units_with_maps

Table actions

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

10 rows where AGNCY_NAME = 25, AGNCY_WEB = "https://www.wildlife.ca.gov/" and DES_TP = 104

This data as json, copyable, CSV (advanced)

ACCESS_TYP 2

MNG_AG_TYP 1

DES_TP 1

  • State Other or Unknown · 10 ✖
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
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 0 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 0 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 0 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   0 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 0 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 0 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 0 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 0 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 0 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 0 State Other or Unknown 104 4

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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