nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

AcGIS Pro 2.4 | How to display X,Y point coordinates in Query Layer?

VincentLaunstorfer

Hi,

In an Oracle DBMS, I created views with X and Y coordinates in columns, in WGS84. In ArcGIS Pro, I tried to create a Query Layer in order to display live and up-to-date datasets. I managed to select an integer unique identifier and the query layer opens as a Table in the Content. However, I'd like to display it as a point layer in the Content. If I try to right-click the table and Display XY, it opens the geoprocessing tool XY Table to Point which would create a copy of the data. This is not what I am expecting. How to display point layer XY, stored in columns, in a Query Layer based on an Oracle view (with no spatial column) ?

Thanks

PS: I changed this question to ArcGIS Pro instead of Managing Data as it looks more appropriate

Finde mehr Beiträge mit dem Tag

Accepted answers

All comments

George_Thompson

I would think that you need to have a spatial (shape) field and that the client will not add the shape (based on X / Y) on the fly. Is that what you are looking for?

"Geometry SRID property

This property is the spatial reference identification value that is set on the shape objects in the database. It will be blank if the query layer does not have a spatial field. If this value is set, all features that do not have the specified geometry SRID values will be excluded from the result set."

Defining the spatial reference of the query layer—Query layers | ArcGIS Desktop

What is a query layer?—Query layers | ArcGIS Desktop

Geodatabase‌ Managing Data‌

VincentLaunstorfer

In addition to my question posted yesterday using the geoprocessing tool XY Table to Point to create a Point Feature Class, I tried the Make XY Event Layer tool to keep the layer live and connection to my Query Layer.

Unfortunately, my Event layer in the Table of Content do not display anything and if I try to open Attributes Table, I get a DBMS error ORA-01455: converting column overflows integer datatype. Perhaps, I need to ensure all my number column in my views are readable by ArcGIS clients...

George, you mentioned to have a spatial field in my Oracle table. Why not. Can I build a ST_Geometry or SDO_Geometry spatial field from my X and Y coordinates columns in my views? What would be the syntax?

Thanks

George_Thompson

You can do this in the view on the Oracle side of the view, then bring it into the ArcGIS client; ST_Geometry—Help | ArcGIS Desktop

Generally speaking you want to make sure that your Oracle instance can support the ST functions via EXTPROC; Configure the extproc to access ST_Geometry in Oracle—Help | ArcGIS Desktop

VincentLaunstorfer

My Oracle instance is EXTPROC enabled and I can build ST_Geometry objects.

select

sde.st_geometry('point('amh.LONGITUDE_DEC_DEG','amh.LATITUDE_DEC_DEG'),4326') SHAPE,

select
sde.st_geometry(amh.LONGITUDE_DEC_DEG,amh.LATITUDE_DEC_DEG,null,null,4326) SHAPE,

...should work to create the spatial column as Point in my view, but I still get an Oracle ORA-00907 silling error on "missing right parenthesis". Should I cast my X and Y number column to NUMBER(38,8) for example? Or is there anything alse wrong in the syntax?

Thanks for you help, I am sure I will get this one sorted out today...

George_Thompson

I would guess that the X/Y fields would need to be numeric fields. Try that and then test.

Nimm an der Diskussion teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

Alle Communities
Neueste Beiträge
Gefolgte Inhalte
Community-Hilfe

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.