Data Tables and File Layouts

 

Database Download -

Microsoft Access Database Tables -

The Sarasota table contains property records from the SCPA mass appraisal database. The codes described to the right are listed for each property record.

The Tangible Personal Property table contains the business accounts from the SCPA database.

The Mobile Home table contains the mobile home owners from the SCPA tangible personal property database.

Access Code Tables -

tblBusinessTypes (6 digit) - Business classifications for a tangible account.
tblBuildingClass (3-4 digit) - Quality of construction codes.
tblDelDistricts (4 digit) - Community delineated district codes.
tblExemptions (3 digit) - Types of property and personal exemptions.
tblGulfBay [Waterfront] (3-4 digit) - Types of waterfront for major waterways.
tblLandUse (4 digit) - Land use codes.
tblMobileHomeIndex - Mobile Home Park Index and associated mapping.
tblNeighborhood (3 digit) - Neighborhood codes.
tblQualification (2 digit) - Type of sales qualification code.
tblSubCodes (4 digit) - Subdivision codes.
tblSubIndex (4 digit) - Subdivision codes with associated mapping.
tblTaxCodes (4 digit) - Ad Valorem tax codes
tblZoning (2-4 digit) - Zoning codes.

Text Delimited Database File -

The Sarasota.txt file contains property records from the SCPA mass appraisal database. The codes described to the right are listed for each property record. Click here for file layout.

The MobileHomes.txt file contains the mobile home owners from the SCPA tangible personal property database. Click here for file layout.

Text Delimited Code Files -

Same as above.

 

Sales Database Download -

Microsoft Access Sales Database Table -

The Parcel Sales table is the sales database listing each sales transaction.

Access Code Tables -

tblDeedTypes (2 digit) - Description of each deed type.
tblQualifications (1-2 digit) - Types of qualification codes.

Text Delimited File -

The ParcelSales.txt file is the sales database listing each sales transaction.

 

 

Text Delimited Code Files-

DeedTypes.txt and QualificationCode.txt files.

 


 

Last Update 05/03/10