Oracle SDO table view not showing in arcmap

175
0
12-27-2021 03:13 AM
Hcemince
New Contributor II

Hello ,

I am trying to create view table based on a sdo spatial table from our database. When i create the view, arcmap doesn't draw the points. 

 

CREATE OR REPLACE VIEW "GIS"."VIEWTEST1" AS
SELECT CAST (ROWNUM AS NUMBER (7))OBJECTID , o.ID , o.FAULT_CODE AS ARIZANO, o.FAULT_TYPE_ID AS ARIZATIPI ,o.QUARTER_STREET_ID AS CSBMKOD ,o.FAULT_DATE AS KAYITTARIHI, SYS_GUID() AS ESRI_OID,
SDO_GEOMETRY (
o.LOCATION.SDO_GTYPE,
5254,
NULL,
o.LOCATION.SDO_ELEM_INFO,
o.LOCATION.SDO_ORDINATES
)SHAPE
FROM TEST.OPR_FAULT_NOTIFY o
WHERE o.WORK_FINISH_DATE IS NULL

Tags (3)
0 Kudos
0 Replies