"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
-
[A] getIncidentData - retrieve JSON data from Traffic API
-
[J] processAddress - prepare valid address
-
[J] getGeoCodes - provide valid address to Geo Code API to retrieve geo coordinates (lat=latitude, lng=longitude)
-
[A] storeIncidents - insert incidents with valid geo coordinates to PostgreSQL database
incident_number, date, code, type, address, location, area
Source Data: https://data.honolulu.gov/api/views/INLINE/rows.json?accessType=DOWNLOAD
Notes: 2 hour delay, over 162,000+ records, dates back to Aug 2012
Source Data: http://www4.honolulu.gov/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]
number: [INT, over 160,000+]
date: [DATE/TIME]
code: [INT or code table?]
type: [STRING or FK to code_index?]
address: [STRING]
location: [STRING]
area: [STRING]
geo_coord: gc_index [FK]
gc_index: [PK, INT, AUTO]
col: lat [FLOAT]
col: lng [FLOAT]