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:
- Use geometry and store 3D data 2)
- Create "2D table" with N columns and N rows (not PostGIS, but classic Postgre solution)
Any better ideas or ways how this should be solved?
My data are approx. 3000x1500