Data Layout#

Introduction#

Property and Mortgage data for Insight and Analytics. Add Property and Mortgage Data to Your Records for Data-Driven Insight and Analytics. Our custom property data solutions give you fresh, accurate real estate and property data on more than 140 million U.S. properties including parcel and building information, calculated value, deed information and history, and more. Along with comprehensive information on the property, you also get detailed information on the homeowner and all other properties that owner has ever owned.

When you add more than 400 fields of detailed property data to your in-house records, you’ll gain the competitive edge and capitalize on market opportunities. The Property API is ideal for lenders, real estate professionals, investors and insurance agents.

Property Data#

Sample File#

Click here to download the sample file.

Layout and Definitions#

Grouping

Column Name

Type

Definition

Primary Owner

Owner1FullName

varchar(255)

Owner 1 Full Name

Owner1FirstName

varchar(166)

Owner 1 First Name

Owner1MiddleName

varchar(166)

Owner 1 Middle Name

Owner1LastName

varchar(166)

Owner 1 Last Name

Owner1NameSuffix

varchar(50)

Owner 1 Name Suffix

Owner2FullName

varchar(255)

Owner 2 Full Name

Owner2FirstName

varchar(166)

Owner 2 First Name

Owner2MiddleName

varchar(166)

Owner 2 Middle Name

Owner2LastName

varchar(166)

Owner 2 Last Name

Owner2NameSuffix

varchar(50)

Owner 2 Name Suffix

PropertyAddress

PropertyMelissaAddressKey

bigint

10-digit unique key assigned to each address.

PropertyBaseMelissaAddressKey

bigint

Displays the parent Melissa Address Key of an address if it is a part of or within a building. Ex. Apartment

PropertyAddressLine

varchar(150)

Address line

PropertySuite

varchar(50)

Suite

PropertyCity

varchar(100)

City

PropertyState

varchar(2)

State

PropertyZIPCode

varchar(5)

ZIP Code

PropertyPlus4

varchar(4)

Plus4

PropertyDeliveryPoint

varchar(2)

A specific location where mail is delivered to an individual or entity. It is a precise point of delivery for a particular address.

PropertyAddressKey

varchar(11)

Address key is a combination of a location’s ZIPCode + Plus4 + DeliveryPoint

PropertyAddressStreetNumber

varchar(50)

Address street number. Ex. ‘6450’

PropertyAddressDirectionPrefix

varchar(10)

Address directional prefix. Ex. ‘e’

PropertyAddressStreetName

varchar(100)

Street name. Ex. ‘Side’

PropertyAddressStreetSuffix

varchar(10)

Suffix of address. Ex. ‘Dr’

PropertyAddressDirectionSuffix

varchar(10)

Address directional suffix. Ex. ‘Ne’

PropertyAddressSuiteName

varchar(50)

Suite. Ex. ‘Apt’

PropertyAddressSuiteNumber

varchar(50)

Suite number. Ex. ‘Q’

PropertyRBDI

varchar(1)

Business/residential indication

PropertyCarrierRoute

varchar(4)

The carrier route for the location address as assigned by the USPS.

PropertyFIPSCode

varchar(5)

The FIPSCode indicates the location of the address at both the state and county level.

PropertyAddressType

varchar(1)

Address type

PropertyResultCodes

varchar(100)

Melissa result codes

PropertyGeo

PropertyCensusKey

varchar(16)

Census key is a 15 or 16-character key combination of the state FIPS code + county FIPS code + tract number + block number + block suffix. The Census key was created by the US Government to correctly identify, classify, and pull statistical data from areas across the United States.

PropertyLatitude

decimal(18,6)

The latitude in decimal degrees using the WGS84 datum for the address

PropertyLongitude

decimal(18,6)

The longitude in decimal degrees using the WGS84 datum for the address

Parcel

UDParcelNumberRaw

varchar(45)

Undecorated Assessor’s Parcel Number or Parcel Identification Number.

ParcelNumberRaw

varchar(45)

Assessor’s Parcel Number or Parcel Identification Number.

ParcelNumberYearAdded

int

The year that the current Parcel Number was created by the Assessor.

ParcelNumberAlternate

varchar(60)

In addition to the primary parcel number, an alternate property identifier.

ParcelAccountNumber

varchar(30)

When provided in the assessment files, an arbitrary parcel identifier usually assigned by the County Treasurer for tax purposes.

Tax

TaxYearAssessed

varchar(4)

Relates to the current lien date for which the values contained in (Assessed Land Value, Assessed Improvement Value and Total Assessed Value) were established. If a fiscal year (Mar’95 - Feb’96), this is the beginning year (i.e. 1995).

TaxAssessedValueTotal

int

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.

TaxAssessedValueImprovements

int

The current assessed value of the improvements only (before exemptions) 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.

TaxAssessedValueLand

int

The current assessed value of the land only (before exemptions) as reported on the current county tax/assessment roll.

TaxMarketValueYear

varchar(4)

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.

TaxMarketValueTotal

int

When available from the county, the Total Market Value as determined by the Assessor. See also Total Assessed Value

TaxMarketValueImprovements

int

