{"rows":[{"cartodb_id":857513,"the_geom":"0101000020E610000080AEF9198BCB52C09F732A8ED1034440","the_geom_webmercator":"0101000020110F0000DC3855FDE3EC5FC18CC2059B21945241","permitnumber":"CP-2020-006786","addressobjectid":"425942693","parcel_id_num":"117077","permittype":"Building","permitdescription":"Commercial Building Permit","commercialorresidential":"Commercial","typeofwork":"New Construction","approvedscopeofwork":"FOR THE COMPLETE DEMOLITION OF EXISTING BUILDING AND FOR THE ERECTION OF AN ATTACHED BUILDING WITH A ROOF DECK. FOR THE USE AS MULTI-FAMILY (FORTY-NINE (49) UNITS) HOUSEHOLD LIVING WITH ACCESSARY PARKING. BUILDING TO BE FULLY SPRINKLERED. SEPARATE PERMITS REQURIED FOR M.E.P.S WORK. SEPARATE APPROVAL REQUIRED FROM PA LABOR AND INDUSTRY FOR ELEVATOR INSTALLATION.\nAmendment to change the construction type of entire building to type IIIA and add horizontal exits fron 2nd to 5th floors as per approved plans.","permitissuedate":"2021-03-23T04:00:00Z","status":"Completed","applicanttype":"Professional / Tradesperson","contractorname":"Tester Construction Group LLC","contractoraddress1":"Tester Construction Group LLC\nOne Bala Plaza\nSuite 504\nBala Cynwyd, PA  19004\nUSA","contractoraddress2":null,"contractorcity":null,"contractorstate":null,"contractorzip":null,"mostrecentinsp":"2023-10-27T12:16:44Z","opa_account_num":"881000051","address":"308 W CHELTEN AVE","unit_type":null,"unit_num":null,"zip":"19144-3805","censustract":"024000","council_district":"8","opa_owner":"ZI 308 W CHELTEN LLC","systemofrecord":"ECLIPSE","geocode_x":2687991.88206159,"geocode_y":264193.43924183,"posse_jobid":"294013155","gdb_geomattr_data":null,"objectid":857474,"usecategories":null,"occupancytype":"A-3 Assembly (Worship, Recreation, Amusement, Other)|R-2 Residential (>2 Dwellings)|S-2 Storage (Low Hazard)","permitcompleteddate":"2023-10-27T12:27:48Z","numberofunits":49,"certificateofoccupancydate":"2023-10-27T12:28:04Z","certificateofoccupancyrequired":"Y","parentjobid":null,"certificateofoccupancylink":"https://eclipse.phila.gov/phillylmsprod/pub/ws/DocumentDownload/download?documentId=656826710&hash=771760107CCA1EF15D8E30DE2B04B55224E4585F0CB41CF24A41EAA832990D1B","zoningpermitjobid":"303938072","numberofstories":5,"denialdocumentlink":null,"areaofdisturbance":13730,"denialdate":null}],"time":0.291,"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}