Mengonversi string referensi spasial dari format Esri well-known text (WKT) ke format Open Geospatial Consortium (OGC) WKT.
Sintaksis
cstring ST_SrFromEsriWkt(cstring sr);Parameter
| Parameter | Description |
|---|---|
| sr | String referensi spasial dalam format Esri WKT. |
Contoh
Contoh berikut mengonversi string referensi spasial CGCS2000 (China Geodetic Coordinate System 2000) dari Esri WKT ke OGC WKT. Perhatikan bahwa nama DATUM berubah dari D_China_2000 menjadi China_2000—awalan D_ dihapus dalam output.
SELECT ST_SrFromEsriWkt('GEOGCS["China Geodetic Coordinate System 2000",DATUM["D_China_2000",SPHEROID["CGCS2000",6378137,298.257222101]],PRIMEM["Greenwich",0],UNIT["Degree",0.017453292519943295]]');Output:
st_srfromesriwkt
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------
GEOGCS["China Geodetic Coordinate System 2000",DATUM["China_2000",SPHEROID["CGCS2000",6378137,298.257222101]],PRIMEM["Greenwich",0],UNIT["Degree",0.017453292519943295]]