When available from the county, the Market Improvement Value as determined by the Assessor. See also Assessed Improvement Value

TaxMarketValueLand

int

When available from the county, the Market Land Value as determined by the Assessor. See also Assessed Land Value

TaxFiscalYear

varchar(4)

This is the year in which the amount shown in Tax Amount was levied.

TaxRateArea

varchar(18)

Represents separate tax jurisdictions within the county as provided on the county tax/assessment roll.

TaxBilledAmount

decimal(11,2)

This field contains the amount of tax on the property expressed in dollars and cents

TaxDelinquentYear

varchar(4)

This is the year in which the property tax became delinquent (unpaid).

PropertyEstimatedValue

int

Property estimated value

CurrentDeed

Mortgage1Amount

int

Mortgage (purchase money) recorded concurrently with the conveying instrument.

Mortgage1InterestRate

decimal(10,2)

When available, initial rate as given on the trust deed or rider.

Mortgage1InterestRateType

varchar(1)

When available will indicate the type of interest rate terms for the concurrent TD

Mortgage1LenderInfoSellerCarryBackInd

bit

Indicating if a lender is a seller

Mortgage1LenderNameFullStandardized

varchar(40)

Name of the beneficiary to the first trust deed (mortgage).

Mortgage1RecordingDate

date

The official date of the document recordation.

Mortgage1Type

varchar(3)

Indicates the type of loan, if able to determine from the recorded document. See Code Description table.

Mortgage2Amount

int

Loan amount of second trust deed concurrent (subject to) to the original (1st) loan.

Mortgage2InterestRate

varchar(1)

When available, initial rate as given on the trust deed or rider.

Mortgage2InterestRateType

varchar(1)

When available will indicate the type of interest rate terms for the concurrent TD

Mortgage2LenderInfoSellerCarryBackInd

varchar(1)

Indicator for lender type

Mortgage2LenderNameFullStandardized

varchar(1)

Name of the beneficiary to the first trust deed (mortgage).

Mortgage2RecordingDate

date

The official date of the document recordation.

Mortgage2Type

varchar(1)

Indicates the type of loan, if able to determine from the recorded document. See Code Description table.

SaleInfo

AssessorLastSaleAmount

int

Whole dollars only without commas (,) and NO Cents

AssessorLastSaleDate

date

Recording Date of the latest sale in the transaction history.

VestingTypeCode

varchar(3)

When available, either identifies how the Assessee took title (vesting) OR describes the type of entity (ID) based on conversion. See Code Description table.

TrustDescription

varchar(50)

identifies whether the ownership type is a trust or not.

CompanyInd

varchar(1)

Indicating the property is company owned

PropertyUseInfo

YearBuilt

varchar(4)

Year the primary structure on the property was built

EffectiveYearBuilt

varchar(4)

The date that reflects the condition of an improvement. It is the same or later than Year Built.

PropertyUseStandardized

varchar(3)

Land Use code standardized for all counties. See Separate Land Use Table.

ExteriorAmendities

AreaBuilding

int

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.

AreaLotAcres

decimal(18,7)

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.

AreaLotSF

int

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.

Pool

varchar(3)

Indicates if a pool exists on the property and any additional information about the pool.

Foundation

varchar(3)

Indicates the type of foundation for the primary structure on the property.

Construction

varchar(2)

Indicates the material used in the construction of the framework for the primary structure on the property.

RoofConstruction

varchar(3)

Indicates the primary roof framing structure (A-Frame, Gable, Mansard, etc.).

ContentOverheadDoorInd

bit

Indicates the existence of an Overhead Door.

ViewDescription

varchar(3)

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.

PorchCode

varchar(3)

This indicates if a proch is present, and if so, potentially what type of porch.

PorchArea

int

The total square footage of the porch(s) on the property .

PatioArea

int

The square footage of the patio(s) for all structures on a property.

DeckInd

bit

Code indicating the presence of a deck on the property. It, alternatively, can also indicate if the deck is covered.

DeckArea

int

If a deck is present, this details the size of the deck in square feet.

InteriorAmendities

RoomsBasementArea

int

The total area of the basement, in square feet.

InteriorStructure

varchar(3)

This field contains a code reflecting the composition of the interior walls

BathCount

decimal(5,2)

Physical count of all bathrooms (including 1/2 baths). See Code Description table. Input Format: 99v99 (implied decimal)

BedroomsCount

int

Actual count of bedrooms (with closet). Residential only.

UnitsCount

int

Number of Units reported on the Assessment Roll. Primarily used for reporting of apartment buildings.

FireplaceInd

bit

Indicating the presence of fireplace

ContentStormShutterInd

bit

Indicates the presence of Storm Shutters on the main structure.

HVACCoolingDetail

varchar(3)

Indicates the method or system used to provide cooling.

HVACHeatingDetail

varchar(3)

Indicates the method or system used to provide heat.

Foreclosure

ForeclosureLenderNameFullStandardized

varchar(40)

Name of the beneficiary to the first trust deed (mortgage).

ForeclosureLenderAddressLine

varchar(100)

Lender Address

ForeclosureLenderAddressCity

varchar(50)

Lender Address City

ForeclosureLenderAddressState

