[postgis-users] export polygon to shapefile problem

[Marco Lechner - FOSSGIS e.V.]

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 <hsansegundo at meteo.cat>
> *To:* PostGIS Users Discussion <postgis-users at postgis.refractions.net>
> *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
> > postgis-users at postgis.refractions.net
> <mailto:postgis-users at postgis.refractions.net>
> > 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 hsansegundo at meteo.cat <mailto:hsansegundo at meteo.cat>
> <mailto:hsansegundo at meteo.cat <mailto:hsansegundo at meteo.cat>>
>
> 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
> postgis-users at postgis.refractions.net
> <mailto:postgis-users at postgis.refractions.net>
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>   

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20101117/80207dd8/attachment.html>