Pentaho/Contact Zone:Address Output

From Melissa Data Wiki
Revision as of 22:09, 11 January 2017 by Admin (talk | contribs) (Created page with "{{PentahoCZPropertyNav |PropertyTabsCollapse= }} {{CustomTOC}} link= This tab lets you check the box next to the groups or columns...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

← Contact Zone

← 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



PENT Property AddressOutput.png

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

Property Address

These fields contain the physical address of the property.

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). For more information please see Melissa Address Key.
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.
PreDirectional
The geographic directional that precedes the street name(NW, E, etc).
StreetName

The name of the street from a parsed address (Empresa, etc).

Suffix
Suffix portion of a parsed address(Avenida).
PostDirectional
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.


Parcel

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

FIPSCode
Federal Information Processing Standards codes used nationally to numerically identify a specific county or political jurisdiction.
FIPSSubCode
A secondary classification of a jurisdiction within a FIPS.
UnformattedAPN
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).
APNSequenceNo
This internal sequence number is used to ensure "uniqueness" of the Assessor's Parcel Number (e.g., 10132021A seq 001).
FormattedAPN
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).
OriginalAPN
Assessor's Parcel Number exactly as received by source (e.g., 10132-021A00000).
CensusTract
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.
QuarterSection
A section that has been divided into four “sub” sections (e.g., NE, NW, SE, SW).
HomesteadExempt
This field will be set with a “Y” if the owner has qualified for a Homeowner/Homestead exemption.
AbsenteeOwnerCode
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.
LandUseCode
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.
CountyLandUse1
Primary (i.e., highest) Land Use as established by the county or local taxing administration.
CountyLandUse2
Secondary Land Use as established by the county or local taxing administration.
PropertyIndicatorCode
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.
MunicipalityName
Name of the Municipality where parcel is located.
ViewCode
View from building (e.g., Gulf, Mountains, Pool).
For a list of possible codes returned for this element, see Property Codes - View Code.
LocationInfluenceCode
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.
NumberOfBuildings
Total number of buildings on the parcel.