units_with_maps

Table actions

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

136 rows where ACCESS_TYP = 3, AGNCY_LEV = 5 and MNG_AG_TYP = 5

This data as json, copyable, CSV (advanced)

Suggested facets: AGNCY_NAME, AGNCY_WEB, MNG_AG_ID, GAP_STS

MNG_AG_TYP 1

  • State Agency · 136 ✖

ACCESS_TYP 1

  • No Public Access · 136 ✖
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
25 25 24 {"type": "Polygon", "coordinates": [[[-122.27747, 38.29885], [-122.27706, 38.29891], [-122.27702, 38.29871], [-122.27743, 38.29865], [-122.27747, 38.29885]]]} No Public Access 3 64 Real Estate Services Division 24211 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 0.203 Real Estate Services Division   None 6  
228 228 227 {"type": "Polygon", "coordinates": [[[-122.33028, 41.31414], [-122.32908, 41.31415], [-122.32909, 41.31022], [-122.32966, 41.31067], [-122.33018, 41.31094], [-122.33021, 41.31196], [-122.33028, 41.31197], [-122.33028, 41.31414]]]} No Public Access 3 621 Elsa Rupp Natural Area 32160 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 9.475 Elsa Rupp Natural Area   None 26  
545 545 544 {"type": "Polygon", "coordinates": [[[-122.31307, 41.2763], [-122.31264, 41.2763], [-122.31266, 41.2752], [-122.31307, 41.2752], [-122.31307, 41.2763]]]} No Public Access 3 1814 Lower Box Canyon 32208 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 1.061 Lower Box Canyon 0 State Resource Management Area 55 3
1130 1130 1129 {"type": "Polygon", "coordinates": [[[-118.05045, 37.26696], [-118.05032, 37.28884], [-118.04578, 37.2888], [-118.0458, 37.28518], [-118.04122, 37.28514], [-118.04125, 37.28152], [-118.03671, 37.28148], [-118.03674, 37.27786], [-118.03221, 37.27783], [-118.0323, 37.26688], [-118.05045, 37.26696]]]} No Public Access 3 6619 Deep Springs Lake 32146 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   Inyo 43 725.874 Deep Springs Lake 0 State Resource Management Area 55 3
1316 1316 1315 {"type": "Polygon", "coordinates": [[[-116.74116, 32.57636], [-116.74114, 32.58363], [-116.73714, 32.58342], [-116.73291, 32.5834], [-116.73278, 32.58732], [-116.72047, 32.58718], [-116.72045, 32.58913], [-116.70751, 32.5894], [-116.69094, 32.5893], [-116.69082, 32.58084], [-116.69077, 32.57124], [-116.73696, 32.56738], [-116.73704, 32.56906], [-116.74116, 32.5691], [-116.74116, 32.5727], [-116.73707, 32.57263], [-116.73709, 32.57623], [-116.74116, 32.57636]]]} No Public Access 3 7399 Kuchamaa Experimental Forest 20729 202 California Department of Forestry and Fire Protection 346 State 5 State Agency 5 http://www.fire.ca.gov/ Other State 5 202 California Department of Forestry and Fire Protection 343 State 5 State Agency 5   San Diego 4 2363.684 Kuchamaa Experimental Forest 0 None 113  
1331 1331 1330 {"type": "Polygon", "coordinates": [[[-117.30505, 33.972], [-117.30065, 33.97196], [-117.30065, 33.97556], [-117.29645, 33.97552], [-117.2965, 33.96463], [-117.30083, 33.96465], [-117.30087, 33.96815], [-117.30505, 33.96813], [-117.30505, 33.972]]]} No Public Access 3 47644 Box Springs Reserve 31388 217 University of California 53 State 5 State Agency 5 http://nrs.ucop.edu/ Other State 5 217 University of California 51 State 5 State Agency 5 http://www.ucnrs.org/reserves/box-springs-reserve.html Riverside 10 159.828 Box Springs Reserve 0 State Conservation Area 8 2
1332 1332 1331 {"type": "Polygon", "coordinates": [[[-116.45768, 34.14968], [-116.45334, 34.1497], [-116.45333, 34.15015], [-116.45115, 34.15016], [-116.45115, 34.14929], [-116.44898, 34.1493], [-116.44892, 34.13524], [-116.45764, 34.13534], [-116.45767, 34.14247], [-116.45768, 34.14968]], [[-116.45762, 34.14811], [-116.45654, 34.14811], [-116.45653, 34.14608], [-116.45332, 34.1461], [-116.45333, 34.14699], [-116.45654, 34.14833], [-116.45761, 34.14833], [-116.45762, 34.14811]]]} No Public Access 3 47645 Burns Piñon Ridge Reserve 31389 217 University of California 53 State 5 State Agency 5 http://nrs.ucop.edu/ Other State 5 217 University of California 51 State 5 State Agency 5 http://www.ucnrs.org/reserves/burns-pinon-ridge-reserve.html San Bernardino 22 304.422 Burns Piñon Ridge Reserve 0 State Conservation Area 8 2
1362 1362 1361 {"type": "MultiPolygon", "coordinates": [[[[-120.54592, 36.6911], [-120.53904, 36.69108], [-120.53903, 36.68751], [-120.53931, 36.68748], [-120.53932, 36.67661], [-120.53965, 36.67662], [-120.54592, 36.6911]]], [[[-120.54644, 36.69054], [-120.54632, 36.69071], [-120.54625, 36.69074], [-120.54003, 36.67662], [-120.54028, 36.67664], [-120.54644, 36.69054]]]]} No Public Access 3 8074 Pilobos 32263 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 134.36 Pilobos 0 State Resource Management Area 55 3
1551 1551 1550 {"type": "Polygon", "coordinates": [[[-117.15937, 33.4648], [-117.15693, 33.46596], [-117.15546, 33.46627], [-117.1551, 33.46876], [-117.15582, 33.4699], [-117.15547, 33.4701], [-117.15359, 33.47159], [-117.15293, 33.47188], [-117.14835, 33.47303], [-117.14752, 33.4732], [-117.14553, 33.47346], [-117.1454, 33.4735], [-117.1452, 33.47361], [-117.14441, 33.47424], [-117.14428, 33.4744], [-117.14423, 33.47451], [-117.14422, 33.47465], [-117.14428, 33.47512], [-117.14445, 33.47524], [-117.14434, 33.47534], [-117.14243, 33.47398], [-117.14117, 33.47457], [-117.1392, 33.47439], [-117.13887, 33.4735], [-117.14494, 33.46886], [-117.14521, 33.46914], [-117.14523, 33.46914], [-117.14519, 33.46582], [-117.15408, 33.46502], [-117.15937, 33.4648]]]} No Public Access 3 11546 Santa Margarita Ecological Reserve 33343 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 221 San Diego State University 378 State 5 State Agency 5 https://fsp.sdsu.edu/about-us/ Riverside 10 243.178 Santa Margarita ER 1962 State Conservation Area 8 2
1581 1581 1580 {"type": "Polygon", "coordinates": [[[-115.54599, 33.539], [-115.53693, 33.53898], [-115.53689, 33.53374], [-115.53922, 33.53373], [-115.53931, 33.53565], [-115.54152, 33.53564], [-115.54145, 33.53741], [-115.54597, 33.53769], [-115.54599, 33.539]]]} No Public Access 3 12128 Chuckwalla Bench 32115 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   Riverside 10 66.962 Chuckwalla Bench 0 State Resource Management Area 55 3
1949 1949 1948 {"type": "Polygon", "coordinates": [[[-119.3411, 35.24915], [-119.33804, 35.25071], [-119.33274, 35.25344], [-119.32347, 35.25337], [-119.32342, 35.24243], [-119.33225, 35.24252], [-119.3322, 35.23881], [-119.34107, 35.23889], [-119.3411, 35.24915]]]} No Public Access 3 16653 Elk Hills 32158 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   Kern 36 517.552 Elk Hills 0 State Resource Management Area 55 3
1956 1956 1955 {"type": "Polygon", "coordinates": [[[-117.8303, 35.57191], [-117.83026, 35.57926], [-117.82582, 35.57925], [-117.82581, 35.58284], [-117.82577, 35.58649], [-117.82128, 35.58644], [-117.82132, 35.58281], [-117.82141, 35.57924], [-117.82581, 35.57924], [-117.82587, 35.57561], [-117.82586, 35.5756], [-117.82143, 35.57557], [-117.82145, 35.57191], [-117.8303, 35.57191]]]} No Public Access 3 16665 Indian Wells Valley 32190 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   Kern 36 201.555 Indian Wells Valley 0 State Resource Management Area 55 3
2095 2095 2094 {"type": "Polygon", "coordinates": [[[-121.70681, 38.27679], [-121.69559, 38.279], [-121.69594, 38.27864], [-121.69605, 38.27822], [-121.69594, 38.27776], [-121.69591, 38.27776], [-121.69526, 38.27319], [-121.69496, 38.27168], [-121.6945, 38.26631], [-121.69503, 38.266], [-121.69541, 38.26585], [-121.69632, 38.26585], [-121.69693, 38.26661], [-121.69714, 38.2671], [-121.69799, 38.2678], [-121.69895, 38.26831], [-121.69965, 38.26846], [-121.69988, 38.26865], [-121.70056, 38.26926], [-121.70453, 38.27349], [-121.70503, 38.27408], [-121.70574, 38.27512], [-121.70586, 38.27551], [-121.70622, 38.27614], [-121.70681, 38.27679]]]} No Public Access 3 15834 DWR Mitigation 18327 207 California Department of Water Resources 477 State 5 State Agency 5 http://www.water.ca.gov/ Other State 5 207 California Department of Water Resources 470 State 5 State Agency 5   Solano 26 213.26 DWR Mitigation 0 State Other or Unknown 104 4
2417 2417 2416 {"type": "Polygon", "coordinates": [[[-120.82613, 36.92597], [-120.81978, 36.92585], [-120.82012, 36.91517], [-120.82491, 36.91943], [-120.82613, 36.92597]]]} No Public Access 3 17273 Dos Amigos 32151 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 114.925 Dos Amigos 0 State Resource Management Area 55 3
2428 2428 2427 {"type": "MultiPolygon", "coordinates": [[[[-120.39692, 37.50741], [-120.39664, 37.51843], [-120.39339, 37.51813], [-120.39035, 37.51702], [-120.3889, 37.51665], [-120.38848, 37.51633], [-120.3843, 37.51606], [-120.38436, 37.5155], [-120.38449, 37.51059], [-120.38471, 37.51053], [-120.38563, 37.51016], [-120.38827, 37.50854], [-120.3895, 37.50769], [-120.39086, 37.50715], [-120.39629, 37.50707], [-120.39692, 37.50741]]], [[[-120.39693, 37.50636], [-120.39692, 37.50692], [-120.39645, 37.50666], [-120.39073, 37.50674], [-120.38921, 37.50734], [-120.38794, 37.50822], [-120.38536, 37.50981], [-120.3845, 37.51015], [-120.38462, 37.50621], [-120.39333, 37.50635], [-120.39693, 37.50636]]]]} No Public Access 3 17291 Merced River 32217 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 311.747 Merced River 0 State Resource Management Area 55 3
2472 2472 2471 {"type": "Polygon", "coordinates": [[[-122.42431, 38.57076], [-122.40796, 38.56534], [-122.40763, 38.56593], [-122.40441, 38.56433], [-122.40437, 38.56388], [-122.39965, 38.56388], [-122.39938, 38.56002], [-122.39765, 38.56007], [-122.39459, 38.56008], [-122.3945, 38.55878], [-122.3939, 38.55243], [-122.38916, 38.55225], [-122.38901, 38.54848], [-122.39374, 38.54861], [-122.40827, 38.54845], [-122.40883, 38.55601], [-122.41284, 38.55633], [-122.41246, 38.55706], [-122.41819, 38.55884], [-122.41876, 38.55979], [-122.4195, 38.56112], [-122.42027, 38.56235], [-122.4221, 38.56629], [-122.42372, 38.56906], [-122.42377, 38.56909], [-122.42384, 38.56927], [-122.4243, 38.57012], [-122.42431, 38.57076]]]} No Public Access 3 17455 Las Posadas State Forest 21064 202 California Department of Forestry and Fire Protection 346 State 5 State Agency 5 http://www.fire.ca.gov/ Other State 5 202 California Department of Forestry and Fire Protection 343 State 5 State Agency 5   Napa 11 843.001 Las Posadas State Forest 0 State Resource Management Area 55 3
2481 2481 2480 {"type": "Polygon", "coordinates": [[[-122.19661, 40.26979], [-122.19658, 40.27249], [-122.19162, 40.27297], [-122.18953, 40.27326], [-122.19087, 40.26973], [-122.19661, 40.26979]]]} No Public Access 3 17478 Bend Ferry Road 32047 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   Tehama 18 45.388 Bend Ferry Road 0 State Resource Management Area 55 3
2631 2631 2630 {"type": "Polygon", "coordinates": [[[-121.49959, 37.6491], [-121.49457, 37.649], [-121.49018, 37.64886], [-121.49073, 37.64768], [-121.49079, 37.6476], [-121.49097, 37.64704], [-121.49108, 37.64648], [-121.49155, 37.63993], [-121.4916, 37.63962], [-121.49221, 37.6393], [-121.4944, 37.63887], [-121.49444, 37.63989], [-121.4952, 37.64234], [-121.49679, 37.64307], [-121.49847, 37.64757], [-121.49959, 37.6491]], [[-121.49355, 37.64011], [-121.49277, 37.64012], [-121.49267, 37.64151], [-121.49369, 37.64277], [-121.49423, 37.64241], [-121.49463, 37.64166], [-121.49429, 37.64112], [-121.49355, 37.64011]]]} No Public Access 3 18038 Corral Hollow Ecological Reserve 32134 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 Joaquin 39 125.166 Corral Hollow ER 0 State Conservation Area 8 2
2829 2829 2828 {"type": "MultiPolygon", "coordinates": [[[[-121.90675, 36.49739], [-121.90673, 36.50102], [-121.90221, 36.50098], [-121.90222, 36.50821], [-121.90218, 36.50822], [-121.90219, 36.51184], [-121.89773, 36.51178], [-121.89769, 36.5118], [-121.89768, 36.51303], [-121.89645, 36.51258], [-121.89643, 36.5126], [-121.8964, 36.5126], [-121.89572, 36.51561], [-121.88356, 36.50521], [-121.8826, 36.50435], [-121.88418, 36.50437], [-121.8842, 36.50081], [-121.88872, 36.50083], [-121.88876, 36.49724], [-121.90675, 36.49739]]], [[[-121.92476, 36.51831], [-121.9219, 36.51998], [-121.91891, 36.52179], [-121.91077, 36.52017], [-121.90666, 36.51653], [-121.90673, 36.51189], [-121.91565, 36.51192], [-121.91564, 36.51012], [-121.92009, 36.51014], [-121.92012, 36.51091], [-121.92457, 36.51093], [-121.92476, 36.51831]]], [[[-121.9098, 36.50829], [-121.90903, 36.50905], [-121.90898, 36.51153], [-121.90673, 36.51153], [-121.90672, 36.50851], [-121.90869, 36.50852], [-121.9087, 36.50828], [-121.9098, 36.50829]]], [[[-121.9379, 36.51209], [-121.93641, 36.51184], [-121.93574, 36.51282], [-121.93567, 36.51306], [-121.93098, 36.51383], [-121.93099, 36.50959], [-121.92896, 36.50799], [-121.92945, 36.50798], [-121.92967, 36.50784], [-121.92986, 36.5078], [-121.93061, 36.50786], [-121.93112, 36.50798], [-121.93188, 36.50784], [-121.93233, 36.50812], [-121.93274, 36.50805], [-121.93272, 36.50791], [-121.93315, 36.50797], [-121.93359, 36.50829], [-121.93399, 36.50793], [-121.93423, 36.50787], [-121.935, 36.50814], [-121.93512, 36.50811], [-121.93537, 36.50817], [-121.93548, 36.50813], [-121.93556, 36.50813], [-121.9356, 36.5082], [-121.93622, 36.50826], [-121.93683, 36.50864], [-121.93703, 36.50879], [-121.93722, 36.50895], [-121.93742, 36.50917], [-121.93757, 36.50936], [-121.93769, 36.50956], [-121.93779, 36.50977], [-121.93791, 36.51012], [-121.93796, 36.51048], [-121.93796, 36.51121], [-121.9379, 36.51209]]]]} No Public Access 3 18696 Point Lobos Ranch 23853 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   Monterey 14 1115.979 Point Lobos Ranch 1998 State Park 15 4
2960 2960 2959 {"type": "Polygon", "coordinates": [[[-121.48533, 38.57999], [-121.48515, 38.58041], [-121.48444, 38.58023], [-121.48463, 38.57981], [-121.48533, 38.57999]]]} No Public Access 3 20477 Governor's Mansion State Historic Park 30653 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 http://www.parks.ca.gov/?page_id=498 Sacramento 41 0.789 Governor's Mansion SHP 1903 State Historic or Cultural Area 132 4

Next page

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