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.

2024-12-02 TIL: Flock, Location Properties, and Language Nuances

💻

• The PointsCount is distinct from Count in a Part.
• Location has an AdditionalSourceProperties property, useful for storing extra attributes for a location, such as customized node types like start node, end node, and vertex.
• Flock: Flutter by the community, for the community. Flock is Flutter+.

🌱

• 珩 (héng) is the top gem of the pendants.
• The phrase ‘handled it’ could be pronounced as /ˈhan·dldɪt/.
• The phrase ‘the exhibit instead’ should be pronounced as /ði ɪɡˈzɪbɪt ɪnˈstɛd/.