Many many thanks brother . I was spending a lot of time but could not solve the problem but your only 4 minute video solve my problem .Highly recommended your channel
Why can’t I upload my excel file to arcgis? There’s an error message saying that “failed to connect to database. An underlying database error occurred. Class not registered “ however i saved the excel data sheet as Excel 97-2003 workbook . please help me to resolve it!
Thank you so so much you helped me a lot !!! you have no idea it was exactly what i needed to pinpoint the samples in the map i needed. And it is the first time i am using this software but your explanation was so clear thanks again
Very informative video..sir please tell me how to make a study map using arcgis.i have made an excel file that contains latitude and longitude value . My thesis is on hospitals in Lahore Pakistan.
Thanks! It was very helpful. I have question, How can we add jurisdictional boundaries of stations. suppose we are working on police stations in a city, so, a police station must have jurisdiction, so what data need to collected and what terminologies are to use?
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)
Hi ! I am totally new to ArcGIS. I am just wondering if you could just add your points on Singapore from any of the default basemaps instead of creating a shapefile for Singapore. Would adding all the other layers to the basemap reduce coordinate related errors ?
I have a csv data file and I am trying to upload it on arcmap....everytime I select the option display on xy dialog box appears but the x and y field doesn't show latitude and longitude
Hi. This was really helpful. But the challenge I have right now is that the coordinate points are not appearing inside the map but outside. How can I fix this?
1. Check if you are selecting the right coordinate system when importing the data. 2. Check if you are mixing up X and Y. These 2 are some common mistakes that hinder one from getting to points to place correctly on the map
My coordinates are in Northing and Eastings. I find that when I plot it in ArcMap it locates the points way off (way way off)where they're supposed to be. Can you kindly help me with it? Thank you.
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.
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.
Thank you for this video! It was exactly what I was looking for to help plot my points. Just a quick question if you could help please. When I uploaded the data and plotted the points, I was unable to get the attribute data. Is there anyway I can get it to display? Could there be an issue with my formatting on excel? Any help to get my attribute data to display is very much appreciated. Thank you.
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.
Thank you tons sir.I have been referring to your tutorials on phython which has been handy in my research on climate change.I cannot thank you more sir and kindly request you if you could please prepare videos on projection and transformation in Arcgis UTM to MUTM and vice versa.Thank you in advance.
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.
Hi, i'm trying to put my x and y coordinates in excel but it's not working. For example, i have this coordinate 52.274967, 4.794477. But when i put it in excel it turns into 52.274.967 and 4.794.477 I can't get these locations to show up in ArcGIS. I tried converting the cells to text instead of number but then i can't add them in ArcGIS either. What can i do to remove that 2nd dot because excel keeps adding it
Thank you for an excellent video..Do you think it would be possible to plot a position in real time on a map within excel, from live coordinates from a gps unit? Your thoughts would be appreciated..Thank you..
...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 UA-camrs 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 ua-cam.com/video/J_Cy_QjG6NE/v-deo.html Hope this helps!
ArCGIS student here. Thanks so much
Many many thanks brother . I was spending a lot of time but could not solve the problem but your only 4 minute video solve my problem .Highly recommended your channel
Thank you so much.. Every step and point is well explained but the most best part of this video is your voice...
Thank you, this is exactly what I need to do in many situations
You are welcome
Why can’t I upload my excel file to arcgis? There’s an error message saying that “failed to connect to database. An underlying database error occurred. Class not registered “ however i saved the excel data sheet as Excel 97-2003 workbook .
please help me to resolve it!
very clearly explained. Thank you
Thanks
Thank you so so much you helped me a lot !!! you have no idea it was exactly what i needed to pinpoint the samples in the map i needed. And it is the first time i am using this software but your explanation was so clear thanks again
Thanks for good presentation,
I want know how can I add KmL file into ArcGIs?
@geodeltalabs Where are you pick Singapore data from?
it was very useful tutorial thank you
Amazing!! Thank you so much 🙂
Very informative video..sir please tell me how to make a study map using arcgis.i have made an excel file that contains latitude and longitude value . My thesis is on hospitals in Lahore Pakistan.
thanks brother!!! u made my live longer!! huaa
Thank you so much. Clear instructions
when I add the station coordinate, the latitude and longitude don't show up?
Thanks! It was very helpful.
I have question, How can we add jurisdictional boundaries of stations. suppose we are working on police stations in a city, so, a police station must have jurisdiction, so what data need to collected and what terminologies are to use?
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)
Thank you so much brother. You are a great man
so how do i copy the shape file created to word document?
It was great job .can you insert the UTM coordinates instead of lat.Log...?
Great video my friend, sure helped alot! keep up the good work!
You are welcome :)
Hi ! I am totally new to ArcGIS. I am just wondering if you could just add your points on Singapore from any of the default basemaps instead of creating a shapefile for Singapore. Would adding all the other layers to the basemap reduce coordinate related errors ?
sir latitude and longitude option are not shown what i do, where the whole process is same
thank you very much
I have a csv data file and I am trying to upload it on arcmap....everytime I select the option display on xy dialog box appears but the x and y field doesn't show latitude and longitude
Did you save it in Excel (.xls) 2003 format?
Same issue even with 97-2003.xls file. No option to select Lat or Lon.......
where to get the basemap for Singapore?
Very Helpful, thanks!
Hi. This was really helpful. But the challenge I have right now is that the coordinate points are not appearing inside the map but outside. How can I fix this?
1. Check if you are selecting the right coordinate system when importing the data.
2. Check if you are mixing up X and Y. These 2 are some common mistakes that hinder one from getting to points to place correctly on the map
@@geodeltalabs thank you. I will do it all over again and check that out!🙏
My coordinates are in Northing and Eastings. I find that when I plot it in ArcMap it locates the points way off (way way off)where they're supposed to be. Can you kindly help me with it? Thank you.
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.
how could i receive the excel please?
How shape file was prepared
I have coordinates collected in UTM but since GIS requires lat/long is there an easy way to convert it without needing to do it manually
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.
Madhawa aiya... ❤️
Is he a Sri Lankan?
Sir, Please make a video on how do I calculate the Positional Accuracy of GCP points?
Thanks, a good demonstration
Glad you liked it! :)
tHANK YOU SIR FOR HELPING US SAVE THE WORLD WITH U
OR GIS
You are welcome :)
Thank you for your video
You are welcome
Thank you sir. Do we have to put North or South Latitude as well as East or West Longitude in excel sheet along with the coordinate points?
No, since you are importing points, just the lat and lon of the corresponding point is sufficient
Thank you..
Thank you for this video! It was exactly what I was looking for to help plot my points. Just a quick question if you could help please. When I uploaded the data and plotted the points, I was unable to get the attribute data. Is there anyway I can get it to display? Could there be an issue with my formatting on excel? Any help to get my attribute data to display is very much appreciated. 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 :(
The point did not appear when add like you? I did not found any solution on the internet why it did not appear. Please help me?
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.
How to write station name in study area?
In my case points are plotted but attribute table is showing nothing
Try exporting and saving the temporary file as a proper ESRI shapefile. that should work
Thank you tons sir.I have been referring to your tutorials on phython which has been handy in my research on climate change.I cannot thank you more sir and kindly request you if you could please prepare videos on projection and transformation in Arcgis UTM to MUTM and vice versa.Thank you in advance.
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.
Hi, i'm trying to put my x and y coordinates in excel but it's not working. For example, i have this coordinate 52.274967, 4.794477. But when i put it in excel it turns into 52.274.967 and 4.794.477
I can't get these locations to show up in ArcGIS. I tried converting the cells to text instead of number but then i can't add them in ArcGIS either. What can i do to remove that 2nd dot because excel keeps adding it
Hi, you can first paste it in Notepad before pasting it into excel. Does that work?
Thank you
You're welcome
Thank u so much 👏🏻👏🏻👏🏻
tk yu, im from Indonesia
Thanks for ur efforts, but when I come to to put the x and y into their places I can't find the columns ?):why
You have to use the right cordinate
Thank you so much sir
Dear sir your video is very good always. Please make a video to generate the geotiff raster by CSV data containing lat lon and data using Python
Thank you :)
Good! Thank you
Thanks !
Thank you for an excellent video..Do you think it would be possible to plot a position in real time on a map within excel, from live coordinates from a gps unit? Your thoughts would be appreciated..Thank you..
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 UA-camrs 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
ua-cam.com/video/J_Cy_QjG6NE/v-deo.html
Hope this helps!
It does help, thank you..I’ll do some more research..Thank you for your thoughts and advice.. John..UK
Thanks a lot.
Thanks🙏
Thanks soo much
You're welcome!
Thanks, dude~
Thanks
You are welcome ☺️
Awesome
Wow
😮
Thank you
Thanks so much SIR
You are welcome :)
thanks
You are welcome :)
Thank you