{"rows":[{"cartodb_id":504935,"the_geom":"0101000020E6100000A351459A9BCA52C0A030EB6D43014440","the_geom_webmercator":"0101000020110F000094A73B2D4DEB5FC18C6E272D4C915241","permitnumber":"CP-2021-001994","addressobjectid":"508275153","parcel_id_num":"144313","permittype":"Building","permitdescription":"Commercial Building Permit","commercialorresidential":"Commercial","typeofwork":"New Construction","approvedscopeofwork":"FOR THE ERECTION OF ONE(1) SEMI-DETACHED STRUCTURE WITH ROOF DECK AT SECOND(2ND) FLOOR. FOR A VACANT COMMERCIAL SPACE( USE REGISTRATION PERMIT REQUIRED PRIOR TO OCCUPANCY) AT FIRST FLOOR IN THE SAME BUILDING WITH MULTI-FAMILY HOUSEHOLD LIVING ( 45 DWELLING UNITS) FROM SECOND(2nd)  FLOOR THROUGH FOURTH(4TH ) FLOORS WITH EIGHT(8) INTERIOR IA CLASS BICYCLE SPACES AT FIRST FLOOR WITH TEN(10) ACCESSORY PARKING SPACES INCLUDING WITH ONE(1) VAN ACCESSIBLE SPACES. BBUILDING TO BE FULLY SPRINKLERED. SEPARATE PERMITS REQUIRED FOR M.E.P.S WORK. SEPARATE APPROVAL REQUIRED FROM PA L&I FOR ELEVATOR INSTALLATION.\nAMENDMENT TO CHANGE INSULATION MATERIALS WITHIN EXTERIOR WALL STUDS AS PER APPROVED PLANS.","permitissuedate":"2021-10-06T04:00:00Z","status":"Completed","applicanttype":"Professional / Tradesperson","contractorname":"DANIEL J. KEATING COMPANY ","contractoraddress1":"DANIEL J. KEATING COMPANY \n134 N NARBERTH AVE\nNARBERTH, PA  19072\nUSA","contractoraddress2":null,"contractorcity":null,"contractorstate":null,"contractorzip":null,"mostrecentinsp":"2023-05-30T12:30:47Z","opa_account_num":null,"address":"2221 W VENANGO ST","unit_type":null,"unit_num":null,"zip":"19140-3802","censustract":"020200","council_district":"8","opa_owner":null,"systemofrecord":"ECLIPSE","geocode_x":2692296.4497111,"geocode_y":257044.04779583,"posse_jobid":"334468595","gdb_geomattr_data":null,"objectid":504885,"usecategories":null,"occupancytype":"B Business (Office)|R-2 Residential (>2 Dwellings)","permitcompleteddate":"2023-05-31T18:20:37Z","numberofunits":45,"certificateofoccupancydate":"2023-05-31T18:20:47Z","certificateofoccupancyrequired":"Y","parentjobid":null,"certificateofoccupancylink":"https://eclipse.phila.gov/phillylmsprod/pub/ws/DocumentDownload/download?documentId=606394246&hash=6DA790C369D4D0DC4B789B50B821638407E0A509BA0C66CED0220FB8CA051AAC","zoningpermitjobid":"301376564","numberofstories":4,"denialdocumentlink":null,"areaofdisturbance":12258,"denialdate":null}],"time":0.162,"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}