I have tables in Oracle that contain spatial data using the SDO_GEOMETRY data type. I would like to create a button inside APEX that allows users to download a zipped shapefile export of this data. The shapefile should include all the standard files such as .shp, .shx, .dbf, and so on. Is there a way to implement this functionality directly within Oracle APEX?
I tried to manually convert the SDO_GEOMETRY data to shapefile format, but I ran into issues with encoding and generating the correct .dbf, .shx, and .shp files. Due to these complexities, I couldn’t create a proper shapefile export.
What I am looking for is a way to generate a zipped shapefile directly from within Oracle APEX, including all necessary files (.shp, .shx, .dbf, etc.), so users can download and use it easily.
