superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
10,210 rows where MNG_AG_TYP = 2 sorted by LABEL_NAME descending
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Los Angeles, City of 465
- San Diego, City of 433
- San Jose, City of 253
- San Francisco, City and County of 240
- Sacramento, City of 218
- Ventura, City of 151
- Long Beach, City of 148
- Roseville, City of 124
- Oakland, City of 122
- Irvine, City of 98
- Fresno, City of 94
- Modesto, City of 84
- Stockton, City of 81
- Santa Rosa, City of 79
- Huntington Beach, City of 76
- Tracy, City of 73
- Torrance, City of 72
- Santa Cruz, City of 69
- Chula Vista, City of 69
- Brentwood, City of 68
- Poway, City of 67
- Newport Beach, City of 65
- Santa Barbara, City of 64
- Davis, City of 64
- San Luis Obispo, City of 63
- Napa, City of 62
- Clovis, City of 62
- Bakersfield, City of 61
- Manteca, City of 60
- Anaheim, City of 59
- …
ACCESS_TYP 4
- Open Access 9,670
- Restricted Access 356
- No Public Access 155
- Unknown Access 29
MNG_AG_TYP 1
- City Agency · 10,210 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7946 | 7946 | 7945 | {"type": "Polygon", "coordinates": [[[-121.82582, 36.6117], [-121.8252, 36.61169], [-121.8252, 36.61165], [-121.82581, 36.61166], [-121.82582, 36.6117]]]} | Open Access 1 | park access 2 | 23424 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 0.063 | park access 2 | ||
11517 | 11517 | 11516 | {"type": "Polygon", "coordinates": [[[-117.99859, 33.80404], [-117.99817, 33.80405], [-117.99816, 33.8035], [-117.99859, 33.80349], [-117.99859, 33.80404]]]} | Open Access 1 | Zuniga Park | 27872 | 1342 | Stanton, City of 731 | City 2 | City Agency 2 | http://www.ci.stanton.ca.us/Departments/Parks-and-Recreation | City 2 | 0.587 | Zuniga Park | ||
9870 | 9870 | 9869 | {"type": "Polygon", "coordinates": [[[-119.34342, 36.20836], [-119.34235, 36.20852], [-119.34211, 36.20743], [-119.34318, 36.20728], [-119.34342, 36.20836]]]} | Open Access 1 | Zumwalt Park | 27871 | 1398 | Tulare, City of 159 | City 2 | City Agency 2 | http://www.ci.tulare.ca.us/local_government/departments/rec_parks_library/parks.htm | City 2 | 2.968 | Zumwalt Park | ||
11516 | 11516 | 11515 | {"type": "Polygon", "coordinates": [[[-121.14296, 37.7305], [-121.14279, 37.73057], [-121.14274, 37.73044], [-121.14271, 37.73031], [-121.14278, 37.73023], [-121.14295, 37.73023], [-121.14296, 37.7305]]]} | Open Access 1 | Zumstein Park | 27870 | 1277 | Ripon, City of 527 | City 2 | City Agency 2 | http://www.cityofripon.org/ | City 2 | 0.158 | Zumstein Park | ||
11513 | 11513 | 11512 | {"type": "Polygon", "coordinates": [[[-121.85116, 37.34628], [-121.85095, 37.34628], [-121.85075, 37.34634], [-121.85008, 37.34674], [-121.85002, 37.34676], [-121.84993, 37.34675], [-121.84958, 37.34642], [-121.85074, 37.3457], [-121.85079, 37.34575], [-121.85071, 37.34582], [-121.85116, 37.34628]]]} | Open Access 1 | Zolezzi Park | 27868 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1.717 | Zolezzi Park | 2007 | |
11512 | 11512 | 11511 | {"type": "Polygon", "coordinates": [[[-118.10221, 33.74239], [-118.10162, 33.7432], [-118.10041, 33.74259], [-118.10094, 33.74187], [-118.1018, 33.7423], [-118.10187, 33.74222], [-118.10221, 33.74239]]]} | Open Access 1 | Zoeter Field | 27867 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | http://www.sealbeachca.gov/living/community/facilities/ | City 2 | 3.138 | Zoeter Field | ||
1828 | 1828 | 1827 | {"type": "Polygon", "coordinates": [[[-122.44202, 38.4864], [-122.44169, 38.48664], [-122.44097, 38.48604], [-122.44129, 38.48579], [-122.44202, 38.4864]]]} | Open Access 1 | Zinfandel Park | 27866 | 1290 | Saint Helena, City of 416 | City 2 | City Agency 2 | http://cityofsthelena.org/parks-recreation | City 2 | 0.888 | Zinfandel Park | ||
11510 | 11510 | 11509 | {"type": "Polygon", "coordinates": [[[-120.94386, 37.73879], [-120.94314, 37.73885], [-120.94287, 37.73891], [-120.94263, 37.73902], [-120.94225, 37.73926], [-120.94216, 37.7393], [-120.94209, 37.73937], [-120.94207, 37.73943], [-120.94207, 37.73949], [-120.94212, 37.73957], [-120.94271, 37.74155], [-120.94263, 37.74162], [-120.94258, 37.74163], [-120.94248, 37.74161], [-120.94226, 37.74155], [-120.94204, 37.74153], [-120.94253, 37.74144], [-120.94254, 37.74142], [-120.94212, 37.73998], [-120.94189, 37.73997], [-120.94169, 37.7393], [-120.94138, 37.7393], [-120.9411, 37.73836], [-120.94174, 37.73838], [-120.94238, 37.73837], [-120.94323, 37.73832], [-120.94379, 37.73826], [-120.94386, 37.73879]]]} | Open Access 1 | Zerillo Park | 27863 | 1278 | Riverbank, City of 40 | City 2 | City Agency 2 | http://www.riverbank.org/Depts/Recreation/default.aspx | City 2 | 5.725 | Zerillo Park | ||
11509 | 11509 | 11508 | {"type": "Polygon", "coordinates": [[[-117.05795, 32.7466], [-117.05795, 32.74669], [-117.05759, 32.74659], [-117.05761, 32.74652], [-117.05777, 32.74658], [-117.05795, 32.7466]]]} | Open Access 1 | Zena Mini-Park | 27862 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.067 | Zena Mini-Park | ||
11508 | 11508 | 11507 | {"type": "Polygon", "coordinates": [[[-118.52574, 34.28307], [-118.52532, 34.28336], [-118.5247, 34.28385], [-118.52397, 34.28304], [-118.52299, 34.28249], [-118.52309, 34.28228], [-118.52327, 34.28207], [-118.52344, 34.28194], [-118.52411, 34.28154], [-118.52433, 34.28135], [-118.52467, 34.28097], [-118.52474, 34.28095], [-118.52478, 34.28098], [-118.52495, 34.28132], [-118.5251, 34.28185], [-118.52519, 34.28208], [-118.52531, 34.2823], [-118.52559, 34.2827], [-118.52567, 34.28285], [-118.52574, 34.28307]]]} | Open Access 1 | Zelzah Park | 27861 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 9.729 | Zelzah Park | ||
11507 | 11507 | 11506 | {"type": "Polygon", "coordinates": [[[-122.46161, 37.87736], [-122.46118, 37.87759], [-122.46109, 37.87757], [-122.46043, 37.87756], [-122.46026, 37.87689], [-122.46161, 37.87736]]]} | Open Access 1 | Zelinksy Park | 27860 | 1348 | Tiburon, Town of 477 | City 2 | City Agency 2 | http://www.ci.tiburon.ca.us/ | City 2 | 1.208 | Zelinksy Park | ||
11506 | 11506 | 11505 | {"type": "Polygon", "coordinates": [[[-118.33724, 33.911], [-118.33723, 33.91126], [-118.3372, 33.91128], [-118.33619, 33.91128], [-118.33619, 33.911], [-118.33724, 33.911]]]} | Open Access 1 | Zela Davis Park | 27858 | 1130 | Hawthorne, City of 295 | City 2 | City Agency 2 | http://www.cityofhawthorne.com/ | City 2 | 0.738 | Zela Davis Park | ||
248 | 248 | 247 | {"type": "Polygon", "coordinates": [[[-118.33727, 33.9101], [-118.337, 33.91011], [-118.33698, 33.91027], [-118.3365, 33.91027], [-118.3365, 33.90959], [-118.33727, 33.90959], [-118.33727, 33.9101]]]} | Restricted Access 2 | Zela Davis Elementary School Park | 31892 | 1130 | Hawthorne, City of 295 | City 2 | City Agency 2 | http://www.cityofhawthorne.com/ | City 2 | 1.202 | Zela Davis Elementary School Park | ||
11504 | 11504 | 11503 | {"type": "Polygon", "coordinates": [[[-118.08808, 34.06303], [-118.08554, 34.06569], [-118.08544, 34.06568], [-118.08536, 34.06562], [-118.08532, 34.06557], [-118.08531, 34.06551], [-118.08529, 34.06486], [-118.08727, 34.06278], [-118.08747, 34.06278], [-118.08749, 34.0628], [-118.08808, 34.0628], [-118.08808, 34.06303]]]} | Open Access 1 | Zapopan Park | 27856 | 1284 | Rosemead, City of 127 | City 2 | City Agency 2 | http://www.cityofrosemead.org/index.aspx?page=74 | City 2 | 6.76 | Zapopan Park | ||
11503 | 11503 | 11502 | {"type": "Polygon", "coordinates": [[[-121.4498, 37.74505], [-121.44971, 37.74505], [-121.44874, 37.74425], [-121.44865, 37.74416], [-121.44859, 37.74406], [-121.44854, 37.74394], [-121.44853, 37.74383], [-121.44853, 37.74372], [-121.44856, 37.74363], [-121.44868, 37.74344], [-121.44885, 37.74332], [-121.44898, 37.74325], [-121.44914, 37.74321], [-121.44933, 37.7432], [-121.44948, 37.74321], [-121.44964, 37.74325], [-121.44981, 37.74334], [-121.44993, 37.74344], [-121.45002, 37.74356], [-121.45007, 37.74368], [-121.45009, 37.74379], [-121.45009, 37.74464], [-121.45005, 37.74477], [-121.45, 37.74486], [-121.44991, 37.74496], [-121.4498, 37.74505]]]} | Open Access 1 | Zanussi Park | 27855 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 4.965 | Zanussi Park | ||
11501 | 11501 | 11500 | {"type": "Polygon", "coordinates": [[[-122.43749, 37.6417], [-122.43708, 37.64219], [-122.43677, 37.64236], [-122.43671, 37.64168], [-122.43693, 37.64167], [-122.43694, 37.64171], [-122.43697, 37.64175], [-122.43706, 37.64178], [-122.43716, 37.64175], [-122.4372, 37.64168], [-122.43749, 37.6417]]]} | Open Access 1 | Zamora Playlot | 27853 | 1341 | South San Francisco, City of 58 | City 2 | City Agency 2 | http://www.ssf.net/377/Parks-Recreation | City 2 | 0.712 | Zamora Playlot | ||
11500 | 11500 | 11499 | {"type": "Polygon", "coordinates": [[[-118.01207, 34.07165], [-118.01152, 34.07275], [-118.01061, 34.07243], [-118.01091, 34.07179], [-118.01001, 34.07147], [-118.01024, 34.07101], [-118.01027, 34.07098], [-118.01031, 34.07098], [-118.01204, 34.07159], [-118.01207, 34.07161], [-118.01207, 34.07165]]]} | Open Access 1 | Zamora Park | 27852 | 1095 | El Monte, City of 236 | City 2 | City Agency 2 | http://ci.el-monte.ca.us/Government/ParksandRecreation/ParksRecreation.aspx | City 2 | 4.492 | Zamora Park | ||
11498 | 11498 | 11497 | {"type": "Polygon", "coordinates": [[[-119.02223, 36.0768], [-119.02221, 36.07837], [-119.02222, 36.07915], [-119.02219, 36.07954], [-119.02219, 36.08023], [-119.02126, 36.08021], [-119.02101, 36.07981], [-119.02063, 36.07909], [-119.02029, 36.07837], [-119.01969, 36.07682], [-119.0201, 36.0768], [-119.02223, 36.0768]]]} | Open Access 1 | Zalud Park | 27851 | 1260 | Porterville, City of 136 | City 2 | City Agency 2 | http://www.ci.porterville.ca.us/ | City 2 | 15.304 | Zalud Park | ||
11497 | 11497 | 11496 | {"type": "Polygon", "coordinates": [[[-117.92179, 34.11982], [-117.92177, 34.12163], [-117.92068, 34.12164], [-117.92067, 34.12153], [-117.91871, 34.12153], [-117.91861, 34.12146], [-117.91861, 34.1209], [-117.91868, 34.12085], [-117.91899, 34.12085], [-117.91927, 34.1209], [-117.91984, 34.1209], [-117.92004, 34.12087], [-117.92028, 34.12079], [-117.92041, 34.12076], [-117.92109, 34.12076], [-117.92125, 34.12079], [-117.92137, 34.12077], [-117.92143, 34.12071], [-117.92146, 34.12063], [-117.92143, 34.12048], [-117.92143, 34.1201], [-117.92146, 34.11993], [-117.92145, 34.11987], [-117.92141, 34.11982], [-117.92179, 34.11982]]]} | Open Access 1 | Zacatecas Park | 27850 | 1018 | Azusa, City of 143 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?NID=249 | City 2 | 6.773 | Zacatecas Park | ||
12845 | 12845 | 12844 | {"type": "Polygon", "coordinates": [[[-117.10971, 32.69341], [-117.1097, 32.69341], [-117.10898, 32.69341], [-117.1097, 32.69303], [-117.10971, 32.69341]]]} | Open Access 1 | Z Street Mini-Park | 30067 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.357 | Z Street Mini-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]);