2024-12-03 TIL

2024-12-03 TIL: NMEA Insights, SQL Tips, and Whimsical Observations: From Pac-Man to The Wind in the Willows

💻

NMEA Sentences

  • Four Common Types: $GPGGA, $GPRMC, $GPGSA, and $GPGSV.
    • $GPGGA and $GPRMC contain location and time-related data.
    • $GPGSA and $GPGSV provide satellite-related information.
  • Examples:
    • $GPRMC,194000.000,A,3401.8431,N,11711.4761,W,24.43,145.27,061020,,,D*4F
    • $GPGGA,194000.000,3401.8431,N,11711.4761,W,2,10,1.0,478.9,M,-32.5,M,2.0,0000*4D
  • Time and Date Formats:
    • $GPGGA: Time in HHMMSS.SSS format.
    • $GPRMC: Time (HHMMSS.SSS) + Date (DDMMYY), e.g., 194000.000 (UTC 19:40:00.000) and 061020 (6th October 2020).
  • Checksum: Ensures data integrity. Calculated by XOR-ing all characters between $ and *. Example: 4D.

SQL for ArcGIS

  • Use TIMESTAMP with the format: yyyy-mm-dd hh24:mi:ss (24-hour clock, no AM/PM).

🌱

Figure Skating

  • A type of skating that involves circular patterns and often includes jumps.
  • /ˈfɪɡ.jɚ/

Incisor

  • One of the sharp teeth at the front of the mouth that cut food when you bite into it. (切牙、门齿)
  • /ɪnˈsaɪ.zɚ/

Pac-Man

  • Pac-Man, a classic arcade game by Namco. Named “食鬼” in Hong Kong, “小精灵” in Taiwan, “吃豆人” in Mianland China.
  • Ghost Characters: Blinky (red), Pinky (pink), Inky (light blue), Clyde (orange).

XJBC (夏季八冲)

  • A humorous “coffee brewing technique” requiring:
    • No bean selection, no sifting, no stickers, no blooming, no temperature control, no timing, no circular stirring, no cup warming.

Reading Notes from The Wind in the Willows

  1. On Laziness:
    • Finding joy in being the only idle one among busy citizens.
    • The essence of a good holiday is not resting but watching others work.
  2. On Fear:
    • A terrifying entity feared by all the small animals in the fields and hedges—the “horror of the Wild Wood.”

Musical Skiers

  • Icelandic photographer Haukur Sigurdsson captured this aerial image of Nordic skiers looking like musical notes on a staff.
Puran Zhang @puran