Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question

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.

share|improve this answer
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!

share|improve this answer
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 at 5:18

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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