calands: units_with_maps: 9 rows where AGNCY_TYP = 5 and MNG

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

9 rows where AGNCY_TYP = 5 and MNG_AGENCY = 747

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	COUNTY	ACRES	LABEL_NAME	YR_EST	DES_TP	GAP_STS
4478	4478	4477	{"type": "Polygon", "coordinates": [[[-116.49292, 33.88852], [-116.49291, 33.8894], [-116.48878, 33.88856], [-116.49198, 33.88852], [-116.49292, 33.88852]]]}	Unknown Access 4	3751	Unnamed site - California Wildlife Conservation Board	28678	212	California Wildlife Conservation Board 766	State 5	State Agency 5	http://www.wcb.ca.gov/	Other State 5	212	California Wildlife Conservation Board 747	State 5	State Agency 5	Riverside 10	4.66		0	State Other or Unknown 104	4
4479	4479	4478	{"type": "Polygon", "coordinates": [[[-116.49291, 33.88957], [-116.4929, 33.89588], [-116.48423, 33.89587], [-116.48427, 33.8886], [-116.48805, 33.88856], [-116.49291, 33.88957]]]}	Unknown Access 4	3752	Unnamed site - California Wildlife Conservation Board	28678	212	California Wildlife Conservation Board 766	State 5	State Agency 5	http://www.wcb.ca.gov/	Other State 5	212	California Wildlife Conservation Board 747	State 5	State Agency 5	Riverside 10	154.196		0	State Other or Unknown 104	4
4486	4486	4485	{"type": "Polygon", "coordinates": [[[-116.24853, 33.84567], [-116.24851, 33.84812], [-116.24644, 33.84703], [-116.24644, 33.84565], [-116.24853, 33.84567]]]}	Unknown Access 4	4473	Unnamed site - California Wildlife Conservation Board	28678	212	California Wildlife Conservation Board 766	State 5	State Agency 5	http://www.wcb.ca.gov/	Other State 5	212	California Wildlife Conservation Board 747	State 5	State Agency 5	Riverside 10	10.124		0	State Other or Unknown 104	4
4531	4531	4530	{"type": "Polygon", "coordinates": [[[-117.08544, 34.21542], [-117.08542, 34.22251], [-117.08407, 34.22245], [-117.08415, 34.22223], [-117.08413, 34.22191], [-117.0839, 34.22174], [-117.08329, 34.22154], [-117.08268, 34.22152], [-117.08221, 34.22141], [-117.08181, 34.22089], [-117.08145, 34.22017], [-117.08127, 34.21946], [-117.08113, 34.21914], [-117.08087, 34.21887], [-117.08049, 34.2187], [-117.08027, 34.21843], [-117.08021, 34.21815], [-117.0801, 34.21792], [-117.07994, 34.21776], [-117.07952, 34.21768], [-117.07906, 34.2178], [-117.07588, 34.219], [-117.07557, 34.21902], [-117.07495, 34.21901], [-117.07449, 34.21893], [-117.07394, 34.21892], [-117.07325, 34.21894], [-117.07251, 34.21904], [-117.07197, 34.21922], [-117.07435, 34.21745], [-117.07487, 34.21718], [-117.0755, 34.21664], [-117.07606, 34.21615], [-117.07698, 34.2154], [-117.07709, 34.21533], [-117.08106, 34.21533], [-117.08107, 34.21539], [-117.08544, 34.21542]]]}	Open Access 1	18388	Unnamed site - California Wildlife Conservation Board	28679	212	California Wildlife Conservation Board 766	State 5	State Agency 5	http://www.wcb.ca.gov/	Other State 5	212	California Wildlife Conservation Board 747	State 5	State Agency 5	San Bernardino 22	117.167		0	State Other or Unknown 104	4
5162	5162	5161	{"type": "Polygon", "coordinates": [[[-120.28838, 34.6322], [-120.28819, 34.63214], [-120.28749, 34.63204], [-120.28601, 34.6281], [-120.2848, 34.626], [-120.2853, 34.62489], [-120.28414, 34.61969], [-120.28535, 34.61953], [-120.28645, 34.62558], [-120.28607, 34.62652], [-120.28748, 34.62894], [-120.28838, 34.6322]]]}	Unknown Access 4	17	RHR, Santa Rosa Creek	24314	212	California Wildlife Conservation Board 766	State 5	State Agency 5	http://www.wcb.ca.gov/	Other State 5	212	California Wildlife Conservation Board 747	State 5	State Agency 5	Santa Barbara 7	34.432	RHR, Santa Rosa Creek		None 418
8625	8625	8624	{"type": "Polygon", "coordinates": [[[-120.1217, 34.50899], [-120.1215, 34.51982], [-120.12123, 34.53056], [-120.11243, 34.53048], [-120.11238, 34.5342], [-120.10805, 34.53417], [-120.108, 34.53779], [-120.10865, 34.5378], [-120.09496, 34.53782], [-120.095, 34.53396], [-120.09499, 34.53395], [-120.09504, 34.53037], [-120.09508, 34.5298], [-120.09469, 34.52938], [-120.0943, 34.529], [-120.09418, 34.52877], [-120.09451, 34.52685], [-120.09508, 34.52678], [-120.09515, 34.52404], [-120.09518, 34.52331], [-120.09512, 34.51591], [-120.11291, 34.516], [-120.11298, 34.50877], [-120.1217, 34.50899]]]}	No Public Access 3	13788	Rancho Dos Vistas	24143	212	California Wildlife Conservation Board 766	State 5	State Agency 5	http://www.wcb.ca.gov/	Other State 5	212	California Wildlife Conservation Board 747	State 5	State Agency 5	Santa Barbara 7	1402.81	Rancho Dos Vistas		None 721
10220	10220	10219	{"type": "Polygon", "coordinates": [[[-116.31868, 33.79469], [-116.31429, 33.79469], [-116.31426, 33.79104], [-116.31864, 33.79105], [-116.31868, 33.79469]]]}	Open Access 1	17872	Coachella Valley Preserve - WCB	17455	212	California Wildlife Conservation Board 766	State 5	State Agency 5	http://www.wcb.ca.gov/	Other State 5	212	California Wildlife Conservation Board 747	State 5	State Agency 5	Riverside 10	40.566	Coachella Valley Preserve - WCB		None 889
14678	14678	14677	{"type": "Polygon", "coordinates": [[[-122.38409, 37.66344], [-122.38388, 37.66372], [-122.38363, 37.66373], [-122.38343, 37.66386], [-122.38284, 37.66322], [-122.38239, 37.66304], [-122.38262, 37.6625], [-122.38292, 37.66223], [-122.38313, 37.66237], [-122.38329, 37.66223], [-122.38382, 37.66262], [-122.38391, 37.66314], [-122.38409, 37.66344]]]}	Open Access 1	44985	Oyster Point Park	23284	212	California Wildlife Conservation Board 766	State 5	State Agency 5	http://www.wcb.ca.gov/	Other State 5	212	California Wildlife Conservation Board 747	State 5	State Agency 5	San Mateo 15	3.876	Oyster Point Park		None 1254
14856	14856	14855	{"type": "Polygon", "coordinates": [[[-124.18903, 40.79066], [-124.18902, 40.79082], [-124.18514, 40.7908], [-124.1852, 40.79064], [-124.18903, 40.79066]]]}	No Public Access 3	45366	Del Norte Street Pier	18042	212	California Wildlife Conservation Board 766	State 5	State Agency 5	http://www.wcb.ca.gov/	Other State 5	212	California Wildlife Conservation Board 747	State 5	State Agency 5	Humboldt 45	1.467	Del Norte Street Pier		None 1279

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