{"rows":[{"cartodb_id":138168,"the_geom":"0101000020E610000026E1B33EC2C852C02296BA68F1FD4340","the_geom_webmercator":"0101000020110F00009DDD8A2129E85FC19420F7D09D8D5241","permitnumber":"853930","addressobjectid":"129005309","parcel_id_num":"13446","permittype":"Building","permitdescription":"Commercial Building Permit","commercialorresidential":"Commercial","typeofwork":"New Construction","approvedscopeofwork":"NEW CONSTRUCTION OF FOUR (4) STORY ABOVE GRADE PLANE, W. BASEMENT & UNOCCUPIED ROOFTOP STRUCTURES, TO CREATE A SINGLE-TENANT OFFICE BUILDING OF SHALLOW CONCRETE FOUNDATION, STRUCTURAL STEEL FRAMING, PRE-ENGINEERED WOOD TRUSS (DEFERRED), & WOOD SHEAR WALL CONSTRUCTION PER APPROVED PLANS; BUILDING TO BE FULLY SPRINKLERED. SEPARATE PERMIT REQUIRED FOR APPROVAL OF OPEN WEB WOOD TRUSSES (DEFERRED) & ANY MECH., ELEC., PLUMB., & FIRESUPP WORK. SEPARATE PERMIT FROM CMMNWLTH OF PA L&I FOR ELEVATOR INSTALLATION. ALL MEANS OF PEDESTRIAN PROTECTION TO BE IN PLACE PRIOR TO START OF WORK. SITE TO BE EXCAVATED AT AREAS ABUTTING PROPERTIES NOT WITHIN THE SCOPE OF THIS PERMIT. ADJONING PROPERTY OWNER(S) TO BE NOTIFIED IN WRITING MIN. TEN (10) DAYS PRIOR TO START OF WORK PER SEC. B-3307.1 OF THE PHILA. BLDG. CODE.","permitissuedate":"2019-06-24T13:48:00Z","status":"Expired","applicanttype":"Professional / Tradesperson","contractorname":"VENCO BUILDING GROUP INC","contractoraddress1":"VENCO BUILDING GROUP INC\n1551 W BUTLER PIKE\nBLUE BELL, PA  19422\nUSA","contractoraddress2":null,"contractorcity":null,"contractorstate":null,"contractorzip":null,"mostrecentinsp":null,"opa_account_num":"883139002","address":"201 W SUSQUEHANNA AVE","unit_type":null,"unit_num":null,"zip":"19122-1626","censustract":"016200","council_district":"7","opa_owner":"FINANTA CDC","systemofrecord":"ECLIPSE","geocode_x":2700665.58606167,"geocode_y":247836.60823288,"posse_jobid":"191465380","gdb_geomattr_data":null,"objectid":138142,"usecategories":null,"occupancytype":"B Business","permitcompleteddate":"2023-10-07T22:04:09Z","numberofunits":0,"certificateofoccupancydate":null,"certificateofoccupancyrequired":"Y","parentjobid":null,"certificateofoccupancylink":null,"zoningpermitjobid":null,"numberofstories":5,"denialdocumentlink":null,"areaofdisturbance":null,"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}