Exporting tables

You can export records from the Table Viewer as CSV (comma separated values) or DBF (database format) files to save information from specific queries or to use in other applications. To export selections chose "Export CSV" or "Export to DBF" from the File menu and specify a filename. CSV is a common file format that is compatible with most spreadsheet and database applications. Only the selected records and visible columns will be exported. If zero records are selected then all rows in the attribute table will be exported.

[Tip]Tip

One useful application of the table exporting function combined with the query selection tool is that data from only one period can be selected and output for use in another application. For example, in the route table all road segements that were utilized for a specific period can be selected with the query tool. These route records can be exported as a csv file and used in combination with original GIS files. Active road segments can be added to a schedule map to indicate the exact road network for a given planning period.

[Tip]Tip

Be careful when you are exporting block table attributes into DBF format. DBF restricts the length of field names to 10 characters. This means that if you have a series of field names that all start with the same 10 characters, they will all be truncated to the same name. Some software (such as Microsoft Access) will not import a dataset with more than one field with the same name.

[Tip]Tip

Be careful when exporting CSV files containing commas in the values. Be aware that the entire value will be surrounded in quotations when exported.

[Tip]Tip

CSV format limits values to 255. Sometimes a value in the managedstrata or unmanagedstrata can exceed 255 characters and will be truncated.

[Tip]Tip

Some software, such as ArcMap, will not import datasets with periods (.) in the field names.