{"rows":[{"cartodb_id":584542,"the_geom":"0101000020E6100000D39CFBC9F3CC52C0B9E7316770FA4340","the_geom_webmercator":"0101000020110F0000675655A748EF5FC1D8C812C1BB895241","permitnumber":"990599","addressobjectid":"130749891","parcel_id_num":"241100","permittype":"Building","permitdescription":"Commercial Building Permit","commercialorresidential":"Commercial","typeofwork":"Addition and/or Alteration","approvedscopeofwork":"FOR LEVEL III ALTERATION WITH PARTIAL CHANGE OF USE CLASSIFICATION WITHIN 3 STORY EXISTING STRUCTURE WITH CELLAR, INCLUDING THE SELECT DEMOLITION OF INTERIOR ELEMENTS AS NOTED IN THE PLANS. THE FIRST FLOOR HAVE BUSINESS AND MERCANTLE USES. SECOND AND THIRD FLOORS HAVE BUSINESS/PROFESSIONAL OFFICE USES. THE CELLAR WILL BE USED FOR STORAGE AND BUILDING UTILITIES ONLY. SEPARATE PERMITS REQURIED FOR ALL M.E.P.S WORK. SEPARATE PERMITS REQUIRED FROM PA LABOR AND INDUSTRY FOR ELEVATOR INSTALLATION.ASBESTOS REMOVAL SHALL BE DONE PRIOR TO START OF THE OTHER WORK.","permitissuedate":"2019-08-16T17:45:00Z","status":"Completed","applicanttype":"Professional / Tradesperson","contractorname":"COLUMBUS CONSTRUCTION LLC","contractoraddress1":"COLUMBUS CONSTRUCTION LLC\n1930 S 25TH ST\nPHILADELPHIA, PA  19145\nUSA","contractoraddress2":null,"contractorcity":null,"contractorstate":null,"contractorzip":null,"mostrecentinsp":"2021-03-16T12:09:25Z","opa_account_num":"773015000","address":"22-26 S 40TH ST","unit_type":null,"unit_num":null,"zip":"19104-3009","censustract":"008802","council_district":"3","opa_owner":"22 SOUTH 40TH STREET OWNE","systemofrecord":"ECLIPSE","geocode_x":2682599.51283794,"geocode_y":237332.2993444,"posse_jobid":"217610747","gdb_geomattr_data":null,"objectid":584506,"usecategories":null,"occupancytype":"B Business (Office)|M Mercantile (Retail)|S-2 Storage (Low Hazard)|U Utility and Miscellaneous","permitcompleteddate":"2021-03-19T13:16:23Z","numberofunits":null,"certificateofoccupancydate":"2021-04-21T15:09:10Z","certificateofoccupancyrequired":"Y","parentjobid":null,"certificateofoccupancylink":"https://eclipse.phila.gov/phillylmsprod/pub/ws/DocumentDownload/download?documentId=341713945&hash=B2CBE24695EB9E5D277F595ABE26FDB497E33D75206CC3E6A625810F7A054E8F","zoningpermitjobid":null,"numberofstories":3,"denialdocumentlink":null,"areaofdisturbance":null,"denialdate":null}],"time":0.155,"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}