{ "currentVersion": 10.81, "id": 4, "name": "AssesorRoll_Update_Enriched", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "SITUS_STREET_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "APN", "type": "esriFieldTypeString", "alias": "APN", "length": 10, "domain": null }, { "name": "TAX_RATE_AREA", "type": "esriFieldTypeString", "alias": "TAX_RATE_AREA", "length": 5, "domain": null }, { "name": "AGENCY_CLASS_NO", "type": "esriFieldTypeString", "alias": "AGENCY_CLASS_NO", "length": 6, "domain": null }, { "name": "LAND_CURR_ROLL_YR", "type": "esriFieldTypeInteger", "alias": "LAND_CURR_ROLL_YR", "domain": null }, { "name": "LAND_CURR_VAL", "type": "esriFieldTypeDouble", "alias": "LAND_CURR_VAL", "domain": null }, { "name": "IMP_CURR_ROLL_YR", "type": "esriFieldTypeInteger", "alias": "IMP_CURR_ROLL_YR", "domain": null }, { "name": "IMP_CURR_VAL", "type": "esriFieldTypeDouble", "alias": "IMP_CURR_VAL", "domain": null }, { "name": "SITUS_HOUSE_NO", "type": "esriFieldTypeInteger", "alias": "SITUS_HOUSE_NO", "domain": null }, { "name": "SITUS_FRACTION", "type": "esriFieldTypeString", "alias": "SITUS_FRACTION", "length": 3, "domain": null }, { "name": "SITUS_DIRECTION", "type": "esriFieldTypeString", "alias": "SITUS_DIRECTION", "length": 1, "domain": null }, { "name": "SITUS_STREET_NAME", "type": "esriFieldTypeString", "alias": "SITUS_STREET_NAME", "length": 32, "domain": null }, { "name": "SITUS_UNIT", "type": "esriFieldTypeString", "alias": "SITUS_UNIT", "length": 8, "domain": null }, { "name": "SITUS_CITY_STATE", "type": "esriFieldTypeString", "alias": "SITUS_CITY_STATE", "length": 24, "domain": null }, { "name": "SITUS_ZIP", "type": "esriFieldTypeString", "alias": "SITUS_ZIP", "length": 9, "domain": null }, { "name": "MAIL_ADDR_HOUSE_NO", "type": "esriFieldTypeInteger", "alias": "MAIL_ADDR_HOUSE_NO", "domain": null }, { "name": "MAIL_ADDR_FRACTION", "type": "esriFieldTypeString", "alias": "MAIL_ADDR_FRACTION", "length": 3, "domain": null }, { "name": "MAIL_ADDR_DIR", "type": "esriFieldTypeString", "alias": "MAIL_ADDR_DIR", "length": 1, "domain": null }, { "name": "MAIL_ADDR_ST_NAME", "type": "esriFieldTypeString", "alias": "MAIL_ADDR_ST_NAME", "length": 32, "domain": null }, { "name": "MAIL_ADDR_UNIT", "type": "esriFieldTypeString", "alias": "MAIL_ADDR_UNIT", "length": 8, "domain": null }, { "name": "MAIL_ADDR_CTY_STA", "type": "esriFieldTypeString", "alias": "MAIL_ADDR_CTY_STA", "length": 24, "domain": null }, { "name": "MAIL_ADDR_ZIP", "type": "esriFieldTypeString", "alias": "MAIL_ADDR_ZIP", "length": 9, "domain": null }, { "name": "FRST_OWNR_NAME", "type": "esriFieldTypeString", "alias": "FRST_OWNR_NAME", "length": 32, "domain": null }, { "name": "FRST_OWNR_NAME_OVR", "type": "esriFieldTypeString", "alias": "FRST_OWNR_NAME_OVR", "length": 32, "domain": null }, { "name": "SPEC_NAME_LEGEND", "type": "esriFieldTypeString", "alias": "SPEC_NAME_LEGEND", "length": 5, "domain": null }, { "name": "SPEC_NAME_ASSESSEE", "type": "esriFieldTypeString", "alias": "SPEC_NAME_ASSESSEE", "length": 32, "domain": null }, { "name": "SECND_OWNR_NAME", "type": "esriFieldTypeString", "alias": "SECND_OWNR_NAME", "length": 32, "domain": null }, { "name": "RECORDING_DATE", "type": "esriFieldTypeString", "alias": "RECORDING_DATE", "length": 8, "domain": null }, { "name": "TAX_STATUS_KEY", "type": "esriFieldTypeString", "alias": "TAX_STATUS_KEY", "length": 1, "domain": null }, { "name": "TAX_STAT_YR_SOLD", "type": "esriFieldTypeInteger", "alias": "TAX_STAT_YR_SOLD", "domain": null }, { "name": "HAZ_ABATE_CTY_KEY", "type": "esriFieldTypeString", "alias": "HAZ_ABATE_CTY_KEY", "length": 1, "domain": null }, { "name": "HAZ_ABATE_INFO", "type": "esriFieldTypeString", "alias": "HAZ_ABATE_INFO", "length": 10, "domain": null }, { "name": "ZONING_CODE", "type": "esriFieldTypeString", "alias": "ZONING_CODE", "length": 15, "domain": null }, { "name": "USE_CODE", "type": "esriFieldTypeString", "alias": "USE_CODE", "length": 4, "domain": null }, { "name": "PARTIAL_INTEREST", "type": "esriFieldTypeString", "alias": "PARTIAL_INTEREST", "length": 3, "domain": null }, { "name": "DOC_REASON_CODE", "type": "esriFieldTypeString", "alias": "DOC_REASON_CODE", "length": 1, "domain": null }, { "name": "OWNERSHIP_CODE", "type": "esriFieldTypeString", "alias": "OWNERSHIP_CODE", "length": 1, "domain": null }, { "name": "EXEM_CLAIM_TYPE", "type": "esriFieldTypeString", "alias": "EXEM_CLAIM_TYPE", "length": 1, "domain": null }, { "name": "PER_PROP_KEY", "type": "esriFieldTypeString", "alias": "PER_PROP_KEY", "length": 1, "domain": null }, { "name": "PER_PROP_VAL", "type": "esriFieldTypeString", "alias": "PER_PROP_VAL", "length": 9, "domain": null }, { "name": "PERL_PROP_EXEM_VAL", "type": "esriFieldTypeString", "alias": "PERL_PROP_EXEM_VAL", "length": 9, "domain": null }, { "name": "FIXTURE_VALUE", "type": "esriFieldTypeDouble", "alias": "FIXTURE_VALUE", "domain": null }, { "name": "FIXTURE_EXEM_VAL", "type": "esriFieldTypeDouble", "alias": "FIXTURE_EXEM_VAL", "domain": null }, { "name": "HOMEOWNER_NO_EXEM", "type": "esriFieldTypeString", "alias": "HOMEOWNER_NO_EXEM", "length": 3, "domain": null }, { "name": "HOMEOWNER_EXEM_VAL", "type": "esriFieldTypeDouble", "alias": "HOMEOWNER_EXEM_VAL", "domain": null }, { "name": "REAL_ESTATE_EXEMPT", "type": "esriFieldTypeString", "alias": "REAL_ESTATE_EXEMPT", "length": 9, "domain": null }, { "name": "LAST_SL1_VER_KEY", "type": "esriFieldTypeString", "alias": "LAST_SL1_VER_KEY", "length": 1, "domain": null }, { "name": "LAST_SL1_SL_AMNT", "type": "esriFieldTypeString", "alias": "LAST_SL1_SL_AMNT", "length": 9, "domain": null }, { "name": "LAST_SL1_SL_DT", "type": "esriFieldTypeString", "alias": "LAST_SL1_SL_DT", "length": 8, "domain": null }, { "name": "LAST_SL2_VER_KEY", "type": "esriFieldTypeString", "alias": "LAST_SL2_VER_KEY", "length": 1, "domain": null }, { "name": "LAST_SL2_SL_AMNT", "type": "esriFieldTypeString", "alias": "LAST_SL2_SL_AMNT", "length": 9, "domain": null }, { "name": "LAST_SL2_SL_DT", "type": "esriFieldTypeString", "alias": "LAST_SL2_SL_DT", "length": 8, "domain": null }, { "name": "LAST_SL3_VER_KEY", "type": "esriFieldTypeString", "alias": "LAST_SL3_VER_KEY", "length": 1, "domain": null }, { "name": "LAST_SL3_SL_AMNT", "type": "esriFieldTypeString", "alias": "LAST_SL3_SL_AMNT", "length": 9, "domain": null }, { "name": "LAST_SL3_SL_DT", "type": "esriFieldTypeString", "alias": "LAST_SL3_SL_DT", "length": 8, "domain": null }, { "name": "DATA1_SUBPART", "type": "esriFieldTypeString", "alias": "DATA1_SUBPART", "length": 4, "domain": null }, { "name": "DATA1_DESIGN_TYPE", "type": "esriFieldTypeString", "alias": "DATA1_DESIGN_TYPE", "length": 4, "domain": null }, { "name": "DATA1_QUALITY", "type": "esriFieldTypeString", "alias": "DATA1_QUALITY", "length": 5, "domain": null }, { "name": "DATA1_YR_BUILT", "type": "esriFieldTypeInteger", "alias": "DATA1_YR_BUILT", "domain": null }, { "name": "DATA1_NO_UNITS", "type": "esriFieldTypeInteger", "alias": "DATA1_NO_UNITS", "domain": null }, { "name": "DATA1_NO_BDRMS", "type": "esriFieldTypeInteger", "alias": "DATA1_NO_BDRMS", "domain": null }, { "name": "DATA1_NO_BATHS", "type": "esriFieldTypeInteger", "alias": "DATA1_NO_BATHS", "domain": null }, { "name": "DATA1_SQ_FT", "type": "esriFieldTypeDouble", "alias": "DATA1_SQ_FT", "domain": null }, { "name": "DATA2_SUBPART", "type": "esriFieldTypeString", "alias": "DATA2_SUBPART", "length": 4, "domain": null }, { "name": "DATA2_DESIGN_TYPE", "type": "esriFieldTypeString", "alias": "DATA2_DESIGN_TYPE", "length": 4, "domain": null }, { "name": "DATA2_QUALITY", "type": "esriFieldTypeString", "alias": "DATA2_QUALITY", "length": 5, "domain": null }, { "name": "DATA2_YR_BUILT", "type": "esriFieldTypeInteger", "alias": "DATA2_YR_BUILT", "domain": null }, { "name": "DATA2_NO_UNITS", "type": "esriFieldTypeInteger", "alias": "DATA2_NO_UNITS", "domain": null }, { "name": "DATA2_NO_BDRMS", "type": "esriFieldTypeInteger", "alias": "DATA2_NO_BDRMS", "domain": null }, { "name": "DATA2_NO_BATHS", "type": "esriFieldTypeInteger", "alias": "DATA2_NO_BATHS", "domain": null }, { "name": "DATA2_SQ_FT", "type": "esriFieldTypeDouble", "alias": "DATA2_SQ_FT", "domain": null }, { "name": "DATA3_SUBPART", "type": "esriFieldTypeString", "alias": "DATA3_SUBPART", "length": 4, "domain": null }, { "name": "DATA3_DESIGN_TYPE", "type": "esriFieldTypeString", "alias": "DATA3_DESIGN_TYPE", "length": 4, "domain": null }, { "name": "DATA3_QUALITY", "type": "esriFieldTypeString", "alias": "DATA3_QUALITY", "length": 5, "domain": null }, { "name": "DATA3_YR_BUILT", "type": "esriFieldTypeInteger", "alias": "DATA3_YR_BUILT", "domain": null }, { "name": "DATA3_NO_UNITS", "type": "esriFieldTypeInteger", "alias": "DATA3_NO_UNITS", "domain": null }, { "name": "DATA3_NO_BDRMS", "type": "esriFieldTypeInteger", "alias": "DATA3_NO_BDRMS", "domain": null }, { "name": "DATA3_NO_BATHS", "type": "esriFieldTypeInteger", "alias": "DATA3_NO_BATHS", "domain": null }, { "name": "DATA3_SQ_FT", "type": "esriFieldTypeDouble", "alias": "DATA3_SQ_FT", "domain": null }, { "name": "DATA4_SUBPART", "type": "esriFieldTypeString", "alias": "DATA4_SUBPART", "length": 4, "domain": null }, { "name": "DATA4_DESIGN_TYPE", "type": "esriFieldTypeString", "alias": "DATA4_DESIGN_TYPE", "length": 4, "domain": null }, { "name": "DATA4_QUALITY", "type": "esriFieldTypeString", "alias": "DATA4_QUALITY", "length": 5, "domain": null }, { "name": "DATA4_YR_BUILT", "type": "esriFieldTypeInteger", "alias": "DATA4_YR_BUILT", "domain": null }, { "name": "DATA4_NO_UNITS", "type": "esriFieldTypeInteger", "alias": "DATA4_NO_UNITS", "domain": null }, { "name": "DATA4_NO_BDRMS", "type": "esriFieldTypeInteger", "alias": "DATA4_NO_BDRMS", "domain": null }, { "name": "DATA4_NO_BATHS", "type": "esriFieldTypeInteger", "alias": "DATA4_NO_BATHS", "domain": null }, { "name": "DATA4_SQ_FT", "type": "esriFieldTypeDouble", "alias": "DATA4_SQ_FT", "domain": null }, { "name": "DATA5_SUBPART", "type": "esriFieldTypeString", "alias": "DATA5_SUBPART", "length": 4, "domain": null }, { "name": "DATA5_DESIGN_TYPE", "type": "esriFieldTypeString", "alias": "DATA5_DESIGN_TYPE", "length": 4, "domain": null }, { "name": "DATA5_QUALITY", "type": "esriFieldTypeString", "alias": "DATA5_QUALITY", "length": 5, "domain": null }, { "name": "DATA5_YR_BUILT", "type": "esriFieldTypeInteger", "alias": "DATA5_YR_BUILT", "domain": null }, { "name": "DATA5_NO_UNITS", "type": "esriFieldTypeInteger", "alias": "DATA5_NO_UNITS", "domain": null }, { "name": "DATA5_NO_BDRMS", "type": "esriFieldTypeInteger", "alias": "DATA5_NO_BDRMS", "domain": null }, { "name": "DATA5_NO_BATHS", "type": "esriFieldTypeInteger", "alias": "DATA5_NO_BATHS", "domain": null }, { "name": "DATA5_SQ_FT", "type": "esriFieldTypeDouble", "alias": "DATA5_SQ_FT", "domain": null }, { "name": "LEGAL_DESC1", "type": "esriFieldTypeString", "alias": "LEGAL_DESC1", "length": 40, "domain": null }, { "name": "LEGAL_DESC2", "type": "esriFieldTypeString", "alias": "LEGAL_DESC2", "length": 40, "domain": null }, { "name": "LEGAL_DESC3", "type": "esriFieldTypeString", "alias": "LEGAL_DESC3", "length": 40, "domain": null }, { "name": "LEGAL_DESC4", "type": "esriFieldTypeString", "alias": "LEGAL_DESC4", "length": 40, "domain": null }, { "name": "LEGAL_DESC5", "type": "esriFieldTypeString", "alias": "LEGAL_DESC5", "length": 40, "domain": null }, { "name": "LEGAL_DESC6", "type": "esriFieldTypeString", "alias": "LEGAL_DESC6", "length": 40, "domain": null }, { "name": "Current_Land_Base_Year", "type": "esriFieldTypeString", "alias": "Current_Land_Base_Year", "length": 4, "domain": null }, { "name": "Current_Improvement_Base_Year", "type": "esriFieldTypeString", "alias": "Current_Improvement_Base_Year", "length": 4, "domain": null }, { "name": "Current_Land_Base_Value", "type": "esriFieldTypeString", "alias": "Current_Land_Base_Value", "length": 9, "domain": null }, { "name": "Current_Improvement_Base_Value", "type": "esriFieldTypeString", "alias": "Current_Improvement_Base_Value", "length": 9, "domain": null }, { "name": "Cluster_Location_Cluster_Code", "type": "esriFieldTypeString", "alias": "Cluster_Location_Cluster_Code", "length": 2, "domain": null }, { "name": "Cluster_Type_Cluster_Code", "type": "esriFieldTypeString", "alias": "Cluster_Type_Cluster_Code", "length": 1, "domain": null }, { "name": "Cluster_Appraisal_Unit_Cluster_", "type": "esriFieldTypeString", "alias": "Cluster_Appraisal_Unit_Cluster_Code", "length": 2, "domain": null }, { "name": "Land_Reason_Key", "type": "esriFieldTypeString", "alias": "Land_Reason_Key", "length": 1, "domain": null }, { "name": "Impairment_Key", "type": "esriFieldTypeString", "alias": "Impairment_Key", "length": 5, "domain": null }, { "name": "Document_Transfer_Tax_Sales_Amo", "type": "esriFieldTypeString", "alias": "Document_Transfer_Tax_Sales_Amount", "length": 9, "domain": null }, { "name": "Year_Changed_Building_Data_Line", "type": "esriFieldTypeString", "alias": "Year_Changed_Building_Data_Line_1", "length": 4, "domain": null }, { "name": "Unit_Cost_Main_Building_Data_Li", "type": "esriFieldTypeString", "alias": "Unit_Cost_Main_Building_Data_Line_1", "length": 5, "domain": null }, { "name": "RCN_Main_Building_Data_Line_1", "type": "esriFieldTypeString", "alias": "RCN_Main_Building_Data_Line_1", "length": 9, "domain": null }, { "name": "Year_Changed_Building_Data_Li_1", "type": "esriFieldTypeString", "alias": "Year_Changed_Building_Data_Line_2", "length": 4, "domain": null }, { "name": "Unit_Cost_Main_Building_Data__1", "type": "esriFieldTypeString", "alias": "Unit_Cost_Main_Building_Data_Line_2", "length": 5, "domain": null }, { "name": "RCN_Main_Building_Data_Line_2", "type": "esriFieldTypeString", "alias": "RCN_Main_Building_Data_Line_2", "length": 9, "domain": null }, { "name": "Year_Changed_Building_Data_Li_2", "type": "esriFieldTypeString", "alias": "Year_Changed_Building_Data_Line_3", "length": 4, "domain": null }, { "name": "Unit_Cost_Main_Building_Data__2", "type": "esriFieldTypeString", "alias": "Unit_Cost_Main_Building_Data_Line_3", "length": 5, "domain": null }, { "name": "RCN_Main_Building_Data_Line_3", "type": "esriFieldTypeString", "alias": "RCN_Main_Building_Data_Line_3", "length": 9, "domain": null }, { "name": "Year_Changed_Building_Data_Li_3", "type": "esriFieldTypeString", "alias": "Year_Changed_Building_Data_Line_4", "length": 4, "domain": null }, { "name": "Unit_Cost_Main_Building_Data__3", "type": "esriFieldTypeString", "alias": "Unit_Cost_Main_Building_Data_Line_4", "length": 5, "domain": null }, { "name": "RCN_Main_Building_Data_Line_4", "type": "esriFieldTypeString", "alias": "RCN_Main_Building_Data_Line_4", "length": 9, "domain": null }, { "name": "Year_Changed_Building_Data_Li_4", "type": "esriFieldTypeString", "alias": "Year_Changed_Building_Data_Line_5", "length": 4, "domain": null }, { "name": "Unit_Cost_Main_Building_Data__4", "type": "esriFieldTypeString", "alias": "Unit_Cost_Main_Building_Data_Line_5", "length": 5, "domain": null }, { "name": "RCN_Main_Building_Data_Line_5", "type": "esriFieldTypeString", "alias": "RCN_Main_Building_Data_Line_5", "length": 9, "domain": null }, { "name": "Reappraisal_Year_Landlord_Infor", "type": "esriFieldTypeString", "alias": "Reappraisal_Year_Landlord_Information", "length": 4, "domain": null }, { "name": "Number_Of_Units_Landlord_Inform", "type": "esriFieldTypeString", "alias": "Number_Of_Units_Landlord_Information", "length": 3, "domain": null }, { "name": "First_Transferee_Name", "type": "esriFieldTypeString", "alias": "First_Transferee_Name", "length": 32, "domain": null }, { "name": "First_Transferee_Name_Overflow", "type": "esriFieldTypeString", "alias": "First_Transferee_Name_Overflow", "length": 32, "domain": null }, { "name": "Second_Transferee_Name", "type": "esriFieldTypeString", "alias": "Second_Transferee_Name", "length": 32, "domain": null }, { "name": "Document_Key_Last_Document_Reco", "type": "esriFieldTypeString", "alias": "Document_Key_Last_Document_Recorders_Document_Info", "length": 1, "domain": null }, { "name": "Document_Number_Last_Document_R", "type": "esriFieldTypeString", "alias": "Document_Number_Last_Document_Recorders_Document_Info", "length": 7, "domain": null }, { "name": "SITUS_FULL_ADDR", "type": "esriFieldTypeString", "alias": "SITUS_FULL_ADDR", "length": 255, "domain": null }, { "name": "OWNER_FULL_ADDR", "type": "esriFieldTypeString", "alias": "OWNER_FULL_ADDR", "length": 255, "domain": null }, { "name": "SA_FULLADDR", "type": "esriFieldTypeString", "alias": "SA_FULLADDR", "length": 255, "domain": null }, { "name": "SA_CITY", "type": "esriFieldTypeString", "alias": "SA_CITY", "length": 50, "domain": null }, { "name": "SA_ZIP", "type": "esriFieldTypeString", "alias": "SA_ZIP", "length": 5, "domain": null } ], "indexes": [ { "name": "R707_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "APMonAssrEn", "fields": "APN", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 30000, "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 } }