Take a look at the City Bird's Eye, the City's Information Portal
The @codeforpgh project reads the City of Pittsburgh Police Blotter daily report, reads the .csv file and loads the data into a PostgreSQL database. The address geo-coding is done using the Allegheny County Address REST service. The Council District number comes from a PostGIS lookup using the addresses lat and lng. This is a daily manual process based on yesterday's data. You can also follow City of Pittsburgh Police Incident Data from the Western Pennsylvania Regional Data Center under Public Safety & Justice.
The Pittsburgh Bureau of Police csv file is processed every morning for the previous day of the city's police incidents. The display is limited to the accuracy of the contents and the number of incidents provided by the police and might not include all incidents for the day. It is important that any decisions based on this data be confirmed using additional resources. As the city says, "The City of Pittsburgh has provided this information as a service. The City assumes no responsibility for the use of information posted on this site." Mark Howe supports the project. Tim Condello, Mark Howe, Andrew McGill, Andy Somerville and Sunil Mogadati are the Original CodeForPittsburgh Project Team Members.