Name: Metro_Bus_Stop_Assessment_and_Maintenance
Display Field: objectid
Type: Feature Layer
Geometry Type: esriGeometryPoint
Is View: true
Is Updatable View: true
Source Schema Changes Allowed: true
Sources
Description:
Copyright Text:
Min. Scale: 0
Max. Scale: 0
Default Visibility: true
Max Record Count: 1000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
Extent:
XMin: -180
YMin: -90
XMax: 180
YMax: 90
Spatial Reference: 4326 (4326)
Drawing Info:
{"labelingInfo":null,"renderer":{"description":"Survey Data Locations","label":"Metro Bus Stop Assessment and Maint.","symbol":{"angle":0,"color":[255,0,0,255],"outline":{"color":[255,255,0,255],"width":1},"size":8,"style":"esriSMSCircle","type":"esriSMS","xoffset":0,"yoffset":0},"type":"simple"},"transparency":0}
HasZ: false
HasM: false
Time Info:
Start Time Field: start
End Time Field: end
Track ID Field: null
Time Extent: null
Time Reference: UTC
Time Interval: 0
Time Interval Units: esriTimeUnitsMilliseconds
Has Live Data: false
Export Options:
Use Time: false
Time Data Cumulative: false
Time Offset: 0
Time Offset Units: esriTimeUnitsCenturies
Has Attachments: true
Has Geometry Properties: false
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Object ID Field: objectid
Unique ID Field:
IsSystemMaintained : True
Global ID Field: globalid
Type ID Field:
Fields:
- objectid (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: false, editable: false)
- sto_no (type: esriFieldTypeString, alias: Stop ID:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- stop_desc (type: esriFieldTypeString, alias: Stop Name:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- city (type: esriFieldTypeString, alias: Stop Jurisdiction:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- stopID (type: esriFieldTypeInteger, alias: 1.1 Stop ID:, SQL Type: sqlTypeOther, nullable: true, editable: true)
- description (type: esriFieldTypeString, alias: 1.2 Location Description:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- jurisdiction (type: esriFieldTypeString, alias: 1.3 Jurisdiction:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- position (type: esriFieldTypeString, alias: 1.4 Stop Position:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- assess_name (type: esriFieldTypeString, alias: 1.5 Assessor Name:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Roderick Thomas: Roderick Thomas], [Natalie Siebert: Natalie Siebert], [Lance Peterson: Lance Peterson], ... 1 more ...)
- assess_other (type: esriFieldTypeString, alias: Assessor Name:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Date_Collected (type: esriFieldTypeDate, alias: 1.6 Today's Date:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- stateofrepair (type: esriFieldTypeString, alias: stateofrepair, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- good_repair_label (type: esriFieldTypeString, alias: Needs Assessment, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- state_excellent (type: esriFieldTypeString, alias: 5 - Excellent, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- state_good (type: esriFieldTypeString, alias: 4 - Good, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- state_adequate (type: esriFieldTypeString, alias: 3 - Adequate, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- state_marginal (type: esriFieldTypeString, alias: 2 - Marginal, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- state_worn (type: esriFieldTypeString, alias: 1- Worn, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- type (type: esriFieldTypeString, alias: 2.1 Stop Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [On-Street: On-Street], [Transit Center: Transit Center], [Hub: Hub])
- routes (type: esriFieldTypeString, alias: 2.2 Routes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- last_assess_date (type: esriFieldTypeString, alias: Last Assessment Date:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- last_assess_name (type: esriFieldTypeString, alias: Last Assessed By:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- remove_stop (type: esriFieldTypeString, alias: 2.3 Remove Stop?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- Shelter (type: esriFieldTypeString, alias: 2.4 Shelter:, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- adpanel (type: esriFieldTypeString, alias: 2.4a Does the shelter have an ad panel?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- Bench (type: esriFieldTypeString, alias: 2.5 Bench:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- bench_num (type: esriFieldTypeInteger, alias: 2.5a How many benches are present?, SQL Type: sqlTypeOther, nullable: true, editable: true)
- metro_bench (type: esriFieldTypeInteger, alias: 2.5b How many benches are Metro-owned?, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Bike_racks (type: esriFieldTypeString, alias: 2.6 Bike Rack:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- Trash_cans (type: esriFieldTypeString, alias: 2.7 Garbage Cans:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- lighting (type: esriFieldTypeString, alias: 2.8 Lighting:, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- transfer (type: esriFieldTypeString, alias: 2.9 Transfer Stop:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- adopt (type: esriFieldTypeString, alias: 2.10 Adopt-A-Stop:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- sign_mount (type: esriFieldTypeString, alias: 2.11 On what kind of pole is the Bus Stop sign mounted?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Flush Mount: Flush Mount], [In-Ground: In-Ground], [Light Pole: Light Pole], ... 3 more ...)
- current_sign (type: esriFieldTypeString, alias: 2.11a Is the bus stop sign current?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No Old Sign: No - Old Sign], [No Temporary Sign: No - Temporary Sign], ... 2 more ...)
- sign_image (type: esriFieldTypeString, alias: See Current Bus Stop Sign?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes])
- sign_decal (type: esriFieldTypeString, alias: 2.11b Has the bus stop sign been modified with a decal?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- pole_road (type: esriFieldTypeString, alias: 2.11c Is the bus stop sign and pole at least 24 inches away from the roadway?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- amenities (type: esriFieldTypeString, alias: 2.11d Are any of the amenities mentioned above significantly damaged, corroded, or worn?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- crosswalk (type: esriFieldTypeString, alias: 2.15 Is a crosswalk present that services this stop?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Crosswalk: Crosswalk], [Pedestrian Signal: Pedestrian Signal], [Both: Both], ... 1 more ...)
- change_loc (type: esriFieldTypeString, alias: 2.12 Is a stop location change needed?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- stop_move (type: esriFieldTypeString, alias: 2.12a Move Stop:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Shift to Nearside Position: Shift to Nearside Position], [Shift to Farside Position: Shift to Farside Position], [Shift to Midblock Position: Shift to Midblock Position], ... 2 more ...)
- name_mod (type: esriFieldTypeString, alias: 2.13 Does the Stop Name need to be modified?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- sugg_stopname (type: esriFieldTypeString, alias: 2.13a Suggest a new Stop Name:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- bus_zone (type: esriFieldTypeString, alias: 2.14 Is the Bus Zone properly defined?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- change_buszone (type: esriFieldTypeString, alias: 2.14a What changes are needed to properly define the Bus Zone?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- sight_line (type: esriFieldTypeString, alias: 2.16 Are there any compromised sight lines?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- sightline_def (type: esriFieldTypeString, alias: See Sight Line Definition?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes])
- sight_line_items (type: esriFieldTypeString, alias: Compromised Sight Lines include:
1. A lack of direct lighting on the stop (for street lights, if the light pole wouldn't hit you when it falls, the light is insufficient)
2. Vegetation, walls or signage that could be an ambush point
3. An issue with the stop position that limits an operators visibility to the waiting passengers
4. Cloudy or opaque plexiglass shelter walls, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- stop_long (type: esriFieldTypeDouble, alias: 2.17 Longitude:, SQL Type: sqlTypeOther, nullable: true, editable: true)
- stop_lat (type: esriFieldTypeDouble, alias: 2.18 Latitude:, SQL Type: sqlTypeOther, nullable: true, editable: true)
- trap_lon (type: esriFieldTypeString, alias: 2.19 Trapeze Longitude:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- trap_lat (type: esriFieldTypeString, alias: 2.20 Trapeze Latitude, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- ammen_calc (type: esriFieldTypeString, alias: ammen_calc, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- sight_sign (type: esriFieldTypeString, alias: sight_sign, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- lat_lon_diff (type: esriFieldTypeString, alias: lat_lon_diff, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- dist (type: esriFieldTypeString, alias: Distance (in feet):, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- dist_define (type: esriFieldTypeString, alias: This is a measurement between the latitude/longitude value in Trapeze and the point captured for the stop during this assessment., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- comments (type: esriFieldTypeString, alias: Comments:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- header (type: esriFieldTypeString, alias: Fill out this page only if submitting a service request., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- source (type: esriFieldTypeString, alias: Reporting Source:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Employee: Employee])
- emp_name (type: esriFieldTypeString, alias: Employee Name:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- emp_phone (type: esriFieldTypeString, alias: Employee Phone Number:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- emp_email (type: esriFieldTypeString, alias: Employee Email Address:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- where_prob (type: esriFieldTypeString, alias: Where is the problem?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [ROW-BUS: ROW-BUS])
- hazard (type: esriFieldTypeString, alias: Safety Hazard:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes])
- prob_code (type: esriFieldTypeString, alias: Problem Code:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [010: Damaged], [020: Broken], [025: Install Equipment], ... 27 more ...)
- prob_desc (type: esriFieldTypeString, alias: Describe the problem:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Pad (type: esriFieldTypeString, alias: Pad, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
- pad_calc (type: esriFieldTypeString, alias: pad_calc, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- pad_ada (type: esriFieldTypeString, alias: pad_ada, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Pad_Dimensions (type: esriFieldTypeString, alias: Pad_Dimensions, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
- pad_dim_ada (type: esriFieldTypeString, alias: pad_dim_ada, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Pad_Slope1 (type: esriFieldTypeDouble, alias: Pad running slope measurement #1, SQL Type: sqlTypeOther, nullable: true, editable: true)
- pad_slope1_ada (type: esriFieldTypeString, alias: pad_slope1_ada, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Pad_CS1 (type: esriFieldTypeDouble, alias: Pad Cross Slope Measurement #1, SQL Type: sqlTypeOther, nullable: true, editable: true)
- pad_cs1_ada (type: esriFieldTypeString, alias: pad_cs1_ada, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Int_AccessibleRoute (type: esriFieldTypeString, alias: Int_AccessibleRoute, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
- int_acc_rte_ada (type: esriFieldTypeString, alias: int_acc_rte_ada, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Int_RouteWidth (type: esriFieldTypeString, alias: Int_RouteWidth, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
- int_route_ada (type: esriFieldTypeString, alias: int_route_ada, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- vert_ada (type: esriFieldTypeString, alias: vert_ada, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
- acc_vert_ada (type: esriFieldTypeString, alias: acc_vert_ada, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Surface (type: esriFieldTypeString, alias: Surface, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
- surface_ada (type: esriFieldTypeString, alias: surface_ada, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Sign (type: esriFieldTypeString, alias: Sign, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
- sign_ada (type: esriFieldTypeString, alias: sign_ada, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- sign_height (type: esriFieldTypeString, alias: sign_height, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
- CF_GroundSpace (type: esriFieldTypeString, alias: CF_GroundSpace, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
- cf_gs_ada (type: esriFieldTypeString, alias: cf_gs_ada, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- CF_Dimensions (type: esriFieldTypeString, alias: CF_Dimensions, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
- cf_dim_ada (type: esriFieldTypeString, alias: cf_dim_ada, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- CF_AccessibleRoute (type: esriFieldTypeString, alias: CF_AccessibleRoute, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
- cf_acc_rte_ada (type: esriFieldTypeString, alias: cf_acc_rte_ada, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- ada_noshelter (type: esriFieldTypeString, alias: ada_noshelter, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- ada_shelter (type: esriFieldTypeString, alias: ada_shelter, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- ada_score (type: esriFieldTypeString, alias: ada_score, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- start (type: esriFieldTypeDate, alias: start, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- end (type: esriFieldTypeDate, alias: end, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- dwell (type: esriFieldTypeString, alias: dwell, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- header2 (type: esriFieldTypeString, alias: Be sure to capture all assets in the bus stop zone. Try to capture the closest intersection in at least one of these photos., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
- EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
- shelter_mount (type: esriFieldTypeString, alias: 2.4b How is the shelter mounted?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Flush Mount: Flush Mount], [In-Ground: In-Ground], [Not Metro Owned: Not Metro Owned])
- light_source (type: esriFieldTypeString, alias: 2.8a Where is the nearest source of lighting?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [This Side Within 40ft: This Side Within 40ft], [Across the Street: Across the Street], [Shelter Lighting: Shelter Lighting])
- sightline_calc (type: esriFieldTypeString, alias: sightline_calc, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- ada_head1 (type: esriFieldTypeString, alias: 4.1 Boarding and Alighting Area, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- ada_head2 (type: esriFieldTypeString, alias: 4.2 Accessible Route, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- ada_head3 (type: esriFieldTypeString, alias: 4.3 Bus Stop Sign, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- ada_head4 (type: esriFieldTypeString, alias: 4.4 Bus Stop Shelter, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- ada_improve (type: esriFieldTypeString, alias: Recommended ADA Improvements, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
Templates:
Name: New Feature
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 5/15/2025 5:42:14 PM
Schema Last Edit Date: 5/15/2025 5:42:14 PM
Data Last Edit Date: 5/15/2025 5:42:14 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Query Attachments
Add Features
Update Features
Apply Edits
Calculate
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat