[postgis-users] SRID 32767 or 4326

[Obe, Regina]

I suspect what you are experiencing is that OGR is generating a new
spatial ref record because it can't find what it is looking for in the
list.

For example 32767 doesn't exist in my spatial_ref_sys table and ends at
32766, so I suspect both examples you have are OGR spatial ref creations
at different points in time and have nothing to do with your upgrade.

SELECT UpdateGeometrySRID('public', 'yourtablenamehere',
'yourcolumnnamehere', 4236);

To correct the problem.

Hope that helps,
Regina
 

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
Guido Lemoine
Sent: Wednesday, February 06, 2008 9:33 AM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] SRID 32767 or 4326

Dear All,

My colleague installed postgis 1.3 recently. He then inserted some KML 
polygon
data using (GDAL) ogr2ogr. This gets loaded in a table which has it's
SRID
set to 32767.

In the 1.3 version of the spatial_ref_sys table, SRID=32767 is defined
as a
longlat projection.

In MY 1.2 version of spatial_ref_sys, SRID=32767 is defined as a UTM
zone 42N projection (WGS84). I use SRID=4326 for longlat projection,
which has worked fine until now (I export features as KML for Google
Earth).

Is this something I have to worry about (esp. when upgrading)?

GL

-- 
----------------------------------------------------------------
Guido Lemoine
Joint Research Centre, European Commission
Institute for the Protection and Security of the Citizen (IPSC)
Support to External Security
Via E. Fermi, 2749 TP 267 Ispra 21027 (VA), Italy
Tel. +39 0332 786239 (direct line) Fax. +39 0332 785154
WWW: http://ses.jrc.it
----------------------------------------------------------------
Disclaimer:
Views expressed are those of the individual and do not represent 
the views of the European Commission


_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
-----------------------------------------
The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure
pursuant to Massachusetts law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and delete the material from any computer.