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; } } }

Get a FGDB FC point's XY coordinates using SQL

Bud

In an SQL Expression or a database view on a file geodatabase:

If I understand correctly, we can't access the XY coordinates of a point feature using SQL.

For example, something like this:

x_coord(shape) --would resolve to 665,478.140 meters

Could that functionality be added as a function in the FGDB engine/SQL syntax?

I'm aware that a workaround would be to store the X and Y coordinates in static fields in the FC via a calculation attribute rule. But it would be a lot of work to implement that for all FCs in all FGDBs. Doing it in SQL would be better.

Thanks.

Find more posts tagged with

Geodatabase

Status: Open

Comments

Bud

It might be possible to query for this kind of thing using open source tools like GDBee and QGIS. The FGDB SQL querying functionality seems pretty comprehensive: https://github.com/AlexArcPy/GDBee

KoryKramer

Hi @Bud what is your workflow? i.e. what are you trying to do with the x, y coordinates once extracted from the shape? Because this can be done using Arcade...

AlfredBaldenweck

I'll chime in with a workflow: It'd be great if I could use a definition query to return only points within a certain extent, e.g. west of 108° and north of 36° but south of 42.36565°

KoryKramer

@AlfredBaldenweck that would be Spatial Definition Query which we have Under Consideration and it looks like you've already added your kudos to that idea. Thank you! https://community.esri.com/t5/arcgis-pro-ideas/spatial-definition-query/idi-p/922663

AlfredBaldenweck

I think a spatial definition query (as I interpret it) is more about querying based on the relationship between other features, e.g. all the Public Land Survey Townships within a particular county, and would require there to be a feature there. This is more along the lines of Allow SHAPE field to be used in Definition Query - Esri Community, but for views.

I apologize, I wasn't reading too carefully and should not have brought up definition queries (although I think that's a valid use, too).

SSWoodward

Opening this back up. @Bud if you have an example workflow and some more information on whether or not extraction with arcade is a viable solution for you please share it when the opportunity arises.

Bud

Idea: Spatial SQL Functions — File Geodatabase