NoPublic, bureaucrat, administrator
6,632
edits
Changes
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
{{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]]
