{ "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 6, "name": "TAXDBL.APPRAISAL_COMPARABLES", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "COMP_PARCEL", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "APPR_FILE_NBR", "type": "esriFieldTypeBigInteger", "alias": "APPR_FILE_NBR", "domain": null }, { "name": "COMP_ID", "type": "esriFieldTypeBigInteger", "alias": "COMP_ID", "domain": null }, { "name": "COMP_PARCEL", "type": "esriFieldTypeString", "alias": "COMP_PARCEL", "length": 9, "domain": null }, { "name": "COMP_PARCEL_RANK", "type": "esriFieldTypeSmallInteger", "alias": "COMP_PARCEL_RANK", "domain": null }, { "name": "COMP_ADDRESS", "type": "esriFieldTypeString", "alias": "COMP_ADDRESS", "length": 50, "domain": null }, { "name": "COMP_CITY", "type": "esriFieldTypeString", "alias": "COMP_CITY", "length": 50, "domain": null }, { "name": "COMP_PROXIMITY", "type": "esriFieldTypeString", "alias": "COMP_PROXIMITY", "length": 50, "domain": null }, { "name": "COMP_SALE_DT_ADJ", "type": "esriFieldTypeBigInteger", "alias": "COMP_SALE_DT_ADJ", "domain": null }, { "name": "COMP_CONCESS_ADJ", "type": "esriFieldTypeBigInteger", "alias": "COMP_CONCESS_ADJ", "domain": null }, { "name": "COMP_LOC", "type": "esriFieldTypeString", "alias": "COMP_LOC", "length": 50, "domain": null }, { "name": "COMP_LOC_ADJ", "type": "esriFieldTypeBigInteger", "alias": "COMP_LOC_ADJ", "domain": null }, { "name": "COMP_SITE_AREA", "type": "esriFieldTypeDouble", "alias": "COMP_SITE_AREA", "domain": null }, { "name": "COMP_SITE_AREA_UNIT", "type": "esriFieldTypeString", "alias": "COMP_SITE_AREA_UNIT", "length": 50, "domain": null }, { "name": "COMP_SITE_AREA_ADJ", "type": "esriFieldTypeBigInteger", "alias": "COMP_SITE_AREA_ADJ", "domain": null }, { "name": "COMP_VIEW", "type": "esriFieldTypeString", "alias": "COMP_VIEW", "length": 50, "domain": null }, { "name": "COMP_VIEW_ADJ", "type": "esriFieldTypeBigInteger", "alias": "COMP_VIEW_ADJ", "domain": null }, { "name": "COMP_STYLE", "type": "esriFieldTypeString", "alias": "COMP_STYLE", "length": 50, "domain": null }, { "name": "COMP_STYLE_ADJ", "type": "esriFieldTypeBigInteger", "alias": "COMP_STYLE_ADJ", "domain": null }, { "name": "COMP_CONST_QUAL", "type": "esriFieldTypeString", "alias": "COMP_CONST_QUAL", "length": 50, "domain": null }, { "name": "COMP_CONST_QUAL_ADJ", "type": "esriFieldTypeBigInteger", "alias": "COMP_CONST_QUAL_ADJ", "domain": null }, { "name": "COMP_CONST_TYPE", "type": "esriFieldTypeString", "alias": "COMP_CONST_TYPE", "length": 50, "domain": null }, { "name": "COMP_AGE", "type": "esriFieldTypeSmallInteger", "alias": "COMP_AGE", "domain": null }, { "name": "COMP_AGE_ADJ", "type": "esriFieldTypeBigInteger", "alias": "COMP_AGE_ADJ", "domain": null }, { "name": "COMP_COND", "type": "esriFieldTypeString", "alias": "COMP_COND", "length": 50, "domain": null }, { "name": "COMP_COND_ADJ", "type": "esriFieldTypeBigInteger", "alias": "COMP_COND_ADJ", "domain": null }, { "name": "COMP_RM_CNT", "type": "esriFieldTypeSmallInteger", "alias": "COMP_RM_CNT", "domain": null }, { "name": "COMP_RM_CNT_ADJ", "type": "esriFieldTypeBigInteger", "alias": "COMP_RM_CNT_ADJ", "domain": null }, { "name": "COMP_BDRM_CNT", "type": "esriFieldTypeSmallInteger", "alias": "COMP_BDRM_CNT", "domain": null }, { "name": "COMP_BDRM_ADJ", "type": "esriFieldTypeBigInteger", "alias": "COMP_BDRM_ADJ", "domain": null }, { "name": "COMP_BATH_CNT", "type": "esriFieldTypeSingle", "alias": "COMP_BATH_CNT", "domain": null }, { "name": "COMP_BATH_ADJ", "type": "esriFieldTypeBigInteger", "alias": "COMP_BATH_ADJ", "domain": null }, { "name": "COMP_GLA", "type": "esriFieldTypeInteger", "alias": "COMP_GLA", "domain": null }, { "name": "COMP_GLA_ADJ", "type": "esriFieldTypeBigInteger", "alias": "COMP_GLA_ADJ", "domain": null }, { "name": "COMP_BSMT_SF", "type": "esriFieldTypeInteger", "alias": "COMP_BSMT_SF", "domain": null }, { "name": "COMP_BSMT_SF_ADJ", "type": "esriFieldTypeBigInteger", "alias": "COMP_BSMT_SF_ADJ", "domain": null }, { "name": "COMP_BSMT_FIN", "type": "esriFieldTypeInteger", "alias": "COMP_BSMT_FIN", "domain": null }, { "name": "COMP_BSMT_FIN_ADJ", "type": "esriFieldTypeBigInteger", "alias": "COMP_BSMT_FIN_ADJ", "domain": null }, { "name": "COMP_BSMT_RM_CNT", "type": "esriFieldTypeSmallInteger", "alias": "COMP_BSMT_RM_CNT", "domain": null }, { "name": "COMP_BSMT_ADJ", "type": "esriFieldTypeBigInteger", "alias": "COMP_BSMT_ADJ", "domain": null }, { "name": "COMP_FUNC_UTIL", "type": "esriFieldTypeString", "alias": "COMP_FUNC_UTIL", "length": 50, "domain": null }, { "name": "COMP_FUNC_UTIL_ADJ", "type": "esriFieldTypeBigInteger", "alias": "COMP_FUNC_UTIL_ADJ", "domain": null }, { "name": "COMP_HVAC", "type": "esriFieldTypeString", "alias": "COMP_HVAC", "length": 50, "domain": null }, { "name": "COMP_HVAC_ADJ", "type": "esriFieldTypeBigInteger", "alias": "COMP_HVAC_ADJ", "domain": null }, { "name": "COMP_ENGY_EFF", "type": "esriFieldTypeString", "alias": "COMP_ENGY_EFF", "length": 50, "domain": null }, { "name": "COMP_ENGY_EFF_ADJ", "type": "esriFieldTypeBigInteger", "alias": "COMP_ENGY_EFF_ADJ", "domain": null }, { "name": "COMP_GARAGE", "type": "esriFieldTypeString", "alias": "COMP_GARAGE", "length": 50, "domain": null }, { "name": "COMP_GARAGE_ADJ", "type": "esriFieldTypeBigInteger", "alias": "COMP_GARAGE_ADJ", "domain": null }, { "name": "COMP_CARPORT", "type": "esriFieldTypeString", "alias": "COMP_CARPORT", "length": 50, "domain": null }, { "name": "COMP_CAR_ADJ", "type": "esriFieldTypeBigInteger", "alias": "COMP_CAR_ADJ", "domain": null }, { "name": "COMP_PCH_PAT_DECK", "type": "esriFieldTypeString", "alias": "COMP_PCH_PAT_DECK", "length": 50, "domain": null }, { "name": "COMP_PCH_PAT_DECK_ADJ", "type": "esriFieldTypeBigInteger", "alias": "COMP_PCH_PAT_DECK_ADJ", "domain": null }, { "name": "COMP_RV_PARK", "type": "esriFieldTypeString", "alias": "COMP_RV_PARK", "length": 50, "domain": null }, { "name": "COMP_RV_PARK_ADJ", "type": "esriFieldTypeBigInteger", "alias": "COMP_RV_PARK_ADJ", "domain": null }, { "name": "COMP_NET_ADJ", "type": "esriFieldTypeBigInteger", "alias": "COMP_NET_ADJ", "domain": null }, { "name": "COMP_SALES_PRICE_ADJ", "type": "esriFieldTypeBigInteger", "alias": "COMP_SALES_PRICE_ADJ", "domain": null }, { "name": "COMP_ZIP", "type": "esriFieldTypeString", "alias": "COMP_ZIP", "length": 9, "domain": null }, { "name": "COMP_POOL", "type": "esriFieldTypeString", "alias": "COMP_POOL", "length": 20, "domain": null }, { "name": "COMP_FIREPLACE", "type": "esriFieldTypeSmallInteger", "alias": "COMP_FIREPLACE", "domain": null }, { "name": "COMP_EXTERIOR", "type": "esriFieldTypeString", "alias": "COMP_EXTERIOR", "length": 50, "domain": null }, { "name": "COMP_RMS_BELOW_GRADE", "type": "esriFieldTypeString", "alias": "COMP_RMS_BELOW_GRADE", "length": 20, "domain": null }, { "name": "COMP_YRBLT", "type": "esriFieldTypeSmallInteger", "alias": "COMP_YRBLT", "domain": null }, { "name": "COMP_OTHER_1_DESC", "type": "esriFieldTypeString", "alias": "COMP_OTHER_1_DESC", "length": 20, "domain": null }, { "name": "COMP_OTHER_2_DESC", "type": "esriFieldTypeString", "alias": "COMP_OTHER_2_DESC", "length": 20, "domain": null }, { "name": "COMP_OTHER_3_DESC", "type": "esriFieldTypeString", "alias": "COMP_OTHER_3_DESC", "length": 20, "domain": null }, { "name": "COMP_OTHER_1_ADJ", "type": "esriFieldTypeBigInteger", "alias": "COMP_OTHER_1_ADJ", "domain": null }, { "name": "COMP_OTHER_2_ADJ", "type": "esriFieldTypeBigInteger", "alias": "COMP_OTHER_2_ADJ", "domain": null }, { "name": "COMP_OTHER_3_ADJ", "type": "esriFieldTypeBigInteger", "alias": "COMP_OTHER_3_ADJ", "domain": null }, { "name": "COMP_POOL_ADJ", "type": "esriFieldTypeBigInteger", "alias": "COMP_POOL_ADJ", "domain": null }, { "name": "COMP_FP_ADJ", "type": "esriFieldTypeBigInteger", "alias": "COMP_FP_ADJ", "domain": null }, { "name": "COMP_PROPTYPE", "type": "esriFieldTypeString", "alias": "COMP_PROPTYPE", "length": 50, "domain": null }, { "name": "COMP_ADTL_PARCELS", "type": "esriFieldTypeString", "alias": "COMP_ADTL_PARCELS", "length": 1, "domain": null }, { "name": "COMP_NBR_UNIT", "type": "esriFieldTypeSmallInteger", "alias": "COMP_NBR_UNIT", "domain": null }, { "name": "WC_PARCEL", "type": "esriFieldTypeString", "alias": "WC_PARCEL", "length": 1, "domain": null }, { "name": "COMP_FULL_BTH", "type": "esriFieldTypeSmallInteger", "alias": "COMP_FULL_BTH", "domain": null }, { "name": "COMP_F_BTH_ADJ", "type": "esriFieldTypeBigInteger", "alias": "COMP_F_BTH_ADJ", "domain": null }, { "name": "COMP_HALF_BTH", "type": "esriFieldTypeSmallInteger", "alias": "COMP_HALF_BTH", "domain": null }, { "name": "COMP_H_BTH_ADJ", "type": "esriFieldTypeBigInteger", "alias": "COMP_H_BTH_ADJ", "domain": null }, { "name": "COMP_3QTR_BTH", "type": "esriFieldTypeSmallInteger", "alias": "COMP_3QTR_BTH", "domain": null }, { "name": "COMP_3Q_BTH_ADJ", "type": "esriFieldTypeBigInteger", "alias": "COMP_3Q_BTH_ADJ", "domain": null }, { "name": "COMP_TAX_YEAR", "type": "esriFieldTypeSmallInteger", "alias": "COMP_TAX_YEAR", "domain": null }, { "name": "COMP_COMMENT", "type": "esriFieldTypeString", "alias": "COMP_COMMENT", "length": 2000, "domain": null }, { "name": "COMP_TRANS_HISTORY", "type": "esriFieldTypeString", "alias": "COMP_TRANS_HISTORY", "length": 2000, "domain": null }, { "name": "PSF_GLA_UNADJ", "type": "esriFieldTypeSingle", "alias": "PSF_GLA_UNADJ", "domain": null }, { "name": "PSF_TFA_UNADJ", "type": "esriFieldTypeSingle", "alias": "PSF_TFA_UNADJ", "domain": null }, { "name": "PSF_TOT_UNADJ", "type": "esriFieldTypeSingle", "alias": "PSF_TOT_UNADJ", "domain": null }, { "name": "PSF_GLA_ADJ", "type": "esriFieldTypeSingle", "alias": "PSF_GLA_ADJ", "domain": null }, { "name": "PSF_TFA_ADJ", "type": "esriFieldTypeSingle", "alias": "PSF_TFA_ADJ", "domain": null }, { "name": "PSF_TOT_ADJ", "type": "esriFieldTypeSingle", "alias": "PSF_TOT_ADJ", "domain": null }, { "name": "GROSS_ADJ_PCT", "type": "esriFieldTypeSingle", "alias": "GROSS_ADJ_PCT", "domain": null }, { "name": "COMP_WEIGHT", "type": "esriFieldTypeSingle", "alias": "COMP_WEIGHT", "domain": null }, { "name": "COMP_BLTASCODE", "type": "esriFieldTypeBigInteger", "alias": "COMP_BLTASCODE", "domain": null }, { "name": "COMP_FULL_3Q_BTH", "type": "esriFieldTypeSmallInteger", "alias": "COMP_FULL_3Q_BTH", "domain": null }, { "name": "COMP_FULL_3Q_BTH_ADJ", "type": "esriFieldTypeBigInteger", "alias": "COMP_FULL_3Q_BTH_ADJ", "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Map,Query,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 }, "serviceItemId": "ebeacfed4fea4e5cb6c88bf1b457dc11" }