Build a Members Data Frame with Geocoded IP Addresses
im_geocode_members( all_geo_cols = TRUE, as_tibble = ironmarch_as_tibble(), as_sf = ironmarch_as_sf() )
Arguments
| all_geo_cols |
|
|---|---|
| as_tibble |
|
| as_sf |
|
Examples
geocoded_members <- im_geocode_members() geocoded_members#> Simple feature collection with 31617 features and 94 fields #> geometry type: POINT #> dimension: XY #> bbox: xmin: -158.016 ymin: -54.8076 xmax: 176.162 ymax: 69.6667 #> CRS: EPSG:4326 #> # A tibble: 31,617 x 95 #> member_id name member_group_id email joined ip_address #> <int> <chr> <int> <chr> <dttm> <chr> #> 1 NA NA NA NA NA 5.228.77.… #> 2 NA NA NA NA NA 185.130.5… #> 3 NA NA NA NA NA 67.227.21… #> 4 1 Алек… 4 slav… 2011-09-12 15:46:59 178.140.1… #> 5 NA NA NA NA NA 178.140.1… #> 6 NA NA NA NA NA 178.140.1… #> 7 NA NA NA NA NA 178.176.8… #> 8 NA NA NA NA NA 178.176.8… #> 9 NA NA NA NA NA 178.177.2… #> 10 NA NA NA NA NA 88.147.20… #> # … with 31,607 more rows, and 89 more variables: allow_admin_mails <lgl>, #> # skin <int>, warn_level <int>, warn_lastwarn <int>, restrict_post <lgl>, #> # bday_day <int>, bday_month <int>, bday_year <int>, msg_count_new <int>, #> # msg_count_total <int>, msg_show_notification <lgl>, last_visit <dttm>, #> # last_activity <dttm>, mod_posts <lgl>, auto_track <chr>, temp_ban <lgl>, #> # mgroup_others <chr>, member_login_key_expire <dttm>, #> # members_seo_name <chr>, members_cache <chr>, members_disable_pm <int>, #> # failed_logins <chr>, members_profile_views <int>, members_pass_hash <chr>, #> # members_pass_salt <chr>, members_bitoptions <int>, members_day_posts <chr>, #> # notification_cnt <int>, posts <int>, title <chr>, time_offset <chr>, #> # last_post <dttm>, view_sigs <lgl>, msg_count_reset <lgl>, dst_in_use <lgl>, #> # login_anonymous <chr>, ignored_users <chr>, org_perm_id <chr>, #> # member_login_key <chr>, members_auto_dst <lgl>, members_display_name <chr>, #> # members_l_display_name <chr>, members_l_username <chr>, #> # member_banned <lgl>, member_uploader <chr>, language <int>, #> # failed_login_count <int>, pp_last_visitors <chr>, pp_main_photo <chr>, #> # pp_main_width <int>, pp_main_height <int>, pp_thumb_photo <chr>, #> # pp_thumb_width <int>, pp_thumb_height <int>, #> # pp_setting_count_comments <lgl>, pp_reputation_points <int>, #> # pp_gravatar <chr>, pp_photo_type <chr>, signature <chr>, #> # fb_bwoptions <lgl>, tc_last_sid_import <chr>, tc_bwoptions <lgl>, #> # pp_customization <chr>, timezone <chr>, pp_cover_photo <chr>, #> # members_bitoptions2 <int>, create_menu <chr>, marked_site_read <int>, #> # pp_cover_offset <int>, acp_skin <lgl>, acp_language <lgl>, #> # member_title <chr>, member_posts <int>, member_last_post <int>, #> # member_streams <chr>, photo_last_update <dttm>, msg_count_reset_at <dttm>, #> # status <chr>, country <chr>, countryCode <chr>, region <chr>, #> # regionName <chr>, city <chr>, zip <chr>, i.timezone <chr>, isp <chr>, #> # org <chr>, as <chr>, geometry <POINT [°]>geocoded_cols <- c("country", "countryCode", "region", "regionName", "city", "zip", "timezone", "isp", "org", "as") geocoded_members[, c("name", geocoded_cols)]#> Simple feature collection with 31617 features and 11 fields #> geometry type: POINT #> dimension: XY #> bbox: xmin: -158.016 ymin: -54.8076 xmax: 176.162 ymax: 69.6667 #> CRS: EPSG:4326 #> # A tibble: 31,617 x 12 #> name country countryCode region regionName city zip timezone isp org #> <chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr> #> 1 NA Russia RU MOW Moscow Mosc… 1026… NA NCNET NA #> 2 NA South … KR 11 Seoul Seoul 07247 NA tran… Beju… #> 3 NA United… US NV Nevada Las … 89128 NA SOUR… BENC… #> 4 Алек… Russia RU MOW Moscow Mosc… 1026… Asia/Ri… NCNET NA #> 5 NA Russia RU MOW Moscow Mosc… 1026… NA NCNET NA #> 6 NA Russia RU MOW Moscow Mosc… 1026… NA NCNET NA #> 7 NA Russia RU MOW Moscow Mosc… 1447… NA PJSC… PJSC… #> 8 NA Russia RU MOW Moscow Mosc… 1447… NA PJSC… PJSC… #> 9 NA Russia RU MOW Moscow Mosc… 1447… NA Msk … Scar… #> 10 NA Italy IT 34 Veneto Schio 36015 NA NGI NGI … #> # … with 31,607 more rows, and 2 more variables: as <chr>, geometry <POINT [°]>
