{"rows":[{"cartodb_id":371308,"the_geom":"0101000020E6100000C69369234FC952C0C44A884473F94340","the_geom_webmercator":"0101000020110F00005021E07318E95FC14704314DA3885241","permitnumber":"996607","addressobjectid":"15743131","parcel_id_num":"132838","permittype":"Building","permitdescription":"Commercial Building Permit","commercialorresidential":"Commercial","typeofwork":"Addition and/or Alteration","approvedscopeofwork":"FOR THE LEVEL III ALTERATION TO THE EXISTING HOTEL TO INCLUDE CONSTRUCTING ADA RAMP AT EXTERIOR, PER PLANS PHC STAFF TO REVIEW MASONRY CLEANING SAMPLE FOR FINAL APPROVAL. BUIDLING TO BE FULLY SPRINKLERD. SEPARATE PERMITS REQUIRED FOR M.E.P.S WORK. SEPARATE APPROVAL FORM PA LABOR AND INDUSTRIAL DEPARTMENT FOR THE ELEVATOR INSTALLATION.","permitissuedate":"2019-09-27T15:48:00Z","status":"Completed","applicanttype":"Owner","contractorname":"INTECH CONSTRUCTION LLC","contractoraddress1":"INTECH CONSTRUCTION LLC\n3020 MARKET ST\n6TH FLR\nPHILADELPHIA, PA  19104\nUSA","contractoraddress2":null,"contractorcity":null,"contractorstate":null,"contractorzip":null,"mostrecentinsp":"2022-04-05T11:54:26Z","opa_account_num":"883712500","address":"235 CHESTNUT ST","unit_type":null,"unit_num":null,"zip":"19106-2887","censustract":"000100","council_district":"1","opa_owner":"235 CHESTNUT STREET ASSOC","systemofrecord":"ECLIPSE","geocode_x":2698633.88686374,"geocode_y":234984.85663632,"posse_jobid":"217610920","gdb_geomattr_data":null,"objectid":371265,"usecategories":null,"occupancytype":null,"permitcompleteddate":"2022-04-05T19:54:32Z","numberofunits":null,"certificateofoccupancydate":null,"certificateofoccupancyrequired":"N","parentjobid":null,"certificateofoccupancylink":null,"zoningpermitjobid":null,"numberofstories":5,"denialdocumentlink":null,"areaofdisturbance":null,"denialdate":null}],"time":0.146,"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}