GeoPlan Center Process Steps: Downloaded Spatial/GIS (20190812) and NAL Parcel data (20191231) information from the following FDOR FTP websites (ftp://sdrftp03.dor.state.fl.us/) Map Data: ftp://sdrftp03.dor.state.fl.us/Map%20Data/ ftp://sdrftp03.dor.state.fl.us/Map%20Data/2019%20PIN%20Data%20Distribution/ FDOR GIS Data Download Disclaimer.pdf GIS Shapefiles Download - Read First Counties must deliver their parcel-level GIS data to the Department of Revenue by April 1 each year. Each county generates parcel shapefiles in late March. These are usually available for download in early May. Users should be aware of potential parcel identification number formatting issues when using .csv formatted NAL or SDF files and may download DBF files to use with parcel shapefiles. Miami-Dade and St. Johns counties maintain condominium property in files separate from their parcel shapefiles. The additional files are included for download. Additional, or more complete, GIS data may be available by contacting county property appraisersâ offices directly. ftp://sdrftp03.dor.state.fl.us/Map%20Data/Readme%20First.pdf Tax Roll Data Files: 2019 Final NAL - SDF Files ftp://sdrftp03.dor.state.fl.us/Tax%20Roll%20Data%20Files/2019%20Final%20NAL%20-%20SDF%20Files/ 2018_NAL_SDF_NAP_Users_Guide (2019 documents were not posted) 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_20191231 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_20191231 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 2018 version. Results of Spatial Review: Duval County: 40-inch shift (>1m)[FIXED SEE BELOW] Marion County: 14-inch Shift (moved back to 2017 location) Miami-Dade County: 5-Inch Shift (moved back to 2017 location) Contacted Duval County about 1m shift, downloaded and used newer data directly from the following website to remove 1m shift: Duval County PA - Data Offerings https://www.coj.net/departments/property-appraiser/information-offerings GIS DOWNLOADS - AT TIME OF CERTIFICATION https://www.coj.net/departments/property-appraiser/property-appraiser-online-forms/duval_pao_gis_shapefiles_10_1_2019.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: Used 23_MiamiDadeGISCondos.zip which was available for download from FDOR with rest of GIS County Parcel Data. Determined PARENT parcel ids for missing Miami-Dade NAL information. Created Query Table with master Parcels_2019 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_2019 layer. Query Table Tip Put NAL subset (with Parent id) in same folder with parcel subset that matches parent (2019 had roughly 6600 parcels) Fields: Select All (Button) Expression: Hint: Remove Quotes "NAL_TEMPLATE_2019_Missing_V1_parent_id.NPARNO_PARENT" = "NAL_TEMPLATE_2019_Missing_V1_parent_id.NPARNO_T" NAL_TEMPLATE_2019_Missing_V1_parent_id.NPARNO_PARENT = NAL_TEMPLATE_2019_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: Used the stjohns_condos.zip which was available for download from FDOR with rest of GIS County Parcel Data, and performed the same steps as above to add missing Condo information for roughly 30,000 records. Please Note: Roughly 100,000 NAL records (60,000 of which were subsurface rights) 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 and updated PHYCITY records whose values included COUNTY. 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
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.