Street Resurfacing Schedule

City of New York

@usgov.city_of_new_york_street_resurfacing_schedule

Table List

1 table(8.99 MB)

Table 1

@usgov.city_of_new_york_street_resurfacing_schedule.table_1

8.99 MB
266133 rows
16 columns

work_schedule_project_location_id Work Schedule Project Location ID	borough_name Borough Name	day Day	date Date	on_street_name On Street Name	from_street_name From Street Name	to_street_name To Street Name	community_board Community Board	area Area	work_type Work Type	crew_type Crew Type	shift_type Shift Type	oftcode OFTCode
254293	BRONX	Friday	Fri Nov 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	SEDGWICK AVENUE	PALISADE PLACE	WEST TREMONT AVENUE	205	University Heights-Morris Heights	PAVING	IN-HOUSE CREW	NIGHT SHIFT	263820256740276850
254034	BRONX	Thursday	Thu Oct 31 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	SEDGWICK AVENUE	PALISADE PLACE	WEST TREMONT AVENUE	205	University Heights-Morris Heights	PAVING	IN-HOUSE CREW	NIGHT SHIFT	263820256740276850
254030	BRONX	Thursday	Thu Oct 31 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	SEDGWICK AVENUE	UNDERCLIFF AVENUE		205		PAVING	IN-HOUSE CREW	NIGHT SHIFT	263820270220000000
254289	BRONX	Friday	Fri Nov 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	SEDGWICK AVENUE	UNDERCLIFF AVENUE		205		PAVING	IN-HOUSE CREW	NIGHT SHIFT	263820270220000000
254029	BRONX	Thursday	Thu Oct 31 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	HALL OF FAME TERRACE	SEDGWICK AVENUE		205		PAVING	IN-HOUSE CREW	NIGHT SHIFT	237640263820000000
254288	BRONX	Friday	Fri Nov 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	HALL OF FAME TERRACE	SEDGWICK AVENUE		205		PAVING	IN-HOUSE CREW	NIGHT SHIFT	237640263820000000
254294	BRONX	Friday	Fri Nov 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	PALISADE PLACE	SEDGWICK AVENUE		205		PAVING	IN-HOUSE CREW	NIGHT SHIFT	256740263820000000
254035	BRONX	Thursday	Thu Oct 31 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	PALISADE PLACE	SEDGWICK AVENUE		205		PAVING	IN-HOUSE CREW	NIGHT SHIFT	256740263820000000
254031	BRONX	Thursday	Thu Oct 31 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	SEDGWICK AVENUE	WEST 183 STREET		207		PAVING	IN-HOUSE CREW	NIGHT SHIFT	263820274690000000
254290	BRONX	Friday	Fri Nov 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	SEDGWICK AVENUE	WEST 183 STREET		207		PAVING	IN-HOUSE CREW	NIGHT SHIFT	263820274690000000


CREATE TABLE table_1 (
  "work_schedule_project_location_id" BIGINT,
  "borough_name" VARCHAR,
  "day" VARCHAR,
  "date" TIMESTAMP,
  "on_street_name" VARCHAR,
  "from_street_name" VARCHAR,
  "to_street_name" VARCHAR,
  "community_board" DOUBLE,
  "area" VARCHAR,
  "work_type" VARCHAR,
  "crew_type" VARCHAR,
  "shift_type" VARCHAR,
  "oftcode" VARCHAR,
  "location_segment_id" DOUBLE,
  "location_wkt" VARCHAR,
  "location_node_id" VARCHAR
);