varchar(2)

Lender Address State

ForeclosureLenderAddressZIPCode

varchar(10)

Lender Address ZIP Code

ForeclosureLenderAddressStreetNumber

varchar(25)

Address street number. Ex. ‘6450’

ForeclosureLenderAddressDirectionPrefix

varchar(10)

Address directional prefix. Ex. ‘e’

ForeclosureLenderAddressStreetName

varchar(100)

Street name. Ex. ‘Side’

ForeclosureLenderAddressStreetSuffix

varchar(10)

Suffix of address. Ex. ‘Dr’

ForeclosureLenderAddressDirectionSuffix

varchar(25)

Address directional suffix. Ex. ‘Ne’

ForeclosureLenderAddressSuiteNumber

varchar(25)

Suite number. Ex. ‘Q’

ForeclosureLenderPhone

varchar(15)

Lender Phone Number

ForeclosureLenderPhoneDNCInd

bit

Do not call Flag for Foreclosure_LenderPhone

ForeclosureInstrumentNumber

varchar(20)

Sequential number assigned to documents at the time of recording for identification and to establish the order of recordation as listed on the county/tax assessment roll.

ForeclosureRecordingDate

date

Recording Date for most recent sale as listed on the county tax/assessment roll, if available. The date the property sold to the current ownership.Format provides four positions for the year: YYYYMMDD

ForeclosureRecordedAuctionOpeningBid

varchar(11)

The minimum bid amount as reported on the Notice of Sale or reflects the total amount due on the loan.

ForeclosureAuctionDate

date

The scheduled Auction Date as reported on the Notice of Sale.

ForeclosureAuctionTime

varchar(5)

The scheduled Auction Time as reported on the Notice of Sale.

ForeclosureAuctionAddress

varchar(60)

The Street Address where the auction is scheduled to take place, usually reported on the Notice of Sale

ForeclosureAuctionCity

varchar(40)

The City where the auction is scheduled to take place as reported on the Notice of Sale

ForeclosureServicerAddress

varchar(60)

Full Street Address, City, State, ZIP Code and Plus4

ForeclosureServicerPhoneNumber

varchar(25)

Foreclosure Servicer Phone Number

ForeclosureServicerPhoneDNCInd

bit

Do not call Flat for Foreclosure Servicer Phone Number

ForeclosureTrusteeReferenceNumber

varchar(15)

Number assigned by the Trustee for the purpose of tracking the foreclosure for the given property.

ForeclosureTrusteeName

varchar(40)

Trustee First Name & Middle Name. Note: In Colorado, the Trustee fields will be blank since Colorado uses a Public Trustee

ForeclosureTrusteeAddress

varchar(60)

Trustee Full Street Address , City, State, Zip Code, Plus4

ForeclosureTrusteeAddressCity

varchar(30)

Trustee City

ForeclosureTrusteeAddressState

varchar(2)

Trustee State

ForeclosureTrusteeAddressZIPCode

varchar(5)

Trustee ZIP Code

ForeclosureTrusteePhone

varchar(12)

Trustee Phone Number

ForeclosureTrusteePhoneDNCInd

bit

Do not call Flag for Foreclosure_TrusteePhone

ForeclosureJudgmentAmount

int

Whole dollars. Unpaid principal amount of the loan as stated on the foreclosure document.

ForeclosureBorrowerNameOwner

varchar(40)

#1 - Trustor/Borrower First Name & Middle

ForeclosureOriginalLoanAmount

int

Loan amount of the original loan in default. Whole dollars only.

ForeclosureRecordType

varchar(3)

Unique 2 position document type field that identifies the foreclosure record type. Refer to Foreclosure Doc Type by State tab for complete list.

ForeclosureDefaultAmount

int

Amount that is past due on the loan. First priority is to key the Total Delinquency Amount, if this is not available, then enter the Installment Payment Amount.

ForeclosureRecordLastUpdated

date

The official date of recordation for the foreclosure document.

MailingAddress

MailingMelissaAddressKey

bigint

10-digit unique key assigned to each address.

MailingBaseMelissaAddressKey

bigint

Displays the parent Melissa Address Key of an address if it is a part of or within a building. Ex. Apartment

MailingAddressLine

varchar(150)

Address line

MailingSuite

varchar(50)

Suite

MailingCity

varchar(100)

Mailing city

MailingState

varchar(2)

State

MailingZIPCode

varchar(5)

ZIP Code

MailingPlus4

varchar(4)

Plus4

MailingDeliveryPoint

varchar(2)

A specific location where mail is delivered to an individual or entity. It is a precise point of delivery for a particular address.

MailingResultCodes

varchar(100)

Melissa result codes

MailingAddressStreetNumber

varchar(50)

Address street number. Ex. ‘6450’

MailingAddressDirectionPrefix

varchar(20)

Address directional prefix. Ex. ‘e’

MailingAddressStreetName

varchar(100)

Street name. Ex. ‘Side’

MailingAddressStreetSuffix

varchar(20)

Suffix of address. Ex. ‘Dr’

MailingAddressDirectionSuffix

varchar(20)

Address directional suffix. Ex. ‘Ne’

