Is this what you're looking for?
http://spatialreference.org/ref/epsg/102671/
It looks like there is now an output format for "PostGIS spatial_ref_sys
INSERT statement". I'm not sure if it's what you need, but it might be
worth a look.
Jason
Thanks, that kinda did, it reminded me of something I had seen before, but I
didn't know what it was used for. I know see that this inserts the required
parameters into the spatial_ref_table.
The link you sent me to didn't quite work. It returned no error message but no
rows were created. I was able to use the code I found here though:
http://jc.desconnets.free.fr/mdweb/install/proj/srid.sql
which was:
INSERT INTO "spatial_ref_sys" ("srid", "auth_name", "auth_srid", "srtext",
"proj4text")
VALUES (102671, 'ESRI', 102671,
'PROJCS[\"NAD_1983_StatePlane_Illinois_East_FIPS_1201_Feet\",GEOGCS[\"GCS_North_American_1983\",DATUM[\"D_North_American_1983\",SPHEROID[\"GRS_1980\",6378137,298.257222101]],PRIMEM[\"Greenwich\",0],UNIT[\"Degree\",0.017453292519943295]],PROJECTION[\"Transverse_Mercator\"],PARAMETER[\"False_Easting\",984249.9999999999],PARAMETER[\"False_Northing\",0],PARAMETER[\"Central_Meridian\",-88.33333333333333],PARAMETER[\"Scale_Factor\",0.999975],PARAMETER[\"Latitude_Of_Origin\",36.66666666666666],UNIT[\"Foot_US\",0.30480060960121924]]',
'+proj=tmerc +lat_0=36.66666666666666 +lon_0=-88.33333333333333 +k=0.999975 +x_0=300000 +y_0=0 +ellps=GRS80 +datum=NAD83 +to_meter=0.3048006096012192');
and that seems to have worked.
I don't know if that is of any interest.
Thanks for your help and thanks to this board in general for being quite
friendly and useful. I have been on other open-source boards that seem to make
it a priority to make newbies feel stupid.
Ryan
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
