{"rows":[{"cartodb_id":18799,"the_geom":"0101000020E61000005E141F1652CA52C047571F7084F94340","the_geom_webmercator":"0101000020110F0000CAC2504DD0EA5FC1C2C2E052B6885241","addressobjectid":"593891","address":"1213-19 WALNUT ST","unit_type":null,"unit_num":null,"zip":"19107-0000","opa_account_num":"881011115","parcel_id_num":"63981","censustract":"6","opa_owner":"HG ASB PROPERTY LLC","primaryappellant":"SUZAN D. PAIVA, ESQ","appellanttype":"OTHER","internaljobid":2273287,"appealnumber":"31964","acceleratedappeal":null,"createddate":"2017-10-11T15:47:17Z","completeddate":null,"relatedpermit":"Description of Project:  602940\n  APPEAL TYPES==> \nAPPEAL TYPE: HOUSING  \n\n  BOARD DECISIONS==> \nDECISION: CONTINUED  DECDATE: 09-JAN-18  PROVISO:   \nDECISION: MOOT  DECDATE: 13-MAR-18  PROVISO: VIOLATION WITHDRAWN BY CITY  \n\n  COURT APPEALS==> \n","relatedcasefile":null,"appealstatus":"OPEN","appealtype":null,"agendadescription":null,"applicationtype":"RB_LIRB","meetingnumber":null,"appealgrounds":"NO PERMIT IS REQUIRED BECAUSE VERIZON FALLS UNDER THE EXEMPTION FOR \"PUBLIC UTILITIES, COMMON CARRIERS OR COMMERCIAL RADIO OR TELEVISION STATIONS THAT ARE UNDER THE JURISDICTION OF THE COMMONWEALTH OF PA OR A FEDERAL REGULATORY BODY.\"","scheduleddate":"2018-03-06T18:15:00Z","decision":"MOOT","meetingresult":null,"proviso":"VIOLATION WITHDRAWN BY CITY","decisiondate":"2018-03-13T04:00:00Z","systemofrecord":"HANSEN","geocode_x":2694198.95596013,"geocode_y":235045.38213253,"council_district":null,"posse_jobid":null,"gdb_geomattr_data":null,"objectid":18631,"coordinatingrco":null}],"time":1.501,"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}