Difference between revisions of "SAG Spatial reference system"
(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''...") |
|||
| (2 intermediate revisions by the same user not shown) | |||
| 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> | ||
| + | {{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]] | ||
==Error message when creating Geodata==__NOEDITSECTION__ | ==Error message when creating Geodata==__NOEDITSECTION__ | ||
| Line 19: | Line 40: | ||
| − | [[Category: | + | [[Category:NAA]] |
Latest revision as of 20:25, 20 February 2020
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):
select * from spatial_ref_sys
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
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.
Example: Sri Lanka grid
- Compare your prj file with the definition on the website.
- When you are sure that you have find the correct projection/convertion file then click in the insert link.
- Insert the reference system with a SQL tool like PGAdminIII or Navicat.
 |
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
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.
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.
| ||||||||||||||
