Importing your Own Data To display in GIS

1. Importing your Own Data To display in GIS Lab 4a: (Table Join) Mapping By State, County, or Nation

2. Lab Overview • In this lab you will: • Prepare the data you obtained for your portfolio so that it can be imported into Arc GIS mapping software. • Set up your own personal geodatabase which you can use to store all data you would like to map. • Import your portfolio Data into your geodatabase • Add your portfolio Data to an appropriate map (this involves joining 2 tables) • Selecting how you want the data to be visually represented

3. 1. Preparing the data you created in lab 4 so that it can be imported into Arc GIS mapping software.

4. Create an Excel Spreadsheet that Lists Data By State Make sure that your variable names are along the top row (top 1 row only) and that the state names are down the side column (A). There should be no blank rows above the data and no blank columns to the left.

5. Side Note: Make sure that the primary key (such as state, county, country etc) that you will be linking to in the map are spelled exactly the same way as in the map. (the next 4 slides review this)

6. To examine how the data is stored for a layer, right click on the layer, Select Open Attribute Table

7. It looks like a spreadsheet!

8. Highlight everything (by column) Options, Export, as Text (dbf may work better for your computer) Then you can retrieve these labels and find data that corresponds with them.

10. Side Note ends: Continue from here

11. Select the Data in the Sheet You Want

12. Save As…(give it a name) Save As Type: DBF IV

13. OK to Only Active Sheet

14. OK to Format Change

15. 2. Setting up your own personal geodatabase which you can use to store all data you would like to map.

16. Next Open Up ArcCatalog

17. File, Connect Folder

18. Select your H and the Specific Folder you want to put it in.

19. Now notice your H is in the left pane, Click on the H drive

20. Right Click in Blank Pane on Right hand side, New Personal GeoDatabase

21. Name it

22. Skip the next few slides (it seems to work without them) i.e. skip to part 3 of instructions

23. Right Click on it, New, Feature Class

24. Name it, Next

25. Default

26. Shape, Spatial Reference, 3 dots

27. Select, Geographic Coordinate Systems

28. North America, North American Datum 1927

29. Apply, OK, Finish.

30. Resume with instructions

31. 3. Importing your Lab 4 Data into your geodatabase

32. Next Launch ArcToolbox

33. Pick: Export from Table, Table to Geodatabase

34. If it does not appear as in the previous slide, use the following…

36. You may later find it helpful to shorten the data name here (so variable names are shorter, since this is added to existing variable names). To do this, copy and paste it here and give the pasted version a short name like fhdata.

37. i.e. Shorten the target name in the box that opens

38. ****Be sure that table name is short and no spaces in it!!!! Or else it won’t convert.

39. For Input Table, Select the DBF 4 Data you saved in Excel (click the file folder)

40. For Output, select your new personal geodatabase

41. Press OK and watch it convert

42. 4. Adding your Lab 4 data to an appropriate map(this involves joining 2 tables)

43. Open Arc Map

44. Select the Existing Map for this Course

45. Open it, Save as…an ArcMap Document –not template-(pick your own name) in your H Drive

46. Select + by the Entire Us

47. This expands the selection

48. 3 SLIDES EXCERPTED FROM HERE BECAUSE NO LONGER NEEDED WITH THIS SOFTWARE UPGRADE

49. Insert, Data Frame

50. Right Click on New Data Frame, Add Data