units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
10,524 rows where MNG_AG_TYP = 2 sorted by YR_EST
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- San Jose, City of 202
- San Diego, City of 130
- Ventura, City of 96
- Los Angeles, City of 93
- Long Beach, City of 53
- Roseville, City of 47
- Poway, City of 43
- Redwood City, City of 37
- Palo Alto, City of 33
- San Mateo, City of 32
- Fremont, City of 32
- Santa Clara, City of 30
- Napa, City of 29
- Irvine, City of 28
- San Francisco, City and County of 27
- San Ramon, City of 26
- Davis, City of 25
- Encinitas, City of 24
- Rocklin, City of 24
- Cupertino, City of 23
- California City, City of 23
- Sunnyvale, City of 22
- Santa Clarita, City of 21
- Murrieta, City of 21
- Stockton, City of 21
- Sacramento, City of 21
- Santa Cruz, City of 20
- Milpitas, City of 20
- Mountain View, City of 20
- Oakland, City of 18
- …
DES_TP >30
- Local Park 1,383
- Local Recreation Area 577
- Local Other or Unknown 463
- Local Conservation Area 42
- Local Historic or Cultural Area 8
- National Monument or Landmark 5
- Local Resource Management Area 2
- National Forest 1
- None 1
- None 1
- National Recreation Area 1
- None 1
- None 1
- None 1
- None 1
- National Wildlife Refuge 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
ACCESS_TYP 4
- Open Access 2,369
- Restricted Access 184
- No Public Access 35
- Unknown Access 9
MNG_AG_TYP 1
- City Agency · 2,597 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13004 | 13004 | 13003 | {"type": "Polygon", "coordinates": [[[-117.72024, 33.97313], [-117.72022, 33.97317], [-117.72018, 33.97318], [-117.71926, 33.97334], [-117.71918, 33.97307], [-117.71877, 33.97317], [-117.71804, 33.97342], [-117.71762, 33.97342], [-117.71718, 33.97345], [-117.71675, 33.97356], [-117.71655, 33.97363], [-117.71618, 33.97384], [-117.71601, 33.97396], [-117.71535, 33.97453], [-117.71522, 33.97502], [-117.71522, 33.97528], [-117.71518, 33.97528], [-117.71515, 33.97525], [-117.71513, 33.97372], [-117.71577, 33.97376], [-117.71605, 33.97358], [-117.71614, 33.97336], [-117.71655, 33.97317], [-117.71712, 33.97305], [-117.71774, 33.973], [-117.71798, 33.97296], [-117.7182, 33.97287], [-117.71855, 33.97264], [-117.71869, 33.97256], [-117.71856, 33.97232], [-117.71873, 33.97225], [-117.71884, 33.97251], [-117.71901, 33.97248], [-117.71919, 33.97247], [-117.7202, 33.97261], [-117.72021, 33.97289], [-117.72024, 33.97313]]]} | Open Access 1 | 31038 | Hickory Creek Park | 19896 | 1054 | Chino Hills, City of 119 | City 2 | City Agency 2 | http://www.chinohills.org/index.aspx?nid=364 | City 2 | 1054 | Chino Hills, City of 116 | City 2 | City Agency 2 | San Bernardino 22 | 7.462 | Hickory Creek Park | 0 | Local Park 2 | 4 | |
13009 | 13009 | 13008 | {"type": "Polygon", "coordinates": [[[-117.72757, 33.97048], [-117.72749, 33.97051], [-117.72743, 33.97036], [-117.72712, 33.97032], [-117.72709, 33.97049], [-117.72714, 33.97083], [-117.72644, 33.97079], [-117.72621, 33.9708], [-117.72575, 33.97084], [-117.7254, 33.9708], [-117.72539, 33.97076], [-117.7249, 33.97067], [-117.72468, 33.97066], [-117.72449, 33.9707], [-117.72434, 33.97082], [-117.72358, 33.97117], [-117.72346, 33.97108], [-117.72302, 33.97189], [-117.72291, 33.97189], [-117.72288, 33.97183], [-117.72249, 33.97151], [-117.7221, 33.97213], [-117.721, 33.9732], [-117.7206, 33.97328], [-117.72055, 33.97299], [-117.72053, 33.97273], [-117.72084, 33.97265], [-117.7209, 33.97241], [-117.72127, 33.97225], [-117.72154, 33.97192], [-117.72184, 33.97147], [-117.72196, 33.97134], [-117.7221, 33.97123], [-117.72219, 33.97108], [-117.7223, 33.97095], [-117.72326, 33.97048], [-117.72377, 33.97041], [-117.72377, 33.97008], [-117.72421, 33.97013], [-117.72437, 33.97018], [-117.7245, 33.97016], [-117.72457, 33.97011], [-117.72462, 33.97003], [-117.72462, 33.96997], [-117.72461, 33.96988], [-117.72463, 33.96974], [-117.72751, 33.97013], [-117.72752, 33.97037], [-117.72757, 33.97048]]]} | Open Access 1 | 31037 | Strickling Nature Park | 25924 | 1054 | Chino Hills, City of 119 | City 2 | City Agency 2 | http://www.chinohills.org/index.aspx?nid=364 | City 2 | 1054 | Chino Hills, City of 116 | City 2 | City Agency 2 | San Bernardino 22 | 14.176 | Strickling Nature Park | 0 | Local Park 2 | 4 | |
13014 | 13014 | 13013 | {"type": "Polygon", "coordinates": [[[-120.776, 38.36339], [-120.77571, 38.36344], [-120.77539, 38.36359], [-120.77516, 38.36375], [-120.77436, 38.36316], [-120.77421, 38.36334], [-120.77412, 38.36335], [-120.77261, 38.36265], [-120.77306, 38.36148], [-120.77433, 38.36231], [-120.77519, 38.36262], [-120.77569, 38.3627], [-120.776, 38.36339]]]} | Open Access 1 | 34884 | Kennedy Tailing Wheels Park | 20605 | 1420 | Jackson, City of 1004 | City 2 | City Agency 2 | http://ci.jackson.ca.us/parks_rec.html | City 2 | 1420 | Jackson, City of 967 | City 2 | City Agency 2 | Amador 52 | 7.931 | Kennedy Tailing Wheels Park | 0 | Local Park 2 | 4 | |
13015 | 13015 | 13014 | {"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 | 34877 | Janet Carlsen Park | 20361 | 1223 | Newman, City of 527 | City 2 | City Agency 2 | http://www.cityofnewman.com/ | City 2 | 1223 | Newman, City of 519 | City 2 | City Agency 2 | Stanislaus 2 | 2.904 | Janet Carlsen Park | 0 | Local Park 2 | 4 | |
13030 | 13030 | 13029 | {"type": "Polygon", "coordinates": [[[-119.26155, 34.44189], [-119.26153, 34.44196], [-119.26055, 34.44183], [-119.26057, 34.44177], [-119.26061, 34.44174], [-119.26085, 34.4416], [-119.26093, 34.44159], [-119.26125, 34.44177], [-119.26155, 34.44189]]]} | Open Access 1 | 47055 | Weinberger Memorial Garden | 30705 | 1231 | Ojai, City of 97 | City 2 | City Agency 2 | http://www.ojairec.com/ | City 2 | 1231 | Ojai, City of 95 | City 2 | City Agency 2 | Ventura 8 | 0.438 | Weinberger Memorial Garden | 0 | Local Park 2 | 4 | |
13033 | 13033 | 13032 | {"type": "Polygon", "coordinates": [[[-124.1651, 40.79414], [-124.16471, 40.7942], [-124.16474, 40.79436], [-124.16428, 40.79443], [-124.16413, 40.79378], [-124.16498, 40.79366], [-124.1651, 40.79414]]]} | Open Access 1 | 34892 | Hammond Park | 19628 | 1419 | Eureka, City of 715 | City 2 | City Agency 2 | http://www.ci.eureka.ca.gov/depts/pnr/default.asp | City 2 | 1419 | Eureka, City of 698 | City 2 | City Agency 2 | Humboldt 45 | 1.172 | Hammond Park | 0 | Local Park 2 | 4 | |
13039 | 13039 | 13038 | {"type": "Polygon", "coordinates": [[[-121.03563, 37.30465], [-121.03559, 37.3065], [-121.03527, 37.3065], [-121.0351, 37.30646], [-121.03494, 37.30641], [-121.03479, 37.30634], [-121.03459, 37.3062], [-121.03448, 37.30609], [-121.0344, 37.30596], [-121.03433, 37.30583], [-121.03429, 37.30562], [-121.0343, 37.30547], [-121.03434, 37.30532], [-121.03445, 37.30511], [-121.03456, 37.30499], [-121.03469, 37.30488], [-121.03485, 37.30479], [-121.03502, 37.30472], [-121.0352, 37.30467], [-121.03539, 37.30465], [-121.03563, 37.30465]]]} | Open Access 1 | 34878 | Alfred A. "Bush" Rose, Jr. Park | 30997 | 1223 | Newman, City of 527 | City 2 | City Agency 2 | http://www.cityofnewman.com/ | City 2 | 1223 | Newman, City of 519 | City 2 | City Agency 2 | Stanislaus 2 | 4.821 | Alfred A. "Bush" Rose, Jr. Park | 0 | Local Park 2 | 4 | |
13040 | 13040 | 13039 | {"type": "Polygon", "coordinates": [[[-122.29018, 37.84302], [-122.28869, 37.84344], [-122.28858, 37.84311], [-122.29008, 37.84271], [-122.29018, 37.84302]]]} | Open Access 1 | 34879 | Doyle Hollis Park | 18259 | 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 | 1.271 | Doyle Hollis Park | 0 | Local Park 2 | 4 | |
13041 | 13041 | 13040 | {"type": "Polygon", "coordinates": [[[-119.34092, 36.34566], [-119.34091, 36.34637], [-119.3409, 36.3464], [-119.34038, 36.3464], [-119.34037, 36.3468], [-119.33919, 36.34679], [-119.3392, 36.34562], [-119.34087, 36.34561], [-119.3409, 36.34563], [-119.34092, 36.34566]]]} | Open Access 1 | 34882 | Soroptimist Park | 25630 | 1368 | Visalia, City of 156 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | Tulare 29 | 4.466 | Soroptimist Park | 0 | Local Park 2 | 4 | |
13042 | 13042 | 13041 | {"type": "Polygon", "coordinates": [[[-122.18762, 37.69517], [-122.18698, 37.69551], [-122.18654, 37.69562], [-122.18614, 37.69514], [-122.18568, 37.69455], [-122.18533, 37.69389], [-122.18507, 37.69318], [-122.18495, 37.69278], [-122.18474, 37.69232], [-122.18446, 37.692], [-122.18411, 37.69166], [-122.18391, 37.69118], [-122.18445, 37.6911], [-122.18498, 37.69087], [-122.1862, 37.69229], [-122.18731, 37.69349], [-122.18765, 37.69401], [-122.18777, 37.69444], [-122.18776, 37.69488], [-122.18762, 37.69517]]]} | Open Access 1 | 34883 | Marina Park | 21836 | 1306 | San Leandro, City of 183 | City 2 | City Agency 2 | http://www.sanleandro.org/depts/rec/parks/default.asp | City 2 | 1306 | San Leandro, City of 179 | City 2 | City Agency 2 | Alameda 17 | 18.758 | Marina Park | 0 | Local Park 2 | 4 | |
13043 | 13043 | 13042 | {"type": "Polygon", "coordinates": [[[-120.64976, 40.41359], [-120.64933, 40.41358], [-120.64902, 40.41334], [-120.64894, 40.41443], [-120.64785, 40.41413], [-120.64787, 40.41406], [-120.64746, 40.41393], [-120.64746, 40.41391], [-120.64718, 40.41378], [-120.6472, 40.41372], [-120.64686, 40.41359], [-120.64682, 40.41365], [-120.64671, 40.41361], [-120.64675, 40.41353], [-120.64674, 40.4135], [-120.6464, 40.41308], [-120.64605, 40.41271], [-120.64614, 40.41239], [-120.64652, 40.41262], [-120.64737, 40.41246], [-120.64744, 40.41243], [-120.64902, 40.41302], [-120.64976, 40.41356], [-120.64976, 40.41359]]]} | Open Access 1 | 34885 | Little Leage Park | 21342 | 1437 | Susanville, City of 1013 | City 2 | City Agency 2 | http://www.cityofsusanville.org/ | City 2 | 1437 | Susanville, City of 975 | City 2 | City Agency 2 | Lassen 54 | 8.66 | Little Leage Park | 0 | Local Park 2 | 4 | |
13044 | 13044 | 13043 | {"type": "Polygon", "coordinates": [[[-115.49511, 32.6772], [-115.49465, 32.6772], [-115.49464, 32.67736], [-115.49442, 32.67736], [-115.49442, 32.67694], [-115.49436, 32.67693], [-115.49428, 32.67703], [-115.49416, 32.67713], [-115.49403, 32.6772], [-115.49382, 32.67724], [-115.49353, 32.67723], [-115.49353, 32.67649], [-115.49511, 32.67649], [-115.49511, 32.6772]]]} | Open Access 1 | 34886 | Emerson Field | 18621 | 1451 | Calexico, City of 607 | City 2 | City Agency 2 | http://www.calexicorecreation.org/parks | City 2 | 1451 | Calexico, City of 596 | City 2 | City Agency 2 | Imperial 20 | 2.892 | Emerson Field | 0 | Local Recreation Area 3 | 4 | |
13045 | 13045 | 13044 | {"type": "Polygon", "coordinates": [[[-122.17111, 37.72884], [-122.17104, 37.72922], [-122.17093, 37.7291], [-122.17108, 37.72899], [-122.17109, 37.7289], [-122.17023, 37.72814], [-122.16981, 37.72808], [-122.16974, 37.72827], [-122.16965, 37.72826], [-122.16952, 37.72826], [-122.16913, 37.7282], [-122.16888, 37.72809], [-122.16876, 37.728], [-122.16863, 37.72786], [-122.16855, 37.7277], [-122.16845, 37.7274], [-122.16827, 37.72711], [-122.16811, 37.72693], [-122.1679, 37.72677], [-122.16765, 37.72669], [-122.16744, 37.72668], [-122.16672, 37.72685], [-122.16664, 37.72686], [-122.1665, 37.72685], [-122.1664, 37.72683], [-122.16629, 37.72676], [-122.16623, 37.72672], [-122.16624, 37.7267], [-122.16616, 37.72657], [-122.16677, 37.7265], [-122.16698, 37.72645], [-122.16711, 37.72639], [-122.16755, 37.72638], [-122.16774, 37.72639], [-122.16826, 37.72681], [-122.16855, 37.72713], [-122.16894, 37.72763], [-122.1689, 37.72781], [-122.17018, 37.72802], [-122.17111, 37.72884]]]} | Restricted Access 2 | 34888 | Cherrywood Park | 17175 | 1306 | San Leandro, City of 183 | City 2 | City Agency 2 | http://www.sanleandro.org/depts/rec/parks/default.asp | City 2 | 1306 | San Leandro, City of 179 | City 2 | City Agency 2 | Alameda 17 | 3.331 | Cherrywood Park | 0 | Local Park 2 | 4 | |
13046 | 13046 | 13045 | {"type": "Polygon", "coordinates": [[[-120.97835, 37.62482], [-120.97835, 37.6252], [-120.97609, 37.62409], [-120.9755, 37.62372], [-120.97562, 37.62339], [-120.97585, 37.62358], [-120.97681, 37.62388], [-120.97819, 37.62474], [-120.97835, 37.62482]]]} | Restricted Access 2 | 34895 | Mancini Park | 21733 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 3.106 | Mancini Park | 0 | Local Park 2 | 4 | |
13047 | 13047 | 13046 | {"type": "Polygon", "coordinates": [[[-117.94557, 34.06582], [-117.94463, 34.06672], [-117.94441, 34.0668], [-117.94386, 34.06639], [-117.94496, 34.06537], [-117.94557, 34.06582]]]} | Open Access 1 | 34922 | Sunset Field | 26045 | 1374 | West Covina, City of 318 | City 2 | City Agency 2 | http://www.westcovina.org/departments/community-recreation-services/park-facility-rentals | City 2 | 1374 | West Covina, City of 315 | City 2 | City Agency 2 | Los Angeles 6 | 2.852 | Sunset Field | 0 | Local Recreation Area 3 | 4 | |
13050 | 13050 | 13049 | {"type": "Polygon", "coordinates": [[[-121.23739, 36.32724], [-121.23742, 36.32725], [-121.23769, 36.32756], [-121.23769, 36.32759], [-121.23755, 36.32767], [-121.23751, 36.32767], [-121.23723, 36.32735], [-121.23724, 36.32732], [-121.23739, 36.32724]]]} | Open Access 1 | 34923 | Mariposa Park | 21866 | 1124 | Greenfield, City of 176 | City 2 | City Agency 2 | http://www.ci.greenfield.ca.us/index.aspx?page=179 | City 2 | 1124 | Greenfield, City of 172 | City 2 | City Agency 2 | Monterey 14 | 0.241 | Mariposa Park | 0 | Local Park 2 | 4 | |
13052 | 13052 | 13051 | {"type": "Polygon", "coordinates": [[[-120.24958, 39.68178], [-120.24797, 39.68179], [-120.24795, 39.68118], [-120.24692, 39.68118], [-120.24691, 39.68182], [-120.24567, 39.68182], [-120.24567, 39.68073], [-120.24958, 39.68072], [-120.24958, 39.68178]]]} | Open Access 1 | 34905 | Loyalton Park | 21571 | 1669 | Loyalton, City of 1040 | City 2 | City Agency 2 | http://www.cityofloyalton.com/ | City 2 | 1669 | Loyalton, City of 1002 | City 2 | City Agency 2 | Sierra 58 | 8.349 | Loyalton Park | 0 | Local Park 2 | 4 | |
13053 | 13053 | 13052 | {"type": "Polygon", "coordinates": [[[-118.24215, 34.13224], [-118.24223, 34.1324], [-118.24223, 34.13246], [-118.24219, 34.13251], [-118.24215, 34.13255], [-118.24209, 34.13257], [-118.24186, 34.13257], [-118.24179, 34.1323], [-118.24191, 34.1323], [-118.2419, 34.13224], [-118.24215, 34.13224]]]} | Open Access 1 | 34907 | Adams Square Park | 15264 | 1119 | Glendale, City of 103 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | Los Angeles 6 | 0.292 | Adams Square Park | 0 | Local Park 2 | 4 | |
13058 | 13058 | 13057 | {"type": "Polygon", "coordinates": [[[-117.02984, 32.73907], [-117.02982, 32.73946], [-117.02952, 32.73946], [-117.02952, 32.73932], [-117.02951, 32.73931], [-117.02953, 32.7391], [-117.02958, 32.73907], [-117.02984, 32.73907]]]} | Open Access 1 | 34917 | Firefighters Park | 18910 | 1173 | Lemon Grove, City of 597 | City 2 | City Agency 2 | http://www.lemongrove.ca.gov/departments/community-services/parks-197 | City 2 | 1173 | Lemon Grove, City of 587 | City 2 | City Agency 2 | http://www.lemongrove.ca.gov/Home/Components/FacilityDirectory/FacilityDirectory/38/71 | San Diego 4 | 0.313 | Firefighters Park | 0 | Local Park 2 | 4 |
13059 | 13059 | 13058 | {"type": "Polygon", "coordinates": [[[-122.07808, 37.38834], [-122.07788, 37.38869], [-122.07784, 37.38872], [-122.07779, 37.38871], [-122.07728, 37.38851], [-122.07753, 37.38812], [-122.07808, 37.38834]]]} | Open Access 1 | 34918 | Mercy-Bush Park | 22168 | 1218 | Mountain View, City of 460 | City 2 | City Agency 2 | http://www.ci.mtnview.ca.us/services/parks/default.asp | City 2 | 1218 | Mountain View, City of 453 | City 2 | City Agency 2 | Santa Clara 19 | 0.666 | Mercy-Bush Park | 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]);