{ "currentVersion": 10.91, "id": 9, "name": "Drop Inlet Inspection", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 1, "name": "DropInlet", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "BASE_GUID", "composite": false } ], "isDataVersioned": false, "isDataArchived": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "hasAttachments": true, "supportsAttachmentsByUploadId": true, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "DI_ID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "DI_ID", "type": "esriFieldTypeInteger", "alias": "DI_ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DI_ID" }, { "name": "RESPONSIBILITY", "type": "esriFieldTypeString", "alias": "RESPONSIBILITY", "domain": { "type": "codedValue", "name": "Responsibility", "description": "SCI responsiblity", "codedValues": [ { "name": "PRIVATE", "code": "PRIVATE" }, { "name": "TOWN", "code": "TOWN" }, { "name": "STATE", "code": "STATE" }, { "name": "UNKNOWN", "code": "UNKNW" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "RESPONSIBILITY" }, { "name": "DI_TYPE", "type": "esriFieldTypeString", "alias": "DI TYPE", "domain": { "type": "codedValue", "name": "DI_Type_1", "description": "Drop Inlet Type", "codedValues": [ { "name": "Drop Inlet", "code": "DI" }, { "name": "Stand Pipe", "code": "SP" }, { "name": "Junction Box", "code": "JCTBX" }, { "name": "Unknown", "code": "UNKNW" }, { "name": "Dry Sump", "code": "DS" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 15, "defaultValue": "DI", "modelName": "DI_TYPE" }, { "name": "GRATE_TYPE", "type": "esriFieldTypeString", "alias": "GRATE TYPE", "domain": { "type": "codedValue", "name": "Grate_Type", "description": "", "codedValues": [ { "name": "A", "code": "A" }, { "name": "B", "code": "B" }, { "name": "C", "code": "C" }, { "name": "D", "code": "D" }, { "name": "E", "code": "E" }, { "name": "HalfB", "code": "HALFB" }, { "name": "Steel Grate", "code": "STEEL" }, { "name": "Throated", "code": "THRT" }, { "name": "Other", "code": "OTHER" }, { "name": "Unknown", "code": "UNKNW" }, { "name": "No Grate", "code": "NONE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "GRATE_TYPE" }, { "name": "NUM_GRATES", "type": "esriFieldTypeSmallInteger", "alias": "NUMBER OF GRATES", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "NUM_GRATES" }, { "name": "CONDITION", "type": "esriFieldTypeString", "alias": "CONDITION", "domain": { "type": "codedValue", "name": "General_Condition_9", "description": "General Condition scale", "codedValues": [ { "name": "GOOD", "code": "GOOD" }, { "name": "FAIR", "code": "FAIR" }, { "name": "POOR", "code": "POOR" }, { "name": "CRITICAL", "code": "CRIT" }, { "name": "UNKNOWN", "code": "UNKNW" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CONDITION" }, { "name": "COND_COMMENT", "type": "esriFieldTypeString", "alias": "CONDITION COMMENT", "domain": null, "editable": true, "nullable": true, "length": 230, "defaultValue": null, "modelName": "COND_COMMENT" }, { "name": "BRICK_COLLAR", "type": "esriFieldTypeString", "alias": "BRICK COLLAR", "domain": { "type": "codedValue", "name": "SCI_BrickCollar_1", "description": "Brick Collar", "codedValues": [ { "name": "EXCELLENT", "code": "EXCEL" }, { "name": "NONE", "code": "NONE" }, { "name": "GOOD", "code": "GOOD" }, { "name": "FAIR", "code": "FAIR" }, { "name": "POOR", "code": "POOR" }, { "name": "CRITICAL", "code": "CRIT" }, { "name": "UNKNOWN", "code": "UNKNW" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "BRICK_COLLAR" }, { "name": "SEDIMENT", "type": "esriFieldTypeString", "alias": "SEDIMENT", "domain": { "type": "codedValue", "name": "Sediment_11", "description": "SCI Sediment Level", "codedValues": [ { "name": "NONE", "code": "NONE" }, { "name": "LIGHT", "code": "LIGHT" }, { "name": "MODERATE", "code": "MOD" }, { "name": "HEAVY", "code": "HEAVY" }, { "name": "PLUGGED", "code": "PLUG" }, { "name": "UNKNOWN", "code": "UNKNW" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "SEDIMENT" }, { "name": "EROSION", "type": "esriFieldTypeString", "alias": "EROSION", "domain": { "type": "codedValue", "name": "Erosion_11", "description": "SCI Erosion Level", "codedValues": [ { "name": "NONE", "code": "NONE" }, { "name": "LIGHT", "code": "LIGHT" }, { "name": "MODERATE", "code": "MOD" }, { "name": "SEVERE", "code": "SEVERE" }, { "name": "UNKNOWN", "code": "UNKNW" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "EROSION" }, { "name": "COLLAR_INFILTRATION", "type": "esriFieldTypeString", "alias": "COLLAR INFILTRATION", "domain": { "type": "codedValue", "name": "YesNoInspection", "description": "Yes/No for SCI inspection", "codedValues": [ { "name": "YES", "code": "YES" }, { "name": "NO", "code": "NO" }, { "name": "UNKNOWN", "code": "UNKNW" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "COLLAR_INFILTRATION" }, { "name": "GEN_COMMENT", "type": "esriFieldTypeString", "alias": "GENERAL COMMENT", "domain": null, "editable": true, "nullable": true, "length": 230, "defaultValue": null, "modelName": "GEN_COMMENT" }, { "name": "FUNCTIONAL_STATUS", "type": "esriFieldTypeString", "alias": "FUNCTIONAL STATUS", "domain": { "type": "codedValue", "name": "SCI_FunctionalStatus_12", "description": "Functional Status Change of Feature", "codedValues": [ { "name": "ABANDONED", "code": "ABANDONED" }, { "name": "DISCONTINUED", "code": "DISCONTINUED" }, { "name": "FILLED", "code": "FILLED" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "FUNCTIONAL_STATUS" }, { "name": "NEW_DATA_TYPE", "type": "esriFieldTypeString", "alias": "NEW DATA TYPE", "domain": { "type": "codedValue", "name": "SCI_NEW_DATA_TYPE_19", "description": "If an installation is new construction or replacement", "codedValues": [ { "name": "Replacement", "code": "Replacement" }, { "name": "New Construction", "code": "New Construction" }, { "name": "Discovered", "code": "Discovered" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "NEW_DATA_TYPE" }, { "name": "INSPECTOR", "type": "esriFieldTypeString", "alias": "INSPECTOR", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "INSPECTOR" }, { "name": "INSPECTION_DATE", "type": "esriFieldTypeDate", "alias": "INSPECTION DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LAST_INSPECTION_DATE" }, { "name": "DI_PHOTO", "type": "esriFieldTypeString", "alias": "DI_PHOTO", "domain": null, "editable": true, "nullable": true, "length": 230, "defaultValue": null, "modelName": "DI_PHOTO" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" } ], "indexes": [ { "name": "G117099DI_ID", "fields": "DI_ID", "isAscending": true, "isUnique": false, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "Drop Inlet Inspection", "description": "", "prototype": { "attributes": { "INSPECTION_DATE": null, "DI_PHOTO": null, "DI_ID": null, "RESPONSIBILITY": null, "DI_TYPE": "DI", "GRATE_TYPE": null, "NUM_GRATES": null, "CONDITION": null, "COND_COMMENT": null, "BRICK_COLLAR": null, "SEDIMENT": null, "EROSION": null, "COLLAR_INFILTRATION": null, "GEN_COMMENT": null, "FUNCTIONAL_STATUS": null, "NEW_DATA_TYPE": null, "INSPECTOR": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON", "capabilities": "Query,Extract", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }