Stories
Slash Boxes
Comments
NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

All the Perl that's Practical to Extract and Report

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
 Full
 Abbreviated
 Hidden
More | Login | Reply
Loading... please wait.
  • Yeah, it's quite easy to find data problems there.

    Germany > Berlin: the cities there are really boroughs, and most of them are duplicated (with and without the "Berlin-" prefix).

    Inconsistent umlaut handling: Germany > Baden-Württemberg has a "u" instead of "ü", but I see umlauts in the "cities" under Berlin.

    Croatia > Zagrebacka: this should not be Zagrebacka, but rather Zadarska or so.

    Croatia > Grad Zagreb: the city of Zagreb appears twice, once under the correct name and once under the old German name "Agram" (which nobody uses anymore, not even the Germans). Sveta Nedelja appears in two spellings.

    Maybe it would be better to use the data from OpenStreetMap?

    • I'll look for the OpenStreetMap data and check the license. I've blown enough time looking at annoying data integrity issues that an alternative data source would be good.

      Also, SQLite is fine for a simple database, but when you need serious reliability and are struggling with data integrity, it's painful to work with.

      • Kudos for a great job!

        Let me know if you think I can contribute somehow, I am originally from Argentina so I can check or add places in Argentina/South America from sources in Spanish/etc.

        -- ank

        • Thanks for the offer of help. Eventually I'll get to the point where I'll be needing it from folks who want to help entering legal immigration data per country.

          To be honest, though, I might drop city/region support altogether. As I've discovered, most of the thorough information out there is geographic in nature (not surprising) but the information I need is political in nature. They don't quite fit together. If you want to emigrate to the US, do you really need to know where Paris, Texas is? Not reall