- \n
- AddXYdatafiles.zip<\/a><\/li>\n<\/ul>\n
Adding XY data to ArcGIS screencast<\/h2>\n
The video below covers most of the steps for adding XY data apart from the problem solving tips that are only covered on this page.<\/p>\n
httpv:\/\/youtu.be\/vmEPsc8NnT0<\/p>\n
Adding XY data to ArcGIS text instructions<\/h2>\n
There are ways to open a spreadsheet directly in ArcGIS, but in my experience there are often problems. It is also possible to convert directly from an excel spreadsheet, but this is unreliable. My preferred technique is to convert from .csv format to shapefile or feature class (in geodatabase).<\/p>\n
<\/a>1.1\u00a0\u00a0\u00a0 Checking the XY data<\/h2>\n
It\u2019s important to check your data first!<\/p>\n
- \n
- Get the folder \u201cAdd XY data files\u201d<\/strong> and extract it.<\/li>\n
- There is a map on the top level and a folder with data in it. This is how I like to manage maps and data in ArcGIS.<\/li>\n
- Open the data folder and open up the \u201cfoliation-wt.xlsx\u201d <\/strong><\/li>\n
- The data has been prepared so that it is ready to be added into ArcGIS.<\/li>\n<\/ol>\n
Here are some of the features that make this XY data suitable<\/p>\n
- \n
- It has a single header row with clearly marked fields<\/li>\n
- It has Eastings and Northings and the Map projection is indicated (NZTM).<\/li>\n
- All columns with numbers in them only have numbers (they can therefore be recognised as number fields).<\/li>\n<\/ul>\n
1.2\u00a0\u00a0\u00a0 Saving data as CSV<\/h2>\n
But this data is in excel format. So we need to save it as CSV.<\/p>\n
- \n
- In excel choose File>Save As <\/strong>and choose the location where the excel file \u201cfoliation-wt.xlsx\u201d<\/strong> is stored.<\/li>\n
- In save as type choose CSV (Comma delimited) (*.csv)
\n![\"image1\"](\"https:\/\/blogs.otago.ac.nz\/si-geology\/files\/2015\/04\/image1.png\")
<\/a><\/li>\n- Excel will warn you that some features will be lost. Select \u2018Yes\u2019 we want to save as CSV. CSV is for storing data, it can\u2019t store formulas, graphs, multiple sheets and other things like .xlsx can.
\n![\"image2\"](\"https:\/\/blogs.otago.ac.nz\/si-geology\/files\/2015\/04\/image2.png\")
<\/a><\/li>\n- Close the file. Excel will keep the file open with all excel editable features intact, but will change the file name extension to .csv. This will mean that excel will ask whether you want to save changes when you try to close the file, you can just select \u201cDon\u2019t Save\u201d OR if you haven\u2019t saved some changes you want to preserve in excel format you can do that now.<\/li>\n
- \n
- \n
- Open \u201cfoliation-wt.csv\u201d<\/strong> in a text editor and see that it is the same data with a comma: \u2018,\u2019 between each value (C<\/strong>omma S<\/strong>eparated V<\/strong>alue).<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n
1.3 \u00a0\u00a0 Workflow for adding XY data<\/h2>\n
- \n
- Close excel. IMPORTANT <\/strong>you cannot work on the same file in two programs at once. If you try to work on this file in ArcGIS with it still open in excel it will not work.<\/li>\n
- Open the map \u201cmxd<\/strong>\u201d. Then open the ArcCatalog sidebar (Windows>Catalog<\/strong>) and navigate to the location where the \u201cfoliation-wt.csv<\/strong>\u201d file is stored. i.e Home><\/strong><\/li>\n
- Right click on \u201cfoliation-wt.csv<\/strong>\u201d and choose \u201cCreate Feature class>From XY table<\/strong>\u201d
\n![\"image3\"](\"https:\/\/blogs.otago.ac.nz\/si-geology\/files\/2015\/04\/image3.png\")
<\/a><\/li>\n- Choose the correct Input fields from the sheet headers for easting and Northing.<\/li>\n
- We need to set the coordinate system of these now. Click on \u201cCoordinate system..\u201d Choose the correct coordinate system (for NZ Go to Projected coordinate systems>National grids>New Zealand and choose NZGD2000 New Zealand Transverse Mercator Projection.<\/strong> )<\/li>\n
- It\u2019s a good idea at this point to add the coordinate system to your favourites by clicking on the little star icon. Click OK<\/strong>.
\n![\"image4\"](\"https:\/\/blogs.otago.ac.nz\/si-geology\/files\/2015\/04\/image4.png\")
<\/a>![\"image5\"](\"https:\/\/blogs.otago.ac.nz\/si-geology\/files\/2015\/04\/image5.png\")
<\/a><\/li>\n- Set the output to \u201cXYfoliation-wt.shp<\/strong>\u201d in the \u201cdata\u201d <\/strong><\/li>\n<\/ol>\n
1.4 \u00a0\u00a0 Checking the shapefile you just made<\/h2>\n
- \n
- Now if you look in folder you used in the ArcCatalog Sidebar you will see a shapefile with the name you gave it. Add this to your map by dragging and dropping.<\/li>\n
- You can query what each point is using identify . You can also open the attribute table to see attributes for each point (e.g. name). right click on layer>Open attribute table.<\/strong><\/li>\n
- You have just created spatial data (data that can be read by a GIS). You could now throw the .shp file you created into any new map and it will come up in the right place (provided the coordinate system is the same or transformation is set.).<\/li>\n<\/ol>\n
1.5 \u00a0\u00a0 Things to check for your own datasets<\/h2>\n
1.5.1\u00a0\u00a0\u00a0 Check that all of you points have plotted where you think they should have<\/h3>\n
- \n
- Use the select tool to select all your data in the area you are working in
![\"image6\"](\"https:\/\/blogs.otago.ac.nz\/si-geology\/files\/2015\/04\/image6.png\")
\n<\/a>![\"image8\"](\"https:\/\/blogs.otago.ac.nz\/si-geology\/files\/2015\/04\/image8.png\")
<\/a><\/li>\n- Open up the attribute table and check that all the entries have been selected.<\/li>\n
- If some points are not highlighted it might be because they have incorrect eastings and northings. Look at XY data integrity issues in problem solving<\/li>\n<\/ol>\n
1.1.1\u00a0\u00a0\u00a0 Check your attribute table to see that all data have come through as they should have<\/h3>\n
It\u2019s possible that sometimes ArcGIS will not recognise a field correctly. Look at some of the problem solving techniques below.<\/p>\n
1.6 \u00a0\u00a0 Problem solving<\/h2>\n
There are often a few issues with adding XY data. This section will cover a few of the common issues and some steps to remedy them.<\/p>\n
1.6.1\u00a0\u00a0\u00a0 You didn\u2019t correctly choose the Easting and Northing fields<\/h3>\n
- \n
- If your data don\u2019t plot in the right place then right click on the data file in ArcGIS and choose zoom to layer.<\/li>\n
- If all of your points have plotted but in the wrong place it likely is an issue with the fields you choose for import<\/li>\n
- ArcGIS often defaults to using Easting for both the Easting and Northing fields. So if you don\u2019t change this your data will plot along a 45 degree line somewhere on the map.
\n![\"image9\"](\"https:\/\/blogs.otago.ac.nz\/si-geology\/files\/2015\/04\/image9.png\")
<\/a><\/li>\n- Go back and start again choosing the correct fields for X and Y<\/li>\n<\/ol>\n
1.6.2 \u00a0\u00a0 You are trying to use the wrong coordinate system<\/h3>\n
Make sure you pick the correct coordinate system that your data are in.<\/p>\n
- \n
- One common mistake is to choose a projected coordinate system (Easting\/Northing) when your data are in a geographic coordinate system (Lat\/Long). Your data will plot down the lower left near the origin.<\/li>\n
- Another common mistake is to choose a geographic coordinate system (Lat\/Long) when your data is in a projected coordinate system (Easting\/Northing). Your data will not plot at all because it is getting values in millions of metres and expects values from -180 to +180 (degrees).<\/li>\n
- Another mistake is choosing the wrong projected coordinate system when there are more than one used in an area. For example choosing NZMG instead of NZTM. This will usually result in the points plotting very far away.<\/li>\n
- Another mistake is choosing the wrong geographic coordinate system. E.g. GD49 instead of CG200 in NZ. This will sometimes cause points to plot pretty close to where they should be but with a constant offset of potentially 200m. In some cases the geographic coordinate systems are so similar you won\u2019t be able to tell (e.g. GD2000 and WGS84)<\/li>\n
- A less common mistake is to choose the wrong datum\/projection combination. This will have the same offset effect as choosing the wrong datum.<\/li>\n<\/ul>\n
1.6.3 \u00a0\u00a0 ArcGIS can\u2019t work out what data type to use for a column<\/h3>\n
- \n
- This could be because your data have different types in one column. For example you might have a text where there should only be numbers. ArcGIS will not let you use the rest of the numbers in this column as numbers (e.g. in calculations, object rotations)
\n![\"image10\"](\"https:\/\/blogs.otago.ac.nz\/si-geology\/files\/2015\/04\/image10.png\")
<\/a><\/li>\n- Sometimes ArcGIS takes issue if there are too many blank fields at the start of a column (but this might be an issue with older versions as I can\u2019t seem to replicate it)<\/li>\n<\/ul>\n
1.6.4 \u00a0\u00a0 XY data integrity issues<\/h3>\n
If some of your data isn\u2019t plotting where it should be and you entered the data manually at any stage, then it is likely because you transposed or dropped some numbers. See the example below where a number has been dropped.
\n![\"image11\"](\"https:\/\/blogs.otago.ac.nz\/si-geology\/files\/2015\/04\/image11.png\")
<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"This tutorial covers adding XY data to ArcGIS, so that you can view and work with the data in ArcGIS. By XY data I mean point data such as foliation that has a spatial (XY) component associated with it.<\/p>\n","protected":false},"author":10389,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8741],"tags":[8805,8804,25995,15344,26009,8763,25956,62,25967,25996,8824,25974,8743,26006,25994,25993],"class_list":["post-623","post","type-post","status-publish","format-standard","hentry","category-gis","tag-arcgis","tag-coordinate-systems","tag-geographics-coordinate-systems","tag-geology","tag-gis","tag-instructions","tag-mapping","tag-new-zealand","tag-projected-coordinate-systems","tag-shapefile","tag-spatial","tag-spatial-data","tag-tips-and-tricks","tag-training","tag-xy","tag-xy-data"],"_links":{"self":[{"href":"https:\/\/blogs.otago.ac.nz\/si-geology\/wp-json\/wp\/v2\/posts\/623","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.otago.ac.nz\/si-geology\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.otago.ac.nz\/si-geology\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.otago.ac.nz\/si-geology\/wp-json\/wp\/v2\/users\/10389"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.otago.ac.nz\/si-geology\/wp-json\/wp\/v2\/comments?post=623"}],"version-history":[{"count":0,"href":"https:\/\/blogs.otago.ac.nz\/si-geology\/wp-json\/wp\/v2\/posts\/623\/revisions"}],"wp:attachment":[{"href":"https:\/\/blogs.otago.ac.nz\/si-geology\/wp-json\/wp\/v2\/media?parent=623"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.otago.ac.nz\/si-geology\/wp-json\/wp\/v2\/categories?post=623"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.otago.ac.nz\/si-geology\/wp-json\/wp\/v2\/tags?post=623"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
- Sometimes ArcGIS takes issue if there are too many blank fields at the start of a column (but this might be an issue with older versions as I can\u2019t seem to replicate it)<\/li>\n<\/ul>\n
- This could be because your data have different types in one column. For example you might have a text where there should only be numbers. ArcGIS will not let you use the rest of the numbers in this column as numbers (e.g. in calculations, object rotations)
- Go back and start again choosing the correct fields for X and Y<\/li>\n<\/ol>\n
- You have just created spatial data (data that can be read by a GIS). You could now throw the .shp file you created into any new map and it will come up in the right place (provided the coordinate system is the same or transformation is set.).<\/li>\n<\/ol>\n
- Open the map \u201cmxd<\/strong>\u201d. Then open the ArcCatalog sidebar (Windows>Catalog<\/strong>) and navigate to the location where the \u201cfoliation-wt.csv<\/strong>\u201d file is stored. i.e Home><\/strong><\/li>\n
- Close excel. IMPORTANT <\/strong>you cannot work on the same file in two programs at once. If you try to work on this file in ArcGIS with it still open in excel it will not work.<\/li>\n
- In save as type choose CSV (Comma delimited) (*.csv)
- In excel choose File>Save As <\/strong>and choose the location where the excel file \u201cfoliation-wt.xlsx\u201d<\/strong> is stored.<\/li>\n
- Get the folder \u201cAdd XY data files\u201d<\/strong> and extract it.<\/li>\n