Skip to content

Data Dictionary

Jump to bottom
jonathanleek edited this page Oct 6, 2019 · 3 revisions

Where we can define fields in the dataset.

prcl.mdb

Contains a critical table 'Prcl' which lists all current parcels in the City of St. Louis. It is also the only table so far that contains corresponding entries of each of these parcel ID fields.

ParcelId Table Screenshot

To create ParcelId fields from fields that create it, we wrote a simple SQL query (feel free to adapt it)

"SELECT Parcel , Replace(CStr(Format(CityBlock, "0000.00")) + CStr(Format(Parcel, "0000")) + CStr(OwnerCode),".","") AS ParcelIDAttempt, ParcelId FROM Prcl"

Field Definitions

  • CITY FILE Prcl CITY FIELD
  • prcl.mdb BldgCom CityBlock
  • prcl.mdb BldgCom
  • prcl.mdb BldgCom BldgCategory
  • prcl.mdb BldgCom GroundFloorArea
  • prcl.mdb BldgCom ComExtWallType
  • prcl.mdb BldgCom ComStoriesCode
  • prcl.mdb BldgCom YearBuilt
  • prcl.mdb BldgCom ComConstType
  • prcl.mdb BldgCom TotApts
  • prcl.mdb BldgCom NbrOfAptsEff
  • prcl.mdb BldgCom NbrOfpts1Br
  • prcl.mdb BldgCom NbrOfpts2Br
  • prcl.mdb BldgCom NbrOfpts3Br
  • prcl.mdb BldgCom NbrOfptsOther
  • prcl.mdb BldgRes CityBlock
  • prcl.mdb BldgRes Parcel
  • prcl.mdb BldgRes ResOccType
  • prcl.mdb BldgRes BsmtType
  • prcl.mdb BldgRes BsmtFinishType
  • prcl.mdb BldgRes BsmtAreaFinished
  • prcl.mdb BldgRes BsmtAreaPartial
  • prcl.mdb BldgRes ResExtWallType
  • prcl.mdb BldgRes LivingAreaTotal
  • prcl.mdb BldgRes LivingAreaAtGrade
  • prcl.mdb BldgRes LivingAreaUpDown
  • prcl.mdb BldgRes ResStoriesCode
  • prcl.mdb BldgRes FullBaths
  • prcl.mdb BldgRes HalfBaths
  • prcl.mdb BldgRes AirCondCentral
  • prcl.mdb BldgRes AirCondWindow
  • prcl.mdb BldgRes CentralHeating
  • prcl.mdb BldgRes Garage1
  • prcl.mdb BldgRes Garage2
  • prcl.mdb BldgRes Carport1
  • prcl.mdb BldgRes Carport2
  • prcl.mdb BldgRes YearBuilt
  • prcl.mdb BldgRes ResModelCode
  • prcl.mdb BldgRes ResModelAdjCode
  • prcl.mdb BldgRes EffectiveYearBuilt
  • prcl.mdb BldgRes FuctionalDep
  • prcl.mdb BldgRes LocationalDep
  • prcl.mdb BldgResImp ImpNum
  • prcl.mdb BldgResImp ImpCode
  • prcl.mdb BldgSect SectNum
  • prcl.mdb BldgSect SectCategory
  • prcl.mdb BldgSect SectType
  • prcl.mdb BldgSect FramingType
  • prcl.mdb BldgSect ExcavType
  • prcl.mdb BldgSect ExtWallType
  • prcl.mdb BldgSect LevelFrom
  • prcl.mdb BldgSect LevelTo
  • prcl.mdb BldgSect StoryHeight
  • prcl.mdb BldgSect Area
  • prcl.mdb BldgSect FoundationType
  • prcl.mdb BldgSect RoofType
  • prcl.mdb BldgSect RoofConst1
  • prcl.mdb BldgSect RoofConst2
  • prcl.mdb BldgSect RoofConst3
  • prcl.mdb BldgSect RoofConst4
  • prcl.mdb BldgSect Heating
  • prcl.mdb BldgSect AirCondCentral
  • prcl.mdb BldgSect AirCondWindow
  • prcl.mdb BldgSect Electricity
  • prcl.mdb Prcl Parcelid
  • prcl.mdb Prcl PrimAddrRecNum
  • prcl.mdb Prcl AddrType
  • prcl.mdb Prcl LowAddrNum
  • prcl.mdb Prcl LowAddrSuf
  • prcl.mdb Prcl HighAddrNum
  • prcl.mdb Prcl HighAddrSuf
  • prcl.mdb Prcl NLC
  • prcl.mdb Prcl StName
  • prcl.mdb Prcl StType
  • prcl.mdb Prcl StSufDir
  • prcl.mdb Prcl StdUnitNum
  • prcl.mdb Prcl OwnerName
  • prcl.mdb Prcl OwnerName2
  • prcl.mdb Prcl OwnerAddr
  • prcl.mdb Prcl OwnerCity
  • prcl.mdb Prcl OwnerState
  • prcl.mdb Prcl OwnerCountry
  • prcl.mdb Prcl OwnerZip
  • prcl.mdb Prcl OwnerRank
  • prcl.mdb Prcl LegalDesc1
  • prcl.mdb Prcl LegalDesc2
  • prcl.mdb Prcl LegalDesc3
  • prcl.mdb Prcl LegalDesc4
  • prcl.mdb Prcl LegalDesc5
  • prcl.mdb Prcl AsrClassCode
  • prcl.mdb Prcl AsrLandUse1
  • prcl.mdb Prcl AsrLandUse2
  • prcl.mdb Prcl ReDevPhase
  • prcl.mdb Prcl ReDevYearEnd
  • prcl.mdb Prcl ReDevPhase2
  • prcl.mdb Prcl ReDevYearEnd2
  • prcl.mdb Prcl VacantLot
  • prcl.mdb Prcl SpecBusDist
  • prcl.mdb Prcl SpecBusDist2
  • prcl.mdb Prcl TIFDist
  • prcl.mdb Prcl LendingAgcy
  • prcl.mdb Prcl Condominium
  • prcl.mdb Prcl NbrOfUnits
  • prcl.mdb Prcl NbrOfApts
  • prcl.mdb Prcl Frontage
  • prcl.mdb Prcl LandArea
  • prcl.mdb Prcl RecDailyDate
  • prcl.mdb Prcl RecDailyNum
  • prcl.mdb Prcl RecBookNum
  • prcl.mdb Prcl RecPageNum
  • prcl.mdb Prcl AsdLand
  • prcl.mdb Prcl AsdImprove
  • prcl.mdb Prcl AsdTotal
  • prcl.mdb Prcl BillLand
  • prcl.mdb Prcl BillImprove
  • prcl.mdb Prcl BillTotal
  • prcl.mdb Prcl AprLand
  • prcl.mdb Prcl CostAprImprove
  • prcl.mdb Prcl AsmtAppealYear
  • prcl.mdb Prcl AsmtAppealNum
  • prcl.mdb Prcl AsmtAppealType
  • prcl.mdb Prcl PriorAsdDate
  • prcl.mdb Prcl PriorAsdLand
  • prcl.mdb Prcl PriorAsdImprove
  • prcl.mdb Prcl PriorAsdTotal
  • prcl.mdb Prcl CDALandUse1
  • prcl.mdb Prcl CDALandUse2
  • prcl.mdb Prcl LRMSUnitNum
  • prcl.mdb Prcl Zoning
  • prcl.mdb Prcl ResSalePrice
  • prcl.mdb Prcl ResSaleDate
  • prcl.mdb PrclAddr
  • prcl.mdb PrclAttr
  • prcl.mdb PrclImp ImpMeasure
  • prcl.mdb PrclREAR BillYear
  • prcl.mdb PrclREAR BillSuffix
  • prcl.mdb PrclREAR LastUpdate
  • prcl.mdb PrclREAR OriginalCharge
  • prcl.mdb PrclREAR TaxAmount
  • prcl.mdb PrclREAR LandValue
  • prcl.mdb PrclREAR ImproveValue
  • prcl.mdb PrclREAR TotalValue
  • prcl.mdb PrclREAR TaxBal
  • prcl.mdb PrclREAR NbrofSewerLines
  • prcl.mdb PrclREAR IsAdd
  • prcl.mdb PrclREAR IsDeleted
  • prcl.mdb PrclREAR IsPaidUnderProtest
  • prcl.mdb PrclREAR IsPrior
  • prcl.mdb PrclREAR ComResCode
  • prcl.mdb PrclREAR SpecBusDist
  • prcl.mdb PrclREAR SewerLineSplit
  • prcl.mdb PrclREAR ResTaxAmt
  • prcl.mdb PrclREAR ComLandValue
  • prcl.mdb PrclREAR ComImproveValue
  • prcl.mdb PrclREAR ComTotalValue
  • prcl.mdb PrclREAR ComTaxmt
  • prcl.mdb PrclREAR SurTaxAmt
  • prcl.mdb PrclREAR SBDTaxAmt
  • prcl.mdb PrclREAR LatSewerAmt
  • prcl.mdb PrclREAR DemoCharge
  • prcl.mdb PrclREAR NuisanceTax
  • prcl.mdb PrclREAR TIFDist
  • prcl.mdb PrclREAR TIFSplit
  • prcl.mdb PrclREAR SpecBusDist

Open Questions:

What are FirstDate, LastDate, LastUpDate (see prcl.mdb)

What is CdAttrTypeNum all about?

Clone this wiki locally