Name: Residential

Display Field: PID

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 98265d27dcfb45bd815bfbee3731bed8

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• PID ( type: esriFieldTypeString, alias: PID, length: 20 )
• Assessment_Year ( type: esriFieldTypeSmallInteger, alias: Assessment_Year )
• Version ( type: esriFieldTypeSmallInteger, alias: Version )
• Partial_Const ( type: esriFieldTypeSmallInteger, alias: Partial_Const )
• Model ( type: esriFieldTypeString, alias: Model, length: 20 )
• Adj_Property ( type: esriFieldTypeString, alias: Adj_Property, length: 20 )
• Res_View ( type: esriFieldTypeString, alias: Res_View, length: 20 )
• Arch_Appeal ( type: esriFieldTypeString, alias: Arch_Appeal, length: 20 )
• Quality_Class ( type: esriFieldTypeString, alias: Quality_Class, length: 3 )
• Shape ( type: esriFieldTypeString, alias: Shape, length: 20 )
• Style ( type: esriFieldTypeString, alias: Style, length: 30 )
• Dwelling_Type ( type: esriFieldTypeString, alias: Dwelling_Type, length: 30 )
• Dormer_Length ( type: esriFieldTypeSmallInteger, alias: Dormer_Length )
• Dormer_Quality ( type: esriFieldTypeString, alias: Dormer_Quality, length: 30 )
• Construction ( type: esriFieldTypeString, alias: Construction, length: 30 )
• Ext_Main_Wall ( type: esriFieldTypeString, alias: Ext_Main_Wall, length: 30 )
• Ext_Trim_Wall ( type: esriFieldTypeString, alias: Ext_Trim_Wall, length: 30 )
• Roof_Type ( type: esriFieldTypeString, alias: Roof_Type, length: 30 )
• Roof_Cover ( type: esriFieldTypeString, alias: Roof_Cover, length: 30 )
• Window_Type1 ( type: esriFieldTypeString, alias: Window_Type1, length: 30 )
• Window_Type2 ( type: esriFieldTypeString, alias: Window_Type2, length: 30 )
• Patio_Door_Amt ( type: esriFieldTypeSmallInteger, alias: Patio_Door_Amt )
• Walkout_Type ( type: esriFieldTypeString, alias: Walkout_Type, length: 30 )
• Walkout_Quality ( type: esriFieldTypeString, alias: Walkout_Quality, length: 20 )
• Air_Cond ( type: esriFieldTypeString, alias: Air_Cond, length: 30 )
• Deck_Area ( type: esriFieldTypeSmallInteger, alias: Deck_Area )
• Deck_Quality ( type: esriFieldTypeString, alias: Deck_Quality, length: 20 )
• Deck_Area2 ( type: esriFieldTypeSmallInteger, alias: Deck_Area2 )
• Deck_Quality2 ( type: esriFieldTypeString, alias: Deck_Quality2, length: 20 )
• Patio_Area ( type: esriFieldTypeSmallInteger, alias: Patio_Area )
• Patio_Quality ( type: esriFieldTypeString, alias: Patio_Quality, length: 20 )
• Patio_Area2 ( type: esriFieldTypeSmallInteger, alias: Patio_Area2 )
• Patio_Quality2 ( type: esriFieldTypeString, alias: Patio_Quality2, length: 20 )
• Porch_G_Area ( type: esriFieldTypeSmallInteger, alias: Porch_G_Area )
• Porch_G_Quality ( type: esriFieldTypeString, alias: Porch_G_Quality, length: 20 )
• Porch_S_Area ( type: esriFieldTypeSmallInteger, alias: Porch_S_Area )
• Porch_S_Quality ( type: esriFieldTypeString, alias: Porch_S_Quality, length: 20 )
• Porch_O_Area ( type: esriFieldTypeSmallInteger, alias: Porch_O_Area )
• Porch_O_Quality ( type: esriFieldTypeString, alias: Porch_O_Quality, length: 20 )
• Gar1_Area ( type: esriFieldTypeSmallInteger, alias: Gar1_Area )
• Gar1_Ext_Walls ( type: esriFieldTypeString, alias: Gar1_Ext_Walls, length: 30 )
• Gar1_Nbr_Cars ( type: esriFieldTypeSmallInteger, alias: Gar1_Nbr_Cars )
• Gar1_Condition ( type: esriFieldTypeString, alias: Gar1_Condition, length: 20 )
• Gar1_Placement ( type: esriFieldTypeString, alias: Gar1_Placement, length: 30 )
• Gar2_Area ( type: esriFieldTypeSmallInteger, alias: Gar2_Area )
• Gar2_Ext_Walls ( type: esriFieldTypeString, alias: Gar2_Ext_Walls, length: 30 )
• Gar2_Nbr_Cars ( type: esriFieldTypeSmallInteger, alias: Gar2_Nbr_Cars )
• Gar2_Condition ( type: esriFieldTypeString, alias: Gar2_Condition, length: 20 )
• Gar2_Placement ( type: esriFieldTypeString, alias: Gar2_Placement, length: 30 )
• Pool_Area ( type: esriFieldTypeSmallInteger, alias: Pool_Area )
• Pool_Quality ( type: esriFieldTypeString, alias: Pool_Quality, length: 20 )
• Pool_Area2 ( type: esriFieldTypeSmallInteger, alias: Pool_Area2 )
• Pool_Quality2 ( type: esriFieldTypeString, alias: Pool_Quality2, length: 20 )
• Bsmt_Pct_Avail ( type: esriFieldTypeSmallInteger, alias: Bsmt_Pct_Avail )
• Bsmt_Area ( type: esriFieldTypeSmallInteger, alias: Bsmt_Area )
• Bsmt_Type ( type: esriFieldTypeString, alias: Bsmt_Type, length: 30 )
• Bsmt_Pct_Finish ( type: esriFieldTypeSmallInteger, alias: Bsmt_Pct_Finish )
• Bsmt_Quality ( type: esriFieldTypeString, alias: Bsmt_Quality, length: 20 )
• Bsmt_Avg_Clear_Ht ( type: esriFieldTypeSingle, alias: Bsmt_Avg_Clear_Ht )
• Bsmt_Bath_Spa ( type: esriFieldTypeSmallInteger, alias: Bsmt_Bath_Spa )
• Bsmt_Bath_Spa_Qual ( type: esriFieldTypeString, alias: Bsmt_Bath_Spa_Qual, length: 20 )
• Bsmt_Bath_Dlx ( type: esriFieldTypeSmallInteger, alias: Bsmt_Bath_Dlx )
• Bsmt_Bath_Dlx_Qual ( type: esriFieldTypeString, alias: Bsmt_Bath_Dlx_Qual, length: 20 )
• Bsmt_Bath_Full ( type: esriFieldTypeSmallInteger, alias: Bsmt_Bath_Full )
• Bsmt_Bath_Full_Qual ( type: esriFieldTypeString, alias: Bsmt_Bath_Full_Qual, length: 20 )
• Bsmt_Bath_3_4 ( type: esriFieldTypeSmallInteger, alias: Bsmt_Bath_3_4 )
• Bsmt_Bath_3_4_Qual ( type: esriFieldTypeString, alias: Bsmt_Bath_3_4_Qual, length: 20 )
• Bsmt_Bath_1_2 ( type: esriFieldTypeSmallInteger, alias: Bsmt_Bath_1_2 )
• Bsmt_Bath_1_2_Qual ( type: esriFieldTypeString, alias: Bsmt_Bath_1_2_Qual, length: 20 )
• Bsmt_Fplc_Nbr ( type: esriFieldTypeSmallInteger, alias: Bsmt_Fplc_Nbr )
• Bsmt_Fplc_Qual ( type: esriFieldTypeString, alias: Bsmt_Fplc_Qual, length: 20 )
• Electric_Service ( type: esriFieldTypeString, alias: Electric_Service, length: 30 )
• Heating_Type ( type: esriFieldTypeString, alias: Heating_Type, length: 30 )
• Bsmt_Room_Tot ( type: esriFieldTypeSmallInteger, alias: Bsmt_Room_Tot )
• Bsmt_Bedrm_Tot ( type: esriFieldTypeSmallInteger, alias: Bsmt_Bedrm_Tot )
• Bsmt_Familyrm_Tot ( type: esriFieldTypeSmallInteger, alias: Bsmt_Familyrm_Tot )
• Bsmt_Kitrm_Tot ( type: esriFieldTypeSmallInteger, alias: Bsmt_Kitrm_Tot )
• Bsmt_Bath_Tot ( type: esriFieldTypeSmallInteger, alias: Bsmt_Bath_Tot )
• Bsmt_Othrm_Tot ( type: esriFieldTypeSmallInteger, alias: Bsmt_Othrm_Tot )
• Bsmt_Walkout_Type ( type: esriFieldTypeString, alias: Bsmt_Walkout_Type, length: 30 )
• Bsmt_Walkout_Qual ( type: esriFieldTypeString, alias: Bsmt_Walkout_Qual, length: 20 )
• Bsmt_Comments ( type: esriFieldTypeString, alias: Bsmt_Comments, length: 1000 )
• FF_Kit_Qual ( type: esriFieldTypeString, alias: FF_Kit_Qual, length: 20 )
• FF_Interior ( type: esriFieldTypeString, alias: FF_Interior, length: 20 )
• FF_Trim ( type: esriFieldTypeString, alias: FF_Trim, length: 20 )
• FF_GBA ( type: esriFieldTypeSmallInteger, alias: FF_GBA )
• FF_Unfin_GBA ( type: esriFieldTypeSmallInteger, alias: FF_Unfin_GBA )
• FF_Floor ( type: esriFieldTypeString, alias: FF_Floor, length: 20 )
• FF_Avg_Clear_Ht ( type: esriFieldTypeSingle, alias: FF_Avg_Clear_Ht )
• FF_Bath_Spa ( type: esriFieldTypeSmallInteger, alias: FF_Bath_Spa )
• FF_Bath_Spa_Qual ( type: esriFieldTypeString, alias: FF_Bath_Spa_Qual, length: 20 )
• FF_Bath_Dlx ( type: esriFieldTypeSmallInteger, alias: FF_Bath_Dlx )
• FF_Bath_Dlx_Qual ( type: esriFieldTypeString, alias: FF_Bath_Dlx_Qual, length: 20 )
• FF_Bath_Full ( type: esriFieldTypeSmallInteger, alias: FF_Bath_Full )
• FF_Bath_Full_Qual ( type: esriFieldTypeString, alias: FF_Bath_Full_Qual, length: 20 )
• FF_Bath_3_4 ( type: esriFieldTypeSmallInteger, alias: FF_Bath_3_4 )
• FF_Bath_3_4_Qual ( type: esriFieldTypeString, alias: FF_Bath_3_4_Qual, length: 20 )
• FF_Bath_1_2 ( type: esriFieldTypeSmallInteger, alias: FF_Bath_1_2 )
• FF_Bath_1_2_Qual ( type: esriFieldTypeString, alias: FF_Bath_1_2_Qual, length: 20 )
• FF_Fplc_Nbr ( type: esriFieldTypeSmallInteger, alias: FF_Fplc_Nbr )
• FF_Fplc_Qual ( type: esriFieldTypeString, alias: FF_Fplc_Qual, length: 20 )
• FF_Room_Tot ( type: esriFieldTypeSmallInteger, alias: FF_Room_Tot )
• FF_Bedrm_Tot ( type: esriFieldTypeSmallInteger, alias: FF_Bedrm_Tot )
• FF_Familyrm_Tot ( type: esriFieldTypeSmallInteger, alias: FF_Familyrm_Tot )
• FF_Livrm_Tot ( type: esriFieldTypeSmallInteger, alias: FF_Livrm_Tot )
• FF_Dinrm_Tot ( type: esriFieldTypeSmallInteger, alias: FF_Dinrm_Tot )
• FF_Kitrm_Tot ( type: esriFieldTypeSmallInteger, alias: FF_Kitrm_Tot )
• FF_Bath_Tot ( type: esriFieldTypeSmallInteger, alias: FF_Bath_Tot )
• FF_Othrm_Tot ( type: esriFieldTypeSmallInteger, alias: FF_Othrm_Tot )
• SF_Interior ( type: esriFieldTypeString, alias: SF_Interior, length: 20 )
• SF_Trim ( type: esriFieldTypeString, alias: SF_Trim, length: 20 )
• SF_GBA ( type: esriFieldTypeSmallInteger, alias: SF_GBA )
• SF_Unfin_GBA ( type: esriFieldTypeSmallInteger, alias: SF_Unfin_GBA )
• SF_Floor ( type: esriFieldTypeString, alias: SF_Floor, length: 20 )
• SF_Avg_Clear_Ht ( type: esriFieldTypeSingle, alias: SF_Avg_Clear_Ht )
• SF_Bath_Spa ( type: esriFieldTypeSmallInteger, alias: SF_Bath_Spa )
• SF_Bath_Spa_Qual ( type: esriFieldTypeString, alias: SF_Bath_Spa_Qual, length: 20 )
• SF_Bath_Dlx ( type: esriFieldTypeSmallInteger, alias: SF_Bath_Dlx )
• SF_Bath_Dlx_Qual ( type: esriFieldTypeString, alias: SF_Bath_Dlx_Qual, length: 20 )
• SF_Bath_Full ( type: esriFieldTypeSmallInteger, alias: SF_Bath_Full )
• SF_Bath_Full_Qual ( type: esriFieldTypeString, alias: SF_Bath_Full_Qual, length: 20 )
• SF_Bath_3_4 ( type: esriFieldTypeSmallInteger, alias: SF_Bath_3_4 )
• SF_Bath_3_4_Qual ( type: esriFieldTypeString, alias: SF_Bath_3_4_Qual, length: 20 )
• SF_Bath_1_2 ( type: esriFieldTypeSmallInteger, alias: SF_Bath_1_2 )
• SF_Bath_1_2_Qual ( type: esriFieldTypeString, alias: SF_Bath_1_2_Qual, length: 20 )
• SF_Fplc_Nbr ( type: esriFieldTypeSmallInteger, alias: SF_Fplc_Nbr )
• SF_Fplc_Qual ( type: esriFieldTypeString, alias: SF_Fplc_Qual, length: 20 )
• SF_Room_Tot ( type: esriFieldTypeSmallInteger, alias: SF_Room_Tot )
• SF_Bedrm_Tot ( type: esriFieldTypeSmallInteger, alias: SF_Bedrm_Tot )
• SF_Bath_Tot ( type: esriFieldTypeSmallInteger, alias: SF_Bath_Tot )
• SF_Othrm_Tot ( type: esriFieldTypeSmallInteger, alias: SF_Othrm_Tot )
• TF_Interior ( type: esriFieldTypeString, alias: TF_Interior, length: 20 )
• TF_Trim ( type: esriFieldTypeString, alias: TF_Trim, length: 20 )
• TF_GBA ( type: esriFieldTypeSmallInteger, alias: TF_GBA )
• TF_Unfin_GBA ( type: esriFieldTypeSmallInteger, alias: TF_Unfin_GBA )
• TF_Floor ( type: esriFieldTypeString, alias: TF_Floor, length: 20 )
• TF_Avg_Clear_Ht ( type: esriFieldTypeSingle, alias: TF_Avg_Clear_Ht )
• TF_Bath_Spa ( type: esriFieldTypeSmallInteger, alias: TF_Bath_Spa )
• TF_Bath_Spa_Qual ( type: esriFieldTypeString, alias: TF_Bath_Spa_Qual, length: 20 )
• TF_Bath_Dlx ( type: esriFieldTypeSmallInteger, alias: TF_Bath_Dlx )
• TF_Bath_Dlx_Qual ( type: esriFieldTypeString, alias: TF_Bath_Dlx_Qual, length: 20 )
• TF_Bath_Full ( type: esriFieldTypeSmallInteger, alias: TF_Bath_Full )
• TF_Bath_Full_Qual ( type: esriFieldTypeString, alias: TF_Bath_Full_Qual, length: 20 )
• TF_Bath_3_4 ( type: esriFieldTypeSmallInteger, alias: TF_Bath_3_4 )
• TF_Bath_3_4_Qual ( type: esriFieldTypeString, alias: TF_Bath_3_4_Qual, length: 20 )
• TF_Bath_1_2 ( type: esriFieldTypeSmallInteger, alias: TF_Bath_1_2 )
• TF_Bath_1_2_Qual ( type: esriFieldTypeString, alias: TF_Bath_1_2_Qual, length: 20 )
• TF_Fplc_Nbr ( type: esriFieldTypeSmallInteger, alias: TF_Fplc_Nbr )
• TF_Fplc_Qual ( type: esriFieldTypeString, alias: TF_Fplc_Qual, length: 20 )
• TF_Room_Tot ( type: esriFieldTypeSmallInteger, alias: TF_Room_Tot )
• TF_Bedrm_Tot ( type: esriFieldTypeSmallInteger, alias: TF_Bedrm_Tot )
• TF_Bath_Tot ( type: esriFieldTypeSmallInteger, alias: TF_Bath_Tot )
• TF_Othrm_Tot ( type: esriFieldTypeSmallInteger, alias: TF_Othrm_Tot )
• Int_Layout_Qual ( type: esriFieldTypeString, alias: Int_Layout_Qual, length: 30 )
• Actual_Age ( type: esriFieldTypeSmallInteger, alias: Actual_Age )
• Effective_Age ( type: esriFieldTypeSmallInteger, alias: Effective_Age )
• Renovated_Age ( type: esriFieldTypeSmallInteger, alias: Renovated_Age )
• Functional_Pct ( type: esriFieldTypeSmallInteger, alias: Functional_Pct )
• Economic_Pct ( type: esriFieldTypeSmallInteger, alias: Economic_Pct )
• Manual_Assess ( type: esriFieldTypeString, alias: Manual_Assess, length: 1 )
• Condition ( type: esriFieldTypeString, alias: Condition, length: 20 )
• Total_Rooms ( type: esriFieldTypeSmallInteger, alias: Total_Rooms )
• Total_Bedrm ( type: esriFieldTypeSmallInteger, alias: Total_Bedrm )
• Total_Familyrm ( type: esriFieldTypeSmallInteger, alias: Total_Familyrm )
• Total_Livrm ( type: esriFieldTypeSmallInteger, alias: Total_Livrm )
• Total_Dinrm ( type: esriFieldTypeSmallInteger, alias: Total_Dinrm )
• Total_Kitrm ( type: esriFieldTypeSmallInteger, alias: Total_Kitrm )
• Total_Othrm ( type: esriFieldTypeSmallInteger, alias: Total_Othrm )
• Total_Baths ( type: esriFieldTypeSmallInteger, alias: Total_Baths )
• Dim1_Length ( type: esriFieldTypeSingle, alias: Dim1_Length )
• Dim1_Width ( type: esriFieldTypeSingle, alias: Dim1_Width )
• Dim2_Length ( type: esriFieldTypeSingle, alias: Dim2_Length )
• Dim2_Width ( type: esriFieldTypeSingle, alias: Dim2_Width )
• Dim3_Length ( type: esriFieldTypeSingle, alias: Dim3_Length )
• Dim3_Width ( type: esriFieldTypeSingle, alias: Dim3_Width )
• Dim4_Length ( type: esriFieldTypeSingle, alias: Dim4_Length )
• Dim4_Width ( type: esriFieldTypeSingle, alias: Dim4_Width )
• Dim5_Length ( type: esriFieldTypeSingle, alias: Dim5_Length )
• Dim5_Width ( type: esriFieldTypeSingle, alias: Dim5_Width )
• Dim6_Length ( type: esriFieldTypeSingle, alias: Dim6_Length )
• Dim6_Width ( type: esriFieldTypeSingle, alias: Dim6_Width )
• Dim7_Length ( type: esriFieldTypeSingle, alias: Dim7_Length )
• Dim7_Width ( type: esriFieldTypeSingle, alias: Dim7_Width )
• Yard_Amentity1 ( type: esriFieldTypeString, alias: Yard_Amentity1, length: 30 )
• Yard_Amentity2 ( type: esriFieldTypeString, alias: Yard_Amentity2, length: 30 )
• Yard_Amentity3 ( type: esriFieldTypeString, alias: Yard_Amentity3, length: 30 )
• Yard_Amentity4 ( type: esriFieldTypeString, alias: Yard_Amentity4, length: 30 )
• Yard_Amentity5 ( type: esriFieldTypeString, alias: Yard_Amentity5, length: 30 )
• GB_Area ( type: esriFieldTypeInteger, alias: GB_Area )
• Unfin_GB_Area ( type: esriFieldTypeInteger, alias: Unfin_GB_Area )
• Flat_Value ( type: esriFieldTypeInteger, alias: Flat_Value )
• Flat_Value_Desc ( type: esriFieldTypeString, alias: Flat_Value_Desc, length: 30 )
• ESRI_OID ( type: esriFieldTypeOID, alias: ESRI_OID )

Relationships:

• epgdb.GIS.Parcels (1) -- Related To: Parcels (1)

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

  Iteminfo   Thumbnail   Metadata