Using ArcView tables

1. 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

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

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

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

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

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

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

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

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

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

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

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

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

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

15. Select a field • Display statistics for the field Displaying statistics

16. 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

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

18. 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.

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

20. 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

21. 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