ogr2ogr is what I would use to do this in one step. shp2pgsql can only define a projection, not do a reprojection.<br><br>David<br><br><div class="gmail_quote">On Mon, Apr 6, 2009 at 10:31 AM, Todd Fagin <span dir="ltr"><<a href="mailto:tfagin@coordinatesolutions.com">tfagin@coordinatesolutions.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div link="blue" vlink="purple" lang="EN-US">
<div>
<p><font size="2" face="Trebuchet MS"><span style="font-size: 10pt; font-family: "Trebuchet MS";">Greetings,</span></font></p>
<p><font size="2" face="Trebuchet MS"><span style="font-size: 10pt; font-family: "Trebuchet MS";"> </span></font></p>
<p><font size="2" face="Trebuchet MS"><span style="font-size: 10pt; font-family: "Trebuchet MS";">I have a pretty general question about
reprojecting a shapefile on import into PostGIS. For instance, if I have
a shapefile in EPSG <font color="black"><span style="color: black;">32125, but I
want it imported into PostGIS as EPSG 4326. Is there a way to do this using
shp2pgsql (or other utility) <i><span style="font-style: italic;">prior </span></i>to
importing. I am guessing this can be done be done ogr2ogr (</span></font>-t_srs)<font color="black"><span style="color: black;">, but was curious if there were other
methods.</span></font></span></font></p>
<p><font color="black" size="2" face="Trebuchet MS"><span style="font-size: 10pt; font-family: "Trebuchet MS"; color: black;"> </span></font></p>
<p><font color="black" size="2" face="Trebuchet MS"><span style="font-size: 10pt; font-family: "Trebuchet MS"; color: black;">Thanks,</span></font><font size="2" face="Trebuchet MS"><span style="font-size: 10pt; font-family: "Trebuchet MS";"></span></font></p>
<p><font size="2" face="Trebuchet MS"><span style="font-size: 10pt; font-family: "Trebuchet MS";"> </span></font></p>
<p><font color="navy" size="2" face="Trebuchet MS"><span style="font-size: 10pt; font-family: "Trebuchet MS"; color: navy;">Todd Fagin</span></font><font color="navy"><span style="color: navy;"></span></font></p>
<p><font color="navy" size="3" face="Times New Roman"><span style="font-size: 12pt; color: navy;"> </span></font></p>
<p><font color="navy" size="2" face="Trebuchet MS"><span style="font-size: 10pt; font-family: "Trebuchet MS"; color: navy;">Coordinate
Solutions, Inc.</span></font><font color="navy"><span style="color: navy;"></span></font></p>
<p><font color="navy" size="2" face="Trebuchet MS"><span style="font-size: 10pt; font-family: "Trebuchet MS"; color: navy;">2804 NW 18th St.</span></font><font color="navy"><span style="color: navy;"></span></font></p>
<p><font color="navy" size="2" face="Trebuchet MS"><span style="font-size: 10pt; font-family: "Trebuchet MS"; color: navy;">Oklahoma City,
OK 73107</span></font><font color="navy"><span style="color: navy;"></span></font></p>
<p><font color="navy" size="2" face="Trebuchet MS"><span style="font-size: 10pt; font-family: "Trebuchet MS"; color: navy;">405.740.4324
(voice)</span></font><font color="navy"><span style="color: navy;"></span></font></p>
<p><font color="navy" size="2" face="Trebuchet MS"><span style="font-size: 10pt; font-family: "Trebuchet MS"; color: navy;">904.471.5548
(fax)</span></font><font color="navy"><span style="color: navy;"></span></font></p>
<p><font color="navy" size="2" face="Trebuchet MS"><span style="font-size: 10pt; font-family: "Trebuchet MS"; color: navy;"><a href="http://www.coordinatesolutions.com" target="_blank">www.coordinatesolutions.com</a></span></font></p>
<p><font color="navy" size="2" face="Trebuchet MS"><span style="font-size: 10pt; font-family: "Trebuchet MS"; color: navy;"> </span></font></p>
<p><font color="navy" size="2" face="Arial"><span style="font-size: 10pt; font-family: Arial; color: navy;"> </span></font></p>
<p><font size="3" face="Times New Roman"><span style="font-size: 12pt;"> </span></font></p>
</div>
</div>
<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" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br>************************************<br>David William Bitner<br>