superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
10,210 rows where MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- San Diego, City of 358
- Los Angeles, City of 333
- San Jose, City of 143
- Ventura, City of 135
- San Francisco, City and County of 134
- Sacramento, City of 133
- Long Beach, City of 109
- Roseville, City of 94
- Fresno, City of 67
- Oakland, City of 64
- Poway, City of 59
- Torrance, City of 56
- Santa Cruz, City of 55
- Davis, City of 50
- Napa, City of 50
- Rocklin, City of 49
- Stockton, City of 48
- Clovis, City of 48
- Modesto, City of 46
- Chula Vista, City of 45
- Irvine, City of 45
- Huntington Beach, City of 44
- San Ramon, City of 43
- Santa Barbara, City of 41
- Newport Beach, City of 41
- San Luis Obispo, City of 40
- Santa Rosa, City of 39
- Anaheim, City of 38
- Bakersfield, City of 38
- Fremont, City of 38
- …
ACCESS_TYP 4
- Open Access 6,139
- Restricted Access 254
- No Public Access 131
- Unknown Access 22
MNG_AG_TYP 1
- City Agency · 6,546 ✖
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 | ||
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 | ||
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 | ||
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 | ||
5484 | 5484 | 5483 | {"type": "Polygon", "coordinates": [[[-118.14227, 34.6921], [-118.14122, 34.69222], [-118.14082, 34.68969], [-118.14088, 34.68964], [-118.14184, 34.68964], [-118.14189, 34.68969], [-118.14227, 34.6921]]]} | Open Access 1 | Jane Reynolds Park | 20360 | 1169 | Lancaster, City of 11 | City 2 | City Agency 2 | http://www.cityoflancasterca.org/index.aspx?page=23 | City 2 | 6.805 | Jane Reynolds Park | ||
5485 | 5485 | 5484 | {"type": "Polygon", "coordinates": [[[-121.02647, 37.307], [-121.02645, 37.30777], [-121.02504, 37.30767], [-121.02505, 37.30685], [-121.02578, 37.30686], [-121.02639, 37.30693], [-121.02647, 37.307]]]} | Open Access 1 | Janet Carlsen Park | 20361 | 1223 | Newman, City of 519 | City 2 | City Agency 2 | http://www.cityofnewman.com/ | City 2 | 2.904 | Janet Carlsen Park | ||
5487 | 5487 | 5486 | {"type": "Polygon", "coordinates": [[[-122.43008, 37.78544], [-122.42953, 37.78551], [-122.42942, 37.78498], [-122.42997, 37.78491], [-122.43008, 37.78544]]]} | Open Access 1 | Japanese Peace Plaza And Pagoda | 20363 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.714 | Japanese Peace Plaza And Pagoda | ||
5488 | 5488 | 5487 | {"type": "Polygon", "coordinates": [[[-122.22233, 37.48195], [-122.22209, 37.48228], [-122.22181, 37.48214], [-122.22181, 37.48212], [-122.22203, 37.48181], [-122.22233, 37.48195]]]} | Open Access 1 | Jardin de Ninos Park | 20365 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 0.314 | Jardin de Ninos Park | 1981 | |
5489 | 5489 | 5488 | {"type": "Polygon", "coordinates": [[[-117.866, 33.60265], [-117.86593, 33.6027], [-117.86573, 33.6025], [-117.86554, 33.60226], [-117.86554, 33.60222], [-117.86556, 33.60219], [-117.86577, 33.60204], [-117.86574, 33.60213], [-117.86574, 33.60229], [-117.86576, 33.60238], [-117.86584, 33.60251], [-117.86596, 33.60258], [-117.866, 33.60265]]]} | Open Access 1 | Jasmine Creek Park | 20367 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 0.208 | Jasmine Creek 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]);