Fetches and stores geocoded location data. "Work" will provide geo-coordinate data to supplement data provided by Hawaii Open Data for Traffic Incidents, adding the capability to plot map locations. Data will be stored in a separate database to be utilized by mid and front end developers.

A = Andrew

B = Joanne

1. [A] getIncidentData - retrieves data from Traffic API, converts to a JSON object, creates db model for raw data and inserts data.

2. [J] processAddress - retrieves raw data and prepares valid address.

   a) [J] fixDate - converts date from epoch to local

   b) [J] processAddress - prepares valid address

   c) [J] getGeoCodes - provides valid address to Geo Code API to retrieve geo coordinates (lat=latitude, lng=longitude)

   d) [A] storeIncidents - inserts incidents with valid geo coordinates to the database

3. [A] getRealTimeData - retrieves JSON data from HPD site and stores them on the database daily, and processed by step 2)

4. [J] processIncidents - main program that will emply the first 4 routines. will also provide date-time conversion.

index, date, code, type, address, location, area

Source Data: https://data.honolulu.gov/api/views/ix32-iw26/rows.json?accessType=DOWNLOAD

Notes: 2 hour delay, over 163,000+ records, dates back to Aug 2012

Source Data: http://www4.honolulu.gov/hpdtraffic/ or https://twitter.com/hpdtraffic

Notes: Real-Time data, requires scrapping (later)

Source: http://open.mapquestapi.com/geocoding/

Notes: Account required (J)

Notes: development using Mac OS X version

Production: (TBD)

index: [PK, INT, AUTO INCREMENT, UNIQUE]

number: [INT, over 160,000+]

date: [DATE/TIME]

code: [INT]

type: [STRING]

address: [STRING]

location: [STRING]

area: [STRING]

lat: [FLOAT]

lng: [FLOAT]

Note: postgis.net may provide extensive capability with geography and geometry in the future.

name: [STRING]