[postgis-users] newbie question about geometry

Vincent J. Troisi Vincent.Troisi at Colorado.EDU
Fri Sep 15 08:35:30 PDT 2006


I have some geospatial data I'd like to store  in postgresql and
use postgis operations on the data. The  records  contain  many 
attributes, but
the geometry is defined by 4 corner points (latitude in degrees from -90 
to 90
and longitude in degrees from 0 to 360) with lines between the points as
great circle arcs. I want to create spatial queries based on 4 or more 
point polygons
of any projection that will enable me to test whether the polygon stored
in the database overlaps (contains, overlaps or intersects) the polygon of
the query.

Questions:
    Can I store longitudes as 0-360 or do I need to use the range -180 
to 180?
    Does anyone have an example for establishing such a table and
    a sample of a query for this implementation...or point me to such 
examples.







More information about the postgis-users mailing list