𝚖𝚊𝚌𝚔𝚊 𝚜𝚣𝚎𝚌𝚑𝚗𝚘
LightNews LightNews
banner
mackaszechno.bsky.social
𝚖𝚊𝚌𝚔𝚊 𝚜𝚣𝚎𝚌𝚑𝚗𝚘
@mackaszechno.bsky.social
1.3K followers 620 following 3.2K posts
#rstats geospatial data analyst. GIS expert, of a sort. Sci-fi fan and would be writer. Black cat owner. Occasionally apocalyptical. Can't DM.
WORDS ARE QUICK AND WORDS ARE VAIN, THE SINGLE SURE AND FINAL ANSWER MUST BE PAIN. -Dan Simmons, Olympos
Posts Replies Media Videos
Pinned
mackaszechno.bsky.social
𝚖𝚊𝚌𝚔𝚊 𝚜𝚣𝚎𝚌𝚑𝚗𝚘 @mackaszechno.bsky.social · Feb 28
Слава Україні! 🇺🇦🇪🇺
Reposted by 𝚖𝚊𝚌𝚔𝚊 𝚜𝚣𝚎𝚌𝚑𝚗𝚘
jauntyjjs.bsky.social
Sharing my joy 🌞 that I'm one of the runners up for 2025 Posit Table 𝄜 Contest. Grateful to

@posit.co for the chance to share nice but less-known places to visit in 🇸🇬 🦁.

@nrennie.bsky.social table on lemurs as inspiration.

#rstats #PositTable #TableContest #DataVisualisation #SingaporeTourism
Snapshot of the Posit Table Contest 2025 results saying my table submission is in one of the runners up.
November 11, 2025 at 8:49 AM
Reposted by 𝚖𝚊𝚌𝚔𝚊 𝚜𝚣𝚎𝚌𝚑𝚗𝚘
chiaraphillips.bsky.social
In 2024, 46.9% of net electricity generated in the EU came from renewable energy sources (Eurostat). In the first half of 2025, renewable energy has outpaced coal as the primary source of electricity globally, indicating a shift in our reliance on fossil fuels (NPR). 🌞

#30DayMapChallenge Minimal
November 11, 2025 at 7:53 AM
mackaszechno.bsky.social
Using {mapsf} to create a minimal map showing, hopefully, solidarity with Ukraine.
#30DayMapChallenge | Day 11 - Minimal #rstats
(code in alt)
library(mapsf) library(sf) library(dplyr) library(png) uk <- st_read( paste0("https://ec.europa.eu/eurostat/cache/GISCO/distribution/v2/nuts/", "geojson/NUTS_RG_03M_2016_3857_LEVL_2.geojson"), stringsAsFactors = FALSE ) |> subset(CNTR_CODE == "UK") uk_all <- uk |> st_union() |> st_as_sf() # set up map mf_map(uk_all, col = NA, border = NA) # create background mf_background(filename = "./ukr_flag.png") # create overlay mf_map(uk_all, lwd = 3, col = NA, border = "white", add = TRUE) # create text mf_credits( txt = "macka szechno #30DayMapChallenge | Day 11 - Minimal #rstats", col = "white" )
November 11, 2025 at 9:11 AM
Reposted by 𝚖𝚊𝚌𝚔𝚊 𝚜𝚣𝚎𝚌𝚑𝚗𝚘
rstats.blaze.email
Winners of the 2025 Table Contest

https://posit.co/blog/2025-table-contest-winners/

#rstats #datascience
Winners of the 2025 Table Contest
Summary: Posit showcases 2025 Table Contest winners and runners-up, highlighting diverse gt/Quarto tables, dashboards, and visual storytelling across R and Python.
posit.co
November 11, 2025 at 6:04 AM
Reposted by 𝚖𝚊𝚌𝚔𝚊 𝚜𝚣𝚎𝚌𝚑𝚗𝚘
usrbinr.bsky.social
If you want to load excel files directly to @duckdb.org in #rstats, you can use the md::read_excel() function in the motherduck package

simply pipe your excel file into read_excel() and you will load your data directly to your database by passing your local memory

