PostGIS - store 2D elevation data

[المشرف العام]

I am new to PostGIS. How can I store 2D elevation data? I have uniform raster and for every [x,y], height is set. I want to be able to use this in my queries (something like SELECT height FROM data WHERE index = [10, 15]). I also need to write this data from my C++ application (it is not earth elevation data, it is some "planet" surface, that will be modified) and data retrieval must be realtime to be used on website.

So far I have come up with 2 ideas:

1. Use geometry and store 3D data 2)
2. Create "2D table" with N columns and N rows (not PostGIS, but classic Postgre solution)

I also looked for raster data using GDAL, but that solution didnt looked very fast and flexible.

Any better ideas or ways how this should be solved?

My data are approx. 3000x1500



أكثر...