{"rows":[{"cartodb_id":198684,"the_geom":"0101000020E610000051E483BAD2C952C031A74FDBF0F94340","the_geom_webmercator":"0101000020110F00005D3ACFF8F7E95FC1D31E87702E895241","permitnumber":"533591","addressobjectid":"19191","parcel_id_num":"394706","permittype":"BP_ALTER","permitdescription":"ALTERATION PERMIT","commercialorresidential":null,"typeofwork":"MAJOR","approvedscopeofwork":"**ASBESTOS ABATEMENT REQUIRED PRIOR TO THE COMMENCEMENT OF WORK, SEE PERMIT # 533408 FOR INTERIOR DEMOLITION** LEVEL II INTERIOR / EXTERIOR ALTERATIONS AT GROUND FLOOR COMMERCIAL STOREFRONTS AND ELEVATOR LOBBIES THOUGHOUT. REHAB ON ELEVATOR CAB INTERIORS. SUBDIVIDE SPACE \"G\" WITH NEW DEMISING WALL. 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** SEE PERMIT # 531685 FOR PLANS.","permitissuedate":"2014-05-23T13:37:20Z","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:26:00Z","opa_account_num":"781005000","address":"800-08 ARCH ST","unit_type":null,"unit_num":null,"zip":"005","censustract":"19107-3100","council_district":"1","opa_owner":"PHILADELPHIA PARKING AUTH","systemofrecord":"HANSEN","geocode_x":2696341.97952278,"geocode_y":236314.12559537,"posse_jobid":null,"gdb_geomattr_data":null,"objectid":198640,"usecategories":null,"occupancytype":null,"permitcompleteddate":"2017-05-12T18:27:00Z","numberofunits":null,"certificateofoccupancydate":null,"certificateofoccupancyrequired":null,"parentjobid":null,"certificateofoccupancylink":null,"zoningpermitjobid":null,"numberofstories":null,"denialdocumentlink":null,"areaofdisturbance":null,"denialdate":null}],"time":0.455,"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}