calands: units_with_maps: 10 rows where DES_TP = 104, LAYER = 6 and MNG

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

10 rows where DES_TP = 104, LAYER = 6 and MNG_AGENCY = 25

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	DES_TP	GAP_STS
3676	3676	3675	{"type": "Polygon", "coordinates": [[[-123.9944, 40.85728], [-123.98793, 40.85729], [-123.98823, 40.85355], [-123.99083, 40.85359], [-123.991, 40.85206], [-123.99205, 40.85205], [-123.99208, 40.8536], [-123.99105, 40.85359], [-123.99104, 40.8536], [-123.99158, 40.85448], [-123.99209, 40.85481], [-123.99433, 40.85721], [-123.9944, 40.85728]]]}	Open Access 1	44354	Mad River Fish Hatchery	32212	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	Humboldt 45	43.3	Mad River Fish Hatchery	State Other or Unknown 104	4
3679	3679	3678	{"type": "Polygon", "coordinates": [[[-118.88648, 34.3927], [-118.88616, 34.39362], [-118.88606, 34.39361], [-118.88569, 34.39465], [-118.88193, 34.39395], [-118.88215, 34.39142], [-118.88648, 34.3927]]]}	Open Access 1	44358	Fillmore Fish Hatchery	32165	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	Ventura 8	24.109	Fillmore Fish Hatchery	State Other or Unknown 104	4
3680	3680	3679	{"type": "Polygon", "coordinates": [[[-117.26286, 34.48019], [-117.26032, 34.48127], [-117.25982, 34.48047], [-117.25985, 34.47881], [-117.25943, 34.47781], [-117.26087, 34.47739], [-117.26169, 34.47931], [-117.26221, 34.47915], [-117.26286, 34.48019]]]}	Open Access 1	44360	Mojave River Fish Hatchery	32227	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	San Bernardino 22	17.666	Mojave River Fish Hatchery	State Other or Unknown 104	4
4771	4771	4770	{"type": "Polygon", "coordinates": [[[-124.09931, 40.49321], [-124.09822, 40.4937], [-124.09816, 40.49283], [-124.09855, 40.49302], [-124.09884, 40.49286], [-124.09931, 40.49321]]]}	Open Access 1	46932	Unnamed site - California Department of Fish and Wildlife	30559	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	Humboldt 45	1.271		State Other or Unknown 104	4
6495	6495	6494	{"type": "Polygon", "coordinates": [[[-122.3326, 41.30589], [-122.33249, 41.3062], [-122.33207, 41.30637], [-122.33217, 41.30672], [-122.33166, 41.30715], [-122.33116, 41.30804], [-122.33115, 41.30819], [-122.33034, 41.30844], [-122.33029, 41.30956], [-122.33025, 41.30957], [-122.33012, 41.30987], [-122.32975, 41.31021], [-122.32973, 41.31055], [-122.32915, 41.3101], [-122.32887, 41.30992], [-122.32817, 41.30958], [-122.32679, 41.30908], [-122.32659, 41.30891], [-122.32846, 41.30749], [-122.32846, 41.30626], [-122.33044, 41.30579], [-122.33046, 41.30533], [-122.33252, 41.30536], [-122.33252, 41.30566], [-122.3326, 41.30589]]]}	Open Access 1	2367	Mount Shasta Fish Hatchery	32233	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	Siskiyou 28	32.759	Mount Shasta Fish Hatchery	State Other or Unknown 104	4
6906	6906	6905	{"type": "Polygon", "coordinates": [[[-121.85532, 36.96849], [-121.8553, 36.97036], [-121.85531, 36.97247], [-121.8493, 36.97206], [-121.84933, 36.97197], [-121.84969, 36.9715], [-121.84967, 36.97143], [-121.85036, 36.97084], [-121.85035, 36.97049], [-121.85054, 36.97015], [-121.85084, 36.97007], [-121.85123, 36.96986], [-121.85152, 36.96938], [-121.85532, 36.96849]]]}	No Public Access 3	47542	San Andreas Creek - King Property	31250	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	Santa Cruz 5	39.619	San Andreas Creek - King Property	State Other or Unknown 104	4
7566	7566	7565	{"type": "MultiPolygon", "coordinates": [[[[-118.79086, 34.75249], [-118.7905, 34.75269], [-118.78995, 34.75282], [-118.78833, 34.75304], [-118.7856, 34.75305], [-118.78493, 34.75343], [-118.7845, 34.75351], [-118.78357, 34.75316], [-118.78272, 34.7538], [-118.78126, 34.75417], [-118.78017, 34.75394], [-118.77903, 34.75547], [-118.77894, 34.75664], [-118.77779, 34.75756], [-118.77848, 34.758], [-118.77841, 34.75986], [-118.77886, 34.75987], [-118.77913, 34.76202], [-118.77761, 34.76518], [-118.77755, 34.76574], [-118.77634, 34.76582], [-118.77522, 34.7637], [-118.77346, 34.76262], [-118.77195, 34.76241], [-118.77418, 34.76093], [-118.7718, 34.76016], [-118.7718, 34.75988], [-118.77251, 34.75988], [-118.77253, 34.75986], [-118.77541, 34.75987], [-118.77538, 34.75716], [-118.76641, 34.75721], [-118.76641, 34.7563], [-118.76211, 34.75628], [-118.76217, 34.75101], [-118.76215, 34.74996], [-118.76216, 34.74903], [-118.74905, 34.74906], [-118.74903, 34.74547], [-118.74904, 34.73837], [-118.75789, 34.73825], [-118.75783, 34.7453], [-118.75784, 34.74543], [-118.76664, 34.74538], [-118.76648, 34.75269], [-118.78437, 34.75246], [-118.79086, 34.75249]]], [[[-118.81161, 34.69934], [-118.80281, 34.69927], [-118.80282, 34.70238], [-118.80001, 34.70204], [-118.79731, 34.7014], [-118.79715, 34.70135], [-118.79688, 34.70122], [-118.79659, 34.70101], [-118.79636, 34.70072], [-118.79535, 34.69892], [-118.79396, 34.69519], [-118.79373, 34.69386], [-118.79362, 34.6936], [-118.79348, 34.69334], [-118.7933, 34.69308], [-118.7926, 34.69251], [-118.79179, 34.69207], [-118.79171, 34.69193], [-118.79408, 34.69176], [-118.80275, 34.69201], [-118.80714, 34.69205], [-118.80718, 34.69567], [-118.81157, 34.69571], [-118.81161, 34.69934]]], [[[-118.7954, 34.74528], [-118.79529, 34.74598], [-118.79517, 34.74694], [-118.79477, 34.7469], [-118.79447, 34.74857], [-118.79437, 34.74895], [-118.79362, 34.75118], [-118.79356, 34.75131], [-118.79347, 34.75144], [-118.79333, 34.75159], [-118.79322, 34.75168], [-118.79317, 34.74518], [-118.7953, 34.74521], [-118.7954, 34.74528]]]]}	No Public Access 3	7259	DWR Mitigation -- L.A. Property	32152	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	Los Angeles 6	999.598	DWR Mitigation -- L.A. Property	State Other or Unknown 104	4
7674	7674	7673	{"type": "Polygon", "coordinates": [[[-119.72154, 36.98342], [-119.72124, 36.98436], [-119.72043, 36.98505], [-119.72041, 36.98576], [-119.72081, 36.98612], [-119.71504, 36.98955], [-119.71421, 36.98877], [-119.71461, 36.98852], [-119.71382, 36.98803], [-119.71385, 36.98732], [-119.71406, 36.98693], [-119.71412, 36.9868], [-119.71485, 36.98589], [-119.7156, 36.98567], [-119.71653, 36.98603], [-119.71687, 36.98603], [-119.71851, 36.98504], [-119.7193, 36.98381], [-119.72074, 36.98281], [-119.72122, 36.98286], [-119.72154, 36.98342]]]}	Open Access 1	7583	San Joaquin Fish Hatchery	32294	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	Fresno 9	49.554	San Joaquin Fish Hatchery	State Other or Unknown 104	4
10013	10013	10012	{"type": "Polygon", "coordinates": [[[-121.0344, 37.04936], [-121.02559, 37.04938], [-121.02568, 37.04211], [-121.02537, 37.0413], [-121.02528, 37.04058], [-121.02522, 37.04034], [-121.03435, 37.04041], [-121.03434, 37.04218], [-121.0344, 37.04936]]]}	No Public Access 3	17275	Jasper Sears Mitigation Parcel	32192	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	Merced 37	192.527	Jasper Sears Mitigation Parcel	State Other or Unknown 104	4
14336	14336	14335	{"type": "Polygon", "coordinates": [[[-122.00031, 40.43185], [-122.00029, 40.43226], [-121.99983, 40.4321], [-121.99906, 40.4325], [-121.99844, 40.43331], [-121.99657, 40.43358], [-121.99441, 40.43303], [-121.99419, 40.433], [-121.9926, 40.43265], [-121.99119, 40.43195], [-121.99124, 40.42927], [-121.99732, 40.42914], [-121.99734, 40.42833], [-122.00029, 40.42825], [-122.00031, 40.43185]]]}	Open Access 1	44352	Darrah Springs Fish Hatchery	32144	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	Shasta 27	85.045	Darrah Springs Fish Hatchery	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]);