parking choice records table structure

Contents

parking choice records table structure#

A table for debugging the Parking choice model inputs.

Table Structure#

Field

Type

NULL allowed

Default Value

Foreign key

Description

id*

INTEGER

NO

auto id for all parking choices available for this parking event

choice_id

INTEGER

NO

0

Unique identifier of this parking choice id (to match with parking choice id in Parking Records)

person

INTEGER

NO

0

The person driving the vehicle (to match with person id in Person table)

choice_event_time

INTEGER

NO

0

Time of the parking event

is_depart_pk

INTEGER

NO

0

Boolean flag - if the person departed for the activity in peak-hour?

act_dur_hr

REAL

YES

0

Activity duration (hours)

female

INTEGER

NO

0

Boolean flag - if the person is female?

hhsize

INTEGER

NO

0

Household size of the person parking

ln_hhinc

REAL

YES

0

Natural logarithm of the household size

urgent

INTEGER

NO

0

Boolean flag - if this activity is urgent?

age_above_60

INTEGER

NO

0

Boolean flag - if the person is above 60 years?

ln_dest_empdens

REAL

YES

0

Natural logarithm of the activity zone employment density per acre

ln_dest_popdens

REAL

YES

0

Natural logarithm of the activity zone population density per acre

destination

INTEGER

NO

0

Destination of the activity (to match with location id in Location table)

type

INTEGER

NO

0

Type of parking Values at type.

distance_to_G

REAL

YES

0

Distance from destination to the garage (kilometers)

parking_fee

REAL

YES

0

Parking fee ($USD)

chosen

INTEGER

NO

0

Boolean flag - if this specifc parking was chosen as an output of the choice model?

garage_id

INTEGER

NO

0

Garage identifier (to match with parking id in Parking table)

reserved_or_not

INTEGER

NO

0

Boolean flag - if the parking was reserved or no?

num_garage_choices

INTEGER

NO

0

Number of garages with available capacity

garage_choices_existed

INTEGER

NO

0

Boolean flag - if there were any garages (even if full) nearby for the person to consider?

can_use_escooter

INTEGER

NO

0

Boolean flag - if the person is willing to use an escooter ?

(* - Primary key)

The SQL statement for table and index creation is below.

CREATE TABLE Parking_Choice_Records (
    "id"                        INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    "choice_id"                 INTEGER NOT NULL DEFAULT 0,
    "person"                    INTEGER NOT NULL DEFAULT 0,
    "choice_event_time"         INTEGER NOT NULL DEFAULT 0,
    "is_depart_pk"              INTEGER NOT NULL DEFAULT 0,
    "act_dur_hr"                REAL             DEFAULT 0,
    "female"                    INTEGER NOT NULL DEFAULT 0,
    "hhsize"                    INTEGER NOT NULL DEFAULT 0,
    "ln_hhinc"                  REAL             DEFAULT 0,
    "urgent"                    INTEGER NOT NULL DEFAULT 0,
    "age_above_60"              INTEGER NOT NULL DEFAULT 0,
    "ln_dest_empdens"           REAL             DEFAULT 0,
    "ln_dest_popdens"           REAL             DEFAULT 0,
    "destination"               INTEGER NOT NULL DEFAULT 0,
    "type"                      INTEGER NOT NULL DEFAULT 0,
    "distance_to_G"             REAL             DEFAULT 0,
    "parking_fee"               REAL             DEFAULT 0,
    "chosen"                    INTEGER NOT NULL DEFAULT 0,
    "garage_id"                 INTEGER NOT NULL DEFAULT 0,
    "reserved_or_not"           INTEGER NOT NULL DEFAULT 0,
    "num_garage_choices"        INTEGER NOT NULL DEFAULT 0,
    "garage_choices_existed"    INTEGER NOT NULL DEFAULT 0,
    "can_use_escooter"          INTEGER NOT NULL DEFAULT 0
);

Enums#

The following enums are used in this table.

type#

Enum Values Description#

Value

Name

Description

0

ONSTREET_PARKING

1

GARAGE_NEST

2

GARAGE_PARKING
Contents