Tag Archives: sql

Optimize Your Indexes and Selections

Posted on September 10, 2015 by John Reiser

I have been working on a project that is driven by a series of functions written in PL/pgsql. The functions look at New Jersey’s land use data over several different time periods and selects out certain areas if they have the … Continue reading →

Posted in PostgreSQL, Technology, Tools and Scripts | Tagged , , , , , , | Comments Off on Optimize Your Indexes and Selections

Generating row and column IDs for a hexagon grid

Posted on November 17, 2014 by John Reiser

Recently when working on a project that uses a hexagon grid, I used the awesome mmqgis plugin to QGIS to produce the grid. The one small shortcoming with the tool is that I would prefer to have a cell identifier … Continue reading →

Posted in Data, PostgreSQL, Tools and Scripts | Tagged , , , , | Comments Off on Generating row and column IDs for a hexagon grid

“Doing more with SQL” talk at MAC URISA

Posted on October 30, 2014 by John Reiser

Last week, I gave a 30 minute talk on “Doing More with SQL” at MAC URISA 2014. The slides from the talk are available below:

Posted in Conferences, PostgreSQL, Technology | Tagged , , , , , , , | 3 Comments