Layers:

Layer: NanaimoSDE.SIGNAGE.Streetlight (0)

Name: NanaimoSDE.SIGNAGE.Streetlight

Display Field: StLightAssetID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: <DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>Spatial representation of city owned streetlight poles across the City. Used in Cityworks to track sticker installs, or graffiti clean up by Traffic Unit. Used in Cityworks by PW Dispatch to track service requests for repairs by contractors.</SPAN></P></DIV></DIV></DIV>

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 423025.1261999998
YMin: 5439114.432600001
XMax: 436907.8411999997
YMax: 5455542.2502
Spatial Reference: 26910  (26910)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [173, 58, 133, 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: false
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: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• StLightAssetID ( type: esriFieldTypeString, alias: StLightAssetID, length: 50 )
• Status ( type: esriFieldTypeString, alias: Status, length: 50 , Coded Values: [ACTIVE: Active] , [PENDING: Pending] , [REMOVED: Removed] )
• Owner ( type: esriFieldTypeString, alias: Owner, length: 50 , Coded Values: [CITY: City of Nanaimo] , [MOT: Ministry of Transportation] , [NPA: Nanaimo Port Authority] , ...4 more... )
• PoleType ( type: esriFieldTypeString, alias: PoleType, length: 50 , Coded Values: [COG: Cobra / Galvanized] , [COP: Cobra / Painted] , [HCP: Heritage Cobra / Painted] , ...5 more... )
• LuminaireType ( type: esriFieldTypeString, alias: LuminaireType, length: 50 , Coded Values: [DGC: Drop Glass / Cobra] , [FGC: Flat Glass / Cobra] , [GLO: Globe] , ...5 more... )
• LampType ( type: esriFieldTypeString, alias: LampType, length: 50 , Coded Values: [HPS: High Pressure Sodium] , [I: Incandescent] , [LED: LED] , ...3 more... )
• Wattage ( type: esriFieldTypeSmallInteger, alias: Wattage )
• Height ( type: esriFieldTypeDouble, alias: Height )
• Asbuilt ( type: esriFieldTypeInteger, alias: Asbuilt )
• Dual ( type: esriFieldTypeString, alias: Dual, length: 5 )
• InstallDate ( type: esriFieldTypeDate, alias: InstallDate, length: 8 )
• ConditionDate ( type: esriFieldTypeDate, alias: ConditionDate, length: 8 )
• RemovalDate ( type: esriFieldTypeDate, alias: RemovalDate, length: 8 )
• WarrantyDate ( type: esriFieldTypeDate, alias: WarrantyDate, length: 8 )
• ConditionScore ( type: esriFieldTypeInteger, alias: ConditionScore )
• ConditionPass ( type: esriFieldTypeString, alias: ConditionPass, length: 10 )
• Neighbourhood ( type: esriFieldTypeString, alias: Neighbourhood, length: 50 )
• Location ( type: esriFieldTypeString, alias: Location, length: 50 )
• Address ( type: esriFieldTypeString, alias: Address, length: 100 )
• H_PoleID ( type: esriFieldTypeString, alias: H_PoleID, length: 50 )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• ReplacedDate ( type: esriFieldTypeSmallInteger, alias: Replaced Date )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )

Relationships:

• Streetlight_LED_Info (0) -- Related To: NanaimoSDE.SIGNAGE.Streetlight_LED_Info (1)

Tables:

Table: NanaimoSDE.SIGNAGE.Streetlight_LED_Info (1)

Name: NanaimoSDE.SIGNAGE.Streetlight_LED_Info

Display Field: StLightAssetID

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
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: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• StLightAssetID ( type: esriFieldTypeString, alias: StLightAssetID, length: 50 )
• H_PoleID ( type: esriFieldTypeString, alias: H_PoleID, length: 50 )
• LIGHTID ( type: esriFieldTypeInteger, alias: LIGHTID )
• poleid ( type: esriFieldTypeInteger, alias: poleid )
• servicevoltage ( type: esriFieldTypeString, alias: servicevoltage, length: 5 )
• luminairebrand ( type: esriFieldTypeString, alias: luminairebrand, length: 50 )
• luminaireinstalldate ( type: esriFieldTypeDate, alias: luminaireinstalldate, length: 8 )
• wiringinstalldate ( type: esriFieldTypeDate, alias: wiringinstalldate, length: 8 )
• fusetype ( type: esriFieldTypeString, alias: fusetype, length: 50 )
• wiringcoverreplacedate ( type: esriFieldTypeDate, alias: wiringcoverreplacedate, length: 8 )
• partnumber ( type: esriFieldTypeString, alias: partnumber, length: 100 )
• Phase ( type: esriFieldTypeString, alias: Phase, length: 50 )
• dualsingle ( type: esriFieldTypeString, alias: dualsingle, length: 50 )
• poleheight ( type: esriFieldTypeDouble, alias: poleheight )
• poleclassification ( type: esriFieldTypeString, alias: poleclassification, length: 50 )
• poleinstallyear ( type: esriFieldTypeInteger, alias: poleinstallyear )
• luminairetype ( type: esriFieldTypeString, alias: luminairetype, length: 50 )
• luminairecolourtemp ( type: esriFieldTypeString, alias: luminairecolourtemp, length: 5 )
• NANGID ( type: esriFieldTypeGUID, alias: NANGID, length: 38 )
• globalid ( type: esriFieldTypeGlobalID, alias: globalid, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 50 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 50 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )

Relationships:

• Streetlight (0) -- Related To: NanaimoSDE.SIGNAGE.Streetlight (0)