After taking a course in Android app programming at UCLA Extension, I continued to learn about Android and in late 2014 published a free app onto the Google Play store. The user manually inputs information about coupons (or, really, anything you want to remind yourself about), and the app reminds you two days before and on the day of the expiration date entered. The Android Notification API was a little thorny to deal with, since when I created the app, notifications needed to be re-scheduled each time the phone was turned off/on. The app has been downloaded over 100 times (lol)!
This tile links to a simple tool I created leveraging Esri's arcpy Python library. Esri's flagship software ArcGIS is used to visualize map data. The map items displayed on the screen, e.g., streets in a metropolitan area, are linked to data tables with related attributes. While employed at Esri, I often worked with street data. A single street is often composed of multiple records in a data table, corresopnding to multiple sub-lines in the map. I frequently found myself needing to select all records pertaining to multiple streets, but it was a pain in the butt to do that by manually clicking on table records or lines on the map. This tool automates the process of selecting all these records, by deriving a SQL query to select the desired streets and then applying the query to the map. It's like telling the software "I've selected parts of these 10 streets. Can you select all records that have these street names?" Of course, this tool isn't limited to street names; you can select any other attribute in the data table as the basis of the selection. In other words, this tool enables one to make a full selection of records based on an ad hoc partial selection.
This is the (static) map I made for a final project for a Cartography course I took at the University of Wisconsin, Madison. One of my passions is public transit. I've spent about 4 years of my life in Tokyo, and I am still in love with the dense array of above-ground trains and subways that fan out around Tokyo. The highly dense urban sprawl that surrounds Tokyo developed contemporaneously with the suburban railway network. As the city grew, train companies continued to extend above-ground lines farther from the central city, allowing quick and economical access for suburban dwellers to downtown areas. This allowed Tokyo to grow to the point that is still considered by many to be the most populous single urban conglomeration in the world. Above-ground train construction is much cheaper than subway construction, which cities that are already built out must resort to. Additionally, unlike in the United States, where following the robber baron years of railway monopolies the American government restricted real estate investment by railway companies, Tokyo suburban rail companies did not face such restrictions and built railway lines that complemented their real estatement development projects. The synergy between railway and real estate development is one of the major forces responsible for the nature of Tokyo's built environment. This map reflects the unique quality of Tokyo's urban environment: a much larger portion of Tokyo proper is accessible by rail than New York City.