calands: units_with_maps: 6 rows where COUNTY = 36, DES_TP = 3 and MNG_AG

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

6 rows where COUNTY = 36, DES_TP = 3 and MNG_AG_TYP = 4

Search:

descending

This data as json, copyable, CSV (advanced)

Link	rowid ▼	id	map	ACCESS_TYP	UNIT_ID	UNIT_NAME	SUID_NMA	AGNCY_ID	AGNCY_NAME	AGNCY_LEV	AGNCY_TYP	AGNCY_WEB	LAYER	MNG_AG_ID	MNG_AGENCY	MNG_AG_LEV	MNG_AG_TYP	COUNTY	ACRES	LABEL_NAME	YR_EST	DES_TP	GAP_STS
4346	4346	4345	{"type": "Polygon", "coordinates": [[[-119.27012, 35.49626], [-119.27011, 35.49689], [-119.26949, 35.49688], [-119.26949, 35.49626], [-119.27012, 35.49626]]]}	Open Access 1	48440	Skate Park	33145	2149	Shafter Recreation and Park District 436	Special District 4	Recreation/Parks District 4	http://shafterrecreation.com/	Special District 4	2149	Shafter Recreation and Park District 430	Special District 4	Recreation/Parks District 4	Kern 36	0.977	Skate Park	2001	Local Recreation Area 3	4
9185	9185	9184	{"type": "MultiPolygon", "coordinates": [[[[-119.44742, 35.15369], [-119.44736, 35.1537], [-119.44736, 35.15446], [-119.44283, 35.15448], [-119.43856, 35.15446], [-119.43858, 35.15264], [-119.43862, 35.15144], [-119.44741, 35.15143], [-119.44742, 35.15369]]], [[[-119.44785, 35.15654], [-119.44345, 35.15653], [-119.44343, 35.15646], [-119.44238, 35.15646], [-119.44237, 35.15533], [-119.43971, 35.15532], [-119.43971, 35.15463], [-119.44343, 35.15465], [-119.44743, 35.15465], [-119.44743, 35.15505], [-119.44756, 35.15505], [-119.44757, 35.15546], [-119.44763, 35.15584], [-119.44772, 35.1562], [-119.44785, 35.15654]]]]}	Open Access 1	15249	Franklin Field	19058	2178	West Side Recreation and Park District 467	Special District 4	Recreation/Parks District 4	http://www.wsrpd.com/	Special District 4	2178	West Side Recreation and Park District 460	Special District 4	Recreation/Parks District 4	Kern 36	95.954	Franklin Field	0	Local Recreation Area 3	4
9203	9203	9202	{"type": "Polygon", "coordinates": [[[-119.46792, 35.14555], [-119.46787, 35.14565], [-119.46753, 35.1456], [-119.46697, 35.14543], [-119.46709, 35.14517], [-119.46637, 35.14446], [-119.46546, 35.14447], [-119.46546, 35.14411], [-119.4675, 35.14408], [-119.46791, 35.1441], [-119.46789, 35.14418], [-119.46792, 35.14555]]]}	Open Access 1	15283	Taft Community Center and Skate Park	26163	2178	West Side Recreation and Park District 467	Special District 4	Recreation/Parks District 4	http://www.wsrpd.com/	Special District 4	2178	West Side Recreation and Park District 460	Special District 4	Recreation/Parks District 4	Kern 36	5.19	Taft Community Ctr. and Skate Park	0	Local Recreation Area 3	4
12167	12167	12166	{"type": "Polygon", "coordinates": [[[-119.10975, 35.37746], [-119.10975, 35.37803], [-119.10971, 35.37821], [-119.10971, 35.37828], [-119.10974, 35.37835], [-119.10974, 35.37846], [-119.10684, 35.37845], [-119.10682, 35.37976], [-119.10631, 35.37976], [-119.10632, 35.37746], [-119.10975, 35.37746]]]}	Open Access 1	25360	Greenacres Community Center	19470	2096	North of the River Recreation and Park District 386	Special District 4	Recreation/Parks District 4	http://norfun.org/	Special District 4	2096	North of the River Recreation and Park District 382	Special District 4	Recreation/Parks District 4	Kern 36	10.147	Greenacres Community Ctr.	0	Local Recreation Area 3	4
12574	12574	12573	{"type": "Polygon", "coordinates": [[[-119.33565, 35.61001], [-119.33563, 35.61241], [-119.33394, 35.61241], [-119.33397, 35.60885], [-119.33445, 35.60886], [-119.33445, 35.61], [-119.33565, 35.61001]]]}	Open Access 1	29318	Annin Ave Soccer Fields	15505	2175	Wasco Recreation and Park District 465	Special District 4	Recreation/Parks District 4	http://www.wascoparks.com/	Special District 4	2175	Wasco Recreation and Park District 458	Special District 4	Recreation/Parks District 4	Kern 36	11.506	Annin Ave Soccer Fields	0	Local Recreation Area 3	4
14414	14414	14413	{"type": "Polygon", "coordinates": [[[-119.01983, 35.40852], [-119.01888, 35.40852], [-119.01887, 35.40797], [-119.01983, 35.40797], [-119.01983, 35.40852]]]}	Open Access 1	44536	Rasmussen Center	24188	2096	North of the River Recreation and Park District 386	Special District 4	Recreation/Parks District 4	http://norfun.org/	Special District 4	2096	North of the River Recreation and Park District 382	Special District 4	Recreation/Parks District 4	Kern 36	1.31	Rasmussen Ctr.	0	Local Recreation Area 3	4

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE units_with_maps(
  id INT,
  map,
  ACCESS_TYP INT,
  UNIT_ID INT,
  UNIT_NAME TEXT,
  SUID_NMA INT,
  AGNCY_ID INT,
  AGNCY_NAME INT,
  AGNCY_LEV INT,
  AGNCY_TYP INT,
  AGNCY_WEB TEXT,
  LAYER INT,
  MNG_AG_ID INT,
  MNG_AGENCY INT,
  MNG_AG_LEV INT,
  MNG_AG_TYP INT,
  PARK_URL TEXT,
  COUNTY INT,
  ACRES REAL,
  LABEL_NAME TEXT,
  YR_EST INT,
  DES_TP INT,
  GAP_STS TEXT,
   FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]),
   FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]),
   FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]),
   FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]),
   FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]),
   FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]),
   FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]),
   FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]),
   FOREIGN KEY([COUNTY]) REFERENCES [COUNTY]([id]),
   FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id])
);
CREATE INDEX [idx_units_with_maps_DES_TP]
    ON [units_with_maps] ([DES_TP]);
CREATE INDEX [idx_units_with_maps_COUNTY]
    ON [units_with_maps] ([COUNTY]);
CREATE INDEX [idx_units_with_maps_MNG_AG_TYP]
    ON [units_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_units_with_maps_MNG_AG_LEV]
    ON [units_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_units_with_maps_MNG_AGENCY]
    ON [units_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_units_with_maps_LAYER]
    ON [units_with_maps] ([LAYER]);
CREATE INDEX [idx_units_with_maps_AGNCY_TYP]
    ON [units_with_maps] ([AGNCY_TYP]);
CREATE INDEX [idx_units_with_maps_AGNCY_LEV]
    ON [units_with_maps] ([AGNCY_LEV]);
CREATE INDEX [idx_units_with_maps_AGNCY_NAME]
    ON [units_with_maps] ([AGNCY_NAME]);
CREATE INDEX [idx_units_with_maps_ACCESS_TYP]
    ON [units_with_maps] ([ACCESS_TYP]);