{"rows":[{"cartodb_id":232847,"the_geom":"0101000020E6100000ED06423C75CA52C019EDC6F7D1FA4340","the_geom_webmercator":"0101000020110F000094498E010CEB5FC1471C2FDB278A5241","permitnumber":"CP-2021-008526","addressobjectid":"158279804","parcel_id_num":"341139","permittype":"Building","permitdescription":"Commercial Building Permit","commercialorresidential":"Commercial","typeofwork":"New Construction","approvedscopeofwork":"FOR THE ERECTION OF AN ATTACHED STRUCTURE WITH ACCESSORY PARKING AND BICYCLE SPACES LOCATED ALONG AN ACCESSIBLE ROUTE. FOR USE AS HOUSEHOLD LIVING (ONE HUNDRED AND SIXTY-TWO (162) DWELLING UNITS). FOR THE CREATION OF INTERIOR, PARKING GARAGE FOR THIRTY-ONE (31) PARKING SPACES AND SEVENTY-FOUR (74) BICYCLE SPACES. BUILDING TO BE FULLY SPRINKLERED. SEPARATE PERMITS REQUIRED FOR MEP & FP WORK. SEPARATE APPROVAL REQUIRED FROM PA L&I FOR ELEVATOR INSTALLATION.\nSEPARATE APPROVAL REQUIRED FOR THE GEOPILE INSTALLATION.","permitissuedate":"2021-12-31T05:00:00Z","status":"Expired","applicanttype":"Professional / Tradesperson","contractorname":"BSI CONSTRUCTION LLC","contractoraddress1":"BSI CONSTRUCTION LLC\n735 Birch Ave\nBensalem, PA  19020\nUSA","contractoraddress2":null,"contractorcity":null,"contractorstate":null,"contractorzip":null,"mostrecentinsp":"2022-01-18T13:57:27Z","opa_account_num":"885714410","address":"1428 CALLOWHILL ST","unit_type":null,"unit_num":null,"zip":"19130-4018","censustract":"012500","council_district":"5","opa_owner":"BAYVIEW PHILADELPHIA CALLOWHILL LLC","systemofrecord":"ECLIPSE","geocode_x":2693489.14604762,"geocode_y":238734.02401309,"posse_jobid":"413722745","gdb_geomattr_data":null,"objectid":232811,"usecategories":null,"occupancytype":"R-2 Residential (>2 Dwellings)","permitcompleteddate":"2024-01-22T15:46:28Z","numberofunits":162,"certificateofoccupancydate":null,"certificateofoccupancyrequired":"Y","parentjobid":null,"certificateofoccupancylink":null,"zoningpermitjobid":"335575711","numberofstories":13,"denialdocumentlink":null,"areaofdisturbance":8580,"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}