units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
32 rows where ACCESS_TYP = 1 and DES_TP = 104 sorted by ACRES
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP
ACCESS_TYP 1
- Open Access · 32 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4682 | 4682 | 4681 | {"type": "Polygon", "coordinates": [[[-121.68569, 36.44484], [-121.68518, 36.44573], [-121.68502, 36.44565], [-121.68518, 36.44552], [-121.68529, 36.44539], [-121.68537, 36.44527], [-121.68545, 36.44508], [-121.6855, 36.44499], [-121.68558, 36.44491], [-121.68569, 36.44484]]]} | Open Access 1 | 43073 | Unnamed site - Other State | 28654 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Monterey 14 | 0.221 | 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 | ||
4615 | 4615 | 4614 | {"type": "Polygon", "coordinates": [[[-120.43434, 35.8989], [-120.4339, 35.89938], [-120.433, 35.89938], [-120.433, 35.89909], [-120.43279, 35.89769], [-120.4328, 35.89746], [-120.43285, 35.89727], [-120.43291, 35.89727], [-120.43341, 35.89756], [-120.43422, 35.89848], [-120.43434, 35.8989]]]} | Open Access 1 | 36133 | Unnamed site - Other State | 28654 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Monterey 14 | 5.226 | 0 | State Other or Unknown 104 | 4 | |||
4617 | 4617 | 4616 | {"type": "Polygon", "coordinates": [[[-121.44723, 35.87386], [-121.44572, 35.87386], [-121.44568, 35.87182], [-121.44593, 35.87189], [-121.44619, 35.87189], [-121.44641, 35.87183], [-121.44656, 35.87186], [-121.447, 35.87216], [-121.447, 35.87235], [-121.44694, 35.8725], [-121.44675, 35.87258], [-121.44665, 35.87274], [-121.44665, 35.87297], [-121.44685, 35.87305], [-121.44688, 35.87323], [-121.44688, 35.87356], [-121.44709, 35.87378], [-121.44723, 35.87386]]]} | Open Access 1 | 36110 | Unnamed site - Other State | 28654 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Monterey 14 | 5.733 | 0 | State Other or Unknown 104 | 4 | |||
15481 | 15481 | 15480 | {"type": "Polygon", "coordinates": [[[-121.90442, 36.37228], [-121.90409, 36.37302], [-121.90285, 36.37256], [-121.9025, 36.37238], [-121.90224, 36.3722], [-121.90207, 36.37203], [-121.90198, 36.37191], [-121.90184, 36.37165], [-121.90175, 36.37141], [-121.90168, 36.37116], [-121.90166, 36.37091], [-121.90167, 36.37059], [-121.90307, 36.3706], [-121.90305, 36.37087], [-121.90312, 36.37125], [-121.90317, 36.3714], [-121.90343, 36.37175], [-121.9036, 36.37192], [-121.90369, 36.37199], [-121.90388, 36.37208], [-121.90399, 36.37216], [-121.90408, 36.3722], [-121.90442, 36.37228]]]} | Open Access 1 | 43080 | Unnamed site - Other State | 28654 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Monterey 14 | 8.36 | 0 | State Other or Unknown 104 | 4 | |||
4681 | 4681 | 4680 | {"type": "Polygon", "coordinates": [[[-121.45347, 35.88079], [-121.45045, 35.88079], [-121.45039, 35.87782], [-121.45083, 35.87812], [-121.45128, 35.87836], [-121.45184, 35.87897], [-121.45199, 35.87926], [-121.45214, 35.87963], [-121.45241, 35.88005], [-121.45259, 35.88039], [-121.45312, 35.88067], [-121.45347, 35.88079]]]} | Open Access 1 | 43023 | Unnamed site - Other State | 28654 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Monterey 14 | 11.034 | 0 | State Other or Unknown 104 | 4 | |||
4561 | 4561 | 4560 | {"type": "Polygon", "coordinates": [[[-121.68777, 36.44521], [-121.68564, 36.44803], [-121.68544, 36.44783], [-121.68401, 36.44774], [-121.68569, 36.44484], [-121.68595, 36.44475], [-121.68612, 36.44467], [-121.68628, 36.44455], [-121.68641, 36.44439], [-121.68648, 36.44425], [-121.68652, 36.44411], [-121.68653, 36.44396], [-121.68651, 36.44383], [-121.68652, 36.44381], [-121.68655, 36.4438], [-121.68658, 36.44382], [-121.68665, 36.44396], [-121.68679, 36.44411], [-121.68691, 36.4442], [-121.68711, 36.44428], [-121.68715, 36.44432], [-121.68717, 36.44437], [-121.68713, 36.44456], [-121.68714, 36.4447], [-121.68719, 36.44484], [-121.68728, 36.44497], [-121.6874, 36.44507], [-121.68751, 36.44513], [-121.68777, 36.44521]]]} | Open Access 1 | 35187 | Unnamed site - Other State | 28654 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Monterey 14 | 16.412 | 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 | |
4684 | 4684 | 4683 | {"type": "Polygon", "coordinates": [[[-121.44979, 35.87733], [-121.44731, 35.87732], [-121.4472, 35.87724], [-121.44693, 35.87699], [-121.44647, 35.87652], [-121.44576, 35.87561], [-121.44572, 35.87386], [-121.44723, 35.87386], [-121.44745, 35.87417], [-121.44748, 35.87437], [-121.44749, 35.87455], [-121.44772, 35.87489], [-121.44778, 35.87492], [-121.44805, 35.8752], [-121.44825, 35.87555], [-121.44833, 35.87614], [-121.44853, 35.87649], [-121.44887, 35.87663], [-121.44941, 35.87701], [-121.44966, 35.87726], [-121.44979, 35.87733]]]} | Open Access 1 | 43078 | Unnamed site - Other State | 28654 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Monterey 14 | 18.337 | 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 | |
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 | |
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 | |
4560 | 4560 | 4559 | {"type": "Polygon", "coordinates": [[[-120.34826, 34.69117], [-120.34814, 34.69379], [-120.34386, 34.69377], [-120.34383, 34.69], [-120.34826, 34.69117]]]} | Open Access 1 | 35186 | Unnamed site - Other State | 28654 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Santa Barbara 7 | 34.99 | 0 | State Other or Unknown 104 | 4 | |||
4773 | 4773 | 4772 | {"type": "MultiPolygon", "coordinates": [[[[-124.24021, 40.69417], [-124.23559, 40.69411], [-124.23559, 40.69168], [-124.23695, 40.69223], [-124.23917, 40.69269], [-124.23992, 40.69296], [-124.24019, 40.69317], [-124.24021, 40.69417]]], [[[-124.24508, 40.7334], [-124.24498, 40.73418], [-124.24133, 40.73757], [-124.24139, 40.73806], [-124.24119, 40.73823], [-124.24034, 40.73821], [-124.24066, 40.73756], [-124.24062, 40.73631], [-124.24108, 40.73545], [-124.24262, 40.73463], [-124.24508, 40.7334]]]]} | Open Access 1 | 46934 | Unnamed site - California State Lands Commission | 30557 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | Humboldt 45 | 35.708 | 0 | State Other or Unknown 104 | 4 | ||
4827 | 4827 | 4826 | {"type": "Polygon", "coordinates": [[[-118.74074, 34.07084], [-118.73649, 34.07068], [-118.73648, 34.06711], [-118.74072, 34.06713], [-118.74074, 34.07084]]]} | Open Access 1 | 48969 | Unnamed site - California Department of Parks and Recreation | 30566 | 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 | Los Angeles 6 | 39.075 | 0 | State Other or Unknown 104 | 4 | ||
5657 | 5657 | 5656 | {"type": "Polygon", "coordinates": [[[-122.55331, 38.60735], [-122.54863, 38.60741], [-122.54854, 38.60384], [-122.55324, 38.60379], [-122.55331, 38.60735]]]} | Open Access 1 | 43096 | Unnamed site - California Department of General Services | 28627 | 203 | California Department of General Services 17 | State 5 | State Agency 5 | http://www.dgs.ca.gov/default.htm | Other State 5 | 203 | California Department of General Services 17 | State 5 | State Agency 5 | Napa 11 | 40.016 | 0 | State Other or Unknown 104 | 4 | ||
4775 | 4775 | 4774 | {"type": "Polygon", "coordinates": [[[-124.15052, 40.86761], [-124.14962, 40.86842], [-124.14818, 40.86841], [-124.14656, 40.86849], [-124.1365, 40.86849], [-124.1372, 40.86837], [-124.13789, 40.86828], [-124.13851, 40.86817], [-124.14003, 40.86783], [-124.14288, 40.86717], [-124.14878, 40.86571], [-124.14929, 40.8665], [-124.15052, 40.86761]]]} | Open Access 1 | 46938 | Unnamed site - California State University | 30561 | 210 | California State University 778 | State 5 | State Agency 5 | http://www.calstate.edu/ | Other State 5 | 210 | California State University 758 | State 5 | State Agency 5 | Humboldt 45 | 42.634 | 0 | State Other or Unknown 104 | 4 | ||
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 | |
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 | |
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]);