units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
9,376 rows where DES_TP = 2
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Los Angeles, City of 306
- San Diego, City of 248
- Sacramento, City of 192
- San Jose, City of 170
- San Francisco, City and County of 117
- Long Beach, City of 101
- Oakland, City of 98
- Los Angeles, County of 93
- Consumnes Community Services District 92
- East Bay Regional Park District 76
- Modesto, City of 76
- Hayward Area Recreation and Park District 74
- Huntington Beach, City of 72
- Tracy, City of 69
- San Diego, County of 67
- Stockton, City of 67
- Roseville, City of 67
- Santa Rosa, City of 65
- Fresno, City of 64
- Mountains Recreation and Conservation Authority 63
- Brentwood, City of 63
- Chula Vista, City of 59
- Irvine, City of 59
- Valley-Wide Recreation and Park District 57
- Bakersfield, City of 56
- Clovis, City of 54
- Manteca, City of 54
- Riverside, City of 49
- Anaheim, City of 48
- Newport Beach, City of 47
- …
MNG_AG_TYP 16
- City Agency 7,234
- Recreation/Parks District 697
- County Agency 628
- Community Services District 173
- County Agency - Parks 151
- Open Space District 70
- Water District 38
- School District 32
- Port/Harbor District 24
- Flood District 15
- Special District - Other 9
- County Agency - Other 7
- Cemetery District 2
- Irrigation District 1
- Sanitation District 1
- Joint Powers Authority 1
ACCESS_TYP 4
- Open Access 8,792
- Restricted Access 209
- No Public Access 77
- Unknown Access 5
DES_TP 1
- Local Park · 9,083 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
419 | 419 | 418 | {"type": "Polygon", "coordinates": [[[-119.35505, 36.20879], [-119.35454, 36.20886], [-119.35447, 36.20859], [-119.35391, 36.20865], [-119.35361, 36.2071], [-119.35416, 36.20701], [-119.35428, 36.20746], [-119.35473, 36.2074], [-119.35505, 36.20879]]]} | Open Access 1 | 1293 | Tyler Park | 26629 | 1398 | Tulare, City of 163 | City 2 | City Agency 2 | http://www.ci.tulare.ca.us/local_government/departments/rec_parks_library/parks.htm | City 2 | 1398 | Tulare, City of 159 | City 2 | City Agency 2 | Tulare 29 | 3.989 | Tyler Park | 0 | Local Park 2 | 4 | |
420 | 420 | 419 | {"type": "Polygon", "coordinates": [[[-117.97183, 33.79249], [-117.97103, 33.79199], [-117.97103, 33.79179], [-117.97112, 33.79178], [-117.97112, 33.79137], [-117.97181, 33.79137], [-117.97183, 33.79249]]]} | Open Access 1 | 1294 | Gutosky Park | 19574 | 1116 | Garden Grove, City of 62 | City 2 | City Agency 2 | http://www.ci.garden-grove.ca.us/commserv/recreation | City 2 | 1116 | Garden Grove, City of 60 | City 2 | City Agency 2 | Orange 3 | 1.639 | Gutosky Park | 0 | Local Park 2 | 4 | |
421 | 421 | 420 | {"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 | 1297 | Zumwalt Park | 27871 | 1398 | Tulare, City of 163 | City 2 | City Agency 2 | http://www.ci.tulare.ca.us/local_government/departments/rec_parks_library/parks.htm | City 2 | 1398 | Tulare, City of 159 | City 2 | City Agency 2 | Tulare 29 | 2.969 | Zumwalt Park | 0 | Local Park 2 | 4 | |
422 | 422 | 421 | {"type": "Polygon", "coordinates": [[[-120.47173, 34.64553], [-120.47171, 34.64701], [-120.47055, 34.647], [-120.47057, 34.64552], [-120.47173, 34.64553]]]} | Open Access 1 | 1352 | Thompson Park | 26315 | 1183 | Lompoc, City of 39 | City 2 | City Agency 2 | http://www.cityoflompoc.com/parks_rec/ | City 2 | 1183 | Lompoc, City of 38 | City 2 | City Agency 2 | Santa Barbara 7 | 4.345 | Thompson Park | 0 | Local Park 2 | 4 | |
423 | 423 | 422 | {"type": "Polygon", "coordinates": [[[-120.7087, 35.54967], [-120.70788, 35.55014], [-120.70681, 35.54963], [-120.7074, 35.54889], [-120.7087, 35.54967]]]} | Open Access 1 | 1306 | Templeton Community Park | 26237 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 2.932 | Templeton Community Park | 0 | Local Park 2 | 4 | |
424 | 424 | 423 | {"type": "Polygon", "coordinates": [[[-119.29357, 36.30286], [-119.29341, 36.30336], [-119.29286, 36.30364], [-119.29231, 36.30375], [-119.29185, 36.30434], [-119.29179, 36.30191], [-119.29322, 36.30197], [-119.29357, 36.30286]]]} | Open Access 1 | 1307 | Blain Park | 16147 | 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 | 7.099 | Blain Park | 0 | Local Park 2 | 4 | |
425 | 425 | 424 | {"type": "MultiPolygon", "coordinates": [[[[-121.86668, 36.99615], [-121.86622, 36.99659], [-121.86588, 36.99638], [-121.86594, 36.99611], [-121.86598, 36.99604], [-121.86629, 36.99605], [-121.86668, 36.99615]]], [[[-121.86716, 36.99638], [-121.86716, 36.99639], [-121.86607, 36.99714], [-121.8662, 36.99674], [-121.86631, 36.99659], [-121.86672, 36.99621], [-121.86716, 36.99638]]]]} | Open Access 1 | 1674 | Valencia Hall Park | 26761 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 1.476 | Valencia Hall Park | 0 | Local Park 2 | 4 | |
427 | 427 | 426 | {"type": "Polygon", "coordinates": [[[-121.98272, 38.36571], [-121.98118, 38.36563], [-121.9812, 38.36528], [-121.98124, 38.36513], [-121.98126, 38.36473], [-121.98231, 38.36477], [-121.98241, 38.3648], [-121.98251, 38.36487], [-121.98263, 38.36502], [-121.9827, 38.36517], [-121.98273, 38.36528], [-121.98274, 38.36538], [-121.98272, 38.36571]]]} | Open Access 1 | 1707 | Trower Park | 26551 | 1364 | Vacaville, City of 151 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | Solano 26 | 3.156 | Trower Park | 0 | Local Park 2 | 4 | |
428 | 428 | 427 | {"type": "Polygon", "coordinates": [[[-121.84692, 36.60162], [-121.84692, 36.60208], [-121.84657, 36.60207], [-121.84657, 36.60162], [-121.84692, 36.60162]]]} | Open Access 1 | 48914 | Ellis Park | 33635 | 1330 | Seaside, City of 115 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/Facilities/Facility/Details/Ellis-Park-28 | Monterey 14 | 0.391 | Ellis Park | 0 | Local Park 2 | 4 |
429 | 429 | 428 | {"type": "Polygon", "coordinates": [[[-117.49266, 34.11629], [-117.4928, 34.1163], [-117.49293, 34.11635], [-117.49305, 34.11641], [-117.49313, 34.11648], [-117.49322, 34.11658], [-117.49327, 34.11668], [-117.4933, 34.11678], [-117.4933, 34.11692], [-117.49327, 34.11701], [-117.49322, 34.11712], [-117.49313, 34.11722], [-117.49304, 34.11729], [-117.49292, 34.11736], [-117.4928, 34.11739], [-117.49267, 34.11741], [-117.49253, 34.11741], [-117.4923, 34.11734], [-117.49218, 34.11728], [-117.49209, 34.1172], [-117.49201, 34.1171], [-117.49197, 34.11701], [-117.49195, 34.11691], [-117.49195, 34.11678], [-117.49197, 34.11669], [-117.49202, 34.11659], [-117.49209, 34.1165], [-117.49219, 34.11642], [-117.49238, 34.11632], [-117.4925, 34.11629], [-117.49266, 34.11629]]]} | Open Access 1 | 1717 | Heritage Circle Park | 19833 | 1109 | Fontana, City of 168 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | San Bernardino 22 | 3.008 | Heritage Circle Park | 0 | Local Park 2 | 4 | |
431 | 431 | 430 | {"type": "Polygon", "coordinates": [[[-117.28428, 33.76243], [-117.28273, 33.76246], [-117.2827, 33.76182], [-117.28324, 33.76181], [-117.28324, 33.76162], [-117.28425, 33.76159], [-117.28428, 33.76243]]]} | Open Access 1 | 48878 | Goodhope Park | 33599 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | Riverside 10 | 3.022 | Goodhope Park | 0 | Local Park 2 | 4 | |
432 | 432 | 431 | {"type": "Polygon", "coordinates": [[[-119.21445, 34.18501], [-119.21443, 34.18655], [-119.21133, 34.18652], [-119.21134, 34.18535], [-119.21139, 34.18509], [-119.21145, 34.18492], [-119.21147, 34.1849], [-119.21184, 34.18496], [-119.21441, 34.18498], [-119.21445, 34.18501]]]} | Open Access 1 | 1737 | Via Marina Park | 27066 | 1237 | Oxnard, City of 95 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | Ventura 8 | 12.286 | Via Marina Park | 0 | Local Park 2 | 4 | |
433 | 433 | 432 | {"type": "Polygon", "coordinates": [[[-116.59781, 32.61496], [-116.59778, 32.61691], [-116.592, 32.61684], [-116.59195, 32.61847], [-116.58772, 32.61842], [-116.58772, 32.61307], [-116.59204, 32.61313], [-116.59203, 32.6113], [-116.59613, 32.61131], [-116.59619, 32.61494], [-116.59781, 32.61496]]]} | Open Access 1 | 836 | Potrero Park | 23926 | 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/Potrero.html | San Diego 4 | 126.277 | Potrero Park | 0 | Local Park 2 | 4 |
435 | 435 | 434 | {"type": "Polygon", "coordinates": [[[-119.69855, 34.45558], [-119.69836, 34.45579], [-119.69797, 34.45582], [-119.69763, 34.4559], [-119.6974, 34.45592], [-119.69721, 34.45613], [-119.69705, 34.45625], [-119.69706, 34.45701], [-119.69648, 34.45697], [-119.69605, 34.45727], [-119.69579, 34.45719], [-119.69542, 34.45728], [-119.69512, 34.457], [-119.69503, 34.45701], [-119.69485, 34.45705], [-119.69472, 34.45712], [-119.69395, 34.45739], [-119.69294, 34.45739], [-119.6922, 34.45773], [-119.69219, 34.45747], [-119.69224, 34.45747], [-119.6924, 34.45716], [-119.69291, 34.45688], [-119.69296, 34.45676], [-119.69302, 34.45564], [-119.69377, 34.45575], [-119.694, 34.45558], [-119.69406, 34.45526], [-119.69316, 34.45512], [-119.69481, 34.45361], [-119.69524, 34.45356], [-119.69511, 34.45391], [-119.69511, 34.45393], [-119.6963, 34.45392], [-119.69646, 34.45399], [-119.69718, 34.45447], [-119.69735, 34.45452], [-119.69758, 34.45457], [-119.69822, 34.45452], [-119.69832, 34.45556], [-119.69855, 34.45558]]]} | Open Access 1 | 838 | Skofield Park | 25530 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | Santa Barbara 7 | 35.113 | Skofield Park | 0 | Local Park 2 | 4 | |
437 | 437 | 436 | {"type": "Polygon", "coordinates": [[[-119.26048, 36.3315], [-119.26048, 36.33249], [-119.26047, 36.33253], [-119.26043, 36.33256], [-119.25979, 36.33265], [-119.25935, 36.33274], [-119.25908, 36.33282], [-119.25872, 36.33298], [-119.258, 36.33343], [-119.25742, 36.33278], [-119.25769, 36.33246], [-119.25781, 36.33241], [-119.25819, 36.3323], [-119.25849, 36.3323], [-119.25857, 36.33227], [-119.25898, 36.33176], [-119.2591, 36.33169], [-119.25933, 36.33166], [-119.26009, 36.3316], [-119.26034, 36.33152], [-119.26048, 36.3315]]]} | Open Access 1 | 1373 | Mill Creek Park | 22226 | 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 | 7.02 | Mill Creek Park | 0 | Local Park 2 | 4 | |
438 | 438 | 437 | {"type": "Polygon", "coordinates": [[[-119.84426, 36.80273], [-119.83996, 36.80275], [-119.83995, 36.80098], [-119.84162, 36.80098], [-119.84205, 36.80106], [-119.84262, 36.80112], [-119.84422, 36.80112], [-119.84426, 36.80273]]]} | Open Access 1 | 1388 | Lions Park | 21319 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 17.754 | Lions Park | 0 | Local Park 2 | 4 | |
439 | 439 | 438 | {"type": "Polygon", "coordinates": [[[-121.7605, 38.56573], [-121.7605, 38.56632], [-121.75984, 38.56631], [-121.75985, 38.56573], [-121.7605, 38.56573]]]} | Open Access 1 | 21013 | Hacienda Park | 19586 | 1081 | Davis, City of 171 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | Yolo 33 | 0.923 | Hacienda Park | 0 | Local Park 2 | 4 | |
440 | 440 | 439 | {"type": "Polygon", "coordinates": [[[-119.26949, 36.32014], [-119.26948, 36.32187], [-119.2684, 36.32186], [-119.26942, 36.32014], [-119.26949, 36.32014]]]} | Open Access 1 | 1377 | Pinkham Park | 23697 | 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 | 2.438 | Pinkham Park | 0 | Local Park 2 | 4 | |
441 | 441 | 440 | {"type": "Polygon", "coordinates": [[[-118.85799, 34.28692], [-118.85787, 34.28768], [-118.8578, 34.28774], [-118.85765, 34.28776], [-118.85737, 34.28709], [-118.85799, 34.28692]]]} | Open Access 1 | 1773 | Virginia Colony Park | 27157 | 1214 | Moorpark, City of 172 | City 2 | City Agency 2 | http://www.moorparkca.gov/199/Recreation | City 2 | 1214 | Moorpark, City of 168 | City 2 | City Agency 2 | Ventura 8 | 0.801 | Virginia Colony Park | 0 | Local Park 2 | 4 | |
443 | 443 | 442 | {"type": "Polygon", "coordinates": [[[-119.39303, 36.32471], [-119.39295, 36.32489], [-119.3927, 36.32484], [-119.39045, 36.32479], [-119.39025, 36.32471], [-119.39042, 36.32429], [-119.39019, 36.32419], [-119.39003, 36.32446], [-119.38997, 36.3248], [-119.38972, 36.3248], [-119.38943, 36.32484], [-119.38905, 36.325], [-119.38869, 36.32501], [-119.38834, 36.32486], [-119.38818, 36.32466], [-119.38794, 36.32414], [-119.3879, 36.32397], [-119.38792, 36.32382], [-119.38827, 36.32255], [-119.38842, 36.32226], [-119.38852, 36.32213], [-119.38869, 36.32201], [-119.38888, 36.32191], [-119.38905, 36.32185], [-119.38952, 36.32175], [-119.38983, 36.32163], [-119.38997, 36.32155], [-119.39026, 36.32131], [-119.39047, 36.32109], [-119.39063, 36.32115], [-119.39073, 36.32123], [-119.39297, 36.3245], [-119.39303, 36.32471]]]} | Open Access 1 | 1382 | Plaza Park | 23789 | 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 | 30.735 | Plaza 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]);