Robin Lovelace
Robin Lovelace
Ground truth data from TfL daily counts, cc @rogerbeecham. ``` r library(ggplot2) u = "https://data.london.gov.uk/download/number-bicycle-hires/ac29363e-e0cb-47cc-a97a-e216d900a6b0/tfl-daily-cycle-hires.xls" download.file(u, "tfl-daily-cycle-hires.xls") daily_hires_schema = readxl::read_excel("tfl-daily-cycle-hires.xls") daily_hires = readxl::read_excel("tfl-daily-cycle-hires.xls", sheet = 2) #> New names: #>...
Another illustration of this - should be able to find duplicate files that go into the DB with this: 
The `distinct()` function in dplyr can find them, frustratingly the trip ids differ: ``` > nrow(trips_df_duplicated) / nrow(trips_df) # [1] 0.824824 > > > trips_df_duplicated = distinct(trips_df %>% select(start_time, stop_time,...
Aha, didn't even realise it was down! Hope this info is of use and not a hassle, will share with you any code we write that may be of use...
Thought on this: the only reliable way is using spatial joins. Thinking about the seemingly common example where a way is split in 2 to add a new node/junctions, the...
Having just looked at the OSM wiki on permanent IDs I think my idea is basically the same as https://wiki.openstreetmap.org/wiki/Permanent_ID#OSM_Permanent_ID_with_geo_URI but with a buffer around the 'geo URI' and including...
> I have an edit describing a change to road A covering 5 city blocks originally. Someone updates OSM and splits that road into two pieces. When we snap, we...
Then it could go to the next conflict. Of course there could be settings like `--clobber-all` or `--keep-local` that could be used when there are too many changes to do...
Not sure if this is related but the latest data from spDataLarge is way different. Before:  After:  And interactive map: 
I think I've found the cause, from spDataLarge tests: ``` waldo::compare(bristol_stations, bristol_stations_new) lines(attr(old$geometry, 'crs')$wkt)[6:11] vs lines(attr(new$geometry, 'crs')$wkt)[6:12] " MEMBER[\"World Geodetic System 1984 (G873)\"]," " MEMBER[\"World Geodetic System 1984 (G1150)\"]," "...