superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,091 rows where LAYER = 4 and MNG_AG_TYP = 4 sorted by AGNCY_WEB
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- East Bay Regional Park District 132
- Hayward Area Recreation and Park District 84
- Valley-Wide Recreation and Park District 67
- Rancho Simi Recreation and Park District 53
- Conejo Recreation and Park District 44
- Midpeninsula Regional Open Space District 43
- Southgate Recreation and Park District 40
- Marin County Open Space District 39
- Sunrise Recreation and Park District 39
- Cordova Recreation and Park District 36
- Greater Vallejo Recreation and Park District 33
- Pleasant Valley Recreation and Park District 31
- North of the River Recreation and Park District 27
- Monterey Peninsula Regional Park District 24
- Santa Clara Valley Open Space Authority 23
- Sonoma County Agricultural Preservation and Open Space District 21
- Jurupa Area Recreation and Park District 18
- Desert Recreation District 15
- Isla Vista Recreation and Park District 14
- Mission Oaks Recreation and Park District 14
- Apple Valley Recreation and Park District 13
- Livermore Area Recreation and Park District 13
- Pleasant Hill Recreation and Park District 12
- Carmichael Recreation and Park District 12
- Auburn Area Recreation and Park District 11
- North Highland Recreation and Park District 11
- Napa County Regional Park and Open Space District 10
- Hesperia Recreation and Park District 10
- Miraleste Recreation and Park District 10
- Rio Linda Elverta Recreation and Park District 9
- …
ACCESS_TYP 4
- Open Access 931
- No Public Access 97
- Restricted Access 62
- Unknown Access 1
MNG_AG_TYP 1
- Recreation/Parks District · 1,091 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2639 | 2639 | 2638 | {"type": "Polygon", "coordinates": [[[-121.73742, 36.48206], [-121.73572, 36.4827], [-121.73546, 36.48248], [-121.73613, 36.48154], [-121.73566, 36.48131], [-121.73587, 36.48102], [-121.7362, 36.4812], [-121.73668, 36.48141], [-121.73694, 36.48155], [-121.7372, 36.48177], [-121.73734, 36.48193], [-121.73742, 36.48206]]]} | Open Access 1 | Carmel Valley Park | 16876 | 2337 | Carmel Valley Recreation Park District 1065 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 3.858 | Carmel Valley Park | |||
3206 | 3206 | 3205 | {"type": "Polygon", "coordinates": [[[-117.25827, 34.54145], [-117.25718, 34.54179], [-117.25716, 34.54027], [-117.25826, 34.54028], [-117.25827, 34.54145]]]} | Open Access 1 | Corwin Park | 17669 | 2200 | Apple Valley Recreation and Park District 262 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 3.69 | Corwin Park | |||
3283 | 3283 | 3282 | {"type": "Polygon", "coordinates": [[[-117.22181, 34.53488], [-117.22174, 34.535], [-117.2217, 34.53513], [-117.22168, 34.53527], [-117.22168, 34.53555], [-117.22166, 34.53558], [-117.22162, 34.5356], [-117.22091, 34.53561], [-117.22089, 34.53514], [-117.22017, 34.53515], [-117.22017, 34.53467], [-117.22046, 34.5346], [-117.22059, 34.53454], [-117.22074, 34.53444], [-117.22112, 34.53478], [-117.22124, 34.53468], [-117.22181, 34.53488]]]} | Open Access 1 | Cramer Family Park | 17754 | 2200 | Apple Valley Recreation and Park District 262 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2.83 | Cramer Family Park | |||
4278 | 4278 | 4277 | {"type": "Polygon", "coordinates": [[[-117.04739, 34.89181], [-117.04738, 34.89249], [-117.04398, 34.89336], [-117.04397, 34.89172], [-117.04739, 34.89181]]]} | Open Access 1 | Foglesong Park/Eda Henderson Pool | 18966 | 2203 | Barstow Recreation and Park District 76 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 9.886 | Foglesong Park/Eda Henderson Pool | |||
4422 | 4422 | 4421 | {"type": "Polygon", "coordinates": [[[-116.33702, 34.11024], [-116.33643, 34.11074], [-116.33563, 34.11215], [-116.33564, 34.11023], [-116.33702, 34.11024]]]} | Open Access 1 | Friendly Hills Park | 19115 | 2230 | Joshua Tree Park and Recreation District 616 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2.814 | Friendly Hills Park | |||
5257 | 5257 | 5256 | {"type": "Polygon", "coordinates": [[[-117.13372, 34.48655], [-117.12931, 34.48651], [-117.12931, 34.48533], [-117.13037, 34.48459], [-117.13067, 34.48392], [-117.13217, 34.48391], [-117.1327, 34.48343], [-117.13274, 34.48292], [-117.13251, 34.48283], [-117.13251, 34.48129], [-117.13371, 34.48132], [-117.13372, 34.48655]]]} | Open Access 1 | Horsemen's Center | 20096 | 2200 | Apple Valley Recreation and Park District 262 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 33.692 | Horsemen's Ctr. | |||
5368 | 5368 | 5367 | {"type": "Polygon", "coordinates": [[[-116.08355, 34.12978], [-116.08208, 34.12979], [-116.08206, 34.12438], [-116.08353, 34.12437], [-116.08355, 34.12978]]]} | Open Access 1 | Knott Sky Park | 20705 | 2265 | Twentynine Palms Park and Recreation District 563 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 20.116 | Knott Sky Park | |||
5422 | 5422 | 5421 | {"type": "Polygon", "coordinates": [[[-116.03991, 34.14688], [-116.03988, 34.15024], [-116.03658, 34.15029], [-116.03661, 34.14692], [-116.03991, 34.14688]]]} | Open Access 1 | Luckie Park | 21581 | 2265 | Twentynine Palms Park and Recreation District 563 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 28.064 | Luckie Park | |||
5625 | 5625 | 5624 | {"type": "Polygon", "coordinates": [[[-116.31502, 34.13125], [-116.31407, 34.13125], [-116.31373, 34.1311], [-116.314, 34.13093], [-116.3143, 34.13079], [-116.31462, 34.1307], [-116.31496, 34.13065], [-116.315, 34.13067], [-116.31502, 34.1307], [-116.31502, 34.13125]]]} | Open Access 1 | Joshua Tree Park and Recreation District 1 | 20507 | 2230 | Joshua Tree Park and Recreation District 616 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 1.383 | Joshua Tree Park and Rec. District 1 | |||
6111 | 6111 | 6110 | {"type": "Polygon", "coordinates": [[[-117.20598, 34.54853], [-117.2057, 34.54853], [-117.20553, 34.5484], [-117.20246, 34.5484], [-117.20244, 34.54399], [-117.20595, 34.54398], [-117.20598, 34.54853]]]} | Open Access 1 | Lenny Brewster Sports Center | 21164 | 2200 | Apple Valley Recreation and Park District 262 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 39.16 | Lenny Brewster Sports Ctr. | |||
6236 | 6236 | 6235 | {"type": "Polygon", "coordinates": [[[-117.21166, 34.51739], [-117.21088, 34.51795], [-117.2105, 34.51759], [-117.21131, 34.51706], [-117.21142, 34.51709], [-117.2115, 34.51715], [-117.21159, 34.51725], [-117.21166, 34.51739]]]} | Open Access 1 | Lion's Park | 21311 | 2200 | Apple Valley Recreation and Park District 262 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 1.245 | Lion's Park | |||
6937 | 6937 | 6936 | {"type": "Polygon", "coordinates": [[[-117.1878, 34.44347], [-117.18605, 34.44348], [-117.18605, 34.44269], [-117.18779, 34.44268], [-117.1878, 34.44347]]]} | Open Access 1 | Mendel Park | 22148 | 2200 | Apple Valley Recreation and Park District 262 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 3.477 | Mendel Park | |||
7145 | 7145 | 7144 | {"type": "MultiPolygon", "coordinates": [[[[-121.89718, 36.61024], [-121.89709, 36.61029], [-121.89629, 36.60934], [-121.8964, 36.60932], [-121.89718, 36.61024]]], [[[-121.89804, 36.61126], [-121.89796, 36.61131], [-121.89719, 36.6104], [-121.89727, 36.61035], [-121.89804, 36.61126]]], [[[-121.89857, 36.61213], [-121.89845, 36.6122], [-121.89841, 36.61202], [-121.89831, 36.61179], [-121.89821, 36.61162], [-121.89805, 36.61143], [-121.89816, 36.61137], [-121.89831, 36.61155], [-121.89846, 36.6118], [-121.89852, 36.61194], [-121.89857, 36.61213]]], [[[-121.89976, 36.61454], [-121.8996, 36.61463], [-121.89874, 36.61359], [-121.89862, 36.61339], [-121.89853, 36.61314], [-121.8985, 36.61297], [-121.89847, 36.61266], [-121.89862, 36.61283], [-121.89864, 36.61302], [-121.89868, 36.61318], [-121.89875, 36.61336], [-121.89886, 36.61355], [-121.89942, 36.61422], [-121.89947, 36.6142], [-121.89976, 36.61454]]], [[[-121.90075, 36.61569], [-121.90057, 36.61579], [-121.89971, 36.61477], [-121.89987, 36.61468], [-121.90006, 36.61489], [-121.90008, 36.61489], [-121.90075, 36.61569]]], [[[-121.90167, 36.61684], [-121.90153, 36.61692], [-121.90067, 36.6159], [-121.9008, 36.61582], [-121.90167, 36.61684]]], [[[-121.90242, 36.6177], [-121.90225, 36.61776], [-121.90163, 36.61703], [-121.90177, 36.61695], [-121.90242, 36.6177]]], [[[-121.90324, 36.61833], [-121.90322, 36.61834], [-121.90314, 36.61831], [-121.903, 36.61821], [-121.90291, 36.61811], [-121.90302, 36.61806], [-121.90324, 36.61833]]]]} | Open Access 1 | Monterey Bay Coastal Trail | 22417 | 2084 | Monterey Peninsula Recreational Trail Joint Powers 530 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 3.183 | Monterey Bay Coastal Trail | |||
7418 | 7418 | 7417 | {"type": "Polygon", "coordinates": [[[-117.21794, 34.50725], [-117.21794, 34.50766], [-117.2166, 34.50766], [-117.21659, 34.50655], [-117.21716, 34.50654], [-117.21716, 34.50697], [-117.21713, 34.5071], [-117.21716, 34.50719], [-117.21723, 34.50724], [-117.21735, 34.50728], [-117.2175, 34.50725], [-117.21794, 34.50725]]]} | Open Access 1 | Norm Schmidt Park | 22794 | 2200 | Apple Valley Recreation and Park District 262 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2.378 | Norm Schmidt Park | |||
8704 | 8704 | 8703 | {"type": "MultiPolygon", "coordinates": [[[[-118.37159, 33.76721], [-118.37139, 33.76744], [-118.37081, 33.76795], [-118.37054, 33.76809], [-118.37028, 33.76819], [-118.36988, 33.76825], [-118.36957, 33.76825], [-118.36931, 33.76821], [-118.36905, 33.76812], [-118.36801, 33.7677], [-118.3677, 33.76761], [-118.36738, 33.76756], [-118.36695, 33.76756], [-118.36722, 33.76751], [-118.36745, 33.76751], [-118.36778, 33.76756], [-118.36792, 33.7676], [-118.3693, 33.76817], [-118.36961, 33.76824], [-118.36984, 33.76825], [-118.37, 33.76823], [-118.37022, 33.76817], [-118.37042, 33.76808], [-118.37055, 33.76799], [-118.37068, 33.76788], [-118.37138, 33.76708], [-118.37138, 33.76701], [-118.37159, 33.76714], [-118.37159, 33.76721]]], [[[-118.3718, 33.76638], [-118.3718, 33.76662], [-118.37176, 33.76685], [-118.3717, 33.7669], [-118.37163, 33.76689], [-118.37158, 33.76686], [-118.37168, 33.7667], [-118.37175, 33.76655], [-118.37178, 33.76638], [-118.37178, 33.76628], [-118.3718, 33.76638]]]]} | Open Access 1 | Ridgecrest Ranchos Open Space | 24353 | 2120 | Ridgecrest Ranchos Recreation and Park District 1105 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 1.195 | Ridgecrest Ranchos OS | |||
8820 | 8820 | 8819 | {"type": "Polygon", "coordinates": [[[-117.01533, 34.86952], [-117.01105, 34.86943], [-117.01101, 34.8658], [-117.01529, 34.86588], [-117.01533, 34.86952]]]} | Open Access 1 | Robert A. Sessions Memorial Sports Park | 24482 | 2203 | Barstow Recreation and Park District 76 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 38.929 | Robert A. Sessions Memorial Sports Park | |||
10074 | 10074 | 10073 | {"type": "Polygon", "coordinates": [[[-116.30843, 34.14128], [-116.30425, 34.14132], [-116.30424, 34.13951], [-116.30642, 34.1395], [-116.30644, 34.13956], [-116.30842, 34.13955], [-116.30843, 34.14128]]]} | Open Access 1 | Sunburst Park | 25986 | 2230 | Joshua Tree Park and Recreation District 616 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 18.75 | Sunburst Park | |||
10190 | 10190 | 10189 | {"type": "Polygon", "coordinates": [[[-117.1555, 34.55318], [-117.15316, 34.55317], [-117.15316, 34.55251], [-117.15326, 34.55248], [-117.15331, 34.55239], [-117.1533, 34.55235], [-117.15324, 34.55222], [-117.15324, 34.55175], [-117.15329, 34.55171], [-117.15334, 34.55169], [-117.15537, 34.55167], [-117.15544, 34.55169], [-117.15549, 34.55175], [-117.1555, 34.55318]]]} | Open Access 1 | Sycamore Rocks Park | 26142 | 2200 | Apple Valley Recreation and Park District 262 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 8.579 | Sycamore Rocks Park | |||
10350 | 10350 | 10349 | {"type": "Polygon", "coordinates": [[[-117.21458, 34.53082], [-117.21419, 34.53082], [-117.21418, 34.53128], [-117.21261, 34.53128], [-117.2126, 34.53013], [-117.21265, 34.53009], [-117.21457, 34.53009], [-117.21458, 34.53082]]]} | Open Access 1 | Thunderbird Park | 26338 | 2200 | Apple Valley Recreation and Park District 262 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 5.463 | Thunderbird Park | |||
10937 | 10937 | 10936 | {"type": "Polygon", "coordinates": [[[-117.17372, 34.56238], [-117.17371, 34.5633], [-117.17151, 34.5633], [-117.17152, 34.56283], [-117.17239, 34.56283], [-117.1724, 34.56238], [-117.17372, 34.56238]]]} | Open Access 1 | Virginia Park | 27158 | 2200 | Apple Valley Recreation and Park District 262 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 4.103 | Virginia Park |
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]);