Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to request a table to return GeoJSON FeatureCollection

op3nupAug 24 2017 — edited Sep 15 2017

Hi,

I am interested in requesting a conventional non-geojson spatial table  with spatial  sdo_geometry column to return a GeoJSON FeatureCollection including geometry and non-spatial data. GeoJSON Support seems to be new to Oracle 12.2. I read the interesting Dojo13 which states at page 88:

select c.geometry.get_geojson() from world_capital_cities c where c.name = 'Berlin';

How can I request a complete FeatureCollection?

Thanks for your support!

Hanko

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 13 2017
Added on Aug 24 2017
6 comments
1,642 views