Listware Online:Property

From Melissa Data Wiki
Revision as of 23:07, 26 July 2017 by Admin (talk | contribs) (Created page with "← Listware Online {{CustomTOC}} ==Upload== You must first upload the file you want to cleanse and enrich. Then select the data quality service you w...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

← Listware Online


Upload

You must first upload the file you want to cleanse and enrich.

Then select the data quality service you want to use.


Mapping

By default, the File Name, File Size, Header presence, and Record Count are displayed at the top of this page.

Review and Map the Input Columns

Match the input columns with the correct data type. The service will try to match the columns automatically, but you may need to do some fine tuning.


Outputs

Check the boxes next to your desired output columns

Parcel

These fields return information used to uniquely identify the parcel of land which the property occupies.

FIPS Code
Federal Information Processing Standards codes used nationally to numerically identify a specific county or political jurisdiction.
FIPS Sub Code
A secondary classification of a jurisdiction within a FIPS.
Unformatted APN
Assessor's Parcel Number in an unformatted form. This is most often used by the county and others as a unique key (e.g., 10132021A).
APN Sequence No.
This internal sequence number is used to ensure "uniqueness" of the Assessor's Parcel Number (e.g., 10132021A seq 001).
Formatted APN
Assessor's Parcel Number in a formatted form. Dashes and decimals are commonly used to break an APN down into logical components (e.g., 101-32-021.A).
Original APN
Assessor's Parcel Number exactly as received by source (e.g., 10132-021A00000).
Census Tract
Comprised of Census Tract, Census Block and Census Block Suffix. These numbers are established by the US Department of Commerce (Bureau Of The Census).
Zoning
The data contained in this field is based upon County and/or Local established Zoning Codes and are not converted by FARES.
Range
The “range” portion of geographical coordinates based on local surveys. Ranges typically run east or west of predetermined “meridian” in sixmile intervals.
Township
The “township” portion of geographical coordinates based on local surveys. Townships typically run north or south of predetermined “meridian” in six-mile intervals.
Section
The "section" portion of geographical coordinates based on local surveys. Sections are 1 square mile and there are 36 sections within the intersection of a Range / Township.
Quarter Section
A section that has been divided into four “sub” sections (e.g., NE, NW, SE, SW).
HomeStead Exempt
This field will be set with a “Y” if the owner has qualified for a Homeowner/Homestead exemption.
Absentee Owner Code
This field will be set with an "A" if the owner is an absentee.
For a list of possible codes returned for this element, see Property Codes - Absentee Owner Code.
Land User Code
A FARES established Land Use code converted from various county Land Use codes to aid in search and extract functions.
For a list of possible codes returned for this element, see Property Codes - Land Use Code.
County Land Use1
Primary (i.e., highest) Land Use as established by the county or local taxing administration.
County Land Use2
Secondary Land Use as established by the county or local taxing administration.
Property Indicator Code
A FARES general code used to easily recognize specific property types (e.g, Residential, Condominium, Commercial).
For a list of possible codes returned for this element, see Property Codes - Property Indicator Code.
Municipality Name
Name of the Municipality where parcel is located.
View Code
View from building (e.g., Gulf, Mountains, Pool).
For a list of possible codes returned for this element, see Property Codes - View Code.
Location Influence Code
Positive or negative aspects associated with the location of the parcel (e.g., waterfront, flood plane, airport).
For a list of possible codes returned for this element, see Property Codes - Location Influence Code.
Number Of Building
Total number of buildings on the parcel.

Property Address

These fields contain the physical address of the property.

Address
The first line of the street address (e.g., 22382 Avenida Empresa).
City
The city associated with the property address (CHICAGO, ATLANTA, DENVER).
State
The two-letter USPS postal abbreviation associated with the state/protectorants/commonwealth (CA, VI, PR).
Zip
The nine-digit code (i.e., ZIP & plus 4) assigned by the USPS. This is populated by various source files and other proprietary and nonproprietary processes (95463-0042).
Address Key
A unique 11-digit address key for the submitted address (92688211282).
Latitude
Geographic coordinate that specifies the northsouth position of a point on the Earth's surface (33.637550).
Longitude
Geographic coordinate that specifies the eastwest position of a point on the Earth's surface (117.606840).

Parsed Property Address

These fields contain the parsed address of the physical property.

Range
The delivery number of a parsed address.
Pre Directional
The geographic directional that precedes the street name(NW, E, etc).
Street Name
The name of the street from a parsed address (Empresa, etc).
Suffix
Suffix portion of a parsed address(Avenida).
Post Directional
Geographic directional that follows the street name.
Suite Name
The name of the secondary unit of a parsed address (Apt, Suite, etc.).
Suite Range
Range of any secondary unit of a parsed address.

Owner

These fields contain information on the current owner of the property.

Corporate Owner
The Name of the property owner has been recognized as a corporation or business.
Name
The name of the property owner.
Name2
Additional owner names if more than one person owns the property.
Unparsed Name1
Non-parsed owner name.
Unparsed Name2
Additional owner names if more than one person owns the property - non-parsed.
Phone
Phone number of property owner (e.g., 9095551212).
Phone OptOut
A “Y” represents a record where the property owner has contacted the DMA (i.e., Direct Marketing Association) and has asked not to be contacted by phone for solicitation.

Owner Address

These fields contain the ownder's mailing address.

Address
The first line of the street address.
Suite
The unit or suite number of the property address (e.g., 649 LAKE SHORE DR #1400).
City
The city associated with the property address (e.g., CHICAGO, ATLANTA, DENVER).
State
The two-letter USPS postal abbreviation associated with the state/protectorants/commonwealth (e.g., CA, VI, PR).
Zip
The nine-digit code (i.e., ZIP & plus 4) assigned by the USPS. This is populated by various source files and other proprietary and nonproprietary processes (e.g., 954630042).
Carrier Route
This is the four-digit code used by the local mail carrier to identify the delivery path.
Match Code
Indicates the level of matching for an owner's mailing address (no matching streets, ranges, etc.)
For a list of possible codes returned for this element, see Property Codes - Matchcode.
Mail Opt Out
A “Y” represents a record where the property owner has contacted the DMA (i.e., Direct Marketing Association) and has asked not to be contacted by mail for solicitation.

Values

These fields contain data on the current value of the property.

Calculated Total Value
The “TOTAL” (i.e., Land + Improvement) Value closest to current market value used for assessment by county or local taxing authorities.
Calculated Land Value
The “LAND” Value closest to current market value used for assessment by county or local taxing authorities.
Calculated Improvement Value
The “IMPROVEMENT” Value closest to current market value used for assessment by county or local taxing authorities.
Calculated Total Value Code
The code appearing in this indicator field reflects the type of values (e.g., Market, Appraised) used to seed the TOTAL VALUE CALCULATED field.
For a list of possible codes returned for this element, see Property Codes - Total Value Calculated Indicator.
Calculated Land Value Code
The code appearing in this indicator field reflects the type of values (e.g., Market, Appraised) used to seed the LAND VALUE CALCULATED field.
For a list of possible codes returned for this element, see Property Codes - Total Value Calculated Indicator.
Calculated Improvement Value Code
The code appearing in this indicator field reflects the type of values (e.g., Market, Appraised) used to seed the IMPROVEMENT VALUE CALCULATED field.
For a list of possible codes returned for this element, see Property Codes - Total Value Calculated Indicator.
Assessed Total Value
The Total Assessed Value of the Parcel's Land & Improvement values as provided by the county or local taxing/assessment authority.
Assessed Land Value
The Assessed Land Values as provided by the county or local taxing/assessment authority.
Assessed Improvement Value
The Assessed Improvement Values as provided by the county or local taxing/assessment authority.
Market Total Value
The Total Market Value of the Parcel's Land & Improvement values as provided by the county or local taxing/assessment authority.
Market Land Value
The Market Land Values as provided by the county or local taxing/assessment authority.
Market Improvement Value
The Market Improvement Values as provided by the county or local taxing/assessment authority.
Appraised Total Value
The Total Appraised Value of the Parcel's Land & Improvement values as provided by the county or local taxing/assessment authority.
Appraised Land Value
The Appraised Land Values as provided by the county or local taxing/assessment authority.
Appraised Improvement Value
The Appraised Improvement Values as provided by the county or local taxing/assessment authority.
Tax Amount
The Total Tax amount provided by the county or local taxing/assessment authority.
Tax Year
The tax or assessment year for which the taxes were billed.

Current Sale

These fields contain information from the most recent sale of the property.

Transaction Id
This is a FARES internal number used to identify a specific transaction. This number may aid customers in the creation of unique keys.
Document Year
The year a sales transaction document was recorded (e.g., 1984).
Deed Category Code
The type of deed used to record the sales transaction (e.g., Grant, Quit, Foreclosure).
Recording Date
The date the sales transaction was recorded at the county (e.g., 19621028).
Sale Date
The date the sales transaction was legally completed (i.e., contact signed) (e.g., 19621025).
Sale Price
Price of the sale as depicted on the recorded sales transaction.
Sale Code
This field indicates whether the financial consideration is F = Full or P = Partial.
For a list of possible codes returned for this element, see Property Codes - Sale Code.
Seller Name
The seller's name as it appears on the recorded sales transaction.
Multi APN Code
The data contained in this field depicts multiple or split parcel sales.
Multi APN Count
This reflects the number of parcels associated with the sale (e.g., 14 parcels recorded on the same document number).
Residental Model
A code to indicate whether the property is residential based on individual ZIP codes and values. “Y” = yes, “N” or blank = no.

Current Deed

These fields contain information about the current mortgage holder on the property.

Mortgage Amount
The amount of the first mortgage as depicted on the recorded document.
Mortgage Date
The date the Mortgage was initiated.
Mortgage Loan Type Code
Type of loan secured (e.g., Conventional, FHA, VA).
For a list of possible codes returned for this element, see Property Codes - Mortgage Loan Type Code.
Mortgage Deed Type Code
Type of deed used for recording (e.g., Agreement of Sale, Assumption, Correction Deed).
For a list of possible codes returned for this element, see Property Codes - Mortgage Deed Type Code.
Mortgage Term Code
This code is used to identify whether the number stored in the MORTGAGE TERM field is in Days, Months or Years.
For a list of possible codes returned for this element, see Property Codes - Mortgage Term Code.
Mortgage Term
The length of time before the mortgage matures (e.g., 15yrs, 30 yrs, 45dys).
Mortgage Due Date
The date the mortgage amount becomes due.
Mortgage Assumption Amount
The assumption amount related to an existing mortgage.
Lender Code
This is a FARES internal code used to identify the Lending Company that was associated with the sales transaction.
Lender Name
This is the name of the lender on the original recorded document.
Second Mortgage Amount
This is the amount associated with the 2nd mortgage.
Second Mortgage Loan Type Code
Type of loan secured as part of the 2nd mortgage (e.g., Conventional, FHA, VA).
Second Mortgage Deed Type Code
Type of deed used for recording the 2nd mortgage (e.g., Agreement of Sale, Assumption, Correction Deed).

Prior Sale

These fields contain information about a sale of the property prior to the most recent one.

Transaction Id
This is a FARES internal number used to identify a specific transaction. This number may aid customers in the creation of unique keys.
Document Year
The year a sales transaction document was recorded (e.g., 1984).
Deed Category Code
The type of deed used to record the prior sales transaction (e.g., Grant, Quit, Foreclosure).
For a list of possible codes returned for this element, see Property Codes - Deed Category Code.
Recording Date
The date the sales transaction was recorded at the county (e.g., 19621028).
Sale Date
The date the sales transaction was legally completed (i.e., contact signed) (e.g., 19621025).
Sale Price
Price of the sale as depicted on the recorded sales transaction.
Sale Code
This field indicates whether the financial consideration is F = Full or P = Partial.
Transaction Code
This identifies situations associated with the sale (e.g., Resale, Construction Loan, Seller Carryback).
Multi APN Code
The data contained in this field depicts multiple or split parcel sales.
For a list of possible codes returned for this element, see Property Codes - Multi APN Code.
Multi APN Count
This reflects the number of parcels associated with the sale (e.g., 14 parcels recorded on the same document number).
Mortgage Amount
This is the amount associated with the mortgage of the prior sale.
Deed Type Code
Type of deed used for recording (e.g., Agreement of Sale, Assumption, Correction Deed).

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.

Square Footage

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.


Review

This section displays your selected options and columns.

Create Job Name

You must also create a name for the job.


Report

Once we have processed your job, you may access a summary report of the job. This will show you the record counts (e.g. number of verified records, matches, etc.) and credit costs.