View In:   ArcGIS Online Map Viewer

Name: TrafficAnalysis.dbo.MaintCostSummary_StoredView

Display Field: DistrictName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 20000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

Supports Datum Transformation: true

Extent:

XMin: -103.16800206299996
YMin: 46.628799067000045
XMax: -97.28779805399995
YMax: 48.278300966000074
Spatial Reference: 4326  (4326)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [48, 150, 114, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• Id ( type: esriFieldTypeOID, alias: Id, editable: false, nullable: false, defaultValue: null, modelName: Id )
• District_No ( type: esriFieldTypeInteger, alias: District_No, editable: true, nullable: true, defaultValue: null, modelName: District_No )
• DistrictName ( type: esriFieldTypeString, alias: DistrictName, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DistrictName )
• MaintenanceDate ( type: esriFieldTypeDate, alias: MaintenanceDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: MaintenanceDate )
• MaintenanceMonth ( type: esriFieldTypeString, alias: MaintenanceMonth, editable: true, nullable: true, length: 10, defaultValue: null, modelName: MaintenanceMonth )
• MaintenanceYear ( type: esriFieldTypeString, alias: MaintenanceYear, editable: true, nullable: true, length: 10, defaultValue: null, modelName: MaintenanceYear )
• MatCost ( type: esriFieldTypeDouble, alias: MatCost, editable: true, nullable: true, defaultValue: null, modelName: MatCost )
• LaborTotal ( type: esriFieldTypeDouble, alias: LaborTotal, editable: true, nullable: true, defaultValue: null, modelName: LaborTotal )
• EquipmentCost ( type: esriFieldTypeDouble, alias: EquipmentCost, editable: true, nullable: true, defaultValue: null, modelName: EquipmentCost )
• GrandTotal ( type: esriFieldTypeDouble, alias: GrandTotal, editable: true, nullable: true, defaultValue: null, modelName: GrandTotal )
• GT_TotalRange ( type: esriFieldTypeString, alias: GT_TotalRange, editable: true, nullable: true, length: 500, defaultValue: null, modelName: GT_TotalRange )
• MatCostLM ( type: esriFieldTypeDouble, alias: MatCostLM, editable: true, nullable: true, defaultValue: null, modelName: MatCostLM )
• MatCostTT ( type: esriFieldTypeDouble, alias: MatCostTT, editable: true, nullable: true, defaultValue: null, modelName: MatCostTT )
• MatCostLMByTT ( type: esriFieldTypeDouble, alias: MatCostLMByTT, editable: true, nullable: true, defaultValue: null, modelName: MatCostLMByTT )
• LabCostLM ( type: esriFieldTypeDouble, alias: LabCostLM, editable: true, nullable: true, defaultValue: null, modelName: LabCostLM )
• LabCostTT ( type: esriFieldTypeDouble, alias: LabCostTT, editable: true, nullable: true, defaultValue: null, modelName: LabCostTT )
• LabCostLMByTT ( type: esriFieldTypeDouble, alias: LabCostLMByTT, editable: true, nullable: true, defaultValue: null, modelName: LabCostLMByTT )
• GrandCostLM ( type: esriFieldTypeDouble, alias: GrandCostLM, editable: true, nullable: true, defaultValue: null, modelName: GrandCostLM )
• GrandCostTT ( type: esriFieldTypeDouble, alias: GrandCostTT, editable: true, nullable: true, defaultValue: null, modelName: GrandCostTT )
• GrandCostLMByTT ( type: esriFieldTypeDouble, alias: GrandCostLMByTT, editable: true, nullable: true, defaultValue: null, modelName: GrandCostLMByTT )

Templates:

• Name: TrafficAnalysis.dbo.MaintCostSummary_StoredView
  Description:
  Prototype:
  GrandCostTT: null
  GrandCostLMByTT: null
  District_No: null
  DistrictName: null
  MaintenanceDate: null
  MaintenanceMonth: null
  MaintenanceYear: null
  MatCost: null
  LaborTotal: null
  EquipmentCost: null
  GrandTotal: null
  GT_TotalRange: null
  MatCostLM: null
  MatCostTT: null
  MatCostLMByTT: null
  LabCostLM: null
  LabCostTT: null
  LabCostLMByTT: null
  GrandCostLM: 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

Supported Operations:   Query   Query DateBins   Query Attachments   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata