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.
Thanks
Vatsa
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
sdo_util.from_wktgeometry(your_clob_column)
Load geojson as SDO_GEOMETRY
Karin Patenge, January 08, 2024 - 8:49 am UTC
Vatsa,
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.
Karin
Thanks for your response.
Vatsa, April 30, 2024 - 12:23 pm UTC
I converted the BLOB column to SDO_GEOMETRY using the function, but when I tried to plot the polygon using the converted column it does not draw the polygon. So, I am not sure if the conversion has happened correctly or if I am missing something.