Football Fields

City of Seattle

@usgov.city_of_seattle_football_fields

Table List

1 table(16.06 KB)

Table 1

@usgov.city_of_seattle_football_fields.table_1

16.06 KB
21 rows
21 columns

objectid OBJECTID	name NAME	address ADDRESS	division DIVISION	football FOOTBALL	overlapping Overlapping	surface Surface	lights Lights	pmaid PMAid	res1 RES1	globalid GLOBALID	gis_creator GIS CREATOR	gis_crt_dt GIS CRT DT	gis_editor GIS EDITOR	gis_edt_dt GIS EDT DT	spatial_data_quality_level Spatial Data Quality Level	x X	y Y
2653	Garfield PF	23rd Ave & E Cherry St	Central	1	Y	Synthetic and Grass	Yes	353	1 Sched	e5b32495-0572-44a8-847f-d5fe306d9e64	SeattleParks_SeattleCityGIS	4/29/2025 9:48:36 PM	SeattleParks_SeattleCityGIS	4/29/2025 9:48:36 PM	QL-D3	1278349.62504746	224842.765651003
2654	Rainier PF	3701 S Oregon St	South	1	Y	Grass	Yes	423	4- Sched	a2f0a7ee-a9cc-475f-b75d-0ad63575a897	SeattleParks_SeattleCityGIS	4/29/2025 9:48:36 PM	SeattleParks_SeattleCityGIS	4/29/2025 9:48:36 PM	QL-D3	1281714.24994659	208223.906243518
2655	SE Athletic Complex	8815 Seward Park Ave S	SSD	1	No	Synthetic	Yes		1- Sched	be012585-1be6-45dc-b589-06d1ad015337	SeattleParks_SeattleCityGIS	4/29/2025 9:48:36 PM	SeattleParks_SeattleCityGIS	4/29/2025 9:48:36 PM	QL-D3	1286341.12726291	194496.315702736
2656	Hiawatha PF	2700 California Ave SW	South	1	Y	Synthetic	Yes	456	2- Sched	61e4c2a6-5fa4-4516-978d-576b909abff7	SeattleParks_SeattleCityGIS	4/29/2025 9:48:36 PM	SeattleParks_SeattleCityGIS	4/29/2025 9:48:36 PM	QL-D3	1257285.06592385	214719.536969572
2657	Garfield HS	400 23rd Ave	SSD	1	N	Synthetic	No		2- Sched	c8a6e66f-bf8c-4127-8fd2-4fbcf698424b	SeattleParks_SeattleCityGIS	4/29/2025 9:48:36 PM	SeattleParks_SeattleCityGIS	4/29/2025 9:48:36 PM	QL-D3	1278492.62498359	224170.234322369
2658	Madison MS	3429 45th Ave SW	SSD	1	N	Grass	No		1- Sched	fa659c5b-ec30-4680-ac4e-632ab94313d9	SeattleParks_SeattleCityGIS	4/29/2025 9:48:36 PM	SeattleParks_SeattleCityGIS	4/29/2025 9:48:36 PM	QL-D3	1255790.25005046	212917.937479883
2659	Soundview PF	1590 NW 90th St	North	1	Y	Grass	No	251	6- Sched	aba272da-b766-462c-9175-eda7739ca0c7	SeattleParks_SeattleCityGIS	4/29/2025 9:48:36 PM	SeattleParks_SeattleCityGIS	4/29/2025 9:48:36 PM	QL-D3	1259808.37498219	257505.203185409
2660	Roosevelt HS	1410 NE 66th St	SSD	1	Y	Synthetic	No		1- Sched	90759ba1-4597-41ca-b954-2a8d7c5524f0	SeattleParks_SeattleCityGIS	4/29/2025 9:48:36 PM	SeattleParks_SeattleCityGIS	4/29/2025 9:48:36 PM	QL-D3	1275565.87502888	250549.093738943
2661	Ballard HS	1418 NW 65th St	SSD	1	Y	Synthetic	No		2- Sched	288bdf9b-e7e3-4f72-a452-7fb365dcd43f	SeattleParks_SeattleCityGIS	4/29/2025 9:48:36 PM	SeattleParks_SeattleCityGIS	4/29/2025 9:48:36 PM	QL-D3	1261097.0555594	250725.140843093
2662	Interbay PF	3027 17th Ave W	Central	1	Y	Grass	Yes	3887	3- Sched	1fa69f27-e42e-484b-83ec-be0cdaaa2803	SeattleParks_SeattleCityGIS	4/29/2025 9:48:36 PM	SeattleParks_SeattleCityGIS	4/29/2025 9:48:36 PM	QL-D3	1259367.79181379	240249.427681342


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "name" VARCHAR,
  "address" VARCHAR,
  "division" VARCHAR,
  "football" BIGINT,
  "overlapping" VARCHAR,
  "surface" VARCHAR,
  "lights" VARCHAR,
  "pmaid" DOUBLE,
  "location_id" VARCHAR,
  "amwo_id" VARCHAR,
  "res1" VARCHAR,
  "res2" VARCHAR,
  "globalid" VARCHAR,
  "gis_creator" VARCHAR,
  "gis_crt_dt" VARCHAR,
  "gis_editor" VARCHAR,
  "gis_edt_dt" VARCHAR,
  "spatial_data_quality_level" VARCHAR,
  "x" DOUBLE,
  "y" DOUBLE
);