SAG Spatial reference system - Revision history

Alnaucler at 19:25, 20 February 2020

2020-02-20T19:25:26Z

← Older revision		Revision as of 21:25, 20 February 2020
Line 40:		Line 40:


	[[Category:~~VIE~~]]		[[Category:NAA]]

Alnaucler at 12:08, 7 October 2017

2017-10-07T12:08:01Z

← Older revision		Revision as of 14:08, 7 October 2017
Line 25:		Line 25:
	<li>Insert the reference system with a SQL tool like PGAdminIII or Navicat.		<li>Insert the reference system with a SQL tool like PGAdminIII or Navicat.
	</ol>		</ol>
			{{Note \| The Staging Area Generator will use the first number in the Insert statement in the ''Target SRID'' drop-down list.}}

	[[Image:Staging_Area_Generator_GUI_options.png\|center]]		[[Image:Staging_Area_Generator_GUI_options.png\|center]]
	~~{{Note \| The Staging Area Generator will use the first number in the Insert statement in the ''Target SRID'' drop-down list.}}~~

	==Error message when creating Geodata==__NOEDITSECTION__		==Error message when creating Geodata==__NOEDITSECTION__

Alnaucler at 11:17, 7 October 2017

2017-10-07T11:17:09Z

← Older revision		Revision as of 13:17, 7 October 2017
Line 7:		Line 7:

	You may also consult http://spatialreference.org/ to find the SRID that you would like to use. PostgreSQL is using the EPSG standard.		You may also consult http://spatialreference.org/ to find the SRID that you would like to use. PostgreSQL is using the EPSG standard.

			==Adding spatial reference system==__NOEDITSECTION__
			If you cannot find the reference system you would like to use in the dropdown list then you need to add it to the staging database.
			You consult http://spatialreference.org/ to find the SRID that you would like to use.

			[[Image:SAG add ref sys.png\|500px\|center]]
			<div align="center">
			'' Example: Sri Lanka grid''
			</div><br/>

			<ol>
			<li>Compare your prj file with the definition on the website.
			<li>When you are sure that you have find the '''correct''' projection/convertion file then click in the ''insert'' link.

			[[Image:SAG add ref sys2.png\|900px\|center]]<br/>

			<li>Insert the reference system with a SQL tool like PGAdminIII or Navicat.
			</ol>
			[[Image:Staging_Area_Generator_GUI_options.png\|center]]
			{{Note \| The Staging Area Generator will use the first number in the Insert statement in the ''Target SRID'' drop-down list.}}

	==Error message when creating Geodata==__NOEDITSECTION__		==Error message when creating Geodata==__NOEDITSECTION__

Alnaucler: Created page with "{{TOC right}} For a complete list of available projections, issue the following query on an empty staging area (i.e. the one created after clicking on '''Validate Selections''..."

2017-10-07T10:50:23Z

Created page with "{{TOC right}} For a complete list of available projections, issue the following query on an empty staging area (i.e. the one created after clicking on '''Validate Selections''..."

New page

{{TOC right}}
For a complete list of available projections, issue the following query on an empty staging area (i.e. the one created after clicking on '''Validate Selections'''):
<pre>
select *
from spatial_ref_sys
</pre>

You may also consult http://spatialreference.org/ to find the SRID that you would like to use. PostgreSQL is using the EPSG standard.

==Error message when creating Geodata==__NOEDITSECTION__
Conversions/re-projections cannot be done between all coordinate systems/SRIDs. In fact, some coordinate systems are defined for and focus on a specific part of the world, and coordinates outside of this specific range cannot be represented. If this is the case, an error message such as the following will be displayed in the staging area generator progress window.

[[File:SAG_geo_error.png]]
[[File:SAG_geo_error2.png]]

If you encounter this error, please verify whether the chosen SRID for re-projection and the coordinates in the source IMSMA are compatible. It could also be something wrong with references between tables in the {{IMSMANG}} database. You will find more information in the log file.

{{NavBox Business Intelligence}}

[[Category:VIE]]