1 / 21

Working with Tables

This guide focuses on the essential practices of working with tables in Geographic Information Systems (GIS). It discusses key features like one record per feature, unique column naming, defining data types, and setting appropriate attribute widths. It also covers methods for joining and relating tables, including one-to-one, many-to-one, one-to-many, and many-to-many relationships. The importance of maintaining original data integrity while joining is emphasized, and it offers insights into data summarization and visualization techniques like charts and reports.

stesha
Télécharger la présentation

Working with Tables

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. Working with Tables Where the serious GIS work takes place.

  2. One Feature – One Record

  3. Field or Column Record or Row One Feature – One Record

  4. Field Requirements • Use unique column names • Define the data type to be stored • Appropriate width for attribute value. Data Types will be discussed in the next lecture.

  5. Joining and Relating Tables A Common Field

  6. One to One Relationship Join the tables.

  7. Many to One Join the tables.

  8. One to Many Relationship Relate the tables.

  9. Many to Many Relate the tables.

  10. Joining Tables

  11. Joining to another table based on atributes. This is the table you are joining These are the common fields

  12. Join Results Original Owners.dbf Original Coffee Shop Attribute Table (points)

  13. Joined Tables • The originals remain separated • They can be unjoined • You can use joined data to symbolize and classify. • You can create statistics, charts and reports.

  14. What happens if you join when you should relate for a One to Many? ? ? Join will combine for the first record and then ignore the rest. Relate will connect all the records. ?

  15. What happens if you join in a Many to One The records are duplicated in the Joined file

  16. Multiple Joins and Relates(Daisy Chains) Route Route

  17. Related Tables

  18. Summarize Data

  19. Create a Graph from Summarized, Selected Data

  20. Chart of joined, summarized, selected data.

More Related