MailingAddressSuiteName

varchar(50)

Suite. Ex. ‘Apt’

MailingAddressSuiteNumber

varchar(50)

Suite number. Ex. ‘Q’

MailingRBDI

varchar(1)

Business/residential indication

MailingCarrierRoute

varchar(4)

The carrier route for the location address assigned by the USPS.

MailingFIPSCode

varchar(5)

The FIPSCode indicates the location of the address at both the state and county level.

MailingAddressType

varchar(1)

Address type

MailingAddressGeo

MailingCensusKey

varchar(16)

Census key is a 15 or 16-character key combination of the state FIPS code + county FIPS code + tract number + block number + block suffix. The Census key was created by the US Government to correctly identify, classify, and pull statistical data from areas across the United States.

PlaceCode

varchar(5)

Place Codes, Place as defined by the US Census Bureau. Supplemental geographical definition provided to assist with data analysis.

Phone

FullPhoneNumber

varchar(10)

Full phone number

FullPhoneNumber_DNCInd

bit

Do not call Flag for Phone

CellPhoneNumber

varchar(10)

Cell phone number

Email

CellPhoneNumber_DNCInd

bit

Do not call Flag for Cell Phone

Email

varchar(450)

Email

EmailResultLevel

int

EmailResultLevel

Code and Definitions#

Column Name

Code

Definition

Mortgage1InterestRateType

1

Adjustable Rate

0

Unknown

2

Fixed Rate

PropertyRBDI

B

Business

P

P.O. Box

R

Residential

U

Unknown

PropertyAddressType

A

Alias

F

Firm or Company Address

G

General Delivery Address

H

High Rise or Business Complex

P

P.O. Box Address

R

Rural Route Address

S

Street or Residential Address

U

Unique

Z

Unique

Mortgage1Type

126

Stand Alone First

128

Stand Alone Second

123

Arm (Adjustable Rate Mortgage)

0

Unknown

101

USDA - US Department of Agriculture Loan

124

Closed End Mortgage

133

Small Business Association

121

Assumption

3

Building or Construction

134

Cash

130

Second Mortgage To Cover Down Payment

6

Line of Credit

8

FHA

122

Balloon

102

Farmers Home Administration

135

Negative Amortization

131

Land Contract (Arrangement Of Sale)

132

Loan Modification

10

Conventional

103

Commercial

127

Stand Alone Refinance

125

Seller Take-Back

16

Veterans Administration Loan

105

Reverse Mortgage

Mortgage2InterestRateType

1

Adjustable Rate

0

Unknown

2

Fixed Rate

Mortgage2Type

126

Stand Alone First

128

Stand Alone Second

123

Arm (Adjustable Rate Mortgage)

0

Unknown

101

USDA - US Department of Agriculture Loan

124

Closed End Mortgage

133

Small Business Association

121

Assumption

3

Building or Construction

134

Cash

130

Second Mortgage To Cover Down Payment

6

Line of Credit

8

FHA

122

Balloon

102

Farmers Home Administration

135

Negative Amortization

131

Land Contract (Arrangement Of Sale)

132

Loan Modification

10

Conventional

103

Commercial

127

Stand Alone Refinance

125

Seller Take-Back

16

Veterans Administration Loan

105

Reverse Mortgage

VestingTypeCode

174

Also Known As (a/k/a)

103

Company

149

Community Property

227

Contract Owner

175

Doing Business As (dba)

216

Domestic Partner

218

Et Al (and Others) - Vendor Data Only

150

Estate

219

Et Ux (and Wife) - Vendor Data Only

151

Executor

178

Formerly Known As (f/k/a)

220

Family Living Trust

221

Family Trust

222

Family Revocable Trust

179

Government

223

Her Husband

109

Husband And Wife

204

Irrevocable Living Trust

203

Irrevocable Trust

153

Joint Tenant/joint Tenant W/ Right Of Survivorship

205

Joint Tenants

154

Joint Venture

156

Life Estate

182

Life Tenant (holds A Life Estate Interest Only)

159

Living Trust

183

Minor, Ward Or Client (represented By Trustee)

206

Married Man As His Sole And Separate Property

207

Married Woman As Her Sole & Separate Property

208

Partnership

189

Revocable Living Trust

164

Right Of Survivorship

165

Revocable Trust

125

Single Man

167

Sole Owner

127

Single Woman

169

Tenants In Common

209

Transfer Of Death

171

Tenant By Entirety

210

Tenant

211

Trustee/conservator

129

Trustee

215

Tax Payer

195

Widow Or Widower

TrustDescription

Not Available

Name is a Trust

Name is a Trust

CompanyInd

Not Available

N

N

Y

Y

PropertyUseStandardized

315

Miscellaneous (General)

246

Pipeline Or Right-of-way

248

Rail (Right-Of-Way & Track)

249

Road (Right-Of-Way)

255

Utilities (Right-Of-Way Only)

252

Sub-surface Rights (Mineral)

253

Surface Rights (Grazing, Timber, Coal, Etc.)

438

Leasehold Rights (Misc.)

431

Possessory Interest (Misc.)

456

Petroleum & Gas Wells (Misc.)

435

