OverpassTurbo: Export ::user inside a BoundingBox as CSV

MichaelFS · 2024-08-19T07:29:04.477Z

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.

Codesurfer · 2024-08-20T01:10:05.274Z

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.

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

InsertUser · 2024-08-20T02:06:11.717Z

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.

MichaelFS · 2024-08-20T07:03:57.473Z

Thanks a lot @Codesurfer:

Codesurfer:

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

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?

Codesurfer · 2024-08-20T12:58:41.366Z

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

InsertUser · 2024-08-20T21:43:04.169Z

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

Codesurfer · 2024-08-20T23:10:13.145Z

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

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

MichaelFS · 2024-08-21T05:50:52.363Z

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

Codesurfer:

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

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

Codesurfer · 2024-08-21T10:57:21.719Z

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