View In:   ArcGIS Online Map Viewer

Name: Excavation Damage

Display Field: responsiblepartyname

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Service Item Id: 244cb8979f2c40a38de4c630bbf77b6a

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 50000.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: NaN
YMin: NaN
XMax: NaN
YMax: NaN
Spatial Reference: 102039  (102039)  VCSWkid(105703)  LatestVCSWkid(6360)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: damagetype
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: Dent
  Label: Dent
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [153, 147, 84, 255]
  Width: 3
• Value: Gauge
  Label: Gauge
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [126, 89, 240, 255]
  Width: 3
• Value: Line Cut
  Label: Line Cut
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [222, 100, 147, 255]
  Width: 3
• Value: Other
  Label: Other
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [126, 189, 237, 255]
  Width: 3
• Value: Pulled
  Label: Pulled
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [127, 247, 116, 255]
  Width: 3
• Value: Puncture
  Label: Puncture
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [72, 73, 133, 255]
  Width: 3
• Value: Unknown
  Label: Unknown
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [97, 207, 168, 255]
  Width: 3
Transparency: 0
Labeling Info:

Feature Draw Order:

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: false
Supports Query With Current User: true

HasZ: true

HasM: true

Time Info:

Start Time Field: fromdate
End Time Field: todate
Track ID Field: null
Time Extent:
[1952/03/31 12:00:00 UTC, 2042/04/12 00:00:00 UTC]

Time Reference: N/A
Time Interval: 1
Time Interval Units: esriTimeUnitsUnknown
Has Live Data: false
Export Options:
Use Time: true
Time Data Cumulative: false
Time Offset: null (null)

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: damagetype

Fields:

