Name
sr_iri_to_srid, sr_srid_to_iri — convert between SRS IRIs and integer SRID codes
Synopsis
integer sr_iri_to_srid(
|
in sr_iri varchar); |
varchar sr_srid_to_iri(
|
in srid integer); |
Description
sr_iri_to_srid looks up an OGC spatial reference
system by its IRI (e.g.
http://www.opengis.net/def/crs/EPSG/0/4326) and returns
the corresponding integer SRID. Returns SQL NULL when the IRI does not
name a known reference system.
sr_srid_to_iri performs the inverse mapping: given an
integer SRID code, it returns the canonical IRI string registered for that
spatial reference system, or SQL NULL if no IRI is known for the given
SRID. Both negative SRIDs and unknown values map to NULL.
These conversions are used by Virtuoso's GeoSPARQL support to translate between the integer SRID stored on each geometry and the IRI form used in RDF triples.