units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,219 rows where MNG_AG_TYP = 3
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Los Angeles, County of 139
- Santa Barbara, County of 102
- San Diego, County of 102
- Orange, County of 81
- Sacramento, County of 56
- Lake, County of 54
- Butte, County of 53
- El Dorado, County of 43
- Monterey, County of 40
- Santa Cruz, County of 38
- Riverside, County of 35
- Kern, County of 34
- Placer, County of 26
- Ventura, County of 21
- Stanislaus, County of 20
- San Bernardino, County of 19
- San Luis Obispo, County of 18
- Yolo, County of 18
- Fresno, County of 15
- San Joaquin, County of 15
- Humboldt, County of 12
- Tulare, County of 10
- Merced, County of 9
- Mono, County of 7
- Tehama, County of 7
- Mendocino, County of 7
- Lassen, County of 6
- Modoc, County of 5
- Mariposa, County of 4
- Imperial, County of 4
- …
DES_TP >30
- Local Park 523
- Local Other or Unknown 208
- Local Recreation Area 109
- Local Conservation Area 87
- Local Historic or Cultural Area 14
- National Recreation Area 3
- National Monument or Landmark 2
- National Forest 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
ACCESS_TYP 4
- Open Access 931
- Restricted Access 55
- Unknown Access 34
- No Public Access 23
MNG_AG_TYP 1
- County Agency · 1,043 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2498 | 2498 | 2497 | {"type": "MultiPolygon", "coordinates": [[[[-119.63205, 34.43527], [-119.631, 34.43526], [-119.63141, 34.43312], [-119.63141, 34.43311], [-119.63134, 34.4331], [-119.63134, 34.43283], [-119.63179, 34.43283], [-119.6318, 34.43303], [-119.63183, 34.43323], [-119.63201, 34.43386], [-119.63205, 34.43527]]], [[[-119.63427, 34.43281], [-119.63426, 34.43526], [-119.63224, 34.43526], [-119.63225, 34.43427], [-119.63336, 34.43427], [-119.63339, 34.43368], [-119.63328, 34.43339], [-119.63369, 34.43334], [-119.63417, 34.43334], [-119.63418, 34.43281], [-119.63427, 34.43281]]]]} | Open Access 1 | 17533 | Manning Park | 21754 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 11.812 | Manning Park | 0 | Local Park 2 | 4 | |
2535 | 2535 | 2534 | {"type": "Polygon", "coordinates": [[[-119.88382, 34.43947], [-119.88316, 34.43948], [-119.88316, 34.43906], [-119.88317, 34.43903], [-119.8832, 34.43902], [-119.88379, 34.43902], [-119.88381, 34.43905], [-119.88382, 34.43947]]]} | Open Access 1 | 17758 | Bella Vista III | 15978 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 0.76 | Bella Vista III | None 208 | |||
2555 | 2555 | 2554 | {"type": "Polygon", "coordinates": [[[-120.47151, 34.59209], [-120.4715, 34.59302], [-120.4694, 34.59376], [-120.46933, 34.59299], [-120.47003, 34.59241], [-120.47066, 34.59232], [-120.47151, 34.59209]]]} | Open Access 1 | 17819 | Miguelito County Park | 22211 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 5.367 | Miguelito County Park | 0 | Local Park 2 | 4 | |
2608 | 2608 | 2607 | {"type": "MultiPolygon", "coordinates": [[[[-121.97832, 36.95705], [-121.97828, 36.95709], [-121.9783, 36.95711], [-121.97787, 36.95759], [-121.97783, 36.95757], [-121.97775, 36.95765], [-121.97718, 36.95745], [-121.97667, 36.9574], [-121.97609, 36.95755], [-121.97595, 36.95809], [-121.97577, 36.9583], [-121.97571, 36.95895], [-121.97546, 36.95939], [-121.97509, 36.95967], [-121.97488, 36.95987], [-121.97474, 36.95987], [-121.97499, 36.95918], [-121.97528, 36.95862], [-121.97554, 36.95745], [-121.9757, 36.95715], [-121.97617, 36.9566], [-121.97634, 36.95646], [-121.97646, 36.95645], [-121.97691, 36.95656], [-121.97758, 36.95608], [-121.97784, 36.95626], [-121.97797, 36.95666], [-121.97791, 36.95672], [-121.97828, 36.95698], [-121.97832, 36.95705]]], [[[-121.97827, 36.95625], [-121.97813, 36.95638], [-121.97809, 36.95638], [-121.97801, 36.95612], [-121.97812, 36.95614], [-121.97827, 36.95625]]]]} | Open Access 1 | 17987 | Moran Lake Park | 22471 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 8.942 | Moran Lake Park | 0 | Local Park 2 | 4 | |
2615 | 2615 | 2614 | {"type": "Polygon", "coordinates": [[[-119.80483, 34.42522], [-119.80482, 34.42554], [-119.80247, 34.42582], [-119.8009, 34.42611], [-119.80039, 34.42613], [-119.79935, 34.42613], [-119.79881, 34.42614], [-119.79835, 34.42616], [-119.7981, 34.4262], [-119.79785, 34.42626], [-119.79761, 34.42634], [-119.79738, 34.42644], [-119.79607, 34.42714], [-119.7965, 34.42603], [-119.7965, 34.42592], [-119.79466, 34.42424], [-119.801, 34.42408], [-119.80117, 34.42409], [-119.80132, 34.42412], [-119.80156, 34.4242], [-119.80248, 34.42446], [-119.80249, 34.4255], [-119.80483, 34.42522]]]} | Open Access 1 | 17990 | More Mesa Open Space | 22473 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 36.882 | More Mesa OS | 0 | Local Recreation Area 3 | 4 | |
2617 | 2617 | 2616 | {"type": "Polygon", "coordinates": [[[-119.08056, 37.77893], [-119.08015, 37.77893], [-119.08014, 37.77847], [-119.08056, 37.77847], [-119.08056, 37.77893]]]} | Open Access 1 | 20758 | Gull Lake Park | 19565 | 309 | Mono, County of 538 | County 3 | County Agency 3 | http://www.monocounty.ca.gov/facilities/page/parks-recreation-areas | County 3 | 309 | Mono, County of 531 | County 3 | County Agency 3 | Mono 32 | 0.46 | Gull Lake Park | 0 | Local Park 2 | 4 | |
2643 | 2643 | 2642 | {"type": "Polygon", "coordinates": [[[-121.07603, 37.39301], [-121.07567, 37.39319], [-121.07512, 37.39252], [-121.07553, 37.39229], [-121.07603, 37.39291], [-121.07603, 37.39301]]]} | Open Access 1 | 18132 | Bonita Park | 16261 | 329 | Stanislaus, County of 505 | County 3 | County Agency 3 | http://www.stancounty.com/er/parks/ | County 3 | 329 | Stanislaus, County of 497 | County 3 | County Agency 3 | Stanislaus 2 | 0.972 | Bonita Park | 0 | Local Park 2 | 4 | |
2653 | 2653 | 2652 | {"type": "Polygon", "coordinates": [[[-120.1819, 34.5326], [-120.18188, 34.5355], [-120.18164, 34.53547], [-120.17751, 34.53436], [-120.17561, 34.53522], [-120.1757, 34.53333], [-120.1755, 34.53184], [-120.17499, 34.53056], [-120.17342, 34.52986], [-120.17345, 34.52719], [-120.17782, 34.5272], [-120.17762, 34.53254], [-120.1819, 34.5326]]]} | Open Access 1 | 18125 | Nojoqui Falls County Park | 22783 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 83.478 | Nojoqui Falls County Park | 0 | Local Park 2 | 4 | |
2654 | 2654 | 2653 | {"type": "Polygon", "coordinates": [[[-121.02794, 37.62238], [-121.02735, 37.6224], [-121.02736, 37.62169], [-121.02793, 37.62169], [-121.02794, 37.62238]]]} | Open Access 1 | 18139 | Burbank-Paradise Park | 16507 | 329 | Stanislaus, County of 505 | County 3 | County Agency 3 | http://www.stancounty.com/er/parks/ | County 3 | 329 | Stanislaus, County of 497 | County 3 | County Agency 3 | Stanislaus 2 | 0.985 | Burbank-Paradise Park | 0 | Local Park 2 | 4 | |
2659 | 2659 | 2658 | {"type": "Polygon", "coordinates": [[[-121.08623, 37.70481], [-121.08544, 37.70542], [-121.08476, 37.70485], [-121.08556, 37.70424], [-121.08623, 37.70481]]]} | Open Access 1 | 18204 | Salida Park | 24796 | 329 | Stanislaus, County of 505 | County 3 | County Agency 3 | http://www.stancounty.com/er/parks/ | County 3 | 329 | Stanislaus, County of 497 | County 3 | County Agency 3 | Stanislaus 2 | 2.088 | Salida Park | 0 | Local Park 2 | 4 | |
2661 | 2661 | 2660 | {"type": "Polygon", "coordinates": [[[-120.90829, 37.55597], [-120.90828, 37.55697], [-120.9071, 37.55696], [-120.90712, 37.55515], [-120.9071, 37.55494], [-120.90829, 37.55597]]]} | Open Access 1 | 18167 | Hatch Park | 19734 | 329 | Stanislaus, County of 505 | County 3 | County Agency 3 | http://www.stancounty.com/er/parks/ | County 3 | 329 | Stanislaus, County of 497 | County 3 | County Agency 3 | Stanislaus 2 | 4.28 | Hatch Park | 0 | Local Park 2 | 4 | |
2669 | 2669 | 2668 | {"type": "Polygon", "coordinates": [[[-120.97809, 37.63478], [-120.97809, 37.63538], [-120.97657, 37.63538], [-120.97657, 37.63478], [-120.97809, 37.63478]]]} | Open Access 1 | 18189 | Mono Park | 22372 | 329 | Stanislaus, County of 505 | County 3 | County Agency 3 | http://www.stancounty.com/er/parks/ | County 3 | 329 | Stanislaus, County of 497 | County 3 | County Agency 3 | Stanislaus 2 | 2.215 | Mono Park | 0 | Local Park 2 | 4 | |
2682 | 2682 | 2681 | {"type": "Polygon", "coordinates": [[[-120.79984, 37.51646], [-120.79984, 37.51725], [-120.7997, 37.51725], [-120.7997, 37.51759], [-120.79865, 37.51758], [-120.79866, 37.51646], [-120.79984, 37.51646]]]} | Open Access 1 | 18211 | Sterling Ranch Park | 25835 | 329 | Stanislaus, County of 505 | County 3 | County Agency 3 | http://www.stancounty.com/er/parks/ | County 3 | 329 | Stanislaus, County of 497 | County 3 | County Agency 3 | Stanislaus 2 | 3.141 | Sterling Ranch Park | 0 | Local Park 2 | 4 | |
2687 | 2687 | 2686 | {"type": "MultiPolygon", "coordinates": [[[[-120.60154, 34.69034], [-120.60044, 34.69224], [-120.59668, 34.69152], [-120.59741, 34.68786], [-120.60038, 34.68829], [-120.60154, 34.69034]]], [[[-120.60536, 34.68376], [-120.60493, 34.6845], [-120.60463, 34.68438], [-120.60507, 34.68364], [-120.60536, 34.68376]]]]} | Open Access 1 | 18238 | Ocean Beach Park | 23051 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 38.919 | Ocean Beach Park | 0 | Local Park 2 | 4 | |
2689 | 2689 | 2688 | {"type": "Polygon", "coordinates": [[[-121.96932, 38.8863], [-121.9688, 38.88631], [-121.9688, 38.88594], [-121.96932, 38.88593], [-121.96932, 38.8863]]]} | Open Access 1 | 28059 | Dunnigan Park | 33723 | 332 | Yolo, County of 545 | County 3 | County Agency 3 | http://www.yolocounty.org/general-government/general-government-departments/parks | County 3 | 332 | Yolo, County of 538 | County 3 | County Agency 3 | Yolo 33 | 0.458 | Dunnigan Park | 0 | Local Park 2 | 4 | |
2692 | 2692 | 2691 | {"type": "MultiPolygon", "coordinates": [[[[-122.08941, 37.08847], [-122.08867, 37.0882], [-122.0887, 37.08805], [-122.0888, 37.08808], [-122.08909, 37.08823], [-122.08938, 37.08835], [-122.08941, 37.08847]]], [[[-122.09254, 37.08896], [-122.0925, 37.08902], [-122.09228, 37.08886], [-122.09149, 37.08889], [-122.09142, 37.08887], [-122.09137, 37.08877], [-122.09012, 37.08881], [-122.09009, 37.08845], [-122.09002, 37.08845], [-122.09019, 37.08817], [-122.09026, 37.08819], [-122.09035, 37.08816], [-122.09053, 37.08823], [-122.09047, 37.08832], [-122.09038, 37.08833], [-122.09042, 37.08845], [-122.09038, 37.08844], [-122.09039, 37.08849], [-122.09058, 37.08852], [-122.09111, 37.08856], [-122.09112, 37.08855], [-122.09111, 37.08848], [-122.09135, 37.08849], [-122.09136, 37.08857], [-122.09139, 37.08858], [-122.09176, 37.08858], [-122.09193, 37.08861], [-122.09225, 37.08874], [-122.09234, 37.08883], [-122.09245, 37.08889], [-122.09254, 37.08896]]]]} | Open Access 1 | 17802 | Ben Lomond Park | 16002 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 1.953 | Ben Lomond Park | 0 | Local Park 2 | 4 | |
2694 | 2694 | 2693 | {"type": "Polygon", "coordinates": [[[-120.62642, 35.1044], [-120.62597, 35.10496], [-120.62525, 35.10457], [-120.6257, 35.10401], [-120.62642, 35.1044]]]} | Open Access 1 | 18257 | Oceano Memorial Campground | 23064 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 1.456 | Oceano Memorial Campground | 0 | Local Recreation Area 3 | 4 | |
2695 | 2695 | 2694 | {"type": "MultiPolygon", "coordinates": [[[[-120.62428, 35.10545], [-120.62366, 35.10564], [-120.6231, 35.1049], [-120.62418, 35.10482], [-120.62428, 35.10545]]], [[[-120.62597, 35.10646], [-120.62472, 35.10684], [-120.62438, 35.10481], [-120.62511, 35.10475], [-120.62594, 35.10521], [-120.62551, 35.10565], [-120.6255, 35.10593], [-120.62574, 35.10626], [-120.62594, 35.10634], [-120.62597, 35.10646]]]]} | Open Access 1 | 18260 | Oceano Memorial Park | 23065 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 6.953 | Oceano Memorial Park | 0 | Local Park 2 | 4 | |
2697 | 2697 | 2696 | {"type": "Polygon", "coordinates": [[[-117.80432, 33.54625], [-117.80431, 33.54636], [-117.80425, 33.54646], [-117.80426, 33.54653], [-117.80399, 33.54715], [-117.80384, 33.54717], [-117.80374, 33.54724], [-117.80339, 33.54663], [-117.80347, 33.54661], [-117.80351, 33.54656], [-117.80354, 33.54652], [-117.80361, 33.54645], [-117.80363, 33.54639], [-117.80376, 33.54626], [-117.80381, 33.54617], [-117.80386, 33.54614], [-117.80407, 33.54613], [-117.80418, 33.54616], [-117.80432, 33.54625]]]} | Open Access 1 | 18271 | Crescent Bay Point Park | 17792 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 1.554 | Crescent Bay Point Park | 0 | Local Park 2 | 4 | |
2717 | 2717 | 2716 | {"type": "Polygon", "coordinates": [[[-121.74025, 38.67015], [-121.73904, 38.67037], [-121.739, 38.67027], [-121.73832, 38.6704], [-121.73826, 38.67032], [-121.73803, 38.67042], [-121.73754, 38.66974], [-121.73757, 38.66967], [-121.73915, 38.66898], [-121.73967, 38.6688], [-121.74022, 38.66866], [-121.7402, 38.66999], [-121.74025, 38.67015]]]} | Open Access 1 | 21366 | Klenhard Park | 20689 | 332 | Yolo, County of 545 | County 3 | County Agency 3 | http://www.yolocounty.org/general-government/general-government-departments/parks | County 3 | 332 | Yolo, County of 538 | County 3 | County Agency 3 | Yolo 33 | 7.227 | Klenhard Park | 0 | Local Park 2 | 4 |
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]);