<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;">Hi Daniel,<br><br>The GUI is only available for Windows, which I haven't used much for some years now. So I can't help with that aspect. I would assume the GUI has some way for you to enter the same parameters.<br><br>As often as not, I find a GUI is an intermediary between me & the application I want to run. If I know the application well, I often don't want an intermediary, I want to directly control the application myself :-) But there are applications where a GUI is facilitative & useful rather than just a limited menu.<br><br>You can run the commands in the command prompt/DOS shell/Windows Terminal or whatever it is called these days.<br><br>Cheers,<br><br> Brent<br><br><br><br>--- On <b>Sun, 1/1/12, Daniel Montenegro <i><dmontenegro84@gmail.com></i></b> wrote:<br><blockquote style="border-left: 2px solid rgb(16, 16, 255);
margin-left: 5px; padding-left: 5px;"><br>From: Daniel Montenegro <dmontenegro84@gmail.com><br>Subject: Re: [postgis-users] Geographic Coordinates<br>To: pcreso@pcreso.com<br>Date: Sunday, January 1, 2012, 2:54 AM<br><br><div id="yiv1028763279"><div>Thanks again Brent!</div><div> </div><div>Could you explain it a little bit more detailed? I'm using the shp2pgsql-gui (exe) to import shapefiles and there's no need to wright any command... So I don't know where I should wright this specific comand line. Maybe in the PSQL console (pgadmin)?</div>
<div> </div><div>Daniel<br><br></div><div class="yiv1028763279gmail_quote">2011/12/31 <span dir="ltr"><<a rel="nofollow" ymailto="mailto:pcreso@pcreso.com" target="_blank" href="/mc/compose?to=pcreso@pcreso.com">pcreso@pcreso.com</a>></span><br><blockquote style="margin:0px 0px 0px 0.8ex;padding-left:1ex;border-left-color:rgb(204,204,204);border-left-width:1px;border-left-style:solid;" class="yiv1028763279gmail_quote">
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr><td style="font:inherit;font-size-adjust:inherit;font-stretch:inherit;" valign="top">pgsql2shp -s 4326 -I <shapefile> <mytable> | psql -d <mydb><br>
<br>where <br><shapefile> is the name of your shapefile, eg: myfile.shp<br><mytable> is the name of the POstgis table to create & populate<br><mydb> is the name of od the Postgis database (Postgres with Postgis installed)<br>
<br>"-s 4326" tells pgsql to create a table for a shapefile with lat/long geometries, as in<br><a rel="nofollow" target="_blank" href="http://www.spatialreference.org/ref/epsg/4326/">http://www.spatialreference.org/ref/epsg/4326/</a><br>
<br>HTH,<br><br> Brent Wood<br><br>--- On <b>Sat, 12/31/11, Daniel Montenegro <i><<a rel="nofollow" ymailto="mailto:dmontenegro84@gmail.com" target="_blank" href="/mc/compose?to=dmontenegro84@gmail.com">dmontenegro84@gmail.com</a>></i></b> wrote:<br><blockquote style="padding-left:5px;margin-left:5px;border-left-color:rgb(16,16,255);border-left-width:2px;border-left-style:solid;">
<br>From: Daniel Montenegro <<a rel="nofollow" ymailto="mailto:dmontenegro84@gmail.com" target="_blank" href="/mc/compose?to=dmontenegro84@gmail.com">dmontenegro84@gmail.com</a>><br>Subject: [postgis-users] Geographic
Coordinates<br>To: "postgis-users" <<a rel="nofollow" ymailto="mailto:postgis-users@postgis.refractions.net" target="_blank" href="/mc/compose?to=postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>><br>Date: Saturday, December 31, 2011, 4:57 PM<div><div>
</div><div class="yiv1028763279h5"><br><br><div><div>Hi there!</div><div> </div><div>How can I import a shape file with geographic coordinates to PostGIS via shp2pgsql?</div><div> </div><div>Thanks</div><div> </div><div>Daniel</div>
</div><br></div></div>-----Inline Attachment Follows-----<br><br><div>_______________________________________________<br>postgis-users mailing list<br><a rel="nofollow" target="_blank" href="http://mc/compose?to=postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
<a rel="nofollow" target="_blank" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br></div></blockquote></td></tr></tbody></table></blockquote></div>
<br>
</div></blockquote></td></tr></table>