cakephp controller save from scaffolded “join table” relationship, non-conventional primary keys

When I build interfaces on top of a pre-established database schema, I usually can’t change schema properties.  That’s a problem when working with a “convention over configuration” MVC Framework like cakephp. After baking/scaffolding a CRUD interface based on a “join table” (HABTM) class, that issue came into focus, once again.  I have had run into…

Undocumented KML Output Conversion, GDAL

As noted here: http://gis.stackexchange.com/questions/18280/batch-convert-geotiffs-to-kmz-files, an undocumented method for conversion to KML exists in GDAL’s gdal_translate as format KMLSUPEROVERLAY.  To do this with an existing image, such as a geotiff, your command will be the following format (on Windows): C:OSGeo4W64>gdal_translate -of KMLSUPEROVERLAY   FORMAT=JPEGwith an example path, this looks like:C:OSGeo4W64>gdal_translate -of KMLSUPEROVERLAY D:downloadstile177_12orthos177.tif D:downloadstile177_12orthos177.kml -co FORMAT=JPEGThis will output…

Disk I/O Error on sqlite/spatialite

On running sqlite CREATE and INSERT queries, I was getting some mysterious errors, like “Error: disk I/O error”, despite having the proper permissions on the .sqlite file and adequate space in the directory.  I then broke down the compound query to a simple query and was getting “GEOS error: IllegalArgumentException: Points of LinearRing do not…

github push 403 and Permission denied

Initially I was getting error: The requested URL returned error: 403 Forbidden while accessing https://github.com/.. on $ git push origin master I read a forum post that recommended $ vi .git/config and changing the url line from https://github.com/.. to ssh://github.com/.. and then generating public/private keys and adding this to github.  After doing so I was…

Quick GIS tip of the day, 6/10/14

To keep symbology of a shapefile or geodatabase feature class, save a layer as a “layer file” (.lyr).  If you keep this .lyr file in the same relative path location (in the same directory, for instance), it should continue to reference the data and you can just add the .lyr instead of the data itself.  If…

Colored Conventions

Developed a digital humanities website, in collaboration with Dr. Gabrielle Foreman et al. (University of Delaware).  The site illuminates the so called Colored Conventions, postbellum meetings of Black Americans around the profound issues of the day, through mapping and digital humanities methods.  This project was built on the Omeka CMS for Digital Humanities and Neatline, Geoserver integrated…