usrbinr.github.io/md/reference...
Read an Excel file into a DuckDB/MotherDuck table — read_excel
Loads the DuckDB excel extension and creates a table from an Excel file using the read_xlsx() table function. The destination is fully qualified as &lt;database&gt;.&lt;schema&gt;.&lt;table&gt;. Only ...
usrbinr.github.io
November 10, 2025 at 1:14 PM
Reposted by 𝚖𝚊𝚌𝚔𝚊 𝚜𝚣𝚎𝚌𝚑𝚗𝚘
pythonmaps.bsky.social
Day 10 of the #30DayMapChallenge - Air - Map of the world's airports and airways.
November 10, 2025 at 9:35 PM
Reposted by 𝚖𝚊𝚌𝚔𝚊 𝚜𝚣𝚎𝚌𝚑𝚗𝚘
underdarkgis.fosstodon.org.ap.brid.gy
We’re getting ready for QGIS Open Day on 28 November 2025! 💚

We’re looking for speakers. If you’d like to share your #qgis work or ideas, sign up

👉 https://github.com/qgis/QGIS/wiki/QOD-November-2025

#qod #gischat #osgeo
QOD November 2025
QGIS is a free, open source, cross platform (lin/win/mac) geographical information system (GIS) - qgis/QGIS
github.com
November 10, 2025 at 8:39 PM
Reposted by 𝚖𝚊𝚌𝚔𝚊 𝚜𝚣𝚎𝚌𝚑𝚗𝚘
xiongbiao.bsky.social
#30DayMapChallenge
Day-10/15/20 Air/Fire/Water
Using WRI’s data to visualize China's power plants, where different colors represent plant types (Wind, Coal, Hydro, etc.) and size indicates installed capacity. And I've marked the top ten.
November 10, 2025 at 12:28 PM
mackaszechno.bsky.social
Mapping 7698 airports and 67443 routes
Data from: github.com/jpatokal/ope...
#30DayMapChallenge | Day 10 - Air #rstats
(code in alt)
library(sf) library(dplyr) library(readr) library(purrr) library(mapview) library(mapgl) # https://openflights.org/data.php # https://github.com/jpatokal/openflights sf_use_s2() # [1] TRUE # great circle distance calculations use by default plane <- read_csv("./data/airports/airports.csv") |> st_as_sf(coords = c("Lon", "Lat"), crs = 4326) plane$AirportID <- as.character(plane$AirportID) route <- read_csv("./data/airports/routes.csv") # cleaning ---- plane$AirportID |> duplicated() |> table() # FALSE # 7698 route <- route |> filter(SourceAirportID != "\\N") |> filter(DestinationAirportID != "\\N") |> filter(Stops == 0) route <- route |> filter(SourceAirportID != DestinationAirportID) route <- route |> filter(SourceAirportID %in% plane$AirportID) |> filter(DestinationAirportID %in% plane$AirportID) # creating route linestring geometry ---- draw_route <- function(x, plane){ line <- st_sfc( st_linestring( rbind( st_coordinates( plane[as.character(plane$AirportID) == x$SourceAirportID, ] ), st_coordinates( plane[as.character(plane$AirportID) == x$DestinationAirportID, ] ) ) ), crs = 4326 ) return(line) } route_geometry <- map(1:nrow(route), \(x) draw_route(route[x, ], plane)) # bind list of linetrings into dataframe route_geometry_df <- do.call(rbind, route_geometry) # make dataframe a sf column route_geometry_df <- route_geometry_df |> st_as_sfc(crs = 4326) # combine that with the route st_geometry(route) <- route_geometry_df maplibre(style = carto_style("dark-matter")) |> add_circle_layer(id = "airport", source = plane, circle_color = "limegreen", circle_blur = 1) |> add_line_layer(id = "route", source = route, line_width = 0.1, line_color = "lightblue", line_blur = 1)
November 10, 2025 at 3:32 PM
Reposted by 𝚖𝚊𝚌𝚔𝚊 𝚜𝚣𝚎𝚌𝚑𝚗𝚘
kylewalker.bsky.social
Today's mapgl tip for #30DayMapChallenge: Air

