units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
117 rows where ACCESS_TYP = 2, AGNCY_TYP = 14 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
Suggested facets: PARK_URL, COUNTY, YR_EST
MNG_AGENCY >30
- Whittier, City of 18
- San Ramon, City of 15
- Arcadia, City of 7
- Manhattan Beach, City of 7
- Hollister, City of 6
- Santa Ana, City of 5
- Beverly Hills, City of 5
- Lawndale, City of 4
- Los Angeles, City of 3
- Carlsbad, City of 3
- San Bernardino, City of 3
- Palmdale, City of 3
- Pasadena, City of 3
- San Gabriel, City of 3
- San Diego, City of 2
- Glendora, City of 2
- Lake Elsinore, City of 2
- Sierra Madre, City of 2
- South El Monte, City of 2
- Santa Rosa, City of 1
- Encinitas, City of 1
- Yorba Linda, City of 1
- Oceanside, City of 1
- Huntington Park, City of 1
- El Centro, City of 1
- Burbank, City of 1
- Azusa, City of 1
- Walnut Creek, City of 1
- Brea, City of 1
- Needles, City of 1
- …
DES_TP 4
- Local Park 91
- Local Recreation Area 24
- None 1
- None 1
MNG_AG_TYP 1
- City Agency · 117 ✖
ACCESS_TYP 1
- Restricted Access · 117 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
347 | 347 | 346 | {"type": "Polygon", "coordinates": [[[-117.85051, 34.14864], [-117.85051, 34.14999], [-117.84989, 34.15], [-117.84989, 34.15052], [-117.84633, 34.15052], [-117.84629, 34.15049], [-117.84629, 34.14964], [-117.84651, 34.14929], [-117.84697, 34.14876], [-117.84774, 34.14876], [-117.84775, 34.14814], [-117.84839, 34.14815], [-117.84839, 34.14865], [-117.85051, 34.14864]]]} | Restricted Access 2 | 953 | George Manooshian Park | 29754 | 2312 | Glendora Unified School District 141 | Special District 4 | School District 14 | http://www.glendora.k12.ca.us/ | Special District 4 | 1120 | Glendora, City of 74 | City 2 | City Agency 2 | Los Angeles 6 | 18.865 | George Manooshian Park | 0 | Local Park 2 | 4 | |
2098 | 2098 | 2097 | {"type": "Polygon", "coordinates": [[[-121.89542, 37.75272], [-121.89511, 37.75373], [-121.89391, 37.75351], [-121.89423, 37.75248], [-121.89542, 37.75272]]]} | Restricted Access 2 | 47568 | Live Oak School Park | 31293 | 2309 | San Ramon Valley Unified School District 478 | Special District 4 | School District 14 | http://www.srvusd.net/ | Special District 4 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | Contra Costa 12 | 3.116 | Live Oak School Park | 0 | Local Park 2 | 4 | |
2099 | 2099 | 2098 | {"type": "Polygon", "coordinates": [[[-121.94503, 37.73765], [-121.94369, 37.73818], [-121.94322, 37.73744], [-121.94227, 37.7378], [-121.94234, 37.73798], [-121.94192, 37.73811], [-121.94168, 37.73772], [-121.94145, 37.73739], [-121.94426, 37.7363], [-121.9444, 37.73653], [-121.94433, 37.7366], [-121.94433, 37.73668], [-121.94438, 37.73674], [-121.94449, 37.73676], [-121.94503, 37.73765]]]} | Restricted Access 2 | 47569 | Pine Valley Middle School Parks and Community Gym | 31294 | 2309 | San Ramon Valley Unified School District 478 | Special District 4 | School District 14 | http://www.srvusd.net/ | Special District 4 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | Contra Costa 12 | 8.075 | Pine Valley Middle School Parks and Community Gym | 0 | Local Recreation Area 3 | 4 | |
2216 | 2216 | 2215 | {"type": "Polygon", "coordinates": [[[-121.90955, 37.75216], [-121.90924, 37.75257], [-121.90894, 37.75304], [-121.90858, 37.75288], [-121.90819, 37.75274], [-121.90782, 37.75266], [-121.90741, 37.75261], [-121.90741, 37.7522], [-121.90735, 37.75209], [-121.90718, 37.752], [-121.90702, 37.75197], [-121.90676, 37.75208], [-121.9058, 37.75097], [-121.9068, 37.75041], [-121.90754, 37.75103], [-121.90769, 37.7511], [-121.90786, 37.75114], [-121.90802, 37.75114], [-121.90823, 37.75111], [-121.90845, 37.75099], [-121.90955, 37.75216]]]} | Restricted Access 2 | 47570 | Windemere Ranch School Park | 31295 | 2309 | San Ramon Valley Unified School District 478 | Special District 4 | School District 14 | http://www.srvusd.net/ | Special District 4 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | Contra Costa 12 | 11.225 | Windemere Ranch School Park | 0 | Local Park 2 | 4 | |
2890 | 2890 | 2889 | {"type": "Polygon", "coordinates": [[[-121.39678, 36.84126], [-121.39678, 36.84159], [-121.39616, 36.84157], [-121.39614, 36.84183], [-121.39515, 36.8418], [-121.39507, 36.842], [-121.39507, 36.84215], [-121.39527, 36.84217], [-121.39527, 36.84247], [-121.39543, 36.84248], [-121.39542, 36.84336], [-121.39404, 36.84334], [-121.39252, 36.84106], [-121.39624, 36.84113], [-121.39633, 36.8412], [-121.39644, 36.84126], [-121.39678, 36.84126]]]} | Restricted Access 2 | 18924 | Rancho San Justo Sports Complex | 32730 | 2425 | Hollister School District 561 | Special District 4 | School District 14 | https://www.hesd.org/ | Special District 4 | 1138 | Hollister, City of 196 | City 2 | City Agency 2 | San Benito 38 | 13.179 | Rancho San Justo Sports Complex | 0 | Local Recreation Area 3 | 4 | |
3237 | 3237 | 3236 | {"type": "MultiPolygon", "coordinates": [[[[-115.58465, 32.79644], [-115.5824, 32.79643], [-115.58235, 32.79448], [-115.58464, 32.79447], [-115.58465, 32.79644]]], [[[-115.58623, 32.79447], [-115.58623, 32.79645], [-115.58486, 32.79644], [-115.58485, 32.79446], [-115.58623, 32.79447]]]]} | Restricted Access 2 | 48110 | Sunflower Park | 32835 | 2422 | El Centro Elementary School District 602 | Special District 4 | School District 14 | www.ecesd.org | Special District 4 | 1093 | El Centro, City of 92 | City 2 | City Agency 2 | http://www.cityofelcentro.org | Imperial 20 | 18.451 | Sunflower Park | 2000 | Local Park 2 | 4 |
3290 | 3290 | 3289 | {"type": "Polygon", "coordinates": [[[-121.39236, 36.82838], [-121.39233, 36.82946], [-121.39215, 36.82958], [-121.39084, 36.82955], [-121.3909, 36.8283], [-121.39236, 36.82838]]]} | Restricted Access 2 | 48200 | Ladd Lane School Park | 32765 | 2425 | Hollister School District 561 | Special District 4 | School District 14 | https://www.hesd.org/ | Special District 4 | 1138 | Hollister, City of 196 | City 2 | City Agency 2 | San Benito 38 | 4.424 | Ladd Lane School Park | 0 | Local Park 2 | 4 | |
3545 | 3545 | 3544 | {"type": "Polygon", "coordinates": [[[-118.04485, 34.04282], [-118.04349, 34.04401], [-118.04261, 34.04329], [-118.04286, 34.04329], [-118.04283, 34.04288], [-118.04383, 34.04199], [-118.0448, 34.04278], [-118.04482, 34.04281], [-118.04485, 34.04282]]]} | Restricted Access 2 | 20607 | New Temple Park | 31632 | 2383 | Valle Lindo Unified School District 658 | Special District 4 | School District 14 | http://www.vallelindo.k12.ca.us/ | Special District 4 | 1402 | South El Monte, City of 595 | City 2 | City Agency 2 | Los Angeles 6 | 5.682 | New Temple Park | 0 | Local Park 2 | 4 | |
3663 | 3663 | 3662 | {"type": "Polygon", "coordinates": [[[-118.35756, 33.87843], [-118.35626, 33.87843], [-118.35625, 33.87755], [-118.3565, 33.87755], [-118.35651, 33.87731], [-118.35663, 33.87731], [-118.35663, 33.87709], [-118.35756, 33.87709], [-118.35756, 33.87843]]]} | Restricted Access 2 | 44123 | William Green Park | 27544 | 2396 | Lawndale Elementary School District 670 | Special District 4 | School District 14 | http://www.lawndale.k12.ca.us/ | Special District 4 | 1172 | Lawndale, City of 475 | City 2 | City Agency 2 | http://www.lawndalecity.org/ASSETS/PDF/Parks/williamgreenpark.pdf | Los Angeles 6 | 4.064 | William Green Park | 0 | Local Park 2 | 4 |
3922 | 3922 | 3921 | {"type": "Polygon", "coordinates": [[[-118.17903, 34.59426], [-118.17429, 34.59426], [-118.17423, 34.59106], [-118.17426, 34.59084], [-118.17426, 34.59041], [-118.17434, 34.59034], [-118.17507, 34.59036], [-118.17509, 34.59034], [-118.17895, 34.59035], [-118.17903, 34.59426]]]} | Restricted Access 2 | 46141 | Highland High School Park | 31877 | 2388 | Antelope Valley Union High School District 698 | Special District 4 | School District 14 | http://www.avdistrict.org/ | Special District 4 | 1242 | Palmdale, City of 201 | City 2 | City Agency 2 | Los Angeles 6 | 46.587 | Highland High School Park | 0 | Local Park 2 | 4 | |
3932 | 3932 | 3931 | {"type": "Polygon", "coordinates": [[[-118.4757, 34.42905], [-118.47423, 34.42905], [-118.4742, 34.42839], [-118.47412, 34.42835], [-118.47409, 34.42733], [-118.47558, 34.42732], [-118.47558, 34.42796], [-118.47557, 34.42802], [-118.47558, 34.42841], [-118.47568, 34.42842], [-118.4757, 34.42905]]]} | Restricted Access 2 | 46226 | North Oaks Park | 31633 | 2389 | William S. Hart Union High School District 702 | Special District 4 | School District 14 | http://www.hartdistrict.org/ | Special District 4 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=413 | Los Angeles 6 | 6.399 | North Oaks Park | 0 | Local Park 2 | 4 |
3975 | 3975 | 3974 | {"type": "Polygon", "coordinates": [[[-118.01891, 33.96032], [-118.01812, 33.96131], [-118.01618, 33.96022], [-118.01659, 33.95971], [-118.01891, 33.96032]]]} | Restricted Access 2 | 46582 | Ocean View Elementary School Park | 31920 | 2370 | East Whittier City School District 707 | Special District 4 | School District 14 | http://ewcsd.org/ | Special District 4 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | Los Angeles 6 | 5.333 | Ocean View Elementary School Park | 0 | Local Park 2 | 4 | |
3978 | 3978 | 3977 | {"type": "Polygon", "coordinates": [[[-118.05658, 34.16669], [-118.05578, 34.16669], [-118.05577, 34.16573], [-118.05657, 34.16571], [-118.05658, 34.16669]]]} | Restricted Access 2 | 46602 | Sierra Madre Elementary School Park | 31924 | 2360 | Pasadena Unified School District 708 | Special District 4 | School District 14 | http://www.pusd.us/pages/PasadenaUSD | Special District 4 | 1333 | Sierra Madre, City of 308 | City 2 | City Agency 2 | Los Angeles 6 | 1.948 | Sierra Madre Elementary School Park | 0 | Local Park 2 | 4 | |
4031 | 4031 | 4030 | {"type": "Polygon", "coordinates": [[[-122.01457, 37.93282], [-122.01322, 37.93363], [-122.01205, 37.93236], [-122.01398, 37.93158], [-122.01414, 37.93182], [-122.01456, 37.93195], [-122.01454, 37.93209], [-122.01455, 37.93222], [-122.01415, 37.93237], [-122.01457, 37.93282]]]} | Restricted Access 2 | 44198 | Valle Verde Park | 26771 | 2317 | Mount Diablo Unified School District 712 | Special District 4 | School District 14 | http://www.mdusd.org/ | Special District 4 | 1371 | Walnut Creek, City of 174 | City 2 | City Agency 2 | Contra Costa 12 | 6.862 | Valle Verde Park | 0 | Local Park 2 | 4 | |
4165 | 4165 | 4164 | {"type": "Polygon", "coordinates": [[[-121.94848, 37.74904], [-121.94621, 37.74996], [-121.94536, 37.74865], [-121.94551, 37.7483], [-121.94569, 37.74815], [-121.94589, 37.7481], [-121.94621, 37.74811], [-121.94644, 37.7482], [-121.9468, 37.74876], [-121.94796, 37.74823], [-121.94848, 37.74904]]]} | Restricted Access 2 | 47573 | California High School Tennis Courts and Track | 31298 | 2309 | San Ramon Valley Unified School District 478 | Special District 4 | School District 14 | http://www.srvusd.net/ | Special District 4 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | Contra Costa 12 | 7.772 | California High School Tennis Courts and Track | None 360 | |||
4166 | 4166 | 4165 | {"type": "Polygon", "coordinates": [[[-121.07771, 39.22081], [-121.07676, 39.22153], [-121.07673, 39.22149], [-121.07655, 39.22152], [-121.07648, 39.22148], [-121.07549, 39.22233], [-121.07527, 39.22221], [-121.07499, 39.22212], [-121.07443, 39.22199], [-121.07444, 39.22102], [-121.07552, 39.22103], [-121.07557, 39.22092], [-121.07556, 39.22075], [-121.07569, 39.22072], [-121.07668, 39.22003], [-121.07771, 39.22081]]]} | Restricted Access 2 | 48291 | Margaret G Scotten School Ballfields | 32866 | 2429 | Grass Valley School District 728 | Special District 4 | School District 14 | www.gvsd.us | Special District 4 | 1673 | Grass Valley, City of 712 | City 2 | City Agency 2 | Nevada 30 | 8.566 | Margaret G Scotten School Ballfields | 2018 | None 361 | ||
4386 | 4386 | 4385 | {"type": "Polygon", "coordinates": [[[-117.35693, 33.17681], [-117.35685, 33.17689], [-117.3562, 33.17729], [-117.35652, 33.17766], [-117.35629, 33.17779], [-117.35659, 33.17815], [-117.3568, 33.1783], [-117.3563, 33.1786], [-117.35517, 33.17726], [-117.3566, 33.1764], [-117.35693, 33.17681]]]} | Restricted Access 2 | 45967 | South Oceanside School Park | 31598 | 2100 | Oceanside Unified School District 756 | Special District 4 | School District 14 | http://www.oside.k12.ca.us/ | Special District 4 | 1230 | Oceanside, City of 75 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/gov/ns/parks/amenities/parks.asp#48 | San Diego 4 | 4.254 | South Oceanside School Park | 0 | Local Park 2 | 4 |
4411 | 4411 | 4410 | {"type": "Polygon", "coordinates": [[[-118.35352, 34.18058], [-118.3535, 34.18106], [-118.35346, 34.18107], [-118.35306, 34.18107], [-118.35307, 34.18057], [-118.35352, 34.18058]]]} | Restricted Access 2 | 46266 | Maple Street Playground | 31626 | 2391 | Burbank Unified School District 759 | Special District 4 | School District 14 | http://www.burbankusd.org/ | Special District 4 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | http://www.burbankca.gov/departments/parks-and-recreation/parks-facilities/maple-street-playground | Los Angeles 6 | 0.55 | Maple Street Playground | 0 | Local Recreation Area 3 | 4 |
4439 | 4439 | 4438 | {"type": "Polygon", "coordinates": [[[-118.03633, 34.13066], [-118.03547, 34.13067], [-118.03546, 34.13071], [-118.03229, 34.13073], [-118.03226, 34.12947], [-118.03497, 34.12908], [-118.03498, 34.12944], [-118.03598, 34.12943], [-118.03599, 34.12981], [-118.0363, 34.12981], [-118.03633, 34.13066]]]} | Restricted Access 2 | 46490 | Arcadia High School Park | 31846 | 2315 | Arcadia Unified School District 762 | Special District 4 | School District 14 | http://site.ausd.net/ | Special District 4 | 1009 | Arcadia, City of 299 | City 2 | City Agency 2 | http://ahs.ausd.net/ | Los Angeles 6 | 13.815 | Arcadia High School Park | 0 | Local Park 2 | 4 |
4830 | 4830 | 4829 | {"type": "Polygon", "coordinates": [[[-118.01607, 33.95413], [-118.01537, 33.95498], [-118.01511, 33.95485], [-118.01456, 33.95558], [-118.01606, 33.9564], [-118.01525, 33.95741], [-118.01384, 33.95663], [-118.01356, 33.9561], [-118.0145, 33.95494], [-118.0145, 33.95492], [-118.01435, 33.95484], [-118.01524, 33.9537], [-118.01607, 33.95413]]]} | Restricted Access 2 | 46570 | East Whittier Middle School Park | 31913 | 2370 | East Whittier City School District 707 | Special District 4 | School District 14 | http://ewcsd.org/ | Special District 4 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | Los Angeles 6 | 10.453 | East Whittier Middle School 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]);