NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
* xx_polygon
* xx_polyline.
You do not need to include longitude and latitude columns for points in the SQL view since it is the column '''''shape''''' that will be used when creating the shape file.
[[Image:Pg sql2.png|500px|center]]
{{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. <br/>Example: <nowiki>pgsql2shp -f land_polygon -h localhost -u imsma -P password staging " select * from haz_gis_poly where \"Status\" = 'Closed' " </nowiki>}}
[[Image:Pgsql2shp.png|600px|center]]<br/>
<div align="center">
'' The number of rows exported will be shown when the export is done ''
</div>
{{Note | If the Output shape type is '''''Unknown''''' or '''''Null'''''then there is something wrong with the SQL view/table. Most likely the mandatory column ''shape'' is '''not''' included.}}
{{NavBox AGOL Extension}}
[[Category:NAA]]
