{ "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "attachmentProperties": [ { "fieldName": "ATTACHMENTID", "isEnabled": true, "name": "id" }, { "fieldName": "GLOBALID", "isEnabled": true, "name": "globalId" }, { "fieldName": "ATT_NAME", "isEnabled": true, "name": "name" }, { "fieldName": "DATA_SIZE", "isEnabled": true, "name": "size" }, { "fieldName": "CONTENT_TYPE", "isEnabled": true, "name": "contentType" }, { "fieldName": "KEYWORDS", "isEnabled": false, "name": "keywords" }, { "fieldName": "EXIFINFO", "isEnabled": false, "name": "exifInfo" } ], "attachmentFields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "ATTACHMENTID", "alias": "ATTACHMENTID", "type": "esriFieldTypeOID" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "GLOBALID", "length": 38, "alias": "GLOBALID", "type": "esriFieldTypeGlobalID" }, { "nullable": false, "editable": true, "defaultValue": null, "domain": null, "name": "ATT_NAME", "length": 250, "alias": "ATT_NAME", "type": "esriFieldTypeString" }, { "nullable": false, "editable": true, "defaultValue": null, "domain": null, "name": "DATA_SIZE", "alias": "DATA_SIZE", "type": "esriFieldTypeInteger" }, { "nullable": false, "editable": true, "defaultValue": null, "domain": null, "name": "CONTENT_TYPE", "length": 150, "alias": "CONTENT_TYPE", "type": "esriFieldTypeString" } ], "infoInEstimates": ["count"], "datesInUnknownTimezone": false, "ownershipBasedAccessControlForFeatures": null, "type": "Table", "supportsAttachmentsByUploadId": true, "relationships": [{ "keyField": "assetguid", "role": "esriRelRoleDestination", "catalogID": "{C640E064-6334-4CD9-BC78-AB6C1799BBA3}", "composite": false, "name": "StructureJunction_2024", "relatedTableId": 28, "id": 10, "cardinality": "esriRelCardinalityOneToMany" }], "supportsAttachmentsResizing": true, "cimVersion": "3.6.0", "isDataArchived": true, "id": 38, "archivingInfo": { "startArchivingMoment": 1726487572000, "supportsQueryWithHistoricMoment": true }, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson,kml", "standardMaxRecordCount": 32000, "isDataVersioned": false, "templates": [{ "name": "Sewer Manhole Inspection", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": {"attributes": { "notes": null, "framecondition": null, "framesealcondition": null, "created_user": null, "precleaning": null, "coverringcondition": null, "globalid": "{00000000-0000-0000-0000-000000000000}", "runoff": null, "inspector": null, "inspectionstatus": null, "covercondition": null, "inspectpurp": null, "evidsurcharge": null, "last_edited_user": null, "coverfit": null, "framesealinflow": null, "assetguid": null, "inspectdt": null, "weather": null, "coverinsertcondition": null, "last_edited_date": null, "created_date": null, "precleaningdt": null }} }], "supportsAdvancedQueries": true, "currentVersion": 12, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedSqlFormatsInCalculate": ["standard"], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "objectid", "name": "Sewer Manhole Inspection", "displayField": "inspector", "supportsCalculate": true, "fields": [ { "modelName": "inspector", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "inspector", "length": 50, "alias": "Inspector", "type": "esriFieldTypeString" }, { "modelName": "inspectdt", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "inspectdt", "length": 8, "alias": "Inspection Date", "type": "esriFieldTypeDate" }, { "modelName": "inspectpurp", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "Inspection_Manhole_Purpose", "description": "", "type": "codedValue", "codedValues": [ { "code": 0, "name": "Unknown" }, { "code": 1, "name": "Maintenance Required" }, { "code": 2, "name": "I&I Investigation" }, { "code": 3, "name": "Post-Rehab Survey" }, { "code": 4, "name": "Pre-Rehab Survey" }, { "code": 5, "name": "Pre-Acceptance" }, { "code": 6, "name": "Routine Assessment" }, { "code": 7, "name": "CIP Assessment" }, { "code": 8, "name": "Resurvey for Any Reason" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "inspectpurp", "alias": "Inspection Purpose", "type": "esriFieldTypeSmallInteger" }, { "modelName": "precleaning", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "Inspection_Manhole_Pre-Cleaning", "description": "", "type": "codedValue", "codedValues": [ { "code": 0, "name": "Unknown" }, { "code": 1, "name": "Jetting" }, { "code": 2, "name": "Heavy Cleaning" }, { "code": 3, "name": "No Pre-Cleaning" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "precleaning", "alias": "Pre-Cleaning", "type": "esriFieldTypeSmallInteger" }, { "modelName": "precleaningdt", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "precleaningdt", "length": 8, "alias": "Pre-Cleaning Date", "type": "esriFieldTypeDate" }, { "modelName": "weather", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "Inspection_Manhole_Weather", "description": "", "type": "codedValue", "codedValues": [ { "code": 0, "name": "Unknown" }, { "code": 1, "name": "Very Dry" }, { "code": 2, "name": "Dry" }, { "code": 3, "name": "Damp" }, { "code": 4, "name": "Light Rain" }, { "code": 5, "name": "Heavy Rain" }, { "code": 6, "name": "Snow" }, { "code": 7, "name": "Saturated" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "weather", "alias": "Weather", "type": "esriFieldTypeSmallInteger" }, { "modelName": "runoff", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "Inspection_Manhole_Runoff_Potential", "description": "", "type": "codedValue", "codedValues": [ { "code": 0, "name": "Unknown" }, { "code": 1, "name": "Sheeting" }, { "code": 2, "name": "Pounding" }, { "code": 3, "name": "Inundated" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "runoff", "alias": "Runoff Potential", "type": "esriFieldTypeSmallInteger" }, { "modelName": "inspectionstatus", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "Inspection_Manhole_Status", "description": "", "type": "codedValue", "codedValues": [ { "code": 0, "name": "Unknown" }, { "code": 1, "name": "Surface Inspection" }, { "code": 2, "name": "Descent Inspection" }, { "code": 3, "name": "Remote Inspection" }, { "code": 4, "name": "Not Found" }, { "code": 5, "name": "Not Opened" }, { "code": 6, "name": "Surcharged/Debris" }, { "code": 7, "name": "Not Inspected - Traffic" }, { "code": 8, "name": "No Access" }, { "code": 9, "name": "Buried and Marked" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "inspectionstatus", "alias": "Inspection Status", "type": "esriFieldTypeSmallInteger" }, { "modelName": "evidsurcharge", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "Yes_No", "description": "A yes/no indicator", "type": "codedValue", "codedValues": [ { "code": 0, "name": "Unknown" }, { "code": 1, "name": "Yes" }, { "code": 2, "name": "No" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "evidsurcharge", "alias": "Evidence of Surcharge", "type": "esriFieldTypeSmallInteger" }, { "modelName": "coverfit", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "Inspection_Manhole_Cover_Fit", "description": "", "type": "codedValue", "codedValues": [ { "code": 0, "name": "Unknown" }, { "code": 1, "name": "Oversized" }, { "code": 2, "name": "Undersized" }, { "code": 3, "name": "Rocks/Wobbles" }, { "code": 4, "name": "Good" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "coverfit", "alias": "Cover Fit", "type": "esriFieldTypeSmallInteger" }, { "modelName": "covercondition", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "Inspection_Manhole_Cover_Condition", "description": "", "type": "codedValue", "codedValues": [ { "code": 0, "name": "Unknown" }, { "code": 1, "name": "Sound" }, { "code": 2, "name": "Cracked" }, { "code": 3, "name": "Broken" }, { "code": 4, "name": "Missing" }, { "code": 5, "name": "Corroded/Pitted" }, { "code": 6, "name": "Bolts Missing" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "covercondition", "alias": "Cover Condition", "type": "esriFieldTypeSmallInteger" }, { "modelName": "coverinsertcondition", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "Inspection_Manhole_Cover_Insert_Condition", "description": "", "type": "codedValue", "codedValues": [ { "code": 0, "name": "Unknown" }, { "code": 1, "name": "Sound" }, { "code": 2, "name": "Poorly Fitting" }, { "code": 3, "name": "Cracked/Torn/Holes" }, { "code": 4, "name": "Leaking" }, { "code": 5, "name": "Insert Fell" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "coverinsertcondition", "alias": "Cover Insert Condition", "type": "esriFieldTypeSmallInteger" }, { "modelName": "coverringcondition", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "Inspection_Manhole_Adjustable_Ring_Condition", "description": "", "type": "codedValue", "codedValues": [ { "code": 0, "name": "Unknown" }, { "code": 1, "name": "Sound" }, { "code": 2, "name": "Cracked" }, { "code": 3, "name": "Broken" }, { "code": 4, "name": "Corroded/Pitted/Worn" }, { "code": 5, "name": "Leaking" }, { "code": 6, "name": "Poor Installation" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "coverringcondition", "alias": "Cover Ring Condition", "type": "esriFieldTypeSmallInteger" }, { "modelName": "framecondition", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "Inspection_Manhole_Frame_Condition", "description": "", "type": "codedValue", "codedValues": [ { "code": 0, "name": "Unknown" }, { "code": 1, "name": "Sound" }, { "code": 2, "name": "Cracked" }, { "code": 3, "name": "Broken" }, { "code": 4, "name": "Missing" }, { "code": 5, "name": "Corroded/Pitted/Worn" }, { "code": 6, "name": "Coated" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "framecondition", "alias": "Frame Condition", "type": "esriFieldTypeSmallInteger" }, { "modelName": "framesealcondition", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "Inspection_Manhole_Frame_Seal_Condition", "description": "", "type": "codedValue", "codedValues": [ { "code": 0, "name": "Unknown" }, { "code": 1, "name": "Sound" }, { "code": 2, "name": "Cracked" }, { "code": 3, "name": "Loose/Not Attached" }, { "code": 4, "name": "Offset" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "framesealcondition", "alias": "Frame Seal Condition", "type": "esriFieldTypeSmallInteger" }, { "modelName": "framesealinflow", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "Inspection_Manhole_Frame_Seal_Inflow", "description": "", "type": "codedValue", "codedValues": [ { "code": 0, "name": "Unknown" }, { "code": 1, "name": "None" }, { "code": 2, "name": "Stains" }, { "code": 3, "name": "I&I Visible - Weeper" }, { "code": 4, "name": "I&I Visible - Dripper" }, { "code": 5, "name": "I&I Visible - Runner" }, { "code": 6, "name": "I&I Visible - Gusher" }, { "code": 7, "name": "Dye Test Positive" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "framesealinflow", "alias": "Evidence of Frame Seal Inflow", "type": "esriFieldTypeSmallInteger" }, { "modelName": "notes", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "notes", "length": 2000, "alias": "Notes", "type": "esriFieldTypeString" }, { "modelName": "assetguid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "assetguid", "length": 38, "alias": "Asset Guid", "type": "esriFieldTypeGUID" }, { "modelName": "created_user", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "created_user", "length": 255, "alias": "created_user", "type": "esriFieldTypeString" }, { "modelName": "created_date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "created_date", "length": 8, "alias": "created_date", "type": "esriFieldTypeDate" }, { "modelName": "last_edited_user", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "last_edited_user", "length": 255, "alias": "last_edited_user", "type": "esriFieldTypeString" }, { "modelName": "last_edited_date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "last_edited_date", "length": 8, "alias": "last_edited_date", "type": "esriFieldTypeDate" }, { "modelName": "GlobalID", "nullable": false, "editable": true, "defaultValue": "{00000000-0000-0000-0000-000000000000}", "domain": null, "name": "globalid", "length": 38, "alias": "GlobalID", "type": "esriFieldTypeGUID" }, { "modelName": "CreationDate", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "creationdate", "length": 8, "alias": "CreationDate", "type": "esriFieldTypeDate", "required": true }, { "modelName": "Creator", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "creator", "length": 128, "alias": "Creator", "type": "esriFieldTypeString", "required": true }, { "modelName": "EditDate", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "editdate", "length": 8, "alias": "EditDate", "type": "esriFieldTypeDate", "required": true }, { "modelName": "Editor", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "editor", "length": 128, "alias": "Editor", "type": "esriFieldTypeString", "required": true }, { "modelName": "OBJECTID", "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "objectid", "alias": "OBJECTID", "type": "esriFieldTypeOID" }, { "modelName": "GlobalID_1", "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "GlobalID_1", "length": 38, "alias": "GlobalID_1", "type": "esriFieldTypeGlobalID" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "America/Chicago", "respectsDaylightSaving": true, "timeZone": "Central Standard Time" }, "bigIntegerRestrictedTo53Bits": true, "preferredTimeReference": null, "useStandardizedQueries": true, "globalIdField": "GlobalID_1", "description": "", "syncCanReturnChanges": true, "supportsRollbackOnFailureParameter": false, "isDataReplicaTracked": false, "indexes": [ { "name": "I165globalid", "isUnique": false, "description": "", "isAscending": true, "fields": "globalid" }, { "name": "I165assetguid", "isUnique": false, "description": "", "isAscending": true, "fields": "assetguid" }, { "name": "I165creationdate", "isUnique": false, "description": "", "isAscending": true, "fields": "creationdate" }, { "name": "I165creator", "isUnique": false, "description": "", "isAscending": true, "fields": "creator" }, { "name": "I165editdate", "isUnique": false, "description": "", "isAscending": true, "fields": "editdate" }, { "name": "I165editor", "isUnique": false, "description": "", "isAscending": true, "fields": "editor" }, { "name": "gdb_ct3_22", "isUnique": false, "description": "", "isAscending": true, "fields": "objectid" }, { "name": "UUID_22", "isUnique": true, "description": "", "isAscending": true, "fields": "GlobalID_1" } ], "editFieldsInfo": { "editDateField": "EditDate", "editorField": "Editor", "creationDateField": "CreationDate", "creatorField": "Creator", "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false, "timeZone": "UTC" } }, "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasAttachments": true, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "fullTextSearchCapabilities": { "supportsSqlExpressionInFullText": true, "supportsOperator": false, "supportsSearchOperator": true }, "supportsQueryWithLodSR": false, "supportsPagination": true, "fullTextSearchableFields": [], "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": true, "supportsQueryWithDistance": true, "supportsQueryAttachmentOrderByFields": true, "supportsLod": false, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsReturningGeometryEnvelope": false, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": "", "supportsValidateSQL": true, "serviceItemId": "0f739664893f42f8bdb01bbb63cc551c", "supportsCoordinatesQuantization": false, "types": [], "capabilities": "Query,Create,Update,Delete,Uploads,Editing,ChangeTracking", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": true }, "hasMetadata": true, "supportedAppendFormats": "FILEGDB,PBF", "tileMaxRecordCount": 2000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "copyrightText": "" }