{ "currentVersion": 10.51, "id": 2, "name": "Improvements", "type": "Table", "description": "This table contains improvements data used for appraisal of Deschutes County, Oregon properties. Created from the Deschutes County Assessor's Office data which resides in the ORCATs system. Can be related to the taxlots GIS data table. This table has a one to one relationship with taxlots.", "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Taxlot", "typeIdField": null, "subtypeFieldName": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Taxlot", "type": "esriFieldTypeString", "alias": "Taxlot", "length": 20, "domain": null }, { "name": "Land_Size_Acres", "type": "esriFieldTypeDouble", "alias": "Land_Size_Acres", "domain": null }, { "name": "Year_Appr", "type": "esriFieldTypeString", "alias": "Year_Appr", "length": 4, "domain": null }, { "name": "Property_Class", "type": "esriFieldTypeString", "alias": "Property_Class", "length": 6, "domain": null }, { "name": "impr_ID_1", "type": "esriFieldTypeInteger", "alias": "impr_ID_1", "domain": null }, { "name": "Stat_Class_1", "type": "esriFieldTypeString", "alias": "Stat_Class_1", "length": 3, "domain": null }, { "name": "Stat_Class_Desc_1", "type": "esriFieldTypeString", "alias": "Stat_Class_Desc_1", "length": 250, "domain": null }, { "name": "Total_Sqft_1", "type": "esriFieldTypeInteger", "alias": "Total_Sqft_1", "domain": null }, { "name": "Year_Built_1", "type": "esriFieldTypeString", "alias": "Year_Built_1", "length": 4, "domain": null }, { "name": "Garage_Sqft_1", "type": "esriFieldTypeInteger", "alias": "Garage_Sqft_1", "domain": null }, { "name": "impr_ID_2", "type": "esriFieldTypeInteger", "alias": "impr_ID_2", "domain": null }, { "name": "Stat_Class_2", "type": "esriFieldTypeString", "alias": "Stat_Class_2", "length": 3, "domain": null }, { "name": "Stat_Class_Desc_2", "type": "esriFieldTypeString", "alias": "Stat_Class_Desc_2", "length": 250, "domain": null }, { "name": "Total_Sqft_2", "type": "esriFieldTypeInteger", "alias": "Total_Sqft_2", "domain": null }, { "name": "Year_Built_2", "type": "esriFieldTypeString", "alias": "Year_Built_2", "length": 4, "domain": null }, { "name": "Garage_Sqft_2", "type": "esriFieldTypeInteger", "alias": "Garage_Sqft_2", "domain": null }, { "name": "Outcode_1_1", "type": "esriFieldTypeString", "alias": "Outcode_1_1", "length": 4, "domain": null }, { "name": "Outcode_1_1_Description", "type": "esriFieldTypeString", "alias": "Outcode_1_1_Description", "length": 30, "domain": null }, { "name": "Outcode_1_2", "type": "esriFieldTypeString", "alias": "Outcode_1_2", "length": 4, "domain": null }, { "name": "Outcode_1_2_Description", "type": "esriFieldTypeString", "alias": "Outcode_1_2_Description", "length": 30, "domain": null }, { "name": "Outcode_1_3", "type": "esriFieldTypeString", "alias": "Outcode_1_3", "length": 4, "domain": null }, { "name": "Outcode_1_3_Description", "type": "esriFieldTypeString", "alias": "Outcode_1_3_Description", "length": 30, "domain": null }, { "name": "Outcode_2_1", "type": "esriFieldTypeString", "alias": "Outcode_2_1", "length": 4, "domain": null }, { "name": "Outcode_2_1_Description", "type": "esriFieldTypeString", "alias": "Outcode_2_1_Description", "length": 30, "domain": null }, { "name": "Outcode_2_2", "type": "esriFieldTypeString", "alias": "Outcode_2_2", "length": 4, "domain": null }, { "name": "Outcode_2_2_Description", "type": "esriFieldTypeString", "alias": "Outcode_2_2_Description", "length": 30, "domain": null }, { "name": "Outcode_2_3", "type": "esriFieldTypeString", "alias": "Outcode_2_3", "length": 4, "domain": null }, { "name": "Outcode_2_3_Description", "type": "esriFieldTypeString", "alias": "Outcode_2_3_Description", "length": 30, "domain": null }, { "name": "Bedrooms", "type": "esriFieldTypeDouble", "alias": "Bedrooms", "domain": null }, { "name": "Bathrooms", "type": "esriFieldTypeDouble", "alias": "Bathrooms", "domain": null } ], "indexes": [ { "name": "GDB_188_Taxlot", "fields": "Taxlot", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "Improvement", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "Taxlot", "cardinality": "esriRelCardinalityOneToOne", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, AMF", "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": false } }