- Unless explicitly stated otherwise, the opinions expressed here are my own.
Tag CloudAerial Photography Apple ArcGIS ArcGIS Server Atlantic City Changing Landscapes Data ESRI Flickr geolab Geoserver geotagging GIS Google Google Earth Google Latitude Google Map Maker Google Maps Government gps Hurricane Land Use Location-based Services Microsoft new jersey New Jersey Geospatial Forum New Jersey State Atlas njgeo open source OpenStreetMap Planning postgis postgresql Privacy python Rowan University satellite social networking Teaching Twitter Updates Virtual Earth visualization Web Mapping wms
Category Archives: PostgreSQL
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
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
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
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
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
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:
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.