[postgis-users] data base structure for holding climate data

[Markus Schaber]

Hi, Kirk,

Kirk R. Wythers wrote:

>> I'm assuming also you will do the same for lat lon - store them as
>> postgis geom point types to take advantage of the postgis spatial
>> functions.
> 
> Obe, How is storing lat lon as geom points different from reading them
> into postgis as simple xy coordinates?

You have the full power of PostGIS functions, e. G.

- Intersection with polygons (search all in an area)

- Index-based bbox searching (accellerates the above)

- Projections into other coordinate systems (for map display)

- Aggregates (collect into an multipoint in a GROUP BY query)


and more...

HTH,
Markus

-- 
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in Europe! www.ffii.org
www.nosoftwarepatents.org