GIS Data and Map Coordinates

Florida Department of Revenue Data

The Department of Revenue publishes shape files for every property in Florida.  Download from

The shape files use NAD 83 (HARN) projection.  Use ogr2ogr ( setup/build instructions for ogr2ogr) to convert to them WGS 84:

ogr2ogr -t_srs WGS84 outfile_wgs84.shp infile_harn.shp

Use shp2sdo to generate a SQL Loader file for the converted shp file:

#!/bin/bash
./shp2sdo.exe -o ./geo2012wgs84/g11 pr_geo11 -g GEOM -i ID -n 110000000 -s 8307 -f # alachua
./shp2sdo.exe -o ./geo2012wgs84/g12 pr_geo12 -g GEOM -i ID -n 120000000 -s 8307 -f # baker
./shp2sdo.exe -o ./geo2012wgs84/g13 pr_geo13 -g GEOM -i ID -n 130000000 -s 8307 -f # bay
./shp2sdo.exe -o ./geo2012wgs84/g14 pr_geo14 -g GEOM -i ID -n 140000000 -s 8307 -f # bradford

... etc

 

County Data

1.  Download Parcel File Coordinate data:

2.  Unzip the files and stage in a local disk drive. 

3.  Brevard dbf file can be opened using Excel.  Create a System DSN then open Excel
Select Data-> Other Sources-> ODBC
Open the Address node in the Query Wizard and Select:

RENUM
LONGITUDE
LATITIUDE

Sort by RENUM
Save as .csv

4. Brevard and Orange dbf files can be opened using Whitetown CDBF.  Open the file then Save As a CSV file.

5. Volusia GIS data is delivered as a ESRI Shapefile.  The map coordinates are expressed using a NAD 83 (HARN) projection. They need to be converted to WGS 84. This can be done using Map Window4.

  • Open a new project. 
  • Click on the Projection drop down in the bottom left corner of the screen. 
  • Select WGS 84 in the Select Projection dialog and press OK
  • Click the Add Map Layer button on the main menu bar.
  • Select the Volusia address.shp file
  • MapWindow will detect a projection mismatch and ask how to handle it.
  • Select Reproject file.  This will generate a new set of Shape files

6. Export the WGS 84 Shape file to CSV

  • Select Spatial Converter from the Plugin menu
  • Export from a shapefile to CSV
  • Select the shape file

Setup a geo code server to geocode any address: