User Tools

Site Tools


wdb:manuals:wdb_metadata

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
wdb:manuals:wdb_metadata [2013-01-24 10:25:46]
michaeloa [Add place Definitions]
wdb:manuals:wdb_metadata [2013-09-11 17:58:08] (current)
michaeloa [Spatial Reference ID]
Line 165: Line 165:
                            ​st_geomfromtext('​POINT(10.7464 59.9111)',​4030));​                            ​st_geomfromtext('​POINT(10.7464 59.9111)',​4030));​
  
-The first parameter in the function is the place name, while the second is the geographical position of the place definition in the default coordinate system of the WDB instance (as a binary geometry). ​Parameters three and four, define ​the valid time of the place point definition.+The first parameter in the function is the place name, while the second is the geographical position of the place definition in the default coordinate system of the WDB instance (as a binary geometry). ​Note that the SRID provided must be the same as the default PostGIS SRID used to build WDB (by default, this tends to be PostGIS ID 4030).
  
   select wci.addplaceregulargrid( 'ecmwf 0.5 grid',   select wci.addplaceregulargrid( 'ecmwf 0.5 grid',
Line 187: Line 187:
 ==== Spatial Reference ID ====  ==== Spatial Reference ID ==== 
  
 +All SRIDs must be defined with "​+no_defs"​. Not including the "​+no_defs"​ parameter in the PROJ.4 transformation string makes the SRID dependent on the /​usr/​share/​proj/​proj_def.dat,​ essentially breaking the integrity of the metadata in the database.
 ==== Setting a Place Name ==== ==== Setting a Place Name ====
  
wdb/manuals/wdb_metadata.1359023146.txt.gz · Last modified: 2013-01-24 10:25:46 by michaeloa