Set the coordinate reference system information for all HPD source data using a Well-Known Text (WKT) representation of a coordinate reference system. HPD source data is expected to be unprojected data stored as geographic coordinates.
The source data in an HPD schema is initially assumed to be in CARIS Datum WG84, using EPSG code EPSG:4326, which is Oracle SRID 8307.
Because all HPD source features are assumed to be in this coordinate reference system, this procedure does not transform features from one coordinate reference system to another.
Input
Parameter | Type | Description |
|---|---|---|
v_EPSG | VARCHAR2 | EPSG code of the HPD source data. Only EPSG:4326 and EPSG:4258 are supported. |
v_wkt | VARCHAR2 | Well-Known Text string representation of a coordinate reference system. |
v_description | VARCHAR2 | Free text to describe the coordinate reference system. |
Example
begin p_hpdconfig.set_source_geographic_crs_wkt('EPSG:4258', q'[GEOGCS["ETRS89 Shifted", DATUM["European Terrestrial Reference System 1989", SPHEROID["GRS 1980",6378137,298.2572221010041, AUTHORITY["EPSG","7019"]], TOWGS84[0.847,1.170,-0.735,0.039151,-0.017972,-0.032992,-0.0137], AUTHORITY["EPSG","6258"]], PRIMEM["Greenwich",0, AUTHORITY["EPSG","8901"]], UNIT["degree (supplier to define representation)",0.0174532925199433, AUTHORITY["EPSG","9122"]], AUTHORITY["EPSG","4258"]]]', 'descriptions'); end; |
Reminder: You will not see the effect of the example until you commit and the application is restarted. |
Exception
Only EPSG:4326 and EPSG:4258 are supported.