units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
9,084 rows where ACCESS_TYP = 1 and DES_TP = 2 sorted by UNIT_NAME
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Los Angeles, City of 288
- San Diego, City of 272
- Sacramento, City of 189
- San Jose, City of 174
- San Francisco, City and County of 116
- Oakland, City of 98
- Long Beach, City of 97
- Consumnes Community Services District 92
- Los Angeles, County of 91
- Fresno, City of 82
- Huntington Beach, City of 74
- Modesto, City of 72
- Hayward Area Recreation and Park District 70
- Tracy, City of 69
- Santa Rosa, City of 67
- Stockton, City of 67
- San Diego, County of 66
- Roseville, City of 65
- Brentwood, City of 63
- Mountains Recreation and Conservation Authority 62
- Chula Vista, City of 60
- Irvine, City of 59
- Valley-Wide Recreation and Park District 57
- Bakersfield, City of 55
- Clovis, City of 54
- Manteca, City of 54
- Newport Beach, City of 50
- Anaheim, City of 49
- Riverside, City of 49
- East Bay Regional Park District 46
- …
MNG_AG_TYP 15
- City Agency 7,277
- Recreation/Parks District 659
- County Agency 641
- Community Services District 172
- County Agency - Parks 146
- Open Space District 69
- Water District 37
- Port/Harbor District 24
- Flood District 17
- Special District - Other 9
- County Agency - Other 7
- Cemetery District 3
- Irrigation District 1
- Sanitation District 1
- Joint Powers Authority 1
DES_TP 1
- Local Park · 9,064 ✖
ACCESS_TYP 1
- Open Access · 9,064 ✖
Link | rowid | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME ▼ | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6323 | 6323 | 6322 | {"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 | 13419 | 35th Avenue Plaza | 15195 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 0.074 | 35th Avenue Plaza | 0 | Local Park 2 | 4 | |
7314 | 7314 | 7313 | {"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 | 6628 | 38th Street Park | 15197 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 0.922 | 38th Street Park | 0 | Local Park 2 | 4 | |
6434 | 6434 | 6433 | {"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 | 1958 | 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 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.161 | 41st Street Mini-Park | 0 | Local Park 2 | 4 | |
12125 | 12125 | 12124 | {"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 | 25080 | 49'er Rotary Park | 15205 | 1448 | Sonora, City of 645 | City 2 | City Agency 2 | http://www.sonoraca.com/visitsonora/trailsparks.htm | City 2 | 1448 | Sonora, City of 635 | City 2 | City Agency 2 | Tuolumne 21 | 28.185 | 49'er Rotary Park | 0 | Local Park 2 | 4 | |
5715 | 5715 | 5714 | {"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 | 45781 | 49th Street Pocket Park | 28800 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://www.laparks.org/environmental/49thStPark.htm | Los Angeles 6 | 0.189 | 49th Street PP | 0 | Local Park 2 | 4 |
3654 | 3654 | 3653 | {"type": "Polygon", "coordinates": [[[-117.11836, 33.00338], [-117.1183, 33.00374], [-117.11756, 33.00369], [-117.11751, 33.00406], [-117.11703, 33.00401], [-117.11707, 33.00365], [-117.11615, 33.00356], [-117.11606, 33.00392], [-117.11566, 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 | 29594 | 4S Ranch Community Park | 29225 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/4SRanchParks/4SRanchSports.html | San Diego 4 | 5.809 | 4S Ranch Community Park | 0 | Local Park 2 | 4 |
6239 | 6239 | 6238 | {"type": "Polygon", "coordinates": [[[-117.11773, 33.01502], [-117.1175, 33.01584], [-117.11707, 33.01618], [-117.11694, 33.01675], [-117.11621, 33.01663], [-117.11619, 33.01662], [-117.11626, 33.01623], [-117.11629, 33.01582], [-117.11618, 33.01481], [-117.11619, 33.01477], [-117.11623, 33.01474], [-117.11639, 33.01475], [-117.11773, 33.01502]]]} | Open Access 1 | 1304 | 4S Ranch Heritage Park | 29226 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/4SRanchParks.html | San Diego 4 | 5.39 | 4S Ranch Heritage Park | 0 | Local Park 2 | 4 |
15157 | 15157 | 15156 | {"type": "Polygon", "coordinates": [[[-117.11743, 33.01151], [-117.11752, 33.01172], [-117.11755, 33.01187], [-117.11753, 33.01206], [-117.11751, 33.01214], [-117.11748, 33.01217], [-117.11743, 33.01217], [-117.11666, 33.01201], [-117.11662, 33.01199], [-117.11658, 33.01192], [-117.11651, 33.01189], [-117.11645, 33.01189], [-117.11638, 33.01191], [-117.11618, 33.0117], [-117.11606, 33.01182], [-117.11597, 33.01213], [-117.11604, 33.01169], [-117.11601, 33.0116], [-117.11591, 33.01148], [-117.11611, 33.0115], [-117.11631, 33.01148], [-117.11653, 33.01149], [-117.1168, 33.01156], [-117.11707, 33.01159], [-117.11743, 33.01151]]]} | Open Access 1 | 46006 | 4S Ranch Homestead Park | 29267 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/4SRanchParks/4SRanchLiberty.html | San Diego 4 | 1.801 | 4S Ranch Homestead Park | 0 | Local Park 2 | 4 |
15150 | 15150 | 15149 | {"type": "Polygon", "coordinates": [[[-117.11446, 33.0364], [-117.11431, 33.03678], [-117.1142, 33.03696], [-117.11407, 33.03715], [-117.11377, 33.0375], [-117.11362, 33.03763], [-117.11341, 33.03775], [-117.11311, 33.03738], [-117.1126, 33.03682], [-117.11261, 33.03678], [-117.11303, 33.03641], [-117.11347, 33.0359], [-117.11376, 33.03607], [-117.11436, 33.03631], [-117.11446, 33.0364]]]} | Open Access 1 | 45993 | 4S Ranch Liberty Park | 29187 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/4SRanchParks.html | San Diego 4 | 4.774 | 4S Ranch Liberty Park | 0 | Local Park 2 | 4 |
15156 | 15156 | 15155 | {"type": "Polygon", "coordinates": [[[-117.10945, 33.02613], [-117.1071, 33.02507], [-117.10729, 33.02431], [-117.10808, 33.02445], [-117.10808, 33.02453], [-117.10813, 33.02459], [-117.10823, 33.02463], [-117.10995, 33.02563], [-117.10997, 33.02568], [-117.10993, 33.02573], [-117.10955, 33.02601], [-117.10945, 33.02613]]]} | Open Access 1 | 46005 | 4S Ranch Patriot Park | 29266 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/4SRanchParks.html | San Diego 4 | 5.762 | 4S Ranch Patriot Park | 0 | Local Park 2 | 4 |
4955 | 4955 | 4954 | {"type": "Polygon", "coordinates": [[[-122.28849, 37.84349], [-122.28816, 37.84358], [-122.28806, 37.84325], [-122.28838, 37.84316], [-122.28849, 37.84349]]]} | Open Access 1 | 14777 | 61st Street Mini Park | 15207 | 1098 | Emeryville, City of 790 | City 2 | City Agency 2 | http://www.ci.emeryville.ca.us/158/City-Parks | City 2 | 1098 | Emeryville, City of 769 | City 2 | City Agency 2 | Alameda 17 | 0.282 | 61st Street MP | 1976 | Local Park 2 | 4 | |
5390 | 5390 | 5389 | {"type": "Polygon", "coordinates": [[[-118.27253, 33.98433], [-118.27253, 33.98468], [-118.2724, 33.98468], [-118.2724, 33.98433], [-118.27253, 33.98433]]]} | Open Access 1 | 45782 | 61st Street Pocket Park | 28801 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.118 | 61st Street PP | 0 | Local Park 2 | 4 | |
8633 | 8633 | 8632 | {"type": "Polygon", "coordinates": [[[-122.27515, 37.84778], [-122.27496, 37.84781], [-122.27489, 37.84744], [-122.27507, 37.84741], [-122.27515, 37.84778]]]} | Open Access 1 | 13805 | 63rd Street Mini-Park | 15208 | 1028 | Berkeley, City of 337 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | Alameda 17 | 0.164 | 63rd Street Mini-Park | 0 | Local Park 2 | 4 | |
3875 | 3875 | 3874 | {"type": "Polygon", "coordinates": [[[-118.28833, 33.97082], [-118.28833, 33.9712], [-118.2882, 33.9712], [-118.2882, 33.97082], [-118.28833, 33.97082]]]} | Open Access 1 | 45783 | 76th Street Pocket Park | 28802 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://www.lanlt.org/parks-and-gardens.php#76th | Los Angeles 6 | 0.128 | 76th Street PP | 0 | Local Park 2 | 4 |
6970 | 6970 | 6969 | {"type": "Polygon", "coordinates": [[[-122.40517, 37.62935], [-122.40481, 37.62939], [-122.40477, 37.62877], [-122.40516, 37.62875], [-122.40517, 37.62935]]]} | Open Access 1 | 14394 | 7th Avenue Park | 15214 | 1294 | San Bruno, City of 440 | City 2 | City Agency 2 | http://www.sanbruno.ca.gov/parks_main.html | City 2 | 1294 | San Bruno, City of 434 | City 2 | City Agency 2 | San Mateo 15 | 0.556 | 7th Avenue Park | 1940 | Local Park 2 | 4 | |
6851 | 6851 | 6850 | {"type": "Polygon", "coordinates": [[[-122.40576, 37.63377], [-122.40541, 37.63374], [-122.40526, 37.63285], [-122.40564, 37.63282], [-122.40576, 37.63377]]]} | Open Access 1 | 14392 | 7th Avenue and Walnut Park | 15213 | 1294 | San Bruno, City of 440 | City 2 | City Agency 2 | http://www.sanbruno.ca.gov/parks_main.html | City 2 | 1294 | San Bruno, City of 434 | City 2 | City Agency 2 | San Mateo 15 | 0.806 | 7th Avenue and Walnut Park | 1940 | Local Park 2 | 4 | |
2120 | 2120 | 2119 | {"type": "Polygon", "coordinates": [[[-117.6908, 34.02102], [-117.69079, 34.02124], [-117.69076, 34.02128], [-117.69068, 34.02129], [-117.69063, 34.02129], [-117.69057, 34.02125], [-117.69057, 34.02103], [-117.69059, 34.02098], [-117.69063, 34.02096], [-117.6907, 34.02096], [-117.69078, 34.02099], [-117.6908, 34.02102]]]} | Open Access 1 | 15923 | 7th Street Park | 15215 | 1053 | Chino, City of 266 | City 2 | City Agency 2 | http://www.cityofchino.org/residents/parks | City 2 | 1053 | Chino, City of 261 | City 2 | City Agency 2 | http://www.cityofchino.org/government-services/community-services/parks/7th-street-park | San Bernardino 22 | 0.175 | 7th Street Park | 0 | Local Park 2 | 4 |
2736 | 2736 | 2735 | {"type": "Polygon", "coordinates": [[[-117.06482, 34.02935], [-117.06276, 34.02935], [-117.06276, 34.02844], [-117.06105, 34.02844], [-117.06104, 34.02824], [-117.06068, 34.02824], [-117.06068, 34.028], [-117.06226, 34.02701], [-117.06227, 34.02671], [-117.06276, 34.02671], [-117.06277, 34.02675], [-117.06478, 34.02675], [-117.06482, 34.0268], [-117.06482, 34.02935]]]} | Open Access 1 | 18387 | 7th Street Park | 15216 | 1387 | Yucaipa, City of 83 | City 2 | City Agency 2 | http://yucaipa.org/recreation/parks/ | City 2 | 1387 | Yucaipa, City of 81 | City 2 | City Agency 2 | San Bernardino 22 | 19.264 | 7th Street Park | 0 | Local Park 2 | 4 | |
4794 | 4794 | 4793 | {"type": "Polygon", "coordinates": [[[-119.33362, 35.59357], [-119.33362, 35.59412], [-119.33338, 35.59412], [-119.33338, 35.59392], [-119.33336, 35.59391], [-119.33337, 35.59357], [-119.33362, 35.59357]]]} | Open Access 1 | 48296 | 7th Street Park | 32868 | 1693 | Wasco, City of 782 | City 2 | City Agency 2 | http://www.ci.wasco.ca.us/ | City 2 | 1693 | Wasco, City of 762 | City 2 | City Agency 2 | Kern 36 | 0.339 | 7th Street Park | 0 | Local Park 2 | 4 | |
8534 | 8534 | 8533 | {"type": "Polygon", "coordinates": [[[-122.17361, 37.75533], [-122.17331, 37.75544], [-122.17312, 37.7551], [-122.1734, 37.755], [-122.17361, 37.75533]]]} | Open Access 1 | 13413 | 85th Avenue Mini Park | 15217 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 0.291 | 85th Avenue MP | 0 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);