70 reputation
5
bio website
location
age 41
visits member for 1 year, 5 months
seen Apr 8 at 13:16

I grew up in Youngstown, NY with a deep respect and fascination for the Laurentian Great Lakes and all things water. After a dabbling with interests in sports medicine, and being a professional potter, undergraduate work at CU - Boulder led me back to my passion for water and science. Undergrad degree in tow I worked as an aquatic toxicologist and GIS/RS analyst in the Front Range. Graduate work at Wisconsin – Milwaukee fed my curiosity about the Great Lakes extended my interests in data analysis and management. My projects involved climate change modeling, phytoplankton physiology, riding research vessels in the frigid Lake Michigan, managing an environmental database development effort, and of course GIS/RS. My next job found me in Fairfax, Virginia where I was able to continue with most of my professional interests. The chaos of Greater D.C and a need to be closer to family brought us to Portland, Maine. I am still passionate about all things water, environmental, and spatial and am a strong advocate for Open Source software (for a variety of reasons). I lead software development and data management projects for Tetra Tech and focus on things geospatial.


Dec
18
awarded  Tumbleweed
Dec
11
asked Feature Service from plain Postgres/PostGIS in ArcGIS Server 10.2
Apr
2
awarded  Supporter
Jan
3
comment Standard for storing human metadata in spatial databases
Sandro (author of Spatialite) must have heard this cry in the wilderness - via googlegroups.com Hi List, a BETA preview of the next-to-come SpatiaLite 4.1.0 is now available gaia-gis.it/fossil/libspatialite/… Main goals are: - storing XML Documents within the DBMS - support XML validation - support plain SQL queries on XML Documents via canonical XPath expressions Implementing a common core of XML-oriented features is useful considering that ISO- and INSPIRE-Metadata or SLD/SE Styles are fully based on XML.
Dec
4
comment Are there tools to directly import QGIS projects into Tilemill?
Not an an answer here, but having a utility to quickly stub out CartoCSS from QGIS would be a big help and would lower the bar for casual users who really want the power of Tilemill but can't rapidly spit out CSS yet. Something a little more mature than this. github.com/yuletide/QGISTileMillExport
Nov
29
accepted ogrinfo bash script failure
Nov
29
answered ogrinfo bash script failure
Nov
27
asked ogrinfo bash script failure
Nov
27
accepted Standard for storing human metadata in spatial databases
Nov
14
comment Standard for storing human metadata in spatial databases
Thanks all for the responses. I updated my original post with more information. I think I'm returning to conclusion that no one is really doing this out-of-the-box, but the solution would be "simply" create a table for metadata blobs (store XML of some standard) with triggers to create rows whenever a new spatial table is added to the DB. CREATE TABLE "layer_metadata" ("meta_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL UNIQUE , "f_table_name" TEXT NOT NULL, "created_dt" DATETIME NOT NULL , "updated_dt" DATETIME NOT NULL , "meta_document" BLOB NOT NULL )
Nov
14
awarded  Editor
Nov
14
revised Standard for storing human metadata in spatial databases
added 1735 characters in body
Nov
13
asked Standard for storing human metadata in spatial databases
Nov
13
awarded  Scholar
Nov
13
accepted OSS java approach to convert Shapefile to GML
Nov
2
awarded  Student
Nov
2
asked OSS java approach to convert Shapefile to GML