Assesor Layout
| Field Name | Field Description | Data Type |
|---|---|---|
| Constellation_ID (CID) | CID (Constellation Unique Identifier) | varchar |
| FIPS Code (State/County) | Numeric code which identifies every County/State in the United States. First 2 bytes = State; last 3 = County. | varchar |
| Assessor’s Parcel Number (APN, PIN) | Assessor's Parcel Number or Parcel Identification Number. An arbitrary parcel identifier assigned by the county Assessor to simplify identification and expedite the locating of parcels. While format and composition vary widely, it is usually composed of MAP, PAGE, PARCEL, and SUB PARCEL numbers. Some counties use SEC‑TWP‑RNG as part of the APN or a MAP-BOOK, PAGE, and PARCEL reference; others use SUBDIVISION, BLOCK, and LOT to identify a parcel. Leading zeros or spaces used to maintain the integrity of the format. Re-formatted if necessary to match the county display format. | varchar |
| Property Full Street Address | Street Address components are: • House Number • House Alpha (i.e. 400 ½, 230A, etc.) • Street Direction Left (i.e. N, S, E, W, NE, SE, etc.) • Street Name • Suffix (Ave, Rd, St, etc.) • Street Direction Right (i.e. N, S, E, W, NE, SE etc.) Example incorporating all components: 400 ½ E Iris Ave NE Note: Rural Routes are considered to be Property Addresses. | varchar |
| City | City Name where the property is located. May be different from Legal: City, Municipality, Township | varchar |
| State Or Province | Two-letter standard postal abbreviation | varchar |
| Postal Code | 5-digit postal zip code. May be obtained from mailing address for owner‑occupied. | varchar |
| Postal Code Plus 4 | 4‑digit extension to postal zip code for the property address. Not always available. | varchar |
| Street Number | House number location of the property. In some areas, house numbers may include a direction designation. EXAMPLE: 123N456 MAIN ST | varchar |
| Street Direction Prefix | Appears before the street name and denotes the street name direction. VALID DIRECTIONS: N, S, E, W and NE, NW, SE, SW EXAMPLE: 3550 W Temple St | varchar |
| Street Name | varchar | |
| Street Suffix | The recommended Official USPS Standardized Suffix Abbreviations | varchar |
| Street Direction Suffix | In some cities (Seattle), the directional appears after the street suffix to denote direction/quadrant. EXAMPLE: 12345 Main St N Both directions may be present: 12345 N Main St NW | varchar |
| Unit Number | Unit or suite number. Part of the Property Address. Also may be present in mailing address. Often used to identify condo or apartment units. May be numeric or alpha or both. EXAMPLES: Unit 5, or #5, or Number 5, or Unit Five - entered as: 5 | varchar |
| Unit Type | Property Address Unit Designator. | varchar |
| Carrier Route | Format: C999 | varchar |
| Census Tract | Format: 999999999.99999C First 5 bytes = FIPS; 7 bytes = Census Tract; Last 4 bytes = Census Block Code (1st byte of Block Code = Block Number) | varchar |
| Latitude | Format: 99.999999 | float |
| Longitude | Format: -999.99999 | float |
| Match Code | See GeoStan Status Match codes: see https://support.precisely.com/products/geostan/ | varchar |
| Location Code | See GeoStan Status Location codes: see https://support.precisely.com/products/geostan/ | varchar |
| Bathrooms Full | Physical count of all bathrooms (including 1/2 baths). Input Format: 99.99 | decimal |
| Bathrooms Partial | int | |
| Bedrooms Total | Actual count of bedrooms (with closet). Residential only. | int |
| Year Built | Year the primary structure on the property was built | varchar |
| Topography | Contains code representing the physical (including man-made) or natural features of the land. | varchar |
| Site Influence | Identifies features or characteristics of a location which might influence the value or desirability of a parcel, such as waterfront or traffic patterns. The field can contain up to two codes. | varchar |
| Air Conditioning | Central Evaporative Cooler Office only Geo-Thermal Packaged Unit Window\Unit None Other Partial Chilled Water Refrigeration Ventilation Wall Yes | varchar |
| Air Conditioning Type | Evaporative Cooler Geo-Thermal Refrigeration Ventilation Chilled Water | varchar |
| Amenities | Identifies the extra selling features that add to the value of property, such as a tennis court or golf course. This data is provided by the county, but typically does not indicate the size of the Amenity. This field can contain up to five codes. | varchar |
| Basement | Basement (not specified) Daylight, Full Full Basement Improved Basement (Finished) Daylight, Partial No Basement Partial Basement Unfinished Basement Daylight / Walkout | varchar |
| Building Area | The building area of the primary structure on the property. When multiple building areas are given for a structure, the preferred data for this field is Living Area for residential properties and Total Area for all others. | varchar |
| Building Area 1 | Building area for a building features, such as garage, porch, basement | varchar |
| Building Area 1 Indicator | Two-digit Code describing the feature moves to Building Area; If single position, can be combined with 'F' for Finished, or 'U' for Unfinished | varchar |
| Building Area 2 | Building area for a building features, such as garage, porch, basement | varchar |
| Building Area 2 Indicator | Two-digit Code describing the feature moves to Building Area; If single position, can be combined with 'F' for Finished, or 'U' for Unfinished | varchar |
| Building Area 3 | Building area for a building features, such as garage, porch, basement | varchar |
| Building Area 3 Indicator | Two-digit Code describing the feature moves to Building Area; If single position, can be combined with 'F' for Finished, or 'U' for Unfinished | varchar |
| Building Area 4 | Building area for a building features, such as garage, porch, basement | varchar |
| Building Area 4 Indicator | Two-digit Code describing the feature moves to Building Area; If single position, can be combined with 'F' for Finished, or 'U' for Unfinished | varchar |
| Building Area 5 | Building area for a building features, such as garage, porch, basement | varchar |
| Building Area 5 Indicator | Two-digit Code describing the feature moves to Building Area; If single position, can be combined with 'F' for Finished, or 'U' for Unfinished | varchar |
| Building Area 6 | Building area for a building features, such as garage, porch, basement | varchar |
| Building Area 6 Indicator | Two-digit Code describing the feature moves to Building Area; If single position, can be combined with 'F' for Finished, or 'U' for Unfinished | varchar |
| Building Area 7 | Building area for a building features, such as garage, porch, basement | varchar |
| Building Area 7 Indicator | Two-digit Code describing the feature moves to Building Area; If single position, can be combined with 'F' for Finished, or 'U' for Unfinished | varchar |
| Building Class | Fire Insurance Building Classification Code used for Commercial/Industrial buildings. | varchar |
| Building Condition | Additional information regarding a parcel. This information may come from a comments field provided by the county or can be information added by the analyst. If Duplicate parcels are present, this field contains a Summary of multiple building records and should contain the Improvement # and any available physical characteristics. | varchar |
| Building Quality | Buildings having fireproofed structural steel frames carrying all wall, floor and roof loads. Wall, floor and roof structures are built of non-combustible materials. Buildings having fireproofed reinforced concrete frames carrying all wall, floor and roof loads which are all non-combustible. Buildings having exterior walls built of a non-combustible material such as brick, concrete, block or poured concrete. Interior partitions and roof structure are built of combustible materials. Floor may be concrete or wood frame. Buildings having wood or wood and steel frames. Specialized buildings that do not fit in any of the above categories. | varchar |
| Comments: Summary of Building Cards ("DR" Records) | Additional information regarding a parcel. This information may come from a comments field provided by the county or can be information added by the analyst. If Duplicate parcels are present, this field contains a Summary of multiple building records and should contain the Improvement # and any available physical characteristics. | varchar |
| Effective Year Built | The date that reflects the condition of an improvement. It is the same or later than Year Built. NOTE: If the county does not provide the effective year built, use remodel year is moved. | varchar |
| Exterior Walls | List of values describing the different types of exterior walls: EIFS / Synthetic Stucco Fiber cement siding (Hardi-board/Hardi-plank) Aluminum siding Vinyl siding Concrete tile Clay tile Ceramic tile Bamboo Asbestos Shingle Brick Brick Veneer Block Composition/Composite Concrete Concrete Block Glass Log Metal Rock, Stone Stucco Tile Tilt-up (pre-cast concrete) Other Wood Shingle Wood Wood Siding Siding (Alum/Vinyl) Adobe Shingle (Not Wood) Marble Combination Masonry Siding (not specified) | varchar |
| Extra Features 1 Area | Allow for identifying areas for up to 4 extra features, such as driveways, fences, paving. An exterior feature potentially adds value to the property, but is not a building or attribute that has been designated under Other Buildings/Improvements. The area of the feature moves to Extra Features Area, expressed in square feet and/or dimensions, and a one or two-digit Code describing the feature moves to Extra Features Area Indicator. It is not necessary for this field to be populated to populate the Indicator fields. | varchar |
| Extra Features 1 Indicator | A one or two-digit Code describing the extra feature. The first byte of Extra Feature Indicator represents the feature (driveway, fence, paving) and the 2nd byte, if present, indicates the specific type of feature. It is possible for this field to be populated and not the corresponding Extra Features field | varchar |
| Extra Features 2 Area | See description for Extra_Features_1_Area | varchar |
| Extra Features 2 Indicator | See description for Extra_Features_1_Indicator | varchar |
| Extra Features 3 Area | See description for Extra_Features_1_Area | varchar |
| Extra Features 3 Indicator | See description for Extra_Features_1_Indicator | varchar |
| Extra Features 4 Area | See description for Extra_Features_1_Area | varchar |
| Extra Features 4 Indicator | See description for Extra_Features_1_Indicator | varchar |
| Fireplace | The actual number of fireplaces or (Y)es | varchar |
| FLOOR COVER | This field contains a code reflecting the type of flooring used in improvements on the property | varchar |
| Foundation | Concrete Crawl/Raised Crossed Walls Masonry Earth Mud Sill Stone Brick Concrete Block Piling Other Piers Open Piers Retaining Wall Slab Footing Wood Closed Piers | varchar |
| Garage (Parking) - # of Cars | When available from county assessor. Total number of cars which garage, carport, or parking lot/structure will accommodate. When parking square footage is available instead of the number of cars, it is converted by estimating the average size as follows: 200 SF = 1 Car; 400 SF = 2 Cars; 720 SF = 3 Cars; etc. | int |
| Garage Type (Parking) | A Attached Garage B Built-in C Carport D Detached Garage E Pole F Offsite G Garage H Heated I Unfinished - Attached J Unfinished - Detached K Unimproved L Parking Lot M Mixed N None O Open P Paved/Surfaced R Ramp S Parking Structure T Tuckunder U Underground/Basement V Covered W Finished - Attached X Finished - Detached Z Finished | varchar |
| Heating | A Baseboard B Electric C Central D Forced Air Unit E Oil F Floor/Wall G Gravity H Heat Pump I Geo-Thermal J Hot Water K Gas L Partial M Radiant N None O Other P Steam Q Coal R Space/Suspended S Convection T Solar V Vent W Wood Burning X Propane Y Yes Z Zone | varchar |
| Heating Fuel Type | The type of heating fuel (oil, gas, solar). Some counties may also provide a heating system type, which moves to Heating. | varchar |
| Interior Walls | This field contains a code reflecting the composition of the interior walls | varchar |
| Main Building Area Indicator | Code describing the feature moves to Building Area | varchar |
| No. of Buildings | A. All property types: Total number of buildings or structures on a single parcel as reported on the Assessment Roll. OR B. When a Multi-Record condition exists for selected counties, this field will reflect the number of improvement records in the source file. | int |
| No. of Stories | Either the actual number of stories of the main structure (1, 1.5, 2, 2.5, etc.). NOTE: Other valid entries include any number followed by "+" (1+, 2+, 3+, etc., to indicate a fractional story less than 1/2) as well as attic/basement combinations such as “2+AB”. | varchar |
| Number of Units | Number of Units reported on the Assessment Roll. Primarily used for reporting of apartment buildings. | int |
| Other Impr Building Area 1 | Contains the measurements of their respective Buildings and Improvements described in Other Impr Bldg Ind 1-5 | varchar |
| Other Impr Building Area 2 | See description for Other_Impr_Building_Area_1 | varchar |
| Other Impr Building Area 3 | See description for Other_Impr_Building_Area_1 | varchar |
| Other Impr Building Area 4 | See description for Other_Impr_Building_Area_1 | varchar |
| Other Impr Building Area 5 | See description for Other_Impr_Building_Area_1 | varchar |
| Other Impr Building Indicator 1 | These fields are defined as buildings not attached to the main building/house and other improvements as designated including: Wood Deck, Patio Screened, Patio, Pool Size and Loading Platform. The size or measurement of these will be indicated in Other Impr Bldg Area 1-5 when provided by the county. | varchar |
| Other Impr Building Indicator 2 | These fields are defined as buildings not attached to the main building/house and other improvements as designated including: Wood Deck, Patio Screened, Patio, Pool Size and Loading Platform. The size or measurement of these will be indicated in Other Impr Bldg Area 1-5 when provided by the county. | varchar |
| Other Impr Building Indicator 3 | These fields are defined as buildings not attached to the main building/house and other improvements as designated including: Wood Deck, Patio Screened, Patio, Pool Size and Loading Platform. The size or measurement of these will be indicated in Other Impr Bldg Area 1-5 when provided by the county. | varchar |
| Other Impr Building Indicator 4 | These fields are defined as buildings not attached to the main building/house and other improvements as designated including: Wood Deck, Patio Screened, Patio, Pool Size and Loading Platform. The size or measurement of these will be indicated in Other Impr Bldg Area 1-5 when provided by the county. | varchar |
| Other Impr Building Indicator 5 | See description for Other_Impr_Building_Indicator_1 | varchar |
| Other Rooms | This field describes the rooms within the main building/house, if provided by the county. You can move up to five (5) codes per parcel. | varchar |
| Plumbing Fixtures Count | This is a numerical field identifying the number of plumbing features reported by the county assessor in the primary building/improvement on the property. | varchar |
| Pool | A Above-Ground Pool B Pool & Spa (both) C Community Pool or Spa E Enclosed G In-Ground Pool H Heated Pool I Indoor Swimming Pool L Solar Heated P Pool (yes) S Spa or Hot Tub (only) V Vinyl In-Ground Pool | varchar |
| Roof Cover | 1 Ceramic tile 2 Clay tile 3 Concrete tile 4 Copper 5 Tin A Asbestos B Built-Up C Composition Shingle D Concrete E Metal F Slate G Rock / Gravel H Tar & Gravel I Bermuda J Masonite/ Cement Shake K Fiberglass L Aluminum M Wood Shake/ Shingles O Other P Asphalt R Roll Composition S Steel T Tile U Urethane V Shingle (Not Wood) W Wood Y Gypsum Z Solar | varchar |
| Roof Type | The architectural style of the roof (gable, mansard, etc.). | varchar |
| Sewer | Contains codes representing the waste disposal/sewage system for the property. | varchar |
| Standardized Land Use Code | Land Use code standardized for all counties. See Separate Land Use Table. NOTE: Code “1999” based on the following criteria: 1. Land Use in the source file is generally indicated as residential. This may vary from county to county, i.e.: R = residential, Lots, etc. 2. Improvement value is greater than zero. 3. There is Homeowner’s exemption or the property is Owner Occupied. 4. If there is no land use designation, Bedroom and Bath fields are populated. | varchar |
| Style | 2 Traditional/Old 3 European 4 Mobile/Manufactured 5 Tiny House 6 Shotgun A A-Frame B Bungalow C Cape Cod D Colonial E English F French Provincial G Georgian H High-rise I Modern J Ranch\Rambler K Spanish L Tudor M Mediterranean N Conventional O Other P Prefab, Modular Q Mansion R Raised Ranch S Dome T Contemporary U Unfinished\Under Construction V Victorian W Cottage X Custom Y Log Cabin/Rustic Z Historical | varchar |
| Total Number of Rooms | Total Number of Rooms reported on the Assessment Roll | varchar |
| Type Construction | A Adobe B Brick C Concrete D Concrete Block E Dome F Frame H Heavy L Light M Log N Manufactured O Other P Masonry Q Metal R Steel S Stone T Tilt-Up (pre-cast concrete) W Wood X Mixed | varchar |
| Water | Contains codes representing the water system for the property. | varchar |
| Zoning | Actual City Zoning, unique to each incorporated area. If not available on the Assessment Roll, this field will be blank. | varchar |
| Record Creation Date | The date this record was created | varchar |
| School/Tax District 3 Indicator (see below for values) | A Water B Library C Conservation D Drainage E Medical (Hospital/Ambulance) F Fire H Historical L Special Services M Municipality N Sanitation P Public Improvement R Transportation S School T Tax U Utility W Waste Management X Miscellaneous | varchar |
| Assessed Value Improvement | The current assessed value of the improvements only (before exemptions, if any) as reported on the current county tax/assessment roll. Whenever separate fields are provided for additional improved values, this will be the total of all improvement values. Whole dollars only. | int |
| Assessed Value Land | The current assessed value of the land only (before exemptions, if any) as reported on the current county tax/assessment roll. Whole dollars only. | int |
| Assessed Value Total | The total current assessed value of both Land and Improvements (before exemptions, if any) as reported on the current county tax/assessment roll. Whole dollars only. | int |
| Assessment Year | The year for Asseessment. | varchar |
| California Homeowner's Exemption | Indicates whether (H)homeowner's Exemption is applicable. Not the same as Homestead - see Tax Exemption = "D". Blank for deed updates. | varchar |
| Tax Exemption Codes | Up to four (4) property tax exemptions. Format: XXXX (no delimiters) | varchar |
| Market Value: Improvement | When available from the county, the Market Improvement Value as determined by the Assessor. | int |
| Market Value: Land | When available from the county, the Market Land Value as determined by the Assessor. | int |
| Market Value: Total | When available from the county, the Total Market Value as determined by the Assessor. | int |
| Market Value: Year | The year the market values were established. Normally, this is a constant year for all records with a market value > zero, although there are cases where the county file contains the year each parcel was physically appraised and in such cases we move the Market Value year specific to each parcel resulting in several different values per county. | varchar |
| Tax Amount | Format: 9(9).99 | |
| Tax Year | varchar | |
| Tax Delinquent Year | varchar | |
| Tax Rate Code Area | Represents separate tax jurisdictions within the county as provided on the county tax/assessment roll. | varchar |
| Current Owner Name | Current Owner Name. 1. The Assessed owner(s) as of the lien date. Name displayed exactly as shown in the current Assessor's Roll or 2. Name of the grantee on the most recent recorded document. | varchar |
| Current Owner: Mail Care of Name | varchar | |
| Current Owner: Mail Street Address | varchar | |
| Current Owner: Mailing City | varchar | |
| Current Owner: Mailing State Or Province | varchar | |
| Current Owner: Mailing Postal Code | Five-digit postal zip code | varchar |
| Current Owner: Mailing Postal +4 Code | Four-digit extension to postal zip code. Not always available. | varchar |
| Current Owner: Unit Number | varchar | |
| Current Owner: Unit Type | Property Address Unit Designator. | varchar |
| Mail Care-Of Name Indicator | Indicates the predominate pattern of names for Mail Care-Of Name | varchar |
| Owner-Occupied (Residential) | B Probable owner-occupied property - no property address and mailing address within County. (Improved Residential) O Owner-occupied property (Non-Residential), no longer in use (refer to code Y or B). Code phased out 2017. Y Owner-occupied property (SFR/Condo) SFR and Condo properties only. | varchar |
| Owner1 FirstName | Parsed Owner Name 1 First Name | varchar |
| Owner1 MiddleName | Parsed Owner Name 1 Middle Name | varchar |
| Owner1 LastName | Parsed Owner Name 1 Last Name | varchar |
| Owner2 FirstName | Parsed Owner Name 2 First Name | varchar |
| Owner2 MiddleName | Parsed Owner Name 2 Middle Name | varchar |
| Owner2 LastName | Parsed Owner Name 2 Last Name | varchar |
| Legal: Assessor's Map Ref | The map number assigned by the County Assessor; may or may not be the same as either the APN or legal map references. | varchar |
| Legal: Brief Description | The narrative legal description of the property, exactly as given in the Assessor Source Files | varchar |
| Legal: Brief Description - FULL | Compilation of all legal description components | varchar |
| Legal: Section/Township/ Range/Meridian | Format: SEC 99 TWN 99A RNG 99A Where "A" = Directional (N/S for TWN and E/W for RNG) | varchar |
| Legal: Block | The block of the subdivision or city in which the property is located | varchar |
| Legal: Lot Number | The individual lot(s) which comprise the property. The actual lot number(s) such as in a tract or subdivision. If more than one, as many multiple lot numbers as allowed by the field length are entered, separated with a comma (,) or ampersand (&). A hyphen is used to indicate a range (-). Refer to Lot Code. | varchar |
| Legal: City, Township, Municipality | The jurisdiction in which the property is located. May be “Unincorporated”, if applicable. Often a description of the code provided in Legal: District | varchar |
| Legal: District | The district in which the property is located. Usually a numeric code corresponding to the literal name in Legal: City, Municipality, Township | varchar |
| Legal: Section | The section of the city in which the property is located. Not the same as the “Section” of a Township-Range. See Legal: Sec/Twn/Rng/Mer | varchar |
| Legal: Land Lot | A large portion or tract of land (which may also encompass many individual blocks or lots) in which the property is located | varchar |
| Legal: Lot Code | Identifies properties which include more than one lot or partial lots. | varchar |
| Legal: Phase Number | Generally, the phase number of the subdivision or tract development | varchar |
| Legal: Subdivision Name | The name of the subdivision, plat, or tract in which the property is located | varchar |
| Legal: Tract Number | The number of the tract in which the property is located | varchar |
| Legal: Unit | The subdivision unit number. Common for condominiums, townhomes, etc. Not necessarily the same as the Property Unit Number | varchar |
| Record Creation Date | The date this record was created | varchar |
| Version | varchar | |
| Lot Size - Depth Feet | This field provides the depth measurement of the property when provided by the county assessor. | varchar |
| Lot Size - Frontage Feet | This field provides the frontage measurement of the property when provided by the county assessor. | varchar |
| Lot Size/Area Unit | The total square footage of the land. | varchar |
| Original Lot Size or Area | Indicates the unit of measurement for the Lot Size or Area. | varchar |
| Lot Size - Square Feet | This field contains the total area measurement of the land in square feet. If the lot size is provided by the county assessor in acres, this field will be show the conversion to square feet. | varchar |
| Lot Size - Acres | This field contains the total area measurement of the land in acres. If the lot size is provided by the county assessor in square feet, this field will contain a conversion of square feet to acres. | varchar |
| Lot Size or Area | The toal square footage of the land. | varchar |
| Hashvalue | Record hash value, updated hashvalue indicates if the record changed | varchar |
| ModificationTimestamp | When the record was updated | DateTime |
| RecordId | Unique identifier for Assessor record only | varchar |