Category Archives: Tools and Scripts

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

Unix Philosophy

Often, when I go to tackle a problem, I look to use the simplest tools available first. Unix (and its derivatives/descendants, like Mac OS X and Linux) was designed with the following principles in mind: Write programs that do one … Continue reading

Posted in Data, Technology, Tools and Scripts | Comments Off on Unix Philosophy

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

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

Key issue with New Jersey’s parcel data

I’ve been working on a project to visualize differences between assessed value and levied taxes in New Jersey and I discovered a bug in some of New Jersey’s parcel data. New Jersey uses “PAMS_PIN” as a key between the GIS … Continue reading

Posted in Data, Tools and Scripts | Comments Off on Key issue with New Jersey’s parcel data

Mitch Hedberg and GIS

So, a recent post on Reddit highlighted a Mitch Hedberg joke. “La Quinta” is Spanish for “next to Denny’s.” Thinking about this, I realized we could use GIS to find the number of La Quintas that are next to Denny’s. … Continue reading

Posted in Data, Google Maps, In the News, Teaching, Technology, Tools and Scripts, Web Mapping | 4 Comments

Pulling data from OSM using XAPI, bringing it to ArcGIS

I was recently asked by a friend if I knew of an ArcGIS-friendly data set representing the highway interchanges within New Jersey. I knew the information was already available in OpenStreetMap, but how could I quickly pull just the highway … Continue reading

Posted in OpenStreetMap, Technology, Tools and Scripts | Tagged , , , , , | 1 Comment

Back to the New Normal

It’s been a while since I last posted to the ol’ Blog. After I returned from the DevSummit in March, my free time dwindled down to nothing. The end of the spring semester has been a whirlwind of activity; developing … Continue reading

Posted in Technology, Tools and Scripts, Updates, Web Mapping | Tagged , , , | Comments Off on Back to the New Normal

March Madness

Back in January, I had every intention of updating this weekly, but once the semester starts, all bets were off. It’s been a crazy few weeks, juggling several research projects, two classes and compiling everything needed for my recontracting at … Continue reading

Posted in Conferences, Events, Technology, Tools and Scripts, Web Mapping | Tagged , , , | 1 Comment