Box C: Sample Data Elements for Separate but Linked Facilities (General Mitchell International Airport and Airport Rail Station, Milwaukee, WI )
Thursday, September 6, 2012
Box C: Sample Data Elements for Separate but Linked Facilities (General Mitchell International Airport and Airport Rail Station, Milwaukee, WI )
Data field | Airport terminal Record | Explanatory notes | Airport rail station terminal record |
---|---|---|---|
FACILITY_ID | WI5320701 | Separate facility ID's | WI5322101 |
AIRPORT_CODE | MKE | Airport code shown for both rail and air facility since both modes are considered to serve both facilities. | MKE |
AIRPORT_CODE2 | No secondary airport code for General Mitchell Int'l | ||
AMTRAK_STATION_CODE | MKA | Amtrak city code shown for both rail and air facility since both modes are considered to serve both facilities. | MKA |
FERRY_TERMINAL_CODE | Not applicable | ||
FACILITY_STATUS | 1 | 1=active | 1 |
DATE_UPDATED | 3/2/2007 | 9/25/2006 | |
ADDRESS | 5300 S. Howell Ave. | 5601 S. 6th Street | |
CITY | Milwaukee | Milwaukee | |
STATE | WI | WI | |
ZIPCODE | 53207 | 53221 | |
METRO_AREA | Milwaukee--Waukesha, WI | Milwaukee--Waukesha, WI | |
FACILITY_NAME | General Mitchell Int'l | General Mitchell Int'l | |
LONGITUDE | -87.897 | -87.925 | |
LATITUDE | 42.947 | 42.931 | |
FACILITY_TYPE | 1 | 1=Airport; 10=Intercity Rail | 10 |
FERRY_TRANSIT | 3 | 3=Mode does not serve this locale | 3 |
FERRY_INTERCITY | 3 | 3=Mode does not serve this locale | 3 |
BUS_TRANSIT | 1 | 1=Served by this mode (note--transit bus actually serves airport terminal, but because rail terminal and air terminal are linked by airport shuttle bus, connecting mode is considsered available at both facilities.) | 1 |
BUS_INTERCITY | 1 | same as BUS_TRANSIT | 1 |
BUS_CODE_SHARE | 3 | 3=Mode does not serve this locale | 3 |
BUS_SUPPLEMENTAL | 3 | 3=Mode does not serve this locale | 3 |
RAIL_INTERCITY | 1 | 1=Served by this mode (note--actually serves rail terminal, but because rail terminal and air terminal are linked by airport shuttle bus, mode is considered available at both facilities.) | 1 |
RAIL_COMMUTER | 3 | 3=Mode does not serve this locale | 3 |
RAIL_HEAVY | 3 | 3=Mode does not serve this locale | 3 |
RAIL_LIGHT | 3 | 3=Mode does not serve this locale | 3 |
AIR_SERVICE | 1 | 1=Served by this mode (note--actually serves air terminal, but because rail terminal and air terminal are linked by airport shuttle bus, mode is considered available at both facilities.) | 1 |
WEBSITE | www.mitchellairport.com | www.dot.state.wi.us/travel/rail/mars.htm | |
NOTES | Served by Amtrak (via airport shuttle bus), Badger bus, Milwaukee Transit System | Provides details of actual | Served by Amtrak, and airlines, Badger bus, Milwaukee Transit System via Airport Shuttle bus. |
DATA_SOURCE | Amtrak file, www.ridemcts.com, www.mitchellairport.com, www.badgerbus.com, | Lists data sources other than DOT facility databases and web mapping sites where data was obtained to validate particulars of connecting modes. | Amtrak station file, www.ridemcts.com, www.mitchellairport.com, www.badgerbus.com, |
INTERCITY_SERVICE | 1 | 0=no, 1=yes | 1 |
TRANSIT_SERVICE | 1 | 0=no, 1=yes | 1 |
CBSA_CODE | 33340 | Five digit Census Bureau code for micropolitan or metropolitan area (CBSA=Core Based Statistical Area) | 33340 |
CBSA_TYPE | 1 | 1=Metropolitan Area; 2=Micropolitan Area | 1 |
MODES_SERVING | 3 | Count of transportation modes serving using the mode groups which follow in this record. | 3 |
MODE_BUS | 1 | Groups all four types of bus service. Used for count of modes serving. | 1 |
MODE_AIR | 1 | Used for count of modes serving. | 1 |
MODE_RAILSTD | 1 | Includes intercity and commuter rail. Used for count of modes serving. | 1 |
MODE_RAILTRT | 0 | Includes light rail and heavy rail transit. Used for count of modes serving. | 0 |
MODE_FERRY | 0 | Includes intercity and transit ferry. Used for count of modes serving. | 0 |