Downloading completed roads to Excel

Support
1

I track the roads I have completed on an excel spreadsheet and transferring these from the Profile page of the completed walk, is a copy and paste operaton, which also lifts all the unecessary information listed alongside each road e.g “London Borough of Redbridge
10 Nodes
0.08 miles
ShowGo”
which I then have to manually delete for each and every road, and there are many duplicates also. Is there a clean and simple way I can import into my spreadsheet the list of roads I have completed. Cheers Peter

1 Like
2

@aheadahat - have you tried using python to extract just what you want from your page? It would take a little bit of set up but then you could just run that whenever you want. I currently do that to pull some data for what I like to monitor (streets / rank / etc).

3

Thanks, Dean, I’ve not heard of python, but I’ll look into it.

Cheers

Peter

4

Looks a bit techie for me.

5

Yes, it is coding for sure :sweat_smile:

6

What are you doing in the spreadsheet?
The whole point of CityStrides existing is, largely, to remove the need for manually futzing with spreadsheets etc.

7

Hi @aheadahat, I’ve written some Python code to plan out my runs and part of it is to import all my (un)completed streets from CityStrides! If you want I can share the code such that it prints out all (un)completed streets. Let me know :slight_smile:

8

:thinking: I do that for you already … The default open tab in eevdriet is running Rotterdam, Zuid-Holland - CityStrides shows you your incomplete streets and the second tab in shows you all your complete streets

I’m so confused :sweat_smile:

9

Sorry for the confusion! I could have explained it better perhaps :sweat_smile:
What I meant was extracting those streets from the CityStrides tab to a text file to work with locally in Python, probably similar to what @dean.disimone mention they do for monitoring some statistics.

10

It’s sometimes more convenient to see thousand of streets in one Excel sheet, than on 286 pages in CS :wink:

1 Like
11

Speaking of pagination - is there a way to see the full list of anything that is currently paginated or would that just stress the server too much, @JamesChevalier?

12

I get a kick out of conversations like this thread. Y’all are different than me. :smile: I think the only time I look at the list of streets is when I’m answering a question from someone in the community. :laughing: The only stat I think about is my percent complete, but even then I don’t know it offhand. :grimacing: I’m the biggest imposter CityStrides member there is! :rofl:

The whole point of CityStrides is to make running every street easier for us … So if there’s stuff that’s useful to you that’s not currently present - I’d love to hear the details in Ideas so you can spend more time running and less time in spreadsheets/code.

I’m interested in what stats you’re working out. I take a much more simplistic approach to all this, by looking where I haven’t run yet & going out and running there. I think all the time I would have used to think of stats for my journey is instead spent on CityStrides itself.

What are you doing looking at a list of a thousand streets? :rofl: What do you get from that? (Just in case; I don’t mean to come across as rude about it - I’m genuinely wondering what the workflow/goals are there)

Yeah, that’d be the last we saw of CityStrides :saluting_face: if I tried sending out everything in one page :rofl:

1 Like
14

James,
As well as recording the streets I’ve walked down, I want to record the streets I’ve missed, the streets that have appeared since the A-Z was last updated, the pubs that I have passed that I have not visited before. The pubs I have visited. City Strides is great for helping me tick off the streets I have covered, but not the rest. Plus a spreadsheet helps me with further statistical analysis. Not least helping me work out how many more years doing this damn silly project it will be before I walk down all 72,000 streets. :grinning:

1 Like
15

What city are you walking in that has 72,000 streets?

16

I’m walking the London A-Z. The index has 270 pages, each with 4 columns of streets, with an average of 68 streets per column. 270 x 4 x 68 = 73,440. I’ve been doing it for 2 years now and have done 13,261 streets, and if I look at the Life Map it seems to be about the 19.6% of the total I calculate, so 72,000 or so looks about right. :grinning: