{"rows":[{"cartodb_id":381860,"the_geom":"0101000020E61000003D24D31E25CA52C0C2D122E47EFA4340","the_geom_webmercator":"0101000020110F0000404338EC83EA5FC1373183CECB895241","permitnumber":"917065","addressobjectid":"15433898","parcel_id_num":"200406","permittype":"Building","permitdescription":"Commercial Building Permit","commercialorresidential":"Commercial","typeofwork":"Addition and/or Alteration","approvedscopeofwork":"FOR THE INSTALLATION OF AN ELEVATOR IN AN EXISTING TWO STORY FUNERAL HOME. ALL STRUCTURAL AND FRAMING WORK TO BE COMPLETED PER DETAILS SEALED BY STRUCTURAL ENGINEER. ELEVATOR TO BE INSTALLED PER MANUFACTURER'S SPECIFICATIONS. ALL WORK TO BE DONE PER APPROVED PLANS. IF FIELD CONDITIONS VARY CONTACT DESIGN ENGINEER PRIOR TO THE START OF ANY WORK. SEPARATE PERMITS REQUIRED FOR ALL OTHER WORK.","permitissuedate":"2019-03-22T16:36:00Z","status":"Expired","applicanttype":"Owner","contractorname":"PLATINUM GUTTERS INC","contractoraddress1":"PLATINUM GUTTERS INC\n5920 DITMAN STREET\nPHILADELPHIA, PA  19135\nUSA","contractoraddress2":null,"contractorcity":null,"contractorstate":null,"contractorzip":null,"mostrecentinsp":"2021-01-12T15:51:26Z","opa_account_num":"882917990","address":"247-49 N 12TH ST","unit_type":null,"unit_num":null,"zip":"19107-1718","censustract":"000200","council_district":"1","opa_owner":"CHOI JAYSON","systemofrecord":"ECLIPSE","geocode_x":2694886.40738216,"geocode_y":237851.03805694,"posse_jobid":"217609895","gdb_geomattr_data":null,"objectid":381805,"usecategories":null,"occupancytype":"B Business","permitcompleteddate":"2023-05-31T13:30:42Z","numberofunits":null,"certificateofoccupancydate":null,"certificateofoccupancyrequired":"Y","parentjobid":null,"certificateofoccupancylink":null,"zoningpermitjobid":null,"numberofstories":2,"denialdocumentlink":null,"areaofdisturbance":null,"denialdate":null}],"time":0.175,"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}