Use the `set_fog()` function to change the color of the sky on your @Mapbox map. Visualize the glow of the Northern Lights - or whatever you can come up with!
November 10, 2025 at 2:46 PM
Reposted by 𝚖𝚊𝚌𝚔𝚊 𝚜𝚣𝚎𝚌𝚑𝚗𝚘
justjami.bsky.social
Color can be hard, but it doesn't have to be. Understanding and applying basic color theory can help improve your visuals - whether it's a chart, map, or dashboard.

I walk you through the basics in my upcoming workshop: Data Visualization Essentials, Dec 9.
LevelUpMySkills.com/dataviz
levelupmyskills.bsky.social levelupmyskills.bsky.social @levelupmyskills.bsky.social · 21h
Color isn't just decoration, it's communication. Guide your audience's eyes by using color strategically to enhance understanding.

Learn about purposeful design in our next workshop on Dec 9, 2025, taught by @justjami.bsky.social

Data Visualization Essentials
levelupmyskills.com/dataviz

#prodev
Communicate with color: Color is not just a decoration; Color provides meaning and enhances insight. The accompanying graphics show a "before" chart with multiple random colors for the bars and an "after" chart that shows the bars in shaded teal tones and gray, signifying Excellent to bad reviews (with Excellent being the darkest teal color). This is one of the lessons taught in the upcoming Data Visualization Essentials workshops. details found at levelUpMySkills.com/dataviz
November 10, 2025 at 2:19 PM
Reposted by 𝚖𝚊𝚌𝚔𝚊 𝚜𝚣𝚎𝚌𝚑𝚗𝚘
tylermw.com
Rendering the peak of Mount Everest from sunrise to sunset in R with rayshader and rayrender

#RStats #rayrender #rayshader #rayverse
November 9, 2025 at 4:41 AM
Reposted by 𝚖𝚊𝚌𝚔𝚊 𝚜𝚣𝚎𝚌𝚑𝚗𝚘
jasminedaly.bsky.social
{shinyfa} is on CRAN 🎉 I’ll be chatting more about its origins in my talk this Thursday at R+AI conference!

I’m so happy to have more brain space back to think strategically about how to develop more #rstats packages with AI-assisted development!

#databs
November 9, 2025 at 9:38 PM
Reposted by 𝚖𝚊𝚌𝚔𝚊 𝚜𝚣𝚎𝚌𝚑𝚗𝚘
mapsmania.bsky.social
#30DayMapChallenge - Analog
So this is a bit of a stretch - but ...
🖌️🎨🖼️
How to create a hand-drawn (analog looking) map style in Maputnik.
googlemapsmania.blogspot.com/2025/11/a-pe...
A Pencil Style for Maplibre
Maps Mania is a blog dedicated to tracking the very best digital interactive maps on the internet and the tools used to create them.
googlemapsmania.blogspot.com
November 9, 2025 at 4:27 PM
Reposted by 𝚖𝚊𝚌𝚔𝚊 𝚜𝚣𝚎𝚌𝚑𝚗𝚘
kylewalker.bsky.social
A custom styling trick for #30DayMapChallenge: Analog

