Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Division areas wrapping around Earth #236

Open
honeybadger93 opened this issue Oct 2, 2024 · 0 comments
Open

Division areas wrapping around Earth #236

honeybadger93 opened this issue Oct 2, 2024 · 0 comments
Labels
bug Something isn't working divisions

Comments

@honeybadger93
Copy link

honeybadger93 commented Oct 2, 2024

Hello,

For a handful of places, I've noticed that the geometry area is inverted at places, causing an area that wraps around the globe. The ones I noticed have been countries, a few broken out in the query below. Screenshot is from taking Fiji's geometry and plugging it into geojson.io. I'm accessing the data through Carto's snowflake catalog. For the US, some tiny island in Alaska triggered it, so it seems to be Multipolygons triggering it.

SELECT DA.GEOMETRY
FROM OVERTURE_MAPS__DIVISIONS.CARTO.DIVISION D
         LEFT JOIN OVERTURE_MAPS__DIVISIONS.CARTO.DIVISION_AREA DA ON DA.DIVISION_ID = D.ID
WHERE D.ID IN (
    '08532860bfffffff0189fef318192d15' --Fiji
    , '0850c861bfffffff01aeb407d56d3441' --USA
    ,'085f12e4ffffffff01a7ecbe4b50fb48' --Tuvalu
   ,'085012b1bfffffff01e24b3e5cecdf2a' --Russia
    )
image
@atiannicelli atiannicelli added divisions bug Something isn't working labels Oct 14, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working divisions
Projects
None yet
Development

No branches or pull requests

2 participants