Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Please ask technical questions in the appropriate category. Thank you!

How to display GeoJSON from a CLOB column in the database on a Map Region?

myluism2 days ago

Hi guys.

I'm using Apex 23 with Oracle 21c XE on my laptop.

This is scenario

  1. Downloaded GeoJson Data from this Site: https://gadm.org/download_country.html. I'm testing with GeoJSON data from Venezuela. GeoJSON Level-0 file for my first test.
  2. Created a test table with CLOB column containing GeoJSON Level-0 data on one Row:

3. Created a Test app with a page with map region as this:

Also these attributes:

I created the page and run it but I do not see the particular country highlighted or anything at all:

Is it just a map and that it. I have tested changing some properties but no luck. Please notice I created a faceted search. Now rows!

What am i missing here? I'm assuming the column contains the right data.

Could anyone provide some feedback please? I´m completely new with GeoJSON and Apex.

Thanks in advance !!!

Comments
Post Details
Added 2 days ago
3 comments
62 views