• objectid ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• datedamaged ( type: esriFieldTypeDate, alias: Date Damaged, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATADAMAGED )
• responsiblepartyname ( type: esriFieldTypeString, alias: Responsible Party Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RESPONSIBLEPARTYNAME )
• responsiblecontactname ( type: esriFieldTypeString, alias: Responsible Contact Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RESPONSIBLECONTACTNAME )
• responsiblepartyaddress ( type: esriFieldTypeString, alias: Responsible Party Address, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RESPONSIBLEPARTYADDRESS )
• responsiblepartycity ( type: esriFieldTypeString, alias: Responsible Party City, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RESPONSIBLEPARTYCITY )
• responsiblepartystate ( type: esriFieldTypeString, alias: Responsible Party State, editable: true, nullable: true, length: 2, defaultValue: null, modelName: RESPONSIBLEPARTYSTATE , Coded Values: [U: Unknown] , [AL: Alabama] , [AK: Alaska] , ...48 more... )
• responsiblepartyphone ( type: esriFieldTypeString, alias: Responsible Party Phone, editable: true, nullable: true, length: 20, defaultValue: null, modelName: RESPONSIBLEPARTYPHONE )
• responsiblepartytype ( type: esriFieldTypeString, alias: Responsible Party Type, editable: true, nullable: true, length: 30, defaultValue: null, modelName: RESPONSIBLEPARTYTYPE , Coded Values: [Unknown: Unknown] , [Company: Company] , [Homeowner: Homeowner] , ...5 more... )
• incidentlocationaddress ( type: esriFieldTypeString, alias: Incident Location Address, editable: true, nullable: true, length: 50, defaultValue: null, modelName: INCIDENTLOCATIONADDRESS )
• incidentlocationcity ( type: esriFieldTypeString, alias: Incident Location City, editable: true, nullable: true, length: 50, defaultValue: null, modelName: INCIDENTLOCATIONCITY )
• incidentlocationstate ( type: esriFieldTypeString, alias: Incident Location State, editable: true, nullable: true, length: 2, defaultValue: null, modelName: INCIDENTLOCATIONSTATE , Coded Values: [U: Unknown] , [AL: Alabama] , [AK: Alaska] , ...48 more... )
• damagetype ( type: esriFieldTypeString, alias: Damage Type, editable: true, nullable: true, length: 25, defaultValue: null, modelName: DAMAGETYPE , Coded Values: [Unknown: Unknown] , [Dent: Dent] , [Gauge: Gauge] , ...4 more... )
• damagedfacilitytype ( type: esriFieldTypeString, alias: Damaged Facility Type, editable: true, nullable: true, length: 30, defaultValue: null, modelName: DAMAGEDFACILITYTYPE , Coded Values: [Unknown: Unknown] , [Distribution Line: Distribution Line] , [Service Line: Service Line] , ...11 more... )
• equipcausingdamage ( type: esriFieldTypeString, alias: Equipment Causing Damage, editable: true, nullable: true, length: 20, defaultValue: null, modelName: EQUIPCAUSINGDAMAGE , Coded Values: [Unknown: Unknown] , [Auger: Auger] , [Backhoe: Backhoe] , ...5 more... )
• worktype ( type: esriFieldTypeString, alias: Work Type, editable: true, nullable: true, length: 30, defaultValue: null, modelName: WORKTYPE , Coded Values: [Unknown: Unknown] , [Cut and Cap Gas Service: Cut and Cap Gas Service] , [Commercial Construction: Commercial Construction] , ...11 more... )
• rootcause ( type: esriFieldTypeString, alias: Root Cause, editable: true, nullable: true, length: 30, defaultValue: null, modelName: ROOTCAUSE , Coded Values: [Unknown: Unknown] , [Clearance Not Maintained: Clearance Not Maintained] , [Failure to Mark: Failure to Mark] , ...16 more... )
• policereport ( type: esriFieldTypeSmallInteger, alias: Police Report, editable: true, nullable: true, defaultValue: 1, modelName: POLICEREPORT , Coded Values: [0: Unknown] , [1: Yes] , [2: No] )
• remarks ( type: esriFieldTypeString, alias: Remarks, editable: true, nullable: true, length: 250, defaultValue: null, modelName: REMARKS )
• spatialaccuracy ( type: esriFieldTypeSmallInteger, alias: Spatial Accuracy, editable: true, nullable: true, defaultValue: null, modelName: SPATIALACCURACY , Coded Values: [0: Unknown] , [1: Greater than 300 Meters] , [3: 31-100 Meters] , ...7 more... )
• gpsx ( type: esriFieldTypeDouble, alias: GPS X, editable: true, nullable: true, defaultValue: null, modelName: GPSX )
• gpsy ( type: esriFieldTypeDouble, alias: GPS Y, editable: true, nullable: true, defaultValue: null, modelName: GPSY )
• eventid ( type: esriFieldTypeString, alias: EventID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: EVENTID )
• fromdate ( type: esriFieldTypeDate, alias: From Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: FROMDATE )
• todate ( type: esriFieldTypeDate, alias: To Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: TODATE )
• engrouteid ( type: esriFieldTypeString, alias: Engineering Route ID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: ENGROUTEID )
• engroutename ( type: esriFieldTypeString, alias: Engineering Route Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ENGROUTENAME )
• engfromm ( type: esriFieldTypeDouble, alias: Engineering From Measure, editable: true, nullable: true, defaultValue: null, modelName: ENGFROMM )
• engtorouteid ( type: esriFieldTypeString, alias: Engineering To Route ID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: ENGTOROUTEID )
• engtoroutename ( type: esriFieldTypeString, alias: Engineering To Route Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ENGTOROUTENAME )
• engtom ( type: esriFieldTypeDouble, alias: Engineering To Measure, editable: true, nullable: true, defaultValue: null, modelName: ENGTOM )
• continrouteid ( type: esriFieldTypeString, alias: Continuous Route ID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: CONTINROUTEID )
• continroutename ( type: esriFieldTypeString, alias: Continuous Route Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CONTINROUTENAME )
• continfromm ( type: esriFieldTypeDouble, alias: Continuous From Measure, editable: true, nullable: true, defaultValue: null, modelName: CONTINFROMM )
• contintom ( type: esriFieldTypeDouble, alias: Continuous To Measure, editable: true, nullable: true, defaultValue: null, modelName: CONTINTOM )
• fromrefmethod ( type: esriFieldTypeSmallInteger, alias: From Reference Method, editable: true, nullable: true, defaultValue: null, modelName: FROMREFMETHOD )
• fromrefoffset ( type: esriFieldTypeString, alias: From Reference Offset, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FROMREFOFFSET )
• fromreflocation ( type: esriFieldTypeString, alias: From Reference Location, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FROMREFLOCATION )
• torefmethod ( type: esriFieldTypeSmallInteger, alias: To Reference Method, editable: true, nullable: true, defaultValue: null, modelName: TOREFMETHOD )
• torefoffset ( type: esriFieldTypeString, alias: To Reference Offset, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TOREFOFFSET )
• toreflocation ( type: esriFieldTypeString, alias: To Reference Location, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TOREFLOCATION )
• locationerror ( type: esriFieldTypeString, alias: Location Error, editable: true, nullable: true, length: 100, defaultValue: null, modelName: LOCATIONERROR )
• 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, required: true )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date, required: true )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user, required: true )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date, required: true )
• Shape__Length ( type: esriFieldTypeDouble, alias: st_length(shape), editable: false, nullable: true, defaultValue: null, modelName: st_length(shape), required: true )

