[postgis-users] srid for NAD83 State Plane Illinois East US Foot

[Ryan D. Enos]

>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