Thanks for your response.
Vatsa, December 11, 2023 - 3:07 pm UTC
I forgot to mention that the polygon data for the congressional districts in the table is ia CLOB and not SDO_GEOMETRY. Given a lat and long I want to find out which congressional district are those coordinates in.
Sorry for not being clear the first time.
convert wkt to sdo_geometry
good luck, December 17, 2023 - 12:07 pm UTC
If you want to do spatial queries, you need to use sdo_geometry objects. You can convert the clob to a polygon dynamically in the query using the function sdo_util.from_wktgeometry
Load geojson as SDO_GEOMETRY
Karin Patenge, January 08, 2024 - 8:49 am UTC
Besides the conversion functions provided by the SDO_UTIL package, you can also load GeoJSON data via Oracle Spatial Studio. It automatically creates SDO_GEOMETRY objects from your GeoJSON.
Then, simply use SDO_RELATE with mask=INSIDE/ANYINTERACT or SDO_INSIDE/SDO_ANYINTERACT get your containment question answered.