100 likes | 133 Views
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
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