Trans CAD Managing Data Tables 2232021 1 Create

Trans. CAD Managing Data Tables 2/23/2021 1

Create a New Table 2/23/2021 2

Add a field Delete a field Change the field order Change a field name Use a display name Change a field type Change a field width Change the number of decimals Set a default value in new records Change a field format Change a field description Index a field Change the aggregation method 2/23/2021 3

Adding Records to a New Table 2/23/2021 4

Adding Records to a New Table ¬ Adding a Fixed Number of Records – If you know how many records you want to store in the new table, you can tell Trans. CAD to add that number of blank records to the table. ¬ Adding Matching Records – Use this option when you want to store additional columns of information about records or map features in a new table. The Matching Records option automatically adds one matching record for each record or feature in the original dataview. 2/23/2021 5

Adding Records to a New Table ¬Adding a Record for Each Unique Value of a Field – Use this option when you want to create a lookup table that adds new information to a map layer or dataview. To use this option, you must choose: • The map layer or dataview you want to examine. • The field whose values you want to use. Trans. CAD adds this field to the new table. 2/23/2021 6

Modify the Structure of a Table 2/23/2021 7

Working with Codes ¬ Often a database will contain shorthand codes that have a particular meaning. Using codes saves space because long character strings are replaced with shorter codes. ¬ To replace shorthand codes with descriptive text, you create a lookup table and attach it to the original table. A look up table is simply a table that contains the field names, the shorthand codes, and the descriptive text you eant to see displayed. 2/23/2021 8

Attach Codes Lookup Table – All of the column data type has to be character as well as the column contains codes 2/23/2021 9

2/23/2021 10

Double Click 2/23/2021 11

Create a Lookup Table From a Dataview 2/23/2021 12

Create a New Table from a Dataview Marking Column 2/23/2021 13

Creating a Table from an Excel File 2/23/2021 14

2/23/2021 15

About Dictionary Files ¬ Tables in fixed-format ¬ When you create a table in text, fixed-format binary, one of these formats, and comma- and tab. Trans. CAD automatically separated text format creates the dictionary file. require an additional file ¬ Dictionary files have the called the dictionary file. same file name as the data The dictionary file serves file and an extension of: as a header and tells –. DCT for a fixed-format text Trans. CAD where to look file in the data file for the –. DCC for a comma- or tabseparated text file different fields of data. 2/23/2021 –. DCB for a fixed-fromat binary file 16