{
 "layers": [
  {
   "currentVersion": 10.91,
   "cimVersion": "2.9.0",
   "id": 0,
   "name": "Sewer Activity",
   "type": "Feature Layer",
   "description": "Subset of addresses related to sewer activity\n\nThe Hansen asset management database address table from Aug 6, 2020 was geocoded using the propadd streets locator sp. 17,725 matched (95%) while 903 (5%) did not match. Some manual re-matching occurred, however, many addresses appear to have been guesses. As of 8/6/20, 16,356 addresses can be related to 85,972 RCOSTSUM+HISTORY rows. 97%!",
   "geometryType": "esriGeometryPoint",
   "sourceSpatialReference": {
    "wkid": 102685,
    "latestWkid": 2248,
    "xyTolerance": 0.003280833333333333,
    "zTolerance": 0.001,
    "mTolerance": 0.001,
    "falseX": -120561100,
    "falseY": -95444400,
    "xyUnits": 3048.0060960121914,
    "falseZ": 0,
    "zUnits": 1,
    "falseM": 0,
    "mUnits": 1
   },
   "copyrightText": "",
   "parentLayer": null,
   "subLayers": [],
   "minScale": 0,
   "maxScale": 0,
   "referenceScale": 0.0,
   "drawingInfo": {
    "renderer": {
     "type": "simple",
     "symbol": {
      "type": "esriSMS",
      "style": "esriSMSCircle",
      "color": [
       255,
       170,
       0,
       255
      ],
      "size": 6,
      "angle": 0,
      "xoffset": 0,
      "yoffset": 0,
      "outline": {
       "color": [
        0,
        0,
        0,
        255
       ],
       "width": 1
      }
     }
    },
    "scaleSymbols": true,
    "transparency": 0,
    "labelingInfo": null
   },
   "defaultVisibility": true,
   "extent": {
    "xmin": -3100017.721518889,
    "ymin": -7193065.010240808,
    "xmax": 1281661.0735049397,
    "ymax": 533019.5362468511,
    "spatialReference": {
     "wkid": 102685,
     "latestWkid": 2248,
     "xyTolerance": 0.003280833333333333,
     "zTolerance": 2,
     "mTolerance": 0.001,
     "falseX": -120561100,
     "falseY": -95444400,
     "xyUnits": 3.695308229454812E7,
     "falseZ": 0,
     "zUnits": 1,
     "falseM": -100000,
     "mUnits": 10000
    }
   },
   "hasAttachments": false,
   "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText",
   "displayField": "ADDRESS",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "GlobalID",
     "type": "esriFieldTypeGlobalID",
     "alias": "GlobalID",
     "length": 38,
     "domain": null
    },
    {
     "name": "OBJECTID",
     "type": "esriFieldTypeOID",
     "alias": "OBJECTID",
     "domain": null
    },
    {
     "name": "ADDRKEY",
     "type": "esriFieldTypeInteger",
     "alias": "ADDRKEY",
     "domain": null
    },
    {
     "name": "STNAME",
     "type": "esriFieldTypeString",
     "alias": "STNAME",
     "length": 20,
     "domain": null
    },
    {
     "name": "ACCT",
     "type": "esriFieldTypeString",
     "alias": "ACCT",
     "length": 16,
     "domain": null
    },
    {
     "name": "ADDRESS",
     "type": "esriFieldTypeString",
     "alias": "ADDRESS",
     "length": 50,
     "domain": null
    },
    {
     "name": "ID_NUM",
     "type": "esriFieldTypeInteger",
     "alias": "ID_NUM",
     "domain": null
    },
    {
     "name": "Loc_name",
     "type": "esriFieldTypeString",
     "alias": "Loc_name",
     "length": 14,
     "domain": null
    },
    {
     "name": "Shape",
     "type": "esriFieldTypeGeometry",
     "alias": "Shape",
     "domain": null
    },
    {
     "name": "ADDRESS_NUMBER",
     "type": "esriFieldTypeString",
     "alias": "ADDRESS_NUMBER",
     "length": 8,
     "domain": null
    },
    {
     "name": "FLAG",
     "type": "esriFieldTypeString",
     "alias": "FLAG",
     "length": 1,
     "domain": {
      "type": "codedValue",
      "name": "YesNo_2",
      "description": "Y or N",
      "codedValues": [
       {
        "name": "Yes",
        "code": "Y"
       },
       {
        "name": "No",
        "code": "N"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    }
   ],
   "geometryField": {
    "name": "Shape",
    "type": "esriFieldTypeGeometry",
    "alias": "Shape"
   },
   "indexes": [
    {
     "name": "R2000_pk",
     "fields": "OBJECTID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    },
    {
     "name": "GDB_21835_ADDRKE",
     "fields": "ADDRKEY",
     "isAscending": true,
     "isUnique": false,
     "description": ""
    },
    {
     "name": "UUID_2000",
     "fields": "GlobalID",
     "isAscending": true,
     "isUnique": false,
     "description": ""
    },
    {
     "name": "UUID_OID_2000",
     "fields": "GlobalID,OBJECTID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    },
    {
     "name": "S1482_idx",
     "fields": "Shape",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    }
   ],
   "subtypes": [],
   "relationships": [
    {
     "id": 0,
     "name": "may have history",
     "relatedTableId": 2,
     "role": "esriRelRoleOrigin",
     "keyField": "ADDRKEY",
     "cardinality": "esriRelCardinalityOneToMany",
     "composite": false
    }
   ],
   "canModifyLayer": true,
   "canScaleSymbols": false,
   "hasLabels": false,
   "capabilities": "Map,Query,Data",
   "maxRecordCount": 1000,
   "supportsStatistics": true,
   "supportsExceedsLimitStatistics": true,
   "supportsAdvancedQueries": true,
   "supportedQueryFormats": "JSON, geoJSON, PBF",
   "isDataVersioned": true,
   "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,
    "supportsPagination": true,
    "supportsLod": false,
    "supportsQueryWithLodSR": false,
    "supportsTrueCurve": true,
    "supportsQueryWithDatumTransformation": true,
    "supportsReturningQueryExtent": true,
    "supportsQueryWithDistance": true,
    "supportsSqlExpression": true,
    "supportsTimeRelation": true,
    "supportsSqlFormat": false,
    "supportsQueryAnalytic": true
   },
   "supportsDatumTransformation": true,
   "advancedQueryAnalyticCapabilities": {
    "supportsLinearRegression": true,
    "supportsAsync": false,
    "supportsPercentileAnalytic": true
   },
   "dateFieldsTimeReference": null,
   "preferredTimeReference": null,
   "datesInUnknownTimezone": false,
   "hasMetadata": false,
   "isDataArchived": false,
   "archivingInfo": {
    "supportsQueryWithHistoricMoment": false,
    "startArchivingMoment": -1
   },
   "supportsCoordinatesQuantization": true,
   "supportsDynamicLegends": true
  },
  {
   "currentVersion": 10.91,
   "cimVersion": "2.9.0",
   "id": 1,
   "name": "All Hansen Addresses",
   "type": "Feature Layer",
   "description": "The Hansen asset management database address table from Aug 6, 2020 was geocoded using the propadd streets locator sp. 17,725 matched (95%) while 903 (5%) did not match. Some manual re-matching occurred, however, many addresses appear to have been guesses. As of 8/6/20, 16,356 addresses can be related to 85,972 RCOSTSUM+HISTORY rows. 97%!",
   "geometryType": "esriGeometryPoint",
   "sourceSpatialReference": {
    "wkid": 102685,
    "latestWkid": 2248,
    "xyTolerance": 0.003280833333333333,
    "zTolerance": 0.001,
    "mTolerance": 0.001,
    "falseX": -120561100,
    "falseY": -95444400,
    "xyUnits": 3048.0060960121914,
    "falseZ": 0,
    "zUnits": 1,
    "falseM": 0,
    "mUnits": 1
   },
   "copyrightText": "",
   "parentLayer": null,
   "subLayers": [],
   "minScale": 0,
   "maxScale": 0,
   "referenceScale": 0.0,
   "drawingInfo": {
    "renderer": {
     "type": "simple",
     "symbol": {
      "type": "esriSMS",
      "style": "esriSMSCircle",
      "color": [
       76,
       230,
       0,
       255
      ],
      "size": 6,
      "angle": 0,
      "xoffset": 0,
      "yoffset": 0,
      "outline": {
       "color": [
        0,
        0,
        0,
        255
       ],
       "width": 1
      }
     }
    },
    "scaleSymbols": true,
    "transparency": 0,
    "labelingInfo": null
   },
   "defaultVisibility": true,
   "extent": {
    "xmin": -3100017.721518889,
    "ymin": -7193065.010240808,
    "xmax": 1281661.0735049397,
    "ymax": 533019.5362468511,
    "spatialReference": {
     "wkid": 102685,
     "latestWkid": 2248,
     "xyTolerance": 0.003280833333333333,
     "zTolerance": 2,
     "mTolerance": 0.001,
     "falseX": -120561100,
     "falseY": -95444400,
     "xyUnits": 3.695308229454812E7,
     "falseZ": 0,
     "zUnits": 1,
     "falseM": -100000,
     "mUnits": 10000
    }
   },
   "hasAttachments": false,
   "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText",
   "displayField": "ADDRESS",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "GlobalID",
     "type": "esriFieldTypeGlobalID",
     "alias": "GlobalID",
     "length": 38,
     "domain": null
    },
    {
     "name": "OBJECTID",
     "type": "esriFieldTypeOID",
     "alias": "OBJECTID",
     "domain": null
    },
    {
     "name": "ADDRKEY",
     "type": "esriFieldTypeInteger",
     "alias": "ADDRKEY",
     "domain": null
    },
    {
     "name": "STNAME",
     "type": "esriFieldTypeString",
     "alias": "STNAME",
     "length": 20,
     "domain": null
    },
    {
     "name": "ACCT",
     "type": "esriFieldTypeString",
     "alias": "ACCT",
     "length": 16,
     "domain": null
    },
    {
     "name": "ADDRESS",
     "type": "esriFieldTypeString",
     "alias": "ADDRESS",
     "length": 50,
     "domain": null
    },
    {
     "name": "ID_NUM",
     "type": "esriFieldTypeInteger",
     "alias": "ID_NUM",
     "domain": null
    },
    {
     "name": "Loc_name",
     "type": "esriFieldTypeString",
     "alias": "Loc_name",
     "length": 14,
     "domain": null
    },
    {
     "name": "Shape",
     "type": "esriFieldTypeGeometry",
     "alias": "Shape",
     "domain": null
    },
    {
     "name": "ADDRESS_NUMBER",
     "type": "esriFieldTypeString",
     "alias": "ADDRESS_NUMBER",
     "length": 8,
     "domain": null
    },
    {
     "name": "FLAG",
     "type": "esriFieldTypeString",
     "alias": "FLAG",
     "length": 1,
     "domain": {
      "type": "codedValue",
      "name": "YesNo_2",
      "description": "Y or N",
      "codedValues": [
       {
        "name": "Yes",
        "code": "Y"
       },
       {
        "name": "No",
        "code": "N"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    }
   ],
   "geometryField": {
    "name": "Shape",
    "type": "esriFieldTypeGeometry",
    "alias": "Shape"
   },
   "indexes": [
    {
     "name": "R2000_pk",
     "fields": "OBJECTID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    },
    {
     "name": "GDB_21835_ADDRKE",
     "fields": "ADDRKEY",
     "isAscending": true,
     "isUnique": false,
     "description": ""
    },
    {
     "name": "UUID_2000",
     "fields": "GlobalID",
     "isAscending": true,
     "isUnique": false,
     "description": ""
    },
    {
     "name": "UUID_OID_2000",
     "fields": "GlobalID,OBJECTID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    },
    {
     "name": "S1482_idx",
     "fields": "Shape",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    }
   ],
   "subtypes": [],
   "relationships": [
    {
     "id": 1,
     "name": "may have history",
     "relatedTableId": 2,
     "role": "esriRelRoleOrigin",
     "keyField": "ADDRKEY",
     "cardinality": "esriRelCardinalityOneToMany",
     "composite": false
    }
   ],
   "canModifyLayer": true,
   "canScaleSymbols": false,
   "hasLabels": false,
   "capabilities": "Map,Query,Data",
   "maxRecordCount": 1000,
   "supportsStatistics": true,
   "supportsExceedsLimitStatistics": true,
   "supportsAdvancedQueries": true,
   "supportedQueryFormats": "JSON, geoJSON, PBF",
   "isDataVersioned": true,
   "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,
    "supportsPagination": true,
    "supportsLod": false,
    "supportsQueryWithLodSR": false,
    "supportsTrueCurve": true,
    "supportsQueryWithDatumTransformation": true,
    "supportsReturningQueryExtent": true,
    "supportsQueryWithDistance": true,
    "supportsSqlExpression": true,
    "supportsTimeRelation": true,
    "supportsSqlFormat": false,
    "supportsQueryAnalytic": true
   },
   "supportsDatumTransformation": true,
   "advancedQueryAnalyticCapabilities": {
    "supportsLinearRegression": true,
    "supportsAsync": false,
    "supportsPercentileAnalytic": true
   },
   "dateFieldsTimeReference": null,
   "preferredTimeReference": null,
   "datesInUnknownTimezone": false,
   "hasMetadata": false,
   "isDataArchived": false,
   "archivingInfo": {
    "supportsQueryWithHistoricMoment": false,
    "startArchivingMoment": -1
   },
   "supportsCoordinatesQuantization": true,
   "supportsDynamicLegends": true
  }
 ],
 "tables": [
  {
   "currentVersion": 10.91,
   "cimVersion": "2.9.0",
   "id": 2,
   "name": "Hansen Sewer Activity",
   "type": "Table",
   "description": null,
   "hasAttachments": false,
   "htmlPopupType": "esriServerHTMLPopupTypeNone",
   "displayField": "UNITID",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "OBJECTID",
     "type": "esriFieldTypeOID",
     "alias": "OBJECTID",
     "domain": null
    },
    {
     "name": "DIST",
     "type": "esriFieldTypeDouble",
     "alias": "DIST",
     "domain": null
    },
    {
     "name": "UNITID",
     "type": "esriFieldTypeString",
     "alias": "UNITID",
     "length": 16,
     "domain": null
    },
    {
     "name": "UNITID2",
     "type": "esriFieldTypeString",
     "alias": "UNITID2",
     "length": 16,
     "domain": null
    },
    {
     "name": "ACTCODE",
     "type": "esriFieldTypeString",
     "alias": "ACTCODE",
     "length": 6,
     "domain": null
    },
    {
     "name": "ACTDESC",
     "type": "esriFieldTypeString",
     "alias": "ACTDESC",
     "length": 30,
     "domain": null
    },
    {
     "name": "ACTGRP",
     "type": "esriFieldTypeString",
     "alias": "ACTGRP",
     "length": 6,
     "domain": null
    },
    {
     "name": "COND",
     "type": "esriFieldTypeString",
     "alias": "COND",
     "length": 4,
     "domain": null
    },
    {
     "name": "MAINTTYPE",
     "type": "esriFieldTypeString",
     "alias": "MAINTTYPE",
     "length": 4,
     "domain": null
    },
    {
     "name": "STARTDTTM",
     "type": "esriFieldTypeDate",
     "alias": "STARTDTTM",
     "length": 8,
     "domain": null
    },
    {
     "name": "INITDTTM",
     "type": "esriFieldTypeDate",
     "alias": "INITDTTM",
     "length": 8,
     "domain": null
    },
    {
     "name": "COMPDTTM",
     "type": "esriFieldTypeDate",
     "alias": "COMPDTTM",
     "length": 8,
     "domain": null
    },
    {
     "name": "HISTKEY",
     "type": "esriFieldTypeInteger",
     "alias": "HISTKEY",
     "domain": null
    },
    {
     "name": "WONO",
     "type": "esriFieldTypeString",
     "alias": "WONO",
     "length": 9,
     "domain": null
    },
    {
     "name": "PROB",
     "type": "esriFieldTypeString",
     "alias": "PROB",
     "length": 5,
     "domain": null
    },
    {
     "name": "STOPPAGE",
     "type": "esriFieldTypeString",
     "alias": "STOPPAGE",
     "length": 1,
     "domain": null
    },
    {
     "name": "ACTION",
     "type": "esriFieldTypeString",
     "alias": "ACTION",
     "length": 1,
     "domain": null
    },
    {
     "name": "ACTKEY",
     "type": "esriFieldTypeInteger",
     "alias": "ACTKEY",
     "domain": null
    },
    {
     "name": "ADDBY",
     "type": "esriFieldTypeString",
     "alias": "ADDBY",
     "length": 30,
     "domain": null
    },
    {
     "name": "ADDDTTM",
     "type": "esriFieldTypeDate",
     "alias": "ADDDTTM",
     "length": 8,
     "domain": null
    },
    {
     "name": "COMPKEY",
     "type": "esriFieldTypeInteger",
     "alias": "COMPKEY",
     "domain": null
    },
    {
     "name": "COMPTYPE",
     "type": "esriFieldTypeInteger",
     "alias": "COMPTYPE",
     "domain": null
    },
    {
     "name": "MODBY",
     "type": "esriFieldTypeString",
     "alias": "MODBY",
     "length": 30,
     "domain": null
    },
    {
     "name": "MODDTTM",
     "type": "esriFieldTypeDate",
     "alias": "MODDTTM",
     "length": 8,
     "domain": null
    },
    {
     "name": "RES",
     "type": "esriFieldTypeString",
     "alias": "RES",
     "length": 7,
     "domain": null
    },
    {
     "name": "RESP",
     "type": "esriFieldTypeString",
     "alias": "RESP",
     "length": 4,
     "domain": null
    },
    {
     "name": "ADDRKEY",
     "type": "esriFieldTypeInteger",
     "alias": "ADDRKEY",
     "domain": null
    },
    {
     "name": "ADDRESS",
     "type": "esriFieldTypeString",
     "alias": "ADDRESS",
     "length": 75,
     "domain": null
    },
    {
     "name": "GREASE",
     "type": "esriFieldTypeString",
     "alias": "GREASE",
     "length": 1,
     "domain": null
    },
    {
     "name": "ROOTS",
     "type": "esriFieldTypeString",
     "alias": "ROOTS",
     "length": 1,
     "domain": null
    },
    {
     "name": "CLEAR",
     "type": "esriFieldTypeString",
     "alias": "CLEAR",
     "length": 1,
     "domain": null
    },
    {
     "name": "RESULTS",
     "type": "esriFieldTypeString",
     "alias": "RESULTS",
     "length": 50,
     "domain": null
    },
    {
     "name": "COMMENT",
     "type": "esriFieldTypeString",
     "alias": "COMMENT",
     "length": 1000,
     "domain": null
    },
    {
     "name": "RELIEVE_STOPPAGE",
     "type": "esriFieldTypeString",
     "alias": "RELIEVE_STOPPAGE",
     "length": 1,
     "domain": null
    },
    {
     "name": "GlobalID",
     "type": "esriFieldTypeGlobalID",
     "alias": "GlobalID",
     "length": 38,
     "domain": null
    },
    {
     "name": "COMPBY",
     "type": "esriFieldTypeString",
     "alias": "COMPBY",
     "length": 12,
     "domain": null
    }
   ],
   "indexes": [
    {
     "name": "R2001_SDE_ROWID_UK",
     "fields": "OBJECTID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    },
    {
     "name": "GDB_21836_ADDRKE",
     "fields": "ADDRKEY",
     "isAscending": true,
     "isUnique": false,
     "description": ""
    },
    {
     "name": "UUID_2001",
     "fields": "GlobalID",
     "isAscending": true,
     "isUnique": false,
     "description": ""
    },
    {
     "name": "UUID_OID_2001",
     "fields": "GlobalID,OBJECTID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    }
   ],
   "subtypes": [],
   "relationships": [
    {
     "id": 0,
     "name": "belongs to",
     "relatedTableId": 0,
     "role": "esriRelRoleDestination",
     "keyField": "ADDRKEY",
     "cardinality": "esriRelCardinalityOneToMany",
     "composite": false
    },
    {
     "id": 1,
     "name": "belongs to",
     "relatedTableId": 1,
     "role": "esriRelRoleDestination",
     "keyField": "ADDRKEY",
     "cardinality": "esriRelCardinalityOneToMany",
     "composite": false
    }
   ],
   "capabilities": "Map,Query,Data",
   "maxRecordCount": 1000,
   "supportsStatistics": true,
   "supportsExceedsLimitStatistics": true,
   "supportsAdvancedQueries": true,
   "supportedQueryFormats": "JSON, PBF",
   "isDataVersioned": true,
   "useStandardizedQueries": true,
   "advancedQueryCapabilities": {
    "useStandardizedQueries": true,
    "supportsStatistics": true,
    "supportsPercentileStatistics": true,
    "supportsHavingClause": true,
    "supportsOrderBy": true,
    "supportsDistinct": true,
    "supportsCountDistinct": true,
    "supportsPagination": true,
    "supportsTrueCurve": false,
    "supportsReturningQueryExtent": true,
    "supportsQueryWithDistance": true,
    "supportsSqlExpression": true,
    "supportsTimeRelation": true,
    "supportsSqlFormat": false,
    "supportsQueryAnalytic": true
   },
   "advancedQueryAnalyticCapabilities": {
    "supportsLinearRegression": true,
    "supportsAsync": false,
    "supportsPercentileAnalytic": true
   },
   "dateFieldsTimeReference": null,
   "preferredTimeReference": null,
   "datesInUnknownTimezone": false,
   "hasMetadata": false,
   "isDataArchived": false,
   "archivingInfo": {
    "supportsQueryWithHistoricMoment": false,
    "startArchivingMoment": -1
   }
  }
 ]
}