View In:   ArcGIS Online Map Viewer

Name: Emergency Work Request

Display Field: RequestID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Transportation Online Permitting System - TOPS - Emergency Work Request

Copyright Text: DDOT

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 50000

Max Scale: 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: -8584375.7419
YMin: 4694974.704499997
XMax: -8561548.2658
YMax: 4720953.540399998
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
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:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• RequestID ( type: esriFieldTypeInteger, alias: RequestID, editable: true, nullable: true, defaultValue: null, modelName: RequestID )
• RequestNumber ( type: esriFieldTypeString, alias: RequestNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RequestNumber )
• EmergencyTypeCode ( type: esriFieldTypeString, alias: EmergencyTypeCode, editable: true, nullable: true, length: 50, defaultValue: null, modelName: EmergencyTypeCode , Coded Values: [ElectricOver: Electric Overhead] , [ElectricUnder: Electric Underground] , [Gas: Gas] , ...5 more... )
• EmergencyCauseID ( type: esriFieldTypeInteger, alias: EmergencyCauseID, editable: true, nullable: true, defaultValue: null, modelName: EmergencyCauseID , Coded Values: [1: Fire Hydrant Break / Leak] , [2: Fire Hydrant Control Valve Break / Leak] , [3: Struck Fire Hydrant] , ...29 more... )
• EffectiveDate ( type: esriFieldTypeDate, alias: EffectiveDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: EffectiveDate )
• ExpirationDate ( type: esriFieldTypeDate, alias: ExpirationDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ExpirationDate )
• StartTime ( type: esriFieldTypeString, alias: StartTime, editable: true, nullable: true, length: 10, defaultValue: null, modelName: StartTime )
• ApplicationDate ( type: esriFieldTypeDate, alias: ApplicationDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ApplicationDate )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: false, length: 50, defaultValue: null, modelName: Status , Coded Values: [CANCELLED: Cancelled] , [PERMITAPPLIED: Permit Applied For] , [REJECTED: Rejected] , ...1 more... )
• LocationDetail ( type: esriFieldTypeString, alias: LocationDetail, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LocationDetail )
• LocationDescription ( type: esriFieldTypeString, alias: LocationDescription, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: LocationDescription )
• LocationFullDescription ( type: esriFieldTypeString, alias: LocationFullDescription, editable: true, nullable: true, length: 100, defaultValue: null, modelName: LocationFullDescription )
• ConstructionTrackingNumber ( type: esriFieldTypeInteger, alias: ConstructionTrackingNumber, editable: true, nullable: true, defaultValue: null, modelName: ConstructionTrackingNumber )
• OccupancyTrackingNumber ( type: esriFieldTypeInteger, alias: OccupancyTrackingNumber, editable: true, nullable: true, defaultValue: null, modelName: OccupancyTrackingNumber )
• SubmissionDate ( type: esriFieldTypeDate, alias: SubmissionDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: SubmissionDate )
• RejectedDate ( type: esriFieldTypeDate, alias: RejectedDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: RejectedDate )
• LastUpdateDate ( type: esriFieldTypeDate, alias: LastUpdateDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LastUpdateDate )
• CancelledDate ( type: esriFieldTypeDate, alias: CancelledDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CancelledDate )
• StartTimeAMPM ( type: esriFieldTypeString, alias: StartTimeAMPM, editable: true, nullable: true, length: 8, defaultValue: null, modelName: StartTimeAMPM )
• ApplicationTime ( type: esriFieldTypeString, alias: ApplicationTime, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ApplicationTime )
• NotificationSent ( type: esriFieldTypeDate, alias: NotificationSent, editable: true, nullable: true, length: 8, defaultValue: null, modelName: NotificationSent )
• EWR_Location_ID ( type: esriFieldTypeInteger, alias: EWR_Location_ID, editable: true, nullable: true, defaultValue: null, modelName: EWR_Location_ID )
• Ward ( type: esriFieldTypeString, alias: Ward, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Ward )
• FiscalYear ( type: esriFieldTypeInteger, alias: FiscalYear, editable: true, nullable: true, defaultValue: null, modelName: FiscalYear )
• Quadrant ( type: esriFieldTypeString, alias: Quadrant, editable: true, nullable: true, length: 2, defaultValue: null, modelName: Quadrant )
• ZipCode ( type: esriFieldTypeString, alias: ZipCode, editable: true, nullable: true, length: 5, defaultValue: null, modelName: ZipCode )
• ANC ( type: esriFieldTypeString, alias: ANC, editable: true, nullable: true, length: 2, defaultValue: null, modelName: ANC )
• SMD ( type: esriFieldTypeString, alias: SMD, editable: true, nullable: true, length: 4, defaultValue: null, modelName: SMD )
• NeighborhoodClusters ( type: esriFieldTypeString, alias: NeighborhoodClusters, editable: true, nullable: true, length: 50, defaultValue: null, modelName: NeighborhoodClusters )
• NeighborhoodNames ( type: esriFieldTypeString, alias: NeighborhoodNames, editable: true, nullable: true, length: 50, defaultValue: null, modelName: NeighborhoodNames )
• BID ( type: esriFieldTypeString, alias: BID, editable: true, nullable: true, length: 100, defaultValue: null, modelName: BID )
• AWI ( type: esriFieldTypeString, alias: AWI, editable: true, nullable: true, length: 100, defaultValue: null, modelName: AWI )
• EDZ ( type: esriFieldTypeString, alias: EDZ, editable: true, nullable: true, length: 100, defaultValue: null, modelName: EDZ )
• NIF ( type: esriFieldTypeString, alias: NIF, editable: true, nullable: true, length: 100, defaultValue: null, modelName: NIF )
• HistoricDistrict ( type: esriFieldTypeString, alias: HistoricDistrict, editable: true, nullable: true, length: 100, defaultValue: null, modelName: HistoricDistrict )
• Zoning ( type: esriFieldTypeString, alias: Zoning, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Zoning )
• PUD ( type: esriFieldTypeString, alias: PUD, editable: true, nullable: true, length: 100, defaultValue: null, modelName: PUD )
• CFAR ( type: esriFieldTypeString, alias: CFAR, editable: true, nullable: true, length: 100, defaultValue: null, modelName: CFAR )
• PSA ( type: esriFieldTypeString, alias: PSA, editable: true, nullable: true, length: 5, defaultValue: null, modelName: PSA )
• PD ( type: esriFieldTypeString, alias: PD, editable: true, nullable: true, length: 5, defaultValue: null, modelName: PD )
• ProblemDetails ( type: esriFieldTypeString, alias: ProblemDetails, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: ProblemDetails )
• StatusDescription ( type: esriFieldTypeString, alias: StatusDescription, editable: true, nullable: true, length: 100, defaultValue: null, modelName: StatusDescription )
• XCoord ( type: esriFieldTypeDouble, alias: XCoord, editable: true, nullable: true, defaultValue: null, modelName: XCoord )
• YCoord ( type: esriFieldTypeDouble, alias: YCoord, editable: true, nullable: true, defaultValue: null, modelName: YCoord )
• OnSegX ( type: esriFieldTypeDouble, alias: OnSegX, editable: true, nullable: true, defaultValue: null, modelName: OnSegX )
• OnSegY ( type: esriFieldTypeDouble, alias: OnSegY, editable: true, nullable: true, defaultValue: null, modelName: OnSegY )
• Longitude ( type: esriFieldTypeDouble, alias: Longitude, editable: true, nullable: true, defaultValue: null, modelName: Longitude )
• Latitude ( type: esriFieldTypeDouble, alias: Latitude, editable: true, nullable: true, defaultValue: null, modelName: Latitude )

Templates:

• Name: Emergency Work Request
  Description:
  Prototype:
  Longitude: null
  RequestID: null
  RequestNumber: null
  EmergencyTypeCode: null
  EmergencyCauseID: null
  EffectiveDate: null
  ExpirationDate: null
  StartTime: null
  ApplicationDate: null
  Status:
  LocationDetail: null
  LocationDescription: null
  LocationFullDescription: null
  ConstructionTrackingNumber: null
  OccupancyTrackingNumber: null
  SubmissionDate: null
  RejectedDate: null
  LastUpdateDate: null
  CancelledDate: null
  StartTimeAMPM: null
  ApplicationTime: null
  NotificationSent: null
  EWR_Location_ID: null
  Ward: null
  FiscalYear: null
  Quadrant: null
  ZipCode: null
  ANC: null
  SMD: null
  NeighborhoodClusters: null
  NeighborhoodNames: null
  BID: null
  AWI: null
  EDZ: null
  NIF: null
  HistoricDistrict: null
  Zoning: null
  PUD: null
  CFAR: null
  PSA: null
  PD: null
  ProblemDetails: null
  StatusDescription: null
  XCoord: null
  YCoord: null
  OnSegX: null
  OnSegY: null
  Latitude: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Analytic   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata