Importing Excel Coordinates to ArcMap and Plotting 

You are welcome

You are welcome :)

Glad you liked it! :)

Just make sure you get China and India on board with massive Climate Change regulations ASAP!!! Nobody pollutes the environment that these two countries and until THEY make these drastic changes, there will be no change in the quality of air for millions of people on that side of the world.

You are welcome

You are welcome :)

Is he a Sri Lankan?

Hi, since the jurisdictional boundary is something that was demarcated by the respective authorities/ government, you will need to see whether that particular information is available for you to be downloaded in a GIS format. If they are not readily available in digital formats, another possibility would be to georeference a scanned map which indicates those boundaries, and then digitize it by yourself (and again, this is assuming that you have access to at least a printed version of a map)

You're welcome!

Thank you :)

Hello, were you able to resolve this? I'm also having the same issue.

@@bidhanghimire6868 no I don’t remember being able to fix it :(

You are welcome ☺️

No, since you are importing points, just the lat and lon of the corresponding point is sufficient

Thank you..

If that's the case, you can bring in your coordinates to ArcMap using the same method that's explain in this video, BUT first you need to set the coordinate system of the ArcMap dataframe/ project to that particular UTM coordinate system. Then you can being in your UTM coordinates and it will get stationed at the correct locations.

You are welcome :)

Hi, can you give an example of such a case, I might be able to give you some insights better if I can look at an example

...thank you for your response...I help to support a local school electric car racing team, and we have a direct radio telemetry link which brings up data on our laptop, from the car, in real time.. The telemetry software on the laptop is displayed within Excel...A future development is that our car will incorporate a GPS module, initially to indicate road speed...Do you think it would be possible, if we get the GPS to transmit the coordinates, to add a sheet within our telemetry program that would show a plan of a racetrack with the live car position being indicated..? I really don't want to take up too much of your time here, so a simple yes or no as to the feasibility of the idea would help me to decide whether to research the idea more, or not...Thank you again for responding..John..UK

Hi John, I think this is doable in python with the help of a bit of an advanced library like Dash. I haven't explored Dash to it's core, but based on a cursory reading of their documentation, it seems like its doable. I'll direct you to the page of one of the RU-vidrs who has covered certain aspects of Dash, so that you might be able to get an idea how the library works and how you might be able to alter the functionalities to fit to your purpose. This tutorial is just a representation of how Dash can be used to develop graphs, but I'm sure it might be possible to do the same with geographical data as well ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-J_Cy_QjG6NE.html Hope this helps!

It does help, thank you..I’ll do some more research..Thank you for your thoughts and advice.. John..UK

Hi, if your coordinates are in Northing and Easting, you need to find out first in which coordinate system those points were created. After finding out, you have to change the coordinate system of the ArcMap dataframe to be on that correct coordinate system, and then only proceed to import those points from your Excel. If you import coordinates corresponding to a projected coordinate system to an ArcMap dataframe which is in a geographic coordinate system, then it is obvious that the locations will be way off because ArcMap does not know the original coordinate system of the data points. Hope this helps.

@@geodeltalabs Thank you.

Did you save it in Excel (.xls) 2003 format?

Same issue even with 97-2003.xls file. No option to select Lat or Lon.......

Hi, you can first paste it in Notepad before pasting it into excel. Does that work?

You are welcome :)

Possible causes: 1. Accidentally mixed up X and Y value fields when assigning them to Latitude and Longitude 2. Did not set the coordinate reference system of ArcMap to the correct CRS before importing the points 3. While importing data, the specified coordinate reference system was incorrect You may see if any of this above is applicable for your case.

Try exporting and saving the temporary file as a proper ESRI shapefile. that should work

You're welcome