{"rows":[{"cartodb_id":290755,"the_geom":"0101000020E6100000B46106D885CB52C08C4FEE3384F34340","the_geom_webmercator":"0101000020110F0000BFC8190FDBEC5FC188677FF810825241","permitnumber":"PP-2022-011736","addressobjectid":"156771821","parcel_id_num":"42327","permittype":"Plumbing","permitdescription":"Plumbing Permit","commercialorresidential":"Commercial","typeofwork":"Alterations","approvedscopeofwork":"F&I All Sanitary & Domestic Water Piping - F&I (3) Wall mounted LAVS, (10) Undermount LAVS , (1) Wall Mounted Urinal, (15) Wall Mounted Water Closets, (1) Shower, (2) Electric Water Coolers, (2) Undermount Double Bowl Sinks, (2) triple Bowl Sinks, (4) Hand Sinks, (1) Prep Sink, (1) Triple Bowl, (3) Drop in In Sinks, (4) Grease Traps, * FCO, (4) Mop Basins, (11) Floor Drains, (2) Area Drains, (2) 40 Gal WH, (1) 30 Gal WH, (3) Hot Water Return Pumps, (1) Sewage Ejector, (1) Sump Pump, (1) Elevator Sump Pump, (1)  BFP","permitissuedate":"2022-12-22T05:00:00Z","status":"Completed","applicanttype":"Owner","contractorname":"DWD MECHANICAL CONTRACTOR INC","contractoraddress1":"DWD MECHANICAL CONTRACTOR INC\n1005 Kedron Ave\nMorton, PA  19070\nUSA","contractoraddress2":null,"contractorcity":null,"contractorstate":null,"contractorzip":null,"mostrecentinsp":"2025-04-07T18:52:57Z","opa_account_num":"885698080","address":"3500 S BROAD ST","unit_type":null,"unit_num":null,"zip":"19145","censustract":"037300","council_district":"2","opa_owner":"CITY OF PHILA, LEAGUE ISL-FDR PARK","systemofrecord":"ECLIPSE","geocode_x":2689431.66866605,"geocode_y":217820.48782972,"posse_jobid":"506726120","gdb_geomattr_data":null,"objectid":290737,"usecategories":null,"occupancytype":null,"permitcompleteddate":"2025-04-08T14:27:25Z","numberofunits":null,"certificateofoccupancydate":null,"certificateofoccupancyrequired":null,"parentjobid":"434338469","certificateofoccupancylink":null,"zoningpermitjobid":null,"numberofstories":null,"denialdocumentlink":null,"areaofdisturbance":null,"denialdate":null}],"time":0.802,"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}