units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,989 rows where DES_TP = 3 sorted by ACRES
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- San Diego, City of 210
- Los Angeles, City of 115
- San Francisco, City and County of 79
- Mountains Recreation and Conservation Authority 58
- Los Angeles, County of 31
- Conejo Open Space Conservation Agency 29
- East Bay Regional Park District 28
- San Luis Obispo, City of 26
- Long Beach, City of 25
- Las Virgenes Municipal Water District 24
- Davis, City of 23
- Glendale, City of 22
- Santa Barbara, County of 19
- Santa Clarita, City of 18
- Sacramento, City of 18
- San Jose, City of 17
- Vacaville, City of 17
- Oakland, City of 16
- Thousand Oaks, City of 16
- Fullerton, City of 15
- Los Angeles - Department of Parks and Recreation, County of 15
- Santa Cruz, City of 14
- San Bernardino, City of 14
- San Marcos, City of 14
- East Bay Municipal Utility District 13
- Tiburon, Town of 13
- Conejo Recreation and Park District 12
- Carlsbad, City of 12
- Poway, City of 12
- Sunrise Recreation and Park District 12
- …
MNG_AG_TYP 17
- City Agency 1,429
- Recreation/Parks District 160
- County Agency 117
- Open Space District 88
- Water District 65
- County Agency - Parks 37
- Irrigation District 23
- Community Services District 14
- Flood District 11
- Port/Harbor District 5
- School District 5
- County Agency - Other 4
- Special District - Other 4
- Sanitation District 3
- Cemetery District 2
- Conservation District 1
- Transportation Agency 1
ACCESS_TYP 4
- Open Access 1,625
- Restricted Access 219
- No Public Access 109
- Unknown Access 16
DES_TP 1
- Local Recreation Area · 1,969 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
986 | 986 | 985 | {"type": "MultiPolygon", "coordinates": [[[[-118.07211, 33.98316], [-118.0721, 33.98317], [-118.07151, 33.98276], [-118.07152, 33.98275], [-118.07211, 33.98316]]], [[[-118.07278, 33.98341], [-118.07277, 33.98343], [-118.07221, 33.98304], [-118.07222, 33.98303], [-118.07278, 33.98341]]], [[[-118.07399, 33.98445], [-118.07398, 33.98447], [-118.07355, 33.98418], [-118.07356, 33.98416], [-118.07399, 33.98445]]]]} | Open Access 1 | 6696 | San Gabriel River & Bike Trail | 24897 | 2272 | Los Angeles County Flood Control District 287 | Special District 4 | Flood District 8 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 2272 | Los Angeles County Flood Control District 284 | Special District 4 | Flood District 9 | Los Angeles 6 | 0.082 | San Gabriel River & Bike Trail | 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 |
8335 | 8335 | 8334 | {"type": "Polygon", "coordinates": [[[-121.07801, 38.69279], [-121.07777, 38.69282], [-121.07777, 38.69263], [-121.07784, 38.69262], [-121.07786, 38.69264], [-121.07792, 38.69263], [-121.07799, 38.69273], [-121.07801, 38.69279]]]} | Open Access 1 | 47800 | New York Creek Nature Trail | 30318 | 2220 | El Dorado Irrigation District 890 | Special District 4 | Irrigation District 17 | http://www.eid.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/new-york-creek/index.html | El Dorado 34 | 0.089 | New York Creek Nature Trail | 0 | 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 | |
2066 | 2066 | 2065 | {"type": "Polygon", "coordinates": [[[-118.67437, 34.13917], [-118.67424, 34.13936], [-118.67408, 34.13928], [-118.67422, 34.13909], [-118.67437, 34.13917]]]} | No Public Access 3 | 12422 | Las Virgenes Municipal Water District Open Space | 21072 | 2059 | Las Virgenes Municipal Water District 398 | Special District 4 | Water District 13 | http://www.lvmwd.com/ | Special District 4 | 2059 | Las Virgenes Municipal Water District 392 | Special District 4 | Water District 13 | Los Angeles 6 | 0.103 | Las Virgenes Municipal Water District OS | 0 | Local Recreation Area 3 | 4 | |
15991 | 15991 | 15990 | {"type": "Polygon", "coordinates": [[[-117.1688, 33.15147], [-117.16874, 33.15146], [-117.16824, 33.15127], [-117.16804, 33.15122], [-117.16773, 33.15117], [-117.16777, 33.15112], [-117.16796, 33.15118], [-117.168, 33.15117], [-117.16818, 33.15124], [-117.16821, 33.15121], [-117.16838, 33.1513], [-117.16843, 33.15128], [-117.16859, 33.15137], [-117.16863, 33.15136], [-117.1688, 33.15147]]]} | Open Access 1 | 1808 | City of San Marcos Open Space | 17333 | 1308 | San Marcos, City of 201 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | San Diego 4 | 0.109 | City of San Marcos OS | 0 | Local Recreation Area 3 | 4 | |
7635 | 7635 | 7634 | {"type": "Polygon", "coordinates": [[[-118.25546, 34.22082], [-118.25537, 34.22087], [-118.25538, 34.22104], [-118.25521, 34.22098], [-118.25528, 34.22083], [-118.25519, 34.2208], [-118.25539, 34.2207], [-118.25546, 34.22082]]]} | Open Access 1 | 7155 | 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.115 | City of Glendale Verdugo Mtns. OS | 0 | Local Recreation Area 3 | 4 | |
12501 | 12501 | 12500 | {"type": "MultiPolygon", "coordinates": [[[[-122.05671, 38.25641], [-122.05649, 38.25652], [-122.05634, 38.25651], [-122.0563, 38.25649], [-122.05666, 38.25634], [-122.05671, 38.25641]]], [[[-122.06112, 38.25383], [-122.06072, 38.254], [-122.06069, 38.25395], [-122.06087, 38.25392], [-122.06096, 38.25387], [-122.06108, 38.25378], [-122.06112, 38.25383]]]]} | Open Access 1 | 28317 | Linear Park Playground | 21306 | 1105 | Fairfield, City of 208 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | Solano 26 | 0.116 | Linear Park Playground | 0 | Local Recreation Area 3 | 4 | |
6868 | 6868 | 6867 | {"type": "Polygon", "coordinates": [[[-118.38545, 33.86935], [-118.38521, 33.86935], [-118.38521, 33.86898], [-118.38541, 33.86928], [-118.38545, 33.86935]]]} | Open Access 1 | 6091 | Redondo Beach Open Space | 24239 | 1270 | Redondo Beach, City of 246 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | Los Angeles 6 | 0.118 | Redondo Beach OS | 0 | Local Recreation Area 3 | 4 | |
6492 | 6492 | 6491 | {"type": "Polygon", "coordinates": [[[-117.17175, 32.73853], [-117.17141, 32.73854], [-117.17141, 32.7384], [-117.17175, 32.7384], [-117.17175, 32.73853]]]} | Open Access 1 | 180 | 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.122 | Uptown OS | 0 | Local Recreation Area 3 | 4 | |
13957 | 13957 | 13956 | {"type": "Polygon", "coordinates": [[[-122.31129, 38.33053], [-122.31128, 38.33057], [-122.31125, 38.3306], [-122.3111, 38.33063], [-122.31102, 38.33039], [-122.31124, 38.33035], [-122.31129, 38.33053]]]} | Open Access 1 | 36599 | Sequoia Tot Lot | 30029 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 0.125 | Sequoia Tot Lot | 0 | Local Recreation Area 3 | 4 | |
7634 | 7634 | 7633 | {"type": "Polygon", "coordinates": [[[-118.25521, 34.22126], [-118.25496, 34.22127], [-118.25483, 34.22122], [-118.25495, 34.22109], [-118.25521, 34.22114], [-118.25521, 34.22126]]]} | Open Access 1 | 7154 | 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.128 | City of Glendale Verdugo Mtns. OS | 0 | Local Recreation Area 3 | 4 | |
8322 | 8322 | 8321 | {"type": "Polygon", "coordinates": [[[-118.60332, 34.08036], [-118.60312, 34.08066], [-118.60292, 34.08071], [-118.60319, 34.08034], [-118.60332, 34.08036]]]} | Open Access 1 | 12773 | Los Angeles County Open Space | 21481 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 0.131 | Los Angeles County OS | 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]);