Page MenuHomePhabricator

Spatial database for tool-labs
Closed, ResolvedPublic

Description

I would like to host a tool on tool-labs that uses a spatial database. Currently I am locally running PostGIS, an extension of PostgreSQL.

The database stores requested images for Commons with the coordinates where these images can be taken. A spatial REST-API allows other programs to get a list of requested images around a certain point in GeoJSON Format.

The primary consumer of this API would be the Commons Mobile App that can use this, to query for requested images around the users current location. This has the advantage that not a whole list of request needs to be downloaded each time.

These are most of my dependencies:

  • System
    • Postgis
    • PostgreSQL
  • Python virtual environment
    • Django
    • djangorestframework
    • djangorestframework-gis
    • psycopg2

Event Timeline

Restricted Application added a project: Cloud-Services. · View Herald TranscriptJan 3 2017, 5:27 PM
Restricted Application added a subscriber: Aklapper. · View Herald Transcript

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?

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.

@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.

@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.

Tobias1984 closed this task as Resolved.Jan 12 2017, 8:57 PM
Tobias1984 claimed this task.

Thank you all for you help! I contacted @akosiaris