4 ms·
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
by Vespasian 11y ago
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.
- maze-le 11y agoIt 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.
- maze-le 11y agoActually, according to the resource-file is isn't Natural Earth after all. The column-names almost fit the NE-Datasaet though...
- anc84 11y agoThe SOURCE.md file only lists Natural Earth.
- Vespasian 11y agoFor 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 ;)
- marco1 11y agoWe should definitely fix this in the future! Thank you :)
- marco1 11y agoYou're right! Please see the "SOURCE.md" file for all necessary information. Sorry for not linking this file in a prominent place!
- jerrysievert 11y agounfortunately, 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.
- marco1 11y agoThank 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.
- funkysquid 11y agoLooks like they include instructions on how to build in SOURCE.md (https://github.com/delight-im/FreeGeoDB/blob/master/SOURCE.md https://github.com/delight-im/FreeGeoDB/blob/master/SOURCE.m...) - would be great to have that linked in the README though.
- marco1 11y agoThanks! We'll have to add a link to the README, you're right!
- marco1 11y agoExactly! 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!