{"rows":[{"cartodb_id":763416,"the_geom":"0101000020E6100000A6C7D68EDECD52C02F46670601FD4340","the_geom_webmercator":"0101000020110F00002C72AF6ED7F05FC1297C3162938C5241","permitnumber":"CP-2020-005797","addressobjectid":"159307619","parcel_id_num":"1472195","permittype":"Building","permitdescription":"Commercial Building Permit","commercialorresidential":"Commercial","typeofwork":"New Construction","approvedscopeofwork":"FOR THE ERECTION OF A DETACHED STRUCTURE. FOR USE AS WAREHOUSE AND BUSINESS AND PROFESSIONAL OFFICE, AND SIXTY-FOUR (64) ACCESSORY OFF STREET SURFACE PARKING SPACES INCLUDING 4 ADA SPACES (INCLUDING 1 VAN ACCESSIBLE) AND FIVE (5) OFF STREET LOADING SPACES, AND SEVEN (7) OFF STREET BICYCLE PARKING SPACES ON AN ACCESSIBLE ROUTE. BUILDING TO BE FULLY SPRINKLERED. SEPARATE PERMITS REQUIRED FOR M.E.P.S WORK. SEPARATE APPROVAL REQUIRED FROM PA L&I FOR ELEVATOR INSTALLATION. ","permitissuedate":"2020-12-29T05:00:00Z","status":"Completed","applicanttype":"Professional / Tradesperson","contractorname":"Domus, Inc.","contractoraddress1":"Domus, Inc.\n101 Limekiln Pike\nGlenside, PA  19038\nUSA","contractoraddress2":null,"contractorcity":null,"contractorstate":null,"contractorzip":null,"mostrecentinsp":"2023-08-22T17:57:01Z","opa_account_num":"884000142","address":"4801 JEFFERSON ST","unit_type":null,"unit_num":null,"zip":"19131-4743","censustract":"011100","council_district":"4","opa_owner":"SUPRA ENTERPRISES LIMITED LIABILITY COMP","systemofrecord":"ECLIPSE","geocode_x":2678374.77641426,"geocode_y":244513.4262542,"posse_jobid":"281596717","gdb_geomattr_data":null,"objectid":763360,"usecategories":null,"occupancytype":"B Business (Office)|H-3 High Hazard (Ready Combustion)|S-1 Storage (Moderate Hazard)","permitcompleteddate":"2023-08-22T19:27:46Z","numberofunits":1,"certificateofoccupancydate":"2023-08-24T11:30:10Z","certificateofoccupancyrequired":"Y","parentjobid":null,"certificateofoccupancylink":"https://eclipse.phila.gov/phillylmsprod/pub/ws/DocumentDownload/download?documentId=636038014&hash=AD3FF53B57677A36D03008D1F1B51CE01593B3F3A395C1DFB861D0AE1DBC181F","zoningpermitjobid":"226790595","numberofstories":3,"denialdocumentlink":null,"areaofdisturbance":319875,"denialdate":null}],"time":0.156,"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}