Water Rights (Misc.)

251

Right-of-way (Not Rail, Road Or Utility)

465

Easement (Misc.)

440

Homestead (Misc.)

407

Common Area (Misc.)

250

Royalty Interest

257

Working Interest

463

Parcels With Improvements, Use Not Specified

411

Personal Property (General)

441

Vehicles (General)

420

Motor Vehicles (Cars, Trucks, Etc.)

460

Recreational Vehicles / Travel Trailers

432

Watercraft (Ships, Boats, Pwcs, Etc.)

415

Aircraft

434

Rolling Stock (Railroad)

427

Spacecraft

444

Misc Vehicles Not Otherwise Classed (Antiques, Etc.)

445

Business Personal Property (General)

455

Equipment / Supplies

419

Inventory

425

Goods In Transit

466

Livestock (Animals, Fish, Birds, Etc.)

413

Crops (In Ground)

446

Crops (Harvested)

439

Misc. Business Personal Property Not Otherwise Classed

414

Structures (General)

429

Structures On Leased Land

408

Temporary Structures

422

Misc Structures Not Otherwise Classed (Billboards, Etc.)

437

Intangible Personal Property

436

Misc Personal Property Not Otherwise Classed

181

Single Family Residential

385

Single Family Residential

386

Townhouse

364

Cluster Home

366

Condominium

367

Cooperative

373

Mobile Home

382

Row House

118

Agricultural/rural (General)

377

Planned Unit Development (PUD)

365

Common Area (Residential)

387

Timeshare

384

Seasonal, Cabin, Vacation Residence

363

Bungalow (Residential)

390

Zero Lot Line (Residential)

375

Miscellaneous (Residential)

371

Manufactured, Modular, Pre-fabricated Homes

376

Patio Home

452

Garden Home

416

Landominium

423

Barndominium

447

Tiny House

381

Residential Income (General/Multi-Family)

369

Duplex (2 Units, Any Combination)

388

Triplex (3 Units, Any Combination)

378

Quadplex (4 Units, Any Combination)

361

Apartment House (5+ Units)

359

Apartment House (100+ Units)

357

Garden Apt, Court Apt (5+ Units)

358

High-rise Apartments

362

Boarding/rooming House, Apt Hotel

162

Mobile Home Park, Trailer Park

372

Multi-family Dwellings (Generic, Any Combination)

370

Fraternity House, Sorority House

360

Apartments (Generic)

368

Dormitory, Group Quarters (Residential)

379

Condominium Development (Association Assessment)

421

Condominium Building (Residential)

461

Cooperative Building (Residential)

418

Residential Parking Garage

448

Residential Storage Space

135

Commercial (General)

178

Retail Stores (Personal Services, Photography, Travel)

143

Department Store (Multi-Story)

140

Store/office (Mixed Use)

141

Department Store (Apparel, Household Goods, Furniture)

151

Grocery, Supermarket

179

Regional: Shopping Center, Mall (w/Anchor)

183

Community: Shopping Center, Mini-mall

167

Neighborhood: Shopping Center, Strip Center, Enterprise Zone

182

Shopping Center Common Area (Parking Etc)

192

Veterinary, Animal Hospital

148

Restaurant

146

Drive-thru Restaurant, Fast Food

189

Take-out Restaurant (Food Preparation)

128

Bakery

129

Bar, Tavern

158

Liquor Store

124

Convenience Store (7-11)

137

Convenience Store (w/Fuel Pump)

186

Service Station (Full Service)

185

Service Station w/Convenience Store (Food Mart)

190

Truck Stop (Fuel And Diner)

127

Vehicle Sales, Vehicle Rentals (Auto/Truck/RV/Boat/etc)

126

Auto Repair, Garage

193

Car Wash

147

Dry Cleaner

191

Service Shop (TV, Radio, Electric, Plumbing)

168

Nursery, Greenhouse, Florist (Retail, Wholesale)

194

Wholesale Outlet, Discount Store (Franchise)

173

Printer - Retail (Pip, Qwikcopy, etc.)

229

Mini-warehouse, Storage

175

Day Care, Pre-School (Commercial)

163

Motel

155

Hotel

172

Parking Garage, Parking Structure

174

Parking Lot

133

Cemetery, Funeral Home, Mortuary (Commercial)

132

Casino

154

Hotel-Resort

153

Hotel/motel

180

Gas Station

130

Commercial Building, Mail Order, Show Room (Non-Auto), Warehouse

171

Commercial Office/residential (Mixed Use)

125

Appliance Store (Bix Box Appliance)

156

Kennel

157

Laundromat (Self-Service)

166

Nightclub (Cocktail Lounge)

149

Farm Supply & Equipment (Commercial)

144

Garden Center, Home Improvement (Do-It-Yourself)

138

Commercial Condominium (Not Offices)

145

Drug Store, Pharmacy

131

Bed & Breakfast

464

Barber/Hair Salon

412

Pet Boarding & Grooming

449

Roadside Market

458

Car Wash - Automated

433

Car Wash - Self-Serve

459

Cannabis Dispensary

136

Commercial Office (General)

177

Professional Building (Legal, Insurance, Real Estate, Business)

