New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Search by changeset metadata ? #189

Open
pyrog opened this Issue Jan 23, 2015 · 13 comments

Comments

Projects
None yet
7 participants
@pyrog

pyrog commented Jan 23, 2015

I would like to search for changesets with specific metadata, but I don't find any information in the wiki.

Examples:

  • searching changesets with comment starting with "#hotosm-task-"
  • or with source equal to "bing"

Syntax:

<changeset comment~"^#hotosm-task-"/>
<changeset source="bing"/>

Note: The use case is to search the numbers of changeset made by one hot task manager user (see hotosm/osm-tasking-manager2#538

@mmd-osm

This comment has been minimized.

Show comment
Hide comment
@mmd-osm

mmd-osm Jan 23, 2015

Contributor

Overpass API doesn't support queries on changeset metadata at this time, but you could use the main API instead. A bit of post processing (=filtering) on the result will be required, though.

Due to the limit of 100 changesets, you might have to create several requests with different timestamps as selection criteria or even use the bbox restriction.

Example:

https://api.openstreetmap.org/api/0.6/changesets?display_name=pyrog

Contributor

mmd-osm commented Jan 23, 2015

Overpass API doesn't support queries on changeset metadata at this time, but you could use the main API instead. A bit of post processing (=filtering) on the result will be required, though.

Due to the limit of 100 changesets, you might have to create several requests with different timestamps as selection criteria or even use the bbox restriction.

Example:

https://api.openstreetmap.org/api/0.6/changesets?display_name=pyrog

@kolesar-andras

This comment has been minimized.

Show comment
Hide comment
@kolesar-andras

kolesar-andras Mar 18, 2015

I also need this feature, especially filtering for source tag of the changeset.

Or simply filter objects by changeset id? Similar to user or type filter:

changeset:1234567

This data is available for overpass, returns with objects. Related to #162.

kolesar-andras commented Mar 18, 2015

I also need this feature, especially filtering for source tag of the changeset.

Or simply filter objects by changeset id? Similar to user or type filter:

changeset:1234567

This data is available for overpass, returns with objects. Related to #162.

@mmd-osm

This comment has been minimized.

Show comment
Hide comment
@mmd-osm

mmd-osm Mar 19, 2015

Contributor

@kolesar-andras : can you shed some more light on your use case?

Applying today's logic to query by user name, filtering by changeset (changeset:1234567) would only return objects which have been last modified in that changeset 1234567. It will certainly not return an object, it any of its versions was modified in changeset 1234567.

Is this what you're expecting?

Contributor

mmd-osm commented Mar 19, 2015

@kolesar-andras : can you shed some more light on your use case?

Applying today's logic to query by user name, filtering by changeset (changeset:1234567) would only return objects which have been last modified in that changeset 1234567. It will certainly not return an object, it any of its versions was modified in changeset 1234567.

Is this what you're expecting?

@mmd-osm

This comment has been minimized.

Show comment
Hide comment
@mmd-osm

mmd-osm Mar 19, 2015

Contributor

@pyrog : there are also some other approaches available to query changeset metadata. One example is OpenStreetMap Changeset Sync for PostgreSQL.

Contributor

mmd-osm commented Mar 19, 2015

@pyrog : there are also some other approaches available to query changeset metadata. One example is OpenStreetMap Changeset Sync for PostgreSQL.

@kolesar-andras

This comment has been minimized.

Show comment
Hide comment
@kolesar-andras

kolesar-andras Mar 20, 2015

I would like to follow progress digitizing objects of a high resolution ortohoto. Searching objects for source tag matches only objects explicitly tagged with source, misses objects where changeset was tagged with source.

Best solution would be if an object does not have a source tag, overpass would substitute it with changeset source. In this case a simple search for source would return objects of both tagging scheme.

One more solution: searching for changeset:source would match source tag of the objects's changeset. In this case simple source search would match source tag of the object only.

kolesar-andras commented Mar 20, 2015

I would like to follow progress digitizing objects of a high resolution ortohoto. Searching objects for source tag matches only objects explicitly tagged with source, misses objects where changeset was tagged with source.

Best solution would be if an object does not have a source tag, overpass would substitute it with changeset source. In this case a simple search for source would return objects of both tagging scheme.

One more solution: searching for changeset:source would match source tag of the objects's changeset. In this case simple source search would match source tag of the object only.

@rmikke

This comment has been minimized.

Show comment
Hide comment
@rmikke

rmikke Dec 20, 2015

I got here when looking for a way to find a changeset created by me using OpenMaps. Pascal Neis says there is one: http://hdyc.neis-one.org/?rmikke but it's most probably something accidental as I didn't even know it's possible to edit with OpenMaps.

So, there is no way to find it?

rmikke commented Dec 20, 2015

I got here when looking for a way to find a changeset created by me using OpenMaps. Pascal Neis says there is one: http://hdyc.neis-one.org/?rmikke but it's most probably something accidental as I didn't even know it's possible to edit with OpenMaps.

So, there is no way to find it?

@mmd-osm

This comment has been minimized.

Show comment
Hide comment
@mmd-osm

mmd-osm Dec 20, 2015

Contributor

@rmikke : it's actually in changeset 26767766. No, you can't find it via Overpass API. I use a dedicated database based on https://github.com/zhm/osmchanges-postgres for it.

Contributor

mmd-osm commented Dec 20, 2015

@rmikke : it's actually in changeset 26767766. No, you can't find it via Overpass API. I use a dedicated database based on https://github.com/zhm/osmchanges-postgres for it.

@rmikke

This comment has been minimized.

Show comment
Hide comment
@rmikke

rmikke Dec 20, 2015

@mmd-osm : Wow, thanks. So it wasn't accidental after all, I just didn't remember it.

rmikke commented Dec 20, 2015

@mmd-osm : Wow, thanks. So it wasn't accidental after all, I just didn't remember it.

@rmikke

This comment has been minimized.

Show comment
Hide comment
@rmikke

rmikke Dec 20, 2015

Could you also identify my change with editor reported as unknown? Or not
one of:
iD
Potlatch
JOSM
Vespucci
OpenMaps
?

2015-12-20 20:54 GMT+01:00 mmd notifications@github.com:

@rmikke https://github.com/rmikke : it's actually in changeset 26767766
http://www.openstreetmap.org/changeset/26767766. No, you can't find it
via Overpass API. I use a dedicated database based on
https://github.com/zhm/osmchanges-postgres for it.


Reply to this email directly or view it on GitHub
#189 (comment)
.

http://tnij.com/WyszukiwarkaRowerowa http://jolanta.korwin-mikke.pl/
R.Mikke@pl.vwfsag.de Ryszard.Mikke@gmail.com

دراجة أكبر

rmikke commented Dec 20, 2015

Could you also identify my change with editor reported as unknown? Or not
one of:
iD
Potlatch
JOSM
Vespucci
OpenMaps
?

2015-12-20 20:54 GMT+01:00 mmd notifications@github.com:

@rmikke https://github.com/rmikke : it's actually in changeset 26767766
http://www.openstreetmap.org/changeset/26767766. No, you can't find it
via Overpass API. I use a dedicated database based on
https://github.com/zhm/osmchanges-postgres for it.


Reply to this email directly or view it on GitHub
#189 (comment)
.

http://tnij.com/WyszukiwarkaRowerowa http://jolanta.korwin-mikke.pl/
R.Mikke@pl.vwfsag.de Ryszard.Mikke@gmail.com

دراجة أكبر

@mmd-osm

This comment has been minimized.

Show comment
Hide comment
@mmd-osm
Contributor

mmd-osm commented Dec 21, 2015

@d1g

This comment has been minimized.

Show comment
Hide comment
@d1g

d1g Mar 27, 2016

Regardless of OPAPI, even simplest form of this would be nice to have:

  • query change-sets by their tags (type:changeset + source:survey + user:myfriend)
  • get ids as result (out:ids)

there are also some other approaches available to query changeset metadata. One example is OpenStreetMap Changeset Sync for PostgreSQL.

This tool is great, thanks for suggestion! But overpass API is integrated in simple-to-use JOSM dialogues and overpass-turbo, they are more easily reachable than suggested solution!

While, change-sets are not part of our data model (in the strict or "academic" sense) they are heavily utilized in workflows (I guess people asking for change-sets because they seen how it is powerful could be in JOSM Ctrl+F), but they are not familiar with true databases

Instead of re-writing overpass, we could adapt some other solution to mimic overpass syntax, but translate queries (to, say, PostgreSQL). At least one online solution would help our users (no need to setup their own servers, if they cannot do this).

d1g commented Mar 27, 2016

Regardless of OPAPI, even simplest form of this would be nice to have:

  • query change-sets by their tags (type:changeset + source:survey + user:myfriend)
  • get ids as result (out:ids)

there are also some other approaches available to query changeset metadata. One example is OpenStreetMap Changeset Sync for PostgreSQL.

This tool is great, thanks for suggestion! But overpass API is integrated in simple-to-use JOSM dialogues and overpass-turbo, they are more easily reachable than suggested solution!

While, change-sets are not part of our data model (in the strict or "academic" sense) they are heavily utilized in workflows (I guess people asking for change-sets because they seen how it is powerful could be in JOSM Ctrl+F), but they are not familiar with true databases

Instead of re-writing overpass, we could adapt some other solution to mimic overpass syntax, but translate queries (to, say, PostgreSQL). At least one online solution would help our users (no need to setup their own servers, if they cannot do this).

@drolbr drolbr added the question label Jun 4, 2016

@erickdeoliveiraleal

This comment has been minimized.

Show comment
Hide comment
@erickdeoliveiraleal

erickdeoliveiraleal Aug 17, 2016

I think created_by tag should be searchable also because of the many changesets created by Maps.Me app, filter out it would be great.

erickdeoliveiraleal commented Aug 17, 2016

I think created_by tag should be searchable also because of the many changesets created by Maps.Me app, filter out it would be great.

@mmd-osm

This comment has been minimized.

Show comment
Hide comment
@mmd-osm

mmd-osm Mar 25, 2017

Contributor

Also check the discussion on openstreetmap/openstreetmap-website#1500

Contributor

mmd-osm commented Mar 25, 2017

Also check the discussion on openstreetmap/openstreetmap-website#1500

@ENT8R ENT8R referenced this issue May 1, 2018

Closed

Add review mode #1043

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment