calands: units_with_maps: 6 rows where COUNTY = 35 and MNG

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

6 rows where COUNTY = 35 and MNG_AGENCY = 658

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	PARK_URL	COUNTY	ACRES	LABEL_NAME	YR_EST	DES_TP	GAP_STS
3662	3662	3661	{"type": "Polygon", "coordinates": [[[-120.12232, 39.1832], [-120.12208, 39.18354], [-120.12208, 39.18367], [-120.11972, 39.18367], [-120.11988, 39.18121], [-120.12025, 39.18139], [-120.12032, 39.1818], [-120.12053, 39.18185], [-120.12046, 39.18195], [-120.12103, 39.1821], [-120.12119, 39.18228], [-120.12117, 39.18246], [-120.12131, 39.18265], [-120.12207, 39.18255], [-120.12231, 39.18258], [-120.12222, 39.18281], [-120.1222, 39.18292], [-120.12223, 39.18306], [-120.12232, 39.1832]]]}	Open Access 1	29621	Burton Creek State Park	16530	204	California Department of Parks and Recreation 48	State 5	State Agency 5	http://www.parks.ca.gov/	California Department of Parks and Recreation 9	2260	Tahoe City Public Utilities District 658	Special District 4	Water District 13	https://www.parks.ca.gov/?page_id=512	Placer 35	8.931	Burton Creek SP	1976	None 306
11841	11841	11840	{"type": "Polygon", "coordinates": [[[-120.12168, 39.18367], [-120.12168, 39.18469], [-120.12128, 39.18475], [-120.11964, 39.1841], [-120.1189, 39.18402], [-120.1189, 39.18368], [-120.12168, 39.18367]]]}	Open Access 1	24253	Pomin Park	23878	2260	Tahoe City Public Utilities District 993	Special District 4	Water District 13	http://www.tahoecitypud.com/parksrec.shtml	Special District 4	2260	Tahoe City Public Utilities District 658	Special District 4	Water District 13		Placer 35	4.592	Pomin Park	0	Local Park 2	4
11876	11876	11875	{"type": "Polygon", "coordinates": [[[-120.11571, 39.1806], [-120.11568, 39.18066], [-120.11555, 39.18075], [-120.11512, 39.18076], [-120.11498, 39.18084], [-120.11442, 39.18138], [-120.11424, 39.18139], [-120.11419, 39.1813], [-120.11437, 39.18121], [-120.11442, 39.18108], [-120.11455, 39.18091], [-120.11474, 39.18052], [-120.11432, 39.18023], [-120.11388, 39.17996], [-120.11386, 39.1799], [-120.11374, 39.17984], [-120.11375, 39.17968], [-120.11395, 39.17941], [-120.11435, 39.17916], [-120.11455, 39.17905], [-120.11478, 39.17905], [-120.11469, 39.17913], [-120.11465, 39.1793], [-120.11467, 39.17939], [-120.1146, 39.17983], [-120.11474, 39.18003], [-120.11493, 39.18017], [-120.11517, 39.18021], [-120.11555, 39.18034], [-120.11569, 39.18033], [-120.11571, 39.1806]]]}	Open Access 1	24329	Lake Forest Beach Park	20886	2260	Tahoe City Public Utilities District 993	Special District 4	Water District 13	http://www.tahoecitypud.com/parksrec.shtml	Special District 4	2260	Tahoe City Public Utilities District 658	Special District 4	Water District 13		Placer 35	3.69	Lake Forest Beach Park	0	Local Park 2	4
13067	13067	13066	{"type": "MultiPolygon", "coordinates": [[[[-120.11204, 39.18469], [-120.11175, 39.18479], [-120.11195, 39.18517], [-120.11053, 39.18564], [-120.11053, 39.18732], [-120.10893, 39.18731], [-120.10892, 39.18738], [-120.10783, 39.18743], [-120.10791, 39.18368], [-120.10919, 39.18328], [-120.10947, 39.18378], [-120.11025, 39.18353], [-120.11056, 39.18408], [-120.11153, 39.18376], [-120.11204, 39.18469]]], [[[-120.11717, 39.18101], [-120.11706, 39.18367], [-120.11653, 39.18367], [-120.11661, 39.18202], [-120.11608, 39.182], [-120.11613, 39.18078], [-120.1164, 39.18079], [-120.11666, 39.18083], [-120.11675, 39.18085], [-120.11717, 39.18101]]]]}	Open Access 1	34943	TSRA Outliers - Skylandia	26556	204	California Department of Parks and Recreation 48	State 5	State Agency 5	http://www.parks.ca.gov/	California Department of Parks and Recreation 9	2260	Tahoe City Public Utilities District 658	Special District 4	Water District 13		Placer 35	33.462	TSRA Outliers - Skylandia		None 1133
14930	14930	14929	{"type": "Polygon", "coordinates": [[[-120.14308, 39.16907], [-120.14254, 39.16948], [-120.14177, 39.17015], [-120.1403, 39.17133], [-120.14004, 39.17112], [-120.14008, 39.17111], [-120.14018, 39.17102], [-120.14023, 39.17089], [-120.14024, 39.17067], [-120.14032, 39.1705], [-120.14044, 39.17038], [-120.1406, 39.17007], [-120.14074, 39.16998], [-120.14119, 39.16984], [-120.14143, 39.16975], [-120.14154, 39.16966], [-120.14166, 39.16946], [-120.14176, 39.16907], [-120.14308, 39.16907]]]}	Open Access 1	45515	Commons Beach	28348	2260	Tahoe City Public Utilities District 993	Special District 4	Water District 13	http://www.tahoecitypud.com/parksrec.shtml	Special District 4	2260	Tahoe City Public Utilities District 658	Special District 4	Water District 13	http://www.tahoecitypud.com/parksrec/4e3_commons_beach.shtml	Placer 35	4.738	Commons Beach	0	Local Park 2	4
14970	14970	14969	{"type": "Polygon", "coordinates": [[[-120.15795, 39.13429], [-120.15786, 39.13569], [-120.15552, 39.13559], [-120.15642, 39.13422], [-120.15795, 39.13429]]]}	Open Access 1	45583	Kilner Park	28409	2260	Tahoe City Public Utilities District 993	Special District 4	Water District 13	http://www.tahoecitypud.com/parksrec.shtml	Special District 4	2260	Tahoe City Public Utilities District 658	Special District 4	Water District 13	https://www.tcpud.org/parks-recreation/facilities-parks-and-rentals/parks/kilner-park	Placer 35	6.423	Kilner 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]);