units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
79 rows where DES_TP = 55 and MNG_AGENCY = 73
This data as json, copyable, CSV (advanced)
ACCESS_TYP 4
MNG_AG_TYP 1
- State Agency 59
MNG_AGENCY 1
- California State Lands Commission · 59 ✖
DES_TP 1
- State Resource Management Area · 59 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
12265 | 12265 | 12264 | {"type": "Polygon", "coordinates": [[[-122.53034, 38.61119], [-122.52572, 38.61121], [-122.52574, 38.61484], [-122.52112, 38.61486], [-122.52091, 38.614], [-122.52089, 38.61399], [-122.52101, 38.61821], [-122.51659, 38.61803], [-122.51647, 38.6144], [-122.51625, 38.60714], [-122.52067, 38.60732], [-122.52401, 38.60734], [-122.53031, 38.60743], [-122.53034, 38.61119]]]} | No Public Access 3 | 25816 | California State Lands Commission | 16723 | 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 | 245.258 | SLC | 0 | State Resource Management Area 55 | 3 | |
12926 | 12926 | 12925 | {"type": "Polygon", "coordinates": [[[-117.94244, 34.17999], [-117.92493, 34.18006], [-117.9247, 34.16904], [-117.92478, 34.16739], [-117.92476, 34.16531], [-117.94231, 34.16524], [-117.94224, 34.16864], [-117.94244, 34.17999]]]} | Unknown Access 4 | 44746 | California State Lands Commission | 16726 | 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 | 653.218 | 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 | |
14330 | 14330 | 14329 | {"type": "Polygon", "coordinates": [[[-121.35088, 40.9054], [-121.35078, 40.90893], [-121.34677, 40.90892], [-121.34658, 40.91981], [-121.34648, 40.91985], [-121.33442, 40.91971], [-121.33131, 40.91966], [-121.33175, 40.90581], [-121.33418, 40.90581], [-121.33418, 40.90513], [-121.35088, 40.9054]]]} | Restricted Access 2 | 44318 | California State Lands Commission | 16725 | 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 | Shasta 27 | 539.61 | 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 | |
14618 | 14618 | 14617 | {"type": "Polygon", "coordinates": [[[-115.71453, 35.03003], [-115.71447, 35.04386], [-115.69802, 35.04386], [-115.69803, 35.03], [-115.71453, 35.03003]]]} | Restricted Access 2 | 44845 | California State Lands Commission | 16725 | 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 | 570.632 | 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 |
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]);