2010 NCFO Query Database Schema
Table Name: T_Ferry_Operator
Table Description: The Operators data table contains information about ferry operators and details about their operation.
Field Name | Description | Format | Length | Value |
---|---|---|---|---|
SURVEYYEAR | Year of survey | DATE (yyyy) | 4 | 2000, 2006, 2008, 2010 |
OPERATOR_ID | A unique numeric identifier assigned to each ferry operator | NUMERIC (4.0) | 4 | 1 - 9999 |
OPERATOR_NAME | The complete company name of the ferry operator | CHARACTER | 120 | Text |
PUBLIC_PRIVATE | Indicates if the ferry operation publicly or privately owned | NUMERIC (1.0) | 1 | 0 -
Publicly Owned 1- Privately Owned 2 - Both Public and Private 3 - Unknown |
OPERATION_TYPE | Indicates if the ferry operation is publicly or privately operated | NUMERIC (1.0) | 1 | 0 -
Publicly Operated 1 - Privately Operated 2 - Both Public and Private 3 - Unknown |
RATE_REGULATED | Indicates if the rates are regulated by a governing body, a government agency or state or local legislation | NUMERIC (1.0) | 1 | 0 -
Not Regulated 1 - Regulated 2 - Unknown |
RATE_REGULATED_BY | Name of agency or agencies which regulate fares | CHARACTER | 150 | Text |
URL | Company Web Site | CHARACTER | 120 | Text |
OP_STRCITY | City for the ferry operator street address | CHARACTER | 40 | Text |
OP_STATE | State for the ferry operator street address | CHARACTER | 20 | Text |
OP_STRZIP | Zip code for the ferry operator street address | CHARACTER | 10 | Text |
OPERATORCOUNTRY | Country for the ferry operator street address | CHARACTER | 40 | Text |
TICKET _REVENUE | Percentage of annual revenues from individual purchased tickets or fares (including fare cards) | NUMERIC (5.2) | 5 | 0.00 - 100.00 |
PRIVATE_CONTRACT_REVENUE | Percentage of annual revenues from private contracts payment | NUMERIC (5.2) | 5 | 0.00 - 100.00 |
ADVERTISING_REVENUE | Percentage of annual revenues from advertising contracts payment | NUMERIC (5.2) | 5 | 0.00 - 100.00 |
PUBLIC_CONTRACT_REVENUE | Percentage of annual revenues from contracts with public agencies | NUMERIC (5.2) | 5 | 0.00 - 100.00 |
PUBLIC_FUNDING_REVENUE | Percentage of annual revenues from direct public funding | NUMERIC (5.2) | 5 | 0.00 - 100.00 |
Table Name: T_Ferry_Vessel
Table Description: The Vessels data table contains information about ferry vessels such as USCG number, passenger and/or vehicle capacity, speed, and fuel type.
Field Name | Description | Field Type | Field Length | Value |
---|---|---|---|---|
VESSEL_ID | A unique numeric identifier assigned to each vessel | NUMERIC (10.0) | 10 | 1 - 9999999999 |
VESSEL_NAME | Vessel Name | CHARACTER | 40 | Text |
USCG_NUMBER | The official vessel number assigned by the USCG. | CHARACTER | 20 | Text |
OPERATOR_ID | Ferry Operator ID for operator of vessel | NUMERIC (4.0) | 4 | 1 - 9999 |
TYPICAL_SPEED | Vessel Typical Operating Speed (in knots) | NUMERIC (5.2) | 5 | 0.00 - 999.99 |
LANE_FEET | Lane feet of car deck on RoRo Vessels | NUMERIC (5.0) | 5 | 0-99999 |
PASSENGER_CAPACITY | Passenger capacity of the vessel | NUMERIC (10.0) | 10 | 0 - 9999999999 |
VEHICLE_CAPACITY | Vehicle capacity of the vessel | NUMERIC (10.0) | 10 | 0 - 9999999999 |
CARRIES_PASSENGERS | Indicates whether the vessel carried passengers. | NUMERIC (1.0) | 1 | 0 -
No 1 – Yes |
CARRIES_VEHICLES | Indicates whether the vessel carried vehicles | NUMERIC (1.0) | 1 | 0 -
No 1 – Yes |
CARRIES_FREIGHT | Indicates whether the vessel carried freight | NUMERIC (1.0) | 1 | 0 -
No 1 – Yes |
FUEL_TYPE | Fuel type (Diesel, Gasoline, CNG, Electricity, Other) | NUMERIC (1.0) | 1 | 0 -
Unknown
1 - Diesel 2 - Gasoline 3 - CNG 4 - Electric 5 - Other |
FUEL_OTHER | Description of Other type of fuel | CHARACTER | 50 | Text |
VESSELBUILDYEAR | Year the vessel was built | DATE (yyyy) | 4 | 0000 - 9999 |
YEARREBUILT | Contains either the year that the vessel was rebuilt or is blank | DATE (yyyy) | 4 | 0000 - 9999 |
HIGHEST_FIXED_POINT | The height of the highest fixed point on the vessel in unit of feet | NUMERIC (7,2) | 7 | 0.00– 99999.99 |
HORSEPOWER | Horsepower rating for the vessel, typically when new or when current engines were installed | NUMERIC (7.0) | 7 | 0 – 9999999 |
MAINHORSEPOWERAHEAD | Main Horsepower Ahead | NUMERIC (7.0) | 7 | 0 – 9999999 |
MAINHORSEPOWERASTERN | Main Horsepower Astern | NUMERIC (7.0) | 7 | 0 – 9999999 |
HULLTYPE | Style of hull design | NUMERIC (1.0) | 1 | 0 -
Unknown
1 - Monohull 2 - Catamaran 3 - Other Multi-Hull 4 - SWATH 5 - Hydrofoil 6 - Other |
HULLOTHER | If "Other" hull type indicated, specifies hull type | CHARACTER | 50 | Text |
HULLMATERIAL | Type of hull Material | NUMERIC (1.0) | 1 | 0 - Unknown
1 - Aluminum 2 - Concrete 3 - FRP (Fiberglass) 4 - Glass 5 - Plastic (non-reinforced) 6 - Plastic - MSIS Legacy 7 - Rubber 8 - Steel 9 - Wood 10 - Other |
HULLSHAPE | Hull Shape | NUMERIC (1.0) | 1 | 0 - Unknown 1 - Box 2 - Sail (Distinct Keel) 3 - Sail (Faired Keel) 4 - Ship |
VTCC | The Vessel Type, Construction and Characteristics (VTCC) code, as indicated in the 1997 US Army Corps Waterborne Transportation Lines of the United States vessel characteristics database | CHARACTER | 50 | Text |
PROPULSIONTYPE | Propulsion type | NUMERIC (1.0) | 1 | 0 -
Unknown
1 - Fixed Pitch Propeller 2 - Controllable Pitch Prop 3 - Water Jet 4 - Cable 5 - Auxiliary Sail 6 - Combination Types 7 - Diesel 8 - Diesel Direct 9 - Diesel Electric 10 - Diesel Outdrive 11 - Diesel Reduction 12 - Electric Motor 13 - Gas Turbine 14 - Gasoline Engine 15 - Gasoline Inboard 16 - Gasoline Outboard 17 - Inboard/Outboard 18 - Jet Drive 19 - Manual 20 - Sail 21 - Steam Reciprocating 22 - Steam Turbine 23 - Steam Turboelectric 24 - Other |
PROPULSIONOTHER | Description of other propulsion type | CHARACTER | 50 | Text |
SELFPROPINDICATOR | Self Propelled Indicator | NUMERIC (1.0) | 1 | 0 - Vessel not self-propelled 1 - Vessel self-propelled 2 - Unknown |
REGISTEREDBREADTH | Registered breadth, reported in units of feet to the nearest tenth. | NUMERIC (4.1) | 4 | 0.0 – 999.9 |
REGISTEREDDEPTH | Registered depth (draft), reported in units of feet to the nearest tenth. | NUMERIC (4.1) | 4 | 0.0 – 999.9 |
REGISTEREDLENGTH | Registered length, reported in units of feet to the nearest tenth. | NUMERIC (4.1) | 4 | 0.0 – 999.9 |
REGISTEREDGROSSTONS | Registered gross tons. | NUMERIC (5.0) | 5 | 0 – 99999 |
REGISTEREDNETTONS | Registered Net Tons | NUMERIC (5.0) | 5 | 0 – 99999 |
OVERALLBREADTH | The overall breadth of the vessel is reported in units of feet. The overall breadth is the extreme breadth of maximum breadth to the outside of the vessel's structure. In paddle ships, this includes the paddle boxes. | NUMERIC (4.1) | 4 | 0.0 – 999.9 |
OVERALLLENGTH | The overall length of the vessel is reported in units of feet. The overall length is the extreme length of the vessel which would include any structure which extends beyond the outer planking or plating on the bow or any structure that extends beyond | NUMERIC (4.1) | 4 | 0.0 – 999.9 |
LIGHTDRAFT | The draft of the vessel when it is empty, reported in units of feet. | NUMERIC (3.1) | 3 | 0.0 – 99.9 |
LOADDRAFT | The draft of the vessel when fully loaded, reported in units of feet. | NUMERIC (3.1) | 3 | 0.0 – 99.9 |
PASSCAPARMYCORPS | Certificated Passenger capacity of the vessel from Army Corps Vessel Database | NUMERIC (5.0) | 5 | 0 – 99999 |
CAPACITYTONSARMYCORPS | The full load capacity of the vessel in short tons (2,000 lbs) from Army Corps Vessel Database | NUMERIC (5.0) | 5 | 0 – 99999 |
NETTONNAGE | Net Tonnage is defined as the volume of space available for the accommodation of passengers and the stowage of cargo, expressed in units of 100 cubic feet for each net ton. | NUMERIC (4.0) | 4 | 0 – 9999 |
IN_SERVICE | Indicates whether the vessel is served in year 2009 | NUMERIC (1.0) | 1 | 0 -
No 1 – Yes |
SURVEYYEAR | Year of survey | DATE (yyyy) | 4 | 2000, 2006, 2008, 2010 |
Table Name: T_Ferry_Terminal
Table Description: The Terminals data table contains information about ferry terminals, their location, and facilities.
Field Name | Description | Field Type | Field Length | Value |
---|---|---|---|---|
TERMINAL_ID | A unique numeric identifier assigned to each ferry terminal | NUMERIC (4.0) | 4 | 1 – 9999 |
TERMINAL_NAME | Ferry terminal name | CHARACTER | 80 | Text |
TERMINALCBSACODE | Census Bureau Core Based Statistical Area Code | NUMERIC (5.0) | 5 | 0 - 99999 |
TERMINALCBSATYPE | Indicates whether CBSA is a Metropolitan Statistical Area (at least one urbanized area of 50,000+ population), or Micropolitan Statistical Area (at least one urbanized area of 10,000-50,000 population) | NUMERIC (1.0) | 1 | 0 –
Neither 1 – Metropolitan 2 – Micropolitan |
TERM_CITY | City in which the ferry terminal is located | CHARACTER | 40 | Text |
TERM_STATE | State or province in which the ferry terminal is located | CHARACTER | 20 | Text |
TERM_COUNTRY | Country in which the ferry terminal is located. | CHARACTER | 30 | Text |
TERM_ZIPCODE | Zip code in which the ferry terminal is located. | CHARACTER | 10 | Text |
LATITUDE | Position of the ferry terminal, in degrees of latitude | NUMERIC(10.5) | 10 | -99999.99999 – 99999.99999 |
LONGITUDE | Position of the ferry terminal, in degrees of longitude | NUMERIC(10.5) | 10 | -99999.99999 – 99999.99999 |
PARKING |
Indicates whether parking is available at the ferry terminal | NUMERIC (1.0) | 1 | 0 - Not available 1 - Available 2 - Unknown 3 - On-site 4 - Nearby (1/4 mile) 5 - Within the city 6 - Not within the city |
LOCAL_BUS | Indicates whether local bus is available at the ferry terminal | NUMERIC (1.0) | 1 | 0 - Not available 1 - Available 2 - Unknown 3 - On-site 4 - Nearby (1/4 mile) 5 - Within the city 6 - Not within the city |
INTERCITY_BUS | Indicates whether intercity bus is available at the ferry terminal | NUMERIC (1.0) | 1 | 0 - Not available 1 - Available 2 - Unknown 3 - On-site 4 - Nearby (1/4 mile) 5 - Within the city 6 - Not within the city |
LOCAL_RAIL | Indicates whether local rail is available at the ferry terminal | NUMERIC (1.0) | 1 | 0 - Not available 1 - Available 2 - Unknown 3 - On-site 4 - Nearby (1/4 mile) 5 - Within the city 6 - Not within the city |
INTERCITY_RAIL | Indicates whether intercity rail is available at the ferry terminal | NUMERIC (1.0) | 1 | 0 - Not available 1 - Available 2 - Unknown 3 - On-site 4 - Nearby (1/4 mile) 5 - Within the city 6 - Not within the city |
FREIGHTRAIL | For railroad car float terminals, indicates whether freight rail service is available at the ferry terminal. | NUMERIC (1.0) | 1 | 0 - Not available 1 - Available 2 - Unknown 3 - On-site 4 - Nearby (1/4 mile) 5 - Within the city 6 - Not within the city |
OTHERSERVICE | Describes other type of ground transportation service available at the ferry terminal, if indicated. | NUMERIC (1.0) | 1 | 0 - Not available
1 - Available 2 - Unknown 3 - On-site 4 - Nearby (1/4 mile) 5 - Within the city 6 - Not within the city |
OTHERRAILSERVICE | For railroad car float terminals, describes the other type of ground transportation service available at the ferry terminal, if indicated. | CHARACTER | 50 | Text |
SURVEYYEAR | Year of survey | DATE (yyyy) | 4 | 2000, 2006, 2008, 2010 |
ACTIVE | Indicate whether a terminal is active or not in a survey | NUMERIC (1.0) | 1 | 0 -
No 1 – Yes |
Table Name: T_FERRY_TERMINAL_VENDOR
Table Description: The Terminal Vendor data table contains information about other business entities (such as food service concessionaires, car rental companies, facility operator, etc) that utilized the terminal facility.
Field Name | Description | Field Type | Field Length | Value |
---|---|---|---|---|
VENDOR_ID | A unique numeric identifier assigned to each ferry terminal vendor | NUMERIC (4.0) | 4 | 1 – 9999 |
VENDOR_NAME | Business Name of the ferry terminal vendor | CHARACTER | 80 | Text |
VENDOR_SERVICE | Type of business operated by vendor | CHARACTER | 200 | Text |
TERMINAL_ID | Unique numeric terminal identifier (from Terminal Table) of the terminal where the vendor is located | NUMERIC (4.0) | 4 | 1 – 9999 |
SURVEYYEAR | Year of survey | DATE (yyyy) | 4 | 2000, 2006, 2008, 2010 |
Table Name: T_FERRY_OPERATOR_SEGMENT
Table Description: The data table contains information related to route segments such as ferry operators who provide service, segment length, average trip time, passenger volume, peak season, surge ridership period and season start and end dates.
Field Name | Description | Format | Length | Value |
---|---|---|---|---|
OPERATOR_ID | ID of the Operator that provides service for the terminal | NUMERIC (4.0) | 4 | 1 – 9999 |
SEGMENT_ID | A unique numeric identifier assigned to each ferry route segment | NUMERIC (4.0) | 4 | 1 – 9999 |
AVERAGE_TRIP_TIME | Average trip time for the segment | Time(hh:mm) | 5 | 00:00 – 99:59 |
SEASON_START | The seasonal service start date | DATE (mm/dd) | 5 | 01/01 – 12/31 |
SEASON_END | The seasonal service end date | DATE (mm/dd) | 5 | 01/01 – 12/31 |
PASSENGERS | Total passenger boardings in 2009 | NUMERIC (12.0) | 12 | 0 - 999999999999 |
VEHICLES | Total vehicle boardings in 2009 | NUMERIC (12.0) | 12 | 0 - 999999999999 |
SEG_LENGTH | Segment length in nautical miles | NUMERIC (10.2) | 10 | 0.00 - 99999999.99 |
TRIPS_PER_DAY_MON | Average number of trips operated over this segment on Monday in 2009 | NUMERIC (3.0) | 3 | 0 - 999 |
TRIPS_PER_DAY_TUE | Average number of trips operated over this segment on Tuesday in 2009 | NUMERIC (3.0) | 3 | 0 - 999 |
TRIPS_PER_DAY_WED | Average number of trips operated over this segment on Wednesday in 2009 | NUMERIC (3.0) | 3 | 0 - 999 |
TRIPS_PER_DAY_THU | Average number of trips operated over this segment on Thursday in 2009 | NUMERIC (3.0) | 3 | 0 - 999 |
TRIPS_PER_DAY_FRI | Average number of trips operated over this segment on Friday in 2009 | NUMERIC (3.0) | 3 | 0 - 999 |
TRIPS_PER_DAY_SAT | Average number of trips operated over this segment on Saturday in 2009 | NUMERIC (3.0) | 3 | 0 - 999 |
TRIPS_PER_DAY_SUN | Average number of trips operated over this segment on Sunday in 2009 | NUMERIC (3.0) | 3 | 0 - 999 |
AVG_DAILY_BRD_PAX | Average daily passenger boardings | NUMERIC (10.0) | 10 | 0 - 9999999999 |
AVG_DAILY_BRD_VEH | Average daily vehicle boardings | NUMERIC (10.0) | 10 | 0 - 9999999999 |
HIGHER_THAN_AVG_JAN | Peak season includes January | NUMERIC (1.0) | 1 | 0 -
No 1 - Yes |
HIGHER_THAN_AVG_FEB | Peak season includes February | NUMERIC (1.0) | 1 | 0 -
No 1 - Yes |
HIGHER_THAN_AVG_MAR | Peak season includes March | NUMERIC (1.0) | 1 | 0 -
No 1 - Yes |
HIGHER_THAN_AVG_APR | Peak season includes April | NUMERIC (1.0) | 1 | 0 -
No 1 - Yes |
HIGHER_THAN_AVG_MAY | Peak season includes May | NUMERIC (1.0) | 1 | 0 -
No 1 - Yes |
HIGHER_THAN_AVG_JUN | Peak season includes June | NUMERIC (1.0) | 1 | 0 -
No 1 - Yes |
HIGHER_THAN_AVG_JUL | Peak season includes July | NUMERIC (1.0) | 1 | 0 -
No 1 - Yes |
HIGHER_THAN_AVG_AUG | Peak season includes August | NUMERIC (1.0) | 1 | 0 -
No 1 - Yes |
HIGHER_THAN_AVG_SEP | Peak season includes September | NUMERIC (1.0) | 1 | 0 -
No 1 - Yes |
HIGHER_THAN_AVG_OCT | Peak season includes October | NUMERIC (1.0) | 1 | 0 -
No 1 - Yes |
HIGHER_THAN_AVG_NOV | Peak season includes November | NUMERIC (1.0) | 1 | 0 -
No 1 - Yes |
HIGHER_THAN_AVG_DEC | Peak season includes December | NUMERIC (1.0) | 1 | 0 -
No 1 - Yes |
SURGE_EXPERIENCE_MON | Monday has a surge in redership | NUMERIC (1.0) | 1 | 0 -
No 1 - Yes |
SURGE_EXPERIENCE_TUE | Tuesday has a surge in ridership | NUMERIC (1.0) | 1 | 0 -
No 1 - Yes |
SURGE_EXPERIENCE_WED | Wednesday has a surge in ridership | NUMERIC (1.0) | 1 | 0 -
No 1 - Yes |
SURGE_EXPERIENCE_THU | Thursday has a surge in ridership | NUMERIC (1.0) | 1 | 0 -
No 1 - Yes |
SURGE_EXPERIENCE_FRI | Friday has a surge in ridership | NUMERIC (1.0) | 1 | 0 -
No 1 - Yes |
SURGE_EXPERIENCE_SAT | Saturday has surge in ridership | NUMERIC (1.0) | 1 | 0 -
No 1 - Yes |
SURGE_EXPERIENCE_SUN | Sunday has a surge in ridership | NUMERIC (1.0) | 1 | 0 -
No 1 - Yes |
SURGE_AVG_BRD_PAX | Average passenger boardings during weekly ridership surge | NUMERIC (10.0) | 10 | 0 - 9999999999 |
SURGE_AVG_BRD_VEH | Average vehicle boardings during weekly ridership surge | NUMERIC (10.0) | 10 | 0 - 9999999999 |
WEEKDAY_AM_PK_START | Weekday AM peak period start time. | DATE (hh:mm) | 5 | 00:00 - 23:59 |
WEEKDAY_AM_PK_END | Weekday AM peak period end time. | DATE (hh:mm) | 5 | 00:00 - 23:59 |
WKD_AM_P_AVG_BRD_PAX | Average passenger boardings during weekday AM peak period | NUMERIC (10.0) | 10 | 0 - 9999999999 |
WKD_AM_P_AVG_BRD_VEH | Average vehicle boardings during weekday AM peak period | NUMERIC (10.0) | 10 | 0 - 9999999999 |
WEEKDAY_PM_PK_START | Weekday PM peak period start time | DATE (hh:mm) | 5 | 00:00 - 23:59 |
WEEKDAY_PM_PK_END | Weekday PM peak period end time | DATE (hh:mm) | 5 | 00:00 - 23:59 |
WKD_PM_P_AVG_BRD_PAX | Average passenger boardings during weekday PM peak period | NUMERIC (10.0) | 10 | 0-9999999999 |
WKD_PM_P_AVG_BRD_VEH | Average vehicle boardings during weekday PM peak period | NUMERIC (10.0) | 10 | 0-9999999999 |
SATURDAY_PEAK_START | Saturday peak period start time | DATE (hh:mm) | 5 | 00:00 - 23:59 |
SATURDAY_PEAK_END | Saturday peak period end time | DATE (hh:mm) | 5 | 00:00 - 23:59 |
SAT_PK_AVG_BRD_PAX | Average passenger boardings during Saturday peak period | NUMERIC (10.0) | 10 | 0-9999999999 |
SAT_PK_AVG_BRD_VEH | Average vehicle boardings during Saturday peak period | NUMERIC (10.0) | 10 | 0-9999999999 |
SUNDAY_PEAK_START | Sunday peak period start time | DATE (hh:mm) | 5 | 00:00 - 23:59 |
SUNDAY_PEAK_END | Sunday peak period end time (hh:mm) | DATE (hh:mm) | 5 | 00:00 - 23:59 |
SUN_PK_AVG_BRD_PAX | Average passengers boardings during Sunday peak period | NUMERIC (10.0) | 10 | 0-9999999999 |
SUN_PK_AVG_BRD_VEH | Average vehicles boardings during Sunday peak period | NUMERIC (10.0) | 10 | 0-9999999999 |
TRIPSPERDAY | Number of trips per day operated over this segment. | NUMERIC (3.0) | 3 | 0 - 999 |
DAYSPERWEEK | Number of days per week that service is provided on this segment. | NUMERIC (1.0) | 1 | 0 - 7 |
PEAK1MON | Indicates whether the Peak 1 ridership surge is normally experienced on Monday. | NUMERIC (1.0) | 1 | 1 –
No 2 - Yes |
PEAK1TUE | Indicates whether the Peak 1 ridership surge is normally experienced on Tuesday. | NUMERIC (1.0) | 1 | 1 –
No 2 - Yes |
PEAK1WED | Indicates whether the Peak 1 ridership surge is normally experienced on Wednesday. | NUMERIC (1.0) | 1 | 1 –
No 2 - Yes |
PEAK1THU | Indicates whether the Peak 1 ridership surge is normally experienced on Thursday. | NUMERIC (1.0) | 1 | 1 –
No 2 - Yes |
PEAK1FRI | Indicates whether the Peak 1 ridership surge is normally experienced on Friday. | NUMERIC (1.0) | 1 | 1 –
No 2 - Yes |
PEAK1SAT | Indicates whether the Peak 1 ridership surge is normally experienced on Saturday. | NUMERIC (1.0) | 1 | 1 –
No 2 - Yes |
PEAK1SUN | Indicates whether the Peak 1 ridership surge is normally experienced on Sunday. | NUMERIC (1.0) | 1 | 1 –
No 2 - Yes |
PEAK1STARTTIME | Indicates the time when the first routine ridership surge period of the day normally begins. | DATE (hh:mm) | 5 | 00:00 – 23:59 |
PEAK1ENDTIME | Indicates the time when the first routine ridership surge period of the day normally ends. | DATE (hh:mm) | 5 | 00:00 – 23:59 |
PEAK1PAX | Number of passenger boardings per day during the first peak period | NUMERIC (10.0) | 10 | 0-9999999999 |
PEAK1VEHICLES | Number of vehicle boardings per day during the first peak period | NUMERIC (10.0) | 10 | 0-9999999999 |
PEAK2MON | Indicates whether the Peak 2 ridership surge is normally experienced on Monday. | NUMERIC (1.0) | 1 | 1 –
No 2 - Yes |
PEAK2TUE | Indicates whether the Peak 2 ridership surge is normally experienced on Tuesday. | NUMERIC (1.0) | 1 | 1 –
No 2 - Yes |
PEAK2WED | Indicates whether the Peak 2 ridership surge is normally experienced on Wednesday. | NUMERIC (1.0) | 1 | 1 –
No 2 - Yes |
PEAK2THU | Indicates whether the Peak 2 ridership surge is normally experienced on Thursday. | NUMERIC (1.0) | 1 | 1 –
No 2 - Yes |
PEAK2FRI | Indicates whether the Peak 2 ridership surge is normally experienced on Friday. | NUMERIC (1.0) | 1 | 1 –
No 2 - Yes |
PEAK2SAT | Indicates whether the Peak 2 ridership surge is normally experienced on Saturday. | NUMERIC (1.0) | 1 | 1 –
No 2 - Yes |
PEAK2SUN | Indicates whether the Peak 2 ridership surge is normally experienced on Sunday. | NUMERIC (1.0) | 1 | 1 –
No 2 - Yes |
PEAK2STARTTIME | Indicates the time when the second routine ridership surge period of the day normally begins. | DATE (hh:mm) | 5 | 00:00 – 23:59 |
PEAK2ENDTIME | Indicates the time when the second routine ridership surge period of the day normally ends. | DATE (hh:mm) | 5 | 00:00 – 23:59 |
PEAK2PAX | Number of passenger boardings per day during the second peak period | NUMERIC (10.0) | 10 | 0-9999999999 |
PEAK2VEHICLES | Number of vehicle boardings per day during the second peak period | NUMERIC (10.0) | 10 | 0-9999999999 |
SURVEYYEAR | Year of survey | DATE (yyyy) | 4 | 2000, 2006, 2008, 2010 |
Table Name: T_FERRY_Segment
Table Description: The Segments data table contains information about each route segment such as the terminals it connects, the type geographic area it serves, and whether it serves a National Park Service location.
Field Name | Description | Field Type | Field Length | Value |
---|---|---|---|---|
SEGMENT_ID | Numeric identifier assigned to each ferry route segment | NUMERIC (4.0) | 4 | 1-9999 |
SEGMENT_NAME | Name of the segment | CHARACTER | 200 | Text |
SEG_TYPE | Indicates whether service on this segment is intrastate, interstate or international. | Number(1.0) | 1 | 1 –
Intrastate 2 – Interstate 3 - International |
SERVES_NPS | Indicates whether the segment serves a unit of the National Park System. | Number(1.0) | 1 | 0 –
No 1 – Yes |
SEG_TERMINAL1_ID | The unique numeric identifier for the ferry terminal located at one end of the route segment. | NUMERIC (4.0) | 4 | 1-9999 |
SEG_TERMINAL2_ID | The unique numeric identifier for the ferry terminal located at the other end of the route segment. | NUMERIC (4.0) | 4 | 1-9999 |
SURVEYYEAR | Year of the Survey | DATE (yyyy) | 4 | 2000, 2006, 2008, 2010 |