100 likes | 133 Views
Learn about data table formats, join and relate tables, field calculator, and calculating geometry in GIS. Explore data formats like xls, csv, dbf, and shapefile, along with field and table types. Discover how to join and relate tables, use the field calculator, and calculate geometry.
E N D
Introduction to GIS Module 1: Attributes and tables
Overview • Data Table Formats • Join and Relate Tables • Field Calculator and Calculate Geometry • Demonstration
DATA FORMATS • Table Types: • Tables Data: .xls, .csv, .dbf, .dbase • Shapefile: dbf
DATA FORMATS • xls: • Can view directly • Can not edit • Must import into .gdb or .dbf • Can only use one Sheet at a time • Must use GIS Naming Conventions
DATA FORMATS • Field Types: • String • Short • Long • Double • Date
Join Tables • Temporary Append of tabular data to geographic data • Appropriate for One to One or Many to One relationships
Relate Tables • Establishes a relationship between tables • Appropriate to use with a One to Many and Many to Many relationship
Field Calculator • Used to edit Attribute Values in bulk • Can edit all or selected records • Can use Simple or Advanced Expressions • Advanced Expressions use VBScript or Python • Can Save and recall expressions
Calculate Geometry • Can Calculate Area, Length, or perimeter • Data Must Be a Projected Coordinate System
Tables Demonstration • Tables in ArcMap and ArcCatalog • Table Properties • Table Interface • Multi-table view, Pin, Hide, Dock • Field Properties • Field Calculator (python) • Import Table