Name: Building Details

Display Field: Building_Address

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 53e6fa03dbe944649aa2f8f4fe914be1

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
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: false
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:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: ObjectID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Building_Id ( type: esriFieldTypeDouble, alias: Building Id, editable: true, nullable: true, defaultValue: null, modelName: Building_Id )
• Parcel_Pk ( type: esriFieldTypeDouble, alias: Parcel Pk, editable: true, nullable: true, defaultValue: null, modelName: Parcel_Pk )
• Parcel_Number ( type: esriFieldTypeDouble, alias: Parcel Number, editable: true, nullable: true, defaultValue: null, modelName: Parcel_Number )
• Building_Card_Number ( type: esriFieldTypeDouble, alias: Building Card Number, editable: true, nullable: true, defaultValue: null, modelName: Building_Card_Number )
• Building_Address ( type: esriFieldTypeString, alias: Building Address, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Building_Address )
• Building_Description ( type: esriFieldTypeString, alias: Building Description, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Building_Description )
• Building_Type ( type: esriFieldTypeString, alias: Building Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Building_Type )
• Number_of_Units ( type: esriFieldTypeDouble, alias: Number of Units, editable: true, nullable: true, defaultValue: null, modelName: Number_of_Units )
• Heated_Area ( type: esriFieldTypeDouble, alias: Heated Area, editable: true, nullable: true, defaultValue: null, modelName: Heated_Area )
• Story_Height ( type: esriFieldTypeDouble, alias: Story Height, editable: true, nullable: true, defaultValue: null, modelName: Story_Height )
• Design_Style ( type: esriFieldTypeString, alias: Design Style, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Design_Style )
• Basement_Type ( type: esriFieldTypeString, alias: Basement Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Basement_Type )
• Exterior_Type ( type: esriFieldTypeString, alias: Exterior Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Exterior_Type )
• Construction_Type ( type: esriFieldTypeString, alias: Construction Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Construction_Type )
• Heating_Type ( type: esriFieldTypeString, alias: Heating Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Heating_Type )
• Air_Conditioning_Type ( type: esriFieldTypeString, alias: Air Conditioning Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Air_Conditioning_Type )
• Total_Plumbing_Fixtures ( type: esriFieldTypeDouble, alias: Total Plumbing Fixtures, editable: true, nullable: true, defaultValue: null, modelName: Total_Plumbing_Fixtures )
• Year_Built ( type: esriFieldTypeDouble, alias: Year Built, editable: true, nullable: true, defaultValue: null, modelName: Year_Built )
• Effective_Year ( type: esriFieldTypeDouble, alias: Effective Year, editable: true, nullable: true, defaultValue: null, modelName: Effective_Year )
• Additions ( type: esriFieldTypeDouble, alias: Additions, editable: true, nullable: true, defaultValue: null, modelName: Additions )
• Remodeled ( type: esriFieldTypeDouble, alias: Remodeled, editable: true, nullable: true, defaultValue: null, modelName: Remodeled )
• Interior_Adjustments ( type: esriFieldTypeString, alias: Interior Adjustments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Interior_Adjustments )
• Other_Features ( type: esriFieldTypeString, alias: Other Features, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Other_Features )
• Building_Value ( type: esriFieldTypeDouble, alias: Building Value, editable: true, nullable: true, defaultValue: null, modelName: Building_Value )
• Grade ( type: esriFieldTypeString, alias: Grade, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Grade )
• Condition ( type: esriFieldTypeString, alias: Condition, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Condition )
• Depreciation_Percent ( type: esriFieldTypeString, alias: Depreciation Percent, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Depreciation_Percent )
• Market_Adjustment_1 ( type: esriFieldTypeString, alias: Market Adjustment 1, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Market_Adjustment_1 )
• Market_Adjustment_2 ( type: esriFieldTypeString, alias: Market Adjustment 2, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Market_Adjustment_2 )
• Market_Adjustment_3 ( type: esriFieldTypeString, alias: Market Adjustment 3, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Market_Adjustment_3 )
• Accrued_Percent ( type: esriFieldTypeDouble, alias: Accrued Percent, editable: true, nullable: true, defaultValue: null, modelName: Accrued_Percent )
• Incomplete_Code ( type: esriFieldTypeDouble, alias: Incomplete Code, editable: true, nullable: true, defaultValue: null, modelName: Incomplete_Code )
• Total_Building_Value ( type: esriFieldTypeDouble, alias: Total Building Value, editable: true, nullable: true, defaultValue: null, modelName: Total_Building_Value )
• All_Cards_Value ( type: esriFieldTypeString, alias: All Cards Value, editable: true, nullable: true, length: 255, defaultValue: null, modelName: All_Cards_Value )
• Sketch_Path ( type: esriFieldTypeString, alias: Sketch Path, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Sketch_Path )
• Photo_Path ( type: esriFieldTypeString, alias: Photo Path, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Photo_Path )
• Photo_Date ( type: esriFieldTypeDate, alias: Photo Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Photo_Date )
• Bedrooms ( type: esriFieldTypeDouble, alias: Bedrooms, editable: true, nullable: true, defaultValue: null, modelName: Bedrooms )
• Foundation ( type: esriFieldTypeString, alias: Foundation, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Foundation )
• Frame ( type: esriFieldTypeString, alias: Frame, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Frame )
• Floor ( type: esriFieldTypeString, alias: Floor, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Floor )
• Floor2 ( type: esriFieldTypeString, alias: Floor2, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Floor2 )
• Subfloor ( type: esriFieldTypeString, alias: Subfloor, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Subfloor )
• Roof_Cover ( type: esriFieldTypeString, alias: Roof Cover, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Roof_Cover )
• Roof_Type ( type: esriFieldTypeString, alias: Roof Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Roof_Type )
• Ceiling_Insulation ( type: esriFieldTypeString, alias: Ceiling Insulation, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Ceiling_Insulation )
• Lighting ( type: esriFieldTypeString, alias: Lighting, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Lighting )
• Occupancy ( type: esriFieldTypeString, alias: Occupancy, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Occupancy )
• AC_Unit_Count ( type: esriFieldTypeString, alias: AC Unit Count, editable: true, nullable: true, length: 255, defaultValue: null, modelName: AC_Unit_Count )
• Main_Body_Footprint_Area ( type: esriFieldTypeDouble, alias: Main Body Footprint Area, editable: true, nullable: true, defaultValue: null, modelName: Main_Body_Footprint_Area )
• Total_Adjusted_Replacement_Valu ( type: esriFieldTypeDouble, alias: Total Adjusted Replacement Value, editable: true, nullable: true, defaultValue: null, modelName: Total_Adjusted_Replacement_Valu )
• Depreciated_Value ( type: esriFieldTypeDouble, alias: Depreciated Value, editable: true, nullable: true, defaultValue: null, modelName: Depreciated_Value )
• Total_Depreciated_Value ( type: esriFieldTypeDouble, alias: Total Depreciated Value, editable: true, nullable: true, defaultValue: null, modelName: Total_Depreciated_Value )
• Market_Area_Factor ( type: esriFieldTypeDouble, alias: Market Area Factor, editable: true, nullable: true, defaultValue: null, modelName: Market_Area_Factor )
• Misc_Improvement_Assessed_Value ( type: esriFieldTypeDouble, alias: Misc Improvement Assessed Value, editable: true, nullable: true, defaultValue: null, modelName: Misc_Improvement_Assessed_Value )
• Economic_Depreciation_Percent ( type: esriFieldTypeString, alias: Economic Depreciation Percent, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Economic_Depreciation_Percent )
• Economic_Depreciation_Note ( type: esriFieldTypeString, alias: Economic Depreciation Note, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Economic_Depreciation_Note )
• Functional_Depreciation_Percent ( type: esriFieldTypeString, alias: Functional Depreciation Percent, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Functional_Depreciation_Percent )
• Functional_Depreciation_Note ( type: esriFieldTypeString, alias: Functional Depreciation Note, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Functional_Depreciation_Note )
• Bath_Full ( type: esriFieldTypeDouble, alias: Bath Full, editable: true, nullable: true, defaultValue: null, modelName: Bath_Full )
• Bath_Half ( type: esriFieldTypeDouble, alias: Bath Half, editable: true, nullable: true, defaultValue: null, modelName: Bath_Half )
• Extra_Fixtures ( type: esriFieldTypeDouble, alias: Extra Fixtures, editable: true, nullable: true, defaultValue: null, modelName: Extra_Fixtures )
• REID ( type: esriFieldTypeString, alias: Record Number, editable: true, nullable: true, length: 20, defaultValue: null, modelName: REID )

Templates:

• Name: Building Details
  Description:
  Prototype:
  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
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Analytic   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata