Geodataset Name:       PARCELS_2018
Geodataset Type:       FILE GEODATABASE FEATURE CLASS
Geodataset Feature:    Polygon
Feature Count:         10261260

DATA SOURCE(S):                    University of Florida GeoPlan Center
SCALE OF ORIGINAL SOURCE MAPS:     Varies
GEODATASET EXTENT:                 State of Florida

PUBLICATION DATE:                  20190312
TIME PERIOD OF CONTENT:            Begin Date: 20180724    End Date: 20181228
DOWNLOAD LINK:                     http://www.fgdl.org/metadataexplorer/explorer.jsp

FEATURE ATTRIBUTE TABLES:

Datafile Name: PARCELS_2018.DBF

FEATURE ATTRIBUTE TABLES CODES AND VALUES:

Item	Item Description
OBJECTID	Internal feature number.
Shape	Feature geometry.
CNTYNAME	The County Name.
LINK	The local parcel number with the state DOR county code added to the beginning of the number.
PARCELID	The local parcel number for the parcel record.
NPARNO	The local parcel number with the state and county fips added to the beginning of the number.
DORUC	DOR classification code. Land use codes for assessment purposes. For more detailed descriptions please see the Attribute Overview Section: DOR LAND USE CODES 000 = Vacant Residential 001 = Single Family Residential 002 = Mobile Homes 003 = Multi-family - 10 units or more 004 = Condominiums 005 = Cooperatives 006 = Retirement Homes not eligible for exemption. 007 = Miscellaneous Residential (migrant camps, boarding homes, etc.) 008 = Multi-family - less than 10 units 009 = Residential Common Elements / Areas 010 = Vacant Commercial 011 = Stores One-Story 012 = Mixed use - store and office or store and residential or residential combination 013 = Department Stores 014 = Supermarkets 015 = Regional Shopping Centers 016 = Community Shopping Centers 017 = Office buildings, non-professional service buildings, one story 018 = Office buildings, non-professional service buildings, multi-story 019 = Professional Service Buildings 020 = Airports (private or commercial), bus terminals, marine terminals, piers, marinas. 021 = Restaurants, Cafeterias 022 = Drive-in Restaurants 023 = Financial institutions (banks, saving and loan companies, mortgage companies, credit services) 024 = Insurance Company Offices 025 = Repair service shops (excluding automotive), radio and T.V. repair, refrigeration service, electric repair, laundries, laundromats. 026 = Service Stations 027 = Auto sales, auto repair and storage, auto service shops, body and fender shops, commercial garages, farm and machinery sales and services, auto rental, marine equipment, trailers and related equipment, mobile home sales, motorcycles, construction vehicle sales. 028 = Parking lots (commercial or patron) mobile home parks. 029 = Wholesale outlets, produce houses, manufacturing outlets. 030 = Florist, greenhouses 031 = Drive-in theaters, open stadiums 032 = Enclosed theaters, enclosed auditoriums 033 = Nightclubs, cocktail lounges, bars 034 = Bowling alleys, skating rinks, pool halls, enclosed arenas 035 = Tourist attractions, permanent exhibits, other entertainment facilities, fairgrounds (privately owned). 036 = Camps 037 = Race tracks; horse, auto or dog 038 = Golf courses, driving ranges 039 = Hotels, motels 040 = Vacant Industrial 041 = Light manufacturing, small equipment manufacturing plants, small machine shops, instrument manufacturing printing plants. 042 = Heavy industrial, heavy equipment manufacturing, large machine shops, foundries, steel fabricating plants, auto or aircraft plants 043 = Lumber yards, sawmills, planing mills 044 = Packing plants, fruit and vegetable packing plants, meat packing plants 045 = Canneries, fruit and vegetable, bottlers and brewers distilleries, wineries 046 = Other food processing, candy factories, bakeries, potato chip factories 047 = Mineral processing, phosphate processing, cement plants, refineries, clay plants, rock and gravel plants 048 = Warehousing, distribution terminals, trucking terminals, van and storage warehousing 049 = Open storage, new and used building supplies, junk yards, auto wrecking, fuel storage, equipment and material storage 050 = Improved agricultural 051 = Cropland soil capability Class I 052 = Cropland soil capability Class II 053 = Cropland soil capability Class III 054 = Timberland - site index 90 and above 055 = Timberland - site index 80 to 89 056 = Timberland - site index 70 to 79 057 = Timberland - site index 60 to 69 058 = Timberland - site index 50 to 59 059 = Timberland not classified by site index to Pines 060 = Grazing land soil capability Class I 061 = Grazing land soil capability Class II 062 = Grazing land soil capability Class III 063 = Grazing land soil capability Class IV 064 = Grazing land soil capability Class V 065 = Grazing land soil capability Class VI 066 = Orchard Groves, Citrus, etc. 067 = Poultry, bees, tropical fish, rabbits, etc. 068 = Dairies, feed lots 069 = Ornamentals, miscellaneous agricultural 070 = Vacant , with or without extra features 071 = Churches 072 = Private schools and colleges 073 = Privately owned hospitals 074 = Homes for the aged 075 = Orphanages, other non-profit or charitable services 076 = Mortuaries, cemeteries, crematoriums 077 = Clubs, lodges, union halls 078 = Sanitariums, convalescent and rest homes 079 = Cultural organizations, facilities 080 = Vacant Governmental 081 = Military 082 = Forest, parks, recreational areas 083 = Public county schools - include all property of Board of Public Instruction 084 = Colleges 085 = Hospitals 086 = Counties (other than public schools, colleges, hospitals) including non-municipal government. 087 = State, other than military, forests, parks, recreational areas, colleges, hospitals 088 = Federal, other than military, forests, parks, recreational areas, hospitals, colleges 089 = Municipal, other than parks, recreational areas, colleges, hospitals 090 = Leasehold interests (government owned property leased by a non-governmental lessee) 091 = Utility, gas and electricity, telephone and telegraph, locally assessed railroads, water and sewer service, pipelines, canals, radio/television communication 092 = Mining lands, petroleum lands, or gas lands 093 = Subsurface rights 094 = Right-of-way, streets, roads, irrigation channel, ditch, etc. 095 = Rivers and lakes, submerged lands 096 = Sewage disposal, solid waste, borrow pits, drainage reservoirs, waste land, marsh, sand dunes, swamps 097 = Outdoor recreational or parkland, or high-water recharge subject to classified use assessment. 098 = Centrally assessed 099 = Acreage not zoned agricultural with or without extra features 100 = Parcels with no values. 995 = No Data Available (Water) 999 = No Data Available 101 = Parcels with no values (ROW). 102 = Parcels with no values (Water).
PAUC	Appraiser Land Use Code.
PARUSEDESC	Based on DORUC - Florida Water Management Districts Land Use Code Description.
SPASS_CD	Special Assessment Code. This field contains a code indicating special assessment considerations applicable to a parcel. This field is left blank if not applicable. This entry has a fixed length and should appear as a one-digit number. 1 = Pollution Control Device(s). 2 = Land subject to a conservation easement, environmentally endangered lands, or lands used for outdoor recreational or park purposes when land development rights have been conveyed or conservation restrictions have been covenanted. 3 = Land subject to a building moratorium.
IMPROVVAL	The value of the improvements on the parcels.
LNDVAL	The value of the land on the parcel.
JV	Total Just Value (land just value plus building value plus special feature value) of the property. Factors to be considered in determining just value are: present cash value; use; location; quantity or size; cost; replacement value of improvements; condition; income from property; and net proceeds if the property is sold. The net proceeds equal the value of the property minus 15% of the true market value. This accounts for the cost of selling the property.
JV_CHNG	Just Value Change. This field records the total change in just value between the preliminary roll the Department approves in July and the final NAL roll the property appraiser submits as certified to the tax collector. This field is not applicable to the preliminary roll and will only be filled on the initially certified final NAL file and, if required, the second final NAL file, certified after the value adjustment board concludes. Just value changes in the range of -$100 to $100 or value changes resulting from parcel splits or combinations are not recorded in this field. This field is left blank if not applicable.
JV_HMSTD	Just Value Homestead Property. This field indicates the just value of only the portion of the property that is subject to the Save Our Homes assessment increase limitation (s. 193.155, F.S.). This field is left blank if not applicable.
AV_SD	Assessed Value School District. This field indicates assessed value for school district assessments. School and non-school assessed value may differ if a parcel is subject to assessment limitations that are not applicable to school district assessments. These include the 10 percent assessment increase limitation on non-homestead property and locally-adopted assessment limitations on high-water recharge property and historic property used for commercial or non-profit purposes.
AV_NSD	Assessed Value Non-School District. This field contains the total assessed value for non-school district assessment purposes. School and non-school district assessed value may differ if a parcel is subject to assessment limitations applicable only to non-school district assessments. These include the 10 percent assessment increase limitation on non-homestead property and locally-adopted assessment limitations on high-water recharge property and historic property used for commercial or non-profit purposes.
AV_HMSTD	Assessed Value Homestead Property. This field indicates the assessed value of only the portion of the property that is subject to the Save Our Homes assessment increase limitation (s. 193.155, F.S.). This field is left blank if not applicable.
TV_SD	Taxable Value School District. This field contains the taxable value for school purposes, which is based on school assessed value. The additional $25,000 homestead exemption and local option homestead exemptions are not applicable to the school district's taxable value.
TV_NSD	Taxable Value Non-School District. This field indicates the taxable value for county purposes, which is based on non-school district assessed value (field 15). Only exemptions adopted by municipalities are not applicable to the county's taxable value.
JV_CLASS_USE	Just Value Classified Use (Agricultural Land Value). This field contains the just value of only the portion of the parcel that is classified as agricultural. This field is left blank if not applicable.
ONAME	Owner's Name (Primary Owner).
OADDR1	Owner's Street Address Line 1 ( Or P.O. Box ).
OADDR2	Owner's Street Address Line 2.
OCITY	Owner's City.
OSTATE	Owner's State or Country.
OZIPCD	Owner's U.S. Mail Zip Code.
PHYADDR1	Physical Location Street Address.
PHYCITY	Physical Location City.
PHYZIP	Physical Location Zip Code.
SLEGAL	Short Legal Description, this is generally needed when the parcel data does not include a map of the parcel.
ALTKEY	Property Appraiser's Alternate Key. If a county changes its parcel identification numbering system the previous number is put in the Alternate Key field.
ACTYRBLT	Actual Year Built.
EFFYRBLT	Effective Year Built.
TOTLVGAREA	Total Living Area - Residential OR Adjusted Usable - Non-Residential.
NOBULDNG	Number of Buildings.
NORESUNTS	Number of Residential Units.
PARSPLT	Flag tag: Parcel Split or Parcel Combination. 1 = Parcel was split since the previous year's tax roll. Remaining 4 characters are the 2 digit month and 2 digit year of occurrence 2 = Parcel is the combination of two or more parcels since the previous year's tax roll. Remaining 4 characters are the 2 digit month and 2 digit year of occurrence.
LNDSQFOOT	Land Square Footage. This field contains the equivalent square footage of the site. The entries in this field appear as whole numbers and are not necessarily the basis of land valuation by the county. An entry is required for all property except condominiums, cooperatives, and homeowners associations property. This field is left blank if not applicable.
CONSTCLASS	Construction Class. This field contains a code denoting the general overall construction class of the predominate structure(s) on the property. The classes are those established in the Marshall Valuation Service Manual Section 1. An entry is required for all improved commercial, industrial, governmental, and institutional property. This field will be blank if not applicable.
SALEPRC1	Sale Price (Most Recent Sale).
SALEYR1	Sale Year.
SALEPRC2	Sale Price Sale 2. This field will be blank if fewer than two current sales are posted to the parcel.
SALEYR2	Sale Year Sale 2. This field will be blank if fewer than two current sales are posted to the parcel.
NBRHDCD	Neighborhood Code. This field contains a code indicating the parcel's neighborhood. Property appraisers may assign neighborhood codes. This field is left blank if the property appraiser has not established neighborhood codes.
PUBLICLND	Public Land Code. F = Federal S = State C = County, County School District M = Municipal / City / Town D = Special Taxing Districts ( drainage/water/flood/mosquito/fire control, conservation, reclamation, sanitation/sewer, hospital/medical, airport/transit authority, regional planning councils, community colleges) W = Water Management Districts P = Other public lands T = State of Florida TIITF (owned by the Board of Trustees of the Internal Improvement Trust Fund) R = Railroad Owned (locally assessed)
TAXAUTHCD	A code identifying the taxing authorities that levy property tax on the parcel. Taxing Authority Code - first two digits indicate municipality where parcel located.
SEC	PLSS Section or Grant Number.
TWN	PLSS Township Number.
RNG	PLSS Range Number.
CENSUSBK	Census Block Group Number. This field identifies the parcel's U.S. Census Block Group and related information. The entry includes the Federal Information Processing Series (FIPS) codes for the state, county, tract, and block group. If a parcel is located in multiple block groups, the field identifies the block group of the center of the parcel.
SOURCEAGE	Source Agency.
SOURCEDATE	The date of the source document that was used to generate the parcel information.
LAT_DD	Latitude of the parcels centroid/label point in decimal degrees.
LONG_DD	Longitude of the parcels centroid/label point in decimal degrees.
MGRS	Military Grid Reference System (MGRS) Coordinate of the Parcel Centroid. The MGRS is the geocoordinate standard used by NATO militaries for locating points on the earth. The MGRS provides a means to represent any location on the surface of the Earth using an alphanumeric string. Hierarchical references are based on the Universal Transverse Mercator (UTM) coordinate system. The MGRS is used for the entire earth. http://mgrs-data.org/
GOOGLEMAP	Webpage hyperlink to location in Google Maps.
ACRES	Acreage of parcel.
EXMPT	Exemptions. Exemptions for Homestead property or land dedicated in perpetuity for conservation or land that has an affordable housing property exemption, AFF = Affordable housing property exemption was noted in the NAL table for any or all of the following fields: EXMPT_03, EXMPT_04, and EXMPT_15. CON = Land dedicated in perpetuity for conservation purposes and used exclusively for those purposes (EXMPT_36) OR Land dedicated in perpetuity for conservation purposes but also used for commercial purposes (EXMPT_37). HOM = Homestead property exemption was noted in the NAL table for any or all of the following fields: EXMPT_01 and EXMPT_02.
LU_RES	Land use code provides for residential use (YES/NO). Please Note: LUCODE '028' was reviewed using imagery only, LU_RES field = 'YES' where Mobile Homes were located. LU_RES = 'YES' for all of the following LUCODEs; 001, 002, 003, 004, 005, 006, 007, and 008.
LUCODE	Land Use Code Number based on DORUC and added new values: 100, 101, 102, 995 and 999.
GCID	GeoPlan Center Unique Identification Number.
DESCRIPT	Based on DORUC - FDOR description.
FLAG	Type of update that occurred, C = City name added for NULL value in physical address CITY field. Z = Zip code added for NULL value in physical address ZIPCODE field.
FGDLAQDATE	The date FGDL received the data from the Source.
AUTOID	Unique ID added by GeoPlan
Shape_Length	Length of feature in internal units.
Shape_Area	Area of feature in internal units squared.

