units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,414 rows where AGNCY_LEV = 2 and DES_TP = 3 sorted by ACRES
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- San Diego, City of 209
- Los Angeles, City of 115
- San Francisco, City and County of 80
- San Luis Obispo, City of 24
- Glendale, City of 24
- Davis, City of 23
- Long Beach, City of 23
- Sacramento, City of 18
- San Jose, City of 17
- Vacaville, City of 17
- Santa Clarita, City of 17
- Oakland, City of 16
- Thousand Oaks, City of 16
- Fullerton, City of 15
- Santa Cruz, City of 14
- San Marcos, City of 14
- Tiburon, Town of 13
- Poway, City of 12
- San Bernardino, City of 12
- Carlsbad, City of 11
- Mission Viejo, City of 11
- Fresno, City of 10
- Oceanside, City of 10
- Riverside, City of 9
- Irvine, City of 9
- Roseville, City of 9
- Santa Barbara, City of 8
- South San Francisco, City of 8
- Escondido, City of 8
- Chico, City of 8
- …
MNG_AG_TYP 7
ACCESS_TYP 4
- Open Access 1,229
- Restricted Access 140
- No Public Access 39
- Unknown Access 6
DES_TP 1
- Local Recreation Area · 1,414 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10240 | 10240 | 10239 | {"type": "Polygon", "coordinates": [[[-121.94543, 36.97873], [-121.9451, 36.97895], [-121.94502, 36.97897], [-121.94541, 36.9787], [-121.94543, 36.97873]]]} | Open Access 1 | 17920 | Monterey Avenue Park Access | 22415 | 1044 | Capitola, City of 112 | City 2 | City Agency 2 | http://www.cityofcapitola.org/publicworks/page/parks | City 2 | 1044 | Capitola, City of 109 | City 2 | City Agency 2 | Santa Cruz 5 | 0.034 | Monterey Avenue Park Access | 0 | Local Recreation Area 3 | 4 | |
15345 | 15345 | 15344 | {"type": "Polygon", "coordinates": [[[-118.13021, 34.02626], [-118.1301, 34.02634], [-118.13002, 34.02626], [-118.13013, 34.02617], [-118.13021, 34.02626]]]} | Open Access 1 | 46529 | Dutcher Tot Lot | 29820 | 1211 | Montebello, City of 252 | City 2 | City Agency 2 | http://www.cityofmontebello.com/depts/parks/default.asp | City 2 | 1211 | Montebello, City of 248 | City 2 | City Agency 2 | Los Angeles 6 | 0.039 | Dutcher Tot Lot | 0 | Local Recreation Area 3 | 4 | |
2826 | 2826 | 2825 | {"type": "Polygon", "coordinates": [[[-117.12944, 32.98294], [-117.12938, 32.98304], [-117.12928, 32.9829], [-117.12938, 32.98285], [-117.12944, 32.98294]]]} | Open Access 1 | 931 | Black Mountain Open Space Park | 10257 | 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 | http://www.sandiego.gov/park-and-recreation/parks/osp/blackmtn/index.shtml | San Diego 4 | 0.04 | Black Mtn. OS Park | 0 | Local Recreation Area 3 | 4 |
917 | 917 | 916 | {"type": "Polygon", "coordinates": [[[-118.446, 34.13918], [-118.44599, 34.13919], [-118.44597, 34.13919], [-118.44542, 34.13894], [-118.44542, 34.13891], [-118.446, 34.13918]]]} | Open Access 1 | 6396 | Oak Forest West Access | 22965 | 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.044 | Oak Forest West Access | 0 | Local Recreation Area 3 | 4 | |
14417 | 14417 | 14416 | {"type": "Polygon", "coordinates": [[[-123.9855, 40.88189], [-123.98541, 40.88195], [-123.98525, 40.88184], [-123.98534, 40.88177], [-123.9855, 40.88189]]]} | Open Access 1 | 47033 | City of Blue Lake Tot Lot | 30684 | 1443 | Blue Lake, City of 716 | City 2 | City Agency 2 | http://bluelake.ca.gov/ | City 2 | 1443 | Blue Lake, City of 699 | City 2 | City Agency 2 | Humboldt 45 | 0.047 | City of Blue Lake Tot Lot | 0 | Local Recreation Area 3 | 4 | |
8826 | 8826 | 8825 | {"type": "Polygon", "coordinates": [[[-122.41355, 37.63561], [-122.41355, 37.63561], [-122.41334, 37.63565], [-122.41336, 37.63552], [-122.41342, 37.63547], [-122.41351, 37.63555], [-122.41355, 37.63561]]]} | Open Access 1 | 14387 | Herman Tot Lot | 19867 | 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.056 | Herman Tot Lot | 1940 | Local Recreation Area 3 | 4 | |
11460 | 11460 | 11459 | {"type": "Polygon", "coordinates": [[[-118.30636, 33.88501], [-118.306, 33.88501], [-118.306, 33.88495], [-118.30635, 33.88494], [-118.30636, 33.88501]]]} | Restricted Access 2 | 48160 | Rush Memorial Gymnasium | 32699 | 1117 | Gardena, City of 297 | City 2 | City Agency 2 | http://www.ci.gardena.ca.us/ | City 2 | 1117 | Gardena, City of 293 | City 2 | City Agency 2 | https://www.facebook.com/pages/Rush-Memorial-Gymnasium/1811050155861741 | Los Angeles 6 | 0.058 | Rush Memorial Gymnasium | 0 | Local Recreation Area 3 | 4 |
11170 | 11170 | 11169 | {"type": "Polygon", "coordinates": [[[-122.29374, 37.88467], [-122.29357, 37.88471], [-122.29353, 37.88457], [-122.2937, 37.88454], [-122.29374, 37.88467]]]} | Open Access 1 | 48000 | Opal Staniek Tot Lot | 33380 | 1002 | Albany, City of 274 | City 2 | City Agency 2 | http://www.albanyca.org/index.aspx?page=473 | City 2 | 1002 | Albany, City of 269 | City 2 | City Agency 2 | https://www.albanyca.org/Home/Components/FacilityDirectory/FacilityDirectory/69/1670 | Alameda 17 | 0.06 | Opal Staniek Tot Lot | 0 | Local Recreation Area 3 | 4 |
1269 | 1269 | 1268 | {"type": "Polygon", "coordinates": [[[-118.26461, 34.17807], [-118.26461, 34.17807], [-118.26442, 34.17818], [-118.2644, 34.17805], [-118.26441, 34.17804], [-118.26459, 34.17797], [-118.26461, 34.17807]]]} | Open Access 1 | 7148 | City of Glendale Verdugo Mountains Open Space | 4153 | 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.061 | City of Glendale Verdugo Mtns. OS | 0 | Local Recreation Area 3 | 4 | |
16122 | 16122 | 16121 | {"type": "Polygon", "coordinates": [[[-122.43454, 37.73883], [-122.43413, 37.73884], [-122.43411, 37.73877], [-122.43447, 37.73876], [-122.43454, 37.73883]]]} | Open Access 1 | 15929 | Diamond & Farnum Open Space | 18138 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 0.069 | Diamond & Farnum OS | 0 | Local Recreation Area 3 | 4 | |
16937 | 16937 | 16936 | {"type": "Polygon", "coordinates": [[[-118.26513, 34.17801], [-118.26487, 34.17804], [-118.26484, 34.17792], [-118.2651, 34.1779], [-118.26513, 34.17801]]]} | Open Access 1 | 7149 | City of Glendale Verdugo Mountains Open Space | 4153 | 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.075 | City of Glendale Verdugo Mtns. OS | 0 | Local Recreation Area 3 | 4 | |
6147 | 6147 | 6146 | {"type": "Polygon", "coordinates": [[[-120.65509, 35.2621], [-120.65487, 35.26189], [-120.65504, 35.26178], [-120.65504, 35.26178], [-120.65509, 35.2621]]]} | Open Access 1 | 1140 | Stoneridge Development Open Space | 25895 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 0.077 | Stoneridge Development OS | 0 | Local Recreation Area 3 | 4 | |
5805 | 5805 | 5804 | {"type": "Polygon", "coordinates": [[[-117.15503, 32.75526], [-117.15494, 32.7552], [-117.15494, 32.75483], [-117.15502, 32.75483], [-117.15503, 32.75526]]]} | Open Access 1 | 73 | Uptown Open Space | 26740 | 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.082 | Uptown OS | 0 | Local Recreation Area 3 | 4 | |
11432 | 11432 | 11431 | {"type": "Polygon", "coordinates": [[[-118.19075, 33.79976], [-118.19062, 33.79976], [-118.19062, 33.79951], [-118.19075, 33.79951], [-118.19075, 33.79976]]]} | Open Access 1 | 48115 | Locust Tot Lot | 32630 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/park-and-facilities/directory/locust-tot-lot/ | Los Angeles 6 | 0.085 | Locust Tot Lot | 2016 | Local Recreation Area 3 | 4 |
3977 | 3977 | 3976 | {"type": "Polygon", "coordinates": [[[-121.85453, 37.34889], [-121.85442, 37.34894], [-121.85423, 37.34868], [-121.85434, 37.34863], [-121.85453, 37.34889]]]} | Open Access 1 | 48844 | San Antonio Tot Lot | 33564 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | https://www.sanjoseca.gov/Home/Components/FacilityDirectory/FacilityDirectory/2945/37 | Santa Clara 19 | 0.09 | San Antonio Tot Lot | 0 | Local Recreation Area 3 | 4 |
4934 | 4934 | 4933 | {"type": "Polygon", "coordinates": [[[-117.08994, 32.84113], [-117.08988, 32.84128], [-117.08972, 32.84134], [-117.08976, 32.84106], [-117.08994, 32.84113]]]} | Open Access 1 | 241 | Tierrasanta Open Space | 10608 | 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.095 | Tierrasanta OS | 0 | Local Recreation Area 3 | 4 | |
10588 | 10588 | 10587 | {"type": "Polygon", "coordinates": [[[-117.10949, 32.77704], [-117.10951, 32.77714], [-117.10945, 32.77755], [-117.10939, 32.77756], [-117.10944, 32.77714], [-117.10941, 32.77704], [-117.10949, 32.77704]]]} | Open Access 1 | 18912 | Mission Valley Slopes #2 Open Space | 22317 | 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.095 | Mission Valley Slopes #2 OS | 0 | Local Recreation Area 3 | 4 | |
3300 | 3300 | 3299 | {"type": "Polygon", "coordinates": [[[-122.29705, 37.50541], [-122.29705, 37.50546], [-122.29697, 37.50559], [-122.29687, 37.50551], [-122.29678, 37.50541], [-122.29685, 37.50536], [-122.29697, 37.50534], [-122.29703, 37.50536], [-122.29705, 37.50541]]]} | Open Access 1 | 48212 | Hastings Tot Lot | 32752 | 1025 | Belmont, City of 198 | City 2 | City Agency 2 | http://www.belmont.gov/city-hall/park-and-recreation | City 2 | 1025 | Belmont, City of 194 | City 2 | City Agency 2 | San Mateo 15 | 0.096 | Hastings Tot Lot | 0 | Local Recreation Area 3 | 4 | |
14045 | 14045 | 14044 | {"type": "Polygon", "coordinates": [[[-122.54914, 38.10824], [-122.54909, 38.10831], [-122.54903, 38.10833], [-122.54883, 38.10823], [-122.54892, 38.10809], [-122.54903, 38.10813], [-122.54905, 38.1082], [-122.54914, 38.10824]]]} | Open Access 1 | 38046 | Knolltop Tot Lot | 20702 | 1226 | Novato, City of 444 | City 2 | City Agency 2 | http://www.ci.novato.ca.us/Index.aspx?page=520 | City 2 | 1226 | Novato, City of 438 | City 2 | City Agency 2 | Marin 23 | 0.097 | Knolltop Tot Lot | 0 | Local Recreation Area 3 | 4 | |
3111 | 3111 | 3110 | {"type": "Polygon", "coordinates": [[[-122.07502, 37.59279], [-122.07482, 37.5928], [-122.07481, 37.59272], [-122.07469, 37.59272], [-122.07477, 37.59259], [-122.07489, 37.59264], [-122.075, 37.59267], [-122.07502, 37.59279]]]} | Open Access 1 | 48004 | Holly Community Center | 32427 | 1362 | Union City, City of 365 | City 2 | City Agency 2 | http://www.ci.union-city.ca.us/ | City 2 | 1362 | Union City, City of 361 | City 2 | City Agency 2 | Alameda 17 | 0.098 | Holly Community Ctr. | 0 | Local Recreation Area 3 | 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]);