{"rows":[{"cartodb_id":879851,"the_geom":"0101000020E6100000418ED25CBECA52C043CEAA66B5F74340","the_geom_webmercator":"0101000020110F00004F8C513888EB5FC149D65965B5865241","permitnumber":"ZP-2021-003979","addressobjectid":"129563409","parcel_id_num":"82054","permittype":"Zoning","permitdescription":"Zoning Permit","commercialorresidential":"Commercial","typeofwork":"New construction, addition, GFA change","approvedscopeofwork":"For partial demolition (of portion of second story along south side of building), and for the erection of an addition (of new third and fourth stories, with roof decks above existing single-story portion along south side of building, and above fourth story roof (accessed from pilot houses enclosing access stairs only), with balconies along south side of new third story, and mechanical/elevator penthouses), to an existing attached structure, size and location as shown on plan/application; no change to footprint of existing building.","permitissuedate":null,"status":"Refused","applicanttype":"Professional / Tradesperson","contractorname":"Landmark Architectural Design LLC ","contractoraddress1":"Landmark Architectural Design LLC \n1303 S BROAD STREET\nPHILADELPHIA, PA  19147\nUSA","contractoraddress2":null,"contractorcity":null,"contractorstate":null,"contractorzip":null,"mostrecentinsp":null,"opa_account_num":"773058995","address":"1212-14 S BROAD ST","unit_type":null,"unit_num":null,"zip":"19146-3119","censustract":"002200","council_district":"2","opa_owner":"DIGIRONIMO JOSEPH","systemofrecord":"ECLIPSE","geocode_x":2692497.37582786,"geocode_y":229845.76183825,"posse_jobid":"339046040","gdb_geomattr_data":null,"objectid":879808,"usecategories":"Residential - Household Living - Multi-Family","occupancytype":null,"permitcompleteddate":"2021-11-09T14:33:02Z","numberofunits":null,"certificateofoccupancydate":null,"certificateofoccupancyrequired":null,"parentjobid":null,"certificateofoccupancylink":null,"zoningpermitjobid":null,"numberofstories":null,"denialdocumentlink":"https://eclipse.phila.gov/phillylmsprod/pub/ws/DocumentDownload/download?documentId=358393157&hash=B3315F1EB8E84411E7A406B3ECEC53375FED451AF023F3A7629C8C78EB14186E","areaofdisturbance":0,"denialdate":"2021-06-09T20:39:38Z"}],"time":0.167,"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},"permitnumber":{"type":"string","pgtype":"varchar"},"addressobjectid":{"type":"string","pgtype":"varchar"},"parcel_id_num":{"type":"string","pgtype":"varchar"},"permittype":{"type":"string","pgtype":"varchar"},"permitdescription":{"type":"string","pgtype":"varchar"},"commercialorresidential":{"type":"string","pgtype":"varchar"},"typeofwork":{"type":"string","pgtype":"varchar"},"approvedscopeofwork":{"type":"string","pgtype":"varchar"},"permitissuedate":{"type":"date","pgtype":"timestamptz"},"status":{"type":"string","pgtype":"varchar"},"applicanttype":{"type":"string","pgtype":"varchar"},"contractorname":{"type":"string","pgtype":"varchar"},"contractoraddress1":{"type":"string","pgtype":"varchar"},"contractoraddress2":{"type":"string","pgtype":"varchar"},"contractorcity":{"type":"string","pgtype":"varchar"},"contractorstate":{"type":"string","pgtype":"varchar"},"contractorzip":{"type":"string","pgtype":"varchar"},"mostrecentinsp":{"type":"date","pgtype":"timestamptz"},"opa_account_num":{"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"},"censustract":{"type":"string","pgtype":"varchar"},"council_district":{"type":"string","pgtype":"varchar"},"opa_owner":{"type":"string","pgtype":"varchar"},"systemofrecord":{"type":"string","pgtype":"varchar"},"geocode_x":{"type":"number","pgtype":"numeric"},"geocode_y":{"type":"number","pgtype":"numeric"},"posse_jobid":{"type":"string","pgtype":"varchar"},"gdb_geomattr_data":{"type":"bytea","pgtype":"bytea"},"objectid":{"type":"number","pgtype":"int4"},"usecategories":{"type":"string","pgtype":"varchar"},"occupancytype":{"type":"string","pgtype":"varchar"},"permitcompleteddate":{"type":"date","pgtype":"timestamptz"},"numberofunits":{"type":"number","pgtype":"int4"},"certificateofoccupancydate":{"type":"date","pgtype":"timestamptz"},"certificateofoccupancyrequired":{"type":"string","pgtype":"varchar"},"parentjobid":{"type":"string","pgtype":"varchar"},"certificateofoccupancylink":{"type":"string","pgtype":"varchar"},"zoningpermitjobid":{"type":"string","pgtype":"varchar"},"numberofstories":{"type":"number","pgtype":"numeric"},"denialdocumentlink":{"type":"string","pgtype":"varchar"},"areaofdisturbance":{"type":"number","pgtype":"numeric"},"denialdate":{"type":"date","pgtype":"timestamptz"}},"total_rows":1}