I have geojson derived from a catchment API stored in a postgres. Using a st_transform function a geometry field is added in a view as per the code below. The resulting view works fine in QGIS however it fails to load when added to ArcMap /Pro. The issue only happens when features contain complex polygons (donut shapes), no issues when the polygon is simple.
This issue seems recent, as I have been using this for over three years now and always the complex polygons were visible within Arc. as anything changed recently?
I can share actual data if that helps.
CREATE OR REPLACE VIEW public.travel_times_test
WITH data AS (
travel_data_new.data::json AS fc
SELECT row_number() OVER () AS objectid,
st_transform(st_setsrid(st_geomfromgeojson(f.feat ->> 'geometry'::text), 4326), 3785) AS geom
FROM ( SELECT json_array_elements(data.fc -> 'features'::text) AS feat,
FROM data) f;
ALTER TABLE public.travel_times_test
OWNER TO gwkgis2016;