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 MNG_AG_ID 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
487 | 487 | 486 | {"type": "Polygon", "coordinates": [[[-122.36754, 37.72678], [-122.36734, 37.727], [-122.36723, 37.72694], [-122.36712, 37.72698], [-122.36703, 37.72705], [-122.36698, 37.72714], [-122.36697, 37.72723], [-122.36708, 37.7273], [-122.36688, 37.72752], [-122.36589, 37.72698], [-122.36647, 37.72634], [-122.36666, 37.72629], [-122.36754, 37.72678]]]} | Open Access 1 | Hillpoint Park | https://www.cmgsite.com/project/hunters-point-parks-hillside-central-park-hillpoint-park-and-innes-court-park/ | 33507 | 2290 | San Francisco, City and County of, Redevelopment Agency 788 | City 2 | City Agency 2 | http://www.sfredevelopment.org/index.aspx?page=104 | City 2 | 2.471 | Hillpoint Park | 2003 |
14122 | 14122 | 14121 | {"type": "Polygon", "coordinates": [[[-117.85818, 34.19361], [-117.85655, 34.19631], [-117.85599, 34.19646], [-117.85577, 34.1973], [-117.85578, 34.19593], [-117.85608, 34.19585], [-117.85744, 34.1936], [-117.85818, 34.19361]]]} | No Public Access 3 | Unnamed Site - Pasadena Department of Water and Power | 33667 | 1720 | Pasadena Department of Water and Power 1099 | City 2 | City Agency 2 | https://ww5.cityofpasadena.net/water-and-power/ | City 2 | 5.623 | |||
12217 | 12217 | 12216 | {"type": "Polygon", "coordinates": [[[-118.24292, 33.94311], [-118.24258, 33.94313], [-118.24261, 33.94276], [-118.24292, 33.94277], [-118.24292, 33.94311]]]} | Restricted Access 2 | Watts Historic Train Station | 29326 | 1717 | Los Angeles - Community Redevelopment Agency, City of 829 | City 2 | City Agency 2 | http://www.crala.org/internet-site/index.cfm | City 2 | 0.287 | Watts Historic Train Station | ||
12218 | 12218 | 12217 | {"type": "Polygon", "coordinates": [[[-118.26813, 34.03678], [-118.26797, 34.03702], [-118.26752, 34.03682], [-118.26768, 34.03658], [-118.26813, 34.03678]]]} | Open Access 1 | Venice Hope Park | 29327 | 1717 | Los Angeles - Community Redevelopment Agency, City of 829 | City 2 | City Agency 2 | http://www.crala.org/internet-site/index.cfm | City 2 | 0.357 | Venice Hope Park | ||
53 | 53 | 52 | {"type": "MultiPolygon", "coordinates": [[[[-118.35436, 34.11245], [-118.35429, 34.11252], [-118.35299, 34.11466], [-118.35297, 34.11244], [-118.35436, 34.11245]]], [[[-118.35377, 34.11413], [-118.35376, 34.1142], [-118.35361, 34.11442], [-118.35357, 34.11455], [-118.35354, 34.11476], [-118.35355, 34.11511], [-118.3535, 34.11525], [-118.35333, 34.11551], [-118.35348, 34.11564], [-118.353, 34.11529], [-118.35299, 34.11526], [-118.35373, 34.11404], [-118.35377, 34.11413]]]]} | Open Access 1 | Runyon Canyon Park | 31769 | 1716 | Los Angeles Department of Recreation and Parks, City of 647 | City 2 | City Agency 2 | http://www.laparks.org/ | City 2 | 4.703 | Runyon Canyon Park | ||
12116 | 12116 | 12115 | {"type": "Polygon", "coordinates": [[[-118.33513, 34.1361], [-118.33399, 34.13613], [-118.33065, 34.14103], [-118.32259, 34.13646], [-118.32257, 34.1343], [-118.32662, 34.13429], [-118.33423, 34.13423], [-118.33431, 34.13463], [-118.33462, 34.13512], [-118.33462, 34.13529], [-118.33478, 34.1354], [-118.33491, 34.13558], [-118.3349, 34.13582], [-118.33505, 34.13595], [-118.33513, 34.1361]]]} | Open Access 1 | Cahuenga Peak Phase 1 | http://www.laparks.org/ | 29079 | 1716 | Los Angeles Department of Recreation and Parks, City of 647 | City 2 | City Agency 2 | http://www.laparks.org/ | City 2 | 130.506 | Cahuenga Peak Phase 1 | |
12138 | 12138 | 12137 | {"type": "Polygon", "coordinates": [[[-118.34333, 34.10414], [-118.34241, 34.10414], [-118.34241, 34.10351], [-118.34332, 34.10352], [-118.34333, 34.10414]]]} | Open Access 1 | Dorothy J. and Benjamin B. Smith Park | 29107 | 1716 | Los Angeles Department of Recreation and Parks, City of 647 | City 2 | City Agency 2 | http://www.laparks.org/ | City 2 | 1.44 | Dorothy J. and Benjamin B. Smith Park | ||
12140 | 12140 | 12139 | {"type": "Polygon", "coordinates": [[[-118.24283, 34.12002], [-118.2427, 34.12011], [-118.24249, 34.11991], [-118.24263, 34.11981], [-118.24283, 34.12002]]]} | Open Access 1 | Drew Street Park | 29109 | 1716 | Los Angeles Department of Recreation and Parks, City of 647 | City 2 | City Agency 2 | http://www.laparks.org/ | City 2 | 0.116 | Drew Street Park | ||
12179 | 12179 | 12178 | {"type": "Polygon", "coordinates": [[[-118.31351, 33.97087], [-118.3135, 33.97102], [-118.3134, 33.97108], [-118.31327, 33.97108], [-118.31322, 33.97104], [-118.31317, 33.97098], [-118.31318, 33.97087], [-118.31325, 33.9708], [-118.31334, 33.97077], [-118.31341, 33.97078], [-118.31346, 33.9708], [-118.31351, 33.97087]]]} | Open Access 1 | Circle Park (Gramercy) | http://www.laparks.org/ | 29159 | 1716 | Los Angeles Department of Recreation and Parks, City of 647 | City 2 | City Agency 2 | http://www.laparks.org/ | City 2 | 0.216 | Circle Park (Gramercy) | |
12180 | 12180 | 12179 | {"type": "Polygon", "coordinates": [[[-118.32227, 33.9709], [-118.32226, 33.97102], [-118.3222, 33.97106], [-118.32211, 33.97108], [-118.32196, 33.97104], [-118.32192, 33.97096], [-118.32194, 33.97086], [-118.32203, 33.9708], [-118.32211, 33.97078], [-118.32221, 33.97079], [-118.32224, 33.97081], [-118.32227, 33.9709]]]} | Open Access 1 | Circle Park (5th Avenue) | http://www.laparks.org/ | 29160 | 1716 | Los Angeles Department of Recreation and Parks, City of 647 | City 2 | City Agency 2 | http://www.laparks.org/ | City 2 | 0.21 | Circle Park (5th Avenue) | |
12773 | 12773 | 12772 | {"type": "Polygon", "coordinates": [[[-118.26272, 34.09928], [-118.26229, 34.09907], [-118.26213, 34.09908], [-118.2619, 34.09916], [-118.26179, 34.09924], [-118.26172, 34.09933], [-118.2614, 34.09995], [-118.26119, 34.10003], [-118.26115, 34.0999], [-118.26088, 34.0994], [-118.26078, 34.09911], [-118.26076, 34.09887], [-118.26076, 34.09824], [-118.26078, 34.09803], [-118.26083, 34.09784], [-118.26097, 34.09757], [-118.26169, 34.09659], [-118.26181, 34.0963], [-118.26192, 34.09588], [-118.262, 34.09572], [-118.2623, 34.09572], [-118.26183, 34.09659], [-118.26187, 34.09749], [-118.26209, 34.09818], [-118.26272, 34.09928]]]} | Open Access 1 | Silver Lake Meadows Park | 29963 | 1716 | Los Angeles Department of Recreation and Parks, City of 647 | City 2 | City Agency 2 | http://www.laparks.org/ | City 2 | 8.813 | Silver Lake Meadows Park | ||
13916 | 13916 | 13915 | {"type": "Polygon", "coordinates": [[[-118.47355, 34.29793], [-118.47245, 34.29891], [-118.47229, 34.29879], [-118.4722, 34.29887], [-118.47221, 34.29894], [-118.47213, 34.29901], [-118.47089, 34.29806], [-118.47156, 34.29743], [-118.47171, 34.2975], [-118.47187, 34.29753], [-118.47223, 34.29752], [-118.47272, 34.29745], [-118.47288, 34.29749], [-118.47324, 34.29764], [-118.47333, 34.2977], [-118.47355, 34.29793]]]} | Open Access 1 | West Lakeside Street Park | 32503 | 1716 | Los Angeles Department of Recreation and Parks, City of 647 | City 2 | City Agency 2 | http://www.laparks.org/ | City 2 | 6.244 | West Lakeside Street Park | ||
15511 | 15511 | 15510 | {"type": "Polygon", "coordinates": [[[-118.24477, 34.05427], [-118.24461, 34.05444], [-118.24458, 34.05443], [-118.24454, 34.05448], [-118.24455, 34.05451], [-118.24403, 34.05507], [-118.2432, 34.05453], [-118.24394, 34.05373], [-118.24477, 34.05427]]]} | Open Access 1 | 1st and Broadway Civic Center Park | 29093 | 1716 | Los Angeles Department of Recreation and Parks, City of 647 | City 2 | City Agency 2 | http://www.laparks.org/ | City 2 | 2.682 | 1st and Broadway Civic Ctr. Park | ||
15620 | 15620 | 15619 | {"type": "Polygon", "coordinates": [[[-118.244, 33.99945], [-118.244, 34.00174], [-118.24354, 34.00179], [-118.24362, 33.99941], [-118.244, 33.99945]]]} | Open Access 1 | Fred Roberts Recreation Center | http://www.laparks.org/ | 29143 | 1716 | Los Angeles Department of Recreation and Parks, City of 647 | City 2 | City Agency 2 | http://www.laparks.org/ | City 2 | 2.494 | Fred Roberts Rec. Ctr. | |
587 | 587 | 586 | {"type": "Polygon", "coordinates": [[[-118.65948, 34.17172], [-118.6594, 34.17201], [-118.65918, 34.17207], [-118.65913, 34.1721], [-118.65863, 34.17207], [-118.65863, 34.17156], [-118.65948, 34.17172]]]} | Open Access 1 | Hidden Hills Demonstration Gardens | 32688 | 1713 | Hidden Hills, City of 728 | City 2 | City Agency 2 | http://www.hiddenhillscity.org/ | City 2 | 0.895 | Hidden Hills Demonstration Gardens | ||
12584 | 12584 | 12583 | {"type": "Polygon", "coordinates": [[[-117.97481, 34.14373], [-117.9748, 34.14592], [-117.97454, 34.14593], [-117.97453, 34.14687], [-117.9745, 34.14687], [-117.9745, 34.1459], [-117.97472, 34.14589], [-117.97476, 34.14586], [-117.97476, 34.14373], [-117.97481, 34.14373]]]} | Open Access 1 | Lemon Trail | 29710 | 1712 | Bradbury, City of 1097 | City 2 | City Agency 2 | http://cityofbradbury.org/ | City 2 | 0.344 | Lemon Trail | ||
12585 | 12585 | 12584 | {"type": "Polygon", "coordinates": [[[-117.97472, 34.14357], [-117.97464, 34.14362], [-117.96441, 34.1437], [-117.96441, 34.14354], [-117.97458, 34.14347], [-117.97472, 34.14357]]]} | Open Access 1 | Royal Oaks Trail North | 29711 | 1712 | Bradbury, City of 1097 | City 2 | City Agency 2 | http://cityofbradbury.org/ | City 2 | 4.027 | Royal Oaks Trail North | ||
15622 | 15622 | 15621 | {"type": "Polygon", "coordinates": [[[-117.96999, 34.14575], [-117.9696, 34.14575], [-117.96915, 34.14556], [-117.96899, 34.14555], [-117.96898, 34.14547], [-117.96986, 34.1455], [-117.96996, 34.14548], [-117.96999, 34.14575]]]} | Open Access 1 | Civic Center Park | 32522 | 1712 | Bradbury, City of 1097 | City 2 | City Agency 2 | http://cityofbradbury.org/ | City 2 | 0.468 | Civic Ctr. Park | ||
3762 | 3762 | 3761 | {"type": "Polygon", "coordinates": [[[-117.20726, 33.69264], [-117.2072, 33.69272], [-117.20725, 33.69299], [-117.20637, 33.69311], [-117.20628, 33.69281], [-117.20621, 33.69235], [-117.2062, 33.69115], [-117.20627, 33.69109], [-117.20713, 33.69109], [-117.20718, 33.69113], [-117.20718, 33.6923], [-117.20715, 33.69247], [-117.20718, 33.69257], [-117.20726, 33.69264]]]} | Open Access 1 | E.L. Pete Peterson Park | 18333 | 1707 | Menifee, City of 655 | City 2 | City Agency 2 | http://www.cityofmenifee.us/284/Community-Services | City 2 | 4.807 | E.L. Pete Peterson Park | ||
5811 | 5811 | 5810 | {"type": "Polygon", "coordinates": [[[-117.22339, 33.68723], [-117.22337, 33.69107], [-117.22278, 33.69127], [-117.22266, 33.69114], [-117.22231, 33.69085], [-117.22192, 33.69039], [-117.2218, 33.69029], [-117.22163, 33.69019], [-117.22162, 33.69014], [-117.22271, 33.68883], [-117.22296, 33.68847], [-117.2231, 33.6882], [-117.22324, 33.68787], [-117.22332, 33.68758], [-117.22339, 33.68723]]]} | Open Access 1 | La Ladera Park | 20770 | 1707 | Menifee, City of 655 | City 2 | City Agency 2 | http://www.cityofmenifee.us/284/Community-Services | City 2 | 8.314 | La Ladera 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]);