units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
81 rows where ACCESS_TYP = 1 and DES_TP = 55 sorted by UNIT_NAME
This data as json, copyable, CSV (advanced)
MNG_AGENCY 3
MNG_AG_TYP 1
- State Agency 61
DES_TP 1
- State Resource Management Area · 61 ✖
ACCESS_TYP 1
- Open Access · 61 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11548 | 11548 | 11547 | {"type": "Polygon", "coordinates": [[[-121.01476, 41.91316], [-121.01476, 41.9204], [-121.00504, 41.92032], [-121.00501, 41.91672], [-120.99031, 41.91664], [-120.99007, 41.91308], [-121.00499, 41.91311], [-121.00502, 41.91671], [-121.00986, 41.91674], [-121.00987, 41.91673], [-121.00986, 41.91312], [-121.01476, 41.91316]]]} | Open Access 1 | 23627 | 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 | Modoc 56 | 241.472 | SLC | 0 | State Resource Management Area 55 | 3 | |
11562 | 11562 | 11561 | {"type": "Polygon", "coordinates": [[[-120.16674, 38.50827], [-120.15343, 38.50783], [-120.1532, 38.50427], [-120.16663, 38.5047], [-120.16674, 38.50827]]]} | Open Access 1 | 23576 | 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 | 113.944 | 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 | |
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 | |
14331 | 14331 | 14330 | {"type": "Polygon", "coordinates": [[[-115.76535, 35.61555], [-115.74758, 35.61563], [-115.74758, 35.60112], [-115.76532, 35.60093], [-115.76535, 35.61555]]]} | Open Access 1 | 44321 | 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 Bernardino 22 | 642.434 | SLC | 0 | State Resource Management Area 55 | 3 | |
14332 | 14332 | 14331 | {"type": "Polygon", "coordinates": [[[-115.00291, 34.87591], [-114.9853, 34.87592], [-114.98527, 34.86141], [-115.0029, 34.8614], [-115.00291, 34.87591]]]} | Open Access 1 | 44323 | 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 Bernardino 22 | 640.775 | SLC | 0 | State Resource Management Area 55 | 3 | |
14371 | 14371 | 14370 | {"type": "Polygon", "coordinates": [[[-115.26829, 34.55721], [-115.26828, 34.57171], [-115.25094, 34.57173], [-115.25091, 34.5681], [-115.2509, 34.55723], [-115.26056, 34.55721], [-115.26829, 34.55721]]]} | Open Access 1 | 44455 | 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 Bernardino 22 | 633.958 | SLC | 0 | State Resource Management Area 55 | 3 | |
14574 | 14574 | 14573 | {"type": "MultiPolygon", "coordinates": [[[[-115.27382, 35.21487], [-115.25611, 35.21492], [-115.2561, 35.21221], [-115.25612, 35.20769], [-115.25612, 35.20045], [-115.2738, 35.2004], [-115.27382, 35.21487]]], [[[-115.60685, 35.11645], [-115.60683, 35.13095], [-115.58867, 35.13096], [-115.58869, 35.11646], [-115.60685, 35.11645]]], [[[-115.7169, 35.21831], [-115.69787, 35.21826], [-115.69773, 35.20367], [-115.71685, 35.2037], [-115.7169, 35.21831]]], [[[-115.77179, 35.33564], [-115.77167, 35.34969], [-115.75363, 35.3497], [-115.75389, 35.33585], [-115.77179, 35.33564]]], [[[-115.93462, 35.13209], [-115.91697, 35.13165], [-115.9169, 35.1244], [-115.9168, 35.11715], [-115.93444, 35.11754], [-115.93462, 35.13209]]]]} | Open Access 1 | 44745 | 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 Bernardino 22 | 3258.082 | SLC | 0 | State Resource Management Area 55 | 3 | |
14581 | 14581 | 14580 | {"type": "MultiPolygon", "coordinates": [[[[-120.03471, 41.86345], [-120.01526, 41.8635], [-120.01527, 41.85244], [-120.02011, 41.85252], [-120.02022, 41.8488], [-120.03463, 41.84892], [-120.03471, 41.86345]]], [[[-120.04633, 41.6883], [-120.02696, 41.68821], [-120.0269, 41.67368], [-120.04619, 41.67391], [-120.04633, 41.6883]]], [[[-120.04675, 41.51419], [-120.02739, 41.51418], [-120.02743, 41.49983], [-120.04672, 41.49973], [-120.04675, 41.51419]]], [[[-120.04814, 41.77623], [-120.02874, 41.77636], [-120.0287, 41.76148], [-120.0481, 41.76138], [-120.04814, 41.77623]]], [[[-120.09123, 41.72831], [-120.08644, 41.72823], [-120.08643, 41.71744], [-120.0887, 41.71744], [-120.08886, 41.71797], [-120.0892, 41.71888], [-120.08922, 41.71902], [-120.08925, 41.71998], [-120.08923, 41.72034], [-120.08926, 41.72061], [-120.08939, 41.72088], [-120.08953, 41.72106], [-120.08969, 41.7212], [-120.08974, 41.72128], [-120.08981, 41.7216], [-120.09006, 41.72374], [-120.09027, 41.72515], [-120.09095, 41.72658], [-120.09099, 41.72671], [-120.09097, 41.72719], [-120.09104, 41.72734], [-120.09123, 41.72764], [-120.09123, 41.72831]]], [[[-120.10578, 41.72154], [-120.10462, 41.72327], [-120.10182, 41.72432], [-120.10022, 41.72568], [-120.10096, 41.73181], [-120.09612, 41.73181], [-120.09623, 41.72839], [-120.09134, 41.72831], [-120.09134, 41.72762], [-120.0913, 41.72753], [-120.09114, 41.72731], [-120.09108, 41.72717], [-120.0911, 41.7267], [-120.09106, 41.72656], [-120.09038, 41.72513], [-120.09017, 41.72373], [-120.08992, 41.72159], [-120.08984, 41.72126], [-120.08979, 41.72116], [-120.08955, 41.72093], [-120.08949, 41.72084], [-120.08936, 41.72059], [-120.08934, 41.72034], [-120.08936, 41.71998], [-120.08933, 41.71901], [-120.08931, 41.71887], [-120.08897, 41.71795], [-120.08881, 41.71744], [-120.09616, 41.71744], [-120.10577, 41.71734], [-120.10578, 41.72154]]], [[[-120.1481, 41.60023], [-120.14805, 41.60233], [-120.1432, 41.60226], [-120.14321, 41.59826], [-120.14458, 41.60079], [-120.1481, 41.60023]]], [[[-120.25835, 41.94328], [-120.25353, 41.94324], [-120.25343, 41.93598], [-120.25829, 41.93597], [-120.25835, 41.94328]]], [[[-120.48647, 41.66042], [-120.4668, 41.6606], [-120.46683, 41.64603], [-120.48635, 41.64594], [-120.48647, 41.66042]]], [[[-120.87697, 41.93055], [-120.87697, 41.93417], [-120.87334, 41.93416], [-120.87331, 41.93054], [-120.87697, 41.93055]]], [[[-120.95282, 41.68619], [-120.94791, 41.68629], [-120.94313, 41.68636], [-120.94296, 41.67901], [-120.9474, 41.67906], [-120.95235, 41.679], [-120.95282, 41.68619]]], [[[-120.95369, 41.823], [-120.95368, 41.82662], [-120.94875, 41.82658], [-120.94881, 41.82296], [-120.94398, 41.82292], [-120.94403, 41.81941], [-120.94887, 41.8194], [-120.94881, 41.82296], [-120.95369, 41.823]]], [[[-121.16915, 41.74891], [-121.16424, 41.74888], [-121.16422, 41.74528], [-121.16913, 41.74531], [-121.16915, 41.74891]]], [[[-121.30003, 41.99731], [-121.29512, 41.99737], [-121.29506, 41.99424], [-121.29995, 41.9943], [-121.30003, 41.99731]]]]} | Open Access 1 | 44718 | 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 | Modoc 56 | 4096.771 | SLC | 0 | State Resource Management Area 55 | 3 | |
14803 | 14803 | 14802 | {"type": "MultiPolygon", "coordinates": [[[[-116.17464, 32.69733], [-116.15733, 32.69758], [-116.15691, 32.68285], [-116.17365, 32.68294], [-116.17464, 32.69733]]], [[[-116.67842, 32.77602], [-116.67832, 32.78694], [-116.67406, 32.78701], [-116.67408, 32.77962], [-116.67412, 32.77604], [-116.67842, 32.77602]]]]} | Open Access 1 | 45219 | 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 | 757.572 | SLC | 0 | State Resource Management Area 55 | 3 | |
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 | |
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 | |
16332 | 16332 | 16331 | {"type": "Polygon", "coordinates": [[[-120.85499, 39.14173], [-120.85496, 39.14255], [-120.85496, 39.14519], [-120.85489, 39.1452], [-120.8549, 39.14874], [-120.84548, 39.1481], [-120.84538, 39.14426], [-120.85019, 39.1447], [-120.85017, 39.14118], [-120.85499, 39.14173]]]} | Open Access 1 | 44761 | 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 | Placer 35 | 122.823 | SLC | 0 | State Resource Management Area 55 | 3 | |
16352 | 16352 | 16351 | {"type": "Polygon", "coordinates": [[[-117.3542, 33.60498], [-117.34984, 33.60488], [-117.34984, 33.60123], [-117.34548, 33.60113], [-117.3455, 33.59749], [-117.35419, 33.59768], [-117.3542, 33.60498]]]} | Open Access 1 | 44762 | 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 | 121.181 | SLC | 0 | State Resource Management Area 55 | 3 | |
16357 | 16357 | 16356 | {"type": "MultiPolygon", "coordinates": [[[[-119.40892, 37.09687], [-119.40888, 37.10414], [-119.40433, 37.10414], [-119.40438, 37.09688], [-119.40892, 37.09687]]], [[[-119.41801, 37.10775], [-119.41344, 37.10776], [-119.41343, 37.11139], [-119.40885, 37.1114], [-119.40887, 37.10777], [-119.41344, 37.10776], [-119.41346, 37.09687], [-119.418, 37.09686], [-119.41801, 37.10775]]]]} | Open Access 1 | 44763 | 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 | 242.067 | 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 | |
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 | |
16582 | 16582 | 16581 | {"type": "MultiPolygon", "coordinates": [[[[-119.71974, 35.2303], [-119.71972, 35.23372], [-119.71531, 35.23371], [-119.71533, 35.23026], [-119.70652, 35.23018], [-119.70654, 35.22655], [-119.70214, 35.2265], [-119.70217, 35.22287], [-119.70658, 35.22291], [-119.70661, 35.21927], [-119.71102, 35.21932], [-119.71099, 35.22295], [-119.70658, 35.22291], [-119.70655, 35.22654], [-119.71537, 35.22663], [-119.71534, 35.23026], [-119.71974, 35.2303]]], [[[-119.77399, 35.04841], [-119.76497, 35.04846], [-119.7649, 35.04519], [-119.76936, 35.04515], [-119.76928, 35.04158], [-119.75627, 35.04163], [-119.75623, 35.03425], [-119.77383, 35.03421], [-119.77399, 35.04841]]]]} | Open Access 1 | 44756 | 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 Luis Obispo 1 | 638.28 | 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 | |
16681 | 16681 | 16680 | {"type": "MultiPolygon", "coordinates": [[[[-120.32573, 37.85571], [-120.32111, 37.85566], [-120.31648, 37.85557], [-120.31634, 37.84848], [-120.3256, 37.84859], [-120.32573, 37.85571]]], [[[-120.39171, 38.0782], [-120.37783, 38.07796], [-120.37779, 38.07702], [-120.37763, 38.07058], [-120.37785, 38.0706], [-120.38224, 38.07064], [-120.38236, 38.07434], [-120.39154, 38.07447], [-120.39171, 38.0782]]], [[[-120.41404, 38.07256], [-120.40966, 38.0724], [-120.40965, 38.07241], [-120.40965, 38.07255], [-120.40517, 38.07249], [-120.40503, 38.07069], [-120.40411, 38.07069], [-120.40397, 38.06968], [-120.40045, 38.06972], [-120.40021, 38.06699], [-120.40477, 38.06696], [-120.4047, 38.066], [-120.40466, 38.06494], [-120.41336, 38.06492], [-120.41374, 38.06494], [-120.41373, 38.06519], [-120.41377, 38.06623], [-120.41397, 38.0706], [-120.41404, 38.07256]]], [[[-120.54921, 37.89979], [-120.54451, 37.90234], [-120.54289, 37.90189], [-120.54273, 37.90178], [-120.5427, 37.89895], [-120.54269, 37.89619], [-120.54608, 37.89771], [-120.54619, 37.89777], [-120.54776, 37.89846], [-120.54845, 37.89908], [-120.5487, 37.89935], [-120.54921, 37.89979]]]]} | Open Access 1 | 552 | 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 | Tuolumne 21 | 576.163 | 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]);