Code snippet 9 for blog post http://blog.geomusings.com/2014/02/18/a-little-deeper-with-node-and-postgis/

snippet9.js

app.get('/leonardtown/buildings/:geom', function (req, res, next) {
  var client = new pg.Client(app.conString);
  var geom = req.params.geom.toLowerCase();
  if ((geom != "features") && (geom != "geometry")) {
      res.status(404).send("Resource '" + geom + "' not found");
      return;
  }
  var tablename = "leonardtown_bldgs";
  var schemaname = "public";
  var fullname = schemaname + "." + tablename;
  var spatialcol = "";
  var proptype = req.query.type;
  var whereclause = ";";
  if (typeof proptype != "undefined") {
      if (proptype.toLowerCase() != "all") {
          whereclause = " where structure_ = '" + proptype + "';";
      }
  }
  var coll;
  var sql = "";
  //logic continues from here