Tag: ArcGIS

Analysis, ArcGIS, Database, PostGIS, PostgreSQL, SQL

Proper (ab)use of a database, contour interpolation using #postgresql #postgis #arcgis

Anyone who has been following along at home knows I don’t think much like a DBA.  Sometimes that’s good; mostly it’s probably bad.  In this post, I hope it will be interesting. The problem of the day is how to take engineering contours derived from breaklines, a lidar point cloud, and all the lot, and do a good job interpolating that to a DEM.  This … Continue reading Proper (ab)use of a database, contour interpolation using #postgresql #postgis #arcgis

Unknown's avatarsmathermatherLeave a comment
Other

Historical USGS Quads

This will be a very quick post today.  We wanted to use some historical USGS quads for analysis.  We had a ready source, used ArcGIS to georeference them to a grid, but then wanted something approaching a seamless product. Enter gdal. First step, create an image to put the mosaic into: gdal_merge -o usgs_merge.tif -createonly input1.tif input2.tif … Then mosaic into that.  Since we have … Continue reading Historical USGS Quads

Unknown's avatarsmathermather1 Comment
Database, PostGIS, SQL

Geometry Collections and Small Headaches

The disk that held the personal geodatabases of our contour datasets died a while back, but not before I loaded the contours into PostGIS and started serving them up. Our new intern is working on putting together some shapefiles layer groups in ArcGIS for map production, and asked for a missing one… . I don’t have it, but in principle can always extract it from … Continue reading Geometry Collections and Small Headaches

Unknown's avatarsmathermather5 Comments
GeoServer, PostGIS

Parcel Annotations in GeoServer (with some Maplex help)

smathermather: We have a guest blogger today– Ramon, a bright and hard-working intern I’ve had the pleasure of working with for over a year.  If you’re looking for someone versed in Postgre/PostGIS/GeoServer/OpenLayers, Ramon’s been my rock as we’ve been building our internal system, doing everything from basic grunt work to esoteric trouble-shooting.  I’m trying hard not to fall on my face now that he’s moved … Continue reading Parcel Annotations in GeoServer (with some Maplex help)

Unknown's avatarsmathermather2 Comments
Uncategorized

Garmin Custom Maps

I don’t spend much time on field equipment, e.g. GPS units.  Why?  Lack of interest?  No.  Lack of space in my job description.  Yes, I know.  A GIS Manager who doesn’t have a GPS is it’s own category of silly.  None-the-less, when a colleague told me that Garmin now has firmware support for custom maps for some of it’s GPS units, I told him it … Continue reading Garmin Custom Maps

Unknown's avatarsmathermather3 Comments
Other

ArcGIS, Layer Packages and Workarounds

I’ve said before that I work in a hybrid shop– part ESRI, part Open Source. We use GeoExt/OpenLayers/GeoServer/PostGIS for the Enterprise stuff, and ESRI for the analyses, some specialized cartography, and the easy way out on one-off projects. I mostly blog about the Open Source stuff, ’cause that’s where my heart (and budget) lays. So, now for some ESRI Fan geek-dum. Plus the obligatory work … Continue reading ArcGIS, Layer Packages and Workarounds

Unknown's avatarsmathermather2 Comments
Database, PostGIS, SQL

Shapfile spatial indices and PostGIS dumps

Another short post… . I have in place a framework for maintenance of our boundary data that works really well. I feed an edited shapefile into the database, and PostGIS creates all the versions of the boundary that need created. The database then exports the managed data to shapefile so there is a database version and a shapefile version depending on need. When all was … Continue reading Shapfile spatial indices and PostGIS dumps

Unknown's avatarsmathermather2 Comments