{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 10, "name": "BaseGIS_SDE.MAINT.PlaygroundInspection_Equipment", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 3, "name": "PlaygroundEquipment", "relatedTableId": 9, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "PlaygroundEquipmentID", "composite": false, "catalogID": "{09F73194-CF73-4328-99B4-9D4284C070DD}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": true, "supportsAttachmentsByUploadId": true, "supportsAttachmentsResizing": true, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "InspectionDate", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "InspectorName", "type": "esriFieldTypeString", "alias": "Inspector Name", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "InspectorName" }, { "name": "InspectionDate", "type": "esriFieldTypeDate", "alias": "Inspection Date", "domain": null, "editable": true, "nullable": false, "length": 8, "defaultValue": null, "modelName": "InspectionDate" }, { "name": "EquipmentType", "type": "esriFieldTypeString", "alias": "Equipment Type", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "EquipmentType" }, { "name": "InspectionRating", "type": "esriFieldTypeString", "alias": "Inspection Rating", "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" }, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "InspectionRating" }, { "name": "EquipmentIssue", "type": "esriFieldTypeString", "alias": "Equipment Issue", "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" }, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "EquipmentIssue" }, { "name": "EquipmentIssueRating", "type": "esriFieldTypeString", "alias": "Equipment Issue Rating", "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" }, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "EquipmentIssueRating" }, { "name": "EquipmentIssuePart", "type": "esriFieldTypeString", "alias": "Equipment Issue Part Needed", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "EquipmentIssuePart" }, { "name": "EquipmentIssuePartOrderedDate", "type": "esriFieldTypeDate", "alias": "Part Ordered Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "EquipmentIssuePartOrderedDate" }, { "name": "EquipmentIssueCompletedDate", "type": "esriFieldTypeDate", "alias": "Equipment Issue Completed Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "EquipmentIssueCompletedDate" }, { "name": "EquipmentNotes", "type": "esriFieldTypeString", "alias": "Equipment Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "EquipmentNotes" }, { "name": "EQPlaygroundName", "type": "esriFieldTypeString", "alias": "EQ Playground Name", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PlaygroundName" }, { "name": "PlaygroundName", "type": "esriFieldTypeString", "alias": "Playground Name", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PlaygroundName" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "PlaygroundEquipmentID", "type": "esriFieldTypeString", "alias": "PlaygroundEquipmentID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PlaygroundEquipmentID" }, { "name": "PlaygroundEquipmentType", "type": "esriFieldTypeString", "alias": "PlaygroundEquipmentType", "domain": null, "editable": true, "nullable": true, "length": 300, "defaultValue": null, "modelName": "PlaygroundEquipmentType" } ], "indexes": [ { "name": "R2067_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_2067", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "BaseGIS_SDE.MAINT.PlaygroundInspection_Equipment", "description": "", "prototype": { "attributes": { "PlaygroundEquipmentID": null, "InspectorName": null, "InspectionDate": -2209161600000, "EquipmentType": null, "InspectionRating": null, "EquipmentIssue": null, "EquipmentIssueRating": null, "EquipmentIssuePart": null, "EquipmentIssuePartOrderedDate": null, "EquipmentIssueCompletedDate": null, "EquipmentNotes": null, "EQPlaygroundName": null, "PlaygroundName": null, "PlaygroundEquipmentType": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalId", "fieldName": "GLOBALID", "isEnabled": true }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "domain": null, "editable": true, "nullable": false, "length": 250, "defaultValue": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "domain": null, "editable": true, "nullable": false, "defaultValue": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "domain": null, "editable": true, "nullable": false, "length": 150, "defaultValue": null } ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 }