units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
86 rows where MNG_AGENCY = 73 and MNG_AG_TYP = 5 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, LABEL_NAME, YR_EST, GAP_STS
SUID_NMA 11 ✖
DES_TP 8
- State Resource Management Area 79
- State Park 1
- None 1
- None 1
- None 1
- State Other or Unknown 1
- None 1
- None 1
ACCESS_TYP 4
MNG_AG_TYP 1
- State Agency · 86 ✖
MNG_AGENCY 1
- California State Lands Commission · 86 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
190 | 190 | 189 | {"type": "Polygon", "coordinates": [[[-119.54817, 34.40521], [-119.54802, 34.4054], [-119.54792, 34.40532], [-119.54714, 34.40436], [-119.54706, 34.40429], [-119.54684, 34.40419], [-119.54661, 34.40416], [-119.54636, 34.40425], [-119.54631, 34.40432], [-119.54628, 34.40444], [-119.5462, 34.40436], [-119.54604, 34.40426], [-119.54606, 34.40336], [-119.54817, 34.40521]]]} | Open Access 1 | 524 | Santa Claus Lane Beach | 25061 | 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 | Santa Barbara 7 | 1.665 | Santa Claus Lane Beach | None 20 | |||
15513 | 15513 | 15512 | {"type": "Polygon", "coordinates": [[[-121.03855, 39.55161], [-121.03816, 39.55198], [-121.0378, 39.55215], [-121.03733, 39.55232], [-121.03708, 39.55244], [-121.03705, 39.55083], [-121.03851, 39.55084], [-121.03849, 39.55098], [-121.0385, 39.5513], [-121.03855, 39.55161]]]} | Open Access 1 | 44776 | California State Lands Commission | 16724 | 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 | Sierra 58 | 4.373 | SLC | 0 | State Resource Management Area 55 | 3 | |
11563 | 11563 | 11562 | {"type": "Polygon", "coordinates": [[[-122.064, 36.98385], [-122.06366, 36.98401], [-122.06267, 36.98408], [-122.06257, 36.98463], [-122.06235, 36.98486], [-122.06189, 36.98495], [-122.06155, 36.98351], [-122.06155, 36.98317], [-122.06189, 36.98305], [-122.06343, 36.98349], [-122.06394, 36.98377], [-122.064, 36.98385]]]} | Open Access 1 | 23588 | California State Lands Commission | 16724 | 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 | Santa Cruz 5 | 5.72 | SLC | 0 | State Resource Management Area 55 | 3 | |
4169 | 4169 | 4168 | {"type": "Polygon", "coordinates": [[[-118.14515, 34.4821], [-118.14512, 34.48211], [-118.14511, 34.48207], [-118.14435, 34.48228], [-118.14374, 34.48241], [-118.14324, 34.48247], [-118.1425, 34.48253], [-118.14203, 34.48261], [-118.14157, 34.48276], [-118.14072, 34.48318], [-118.14071, 34.48255], [-118.14128, 34.48233], [-118.14154, 34.48224], [-118.1419, 34.48215], [-118.14259, 34.48201], [-118.14311, 34.48194], [-118.14358, 34.48191], [-118.14389, 34.48186], [-118.14452, 34.48171], [-118.14514, 34.48153], [-118.14515, 34.4821]]]} | Open Access 1 | 44770 | California State Lands Commission | 16724 | 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 | Los Angeles 6 | 5.937 | SLC | 0 | State Resource Management Area 55 | 3 | |
10442 | 10442 | 10441 | {"type": "MultiPolygon", "coordinates": [[[[-121.13401, 39.37997], [-121.1337, 39.38361], [-121.13238, 39.38371], [-121.13257, 39.38008], [-121.13401, 39.37997]]], [[[-121.59067, 39.13306], [-121.59041, 39.13391], [-121.58999, 39.13382], [-121.59013, 39.13324], [-121.59017, 39.13271], [-121.59067, 39.13306]]]]} | Open Access 1 | 18454 | California State Lands Commission | 16724 | 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 | Yuba 25 | 12.838 | SLC | 0 | State Resource Management Area 55 | 3 | |
15765 | 15765 | 15764 | {"type": "MultiPolygon", "coordinates": [[[[-115.41577, 33.9071], [-115.41501, 33.90797], [-115.41501, 33.90797], [-115.41501, 33.90709], [-115.41577, 33.9071]]], [[[-115.42113, 33.90913], [-115.42096, 33.90966], [-115.42064, 33.90959], [-115.418, 33.91076], [-115.41661, 33.91075], [-115.42056, 33.909], [-115.42113, 33.90913]]], [[[-115.42044, 33.90739], [-115.41978, 33.90743], [-115.41945, 33.9035], [-115.42011, 33.90351], [-115.42044, 33.90739]]]]} | Open Access 1 | 44795 | California State Lands Commission | 16724 | 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 | Riverside 10 | 13.226 | SLC | 0 | State Resource Management Area 55 | 3 | |
16867 | 16867 | 16866 | {"type": "Polygon", "coordinates": [[[-121.04176, 39.55452], [-121.0371, 39.55445], [-121.03708, 39.55244], [-121.03733, 39.55232], [-121.0378, 39.55215], [-121.03816, 39.55198], [-121.03855, 39.55162], [-121.0385, 39.5513], [-121.03849, 39.55097], [-121.03851, 39.55084], [-121.03854, 39.55083], [-121.04171, 39.55088], [-121.04176, 39.55452]]]} | Open Access 1 | 44775 | California State Lands Commission | 16724 | 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 | Yuba 25 | 35.62 | SLC | 0 | State Resource Management Area 55 | 3 | |
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 | ||
16883 | 16883 | 16882 | {"type": "Polygon", "coordinates": [[[-120.15748, 38.50084], [-120.15296, 38.5007], [-120.15273, 38.49714], [-120.15729, 38.49728], [-120.15748, 38.50084]]]} | Open Access 1 | 44767 | California State Lands Commission | 16724 | 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 | Amador 52 | 38.652 | SLC | 0 | State Resource Management Area 55 | 3 | |
16834 | 16834 | 16833 | {"type": "Polygon", "coordinates": [[[-119.9027, 37.22836], [-119.90274, 37.22877], [-119.90272, 37.22927], [-119.90266, 37.22968], [-119.90248, 37.23018], [-119.9021, 37.23082], [-119.90181, 37.23124], [-119.9015, 37.23159], [-119.90102, 37.23201], [-119.90008, 37.2326], [-119.89985, 37.23279], [-119.89973, 37.23295], [-119.89961, 37.23347], [-119.89943, 37.23413], [-119.89898, 37.2347], [-119.89853, 37.23526], [-119.89787, 37.23589], [-119.89667, 37.23681], [-119.8961, 37.23705], [-119.89555, 37.23721], [-119.89432, 37.2372], [-119.89379, 37.23705], [-119.89303, 37.23669], [-119.89233, 37.23613], [-119.89202, 37.23595], [-119.89153, 37.23577], [-119.89115, 37.23556], [-119.89085, 37.23549], [-119.8906, 37.23546], [-119.89015, 37.23545], [-119.88983, 37.23546], [-119.88925, 37.23573], [-119.88862, 37.23611], [-119.88862, 37.23476], [-119.88945, 37.23437], [-119.89016, 37.23435], [-119.89074, 37.23437], [-119.89115, 37.23442], [-119.89175, 37.23456], [-119.8922, 37.23481], [-119.89273, 37.235], [-119.89323, 37.23531], [-119.89388, 37.23582], [-119.89438, 37.23605], [-119.89457, 37.23611], [-119.89531, 37.23611], [-119.89554, 37.23604], [-119.89585, 37.23591], [-119.89687, 37.23514], [-119.89742, 37.23461], [-119.89813, 37.23372], [-119.89826, 37.23325], [-119.89842, 37.23256], [-119.89874, 37.23213], [-119.89915, 37.23179], [-119.90008, 37.2312], [-119.90042, 37.2309], [-119.90064, 37.23066], [-119.90087, 37.23032], [-119.90119, 37.22978], [-119.90131, 37.22946], [-119.90135, 37.22919], [-119.90137, 37.22879], [-119.90132, 37.22836], [-119.9027, 37.22836]]]} | Open Access 1 | 44771 | California State Lands Commission | 16724 | 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 | Madera 48 | 55.076 | SLC | 0 | State Resource Management Area 55 | 3 | |
16593 | 16593 | 16592 | {"type": "MultiPolygon", "coordinates": [[[[-122.5586, 38.6838], [-122.55473, 38.68451], [-122.55398, 38.68451], [-122.55398, 38.68085], [-122.55859, 38.68086], [-122.5586, 38.6838]]], [[[-122.58595, 38.67705], [-122.58595, 38.67735], [-122.57684, 38.67946], [-122.57685, 38.67727], [-122.58595, 38.67705]]]]} | Open Access 1 | 44758 | California State Lands Commission | 16724 | 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 | Napa 11 | 64.112 | SLC | 0 | State Resource Management Area 55 | 3 | |
16840 | 16840 | 16839 | {"type": "MultiPolygon", "coordinates": [[[[-119.76601, 36.91962], [-119.7636, 36.92003], [-119.76289, 36.9203], [-119.76261, 36.91997], [-119.76318, 36.91981], [-119.76576, 36.919], [-119.76601, 36.91962]]], [[[-119.76278, 36.92035], [-119.76224, 36.92064], [-119.75912, 36.92058], [-119.75532, 36.92228], [-119.75435, 36.92355], [-119.75383, 36.9233], [-119.75406, 36.92285], [-119.75457, 36.92223], [-119.7565, 36.92094], [-119.7579, 36.92044], [-119.75879, 36.92034], [-119.7601, 36.91999], [-119.76219, 36.92011], [-119.76246, 36.92003], [-119.76278, 36.92035]]], [[[-119.7554, 36.93223], [-119.7545, 36.93259], [-119.75399, 36.93406], [-119.75335, 36.93405], [-119.75361, 36.93256], [-119.75229, 36.93156], [-119.75185, 36.9301], [-119.75138, 36.92834], [-119.75133, 36.92752], [-119.75223, 36.92685], [-119.75258, 36.92621], [-119.75267, 36.92492], [-119.75326, 36.92447], [-119.75379, 36.9234], [-119.75425, 36.92364], [-119.75347, 36.9264], [-119.75359, 36.92689], [-119.75403, 36.92733], [-119.75444, 36.92871], [-119.75448, 36.92903], [-119.75459, 36.92926], [-119.755, 36.92976], [-119.75507, 36.93094], [-119.7554, 36.93223]]]]} | Open Access 1 | 16689 | California State Lands Commission | 16724 | 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 | Madera 48 | 65.906 | SLC | 0 | State Resource Management Area 55 | 3 | |
4168 | 4168 | 4167 | {"type": "MultiPolygon", "coordinates": [[[[-120.63132, 38.61416], [-120.63122, 38.61777], [-120.62662, 38.61765], [-120.62672, 38.61404], [-120.63132, 38.61416]]], [[[-120.67404, 38.69789], [-120.67403, 38.70149], [-120.67175, 38.70148], [-120.67176, 38.69788], [-120.67404, 38.69789]]], [[[-120.69234, 38.70875], [-120.69234, 38.71055], [-120.69004, 38.71055], [-120.69004, 38.70966], [-120.69119, 38.70965], [-120.69119, 38.70875], [-120.69234, 38.70875]]]]} | Open Access 1 | 44768 | California State Lands Commission | 16724 | 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 | El Dorado 34 | 66.735 | SLC | 0 | State Resource Management Area 55 | 3 | |
16863 | 16863 | 16862 | {"type": "MultiPolygon", "coordinates": [[[[-120.09215, 35.07196], [-120.08828, 35.07201], [-120.08808, 35.06832], [-120.09206, 35.06824], [-120.09215, 35.07196]]], [[[-120.10135, 35.06803], [-120.09724, 35.0681], [-120.09722, 35.06445], [-120.10124, 35.06441], [-120.10135, 35.06803]]]]} | Open Access 1 | 44774 | California State Lands Commission | 16724 | 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 | Santa Barbara 7 | 73.387 | SLC | 0 | State Resource Management Area 55 | 3 | |
16862 | 16862 | 16861 | {"type": "Polygon", "coordinates": [[[-121.36711, 40.14473], [-121.3671, 40.15548], [-121.36417, 40.15546], [-121.36414, 40.14476], [-121.36711, 40.14473]]]} | Open Access 1 | 44773 | California State Lands Commission | 16724 | 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 | Plumas 57 | 73.975 | SLC | 0 | State Resource Management Area 55 | 3 | |
16424 | 16424 | 16423 | {"type": "Polygon", "coordinates": [[[-120.75625, 39.34502], [-120.75579, 39.34604], [-120.74658, 39.34587], [-120.74638, 39.34242], [-120.75565, 39.34249], [-120.7561, 39.34484], [-120.75625, 39.34502]]]} | Open Access 1 | 44772 | California State Lands Commission | 16724 | 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 | Nevada 30 | 78.319 | SLC | 0 | State Resource Management Area 55 | 3 | |
12983 | 12983 | 12982 | {"type": "Polygon", "coordinates": [[[-119.01902, 36.735], [-119.019, 36.73858], [-119.01004, 36.73851], [-119.01008, 36.73493], [-119.01902, 36.735]]]} | Open Access 1 | 44769 | California State Lands Commission | 16724 | 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 | Fresno 9 | 78.552 | SLC | 0 | State Resource Management Area 55 | 3 | |
2275 | 2275 | 2274 | {"type": "Polygon", "coordinates": [[[-119.98568, 37.56734], [-119.98545, 37.56713], [-119.98536, 37.56702], [-119.98533, 37.56689], [-119.98526, 37.56633], [-119.9852, 37.5661], [-119.98512, 37.566], [-119.98497, 37.56586], [-119.98357, 37.56529], [-119.98338, 37.56523], [-119.98293, 37.56515], [-119.98262, 37.56515], [-119.98237, 37.56516], [-119.98185, 37.5653], [-119.98184, 37.56539], [-119.98083, 37.56535], [-119.98087, 37.55765], [-119.98536, 37.55764], [-119.98542, 37.5624], [-119.98543, 37.56466], [-119.98188, 37.56457], [-119.98185, 37.5651], [-119.98186, 37.56511], [-119.98233, 37.56499], [-119.98261, 37.56497], [-119.98295, 37.56497], [-119.98314, 37.56499], [-119.98345, 37.56506], [-119.98367, 37.56513], [-119.98512, 37.56572], [-119.98531, 37.56589], [-119.98542, 37.56603], [-119.98551, 37.56644], [-119.98555, 37.56687], [-119.98558, 37.56695], [-119.98568, 37.56706], [-119.98568, 37.56734]]]} | Open Access 1 | 16825 | California State Lands Commission | 16724 | 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 | Mariposa 31 | 81.091 | SLC | 0 | State Resource Management Area 55 | 3 | |
16362 | 16362 | 16361 | {"type": "Polygon", "coordinates": [[[-119.89135, 38.76567], [-119.89129, 38.77295], [-119.88657, 38.7729], [-119.88658, 38.76567], [-119.89135, 38.76567]]]} | Open Access 1 | 44766 | California State Lands Commission | 16724 | 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 | Alpine 51 | 82.078 | SLC | 0 | State Resource Management Area 55 | 3 | |
7960 | 7960 | 7959 | {"type": "Polygon", "coordinates": [[[-116.77151, 33.12419], [-116.76285, 33.1242], [-116.76283, 33.12035], [-116.7715, 33.12036], [-116.77151, 33.12419]]]} | Open Access 1 | 12841 | California State Lands Commission | 16724 | 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 | San Diego 4 | 85.079 | SLC | 0 | State Resource Management Area 55 | 3 |
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]);