Extract 'Overdue Inspections' Feature from Restaurant Inspection Data

[jasonasher]

This issue is being migrated just for administrative tracking from the original on the dc_doh_hackathon repository, which can be found here:
issue_17

Start with the DC DOH Food Service Establishment Inspection report data in the /Data Sets/Restaurant Inspections/ folder in Dropbox.

Develop a script to extract the number of overdue restaurant inspections. Food establishments are categorized by Risk Category from 1-5, and this determines the frequency at which inspections should be conducted. More details can be found here

Note that this issue depends upon the geocoding results from Issue #13

Input:
CSV files with inspection summary and violation details

Output:
A CSV file with

• 1 row for each establishment type and risk category, and each week, year, and census block
• The following columns:

feature_id: The ID for the feature, in this case, "restaurant_inspections_overdue"
feature_type: The establishment_type from the restaurant data set
feature_subtype: The risk_category from 1-5
year: The ISO-8601 year of the feature value
week: The ISO-8601 week number of the feature value
census_block_2010: The 2010 Census Block of the feature value
value: The value of the feature, i.e. the number of inspections that are overdue for establishments with the given types and risk categories in the specified week, year, and census block.