1 / 21

Using ArcView tables

Learn to create, edit, and analyze tables in ArcView to manage data efficiently. Add, join, and calculate fields, and create charts for better visualization. Master querying tables using various criteria and optimizing selections for accurate results.

nlangdon
Download Presentation

Using ArcView tables

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

More Related