{"rows":[{"cartodb_id":3859,"the_geom":"0101000020E61000009AB58FF03ECB52C0F6F49B476CF84340","the_geom_webmercator":"0101000020110F0000B367039F62EC5FC1FEC671F77F875241","addressobjectid":"671168","address":"905-07 S 20TH ST","unit_type":null,"unit_num":null,"zip":"19146-2608","opa_account_num":"871400120","parcel_id_num":"106213","censustract":"19","opa_owner":"WHACK JEROME","primaryappellant":"HENRY  M. CLINTON, ESQUIRE","appellanttype":"OTHER","internaljobid":1221054,"appealnumber":"14829","acceleratedappeal":null,"createddate":"2011-03-25T18:48:00Z","completeddate":null,"relatedpermit":"Description of Project:  237838\n  APPEAL TYPES==> \nAPPEAL TYPE: AGAINSTL&I  \n\n  BOARD DECISIONS==> \nDECISION: LATE-APPRVD  DECDATE: 06-APR-11  PROVISO:   \nDECISION: CONTINUED  DECDATE: 18-MAY-11  PROVISO:   \nDECISION: CONTINUED  DECDATE: 28-JUL-11  PROVISO:   \nDECISION: AFFIRMED  DECDATE: 26-JAN-12  PROVISO: CITY AFFIRMED WINDOWS VIOLATIONS  \n\n  COURT APPEALS==> \n","relatedcasefile":null,"appealstatus":"OPEN","appealtype":null,"agendadescription":null,"applicationtype":"RB_LIRB","meetingnumber":null,"appealgrounds":"APPELLANT HAS LOCATED ZONING FILES WHICH INDICATE THE WINDOWS AND THE ADDITION CITED  IN THE VIOLATION HAVE BEEN IN EXISTENCE ON THE PROPERTY SINCE AT LEAST 1977. APPELLANT PURCHASED THE PROPERTY ON JUNE 8, 2004.","scheduleddate":"2012-01-24T18:15:00Z","decision":"AFFIRMED","meetingresult":null,"proviso":"CITY AFFIRMED WINDOWS VIOLATIONS","decisiondate":"2012-01-26T05:00:00Z","systemofrecord":"HANSEN","geocode_x":2690238.34072798,"geocode_y":231813.72116141,"council_district":null,"posse_jobid":null,"gdb_geomattr_data":null,"objectid":3800,"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}