{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 31, "name": "Building Details", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "Building_Address", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "ObjectID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "Building_Id", "type": "esriFieldTypeDouble", "alias": "Building Id", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Building_Id" }, { "name": "Parcel_Pk", "type": "esriFieldTypeDouble", "alias": "Parcel Pk", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Parcel_Pk" }, { "name": "Parcel_Number", "type": "esriFieldTypeDouble", "alias": "Parcel Number", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Parcel_Number" }, { "name": "Building_Card_Number", "type": "esriFieldTypeDouble", "alias": "Building Card Number", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Building_Card_Number" }, { "name": "Building_Address", "type": "esriFieldTypeString", "alias": "Building Address", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Building_Address" }, { "name": "Building_Description", "type": "esriFieldTypeString", "alias": "Building Description", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Building_Description" }, { "name": "Building_Type", "type": "esriFieldTypeString", "alias": "Building Type", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Building_Type" }, { "name": "Number_of_Units", "type": "esriFieldTypeDouble", "alias": "Number of Units", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Number_of_Units" }, { "name": "Heated_Area", "type": "esriFieldTypeDouble", "alias": "Heated Area", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Heated_Area" }, { "name": "Story_Height", "type": "esriFieldTypeDouble", "alias": "Story Height", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Story_Height" }, { "name": "Design_Style", "type": "esriFieldTypeString", "alias": "Design Style", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Design_Style" }, { "name": "Basement_Type", "type": "esriFieldTypeString", "alias": "Basement Type", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Basement_Type" }, { "name": "Exterior_Type", "type": "esriFieldTypeString", "alias": "Exterior Type", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Exterior_Type" }, { "name": "Construction_Type", "type": "esriFieldTypeString", "alias": "Construction Type", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Construction_Type" }, { "name": "Heating_Type", "type": "esriFieldTypeString", "alias": "Heating Type", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Heating_Type" }, { "name": "Air_Conditioning_Type", "type": "esriFieldTypeString", "alias": "Air Conditioning Type", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Air_Conditioning_Type" }, { "name": "Total_Plumbing_Fixtures", "type": "esriFieldTypeDouble", "alias": "Total Plumbing Fixtures", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Total_Plumbing_Fixtures" }, { "name": "Year_Built", "type": "esriFieldTypeDouble", "alias": "Year Built", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Year_Built" }, { "name": "Effective_Year", "type": "esriFieldTypeDouble", "alias": "Effective Year", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Effective_Year" }, { "name": "Additions", "type": "esriFieldTypeDouble", "alias": "Additions", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Additions" }, { "name": "Remodeled", "type": "esriFieldTypeDouble", "alias": "Remodeled", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Remodeled" }, { "name": "Interior_Adjustments", "type": "esriFieldTypeString", "alias": "Interior Adjustments", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Interior_Adjustments" }, { "name": "Other_Features", "type": "esriFieldTypeString", "alias": "Other Features", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Other_Features" }, { "name": "Building_Value", "type": "esriFieldTypeDouble", "alias": "Building Value", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Building_Value" }, { "name": "Grade", "type": "esriFieldTypeString", "alias": "Grade", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Grade" }, { "name": "Condition", "type": "esriFieldTypeString", "alias": "Condition", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Condition" }, { "name": "Depreciation_Percent", "type": "esriFieldTypeString", "alias": "Depreciation Percent", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Depreciation_Percent" }, { "name": "Market_Adjustment_1", "type": "esriFieldTypeString", "alias": "Market Adjustment 1", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Market_Adjustment_1" }, { "name": "Market_Adjustment_2", "type": "esriFieldTypeString", "alias": "Market Adjustment 2", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Market_Adjustment_2" }, { "name": "Market_Adjustment_3", "type": "esriFieldTypeString", "alias": "Market Adjustment 3", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Market_Adjustment_3" }, { "name": "Accrued_Percent", "type": "esriFieldTypeDouble", "alias": "Accrued Percent", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Accrued_Percent" }, { "name": "Incomplete_Code", "type": "esriFieldTypeDouble", "alias": "Incomplete Code", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Incomplete_Code" }, { "name": "Total_Building_Value", "type": "esriFieldTypeDouble", "alias": "Total Building Value", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Total_Building_Value" }, { "name": "All_Cards_Value", "type": "esriFieldTypeString", "alias": "All Cards Value", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "All_Cards_Value" }, { "name": "Sketch_Path", "type": "esriFieldTypeString", "alias": "Sketch Path", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Sketch_Path" }, { "name": "Photo_Path", "type": "esriFieldTypeString", "alias": "Photo Path", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Photo_Path" }, { "name": "Photo_Date", "type": "esriFieldTypeDate", "alias": "Photo Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Photo_Date" }, { "name": "Bedrooms", "type": "esriFieldTypeDouble", "alias": "Bedrooms", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Bedrooms" }, { "name": "Foundation", "type": "esriFieldTypeString", "alias": "Foundation", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Foundation" }, { "name": "Frame", "type": "esriFieldTypeString", "alias": "Frame", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Frame" }, { "name": "Floor", "type": "esriFieldTypeString", "alias": "Floor", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Floor" }, { "name": "Floor2", "type": "esriFieldTypeString", "alias": "Floor2", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Floor2" }, { "name": "Subfloor", "type": "esriFieldTypeString", "alias": "Subfloor", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Subfloor" }, { "name": "Roof_Cover", "type": "esriFieldTypeString", "alias": "Roof Cover", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Roof_Cover" }, { "name": "Roof_Type", "type": "esriFieldTypeString", "alias": "Roof Type", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Roof_Type" }, { "name": "Ceiling_Insulation", "type": "esriFieldTypeString", "alias": "Ceiling Insulation", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Ceiling_Insulation" }, { "name": "Lighting", "type": "esriFieldTypeString", "alias": "Lighting", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Lighting" }, { "name": "Occupancy", "type": "esriFieldTypeString", "alias": "Occupancy", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Occupancy" }, { "name": "AC_Unit_Count", "type": "esriFieldTypeString", "alias": "AC Unit Count", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "AC_Unit_Count" }, { "name": "Main_Body_Footprint_Area", "type": "esriFieldTypeDouble", "alias": "Main Body Footprint Area", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Main_Body_Footprint_Area" }, { "name": "Total_Adjusted_Replacement_Valu", "type": "esriFieldTypeDouble", "alias": "Total Adjusted Replacement Value", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Total_Adjusted_Replacement_Valu" }, { "name": "Depreciated_Value", "type": "esriFieldTypeDouble", "alias": "Depreciated Value", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Depreciated_Value" }, { "name": "Total_Depreciated_Value", "type": "esriFieldTypeDouble", "alias": "Total Depreciated Value", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Total_Depreciated_Value" }, { "name": "Market_Area_Factor", "type": "esriFieldTypeDouble", "alias": "Market Area Factor", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Market_Area_Factor" }, { "name": "Misc_Improvement_Assessed_Value", "type": "esriFieldTypeDouble", "alias": "Misc Improvement Assessed Value", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Misc_Improvement_Assessed_Value" }, { "name": "Economic_Depreciation_Percent", "type": "esriFieldTypeString", "alias": "Economic Depreciation Percent", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Economic_Depreciation_Percent" }, { "name": "Economic_Depreciation_Note", "type": "esriFieldTypeString", "alias": "Economic Depreciation Note", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Economic_Depreciation_Note" }, { "name": "Functional_Depreciation_Percent", "type": "esriFieldTypeString", "alias": "Functional Depreciation Percent", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Functional_Depreciation_Percent" }, { "name": "Functional_Depreciation_Note", "type": "esriFieldTypeString", "alias": "Functional Depreciation Note", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Functional_Depreciation_Note" }, { "name": "Bath_Full", "type": "esriFieldTypeDouble", "alias": "Bath Full", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Bath_Full" }, { "name": "Bath_Half", "type": "esriFieldTypeDouble", "alias": "Bath Half", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Bath_Half" }, { "name": "Extra_Fixtures", "type": "esriFieldTypeDouble", "alias": "Extra Fixtures", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Extra_Fixtures" }, { "name": "REID", "type": "esriFieldTypeString", "alias": "Record Number", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "REID" } ], "indexes": [ { "name": "R607_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_5151_REID", "fields": "REID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": true }, "types": [], "templates": [ { "name": "Building Details", "description": "", "prototype": { "attributes": { "Extra_Fixtures": null, "REID": null, "Building_Id": null, "Parcel_Pk": null, "Parcel_Number": null, "Building_Card_Number": null, "Building_Address": null, "Building_Description": null, "Building_Type": null, "Number_of_Units": null, "Heated_Area": null, "Story_Height": null, "Design_Style": null, "Basement_Type": null, "Exterior_Type": null, "Construction_Type": null, "Heating_Type": null, "Air_Conditioning_Type": null, "Total_Plumbing_Fixtures": null, "Year_Built": null, "Effective_Year": null, "Additions": null, "Remodeled": null, "Interior_Adjustments": null, "Other_Features": null, "Building_Value": null, "Grade": null, "Condition": null, "Depreciation_Percent": null, "Market_Adjustment_1": null, "Market_Adjustment_2": null, "Market_Adjustment_3": null, "Accrued_Percent": null, "Incomplete_Code": null, "Total_Building_Value": null, "All_Cards_Value": null, "Sketch_Path": null, "Photo_Path": null, "Photo_Date": null, "Bedrooms": null, "Foundation": null, "Frame": null, "Floor": null, "Floor2": null, "Subfloor": null, "Roof_Cover": null, "Roof_Type": null, "Ceiling_Insulation": null, "Lighting": null, "Occupancy": null, "AC_Unit_Count": null, "Main_Body_Footprint_Area": null, "Total_Adjusted_Replacement_Valu": null, "Depreciated_Value": null, "Total_Depreciated_Value": null, "Market_Area_Factor": null, "Misc_Improvement_Assessed_Value": null, "Economic_Depreciation_Percent": null, "Economic_Depreciation_Note": null, "Functional_Depreciation_Percent": null, "Functional_Depreciation_Note": null, "Bath_Full": null, "Bath_Half": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "53e6fa03dbe944649aa2f8f4fe914be1" }