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
