[postgis-users] OGR2OGR srid being ignored

[Sufficool, Stanley]

Per OGR2OGR docs:
	
	... or a well known definition (ie. EPSG:4326) 

Per http://spatialreference.org/ref/epsg/?search=NAD83

	EPSG:2229: NAD83 / California zone 5 (ftUS) 

I'm assuming that the fix to GDAL that was previously posted allows this
notation now.

> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net 
> [mailto:postgis-users-bounces at postgis.refractions.net] On 
> Behalf Of Frank Warmerdam
> Sent: Thursday, July 10, 2008 11:18 AM
> To: PostGIS Users Discussion
> Subject: Re: [postgis-users] OGR2OGR srid being ignored
> 
> 
> Sufficool, Stanley wrote:
> > I import / synchronize data from ARC/INFO coverage files 
> frequently. I
> > use the following command to pull in the data for our 
> intranet mapping 
> > server, but it does not seem to honor the SRID arguments 
> and places all 
> > geometries with SRID = 32767. I have tried every combination of  
> > -*_srs args to no avail.  What am I missing here?
> >  
> >  
> > ogr2ogr -overwrite -f PostgreSQL PG:\"host=<host> dbname=postgis
> > user=postgres password=<iwonttell>" 
/mnt/gis/covers/precinct pal -nln 
> > precinct_tmp -s_srs EPSG:2229 -a_srs EPSG:2229 -t_srs 
> EPSG:2229  -lco 
> > PRECISION=no
> 
> Stanley,
> 
> The EPSG codes are not PostGIS SRIDs!  Internally OGR expands 
> these requests into WKT and then it does a check against the 
> spatial_ref_sys table to see if it finds an exact match. If 
> not, it creates a new spatial_ref_sys entry.
> 
> It takes surprisingly minor differences in the coordinate 
> system definition (such as subtle rounding errors in some 
> parameters) to cause matches to fail.
> 
> It has een my intent to add a layer creation option to force 
> selection of a particular SRID for the PG driver, but 
> apparently this has not been implemented.  So, basically, you 
> have no way to force use of a particular SRID now.
> 
> Best regards,
> 
> -- 
> ---------------------------------------+----------------------
> ----------
> ---------------------------------------+------
> I set the clouds in motion - turn up   | Frank Warmerdam, 
> warmerdam at pobox.com
> light and sound - activate the windows | http://pobox.com/~warmerdam
> and watch the world go round - Rush    | President OSGeo, 
> http://osgeo.org
> 
> _______________________________________________
> postgis-users mailing list postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>