{"rows":[{"cartodb_id":485048,"the_geom":"0101000020E6100000F8BD77E07FCA52C0DF79E6AF62F94340","the_geom_webmercator":"0101000020110F0000077CE6141EEB5FC12DBDC7EE90885241","permitnumber":"893642","addressobjectid":"51349","parcel_id_num":"81337","permittype":"BP_ALTER","permitdescription":"ALTERATION PERMIT","commercialorresidential":null,"typeofwork":"MAJOR","approvedscopeofwork":"FOR THE BREACH OF SEPARATION WALLS BETWEEN EXISTING BUILDINGS ON FOUR DEEDED LOTS TO CREATE ONE STRUCTURE WITH AN EXTENSION IN FLOOR AREA (ADDITION) THROUGHOUT THE ENTIRE NEW STRUCTURE TO CREATE A BANQUET HALL/PRIVATE CLUB ON 1ST AND 2ND FLOORS OF THE ENTIRE STRUCTURE, NO CHANGE OF USE CLASSIFICATION. SEE CASE# 34806 FOR THE BBS VARIANCE. BUILDING TO BE FULLY SPRINKLERED. SEPARATE PERMITS TO BE REQUIRED FOR NEW ELECTRICAL, MECHANICAL, PLUMBING, AND FIRE SUPPRESSION SYSTEM WORK.  SEPARATE PERMITS REQUIRED FROM PA DEPT OF LABOR & INDUSTRY FOR ELEVATOR INSTALLATION.","permitissuedate":"2018-10-03T13:38:18Z","status":"COMPLETED","applicanttype":null,"contractorname":"WELLCRAFT CONSTRUCTION CO INC","contractoraddress1":"180 NEW ROAD","contractoraddress2":null,"contractorcity":"SOUTHAMPTON","contractorstate":"PA","contractorzip":"18966-0000","mostrecentinsp":"2019-01-22T13:07:00Z","opa_account_num":"882142500","address":"227-29 S BROAD ST","unit_type":null,"unit_num":null,"zip":"009","censustract":"19107-5303","council_district":"1","opa_owner":"BL PARTNERS GROUP LP","systemofrecord":"HANSEN","geocode_x":2693426.69472921,"geocode_y":234647.38032683,"posse_jobid":null,"gdb_geomattr_data":null,"objectid":485023,"usecategories":null,"occupancytype":null,"permitcompleteddate":"2019-01-23T13:08:14Z","numberofunits":null,"certificateofoccupancydate":null,"certificateofoccupancyrequired":null,"parentjobid":null,"certificateofoccupancylink":null,"zoningpermitjobid":null,"numberofstories":null,"denialdocumentlink":null,"areaofdisturbance":null,"denialdate":null}],"time":0.139,"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}