Pentaho:Building Output

From Melissa Data Wiki
Jump to navigation Jump to search

← Data Quality Components for Pentaho

Property Navigation
Overview
Tutorial
Advanced Configuration
Property Tabs
Input
Address Output
Property Value Output
Building Output
Owner Output
Property Codes
Pass Through Columns
Output Filter
Result Codes



This tab lets you check the box next to the groups or columns you want to output for the building details information. The following are definitions of the available groups and columns. For a list of codes returned by these columns, refer to Property Codes.


Lot

These fields contain data on the physical dimensions of the entire property.

Front Footage
The linear feet across the front of the lot - facing the street.
Depth Footage
The linear feet between the front and back of the lot.
Acreage
Total land mass in Acres.
Square Footage
Total land mass in Square Feet.


SquareFootage

These fields contain physical information about the building or buildings on the property.

Universal Building
The Building Square Footage that can most accurately be used for assessments or comparables (e.g., Living, Adjusted, Gross).
Building Area Code
The codes appearing in this field indicate the source used to populate the UNIVERSAL BUILDING SQUARE FEET field (e.g., Living, Adjusted, Gross).
For a list of possible codes returned for this element, see Property Codes - Building Area Code.
Building Area
The size of the building in Square Feet. This field is most commonly populated as a cumulative total when a county does not differentiate between Living and Non-living areas.
Living Space
This is the area of a building that is used for general living. This is typically the area of a building that is heated or air conditioned and does not include Garage, Porch or Basement square footage.
Ground Floor
Square footage of the part of the building which is level with the ground (typically the front of the building). This is generally above the basement(s) and below the second floor.
Gross
This is the square footage for the entire building. Typically this represents all square feet under the roof.
Adjusted Gross
This is the square footage used by the county or local taxing / assessment authority to determine Improvement Value. This figure is typically 100% of the living area, plus lower percentage of non-living area.
Basement
This is total square footage associated with Basement portion of a building. This would include both finished and unfinished areas.
Garage or Parking
This is the total square footage of the primary garage or parking area (i.e., commercial). This includes both finished and unfinished areas.


Building

These fields contain information about the features of the building or buildings on the property.

