There is a PostgreSQL database that replicates data from OSM and is used by some tools; currently accounts for that database are managed manually in role::osm::master, mainly by @akosiaris, so cc'ing him here.

Also, Extension:GeoData is deployed on the Wikimedia cluster which may overlap with or could be used for your use case.

We have an Elasticsearch cluster in Tool Labs. Could you achieve the same end result by using the GeoJSON support that it has?

Can this be accomplished with the geo keywords available on commons for search?

https://www.mediawiki.org/wiki/Help:CirrusSearch#Geo_Search
https://commons.wikimedia.org/w/index.php?search=nearcoord%3A42km%2C37.77666667%2C-122.39&fulltext=1
https://commons.wikimedia.org/w/index.php?title=Special:Search&profile=default&fulltext=Search&search=neartitle%3A42km%2CSan_Francisco&fulltext=1

In T154497#2913411, @scfc wrote:

There is a PostgreSQL database that replicates data from OSM and is used by some tools; currently accounts for that database are managed manually in role::osm::master, mainly by @akosiaris, so cc'ing him here.

The way I read this request, it does NOT request an OSM synced (that is a database with the entire OpenStreetMap dataset) database. Just a PostgreSQL with Postgis installed. We do have a such a database (different from the OSM one) as well and the accounts for that are managed manually indeed (we have never found the time to automate this). If that's indeed what's needed and the suggestions from others do not provide better ways of achieving this, please confirm and I 'll create an account. As for the rest of the requirements I think they can be very easily fullfiled in the container that will run this application in the toollabs kubernetes environment.

@akosiaris That would be great if I could get an account and the information on how to access the database from wmflabs.

In T154497#2918930, @Tobias1984 wrote:

@akosiaris That would be great if I could get an account and the information on how to access the database from wmflabs.

Sure, what's your LDAP (wikitech) username ? I don't seem to be able to find it.

Sorry. I forgot that I registered like this: https://wikitech.wikimedia.org/wiki/User:Tobias47n9e

@Tobias1984. Sorry I completely forgot about this. I 've created your account. Contact me privately on IRC (akosiaris) or via email so I can provide the credentials to you.