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
- Slides: 16