calands: units_with_maps: 8 rows where ACCESS_TYP = 3, COUNTY = 10 and MNG_AG

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

8 rows where ACCESS_TYP = 3, COUNTY = 10 and MNG_AG_TYP = 5

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
1331	1331	1330	{"type": "Polygon", "coordinates": [[[-117.30505, 33.972], [-117.30065, 33.97196], [-117.30065, 33.97556], [-117.29645, 33.97552], [-117.2965, 33.96463], [-117.30083, 33.96465], [-117.30087, 33.96815], [-117.30505, 33.96813], [-117.30505, 33.972]]]}	No Public Access 3	47644	Box Springs Reserve	31388	217	University of California 53	State 5	State Agency 5	http://nrs.ucop.edu/	Other State 5	217	University of California 51	State 5	State Agency 5	http://www.ucnrs.org/reserves/box-springs-reserve.html	Riverside 10	159.828	Box Springs Reserve	0	State Conservation Area 8	2
1551	1551	1550	{"type": "Polygon", "coordinates": [[[-117.15937, 33.4648], [-117.15693, 33.46596], [-117.15546, 33.46627], [-117.1551, 33.46876], [-117.15582, 33.4699], [-117.15547, 33.4701], [-117.15359, 33.47159], [-117.15293, 33.47188], [-117.14835, 33.47303], [-117.14752, 33.4732], [-117.14553, 33.47346], [-117.1454, 33.4735], [-117.1452, 33.47361], [-117.14441, 33.47424], [-117.14428, 33.4744], [-117.14423, 33.47451], [-117.14422, 33.47465], [-117.14428, 33.47512], [-117.14445, 33.47524], [-117.14434, 33.47534], [-117.14243, 33.47398], [-117.14117, 33.47457], [-117.1392, 33.47439], [-117.13887, 33.4735], [-117.14494, 33.46886], [-117.14521, 33.46914], [-117.14523, 33.46914], [-117.14519, 33.46582], [-117.15408, 33.46502], [-117.15937, 33.4648]]]}	No Public Access 3	11546	Santa Margarita Ecological Reserve	33343	201	California Department of Fish and Wildlife 25	State 5	State Agency 5	https://www.wildlife.ca.gov/	California Department of Fish and Wildlife 6	221	San Diego State University 378	State 5	State Agency 5	https://fsp.sdsu.edu/about-us/	Riverside 10	243.178	Santa Margarita ER	1962	State Conservation Area 8	2
1581	1581	1580	{"type": "Polygon", "coordinates": [[[-115.54599, 33.539], [-115.53693, 33.53898], [-115.53689, 33.53374], [-115.53922, 33.53373], [-115.53931, 33.53565], [-115.54152, 33.53564], [-115.54145, 33.53741], [-115.54597, 33.53769], [-115.54599, 33.539]]]}	No Public Access 3	12128	Chuckwalla Bench	32115	201	California Department of Fish and Wildlife 25	State 5	State Agency 5	https://www.wildlife.ca.gov/	California Department of Fish and Wildlife 6	201	California Department of Fish and Wildlife 25	State 5	State Agency 5		Riverside 10	66.962	Chuckwalla Bench	0	State Resource Management Area 55	3
5306	5306	5305	{"type": "Polygon", "coordinates": [[[-117.12552, 33.99331], [-117.12126, 33.99328], [-117.11256, 33.99348], [-117.11249, 33.98994], [-117.11245, 33.98023], [-117.11095, 33.97863], [-117.1105, 33.97829], [-117.10978, 33.9779], [-117.10945, 33.97776], [-117.10864, 33.97754], [-117.10816, 33.97747], [-117.10379, 33.97714], [-117.1038, 33.97554], [-117.10311, 33.9613], [-117.12114, 33.96103], [-117.12106, 33.97547], [-117.11887, 33.97549], [-117.11892, 33.97888], [-117.11702, 33.97902], [-117.11725, 33.98106], [-117.11679, 33.98109], [-117.11681, 33.98163], [-117.11762, 33.98158], [-117.11875, 33.98146], [-117.11944, 33.98136], [-117.12249, 33.98086], [-117.12289, 33.98081], [-117.12321, 33.98079], [-117.12326, 33.98622], [-117.12121, 33.98622], [-117.12124, 33.98976], [-117.12548, 33.98977], [-117.12552, 33.99331]], [[-117.1118, 33.97551], [-117.11183, 33.97539], [-117.11181, 33.97527], [-117.11161, 33.97497], [-117.11154, 33.97471], [-117.1115, 33.97466], [-117.11143, 33.97461], [-117.11132, 33.97458], [-117.11082, 33.97459], [-117.11052, 33.97453], [-117.11042, 33.97447], [-117.11014, 33.97416], [-117.11005, 33.97412], [-117.10995, 33.97411], [-117.10938, 33.97423], [-117.10928, 33.9742], [-117.10915, 33.97407], [-117.1089, 33.97423], [-117.10856, 33.97458], [-117.10841, 33.97491], [-117.10771, 33.97497], [-117.10783, 33.97519], [-117.10765, 33.97529], [-117.10752, 33.97541], [-117.10664, 33.97665], [-117.10653, 33.97672], [-117.10639, 33.97671], [-117.10638, 33.97672], [-117.10643, 33.97679], [-117.10689, 33.97686], [-117.10837, 33.97694], [-117.10878, 33.97699], [-117.10954, 33.97714], [-117.11031, 33.97741], [-117.11039, 33.97735], [-117.11049, 33.97733], [-117.11082, 33.97745], [-117.11095, 33.97745], [-117.11105, 33.97742], [-117.11114, 33.97738], [-117.11126, 33.97724], [-117.11128, 33.97716], [-117.11128, 33.97682], [-117.1114, 33.97631], [-117.11146, 33.97618], [-117.11157, 33.97605], [-117.11168, 33.97586], [-117.1118, 33.97551]]]}	No Public Access 3	5782	San Timoteo Canyon	24994	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	204	California Department of Parks and Recreation 47	State 5	State Agency 5		Riverside 10	1079.444	San Timoteo Canyon	2002	None 428
6386	6386	6385	{"type": "Polygon", "coordinates": [[[-117.52541, 33.96645], [-117.52323, 33.96645], [-117.52323, 33.96816], [-117.52308, 33.96816], [-117.52307, 33.96821], [-117.52205, 33.96822], [-117.52205, 33.96841], [-117.5211, 33.96915], [-117.52048, 33.96989], [-117.51961, 33.97059], [-117.51875, 33.97187], [-117.51691, 33.97319], [-117.5158, 33.97365], [-117.5131, 33.97522], [-117.50998, 33.9752], [-117.50918, 33.97488], [-117.50687, 33.9741], [-117.50585, 33.97403], [-117.50479, 33.97394], [-117.50361, 33.97318], [-117.50246, 33.97302], [-117.50143, 33.97293], [-117.5014, 33.97181], [-117.49279, 33.97184], [-117.49277, 33.9709], [-117.49061, 33.97092], [-117.49058, 33.97001], [-117.48845, 33.97007], [-117.4863, 33.96896], [-117.48462, 33.96846], [-117.48335, 33.96843], [-117.48115, 33.9678], [-117.47973, 33.96718], [-117.47972, 33.96719], [-117.47972, 33.96789], [-117.47848, 33.96747], [-117.47631, 33.96659], [-117.47327, 33.96741], [-117.47088, 33.96761], [-117.47004, 33.96751], [-117.47017, 33.96736], [-117.47022, 33.96727], [-117.47026, 33.96712], [-117.47026, 33.96701], [-117.47023, 33.96686], [-117.47019, 33.96676], [-117.47012, 33.96667], [-117.46994, 33.96654], [-117.46977, 33.96648], [-117.46961, 33.96645], [-117.46958, 33.96655], [-117.46789, 33.96629], [-117.46628, 33.96524], [-117.46603, 33.96324], [-117.46598, 33.96295], [-117.46585, 33.9625], [-117.46578, 33.96229], [-117.46557, 33.96188], [-117.46536, 33.96155], [-117.46522, 33.96136], [-117.4649, 33.961], [-117.46467, 33.96077], [-117.46428, 33.96046], [-117.46388, 33.9602], [-117.46301, 33.95955], [-117.46411, 33.95939], [-117.46456, 33.95971], [-117.46482, 33.96024], [-117.46666, 33.96053], [-117.46667, 33.96066], [-117.46709, 33.96066], [-117.46883, 33.96132], [-117.46884, 33.96162], [-117.47095, 33.96164], [-117.47638, 33.96163], [-117.47641, 33.96253], [-117.4789, 33.96253], [-117.47887, 33.96481], [-117.47972, 33.96482], [-117.47977, 33.96254], [-117.48076, 33.96254], [-117.48077, 33.96164], [-117.48403, 33.96166], [-117.48405, 33.96075], [-117.48731, 33.96077], [-117.48732, 33.9605], [-117.49316, 33.96053], [-117.49311, 33.96121], [-117.49543, 33.96154], [-117.49849, 33.96316], [-117.49981, 33.96326], [-117.50044, 33.96291], [-117.50023, 33.96235], [-117.50322, 33.96165], [-117.50579, 33.96291], [-117.50662, 33.9634], [-117.51029, 33.96284], [-117.51273, 33.96201], [-117.51499, 33.96194], [-117.51499, 33.96243], [-117.51546, 33.96243], [-117.51546, 33.9628], [-117.51574, 33.96299], [-117.51821, 33.9628], [-117.52417, 33.95936], [-117.5254, 33.9605], [-117.52537, 33.96097], [-117.5254, 33.96098], [-117.52541, 33.96645]]]}	No Public Access 3	1798	Hidden Valley	32185	201	California Department of Fish and Wildlife 25	State 5	State Agency 5	https://www.wildlife.ca.gov/	California Department of Fish and Wildlife 6	201	California Department of Fish and Wildlife 25	State 5	State Agency 5		Riverside 10	1299.756	Hidden Valley	0	State Resource Management Area 55	3
7238	7238	7237	{"type": "Polygon", "coordinates": [[[-116.40815, 33.62707], [-116.40367, 33.6271], [-116.40321, 33.62712], [-116.40272, 33.62712], [-116.40277, 33.62581], [-116.40283, 33.62536], [-116.40298, 33.62502], [-116.40321, 33.62472], [-116.40343, 33.62452], [-116.4037, 33.62436], [-116.40395, 33.62425], [-116.40505, 33.62391], [-116.40545, 33.62377], [-116.4061, 33.62346], [-116.40655, 33.62317], [-116.40705, 33.62276], [-116.40753, 33.62235], [-116.40796, 33.62211], [-116.40815, 33.62343], [-116.40815, 33.62707]]]}	No Public Access 3	29180	Hidden Palms Ecological Reserve	32184	201	California Department of Fish and Wildlife 25	State 5	State Agency 5	https://www.wildlife.ca.gov/	California Department of Fish and Wildlife 6	201	California Department of Fish and Wildlife 25	State 5	State Agency 5		Riverside 10	47.345	Hidden Palms ER	0	State Conservation Area 8	2
9250	9250	9249	{"type": "MultiPolygon", "coordinates": [[[[-116.44947, 33.88499], [-116.44723, 33.88499], [-116.44529, 33.88496], [-116.4457, 33.88489], [-116.44596, 33.88482], [-116.44707, 33.88443], [-116.44732, 33.88435], [-116.44773, 33.88427], [-116.44824, 33.8842], [-116.44946, 33.88418], [-116.44947, 33.88499]]], [[[-116.46255, 33.8886], [-116.46251, 33.89218], [-116.45813, 33.89218], [-116.45819, 33.88861], [-116.46255, 33.8886]]], [[[-116.47988, 33.89224], [-116.47985, 33.89496], [-116.47554, 33.89498], [-116.47555, 33.89223], [-116.47988, 33.89224]]]]}	No Public Access 3	15404	Edom Hill-Willow Hole Preserve	18453	214	Coachella Valley Mountains Conservancy 767	State 5	State Agency 5	http://www.cvmc.ca.gov/	Other State 5	214	Coachella Valley Mountains Conservancy 748	State 5	State Agency 5		Riverside 10	75.092	Edom Hill-Willow Hole Preserve	0	State Conservation Area 8	2
9251	9251	9250	{"type": "Polygon", "coordinates": [[[-116.47394, 33.88857], [-116.47122, 33.88857], [-116.47122, 33.88785], [-116.47129, 33.88596], [-116.47394, 33.88857]]]}	No Public Access 3	15407	Edom Hill-Willow Hole Preserve	18453	214	Coachella Valley Mountains Conservancy 767	State 5	State Agency 5	http://www.cvmc.ca.gov/	Other State 5	214	Coachella Valley Mountains Conservancy 748	State 5	State Agency 5		Riverside 10	9.085	Edom Hill-Willow Hole Preserve	0	State Conservation Area 8	2

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