Skip to Main Content

APEX

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 load geoJSON to apex cloud?

GregStef0May 1 2019 — edited May 3 2019

Hello everyone.

I have just joined this community and here is my 1st question:

I have created a geoJSON file containing Municipality data from a locally installed 11.2 db spatial table.

The geometries are reprojected to WGS84, it has a total of 76122 rows ('Pretty Print' ed), representing 326 geometries with 8 attributes each. Its size is 1.9 MB.

181 entries are simple polygons and the rest range from simple polygon with hole to multipolygon of 210 elements (island municipality).

How can I load this file to my apex.oracle.com workspace, in order to create a copy of my local table (in WGS84)?

The Data Workshop/Load Data process creates the table with all the json's attributes, but drops the geometry part altogether.

Thank in advance for your time

Please? Anyone??

Am I posting in the wrong place/not following protocol/have little reputation?

Message was edited by: GregStef0

This post has been answered by Carsten Czarski-Oracle on May 3 2019
Jump to Answer
Comments
Post Details
Added on May 1 2019
3 comments
616 views