{"rows":[{"cartodb_id":20791,"the_geom":"0101000020E610000022D4CEDDFECA52C0820B5BF36FF34340","the_geom_webmercator":"0101000020110F00001B3749C9F5EB5FC134FAA98CFA815241","permitnumber":"890847","addressobjectid":"51954","parcel_id_num":"403151","permittype":"BP_ALTER","permitdescription":"ALTERATION PERMIT","commercialorresidential":null,"typeofwork":"MAJOR","approvedscopeofwork":"FOR INTERIOR DEMOLITION AND CONSTRUCTION OF NEW EVENT CONCESSIONS AND ASSOCIATED WORK ON LEVEL 6 WITH THE INSTALLATION OF AN ELEVATOR SHAFT THROUGHOUT. RENOVATIONS TO INCLUDE THE ERECTION OF PARITION WALLS, PROVIDE FINISHES/FURNISHINGS AND ACCESSIBILITY IMPROVEMENTS THROUGHOUT. ALL WORK TO BE DONE PER APPROVED PLANS.IF FIELD CONDITIONS VARY CONTACT STRUCTURAL ENGINEER PRIOR TO THE START OF ANY WORK. SEPARATE PERMITS REQUIRED FOR ALL OTHER WORK.","permitissuedate":"2018-09-13T14:37:19Z","status":"COMPLETED","applicanttype":"CONTRACTOR","contractorname":"STRUCTURE TONE,LLC","contractoraddress1":"1500 WALNUT STREET","contractoraddress2":"SUITE 1410","contractorcity":"PHILADELPHIA","contractorstate":"PA","contractorzip":"19102-    ","mostrecentinsp":"2020-01-15T13:18:00Z","opa_account_num":"788020600","address":"3601 S BROAD ST","unit_type":null,"unit_num":null,"zip":"049","censustract":"19148-5200","council_district":"2","opa_owner":"CITY OF PHILA","systemofrecord":"HANSEN","geocode_x":2691748.63652464,"geocode_y":217662.80132219,"posse_jobid":null,"gdb_geomattr_data":null,"objectid":20730,"usecategories":null,"occupancytype":null,"permitcompleteddate":"2020-01-15T13:21:34Z","numberofunits":null,"certificateofoccupancydate":null,"certificateofoccupancyrequired":null,"parentjobid":null,"certificateofoccupancylink":null,"zoningpermitjobid":null,"numberofstories":null,"denialdocumentlink":null,"areaofdisturbance":null,"denialdate":null}],"time":0.284,"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}