{"rows":[{"cartodb_id":211162,"the_geom":"0101000020E6100000ABF64D937ECA52C0EC2CAACD13FC4340","the_geom_webmercator":"0101000020110F00008D36FDDE1BEB5FC11515EA7B8C8B5241","permitnumber":"EP-2023-001460","addressobjectid":"515379148","parcel_id_num":"405124","permittype":"Electrical","permitdescription":"Electrical Permit","commercialorresidential":"Commercial","typeofwork":"Addition and/or Alteration","approvedscopeofwork":"Amend Permit to include full building scope of work. \n\n Install new 1600 amp service, (2) 400 amp services,34 gang \nmeter bank. Wiring throughout common areas, (32) units and core wiring for (3) commercial spaces. Provide wiring for \nmechanical and hvac equipment. Install a new fire alarm system throughout. Install rescue assistance system ,mag releases for door holders. as per APPROVED DRAWINGS -2017 nec & 2016 nfpa-72. \n** NO FIRE PUMP ON THIS PROJECT.\n\n","permitissuedate":"2026-09-22T04:00:00Z","status":"Issued","applicanttype":"Professional / Tradesperson","contractorname":"TJT ELECTRICAL & PLUMBING","contractoraddress1":"TJT ELECTRICAL & PLUMBING\n4834 OLD YORK ROAD\nPHILADELPHIA, PA  19141\nUSA","contractoraddress2":null,"contractorcity":null,"contractorstate":null,"contractorzip":null,"mostrecentinsp":"2026-11-19T19:41:04Z","opa_account_num":"881442492","address":"1614-20 RIDGE AVE","unit_type":null,"unit_num":null,"zip":"19130-2116","censustract":"013300","council_district":"5","opa_owner":"ECHO PHILLY PROPERTIES LL","systemofrecord":"ECLIPSE","geocode_x":2693224.65312106,"geocode_y":242305.6589377,"posse_jobid":"567396803","gdb_geomattr_data":null,"objectid":211099,"usecategories":null,"occupancytype":null,"permitcompleteddate":"2023-09-01T13:55:40Z","numberofunits":null,"certificateofoccupancydate":null,"certificateofoccupancyrequired":null,"parentjobid":"289071327","certificateofoccupancylink":null,"zoningpermitjobid":null,"numberofstories":null,"denialdocumentlink":null,"areaofdisturbance":null,"denialdate":null}],"time":4.255,"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}