Hotel Building Polygons (Footprints)

For each hotel, the footprint of the building it occupies, as a WKT MULTIPOLYGON in WGS84 (EPSG:4326), with its area in square metres, where the footprint came from, and a grade from A to E for how confidently the building matches the hotel.

Hotel Eden Nord Soller · 950 m² · grade A · source: OpenStreetMap (osm_name)

Fields

Building polygon columns
ColumnMeaningAvailability
building_polygon_wktA MULTIPOLYGON in WGS84 (EPSG:4326).in sample
building_area_m2Footprint area in square metres.in sample
building_idBuilding identifier from the source dataset.in sample
building_nameBuilding name, where the source has one.in sample
polygon_sourceoverture_contains, osm_name or overture_nearest (see below).in sample
building_match_gradeMatch confidence grade, A (highest) to E (lowest).in sample
building_match_scoreNumeric match score behind the grade.in sample
building_dist_mDistance from the hotel point to the building, in metres (0 when inside).in sample
building_osm_idOpenStreetMap ID of the building, where matched by name.in sample
building_osm_nameOpenStreetMap name of the building.in sample
places_inside_buildingNumber of other places located inside the same building.in sample
contained_places_categoriesCategories of the places inside the building.in sample

Polygon sources

How footprints were matched in the sample
polygon_sourceMeaningHotels
overture_containsThe hotel point lies inside an Overture building.102
osm_nameAn OpenStreetMap building whose name matches the hotel.76
overture_nearestThe nearest Overture building to the hotel point.37

Match grades in the sample

215 of the 250 sample hotels (86%) have a polygon; the median footprint is 946 m². Grades are match confidence: A is the highest confidence and E the lowest. We recommend grades A–B for automated use and a review for C–E.

Polygon match grades (building_match_grade), of 250 hotels
GradeHotelsShare
A15462%
B2410%
C146%
D177%
E62%
No polygon3514%

Footprints from the sample

Viva Maya by Wyndham · 1,539 m² · grade A · source: Overture (overture_contains)
Holiday Inn New York City - Times Square by IHG · 548 m² · grade A · source: Overture (overture_contains)
Paradise Beach Hotel · 678 m² · grade A · source: OpenStreetMap (osm_name)

The WKT of the first footprint, as it appears in building_polygon_wkt:

MULTIPOLYGON (((2.6967423 39.7994039, 2.6968025 39.7992372, 2.6970276 39.7992449, 2.6970236 39.7993252, 2.6971609 39.7993453, 2.6971311 39.799438, 2.6971048 39.7994342, 2.6971057 39.7994244, 2.6969995 39.7994209, 2.6969874 39.7996061, 2.6967543 39.7995984, 2.6967637 39.799406, 2.6967423 39.7994039)))

How to load it

The polygons are plain WKT text in a CSV or Excel column, so any GIS tool reads them. The guide Load hotel polygons (WKT) covers each tool step by step.

GeoPandas

import pandas as pd, geopandas as gpd
from shapely import wkt

df = pd.read_csv("hotels.csv")
df = df[df["building_polygon_wkt"].notna()]
gdf = gpd.GeoDataFrame(df, geometry=df["building_polygon_wkt"].apply(wkt.loads), crs="EPSG:4326")

PostGIS

ALTER TABLE hotels ADD COLUMN geom geometry(MultiPolygon, 4326);
UPDATE hotels SET geom = ST_GeomFromText(building_polygon_wkt, 4326)
WHERE building_polygon_wkt IS NOT NULL;

QGIS

Layer → Add Layer → Add Delimited Text Layer, choose the CSV, then under Geometry definition select Well known text (WKT), pick building_polygon_wkt as the geometry field and EPSG:4326 as the CRS.

Converting to GeoJSON

gdf.to_file("hotel_buildings.geojson", driver="GeoJSON")

Or with GDAL: ogr2ogr -f GeoJSON hotel_buildings.geojson hotels.csv -oo GEOM_POSSIBLE_NAMES=building_polygon_wkt -a_srs EPSG:4326

Uses

See mapping, GIS and geofencing.

Attribution

Building footprints are derived from OpenStreetMap (© OpenStreetMap contributors, ODbL) and Overture Maps Foundation data, and keep their original licences. Details are on the methodology page.

See it in the free sample

The Excel sample has 250 real hotel rows with these columns. Enter your name and work email to get the link.

By downloading you agree to our privacy policy.

Get the data

Download the free Excel sample to see every column with real rows, or tell us the countries and fields you need for counts and a quote. We reply within 24 hours.

Download free sample Contact us