Year Built
This is the construction year of the original building.
Effective Year Built
This is the first year the building was assessed with its current components (e.g., a building is originally constructed in 1960 and a bedroom and bath was added to the building in 1974). The Year Built would be 1960 and the Effective Year Built would be 1974.
Bed Rooms
Total number of Bedrooms contained in the primary building.
Total Rooms
Total number of rooms contained in the primary building.
Total Baths Calculated
Total number of Bathrooms in whole numbers (e.g., a home containing 2 1/2 baths would have the number 3 stored in this field as, three actual rooms have been designated for this purpose).
Total Baths
Total number of Bathrooms as provided by our data sources (e.g., 4.00, 2.50, 1.75).
Full Baths
Total number of Full Baths (typically comprised of a sink, toilet, and bathtub / shower stall). A home containing 2 1/2 baths would have the number 2 stored in this field.
Half Baths
Total number of Half Baths (typically comprised of a sink & toilet). A home containing 2 1/2 baths would have the number 1 stored in this field.
One Quarter Baths
Total number of Quarter Baths (typically comprised only of a sink, as found in many laundry rooms).
Three Quarter Baths
Total number of Three-Quarter Baths (typically comprised of a sink, toilet & shower stall).
Bath Fixtures
The total number of bathroom fixtures (typically a Full Bath would have 4 fixtures - 1 = sink, 1 = toilet, 1 = bathtub, 1 = shower head).
Air Conditioning Code
The type of air conditioning method used to cool the building (e.g., Central, Wall Unit, Evaporative).
For a list of possible codes returned for this element, see Property Codes - Air Conditioning Code.
Basement Code
The type of basement finish found in the building (e.g., Finished, Half, Crawl).
For a list of possible codes returned for this element, see Property Codes - Basement Code.
Building Code
The primary building type (e.g., Bowling Alley, Supermarket).
For a list of possible codes returned for this element, see Property Codes - Building Code.
Improvement Code
The primary improvement type (e.g., Grain Silo, Hanger, Marina).
For a list of possible codes returned for this element, see Property Codes - Improvement Code.
Condition Code
This represents the physical condition of the main improvement (e.g., Good, Fair, Under Construction).
For a list of possible codes returned for this element, see Property Codes - Condition Code.
Construction Code
The primary method of construction (e.g., Steel/Glass, Concrete Block, Log).
For a list of possible codes returned for this element, see Property Codes - Construction Code.
Exterior Wall Code
The type and/or finish of the exterior walls (e.g., Vinyl Siding, Brick Veneer, Frame / Stone).
For a list of possible codes returned for this element, see Property Codes - Exterior Wall Code.
Fireplace
This field is populated with a “Y” if a fireplace is located within the building.
Fireplaces
This represents the number of fireplace openings located within the building
Fireplace Code
The type of fireplace (e.g., 2 Story / 3 Openings, 2 Story Brick).
For a list of possible codes returned for this element, see Property Codes - Fireplace Code.
Foundation Code
The type of foundation (e.g., Continuous Footing, Pier, Mud Sill).
For a list of possible codes returned for this element, see Property Codes - Foundation Code.
Flooring Code
The type of floor construction (e.g., Concrete, Plywood).
For a list of possible codes returned for this element, see Property Codes - Flooring Code.
Roof Framing Code
The type of roof framing used (e.g., Bar Joist, Reinforced Concrete, Flexicore).
For a list of possible codes returned for this element, see Property Codes - Roof Framing Code.
Garage Code
Type of garage or carport present (e.g., Attached Finished, Enclosed Carport, Basement Garage).
For a list of possible codes returned for this element, see Property Codes - Garage Code.
Heating Code
Type or method of heating (e.g., Hot Water, Heat Pump, Baseboard, Radiant).
For a list of possible codes returned for this element, see Property Codes - Heating Code.
Mobile Home
This element is populated with a “Y” if a Mobile Home is present on the parcel.
Parking Spaces
This represent the total number of Parking Spaces or Car Capacity associated with the Garage or Parking type.
Parking Code
Type of parking found on the parcel. This is typically commercial or communal (e.g., Condos) in nature.
For a list of possible codes returned for this element, see Property Codes - Parking Code.
Pool
This element is populated with a “Y” if a Pool is present on the parcel.
Pool Code
Type of pool, construction or pool amenities (e.g., Kidney, Gunite, Vinyl, Jacuzzi, Heated).
For a list of possible codes returned for this element, see Property Codes - Pool Code.
Quality Code
Type of construction quality of building (e.g., excellent, economical).
For a list of possible codes returned for this element, see Property Codes - Quality Code.
Roof Cover Code
Type of roof covering (e.g., Clay Tile, Aluminum, Shake).
For a list of possible codes returned for this element, see Property Codes - Roof Cover Code.
Roof Type Code
Type of roof shape (e.g., Gambrel, Gable, Flat, Mansard).
For a list of possible codes returned for this element, see Property Codes - Roof Type Code.
Stories Code
Type / number of stories (e.g., Split Foyer, Tri Level, 2 Story).
For a list of possible codes returned for this element, see Property Codes - Stories Code.
Stories
Number of stories associated with the building (e.g., 2, 1.5).
Building Style Code
Type of building style (e.g., Colonial, Cape Code, Bungalow).
For a list of possible codes returned for this element, see Property Codes - Building Style Code.
Units
Number of Residential, Apartment or Business Units.
Electricity Code
Type of electricity or energy use within the building (e.g., Average Wiring, Underground Wired, Private Source).
For a list of possible codes returned for this element, see Property Codes - Electricity Code.
Fuel Code
Type of fuel used for heating of water and building (e.g., Solar, Gas, Oil).
For a list of possible codes returned for this element, see Property Codes - Fuel Code.
Sewer Code
Type of sewer system on the parcel (e.g., Public, Septic, Commercial).
For a list of possible codes returned for this element, see Property Codes - Sewer Code.
Water Code
Type of water service on the parcel (e.g., Public, Well, Cistern).
For a list of possible codes returned for this element, see Property Codes - Water Code.