Search Postgresql Archives

Storing data on a regular lat/lon grid

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi all,

I have temperature data that has been interpolated to a regular lat/lon grid. I have one grid per day.

I want to be able to select points within a certain region, and within a certain time period.

Now, I could store each grid point as a separate record (a new row for every single point/time, with columns lat, lon, time, temperature), but since my grid is constant, there's a lot of redundancy there, no? Disk space is somewhat of a constraint, since there are a lot of files.

Basically, has anyone done any work with storing gridded spatial data? I see lot's of info on Geospatial data, but it's usually cities, stations, etc., not a regular grid that doesn't change...

I also noticed that PostGIS does not support raster data...

Thanks a lot,

--
Mike

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux