search

Amherst-Statistics / ValleyBikes-obsolete

Repository for the Valley Bikes data project
Other
0 stars 0 forks source link

Generate the table of stations locations #4

Closed elachtara closed 4 years ago

nicholasjhorton commented 4 years ago

This is all the background I have:

On Jul 2, 2019, at 1:20 PM, Yanik Hardy yanik@bewegen.com wrote:

Hi Nick,

Maybe you can start with this? https://www.valleybike.org/ Click on any icon and you will have station info i.e. name, address, number of docks.

We don't have an actual file like you're looking for.

Yanik

-----Message d'origine----- De : Nicholas Horton nicholasjhorton@gmail.com Envoyé : 30 juin 2019 15:44 À : Yanik Hardy yanik@bewegen.com Cc : Nicholas Horton nicholasjhorton@gmail.com; Wayne Feiden wfeiden@northamptonma.gov Objet : query about dock locations

Yanik,

Do you have a file which maps dock locations to dock names? I know many of them but not all.

Thanks in advance for any guidance,

Nick

elachtara commented 4 years ago

would it be best if I do this in excel file?

nicholasjhorton commented 4 years ago

My suggestion would be to use one day's worth of data from 2019 (not yet available, substitute 2018 for now) and generate the set of all starting locations and ending locations. Those lat/long combinations should be the stations. I'd prefer to do this using an R Markdown file.

elachtara commented 4 years ago

me and shukry have made progress on this and are trying to read in multiple days in order to get all the stations.

nicholasjhorton commented 4 years ago

Can you please add a link to the code on github?

shukryzablah commented 4 years ago

The code is in the update#1 file.

Next step is checking if we can join a table (with names for stations) from a report in the government file cabinet, and our generated stations table.

shukryzablah commented 4 years ago

We will use the json that is requested by the valleybike.org site to get the table of stations.

We got the following link by inspecting the network requests made by the site:

https://valleybike.org/stations/stations/

nicholasjhorton commented 4 years ago

Nice!

elachtara commented 4 years ago

Check out the file "StationLocationScraping"

nicholasjhorton commented 4 years ago

This is shaping up well. Can you please add an example for how to plot the station locations to the ValleyBikes package github repo?

nicholasjhorton commented 4 years ago

I'm hoping that we can review the workflow here for the data package. But I'm not seeing the file StationLocationScraping in the current repo. Can you please advise?

shukryzablah commented 4 years ago

Check out this file: https://github.com/Amherst-Statistics/ValleyBikes/blob/master/code/stations.Rmd or it's pdf

nicholasjhorton commented 4 years ago

That looks great and is helpful.

But I was more curious about the workflow to generate the stations, as we will need to run it in the future. Can you please send a pointer to that when you have a chance?

shukryzablah commented 4 years ago

The data-raw folder contains scripts to recreate the data objects that will be included in the package. Check out this file: https://github.com/Amherst-Statistics/ValleyBikes/blob/master/data-raw/stations.R

nicholasjhorton commented 4 years ago

Cool. So am I correct in understanding that the Station locations are now coming from the ValleyBikes website (and not being generated using the paths of the bikes?

shukryzablah commented 4 years ago

Yes. There is the small addition of the clustering into communities since that was not included originally and felt useful.

On Fri, Nov 8, 2019, 12:27 PM Nicholas Horton notifications@github.com wrote:

Cool. So am I correct in understanding that the Station locations are now coming from the ValleyBikes website (and not being generated using the paths of the bikes?

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/Amherst-Statistics/ValleyBikes/issues/4?email_source=notifications&email_token=AG3OAIVIX2FVB2FB5PS6G6LQSWOQ5A5CNFSM4IUB6FBKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEDSZUNI#issuecomment-551918133, or unsubscribe https://github.com/notifications/unsubscribe-auth/AG3OAISEHW7GVUMOHKNHJCDQSWOQ5ANCNFSM4IUB6FBA .