Layers:

Layer: Elevators (0)

Name: Elevators

Display Field: station_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: fa1d73b1413c4a698837c693bafcc08b

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:
XMin: 234815.0944999978
YMin: 900028.1561999992
XMax: 236445.29670000076
YMax: 901036.5687999986
Spatial Reference: 26986  (26986)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [152, 166, 0, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:
• station_name ( type: esriFieldTypeString, alias: station_name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: station_name )
• elevator_clean ( type: esriFieldTypeString, alias: elevator_clean, editable: true, nullable: true, length: 255, defaultValue: null, modelName: elevator_clean )
• cleanliness_problem ( type: esriFieldTypeString, alias: cleanliness_problem, editable: true, nullable: true, length: 255, defaultValue: null, modelName: cleanliness_problem )
• Timestamp ( type: esriFieldTypeDate, alias: Timestamp, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Timestamp )
• ResponseDue ( type: esriFieldTypeDate, alias: ResponseDue, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ResponseDue )
• Last_Status ( type: esriFieldTypeString, alias: Last_Status, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Last_Status )
• Last_Status_Update ( type: esriFieldTypeDate, alias: Last_Status_Update, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Last_Status_Update )
• rSLA ( type: esriFieldTypeInteger, alias: rSLA, editable: true, nullable: true, defaultValue: null, modelName: rSLA )
• ElevatorStatus ( type: esriFieldTypeString, alias: ElevatorStatus, editable: true, nullable: false, length: 26, defaultValue: null, modelName: ElevatorStatus )
• Core ( type: esriFieldTypeString, alias: Core, editable: true, nullable: false, length: 8, defaultValue: null, modelName: Core )
• GlobalID ( type: esriFieldTypeGUID, alias: GlobalID, editable: true, nullable: false, length: 38, defaultValue: {00000000-0000-0000-0000-000000000000}, modelName: GlobalID )
• OBJECTID ( type: esriFieldTypeInteger, alias: OBJECTID, editable: true, nullable: false, defaultValue: null, modelName: OBJECTID )
• rGUID ( type: esriFieldTypeGUID, alias: rGUID, editable: true, nullable: false, length: 38, defaultValue: {00000000-0000-0000-0000-000000000000}, modelName: rGUID )
• rOBJECTID ( type: esriFieldTypeInteger, alias: rOBJECTID, editable: true, nullable: false, defaultValue: null, modelName: rOBJECTID )
• ESRI_OID ( type: esriFieldTypeOID, alias: ESRI_OID, editable: false, nullable: false, defaultValue: null, modelName: ESRI_OID )
Templates:
• Name: Elevators
  Description:
  Prototype:
  rGUID: {00000000-0000-0000-0000-000000000000}
  station_name: null
  elevator_clean: null
  cleanliness_problem: null
  Timestamp: null
  ResponseDue: null
  Last_Status: null
  Last_Status_Update: null
  rSLA: null
  ElevatorStatus:
  Core:
  GlobalID: {00000000-0000-0000-0000-000000000000}
  OBJECTID: 0
  rOBJECTID: 0
  
  Drawing Tool: esriFeatureEditToolPoint

Tables:

Table: Reports (1)

Name: Reports

Display Field: station_name

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• globalid ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: globalid )
• station_name ( type: esriFieldTypeString, alias: What T Station is this?, editable: true, nullable: true, length: 255, defaultValue: null, modelName: station_name , Coded Values: [Chinatown: Chinatown] , [Copley: Copley] , [State: State] )
• elevator_clean ( type: esriFieldTypeString, alias: Is this elevator clean?, editable: true, nullable: true, length: 255, defaultValue: null, modelName: elevator_clean , Coded Values: [Yes: Yes] , [Not perfect, but clean enough: Not perfect, but clean enough] , [No: No] )
• cleanliness_problem ( type: esriFieldTypeString, alias: What is the problem?, editable: true, nullable: true, length: 255, defaultValue: null, modelName: cleanliness_problem , Coded Values: [Urine (visible): Urine (visible)] , [Urine (smell): Urine (smell)] , [Other bodily fluid: Other bodily fluid] , ...2 more... )
• cleanliness_specify ( type: esriFieldTypeString, alias: Please specify:, editable: true, nullable: true, length: 255, defaultValue: null, modelName: cleanliness_specify )
• general_satisfaction ( type: esriFieldTypeString, alias: Are you generally satisfied with this elevator cleanliness?, editable: true, nullable: true, length: 255, defaultValue: null, modelName: general_satisfaction , Coded Values: [Yes - Most of the time: Yes - Most of the time] , [50% of the time: 50% of the time] , [No - This elevator is often dirty: No - This elevator is often dirty] )
• suggestions ( type: esriFieldTypeString, alias: Suggestions for improvement, editable: true, nullable: true, length: 255, defaultValue: null, modelName: suggestions )
• Elevator_ID ( type: esriFieldTypeGUID, alias: Elevator_ID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: Elevator_ID )
• Timestamp ( type: esriFieldTypeDate, alias: Timestamp, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Timestamp )
• ResponseDue ( type: esriFieldTypeDate, alias: Respond by:, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ResponseDue )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• RespondingWO ( type: esriFieldTypeString, alias: RespondingWO, editable: true, nullable: true, length: 255, defaultValue: null, modelName: RespondingWO )
Templates:
• Name: Reports
  Description:
  Prototype:
  Timestamp: null
  ResponseDue: null
  RespondingWO: null
  station_name: null
  elevator_clean: null
  cleanliness_problem: null
  cleanliness_specify: null
  general_satisfaction: null
  suggestions: null
  Elevator_ID: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• DBO.MBTA_Elevator_Cleanliness_Response (0) -- Related To: Work Orders (2)

