You are here

2014 NCFO Data Dictionary

PDF

Table: Operator

Field Name Description Format Length Value
OPERATOR_ID A unique numeric identifier assigned to each ferry operator NUMERIC (4.0) 4 Jan-99
OPERATOR_NAME The complete company name of the ferry operator CHARACTER 120 Text
OP_STRCITY City for the ferry operator mailing address CHARACTER 40 Text
OP_STATE State for the ferry operator mailing address CHARACTER 20 Text
OP_STRZIP Zip code for the ferry operator mailing address CHARACTER 10 Text
URL Company Web Site CHARACTER 120 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
FEDERAL_STATE_LOCAL Completing the census on behalf of a federal, state or local govt. agency. NUMERIC (1.0) 1 0 - No
1 – Yes
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
FEDERAL_FUNDING_REVENUE Percentage of annual revenues from direct public funding NUMERIC (5.2) 5 0.00 - 100.00
STATE_FUNDING_REVENUE Percentage of annual revenues from direct public funding NUMERIC (5.2) 5 0.00 - 100.00
LOCAL_FUNDING_REVENUE Percentage of annual revenues from direct public funding NUMERIC (5.2) 5 0.00 - 100.00
PUBLIC_FUNDING_TYPE_1 Public funding type 1 NUMERIC (1.0) 1 0 - Federal
1 – State
2 - Local
PUBLIC_FUNDING_SOURCE_1 Name of public funding agency 1 CHARACTER 150 Text
PUBLIC_FUNDING_PROGRAM_1 Name of public funding program 1 CHARACTER 150 Text
PUBLIC_FUNDING_TYPE_2 Public funding type 2 NUMERIC (1.0) 1 0 - Federal
1 – State
2 - Local
PUBLIC_FUNDING_SOURCE_2 Name of public funding agency 2 CHARACTER 150 Text
PUBLIC_FUNDING_PROGRAM_2 Name of public funding program 2 CHARACTER 150 Text
PUBLIC_FUNDING_TYPE_3 Public funding type 3 NUMERIC (1.0) 1 0 - Federal
1 – State
2 - Local
PUBLIC_FUNDING_SOURCE_3 Name of public funding agency 3 CHARACTER 150 Text
PUBLIC_FUNDING_PROGRAM_3 Name of public funding program 3 CHARACTER 150 Text
PUBLIC_FUNDING_TYPE_4 Public funding type 4 NUMERIC (1.0) 1 0 - Federal
1 – State
2 - Local
PUBLIC_FUNDING_SOURCE_4 Name of public funding agency 4 CHARACTER 150 Text
PUBLIC_FUNDING_PROGRAM_4 Name of public funding program 4 CHARACTER 150 Text
PUBLIC_FUNDING_TYPE_5 Public funding type 5 NUMERIC (1.0) 1 0 - Federal
1 – State
2 - Local
PUBLIC_FUNDING_SOURCE_5 Name of public funding agency 5 CHARACTER 150 Text
PUBLIC_FUNDING_PROGRAM_5 Name of public funding program 5 CHARACTER 150 Text
PUBLIC_FUNDING_TYPE_6 Public funding type 6 NUMERIC (1.0) 1 0 - Federal
1 – State
2 - Local
PUBLIC_FUNDING_SOURCE_6 Name of public funding agency 6 CHARACTER 150 Text
PUBLIC_FUNDING_PROGRAM_6 Name of public funding program 6 CHARACTER 150 Text
PUBLIC_FUNDING_TYPE_7 Public funding type 7 NUMERIC (1.0) 1 0 - Federal
1 – State
2 - Local
PUBLIC_FUNDING_SOURCE_7 Name of public funding agency 7 CHARACTER 150 Text
PUBLIC_FUNDING_PROGRAM_7 Name of public funding program 7 CHARACTER 150 Text
PUBLIC_FUNDING_TYPE_8 Public funding type 8 NUMERIC (1.0) 1 0 - Federal
1 – State
2 - Local
PUBLIC_FUNDING_SOURCE_8 Name of public funding agency 8 CHARACTER 150 Text
PUBLIC_FUNDING_PROGRAM_8 Name of public funding program 8 CHARACTER 150 Text
PUBLIC_FUNDING_TYPE_9 Public funding type 9 NUMERIC (1.0) 1 0 - Federal
1 – State
2 - Local
PUBLIC_FUNDING_SOURCE_9 Name of public funding agency 9 CHARACTER 150 Text
PUBLIC_FUNDING_PROGRAM_1 Name of public funding program 9 CHARACTER 150 Text
PUBLIC_FUNDING_TYPE_10 Public funding type 10 NUMERIC (1.0) 1 0 - Federal
1 – State
2 - Local
PUBLIC_FUNDING_SOURCE_10 Name of public funding agency 10 CHARACTER 150 Text
PUBLIC_FUNDING_PROGRAM_10 Name of public funding program 10 CHARACTER 150 Text
SURVEYYEAR Year of survey DATE (yyyy) 4 2014

