[postgis-users] SRID 32767 or 4326

Obe, Regina robe.dnd at cityofboston.gov
Wed Feb 6 06:51:39 PST 2008

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

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,

-----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 
data using (GDAL) ogr2ogr. This gets loaded in a table which has it's
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

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


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
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
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.

More information about the postgis-users mailing list