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

Missing geometry in history tables #27

Open
nanodan opened this issue Oct 8, 2020 · 4 comments
Open

Missing geometry in history tables #27

nanodan opened this issue Oct 8, 2020 · 4 comments

Comments

@nanodan
Copy link
Collaborator

nanodan commented Oct 8, 2020

select geometry is null as IsNull, count(1) Cnt
  from `bigquery-public-data.geo_openstreetmap.history_ways` 
 group by 1

Returns 274,408,759 empty geometries and 1,042,637,220 that have geometries. This seems to happen whenever there are no tags, similar to #26

@allenday
Copy link
Contributor

@nanodan please submit this as a bug report upstream to gdal. That's The right place for it to be fixed, and when it is the fix will propagate to BQ, although it will require a full history reprocessing (we will do this)

@nanodan
Copy link
Collaborator Author

nanodan commented Nov 22, 2020

OSGeo/gdal#3208

@nanodan
Copy link
Collaborator Author

nanodan commented Nov 22, 2020

@allenday I opened a ticket with the gdal folks but they want more details on the process before anything is actionable. Could someone address their questions in that ticket as I don't know the intimate details of your conversion and upload process.

@nanodan
Copy link
Collaborator Author

nanodan commented Feb 14, 2022

Note that this was closed in GDAL for lack of further details to action on their side. Can someone with more knowledge of Google's ingestion process re-open that ticket?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants