units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
17,068 rows
This data as json, copyable, CSV (advanced)
MNG_AG_TYP >30
- City Agency 8,107
- Recreation/Parks District 1,018
- State Agency 999
- County Agency 984
- Non Profit - Land Trust 512
- Federal Agency 419
- Open Space District 391
- Water District 213
- County Agency - Parks 208
- Home Owners Association 185
- Community Services District 178
- Non Profit - Conservation 133
- Flood District 97
- Non Profit - Other 42
- Irrigation District 39
- School District 35
- Cemetery District 33
- County Agency - Other 27
- Port/Harbor District 27
- Special District - Other 15
- Commercial 14
- Joint Powers Authority 7
- Sanitation District 6
- 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 417
- California Department of Fish and Wildlife 386
- Los Angeles, City of 379
- California Department of Parks and Recreation 332
- Mountains Recreation and Conservation Authority 319
- San Jose, City of 191
- Sacramento, City of 190
- San Francisco, City and County of 161
- East Bay Regional Park District 158
- Los Angeles, County of 139
- Ventura, City of 132
- Long Beach, City of 122
- Roseville, City of 120
- San Diego, County of 101
- Oakland, City of 100
- United States Bureau of Land Management 95
- Santa Barbara, County of 95
- Consumnes Community Services District 93
- United States Forest Service 88
- Napa, City of 80
- Orange, County of 77
- California State Lands Commission 76
- United States Fish and Wildlife Service 75
- United States National Park Service 72
- Irvine, City of 70
- Hayward Area Recreation and Park District 68
- Tracy, City of 65
- Valley-Wide Recreation and Park District 64
- Poway, City of 61
- Davis, City of 61
- …
DES_TP >30
- Local Park 7,033
- Local Recreation Area 1,723
- Local Other or Unknown 1,147
- Private Conservation 537
- Local Conservation Area 420
- State Conservation Area 341
- Private Recreation or Education 239
- State Park 182
- State Resource Management Area 136
- State Recreation Area 125
- National Forest 75
- Local Historic or Cultural Area 70
- National Wildlife Refuge 68
- State Other or Unknown 66
- State Historic or Cultural Area 58
- National Public Lands 53
- Recreation Management Area 51
- Private Other or Unknown 51
- National Monument or Landmark 36
- National Recreation Area 34
- National Park 22
- Local Resource Management Area 20
- Resource Management Area 19
- Federal Other or Unknown 18
- Conservation Area 12
- Private Agricultural 12
- Area of Critical Environmental Concern 7
- Wilderness Area 5
- Historic or Cultural Area 5
- Private Historic or Cultural 4
- …
ACCESS_TYP 4
- Open Access 11,447
- Restricted Access 1,062
- No Public Access 847
- Unknown Access 366
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3347 | 3347 | 3346 | {"type": "Polygon", "coordinates": [[[-119.78805, 36.73876], [-119.78766, 36.73903], [-119.78676, 36.73821], [-119.78714, 36.73794], [-119.78805, 36.73876]]]} | Open Access 1 | 24154 | Eaton Plaza | 18412 | 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 | 1.379 | Eaton Plaza | 0 | Local Park 2 | 4 | |
3348 | 3348 | 3347 | {"type": "Polygon", "coordinates": [[[-115.49341, 32.67129], [-115.49223, 32.6713], [-115.49224, 32.66997], [-115.4934, 32.66997], [-115.49341, 32.67129]]]} | Open Access 1 | 30419 | Rockwood Plaza Park | 24539 | 1451 | Calexico, City of 607 | City 2 | City Agency 2 | http://www.calexicorecreation.org/parks | City 2 | 1451 | Calexico, City of 596 | City 2 | City Agency 2 | Imperial 20 | 3.996 | Rockwood Plaza Park | 0 | Local Park 2 | 4 | |
3349 | 3349 | 3348 | {"type": "Polygon", "coordinates": [[[-122.3076, 40.57465], [-122.30296, 40.57463], [-122.30287, 40.5745], [-122.30289, 40.57104], [-122.3076, 40.57103], [-122.3076, 40.57465]]]} | Open Access 1 | 24175 | Redding Soccer Park | 24234 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 39.524 | Redding Soccer Park | 0 | Local Recreation Area 3 | 4 | |
3350 | 3350 | 3349 | {"type": "Polygon", "coordinates": [[[-122.34575, 40.54282], [-122.34573, 40.54285], [-122.34569, 40.54286], [-122.34439, 40.54287], [-122.34439, 40.54227], [-122.34449, 40.54203], [-122.34575, 40.54202], [-122.34575, 40.54282]]]} | Open Access 1 | 24178 | East Oak Park | 18378 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 2.637 | East Oak Park | 0 | Local Park 2 | 4 | |
3351 | 3351 | 3350 | {"type": "Polygon", "coordinates": [[[-121.63593, 39.77761], [-121.63218, 39.77763], [-121.63219, 39.77495], [-121.63309, 39.77382], [-121.63173, 39.7738], [-121.63278, 39.77294], [-121.63294, 39.77294], [-121.63295, 39.7728], [-121.63365, 39.77224], [-121.63365, 39.77252], [-121.63359, 39.77253], [-121.63359, 39.77266], [-121.63317, 39.77267], [-121.63316, 39.77272], [-121.63305, 39.77273], [-121.63306, 39.77308], [-121.63589, 39.77309], [-121.63593, 39.77761]]]} | Open Access 1 | 24231 | Bill Park Expansion | 16108 | 2250 | Paradise Recreation and Park District 580 | Special District 4 | Recreation/Parks District 4 | http://www.paradiseprpd.com/ | Special District 4 | 2250 | Paradise Recreation and Park District 572 | Special District 4 | Recreation/Parks District 4 | Butte 42 | 38.925 | Bill Park Expansion | None 273 | |||
3352 | 3352 | 3351 | {"type": "Polygon", "coordinates": [[[-124.10338, 40.95518], [-124.10286, 40.95518], [-124.10286, 40.95491], [-124.10338, 40.95491], [-124.10338, 40.95518]]]} | Open Access 1 | 24241 | Larissa Park | 21027 | 2238 | McKinleyville Community Services District 624 | Special District 4 | Community Services District 19 | http://mckinleyvillecsd.com/ | Special District 4 | 2238 | McKinleyville Community Services District 613 | Special District 4 | Community Services District 17 | Humboldt 45 | 0.324 | Larissa Park | 0 | Local Park 2 | 4 | |
3353 | 3353 | 3352 | {"type": "Polygon", "coordinates": [[[-120.03475, 39.23713], [-120.03474, 39.23761], [-120.03371, 39.23746], [-120.0337, 39.23752], [-120.03184, 39.23717], [-120.03128, 39.23711], [-120.03013, 39.23705], [-120.02969, 39.23699], [-120.0297, 39.23614], [-120.03008, 39.23624], [-120.03036, 39.23635], [-120.03066, 39.23644], [-120.03163, 39.23669], [-120.0319, 39.23672], [-120.03226, 39.23667], [-120.03256, 39.23669], [-120.0329, 39.23677], [-120.03475, 39.23713]]]} | Open Access 1 | 24255 | Secline Beach | 25276 | 2246 | North Tahoe Public Utilities District 625 | Special District 4 | Water District 13 | http://www.ntpud.org/ | Special District 4 | 2246 | North Tahoe Public Utilities District 614 | Special District 4 | Water District 13 | Placer 35 | 7.066 | Secline Beach | 0 | Local Park 2 | 4 | |
3354 | 3354 | 3353 | {"type": "Polygon", "coordinates": [[[-116.37238, 33.73512], [-116.37237, 33.73598], [-116.36947, 33.73599], [-116.36946, 33.73575], [-116.36891, 33.73575], [-116.36891, 33.73476], [-116.36946, 33.73476], [-116.36947, 33.73463], [-116.37125, 33.73473], [-116.37126, 33.73447], [-116.37196, 33.73446], [-116.37197, 33.73511], [-116.37238, 33.73512]]]} | Open Access 1 | 24270 | Magnesia Falls City Park | 21671 | 1240 | Palm Desert, City of 215 | City 2 | City Agency 2 | http://www.cityofpalmdesert.org/Index.aspx?page=174 | City 2 | 2216 | Desert Recreation District 282 | Special District 4 | Recreation/Parks District 4 | Riverside 10 | 10.941 | Magnesia Falls City Park | 0 | Local Park 2 | 4 | |
3355 | 3355 | 3354 | {"type": "Polygon", "coordinates": [[[-116.36064, 33.7325], [-116.36064, 33.73492], [-116.35884, 33.73445], [-116.35656, 33.73376], [-116.35647, 33.73315], [-116.35647, 33.73251], [-116.36064, 33.7325]]]} | Open Access 1 | 24277 | Cook Fields Sports Complex | 17615 | 2216 | Desert Recreation District 286 | Special District 4 | Recreation/Parks District 4 | http://www.myrecreationdistrict.com | Special District 4 | 2216 | Desert Recreation District 282 | Special District 4 | Recreation/Parks District 4 | Riverside 10 | 19.46 | Cook Fields Sports Complex | 0 | Local Recreation Area 3 | 4 | |
3356 | 3356 | 3355 | {"type": "Polygon", "coordinates": [[[-121.33164, 38.90965], [-121.33137, 38.90972], [-121.33102, 38.90984], [-121.33074, 38.90939], [-121.33134, 38.90917], [-121.33164, 38.90965]]]} | Open Access 1 | 48731 | Brown Park | 33459 | 1175 | Lincoln, City of 608 | City 2 | City Agency 2 | http://www.ci.lincoln.ca.us/default.aspx?Jpage=41500 | City 2 | 1175 | Lincoln, City of 597 | City 2 | City Agency 2 | http://www.lincolnca.gov/city-hall/departments-divisions/parks-and-recreation | Placer 35 | 0.811 | Brown Park | 0 | Local Park 2 | 4 |
3357 | 3357 | 3356 | {"type": "Polygon", "coordinates": [[[-116.38229, 33.73105], [-116.38228, 33.73588], [-116.38227, 33.73591], [-116.38222, 33.73594], [-116.38222, 33.73608], [-116.3784, 33.73609], [-116.3784, 33.73058], [-116.37927, 33.73059], [-116.37961, 33.7303], [-116.37961, 33.73014], [-116.38057, 33.73015], [-116.38145, 33.73079], [-116.38146, 33.73105], [-116.38229, 33.73105]]]} | Open Access 1 | 24262 | Palm Desert Civic Center Park | 23336 | 2216 | Desert Recreation District 286 | Special District 4 | Recreation/Parks District 4 | http://www.myrecreationdistrict.com | Special District 4 | 2216 | Desert Recreation District 282 | Special District 4 | Recreation/Parks District 4 | Riverside 10 | 54.826 | Palm Desert Civic Ctr. Park | 0 | Local Park 2 | 4 | |
3358 | 3358 | 3357 | {"type": "Polygon", "coordinates": [[[-116.07594, 33.57297], [-116.07593, 33.5744], [-116.0754, 33.57439], [-116.07538, 33.57444], [-116.07467, 33.57442], [-116.07467, 33.573], [-116.07472, 33.57296], [-116.07594, 33.57297]]]} | Open Access 1 | 24269 | Mecca Community Center and Park | 22102 | 2216 | Desert Recreation District 286 | Special District 4 | Recreation/Parks District 4 | http://www.myrecreationdistrict.com | Special District 4 | 2216 | Desert Recreation District 282 | Special District 4 | Recreation/Parks District 4 | Riverside 10 | 4.682 | Mecca Community Ctr. and Park | 0 | Local Recreation Area 3 | 4 | |
3359 | 3359 | 3358 | {"type": "Polygon", "coordinates": [[[-122.08953, 37.41652], [-122.08961, 37.41709], [-122.0896, 37.41713], [-122.08952, 37.41717], [-122.0891, 37.41714], [-122.089, 37.41649], [-122.08953, 37.41652]]]} | Open Access 1 | 48654 | Sierra Vista Park | 33401 | 1218 | Mountain View, City of 460 | City 2 | City Agency 2 | http://www.ci.mtnview.ca.us/services/parks/default.asp | City 2 | 1218 | Mountain View, City of 453 | City 2 | City Agency 2 | https://www.mountainview.gov/depts/cs/parks/parks/city_parks.asp | Santa Clara 19 | 0.813 | Sierra Vista Park | 0 | Local Park 2 | 4 |
3360 | 3360 | 3359 | {"type": "MultiPolygon", "coordinates": [[[[-117.65114, 34.06938], [-117.65086, 34.06937], [-117.65085, 34.0683], [-117.65111, 34.0683], [-117.65114, 34.06938]]], [[[-117.65112, 34.06348], [-117.65109, 34.06452], [-117.65086, 34.06452], [-117.65085, 34.06346], [-117.65112, 34.06348]]], [[[-117.65112, 34.07054], [-117.65086, 34.07054], [-117.65086, 34.06952], [-117.65112, 34.06952], [-117.65112, 34.07054]]], [[[-117.65109, 34.06468], [-117.65109, 34.06571], [-117.65087, 34.06572], [-117.65086, 34.06468], [-117.65109, 34.06468]]], [[[-117.65114, 34.07239], [-117.65088, 34.07239], [-117.65086, 34.07077], [-117.65114, 34.07078], [-117.65114, 34.07239]]], [[[-117.65111, 34.06589], [-117.6511, 34.06695], [-117.65088, 34.06695], [-117.65087, 34.06589], [-117.65111, 34.06589]]], [[[-117.65111, 34.06815], [-117.65088, 34.06815], [-117.65088, 34.06711], [-117.6511, 34.06711], [-117.65111, 34.06815]]], [[[-117.65115, 34.07255], [-117.65114, 34.07422], [-117.65089, 34.07421], [-117.65088, 34.07254], [-117.65115, 34.07255]]], [[[-117.65116, 34.07438], [-117.65114, 34.07603], [-117.6509, 34.07603], [-117.65089, 34.07438], [-117.65116, 34.07438]]], [[[-117.65116, 34.0762], [-117.65114, 34.07783], [-117.65091, 34.07784], [-117.6509, 34.07619], [-117.65116, 34.0762]]], [[[-117.65119, 34.08148], [-117.65093, 34.08148], [-117.65091, 34.07801], [-117.65116, 34.07801], [-117.65118, 34.07932], [-117.65117, 34.0804], [-117.65119, 34.08148]]], [[[-117.65119, 34.08512], [-117.65096, 34.08512], [-117.65093, 34.08165], [-117.65117, 34.08165], [-117.65119, 34.0826], [-117.65118, 34.08395], [-117.65119, 34.08512]]], [[[-117.65122, 34.08529], [-117.65118, 34.0869], [-117.65099, 34.08694], [-117.65096, 34.08529], [-117.65122, 34.08529]]]]} | Open Access 1 | 20586 | Euclid Avenue Parkway | 18744 | 1232 | Ontario, City of 126 | City 2 | City Agency 2 | http://www.ci.ontario.ca.us/index.aspx?page=456 | City 2 | 1232 | Ontario, City of 123 | City 2 | City Agency 2 | San Bernardino 22 | 13.425 | Euclid Avenue Parkway | 0 | Local Recreation Area 3 | 4 | |
3361 | 3361 | 3360 | {"type": "Polygon", "coordinates": [[[-116.94595, 34.2707], [-116.94595, 34.27072], [-116.94563, 34.27071], [-116.94562, 34.27077], [-116.94497, 34.27093], [-116.94464, 34.27093], [-116.94464, 34.27032], [-116.94497, 34.27032], [-116.94562, 34.2706], [-116.94562, 34.27069], [-116.94595, 34.2707]]]} | Open Access 1 | 24294 | Miller Park | 22245 | 2207 | Big Bear Valley Recreation and Park District 626 | Special District 4 | Recreation/Parks District 4 | http://bigbearparks.com/ | Special District 4 | 2207 | Big Bear Valley Recreation and Park District 615 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 1.155 | Miller Park | 0 | Local Park 2 | 4 | |
3362 | 3362 | 3361 | {"type": "Polygon", "coordinates": [[[-116.30843, 34.14128], [-116.30425, 34.14132], [-116.30424, 34.13951], [-116.30642, 34.1395], [-116.30643, 34.13956], [-116.30842, 34.13955], [-116.30843, 34.14128]]]} | Open Access 1 | 24295 | Sunburst Park | 25986 | 2230 | Joshua Tree Park and Recreation District 627 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2230 | Joshua Tree Park and Recreation District 616 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 18.753 | Sunburst Park | 0 | Local Park 2 | 4 | ||
3363 | 3363 | 3362 | {"type": "Polygon", "coordinates": [[[-120.1891, 39.3279], [-120.18813, 39.32838], [-120.18792, 39.32815], [-120.1889, 39.32764], [-120.1891, 39.3279]]]} | Open Access 1 | 24338 | Veterans Hall | 27021 | 2263 | Truckee-Donner Recreation and Park District 576 | Special District 4 | Recreation/Parks District 4 | http://www.tdrpd.com/ | Special District 4 | 2263 | Truckee-Donner Recreation and Park District 568 | Special District 4 | Recreation/Parks District 4 | Nevada 30 | 0.806 | Veterans Hall | None 274 | |||
3364 | 3364 | 3363 | {"type": "Polygon", "coordinates": [[[-122.06821, 37.96242], [-122.06779, 37.96243], [-122.06778, 37.96239], [-122.06715, 37.9624], [-122.06651, 37.96247], [-122.06646, 37.96233], [-122.06626, 37.96208], [-122.06625, 37.96193], [-122.06635, 37.96168], [-122.06738, 37.96154], [-122.06818, 37.96148], [-122.06821, 37.96242]]]} | Open Access 1 | 31033 | Pleasant Hill Community Center / Frank Salfingere Park | 23794 | 2112 | Pleasant Hill Recreation and Park District 466 | Special District 4 | Recreation/Parks District 4 | http://www.pleasanthillrec.com | Special District 4 | 2112 | Pleasant Hill Recreation and Park District 459 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 3.829 | Pleasant Hill Community Ctr. / Frank Salfingere Park | 0 | Local Recreation Area 3 | 4 | |
3365 | 3365 | 3364 | {"type": "Polygon", "coordinates": [[[-122.30317, 41.32335], [-122.2975, 41.32334], [-122.29751, 41.31982], [-122.30223, 41.31983], [-122.30222, 41.32021], [-122.30219, 41.32031], [-122.30215, 41.32037], [-122.30207, 41.32043], [-122.30199, 41.32048], [-122.30174, 41.32056], [-122.30317, 41.32335]]]} | Open Access 1 | 24314 | Shastice Park | 25372 | 2244 | Mt. Shasta Recreation and Park District 628 | Special District 4 | Recreation/Parks District 4 | http://www.msrec.org/ | Special District 4 | 2244 | Mt. Shasta Recreation and Park District 617 | Special District 4 | Recreation/Parks District 4 | Siskiyou 28 | 39.545 | Shastice Park | 0 | Local Park 2 | 4 | |
3366 | 3366 | 3365 | {"type": "Polygon", "coordinates": [[[-123.02007, 38.4736], [-123.01905, 38.47432], [-123.01973, 38.47494], [-123.019, 38.4755], [-123.01754, 38.47486], [-123.01736, 38.47459], [-123.01653, 38.47281], [-123.0177, 38.47143], [-123.01778, 38.47153], [-123.02007, 38.4736]]]} | Open Access 1 | 24315 | Monte Rio Riverfront Meadow | 22391 | 2241 | Monte Rio Recreation and Park District 573 | Special District 4 | Recreation/Parks District 4 | http://www.mrrpd.org/ | Special District 4 | 2241 | Monte Rio Recreation and Park District 565 | Special District 4 | Recreation/Parks District 4 | Sonoma 16 | 18.497 | Monte Rio Riverfront Meadow | None 275 |
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]);