How To Draw Jusridictions Arcgis From Excel

Creating a betoken layer of locations

This is a beginner's guide to creating a indicate layer in ArcGIS x.2 using the latitude and longitude of the locations y'all wish to brandish. The offset part of this guide will walk you through creating an Excel file of coordinates found in decimal degrees that are set up and ready to exist imported into ArcGIS. How to locate coordinates online will also be discussed. This guide will so walk y'all through bringing your data into ArcGIS and creating your bespeak layer on height of a base layer of countries.

For this guide we will exist using an Excel table with information for places that would be great to visit effectually the globe.

Open upwards a new document in Excel.
Characterization your headings as the first row of your spreadsheet will contain the names of each column. In this guide, we have aLocations column to put the name of the identify you take coordinates for. This column is followed by aLatitude andLongitude cavalcade that must have aNumber format, unlike theLocations column. Columns will default to beingness in aFull general format, unless you lot alter them.

One time you lot accept created your header row, you can input your information into the cells below. You can fifty-fifty create columns with other sorts of data that you lot may want to have accessible to you in ArcGIS.

Be careful! Effort and keep your header labels, whatever folders yous're using, and the name of your map to ix characters or less and exercise not include whatsoever special characters or spaces.
Finding coordinates for sites of involvement has never been and so piece of cake! Go to Wikipedia, type in the urban center or area of involvement. For the bulk of articles about places in Wikipedia the coordinates listed in the top correct hand side of the screen with a small globe beside it. Click on the particular coordinates for the site (the discussion "Coordinates" and the earth will bring yous to different places) and you will exist linked to GeoHack.

GeoHack has all of the pertinent spatial data for your site that you will need.

We are interested in the second gear up of coordinates, highlighted in the screenshot to a higher place.
To make full up the Excel tabular array we volition be taking the Decimal Caste information, highlighted in red in the image above from GeoHack, from a range of destinations the world over. The first coordinates to the left of the Decimal Degree data stand forLatitude and the coordinates on the right representLongitude. Copy and paste the data from GeoHack into your columns in Excel and don't forget to include whatever negative signs as they are a crucial component of your coordinates.

The Excel file created for this exercise is equanimous of destinations that we would beloved to visit with columns for location data, latitude, longitude, and a brief description of what makes the location special.
Save and close your Excel file when it is completed and the columns are formatted. Once your Excel tabular array is consummate you lot tin can move to working in ArcGIS. This guide is designed to complement version ArcMap 10.2.
For a base map, this guide will be using the free-to-download Countries vector layers (highlighted red in the prototype beneath) from the Natural Globe website: http://www.naturalearthdata.com/downloads/110m-cultural-vectors/

Download the Countries data. The data is compressed, so before you can use it you will need to unzip it. If you don't have whatsoever software to unzip files, 7-goose egg is a slap-up free plan that is easy to install. You can notice information technology here: http://www.vii-zip.org/.
Open up a new, blank map in ArcMap and so go to File and Save As, and and so give your map a proper name to salvage information technology. Nosotros called ours ExcelToPoint. Saving your map correct away is good practice as you should consistently salve your work as you go on in ArcGIS.
It is also incredibly important that you NEVER save piece of work with names that have a space in them or in folders that have names with spaces in them. Keep names to i word or bespeak spaces past using an underscore ( _ ).
Add to your map the Countries data that was retrieved from Natural World. To practice this go to the Add Data button at the elevation of the screen on the toolbar that is highlighted in red in the image below. Add the Natural World unzipped shapefile data; information technology will accept a .shp extension.
Add your Excel file the same way equally you added the Countries data – you will have to select the Excel file and the Sheet that your information is on. For this exercise our data is on the start canvass and the default name given to it is Sheet1$.
Once you have added your information you may have to modify the view of the Table of Contents (the window on the left side of the screen) to see the file in the list; unremarkably the views switch automatically so you can see the file just added, simply it is helpful to know that an Excel file is not visible in the Tabular array of Contents window nether the List By Drawing Order view. It is visible in the Listing By Source view.
In order to have your Excel information become spatial data in your map you will go to File, Add Data, Add together X Y Data, and from the dropdown menu select the Excel sail with your data in it. Likewise, select the column labeled Longitude to be the X Field and that Latitude is selected from the dropdown menu for the Y Field. The Z Field is for Z Values representing meridian or height data that can be used to make three dimensional data. But we won't worry almost that here and we'll simply leave it as None.
ArcGIS 10.two will automatically set a Geographic Coordinate Organization and Project for your new layer. This information is based on the coordinate system and project of your map.

The Coordinate System and Project of your map is initially fix by the commencement layer with spatial data added to it. This information for your map tin can exist found in the window that pops up if you lot double click Layers(highlighted in the paradigm below). The Coordinate system and projection tin be changed for your map and/or for your layer in several different places. To change the coordinate system and projection only for your layer, you tin easily do this at the Add together XY Data window. Just, we won't demand to do this in this example. If you would like more than data on irresolute Coordinate Systems and Projections, please get to this link: https://mdl.library.utoronto.ca/technology/tutorials/selecting-right-projection.

When you lot have specified the X Field (Longitude) and Y Field (Latitude) in the Add together XY Data window, click OK. A warning will appear, just click OK.

A new layer will appear in the Tabular array of Contents with the proper noun of your Excel layer followed by the give-and-takeEvents and your Excel information volition accept translated into points on the map. In our instance, nosotros left the Excel sheet as the default name, Sheet1$, so the new layer is called Sheet1$ Events.
In club to save your new spatial data in ArcGIS and if y'all want to interact with your data (query, select) afterwards on, in that location is one final pace to undertake. Your new Events layer needs to be transformed into a shapefile or feature class.
Export your Excel layer by right-clicking on the layer in the Tabular array of Contents. Go to Data, Export Information. The Export Information window will pop up. Make sure the dropdown menu has All Features selected and the coordinate system volition exist this layer'southward source data. In the Output characteristic grade box select where you want to choose where to save your information and you tin can requite information technology a new proper noun every bit this procedure will save your work equally a new layer. This new layer is an official point shapefile. For this exercise, we called the new layerNewShapefile (recollect not to take whatsoever spaces in names). When this is washed, striking OK.
A message box will pop up asking you if y'all want to add the exported data to the map as a layer and yous will hit Aye and the new shapefile will announced in your Table of Contents. Yous can remove the Events layer by right clicking it and selecting Remove. The Events layer will not exist of use to y'all for now on.
If y'all right click on your new layer,NewShapefile, and click onAttribute Table, you volition come across that eachdestination that was in the original Excel file now has their ownFIDcolumn.FIDis a value that lets the GIS programme work with and identify each point.
Relieve your work! And you are done transforming an Excel tabular array into a shapefile in ArcGIS that can exist reused and queried.