{
 "currentVersion": 11.3,
 "cimVersion": "3.3.0",
 "id": 16,
 "name": "Walls Inspection Table",
 "type": "Table",
 "description": null,
 "hasAttachments": true,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "streetnameno",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "objectid",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "surveyedby",
   "type": "esriFieldTypeString",
   "alias": "Surveyed By ",
   "length": 100,
   "domain": null
  },
  {
   "name": "reviewedby",
   "type": "esriFieldTypeString",
   "alias": "Reviewed By",
   "length": 100,
   "domain": null
  },
  {
   "name": "owner",
   "type": "esriFieldTypeString",
   "alias": "Owner (Public or Private)",
   "length": 20,
   "domain": {
    "type": "codedValue",
    "name": "Owner",
    "description": "",
    "codedValues": [
     {
      "name": "PUBLIC",
      "code": "PUBLIC"
     },
     {
      "name": "PRIVATE",
      "code": "PRIVATE"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "ifpublic",
   "type": "esriFieldTypeString",
   "alias": "IF PUBLIC",
   "length": 25,
   "domain": {
    "type": "codedValue",
    "name": "OwnerPublic",
    "description": "",
    "codedValues": [
     {
      "name": "COH",
      "code": "COH"
     },
     {
      "name": "STATE",
      "code": "STATE"
     },
     {
      "name": "COUNTY",
      "code": "COUNTY"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "ifprivate",
   "type": "esriFieldTypeString",
   "alias": "IF PRIVATE",
   "length": 25,
   "domain": {
    "type": "codedValue",
    "name": "OwnerPrivate",
    "description": "",
    "codedValues": [
     {
      "name": "COMMERCIAL",
      "code": "COMMERCIAL"
     },
     {
      "name": "RESIDENTIAL",
      "code": "RESIDENTIAL"
     },
     {
      "name": "HOA/COLLECTIVE",
      "code": "HOA/COLLECTIVE"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "project",
   "type": "esriFieldTypeString",
   "alias": "Project",
   "length": 100,
   "domain": {
    "type": "codedValue",
    "name": "ProjectName",
    "description": "",
    "codedValues": [
     {
      "name": "2025 STORMWATER ASSET INVENTORY",
      "code": "2025 STORMWATER ASSET INVENTORY"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "inspectiondate",
   "type": "esriFieldTypeDate",
   "alias": "Inspection Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "weather",
   "type": "esriFieldTypeString",
   "alias": "Weather",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "WeatherCondition",
    "description": "",
    "codedValues": [
     {
      "name": "DRY",
      "code": "DRY"
     },
     {
      "name": "HEAVY RAIN",
      "code": "HEAVY RAIN"
     },
     {
      "name": "LIGHT RAIN",
      "code": "LIGHT RAIN"
     },
     {
      "name": "SNOW",
      "code": "SNOW"
     },
     {
      "name": "DRY WEATHER/WET GROUND",
      "code": "DRY WEATHER/WET GROUND"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "precleaning",
   "type": "esriFieldTypeString",
   "alias": "Pre-Cleaning?",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "PreCleaning",
    "description": "",
    "codedValues": [
     {
      "name": "HEAVY CLEANING",
      "code": "HEAVY CLEANING"
     },
     {
      "name": "LIGHT CLEANING (JETTING)",
      "code": "LIGHT CLEANING (JETTING)"
     },
     {
      "name": "NO PRE-CLEAN",
      "code": "NO PRE-CLEAN"
     },
     {
      "name": "UNK",
      "code": "UNK"
     },
     {
      "name": "OTHER",
      "code": "OTHER"
     },
     {
      "name": "COMPLETE",
      "code": "COMPLETE"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "datecleaned",
   "type": "esriFieldTypeDate",
   "alias": "Date Cleaned",
   "length": 8,
   "domain": null
  },
  {
   "name": "inspectionstatus",
   "type": "esriFieldTypeString",
   "alias": "Inspection Status",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "InspectionStatus",
    "description": "",
    "codedValues": [
     {
      "name": "COMPLETED INSPECTION",
      "code": "COMPLETED INSPECTION"
     },
     {
      "name": "BURIED AND MARKED",
      "code": "BURIED AND MARKED"
     },
     {
      "name": "NO ACCESS",
      "code": "NO ACCESS"
     },
     {
      "name": "DOES NOT EXIST",
      "code": "DOES NOT EXIST"
     },
     {
      "name": "NOT FOUND",
      "code": "NOT FOUND"
     },
     {
      "name": "TRAFFIC",
      "code": "TRAFFIC"
     },
     {
      "name": "NOT OPENED",
      "code": "NOT OPENED"
     },
     {
      "name": "DEBRIS",
      "code": "DEBRIS"
     },
     {
      "name": "STRUCTURE LIMITATION",
      "code": "STRUCTURE LIMITATION"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "consequenceoffailure",
   "type": "esriFieldTypeString",
   "alias": "Consequence of failure",
   "length": 255,
   "domain": null
  },
  {
   "name": "drainagearea",
   "type": "esriFieldTypeString",
   "alias": "Drainage Area",
   "length": 10,
   "domain": {
    "type": "codedValue",
    "name": "DrainageArea",
    "description": "",
    "codedValues": [
     {
      "name": "TUR",
      "code": "TUR"
     },
     {
      "name": "DER",
      "code": "DER"
     },
     {
      "name": "DUC",
      "code": "DUC"
     },
     {
      "name": "GEO",
      "code": "GEO"
     },
     {
      "name": "CAL",
      "code": "CAL"
     },
     {
      "name": "BEA",
      "code": "BEA"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "assetid",
   "type": "esriFieldTypeString",
   "alias": "Asset ID",
   "length": 100,
   "domain": null
  },
  {
   "name": "streetnameno",
   "type": "esriFieldTypeString",
   "alias": "Street (Name & Number)",
   "length": 255,
   "domain": null
  },
  {
   "name": "city",
   "type": "esriFieldTypeString",
   "alias": "City",
   "length": 20,
   "domain": {
    "type": "codedValue",
    "name": "City",
    "description": "",
    "codedValues": [
     {
      "name": "HOBART",
      "code": "HOBART"
     },
     {
      "name": "MERRILLVILLE",
      "code": "MERRILLVILLE"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "locationcode",
   "type": "esriFieldTypeString",
   "alias": "Location Code",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "LocationCode",
    "description": "",
    "codedValues": [
     {
      "name": "PRIMARY MAJOR ARTERIAL ROAD",
      "code": "PRIMARY MAJOR ARTERIAL ROAD"
     },
     {
      "name": "SECONDARY ROAD",
      "code": "SECONDARY ROAD"
     },
     {
      "name": "LOCAL/RURAL STREET",
      "code": "LOCAL/RURAL STREET"
     },
     {
      "name": "EASEMENT/ROW",
      "code": "EASEMENT/ROW"
     },
     {
      "name": "WOODS",
      "code": "WOODS"
     },
     {
      "name": "SIDEWALK",
      "code": "SIDEWALK"
     },
     {
      "name": "PARKING LOT",
      "code": "PARKING LOT"
     },
     {
      "name": "ALLEY",
      "code": "ALLEY"
     },
     {
      "name": "DITCH",
      "code": "DITCH"
     },
     {
      "name": "BUILDING",
      "code": "BUILDING"
     },
     {
      "name": "CREEK/RIVER/STREAM",
      "code": "CREEK/RIVER/STREAM"
     },
     {
      "name": "RAILWAY",
      "code": "RAILWAY"
     },
     {
      "name": "LEVEE/FLOODWALL",
      "code": "LEVEE/FLOODWALL"
     },
     {
      "name": "DAM",
      "code": "DAM"
     },
     {
      "name": "LEVEE PUMP STATION",
      "code": "LEVEE PUMP STATION"
     },
     {
      "name": "YARD",
      "code": "YARD"
     },
     {
      "name": "OTHER",
      "code": "OTHER"
     },
     {
      "name": "STRUCTURE/RESIDENCE",
      "code": "STRUCTURE/RESIDENCE"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "usnorthing",
   "type": "esriFieldTypeDouble",
   "alias": "Wall US Northing",
   "domain": null
  },
  {
   "name": "useasting",
   "type": "esriFieldTypeDouble",
   "alias": "Wall US Easting",
   "domain": null
  },
  {
   "name": "uselevation",
   "type": "esriFieldTypeDouble",
   "alias": "Wall US elevation (lowest point)",
   "domain": null
  },
  {
   "name": "dsnorthing",
   "type": "esriFieldTypeDouble",
   "alias": "Wall DS Northing",
   "domain": null
  },
  {
   "name": "dseasting",
   "type": "esriFieldTypeDouble",
   "alias": "Wall DS Easting",
   "domain": null
  },
  {
   "name": "dselevation",
   "type": "esriFieldTypeDouble",
   "alias": "Wall DS elevation (lowest point)",
   "domain": null
  },
  {
   "name": "coordinatesystem",
   "type": "esriFieldTypeString",
   "alias": "Coordinate System",
   "length": 100,
   "domain": null
  },
  {
   "name": "verticaldatum",
   "type": "esriFieldTypeString",
   "alias": "Vertical Datum",
   "length": 100,
   "domain": null
  },
  {
   "name": "gpsaccuracy",
   "type": "esriFieldTypeString",
   "alias": "GPS Accuracy",
   "length": 25,
   "domain": {
    "type": "codedValue",
    "name": "GPSAccuracy",
    "description": "",
    "codedValues": [
     {
      "name": "SURVEY GRADE",
      "code": "SURVEY GRADE"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "assettype",
   "type": "esriFieldTypeString",
   "alias": "Asset Type",
   "length": 20,
   "domain": {
    "type": "codedValue",
    "name": "Walls_AssetType",
    "description": "",
    "codedValues": [
     {
      "name": "ENDWALL",
      "code": "ENDWALL"
     },
     {
      "name": "WINGWALL",
      "code": "WINGWALL"
     },
     {
      "name": "FLOODWALL",
      "code": "FLOODWALL"
     },
     {
      "name": "HEADWALL",
      "code": "HEADWALL"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "culvertattached",
   "type": "esriFieldTypeString",
   "alias": "Attached to a Culvert?",
   "length": 10,
   "domain": {
    "type": "codedValue",
    "name": "YesNo",
    "description": "",
    "codedValues": [
     {
      "name": "YES",
      "code": "YES"
     },
     {
      "name": "NO",
      "code": "NO"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "culvertid",
   "type": "esriFieldTypeString",
   "alias": "If yes, what is the culverts asset ID?",
   "length": 100,
   "domain": null
  },
  {
   "name": "wallcondition",
   "type": "esriFieldTypeString",
   "alias": "Wall Condition",
   "length": 100,
   "domain": null
  },
  {
   "name": "height",
   "type": "esriFieldTypeDouble",
   "alias": "Height",
   "domain": null
  },
  {
   "name": "wallwidth",
   "type": "esriFieldTypeDouble",
   "alias": "Width",
   "domain": null
  },
  {
   "name": "wallthickness",
   "type": "esriFieldTypeDouble",
   "alias": "Thickness",
   "domain": null
  },
  {
   "name": "material",
   "type": "esriFieldTypeString",
   "alias": "Material",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "Walls_Material",
    "description": "",
    "codedValues": [
     {
      "name": "CAST IRON",
      "code": "CAST IRON"
     },
     {
      "name": "CAST-IN-PLACE CONCRETE",
      "code": "CAST-IN-PLACE CONCRETE"
     },
     {
      "name": "PRECAST CONCRETE",
      "code": "PRECAST CONCRETE"
     },
     {
      "name": "DUCTILE IRON",
      "code": "DUCTILE IRON"
     },
     {
      "name": "FIBERGLASS REINFORCED",
      "code": "FIBERGLASS REINFORCED"
     },
     {
      "name": "POLYETHYLENE",
      "code": "POLYETHYLENE"
     },
     {
      "name": "PLASTIC/STEEL COMPOSITE",
      "code": "PLASTIC/STEEL COMPOSITE"
     },
     {
      "name": "PVC",
      "code": "PVC"
     },
     {
      "name": "STEEL",
      "code": "STEEL"
     },
     {
      "name": "UNK",
      "code": "UNK"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "liningmethod",
   "type": "esriFieldTypeString",
   "alias": "Lining/Coating Method",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "Walls_Lining",
    "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": "POLYMER",
      "code": "POLYMER"
     },
     {
      "name": "PLASTIC",
      "code": "PLASTIC"
     },
     {
      "name": "RUBBER",
      "code": "RUBBER"
     },
     {
      "name": "UNK",
      "code": "UNK"
     },
     {
      "name": "NONE",
      "code": "NONE"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "totallength",
   "type": "esriFieldTypeDouble",
   "alias": "Total Length (From beginning to end of segment)",
   "domain": null
  },
  {
   "name": "lengthsurveyed",
   "type": "esriFieldTypeDouble",
   "alias": "Length Surveyed",
   "domain": null
  },
  {
   "name": "erosionsigns",
   "type": "esriFieldTypeString",
   "alias": "Signs of Erosion?",
   "length": 10,
   "domain": {
    "type": "codedValue",
    "name": "YesNo",
    "description": "",
    "codedValues": [
     {
      "name": "YES",
      "code": "YES"
     },
     {
      "name": "NO",
      "code": "NO"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "cracksordamage",
   "type": "esriFieldTypeString",
   "alias": "Presence of Cracks or Damage?",
   "length": 255,
   "domain": null
  },
  {
   "name": "settlementorshifting",
   "type": "esriFieldTypeString",
   "alias": "Settlement or Shifting?",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "SettlementOrShifting",
    "description": "",
    "codedValues": [
     {
      "name": "SETTLEMENT",
      "code": "SETTLEMENT"
     },
     {
      "name": "SHIFTING",
      "code": "SHIFTING"
     },
     {
      "name": "BOTH SETTLEMENT AND SHIFTING",
      "code": "BOTH SETTLEMENT AND SHIFTING"
     },
     {
      "name": "NONE",
      "code": "NONE"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "floodingevidence",
   "type": "esriFieldTypeString",
   "alias": "Evidence of Flooding?",
   "length": 10,
   "domain": {
    "type": "codedValue",
    "name": "YesNo",
    "description": "",
    "codedValues": [
     {
      "name": "YES",
      "code": "YES"
     },
     {
      "name": "NO",
      "code": "NO"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "flowcontrol",
   "type": "esriFieldTypeString",
   "alias": "Flow Control",
   "length": 10,
   "domain": {
    "type": "codedValue",
    "name": "YesNo",
    "description": "",
    "codedValues": [
     {
      "name": "YES",
      "code": "YES"
     },
     {
      "name": "NO",
      "code": "NO"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "flowobservations",
   "type": "esriFieldTypeString",
   "alias": "Flow Observations",
   "length": 255,
   "domain": null
  },
  {
   "name": "bypassoverflowmechanismevidence",
   "type": "esriFieldTypeString",
   "alias": "Evidence of Bypass or Overflow Mechanism?",
   "length": 10,
   "domain": {
    "type": "codedValue",
    "name": "YesNo",
    "description": "",
    "codedValues": [
     {
      "name": "YES",
      "code": "YES"
     },
     {
      "name": "NO",
      "code": "NO"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "bypassoverflowcondition",
   "type": "esriFieldTypeString",
   "alias": "Bypass or overflow condition",
   "length": 100,
   "domain": null
  },
  {
   "name": "sedimentdebris",
   "type": "esriFieldTypeString",
   "alias": "Sediment & Debris Build-Up?",
   "length": 20,
   "domain": {
    "type": "codedValue",
    "name": "SedimentDebrisBuildUp",
    "description": "",
    "codedValues": [
     {
      "name": "NONE",
      "code": "NONE"
     },
     {
      "name": "LOW",
      "code": "LOW"
     },
     {
      "name": "MEDIUM",
      "code": "MEDIUM"
     },
     {
      "name": "HIGH",
      "code": "HIGH"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "typeofdebris",
   "type": "esriFieldTypeString",
   "alias": "Type of Debris (e.g., leaves, trash)",
   "length": 255,
   "domain": null
  },
  {
   "name": "additionalinfo",
   "type": "esriFieldTypeString",
   "alias": "Additional Component Information",
   "length": 255,
   "domain": null
  },
  {
   "name": "globalid",
   "type": "esriFieldTypeGlobalID",
   "alias": "GlobalID",
   "length": 38,
   "domain": null
  }
 ],
 "indexes": [
  {
   "name": "g553assetid",
   "fields": "assetid",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "r181_sde_rowid_uk",
   "fields": "objectid",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "uuid_181",
   "fields": "globalid",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 6,
   "name": "geohub.GIS.Walls",
   "relatedTableId": 6,
   "role": "esriRelRoleDestination",
   "keyField": "AssetID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false,
   "catalogID": "{9ADFB835-5E02-487A-965E-0501E0FDAD48}"
  }
 ],
 "capabilities": "Map,Query,Data",
 "maxRecordCount": 2000,
 "supportsStatistics": true,
 "supportsExceedsLimitStatistics": true,
 "supportsAdvancedQueries": true,
 "supportedQueryFormats": "JSON, PBF",
 "isDataVersioned": false,
 "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": false
 },
 "dateFieldsTimeReference": null,
 "preferredTimeReference": null,
 "datesInUnknownTimezone": false,
 "hasMetadata": true,
 "isDataArchived": false,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": false,
  "startArchivingMoment": -1
 },
 "serviceItemId": "c548dfd6c5f74a3fbf79c0d304bce63f"
}