{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 5, "name": "GIS.DBO.ssManholeInspectionTable", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "FACILITYID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Facility Identifier", "length": 100, "domain": null }, { "name": "INSPTYPE", "type": "esriFieldTypeString", "alias": "Type of Manhole Inspection", "length": 50, "domain": { "type": "codedValue", "name": "INSPTYPE", "description": "", "codedValues": [ { "name": "Routine Maintenance", "code": "Routine Maintenance" }, { "name": "Repair", "code": "Repair" }, { "name": "Emergency Response", "code": "Emergency Response" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "EQPCNDTN", "type": "esriFieldTypeString", "alias": "Manhole Condition", "length": 50, "domain": { "type": "codedValue", "name": "EQPCNDTN", "description": "", "codedValues": [ { "name": "Excellent", "code": "Excellent" }, { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" }, { "name": "Replace", "code": "Replace" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OBSTRUCT", "type": "esriFieldTypeString", "alias": "Were any Obstructions Encountered", "length": 3, "domain": { "type": "codedValue", "name": "YESNONA", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "REPAIRS", "type": "esriFieldTypeString", "alias": "Are Repairs Needed", "length": 3, "domain": { "type": "codedValue", "name": "YESNONA", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FIELDNOTES", "type": "esriFieldTypeString", "alias": "Field Notes", "length": 150, "domain": null }, { "name": "EQPSTATUS", "type": "esriFieldTypeString", "alias": "Manhole Status", "length": 50, "domain": { "type": "codedValue", "name": "EQPSTATUS", "description": "", "codedValues": [ { "name": "Operational", "code": "Operational" }, { "name": "Out of Service", "code": "Out of Service" }, { "name": "Abandoned", "code": "Abandoned" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "INSPDATE", "type": "esriFieldTypeDate", "alias": "Date Inspected", "length": 8, "domain": null }, { "name": "INSPUSER", "type": "esriFieldTypeString", "alias": "Inspected By", "length": 10, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "GUID", "type": "esriFieldTypeGUID", "alias": "GUID", "length": 38, "domain": null }, { "name": "ManholeSurfaceType", "type": "esriFieldTypeString", "alias": "ManholeSurfaceType", "length": 50, "domain": { "type": "codedValue", "name": "ManholeSurfaceType", "description": "", "codedValues": [ { "name": "Concrete Pavement", "code": "Concrete Pavement" }, { "name": "Concrete Collar", "code": "Concrete Collar" }, { "name": "Asphalt", "code": "Asphalt" }, { "name": "Grass_Dirt", "code": "Grass_Dirt" }, { "name": "Gravel", "code": "Gravel" }, { "name": "other", "code": "other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CoverShape", "type": "esriFieldTypeString", "alias": "CoverShape", "length": 50, "domain": { "type": "codedValue", "name": "MHShape", "description": "", "codedValues": [ { "name": "Circular", "code": "Circular" }, { "name": "Square", "code": "Square" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CoverSize", "type": "esriFieldTypeSmallInteger", "alias": "CoverSize", "domain": { "type": "codedValue", "name": "MHCoverSize", "description": "MHCoverSize", "codedValues": [ { "name": "24\"", "code": 24 }, { "name": "Other", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CoverMaterial", "type": "esriFieldTypeString", "alias": "CoverMaterial", "length": 50, "domain": { "type": "codedValue", "name": "MhoCoverMaterial", "description": "", "codedValues": [ { "name": "Aluminum", "code": "Aluminum" }, { "name": "Cast Iron", "code": "Cast Iron" }, { "name": "other", "code": "other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CoverFrameFit", "type": "esriFieldTypeString", "alias": "CoverFrameFit", "length": 50, "domain": { "type": "codedValue", "name": "Condition", "description": "", "codedValues": [ { "name": "Excellent", "code": "Excellent" }, { "name": "Very Good", "code": "Very Good" }, { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" }, { "name": "Very Poor", "code": "Very Poor" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "CoverType", "type": "esriFieldTypeString", "alias": "CoverType", "length": 50, "domain": { "type": "codedValue", "name": "piManholeCoverType", "description": "", "codedValues": [ { "name": "Standard W/ Lock", "code": "Standard W/ Lock" }, { "name": "Standard W/ Ears", "code": "Standard W/ Ears" }, { "name": "Non-District", "code": "Non-District" }, { "name": "Water Tight", "code": "Water Tight" }, { "name": "27\" Diameter", "code": "27\" Diameter" }, { "name": "42\" Diameter", "code": "42\" Diameter" }, { "name": "Large - Water Tight", "code": "Large - Water Tight" }, { "name": "Rectangular", "code": "Rectangular" }, { "name": "Other", "code": "Other" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Solid", "code": "Solid" }, { "name": "Vented_Slots", "code": "Vented_Slots" }, { "name": "Gasketed", "code": "gasketed" }, { "name": "hatch single", "code": "hatch single" }, { "name": "Hatch Double", "code": "Hatch Double" }, { "name": "Bolted", "code": "Bolted" }, { "name": "Locking", "code": "Locking" }, { "name": "Lamphole", "code": "Lamphole" }, { "name": "Inner Cover", "code": "Inner Cover" }, { "name": "24\" Diameter", "code": "24\" Diameter" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "NumberOf_VentHoles", "type": "esriFieldTypeSmallInteger", "alias": "NumberOf_VentHoles", "domain": null }, { "name": "CoverCondition", "type": "esriFieldTypeString", "alias": "CoverCondition", "length": 50, "domain": { "type": "codedValue", "name": "CoverCondition", "description": "CoverCondition", "codedValues": [ { "name": "sound", "code": "sound" }, { "name": "cracked", "code": "cracked" }, { "name": "broken", "code": "broken" }, { "name": "missing", "code": "missing" }, { "name": "corroded/pitted", "code": "corroded/pitted" }, { "name": "restraint missing", "code": "restraint missing" }, { "name": "restraint defective", "code": "restraint defective" }, { "name": "other", "code": "other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CoverInsertType", "type": "esriFieldTypeString", "alias": "CoverInsertType", "length": 50, "domain": { "type": "codedValue", "name": "MHCover_Insert_Type", "description": "MHCover_Insert_Type", "codedValues": [ { "name": "Tray Tin", "code": "Tray Tin" }, { "name": "Tray Metal", "code": "Tray Metal" }, { "name": "None", "code": "None" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CoverInsertCondition", "type": "esriFieldTypeString", "alias": "CoverInsertCondition", "length": 50, "domain": { "type": "codedValue", "name": "CoverCondition", "description": "CoverCondition", "codedValues": [ { "name": "sound", "code": "sound" }, { "name": "cracked", "code": "cracked" }, { "name": "broken", "code": "broken" }, { "name": "missing", "code": "missing" }, { "name": "corroded/pitted", "code": "corroded/pitted" }, { "name": "restraint missing", "code": "restraint missing" }, { "name": "restraint defective", "code": "restraint defective" }, { "name": "other", "code": "other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "EvidenceOfSurcharge", "type": "esriFieldTypeString", "alias": "EvidenceOfSurcharge", "length": 50, "domain": { "type": "codedValue", "name": "YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Elevation", "type": "esriFieldTypeInteger", "alias": "Elevation", "domain": null }, { "name": "InspectionStatus", "type": "esriFieldTypeString", "alias": "InspectionStatus", "length": 50, "domain": { "type": "codedValue", "name": "MHInspectStatus", "description": "Manhole Inspection Status", "codedValues": [ { "name": "Inspected", "code": "Inspected" }, { "name": "Not Inspected", "code": "Not Inspected" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MH_Adj_Ring_Material", "type": "esriFieldTypeString", "alias": "MH_Adj_Ring_Material", "length": 255, "domain": { "type": "codedValue", "name": "MH__Adj_Mat", "description": "", "codedValues": [ { "name": "CastI Iron", "code": "CastI Iron" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MH_Adj_Ring_Height", "type": "esriFieldTypeDouble", "alias": "MH_Adj_Ring_Height", "domain": null }, { "name": "MH_Adj_Ring", "type": "esriFieldTypeString", "alias": "MH_Adj_Ring", "length": 255, "domain": { "type": "codedValue", "name": "MHAdjustRingCondition", "description": "MHAdjustRing", "codedValues": [ { "name": "Sound", "code": "Sound" }, { "name": "Cracked", "code": "Cracked" }, { "name": "Broken", "code": "Broken" }, { "name": "Corroded_Pitted_Worn", "code": "Corroded_Pitted_Worn" }, { "name": "Leaking", "code": "Leaking" }, { "name": "PoorInstallation", "code": "PoorInstallation" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Frame_Offset_Distance", "type": "esriFieldTypeDouble", "alias": "Frame_Offset_Distance", "domain": null }, { "name": "Frame_Condition", "type": "esriFieldTypeString", "alias": "Frame_Condition", "length": 255, "domain": { "type": "codedValue", "name": "FrameCondition", "description": "FrameCondition", "codedValues": [ { "name": "Sound", "code": "Sound" }, { "name": "Cracked", "code": "Cracked" }, { "name": "Broken", "code": "Broken" }, { "name": "Missing", "code": "Missing" }, { "name": "Coated", "code": "Coated" }, { "name": "Corroeded_Pitted_Worn", "code": "Corroeded Pitted Worn" }, { "name": "Offset", "code": "Offset" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Frame_Seal_Condition", "type": "esriFieldTypeString", "alias": "Frame_Seal_Condition", "length": 255, "domain": { "type": "codedValue", "name": "FrameSealCondition", "description": "FrameSealCondition", "codedValues": [ { "name": "Sound", "code": "Sound" }, { "name": "Cracked", "code": "Cracked" }, { "name": "Missing", "code": "Missing" }, { "name": "Offset", "code": "Offset" }, { "name": "Loose_NotAttached", "code": "Loose_NotAttached" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Cone_Type", "type": "esriFieldTypeString", "alias": "Cone_Type", "length": 255, "domain": { "type": "codedValue", "name": "MHConeType", "description": "MHConeType", "codedValues": [ { "name": "Conical Centered", "code": "Conical Centered" }, { "name": "Conical Off-Centered", "code": "Conical Off-Centered" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Int_Cone_Coat", "type": "esriFieldTypeString", "alias": "Int_Cone_Coat", "length": 255, "domain": { "type": "codedValue", "name": "YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Cone_Material", "type": "esriFieldTypeString", "alias": "Cone_Material", "length": 255, "domain": null }, { "name": "Bench_Present", "type": "esriFieldTypeString", "alias": "Bench_Present", "length": 255, "domain": { "type": "codedValue", "name": "MHBench", "description": "MHBench", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "Epoxy", "code": "None" }, { "name": "Partial", "code": "Partial" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Bench_Material", "type": "esriFieldTypeString", "alias": "Bench_Material", "length": 255, "domain": { "type": "codedValue", "name": "MH_BenchMaterial", "description": "", "codedValues": [ { "name": "Concrete", "code": "Concrete" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Bench_Coat", "type": "esriFieldTypeString", "alias": "Bench_Coat", "length": 255, "domain": { "type": "codedValue", "name": "MH_WallCoating", "description": "", "codedValues": [ { "name": "Epoxy", "code": "Epoxy" }, { "name": "Strong Seal", "code": "Strong Seal" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Channel_Material", "type": "esriFieldTypeString", "alias": "Channel_Material", "length": 255, "domain": { "type": "codedValue", "name": "Chimney_Material", "description": "Chimney_Material", "codedValues": [ { "name": "Concrete", "code": "Concrete" }, { "name": "Other", "code": "Other" }, { "name": "Brick", "code": "Brick" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Channel_Installed", "type": "esriFieldTypeString", "alias": "Channel_Installed", "length": 255, "domain": { "type": "codedValue", "name": "YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Number_Steps", "type": "esriFieldTypeSmallInteger", "alias": "Number_Steps", "domain": null }, { "name": "Step_Material", "type": "esriFieldTypeString", "alias": "Step_Material", "length": 255, "domain": { "type": "codedValue", "name": "MH_StepMaterial", "description": "MH_StepMaterial", "codedValues": [ { "name": "Cast Iron", "code": "Cast Iron" }, { "name": "Aluminum", "code": "Aluminum" }, { "name": "Plastic", "code": "Plastic" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Outgoing_Rim_to_Invert", "type": "esriFieldTypeDouble", "alias": "Outgoing_Rim_to_Invert", "domain": null }, { "name": "FrameDepth", "type": "esriFieldTypeDouble", "alias": "FrameDepth", "domain": null }, { "name": "MH_RingType", "type": "esriFieldTypeString", "alias": "MH Ring Type", "length": 255, "domain": { "type": "codedValue", "name": "MHRingType", "description": "", "codedValues": [ { "name": "Adjustable", "code": "Adjustable" }, { "name": "Solid", "code": "Solid" }, { "name": "Both", "code": "Both" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FrameInflowInfiltration", "type": "esriFieldTypeString", "alias": "FrameInflow_Infiltration", "length": 255, "domain": { "type": "codedValue", "name": "YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Chimney_Material", "type": "esriFieldTypeString", "alias": "Chimney Material", "length": 255, "domain": { "type": "codedValue", "name": "Chimney_Material", "description": "Chimney_Material", "codedValues": [ { "name": "Concrete", "code": "Concrete" }, { "name": "Other", "code": "Other" }, { "name": "Brick", "code": "Brick" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Wall_Material", "type": "esriFieldTypeString", "alias": "Wall Material", "length": 255, "domain": { "type": "codedValue", "name": "Chimney_Material", "description": "Chimney_Material", "codedValues": [ { "name": "Concrete", "code": "Concrete" }, { "name": "Other", "code": "Other" }, { "name": "Brick", "code": "Brick" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Wall_Coating", "type": "esriFieldTypeString", "alias": "Wall Coating", "length": 255, "domain": { "type": "codedValue", "name": "MH_WallCoating", "description": "", "codedValues": [ { "name": "Epoxy", "code": "Epoxy" }, { "name": "Strong Seal", "code": "Strong Seal" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Channel_Condition", "type": "esriFieldTypeString", "alias": "Channel Condition", "length": 255, "domain": { "type": "codedValue", "name": "MH_ChannelCondition", "description": "", "codedValues": [ { "name": "GOOD", "code": "GOOD" }, { "name": "POOR", "code": "POOR" }, { "name": "NEEDS REPAIR", "code": "NEEDS REPAIR" }, { "name": "OTHER", "code": "OTHER" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InspectionStyle", "type": "esriFieldTypeString", "alias": "Inspection Style", "length": 255, "domain": { "type": "codedValue", "name": "MH_InspectionStyle", "description": "", "codedValues": [ { "name": "Above Ground", "code": "Above Ground" }, { "name": "Remote", "code": "Remote" }, { "name": "Descend", "code": "Descend" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R89_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_89", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_89", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "ssManhole", "relatedTableId": 2, "role": "esriRelRoleDestination", "keyField": "GUID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{B2E41B7D-E254-45A8-9257-6EC153D8A7B7}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }