{"rows":[{"cartodb_id":30308,"the_geom":"0101000020E610000003288AF5F8C852C0804A3DF5ABFC4340","the_geom_webmercator":"0101000020110F00002A8A901186E85FC1D397F41A358C5241","addressobjectid":"129321819","address":"1500-06 N AMERICAN ST","unit_type":null,"unit_num":null,"zip":"19122-3811","opa_account_num":null,"parcel_id_num":"114590","censustract":"014400","opa_owner":null,"primaryappellant":"MICAH GOLD-MARKEL","appellanttype":"Owner","internaljobid":null,"appealnumber":"HA-2021-000715","acceleratedappeal":"Standard Appeal","createddate":"2021-02-12T14:25:34Z","completeddate":"2022-03-05T17:07:36Z","relatedpermit":null,"relatedcasefile":null,"appealstatus":"Closed","appealtype":"LIRB-C Other L&I","agendadescription":null,"applicationtype":"L&I Review Board Codes","meetingnumber":"MI-2021-000754","appealgrounds":"The lateral in Question is less than 2 yrs old and was inspected by the City of Philadelphia. We are located right on the corner of Jefferson and American St. The City has torn up the street and done underground work numerous times since lateral installation. I believe the City should have to pay for the repair as it is reasonable to conclude the city caused the problem.","scheduleddate":"2021-08-31T17:15:00Z","decision":"City Affirmed","meetingresult":"Complete","proviso":null,"decisiondate":"2022-03-05T17:06:17Z","systemofrecord":"ECLIPSE","geocode_x":2699837.08743765,"geocode_y":244192.47422917,"council_district":"7","posse_jobid":"316608189","gdb_geomattr_data":null,"objectid":30159,"coordinatingrco":null}],"time":0.003,"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}