{"rows":[{"cartodb_id":167392,"the_geom":"0101000020E61000005D34FD5B97CA52C07D651A4356FC4340","the_geom_webmercator":"0101000020110F00003E0213F845EB5FC1D6E63D22D68B5241","permitnumber":"CP-2020-000981","addressobjectid":"134818674","parcel_id_num":"310627","permittype":"Building","permitdescription":"Commercial Building Permit","commercialorresidential":"Commercial","typeofwork":"New Construction","approvedscopeofwork":"FOR THE ERECTION OF AN ATTACHED STRUCTURE WITH ROOF DECK.  FOR A VACANT COMMERCIAL SPACE AT FIRST FLOOR FRONT( USE REGISTRATION PERMIT AND FIT-OUT REQUIRED PRIOR TO OCCUPANCY) IN THE SAME BUILDING WITH MULTI-FAMILY HOUSEHOLD LIVING (14 DWELLING UNITS) FROM FIRST FLOOR REAR THROUGH FIFTH(5TH) FLOORS WITH  FIVE(5) IA CLASS BICYCLE SPACES AT FIRST FLOOR SEPARATE PERMITS REQUIRED FOR MEPS WORK. BUILDING TO BE FULLY SPRINKLERED. SEPARATE APPROVAL FROM PA L&I REQUIRED FOR ELEVATOR INSTALLATION. SEE THE FOUNDATION ONLY PERMIT AP#1044228.\nAmendment to create horizontal exits from 2nd to 5th floors as per approved plans.","permitissuedate":"2020-07-06T04: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":"2021-12-15T20:13:36Z","opa_account_num":"471266910","address":"1723 RIDGE AVE","unit_type":null,"unit_num":null,"zip":"19130-1538","censustract":"014000","council_district":"5","opa_owner":"PELICAN HILL PARTNERS LLC","systemofrecord":"ECLIPSE","geocode_x":2692779.22867409,"geocode_y":243031.75496835,"posse_jobid":"224177149","gdb_geomattr_data":null,"objectid":167368,"usecategories":null,"occupancytype":"A-3 Assembly (Worship, Recreation, Amusement, Other)|R-2 Residential (>2 Dwellings)|S-2 Storage (Low Hazard)|Unknown/Other","permitcompleteddate":"2021-12-15T20:30:10Z","numberofunits":14,"certificateofoccupancydate":"2021-12-15T20:30:24Z","certificateofoccupancyrequired":"Y","parentjobid":null,"certificateofoccupancylink":"https://eclipse.phila.gov/phillylmsprod/pub/ws/DocumentDownload/download?documentId=422833003&hash=367B70EA2EA4B45488F35ED10D2091709610615BC9902217DDC23437B472F61A","zoningpermitjobid":null,"numberofstories":5,"denialdocumentlink":null,"areaofdisturbance":4166,"denialdate":null}],"time":1.621,"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}