{
 "layers": [
  {
   "currentVersion": 11.5,
   "cimVersion": "3.5.0",
   "id": 2,
   "name": "Outfall Drainage Area",
   "type": "Feature Layer",
   "parentLayer": null,
   "defaultVisibility": true,
   "minScale": 0,
   "maxScale": 0,
   "canScaleSymbols": false,
   "geometryType": "esriGeometryPolygon",
   "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.",
   "copyrightText": "",
   "editFieldsInfo": {
    "creationDateField": "created_date",
    "creatorField": "created_user",
    "editDateField": "last_edited_date",
    "editorField": "last_edited_user"
   },
   "ownershipBasedAccessControlForFeatures": null,
   "syncCanReturnChanges": false,
   "relationships": [],
   "isDataVersioned": false,
   "isDataArchived": false,
   "infoInEstimates": [
    "extent",
    "count"
   ],
   "isDataBranchVersioned": false,
   "isDataReplicaTracked": false,
   "isCoGoEnabled": false,
   "modelName": "GP_248342601",
   "supportsRollbackOnFailureParameter": false,
   "archivingInfo": {
    "supportsQueryWithHistoricMoment": false,
    "startArchivingMoment": -1
   },
   "supportsStatistics": true,
   "supportsExceedsLimitStatistics": true,
   "supportsAdvancedQueries": true,
   "supportsValidateSQL": true,
   "supportsCoordinatesQuantization": true,
   "supportsQuantizationEditMode": true,
   "supportsCalculate": true,
   "supportsASyncCalculate": true,
   "supportsDatumTransformation": true,
   "advancedQueryCapabilities": {
    "supportsPagination": true,
    "supportsQueryWithDistance": true,
    "supportsReturningQueryExtent": true,
    "supportsStatistics": true,
    "supportsPercentileStatistics": true,
    "supportsHavingClause": true,
    "supportsOrderBy": true,
    "supportsDistinct": true,
    "supportsCountDistinct": true,
    "supportsAdvancedQueryRelated": true,
    "supportsQueryRelatedPagination": true,
    "supportsCurrentUserQueries": true,
    "supportsFullTextSearch": true,
    "fullTextSearchCapabilities": {
     "supportsSearchOperator": true,
     "supportsOperator": false,
     "supportsSqlExpressionInFullText": true
    },
    "fullTextSearchableFields": [],
    "supportsQueryWithResultType": true,
    "supportsReturningGeometryCentroid": true,
    "supportsReturningGeometryEnvelope": true,
    "supportsSqlExpression": true,
    "supportsQueryWithDatumTransformation": true,
    "supportsLod": false,
    "supportsQueryWithLodSR": false,
    "supportsQueryAnalytic": true,
    "supportsTrueCurve": true,
    "supportedCurveTypes": [
     "esriGeometryCircularArc",
     "esriGeometryEllipticArc",
     "esriGeometryBezier3Curve"
    ],
    "supportsQueryWithCacheHint": false
   },
   "advancedQueryAnalyticCapabilities": {
    "supportsLinearRegression": true,
    "supportsAsync": true,
    "supportsPercentileAnalytic": true
   },
   "advancedEditingCapabilities": {
    "supportedSqlFormatsInCalculate": [
     "standard"
    ],
    "supportsAsyncApplyEdits": true,
    "supportsApplyEditsbyUploadID": true,
    "supportedApplyEditsUploadIDFormats": "JSON,PBF"
   },
   "hasGeometryProperties": true,
   "geometryProperties": {
    "shapeAreaFieldName": "Shape__Area",
    "shapeLengthFieldName": "Shape__Length",
    "units": "esriFeet"
   },
   "hasMetadata": 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
    }
   },
   "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
   },
   "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
   },
   "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
   },
   "hasM": false,
   "hasZ": false,
   "allowGeometryUpdates": true,
   "allowTrueCurvesUpdates": true,
   "onlyAllowTrueCurveUpdatesByTrueCurveClients": true,
   "hasAttachments": false,
   "supportsApplyEditsWithGlobalIds": true,
   "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText",
   "objectIdField": "OBJECTID",
   "globalIdField": "GlobalID",
   "displayField": "MDE_GDB_ID",
   "typeIdField": "",
   "subtypeField": "",
   "fields": [
    {
     "name": "OBJECTID",
     "type": "esriFieldTypeOID",
     "alias": "OBJECTID",
     "domain": null,
     "editable": false,
     "nullable": false,
     "defaultValue": null,
     "modelName": "OBJECTID"
    },
    {
     "name": "MDE_GDB_ID",
     "type": "esriFieldTypeString",
     "alias": "MDE_GDB_ID",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 13,
     "defaultValue": null,
     "modelName": "MDE_GDB_ID"
    },
    {
     "name": "MDE_GDB_ID_Outfall",
     "type": "esriFieldTypeString",
     "alias": "MDE GDB ID of Outfall",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 13,
     "defaultValue": null,
     "modelName": "MDE_GDB_ID_Outfall"
    },
    {
     "name": "OUTFALL_DRAIN_AREA",
     "type": "esriFieldTypeDouble",
     "alias": "Drainage area (acres) to outfall",
     "domain": null,
     "editable": true,
     "nullable": true,
     "defaultValue": null,
     "modelName": "OUTFALL_DRAIN_AREA"
    },
    {
     "name": "SD_Number",
     "type": "esriFieldTypeString",
     "alias": "SD Number",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 13,
     "defaultValue": null,
     "modelName": "SD_Number"
    },
    {
     "name": "GEN_COMMENTS",
     "type": "esriFieldTypeString",
     "alias": "General comments",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 255,
     "defaultValue": null,
     "modelName": "GEN_COMMENTS"
    },
    {
     "name": "created_user",
     "type": "esriFieldTypeString",
     "alias": "Created by",
     "domain": null,
     "editable": false,
     "nullable": true,
     "length": 255,
     "defaultValue": null,
     "modelName": "created_user"
    },
    {
     "name": "created_date",
     "type": "esriFieldTypeDate",
     "alias": "Date created",
     "domain": null,
     "editable": false,
     "nullable": true,
     "length": 8,
     "defaultValue": null,
     "modelName": "created_date"
    },
    {
     "name": "last_edited_user",
     "type": "esriFieldTypeString",
     "alias": "Last edited by",
     "domain": null,
     "editable": false,
     "nullable": true,
     "length": 255,
     "defaultValue": null,
     "modelName": "last_edited_user"
    },
    {
     "name": "last_edited_date",
     "type": "esriFieldTypeDate",
     "alias": "Last edited date",
     "domain": null,
     "editable": false,
     "nullable": true,
     "length": 8,
     "defaultValue": null,
     "modelName": "last_edited_date"
    },
    {
     "name": "GlobalID",
     "type": "esriFieldTypeGlobalID",
     "alias": "GlobalID",
     "domain": null,
     "editable": false,
     "nullable": false,
     "length": 38,
     "defaultValue": null,
     "modelName": "GlobalID"
    },
    {
     "name": "Shape__Area",
     "type": "esriFieldTypeDouble",
     "alias": "Shape.STArea()",
     "domain": null,
     "editable": false,
     "nullable": true,
     "defaultValue": null,
     "modelName": "Shape.STArea()",
     "required": true
    },
    {
     "name": "Shape__Length",
     "type": "esriFieldTypeDouble",
     "alias": "Shape.STLength()",
     "domain": null,
     "editable": false,
     "nullable": true,
     "defaultValue": null,
     "modelName": "Shape.STLength()",
     "required": true
    }
   ],
   "geometryField": {
    "name": "Shape",
    "type": "esriFieldTypeGeometry",
    "alias": "Shape",
    "domain": null,
    "editable": true,
    "nullable": true,
    "defaultValue": null,
    "modelName": "Shape"
   },
   "indexes": [
    {
     "name": "R502_pk",
     "isAscending": true,
     "isUnique": true,
     "description": "",
     "fields": "OBJECTID"
    },
    {
     "name": "UUID_502",
     "isAscending": true,
     "isUnique": true,
     "description": "",
     "fields": "GlobalID"
    },
    {
     "name": "GDB_3411_MDE_GDB",
     "isAscending": true,
     "isUnique": false,
     "description": "",
     "fields": "MDE_GDB_ID"
    },
    {
     "name": "S233_idx",
     "isAscending": true,
     "isUnique": true,
     "description": "",
     "fields": "Shape"
    }
   ],
   "datesInUnknownTimezone": false,
   "dateFieldsTimeReference": {
    "timeZone": "UTC",
    "timeZoneIANA": "Etc/UTC",
    "respectsDaylightSaving": false
   },
   "preferredTimeReference": null,
   "types": [],
   "templates": [
    {
     "name": "Outfall Drainage Area",
     "description": "",
     "prototype": {
      "attributes": {
       "SD_Number": null,
       "GEN_COMMENTS": null,
       "MDE_GDB_ID": null,
       "MDE_GDB_ID_Outfall": null,
       "OUTFALL_DRAIN_AREA": null
      }
     },
     "drawingTool": "esriFeatureEditToolPolygon"
    }
   ],
   "maxRecordCount": 2000,
   "supportedQueryFormats": "JSON, geoJSON, PBF",
   "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson",
   "capabilities": "Query,Create,Update,Delete,Uploads,Editing",
   "useStandardizedQueries": true,
   "bigIntegerRestrictedTo53Bits": true,
   "supportedSpatialRelationships": [
    "esriSpatialRelIntersects",
    "esriSpatialRelContains",
    "esriSpatialRelCrosses",
    "esriSpatialRelEnvelopeIntersects",
    "esriSpatialRelIndexIntersects",
    "esriSpatialRelOverlaps",
    "esriSpatialRelTouches",
    "esriSpatialRelWithin",
    "esriSpatialRelRelation"
   ],
   "supportsAppend": true,
   "supportedAppendFormats": "FILEGDB,PBF",
   "standardMaxRecordCount": 4000,
   "tileMaxRecordCount": 4000,
   "standardMaxRecordCountNoGeometry": 32000,
   "maxRecordCountFactor": 1,
   "serviceItemId": "1d37896af2b642789f9d73cc050f3ca6"
  }
 ],
 "tables": [
  {
   "currentVersion": 11.5,
   "cimVersion": "3.5.0",
   "id": 3,
   "name": "SDC_Cleaning",
   "type": "Table",
   "description": "",
   "copyrightText": "",
   "editFieldsInfo": {
    "creationDateField": "created_date",
    "creatorField": "created_user",
    "editDateField": "last_edited_date",
    "editorField": "last_edited_user"
   },
   "ownershipBasedAccessControlForFeatures": null,
   "syncCanReturnChanges": false,
   "relationships": [],
   "isDataVersioned": false,
   "isDataArchived": false,
   "infoInEstimates": [
    "count"
   ],
   "isDataBranchVersioned": false,
   "isDataReplicaTracked": false,
   "isCoGoEnabled": false,
   "supportsRollbackOnFailureParameter": true,
   "archivingInfo": {
    "supportsQueryWithHistoricMoment": false,
    "startArchivingMoment": -1
   },
   "supportsStatistics": true,
   "supportsExceedsLimitStatistics": true,
   "supportsAdvancedQueries": true,
   "supportsValidateSQL": true,
   "supportsCoordinatesQuantization": false,
   "supportsCalculate": true,
   "supportsASyncCalculate": true,
   "advancedQueryCapabilities": {
    "supportsPagination": true,
    "supportsQueryWithDistance": true,
    "supportsReturningQueryExtent": true,
    "supportsStatistics": true,
    "supportsPercentileStatistics": true,
    "supportsHavingClause": true,
    "supportsOrderBy": true,
    "supportsDistinct": true,
    "supportsCountDistinct": true,
    "supportsAdvancedQueryRelated": true,
    "supportsQueryRelatedPagination": true,
    "supportsCurrentUserQueries": true,
    "supportsFullTextSearch": true,
    "fullTextSearchCapabilities": {
     "supportsSearchOperator": true,
     "supportsOperator": false,
     "supportsSqlExpressionInFullText": true
    },
    "fullTextSearchableFields": [],
    "supportsQueryWithResultType": true,
    "supportsReturningGeometryCentroid": false,
    "supportsReturningGeometryEnvelope": false,
    "supportsSqlExpression": true,
    "supportsLod": false,
    "supportsQueryWithLodSR": false,
    "supportsQueryAnalytic": true,
    "supportsQueryWithCacheHint": false
   },
   "advancedQueryAnalyticCapabilities": {
    "supportsLinearRegression": true,
    "supportsAsync": true,
    "supportsPercentileAnalytic": true
   },
   "advancedEditingCapabilities": {
    "supportedSqlFormatsInCalculate": [
     "standard"
    ],
    "supportsAsyncApplyEdits": true,
    "supportsApplyEditsbyUploadID": true,
    "supportedApplyEditsUploadIDFormats": "JSON,PBF"
   },
   "hasMetadata": true,
   "hasAttachments": false,
   "supportsApplyEditsWithGlobalIds": true,
   "htmlPopupType": "esriServerHTMLPopupTypeNone",
   "objectIdField": "OBJECTID",
   "globalIdField": "GlobalID",
   "displayField": "conv_pipe_cleaned",
   "typeIdField": "",
   "subtypeField": "",
   "fields": [
    {
     "name": "OBJECTID",
     "type": "esriFieldTypeOID",
     "alias": "OBJECTID",
     "domain": null,
     "editable": false,
     "nullable": false,
     "defaultValue": null,
     "modelName": "OBJECTID"
    },
    {
     "name": "rel_globalid",
     "type": "esriFieldTypeGUID",
     "alias": "REL_GLOBALID",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 38,
     "defaultValue": null,
     "modelName": "rel_globalid"
    },
    {
     "name": "conv_pipe_cleaned",
     "type": "esriFieldTypeString",
     "alias": "Pipe Cleaned",
     "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"
     },
     "editable": true,
     "nullable": true,
     "length": 50,
     "defaultValue": null,
     "modelName": "inlet_cleaned"
    },
    {
     "name": "conv_date_cleaned",
     "type": "esriFieldTypeDate",
     "alias": "Date Cleaned",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 8,
     "defaultValue": null,
     "modelName": "date_last_cleaned"
    },
    {
     "name": "Conv_comments",
     "type": "esriFieldTypeString",
     "alias": "Comments",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 1000,
     "defaultValue": null,
     "modelName": "comments"
    },
    {
     "name": "C_meets_criteria_yn",
     "type": "esriFieldTypeString",
     "alias": "Meets Criteria",
     "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"
     },
     "editable": true,
     "nullable": true,
     "length": 50,
     "defaultValue": null,
     "modelName": "meets_criteria_yn"
    },
    {
     "name": "GlobalID",
     "type": "esriFieldTypeGlobalID",
     "alias": "GlobalID",
     "domain": null,
     "editable": false,
     "nullable": false,
     "length": 38,
     "defaultValue": null,
     "modelName": "GlobalID"
    },
    {
     "name": "created_user",
     "type": "esriFieldTypeString",
     "alias": "created_user",
     "domain": null,
     "editable": false,
     "nullable": true,
     "length": 255,
     "defaultValue": null,
     "modelName": "created_user"
    },
    {
     "name": "created_date",
     "type": "esriFieldTypeDate",
     "alias": "created_date",
     "domain": null,
     "editable": false,
     "nullable": true,
     "length": 8,
     "defaultValue": null,
     "modelName": "created_date"
    },
    {
     "name": "last_edited_user",
     "type": "esriFieldTypeString",
     "alias": "last_edited_user",
     "domain": null,
     "editable": false,
     "nullable": true,
     "length": 255,
     "defaultValue": null,
     "modelName": "last_edited_user"
    },
    {
     "name": "last_edited_date",
     "type": "esriFieldTypeDate",
     "alias": "last_edited_date",
     "domain": null,
     "editable": false,
     "nullable": true,
     "length": 8,
     "defaultValue": null,
     "modelName": "last_edited_date"
    },
    {
     "name": "Length_Pipe_Cleaned",
     "type": "esriFieldTypeDouble",
     "alias": "Length of Pipe Cleaned (FT)",
     "domain": null,
     "editable": true,
     "nullable": true,
     "defaultValue": null,
     "modelName": "Length_Pipe_Cleaned"
    }
   ],
   "indexes": [
    {
     "name": "R771_SDE_ROWID_UK",
     "isAscending": true,
     "isUnique": true,
     "description": "",
     "fields": "OBJECTID"
    },
    {
     "name": "GDB_5848_rel_glo",
     "isAscending": true,
     "isUnique": false,
     "description": "",
     "fields": "rel_globalid"
    },
    {
     "name": "UUID_771",
     "isAscending": true,
     "isUnique": true,
     "description": "",
     "fields": "GlobalID"
    }
   ],
   "datesInUnknownTimezone": false,
   "dateFieldsTimeReference": {
    "timeZone": "UTC",
    "timeZoneIANA": "Etc/UTC",
    "respectsDaylightSaving": false
   },
   "preferredTimeReference": null,
   "types": [],
   "templates": [
    {
     "name": "SDC_Cleaning",
     "description": "",
     "prototype": {
      "attributes": {
       "C_meets_criteria_yn": null,
       "Length_Pipe_Cleaned": null,
       "rel_globalid": null,
       "conv_pipe_cleaned": null,
       "conv_date_cleaned": null,
       "Conv_comments": null
      }
     },
     "drawingTool": "esriFeatureEditToolNone"
    }
   ],
   "maxRecordCount": 2000,
   "supportedQueryFormats": "JSON, geoJSON, PBF",
   "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson",
   "capabilities": "Query,Create,Update,Delete,Uploads,Editing",
   "useStandardizedQueries": true,
   "bigIntegerRestrictedTo53Bits": true,
   "supportsAppend": true,
   "supportedAppendFormats": "FILEGDB,PBF",
   "standardMaxRecordCount": 32000,
   "tileMaxRecordCount": 2000,
   "maxRecordCountFactor": 1,
   "serviceItemId": "1d37896af2b642789f9d73cc050f3ca6"
  },
  {
   "currentVersion": 11.5,
   "cimVersion": "3.5.0",
   "id": 4,
   "name": "SDC_Condition",
   "type": "Table",
   "description": "",
   "copyrightText": "",
   "editFieldsInfo": {
    "creationDateField": "created_date",
    "creatorField": "created_user",
    "editDateField": "last_edited_date",
    "editorField": "last_edited_user"
   },
   "ownershipBasedAccessControlForFeatures": null,
   "syncCanReturnChanges": false,
   "relationships": [],
   "isDataVersioned": false,
   "isDataArchived": false,
   "infoInEstimates": [
    "count"
   ],
   "isDataBranchVersioned": false,
   "isDataReplicaTracked": false,
   "isCoGoEnabled": false,
   "supportsRollbackOnFailureParameter": false,
   "archivingInfo": {
    "supportsQueryWithHistoricMoment": false,
    "startArchivingMoment": -1
   },
   "supportsStatistics": true,
   "supportsExceedsLimitStatistics": true,
   "supportsAdvancedQueries": true,
   "supportsValidateSQL": true,
   "supportsCoordinatesQuantization": false,
   "supportsCalculate": true,
   "supportsASyncCalculate": true,
   "advancedQueryCapabilities": {
    "supportsPagination": true,
    "supportsQueryWithDistance": true,
    "supportsReturningQueryExtent": true,
    "supportsStatistics": true,
    "supportsPercentileStatistics": true,
    "supportsHavingClause": true,
    "supportsOrderBy": true,
    "supportsDistinct": true,
    "supportsCountDistinct": true,
    "supportsAdvancedQueryRelated": true,
    "supportsQueryRelatedPagination": true,
    "supportsCurrentUserQueries": true,
    "supportsFullTextSearch": true,
    "fullTextSearchCapabilities": {
     "supportsSearchOperator": true,
     "supportsOperator": false,
     "supportsSqlExpressionInFullText": true
    },
    "fullTextSearchableFields": [],
    "supportsQueryWithResultType": true,
    "supportsReturningGeometryCentroid": false,
    "supportsReturningGeometryEnvelope": false,
    "supportsSqlExpression": true,
    "supportsLod": false,
    "supportsQueryWithLodSR": false,
    "supportsQueryAnalytic": true,
    "supportsQueryWithCacheHint": false
   },
   "advancedQueryAnalyticCapabilities": {
    "supportsLinearRegression": true,
    "supportsAsync": true,
    "supportsPercentileAnalytic": true
   },
   "advancedEditingCapabilities": {
    "supportedSqlFormatsInCalculate": [
     "standard"
    ],
    "supportsAsyncApplyEdits": true,
    "supportsApplyEditsbyUploadID": true,
    "supportedApplyEditsUploadIDFormats": "JSON,PBF"
   },
   "hasMetadata": true,
   "hasAttachments": false,
   "supportsApplyEditsWithGlobalIds": true,
   "htmlPopupType": "esriServerHTMLPopupTypeNone",
   "objectIdField": "OBJECTID",
   "globalIdField": "GlobalID",
   "displayField": "safety_score2",
   "typeIdField": "",
   "subtypeField": "",
   "fields": [
    {
     "name": "OBJECTID",
     "type": "esriFieldTypeOID",
     "alias": "OBJECTID",
     "domain": null,
     "editable": false,
     "nullable": false,
     "defaultValue": null,
     "modelName": "OBJECTID"
    },
    {
     "name": "safety_score2",
     "type": "esriFieldTypeString",
     "alias": "Safety Score",
     "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"
     },
     "editable": true,
     "nullable": true,
     "length": 75,
     "defaultValue": null,
     "modelName": "SAFETY_SCORE"
    },
    {
     "name": "blockage2",
     "type": "esriFieldTypeString",
     "alias": "Blockage Extent",
     "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"
     },
     "editable": true,
     "nullable": true,
     "length": 75,
     "defaultValue": null,
     "modelName": "BLOCKAGE"
    },
    {
     "name": "ConvRepairEval2",
     "type": "esriFieldTypeString",
     "alias": "Repair Assessment Indicator",
     "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"
     },
     "editable": true,
     "nullable": true,
     "length": 75,
     "defaultValue": null,
     "modelName": "CONDITION"
    },
    {
     "name": "assess_comments2",
     "type": "esriFieldTypeString",
     "alias": "Assesment Comments",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 255,
     "defaultValue": null,
     "modelName": "ASSESS_COMMENTS"
    },
    {
     "name": "assess_date2",
     "type": "esriFieldTypeDate",
     "alias": "Assement Date",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 8,
     "defaultValue": null,
     "modelName": "ASSESS_DATE"
    },
    {
     "name": "rel_globalid",
     "type": "esriFieldTypeGUID",
     "alias": "REL_GLOBALID",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 38,
     "defaultValue": null,
     "modelName": "REL_GLOBALID"
    },
    {
     "name": "created_user",
     "type": "esriFieldTypeString",
     "alias": "created_user",
     "domain": null,
     "editable": false,
     "nullable": true,
     "length": 255,
     "defaultValue": null,
     "modelName": "created_user"
    },
    {
     "name": "created_date",
     "type": "esriFieldTypeDate",
     "alias": "created_date",
     "domain": null,
     "editable": false,
     "nullable": true,
     "length": 8,
     "defaultValue": null,
     "modelName": "created_date"
    },
    {
     "name": "last_edited_user",
     "type": "esriFieldTypeString",
     "alias": "last_edited_user",
     "domain": null,
     "editable": false,
     "nullable": true,
     "length": 255,
     "defaultValue": null,
     "modelName": "last_edited_user"
    },
    {
     "name": "last_edited_date",
     "type": "esriFieldTypeDate",
     "alias": "last_edited_date",
     "domain": null,
     "editable": false,
     "nullable": true,
     "length": 8,
     "defaultValue": null,
     "modelName": "last_edited_date"
    },
    {
     "name": "GlobalID",
     "type": "esriFieldTypeGlobalID",
     "alias": "GlobalID",
     "domain": null,
     "editable": false,
     "nullable": false,
     "length": 38,
     "defaultValue": null,
     "modelName": "GlobalID"
    },
    {
     "name": "VideoPipeInsp",
     "type": "esriFieldTypeString",
     "alias": "Video Pipe Inspection",
     "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"
     },
     "editable": true,
     "nullable": true,
     "length": 255,
     "defaultValue": null,
     "modelName": "VideoPipeInsp"
    },
    {
     "name": "VideoPipeInspDate",
     "type": "esriFieldTypeDate",
     "alias": "Video Pipe Inspection Date",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 8,
     "defaultValue": null,
     "modelName": "VideoPipeInspDate"
    },
    {
     "name": "Length_Pipe_Insp",
     "type": "esriFieldTypeDouble",
     "alias": "Length of Pipe Inspected (FT)",
     "domain": null,
     "editable": true,
     "nullable": true,
     "defaultValue": null,
     "modelName": "Length_Pipe_Insp"
    }
   ],
   "indexes": [
    {
     "name": "R772_SDE_ROWID_UK",
     "isAscending": true,
     "isUnique": true,
     "description": "",
     "fields": "OBJECTID"
    },
    {
     "name": "GDB_5849_rel_glo",
     "isAscending": true,
     "isUnique": false,
     "description": "",
     "fields": "rel_globalid"
    },
    {
     "name": "UUID_772",
     "isAscending": true,
     "isUnique": true,
     "description": "",
     "fields": "GlobalID"
    }
   ],
   "datesInUnknownTimezone": false,
   "dateFieldsTimeReference": {
    "timeZone": "UTC",
    "timeZoneIANA": "Etc/UTC",
    "respectsDaylightSaving": false
   },
   "preferredTimeReference": null,
   "types": [],
   "templates": [
    {
     "name": "SDC_Condition",
     "description": "",
     "prototype": {
      "attributes": {
       "VideoPipeInspDate": null,
       "VideoPipeInsp": null,
       "safety_score2": null,
       "blockage2": null,
       "ConvRepairEval2": null,
       "assess_comments2": null,
       "assess_date2": null,
       "rel_globalid": null,
       "Length_Pipe_Insp": null
      }
     },
     "drawingTool": "esriFeatureEditToolNone"
    }
   ],
   "maxRecordCount": 2000,
   "supportedQueryFormats": "JSON, geoJSON, PBF",
   "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson",
   "capabilities": "Query,Create,Update,Delete,Uploads,Editing",
   "useStandardizedQueries": true,
   "bigIntegerRestrictedTo53Bits": true,
   "supportsAppend": true,
   "supportedAppendFormats": "FILEGDB,PBF",
   "standardMaxRecordCount": 32000,
   "tileMaxRecordCount": 2000,
   "maxRecordCountFactor": 1,
   "serviceItemId": "1d37896af2b642789f9d73cc050f3ca6"
  },
  {
   "currentVersion": 11.5,
   "cimVersion": "3.5.0",
   "id": 5,
   "name": "SDC_Repairs",
   "type": "Table",
   "description": "",
   "copyrightText": "",
   "editFieldsInfo": {
    "creationDateField": "created_date",
    "creatorField": "created_user",
    "editDateField": "last_edited_date",
    "editorField": "last_edited_user"
   },
   "ownershipBasedAccessControlForFeatures": null,
   "syncCanReturnChanges": false,
   "relationships": [],
   "isDataVersioned": false,
   "isDataArchived": false,
   "infoInEstimates": [
    "count"
   ],
   "isDataBranchVersioned": false,
   "isDataReplicaTracked": false,
   "isCoGoEnabled": false,
   "supportsRollbackOnFailureParameter": false,
   "archivingInfo": {
    "supportsQueryWithHistoricMoment": false,
    "startArchivingMoment": -1
   },
   "supportsStatistics": true,
   "supportsExceedsLimitStatistics": true,
   "supportsAdvancedQueries": true,
   "supportsValidateSQL": true,
   "supportsCoordinatesQuantization": false,
   "supportsCalculate": true,
   "supportsASyncCalculate": true,
   "advancedQueryCapabilities": {
    "supportsPagination": true,
    "supportsQueryWithDistance": true,
    "supportsReturningQueryExtent": true,
    "supportsStatistics": true,
    "supportsPercentileStatistics": true,
    "supportsHavingClause": true,
    "supportsOrderBy": true,
    "supportsDistinct": true,
    "supportsCountDistinct": true,
    "supportsAdvancedQueryRelated": true,
    "supportsQueryRelatedPagination": true,
    "supportsCurrentUserQueries": true,
    "supportsFullTextSearch": true,
    "fullTextSearchCapabilities": {
     "supportsSearchOperator": true,
     "supportsOperator": false,
     "supportsSqlExpressionInFullText": true
    },
    "fullTextSearchableFields": [],
    "supportsQueryWithResultType": true,
    "supportsReturningGeometryCentroid": false,
    "supportsReturningGeometryEnvelope": false,
    "supportsSqlExpression": true,
    "supportsLod": false,
    "supportsQueryWithLodSR": false,
    "supportsQueryAnalytic": true,
    "supportsQueryWithCacheHint": false
   },
   "advancedQueryAnalyticCapabilities": {
    "supportsLinearRegression": true,
    "supportsAsync": true,
    "supportsPercentileAnalytic": true
   },
   "advancedEditingCapabilities": {
    "supportedSqlFormatsInCalculate": [
     "standard"
    ],
    "supportsAsyncApplyEdits": true,
    "supportsApplyEditsbyUploadID": true,
    "supportedApplyEditsUploadIDFormats": "JSON,PBF"
   },
   "hasMetadata": true,
   "hasAttachments": false,
   "supportsApplyEditsWithGlobalIds": true,
   "htmlPopupType": "esriServerHTMLPopupTypeNone",
   "objectIdField": "OBJECTID",
   "globalIdField": "GlobalID",
   "displayField": "created_user",
   "typeIdField": "",
   "subtypeField": "",
   "fields": [
    {
     "name": "OBJECTID",
     "type": "esriFieldTypeOID",
     "alias": "OBJECTID",
     "domain": null,
     "editable": false,
     "nullable": false,
     "defaultValue": null,
     "modelName": "OBJECTID"
    },
    {
     "name": "REL_GUID",
     "type": "esriFieldTypeGUID",
     "alias": "REL_GUID",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 38,
     "defaultValue": null,
     "modelName": "REL_GUID"
    },
    {
     "name": "created_user",
     "type": "esriFieldTypeString",
     "alias": "created_user",
     "domain": null,
     "editable": false,
     "nullable": true,
     "length": 255,
     "defaultValue": null,
     "modelName": "created_user"
    },
    {
     "name": "created_date",
     "type": "esriFieldTypeDate",
     "alias": "created_date",
     "domain": null,
     "editable": false,
     "nullable": true,
     "length": 8,
     "defaultValue": null,
     "modelName": "created_date"
    },
    {
     "name": "last_edited_user",
     "type": "esriFieldTypeString",
     "alias": "last_edited_user",
     "domain": null,
     "editable": false,
     "nullable": true,
     "length": 255,
     "defaultValue": null,
     "modelName": "last_edited_user"
    },
    {
     "name": "last_edited_date",
     "type": "esriFieldTypeDate",
     "alias": "last_edited_date",
     "domain": null,
     "editable": false,
     "nullable": true,
     "length": 8,
     "defaultValue": null,
     "modelName": "last_edited_date"
    },
    {
     "name": "Conv_RepairResp3",
     "type": "esriFieldTypeString",
     "alias": "Repair Responsibility",
     "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"
     },
     "editable": true,
     "nullable": true,
     "length": 255,
     "defaultValue": null,
     "modelName": "Conv_RepairResp3"
    },
    {
     "name": "Conv_RepairDate3",
     "type": "esriFieldTypeDate",
     "alias": "Repair Date",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 8,
     "defaultValue": null,
     "modelName": "Conv_RepairDate3"
    },
    {
     "name": "Conv_Repair_Issue3",
     "type": "esriFieldTypeString",
     "alias": "Repair Issue",
     "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"
     },
     "editable": true,
     "nullable": true,
     "length": 255,
     "defaultValue": null,
     "modelName": "Conv_Repair_Issue3"
    },
    {
     "name": "Conv_RepairNotes3",
     "type": "esriFieldTypeString",
     "alias": "Repair Notes",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 255,
     "defaultValue": null,
     "modelName": "Conv_RepairNotes3"
    },
    {
     "name": "GlobalID",
     "type": "esriFieldTypeGlobalID",
     "alias": "GlobalID",
     "domain": null,
     "editable": false,
     "nullable": false,
     "length": 38,
     "defaultValue": null,
     "modelName": "GlobalID"
    },
    {
     "name": "SR_NOb3",
     "type": "esriFieldTypeString",
     "alias": "Service Request Number",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 11,
     "defaultValue": null,
     "modelName": "SR_NOb3"
    },
    {
     "name": "Material_PipeReplace",
     "type": "esriFieldTypeString",
     "alias": "Material of Replaced Pipe",
     "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"
     },
     "editable": true,
     "nullable": true,
     "length": 255,
     "defaultValue": null,
     "modelName": "Material_PipeReplace"
    },
    {
     "name": "Length_PipeReplace",
     "type": "esriFieldTypeDouble",
     "alias": "Length of Replaced Pipe  (FT)",
     "domain": null,
     "editable": true,
     "nullable": true,
     "defaultValue": null,
     "modelName": "Length_PipeReplace"
    }
   ],
   "indexes": [
    {
     "name": "R773_SDE_ROWID_UK",
     "isAscending": true,
     "isUnique": true,
     "description": "",
     "fields": "OBJECTID"
    },
    {
     "name": "GDB_5850_REL_GUI",
     "isAscending": true,
     "isUnique": false,
     "description": "",
     "fields": "REL_GUID"
    },
    {
     "name": "UUID_773",
     "isAscending": true,
     "isUnique": true,
     "description": "",
     "fields": "GlobalID"
    }
   ],
   "datesInUnknownTimezone": false,
   "dateFieldsTimeReference": {
    "timeZone": "UTC",
    "timeZoneIANA": "Etc/UTC",
    "respectsDaylightSaving": false
   },
   "preferredTimeReference": null,
   "types": [],
   "templates": [
    {
     "name": "SDC_Repairs",
     "description": "",
     "prototype": {
      "attributes": {
       "Material_PipeReplace": null,
       "SR_NOb3": null,
       "REL_GUID": null,
       "Length_PipeReplace": null,
       "Conv_RepairNotes3": null,
       "Conv_Repair_Issue3": null,
       "Conv_RepairDate3": null,
       "Conv_RepairResp3": null
      }
     },
     "drawingTool": "esriFeatureEditToolNone"
    }
   ],
   "maxRecordCount": 2000,
   "supportedQueryFormats": "JSON, geoJSON, PBF",
   "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson",
   "capabilities": "Query,Create,Update,Delete,Uploads,Editing",
   "useStandardizedQueries": true,
   "bigIntegerRestrictedTo53Bits": true,
   "supportsAppend": true,
   "supportedAppendFormats": "FILEGDB,PBF",
   "standardMaxRecordCount": 32000,
   "tileMaxRecordCount": 2000,
   "maxRecordCountFactor": 1,
   "serviceItemId": "1d37896af2b642789f9d73cc050f3ca6"
  },
  {
   "currentVersion": 11.5,
   "cimVersion": "3.5.0",
   "id": 6,
   "name": "SDS_Cleaning",
   "type": "Table",
   "description": "",
   "copyrightText": "",
   "editFieldsInfo": {
    "creationDateField": "created_date",
    "creatorField": "created_user",
    "editDateField": "last_edited_date",
    "editorField": "last_edited_user"
   },
   "ownershipBasedAccessControlForFeatures": null,
   "syncCanReturnChanges": false,
   "relationships": [],
   "isDataVersioned": false,
   "isDataArchived": false,
   "infoInEstimates": [
    "count"
   ],
   "isDataBranchVersioned": false,
   "isDataReplicaTracked": false,
   "isCoGoEnabled": false,
   "supportsRollbackOnFailureParameter": false,
   "archivingInfo": {
    "supportsQueryWithHistoricMoment": false,
    "startArchivingMoment": -1
   },
   "supportsStatistics": true,
   "supportsExceedsLimitStatistics": true,
   "supportsAdvancedQueries": true,
   "supportsValidateSQL": true,
   "supportsCoordinatesQuantization": false,
   "supportsCalculate": true,
   "supportsASyncCalculate": true,
   "advancedQueryCapabilities": {
    "supportsPagination": true,
    "supportsQueryWithDistance": true,
    "supportsReturningQueryExtent": true,
    "supportsStatistics": true,
    "supportsPercentileStatistics": true,
    "supportsHavingClause": true,
    "supportsOrderBy": true,
    "supportsDistinct": true,
    "supportsCountDistinct": true,
    "supportsAdvancedQueryRelated": true,
    "supportsQueryRelatedPagination": true,
    "supportsCurrentUserQueries": true,
    "supportsFullTextSearch": true,
    "fullTextSearchCapabilities": {
     "supportsSearchOperator": true,
     "supportsOperator": false,
     "supportsSqlExpressionInFullText": true
    },
    "fullTextSearchableFields": [],
    "supportsQueryWithResultType": true,
    "supportsReturningGeometryCentroid": false,
    "supportsReturningGeometryEnvelope": false,
    "supportsSqlExpression": true,
    "supportsLod": false,
    "supportsQueryWithLodSR": false,
    "supportsQueryAnalytic": true,
    "supportsQueryWithCacheHint": false
   },
   "advancedQueryAnalyticCapabilities": {
    "supportsLinearRegression": true,
    "supportsAsync": true,
    "supportsPercentileAnalytic": true
   },
   "advancedEditingCapabilities": {
    "supportedSqlFormatsInCalculate": [
     "standard"
    ],
    "supportsAsyncApplyEdits": true,
    "supportsApplyEditsbyUploadID": true,
    "supportedApplyEditsUploadIDFormats": "JSON,PBF"
   },
   "hasMetadata": true,
   "hasAttachments": false,
   "supportsApplyEditsWithGlobalIds": true,
   "htmlPopupType": "esriServerHTMLPopupTypeNone",
   "objectIdField": "OBJECTID",
   "globalIdField": "GlobalID",
   "displayField": "inlet_cleaned",
   "typeIdField": "",
   "subtypeField": "",
   "fields": [
    {
     "name": "OBJECTID",
     "type": "esriFieldTypeOID",
     "alias": "OBJECTID",
     "domain": null,
     "editable": false,
     "nullable": false,
     "defaultValue": null,
     "modelName": "OBJECTID"
    },
    {
     "name": "rel_globalid",
     "type": "esriFieldTypeGUID",
     "alias": "KCI Guid",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 38,
     "defaultValue": null,
     "modelName": "rel_globalid"
    },
    {
     "name": "inlet_cleaned",
     "type": "esriFieldTypeString",
     "alias": "Inlet Cleaned",
     "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"
     },
     "editable": true,
     "nullable": true,
     "length": 50,
     "defaultValue": null,
     "modelName": "inlet_cleaned"
    },
    {
     "name": "st_date_cleaned",
     "type": "esriFieldTypeDate",
     "alias": "Date Cleaned",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 8,
     "defaultValue": null,
     "modelName": "date_last_cleaned"
    },
    {
     "name": "st_comments",
     "type": "esriFieldTypeString",
     "alias": "Comments",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 1000,
     "defaultValue": null,
     "modelName": "comments"
    },
    {
     "name": "meets_criteria_yn",
     "type": "esriFieldTypeString",
     "alias": "Meets Criteria",
     "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"
     },
     "editable": true,
     "nullable": true,
     "length": 50,
     "defaultValue": null,
     "modelName": "meets_criteria_yn"
    },
    {
     "name": "GlobalID",
     "type": "esriFieldTypeGlobalID",
     "alias": "GlobalID",
     "domain": null,
     "editable": false,
     "nullable": false,
     "length": 38,
     "defaultValue": null,
     "modelName": "GlobalID"
    },
    {
     "name": "created_user",
     "type": "esriFieldTypeString",
     "alias": "created_user",
     "domain": null,
     "editable": false,
     "nullable": true,
     "length": 255,
     "defaultValue": null,
     "modelName": "created_user"
    },
    {
     "name": "created_date",
     "type": "esriFieldTypeDate",
     "alias": "created_date",
     "domain": null,
     "editable": false,
     "nullable": true,
     "length": 8,
     "defaultValue": null,
     "modelName": "created_date"
    },
    {
     "name": "last_edited_user",
     "type": "esriFieldTypeString",
     "alias": "last_edited_user",
     "domain": null,
     "editable": false,
     "nullable": true,
     "length": 255,
     "defaultValue": null,
     "modelName": "last_edited_user"
    },
    {
     "name": "last_edited_date",
     "type": "esriFieldTypeDate",
     "alias": "last_edited_date",
     "domain": null,
     "editable": false,
     "nullable": true,
     "length": 8,
     "defaultValue": null,
     "modelName": "last_edited_date"
    }
   ],
   "indexes": [
    {
     "name": "R774_SDE_ROWID_UK",
     "isAscending": true,
     "isUnique": true,
     "description": "",
     "fields": "OBJECTID"
    },
    {
     "name": "GDB_5851_rel_glo",
     "isAscending": true,
     "isUnique": false,
     "description": "",
     "fields": "rel_globalid"
    },
    {
     "name": "UUID_774",
     "isAscending": true,
     "isUnique": true,
     "description": "",
     "fields": "GlobalID"
    }
   ],
   "datesInUnknownTimezone": false,
   "dateFieldsTimeReference": {
    "timeZone": "UTC",
    "timeZoneIANA": "Etc/UTC",
    "respectsDaylightSaving": false
   },
   "preferredTimeReference": null,
   "types": [],
   "templates": [
    {
     "name": "SDS_Cleaning",
     "description": "",
     "prototype": {
      "attributes": {
       "meets_criteria_yn": null,
       "st_comments": null,
       "rel_globalid": null,
       "inlet_cleaned": null,
       "st_date_cleaned": null
      }
     },
     "drawingTool": "esriFeatureEditToolNone"
    }
   ],
   "maxRecordCount": 2000,
   "supportedQueryFormats": "JSON, geoJSON, PBF",
   "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson",
   "capabilities": "Query,Create,Update,Delete,Uploads,Editing",
   "useStandardizedQueries": true,
   "bigIntegerRestrictedTo53Bits": true,
   "supportsAppend": true,
   "supportedAppendFormats": "FILEGDB,PBF",
   "standardMaxRecordCount": 32000,
   "tileMaxRecordCount": 2000,
   "maxRecordCountFactor": 1,
   "serviceItemId": "1d37896af2b642789f9d73cc050f3ca6"
  },
  {
   "currentVersion": 11.5,
   "cimVersion": "3.5.0",
   "id": 7,
   "name": "SDS_Condition",
   "type": "Table",
   "description": "",
   "copyrightText": "",
   "editFieldsInfo": {
    "creationDateField": "created_date",
    "creatorField": "created_user",
    "editDateField": "last_edited_date",
    "editorField": "last_edited_user"
   },
   "ownershipBasedAccessControlForFeatures": null,
   "syncCanReturnChanges": false,
   "relationships": [],
   "isDataVersioned": false,
   "isDataArchived": false,
   "infoInEstimates": [
    "count"
   ],
   "isDataBranchVersioned": false,
   "isDataReplicaTracked": false,
   "isCoGoEnabled": false,
   "supportsRollbackOnFailureParameter": false,
   "archivingInfo": {
    "supportsQueryWithHistoricMoment": false,
    "startArchivingMoment": -1
   },
   "supportsStatistics": true,
   "supportsExceedsLimitStatistics": true,
   "supportsAdvancedQueries": true,
   "supportsValidateSQL": true,
   "supportsCoordinatesQuantization": false,
   "supportsCalculate": true,
   "supportsASyncCalculate": true,
   "advancedQueryCapabilities": {
    "supportsPagination": true,
    "supportsQueryWithDistance": true,
    "supportsReturningQueryExtent": true,
    "supportsStatistics": true,
    "supportsPercentileStatistics": true,
    "supportsHavingClause": true,
    "supportsOrderBy": true,
    "supportsDistinct": true,
    "supportsCountDistinct": true,
    "supportsAdvancedQueryRelated": true,
    "supportsQueryRelatedPagination": true,
    "supportsCurrentUserQueries": true,
    "supportsFullTextSearch": true,
    "fullTextSearchCapabilities": {
     "supportsSearchOperator": true,
     "supportsOperator": false,
     "supportsSqlExpressionInFullText": true
    },
    "fullTextSearchableFields": [],
    "supportsQueryWithResultType": true,
    "supportsReturningGeometryCentroid": false,
    "supportsReturningGeometryEnvelope": false,
    "supportsSqlExpression": true,
    "supportsLod": false,
    "supportsQueryWithLodSR": false,
    "supportsQueryAnalytic": true,
    "supportsQueryWithCacheHint": false
   },
   "advancedQueryAnalyticCapabilities": {
    "supportsLinearRegression": true,
    "supportsAsync": true,
    "supportsPercentileAnalytic": true
   },
   "advancedEditingCapabilities": {
    "supportedSqlFormatsInCalculate": [
     "standard"
    ],
    "supportsAsyncApplyEdits": true,
    "supportsApplyEditsbyUploadID": true,
    "supportedApplyEditsUploadIDFormats": "JSON,PBF"
   },
   "hasMetadata": true,
   "hasAttachments": false,
   "supportsApplyEditsWithGlobalIds": true,
   "htmlPopupType": "esriServerHTMLPopupTypeNone",
   "objectIdField": "OBJECTID",
   "globalIdField": "GlobalID",
   "displayField": "safety_score",
   "typeIdField": "",
   "subtypeField": "",
   "fields": [
    {
     "name": "OBJECTID",
     "type": "esriFieldTypeOID",
     "alias": "OBJECTID",
     "domain": null,
     "editable": false,
     "nullable": false,
     "defaultValue": null,
     "modelName": "OBJECTID"
    },
    {
     "name": "safety_score",
     "type": "esriFieldTypeString",
     "alias": "Safety Score",
     "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"
     },
     "editable": true,
     "nullable": true,
     "length": 75,
     "defaultValue": null,
     "modelName": "SAFETY_SCORE"
    },
    {
     "name": "blockage",
     "type": "esriFieldTypeString",
     "alias": "Blockage Extent",
     "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"
     },
     "editable": true,
     "nullable": true,
     "length": 75,
     "defaultValue": null,
     "modelName": "BLOCKAGE"
    },
    {
     "name": "RepairEval",
     "type": "esriFieldTypeString",
     "alias": "Repair Assessment Indicator",
     "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"
     },
     "editable": true,
     "nullable": true,
     "length": 75,
     "defaultValue": null,
     "modelName": "CONDITION"
    },
    {
     "name": "assess_comments",
     "type": "esriFieldTypeString",
     "alias": "Assesment Comments",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 255,
     "defaultValue": null,
     "modelName": "ASSESS_COMMENTS"
    },
    {
     "name": "assess_date",
     "type": "esriFieldTypeDate",
     "alias": "Assessment Date",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 8,
     "defaultValue": null,
     "modelName": "ASSESS_DATE"
    },
    {
     "name": "rel_globalid",
     "type": "esriFieldTypeGUID",
     "alias": "KCI Guid",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 38,
     "defaultValue": null,
     "modelName": "REL_GLOBALID"
    },
    {
     "name": "created_user",
     "type": "esriFieldTypeString",
     "alias": "created_user",
     "domain": null,
     "editable": false,
     "nullable": true,
     "length": 255,
     "defaultValue": null,
     "modelName": "created_user"
    },
    {
     "name": "created_date",
     "type": "esriFieldTypeDate",
     "alias": "created_date",
     "domain": null,
     "editable": false,
     "nullable": true,
     "length": 8,
     "defaultValue": null,
     "modelName": "created_date"
    },
    {
     "name": "last_edited_user",
     "type": "esriFieldTypeString",
     "alias": "last_edited_user",
     "domain": null,
     "editable": false,
     "nullable": true,
     "length": 255,
     "defaultValue": null,
     "modelName": "last_edited_user"
    },
    {
     "name": "last_edited_date",
     "type": "esriFieldTypeDate",
     "alias": "last_edited_date",
     "domain": null,
     "editable": false,
     "nullable": true,
     "length": 8,
     "defaultValue": null,
     "modelName": "last_edited_date"
    },
    {
     "name": "top_stable",
     "type": "esriFieldTypeString",
     "alias": "Top is Stable",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 25,
     "defaultValue": null,
     "modelName": "top_stable_"
    },
    {
     "name": "LAB_GUID",
     "type": "esriFieldTypeGUID",
     "alias": "Lab Guid",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 38,
     "defaultValue": null,
     "modelName": "LAB_GUID"
    },
    {
     "name": "GlobalID",
     "type": "esriFieldTypeGlobalID",
     "alias": "GlobalID",
     "domain": null,
     "editable": false,
     "nullable": false,
     "length": 38,
     "defaultValue": null,
     "modelName": "GlobalID"
    }
   ],
   "indexes": [
    {
     "name": "R775_SDE_ROWID_UK",
     "isAscending": true,
     "isUnique": true,
     "description": "",
     "fields": "OBJECTID"
    },
    {
     "name": "GDB_5852_rel_glo",
     "isAscending": true,
     "isUnique": false,
     "description": "",
     "fields": "rel_globalid"
    },
    {
     "name": "UUID_775",
     "isAscending": true,
     "isUnique": true,
     "description": "",
     "fields": "GlobalID"
    }
   ],
   "datesInUnknownTimezone": false,
   "dateFieldsTimeReference": {
    "timeZone": "UTC",
    "timeZoneIANA": "Etc/UTC",
    "respectsDaylightSaving": false
   },
   "preferredTimeReference": null,
   "types": [],
   "templates": [
    {
     "name": "SDS_Condition",
     "description": "",
     "prototype": {
      "attributes": {
       "LAB_GUID": null,
       "top_stable": null,
       "safety_score": null,
       "blockage": null,
       "RepairEval": null,
       "assess_comments": null,
       "assess_date": null,
       "rel_globalid": null
      }
     },
     "drawingTool": "esriFeatureEditToolNone"
    }
   ],
   "maxRecordCount": 2000,
   "supportedQueryFormats": "JSON, geoJSON, PBF",
   "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson",
   "capabilities": "Query,Create,Update,Delete,Uploads,Editing",
   "useStandardizedQueries": true,
   "bigIntegerRestrictedTo53Bits": true,
   "supportsAppend": true,
   "supportedAppendFormats": "FILEGDB,PBF",
   "standardMaxRecordCount": 32000,
   "tileMaxRecordCount": 2000,
   "maxRecordCountFactor": 1,
   "serviceItemId": "1d37896af2b642789f9d73cc050f3ca6"
  },
  {
   "currentVersion": 11.5,
   "cimVersion": "3.5.0",
   "id": 8,
   "name": "SDS_Repairs",
   "type": "Table",
   "description": "",
   "copyrightText": "",
   "editFieldsInfo": {
    "creationDateField": "created_date",
    "creatorField": "created_user",
    "editDateField": "last_edited_date",
    "editorField": "last_edited_user"
   },
   "ownershipBasedAccessControlForFeatures": null,
   "syncCanReturnChanges": false,
   "relationships": [],
   "isDataVersioned": false,
   "isDataArchived": false,
   "infoInEstimates": [
    "count"
   ],
   "isDataBranchVersioned": false,
   "isDataReplicaTracked": false,
   "isCoGoEnabled": false,
   "supportsRollbackOnFailureParameter": false,
   "archivingInfo": {
    "supportsQueryWithHistoricMoment": false,
    "startArchivingMoment": -1
   },
   "supportsStatistics": true,
   "supportsExceedsLimitStatistics": true,
   "supportsAdvancedQueries": true,
   "supportsValidateSQL": true,
   "supportsCoordinatesQuantization": false,
   "supportsCalculate": true,
   "supportsASyncCalculate": true,
   "advancedQueryCapabilities": {
    "supportsPagination": true,
    "supportsQueryWithDistance": true,
    "supportsReturningQueryExtent": true,
    "supportsStatistics": true,
    "supportsPercentileStatistics": true,
    "supportsHavingClause": true,
    "supportsOrderBy": true,
    "supportsDistinct": true,
    "supportsCountDistinct": true,
    "supportsAdvancedQueryRelated": true,
    "supportsQueryRelatedPagination": true,
    "supportsCurrentUserQueries": true,
    "supportsFullTextSearch": true,
    "fullTextSearchCapabilities": {
     "supportsSearchOperator": true,
     "supportsOperator": false,
     "supportsSqlExpressionInFullText": true
    },
    "fullTextSearchableFields": [],
    "supportsQueryWithResultType": true,
    "supportsReturningGeometryCentroid": false,
    "supportsReturningGeometryEnvelope": false,
    "supportsSqlExpression": true,
    "supportsLod": false,
    "supportsQueryWithLodSR": false,
    "supportsQueryAnalytic": true,
    "supportsQueryWithCacheHint": false
   },
   "advancedQueryAnalyticCapabilities": {
    "supportsLinearRegression": true,
    "supportsAsync": true,
    "supportsPercentileAnalytic": true
   },
   "advancedEditingCapabilities": {
    "supportedSqlFormatsInCalculate": [
     "standard"
    ],
    "supportsAsyncApplyEdits": true,
    "supportsApplyEditsbyUploadID": true,
    "supportedApplyEditsUploadIDFormats": "JSON,PBF"
   },
   "hasMetadata": true,
   "hasAttachments": false,
   "supportsApplyEditsWithGlobalIds": true,
   "htmlPopupType": "esriServerHTMLPopupTypeNone",
   "objectIdField": "OBJECTID",
   "globalIdField": "GlobalID",
   "displayField": "ST_RepairDate3",
   "typeIdField": "",
   "subtypeField": "",
   "fields": [
    {
     "name": "OBJECTID",
     "type": "esriFieldTypeOID",
     "alias": "OBJECTID",
     "domain": null,
     "editable": false,
     "nullable": false,
     "defaultValue": null,
     "modelName": "OBJECTID"
    },
    {
     "name": "ST_RepairDate3",
     "type": "esriFieldTypeDate",
     "alias": "Repair Date",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 8,
     "defaultValue": null,
     "modelName": "ST_RepairDate3"
    },
    {
     "name": "ST_Repair_Issue3",
     "type": "esriFieldTypeString",
     "alias": "Repair Issue",
     "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"
     },
     "editable": true,
     "nullable": true,
     "length": 255,
     "defaultValue": null,
     "modelName": "ST_Repair_Issue3"
    },
    {
     "name": "ST_RepairNotes3",
     "type": "esriFieldTypeString",
     "alias": "Repair Notes",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 255,
     "defaultValue": null,
     "modelName": "ST_RepairNotes3"
    },
    {
     "name": "ST_RepairResp3",
     "type": "esriFieldTypeString",
     "alias": "Repair Responsibility",
     "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"
     },
     "editable": true,
     "nullable": true,
     "length": 255,
     "defaultValue": null,
     "modelName": "ST_RepairResp3"
    },
    {
     "name": "REL_GUID",
     "type": "esriFieldTypeGUID",
     "alias": "REL_GUID",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 38,
     "defaultValue": null,
     "modelName": "REL_GUID"
    },
    {
     "name": "created_user",
     "type": "esriFieldTypeString",
     "alias": "created_user",
     "domain": null,
     "editable": false,
     "nullable": true,
     "length": 255,
     "defaultValue": null,
     "modelName": "created_user"
    },
    {
     "name": "created_date",
     "type": "esriFieldTypeDate",
     "alias": "created_date",
     "domain": null,
     "editable": false,
     "nullable": true,
     "length": 8,
     "defaultValue": null,
     "modelName": "created_date"
    },
    {
     "name": "last_edited_user",
     "type": "esriFieldTypeString",
     "alias": "last_edited_user",
     "domain": null,
     "editable": false,
     "nullable": true,
     "length": 255,
     "defaultValue": null,
     "modelName": "last_edited_user"
    },
    {
     "name": "last_edited_date",
     "type": "esriFieldTypeDate",
     "alias": "last_edited_date",
     "domain": null,
     "editable": false,
     "nullable": true,
     "length": 8,
     "defaultValue": null,
     "modelName": "last_edited_date"
    },
    {
     "name": "GlobalID",
     "type": "esriFieldTypeGlobalID",
     "alias": "GlobalID",
     "domain": null,
     "editable": false,
     "nullable": false,
     "length": 38,
     "defaultValue": null,
     "modelName": "GlobalID"
    },
    {
     "name": "SR3",
     "type": "esriFieldTypeString",
     "alias": "Service Request Number",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 11,
     "defaultValue": null,
     "modelName": "SR3"
    }
   ],
   "indexes": [
    {
     "name": "R776_SDE_ROWID_UK",
     "isAscending": true,
     "isUnique": true,
     "description": "",
     "fields": "OBJECTID"
    },
    {
     "name": "UUID_776",
     "isAscending": true,
     "isUnique": true,
     "description": "",
     "fields": "GlobalID"
    },
    {
     "name": "GDB_5853_REL_GUI",
     "isAscending": true,
     "isUnique": false,
     "description": "",
     "fields": "REL_GUID"
    }
   ],
   "datesInUnknownTimezone": false,
   "dateFieldsTimeReference": {
    "timeZone": "UTC",
    "timeZoneIANA": "Etc/UTC",
    "respectsDaylightSaving": false
   },
   "preferredTimeReference": null,
   "types": [],
   "templates": [
    {
     "name": "SDS_Repairs",
     "description": "",
     "prototype": {
      "attributes": {
       "SR3": null,
       "REL_GUID": null,
       "ST_RepairDate3": null,
       "ST_Repair_Issue3": null,
       "ST_RepairNotes3": null,
       "ST_RepairResp3": null
      }
     },
     "drawingTool": "esriFeatureEditToolNone"
    }
   ],
   "maxRecordCount": 2000,
   "supportedQueryFormats": "JSON, geoJSON, PBF",
   "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson",
   "capabilities": "Query,Create,Update,Delete,Uploads,Editing",
   "useStandardizedQueries": true,
   "bigIntegerRestrictedTo53Bits": true,
   "supportsAppend": true,
   "supportedAppendFormats": "FILEGDB,PBF",
   "standardMaxRecordCount": 32000,
   "tileMaxRecordCount": 2000,
   "maxRecordCountFactor": 1,
   "serviceItemId": "1d37896af2b642789f9d73cc050f3ca6"
  }
 ]
}