superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
34 rows where ACCESS_TYP = 3 and LAYER = 5 sorted by MNG_AGENCY
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_WEB
MNG_AGENCY 14
- California Department of Water Resources 11
- California Department of Transportation 5
- California Department of General Services 3
- University of California 3
- California Department of Forestry and Fire Protection 2
- California Wildlife Conservation Board 2
- California State Lands Commission 1
- Other State 1
- Napa Valley College 1
- San Diego State University 1
- Coachella Valley Mountains Conservancy 1
- California State University 1
- California State Coastal Conservancy 1
- California Tahoe Conservancy 1
MNG_AG_TYP 1
- State Agency 34
ACCESS_TYP 1
- No Public Access · 34 ✖
Link | rowid | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY ▼ | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1079 | 1079 | 1078 | {"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 | 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 | 0.209 | 575 Third St | ||
8571 | 8571 | 8570 | {"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 | 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 | 0.203 | Real Estate Services Division | ||
14269 | 14269 | 14268 | {"type": "MultiPolygon", "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]]], [[[-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]]], [[[-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]]], [[[-122.30619, 38.31262], [-122.30611, 38.31263], [-122.30598, 38.31222], [-122.30605, 38.3122], [-122.30619, 38.31262]]], [[[-122.57285, 38.57309], [-122.57104, 38.57221], [-122.57064, 38.57205], [-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], [-122.57176, 38.57199], [-122.57199, 38.57244], [-122.57265, 38.57291], [-122.57285, 38.57309]]], [[[-122.57831, 38.57459], [-122.57825, 38.5747], [-122.57785, 38.57457], [-122.57792, 38.57445], [-122.57831, 38.57459]]], [[[-122.60006, 38.59944], [-122.59941, 38.60053], [-122.59885, 38.60029], [-122.5995, 38.59921], [-122.60006, 38.59944]]]]} | No Public Access 3 | 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 | 58.219 | |||
6307 | 6307 | 6306 | {"type": "Polygon", "coordinates": [[[-121.7562, 37.72355], [-121.75619, 37.73783], [-121.75386, 37.73785], [-121.7539, 37.73081], [-121.7516, 37.73078], [-121.75166, 37.72355], [-121.7562, 37.72355]]]} | No Public Access 3 | Livermore Monitoring Station | 21382 | 217 | University of California 51 | State 5 | State Agency 5 | http://nrs.ucop.edu/ | Other State 5 | 119.349 | Livermore Monitoring Station | ||
13620 | 13620 | 13619 | {"type": "Polygon", "coordinates": [[[-117.30505, 33.97199], [-117.30066, 33.97196], [-117.30065, 33.97556], [-117.29645, 33.97552], [-117.2965, 33.96463], [-117.30083, 33.96465], [-117.30087, 33.96814], [-117.30505, 33.96813], [-117.30505, 33.97199]]]} | No Public Access 3 | Box Springs Reserve | http://www.ucnrs.org/reserves/box-springs-reserve.html | 31388 | 217 | University of California 51 | State 5 | State Agency 5 | http://nrs.ucop.edu/ | Other State 5 | 159.883 | Box Springs Reserve | |
13839 | 13839 | 13838 | {"type": "Polygon", "coordinates": [[[-116.45768, 34.14968], [-116.45335, 34.1497], [-116.45333, 34.15015], [-116.45115, 34.15016], [-116.45114, 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.14812], [-116.45761, 34.14811], [-116.45654, 34.14811], [-116.45653, 34.14608], [-116.45332, 34.1461], [-116.45334, 34.147], [-116.45654, 34.14833], [-116.4576, 34.14833], [-116.45762, 34.14812]]]} | No Public Access 3 | Burns Piñon Ridge Reserve | http://www.ucnrs.org/reserves/burns-pinon-ridge-reserve.html | 31389 | 217 | University of California 51 | State 5 | State Agency 5 | http://nrs.ucop.edu/ | Other State 5 | 304.485 | Burns Piñon Ridge Reserve | |
2523 | 2523 | 2522 | {"type": "Polygon", "coordinates": [[[-122.53034, 38.61119], [-122.52573, 38.61122], [-122.52574, 38.61484], [-122.52112, 38.61486], [-122.52091, 38.61402], [-122.52089, 38.61401], [-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 | California State Lands Commission | 16723 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 245.304 | SLC | ||
9986 | 9986 | 9985 | {"type": "Polygon", "coordinates": [[[-121.50125, 38.31704], [-121.50005, 38.31773], [-121.49878, 38.31973], [-121.49852, 38.31959], [-121.49847, 38.31958], [-121.4946, 38.31753], [-121.49279, 38.31453], [-121.50082, 38.31445], [-121.50125, 38.31704]]]} | No Public Access 3 | Stone Lakes | 25871 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 68.283 | Stone Lakes | |||
3407 | 3407 | 3406 | {"type": "Polygon", "coordinates": [[[-122.46839, 38.40869], [-122.46606, 38.40871], [-122.46603, 38.40487], [-122.46579, 38.40181], [-122.46609, 38.40194], [-122.46628, 38.402], [-122.46661, 38.40209], [-122.46676, 38.4021], [-122.4669, 38.40215], [-122.46726, 38.40233], [-122.4675, 38.40235], [-122.46761, 38.40231], [-122.46771, 38.40225], [-122.46801, 38.40199], [-122.46819, 38.40193], [-122.46832, 38.40179], [-122.46839, 38.40869]]]} | No Public Access 3 | Dale Peters Clyde | 17895 | 223 | Napa Valley College 263 | State 5 | State Agency 5 | http://www.napavalley.edu/ | Other State 5 | 37.393 | Dale Peters Clyde | ||
3570 | 3570 | 3569 | {"type": "MultiPolygon", "coordinates": [[[[-122.29969, 38.27466], [-122.29947, 38.27466], [-122.29946, 38.27356], [-122.29948, 38.27356], [-122.29969, 38.27466]]], [[[-122.46397, 38.50119], [-122.46394, 38.50121], [-122.46301, 38.50039], [-122.46304, 38.50037], [-122.46397, 38.50119]]]]} | No Public Access 3 | Department of Transportation | 18097 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 0.423 | Department of Transportation | ||
3576 | 3576 | 3575 | {"type": "Polygon", "coordinates": [[[-122.25654, 38.2078], [-122.25633, 38.20788], [-122.2563, 38.20749], [-122.2564, 38.20753], [-122.25652, 38.20754], [-122.25654, 38.2078]]]} | No Public Access 3 | Dept Of Transportation/Paul Kenny | 18103 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 0.163 | Dept Of Transportation/Paul Kenny | ||
4333 | 4333 | 4332 | {"type": "Polygon", "coordinates": [[[-117.00555, 32.56116], [-117.00554, 32.56472], [-117.00446, 32.56471], [-117.00445, 32.56601], [-117.00443, 32.56603], [-117.00418, 32.566], [-117.004, 32.56588], [-117.00338, 32.56582], [-117.00337, 32.56469], [-117.00123, 32.56466], [-117.00126, 32.56109], [-117.00555, 32.56116]]]} | No Public Access 3 | Anderprises TransNet Environmental Mitigation | 32283 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 42.9 | Anderprises TransNet Environmental Mitigation | ||
12924 | 12924 | 12923 | {"type": "Polygon", "coordinates": [[[-116.95835, 32.58995], [-116.95155, 32.59194], [-116.94918, 32.59009], [-116.947, 32.58786], [-116.94582, 32.58582], [-116.94542, 32.58527], [-116.94807, 32.58424], [-116.94748, 32.58333], [-116.94716, 32.58293], [-116.94705, 32.58296], [-116.94672, 32.58291], [-116.94635, 32.58283], [-116.94603, 32.58271], [-116.94582, 32.58248], [-116.9458, 32.58217], [-116.94581, 32.58211], [-116.94962, 32.58217], [-116.95013, 32.5831], [-116.95155, 32.5844], [-116.95157, 32.58584], [-116.9523, 32.58586], [-116.95595, 32.58857], [-116.95639, 32.58888], [-116.95835, 32.58995]]]} | No Public Access 3 | Otay Valley Regional Park | http://www.sdparks.org/content/sdparks/en/park-pages/OVRP.html | 31498 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 146.7 | Otay Valley RP | |
12925 | 12925 | 12924 | {"type": "MultiPolygon", "coordinates": [[[[-116.94813, 32.58902], [-116.9452, 32.5891], [-116.94513, 32.5821], [-116.94581, 32.58211], [-116.9458, 32.58218], [-116.94582, 32.58248], [-116.94603, 32.58271], [-116.94635, 32.58283], [-116.94672, 32.58291], [-116.94705, 32.58296], [-116.94715, 32.58293], [-116.94748, 32.58333], [-116.94808, 32.58424], [-116.94543, 32.58528], [-116.94582, 32.58582], [-116.947, 32.58786], [-116.94813, 32.58902]]], [[[-116.96324, 32.58239], [-116.96221, 32.58238], [-116.96223, 32.58109], [-116.96255, 32.58146], [-116.96287, 32.58187], [-116.96324, 32.58239]]], [[[-116.97107, 32.58246], [-116.96665, 32.58242], [-116.96664, 32.58433], [-116.9656, 32.58432], [-116.96528, 32.5838], [-116.96527, 32.58366], [-116.96504, 32.58323], [-116.96479, 32.58282], [-116.96439, 32.58227], [-116.96379, 32.5813], [-116.96318, 32.58026], [-116.96293, 32.57991], [-116.96267, 32.57957], [-116.96225, 32.57912], [-116.96225, 32.57881], [-116.96235, 32.57879], [-116.96238, 32.57507], [-116.97088, 32.57514], [-116.97107, 32.58246]]]]} | No Public Access 3 | Lonestar Ridge TransNet Environmental Mitigation | 31496 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 191.665 | Lonestar Ridge TransNet Environmental Mitigation | ||
5787 | 5787 | 5786 | {"type": "Polygon", "coordinates": [[[-116.74116, 32.57636], [-116.74114, 32.58363], [-116.73714, 32.58342], [-116.73291, 32.5834], [-116.73278, 32.58732], [-116.72048, 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 | Kuchamaa Experimental Forest | 20729 | 202 | California Department of Forestry and Fire Protection 343 | State 5 | State Agency 5 | http://www.fire.ca.gov/ | Other State 5 | 2363.81 | Kuchamaa Experimental Forest | ||
6024 | 6024 | 6023 | {"type": "Polygon", "coordinates": [[[-122.42431, 38.57076], [-122.40797, 38.56535], [-122.40763, 38.56593], [-122.40441, 38.56433], [-122.40436, 38.56388], [-122.39965, 38.56388], [-122.39938, 38.56003], [-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.41247, 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 | Las Posadas State Forest | 21064 | 202 | California Department of Forestry and Fire Protection 343 | State 5 | State Agency 5 | http://www.fire.ca.gov/ | Other State 5 | 843.093 | Las Posadas State Forest | ||
13006 | 13006 | 13005 | {"type": "Polygon", "coordinates": [[[-117.15937, 33.4648], [-117.15693, 33.46596], [-117.15547, 33.46627], [-117.1551, 33.46876], [-117.15582, 33.4699], [-117.15547, 33.4701], [-117.15359, 33.47159], [-117.15293, 33.47188], [-117.14836, 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.14522, 33.46914], [-117.14519, 33.46582], [-117.15408, 33.46502], [-117.15937, 33.4648]]]} | No Public Access 3 | Santa Margarita Ecological Reserve | https://fsp.sdsu.edu/about-us/ | 33343 | 221 | San Diego State University 378 | State 5 | State Agency 5 | http://www.sdsu.edu/ | Other State 5 | 243.201 | Santa Margarita ER | 1962 |
1605 | 1605 | 1604 | {"type": "Polygon", "coordinates": [[[-120.12173, 36.2483], [-120.12148, 36.2483], [-120.12146, 36.24807], [-120.10458, 36.24812], [-120.10456, 36.24822], [-120.10395, 36.24822], [-120.10393, 36.2482], [-120.10338, 36.24816], [-120.10321, 36.24807], [-120.08575, 36.24814], [-120.08572, 36.25219], [-120.08397, 36.25081], [-120.08324, 36.25055], [-120.08275, 36.25016], [-120.08242, 36.2498], [-120.07876, 36.24666], [-120.07738, 36.24531], [-120.07628, 36.2438], [-120.07409, 36.24039], [-120.07219, 36.23723], [-120.06988, 36.23366], [-120.06783, 36.23367], [-120.06783, 36.23047], [-120.06518, 36.22639], [-120.0612, 36.22003], [-120.05967, 36.22059], [-120.05947, 36.22022], [-120.06105, 36.2196], [-120.06106, 36.21958], [-120.05979, 36.21789], [-120.05716, 36.21086], [-120.05712, 36.21066], [-120.05696, 36.21019], [-120.05185, 36.1961], [-120.05042, 36.19239], [-120.04902, 36.18884], [-120.0482, 36.18882], [-120.0484, 36.18167], [-120.05002, 36.18159], [-120.05751, 36.18176], [-120.05747, 36.18776], [-120.05533, 36.18777], [-120.05526, 36.18884], [-120.05086, 36.18883], [-120.05085, 36.18885], [-120.05226, 36.19238], [-120.05722, 36.19239], [-120.05722, 36.196], [-120.05384, 36.19606], [-120.05383, 36.19608], [-120.05892, 36.21035], [-120.05941, 36.21066], [-120.06768, 36.21071], [-120.06771, 36.21711], [-120.08038, 36.21218], [-120.08246, 36.21139], [-120.08563, 36.21136], [-120.08583, 36.22637], [-120.091, 36.22637], [-120.10353, 36.22642], [-120.12169, 36.22629], [-120.12169, 36.2408], [-120.12173, 36.2483]]]} | No Public Access 3 | Arroyo Pasajero Westside Detention Basin | 15624 | 207 | California Department of Water Resources 470 | State 5 | State Agency 5 | http://www.water.ca.gov/ | Other State 5 | 3820.213 | Arroyo Pasajero Westside Detention Basin | ||
3276 | 3276 | 3275 | {"type": "Polygon", "coordinates": [[[-117.05061, 34.06564], [-117.05016, 34.06761], [-117.04942, 34.06795], [-117.04771, 34.06692], [-117.04766, 34.06428], [-117.04902, 34.06452], [-117.05061, 34.06564]]]} | No Public Access 3 | Crafton Hills Reservoir | 17748 | 207 | California Department of Water Resources 470 | State 5 | State Agency 5 | http://www.water.ca.gov/ | Other State 5 | 19.389 | Crafton Hills Reservoir | ||
3572 | 3572 | 3571 | {"type": "Polygon", "coordinates": [[[-122.22476, 38.22438], [-122.22475, 38.22525], [-122.2237, 38.22526], [-122.2237, 38.22472], [-122.22307, 38.22433], [-122.2222, 38.22245], [-122.22221, 38.22188], [-122.22324, 38.22127], [-122.22322, 38.22152], [-122.22316, 38.22152], [-122.22316, 38.22161], [-122.22261, 38.22185], [-122.22242, 38.2221], [-122.22241, 38.22244], [-122.22307, 38.22385], [-122.22384, 38.22431], [-122.22415, 38.22431], [-122.22452, 38.22437], [-122.22476, 38.22438]]]} | No Public Access 3 | Department Of Water Resourses | 18099 | 207 | California Department of Water Resources 470 | State 5 | State Agency 5 | http://www.water.ca.gov/ | Other State 5 | 4.799 | Department Of Water Resourses |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);