{"rows":[{"cartodb_id":54285,"the_geom":"0101000020E6100000D10203E9E6CD52C0753B0D60A9F84340","the_geom_webmercator":"0101000020110F00000743969EE5F05FC170C0F5A4C3875241","permitnumber":"CP-2022-005584","addressobjectid":"271639600","parcel_id_num":"493464","permittype":"Building","permitdescription":"Commercial Building Permit","commercialorresidential":"Commercial","typeofwork":"Addition and/or Alteration","approvedscopeofwork":"FOR EXTERIOR ALTERATIONS TO INCLUDE MASONRY CLEANING, REPAIR, & REPOINTING, NEW WINDOWS & DOORS, AND ROOF REPLACEMENT WITH NEW ROOF ACCESS LADDERS AND FOR LEVEL II INTERIOR ALTERATIONS TO INCLUDE NEW ELEVATOR/SHAFT, NEW FINISHES, REPAIRS TO PLASTER & WOOD, AND RENOVATED TOILET ROOMS. NO CHANGE TO EXISTING GROUP A-3 LIBRARY OCCUPANCY. BUILDING IS NOT SPRINKLERED. ALL WORK TO BE DONE PER APPROVED PLANS AND IN ACCORDANCE WITH 2018 IEBC. SEPARATE PERMITS REQUIRED FOR MECHANICAL, ELECTRICAL, AND PLUMBING WORK. IF SITE CONDITIONS VARY, CONTACT DESIGN PROFESSIONAL PRIOR TO START OF WORK.","permitissuedate":"2023-03-10T05:00:00Z","status":"Completed","applicanttype":"Professional / Tradesperson","contractorname":"SMITH CONSTRUCTION CO OF PHILADELPHIA","contractoraddress1":"SMITH CONSTRUCTION CO OF PHILADELPHIA\n10400 Drummond Road\nPhiladelphia, PA  19154\nUSA","contractoraddress2":null,"contractorcity":null,"contractorstate":null,"contractorzip":null,"mostrecentinsp":"2025-01-31T14:51:05Z","opa_account_num":"783249500","address":"4901 KINGSESSING AVE","unit_type":null,"unit_num":null,"zip":"19143","censustract":"007400","council_district":"3","opa_owner":"CITY OF PHILA, KINGSESSING REC CTR","systemofrecord":"ECLIPSE","geocode_x":2678586.35279552,"geocode_y":232156.1911154,"posse_jobid":"523971287","gdb_geomattr_data":null,"objectid":54263,"usecategories":null,"occupancytype":"A-3 Assembly (Worship, Recreation, Amusement, Other)","permitcompleteddate":"2025-02-04T14:39:59Z","numberofunits":1,"certificateofoccupancydate":null,"certificateofoccupancyrequired":"N","parentjobid":null,"certificateofoccupancylink":null,"zoningpermitjobid":null,"numberofstories":2,"denialdocumentlink":null,"areaofdisturbance":1200,"denialdate":null}],"time":0.147,"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}