social networking
- Unless explicitly stated otherwise, the opinions expressed here are my own.
Tag Cloud
- Aerial Photography
- Apple
- ArcGIS
- ArcGIS Server
- Atlantic City
- Changing Landscapes
- Data
- ESRI
- Flickr
- geolab
- Geoserver
- geotagging
- GIS
- 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
- Updates
- Virtual Earth
- visualization
- Web Mapping
- wms
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 Data, gdal/ogr, open data, postgresql
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 indexes, Land Use, new jersey, optimize, postgis, postgresql, sql
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 GIS, Land Use, new jersey, postgis, postgresql, tableau, visualization
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 GIS, hexagons, postgis, postgresql, sql
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