{"rows":[{"cartodb_id":771130,"the_geom":"0101000020E61000006B88BFFBD3CA52C075816AFD56F64340","the_geom_webmercator":"0101000020110F0000F261F2F1ACEB5FC1B8F7A24C31855241","permitnumber":"ZP-2024-005496","addressobjectid":"129873580","parcel_id_num":"88594","permittype":"Zoning","permitdescription":"Zoning Permit","commercialorresidential":"Commercial","typeofwork":"New construction, addition, GFA change","approvedscopeofwork":"For the erection of an addition fronting on both Broad St and Watts St  above an existing one story attached structure. Addition to include residential roof decks above the first and 5th floor roofs, with pilot houses and an elevator penthouse above the fifth floor roof. Size and location as shown on plans.","permitissuedate":"2024-07-24T20:33:01Z","status":"Cancelled","applicanttype":"Professional / Tradesperson","contractorname":"IAN SMITH","contractoraddress1":"IAN SMITH\n322 E THOMPSON ST\nPHILADELPHIA, PA  19125\nUSA","contractoraddress2":null,"contractorcity":null,"contractorstate":null,"contractorzip":null,"mostrecentinsp":null,"opa_account_num":"882045700","address":"2033-35 S BROAD ST","unit_type":null,"unit_num":null,"zip":"19148-5505","censustract":"004001","council_district":"1","opa_owner":"2033 BROAD STREET LLC","systemofrecord":"ECLIPSE","geocode_x":2692241.2999854,"geocode_y":225941.08794088,"posse_jobid":"751850767","gdb_geomattr_data":null,"objectid":771100,"usecategories":"Residential - Household Living - Multi-Family; Medical, Dental, and Health Practitioner - Group Medical, Dental, and Health Practitioner","occupancytype":null,"permitcompleteddate":"2026-03-26T13:30:37Z","numberofunits":null,"certificateofoccupancydate":null,"certificateofoccupancyrequired":null,"parentjobid":null,"certificateofoccupancylink":null,"zoningpermitjobid":null,"numberofstories":null,"denialdocumentlink":null,"areaofdisturbance":2000,"denialdate":null}],"time":0.176,"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}