The project maps addresses of St. Andrews in Venice, Florida, to a map. The map is created with leaflet. St. Andrews is 388 separate properties in 14 subdivisions.
The data comes from the Sarasota County Property Appraiser for the property records and the Sarasota County GIS for the subdivision boundaries.
The property records are not geocoded, so the addresses need to be assigned a latitude and longitude. The records have two columns regarding address with the first portion being a street address like "123 Main St." and the second portion being a building and unit number. The second portion was inconsistent and only the first portion could be used.
This resulted in a building with 8 residents having 8 points fixed to the same location. This was fixed by manually moving each of the points within QGIS and exporting the data back to the project. Not great for reproducibility, but resulted in a much better and more accurate map.