NoPublic, bureaucrat, administrator
6,632
edits
Changes
Created page with "One of the geotables need to be included in the table/view that you are exporting and the mandatory column called ''shape''. # Create a SQL view or use one of the existing GI..."
One of the geotables need to be included in the table/view that you are exporting and the mandatory column called ''shape''.
# Create a SQL view or use one of the existing GIS views
# Open the command / DOS prompt
# 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.}}
pgsql2shp -f shape_name -h localhost -u imsma -P password staging
"select * from xxx"
{{NavBox AGOL Extension}}
[[Category:PEW]]
# Create a SQL view or use one of the existing GIS views
# Open the command / DOS prompt
# 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.}}
pgsql2shp -f shape_name -h localhost -u imsma -P password staging
"select * from xxx"
{{NavBox AGOL Extension}}
[[Category:PEW]]
