{ "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 1, "name": "Pothole Inspections", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "TECHNICIAN", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "TECHNICIAN", "type": "esriFieldTypeString", "alias": "Technician", "length": 255, "domain": { "type": "codedValue", "name": "TechsRoadsDiv", "description": "Technicians from the Roads Division", "codedValues": [ { "name": "David Johnson", "code": "David Johnson" }, { "name": "Derek Mangelson", "code": "Derek Mangelson" }, { "name": "Hank Price", "code": "Hank Price" }, { "name": "Martin Jensen", "code": "Martin Jensen" }, { "name": "Sam Coombs", "code": "Sam Coombs" }, { "name": "Sam Edwards", "code": "Sam Edwards" }, { "name": "Scott Beckstorm", "code": "Scott Beckstorm" }, { "name": "Steven Roylance", "code": "Steven Roylance" }, { "name": "Tyler Shepherd", "code": "Tyler Shepherd" }, { "name": "Temp ( Add Comment)", "code": "Temp ( Add Comment)" }, { "name": "Kristy Vincent", "code": "Kristy Vincent" }, { "name": "Landen Quayle", "code": "Landen Quayle" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DATE_", "type": "esriFieldTypeDate", "alias": "Date", "length": 8, "domain": null }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "Status", "length": 255, "domain": { "type": "codedValue", "name": "PotholeStatus", "description": "Satus of Potholes for Roads Division", "codedValues": [ { "name": "Work Required", "code": "Work Required" }, { "name": "Complete", "code": "Complete" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "COMMENT_", "type": "esriFieldTypeString", "alias": "Comment", "length": 255, "domain": null }, { "name": "GUID", "type": "esriFieldTypeGUID", "alias": "GUID", "length": 38, "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "length": 38, "domain": null }, { "name": "CREATED_USER", "type": "esriFieldTypeString", "alias": "CREATED_USER", "length": 255, "domain": null }, { "name": "CREATED_DATE", "type": "esriFieldTypeDate", "alias": "CREATED_DATE", "length": 8, "domain": null }, { "name": "LAST_EDITED_USER", "type": "esriFieldTypeString", "alias": "LAST_EDITED_USER", "length": 255, "domain": null }, { "name": "LAST_EDITED_DATE", "type": "esriFieldTypeDate", "alias": "LAST_EDITED_DATE", "length": 8, "domain": null } ], "indexes": [ { "name": "GDB_273973_GUID", "fields": "GUID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "R1166850_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_1166850", "fields": "GLOBALID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_1166850", "fields": "GLOBALID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "PWORKS.Potholes", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "GUID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{A7714C3B-A28A-4C17-A62C-7D779BFB81D4}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "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": { "timeZone": "Mountain Standard Time", "timeZoneIANA": "America/Denver", "respectsDaylightSaving": true }, "preferredTimeReference": { "timeZone": "Mountain Standard Time", "timeZoneIANA": "America/Denver", "respectsDaylightSaving": true }, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }