{"rows":[{"cartodb_id":29465,"the_geom":"0101000020E6100000DDF3571DB4CA52C0722E62BBA4F64340","the_geom_webmercator":"0101000020110F0000045B13D076EB5FC1C174A56587855241","addressobjectid":"473266","address":"1830 E PASSYUNK AVE","unit_type":null,"unit_num":null,"zip":"19148-2128","opa_account_num":"871559390","parcel_id_num":"171370","censustract":"29","opa_owner":"RENZULLI DANIELLE","primaryappellant":"KRISTIN RENZULLI","appellanttype":"APPL","internaljobid":1000901,"appealnumber":"9705","acceleratedappeal":null,"createddate":"2009-08-04T11:52:00Z","completeddate":null,"relatedpermit":"Description of Project:  RADIO 145\n  APPEAL TYPES==> \nAPPEAL TYPE: WATER  \n\n  BOARD DECISIONS==> \nDECISION: WITHDRAWN  DECDATE: 04-NOV-09  PROVISO:   \n\n  COURT APPEALS==> \n","relatedcasefile":null,"appealstatus":"OPEN","appealtype":null,"agendadescription":null,"applicationtype":"RB_LIRB","meetingnumber":null,"appealgrounds":"I REPLACED THIS PIPE 10 YEARS AGO AND THE CITY REPLACED THE STREET AND PIPES 3 YEARS AGO, EVER SINCE THEN THE STREET HAS BEEN SINKING. THE WHOLE RIGHT SIDE OF THE STREET CORNER  IS CAVING IN AND THAT IS WHAT BROKE THE PIPE. MR CLARK NESLY FROM THE WATER DEPARTMENT SAID I WOULD BE REIMBURSED FOR THE WORK BUT I AM CURRENTLY UNEMPLOYED AND CANNOT AFFORD TO REPLACE THE PIPE","scheduleddate":"2009-11-03T18:15:00Z","decision":"WITHDRAWN","meetingresult":null,"proviso":null,"decisiondate":"2009-11-04T05:00:00Z","systemofrecord":"HANSEN","geocode_x":2692761.3442071197,"geocode_y":226820.92400052,"council_district":null,"posse_jobid":null,"gdb_geomattr_data":null,"objectid":29353,"coordinatingrco":null}],"time":1.478,"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},"addressobjectid":{"type":"string","pgtype":"varchar"},"address":{"type":"string","pgtype":"varchar"},"unit_type":{"type":"string","pgtype":"varchar"},"unit_num":{"type":"string","pgtype":"varchar"},"zip":{"type":"string","pgtype":"varchar"},"opa_account_num":{"type":"string","pgtype":"varchar"},"parcel_id_num":{"type":"string","pgtype":"varchar"},"censustract":{"type":"string","pgtype":"varchar"},"opa_owner":{"type":"string","pgtype":"varchar"},"primaryappellant":{"type":"string","pgtype":"varchar"},"appellanttype":{"type":"string","pgtype":"varchar"},"internaljobid":{"type":"number","pgtype":"numeric"},"appealnumber":{"type":"string","pgtype":"varchar"},"acceleratedappeal":{"type":"string","pgtype":"varchar"},"createddate":{"type":"date","pgtype":"timestamptz"},"completeddate":{"type":"date","pgtype":"timestamptz"},"relatedpermit":{"type":"string","pgtype":"varchar"},"relatedcasefile":{"type":"string","pgtype":"varchar"},"appealstatus":{"type":"string","pgtype":"varchar"},"appealtype":{"type":"string","pgtype":"varchar"},"agendadescription":{"type":"string","pgtype":"varchar"},"applicationtype":{"type":"string","pgtype":"varchar"},"meetingnumber":{"type":"string","pgtype":"varchar"},"appealgrounds":{"type":"string","pgtype":"varchar"},"scheduleddate":{"type":"date","pgtype":"timestamptz"},"decision":{"type":"string","pgtype":"varchar"},"meetingresult":{"type":"string","pgtype":"varchar"},"proviso":{"type":"string","pgtype":"varchar"},"decisiondate":{"type":"date","pgtype":"timestamptz"},"systemofrecord":{"type":"string","pgtype":"varchar"},"geocode_x":{"type":"number","pgtype":"numeric"},"geocode_y":{"type":"number","pgtype":"numeric"},"council_district":{"type":"string","pgtype":"varchar"},"posse_jobid":{"type":"string","pgtype":"varchar"},"gdb_geomattr_data":{"type":"bytea","pgtype":"bytea"},"objectid":{"type":"number","pgtype":"int4"},"coordinatingrco":{"type":"string","pgtype":"varchar"}},"total_rows":1}