176

Professional Building (Multi-Story)

169

Office Building

170

Office Building (Multi-Story)

142

Dental Building

160

Medical Building

150

Financial Building

139

Condominium Offices

184

Skyscraper/high-rise (Commercial Offices)

161

Mixed Use (Commercial/Industrial)

134

Common Area (Commercial, Not Shopping Center)

159

Mobile Commercial Units

334

Recreational/Entertainment (General)

332

Recreational Center

326

Public Swimming Pool

311

Marina, Boat Slips, Yacht Club, Boat Landing

264

Bowling Alley

259

Arcades (Amusement)

343

Skating Rink, Ice Skating, Roller Skating

270

Clubs, Lodges, Professional Associations

316

Museum, Library, Art Gallery (Recreational)

267

Country Club

346

Stadium

260

Arena, Convention Center

261

Auditorium

290

Driving Range (Golf)

350

Race Track (Auto, Dog, Horse)

296

Gym, Health Spa

279

Dance Hall

337

Riding Stable, Trails

273

Campground, RV Park

285

Fairgrounds

348

Theater (Movie)

281

Drive-in Theater

327

Amusement Park, Tourist Attraction

323

Piers, Wharf (Recreation)

287

Fish Camps, Game Club Target Shooting

262

Outdoor Recreation: Beach, Mountain, Desert

263

Pool Hall, Billiard Parlor

322

Park, Playground, Picnic Area

293

Golf Course

331

Racquet Court, Tennis Court

355

Zoo

292

Go-carts, Miniature Gold, Water Slides

410

Sports Complex

212

Industrial (General)

220

Manufacturing (Light)

215

Light Industrial (10% Improved Office Space; Machine Shop)

238

Warehouse, Storage

236

Storage Yard, Open Storage (Light Equipment, Material)

208

Food Packing, Packing Plant (Fruit, Vegetable, Meat, Dairy)

195

Assembly (Light Industrial)

206

Food Processing

232

Recycling (Metal, Paper, Glass)

272

Communications

201

Condominiums (Industrial)

231

R&d Facility, Laboratory, Research Facility, Cosmetics, Pharmaceutical

213

Industrial Park

224

Multi-tenant Industrial Building

219

Marine Facility/board Repairs (Small Craft, Sailboat)

218

Lumber & Wood Product Mfg (Including Furniture)

225

Paper Product Mfg & Related Products

227

Printing & Publishing (Light Industrial)

216

Industrial Loft Building, Loft Building

198

Construction/contracting Services (Industrial)

200

Common Area (Industrial)

210

Heavy Industrial (General)

291

Transportation (General)

280

Distribution Warehouse (Regional)

222

Mining, Mineral, Quarries

235

Storage Yard (Junk, Auto Wrecking, Salvage)

203

Distillery, Brewery, Bottling

226

Refinery, Petroleum Products

221

Mill (Feed, Grain, Paper, Lumber, Textile, Pulp)

205

Factory (Apparel, Textile, Leather, Medium Mfg)

228

Processing Plant (Minerals, Cement, Rock, Gravel, Glass, Clay)

217

Lumberyard, Building Materials

233

Shipyard - Built Or Repaired (Seagoing Vessels)

234

Slaughter House, Stockyard

240

Waste Disposal, Sewage (Processing, Disposal, Storage, Treatment)

230

Quarries (Sand, Gravel, Rock)

211

Heavy Manufacturing

214

Labor Camps (Industrial)

239

Winery

199

Chemical

207

Foundry, Industrial Plant (Metal, Rubber, Plastic)

197

Cannery

196

Bulk Storage, Tanks (Gasoline, Fuel, Etc)

209

Grain Elevator

204

Dump Site

202

Cold Storage

237

Sugar Refinery

258

Airport & Related

330

Railroad & Related

289

Freeways, State Hwys

338

Roads, Streets, Bridges

265

Bus Terminal

347

Telegraph, Telephone

340

Radio Or TV Station

351

Truck Terminal (Motor Freight)

276

Cable TV Station

300

Harbor & Marine Transportation

313

Microwave

266

Commercial Auto Transportation/Storage

324

Pollution Control

451

Cellular

105

Farm (Irrigated Or Dry)

114

Ranch

117

Range Land (Grazing)

103

Farm, Crops

110

Orchard (Fruit, Nut)

121

Vineyard

113

Poultry Farm (Chicken, Turkey, Fish, Bees, Rabbits)

101

Dairy Farm

120

Timberland, Forest, Trees

123

Wildlife (Refuge)

102

Desert Or Barren Land

112

Pasture

109

Miscellaneous Structures - Ranch, Farm Fixtures

111

Orchards, Groves

104

Feedlots

108

Livestock, Animals

106

Horticulture, Ornamental (Agricultural)

122

Well Site (Agricultural)

119

Truck Crops

115

Reservoir, Water Supply

107

Irrigation, Flood Control

317

Natural Resources

116

Rural Improved / Non-residential

450

Cannabis Grow Facility

389

Vacant Land

401

Residential - Vacant Land

393

Vacant Commercial

395

Industrial - Vacant Land

399

Private Preserve, Open Space - Vacant Land

