I have been asked to provide a list of coordinates for a point layer in our GIS. I am currently using a state plane coordinate system. How do I view/list this data. Below is the data request in it's original form: (Each serial number is assigned to a specific city address)

If I were to provide you with a list of ONT serial numbers like this one:

Serial Number Lon Lat

Would you be able to fill in the longitude and latitude of the ONT owning that serial number based on the data stored within the GIS?

Or on the other hand, do you have the ability to export such a list?


If you are using ArcGIS you can generate XY columns for the data using the Add XY Coordinates tool in ArcToolbox. Open ArcToolbox, then go to the Data Management Tools>Features toolbox. This will add an X and Y column to your data a populate them. You can then export to a table if that is what's required.

  • When I run this in ArcToolbox I get the following error message: "Either beig edited or in use by another application". At the time that I ran this I did not have ArcGIS open.....what gives? – user478 Aug 4 '10 at 21:59
  • If you are working in ArcCatalog and had been previewing the layer, Catalog is probably locking the layer. Close and reopen Catalog then use the tool without previewing the layer. That has worked for me in the past. – Zachary Aug 5 '10 at 1:33
  • I used this today & it worked famously. Thanks Zachary (+1) – Dano Jun 30 '11 at 17:20

I prefer to use python field calculator script for Point features.

To get X value use --!SHAPE.FirstPoint.X!

To get Y value use --!SHAPE.FirstPoint.Y!


N.B. This comes very much handy when you need to get start and end X,Y of Lines. as below

To get start X value of line use --!SHAPE.FirstPoint.X!

To get start Y value of line use --!SHAPE.FirstPoint.Y!

To get end X value of line use --!SHAPE.LastPoint.X!

To get end Y value of line use --!SHAPE.LastPoint.Y!

  • Slow! And same invalid results as the Generate XY tool. Selecting the "Calculate Geometry..." tool just below this one did work, though. – ca0v Dec 31 '15 at 19:35
  • @ ca0V Ah!, I just tested and found this does not give wrong values. – SIslam Jan 1 '16 at 5:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.