{"rows":[{"cartodb_id":568722,"the_geom":"0101000020E61000001203CCF328CC52C047EEA0769CF94340","the_geom_webmercator":"0101000020110F0000BE347B1DF0ED5FC143E3D2F0D0885241","permitnumber":"553636","addressobjectid":"684445","parcel_id_num":null,"permittype":"BP_ALTER","permitdescription":"ALTERATION PERMIT","commercialorresidential":null,"typeofwork":"MAJOR","approvedscopeofwork":"NO CHANGE IN USE AND OCCUPANCY CLASSIFICATION. INTERIOR ALTERATIONS TO FIT OUT FOR THE 1ST AND 2ND LEVEL, STRUCTURAL WORK, ALTERATIONS TO THE BUILDING ENVELOPE, NEW ELEVATOR, AND SPECIAL INSPECTIONS TO AN EXISTING ATHLETIC FACILITY AS PER PLANS. ASBESTOS ABATEMENT REQUIRED PRIOR TO COMMENCEMENT OF WORK. SEPARATE PERMIT REQUIRED FOR MECHANICAL, ELECTRICAL, PLUMBING, AND FIRE SUPPRESSION WORK.","permitissuedate":"2014-08-27T14:03:33Z","status":"COMPLETED","applicanttype":"APPL","contractorname":"LORENZON BROTHERS COMPANY","contractoraddress1":"220 EAST SPRINGFIELD AVE","contractoraddress2":null,"contractorcity":"PHILADELPHIA","contractorstate":"PA","contractorzip":"19118-0000","mostrecentinsp":"2016-01-15T21:13:00Z","opa_account_num":"885623800","address":"201 S 32ND ST","unit_type":null,"unit_num":null,"zip":"089","censustract":"19104-4300","council_district":"3","opa_owner":"TRS UNIV OF PENN","systemofrecord":"HANSEN","geocode_x":2686137.0027364,"geocode_y":235077.50521576,"posse_jobid":null,"gdb_geomattr_data":null,"objectid":568673,"usecategories":null,"occupancytype":null,"permitcompleteddate":"2016-01-15T21:14:27Z","numberofunits":null,"certificateofoccupancydate":null,"certificateofoccupancyrequired":null,"parentjobid":null,"certificateofoccupancylink":null,"zoningpermitjobid":null,"numberofstories":null,"denialdocumentlink":null,"areaofdisturbance":null,"denialdate":null}],"time":0.165,"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}