Fairfax Connector/Field information
Jump to navigation
Jump to search
The Data
- There is one duplicate, StopID=02676
- Data hasn't been normalized (i.e. mix of capitalization, spelling, abbreviations, etc.)
There are 130 fields, however only a few attributes can be directly imported into OSM. Common to all objects will be the following tags:
- source=Fairfax Connector
- source:url=http://www.fairfaxconnector.com
- highway=bus_stop
- public_transport=platform
Some might suggest the StopID belongs in the ref=* key, however the majority of these bus stops are also served by WMATA, the regional transit agency. Indeed the poles are owned by Fairfax (2007), WMATA (1429), or are shared between the two (512). The shelters are owned by Fairfax, WMATA, and others. So really, no one organization "owns" the stop, so using ref=* doesn't make much sense, which is why I suggest to use the ffx:stopid=* key. Similar ambiguity exist with the network=* and operator=* keys.
Field mapping
| GeoDatabase Attribute | FC Description (general) | Suggested OSM tag |
|---|---|---|
| OBJECTID | Index field created by ArcGIS | N/A |
| StopID | Fairfax County unique identifier | ffx:stopid=* |
| SPRV_DIST | Supervisor district | N/A |
| ON_STREET | Street name | N/A |
| St_BlkNum | Block number | N/A |
| St_Prefix | Street prefix | N/A |
| St_Name | Street name | N/A |
| St_Type | Street type | N/A |
| St_Suffix | Street suffix | N/A |
| STROUTE | Street route number | N/A |
| SPEED | on street Speed limit | N/A |
| AT_STREET | Intersecting street name | N/A |
| X_St_Prefix | Intersecting street prefix | N/A |
| X_St_Name | Intersecting street name | N/A |
| X_St_Type | Intersecting street type | N/A |
| X_St_Suffix | Intersecting street suffix | N/A |
| FacilityType | Type of stop (Bus Stop, Park & Ride, etc.) | N/A |
| BusRoute1-15 | Bus routes that use this stop | N/A (this info belongs in relations) |
| TravelDir | Direction of travel | N/A |
| StopLocation | Location in relation to St_BlkNum | N/A |
| AdjPropAddress | Adjacent address | N/A |
| AdjAddressType | Adjacent land-use | N/A |
| SidewalkTrailWidth | Width of sidewalk @ stop | N/A |
| LandAreaType | Land condition @ stop | N/A |
| PedPadMaterial | Material of pedestrian pad | N/A |
| PedPadConnectCurb | Does PedPad reach curb | N/A |
| PedPadLength_ft | Dimension of PedPad | N/A |
| PedPadWidth_ft | Dimension of PedPad | N/A |
| TravelLanes | Number of travel lanes | N/A |
| Drainage | Drainage present along stop | N/A |
| OnStreetParking | Parking availability @ stop | N/A |
| BusPullOutType | Pull out for busses | N/A |
| SiteDistance | Traffic sight distance approaching stop | N/A |
| SignPost | Sign post for stop | N/A |
| SignPoleOwner | Owner of post | N/A |
| SignInstallType | Post installment method | N/A |
| SignPoleCond | Condition of post | N/A |
| CarrierSign1-4 | Sign(s) owner | N/A |
| SignType1-4 | Type of sign(s) | N/A |
| CarrierSignCond1-4 | Condition of sign(s) | N/A |
| Shelter | Is shelter present @ stop | shelter=* |
| ShelterNum | Shelter identifier number | N/A |
| ShelterMat | Material for shelter | N/A |
| ShelterType | Type of shelter | Can infer covered=* |
| ShelterOwner | Owner of shelter | N/A |
| ShelterOwnerOther | Secondary owner of shelter | N/A |
| ShelterFoundation | Foundation shelter is built upon | N/A |
| Shelter2CurbDist_ft | Distance to curb | N/A |
| BenchInShelter | Is a bench present in shelter | bench=* |
| ShelterInteriorLite | Is interior lighting in shelter | lit=* |
| ShelterADA | Is shelter ADA accessable | wheelchair=* |
| InfoCase | Bus information available | N/A |
| InfoCaseOwner | Owner of flyer case | N/A |
| ScheduleInfo | Available flyers | N/A |
| Trash | Trash bin on site | N/A |
| TrashType | Type of trash bin | N/A |
| NewspaperBoxNum | Number of newspaper boxes | N/A |
| TrafficControlDev | Traffic control devices near stop | N/A |
| HandRmpQuad1 | Handicap ramp @ SE | N/A |
| HandRmpQuad2 | Handicap ramp @ NE | N/A |
| HandRmpQuad3 | Handicap ramp @ NW | N/A |
| HandRmpQuad4 | Handicap ramp @ SW | N/A |
| HandRmpQuadMid | Handicap ramp along stop (usually service roads) | N/A |
| CrosswalkOnNearside | Crosswalk adjacent to stop | N/A |
| CrosswalkOnFarside | Crosswalk ON_STREET opposite stop | N/A |
| CrosswalkAtNearside | Crosswalk opposite stop | N/A |
| CrosswalkAtFarside | Crosswalk AT_STREET opposite stop | N/A |
| CrosswalkMid | Crosswalk along stop (usually service roads) | N/A |
| PedHeadOnNearside | Pedestrian signal adjacent to stop | N/A |
| PedHeadOnFarside | Pedestrian signal ON_STREET opposite stop | N/A |
| PedHeadAtNearside | Pedestrian signal opposite stop | N/A |
| PedHeadAtFarside | Pedestrian signal AT_STREET opposite stop | N/A |
| PedHeadMid | Pedestrian signal along stop (usually service roads) | N/A |
| TurnBayLanes | Lanes present for turning (For PnRs) | N/A |
| OverheadStLighting | Street lignting present | N/A |
| LightingDistWIn | Lighting distance | N/A |
| Category | Identifier | N/A |
| Sketch | Unused | N/A |
| Complex | Identifier | N/A |
| Inactive | Is stop in use | N/A |
| REGID | Identifier | N/A |
Frequency count (top 5)
StopID: 02676 (2), 02522 (1), 02523 (1), 05513 (1), 06119 (1) SPRV_DIST: HUNTER MILL (625), LEE (497), MT. VERNON (487), BRADDOCK (452), PROVIDENCE (414) ON_STREET: BRADDOCK RD (90), RICHMOND HY (82), CHAIN BRIDGE RD (81), LEESBURG PI (76), LITTLE RIVER TP (66) St_BlkNum: (1351), 0 (166), 6300 (64), 6200 (53), 6500 (47) St_Prefix: (3997), S (19), N (4), W (3), St_Prefix (1) St_Name: BRADDOCK (90), RICHMOND (82), CHAIN BRIDGE (78), LEESBURG (77), LITTLE RIVER (66) St_Type: RD (1418), DR (874), ST (302), BV (239), HY (222) St_Suffix: (4016), S (4), SW (2), NE (1), St_Suffix (1) STROUTE: (363), other (277), 123 (96), 644 (88), 620 (87) SPEED: 35 (1389), 25 (1335), 45 (493), 0 (292), 30 (279) AT_STREET: (24), LEESBURG PI (23), HENRY G SHIRLEY MEMORIAL HY (22), JONES BRANCH DR (21), RICHMOND HY (21) X_St_Prefix: (4004), S (11), N (4), W (3), <Null> (2) X_St_Name: (29), LEESBURG (25), HENRY G SHIRLEY MEMORIAL (22), JONES BRANCH (21), RICHMOND (21) X_St_Type: DR (1145), RD (873), ST (438), LA (368), CT (338) X_St_Suffix: (4016), S (4), SW (2), X_St_Suffix (1), NE (1) FacilityType: Bus Stop (3652), BUS STOP (197), Transit Center (88), Park & Ride Lot (40), (39) BusRoute1: (356), 15K (152), 17A (132), 17B (125), 101 (103) BusRoute2: 0 (1734), (413), 15L (136), 17B (63), 2G (58) BusRoute3: 0 (2603), (430), 16E (55), 306 (52), 2W (36) BusRoute4: 0 (3085), (444), 17G (28), 1F (27), 2G (26) BusRoute5: 0 (3294), (446), 1Z (27), 29K (26), 17H (19) BusRoute6: 0 (3420), (449), 17K (19), 29G (15), 29K (12) BusRoute7: 0 (3480), (454), 17L (19), 29H (15), 3A (10) BusRoute8: 0 (3515), (457), 306 (16), 29K (15), 401 (9) BusRoute9: 0 (3545), (458), 29N (14), <Null> (3), 28A (2) BusRoute10: 0 (3545), (461), 306 (11), 28B (2), 7X (2) BusRoute11: 0 (3547), (462), 7X (8), 7A (2), 4A (2) BusRoute12: 0 (3556), (462), 7F (2), 4B (2), <Null> (1) BusRoute13: 0 (3556), (462), 7H (2), 4H (2), <Null> (1) BusRoute14: 0 (3558), (462), 4S (2), 16K (1), <Null> (1) BusRoute15: 0 (3560), (462), BusRoute15 (1), 16B (1), <Null> (1) TravelDir: West (1003), East (956), South (909), North (904), WEST (60) StopLocation: Near (1636), MidBlock (1215), Far (920), NEAR (98), FAR (56) AdjPropAddress: (1931), WEST FALLS CHURCH METRO STATION (17), VIENNA GMU METRO STATION SOUTH (10), RESTON EAST PARK & RIDE (10), TYSONS WESTPARK TRANSIT CENTET (10) AdjAddressType: Residence-detached (1414), Residence-townhouse (481), Office Building (388), Vacant Land (355), Apartment (340) SidewalkTrailWidth: 4 (1680), None (848), 5 (490), 3 (291), 6 (174) LandAreaType: Grass (2419), Pad (465), Sidewalk (345), Shoulder (249), Drainage Structure (248) PedPadMaterial: (3477), Concrete (461), Brick Pavement (34), Asphalt (18), CONCRETE (15) PedPadConnectCurb: No (3264), Yes (486), (257), YES (15), NO (2) PedPadLength_ft: 0 (3525), 3 (72), 14 (56), 8 (44), 10 (40) PedPadWidth_ft: 0 (3525), 5 (51), 12 (51), 14 (48), 6 (43) TravelLanes: 1 (2084), 2 (1605), 3 (253), (55), 4 (22) Drainage: Curb & Gutter (3174), Ditch (246), (220), CURB AND GUTTER (196), Other (176) OnStreetParking: No (3192), Yes (612), NO (167), YES (37), (16) BusPullOutType: Partial (3391), Full (365), PARTIAL (194), (49), Queue Jump (10) SiteDistance: Clear (3527), PartiallyObstructed (197), CLEAR (196), (61), Obstructed (31) SignPost: Yes (3755), (223), No (38), YES (8), SignPost (1) SignPoleOwner: FAIRFAX (2007), WMATA (1429), Shared (506), (70), SHARED (6) SignInstallType: Earth/Ground (3573), EARTH/GROUND (200), Concrete (157), (89), CONCRETE (2) SignPoleCond: PG (3014), PF (595), PP (322), (92), <Null> (1) CarrierSign1: FAIRFAX (2362), WMATA (1558), (44), 0 (35), OTHER (14) CarrierSign2: 0 (3156), (344), WMATA (337), FAIRFAX (122), OTHER (18) CarrierSign3: 0 (3640), (353), TAGS (13), DASH (7), CUE (4) CarrierSign4: 0 (3669), (354), CarrierSign4 (1), <Null> (1) SignType1: Snowflake (1365), RouteNums (1230), Generic (649), Generic w Area Code (429), GENERIC W/ AREA CODE (204) SignType2: 0 (3193), (335), RouteNums (263), Generic (88), Snowflake (77) SignType3: 0 (3666), (353), Generic (3), <Null> (2), SignType3 (1) SignType4: 0 (3669), (354), SignType4 (1), <Null> (1) CarrierSignCond1: SG (3632), SF (197), SP (84), (60), SX (37) CarrierSignCond2: 0 (3156), SG (488), (346), SF (27), SP (4) CarrierSignCond3: 0 (3640), (354), SG (26), SF (2), SX (1) CarrierSignCond4: 0 (3669), (354), CarrierSignCond4 (1), <Null> (1) Shelter: No (3395), Yes (398), (212), YES (14), No (4) ShelterNum1: (3612), 1 (196), AHQ-09 (6), AHQ-07 (5), AHQ-11 (5) ShelterMat1: (3608), Aluminum (317), Other (Non-Standard) (62), ALUMINUM (14), Aluminium (9) ShelterType1: (3608), Three sided (319), Canopy (28), Three Sided (26), Other (25) ShelterOwner1: (3611), 0 (158), FCDPWS (57), WMATA (55), FairfaxCONN (43) ShelterOwnerOther1: (3654), 0 (362), Daytech Mfg (2), Ffax & Stormwater Mgt (1), Cedar Ridge Apartment (1) ShelterFoundation1: (3608), Concrete Pad (356), Brick (28), CONCRETE PAD (11), Soil/Grass/Unimproved (9) Shelter2CurbDist1_ft: 0 (3650), 8 (41), 4 (38), 9 (36), 7 (34) BenchInShelter1: No (3360), Yes (360), (289), YES (11), NO (4) ShelterInteriorLite1: No (3636), (291), Yes (84), NO (12), ShelterInteriorLite1 (1) ShelterADA1: No (3377), Yes (343), (291), YES (13), ShelterADA1 (1) ShelterNum2: (3650), 0 (302), 2 (62), CRP-16 (1), AHQ-6a (1) ShelterMat2: (3650), 0 (303), Aluminum (62), Other (Non-Standard) (6), ALUMINUM (3) ShelterType2: (3650), 0 (303), Three sided (66), THREE SIDED (3), Other (1) ShelterOwner2: (3650), 0 (363), FairfaxCONN (5), FAIRFAX CONNECTOR (3), VDOT (2) ShelterOwnerOther2: (3653), 0 (371), ShelterOwnerOther2 (1) ShelterFoundation2: (3650), 0 (306), Concrete Pad (64), CONCRETE PAD (3), ShelterFoundation2 (1) Shelter2CurbDist2_ft: 0 (3956), 7 (19), 6 (9), 8 (9), 12 (8) BenchInShelter2: No (3639), (323), Yes (59), YES (3), BenchInShelter2 (1) ShelterInteriorLite2: No (3644), (323), Yes (54), NO (3), ShelterInteriorLite2 (1) ShelterADA2: No (3632), (323), Yes (66), YES (3), ShelterADA2 (1) ShelterNum3: (3653), 0 (370), 3 (1), ShelterNum3 (1) ShelterMat3: (3653), 0 (370), Other (Non-Standard) (1), ShelterMat3 (1) ShelterType3: (3653), 0 (370), ShelterType3 (1), Canopy (1) ShelterOwner3: (3653), 0 (371), ShelterOwner3 (1) ShelterOwnerOther3: (3653), 0 (371), ShelterOwnerOther3 (1) ShelterFoundation3: (3653), 0 (370), ShelterFoundation3 (1), Concrete Pad (1) Shelter2CurbDist3_ft: 0 (4023), 19 (1), Shelter2CurbDist3_ft (1) BenchInShelter3: No (3696), (326), Yes (2), BenchInShelter3 (1) ShelterInteriorLite3: No (3697), (326), Yes (1), ShelterInteriorLite3 (1) ShelterADA3: No (3697), (326), Yes (1), ShelterADA3 (1) Bench: No (3624), NO (188), Yes (129), (63), YES (15) BenchNum1: 0 (3916), 1 (108), BenchNum1 (1) BenchMat1: (3879), Wood (66), Metal (61), METAL (11), WOOD (4) BenchOwner1: (3876), 0 (98), Fairfax (17), FAIRFAX CONNECTOR (14), FAIRFAXCONN (8) BenchNum2: 0 (3996), 2 (28), BenchNum2 (1) BenchMat2: (3912), 0 (79), Wood (15), Metal (14), METAL (3) BenchOwner2: (3913), 0 (105), FAIRFAX CONNECTOR (3), Lions Club (2), BenchOwner2 (1) InfoCase: No (3325), Yes (469), NO (201), (12), YES (11) InfoCaseOwner: (3735), WMATA (241), FAIRFAXCONN (10), FAIRFAX (9), FAIRFAX CONNECTOR (8) ScheduleInfo: (3551), Schedule & Map (131), None (127), Schedule only (82), Map Only (38) Trash: No (3349), Yes (449), NO (198), (15), YES (13) TrashType: (3557), Free Standing (297), On Pole (45), Placed By Citizens (45), Garbage Can (35) NewspaperBoxNum: 0 (3709), 2 (84), 1 (64), 3 (54), 4 (38) TrafficControlDev: Traffic Sign (1762), (1445), Signal (712), Ped Signal (51), SIGNAL (44) HandRmpQuad1: Yes (2191), No (1612), YES (139), NO (65), (17) HandRmpQuad2: No (1962), Yes (1841), YES (105), NO (98), (17) HandRmpQuad3: No (2082), Yes (1721), YES (111), NO (93), (17) HandRmpQuad4: Yes (2028), No (1773), YES (133), NO (71), (18) HandRmpQuadMid: No (3630), NO (187), Yes (172), (17), YES (17) CrosswalkOnNearside: No (2991), Yes (810), NO (157), YES (48), (18) CrosswalkOnFarside: No (3093), Yes (709), NO (173), YES (31), (18) CrosswalkAtNearside: No (3066), Yes (736), NO (165), YES (39), (17) CrosswalkAtFarside: No (3147), Yes (656), NO (181), YES (22), (17) CrosswalkMid: No (3716), NO (195), Yes (87), (17), YES (9) PedHeadOnNearside: (3387), Standard/Symbols (385), NO (180), STANDARD/COUNTDOWN (23), Other (12) PedHeadOnFarside: (3434), Standard/Symbols (354), NO (187), STANDARD/COUNTDOWN (16), No (14) PedHeadAtNearside: (3505), Standard/Symbols (293), NO (181), STANDARD/COUNTDOWN (22), Yes (9) PedHeadAtFarside: (3509), Standard/Symbols (284), NO (192), STANDARD/COUNTDOWN (12), Yes (10) PedHeadMid: (3801), NO (200), No (10), Other (6), Standard/Symbols (4) TurnBayLanes: No (3159), Yes (638), NO (154), YES (50), (23) OverheadStLighting: Yes (2858), No (945), YES (114), NO (90), (17) LightingDistWIn: 25' (1526), (1050), 50' (819), 100' (451), 25 (93) Category: B1 (2286), B2 (625), C (413), (369), D (176) Sketch: (4024), Sketch (1) Complex: No (3640), (327), Yes (54), 0 (3), Complex (1) Inactive: No (3808), (205), NO (11), Inactive (1) REGID: 0 (2), 5001300 (2), 5002166 (2), 5002178 (2), 5001210 (2)