Show HN: Free database of geographic place names and geospatial data

Re:Show HN: Free database of geographic place names and geos... by Vespasian on Friday September 25, 2015 @05:26AM (#10277094)

So this is bascially Natural Earth repacked as JSON, CSV and SQL?

It's a nice start. I like it. Would it be possible to add the programm /instructions you used for converting the data from their original shape?

I would love to see an additional SQL version for PostGIS and the likes so that I can use their a large number of spatial functions to work with this data.

[ Parent | on HN ]

Re:Show HN: Free database of geographic place names and geos... by maze-le on Friday September 25, 2015 @05:32AM (#10277117)

It seems to be the Natural Earth Dataset -- I think the 1:50m-resolution, but with a slightly reduced set of properties (columns). I haven't tried it, but from the looks of it, the sql-files should work with PostGIS as they are.

[ Parent | on HN ]

Re:Show HN: Free database of geographic place names and geos... by Vespasian on Friday September 25, 2015 @10:35AM (#10278373)

For what I've seen the data type of the columns is always varchar and not geometry.

Not a big issues merely it's more convenient otherwise ;)

[ Parent | on HN ]

Re:Show HN: Free database of geographic place names and geos... by marco1 on Friday September 25, 2015 @06:26PM (#10281090)

We should definitely fix this in the future! Thank you :)

[ Parent | on HN ]

Re:Show HN: Free database of geographic place names and geos... by marco1 on Friday September 25, 2015 @06:27PM (#10281096)

You're right! Please see the "SOURCE.md" file for all necessary information. Sorry for not linking this file in a prominent place!

[ Parent | on HN ]

Re:Show HN: Free database of geographic place names and geos... by maze-le on Friday September 25, 2015 @06:37AM (#10277306)

Actually, according to the resource-file is isn't Natural Earth after all. The column-names almost fit the NE-Datasaet though...

[ Parent | on HN ]

Re:Show HN: Free database of geographic place names and geos... by anc84 on Friday September 25, 2015 @07:32AM (#10277517)

The SOURCE.md file only lists Natural Earth.

[ Parent | on HN ]

Re:Show HN: Free database of geographic place names and geos... by funkysquid on Friday September 25, 2015 @02:19PM (#10279759)

Looks like they include instructions on how to build in SOURCE.md (https://github.com/delight-im/FreeGeoDB/blob/master/SOURCE.m...) - would be great to have that linked in the README though.

[ Parent | on HN ]

Re:Show HN: Free database of geographic place names and geos... by marco1 on Friday September 25, 2015 @06:25PM (#10281086)

Thanks! We'll have to add a link to the README, you're right!

[ Parent | on HN ]

Re:Show HN: Free database of geographic place names and geos... by marco1 on Friday September 25, 2015 @06:25PM (#10281082)

Exactly! Thanks. Although to some it may be "just Natural Earth", we thought it could be useful. JSON, CSV and SQL should be more helpful than the original shape files when building (web and mobile) applications.

We'll love to extend the data to make it ready for PostGIS etc. Will be useful!

[ Parent | on HN ]

Re:Show HN: Free database of geographic place names and geos... by jerrysievert on Friday September 25, 2015 @11:51AM (#10278817)

unfortunately, while it is in JSON, it is not in GEOJSON, nor anything that appears to be standard.

at least the points are in WKT, so should be able to be converted into something useful.

[ Parent | on HN ]

Re:Show HN: Free database of geographic place names and geos... by marco1 on Friday September 25, 2015 @06:28PM (#10281099)

Thank you! We'll love to hear and discuss what's the best way to represent and store the data. We're open to changes between GeoJSON, WKT, etc.

[ Parent | on HN ]