On 18 July 2012 07:19, Peter Tittmann <ptittm...@gmail.com> wrote: > Seems a little strange that spatialreference.org would produce an invalid > insert statement. Regardless, thanks for the pointer.
Personally, I feel that spatialreference.org is a bit broke (but otherwise an excellent resource!). Firstly, it is broke with respect to the current version of PostGIS, where their SRID > MAX_SRID, thus invalid. Secondly, their SRIDs are probably internal representations in their database, so they have really peculiar codes. For instance, if one were to use the definition of EPSG:4326 from http://spatialreference.org/ref/epsg/4326/postgis/ they wound need to use SRID=94326 to encode geometries, which is really odd and could raise some unexpected behaviour if it were converted to a geography type. So in general, try to set srid the same as auth_srid. -Mike _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
