Name: Transport - Roads

Display Field: STREET_NAME

Type: Feature Layer

Geometry Type: esriGeometryPolyline

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: 596231.953625
YMin: 4802912.841
XMax: 611103.391
YMax: 4820677.546
Spatial Reference: 26917 (26917)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[204,204,204,255],"width":1.3}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GLOBALID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• STREET_DIR (type: esriFieldTypeString, alias: STREET_DIR, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• L_LADD (type: esriFieldTypeString, alias: L_LADD, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• L_LSRC (type: esriFieldTypeString, alias: L_LSRC, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [I: Interpolated], [K: Known])
• L_HADD (type: esriFieldTypeString, alias: L_HADD, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• L_HSRC (type: esriFieldTypeString, alias: L_HSRC, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [I: Interpolated], [K: Known])
• R_LADD (type: esriFieldTypeString, alias: R_LADD, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• R_LSRC (type: esriFieldTypeString, alias: R_LSRC, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [I: Interpolated], [K: Known])
• R_HADD (type: esriFieldTypeString, alias: R_HADD, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• R_HSRC (type: esriFieldTypeString, alias: R_HSRC, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [I: Interpolated], [K: Known])
• L_POSTAL (type: esriFieldTypeString, alias: L_POSTAL, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• R_POSTAL (type: esriFieldTypeString, alias: R_POSTAL, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• STREET_CLA (type: esriFieldTypeString, alias: STREET_CLA, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [F: Freeway], [P: Proposed Freeway], [C: Regional Primary Arterial & Provincial Highways], ... 15 more ...)
• ONEWAY (type: esriFieldTypeString, alias: ONEWAY, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [FT: One Way])
• ONEWAY_DIR (type: esriFieldTypeString, alias: ONEWAY_DIR, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [NORTHBOUND: Northbound], [SOUTHBOUND: Southbound], [EASTBOUND: Eastbound], ... 1 more ...)
• DATA_ADD1 (type: esriFieldTypeString, alias: DATA_ADD1, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DATE_EDIT (type: esriFieldTypeString, alias: DATE_EDIT, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• COMMENTS (type: esriFieldTypeString, alias: COMMENTS, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• WIDTH (type: esriFieldTypeDouble, alias: WIDTH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GGM_ID (type: esriFieldTypeString, alias: GGM_ID, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• STATUS (type: esriFieldTypeString, alias: STATUS, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• CHECK_ (type: esriFieldTypeDouble, alias: CHECK_, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SECT_NO (type: esriFieldTypeString, alias: SECT_NO, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• SECT_OLD (type: esriFieldTypeString, alias: SECT_OLD, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• ROAD_NAME_ID (type: esriFieldTypeInteger, alias: ROAD_NAME_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SEGMENT_ID (type: esriFieldTypeInteger, alias: SEGMENT_ID, SQL Type: sqlTypeOther, nullable: false, editable: true)
• STREET_NAME (type: esriFieldTypeString, alias: STREET_NAME, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• STREET_TYPE (type: esriFieldTypeString, alias: STREET_TYPE, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• STREET_DIR_PREFIX (type: esriFieldTypeString, alias: STREET_DIR_PREFIX, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• STREET_TYPE_PREFIX (type: esriFieldTypeString, alias: STREET_TYPE_PREFIX, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• ALIAS_ST_D (type: esriFieldTypeString, alias: ALIAS_ST_D, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• JURISDICTION (type: esriFieldTypeString, alias: JURISDICTION, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [X: Private], [I: Indian Reserve], [P: Provincial], ... 5 more ...)
• FULL_STREET_NAME (type: esriFieldTypeString, alias: FULL_STREET_NAME, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• ROUTE (type: esriFieldTypeString, alias: ROUTE, SQL Type: sqlTypeOther, length: 110, nullable: true, editable: true)
• L_MUNC_ID (type: esriFieldTypeString, alias: L_MUNC_ID, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• R_MUNC_ID (type: esriFieldTypeString, alias: R_MUNC_ID, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• L_MUNC_FULL (type: esriFieldTypeString, alias: L_MUNC_FULL, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• R_MUNC_FULL (type: esriFieldTypeString, alias: R_MUNC_FULL, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• END_DATE (type: esriFieldTypeDate, alias: END_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ENG_CLASS (type: esriFieldTypeSmallInteger, alias: ENG_CLASS, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [1 - 6])
• SPEED_LIMIT (type: esriFieldTypeSmallInteger, alias: SPEED_LIMIT, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [40: 40], [50: 50], [60: 60], ... 3 more ...)
• HEIGHT_LIMIT (type: esriFieldTypeDouble, alias: HEIGHT_LIMIT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PLAN_CLASS (type: esriFieldTypeString, alias: PLAN_CLASS, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [H: Major Highway], [A: Major Arterial], [M: Multi-Purpose Arterial], ... 6 more ...)
• WEIGHT_LIMIT (type: esriFieldTypeDouble, alias: WEIGHT_LIMIT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PLOW_PR (type: esriFieldTypeInteger, alias: PLOW_PR, SQL Type: sqlTypeOther, nullable: false, editable: true)
• ENTRY_UID (type: esriFieldTypeString, alias: ENTRY_UID, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• ENTRY_WHEN (type: esriFieldTypeDate, alias: ENTRY_WHEN, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• GISID (type: esriFieldTypeInteger, alias: GISID, SQL Type: sqlTypeOther, nullable: false, editable: true)
• DATA_ADD (type: esriFieldTypeDate, alias: DATA_ADD, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• TOP_ALIAS (type: esriFieldTypeString, alias: TOP_ALIAS, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• PARENTID (type: esriFieldTypeString, alias: PARENTID, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• GLOBALID (type: esriFieldTypeGlobalID, alias: GLOBALID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• NUM_PASSES (type: esriFieldTypeSmallInteger, alias: NUM_PASSES, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WINTER_ZON (type: esriFieldTypeString, alias: WINTER_ZON, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ResurfacingStage (type: esriFieldTypeString, alias: ResurfacingStage, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [1: To Be Completed], [2: In Progress, Concrete Phase], [3: In Progress, Milling Phase], ... 3 more ...)
• created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

Name: Transport - Roads
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• SPEED_LIMIT: 50
• L_HSRC: K
• L_MUNC_ID: FCGKZ
• PLOW_PR: 0
• R_LSRC: K
• SEGMENT_ID: 0
• R_MUNC_ID: FCGKZ
• L_LSRC: K
• R_HSRC: K
• L_MUNC_FULL: OAKVILLE
• R_MUNC_FULL: OAKVILLE
• GISID: 0

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 12/8/2023 5:09:17 PM

Schema Last Edit Date: 12/8/2023 5:09:17 PM

Data Last Edit Date: 12/8/2023 5:09:17 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat