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