superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
13,512 rows where ACCESS_TYP = 1
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Los Angeles, City of 359
- San Diego, City of 353
- California Department of Fish and Wildlife 208
- San Jose, City of 182
- San Francisco, City and County of 175
- Sacramento, City of 170
- Ventura, City of 141
- California Department of Parks and Recreation 139
- Los Angeles, County of 120
- Long Beach, City of 115
- Mountains Recreation and Conservation Authority 114
- Roseville, City of 103
- San Diego, County of 95
- Oakland, City of 89
- Irvine, City of 83
- Fresno, City of 80
- Consumnes Community Services District 78
- Huntington Beach, City of 64
- Tracy, City of 63
- Orange, County of 62
- Hayward Area Recreation and Park District 62
- Stockton, City of 61
- Santa Barbara, County of 60
- Chula Vista, City of 58
- Poway, City of 58
- Modesto, City of 58
- Santa Cruz, City of 57
- Lake, County of 53
- San Luis Obispo, City of 52
- Davis, City of 52
- …
MNG_AG_TYP 28
- City Agency 7,725
- County Agency 752
- Recreation/Parks District 698
- State Agency 423
- Community Services District 151
- County Agency - Parks 149
- Open Space District 143
- Non Profit - Land Trust 133
- Federal Agency 101
- Water District 71
- Cemetery District 47
- Non Profit - Conservation 39
- Flood District 32
- Port/Harbor District 27
- Non Profit - Other 27
- County Agency - Other 14
- Irrigation District 6
- Sanitation District 6
- Special District - Other 6
- Non Profit - Cemetery District 5
- Joint Powers Authority 2
- Other 2
- Conservation District 2
- Non Profit - Education 2
- Airport District 1
- Metropolitan Planning Organization 1
- Utility 1
- Transportation Agency 1
ACCESS_TYP 1
- Open Access · 10,567 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3340 | 3340 | 3339 | {"type": "Polygon", "coordinates": [[[-121.85534, 36.57982], [-121.85525, 36.57992], [-121.85519, 36.57986], [-121.85475, 36.58], [-121.85446, 36.57938], [-121.85488, 36.57925], [-121.85494, 36.57919], [-121.85503, 36.57922], [-121.85515, 36.57922], [-121.85534, 36.57982]]]} | Open Access 1 | Fishermans Flats Park | 18924 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 1.108 | Fishermans Flats Park | ||
3342 | 3342 | 3341 | {"type": "Polygon", "coordinates": [[[-121.68802, 38.15957], [-121.68737, 38.16052], [-121.68654, 38.16013], [-121.68724, 38.15917], [-121.68802, 38.15957]]]} | Open Access 1 | Fishing Access Park | 18925 | 1276 | Rio Vista, City of 324 | City 2 | City Agency 2 | http://riovistacity.com/parks-dept/ | City 2 | 2.495 | FA Park | ||
3343 | 3343 | 3342 | {"type": "Polygon", "coordinates": [[[-121.45444, 38.42969], [-121.45442, 38.43075], [-121.45442, 38.43083], [-121.45439, 38.43086], [-121.45317, 38.43087], [-121.45288, 38.43085], [-121.45288, 38.42967], [-121.45444, 38.42969]]]} | Open Access 1 | Fite Park | 18926 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 4.4 | Fite Park | ||
3348 | 3348 | 3347 | {"type": "Polygon", "coordinates": [[[-122.15575, 38.04966], [-122.15517, 38.05049], [-122.15412, 38.04999], [-122.15467, 38.04915], [-122.15575, 38.04966]]]} | Open Access 1 | Fitzgerald Park | 18929 | 1027 | Benicia, City of 344 | City 2 | City Agency 2 | http://ci.benicia.ca.us/parks | City 2 | 2.827 | Fitzgerald Park | ||
3349 | 3349 | 3348 | {"type": "Polygon", "coordinates": [[[-121.73394, 37.98555], [-121.73394, 37.98694], [-121.73255, 37.98694], [-121.73255, 37.98555], [-121.73394, 37.98555]]]} | Open Access 1 | Crockett Park | 17829 | 1229 | Oakley, City of 251 | City 2 | City Agency 2 | http://www.ci.oakley.ca.us/subpage.cfm?id=441408 | City 2 | 4.666 | Crockett Park | ||
3350 | 3350 | 3349 | {"type": "Polygon", "coordinates": [[[-117.17162, 32.68965], [-117.17162, 32.68965], [-117.17145, 32.68995], [-117.1713, 32.68952], [-117.17162, 32.68965]]]} | Open Access 1 | Cronan Park | https://www.coronado.ca.us/cms/one.aspx?portalId=746090&pageId=3814919 | 17830 | 1069 | Coronado, City of 102 | City 2 | City Agency 2 | http://www.coronado.ca.us/category/subcategory-rec.php | City 2 | 0.154 | Cronan Park | |
3351 | 3351 | 3350 | {"type": "Polygon", "coordinates": [[[-120.66948, 35.27794], [-120.66942, 35.27805], [-120.66924, 35.27827], [-120.66871, 35.27798], [-120.66901, 35.27765], [-120.66948, 35.27794]]]} | Open Access 1 | Dana Adobe | 17907 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 0.619 | Dana Adobe | ||
3353 | 3353 | 3352 | {"type": "Polygon", "coordinates": [[[-117.74366, 33.98107], [-117.74298, 33.98167], [-117.74275, 33.98189], [-117.74264, 33.9819], [-117.7419, 33.9814], [-117.74165, 33.98124], [-117.74134, 33.98108], [-117.74131, 33.98104], [-117.74132, 33.981], [-117.74193, 33.98005], [-117.74207, 33.97987], [-117.74236, 33.97957], [-117.74262, 33.97933], [-117.74366, 33.98107]]]} | Open Access 1 | Crossroads Park | 17832 | 1054 | Chino Hills, City of 116 | City 2 | City Agency 2 | http://www.chinohills.org/index.aspx?nid=364 | City 2 | 8.092 | Crossroads Park | ||
3354 | 3354 | 3353 | {"type": "MultiPolygon", "coordinates": [[[[-118.27963, 34.43891], [-118.27942, 34.44], [-118.27919, 34.43986], [-118.27895, 34.43975], [-118.27854, 34.4396], [-118.27563, 34.4389], [-118.27528, 34.43884], [-118.27503, 34.43882], [-118.27478, 34.43883], [-118.27453, 34.43886], [-118.27415, 34.43895], [-118.2739, 34.43904], [-118.27307, 34.43944], [-118.27278, 34.43957], [-118.27249, 34.43966], [-118.27218, 34.43973], [-118.27214, 34.43775], [-118.27694, 34.43776], [-118.27882, 34.43867], [-118.2793, 34.43883], [-118.27963, 34.43891]]], [[[-118.27986, 34.44135], [-118.27222, 34.44131], [-118.2722, 34.44029], [-118.2726, 34.44021], [-118.27309, 34.44005], [-118.2734, 34.43992], [-118.27412, 34.43956], [-118.27445, 34.43944], [-118.2748, 34.43938], [-118.27503, 34.43937], [-118.27527, 34.43939], [-118.27822, 34.44009], [-118.27858, 34.44021], [-118.27891, 34.44037], [-118.27921, 34.44059], [-118.27947, 34.44086], [-118.27986, 34.44135]]]]} | Open Access 1 | Bird's Nest | 33245 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 51.382 | Bird's Nest | 2018 | |
3355 | 3355 | 3354 | {"type": "Polygon", "coordinates": [[[-117.59328, 34.07568], [-117.58472, 34.07562], [-117.58471, 34.07381], [-117.58569, 34.07381], [-117.5857, 34.0738], [-117.58569, 34.07305], [-117.58474, 34.07304], [-117.58474, 34.07199], [-117.59321, 34.07205], [-117.59322, 34.07294], [-117.59323, 34.07295], [-117.59327, 34.07292], [-117.59328, 34.07568]]]} | Open Access 1 | Cucamonga-Guasti Regional Park | 17846 | 318 | San Bernardino, County of 363 | County 3 | County Agency 3 | http://cms.sbcounty.gov/parks/Home.aspx | County 3 | 76.486 | Cucamonga-Guasti RP | ||
3356 | 3356 | 3355 | {"type": "MultiPolygon", "coordinates": [[[[-121.30085, 38.68737], [-121.30066, 38.68739], [-121.29997, 38.68774], [-121.29947, 38.68774], [-121.29946, 38.68709], [-121.29977, 38.68709], [-121.29988, 38.68719], [-121.30039, 38.68715], [-121.30044, 38.68715], [-121.30082, 38.68698], [-121.30085, 38.68737]]], [[[-121.30537, 38.68726], [-121.30541, 38.68736], [-121.30543, 38.68748], [-121.30543, 38.68761], [-121.3054, 38.68772], [-121.30529, 38.68792], [-121.30518, 38.68804], [-121.30508, 38.68811], [-121.30454, 38.68839], [-121.30434, 38.68847], [-121.30414, 38.6885], [-121.30344, 38.6885], [-121.30319, 38.68804], [-121.30306, 38.68786], [-121.30289, 38.68742], [-121.30269, 38.68724], [-121.30237, 38.68711], [-121.30205, 38.68707], [-121.30106, 38.68731], [-121.301, 38.68664], [-121.30186, 38.68661], [-121.3024, 38.68638], [-121.3024, 38.68641], [-121.30327, 38.68679], [-121.30338, 38.68778], [-121.30377, 38.68796], [-121.30413, 38.68793], [-121.30537, 38.68726]]], [[[-121.30762, 38.68752], [-121.30717, 38.68784], [-121.30705, 38.68749], [-121.30663, 38.68722], [-121.30615, 38.68718], [-121.30564, 38.68742], [-121.3056, 38.68727], [-121.3055, 38.68709], [-121.30481, 38.68624], [-121.30473, 38.68611], [-121.30553, 38.68598], [-121.30641, 38.68555], [-121.30762, 38.68752]]]]} | Open Access 1 | Crosswoods Park | 17833 | 2199 | Sunrise Recreation and Park District 639 | Special District 4 | Recreation/Parks District 4 | http://sunriseparks.com/ | Special District 4 | 15.696 | Crosswoods Park | ||
3357 | 3357 | 3356 | {"type": "Polygon", "coordinates": [[[-121.44822, 38.49495], [-121.4482, 38.49517], [-121.44786, 38.49499], [-121.44687, 38.49483], [-121.44598, 38.49481], [-121.44504, 38.49472], [-121.44491, 38.49465], [-121.44535, 38.49428], [-121.44562, 38.49428], [-121.44583, 38.4941], [-121.44645, 38.49453], [-121.44665, 38.49463], [-121.44686, 38.49472], [-121.44727, 38.49483], [-121.44822, 38.49495]]]} | Open Access 1 | Crowfoot Park | 17834 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 2.128 | Crowfoot Park | ||
3359 | 3359 | 3358 | {"type": "Polygon", "coordinates": [[[-117.07528, 33.4991], [-117.07508, 33.49922], [-117.07485, 33.49926], [-117.07477, 33.49928], [-117.07472, 33.49934], [-117.07471, 33.49943], [-117.07465, 33.49937], [-117.07456, 33.49911], [-117.07455, 33.49897], [-117.07444, 33.49882], [-117.07437, 33.49867], [-117.07419, 33.49838], [-117.0741, 33.49817], [-117.07404, 33.49763], [-117.07405, 33.49747], [-117.07413, 33.49735], [-117.07447, 33.49703], [-117.07482, 33.49778], [-117.07483, 33.4979], [-117.07478, 33.49807], [-117.07479, 33.49817], [-117.07528, 33.4991]]]} | Open Access 1 | Crown Hill Park | 17836 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 3.554 | Crown Hill Park | ||
3360 | 3360 | 3359 | {"type": "Polygon", "coordinates": [[[-117.71189, 33.52976], [-117.71141, 33.53052], [-117.71123, 33.53133], [-117.71118, 33.53213], [-117.71108, 33.53287], [-117.71045, 33.53324], [-117.71019, 33.53335], [-117.71002, 33.53355], [-117.70961, 33.53416], [-117.7094, 33.53408], [-117.70903, 33.53401], [-117.70864, 33.53413], [-117.70792, 33.53388], [-117.70804, 33.53366], [-117.70816, 33.53205], [-117.70601, 33.53084], [-117.7074, 33.53018], [-117.70779, 33.52996], [-117.70829, 33.52961], [-117.70843, 33.52961], [-117.70855, 33.52951], [-117.70855, 33.5294], [-117.70878, 33.52919], [-117.70902, 33.52894], [-117.70934, 33.52857], [-117.70962, 33.52817], [-117.70981, 33.52793], [-117.71023, 33.52749], [-117.71058, 33.52781], [-117.71057, 33.5279], [-117.71077, 33.52798], [-117.71076, 33.52832], [-117.71089, 33.52864], [-117.71147, 33.52941], [-117.71189, 33.52976]]]} | Open Access 1 | Crown Valley Community Park | 17837 | 1166 | Laguna Niguel, City of 525 | City 2 | City Agency 2 | http://www.cityoflagunaniguel.org/index.aspx?nid=12 | City 2 | 48.004 | Crown Valley Community Park | ||
3361 | 3361 | 3360 | {"type": "Polygon", "coordinates": [[[-117.64889, 33.64769], [-117.64859, 33.64778], [-117.64842, 33.64786], [-117.64826, 33.64796], [-117.64798, 33.64819], [-117.64775, 33.64808], [-117.64751, 33.64791], [-117.64738, 33.64774], [-117.64723, 33.64738], [-117.64716, 33.64719], [-117.64712, 33.64686], [-117.64713, 33.64652], [-117.64727, 33.64615], [-117.64741, 33.6462], [-117.64804, 33.64651], [-117.64803, 33.64661], [-117.6481, 33.64669], [-117.64837, 33.64685], [-117.6486, 33.64703], [-117.6487, 33.64715], [-117.64876, 33.64727], [-117.64889, 33.64765], [-117.64889, 33.64769]]]} | Open Access 1 | Crucero Park | 17838 | 1207 | Mission Viejo, City of 178 | City 2 | City Agency 2 | http://cityofmissionviejo.org/ | City 2 | 5.477 | Crucero Park | ||
3362 | 3362 | 3361 | {"type": "Polygon", "coordinates": [[[-115.48727, 32.67578], [-115.48625, 32.6758], [-115.48625, 32.67464], [-115.48727, 32.67463], [-115.48727, 32.67578]]]} | Open Access 1 | Crummett Park | 17840 | 1451 | Calexico, City of 596 | City 2 | City Agency 2 | http://www.calexicorecreation.org/parks | City 2 | 3.029 | Crummett Park | ||
3363 | 3363 | 3362 | {"type": "Polygon", "coordinates": [[[-117.21754, 33.58942], [-117.21704, 33.5898], [-117.2169, 33.58988], [-117.21649, 33.58952], [-117.21708, 33.58907], [-117.21716, 33.58907], [-117.21754, 33.58942]]]} | Open Access 1 | Crystal Aire Park | 17842 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 1.112 | Crystal Aire Park | ||
3364 | 3364 | 3363 | {"type": "Polygon", "coordinates": [[[-117.69339, 33.46661], [-117.69327, 33.46682], [-117.69286, 33.4667], [-117.69222, 33.46655], [-117.69079, 33.46631], [-117.69087, 33.46607], [-117.69253, 33.46636], [-117.69294, 33.46646], [-117.69339, 33.46661]]]} | Open Access 1 | Crystal Cove Park | 17844 | 1079 | Dana Point, City of 131 | City 2 | City Agency 2 | http://www.danapoint.org/index.aspx?page=170 | City 2 | 1.606 | Crystal Cove Park | ||
3366 | 3366 | 3365 | {"type": "Polygon", "coordinates": [[[-117.03519, 32.61371], [-117.03432, 32.61396], [-117.03398, 32.61417], [-117.03397, 32.61419], [-117.03366, 32.61425], [-117.03363, 32.61401], [-117.03365, 32.61375], [-117.03368, 32.61363], [-117.03396, 32.61295], [-117.03424, 32.61301], [-117.03431, 32.61284], [-117.03436, 32.61267], [-117.03438, 32.61247], [-117.03436, 32.61198], [-117.0344, 32.61182], [-117.03447, 32.61169], [-117.03467, 32.61177], [-117.03472, 32.61192], [-117.03453, 32.612], [-117.03519, 32.61371]]]} | Open Access 1 | Flair Slopes Open Space | 18937 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 4.507 | Flair Slopes OS | ||
3367 | 3367 | 3366 | {"type": "Polygon", "coordinates": [[[-122.1749, 37.47544], [-122.17257, 37.4755], [-122.17117, 37.47701], [-122.16922, 37.47588], [-122.16884, 37.47589], [-122.17024, 37.47319], [-122.17411, 37.47515], [-122.17446, 37.4753], [-122.1749, 37.47544]]]} | Open Access 1 | Flood Park | 18954 | 324 | San Mateo County Parks and Recreation Dept., County of 28 | County 3 | County Agency - Parks 7 | http://www.co.sanmateo.ca.us/portal/site/parks/ | County 3 | 23.33 | Flood Park | 2000 |
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]);