Hello! Thank you for your answer!
Please find below more information: The type of data which I will insert is an 1D array of values between 0 and 255. This array should be mapped to different dimensions: 1D - grey string 2D - grey image 3d - grey cube There will be a lot of reads from the arrays and only one write at insert. The size of the array will be kept constant and will be given by the file size. Is there a way to import directly the 1D binary file into arrays of higher dimensions or do I need to convert it first and then import it? Best, George On Tue, Nov 25, 2014 at 5:56 PM, Rémi Cura <[email protected]> wrote: > Hey, > you don't even need postgis for this, you could store a cube per line, > with a x,y,z number, indexes on it,then querry like > SELECT * > FROM my_cube_table > WHERE x BETWEEN 100 AND 200 > AND y BETWEEN 23 AND 45 > AND z BETWEEN 45 AND 67 > You could alos use postgres range type. > Of course you could store cube as meshes, and use pure 3D function > (postgis so ) > etc etc > > It is very hard to answer you if you don't explain what you want to do > with this cubes , how many you will have, ifyou read it more or write it > more, what kind of data it contains, if the size of each cube may change, > if you want to convert this to geo types ... > > Cheers, > Rémi-C > > 2014-11-25 17:32 GMT+01:00 George Merticariu <[email protected]>: > >> Hello! >> >> I want to use PostGIS for handling 3D cubes but I couldn't figure out how >> to do it from the manual. >> >> The main tasks I want to accomplish are: >> >> 1. Import a 1D char array file (grey cube) into a 3D cube. >> 2. Retrieve sections from the cube, where a section is defined by a >> domain. >> >> Example: >> >> Given a file of 1024*1024*1024 bytes, I want to import it into a cube >> with the domain [0:1023, 0:1023, 0:1023]. Then, select the sub-domains >> (examples): >> >> - [100:200, 100:200, 0:100] >> - [0:1, 0:1023, 0:1023] >> >> >> Is this possible using PostiGIS? If yes, are there any detailed tutorials >> which explain how to do that? >> >> Thank you! >> >> Best regards, >> George Merticariu >> >> >> _______________________________________________ >> postgis-users mailing list >> [email protected] >> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users >> > > > _______________________________________________ > postgis-users mailing list > [email protected] > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users > -- George Merticariu Jacobs University Bremen B.Sc. Computer Science Class of 2014 [email protected] [email protected]
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
