Category Archives: Technology

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

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

Bizarre GeoServer WMS rendering possibly due to ArcGIS handling of PostGIS data

I just submitted a problem to the OpenGeo support forum regarding an unusual bug I’ve discovered in GeoServer. Multipart polygon geometries are producing “unintentional art” when rendered through GeoServer. Several GIS data sets that have been brought into PostGIS using … Continue reading

Posted in Data, Technology, Visualization, Web Mapping | Tagged , , , , , | 1 Comment