Name: City of Waterloo One-Ways

Display Field: STREET_NAME

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: SDE_USER.ROADS

Copyright Text:

Min. Scale: 18055.954822

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -8975288.10705021
YMin: 5377879.4995742
XMax: -8958564.86666642
YMax: 5393168.05715701
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[140,140,140,255],"width":1}},"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:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• SEGMENT_ID (type: esriFieldTypeInteger, alias: SEGMENT_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SEQUENCE (type: esriFieldTypeDouble, alias: SEQUENCE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• STREET_NAME (type: esriFieldTypeString, alias: STREET_NAME, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• STREET_NAME_ID (type: esriFieldTypeInteger, alias: STREET_NAME_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FROM_LEFT (type: esriFieldTypeSmallInteger, alias: FROM_LEFT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TO_LEFT (type: esriFieldTypeSmallInteger, alias: TO_LEFT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FROM_RIGHT (type: esriFieldTypeSmallInteger, alias: FROM_RIGHT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TO_RIGHT (type: esriFieldTypeSmallInteger, alias: TO_RIGHT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LOW__ (type: esriFieldTypeSmallInteger, alias: _LOW, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HIGH__ (type: esriFieldTypeSmallInteger, alias: _HIGH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RANGE__ (type: esriFieldTypeString, alias: _RANGE, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• LEFT_PARITY (type: esriFieldTypeString, alias: LEFT_PARITY, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• RIGHT_PARITY (type: esriFieldTypeString, alias: RIGHT_PARITY, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• LEFT_MUNICIPALITY (type: esriFieldTypeString, alias: LEFT_MUNICIPALITY, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• RIGHT_MUNICIPALITY (type: esriFieldTypeString, alias: RIGHT_MUNICIPALITY, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• CRISYS_STREET_NAMES (type: esriFieldTypeString, alias: _ALT_STREET_NAMES, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• FROM_STREET (type: esriFieldTypeString, alias: FROM_STREET, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• FROM_STREET_ID (type: esriFieldTypeInteger, alias: FROM_STREET_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TO_STREET (type: esriFieldTypeString, alias: TO_STREET, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• TO_STREET_ID (type: esriFieldTypeInteger, alias: TO_STREET_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LIFECYCLE_STATUS (type: esriFieldTypeString, alias: LIFECYCLE_STATUS, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Active: Active], [Proposed: Proposed], [Abandoned: Abandoned], ... 4 more ...)
• STATUS_PHYSICAL (type: esriFieldTypeString, alias: STATUS_PHYSICAL, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• STATUS_PLANNING (type: esriFieldTypeString, alias: STATUS_PLANNING, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• STREET_TYPE (type: esriFieldTypeString, alias: STREET_TYPE, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• STREET_CLASS (type: esriFieldTypeString, alias: STREET_CLASS, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• CARTO_CLASS (type: esriFieldTypeString, alias: CARTO_CLASS, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• OWNED_BY (type: esriFieldTypeString, alias: OWNED_BY, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• MANAGED_BY (type: esriFieldTypeString, alias: MANAGED_BY, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• MAIN_ROAD (type: esriFieldTypeString, alias: MAIN_ROAD, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• FLOW_DIRECTION (type: esriFieldTypeString, alias: FLOW_DIRECTION, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• SURFACE_TYPE (type: esriFieldTypeString, alias: SURFACE_TYPE, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• NUMBER_LANES (type: esriFieldTypeSmallInteger, alias: NUMBER_LANES, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ROAD_WIDTH (type: esriFieldTypeDouble, alias: ROAD_WIDTH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SPEED_ZONE (type: esriFieldTypeSmallInteger, alias: SPEED_ZONE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• REGIONAL_ROAD_NUMBER (type: esriFieldTypeSmallInteger, alias: REGIONAL_ROAD_NUMBER, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PUBLIC_ACCESS (type: esriFieldTypeString, alias: PUBLIC_ACCESS, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• STREET_INDEX (type: esriFieldTypeString, alias: STREET_INDEX, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• RUNCARD_ID (type: esriFieldTypeSmallInteger, alias: RUNCARD_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FIRE_ROUTE (type: esriFieldTypeString, alias: FIRE_ROUTE, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Primary: Primary], [Secondary: Secondary], [NA: NA])
• DEMAND_ZONE (type: esriFieldTypeSmallInteger, alias: DEMAND_ZONE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TANKER_RQR (type: esriFieldTypeString, alias: TANKER_RQR, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• FIRST (type: esriFieldTypeSmallInteger, alias: FIRST, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SECOND (type: esriFieldTypeSmallInteger, alias: SECOND, SQL Type: sqlTypeOther, nullable: true, editable: true)
• THIRD (type: esriFieldTypeSmallInteger, alias: THIRD, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FOURTH (type: esriFieldTypeSmallInteger, alias: FOURTH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RP_CLASS (type: esriFieldTypeSmallInteger, alias: RP_CLASS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RP_ROUTE_CODE (type: esriFieldTypeSmallInteger, alias: RP_ROUTE_CODE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CUL_DE_SAC (type: esriFieldTypeString, alias: CUL_DE_SAC, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• CUL_DE_SAC_ISLAND (type: esriFieldTypeString, alias: CUL_DE_SAC_ISLAND, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• CUL_DE_SAC_GRASS_CODE (type: esriFieldTypeString, alias: CUL_DE_SAC_GRASS_CODE, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• NOTES (type: esriFieldTypeString, alias: NOTES, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• CREATE_DATE (type: esriFieldTypeDate, alias: CREATE_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• CREATE_USER (type: esriFieldTypeString, alias: CREATE_USER, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: false)
• UPDATE_DATE (type: esriFieldTypeDate, alias: UPDATE_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• UPDATE_USER (type: esriFieldTypeString, alias: UPDATE_USER, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: false)
• ROW_ID (type: esriFieldTypeString, alias: ROW_ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• MXLOCATION (type: esriFieldTypeString, alias: MXLOCATION, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• MXSITEID (type: esriFieldTypeString, alias: MXSITEID, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• MXCREATIONSTATE (type: esriFieldTypeSmallInteger, alias: MXCREATIONSTATE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ROWSTAMP (type: esriFieldTypeString, alias: ROWSTAMP, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• GLOBAL_ID (type: esriFieldTypeGUID, alias: GLOBAL_ID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• MEDIAN (type: esriFieldTypeString, alias: MEDIAN, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• AADT (type: esriFieldTypeInteger, alias: AADT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AADT_DATE (type: esriFieldTypeDate, alias: AADT_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• AADT_SOURCE (type: esriFieldTypeString, alias: AADT_SOURCE, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• SCHOOL_ZONE (type: esriFieldTypeString, alias: SCHOOL_ZONE, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

Name: Minor, ToFrom
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• MAIN_ROAD: N
• STREET_TYPE: ROAD
• FLOW_DIRECTION: ToFrom
Name: Major, FromTo, Ramp
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• MAIN_ROAD: Y
• STREET_TYPE: RAMP
• FLOW_DIRECTION: FromTo
Name: Minor, FromTo
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• MAIN_ROAD: N
• STREET_TYPE: ROAD
• FLOW_DIRECTION: FromTo
Name: Minor, FromTo, Lane
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• MAIN_ROAD: N
• STREET_TYPE: ACCESS LANE
• FLOW_DIRECTION: FromTo
Name: Major, FromTo
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• MAIN_ROAD: Y
• STREET_TYPE: ROAD
• FLOW_DIRECTION: FromTo
Name: Major, ToFrom
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• MAIN_ROAD: Y
• STREET_TYPE: REG RD
• FLOW_DIRECTION: ToFrom

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/27/2023 2:50:38 PM

Schema Last Edit Date: 4/27/2023 2:50:38 PM

Data Last Edit Date: 4/27/2023 2:50:38 PM

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