{"rows":[{"cartodb_id":810588,"the_geom":"0101000020E6100000557DC15AF1CA52C0F3ECF895A8F94340","the_geom_webmercator":"0101000020110F000012E8BCD5DEEB5FC1E0F1F15EDE885241","permitnumber":"CP-2023-006769","addressobjectid":"134578831","parcel_id_num":"38347","permittype":"Building","permitdescription":"Commercial Building Permit","commercialorresidential":"Commercial","typeofwork":"Addition and/or Alteration","approvedscopeofwork":"For level II alteration to the existing structure with partial change of occupancy classification to create a sit-down restaurant with accessory office and accessory storage in an existing structure at 1st, 2nd, 3rd floor, and partial basement space. Building is fully sprinklered. Separate permits required for MEP and FP work. Asbestos remediation required prior to start of other work.\nAmendment to the facade design.\nStructural amendment to elevator foundation and core location.\nAmendment#1 to the floor layout on 3rd floor and basement.\nAmendment#2 for minor change to the ceiling and room design.","permitissuedate":"2024-01-24T05:00:00Z","status":"Completed","applicanttype":"Professional / Tradesperson","contractorname":"HUNTER ROBERTS HOLDINGS LLC","contractoraddress1":"HUNTER ROBERTS HOLDINGS LLC\n501 NW GRAND BLVD - 6TH FLOOR\nOKLAHOMA CITY, OK  73118\nUSA","contractoraddress2":null,"contractorcity":null,"contractorstate":null,"contractorzip":null,"mostrecentinsp":"2025-07-23T21:34:42Z","opa_account_num":null,"address":"1805-09 WALNUT ST","unit_type":null,"unit_num":null,"zip":"19103-4727","censustract":"000700","council_district":"5","opa_owner":null,"systemofrecord":"ECLIPSE","geocode_x":2691462.93276076,"geocode_y":235367.33453226,"posse_jobid":"669712552","gdb_geomattr_data":null,"objectid":810540,"usecategories":null,"occupancytype":"A-2 Assembly (Food)|B Business (Office)","permitcompleteddate":"2025-07-24T11:49:53Z","numberofunits":1,"certificateofoccupancydate":"2025-07-24T11:50:08Z","certificateofoccupancyrequired":"Y","parentjobid":"703492529","certificateofoccupancylink":"https://eclipse.phila.gov/phillylmsprod/pub/ws/DocumentDownload/download?documentId=897957984&hash=6C1DC73125B2983F157ED64CDE7C516204D240AF2D3669010D3330D4B84D1FD1","zoningpermitjobid":"680777560","numberofstories":4,"denialdocumentlink":null,"areaofdisturbance":135,"denialdate":null}],"time":0.188,"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}