396

Institutional - Vacant Land

394

Government - Vacant Land

398

Multi-family - Vacant Land

392

Agricultural (Unimproved) - Vacant Land

404

Waste Land, Marsh, Swamp, Submerged - Vacant Land

400

Recreational - Vacant Land

406

Water Area (Lakes, River, Shore) - Vacant Land

403

Unusable Land (Remnant, Steep, Etc.)

391

Abandoned Site, Contaminated Site

402

Under Construction

453

Vacant Land - Destroyed/Uninhabitable Improvement

462

Vacant Land - Unspecified Improvement

409

Vacant Land - Exempt

345

Special Purpose

333

Regulating Districts & Assessments; Tax Abatement

335

Redevelopment Agency Or Zone

268

Centrally Assessed

284

Exempt (Full Or Partial)

309

Indian Lands

310

Institutional (General)

336

Religious, Church, Worship (Synagogue, Temple, Parsonage)

328

Parochial School, Private School

274

College, University, Vocational School - Private

152

Hospital - Private

312

Medical Clinic

339

Homes (Retired, Handicap, Rest, Convalescent, Nursing)

320

Children’s Home, Orphanage

282

Cemetery (Exempt)

275

Crematorium, Mortuary (Exempt)

269

Charitable Organization, Fraternal

318

Recreational Non-taxable (Camps, Boy Scouts)

353

Private Utility (Electric, Water, Gas, Etc.)

294

Governmental / Public Use (General)

314

Military (Office, Base, Post, Port, Reserve, Weapon Range, Test Sites)

288

Forest (Park, Reserve, Recreation, Conservation)

342

Public School (Administration, Campus, Dorms, Instruction)

352

Colleges, University - Public

325

Post Office

298

Cultural, Historical (Monuments, Homes, Museums, Other)

295

Govt. Administrative Office (Federal, State, Local, Court House)

283

Emergency (Police, Fire, Rescue, Shelters, Animal Shelter)

356

Other Exempt Property

277

City, Municipal, Town, Village Owned (Exempt)

278

County Owned (Exempt)

344

State Owned (Exempt)

286

Federal Property (Exempt)

321

Public Health Care Facility (Exempt)

271

Community Center (Exempt)

329

Public Utility (Electric, Water, Gas, Etc.)

354

Welfare, Social Service, Low Income Housing (Exempt)

319

Correctional Facility, Jails, Prisons, Insane Asylum

302

Hospital - Public

304

Historical - Private (General)

306

Historical Residence

307

Historical Retail

308

Historical Warehouse

301

Historical Office

299

Historical Transient Lodging (Hotel, Motel)

305

Historical Recreation, Entertainment

303

Historical Park, Site, Misc.

297

Historical District

Pool

110

Above-ground Pool

502

Pool w/Hot Tub/Spa

101

Public/Municipal/Commercial

610

Pool (Unspecified), Enclosed

121

In-ground Vinyl Pool

401

Pool (Unspecified), Heated

130

Indoor Pool

402

Pool, Solar Heated

999

Type Unspecified

904

Spa/Hot Tub (only)

Foundation

Null

Null

501

Raised (Unspecified)

999

Type Not Specified

922

Masonry (Unspecified)

921

Stone (Unspecified)

924

Brick (Unspecified)

923

Block (Unspecified)

300

Pile

400

Pier/Post & Beam

930

Retaining Wall

100

Mat/Raft Foundation (Slab)

200

FOOTING

920

Wood (Unspecified)

Construction

Null

Null

31

Brick

23

Concrete

28

Concrete Blocks

50

Arched/Dome

2

Frame

8

Heavy Frame

7

Light Frame

42

Log

43

Manufactured

1

Type Not Specified

25

Masonry/Concrete Masonry Units (CMUs)

19

Metal Frame

20

Steel Frame

38

Stone

46

Tilt-Up Concrete

10

Wood

99

Mixed

RoofConstruction

Null

Null

251

Gable

313

Bowstring Truss

329

Reinforced Concrete

345

Geodesic/Dome

312

Steel Frm/truss

197

Flat

253

Gable/Hip

258

Hip

283

Cathedral/Clerestory

289

Gambrel

265

Mansard

320

Prestress Concrete

311

Rigid Frm Bar Jt

274

Shed

282

Sawtooth

318

Wood Truss

ViewDescription

Null

Null

A

Freeway Proximity

B

Waterfront-Beach (Ocean, River, or Lake)

C

Contamination Site

D

Cul-de-sac

E

Corner

VPR

Poor

VAV

Average

H

Historical

I

School Proximity

VGC

Golf Course

0

None

VLA

Lake

VMN

Mountain

VCA

Canal

VOC

Ocean

P

Proximity To Airport

VGP

Greenbelt/Park

R

Proximity To Railroad

S

Major Street/Thoroughfare

T

High Traffic Area

VRR

River

None

Z

Flood Plain/Flood Zone

PorchCode

Null

Null

PC0

Covered Porch

PE0

Enclosed Porch

P0Y

Glass Porch

PO0

Open Porch

InteriorStructure

Null

Null

410

Brick

430

Concrete

402

Block (Unspecified)

