{"help": "https://data.wprdc.org/de/api/3/action/help_show?name=datastore_search", "success": true, "result": {"include_total": true, "limit": 100, "records_format": "objects", "resource_id": "29462525-62a6-45bf-9b5e-ad2e1c06348d", "total_estimation_threshold": null, "records": [{"_id":1,"group_id":"827262","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"DPW - Administration","request_type_name":"Park Shelter","request_type_id":"543","create_date_et":"2024-03-12T10:50:00","create_date_utc":"2024-03-12T14:50:00","last_action_et":"2024-03-12T10:50:00","last_action_utc":"2024-03-12T14:50:00","closed_date_et":null,"closed_date_utc":null,"origin":"Call Center","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":2,"group_id":"720661","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"DPW - Administration","request_type_name":"Park Shelter","request_type_id":"543","create_date_et":"2023-03-20T07:52:00","create_date_utc":"2023-03-20T11:52:00","last_action_et":"2023-03-20T07:52:00","last_action_utc":"2023-03-20T11:52:00","closed_date_et":null,"closed_date_utc":null,"origin":"Call Center","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":3,"group_id":"722010","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"DPW - Administration","request_type_name":"Park Shelter","request_type_id":"543","create_date_et":"2023-03-24T07:44:00","create_date_utc":"2023-03-24T11:44:00","last_action_et":"2023-03-24T07:44:00","last_action_utc":"2023-03-24T11:44:00","closed_date_et":null,"closed_date_utc":null,"origin":"Call Center","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":4,"group_id":"846915","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"Police - Zones 1-6","request_type_name":"Illegal Parking","request_type_id":"417","create_date_et":"2024-05-19T12:24:00","create_date_utc":"2024-05-19T16:24:00","last_action_et":"2024-05-19T12:24:00","last_action_utc":"2024-05-19T16:24:00","closed_date_et":null,"closed_date_utc":null,"origin":"Website","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":5,"group_id":"853708","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"DPW - Facilities","request_type_name":"City Facility","request_type_id":"375","create_date_et":"2024-06-06T23:04:00","create_date_utc":"2024-06-07T03:04:00","last_action_et":"2024-06-06T23:04:00","last_action_utc":"2024-06-07T03:04:00","closed_date_et":null,"closed_date_utc":null,"origin":"Website","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":6,"group_id":"882180","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"311","request_type_name":"Thank You - 311","request_type_id":"554","create_date_et":"2024-09-03T13:19:00","create_date_utc":"2024-09-03T17:19:00","last_action_et":"2024-09-03T13:19:00","last_action_utc":"2024-09-03T17:19:00","closed_date_et":null,"closed_date_utc":null,"origin":"Call Center","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":7,"group_id":"762329","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"311","request_type_name":"Mayor's Office","request_type_id":"281","create_date_et":"2023-07-25T10:38:00","create_date_utc":"2023-07-25T14:38:00","last_action_et":"2023-07-25T10:38:00","last_action_utc":"2023-07-25T14:38:00","closed_date_et":null,"closed_date_utc":null,"origin":"Call Center","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":8,"group_id":"189833","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":null,"request_type_name":"Discrimination/Unfair Practices","request_type_id":"118083","create_date_et":"2017-09-27T11:14:00","create_date_utc":"2017-09-27T15:14:00","last_action_et":"2017-09-27T11:14:00","last_action_utc":"2017-09-27T15:14:00","closed_date_et":null,"closed_date_utc":null,"origin":"Website","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":9,"group_id":"707454","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"311","request_type_name":"Police Department","request_type_id":"283","create_date_et":"2023-01-23T10:02:00","create_date_utc":"2023-01-23T15:02:00","last_action_et":"2023-01-23T11:48:00","last_action_utc":"2023-01-23T16:48:00","closed_date_et":null,"closed_date_utc":null,"origin":"Call Center","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":10,"group_id":"660188","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"Finance","request_type_name":"City Source (CDBG)","request_type_id":"29136","create_date_et":"2022-07-27T12:00:00","create_date_utc":"2022-07-27T16:00:00","last_action_et":"2022-07-27T12:00:00","last_action_utc":"2022-07-27T16:00:00","closed_date_et":null,"closed_date_utc":null,"origin":"Call Center","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":11,"group_id":"871271","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"DPW - Refuse","request_type_name":"Missed Refuse Pick Up","request_type_id":"507","create_date_et":"2024-07-30T12:01:00","create_date_utc":"2024-07-30T16:01:00","last_action_et":"2024-07-30T12:01:00","last_action_utc":"2024-07-30T16:01:00","closed_date_et":null,"closed_date_utc":null,"origin":"Call Center","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Wilkinsburg","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":12,"group_id":"873927","num_requests":1,"parent_closed":false,"status_name":"in progress","status_code":3,"dept":"DPW - Forestry Division","request_type_name":"Pruning (city tree)","request_type_id":"520","create_date_et":"2024-08-07T11:25:00","create_date_utc":"2024-08-07T15:25:00","last_action_et":"2024-08-21T08:29:00","last_action_utc":"2024-08-21T12:29:00","closed_date_et":null,"closed_date_utc":null,"origin":"Website","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":13,"group_id":"717243","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"City Planning - Disabilities","request_type_name":"Americans with Disabilities","request_type_id":"353","create_date_et":"2023-03-06T08:04:00","create_date_utc":"2023-03-06T13:04:00","last_action_et":"2023-03-06T08:04:00","last_action_utc":"2023-03-06T13:04:00","closed_date_et":null,"closed_date_utc":null,"origin":"Website","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":14,"group_id":"727841","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"DPW - Administration","request_type_name":"Park Shelter","request_type_id":"543","create_date_et":"2023-04-14T11:15:00","create_date_utc":"2023-04-14T15:15:00","last_action_et":"2023-04-14T11:15:00","last_action_utc":"2023-04-14T15:15:00","closed_date_et":null,"closed_date_utc":null,"origin":"Call Center","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":15,"group_id":"689647","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"DPW - Construction Division","request_type_name":"Bike Lane Bollard","request_type_id":"542","create_date_et":"2022-10-28T17:47:00","create_date_utc":"2022-10-28T21:47:00","last_action_et":"2022-10-31T09:30:00","last_action_utc":"2022-10-31T13:30:00","closed_date_et":null,"closed_date_utc":null,"origin":"Call Center","street":null,"cross_street":null,"street_id":"0","cross_street_id":"0","city":"Pittsburgh","neighborhood":"","census_tract":"","council_district":"","ward":"","police_zone":"","latitude":0,"longitude":0,"geo_accuracy":"EXACT"},{"_id":16,"group_id":"801720","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"Finance","request_type_name":"Thank you - Finance","request_type_id":"14570","create_date_et":"2023-12-07T15:47:00","create_date_utc":"2023-12-07T20:47:00","last_action_et":"2023-12-07T15:47:00","last_action_utc":"2023-12-07T20:47:00","closed_date_et":null,"closed_date_utc":null,"origin":"Call Center","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":17,"group_id":"792321","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"311","request_type_name":"Thank You - 311","request_type_id":"554","create_date_et":"2023-11-01T10:32:00","create_date_utc":"2023-11-01T14:32:00","last_action_et":"2023-11-01T10:32:00","last_action_utc":"2023-11-01T14:32:00","closed_date_et":null,"closed_date_utc":null,"origin":"Call Center","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":18,"group_id":"653729","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"311","request_type_name":"Vacant Lot","request_type_id":"413","create_date_et":"2022-07-08T16:42:00","create_date_utc":"2022-07-08T20:42:00","last_action_et":"2022-07-08T16:42:00","last_action_utc":"2022-07-08T20:42:00","closed_date_et":null,"closed_date_utc":null,"origin":"Website","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":19,"group_id":"868766","num_requests":1,"parent_closed":false,"status_name":"in progress","status_code":3,"dept":"DPW - Refuse","request_type_name":"Missed Refuse Pick Up","request_type_id":"507","create_date_et":"2024-07-23T11:32:00","create_date_utc":"2024-07-23T15:32:00","last_action_et":"2024-07-24T09:20:00","last_action_utc":"2024-07-24T13:20:00","closed_date_et":null,"closed_date_utc":null,"origin":"Control Panel","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":20,"group_id":"751677","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"DPW - Administration","request_type_name":"Park Shelter","request_type_id":"543","create_date_et":"2023-06-26T11:17:00","create_date_utc":"2023-06-26T15:17:00","last_action_et":"2023-06-26T11:18:00","last_action_utc":"2023-06-26T15:18:00","closed_date_et":null,"closed_date_utc":null,"origin":"Call Center","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":21,"group_id":"874963","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"Police - Zones 1-6","request_type_name":"Illegal Parking","request_type_id":"417","create_date_et":"2024-08-09T17:35:00","create_date_utc":"2024-08-09T21:35:00","last_action_et":"2024-08-09T17:35:00","last_action_utc":"2024-08-09T21:35:00","closed_date_et":null,"closed_date_utc":null,"origin":"Website","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":22,"group_id":"635608","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"OMI","request_type_name":"Misconduct/City Employee","request_type_id":"442","create_date_et":"2022-05-20T15:20:00","create_date_utc":"2022-05-20T19:20:00","last_action_et":"2022-05-20T15:20:00","last_action_utc":"2022-05-20T19:20:00","closed_date_et":null,"closed_date_utc":null,"origin":"Website","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":23,"group_id":"662939","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"Finance","request_type_name":"Property Purchase","request_type_id":"14651","create_date_et":"2022-08-01T17:05:00","create_date_utc":"2022-08-01T21:05:00","last_action_et":"2022-08-01T17:05:00","last_action_utc":"2022-08-01T21:05:00","closed_date_et":null,"closed_date_utc":null,"origin":"Website","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":24,"group_id":"734010","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"DPW - Administration","request_type_name":"Park Shelter","request_type_id":"543","create_date_et":"2023-05-08T09:33:00","create_date_utc":"2023-05-08T13:33:00","last_action_et":"2023-05-08T09:33:00","last_action_utc":"2023-05-08T13:33:00","closed_date_et":null,"closed_date_utc":null,"origin":"Call Center","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":25,"group_id":"826684","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"DPW - Administration","request_type_name":"Park Shelter","request_type_id":"543","create_date_et":"2024-03-11T07:56:00","create_date_utc":"2024-03-11T11:56:00","last_action_et":"2024-03-11T07:56:00","last_action_utc":"2024-03-11T11:56:00","closed_date_et":null,"closed_date_utc":null,"origin":"Call Center","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":26,"group_id":"716595","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"DPW - Administration","request_type_name":"Park Shelter","request_type_id":"543","create_date_et":"2023-03-02T11:50:00","create_date_utc":"2023-03-02T16:50:00","last_action_et":"2023-03-02T11:50:00","last_action_utc":"2023-03-02T16:50:00","closed_date_et":null,"closed_date_utc":null,"origin":"Call Center","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":27,"group_id":"725301","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"Finance","request_type_name":"Real Estate Tax","request_type_id":"14568","create_date_et":"2023-04-04T17:39:00","create_date_utc":"2023-04-04T21:39:00","last_action_et":"2023-04-04T17:39:00","last_action_utc":"2023-04-04T21:39:00","closed_date_et":null,"closed_date_utc":null,"origin":"Website","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":28,"group_id":"724991","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"DPW - Administration","request_type_name":"Park Shelter","request_type_id":"543","create_date_et":"2023-04-04T07:52:00","create_date_utc":"2023-04-04T11:52:00","last_action_et":"2023-04-04T07:52:00","last_action_utc":"2023-04-04T11:52:00","closed_date_et":null,"closed_date_utc":null,"origin":"Call Center","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":29,"group_id":"831890","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"Police - Support Services","request_type_name":"Police Cameras","request_type_id":"468746","create_date_et":"2024-04-01T11:37:00","create_date_utc":"2024-04-01T15:37:00","last_action_et":"2024-04-01T11:37:00","last_action_utc":"2024-04-01T15:37:00","closed_date_et":null,"closed_date_utc":null,"origin":"Call Center","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":30,"group_id":"790140","num_requests":1,"parent_closed":false,"status_name":"in progress","status_code":3,"dept":"Permits, Licenses and Inspections","request_type_name":"Weeds/Debris","request_type_id":"410","create_date_et":"2023-10-24T10:53:00","create_date_utc":"2023-10-24T14:53:00","last_action_et":"2023-11-07T15:01:00","last_action_utc":"2023-11-07T20:01:00","closed_date_et":null,"closed_date_utc":null,"origin":"Call Center","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":31,"group_id":"803838","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"DPW - Refuse","request_type_name":"Missed Refuse Pick Up","request_type_id":"507","create_date_et":"2023-12-15T10:45:00","create_date_utc":"2023-12-15T15:45:00","last_action_et":"2023-12-15T10:45:00","last_action_utc":"2023-12-15T15:45:00","closed_date_et":null,"closed_date_utc":null,"origin":"Call Center","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":32,"group_id":"548718","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":null,"request_type_name":"SPIN (Stand Up) Scooters","request_type_id":"542084","create_date_et":"2021-07-29T12:33:00","create_date_utc":"2021-07-29T16:33:00","last_action_et":"2021-07-29T12:33:00","last_action_utc":"2021-07-29T16:33:00","closed_date_et":null,"closed_date_utc":null,"origin":"Call Center","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":33,"group_id":"708137","num_requests":1,"parent_closed":false,"status_name":"in progress","status_code":3,"dept":"DPW - Refuse","request_type_name":"Recycling Questions","request_type_id":"508","create_date_et":"2023-01-25T12:36:00","create_date_utc":"2023-01-25T17:36:00","last_action_et":"2023-06-09T14:40:00","last_action_utc":"2023-06-09T18:40:00","closed_date_et":null,"closed_date_utc":null,"origin":"Call Center","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":34,"group_id":"747169","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"DPW - Administration","request_type_name":"Park Shelter","request_type_id":"543","create_date_et":"2023-06-13T07:52:00","create_date_utc":"2023-06-13T11:52:00","last_action_et":"2023-06-13T07:52:00","last_action_utc":"2023-06-13T11:52:00","closed_date_et":null,"closed_date_utc":null,"origin":"Call Center","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":35,"group_id":"872006","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"DPW - Refuse","request_type_name":"Missed Refuse Pick Up","request_type_id":"507","create_date_et":"2024-08-01T10:10:00","create_date_utc":"2024-08-01T14:10:00","last_action_et":"2024-08-01T10:10:00","last_action_utc":"2024-08-01T14:10:00","closed_date_et":null,"closed_date_utc":null,"origin":"Call Center","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":36,"group_id":"873575","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"DPW - Administration","request_type_name":"Public Works Department","request_type_id":"285","create_date_et":"2024-08-06T14:14:00","create_date_utc":"2024-08-06T18:14:00","last_action_et":"2024-08-06T14:14:00","last_action_utc":"2024-08-06T18:14:00","closed_date_et":null,"closed_date_utc":null,"origin":"Email","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":37,"group_id":"648678","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"311","request_type_name":"Tenant/Landlord Problems","request_type_id":"305","create_date_et":"2022-06-23T21:59:00","create_date_utc":"2022-06-24T01:59:00","last_action_et":"2022-06-23T21:59:00","last_action_utc":"2022-06-24T01:59:00","closed_date_et":null,"closed_date_utc":null,"origin":"Website","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":38,"group_id":"633284","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"SPIN Scooters","request_type_name":"SPIN (Stand Up) Scooters","request_type_id":"542084","create_date_et":"2022-05-14T13:08:00","create_date_utc":"2022-05-14T17:08:00","last_action_et":"2022-05-14T13:08:00","last_action_utc":"2022-05-14T17:08:00","closed_date_et":null,"closed_date_utc":null,"origin":"Website","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":39,"group_id":"765859","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"City Planning - Disabilities","request_type_name":"Americans with Disabilities","request_type_id":"353","create_date_et":"2023-08-03T12:05:00","create_date_utc":"2023-08-03T16:05:00","last_action_et":"2023-08-03T12:05:00","last_action_utc":"2023-08-03T16:05:00","closed_date_et":null,"closed_date_utc":null,"origin":"Website","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":40,"group_id":"725275","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"311","request_type_name":"Police Department","request_type_id":"283","create_date_et":"2023-04-04T16:37:00","create_date_utc":"2023-04-04T20:37:00","last_action_et":"2023-04-04T16:37:00","last_action_utc":"2023-04-04T20:37:00","closed_date_et":null,"closed_date_utc":null,"origin":"Website","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":41,"group_id":"842079","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"311","request_type_name":"Police Department","request_type_id":"283","create_date_et":"2024-05-03T16:55:00","create_date_utc":"2024-05-03T20:55:00","last_action_et":"2024-05-03T16:55:00","last_action_utc":"2024-05-03T20:55:00","closed_date_et":null,"closed_date_utc":null,"origin":"Call Center","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":42,"group_id":"838851","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"DPW - Refuse","request_type_name":"Missed Refuse Pick Up","request_type_id":"507","create_date_et":"2024-04-23T09:05:00","create_date_utc":"2024-04-23T13:05:00","last_action_et":"2024-04-23T09:05:00","last_action_utc":"2024-04-23T13:05:00","closed_date_et":null,"closed_date_utc":null,"origin":"Call Center","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":43,"group_id":"582587","num_requests":1,"parent_closed":false,"status_name":"in progress","status_code":3,"dept":"311","request_type_name":"Police Department","request_type_id":"283","create_date_et":"2021-11-21T07:32:00","create_date_utc":"2021-11-21T12:32:00","last_action_et":"2021-11-22T07:41:00","last_action_utc":"2021-11-22T12:41:00","closed_date_et":null,"closed_date_utc":null,"origin":"Website","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":44,"group_id":"694659","num_requests":1,"parent_closed":false,"status_name":"in progress","status_code":3,"dept":"DPW - Refuse","request_type_name":"Missed Refuse Pick Up","request_type_id":"507","create_date_et":"2022-11-18T08:37:00","create_date_utc":"2022-11-18T13:37:00","last_action_et":"2022-11-21T08:30:00","last_action_utc":"2022-11-21T13:30:00","closed_date_et":null,"closed_date_utc":null,"origin":"Call Center","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":45,"group_id":"822423","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"Park Rangers","request_type_name":"Park Ranger","request_type_id":"225211","create_date_et":"2024-02-23T08:47:00","create_date_utc":"2024-02-23T13:47:00","last_action_et":"2024-02-23T08:47:00","last_action_utc":"2024-02-23T13:47:00","closed_date_et":null,"closed_date_utc":null,"origin":"Call Center","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":46,"group_id":"775969","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"Police - AVU","request_type_name":"Abandoned Vehicle (parked on street)","request_type_id":"415","create_date_et":"2023-09-04T13:32:00","create_date_utc":"2023-09-04T17:32:00","last_action_et":"2023-09-04T13:32:00","last_action_utc":"2023-09-04T17:32:00","closed_date_et":null,"closed_date_utc":null,"origin":"Website","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":47,"group_id":"745402","num_requests":1,"parent_closed":false,"status_name":"in progress","status_code":3,"dept":"Permits, Licenses and Inspections","request_type_name":"Weeds/Debris","request_type_id":"410","create_date_et":"2023-06-07T09:50:00","create_date_utc":"2023-06-07T13:50:00","last_action_et":"2023-06-28T16:02:00","last_action_utc":"2023-06-28T20:02:00","closed_date_et":null,"closed_date_utc":null,"origin":"Call Center","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":48,"group_id":"736808","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"DPW - Administration","request_type_name":"Park Shelter","request_type_id":"543","create_date_et":"2023-05-16T07:46:00","create_date_utc":"2023-05-16T11:46:00","last_action_et":"2023-05-16T07:46:00","last_action_utc":"2023-05-16T11:46:00","closed_date_et":null,"closed_date_utc":null,"origin":"Call Center","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":49,"group_id":"550188","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"City Planning","request_type_name":"Neighborhood Issues","request_type_id":"58345","create_date_et":"2021-08-03T16:08:00","create_date_utc":"2021-08-03T20:08:00","last_action_et":"2021-08-03T16:08:00","last_action_utc":"2021-08-03T20:08:00","closed_date_et":null,"closed_date_utc":null,"origin":"Call Center","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":50,"group_id":"569303","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":null,"request_type_name":"SPIN (Stand Up) Scooters","request_type_id":"542084","create_date_et":"2021-09-28T17:50:00","create_date_utc":"2021-09-28T21:50:00","last_action_et":"2021-09-28T17:50:00","last_action_utc":"2021-09-28T21:50:00","closed_date_et":null,"closed_date_utc":null,"origin":"Call Center","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":51,"group_id":"584927","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"DPW - Park Maintenance","request_type_name":"Playground","request_type_id":"432","create_date_et":"2021-12-04T08:42:00","create_date_utc":"2021-12-04T13:42:00","last_action_et":"2021-12-05T08:29:00","last_action_utc":"2021-12-05T13:29:00","closed_date_et":null,"closed_date_utc":null,"origin":"Website","street":null,"cross_street":null,"street_id":"0","cross_street_id":"0","city":"Pittsburgh","neighborhood":"","census_tract":"","council_district":"","ward":"","police_zone":"","latitude":0,"longitude":0,"geo_accuracy":"EXACT"},{"_id":52,"group_id":"685781","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"Finance","request_type_name":"Real Estate Tax","request_type_id":"14568","create_date_et":"2022-10-13T16:00:00","create_date_utc":"2022-10-13T20:00:00","last_action_et":"2024-04-03T13:47:00","last_action_utc":"2024-04-03T17:47:00","closed_date_et":null,"closed_date_utc":null,"origin":"Website","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":53,"group_id":"818335","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"PCSC","request_type_name":"Thank You","request_type_id":"12074","create_date_et":"2024-02-07T13:59:00","create_date_utc":"2024-02-07T18:59:00","last_action_et":"2024-02-07T13:59:00","last_action_utc":"2024-02-07T18:59:00","closed_date_et":null,"closed_date_utc":null,"origin":"Call Center","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":54,"group_id":"861916","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"Finance","request_type_name":"City Owned Property Maintenance","request_type_id":"29136","create_date_et":"2024-07-02T10:27:00","create_date_utc":"2024-07-02T14:27:00","last_action_et":"2024-07-02T10:27:00","last_action_utc":"2024-07-02T14:27:00","closed_date_et":null,"closed_date_utc":null,"origin":"Call Center","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":55,"group_id":"753031","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"DPW - Administration","request_type_name":"Park Shelter","request_type_id":"543","create_date_et":"2023-06-29T13:37:00","create_date_utc":"2023-06-29T17:37:00","last_action_et":"2023-06-29T13:37:00","last_action_utc":"2023-06-29T17:37:00","closed_date_et":null,"closed_date_utc":null,"origin":"Call Center","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":56,"group_id":"633969","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"DPW - Refuse","request_type_name":"Early Set Out","request_type_id":"504","create_date_et":"2022-05-16T23:54:00","create_date_utc":"2022-05-17T03:54:00","last_action_et":"2022-05-16T23:54:00","last_action_utc":"2022-05-17T03:54:00","closed_date_et":null,"closed_date_utc":null,"origin":"Website","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":57,"group_id":"829078","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"DPW - Administration","request_type_name":"Park Shelter","request_type_id":"543","create_date_et":"2024-03-19T12:53:00","create_date_utc":"2024-03-19T16:53:00","last_action_et":"2024-03-19T12:53:00","last_action_utc":"2024-03-19T16:53:00","closed_date_et":null,"closed_date_utc":null,"origin":"Call Center","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":58,"group_id":"443443","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"DOMI - Streets","request_type_name":"ADA Ramp, Installation","request_type_id":"817","create_date_et":"2020-06-20T16:33:00","create_date_utc":"2020-06-20T20:33:00","last_action_et":"2021-03-02T13:30:00","last_action_utc":"2021-03-02T18:30:00","closed_date_et":null,"closed_date_utc":null,"origin":"Website","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":59,"group_id":"444019","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"DOMI - Traffic","request_type_name":"Crosswalk, New","request_type_id":"464","create_date_et":"2020-06-23T04:11:00","create_date_utc":"2020-06-23T08:11:00","last_action_et":"2020-06-23T04:11:00","last_action_utc":"2020-06-23T08:11:00","closed_date_et":null,"closed_date_utc":null,"origin":"Website","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":60,"group_id":"718053","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"Pittsburgh Water and Sewer Authority","request_type_name":"PWSA Billing or Shut Off","request_type_id":"522","create_date_et":"2023-03-08T12:30:00","create_date_utc":"2023-03-08T17:30:00","last_action_et":"2023-03-08T12:30:00","last_action_utc":"2023-03-08T17:30:00","closed_date_et":null,"closed_date_utc":null,"origin":"Call Center","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":61,"group_id":"832041","num_requests":1,"parent_closed":true,"status_name":"closed","status_code":1,"dept":"Public Safety","request_type_name":"Homeless","request_type_id":"450","create_date_et":"2024-04-01T15:09:00","create_date_utc":"2024-04-01T19:09:00","last_action_et":"2025-01-06T10:36:00","last_action_utc":"2025-01-06T15:36:00","closed_date_et":"2025-01-06T10:36:00","closed_date_utc":"2025-01-06T15:36:00","origin":"Call Center","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":62,"group_id":"858659","num_requests":1,"parent_closed":true,"status_name":"closed","status_code":1,"dept":"Public Safety","request_type_name":"Homeless","request_type_id":"450","create_date_et":"2024-06-22T20:06:00","create_date_utc":"2024-06-23T00:06:00","last_action_et":"2025-01-06T10:38:00","last_action_utc":"2025-01-06T15:38:00","closed_date_et":"2025-01-06T10:38:00","closed_date_utc":"2025-01-06T15:38:00","origin":"Website","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":63,"group_id":"570682","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":null,"request_type_name":"SPIN (Stand Up) Scooters","request_type_id":"542084","create_date_et":"2021-10-04T10:44:00","create_date_utc":"2021-10-04T14:44:00","last_action_et":"2021-10-04T10:44:00","last_action_utc":"2021-10-04T14:44:00","closed_date_et":null,"closed_date_utc":null,"origin":"Text Message","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":64,"group_id":"883419","num_requests":1,"parent_closed":true,"status_name":"closed","status_code":1,"dept":"Public Safety","request_type_name":"Homeless","request_type_id":"450","create_date_et":"2024-09-06T13:29:00","create_date_utc":"2024-09-06T17:29:00","last_action_et":"2024-12-13T11:33:00","last_action_utc":"2024-12-13T16:33:00","closed_date_et":"2024-12-13T11:33:00","closed_date_utc":"2024-12-13T16:33:00","origin":"Website","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":65,"group_id":"755693","num_requests":1,"parent_closed":false,"status_name":"in progress","status_code":3,"dept":"DPW - Street Maintenance","request_type_name":"Litter, Public Property","request_type_id":"831","create_date_et":"2023-07-08T11:38:00","create_date_utc":"2023-07-08T15:38:00","last_action_et":"2023-07-10T11:31:00","last_action_utc":"2023-07-10T15:31:00","closed_date_et":null,"closed_date_utc":null,"origin":"Website","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":66,"group_id":"174459","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"City Planning","request_type_name":"Neighborhood Issues","request_type_id":"58345","create_date_et":"2017-07-28T15:19:00","create_date_utc":"2017-07-28T19:19:00","last_action_et":"2017-07-28T15:23:00","last_action_utc":"2017-07-28T19:23:00","closed_date_et":null,"closed_date_utc":null,"origin":"Call Center","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":67,"group_id":"810991","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"DPW - Administration","request_type_name":"Park Shelter","request_type_id":"543","create_date_et":"2024-01-17T09:14:00","create_date_utc":"2024-01-17T14:14:00","last_action_et":"2024-01-17T09:14:00","last_action_utc":"2024-01-17T14:14:00","closed_date_et":null,"closed_date_utc":null,"origin":"Call Center","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":68,"group_id":"864861","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"DPW - Refuse","request_type_name":"Missed Refuse Pick Up","request_type_id":"507","create_date_et":"2024-07-11T16:33:00","create_date_utc":"2024-07-11T20:33:00","last_action_et":"2024-07-11T16:33:00","last_action_utc":"2024-07-11T20:33:00","closed_date_et":null,"closed_date_utc":null,"origin":"Website","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":69,"group_id":"778336","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"DPW - Refuse","request_type_name":"Missed Refuse Pick Up","request_type_id":"507","create_date_et":"2023-09-11T18:39:00","create_date_utc":"2023-09-11T22:39:00","last_action_et":"2023-09-11T18:39:00","last_action_utc":"2023-09-11T22:39:00","closed_date_et":null,"closed_date_utc":null,"origin":"Website","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":70,"group_id":"783095","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"DPW - Refuse","request_type_name":"Bulk Pick Up","request_type_id":"502","create_date_et":"2023-09-28T10:13:00","create_date_utc":"2023-09-28T14:13:00","last_action_et":"2023-09-28T10:13:00","last_action_utc":"2023-09-28T14:13:00","closed_date_et":null,"closed_date_utc":null,"origin":"Website","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":71,"group_id":"778607","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"DPW - Administration","request_type_name":"Park Shelter","request_type_id":"543","create_date_et":"2023-09-12T13:16:00","create_date_utc":"2023-09-12T17:16:00","last_action_et":"2023-09-12T13:16:00","last_action_utc":"2023-09-12T17:16:00","closed_date_et":null,"closed_date_utc":null,"origin":"Call Center","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":72,"group_id":"747165","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"DPW - Administration","request_type_name":"Park Shelter","request_type_id":"543","create_date_et":"2023-06-13T07:44:00","create_date_utc":"2023-06-13T11:44:00","last_action_et":"2023-06-13T07:44:00","last_action_utc":"2023-06-13T11:44:00","closed_date_et":null,"closed_date_utc":null,"origin":"Call Center","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":73,"group_id":"744977","num_requests":1,"parent_closed":true,"status_name":"closed","status_code":1,"dept":"DPW - Refuse","request_type_name":"Blue Bin Containers","request_type_id":"475156","create_date_et":"2023-06-06T11:17:00","create_date_utc":"2023-06-06T15:17:00","last_action_et":"2024-11-22T13:06:00","last_action_utc":"2024-11-22T18:06:00","closed_date_et":"2024-11-22T13:06:00","closed_date_utc":"2024-11-22T18:06:00","origin":"Call Center","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":74,"group_id":"876937","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"311","request_type_name":"Thank You - 311","request_type_id":"554","create_date_et":"2024-08-16T10:30:00","create_date_utc":"2024-08-16T14:30:00","last_action_et":"2024-08-16T10:30:00","last_action_utc":"2024-08-16T14:30:00","closed_date_et":null,"closed_date_utc":null,"origin":"Call Center","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":75,"group_id":"551510","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":null,"request_type_name":"SPIN (Stand Up) Scooters","request_type_id":"542084","create_date_et":"2021-08-07T17:47:00","create_date_utc":"2021-08-07T21:47:00","last_action_et":"2021-08-10T14:15:00","last_action_utc":"2021-08-10T18:15:00","closed_date_et":null,"closed_date_utc":null,"origin":"Website","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":76,"group_id":"726872","num_requests":1,"parent_closed":false,"status_name":"on hold","status_code":4,"dept":"DPW - Park Maintenance","request_type_name":"Illegal Dumping","request_type_id":"828","create_date_et":"2023-04-11T14:58:00","create_date_utc":"2023-04-11T18:58:00","last_action_et":"2023-04-11T15:48:00","last_action_utc":"2023-04-11T19:48:00","closed_date_et":null,"closed_date_utc":null,"origin":"Website","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":77,"group_id":"848322","num_requests":1,"parent_closed":true,"status_name":"closed","status_code":1,"dept":"Public Safety","request_type_name":"Homeless","request_type_id":"450","create_date_et":"2024-05-22T13:59:00","create_date_utc":"2024-05-22T17:59:00","last_action_et":"2025-01-06T10:37:00","last_action_utc":"2025-01-06T15:37:00","closed_date_et":"2025-01-06T10:37:00","closed_date_utc":"2025-01-06T15:37:00","origin":"Website","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":78,"group_id":"832445","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"311","request_type_name":"City Cuts Application Request","request_type_id":"255449","create_date_et":"2024-04-02T14:43:00","create_date_utc":"2024-04-02T18:43:00","last_action_et":"2024-04-02T14:43:00","last_action_utc":"2024-04-02T18:43:00","closed_date_et":null,"closed_date_utc":null,"origin":"Call Center","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":79,"group_id":"856648","num_requests":1,"parent_closed":false,"status_name":"in progress","status_code":3,"dept":"Permits, Licenses and Inspections","request_type_name":"Vacant Building","request_type_id":"27522","create_date_et":"2024-06-16T14:48:00","create_date_utc":"2024-06-16T18:48:00","last_action_et":"2024-08-13T13:05:00","last_action_utc":"2024-08-13T17:05:00","closed_date_et":null,"closed_date_utc":null,"origin":"Website","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":80,"group_id":"886445","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"DPW - Facilities","request_type_name":"City Facility","request_type_id":"375","create_date_et":"2024-09-17T14:01:00","create_date_utc":"2024-09-17T18:01:00","last_action_et":"2024-09-17T14:01:00","last_action_utc":"2024-09-17T18:01:00","closed_date_et":null,"closed_date_utc":null,"origin":"Website","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":81,"group_id":"756758","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"DPW - Administration","request_type_name":"Park Shelter","request_type_id":"543","create_date_et":"2023-07-11T13:13:00","create_date_utc":"2023-07-11T17:13:00","last_action_et":"2023-07-11T13:13:00","last_action_utc":"2023-07-11T17:13:00","closed_date_et":null,"closed_date_utc":null,"origin":"Call Center","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":82,"group_id":"698938","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"311","request_type_name":"City Council","request_type_id":"277","create_date_et":"2022-12-12T17:08:00","create_date_utc":"2022-12-12T22:08:00","last_action_et":"2022-12-12T17:08:00","last_action_utc":"2022-12-12T22:08:00","closed_date_et":null,"closed_date_utc":null,"origin":"Call Center","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":83,"group_id":"865190","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"Finance","request_type_name":"Real Estate Tax","request_type_id":"14568","create_date_et":"2024-07-12T12:47:00","create_date_utc":"2024-07-12T16:47:00","last_action_et":"2024-07-12T12:47:00","last_action_utc":"2024-07-12T16:47:00","closed_date_et":null,"closed_date_utc":null,"origin":"Call Center","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":84,"group_id":"871771","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"311","request_type_name":"Mayor's Office","request_type_id":"281","create_date_et":"2024-07-31T14:12:00","create_date_utc":"2024-07-31T18:12:00","last_action_et":"2024-07-31T14:32:00","last_action_utc":"2024-07-31T18:32:00","closed_date_et":null,"closed_date_utc":null,"origin":"Email","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":85,"group_id":"866956","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"DPW - Refuse","request_type_name":"Missed Refuse Pick Up","request_type_id":"507","create_date_et":"2024-07-18T10:12:00","create_date_utc":"2024-07-18T14:12:00","last_action_et":"2024-07-18T10:12:00","last_action_utc":"2024-07-18T14:12:00","closed_date_et":null,"closed_date_utc":null,"origin":"Call Center","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":86,"group_id":"880597","num_requests":1,"parent_closed":true,"status_name":"closed","status_code":1,"dept":"DPW - Street Maintenance","request_type_name":"Trail Maintenance","request_type_id":"541","create_date_et":"2024-08-28T08:23:00","create_date_utc":"2024-08-28T12:23:00","last_action_et":"2024-12-26T12:45:00","last_action_utc":"2024-12-26T17:45:00","closed_date_et":"2024-12-26T12:45:00","closed_date_utc":"2024-12-26T17:45:00","origin":"Call Center","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":87,"group_id":"772881","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"311","request_type_name":"Thank You - 311","request_type_id":"554","create_date_et":"2023-08-24T13:23:00","create_date_utc":"2023-08-24T17:23:00","last_action_et":"2023-08-24T13:23:00","last_action_utc":"2023-08-24T17:23:00","closed_date_et":null,"closed_date_utc":null,"origin":"Call Center","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":88,"group_id":"827186","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"DPW - Administration","request_type_name":"Park Shelter","request_type_id":"543","create_date_et":"2024-03-12T08:13:00","create_date_utc":"2024-03-12T12:13:00","last_action_et":"2024-03-12T08:13:00","last_action_utc":"2024-03-12T12:13:00","closed_date_et":null,"closed_date_utc":null,"origin":"Call Center","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":89,"group_id":"470698","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"City Planning - Bicycles/Pedestrian traffic","request_type_name":"Bicycle Parking","request_type_id":"175753","create_date_et":"2020-10-02T12:42:00","create_date_utc":"2020-10-02T16:42:00","last_action_et":"2020-10-02T12:42:00","last_action_utc":"2020-10-02T16:42:00","closed_date_et":null,"closed_date_utc":null,"origin":"Call Center","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":90,"group_id":"506539","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"DOMI - Traffic","request_type_name":"Handicap Parking Signs, Removal","request_type_id":"551","create_date_et":"2021-03-09T17:00:00","create_date_utc":"2021-03-09T22:00:00","last_action_et":"2021-03-10T08:04:00","last_action_utc":"2021-03-10T13:04:00","closed_date_et":null,"closed_date_utc":null,"origin":"Call Center","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":91,"group_id":"857828","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"Office of Equal Protection","request_type_name":"Americans with Disabilities","request_type_id":"353","create_date_et":"2024-06-20T09:10:00","create_date_utc":"2024-06-20T13:10:00","last_action_et":"2024-06-20T09:10:00","last_action_utc":"2024-06-20T13:10:00","closed_date_et":null,"closed_date_utc":null,"origin":"Email","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":92,"group_id":"686663","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"Police - AVU","request_type_name":"Abandoned Vehicle (parked on street)","request_type_id":"415","create_date_et":"2022-10-17T16:21:00","create_date_utc":"2022-10-17T20:21:00","last_action_et":"2022-10-17T16:21:00","last_action_utc":"2022-10-17T20:21:00","closed_date_et":null,"closed_date_utc":null,"origin":"Website","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":93,"group_id":"806936","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"Pittsburgh Water and Sewer Authority","request_type_name":"Thank You - PWSA","request_type_id":"16054","create_date_et":"2023-12-30T20:33:00","create_date_utc":"2023-12-31T01:33:00","last_action_et":"2023-12-30T20:33:00","last_action_utc":"2023-12-31T01:33:00","closed_date_et":null,"closed_date_utc":null,"origin":"Website","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":94,"group_id":"804267","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"311","request_type_name":"Police Department","request_type_id":"283","create_date_et":"2023-12-18T11:58:00","create_date_utc":"2023-12-18T16:58:00","last_action_et":"2023-12-18T11:58:00","last_action_utc":"2023-12-18T16:58:00","closed_date_et":null,"closed_date_utc":null,"origin":"Website","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":95,"group_id":"795984","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"Police - AVU","request_type_name":"Abandoned Vehicle (parked on street)","request_type_id":"415","create_date_et":"2023-11-14T15:21:00","create_date_utc":"2023-11-14T20:21:00","last_action_et":"2023-11-14T15:21:00","last_action_utc":"2023-11-14T20:21:00","closed_date_et":null,"closed_date_utc":null,"origin":"Website","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":96,"group_id":"798556","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"DPW - Refuse","request_type_name":"Missed Refuse Pick Up","request_type_id":"507","create_date_et":"2023-11-27T11:13:00","create_date_utc":"2023-11-27T16:13:00","last_action_et":"2023-11-27T11:13:00","last_action_utc":"2023-11-27T16:13:00","closed_date_et":null,"closed_date_utc":null,"origin":"Website","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":97,"group_id":"626501","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"Police - Zones 1-6","request_type_name":"Excessive Noise/Disturbances","request_type_id":"297","create_date_et":"2022-04-24T09:56:00","create_date_utc":"2022-04-24T13:56:00","last_action_et":"2022-04-24T09:56:00","last_action_utc":"2022-04-24T13:56:00","closed_date_et":null,"closed_date_utc":null,"origin":"Website","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":"Central Business District","census_tract":"42003020100","council_district":"6","ward":"2","police_zone":"2","latitude":40.443452258954316,"longitude":-80.0041994400574,"geo_accuracy":"APPROXIMATE"},{"_id":98,"group_id":"818193","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"PCSC","request_type_name":"Thank You","request_type_id":"12074","create_date_et":"2024-02-07T08:29:00","create_date_utc":"2024-02-07T13:29:00","last_action_et":"2024-02-07T08:29:00","last_action_utc":"2024-02-07T13:29:00","closed_date_et":null,"closed_date_utc":null,"origin":"Call Center","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":99,"group_id":"815605","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"311","request_type_name":"Police Department","request_type_id":"283","create_date_et":"2024-01-29T15:12:00","create_date_utc":"2024-01-29T20:12:00","last_action_et":"2024-01-29T15:12:00","last_action_utc":"2024-01-29T20:12:00","closed_date_et":null,"closed_date_utc":null,"origin":"Call Center","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"},{"_id":100,"group_id":"732881","num_requests":1,"parent_closed":false,"status_name":"open","status_code":0,"dept":"Finance","request_type_name":"City Owned Property Maintenance","request_type_id":"29136","create_date_et":"2023-05-03T09:01:00","create_date_utc":"2023-05-03T13:01:00","last_action_et":"2023-05-03T09:01:00","last_action_utc":"2023-05-03T13:01:00","closed_date_et":null,"closed_date_utc":null,"origin":"Call Center","street":null,"cross_street":null,"street_id":null,"cross_street_id":null,"city":"Pittsburgh","neighborhood":null,"census_tract":null,"council_district":null,"ward":null,"police_zone":null,"latitude":null,"longitude":null,"geo_accuracy":"NULL_COORDINATES"}], "fields": [{"id": "_id", "type": "int"}, {"id": "group_id", "type": "text", "info": {"label": "Group ID", "notes": "The `group_id` field will be populated if there is only a single report of an issue or if there are multiple reports. The ID of the first ticket to arrive for a given issue is used as the `group_id`.", "type_override": ""}}, {"id": "num_requests", "type": "int4", "info": {"label": "Request count", "notes": "The total number of requests for a given issue (parent + child tickets).", "type_override": ""}}, {"id": "parent_closed", "type": "bool", "info": {"label": "Parent closed", "notes": "Families of tickets (children and parent tickets) should be closed simultaneously. In some edge cases, prior to August of 2021, this did not always occur. This dataset is maintained with the understanding that all ticket statuses should be updated on the parent ticket and cascade to the entire family of tickets.", "type_override": ""}}, {"id": "status_name", "type": "text", "info": {"label": "Status", "notes": "This field is useful for aggregating tickets for progress metrics such as the ticket closure rate.", "type_override": ""}}, {"id": "status_code", "type": "int4", "info": {"label": "Status code", "notes": "This field is interchangeable with status_name (0 = open; 1 = closed; 3 = in progress; 4 = on hold).", "type_override": ""}}, {"id": "dept", "type": "text", "info": {"label": "Department", "notes": "The department assigned to handle the ticket.", "type_override": ""}}, {"id": "request_type_name", "type": "text", "info": {"label": "Request type", "notes": "Category that the request falls under. This is interchangeable with `request_type_id`.", "type_override": ""}}, {"id": "request_type_id", "type": "text", "info": {"label": "Request type ID", "notes": "ID for the category that the request falls under. This is interchangeable with `request_type_name` (e.g., potholes = 484).", "type_override": ""}}, {"id": "create_date_et", "type": "timestamp", "info": {"label": "Create datetime (ET)", "notes": "See general notes section for more information.", "type_override": ""}}, {"id": "create_date_utc", "type": "timestamp", "info": {"label": "Create datetime (UTC)", "notes": "The UTC datetime that the issue/request was created for the parent ticket.", "type_override": ""}}, {"id": "last_action_et", "type": "timestamp", "info": {"label": "Last update (ET)", "notes": "Updates are always made on parent tickets. See description of `parent_closed` for more information.", "type_override": ""}}, {"id": "last_action_utc", "type": "timestamp", "info": {"label": "Last update (UTC)", "notes": "The UTC datetime that an action was last taken on the parent ticket.", "type_override": ""}}, {"id": "closed_date_et", "type": "timestamp", "info": {"label": "Closed datetime (ET)", "notes": "Closures are always made on parent tickets. See description of `parent_closed` for more information.", "type_override": ""}}, {"id": "closed_date_utc", "type": "timestamp", "info": {"label": "Closed datetime (UTC)", "notes": "The UTC datetime that the parent ticket was closed.", "type_override": ""}}, {"id": "origin", "type": "text", "info": {"label": "Request origin", "notes": "Method used to submit the 3-1-1 request (e.g., 'Call Center' for requests by phone and 'Email' for requests by e-mail).", "type_override": ""}}, {"id": "street", "type": "text", "info": {"label": "Street", "notes": "This is the street that the request location is on, as input by a 311 operator or the resident who submitted the request.\r\n", "type_override": ""}}, {"id": "cross_street", "type": "text", "info": {"label": "Cross-street", "notes": "Note that for some locations, it is irrelevant to list a cross street, and this field may be missing.", "type_override": ""}}, {"id": "street_id", "type": "text", "info": {"label": "Street ID", "notes": "Streets are assigned a string representation of a numeric code. Note that this value is set to 0 for instances where streets are not entered. This code may be useful for types of analyses in which street name is an unwieldy datapoint and a more concise representation is helpful.", "type_override": ""}}, {"id": "cross_street_id", "type": "text", "info": {"label": "Cross-street ID", "notes": "See `street_id` field description for further information.", "type_override": ""}}, {"id": "city", "type": "text", "info": {"label": "City", "notes": "The `city` field is extracted from the location that the user enters. (Requests/issues are occasionally submitted for locations outside of the city limits. The city of Pittsburgh cannot address these tickets.)\r\n", "type_override": ""}}, {"id": "neighborhood", "type": "text", "info": {"label": "Neighborhood", "notes": "The name of the neighborhood containing the latitude and longitude for the location in question.", "type_override": ""}}, {"id": "census_tract", "type": "text", "info": {"label": "Census tract", "notes": "The Census tract containing the latitude and longitude for the location in question.", "type_override": ""}}, {"id": "council_district", "type": "text", "info": {"label": "Council district", "notes": "The council district containing the latitude and longitude for the location in question. ", "type_override": ""}}, {"id": "ward", "type": "text", "info": {"label": "Ward", "notes": "The ward containing the latitude and longitude for the location in question. ", "type_override": ""}}, {"id": "police_zone", "type": "text", "info": {"label": "Police zone", "notes": "The police zone containing the latitude and longitude for the location in question. ", "type_override": ""}}, {"id": "latitude", "type": "float8", "info": {"label": "Latitude", "notes": "The latitude of the request's location, subject to possible obfuscation as described by the `geoaccuracy` field.", "type_override": ""}}, {"id": "longitude", "type": "float8", "info": {"label": "Longitude", "notes": "The longitude of the request's location, subject to possible obfuscation as described by the `geoaccuracy` field.", "type_override": ""}}, {"id": "geo_accuracy", "type": "text", "info": {"label": "Geoaccuracy", "notes": "This field describes the nature of the `latitude` and `longitude` values, indicating whether 1) they match those attached to the original request (EXACT), 2) they've been modified (APPROXIMATE) or removed entirely (REDACTED) to obscure the location for privacy reasons, 3) they are out of the 3-1-1 service area (OUT_OF_BOUNDS), or 4) they were missing from the original request or removed in cases where the location is not germane to the request (NULL_COORDINATES).", "type_override": ""}}], "_links": {"start": "/api/action/datastore_search?resource_id=29462525-62a6-45bf-9b5e-ad2e1c06348d", "next": "/api/action/datastore_search?resource_id=29462525-62a6-45bf-9b5e-ad2e1c06348d&offset=100"}, "total": 815417, "total_was_estimated": false}}