-
Notifications
You must be signed in to change notification settings - Fork 3
/
Copy pathtable ideas
116 lines (100 loc) · 2.88 KB
/
table ideas
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
TABLE IDEAS
hours_of_operations
- times
- corridor
calendar_dates
- weekdays
- saturday
- sunday
location facility
- lanes
- entrance lat/lng
- exit lat/lng
- extent (full length)
- Access Points
- toll sign lat/lng
- toll reader lat/lng
- type (bridge, express lane, ramp, toll road, tunnel, reversible lanes)
Facility_id: [
{id : "CLW", label : "calaveras westbound", direction: "WB" },
{id : "FSE", label : "first street eastbound", direction: "EB" }
]
facility_type:
- carpool lanes
- Ramp meters (future development and coordination with Caltrans)
- Carpool Ramp meters (subset of Ramp meter data, HOV lane at ramp meter)
- Express Lanes
- Toll Roads
- Bridges
- Tunnels
- Reversible Lanes (e.g. Lafayette St, City of Santa Clara)
facility_corridor_shapes (polyline)
- shape_id
- shape_pt_lat
- shape_pt_long
- shape_pt_sequence
- shape_dist_traveled
facilty_lane_type (ID - Lane Type) These could all be renamed, Lane 1, 2, 3, 4, 5, ....
- AL-All Lanes
- LEFTLANE-Left Lane
- LEFTLANE2-Two left lanes
- LEFTLANE3-Three left lanes
- MIDDLELANE-Middle Lane
- MIDDLELANE2-Two middle lanes
- MIDDLELANE3-Three middle lanes
- RIGHTLANE-Right lane
- RIGHTLANE2-Two Right Lanes
- RIGHTLANE3-Three Right Lanes
- CARPOOLLANE-Carpool lanes
toll_rates (describe dollar amounts, optional, used for fixed toll rates, based on vehicle axles)
- consume toll rate API for real time updates - https://github.com/vta/expresslanes-api
- update time rate, e.g. 5 minutes - normally referred to as interval
- toll rate range, e.g. $0.50 - $7.00
tolling_method (tolling application and collection)
- CASH - Cash
- PAYBYPLATE - Pay by (License) Plate
- FASTRAK - FasTrak - maybe AVI, automatic vehicle identification, tag reads, Fastrak
- TOLLBOOTH - Toll Booth
toll_rate_update
- Toll rate definition, HOV 2+, HOV 3+, CAV, clean air vehicle
- Toll rules
- Zones
- Alerts or closures
agency
- agency_name
- corridor
- agency_url
- agency_timezone
- agency_phone
- agency_toll_url
transponder_type
- single signal
- switchable
- distributor
- manufacturer
vehicle_exceptions
- electric (green (plugin hybrid) or white (cng, all electric)) - CAV
- carpool (2+, 3+)
- motorcycle
- transit (busses)
- emergency vehicles
vehicle_type (ID - Vehicle Type)
- AV - All Vehicles
- SOV- SOV : Single Occupancy Vehicles
- HOV2 - HOV 2+: High Occupancy Vehicles, 2 or more people
- HOV2OC - HOV 2 for vehicles that have maximum of 2 seats.
- HOV3 - HOV 3+: High Occupancy Vehicles, 3 or more people
- HOV4 - HOV 4+: High Occupancy Vehicles, 4 or more people
- HYBCARS - Hybrid Cars
- MOTORBIKE - Motor bikes
- BUS - Bus/Buses
- VANPOOL - Vanpools
- LOWEV - Low Emission Vehicles
- HIGHEV - High Emission Vehicles - refer to DMV
- TRAILER - Trailers
- AXLE2 - 2-Axle Vehicles
- AXLE3 - 3-Axle Vehicles
- AXLE4 - 4-Axle Vehicles
- AXLE5 - 5-Axle Vehicles
- AXLE6 - 6-Axle Vehicles
- MULTIAXLE - Multi-Axle Vehicles