[postgis-users] Raster data questions

[Rémi Cura]

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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20141125/4e75d025/attachment.html>