Looking for an open database of lat/long co-ordinates for hotels. I am aware of sites like Factual.com but I'm looking for something more open.
OpenStreetMap (OSM) to the rescue, I would say. According the the OSM Wiki, hotels can be found within the database by the tag
A quick check using the Overpass API, shown here for an excerpt of Rome, Italy; result:
153 nodes (hotels) only in the visible area, tagged with name, operator, website, phone number. YMMV, depending on exact location.
While OSM is the most obvious place for open data about hotels, the second best place might be Wikivoyage.
The data is available as CSV under the Creative Commons Attribution-ShareAlike 3.0 License: https://github.com/baturin/wikivoyage-listings
- Wikivoyage's goal is not to list ALL hotels, but to list for each destination about 10 hotels in each of 3 price ranges. Hotels are selected for value and cachet by Wikivoyage editors in a democratic and usually unbiased process. That might suit your purpose better than an indiscriminate list which would also contain unrecommended hotels.
- Not all hotels have GPS coordinates yet.
- We do not run the tool often, so the data files are probably quite old. But it is open source and can be run by anyone. Maintainers welcome!
- Formats: CSV, KML, GPX, OBF (OpenStreetMap), etc.
Here's how I would start. I would contact the customer support for each major hotel chain and inquire on how to make a request for a copy of all their locations in electronic format (e.g., CSV file). If you get any datasets, post them somewhere (e.g., github) and leave a link here for the rest of us to use.
Uncertain what your geographic interests are but for US take a look at data from Rutgers U. It's free and open for non-commercial uses. Data is available by state so you'll probably have to download 50 or so files.
The data has detailed information about businesses. You could search by Standard Industry Code for hotels. Some records have lat/long - most do not.
Use an online bulk geo coder to get lat/long.
Uncertain how up-to-date or complete the data is.
You can negotiate to buy all worldwide hotels data from
They actually have collected almost all planet accommodation properties. It is not free, but it is the most affordable. The database is comprehensive with contact details and hotels images.
(Note: I am affiliated with this site)