{
 "layers": [
  {
   "currentVersion": 11.3,
   "cimVersion": "3.3.0",
   "id": 0,
   "name": "All Parcels",
   "type": "Feature Layer",
   "description": "",
   "geometryType": "esriGeometryPolygon",
   "sourceSpatialReference": {
    "wkid": 102100,
    "latestWkid": 3857,
    "xyTolerance": 0.001,
    "zTolerance": 0.001,
    "mTolerance": 0.001,
    "falseX": -20037700,
    "falseY": -30241100,
    "xyUnits": 10000,
    "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": "esriSFS",
      "style": "esriSFSSolid",
      "color": [
       130,
       130,
       130,
       0
      ],
      "outline": {
       "type": "esriSLS",
       "style": "esriSLSSolid",
       "color": [
        255,
        0,
        0,
        255
       ],
       "width": 1
      }
     }
    },
    "scaleSymbols": true,
    "transparency": 0,
    "labelingInfo": null
   },
   "defaultVisibility": false,
   "extent": {
    "xmin": -9300892.3884,
    "ymin": 4881492.784699999,
    "xmax": -9258425.2561,
    "ymax": 4939948.047700003,
    "spatialReference": {
     "wkid": 102100,
     "latestWkid": 3857,
     "xyTolerance": 0.001,
     "zTolerance": 0.001,
     "mTolerance": 0.001,
     "falseX": -20037700,
     "falseY": -30241100,
     "xyUnits": 10000,
     "falseZ": -100000,
     "zUnits": 10000,
     "falseM": -100000,
     "mUnits": 10000
    }
   },
   "hasAttachments": false,
   "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText",
   "displayField": "taxDistrictName",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "camano",
     "type": "esriFieldTypeString",
     "alias": "camano",
     "length": 13,
     "domain": null
    },
    {
     "name": "Acreage",
     "type": "esriFieldTypeDouble",
     "alias": "Acreage",
     "domain": null
    },
    {
     "name": "Address",
     "type": "esriFieldTypeString",
     "alias": "Address",
     "length": 59,
     "domain": null
    },
    {
     "name": "city",
     "type": "esriFieldTypeString",
     "alias": "city",
     "length": 50,
     "domain": null
    },
    {
     "name": "GISNO",
     "type": "esriFieldTypeString",
     "alias": "GISNO",
     "length": 13,
     "domain": null
    },
    {
     "name": "link",
     "type": "esriFieldTypeString",
     "alias": "link",
     "length": 17,
     "domain": null
    },
    {
     "name": "NeighborhoodCode",
     "type": "esriFieldTypeString",
     "alias": "NeighborhoodCode",
     "length": 8,
     "domain": null
    },
    {
     "name": "objectid",
     "type": "esriFieldTypeOID",
     "alias": "objectid",
     "domain": null
    },
    {
     "name": "Owner",
     "type": "esriFieldTypeString",
     "alias": "Owner",
     "length": 100,
     "domain": null
    },
    {
     "name": "ParcelClass",
     "type": "esriFieldTypeString",
     "alias": "ParcelClass",
     "length": 3,
     "domain": null
    },
    {
     "name": "PARCELTYPE",
     "type": "esriFieldTypeString",
     "alias": "PARCELTYPE",
     "length": 1,
     "domain": null
    },
    {
     "name": "schoolDistrict",
     "type": "esriFieldTypeString",
     "alias": "schoolDistrict",
     "length": 50,
     "domain": null
    },
    {
     "name": "Shape",
     "type": "esriFieldTypeGeometry",
     "alias": "Shape",
     "domain": null
    },
    {
     "name": "taxDistrictName",
     "type": "esriFieldTypeString",
     "alias": "taxDistrictName",
     "length": 50,
     "domain": null
    },
    {
     "name": "TIF",
     "type": "esriFieldTypeString",
     "alias": "TIF",
     "length": 100,
     "domain": null
    },
    {
     "name": "township",
     "type": "esriFieldTypeString",
     "alias": "township",
     "length": 55,
     "domain": null
    },
    {
     "name": "ZipCode",
     "type": "esriFieldTypeString",
     "alias": "ZipCode",
     "length": 35,
     "domain": null
    },
    {
     "name": "subdivision_name",
     "type": "esriFieldTypeString",
     "alias": "subdivision_name",
     "length": 200,
     "domain": null
    },
    {
     "name": "subyear",
     "type": "esriFieldTypeString",
     "alias": "subyear",
     "length": 4,
     "domain": null
    },
    {
     "name": "subdivisionAcreage",
     "type": "esriFieldTypeDouble",
     "alias": "subdivisionAcreage",
     "domain": null
    },
    {
     "name": "AppraisedMarketLandValue",
     "type": "esriFieldTypeDouble",
     "alias": "AppraisedMarketLandValue",
     "domain": null
    },
    {
     "name": "LivingArea",
     "type": "esriFieldTypeInteger",
     "alias": "LivingArea",
     "domain": null
    },
    {
     "name": "saledate",
     "type": "esriFieldTypeDate",
     "alias": "saledate",
     "length": 8,
     "domain": null
    },
    {
     "name": "salePrice",
     "type": "esriFieldTypeDouble",
     "alias": "salePrice",
     "domain": null
    },
    {
     "name": "AgeYear",
     "type": "esriFieldTypeString",
     "alias": "AgeYear",
     "length": 4,
     "domain": null
    },
    {
     "name": "beds",
     "type": "esriFieldTypeInteger",
     "alias": "beds",
     "domain": null
    },
    {
     "name": "FullBaths",
     "type": "esriFieldTypeInteger",
     "alias": "FullBaths",
     "domain": null
    },
    {
     "name": "HalfBaths",
     "type": "esriFieldTypeInteger",
     "alias": "HalfBaths",
     "domain": null
    },
    {
     "name": "typeofSale",
     "type": "esriFieldTypeString",
     "alias": "typeofSale",
     "length": 5,
     "domain": null
    },
    {
     "name": "floornumber",
     "type": "esriFieldTypeDouble",
     "alias": "floornumber",
     "domain": null
    },
    {
     "name": "conveyanceNo",
     "type": "esriFieldTypeInteger",
     "alias": "conveyanceNo",
     "domain": null
    },
    {
     "name": "NumberofParcelsInSale",
     "type": "esriFieldTypeInteger",
     "alias": "NumberofParcelsInSale",
     "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": "R13_pk",
     "fields": "objectid",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    },
    {
     "name": "NonClusteredIndex-20201123-112929",
     "fields": "camano,objectid",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    },
    {
     "name": "S2_idx",
     "fields": "Shape",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    }
   ],
   "subtypes": [],
   "relationships": [
    {
     "id": 0,
     "name": "sde.parcelsaleinfonew",
     "relatedTableId": 3,
     "role": "esriRelRoleOrigin",
     "keyField": "camano",
     "cardinality": "esriRelCardinalityOneToMany",
     "composite": false,
     "catalogID": "{97F6B507-2259-40BD-9257-F31E299465AE}"
    },
    {
     "id": 1,
     "name": "sde.parcelBuildingInfo",
     "relatedTableId": 2,
     "role": "esriRelRoleOrigin",
     "keyField": "camano",
     "cardinality": "esriRelCardinalityOneToMany",
     "composite": false,
     "catalogID": "{8B130F19-4478-4023-84CA-BC8CA979F6C4}"
    }
   ],
   "canModifyLayer": true,
   "canScaleSymbols": false,
   "hasLabels": false,
   "capabilities": "Query,Map,Data",
   "maxRecordCount": 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": "esriMeters",
    "mapUnits": {"uwkid": 9001}
   },
   "hasMetadata": true,
   "isDataArchived": false,
   "archivingInfo": {
    "supportsQueryWithHistoricMoment": false,
    "startArchivingMoment": -1
   },
   "supportsCoordinatesQuantization": true,
   "supportsDynamicLegends": true,
   "serviceItemId": "251ed7b504854de18e509e5712d1345a"
  },
  {
   "currentVersion": 11.3,
   "cimVersion": "3.3.0",
   "id": 1,
   "name": "Parcels",
   "type": "Feature Layer",
   "description": "",
   "geometryType": "esriGeometryPolygon",
   "sourceSpatialReference": {
    "wkid": 102100,
    "latestWkid": 3857,
    "xyTolerance": 0.001,
    "zTolerance": 0.001,
    "mTolerance": 0.001,
    "falseX": -20037700,
    "falseY": -30241100,
    "xyUnits": 10000,
    "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": "esriSFS",
      "style": "esriSFSSolid",
      "color": [
       130,
       130,
       130,
       0
      ],
      "outline": {
       "type": "esriSLS",
       "style": "esriSLSSolid",
       "color": [
        255,
        127,
        127,
        255
       ],
       "width": 1
      }
     }
    },
    "scaleSymbols": true,
    "transparency": 0,
    "labelingInfo": null
   },
   "defaultVisibility": true,
   "extent": {
    "xmin": -9300892.8767,
    "ymin": 4881493.9147000015,
    "xmax": -9258425.2561,
    "ymax": 4939948.047700003,
    "spatialReference": {
     "wkid": 102100,
     "latestWkid": 3857,
     "xyTolerance": 0.001,
     "zTolerance": 0.001,
     "mTolerance": 0.001,
     "falseX": -20037700,
     "falseY": -30241100,
     "xyUnits": 10000,
     "falseZ": -100000,
     "zUnits": 10000,
     "falseM": -100000,
     "mUnits": 10000
    }
   },
   "hasAttachments": false,
   "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText",
   "displayField": "ParcelNo",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "objectid",
     "type": "esriFieldTypeOID",
     "alias": "objectid",
     "length": 8,
     "domain": null
    },
    {
     "name": "Shape",
     "type": "esriFieldTypeGeometry",
     "alias": "Shape",
     "domain": null
    },
    {
     "name": "ParcelNo",
     "type": "esriFieldTypeString",
     "alias": "ParcelNo",
     "length": 13,
     "domain": null
    },
    {
     "name": "DeedOwner",
     "type": "esriFieldTypeString",
     "alias": "DeedOwner",
     "length": 100,
     "domain": null
    },
    {
     "name": "Acreage",
     "type": "esriFieldTypeDouble",
     "alias": "Acreage",
     "domain": null
    },
    {
     "name": "GISNO",
     "type": "esriFieldTypeString",
     "alias": "GISNO",
     "length": 13,
     "domain": null
    },
    {
     "name": "NeighborhoodCode",
     "type": "esriFieldTypeString",
     "alias": "NeighborhoodCode",
     "length": 8,
     "domain": null
    },
    {
     "name": "PARCELCLASS",
     "type": "esriFieldTypeString",
     "alias": "PARCELCLASS",
     "length": 3,
     "domain": null
    },
    {
     "name": "classDescription",
     "type": "esriFieldTypeString",
     "alias": "classDescription",
     "length": 254,
     "domain": null
    },
    {
     "name": "Address",
     "type": "esriFieldTypeString",
     "alias": "Address",
     "length": 64,
     "domain": null
    },
    {
     "name": "city",
     "type": "esriFieldTypeString",
     "alias": "city",
     "length": 50,
     "domain": null
    },
    {
     "name": "ZipCode",
     "type": "esriFieldTypeString",
     "alias": "ZipCode",
     "length": 35,
     "domain": null
    },
    {
     "name": "schoolDistrict",
     "type": "esriFieldTypeString",
     "alias": "schoolDistrict",
     "length": 50,
     "domain": null
    },
    {
     "name": "township",
     "type": "esriFieldTypeString",
     "alias": "township",
     "length": 55,
     "domain": null
    },
    {
     "name": "taxDistrictName",
     "type": "esriFieldTypeString",
     "alias": "taxDistrictName",
     "length": 53,
     "domain": null
    },
    {
     "name": "houseNumber",
     "type": "esriFieldTypeInteger",
     "alias": "houseNumber",
     "domain": null
    },
    {
     "name": "StreetName",
     "type": "esriFieldTypeString",
     "alias": "StreetName",
     "length": 50,
     "domain": null
    },
    {
     "name": "TIF",
     "type": "esriFieldTypeString",
     "alias": "TIF",
     "length": 100,
     "domain": null
    },
    {
     "name": "netTax1H",
     "type": "esriFieldTypeDouble",
     "alias": "netTax1H",
     "domain": null
    },
    {
     "name": "netTax2H",
     "type": "esriFieldTypeDouble",
     "alias": "netTax2H",
     "domain": null
    },
    {
     "name": "subdivision_name",
     "type": "esriFieldTypeString",
     "alias": "subdivision_name",
     "length": 200,
     "domain": null
    },
    {
     "name": "Condominium_name",
     "type": "esriFieldTypeString",
     "alias": "Condominium_name",
     "length": 60,
     "domain": null
    },
    {
     "name": "AppraisedBuildValue",
     "type": "esriFieldTypeDouble",
     "alias": "AppraisedBuildValue",
     "domain": null
    },
    {
     "name": "appraisedLandValue",
     "type": "esriFieldTypeDouble",
     "alias": "appraisedLandValue",
     "domain": null
    },
    {
     "name": "appraisedTotalValue",
     "type": "esriFieldTypeDouble",
     "alias": "appraisedTotalValue",
     "domain": null
    },
    {
     "name": "conveyanceNo",
     "type": "esriFieldTypeInteger",
     "alias": "conveyanceNo",
     "domain": null
    },
    {
     "name": "saleDate",
     "type": "esriFieldTypeDate",
     "alias": "saleDate",
     "length": 8,
     "precision": 1,
     "domain": null
    },
    {
     "name": "salePrice",
     "type": "esriFieldTypeDouble",
     "alias": "salePrice",
     "domain": null
    },
    {
     "name": "typeofSale",
     "type": "esriFieldTypeString",
     "alias": "typeofSale",
     "length": 5,
     "domain": null
    },
    {
     "name": "isValidSale",
     "type": "esriFieldTypeSmallInteger",
     "alias": "isValidSale",
     "domain": null
    },
    {
     "name": "construction",
     "type": "esriFieldTypeString",
     "alias": "construction",
     "length": 8000,
     "domain": null
    },
    {
     "name": "name",
     "type": "esriFieldTypeString",
     "alias": "name",
     "length": 150,
     "domain": null
    },
    {
     "name": "yearBuilt",
     "type": "esriFieldTypeString",
     "alias": "yearBuilt",
     "length": 30,
     "domain": null
    },
    {
     "name": "yearRemodeled",
     "type": "esriFieldTypeString",
     "alias": "yearRemodeled",
     "length": 6,
     "domain": null
    },
    {
     "name": "bedroom",
     "type": "esriFieldTypeInteger",
     "alias": "bedroom",
     "domain": null
    },
    {
     "name": "FullBaths",
     "type": "esriFieldTypeInteger",
     "alias": "FullBaths",
     "domain": null
    },
    {
     "name": "halfBath",
     "type": "esriFieldTypeInteger",
     "alias": "halfBath",
     "domain": null
    },
    {
     "name": "roomCount",
     "type": "esriFieldTypeInteger",
     "alias": "roomCount",
     "domain": null
    },
    {
     "name": "unit",
     "type": "esriFieldTypeInteger",
     "alias": "unit",
     "domain": null
    },
    {
     "name": "LivingArea",
     "type": "esriFieldTypeInteger",
     "alias": "LivingArea",
     "domain": null
    },
    {
     "name": "TotalBuildingArea",
     "type": "esriFieldTypeInteger",
     "alias": "TotalBuildingArea",
     "domain": null
    },
    {
     "name": "MailOwner",
     "type": "esriFieldTypeString",
     "alias": "MailOwner",
     "length": 275,
     "domain": null
    },
    {
     "name": "MailAddress1",
     "type": "esriFieldTypeString",
     "alias": "MailAddress1",
     "length": 275,
     "domain": null
    },
    {
     "name": "MailAddress2",
     "type": "esriFieldTypeString",
     "alias": "MailAddress2",
     "length": 275,
     "domain": null
    },
    {
     "name": "Mailaddress3",
     "type": "esriFieldTypeString",
     "alias": "Mailaddress3",
     "length": 275,
     "domain": null
    },
    {
     "name": "Floor",
     "type": "esriFieldTypeDouble",
     "alias": "Floor",
     "domain": null
    },
    {
     "name": "haveBSMT",
     "type": "esriFieldTypeString",
     "alias": "haveBSMT",
     "length": 10,
     "domain": null
    },
    {
     "name": "neighborhoodName",
     "type": "esriFieldTypeString",
     "alias": "neighborhoodName",
     "length": 150,
     "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": null,
   "subtypes": [],
   "relationships": [],
   "canModifyLayer": true,
   "canScaleSymbols": false,
   "hasLabels": false,
   "capabilities": "Query,Map,Data",
   "maxRecordCount": 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": "esriMeters",
    "mapUnits": {"uwkid": 9001}
   },
   "hasMetadata": true,
   "isDataArchived": false,
   "archivingInfo": {
    "supportsQueryWithHistoricMoment": false,
    "startArchivingMoment": -1
   },
   "supportsCoordinatesQuantization": true,
   "supportsDynamicLegends": true,
   "serviceItemId": "251ed7b504854de18e509e5712d1345a"
  }
 ],
 "tables": [
  {
   "currentVersion": 11.3,
   "cimVersion": "3.3.0",
   "id": 2,
   "name": "Building Info",
   "type": "Table",
   "description": null,
   "hasAttachments": false,
   "htmlPopupType": "esriServerHTMLPopupTypeNone",
   "displayField": "parcel",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "parcel",
     "type": "esriFieldTypeString",
     "alias": "parcel",
     "length": 13,
     "domain": null
    },
    {
     "name": "FloorLevel",
     "type": "esriFieldTypeString",
     "alias": "FloorLevel",
     "length": 5,
     "domain": null
    },
    {
     "name": "Construction",
     "type": "esriFieldTypeString",
     "alias": "Construction",
     "length": 3,
     "domain": null
    },
    {
     "name": "BedroomCount",
     "type": "esriFieldTypeSmallInteger",
     "alias": "BedroomCount",
     "domain": null
    },
    {
     "name": "FullBath",
     "type": "esriFieldTypeSmallInteger",
     "alias": "FullBath",
     "domain": null
    },
    {
     "name": "HalfBath",
     "type": "esriFieldTypeSmallInteger",
     "alias": "HalfBath",
     "domain": null
    },
    {
     "name": "ExtraFixtures",
     "type": "esriFieldTypeSmallInteger",
     "alias": "ExtraFixtures",
     "domain": null
    },
    {
     "name": "BuiltYear",
     "type": "esriFieldTypeString",
     "alias": "BuiltYear",
     "length": 4,
     "domain": null
    },
    {
     "name": "Remodeled",
     "type": "esriFieldTypeString",
     "alias": "Remodeled",
     "length": 4,
     "domain": null
    },
    {
     "name": "LivingArea",
     "type": "esriFieldTypeInteger",
     "alias": "LivingArea",
     "domain": null
    },
    {
     "name": "id",
     "type": "esriFieldTypeOID",
     "alias": "id",
     "domain": null
    }
   ],
   "indexes": [
    {
     "name": "ClusteredIndex-20201123-113122",
     "fields": "parcel,id",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    },
    {
     "name": "R14_SDE_ROWID_UK",
     "fields": "id",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    }
   ],
   "subtypes": [],
   "relationships": [
    {
     "id": 1,
     "name": "sde.parcelSaleinfoAdvance",
     "relatedTableId": 0,
     "role": "esriRelRoleDestination",
     "keyField": "parcel",
     "cardinality": "esriRelCardinalityOneToMany",
     "composite": false,
     "catalogID": "{8B130F19-4478-4023-84CA-BC8CA979F6C4}"
    }
   ],
   "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": "251ed7b504854de18e509e5712d1345a"
  },
  {
   "currentVersion": 11.3,
   "cimVersion": "3.3.0",
   "id": 3,
   "name": "Sale Info",
   "type": "Table",
   "description": null,
   "hasAttachments": false,
   "htmlPopupType": "esriServerHTMLPopupTypeNone",
   "displayField": "parcel",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "parcel",
     "type": "esriFieldTypeString",
     "alias": "parcel",
     "length": 13,
     "domain": null
    },
    {
     "name": "conveyanceNo",
     "type": "esriFieldTypeInteger",
     "alias": "conveyanceNo",
     "domain": null
    },
    {
     "name": "isValidSale",
     "type": "esriFieldTypeSmallInteger",
     "alias": "isValidSale",
     "domain": null
    },
    {
     "name": "saledate",
     "type": "esriFieldTypeDate",
     "alias": "saledate",
     "length": 8,
     "domain": null
    },
    {
     "name": "toRemark",
     "type": "esriFieldTypeString",
     "alias": "toRemark",
     "length": 100,
     "domain": null
    },
    {
     "name": "salePrice",
     "type": "esriFieldTypeDouble",
     "alias": "salePrice",
     "domain": null
    },
    {
     "name": "typeOfSale",
     "type": "esriFieldTypeString",
     "alias": "typeOfSale",
     "length": 5,
     "domain": null
    },
    {
     "name": "parcelclass",
     "type": "esriFieldTypeString",
     "alias": "parcelclass",
     "length": 3,
     "domain": null
    },
    {
     "name": "SaleDailySequence",
     "type": "esriFieldTypeInteger",
     "alias": "SaleDailySequence",
     "domain": null
    },
    {
     "name": "NumberofParcelsInSale",
     "type": "esriFieldTypeInteger",
     "alias": "NumberofParcelsInSale",
     "domain": null
    },
    {
     "name": "id",
     "type": "esriFieldTypeOID",
     "alias": "id",
     "domain": null
    },
    {
     "name": "P#",
     "type": "esriFieldTypeString",
     "alias": "P#",
     "length": 3,
     "domain": null
    }
   ],
   "indexes": [
    {
     "name": "ClusteredIndex-20201123-113145",
     "fields": "parcel,id",
     "isAscending": true,
     "isUnique": false,
     "description": ""
    },
    {
     "name": "R15_SDE_ROWID_UK",
     "fields": "id",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    }
   ],
   "subtypes": [],
   "relationships": [
    {
     "id": 0,
     "name": "sde.parcelSaleinfoAdvance",
     "relatedTableId": 0,
     "role": "esriRelRoleDestination",
     "keyField": "parcel",
     "cardinality": "esriRelCardinalityOneToMany",
     "composite": false,
     "catalogID": "{97F6B507-2259-40BD-9257-F31E299465AE}"
    }
   ],
   "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": "251ed7b504854de18e509e5712d1345a"
  }
 ]
}