{ "preferredTimeReference": null, "useStandardizedQueries": true, "maxRecordCount": 2000, "description": null, "datesInUnknownTimezone": false, "type": "Table", "subtypes": [ { "code": 1, "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"} }, "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": null, "LidHoleCount": null, "CorbelOffset": "0", "Pipe2Diameter": null, "StepCondition": null } }, { "code": 2, "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"} }, "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": null, "LidHoleCount": null, "CorbelOffset": null, "Pipe2Diameter": null, "StepCondition": null } }, { "code": 3, "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"} }, "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": null, "LidHoleCount": null, "CorbelOffset": null, "Pipe2Diameter": null, "StepCondition": null } }, { "code": 4, "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"} }, "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": null, "LidHoleCount": null, "CorbelOffset": null, "Pipe2Diameter": null, "StepCondition": null } } ], "relationships": [{ "keyField": "ID", "role": "esriRelRoleDestination", "catalogID": "{0A156C6B-791D-4C1A-A266-49B5FBF01208}", "composite": false, "name": "SewerDevice", "relatedTableId": 14, "id": 6, "cardinality": "esriRelCardinalityOneToOne" }], "indexes": [ { "name": "R67_SDE_ROWID_UK", "isUnique": true, "description": "", "fields": "OBJECTID", "isAscending": true }, { "name": "G609ID", "isUnique": false, "description": "", "fields": "ID", "isAscending": true } ], "htmlPopupType": "esriServerHTMLPopupTypeNone", "cimVersion": "3.6.0", "isDataArchived": false, "id": 17, "archivingInfo": { "startArchivingMoment": -1, "supportsQueryWithHistoricMoment": false }, "hasAttachments": false, "advancedQueryCapabilities": { "supportsStatistics": true, "supportsSqlExpression": true, "supportsTrueCurve": false, "supportsOrderBy": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "useStandardizedQueries": true, "supportsQueryWithDistance": true, "supportsCountDistinct": true, "supportsCurrentUserQueries": true, "supportsAdvancedQueryRelated": true, "supportsReturningQueryExtent": true, "supportsPagination": true, "supportsDistinct": true, "supportsTimeRelation": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": "Type", "subtypeFieldName": "Type", "supportsStatistics": true, "serviceItemId": "4d3246a8cb4e4a5f9bcec0d35c9fe573", "types": [ { "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 }, { "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 }, { "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 }, { "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,Map,Data", "supportsExceedsLimitStatistics": true, "isDataVersioned": false, "supportsAdvancedQueries": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": true }, "hasMetadata": true, "currentVersion": 12, "typeIdField": "Type", "defaultSubtypeCode": 1, "supportedQueryFormats": "JSON, PBF", "name": "Existing_MH_Inspections", "displayField": "ID", "copyrightText": null, "fields": [ { "nullable": false, "domain": null, "name": "OBJECTID", "alias": "OBJECTID", "type": "esriFieldTypeOID" }, { "nullable": true, "domain": null, "name": "RawID", "alias": "Survey ID", "type": "esriFieldTypeSmallInteger" }, { "nullable": true, "domain": null, "name": "ID", "length": 50, "alias": "Trotwood ID", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "Type", "alias": "Str type", "type": "esriFieldTypeInteger" }, { "nullable": true, "domain": null, "name": "Address", "length": 80, "alias": "Street Address", "type": "esriFieldTypeString" }, { "nullable": true, "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" }, { "nullable": true, "domain": null, "name": "DepressionArea", "length": 20, "alias": "Sump area (ft)", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "RimElev", "alias": "RimElev", "type": "esriFieldTypeDouble" }, { "nullable": true, "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" }, { "nullable": true, "domain": null, "name": "LidHoleCount", "alias": "LidHoleCount", "type": "esriFieldTypeSmallInteger" }, { "nullable": true, "domain": null, "name": "Grade", "alias": "Grade", "type": "esriFieldTypeDouble" }, { "nullable": true, "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" }, { "nullable": true, "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" }, { "nullable": true, "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" }, { "nullable": true, "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" }, { "nullable": true, "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" }, { "nullable": true, "domain": null, "name": "StructureDepth", "alias": "Overall Structure Depth", "type": "esriFieldTypeDouble" }, { "nullable": true, "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" }, { "nullable": true, "domain": null, "name": "StructureDiameter", "alias": "Structure Diameter (in.)", "type": "esriFieldTypeSmallInteger" }, { "nullable": true, "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" }, { "nullable": true, "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" }, { "nullable": true, "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" }, { "nullable": true, "domain": null, "name": "DepositionDepth", "alias": "DepositionDepth", "type": "esriFieldTypeDouble" }, { "nullable": true, "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" }, { "nullable": true, "domain": null, "name": "StepCount", "alias": "StepCount", "type": "esriFieldTypeSmallInteger" }, { "nullable": true, "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" }, { "nullable": true, "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" }, { "nullable": true, "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" }, { "nullable": true, "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" }, { "nullable": true, "domain": null, "name": "InfiltrationLocation", "length": 20, "alias": "InfiltrationLocation", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "InfiltrationFlowRate", "alias": "InfiltrationFlowRate", "type": "esriFieldTypeDouble" }, { "nullable": true, "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" }, { "nullable": true, "domain": null, "name": "InflowLocation", "length": 20, "alias": "InflowLocation", "type": "esriFieldTypeString" }, { "nullable": true, "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" }, { "nullable": true, "domain": null, "name": "SurchargeHeight", "alias": "SurchargeHeight", "type": "esriFieldTypeDouble" }, { "nullable": true, "domain": null, "name": "Pipe1", "length": 50, "alias": "Pipe1", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "Pipe2", "length": 50, "alias": "Pipe2", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "Pipe3", "length": 50, "alias": "Pipe3", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "Pipe4", "length": 50, "alias": "Pipe4", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "Pipe5", "length": 50, "alias": "Pipe5", "type": "esriFieldTypeString" }, { "nullable": true, "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" }, { "nullable": true, "domain": null, "name": "Notes", "length": 150, "alias": "Notes", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "Images", "length": 100, "alias": "Images", "type": "esriFieldTypeString" }, { "nullable": true, "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" }, { "nullable": true, "domain": null, "name": "InspectedBy", "length": 50, "alias": "InspectedBy", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "InspectionDate", "length": 8, "alias": "InspectionDate", "type": "esriFieldTypeDate" }, { "nullable": true, "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" }, { "nullable": true, "domain": null, "name": "Pipe1Direction", "length": 5, "alias": "Pipe 1 Direction", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "Pipe1Depth", "alias": "Pipe 1 Depth", "type": "esriFieldTypeDouble" }, { "nullable": true, "domain": null, "name": "Pipe2Direction", "length": 5, "alias": "Pipe 2 Direction", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "Pipe2Depth", "alias": "Pipe 2 Depth", "type": "esriFieldTypeDouble" }, { "nullable": true, "domain": null, "name": "Pipe3Direction", "length": 5, "alias": "Pipe 3 Direction", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "Pipe3Depth", "alias": "Pipe 3 Depth", "type": "esriFieldTypeDouble" }, { "nullable": true, "domain": null, "name": "Pipe4Direction", "length": 5, "alias": "Pipe 4 Direction", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "Pipe4Depth", "alias": "Pipe 4 Depth", "type": "esriFieldTypeDouble" }, { "nullable": true, "domain": null, "name": "Pipe5Direction", "length": 5, "alias": "Pipe 5 Direction", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "Pipe5Depth", "alias": "Pipe 5 Depth", "type": "esriFieldTypeDouble" }, { "nullable": true, "domain": null, "name": "Pipe1Diameter", "alias": "Pipe 1 Diameter", "type": "esriFieldTypeSmallInteger" }, { "nullable": true, "domain": null, "name": "Pipe2Diameter", "alias": "Pipe 2 Diameter", "type": "esriFieldTypeSmallInteger" }, { "nullable": true, "domain": null, "name": "Pipe3Diameter", "alias": "Pipe 3 Diameter", "type": "esriFieldTypeSmallInteger" }, { "nullable": true, "domain": null, "name": "Pipe4Diameter", "alias": "Pipe 4 Diameter", "type": "esriFieldTypeSmallInteger" }, { "nullable": true, "domain": null, "name": "Pipe5Diameter", "alias": "Pipe 5 Diameter", "type": "esriFieldTypeSmallInteger" } ], "dateFieldsTimeReference": { "timeZoneIANA": "Etc/GMT+5", "respectsDaylightSaving": false, "timeZone": "Eastern Standard Time" } }