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

Alaska missing a lot of areas/buildings? #81

Open
chris opened this issue Sep 30, 2022 · 0 comments
Open

Alaska missing a lot of areas/buildings? #81

chris opened this issue Sep 30, 2022 · 0 comments

Comments

@chris
Copy link

chris commented Sep 30, 2022

In looking at the latest data for Alaska (the 2020/downloaded the Alaska data in the last 6 months), it seems it only covers part of the state. For example, if I import all the Alaska buildings into PostGIS, and then do an ST_ConvexHull to get a bounding polygon (see query below for reference) for where these are, I see this:

geojson_io

Yet, I see there are buildings in places like Nome and Dillingham (where the two arrows are), as well as many others. I've queried for buildings in these areas and don't find them. Am I missing something? Or is the Alaska data less complete, or?

Bounding polygon query I used (note that I have added a state column in my DB, and set it to the particular state when importing each state):

SELECT st_asgeojson(ST_ConvexHull(ST_Collect(wkb_geometry))) AS ak_bound FROM buildings_usa WHERE state = 'Alaska';
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

1 participant