For a wider listing of diplomatic entities, consider using Open Street Maps.
For example, you can use the Tag: amenity=embassy. This data source includes the following dimensions:
Wikidata has a lot of data about embassies and consulates.
I created a Python+SPARQL script that pulls that data and maintains an easy-to-consume CSV file. You can download the CSV file at https://database-of-embassies.github.io.
OpenAddresses.io does not have nearly 100% coverage but you may get lucky: http://results.openaddresses.io/
Open Street Map ("OSM") is another potential source: https://gis.stackexchange.com/questions/121266/extracting-list-of-addresses-in-particular-region-from-openstreetmap-osm-data
One less expensive option may be to buy voter registration lists from ...
I don't know specifics on how Zillow, etc acquired their data - other than assuming they (or 3rd party) obtains the data on a per county basis.
As cities/counties open up open data portals, this data will become more accessible to developers.
When searching these portals, you want to look for tax lots, property tax, or parcels.
A lot of these datasets are ...
Official lists maintained by government bodies:
The dc.gov (Washington, DC) has a dataset for all embassies in Washington, DC:
This data.gov dataset lists all US embassies/consulates in the World:
This open.canada dataset lists ...
It says: Data: OpenStreetMap in the image.
You can download OpenStreetMap data dumps in a variety of formats, such as shape-files. Like a database, it will contain nodes of certain types, including one for pubs. They will all include geographic coordinates. Simply extract all the nodes that are pubs and you're there.
I will answer this in the more general term (leaving the consumer out). Invariably when data is aggregated and coalesced from plural data sources you will have conflicts in records. Just think of all the wacky occupants you receive in your mailbox or the wacky places you supposedly lived when you do a FREE background search.
These data sources need to ...
The French government has just launched a national open database that aims to contain all currently valid addresses: http://adresse.data.gouv.fr
It is a collaboration between the government, the French National Geographic Institute, the postal service, and OpenStreetMap.
800 megabytes, one CSV file per French departement, WIN1252 encoding.
The data can be ...
While I don't have direct experience with Japanese material, a quick search for Japan cadastral material reveals that this data might not exist in a digital form.
"[The] lack of progress in surveying land in the Tokyo metropolitan area has become a serious problem" – Japan Times, "Property borders: Where to draw the line", 2 January 2015
The Ministry of ...
Why not use OSM Buildings data?
Microsoft released US Building Footprints dataset but you are going to want to ensure accuracy. I've read/seen examples where it is not 100% accurate.
OSM Buildings References:
Fetching Building Data with OSM
Extracting Building Footprints from OpenStreetMap
How to Download OSM 3D Building Data
In the first link in the original post, among the many datasets available in Japanese there is a resource from the Ministry of Land, Infrastructure and Transport that provides geocoordinates for addresses in most Tokyo wards and cities. The resource is
For example, there are around 178,000 building ...
The US NGA/GNS Server contains geographic datasets for every country in the world. It does not contain shapefiles, but does have area centroids for at least:
Capitals (both country and administrative divisions).
Other Populated Localities.
OpenCorporates is the only open database of companies in the world that I am aware. They provide addresses and other data. Not sure if they have phone numbers. But I guess it is the best free, open option you have.
For example, here you can find all companies with the keyword Subways. You can filter it bases on the countries and states you want. Then ...
You can find the dataset here -:
P.S- I worl for datazar, an open source datalibrary, where people can share, discover and work with data.
Just to detail my findings about Andrew's first link (embassies in Washington, DC):
The data file can be found at http://geospatial.dcgis.dc.gov/dc_kmz/Culture_and_Society/DCG9_Miscellaneous_EmbassyPt/DCG9_Miscellaneous_EmbassyPt/DCG9_Miscellaneous_EmbassyPt.kmz
Once unzipped, open the doc.kml file, it contains such an item for each embassy:
How you can improve it depends very much on how you want to use it, and who you want it to be useful for. 'Valid' RDF is fine, but may not be useful depending on your intended application! If you want it to be helpful to open/linked types, publishing it using other 'accepted' vocabularies is good (although schema.org is the best catch-all, it is not always ...
Do you have reasons to believe that addresses of these establishments (the casino being a structure) can change?
Anyway, my best bet is to look for their EIN (Employer Identification Number) with the IRS and go over the forms they submitted through the years. For the Wheeling Island Hotel-Casino-Racetrack I found a SEC filing mentioning it, as part of the ...
Good question. The first address added to a company in Crunchbase is assigned the headquarter relationship. If a new HQ is subsequently added, it can be selected and reset on crunchbase.com on the top card.
Geonames has postal codes but they're per city not per ADM1.
Eg the city https://www.geonames.org/728378/pazardzhik.html shows post=4400, and in Hierarchy shows its parent ADM1 https://www.geonames.org/728379/pazardzhik.html.
This is available in structured data, so you need to find all populated places (featureClass=P) per ADM1 and collect their postal ...
It's mentioned in the comments, but in addition to google maps geocoding API, you can use Nominatim geocoding from OSM.
Here's an example query based on latitude and longitude:
which resolves to this address:
Yo can get all the required data from official website data.gov.in. The data seems to be divided into state level, so maybe you will have to download ~31 csvs'. They have csv, ods, etc. they also support api calls, yo can check this feature, which could save you from downloading separate files.
You could do this with a few lines of R, taking the spatial over of the roads file and the block file, then iterating through the list and dumping it to a nice table. I'm not sure of any other way to do this.
If i may, can i add one more platform called CSV2GEO that does batch geocoding , reverse geocoding and plenty other geolocation services. It has hybrid price model of free and paid options. The system can process from single line to millions of records.
Disclaimer: I founded CSV2GEO.
List of Open/Open Source/Free-ish Geocoding Services and Tools (2017-05-10)
A coarse forward & reverse geocoder in scala.
Geonames Geocode Webservice
A widget for finding addresses and landmarks, and flying the camera to them. Geocoding is performed using the Bing Maps Locations API.
Complete Ruby geocoding ...