{"rows":[{"cartodb_id":1,"the_geom":"0101000020E6100000CB30EE06D1CA52C0268DD13AAAFE4340","the_geom_webmercator":"0101000020110F0000226C6AECA7EB5FC13FAE1BAF6A8E5241","objectid":1,"service_request_id":10007982,"status":"Closed","status_notes":"Question Answered","service_name":"Information Request","service_code":"SR-IR01","agency_responsible":"Philly311 Contact Center","service_notice":"None","requested_datetime":"2016-01-10T20:02:54Z","updated_datetime":"2016-12-29T16:41:34Z","expected_datetime":null,"address":"2173–2215  W Dauphin St","zipcode":"19132","media_url":"https://d17aqltn7cihbm.cloudfront.net/uploads/large_9975fee3f510edda03551be0cd75a034","lat":39.98957,"lon":-75.169008,"subject":null,"closed_datetime":"2016-12-29T16:41:30Z","gdb_geomattr_data":null,"service_type":"Information Request"},{"cartodb_id":2,"the_geom":"0101000020E61000001C10217F32CE52C08332300EF1034440","the_geom_webmercator":"0101000020110F0000B461B50266F15FC1020C708B44945241","objectid":2,"service_request_id":10014183,"status":"Closed","status_notes":null,"service_name":"Maintenance Residential or Commercial","service_code":"SR-LI21","agency_responsible":"License & Inspections","service_notice":null,"requested_datetime":"2016-01-10T20:11:34Z","updated_datetime":"2024-05-10T18:34:47Z","expected_datetime":"2016-02-10T00:00:00Z","address":"303 GREEN LN","zipcode":"19128","media_url":"https://d17aqltn7cihbm.cloudfront.net/uploads/large_1d8497bb1933d48fa9331fe7ddcc5fcb","lat":40.03079393,"lon":-75.22183207,"subject":null,"closed_datetime":"2016-01-23T02:00:48Z","gdb_geomattr_data":null,"service_type":"Maintenance Residential"},{"cartodb_id":3,"the_geom":"0101000020E6100000350D76DF05CB52C06B2B69B7E4F84340","the_geom_webmercator":"0101000020110F00009F89FCAF01EC5FC158F0756105885241","objectid":3,"service_request_id":10030187,"status":"Closed","status_notes":"Repair Completed","service_name":"Graffiti Removal","service_code":"SR-CL01","agency_responsible":"Community Life Improvement Program","service_notice":"7 Business Days","requested_datetime":"2016-01-10T20:35:42Z","updated_datetime":"2024-05-11T00:40:17Z","expected_datetime":"2016-01-20T00:00:00Z","address":"1800 SOUTH ST","zipcode":"19146","media_url":"https://d17aqltn7cihbm.cloudfront.net/uploads/large_b29c149c8dc0d9aac1cf2ac7771e3053","lat":39.94447987,"lon":-75.17223345,"subject":null,"closed_datetime":"2016-01-13T20:24:16Z","gdb_geomattr_data":null,"service_type":"Graffiti Removal"},{"cartodb_id":4,"the_geom":"0101000020E61000000D4B1B64F7CA52C032BE3DDF51F94340","the_geom_webmercator":"0101000020110F0000B2F7AB16E9EB5FC11155E74D7E885241","objectid":4,"service_request_id":10034988,"status":"Closed","status_notes":"Repair Completed","service_name":"Graffiti Removal","service_code":"SR-CL01","agency_responsible":"Community Life Improvement Program","service_notice":"7 Business Days","requested_datetime":"2016-01-10T20:42:27Z","updated_datetime":"2024-05-11T01:05:36Z","expected_datetime":"2016-01-20T00:00:00Z","address":"1801 SPRUCE ST","zipcode":"19103","media_url":"https://d17aqltn7cihbm.cloudfront.net/uploads/large_fe4377aa230ce6c5e20eedfdac2bae77","lat":39.94781104,"lon":-75.17134955,"subject":null,"closed_datetime":"2016-01-13T19:48:03Z","gdb_geomattr_data":null,"service_type":"Graffiti Removal"},{"cartodb_id":5,"the_geom":null,"the_geom_webmercator":null,"objectid":5,"service_request_id":10036132,"status":"Closed","status_notes":null,"service_name":"Vacant House or Commercial","service_code":"SR-LI27","agency_responsible":"License & Inspections","service_notice":null,"requested_datetime":"2014-01-02T09:15:16Z","updated_datetime":"2024-05-10T18:52:00Z","expected_datetime":"2014-02-03T00:00:00Z","address":"02409 N CLEVELAND ST","zipcode":"19132","media_url":null,"lat":null,"lon":null,"subject":null,"closed_datetime":"2014-01-02T09:17:38Z","gdb_geomattr_data":null,"service_type":"Vacant House"}],"time":0.002,"fields":{"cartodb_id":{"type":"number","pgtype":"int8"},"the_geom":{"type":"geometry","wkbtype":"Unknown","dims":2,"srid":4326},"the_geom_webmercator":{"type":"geometry","wkbtype":"Unknown","dims":2,"srid":3857},"objectid":{"type":"number","pgtype":"int4"},"service_request_id":{"type":"number","pgtype":"int4"},"status":{"type":"string","pgtype":"varchar"},"status_notes":{"type":"string","pgtype":"varchar"},"service_name":{"type":"string","pgtype":"varchar"},"service_code":{"type":"string","pgtype":"varchar"},"agency_responsible":{"type":"string","pgtype":"varchar"},"service_notice":{"type":"string","pgtype":"varchar"},"requested_datetime":{"type":"date","pgtype":"timestamptz"},"updated_datetime":{"type":"date","pgtype":"timestamptz"},"expected_datetime":{"type":"date","pgtype":"timestamptz"},"address":{"type":"string","pgtype":"varchar"},"zipcode":{"type":"string","pgtype":"varchar"},"media_url":{"type":"string","pgtype":"varchar"},"lat":{"type":"number","pgtype":"numeric"},"lon":{"type":"number","pgtype":"numeric"},"subject":{"type":"string","pgtype":"varchar"},"closed_datetime":{"type":"date","pgtype":"timestamptz"},"gdb_geomattr_data":{"type":"bytea","pgtype":"bytea"},"service_type":{"type":"string","pgtype":"varchar"}},"total_rows":5}