{"rows":[{"cartodb_id":7065,"the_geom":"0101000020E6100000DA3BB66FDCC952C0A814862CD3F94340","the_geom_webmercator":"0101000020110F0000C3832A7608EA5FC190A3C58D0D895241","addressobjectid":"729482","address":"801 MARKET ST","unit_type":null,"unit_num":"3","zip":"19107-3109","opa_account_num":"883013400","parcel_id_num":"259134","censustract":"5","opa_owner":"PHILADELPHIA OFFICE 2016","primaryappellant":"LANCONNECT, INC.","appellanttype":"APPL","internaljobid":1409564,"appealnumber":"18294","acceleratedappeal":null,"createddate":"2012-06-19T21:17:16Z","completeddate":null,"relatedpermit":"Description of Project:  329824\n  APPEAL TYPES==> \nAPPEAL TYPE: AGAINSTL&I  \n\n  BOARD DECISIONS==> \nDECISION: MOOT  DECDATE: 20-SEP-12  PROVISO: COMPLIED  \n\n  COURT APPEALS==> \n","relatedcasefile":null,"appealstatus":"OPEN","appealtype":null,"agendadescription":null,"applicationtype":"RB_LIRB","meetingnumber":null,"appealgrounds":"LANCONNECT APPLIED FOR AND PAID THE INITIAL PROCESSING FEE FOR PERMIT #399988 ON 4/18/12. WE RECEIVED A LETTER STATING THE PERMIT WAS APPROVED AND THAT WE NEEDED TO COME DOWN AND PAY THE REMAINDER OF THE BALANCE. SINCE WE THOUGHT WE HAD OBTAINED THE ROUGH IN PERMIT, WE STARTED ROUGHING IN THE CABLE FOR THIS PROJECT.","scheduleddate":"2012-09-18T17:15:00Z","decision":"MOOT","meetingresult":null,"proviso":"COMPLIED","decisiondate":"2012-09-20T04:00:00Z","systemofrecord":"HANSEN","geocode_x":2696185.6344077,"geocode_y":235979.40205825,"council_district":null,"posse_jobid":null,"gdb_geomattr_data":null,"objectid":6979,"coordinatingrco":null}],"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},"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}