Demand Database#
The Demand submodule of polaris-studio uses the same database management layer as the Supply module but is significantly less mature in terms of its capabilities for manipulation of the database and for ensuring consistency.
Demand Data Model#
Demand data for polaris is generally stored in a sqlite database called “ModelName-Demand.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
Pure data tables#
- vintage type table structure
- vehicle type table structure
- vehicle class table structure
- vehicle table structure
- trip table structure
- traveler table structure
- transit vehicle links table structure
- transit vehicle table structure
- tnc trip table structure
- tnc servicing table structure
- tnc request table structure
- selection table structure
- powertrain type table structure
- planned activity table structure
- plan table structure
- person gaps table structure
- person table structure
- path units table structure
- path multimodal links table structure
- path multimodal table structure
- path links table structure
- path table structure
- parking records table structure
- mode table structure
- mm trip table structure
- migrations table structure
- industry make use table structure
- household table structure
- fuel type table structure
- freight shipment table structure
- freight delivery table structure
- fleet table structure
- firms table structure
- ev features table structure
- ev charging table structure
- establishments attributes table structure
- establishments table structure
- connectivity type table structure
- automation type table structure
- activity type table structure
- activity table structure
- about model table structure