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

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

14 rows where COUNTY = 10 and MNG_AGENCY = 644

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
3533	3533	3532	{"type": "Polygon", "coordinates": [[[-117.2507, 33.68241], [-117.25037, 33.68251], [-117.2504, 33.68248], [-117.2504, 33.68243], [-117.25019, 33.68189], [-117.25016, 33.68186], [-117.25011, 33.68184], [-117.2503, 33.68184], [-117.25047, 33.68182], [-117.2507, 33.68241]]]}	Open Access 1	28098	Lions Parkq	21326	1458	Canyon Lake, City of 656	City 2	City Agency 2	http://www.cityofcanyonlake.com/	City 2	1458	Canyon Lake, City of 644	City 2	City Agency 2	Riverside 10	0.491	Lions Parkq		None 294
10668	10668	10667	{"type": "Polygon", "coordinates": [[[-117.23963, 33.6837], [-117.23957, 33.68378], [-117.23877, 33.68337], [-117.23896, 33.68324], [-117.23951, 33.68351], [-117.23963, 33.6837]]]}	Open Access 1	27033	Lucky Cove Park	21582	1458	Canyon Lake, City of 656	City 2	City Agency 2	http://www.cityofcanyonlake.com/	City 2	1458	Canyon Lake, City of 644	City 2	City Agency 2	Riverside 10	0.432	Lucky Cove Park	0	Local Park 2	4
12128	12128	12127	{"type": "Polygon", "coordinates": [[[-117.26196, 33.68293], [-117.26182, 33.68298], [-117.26168, 33.68267], [-117.2614, 33.68249], [-117.26143, 33.6822], [-117.26154, 33.68204], [-117.26162, 33.68207], [-117.26161, 33.68232], [-117.26182, 33.68263], [-117.26196, 33.68293]]]}	Open Access 1	25092	Diamond Point Park	18148	1458	Canyon Lake, City of 656	City 2	City Agency 2	http://www.cityofcanyonlake.com/	City 2	1458	Canyon Lake, City of 644	City 2	City Agency 2	Riverside 10	0.46	Diamond Point Park	0	Local Park 2	4
12129	12129	12128	{"type": "Polygon", "coordinates": [[[-117.26052, 33.67978], [-117.26043, 33.67985], [-117.26036, 33.67993], [-117.26032, 33.68004], [-117.26033, 33.68015], [-117.25993, 33.67977], [-117.26008, 33.67963], [-117.26018, 33.67956], [-117.2603, 33.6795], [-117.26047, 33.67946], [-117.26052, 33.67978]]]}	Open Access 1	25093	Emerald Park	18618	1458	Canyon Lake, City of 656	City 2	City Agency 2	http://www.cityofcanyonlake.com/	City 2	1458	Canyon Lake, City of 644	City 2	City Agency 2	Riverside 10	0.533	Emerald Park	0	Local Park 2	4
12130	12130	12129	{"type": "Polygon", "coordinates": [[[-117.24873, 33.68638], [-117.2485, 33.68644], [-117.24818, 33.68657], [-117.24804, 33.68685], [-117.24805, 33.68707], [-117.24841, 33.68707], [-117.24841, 33.68713], [-117.24805, 33.68714], [-117.24806, 33.68804], [-117.24786, 33.68805], [-117.24785, 33.68777], [-117.24738, 33.68777], [-117.24738, 33.68776], [-117.24755, 33.68771], [-117.24773, 33.6876], [-117.24782, 33.68731], [-117.24776, 33.68715], [-117.24775, 33.68698], [-117.24771, 33.68677], [-117.2475, 33.68652], [-117.24733, 33.68645], [-117.24758, 33.68644], [-117.24759, 33.68616], [-117.24786, 33.68616], [-117.24787, 33.68642], [-117.24836, 33.68641], [-117.24871, 33.68635], [-117.24873, 33.68638]]]}	Open Access 1	25094	Evans Park	18757	1458	Canyon Lake, City of 656	City 2	City Agency 2	http://www.cityofcanyonlake.com/	City 2	1458	Canyon Lake, City of 644	City 2	City Agency 2	Riverside 10	1.843	Evans Park	0	Local Park 2	4
12131	12131	12130	{"type": "Polygon", "coordinates": [[[-117.27974, 33.68355], [-117.27956, 33.68368], [-117.27935, 33.68379], [-117.27912, 33.68385], [-117.27887, 33.68388], [-117.27887, 33.68355], [-117.27897, 33.68358], [-117.27903, 33.68367], [-117.27908, 33.68371], [-117.27915, 33.68371], [-117.27927, 33.68368], [-117.2794, 33.68362], [-117.27944, 33.68358], [-117.27945, 33.68353], [-117.27941, 33.68341], [-117.27945, 33.68333], [-117.27974, 33.68355]]]}	Open Access 1	25096	Harrelson Memorial Park	19691	1458	Canyon Lake, City of 656	City 2	City Agency 2	http://www.cityofcanyonlake.com/	City 2	1458	Canyon Lake, City of 644	City 2	City Agency 2	Riverside 10	0.436	Harrelson Memorial Park	0	Local Park 2	4
12132	12132	12131	{"type": "Polygon", "coordinates": [[[-117.27246, 33.68009], [-117.27226, 33.68039], [-117.27216, 33.68043], [-117.27206, 33.6805], [-117.27199, 33.68063], [-117.27169, 33.68088], [-117.27061, 33.68125], [-117.27053, 33.68108], [-117.27059, 33.68099], [-117.2705, 33.68063], [-117.27076, 33.68054], [-117.27096, 33.68042], [-117.27189, 33.67963], [-117.27246, 33.68009]]]}	Open Access 1	25097	Holiday Harbor Park	20029	1458	Canyon Lake, City of 656	City 2	City Agency 2	http://www.cityofcanyonlake.com/	City 2	1458	Canyon Lake, City of 644	City 2	City Agency 2	Riverside 10	3.725	Holiday Harbor Park	0	Local Park 2	4
12133	12133	12132	{"type": "Polygon", "coordinates": [[[-117.27024, 33.69265], [-117.26998, 33.69287], [-117.26996, 33.69296], [-117.26979, 33.69296], [-117.26961, 33.69301], [-117.26926, 33.69304], [-117.26911, 33.69293], [-117.26907, 33.69276], [-117.26941, 33.69276], [-117.26948, 33.69274], [-117.26953, 33.69271], [-117.26991, 33.69285], [-117.2702, 33.69262], [-117.27024, 33.69265]]]}	Open Access 1	25098	Moonstone Beach Park	22455	1458	Canyon Lake, City of 656	City 2	City Agency 2	http://www.cityofcanyonlake.com/	City 2	1458	Canyon Lake, City of 644	City 2	City Agency 2	Riverside 10	0.554	Moonstone Beach Park	0	Local Park 2	4
12134	12134	12133	{"type": "Polygon", "coordinates": [[[-117.25878, 33.6802], [-117.25875, 33.68026], [-117.25747, 33.68018], [-117.25756, 33.67992], [-117.25878, 33.6802]]]}	Open Access 1	25102	Roadrunner Park	24476	1458	Canyon Lake, City of 656	City 2	City Agency 2	http://www.cityofcanyonlake.com/	City 2	1458	Canyon Lake, City of 644	City 2	City Agency 2	Riverside 10	0.53	Roadrunner Park	0	Local Park 2	4
12135	12135	12134	{"type": "Polygon", "coordinates": [[[-117.26123, 33.69434], [-117.26082, 33.69493], [-117.26031, 33.6952], [-117.26015, 33.69499], [-117.26046, 33.6948], [-117.26015, 33.69424], [-117.2601, 33.69344], [-117.25971, 33.69336], [-117.25975, 33.6932], [-117.25984, 33.69299], [-117.26017, 33.6931], [-117.26066, 33.6931], [-117.26082, 33.69322], [-117.26084, 33.69375], [-117.26123, 33.69434]]]}	Open Access 1	25103	Sierra Park	25464	1458	Canyon Lake, City of 656	City 2	City Agency 2	http://www.cityofcanyonlake.com/	City 2	1458	Canyon Lake, City of 644	City 2	City Agency 2	Riverside 10	4.107	Sierra Park	0	Local Park 2	4
12136	12136	12135	{"type": "Polygon", "coordinates": [[[-117.24702, 33.68479], [-117.24699, 33.68481], [-117.24677, 33.68451], [-117.24585, 33.68496], [-117.24564, 33.68524], [-117.24564, 33.68547], [-117.24558, 33.68549], [-117.24558, 33.68525], [-117.24581, 33.68471], [-117.24585, 33.68456], [-117.24544, 33.68447], [-117.24546, 33.68442], [-117.24586, 33.68449], [-117.24594, 33.68438], [-117.24603, 33.68439], [-117.24664, 33.68425], [-117.24702, 33.68479]]]}	Open Access 1	25104	Steelhead Park	25822	1458	Canyon Lake, City of 656	City 2	City Agency 2	http://www.cityofcanyonlake.com/	City 2	1458	Canyon Lake, City of 644	City 2	City Agency 2	Riverside 10	1.204	Steelhead Park	0	Local Park 2	4
12426	12426	12425	{"type": "Polygon", "coordinates": [[[-117.23703, 33.68023], [-117.23632, 33.68105], [-117.23607, 33.68093], [-117.23578, 33.68084], [-117.23547, 33.68078], [-117.23511, 33.68076], [-117.23507, 33.68072], [-117.23508, 33.68013], [-117.23577, 33.68015], [-117.23599, 33.68005], [-117.23607, 33.68008], [-117.23659, 33.68008], [-117.2368, 33.68012], [-117.23703, 33.68023]]]}	Open Access 1	27032	Eastport Park	18396	1458	Canyon Lake, City of 656	City 2	City Agency 2	http://www.cityofcanyonlake.com/	City 2	1458	Canyon Lake, City of 644	City 2	City Agency 2	Riverside 10	3.262	Eastport Park	0	Local Park 2	4
12428	12428	12427	{"type": "Polygon", "coordinates": [[[-117.24218, 33.68765], [-117.24215, 33.68828], [-117.24216, 33.68829], [-117.24184, 33.68862], [-117.24108, 33.68863], [-117.24142, 33.68853], [-117.24151, 33.68826], [-117.24162, 33.68811], [-117.24158, 33.68792], [-117.24155, 33.68791], [-117.24156, 33.68789], [-117.24183, 33.68792], [-117.24186, 33.68764], [-117.24218, 33.68765]]]}	Open Access 1	27034	Outrigger Park	23269	1458	Canyon Lake, City of 656	City 2	City Agency 2	http://www.cityofcanyonlake.com/	City 2	1458	Canyon Lake, City of 644	City 2	City Agency 2	Riverside 10	1.285	Outrigger Park	0	Local Park 2	4
12429	12429	12428	{"type": "Polygon", "coordinates": [[[-117.25122, 33.67854], [-117.25116, 33.67892], [-117.25092, 33.67904], [-117.25051, 33.67885], [-117.25045, 33.67863], [-117.25015, 33.67867], [-117.25032, 33.67802], [-117.25098, 33.67774], [-117.25102, 33.6778], [-117.25104, 33.6779], [-117.25104, 33.67812], [-117.25122, 33.67854]]]}	Open Access 1	27036	Indian Beach Park	20198	1458	Canyon Lake, City of 656	City 2	City Agency 2	http://www.cityofcanyonlake.com/	City 2	1458	Canyon Lake, City of 644	City 2	City Agency 2	Riverside 10	2.249	Indian Beach 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]);