Anyone know of a source for sample data of addresses?

Question

Hi all; Anyone know of a source for getting 50 - 500 addresses, for a city, in a spreadsheet format (csv, xlsx, anything)? All I can find is 10+ in an index card for each. And one that gave an address per line text format - with NO commas. thanks - dave

Answer 1

A really good set of real addresses around the world for testing can be found here: https://results.openaddresses.io/ As a bonus it includes latitude and longitude. Some data clean up may be needed (remove "UNKNOWN" and blank address lines values). If you don't need it for a specific location, the Azure Maps sample site has a couple of data files you could potentially use: https://github.com/Azure-Samples/AzureMapsCodeSamples/tree/main/Static/data

Here are some of the CSV files that have addresses:

• https://github.com/Azure-Samples/AzureMapsCodeSamples/blob/main/Static/data/SpatialCSV/Chicago_Police_Stations.csv
• https://github.com/Azure-Samples/AzureMapsCodeSamples/blob/main/Static/data/SpatialCSV/Chicago_Bike_Racks.csv

Some sample sin GeoJSON format:

• https://github.com/Azure-Samples/AzureMapsCodeSamples/blob/main/Static/data/geojson/SamplePoiDataSet.json
• https://github.com/Azure-Samples/AzureMapsCodeSamples/blob/main/Static/data/geojson/US_farmers_markets.json
• https://github.com/Azure-Samples/AzureMapsCodeSamples/blob/main/Static/data/geojson/address.json
• https://github.com/Azure-Samples/AzureMapsCodeSamples/blob/main/Static/data/geojson/address_optimized.json