You take a look here?<br><a href="http://www.inovagis.org/giserver/epsg.asp">http://www.inovagis.org/giserver/epsg.asp</a><br><br><div><span class="gmail_quote">On 8/19/06, <b class="gmail_sendername">P Kishor</b> <<a href="mailto:punkish@eidesis.org">
punkish@eidesis.org</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Well, after a few hours of bouncing around on websites, and scanning
<br>through rows after rows of similar looking srtext, I give up. I can't<br>figure out the srid, auth_name, auth_srid, and proj4text for the<br>following srtext --<br><br>PROJCS[<br> 'USA_Contiguous_Lambert_Conformal_Conic',
<br> GEOGCS[<br> 'GCS_North_American_1983',<br> DATUM[<br> 'D_North_American_1983',<br> SPHEROID['GRS_1980',6378137.0,298.257222101]<br> ],<br> PRIMEM['Greenwich',0.0],<br> UNIT['Degree',0.0174532925199433
]<br> ],<br> PROJECTION['Lambert_Conformal_Conic'],<br> PARAMETER['False_Easting',0.0],<br> PARAMETER['False_Northing',0.0],<br> PARAMETER['Central_Meridian',-96.0],<br> PARAMETER['Standard_Parallel_1',33.0],<br> PARAMETER['Standard_Parallel_2',
45.0],<br> PARAMETER['Latitude_Of_Origin',39.0],<br> UNIT['Meter',1.0]<br>];<br>-19071146.8131673 -17820932.1267064 61.0351561931566;0 100000;0 100000<br><br>Any help would be much appreciated as it would stop me for committing
<br>harm to my dell.<br><br><br>On 8/19/06, P Kishor <<a href="mailto:punkish@eidesis.org">punkish@eidesis.org</a>> wrote:<br>> Right then. So, I have to insert an entry for my SRS in the<br>> spatial_ref_sys table. Actually, I am surprised something like
<br>> "USA_Contiguous_Lambert_Conformal_Conic" is not already there... I was<br>> assuming this was one of the common USA projections.<br>><br>> In any case, I have the srtext nonsense. How do I "discover" the srid,
<br>> auth_name, auth_srid, and proj4text for it? I am assuming I can't just<br>> make stuff up here.<br>><br>> Follow-up question -- when I am able to add a row to the<br>> spatial_ref_sys table, then what? Do I have to actually transform
<br>> (project) my datasets into this projection, and store them like that,<br>> or do I apply this projection on the fly whenever I do any SQL<br>> operation on them?<br>><br>> On 8/19/06, Dylan Beaudette <
<a href="mailto:dylan.beaudette@gmail.com">dylan.beaudette@gmail.com</a>> wrote:<br>> > ja.<br>> ><br>> > On 8/19/06, P Kishor <<a href="mailto:punkish@eidesis.org">punkish@eidesis.org</a>> wrote:
<br>> > > On 8/19/06, Dylan Beaudette <<a href="mailto:dylan.beaudette@gmail.com">dylan.beaudette@gmail.com</a>> wrote:<br>> > > > Do you have any of the parameters associated with the Lambert<br>
> > > > conformal conic projection? You will need these in order to add an<br>> > > > entry to the spatial_ref_sys table, with a custom SRID.<br>> > ><br>> > > Well, I do have the entire SRTEXT. Is that what you meant?
<br>> > ><br>> > ><br>> > > ><br>> > > > you can get more information on your original file with a tool like ogrinfo .<br>> > > ><br>> > > > Cheers,<br>> > > >
<br>> > > > On 8/19/06, P Kishor <<a href="mailto:punkish@eidesis.org">punkish@eidesis.org</a>> wrote:<br>> > > > > Actually, I should explain this a bit further --<br>> > > > >
<br>> > > > > (a) I had a Shapefile in USA_Lambert_Conformal_Conic that I imported<br>> > > > > into PostGIS using the shp2pgsql, psql dance. Whatever I did, its SRID<br>> > > > > is set to -1.
<br>> > > > ><br>> > > > > (b) I created another dataset from lon/lat explicitly setting its SRID to 4326.<br>> > > > ><br>> > > > > Of course, now I can't do any geometrical analysis on these two
<br>> > > > > because they are in different spatial references. Ideally, I want to<br>> > > > > convert my (b) dataset, the points that are in 4326, to the same srs<br>> > > > > as (a) dataset, namely USA_Lambert_Conformal_Conic.
<br>> > > > ><br>> > > > > Hence my question.<br>> > > > ><br>> > > > > Many thanks in advance.<br>> > > > ><br>> > > > > On 8/19/06, P Kishor <
<a href="mailto:punkish@eidesis.org">punkish@eidesis.org</a>> wrote:<br>> > > > > > This is a topic I know very little about. Where do I learn more about<br>> > > > > > SRIDs, and more specifically,
<br>> > > > > ><br>> > > > > > 1. how do I find SRID for USA_Lambert_Conformal_Conic; and<br>> > > > > > 2. use that to change a dataset (project? is that the word wrt SRIDs?)
<br>> > > > > ><br>><br>><br>> --<br>> Puneet Kishor <a href="http://punkish.eidesis.org/">http://punkish.eidesis.org/</a><br>> Nelson Inst. for Env. Studies, UW-Madison <a href="http://www.ies.wisc.edu/">
http://www.ies.wisc.edu/</a><br>> Open Source Geospatial Foundation <a href="https://edu.osgeo.org/">https://edu.osgeo.org/</a><br>><br><br><br>--<br>Puneet Kishor <a href="http://punkish.eidesis.org/">http://punkish.eidesis.org/
</a><br>Nelson Inst. for Env. Studies, UW-Madison <a href="http://www.ies.wisc.edu/">http://www.ies.wisc.edu/</a><br>Open Source Geospatial Foundation <a href="https://edu.osgeo.org/">https://edu.osgeo.org/</a><br>_______________________________________________
<br>postgis-users mailing list<br><a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br><a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users
</a><br></blockquote></div><br><br clear="all"><br>-- <br>E. Dylan Lorimer<br>Sales Engineer<br>Google Earth Enterprise<br>650.253.2459 (Office)<br>650.862.6810 (Mobile)<br>650.644.0182 (Fax)<br><a href="mailto:edylan@google.com">
edylan@google.com</a>