Extract Non-Rodent 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 service requests in the past week that are not rodent-related (there is a separate issue to process rodent-related requests).

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. We are interested in all other service request types for this feature.

Input: CSV files with data for each given year

Output: A CSV file with

• 1 row for each service code, 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, found in the SERVICECODE column of the 311 data feature_subtype: Left blank 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 311 service requests with the specified service code 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!

[meghnakayam]

Completed

[jasonasher]

Closed and migrated to the-rat-hack