Using ArcView tables

Using ArcView tables • Create new tables • Add fields and records to tables • Edit table values • Query and summarize tables • Build relationships between tables • Create charts from tables

Fields Records Tables • manages the display of tabular information • Arcview tables • format information into records and fields

Table Properties • Hide fields • Make an alias for field name • Rearrange the position of fields (dragging)

Loading existing data into ArcView • Add dBASE, INFO, and text files

Create a new table • Name the new source file • A new table is created Creating a new table and file

Adding fields to a table • Define fields • New fields added

Table with fields but no records • New records added Adding records to a table

Editing values in a table • Choose Edit tool • Click to activate cell

Type new values • Choose Stop Editing Editing values in a table

Joining tables • Choose a common field • Make the destination table active

Results of joining tables • All fields from the source are appended to the destination • Source file remains separate • Joins can be removed

Linking tables • Fields are not appended to the destination table • Selections display the ‘linked’ information

Displaying the selection • Selected records and features are selected • Promote selected records to the top of the table

Calculate button • Write an expression to calculate new values Calculating fields

Select a field • Display statistics for the field Displaying statistics

choose Summarize Name & location of output file Statistics field Type of statistic Summarizing tables • generate summary statistics based on attribute values • select the field to summarize on

Results of summary statistics • New summary table • Added to project

Adding Event Themes • Add a new theme using a table as a data source • each record in your table represents a point feature located at a X, Y coordinate point. • X field: The field in the table that contains the X-coordinate or longitude data. • Y field: The field in the table that contains the Y-coordinate or latitude data.

Querying tables • Select records that meet your criteria • define selection criteria with the Query Builder • specify a field, operator, and value Query button

Create a new selected set Add records to the selected set Select records from the selected set Select all Select none Switch selection Modifying the selection • Build a new query • Use buttons

Query Expression • strings are always quoted • use * as a multiple character wildcard • use ? as a single character wildcard • compare the values of two fields • use AND when both expressions must be true • use OR when at least one expression must be true • use the NOT operator to exclude • calculations can be included in queries • date fields follow the yyyymmdd format • boolean fields are either true or false

Using ArcView tables