Network Data Model

The data model presented in this section pertains only to the structure of the database and general information about the usefulness of specific fields, especially those not used by Polaris itself.

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

Geometry-enabled tables

• zone table structure
• transit walk table structure
• transit stops table structure
• transit routes table structure
• transit patterns table structure
• transit pattern mapping table structure
• transit links table structure
• transit bike table structure
• parking table structure
• node table structure
• migrations table structure
• micromobility docks table structure
• location table structure
• link table structure
• ev charging stations table structure
• connection table structure

Pure data tables

• use code table structure
• turn overrides table structure
• transit zones table structure
• transit trips schedule table structure
• transit trips table structure
• transit pattern links table structure
• transit modes table structure
• transit fare rules table structure
• transit fare attributes table structure
• transit agencies table structure
• traffic incident table structure
• toll pricing table structure
• timing nested records table structure
• timing table structure
• signal nested records table structure
• signal table structure
• sign table structure
• roadsideunit table structure
• pocket table structure
• phasing nested records table structure
• phasing table structure
• migrations table structure
• micromobility agencies table structure
• location parking table structure
• location links table structure
• link type table structure
• link overrides table structure
• land use table structure
• ev charging station service bays table structure
• ev charging station pricing table structure
• ev charging station plugs table structure
• ev charging station plug types table structure
• electricity provider pricing table structure
• electricity provider table structure
• electricity grid transmission table structure
• editing table table structure
• county skims table structure
• area type table structure
• about model table structure