Name: Park Asset Info

Display Field: SITENAME

Type: Table

Geometry Type: N/A

Description:

Definition Expression: N/A

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, AMF

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: false
Supports TrueCurve: false

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: CATEGORY

Fields:

• OBJECTID ( type: esriFieldTypeOID , alias: OBJECTID , editable: false , nullable: false )
• ASSETID ( type: esriFieldTypeString , alias: Asset ID , editable: false , nullable: true , length: 8 )
• YOC ( type: esriFieldTypeSmallInteger , alias: YOC , editable: true , nullable: false )
• CATEGORY ( type: esriFieldTypeSmallInteger , alias: Category , editable: true , nullable: true )
• TYPE ( type: esriFieldTypeString , alias: Type , editable: true , nullable: false , length: 50 )
• SITENAME ( type: esriFieldTypeString , alias: Site Name , editable: true , nullable: false , length: 120 , Coded Values: [Andrew Petrie Oval: Andrew Petrie Oval] , [Beach Avenue Reserve: Beach Avenue Reserve] , [Begg Lane Reserve: Begg Lane Reserve] , ...102 more... )
• GlobalID_REL ( type: esriFieldTypeGUID , alias: GlobalID_REL , editable: true , nullable: true , length: 38 )
• GlobalID ( type: esriFieldTypeGlobalID , alias: GlobalID , editable: false , nullable: false , length: 38 )
• STATUS ( type: esriFieldTypeString , alias: Status , editable: true , nullable: false , length: 25 , Coded Values: [Current: Current] , [Retired: Retired] , [Not WMC: Not WMC] , ...3 more... )
• INST_DATE ( type: esriFieldTypeDate , alias: Installed Date , editable: true , nullable: true , length: 36 )
• MATERIAL ( type: esriFieldTypeString , alias: Material , editable: true , nullable: false , length: 50 , Coded Values: [Asphalt: Asphalt] , [Chainwire: Chainwire] , [Concrete: Concrete] , ...13 more... )
• NOTES ( type: esriFieldTypeString , alias: Notes , editable: true , nullable: true , length: 255 )
• DIMENSION ( type: esriFieldTypeDouble , alias: Dimension , editable: true , nullable: true )
• SURF_COATING ( type: esriFieldTypeString , alias: Surface Coating , editable: true , nullable: true , length: 50 , Coded Values: [Painted: Painted] , [Unpainted: Unpainted] , [Stained: Stained] , ...1 more... )
• INSP_DATE ( type: esriFieldTypeDate , alias: Inspection Date , editable: true , nullable: true , length: 36 )
• INSP_BY ( type: esriFieldTypeString , alias: Inspected By , editable: true , nullable: true , length: 20 , Coded Values: [Jeff Hill: Jeff Hill] , [Nola Urquhart: Nola Urquhart] , [Lillian Mills: Lillian Mills] , ...4 more... )
• CONDITION ( type: esriFieldTypeSmallInteger , alias: Condition , editable: true , nullable: false , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...3 more... )
• UNIQUE_RC ( type: esriFieldTypeDouble , alias: Unique Replacement Cost , editable: true , nullable: true )
• UNIQUE_UL ( type: esriFieldTypeSmallInteger , alias: Unique Remaining Life , editable: true , nullable: true )
• TEXT_1 ( type: esriFieldTypeString , alias: 2023 Inspections , editable: true , nullable: true , length: 50 , Coded Values: [Desktop Complete: Desktop Complete] , [WMC: WMC] , [WMC - Priority: WMC - Priority] , ...1 more... )
• NUM_1 ( type: esriFieldTypeSmallInteger , alias: Predicted Condition , editable: true , nullable: true )
• COUNT_ ( type: esriFieldTypeSmallInteger , alias: Count , editable: true , nullable: false )
• LEN_AREA ( type: esriFieldTypeDouble , alias: Length/Area , editable: true , nullable: true )
• UR_JOIN ( type: esriFieldTypeString , alias: Unit Rate Join , editable: true , nullable: true , length: 90 )
• INSP_REQU ( type: esriFieldTypeString , alias: Inspection Required , editable: true , nullable: true , length: 1 , Coded Values: [Y: Yes] , [N: No] )

Types:

ID: 1
Name: Bin
Domains:
• TYPE:
  Coded Values: [Freestanding: Freestanding] , [Standard Single: Standard Single] , [Standard Double: Standard Double] , ...3 more...
