Skip to content

Instantly share code, notes, and snippets.

@jtiai
Created September 8, 2015 18:27
Show Gist options
  • Save jtiai/e3459777debf97458187 to your computer and use it in GitHub Desktop.
Save jtiai/e3459777debf97458187 to your computer and use it in GitHub Desktop.
Oracle spatial TO_GMLGEOMETRY
SELECT TO_CHAR(
SDO_UTIL.TO_GMLGEOMETRY(sdo_geometry(2001, 8307,
sdo_point_type(-80, 70, null),
sdo_elem_info_array(1,1,1), sdo_ordinate_array(10, 10)))
)
AS GmlGeometry FROM DUAL;
# srsName="SDO:8307"
SELECT TO_CHAR(
SDO_UTIL.TO_GMLGEOMETRY(sdo_geometry(2001, 4326,
sdo_point_type(-80, 70, null),
sdo_elem_info_array(1,1,1), sdo_ordinate_array(10, 10)))
)
AS GmlGeometry FROM DUAL;
# may return srsName="EPSG:4326" or srsName="SDO:4326"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment