2022 / Recap
Day 1: Points
I'll be doing nonsense-only this #30DayMapChallenge. For example, for day 1 created a bunch of random points and then tried different postgis clustering functions on them. Much fun. SQL bits at https://t.co/IauEhgFomT pic.twitter.com/HjiFvQdjAQ
— Tõnis Kärdi (@tkardi) November 1, 2022
Day 2: Lines
#30DayMapChallenge day 2 finds me creating lines between node pairs in PostGIS. Again, SQL bits at https://t.co/4Ji7LJw0ak pic.twitter.com/CBbFWh5AUd
— Tõnis Kärdi (@tkardi) November 2, 2022
Day 3: Polygons
#30DayMapChallenge day 3. Quadtree-indexing empty space around obstacles. SQL bits at https://t.co/9qwop0uISp pic.twitter.com/zDuXHPX2ex
— Tõnis Kärdi (@tkardi) November 4, 2022
Day 4: Green
#30DayMapChallenge day 4 goes into the randomness of random points. All in green. SQL bits at https://t.co/6oTL0eRvpG pic.twitter.com/CpKhQLgRDi
— Tõnis Kärdi (@tkardi) November 4, 2022
Day 5: Ukraine
#30DayMapChallenge day 5 - building non-overlapping buffers for points in PostGIS. Uses Ukrainian 1st level admin unit centroids generated from NaturalEarth data. SQL bits at https://t.co/5o50Ppo83g pic.twitter.com/2AaVKqcUwX
— Tõnis Kärdi (@tkardi) November 4, 2022
Day 6: Network
#30DayMapChallenge day 6 - there might have been some method in my madness in which i summarize the work from the first 3 days into one. Building an ad-hoc graph to do "open area pathfinding" around obstacles with pgRouting and PostGIS.
— Tõnis Kärdi (@tkardi) November 6, 2022
SQL bits at https://t.co/eiDtWXXb4a pic.twitter.com/VapsrvobFk
Day 7: Raster
#30DayMapChallenge day 7 - I remember seeing a color TV for the first time in my life as a kid, and lookig at it real close thinking what trickery is this. So here's vector data pretending to be raster, and viewed through a kinescope.
— Tõnis Kärdi (@tkardi) November 7, 2022
SQL bits at https://t.co/qskbSJ3fRm pic.twitter.com/vz82qKDf9R
Day 8: OpenStreetMap
#30DayMapChallenge day 8 - "Sure we have GIS data, please see the attached file". For todays OpenStreetMap data challenge I'll turn this the other way around: exporting your own data as OSM XML.
— Tõnis Kärdi (@tkardi) November 8, 2022
SQL bits at https://t.co/ZY2NUKnUIx pic.twitter.com/NOrK9U6YrF
Day 9: Space
#30DayMapChallenge day 9 - Dividing empty space between polygons.
— Tõnis Kärdi (@tkardi) November 9, 2022
SQL bits at https://t.co/2R9ied5nCT pic.twitter.com/Ytg9lZQiTQ
Day 10: Bad
#30DayMapChallenge day 10 - Calculating a (very linear) color gradient from #BAD to #A55 with just a sprinkle of opacity.
— Tõnis Kärdi (@tkardi) November 10, 2022
SQL bits at https://t.co/MMkOz2ku7I pic.twitter.com/rQlW166Ars
Day 11: Red
#30DayMapChallenge Day 11 - A spiral of a train schedule. Reworking an idea from 2 years ago and it's not really still there. Well, maybe next time.
— Tõnis Kärdi (@tkardi) November 11, 2022
Features fresh data off the national passanger rail provider homepage https://t.co/HxiscB1jrL
SQL bits at https://t.co/yhihQ9lybn pic.twitter.com/QbktpNzLME
Day 12: Scale
#30DayMapChallenge Day 12 - Comparing geometry simplification functions on a set on linestrings in PostGIS.
— Tõnis Kärdi (@tkardi) November 12, 2022
SQL bits at https://t.co/NmUOH3ZQq7 pic.twitter.com/HjrPSXbGEM
Day 13: A five minute map
#30DayMapChallenge - Day 13. A five minute graticule over the Estonian Land Boards TMS tilegrid bounds.
— Tõnis Kärdi (@tkardi) November 13, 2022
SQL bits at https://t.co/tnkiWejgrZ pic.twitter.com/aSicetTHfK
Day 14: Hexagons
#30DayMapChallenge Day 14 - Creating hexagons using PostGIS, but only where you really need them.
— Tõnis Kärdi (@tkardi) November 14, 2022
SQL bits at https://t.co/QmovHaEsYX pic.twitter.com/cFpvbeJysG
Day 15: Food or drink
#30DayMapChallenge Day 15 - PostGIS has a st_letters function which turns input chars into polygons.
— Tõnis Kärdi (@tkardi) November 15, 2022
Best served with the sound of neon lights buzzing in the background.
SQL bits at https://t.co/jPQL0fyA9C pic.twitter.com/z5C5tILz6B
Day 16: Minimal
#30DayMapChallenge Day 16 - I'm minimally late doing very minimal things: looking at some "geometry approximations" using PostGIS.
— Tõnis Kärdi (@tkardi) November 17, 2022
SQL bits at https://t.co/7bs0NihCTQ pic.twitter.com/01wMoOttf8
Day 17: A map without a computer
#30DayMapChallenge Day 17 - I revisit one of my old scrapbooks from a year and a half ago and try to decipher what in the world was I ever babbling about.
— Tõnis Kärdi (@tkardi) November 17, 2022
Quasi-SQL bits at https://t.co/QLo9EFsnT9 pic.twitter.com/EivmoCCQbY
Day 18: Blue
#30DayMapChallenge Day 18 - Calculating shared borders with left and right side props attached from polygons using PostGIS.
— Tõnis Kärdi (@tkardi) November 18, 2022
SQL bits at https://t.co/WQoQZ4I6cS pic.twitter.com/lM2UZYTOCy
Day 19: Globe
#30DayMapChallenge Day 19 - WGS84 longitude isoprecision lines: how much is this extra decimal place really worth.
— Tõnis Kärdi (@tkardi) November 19, 2022
SQL bits at https://t.co/jD1T1VfzQI pic.twitter.com/f2A7ffF55J
Day 20: Favourite
#30DayMapChallenge Day 20 - Through the 24h of flat earth ice wall rotating in Web Mercator. And me with it. To celebrate the beginnings of my least favourite season of the year.
— Tõnis Kärdi (@tkardi) November 20, 2022
SQL bits at https://t.co/88sMVkopzx pic.twitter.com/1PKwqA4nbw
Day 21: Kontur world population dataset
#30DayMapChallenge Day 21 - Population of the world grouped at the Equator.
— Tõnis Kärdi (@tkardi) November 21, 2022
Features data off Kontur, NaturalEarth, and Wikipedia.
SQL bits at https://t.co/S2ouXZbXYE pic.twitter.com/d8IWDdRhey
Day 22: NULL
#30DayMapChallenge Day 22 - On the the contrary to a rose - null is null is not null.
— Tõnis Kärdi (@tkardi) November 22, 2022
SQL bits at https://t.co/b1PRFvzMBW pic.twitter.com/NZ69eJLlth
Day 23: Movement
#30DayMapChallenge Day 23 - Estimating public transit locations from time-table data using PostGIS.
— Tõnis Kärdi (@tkardi) November 23, 2022
SQLBits at https://t.co/xlxkVOYVRC pic.twitter.com/jIrcN3Nm2X
Day 24: Fantasy
#30DayMapChallenge Day 24 - Plans for Dantes Inferno as calculated by Antonio Manetti of Florence, and digitized using a PostGIS SQL query by one Tõnis of Tartu.
— Tõnis Kärdi (@tkardi) November 24, 2022
SQL bits at https://t.co/dQvyhyHiCs pic.twitter.com/59ClCUz4HV
Day 25: Two colors
#30DayMapChallenge Day 25 - Reworking day 7 "raster-kinescope" to get the CRT frame refresh effect.
— Tõnis Kärdi (@tkardi) November 25, 2022
Features Ukrainian 1st level admin unit bbox data generated from NaturalEarth.
SQL bits as https://t.co/QECyaR7jdX pic.twitter.com/swAHuPfJMp
Day 26: Island(s)
#30DayMapChallenge Day 26 - From points with costs to isocost areas: removing islands of "smaller costs" from isoareas using PostGIS.
— Tõnis Kärdi (@tkardi) November 26, 2022
SQL bits at https://t.co/PcHYPfeP3E pic.twitter.com/hCMJ1RkWRY
Day 27: Music
#30DayMapChallenge Day 27 - Viva La Vinyl! A CD is like bad acid not for production or consumption. Spin the black circle!
— Tõnis Kärdi (@tkardi) November 27, 2022
SQL Bits at https://t.co/mzQwYUR1fw pic.twitter.com/6hqxTubeWU
Day 28: 3D
#30DayMapChallenge Day 28 - Unfolding a 3D geometry using PostGIS.
— Tõnis Kärdi (@tkardi) November 28, 2022
SQL bits at https://t.co/hGCTAuCvxD pic.twitter.com/5vyWDK7Jjx
Day 29: Out of my comfort zone
#30DayMapChallenge Day 29 - out of my comfort zone to mix RGB colors in PostGIS. Don't like this, can I go back to b/w now?
— Tõnis Kärdi (@tkardi) November 29, 2022
SQL bits at https://t.co/k5kmBgOlcz pic.twitter.com/5jOVODYHol
Day 30: Remix
#30DayMapChallenge Day 30 - A flat Earth 1-degree graticule in Web Mercator.
— Tõnis Kärdi (@tkardi) November 30, 2022
SQL bits at https://t.co/K9eQ8yUlOi pic.twitter.com/UoeZMy70z6