Category Archives: PostgreSQL

Broken libraries? Docker to the rescue!

I’m working on some spatial data, loading shapefiles into PostgreSQL on an older server of mine. Revisiting my previous blog post, I wanted to review more recent NJ Land Use/Land Cover data with the 2002 LULC data I imported to … Continue reading

Posted in Data, PostgreSQL, Tools and Scripts | Tagged , , , | Comments Off on Broken libraries? Docker to the rescue!

Presentations at MAC URISA 2018

I’m currently down at the MAC URISA 2018 conference in Atlantic City. This year, I conducted a full-day workshop on Spatial SQL. I also presented on using Docker to explore open source GIS offerings. If you’re still around at the … Continue reading

Posted in Conferences, PostgreSQL, Teaching, Technology, Tools and Scripts | Comments Off on Presentations at MAC URISA 2018

Leveraging the Power of Spatial Databases

I’m out at the ESRI DevSummit this year, and tonight I presented the following talk on using SQL to perform spatial analysis tasks. The presentation slides are included here. I tried to squeeze in several examples, including mapping 2,199 farms … Continue reading

Posted in Conferences, ESRI, Events, PostgreSQL, Technology, Tools and Scripts | Comments Off on Leveraging the Power of Spatial Databases

Optimize Your Indexes and Selections

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

Using Tableau to visualize land use change

I was home sick on Wednesday, so while I was on the couch I decided to dive into Tableau Public, a free desktop visualization tool. At IERP, we use Tableau for some of our public dashboards. Other than some minor … Continue reading

Posted in Data, Planning, PostgreSQL, Technology, Tools and Scripts, Visualization | Tagged , , , , , , | 1 Comment

Generating row and column IDs for a hexagon grid

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

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

Insignificant Spaces

Yesterday, I mentioned that I discovered ArcGIS’s inconsistent handling of spaces within text fields. Today, I tested to see how ArcGIS handles NULLs, Empty Strings and Spaces within its native file formats.

Posted in Data, PostgreSQL, Technology, Tools and Scripts | Comments Off on Insignificant Spaces