id,summary,reporter,owner,description,type,status,priority,milestone,component,version,severity,resolution,keywords,cc 2123,"use the ""auth_srid"" to avoid mismatches between OGR and PostGIS WKTs of EPSG codes",msieczka,Even Rouault,"To avoid mismatches between OGR's EPSG->WKT and PostGIS's ""srtext"" strings due to formatting differences, look-up the ""spatial_ref_sys"" table for ""auth_srid"" equal to the EPSG code requested, check if ""auth_name"" is ""EPSG"", and use the ""auth_srid"" value then. That would guarantee that a correct EPSG code is used; see: {{{ SELECT srid,auth_name,auth_srid FROM spatial_ref_sys WHERE auth_srid=2180; srid | auth_name | auth_srid ------+-----------+----------- 2180 | EPSG | 2180 }}} Some more details in discussion at [1]. [1]http://thread.gmane.org/gmane.comp.gis.gdal.devel/10433/focus=13927 ",enhancement,closed,normal,1.5.2,OGR_SF,1.5.0 betas/RCs,normal,fixed,postgis pg,warmerdam project10 Jeff McKenna