NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
One of the geotables need to be included in the table/view that you are exporting and the mandatory column is called ''shape''.
# Create a SQL view or use one of the existing GIS views
# Go to ''C:\IMSMAng\pgsql\bin''
# Run the command ''pgsql2shp'' with the following parameters
:: -f the name of the resulting shape file:: -h host name If the Staging area database is on your computer than use ''localhost'':: -u user Use ''imsma'':: -P password Use ''password:: database name:: SQL view or table name You may refer to it by the name of if you would like to export all rows OR specify the SQL statement
{{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.}}
[[Image:Pgsql2shp.png|700px|center]]<br/><div align="center">'' The number of rows exported witll be shown when the export is done ''</div>Example: pgsql2shp -f shape_name land_polygon -h localhost -u imsma -P password staging"select * from xxxhaz_gis_poly where \"Status\" = 'Closed' "
{{NavBox AGOL Extension}}
[[Category:PEW]]
