{
 "currentVersion": 10.71,
 "id": 9,
 "name": "SDE.DBO.Adata",
 "type": "Table",
 "description": null,
 "hasAttachments": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "name",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "schno",
   "type": "esriFieldTypeInteger",
   "alias": "schno",
   "domain": null
  },
  {
   "name": "ppi",
   "type": "esriFieldTypeString",
   "alias": "ppi",
   "length": 255,
   "domain": null
  },
  {
   "name": "subcode",
   "type": "esriFieldTypeInteger",
   "alias": "subcode",
   "domain": null
  },
  {
   "name": "subdesc",
   "type": "esriFieldTypeString",
   "alias": "subdesc",
   "length": 255,
   "domain": null
  },
  {
   "name": "filing",
   "type": "esriFieldTypeInteger",
   "alias": "filing",
   "domain": null
  },
  {
   "name": "phase",
   "type": "esriFieldTypeInteger",
   "alias": "phase",
   "domain": null
  },
  {
   "name": "block",
   "type": "esriFieldTypeString",
   "alias": "block",
   "length": 255,
   "domain": null
  },
  {
   "name": "lot",
   "type": "esriFieldTypeString",
   "alias": "lot",
   "length": 255,
   "domain": null
  },
  {
   "name": "legal1",
   "type": "esriFieldTypeString",
   "alias": "legal1",
   "length": 255,
   "domain": null
  },
  {
   "name": "legal2",
   "type": "esriFieldTypeString",
   "alias": "legal2",
   "length": 255,
   "domain": null
  },
  {
   "name": "legal3",
   "type": "esriFieldTypeString",
   "alias": "legal3",
   "length": 255,
   "domain": null
  },
  {
   "name": "legal4",
   "type": "esriFieldTypeString",
   "alias": "legal4",
   "length": 255,
   "domain": null
  },
  {
   "name": "legal_etal",
   "type": "esriFieldTypeString",
   "alias": "legal_etal",
   "length": 255,
   "domain": null
  },
  {
   "name": "econ",
   "type": "esriFieldTypeString",
   "alias": "econ",
   "length": 255,
   "domain": null
  },
  {
   "name": "nhood",
   "type": "esriFieldTypeString",
   "alias": "nhood",
   "length": 255,
   "domain": null
  },
  {
   "name": "house",
   "type": "esriFieldTypeString",
   "alias": "house",
   "length": 255,
   "domain": null
  },
  {
   "name": "pdir",
   "type": "esriFieldTypeString",
   "alias": "pdir",
   "length": 255,
   "domain": null
  },
  {
   "name": "name",
   "type": "esriFieldTypeString",
   "alias": "name",
   "length": 255,
   "domain": null
  },
  {
   "name": "suff",
   "type": "esriFieldTypeString",
   "alias": "suff",
   "length": 255,
   "domain": null
  },
  {
   "name": "sdir",
   "type": "esriFieldTypeString",
   "alias": "sdir",
   "length": 255,
   "domain": null
  },
  {
   "name": "unit",
   "type": "esriFieldTypeString",
   "alias": "unit",
   "length": 255,
   "domain": null
  },
  {
   "name": "town",
   "type": "esriFieldTypeString",
   "alias": "town",
   "length": 255,
   "domain": null
  },
  {
   "name": "num",
   "type": "esriFieldTypeString",
   "alias": "num",
   "length": 255,
   "domain": null
  },
  {
   "name": "abst1",
   "type": "esriFieldTypeInteger",
   "alias": "abst1",
   "domain": null
  },
  {
   "name": "abst2",
   "type": "esriFieldTypeInteger",
   "alias": "abst2",
   "domain": null
  },
  {
   "name": "abst3",
   "type": "esriFieldTypeInteger",
   "alias": "abst3",
   "domain": null
  },
  {
   "name": "abst4",
   "type": "esriFieldTypeInteger",
   "alias": "abst4",
   "domain": null
  },
  {
   "name": "more_abst",
   "type": "esriFieldTypeString",
   "alias": "more_abst",
   "length": 255,
   "domain": null
  },
  {
   "name": "totlandval",
   "type": "esriFieldTypeInteger",
   "alias": "totlandval",
   "domain": null
  },
  {
   "name": "totimpval",
   "type": "esriFieldTypeInteger",
   "alias": "totimpval",
   "domain": null
  },
  {
   "name": "totactval",
   "type": "esriFieldTypeInteger",
   "alias": "totactval",
   "domain": null
  },
  {
   "name": "totassval",
   "type": "esriFieldTypeInteger",
   "alias": "totassval",
   "domain": null
  },
  {
   "name": "tax_year",
   "type": "esriFieldTypeString",
   "alias": "tax_year",
   "length": 255,
   "domain": null
  },
  {
   "name": "tax_area",
   "type": "esriFieldTypeString",
   "alias": "tax_area",
   "length": 255,
   "domain": null
  },
  {
   "name": "mills",
   "type": "esriFieldTypeString",
   "alias": "mills",
   "length": 255,
   "domain": null
  },
  {
   "name": "p_ownerf",
   "type": "esriFieldTypeString",
   "alias": "p_ownerf",
   "length": 255,
   "domain": null
  },
  {
   "name": "p_ownerl",
   "type": "esriFieldTypeString",
   "alias": "p_ownerl",
   "length": 255,
   "domain": null
  },
  {
   "name": "s_ownerf",
   "type": "esriFieldTypeString",
   "alias": "s_ownerf",
   "length": 255,
   "domain": null
  },
  {
   "name": "s_ownerl",
   "type": "esriFieldTypeString",
   "alias": "s_ownerl",
   "length": 255,
   "domain": null
  },
  {
   "name": "owner_etal",
   "type": "esriFieldTypeString",
   "alias": "owner_etal",
   "length": 255,
   "domain": null
  },
  {
   "name": "care_of",
   "type": "esriFieldTypeString",
   "alias": "care_of",
   "length": 255,
   "domain": null
  },
  {
   "name": "address",
   "type": "esriFieldTypeString",
   "alias": "address",
   "length": 255,
   "domain": null
  },
  {
   "name": "city",
   "type": "esriFieldTypeString",
   "alias": "city",
   "length": 255,
   "domain": null
  },
  {
   "name": "state",
   "type": "esriFieldTypeString",
   "alias": "state",
   "length": 255,
   "domain": null
  },
  {
   "name": "zip",
   "type": "esriFieldTypeString",
   "alias": "zip",
   "length": 255,
   "domain": null
  },
  {
   "name": "recno1",
   "type": "esriFieldTypeString",
   "alias": "recno1",
   "length": 255,
   "domain": null
  },
  {
   "name": "recdate1",
   "type": "esriFieldTypeString",
   "alias": "recdate1",
   "length": 255,
   "domain": null
  },
  {
   "name": "rectype1",
   "type": "esriFieldTypeString",
   "alias": "rectype1",
   "length": 255,
   "domain": null
  },
  {
   "name": "docfee1",
   "type": "esriFieldTypeString",
   "alias": "docfee1",
   "length": 255,
   "domain": null
  },
  {
   "name": "recno2",
   "type": "esriFieldTypeString",
   "alias": "recno2",
   "length": 255,
   "domain": null
  },
  {
   "name": "recdate2",
   "type": "esriFieldTypeString",
   "alias": "recdate2",
   "length": 255,
   "domain": null
  },
  {
   "name": "rectype2",
   "type": "esriFieldTypeString",
   "alias": "rectype2",
   "length": 255,
   "domain": null
  },
  {
   "name": "docfee2",
   "type": "esriFieldTypeString",
   "alias": "docfee2",
   "length": 255,
   "domain": null
  },
  {
   "name": "recno3",
   "type": "esriFieldTypeString",
   "alias": "recno3",
   "length": 255,
   "domain": null
  },
  {
   "name": "recdate3",
   "type": "esriFieldTypeString",
   "alias": "recdate3",
   "length": 255,
   "domain": null
  },
  {
   "name": "rectype3",
   "type": "esriFieldTypeString",
   "alias": "rectype3",
   "length": 255,
   "domain": null
  },
  {
   "name": "docfee3",
   "type": "esriFieldTypeString",
   "alias": "docfee3",
   "length": 255,
   "domain": null
  },
  {
   "name": "recno4",
   "type": "esriFieldTypeString",
   "alias": "recno4",
   "length": 255,
   "domain": null
  },
  {
   "name": "recdate4",
   "type": "esriFieldTypeString",
   "alias": "recdate4",
   "length": 255,
   "domain": null
  },
  {
   "name": "rectype4",
   "type": "esriFieldTypeString",
   "alias": "rectype4",
   "length": 255,
   "domain": null
  },
  {
   "name": "docfee4",
   "type": "esriFieldTypeString",
   "alias": "docfee4",
   "length": 255,
   "domain": null
  },
  {
   "name": "more_recs",
   "type": "esriFieldTypeString",
   "alias": "more_recs",
   "length": 255,
   "domain": null
  },
  {
   "name": "acres",
   "type": "esriFieldTypeString",
   "alias": "acres",
   "length": 255,
   "domain": null
  },
  {
   "name": "sqft",
   "type": "esriFieldTypeString",
   "alias": "sqft",
   "length": 255,
   "domain": null
  },
  {
   "name": "zoning",
   "type": "esriFieldTypeString",
   "alias": "zoning",
   "length": 255,
   "domain": null
  },
  {
   "name": "water",
   "type": "esriFieldTypeString",
   "alias": "water",
   "length": 255,
   "domain": null
  },
  {
   "name": "sewer",
   "type": "esriFieldTypeString",
   "alias": "sewer",
   "length": 255,
   "domain": null
  },
  {
   "name": "utils",
   "type": "esriFieldTypeString",
   "alias": "utils",
   "length": 255,
   "domain": null
  },
  {
   "name": "access",
   "type": "esriFieldTypeString",
   "alias": "access",
   "length": 255,
   "domain": null
  },
  {
   "name": "topo",
   "type": "esriFieldTypeString",
   "alias": "topo",
   "length": 255,
   "domain": null
  },
  {
   "name": "scenic_view",
   "type": "esriFieldTypeString",
   "alias": "scenic_view",
   "length": 255,
   "domain": null
  },
  {
   "name": "cover",
   "type": "esriFieldTypeString",
   "alias": "cover",
   "length": 255,
   "domain": null
  },
  {
   "name": "hydro",
   "type": "esriFieldTypeString",
   "alias": "hydro",
   "length": 255,
   "domain": null
  },
  {
   "name": "misc",
   "type": "esriFieldTypeString",
   "alias": "misc",
   "length": 255,
   "domain": null
  },
  {
   "name": "impno",
   "type": "esriFieldTypeString",
   "alias": "impno",
   "length": 255,
   "domain": null
  },
  {
   "name": "numstructs",
   "type": "esriFieldTypeString",
   "alias": "numstructs",
   "length": 255,
   "domain": null
  },
  {
   "name": "proptype",
   "type": "esriFieldTypeString",
   "alias": "proptype",
   "length": 255,
   "domain": null
  },
  {
   "name": "style",
   "type": "esriFieldTypeString",
   "alias": "style",
   "length": 255,
   "domain": null
  },
  {
   "name": "styledesc",
   "type": "esriFieldTypeString",
   "alias": "styledesc",
   "length": 255,
   "domain": null
  },
  {
   "name": "units",
   "type": "esriFieldTypeString",
   "alias": "units",
   "length": 255,
   "domain": null
  },
  {
   "name": "year_blt",
   "type": "esriFieldTypeString",
   "alias": "year_blt",
   "length": 255,
   "domain": null
  },
  {
   "name": "adj_year_blt",
   "type": "esriFieldTypeString",
   "alias": "adj_year_blt",
   "length": 255,
   "domain": null
  },
  {
   "name": "grade",
   "type": "esriFieldTypeString",
   "alias": "grade",
   "length": 255,
   "domain": null
  },
  {
   "name": "cond",
   "type": "esriFieldTypeString",
   "alias": "cond",
   "length": 255,
   "domain": null
  },
  {
   "name": "xwall",
   "type": "esriFieldTypeString",
   "alias": "xwall",
   "length": 255,
   "domain": null
  },
  {
   "name": "heat",
   "type": "esriFieldTypeString",
   "alias": "heat",
   "length": 255,
   "domain": null
  },
  {
   "name": "first_sqft",
   "type": "esriFieldTypeString",
   "alias": "first_sqft",
   "length": 255,
   "domain": null
  },
  {
   "name": "second_sqft",
   "type": "esriFieldTypeString",
   "alias": "second_sqft",
   "length": 255,
   "domain": null
  },
  {
   "name": "third_sqft",
   "type": "esriFieldTypeString",
   "alias": "third_sqft",
   "length": 255,
   "domain": null
  },
  {
   "name": "addn",
   "type": "esriFieldTypeString",
   "alias": "addn",
   "length": 255,
   "domain": null
  },
  {
   "name": "fin_half",
   "type": "esriFieldTypeString",
   "alias": "fin_half",
   "length": 255,
   "domain": null
  },
  {
   "name": "fin_bsmt",
   "type": "esriFieldTypeString",
   "alias": "fin_bsmt",
   "length": 255,
   "domain": null
  },
  {
   "name": "unfin_bsmt",
   "type": "esriFieldTypeString",
   "alias": "unfin_bsmt",
   "length": 255,
   "domain": null
  },
  {
   "name": "sfla",
   "type": "esriFieldTypeString",
   "alias": "sfla",
   "length": 255,
   "domain": null
  },
  {
   "name": "basement",
   "type": "esriFieldTypeString",
   "alias": "basement",
   "length": 255,
   "domain": null
  },
  {
   "name": "garage",
   "type": "esriFieldTypeString",
   "alias": "garage",
   "length": 255,
   "domain": null
  },
  {
   "name": "cars",
   "type": "esriFieldTypeString",
   "alias": "cars",
   "length": 255,
   "domain": null
  },
  {
   "name": "garage_size",
   "type": "esriFieldTypeString",
   "alias": "garage_size",
   "length": 255,
   "domain": null
  },
  {
   "name": "rooms",
   "type": "esriFieldTypeString",
   "alias": "rooms",
   "length": 255,
   "domain": null
  },
  {
   "name": "beds",
   "type": "esriFieldTypeString",
   "alias": "beds",
   "length": 255,
   "domain": null
  },
  {
   "name": "lofts",
   "type": "esriFieldTypeString",
   "alias": "lofts",
   "length": 255,
   "domain": null
  },
  {
   "name": "kitchen",
   "type": "esriFieldTypeString",
   "alias": "kitchen",
   "length": 255,
   "domain": null
  },
  {
   "name": "m_baths",
   "type": "esriFieldTypeString",
   "alias": "m_baths",
   "length": 255,
   "domain": null
  },
  {
   "name": "f_baths",
   "type": "esriFieldTypeString",
   "alias": "f_baths",
   "length": 255,
   "domain": null
  },
  {
   "name": "t_baths",
   "type": "esriFieldTypeString",
   "alias": "t_baths",
   "length": 255,
   "domain": null
  },
  {
   "name": "h_baths",
   "type": "esriFieldTypeString",
   "alias": "h_baths",
   "length": 255,
   "domain": null
  },
  {
   "name": "q_baths",
   "type": "esriFieldTypeString",
   "alias": "q_baths",
   "length": 255,
   "domain": null
  },
  {
   "name": "bath_tot",
   "type": "esriFieldTypeString",
   "alias": "bath_tot",
   "length": 255,
   "domain": null
  },
  {
   "name": "title",
   "type": "esriFieldTypeString",
   "alias": "title",
   "length": 255,
   "domain": null
  },
  {
   "name": "floor",
   "type": "esriFieldTypeString",
   "alias": "floor",
   "length": 255,
   "domain": null
  },
  {
   "name": "unit_position",
   "type": "esriFieldTypeString",
   "alias": "unit_position",
   "length": 255,
   "domain": null
  },
  {
   "name": "biztype1",
   "type": "esriFieldTypeString",
   "alias": "biztype1",
   "length": 255,
   "domain": null
  },
  {
   "name": "biztype2",
   "type": "esriFieldTypeString",
   "alias": "biztype2",
   "length": 255,
   "domain": null
  },
  {
   "name": "biztype3",
   "type": "esriFieldTypeString",
   "alias": "biztype3",
   "length": 255,
   "domain": null
  },
  {
   "name": "more_com",
   "type": "esriFieldTypeString",
   "alias": "more_com",
   "length": 255,
   "domain": null
  },
  {
   "name": "n_leases",
   "type": "esriFieldTypeString",
   "alias": "n_leases",
   "length": 255,
   "domain": null
  },
  {
   "name": "xcond",
   "type": "esriFieldTypeString",
   "alias": "xcond",
   "length": 255,
   "domain": null
  }
 ],
 "indexes": [
  {
   "name": "R350_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "GDB_6077_ppi",
   "fields": "ppi",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 0,
   "name": "SDE.DBO.Unincorp_Parcel_Frisco",
   "relatedTableId": 7,
   "role": "esriRelRoleDestination",
   "keyField": "ppi",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  },
  {
   "id": 1,
   "name": "SDE.DBO.Parcels",
   "relatedTableId": 8,
   "role": "esriRelRoleDestination",
   "keyField": "ppi",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  }
 ],
 "capabilities": "Map,Query,Data",
 "maxRecordCount": 1000,
 "supportsStatistics": true,
 "supportsAdvancedQueries": true,
 "supportedQueryFormats": "JSON",
 "isDataVersioned": false,
 "useStandardizedQueries": true,
 "advancedQueryCapabilities": {
  "useStandardizedQueries": true,
  "supportsStatistics": true,
  "supportsHavingClause": true,
  "supportsCountDistinct": true,
  "supportsOrderBy": true,
  "supportsDistinct": true,
  "supportsPagination": true,
  "supportsTrueCurve": false,
  "supportsReturningQueryExtent": true,
  "supportsQueryWithDistance": true,
  "supportsSqlExpression": true
 }
}