[postgis-users] proj4 error between versions 8.4.2 (works) and 9.1.4 (doesn't work)
I'm getting an error in proj4text in 9.1.4 for our custom projection which works just fine in 8.4.2. when inserting a geom like: INSERT INTO InsertInfoStp(. . . . the_geom, . . . .) VALUES (. . . . ST_Transform (ST_SetSRID (ST_MakePoint (-93.1286,44.9675), 4326), 200068), . . . .) The problem is in the ST_Transform, if I drop it, it succeeds. Can anyone see anything obvious with : srid=200068 auth_name=EPSG auth_srid=200068 srtext=PROJCS[MN Ramsey County,GEOGCS[NAD83 (1986),DATUM[GRS 1980 + MN Ramsey Elevation,SPHEROID[Unknown,6378418.941,298.2572242549219]],PRIMEM[Greenwich,0],UNIT[Degree,0.017453292519943295]], PROJECTION[Lambert_Conformal_Conic_2SP],PARAMETER[standard_parallel_1,45.13],PARAMETER[standard_parallel_2,44.88],PARAMETER[latitude_of_origin,44.79], PARAMETER[central_meridian,-93.383334],PARAMETER[false_easting,50],PARAMETER[false_northing,10],UNIT[Foot_US,0.30480060960121924]] proj4text=+proj=lcc +lat_2=44.88 +lat_1=45.13 +lat_0=44.79 +lon_0=-93.383334 +x_0=152400.3048 +y_0=30480.0610 +units=ft +to_meter=0.30480060960122 +a=6378418.941 +b=6357033.310 +no_defs ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] proj4 error between versions 8.4.2 (works) and 9.1.4 (doesn't work)
Sorry, forgot to add the error: ERROR: AddToPROJ4SRSCache: couldn't parse proj4 string: '+proj=lcc +lat_2=44.88 +lat_1=45.13 +lat_0=44.79 +lon_0=-93.383334 +x_0=152400.3048 +y_0=30480.0610 +units=ft +to_meter=0.30480060960122 +a=6378418.941 +b=6357033.310 +no_defs': projection not named ** Error ** ERROR: AddToPROJ4SRSCache: couldn't parse proj4 string: '+proj=lcc +lat_2=44.88 +lat_1=45.13 +lat_0=44.79 +lon_0=-93.383334 +x_0=152400.3048 +y_0=30480.0610 +units=ft +to_meter=0.30480060960122 +a=6378418.941 +b=6357033.310 +no_defs': projection not named SQL state: XX000 From: postgis-users-boun...@postgis.refractions.net [postgis-users-boun...@postgis.refractions.net] on behalf of Basques, Bob (CI-StPaul) [bob.basq...@ci.stpaul.mn.us] Sent: Tuesday, June 26, 2012 9:51 AM To: postgis-users@postgis.refractions.net Subject: [postgis-users] proj4 error between versions 8.4.2 (works) and 9.1.4 (doesn't work) I'm getting an error in proj4text in 9.1.4 for our custom projection which works just fine in 8.4.2. when inserting a geom like: INSERT INTO InsertInfoStp(. . . . the_geom, . . . .) VALUES (. . . . ST_Transform (ST_SetSRID (ST_MakePoint (-93.1286,44.9675), 4326), 200068), . . . .) The problem is in the ST_Transform, if I drop it, it succeeds. Can anyone see anything obvious with : srid=200068 auth_name=EPSG auth_srid=200068 srtext=PROJCS[MN Ramsey County,GEOGCS[NAD83 (1986),DATUM[GRS 1980 + MN Ramsey Elevation,SPHEROID[Unknown,6378418.941,298.2572242549219]],PRIMEM[Greenwich,0],UNIT[Degree,0.017453292519943295]], PROJECTION[Lambert_Conformal_Conic_2SP],PARAMETER[standard_parallel_1,45.13],PARAMETER[standard_parallel_2,44.88],PARAMETER[latitude_of_origin,44.79], PARAMETER[central_meridian,-93.383334],PARAMETER[false_easting,50],PARAMETER[false_northing,10],UNIT[Foot_US,0.30480060960121924]] proj4text=+proj=lcc +lat_2=44.88 +lat_1=45.13 +lat_0=44.79 +lon_0=-93.383334 +x_0=152400.3048 +y_0=30480.0610 +units=ft +to_meter=0.30480060960122 +a=6378418.941 +b=6357033.310 +no_defs ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] proj4 error between versions 8.4.2 (works) and 9.1.4 (doesn't work)
Geez, I think I need to slow down some. I figured out it would probably be more pertinent to list the POSTGIS version instead of PostGres. proj4 parsing error in : POSTGIS=1.5.3 GEOS=3.3.3-CAPI-1.7.4 PROJ=Rel. 4.8.0, 6 March 2012 LIBXML=2.7.8 USE_STATS the INSERT works fine in: POSTGIS=1.4.1 GEOS=3.2.0-CAPI-1.6.0 PROJ=Rel. 4.7.1, 23 September 2009 USE_STATS I used the same creation statement in both DB's for the custom projection. bobb From: postgis-users-boun...@postgis.refractions.net [postgis-users-boun...@postgis.refractions.net] on behalf of Basques, Bob (CI-StPaul) [bob.basq...@ci.stpaul.mn.us] Sent: Tuesday, June 26, 2012 9:52 AM To: PostGIS Users Discussion Subject: Re: [postgis-users] proj4 error between versions 8.4.2 (works) and 9.1.4 (doesn't work) Sorry, forgot to add the error: ERROR: AddToPROJ4SRSCache: couldn't parse proj4 string: '+proj=lcc +lat_2=44.88 +lat_1=45.13 +lat_0=44.79 +lon_0=-93.383334 +x_0=152400.3048 +y_0=30480.0610 +units=ft +to_meter=0.30480060960122 +a=6378418.941 +b=6357033.310 +no_defs': projection not named ** Error ** ERROR: AddToPROJ4SRSCache: couldn't parse proj4 string: '+proj=lcc +lat_2=44.88 +lat_1=45.13 +lat_0=44.79 +lon_0=-93.383334 +x_0=152400.3048 +y_0=30480.0610 +units=ft +to_meter=0.30480060960122 +a=6378418.941 +b=6357033.310 +no_defs': projection not named SQL state: XX000 From: postgis-users-boun...@postgis.refractions.net [postgis-users-boun...@postgis.refractions.net] on behalf of Basques, Bob (CI-StPaul) [bob.basq...@ci.stpaul.mn.us] Sent: Tuesday, June 26, 2012 9:51 AM To: postgis-users@postgis.refractions.net Subject: [postgis-users] proj4 error between versions 8.4.2 (works) and 9.1.4 (doesn't work) I'm getting an error in proj4text in 9.1.4 for our custom projection which works just fine in 8.4.2. when inserting a geom like: INSERT INTO InsertInfoStp(. . . . the_geom, . . . .) VALUES (. . . . ST_Transform (ST_SetSRID (ST_MakePoint (-93.1286,44.9675), 4326), 200068), . . . .) The problem is in the ST_Transform, if I drop it, it succeeds. Can anyone see anything obvious with : srid=200068 auth_name=EPSG auth_srid=200068 srtext=PROJCS[MN Ramsey County,GEOGCS[NAD83 (1986),DATUM[GRS 1980 + MN Ramsey Elevation,SPHEROID[Unknown,6378418.941,298.2572242549219]],PRIMEM[Greenwich,0],UNIT[Degree,0.017453292519943295]], PROJECTION[Lambert_Conformal_Conic_2SP],PARAMETER[standard_parallel_1,45.13],PARAMETER[standard_parallel_2,44.88],PARAMETER[latitude_of_origin,44.79], PARAMETER[central_meridian,-93.383334],PARAMETER[false_easting,50],PARAMETER[false_northing,10],UNIT[Foot_US,0.30480060960121924]] proj4text=+proj=lcc +lat_2=44.88 +lat_1=45.13 +lat_0=44.79 +lon_0=-93.383334 +x_0=152400.3048 +y_0=30480.0610 +units=ft +to_meter=0.30480060960122 +a=6378418.941 +b=6357033.310 +no_defs ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users