{"rows":[{"cartodb_id":136901,"the_geom":"0101000020E6100000E3AF353086CC52C0E3B9B50112FA4340","the_geom_webmercator":"0101000020110F0000EEDA617C8EEE5FC19391CE2A53895241","permitnumber":"901409","addressobjectid":"594764","parcel_id_num":"338297","permittype":"BP_ALTER","permitdescription":"ALTERATION PERMIT","commercialorresidential":null,"typeofwork":"MAJOR","approvedscopeofwork":"REMOVE TWOR EXISTING ESCALATORS LEADING FROM THE FIRST FLOOR TO SECOND FLOORINGS AND REPLACE WITH TWO NEW ESCALATORS IN THE SAME LOCATIONS. REINSTALL EXISTING GUARD RAILINGS AND REPLACE FINISHES AS NECESSARY TO ACCOMODATE ESCALATOR WORK. WORK ALSO INCLUDES SETTING UP A TEMPORARY STAIR FROM REIASED INTERSTITIAL FLOOR TO FIRST FLOOR IN ORDER TO PROVIDE PROPER ACCESS AROUND PROTECTED JOBSITE.","permitissuedate":"2018-09-05T13:45:40Z","status":"COMPLETED","applicanttype":"CONTRACTOR","contractorname":"FLATIRON BUILDING COMPANY","contractoraddress1":"5189-91 RIDGE AVE","contractoraddress2":null,"contractorcity":"PHILADELPHIA","contractorstate":"PA","contractorzip":"19128-3735","mostrecentinsp":"2019-01-17T15:22:00Z","opa_account_num":"883727100","address":"3601-51 WALNUT ST","unit_type":null,"unit_num":null,"zip":"089","censustract":"19104-3800","council_district":"3","opa_owner":"TRS UNIV OF PENN","systemofrecord":"HANSEN","geocode_x":2684504.40875877,"geocode_y":236337.4956043,"posse_jobid":null,"gdb_geomattr_data":null,"objectid":136870,"usecategories":null,"occupancytype":null,"permitcompleteddate":"2019-01-17T15:22:42Z","numberofunits":null,"certificateofoccupancydate":null,"certificateofoccupancyrequired":null,"parentjobid":null,"certificateofoccupancylink":null,"zoningpermitjobid":null,"numberofstories":null,"denialdocumentlink":null,"areaofdisturbance":null,"denialdate":null}],"time":0.152,"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}