{
"currentVersion": 11.3,
"cimVersion": "3.3.0",
"id": 10,
"name": "BaseGIS_SDE.MAINT.PlaygroundInspection_Equipment",
"type": "Table",
"description": null,
"hasAttachments": true,
"htmlPopupType": "esriServerHTMLPopupTypeNone",
"displayField": "InspectionDate",
"typeIdField": null,
"subtypeFieldName": null,
"subtypeField": null,
"defaultSubtypeCode": null,
"fields": [
{
"name": "InspectorName",
"type": "esriFieldTypeString",
"alias": "Inspector Name",
"length": 20,
"domain": null
},
{
"name": "InspectionDate",
"type": "esriFieldTypeDate",
"alias": "Inspection Date",
"length": 8,
"domain": null
},
{
"name": "EquipmentType",
"type": "esriFieldTypeString",
"alias": "Equipment Type",
"length": 50,
"domain": {
"type": "codedValue",
"name": "PlaygroundEquipment",
"description": "Playground Equipment",
"codedValues": [
{
"name": "Surface Material/Border",
"code": "Surface Material"
},
{
"name": "Swings",
"code": "Swings"
},
{
"name": "Climber/Ladder",
"code": "Climber"
},
{
"name": "Slide",
"code": "Slide"
},
{
"name": "Free Standing Toy",
"code": "Free Standing Toy"
},
{
"name": "Main Structure",
"code": "Main Structure"
},
{
"name": "Other",
"code": "Other"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "InspectionRating",
"type": "esriFieldTypeString",
"alias": "Inspection Rating",
"length": 15,
"domain": {
"type": "codedValue",
"name": "PlaygroundInspect",
"description": "Playground Inspection Status",
"codedValues": [
{
"name": "OK",
"code": "OK"
},
{
"name": "Needs Work",
"code": "Needs Work"
},
{
"name": "Complete",
"code": "Complete"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "EquipmentIssue",
"type": "esriFieldTypeString",
"alias": "Equipment Issue",
"length": 100,
"domain": {
"type": "codedValue",
"name": "PlaygroundEquipIssue",
"description": "Playground Equipment Issue",
"codedValues": [
{
"name": "Broken Swing Seat",
"code": "Broken Swing Seat"
},
{
"name": "Worn Swing Chain or Clevis",
"code": "Worn Swing Chain or Clevis"
},
{
"name": "Missing Bolt",
"code": "Missing Bolt"
},
{
"name": "Cracked or Broken Panel",
"code": "Cracked or Broken Panel"
},
{
"name": "Cracked or Broken Slide",
"code": "Cracked or Broken Slide"
},
{
"name": "Cracked Weld",
"code": "Cracked Weld"
},
{
"name": "Adequate Surface Material",
"code": "Adequate Surface Material\t\t\n\t\nAdequate Surface Material"
},
{
"name": "Loose Top Cap or Rotten Timbers on Border",
"code": "Loose Top Cap or Rotten Timbers on Border"
},
{
"name": "Graffiti",
"code": "Graffiti"
},
{
"name": "Trash or Debris in Pearock (Weeds/Leaves)",
"code": "Trash or Debris in Pearock (Weeds/Leaves)"
},
{
"name": "Missing Warning Stickers",
"code": "Missing Warning Stickers"
},
{
"name": "Scratched or Chipped Paint on Structure",
"code": "Scratched or Chipped Paint on Structure"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "EquipmentIssueRating",
"type": "esriFieldTypeString",
"alias": "Equipment Issue Rating",
"length": 150,
"domain": {
"type": "codedValue",
"name": "PlaygroundIssueRating",
"description": "Playground Issue Rating",
"codedValues": [
{
"name": "1 - Permanent disability, loss of life or body part (condition should be corrected immediately)",
"code": "1"
},
{
"name": "2 - Serious injury resulting in temporary disability (condition should be corrected asap)",
"code": "2"
},
{
"name": "3 - Minor (non-disabling) injury (condition should be corrected when time permits)",
"code": "3"
},
{
"name": "4 - Potential for injury very minimal (condition should be corrected if it worsens)",
"code": "4"
},
{
"name": "5 - Existing condition is compliant",
"code": "5"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "EquipmentIssuePart",
"type": "esriFieldTypeString",
"alias": "Equipment Issue Part Needed",
"length": 50,
"domain": null
},
{
"name": "EquipmentIssuePartOrderedDate",
"type": "esriFieldTypeDate",
"alias": "Part Ordered Date",
"length": 8,
"domain": null
},
{
"name": "EquipmentIssueCompletedDate",
"type": "esriFieldTypeDate",
"alias": "Equipment Issue Completed Date",
"length": 8,
"domain": null
},
{
"name": "EquipmentNotes",
"type": "esriFieldTypeString",
"alias": "Equipment Notes",
"length": 255,
"domain": null
},
{
"name": "EQPlaygroundName",
"type": "esriFieldTypeString",
"alias": "EQ Playground Name",
"length": 50,
"domain": {
"type": "codedValue",
"name": "PlaygroundName",
"description": "Playground Name",
"codedValues": [
{
"name": "Bridgeview",
"code": "Bridgeview"
},
{
"name": "Bridle Ridge",
"code": "Bridle Ridge"
},
{
"name": "Bur Oaks North",
"code": "Bur Oaks North"
},
{
"name": "Bur Oaks South",
"code": "Bur Oaks South"
},
{
"name": "Captain Dodd",
"code": "Captain Dodd"
},
{
"name": "Carlson Lake",
"code": "Carlson Lake"
},
{
"name": "Carnelian",
"code": "Carnelian"
},
{
"name": "Cascade Bay",
"code": "Cascade Bay"
},
{
"name": "Cedar Pond",
"code": "Cedar Pond"
},
{
"name": "Cinnamon Ridge",
"code": "Cinnamon Ridge"
},
{
"name": "Community Center",
"code": "Community Center"
},
{
"name": "Country Home",
"code": "Country Home"
},
{
"name": "Evergreen",
"code": "Evergreen"
},
{
"name": "Fish Lake",
"code": "Fish Lake"
},
{
"name": "George Ohmann",
"code": "George Ohmann"
},
{
"name": "Goat Hill",
"code": "Goat Hill"
},
{
"name": "Highview",
"code": "Highview"
},
{
"name": "Holz Farm",
"code": "Holz Farm"
},
{
"name": "Kettle",
"code": "Kettle"
},
{
"name": "Lakeside",
"code": "Lakeside"
},
{
"name": "Lexington",
"code": "Lexington"
},
{
"name": "Meadowland",
"code": "Meadowland"
},
{
"name": "Northview",
"code": "Northview"
},
{
"name": "Oak Chase",
"code": "Oak Chase"
},
{
"name": "Peridot Path",
"code": "Peridot Path"
},
{
"name": "Quarry",
"code": "Quarry"
},
{
"name": "Rahn Phase 2",
"code": "Rahn Phase 2"
},
{
"name": "Rahn Tiny Tot",
"code": "Rahn Tiny Tot"
},
{
"name": "Ridgecliff",
"code": "Ridgecliff"
},
{
"name": "River Hills",
"code": "River Hills"
},
{
"name": "Sky Hill",
"code": "Sky Hill"
},
{
"name": "Slater Acres",
"code": "Slater Acres"
},
{
"name": "South Oaks",
"code": "South Oaks"
},
{
"name": "Walden Heights",
"code": "Walden Heights"
},
{
"name": "Walnut Hill",
"code": "Walnut Hill"
},
{
"name": "Wescott Commons",
"code": "Wescott Commons"
},
{
"name": "Wescott Station",
"code": "Wescott Station"
},
{
"name": "Woodhaven",
"code": "Woodhaven"
},
{
"name": "Moonshine",
"code": "Moonshine"
},
{
"name": "Community Center Exercise",
"code": "Community Center Exercise"
},
{
"name": "Thomas Lake",
"code": "Thomas Lake"
},
{
"name": "Thresher",
"code": "Thresher"
},
{
"name": "Patrick Eagan Nature",
"code": "Patrick Eagan Nature"
},
{
"name": "Woodhaven All Play",
"code": "Woodhaven All Play"
},
{
"name": "Blackhawk",
"code": "Blackhawk"
},
{
"name": "Trapp Farm",
"code": "Trapp Farm"
},
{
"name": "OLeary",
"code": "OLeary"
},
{
"name": "Lexington-Diffley",
"code": "LexDiff"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "PlaygroundName",
"type": "esriFieldTypeString",
"alias": "Playground Name",
"length": 50,
"domain": {
"type": "codedValue",
"name": "PlaygroundName",
"description": "Playground Name",
"codedValues": [
{
"name": "Bridgeview",
"code": "Bridgeview"
},
{
"name": "Bridle Ridge",
"code": "Bridle Ridge"
},
{
"name": "Bur Oaks North",
"code": "Bur Oaks North"
},
{
"name": "Bur Oaks South",
"code": "Bur Oaks South"
},
{
"name": "Captain Dodd",
"code": "Captain Dodd"
},
{
"name": "Carlson Lake",
"code": "Carlson Lake"
},
{
"name": "Carnelian",
"code": "Carnelian"
},
{
"name": "Cascade Bay",
"code": "Cascade Bay"
},
{
"name": "Cedar Pond",
"code": "Cedar Pond"
},
{
"name": "Cinnamon Ridge",
"code": "Cinnamon Ridge"
},
{
"name": "Community Center",
"code": "Community Center"
},
{
"name": "Country Home",
"code": "Country Home"
},
{
"name": "Evergreen",
"code": "Evergreen"
},
{
"name": "Fish Lake",
"code": "Fish Lake"
},
{
"name": "George Ohmann",
"code": "George Ohmann"
},
{
"name": "Goat Hill",
"code": "Goat Hill"
},
{
"name": "Highview",
"code": "Highview"
},
{
"name": "Holz Farm",
"code": "Holz Farm"
},
{
"name": "Kettle",
"code": "Kettle"
},
{
"name": "Lakeside",
"code": "Lakeside"
},
{
"name": "Lexington",
"code": "Lexington"
},
{
"name": "Meadowland",
"code": "Meadowland"
},
{
"name": "Northview",
"code": "Northview"
},
{
"name": "Oak Chase",
"code": "Oak Chase"
},
{
"name": "Peridot Path",
"code": "Peridot Path"
},
{
"name": "Quarry",
"code": "Quarry"
},
{
"name": "Rahn Phase 2",
"code": "Rahn Phase 2"
},
{
"name": "Rahn Tiny Tot",
"code": "Rahn Tiny Tot"
},
{
"name": "Ridgecliff",
"code": "Ridgecliff"
},
{
"name": "River Hills",
"code": "River Hills"
},
{
"name": "Sky Hill",
"code": "Sky Hill"
},
{
"name": "Slater Acres",
"code": "Slater Acres"
},
{
"name": "South Oaks",
"code": "South Oaks"
},
{
"name": "Walden Heights",
"code": "Walden Heights"
},
{
"name": "Walnut Hill",
"code": "Walnut Hill"
},
{
"name": "Wescott Commons",
"code": "Wescott Commons"
},
{
"name": "Wescott Station",
"code": "Wescott Station"
},
{
"name": "Woodhaven",
"code": "Woodhaven"
},
{
"name": "Moonshine",
"code": "Moonshine"
},
{
"name": "Community Center Exercise",
"code": "Community Center Exercise"
},
{
"name": "Thomas Lake",
"code": "Thomas Lake"
},
{
"name": "Thresher",
"code": "Thresher"
},
{
"name": "Patrick Eagan Nature",
"code": "Patrick Eagan Nature"
},
{
"name": "Woodhaven All Play",
"code": "Woodhaven All Play"
},
{
"name": "Blackhawk",
"code": "Blackhawk"
},
{
"name": "Trapp Farm",
"code": "Trapp Farm"
},
{
"name": "OLeary",
"code": "OLeary"
},
{
"name": "Lexington-Diffley",
"code": "LexDiff"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "GlobalID",
"type": "esriFieldTypeGlobalID",
"alias": "GlobalID",
"length": 38,
"domain": null
},
{
"name": "OBJECTID",
"type": "esriFieldTypeOID",
"alias": "OBJECTID",
"domain": null
},
{
"name": "PlaygroundEquipmentID",
"type": "esriFieldTypeString",
"alias": "PlaygroundEquipmentID",
"length": 50,
"domain": null
},
{
"name": "PlaygroundEquipmentType",
"type": "esriFieldTypeString",
"alias": "PlaygroundEquipmentType",
"length": 300,
"domain": null
}
],
"indexes": [
{
"name": "R2067_SDE_ROWID_UK",
"fields": "OBJECTID",
"isAscending": true,
"isUnique": true,
"description": ""
},
{
"name": "UUID_2067",
"fields": "GlobalID",
"isAscending": true,
"isUnique": false,
"description": ""
}
],
"subtypes": [],
"relationships": [
{
"id": 3,
"name": "PlaygroundEquipment",
"relatedTableId": 9,
"role": "esriRelRoleDestination",
"keyField": "PlaygroundEquipmentID",
"cardinality": "esriRelCardinalityOneToMany",
"composite": false,
"catalogID": "{09F73194-CF73-4328-99B4-9D4284C070DD}"
}
],
"capabilities": "Map,Query,Data",
"maxRecordCount": 1000,
"supportsStatistics": true,
"supportsExceedsLimitStatistics": true,
"supportsAdvancedQueries": true,
"supportedQueryFormats": "JSON, PBF",
"isDataVersioned": false,
"useStandardizedQueries": true,
"advancedQueryCapabilities": {
"useStandardizedQueries": true,
"supportsStatistics": true,
"supportsPercentileStatistics": true,
"supportsHavingClause": true,
"supportsOrderBy": true,
"supportsDistinct": true,
"supportsCountDistinct": true,
"supportsPagination": true,
"supportsTrueCurve": false,
"supportsReturningQueryExtent": true,
"supportsQueryWithDistance": true,
"supportsSqlExpression": true,
"supportsTimeRelation": true,
"supportsAdvancedQueryRelated": true,
"supportsQueryRelatedPagination": true,
"supportsSqlFormat": false,
"supportsQueryAnalytic": true,
"supportsCurrentUserQueries": true
},
"advancedQueryAnalyticCapabilities": {
"supportsLinearRegression": true,
"supportsAsync": false,
"supportsPercentileAnalytic": true
},
"dateFieldsTimeReference": null,
"preferredTimeReference": null,
"datesInUnknownTimezone": false,
"hasMetadata": true,
"isDataArchived": false,
"archivingInfo": {
"supportsQueryWithHistoricMoment": false,
"startArchivingMoment": -1
}
}