{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 3, "name": "Catch Basin Inspection", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "INSPECT_DATE", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "INSPECT_DATE", "type": "esriFieldTypeDate", "alias": "Inspection Date", "length": 8, "domain": null }, { "name": "FRAME", "type": "esriFieldTypeString", "alias": "Frame Condition", "length": 10, "domain": { "type": "codedValue", "name": "Cond_Status", "description": "", "codedValues": [ { "name": "Poor", "code": "Poor" }, { "name": "Fair", "code": "Fair" }, { "name": "Good", "code": "Good" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GRATE", "type": "esriFieldTypeString", "alias": "Grate Condition", "length": 10, "domain": { "type": "codedValue", "name": "Cond_Status_Grate", "description": "", "codedValues": [ { "name": "Poor", "code": "Poor" }, { "name": "Fair", "code": "Fair" }, { "name": "Good", "code": "Good" }, { "name": "Bike Issue", "code": "Bike Issue" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RISER", "type": "esriFieldTypeString", "alias": "Riser Condition", "length": 10, "domain": { "type": "codedValue", "name": "Cond_Status", "description": "", "codedValues": [ { "name": "Poor", "code": "Poor" }, { "name": "Fair", "code": "Fair" }, { "name": "Good", "code": "Good" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "STRUCTURAL", "type": "esriFieldTypeString", "alias": "Structural Condition", "length": 10, "domain": { "type": "codedValue", "name": "Cond_Status", "description": "", "codedValues": [ { "name": "Poor", "code": "Poor" }, { "name": "Fair", "code": "Fair" }, { "name": "Good", "code": "Good" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PIPE", "type": "esriFieldTypeString", "alias": "Pipe Condition", "length": 50, "domain": { "type": "codedValue", "name": "Cond_Status", "description": "", "codedValues": [ { "name": "Poor", "code": "Poor" }, { "name": "Fair", "code": "Fair" }, { "name": "Good", "code": "Good" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "TYPE", "type": "esriFieldTypeString", "alias": "Type", "length": 10, "domain": { "type": "codedValue", "name": "CB_INSPECT_TYPE", "description": "For the Catch Basin Inspection Form", "codedValues": [ { "name": "Catchbasin", "code": "CB" }, { "name": "Catchbasin Manhole", "code": "CBMH" }, { "name": "Double Catchbasin", "code": "DCB" }, { "name": "Double Catchbasin Manhole", "code": "DCBMH" }, { "name": "Ditch Inlet", "code": "DI" }, { "name": "Ditch Inlet Catchbasin", "code": "DICB" }, { "name": "Ditch Inlet Catchbasin Manhole", "code": "DICBMH" }, { "name": "Other", "code": "OTHER" }, { "name": "*Required", "code": "REQ" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OTHER", "type": "esriFieldTypeString", "alias": "Other Condition/Deficiency", "length": 240, "domain": null }, { "name": "COMMENT_", "type": "esriFieldTypeString", "alias": "Comments", "length": 240, "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 }, { "name": "REL_GLOBALID", "type": "esriFieldTypeGUID", "alias": "REL_GLOBALID", "length": 38, "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null } ], "indexes": [ { "name": "UUID_385", "fields": "GLOBALID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G676REL_GLOBALID", "fields": "REL_GLOBALID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "gdb_ct3_385", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "PRD.GIS.Storm_Node_Z", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "REL_GLOBALID", "cardinality": "esriRelCardinalityOneToMany", "composite": true } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "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, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": false }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1716222559000 } }