PostGIS function pgsql2shp - Revision history

Alnaucler at 15:13, 11 September 2018

2018-09-11T15:13:43Z

← Older revision		Revision as of 17:13, 11 September 2018
Line 5:		Line 5:
	* xx_polygon		* xx_polygon
	* xx_polyline.		* 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]]		[[Image:Pg sql2.png\|500px\|center]]
Line 36:		Line 39:
	</div>		</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.}}		{{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}}		{{NavBox AGOL Extension}}
	[[Category:NAA]]		[[Category:NAA]]

Alnaucler at 12:23, 11 September 2018

2018-09-11T12:23:36Z

← Older revision		Revision as of 14:23, 11 September 2018
Line 31:		Line 31:
	{{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>}}		{{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/>~~		[[Image:Pgsql2shp.png\|600px\|center]]
	<div align="center">		<div align="center">
	'' The number of rows exported will be shown when the export is done ''		'' The number of rows exported will be shown when the export is done ''

Alnaucler at 12:22, 11 September 2018

2018-09-11T12:22:46Z

← Older revision		Revision as of 14:22, 11 September 2018
Line 10:		Line 10:
	The mandatory column to include in the export is called ''shape''		The mandatory column to include in the export is called ''shape''
	</div>		</div>
			<ol>
	# Create a SQL view or use one of the existing GIS views		<li> Create a SQL view or use one of the existing GIS views
	# Open the command / DOS prompt		<li> Open the command / DOS prompt
	# Go to ''C:\IMSMAng\pgsql\bin''		<li> Go to ''C:\IMSMAng\pgsql\bin''
	# Run the command ''pgsql2shp'' with the following parameters		<li> Run the command ''pgsql2shp'' with the following parameters
	:: -f the name of the resulting shape file		:: -f the name of the resulting shape file
	:: -h host name		:: -h host name
Line 24:		Line 24:
	:: database name		:: database name
	:: SQL view or table name		:: SQL view or table name
			<li> The export files are created in ''C:\IMSMAng\pgsql\bin'' (dbf, prj, shp and shx)
	If you would like to export all rows then you refer to the SQL view/table by the name of it.<br/>		</ol>
	If you would like to export only some rows then you need to add ~~more~~ SQL ~~statements~~.		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>}}		{{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>}}

Alnaucler at 12:17, 11 September 2018

2018-09-11T12:17:57Z

← Older revision		Revision as of 14:17, 11 September 2018
Line 25:		Line 25:
	:: SQL view or table name		:: SQL view or table name

	If you would like to export all rows then you refer to the SQL view/table by the name of it.		If you would like to export all rows then you refer to the SQL view/table by the name of it.<br/>
	If you would like to export only some rows then you need to add more SQL statements.		If you would like to export only some rows then you need to add more SQL statements.

	{{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 \| 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/>		[[Image:Pgsql2shp.png\|600px\|center]]<br/>
Line 34:		Line 34:
	'' The number of rows exported will be shown when the export is done ''		'' The number of rows exported will be shown when the export is done ''
	</div>		</div>
	~~Example: pgsql2shp -f land_polygon -h localhost -u imsma -P password staging " select * from haz_gis_poly where \"Status\" = 'Closed' "~~

	{{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.}}		{{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}}		{{NavBox AGOL Extension}}
	[[Category:NAA]]		[[Category:NAA]]

Alnaucler at 12:14, 11 September 2018

2018-09-11T12:14:06Z

← Older revision		Revision as of 14:14, 11 September 2018
Line 36:		Line 36:
	Example: pgsql2shp -f land_polygon -h localhost -u imsma -P password staging " select * from haz_gis_poly where \"Status\" = 'Closed' "		Example: pgsql2shp -f land_polygon -h localhost -u imsma -P password staging " select * from haz_gis_poly where \"Status\" = 'Closed' "

	{{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.}}		{{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}}		{{NavBox AGOL Extension}}
	[[Category:NAA]]		[[Category:NAA]]

Alnaucler at 12:12, 11 September 2018

2018-09-11T12:12:38Z

← Older revision		Revision as of 14:12, 11 September 2018
Line 30:		Line 30:
	{{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 \| 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/>		[[Image:Pgsql2shp.png\|600px\|center]]<br/>
	<div align="center">		<div align="center">
	'' The number of rows exported will be shown when the export is done ''		'' The number of rows exported will be shown when the export is done ''

Alnaucler at 12:12, 11 September 2018

2018-09-11T12:12:09Z

← Older revision		Revision as of 14:12, 11 September 2018
Line 32:		Line 32:
	[[Image:Pgsql2shp.png\|700px\|center]]<br/>		[[Image:Pgsql2shp.png\|700px\|center]]<br/>
	<div align="center">		<div align="center">
	'' The number of rows exported ~~witll~~ be shown when the export is done ''		'' The number of rows exported will be shown when the export is done ''
	</div>		</div>
	Example: pgsql2shp -f land_polygon -h localhost -u imsma -P password staging " select * from haz_gis_poly where \"Status\" = 'Closed' "		Example: pgsql2shp -f land_polygon -h localhost -u imsma -P password staging " select * from haz_gis_poly where \"Status\" = 'Closed' "

Alnaucler at 09:25, 11 September 2018

2018-09-11T09:25:00Z

← Older revision		Revision as of 11:25, 11 September 2018
Line 1:		Line 1:
	One of the geotables need to be included in the table/view that you are exporting ~~and the~~ mandatory column is called ''shape''.		{{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:
			* 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		# Create a SQL view or use one of the existing GIS views
Line 6:		Line 16:
	# Run the command ''pgsql2shp'' with the following parameters		# Run the command ''pgsql2shp'' with the following parameters
	:: -f the name of the resulting shape file		:: -f the name of the resulting shape file
	:: -h host name If the Staging area database is on your computer than use ''localhost''		:: -h host name
	:: -u user ~~Use~~ ''imsma''		::: if the Staging area database is on your computer than use ''localhost''
	:: -P password ~~Use~~ ''password		:: -u user
			::: use ''imsma''
			:: -P password
			::: use ''password
	:: database name		:: database name
	:: SQL view or table name		:: SQL view or table name

	~~You may~~ refer to the SQL view/table by the name of it you would like to export ~~all~~ rows ~~OR specify the~~ SQL ~~statement~~.		If you would like to export all rows then you refer to the SQL view/table by the name of it.
			If you would like to export only some rows then you need to add more SQL statements.

	{{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 \| 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.}}
Line 24:		Line 38:
	{{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.}}		{{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}}		{{NavBox AGOL Extension}}
	[[Category:~~PEW~~]]		[[Category:NAA]]

Alnaucler at 12:43, 9 March 2018

2018-03-09T12:43:32Z

← Older revision		Revision as of 14:43, 9 March 2018
Line 22:		Line 22:
	Example: pgsql2shp -f land_polygon -h localhost -u imsma -P password staging " select * from haz_gis_poly where \"Status\" = 'Closed' "		Example: pgsql2shp -f land_polygon -h localhost -u imsma -P password staging " select * from haz_gis_poly where \"Status\" = 'Closed' "

			{{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}}		{{NavBox AGOL Extension}}
	[[Category:PEW]]		[[Category:PEW]]

Alnaucler at 08:20, 9 March 2018

2018-03-09T08:20:34Z

← Older revision		Revision as of 10:20, 9 March 2018
Line 10:		Line 10:
	:: -P password Use ''password		:: -P password Use ''password
	:: database name		:: 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		:: SQL view or table name

			You may refer to the SQL view/table by the name of it 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.}}		{{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.}}