Description: The Operators data table contains information about ferry operators and details about their operation.

 

Table: Vessel

Field Name Description Field Type Field Value
Length
VESSEL_ID A unique numeric identifier assigned to each vessel NUMERIC (10.0) 10 1 - 9999999999
OPERATOR_ID Ferry Operator ID for operator of vessel NUMERIC (4.0) 4 Jan-99
VESSEL_NAME Vessel Name CHARACTER 40 Text
USCG_NUMBER The official vessel number assigned by the USCG. CHARACTER 20 Text
IN_SERVICE Indicates whether the vessel is service during the census year NUMERIC (1.0) 1 0 - No
1 – Yes
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
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
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
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
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
MAINHORSEPOWERAHEAD Main Horsepower Ahead NUMERIC (7.0) 7 0 – 9999999
MAINHORSEPOWERASTERN Main Horsepower Astern NUMERIC (7.0) 7 0 – 9999999
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
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
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
SURVEYYEAR Year of survey DATE (yyyy) 4 2000, 2006, 2008, 2010
VESSEL_OWNERSHIP Indicates if the ferry vessel is publicly or privately owned. NUMERIC (1.0) 1 0 - Publicly Owned
1- Privately Owned
2 - Unknown
VESSEL_OWNED_BY Name of public agency who owns the vessel CHARACTER 150 Text
VESSEL_OPERATION Indicates if the ferry vessel is publicly or privately operated. NUMERIC (1.0) 1 0 - Publicly Operated
1 - Privately Operated
2 - Unknown
VESSEL_OPERATED_BY Name of public agency or operates the vessel CHARACTER 150 Text
FUEL_MILEAGE Fuel mileage of the vessel in miles per gallon CHARACTER 10 Text
ADA_ACCESSIBLE Indicates whether the vessel is accessible to Americans with Disabilities. NUMERIC (1.0) 1 0 - No
1 – Yes
ENGINE_LIFESPAN Lifespan of the vessel engine(s) in hours since last rebuild. NUMERIC (7.0) 7 0 – 9999999
ENGINE_HOURS Engine hours on the vessel since last rebuild. NUMERIC (7.0) 7 0 – 9999999
CENSUS_YEAR_MILES Nautical miles vessel traveled in census year NUMERIC (7.0) 7 0 – 9999999

Description: The Vessels data table contains information about ferry vessels such as USCG number, passenger and/or vehicle capacity, speed, and fuel type.

 

Table: Terminal

