calands: units_with_maps: 13 rows where ACCESS_TYP = 1, AGNCY_NAME = 373 and DES

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

13 rows where ACCESS_TYP = 1, AGNCY_NAME = 373 and DES_TP = 2

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	DES_TP	GAP_STS
1481	1481	1480	{"type": "Polygon", "coordinates": [[[-122.46756, 38.28916], [-122.46746, 38.29018], [-122.46741, 38.29045], [-122.46743, 38.29049], [-122.4674, 38.2906], [-122.46684, 38.29058], [-122.46677, 38.29073], [-122.46652, 38.29072], [-122.46649, 38.29089], [-122.46596, 38.29083], [-122.4661, 38.2899], [-122.46622, 38.2899], [-122.46635, 38.28903], [-122.46756, 38.28916]]]}	Open Access 1	10169	Eraldi Park	18692	1338	Sonoma, City of 373	City 2	City Agency 2	http://www.sonomacity.org/	City 2	1338	Sonoma, City of 368	City 2	City Agency 2	Sonoma 16	5.179	Eraldi Park	Local Park 2	4
3535	3535	3534	{"type": "Polygon", "coordinates": [[[-122.44112, 38.28032], [-122.44096, 38.28136], [-122.43854, 38.28113], [-122.43869, 38.28008], [-122.44112, 38.28032]]]}	Open Access 1	28218	Sonoma Garden Park	25611	1338	Sonoma, City of 373	City 2	City Agency 2	http://www.sonomacity.org/	City 2	1338	Sonoma, City of 368	City 2	City Agency 2	Sonoma 16	6.173	Sonoma Garden Park	Local Park 2	4
3811	3811	3810	{"type": "Polygon", "coordinates": [[[-122.46979, 38.29855], [-122.46968, 38.29918], [-122.46947, 38.29916], [-122.46943, 38.29938], [-122.46936, 38.29938], [-122.46939, 38.29915], [-122.46885, 38.29909], [-122.46885, 38.29895], [-122.46881, 38.29885], [-122.46889, 38.29885], [-122.46895, 38.2985], [-122.46979, 38.29855]]]}	Open Access 1	10145	Olsen Park	23138	1338	Sonoma, City of 373	City 2	City Agency 2	http://www.sonomacity.org/	City 2	1338	Sonoma, City of 368	City 2	City Agency 2	Sonoma 16	1.303	Olsen Park	Local Park 2	4
4512	4512	4511	{"type": "Polygon", "coordinates": [[[-122.45886, 38.29215], [-122.45854, 38.29374], [-122.4565, 38.29353], [-122.45686, 38.29192], [-122.45886, 38.29215]]]}	Open Access 1	10157	The Plaza	26291	1338	Sonoma, City of 373	City 2	City Agency 2	http://www.sonomacity.org/	City 2	1338	Sonoma, City of 368	City 2	City Agency 2	Sonoma 16	7.947	The Plaza	Local Park 2	4
7855	7855	7854	{"type": "Polygon", "coordinates": [[[-122.45045, 38.28734], [-122.45043, 38.28747], [-122.45007, 38.28744], [-122.44989, 38.28741], [-122.44968, 38.28734], [-122.44972, 38.28703], [-122.45015, 38.28707], [-122.45011, 38.28731], [-122.45045, 38.28734]]]}	Open Access 1	10259	Pinelli Park	23689	1338	Sonoma, City of 373	City 2	City Agency 2	http://www.sonomacity.org/	City 2	1338	Sonoma, City of 368	City 2	City Agency 2	Sonoma 16	0.466	Pinelli Park	Local Park 2	4
7902	7902	7901	{"type": "MultiPolygon", "coordinates": [[[[-122.46731, 38.28258], [-122.46729, 38.28272], [-122.46688, 38.28263], [-122.4668, 38.28253], [-122.46731, 38.28258]]], [[[-122.46815, 38.28261], [-122.4681, 38.28322], [-122.46768, 38.28297], [-122.46743, 38.2829], [-122.46745, 38.28256], [-122.46815, 38.28261]]]]}	Open Access 1	10182	Hertenstein Park	19880	1338	Sonoma, City of 373	City 2	City Agency 2	http://www.sonomacity.org/	City 2	1338	Sonoma, City of 368	City 2	City Agency 2	Sonoma 16	0.882	Hertenstein Park	Local Park 2	4
7903	7903	7902	{"type": "Polygon", "coordinates": [[[-122.46604, 38.27643], [-122.4658, 38.27801], [-122.4656, 38.278], [-122.46521, 38.28026], [-122.46506, 38.28023], [-122.46549, 38.27776], [-122.46543, 38.27757], [-122.4653, 38.27734], [-122.46509, 38.27716], [-122.465, 38.27703], [-122.46493, 38.27683], [-122.46496, 38.27635], [-122.46604, 38.27643]]]}	Open Access 1	10194	Madera Park	21653	1338	Sonoma, City of 373	City 2	City Agency 2	http://www.sonomacity.org/	City 2	1338	Sonoma, City of 368	City 2	City Agency 2	Sonoma 16	3.699	Madera Park	Local Park 2	4
7904	7904	7903	{"type": "MultiPolygon", "coordinates": [[[[-122.46512, 38.27988], [-122.4651, 38.27996], [-122.46449, 38.27991], [-122.46435, 38.28012], [-122.46401, 38.28075], [-122.4642, 38.28083], [-122.46441, 38.28083], [-122.46445, 38.28084], [-122.46439, 38.28094], [-122.46407, 38.28083], [-122.46367, 38.2815], [-122.46336, 38.28146], [-122.46331, 38.28144], [-122.4633, 38.2814], [-122.46342, 38.28096], [-122.46343, 38.2808], [-122.4634, 38.28064], [-122.46358, 38.28062], [-122.46366, 38.28059], [-122.4637, 38.28053], [-122.46372, 38.2804], [-122.46369, 38.28024], [-122.4637, 38.28008], [-122.46375, 38.27975], [-122.4633, 38.27971], [-122.46328, 38.27978], [-122.46099, 38.27956], [-122.46111, 38.2788], [-122.46147, 38.27877], [-122.46165, 38.27878], [-122.46169, 38.27884], [-122.46182, 38.27896], [-122.46265, 38.27904], [-122.46274, 38.27902], [-122.4628, 38.27897], [-122.46285, 38.27888], [-122.46288, 38.27873], [-122.46282, 38.27867], [-122.46313, 38.2787], [-122.46305, 38.27875], [-122.46304, 38.27883], [-122.46342, 38.27886], [-122.46337, 38.27921], [-122.46365, 38.27923], [-122.46363, 38.27936], [-122.46369, 38.27946], [-122.46376, 38.2795], [-122.46385, 38.27953], [-122.46403, 38.27955], [-122.464, 38.27977], [-122.46512, 38.27988]]], [[[-122.46555, 38.27992], [-122.46554, 38.28], [-122.46551, 38.27999], [-122.46552, 38.27992], [-122.46555, 38.27992]]]]}	Open Access 1	10206	Carter Park	16925	1338	Sonoma, City of 373	City 2	City Agency 2	http://www.sonomacity.org/	City 2	1338	Sonoma, City of 368	City 2	City Agency 2	Sonoma 16	7.493	Carter Park	Local Park 2	4
7905	7905	7904	{"type": "MultiPolygon", "coordinates": [[[[-122.45661, 38.28445], [-122.45568, 38.28434], [-122.45583, 38.28349], [-122.45626, 38.28353], [-122.45613, 38.28365], [-122.45606, 38.28377], [-122.45611, 38.28395], [-122.45638, 38.28416], [-122.45656, 38.28427], [-122.45661, 38.28445]]], [[[-122.45749, 38.27837], [-122.45745, 38.27859], [-122.45693, 38.27902], [-122.45674, 38.279], [-122.4568, 38.27859], [-122.45669, 38.27857], [-122.45662, 38.27854], [-122.45656, 38.27835], [-122.45648, 38.27822], [-122.45624, 38.27799], [-122.45615, 38.27785], [-122.45609, 38.27771], [-122.45596, 38.27661], [-122.45618, 38.27663], [-122.45621, 38.27694], [-122.45632, 38.27727], [-122.45629, 38.27778], [-122.45639, 38.27779], [-122.45652, 38.27791], [-122.45675, 38.27797], [-122.45694, 38.27787], [-122.45713, 38.27789], [-122.45727, 38.27822], [-122.45749, 38.27837]]], [[[-122.45772, 38.28472], [-122.45761, 38.28545], [-122.4572, 38.2854], [-122.45727, 38.285], [-122.4572, 38.28499], [-122.45725, 38.28468], [-122.45772, 38.28472]]]]}	Open Access 1	10218	Nathanson Creek Park	22637	1338	Sonoma, City of 373	City 2	City Agency 2	http://www.sonomacity.org/	City 2	1338	Sonoma, City of 368	City 2	City Agency 2	Sonoma 16	4.455	Nathanson Creek Park	Local Park 2	4
11277	11277	11276	{"type": "Polygon", "coordinates": [[[-122.45816, 38.29594], [-122.45793, 38.29742], [-122.45582, 38.29721], [-122.45611, 38.29535], [-122.45646, 38.29538], [-122.4565, 38.29537], [-122.45788, 38.2955], [-122.45781, 38.2959], [-122.45816, 38.29594]]]}	Open Access 1	23640	Depot Park	18101	1338	Sonoma, City of 373	City 2	City Agency 2	http://www.sonomacity.org/	City 2	1338	Sonoma, City of 368	City 2	City Agency 2	Sonoma 16	9.326	Depot Park	Local Park 2	4
11498	11498	11497	{"type": "Polygon", "coordinates": [[[-122.4605, 38.29716], [-122.4602, 38.29918], [-122.46023, 38.2992], [-122.45789, 38.299], [-122.45816, 38.29724], [-122.45865, 38.29728], [-122.45874, 38.2967], [-122.4605, 38.29716]]]}	Open Access 1	23639	Dog Park	18184	1338	Sonoma, City of 373	City 2	City Agency 2	http://www.sonomacity.org/	City 2	1338	Sonoma, City of 368	City 2	City Agency 2	Sonoma 16	11.769	Dog Park	Local Park 2	4
11557	11557	11556	{"type": "Polygon", "coordinates": [[[-122.44779, 38.2892], [-122.44774, 38.28951], [-122.44713, 38.28945], [-122.44719, 38.28909], [-122.44773, 38.28914], [-122.44777, 38.28916], [-122.44779, 38.2892]]]}	Open Access 1	23645	Armstrong Park	15597	1338	Sonoma, City of 373	City 2	City Agency 2	http://www.sonomacity.org/	City 2	1338	Sonoma, City of 368	City 2	City Agency 2	Sonoma 16	0.539	Armstrong Park	Local Park 2	4
12470	12470	12469	{"type": "Polygon", "coordinates": [[[-122.45612, 38.28936], [-122.45618, 38.28958], [-122.45611, 38.28984], [-122.45603, 38.28983], [-122.45611, 38.28936], [-122.45612, 38.28936]]]}	Open Access 1	28214	Grinstead Park	19520	1338	Sonoma, City of 373	City 2	City Agency 2	http://www.sonomacity.org/	City 2	1338	Sonoma, City of 368	City 2	City Agency 2	Sonoma 16	0.088	Grinstead Park	Local Park 2	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]);