{"rows":[{"cartodb_id":881648,"the_geom":"0101000020E61000003AAE3117A3CF52C06A30A55773FA4340","the_geom_webmercator":"0101000020110F0000012BC61AD8F35FC1ECC0C502BF895241","permitnumber":"944789","addressobjectid":"548897","parcel_id_num":"478838","permittype":"BP_ALTER","permitdescription":"ALTERATION PERMIT","commercialorresidential":null,"typeofwork":"MAJOR","approvedscopeofwork":"INSTALLATION OF A BRUNO, BATTERY POWERED VERTICAL PLATFORM LIFT IN THE FRONT OF THE HOME. EXCAVATION OF THE FRONT YARD FROM THE CITY SIDEWALK TO THE WALL OF THE HOME. APPROXIMATELY 5' WIDE AND 6' DEEP TO CREATE A LEVEL CONCRETE PAD, 3500 PSI FOR THE INSTALLATION OF THE LIFT. BUILD UP THE FRONT PORCH TO CREATE A LEVEL AND SMOOTH ENTRANCE INTO THE HOME FROM THE FRONT PORCH. PORCH BUILD UP OF PRESSURE TREATED LUMBER. EXTEND FRONT PORCH OUT BY 3' APPROXIMATELY 5' WIDE. TWO FOOTINGS WILL BE POURED, 12' BELOW GRADE, FOR PORCH EXTENSION. LANDSCAPE TIMERS WILL LINE THE CONCRETE PAD ON EITHER SIDE. THE VPL WILL BE INSTALLED ON THE NEW CONCRET-RAISE TO THE NEW EXTENSION.","permitissuedate":"2020-03-10T17:28:44Z","status":"COMPLETED","applicanttype":"CONTRACTOR","contractorname":"JEMILEX INC DBA 101 MOBILITY","contractoraddress1":"3370 PROGRESS DRIVE SUITE L","contractoraddress2":"JEMILEX INC","contractorcity":"BENSALEM","contractorstate":"PA","contractorzip":"19020-    ","mostrecentinsp":"2020-03-10T17:27:00Z","opa_account_num":"032006000","address":"6110 SPRUCE ST","unit_type":null,"unit_num":null,"zip":"083","censustract":"19139-3740","council_district":"3","opa_owner":"HARGROVE CAROLYN","systemofrecord":"HANSEN","geocode_x":2670843.28057988,"geocode_y":237028.54285183,"posse_jobid":null,"gdb_geomattr_data":null,"objectid":881614,"usecategories":null,"occupancytype":null,"permitcompleteddate":"2020-03-10T17:30:34Z","numberofunits":null,"certificateofoccupancydate":null,"certificateofoccupancyrequired":null,"parentjobid":null,"certificateofoccupancylink":null,"zoningpermitjobid":null,"numberofstories":null,"denialdocumentlink":null,"areaofdisturbance":null,"denialdate":null}],"time":0.14,"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}