Hot answers tagged

12

OpenStreetMap has quite an easily accessible database of restaurants (and other places), which you can easily query using their Overpass API. An example query for Overpass's Query Form which gets all restaurants in greater London: <query type="node"> <has-kv k="amenity" v="restaurant"/> <bbox-query s="51.28" n="51.686" w="-0.489" e="0.236"...


12

You mention you want data sources, so I'm going to focus on where you can get information that helps match street addresses to coordinates, rather than APIs. If you can, go with a web service, but there's a certain masochistic pleasure in building your own geocoder from raw data! OpenStreetMap is the most comprehensive worldwide source, and has good ...


11

Openstreetmap has an API which gives coordinates for an address, see Stackoverflow for an example


8

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: "lat" "lon" "tags": { "addr:city" "addr:country" "addr:housenumber" "addr:postcode" "addr:street" "amenity" "contact:email" "contact:fax" ...


7

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. Data sample: operator;operatorQID;jurisdictions;jurisdictionQIDs;country;countryQID;city;cityQID;address;latitude;longitude;phone;...


7

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 ...


7

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 ...


7

The SimpleGeo point of interest dump of 21m places is the best open data set I know of, though it's getting pretty long in the tooth these days and so won't have the up-to-date-ness you're looking for: http://archive.org/details/2011-08-SimpleGeo-CC0-Public-Spaces


6

FWIW, Karsten W.'s suggestion uses R, so I'm not sure what your tool of choice is, but here're two other options: 1.) A Python client, geopy, that hooks into the geocoders from: • GoogleV3 • Yahoo! • geocoder.us (free for non-commercial use, accounts available for commercial uses) • GeoNames • MediaWiki • Semantic MediaWiki I've used it for years. It's ...


6

Official lists maintained by government bodies: United States The dc.gov (Washington, DC) has a dataset for all embassies in Washington, DC: http://data.octo.dc.gov/metadata.aspx?id=77 This data.gov dataset lists all US embassies/consulates in the World: https://catalog.data.gov/dataset/country-specific-information Canada This open.canada dataset lists ...


5

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.


5

Wikivoyage has open data about restaurants and bars, worldwide, pretty up-to-date. The data is licensed under Creative Commons Attribution/Share-Alike. The format is like this: {{eat | name=Atelier de Joel Robuchon | url=http://www.robuchon.jp/latelier | email= | address=Roppongi Hills Hillside 2F, 6-10-1 Roppongi | lat=35.660197 | long=139.728804 | ...


4

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 ...


4

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 ...


4

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 ...


3

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 http://www.data.go.jp/data/en/dataset/mlit_20140919_3059 For example, there are around 178,000 building ...


3

Texas A&M Geoservices has a few Geocoding Services/Tools available, however they are for the U.S. only.


3

Firstly, "geocoding" is the name of the task you're trying to achieve (might help with future Googling). The Geocommons geocoder is one example of an open-data-driven geocoder; I think they mostly use US Census data. (As that example illustrates, a lot of this kind of data is country-specific, so a bit more detail in your question may produce better ...


3

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: Administrative Divisions Capitals (both country and administrative divisions). Incorporated Cities Other Populated Localities. http://earth-info.nga.mil/gns/html/namefiles.htm


3

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: OSM Wiki Fetching Building Data with OSM Extracting Building Footprints from OpenStreetMap How to Download OSM 3D Building Data


2

The GADM Database of Global Administrative Areas attempts to capture all the administrative areas of all countries at all levels. You download all the data for an entire country. The adminstrative units don't go down to zipcodes for Germany. While the license is not the most liberal, it is free for academic or noncommercial use.


2

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 ...


2

You can find the dataset here -: https://www.datazar.com/project/p3d688124-3fc2-4130-9532-429780fb4d81 P.S- I worl for datazar, an open source datalibrary, where people can share, discover and work with data.


2

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: <Placemark ...


2

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 ...


2

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 ...


2

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.


2

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: https://nominatim.openstreetmap.org/search.php?q=51.108236%2C+13.631143 which resolves to this address: https://nominatim.openstreetmap.org/details.php?place_id=172430942 Address ...


2

You can try in Kaggle datasets. For example https://www.kaggle.com/openaddresses/openaddresses-europe contains the list of addresses in Europe per country.


2

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 ...


Only top voted, non community-wiki answers of a minimum length are eligible