Re: [mapguide-users] shp2pgsql
Follow the steps, set environment varabel for shp2pgsql.ex(i think it is in programme files -postgresql-bin).so please set enviranment varable for bin folder of above given path. and once that done open command prompt - write command as and goes to the set the shapefile path and write below command shp2pgsql -s 3000 test.shp test test.sql 3000 will be your SRID test is your table name which supposed to be insert into your postgresql database.. then test.sql will be stored in your setted path(shapefile path). then run the same sql file from querybuilder in postgresql.. Let me know if you have problems Regards, Venkat Tammineni CroNicoRn wrote: Hai all Now I wanna try convert shp to pgsql.. SO anyone can teach me step by step .. how i wanna do it.. because i want try intergrate mapguide open source witg pgrouting.. Thanx -- View this message in context: http://n2.nabble.com/shp2pgsql-tp1818379p3775007.html Sent from the MapGuide Users mailing list archive at Nabble.com. ___ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users
Re: [mapguide-users] shp2pgsql
1- open command window from startruncmd , then by command cd open the fillowing path C:\Program Files\PostgreSQL\8.3\bin and make sure that in this path executable file called shp2pgsql.exe http://n2.nabble.com/file/n3760302/untitled.bmp 2-Now You can load shapefile into PostGIS Shp2pgsql.exe –I –D d:\shapes\stations.shp stations | psql postgis postgres • Command Name: Shp2pgsql.exe • Command Options : -I –D (that is a captial ‘i’) This means create a spatial index Load using dump format (faster) • The path to the shape file • The table name to load the file into. •The pipe (|): send the output of shp2pgsql to psql • Psql : the command line sql client for PostgreSQL • Postgis: the database you want to load the shape file into. • Postgres: the username to connect to the database with. - http://gsg-eg.com http://n2.nabble.com/file/u111068/head2.jpg GeoService -- View this message in context: http://n2.nabble.com/shp2pgsql-tp1818379p3760302.html Sent from the MapGuide Users mailing list archive at Nabble.com. ___ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users
Re: [mapguide-users] shp2pgsql
http://man.cx/shp2pgsql(1) Gabriele On Mon, Nov 17, 2008 at 09:26, ajid1980 [EMAIL PROTECTED] wrote: Hai all Now I wanna try convert shp to pgsql.. SO anyone can teach me step by step .. how i wanna do it.. because i want try intergrate mapguide open source witg pgrouting.. Thanx -- View this message in context: http://www.nabble.com/shp2pgsql-tp20535434p20535434.html Sent from the MapGuide Users mailing list archive at Nabble.com. ___ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users ___ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users
[mapguide-users] shp2pgsql
Hai all Now I wanna try convert shp to pgsql.. SO anyone can teach me step by step .. how i wanna do it.. because i want try intergrate mapguide open source witg pgrouting.. Thanx -- View this message in context: http://www.nabble.com/shp2pgsql-tp20535434p20535434.html Sent from the MapGuide Users mailing list archive at Nabble.com. ___ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users
Re: [ZS2] [mapguide-users] shp2pgsql
Have you tried FDO Toolbox: http://code.google.com/p/fdotoolbox/ Or fdo2fdo: http://www.sl-king.com/Fdo2Fdo/download/download.html Regards, Kenneth Skovhede, GEOGRAF A/S ajid1980 skrev: Hai all Now I wanna try convert shp to pgsql.. SO anyone can teach me step by step .. how i wanna do it.. because i want try intergrate mapguide open source witg pgrouting.. Thanx ___ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users