Name: TAXDBL.APPRAISAL_COMPARABLES

Display Field: COMP_PARCEL

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: ebeacfed4fea4e5cb6c88bf1b457dc11

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• APPR_FILE_NBR ( type: esriFieldTypeBigInteger, alias: APPR_FILE_NBR )
• COMP_ID ( type: esriFieldTypeBigInteger, alias: COMP_ID )
• COMP_PARCEL ( type: esriFieldTypeString, alias: COMP_PARCEL, length: 9 )
• COMP_PARCEL_RANK ( type: esriFieldTypeSmallInteger, alias: COMP_PARCEL_RANK )
• COMP_ADDRESS ( type: esriFieldTypeString, alias: COMP_ADDRESS, length: 50 )
• COMP_CITY ( type: esriFieldTypeString, alias: COMP_CITY, length: 50 )
• COMP_PROXIMITY ( type: esriFieldTypeString, alias: COMP_PROXIMITY, length: 50 )
• COMP_SALE_DT_ADJ ( type: esriFieldTypeBigInteger, alias: COMP_SALE_DT_ADJ )
• COMP_CONCESS_ADJ ( type: esriFieldTypeBigInteger, alias: COMP_CONCESS_ADJ )
• COMP_LOC ( type: esriFieldTypeString, alias: COMP_LOC, length: 50 )
• COMP_LOC_ADJ ( type: esriFieldTypeBigInteger, alias: COMP_LOC_ADJ )
• COMP_SITE_AREA ( type: esriFieldTypeDouble, alias: COMP_SITE_AREA )
• COMP_SITE_AREA_UNIT ( type: esriFieldTypeString, alias: COMP_SITE_AREA_UNIT, length: 50 )
• COMP_SITE_AREA_ADJ ( type: esriFieldTypeBigInteger, alias: COMP_SITE_AREA_ADJ )
• COMP_VIEW ( type: esriFieldTypeString, alias: COMP_VIEW, length: 50 )
• COMP_VIEW_ADJ ( type: esriFieldTypeBigInteger, alias: COMP_VIEW_ADJ )
• COMP_STYLE ( type: esriFieldTypeString, alias: COMP_STYLE, length: 50 )
• COMP_STYLE_ADJ ( type: esriFieldTypeBigInteger, alias: COMP_STYLE_ADJ )
• COMP_CONST_QUAL ( type: esriFieldTypeString, alias: COMP_CONST_QUAL, length: 50 )
• COMP_CONST_QUAL_ADJ ( type: esriFieldTypeBigInteger, alias: COMP_CONST_QUAL_ADJ )
• COMP_CONST_TYPE ( type: esriFieldTypeString, alias: COMP_CONST_TYPE, length: 50 )
• COMP_AGE ( type: esriFieldTypeSmallInteger, alias: COMP_AGE )
• COMP_AGE_ADJ ( type: esriFieldTypeBigInteger, alias: COMP_AGE_ADJ )
• COMP_COND ( type: esriFieldTypeString, alias: COMP_COND, length: 50 )
• COMP_COND_ADJ ( type: esriFieldTypeBigInteger, alias: COMP_COND_ADJ )
• COMP_RM_CNT ( type: esriFieldTypeSmallInteger, alias: COMP_RM_CNT )
• COMP_RM_CNT_ADJ ( type: esriFieldTypeBigInteger, alias: COMP_RM_CNT_ADJ )
• COMP_BDRM_CNT ( type: esriFieldTypeSmallInteger, alias: COMP_BDRM_CNT )
• COMP_BDRM_ADJ ( type: esriFieldTypeBigInteger, alias: COMP_BDRM_ADJ )
• COMP_BATH_CNT ( type: esriFieldTypeSingle, alias: COMP_BATH_CNT )
• COMP_BATH_ADJ ( type: esriFieldTypeBigInteger, alias: COMP_BATH_ADJ )
• COMP_GLA ( type: esriFieldTypeInteger, alias: COMP_GLA )
• COMP_GLA_ADJ ( type: esriFieldTypeBigInteger, alias: COMP_GLA_ADJ )
• COMP_BSMT_SF ( type: esriFieldTypeInteger, alias: COMP_BSMT_SF )
• COMP_BSMT_SF_ADJ ( type: esriFieldTypeBigInteger, alias: COMP_BSMT_SF_ADJ )
• COMP_BSMT_FIN ( type: esriFieldTypeInteger, alias: COMP_BSMT_FIN )
• COMP_BSMT_FIN_ADJ ( type: esriFieldTypeBigInteger, alias: COMP_BSMT_FIN_ADJ )
• COMP_BSMT_RM_CNT ( type: esriFieldTypeSmallInteger, alias: COMP_BSMT_RM_CNT )
• COMP_BSMT_ADJ ( type: esriFieldTypeBigInteger, alias: COMP_BSMT_ADJ )
• COMP_FUNC_UTIL ( type: esriFieldTypeString, alias: COMP_FUNC_UTIL, length: 50 )
• COMP_FUNC_UTIL_ADJ ( type: esriFieldTypeBigInteger, alias: COMP_FUNC_UTIL_ADJ )
• COMP_HVAC ( type: esriFieldTypeString, alias: COMP_HVAC, length: 50 )
• COMP_HVAC_ADJ ( type: esriFieldTypeBigInteger, alias: COMP_HVAC_ADJ )
• COMP_ENGY_EFF ( type: esriFieldTypeString, alias: COMP_ENGY_EFF, length: 50 )
• COMP_ENGY_EFF_ADJ ( type: esriFieldTypeBigInteger, alias: COMP_ENGY_EFF_ADJ )
• COMP_GARAGE ( type: esriFieldTypeString, alias: COMP_GARAGE, length: 50 )
• COMP_GARAGE_ADJ ( type: esriFieldTypeBigInteger, alias: COMP_GARAGE_ADJ )
• COMP_CARPORT ( type: esriFieldTypeString, alias: COMP_CARPORT, length: 50 )
• COMP_CAR_ADJ ( type: esriFieldTypeBigInteger, alias: COMP_CAR_ADJ )
• COMP_PCH_PAT_DECK ( type: esriFieldTypeString, alias: COMP_PCH_PAT_DECK, length: 50 )
• COMP_PCH_PAT_DECK_ADJ ( type: esriFieldTypeBigInteger, alias: COMP_PCH_PAT_DECK_ADJ )
• COMP_RV_PARK ( type: esriFieldTypeString, alias: COMP_RV_PARK, length: 50 )
• COMP_RV_PARK_ADJ ( type: esriFieldTypeBigInteger, alias: COMP_RV_PARK_ADJ )
• COMP_NET_ADJ ( type: esriFieldTypeBigInteger, alias: COMP_NET_ADJ )
• COMP_SALES_PRICE_ADJ ( type: esriFieldTypeBigInteger, alias: COMP_SALES_PRICE_ADJ )
• COMP_ZIP ( type: esriFieldTypeString, alias: COMP_ZIP, length: 9 )
• COMP_POOL ( type: esriFieldTypeString, alias: COMP_POOL, length: 20 )
• COMP_FIREPLACE ( type: esriFieldTypeSmallInteger, alias: COMP_FIREPLACE )
• COMP_EXTERIOR ( type: esriFieldTypeString, alias: COMP_EXTERIOR, length: 50 )
• COMP_RMS_BELOW_GRADE ( type: esriFieldTypeString, alias: COMP_RMS_BELOW_GRADE, length: 20 )
• COMP_YRBLT ( type: esriFieldTypeSmallInteger, alias: COMP_YRBLT )
• COMP_OTHER_1_DESC ( type: esriFieldTypeString, alias: COMP_OTHER_1_DESC, length: 20 )
• COMP_OTHER_2_DESC ( type: esriFieldTypeString, alias: COMP_OTHER_2_DESC, length: 20 )
• COMP_OTHER_3_DESC ( type: esriFieldTypeString, alias: COMP_OTHER_3_DESC, length: 20 )
• COMP_OTHER_1_ADJ ( type: esriFieldTypeBigInteger, alias: COMP_OTHER_1_ADJ )
• COMP_OTHER_2_ADJ ( type: esriFieldTypeBigInteger, alias: COMP_OTHER_2_ADJ )
• COMP_OTHER_3_ADJ ( type: esriFieldTypeBigInteger, alias: COMP_OTHER_3_ADJ )
• COMP_POOL_ADJ ( type: esriFieldTypeBigInteger, alias: COMP_POOL_ADJ )
• COMP_FP_ADJ ( type: esriFieldTypeBigInteger, alias: COMP_FP_ADJ )
• COMP_PROPTYPE ( type: esriFieldTypeString, alias: COMP_PROPTYPE, length: 50 )
• COMP_ADTL_PARCELS ( type: esriFieldTypeString, alias: COMP_ADTL_PARCELS, length: 1 )
• COMP_NBR_UNIT ( type: esriFieldTypeSmallInteger, alias: COMP_NBR_UNIT )
• WC_PARCEL ( type: esriFieldTypeString, alias: WC_PARCEL, length: 1 )
• COMP_FULL_BTH ( type: esriFieldTypeSmallInteger, alias: COMP_FULL_BTH )
• COMP_F_BTH_ADJ ( type: esriFieldTypeBigInteger, alias: COMP_F_BTH_ADJ )
• COMP_HALF_BTH ( type: esriFieldTypeSmallInteger, alias: COMP_HALF_BTH )
• COMP_H_BTH_ADJ ( type: esriFieldTypeBigInteger, alias: COMP_H_BTH_ADJ )
• COMP_3QTR_BTH ( type: esriFieldTypeSmallInteger, alias: COMP_3QTR_BTH )
• COMP_3Q_BTH_ADJ ( type: esriFieldTypeBigInteger, alias: COMP_3Q_BTH_ADJ )
• COMP_TAX_YEAR ( type: esriFieldTypeSmallInteger, alias: COMP_TAX_YEAR )
• COMP_COMMENT ( type: esriFieldTypeString, alias: COMP_COMMENT, length: 2000 )
• COMP_TRANS_HISTORY ( type: esriFieldTypeString, alias: COMP_TRANS_HISTORY, length: 2000 )
• PSF_GLA_UNADJ ( type: esriFieldTypeSingle, alias: PSF_GLA_UNADJ )
• PSF_TFA_UNADJ ( type: esriFieldTypeSingle, alias: PSF_TFA_UNADJ )
• PSF_TOT_UNADJ ( type: esriFieldTypeSingle, alias: PSF_TOT_UNADJ )
• PSF_GLA_ADJ ( type: esriFieldTypeSingle, alias: PSF_GLA_ADJ )
• PSF_TFA_ADJ ( type: esriFieldTypeSingle, alias: PSF_TFA_ADJ )
• PSF_TOT_ADJ ( type: esriFieldTypeSingle, alias: PSF_TOT_ADJ )
• GROSS_ADJ_PCT ( type: esriFieldTypeSingle, alias: GROSS_ADJ_PCT )
• COMP_WEIGHT ( type: esriFieldTypeSingle, alias: COMP_WEIGHT )
• COMP_BLTASCODE ( type: esriFieldTypeBigInteger, alias: COMP_BLTASCODE )
• COMP_FULL_3Q_BTH ( type: esriFieldTypeSmallInteger, alias: COMP_FULL_3Q_BTH )
• COMP_FULL_3Q_BTH_ADJ ( type: esriFieldTypeBigInteger, alias: COMP_FULL_3Q_BTH_ADJ )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata