{
 "currentVersion": 10.71,
 "id": 10,
 "name": "SFR Characteristics",
 "type": "Table",
 "description": null,
 "hasAttachments": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "Parcel",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "Parcel",
   "type": "esriFieldTypeString",
   "alias": "Parcel",
   "length": 13,
   "domain": null
  },
  {
   "name": "EffectiveDateFrom",
   "type": "esriFieldTypeString",
   "alias": "Effective Date From",
   "length": 10,
   "domain": null
  },
  {
   "name": "EffectiveDateto",
   "type": "esriFieldTypeString",
   "alias": "Effective Date to",
   "length": 10,
   "domain": null
  },
  {
   "name": "Sqnce",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Sequence",
   "domain": null
  },
  {
   "name": "ConstType",
   "type": "esriFieldTypeString",
   "alias": "Const Type",
   "length": 1,
   "domain": null
  },
  {
   "name": "QualityDesc",
   "type": "esriFieldTypeString",
   "alias": "Quality",
   "length": 146,
   "domain": null
  },
  {
   "name": "Shape",
   "type": "esriFieldTypeString",
   "alias": "Shape",
   "length": 1,
   "domain": null
  },
  {
   "name": "OtherSFAddressln1",
   "type": "esriFieldTypeString",
   "alias": "SFR Addressln1",
   "length": 41,
   "domain": null
  },
  {
   "name": "OtherSFAddressln2",
   "type": "esriFieldTypeString",
   "alias": "SFR Addressln2",
   "length": 27,
   "domain": null
  },
  {
   "name": "CostTableDesc",
   "type": "esriFieldTypeString",
   "alias": "Cost Table",
   "length": 105,
   "domain": null
  },
  {
   "name": "MHMakeDesc",
   "type": "esriFieldTypeString",
   "alias": "MH Make",
   "length": 106,
   "domain": null
  },
  {
   "name": "Size_",
   "type": "esriFieldTypeInteger",
   "alias": "Size",
   "domain": null
  },
  {
   "name": "ConstYear",
   "type": "esriFieldTypeString",
   "alias": "Const Year",
   "length": 4,
   "domain": null
  },
  {
   "name": "EffYear",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Eff Year",
   "domain": null
  },
  {
   "name": "NumberofBath",
   "type": "esriFieldTypeString",
   "alias": "Nbr Bath",
   "length": 50,
   "domain": null
  },
  {
   "name": "NumberofBed",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Nbr Bdrm",
   "domain": null
  },
  {
   "name": "FamilyDen",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Family Den",
   "domain": null
  },
  {
   "name": "TotalRooms",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Total Rooms",
   "domain": null
  },
  {
   "name": "RoofTypeDesc",
   "type": "esriFieldTypeString",
   "alias": "Roof Type",
   "length": 104,
   "domain": null
  },
  {
   "name": "LandscapeDesc",
   "type": "esriFieldTypeString",
   "alias": "Landscape Quality",
   "length": 144,
   "domain": null
  },
  {
   "name": "FobsoDesc",
   "type": "esriFieldTypeString",
   "alias": "Func Obs",
   "length": 104,
   "domain": null
  },
  {
   "name": "TMSSeasonDesc",
   "type": "esriFieldTypeString",
   "alias": "TMS Season",
   "length": 105,
   "domain": null
  },
  {
   "name": "CostMod",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Cost Mod",
   "domain": null
  },
  {
   "name": "FunctionalObsoPct",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Fun Obs pct",
   "domain": null
  },
  {
   "name": "EcoObsoPct",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Eco Obso Pct",
   "domain": null
  },
  {
   "name": "DefrMaintenance",
   "type": "esriFieldTypeInteger",
   "alias": "Defr Maint",
   "domain": null
  },
  {
   "name": "Floor1Size",
   "type": "esriFieldTypeInteger",
   "alias": "Floor1 Size",
   "domain": null
  },
  {
   "name": "Floor2Size",
   "type": "esriFieldTypeInteger",
   "alias": "Floor2 Size",
   "domain": null
  },
  {
   "name": "Floor2Factor",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Floor2 Factor",
   "domain": null
  },
  {
   "name": "Floor3Size",
   "type": "esriFieldTypeInteger",
   "alias": "Floor3 Size",
   "domain": null
  },
  {
   "name": "Floor3Factor",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Floor3 Factor",
   "domain": null
  },
  {
   "name": "Bas1Size",
   "type": "esriFieldTypeInteger",
   "alias": "Bas1 Size",
   "domain": null
  },
  {
   "name": "Bas1Factor",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Bas1 Factor",
   "domain": null
  },
  {
   "name": "Bas2Size",
   "type": "esriFieldTypeInteger",
   "alias": "Bas2 Size",
   "domain": null
  },
  {
   "name": "Bas2Factor",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Bas2 Factor",
   "domain": null
  },
  {
   "name": "Add1Size",
   "type": "esriFieldTypeInteger",
   "alias": "Add1 Size",
   "domain": null
  },
  {
   "name": "Add1Factor",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Add1 Factor",
   "domain": null
  },
  {
   "name": "Add2Size",
   "type": "esriFieldTypeInteger",
   "alias": "Add2 Size",
   "domain": null
  },
  {
   "name": "Add2Factor",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Add2 Factor",
   "domain": null
  },
  {
   "name": "Add3Size",
   "type": "esriFieldTypeInteger",
   "alias": "Add3 Size",
   "domain": null
  },
  {
   "name": "Add3Factor",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Add3 Factor",
   "domain": null
  },
  {
   "name": "Pch1Size",
   "type": "esriFieldTypeInteger",
   "alias": "Pch1 Size",
   "domain": null
  },
  {
   "name": "Pch1Factor",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Pch1 Factor",
   "domain": null
  },
  {
   "name": "Pch2Size",
   "type": "esriFieldTypeInteger",
   "alias": "Pch2 Size",
   "domain": null
  },
  {
   "name": "Pch2Factor",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Pch2 Factor",
   "domain": null
  },
  {
   "name": "Pch3Size",
   "type": "esriFieldTypeInteger",
   "alias": "Pch3 Size",
   "domain": null
  },
  {
   "name": "Pch3Factor",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Pch3 Factor",
   "domain": null
  },
  {
   "name": "DeckSQF",
   "type": "esriFieldTypeInteger",
   "alias": "Deck SQF",
   "domain": null
  },
  {
   "name": "DeckFactor",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Deck Factor",
   "domain": null
  },
  {
   "name": "DeckStall",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Deck Stall",
   "domain": null
  },
  {
   "name": "PortSQF",
   "type": "esriFieldTypeInteger",
   "alias": "Port SQF",
   "domain": null
  },
  {
   "name": "PortFactor",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Port Factor",
   "domain": null
  },
  {
   "name": "PortStall",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Port Stall",
   "domain": null
  },
  {
   "name": "GarageSQF",
   "type": "esriFieldTypeInteger",
   "alias": "Garage SQF",
   "domain": null
  },
  {
   "name": "GarageClassDesc",
   "type": "esriFieldTypeString",
   "alias": "Garage Class",
   "length": 106,
   "domain": null
  },
  {
   "name": "GarageStall",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Garage Stall",
   "domain": null
  },
  {
   "name": "ACRcn",
   "type": "esriFieldTypeInteger",
   "alias": "AC Rcn",
   "domain": null
  },
  {
   "name": "HeatDesc",
   "type": "esriFieldTypeString",
   "alias": "Heat",
   "length": 104,
   "domain": null
  },
  {
   "name": "CoolDesc",
   "type": "esriFieldTypeString",
   "alias": "Cool",
   "length": 104,
   "domain": null
  },
  {
   "name": "FireplaceRcn",
   "type": "esriFieldTypeInteger",
   "alias": "Fireplace Rcn",
   "domain": null
  },
  {
   "name": "NoofFireplaces",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Nbr Fireplaces",
   "domain": null
  },
  {
   "name": "YardImpRcn",
   "type": "esriFieldTypeInteger",
   "alias": "Yard Imp Rcn",
   "domain": null
  },
  {
   "name": "MiscRcn",
   "type": "esriFieldTypeInteger",
   "alias": "Misc. Rcn",
   "domain": null
  },
  {
   "name": "PoolRcn",
   "type": "esriFieldTypeInteger",
   "alias": "Pool Rcn",
   "domain": null
  },
  {
   "name": "PoolTypeDesc",
   "type": "esriFieldTypeString",
   "alias": "Pool Type",
   "length": 144,
   "domain": null
  },
  {
   "name": "SpecialImpRcn",
   "type": "esriFieldTypeInteger",
   "alias": "spc Imp Rcn",
   "domain": null
  },
  {
   "name": "SpecialImp1Desc",
   "type": "esriFieldTypeString",
   "alias": "Spc Imp1",
   "length": 105,
   "domain": null
  },
  {
   "name": "SpecialImp2Desc",
   "type": "esriFieldTypeString",
   "alias": "Spc Imp2",
   "length": 105,
   "domain": null
  },
  {
   "name": "SpecialImp3Desc",
   "type": "esriFieldTypeString",
   "alias": "Spc Imp3",
   "length": 105,
   "domain": null
  },
  {
   "name": "MHSlidingDesc",
   "type": "esriFieldTypeString",
   "alias": "MH Sliding",
   "length": 104,
   "domain": null
  },
  {
   "name": "MHFndLf",
   "type": "esriFieldTypeSmallInteger",
   "alias": "MH Fnd Lf",
   "domain": null
  },
  {
   "name": "MHFndTypeDesc",
   "type": "esriFieldTypeString",
   "alias": "MH Fnd Typ",
   "length": 104,
   "domain": null
  },
  {
   "name": "MHSkirtLf",
   "type": "esriFieldTypeSmallInteger",
   "alias": "MH Skirt Lf",
   "domain": null
  },
  {
   "name": "MHSkirtTypeDesc",
   "type": "esriFieldTypeString",
   "alias": "MH Skrt Typ",
   "length": 104,
   "domain": null
  }
 ],
 "indexes": [
  {
   "name": "R22_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "ix_Parcel",
   "fields": "Parcel",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 8,
   "name": "SBC_PUB.DBO.PAT_PropertyInfo_INTERNAL",
   "relatedTableId": 0,
   "role": "esriRelRoleDestination",
   "keyField": "Parcel",
   "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
 }
}