{"rows":[{"cartodb_id":278105,"the_geom":"0101000020E61000005DDE903ED9CA52C0079CA9028FF94340","the_geom_webmercator":"0101000020110F000077F8A6E1B5EB5FC184535B09C2885241","permitnumber":"666289","addressobjectid":"594006","parcel_id_num":"266598","permittype":"BP_ALTER","permitdescription":"ALTERATION PERMIT","commercialorresidential":null,"typeofwork":"MAJOR","approvedscopeofwork":"FOR LEVEL 3 ALTERATION TO AN EXISTING STRUCTURE TO INCLUDE: LOWERING OF EXISTING FIRST FLOOR OF FRONT BUILDING TO BE LEVEL WITH SIDEWALK; CONSTRUCTING NEW FIRE RATED STAIRWAY IN CENTER OF THE BUILDING; ADDING NEW TOP STOP ELEVATOR FOR RETAIL TENANT USE ONLY;CONNECTING NEW FIRST FLOOR FRONT TO SECOND FLOOR TO CREATE TWO LEVELS OF RETAIL; CONNECTING THE EXISTING ONE STORY NIGHTCLUB AT REAR TO REMAINING FIRST LEVEL ABOVE; AND CREATING EGRESS COURT ON WEST SIDE OF BUILDING. THIRD AND FOURTH FLOORS TO BE ABANDONED. USE PERMIT STILL REQUIRED FOR COMMERCIAL SPACE. ASBESTOS REMOVAL REQUIRED PRIOR TO THE START OF WORK. SEPARATE PERMITS REQUIRED FOR ALL MECHANICAL, ELECTRICAL, PLUMBING AND FIRE SUPPRESSION WORK.","permitissuedate":"2016-06-03T15:17:19Z","status":"EXPIRED","applicanttype":"DESIGN PROFESSIONAL","contractorname":"CLEMENS CONSTRUCTION CO INC","contractoraddress1":"1435 WALNUT ST","contractoraddress2":"2ND FL","contractorcity":"PHILADELPHIA","contractorstate":"PA","contractorzip":"19102-0000","mostrecentinsp":"2018-10-12T12:34:00Z","opa_account_num":"882428200","address":"1704 WALNUT ST","unit_type":null,"unit_num":null,"zip":"008","censustract":"19103-6101","council_district":"5","opa_owner":"AP 1704 WALNUT ST LP","systemofrecord":"HANSEN","geocode_x":2691883.63801097,"geocode_y":235095.18422387,"posse_jobid":null,"gdb_geomattr_data":null,"objectid":278060,"usecategories":null,"occupancytype":null,"permitcompleteddate":"2018-04-11T12:49:30Z","numberofunits":null,"certificateofoccupancydate":null,"certificateofoccupancyrequired":null,"parentjobid":null,"certificateofoccupancylink":null,"zoningpermitjobid":null,"numberofstories":null,"denialdocumentlink":null,"areaofdisturbance":null,"denialdate":null}],"time":0.148,"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}