{ "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 1, "name": "EnvironmentalPreserrveInspectionsHistory", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "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, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "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": "", "displayField": "Inspector", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "Inspector", "type": "esriFieldTypeString", "alias": "Inspector", "domain": { "type": "codedValue", "name": "Public Works Inspections Users", "description": "Users for Public Works Inspections", "codedValues": [ { "name": "Jose Sanchez", "code": "JS" }, { "name": "Mike Johnson", "code": "MJ" }, { "name": "Brian Bigbie", "code": "BB" }, { "name": "Gabriel Jimenez", "code": "GJ" }, { "name": "Dan Dailey", "code": "DD" }, { "name": "Alex Wamsley", "code": "AW" }, { "name": "Chad Crissman", "code": "CC" }, { "name": "Christopher Draves", "code": "CD" }, { "name": "Jack Guialdo", "code": "JG" }, { "name": "Mike Zembrzuski", "code": "MZ" }, { "name": "Kris Bock", "code": "KB" }, { "name": "Chris Tognacci", "code": "CT" }, { "name": "Scott Fletcher", "code": "SF" }, { "name": "Jeff Stratton", "code": "JeS" }, { "name": "Miguel Hernandez", "code": "MH" }, { "name": "Evan Carver", "code": "EC" }, { "name": "Jordan Bonnet", "code": "JB" }, { "name": "Colin Jackson", "code": "CJ" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Inspector" }, { "name": "InspectionDate", "type": "esriFieldTypeDate", "alias": "Inspection Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "InspectionDate" }, { "name": "NextInspectionDate", "type": "esriFieldTypeDate", "alias": "Next Inspection Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "NextInspectionDate" }, { "name": "InspectionStatus", "type": "esriFieldTypeString", "alias": "Inspection Status", "domain": { "type": "codedValue", "name": "Inspection Status", "description": "Status of Inspections", "codedValues": [ { "name": "Completed", "code": "Com" }, { "name": "Scheduled", "code": "Sched" }, { "name": "Overdue", "code": "Due" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "InspectionStatus" }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Location" }, { "name": "NorthParkTrash", "type": "esriFieldTypeString", "alias": "Trash picked up at the north parking lot?", "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "NorthParkTrash" }, { "name": "NPTrashIssue", "type": "esriFieldTypeString", "alias": "Describe Issue", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "NPTrashIssue" }, { "name": "NorthParkDamage", "type": "esriFieldTypeString", "alias": "Is the north parking lot free of visible damage?", "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "NorthParkDamage" }, { "name": "NPDamageIssue", "type": "esriFieldTypeString", "alias": "Describe Issue", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "NPDamageIssue" }, { "name": "SouthParkTrash", "type": "esriFieldTypeString", "alias": "Trash picked up at the south parking lot?", "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SouthParkTrash" }, { "name": "SPTrashIssue", "type": "esriFieldTypeString", "alias": "Describe Issue", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "SPTrashIssue" }, { "name": "SouthParkDamage", "type": "esriFieldTypeString", "alias": "Is the south parking lot free of visible damage?", "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SouthParkDamage" }, { "name": "SPDamageIssue", "type": "esriFieldTypeString", "alias": "Describe Issue", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "SPDamageIssue" }, { "name": "KioskClean", "type": "esriFieldTypeString", "alias": "Is the kiosk building clean?", "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "KioskClean" }, { "name": "KioCleanIssue", "type": "esriFieldTypeString", "alias": "Describe Issue", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "KioCleanIssue" }, { "name": "KioskElectronics", "type": "esriFieldTypeString", "alias": "Are the electronics in the kiosk building in working order?", "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "KioskElectronics" }, { "name": "KioElectIssue", "type": "esriFieldTypeString", "alias": "Describe Issue", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "KioElectIssue" }, { "name": "BoardsClean", "type": "esriFieldTypeString", "alias": "Are the boardwalks clean?", "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "BoardsClean" }, { "name": "BoardCleanIssue", "type": "esriFieldTypeString", "alias": "Describe Issue", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "BoardCleanIssue" }, { "name": "BoardsHazards", "type": "esriFieldTypeString", "alias": "Are the boardwalks free of trip hazards?", "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "BoardsHazards" }, { "name": "BoardsHazardIssue", "type": "esriFieldTypeString", "alias": "Describe Issue", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "BoardsHazardIssue" }, { "name": "Boards", "type": "esriFieldTypeString", "alias": "Are the boardwalks free of damaged boards?", "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Boards" }, { "name": "BoardsIssue", "type": "esriFieldTypeString", "alias": "Describe Issue", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "BoardsIssue" }, { "name": "Walkways", "type": "esriFieldTypeString", "alias": "Are the paved walkways free of trip hazards?", "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Walkways" }, { "name": "WalkIssue", "type": "esriFieldTypeString", "alias": "Describe Issue", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "WalkIssue" }, { "name": "TowerClean", "type": "esriFieldTypeString", "alias": "Is the tower clean?", "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "TowerClean" }, { "name": "TowCleanIssue", "type": "esriFieldTypeString", "alias": "Describe Issue", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "TowCleanIssue" }, { "name": "TowerDamage", "type": "esriFieldTypeString", "alias": "Is the tower free of any visible damage?", "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "TowerDamage" }, { "name": "TowDamageIssue", "type": "esriFieldTypeString", "alias": "Describe Issue", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "TowDamageIssue" }, { "name": "FenceLines", "type": "esriFieldTypeString", "alias": "Are the fence lines free of any visible damage?", "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FenceLines" }, { "name": "FenceIssue", "type": "esriFieldTypeString", "alias": "Describe Issue", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "FenceIssue" }, { "name": "Trellis", "type": "esriFieldTypeString", "alias": "Is the trellis free of any visible damage?", "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Trellis" }, { "name": "TrellisIssue", "type": "esriFieldTypeString", "alias": "Describe Issue", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "TrellisIssue" }, { "name": "MensRest", "type": "esriFieldTypeString", "alias": "Any issue(s) with the mens restroom?", "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MensRest" }, { "name": "MensRestIssue", "type": "esriFieldTypeString", "alias": "Describe Issue", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "MensRestIssue" }, { "name": "WomensRest", "type": "esriFieldTypeString", "alias": "Any issue(s) with the womens restroom?", "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "WomensRest" }, { "name": "WomRestIssue", "type": "esriFieldTypeString", "alias": "Describe Issue", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "WomRestIssue" }, { "name": "WalkHazards", "type": "esriFieldTypeString", "alias": "Is the walkway free of trip hazards?", "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "WalkHazards" }, { "name": "WalkHazIssue", "type": "esriFieldTypeString", "alias": "Describe Issue", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "WalkHazIssue" }, { "name": "WalkClean", "type": "esriFieldTypeString", "alias": "Is the walkway clean?", "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "WalkClean" }, { "name": "WalkCleanIssue", "type": "esriFieldTypeString", "alias": "Describe Issue", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "WalkCleanIssue" }, { "name": "TrailHaz", "type": "esriFieldTypeString", "alias": "Are the trails free of trip hazards?", "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "TrailHaz" }, { "name": "TrailHazIssue", "type": "esriFieldTypeString", "alias": "Describe Issue", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "TrailHazIssue" }, { "name": "Replacement", "type": "esriFieldTypeString", "alias": "Any replacements needed?", "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Replacement" }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Any comments or concerns?", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "Comments" } ], "indexes": [ { "name": "R212_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "EnvironmentalPreserrveInspectionsHistory", "description": "", "prototype": { "attributes": { "Replacement": null, "Comments": null, "Inspector": null, "InspectionDate": null, "NextInspectionDate": null, "InspectionStatus": null, "Location": null, "NorthParkTrash": null, "NPTrashIssue": null, "NorthParkDamage": null, "NPDamageIssue": null, "SouthParkTrash": null, "SPTrashIssue": null, "SouthParkDamage": null, "SPDamageIssue": null, "KioskClean": null, "KioCleanIssue": null, "KioskElectronics": null, "KioElectIssue": null, "BoardsClean": null, "BoardCleanIssue": null, "BoardsHazards": null, "BoardsHazardIssue": null, "Boards": null, "BoardsIssue": null, "Walkways": null, "WalkIssue": null, "TowerClean": null, "TowCleanIssue": null, "TowerDamage": null, "TowDamageIssue": null, "FenceLines": null, "FenceIssue": null, "Trellis": null, "TrellisIssue": null, "MensRest": null, "MensRestIssue": null, "WomensRest": null, "WomRestIssue": null, "WalkHazards": null, "WalkHazIssue": null, "WalkClean": null, "WalkCleanIssue": null, "TrailHaz": null, "TrailHazIssue": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Update,Uploads,Editing", "useStandardizedQueries": true, "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalId", "fieldName": "GLOBALID", "isEnabled": false }, { "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": "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": 2000, "maxRecordCountFactor": 1 }