User Tools

Site Tools


record_filters

Record Filters for WinCAMA

Parcel Record Filters

Here are some record filter examples.

PARCELS WITH MOBILE HOME

Parcel.Parcelkey in (select parcelkey from improvements, residential where residential.impkey = improvements.impkey and residential.occupancy = '4')

AG ADJ NO CHANGE

Parcel.ParcelKey in (Select AgAdjNoChange.ParcelKey from AgAdjNoChange)

AG ADJ WENT DOWN

Parcel.ParcelKey in (Select AgAdjWentDown.ParcelKey from AgAdjWentDown)

AG ADJ WENT UP

Parcel.ParcelKey in (Select AgAdjWentUp.ParcelKey from AgAdjWentUp)

MISSING PHOTOS

parcel.parcelkey in (select parcel.Parcelkey from Parcel inner join Improvements on parcel.ParcelKey = Improvements.ParcelKey inner join documents on improvements.ImpKey = documents.ForeignKey inner join Residential on Improvements.ImpKey = Residential.ImpKey where documents.DocType = 'Apex' and Residential.Living1 > 0 and not documents.ForeignKey in (select foreignkey from Documents where DocType = 'Photo'))

NEW PHOTOS

Parcel.Parcelkey in (select parcel.parcelkey from Parcel inner join Improvements on parcel.ParcelKey=Improvements.ParcelKey inner join Documents on Improvements.ImpKey = Documents.ForeignKey Where DocType = 'Photo' and documents.ChangedDate >= '2013-01-01 00:00:00.000')

2006 DOB FREEZE

parcel.parcelkey in (select parcel.parcelkey from parcel left outer join valuation as oldvalue on oldvalue.valuekey = previousvaluekey left outer join valuation as newvalue on newvalue.valuekey = currentvaluekey where oldvalue.over65 = false and newvalue.over65 = true and year(newvalue.birthdate) = 1941)

2006 DEED FREEZE

parcel.parcelkey in (select parcel.parcelkey from parcel left outer join valuation as oldvalue on oldvalue.valuekey = previousvaluekey left outer join valuation as newvalue on newvalue.valuekey = currentvaluekey where oldvalue.over65 = false and newvalue.over65 = true)

IMP SALES MARKED VACANT

parcel.parcelkey in (select parcel.parcelkey from parcel left outer join valuation on parcel.currentvaluekey = valuation.valuekey left outer join deeds on parcel.lastsalekey = deeds.deedkey where valuation.hsfullimps+valuation.nhsfullimps > 0 and deeds.saletype <> 'I' and deeds.saledate > '03/31/2006')

2007 FUTURE (8/21/06)

parcel.parcelkey in (select parcel.parcelkey from parcel left outer join valuation on parcel.parcelkey = valuation.parcelkey where calcmethod = '99' and changedate >= '08/21/2006')

2006 SALES NOT APP W/HOMESTEAD

parcel.parcelkey in (select parcel.parcelkey from parcel, valuation, deeds where parcel.currentvaluekey = valuation.valuekey and parcel.lastsalekey = deeds.deedkey and deeds.validappby is null and deeds.validreqby is not null and year(deeds.saledate) = 2006 and valuation.homestead = true)

2006 HS AHIST NO HS IMP

Parcel.parcelkey in (select parcelkey from Valuation where Valuation.AsYear=2006 AND Valuation.Homestead = true AND Valuation.HSEffective=0 AND CalcMethod<>'99')

FULL VALUE INCREASE
parcel.parcelkey in (select v1.parcelkey from valuation v1, valuation v2 where v1.valuekey = parcel.currentvaluekey and v2.valuekey = parcel.previousvaluekey and v1.hsfullland + v1.hsfullimps + v1.nhsfullimps + v1.nhsfullland > v2.hsfullland + v2.hsfullimps + v2.nhsfullimps + v2.nhsfullland)

NEW CONST LETTER FOR 2007

parcel.parcelkey in (select valuation.parcelkey from valuation where valuation.asyear=2007 and valuation.homestead = false and (valuation.hsfullimps + valuation.nhsfullimps) > 100 and valuation.calcmethod <> '99' and parcel.currentvaluekey = valuation.valuekey) and Parcel.parcelkey in (select ParcelUseCodes.parcelkey from ParcelUseCodes where ParcelUseCodes.UseCode like '%2007ND%')

NO 2013* USE CODE

Parcel.parcelkey NOT in (select parcelkey from ParcelUseCodes where ParcelUseCodes.UseCode='2013*')

NO 2009ND, RURAL, RURBAN OR MN

Parcel.ParcelKey not in (Select ParcelUseCodes.ParcelKey from ParcelUseCodes where Parcel.ParcelKey = ParcelUseCodes.ParcelKey and ParcelUseCodes.UseCode in ('2009ND')) and Parcel.Parcel not like '001%' and (Parcel.Parcel ⇐ '010-00001-000' or Parcel.Parcel >= '376-00128-000')

USE CODE NOT COM OR 2009ND

