OverpassTurbo: Export ::user inside a BoundingBox as CSV

Help and support
,
1

I’d like to use OverpassTurbo to generate a CSV list showing users inside a bounding box
(48.5172,11.4700,48.5467,11.5287)
ideally with the date of the first and most recent and the number of changesets; i.e. a table (sorted if possible) :

UserName || most recent ChangeSet || First CS || Number of CS
--------------------------------------------------------------

Info: I have been asking this in the German Forum.

2

Hi, check the documentation here. You’ll want to use ::changeset, ::timestamp, and ::version at the least in your query.

I also use out meta in my query, export to GeoJSON, then convert to csv in my software.
:eyes:

Here’s a quick test for you to start overpass turbo

1 Like
3

I think Overpass only gives you the latest version of the data unless you query a specific date so you’ll only see the earliest changeset that hasn’t had all its data updated since then.

In practical terms I think it would be easier to just do the post-processing of the changeset on your computer after you’ve downloaded the csv.

1 Like
4

Thanks a lot @Codesurfer:

This helps a lot and I try to understand it. Why dis you add at the end out center;, I’m getting only empty lines for that?

1 Like
5

@MichaelFS Bitte. That was from another query of mine and I forgot to change it to out geom. You can use the regular out geom for your queries.

1 Like
6

I think if you need usernames the out statement has to include meta?

7

@InsertUser yes, the full query would include the out meta too

// print results
out meta; // this will get you the metadata
out geom;

8

@InsertUser : In order to avoid confusion: This was the original post from @Codesurfer :

He had out meta already. Only the last line out geom is obsolete.
Correct?

1 Like
9

Yes, I misinterpreted that question. You don’t need out geom with a csv output.

1 Like