Differences

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

--- wdb:manuals:wdb_metadata [2012-06-14 21:12:19]
michaeloa [Set Parameter Names in Namespace]
+++ wdb:manuals:wdb_metadata [2013-01-24 10:30:56]
michaeloa [Add place Definitions]
@@ Line 160: / Line 160: @@
 ==== Add place Definitions ====
-There are various differing functions to add a place definition to the database, depending on the type of place definition to be added. The function wci.addplacepoint is used for adding point data, while wci.addplaceregulargrid is used to define regular grids as follows.
+There are various differing functions to add a place definition to the database, depending on the type of place definition to be added. The function wci.addplacepoint is used for adding point data, while wci.addplaceregulargrid is used to define regular grids as follows:
-  select wci.addplacepoint( 'oslo',
+  select wci.addplacepoint('oslo',
-                            'POINT(10.7564 59.9494)' );
+                           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.
+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',
@@ Line 179: / Line 179: @@
 The fifth parameter is a comment field. Ideally, it contains a few brief lines of text that describe and explain the data provider entity.
 ==== Adding a Place Definition ====