units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
17,068 rows sorted by ACRES
This data as json, copyable, CSV (advanced)
MNG_AG_TYP >30
- City Agency 10,373
- County Agency 1,206
- Recreation/Parks District 1,154
- State Agency 1,140
- Non Profit - Land Trust 599
- Federal Agency 517
- Open Space District 417
- County Agency - Parks 236
- Water District 234
- Home Owners Association 203
- Community Services District 195
- Non Profit - Conservation 145
- Flood District 106
- Cemetery District 62
- Irrigation District 50
- Non Profit - Other 45
- School District 38
- County Agency - Other 33
- Port/Harbor District 33
- Commercial 15
- Special District - Other 15
- Sanitation District 9
- Joint Powers Authority 9
- Other 6
- Non Profit - Cemetery District 5
- Conservation District 5
- Transportation Agency 5
- Mitigation Bank 4
- Non Profit - Education 3
- Metropolitan Planning Organization 2
- …
MNG_AGENCY >30
- San Diego, City of 524
- Los Angeles, City of 471
- California Department of Fish and Wildlife 443
- California Department of Parks and Recreation 380
- Mountains Recreation and Conservation Authority 341
- San Jose, City of 250
- San Francisco, City and County of 223
- Sacramento, City of 220
- Los Angeles, County of 175
- East Bay Regional Park District 165
- Long Beach, City of 145
- Roseville, City of 126
- Ventura, City of 125
- San Diego, County of 123
- United States Bureau of Land Management 121
- Santa Barbara, County of 118
- Oakland, City of 118
- United States Forest Service 111
- Irvine, City of 101
- Orange, County of 95
- Consumnes Community Services District 94
- Fresno, City of 89
- United States National Park Service 89
- California State Lands Commission 86
- Modesto, City of 85
- Hayward Area Recreation and Park District 84
- Santa Rosa, City of 82
- United States Fish and Wildlife Service 82
- Stockton, City of 81
- Napa, City of 79
- …
DES_TP >30
- Local Park 9,290
- Local Recreation Area 1,963
- Local Other or Unknown 1,125
- Private Conservation 627
- Local Conservation Area 481
- State Conservation Area 381
- Private Recreation or Education 265
- State Park 208
- State Resource Management Area 159
- State Recreation Area 145
- Local Historic or Cultural Area 116
- National Forest 99
- National Public Lands 75
- National Wildlife Refuge 75
- State Other or Unknown 69
- State Historic or Cultural Area 63
- Recreation Management Area 61
- Private Other or Unknown 51
- National Recreation Area 40
- National Monument or Landmark 39
- National Park 26
- Resource Management Area 26
- Local Resource Management Area 24
- Federal Other or Unknown 24
- Conservation Area 14
- Private Agricultural 12
- Wilderness Area 7
- Area of Critical Environmental Concern 7
- Historic or Cultural Area 5
- Private Historic or Cultural 4
- …
ACCESS_TYP 4
- Open Access 14,332
- Restricted Access 1,199
- No Public Access 958
- Unknown Access 379
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7926 | 7926 | 7925 | {"type": "Polygon", "coordinates": [[[-122.73678, 38.44783], [-122.73649, 38.44785], [-122.73648, 38.44771], [-122.73672, 38.44771], [-122.73677, 38.44775], [-122.73678, 38.44783]]]} | Open Access 1 | 10664 | Haydn Village Park | 19753 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 0.09 | Haydn Village Park | 0 | Local Park 2 | 4 | |
8192 | 8192 | 8191 | {"type": "Polygon", "coordinates": [[[-119.8023, 36.74348], [-119.80198, 36.74349], [-119.80205, 36.74325], [-119.80206, 36.74326], [-119.8023, 36.74348]]]} | Open Access 1 | 47321 | Broadway Pocket Park | 31027 | 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 | 0.09 | Broadway PP | 0 | Local Park 2 | 4 | |
12199 | 12199 | 12198 | {"type": "Polygon", "coordinates": [[[-124.08305, 40.87281], [-124.08288, 40.87326], [-124.08285, 40.87325], [-124.08292, 40.87278], [-124.08305, 40.87281]]]} | Open Access 1 | 25399 | Vinum Park | 27151 | 1432 | Arcata, City of 587 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | Humboldt 45 | 0.09 | Vinum Park | 0 | Local Park 2 | 4 | |
502 | 502 | 501 | {"type": "Polygon", "coordinates": [[[-119.06104, 34.35542], [-119.06084, 34.35549], [-119.06077, 34.35534], [-119.06097, 34.35527], [-119.06104, 34.35542]]]} | Open Access 1 | 48366 | Moreton Bay Fig Tree Park | 32932 | 1674 | Santa Paula, City of 190 | City 2 | City Agency 2 | http://www.ci.santa-paula.ca.us/ | City 2 | 1674 | Santa Paula, City of 186 | City 2 | City Agency 2 | Ventura 8 | 0.091 | Moreton Bay Fig Tree Park | 0 | Local Park 2 | 4 | |
4686 | 4686 | 4685 | {"type": "Polygon", "coordinates": [[[-120.45512, 34.65536], [-120.45512, 34.65556], [-120.45477, 34.65559], [-120.45508, 34.65538], [-120.45512, 34.65536]]]} | Open Access 1 | 43090 | Unnamed site - Santa Barbara Flood Control and Water Conserv. District | 28688 | 2141 | Santa Barbara Flood Control and Water Conserv. District 46 | Special District 4 | Flood District 8 | http://cosb.countyofsb.org/pwd/pwwater.aspx?id=3572 | Special District 4 | 2141 | Santa Barbara Flood Control and Water Conserv. District 45 | Special District 4 | Flood District 9 | Santa Barbara 7 | 0.091 | 0 | Local Other or Unknown 14 | 4 | ||
6532 | 6532 | 6531 | {"type": "Polygon", "coordinates": [[[-118.42634, 34.19022], [-118.42593, 34.19022], [-118.4259, 34.19019], [-118.42589, 34.19014], [-118.42634, 34.19014], [-118.42634, 34.19022]]]} | Open Access 1 | 2916 | Kittridge Mini Park | 20680 | 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.091 | Kittridge MP | 0 | Local Park 2 | 4 | |
13572 | 13572 | 13571 | {"type": "Polygon", "coordinates": [[[-117.02405, 33.00214], [-117.02394, 33.00214], [-117.02394, 33.00177], [-117.02401, 33.00177], [-117.02405, 33.00214]]]} | Open Access 1 | 35891 | Poway holding 22 | 23946 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 0.091 | Poway holding 22 | 0 | Local Other or Unknown 14 | 4 | |
2119 | 2119 | 2118 | {"type": "Polygon", "coordinates": [[[-122.43912, 37.75734], [-122.43895, 37.75734], [-122.43893, 37.75709], [-122.43911, 37.75715], [-122.43912, 37.75734]]]} | Open Access 1 | 15928 | Corwin Community Garden | 17668 | 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.092 | Corwin Community Garden | 0 | Local Park 2 | 4 | |
4231 | 4231 | 4230 | {"type": "Polygon", "coordinates": [[[-122.31412, 37.26649], [-122.31377, 37.26649], [-122.31369, 37.26638], [-122.31401, 37.26638], [-122.31412, 37.26649]]]} | No Public Access 3 | 29758 | Kraynick | 20724 | 3054 | Peninsula Open Space Trust 338 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.openspacetrust.org/ | Non Governmental Organization 10 | 3054 | Peninsula Open Space Trust 335 | Non Profit 6 | Non Profit - Land Trust 10 | San Mateo 15 | 0.092 | Kraynick | 0 | Private Conservation 16 | 2 | |
4673 | 4673 | 4672 | {"type": "Polygon", "coordinates": [[[-121.86411, 36.93794], [-121.86404, 36.93797], [-121.86384, 36.93798], [-121.86379, 36.93797], [-121.86377, 36.93793], [-121.86383, 36.93779], [-121.86393, 36.93787], [-121.86398, 36.93783], [-121.86411, 36.93794]]]} | Open Access 1 | 36646 | Unnamed site - La Selva Beach Recreation District | 28638 | 2056 | La Selva Beach Recreation District 772 | Special District 4 | Recreation/Parks District 4 | http://php.santacruzpl.org/cid/public/full.php?id=383 | Special District 4 | 2056 | La Selva Beach Recreation District 753 | Special District 4 | Recreation/Parks District 4 | Santa Cruz 5 | 0.092 | 0 | Local Other or Unknown 14 | 4 | ||
13552 | 13552 | 13551 | {"type": "Polygon", "coordinates": [[[-117.28549, 33.07638], [-117.28536, 33.07638], [-117.28543, 33.07582], [-117.28549, 33.07638], [-117.28549, 33.07638]]]} | Open Access 1 | 35868 | Encinitas holding 17 | 18648 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | San Diego 4 | 0.092 | Encinitas holding 17 | 0 | Local Other or Unknown 14 | 4 | |
1933 | 1933 | 1932 | {"type": "Polygon", "coordinates": [[[-118.39025, 33.81526], [-118.39021, 33.81551], [-118.3901, 33.81537], [-118.38993, 33.81522], [-118.39025, 33.81526]]]} | Open Access 1 | 5984 | Miramar Park | 22287 | 2158 | South Bay Cities Sanitation District 455 | Special District 4 | Sanitation District 18 | http://www.lacsd.org/ | Special District 4 | 2158 | South Bay Cities Sanitation District 449 | Special District 4 | Sanitation District 19 | Los Angeles 6 | 0.094 | Miramar Park | 0 | Local Park 2 | 4 | |
5634 | 5634 | 5633 | {"type": "Polygon", "coordinates": [[[-122.70518, 38.4452], [-122.70488, 38.44513], [-122.70485, 38.44509], [-122.70485, 38.44504], [-122.70498, 38.44494], [-122.70518, 38.4452]]]} | Open Access 1 | 29789 | College Triangle Park | 17513 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 0.094 | College Triangle Park | 0 | Local Park 2 | 4 | |
12630 | 12630 | 12629 | {"type": "Polygon", "coordinates": [[[-118.07687, 33.80434], [-118.07686, 33.8046], [-118.07673, 33.8046], [-118.07672, 33.80434], [-118.07687, 33.80434]]]} | Open Access 1 | 48794 | Roberts Park | 33515 | 1185 | Los Alamitos, City of 295 | City 2 | City Agency 2 | http://cityoflosalamitos.org/ | City 2 | 1185 | Los Alamitos, City of 291 | City 2 | City Agency 2 | https://cityoflosalamitos.org/recreation/events-facilities/facilities/parks-shelters/ | Orange 3 | 0.094 | Roberts Park | 0 | Local Park 2 | 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 | |
15496 | 15496 | 15495 | {"type": "Polygon", "coordinates": [[[-118.21315, 34.10672], [-118.21311, 34.10678], [-118.21276, 34.10672], [-118.21276, 34.10658], [-118.21315, 34.10672]]]} | Unknown Access 4 | 46171 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.095 | 0 | Local Other or Unknown 14 | 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 | |
3979 | 3979 | 3978 | {"type": "Polygon", "coordinates": [[[-117.85936, 33.75016], [-117.85918, 33.75024], [-117.85907, 33.75004], [-117.85927, 33.75002], [-117.85936, 33.75016]]]} | Open Access 1 | 48845 | Garfield Exercise | 33565 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | https://www.santa-ana.org/parks/parks-location/garfield-exercise | Orange 3 | 0.096 | Garfield Exercise | None 344 | ||
4886 | 4886 | 4885 | {"type": "Polygon", "coordinates": [[[-117.66702, 33.49792], [-117.66702, 33.49797], [-117.66682, 33.49806], [-117.66672, 33.49814], [-117.66665, 33.4983], [-117.66661, 33.49829], [-117.66673, 33.49802], [-117.6668, 33.49795], [-117.66702, 33.49792]]]} | Open Access 1 | 30270 | Arce Park | 15572 | 1305 | San Juan Capistrano, City of 92 | City 2 | City Agency 2 | http://www.sanjuancapistrano.org/ | City 2 | 1305 | San Juan Capistrano, City of 90 | City 2 | City Agency 2 | Orange 3 | 0.096 | Arce 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]);