Created
November 13, 2015 11:37
-
-
Save pnorman/48471b214ed47d04d8ea to your computer and use it in GitHub Desktop.
mapbox unresponded dump
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ┌──────────────┬─────────────────────┬───────────────────┬─────────────────────┬───────────────────────────────────────────────────────────────────────────────┐ | |
| │ changeset_id │ changeset_user_name │ comment_user_name │ comment_date │ comment_text │ | |
| ├──────────────┼─────────────────────┼───────────────────┼─────────────────────┼───────────────────────────────────────────────────────────────────────────────┤ | |
| │ 34823048 │ abel801 │ mfuji │ 2015-10-28 15:12:33 │ Please don't break our data! ↵│ | |
| │ │ │ │ │ ↵│ | |
| │ │ │ │ │ You have deleted the SECONDARY roads #335726311 and #313944874 by merging int…│ | |
| │ │ │ │ │…o a different TERTIARY road #376538841. ↵│ | |
| │ │ │ │ │ But they are roads in different class and they are unknown from imagery. Then…│ | |
| │ │ │ │ │… we have lost many informations tagged in these roads, including informations…│ | |
| │ │ │ │ │… we surveyed. ↵│ | |
| │ │ │ │ │ ↵│ | |
| │ │ │ │ │ You can edit geometries of roads from imagery, but don't merge, delete or rep…│ | |
| │ │ │ │ │…leace ways if you don't actually know about there. │ | |
| │ 34296442 │ nikhilprabhakar │ SomeoneElse │ 2015-09-30 13:58:50 │ If http://www.openstreetmap.org/way/30474767/history has changed its name fro…│ | |
| │ │ │ │ │…m Telegraph Row to Teelgraph Road, what about http://www.openstreetmap.org/wa…│ | |
| │ │ │ │ │…y/32650736 ? │ | |
| │ 34203846 │ ruthmaben │ sanchi │ 2015-09-23 14:05:10 │ because you take away the oneway? │ | |
| │ 34203846 │ ruthmaben │ sanchi │ 2015-09-27 12:44:40 │ Revertido http://www.openstreetmap.org/changeset/34282351 │ | |
| │ 33956590 │ oini │ 51114u9 │ 2015-09-11 15:46:33 │ No. Living street not connected with the avenue. There are few meters of kerb…│ | |
| │ │ │ │ │…. ↵│ | |
| │ │ │ │ │ ↵│ | |
| │ │ │ │ │ I will revert this change │ | |
| │ 33948861 │ ruthmaben │ leodobrasil │ 2015-09-16 00:35:54 │ Dear Ruth, I observed that you connected roads through existing (and mapped!)…│ | |
| │ │ │ │ │… fences in this changeset. I´m a local mapper and know from my field survey t…│ | |
| │ │ │ │ │…hat there is no connection between the "caminho de acesso à casa de bomba" an…│ | |
| │ │ │ │ │…d Rua K, L and M, respectively, but just a fence. ↵│ | |
| │ │ │ │ │ Sincerely, ↵│ | |
| │ │ │ │ │ Leonhard │ | |
| │ 33909783 │ PlaneMad │ 51114u9 │ 2015-09-09 22:05:04 │ thank you for edit and improve the map of Bolivia :) │ | |
| │ 33714845 │ samely │ ikz │ 2015-09-02 19:55:19 │ Are you sure in this points? ↵│ | |
| │ │ │ │ │ Yes, we can put nodes in intersections, but then we need to split ways and ma…│ | |
| │ │ │ │ │…ke lot of restrictions. │ | |
| │ 33699815 │ pratikyadav │ andrewpmk │ 2015-08-31 16:39:44 │ I don't think there is a bike lane here │ | |
| │ 33310794 │ aarthy │ MikeN │ 2015-08-19 20:50:58 │ Hi, Thank you for your edit! It appears that an entire railroad has been a…│ | |
| │ │ │ │ │…ccidentally moved, and now seems to be misaligned. I can undo this change; l…│ | |
| │ │ │ │ │…et me know what you wish to do. │ | |
| │ 33310794 │ aarthy │ MikeN │ 2015-08-20 12:40:03 │ It looks like someone else had moved the entire rail first in changeset https…│ | |
| │ │ │ │ │…://www.openstreetmap.org/changeset/33235552 . But there was also work since…│ | |
| │ │ │ │ │… done by several people with local crossing fixes, so moving the entire rail …│ | |
| │ │ │ │ │…was no longer possible. I manually fixed the entire line. │ | |
| │ 33262557 │ ruthmaben │ cufarulcopiilor │ 2015-08-11 10:37:29 │ great │ | |
| │ 33186281 │ dannykath │ SomeoneElse │ 2015-08-08 17:06:34 │ Thanks - that looks much more like the right size. │ | |
| │ 33101616 │ dannykath │ SomeoneElse │ 2015-08-07 17:14:49 │ Would it be possible to describe what the "impossible angle" was before here?…│ | |
| │ │ │ │ │… http://osmhv.openstreetmap.de/changeset.jsp?id=33101616 doesn't really show …│ | |
| │ │ │ │ │…a lot of difference. The resulting roundabout still looks a bit overnoded an…│ | |
| │ │ │ │ │…d too big for the imagery. │ | |
| │ 32954543 │ nikhilprabhakar │ EdLoach │ 2015-07-29 14:33:03 │ Did you mean to delete Currys PC World when you were amending the building ou…│ | |
| │ │ │ │ │…tline? │ | |
| │ 32954543 │ nikhilprabhakar │ PlaneMad │ 2015-08-01 06:09:36 │ Restored the deleted building. Nikhil, please be more careful with existing o…│ | |
| │ │ │ │ │…bjects and make sure you don't accidentally remove the work of others while m…│ | |
| │ │ │ │ │…aking improvements. | |
| │ 32796912 │ PlaneMad │ servergate │ 2015-07-22 11:16:35 │ like │ | |
| │ 32677866 │ karitotp │ chillly │ 2015-07-17 21:37:34 │ Another crap, remote edit by a Mapbox person. ↵│ | |
| │ │ │ │ │ ↵│ | |
| │ │ │ │ │ Please STOP making these WRONG remote edits without visiting the site. Why no…│ | |
| │ │ │ │ │…t send me a message asking if there is a problem rather than maaking work for…│ | |
| │ │ │ │ │… me to correct this? ↵│ | |
| │ │ │ │ │ ↵│ | |
| │ │ │ │ │ i will revert this. │ | |
| │ 32677866 │ karitotp │ lxbarth │ 2015-07-20 22:07:44 │ This was reverted by @chillly here http://www.openstreetmap.org/changeset/327…│ | |
| │ │ │ │ │…08331 │ | |
| │ 31917716 │ Chetan_Gowda │ Glassman │ 2015-06-12 15:09:47 │ I removed the road. It doesn't exist last time I drove through the park. │ | |
| 31907988 │ karitotp │ orson │ 2015-06-15 01:22:01 │ I'm curious why you split this road into two oneway streets and why they have…│ | |
| │ │ │ │ │… different names? │ | |
| │ 31844248 │ samely │ mhenson │ 2015-06-09 17:35:14 │ Thank you! I have done a lot of mapping, but I have not reverted any change s…│ | |
| │ │ │ │ │…ets. │ | |
| │ 31638424 │ dannykath │ SomeoneElse │ 2015-06-08 11:58:41 │ Did you mention the "problem" that you fixed here to either SK53 or will_p wh…│ | |
| │ │ │ │ │…o were the previous mappers of the ways concerned? Given that they're both o…│ | |
| │ │ │ │ │…n-the-ground mappers I'd be very surprised if the previous situation was inco…│ | |
| │ │ │ │ │…rrect. Perhaps rather than diving in and trying to "fix" a problem (especial…│ | |
| │ │ │ │ │…ly where, as in this case, it's really not clear from the imagery) it would b…│ | |
| │ │ │ │ │…e better to contact the previous mappers and ask them? │ | |
| │ 29730352 │ abel801 │ dudka │ 2015-03-25 17:03:41 │ Please revert this changeset since it corrupted hundred of ways. ↵│ | |
| │ │ │ │ │ Why(and how) did you add this node http://www.openstreetmap.org/node/18953149…│ | |
| │ │ │ │ │…79 to so many ways? │ | |
| │ 29730352 │ abel801 │ dudka │ 2015-03-25 17:11:28 │ I've reverted it. │ | |
| │ 28594248 │ Luis36995 │ GerdP │ 2015-10-22 05:49:14 │ please review: ↵│ | |
| │ │ │ │ │ I've changed highway="orange Peel" ↵│ | |
| │ │ │ │ │ to highway=path. ↵│ | |
| │ │ │ │ │ Maybe it is name="Orange Peel" ? ↵│ | |
| │ │ │ │ │ Or was it some kind of joke? │ | |
| │ 28473195 │ lxbarth │ Aaron Lidman │ 2015-01-29 21:31:31 │ Test test. Did you get an email? │ | |
| │ 28446941 │ Luis36995 │ GerdP │ 2015-10-07 11:05:27 │ I guess this was meant to add a name ↵│ | |
| │ │ │ │ │ iinstead of setting ↵│ | |
| │ │ │ │ │ highway=Heritage Place ? ↵│ | |
| │ │ │ │ │ I'll change it that way. │ | |
| │ 28264012 │ ediyes │ SomeoneElse │ 2015-01-21 11:37:26 │ In this case, did you contact the previous mapper to explain what you'd done?…│ | |
| │ │ │ │ │… Fixing the data's all very well but if mappers don't know tat they're suppo…│ | |
| │ │ │ │ │…sed to join footpaths to roads, they won't. It's important to communicate wi…│ | |
| │ │ │ │ │…th other mappers and work together. │ | |
| │ 28163061 │ Rub21 │ SomeoneElse │ 2015-01-21 09:28:28 │ What does "Fixing to relation" actually mean? │ | |
| │ 27938643 │ andygol │ SomeoneElse │ 2015-01-21 11:15:57 │ What does "to-fix (http://osmlab.github.io/to-fix/?error=unconnected_major1)"…│ | |
| │ │ │ │ │… mean? ↵│ | |
| │ │ │ │ │ ↵│ | |
| │ │ │ │ │ Meaningful changeset comments (and small geographical changeset areas) are ex…│ | |
| │ │ │ │ │…tremely useful to help other mappers understand what changes are being made t…│ | |
| │ │ │ │ │…o their local areas. This changeset has neither of these. ↵│ | |
| │ │ │ │ │ ↵│ | |
| │ │ │ │ │ Can you please explain what you have changed and why? │ | |
| └──────────────┴─────────────────────┴───────────────────┴─────────────────────┴───────────────────────────────────────────────────────────────────────────────┘ |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT cc.comment_changeset_id AS changeset_id, | |
| cs.user_name AS changeset_user_name, | |
| cc.comment_user_name, | |
| cc.comment_date, | |
| cc.comment_text | |
| FROM osm_changeset_comment cc | |
| JOIN osm_changeset cs ON cs.id = cc.comment_changeset_id | |
| WHERE (cs.user_name::text IN ( SELECT mapbox_editors.user_name | |
| FROM mapbox_editors)) AND NOT (EXISTS ( SELECT 1 | |
| FROM osm_changeset_comment | |
| WHERE cs.id = osm_changeset_comment.comment_changeset_id AND cs.user_name::text = osm_changeset_comment.comment_user_name::text)) AND (EXISTS ( SELECT 1 | |
| FROM osm_changeset_comment | |
| WHERE cs.id = osm_changeset_comment.comment_changeset_id AND NOT (osm_changeset_comment.comment_user_name::text IN ( SELECT mapbox_editors.user_name | |
| FROM mapbox_editors)))) | |
| ORDER BY changeset_id DESC, comment_date ASC; |
@samely - just add the changeset id to the end of http://www.openstreetmap.org/changeset/ - so for instance for changeset id 34823048 the URL is http://www.openstreetmap.org/changeset/34823048: http://www.openstreetmap.org/changeset/34823048
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Where can I get the changeset url?