[postgis-users] Issue with the geometry field in postgresql tables

[Curtis W. Ruck]

I ran across this issue with my data set and my solution was converting all the coordinates into one shared srid like WGS84 (EPSG:4326) from the various input coordinates.

----- Original Message ----
From: Vincent J. Troisi <Vincent.Troisi at Colorado.EDU>
To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>; Vincent J. Troisi <vincent.troisi at Colorado.EDU>
Sent: Monday, December 18, 2006 9:13:33 AM
Subject: [postgis-users] Issue with the geometry field in postgresql tables

We want to conduct searches on a table containing a variety of
geometry types. The search returns records that satisfy the
tests for intersection, containment, and overlap. Our DBA
has discovered an issue with using the geometry field; the
field can contain only one geometry definition.

Does anyone have an approach that we can use to query a
spatial field (e.g., geometry) in a table using the standard
functions available in postgis? See below...


>
> Here is the write up for the issue I found out with postGIS 
> yesterday.  The way postgresql handles the geometry column is that you 
> have specify a spatial reference system ID everytime a geometry column 
> is created.  It then uses the spatial reference ID to enforce the rule 
> that every geometry entered into that column matches the spatial 
> reference ID or it will give you an error.  It also allows postGIS to 
> perform convertion on the projections.  This causes the problem 
> because we need to be able to assign different spatial reference ID to 
> different datasets.  With a fixed spatial reference ID assigned to the 
> column, it prevents us from using that the column for datasets that 
> have different spatial reference IDs. 

_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users




-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20061218/862096b3/attachment.html>