calands: superunits_with_maps: 6 rows where ACCESS_TYP = 1, LAYER = 4 and MNG

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

6 rows where ACCESS_TYP = 1, LAYER = 4 and MNG_AGENCY = 658

Search:

descending

This data as json, copyable, CSV (advanced)

Link	rowid ▼	id	map	ACCESS_TYP	PARK_NAME	PARK_URL	SUID_NMA	MNG_AG_ID	MNG_AGENCY	MNG_AG_LEV	MNG_AG_TYP	AGNCY_WEB	LAYER	ACRES	LABEL_NAME	YR_EST
1661	1661	1660	{"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.12047, 39.18195], [-120.12103, 39.1821], [-120.12119, 39.18228], [-120.12117, 39.18246], [-120.12131, 39.18264], [-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	Burton Creek State Park	https://www.parks.ca.gov/?page_id=512	16530	2260	Tahoe City Public Utilities District 658	Special District 4	Water District 13	http://www.tahoecitypud.com/parksrec.shtml	Special District 4	8.935	Burton Creek SP	1976
5908	5908	5907	{"type": "Polygon", "coordinates": [[[-120.11571, 39.1806], [-120.11568, 39.18066], [-120.11555, 39.18075], [-120.11511, 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	Lake Forest Beach Park		20886	2260	Tahoe City Public Utilities District 658	Special District 4	Water District 13	http://www.tahoecitypud.com/parksrec.shtml	Special District 4	3.695	Lake Forest Beach Park
8290	8290	8289	{"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	Pomin Park		23878	2260	Tahoe City Public Utilities District 658	Special District 4	Water District 13	http://www.tahoecitypud.com/parksrec.shtml	Special District 4	4.592	Pomin Park
10472	10472	10471	{"type": "MultiPolygon", "coordinates": [[[[-120.11204, 39.18469], [-120.11176, 39.1848], [-120.11195, 39.18517], [-120.11054, 39.18565], [-120.11053, 39.18732], [-120.10894, 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.18203], [-120.11608, 39.182], [-120.11613, 39.18078], [-120.1164, 39.18079], [-120.11666, 39.18083], [-120.11675, 39.18086], [-120.11717, 39.18101]]]]}	Open Access 1	TSRA Outliers - Skylandia		26556	2260	Tahoe City Public Utilities District 658	Special District 4	Water District 13	http://www.tahoecitypud.com/parksrec.shtml	Special District 4	33.484	TSRA Outliers - Skylandia
11741	11741	11740	{"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.17088], [-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	Commons Beach	http://www.tahoecitypud.com/parksrec/4e3_commons_beach.shtml	28348	2260	Tahoe City Public Utilities District 658	Special District 4	Water District 13	http://www.tahoecitypud.com/parksrec.shtml	Special District 4	4.738	Commons Beach
11789	11789	11788	{"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	Kilner Park	https://www.tcpud.org/parks-recreation/facilities-parks-and-rentals/parks/kilner-park	28409	2260	Tahoe City Public Utilities District 658	Special District 4	Water District 13	http://www.tahoecitypud.com/parksrec.shtml	Special District 4	6.422	Kilner Park

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE superunits_with_maps(
  id INT,
  map,
  ACCESS_TYP INT,
  PARK_NAME TEXT,
  PARK_URL TEXT,
  SUID_NMA INT,
  MNG_AG_ID INT,
  MNG_AGENCY INT,
  MNG_AG_LEV INT,
  MNG_AG_TYP INT,
  AGNCY_WEB TEXT,
  LAYER INT,
  ACRES REAL,
  LABEL_NAME TEXT,
  YR_EST INT,
   FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id])
);
CREATE INDEX [idx_superunits_with_maps_LAYER]
    ON [superunits_with_maps] ([LAYER]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP]
    ON [superunits_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV]
    ON [superunits_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY]
    ON [superunits_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP]
    ON [superunits_with_maps] ([ACCESS_TYP]);