You are here

2010 NCFO Query Database Schema

2010 NCFO Query Database Schema

PDF

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