Types:

ID: Dent
Name: Dent
Domains:
• responsiblepartystate:
  Inherited
• responsiblepartytype:
  Inherited
• incidentlocationstate:
  Inherited
• damagetype:
  Inherited
• damagedfacilitytype:
  Inherited
• equipcausingdamage:
  Inherited
• worktype:
  Inherited
• rootcause:
  Inherited
• policereport:
  Inherited
• spatialaccuracy:
  Inherited
Templates:
• Name: Dent
  Description:
  Prototype:
  toreflocation: null
  locationerror: null
  datedamaged: null
  responsiblepartyname: null
  responsiblecontactname: null
  responsiblepartyaddress: null
  responsiblepartycity: null
  responsiblepartystate: null
  responsiblepartyphone: null
  responsiblepartytype: null
  incidentlocationaddress: null
  incidentlocationcity: null
  incidentlocationstate: null
  damagetype: Dent
  damagedfacilitytype: null
  equipcausingdamage: null
  worktype: null
  rootcause: null
  policereport: 1
  remarks: null
  spatialaccuracy: null
  gpsx: null
  gpsy: null
  eventid: null
  fromdate: null
  todate: null
  engrouteid: null
  engroutename: null
  engfromm: null
  engtorouteid: null
  engtoroutename: null
  engtom: null
  continrouteid: null
  continroutename: null
  continfromm: null
  contintom: null
  fromrefmethod: null
  fromrefoffset: null
  fromreflocation: null
  torefmethod: null
  torefoffset: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Gauge
Name: Gauge
Domains:
• responsiblepartystate:
  Inherited
• responsiblepartytype:
  Inherited
• incidentlocationstate:
  Inherited
• damagetype:
  Inherited
• damagedfacilitytype:
  Inherited
• equipcausingdamage:
  Inherited
• worktype:
  Inherited
• rootcause:
  Inherited
• policereport:
  Inherited
• spatialaccuracy:
  Inherited
Templates:
• Name: Gauge
  Description:
  Prototype:
  toreflocation: null
  locationerror: null
  datedamaged: null
  responsiblepartyname: null
  responsiblecontactname: null
  responsiblepartyaddress: null
  responsiblepartycity: null
  responsiblepartystate: null
  responsiblepartyphone: null
  responsiblepartytype: null
  incidentlocationaddress: null
  incidentlocationcity: null
  incidentlocationstate: null
  damagetype: Gauge
  damagedfacilitytype: null
  equipcausingdamage: null
  worktype: null
  rootcause: null
  policereport: 1
  remarks: null
  spatialaccuracy: null
  gpsx: null
  gpsy: null
  eventid: null
  fromdate: null
  todate: null
  engrouteid: null
  engroutename: null
  engfromm: null
  engtorouteid: null
  engtoroutename: null
  engtom: null
  continrouteid: null
  continroutename: null
  continfromm: null
  contintom: null
  fromrefmethod: null
  fromrefoffset: null
  fromreflocation: null
  torefmethod: null
  torefoffset: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Line Cut
Name: Line Cut
Domains:
• responsiblepartystate:
  Inherited
• responsiblepartytype:
  Inherited
• incidentlocationstate:
  Inherited
• damagetype:
  Inherited
• damagedfacilitytype:
  Inherited
• equipcausingdamage:
  Inherited
• worktype:
  Inherited
• rootcause:
  Inherited
• policereport:
  Inherited
• spatialaccuracy:
  Inherited
Templates:
• Name: Line Cut
  Description:
  Prototype:
  toreflocation: null
  locationerror: null
  datedamaged: null
  responsiblepartyname: null
  responsiblecontactname: null
  responsiblepartyaddress: null
  responsiblepartycity: null
  responsiblepartystate: null
  responsiblepartyphone: null
  responsiblepartytype: null
  incidentlocationaddress: null
  incidentlocationcity: null
  incidentlocationstate: null
  damagetype: Line Cut
  damagedfacilitytype: null
  equipcausingdamage: null
  worktype: null
  rootcause: null
  policereport: 1
  remarks: null
  spatialaccuracy: null
  gpsx: null
  gpsy: null
  eventid: null
  fromdate: null
  todate: null
  engrouteid: null
  engroutename: null
  engfromm: null
  engtorouteid: null
  engtoroutename: null
  engtom: null
  continrouteid: null
  continroutename: null
  continfromm: null
  contintom: null
  fromrefmethod: null
  fromrefoffset: null
  fromreflocation: null
  torefmethod: null
  torefoffset: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Other
Name: Other
Domains:
• responsiblepartystate:
  Inherited
• responsiblepartytype:
  Inherited
• incidentlocationstate:
  Inherited
• damagetype:
  Inherited
• damagedfacilitytype:
  Inherited
• equipcausingdamage:
  Inherited
• worktype:
  Inherited
• rootcause:
  Inherited
• policereport:
  Inherited
• spatialaccuracy:
  Inherited
Templates:
• Name: Other
  Description:
  Prototype:
  toreflocation: null
  locationerror: null
  datedamaged: null
  responsiblepartyname: null
  responsiblecontactname: null
  responsiblepartyaddress: null
  responsiblepartycity: null
  responsiblepartystate: null
  responsiblepartyphone: null
  responsiblepartytype: null
  incidentlocationaddress: null
  incidentlocationcity: null
  incidentlocationstate: null
  damagetype: Other
  damagedfacilitytype: null
  equipcausingdamage: null
  worktype: null
  rootcause: null
  policereport: 1
  remarks: null
  spatialaccuracy: null
  gpsx: null
  gpsy: null
  eventid: null
  fromdate: null
  todate: null
  engrouteid: null
  engroutename: null
  engfromm: null
  engtorouteid: null
  engtoroutename: null
  engtom: null
  continrouteid: null
  continroutename: null
  continfromm: null
  contintom: null
  fromrefmethod: null
  fromrefoffset: null
  fromreflocation: null
  torefmethod: null
  torefoffset: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Pulled
Name: Pulled
Domains:
• responsiblepartystate:
  Inherited
• responsiblepartytype:
  Inherited
• incidentlocationstate:
  Inherited
• damagetype:
  Inherited
• damagedfacilitytype:
  Inherited
• equipcausingdamage:
  Inherited
• worktype:
  Inherited
• rootcause:
  Inherited
• policereport:
  Inherited
• spatialaccuracy:
  Inherited
