Name: Publish.dbo.CACHE_StreetsContractorWO
Display Field: contractorName
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: 2000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
Extent:
XMin: -97.044435799
YMin: 32.9892140150001
XMax: -96.87335561
YMax: 33.0846464700001
Spatial Reference: 4326 (4326)
Drawing Info:
{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[138,140,60,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: false
HasM: false
Has Attachments: false
Has Geometry Properties: false
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Object ID Field: ESRI_OID
Unique ID Field:
IsSystemMaintained : True
Global ID Field:
Type ID Field:
Fields:
- workOrderID (type: esriFieldTypeString, alias: workOrderID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- woDesc (type: esriFieldTypeString, alias: woDesc, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- submitTo (type: esriFieldTypeString, alias: submitTo, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- supervisor (type: esriFieldTypeString, alias: supervisor, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- dateInitiated (type: esriFieldTypeDate, alias: dateInitiated, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- daysElapsed (type: esriFieldTypeDouble, alias: daysElapsed, SQL Type: sqlTypeOther, nullable: true, editable: true)
- woAddress (type: esriFieldTypeString, alias: woAddress, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
- woLocation (type: esriFieldTypeString, alias: woLocation, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
- woPriorityCode (type: esriFieldTypeString, alias: woPriorityCode, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
- woPriorityDesc (type: esriFieldTypeString, alias: woPriorityDesc, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- woStatus (type: esriFieldTypeString, alias: woStatus, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- contractorID (type: esriFieldTypeDouble, alias: contractorID, SQL Type: sqlTypeOther, nullable: true, editable: true)
- contractorName (type: esriFieldTypeString, alias: contractorName, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- woEntity (type: esriFieldTypeString, alias: woEntity, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- custFieldID (type: esriFieldTypeDouble, alias: custFieldID, SQL Type: sqlTypeOther, nullable: true, editable: true)
- lat (type: esriFieldTypeDouble, alias: lat, SQL Type: sqlTypeOther, nullable: true, editable: true)
- lng (type: esriFieldTypeDouble, alias: lng, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ESRI_OID (type: esriFieldTypeOID, alias: ESRI_OID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
Templates:
Name: Publish.dbo.CACHE_StreetsContractorWO
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 9/25/2026 12:39:59 PM
Schema Last Edit Date: 9/25/2026 12:39:59 PM
Data Last Edit Date: 9/25/2026 12:39:59 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat