{"rows":[{"cartodb_id":635823,"the_geom":"0101000020E6100000201550C2AFCA52C025FE2C48F5FD4340","the_geom_webmercator":"0101000020110F00008C6C156A6FEB5FC17768E81BA28D5241","permitnumber":"957422","addressobjectid":"15829639","parcel_id_num":"258277","permittype":"Building","permitdescription":"Commercial Building Permit","commercialorresidential":"Commercial","typeofwork":"Addition and/or Alteration","approvedscopeofwork":"FOR LEVEL II ALTERATIONS TO INCLUDE MODERNIZATION OF ELEVATOR SYSTEMS AND ASSOCIATED WORK. SEPARATE PERMIT TO BE OBAINTED WITH PA DEPT OF LABOR AND INDUSTRY ELEVATOR SECTION FOR MAJOR REPAIRS AND ALTERATIONS OF LIFTING DEVICES. ALL WORK TO BE DONE PER APPROVED PLANS. IF FIELD CONDITIONS VARY CONTACT DESIGN ENGINEER PRIOR TO THE START OF ANY WORK. SEPARATE PERMITS TO BE OBTAINED FOR ALL OTHER WORK.","permitissuedate":"2019-12-20T13:58:00Z","status":"Expired","applicanttype":"Professional / Tradesperson","contractorname":"SMITH CONSTRUCTION CO OF PHILADELPHIA","contractoraddress1":"SMITH CONSTRUCTION CO OF PHILADELPHIA\n10400 Drummond Road\nPhiladelphia, PA  19154\nUSA","contractoraddress2":null,"contractorcity":null,"contractorstate":null,"contractorzip":null,"mostrecentinsp":null,"opa_account_num":"886761305","address":"2000 W NORRIS ST","unit_type":null,"unit_num":null,"zip":"19121-2101","censustract":"015200","council_district":"5","opa_owner":"CITY OF PHILA, DEPT OF PUBLIC PROP","systemofrecord":"ECLIPSE","geocode_x":2692227.0761278,"geocode_y":247631.35220084,"posse_jobid":"217610652","gdb_geomattr_data":null,"objectid":635778,"usecategories":null,"occupancytype":"R-1 Residential (Transient)","permitcompleteddate":"2026-04-02T13:12:47Z","numberofunits":null,"certificateofoccupancydate":null,"certificateofoccupancyrequired":"N","parentjobid":null,"certificateofoccupancylink":null,"zoningpermitjobid":null,"numberofstories":1,"denialdocumentlink":null,"areaofdisturbance":null,"denialdate":null}],"time":0.153,"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}