View In:   ArcGIS Online Map Viewer

Name: DBO.RNSSegmentsBudget2024

Display Field: FULL_NAME_1

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: POLYLINE DATA TO REPRESENT THE ROADS IN HALDIMAND COUNTY. DEVELOPED IN CONJUCTION WITH THE MTO FOR A PILOT PROJECT, TO DEMONSTRATE THE POWER IN GIS FOR THE RIMS DATA COLLECTION AND ROAD NEEDS STUDIES WITHIN THE COUNTY.IT WAS ORIGINALLY BUILT BY THE MTO AS AN SLRN AROUND 1999, IN AUTOCAD, THEN CONVERTED AND TWEAKED BY DOUG REIMER IN 2002. THE FIRST GIS LAYER BUILT FOR/BY THE ENGINEERING DEPT, HALDIMAND COUNTY.

Service Item Id: ec53d0a5650848d6a0c95d7c6403b72c

Copyright Text: DAVE ANDERSON, DAVE GRAHAM, MTO, DOUG REIMER

Default Visibility: true

MaxRecordCount: 2000

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

Supports Datum Transformation: true

Extent:

XMin: 566410.0842000004
YMin: 4737814.030300001
XMax: 627642.5999999996
YMax: 4775973.08
Spatial Reference: 26917  (26917)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [65, 142, 41, 255]
Width: 1
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:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID_1, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• RIMS_ID ( type: esriFieldTypeString, alias: RIMS_ID, editable: true, nullable: true, length: 6, defaultValue: null, modelName: RIMS_ID )
• RNS_ID_1 ( type: esriFieldTypeInteger, alias: RNS_ID, editable: true, nullable: true, defaultValue: null, modelName: RNS_ID_1 )
• FULL_NAME_1 ( type: esriFieldTypeString, alias: FULL_NAME, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FULL_NAME_1 )
• FROM1 ( type: esriFieldTypeString, alias: FROM_, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FROM1 )
• TO1 ( type: esriFieldTypeString, alias: TO_, editable: true, nullable: true, length: 255, defaultValue: null, modelName: TO1 )
• OWNERSHIP ( type: esriFieldTypeString, alias: OWNERSHIP, editable: true, nullable: true, length: 255, defaultValue: null, modelName: OWNERSHIP )
• TOWN ( type: esriFieldTypeString, alias: TOWN, editable: true, nullable: true, length: 255, defaultValue: null, modelName: TOWN )
• PROGRAM ( type: esriFieldTypeString, alias: PROGRAM, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PROGRAM )
• NEED2 ( type: esriFieldTypeString, alias: NEED2, editable: true, nullable: true, length: 255, defaultValue: null, modelName: NEED2 )
• MATERIAL_1 ( type: esriFieldTypeString, alias: MATERIAL, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MATERIAL_1 )
• STREET_LOC_1 ( type: esriFieldTypeString, alias: STREET_LOC, editable: true, nullable: true, length: 255, defaultValue: null, modelName: STREET_LOC_1 )
• Speed_1 ( type: esriFieldTypeInteger, alias: Speed, editable: true, nullable: true, defaultValue: null, modelName: Speed_1 )
• LANES_1 ( type: esriFieldTypeInteger, alias: LANES, editable: true, nullable: true, defaultValue: null, modelName: LANES_1 )
• Length_1 ( type: esriFieldTypeDouble, alias: Length, editable: true, nullable: true, defaultValue: null, modelName: Length_1 )
• Width_1 ( type: esriFieldTypeDouble, alias: Width, editable: true, nullable: true, defaultValue: null, modelName: Width_1 )
• PCI ( type: esriFieldTypeDouble, alias: PCI 2021 Actual, editable: true, nullable: true, defaultValue: null, modelName: PCI )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Status )
• ProjectSubmission ( type: esriFieldTypeString, alias: ProjectSubmission, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ProjectSubmission )
• ReferenceTable ( type: esriFieldTypeString, alias: ReferenceTable, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ReferenceTable )
• UpdatedInReferenceTable ( type: esriFieldTypeString, alias: UpdatedInReferenceTable, editable: true, nullable: true, length: 255, defaultValue: null, modelName: UpdatedInReferenceTable )
• VerificationNeeded ( type: esriFieldTypeString, alias: VerificationNeeded, editable: true, nullable: true, length: 255, defaultValue: null, modelName: VerificationNeeded )
• DuplicateGeometry ( type: esriFieldTypeString, alias: DuplicateGeometry, editable: true, nullable: true, length: 255, defaultValue: null, modelName: DuplicateGeometry )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: true, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: true, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• OBJECTID_1 ( type: esriFieldTypeInteger, alias: OBJECTID, editable: true, nullable: true, defaultValue: null, modelName: OBJECTID_1 )
• AADT___2021_2022 ( type: esriFieldTypeInteger, alias: AADT - 2021, editable: true, nullable: true, defaultValue: null, modelName: AADT___2021_2022 )
• MMS_Class_1 ( type: esriFieldTypeInteger, alias: MMS Class, editable: true, nullable: true, defaultValue: null, modelName: MMS_Class_1 )
• PCI_1 ( type: esriFieldTypeDouble, alias: PCI, editable: true, nullable: true, defaultValue: null, modelName: PCI_1 )
• DMI ( type: esriFieldTypeDouble, alias: DMI, editable: true, nullable: true, defaultValue: null, modelName: DMI )
• RCR ( type: esriFieldTypeInteger, alias: RCR, editable: true, nullable: true, defaultValue: null, modelName: RCR )
• Curb_Even ( type: esriFieldTypeString, alias: Curb Even, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Curb_Even )
• Curb_Odd ( type: esriFieldTypeString, alias: Curb Odd, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Curb_Odd )
• Sidewalk_Even ( type: esriFieldTypeSmallInteger, alias: Sidewalk Even, editable: true, nullable: true, defaultValue: null, modelName: Sidewalk_Even )
• Sidewalk_Odd ( type: esriFieldTypeSmallInteger, alias: Sidewalk Odd, editable: true, nullable: true, defaultValue: null, modelName: Sidewalk_Odd )
• Drainage ( type: esriFieldTypeString, alias: Drainage, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Drainage )
• Project_Year ( type: esriFieldTypeInteger, alias: Project Year, editable: true, nullable: true, defaultValue: null, modelName: Project_Year )
• COL_V ( type: esriFieldTypeString, alias: COL_V, editable: true, nullable: true, length: 255, defaultValue: null, modelName: COL_V )
• PCIDec2021 ( type: esriFieldTypeDouble, alias: PCIDec2021, editable: true, nullable: true, defaultValue: null, modelName: PCIDec2021 )
• PCIDec2022 ( type: esriFieldTypeDouble, alias: PCIDec2022, editable: true, nullable: true, defaultValue: null, modelName: PCIDec2022 )
• PCIDec2023 ( type: esriFieldTypeDouble, alias: PCIDec2023, editable: true, nullable: true, defaultValue: null, modelName: PCIDec2023 )
• PCIDec2024 ( type: esriFieldTypeDouble, alias: PCIDec2024, editable: true, nullable: true, defaultValue: null, modelName: PCIDec2024 )
• Shape__Length ( type: esriFieldTypeDouble, alias: Shape.STLength(), editable: false, nullable: false, defaultValue: null, modelName: Shape.STLength() )
• Asset_Mngmt_ID ( type: esriFieldTypeInteger, alias: Asset_Mngmt_ID, editable: true, nullable: true, defaultValue: null, modelName: Asset_Mngmt_ID )

