search

straup / whereonearth-metropolitan-area

7 stars 4 forks source link

Should preserve the GeoNames.org uniqueID #1

Closed nvkelso closed 12 years ago

nvkelso commented 12 years ago

present in Natural Earth. Those are much more stable than a FID.

straup commented 12 years ago

There's a GeoNames ID? Where? What's it called? I just opened the 10m shapefile and didn't see it in the properties...

nvkelso commented 12 years ago

Ha, I see. You grabbed the urban areas directly and then did a spatial join on them. Using what? The Natural Earth populated places included a GeoNames.org ID, the urban areas do not. I've tried to hack that a couple times. I should revisit it and compare with what you've done.

straup commented 12 years ago

Spatial join?

I just grabbed the shapefile and convered it to a GeoJSON file (using ogr2ogr) because it's easier to work with and then chunked all the records to individual files, assigning artisanal/WOE IDs along the way.

Now that that's done I'm rolling through them all calculating ancestors and eventually the children which is where the pop. places will fit in. Those need to be geocoded (like whereonearth-state) to get there WOE ID and then eventually checked to see which urban area they're contained.

Unless that data is already in the pop. places data which would be awesome. If not, then soon enough...

straup commented 12 years ago

See also:

https://github.com/straup/whereonearth-metropolitan-area/tree/master/meta#populated-places-concordancecsv