{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 4, "name": "Manhole Inspect Form", "type": "Table", "description": null, "hasAttachments": true, "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 ID", "length": 20, "domain": null }, { "name": "INSPECTOR", "type": "esriFieldTypeString", "alias": "Inspector", "length": 50, "domain": null }, { "name": "DATE", "type": "esriFieldTypeDate", "alias": "Date", "length": 8, "domain": null }, { "name": "STREET", "type": "esriFieldTypeString", "alias": "Street", "length": 100, "domain": null }, { "name": "WEATHER", "type": "esriFieldTypeString", "alias": "Weather", "length": 50, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeSmallInteger", "alias": "Location", "domain": { "type": "codedValue", "name": "ssInspectLocation_2", "description": "", "codedValues": [ { "name": "Traffic Lane", "code": 1 }, { "name": "Crown", "code": 2 }, { "name": "Gutter", "code": 3 }, { "name": "Alley", "code": 4 }, { "name": "Parking Lot", "code": 5 }, { "name": "Driveway", "code": 6 }, { "name": "Sidewalk", "code": 7 }, { "name": "Front Yard", "code": 8 }, { "name": "Rear Yard", "code": 9 }, { "name": "Ditch/Creek", "code": 10 }, { "name": "Easement", "code": 11 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SURFACE_AREA", "type": "esriFieldTypeSmallInteger", "alias": "Surface Area", "domain": { "type": "codedValue", "name": "ssInspectSurfaceArea_2", "description": "", "codedValues": [ { "name": "Paved", "code": 1 }, { "name": "Unpaved", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "COVER_DIAM", "type": "esriFieldTypeString", "alias": "Cover Diam", "length": 50, "domain": null }, { "name": "COVER_HOLES", "type": "esriFieldTypeSmallInteger", "alias": "Cover Holes", "domain": { "type": "range", "name": "ssInspectCoverHoles_2", "description": "", "range": [ 0, 30 ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "HOLE_DIAM", "type": "esriFieldTypeString", "alias": "Hole Diam", "length": 3, "domain": null }, { "name": "MH_COVER_TYPE", "type": "esriFieldTypeString", "alias": "MH Cover Type", "length": 50, "domain": { "type": "codedValue", "name": "ssInspectCoverType_2", "description": "", "codedValues": [ { "name": "Manhole", "code": "MH" }, { "name": "Grate", "code": "GR" }, { "name": "Other", "code": "OTH" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MH_DEPTH", "type": "esriFieldTypeString", "alias": "MH Depth", "length": 30, "domain": null }, { "name": "SURCHARGE", "type": "esriFieldTypeSmallInteger", "alias": "Surcharge", "domain": { "type": "codedValue", "name": "ssInpsectSurcharge_2", "description": "", "codedValues": [ { "name": "Yes", "code": 1 }, { "name": "No", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SURCHARGE_DEPTH", "type": "esriFieldTypeString", "alias": "Surcharge Depth", "length": 50, "domain": null }, { "name": "CORBEL_MTRL_CODE", "type": "esriFieldTypeString", "alias": "Corbel Material", "length": 50, "domain": { "type": "codedValue", "name": "ssInpsectMHMaterial_2", "description": "", "codedValues": [ { "name": "Brick (hand-laid)", "code": "BRK" }, { "name": "Cement Block", "code": "BLK" }, { "name": "Cast Iron", "code": "CI" }, { "name": "Precast Concrete", "code": "PC" }, { "name": "Other (see comments)", "code": "OTH" }, { "name": "Cement", "code": "CEM" }, { "name": "VC Pipe Section", "code": "VC" }, { "name": "Cobblestone", "code": "CBLS" }, { "name": "Ductile Iron", "code": "DI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CORBEL_INFIL_CODE", "type": "esriFieldTypeString", "alias": "Corbel Infiltration", "length": 50, "domain": { "type": "codedValue", "name": "ssInpsectMHInfiltration_2", "description": "", "codedValues": [ { "name": "No Evidence", "code": "NE" }, { "name": "Evidence of Infiltration", "code": "EI" }, { "name": "Active Infiltration", "code": "AI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CORBEL_CONDITION_CODE", "type": "esriFieldTypeString", "alias": "Corbel Condition", "length": 50, "domain": { "type": "codedValue", "name": "ssInpsectMHCondition_2", "description": "", "codedValues": [ { "name": "Broken", "code": "BR" }, { "name": "Satisfactory", "code": "S" }, { "name": "Poor Fitting", "code": "PF" }, { "name": "Cracked", "code": "CR" }, { "name": "Silt/Debris Buildup", "code": "SD" }, { "name": "Sulfide Corrosion", "code": "SC" }, { "name": "Mineral Deposits", "code": "MD" }, { "name": "Heavy Deterioration", "code": "HD" }, { "name": "Roots", "code": "R" }, { "name": "Material Missing", "code": "MM" }, { "name": "Misaligned", "code": "MIS" }, { "name": "Bad Pipe Connection", "code": "BC" }, { "name": "Light Deterioration", "code": "LD" }, { "name": "Other (see comments)", "code": "OTH" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CORBEL_REPAIR_CODE", "type": "esriFieldTypeString", "alias": "Corbel Repair", "length": 50, "domain": { "type": "codedValue", "name": "ssInpsectMHRepair_2", "description": "", "codedValues": [ { "name": "No Action Required", "code": "NA" }, { "name": "Replace Frame & Cover", "code": "RFC" }, { "name": "Reset Extg. Frame & Cover", "code": "RS" }, { "name": "Rebuild Top/Replace F&C", "code": "RB" }, { "name": "Line Manhole", "code": "LM" }, { "name": "Add Riser Ring to F&C", "code": "RIS" }, { "name": "Install New Drop", "code": "ID" }, { "name": "Repair Channel", "code": "RCH" }, { "name": "Seal/Repoint", "code": "S" }, { "name": "Replace Manhole", "code": "RPL" }, { "name": "Remove Roots", "code": "RR" }, { "name": "Other (see comments)", "code": "OTH" }, { "name": "Clean", "code": "CL" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CORBEL_PRIORITY_CODE", "type": "esriFieldTypeSmallInteger", "alias": "Corbel Priority", "domain": { "type": "codedValue", "name": "ssInpsectMHPriority_2", "description": "", "codedValues": [ { "name": "No Defect, No Rehab Required", "code": 1 }, { "name": "Light to moderate, Rehab and or Routine Maint is Probable", "code": 2 }, { "name": "Moderate to Medium, Rehab is Necessary, Mid-Term", "code": 3 }, { "name": "Medium to Severe, Rehab is Urgent, Short Term", "code": 4 }, { "name": "Severe, Rehab is Emergency, Immediate", "code": 5 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CORBEL_COMMENTS", "type": "esriFieldTypeString", "alias": "Corbel Comments", "length": 255, "domain": null }, { "name": "CHIMNEY_MTRL_CODE", "type": "esriFieldTypeString", "alias": "Chimney Material", "length": 503, "domain": { "type": "codedValue", "name": "ssInpsectMHMaterial_2", "description": "", "codedValues": [ { "name": "Brick (hand-laid)", "code": "BRK" }, { "name": "Cement Block", "code": "BLK" }, { "name": "Cast Iron", "code": "CI" }, { "name": "Precast Concrete", "code": "PC" }, { "name": "Other (see comments)", "code": "OTH" }, { "name": "Cement", "code": "CEM" }, { "name": "VC Pipe Section", "code": "VC" }, { "name": "Cobblestone", "code": "CBLS" }, { "name": "Ductile Iron", "code": "DI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CHIMNEY_INFIL_CODE", "type": "esriFieldTypeString", "alias": "Chimney Infiltration", "length": 50, "domain": { "type": "codedValue", "name": "ssInpsectMHInfiltration_2", "description": "", "codedValues": [ { "name": "No Evidence", "code": "NE" }, { "name": "Evidence of Infiltration", "code": "EI" }, { "name": "Active Infiltration", "code": "AI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CHIMNEY_CONDITION_CODE", "type": "esriFieldTypeString", "alias": "Chimney Condition", "length": 50, "domain": { "type": "codedValue", "name": "ssInpsectMHCondition_2", "description": "", "codedValues": [ { "name": "Broken", "code": "BR" }, { "name": "Satisfactory", "code": "S" }, { "name": "Poor Fitting", "code": "PF" }, { "name": "Cracked", "code": "CR" }, { "name": "Silt/Debris Buildup", "code": "SD" }, { "name": "Sulfide Corrosion", "code": "SC" }, { "name": "Mineral Deposits", "code": "MD" }, { "name": "Heavy Deterioration", "code": "HD" }, { "name": "Roots", "code": "R" }, { "name": "Material Missing", "code": "MM" }, { "name": "Misaligned", "code": "MIS" }, { "name": "Bad Pipe Connection", "code": "BC" }, { "name": "Light Deterioration", "code": "LD" }, { "name": "Other (see comments)", "code": "OTH" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CHIMNEY_REPAIR_CODE", "type": "esriFieldTypeString", "alias": "Chimney Repair", "length": 50, "domain": { "type": "codedValue", "name": "ssInpsectMHRepair_2", "description": "", "codedValues": [ { "name": "No Action Required", "code": "NA" }, { "name": "Replace Frame & Cover", "code": "RFC" }, { "name": "Reset Extg. Frame & Cover", "code": "RS" }, { "name": "Rebuild Top/Replace F&C", "code": "RB" }, { "name": "Line Manhole", "code": "LM" }, { "name": "Add Riser Ring to F&C", "code": "RIS" }, { "name": "Install New Drop", "code": "ID" }, { "name": "Repair Channel", "code": "RCH" }, { "name": "Seal/Repoint", "code": "S" }, { "name": "Replace Manhole", "code": "RPL" }, { "name": "Remove Roots", "code": "RR" }, { "name": "Other (see comments)", "code": "OTH" }, { "name": "Clean", "code": "CL" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CHIMNEY_PRIORITY_CODE", "type": "esriFieldTypeSmallInteger", "alias": "Chimney Priority", "domain": { "type": "codedValue", "name": "ssInpsectMHPriority_2", "description": "", "codedValues": [ { "name": "No Defect, No Rehab Required", "code": 1 }, { "name": "Light to moderate, Rehab and or Routine Maint is Probable", "code": 2 }, { "name": "Moderate to Medium, Rehab is Necessary, Mid-Term", "code": 3 }, { "name": "Medium to Severe, Rehab is Urgent, Short Term", "code": 4 }, { "name": "Severe, Rehab is Emergency, Immediate", "code": 5 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CHIMNEY_COMMENTS", "type": "esriFieldTypeString", "alias": "Chimney Comments", "length": 50, "domain": null }, { "name": "WALLS_MTRL_CODE", "type": "esriFieldTypeString", "alias": "Walls Material", "length": 50, "domain": { "type": "codedValue", "name": "ssInpsectMHMaterial_2", "description": "", "codedValues": [ { "name": "Brick (hand-laid)", "code": "BRK" }, { "name": "Cement Block", "code": "BLK" }, { "name": "Cast Iron", "code": "CI" }, { "name": "Precast Concrete", "code": "PC" }, { "name": "Other (see comments)", "code": "OTH" }, { "name": "Cement", "code": "CEM" }, { "name": "VC Pipe Section", "code": "VC" }, { "name": "Cobblestone", "code": "CBLS" }, { "name": "Ductile Iron", "code": "DI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "WALLS_INFIL_CODE", "type": "esriFieldTypeString", "alias": "Walls Infiltration", "length": 50, "domain": { "type": "codedValue", "name": "ssInpsectMHInfiltration_2", "description": "", "codedValues": [ { "name": "No Evidence", "code": "NE" }, { "name": "Evidence of Infiltration", "code": "EI" }, { "name": "Active Infiltration", "code": "AI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "WALLS_CONDITION_CODE", "type": "esriFieldTypeString", "alias": "Walls Condition", "length": 50, "domain": { "type": "codedValue", "name": "ssInpsectMHCondition_2", "description": "", "codedValues": [ { "name": "Broken", "code": "BR" }, { "name": "Satisfactory", "code": "S" }, { "name": "Poor Fitting", "code": "PF" }, { "name": "Cracked", "code": "CR" }, { "name": "Silt/Debris Buildup", "code": "SD" }, { "name": "Sulfide Corrosion", "code": "SC" }, { "name": "Mineral Deposits", "code": "MD" }, { "name": "Heavy Deterioration", "code": "HD" }, { "name": "Roots", "code": "R" }, { "name": "Material Missing", "code": "MM" }, { "name": "Misaligned", "code": "MIS" }, { "name": "Bad Pipe Connection", "code": "BC" }, { "name": "Light Deterioration", "code": "LD" }, { "name": "Other (see comments)", "code": "OTH" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "WALLS_REPAIR_CODE", "type": "esriFieldTypeString", "alias": "Walls Repair", "length": 50, "domain": { "type": "codedValue", "name": "ssInpsectMHRepair_2", "description": "", "codedValues": [ { "name": "No Action Required", "code": "NA" }, { "name": "Replace Frame & Cover", "code": "RFC" }, { "name": "Reset Extg. Frame & Cover", "code": "RS" }, { "name": "Rebuild Top/Replace F&C", "code": "RB" }, { "name": "Line Manhole", "code": "LM" }, { "name": "Add Riser Ring to F&C", "code": "RIS" }, { "name": "Install New Drop", "code": "ID" }, { "name": "Repair Channel", "code": "RCH" }, { "name": "Seal/Repoint", "code": "S" }, { "name": "Replace Manhole", "code": "RPL" }, { "name": "Remove Roots", "code": "RR" }, { "name": "Other (see comments)", "code": "OTH" }, { "name": "Clean", "code": "CL" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "WALLS_PRIORITY_CODE", "type": "esriFieldTypeSmallInteger", "alias": "Walls Priority", "domain": { "type": "codedValue", "name": "ssInpsectMHPriority_2", "description": "", "codedValues": [ { "name": "No Defect, No Rehab Required", "code": 1 }, { "name": "Light to moderate, Rehab and or Routine Maint is Probable", "code": 2 }, { "name": "Moderate to Medium, Rehab is Necessary, Mid-Term", "code": 3 }, { "name": "Medium to Severe, Rehab is Urgent, Short Term", "code": 4 }, { "name": "Severe, Rehab is Emergency, Immediate", "code": 5 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "WALLS_COMMENTS", "type": "esriFieldTypeString", "alias": "Walls Comments", "length": 50, "domain": null }, { "name": "RUNG_MTRL_CODE", "type": "esriFieldTypeString", "alias": "Rung Material", "length": 50, "domain": { "type": "codedValue", "name": "ssInpsectMHMaterial_2", "description": "", "codedValues": [ { "name": "Brick (hand-laid)", "code": "BRK" }, { "name": "Cement Block", "code": "BLK" }, { "name": "Cast Iron", "code": "CI" }, { "name": "Precast Concrete", "code": "PC" }, { "name": "Other (see comments)", "code": "OTH" }, { "name": "Cement", "code": "CEM" }, { "name": "VC Pipe Section", "code": "VC" }, { "name": "Cobblestone", "code": "CBLS" }, { "name": "Ductile Iron", "code": "DI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RUNG_CONDITION_CODE", "type": "esriFieldTypeString", "alias": "Rung Condition", "length": 50, "domain": { "type": "codedValue", "name": "ssInpsectMHCondition_2", "description": "", "codedValues": [ { "name": "Broken", "code": "BR" }, { "name": "Satisfactory", "code": "S" }, { "name": "Poor Fitting", "code": "PF" }, { "name": "Cracked", "code": "CR" }, { "name": "Silt/Debris Buildup", "code": "SD" }, { "name": "Sulfide Corrosion", "code": "SC" }, { "name": "Mineral Deposits", "code": "MD" }, { "name": "Heavy Deterioration", "code": "HD" }, { "name": "Roots", "code": "R" }, { "name": "Material Missing", "code": "MM" }, { "name": "Misaligned", "code": "MIS" }, { "name": "Bad Pipe Connection", "code": "BC" }, { "name": "Light Deterioration", "code": "LD" }, { "name": "Other (see comments)", "code": "OTH" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "TABLE_MTRL_CODE", "type": "esriFieldTypeString", "alias": "Table Material", "length": 50, "domain": { "type": "codedValue", "name": "ssInpsectMHMaterial_2", "description": "", "codedValues": [ { "name": "Brick (hand-laid)", "code": "BRK" }, { "name": "Cement Block", "code": "BLK" }, { "name": "Cast Iron", "code": "CI" }, { "name": "Precast Concrete", "code": "PC" }, { "name": "Other (see comments)", "code": "OTH" }, { "name": "Cement", "code": "CEM" }, { "name": "VC Pipe Section", "code": "VC" }, { "name": "Cobblestone", "code": "CBLS" }, { "name": "Ductile Iron", "code": "DI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "TABLE_INFIL_CODE", "type": "esriFieldTypeString", "alias": "Table Infiltration", "length": 50, "domain": { "type": "codedValue", "name": "ssInpsectMHInfiltration_2", "description": "", "codedValues": [ { "name": "No Evidence", "code": "NE" }, { "name": "Evidence of Infiltration", "code": "EI" }, { "name": "Active Infiltration", "code": "AI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "TABLE_CONDITION_CODE", "type": "esriFieldTypeString", "alias": "Table Condition", "length": 50, "domain": { "type": "codedValue", "name": "ssInpsectMHCondition_2", "description": "", "codedValues": [ { "name": "Broken", "code": "BR" }, { "name": "Satisfactory", "code": "S" }, { "name": "Poor Fitting", "code": "PF" }, { "name": "Cracked", "code": "CR" }, { "name": "Silt/Debris Buildup", "code": "SD" }, { "name": "Sulfide Corrosion", "code": "SC" }, { "name": "Mineral Deposits", "code": "MD" }, { "name": "Heavy Deterioration", "code": "HD" }, { "name": "Roots", "code": "R" }, { "name": "Material Missing", "code": "MM" }, { "name": "Misaligned", "code": "MIS" }, { "name": "Bad Pipe Connection", "code": "BC" }, { "name": "Light Deterioration", "code": "LD" }, { "name": "Other (see comments)", "code": "OTH" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "TABLE_REPAIR_CODE", "type": "esriFieldTypeString", "alias": "Table Repair", "length": 50, "domain": { "type": "codedValue", "name": "ssInpsectMHRepair_2", "description": "", "codedValues": [ { "name": "No Action Required", "code": "NA" }, { "name": "Replace Frame & Cover", "code": "RFC" }, { "name": "Reset Extg. Frame & Cover", "code": "RS" }, { "name": "Rebuild Top/Replace F&C", "code": "RB" }, { "name": "Line Manhole", "code": "LM" }, { "name": "Add Riser Ring to F&C", "code": "RIS" }, { "name": "Install New Drop", "code": "ID" }, { "name": "Repair Channel", "code": "RCH" }, { "name": "Seal/Repoint", "code": "S" }, { "name": "Replace Manhole", "code": "RPL" }, { "name": "Remove Roots", "code": "RR" }, { "name": "Other (see comments)", "code": "OTH" }, { "name": "Clean", "code": "CL" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "TABLE_PRIORITY_CODE", "type": "esriFieldTypeSmallInteger", "alias": "Table Priority", "domain": { "type": "codedValue", "name": "ssInpsectMHPriority_2", "description": "", "codedValues": [ { "name": "No Defect, No Rehab Required", "code": 1 }, { "name": "Light to moderate, Rehab and or Routine Maint is Probable", "code": 2 }, { "name": "Moderate to Medium, Rehab is Necessary, Mid-Term", "code": 3 }, { "name": "Medium to Severe, Rehab is Urgent, Short Term", "code": 4 }, { "name": "Severe, Rehab is Emergency, Immediate", "code": 5 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "TABLE_COMMENTS", "type": "esriFieldTypeString", "alias": "Table Comments", "length": 50, "domain": null }, { "name": "CHANNEL_MTRL_CODE", "type": "esriFieldTypeString", "alias": "Channel Material", "length": 50, "domain": { "type": "codedValue", "name": "ssInpsectMHMaterial_2", "description": "", "codedValues": [ { "name": "Brick (hand-laid)", "code": "BRK" }, { "name": "Cement Block", "code": "BLK" }, { "name": "Cast Iron", "code": "CI" }, { "name": "Precast Concrete", "code": "PC" }, { "name": "Other (see comments)", "code": "OTH" }, { "name": "Cement", "code": "CEM" }, { "name": "VC Pipe Section", "code": "VC" }, { "name": "Cobblestone", "code": "CBLS" }, { "name": "Ductile Iron", "code": "DI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CHANNEL_INFIL_CODE", "type": "esriFieldTypeString", "alias": "Channel Infiltration", "length": 50, "domain": { "type": "codedValue", "name": "ssInpsectMHInfiltration_2", "description": "", "codedValues": [ { "name": "No Evidence", "code": "NE" }, { "name": "Evidence of Infiltration", "code": "EI" }, { "name": "Active Infiltration", "code": "AI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CHANNEL_CONDITION_CODE", "type": "esriFieldTypeString", "alias": "Channel Condition", "length": 50, "domain": { "type": "codedValue", "name": "ssInpsectMHCondition_2", "description": "", "codedValues": [ { "name": "Broken", "code": "BR" }, { "name": "Satisfactory", "code": "S" }, { "name": "Poor Fitting", "code": "PF" }, { "name": "Cracked", "code": "CR" }, { "name": "Silt/Debris Buildup", "code": "SD" }, { "name": "Sulfide Corrosion", "code": "SC" }, { "name": "Mineral Deposits", "code": "MD" }, { "name": "Heavy Deterioration", "code": "HD" }, { "name": "Roots", "code": "R" }, { "name": "Material Missing", "code": "MM" }, { "name": "Misaligned", "code": "MIS" }, { "name": "Bad Pipe Connection", "code": "BC" }, { "name": "Light Deterioration", "code": "LD" }, { "name": "Other (see comments)", "code": "OTH" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CHANNEL_REPAIR_CODE", "type": "esriFieldTypeString", "alias": "Channel Repair", "length": 50, "domain": { "type": "codedValue", "name": "ssInpsectMHRepair_2", "description": "", "codedValues": [ { "name": "No Action Required", "code": "NA" }, { "name": "Replace Frame & Cover", "code": "RFC" }, { "name": "Reset Extg. Frame & Cover", "code": "RS" }, { "name": "Rebuild Top/Replace F&C", "code": "RB" }, { "name": "Line Manhole", "code": "LM" }, { "name": "Add Riser Ring to F&C", "code": "RIS" }, { "name": "Install New Drop", "code": "ID" }, { "name": "Repair Channel", "code": "RCH" }, { "name": "Seal/Repoint", "code": "S" }, { "name": "Replace Manhole", "code": "RPL" }, { "name": "Remove Roots", "code": "RR" }, { "name": "Other (see comments)", "code": "OTH" }, { "name": "Clean", "code": "CL" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CHANNEL_PRIORITY_CODE", "type": "esriFieldTypeSmallInteger", "alias": "Channel Priority", "domain": { "type": "codedValue", "name": "ssInpsectMHPriority_2", "description": "", "codedValues": [ { "name": "No Defect, No Rehab Required", "code": 1 }, { "name": "Light to moderate, Rehab and or Routine Maint is Probable", "code": 2 }, { "name": "Moderate to Medium, Rehab is Necessary, Mid-Term", "code": 3 }, { "name": "Medium to Severe, Rehab is Urgent, Short Term", "code": 4 }, { "name": "Severe, Rehab is Emergency, Immediate", "code": 5 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CHANNEL_COMMENTS", "type": "esriFieldTypeString", "alias": "Channel Comments", "length": 50, "domain": null }, { "name": "FRAME_COVER_MTRL_CODE", "type": "esriFieldTypeString", "alias": "Frame & Cover Material", "length": 50, "domain": { "type": "codedValue", "name": "ssInpsectMHMaterial_2", "description": "", "codedValues": [ { "name": "Brick (hand-laid)", "code": "BRK" }, { "name": "Cement Block", "code": "BLK" }, { "name": "Cast Iron", "code": "CI" }, { "name": "Precast Concrete", "code": "PC" }, { "name": "Other (see comments)", "code": "OTH" }, { "name": "Cement", "code": "CEM" }, { "name": "VC Pipe Section", "code": "VC" }, { "name": "Cobblestone", "code": "CBLS" }, { "name": "Ductile Iron", "code": "DI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FRAME_COVER_INFIL_CODE", "type": "esriFieldTypeString", "alias": "Frame & Cover Infiltration", "length": 50, "domain": { "type": "codedValue", "name": "ssInpsectMHInfiltration_2", "description": "", "codedValues": [ { "name": "No Evidence", "code": "NE" }, { "name": "Evidence of Infiltration", "code": "EI" }, { "name": "Active Infiltration", "code": "AI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FRAME_COVER_CONDITION_CODE", "type": "esriFieldTypeString", "alias": "Frame & Cover Condition", "length": 50, "domain": { "type": "codedValue", "name": "ssInpsectMHCondition_2", "description": "", "codedValues": [ { "name": "Broken", "code": "BR" }, { "name": "Satisfactory", "code": "S" }, { "name": "Poor Fitting", "code": "PF" }, { "name": "Cracked", "code": "CR" }, { "name": "Silt/Debris Buildup", "code": "SD" }, { "name": "Sulfide Corrosion", "code": "SC" }, { "name": "Mineral Deposits", "code": "MD" }, { "name": "Heavy Deterioration", "code": "HD" }, { "name": "Roots", "code": "R" }, { "name": "Material Missing", "code": "MM" }, { "name": "Misaligned", "code": "MIS" }, { "name": "Bad Pipe Connection", "code": "BC" }, { "name": "Light Deterioration", "code": "LD" }, { "name": "Other (see comments)", "code": "OTH" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FRAME_COVER_REPAIR_CODE", "type": "esriFieldTypeString", "alias": "Frame & Cover Repair", "length": 50, "domain": { "type": "codedValue", "name": "ssInpsectMHRepair_2", "description": "", "codedValues": [ { "name": "No Action Required", "code": "NA" }, { "name": "Replace Frame & Cover", "code": "RFC" }, { "name": "Reset Extg. Frame & Cover", "code": "RS" }, { "name": "Rebuild Top/Replace F&C", "code": "RB" }, { "name": "Line Manhole", "code": "LM" }, { "name": "Add Riser Ring to F&C", "code": "RIS" }, { "name": "Install New Drop", "code": "ID" }, { "name": "Repair Channel", "code": "RCH" }, { "name": "Seal/Repoint", "code": "S" }, { "name": "Replace Manhole", "code": "RPL" }, { "name": "Remove Roots", "code": "RR" }, { "name": "Other (see comments)", "code": "OTH" }, { "name": "Clean", "code": "CL" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FRAME_COVER_PRIORITY_CODE", "type": "esriFieldTypeSmallInteger", "alias": "Frame & Cover Priority", "domain": { "type": "codedValue", "name": "ssInpsectMHPriority_2", "description": "", "codedValues": [ { "name": "No Defect, No Rehab Required", "code": 1 }, { "name": "Light to moderate, Rehab and or Routine Maint is Probable", "code": 2 }, { "name": "Moderate to Medium, Rehab is Necessary, Mid-Term", "code": 3 }, { "name": "Medium to Severe, Rehab is Urgent, Short Term", "code": 4 }, { "name": "Severe, Rehab is Emergency, Immediate", "code": 5 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FRAME_COVER_COMMENTS", "type": "esriFieldTypeString", "alias": "Frame & Cover Comments", "length": 50, "domain": null }, { "name": "GENERAL_COMMENTS", "type": "esriFieldTypeString", "alias": "General Comments", "length": 255, "domain": null }, { "name": "GENERAL_MH_CONDITION", "type": "esriFieldTypeString", "alias": "General MH Condition", "length": 50, "domain": { "type": "codedValue", "name": "ssInpsectMHCondition_2", "description": "", "codedValues": [ { "name": "Broken", "code": "BR" }, { "name": "Satisfactory", "code": "S" }, { "name": "Poor Fitting", "code": "PF" }, { "name": "Cracked", "code": "CR" }, { "name": "Silt/Debris Buildup", "code": "SD" }, { "name": "Sulfide Corrosion", "code": "SC" }, { "name": "Mineral Deposits", "code": "MD" }, { "name": "Heavy Deterioration", "code": "HD" }, { "name": "Roots", "code": "R" }, { "name": "Material Missing", "code": "MM" }, { "name": "Misaligned", "code": "MIS" }, { "name": "Bad Pipe Connection", "code": "BC" }, { "name": "Light Deterioration", "code": "LD" }, { "name": "Other (see comments)", "code": "OTH" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "CreationDate", "type": "esriFieldTypeDate", "alias": "CreationDate", "length": 8, "domain": null }, { "name": "Creator", "type": "esriFieldTypeString", "alias": "Creator", "length": 50, "domain": null }, { "name": "EditDate", "type": "esriFieldTypeDate", "alias": "EditDate", "length": 8, "domain": null }, { "name": "Editor", "type": "esriFieldTypeString", "alias": "Editor", "length": 50, "domain": null }, { "name": "Lined", "type": "esriFieldTypeString", "alias": "Lined", "length": 10, "domain": null }, { "name": "RUNG_COMMENT", "type": "esriFieldTypeString", "alias": "Rung Comment", "length": 256, "domain": null }, { "name": "RelGUID", "type": "esriFieldTypeGUID", "alias": "RelGUID", "length": 38, "domain": null } ], "indexes": [ { "name": "R15_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_15", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G50FACILITYID", "fields": "FACILITYID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_15", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "DBO.Sewer_Manholes", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "FACILITYID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{71D5ABAD-18AE-4E35-9F26-8D892C4207C4}" } ], "capabilities": "Query,Map,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 } }