units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
358 rows where LAYER = 5 and MNG_AG_TYP = 5 sorted by MNG_AGENCY
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_WEB, MNG_AG_ID
DES_TP >30
- State Resource Management Area 88
- State Conservation Area 81
- State Other or Unknown 54
- State Recreation Area 22
- State Park 15
- National Monument or Landmark 2
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- National Wildlife Refuge 1
- None 1
- None 1
- State Historic or Cultural Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
MNG_AGENCY 20
- California State Lands Commission 86
- University of California 52
- Other State 43
- California Department of Fish and Wildlife 32
- California Department of Transportation 27
- California Department of Parks and Recreation 23
- California Department of Water Resources 20
- Santa Monica Mountains Conservancy 18
- California Department of General Services 14
- California Department of Forestry and Fire Protection 10
- California Wildlife Conservation Board 9
- California State Coastal Conservancy 7
- Coachella Valley Mountains Conservancy 5
- California Department of Veterans Affairs 2
- Napa Valley College 2
- San Diego State University 2
- California State University 2
- California Tahoe Conservancy 2
- California State University Sonoma 1
- California State University Long Beach 1
ACCESS_TYP 4
- Open Access 218
- Restricted Access 67
- No Public Access 45
- Unknown Access 28
MNG_AG_TYP 1
- State Agency · 358 ✖
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 | |||
4590 | 4590 | 4589 | {"type": "Polygon", "coordinates": [[[-122.53085, 38.65457], [-122.52623, 38.65454], [-122.52626, 38.66281], [-122.52163, 38.66281], [-122.52162, 38.65813], [-122.52159, 38.65443], [-122.5216, 38.65086], [-122.52621, 38.65092], [-122.53085, 38.65095], [-122.53085, 38.65457]]]} | Open Access 1 | 35477 | 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 | 171.758 | 0 | State Other or Unknown 104 | 4 | ||
4604 | 4604 | 4603 | {"type": "Polygon", "coordinates": [[[-122.52162, 38.65813], [-122.51683, 38.65816], [-122.51708, 38.65772], [-122.517, 38.65768], [-122.51701, 38.65454], [-122.51243, 38.65456], [-122.51247, 38.65095], [-122.5216, 38.65086], [-122.52159, 38.65443], [-122.52162, 38.65813]]]} | Open Access 1 | 35702 | 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 | 119.087 | 0 | State Other or Unknown 104 | 4 | ||
4605 | 4605 | 4604 | {"type": "Polygon", "coordinates": [[[-122.122, 38.33618], [-122.12148, 38.33658], [-122.12116, 38.33673], [-122.12083, 38.33684], [-122.12005, 38.33619], [-122.1206, 38.33583], [-122.12117, 38.33549], [-122.122, 38.33618]]]} | No Public Access 3 | 35709 | Unnamed site - California Department of General Services | 28625 | 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 | 3.337 | 0 | State Other or Unknown 104 | 4 | ||
4622 | 4622 | 4621 | {"type": "Polygon", "coordinates": [[[-122.57831, 38.57459], [-122.57825, 38.5747], [-122.57785, 38.57457], [-122.57792, 38.57445], [-122.57831, 38.57459]]]} | No Public Access 3 | 36169 | Unnamed site - California Department of General Services | 28625 | 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.134 | 0 | State Other or Unknown 104 | 4 | ||
4625 | 4625 | 4624 | {"type": "Polygon", "coordinates": [[[-122.30619, 38.31262], [-122.30611, 38.31263], [-122.30598, 38.31222], [-122.30605, 38.3122], [-122.30619, 38.31262]]]} | No Public Access 3 | 36253 | Unnamed site - California Department of General Services | 28625 | 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.081 | 0 | State Other or Unknown 104 | 4 | ||
4626 | 4626 | 4625 | {"type": "Polygon", "coordinates": [[[-122.57086, 38.57153], [-122.57059, 38.57199], [-122.57035, 38.57175], [-122.57018, 38.5716], [-122.56976, 38.57131], [-122.56945, 38.57115], [-122.56889, 38.57091], [-122.56913, 38.57052], [-122.56989, 38.5711], [-122.57086, 38.57153]]]} | No Public Access 3 | 36255 | Unnamed site - California Department of General Services | 28625 | 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 | 1.713 | 0 | State Other or Unknown 104 | 4 | ||
4627 | 4627 | 4626 | {"type": "Polygon", "coordinates": [[[-122.12934, 38.45011], [-122.1247, 38.44986], [-122.1229, 38.44968], [-122.12294, 38.44961], [-122.12321, 38.44927], [-122.12353, 38.44842], [-122.12377, 38.44773], [-122.12385, 38.44729], [-122.12381, 38.44696], [-122.12383, 38.44653], [-122.12379, 38.44617], [-122.12468, 38.44627], [-122.12921, 38.44654], [-122.12934, 38.45011]]]} | No Public Access 3 | 36256 | Unnamed site - California Department of General Services | 28625 | 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 | 48.839 | 0 | State Other or Unknown 104 | 4 | ||
4678 | 4678 | 4677 | {"type": "Polygon", "coordinates": [[[-122.60006, 38.59944], [-122.59941, 38.60053], [-122.59885, 38.60029], [-122.5995, 38.59921], [-122.60006, 38.59944]]]} | No Public Access 3 | 36663 | Unnamed site - California Department of General Services | 28625 | 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 | 1.831 | 0 | State Other or Unknown 104 | 4 | ||
4680 | 4680 | 4679 | {"type": "Polygon", "coordinates": [[[-122.57285, 38.57309], [-122.57104, 38.57221], [-122.57064, 38.57205], [-122.57059, 38.57199], [-122.57086, 38.57153], [-122.57176, 38.57199], [-122.57199, 38.57244], [-122.57265, 38.57291], [-122.57285, 38.57309]]]} | No Public Access 3 | 43017 | Unnamed site - California Department of General Services | 28625 | 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 | 1.952 | 0 | State Other or Unknown 104 | 4 | ||
5656 | 5656 | 5655 | {"type": "Polygon", "coordinates": [[[-122.27035, 38.24032], [-122.27033, 38.24039], [-122.27027, 38.24044], [-122.26924, 38.24035], [-122.2691, 38.24036], [-122.26909, 38.24025], [-122.27035, 38.24032]]]} | No Public Access 3 | 43095 | Unnamed site - California Department of General Services | 28625 | 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.336 | 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 | ||
6750 | 6750 | 6749 | {"type": "Polygon", "coordinates": [[[-122.20351, 38.39474], [-122.20319, 38.39454], [-122.20286, 38.39422], [-122.20272, 38.39405], [-122.20259, 38.39383], [-122.20236, 38.3935], [-122.20227, 38.39332], [-122.20224, 38.39304], [-122.20227, 38.39292], [-122.20234, 38.39283], [-122.20237, 38.39269], [-122.20236, 38.39256], [-122.2023, 38.39242], [-122.20223, 38.3923], [-122.20209, 38.39217], [-122.20207, 38.3921], [-122.20208, 38.392], [-122.20213, 38.39192], [-122.20226, 38.3916], [-122.20266, 38.39133], [-122.20249, 38.39094], [-122.20223, 38.39075], [-122.20181, 38.39006], [-122.20176, 38.38991], [-122.20181, 38.38973], [-122.20189, 38.38957], [-122.20196, 38.38931], [-122.20185, 38.38897], [-122.20163, 38.38873], [-122.20152, 38.38847], [-122.20151, 38.38838], [-122.20155, 38.38829], [-122.20162, 38.38801], [-122.20178, 38.38753], [-122.20178, 38.38737], [-122.20176, 38.38726], [-122.20165, 38.38706], [-122.20158, 38.38698], [-122.20153, 38.38687], [-122.20158, 38.38645], [-122.20157, 38.38591], [-122.20153, 38.38561], [-122.20147, 38.38547], [-122.20134, 38.38522], [-122.20117, 38.38497], [-122.2033, 38.38496], [-122.20351, 38.39474]]]} | Open Access 1 | 5115 | Department Of Transportation | 18098 | 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 | 32.678 | Department Of Transportation | None 548 | |||
7312 | 7312 | 7311 | {"type": "Polygon", "coordinates": [[[-122.27901, 38.29895], [-122.27868, 38.299], [-122.27861, 38.29876], [-122.27894, 38.2987], [-122.27901, 38.29895]]]} | No Public Access 3 | 6623 | 575 Third St | 15206 | 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.21 | 575 Third St | None 604 | |||
1947 | 1947 | 1946 | {"type": "MultiPolygon", "coordinates": [[[[-118.98159, 36.05067], [-118.98137, 36.05079], [-118.9727, 36.05085], [-118.9718, 36.05081], [-118.97127, 36.05076], [-118.9708, 36.0507], [-118.97091, 36.0439], [-118.98041, 36.04394], [-118.98036, 36.04846], [-118.98039, 36.04883], [-118.98043, 36.04901], [-118.98052, 36.04928], [-118.98064, 36.04953], [-118.98074, 36.0497], [-118.98091, 36.04994], [-118.98105, 36.05009], [-118.98123, 36.05026], [-118.98148, 36.05046], [-118.98159, 36.05067]]], [[[-118.98205, 36.04396], [-118.98203, 36.04531], [-118.98196, 36.05048], [-118.98172, 36.05031], [-118.98148, 36.05012], [-118.98129, 36.04993], [-118.9811, 36.0497], [-118.98094, 36.04945], [-118.98084, 36.04924], [-118.98075, 36.04901], [-118.98068, 36.04874], [-118.98065, 36.04846], [-118.9807, 36.04394], [-118.98205, 36.04396]]]]} | Restricted Access 2 | 29177 | Yaudanchi Ecological Reserve | 27765 | 220 | California Department of Health Services 459 | State 5 | State Agency 5 | http://www.dhcs.ca.gov/Pages/default.aspx | Other State 5 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Tulare 29 | 184.306 | Yaudanchi ER | 0 | State Conservation Area 8 | 2 | |
3538 | 3538 | 3537 | {"type": "MultiPolygon", "coordinates": [[[[-115.82568, 35.02937], [-115.82568, 35.04387], [-115.80655, 35.04385], [-115.80654, 35.02936], [-115.82568, 35.02937]]], [[[-115.82562, 35.11652], [-115.8256, 35.13105], [-115.80662, 35.13104], [-115.80661, 35.11652], [-115.82562, 35.11652]]]]} | Open Access 1 | 28126 | Kelso Peak & Old Dad Mountains Wildlife Area | 30459 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | San Bernardino 22 | 1383.587 | Kelso Peak & Old Dad Mtns. Wildlife Area | 1989 | State Conservation Area 8 | 2 | |
3672 | 3672 | 3671 | {"type": "MultiPolygon", "coordinates": [[[[-120.44871, 34.6888], [-120.44792, 34.69026], [-120.4478, 34.69035], [-120.44763, 34.69033], [-120.44725, 34.69018], [-120.44662, 34.68998], [-120.44669, 34.6899], [-120.44679, 34.6897], [-120.44724, 34.68935], [-120.44815, 34.68888], [-120.44871, 34.6888]]], [[[-120.4499, 34.69128], [-120.44987, 34.69127], [-120.44986, 34.69126], [-120.44856, 34.69068], [-120.44826, 34.69059], [-120.44812, 34.69043], [-120.44817, 34.69018], [-120.44916, 34.6887], [-120.44971, 34.68869], [-120.44982, 34.68905], [-120.45004, 34.69], [-120.45006, 34.69067], [-120.4499, 34.69128]]]]} | Restricted Access 2 | 29691 | Burton Mesa Ecological Reserve | 16533 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Burton-Mesa-ER | Santa Barbara 7 | 11.989 | Burton Mesa ER | 2004 | State Conservation Area 8 | 2 |
5060 | 5060 | 5059 | {"type": "Polygon", "coordinates": [[[-122.5038, 38.11388], [-122.50155, 38.11561], [-122.50104, 38.11583], [-122.49865, 38.11461], [-122.50105, 38.1126], [-122.50133, 38.11229], [-122.5038, 38.11388]]]} | Open Access 1 | 25328 | Petaluma Marsh Wildlife Area | 30485 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Petaluma-Marsh-WA | Sonoma 16 | 21.886 | Petaluma Marsh Wildlife Area | 1979 | State Conservation Area 8 | 2 |
5105 | 5105 | 5104 | {"type": "Polygon", "coordinates": [[[-123.68414, 40.48042], [-123.67906, 40.48126], [-123.66993, 40.48271], [-123.67004, 40.47815], [-123.6746, 40.47741], [-123.67492, 40.47444], [-123.67959, 40.47359], [-123.67921, 40.47671], [-123.68403, 40.47602], [-123.68414, 40.48042]]]} | No Public Access 3 | 48240 | McClellan Mountain Peatland | 32798 | 212 | California Wildlife Conservation Board 766 | State 5 | State Agency 5 | http://www.wcb.ca.gov/ | Other State 5 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Humboldt 45 | 180.409 | McClellan Mtn. Peatland | 2017 | State Resource Management Area 55 | 3 | |
5757 | 5757 | 5756 | {"type": "Polygon", "coordinates": [[[-118.06308, 33.71148], [-118.0591, 33.71135], [-118.05909, 33.71137], [-118.05916, 33.71145], [-118.0591, 33.71145], [-118.0529, 33.70379], [-118.05255, 33.70376], [-118.05209, 33.70383], [-118.05126, 33.7045], [-118.05053, 33.70499], [-118.04992, 33.70528], [-118.04939, 33.70559], [-118.04839, 33.70627], [-118.04758, 33.70679], [-118.04721, 33.70696], [-118.0473, 33.70706], [-118.04645, 33.70713], [-118.0451, 33.7068], [-118.04429, 33.70664], [-118.04277, 33.7066], [-118.04262, 33.70639], [-118.03926, 33.70783], [-118.03874, 33.70808], [-118.03248, 33.7108], [-118.03236, 33.71026], [-118.0385, 33.70771], [-118.03856, 33.70759], [-118.04008, 33.70696], [-118.04008, 33.70694], [-118.03929, 33.70619], [-118.0362, 33.70457], [-118.0348, 33.70349], [-118.0343, 33.70285], [-118.03222, 33.70268], [-118.03233, 33.70084], [-118.03007, 33.70098], [-118.02774, 33.69924], [-118.02442, 33.69685], [-118.02392, 33.69652], [-118.02288, 33.69605], [-118.02167, 33.69532], [-118.02083, 33.69486], [-118.02092, 33.69004], [-118.0209, 33.68917], [-118.02053, 33.68916], [-118.02115, 33.68814], [-118.02114, 33.68806], [-118.02204, 33.68651], [-118.02221, 33.68641], [-118.02252, 33.68592], [-118.02297, 33.68566], [-118.02347, 33.68548], [-118.02404, 33.68539], [-118.02475, 33.68495], [-118.02488, 33.68482], [-118.02499, 33.68461], [-118.02516, 33.68437], [-118.02565, 33.68424], [-118.02733, 33.68355], [-118.02777, 33.68348], [-118.02863, 33.68372], [-118.03085, 33.6841], [-118.03152, 33.68436], [-118.03221, 33.68471], [-118.03276, 33.68458], [-118.03308, 33.68442], [-118.03319, 33.6839], [-118.0338, 33.68341], [-118.03355, 33.68309], [-118.03361, 33.68286], [-118.03424, 33.68245], [-118.03919, 33.68737], [-118.04395, 33.69223], [-118.04773, 33.69635], [-118.05291, 33.70154], [-118.05401, 33.7027], [-118.05549, 33.70404], [-118.05874, 33.70712], [-118.06037, 33.70878], [-118.06086, 33.70921], [-118.06308, 33.71148]]]} | Restricted Access 2 | 6996 | Bolsa Chica Ecological Reserve | 16245 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Bolsa-Chica-ER | Orange 3 | 1223.82 | Bolsa Chica ER | 1993 | State Conservation Area 8 | 2 |
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]);