{
 "layers": [
  {
   "currentVersion": 11.3,
   "cimVersion": "3.3.0",
   "id": 0,
   "name": "Parcels",
   "type": "Feature Layer",
   "description": "",
   "geometryType": "esriGeometryPolygon",
   "sourceSpatialReference": {
    "wkid": 102705,
    "latestWkid": 102705,
    "xyTolerance": 0.00328083333333333,
    "zTolerance": 0.001,
    "mTolerance": 0.001,
    "falseX": -18285500,
    "falseY": -47441400,
    "xyUnits": 3048.00609601219,
    "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": [
       184,
       252,
       202,
       0
      ],
      "outline": {
       "type": "esriSLS",
       "style": "esriSLSSolid",
       "color": [
        110,
        110,
        110,
        255
       ],
       "width": 0.7
      }
     }
    },
    "scaleSymbols": true,
    "transparency": 0,
    "labelingInfo": null
   },
   "defaultVisibility": true,
   "extent": {
    "xmin": -1.078855960395126E7,
    "ymin": 4942227.759897623,
    "xmax": -1.0738099035817549E7,
    "ymax": 5019164.509228891,
    "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": "CNVYNAME",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "OBJECTID",
     "type": "esriFieldTypeOID",
     "alias": "OBJECTID",
     "domain": null
    },
    {
     "name": "SHAPE",
     "type": "esriFieldTypeGeometry",
     "alias": "Shape",
     "domain": null
    },
    {
     "name": "SHAPE.STArea()",
     "type": "esriFieldTypeDouble",
     "alias": "Shape.STArea()",
     "domain": null
    },
    {
     "name": "SHAPE.STLength()",
     "type": "esriFieldTypeDouble",
     "alias": "Shape.STLength()",
     "domain": null
    },
    {
     "name": "LOWPARCELID",
     "type": "esriFieldTypeString",
     "alias": "Lowest Parcel Identification Number",
     "length": 30,
     "domain": null
    },
    {
     "name": "PARCELID",
     "type": "esriFieldTypeString",
     "alias": "Parcel Identification Number",
     "length": 30,
     "domain": null
    },
    {
     "name": "BUILDING",
     "type": "esriFieldTypeString",
     "alias": "Building Number",
     "length": 50,
     "domain": null
    },
    {
     "name": "UNIT",
     "type": "esriFieldTypeString",
     "alias": "Unit Number",
     "length": 50,
     "domain": null
    },
    {
     "name": "GIS_AREA",
     "type": "esriFieldTypeString",
     "alias": "GIS Area",
     "length": 50,
     "domain": null
    },
    {
     "name": "LGLSTARTDT",
     "type": "esriFieldTypeDate",
     "alias": "Legal Start Date",
     "length": 8,
     "domain": null
    },
    {
     "name": "CVTTXCD",
     "type": "esriFieldTypeString",
     "alias": "Tax District Code",
     "length": 4,
     "domain": null
    },
    {
     "name": "CVTTXDSCRP",
     "type": "esriFieldTypeString",
     "alias": "Tax District Description",
     "length": 100,
     "domain": null
    },
    {
     "name": "SCHLTXCD",
     "type": "esriFieldTypeString",
     "alias": "School District Code",
     "length": 4,
     "domain": null
    },
    {
     "name": "SCHLDSCRP",
     "type": "esriFieldTypeString",
     "alias": "School District Description",
     "length": 100,
     "domain": null
    },
    {
     "name": "USECD",
     "type": "esriFieldTypeString",
     "alias": "Assessing Use Code",
     "length": 4,
     "domain": null
    },
    {
     "name": "USEDSCRP",
     "type": "esriFieldTypeString",
     "alias": "Assessing Use Description",
     "length": 100,
     "domain": null
    },
    {
     "name": "NGHBRHDCD",
     "type": "esriFieldTypeString",
     "alias": "Assessing Neighbornood Code",
     "length": 10,
     "domain": null
    },
    {
     "name": "CLASSCD",
     "type": "esriFieldTypeString",
     "alias": "Property Class Code",
     "length": 10,
     "domain": null
    },
    {
     "name": "CLASSDSCRP",
     "type": "esriFieldTypeString",
     "alias": "Property Class",
     "length": 100,
     "domain": null
    },
    {
     "name": "SITEADDRESS",
     "type": "esriFieldTypeString",
     "alias": "Site Address",
     "length": 255,
     "domain": null
    },
    {
     "name": "PRPRTYDSCRP",
     "type": "esriFieldTypeString",
     "alias": "Property Legal Description",
     "length": 320,
     "domain": null
    },
    {
     "name": "CNVYNAME",
     "type": "esriFieldTypeString",
     "alias": "Sub or Condo Name",
     "length": 500,
     "domain": null
    },
    {
     "name": "OWNERNME1",
     "type": "esriFieldTypeString",
     "alias": "First Owner Name",
     "length": 255,
     "domain": null
    },
    {
     "name": "OWNERNME2",
     "type": "esriFieldTypeString",
     "alias": "Second Owner Name",
     "length": 255,
     "domain": null
    },
    {
     "name": "PSTLADDRESS",
     "type": "esriFieldTypeString",
     "alias": "Postal Address",
     "length": 600,
     "domain": null
    },
    {
     "name": "PSTLCITY",
     "type": "esriFieldTypeString",
     "alias": "Postal City",
     "length": 255,
     "domain": null
    },
    {
     "name": "PSTLSTATE",
     "type": "esriFieldTypeString",
     "alias": "Postal State",
     "length": 5,
     "domain": null
    },
    {
     "name": "PSTLZIP5",
     "type": "esriFieldTypeString",
     "alias": "Postal Zip 5",
     "length": 10,
     "domain": null
    },
    {
     "name": "PSTLZIP4",
     "type": "esriFieldTypeString",
     "alias": "Postal Zip +4",
     "length": 4,
     "domain": null
    },
    {
     "name": "FLOORCOUNT",
     "type": "esriFieldTypeSmallInteger",
     "alias": "Number of Floors",
     "domain": null
    },
    {
     "name": "BLDGAREA",
     "type": "esriFieldTypeDouble",
     "alias": "Building Area",
     "domain": null
    },
    {
     "name": "RESFLRAREA",
     "type": "esriFieldTypeDouble",
     "alias": "Residential Floor Area",
     "domain": null
    },
    {
     "name": "RESYRBLT",
     "type": "esriFieldTypeDouble",
     "alias": "Residential Year Built",
     "domain": null
    },
    {
     "name": "RESSTRTYP",
     "type": "esriFieldTypeString",
     "alias": "Residential Structure Type",
     "length": 50,
     "domain": null
    },
    {
     "name": "STRCLASS",
     "type": "esriFieldTypeString",
     "alias": "Structure Class",
     "length": 5,
     "domain": null
    },
    {
     "name": "CLASSMOD",
     "type": "esriFieldTypeString",
     "alias": "Structure Class Modifier",
     "length": 5,
     "domain": null
    },
    {
     "name": "LNDVALUE",
     "type": "esriFieldTypeDouble",
     "alias": "Land Value",
     "domain": null
    },
    {
     "name": "PRVASSDVAL",
     "type": "esriFieldTypeDouble",
     "alias": "Previous Assessed Value",
     "domain": null
    },
    {
     "name": "CNTASSDVAL",
     "type": "esriFieldTypeDouble",
     "alias": "Current Assessed Value",
     "domain": null
    },
    {
     "name": "ASSDVALYRCG",
     "type": "esriFieldTypeDouble",
     "alias": "Assessed Value Year Over Year Change",
     "domain": null
    },
    {
     "name": "ASSDPCNTCG",
     "type": "esriFieldTypeDouble",
     "alias": "Assessed Value % Change",
     "domain": null
    },
    {
     "name": "PRVTXBLVAL",
     "type": "esriFieldTypeDouble",
     "alias": "Previous Taxable Value",
     "domain": null
    },
    {
     "name": "CNTTXBLVAL",
     "type": "esriFieldTypeDouble",
     "alias": "Current Taxable Value",
     "domain": null
    },
    {
     "name": "TXBLVALYRCHG",
     "type": "esriFieldTypeDouble",
     "alias": "Taxable Value Year Over Year Change",
     "domain": null
    },
    {
     "name": "TXBLPCNTCHG",
     "type": "esriFieldTypeDouble",
     "alias": "Taxable Value % Change",
     "domain": null
    },
    {
     "name": "PRVWNTTXOD",
     "type": "esriFieldTypeDouble",
     "alias": "Previous Winter Taxes Owed",
     "domain": null
    },
    {
     "name": "PRVSMRTXOD",
     "type": "esriFieldTypeDouble",
     "alias": "Previous Summer Taxes Owed",
     "domain": null
    },
    {
     "name": "TOTPRVTXTOD",
     "type": "esriFieldTypeDouble",
     "alias": "Total Previous Taxes Owed",
     "domain": null
    },
    {
     "name": "CNTWNTTXOD",
     "type": "esriFieldTypeDouble",
     "alias": "Current Winter Taxes Owed",
     "domain": null
    },
    {
     "name": "CNTSMRTXOD",
     "type": "esriFieldTypeDouble",
     "alias": "Current Summer Taxes Owed",
     "domain": null
    },
    {
     "name": "TOTCNTTXOD",
     "type": "esriFieldTypeDouble",
     "alias": "Total Current Taxes Owed",
     "domain": null
    },
    {
     "name": "TXODYRCHG",
     "type": "esriFieldTypeDouble",
     "alias": "Taxes Owed Year Over Year Change",
     "domain": null
    },
    {
     "name": "TXODPCNTCHG",
     "type": "esriFieldTypeDouble",
     "alias": "Taxes Owed % Change",
     "domain": null
    },
    {
     "name": "WATERSERV",
     "type": "esriFieldTypeString",
     "alias": "Water Service Provider",
     "length": 50,
     "domain": null
    },
    {
     "name": "SEWERSERV",
     "type": "esriFieldTypeString",
     "alias": "Sewer Service Provider",
     "length": 50,
     "domain": null
    },
    {
     "name": "LASTUPDATE",
     "type": "esriFieldTypeDate",
     "alias": "Last Update Date",
     "length": 8,
     "domain": null
    },
    {
     "name": "PRIMEUSE",
     "type": "esriFieldTypeString",
     "alias": "Property Primary Use Code",
     "length": 50,
     "domain": null
    },
    {
     "name": "VALMETHOD",
     "type": "esriFieldTypeString",
     "alias": "Property Valuation Method",
     "length": 50,
     "domain": null
    },
    {
     "name": "GREENBELT",
     "type": "esriFieldTypeString",
     "alias": "Property Greenbelt Status",
     "length": 10,
     "domain": null
    },
    {
     "name": "PHOTOPATH",
     "type": "esriFieldTypeString",
     "alias": "Property Photo",
     "length": 513,
     "domain": null
    }
   ],
   "geometryField": {
    "name": "SHAPE",
    "type": "esriFieldTypeGeometry",
    "alias": "Shape"
   },
   "indexes": [
    {
     "name": "R4161_pk",
     "fields": "OBJECTID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    },
    {
     "name": "insights_1aad0a615af1c4b137e73391e800a7e6",
     "fields": "PARCELID",
     "isAscending": true,
     "isUnique": false,
     "description": ""
    },
    {
     "name": "S3895_idx",
     "fields": "SHAPE",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    }
   ],
   "subtypes": [],
   "relationships": [
    {
     "id": 0,
     "name": "LGIM.DBO.PropertySalesInformation",
     "relatedTableId": 1,
     "role": "esriRelRoleOrigin",
     "keyField": "PARCELID",
     "cardinality": "esriRelCardinalityOneToMany",
     "composite": false
    },
    {
     "id": 0,
     "name": "LGIM.dbo.asrPermits",
     "relatedTableId": 1,
     "role": "esriRelRoleOrigin",
     "keyField": "PARCELID",
     "cardinality": "esriRelCardinalityOneToMany",
     "composite": false
    }
   ],
   "canModifyLayer": true,
   "canScaleSymbols": false,
   "hasLabels": false,
   "capabilities": "Map,Query,Data",
   "maxRecordCount": 10000,
   "supportsStatistics": true,
   "supportsExceedsLimitStatistics": true,
   "supportsAdvancedQueries": true,
   "supportedQueryFormats": "JSON, geoJSON, PBF",
   "isDataVersioned": false,
   "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true},
   "useStandardizedQueries": true,
   "supportedSpatialRelationships": [
    "esriSpatialRelIntersects",
    "esriSpatialRelContains",
    "esriSpatialRelCrosses",
    "esriSpatialRelEnvelopeIntersects",
    "esriSpatialRelIndexIntersects",
    "esriSpatialRelOverlaps",
    "esriSpatialRelTouches",
    "esriSpatialRelWithin",
    "esriSpatialRelRelation"
   ],
   "advancedQueryCapabilities": {
    "useStandardizedQueries": true,
    "supportsStatistics": true,
    "supportsPercentileStatistics": true,
    "supportsHavingClause": true,
    "supportsOrderBy": true,
    "supportsDistinct": true,
    "supportsCountDistinct": true,
    "supportsAdvancedQueryRelated": true,
    "supportsQueryRelatedPagination": true,
    "supportsPagination": true,
    "supportsLod": false,
    "supportsQueryWithLodSR": false,
    "supportsTrueCurve": true,
    "supportsQueryWithDatumTransformation": true,
    "supportsReturningQueryExtent": true,
    "supportsQueryWithDistance": true,
    "supportsSqlExpression": true,
    "supportsTimeRelation": true,
    "supportsSqlFormat": false,
    "supportsQueryAnalytic": true,
    "supportsCurrentUserQueries": true
   },
   "supportsDatumTransformation": true,
   "advancedQueryAnalyticCapabilities": {
    "supportsLinearRegression": true,
    "supportsAsync": false,
    "supportsPercentileAnalytic": true
   },
   "dateFieldsTimeReference": null,
   "preferredTimeReference": null,
   "datesInUnknownTimezone": false,
   "hasGeometryProperties": true,
   "geometryProperties": {
    "shapeAreaFieldName": "SHAPE.STArea()",
    "shapeLengthFieldName": "SHAPE.STLength()",
    "units": "esriFeet",
    "mapUnits": {"uwkid": 9003}
   },
   "hasMetadata": true,
   "isDataArchived": false,
   "archivingInfo": {
    "supportsQueryWithHistoricMoment": false,
    "startArchivingMoment": -1
   },
   "supportsCoordinatesQuantization": true,
   "supportsDynamicLegends": true,
   "serviceItemId": "af8366893662497ea3b9cfd841eec2a2"
  }
 ],
 "tables": [
  {
   "currentVersion": 11.3,
   "cimVersion": "3.3.0",
   "id": 1,
   "name": "Sales",
   "type": "Table",
   "description": null,
   "hasAttachments": false,
   "htmlPopupType": "esriServerHTMLPopupTypeNone",
   "displayField": "SaleDate",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "OBJECTID",
     "type": "esriFieldTypeOID",
     "alias": "OBJECTID",
     "domain": null
    },
    {
     "name": "PID",
     "type": "esriFieldTypeString",
     "alias": "PID",
     "length": 50,
     "domain": null
    },
    {
     "name": "InstNum",
     "type": "esriFieldTypeString",
     "alias": "Instrument Number",
     "length": 50,
     "domain": null
    },
    {
     "name": "InstType",
     "type": "esriFieldTypeString",
     "alias": "Instrument Type",
     "length": 50,
     "domain": null
    },
    {
     "name": "SalePrice",
     "type": "esriFieldTypeDouble",
     "alias": "Sale Price",
     "domain": null
    },
    {
     "name": "SaleDate",
     "type": "esriFieldTypeDate",
     "alias": "Sale Date",
     "length": 8,
     "domain": null
    },
    {
     "name": "SaleType",
     "type": "esriFieldTypeString",
     "alias": "Sale Type",
     "length": 50,
     "domain": null
    },
    {
     "name": "SaleValidityCode",
     "type": "esriFieldTypeString",
     "alias": "Sale Validity Code",
     "length": 50,
     "domain": null
    },
    {
     "name": "Appraiser",
     "type": "esriFieldTypeString",
     "alias": "Appraiser",
     "length": 50,
     "domain": null
    },
    {
     "name": "NBH",
     "type": "esriFieldTypeString",
     "alias": "NBH",
     "length": 50,
     "domain": null
    },
    {
     "name": "NBHGroup",
     "type": "esriFieldTypeString",
     "alias": "NBH Group",
     "length": 50,
     "domain": null
    },
    {
     "name": "NBHModel",
     "type": "esriFieldTypeString",
     "alias": "NBH Model",
     "length": 50,
     "domain": null
    },
    {
     "name": "SaleRatioSiteValue",
     "type": "esriFieldTypeDouble",
     "alias": "Sale Ratio Site Value",
     "domain": null
    },
    {
     "name": "SaleRatioTotalValue",
     "type": "esriFieldTypeDouble",
     "alias": "Sale Ratio Total Value",
     "domain": null
    },
    {
     "name": "MktLandType",
     "type": "esriFieldTypeString",
     "alias": "Market Land Type",
     "length": 50,
     "domain": null
    },
    {
     "name": "InflCode1",
     "type": "esriFieldTypeString",
     "alias": "Influence Code 1",
     "length": 50,
     "domain": null
    },
    {
     "name": "InflCode2",
     "type": "esriFieldTypeString",
     "alias": "Influence Code 2",
     "length": 50,
     "domain": null
    },
    {
     "name": "ResBldgFoundation",
     "type": "esriFieldTypeString",
     "alias": "ResBldg Foundation",
     "length": 50,
     "domain": null
    },
    {
     "name": "PropType",
     "type": "esriFieldTypeString",
     "alias": "Property Type",
     "length": 20,
     "domain": null
    },
    {
     "name": "SiteAddress",
     "type": "esriFieldTypeString",
     "alias": "Site Address",
     "length": 500,
     "domain": null
    },
    {
     "name": "TaxDistCode",
     "type": "esriFieldTypeString",
     "alias": "Tax District Code",
     "length": 20,
     "domain": null
    },
    {
     "name": "RecordedDate",
     "type": "esriFieldTypeDate",
     "alias": "Date Recorded",
     "length": 8,
     "domain": null
    },
    {
     "name": "Grantor",
     "type": "esriFieldTypeString",
     "alias": "Grantor",
     "length": 167,
     "domain": null
    },
    {
     "name": "Grantee",
     "type": "esriFieldTypeString",
     "alias": "Grantee",
     "length": 167,
     "domain": null
    },
    {
     "name": "SalePriceSF",
     "type": "esriFieldTypeDouble",
     "alias": "Sale Price/SF",
     "domain": null
    },
    {
     "name": "AssdValue",
     "type": "esriFieldTypeInteger",
     "alias": "AssdValue",
     "domain": null
    },
    {
     "name": "ResStructureType",
     "type": "esriFieldTypeString",
     "alias": "Residential Structure Type",
     "length": 50,
     "domain": null
    },
    {
     "name": "ResYrBlt",
     "type": "esriFieldTypeDouble",
     "alias": "Residential Year Built",
     "domain": null
    },
    {
     "name": "ResFlrArea",
     "type": "esriFieldTypeDouble",
     "alias": "Residential Floor Area",
     "domain": null
    },
    {
     "name": "PhotoPath",
     "type": "esriFieldTypeString",
     "alias": "PhotoPath",
     "length": 513,
     "domain": null
    }
   ],
   "indexes": [
    {
     "name": "R2826_SDE_ROWID_UK",
     "fields": "OBJECTID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    },
    {
     "name": "GDB_44317_PID",
     "fields": "PID",
     "isAscending": true,
     "isUnique": false,
     "description": ""
    },
    {
     "name": "insights_0851fda2cc3f8edf7397353e1fcdc26c",
     "fields": "PID",
     "isAscending": true,
     "isUnique": false,
     "description": ""
    },
    {
     "name": "insights_84087f1d90b9f7eaefda5c83b7c544d3",
     "fields": "SaleDate",
     "isAscending": true,
     "isUnique": false,
     "description": ""
    },
    {
     "name": "insights_19343e28dcfee4de63cdd925739a24d4",
     "fields": "NBH",
     "isAscending": true,
     "isUnique": false,
     "description": ""
    },
    {
     "name": "insights_657686f4d4bdd5d28102a2115954fc1a",
     "fields": "OBJECTID",
     "isAscending": true,
     "isUnique": false,
     "description": ""
    }
   ],
   "subtypes": [],
   "relationships": [
    {
     "id": 0,
     "name": "LGIM.DBO.TaxParcel",
     "relatedTableId": 0,
     "role": "esriRelRoleDestination",
     "keyField": "PID",
     "cardinality": "esriRelCardinalityOneToMany",
     "composite": false
    }
   ],
   "capabilities": "Map,Query,Data",
   "maxRecordCount": 10000,
   "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": "af8366893662497ea3b9cfd841eec2a2"
  },
  {
   "currentVersion": 11.3,
   "cimVersion": "3.3.0",
   "id": 2,
   "name": "Permits",
   "type": "Table",
   "description": null,
   "hasAttachments": false,
   "htmlPopupType": "esriServerHTMLPopupTypeNone",
   "displayField": "Permit",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "Appr",
     "type": "esriFieldTypeString",
     "alias": "Appr",
     "length": 20,
     "domain": null
    },
    {
     "name": "PrpCls",
     "type": "esriFieldTypeString",
     "alias": "PrpCls",
     "length": 20,
     "domain": null
    },
    {
     "name": "PrUse",
     "type": "esriFieldTypeString",
     "alias": "PrUse",
     "length": 20,
     "domain": null
    },
    {
     "name": "NBHD",
     "type": "esriFieldTypeString",
     "alias": "NBHD",
     "length": 20,
     "domain": null
    },
    {
     "name": "NBHMod",
     "type": "esriFieldTypeString",
     "alias": "NBHMod",
     "length": 20,
     "domain": null
    },
    {
     "name": "PID",
     "type": "esriFieldTypeString",
     "alias": "PID",
     "length": 60,
     "domain": null
    },
    {
     "name": "Situs",
     "type": "esriFieldTypeString",
     "alias": "Situs",
     "length": 500,
     "domain": null
    },
    {
     "name": "Infl1",
     "type": "esriFieldTypeString",
     "alias": "Infl1",
     "length": 20,
     "domain": null
    },
    {
     "name": "Infl2",
     "type": "esriFieldTypeString",
     "alias": "Infl2",
     "length": 20,
     "domain": null
    },
    {
     "name": "InflCom",
     "type": "esriFieldTypeString",
     "alias": "InflCom",
     "length": 20,
     "domain": null
    },
    {
     "name": "Permit",
     "type": "esriFieldTypeString",
     "alias": "Permit",
     "length": 30,
     "domain": null
    },
    {
     "name": "PmtStatus",
     "type": "esriFieldTypeString",
     "alias": "PmtStatus",
     "length": 20,
     "domain": null
    },
    {
     "name": "PmtType",
     "type": "esriFieldTypeString",
     "alias": "PmtType",
     "length": 20,
     "domain": null
    },
    {
     "name": "PmtDesc",
     "type": "esriFieldTypeString",
     "alias": "PmtDesc",
     "length": 60,
     "domain": null
    },
    {
     "name": "InspReason",
     "type": "esriFieldTypeString",
     "alias": "InspReason",
     "length": 20,
     "domain": null
    },
    {
     "name": "BldgType",
     "type": "esriFieldTypeString",
     "alias": "BldgType",
     "length": 20,
     "domain": null
    },
    {
     "name": "BldgPctComp",
     "type": "esriFieldTypeInteger",
     "alias": "BldgPctComp",
     "domain": null
    },
    {
     "name": "Description",
     "type": "esriFieldTypeString",
     "alias": "Description",
     "length": 1073741822,
     "domain": null
    },
    {
     "name": "Amount",
     "type": "esriFieldTypeInteger",
     "alias": "Amount",
     "domain": null
    },
    {
     "name": "NoteCode",
     "type": "esriFieldTypeString",
     "alias": "NoteCode",
     "length": 1073741822,
     "domain": null
    },
    {
     "name": "FVAppraiser",
     "type": "esriFieldTypeString",
     "alias": "FVAppraiser",
     "length": 60,
     "domain": null
    },
    {
     "name": "Method",
     "type": "esriFieldTypeString",
     "alias": "Method",
     "length": 50,
     "domain": null
    },
    {
     "name": "FinalTotal",
     "type": "esriFieldTypeDouble",
     "alias": "FinalTotal",
     "domain": null
    },
    {
     "name": "Growth",
     "type": "esriFieldTypeDouble",
     "alias": "Growth",
     "domain": null
    },
    {
     "name": "OBJECTID",
     "type": "esriFieldTypeOID",
     "alias": "OBJECTID",
     "domain": null
    },
    {
     "name": "IssueDate",
     "type": "esriFieldTypeDate",
     "alias": "IssueDate",
     "length": 8,
     "domain": null
    },
    {
     "name": "InspDate",
     "type": "esriFieldTypeDate",
     "alias": "InspDate",
     "length": 8,
     "domain": null
    },
    {
     "name": "PropType",
     "type": "esriFieldTypeString",
     "alias": "PropType",
     "length": 50,
     "domain": null
    }
   ],
   "indexes": [
    {
     "name": "R4860_SDE_ROWID_UK",
     "fields": "OBJECTID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    }
   ],
   "subtypes": [],
   "relationships": [
    {
     "id": 0,
     "name": "LGIM.DBO.TaxParcel",
     "relatedTableId": 0,
     "role": "esriRelRoleDestination",
     "keyField": "PID",
     "cardinality": "esriRelCardinalityOneToMany",
     "composite": false
    }
   ],
   "capabilities": "Map,Query,Data",
   "maxRecordCount": 10000,
   "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": "af8366893662497ea3b9cfd841eec2a2"
  },
  {
   "currentVersion": 11.3,
   "cimVersion": "3.3.0",
   "id": 3,
   "name": "Values",
   "type": "Table",
   "description": null,
   "hasAttachments": false,
   "htmlPopupType": "esriServerHTMLPopupTypeNone",
   "displayField": "Year",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "OBJECTID",
     "type": "esriFieldTypeOID",
     "alias": "OBJECTID",
     "domain": null
    },
    {
     "name": "Year",
     "type": "esriFieldTypeSmallInteger",
     "alias": "Year",
     "domain": null
    },
    {
     "name": "AgImpAvgAssdVal",
     "type": "esriFieldTypeInteger",
     "alias": "AvgAssdValue",
     "domain": null
    },
    {
     "name": "ComImpAvgAssdVal",
     "type": "esriFieldTypeDouble",
     "alias": "ComImpAvgAssdVal",
     "domain": null
    },
    {
     "name": "ResImpAvgAssdVal",
     "type": "esriFieldTypeInteger",
     "alias": "ResImpAvgAssdVal",
     "domain": null
    },
    {
     "name": "AgVacAvgAssdVal",
     "type": "esriFieldTypeInteger",
     "alias": "AgVacAvgAssdVal",
     "domain": null
    },
    {
     "name": "ComVacAvgAssdVal",
     "type": "esriFieldTypeInteger",
     "alias": "ComVacAvgAssdVal",
     "domain": null
    },
    {
     "name": "ResVacAvgAssdVal",
     "type": "esriFieldTypeInteger",
     "alias": "ResVacAvgAssdVal",
     "domain": null
    }
   ],
   "indexes": [
    {
     "name": "R4856_SDE_ROWID_UK",
     "fields": "OBJECTID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    }
   ],
   "subtypes": [],
   "relationships": [],
   "capabilities": "Map,Query,Data",
   "maxRecordCount": 10000,
   "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": "af8366893662497ea3b9cfd841eec2a2"
  },
  {
   "currentVersion": 11.3,
   "cimVersion": "3.3.0",
   "id": 4,
   "name": "PermitCounts",
   "type": "Table",
   "description": null,
   "hasAttachments": false,
   "htmlPopupType": "esriServerHTMLPopupTypeNone",
   "displayField": "ValueRange",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "ValueRange",
     "type": "esriFieldTypeString",
     "alias": "ValueRange",
     "length": 50,
     "domain": null
    },
    {
     "name": "PermitPercent",
     "type": "esriFieldTypeSingle",
     "alias": "PermitPercent",
     "domain": null
    },
    {
     "name": "OBJECTID",
     "type": "esriFieldTypeOID",
     "alias": "OBJECTID",
     "domain": null
    },
    {
     "name": "PermitCount",
     "type": "esriFieldTypeInteger",
     "alias": "PermitCount",
     "domain": null
    }
   ],
   "indexes": [
    {
     "name": "R4871_SDE_ROWID_UK",
     "fields": "OBJECTID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    }
   ],
   "subtypes": [],
   "relationships": [],
   "capabilities": "Map,Query,Data",
   "maxRecordCount": 10000,
   "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": "af8366893662497ea3b9cfd841eec2a2"
  },
  {
   "currentVersion": 11.3,
   "cimVersion": "3.3.0",
   "id": 5,
   "name": "AssdValueRange",
   "type": "Table",
   "description": null,
   "hasAttachments": false,
   "htmlPopupType": "esriServerHTMLPopupTypeNone",
   "displayField": "ValueRange",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "ValueRange",
     "type": "esriFieldTypeString",
     "alias": "ValueRange",
     "length": 50,
     "domain": null
    },
    {
     "name": "PropertyPercent",
     "type": "esriFieldTypeSingle",
     "alias": "PropertyPercent",
     "domain": null
    },
    {
     "name": "OBJECTID",
     "type": "esriFieldTypeOID",
     "alias": "OBJECTID",
     "domain": null
    },
    {
     "name": "PropertyCount",
     "type": "esriFieldTypeInteger",
     "alias": "PropertyCount",
     "domain": null
    }
   ],
   "indexes": [
    {
     "name": "R4878_SDE_ROWID_UK",
     "fields": "OBJECTID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    }
   ],
   "subtypes": [],
   "relationships": [],
   "capabilities": "Map,Query,Data",
   "maxRecordCount": 10000,
   "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": "af8366893662497ea3b9cfd841eec2a2"
  },
  {
   "currentVersion": 11.3,
   "cimVersion": "3.3.0",
   "id": 6,
   "name": "AssedValueCount",
   "type": "Table",
   "description": null,
   "hasAttachments": false,
   "htmlPopupType": "esriServerHTMLPopupTypeNone",
   "displayField": "PropType",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "PropType",
     "type": "esriFieldTypeString",
     "alias": "PropType",
     "length": 20,
     "domain": null
    },
    {
     "name": "PropertyCount",
     "type": "esriFieldTypeInteger",
     "alias": "PropertyCount",
     "domain": null
    },
    {
     "name": "AssessedValue",
     "type": "esriFieldTypeDouble",
     "alias": "AssessedValue",
     "domain": null
    },
    {
     "name": "OBJECTID",
     "type": "esriFieldTypeOID",
     "alias": "OBJECTID",
     "domain": null
    }
   ],
   "indexes": [
    {
     "name": "R4879_SDE_ROWID_UK",
     "fields": "OBJECTID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    }
   ],
   "subtypes": [],
   "relationships": [],
   "capabilities": "Map,Query,Data",
   "maxRecordCount": 10000,
   "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": "af8366893662497ea3b9cfd841eec2a2"
  },
  {
   "currentVersion": 11.3,
   "cimVersion": "3.3.0",
   "id": 7,
   "name": "AvgSalePrice",
   "type": "Table",
   "description": null,
   "hasAttachments": false,
   "htmlPopupType": "esriServerHTMLPopupTypeNone",
   "displayField": "Year",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "OBJECTID",
     "type": "esriFieldTypeOID",
     "alias": "OBJECTID",
     "domain": null
    },
    {
     "name": "Year",
     "type": "esriFieldTypeSmallInteger",
     "alias": "Year",
     "domain": null
    },
    {
     "name": "AvgSalePrice",
     "type": "esriFieldTypeInteger",
     "alias": "Average Sale Price",
     "domain": null
    },
    {
     "name": "SaleType",
     "type": "esriFieldTypeString",
     "alias": "Sale Type",
     "length": 20,
     "domain": null
    },
    {
     "name": "PropType",
     "type": "esriFieldTypeString",
     "alias": "Property Type",
     "length": 20,
     "domain": null
    },
    {
     "name": "SaleCount",
     "type": "esriFieldTypeSmallInteger",
     "alias": "Sale Count",
     "domain": null
    },
    {
     "name": "MedSalePrice",
     "type": "esriFieldTypeInteger",
     "alias": "Median Sale Price",
     "domain": null
    },
    {
     "name": "MedAssdValue",
     "type": "esriFieldTypeInteger",
     "alias": "Median Assessed Value",
     "domain": null
    },
    {
     "name": "TotalSaleAmount",
     "type": "esriFieldTypeInteger",
     "alias": "Total Sale Amount",
     "domain": null
    },
    {
     "name": "Month",
     "type": "esriFieldTypeSmallInteger",
     "alias": "Month",
     "domain": null
    }
   ],
   "indexes": [
    {
     "name": "R4947_SDE_ROWID_UK",
     "fields": "OBJECTID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    }
   ],
   "subtypes": [],
   "relationships": [],
   "capabilities": "Map,Query,Data",
   "maxRecordCount": 10000,
   "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": "af8366893662497ea3b9cfd841eec2a2"
  },
  {
   "currentVersion": 11.3,
   "cimVersion": "3.3.0",
   "id": 8,
   "name": "MonAvgSalePrice",
   "type": "Table",
   "description": null,
   "hasAttachments": false,
   "htmlPopupType": "esriServerHTMLPopupTypeNone",
   "displayField": "OBJECTID",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "OBJECTID",
     "type": "esriFieldTypeOID",
     "alias": "OBJECTID",
     "domain": null
    },
    {
     "name": "Year",
     "type": "esriFieldTypeSmallInteger",
     "alias": "Year",
     "domain": null
    },
    {
     "name": "Month",
     "type": "esriFieldTypeSmallInteger",
     "alias": "Month",
     "domain": null
    },
    {
     "name": "SaleCount",
     "type": "esriFieldTypeSmallInteger",
     "alias": "SaleCount",
     "domain": null
    },
    {
     "name": "AvgSalePrice",
     "type": "esriFieldTypeInteger",
     "alias": "AvgSalePrice",
     "domain": null
    },
    {
     "name": "TotalSaleAmt",
     "type": "esriFieldTypeInteger",
     "alias": "TotalSaleAmt",
     "domain": null
    },
    {
     "name": "MedSalePrice",
     "type": "esriFieldTypeInteger",
     "alias": "MedSalePrice",
     "domain": null
    }
   ],
   "indexes": [
    {
     "name": "R5017_SDE_ROWID_UK",
     "fields": "OBJECTID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    }
   ],
   "subtypes": [],
   "relationships": [],
   "capabilities": "Map,Query,Data",
   "maxRecordCount": 10000,
   "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": "af8366893662497ea3b9cfd841eec2a2"
  }
 ]
}