superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
15,638 rows
This data as json, copyable, CSV (advanced)
MNG_AG_TYP >30
- City Agency 8,161
- County Agency 858
- Recreation/Parks District 838
- State Agency 624
- Non Profit - Land Trust 426
- Open Space District 199
- Federal Agency 179
- County Agency - Parks 173
- Water District 159
- Community Services District 154
- Home Owners Association 134
- Non Profit - Conservation 97
- Flood District 74
- Cemetery District 47
- Non Profit - Other 33
- County Agency - Other 27
- Port/Harbor District 27
- Irrigation District 16
- School District 13
- Commercial 10
- Sanitation District 9
- Special District - Other 6
- Other 5
- Non Profit - Cemetery District 5
- Conservation District 5
- Joint Powers Authority 4
- Mitigation Bank 4
- Transportation Agency 4
- Non Profit - Education 3
- Metropolitan Planning Organization 2
- …
MNG_AGENCY >30
- Los Angeles, City of 388
- San Diego, City of 376
- California Department of Fish and Wildlife 296
- San Jose, City of 188
- San Francisco, City and County of 177
- Sacramento, City of 173
- California Department of Parks and Recreation 163
- Mountains Recreation and Conservation Authority 153
- Ventura, City of 141
- Los Angeles, County of 140
- Long Beach, City of 124
- San Diego, County of 113
- Roseville, City of 110
- East Bay Regional Park District 104
- Oakland, City of 89
- Irvine, City of 84
- Fresno, City of 83
- Consumnes Community Services District 78
- Santa Barbara, County of 71
- Torrance, City of 69
- Orange, County of 68
- Hayward Area Recreation and Park District 65
- Stockton, City of 65
- Huntington Beach, City of 64
- Tracy, City of 63
- Modesto, City of 62
- Santa Cruz, City of 61
- Poway, City of 61
- Chula Vista, City of 60
- Los Angeles - Department of Parks and Recreation, County of 58
- …
ACCESS_TYP 4
- Open Access 10,567
- Restricted Access 871
- No Public Access 628
- Unknown Access 233
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 | ||
3341 | 3341 | 3340 | {"type": "Polygon", "coordinates": [[[-118.00977, 34.00681], [-118.00047, 34.02256], [-117.99322, 34.01961], [-117.99553, 34.01569], [-117.99582, 34.01579], [-117.99633, 34.01493], [-117.99605, 34.0148], [-118.00515, 33.99931], [-118.00592, 33.99969], [-118.00608, 33.99979], [-118.00624, 33.99992], [-118.00635, 34.00003], [-118.00702, 34.00098], [-118.00716, 34.00115], [-118.00742, 34.00135], [-118.00767, 34.00147], [-118.0079, 34.00193], [-118.00888, 34.00585], [-118.00977, 34.00681]]]} | Unknown Access 4 | Hacienda Hills Open Space - Sanitation District | 29676 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 419.345 | Hacienda Hills OS - Sanitation District | ||
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 | ||
3344 | 3344 | 3343 | {"type": "Polygon", "coordinates": [[[-118.15633, 33.9544], [-118.15556, 33.95835], [-118.15532, 33.95831], [-118.15543, 33.95776], [-118.15532, 33.95757], [-118.15526, 33.95754], [-118.15527, 33.9572], [-118.15505, 33.95697], [-118.15296, 33.95675], [-118.15268, 33.95647], [-118.15483, 33.95531], [-118.15633, 33.9544]]]} | Restricted Access 2 | Bell Gardens Golf Course at Ford Park | 33117 | 1023 | Bell Gardens, City of 222 | City 2 | City Agency 2 | http://www.bellgardens.org/GOVERNMENT/CityDepartments/RecreationCommunityServices/ParksandFacilities.aspx | City 2 | 12.798 | Bell Gardens GC at Ford Park | ||
3345 | 3345 | 3344 | {"type": "Polygon", "coordinates": [[[-118.44985, 34.49555], [-118.44095, 34.49537], [-118.44088, 34.48111], [-118.44536, 34.48112], [-118.44538, 34.48475], [-118.44984, 34.48473], [-118.44985, 34.49555]]]} | Unknown Access 4 | Texas Canyon Open Space | 29702 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 281.452 | Texas Canyon OS | ||
3346 | 3346 | 3345 | {"type": "Polygon", "coordinates": [[[-118.14026, 33.782], [-118.14026, 33.78244], [-118.13519, 33.78245], [-118.13517, 33.78214], [-118.13189, 33.78191], [-118.1286, 33.77948], [-118.1286, 33.77543], [-118.13159, 33.77543], [-118.13155, 33.77619], [-118.13253, 33.77718], [-118.13431, 33.77757], [-118.13695, 33.77795], [-118.1371, 33.77794], [-118.13729, 33.77819], [-118.13734, 33.77832], [-118.13746, 33.77879], [-118.13743, 33.77907], [-118.13769, 33.77961], [-118.13781, 33.77978], [-118.13825, 33.78024], [-118.1386, 33.78072], [-118.13873, 33.78094], [-118.13906, 33.78131], [-118.13928, 33.78148], [-118.13951, 33.78164], [-118.13984, 33.78183], [-118.14026, 33.782]]]} | Restricted Access 2 | Recreation Park 18 Hole Golf Course | 33116 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 119.653 | Rec. Park 18 Hole GC | ||
3347 | 3347 | 3346 | {"type": "Polygon", "coordinates": [[[-117.78685, 34.08806], [-117.78682, 34.08835], [-117.78544, 34.08847], [-117.78504, 34.08833], [-117.78493, 34.08852], [-117.78422, 34.08859], [-117.78404, 34.08903], [-117.78042, 34.08809], [-117.78037, 34.08814], [-117.77867, 34.08717], [-117.77694, 34.08624], [-117.77697, 34.0862], [-117.77697, 34.08618], [-117.77522, 34.08526], [-117.77486, 34.08403], [-117.77477, 34.08386], [-117.77462, 34.08372], [-117.77291, 34.08262], [-117.77288, 34.08258], [-117.77288, 34.08254], [-117.77303, 34.08229], [-117.77324, 34.08205], [-117.77352, 34.08184], [-117.77384, 34.08168], [-117.77419, 34.08158], [-117.77414, 34.08161], [-117.77559, 34.08135], [-117.77669, 34.08111], [-117.77718, 34.08098], [-117.77767, 34.08079], [-117.77822, 34.08051], [-117.77878, 34.08014], [-117.77903, 34.07993], [-117.77937, 34.07959], [-117.77961, 34.07928], [-117.77973, 34.07925], [-117.7799, 34.07934], [-117.78382, 34.08108], [-117.78098, 34.08373], [-117.78203, 34.08538], [-117.78408, 34.0849], [-117.78541, 34.08509], [-117.78685, 34.08806]]]} | Restricted Access 2 | Mountain Meadows Golf Course | http://parks.lacounty.gov/wps/portal/dpr/ThingsToDo/Golf/Mountain_Meadows_Golf_Course | 33118 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 165.229 | Mtn. Meadows GC | |
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 | ||
3352 | 3352 | 3351 | {"type": "Polygon", "coordinates": [[[-120.9889, 38.82713], [-120.98787, 38.82714], [-120.98483, 38.82713], [-120.98488, 38.82712], [-120.98485, 38.82698], [-120.98311, 38.8197], [-120.9866, 38.81975], [-120.98651, 38.82011], [-120.98625, 38.82065], [-120.98624, 38.82099], [-120.98631, 38.82126], [-120.98631, 38.8213], [-120.9865, 38.82179], [-120.98694, 38.82251], [-120.98712, 38.82289], [-120.9872, 38.823], [-120.98759, 38.82338], [-120.98777, 38.82376], [-120.98792, 38.82394], [-120.98822, 38.82421], [-120.98854, 38.82472], [-120.98858, 38.82499], [-120.98872, 38.82552], [-120.989, 38.82633], [-120.98901, 38.8266], [-120.98898, 38.82699], [-120.9889, 38.82713]]]} | No Public Access 3 | Cronan Ranch | 17831 | 3003 | American River Conservancy 593 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.arconservancy.org/ | Non Governmental Organization 10 | 63.637 | Cronan Ranch | ||
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 | ||
3358 | 3358 | 3357 | {"type": "Polygon", "coordinates": [[[-118.72648, 37.55749], [-118.72642, 37.56318], [-118.72642, 37.56318], [-118.72457, 37.56217], [-118.72298, 37.55769], [-118.7229, 37.55769], [-118.7228, 37.55746], [-118.72648, 37.55749]]]} | No Public Access 3 | Crowley Hilltop Preserve | 17835 | 3103 | Eastern Sierra Land Trust 654 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.easternsierralandtrust.org/ | Non Governmental Organization 10 | 33.238 | Crowley Hilltop Preserve | ||
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 |
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]);