superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
13,512 rows where ACCESS_TYP = 1 sorted by PARK_NAME
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 30
- City Agency 9,651
- County Agency 983
- Recreation/Parks District 931
- State Agency 602
- Federal Agency 203
- Community Services District 190
- County Agency - Parks 189
- Open Space District 182
- Non Profit - Land Trust 180
- Water District 93
- Cemetery District 61
- Non Profit - Conservation 48
- Flood District 37
- Non Profit - Other 35
- Port/Harbor District 32
- County Agency - Other 19
- Special District - Other 15
- Irrigation District 14
- Sanitation District 6
- Non Profit - Cemetery District 5
- Commercial 4
- Joint Powers Authority 2
- Other 2
- Conservation District 2
- Non Profit - Education 2
- Airport District 1
- Metropolitan Planning Organization 1
- Utility 1
- Fire District 1
- Transportation Agency 1
MNG_AGENCY >30
- Los Angeles, City of 427
- San Diego, City of 408
- California Department of Fish and Wildlife 252
- California Department of Parks and Recreation 250
- San Jose, City of 247
- San Francisco, City and County of 235
- Sacramento, City of 213
- Los Angeles, County of 149
- Ventura, City of 149
- Mountains Recreation and Conservation Authority 139
- Long Beach, City of 134
- Oakland, City of 122
- Roseville, City of 117
- San Diego, County of 102
- Irvine, City of 97
- Consumnes Community Services District 92
- Fresno, City of 91
- Modesto, City of 78
- Hayward Area Recreation and Park District 77
- Stockton, City of 77
- Huntington Beach, City of 76
- Santa Barbara, County of 75
- Orange, County of 75
- East Bay Regional Park District 73
- Tracy, City of 73
- Santa Rosa, City of 72
- Brentwood, City of 68
- Chula Vista, City of 67
- Valley-Wide Recreation and Park District 66
- Santa Cruz, City of 65
- …
MNG_AG_LEV 8 ✖
- City 9,651
- Special District 1,567
- County 1,191
- State 602
- Non Profit 270
- Federal 203
- Private 7
- Joint 2
ACCESS_TYP 1
- Open Access · 13,493 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11914 | 11914 | 11913 | {"type": "Polygon", "coordinates": [[[-117.26661, 32.96713], [-117.26583, 32.96719], [-117.2658, 32.96677], [-117.2658, 32.96632], [-117.26595, 32.96632], [-117.26661, 32.96713]]]} | Open Access 1 | 21st Street Tennis Courts and Pump Station | http://www.delmar.ca.us/301/Tennis-Courts | 28692 | 1082 | Del Mar, City of 91 | City 2 | City Agency 2 | http://www.delmar.ca.us/203/Beaches-Parks | City 2 | 1.051 | 21st Street Tennis Courts and Pump Station | |
737 | 737 | 736 | {"type": "Polygon", "coordinates": [[[-118.20432, 33.79536], [-118.20431, 33.79659], [-118.20427, 33.79663], [-118.20404, 33.79662], [-118.20404, 33.79555], [-118.20398, 33.79553], [-118.20397, 33.79536], [-118.20432, 33.79536]]]} | Open Access 1 | 21st to Hill Mini Park | http://longbeach.granicus.com/MediaPlayer.php?view_id=12&clip_id=4470 | 28944 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 0.91 | 21st to Hill MP | |
1360 | 1360 | 1359 | {"type": "Polygon", "coordinates": [[[-118.28458, 33.72533], [-118.2844, 33.72593], [-118.28373, 33.7268], [-118.28244, 33.72785], [-118.28077, 33.72872], [-118.28047, 33.72883], [-118.28046, 33.72831], [-118.28107, 33.72799], [-118.28046, 33.72628], [-118.28046, 33.72509], [-118.28209, 33.72464], [-118.28381, 33.72421], [-118.28389, 33.72418], [-118.28392, 33.72412], [-118.28389, 33.72397], [-118.28434, 33.72394], [-118.28451, 33.72426], [-118.28467, 33.72499], [-118.28458, 33.72533]]]} | Open Access 1 | 22nd Street Landing | 15183 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 30.564 | 22nd Street Landing | ||
1367 | 1367 | 1366 | {"type": "Polygon", "coordinates": [[[-122.40867, 37.7532], [-122.4085, 37.75321], [-122.40848, 37.75292], [-122.40865, 37.75291], [-122.40867, 37.7532]]]} | Open Access 1 | 24th & York Mini Park | 15185 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.119 | 24th & York MP | ||
1361 | 1361 | 1360 | {"type": "MultiPolygon", "coordinates": [[[[-121.48235, 38.49361], [-121.48044, 38.49362], [-121.48044, 38.4925], [-121.48046, 38.49243], [-121.4805, 38.49238], [-121.48056, 38.49235], [-121.48062, 38.49233], [-121.48066, 38.49234], [-121.48097, 38.4926], [-121.48201, 38.49327], [-121.48222, 38.49346], [-121.48235, 38.49361]]], [[[-121.48252, 38.49327], [-121.48247, 38.4933], [-121.48241, 38.49329], [-121.48215, 38.49307], [-121.48118, 38.49244], [-121.48098, 38.49229], [-121.4808, 38.4921], [-121.48065, 38.49188], [-121.48065, 38.49185], [-121.48068, 38.49181], [-121.48082, 38.49178], [-121.48186, 38.49179], [-121.48203, 38.49183], [-121.48215, 38.49187], [-121.48238, 38.49202], [-121.48249, 38.49213], [-121.48255, 38.49223], [-121.48261, 38.49243], [-121.48261, 38.49309], [-121.48258, 38.49318], [-121.48252, 38.49327]]]]} | Open Access 1 | 24th Street Bypass Park | 15186 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 7.379 | 24th Street Bypass Park | ||
1368 | 1368 | 1367 | {"type": "Polygon", "coordinates": [[[-122.27275, 37.81463], [-122.27269, 37.81501], [-122.27229, 37.81496], [-122.27236, 37.81458], [-122.27275, 37.81463]]]} | Open Access 1 | 25th St. Mini Park | 15188 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 0.375 | 25th St. MP | ||
1376 | 1376 | 1375 | {"type": "Polygon", "coordinates": [[[-122.44016, 37.74009], [-122.43987, 37.7401], [-122.43978, 37.73989], [-122.43976, 37.7398], [-122.43976, 37.73972], [-122.43982, 37.73946], [-122.43984, 37.73932], [-122.43982, 37.73917], [-122.43978, 37.73898], [-122.44007, 37.73898], [-122.44016, 37.74009]]]} | Open Access 1 | 298 Berkeley Way Open Space | 15190 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.83 | 298 Berkeley Way OS | ||
1380 | 1380 | 1379 | {"type": "Polygon", "coordinates": [[[-116.99002, 33.93689], [-116.98976, 33.93713], [-116.98957, 33.93735], [-116.98957, 33.93742], [-116.98948, 33.93746], [-116.98945, 33.9375], [-116.98944, 33.93755], [-116.98924, 33.93759], [-116.98896, 33.93807], [-116.98887, 33.93804], [-116.98867, 33.93792], [-116.98846, 33.93774], [-116.98828, 33.93752], [-116.98819, 33.93733], [-116.98814, 33.93718], [-116.98811, 33.93699], [-116.98811, 33.93607], [-116.98818, 33.93601], [-116.98847, 33.93606], [-116.9894, 33.93642], [-116.98969, 33.93659], [-116.98984, 33.93671], [-116.99002, 33.93689]]]} | Open Access 1 | 3 Rings Ranch Community Park | 15191 | 1415 | Beaumont, City of 782 | City 2 | City Agency 2 | http://www.ci.beaumont.ca.us/index.aspx?nid=33 | City 2 | 6.021 | 3 Rings Ranch Community Park | ||
16 | 16 | 15 | {"type": "Polygon", "coordinates": [[[-117.1296, 32.71069], [-117.1296, 32.71124], [-117.12944, 32.71124], [-117.12944, 32.71069], [-117.1296, 32.71069]]]} | Open Access 1 | 30th Street Mini Park | 15192 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.23 | 30th Street MP | ||
1338 | 1338 | 1337 | {"type": "MultiPolygon", "coordinates": [[[[-117.12486, 32.71786], [-117.12437, 32.71786], [-117.12432, 32.71769], [-117.12428, 32.71748], [-117.12485, 32.71748], [-117.12486, 32.71786]]], [[[-117.12527, 32.7201], [-117.12493, 32.7201], [-117.12492, 32.71957], [-117.12459, 32.71956], [-117.12458, 32.71928], [-117.1244, 32.71927], [-117.1244, 32.71914], [-117.12521, 32.71913], [-117.12522, 32.71925], [-117.12525, 32.71926], [-117.12526, 32.71942], [-117.12527, 32.7201]]], [[[-117.1252, 32.71847], [-117.12449, 32.71847], [-117.12441, 32.71809], [-117.1252, 32.71808], [-117.1252, 32.71847]]], [[[-117.12521, 32.7189], [-117.12456, 32.71891], [-117.12452, 32.71853], [-117.12521, 32.71852], [-117.12521, 32.7189]]], [[[-117.12529, 32.72089], [-117.12494, 32.72089], [-117.12494, 32.72033], [-117.12528, 32.72032], [-117.12529, 32.72089]]], [[[-117.12597, 32.72046], [-117.12554, 32.72046], [-117.12554, 32.72028], [-117.12596, 32.72028], [-117.12597, 32.72046]]], [[[-117.12598, 32.72117], [-117.12554, 32.72117], [-117.12554, 32.72059], [-117.12597, 32.72059], [-117.12598, 32.72117]]], [[[-117.12644, 32.72134], [-117.12644, 32.72193], [-117.12597, 32.72192], [-117.12597, 32.72134], [-117.12644, 32.72134]]], [[[-117.12744, 32.72243], [-117.12743, 32.72304], [-117.12707, 32.72304], [-117.12707, 32.72293], [-117.12704, 32.72291], [-117.12704, 32.72269], [-117.12665, 32.72268], [-117.12666, 32.72243], [-117.12744, 32.72243]]], [[[-117.12744, 32.72221], [-117.12669, 32.72221], [-117.1267, 32.72179], [-117.12703, 32.7218], [-117.12704, 32.72207], [-117.12736, 32.72215], [-117.12743, 32.72215], [-117.12744, 32.72221]]], [[[-117.12829, 32.7239], [-117.12792, 32.72391], [-117.12792, 32.72377], [-117.12829, 32.72378], [-117.12829, 32.7239]]], [[[-117.1283, 32.72411], [-117.12828, 32.72434], [-117.12792, 32.72434], [-117.12792, 32.72404], [-117.12829, 32.72404], [-117.1283, 32.72411]]]]} | Open Access 1 | 32nd Street Canyon | 15193 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 7.015 | 32nd Street Canyon | ||
12570 | 12570 | 12569 | {"type": "Polygon", "coordinates": [[[-117.12552, 32.73807], [-117.12552, 32.73821], [-117.12512, 32.73821], [-117.12512, 32.73807], [-117.12552, 32.73807]]]} | Open Access 1 | 32nd Street Mini Park | 31228 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.143 | 32nd Street MP | ||
1349 | 1349 | 1348 | {"type": "Polygon", "coordinates": [[[-117.12447, 32.72612], [-117.12413, 32.72613], [-117.12412, 32.72547], [-117.12445, 32.72546], [-117.12447, 32.72612]]]} | Open Access 1 | 34th St Canyon Open Space | 15194 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.575 | 34th St Canyon OS | ||
12721 | 12721 | 12720 | {"type": "Polygon", "coordinates": [[[-118.20463, 33.81903], [-118.20462, 33.81984], [-118.20458, 33.82011], [-118.20441, 33.82001], [-118.20429, 33.81989], [-118.20428, 33.81985], [-118.20429, 33.81892], [-118.20458, 33.81893], [-118.20463, 33.81903]]]} | Open Access 1 | 34th St Greenbelt | 29894 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 0.927 | 34th St Greenbelt | 2007 | |
1342 | 1342 | 1341 | {"type": "Polygon", "coordinates": [[[-122.22256, 37.7762], [-122.22252, 37.77649], [-122.22235, 37.77642], [-122.22253, 37.77619], [-122.22256, 37.7762]]]} | Open Access 1 | 35th Avenue Plaza | 15195 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 0.074 | 35th Avenue Plaza | ||
1343 | 1343 | 1342 | {"type": "Polygon", "coordinates": [[[-117.93517, 33.61789], [-117.93509, 33.61794], [-117.93498, 33.61796], [-117.93491, 33.61795], [-117.93482, 33.61791], [-117.93424, 33.61727], [-117.93418, 33.61712], [-117.93418, 33.61708], [-117.93421, 33.61704], [-117.93424, 33.61702], [-117.93439, 33.61697], [-117.93516, 33.61784], [-117.93517, 33.61789]]]} | Open Access 1 | 38th Street Park | 15197 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 0.922 | 38th Street Park | ||
1344 | 1344 | 1343 | {"type": "Polygon", "coordinates": [[[-117.10586, 32.68969], [-117.1057, 32.68969], [-117.10569, 32.68931], [-117.10586, 32.68931], [-117.10586, 32.68969]]]} | Open Access 1 | 41st Street Mini-Park | 15201 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.16 | 41st Street Mini-Park | ||
44 | 44 | 43 | {"type": "MultiPolygon", "coordinates": [[[[-117.09436, 32.74201], [-117.09395, 32.74201], [-117.09393, 32.74146], [-117.09346, 32.74146], [-117.09345, 32.74102], [-117.09291, 32.74017], [-117.09284, 32.74016], [-117.09282, 32.73919], [-117.09236, 32.73919], [-117.09235, 32.7385], [-117.0928, 32.73848], [-117.09279, 32.73755], [-117.09338, 32.73754], [-117.09339, 32.73696], [-117.09359, 32.73697], [-117.09361, 32.73699], [-117.0938, 32.73699], [-117.09383, 32.7391], [-117.09322, 32.73912], [-117.09324, 32.74036], [-117.09385, 32.74037], [-117.09387, 32.74117], [-117.09435, 32.74118], [-117.09436, 32.74201]]], [[[-117.09277, 32.74057], [-117.0927, 32.74058], [-117.09269, 32.74084], [-117.09238, 32.74085], [-117.09238, 32.74039], [-117.09276, 32.74038], [-117.09277, 32.74057]]], [[[-117.09497, 32.74242], [-117.09456, 32.74242], [-117.09456, 32.74223], [-117.09497, 32.74222], [-117.09497, 32.74242]]], [[[-117.09603, 32.7429], [-117.09564, 32.74291], [-117.09564, 32.7427], [-117.09603, 32.7427], [-117.09603, 32.7429]]]]} | Open Access 1 | 47th Street Canyon | 15202 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 10.029 | 47th Street Canyon | ||
49 | 49 | 48 | {"type": "Polygon", "coordinates": [[[-120.37312, 37.98464], [-120.37092, 37.98352], [-120.37013, 37.98316], [-120.36931, 37.98351], [-120.36816, 37.98404], [-120.36712, 37.98448], [-120.36706, 37.98392], [-120.36712, 37.98344], [-120.36852, 37.98162], [-120.37305, 37.98169], [-120.37304, 37.98224], [-120.37297, 37.98379], [-120.373, 37.98406], [-120.37308, 37.98438], [-120.37312, 37.98464]]]} | Open Access 1 | 49'er Rotary Park | 15205 | 1448 | Sonora, City of 635 | City 2 | City Agency 2 | http://www.sonoraca.com/visitsonora/trailsparks.htm | City 2 | 28.185 | 49'er Rotary Park | ||
11974 | 11974 | 11973 | {"type": "Polygon", "coordinates": [[[-118.2636, 33.99857], [-118.26343, 33.99857], [-118.26343, 33.99811], [-118.2636, 33.99811], [-118.2636, 33.99857]]]} | Open Access 1 | 49th Street Pocket Park | http://www.laparks.org/environmental/49thStPark.htm | 28800 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 0.189 | 49th Street PP | |
12239 | 12239 | 12238 | {"type": "Polygon", "coordinates": [[[-117.11836, 33.00338], [-117.1183, 33.00374], [-117.11756, 33.00369], [-117.11751, 33.00406], [-117.11703, 33.00401], [-117.11706, 33.00364], [-117.11616, 33.00356], [-117.11606, 33.00392], [-117.11567, 33.00389], [-117.11564, 33.00395], [-117.11496, 33.0039], [-117.11475, 33.00393], [-117.11456, 33.00399], [-117.11441, 33.00379], [-117.11455, 33.00346], [-117.11463, 33.00323], [-117.1147, 33.00315], [-117.11495, 33.00295], [-117.11527, 33.00298], [-117.11538, 33.00296], [-117.11553, 33.00327], [-117.11583, 33.00319], [-117.11718, 33.00331], [-117.11741, 33.00327], [-117.11754, 33.0033], [-117.11808, 33.00337], [-117.11836, 33.00338]]]} | Open Access 1 | 4S Ranch Community Park | http://www.sdparks.org/content/sdparks/en/park-pages/4SRanchParks/4SRanchSports.html | 29225 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 5.824 | 4S Ranch Community 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]);