units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,141 rows where DES_TP = 2 and LAYER = 4 sorted by LABEL_NAME
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, MNG_AG_LEV
MNG_AGENCY >30
- Consumnes Community Services District 90
- Hayward Area Recreation and Park District 74
- East Bay Regional Park District 56
- Valley-Wide Recreation and Park District 49
- Mountains Recreation and Conservation Authority 44
- Rancho Simi Recreation and Park District 42
- Cordova Recreation and Park District 37
- Southgate Recreation and Park District 34
- Greater Vallejo Recreation and Park District 29
- Conejo Recreation and Park District 25
- Sunrise Recreation and Park District 25
- Pleasant Valley Recreation and Park District 24
- North of the River Recreation and Park District 24
- El Dorado Hills Community Service District 20
- Whittier, City of 18
- Jurupa Area Recreation and Park District 16
- San Diego Unified Port District 15
- Olivehurst Public Utility District 15
- Los Angeles Unified School District 15
- Mission Oaks Recreation and Park District 14
- San Ramon, City of 13
- Fresno Metropolitan Flood Control District 13
- Isla Vista Recreation and Park District 12
- Apple Valley Recreation and Park District 10
- Carmichael Recreation and Park District 10
- Jurupa Community Services District 10
- North Highland Recreation and Park District 10
- Pleasant Hill Recreation and Park District 9
- Hesperia Recreation and Park District 9
- Monterey Peninsula Regional Park District 8
- …
MNG_AG_TYP 15
- Recreation/Parks District 669
- Community Services District 171
- City Agency 116
- Open Space District 52
- Water District 35
- School District 32
- Port/Harbor District 22
- Flood District 17
- Special District - Other 9
- County Agency - Parks 7
- County Agency 5
- Cemetery District 3
- Irrigation District 1
- Sanitation District 1
- Joint Powers Authority 1
ACCESS_TYP 4
- Open Access 970
- Restricted Access 143
- No Public Access 25
- Unknown Access 3
DES_TP 1
- Local Park · 1,141 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12253 | 12253 | 12252 | {"type": "Polygon", "coordinates": [[[-118.20225, 34.07513], [-118.20166, 34.07513], [-118.20166, 34.07528], [-118.20122, 34.07529], [-118.2012, 34.07523], [-118.20091, 34.07524], [-118.2009, 34.07513], [-118.2003, 34.07515], [-118.20011, 34.07437], [-118.20176, 34.07436], [-118.20177, 34.07498], [-118.20225, 34.07497], [-118.20225, 34.07513]]]} | Restricted Access 2 | 46874 | Abraham Lincoln High School Park | 31843 | 2361 | Los Angeles Unified School District 616 | Special District 4 | School District 14 | http://home.lausd.net/ | Special District 4 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 3.467 | Abraham Lincoln High School Park | 0 | Local Park 2 | 4 | |
11859 | 11859 | 11858 | {"type": "Polygon", "coordinates": [[[-117.02375, 33.23685], [-117.02356, 33.2408], [-117.0235, 33.24085], [-117.01947, 33.24142], [-117.01954, 33.24036], [-117.01953, 33.24028], [-117.0196, 33.23816], [-117.01959, 33.23767], [-117.02055, 33.23769], [-117.02067, 33.23715], [-117.02219, 33.23726], [-117.02227, 33.23694], [-117.02375, 33.23685]]]} | Open Access 1 | 24307 | Adams Community Park | 15259 | 2267 | Valley Center Parks and Recreation 994 | Special District 4 | Recreation/Parks District 4 | http://www.valleycenterparks.com/ | Special District 4 | 2267 | Valley Center Parks and Recreation 957 | Special District 4 | Recreation/Parks District 4 | http://valleycenterparks.com/adams-park.html | San Diego 4 | 40.858 | Adams Community Park | 0 | Local Park 2 | 4 |
14443 | 14443 | 14442 | {"type": "Polygon", "coordinates": [[[-117.09722, 33.59201], [-117.09678, 33.59201], [-117.09676, 33.59226], [-117.09668, 33.59227], [-117.09652, 33.59204], [-117.09625, 33.59204], [-117.09621, 33.59183], [-117.09621, 33.59161], [-117.09646, 33.59165], [-117.09678, 33.59166], [-117.09722, 33.59161], [-117.09722, 33.59201]]]} | Open Access 1 | 48261 | Adeline's Farm Park | 32815 | 2171 | Valley-Wide Recreation and Park District 160 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/adeline-s-farm | Riverside 10 | 1.08 | Adeline's Farm Park | 0 | Local Park 2 | 4 |
1518 | 1518 | 1517 | {"type": "Polygon", "coordinates": [[[-122.08221, 37.69769], [-122.08102, 37.69769], [-122.08099, 37.69634], [-122.08217, 37.69632], [-122.08221, 37.69769]]]} | Open Access 1 | 47719 | Adobe Park | 31505 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/facilities/facility/details/Adobe-Park-116 | Alameda 17 | 3.894 | Adobe Park | 0 | Local Park 2 | 4 |
2363 | 2363 | 2362 | {"type": "Polygon", "coordinates": [[[-119.02281, 34.23312], [-119.02272, 34.23323], [-119.02237, 34.23354], [-119.02196, 34.23332], [-119.02166, 34.2331], [-119.02139, 34.23282], [-119.0212, 34.23254], [-119.02281, 34.23253], [-119.02281, 34.23312]]]} | Open Access 1 | 17150 | Adolfo Park | 15274 | 2113 | Pleasant Valley Recreation and Park District 149 | Special District 4 | Recreation/Parks District 4 | http://www.pvrpd.org/ | Special District 4 | 2113 | Pleasant Valley Recreation and Park District 145 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 2.698 | Adolfo Park | 0 | Local Park 2 | 4 | |
9697 | 9697 | 9696 | {"type": "Polygon", "coordinates": [[[-118.06854, 33.96506], [-118.06786, 33.96522], [-118.06772, 33.96583], [-118.06704, 33.96582], [-118.06704, 33.96591], [-118.06669, 33.96591], [-118.06667, 33.9658], [-118.06616, 33.96578], [-118.06653, 33.96476], [-118.06654, 33.96478], [-118.06732, 33.9648], [-118.06733, 33.96478], [-118.06851, 33.96481], [-118.06854, 33.96506]]]} | Restricted Access 2 | 47862 | Aeolian Elementary School Park | 31844 | 2376 | Los Nietos School District 920 | Special District 4 | School District 14 | http://www.losnietos.k12.ca.us/ | Special District 4 | 2376 | Los Nietos School District 893 | Special District 4 | School District 21 | Los Angeles 6 | 4.508 | Aeolian Elementary School Park | 0 | Local Park 2 | 4 | |
1590 | 1590 | 1589 | {"type": "Polygon", "coordinates": [[[-117.47515, 34.00095], [-117.47513, 34.00167], [-117.47122, 34.00165], [-117.47122, 34.00115], [-117.4713, 34.00114], [-117.4713, 34.00095], [-117.47179, 34.00095], [-117.4718, 34.00091], [-117.47184, 34.0009], [-117.47184, 34.00052], [-117.47179, 34.00051], [-117.47179, 34.00047], [-117.47226, 34.00036], [-117.47229, 34.00042], [-117.4726, 34.00035], [-117.47259, 34.00028], [-117.47323, 34.00012], [-117.47323, 34.00094], [-117.47515, 34.00095]]]} | Open Access 1 | 12150 | Agate Park | 15285 | 2051 | Jurupa Area Recreation and Park District 364 | Special District 4 | Recreation/Parks District 4 | http://www.jarpd.org/ | Special District 4 | 2051 | Jurupa Area Recreation and Park District 360 | Special District 4 | Recreation/Parks District 4 | Riverside 10 | 9.349 | Agate Park | 0 | Local Park 2 | 4 | |
11686 | 11686 | 11685 | {"type": "Polygon", "coordinates": [[[-121.28989, 38.60301], [-121.2892, 38.60361], [-121.28854, 38.60412], [-121.2874, 38.60253], [-121.28783, 38.60224], [-121.2882, 38.60189], [-121.28853, 38.60168], [-121.28904, 38.60223], [-121.28918, 38.60246], [-121.28943, 38.60274], [-121.28989, 38.60301]]]} | Open Access 1 | 23981 | Ahlstrom Park | 15298 | 2193 | Cordova Recreation and Park District 307 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.com/ | Special District 4 | 2193 | Cordova Recreation and Park District 304 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 7.052 | Ahlstrom Park | 0 | Local Park 2 | 4 | |
11559 | 11559 | 11558 | {"type": "Polygon", "coordinates": [[[-121.06116, 38.66599], [-121.06067, 38.66612], [-121.06058, 38.66604], [-121.06042, 38.66597], [-121.06024, 38.66593], [-121.06012, 38.66593], [-121.05911, 38.66617], [-121.05881, 38.6654], [-121.06076, 38.66458], [-121.06093, 38.66507], [-121.06106, 38.6657], [-121.06116, 38.66599]]]} | Open Access 1 | 46839 | Alan Lindsey Park | 30317 | 2197 | El Dorado Hills Community Service District 568 | Special District 4 | Community Services District 19 | http://www.edhcsd.org/ | Special District 4 | 2197 | El Dorado Hills Community Service District 560 | Special District 4 | Community Services District 17 | http://www.eldoradohillscsd.org/images/park_detail_popups/allan-lindsey/ | El Dorado 34 | 5.429 | Alan Lindsey Park | 0 | Local Park 2 | 4 |
14076 | 14076 | 14075 | {"type": "Polygon", "coordinates": [[[-117.15686, 33.69873], [-117.15685, 33.69915], [-117.1563, 33.69916], [-117.15626, 33.69919], [-117.15628, 33.69997], [-117.15634, 33.70004], [-117.15639, 33.70004], [-117.1564, 33.70034], [-117.15589, 33.70031], [-117.15545, 33.70012], [-117.15443, 33.69945], [-117.15435, 33.69919], [-117.15465, 33.69866], [-117.15483, 33.69828], [-117.15493, 33.69823], [-117.15632, 33.69856], [-117.15633, 33.69861], [-117.15637, 33.69863], [-117.15674, 33.69872], [-117.15686, 33.69873]]]} | Open Access 1 | 39114 | Aldergate Park | 15348 | 2171 | Valley-Wide Recreation and Park District 160 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | Riverside 10 | 8.124 | Aldergate Park | 0 | Local Park 2 | 4 | |
9611 | 9611 | 9610 | {"type": "Polygon", "coordinates": [[[-120.42789, 34.94443], [-120.42481, 34.9444], [-120.42478, 34.94205], [-120.42786, 34.94209], [-120.42789, 34.94443]]]} | Open Access 1 | 47985 | Alice Threfts Park | 15362 | 2421 | Allan Hancock Community College District 917 | Special District 4 | School District 14 | https://www.hancockcollege.edu/ | Special District 4 | 1322 | Santa Maria, City of 35 | City 2 | City Agency 2 | Santa Barbara 7 | 18.102 | Alice Threfts Park | 0 | Local Park 2 | 4 | |
11850 | 11850 | 11849 | {"type": "Polygon", "coordinates": [[[-121.24202, 38.67499], [-121.23976, 38.67498], [-121.23976, 38.67313], [-121.24201, 38.67315], [-121.24202, 38.67499]]]} | Open Access 1 | 24284 | Almond Park | 15399 | 2248 | Orangevale Recreation and Park District 928 | Special District 4 | Recreation/Parks District 4 | http://www.orangevalecommunitycenter.com/ | Special District 4 | 2248 | Orangevale Recreation and Park District 901 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 9.905 | Almond Park | 0 | Local Park 2 | 4 | |
12178 | 12178 | 12177 | {"type": "Polygon", "coordinates": [[[-119.12129, 35.4109], [-119.12002, 35.41094], [-119.11913, 35.41088], [-119.11906, 35.41083], [-119.11909, 35.41053], [-119.11907, 35.4089], [-119.12128, 35.40887], [-119.12127, 35.40939], [-119.12129, 35.40953], [-119.12129, 35.4109]]]} | Open Access 1 | 25363 | Almondale Park | 15400 | 2096 | North of the River Recreation and Park District 386 | Special District 4 | Recreation/Parks District 4 | http://norfun.org/ | Special District 4 | 2096 | North of the River Recreation and Park District 382 | Special District 4 | Recreation/Parks District 4 | Kern 36 | 11.185 | Almondale Park | 0 | Local Park 2 | 4 | |
11438 | 11438 | 11437 | {"type": "Polygon", "coordinates": [[[-118.37889, 33.82954], [-118.37835, 33.83153], [-118.37833, 33.83156], [-118.37828, 33.83159], [-118.37822, 33.83158], [-118.37818, 33.83156], [-118.37777, 33.83105], [-118.3774, 33.83067], [-118.37715, 33.83045], [-118.37657, 33.83], [-118.37654, 33.82995], [-118.37669, 33.82938], [-118.37889, 33.82954]]]} | Restricted Access 2 | 48132 | Alta Vista Park | 32655 | 2379 | Redondo Beach Unified School District 979 | Special District 4 | School District 14 | http://www.rbusd.org/ | Special District 4 | 2379 | Redondo Beach Unified School District 942 | Special District 4 | School District 21 | Los Angeles 6 | 7.426 | Alta Vista Park | 0 | Local Park 2 | 4 | |
2228 | 2228 | 2227 | {"type": "Polygon", "coordinates": [[[-121.71671, 37.72148], [-121.71669, 37.72289], [-121.71655, 37.72282], [-121.71638, 37.72284], [-121.7163, 37.72283], [-121.71614, 37.72271], [-121.71604, 37.72268], [-121.71589, 37.72271], [-121.7157, 37.7228], [-121.71557, 37.72281], [-121.71548, 37.72278], [-121.71522, 37.72262], [-121.71518, 37.72256], [-121.71517, 37.72242], [-121.71509, 37.72236], [-121.71509, 37.72164], [-121.71547, 37.72166], [-121.71605, 37.72163], [-121.71635, 37.72158], [-121.71671, 37.72148]]]} | Open Access 1 | 47875 | Altamont Creek Park | 31819 | 2062 | Livermore Area Recreation and Park District 394 | Special District 4 | Recreation/Parks District 4 | http://www.larpd.dst.ca.us/ | Special District 4 | 2062 | Livermore Area Recreation and Park District 388 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 4.384 | Altamont Creek Park | 0 | Local Park 2 | 4 | |
13698 | 13698 | 13697 | {"type": "Polygon", "coordinates": [[[-121.54891, 37.78322], [-121.54785, 37.78323], [-121.54781, 37.78321], [-121.54778, 37.78141], [-121.5478, 37.78137], [-121.54888, 37.78136], [-121.54891, 37.78322]]]} | Open Access 1 | 36073 | Altamont Park | 15425 | 2288 | Mountain House Community Services District 703 | Special District 4 | Community Services District 19 | http://www.mhcsd.com/ | Special District 4 | 2288 | Mountain House Community Services District 690 | Special District 4 | Community Services District 17 | San Joaquin 39 | 4.979 | Altamont Park | 0 | Local Park 2 | 4 | |
1322 | 1322 | 1321 | {"type": "Polygon", "coordinates": [[[-122.24455, 38.102], [-122.24448, 38.10265], [-122.24424, 38.10265], [-122.24424, 38.102], [-122.24455, 38.102]]]} | Open Access 1 | 47622 | Amador Bocce Ball Court | 31357 | 2224 | Greater Vallejo Recreation and Park District 341 | Special District 4 | Recreation/Parks District 4 | http://www.gvrd.org/ | Special District 4 | 2224 | Greater Vallejo Recreation and Park District 338 | Special District 4 | Recreation/Parks District 4 | http://www.gvrd.org/?page=Amador_Bocce_Ball | Solano 26 | 0.431 | Amador Bocce Ball Court | 0 | Local Park 2 | 4 |
3243 | 3243 | 3242 | {"type": "Polygon", "coordinates": [[[-121.95011, 38.02426], [-121.95, 38.02588], [-121.95007, 38.0259], [-121.95002, 38.02667], [-121.94884, 38.02667], [-121.94884, 38.02395], [-121.95011, 38.02426]]]} | Open Access 1 | 48137 | Ambrose Center Park | 32665 | 2001 | Ambrose Recreation and Park District 217 | Special District 4 | Recreation/Parks District 4 | http://www.ambroserec.org/ | Special District 4 | 2001 | Ambrose Recreation and Park District 213 | Special District 4 | Recreation/Parks District 4 | https://www.ambroserec.org/ambrose-center-park | Contra Costa 12 | 7.507 | Ambrose Ctr. Park | 1973 | Local Park 2 | 4 |
592 | 592 | 591 | {"type": "Polygon", "coordinates": [[[-121.94024, 38.01658], [-121.93978, 38.01658], [-121.93977, 38.01672], [-121.93947, 38.01673], [-121.9395, 38.01832], [-121.93948, 38.01832], [-121.93914, 38.01842], [-121.93876, 38.01847], [-121.93842, 38.01836], [-121.93821, 38.01832], [-121.93821, 38.01825], [-121.93793, 38.01815], [-121.9373, 38.01768], [-121.93773, 38.01605], [-121.94023, 38.01603], [-121.94024, 38.01658]]]} | Open Access 1 | 2015 | Ambrose Park | 15445 | 2001 | Ambrose Recreation and Park District 217 | Special District 4 | Recreation/Parks District 4 | http://www.ambroserec.org/ | Special District 4 | 2001 | Ambrose Recreation and Park District 213 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 11.746 | Ambrose Park | 0 | Local Park 2 | 4 | |
6455 | 6455 | 6454 | {"type": "Polygon", "coordinates": [[[-117.61081, 33.96804], [-117.60946, 33.96804], [-117.60945, 33.96786], [-117.60921, 33.96786], [-117.60921, 33.96804], [-117.60387, 33.96805], [-117.6108, 33.96589], [-117.61081, 33.96804]]]} | Open Access 1 | 48900 | American Heroes Park | 33617 | 2331 | Jurupa Community Services District 677 | Special District 4 | Community Services District 19 | http://parks.jcsd.us/ | Special District 4 | 2331 | Jurupa Community Services District 667 | Special District 4 | Community Services District 17 | https://www.jcsd.us/Home/Components/FacilityDirectory/FacilityDirectory/2/82 | Riverside 10 | 18.815 | American Heroes 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]);