{
 "layers": [
  {
   "currentVersion": 11.5,
   "cimVersion": "3.5.0",
   "id": 2,
   "name": "Outfall Drainage Area",
   "type": "Feature Layer",
   "description": "Records from storm drains built since 2013 should have drainage areas from as built plans, else earlier records were digitized from contours and existing pipe network.",
   "geometryType": "esriGeometryPolygon",
   "sourceSpatialReference": {
    "wkid": 102685,
    "latestWkid": 2248,
    "xyTolerance": 0.00328083333333333,
    "zTolerance": 2,
    "mTolerance": 0.001,
    "falseX": -120561100,
    "falseY": -95444400,
    "xyUnits": 3048.00609601219,
    "falseZ": 0,
    "zUnits": 1,
    "falseM": 0,
    "mUnits": 1
   },
   "spatialReference": {
    "wkid": 102685,
    "latestWkid": 2248,
    "xyTolerance": 0.00328083333333333,
    "zTolerance": 0.001,
    "mTolerance": 0.001,
    "falseX": -120561100,
    "falseY": -95444400,
    "xyUnits": 3048.00609601219,
    "falseZ": -100000,
    "zUnits": 10000,
    "falseM": -100000,
    "mUnits": 10000
   },
   "copyrightText": "",
   "parentLayer": null,
   "subLayers": [],
   "minScale": 0,
   "maxScale": 0,
   "referenceScale": 0.0,
   "drawingInfo": {
    "renderer": {
     "type": "simple",
     "symbol": {
      "type": "esriSFS",
      "style": "esriSFSSolid",
      "color": [
       169,
       28,
       28,
       0
      ],
      "outline": {
       "type": "esriSLS",
       "style": "esriSLSSolid",
       "color": [
        169,
        0,
        230,
        255
       ],
       "width": 1
      }
     }
    },
    "scaleSymbols": true,
    "transparency": 0,
    "labelingInfo": null
   },
   "defaultVisibility": true,
   "extent": {
    "xmin": 1296874.3665691614,
    "ymin": 321070.525762558,
    "xmax": 1401796.0235233307,
    "ymax": 530272.9702177346,
    "spatialReference": {
     "wkid": 102685,
     "latestWkid": 2248,
     "xyTolerance": 0.00328083333333333,
     "zTolerance": 0.001,
     "mTolerance": 0.001,
     "falseX": -120561100,
     "falseY": -95444400,
     "xyUnits": 3048.00609601219,
     "falseZ": -100000,
     "zUnits": 10000,
     "falseM": -100000,
     "mUnits": 10000
    }
   },
   "hasAttachments": false,
   "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText",
   "displayField": "MDE_GDB_ID",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "OBJECTID",
     "type": "esriFieldTypeOID",
     "alias": "OBJECTID",
     "domain": null
    },
    {
     "name": "MDE_GDB_ID",
     "type": "esriFieldTypeString",
     "alias": "MDE_GDB_ID",
     "length": 13,
     "domain": null
    },
    {
     "name": "MDE_GDB_ID_Outfall",
     "type": "esriFieldTypeString",
     "alias": "MDE GDB ID of Outfall",
     "length": 13,
     "domain": null
    },
    {
     "name": "OUTFALL_DRAIN_AREA",
     "type": "esriFieldTypeDouble",
     "alias": "Drainage area (acres) to outfall",
     "domain": null
    },
    {
     "name": "SD_Number",
     "type": "esriFieldTypeString",
     "alias": "SD Number",
     "length": 13,
     "domain": null
    },
    {
     "name": "GEN_COMMENTS",
     "type": "esriFieldTypeString",
     "alias": "General comments",
     "length": 255,
     "domain": null
    },
    {
     "name": "created_user",
     "type": "esriFieldTypeString",
     "alias": "Created by",
     "length": 255,
     "domain": null
    },
    {
     "name": "created_date",
     "type": "esriFieldTypeDate",
     "alias": "Date created",
     "length": 8,
     "domain": null
    },
    {
     "name": "last_edited_user",
     "type": "esriFieldTypeString",
     "alias": "Last edited by",
     "length": 255,
     "domain": null
    },
    {
     "name": "last_edited_date",
     "type": "esriFieldTypeDate",
     "alias": "Last edited date",
     "length": 8,
     "domain": null
    },
    {
     "name": "GlobalID",
     "type": "esriFieldTypeGlobalID",
     "alias": "GlobalID",
     "length": 38,
     "domain": null
    },
    {
     "name": "Shape",
     "type": "esriFieldTypeGeometry",
     "alias": "Shape",
     "domain": null
    },
    {
     "name": "Shape.STArea()",
     "type": "esriFieldTypeDouble",
     "alias": "Shape.STArea()",
     "domain": null
    },
    {
     "name": "Shape.STLength()",
     "type": "esriFieldTypeDouble",
     "alias": "Shape.STLength()",
     "domain": null
    }
   ],
   "geometryField": {
    "name": "Shape",
    "type": "esriFieldTypeGeometry",
    "alias": "Shape"
   },
   "indexes": [
    {
     "name": "R502_pk",
     "fields": "OBJECTID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    },
    {
     "name": "UUID_502",
     "fields": "GlobalID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    },
    {
     "name": "GDB_3411_MDE_GDB",
     "fields": "MDE_GDB_ID",
     "isAscending": true,
     "isUnique": false,
     "description": ""
    },
    {
     "name": "S233_idx",
     "fields": "Shape",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    }
   ],
   "subtypes": [],
   "relationships": [],
   "canModifyLayer": true,
   "canScaleSymbols": false,
   "hasLabels": false,
   "capabilities": "Query,Map,Data",
   "maxRecordCount": 2000,
   "maxSelectionCount": 2000,
   "supportsStatistics": true,
   "supportsExceedsLimitStatistics": true,
   "supportsAdvancedQueries": true,
   "supportedQueryFormats": "JSON, geoJSON, PBF",
   "isDataVersioned": false,
   "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true},
   "useStandardizedQueries": true,
   "supportedSpatialRelationships": [
    "esriSpatialRelIntersects",
    "esriSpatialRelContains",
    "esriSpatialRelCrosses",
    "esriSpatialRelEnvelopeIntersects",
    "esriSpatialRelIndexIntersects",
    "esriSpatialRelOverlaps",
    "esriSpatialRelTouches",
    "esriSpatialRelWithin",
    "esriSpatialRelRelation"
   ],
   "advancedQueryCapabilities": {
    "useStandardizedQueries": true,
    "supportsStatistics": true,
    "supportsPercentileStatistics": true,
    "supportsHavingClause": true,
    "supportsOrderBy": true,
    "supportsDistinct": true,
    "supportsCountDistinct": true,
    "supportsAdvancedQueryRelated": true,
    "supportsQueryRelatedPagination": true,
    "supportsPagination": true,
    "supportsLod": false,
    "supportsQueryWithLodSR": false,
    "supportsTrueCurve": true,
    "supportsQueryWithDatumTransformation": true,
    "supportsReturningQueryExtent": true,
    "supportsQueryWithDistance": true,
    "supportsSqlExpression": true,
    "supportsTimeRelation": true,
    "supportsSqlFormat": false,
    "supportsQueryAnalytic": true,
    "supportsCurrentUserQueries": true
   },
   "supportsDatumTransformation": true,
   "advancedQueryAnalyticCapabilities": {
    "supportsLinearRegression": true,
    "supportsAsync": false,
    "supportsPercentileAnalytic": true
   },
   "dateFieldsTimeReference": null,
   "preferredTimeReference": null,
   "datesInUnknownTimezone": false,
   "hasGeometryProperties": true,
   "geometryProperties": {
    "shapeAreaFieldName": "Shape.STArea()",
    "shapeLengthFieldName": "Shape.STLength()",
    "units": "esriFeet",
    "mapUnits": {"uwkid": 9003}
   },
   "hasMetadata": true,
   "isDataArchived": false,
   "archivingInfo": {
    "supportsQueryWithHistoricMoment": false,
    "startArchivingMoment": -1
   },
   "supportsCoordinatesQuantization": true,
   "supportsDynamicLegends": true,
   "serviceItemId": "92e3e55a570646aa8c761311234c1975"
  }
 ],
 "tables": [
  {
   "currentVersion": 11.5,
   "cimVersion": "3.5.0",
   "id": 3,
   "name": "SDC_Cleaning",
   "type": "Table",
   "description": null,
   "copyrightText": null,
   "hasAttachments": false,
   "htmlPopupType": "esriServerHTMLPopupTypeNone",
   "displayField": "conv_pipe_cleaned",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "OBJECTID",
     "type": "esriFieldTypeOID",
     "alias": "OBJECTID",
     "domain": null
    },
    {
     "name": "rel_globalid",
     "type": "esriFieldTypeGUID",
     "alias": "REL_GLOBALID",
     "length": 38,
     "domain": null
    },
    {
     "name": "conv_pipe_cleaned",
     "type": "esriFieldTypeString",
     "alias": "Pipe Cleaned",
     "length": 50,
     "domain": {
      "type": "codedValue",
      "name": "d_Boolean",
      "description": "Boolean (Yes/No/NA",
      "codedValues": [
       {
        "name": "Yes",
        "code": "Y"
       },
       {
        "name": "No",
        "code": "N"
       },
       {
        "name": "N/A",
        "code": "NA"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "conv_date_cleaned",
     "type": "esriFieldTypeDate",
     "alias": "Date Cleaned",
     "length": 8,
     "domain": null
    },
    {
     "name": "Conv_comments",
     "type": "esriFieldTypeString",
     "alias": "Comments",
     "length": 1000,
     "domain": null
    },
    {
     "name": "C_meets_criteria_yn",
     "type": "esriFieldTypeString",
     "alias": "Meets Criteria",
     "length": 50,
     "domain": {
      "type": "codedValue",
      "name": "d_Boolean",
      "description": "Boolean (Yes/No/NA",
      "codedValues": [
       {
        "name": "Yes",
        "code": "Y"
       },
       {
        "name": "No",
        "code": "N"
       },
       {
        "name": "N/A",
        "code": "NA"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "GlobalID",
     "type": "esriFieldTypeGlobalID",
     "alias": "GlobalID",
     "length": 38,
     "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
    },
    {
     "name": "Length_Pipe_Cleaned",
     "type": "esriFieldTypeDouble",
     "alias": "Length of Pipe Cleaned (FT)",
     "domain": null
    }
   ],
   "indexes": [
    {
     "name": "R771_SDE_ROWID_UK",
     "fields": "OBJECTID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    },
    {
     "name": "GDB_5848_rel_glo",
     "fields": "rel_globalid",
     "isAscending": true,
     "isUnique": false,
     "description": ""
    },
    {
     "name": "UUID_771",
     "fields": "GlobalID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    }
   ],
   "subtypes": [],
   "relationships": [],
   "capabilities": "Query,Map,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": true
   },
   "dateFieldsTimeReference": null,
   "preferredTimeReference": null,
   "datesInUnknownTimezone": false,
   "hasMetadata": true,
   "isDataArchived": false,
   "archivingInfo": {
    "supportsQueryWithHistoricMoment": false,
    "startArchivingMoment": -1
   },
   "serviceItemId": "92e3e55a570646aa8c761311234c1975"
  },
  {
   "currentVersion": 11.5,
   "cimVersion": "3.5.0",
   "id": 4,
   "name": "SDC_Condition",
   "type": "Table",
   "description": null,
   "copyrightText": null,
   "hasAttachments": false,
   "htmlPopupType": "esriServerHTMLPopupTypeNone",
   "displayField": "safety_score2",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "OBJECTID",
     "type": "esriFieldTypeOID",
     "alias": "OBJECTID",
     "domain": null
    },
    {
     "name": "safety_score2",
     "type": "esriFieldTypeString",
     "alias": "Safety Score",
     "length": 75,
     "domain": {
      "type": "codedValue",
      "name": "dOSDMSafety_Score",
      "description": "OSDM Safety score related to structure",
      "codedValues": [
       {
        "name": "No Safety Hazard Observed",
        "code": "NR"
       },
       {
        "name": "Low Risk Safety Hazard Observed",
        "code": "LR"
       },
       {
        "name": "Moderate Risk Safety Hazard Observed",
        "code": "MR"
       },
       {
        "name": "Significant/High Risk Safety Hazard Observed",
        "code": "SH"
       },
       {
        "name": "Severe/Immediate Risk Safety Hazard Observed",
        "code": "SI"
       },
       {
        "name": "Could not evaluate",
        "code": "NE"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "blockage2",
     "type": "esriFieldTypeString",
     "alias": "Blockage Extent",
     "length": 75,
     "domain": {
      "type": "codedValue",
      "name": "dOSDM_Blockage",
      "description": "Blockage Description",
      "codedValues": [
       {
        "name": "0% - 25% None to Little Blockage",
        "code": "LB"
       },
       {
        "name": "26% to 75% Blockage",
        "code": "MB"
       },
       {
        "name": "Greater than 76% Blockage",
        "code": "HB"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "ConvRepairEval2",
     "type": "esriFieldTypeString",
     "alias": "Repair Assessment Indicator",
     "length": 75,
     "domain": {
      "type": "codedValue",
      "name": "dOSDM_RepairRec",
      "description": "Repair Recommendations",
      "codedValues": [
       {
        "name": "No Repairs Recommended",
        "code": "NA"
       },
       {
        "name": "Significant Repairs Recommended",
        "code": "S"
       },
       {
        "name": "Moderate Repairs Recommended",
        "code": "M"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "assess_comments2",
     "type": "esriFieldTypeString",
     "alias": "Assesment Comments",
     "length": 255,
     "domain": null
    },
    {
     "name": "assess_date2",
     "type": "esriFieldTypeDate",
     "alias": "Assement Date",
     "length": 8,
     "domain": null
    },
    {
     "name": "rel_globalid",
     "type": "esriFieldTypeGUID",
     "alias": "REL_GLOBALID",
     "length": 38,
     "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
    },
    {
     "name": "GlobalID",
     "type": "esriFieldTypeGlobalID",
     "alias": "GlobalID",
     "length": 38,
     "domain": null
    },
    {
     "name": "VideoPipeInsp",
     "type": "esriFieldTypeString",
     "alias": "Video Pipe Inspection",
     "length": 255,
     "domain": {
      "type": "codedValue",
      "name": "d_Boolean",
      "description": "Boolean (Yes/No/NA",
      "codedValues": [
       {
        "name": "Yes",
        "code": "Y"
       },
       {
        "name": "No",
        "code": "N"
       },
       {
        "name": "N/A",
        "code": "NA"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "VideoPipeInspDate",
     "type": "esriFieldTypeDate",
     "alias": "Video Pipe Inspection Date",
     "length": 8,
     "domain": null
    },
    {
     "name": "Length_Pipe_Insp",
     "type": "esriFieldTypeDouble",
     "alias": "Length of Pipe Inspected (FT)",
     "domain": null
    }
   ],
   "indexes": [
    {
     "name": "R772_SDE_ROWID_UK",
     "fields": "OBJECTID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    },
    {
     "name": "GDB_5849_rel_glo",
     "fields": "rel_globalid",
     "isAscending": true,
     "isUnique": false,
     "description": ""
    },
    {
     "name": "UUID_772",
     "fields": "GlobalID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    }
   ],
   "subtypes": [],
   "relationships": [],
   "capabilities": "Query,Map,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": true
   },
   "dateFieldsTimeReference": null,
   "preferredTimeReference": null,
   "datesInUnknownTimezone": false,
   "hasMetadata": true,
   "isDataArchived": false,
   "archivingInfo": {
    "supportsQueryWithHistoricMoment": false,
    "startArchivingMoment": -1
   },
   "serviceItemId": "92e3e55a570646aa8c761311234c1975"
  },
  {
   "currentVersion": 11.5,
   "cimVersion": "3.5.0",
   "id": 5,
   "name": "SDC_Repairs",
   "type": "Table",
   "description": null,
   "copyrightText": null,
   "hasAttachments": false,
   "htmlPopupType": "esriServerHTMLPopupTypeNone",
   "displayField": "created_user",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "OBJECTID",
     "type": "esriFieldTypeOID",
     "alias": "OBJECTID",
     "domain": null
    },
    {
     "name": "REL_GUID",
     "type": "esriFieldTypeGUID",
     "alias": "REL_GUID",
     "length": 38,
     "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
    },
    {
     "name": "Conv_RepairResp3",
     "type": "esriFieldTypeString",
     "alias": "Repair Responsibility",
     "length": 255,
     "domain": {
      "type": "codedValue",
      "name": "dOSDM_MaintResp",
      "description": "Maintenance Responsibility",
      "codedValues": [
       {
        "name": "Contractor 1",
        "code": "C1"
       },
       {
        "name": "Contractor 2",
        "code": "C2"
       },
       {
        "name": "Contractor 3",
        "code": "C3"
       },
       {
        "name": "Clean Water Partnership",
        "code": "CWP"
       },
       {
        "name": "In-House",
        "code": "IN"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "Conv_RepairDate3",
     "type": "esriFieldTypeDate",
     "alias": "Repair Date",
     "length": 8,
     "domain": null
    },
    {
     "name": "Conv_Repair_Issue3",
     "type": "esriFieldTypeString",
     "alias": "Repair Issue",
     "length": 255,
     "domain": {
      "type": "codedValue",
      "name": "dOSDMConvRepairIssue",
      "description": "OSDM Conveyance Repair Issues",
      "codedValues": [
       {
        "name": "Replace - Upgrade",
        "code": "RU"
       },
       {
        "name": "Reset",
        "code": "RS"
       },
       {
        "name": "Replace",
        "code": "RP"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "Conv_RepairNotes3",
     "type": "esriFieldTypeString",
     "alias": "Repair Notes",
     "length": 255,
     "domain": null
    },
    {
     "name": "GlobalID",
     "type": "esriFieldTypeGlobalID",
     "alias": "GlobalID",
     "length": 38,
     "domain": null
    },
    {
     "name": "SR_NOb3",
     "type": "esriFieldTypeString",
     "alias": "Service Request Number",
     "length": 11,
     "domain": null
    },
    {
     "name": "Material_PipeReplace",
     "type": "esriFieldTypeString",
     "alias": "Material of Replaced Pipe",
     "length": 255,
     "domain": {
      "type": "codedValue",
      "name": "dStormDrain_ConveyanceMaterial",
      "description": "Conveyance Material Type",
      "codedValues": [
       {
        "name": "Asphalt Coated Corrugated Metal Pipe",
        "code": "ACCMP"
       },
       {
        "name": "Aluminum Spiral Rib Pipe",
        "code": "ASRP"
       },
       {
        "name": "Bituminous Coated Corrugated Metal Pipe",
        "code": "BCCMP"
       },
       {
        "name": "Cast Iron Pipe",
        "code": "CIP"
       },
       {
        "name": "Corrugated Metal Pipe",
        "code": "CMP"
       },
       {
        "name": "Concrete",
        "code": "CONC"
       },
       {
        "name": "High Density Polyethylene",
        "code": "HDPE"
       },
       {
        "name": "Other",
        "code": "OTH"
       },
       {
        "name": "Polyvinyl Chloride (PVC) Pipe",
        "code": "PVC"
       },
       {
        "name": "Reinforced Concrete Pipe",
        "code": "RCP"
       },
       {
        "name": "Structural Plate Pipe",
        "code": "SPP"
       },
       {
        "name": "Stream",
        "code": "STR"
       },
       {
        "name": "Terracotta Pipe",
        "code": "TCP"
       },
       {
        "name": "Unknown",
        "code": "UNK"
       },
       {
        "name": "Vitrified Clay",
        "code": "VC"
       },
       {
        "name": "Vegetated Channel",
        "code": "VEG"
       },
       {
        "name": "Perforated PVC",
        "code": "PPVC"
       },
       {
        "name": "Ductile Iron",
        "code": "DI"
       },
       {
        "name": "Earthen or soil formed natural channel",
        "code": "ESNC"
       },
       {
        "name": "Mowed, short grass, maintained channel",
        "code": "MGMC"
       },
       {
        "name": "Riprap",
        "code": "RR"
       },
       {
        "name": "Tall grass, unmaintained channel",
        "code": "TGUC"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "Length_PipeReplace",
     "type": "esriFieldTypeDouble",
     "alias": "Length of Replaced Pipe  (FT)",
     "domain": null
    }
   ],
   "indexes": [
    {
     "name": "R773_SDE_ROWID_UK",
     "fields": "OBJECTID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    },
    {
     "name": "GDB_5850_REL_GUI",
     "fields": "REL_GUID",
     "isAscending": true,
     "isUnique": false,
     "description": ""
    },
    {
     "name": "UUID_773",
     "fields": "GlobalID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    }
   ],
   "subtypes": [],
   "relationships": [],
   "capabilities": "Query,Map,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": true
   },
   "dateFieldsTimeReference": null,
   "preferredTimeReference": null,
   "datesInUnknownTimezone": false,
   "hasMetadata": true,
   "isDataArchived": false,
   "archivingInfo": {
    "supportsQueryWithHistoricMoment": false,
    "startArchivingMoment": -1
   },
   "serviceItemId": "92e3e55a570646aa8c761311234c1975"
  },
  {
   "currentVersion": 11.5,
   "cimVersion": "3.5.0",
   "id": 6,
   "name": "SDS_Cleaning",
   "type": "Table",
   "description": null,
   "copyrightText": null,
   "hasAttachments": false,
   "htmlPopupType": "esriServerHTMLPopupTypeNone",
   "displayField": "inlet_cleaned",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "OBJECTID",
     "type": "esriFieldTypeOID",
     "alias": "OBJECTID",
     "domain": null
    },
    {
     "name": "rel_globalid",
     "type": "esriFieldTypeGUID",
     "alias": "KCI Guid",
     "length": 38,
     "domain": null
    },
    {
     "name": "inlet_cleaned",
     "type": "esriFieldTypeString",
     "alias": "Inlet Cleaned",
     "length": 50,
     "domain": {
      "type": "codedValue",
      "name": "d_Boolean",
      "description": "Boolean (Yes/No/NA",
      "codedValues": [
       {
        "name": "Yes",
        "code": "Y"
       },
       {
        "name": "No",
        "code": "N"
       },
       {
        "name": "N/A",
        "code": "NA"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "st_date_cleaned",
     "type": "esriFieldTypeDate",
     "alias": "Date Cleaned",
     "length": 8,
     "domain": null
    },
    {
     "name": "st_comments",
     "type": "esriFieldTypeString",
     "alias": "Comments",
     "length": 1000,
     "domain": null
    },
    {
     "name": "meets_criteria_yn",
     "type": "esriFieldTypeString",
     "alias": "Meets Criteria",
     "length": 50,
     "domain": {
      "type": "codedValue",
      "name": "d_Boolean",
      "description": "Boolean (Yes/No/NA",
      "codedValues": [
       {
        "name": "Yes",
        "code": "Y"
       },
       {
        "name": "No",
        "code": "N"
       },
       {
        "name": "N/A",
        "code": "NA"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "GlobalID",
     "type": "esriFieldTypeGlobalID",
     "alias": "GlobalID",
     "length": 38,
     "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": "R774_SDE_ROWID_UK",
     "fields": "OBJECTID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    },
    {
     "name": "GDB_5851_rel_glo",
     "fields": "rel_globalid",
     "isAscending": true,
     "isUnique": false,
     "description": ""
    },
    {
     "name": "UUID_774",
     "fields": "GlobalID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    }
   ],
   "subtypes": [],
   "relationships": [],
   "capabilities": "Query,Map,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": true
   },
   "dateFieldsTimeReference": null,
   "preferredTimeReference": null,
   "datesInUnknownTimezone": false,
   "hasMetadata": true,
   "isDataArchived": false,
   "archivingInfo": {
    "supportsQueryWithHistoricMoment": false,
    "startArchivingMoment": -1
   },
   "serviceItemId": "92e3e55a570646aa8c761311234c1975"
  },
  {
   "currentVersion": 11.5,
   "cimVersion": "3.5.0",
   "id": 7,
   "name": "SDS_Condition",
   "type": "Table",
   "description": null,
   "copyrightText": null,
   "hasAttachments": false,
   "htmlPopupType": "esriServerHTMLPopupTypeNone",
   "displayField": "safety_score",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "OBJECTID",
     "type": "esriFieldTypeOID",
     "alias": "OBJECTID",
     "domain": null
    },
    {
     "name": "safety_score",
     "type": "esriFieldTypeString",
     "alias": "Safety Score",
     "length": 75,
     "domain": {
      "type": "codedValue",
      "name": "dOSDMSafety_Score",
      "description": "OSDM Safety score related to structure",
      "codedValues": [
       {
        "name": "No Safety Hazard Observed",
        "code": "NR"
       },
       {
        "name": "Low Risk Safety Hazard Observed",
        "code": "LR"
       },
       {
        "name": "Moderate Risk Safety Hazard Observed",
        "code": "MR"
       },
       {
        "name": "Significant/High Risk Safety Hazard Observed",
        "code": "SH"
       },
       {
        "name": "Severe/Immediate Risk Safety Hazard Observed",
        "code": "SI"
       },
       {
        "name": "Could not evaluate",
        "code": "NE"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "blockage",
     "type": "esriFieldTypeString",
     "alias": "Blockage Extent",
     "length": 75,
     "domain": {
      "type": "codedValue",
      "name": "dOSDM_Blockage",
      "description": "Blockage Description",
      "codedValues": [
       {
        "name": "0% - 25% None to Little Blockage",
        "code": "LB"
       },
       {
        "name": "26% to 75% Blockage",
        "code": "MB"
       },
       {
        "name": "Greater than 76% Blockage",
        "code": "HB"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "RepairEval",
     "type": "esriFieldTypeString",
     "alias": "Repair Assessment Indicator",
     "length": 75,
     "domain": {
      "type": "codedValue",
      "name": "dOSDM_RepairRec",
      "description": "Repair Recommendations",
      "codedValues": [
       {
        "name": "No Repairs Recommended",
        "code": "NA"
       },
       {
        "name": "Significant Repairs Recommended",
        "code": "S"
       },
       {
        "name": "Moderate Repairs Recommended",
        "code": "M"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "assess_comments",
     "type": "esriFieldTypeString",
     "alias": "Assesment Comments",
     "length": 255,
     "domain": null
    },
    {
     "name": "assess_date",
     "type": "esriFieldTypeDate",
     "alias": "Assessment Date",
     "length": 8,
     "domain": null
    },
    {
     "name": "rel_globalid",
     "type": "esriFieldTypeGUID",
     "alias": "KCI Guid",
     "length": 38,
     "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
    },
    {
     "name": "top_stable",
     "type": "esriFieldTypeString",
     "alias": "Top is Stable",
     "length": 25,
     "domain": null
    },
    {
     "name": "LAB_GUID",
     "type": "esriFieldTypeGUID",
     "alias": "Lab Guid",
     "length": 38,
     "domain": null
    },
    {
     "name": "GlobalID",
     "type": "esriFieldTypeGlobalID",
     "alias": "GlobalID",
     "length": 38,
     "domain": null
    }
   ],
   "indexes": [
    {
     "name": "R775_SDE_ROWID_UK",
     "fields": "OBJECTID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    },
    {
     "name": "GDB_5852_rel_glo",
     "fields": "rel_globalid",
     "isAscending": true,
     "isUnique": false,
     "description": ""
    },
    {
     "name": "UUID_775",
     "fields": "GlobalID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    }
   ],
   "subtypes": [],
   "relationships": [],
   "capabilities": "Query,Map,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": true
   },
   "dateFieldsTimeReference": null,
   "preferredTimeReference": null,
   "datesInUnknownTimezone": false,
   "hasMetadata": true,
   "isDataArchived": false,
   "archivingInfo": {
    "supportsQueryWithHistoricMoment": false,
    "startArchivingMoment": -1
   },
   "serviceItemId": "92e3e55a570646aa8c761311234c1975"
  },
  {
   "currentVersion": 11.5,
   "cimVersion": "3.5.0",
   "id": 8,
   "name": "SDS_Repairs",
   "type": "Table",
   "description": null,
   "copyrightText": null,
   "hasAttachments": false,
   "htmlPopupType": "esriServerHTMLPopupTypeNone",
   "displayField": "ST_RepairDate3",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "OBJECTID",
     "type": "esriFieldTypeOID",
     "alias": "OBJECTID",
     "domain": null
    },
    {
     "name": "ST_RepairDate3",
     "type": "esriFieldTypeDate",
     "alias": "Repair Date",
     "length": 8,
     "domain": null
    },
    {
     "name": "ST_Repair_Issue3",
     "type": "esriFieldTypeString",
     "alias": "Repair Issue",
     "length": 255,
     "domain": {
      "type": "codedValue",
      "name": "dOSDMStructRepairIssue",
      "description": "OSDM Structure Repair Issues",
      "codedValues": [
       {
        "name": "Total Rebuild",
        "code": "TR"
       },
       {
        "name": "Brick Work - Parging",
        "code": "BWP"
       },
       {
        "name": "Pipe Connection",
        "code": "PC"
       },
       {
        "name": "Crushed Top Slab",
        "code": "CTS"
       },
       {
        "name": "Reset Top Slab",
        "code": "RS"
       },
       {
        "name": "Other",
        "code": "OTH"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "ST_RepairNotes3",
     "type": "esriFieldTypeString",
     "alias": "Repair Notes",
     "length": 255,
     "domain": null
    },
    {
     "name": "ST_RepairResp3",
     "type": "esriFieldTypeString",
     "alias": "Repair Responsibility",
     "length": 255,
     "domain": {
      "type": "codedValue",
      "name": "dOSDM_MaintResp",
      "description": "Maintenance Responsibility",
      "codedValues": [
       {
        "name": "Contractor 1",
        "code": "C1"
       },
       {
        "name": "Contractor 2",
        "code": "C2"
       },
       {
        "name": "Contractor 3",
        "code": "C3"
       },
       {
        "name": "Clean Water Partnership",
        "code": "CWP"
       },
       {
        "name": "In-House",
        "code": "IN"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "REL_GUID",
     "type": "esriFieldTypeGUID",
     "alias": "REL_GUID",
     "length": 38,
     "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
    },
    {
     "name": "GlobalID",
     "type": "esriFieldTypeGlobalID",
     "alias": "GlobalID",
     "length": 38,
     "domain": null
    },
    {
     "name": "SR3",
     "type": "esriFieldTypeString",
     "alias": "Service Request Number",
     "length": 11,
     "domain": null
    }
   ],
   "indexes": [
    {
     "name": "R776_SDE_ROWID_UK",
     "fields": "OBJECTID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    },
    {
     "name": "UUID_776",
     "fields": "GlobalID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    },
    {
     "name": "GDB_5853_REL_GUI",
     "fields": "REL_GUID",
     "isAscending": true,
     "isUnique": false,
     "description": ""
    }
   ],
   "subtypes": [],
   "relationships": [],
   "capabilities": "Query,Map,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": true
   },
   "dateFieldsTimeReference": null,
   "preferredTimeReference": null,
   "datesInUnknownTimezone": false,
   "hasMetadata": true,
   "isDataArchived": false,
   "archivingInfo": {
    "supportsQueryWithHistoricMoment": false,
    "startArchivingMoment": -1
   },
   "serviceItemId": "92e3e55a570646aa8c761311234c1975"
  }
 ]
}