Skip to Main Content
Feature Request FR-2931
Product Area Page Components
Status ROADMAP

9 Voters

Add Support for Thematic Maps using GEOJSON

william.endress Internal · Jan 13 2023

Thematic maps describe geographies using any collection of boundaries, lines or points. Typical use cases include:

  • Maps with political boundaries such as states, which in aggregate also present the shape of a country.
  • Flood zones, tax parcels, hardiness zones for plants ... pretty much anything where there is a geographic area.

Thematic maps are, for example, ubiquitous in the news. We've all seen (too many) color coded maps with numbers of COVID cases

Oracle Jet provides a thematic map object. See. https://www.oracle.com/webfolder/technetwork/jet/jetCookbook.html?component=thematicMap&demo=basemaps

Note that this is different from the basemap provided by the APEX map object. The Oracle Jet thematic map can render any map using geojson. Someone might, for example, create a geojson map with customized regions (collections of states), water basins, a site plan of a sports stadium, pretty much anything with boundaries.

A thematic map could be displayed over the APEX base map.

The implementation should include support user-provided geojson (e.g., selected from a table or a static file), and color or pattern filling based on data values.

Classic example (using Oracle Jet)

This is currently on the roadmap for a future release of Oracle APEX.

Comments

Comments

  • carla.daniels OP 3.4 years ago

    +1  useful application for industries like retail, public health, etc.

  • blesson.baby OP 3.3 years ago

    +1 . This is a good case to show cities and towns which have  regulations/ norms regualting their transition to Net Zero emission.

  • prashant.lal OP 3.3 years ago

    adding this to APEX provides another option to create spatial content (maps) besides, Spatial Studio or OAC. the latter two not being targeted to the APEX audience / customer base.

  • prashant.lal OP 3.3 years ago

    Just noticed this page was made with APEX and has the map displayed as an image.  I would expect enhancement would enable the creation of interactive maps with spatial and other data on it.

  • jayson hanes Admin OP 3.3 years ago

    @prashant.lal APEX already supports maps like this - to a degree.. Its' more about the geometry you have available from your database to deliver to the client and render on the map. It could be made easier to some ways.

  • carsten.czarski APEX Team OP 2.9 years ago

    The APEX Map Region is the component in APEX which is there for all mapping requirements; I think it would not be feasible to introduce a second map region of the “JET Thematic Map” type. 

    As long as your data is within tables, and accessible with SQL, you can have a thematic overlay in the current map region today: the map region renders the base map and puts the information from the SQL query on top.

    There is an enhancement to allow custom base maps (map backgrounds) instead of the built-in ones, which is on the roadmap. Another enhancement (and that would be this one) would be to allow Layers in the Map region being based on a GeoJSON from a URL, and not based on a SQL Query. That would accommodate cases where a GeoJSON is already present and does not need to be constructed using a SQL Query. I see this idea in such a context.

  • william.endress OP 2.9 years ago

    I think a geojson map source from a query or URL sounds about right.