{"rows":[{"cartodb_id":24722,"the_geom":"0101000020E61000006CF6C96905CA52C018EE45737EF64340","the_geom_webmercator":"0101000020110F000015199E104EEA5FC17E9522005D855241","addressobjectid":"537154","address":"611 SIGEL ST","unit_type":null,"unit_num":null,"zip":"19148-1723","opa_account_num":"012154300","parcel_id_num":"173384","censustract":"28.01","opa_owner":"SHOFRAN JOSH","primaryappellant":"JOHN SHOFRAN","appellanttype":"APPL","internaljobid":2614322,"appealnumber":"39115","acceleratedappeal":null,"createddate":"2019-11-05T19:54:25Z","completeddate":null,"relatedpermit":"Description of Project:  PWD\n  APPEAL TYPES==> \nAPPEAL TYPE: WATER  \n\n  BOARD DECISIONS==> \n\n  COURT APPEALS==> \n","relatedcasefile":null,"appealstatus":"OPEN","appealtype":null,"agendadescription":null,"applicationtype":"RB_LIRB","meetingnumber":null,"appealgrounds":"IT IS OUR BELIEF THAT THE CITED DAMAGE TO THE LATERAL LINES AT THE PROPERTIES THAT RECEIVED NODS ARE THE RESULT OF CONTINUED NEGLECT AND ESCALATING DISREPAIR TO THE CITY STREET, AND THEREFORE THE REPAIRS TO THE LATERAL LINES AND OTHER WATER/WASTE PLUMBING UNDER THE STREET SURFACE ARE THE SOLE RESPONSIBILITY OF THE CITY TO REPAIR.","scheduleddate":"2020-03-10T17:15:00Z","decision":"MOOT","meetingresult":null,"proviso":null,"decisiondate":"2020-03-10T04:00:00Z","systemofrecord":"HANSEN","geocode_x":2695763.0996811297,"geocode_y":226483.15958107,"council_district":null,"posse_jobid":null,"gdb_geomattr_data":null,"objectid":24573,"coordinatingrco":null}],"time":0.087,"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}