{"rows":[{"cartodb_id":7948,"the_geom":"0101000020E6100000E0555A7969CA52C0C7AFF52800FF4340","the_geom_webmercator":"0101000020110F00001A093B07F8EA5FC10E23D0F0C98E5241","addressobjectid":"321927","address":"2514 N GRATZ ST","unit_type":null,"unit_num":null,"zip":"19132-3806","opa_account_num":"162066700","parcel_id_num":"293833","censustract":"167.01","opa_owner":"VILLANUEVA MELIDA","primaryappellant":"ALAN GREENBERG","appellanttype":"APPL","internaljobid":1471066,"appealnumber":"19280","acceleratedappeal":null,"createddate":"2012-11-08T20:01:00Z","completeddate":null,"relatedpermit":"Description of Project:  355863\n  APPEAL TYPES==> \nAPPEAL TYPE: HOUSING  \n\n  BOARD DECISIONS==> \nDECISION: AFFIRMED  DECDATE: 06-FEB-13  PROVISO: FOR WANT OF APPEARANCE  \n\n  COURT APPEALS==> \n","relatedcasefile":null,"appealstatus":"OPEN","appealtype":null,"agendadescription":null,"applicationtype":"RB_LIRB","meetingnumber":null,"appealgrounds":"OWNER HAS BEEN DENIED ACCESS TO THE PREMISES. TENANT REFUSES TO MAKE COPIES OF KEYS TO ALLOW ACCESS. TENANT STATES THAT DUE TO HER WORK SCHEDULE, ANY AND ALL REPAIRS CAN ONLY BE PERFORMED ON A SUNDAY.","scheduleddate":"2013-02-05T18:15:00Z","decision":"AFFIRMED","meetingresult":null,"proviso":"FOR WANT OF APPEARANCE","decisiondate":"2013-02-06T05:00:00Z","systemofrecord":"HANSEN","geocode_x":2693341.7801334495,"geocode_y":250632.1521295699,"council_district":null,"posse_jobid":null,"gdb_geomattr_data":null,"objectid":7855,"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}