try C:\Program Files\FWTools2.4.7\bin>ogr2ogr -a srs "EPSG:27700" ...
Does your sql-statemnet produce a result when executed within psql? Are you sure there's no error message right above the usage information? Do you want to reproject to 27700? Then you should use -t_srs Marco Am 17.11.2010 12:56, schrieb Thomas Kouk: > Thanks Helen, > I've been trying to make it work. I don't have ogr2ogr.exe somewhere > in PostgreSQL folder. The only place where I have ogr2ogr.exe is in > FWTools folder, (other ones in OSGeo4W do not work, dll problems). > So I try this: > > C:\Program Files\FWTools2.4.7\bin> ogr2ogr -a srs EPSG:27700 -f "ESRI > Shapefile" file.shp PG:"dbname=postgis host=localhost user=postgres > password=postgres" -sql "SELECT AsBinary(the_geom) as wkb_geometry > FROM W_TQ2575_Buffer" > After this I do not get any error message, but I get the ogr2ogr usage > information (as if something I typed is wrong) and the file.shp is not > created (cannot be found anywhere). > Any help? > > ------------------------------------------------------------------------ > *From:* Helen San Segundo Navazo <[email protected]> > *To:* PostGIS Users Discussion <[email protected]> > *Sent:* Wed, November 17, 2010 9:29:15 AM > *Subject:* Re: [postgis-users] export polygon to shapefile problem > > Hi Thomas, > > I use the next expression to export data automatically in an script > from a table with polygons into a shape file: > > > ogr2ogr -a_srs EPSG:23031 -f "ESRI Shapefile" file.shp > PG:"dbname=db_name host=the_host user=the_user password=the_password" > -sql "SELECT AsBinary(the_geometry_column) as wkb_geometry, > column2,column3,column4 etc. FROM table where conditions" > > I hope this will help you, > Helen > > > Thomas Kouk escribió: > > > > Hi all, > > > > I am newbie in PostGIS and I have a problem exporting a polygon > table in shp. I want to export specific spatial tables from by > database using a batch procedure (bat file). The command I use is: > > > > pgsql2shp -P [password] -f [shapefile path & name] postgis > [tablename], for example: pgsql2shp -P postgres -f Data\Buffers\ > Buffer.shp postgis buffer_table > > > > It works fine with all other spatial tables (linestring or > multilinestring type). For polygons it also seems to work, as I get no > error message: > > > > / Initializing... Done (postgis major version: 1)./ > > > > / Output shape: Polygon/ > > > > / Dumping: XX [1 rows]./ > > > > However, when I try to load the polygon shp in Qgis or ArcGIS I get > an error: ArcGIS cannot open the file, while QGIS loads the shp but > displays nothing (as if the table is empty, which is not the case). > > > > All my tables are spatial tables with no information on > geometry_columns table, but even if I add the polygon table in the > geometry_columns, nothing changes. After all, the function works with > all other spatial non polygon tables despite the fact that > geometry_columns holds no information on them, so this is not the problem. > > > > I can load the postgis polygon table in qgis and export it manually > to a shp, which works fine, but I need to do it in an automatic way > using a command. > > > > Has anyone come to this problem or is there something I do not know > about exporting polygon tables to shp? > > > > Thanks. > > > > > > ------------------------------------------------------------------------ > > > > _______________________________________________ > > postgis-users mailing list > > [email protected] > <mailto:[email protected]> > > http://postgis.refractions.net/mailman/listinfo/postgis-users > > > > > -- > Helen San Segundo Navazo > > > http://www.meteo.cat <http://www.meteo.cat/> > Tel. 93 567 60 90 > Fax 93 567 61 02 > A/e [email protected] <mailto:[email protected]> > <mailto:[email protected] <mailto:[email protected]>> > > Abans d’imprimir aquest correu, assegureu-vos que és del tot > necessari. El medi ambient és cosa de tothom! > > La informació d'aquesta transmissió electrònica és confidencial i el > seu ús sols està permès als seus destinataris. Si Vostè no és la > persona destinatària d'aquesta transmissió electrònica, li preguem que > ens ho comuniqui de forma immediata i destrueixi qualsevol copia de la > mateixa (tant digital com en paper). > > _______________________________________________ > postgis-users mailing list > [email protected] > <mailto:[email protected]> > http://postgis.refractions.net/mailman/listinfo/postgis-users > > > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
