Add a parameter to the importKCL function that allows users to specify the timespan average to download data for

[andylin2004]

Feature request

This request would add a parameter that would be akin to the importUKAQ function, where there is already a data_type parameter to specify the timespan average data to download for. I think the importKCL function by default downloads data on a hourly timespan, which is an issue if I want to download multiple years on end. This package has been super useful for one of my semester project so thank you very much for providing the package.

[jack-davison]

Hi Andy!

Thanks for your issue.

The reason importUKAQ() has data_type is because a lot of these statistics are pre-calculated, so R simply imports them from their web source.

The database behind importKCL() isn't managed by the {openair} authors and doesn't pre-calculate any statistics - hourly is all you get!

So, data_type in importKCL() (or, indeed, importEurope()) would have to work slightly differently - we'd have to leverage {openair} functions to calculate annual means, monthly means, etc. after the data has been imported.

That isn't to say its not a bad idea though, and could be a nice quality of life feature!

Could I ask which sites you're using importKCL() to access? If they're part of Londonair, they should also be in the "locally managed" source and therefore available in importUKAQ() and therefore have data_type already:

openair::importMeta("local", all = TRUE) |>
  dplyr::filter(provider == "Londonair") |>
  dplyr::pull(site) |> unique()
#>   [1] "Barking and Dagenham - North Street"     
#>   [2] "Barking and Dagenham - Rush Green"       
#>   [3] "Barking and Dagenham - Scrattons Farm"   
#>   [4] "Barnet - Strawberry Vale "               
#>   [5] "Bexley - Bedonwell "                     
#>   [6] "Bexley - Belvedere"                      
#>   [7] "Bexley - Belvedere FDMS"                 
#>   [8] "Bexley - Belvedere West"                 
#>   [9] "Bexley - Belvedere West FDMS"            
#>  [10] "Bexley - Erith"                          
#>  [11] "Bexley - Thames Road North"              
#>  [12] "Bexley - Thames Road North FDMS"         
#>  [13] "Bexley - Thames Road South"              
#>  [14] "Bexley - Thamesmead"                     
#>  [15] "Brent - ARK Franklin Primary Academy"    
#>  [16] "Brent - Harlesden"                       
#>  [17] "Brent - Ikea"                            
#>  [18] "Brent - Ikea Car Park"                   
#>  [19] "Brent - John Keble Primary School"       
#>  [20] "Brent - Neasden Lane"                    
#>  [21] "Brent - St Marys Primary School"         
#>  [22] "Bromley - Biggin Hill"                   
#>  [23] "Bromley - Rent Office"                   
#>  [24] "Bromley - Tweedy Rd"                     
#>  [25] "City of London - Beech Street"           
#>  [26] "City of London - Farringdon Street"      
#>  [27] "City of London - Senator House"          
#>  [28] "City of London - Sir John Cass School"   
#>  [29] "City of London - Upper Thames Street"    
#>  [30] "City of London - Walbrook Wharf"         
#>  [31] "Croydon - Euston Road"                   
#>  [32] "Croydon - George Street"                 
#>  [33] "Croydon - Norbury"                       
#>  [34] "Croydon - Park Lane"                     
#>  [35] "Croydon - Purley Way"                    
#>  [36] "Croydon - Purley Way A23"                
#>  [37] "Croydon - Thornton Heath"                
#>  [38] "Crystal Palace - Crystal Palace Parade"  
#>  [39] "Dartford - St Clements 2"                
#>  [40] "Dartford Bean Interchange Roadside"      
#>  [41] "Dartford St Clements Roadside"           
#>  [42] "Dartford Town Centre Roadside"           
#>  [43] "Ealing - Acton Town Hall"                
#>  [44] "Ealing - Acton Town Hall (Partisol)"     
#>  [45] "Ealing - Acton Town Hall FDMS"           
#>  [46] "Ealing - Acton Vale "                    
#>  [47] "Ealing - Court Way"                      
#>  [48] "Ealing - Ealing Town Hall"               
#>  [49] "Ealing - Greenford"                      
#>  [50] "Ealing - Hanger Lane Gyratory"           
#>  [51] "Ealing - Southall"                       
#>  [52] "Ealing - Southall FDMS"                  
#>  [53] "Ealing - Southall Railway"               
#>  [54] "Ealing - Western Avenue"                 
#>  [55] "Elmbridge - Bell Farm Hersham"           
#>  [56] "Elmbridge - Esher High Street"           
#>  [57] "Elmbridge - Hampton Court Parade"        
#>  [58] "Elmbridge - Walton High Street"          
#>  [59] "Enfield - Bowes Primary School"          
#>  [60] "Enfield - Bush Hill Park"                
#>  [61] "Enfield - Church Street"                 
#>  [62] "Enfield - Derby Road"                    
#>  [63] "Enfield - Prince of Wales School"        
#>  [64] "Enfield - Salisbury School"              
#>  [65] "Greenwich - A206 Burrage Grove"          
#>  [66] "Greenwich - Blackheath"                  
#>  [67] "Greenwich - Falconwood"                  
#>  [68] "Greenwich - Falconwood FDMS"             
#>  [69] "Greenwich - Fiveways Sidcup Rd A20"      
#>  [70] "Greenwich - John Harrison Way"           
#>  [71] "Greenwich - Millennium Village"          
#>  [72] "Greenwich - Plumstead High Street"       
#>  [73] "Greenwich - Trafalgar Road"              
#>  [74] "Greenwich - Trafalgar Road (Hoskins St)" 
#>  [75] "Greenwich - Westhorne Avenue"            
#>  [76] "Greenwich - Woolwich Flyover"            
#>  [77] "Hackney - Old Street"                    
#>  [78] "Haringey - Bounds Green"                 
#>  [79] "Harrow - Pinner Road"                    
#>  [80] "Havering - Harold Hill"                  
#>  [81] "Havering - Rainham"                      
#>  [82] "Havering - Romford"                      
#>  [83] "Islington - Arsenal"                     
#>  [84] "Islington - Holloway Road"               
#>  [85] "Islington - Upper Street"                
#>  [86] "Kensington and Chelsea - Green Screen BG"
#>  [87] "Kensington and Chelsea - Green Screen RS"
#>  [88] "Kingston - Chessington"                  
#>  [89] "Kingston - Town Centre"                  
#>  [90] "Kingston Upon Thames - Cromwell Road"    
#>  [91] "Kingston Upon Thames - Kingston Vale"    
#>  [92] "Kingston Upon Thames - Sopwith Way"      
#>  [93] "Kingston Upon Thames - Tolworth Broadway"
#>  [94] "Lambeth - Bondway Interchange"           
#>  [95] "Lambeth - Brixton Road"                  
#>  [96] "Lambeth - Christchurch Road"             
#>  [97] "Lambeth - Loughborough Junct"            
#>  [98] "Lambeth - Streatham Green"               
#>  [99] "Lambeth - Vauxhall Cross"                
#> [100] "Lewisham - Catford"                      
#> [101] "Lewisham - Deptford"                     
#> [102] "Lewisham - Honor Oak Park"               
#> [103] "Lewisham - Loampit Vale"                 
#> [104] "Lewisham - Mercury Way"                  
#> [105] "Lewisham - New Cross"                    
#> [106] "Merton - Merton Road"                    
#> [107] "Merton - Morden Civic Centre"            
#> [108] "Merton - Morden Civic Centre 2"          
#> [109] "Merton - Willow Lane Industrial Estate"  
#> [110] "Mole Valley - Dorking"                   
#> [111] "Mole Valley - Leatherhead"               
#> [112] "Mole Valley - Lower Ashtead"             
#> [113] "National Physical Laboratory, Teddington"
#> [114] "Reading - Caversham Road"                
#> [115] "Reading - Kings Road"                    
#> [116] "Reading - Oxford Road"                   
#> [117] "Redbridge - Fullwell Cross"              
#> [118] "Redbridge - Gardner Close"               
#> [119] "Redbridge - Ilford Broadway"             
#> [120] "Redbridge - Ley Street"                  
#> [121] "Redbridge - Perth Terrace"               
#> [122] "Redbridge - South Woodford"              
#> [123] "Richmond Upon Thames - Barnes Wetlands"  
#> [124] "Richmond Upon Thames - Castelnau"        
#> [125] "Richmond Upon Thames - Chertsey Road"    
#> [126] "Sevenoaks - Bat and Ball"                
#> [127] "Sevenoaks - Greatness Park"              
#> [128] "Sevenoaks - Sevenoaks Quarry"            
#> [129] "Southwark - Elephant and Castle"         
#> [130] "Southwark - Heygate"                     
#> [131] "Southwark - Tower Bridge Road"           
#> [132] "Sutton - Beddington Lane "               
#> [133] "Sutton - Beddington Lane north"          
#> [134] "Sutton - Carshalton"                     
#> [135] "Sutton - North Cheam"                    
#> [136] "Sutton - Robin Hood School"              
#> [137] "Sutton - Therapia Lane"                  
#> [138] "Sutton - Wallington"                     
#> [139] "Sutton - Worcester Park"                 
#> [140] "Tower Hamlets - Bethnal Green"           
#> [141] "Tower Hamlets - Poplar"                  
#> [142] "Waltham Forest - Chingford"              
#> [143] "Waltham Forest - Mobile"                 
#> [144] "Wandsworth - Battersea"                  
#> [145] "Wandsworth - Garratt Lane"               
#> [146] "Wandsworth - High Street"                
#> [147] "Wandsworth - Lavender Hill (Clapham Jct)"
#> [148] "Wandsworth - Putney"                     
#> [149] "Wandsworth - Putney High Street"         
#> [150] "Wandsworth - Putney High Street Facade"  
#> [151] "Wandsworth - Roehampton"                 
#> [152] "Wandsworth - Tooting"                    
#> [153] "Wandsworth - Tooting High Street"        
#> [154] "Westminster - Buckingham Palace Road"    
#> [155] "Westminster - Cavendish Square"          
#> [156] "Westminster - Charing Cross Library"     
#> [157] "Westminster - Covent Garden"             
#> [158] "Westminster - Duke Street (Grosvenor)"   
#> [159] "Westminster - Ebury Street (Grosvenor)"  
#> [160] "Westminster - Elizabeth Bridge"          
#> [161] "Westminster - Mount Street (Grosvenor)"  
#> [162] "Westminster - Oxford Street"             
#> [163] "Westminster - Oxford Street 2"           
#> [164] "Westminster - Oxford Street East"        
#> [165] "Westminster - Strand (Northbank BID)"    
#> [166] "Westminster - Victoria"                  
#> [167] "Westminster - Victoria (Victoria BID)"   
#> [168] "Westminster - Victoria Street"           
#> [169] "Windsor and Maidenhead - Aldebury Road"  
#> [170] "Windsor and Maidenhead - Ascot"          
#> [171] "Windsor and Maidenhead - Clarence Road"  
#> [172] "Windsor and Maidenhead - Frascati Way"

^{Created on 2024-11-26 with reprex v2.1.1}

[andylin2004]

Ah. I didn't check too closely to see if there was any overlap between the two dataset locations, but I was attempting to consult the KCL data after I realized that there was potentially a good amount of CO2 data missing on the UKAQ source.