Email or username:

Password:

Forgot your password?
Gregory's posts Post Back to profile
Top-level
Gregory

Specification of this particular variety of .dbf format:
web.archive.org/web/2015032306

And adding to that: fields have fixed lengths and are padded with spaces. Numbers are stored as decimal strings and padded with spaces from the left. There's no distinction between int and float in the field descriptors, both are 'N'.

Should be easy enough to import into any relational database, which is what I'm going to try now.

8 Dec 2021 at 6:24 | Open on mastodon.social
7 comments
Gregory
Gregory

Names of US states in Russian, for example. Cool stuff.

Except "DC" is supposed to be "Округ Колумбия" ¯\_(ツ)_/¯

But well, it's public domain data. Who am I to complain? I should create a pull request probably.
8 Dec 2021 at 7:40 | Open on mastodon.social
bozh

@grishka especially as there's a state of Вашингтон heheh

8 Dec 2021 at 7:44 | Open on fosstodon.org
Gregory

Ukrainian regions don't have a field where their names would be written in, well, Ukrainian. And there are two Kyiv's, one is the city and another is the region around it.

8 Dec 2021 at 7:51 | Open on mastodon.social
Gregory

Actually... I keep seeing references to "geonames", so I googled that, and sure enough, there's geonames.org and it's also free but requires attribution. There's much more translations.

8 Dec 2021 at 8:02 | Open on mastodon.social
Gregory

Wow! This one's even better. I don't *need* all this data, but it's nice that it's out there.
8 Dec 2021 at 8:10 | Open on mastodon.social
Go Up