[postgis-users] export polygon to shapefile problem

Wed Nov 17 04:44:19 PST 2010

- 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. <marco.lechner at fossgis.de>
> *To:* PostGIS Users Discussion <postgis-users at postgis.refractions.net>
> *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 <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
>>   
>
>
>
> _______________________________________________
> 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/4bab513f/attachment.html>