app.js

// server.js

// BASE SETUP
// =============================================================================

// call the packages we need
var express    = require('express');        // call express
var app        = express();                 // define our app using express
var bodyParser = require('body-parser');
var request = require('request');
var url = require('url');
var _ = require('lodash');

// configure app to use bodyParser()
// this will let us get the data from a POST
app.use(bodyParser.urlencoded({ extended: true }));
app.use(bodyParser.json());

var port = process.env.PORT || 8080;        // set our port

// ROUTES FOR OUR API
// =============================================================================
var router = express.Router();              // get an instance of the express Router

// test route to make sure everything is working (accessed at GET http://localhost:8080/api)
router.get('/dsd/code-enforcement', function(req, res) {
  var dsdURL = "http://opendsd.sandiego.gov/web/Api/Maps/CECase?SearchType=CECase&SouthWestLatitude=32.71879985593221&SouthWestLongitude=-117.16525563507082&NorthEastLatitude=32.74399836325726&NorthEastLongitude=-117.12534436492922&Page=1&PageLimit=100";

  request(dsdURL, function(error, response, body) {
    var body = JSON.parse(body);
    var features = new Array();
    _.each(body.results, function(element, index) {
      // Change fields based on permit type. Need to make flexible for other OpenDSD types, also, need
      // to understand what the "Case Depiction" field actually does.

      var titleString = "There's been a code enforcement case updated near you at: " +element.StreetAddress+".<br/> The violation is "+ element.Description +".<br/> You can find out more at: http://opendsd.sandiego.gov/web/CECases/Details/"+ element.CaseId

      var feature = {
        id: element.caseId,
        type: "Feature",
        geometry: {
          type: "Point",
          coordinates: [element.Longitude, element.Latitude],
        },
        properties: {
          "id":element.CaseId,
          "Description": element.Description,
          "OpenDate":element.OpenDate,
          "CloseDate":element.CloseDate,
          "StreetAddress":element.StreetAddress,
          "title": titleString,
        }
      };
      features.push(feature);
    });
    var resp = {
      "type": "FeatureCollection",
      "features": features
    }
    return res.json(resp);
  });
});


// Route for Discretionary Approvals. Access/GET http://localhost:8080/approvals)
router.get('/dsd/approvals', function(req, res) {
  var dsdURL = "http://opendsd.sandiego.gov/web/Api/Maps/ApprovalsMap?SearchType=Discretionary&SouthWestLatitude=32.71879985593221&SouthWestLongitude=-117.16525563507082&NorthEastLatitude=32.74399836325726&NorthEastLongitude=-117.12534436492922&Page=1&PageLimit=100";

  request(dsdURL, function(error, response, body) {
    var body = JSON.parse(body);
    var features = new Array();
    _.each(body.results, function(element, index) {
      // Change fields based on permit type. Need to make flexible for other OpenDSD types, also, need
      // to understand what the "Case Depiction" field actually does.

      var titleString = element.ApprovalType+" approval for project \"" +element.ProjectTitle+"\".<br/> You can find out more at: http://opendsd.sandiego.gov/web/Approvals/Details/"+element.ApprovalId

      var feature = {
        id: element.caseId,
        type: "Feature",
        geometry: {
          type: "Point",
          coordinates: [element.Longitude, element.Latitude],
        },
        properties: {
          "ApprovalId":element.ApprovalId,
          "ApprovalType": element.ApprovalType,
          "ApprovalScope": element.ApprovalScope,
          "CompleteCancelDate":element.CompleteCancelDate,
          "IssuedDate":element.IssuedDate,
          "ProjectId":element.ProjectId,
          "ProjectTitle":element.ProjectTitle,
          "title": titleString,
        }
      };
      features.push(feature);
    });
    var resp = {
      "type": "FeatureCollection",
      "features": features
    }
    return res.json(resp);
  });
});


// more routes for our API will happen here


// REGISTER OUR ROUTES -------------------------------
// all of our routes will be prefixed with /api
app.use('/', router);

// START THE SERVER
// =============================================================================
app.listen(port);
console.log('Magic happens on port ' + port);