NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
[[Image:Pg sql2.png|500px|center]]
<div align="center">
The mandatory column to include in the export is called ''shape''
</div>
<ol>
<li> Create a SQL view or use one of the existing GIS views
<li> Open the command / DOS prompt
<li> Go to ''C:\IMSMAng\pgsql\bin''
<li> 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
<li> The export files are created in ''C:\IMSMAng\pgsql\bin'' (dbf, prj, shp and shx)
</ol>
If you would like to export all rows then you only need to refer to the SQL view/table by the name of it.<br/>
If you would like to export only some of the rows then you need to add 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. <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]]
<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:PEWNAA]]
