View In:   ArcGIS Online Map Viewer

Name: esri_sde.DBO.Snow_Plow_Route

Display Field: STREETNAME

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Service Item Id: 26435943098449d881d7dc4505955192

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

MaxSelectionCount: 0

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: 1369427.1857019663
YMin: 445831.20668680966
XMax: 1398640.74997814
YMax: 490766.58761639893
Spatial Reference: 2893  (2893)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: Inspection_Status
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: 2
  Label: Checked, not plowed
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 0, 0, 255]
  Width: 5
• Value: 6
  Label: Completed
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [76, 230, 0, 255]
  Width: 5
• Value: 5
  Label: Needs salt
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 255, 0, 255]
  Width: 5
• Value: 1
  Label: Not checked
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [225, 225, 225, 255]
  Width: 5
• Value: 4
  Label: Open but needs follow up
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 112, 255, 255]
  Width: 5
• Value: 3
  Label: Small equipment needed
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [197, 0, 255, 255]
  Width: 5
Transparency: 0
Labeling Info:
Label Placement: esriServerLinePlacementAboveAlong
Label Expression: [STREETNAME]
Use Coded Values: true
Symbol:
Color: [0, 0, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: center
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 8
Font Family: Arial
Font Style: normal
Font Weight: normal
Font Decoration: none

Min. Scale: 0.0
Max. Scale: 0.0

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: Inspection_Status

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• STREETNAME ( type: esriFieldTypeString, alias: STREETNAME, editable: true, nullable: true, length: 50, defaultValue: null, modelName: STREETNAME )
• NOTES ( type: esriFieldTypeString, alias: NOTES, editable: true, nullable: true, length: 50, defaultValue: null, modelName: NOTES )
• Map_Num ( type: esriFieldTypeString, alias: Map_Num, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Map_Num )
• Route_Num ( type: esriFieldTypeString, alias: Route_Num, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Route_Num )
• MILES ( type: esriFieldTypeDouble, alias: MILES, editable: true, nullable: true, defaultValue: null, modelName: MILES )
• Inspection_Status ( type: esriFieldTypeString, alias: Inspection_Status, editable: true, nullable: true, length: 30, defaultValue: null, modelName: Inspection_Status , Coded Values: [1: Not checked] , [2: Checked, not plowed] , [3: Small equipment needed] , ...3 more... )
• Shape__Length ( type: esriFieldTypeDouble, alias: Shape.STLength(), editable: false, nullable: true, defaultValue: null, modelName: Shape.STLength(), required: true )
• Route_ID ( type: esriFieldTypeSmallInteger, alias: Route_ID, editable: true, nullable: true, defaultValue: null, modelName: Route_ID )

Types:

ID: 2
Name: Checked, not plowed
Domains:
• Inspection_Status:
  Inherited
Templates:
• Name: Checked, not plowed
  Description:
  Prototype:
  MILES: null
  Route_ID: null
  STREETNAME: null
  NOTES: null
  Map_Num: null
  Route_Num: null
  Inspection_Status: 2
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 6
Name: Completed
Domains:
• Inspection_Status:
  Inherited
Templates:
• Name: Completed
  Description:
  Prototype:
  MILES: null
  Route_ID: null
  STREETNAME: null
  NOTES: null
  Map_Num: null
  Route_Num: null
  Inspection_Status: 6
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 5
Name: Needs salt
Domains:
• Inspection_Status:
  Inherited
Templates:
• Name: Needs salt
  Description:
  Prototype:
  MILES: null
  Route_ID: null
  STREETNAME: null
  NOTES: null
  Map_Num: null
  Route_Num: null
  Inspection_Status: 5
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 1
Name: Not checked
Domains:
• Inspection_Status:
  Inherited
Templates:
• Name: Not checked
  Description:
  Prototype:
  MILES: null
  Route_ID: null
  STREETNAME: null
  NOTES: null
  Map_Num: null
  Route_Num: null
  Inspection_Status: 1
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 4
Name: Open but needs follow up
Domains:
• Inspection_Status:
  Inherited
Templates:
• Name: Open but needs follow up
  Description:
  Prototype:
  MILES: null
  Route_ID: null
  STREETNAME: null
  NOTES: null
  Map_Num: null
  Route_Num: null
  Inspection_Status: 4
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 3
Name: Small equipment needed
Domains:
• Inspection_Status:
  Inherited
Templates:
• Name: Small equipment needed
  Description:
  Prototype:
  MILES: null
  Route_ID: null
  STREETNAME: null
  NOTES: null
  Map_Num: null
  Route_Num: null
  Inspection_Status: 3
  
  Drawing Tool: esriFeatureEditToolLine

---

Relationships:

• Inspection Records (0) -- Related To: esri_sde.DBO.Plow_Inspection_Records (3)

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

Sync Can Return Changes: false

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:

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