FDOR LAND USE CODES USE CODE PROPERTY TYPE Residential 000 Vacant Residential - with/with out extra features(field 50 Special Features Code) 001 Single Family 002 Mobile Homes 003 Multi-family - 10 units or more 004 Condominia 005 Cooperatives 006 Retirement Homes not eligible for exemption. Others shall be given an Institutional classification 007 Miscellaneous Residential (migrant camps, boarding homes, etc.) 008 Multi-family - less than 10 units 009 Residential Common Elements / Areas. Commercial 010 Vacant Commercial - with/with out extra features(field 50 Special Features Code) 011 Stores, one story 012 Mixed use - store and office or store and residential or residential combination 013 Department Stores 014 Supermarkets 015 Regional Shopping Centers 016 Community Shopping Centers 017 Office buildings, non-professional service buildings, one story 018 Office buildings, non-professional service buildings, multi-story 019 Professional service buildings 020 Airports (private or commercial), bus terminals, marine terminals, piers, marinas 021 Restaurants, cafeterias 022 Drive-in Restaurants 023 Financial institutions (banks, saving and loan companies, mortgage companies, credit services) 024 Insurance company offices 025 Repair service shops (excluding automotive), radio and T.V. repair, refrigeration service, electric repair, laundries, laundromats 026 Service stations 027 Auto sales, auto repair and storage, auto service shops, body and fender shops, commercial garages, farm and machinery sales and services, auto rental, marine equipment, trailers and related equipment, mobile home sales motorcycles, construction vehicle sales. 028 Parking lots (commercial or patron) mobile home parks 029 Wholesale outlets, produce houses, manufacturing outlets 030 Florist, greenhouses 031 Drive-in theaters, open stadiums 032 Enclosed theaters, enclosed auditoriums 033 Nightclubs, cocktail lounges, bars 034 Bowling alleys, skating rinks, pool halls, enclosed arenas 035 Tourist attractions, permanent exhibits, other entertainment facilities, fairgrounds (privately owned). 036 Camps 037 Race tracks; horse, auto or dog 038 Golf courses, driving ranges 039 Hotels, motels Industrial 040 Vacant Industrial -with/with out extra features(field 50 Special Features Code) 041 Light manufacturing, small equipment manufacturing plants, small machine shops, instrument manufacturing printing plants 042 Heavy industrial, heavy equipment manufacturing, large machine shops, foundries, steel fabricating plants, auto or aircraft plants 043 Lumber yards, sawmills, planning mills 044 Packing plants, fruit and vegetable packing plants, meat packing plants 045 Canneries, fruit and vegetable, bottlers and brewers distilleries, wineries 046 Other food processing, candy factories, bakeries, potato chip factories 047 Mineral processing, phosphate processing, cement plants, refineries, clay plants, rock and gravel plants 048 Warehousing, distribution terminals, trucking terminals, van and storage warehousing 049 Open storage, new and used building supplies, junk yards, auto wrecking, fuel storage, equipment and material storage Agricultural 050 Improved agricultural 051 Cropland soil capability Class I 052 Cropland soil capability Class II 053 Cropland soil capability Class III 054 Timberland - site index 90 and above 055 Timberland - site index 80 to 89 056 Timberland - site index 70 to 79 057 Timberland - site index 60 to 69 058 Timberland - site index 50 to 59 059 Timberland not classified by site index to Pines 060 Grazing land soil capability Class I 061 Grazing land soil capability Class II 062 Grazing land soil capability Class III 063 Grazing land soil capability Class IV 064 Grazing land soil capability Class V 065 Grazing land soil capability Class VI 066 Orchard Groves, Citrus, etc. 067 Poultry, bees, tropical fish, rabbits, etc. 068 Dairies, feed lots 069 Ornamentals, miscellaneous agricultural Institutional 070 Vacant Institutional - with/with out extra features(field 50 Special Features Code) 071 Churches 072 Private schools and colleges 073 Privately owned hospitals 074 Homes for the aged 075 Orphanages, other non-profit or charitable services 076 Mortuaries, cemeteries, crematoriums 077 Clubs, lodges, union halls 078 Sanitariums, convalescent and rest homes 079 Cultural organizations, facilities Government 080 Vacant Governmental - with/with out extra features (field 50 Special Features Code) for municipal, counties, state, federal properties and water management district ( including DOT/State of Florida retention and/or detention areas). 081 Military - should include both improved and vacant. 082 Forest, parks, recreational areas 083 Public county schools - should include both improved and vacant. 084 Colleges - (non private) should include both improved and vacant. 085 Hospitals - (non private) should include both improved and vacant. 086 Counties (other than public schools, colleges, hospitals) including non-municipal government. 087 State, other than military, forests, parks, recreational areas, colleges, hospitals 088 Federal, other than military, forests, parks, recreational areas, hospitals, colleges 089 Municipal, other than parks, recreational areas, colleges, hospitals Miscellaneous 090 Leasehold interests (government owned property leased by a non-governmental lessee) 091 Utility, gas and electricity, telephone and telegraph, locally assessed railroads, water and sewer service, pipelines, canals, radio/television communication 092 Mining lands, petroleum lands, or gas lands 093 Subsurface rights 094 Right-of-way, streets, roads, irrigation channel, ditch, etc. 095 Rivers and lakes, submerged lands 096 Sewage disposal, solid waste, borrow pits, drainage reservoirs, waste land, marsh, sand dunes, swamps 097 Outdoor recreational or parkland, or high-water recharge subject to classified use assessment. Centrally Assessed 098 Centrally assessed Non-Agricultural Acreage 099 Acreage not classified agricultural- with/with out extra features(field 50 Special Features Code). Source: 2018 User's Guide for 2018 Department Property Tax Data Files: ftp://sdrftp03.dor.state.fl.us/Tax%20Roll%20Data%20Files/2018_NAL_SDF_NAP_Users_Guide/2018_NAL_SDF_NAP_Users_Guide.docx ADDITIONAL GEOPLAN CENTER LAND USE CODES USE CODE PROPERTY TYPE 100 Parcels with no values. 101 Parcels with no values (ROW). 102 Parcels with no values (Water). 995 No Data Available (Water). 999 No Data Available.

