mheadd

Here are some steps to bring the bulk Philly311 CSV file into a local SQLite database to enable SQL queries.

Tools you'll use

• sqlite3 (installed by default on OS X - try typing in ~$ which sqlite3 at a command prompt).
• csvsql (follow installation instructions here if not already installed).
• SQLite Manager for Firefox.

Steps

mheadd

mheadd

From Town of Tully (Town Hall) to Syracuse Coworks

Standard Route

• Start out going west on Meetinghouse Rd toward State Route 281/NY-281.
• Turn right onto State Route 281/NY-281.
• State Route 281/NY-281 becomes US Route 11/US-11 N.
• Merge onto I-81 N via the ramp on the left.
• Take the Adams St exit, EXIT 18, toward Harrison St.
• Stay straight to go onto Almond St.
• Turn left onto E Genesee St/NY-92.

mheadd

# Using the dataUSA.io API for Census Data in R

This gist contains some notes on constructing a query for census and economic data from the [DataUSA.io](http://datausa.io/) site. This is a quick-start guide to their API; for in-depth documentation check out their [API documentation](https://github.com/DataUSA/datausa-api/wiki/Overview).

A great way to learn how to structure a query is to visit a specific datausa.io page and click on the "Options" button on top of any graph, then select "API" to see the query syntax that created the graph.


![Analytics](https://ga-beacon.appspot.com/UA-27835807-2/gist-id?pixel)

## Example Use

mheadd

• Toward a Definition of the Coproduction Concept. Jeffrey L. Brudney and Robert E. England (1983)

• Managing Coprovision: Using Expectancy Theory to Overcome the Free-Rider Problem. Kathleen J. Powers and Fred Thompson (1994)

• Institutionalised Co-production: Unorthodox Public Service Delivery in Challenging Environments. Anuradha Joshi and Mick Moore (2006)

• Beyond Engagement and Participation: User and Community Coproduction of Public Services. Tony Bovaird (2007)

• It takes Two to Tango? Understanding the Co-production of Public Services by Integrating the Services Management and Public Administration Perspectives. Stephen P. Osborne and Kirsty Stro

mheadd

Summary

Use state-level data on business registration, permitting and inspections to cross check against local data sets for non-permitted businesses.

Opportunities

• Identify unlicensed or unpermitted businesses or business activity.
• Identify business that are not in compliance with local zoning ordinances (e.g., areas that are not zoned for commercial activities).
• Validate (or optimize) snow plowing routes, particularly during times of snow or weather related emergencies.
• Generate macro-level indicators of business activity in a city or region.

mheadd

~$ curl -s 'http://ipsweb.ci.syracuse.ny.us/searchList.svc/getStreets' \
-H 'Content-Type: application/json' \
--data-binary '{"street":"Geddes St"}' 

"Arden Dr & Geddes St S"
"Bear St W To Geddes St N"
"Bellevue Ave & Geddes St"

mheadd

mysql> select distinct(Conviction_Description) from convictions where Conviction_Description like '%SPEED%';
+----------------------------------------------------+
| Conviction_Description                             |
+----------------------------------------------------+
| SPEED IN ZONE                                      |
| SPEEDING                                           |
| SPEEDING +15                                       |
| SPEED NOT REASONABLE AND PRUDENT                   |
| SPEEDING IN A WORK ZONE OR ON A RESTRICTED HIGHWAY |

mheadd

App Challenge Presentation: Tips & Tricks

The purpose of an app challenge demo or presentation is to succinctly present your work on a civic app or solution to a panel of judges. It is usually the culmination of days (or even weeks) of work, and may only be limited to a few minutes.

Here are a set of suggestions that can help make these few minutes in front of a judging panel as effective and impactful as possible.

Get ready

Prepare your presentation ahead of time - while judges may understand the desire to work on a project right up to the last minute, making sure your presentation is solid and tells a compelling story is as important as your project itself. Take the time to prepare slides or a similar visual presentation that can accompany your remarks to the judges.

mheadd

       IDENTIFICATION DIVISION.
       PROGRAM-ID. CLIOPTIONS.
       ENVIRONMENT DIVISION.
       DATA DIVISION.
       WORKING-STORAGE SECTION.

       01 argv                 pic x(100) value spaces.

       PROCEDURE DIVISION.
       ACCEPT argv FROM argument-value