Top

Name

DB.DBA.RDF_GEO_ADD — Translates a geometry into a RDF box

Synopsis

DB.DBA.RDF_GEO_ADD ( in g any );
 

Description

This function translates a geometry into a RDF box. It looks if an identical geometry already exists and if so assigns the existing id to it. If the geometry is new, it gets a new ID and is stored in the RDF literals table RDF_OBJ. At this time it is also automatically inserted into the RDF geometry index.

Note: In a cluster situation one should use the dpipe mechanism for inserting into RDF quad so as to get large numbers of inserts into a single message. This is essential for performance.

Parameters

g

Geometry to be translated into RDF box.

Examples

Example 24.283. Simple example

INSERT INTO RDF_QUAD (g, s, p, o)
VALUES (
         "g",
         "s",
         iri_to_id ('http://www.w3.org/2003/01/geo/wgs84_pos#geometry'),
         DB.DBA.rdf_geo_add (rdf_box (st_point (lng, lat), 256, 257, 0, 1)));