USER NOTES:

GeoPlan: Found topology issues, topology cleaned, see process steps.

Data set has been visually inspected by GeoPlan. According to the Property Appraisers' Offices, all data produced strives to meet National Mapping Accuracy Standards (NMAS).

GeoPlan relied on the integrity of the attribute information within the original data.

FDOR PROPERTY TAX OVERSIGHT: http://floridarevenue.com/property/Pages/Home.aspx FDOR Map Data: ftp://sdrftp03.dor.state.fl.us/Map%20Data/00_2018/ FDOR Tax Roll Data Files: 2018 Final NAL - SDF Files ftp://sdrftp03.dor.state.fl.us/Tax%20Roll%20Data%20Files/2018%20Final%20NAL%20-%20SDF%20Files/ FDOR 2018_NAL_SDF_NAP_Users_Guide ftp://sdrftp03.dor.state.fl.us/Tax%20Roll%20Data%20Files/2018_NAL_SDF_NAP_Users_Guide/2018_NAL_SDF_NAP_Users_Guide.docx ftp://sdrftp03.dor.state.fl.us/Tax%20Roll%20Data%20Files/2018_NAL_SDF_NAP_Users_Guide/2018_Users_Guide_Quick_Reference.xls

This feature class is intended to represent the geometric and spatial extents of tax parcels within their respective Counties.

This data is provided 'as is' and its horizontal positional accuracy has not been verified by GeoPlan

This data is provided 'as is' and its vertical positional accuracy has not been verified by GeoPlan

None. Please check sources, scale, accuracy, currentness and other available information. Please confirm that you are using the most recent copy of both data and metadata.

The Florida Geographic Data Library is a collection of Geospatial Data compiled by the University of Florida GeoPlan Center with support from the Florida Department of Transportation. GIS data available in FGDL is collected from various state, federal, and other agencies (data sources) who are data stewards, producers, or publishers. The data available in FGDL may not be the most current version of the data offered by the data source. University of Florida GeoPlan Center makes no guarantees about the currentness of the data and suggests that data users check with the data source to see if more recent versions of the data exist. Furthermore, the GIS data available in the FGDL are provided 'as is'. The University of Florida GeoPlan Center makes no warranties, guaranties or representations as to the truth, accuracy or completeness of the data provided by the data sources. The University of Florida GeoPlan Center makes no representations or warranties about the quality or suitability of the materials, either expressly or implied, including but not limited to any implied warranties of merchantability, fitness for a particular purpose, or non-infringement. The University of Florida GeoPlan Center shall not be liable for any damages suffered as a result of using, modifying, contributing or distributing the materials. A note about data scale: Scale is an important factor in data usage. Certain scale datasets are not suitable for some project, analysis, or modeling purposes. Please be sure you are using the best available data. 1:24000 scale datasets are recommended for projects that are at the county level. 1:24000 data should NOT be used for high accuracy base mapping such as property parcel boundaries. 1:100000 scale datasets are recommended for projects that are at the multi-county or regional level. 1:125000 scale datasets are recommended for projects that are at the regional or state level or larger. Vector datasets with no defined scale or accuracy should be considered suspect. Make sure you are familiar with your data before using it for projects or analysis. Every effort has been made to supply the user with data documentation. For additional information, see the References section and the Data Source Contact section of this documentation. For more information regarding scale and accuracy, see our webpage at: http://geoplan.ufl.edu/education.html

