Geocode tbl geocodes a whole data frame
geocode_tbl(tbl, adresse, code_insee = NULL, code_postal = NULL)an augmented data frame of class tbl with latitude, longitude, etc
table_test <- tibble::tibble(
x = c("39 quai Andre Citroen", "64 Allee de Bercy", "20 avenue de Segur"),
y = c("75015", "75012", "75007"),
z = rnorm(3)
)
geocode_tbl(tbl = table_test, adresse = x)
#> Writing tempfile to...C:\Users\JULIET~1.ENG\AppData\Local\Temp\RtmpAzOdDH\file646016742fe4.csv
#> If file is larger than 50 MB, it must be splitted
#> Size is : 61 bytes
#> SuccessOKSuccess: (200) OK
#> # A tibble: 3 × 21
#> y z x longitude latitude result_score result_score_next
#> <chr> <dbl> <chr> <dbl> <dbl> <dbl> <chr>
#> 1 75015 -2.44 39 quai Andr… 2.28 48.8 0.980 0.80136999999999…
#> 2 75012 -0.00557 64 Allee de … 2.38 48.8 0.973 NA
#> 3 75007 0.622 20 avenue de… 2.31 48.9 0.972 0.95324454545454…
#> # ℹ 14 more variables: result_label <chr>, result_type <chr>, result_id <chr>,
#> # result_housenumber <chr>, result_name <chr>, result_street <chr>,
#> # result_postcode <chr>, result_city <chr>, result_context <chr>,
#> # result_citycode <chr>, result_oldcitycode <chr>, result_oldcity <chr>,
#> # result_district <chr>, result_status <chr>
geocode_tbl(tbl = table_test, adresse = x, code_postal = y)
#> Writing tempfile to...C:\Users\JULIET~1.ENG\AppData\Local\Temp\RtmpAzOdDH\file64603f3f1851.csv
#> If file is larger than 50 MB, it must be splitted
#> Size is : 81 bytes
#> SuccessOKSuccess: (200) OK
#> # A tibble: 3 × 21
#> z x y longitude latitude result_score result_score_next
#> <dbl> <chr> <chr> <dbl> <dbl> <dbl> <chr>
#> 1 -2.44 39 quai Andr… 75015 2.28 48.8 0.980 NA
#> 2 -0.00557 64 Allee de … 75012 2.38 48.8 0.973 0.600363971291866
#> 3 0.622 20 avenue de… 75007 2.31 48.9 0.972 0.38506487603305…
#> # ℹ 14 more variables: result_label <chr>, result_type <chr>, result_id <chr>,
#> # result_housenumber <chr>, result_name <chr>, result_street <chr>,
#> # result_postcode <chr>, result_city <chr>, result_context <chr>,
#> # result_citycode <chr>, result_oldcitycode <chr>, result_oldcity <chr>,
#> # result_district <chr>, result_status <chr>