calands: superunits_with_maps: 9 rows where ACCESS_TYP = 1, LAYER = 5 and MNG_AG

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

9 rows where ACCESS_TYP = 1, LAYER = 5 and MNG_AG_ID = 205

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
383	383	382	{"type": "MultiPolygon", "coordinates": [[[[-116.98194, 32.66387], [-116.98012, 32.66389], [-116.98006, 32.66252], [-116.98113, 32.66321], [-116.98194, 32.66387]]], [[[-116.99533, 32.66736], [-116.9952, 32.6671], [-116.99494, 32.66669], [-116.9947, 32.66636], [-116.99447, 32.6661], [-116.99404, 32.6657], [-116.99371, 32.66545], [-116.99336, 32.66523], [-116.99305, 32.66506], [-116.99253, 32.66482], [-116.99242, 32.66479], [-116.9924, 32.66481], [-116.98955, 32.66381], [-116.98915, 32.66383], [-116.98534, 32.66471], [-116.98442, 32.66526], [-116.98443, 32.66385], [-116.98299, 32.66386], [-116.98277, 32.66357], [-116.98191, 32.66274], [-116.98083, 32.66182], [-116.98012, 32.66126], [-116.98162, 32.66028], [-116.99252, 32.66025], [-116.99312, 32.66168], [-116.99324, 32.66166], [-116.99346, 32.66211], [-116.99359, 32.66239], [-116.99369, 32.66237], [-116.99393, 32.6629], [-116.99407, 32.66325], [-116.9942, 32.66361], [-116.9944, 32.66434], [-116.99449, 32.66471], [-116.99456, 32.66515], [-116.99455, 32.66531], [-116.99458, 32.66546], [-116.99462, 32.66554], [-116.9947, 32.66567], [-116.99489, 32.66587], [-116.99513, 32.66618], [-116.99523, 32.66641], [-116.99531, 32.66663], [-116.99536, 32.66698], [-116.99535, 32.66725], [-116.99533, 32.66736]]], [[[-117.00156, 32.67463], [-116.99849, 32.67546], [-116.99657, 32.67064], [-116.99567, 32.66833], [-116.9957, 32.6683], [-116.99555, 32.66794], [-116.99562, 32.6678], [-116.99568, 32.66754], [-116.99571, 32.66723], [-116.99569, 32.66683], [-116.99561, 32.66648], [-116.99551, 32.66623], [-116.99533, 32.66591], [-116.99522, 32.66576], [-116.99497, 32.66549], [-116.99488, 32.66534], [-116.99485, 32.66493], [-116.99477, 32.66442], [-116.99459, 32.66368], [-116.9944, 32.66315], [-116.99369, 32.66154], [-116.99617, 32.66084], [-116.99614, 32.66208], [-116.99667, 32.66343], [-116.99675, 32.66451], [-116.99839, 32.6665], [-116.99859, 32.66701], [-116.99879, 32.66746], [-116.99892, 32.66873], [-117.00005, 32.6695], [-117.00038, 32.67013], [-117.00035, 32.67151], [-117.00156, 32.67463]]]]}	Open Access 1	Blue-Bonita Meadows		1797	205	California Department of Transportation 279	State 5	State Agency 5	http://www.dot.ca.gov/	Other State 5	240.053	Blue-Bonita Meadows
1097	1097	1096	{"type": "Polygon", "coordinates": [[[-117.97916, 33.9094], [-117.97859, 33.91001], [-117.97804, 33.91048], [-117.9775, 33.91087], [-117.97591, 33.91182], [-117.97546, 33.91214], [-117.96943, 33.91722], [-117.96887, 33.91721], [-117.97303, 33.91372], [-117.97303, 33.9137], [-117.97384, 33.91309], [-117.9751, 33.91199], [-117.97561, 33.91162], [-117.97741, 33.91054], [-117.97802, 33.91008], [-117.97805, 33.91001], [-117.97841, 33.90968], [-117.9788, 33.90926], [-117.97904, 33.90937], [-117.97916, 33.9094]]]}	Open Access 1	Coyote Creek Bikeway	http://www.lhcm.org/386/Bikeways	32861	205	California Department of Transportation 279	State 5	State Agency 5	http://www.dot.ca.gov/	Other State 5	11.01	Coyote Creek Bikeway	2011
2527	2527	2526	{"type": "Polygon", "coordinates": [[[-116.91384, 32.82128], [-116.9136, 32.82217], [-116.91351, 32.82247], [-116.91325, 32.82312], [-116.91306, 32.82352], [-116.91285, 32.82388], [-116.91253, 32.82436], [-116.91234, 32.8246], [-116.91137, 32.82546], [-116.91041, 32.8248], [-116.9096, 32.82296], [-116.90946, 32.82252], [-116.90948, 32.82219], [-116.91047, 32.82103], [-116.91059, 32.82076], [-116.91384, 32.82128]]]}	Open Access 1	CalTrans TransNet Environmental Mitigation		16740	205	California Department of Transportation 279	State 5	State Agency 5	http://www.dot.ca.gov/	Other State 5	33.901	CalTrans TransNet Environmental Mitigation
3503	3503	3502	{"type": "Polygon", "coordinates": [[[-117.1923, 32.94906], [-117.19099, 32.94919], [-117.19013, 32.94942], [-117.18969, 32.94958], [-117.18951, 32.94982], [-117.19051, 32.94991], [-117.19179, 32.94988], [-117.18881, 32.95146], [-117.18726, 32.95215], [-117.18661, 32.95216], [-117.18603, 32.95168], [-117.1852, 32.95166], [-117.18365, 32.9519], [-117.18288, 32.95212], [-117.18285, 32.94953], [-117.18356, 32.94954], [-117.18489, 32.94924], [-117.18599, 32.94907], [-117.18671, 32.94907], [-117.1883, 32.94888], [-117.18953, 32.94857], [-117.18983, 32.94848], [-117.19089, 32.94847], [-117.1916, 32.9486], [-117.1923, 32.94906]]]}	Open Access 1	Deer Canyon Environmental Mitigation		17991	205	California Department of Transportation 279	State 5	State Agency 5	http://www.dot.ca.gov/	Other State 5	54.196	Deer Canyon Environmental Mitigation
7789	7789	7788	{"type": "Polygon", "coordinates": [[[-117.0144, 32.5799], [-117.00992, 32.57971], [-117.00998, 32.57781], [-117.0099, 32.57209], [-117.01425, 32.57223], [-117.01413, 32.57247], [-117.01413, 32.57266], [-117.01421, 32.57544], [-117.01423, 32.5755], [-117.01432, 32.57559], [-117.0144, 32.5799]]]}	Open Access 1	Otay Mesa North TransNet Mitigation		23240	205	California Department of Transportation 279	State 5	State Agency 5	http://www.dot.ca.gov/	Other State 5	85.222	Otay Mesa North TransNet Mitigation
13471	13471	13470	{"type": "Polygon", "coordinates": [[[-122.51472, 37.90786], [-122.51472, 37.90792], [-122.51462, 37.9081], [-122.5146, 37.90818], [-122.5143, 37.9088], [-122.51347, 37.91085], [-122.51289, 37.9125], [-122.51288, 37.91262], [-122.51293, 37.91302], [-122.51293, 37.91326], [-122.51289, 37.91332], [-122.51271, 37.91352], [-122.51273, 37.91343], [-122.51285, 37.9133], [-122.51288, 37.91325], [-122.51288, 37.91302], [-122.51282, 37.91261], [-122.51284, 37.91248], [-122.51341, 37.91084], [-122.51425, 37.90878], [-122.51455, 37.90817], [-122.51457, 37.90808], [-122.51467, 37.9079], [-122.51472, 37.90786]]]}	Open Access 1	Alto Path		30886	205	California Department of Transportation 279	State 5	State Agency 5	http://www.dot.ca.gov/	Other State 5	0.756	Alto Path
13663	13663	13662	{"type": "Polygon", "coordinates": [[[-122.39127, 37.75408], [-122.39097, 37.75409], [-122.39088, 37.75351], [-122.39082, 37.75346], [-122.39076, 37.75345], [-122.39076, 37.7531], [-122.39079, 37.7531], [-122.39096, 37.75334], [-122.39112, 37.75365], [-122.39126, 37.75395], [-122.39127, 37.75408]]]}	Open Access 1	Progress Park	https://www.sfparksalliance.org/our-work/park-partners/progress-park	33456	205	California Department of Transportation 279	State 5	State Agency 5	http://www.dot.ca.gov/	Other State 5	0.522	Progress Park
14091	14091	14090	{"type": "Polygon", "coordinates": [[[-118.15638, 34.12905], [-118.1549, 34.12906], [-118.15483, 34.12838], [-118.15636, 34.12837], [-118.15633, 34.12839], [-118.15632, 34.12842], [-118.15638, 34.12905]]]}	Open Access 1	Arlington Garden	http://www.arlingtongardenpasadena.com/	32632	205	California Department of Transportation 279	State 5	State Agency 5	http://www.dot.ca.gov/	Other State 5	2.548	Arlington Garden	2005
14340	14340	14339	{"type": "MultiPolygon", "coordinates": [[[[-123.78953, 40.0753], [-123.7895, 40.07556], [-123.78937, 40.07563], [-123.78923, 40.07562], [-123.78895, 40.07539], [-123.78896, 40.07522], [-123.78889, 40.07509], [-123.78898, 40.0749], [-123.78947, 40.07503], [-123.78953, 40.0753]]], [[[-123.80311, 40.92168], [-123.80295, 40.92183], [-123.80259, 40.92175], [-123.80217, 40.92158], [-123.80189, 40.92163], [-123.80154, 40.92173], [-123.80135, 40.92181], [-123.80095, 40.92202], [-123.80048, 40.92219], [-123.79993, 40.92252], [-123.79977, 40.92257], [-123.79706, 40.92221], [-123.79506, 40.92144], [-123.79484, 40.91961], [-123.79532, 40.91907], [-123.79581, 40.91872], [-123.7969, 40.9187], [-123.7967, 40.91955], [-123.79647, 40.91965], [-123.79631, 40.91983], [-123.79617, 40.92023], [-123.79619, 40.92066], [-123.79623, 40.92097], [-123.79652, 40.92115], [-123.79731, 40.92106], [-123.79784, 40.92114], [-123.79858, 40.92122], [-123.80016, 40.92128], [-123.80216, 40.92123], [-123.80242, 40.92129], [-123.80298, 40.92146], [-123.80311, 40.92168]]], [[[-124.15195, 40.80245], [-124.15185, 40.80277], [-124.15155, 40.80277], [-124.15145, 40.80283], [-124.15145, 40.80296], [-124.15115, 40.80296], [-124.15115, 40.80236], [-124.15119, 40.80236], [-124.15157, 40.80212], [-124.15195, 40.80245]]], [[[-124.15906, 40.55577], [-124.15904, 40.5631], [-124.15159, 40.56302], [-124.15233, 40.56174], [-124.15358, 40.55931], [-124.15391, 40.55636], [-124.15462, 40.55636], [-124.15467, 40.55574], [-124.15906, 40.55577]], [[-124.15417, 40.562], [-124.15423, 40.56176], [-124.1541, 40.56175], [-124.15409, 40.56199], [-124.15417, 40.562]]]]}	Open Access 1	Unnamed site - California Department of Transportation		30558	205	California Department of Transportation 279	State 5	State Agency 5	http://www.dot.ca.gov/	Other State 5	124.128

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]);