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)