azavea / osmesa

OSMesa is an OpenStreetMap processing stack based on GeoTrellis and Apache Spark
Apache License 2.0
80 stars 26 forks source link

Surface `last_edit` in `user_statistics` + API responses #95

Closed mojodna closed 5 years ago

mojodna commented 5 years ago

Scoreboard extracts a lossy last_edit timestamp from edit_times. To facilitate more precise reporting, OSMesa should surface a full timestamp as last_edit in the user_statistics materialized view and in the corresponding API response.

SQL fragment:

select max(coalesce(closed_at, created_at)) AS last_edit from changesets where user_id=<user_id>