{ "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 2, "name": "GHP Conveyance Inspection", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "FACILITY_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FACILITY_NAME", "type": "esriFieldTypeString", "alias": "FACILITY NAME", "length": 255, "domain": null }, { "name": "GHP_FACILITYID", "type": "esriFieldTypeString", "alias": "GHP FACILITYID", "length": 255, "domain": null }, { "name": "INSPECTOR_NAME", "type": "esriFieldTypeString", "alias": "INSPECTOR NAME", "length": 255, "domain": null }, { "name": "INSPECTION_DATE", "type": "esriFieldTypeDate", "alias": "INSPECTION DATE", "length": 8, "domain": null }, { "name": "CBI_Q1_ITEM", "type": "esriFieldTypeString", "alias": "DEBRIS/ SEDIMENT BLOCKING BASIN? ITEM Q1", "length": 5, "domain": { "type": "codedValue", "name": "dSTATUS", "description": "Site Inspection Item Status", "codedValues": [ { "name": "YES", "code": "YES" }, { "name": "NO", "code": "NO" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CBI_Q2_ITEM", "type": "esriFieldTypeString", "alias": "DAMAGED OR CRAKED BASIN? ITEM Q2", "length": 5, "domain": { "type": "codedValue", "name": "dSTATUS", "description": "Site Inspection Item Status", "codedValues": [ { "name": "YES", "code": "YES" }, { "name": "NO", "code": "NO" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CBI_Q3_ITEM", "type": "esriFieldTypeString", "alias": "SEDIMENT OR DEBRIS IN BASIN SUMP? ITEM Q3", "length": 5, "domain": { "type": "codedValue", "name": "dSTATUS", "description": "Site Inspection Item Status", "codedValues": [ { "name": "YES", "code": "YES" }, { "name": "NO", "code": "NO" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CBI_Q4_ITEM", "type": "esriFieldTypeString", "alias": "IF FILTER CHECK FOR CLOG OR DAMAGE? ITEM Q4", "length": 5, "domain": { "type": "codedValue", "name": "dSTATUS", "description": "Site Inspection Item Status", "codedValues": [ { "name": "YES", "code": "YES" }, { "name": "NO", "code": "NO" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CBI_Q1_MAINT_NEEDED", "type": "esriFieldTypeString", "alias": "DEBRIS/ SEDIMENT BLOCKING BASIN? MAINT Q1", "length": 5, "domain": { "type": "codedValue", "name": "dYES_NO", "description": "Boolean Yes No", "codedValues": [ { "name": "YES", "code": "YES" }, { "name": "NO", "code": "NO" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CBI_Q2_MAINT_NEEDED", "type": "esriFieldTypeString", "alias": "DAMAGED OR CRAKED BASIN? MAINT Q2", "length": 5, "domain": { "type": "codedValue", "name": "dYES_NO", "description": "Boolean Yes No", "codedValues": [ { "name": "YES", "code": "YES" }, { "name": "NO", "code": "NO" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CBI_Q3_MAINT_NEEDED", "type": "esriFieldTypeString", "alias": "SEDIMENT OR DEBRIS IN BASIN SUMP? MAINT Q3", "length": 5, "domain": { "type": "codedValue", "name": "dYES_NO", "description": "Boolean Yes No", "codedValues": [ { "name": "YES", "code": "YES" }, { "name": "NO", "code": "NO" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CBI_Q4_MAINT_NEEDED", "type": "esriFieldTypeString", "alias": "IF FILTER CHECK FOR CLOG OR DAMAGE? MAINT Q4", "length": 5, "domain": { "type": "codedValue", "name": "dYES_NO", "description": "Boolean Yes No", "codedValues": [ { "name": "YES", "code": "YES" }, { "name": "NO", "code": "NO" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CBI_Q1_CORR_ACT_COM", "type": "esriFieldTypeString", "alias": "DEBRIS/ SEDIMENT BLOCKING BASIN? COMMENT Q1", "length": 255, "domain": null }, { "name": "CBI_Q2_CORR_ACT_COM", "type": "esriFieldTypeString", "alias": "DAMAGED OR CRAKED BASIN? COMMENT Q2", "length": 255, "domain": null }, { "name": "CBI_Q3_CORR_ACT_COM", "type": "esriFieldTypeString", "alias": "SEDIMENT OR DEBRIS IN BASIN SUMP? COMMENT Q3", "length": 255, "domain": null }, { "name": "CBI_Q4_CORR_ACT_COM", "type": "esriFieldTypeString", "alias": "IF FILTER CHECK FOR CLOG OR DAMAGE? COMMENT Q4", "length": 255, "domain": null }, { "name": "PC_Q5_ITEM", "type": "esriFieldTypeString", "alias": "IS PIPE CLOGGED? ITEM Q5", "length": 5, "domain": { "type": "codedValue", "name": "dSTATUS", "description": "Site Inspection Item Status", "codedValues": [ { "name": "YES", "code": "YES" }, { "name": "NO", "code": "NO" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PC_Q6_ITEM", "type": "esriFieldTypeString", "alias": "IS THER VEGETATION GROWTH IMPEDING FLOW? ITEM Q6", "length": 5, "domain": { "type": "codedValue", "name": "dSTATUS", "description": "Site Inspection Item Status", "codedValues": [ { "name": "YES", "code": "YES" }, { "name": "NO", "code": "NO" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PC_Q7_ITEM", "type": "esriFieldTypeString", "alias": "IS PIPE DAMAGED? ITEM Q7", "length": 5, "domain": { "type": "codedValue", "name": "dSTATUS", "description": "Site Inspection Item Status", "codedValues": [ { "name": "YES", "code": "YES" }, { "name": "NO", "code": "NO" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PC_Q5_MAINT_NEEDED", "type": "esriFieldTypeString", "alias": "IS PIPE CLOGGED? MAINT Q5", "length": 5, "domain": { "type": "codedValue", "name": "dYES_NO", "description": "Boolean Yes No", "codedValues": [ { "name": "YES", "code": "YES" }, { "name": "NO", "code": "NO" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PC_Q6_MAINT_NEEDED", "type": "esriFieldTypeString", "alias": "IS THER VEGETATION GROWTH IMPEDING FLOW? MAINT Q6", "length": 5, "domain": { "type": "codedValue", "name": "dYES_NO", "description": "Boolean Yes No", "codedValues": [ { "name": "YES", "code": "YES" }, { "name": "NO", "code": "NO" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PC_Q7_MAINT_NEEDED", "type": "esriFieldTypeString", "alias": "IS PIPE DAMAGED? MAINT Q7", "length": 5, "domain": { "type": "codedValue", "name": "dYES_NO", "description": "Boolean Yes No", "codedValues": [ { "name": "YES", "code": "YES" }, { "name": "NO", "code": "NO" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PC_Q5_CORR_ACT_COM", "type": "esriFieldTypeString", "alias": "IS PIPE CLOGGED? COMMENT Q5", "length": 255, "domain": null }, { "name": "PC_Q6_CORR_ACT_COM", "type": "esriFieldTypeString", "alias": "IS THER VEGETATION GROWTH IMPEDING FLOW? COMMENT Q6", "length": 255, "domain": null }, { "name": "PC_Q7_CORR_ACT_COM", "type": "esriFieldTypeString", "alias": "IS PIPE DAMAGED? COMMENT Q7", "length": 255, "domain": null }, { "name": "DTS_Q8_ITEM", "type": "esriFieldTypeString", "alias": "IS THERE EROSION, SLUMPING, OR UNDERCUTTING? ITEM Q8", "length": 5, "domain": { "type": "codedValue", "name": "dSTATUS", "description": "Site Inspection Item Status", "codedValues": [ { "name": "YES", "code": "YES" }, { "name": "NO", "code": "NO" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DTS_Q9_ITEM", "type": "esriFieldTypeString", "alias": "IS THERE TRASH OR SEDIMENT ACCUMULATION? ITEM Q9", "length": 5, "domain": { "type": "codedValue", "name": "dSTATUS", "description": "Site Inspection Item Status", "codedValues": [ { "name": "YES", "code": "YES" }, { "name": "NO", "code": "NO" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DTS_Q10_ITEM", "type": "esriFieldTypeString", "alias": "IS THERE VEGETATION GROWTH IMPEDING FLOW? ITEM Q10", "length": 5, "domain": { "type": "codedValue", "name": "dSTATUS", "description": "Site Inspection Item Status", "codedValues": [ { "name": "YES", "code": "YES" }, { "name": "NO", "code": "NO" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DTS_Q11_ITEM", "type": "esriFieldTypeString", "alias": "CHECK INTEGRITY OF FLOW FILTERING DEVICES? ITEM Q11", "length": 5, "domain": { "type": "codedValue", "name": "dSTATUS", "description": "Site Inspection Item Status", "codedValues": [ { "name": "YES", "code": "YES" }, { "name": "NO", "code": "NO" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DTS_Q12_ITEM", "type": "esriFieldTypeString", "alias": "CHECK INLETS AND OUTLETS FOR DEBRIS? ITEM Q12", "length": 5, "domain": { "type": "codedValue", "name": "dSTATUS", "description": "Site Inspection Item Status", "codedValues": [ { "name": "YES", "code": "YES" }, { "name": "NO", "code": "NO" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DTS_Q8_MAINT_NEEDED", "type": "esriFieldTypeString", "alias": "IS THERE EROSION, SLUMPING, OR UNDERCUTTING? MAINT Q8", "length": 5, "domain": { "type": "codedValue", "name": "dYES_NO", "description": "Boolean Yes No", "codedValues": [ { "name": "YES", "code": "YES" }, { "name": "NO", "code": "NO" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DTS_Q9_MAINT_NEEDED", "type": "esriFieldTypeString", "alias": "IS THERE TRASH OR SEDIMENT ACCUMULATION? MAINT Q9", "length": 5, "domain": { "type": "codedValue", "name": "dYES_NO", "description": "Boolean Yes No", "codedValues": [ { "name": "YES", "code": "YES" }, { "name": "NO", "code": "NO" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DTS_Q10_MAINT_NEEDED", "type": "esriFieldTypeString", "alias": "IS THERE VEGETATION GROWTH IMPEDING FLOW? MAINT Q10", "length": 5, "domain": { "type": "codedValue", "name": "dYES_NO", "description": "Boolean Yes No", "codedValues": [ { "name": "YES", "code": "YES" }, { "name": "NO", "code": "NO" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DTS_Q11_MAINT_NEEDED", "type": "esriFieldTypeString", "alias": "CHECK INTEGRITY OF FLOW FILTERING DEVICES? MAINT Q11", "length": 5, "domain": { "type": "codedValue", "name": "dYES_NO", "description": "Boolean Yes No", "codedValues": [ { "name": "YES", "code": "YES" }, { "name": "NO", "code": "NO" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DTS_Q12_MAINT_NEEDED", "type": "esriFieldTypeString", "alias": "CHECK INLETS AND OUTLETS FOR DEBRIS? MAINT Q12", "length": 5, "domain": { "type": "codedValue", "name": "dYES_NO", "description": "Boolean Yes No", "codedValues": [ { "name": "YES", "code": "YES" }, { "name": "NO", "code": "NO" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DTS_Q8_CORR_ACT_COM", "type": "esriFieldTypeString", "alias": "IS THERE EROSION, SLUMPING, OR UNDERCUTTING? COMMENT Q8", "length": 255, "domain": null }, { "name": "DTS_Q9_CORR_ACT_COM", "type": "esriFieldTypeString", "alias": "IS THERE TRASH OR SEDIMENT ACCUMULATION? COMMENT Q9", "length": 255, "domain": null }, { "name": "DTS_Q10_CORR_ACT_COM", "type": "esriFieldTypeString", "alias": "IS THERE VEGETATION GROWTH IMPEDING FLOW? COMMENT Q10", "length": 255, "domain": null }, { "name": "DTS_Q11_CORR_ACT_COM", "type": "esriFieldTypeString", "alias": "CHECK INTEGRITY OF FLOW FILTERING DEVICES? COMMENT Q11", "length": 255, "domain": null }, { "name": "DTS_Q12_CORR_ACT_COM", "type": "esriFieldTypeString", "alias": "CHECK INLETS AND OUTLETS FOR DEBRIS? COMMENT Q12", "length": 255, "domain": null }, { "name": "FAC_ID_GUID", "type": "esriFieldTypeGUID", "alias": "FACILITY ID", "length": 38, "domain": null }, { "name": "ADDITIONAL_COMMENTS", "type": "esriFieldTypeString", "alias": "ADDITIONAL COMMENTS", "length": 255, "domain": null }, { "name": "SHAPE_LEN", "type": "esriFieldTypeDouble", "alias": "SHAPE.LEN", "domain": null }, { "name": "SHAPE_AREA", "type": "esriFieldTypeDouble", "alias": "SHAPE.AREA", "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "GDB_23048_FAC_ID", "fields": "FAC_ID_GUID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "R2520333_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_2520333", "fields": "GLOBALID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "GHPFacilities", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "FAC_ID_GUID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{3C96C753-59AA-4BA3-8051-72F9FD9FDCF6}" } ], "capabilities": "Map,Query,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": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }