[postgis-users] Raster data questions

[George Merticariu]

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 <remi.cura at gmail.com> 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 <merticariug at gmail.com>:
>
>> 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
>> postgis-users at lists.osgeo.org
>> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>



-- 
George Merticariu

Jacobs University Bremen
B.Sc. Computer Science
Class of 2014

g.merticariu at jacobs-university.de
merticariug at gmail.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20141202/25775201/attachment.html>