Save and close your Excel file when it is completed and the columns are formatted. Once your Excel table is complete you can move to working in ArcGIS. The Excel file created for this exercise is composed of destinations that we would love to visit with columns for location data, latitude, longitude, and a brief description of what makes the location special. Copy and paste the data from GeoHack into your columns in Excel and don’t forget to include any negative signs as they are a crucial component of your coordinates. The first coordinates to the left of the Decimal Degree data represent Latitude and the coordinates on the right represent Longitude. To fill up the Excel table we will be taking the Decimal Degree data, highlighted in red in the image above from GeoHack, from a range of destinations the world over.
We are interested in the second set of coordinates, highlighted in the screenshot above. GeoHack has all of the pertinent spatial data for your site that you will need. Click on the particular coordinates for the site (the word “Coordinates” and the globe will bring you to different places) and you will be linked to GeoHack. For the majority of articles about places in Wikipedia the coordinates listed in the top right hand side of the screen with a small globe beside it. Finding coordinates for sites of interest has never been so easy! Go to Wikipedia, type in the city or area of interest.You can even create columns with other sorts of data that you may want to have accessible to you in ArcGIS.īe careful! Try and keep your header labels, any folders you’re using, and the name of your map to nine characters or less and do not include any special characters or spaces. Once you have created your header row, you can input your data into the cells below.
Columns will default to being in a General format, unless you change them. This column is followed by a Latitude and Longitude column that must have a Number format, unlike the Locations column. In this guide, we have a Locations column to put the name of the place you have coordinates for. Label your headings as the first row of your spreadsheet will contain the names of each column. For this guide we will be using an Excel table with information for places that would be great to visit around the world.
0 kommentar(er)
