{"rows":[{"cartodb_id":404520,"the_geom":"0101000020E6100000AB8620E5C0CA52C050BAC51405FA4340","the_geom_webmercator":"0101000020110F00001D7387858CEB5FC12FC8BDD844895241","permitnumber":"669587","addressobjectid":"410535","parcel_id_num":"222383","permittype":"PP_PLUMBNG","permitdescription":"PLUMBING PERMIT","commercialorresidential":null,"typeofwork":"PLUMWP","approvedscopeofwork":"INTERIOR PLUMBING ALTERATIONS ON THE 1ST & 2ND FLOORS FOR A DAYCARE IN SUITES 100/200 - SANITARY BRANCHES CONNECTED TO STACKS MUST BE VENTED IN COMPLIANCE WITH SECTION P-1105 AND BRANCHES THAT ARE A CONTINUATION OF THE HOUSE DRAIN MUST COMPLY WITH SECTION P-1110.3 OF THE PHILADELPHIA PLUMBING CODE 2004 - WATER SUPPLIES AND WASTE PIPING FOR THE 3-COMPARTMENT SINK MUST COMPLY WITH TABLES P-811.2 & P-904.7 - THE GREASE TRAP MUST BE COMPLETELY AUTOMATIC AND/OR SEMI-AUTOMATIC AND A MINIMUM SIZE OF 20GPM/4OLBS - MANUAL-TYPE GREASE TRAPS THAT REQUIRE THE REMOVAL OF THE LID FOR SERVICING ARE PROHIBITED BY THE PHILADELPHIA PLUMBING CODE 2004 AND THE INDUSTRIAL WASTE UNIT REQUIREMENTS OF THE PHILADELPHIA WATER DEPARTMENT - THE ELEVATOR SUMP DISCHARGE MUST BE AN INDIRECT WASTE PER SECTION 3004.4 OF THE 2009 INTERNATIONAL BUILDING CODE","permitissuedate":"2016-02-22T15:51:34Z","status":"COMPLETED","applicanttype":"CONTRACTOR","contractorname":"DWD MECHANICAL CONTRACTOR INC.","contractoraddress1":"1005 KEDRON AVENUE","contractoraddress2":null,"contractorcity":"MORTON","contractorstate":"PA","contractorzip":"19070-    ","mostrecentinsp":"2016-07-01T10:56:00Z","opa_account_num":"883053000","address":"1625-37 MARKET ST","unit_type":null,"unit_num":null,"zip":"004","censustract":"19103-2807","council_district":"5","opa_owner":"RC 1635 MARKET STREET LP ASHLEY 1635 MARKET STREET","systemofrecord":"HANSEN","geocode_x":2692261.76272077,"geocode_y":236419.39341502,"posse_jobid":null,"gdb_geomattr_data":null,"objectid":404477,"usecategories":null,"occupancytype":null,"permitcompleteddate":"2016-07-02T10:56:56Z","numberofunits":null,"certificateofoccupancydate":null,"certificateofoccupancyrequired":null,"parentjobid":null,"certificateofoccupancylink":null,"zoningpermitjobid":null,"numberofstories":null,"denialdocumentlink":null,"areaofdisturbance":null,"denialdate":null}],"time":0.146,"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}