Pentaho:Address Output
Jump to navigation
Jump to search
← Data Quality Components for Pentaho
| Property Navigation | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| Overview | |||||||||
| Tutorial | |||||||||
| Advanced Configuration | |||||||||
| |||||||||
| Result Codes |
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.