Dataset: 311 Data

This data set shows 311 service requests in the City of Pittsburgh. This data is collected from the request intake software used by the 311 Response Center in the Department of Innovation & Performance. Requests are collected from phone calls, tweets, emails, a form on the City website, and through the 311 mobile application. For more information, see the 311 Data User Guide. If you are unable to download this data due to a 504 Gateway Timeout error, use this link instead: https://tools.wprdc.org/downstream/76fda9d0-69be-4dd5-8108-0de7907fc5a4

n__id Id	created_on CREATED ON	request_type REQUEST TYPE	request_origin REQUEST ORIGIN	status STATUS	department DEPARTMENT	neighborhood NEIGHBORHOOD	council_district COUNCIL DISTRICT	ward WARD	tract TRACT	public_works_division PUBLIC WORKS DIVISION	pli_division PLI DIVISION	police_zone POLICE ZONE	fire_zone FIRE ZONE	x X	y Y	geo_accuracy GEO ACCURACY
1	Fri Dec 15 2017 14:53:00 GMT+0000 (Coordinated Universal Time)	Street Obstruction/Closure	Call Center	1	DOMI - Permits	Central Northside	1	22	42003220600	1	22	1	1-7	-80.01671599999997	40.4541445	EXACT
2	Wed Nov 29 2017 09:54:00 GMT+0000 (Coordinated Universal Time)	Graffiti	Control Panel	1	Police - Zones 1-6	South Side Flats	3	16	42003160900	3	16	3	4-24	-79.96995167550452	40.42924284135323	APPROXIMATE
3	Fri Dec 01 2017 13:23:00 GMT+0000 (Coordinated Universal Time)	Litter	Call Center	1	DPW - Street Maintenance	Troy Hill	1	24	42003240600	1	24	1	1-2	-79.98585860000003	40.4597155	EXACT
4	Wed Nov 22 2017 14:54:00 GMT+0000 (Coordinated Universal Time)	Water Main Break	Call Center	1	Pittsburgh Water and Sewer Authority	Banksville	2	20	42003202300	5	20	6	4-9	-80.03420990000001	40.4069693	EXACT
5	Thu Oct 12 2017 12:46:00 GMT+0000 (Coordinated Universal Time)	Guide Rail	Call Center	1	DPW - Construction Division	East Hills	9	13	42003130600	2	13	5	3-19	-79.87658200118864	40.45122643152347	EXACT
6	Tue Oct 31 2017 15:17:00 GMT+0000 (Coordinated Universal Time)	Guide Rail	Call Center	1	DPW - Construction Division	East Hills	9	13	42003130600	2	13	5	3-19	-79.8768234	40.4511652	EXACT
7	Fri Oct 13 2017 09:18:00 GMT+0000 (Coordinated Universal Time)	Sidewalk/Curb/HC Ramp Maintenance	Call Center	1	DOMI - Permits	Mount Washington	4	19	42003191500	5	19	3	4-27	-80.01249866634826	40.417229899017336	APPROXIMATE
8	Fri Oct 27 2017 10:23:00 GMT+0000 (Coordinated Universal Time)	Manhole Cover	Call Center	1	DOMI - Permits	Bluff	6	1	42003010300	3	1	2	2-4	-79.98558587196658	40.4352631774289	EXACT
9	Mon Aug 14 2017 14:00:00 GMT+0000 (Coordinated Universal Time)	Neighborhood Issues	Control Panel			Middle Hill	6	5	42003050100	3	5	2	2-1	-79.97772618726532	40.44614211166076	APPROXIMATE
10	Fri Sep 29 2017 11:46:00 GMT+0000 (Coordinated Universal Time)	Mayor's Office	Website	1	311	North Oakland	8	4	42003040400	3	4	4	2-9	-79.94974002603021	40.44811656807566	APPROXIMATE

n__id

request_id

REQUEST ID

created_on

CREATED ON

request_type

REQUEST TYPE

request_origin

REQUEST ORIGIN

status

STATUS

department

DEPARTMENT

neighborhood

NEIGHBORHOOD

council_district

COUNCIL DISTRICT

ward

WARD

tract

TRACT

public_works_division

PUBLIC WORKS DIVISION

pli_division

PLI DIVISION

police_zone

POLICE ZONE

fire_zone

FIRE ZONE

x

y

geo_accuracy

GEO ACCURACY

Fri Dec 15 2017 14:53:00 GMT+0000 (Coordinated Universal Time)

Street Obstruction/Closure

Call Center

DOMI - Permits

Central Northside

42003220600

1-7

-80.01671599999997

40.4541445

EXACT

Wed Nov 29 2017 09:54:00 GMT+0000 (Coordinated Universal Time)

Graffiti

Control Panel

Police - Zones 1-6

South Side Flats

42003160900

4-24

-79.96995167550452

40.42924284135323

APPROXIMATE

Fri Dec 01 2017 13:23:00 GMT+0000 (Coordinated Universal Time)

Litter

Call Center

DPW - Street Maintenance

Troy Hill

42003240600

1-2

-79.98585860000003

40.4597155

EXACT

Wed Nov 22 2017 14:54:00 GMT+0000 (Coordinated Universal Time)

Water Main Break

Call Center

Pittsburgh Water and Sewer Authority

Banksville

42003202300

4-9

-80.03420990000001

40.4069693

EXACT

Thu Oct 12 2017 12:46:00 GMT+0000 (Coordinated Universal Time)

Guide Rail

Call Center

DPW - Construction Division

East Hills

42003130600

3-19

-79.87658200118864

40.45122643152347

EXACT

Tue Oct 31 2017 15:17:00 GMT+0000 (Coordinated Universal Time)

Guide Rail

Call Center

DPW - Construction Division

East Hills

42003130600

3-19

-79.8768234

40.4511652

EXACT

Fri Oct 13 2017 09:18:00 GMT+0000 (Coordinated Universal Time)

Sidewalk/Curb/HC Ramp Maintenance

Call Center

DOMI - Permits

Mount Washington

42003191500

4-27

-80.01249866634826

40.417229899017336

APPROXIMATE

Fri Oct 27 2017 10:23:00 GMT+0000 (Coordinated Universal Time)

Manhole Cover

Call Center

DOMI - Permits

Bluff

42003010300

2-4

-79.98558587196658

40.4352631774289

EXACT

Mon Aug 14 2017 14:00:00 GMT+0000 (Coordinated Universal Time)

Neighborhood Issues

Control Panel

Middle Hill

42003050100

2-1

-79.97772618726532

40.44614211166076

APPROXIMATE

Fri Sep 29 2017 11:46:00 GMT+0000 (Coordinated Universal Time)

Mayor's Office

Website

311

North Oakland

42003040400

2-9

-79.94974002603021

40.44811656807566

APPROXIMATE

CREATE TABLE n_311_data ( "n__id" BIGINT, "request_id" DOUBLE, "created_on" TIMESTAMP, "request_type" VARCHAR, "request_origin" VARCHAR, "status" BIGINT, "department" VARCHAR, "neighborhood" VARCHAR, "council_district" DOUBLE, "ward" DOUBLE, "tract" DOUBLE, "public_works_division" DOUBLE, "pli_division" DOUBLE, "police_zone" DOUBLE, "fire_zone" VARCHAR, "x" DOUBLE, "y" DOUBLE, "geo_accuracy" VARCHAR );

311 Data

Table List

311 Data

@usgov.allegheny_county_city_of_pitts_311_data.n_311_data

n__id

request_id

created_on

request_type

request_origin

status

department

neighborhood

council_district

ward

tract

public_works_division

pli_division

police_zone

fire_zone

x

y

geo_accuracy

Share link