Table: Work Orders (2)

Name: Work Orders

Display Field: SLA

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Elevator_ID ( type: esriFieldTypeGUID, alias: Elevator_ID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: Elevator_ID )
• SLA ( type: esriFieldTypeString, alias: SLA, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SLA )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Status )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Comments )
• Station ( type: esriFieldTypeString, alias: Station, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Station )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• Response_Time ( type: esriFieldTypeDate, alias: ResponseTime, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Response_Time )
• Delayed_Response ( type: esriFieldTypeString, alias: Delayed Response Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Delayed_Response )
• Report_ID ( type: esriFieldTypeGUID, alias: Report ID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: Report_ID )
• Submitted_From ( type: esriFieldTypeString, alias: Submitted_From, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Submitted_From )
Templates:
• Name: Work Orders
  Description:
  Prototype:
  Report_ID: null
  Delayed_Response: null
  Elevator_ID: null
  SLA: null
  Status: null
  Comments: null
  Station: null
  Submitted_From: null
  Response_Time: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• DBO.MBTA_Elevator_Reports (0) -- Related To: Reports (1)

Table: WorkOrderReports (3)

Name: WorkOrderReports

Display Field: Station

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• Station ( type: esriFieldTypeString, alias: Station, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Station )
• ReportedIssue ( type: esriFieldTypeString, alias: ReportedIssue, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ReportedIssue )
• Core ( type: esriFieldTypeString, alias: Core, editable: true, nullable: false, length: 8, defaultValue: null, modelName: Core )
• WOStatus ( type: esriFieldTypeString, alias: WOStatus, editable: true, nullable: false, length: 23, defaultValue: null, modelName: WOStatus )
• Timestamp ( type: esriFieldTypeDate, alias: Timestamp, editable: true, nullable: true, length: 8, defaultValue: null, precision: 1, modelName: Timestamp )
• Response_Time ( type: esriFieldTypeDate, alias: Response_Time, editable: true, nullable: true, length: 8, defaultValue: null, precision: 1, modelName: Response_Time )
• SLA ( type: esriFieldTypeInteger, alias: SLA, editable: true, nullable: true, defaultValue: null, modelName: SLA )
• WOStatusFilter ( type: esriFieldTypeString, alias: WOStatusFilter, editable: true, nullable: true, length: 21, defaultValue: null, modelName: WOStatusFilter )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Comments )
• Delayed_Response ( type: esriFieldTypeString, alias: Delayed_Response, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Delayed_Response )
• Elevator_ID ( type: esriFieldTypeGUID, alias: Elevator_ID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: Elevator_ID )
• globalid ( type: esriFieldTypeGUID, alias: globalid, editable: true, nullable: false, length: 38, defaultValue: {00000000-0000-0000-0000-000000000000}, modelName: globalid )
• OBJECTID ( type: esriFieldTypeInteger, alias: OBJECTID, editable: true, nullable: false, defaultValue: null, modelName: OBJECTID )
• RespondingWO ( type: esriFieldTypeString, alias: RespondingWO, editable: true, nullable: true, length: 255, defaultValue: null, modelName: RespondingWO )
• WOGUID ( type: esriFieldTypeGUID, alias: WOGUID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: WOGUID )
• WOOID ( type: esriFieldTypeInteger, alias: WOOID, editable: true, nullable: true, defaultValue: null, modelName: WOOID )
• Submitted_From ( type: esriFieldTypeString, alias: Submitted_From, editable: true, nullable: true, length: 2147483647, defaultValue: null, modelName: Submitted_From )
• WOStatusTimeFilter ( type: esriFieldTypeString, alias: WOStatusTimeFilter, editable: true, nullable: false, length: 9, defaultValue: null, modelName: WOStatusTimeFilter )
• MAINSTATION ( type: esriFieldTypeString, alias: MAINSTATION, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MAINSTATION )
Templates:
• Name: WorkOrderReports
  Description:
  Prototype:
  WOStatusTimeFilter:
  Station: null
  ReportedIssue: null
  Core:
  WOStatus:
  Timestamp: null
  Response_Time: null
  SLA: null
  WOStatusFilter: null
  Comments: null
  Delayed_Response: null
  Elevator_ID: null
  globalid: {00000000-0000-0000-0000-000000000000}
  OBJECTID: 0
  RespondingWO: null
  WOGUID: null
  WOOID: null
  Submitted_From: null
  MAINSTATION: null
  
  Drawing Tool: esriFeatureEditToolNone