Templates:
• Name: Bin
  Description:
  Prototype:
  UR_JOIN: null
  INSP_REQU: null
  COUNT_: 1
  YOC: 0
  CATEGORY: 1
  TYPE:
  SITENAME:
  GlobalID_REL: null
  LEN_AREA: null
  STATUS: Current
  INST_DATE: null
  MATERIAL:
  NOTES: null
  DIMENSION: null
  SURF_COATING: null
  INSP_DATE: null
  INSP_BY: null
  CONDITION: 1
  UNIQUE_RC: null
  UNIQUE_UL: null
  TEXT_1: null
  NUM_1: null
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 2
Name: Fence
Domains:
• TYPE:
  Coded Values: [Handrail Infill: Handrail Infill] , [Handrail No Infill: Handrail No Infill] , [Standard < 1m: Standard < 1m] , ...11 more...
• SITENAME:
  Inherited
• STATUS:
  Inherited
Templates:
• Name: Fence
  Description:
  Prototype:
  UR_JOIN: null
  INSP_REQU: null
  COUNT_: 1
  YOC: 0
  CATEGORY: 2
  TYPE:
  SITENAME:
  GlobalID_REL: null
  LEN_AREA: null
  STATUS: Current
  INST_DATE: null
  MATERIAL:
  NOTES: null
  DIMENSION: null
  SURF_COATING: null
  INSP_DATE: null
  INSP_BY: null
  CONDITION: 1
  UNIQUE_RC: null
  UNIQUE_UL: null
  TEXT_1: null
  NUM_1: null
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 3
Name: Footpath
Domains:
• TYPE:
  Coded Values: [Asphalt: Asphalt] , [Boardwalk/Decking: Boardwalk/Decking] , [Concrete: Concrete] , ...5 more...
• SITENAME:
  Inherited
• STATUS:
  Inherited
Templates:
• Name: Footpath
  Description:
  Prototype:
  UR_JOIN: null
  INSP_REQU: null
  COUNT_: 1
  YOC: 0
  CATEGORY: 3
  TYPE:
  SITENAME:
  GlobalID_REL: null
  LEN_AREA: null
  STATUS: Current
  INST_DATE: null
  MATERIAL:
  NOTES: null
  DIMENSION: null
  SURF_COATING: null
  INSP_DATE: null
  INSP_BY: null
  CONDITION: 1
  UNIQUE_RC: null
  UNIQUE_UL: null
  TEXT_1: null
  NUM_1: null
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 4
Name: Furniture
Domains:
• TYPE:
  Coded Values: [Bench Standard: Bench Standard] , [Seat Standard: Seat Standard] , [Picnic Setting: Picnic Setting] , ...10 more...
• SITENAME:
  Inherited
• STATUS:
  Inherited
Templates:
• Name: Furniture
  Description:
  Prototype:
  UR_JOIN: null
  INSP_REQU: null
  COUNT_: 1
  YOC: 0
  CATEGORY: 4
  TYPE:
  SITENAME:
  GlobalID_REL: null
  LEN_AREA: null
  STATUS: Current
  INST_DATE: null
  MATERIAL:
  NOTES: null
  DIMENSION: null
  SURF_COATING: null
  INSP_DATE: null
  INSP_BY: null
  CONDITION: 1
  UNIQUE_RC: null
  UNIQUE_UL: null
  TEXT_1: null
  NUM_1: null
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 5
Name: Light
Domains:
• TYPE:
  Coded Values: [Amenity: Amenity] , [Bollard: Bollard] , [Ground/Wall: Ground/Wall] , ...2 more...
• SITENAME:
  Inherited
• STATUS:
  Inherited
Templates:
• Name: Light
  Description:
  Prototype:
  UR_JOIN: null
  INSP_REQU: null
  COUNT_: 1
  YOC: 0
  CATEGORY: 5
  TYPE:
  SITENAME:
  GlobalID_REL: null
  LEN_AREA: null
  STATUS: Current
  INST_DATE: null
  MATERIAL:
  NOTES: null
  DIMENSION: null
  SURF_COATING: null
  INSP_DATE: null
  INSP_BY: null
  CONDITION: 1
  UNIQUE_RC: null
  UNIQUE_UL: null
  TEXT_1: null
  NUM_1: null
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 6
Name: Playground
Domains:
• TYPE:
  Coded Values: [Playground Pocket: Playground Pocket] , [Playground Community: Playground Community] , [Playground Destination: Playground Destination] , ...8 more...
• SITENAME:
  Inherited
• STATUS:
  Inherited
