{"rows":[{"cartodb_id":211003,"the_geom":"0101000020E6100000F08995CFB0CE52C0273A9D57D4F94340","the_geom_webmercator":"0101000020110F000094686E913CF25FC1137022D90E895241","permitnumber":"MP-2022-005048","addressobjectid":"129546928","parcel_id_num":"227321","permittype":"Mechanical","permitdescription":"Mechanical / Fuel Gas Permit","commercialorresidential":"Commercial","typeofwork":"Addition and/or Alterations","approvedscopeofwork":"FOR THE INSTALLATION OF APPLIANCES, FANS, AND ASSOCIATED DUCTWORK SERVING ELEVATOR MACHINE ROOMS AS PER APPROVED PLANS AND IN ACCORDANCE WITH 2018 IMC. APPLIANCES TO BE INSTALLED IN ACCORDANCE WITH MANUFACTURER SPECIFICATIONS. SEPARATE PERMITS TO BE OBTAINED FOR ALL OTHER WORK. IF SITE CONDITIONS VARY, CONTACT DESIGN ENGINEER PRIOR TO START OF WORK. SEE CP-2022-003916 FOR ASSOCIATED BUILDING ALTERATIONS PERMIT.","permitissuedate":"2022-09-29T04:00:00Z","status":"Completed","applicanttype":"Professional / Tradesperson","contractorname":"HERMAN GOLDNER CO INC","contractoraddress1":"HERMAN GOLDNER CO INC\n7777 BREWSTER AVE\nPHILADELPHIA, PA  19153\nUSA","contractoraddress2":null,"contractorcity":null,"contractorstate":null,"contractorzip":null,"mostrecentinsp":"2024-04-02T19:41:20Z","opa_account_num":"774005000","address":"5301 CEDAR AVE","unit_type":null,"unit_num":null,"zip":"19143-1996","censustract":"008000","council_district":"3","opa_owner":"PHMC WEST","systemofrecord":"ECLIPSE","geocode_x":2675037.58111019,"geocode_y":235379.61050431,"posse_jobid":"523139597","gdb_geomattr_data":null,"objectid":210942,"usecategories":null,"occupancytype":null,"permitcompleteddate":"2024-04-03T13:37:22Z","numberofunits":null,"certificateofoccupancydate":null,"certificateofoccupancyrequired":null,"parentjobid":"496478405","certificateofoccupancylink":null,"zoningpermitjobid":null,"numberofstories":null,"denialdocumentlink":null,"areaofdisturbance":null,"denialdate":null}],"time":0.279,"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}