Layers:

Layer: Litter Receptacle (0)

Name: Litter Receptacle

Display Field: LitterReceptacleID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: <DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>Locations of litter receptacles in Strathcona County. Attachments are enabled to attach photos of the litter receptacle, and </SPAN><SPAN><SPAN>there are also additional related tables to store information for service and maintenance events. </SPAN></SPAN></P><P><SPAN /></P><P><SPAN /></P></DIV></DIV></DIV>

Copyright Text: Recreation, Parks and Culture, Strathcona County

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 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: 41824.984899999574
YMin: 5917011.336959771
XMax: 73870.57830000017
YMax: 5954057.943381157
Spatial Reference: 102187  (3776)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [156, 156, 156, 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:
Feature Draw Order:
N/A
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Shape ( type: esriFieldTypeGeometry, alias: SHAPE )
• LitterReceptacleID ( type: esriFieldTypeInteger, alias: Litter Receptacle ID )
• Location ( type: esriFieldTypeString, alias: Location, length: 150 )
• ParkID ( type: esriFieldTypeInteger, alias: Park ID )
• ContainerType ( type: esriFieldTypeString, alias: Container Type, length: 50 , Coded Values: [Architectural: Architectural] , [Barrel: Barrel] , [Combination: Combination] , ...4 more... )
• InstallType ( type: esriFieldTypeString, alias: Install Type, length: 50 , Coded Values: [Piling Anchors: Piling Anchors] , [Screw Anchors: Screw Anchors] , [Post in Hole: Post in Hole] )
• ServicingResponsibility ( type: esriFieldTypeString, alias: Servicing Responsibility, length: 50 , Coded Values: [Turf Maintenance: Turf Maintenance] , [Other: Other] , [Mowing and Waste Diversion: Mowing and Waste Diversion] , ...1 more... )
• LitterRoute ( type: esriFieldTypeString, alias: Litter Route, length: 50 , Coded Values: [Open Space: Open Space] , [Roadways: Roadways] , [Facility: Facility] , ...2 more... )
• SummerFrequency ( type: esriFieldTypeString, alias: Summer Frequency, length: 30 , Coded Values: [Weekly: Weekly] , [Enhanced: Enhanced] )
• WinterFrequency ( type: esriFieldTypeString, alias: Winter Frequency, length: 30 , Coded Values: [Weekly: Weekly] , [Enhanced: Enhanced] )
• Plaque ( type: esriFieldTypeString, alias: Plaque, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• BoardMaterial ( type: esriFieldTypeString, alias: Board Material, length: 30 , Coded Values: [Wood: Wood] , [Composite: Composite] , [None: None] )
• BoardCondition ( type: esriFieldTypeString, alias: Board Condition, length: 15 , Coded Values: [1 - Excellent: 1 - Excellent] , [2 - Good: 2 - Good] , [3 - Fair: 3 - Fair] , ...3 more... )
• ParkDevOverallCondition ( type: esriFieldTypeString, alias: Park Dev Overall Condition, length: 30 , Coded Values: [1 - Excellent: 1 - Excellent] , [2 - Good: 2 - Good] , [3 - Fair: 3 - Fair] , ...2 more... )
• TurfMaintOverallCondition ( type: esriFieldTypeString, alias: Turf Maint Overall Condition, length: 30 , Coded Values: [1 - Excellent: 1 - Excellent] , [2 - Good: 2 - Good] , [3 - Fair: 3 - Fair] , ...2 more... )
• Status ( type: esriFieldTypeString, alias: Status, length: 30 , Coded Values: [Active: Active] , [De-activated: De-activated] )
• YearInstalled ( type: esriFieldTypeSmallInteger, alias: Year Installed )
• ReplacementDate ( type: esriFieldTypeDate, alias: Replacement Date, length: 8 )
• LastInspected ( type: esriFieldTypeDate, alias: Last Inspected, length: 8 )
• InspectedBy ( type: esriFieldTypeString, alias: Inspected By, length: 75 , Coded Values: [Brad Carvery: Brad Carvery] , [Brent Gauvreau: Brent Gauvreau] , [Cathy Reed: Cathy Reed] , ...18 more... )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 200 )
• CreatedBy ( type: esriFieldTypeString, alias: Created By, length: 50 )
• CreatedOn ( type: esriFieldTypeDate, alias: Created On, length: 8 )
• ModifiedBy ( type: esriFieldTypeString, alias: Modified By, length: 50 )
• ModifiedOn ( type: esriFieldTypeDate, alias: Modified On, length: 8 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• ParkName ( type: esriFieldTypeString, alias: Park Name, length: 100 )
• SideWireRack ( type: esriFieldTypeString, alias: Side Wire Rack, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• RouteOrder ( type: esriFieldTypeInteger, alias: Route Order )
• EnhancedOrder ( type: esriFieldTypeInteger, alias: Enhanced Order )

Relationships:

• Litter_Service_Event (0) -- Related To: Litter_Service_Event (2)
• Litter_Maintenance_Event (2) -- Related To: Litter_Maintenance_Event (3)

Tables:

Table: Litter_Receptacle__ATTACH (1)

Name: Litter_Receptacle__ATTACH

Display Field: ATT_NAME

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: null

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Feature Draw Order:
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• ATTACHMENTID ( type: esriFieldTypeOID, alias: ATTACHMENTID )
• REL_GLOBALID ( type: esriFieldTypeGUID, alias: REL_GLOBALID, length: 38 )
• CONTENT_TYPE ( type: esriFieldTypeString, alias: CONTENT_TYPE, length: 150 )
• ATT_NAME ( type: esriFieldTypeString, alias: ATT_NAME, length: 250 )
• DATA_SIZE ( type: esriFieldTypeInteger, alias: DATA_SIZE )
• DATA ( type: esriFieldTypeBlob, alias: DATA )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, length: 38 )
• CreatedBy ( type: esriFieldTypeString, alias: CreatedBy, length: 255 )
• CreatedOn ( type: esriFieldTypeDate, alias: CreatedOn, length: 8 )
• ModifiedBy ( type: esriFieldTypeString, alias: ModifiedBy, length: 255 )
• ModifiedOn ( type: esriFieldTypeDate, alias: ModifiedOn, length: 8 )

Table: Litter_Service_Event (2)

Name: Litter_Service_Event

Display Field: Date

Type: Table

Geometry Type: N/A

Description: This table contains server records on litter receptacles in Strathcona County. The join is based on the litter receptacle Global ID.

Copyright Text: Recreation, Parks and Culture, Strathcona County

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Feature Draw Order:
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• ParentGUID ( type: esriFieldTypeGUID, alias: Parent GUID, length: 38 )
• Date ( type: esriFieldTypeDate, alias: Service Event Date, length: 8 )
• CompletedBy ( type: esriFieldTypeString, alias: Completed By, length: 75 , Coded Values: [Candace Moir: Candace Moir] , [Kris Eskelson: Kris Eskelson] , [Murray Fikowski: Murray Fikowski] , ...15 more... )
• BagRemoved ( type: esriFieldTypeString, alias: Bag Removed, length: 15 , Coded Values: [Yes: Yes] , [No: No] )
• RequestedService ( type: esriFieldTypeString, alias: Requested Service, length: 15 , Coded Values: [Yes: Yes] , [No: No] )
• UnauthorizedDisposal ( type: esriFieldTypeString, alias: Unauthorized Disposal, length: 15 , Coded Values: [Yes: Yes] , [No: No] )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 200 )

Relationships:

• Litter_Receptacle (0) -- Related To: Litter Receptacle (0)

Table: Litter_Maintenance_Event (3)

Name: Litter_Maintenance_Event

Display Field: Date

Type: Table

Geometry Type: N/A

Description: This table contains maintenance records on litter receptacles in Strathcona County. The join is based on the litter receptacle Global ID.

Copyright Text: Recreation, Parks and Culture, Strathcona County

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Feature Draw Order:
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• ParentGUID ( type: esriFieldTypeGUID, alias: Parent GUID, length: 38 )
• Date ( type: esriFieldTypeDate, alias: Maintenance Event Date, length: 8 )
• CompletedBy ( type: esriFieldTypeString, alias: Completed By, length: 75 , Coded Values: [Candace Moir: Candace Moir] , [Kris Eskelson: Kris Eskelson] , [Murray Fikowski: Murray Fikowski] , ...15 more... )
• LidReplacement ( type: esriFieldTypeString, alias: Lid Replacement, length: 15 , Coded Values: [Yes: Yes] , [No: No] )
• BarrelReplacement ( type: esriFieldTypeString, alias: Barrel Replacement, length: 15 , Coded Values: [Yes: Yes] , [No: No] )
• Reattachment ( type: esriFieldTypeString, alias: Reattachment, length: 15 , Coded Values: [Yes: Yes] , [No: No] )
• Graffiti ( type: esriFieldTypeString, alias: Graffiti, length: 15 , Coded Values: [Yes: Yes] , [No: No] )
• Other ( type: esriFieldTypeString, alias: Other, length: 15 , Coded Values: [Yes: Yes] , [No: No] )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 200 )

Relationships:

• Litter_Receptacle (2) -- Related To: Litter Receptacle (0)