{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 15, "name": "Manhole Inspection", "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": 10, "domain": null }, { "name": "STARTDATETIME", "type": "esriFieldTypeDate", "alias": "Start Date Time", "length": 8, "domain": null }, { "name": "WORKKEY", "type": "esriFieldTypeString", "alias": "Work Order #", "length": 50, "domain": null }, { "name": "PURPOSE", "type": "esriFieldTypeString", "alias": "Purpose of Inspection", "length": 50, "domain": { "type": "codedValue", "name": "WS1_NASSCO_Purposes", "description": "", "codedValues": [ { "name": "Inflitration/Inflow Investigation", "code": "Inflitration/Inflow Investigation" }, { "name": "Post Rehabilitation Survey", "code": "Post Rehabilitation Survey" }, { "name": "Pre-Rehabilitation Survey", "code": "Pre-Rehabilitation Survey" }, { "name": "Pre-Acceptance", "code": "Pre-Acceptance" }, { "name": "Routine Assessment", "code": "Routine Assessment" }, { "name": "Capital Improvement Program Assessment", "code": "Capital Improvement Program Assessment" }, { "name": "Re-Inspection", "code": "Re-Inspection" }, { "name": "Not Known", "code": "Not Known" }, { "name": "Maintenance Related", "code": "Maintenance Related" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GROUNDCONDITION", "type": "esriFieldTypeString", "alias": "Ground Condition", "length": 10, "domain": { "type": "codedValue", "name": "WS1_NASSCO_Weather", "description": "", "codedValues": [ { "name": "Damp", "code": "Damp" }, { "name": "Dry", "code": "Dry" }, { "name": "Heavy Rain", "code": "Heavy Rain" }, { "name": "Light Rain", "code": "Light Rain" }, { "name": "Saturated", "code": "Saturated" }, { "name": "Very Dry", "code": "Very Dry" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MANHOLELOCATION", "type": "esriFieldTypeString", "alias": "Manhole Location", "length": 50, "domain": { "type": "codedValue", "name": "WS1_NASSCO_Manlocation", "description": "", "codedValues": [ { "name": "Main Highway - Urban", "code": "Main Highway - Urban" }, { "name": "Main Highway - Suburban/Rural", "code": "Main Highway - Suburban/Rural" }, { "name": "Light Highway", "code": "Light Highway" }, { "name": "Easement/Right of Way", "code": "Easement/Right of Way" }, { "name": "Woods", "code": "Woods" }, { "name": "Sidewalk", "code": "Sidewalk" }, { "name": "Driveway", "code": "Driveway" }, { "name": "Parking Lot", "code": "Parking Lot" }, { "name": "Alley", "code": "Alley" }, { "name": "Ditch", "code": "Ditch" }, { "name": "Building", "code": "Building" }, { "name": "Creek", "code": "Creek" }, { "name": "Railway", "code": "Railway" }, { "name": "Airport", "code": "Airport" }, { "name": "Yard", "code": "Yard" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SURFACETYPE", "type": "esriFieldTypeString", "alias": "Surface Type", "length": 50, "domain": { "type": "codedValue", "name": "WS1_NASSCO_ManholeSurfaceType", "description": "", "codedValues": [ { "name": "Asphalt", "code": "Asphalt" }, { "name": "Concrete Collar", "code": "Concrete Collar" }, { "name": "Grass/Dirt", "code": "Grass/Dirt" }, { "name": "Gravel", "code": "Gravel" }, { "name": "Brick", "code": "Brick" }, { "name": "Concrete Pavement", "code": "Concrete Pavement" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RUNOFF", "type": "esriFieldTypeString", "alias": "Potential for Runoff", "length": 50, "domain": { "type": "codedValue", "name": "WS1_MACP_Potential_Runoff", "description": "", "codedValues": [ { "name": "Inundated", "code": "Inundated" }, { "name": "None", "code": "None" }, { "name": "Ponding", "code": "Ponding" }, { "name": "Sheeting", "code": "Sheeting" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "INSSTATUS", "type": "esriFieldTypeString", "alias": "Inspection Status", "length": 50, "domain": { "type": "codedValue", "name": "WS1_MACP_Inspection_Status", "description": "", "codedValues": [ { "name": "Buried or Marked", "code": "Buried or Marked" }, { "name": "In Traffic", "code": "In Traffic" }, { "name": "No Access No Found", "code": "No Access No Found" }, { "name": "Not Opened", "code": "Not Opened" }, { "name": "Remote Inspection", "code": "Remote Inspection" }, { "name": "Surchared/Debris", "code": "Surchared/Debris" }, { "name": "Surface Inspection", "code": "Surface Inspection" }, { "name": "Descent Inspection", "code": "Descent Inspection" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MHSURFALIGN", "type": "esriFieldTypeString", "alias": "Manhole Even with Surface", "length": 50, "domain": { "type": "codedValue", "name": "WS1_ssManholeAlignment", "description": "", "codedValues": [ { "name": "Even", "code": "Even" }, { "name": "Above", "code": "Above" }, { "name": "Below", "code": "Below" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MHHEIGHT", "type": "esriFieldTypeDouble", "alias": "Inches Above or Below", "domain": null }, { "name": "COVERTYPE", "type": "esriFieldTypeString", "alias": "Cover Type", "length": 50, "domain": { "type": "codedValue", "name": "WS1_NASSCO_CoverType", "description": "", "codedValues": [ { "name": "Double Cover", "code": "Double Cover" }, { "name": "Lamp", "code": "Lamp" }, { "name": "Mascotte", "code": "Mascotte" }, { "name": "Oversized", "code": "Oversized" }, { "name": "Standard", "code": "Standard" }, { "name": "Other", "code": "Other" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "COVERSIZE", "type": "esriFieldTypeString", "alias": "Cover Size", "length": 5, "domain": null }, { "name": "COVERFIT", "type": "esriFieldTypeString", "alias": "Cover Rim Fit", "length": 50, "domain": { "type": "codedValue", "name": "WS1_MACP_Cover_Frame_Fit", "description": "", "codedValues": [ { "name": "Good", "code": "Good" }, { "name": "Oversized", "code": "Oversized" }, { "name": "Rocks/Wobbles", "code": "Rocks/Wobbles" }, { "name": "Undersized", "code": "Undersized" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "COVERCOND", "type": "esriFieldTypeString", "alias": "Cover Condition", "length": 50, "domain": { "type": "codedValue", "name": "WS1_NASSCO_CoverCondition", "description": "", "codedValues": [ { "name": "Sound", "code": "Sound" }, { "name": "Cracked", "code": "Cracked" }, { "name": "Broken", "code": "Broken" }, { "name": "Missing", "code": "Missing" }, { "name": "Corroded/Pitted", "code": "Corroded/Pitted" }, { "name": "Bolts Missing", "code": "Bolts Missing" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "INVERTRIMDIST", "type": "esriFieldTypeString", "alias": "Invert Rim Distance (Feet to Nearest Tenth)", "length": 30, "domain": null }, { "name": "COVERCOND2", "type": "esriFieldTypeString", "alias": "Additional Cover Conditions", "length": 50, "domain": null }, { "name": "INSERTTYPE", "type": "esriFieldTypeString", "alias": "Rain Dish Identifier", "length": 50, "domain": { "type": "codedValue", "name": "WS1_NASSCO_InsertType", "description": "", "codedValues": [ { "name": "None", "code": "None" }, { "name": "Metal", "code": "Metal" }, { "name": "Other", "code": "Other" }, { "name": "Plastic", "code": "Plastic" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "INSERTCOND", "type": "esriFieldTypeString", "alias": "Insert Conditions", "length": 50, "domain": { "type": "codedValue", "name": "WS1_NASSCO_InsertCondition", "description": "", "codedValues": [ { "name": "None", "code": "None" }, { "name": "Sound", "code": "Sound" }, { "name": "Poorly Fitted", "code": "Poorly Fitted" }, { "name": "Cracked/Torn/Holes", "code": "Cracked/Torn/Holes" }, { "name": "Leaking", "code": "Leaking" }, { "name": "Insert Fell", "code": "Insert Fell" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "INSERTCOND2", "type": "esriFieldTypeString", "alias": "Additional Insert Conditions", "length": 50, "domain": null }, { "name": "SURCHARGE", "type": "esriFieldTypeString", "alias": "Evidence of Surcharge", "length": 5, "domain": { "type": "codedValue", "name": "WS1_YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SURCHARGEHEIGHT", "type": "esriFieldTypeString", "alias": "Height Surcharge from Invert", "length": 50, "domain": null }, { "name": "FRAMEADJ", "type": "esriFieldTypeString", "alias": "Adjustment Ring Type", "length": 50, "domain": { "type": "codedValue", "name": "WS1_NASSCO_FrameAdjustmentType", "description": "", "codedValues": [ { "name": "No Value", "code": "No Value" }, { "name": "Adjustable", "code": "Adjustable" }, { "name": "Solid", "code": "Solid" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ADJRINGCOND", "type": "esriFieldTypeString", "alias": "Adjustment Ring Condition", "length": 50, "domain": { "type": "codedValue", "name": "WS1_NASSCO_AdjustmentRingCondition", "description": "", "codedValues": [ { "name": "N/A", "code": "N/A" }, { "name": "Broken", "code": "Broken" }, { "name": "Corroded/Pitted/Worn", "code": "Corroded/Pitted/Worn" }, { "name": "Cracked", "code": "Cracked" }, { "name": "Poor Installation", "code": "Poor Installation" }, { "name": "Sound", "code": "Sound" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ADJRINGCOND2", "type": "esriFieldTypeString", "alias": "Additional Ring Conditions", "length": 50, "domain": null }, { "name": "FRAMETYPE", "type": "esriFieldTypeString", "alias": "Frame Material", "length": 50, "domain": { "type": "codedValue", "name": "WS1_NASSCO_Materials", "description": "", "codedValues": [ { "name": "Cast Iron", "code": "Cast Iron" }, { "name": "Ductile Iron", "code": "Ductile Iron" }, { "name": "Plastic/Steel Composite", "code": "Plastic/Steel Composite" }, { "name": "Other", "code": "Other" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Steel", "code": "Steel" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FRAMECOND", "type": "esriFieldTypeString", "alias": "Frame Condition", "length": 50, "domain": { "type": "codedValue", "name": "WS1_NASSCO_FrameCondition", "description": "", "codedValues": [ { "name": "Sound", "code": "Sound" }, { "name": "Cracked", "code": "Cracked" }, { "name": "Broken", "code": "Broken" }, { "name": "Missing", "code": "Missing" }, { "name": "Corroded/Pitted/Worn", "code": "Corroded/Pitted/Worn" }, { "name": "Coated", "code": "Coated" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FRAMECOND2", "type": "esriFieldTypeString", "alias": "Additional Frame Conditions", "length": 50, "domain": null }, { "name": "FRAMESEALCOND", "type": "esriFieldTypeString", "alias": "Frame to Manhole Seal", "length": 50, "domain": { "type": "codedValue", "name": "WS1_NASSCO_FrameSealCondition", "description": "", "codedValues": [ { "name": "Sound", "code": "Sound" }, { "name": "Cracked", "code": "Cracked" }, { "name": "Loose/Not Attached", "code": "Loose/Not Attached" }, { "name": "Offset", "code": "Offset" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FRAMEOFFSET", "type": "esriFieldTypeDouble", "alias": "Frame Offset", "domain": null }, { "name": "FRAMESEALCOND2", "type": "esriFieldTypeString", "alias": "Additional Seal Conditions", "length": 50, "domain": null }, { "name": "SEALINFLOW", "type": "esriFieldTypeString", "alias": "Frame Seal Inflow", "length": 50, "domain": { "type": "codedValue", "name": "WS1_MACP_Inflow_Infiltration", "description": "", "codedValues": [ { "name": "None", "code": "None" }, { "name": "Infil Stained", "code": "Infil Stained" }, { "name": "Infil Weeper", "code": "Infil Weeper" }, { "name": "Infil Dripper", "code": "Infil Dripper" }, { "name": "Infil Runner", "code": "Infil Runner" }, { "name": "Infil Gusher", "code": "Infil Gusher" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CHIMNEYTYPE", "type": "esriFieldTypeString", "alias": "Chimney Material", "length": 50, "domain": { "type": "codedValue", "name": "WS1_NASSCO_ChimneyMaterial", "description": "", "codedValues": [ { "name": "None", "code": "None" }, { "name": "Brick", "code": "Brick" }, { "name": "Cast Iron", "code": "Cast Iron" }, { "name": "Concrete Pipe (non-reinforced)", "code": "Concrete Pipe (non-reinforced)" }, { "name": "Concrete Ring", "code": "Concrete Ring" }, { "name": "Ductile Iron Pipe", "code": "Ductile Iron Pipe" }, { "name": "Fiberglass Reinforced Pipe", "code": "Fiberglass Reinforced Pipe" }, { "name": "Glass Reinforced Cement", "code": "Glass Reinforced Cement" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CHIMNEYLINETYPE", "type": "esriFieldTypeString", "alias": "Chimney Lining Material", "length": 50, "domain": { "type": "codedValue", "name": "WS1_MACP_Linings", "description": "", "codedValues": [ { "name": "Bitumastic", "code": "Bitumastic" }, { "name": "Cementitious", "code": "Cementitious" }, { "name": "Cured in Place", "code": "Cured in Place" }, { "name": "Epoxy", "code": "Epoxy" }, { "name": "Fiberglass", "code": "Fiberglass" }, { "name": "None - No Coating", "code": "None - No Coating" }, { "name": "Plastic", "code": "Plastic" }, { "name": "Polymer", "code": "Polymer" }, { "name": "Rubber", "code": "Rubber" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CHIMNEYCOND", "type": "esriFieldTypeString", "alias": "Chimney Condition", "length": 50, "domain": { "type": "codedValue", "name": "WS1_NASSCO_ChimneyCondition", "description": "", "codedValues": [ { "name": "No Defects Observed", "code": "No Defects Observed" }, { "name": "Crack", "code": "Crack" }, { "name": "Fracture", "code": "Fracture" }, { "name": "Hole", "code": "Hole" }, { "name": "Brick - mortar missing", "code": "Brick - mortar missing" }, { "name": "Brick - displaced", "code": "Brick - displaced" }, { "name": "Brick - missing", "code": "Brick - missing" }, { "name": "Surface Damage - deterioration", "code": "Surface Damage - deterioration" }, { "name": "Surface Damage - rebar showing", "code": "Surface Damage - rebar showing" }, { "name": "Surface Damage - missing wall", "code": "Surface Damage - missing wall" }, { "name": "Liner/Coating - peeling/bulging", "code": "Liner/Coating - peeling/bulging" }, { "name": "Liner/Coating - detached", "code": "Liner/Coating - detached" }, { "name": "Deposits - encrustation", "code": "Deposits - encrustation" }, { "name": "Deposits - grease", "code": "Deposits - grease" }, { "name": "Deposits - ragging", "code": "Deposits - ragging" }, { "name": "Roots - fine", "code": "Roots - fine" }, { "name": "Roots - medium", "code": "Roots - medium" }, { "name": "Roots - ball", "code": "Roots - ball" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CHIMNEYINFILTRATE", "type": "esriFieldTypeString", "alias": "Chimney Infiltration", "length": 50, "domain": { "type": "codedValue", "name": "WS1_MACP_Inflow_Infiltration", "description": "", "codedValues": [ { "name": "None", "code": "None" }, { "name": "Infil Stained", "code": "Infil Stained" }, { "name": "Infil Weeper", "code": "Infil Weeper" }, { "name": "Infil Dripper", "code": "Infil Dripper" }, { "name": "Infil Runner", "code": "Infil Runner" }, { "name": "Infil Gusher", "code": "Infil Gusher" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CONEMATERIAL", "type": "esriFieldTypeString", "alias": "Cone Material", "length": 50, "domain": { "type": "codedValue", "name": "WS1_NASSCO_ConeMaterial", "description": "", "codedValues": [ { "name": "None", "code": "None" }, { "name": "Brick", "code": "Brick" }, { "name": "Fiberglass Reinforced Pipe", "code": "Fiberglass Reinforced Pipe" }, { "name": "Glass Reinforced Pipe", "code": "Glass Reinforced Pipe" }, { "name": "Reinforced Concrete Pipe", "code": "Reinforced Concrete Pipe" }, { "name": "Segmented Block", "code": "Segmented Block" }, { "name": "Other", "code": "Other" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Brick/Concrete", "code": "Brick/Concrete" }, { "name": "Lined/Coating", "code": "Lined/Coating" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CONETYPE", "type": "esriFieldTypeString", "alias": "Cone Type", "length": 50, "domain": { "type": "codedValue", "name": "WS1_MACP_Cone_Types", "description": "", "codedValues": [ { "name": "None", "code": "None" }, { "name": "Conical Centered", "code": "Conical Centered" }, { "name": "Conical Off Centered", "code": "Conical Off Centered" }, { "name": "Flattop", "code": "Flattop" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CONELINETYPE", "type": "esriFieldTypeString", "alias": "Cone Lining Material", "length": 50, "domain": { "type": "codedValue", "name": "WS1_MACP_Linings", "description": "", "codedValues": [ { "name": "Bitumastic", "code": "Bitumastic" }, { "name": "Cementitious", "code": "Cementitious" }, { "name": "Cured in Place", "code": "Cured in Place" }, { "name": "Epoxy", "code": "Epoxy" }, { "name": "Fiberglass", "code": "Fiberglass" }, { "name": "None - No Coating", "code": "None - No Coating" }, { "name": "Plastic", "code": "Plastic" }, { "name": "Polymer", "code": "Polymer" }, { "name": "Rubber", "code": "Rubber" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CONECOND", "type": "esriFieldTypeString", "alias": "Cone Condition", "length": 50, "domain": { "type": "codedValue", "name": "WS1_NASSCO_ConeCondition", "description": "", "codedValues": [ { "name": "No Defects Observed", "code": "No Defects Observed" }, { "name": "Crack", "code": "Crack" }, { "name": "Fracture", "code": "Fracture" }, { "name": "Hole", "code": "Hole" }, { "name": "Brick - mortar missing", "code": "Brick - mortar missing" }, { "name": "Brick - displaced", "code": "Brick - displaced" }, { "name": "Brick - missing", "code": "Brick - missing" }, { "name": "Surface Damage - deterioration", "code": "Surface Damage - deterioration" }, { "name": "Surface Damage - rebar showing", "code": "Surface Damage - rebar showing" }, { "name": "Surface Damage - missing wall", "code": "Surface Damage - missing wall" }, { "name": "Liner/Coating - peeling/bulging", "code": "Liner/Coating - peeling/bulging" }, { "name": "Liner/Coating - detached", "code": "Liner/Coating - detached" }, { "name": "Deposits - encrustation", "code": "Deposits - encrustation" }, { "name": "Deposits - grease", "code": "Deposits - grease" }, { "name": "Deposits - ragging", "code": "Deposits - ragging" }, { "name": "Roots - fine", "code": "Roots - fine" }, { "name": "Roots - medium", "code": "Roots - medium" }, { "name": "Roots - ball", "code": "Roots - ball" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CONEINFILTRATE", "type": "esriFieldTypeString", "alias": "Cone Infiltration", "length": 50, "domain": { "type": "codedValue", "name": "WS1_MACP_Inflow_Infiltration", "description": "", "codedValues": [ { "name": "None", "code": "None" }, { "name": "Infil Stained", "code": "Infil Stained" }, { "name": "Infil Weeper", "code": "Infil Weeper" }, { "name": "Infil Dripper", "code": "Infil Dripper" }, { "name": "Infil Runner", "code": "Infil Runner" }, { "name": "Infil Gusher", "code": "Infil Gusher" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BARRELTYPE", "type": "esriFieldTypeString", "alias": "Wall Material", "length": 50, "domain": { "type": "codedValue", "name": "WS1_NASSCO_WallMaterial", "description": "", "codedValues": [ { "name": "Brick", "code": "Brick" }, { "name": "Fiberglass Reinforced Pipe", "code": "Fiberglass Reinforced Pipe" }, { "name": "Glass Reinforced Cement", "code": "Glass Reinforced Cement" }, { "name": "Reinforced Concrete Pipe", "code": "Reinforced Concrete Pipe" }, { "name": "Segmented Block", "code": "Segmented Block" }, { "name": "Other", "code": "Other" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Brick/Concrete", "code": "Brick/Concrete" }, { "name": "Lined/Coating", "code": "Lined/Coating" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BARRELLINETYPE", "type": "esriFieldTypeString", "alias": "Wall Lining Material", "length": 50, "domain": { "type": "codedValue", "name": "WS1_MACP_Linings", "description": "", "codedValues": [ { "name": "Bitumastic", "code": "Bitumastic" }, { "name": "Cementitious", "code": "Cementitious" }, { "name": "Cured in Place", "code": "Cured in Place" }, { "name": "Epoxy", "code": "Epoxy" }, { "name": "Fiberglass", "code": "Fiberglass" }, { "name": "None - No Coating", "code": "None - No Coating" }, { "name": "Plastic", "code": "Plastic" }, { "name": "Polymer", "code": "Polymer" }, { "name": "Rubber", "code": "Rubber" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BARRELCOND", "type": "esriFieldTypeString", "alias": "Wall Condition", "length": 50, "domain": { "type": "codedValue", "name": "WS1_NASSCO_WallCondition", "description": "", "codedValues": [ { "name": "No Defects Observed", "code": "No Defects Observed" }, { "name": "Crack", "code": "Crack" }, { "name": "Fracture", "code": "Fracture" }, { "name": "Hole", "code": "Hole" }, { "name": "Brick - mortar missing", "code": "Brick - mortar missing" }, { "name": "Brick - displaced", "code": "Brick - displaced" }, { "name": "Brick - missing", "code": "Brick - missing" }, { "name": "Surface Damage - deterioration", "code": "Surface Damage - deterioration" }, { "name": "Surface Damage - rebar showing", "code": "Surface Damage - rebar showing" }, { "name": "Surface Damage - missing wall", "code": "Surface Damage - missing wall" }, { "name": "Liner/Coating - peeling/bulging", "code": "Liner/Coating - peeling/bulging" }, { "name": "Liner/Coating - detached", "code": "Liner/Coating - detached" }, { "name": "Deposits - encrustation", "code": "Deposits - encrustation" }, { "name": "Deposits - grease", "code": "Deposits - grease" }, { "name": "Deposits - ragging", "code": "Deposits - ragging" }, { "name": "Roots - fine", "code": "Roots - fine" }, { "name": "Roots - medium", "code": "Roots - medium" }, { "name": "Roots - ball", "code": "Roots - ball" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BARRELINFILTRATE", "type": "esriFieldTypeString", "alias": "Wall Infiltration", "length": 50, "domain": { "type": "codedValue", "name": "WS1_MACP_Inflow_Infiltration", "description": "", "codedValues": [ { "name": "None", "code": "None" }, { "name": "Infil Stained", "code": "Infil Stained" }, { "name": "Infil Weeper", "code": "Infil Weeper" }, { "name": "Infil Dripper", "code": "Infil Dripper" }, { "name": "Infil Runner", "code": "Infil Runner" }, { "name": "Infil Gusher", "code": "Infil Gusher" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BENCHTYPE", "type": "esriFieldTypeString", "alias": "Bench Material", "length": 50, "domain": { "type": "codedValue", "name": "WS1_NASSCO_BenchMaterial", "description": "", "codedValues": [ { "name": "Brick", "code": "Brick" }, { "name": "Vitirified Clay Pipe", "code": "Vitirified Clay Pipe" }, { "name": "Other", "code": "Other" }, { "name": "None", "code": "None" }, { "name": "Concrete", "code": "Concrete" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Lined/Coating", "code": "Lined/Coating" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BENCHLINETYPE", "type": "esriFieldTypeString", "alias": "Bench Lining Material", "length": 50, "domain": { "type": "codedValue", "name": "WS1_MACP_Linings", "description": "", "codedValues": [ { "name": "Bitumastic", "code": "Bitumastic" }, { "name": "Cementitious", "code": "Cementitious" }, { "name": "Cured in Place", "code": "Cured in Place" }, { "name": "Epoxy", "code": "Epoxy" }, { "name": "Fiberglass", "code": "Fiberglass" }, { "name": "None - No Coating", "code": "None - No Coating" }, { "name": "Plastic", "code": "Plastic" }, { "name": "Polymer", "code": "Polymer" }, { "name": "Rubber", "code": "Rubber" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BENCHCOND", "type": "esriFieldTypeString", "alias": "Bench Condition", "length": 50, "domain": { "type": "codedValue", "name": "WS1_NASSCO_BenchCondition", "description": "", "codedValues": [ { "name": "No Defects Observed", "code": "No Defects Observed" }, { "name": "Crack", "code": "Crack" }, { "name": "Fracture", "code": "Fracture" }, { "name": "Hole", "code": "Hole" }, { "name": "Brick - mortar missing", "code": "Brick - mortar missing" }, { "name": "Brick - displaced", "code": "Brick - displaced" }, { "name": "Brick - missing", "code": "Brick - missing" }, { "name": "Surface Damage - deterioration", "code": "Surface Damage - deterioration" }, { "name": "Surface Damage - rebar showing", "code": "Surface Damage - rebar showing" }, { "name": "Surface Damage - missing wall", "code": "Surface Damage - missing wall" }, { "name": "Liner/Coating - peeling/bulging", "code": "Liner/Coating - peeling/bulging" }, { "name": "Liner/Coating - detached", "code": "Liner/Coating - detached" }, { "name": "Deposits - encrustation", "code": "Deposits - encrustation" }, { "name": "Deposits - grease", "code": "Deposits - grease" }, { "name": "Deposits - ragging", "code": "Deposits - ragging" }, { "name": "Roots - fine", "code": "Roots - fine" }, { "name": "Roots - medium", "code": "Roots - medium" }, { "name": "Roots - ball", "code": "Roots - ball" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BENCHDEPOSITS", "type": "esriFieldTypeString", "alias": "Bench Deposits", "length": 50, "domain": { "type": "codedValue", "name": "WS1_ssBenchDeposits", "description": "", "codedValues": [ { "name": "Deposits - encrustation", "code": "Deposits - encrustation" }, { "name": "Deposits - grease", "code": "Deposits - grease" }, { "name": "Deposits settled- ragging/sanitary", "code": "Deposits settled- ragging/sanitary" }, { "name": "Deposits settled- fine/sand", "code": "Deposits settled- fine/sand" }, { "name": "Deposits settled- gravel/rocks/brick", "code": "Deposits settled- gravel/rocks/brick" }, { "name": "Deposits settled- hard/compacted", "code": "Deposits settled- hard/compacted" }, { "name": "None", "code": "None" }, { "name": "Other", "code": "Other" }, { "name": "Sand", "code": "Sand" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BENCHDEPOSITSDEPTH", "type": "esriFieldTypeDouble", "alias": "Depth of Deposits", "domain": null }, { "name": "BENCHINFILTRATE", "type": "esriFieldTypeString", "alias": "Bench Infiltration", "length": 50, "domain": { "type": "codedValue", "name": "WS1_MACP_Inflow_Infiltration", "description": "", "codedValues": [ { "name": "None", "code": "None" }, { "name": "Infil Stained", "code": "Infil Stained" }, { "name": "Infil Weeper", "code": "Infil Weeper" }, { "name": "Infil Dripper", "code": "Infil Dripper" }, { "name": "Infil Runner", "code": "Infil Runner" }, { "name": "Infil Gusher", "code": "Infil Gusher" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CHANNELTYPE", "type": "esriFieldTypeString", "alias": "Channel Material", "length": 50, "domain": { "type": "codedValue", "name": "WS1_NASSCO_ChannelType", "description": "", "codedValues": [ { "name": "Brick", "code": "Brick" }, { "name": "Cast Iron", "code": "Cast Iron" }, { "name": "Ductile Iron", "code": "Ductile Iron" }, { "name": "Polyvinyl Chloride", "code": "Polyvinyl Chloride" }, { "name": "Reinforced Concrete Pipe", "code": "Reinforced Concrete Pipe" }, { "name": "Steel Pipe", "code": "Steel Pipe" }, { "name": "Vitrified Clay Pipe", "code": "Vitrified Clay Pipe" }, { "name": "Other", "code": "Other" }, { "name": "None", "code": "None" }, { "name": "Concrete", "code": "Concrete" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Lined/Coating", "code": "Lined/Coating" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CHANNELLINETYPE", "type": "esriFieldTypeString", "alias": "Channel Lining Material", "length": 50, "domain": { "type": "codedValue", "name": "WS1_MACP_Linings", "description": "", "codedValues": [ { "name": "Bitumastic", "code": "Bitumastic" }, { "name": "Cementitious", "code": "Cementitious" }, { "name": "Cured in Place", "code": "Cured in Place" }, { "name": "Epoxy", "code": "Epoxy" }, { "name": "Fiberglass", "code": "Fiberglass" }, { "name": "None - No Coating", "code": "None - No Coating" }, { "name": "Plastic", "code": "Plastic" }, { "name": "Polymer", "code": "Polymer" }, { "name": "Rubber", "code": "Rubber" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CHANNELCOND", "type": "esriFieldTypeString", "alias": "Channel Condition", "length": 50, "domain": { "type": "codedValue", "name": "WS1_NASSCO_ChannelCondition", "description": "", "codedValues": [ { "name": "No Defects Observed", "code": "No Defects Observed" }, { "name": "Crack", "code": "Crack" }, { "name": "Fracture", "code": "Fracture" }, { "name": "Hole", "code": "Hole" }, { "name": "Brick - mortar missing", "code": "Brick - mortar missing" }, { "name": "Brick - displaced", "code": "Brick - displaced" }, { "name": "Brick - missing", "code": "Brick - missing" }, { "name": "Liner/Coating - peeling/bulging", "code": "Liner/Coating - peeling/bulging" }, { "name": "Liner/Coating - detached", "code": "Liner/Coating - detached" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CHANNELDEPOSITS", "type": "esriFieldTypeString", "alias": "Flow Channel Deposits", "length": 50, "domain": { "type": "codedValue", "name": "WS1_ssChannelDeposits", "description": "", "codedValues": [ { "name": "Deposits - encrustation", "code": "Deposits - encrustation" }, { "name": "Deposits - grease", "code": "Deposits - grease" }, { "name": "Deposits settled - ragging/sanitary", "code": "Deposits settled - ragging/sanitary" }, { "name": "Deposits settled - fine/sand", "code": "Deposits settled - fine/sand" }, { "name": "Deposits settled - gravel/rocks/brick", "code": "Deposits settled - gravel/rocks/brick" }, { "name": "Deposits settled - hard/compacted", "code": "Deposits settled - hard/compacted" }, { "name": "None", "code": "None" }, { "name": "Other", "code": "Other" }, { "name": "Sand", "code": "Sand" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CHANNELDEPOSITSDEPTH", "type": "esriFieldTypeDouble", "alias": "Depth of Deposits", "domain": null }, { "name": "CHANNELINFILTRATE", "type": "esriFieldTypeString", "alias": "Channel Infiltration", "length": 50, "domain": { "type": "codedValue", "name": "WS1_MACP_Inflow_Infiltration", "description": "", "codedValues": [ { "name": "None", "code": "None" }, { "name": "Infil Stained", "code": "Infil Stained" }, { "name": "Infil Weeper", "code": "Infil Weeper" }, { "name": "Infil Dripper", "code": "Infil Dripper" }, { "name": "Infil Runner", "code": "Infil Runner" }, { "name": "Infil Gusher", "code": "Infil Gusher" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SEALCOND", "type": "esriFieldTypeString", "alias": "Pipe Seal Condition", "length": 50, "domain": { "type": "codedValue", "name": "WS1_NASSCO_PipeSealCond", "description": "", "codedValues": [ { "name": "No Seal", "code": "No Seal" }, { "name": "Sound", "code": "Sound" }, { "name": "Sand/Water Infiltration", "code": "Sand/Water Infiltration" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PROJECT2", "type": "esriFieldTypeString", "alias": "Additional Project Information", "length": 50, "domain": null }, { "name": "WORKREQUEST", "type": "esriFieldTypeString", "alias": "Work Request Submitted", "length": 50, "domain": { "type": "codedValue", "name": "WS1_YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PROJECT", "type": "esriFieldTypeString", "alias": "Purpose of Work Request", "length": 50, "domain": { "type": "codedValue", "name": "WS1_ssWorkStatus", "description": "Status of Wastewater Work Status", "codedValues": [ { "name": "Access", "code": "Access" }, { "name": "Cleaning", "code": "Cleaning" }, { "name": "Rehabilitation", "code": "Rehabilitation" }, { "name": "Replacement", "code": "Replacement" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "COMPINSPECT", "type": "esriFieldTypeString", "alias": "Inspection Complete", "length": 50, "domain": { "type": "codedValue", "name": "WS1_YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ID", "type": "esriFieldTypeString", "alias": "Legacy Access ID", "length": 50, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "ENDDATETIME", "type": "esriFieldTypeDate", "alias": "ENDDATETIME", "length": 8, "domain": null }, { "name": "INSPECTID", "type": "esriFieldTypeString", "alias": "INSPECTID", "length": 10, "domain": null }, { "name": "UFV", "type": "esriFieldTypeString", "alias": "Unable to Inspect", "length": 50, "domain": { "type": "codedValue", "name": "WS1_ssUFV", "description": "", "codedValues": [ { "name": "Paved Over", "code": "Paved Over" }, { "name": "No Access", "code": "No Access" }, { "name": "Obstruction", "code": "Obstruction" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CANNOTLOCATE", "type": "esriFieldTypeString", "alias": "Cannot Locate", "length": 15, "domain": { "type": "codedValue", "name": "WS1_ssCannotLocate", "description": "", "codedValues": [ { "name": "Cannot Locate", "code": "Cannot Locate" }, { "name": "No Value", "code": "No Value" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "UFVCOMMENTS", "type": "esriFieldTypeString", "alias": "Addition Comments", "length": 300, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "indexes": [ { "name": "UUID_58", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G221FACILITYID", "fields": "FACILITYID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "R58_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "SewerDevice", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "FACILITYID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{34618DF7-617F-4033-8AAA-DF61B85BBE55}" }, { "id": 1, "name": "SewerDevice", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "FACILITYID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{34618DF7-617F-4033-8AAA-DF61B85BBE55}" }, { "id": 2, "name": "SewerDevice", "relatedTableId": 2, "role": "esriRelRoleDestination", "keyField": "FACILITYID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{34618DF7-617F-4033-8AAA-DF61B85BBE55}" }, { "id": 3, "name": "SewerDevice", "relatedTableId": 3, "role": "esriRelRoleDestination", "keyField": "FACILITYID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{34618DF7-617F-4033-8AAA-DF61B85BBE55}" }, { "id": 4, "name": "SewerDevice", "relatedTableId": 4, "role": "esriRelRoleDestination", "keyField": "FACILITYID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{34618DF7-617F-4033-8AAA-DF61B85BBE55}" } ], "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": false, "supportsCurrentUserQueries": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1710854483000 } }