================================================================================ NOTE: *|* Field Is Generally Not Provided In A Customer Data Extraction ================================================================================ LEE COUNTY PROPERTY APPRAISER www.LeePA.org Data Services Department (239) 533-6185 * DataServices@LeePA.org All data is current at time of export and subject to change without notice. All confidential records have been removed. Record Layout For CAMA1.DataServices.dbo.PropertyExport CAMA1.DataServices.dbo.PropertyExportHeaders DataServices.DataServices.dbo.PropertyExport DataServices.DataServices.dbo.PropertyExportHeaders PA_GIS.CAMAdata.dbo.Property PA_GIS.CAMAdata.dbo.PropertyHeaders NAME TYPE LENGTH | DESCRIPTION ================================== | ========================================= ----------------------------- PARCEL INFORMATION ----------------------------- Hide Character 1 *|* Is Property Confidential 'C' or 'S' IsCondo Character 1 | Is Property a Condominium 'C' or 'R' hFolioID Numeric(8,0) 8 *|* Header Record Numeric ID FolioID Numeric(8,0) 8 *|* Property Numeric ID Strap Character 17 | Property ID (Section, Township & Range) TRSparcel Character 17 | Property ID (Township, Range & Section) DORcode Character 2 | Department of Revenue Classification Code UnitOfMeas Character 2 | Type of Unit of Measure NumUnits Numeric(12,2) 13 | Number of Land Units Frontage Numeric(9,0) 9 | Property Frontage in Feet Depth Numeric(9,0) 9 | Property Depth in Feet GISAcres Numeric(12,5) 13 | Total Computed Acres from GIS TaxingDist Character 3 | Taxing District of Property TaxDistDesc Character 60 | Taxing District Description FireDist Character 3 | Fire District of Property FireDistDesc Character 60 | Fire District Description LandUseCode Numeric(4,0) 4 | Land Use Code LandUseDesc Character 60 | Land Use Description NbhdMajor Character 2 *|* Neighborhood Major NbhdMinor Character 3 *|* Neighborhood Minor NbhdLand Character 1 *|* Neighborhood Land LandIsOn Character 5 | BAY,CANAL,CREEK,GULF,LAKE,RIVER & GOLF ------------------------- SITE LOCATION INFORMATION -------------------------- SiteAddress Character 55 | Property Location - Full Address Line SiteNumber Character 10 | Property Location - Street Number SiteStreet Character 40 | Street Name SiteUnit Character 5 | Unit Number SiteCity Character 20 | City SiteZip Character 5 | Zip Code ------------------------------- PARCEL VALUES -------------------------------- Just Numeric(12,0) 12 | Market Value - 2013 Final Roll Value Assessed Numeric(12,0) 12 | Building Value + Land Value - 2013 Final Roll Value Taxable Numeric(12,0) 12 | Taxable Value - 2013 Final Roll Value Land Numeric(12,0) 12 | Land Value Building Numeric(12,0) 12 | Building Value LXFV Numeric(12,0) 12 | Land Extra Feature Value BXFV Numeric(12,0) 12 | Building Extra Feature value NewBuilt Numeric(12,0) 12 | New Construction Value AgAmount Numeric(12,0) 12 | Agriculture "Exemption" Value DisAmount Numeric(12,0) 12 | Disability Exemption Value HistAmount Numeric(12,0) 12 | Historical Exemption Value HstdAmount Numeric(12,0) 12 | Homestead Exemption Value SnrAmount Numeric(12,0) 12 | Senior Exemption Value WhlyAmount Numeric(12,0) 12 | Wholly Exemption Value WidAmount Numeric(12,0) 12 | Widow Exemption Value WidrAmount Numeric(12,0) 12 | Widower Exemption Value ----------------------- CURRENT STRUCTURE INFORMATION ------------------------ BldgCount Numeric(4,0) 4 | Total Number of Buildings on Parcel MinBuiltYear Numeric(4,0) 4 | Oldest Building Built MaxBuiltYear Numeric(4,0) 4 | Newest Building Built TotalArea Numeric(12,0) 12 | Total Building Area HeatedArea Numeric(12,0) 12 | Total Heated Area MaxStories Numeric(4,1) 5 | Tallest Building on Parcel Bedrooms Numeric(5,0) 5 | Total Number of Bedrooms Bathrooms Numeric(5,1) 6 | Total Number of Bathrooms / Not For Comm Garage Character 1 | Garage on Property 'Y' Carport Character 1 | Carport on Property 'Y' Pool Character 1 | Pool on Property 'Y' BoatDock Character 1 | Boat Dock on Property 'Y' SeaWall Character 1 | Sea Wall on Property 'Y' ------------- NEW STRUCTURE INFORMATION NOT ON CURRENT TAX ROLL -------------- NewBldgCount Numeric(4,0) 4 | Total Number of New Buildings on Parcel NewMinBuiltYear Numeric(4,0) 4 | Oldest New Building Built NewMaxBuiltYear Numeric(4,0) 4 | Newest New Building Built NewTotalArea Numeric(12,0) 12 | Total New Building Area NewHeatedArea Numeric(12,0) 12 | Total New Heated Area NewMaxStories Numeric(4,1) 5 | Tallest New Building on Parcel NewBedrooms Numeric(5,0) 5 | Total Number of New Bedrooms NewBathrooms Numeric(5,1) 6 | Total Number of New Bathrooms/Not For Comm NewGarage Character 1 | New Garage on Property 'Y' NewCarport Character 1 | New Carport on Property 'Y' NewPool Character 1 | New Pool on Property 'Y' NewBoatDock Character 1 | New Boat Dock on Property 'Y' NewSeaWall Character 1 | New Sea Wall on Property 'Y' ---------------------------- OWNER INFORMATION ------------------------------ OwnerName Character 30 | Owner Name OwnerOthers Character 120 | Other Owners Full Field OwnerCareOf Character 30 | In Care Of Line OwnerAddr1 Character 30 | Owner Address Line 1 OwnerAddr2 Character 30 | Owner Address Line 2 OwnerCity Character 30 | Owner City OwnerState Character 2 | Owner State OwnerZip Character 9 | Owner Zip OwnerCountry Character 30 | Owner Country ----------------------------- SALES INFORMATION ------------------------------ Sale1Date Date 'YYYYMMDD' 8 | Most Current Sale Date > $100.00 Sale1Amount Numeric(12,0) 12 | Sale Amount Sale1VI Character 1 | Sale Vacant or Improved Sale1TC Character 2 | Sale Transaction Code Sale1TOC Character 2 | Sale Transaction Override Code Sale1ORlocator Character 13 | Original Record (Lee County Clerk) | "-B1234-P1234-" Book & Page | "1234567890123" Document Number Sale1Create Date 'YYYYMMDD' 8 *|* Sale Date Posted By LCPA Sale2Date Date 'YYYYMMDD' 8 | Previous Sale Date > $100.00 Sale2Amount Numeric(12,0) 12 | Sale Amount Sale2VI Character 1 | Sale Vacant or Improved Sale2TC Character 2 | Sale Transaction Code Sale2TOC Character 2 | Sale Transaction Override Code Sale2ORlocator Character 13 | Original Record (Lee County Clerk) | "-B1234-P1234-" Book & Page | "1234567890123" Document Number Sale2Create Date 'YYYYMMDD' 8 *|* Sale Date Posted By LCPA Sale3Date Date 'YYYYMMDD' 8 | Next Previous Sale Date > $100.00 Sale3Amount Numeric(12,0) 12 | Sale Amount Sale3VI Character 1 | Sale Vacant or Improved Sale3TC Character 2 | Sale Transaction Code Sale3TOC Character 2 | Sale Transaction Override Sale3ORlocator Character 13 | Original Record (Lee County Clerk) | "-B1234-P1234-" Book & Page | "1234567890123" Document Number Sale3Create Date 'YYYYMMDD' 8 *|* Sale Date Posted By LCPA Sale4Date Date 'YYYYMMDD' 8 | Next Previous Sale Date > $100.00 Sale4Amount Numeric(12,0) 12 | Sale Amount Sale4VI Character 1 | Sale Vacant or Improved Sale4TC Character 2 | Sale Transaction Code Sale4TOC Character 2 | Sale Transaction Override Sale4ORlocator Character 13 | Original Record (Lee County Clerk) | "-B1234-P1234-" Book & Page | "1234567890123" Document Number Sale4Create Date 'YYYYMMDD' 8 *|* Sale Date Posted By LCPA ----------------------------- LEGAL INFORMATION ------------------------------ Legal Character 255 | Full Legal Description (On Deed) ----------------------------- OTHER INFORMATION ------------------------------ GarbDist Character 3 | County Garbage Hauling Area GarbType Character 1 | County Garbage Pick-up Type GarbComCat Character 1 | County Garbage Commercial Category GarbHeader Character 1 | Garbage Header Code GarbUnits Numeric(12,0) 12 | Number of Garbage Units YearCreated Numeric(4,0) 4 | Year Record was Created in System Property_URL Character 90 | Link to Property Page