{"rows":[{"cartodb_id":563286,"the_geom":"0101000020E6100000C586B86487C852C0B1F5F9AB99FD4340","the_geom_webmercator":"0101000020110F000002CA742AC5E75FC1530876913C8D5241","permitnumber":"937287","addressobjectid":"15756318","parcel_id_num":"286783","permittype":"Building","permitdescription":"Commercial Building Permit","commercialorresidential":"Commercial","typeofwork":"New Construction","approvedscopeofwork":"FOR THE ERECTION OF NEW (5) STORY ABOVE GRADE MIXED-USE BUILDING WITH (22) RESIDENTIAL DWELLING UNITS WITH TWENTY-SIX(26) BICYCLE SPACES IN AN ACCESSIBLE ROUTE AND SHARED RESIDENTIAL ROOF DECK. VACANT COMMERCIAL TENANT SPACES ON THE GROUND FLOOR AND BASEMENT(SEPARATE USE REGISTRATION AND FITOUT PERMITS REQUIRED PRIOR TO OCCUPANCY). NO SIGNAGE THIS APPLICATION.BUILDING TO BE FULLY SPRINKLERED.**SEPARATE PERMITS TO BE REQUIRED FOR ELECTRICAL, PLUMBING, MECHANICAL, FIRE SUPPRESSION, AND STANDPIPE SYSTEM INSTALLATIONS. SEPARATE PERMIT FROM PA DEPT OF LABOR & INDUSTRY REQ'D FOR ELEVATOR INSTALLATIONS.** (IBC 2009 NEW CONSTRUCTION)","permitissuedate":"2019-06-10T17:57:00Z","status":"Completed","applicanttype":"Professional / Tradesperson","contractorname":"KNIGHT RIDER CONSTRUCTION","contractoraddress1":"KNIGHT RIDER CONSTRUCTION\n1235 FEDERAL ST UNIT 2\nPHILADELPHIA, PA  19146\nUSA","contractoraddress2":null,"contractorcity":null,"contractorstate":null,"contractorzip":null,"mostrecentinsp":"2021-02-22T14:28:37Z","opa_account_num":"881068924","address":"2038 N FRONT ST","unit_type":null,"unit_num":null,"zip":"19122-1703","censustract":"015700","council_district":"7","opa_owner":"FAIRMANS GARRET HOLDING LLC","systemofrecord":"ECLIPSE","geocode_x":2701700.61844095,"geocode_y":246891.46031347,"posse_jobid":"191465843","gdb_geomattr_data":null,"objectid":563228,"usecategories":null,"occupancytype":"R-2 Residential (>2 Dwellings)|S-1 Storage (Moderate Hazard)|Unknown/Other","permitcompleteddate":"2021-03-08T14:35:37Z","numberofunits":22,"certificateofoccupancydate":"2021-04-30T11:59:53Z","certificateofoccupancyrequired":"Y","parentjobid":null,"certificateofoccupancylink":"https://eclipse.phila.gov/phillylmsprod/pub/ws/DocumentDownload/download?documentId=344876807&hash=9E901C9DC6871A99819E6900DBABB306C476807ED38DC01C1875177408A88248","zoningpermitjobid":null,"numberofstories":5,"denialdocumentlink":null,"areaofdisturbance":null,"denialdate":null}],"time":0.143,"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}