I left the -a_srs out and I no longer have the usage information, but instead I have an error message:
ESRI Shapefile driver failed to create file.shp. The same happens for other spatial tables as well (not necessarily polygons). The table contains only a geometry column. The funny thing is that if I use a script to merge a lot of such tables into one, adding a gid column so that I can distinguish them, using the command I tried in the beginning: pgsql2shp -P [password] -f [shapefile path & name] postgis [tablename] works fine! However it would be stupid to create another script to split the data and deal with this in this way. ________________________________ From: Marco Lechner - FOSSGIS e.V. <[email protected]> To: PostGIS Users Discussion <[email protected]> Sent: Wed, November 17, 2010 12:44:19 PM Subject: Re: [postgis-users] export polygon to shapefile problem - you could leave out the -a_srs for testing - it should be possible to use those table names like W_TQ2575_Buffer by masking the " Marco Am 17.11.2010 13:40, schrieb Thomas Kouk: Hi Marco, > >I tried the sql statement in psql, it works fine, no error message. >There is no error message right above the usage information. >I do not want to reproject, polygon is already in SRID 27700. > >The table's name could be the problem, because in pgadmin sql window or psql >window it needs quotation (""). So I created a new table like the old one, >only >with a simpler name. I tried again, but still with no results: >ogr2ogr -a -f "ESRI Shapefile" file.shp PG:"dbname=postgis host=localhost >user=postgres password=postgres" -sql "SELECT AsBinary(the_geom) as >wkb_geometry >FROM test" >Is there any other way? >Thanks > > > ________________________________ From: Marco Lechner - FOSSGIS e.V. <[email protected]> >To: PostGIS Users Discussion <[email protected]> >Sent: Wed, November 17, 2010 12:07:27 PM >Subject: Re: [postgis-users] export polygon to shapefile problem > >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] >>> http://postgis.refractions.net/mailman/listinfo/postgis-users >>> >> >> >>-- >>Helen San Segundo Navazo >> >> >>http://www.meteo.cat >>Tel. 93 567 60 90 >>Fax 93 567 61 02 >>A/e [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] >>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 >
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
