Fairfax Connector/Field information

From OpenStreetMap Wiki
Jump to: navigation, 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:

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)