REFERENCES:

Florida Department of Revenue (FDOR) Property Department: http://floridarevenue.com/property/Pages/home.aspx FDOR Map Data: ftp://sdrftp03.dor.state.fl.us/Map%20Data/00_2018/ FDOR Tax Roll Data Files: 2018 Final NAL - SDF Files ftp://sdrftp03.dor.state.fl.us/Tax%20Roll%20Data%20Files/2018%20Final%20NAL%20-%20SDF%20Files/ 2018_NAL_SDF_NAP_Users_Guide ftp://sdrftp03.dor.state.fl.us/Tax%20Roll%20Data%20Files/2018_NAL_SDF_NAP_Users_Guide/2018_NAL_SDF_NAP_Users_Guide.docx ftp://sdrftp03.dor.state.fl.us/Tax%20Roll%20Data%20Files/2018_NAL_SDF_NAP_Users_Guide/2018_Users_Guide_Quick_Reference.xls

DATA LINEAGE SUMMARY:

GeoPlan Center Process Steps: Downloaded Spatial/GIS (20180724) and NAL Parcel data (20181228) information from the following FDOR FTP websites (ftp://sdrftp03.dor.state.fl.us/) Map Data: ftp://sdrftp03.dor.state.fl.us/Map%20Data/00_2018/ FDOR GIS Data Download Disclaimer.pdf Counties must deliver their parcel level GIS data to the Department of Revenue by April 1 each year. The parcel shapefiles available for download are typically generated in late March. Users should be aware of potential parcel identification number formatting issues when using .csv formatted NAL or SDF files. Users should first convert the .csv formatted files to .dbf format before attempting to perform a join operation with parcel shapefiles. Additional, or more complete, GIS data may be available by contacting county property appraisers offices directly. The following counties maintain condominium property in a separate file that is not part of the parcel shapefile downloads provided here. Contact these counties directly for the necessary files. Miami-Dade, St. Johns. ftp://sdrftp03.dor.state.fl.us/Map%20Data/00%20GIS%20Data%20Download%20Disclaimer.pdf Tax Roll Data Files: 2018 Final NAL - SDF Files ftp://sdrftp03.dor.state.fl.us/Tax%20Roll%20Data%20Files/2018%20Final%20NAL%20-%20SDF%20Files/ 2018_NAL_SDF_NAP_Users_Guide ftp://sdrftp03.dor.state.fl.us/Tax%20Roll%20Data%20Files/2018_NAL_SDF_NAP_Users_Guide/2018_NAL_SDF_NAP_Users_Guide.docx ftp://sdrftp03.dor.state.fl.us/Tax%20Roll%20Data%20Files/2018_NAL_SDF_NAP_Users_Guide/2018_Users_Guide_Quick_Reference.xls Step 1: Reprojected all 67 counties GIS parcel data to the following projection: Albers Conical Equal Area [Florida Geographic Data Library] Step 2: Dissolved each county on its PARCELNO field. Edited and exploded any multipart feature that did not have a parcel id. Step 3: Exported ALACHUA County to a new layer called Parcels_20181228 Added the following fields: CNTYNAME, LINK, PARCELID, NPARNO, MGRS, GOOGLEMAP, GCID, LAT_DD, LONG_DD, ACRES, FGDLAQDATE, SOURCEAGE Step 4: Appended the other 66 counties to the new Parcels_20181228 layer. Populated the following fields for all records: CNTYNAME, LINK, PARCELID, NPARNO, MGRS, GCID, LAT_DD, LONG_DD, ACRES, FGDLAQDATE, SOURCEAGE Step 5: Ran the repair geometry command 3x for each county. Spatially reviewed 3 locations in each county to determine level of spatial shift from 2017 version. Results of Spatial Review: Broward County: micro shift Charlotte County, Punta Gorda: 12-inch shift Duval County: 40-inch shift (>1m)[FIXED SEE BELOW] Marion County: 14-inch Shift Miami-Dade County: 5-Inch Shift Contacted Duval County about 1m shift, downloaded and used newer data directly from the following website to remove 1m shift: http://www.coj.net/departments/property-appraiser/property-appraiser-online-forms Duval County GIS Shapefiles 10-15-18 366MB Zipped File http://www.coj.net/departments/property-appraiser/property-appraiser-online-forms/duval_pao_gis_data_2018_10_15.aspx Step 6: Summarized on CNTYNAME to determine record count changes for each county and compared them to the 2015 version. Step 7: Using the Alachua County NAL as a Template built an empty FGDB table to LOAD to using the ArcCatalog Load Data tool. Converted most fields to STRING 255 in order to decrease errors on load. Step 8: Copied all NAL.csv files to a new folder. Using the Rename Program converted all .csv files to .txt Opened each of the 67 NAL.txt files and added a lowercase letter x to each of the first parcelids save and exit. This will force this tabular information to true text data and will not drop leading zeros and convert data to numbers with exponential signs upon load. Once loaded to a single FGDB table select for parcelno field LIKE x% and remove leading x from each of the 67 counties (67 records). Step 9: Load all 67 counties to the FGDB NAL Template review fields that do not load, if any. Step 10: Using the Parcelid and the CO_NO field create a unique LINK field and id. Step 11: Join NAL Template table to the Parcels_20181228 Statewide Parcel layer. Step 12: Determine which NAL records did not join to the statewide layer. Roughly 490,000. Summarize by county. Step 13: Downloaded the Miami-Dade Property_Point layer http://gis-mdc.opendata.arcgis.com/datasets/property-point-view Property Point Feature Layer miami-dade county (1/23/2019) 20190128 downloaded Determined PARENT parcel ids for missing Miami-Dade NAL information. Created Query Table with master Parcels_20181228 layer to create stacked polygons for missing Miami-Dade condo records, roughly 340,000 records. Please note a few other types were also mapped. Appended missing Miami-Dade parcels and NAL data to the Parcels_20181228 layer. Query Table Tip Put NAL subset (with Parent id) in same folder with parcel subset that matches parent (2018 had roughly 6600 parcels) Fields: Select All (Button) Expression: Hint: Remove Quotes "NAL_TEMPLATE_2018_Missing_V1_parent_id.NPARNO_PARENT" = "NAL_TEMPLATE_2018_Missing_V1_parent_id.NPARNO_T" NAL_TEMPLATE_2018_Missing_V1_parent_id.NPARNO_PARENT = NAL_TEMPLATE_2018_Missing_V1_parent_id.NPARNO_T Query Table Name: QueryTable_ParentNAL (If you have to make new QT make sure to change name each time) USE KEY FIELDS (ADD_VIRTUAL_KEY_FIELD) Okay See feature in Map, Export feature to dataset! Step 14: Downloaded the Manatee County CAMA Data and performed the same steps as above to add missing Condo information for roughly 30,000 records. https://www.manateepao.com/dnn/Downloads Comprehensive CAMA Data File https://www.manateepao.com/dnn/Portals/0/AdditionalDownloads/manatee_ccdf.zip 20190128 downloaded Please Note: Roughly 100,000 NAL records were not mapped statewide, additionally roughly 90,000 GIS data records did not join to tabular NAL data with the majority being undocumented ROW and Water features. Step 15: Added and populated the following fields: IMPROVVAL, PARUSEDESC, SOURCEDATE, EXMPT, LU_RES, LUCODE, DESCRIPT, FLAG, AUTOID LU_RES = 'YES' for all of the following LUCODEs; 001, 002, 003, 004, 005, 006, 007, and 008. IMPROVVAL = JV LNDVAL EXMPT AFF: Affordable housing property exemption was noted in the NAL table for any or all of the following fields: EXMPT_03, EXMPT_04 and EXMPT_15. CON: Conservation property exemption was noted in the NAL table for any or all of the following fields: EXMPT_36 and EXMPT_37. HOM: Homestead property exemption was noted in the NAL table for any or all of the following fields: EXMPT_01 and EXMPT_02. Step 16: Added leading zeros back to DORUC NULL DORUC records were calculated to 100. Reviewed DORUC = 100, updated records where features presented as Right-of-Ways (ROW) to 101, and Waterbodies to 102. Step 17: For fields PHYCITY and PHYZIP whose values were NULL created Label Point features and spatially joined these points to a zipcode layer. Joined back updated point layer to statewide polygon layer based on GCID and updated missing information. Marked FLAG field for features that were updated (CZ). Reviewed and updated PHYZIP records whose values did not align with Florida zipcode ranges. Reviewed and updated PHYCITY records whose values included FL by removing State of Florida abbreviation. Reviewed and updated PHYCITY records whose values included CITY OF by removing the additional text. Reviewed PHYADDR1 and PHYADDR2 fixed missing data in PHYADDR1. Step 18: Reviewed ACTYRBLT and EFFYRBLT fields for abnormalities, fixed roughly 10 records in each whose value was incorrect: Example: 1045 was updated to 1945, please note most of the records were for Mobile home sites. Step 19: Removed fields that were not pertinent to FDOT use, for example EXMPT_* fields etc. Please Note: Removal of fields was necessary for database speed and to decrease database crashes due to memory issues. Step 20: Added roughly 47 missing polygons created by GeoPlan that have appear in previous versions of parcels such as 2017. As counties add these missing features the count added by GeoPlan is slowly going down. Step 21: Determined Longest Records for each field and restructured field lengths and types to decreases FGDB file size and speed tabular searches. Restructured field names to match that of previous version for better conversion to Shapefile if necessary. Step 22: Upper cased records for all text fields. Step 23: Calculated field GOOGLEMAP to the following: "https://www.google.com/maps/place/" & [MGRS] Step 24: Updated Metadata Process Date: 20190312

MAP PROJECTION PARAMETERS:

Projection                          ALBERS
Datum                               HPGN
Units                               METERS
Spheroid                            GRS1980
1st Standard Parallel               24  0  0.000
2nd Standard Parallel               31 30  0.000
Central Meridian                   -84 00  0.000
Latitude of Projection's Origin     24  0  0.000
False Easting (meters)              400000.00000
False Northing (meters)             0.00000

DATA SOURCE CONTACT (S):

Name:
Abbr. Name:
Address:


Phone:

Web site:
E-mail:
Contact Person:
         Phone:
        E-mail:

University of Florida GeoPlan Center
GeoPlan
131 Architecture Building, PO Box 115706
Gainesville, FL
32611-5706
www.fgdl.org


www.fgdl.org
data@fgdl.org
Kate Norris

Name:                   FLORIDA GEOGRAPHIC DATA LIBRARY
Abbr. Name:             FGDL
Address:                Florida Geographic Data Library
                        431 Architecture Building
                        PO Box 115706
                        Gainesville, FL  32611-5706
Web site:               http://www.fgdl.org

Contact FGDL: 

      Technical Support:	        http://www.fgdl.org/fgdlfeed.html
      FGDL Frequently Asked Questions:  http://www.fgdl.org/fgdlfaq.html
      FGDL Mailing Lists:		http://www.fgdl.org/fgdl-l.html
      For FGDL Software:                http://www.fgdl.org/software.html