{
 "layers": [],
 "tables": [
  {
   "currentVersion": 11.4,
   "cimVersion": "3.4.0",
   "id": 0,
   "name": "dbo.ResidentialStatusReport",
   "type": "Table",
   "description": null,
   "hasAttachments": false,
   "htmlPopupType": "esriServerHTMLPopupTypeNone",
   "displayField": "SubdivisionName",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "ReportID",
     "type": "esriFieldTypeOID",
     "alias": "ReportID",
     "domain": null
    },
    {
     "name": "SubdivisionCode",
     "type": "esriFieldTypeString",
     "alias": "SubdivisionCode",
     "length": 50,
     "domain": null
    },
    {
     "name": "SubdivisionName",
     "type": "esriFieldTypeString",
     "alias": "SubdivisionName",
     "length": 255,
     "domain": null
    },
    {
     "name": "TaxDistrict",
     "type": "esriFieldTypeString",
     "alias": "TaxDistrict",
     "length": 100,
     "domain": null
    },
    {
     "name": "TotalLots",
     "type": "esriFieldTypeInteger",
     "alias": "TotalLots",
     "domain": null
    },
    {
     "name": "HomesComplete",
     "type": "esriFieldTypeInteger",
     "alias": "HomesComplete",
     "domain": null
    },
    {
     "name": "UnderConstruction",
     "type": "esriFieldTypeInteger",
     "alias": "UnderConstruction",
     "domain": null
    },
    {
     "name": "MinSalePrice",
     "type": "esriFieldTypeDouble",
     "alias": "MinSalePrice",
     "domain": null
    },
    {
     "name": "MaxSalePrice",
     "type": "esriFieldTypeDouble",
     "alias": "MaxSalePrice",
     "domain": null
    },
    {
     "name": "TaxYear",
     "type": "esriFieldTypeInteger",
     "alias": "TaxYear",
     "domain": null
    },
    {
     "name": "ReportGeneratedDate",
     "type": "esriFieldTypeDate",
     "alias": "ReportGeneratedDate",
     "length": 8,
     "precision": 1,
     "domain": null
    }
   ],
   "indexes": [
    {
     "name": "PK__Resident__D5BD48E5E6E21F24",
     "fields": "ReportID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    },
    {
     "name": "UQ_Subdivision_TaxYear",
     "fields": "SubdivisionName,TaxYear",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    },
    {
     "name": "FDO_ReportID",
     "fields": "ReportID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    }
   ],
   "subtypes": [],
   "relationships": [],
   "capabilities": "Query,Map,Data",
   "maxRecordCount": 2000,
   "supportsStatistics": true,
   "supportsExceedsLimitStatistics": true,
   "supportsAdvancedQueries": true,
   "supportedQueryFormats": "JSON, PBF",
   "isDataVersioned": false,
   "useStandardizedQueries": true,
   "advancedQueryCapabilities": {
    "useStandardizedQueries": true,
    "supportsStatistics": true,
    "supportsPercentileStatistics": true,
    "supportsHavingClause": true,
    "supportsOrderBy": true,
    "supportsDistinct": true,
    "supportsCountDistinct": true,
    "supportsPagination": true,
    "supportsTrueCurve": false,
    "supportsReturningQueryExtent": true,
    "supportsQueryWithDistance": true,
    "supportsSqlExpression": true,
    "supportsTimeRelation": true,
    "supportsAdvancedQueryRelated": true,
    "supportsQueryRelatedPagination": true,
    "supportsSqlFormat": false,
    "supportsQueryAnalytic": true,
    "supportsCurrentUserQueries": true
   },
   "advancedQueryAnalyticCapabilities": {
    "supportsLinearRegression": true,
    "supportsAsync": false,
    "supportsPercentileAnalytic": true
   },
   "dateFieldsTimeReference": null,
   "preferredTimeReference": null,
   "datesInUnknownTimezone": false,
   "hasMetadata": true,
   "isDataArchived": false,
   "archivingInfo": {
    "supportsQueryWithHistoricMoment": false,
    "startArchivingMoment": -1
   },
   "uniqueIdInfo": {
    "type": "simple",
    "fields": [
     "ReportID"
    ],
    "OIDFieldContainsHashValue": false
   },
   "maxUniqueIDCount": 100000,
   "serviceItemId": "428dc72e9c5b48a2bcb82778dba5d0aa"
  }
 ]
}