{ "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 22, "name": "Multi-Family", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Building_Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "PID", "type": "esriFieldTypeString", "alias": "PID", "length": 20, "domain": null }, { "name": "Assessment_Year", "type": "esriFieldTypeSmallInteger", "alias": "Assessment_Year", "domain": null }, { "name": "Version", "type": "esriFieldTypeSmallInteger", "alias": "Version", "domain": null }, { "name": "Bldg", "type": "esriFieldTypeSmallInteger", "alias": "Bldg", "domain": null }, { "name": "Building_Name", "type": "esriFieldTypeString", "alias": "Building_Name", "length": 50, "domain": null }, { "name": "Partial_Const", "type": "esriFieldTypeSmallInteger", "alias": "Partial_Const", "domain": null }, { "name": "Overall_Quality", "type": "esriFieldTypeString", "alias": "Overall_Quality", "length": 3, "domain": null }, { "name": "Arch_Appeal", "type": "esriFieldTypeString", "alias": "Arch_Appeal", "length": 20, "domain": null }, { "name": "Construction_Quality", "type": "esriFieldTypeString", "alias": "Construction_Quality", "length": 30, "domain": null }, { "name": "Construction_Type", "type": "esriFieldTypeString", "alias": "Construction_Type", "length": 30, "domain": null }, { "name": "Condition", "type": "esriFieldTypeString", "alias": "Condition", "length": 30, "domain": null }, { "name": "Prim_Ext_Walls", "type": "esriFieldTypeString", "alias": "Prim_Ext_Walls", "length": 30, "domain": null }, { "name": "Sec_Ext_Walls", "type": "esriFieldTypeString", "alias": "Sec_Ext_Walls", "length": 30, "domain": null }, { "name": "Roof_Type", "type": "esriFieldTypeString", "alias": "Roof_Type", "length": 30, "domain": null }, { "name": "Roof_Cover", "type": "esriFieldTypeString", "alias": "Roof_Cover", "length": 30, "domain": null }, { "name": "Functional_Depr", "type": "esriFieldTypeSmallInteger", "alias": "Functional_Depr", "domain": null }, { "name": "Economic_Depr", "type": "esriFieldTypeSmallInteger", "alias": "Economic_Depr", "domain": null }, { "name": "Physical_Depr", "type": "esriFieldTypeSmallInteger", "alias": "Physical_Depr", "domain": null }, { "name": "Actual_Age", "type": "esriFieldTypeSmallInteger", "alias": "Actual_Age", "domain": null }, { "name": "Effective_Age", "type": "esriFieldTypeSmallInteger", "alias": "Effective_Age", "domain": null }, { "name": "Renovated_Age", "type": "esriFieldTypeSmallInteger", "alias": "Renovated_Age", "domain": null }, { "name": "Parking_Type1", "type": "esriFieldTypeString", "alias": "Parking_Type1", "length": 30, "domain": null }, { "name": "Parking_Type2", "type": "esriFieldTypeString", "alias": "Parking_Type2", "length": 30, "domain": null }, { "name": "Parking_Type3", "type": "esriFieldTypeString", "alias": "Parking_Type3", "length": 30, "domain": null }, { "name": "Parking_Type4", "type": "esriFieldTypeString", "alias": "Parking_Type4", "length": 30, "domain": null }, { "name": "Parking_Type5", "type": "esriFieldTypeString", "alias": "Parking_Type5", "length": 30, "domain": null }, { "name": "Parking_Type1_Nbr_Cars", "type": "esriFieldTypeSmallInteger", "alias": "Parking_Type1_Nbr_Cars", "domain": null }, { "name": "Parking_Type2_Nbr_Cars", "type": "esriFieldTypeSmallInteger", "alias": "Parking_Type2_Nbr_Cars", "domain": null }, { "name": "Parking_Type3_Nbr_Cars", "type": "esriFieldTypeSmallInteger", "alias": "Parking_Type3_Nbr_Cars", "domain": null }, { "name": "Parking_Type4_Nbr_Cars", "type": "esriFieldTypeSmallInteger", "alias": "Parking_Type4_Nbr_Cars", "domain": null }, { "name": "Parking_Type5_Nbr_Cars", "type": "esriFieldTypeSmallInteger", "alias": "Parking_Type5_Nbr_Cars", "domain": null }, { "name": "Parking_Type1_Area", "type": "esriFieldTypeInteger", "alias": "Parking_Type1_Area", "domain": null }, { "name": "Parking_Type2_Area", "type": "esriFieldTypeInteger", "alias": "Parking_Type2_Area", "domain": null }, { "name": "Parking_Type3_Area", "type": "esriFieldTypeInteger", "alias": "Parking_Type3_Area", "domain": null }, { "name": "Parking_Type4_Area", "type": "esriFieldTypeInteger", "alias": "Parking_Type4_Area", "domain": null }, { "name": "Parking_Type5_Area", "type": "esriFieldTypeInteger", "alias": "Parking_Type5_Area", "domain": null }, { "name": "Parking_Type1_Rent", "type": "esriFieldTypeSmallInteger", "alias": "Parking_Type1_Rent", "domain": null }, { "name": "Parking_Type2_Rent", "type": "esriFieldTypeSmallInteger", "alias": "Parking_Type2_Rent", "domain": null }, { "name": "Parking_Type3_Rent", "type": "esriFieldTypeSmallInteger", "alias": "Parking_Type3_Rent", "domain": null }, { "name": "Parking_Type4_Rent", "type": "esriFieldTypeSmallInteger", "alias": "Parking_Type4_Rent", "domain": null }, { "name": "Parking_Type5_Rent", "type": "esriFieldTypeSmallInteger", "alias": "Parking_Type5_Rent", "domain": null }, { "name": "Avg_Story", "type": "esriFieldTypeSingle", "alias": "Avg_Story", "domain": null }, { "name": "Nbr_Story", "type": "esriFieldTypeSingle", "alias": "Nbr_Story", "domain": null }, { "name": "Bldg_Avg_Clear_Height", "type": "esriFieldTypeSingle", "alias": "Bldg_Avg_Clear_Height", "domain": null }, { "name": "Finished_Ceiling_Height", "type": "esriFieldTypeSingle", "alias": "Finished_Ceiling_Height", "domain": null }, { "name": "Pool1_Nbr", "type": "esriFieldTypeSmallInteger", "alias": "Pool1_Nbr", "domain": null }, { "name": "Pool2_Nbr", "type": "esriFieldTypeSmallInteger", "alias": "Pool2_Nbr", "domain": null }, { "name": "Pool1_Type", "type": "esriFieldTypeString", "alias": "Pool1_Type", "length": 30, "domain": null }, { "name": "Pool2_Type", "type": "esriFieldTypeString", "alias": "Pool2_Type", "length": 30, "domain": null }, { "name": "Income_Lease", "type": "esriFieldTypeString", "alias": "Income_Lease", "length": 30, "domain": null }, { "name": "Tenant", "type": "esriFieldTypeString", "alias": "Tenant", "length": 30, "domain": null }, { "name": "Security_System", "type": "esriFieldTypeString", "alias": "Security_System", "length": 1, "domain": null }, { "name": "Bsmt_Area", "type": "esriFieldTypeInteger", "alias": "Bsmt_Area", "domain": null }, { "name": "Bsmt_Area_Pct", "type": "esriFieldTypeSingle", "alias": "Bsmt_Area_Pct", "domain": null }, { "name": "Nbr_Elevators", "type": "esriFieldTypeSmallInteger", "alias": "Nbr_Elevators", "domain": null }, { "name": "Air_Cond1", "type": "esriFieldTypeString", "alias": "Air_Cond1", "length": 30, "domain": null }, { "name": "Air_Cond2", "type": "esriFieldTypeString", "alias": "Air_Cond2", "length": 30, "domain": null }, { "name": "Air_Cond3", "type": "esriFieldTypeString", "alias": "Air_Cond3", "length": 30, "domain": null }, { "name": "Air_Cond1_Pct", "type": "esriFieldTypeSmallInteger", "alias": "Air_Cond1_Pct", "domain": null }, { "name": "Air_Cond2_Pct", "type": "esriFieldTypeSmallInteger", "alias": "Air_Cond2_Pct", "domain": null }, { "name": "Air_Cond3_Pct", "type": "esriFieldTypeSmallInteger", "alias": "Air_Cond3_Pct", "domain": null }, { "name": "Electrical_Qual", "type": "esriFieldTypeString", "alias": "Electrical_Qual", "length": 30, "domain": null }, { "name": "Plumbing_Qual", "type": "esriFieldTypeString", "alias": "Plumbing_Qual", "length": 30, "domain": null }, { "name": "Sprinkler_Type", "type": "esriFieldTypeString", "alias": "Sprinkler_Type", "length": 30, "domain": null }, { "name": "Sprinkler_Pct", "type": "esriFieldTypeSmallInteger", "alias": "Sprinkler_Pct", "domain": null }, { "name": "Heat_Type1", "type": "esriFieldTypeString", "alias": "Heat_Type1", "length": 30, "domain": null }, { "name": "Heat_Type2", "type": "esriFieldTypeString", "alias": "Heat_Type2", "length": 30, "domain": null }, { "name": "Heat_Type3", "type": "esriFieldTypeString", "alias": "Heat_Type3", "length": 30, "domain": null }, { "name": "Heat_Pct1", "type": "esriFieldTypeSmallInteger", "alias": "Heat_Pct1", "domain": null }, { "name": "Heat_Pct2", "type": "esriFieldTypeSmallInteger", "alias": "Heat_Pct2", "domain": null }, { "name": "Heat_Pct3", "type": "esriFieldTypeSmallInteger", "alias": "Heat_Pct3", "domain": null }, { "name": "FF_Area", "type": "esriFieldTypeInteger", "alias": "FF_Area", "domain": null }, { "name": "GB_Area", "type": "esriFieldTypeInteger", "alias": "GB_Area", "domain": null }, { "name": "NetRentable_Area", "type": "esriFieldTypeInteger", "alias": "NetRentable_Area", "domain": null }, { "name": "Mezzanine_Area", "type": "esriFieldTypeInteger", "alias": "Mezzanine_Area", "domain": null }, { "name": "Total_Floor_Area", "type": "esriFieldTypeInteger", "alias": "Total_Floor_Area", "domain": null }, { "name": "Land_Bldg_Ratio", "type": "esriFieldTypeDouble", "alias": "Land_Bldg_Ratio", "domain": null }, { "name": "Floor_Area_Ratio", "type": "esriFieldTypeDouble", "alias": "Floor_Area_Ratio", "domain": null }, { "name": "Perimeter_Length", "type": "esriFieldTypeInteger", "alias": "Perimeter_Length", "domain": null }, { "name": "Office_Area", "type": "esriFieldTypeInteger", "alias": "Office_Area", "domain": null }, { "name": "Gross_Office_Pct", "type": "esriFieldTypeSingle", "alias": "Gross_Office_Pct", "domain": null }, { "name": "Gross_Income", "type": "esriFieldTypeInteger", "alias": "Gross_Income", "domain": null }, { "name": "Vacancy_Pct", "type": "esriFieldTypeSingle", "alias": "Vacancy_Pct", "domain": null }, { "name": "Effective_Gross_Income", "type": "esriFieldTypeInteger", "alias": "Effective_Gross_Income", "domain": null }, { "name": "Operating_Expense", "type": "esriFieldTypeInteger", "alias": "Operating_Expense", "domain": null }, { "name": "Net_Income", "type": "esriFieldTypeInteger", "alias": "Net_Income", "domain": null }, { "name": "Capitalization_Rate", "type": "esriFieldTypeSingle", "alias": "Capitalization_Rate", "domain": null }, { "name": "Gross_Rent_Multiplier", "type": "esriFieldTypeSingle", "alias": "Gross_Rent_Multiplier", "domain": null }, { "name": "Rent_SqFt", "type": "esriFieldTypeDouble", "alias": "Rent_SqFt", "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 1000, "domain": null }, { "name": "Location1", "type": "esriFieldTypeString", "alias": "Location1", "length": 30, "domain": null }, { "name": "Location2", "type": "esriFieldTypeString", "alias": "Location2", "length": 30, "domain": null }, { "name": "Location3", "type": "esriFieldTypeString", "alias": "Location3", "length": 30, "domain": null }, { "name": "Location4", "type": "esriFieldTypeString", "alias": "Location4", "length": 30, "domain": null }, { "name": "Utility_Desc1", "type": "esriFieldTypeString", "alias": "Utility_Desc1", "length": 30, "domain": null }, { "name": "Utility_Desc2", "type": "esriFieldTypeString", "alias": "Utility_Desc2", "length": 30, "domain": null }, { "name": "Utility_Desc3", "type": "esriFieldTypeString", "alias": "Utility_Desc3", "length": 30, "domain": null }, { "name": "Utility_Desc4", "type": "esriFieldTypeString", "alias": "Utility_Desc4", "length": 30, "domain": null }, { "name": "Utility_Desc5", "type": "esriFieldTypeString", "alias": "Utility_Desc5", "length": 30, "domain": null }, { "name": "Utility_Desc6", "type": "esriFieldTypeString", "alias": "Utility_Desc6", "length": 30, "domain": null }, { "name": "Utility_Desc7", "type": "esriFieldTypeString", "alias": "Utility_Desc7", "length": 30, "domain": null }, { "name": "Amenity1", "type": "esriFieldTypeString", "alias": "Amenity1", "length": 30, "domain": null }, { "name": "Amenity2", "type": "esriFieldTypeString", "alias": "Amenity2", "length": 30, "domain": null }, { "name": "Amenity3", "type": "esriFieldTypeString", "alias": "Amenity3", "length": 30, "domain": null }, { "name": "Amenity4", "type": "esriFieldTypeString", "alias": "Amenity4", "length": 30, "domain": null }, { "name": "Amenity5", "type": "esriFieldTypeString", "alias": "Amenity5", "length": 30, "domain": null }, { "name": "Amenity6", "type": "esriFieldTypeString", "alias": "Amenity6", "length": 30, "domain": null }, { "name": "Amenity7", "type": "esriFieldTypeString", "alias": "Amenity7", "length": 30, "domain": null }, { "name": "Amenity8", "type": "esriFieldTypeString", "alias": "Amenity8", "length": 30, "domain": null }, { "name": "Amenity9", "type": "esriFieldTypeString", "alias": "Amenity9", "length": 30, "domain": null }, { "name": "Amenity10", "type": "esriFieldTypeString", "alias": "Amenity10", "length": 30, "domain": null }, { "name": "Nbr_Indoor_Sports_Courts", "type": "esriFieldTypeSmallInteger", "alias": "Nbr_Indoor_Sports_Courts", "domain": null }, { "name": "Nbr_Outdoor_Sports_Courts", "type": "esriFieldTypeSmallInteger", "alias": "Nbr_Outdoor_Sports_Courts", "domain": null }, { "name": "Flat_Value", "type": "esriFieldTypeInteger", "alias": "Flat_Value", "domain": null }, { "name": "Flat_Value_Desc", "type": "esriFieldTypeString", "alias": "Flat_Value_Desc", "length": 30, "domain": null }, { "name": "Model_Code1", "type": "esriFieldTypeString", "alias": "Model_Code1", "length": 3, "domain": null }, { "name": "Model_Code2", "type": "esriFieldTypeString", "alias": "Model_Code2", "length": 3, "domain": null }, { "name": "Model_Code3", "type": "esriFieldTypeString", "alias": "Model_Code3", "length": 3, "domain": null }, { "name": "Model_Code4", "type": "esriFieldTypeString", "alias": "Model_Code4", "length": 3, "domain": null }, { "name": "Model_Code1_Suffix", "type": "esriFieldTypeString", "alias": "Model_Code1_Suffix", "length": 1, "domain": null }, { "name": "Model_Code2_Suffix", "type": "esriFieldTypeString", "alias": "Model_Code2_Suffix", "length": 1, "domain": null }, { "name": "Model_Code3_Suffix", "type": "esriFieldTypeString", "alias": "Model_Code3_Suffix", "length": 1, "domain": null }, { "name": "Model_Code4_Suffix", "type": "esriFieldTypeString", "alias": "Model_Code4_Suffix", "length": 1, "domain": null }, { "name": "Model_Pct1", "type": "esriFieldTypeSmallInteger", "alias": "Model_Pct1", "domain": null }, { "name": "Model_Pct2", "type": "esriFieldTypeSmallInteger", "alias": "Model_Pct2", "domain": null }, { "name": "Model_Pct3", "type": "esriFieldTypeSmallInteger", "alias": "Model_Pct3", "domain": null }, { "name": "Model_Pct4", "type": "esriFieldTypeSmallInteger", "alias": "Model_Pct4", "domain": null }, { "name": "Roof_Construction", "type": "esriFieldTypeString", "alias": "Roof_Construction", "length": 30, "domain": null }, { "name": "Bsmt_Model_Code", "type": "esriFieldTypeString", "alias": "Bsmt_Model_Code", "length": 3, "domain": null }, { "name": "Bsmt_Model_Code_Suffix", "type": "esriFieldTypeString", "alias": "Bsmt_Model_Code_Suffix", "length": 1, "domain": null }, { "name": "ESRI_OID", "type": "esriFieldTypeOID", "alias": "ESRI_OID", "domain": null } ], "indexes": [ { "name": "FDO_PID", "fields": "PID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 2, "name": "epgdb.GIS.Parcels", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "PID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "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, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "98265d27dcfb45bd815bfbee3731bed8" }