Category Archives: Technology

What I’m Reading – July 2018

Here are a few articles I’ve read over the last month that you might find interesting. “I keep it because I have not heard a voice I like better,” he once said, “and because I have identified with it.” He … Continue reading

Posted in In the News, Privacy, Technology | Tagged , , , , | Leave a comment

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

Location-based Search for Property Information

This is third in a series of posts on a side project of mine, NJ Parcels. Read the first and the second parts. In the summer of 2015, we decided to get takeout from a local Greek place. We were … Continue reading

Posted in NJ Parcels, Privacy, Technology | Tagged , , , | Comments Off on Location-based Search for Property Information

Open Data and Personal Privacy

This is the second in a series of articles regarding a side project of mine, NJParcels.com. Read the first article here. Read part three here. Once GlassboroMap and NJ Parcels started to get considerable traffic, I began receiving emails asking for … Continue reading

Posted in Data, NJ Parcels, OPRA, Privacy, Technology | Tagged , , , , | 3 Comments

Update on a side project

This is the first in a series of posts about a side project I’ve been developing and maintaining for the past few years. This introduction will be accompanied by subsequent posts dealing with the technical, commitment, and emotional issues associated … Continue reading

Posted in NJ Parcels, Technology | Tagged , , , , , | 6 Comments

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

“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