Templates:

• Name: DBO.RNSSegmentsBudget2024
  Description:
  Prototype:
  PCIDec2024: null
  Asset_Mngmt_ID: null
  RIMS_ID: null
  RNS_ID_1: null
  FULL_NAME_1: null
  FROM1: null
  TO1: null
  OWNERSHIP: null
  TOWN: null
  PROGRAM: null
  NEED2: null
  MATERIAL_1: null
  STREET_LOC_1: null
  Speed_1: null
  LANES_1: null
  Length_1: null
  Width_1: null
  PCI: null
  Status: null
  ProjectSubmission: null
  ReferenceTable: null
  UpdatedInReferenceTable: null
  VerificationNeeded: null
  DuplicateGeometry: null
  created_user: null
  created_date: null
  last_edited_user: null
  last_edited_date: null
  OBJECTID_1: null
  AADT___2021_2022: null
  MMS_Class_1: null
  PCI_1: null
  DMI: null
  RCR: null
  Curb_Even: null
  Curb_Odd: null
  Sidewalk_Even: null
  Sidewalk_Odd: null
  Drainage: null
  Project_Year: null
  COL_V: null
  PCIDec2021: null
  PCIDec2022: null
  PCIDec2023: null
  
  Drawing Tool: esriFeatureEditToolLine

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 Attachments   Query Analytic   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata