Name: District of Lake Country Street Centrelines
Display Field: road_name
Type: Feature Layer
Geometry Type: esriGeometryPolyline
Description: dlcsde.spatial.TRN_Streets
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: 323907.9816
YMin: 5542031.3971
XMax: 335056.6465
YMax: 5558287.5041
Spatial Reference: 26911 (26911)
Drawing Info:
{"renderer":{"authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[210,252,247,255],"toColor":[210,252,247,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,182,245,255],"toColor":[252,182,245,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,190,179,255],"toColor":[252,190,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,249,182,255],"toColor":[252,249,182,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[182,197,252,255],"toColor":[182,197,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[182,252,192,255],"toColor":[182,252,192,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,234,207,255],"toColor":[252,234,207,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[184,224,252,255],"toColor":[184,224,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[240,215,252,255],"toColor":[240,215,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[210,179,252,255],"toColor":[210,179,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,184,206,255],"toColor":[252,184,206,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[231,252,210,255],"toColor":[231,252,210,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[223,252,184,255],"toColor":[223,252,184,255]}]}},"type":"uniqueValue","field1":"road_centreline_type","fieldDelimiter":",","defaultSymbol":{"color":[130,130,130,255],"width":1,"type":"esriSLS","style":"esriSLSSolid"},"defaultLabel":"","uniqueValueInfos":[{"symbol":{"color":[252,232,207,255],"width":1,"type":"esriSLS","style":"esriSLSSolid"},"value":"0","label":"Road"},{"symbol":{"color":[185,179,252,255],"width":1,"type":"esriSLS","style":"esriSLSSolid"},"value":"1","label":"Frontage Road"},{"symbol":{"color":[182,252,252,255],"width":1,"type":"esriSLS","style":"esriSLSSolid"},"value":"2","label":"Highway Interchange"},{"symbol":{"color":[188,252,184,255],"width":1,"type":"esriSLS","style":"esriSLSSolid"},"value":"3","label":"Street Lane"},{"symbol":{"color":[252,189,220,255],"width":1,"type":"esriSLS","style":"esriSLSSolid"},"value":"4","label":"Access Lane"},{"symbol":{"color":[210,222,252,255],"width":1,"type":"esriSLS","style":"esriSLSSolid"},"value":"5","label":"Railway"}]},"labelingInfo":[{"labelExpression":null,"labelExpressionInfo":{"expression":"$feature[\"road_name\"]","value":"{road_name}"},"useCodedValues":true,"maxScale":0,"minScale":0,"where":null,"labelPlacement":"esriServerLinePlacementAboveAlong","symbol":{"color":[51,51,51,255],"type":"esriTS","backgroundColor":null,"borderLineColor":null,"haloSize":0,"haloColor":null,"horizontalAlignment":"center","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"text":"","rotated":false,"kerning":true,"font":{"size":9.75,"style":"normal","decoration":"none","weight":"bold","family":"Arial"}}}],"transparency":0}
HasZ: false
HasM: false
Has Attachments: false
Has Geometry Properties: true
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Object ID Field: objectid
Unique ID Field:
IsSystemMaintained : True
Global ID Field: globalid
Type ID Field: road_centreline_type
Fields:
- objectid (type: esriFieldTypeOID, alias: objectid, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- road_centreline_type (type: esriFieldTypeInteger, alias: ROAD_CENTRELINE_TYPE, SQL Type: sqlTypeOther, nullable: true, editable: true)
- road_centreline_type2 (type: esriFieldTypeString, alias: ROAD_CENTRELINE_TYPE2, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true, Coded Values: [Access Lane: Access Lane], [Frontage Road: Frontage Road], [Highway Interchange: Highway Interchange], ... 3 more ...)
- globalid (type: esriFieldTypeGlobalID, alias: GLOBALID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
- description (type: esriFieldTypeString, alias: DESCRIPTION, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- legacyid (type: esriFieldTypeString, alias: LEGACYID, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- material (type: esriFieldTypeString, alias: MATERIAL, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Asphalt: Asphalt], [Concrete: Concrete], [Grass: Grass], ... 1 more ...)
- road_name (type: esriFieldTypeString, alias: ROAD_NAME, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- roadcode (type: esriFieldTypeString, alias: ROADCODE, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
- rd_class (type: esriFieldTypeString, alias: RD_CLASS, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true, Coded Values: [Arterial: Arterial], [Collector: Collector], [Local: Local], ... 3 more ...)
- no_lane (type: esriFieldTypeInteger, alias: NO_LANE, SQL Type: sqlTypeOther, nullable: true, editable: true)
- speed (type: esriFieldTypeString, alias: SPEED, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0: 0], [10: 10], [20: 20], ... 9 more ...)
- row_width (type: esriFieldTypeString, alias: ROW_WIDTH, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
- paving_date (type: esriFieldTypeDate, alias: PAVING_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- leftfrom (type: esriFieldTypeInteger, alias: LEFTFROM, SQL Type: sqlTypeOther, nullable: true, editable: true)
- rightfrom (type: esriFieldTypeInteger, alias: RIGHTFROM, SQL Type: sqlTypeOther, nullable: true, editable: true)
- leftto (type: esriFieldTypeInteger, alias: LEFTTO, SQL Type: sqlTypeOther, nullable: true, editable: true)
- rightto (type: esriFieldTypeInteger, alias: RIGHTTO, SQL Type: sqlTypeOther, nullable: true, editable: true)
- date_constructed (type: esriFieldTypeDate, alias: DATE_CONSTRUCTED, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- date_closed (type: esriFieldTypeDate, alias: DATE_CLOSED, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- designation (type: esriFieldTypeString, alias: DESIGNATION, SQL Type: sqlTypeOther, length: 18, nullable: true, editable: true, Coded Values: [Commercial: Commercial], [Land Development: Land Development], [Metro Vancouver: Metro Vancouver], ... 2 more ...)
- disaster_response_route (type: esriFieldTypeString, alias: DISASTER_RESPONSE_ROUTE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Primary: Primary], [Secondary: Secondary], [No: No])
- major_road_network (type: esriFieldTypeString, alias: MAJOR_ROAD_NETWORK, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- streetsweeping_route (type: esriFieldTypeString, alias: STREETSWEEPING_ROUTE, SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true)
- truck_route (type: esriFieldTypeString, alias: TRUCK_ROUTE, SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true)
- greenway (type: esriFieldTypeString, alias: GREENWAY, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- gcroads (type: esriFieldTypeString, alias: GCROADS, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- gcpredir (type: esriFieldTypeString, alias: GCPREDIR, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- gcname (type: esriFieldTypeString, alias: GCNAME, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- gctype (type: esriFieldTypeString, alias: GCTYPE, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- gcsufdir (type: esriFieldTypeString, alias: GCSUFDIR, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- status (type: esriFieldTypeString, alias: STATUS, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true, Coded Values: [Capital: Captial], [Closed to Traffic: Closed to Traffic], [Landlocked: Landlocked], ... 3 more ...)
- project_no (type: esriFieldTypeString, alias: PROJECT_NO, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- yr (type: esriFieldTypeSmallInteger, alias: YR, SQL Type: sqlTypeOther, nullable: true, editable: true)
- owner (type: esriFieldTypeString, alias: OWNER, SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true, Coded Values: [DLC: DLC], [Hydro: Hydro], [Other Municipality: Other Municipality], ... 3 more ...)
- location (type: esriFieldTypeString, alias: LOCATION, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
- comments (type: esriFieldTypeString, alias: COMMENTS, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- map_page (type: esriFieldTypeString, alias: MAP_PAGE, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
- status_parks (type: esriFieldTypeString, alias: STATUS_PARKS, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
- status_date (type: esriFieldTypeDate, alias: STATUS_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- park_ownership (type: esriFieldTypeString, alias: PARK_OWNERSHIP, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
- maintenance_responsibility (type: esriFieldTypeString, alias: MAINTENANCE_RESPONSIBILITY, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
- operational_responsibility (type: esriFieldTypeString, alias: OPERATIONAL_RESPONSIBILITY, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
- work_assignment (type: esriFieldTypeString, alias: WORK_ASSIGNMENT, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- inservice_date (type: esriFieldTypeDate, alias: INSERVICE_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- inservice_cost (type: esriFieldTypeDouble, alias: INSERVICE_COST, SQL Type: sqlTypeOther, nullable: true, editable: true)
- yrs_life_expectancy (type: esriFieldTypeDouble, alias: YRS_LIFE_EXPECTANCY, SQL Type: sqlTypeOther, nullable: true, editable: true)
- warranty_provider (type: esriFieldTypeString, alias: WARRANTY_PROVIDER, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- park_legacy_id (type: esriFieldTypeString, alias: PARK_LEGACY_ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- operating_location (type: esriFieldTypeString, alias: OPERATING_LOCATION, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- operating_location_type (type: esriFieldTypeString, alias: OPERATING_LOCATION_TYPE, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- structures_inspection_route (type: esriFieldTypeString, alias: STRUCTURES_INSPECTION_ROUTE, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
- gis_entry_stage (type: esriFieldTypeString, alias: GIS_ENTRY_STAGE, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [EC: EC], [Initial AB: Initial AB], [Final AB: Final AB])
- warrantydate (type: esriFieldTypeDate, alias: WARRANTYDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- condition (type: esriFieldTypeString, alias: CONDITION, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- conditiondate (type: esriFieldTypeDate, alias: CONDITIONDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- ytd_cost (type: esriFieldTypeDouble, alias: YTD_COST, SQL Type: sqlTypeOther, nullable: true, editable: true)
- lifecycle_cost (type: esriFieldTypeDouble, alias: LIFECYCLE_COST, SQL Type: sqlTypeOther, nullable: true, editable: true)
- cre_by (type: esriFieldTypeString, alias: CRE_BY, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
- cre_date (type: esriFieldTypeDate, alias: CRE_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- mod_by (type: esriFieldTypeString, alias: MOD_BY, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
- mod_date (type: esriFieldTypeDate, alias: MOD_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- aas_id (type: esriFieldTypeSmallInteger, alias: AAS_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
- assetid (type: esriFieldTypeString, alias: ASSETID, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- streetplowingpriority (type: esriFieldTypeString, alias: Street Plowing Priority, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
- sidewalkplowingpriority (type: esriFieldTypeString, alias: Sidewalk Plowing Priority, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
- Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)
Types:
ID: 0
Name: Road
Domains:
- Field Name: road_centreline_type2
Inherited
- Field Name: material
Inherited
- Field Name: rd_class
Inherited
- Field Name: speed
Inherited
- Field Name: designation
Inherited
- Field Name: disaster_response_route
Inherited
- Field Name: major_road_network
Inherited
- Field Name: greenway
Inherited
- Field Name: status
Inherited
- Field Name: gis_entry_stage
Inherited
Templates:
Name: Road
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- road_centreline_type: 0
- road_centreline_type2: Road
- owner: Surrey
- gis_entry_stage: Initial AB
ID: 1
Name: Frontage Road
Domains:
- Field Name: road_centreline_type2
Inherited
- Field Name: material
Inherited
- Field Name: rd_class
Inherited
- Field Name: speed
Inherited
- Field Name: designation
Inherited
- Field Name: disaster_response_route
Inherited
- Field Name: major_road_network
Inherited
- Field Name: greenway
Inherited
- Field Name: status
Inherited
- Field Name: gis_entry_stage
Inherited
Templates:
Name: Frontage Road
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- road_centreline_type: 1
- road_centreline_type2: Frontage Road
- status: Open
- yr: 2009
- owner: Surrey
- gis_entry_stage: Initial AB
ID: 2
Name: Highway Interchange
Domains:
- Field Name: road_centreline_type2
Inherited
- Field Name: material
Inherited
- Field Name: rd_class
Inherited
- Field Name: speed
Inherited
- Field Name: designation
Inherited
- Field Name: disaster_response_route
Inherited
- Field Name: major_road_network
Inherited
- Field Name: greenway
Inherited
- Field Name: status
Inherited
- Field Name: gis_entry_stage
Inherited
Templates:
Name: Highway Interchange
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- road_centreline_type: 2
- road_centreline_type2: Highway Interchange
- owner: Surrey
- gis_entry_stage: Initial AB
ID: 3
Name: Street Lane
Domains:
- Field Name: road_centreline_type2
Inherited
- Field Name: material
Inherited
- Field Name: rd_class
Inherited
- Field Name: speed
Inherited
- Field Name: designation
Inherited
- Field Name: disaster_response_route
Inherited
- Field Name: major_road_network
Inherited
- Field Name: greenway
Inherited
- Field Name: status
Inherited
- Field Name: gis_entry_stage
Inherited
Templates:
Name: Street Lane
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- road_centreline_type: 3
- road_centreline_type2: Street Lane
- owner: Surrey
- gis_entry_stage: Initial AB
ID: 4
Name: Access Lane
Domains:
- Field Name: road_centreline_type2
Inherited
- Field Name: material
Inherited
- Field Name: rd_class
Inherited
- Field Name: speed
Inherited
- Field Name: designation
Inherited
- Field Name: disaster_response_route
Inherited
- Field Name: major_road_network
Inherited
- Field Name: greenway
Inherited
- Field Name: status
Inherited
- Field Name: gis_entry_stage
Inherited
Templates:
Name: Access Lane
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- road_centreline_type: 4
- road_centreline_type2: Access Lane
- owner: Surrey
- gis_entry_stage: Initial AB
ID: 5
Name: Railway
Domains:
- Field Name: road_centreline_type2
Inherited
- Field Name: material
Inherited
- Field Name: rd_class
Inherited
- Field Name: speed
Inherited
- Field Name: designation
Inherited
- Field Name: disaster_response_route
Inherited
- Field Name: major_road_network
Inherited
- Field Name: greenway
Inherited
- Field Name: status
Inherited
- Field Name: gis_entry_stage
Inherited
Templates:
Name: Railway
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- road_centreline_type: 5
- road_centreline_type2: Railway
- owner: Surrey
- gis_entry_stage: Initial AB
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 7/9/2021 6:28:16 PM
Schema Last Edit Date: 7/9/2021 6:28:16 PM
Data Last Edit Date: 7/9/2021 6:28:16 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat