Code
I create this page to share code that I have used in my research. Some might look crappy, but hope they can save you time when you happen to come across the same questions/tasks.
CustomizeTMY3 function in NREL SAM model
Code that helped me:
Converting Chinese Characters to Pinyin in PostgreSQL
Voronoi Diagrams in PostGIS (Code)
(Under construction, more to come)