Patrick Noll

- use osm2pgsql or imposm to load into postgres - keep data up to date with diffs - ogr2osm using postgis query with [st_intersection](https://postgis.net/docs/ST_Intersection.html) and st_intersects to clip data

Thanks! > Do you think in the future there could be a potential F-Droid app that automatically adds or auto-updates downloaded maps without having to manually add and update them...

@michaelblyons thanks for mentioning here. I'll try and make the case for a plugin. This would be great, but I'm doubtful the OsmAnd guys will want to build it, if...

all of us_az_coconino make it into pg db but none of it makes it to osm file. Unable to find bad values in db: searched for nulls and 0s, checked...

us_wa_skagit and us_id_bannock also have issues. Looking at OA shows it's bad data from them. Currently, data is taken direct from OA each month for builds. Due to OA's lack...

tests moved to psycopg2 in 29a5728dee9a9ad7d65ac9075bec7e741ae95e3c. table restores still done using psql, doesn't sound like psycopg2 is designed for that.

filter_data moved to psycopg2 in fc7fb1d2b722ba5f7e93bc1739f40962ef12e13e.

I did a couple test runs a few years ago: https://patricknoll.com/posts/Add-Open-Address-Data-To-MapsMe The show stopper was that they try to autocorrect addresses based on nearby streets ,randomly breaking added addresses: https://github.com/mapsme/omim/issues/12121....

Look into running on openjdk17 at same time. https://github.com/osmandapp/OsmAnd-tools/issues/484 Can fall back to using snapshot.debian.org if needed.

work is ongoing in osm_dedupe branch