{"rows":[{"cartodb_id":515767,"the_geom":"0101000020E6100000799A684AFAC652C09C13938904004440","the_geom_webmercator":"0101000020110F0000144D95A522E55FC1870CB599EA8F5241","permitnumber":"PP-2020-005751","addressobjectid":"136085837","parcel_id_num":"150482","permittype":"Plumbing","permitdescription":"Plumbing Permit","commercialorresidential":"Commercial","typeofwork":"New Construction or Additions","approvedscopeofwork":"install water distribution and waste lines for following fixtures: 48 tub/shower units, 48 water closets, 48 lavatories, 24 kitchen sinks, 1 elevator sump pump,24 water heaters, 4 roof drains, and other fixtures (to include 24 washer drain standpipes).  Separate application to be filed for installation of two 6\" sanitary laterals and two 6\" storm water laterals with traps and FAI's","permitissuedate":"2020-07-27T04:00:00Z","status":"Completed","applicanttype":"Professional / Tradesperson","contractorname":"STRONGHOLD DEVELOPMENT & CONSTRUCTION LLC","contractoraddress1":"STRONGHOLD DEVELOPMENT & CONSTRUCTION LLC\n2209 NORTH AMERICAN STREET\nPHILADELPHIA, PA  19133\nUSA","contractoraddress2":null,"contractorcity":null,"contractorstate":null,"contractorzip":null,"mostrecentinsp":"2021-01-06T20:33:57Z","opa_account_num":"881142952","address":"3450 J ST","unit_type":null,"unit_num":null,"zip":"19134-1411","censustract":"019200","council_district":"7","opa_owner":"3450 J STREET LLC","systemofrecord":"ECLIPSE","geocode_x":2708284.0769594,"geocode_y":253970.48459847,"posse_jobid":"253723046","gdb_geomattr_data":null,"objectid":515700,"usecategories":null,"occupancytype":null,"permitcompleteddate":"2021-01-06T20:33:57Z","numberofunits":null,"certificateofoccupancydate":null,"certificateofoccupancyrequired":null,"parentjobid":"191465844","certificateofoccupancylink":null,"zoningpermitjobid":null,"numberofstories":null,"denialdocumentlink":null,"areaofdisturbance":null,"denialdate":null}],"time":0.488,"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}