1 / 96

Importing your Own Data To display in GIS

Importing your Own Data To display in GIS. Lab 4a: (Table Join) Mapping By State, County, or Nation. 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.

krysta
Download Presentation

Importing your Own Data To display in GIS

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  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.

  9. Side Note ends: Continue from here

  10. Select the Data in the Sheet You Want

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

  12. OK to Only Active Sheet

  13. OK to Format Change

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

  15. Next Open Up ArcCatalog

  16. File, Connect Folder

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

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

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

  20. Name it

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

  22. Right Click on it, New, Feature Class

  23. Name it, Next

  24. Default

  25. Shape, Spatial Reference, 3 dots

  26. Select, Geographic Coordinate Systems

  27. North America, North American Datum 1927

  28. Apply, OK, Finish.

  29. Resume with instructions

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

  31. Next Launch ArcToolbox

  32. Pick: Export from Table, Table to Geodatabase

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

  34. 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.

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

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

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

  38. For Output, select your new personal geodatabase

  39. Press OK and watch it convert

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

  41. Open Arc Map

  42. Select the Existing Map for this Course

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

  44. Select + by the Entire Us

  45. This expands the selection

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

  47. Insert, Data Frame

  48. Right Click on New Data Frame, Add Data

More Related