I did more modifications on my side, I collapsed both queries into a single one, and now there’s no wait between objects :) Also, any key for any table. Will try to merge these tonight.

``` #! /usr/bin/env python3

import os import sys

import psycopg2

def main(): db = psycopg2.connect(dbname=’europe’) cursor = db.cursor()

cursor.execute(f'''
    SELECT
        count(*) AS count,
        {sys.argv[2]},
        array_agg(osm_id)
    FROM planet_osm_{sys.argv[1]}
    WHERE
        {sys.argv[2]} IS NOT NULL
    GROUP BY {sys.argv[2]}
    ORDER BY count ASC
''')

while (data := cursor.fetchone()) is not None:
    # print(data)
    count, tag, osm_ids = data
    print(f"next {count}: {tag}")

    for osm_id in osm_ids:
        ans = input(f'Ready for {osm_id}? ')
        if ans != 'n':
            if osm_id < 0:
                # in rendering DBs, this is a relation
                os.system(f"librewolf -P default 'https://www.openstreetmap.org/edit?relation={-osm_id}'")
            else:
                os.system(f"librewolf -P default 'https://www.openstreetmap.org/edit?way={osm_id}'")

if name == ‘main’: main() ```

The edits are by hand, there is no automation there, just finding “bad” values.

Ahí lo puse como path, que sería sendero. Si es otro tipo de vía, por favor cámbiala. Además le puse un vado en el punto donde cruza el arroyo al principio, si había un puente, tratá de ponerlo. Sino contanos un poco mejor y lo arreglamos entre varios.

As LordGarySugar mentions in another entry, “the best way to report vandalism in the future is by emailing data@openstreetmap.org with details of the changes you think are vandalism”.

you definitely don’t want to parse all root certs on startup

it’s ~145 certificates, this takes long? Maybe it makes more sense to store them in a more easily parseable format? CER maybe?

Just be aware that you are permitting more connections than the browsers will

But that’s exactly what they want, because the system where the trust store is, well, stored, is immutable, so the trust sore slowly rots.

Maybe you could just copy over the trust store from for instance Firefox or any of the forks you might trust.

https://www.mozilla.org/en-US/about/governance/policies/security-group/certs/policy/

https://firefox-source-docs.mozilla.org/security/nss/runbooks/rootstore.html#root-store-consumers

Or maybe their downstream equivalents in your distro or curl.

Rebienvenue!

Wow, qué laburazo. Me saco el sombrero :)

And thank you for help up! Every node counts!

And pretty complete too! Feel free to add any other places you like :)

Yes, there is a big difference between a tracker (a site that can see all the sites you visit) and a site’s internal analytics (which, yes, tracks you what you do in the site itself). The former is definitely bad, and we can have a discussion about the second, but sites need to know how people go though their site, and if they’re not using a recognizable tool like Matomo, they most probably have their own internal ways to do the same (Matomo is just convenient because its off the shelf).

I can do it for you, but you already have a user :)

Muito brigado!

Bienvenutti, e grazie per il lavoro fatto!

Hola. Podrías al menos apuntar donde están las vías en cuestión?

Ciao. Scusa l’Espagnolo, io può leggere l’Italiano, ma non scrvirlo molto bene :)

Lo que dices de los negozi, si puedes, has el esfuerzo de agregar los horarios de apertura.

Grazie per tutto il lavoro!

Can you describe exactly what you want to do?

In general you don’t. Why would you need to do it?

\o/ Welcome!