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
Tag 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!
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