Templates:
• Name: Pulled
  Description:
  Prototype:
  toreflocation: null
  locationerror: null
  datedamaged: null
  responsiblepartyname: null
  responsiblecontactname: null
  responsiblepartyaddress: null
  responsiblepartycity: null
  responsiblepartystate: null
  responsiblepartyphone: null
  responsiblepartytype: null
  incidentlocationaddress: null
  incidentlocationcity: null
  incidentlocationstate: null
  damagetype: Pulled
  damagedfacilitytype: null
  equipcausingdamage: null
  worktype: null
  rootcause: null
  policereport: 1
  remarks: null
  spatialaccuracy: null
  gpsx: null
  gpsy: null
  eventid: null
  fromdate: null
  todate: null
  engrouteid: null
  engroutename: null
  engfromm: null
  engtorouteid: null
  engtoroutename: null
  engtom: null
  continrouteid: null
  continroutename: null
  continfromm: null
  contintom: null
  fromrefmethod: null
  fromrefoffset: null
  fromreflocation: null
  torefmethod: null
  torefoffset: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Puncture
Name: Puncture
Domains:
• responsiblepartystate:
  Inherited
• responsiblepartytype:
  Inherited
• incidentlocationstate:
  Inherited
• damagetype:
  Inherited
• damagedfacilitytype:
  Inherited
• equipcausingdamage:
  Inherited
• worktype:
  Inherited
• rootcause:
  Inherited
• policereport:
  Inherited
• spatialaccuracy:
  Inherited
Templates:
• Name: Puncture
  Description:
  Prototype:
  toreflocation: null
  locationerror: null
  datedamaged: null
  responsiblepartyname: null
  responsiblecontactname: null
  responsiblepartyaddress: null
  responsiblepartycity: null
  responsiblepartystate: null
  responsiblepartyphone: null
  responsiblepartytype: null
  incidentlocationaddress: null
  incidentlocationcity: null
  incidentlocationstate: null
  damagetype: Puncture
  damagedfacilitytype: null
  equipcausingdamage: null
  worktype: null
  rootcause: null
  policereport: 1
  remarks: null
  spatialaccuracy: null
  gpsx: null
  gpsy: null
  eventid: null
  fromdate: null
  todate: null
  engrouteid: null
  engroutename: null
  engfromm: null
  engtorouteid: null
  engtoroutename: null
  engtom: null
  continrouteid: null
  continroutename: null
  continfromm: null
  contintom: null
  fromrefmethod: null
  fromrefoffset: null
  fromreflocation: null
  torefmethod: null
  torefoffset: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Unknown
Name: Unknown
Domains:
• responsiblepartystate:
  Inherited
• responsiblepartytype:
  Inherited
• incidentlocationstate:
  Inherited
• damagetype:
  Inherited
• damagedfacilitytype:
  Inherited
• equipcausingdamage:
  Inherited
• worktype:
  Inherited
• rootcause:
  Inherited
• policereport:
  Inherited
• spatialaccuracy:
  Inherited
Templates:
• Name: Unknown
  Description:
  Prototype:
  toreflocation: null
  locationerror: null
  datedamaged: null
  responsiblepartyname: null
  responsiblecontactname: null
  responsiblepartyaddress: null
  responsiblepartycity: null
  responsiblepartystate: null
  responsiblepartyphone: null
  responsiblepartytype: null
  incidentlocationaddress: null
  incidentlocationcity: null
  incidentlocationstate: null
  damagetype: Unknown
  damagedfacilitytype: null
  equipcausingdamage: null
  worktype: null
  rootcause: null
  policereport: 1
  remarks: null
  spatialaccuracy: null
  gpsx: null
  gpsy: null
  eventid: null
  fromdate: null
  todate: null
  engrouteid: null
  engroutename: null
  engfromm: null
  engtorouteid: null
  engtoroutename: null
  engtom: null
  continrouteid: null
  continroutename: null
  continfromm: null
  contintom: null
  fromrefmethod: null
  fromrefoffset: null
  fromreflocation: null
  torefmethod: null
  torefoffset: null
  
  Drawing Tool: esriFeatureEditToolLine

---

Capabilities: Query,Create,Update,Delete,Uploads,Editing,Sync,ChangeTracking

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Supports OidReservation: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: true

Supports Coordinates Quantization: true

Child Resources:

Supported Operations:   Query   Query Attachments   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Append   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata