1 / 16

The Attribute Table!

The Attribute Table! . Without the attribute table, a polygon is just a polygon, a point is a point The attribute table defines what points, lines, or polygons (features) are and describes their characteristics. . Is it a city or a tree? . The Attribute Table! . Area. 2745.767.

darci
Download Presentation

The Attribute Table!

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. The Attribute Table! • Without the attribute table, a polygon is just a polygon, a point is a point • The attribute table defines what points, lines, or polygons (features) are and describes their characteristics. Is it a city or a tree?

  2. The Attribute Table!

  3. Area 2745.767 796.5096 1840.4960 The Attribute Table! • You can add/associate data to your attribute table by: • creating a new field • joining (one-to-one) • relating (one-to-many records)

  4. Schools The Attribute Table! • You can add/associate data to your attribute table by: • creating a new field • joining (one-to-one) • relating (one-to-many records)

  5. Most Common! Relational Database Model Types of relationships Cardinality - one-to-one, one-to-many, many-to-many Examples…? state capitol to state state to cities cities to state Keysfields are used to create relationships between tables. Can be a number or a text field. Always create a relationship from the spatial table (shapefile, geodatabse) to the non-spatial table

  6. Joins and Relates Two ways of linking an external table to a shapefile or geodatabase • One-to-One relationship • is created using the JOIN operation • external table is appended to your shapefile/geodatabase attribute table • One-to-Many relationship • is created using the RELATE operation • external table is physically separate from • the attribute table

  7. Joins • A join appends the fields from the non-spatialtable to the spatial table. • You can symbolize and query table information that is contained in the non-spatial table Spatial Layer shapefile, geodatabase Non-Spatial Layer table (dbf, csv, txt) Ave00

  8. Joins NAME Spatial Layer shapefile, geodatabase Non-Spatial Layer table

  9. Relates • Cannot symbolize • Cannot use “select by attribute” across tables • A relate does not append the fields from the non-spatial to spatial table (tables separate) Non - Spatial Table Spatial Table

  10. Relates Spatial Layer shapefile, geodatabase Non-Spatial Layer table

  11. Joining and Relating Tables • 1 to 1 Join • 1 to Many Relate • Many to 1 Join • Many to ManyRelate Allows link from the spatial table to the external table! (right-click on the shapefile/geodatabes to begin the join or relate)

  12. Manipulation of Fields and Attribute Data – Adding and Deleting Fields Add Fields from the Options button in the attribute table Delete Fields by right-clicking on the field

  13. Manipulation of Fields and Attribute Data – Adding Fields Add Fields from the Options button in the attribute table

  14. Manipulation of Fields and Attribute Data – Field Calculator • Saves time in data entry - automatically calculate values for a field • copying • concatenating • creating new values using mathematical operations (add field 1 to field 2) • -Advanced Field Calculator • performs advanced calculations using Visual Basic for Applications (VBA) statements Right-click on field heading Field Calculator

  15. Manipulation of Fields and Attribute Data - Summarize • Summarizing allows you to • aggregate your records by a field • sum • average • count • minimum • maximum value • standard deviation • variance • ArcMap creates a new table • containing the summarized data • Useful for joining tables

  16. Manipulation of Fields and Attribute Data - Summarize • Right-click field • Summarized Dialog • Create a new table

More Related