Basketball Court Points

City of Seattle

@usgov.city_of_seattle_basketball_court_points

Table List

1 table(24.15 KB)

Table 1

@usgov.city_of_seattle_basketball_court_points.table_1

24.15 KB
66 rows
23 columns

objectid OBJECTID	park_name Park Name	address ADDRESS	type TYPE	number_of_courts Number Of Courts	regulation_size Regulation Size	point_x POINT X	point_y POINT Y	gis_edt_dt GIS EDT DT	latitude LATITUDE	longitude LONGITUDE	pmaid PMAid	location_id Location Id	globalid GLOBALID	gis_creator GIS CREATOR	gis_crt_dt GIS CRT DT	gis_editor GIS EDITOR	spatial_data_quality_level Spatial Data Quality Level	x X	y Y
5574	University Heights	5001 University Way NE	Half	1				4/29/2025 9:52:07 PM			4471		65664e85-daf7-469d-9257-4c0dd0326abc	SeattleParks_SeattleCityGIS	4/29/2025 9:52:07 PM	SeattleParks_SeattleCityGIS	QL-D3	1275719.92405587	246096.422139019
5575	Delridge Playfield	4458 Delridge Way SW	Full	1		1262704.08389939	208512.73398483	4/29/2025 9:52:07 PM	47.56133484	-122.36326061	450		9c04f3f4-f5d6-4fae-b16c-9dac875e409c	SeattleParks_SeattleCityGIS	4/29/2025 9:52:07 PM	SeattleParks_SeattleCityGIS	QL-D3	1262704.08389939	208512.733984828
5576	Ella Bailey Park	2601 W Smith St	Half	2				4/29/2025 9:52:07 PM			318	1311	80679895-154a-43e0-9adf-7db2b0e0ab2a	SeattleParks_SeattleCityGIS	4/29/2025 9:52:07 PM	SeattleParks_SeattleCityGIS	QL-D3	1256330.73597114	237424.220609143
5577	Ravenna-Eckstein Park	6535 Ravenna Ave NE	Full	1		1278013.16082922	250184.10665852	4/29/2025 9:52:07 PM	47.67637302	-122.30449281	488		166450f8-2d50-4f3c-a517-af53fd994b17	SeattleParks_SeattleCityGIS	4/29/2025 9:52:07 PM	SeattleParks_SeattleCityGIS	QL-D3	1278013.16082922	250184.106658518
5578	Green Lake Park	7201 East Green Lake Dr N	Both	2		1272215.36414114	251623.44279441	4/29/2025 9:52:07 PM	47.68001193	-122.32813629	307		fa06c767-0c29-4fd7-9089-824e56534a5d	SeattleParks_SeattleCityGIS	4/29/2025 9:52:07 PM	SeattleParks_SeattleCityGIS	QL-D3	1272215.36414114	251623.442794412
5579	South Park Playground	8319 8th Ave S	Both	3				4/29/2025 9:52:07 PM			467	1177	1c92e2b1-56a1-47d3-bb5f-6666eda1eca5	SeattleParks_SeattleCityGIS	4/29/2025 9:52:07 PM	SeattleParks_SeattleCityGIS	QL-D3	1271840.34923764	196324.114646658
5580	Flo Ware Park	28th Ave S/S Jackson St	Half	1		1279573.60027243	222169.025786	4/29/2025 9:52:07 PM	47.59966552	-122.29599856	363		10f577fd-0003-48a9-9e75-532eecf3a189	SeattleParks_SeattleCityGIS	4/29/2025 9:52:07 PM	SeattleParks_SeattleCityGIS	QL-D3	1279573.60027243	222169.025785998
5581	Kerry Park and Viewpoint	211 W Highland Dr	Half	1		1264064.76043192	233193.02603531	4/29/2025 9:52:07 PM	47.62905635	-122.35973318	342		b68537ca-9c0b-4b0f-a0ad-3d6b65528a2d	SeattleParks_SeattleCityGIS	4/29/2025 9:52:07 PM	SeattleParks_SeattleCityGIS	QL-D3	1264064.76043192	233193.026035309
5582	Rainier Playfield	3700 S Alaska St	Full	2	HS	1281759.93159972	208551.46491008	4/29/2025 9:52:07 PM	47.56245332	-122.28609656	423		152f6187-ea6d-415d-8f41-1d5d6755d206	SeattleParks_SeattleCityGIS	4/29/2025 9:52:07 PM	SeattleParks_SeattleCityGIS	QL-D3	1281759.93159972	208551.464910075
5583	Virgil Flaim Park	2700 NE 123rd St	Half	2				4/29/2025 9:52:07 PM			4002	1668	1122a6a0-8542-4b76-9890-f1e13817effe	SeattleParks_SeattleCityGIS	4/29/2025 9:52:07 PM	SeattleParks_SeattleCityGIS	QL-D3	1279659.15643987	265393.55105634


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "park_name" VARCHAR,
  "address" VARCHAR,
  "type" VARCHAR,
  "number_of_courts" BIGINT,
  "regulation_size" VARCHAR,
  "point_x" DOUBLE,
  "point_y" DOUBLE,
  "gis_edt_dt" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "pmaid" BIGINT,
  "location_id" DOUBLE,
  "amwo_id" VARCHAR,
  "res1" VARCHAR,
  "res2" VARCHAR,
  "globalid" VARCHAR,
  "gis_creator" VARCHAR,
  "gis_crt_dt" VARCHAR,
  "gis_editor" VARCHAR,
  "spatial_data_quality_level" VARCHAR,
  "x" DOUBLE,
  "y" DOUBLE
);