Skip to content
Snippets Groups Projects

Resolve "Add height from GHSL characteristics"

Merged Laurens Oostwegel requested to merge 18-add-height-from-ghsl-characteristics into main
@@ -40,14 +40,14 @@ class GHSLCharacteristicsInformation:
ST_Area(
ST_Intersection(geom, ST_Buffer(ST_GeomFromText('{geometry_wkt}', 4326),0)
), True)
) AS area
)
"""
# Select the type with the largest overlap with the building.
sql_statement = f"""
SELECT type
FROM (
SELECT type, {get_area_function}
SELECT type, {get_area_function} AS area
FROM ghsl_characteristics
WHERE geom && ST_GeomFromText('{geometry_wkt}', 4326)
GROUP BY type
Loading