{"rows":[{"cartodb_id":636172,"the_geom":"0101000020E61000001564D41A12CA52C04044A798E6FD4340","the_geom_webmercator":"0101000020110F00005CB1709F63EA5FC126EAC6D4918D5241","permitnumber":"1057599","addressobjectid":"133806262","parcel_id_num":"5061","permittype":"Building","permitdescription":"Commercial Building Permit","commercialorresidential":"Commercial","typeofwork":"New Construction","approvedscopeofwork":"FOR THE ERECTION OF AN ATTACHED STRUCTURE FOR USE AS VACANT COMMERCIAL SPACE ON THE FIRST FLOOR (SEPARATE USE REGISTRATION, FIT-OUT AND C/O REQUIRED PRIOR TO OCCUPANCY). FOR USE AS A TOTAL OF 40 DWELLING UNITS WITH 14 CLASS 1A BICYCLE PARKING SPACES ON AN ACCESSIBLE ROUTE AS PER APPROVED PLANS. SEPARATE PERMITS REQUIRED FOR M.E.P.S WORK. SEPARATE APPROVAL REQUIRED FROM PA L&I FOR ELEVATOR INSTALLATION.\nAMENDMENT TO THE APPROVED PLANS TO CREATE HORIZONTAL EXITS THROUHG ALL LEVELS.\nAMENDMENT TO THE FLOOR LAYOUT AND FIRE RATED ASSEMBLIES AS PER APPROVED REVISED PLANS.","permitissuedate":"2021-02-04T05:00:00Z","status":"Completed","applicanttype":"Professional / Tradesperson","contractorname":"Ascent Design and Builder LLC","contractoraddress1":"Ascent Design and Builder LLC\n117 Spring Garden St.\nSTE-C\nPhiladelphia, PA  19123\nUSA","contractoraddress2":null,"contractorcity":null,"contractorstate":null,"contractorzip":null,"mostrecentinsp":"2024-04-16T19:41:01Z","opa_account_num":null,"address":"2008 N BROAD ST","unit_type":null,"unit_num":null,"zip":"19121-2305","censustract":"015300","council_district":"5","opa_owner":null,"systemofrecord":"ECLIPSE","geocode_x":2694927.17225706,"geocode_y":247547.16666503,"posse_jobid":"191466136","gdb_geomattr_data":null,"objectid":636125,"usecategories":null,"occupancytype":"R-2 Residential (>2 Dwellings)|U Utility and Miscellaneous|Unknown/Other","permitcompleteddate":"2024-04-16T19:41:31Z","numberofunits":0,"certificateofoccupancydate":"2024-04-16T19:41:45Z","certificateofoccupancyrequired":"Y","parentjobid":null,"certificateofoccupancylink":"https://eclipse.phila.gov/phillylmsprod/pub/ws/DocumentDownload/download?documentId=714454673&hash=5E580E5C3A71532A874DE37E54F28ACB2DE76A1B7A9B63FFEA6890839D7FB9E8","zoningpermitjobid":null,"numberofstories":6,"denialdocumentlink":null,"areaofdisturbance":null,"denialdate":null}],"time":0.14,"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}