750

Glass

101

Finished/Painted

201

Wallboard/Drywall

102

Custom/Decorative

401

Masonry (Unspecified)

350

Log

210

Cement Board

104

Composition

199

Other

701

Plaster

110

Paneling (Unspecified)

420

Stone

601

Metal

190

Unfinished

760

Vinyl Panel/Coating

301

Wood (Unspecified)

320

Plywood

HVACCoolingDetail

Null

Null

136

Evaporative Cooler

137

Other

122

Refrigeration AC

119

Fan Cooling AC

139

Chilled Wate

HVACHeatingDetail

Null

Null

103

Baseboard

113

Electric

108

Central

102

Forced Air

232

Oil

109

Floor/Wall Furnace

104

Gravity

105

Heat Pump

243

Geo-Thermal

111

Hot Water

231

Gas

226

Partial

112

Radiant

219

None

101

Other

110

Steam

229

Coal

120

Space

222

Convection

106

Solar

122

Wood Furnace

244

Propane

236

Yes

238

Zone

ForeclosureRecordType

Null

Null

Not Available

ND

Notice of Default

NL

Notice of Lis Pendens

NS

Notice of Foreclosure Sale

NT

Notice of Trustee Sale

MailingAddressType

Null

Null

Not Available

A

Alias

F

Firm or Company Address

G

General Delivery Address

H

High Rise or Business Complex

P

P.O. Box Address

R

Rural Route Address

S

Street or Residential Address

U

Unique

Z

Unique

Automated Valuation Models (AVM)#

Sample File#

Click here to download the sample file.

Layout and Definitions#

Grouping

Column Name

Type

Definition

Address

PropertyMelissaAddressKey

bigint

10-digit unique key assigned to each address.

PropertyBaseMelissaAddressKey

bigint

Displays the parent Melissa Address Key of an address if it is apart or within a building. Ex. Apartment

PropertyAddressLine

varchar(100)

AddressLine

PropertySuite

varchar(40)

Suite

PropertyCity

varchar(70)

City

PropertyState

varchar(2)

State

PropertyZIPCode

varchar(5)

ZIP code

PropertyPlus4

varchar(4)

Plus4

PropertyDeliveryPoint

varchar(2)

A specific location where mail is delivered to an individual or entity. It is a precise point of delivery for a particular address.

PropertyAddressKey

varchar(22)

Address key is a combination of a location’s ZIPCode + Plus4 + DeliveryPoint

PropertyResultCodes

varchar(200)

Melissa result codes

PropertyStreetNumber

varchar(10)

Address street number. Ex. ‘6450’

PropertyDirectionPrefix

varchar(5)

Address directional prefix. Ex. ‘e’

propertyStreetName

varchar(40)

Street name. Ex. ‘Side’

PropertyStreetSuffix

varchar(10)

Suffix of address. Ex. ‘Dr’

PropertyDirectionSuffix

varchar(5)

Address directional suffix. Ex. ‘Ne’

PropertySuiteName

varchar(10)

Suite. Ex. ‘Apt’

PropertySuiteNumber

varchar(10)

Suite number. Ex. ‘Q’

PropertyPlaceCode

varchar(7)

Place identifier represented as State FIPS (2) + PlaceFIPS (5)

PropertyCarrierRoute

varchar(4)

The carrier route for the location address assigned by the USPS.

PropertyFIPSCode

varchar(5)

The FIPSCode indicates the location of the address at both the state and county level.

PropertyDeliveryPointChecksum

varchar(1)

Barcode for the postal route, assigned to the mailing (primary) address. It shoul be 1 digits

Geo

PropertyLatitude

decimal

The latitude in decimal degrees using the WGS84 datum for the address

PropertyLongitude

decimal

The longitude in decimal degrees using the WGS84 datum for the address

PropertyCensusKey

varchar(16)

Census key is a 15 or 16-character key combination of the state FIPS code + county FIPS code + tract number + block number + block suffix. The Census key was created by the US Government to correctly identify, classify, and pull statistical data from areas across the United States.

PropertyCensusKeyDecennial

varchar(16)

Similar to the Census key, however, this key contains 15 characters and changes every 10 years. Fifteen-digit key that represents: State (2) + County (3) + Tract (6) + Block Group Number (4)

Address

CountyName

varchar(25)

County name

PropertyValuationModel

PropertyEstimatedValue

int

Highest hit rates.

PropertyEstimatedMinValue

int

The lowest probable value for the subject property

PropertyEstimatedMaxValue

int

The highest probable value for the subject property

PropertyEstimatedConfidenceScore

int

Confidence Score is a metric to gauge accuracy of the value estimate based on property and MLS data available to the model. Confidence Scores range from 0 to 100, with higher score being better

PropertyEstimatedValueFSD

int

Forecast Deviation (FSD) is statically recognized metric that measure standard deviation that single value estimates is within a +/- percentage of the true value

ValuationDate

varchar(8)

Date AVM value was rendered

Parcel

APN

varchar(45)

Assessor’s Parcel Number or Parcel Identification Number

APNUndecorated

varchar(45)

Undecorated Assessor’s Parcel Number or Parcel Identification Number