superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,102 rows where MNG_AG_TYP = 3 sorted by SUID_NMA descending
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Los Angeles, County of 171
- San Diego, County of 120
- Santa Barbara, County of 89
- Orange, County of 82
- Lake, County of 56
- Butte, County of 53
- Santa Cruz, County of 49
- Kern, County of 47
- Sacramento, County of 46
- Riverside, County of 37
- San Luis Obispo, County of 31
- Monterey, County of 31
- Placer, County of 24
- Stanislaus, County of 23
- San Joaquin, County of 21
- Ventura, County of 19
- Fresno, County of 17
- San Bernardino, County of 16
- Merced, County of 15
- Tulare, County of 14
- Yolo, County of 14
- Humboldt, County of 12
- El Dorado, County of 9
- Mono, County of 7
- Tehama, County of 7
- Mariposa, County of 6
- Lassen, County of 6
- Napa, County of 5
- Mendocino, County of 5
- Modoc, County of 5
- …
ACCESS_TYP 4
- Open Access 963
- Restricted Access 57
- Unknown Access 36
- No Public Access 26
MNG_AG_TYP 1
- County Agency · 1,082 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1006 | 1006 | 1005 | {"type": "Polygon", "coordinates": [[[-117.51151, 33.77707], [-117.51138, 33.77733], [-117.51089, 33.77824], [-117.51044, 33.77898], [-117.50991, 33.77901], [-117.5099, 33.77885], [-117.50991, 33.77865], [-117.50988, 33.77857], [-117.50981, 33.7785], [-117.50971, 33.77848], [-117.50949, 33.77851], [-117.50935, 33.77852], [-117.50932, 33.77819], [-117.50853, 33.77823], [-117.51151, 33.77707]]]} | Open Access 1 | Montecito Ranch Park | 33601 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 5.317 | Montecito Ranch Park | ||
1005 | 1005 | 1004 | {"type": "Polygon", "coordinates": [[[-117.32215, 34.01575], [-117.32169, 34.01627], [-117.32155, 34.01645], [-117.32148, 34.01656], [-117.3214, 34.01675], [-117.32125, 34.01722], [-117.32099, 34.01872], [-117.32092, 34.01895], [-117.32079, 34.01927], [-117.32066, 34.01927], [-117.32063, 34.01926], [-117.3206, 34.01922], [-117.32022, 34.01922], [-117.32021, 34.01866], [-117.32021, 34.01575], [-117.32215, 34.01575]]]} | Open Access 1 | Highgrove Community Park | https://rivcoccsd.org/new-page-2 | 33600 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 9.518 | Highgrove Community Park | |
1001 | 1001 | 1000 | {"type": "Polygon", "coordinates": [[[-117.28428, 33.76242], [-117.28273, 33.76246], [-117.2827, 33.76182], [-117.28324, 33.7618], [-117.28324, 33.76162], [-117.28425, 33.76159], [-117.28428, 33.76242]]]} | Open Access 1 | Goodhope Park | 33599 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 3.023 | Goodhope Park | ||
1000 | 1000 | 999 | {"type": "Polygon", "coordinates": [[[-117.53184, 33.83651], [-117.52781, 33.83658], [-117.52781, 33.83602], [-117.52859, 33.836], [-117.52865, 33.83597], [-117.52865, 33.83594], [-117.52861, 33.83541], [-117.52852, 33.83513], [-117.52837, 33.83487], [-117.52794, 33.83501], [-117.52726, 33.83357], [-117.52752, 33.83343], [-117.52761, 33.83344], [-117.52777, 33.83335], [-117.5278, 33.83328], [-117.52925, 33.83254], [-117.53, 33.83352], [-117.53166, 33.83607], [-117.53184, 33.83651]]]} | Open Access 1 | El Cerrito Sports Park | https://www.coronaca.gov/Home/Components/FacilityDirectory/FacilityDirectory/95/580 | 33598 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 26.336 | El Cerrito Sports Park | |
980 | 980 | 979 | {"type": "Polygon", "coordinates": [[[-117.12462, 33.54378], [-117.12448, 33.54508], [-117.12437, 33.54615], [-117.12388, 33.54512], [-117.12356, 33.54429], [-117.12362, 33.54435], [-117.12371, 33.54437], [-117.12389, 33.54459], [-117.12437, 33.54458], [-117.12447, 33.54378], [-117.12462, 33.54378]], [[-117.12426, 33.54565], [-117.12424, 33.54563], [-117.1242, 33.54564], [-117.12424, 33.54573], [-117.12426, 33.54572], [-117.12426, 33.54565]]]} | Open Access 1 | Overlook Park | 33597 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 2.196 | Overlook Park | ||
970 | 970 | 969 | {"type": "Polygon", "coordinates": [[[-117.14043, 33.54707], [-117.14033, 33.54714], [-117.14015, 33.54747], [-117.14, 33.54759], [-117.1397, 33.54789], [-117.13919, 33.54827], [-117.13902, 33.54831], [-117.13885, 33.54827], [-117.13872, 33.54818], [-117.13868, 33.54811], [-117.13866, 33.54804], [-117.13864, 33.54803], [-117.13819, 33.54827], [-117.13775, 33.54855], [-117.1376, 33.5487], [-117.13734, 33.54913], [-117.13712, 33.54933], [-117.13684, 33.54927], [-117.13672, 33.54927], [-117.13643, 33.54949], [-117.13623, 33.54973], [-117.13611, 33.54969], [-117.1368, 33.54916], [-117.13676, 33.5491], [-117.13698, 33.54886], [-117.13707, 33.54872], [-117.13719, 33.54846], [-117.13729, 33.54833], [-117.13743, 33.54823], [-117.13791, 33.548], [-117.13812, 33.54786], [-117.13818, 33.54775], [-117.13821, 33.54764], [-117.1382, 33.54752], [-117.13815, 33.54746], [-117.13968, 33.54619], [-117.14015, 33.54657], [-117.13849, 33.5478], [-117.13849, 33.54782], [-117.13853, 33.54785], [-117.1402, 33.54661], [-117.14042, 33.54677], [-117.14043, 33.54707]]]} | Open Access 1 | Guenther Willows Park | 33596 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 8.904 | Guenther Willows Park | ||
969 | 969 | 968 | {"type": "Polygon", "coordinates": [[[-117.12554, 33.55661], [-117.12553, 33.5568], [-117.12529, 33.55681], [-117.12524, 33.55678], [-117.12519, 33.55681], [-117.12507, 33.55681], [-117.12505, 33.55686], [-117.125, 33.55686], [-117.125, 33.5569], [-117.12496, 33.55692], [-117.12494, 33.55695], [-117.12496, 33.55699], [-117.125, 33.55701], [-117.125, 33.55709], [-117.12504, 33.55709], [-117.12505, 33.5572], [-117.12522, 33.5572], [-117.12523, 33.55718], [-117.12525, 33.55718], [-117.12527, 33.5572], [-117.12545, 33.5572], [-117.12546, 33.55724], [-117.12553, 33.55724], [-117.12552, 33.55745], [-117.12403, 33.55744], [-117.12404, 33.55702], [-117.12365, 33.55701], [-117.12365, 33.55667], [-117.12363, 33.55663], [-117.12358, 33.55661], [-117.1234, 33.55662], [-117.12335, 33.55664], [-117.12292, 33.55701], [-117.12262, 33.55696], [-117.12249, 33.55684], [-117.12272, 33.55671], [-117.12299, 33.55661], [-117.12313, 33.55657], [-117.12342, 33.55654], [-117.12549, 33.55657], [-117.12554, 33.55661]]]} | Open Access 1 | Central Park Community Park Murrieta | 33595 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 3.893 | Central Park Community Park Murrieta | ||
968 | 968 | 967 | {"type": "Polygon", "coordinates": [[[-117.12413, 33.54745], [-117.1241, 33.54807], [-117.12362, 33.54832], [-117.12356, 33.54832], [-117.12379, 33.54812], [-117.12375, 33.54798], [-117.1237, 33.54794], [-117.12368, 33.54781], [-117.12365, 33.54779], [-117.12366, 33.54745], [-117.12413, 33.54745]]]} | Open Access 1 | Discovery Park | 33594 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 0.79 | Discovery Park | ||
959 | 959 | 958 | {"type": "Polygon", "coordinates": [[[-117.34495, 33.64111], [-117.34461, 33.64156], [-117.34354, 33.6409], [-117.34412, 33.64026], [-117.34444, 33.64045], [-117.34428, 33.64065], [-117.34495, 33.64111]]]} | Open Access 1 | Perret Park | 33593 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 2.065 | Perret Park | ||
958 | 958 | 957 | {"type": "Polygon", "coordinates": [[[-120.91483, 39.93803], [-120.91233, 39.93808], [-120.91216, 39.93828], [-120.91089, 39.93831], [-120.91086, 39.93744], [-120.9128, 39.93744], [-120.91293, 39.93722], [-120.91325, 39.9372], [-120.91325, 39.93651], [-120.91482, 39.93651], [-120.91483, 39.93803]]]} | Open Access 1 | Quincy Skatepark | 33592 | 362 | Plumas, County of 652 | County 3 | County Agency 3 | http://www.countyofplumas.com/ | County 3 | 10.118 | Quincy Skatepark | ||
957 | 957 | 956 | {"type": "Polygon", "coordinates": [[[-121.7011, 36.60301], [-121.6999, 36.60383], [-121.69965, 36.60353], [-121.69903, 36.60325], [-121.69957, 36.60245], [-121.7004, 36.60282], [-121.7011, 36.60301]]]} | Open Access 1 | Kelton Park | 33591 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | http://www.co.monterey.ca.us/parks/ | County 3 | 3.333 | Kelton Park | ||
955 | 955 | 954 | {"type": "Polygon", "coordinates": [[[-123.20724, 39.27079], [-123.2067, 39.27099], [-123.20634, 39.27092], [-123.20581, 39.27127], [-123.2057, 39.27079], [-123.20565, 39.27078], [-123.20548, 39.27018], [-123.20623, 39.27012], [-123.20624, 39.2701], [-123.20614, 39.26984], [-123.20541, 39.2699], [-123.2054, 39.26983], [-123.20702, 39.26969], [-123.20724, 39.27079]]]} | Open Access 1 | Redwood Valley Lions Club Park | https://www.mendocinocounty.org/government/cultural-services-agency/parks/redwood-valley-lions-club-park | 33588 | 352 | Mendocino, County of 609 | County 3 | County Agency 3 | http://www.co.mendocino.ca.us/gs/parks/ | County 3 | 4.167 | Redwood Valley Lions Club Park | |
14394 | 14394 | 14393 | {"type": "Polygon", "coordinates": [[[-122.20164, 39.52119], [-122.2011, 39.5212], [-122.2011, 39.52062], [-122.20164, 39.52061], [-122.20164, 39.52119]]]} | Open Access 1 | Memorial Park | 33583 | 359 | Glenn, County of 710 | County 3 | County Agency 3 | http://www.countyofglenn.net/ | County 3 | 0.741 | Memorial Park | ||
951 | 951 | 950 | {"type": "Polygon", "coordinates": [[[-122.19397, 39.75117], [-122.19396, 39.75163], [-122.19291, 39.7516], [-122.19294, 39.75113], [-122.193, 39.75108], [-122.19392, 39.75108], [-122.19397, 39.75117]]]} | Open Access 1 | Legion Memorial Park | 33582 | 359 | Glenn, County of 710 | County 3 | County Agency 3 | http://www.countyofglenn.net/ | County 3 | 1.295 | Legion Memorial Park | ||
443 | 443 | 442 | {"type": "Polygon", "coordinates": [[[-120.9568, 39.94607], [-120.95643, 39.94615], [-120.95602, 39.94605], [-120.95529, 39.94608], [-120.95422, 39.94619], [-120.9537, 39.9463], [-120.95284, 39.9463], [-120.95282, 39.94622], [-120.95074, 39.94623], [-120.95079, 39.94587], [-120.95078, 39.94557], [-120.95104, 39.94516], [-120.95129, 39.9451], [-120.95198, 39.94502], [-120.95262, 39.94503], [-120.95321, 39.94493], [-120.95392, 39.94499], [-120.95478, 39.94501], [-120.9558, 39.9451], [-120.9568, 39.94607]]]} | Open Access 1 | Gasner Park | 33499 | 362 | Plumas, County of 652 | County 3 | County Agency 3 | http://www.countyofplumas.com/ | County 3 | 14.937 | Gasner Park | ||
438 | 438 | 437 | {"type": "Polygon", "coordinates": [[[-120.42216, 34.84972], [-120.42192, 34.85046], [-120.42153, 34.85093], [-120.42161, 34.85109], [-120.42151, 34.85123], [-120.42113, 34.8513], [-120.42097, 34.852], [-120.4202, 34.85238], [-120.42045, 34.85272], [-120.42027, 34.85283], [-120.41992, 34.85247], [-120.41927, 34.85288], [-120.41925, 34.85304], [-120.41877, 34.85301], [-120.4185, 34.85298], [-120.41851, 34.85295], [-120.41877, 34.85272], [-120.41876, 34.85243], [-120.41873, 34.85237], [-120.41785, 34.85177], [-120.41792, 34.8515], [-120.41769, 34.85134], [-120.41774, 34.85092], [-120.4174, 34.85061], [-120.41773, 34.85046], [-120.41787, 34.85016], [-120.41891, 34.85012], [-120.41919, 34.84959], [-120.4196, 34.84947], [-120.42048, 34.84963], [-120.42153, 34.84925], [-120.422, 34.8495], [-120.42216, 34.84972]]]} | Open Access 1 | Orcutt Community Park | https://www.countyofsb.org/parks/asset.c/581 | 33496 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 26.029 | Orcutt Community Park | |
14390 | 14390 | 14389 | {"type": "Polygon", "coordinates": [[[-116.07451, 33.56924], [-116.07349, 33.56924], [-116.07349, 33.56872], [-116.07451, 33.56872], [-116.07451, 33.56924]]]} | Open Access 1 | Unknown Park - Riverside, County of | 33493 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 1.338 | |||
404 | 404 | 403 | {"type": "Polygon", "coordinates": [[[-119.7034, 36.73503], [-119.70336, 36.73509], [-119.70325, 36.73514], [-119.70255, 36.73514], [-119.70247, 36.73512], [-119.70241, 36.73508], [-119.70238, 36.735], [-119.70237, 36.73404], [-119.70239, 36.734], [-119.70244, 36.73399], [-119.70282, 36.73399], [-119.70289, 36.73401], [-119.70294, 36.73405], [-119.7034, 36.73496], [-119.7034, 36.73503]]]} | Open Access 1 | Montecito | 33484 | 301 | Fresno, County of 292 | County 3 | County Agency 3 | http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51904 | County 3 | 2.258 | Montecito | ||
13304 | 13304 | 13303 | {"type": "Polygon", "coordinates": [[[-122.54604, 39.88145], [-122.5458, 39.88281], [-122.54366, 39.88282], [-122.54397, 39.88098], [-122.54604, 39.88145]]]} | Open Access 1 | Simpson-Finnell Park | https://www.co.tehama.ca.us/simpson-finnell-park | 33429 | 367 | Tehama, County of 574 | County 3 | County Agency 3 | http://www.co.tehama.ca.us/dep-parks | County 3 | 8.048 | Simpson-Finnell Park | |
14387 | 14387 | 14386 | {"type": "Polygon", "coordinates": [[[-122.11291, 40.02963], [-122.11291, 40.03329], [-122.11092, 40.0333], [-122.11089, 40.03065], [-122.11223, 40.02981], [-122.11291, 40.02963]]]} | Open Access 1 | Unnamed Site - Tehama, County of | 33428 | 367 | Tehama, County of 574 | County 3 | County Agency 3 | http://www.co.tehama.ca.us/dep-parks | County 3 | 15.208 |
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]);