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 6,546
- County Agency 728
- Recreation/Parks District 705
- State Agency 582
- Non Profit - Land Trust 369
- Open Space District 183
- Federal Agency 167
- County Agency - Parks 159
- Water District 150
- Home Owners Association 123
- Community Services District 122
- Non Profit - Conservation 92
- Flood District 63
- Cemetery District 34
- Non Profit - Other 27
- County Agency - Other 25
- Port/Harbor District 20
- Irrigation District 16
- School District 13
- Commercial 10
- Sanitation District 6
- Special District - Other 5
- Other 5
- Joint Powers Authority 4
- Non Profit - Cemetery District 4
- Mitigation Bank 4
- Conservation District 4
- Transportation Agency 4
- Non Profit - Education 3
- Metropolitan Planning Organization 2
- …
MNG_AGENCY >30
- San Diego, City of 358
- Los Angeles, City of 333
- California Department of Fish and Wildlife 285
- California Department of Parks and Recreation 160
- San Jose, City of 143
- Mountains Recreation and Conservation Authority 137
- Ventura, City of 135
- San Francisco, City and County of 134
- Sacramento, City of 133
- Los Angeles, County of 120
- Long Beach, City of 109
- East Bay Regional Park District 97
- San Diego, County of 96
- Roseville, City of 94
- Fresno, City of 67
- Oakland, City of 64
- Santa Barbara, County of 63
- Consumnes Community Services District 62
- Orange, County of 60
- Poway, City of 59
- Los Angeles - Department of Parks and Recreation, County of 57
- Torrance, City of 56
- Santa Cruz, City of 55
- Lake, County of 51
- Davis, City of 50
- Napa, City of 50
- Rocklin, City of 49
- Stockton, City of 48
- Clovis, City of 48
- Yuba County Water Agency 48
- …
ACCESS_TYP 4
- Open Access 8,609
- Restricted Access 793
- No Public Access 567
- Unknown Access 209
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5461 | 5461 | 5460 | {"type": "Polygon", "coordinates": [[[-116.45116, 34.11294], [-116.44916, 34.11324], [-116.44915, 34.11212], [-116.45112, 34.11212], [-116.45116, 34.11217], [-116.45116, 34.11294]]]} | Open Access 1 | Jacobs Park | 20330 | 1356 | Yucca Valley, Town of 267 | City 2 | City Agency 2 | http://www.yucca-valley.org/ | City 2 | 4.908 | Jacobs Park | ||
5462 | 5462 | 5461 | {"type": "Polygon", "coordinates": [[[-121.78692, 38.00858], [-121.78687, 38.00878], [-121.78677, 38.0088], [-121.78661, 38.00949], [-121.78662, 38.0095], [-121.78665, 38.0095], [-121.78658, 38.00977], [-121.78609, 38.00977], [-121.78643, 38.00858], [-121.78692, 38.00858]]]} | Open Access 1 | Jacobsen Park | 20332 | 1007 | Antioch, City of 347 | City 2 | City Agency 2 | http://www.ci.antioch.ca.us/Recreation/parks.asp | City 2 | 1.293 | Jacobsen Park | ||
5463 | 5463 | 5462 | {"type": "Polygon", "coordinates": [[[-121.96099, 36.97023], [-121.95986, 36.97023], [-121.95983, 36.97013], [-121.95832, 36.97013], [-121.95832, 36.96878], [-121.96098, 36.96853], [-121.96099, 36.97023]]]} | Open Access 1 | Jade Street Park | 20334 | 1044 | Capitola, City of 109 | City 2 | City Agency 2 | http://www.cityofcapitola.org/publicworks/page/parks | City 2 | 9.882 | Jade Street Park | ||
5464 | 5464 | 5463 | {"type": "Polygon", "coordinates": [[[-117.55597, 33.83411], [-117.55531, 33.83547], [-117.55479, 33.83646], [-117.55375, 33.83618], [-117.55329, 33.83601], [-117.55276, 33.83579], [-117.55424, 33.83354], [-117.55458, 33.83373], [-117.55476, 33.83382], [-117.55496, 33.83389], [-117.55532, 33.834], [-117.55597, 33.83411]]]} | Open Access 1 | Jameson Park | 20356 | 1068 | Corona, City of 63 | City 2 | City Agency 2 | http://www.coronadwp.com/parkmaint/index.shtml | City 2 | 13.039 | Jameson Park | ||
5465 | 5465 | 5464 | {"type": "Polygon", "coordinates": [[[-117.7142, 34.13204], [-117.71411, 34.13207], [-117.71382, 34.13206], [-117.71377, 34.13209], [-117.71373, 34.13213], [-117.71362, 34.13213], [-117.71333, 34.13222], [-117.7128, 34.13225], [-117.71263, 34.13188], [-117.71254, 34.13155], [-117.71251, 34.13118], [-117.71252, 34.13102], [-117.71254, 34.13094], [-117.71298, 34.13095], [-117.71317, 34.13084], [-117.71338, 34.13068], [-117.71343, 34.1307], [-117.71343, 34.13078], [-117.71346, 34.13085], [-117.71371, 34.13118], [-117.71381, 34.13124], [-117.71393, 34.13125], [-117.71398, 34.1313], [-117.71395, 34.13139], [-117.71396, 34.13148], [-117.71411, 34.1317], [-117.71416, 34.13197], [-117.7142, 34.13204]]]} | Open Access 1 | Jaeger Park | 20335 | 1057 | Claremont, City of 6 | City 2 | City Agency 2 | http://www.ci.claremont.ca.us/ps.leisurerecreation.cfm?ID=1709 | City 2 | 4.44 | Jaeger Park | ||
5466 | 5466 | 5465 | {"type": "MultiPolygon", "coordinates": [[[[-117.78673, 33.54375], [-117.7867, 33.54378], [-117.78638, 33.54383], [-117.78598, 33.54395], [-117.78559, 33.54408], [-117.78529, 33.54424], [-117.78506, 33.54438], [-117.78457, 33.54475], [-117.78442, 33.54482], [-117.78426, 33.54487], [-117.78487, 33.54438], [-117.78525, 33.54413], [-117.78585, 33.54388], [-117.78642, 33.54371], [-117.78662, 33.54368], [-117.78669, 33.5437], [-117.78673, 33.54375]]], [[[-117.78787, 33.54378], [-117.78747, 33.54374], [-117.78715, 33.54373], [-117.78702, 33.54373], [-117.78683, 33.54376], [-117.7868, 33.54374], [-117.78677, 33.54369], [-117.78702, 33.54364], [-117.78703, 33.54357], [-117.78714, 33.54356], [-117.78717, 33.54352], [-117.78787, 33.54378]]]]} | Open Access 1 | Jahraus Park | 20336 | 1164 | Laguna Beach, City of 177 | City 2 | City Agency 2 | http://www.lagunabeachcity.net/cityhall/pw/parks.asp | City 2 | 0.988 | Jahraus Park | ||
5467 | 5467 | 5466 | {"type": "Polygon", "coordinates": [[[-118.58186, 34.38143], [-118.5814, 34.38179], [-118.58125, 34.38199], [-118.58102, 34.38221], [-118.58064, 34.38249], [-118.58034, 34.38267], [-118.57979, 34.38198], [-118.57962, 34.38135], [-118.57997, 34.38127], [-118.58047, 34.38112], [-118.58096, 34.38092], [-118.58127, 34.38077], [-118.58185, 34.38136], [-118.58186, 34.38143]]]} | Open Access 1 | Jake Kuredjian Park | 20337 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 5.753 | Jake Kuredjian Park | ||
5468 | 5468 | 5467 | {"type": "Polygon", "coordinates": [[[-120.5041, 34.51207], [-120.501, 34.51213], [-120.49956, 34.5122], [-120.49927, 34.5116], [-120.49962, 34.51149], [-120.49953, 34.51118], [-120.49947, 34.51085], [-120.49943, 34.51052], [-120.49942, 34.51018], [-120.49944, 34.50985], [-120.4995, 34.50952], [-120.49989, 34.50953], [-120.49989, 34.50973], [-120.50073, 34.50985], [-120.50074, 34.50865], [-120.50101, 34.50799], [-120.5041, 34.51207]]]} | Open Access 1 | Jalama Beach County Park | 20338 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 26.639 | Jalama Beach County Park | ||
5469 | 5469 | 5468 | {"type": "Polygon", "coordinates": [[[-122.01903, 37.65238], [-122.0182, 37.65246], [-122.01762, 37.65137], [-122.0177, 37.65132], [-122.01782, 37.65088], [-122.01797, 37.65081], [-122.01824, 37.65078], [-122.01828, 37.65093], [-122.01836, 37.65112], [-122.01892, 37.65202], [-122.01899, 37.65217], [-122.01903, 37.65238]]]} | Open Access 1 | Jalquin Vista Park | 20339 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 3.154 | Jalquin Vista Park | ||
5470 | 5470 | 5469 | {"type": "Polygon", "coordinates": [[[-121.33031, 38.75424], [-121.33027, 38.75428], [-121.32987, 38.75429], [-121.32986, 38.75538], [-121.32913, 38.75519], [-121.32896, 38.75513], [-121.32875, 38.75502], [-121.32837, 38.75476], [-121.32797, 38.7546], [-121.32792, 38.75455], [-121.32793, 38.7545], [-121.32819, 38.75407], [-121.32825, 38.75403], [-121.32874, 38.75417], [-121.32889, 38.75419], [-121.3291, 38.75419], [-121.32942, 38.75414], [-121.32993, 38.75394], [-121.32997, 38.75396], [-121.33016, 38.75414], [-121.33031, 38.75424]]]} | Open Access 1 | James A. Hall Park | 20341 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 4.364 | James A. Hall Park | ||
5471 | 5471 | 5470 | {"type": "Polygon", "coordinates": [[[-118.23663, 33.85793], [-118.23508, 33.85798], [-118.23505, 33.85798], [-118.23501, 33.85795], [-118.23484, 33.85606], [-118.23486, 33.856], [-118.2349, 33.85598], [-118.23655, 33.85594], [-118.23663, 33.85793]]]} | Open Access 1 | James Anderson, Jr. Memorial Park | 20342 | 1048 | Carson, City of 300 | City 2 | City Agency 2 | http://ci.carson.ca.us/content/department/pub_service/parks_rec_parks.asp | City 2 | 8.449 | James Anderson, Jr. Memorial Park | ||
5472 | 5472 | 5471 | {"type": "Polygon", "coordinates": [[[-117.59289, 33.97159], [-117.59218, 33.97181], [-117.58877, 33.97278], [-117.58866, 33.97294], [-117.58864, 33.97293], [-117.58875, 33.97278], [-117.58875, 33.97258], [-117.58833, 33.97238], [-117.58852, 33.97211], [-117.58873, 33.9719], [-117.58897, 33.97171], [-117.58923, 33.97155], [-117.5896, 33.97137], [-117.59057, 33.97103], [-117.59166, 33.97069], [-117.59189, 33.97065], [-117.59195, 33.97061], [-117.592, 33.97055], [-117.59201, 33.97048], [-117.59199, 33.9704], [-117.59287, 33.97039], [-117.59289, 33.97159]]]} | Open Access 1 | James C. Huber Park | 20343 | 2331 | Jurupa Community Services District 667 | Special District 4 | Community Services District 17 | http://parks.jcsd.us/ | Special District 4 | 13.185 | James C. Huber Park | ||
5473 | 5473 | 5472 | {"type": "Polygon", "coordinates": [[[-117.62638, 34.06698], [-117.62572, 34.06698], [-117.62562, 34.06656], [-117.6253, 34.06659], [-117.62509, 34.06526], [-117.62636, 34.06526], [-117.62636, 34.06667], [-117.62638, 34.0667], [-117.62638, 34.06698]]]} | Open Access 1 | James Galanis Park | 20344 | 1232 | Ontario, City of 123 | City 2 | City Agency 2 | http://www.ci.ontario.ca.us/index.aspx?page=456 | City 2 | 4.629 | James Galanis Park | ||
5474 | 5474 | 5473 | {"type": "MultiPolygon", "coordinates": [[[[-119.20631, 36.19626], [-119.18947, 36.19617], [-119.1893, 36.18901], [-119.20624, 36.18912], [-119.20631, 36.19626]]], [[[-119.20652, 36.21066], [-119.19441, 36.21065], [-119.19394, 36.19634], [-119.20632, 36.19639], [-119.20652, 36.21066]]]]} | Restricted Access 2 | James K. Herbert Wetland Prairie Preserve | 20345 | 3076 | Sequoia Riverlands Trust 106 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sequoiariverlands.org | Non Governmental Organization 10 | 729.169 | James K. Herbert Wetland Prairie Preserve | 2000 | |
5475 | 5475 | 5474 | {"type": "Polygon", "coordinates": [[[-122.2979, 37.87249], [-122.29699, 37.87267], [-122.29647, 37.87108], [-122.29739, 37.8709], [-122.2979, 37.87249]]]} | Open Access 1 | James Kenney Park | 20346 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 3.73 | James Kenney Park | ||
5476 | 5476 | 5475 | {"type": "Polygon", "coordinates": [[[-122.40691, 37.75001], [-122.40661, 37.75019], [-122.40662, 37.75036], [-122.40641, 37.75038], [-122.40626, 37.75063], [-122.40623, 37.75064], [-122.40551, 37.74928], [-122.40551, 37.74924], [-122.40555, 37.74921], [-122.40567, 37.74917], [-122.40642, 37.74905], [-122.4069, 37.74994], [-122.40691, 37.75001]]]} | Open Access 1 | James Rolph Jr Playground | 20351 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 2.931 | James Rolph Jr Playground | ||
5477 | 5477 | 5476 | {"type": "Polygon", "coordinates": [[[-117.27216, 32.97823], [-117.27163, 32.97837], [-117.27093, 32.97727], [-117.27056, 32.97727], [-117.27028, 32.97763], [-117.27008, 32.97763], [-117.27008, 32.97728], [-117.26992, 32.97726], [-117.27001, 32.9771], [-117.2701, 32.97682], [-117.27025, 32.97658], [-117.27069, 32.97614], [-117.2714, 32.97626], [-117.27163, 32.97667], [-117.27181, 32.97708], [-117.27206, 32.97782], [-117.27216, 32.97823]]]} | Open Access 1 | James Scripps Bluff Preserve | 20352 | 1082 | Del Mar, City of 91 | City 2 | City Agency 2 | http://www.delmar.ca.us/203/Beaches-Parks | City 2 | 6.334 | James Scripps Bluff Preserve | ||
5478 | 5478 | 5477 | {"type": "Polygon", "coordinates": [[[-121.2517, 37.81523], [-121.25103, 37.81524], [-121.24931, 37.81423], [-121.24937, 37.81417], [-121.24957, 37.81426], [-121.24958, 37.81428], [-121.24983, 37.81433], [-121.25153, 37.81434], [-121.25157, 37.81439], [-121.25158, 37.81486], [-121.25168, 37.81513], [-121.2517, 37.81523]]]} | Open Access 1 | Monte Bello Park | 33015 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 2.999 | Monte Bello Park | ||
5479 | 5479 | 5478 | {"type": "Polygon", "coordinates": [[[-122.26763, 37.79791], [-122.26733, 37.7984], [-122.26639, 37.79803], [-122.2667, 37.79755], [-122.26763, 37.79791]]]} | Open Access 1 | Madison Square | 21660 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1.377 | Madison Square | ||
5480 | 5480 | 5479 | {"type": "Polygon", "coordinates": [[[-121.31804, 38.75775], [-121.31713, 38.75822], [-121.31682, 38.75837], [-121.31629, 38.75858], [-121.31573, 38.75875], [-121.31504, 38.75891], [-121.31443, 38.759], [-121.31396, 38.75904], [-121.31348, 38.75905], [-121.31343, 38.75904], [-121.31339, 38.759], [-121.31341, 38.75865], [-121.31345, 38.7585], [-121.3135, 38.75837], [-121.31358, 38.75822], [-121.31369, 38.75809], [-121.31397, 38.75784], [-121.31458, 38.75828], [-121.31596, 38.7574], [-121.31702, 38.75682], [-121.31804, 38.75775]]]} | Open Access 1 | JAMES W. WANISH PARK | 20354 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 11.218 | JAMES W. WANISH 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]);