For a "classic" look on your mapgl MapLibre maps, load a parchment paper image (or whatever you'd like) and override the basemap.

Here's how to do it: gist.github.com/walkerke/648...
November 9, 2025 at 3:58 PM
mackaszechno.bsky.social
Bump as it's finally day 9 😁
mackaszechno.bsky.social 𝚖𝚊𝚌𝚔𝚊 𝚜𝚣𝚎𝚌𝚑𝚗𝚘 @mackaszechno.bsky.social · 3d
Okay, wanted to share this now rather than wait. The analogue version is on A3 and the paper is now so old it's yellowed. The digital version is probably only 20 years old. Both were used as the basis for a novella I wrote (unpublished).
#30DayMapChallenge | Day 9 - Analogue #handdrawn
Fictional city of HAC (Halon Administrative Centre) showing all 5 districts. Drawn in MS Word at the turn of the century and copied from the original. Word was a weird choice but it did actually used to have a decent drawing effort.
November 9, 2025 at 12:47 PM
Reposted by 𝚖𝚊𝚌𝚔𝚊 𝚜𝚣𝚎𝚌𝚑𝚗𝚘
rsfrankl.bsky.social
Nothing like a nice long flight for catching up on #30DayMapChallenge 🤪.

Here's Day 8 — urban — right on time. A map of Paris buildings by age of construction. A real beauty if I do say so myself. 😍
Map of Paris buildings by age
November 9, 2025 at 12:53 AM
Reposted by 𝚖𝚊𝚌𝚔𝚊 𝚜𝚣𝚎𝚌𝚑𝚗𝚘
pythonmaps.bsky.social
Day 8 of the #30DayMapChallenge Urban - Roads of the world. Couldn't think of anything more urban than roads.
November 8, 2025 at 11:12 PM
Reposted by 𝚖𝚊𝚌𝚔𝚊 𝚜𝚣𝚎𝚌𝚑𝚗𝚘
obrien.page
This is more or less what I do when faced with a featureserver/map server. Look for the Query operation, set where=1=1 and format you want, then copy the URL and drop all of the empty API arguments. I'm sure there's a better way, but it works.
Find the URL to the server Scroll to the bottom, look for "Query". You may (likely will) need to select a layer first. Set the query to 1=1 to return everything, or a real query to return a subset. Change to geojson for JS-esque endpoints, or CSV for more R-y endpoints.
November 8, 2025 at 10:35 PM
Reposted by 𝚖𝚊𝚌𝚔𝚊 𝚜𝚣𝚎𝚌𝚑𝚗𝚘
ludictechnologies.bsky.social
It's such a great toolkit. Do you know about the sf_ext package as well? I think it's worthy of more attention. It fills a few of the gaps in sf (and has, for example, slightly saner arguments for its st_make_grid() equivalent). elipousson.github.io/sfext/
Extra Functions for Simple Feature Data
Extra functions with additional options for reading, writing, and transforming spatial data. Includes a variety of utility functions for working with tabular data with coordinates and distance and are...
elipousson.github.io
November 4, 2025 at 1:55 PM
mackaszechno.bsky.social
Well, the lad's never wrong...

Cheers, @obrien.page 😀
UK_Shipping_Forecast_Areas <- read_sf(paste0("https://services9.arcgis.com/j1CY4yzWfwptbTWN/ArcGIS/rest/", "services/UK_ShippingForecats/FeatureServer/0/query?", "where=1%3D1&f=pgeojson")) mapview(UK_Shipping_Forecast_Areas, zcol = "Area_Name", label = "Area_Name", labelOptions = labelOptions( noHide = TRUE, textOnly = TRUE, direction = 'center', permanent = TRUE, opacity = 1, style = list(color = "#696969") ))
November 8, 2025 at 8:06 PM
Reposted by 𝚖𝚊𝚌𝚔𝚊 𝚜𝚣𝚎𝚌𝚑𝚗𝚘
rsteve388.bsky.social
Wow these numbers are surprising. Especially OR.
A map of percentage by state population reliant on Food Stamps.
November 8, 2025 at 1:47 PM
Reposted by 𝚖𝚊𝚌𝚔𝚊 𝚜𝚣𝚎𝚌𝚑𝚗𝚘
tterence.bsky.social
#30DayMapChallenge · Day 8 · Urban. Global urban areas.

#rayshader adventures, an #rstats tale
A visualisation of global urban areas on a Mollweide projection
November 8, 2025 at 1:52 PM
Reposted by 𝚖𝚊𝚌𝚔𝚊 𝚜𝚣𝚎𝚌𝚑𝚗𝚘
gnoblet.bsky.social
For Day 06 of the #30DayMapChallenge, I used:

📖 Wikipedia retrieving tallest building list with `rvest`

🏔️ `tidyterra` to retrieve elevation shades

🔮 Refined top buildings's labels and lines with `ggrepel`

Code: guillaume-noblet.com/30DayMapChal...

#rstats #gis #dataviz #ggplot2 #terra
November 8, 2025 at 3:52 PM
Reposted by 𝚖𝚊𝚌𝚔𝚊 𝚜𝚣𝚎𝚌𝚑𝚗𝚘
kylewalker.bsky.social
Today's mapgl tip for #30DayMapChallenge Day 8: Urban

The default Mapbox Standard Style with `mapboxgl()` gets you 3D buildings - with rendered landmarks - out of the box.

Using MapLibre? Try `maplibre(style = openfreemap_style("liberty"))` for 3D OSM buildings!
November 8, 2025 at 1:54 PM