[postgis-users] SRID 32767 or 4326

[Guido Lemoine]

Regina,

I guess you're right. In my version 1.2 spatial_ref_sys, the last 
"valid" EPSG entry is 32766.
Beyond that, I have entries that are related to ogr2ogr imports (mostly 
from shape files in UTM
projection). I actually use XSLT to upload KML, so don't have the 
longlat projection in my
list.

So, yes, seems like an artifact.

Thanks,

GL

Obe, Regina wrote:
> 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