calands: units_with_maps: 10 rows where ACCESS_TYP = 1 and MNG_AG

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

10 rows where ACCESS_TYP = 1 and MNG_AG_ID = 205

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
909	909	908	{"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.99446, 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.99241, 32.66479], [-116.9924, 32.66481], [-116.98955, 32.66381], [-116.98915, 32.66383], [-116.98534, 32.66471], [-116.98442, 32.66526], [-116.98444, 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.66169], [-116.99324, 32.66166], [-116.99346, 32.66211], [-116.99359, 32.6624], [-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.66831], [-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.99781, 32.66579], [-116.99839, 32.6665], [-116.99859, 32.66701], [-116.99879, 32.66746], [-116.99892, 32.66874], [-117.00005, 32.6695], [-117.00038, 32.67013], [-117.00035, 32.67151], [-117.00156, 32.67463]]]]}	Open Access 1	5809	Blue-Bonita Meadows	1797	205	California Department of Transportation 283	State 5	State Agency 5	http://www.dot.ca.gov/	Other State 5	205	California Department of Transportation 279	State 5	State Agency 5		San Diego 4	240.067	Blue-Bonita Meadows		None 81
1157	1157	1156	{"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	7356	CalTrans TransNet Environmental Mitigation	16740	205	California Department of Transportation 283	State 5	State Agency 5	http://www.dot.ca.gov/	Other State 5	205	California Department of Transportation 279	State 5	State Agency 5		San Diego 4	33.902	CalTrans TransNet Environmental Mitigation	0	State Other or Unknown 104	4
4152	4152	4151	{"type": "Polygon", "coordinates": [[[-117.97658, 33.91104], [-117.97658, 33.91143], [-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.97658, 33.91104]]]}	Open Access 1	48288	Coyote Creek Bikeway	32861	312	Orange, County of 142	County 3	County Agency 3	http://ocparks.com/	County 3	205	California Department of Transportation 279	State 5	State Agency 5	http://www.lhcm.org/386/Bikeways	Orange 3	8.381	Coyote Creek Bikeway	2011	None 358
4192	4192	4191	{"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	44884	Otay Mesa North TransNet Mitigation	23240	205	California Department of Transportation 283	State 5	State Agency 5	http://www.dot.ca.gov/	Other State 5	205	California Department of Transportation 279	State 5	State Agency 5		San Diego 4	85.226	Otay Mesa North TransNet Mitigation	0	State Other or Unknown 104	4
4772	4772	4771	{"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.7963, 40.91983], [-123.79616, 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.80017, 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.15156, 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.15907, 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.15907, 40.55577]], [[-124.15418, 40.562], [-124.15424, 40.56175], [-124.1541, 40.56175], [-124.15409, 40.56199], [-124.15418, 40.562]]]]}	Open Access 1	46933	Unnamed site - California Department of Transportation	30558	205	California Department of Transportation 283	State 5	State Agency 5	http://www.dot.ca.gov/	Other State 5	205	California Department of Transportation 279	State 5	State Agency 5		Humboldt 45	124.116		0	State Other or Unknown 104	4
11433	11433	11432	{"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	48123	Arlington Garden	32632	1246	Pasadena, City of 301	City 2	City Agency 2	http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/	City 2	205	California Department of Transportation 279	State 5	State Agency 5	http://www.arlingtongardenpasadena.com/	Los Angeles 6	2.55	Arlington Garden	2005	None 1014
11736	11736	11735	{"type": "Polygon", "coordinates": [[[-122.39127, 37.75408], [-122.39097, 37.75409], [-122.39088, 37.75351], [-122.39085, 37.75347], [-122.39082, 37.75346], [-122.39076, 37.75345], [-122.39076, 37.7531], [-122.39079, 37.7531], [-122.39096, 37.75335], [-122.39112, 37.75365], [-122.39126, 37.75395], [-122.39127, 37.75408]]]}	Open Access 1	48729	Progress Park	33456	205	California Department of Transportation 283	State 5	State Agency 5	http://www.dot.ca.gov/	Other State 5	205	California Department of Transportation 279	State 5	State Agency 5	https://www.sfparksalliance.org/our-work/park-partners/progress-park	San Francisco 13	0.521	Progress Park		None 1038
14519	14519	14518	{"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.51288, 37.9125], [-122.51288, 37.91262], [-122.51293, 37.91302], [-122.51293, 37.91326], [-122.5129, 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	47192	Alto Path	30886	205	California Department of Transportation 283	State 5	State Agency 5	http://www.dot.ca.gov/	Other State 5	205	California Department of Transportation 279	State 5	State Agency 5		Marin 23	0.756	Alto Path		None 1236
14544	14544	14543	{"type": "Polygon", "coordinates": [[[-117.97916, 33.9094], [-117.97859, 33.91001], [-117.97804, 33.91048], [-117.9775, 33.91087], [-117.97658, 33.91143], [-117.97658, 33.91103], [-117.97694, 33.91084], [-117.97741, 33.91054], [-117.97784, 33.91022], [-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	48309	Coyote Creek Bikeway	32861	312	Orange, County of 142	County 3	County Agency 3	http://ocparks.com/	County 3	205	California Department of Transportation 279	State 5	State Agency 5	http://www.lhcm.org/386/Bikeways	Los Angeles 6	2.63	Coyote Creek Bikeway	2011	None 1239
14627	14627	14626	{"type": "Polygon", "coordinates": [[[-117.1923, 32.94906], [-117.191, 32.94919], [-117.19013, 32.94942], [-117.18969, 32.94958], [-117.1895, 32.94982], [-117.19051, 32.94991], [-117.19179, 32.94988], [-117.18881, 32.95146], [-117.18726, 32.95215], [-117.18661, 32.95216], [-117.18604, 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	44879	Deer Canyon Environmental Mitigation	17991	205	California Department of Transportation 283	State 5	State Agency 5	http://www.dot.ca.gov/	Other State 5	205	California Department of Transportation 279	State 5	State Agency 5		San Diego 4	54.189	Deer Canyon Environmental Mitigation	0	State Other or Unknown 104	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]);