Changes

PostGIS function pgsql2shp

269 bytes added, 10:25, 11 September 2018

no edit summary

{{Note | The example below is using the ''staging'' area database.}} One of the geotables need to be included in the table/view that you are exporting and the :* xx_point* xx_polygon* xx_polyline. [[Image:Pg sql2.png|500px|center]]<div align="center">The mandatory column to include in the export is called ''shape''.</div>

# Create a SQL view or use one of the existing GIS views

# Run the command ''pgsql2shp'' with the following parameters

:: -f the name of the resulting shape file

:: -h host name If ::: if the Staging area database is on your computer than use ''localhost'':: -u user Use ::: use ''imsma'':: -P password Use ::: use ''password

:: database name

:: SQL view or table name

You may If you would like to export all rows then you refer to the SQL view/table by the name of it .If you would like to export all only some rows OR specify the then you need to add more SQL statementstatements.

{{Note | Any " inside the SQL statement needs to be escaped and therefore it is easier to refer to a SQL view that contains the columns and rows you would like to export.}}

{{Note | If the Output shape type is '''''Unknown''''' then there is something wrong with the SQL view/table. Most likely the mandatory column ''shape'' is '''not''' included.}}

{{NavBox AGOL Extension}}

[[Category:PEWNAA]]

• ← Older edit
• Newer edit →

Alnaucler

NoPublic, bureaucrat, administrator

6,632

edits