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 |