{"rows":[{"cartodb_id":857515,"the_geom":"0101000020E61000009DBD72B89CC852C08FFDD3091DFD4340","the_geom_webmercator":"0101000020110F0000FA435A64E9E75FC1E5C15A6EB28C5241","permitnumber":"CP-2022-007173","addressobjectid":"135689144","parcel_id_num":"500218","permittype":"Building","permitdescription":"Commercial Building Permit","commercialorresidential":"Commercial","typeofwork":"Addition and/or Alteration","approvedscopeofwork":"FOR CHANGE OF OCCUPANCY AND LEVEL III ALTERATIONS TO INCLUDE UNDERPINNING, MEZZANINE, NEW PARTITIONS, FIXTURES, FURNISHINGS, FINISHES AS PER APPROVED PLANS. BUILDING TO BE SPRINKLERED PER NFPA 13. SEPARATE PERMITS REQUIRED FOR MEP AND FIRE SUPPRESSION WORK. **ASBESTOS ABATEMENT REQUIRED PRIOR TO START OF WORK.**\n\nAMENDMENT 11/27/23 FOR LAYOUT CHANGES, ELEVATOR VESTIBULE, AND OTHER MINOR CHANGES AS PER APPROVED PLANS. \nAMENDMENT 12/10/24 FOR REMOVAL RESTROOM AND INSULATION. ","permitissuedate":"2023-02-14T05:00:00Z","status":"Completed","applicanttype":"Professional / Tradesperson","contractorname":"GRIT Construction LLC","contractoraddress1":"GRIT Construction LLC\n266 Krams Ave\nPhiladelphia, PA  19128\nUSA","contractoraddress2":null,"contractorcity":null,"contractorstate":null,"contractorzip":null,"mostrecentinsp":"2025-01-14T16:54:31Z","opa_account_num":"881076100","address":"1801-03 N HOWARD ST","unit_type":null,"unit_num":null,"zip":"19122-2445","censustract":"015700","council_district":"7","opa_owner":"1801 N HOWARD STREET LLC","systemofrecord":"ECLIPSE","geocode_x":2701377.02178076,"geocode_y":245495.71185982,"posse_jobid":"548093590","gdb_geomattr_data":null,"objectid":857476,"usecategories":null,"occupancytype":"B Business (Office)|R-2 Residential (>2 Dwellings)","permitcompleteddate":"2025-01-14T17:34:48Z","numberofunits":29,"certificateofoccupancydate":"2025-01-30T13:12:17Z","certificateofoccupancyrequired":"Y","parentjobid":null,"certificateofoccupancylink":"https://eclipse.phila.gov/phillylmsprod/pub/ws/DocumentDownload/download?documentId=835416584&hash=0F3D9716E1F8D04039503FFC1BC57E8837D12D9C737DC062EDAC9812971C7269","zoningpermitjobid":"496514739","numberofstories":4,"denialdocumentlink":null,"areaofdisturbance":833,"denialdate":null}],"time":0.211,"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}