GeoJSON, SDO_GEOMETRY examples

geojson_sdo_geometry.sql

-- *** Single Point *** 
 
-- GeoJSON
{"type": "Point", "coordinates": [-0.051, 51.50254]}

-- SDO_GEOMETRY
MDSYS.SDO_GEOMETRY(2001, 4326, MDSYS.SDO_POINT_TYPE(-0.051, 51.50254, NULL), NULL, NULL);

-- Longitude/Latitude
Longitude: -0.051
Latitude: 51.50254

-- *** Polygon ***

-- GeoJSON
{"polygon":{"datapoints":[[-119.48,33.20],[-115.15,36.08],[-117.15,33.62]]}}
 
-- SDO_GEOMETRY
MDSYS.SDO_GEOMETRY(2002, NULL, NULL, 
 MDSYS.SDO_ELEM_INFO_ARRAY(1, 2, 1), 
 MDSYS.SDO_ORDINATE_ARRAY(-119.48,33.20, -115.15,36.08, -117.15,33.62));