[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