idea Get a FGDB FC point's XY coordinates using SQL in ArcGIS Pro Ideas

Get a FGDB FC point's XY coordinates using SQL

Bud — Tue, 06 Dec 2022 02:58:49 GMT

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.

Re: Get a FGDB FC point's XY coordinates using SQL

Bud — Tue, 06 Dec 2022 09:21:39 GMT

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

Re: Get a FGDB FC point's XY coordinates using SQL

KoryKramer — Tue, 06 Dec 2022 13:54:16 GMT

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...

Re: Get a FGDB FC point's XY coordinates using SQL - Status changed to: Needs Clarification

SSWoodward — Thu, 08 Dec 2022 18:13:48 GMT

Re: Get a FGDB FC point's XY coordinates using SQL

AlfredBaldenweck — Tue, 05 Sep 2023 16:15:12 GMT

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°

Re: Get a FGDB FC point's XY coordinates using SQL

KoryKramer — Tue, 05 Sep 2023 16:21:27 GMT

@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

Re: Get a FGDB FC point's XY coordinates using SQL

AlfredBaldenweck — Tue, 05 Sep 2023 16:26:18 GMT

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).

Re: Get a FGDB FC point's XY coordinates using SQL - Status changed to: Open

SSWoodward — Tue, 28 May 2024 19:21:40 GMT

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.

Re: Get a FGDB FC point's XY coordinates using SQL

Bud — Wed, 11 Dec 2024 21:32:22 GMT

Idea: Spatial SQL Functions — File Geodatabase