Table: WorkOrderStationSummary (4)

Name: WorkOrderStationSummary

Display Field: MAINSTATION

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• MAINSTATION ( type: esriFieldTypeString, alias: MAINSTATION, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MAINSTATION )
• ClosedinsideSLA ( type: esriFieldTypeInteger, alias: ClosedinsideSLA, editable: true, nullable: true, defaultValue: null, modelName: ClosedinsideSLA )
• ClosedoutsideSLA ( type: esriFieldTypeInteger, alias: ClosedoutsideSLA, editable: true, nullable: true, defaultValue: null, modelName: ClosedoutsideSLA )
• Morning ( type: esriFieldTypeInteger, alias: Morning, editable: true, nullable: true, defaultValue: null, modelName: Morning )
• Midday ( type: esriFieldTypeInteger, alias: Midday, editable: true, nullable: true, defaultValue: null, modelName: Midday )
• Evening ( type: esriFieldTypeInteger, alias: Evening, editable: true, nullable: true, defaultValue: null, modelName: Evening )
• Overnight ( type: esriFieldTypeInteger, alias: Overnight, editable: true, nullable: true, defaultValue: null, modelName: Overnight )
Templates:
• Name: WorkOrderStationSummary
  Description:
  Prototype:
  Evening: null
  MAINSTATION: null
  ClosedinsideSLA: null
  ClosedoutsideSLA: null
  Morning: null
  Midday: null
  Overnight: null
  
  Drawing Tool: esriFeatureEditToolNone

Table: WorkOrderElevatorsSummary (5)

Name: WorkOrderElevatorsSummary

Display Field: Station

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• Station ( type: esriFieldTypeString, alias: Station, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Station )
• ClosedinsideSLA ( type: esriFieldTypeInteger, alias: ClosedinsideSLA, editable: true, nullable: true, defaultValue: null, modelName: ClosedinsideSLA )
• ClosedoutsideSLA ( type: esriFieldTypeInteger, alias: ClosedoutsideSLA, editable: true, nullable: true, defaultValue: null, modelName: ClosedoutsideSLA )
• Morning ( type: esriFieldTypeInteger, alias: Morning, editable: true, nullable: true, defaultValue: null, modelName: Morning )
• Midday ( type: esriFieldTypeInteger, alias: Midday, editable: true, nullable: true, defaultValue: null, modelName: Midday )
• Evening ( type: esriFieldTypeInteger, alias: Evening, editable: true, nullable: true, defaultValue: null, modelName: Evening )
• Overnight ( type: esriFieldTypeInteger, alias: Overnight, editable: true, nullable: true, defaultValue: null, modelName: Overnight )
Templates:
• Name: WorkOrderElevatorsSummary
  Description:
  Prototype:
  Evening: null
  Station: null
  ClosedinsideSLA: null
  ClosedoutsideSLA: null
  Morning: null
  Midday: null
  Overnight: null
  
  Drawing Tool: esriFeatureEditToolNone