{ "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": ["count"], "datesInUnknownTimezone": false, "ownershipBasedAccessControlForFeatures": null, "type": "Table", "subtypes": [ { "code": 1, "name": "Manhole", "defaultValues": { "StepConstruction": null, "Address": null, "InspectionDate": null, "InfiltrationFlowRate": null, "Pipe4Direction": null, "Pipe1Depth": null, "ApronCondition": null, "FrameCondition": null, "OverallCondition": null, "TroughCondition": null, "RawID": null, "StepCount": null, "Surcharge": null, "InspectedBy": null, "StructureDiameter": null, "ID": null, "ApronDeposition": null, "Pipe5Diameter": null, "RimElev": null, "LidCondition": null, "Images": null, "Grade": null, "Method": null, "SurfaceType": null, "TroughType": null, "Pipe1Diameter": null, "StructureDepth": null, "Infiltration": null, "Pipe4Depth": null, "WallConstruction": null, "Pipe1": null, "DepressionArea": null, "Inflow": null, "Pipe2": null, "Pipe1Direction": null, "Pipe3": null, "Pipe4": null, "Pipe3Diameter": null, "Pipe5": null, "LidLeakage": null, "DepositionDepth": null, "Pipe3Depth": null, "Pipe2Direction": null, "WallLeakage": null, "InfiltrationLocation": null, "CorbelLeakage": null, "Notes": null, "Pipe5Direction": null, "Pipe5Depth": null, "LocationDepression": null, "Pipe2Depth": null, "Pipe4Diameter": null, "SurchargeHeight": null, "InflowLocation": null, "Pipe3Direction": null, "RingCondition": null, "Type": 1, "LidHoleCount": null, "CorbelOffset": "0", "Pipe2Diameter": null, "StepCondition": null }, "domains": { "StepConstruction": {"type": "inherited"}, "LocationDepression": {"type": "inherited"}, "LidCondition": {"type": "inherited"}, "LidLeakage": {"type": "inherited"}, "RingCondition": {"type": "inherited"}, "ApronCondition": {"type": "inherited"}, "Method": {"type": "inherited"}, "FrameCondition": {"type": "inherited"}, "SurfaceType": {"type": "inherited"}, "OverallCondition": {"type": "inherited"}, "TroughType": {"type": "inherited"}, "TroughCondition": {"type": "inherited"}, "Surcharge": {"type": "inherited"}, "CorbelOffset": {"type": "inherited"}, "WallLeakage": {"type": "inherited"}, "CorbelLeakage": {"type": "inherited"}, "Infiltration": {"type": "inherited"}, "WallConstruction": {"type": "inherited"}, "ApronDeposition": { "splitPolicy": "esriSPTDefaultValue", "name": "ApronDeposition", "description": "Residual material", "type": "codedValue", "codedValues": [ { "code": "N", "name": "None" }, { "code": "M", "name": "Mud" }, { "code": "D", "name": "Debris" }, { "code": "S", "name": "Sludge" } ], "mergePolicy": "esriMPTDefaultValue" }, "Inflow": {"type": "inherited"}, "StepCondition": {"type": "inherited"} } }, { "code": 2, "name": "Cleanout", "defaultValues": { "StepConstruction": null, "Address": null, "InspectionDate": null, "InfiltrationFlowRate": null, "Pipe4Direction": null, "Pipe1Depth": null, "ApronCondition": null, "FrameCondition": null, "OverallCondition": null, "TroughCondition": null, "RawID": null, "StepCount": null, "Surcharge": null, "InspectedBy": null, "StructureDiameter": null, "ID": null, "ApronDeposition": null, "Pipe5Diameter": null, "RimElev": null, "LidCondition": null, "Images": null, "Grade": null, "Method": null, "SurfaceType": null, "TroughType": null, "Pipe1Diameter": null, "StructureDepth": null, "Infiltration": null, "Pipe4Depth": null, "WallConstruction": null, "Pipe1": null, "DepressionArea": null, "Inflow": null, "Pipe2": null, "Pipe1Direction": null, "Pipe3": null, "Pipe4": null, "Pipe3Diameter": null, "Pipe5": null, "LidLeakage": null, "DepositionDepth": null, "Pipe3Depth": null, "Pipe2Direction": null, "WallLeakage": null, "InfiltrationLocation": null, "CorbelLeakage": null, "Notes": null, "Pipe5Direction": null, "Pipe5Depth": null, "LocationDepression": null, "Pipe2Depth": null, "Pipe4Diameter": null, "SurchargeHeight": null, "InflowLocation": null, "Pipe3Direction": null, "RingCondition": null, "Type": 2, "LidHoleCount": null, "CorbelOffset": null, "Pipe2Diameter": null, "StepCondition": null }, "domains": { "StepConstruction": {"type": "inherited"}, "LocationDepression": {"type": "inherited"}, "LidCondition": {"type": "inherited"}, "LidLeakage": {"type": "inherited"}, "RingCondition": {"type": "inherited"}, "ApronCondition": {"type": "inherited"}, "Method": {"type": "inherited"}, "FrameCondition": {"type": "inherited"}, "TroughType": {"type": "inherited"}, "TroughCondition": {"type": "inherited"}, "Surcharge": {"type": "inherited"}, "CorbelOffset": {"type": "inherited"}, "WallLeakage": {"type": "inherited"}, "CorbelLeakage": {"type": "inherited"}, "Infiltration": {"type": "inherited"}, "WallConstruction": {"type": "inherited"}, "ApronDeposition": {"type": "inherited"}, "Inflow": {"type": "inherited"}, "StepCondition": {"type": "inherited"} } }, { "code": 3, "name": "Lift Station", "defaultValues": { "StepConstruction": null, "Address": null, "InspectionDate": null, "InfiltrationFlowRate": null, "Pipe4Direction": null, "Pipe1Depth": null, "ApronCondition": null, "FrameCondition": null, "OverallCondition": null, "TroughCondition": null, "RawID": null, "StepCount": null, "Surcharge": null, "InspectedBy": null, "StructureDiameter": null, "ID": null, "ApronDeposition": null, "Pipe5Diameter": null, "RimElev": null, "LidCondition": null, "Images": null, "Grade": null, "Method": null, "SurfaceType": null, "TroughType": null, "Pipe1Diameter": null, "StructureDepth": null, "Infiltration": null, "Pipe4Depth": null, "WallConstruction": null, "Pipe1": null, "DepressionArea": null, "Inflow": null, "Pipe2": null, "Pipe1Direction": null, "Pipe3": null, "Pipe4": null, "Pipe3Diameter": null, "Pipe5": null, "LidLeakage": null, "DepositionDepth": null, "Pipe3Depth": null, "Pipe2Direction": null, "WallLeakage": null, "InfiltrationLocation": null, "CorbelLeakage": null, "Notes": null, "Pipe5Direction": null, "Pipe5Depth": null, "LocationDepression": null, "Pipe2Depth": null, "Pipe4Diameter": null, "SurchargeHeight": null, "InflowLocation": null, "Pipe3Direction": null, "RingCondition": null, "Type": 3, "LidHoleCount": null, "CorbelOffset": null, "Pipe2Diameter": null, "StepCondition": null }, "domains": { "StepConstruction": {"type": "inherited"}, "LocationDepression": {"type": "inherited"}, "LidCondition": {"type": "inherited"}, "LidLeakage": {"type": "inherited"}, "RingCondition": {"type": "inherited"}, "ApronCondition": {"type": "inherited"}, "Method": {"type": "inherited"}, "FrameCondition": {"type": "inherited"}, "TroughType": {"type": "inherited"}, "TroughCondition": {"type": "inherited"}, "Surcharge": {"type": "inherited"}, "CorbelOffset": {"type": "inherited"}, "WallLeakage": {"type": "inherited"}, "CorbelLeakage": {"type": "inherited"}, "Infiltration": {"type": "inherited"}, "WallConstruction": {"type": "inherited"}, "ApronDeposition": {"type": "inherited"}, "Inflow": {"type": "inherited"}, "StepCondition": {"type": "inherited"} } }, { "code": 4, "name": "Other", "defaultValues": { "StepConstruction": null, "Address": null, "InspectionDate": null, "InfiltrationFlowRate": null, "Pipe4Direction": null, "Pipe1Depth": null, "ApronCondition": null, "FrameCondition": null, "OverallCondition": null, "TroughCondition": null, "RawID": null, "StepCount": null, "Surcharge": null, "InspectedBy": null, "StructureDiameter": null, "ID": null, "ApronDeposition": null, "Pipe5Diameter": null, "RimElev": null, "LidCondition": null, "Images": null, "Grade": null, "Method": null, "SurfaceType": null, "TroughType": null, "Pipe1Diameter": null, "StructureDepth": null, "Infiltration": null, "Pipe4Depth": null, "WallConstruction": null, "Pipe1": null, "DepressionArea": null, "Inflow": null, "Pipe2": null, "Pipe1Direction": null, "Pipe3": null, "Pipe4": null, "Pipe3Diameter": null, "Pipe5": null, "LidLeakage": null, "DepositionDepth": null, "Pipe3Depth": null, "Pipe2Direction": null, "WallLeakage": null, "InfiltrationLocation": null, "CorbelLeakage": null, "Notes": null, "Pipe5Direction": null, "Pipe5Depth": null, "LocationDepression": null, "Pipe2Depth": null, "Pipe4Diameter": null, "SurchargeHeight": null, "InflowLocation": null, "Pipe3Direction": null, "RingCondition": null, "Type": 4, "LidHoleCount": null, "CorbelOffset": null, "Pipe2Diameter": null, "StepCondition": null }, "domains": { "StepConstruction": {"type": "inherited"}, "LocationDepression": {"type": "inherited"}, "LidCondition": {"type": "inherited"}, "LidLeakage": {"type": "inherited"}, "RingCondition": {"type": "inherited"}, "ApronCondition": {"type": "inherited"}, "Method": {"type": "inherited"}, "FrameCondition": {"type": "inherited"}, "TroughType": {"type": "inherited"}, "TroughCondition": {"type": "inherited"}, "Surcharge": {"type": "inherited"}, "CorbelOffset": {"type": "inherited"}, "WallLeakage": {"type": "inherited"}, "CorbelLeakage": {"type": "inherited"}, "Infiltration": {"type": "inherited"}, "WallConstruction": {"type": "inherited"}, "ApronDeposition": {"type": "inherited"}, "Inflow": {"type": "inherited"}, "StepCondition": {"type": "inherited"} } } ], "relationships": [{ "keyField": "ID", "role": "esriRelRoleDestination", "catalogID": "{0A156C6B-791D-4C1A-A266-49B5FBF01208}", "composite": false, "name": "SewerDevice", "relatedTableId": 14, "id": 6, "cardinality": "esriRelCardinalityOneToOne" }], "cimVersion": "3.6.0", "isDataArchived": false, "id": 17, "archivingInfo": { "startArchivingMoment": -1, "supportsQueryWithHistoricMoment": false }, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson,kml", "standardMaxRecordCount": 32000, "isDataVersioned": false, "templates": [], "supportsAdvancedQueries": true, "currentVersion": 12, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedSqlFormatsInCalculate": ["standard"], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "OBJECTID", "name": "Existing_MH_Inspections", "displayField": "ID", "supportsCalculate": true, "fields": [ { "modelName": "OBJECTID", "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "OBJECTID", "alias": "OBJECTID", "type": "esriFieldTypeOID" }, { "modelName": "RawID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "RawID", "alias": "Survey ID", "type": "esriFieldTypeSmallInteger" }, { "modelName": "ID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ID", "length": 50, "alias": "Trotwood ID", "type": "esriFieldTypeString" }, { "modelName": "Type", "nullable": true, "editable": true, "defaultValue": 1, "domain": null, "name": "Type", "alias": "Str type", "type": "esriFieldTypeInteger" }, { "modelName": "Address", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "Address", "length": 80, "alias": "Street Address", "type": "esriFieldTypeString" }, { "modelName": "LocationDepression", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "YesNo", "description": "Simple response", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "LocationDepression", "length": 10, "alias": "Sump?", "type": "esriFieldTypeString" }, { "modelName": "DepressionArea", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "DepressionArea", "length": 20, "alias": "Sump area (ft)", "type": "esriFieldTypeString" }, { "modelName": "RimElev", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "RimElev", "alias": "RimElev", "type": "esriFieldTypeDouble" }, { "modelName": "LidCondition", "nullable": true, "editable": true, "defaultValue": "T", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "LidCondition", "description": "Manhole lid quality", "type": "codedValue", "codedValues": [ { "code": "L", "name": "Loose" }, { "code": "T", "name": "Tight" }, { "code": "S", "name": "Sealed" }, { "code": "B", "name": "Bolted" }, { "code": "P", "name": "Paved over" }, { "code": "O", "name": "Other" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "LidCondition", "length": 12, "alias": "LidCondition", "type": "esriFieldTypeString" }, { "modelName": "LidHoleCount", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "LidHoleCount", "alias": "LidHoleCount", "type": "esriFieldTypeSmallInteger" }, { "modelName": "Grade", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "Grade", "alias": "Grade", "type": "esriFieldTypeDouble" }, { "modelName": "LidLeakage", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "YesNo", "description": "Simple response", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "LidLeakage", "length": 4, "alias": "LidLeakage", "type": "esriFieldTypeString" }, { "modelName": "FrameCondition", "nullable": true, "editable": true, "defaultValue": "S", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "SoundBroken", "description": "Frame quality", "type": "codedValue", "codedValues": [ { "code": "S", "name": "Sound" }, { "code": "B", "name": "Broken" }, { "code": "C", "name": "Cracked" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "FrameCondition", "length": 10, "alias": "FrameCondition", "type": "esriFieldTypeString" }, { "modelName": "CorbelOffset", "nullable": true, "editable": true, "defaultValue": "0", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "CorbelOffset", "description": "eccentric lid offset", "type": "codedValue", "codedValues": [ { "code": "0", "name": "0" }, { "code": "12", "name": "12" }, { "code": "24", "name": "24" }, { "code": "O", "name": "Other" }, { "code": "30", "name": "30" }, { "code": "36", "name": "36" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "CorbelOffset", "length": 5, "alias": "CorbelOffset", "type": "esriFieldTypeString" }, { "modelName": "RingCondition", "nullable": true, "editable": true, "defaultValue": "S", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "SoundBroken", "description": "Frame quality", "type": "codedValue", "codedValues": [ { "code": "S", "name": "Sound" }, { "code": "B", "name": "Broken" }, { "code": "C", "name": "Cracked" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "RingCondition", "length": 10, "alias": "RingCondition", "type": "esriFieldTypeString" }, { "modelName": "CorbelLeakage", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "YesNo", "description": "Simple response", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "CorbelLeakage", "length": 4, "alias": "CorbelLeakage", "type": "esriFieldTypeString" }, { "modelName": "StructureDepth", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "StructureDepth", "alias": "Overall Structure Depth", "type": "esriFieldTypeDouble" }, { "modelName": "WallConstruction", "nullable": true, "editable": true, "defaultValue": "S", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Construction", "description": "Manhole construction type", "type": "codedValue", "codedValues": [ { "code": "B", "name": "Brick" }, { "code": "P", "name": "Precast" }, { "code": "CP", "name": "Cast in Place" }, { "code": "S", "name": "Skimcoat" }, { "code": "CB", "name": "Concrete Block" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "WallConstruction", "length": 15, "alias": "WallConstruction", "type": "esriFieldTypeString" }, { "modelName": "StructureDiameter", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "StructureDiameter", "alias": "Structure Diameter (in.)", "type": "esriFieldTypeSmallInteger" }, { "modelName": "WallLeakage", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "YesNo", "description": "Simple response", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "WallLeakage", "length": 4, "alias": "WallLeakage", "type": "esriFieldTypeString" }, { "modelName": "ApronCondition", "nullable": true, "editable": true, "defaultValue": "G", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "ManholeCondition", "description": "Manhole quality check", "type": "codedValue", "codedValues": [ { "code": "G", "name": "Good" }, { "code": "F", "name": "Fair" }, { "code": "P", "name": "Poor" }, { "code": "N", "name": "None" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "ApronCondition", "length": 8, "alias": "ApronCondition", "type": "esriFieldTypeString" }, { "modelName": "ApronDeposition", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "YesNo", "description": "Simple response", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "ApronDeposition", "length": 8, "alias": "ApronDeposition", "type": "esriFieldTypeString" }, { "modelName": "DepositionDepth", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "DepositionDepth", "alias": "DepositionDepth", "type": "esriFieldTypeDouble" }, { "modelName": "StepConstruction", "nullable": true, "editable": true, "defaultValue": "CI", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "StepConstruction", "description": "Manhole step type", "type": "codedValue", "codedValues": [ { "code": "CA", "name": "Cast Aluminum" }, { "code": "C", "name": "Composite" }, { "code": "R", "name": "Rebar" }, { "code": "O", "name": "Other" }, { "code": "CI", "name": "Cast Iron" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "StepConstruction", "length": 15, "alias": "StepConstruction", "type": "esriFieldTypeString" }, { "modelName": "StepCount", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "StepCount", "alias": "StepCount", "type": "esriFieldTypeSmallInteger" }, { "modelName": "StepCondition", "nullable": true, "editable": true, "defaultValue": "G", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "ManholeCondition", "description": "Manhole quality check", "type": "codedValue", "codedValues": [ { "code": "G", "name": "Good" }, { "code": "F", "name": "Fair" }, { "code": "P", "name": "Poor" }, { "code": "N", "name": "None" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "StepCondition", "length": 8, "alias": "StepCondition", "type": "esriFieldTypeString" }, { "modelName": "TroughType", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "TroughType", "description": "Construction of trough", "type": "codedValue", "codedValues": [ { "code": "BP", "name": "Broken pipe" }, { "code": "SC", "name": "Shaped concrete" }, { "code": "O", "name": "Other" }, { "code": "N", "name": "None" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "TroughType", "length": 15, "alias": "TroughType", "type": "esriFieldTypeString" }, { "modelName": "TroughCondition", "nullable": true, "editable": true, "defaultValue": "G", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "ManholeCondition", "description": "Manhole quality check", "type": "codedValue", "codedValues": [ { "code": "G", "name": "Good" }, { "code": "F", "name": "Fair" }, { "code": "P", "name": "Poor" }, { "code": "N", "name": "None" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "TroughCondition", "length": 8, "alias": "TroughCondition", "type": "esriFieldTypeString" }, { "modelName": "Infiltration", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "YesNo", "description": "Simple response", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "Infiltration", "length": 4, "alias": "Infiltration", "type": "esriFieldTypeString" }, { "modelName": "InfiltrationLocation", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "InfiltrationLocation", "length": 20, "alias": "InfiltrationLocation", "type": "esriFieldTypeString" }, { "modelName": "InfiltrationFlowRate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "InfiltrationFlowRate", "alias": "InfiltrationFlowRate", "type": "esriFieldTypeDouble" }, { "modelName": "Inflow", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "YesNo", "description": "Simple response", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "Inflow", "length": 4, "alias": "Inflow", "type": "esriFieldTypeString" }, { "modelName": "InflowLocation", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "InflowLocation", "length": 20, "alias": "InflowLocation", "type": "esriFieldTypeString" }, { "modelName": "Surcharge", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "YesNo", "description": "Simple response", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "Surcharge", "length": 4, "alias": "Surcharge", "type": "esriFieldTypeString" }, { "modelName": "SurchargeHeight", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "SurchargeHeight", "alias": "SurchargeHeight", "type": "esriFieldTypeDouble" }, { "modelName": "Pipe1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "Pipe1", "length": 50, "alias": "Pipe1", "type": "esriFieldTypeString" }, { "modelName": "Pipe2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "Pipe2", "length": 50, "alias": "Pipe2", "type": "esriFieldTypeString" }, { "modelName": "Pipe3", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "Pipe3", "length": 50, "alias": "Pipe3", "type": "esriFieldTypeString" }, { "modelName": "Pipe4", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "Pipe4", "length": 50, "alias": "Pipe4", "type": "esriFieldTypeString" }, { "modelName": "Pipe5", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "Pipe5", "length": 50, "alias": "Pipe5", "type": "esriFieldTypeString" }, { "modelName": "Method", "nullable": true, "editable": true, "defaultValue": "G", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Method", "description": "Point collection method", "type": "codedValue", "codedValues": [ { "code": "O", "name": "Observed" }, { "code": "G", "name": "GIS" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "Method", "length": 10, "alias": "Method", "type": "esriFieldTypeString" }, { "modelName": "Notes", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "Notes", "length": 150, "alias": "Notes", "type": "esriFieldTypeString" }, { "modelName": "Images", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "Images", "length": 100, "alias": "Images", "type": "esriFieldTypeString" }, { "modelName": "SurfaceType", "nullable": true, "editable": true, "defaultValue": "P", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "SurfaceType", "description": "ground above asset", "type": "codedValue", "codedValues": [ { "code": "W", "name": "Waterway" }, { "code": "U", "name": "Unknown" }, { "code": "AP", "name": "Asphalt Pavement" }, { "code": "CP", "name": "Concrete Pavement" }, { "code": "S", "name": "Sidewalk" }, { "code": "D", "name": "Ditch" }, { "code": "P", "name": "Parkway" }, { "code": "C", "name": "Curb" }, { "code": "AD", "name": "Asphalt Driveway" }, { "code": "CD", "name": "Concrete Driveway" }, { "code": "E", "name": "Easement" }, { "code": "A", "name": "Asphalt (parkway)" }, { "code": "O", "name": "Other" }, { "code": "RY", "name": "Rear Yard" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "SurfaceType", "length": 15, "alias": "SurfaceType", "type": "esriFieldTypeString" }, { "modelName": "InspectedBy", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "InspectedBy", "length": 50, "alias": "InspectedBy", "type": "esriFieldTypeString" }, { "modelName": "InspectionDate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "InspectionDate", "length": 8, "alias": "InspectionDate", "type": "esriFieldTypeDate" }, { "modelName": "OverallCondition", "nullable": true, "editable": true, "defaultValue": "U", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "PipeCondition", "description": "Pipe quality check", "type": "codedValue", "codedValues": [ { "code": "G", "name": "Good" }, { "code": "F", "name": "Fair" }, { "code": "P", "name": "Poor" }, { "code": "U", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "OverallCondition", "length": 50, "alias": "OverallCondition", "type": "esriFieldTypeString" }, { "modelName": "Pipe1Direction", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "Pipe1Direction", "length": 5, "alias": "Pipe 1 Direction", "type": "esriFieldTypeString" }, { "modelName": "Pipe1Depth", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "Pipe1Depth", "alias": "Pipe 1 Depth", "type": "esriFieldTypeDouble" }, { "modelName": "Pipe2Direction", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "Pipe2Direction", "length": 5, "alias": "Pipe 2 Direction", "type": "esriFieldTypeString" }, { "modelName": "Pipe2Depth", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "Pipe2Depth", "alias": "Pipe 2 Depth", "type": "esriFieldTypeDouble" }, { "modelName": "Pipe3Direction", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "Pipe3Direction", "length": 5, "alias": "Pipe 3 Direction", "type": "esriFieldTypeString" }, { "modelName": "Pipe3Depth", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "Pipe3Depth", "alias": "Pipe 3 Depth", "type": "esriFieldTypeDouble" }, { "modelName": "Pipe4Direction", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "Pipe4Direction", "length": 5, "alias": "Pipe 4 Direction", "type": "esriFieldTypeString" }, { "modelName": "Pipe4Depth", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "Pipe4Depth", "alias": "Pipe 4 Depth", "type": "esriFieldTypeDouble" }, { "modelName": "Pipe5Direction", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "Pipe5Direction", "length": 5, "alias": "Pipe 5 Direction", "type": "esriFieldTypeString" }, { "modelName": "Pipe5Depth", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "Pipe5Depth", "alias": "Pipe 5 Depth", "type": "esriFieldTypeDouble" }, { "modelName": "Pipe1Diameter", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "Pipe1Diameter", "alias": "Pipe 1 Diameter", "type": "esriFieldTypeSmallInteger" }, { "modelName": "Pipe2Diameter", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "Pipe2Diameter", "alias": "Pipe 2 Diameter", "type": "esriFieldTypeSmallInteger" }, { "modelName": "Pipe3Diameter", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "Pipe3Diameter", "alias": "Pipe 3 Diameter", "type": "esriFieldTypeSmallInteger" }, { "modelName": "Pipe4Diameter", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "Pipe4Diameter", "alias": "Pipe 4 Diameter", "type": "esriFieldTypeSmallInteger" }, { "modelName": "Pipe5Diameter", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "Pipe5Diameter", "alias": "Pipe 5 Diameter", "type": "esriFieldTypeSmallInteger" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/GMT+5", "respectsDaylightSaving": false, "timeZone": "Eastern Standard Time" }, "bigIntegerRestrictedTo53Bits": true, "preferredTimeReference": null, "useStandardizedQueries": true, "globalIdField": "", "description": "", "syncCanReturnChanges": false, "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "indexes": [ { "name": "R67_SDE_ROWID_UK", "isUnique": true, "description": "", "isAscending": true, "fields": "OBJECTID" }, { "name": "G609ID", "isUnique": false, "description": "", "isAscending": true, "fields": "ID" } ], "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasAttachments": false, "advancedQueryCapabilities": { "supportsStatistics": true, "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsOrderBy": true, "supportsQueryRelatedPagination": true, "supportsFullTextSearch": true, "supportsQueryWithDistance": true, "supportsLod": false, "supportsCountDistinct": true, "supportsCurrentUserQueries": true, "supportsAdvancedQueryRelated": true, "fullTextSearchCapabilities": { "supportsSqlExpressionInFullText": true, "supportsOperator": false, "supportsSearchOperator": true }, "supportsReturningQueryExtent": true, "supportsQueryWithLodSR": false, "supportsReturningGeometryEnvelope": false, "supportsPagination": true, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "fullTextSearchableFields": [] }, "subtypeField": "Type", "supportsValidateSQL": true, "serviceItemId": "df55517e9a5e4d21b4919d766fd03e8c", "supportsCoordinatesQuantization": false, "types": [ { "templates": [{ "name": "Manhole", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": {"attributes": { "StepConstruction": "CI", "Address": null, "InspectionDate": null, "InfiltrationFlowRate": null, "Pipe4Direction": null, "Pipe1Depth": null, "ApronCondition": "G", "FrameCondition": "S", "OverallCondition": "U", "TroughCondition": "G", "RawID": null, "StepCount": null, "Surcharge": null, "InspectedBy": null, "StructureDiameter": null, "ID": null, "ApronDeposition": null, "Pipe5Diameter": null, "RimElev": null, "LidCondition": "T", "Images": null, "Grade": null, "Method": "G", "SurfaceType": "P", "TroughType": null, "Pipe1Diameter": null, "StructureDepth": null, "Infiltration": null, "Pipe4Depth": null, "WallConstruction": "S", "Pipe1": null, "DepressionArea": null, "Inflow": null, "Pipe2": null, "Pipe1Direction": null, "Pipe3": null, "Pipe4": null, "Pipe3Diameter": null, "Pipe5": null, "LidLeakage": null, "DepositionDepth": null, "Pipe3Depth": null, "Pipe2Direction": null, "WallLeakage": null, "InfiltrationLocation": null, "CorbelLeakage": null, "Notes": null, "Pipe5Direction": null, "Pipe5Depth": null, "LocationDepression": null, "Pipe2Depth": null, "Pipe4Diameter": null, "SurchargeHeight": null, "InflowLocation": null, "Pipe3Direction": null, "RingCondition": "S", "Type": 1, "LidHoleCount": null, "CorbelOffset": "0", "Pipe2Diameter": null, "StepCondition": "G" }} }], "name": "Manhole", "domains": { "StepConstruction": {"type": "inherited"}, "LocationDepression": {"type": "inherited"}, "LidCondition": {"type": "inherited"}, "LidLeakage": {"type": "inherited"}, "RingCondition": {"type": "inherited"}, "ApronCondition": {"type": "inherited"}, "Method": {"type": "inherited"}, "FrameCondition": {"type": "inherited"}, "SurfaceType": {"type": "inherited"}, "OverallCondition": {"type": "inherited"}, "TroughType": {"type": "inherited"}, "TroughCondition": {"type": "inherited"}, "Surcharge": {"type": "inherited"}, "CorbelOffset": {"type": "inherited"}, "WallLeakage": {"type": "inherited"}, "CorbelLeakage": {"type": "inherited"}, "Infiltration": {"type": "inherited"}, "WallConstruction": {"type": "inherited"}, "ApronDeposition": { "splitPolicy": "esriSPTDefaultValue", "name": "ApronDeposition", "description": "Residual material", "type": "codedValue", "codedValues": [ { "code": "N", "name": "None" }, { "code": "M", "name": "Mud" }, { "code": "D", "name": "Debris" }, { "code": "S", "name": "Sludge" } ], "mergePolicy": "esriMPTDefaultValue" }, "Inflow": {"type": "inherited"}, "StepCondition": {"type": "inherited"} }, "id": 1 }, { "templates": [{ "name": "Cleanout", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": {"attributes": { "StepConstruction": "CI", "Address": null, "InspectionDate": null, "InfiltrationFlowRate": null, "Pipe4Direction": null, "Pipe1Depth": null, "ApronCondition": "G", "FrameCondition": "S", "OverallCondition": "U", "TroughCondition": "G", "RawID": null, "StepCount": null, "Surcharge": null, "InspectedBy": null, "StructureDiameter": null, "ID": null, "ApronDeposition": null, "Pipe5Diameter": null, "RimElev": null, "LidCondition": "T", "Images": null, "Grade": null, "Method": "G", "SurfaceType": "P", "TroughType": null, "Pipe1Diameter": null, "StructureDepth": null, "Infiltration": null, "Pipe4Depth": null, "WallConstruction": "S", "Pipe1": null, "DepressionArea": null, "Inflow": null, "Pipe2": null, "Pipe1Direction": null, "Pipe3": null, "Pipe4": null, "Pipe3Diameter": null, "Pipe5": null, "LidLeakage": null, "DepositionDepth": null, "Pipe3Depth": null, "Pipe2Direction": null, "WallLeakage": null, "InfiltrationLocation": null, "CorbelLeakage": null, "Notes": null, "Pipe5Direction": null, "Pipe5Depth": null, "LocationDepression": null, "Pipe2Depth": null, "Pipe4Diameter": null, "SurchargeHeight": null, "InflowLocation": null, "Pipe3Direction": null, "RingCondition": "S", "Type": 2, "LidHoleCount": null, "CorbelOffset": "0", "Pipe2Diameter": null, "StepCondition": "G" }} }], "name": "Cleanout", "domains": { "StepConstruction": {"type": "inherited"}, "LocationDepression": {"type": "inherited"}, "LidCondition": {"type": "inherited"}, "LidLeakage": {"type": "inherited"}, "RingCondition": {"type": "inherited"}, "ApronCondition": {"type": "inherited"}, "Method": {"type": "inherited"}, "FrameCondition": {"type": "inherited"}, "TroughType": {"type": "inherited"}, "TroughCondition": {"type": "inherited"}, "Surcharge": {"type": "inherited"}, "CorbelOffset": {"type": "inherited"}, "WallLeakage": {"type": "inherited"}, "CorbelLeakage": {"type": "inherited"}, "Infiltration": {"type": "inherited"}, "WallConstruction": {"type": "inherited"}, "ApronDeposition": {"type": "inherited"}, "Inflow": {"type": "inherited"}, "StepCondition": {"type": "inherited"} }, "id": 2 }, { "templates": [{ "name": "Lift Station", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": {"attributes": { "StepConstruction": "CI", "Address": null, "InspectionDate": null, "InfiltrationFlowRate": null, "Pipe4Direction": null, "Pipe1Depth": null, "ApronCondition": "G", "FrameCondition": "S", "OverallCondition": "U", "TroughCondition": "G", "RawID": null, "StepCount": null, "Surcharge": null, "InspectedBy": null, "StructureDiameter": null, "ID": null, "ApronDeposition": null, "Pipe5Diameter": null, "RimElev": null, "LidCondition": "T", "Images": null, "Grade": null, "Method": "G", "SurfaceType": "P", "TroughType": null, "Pipe1Diameter": null, "StructureDepth": null, "Infiltration": null, "Pipe4Depth": null, "WallConstruction": "S", "Pipe1": null, "DepressionArea": null, "Inflow": null, "Pipe2": null, "Pipe1Direction": null, "Pipe3": null, "Pipe4": null, "Pipe3Diameter": null, "Pipe5": null, "LidLeakage": null, "DepositionDepth": null, "Pipe3Depth": null, "Pipe2Direction": null, "WallLeakage": null, "InfiltrationLocation": null, "CorbelLeakage": null, "Notes": null, "Pipe5Direction": null, "Pipe5Depth": null, "LocationDepression": null, "Pipe2Depth": null, "Pipe4Diameter": null, "SurchargeHeight": null, "InflowLocation": null, "Pipe3Direction": null, "RingCondition": "S", "Type": 3, "LidHoleCount": null, "CorbelOffset": "0", "Pipe2Diameter": null, "StepCondition": "G" }} }], "name": "Lift Station", "domains": { "StepConstruction": {"type": "inherited"}, "LocationDepression": {"type": "inherited"}, "LidCondition": {"type": "inherited"}, "LidLeakage": {"type": "inherited"}, "RingCondition": {"type": "inherited"}, "ApronCondition": {"type": "inherited"}, "Method": {"type": "inherited"}, "FrameCondition": {"type": "inherited"}, "TroughType": {"type": "inherited"}, "TroughCondition": {"type": "inherited"}, "Surcharge": {"type": "inherited"}, "CorbelOffset": {"type": "inherited"}, "WallLeakage": {"type": "inherited"}, "CorbelLeakage": {"type": "inherited"}, "Infiltration": {"type": "inherited"}, "WallConstruction": {"type": "inherited"}, "ApronDeposition": {"type": "inherited"}, "Inflow": {"type": "inherited"}, "StepCondition": {"type": "inherited"} }, "id": 3 }, { "templates": [{ "name": "Other", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": {"attributes": { "StepConstruction": "CI", "Address": null, "InspectionDate": null, "InfiltrationFlowRate": null, "Pipe4Direction": null, "Pipe1Depth": null, "ApronCondition": "G", "FrameCondition": "S", "OverallCondition": "U", "TroughCondition": "G", "RawID": null, "StepCount": null, "Surcharge": null, "InspectedBy": null, "StructureDiameter": null, "ID": null, "ApronDeposition": null, "Pipe5Diameter": null, "RimElev": null, "LidCondition": "T", "Images": null, "Grade": null, "Method": "G", "SurfaceType": "P", "TroughType": null, "Pipe1Diameter": null, "StructureDepth": null, "Infiltration": null, "Pipe4Depth": null, "WallConstruction": "S", "Pipe1": null, "DepressionArea": null, "Inflow": null, "Pipe2": null, "Pipe1Direction": null, "Pipe3": null, "Pipe4": null, "Pipe3Diameter": null, "Pipe5": null, "LidLeakage": null, "DepositionDepth": null, "Pipe3Depth": null, "Pipe2Direction": null, "WallLeakage": null, "InfiltrationLocation": null, "CorbelLeakage": null, "Notes": null, "Pipe5Direction": null, "Pipe5Depth": null, "LocationDepression": null, "Pipe2Depth": null, "Pipe4Diameter": null, "SurchargeHeight": null, "InflowLocation": null, "Pipe3Direction": null, "RingCondition": "S", "Type": 4, "LidHoleCount": null, "CorbelOffset": "0", "Pipe2Diameter": null, "StepCondition": "G" }} }], "name": "Other", "domains": { "StepConstruction": {"type": "inherited"}, "LocationDepression": {"type": "inherited"}, "LidCondition": {"type": "inherited"}, "LidLeakage": {"type": "inherited"}, "RingCondition": {"type": "inherited"}, "ApronCondition": {"type": "inherited"}, "Method": {"type": "inherited"}, "FrameCondition": {"type": "inherited"}, "TroughType": {"type": "inherited"}, "TroughCondition": {"type": "inherited"}, "Surcharge": {"type": "inherited"}, "CorbelOffset": {"type": "inherited"}, "WallLeakage": {"type": "inherited"}, "CorbelLeakage": {"type": "inherited"}, "Infiltration": {"type": "inherited"}, "WallConstruction": {"type": "inherited"}, "ApronDeposition": {"type": "inherited"}, "Inflow": {"type": "inherited"}, "StepCondition": {"type": "inherited"} }, "id": 4 } ], "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": true }, "hasMetadata": true, "supportedAppendFormats": "FILEGDB,PBF", "tileMaxRecordCount": 2000, "typeIdField": "Type", "supportsASyncCalculate": true, "defaultSubtypeCode": 1, "supportedQueryFormats": "JSON, geoJSON, PBF", "copyrightText": "" }