Freight data model#
Freight data is stored in an SQLite database called “ModelName-Freight.sqlite”. This section will document the structure and purpose of the tables in that database.
Conventions#
A few conventions have been adopted in the definition of the data model and some are listed below:
Geometry field is always called geo
Projection is always planar and in meters
Tables required by the data model have capital first letter
ID columns are named similarly to the table but lower case (i.e. the railport column in the Railport table is the unique key column)
Foreign key columns are also similarly named (i.e. the ‘firm’ column in the Establishment table is a foreign key to the firm ID column in the Firm table)```
Data tables#
- about model table structure
- airport table structure
- airport locations table structure
- county skims table structure
- delivery table structure
- establishment table structure
- firm table structure
- international port table structure
- international port locations table structure
- migrations table structure
- naics landuses table structure
- port share table structure
- rail operator table structure
- rail operator counties table structure
- rail operator railports table structure
- railport table structure
- railport locations table structure
- shipment table structure
- shipment delivery table structure
- shipment legs table structure
- trade flow table structure
- truck poe table structure