Extract Rodent-Related Features from 311 Data

[jasonasher]

Start with the 311 Service Request data in the /Data Sets/311 Service Requests/ folder in Dropbox.
Write a script that uses this data to produce a feature data table for the number of new 'Rodent Inspection and Treatment' requests in the past week.

You can find the data format and examples on the Feature Dataset Format tab in this document

The 'Rodent Inspection and Treatment' service code is S0311. Additionally, there is a SERVICENOTES field that may give additional information about the response to the given service requests. We are interested in knowing if those fields indicate that the resulting inspections actually found rodents or rodent burrows. We will code these as:
"rats_found", "rats_not_found", or "unknown" depending upon the resulting status.

Input:
CSV files with data for each given year

Output:
A CSV file with

• 1 row for each feature subtype (status of rodents found), week, year, and census block
• The dataset should include the following columns:

feature_id: The ID for the feature, in this case, "311_service_requests"
feature_type: The service code, in this case "S0311"
feature_subtype: The string, either "rats_found", "rats_not_found", or "unknown" that indicates the status of the requests in this feature entry
year: The ISO-8601 year of the feature value, i.e. the year that the service requests were logged (from SERVICEORDERDATE)
week: The ISO-8601 week number of the feature value, i.e. the week that the service requests were logged (from SERVICEORDERDATE)
census_block_2010: The 2010 Census Block of the feature value
value: The value of the feature, i.e. the number of 'Rodent Inspection and Treatment' requests of the specified subtypes in the given census block during the week and year above.

When you are finished
Submit a pull request on GitHub (or upload your scripts)
Upload any files to Dropbox

Need more information?
Flag Jason or Elizabeth, or ask your question in the comments below and we'll respond as soon as we can!

[supermdat]

Hi @jasonasher and @eclee25. I'm interested in working on this issue, but I don't think I have rights to assign it. Could one of you assign to me please? Thanks.

[supermdat]

Thanks, @jasonasher!

[jasonasher]

I think GitHub still doesn't have assignment of issues for non-collaborators!