OvertureMaps / OvertureMaps/data
Land_use data with invalid coordinates
Open
@jenningsanderson is already working on this.
Since Jun 25, 2025.
- Dominant language
- Python
- Stars
- 1.2k
- Forks
- 47
- Avg merge
- 3h 42m
- Merged PRs (30d)
- 1
Description
I wonder whether there should be some rounding of decimals or clipping of data in the land_cover data, as there are polygons with points which are not valid latitude/longitude values (and selfishly it's causing issues with my workflow).
df = sql("select * from parquet.`s3a://overturemaps-us-west-2/release/2025-01-22.0/theme=base/type=land_cover/`")
spark.sql("DROP VIEW IF EXISTS raw_land_cover")
df.createOrReplaceTempView("raw_land_cover")
display(sql("""SELECT min(st_xmin(st_geomfromwkb(geometry))),
min(st_ymin(st_geomfromwkb(geometry))),
max(st_xmax(st_geomfromwkb(geometry))),
max(st_ymax(st_geomfromwkb(geometry)))
FROM raw_land_cover"""))
Result is:
xmin = -180.0002
ymin = -80.5534937
xmax = 180.0002
ymax = 82.8592396
Thanks.
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Assessment
This issue has not been assessed yet.