Parcel.ParcelKey not in (Select ParcelUseCodes.ParcelKey from ParcelUseCodes where Parcel.ParcelKey = ParcelUseCodes.ParcelKey and ParcelUseCodes.UseCode in ('COM','2009ND'))

COMMERCIAL WITH RES IMP

Parcel.ParcelType='COM' and Parcel.parcelkey in (select parcelkey from Improvements where Improvements.ImpType='R')

RPT-PASTURE OR TIMBER PRICING

ParcelKey in (Select Land.ParcelKey from Land where UseCode = 'PASTURE' or UseCode = 'TIMBER')

LOG HOUSES

parcelkey in (select p.parcelkey from parcel p, improvements i, residential r where p.parcelkey = i.parcelkey and i.impkey = r.impkey and r.specialwalltype = 3)

ALL MH

parcelkey in (select parcel.parcelkey from parcel, improvements, residential where parcel.parcelkey = improvements.parcelkey and improvements.impkey = residential.impkey and restype = 'M' )

MH ON OBYI

parcelkey in (select parcel.parcelkey from parcel, improvements, residential, resobyi where parcel.parcelkey = improvements.parcelkey and improvements.impkey = residential.impkey and residential.reskey = resobyi.reskey and resobyi.obyitem like 'MH%' )

UNCALCULATED PARCELS

parcelkey in (select parcelkey from improvements where imptype='R' and homesteadvalue is null)

VACANT

not exists (select * from improvements where improvements.parcelkey=parcel.parcelkey)

PARCELCOUNT

VALUEKEY>0

BAD S-T-R

length(parcel.section)<>2 or length(parcel.township)<>3 or length(parcel.range)<>3 or Parcel.Section is null or Parcel.Township is null or Parcel.Range is null

PASTURE OR TIMBER PRICING

Parcel.ParcelKey in (Select Land.ParcelKey from Land where UseCode = 'PASTURE' or UseCode = 'TIMBER')

SALE NOT APPROVED

Parcel.ParcelKey in (Select Improvements.ParcelKey from Improvements where Improvements.ParcelKey = Parcel.ParcelKey and Improvements.HomesteadValue + Improvements.NonHomesteadValue <> 0) and Parcel.LastSaleKey in (Select Deeds.DeedKey from Deeds where Deeds.DeedKey = Parcel.LastSaleKey and Deeds.SaleDate >= '01/01/2005' and Deeds.ValidAppBy is null)

RURAL AND RURBAN NO FIRE DIST

TaxpayerID <> 09100000 AND 1) and not Parcel.ParcelKey in (Select ImpDist.ParcelKey from ImpDist where ParcelKey = ImpDist.ParcelKey and (Dist='11' or Dist='12' or Dist='13' or Dist='14' or Dist='15' or Dist='16' or Dist='18' or Dist='19' or Dist='21' or Dist='59'))

LOT IN STREET TYPE

Left(Parcel.SiteStreetType,3) = 'LOT'

BAD SOIL CODES

parcel.parcelkey in (select parcel.parcelkey from parcel where parcel.parcelkey in (select distinct(land.parcelkey) from land where (usecode like 'TIMBER%' or usecode like 'PASTURE%') and not soilcode like 'S%') )

TIMBER TAX MISMATCH

parcelkey in (select l.parcelkey from land l where l.usecode like '%TIMBER%' group by l.parcelkey having sum(l.acres) <> timber)

IMPS WITH NO LOT PRICING

parcelkey in (select i.parcelkey from improvements i where i.parcelkey = parcelkey and i.HomesteadValue + i.NonHomesteadValue <> 0) and not parcelkey in (select l.parcelkey from land l where l.parcelkey = parcelkey and l.usecode like '%LOT%') and parcelkey in (select l2.parcelkey from land l2 where l2.parcelkey = parcelkey)

HS/NHS AHIST BUG

parcel in (select parcel from ahistbug)

NOTICE COUNT

(parcel.parcelkey in (select valuation.parcelkey from valuation, valuation v2 where valuation.valuekey = parcel.currentvaluekey and v2.valuekey = parcel.previousvaluekey and valuation.hsfullland+valuation.hsfullimps+valuation.nhsfullland+valuation.nhsfullimps > v2.hsfullland+v2.hsfullimps+v2.nhsfullland+v2.nhsfullimps) or (exists (select valuation.parcelkey from valuation where valuation.valuekey = parcel.currentvaluekey and valuation.hsfullimps+valuation.hsfullland+valuation.nhsfullimps+valuation.nhsfullland <> 0) and not exists (select v2.parcelkey from valuation v2 where v2.valuekey = parcel.previousvaluekey)))

COM PRICING W/O COM PAR TYPE

parcel.parcelkey in (select improvements.parcelkey from improvements where parcel.parcelkey = improvements.parcelkey and improvements.imptype = 'C') and parcel.parceltype <> 'COM'

Back to Assessor Wiki Home || WinCAMA Home

Cloud Words

1) Parcel >= '001-00001-000' AND Parcel ⇐ '001-14643-000') OR (Parcel >= '010-00001-000' AND Parcel ⇐ '376-00128-000'
record_filters.txt · Last modified: 2017/04/21 13:58 (external edit)