{"rows":[{"cartodb_id":769709,"the_geom":"0101000020E6100000767AF1B4CAC952C03457735BEFF94340","the_geom_webmercator":"0101000020110F000010659C58EAE95FC1DE343EC72C895241","permitnumber":"531685","addressobjectid":"19190","parcel_id_num":"8055","permittype":"BP_ALTER","permitdescription":"ALTERATION PERMIT","commercialorresidential":null,"typeofwork":"MAJOR","approvedscopeofwork":"**ASBESTOS ABATEMENT REQUIRED PRIOR TO THE COMMENCEMENT OF WORK, SEE PERMIT # 533407 FOR INTERIOR DEMOLITION** LEVEL II INTERIOR / EXTERIOR ALTERATIONS AT GROUND FLOOR COMMERCIAL STOREFRONTS AND ELEVATOR LOBBIES THROUGHOUT. REHAB ON ELEVATOR CAB INTERIORS. SEPARATE PERMITS REQUIRED FOR INTERIOR FITOUT(S) CERTIFICATE(S) OF OCCUPANCY AND ANY FIRE SUPPRESSION, MECHANICAL, ELECTRICAL OR PLUMBING WORK. **CANOPY PROJECTION EXCLUDED, NO RIGHT-OF-WAY ENROACHMENT WITHOUT STREETS DEPARTMENT APPROVAL**","permitissuedate":"2014-05-23T13:37:53Z","status":"COMPLETED","applicanttype":"CONTRACTOR","contractorname":"BITTENBENDER CONSTRUCTION LP","contractoraddress1":"5 N CHRIS COLUMBUS BLVD","contractoraddress2":"PIER 5","contractorcity":"PHILADELPHIA","contractorstate":"PA","contractorzip":"19106-    ","mostrecentinsp":"2017-05-12T18:25:00Z","opa_account_num":"781004800","address":"726-38 ARCH ST","unit_type":null,"unit_num":null,"zip":"005","censustract":"19106-1505","council_district":"1","opa_owner":"PHILADELPHIA PARKING AUTH","systemofrecord":"HANSEN","geocode_x":2696479.67518364,"geocode_y":236301.49906368,"posse_jobid":null,"gdb_geomattr_data":null,"objectid":769678,"usecategories":null,"occupancytype":null,"permitcompleteddate":"2017-05-12T18:25:17Z","numberofunits":null,"certificateofoccupancydate":null,"certificateofoccupancyrequired":null,"parentjobid":null,"certificateofoccupancylink":null,"zoningpermitjobid":null,"numberofstories":null,"denialdocumentlink":null,"areaofdisturbance":null,"denialdate":null}],"time":0.21,"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}