Field Name Description Field Type Field Value
Length
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
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
LATITUDE Position of the ferry terminal, in degrees of latitude NUMERIC(10.5) 10 -99999.999999 – 99999.999999
LONGITUDE Position of the ferry terminal, in degrees of longitude NUMERIC(10.5) 10 -99999.999999 – 99999.999999
PARKING Indicates whether parking is available at the ferry terminal NUMERIC (1.0) 1 0 - Not available
1 - Available
2 - Unknown
LOCAL_BUS Indicates whether local bus is available at the ferry terminal NUMERIC (1.0) 1 0 - Not available
1 - Available
2 - Unknown
INTERCITY_BUS Indicates whether intercity bus is available at the ferry terminal NUMERIC (1.0) 1 0 - Not available
1 - Available
2 - Unknown
LOCAL_RAIL Indicates whether local rail is available at the ferry terminal NUMERIC (1.0) 1 0 - Not available
1 - Available
2 - Unknown
INTERCITY_RAIL Indicates whether intercity rail is available at the ferry terminal NUMERIC (1.0) 1 0 - Not available
1 - Available
2 - Unknown
TERMINAL_OWNERSHIP Indicates if the ferry vessel is publicly or privately owned. NUMERIC (1.0) 1 0 - Publicly Owned
1- Privately Owned
2 - Unknown
TERMINAL_OWNED_BY Name of public agency who owns the vessel CHARACTER 150 Text
TERMINAL_OPERATION Indicates if the ferry vessel is publicly or privately operated. NUMERIC (1.0) 1 0 - Publicly Operated
1 - Privately Operated
2 - Unknown
TERMINAL_OPERATED_BY Name of public agency or operates the vessel CHARACTER 150 Text
SURVEYYEAR Year of survey DATE (yyyy) 4 2000, 2006, 2008, 2010

Description: The Terminals data table contains information about ferry terminals, their location, and facilities.

 

Table: SEGMENT

Field Name Description Field Type Field Value
Length
SEGMENT_ID Numeric identifier assigned to each ferry route segment NUMERIC (4.0) 4 Jan-99
SEGMENT_NAME Name of the segment CHARACTER 200 Text
SEG_TERMINAL1_ID The unique numeric identifier for the ferry terminal located at the start of the route segment. NUMERIC (4.0) 4 Jan-99
SEG_TERMINAL2_ID The unique numeric identifier for the ferry terminal located at the end of the route segment. NUMERIC (4.0) 4 Jan-99
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
SURVEYYEAR Year of the Survey DATE (yyyy) 4 2000, 2006, 2008, 2010, 2014

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.

 

Table: OPERATOR SEGMENT

Field Name Description Format Length Value
SEGMENT_ID A unique numeric identifier assigned to each ferry route segment NUMERIC (4.0) 4 1 – 9999
OPERATOR_ID ID of the Operator that provides service for the terminal NUMERIC (4.0) 4 1 – 9999
SEG_LENGTH Segment length in nautical miles NUMERIC (10.2) 10 0.00 - 99999999.99
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
ROUTE_RATES_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
ROUTE_RATE_REGULATOR Name of agency or agencies which regulate fares CHARACTER 150 Text
VESSEL1_NAME Name of vessel used most often for the route. CHARACTER 40 Text
VESSEL1_ID ID of vessel used most often for the route. NUMERIC (10.0) 10 1 - 9999999999
VESSEL2_NAME Name of vessel used second most often for the route. CHARACTER 40 Text
VESSEL2_ID ID of vessel used second most often for the route. NUMERIC (10.0) 10 1 - 9999999999
VESSEL3_NAME Name of vessel used third most often for the route. CHARACTER 40 Text
VESSEL3_ID ID of vessel used third most often for the route. NUMERIC (10.0) 10 1 - 9999999999
TRIPS_PER_DAY_SUN Average number of trips operated over this segment on Sunday in 2009 NUMERIC (3.0) 3 0 - 999
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
PASSENGERS Census year total passenger boardings NUMERIC (12.0) 12 0 - 999999999999
VEHICLES Census year total vehicle boardings NUMERIC (12.0) 12 0 - 999999999999
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
VESSEL1_ID Most frequently used vessel NUMERIC (4.0) 4 0 - 9999
VESSEL2_ID Second most frequently used vessel NUMERIC (4.0) 4 0 - 9999
VESSEL3_ID Third most frequently used vessel NUMERIC (4.0) 4 0 - 9999
SURVEYYEAR Year of survey DATE (yyyy) 4 2000, 2006, 2008, 2010

Description: The data table contains information related to route segments such as ferry operators who provide service, segment length, average trip time, passenger volume, and season start and end dates.