calands: units_with_maps: 14 rows where COUNTY = 15 and MNG

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

14 rows where COUNTY = 15 and MNG_AGENCY = 217

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
608	608	607	{"type": "Polygon", "coordinates": [[[-122.16052, 37.46073], [-122.15992, 37.46148], [-122.15819, 37.46088], [-122.15834, 37.46016], [-122.15964, 37.46033], [-122.15972, 37.46057], [-122.16052, 37.46073]]]}	Open Access 1	2123	Willow Oaks Park	27581	1202	Menlo Park, City of 221	City 2	City Agency 2	http://www.menlopark.org/	City 2	1202	Menlo Park, City of 217	City 2	City Agency 2	San Mateo 15	4.256	Willow Oaks Park	1940	Local Park 2	4
743	743	742	{"type": "Polygon", "coordinates": [[[-122.17782, 37.45219], [-122.17654, 37.45387], [-122.1743, 37.4528], [-122.17577, 37.45096], [-122.17782, 37.45219]]]}	Open Access 1	4790	Burgess Park	16518	1202	Menlo Park, City of 221	City 2	City Agency 2	http://www.menlopark.org/	City 2	1202	Menlo Park, City of 217	City 2	City Agency 2	San Mateo 15	13.014	Burgess Park	1947	Local Park 2	4
1865	1865	1864	{"type": "Polygon", "coordinates": [[[-122.18669, 37.44885], [-122.18632, 37.44929], [-122.18592, 37.44908], [-122.18628, 37.44864], [-122.18669, 37.44885]]]}	Open Access 1	14291	Fremont Park	19099	1202	Menlo Park, City of 221	City 2	City Agency 2	http://www.menlopark.org/	City 2	1202	Menlo Park, City of 217	City 2	City Agency 2	San Mateo 15	0.623	Fremont Park	2000	Local Park 2	4
2668	2668	2667	{"type": "Polygon", "coordinates": [[[-122.18195, 37.44777], [-122.18079, 37.44915], [-122.17918, 37.44823], [-122.18028, 37.44688], [-122.18195, 37.44777]]]}	Open Access 1	18188	Nealon Park	22679	1202	Menlo Park, City of 221	City 2	City Agency 2	http://www.menlopark.org/	City 2	1202	Menlo Park, City of 217	City 2	City Agency 2	San Mateo 15	7.884	Nealon Park	1961	Local Park 2	4
5331	5331	5330	{"type": "Polygon", "coordinates": [[[-122.19589, 37.44038], [-122.19554, 37.4408], [-122.19566, 37.44089], [-122.19538, 37.44122], [-122.19395, 37.44046], [-122.19438, 37.43994], [-122.19478, 37.44014], [-122.19494, 37.43998], [-122.19508, 37.44008], [-122.1953, 37.44011], [-122.19589, 37.44038]]]}	Open Access 1	15566	Tinkers Park	26373	1202	Menlo Park, City of 221	City 2	City Agency 2	http://www.menlopark.org/	City 2	1202	Menlo Park, City of 217	City 2	City Agency 2	San Mateo 15	3.227	Tinkers Park	1961	Local Park 2	4
6016	6016	6015	{"type": "Polygon", "coordinates": [[[-122.21219, 37.43296], [-122.21168, 37.433], [-122.21126, 37.43301], [-122.2108, 37.43298], [-122.21028, 37.43286], [-122.20983, 37.43272], [-122.2094, 37.43252], [-122.20901, 37.43238], [-122.20853, 37.43223], [-122.20811, 37.43215], [-122.20783, 37.43243], [-122.20732, 37.43216], [-122.20858, 37.43058], [-122.20888, 37.43058], [-122.20903, 37.43073], [-122.20908, 37.43093], [-122.20928, 37.4311], [-122.20954, 37.43115], [-122.21018, 37.43117], [-122.21054, 37.4312], [-122.21098, 37.43195], [-122.21106, 37.43249], [-122.21159, 37.43261], [-122.21201, 37.4326], [-122.21219, 37.43296]]]}	Open Access 1	695	Sharon Hill Park	25362	1202	Menlo Park, City of 221	City 2	City Agency 2	http://www.menlopark.org/	City 2	1202	Menlo Park, City of 217	City 2	City Agency 2	San Mateo 15	12.961	Sharon Hill Park	1973	Local Park 2	4
6018	6018	6017	{"type": "Polygon", "coordinates": [[[-122.21204, 37.42373], [-122.21157, 37.42448], [-122.2106, 37.4243], [-122.20834, 37.42439], [-122.20823, 37.4236], [-122.20844, 37.42337], [-122.20979, 37.42308], [-122.21204, 37.42373]]]}	Open Access 1	700	Sharon Park	25363	1202	Menlo Park, City of 221	City 2	City Agency 2	http://www.menlopark.org/	City 2	1202	Menlo Park, City of 217	City 2	City Agency 2	San Mateo 15	9.023	Sharon Park	1961	Local Park 2	4
8786	8786	8785	{"type": "Polygon", "coordinates": [[[-122.17165, 37.4789], [-122.16783, 37.47916], [-122.16777, 37.47856], [-122.16808, 37.47859], [-122.16966, 37.47849], [-122.16984, 37.47853], [-122.16994, 37.47849], [-122.16996, 37.47845], [-122.16996, 37.4784], [-122.16991, 37.47833], [-122.16983, 37.47831], [-122.16808, 37.47843], [-122.16791, 37.47842], [-122.16772, 37.47838], [-122.16789, 37.47815], [-122.16789, 37.47811], [-122.16977, 37.47798], [-122.16976, 37.47779], [-122.17165, 37.4789]]]}	Open Access 1	14290	Kelly Park	20588	1202	Menlo Park, City of 221	City 2	City Agency 2	http://www.menlopark.org/	City 2	1202	Menlo Park, City of 217	City 2	City Agency 2	San Mateo 15	6.931	Kelly Park	1961	Local Park 2	4
9329	9329	9328	{"type": "Polygon", "coordinates": [[[-122.18424, 37.44468], [-122.18381, 37.44519], [-122.18236, 37.44442], [-122.18279, 37.44391], [-122.18424, 37.44468]]]}	Open Access 1	15558	Jack W. Lyle Park	20313	1202	Menlo Park, City of 221	City 2	City Agency 2	http://www.menlopark.org/	City 2	1202	Menlo Park, City of 217	City 2	City Agency 2	San Mateo 15	2.626	Jack W. Lyle Park	1961	Local Park 2	4
9330	9330	9329	{"type": "MultiPolygon", "coordinates": [[[[-122.16628, 37.47667], [-122.16608, 37.47688], [-122.16602, 37.47689], [-122.1655, 37.47659], [-122.16567, 37.47641], [-122.16575, 37.4764], [-122.16598, 37.47653], [-122.166, 37.47651], [-122.16628, 37.47667]]], [[[-122.16607, 37.47699], [-122.16585, 37.47723], [-122.16582, 37.47712], [-122.16563, 37.47701], [-122.16576, 37.47686], [-122.16583, 37.47685], [-122.16607, 37.47699]]]]}	Open Access 1	15560	Marketplace Park	21872	1202	Menlo Park, City of 221	City 2	City Agency 2	http://www.menlopark.org/	City 2	1202	Menlo Park, City of 217	City 2	City Agency 2	San Mateo 15	0.67	Marketplace Park	1961	Local Park 2	4
9331	9331	9330	{"type": "Polygon", "coordinates": [[[-122.16632, 37.45965], [-122.16591, 37.45985], [-122.16583, 37.45981], [-122.1657, 37.45978], [-122.16499, 37.45985], [-122.1649, 37.45987], [-122.16476, 37.45983], [-122.16514, 37.45907], [-122.16626, 37.45942], [-122.16632, 37.45965]]]}	Open Access 1	15562	Seminary Oaks Park	25295	1202	Menlo Park, City of 221	City 2	City Agency 2	http://www.menlopark.org/	City 2	1202	Menlo Park, City of 217	City 2	City Agency 2	San Mateo 15	1.897	Seminary Oaks Park	1954	Local Park 2	4
9335	9335	9334	{"type": "Polygon", "coordinates": [[[-122.1983, 37.42177], [-122.19813, 37.42169], [-122.19708, 37.42144], [-122.19716, 37.42104], [-122.1972, 37.42101], [-122.19752, 37.42095], [-122.19785, 37.42085], [-122.1979, 37.42086], [-122.19796, 37.42094], [-122.19809, 37.4212], [-122.1983, 37.42177]]]}	Open Access 1	15564	Stanford Hills Park	25787	1202	Menlo Park, City of 221	City 2	City Agency 2	http://www.menlopark.org/	City 2	1202	Menlo Park, City of 217	City 2	City Agency 2	San Mateo 15	1.539	Stanford Hills Park	1974	Local Park 2	4
10334	10334	10333	{"type": "Polygon", "coordinates": [[[-122.17823, 37.48677], [-122.17738, 37.48711], [-122.17698, 37.48771], [-122.17733, 37.48884], [-122.1774, 37.49166], [-122.1775, 37.49167], [-122.17748, 37.49466], [-122.17381, 37.49463], [-122.17379, 37.49574], [-122.1774, 37.49797], [-122.1774, 37.49812], [-122.17709, 37.4979], [-122.1766, 37.49763], [-122.17462, 37.49633], [-122.17407, 37.49623], [-122.17392, 37.49638], [-122.17378, 37.49641], [-122.17369, 37.4961], [-122.17249, 37.49594], [-122.17117, 37.4957], [-122.16995, 37.49561], [-122.16809, 37.49593], [-122.16804, 37.49271], [-122.16804, 37.48937], [-122.17384, 37.48938], [-122.17388, 37.48676], [-122.17823, 37.48677]]]}	Open Access 1	18224	Bayfront Park Recreation Area	15887	1202	Menlo Park, City of 221	City 2	City Agency 2	http://www.menlopark.org/	City 2	1202	Menlo Park, City of 217	City 2	City Agency 2	San Mateo 15	159.558	Bayfront Park Rec. Area	1981	Local Recreation Area 3	4
14263	14263	14262	{"type": "Polygon", "coordinates": [[[-122.15988, 37.47944], [-122.15936, 37.47948], [-122.15931, 37.47894], [-122.1598, 37.47876], [-122.15988, 37.47944]]]}	Open Access 1	44183	Hamilton Park	19619	1202	Menlo Park, City of 221	City 2	City Agency 2	http://www.menlopark.org/	City 2	1202	Menlo Park, City of 217	City 2	City Agency 2	San Mateo 15	0.765	Hamilton Park	0	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]);