Templates:
• Name: Playground
  Description:
  Prototype:
  UR_JOIN: null
  INSP_REQU: null
  COUNT_: 1
  YOC: 0
  CATEGORY: 6
  TYPE:
  SITENAME:
  GlobalID_REL: null
  LEN_AREA: null
  STATUS: Current
  INST_DATE: null
  MATERIAL:
  NOTES: null
  DIMENSION: null
  SURF_COATING: null
  INSP_DATE: null
  INSP_BY: null
  CONDITION: 1
  UNIQUE_RC: null
  UNIQUE_UL: null
  TEXT_1: null
  NUM_1: null
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 7
Name: Service
Domains:
• TYPE:
  Coded Values: [Bore: Bore] , [CCTV Pole: CCTV Pole] , [CCTV Camera: CCTV Camera] , ...19 more...
• SITENAME:
  Inherited
• STATUS:
  Inherited
Templates:
• Name: Service
  Description:
  Prototype:
  UR_JOIN: null
  INSP_REQU: null
  COUNT_: 1
  YOC: 0
  CATEGORY: 7
  TYPE:
  SITENAME:
  GlobalID_REL: null
  LEN_AREA: null
  STATUS: Current
  INST_DATE: null
  MATERIAL:
  NOTES: null
  DIMENSION: null
  SURF_COATING: null
  INSP_DATE: null
  INSP_BY: null
  CONDITION: 1
  UNIQUE_RC: null
  UNIQUE_UL: null
  TEXT_1: null
  NUM_1: null
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 8
Name: Sign
Domains:
• TYPE:
  Coded Values: [Park Name Standard: Park Name Standard] , [Park Name Large: Park Name Large] , [Reg/Info Single: Reg/Info Single] , ...5 more...
• SITENAME:
  Inherited
• STATUS:
  Inherited
Templates:
• Name: Sign
  Description:
  Prototype:
  UR_JOIN: null
  INSP_REQU: null
  COUNT_: 1
  YOC: 0
  CATEGORY: 8
  TYPE:
  SITENAME:
  GlobalID_REL: null
  LEN_AREA: null
  STATUS: Current
  INST_DATE: null
  MATERIAL:
  NOTES: null
  DIMENSION: null
  SURF_COATING: null
  INSP_DATE: null
  INSP_BY: null
  CONDITION: 1
  UNIQUE_RC: null
  UNIQUE_UL: null
  TEXT_1: null
  NUM_1: null
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 9
Name: Sports
Domains:
• TYPE:
  Coded Values: [Court: Court] , [Cricket Net Single: Cricket Net Single] , [Cricket Net Double: Cricket Net Double] , ...16 more...
• SITENAME:
  Inherited
• STATUS:
  Inherited
Templates:
• Name: Sports
  Description:
  Prototype:
  UR_JOIN: null
  INSP_REQU: null
  COUNT_: 1
  YOC: 0
  CATEGORY: 9
  TYPE:
  SITENAME:
  GlobalID_REL: null
  LEN_AREA: null
  STATUS: Current
  INST_DATE: null
  MATERIAL:
  NOTES: null
  DIMENSION: null
  SURF_COATING: null
  INSP_DATE: null
  INSP_BY: null
  CONDITION: 1
  UNIQUE_RC: null
  UNIQUE_UL: null
  TEXT_1: null
  NUM_1: null
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 10
Name: Structure
Domains:
• TYPE:
  Coded Values: [Garden Edge < 0.3m: Garden Edge < 0.3m] , [Wall < 1m: Wall < 1m] , [Wall > 1m: Wall > 1m] , ...11 more...
• SITENAME:
  Inherited
• STATUS:
  Inherited
Templates:
• Name: Structure
  Description:
  Prototype:
  UR_JOIN: null
  INSP_REQU: null
  COUNT_: 1
  YOC: 0
  CATEGORY: 10
  TYPE:
  SITENAME:
  GlobalID_REL: null
  LEN_AREA: null
  STATUS: Current
  INST_DATE: null
  MATERIAL:
  NOTES: null
  DIMENSION: null
  SURF_COATING: null
  INSP_DATE: null
  INSP_BY: null
  CONDITION: 1
  UNIQUE_RC: null
  UNIQUE_UL: null
  TEXT_1: null
  NUM_1: null
  
  Drawing Tool: esriFeatureEditToolNone

---

Relationships:

• GIS.WMC.parkassets_P (2) -- Related To: Park Assets - Points (0)
• GIS.WMC.parkassets_A (11) -- Related To: Park Assets - Polygons (2)
• GIS.WMC.parkassets_L (7) -- Related To: Park Assets - Line (1)

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supported Operations:   Query   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Generate Renderer   Return Updates