Name: GeneralPlaygroundMaintenancesRT

Display Field: PlaygroundName

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: df6605145b454de69ec5492e8d78e93c

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: false
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• DateMaintained ( type: esriFieldTypeDate, alias: Date Maintained, length: 8 )
• MaintainedBy ( type: esriFieldTypeString, alias: Maintained By, length: 255 )
• Score ( type: esriFieldTypeSmallInteger, alias: Score )
• Notes ( type: esriFieldTypeString, alias: MaintainedNotes, length: 1000 )
• RelatedGlobalID ( type: esriFieldTypeGUID, alias: RelatedGlobalID, length: 38 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• 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 )
• HygeneArea ( type: esriFieldTypeString, alias: Hygiene - Is the area free from broken glass, dog or human excrement, blood, condoms & syringes?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• TreeHealthArea ( type: esriFieldTypeString, alias: Are surrounding trees healthy and free from dead wood which may fall?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• TreeLimbArea ( type: esriFieldTypeString, alias: Is the area free from fallen tree limbs on the ground or hanging limbs above?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• BenchesArea ( type: esriFieldTypeString, alias: Are Benches in good condition, sturdy and free from damage?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• BndryDamageArea ( type: esriFieldTypeString, alias: Is the playground boundary appropriate and free from damage or cracking?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• DrainageArea ( type: esriFieldTypeString, alias: Does the entire play area have satisfactory drainage, espescially in heavy use areas such as under swings and slide exits?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• GarbageBinDamageArea ( type: esriFieldTypeString, alias: Are surrounding Garbage bins in good condition and free from damage?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• TableDamageArea ( type: esriFieldTypeString, alias: Are the surrounding tables in good condition and free from damage?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• SignsReadableArea ( type: esriFieldTypeString, alias: Are signs appropriate and in readable condition?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• ShadeStructureArea ( type: esriFieldTypeString, alias: Are shade sails structure and sail and in good condition and free from damage?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• VandalismArea ( type: esriFieldTypeString, alias: Is the area free from acts of vandalism?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• PostsSlides ( type: esriFieldTypeString, alias: Are posts and foundations firmly placed and have no movement?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• NutsBoltsFastenedSlides ( type: esriFieldTypeString, alias: Are nuts, bolts, screws, clamps and other fittings securely fastened and "S" hooks closed?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• NutsBoltsProtrudingSlides ( type: esriFieldTypeString, alias: Is the equipment free from protruding nuts, bolts and nails?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• SplinteringSlides ( type: esriFieldTypeString, alias: Is equipment free from splintering wood, or fibreglass (especially sliding surfaces)?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• LadderDamageSlides ( type: esriFieldTypeString, alias: Are steps and ladders and other means of access to equipment safe and free from damage?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• HandrailsSturdySlides ( type: esriFieldTypeString, alias: Are handrails sturdy along slide and slide entrance?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• CablesRopesKnottingSlides ( type: esriFieldTypeString, alias: Are cables and other ropework free from knotting, splicing and lashing?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• ChainCoverRustSlides ( type: esriFieldTypeString, alias: Are chain covers in good condition and free from rust beneath?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• SlidingSurfaceDamageSlides ( type: esriFieldTypeString, alias: Are sliding surfaces undamaged and free from burning and/or cracking?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• MetalWearCorrosionSlides ( type: esriFieldTypeString, alias: Have all metal components been checked for wear and corrosion?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• PIPMaterialSlides ( type: esriFieldTypeString, alias: Is softfall or PIP material provided below the slide exit? Is the surface Level approriate?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• PostsFirmEquipment ( type: esriFieldTypeString, alias: Are posts and foundations firm?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• NutsBoltsFastenedEquipment ( type: esriFieldTypeString, alias: Are nuts, bolts, screws, clamps and other fittings securely fastened and "S" hooks closed?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• MissingPlanksEquipment ( type: esriFieldTypeString, alias: Is the equipment safe and free from missing floor boards and planks?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• NutsBoltsProtrudingEquipment ( type: esriFieldTypeString, alias: Is the equipment free from protruding nuts, bolts and nails?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• SplinteringEquipment ( type: esriFieldTypeString, alias: Is equipment free from splintering wood, or fibreglass (especially sliding surfaces)?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• MoveFreelyEquipment ( type: esriFieldTypeString, alias: Do all moving items move freely on their bearings (swing hangers, merry go round bearings, track rides)?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• LadderDamageEquipment ( type: esriFieldTypeString, alias: Are steps and ladders and other means of access to equipment safe and free from damage?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• HandrailsSturdyEquipment ( type: esriFieldTypeString, alias: Are handrails, guardrails, Protective barriers, steps, or rungs sturdy throughout the play structure?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• ClimbSurfacesEquipment ( type: esriFieldTypeString, alias: Are Plastic climbing surfaces undamaged and free from damage or cracking?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• MetalWearCorrosionEquipment ( type: esriFieldTypeString, alias: Have all metal components been checked for wear and corrosion (including springs)?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• PostsFirmSwings ( type: esriFieldTypeString, alias: Are posts and foundations firm?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• NutsBoltsFastenedSwings ( type: esriFieldTypeString, alias: Are nuts, bolts, screws, clamps and other fittings securely fastened and "S" hooks closed?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• CablesRopesKnottingSwings ( type: esriFieldTypeString, alias: Are cables and other ropework free from knotting, splicing and lashing?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• ChainCoverRustSwings ( type: esriFieldTypeString, alias: Are chain covers in good condition and free from rust beneath?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• NutsBoltsProtrudingSwings ( type: esriFieldTypeString, alias: Is the equipment free from protruding nuts, bolts and nails?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• ClearObstructionsSwings ( type: esriFieldTypeString, alias: Is the structure clear of obstructions?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• MetalWearCorrosionSwings ( type: esriFieldTypeString, alias: Have all metal components been checked for wear and corrosion (Clevis with more than 1/4" wear is faulty)?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• SoftfallMaterialSwings ( type: esriFieldTypeString, alias: Is softfall material provided benaeth and throughout use zone?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• PostsFirmSwingsBaby ( type: esriFieldTypeString, alias: Are posts and foundations firm?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• NutsBoltsFastenedSwingsBaby ( type: esriFieldTypeString, alias: Are nuts, bolts, screws, clamps and other fittings securely fastened and "S" hooks closed?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• CablesRopesKnottingSwingsBaby ( type: esriFieldTypeString, alias: Are cables and other ropework free from knotting, splicing and lashing?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• ChainCoverRustSwingsBaby ( type: esriFieldTypeString, alias: Are chain covers in good condition and free from rust beneath?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• NutsBoltsProtrudingSwingsBaby ( type: esriFieldTypeString, alias: Is the equipment free from protruding nuts, bolts and nails?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• SplinteringSwingsBaby ( type: esriFieldTypeString, alias: Is equipment free from splintering wood?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• ClearObstructionsSwingsBaby ( type: esriFieldTypeString, alias: Is the structure clear of obstructions?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• MetalWearCorrosionSwingsBaby ( type: esriFieldTypeString, alias: Have all metal components been checked for wear and corrosion (Clevis with more than 1/4" wear is faulty)?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• SoftfallMaterialSwingsBaby ( type: esriFieldTypeString, alias: Is softfall material provided benaeth and throughout use zone?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• ProtectiveSurfacing ( type: esriFieldTypeString, alias: Is there adequate protective surfacing under and around the equipment?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• DeterioratedSurfacing ( type: esriFieldTypeString, alias: Have the surface material deteriorated?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• MaterialCompactedSurfacing ( type: esriFieldTypeString, alias: Are loose fill materials compacted?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• MaterialDisplacedSurfacing ( type: esriFieldTypeString, alias: Have Loose-fill materials been displaced under heavy use areas such as swings, and slide exits?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• SharpHazards ( type: esriFieldTypeString, alias: Are there No sharp points, corners, or edges on the equipment?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• MissingPlugsHazards ( type: esriFieldTypeString, alias: Are there any missing or damaged protective caps or plugs?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• ProtrusionsHazards ( type: esriFieldTypeString, alias: Are there any hazardous protrusions?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• ClothEntangleHazards ( type: esriFieldTypeString, alias: Are ther any potential clothing entanglement hazards, such as open S hooks or protruding bolts?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• CrushPointsMovingPartsHazards ( type: esriFieldTypeString, alias: Are there any Crush and shearing points exposed on moving parts?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• TripHazards ( type: esriFieldTypeString, alias: Are there any trip hazards, such as exposed footings or anchoring devices and rocks, roots, barrier fabric or any other obstacles in a use zone?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• HygeneAreaNotes ( type: esriFieldTypeString, alias: HygeneAreaNotes, length: 255 )
• TreeHealthAreaNotes ( type: esriFieldTypeString, alias: TreeHealthAreaNotes, length: 255 )
• TreeLimbAreaNotes ( type: esriFieldTypeString, alias: TreeLimbAreaNotes, length: 255 )
• BenchesAreaNotes ( type: esriFieldTypeString, alias: BenchesAreaNotes, length: 255 )
• BndryDamageAreaNotes ( type: esriFieldTypeString, alias: BndryDamageAreaNotes, length: 255 )
• DrainageAreaNotes ( type: esriFieldTypeString, alias: DrainageAreaNotes, length: 255 )
• GarbageBinDamageAreaNotes ( type: esriFieldTypeString, alias: GarbageBinDamageAreaNotes, length: 255 )
• TableDamageAreaNotes ( type: esriFieldTypeString, alias: TableDamageAreaNotes, length: 255 )
• SignsReadableAreaNotes ( type: esriFieldTypeString, alias: SignsReadableAreaNotes, length: 255 )
• ShadeStructureAreaNotes ( type: esriFieldTypeString, alias: ShadeStructureAreaNotes, length: 255 )
• VandalismAreaNotes ( type: esriFieldTypeString, alias: VandalismAreaNotes, length: 255 )
• PostsSlidesNotes ( type: esriFieldTypeString, alias: PostsSlidesNotes, length: 255 )
• NutsBoltsFastenedSlidesNotes ( type: esriFieldTypeString, alias: NutsBoltsFastenedSlidesNotes, length: 255 )
• NutsBoltsProtrudingSlidesNote ( type: esriFieldTypeString, alias: NutsBoltsProtrudingSlidesNote, length: 255 )
• SplinteringSlidesNotes ( type: esriFieldTypeString, alias: SplinteringSlidesNotes, length: 255 )
• LadderDamageSlidesNotes ( type: esriFieldTypeString, alias: LadderDamageSlidesNotes, length: 255 )
• HandrailsSturdySlidesNotes ( type: esriFieldTypeString, alias: HandrailsSturdySlidesNotes, length: 255 )
• CablesRopesKnottingSlidesNote ( type: esriFieldTypeString, alias: CablesRopesKnottingSlidesNote, length: 255 )
• ChainCoverRustSlidesNotes ( type: esriFieldTypeString, alias: ChainCoverRustSlidesNotes, length: 255 )
• SlidingSurfaceDamageSlidesNot ( type: esriFieldTypeString, alias: SlidingSurfaceDamageSlidesNot, length: 255 )
• MetalWearCorrosionSlidesNotes ( type: esriFieldTypeString, alias: MetalWearCorrosionSlidesNotes, length: 255 )
• PIPMaterialSlidesNotes ( type: esriFieldTypeString, alias: PIPMaterialSlidesNotes, length: 255 )
• PostsFirmEquipmentNotes ( type: esriFieldTypeString, alias: PostsFirmEquipmentNotes, length: 255 )
• NutsBoltsFastenedEquipmentNot ( type: esriFieldTypeString, alias: NutsBoltsFastenedEquipmentNot, length: 255 )
• MissingPlanksEquipmentNotes ( type: esriFieldTypeString, alias: MissingPlanksEquipmentNotes, length: 255 )
• NutsBoltsProtrudingEquipmentN ( type: esriFieldTypeString, alias: NutsBoltsProtrudingEquipmentN, length: 255 )
• SplinteringEquipmentNotes ( type: esriFieldTypeString, alias: SplinteringEquipmentNotes, length: 255 )
• MoveFreelyEquipmentNotes ( type: esriFieldTypeString, alias: MoveFreelyEquipmentNotes, length: 255 )
• LadderDamageEquipmentNotes ( type: esriFieldTypeString, alias: LadderDamageEquipmentNotes, length: 255 )
• HandrailsSturdyEquipmentNotes ( type: esriFieldTypeString, alias: HandrailsSturdyEquipmentNotes, length: 255 )
• ClimbSurfacesEquipmentNotes ( type: esriFieldTypeString, alias: ClimbSurfacesEquipmentNotes, length: 255 )
• MetalWearCorrosionEquipmentNo ( type: esriFieldTypeString, alias: MetalWearCorrosionEquipmentNo, length: 255 )
• PostsFirmSwingsNotes ( type: esriFieldTypeString, alias: PostsFirmSwingsNotes, length: 255 )
• NutsBoltsFastenedSwingsNotes ( type: esriFieldTypeString, alias: NutsBoltsFastenedSwingsNotes, length: 255 )
• CablesRopesKnottingSwingsNote ( type: esriFieldTypeString, alias: CablesRopesKnottingSwingsNote, length: 255 )
• ChainCoverRustSwingsNotes ( type: esriFieldTypeString, alias: ChainCoverRustSwingsNotes, length: 255 )
• NutsBoltsProtrudingSwingsNote ( type: esriFieldTypeString, alias: NutsBoltsProtrudingSwingsNote, length: 255 )
• ClearObstructionsSwingsNotes ( type: esriFieldTypeString, alias: ClearObstructionsSwingsNotes, length: 255 )
• MetalWearCorrosionSwingsNotes ( type: esriFieldTypeString, alias: MetalWearCorrosionSwingsNotes, length: 255 )
• SoftfallMaterialSwingsNotes ( type: esriFieldTypeString, alias: SoftfallMaterialSwingsNotes, length: 255 )
• PostsFirmSwingsBabyNotes ( type: esriFieldTypeString, alias: PostsFirmSwingsBabyNotes, length: 255 )
• NutsBoltsFastenedSwingsBabyNo ( type: esriFieldTypeString, alias: NutsBoltsFastenedSwingsBabyNo, length: 255 )
• CablesRopesKnottingSwingsBbyN ( type: esriFieldTypeString, alias: CablesRopesKnottingSwingsBbyN, length: 255 )
• ChainCoverRustSwingsBabyNotes ( type: esriFieldTypeString, alias: ChainCoverRustSwingsBabyNotes, length: 255 )
• NutsBoltsProtrudingSwingsBbyN ( type: esriFieldTypeString, alias: NutsBoltsProtrudingSwingsBbyN, length: 255 )
• SplinteringSwingsBabyNotes ( type: esriFieldTypeString, alias: SplinteringSwingsBabyNotes, length: 255 )
• ClearObstructionsSwingsBabyNo ( type: esriFieldTypeString, alias: ClearObstructionsSwingsBabyNo, length: 255 )
• MetalWearCorrosionSwingsBabyN ( type: esriFieldTypeString, alias: MetalWearCorrosionSwingsBabyN, length: 255 )
• SoftfallMaterialSwingsBabyNot ( type: esriFieldTypeString, alias: SoftfallMaterialSwingsBabyNot, length: 255 )
• ProtectiveSurfacingNotes ( type: esriFieldTypeString, alias: ProtectiveSurfacingNotes, length: 255 )
• DeterioratedSurfacingNotes ( type: esriFieldTypeString, alias: DeterioratedSurfacingNotes, length: 255 )
• MaterialCompactedSurfacingNot ( type: esriFieldTypeString, alias: MaterialCompactedSurfacingNot, length: 255 )
• MaterialDisplacedSurfacingNot ( type: esriFieldTypeString, alias: MaterialDisplacedSurfacingNot, length: 255 )
• SharpHazardsNotes ( type: esriFieldTypeString, alias: SharpHazardsNotes, length: 255 )
• MissingPlugsHazardsNotes ( type: esriFieldTypeString, alias: MissingPlugsHazardsNotes, length: 255 )
• ProtrusionsHazardsNotes ( type: esriFieldTypeString, alias: ProtrusionsHazardsNotes, length: 255 )
• ClothEntangleHazardsNotes ( type: esriFieldTypeString, alias: ClothEntangleHazardsNotes, length: 255 )
• CrushPointsMovingPartsHazardN ( type: esriFieldTypeString, alias: CrushPointsMovingPartsHazardN, length: 255 )
• TripHazardsNotes ( type: esriFieldTypeString, alias: TripHazardsNotes, length: 255 )
• PlaygroundName ( type: esriFieldTypeString, alias: Playground Name, length: 255 )
• PlaygroundAreaTotalCompleted ( type: esriFieldTypeSmallInteger, alias: Playground Area Group Total Completed )
• SlideTotalCompleted ( type: esriFieldTypeSmallInteger, alias: Slide Group Total Completed )
• PlayEquipmentTotalCompleted ( type: esriFieldTypeSmallInteger, alias: Play Equipment Group Total Completed )
• SwingsTotalCompleted ( type: esriFieldTypeSmallInteger, alias: Swings Group Total Completed )
• JrSwingsTotalCompleted ( type: esriFieldTypeSmallInteger, alias: Jr Swings Group Total Completed )
• SurfacingTotalCompleted ( type: esriFieldTypeSmallInteger, alias: Surfacing Group Total Completed )
• GenHazTotalCompleted ( type: esriFieldTypeSmallInteger, alias: General Hazards Group Total Completed )

Relationships:

• DBO.PlaygroundAudits (2) -- Related To: Playground Audits (1)

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata