units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,162 rows where MNG_AG_TYP = 4 sorted by COUNTY descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, AGNCY_TYP, LAYER, GAP_STS
MNG_AGENCY >30
- East Bay Regional Park District 167
- Hayward Area Recreation and Park District 84
- Valley-Wide Recreation and Park District 67
- Rancho Simi Recreation and Park District 54
- Midpeninsula Regional Open Space District 51
- Conejo Recreation and Park District 50
- Marin County Open Space District 41
- Southgate Recreation and Park District 41
- Sunrise Recreation and Park District 39
- Cordova Recreation and Park District 38
- Greater Vallejo Recreation and Park District 33
- Pleasant Valley Recreation and Park District 31
- North of the River Recreation and Park District 27
- Monterey Peninsula Regional Park District 25
- Santa Clara Valley Open Space Authority 25
- Sonoma County Agricultural Preservation and Open Space District 21
- Isla Vista Recreation and Park District 18
- Jurupa Area Recreation and Park District 18
- Desert Recreation District 15
- Mission Oaks Recreation and Park District 14
- Apple Valley Recreation and Park District 13
- Livermore Area Recreation and Park District 13
- Pleasant Hill Recreation and Park District 12
- Carmichael Recreation and Park District 12
- Auburn Area Recreation and Park District 11
- Hesperia Recreation and Park District 11
- North Highland Recreation and Park District 11
- Napa County Regional Park and Open Space District 10
- Miraleste Recreation and Park District 10
- Rio Linda Elverta Recreation and Park District 9
- …
DES_TP >30
- Local Park 704
- Local Conservation Area 172
- Local Recreation Area 164
- Local Other or Unknown 28
- Local Historic or Cultural Area 3
- Local Resource Management Area 2
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
ACCESS_TYP 4
- Open Access 991
- No Public Access 106
- Restricted Access 64
- Unknown Access 1
MNG_AG_TYP 1
- Recreation/Parks District · 1,162 ✖
MNG_AG_LEV 1 ✖
- Special District 1,162
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6713 | 6713 | 6712 | {"type": "Polygon", "coordinates": [[[-121.2326, 40.30976], [-121.23197, 40.31049], [-121.23162, 40.31034], [-121.23162, 40.31029], [-121.23127, 40.31012], [-121.23133, 40.31004], [-121.23107, 40.30991], [-121.23167, 40.30916], [-121.23253, 40.30955], [-121.2326, 40.30976]]]} | Open Access 1 | 48415 | Truman Collins Sports Complex | 33012 | 7030 | Collins Pine Company 841 | Private 7 | Commericial 30 | http://www.collinsco.com/ | Private 14 | 2427 | Almanor Recreation and Park District 818 | Special District 4 | Recreation/Parks District 4 | https://ceqanet.opr.ca.gov/2003038103 | Plumas 57 | 2.653 | Truman Collins Sports Complex | 0 | Local Recreation Area 3 | 4 |
13057 | 13057 | 13056 | {"type": "Polygon", "coordinates": [[[-120.9148, 39.9354], [-120.9148, 39.93622], [-120.9137, 39.93646], [-120.91324, 39.93647], [-120.91323, 39.93607], [-120.91348, 39.93605], [-120.91349, 39.9354], [-120.9148, 39.9354]]]} | Open Access 1 | 34915 | Pioneer Park | 23738 | 2293 | Central Plumas Recreation and Parks District 1041 | Special District 4 | Recreation/Parks District 4 | http://users.psln.com/recdept/ | Special District 4 | 2293 | Central Plumas Recreation and Parks District 1003 | Special District 4 | Recreation/Parks District 4 | Plumas 57 | 3.207 | Pioneer Park | 0 | Local Park 2 | 4 | |
4393 | 4393 | 4392 | {"type": "Polygon", "coordinates": [[[-120.83931, 38.1912], [-120.83922, 38.19286], [-120.83482, 38.19289], [-120.83569, 38.19181], [-120.83506, 38.19149], [-120.8353, 38.19115], [-120.83468, 38.19085], [-120.83452, 38.18937], [-120.83931, 38.1912]]]} | Open Access 1 | 48599 | Valley Springs Memorial Park | 33311 | 2431 | Jenny Lind Veterans Memorial District 757 | Special District 4 | Recreation/Parks District 4 | https://jlvmd.specialdistrict.org/ | Special District 4 | 2431 | Jenny Lind Veterans Memorial District 742 | Special District 4 | Recreation/Parks District 4 | Calaveras 53 | 25.966 | Valley Springs Memorial Park | 0 | Local Park 2 | 4 | |
14300 | 14300 | 14299 | {"type": "Polygon", "coordinates": [[[-120.67776, 38.19598], [-120.67773, 38.19625], [-120.6773, 38.1967], [-120.67696, 38.19652], [-120.67709, 38.19637], [-120.67705, 38.19633], [-120.67709, 38.19629], [-120.67679, 38.19615], [-120.67673, 38.19622], [-120.67652, 38.19613], [-120.67628, 38.19594], [-120.67581, 38.19539], [-120.67607, 38.19531], [-120.6771, 38.19587], [-120.67776, 38.19598]]]} | Open Access 1 | 44233 | Gerald Turner Park | 19277 | 2257 | San Andreas Recreation and Park District 1107 | Special District 4 | Recreation/Parks District 4 | http://sanandreasmerchants.com/SARP.htm | Special District 4 | 2257 | San Andreas Recreation and Park District 1061 | Special District 4 | Recreation/Parks District 4 | Calaveras 53 | 2.323 | Gerald Turner Park | 0 | Local Park 2 | 4 | |
9693 | 9693 | 9692 | {"type": "Polygon", "coordinates": [[[-122.06313, 39.01813], [-122.06254, 39.01813], [-122.06198, 39.01814], [-122.06199, 39.01614], [-122.06312, 39.01613], [-122.06313, 39.01813]]]} | Open Access 1 | 16378 | Ball Four Park | 15784 | 2301 | Arbuckle Parks and Recreation District 918 | Special District 4 | Recreation/Parks District 4 | http://arbuckleparksandrecreation.org/ | Special District 4 | 2301 | Arbuckle Parks and Recreation District 891 | Special District 4 | Recreation/Parks District 4 | Colusa 49 | 5.419 | Ball Four Park | 0 | Local Park 2 | 4 | |
9700 | 9700 | 9699 | {"type": "Polygon", "coordinates": [[[-122.05603, 39.01389], [-122.05597, 39.01392], [-122.05585, 39.01392], [-122.05572, 39.01383], [-122.05561, 39.01382], [-122.05544, 39.01383], [-122.05532, 39.01386], [-122.05523, 39.01386], [-122.05508, 39.01374], [-122.05489, 39.01354], [-122.05489, 39.01349], [-122.05495, 39.01341], [-122.05503, 39.01336], [-122.05516, 39.01332], [-122.05603, 39.01389]]]} | Open Access 1 | 16386 | Wee Park | 27329 | 2301 | Arbuckle Parks and Recreation District 918 | Special District 4 | Recreation/Parks District 4 | http://arbuckleparksandrecreation.org/ | Special District 4 | 2301 | Arbuckle Parks and Recreation District 891 | Special District 4 | Recreation/Parks District 4 | Colusa 49 | 0.721 | Wee Park | 0 | Local Park 2 | 4 | |
9704 | 9704 | 9703 | {"type": "Polygon", "coordinates": [[[-122.05725, 39.01739], [-122.05695, 39.0175], [-122.05674, 39.01718], [-122.05702, 39.01706], [-122.05725, 39.01739]]]} | Open Access 1 | 16403 | Memorial Park | 22144 | 2301 | Arbuckle Parks and Recreation District 918 | Special District 4 | Recreation/Parks District 4 | http://arbuckleparksandrecreation.org/ | Special District 4 | 2301 | Arbuckle Parks and Recreation District 891 | Special District 4 | Recreation/Parks District 4 | Colusa 49 | 0.288 | Memorial Park | 0 | Local Park 2 | 4 | |
9705 | 9705 | 9704 | {"type": "Polygon", "coordinates": [[[-122.05765, 39.01799], [-122.05714, 39.01819], [-122.05681, 39.01768], [-122.05734, 39.01751], [-122.05765, 39.01799]]]} | Open Access 1 | 16415 | LaVanche Hursh Park | 21111 | 2301 | Arbuckle Parks and Recreation District 918 | Special District 4 | Recreation/Parks District 4 | http://arbuckleparksandrecreation.org/ | Special District 4 | 2301 | Arbuckle Parks and Recreation District 891 | Special District 4 | Recreation/Parks District 4 | Colusa 49 | 0.742 | LaVanche Hursh Park | 0 | Local Park 2 | 4 | |
12513 | 12513 | 12512 | {"type": "MultiPolygon", "coordinates": [[[[-122.93343, 40.73163], [-122.9323, 40.73359], [-122.93176, 40.73341], [-122.93176, 40.73338], [-122.93091, 40.7331], [-122.9326, 40.73087], [-122.93343, 40.73163]]], [[[-122.93437, 40.73252], [-122.93407, 40.73292], [-122.93381, 40.73307], [-122.93202, 40.73461], [-122.9336, 40.73179], [-122.93437, 40.73252]]], [[[-122.93533, 40.73097], [-122.93427, 40.73164], [-122.93381, 40.73174], [-122.93267, 40.73065], [-122.93331, 40.72906], [-122.93533, 40.73097]]]]} | Open Access 1 | 28346 | Lowden Park | 21553 | 2291 | Weaverville - Douglas City Recreation District 1029 | Special District 4 | Recreation/Parks District 4 | http://users.snowcrest.net/wb6fzh/wdcrec1.html | Special District 4 | 2291 | Weaverville - Douglas City Recreation District 990 | Special District 4 | Recreation/Parks District 4 | Trinity 46 | 19.77 | Lowden Park | 0 | Local Park 2 | 4 | |
13051 | 13051 | 13050 | {"type": "Polygon", "coordinates": [[[-122.94177, 40.72821], [-122.94151, 40.72819], [-122.94149, 40.7283], [-122.94128, 40.72831], [-122.94131, 40.72874], [-122.94163, 40.72872], [-122.9416, 40.72885], [-122.94116, 40.72888], [-122.94119, 40.72877], [-122.9411, 40.72876], [-122.94092, 40.72921], [-122.9408, 40.72982], [-122.94029, 40.72976], [-122.94021, 40.72913], [-122.94066, 40.72875], [-122.94065, 40.72874], [-122.94056, 40.72876], [-122.94014, 40.72876], [-122.94023, 40.72855], [-122.94015, 40.72816], [-122.94021, 40.72776], [-122.94034, 40.72761], [-122.9404, 40.7271], [-122.94039, 40.7268], [-122.94031, 40.72663], [-122.94038, 40.7264], [-122.94029, 40.72554], [-122.94031, 40.72524], [-122.94067, 40.72524], [-122.94067, 40.72468], [-122.94126, 40.72468], [-122.94127, 40.72583], [-122.94163, 40.72584], [-122.94165, 40.72752], [-122.94177, 40.72821]]]} | Open Access 1 | 34903 | Lee Fong Park | 21132 | 2291 | Weaverville - Douglas City Recreation District 1029 | Special District 4 | Recreation/Parks District 4 | http://users.snowcrest.net/wb6fzh/wdcrec1.html | Special District 4 | 2291 | Weaverville - Douglas City Recreation District 990 | Special District 4 | Recreation/Parks District 4 | Trinity 46 | 12.516 | Lee Fong Park | 0 | Local Park 2 | 4 | |
1045 | 1045 | 1044 | {"type": "Polygon", "coordinates": [[[-121.54516, 39.43302], [-121.54378, 39.43304], [-121.54377, 39.43221], [-121.54515, 39.4322], [-121.54516, 39.43302]]]} | Open Access 1 | 47583 | Palermo Park | 31310 | 2222 | Feather River Recreation and Park District 308 | Special District 4 | Recreation/Parks District 4 | http://www.frrpd.com/ | Special District 4 | 2222 | Feather River Recreation and Park District 305 | Special District 4 | Recreation/Parks District 4 | Butte 42 | 2.687 | Palermo Park | 0 | Local Park 2 | 4 | |
2199 | 2199 | 2198 | {"type": "Polygon", "coordinates": [[[-121.96127, 39.73954], [-121.9611, 39.73965], [-121.96071, 39.73926], [-121.96055, 39.73914], [-121.96029, 39.73899], [-121.96006, 39.7389], [-121.95966, 39.73877], [-121.9598, 39.73858], [-121.95991, 39.73863], [-121.96007, 39.73873], [-121.96046, 39.73889], [-121.96064, 39.73894], [-121.96089, 39.73915], [-121.96127, 39.73954]]]} | Open Access 1 | 16471 | Chico Area Recreation & Park District | 17191 | 2017 | Chico Area Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | http://www.chicorec.com/ | Special District 4 | 2017 | Chico Area Recreation and Park District 485 | Special District 4 | Recreation/Parks District 4 | Butte 42 | 0.797 | Chico Area Rec. & Park District | 0 | Local Recreation Area 3 | 4 | |
3093 | 3093 | 3092 | {"type": "MultiPolygon", "coordinates": [[[[-121.61374, 39.74863], [-121.61373, 39.74885], [-121.61371, 39.74895], [-121.61363, 39.74907], [-121.61353, 39.74918], [-121.61292, 39.74964], [-121.6125, 39.74964], [-121.61251, 39.74863], [-121.61374, 39.74863]]], [[[-121.61484, 39.74863], [-121.61482, 39.74964], [-121.61323, 39.74964], [-121.61369, 39.74929], [-121.61384, 39.74913], [-121.6139, 39.74902], [-121.61393, 39.74892], [-121.61395, 39.74863], [-121.61484, 39.74863]]]]} | Open Access 1 | 25178 | Aquatic Park | 15549 | 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 | 4.914 | Aquatic 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 | |||
3666 | 3666 | 3665 | {"type": "Polygon", "coordinates": [[[-121.57867, 39.52781], [-121.5776, 39.52782], [-121.5776, 39.52519], [-121.57866, 39.5252], [-121.57867, 39.52781]]]} | Open Access 1 | 44171 | Nelson Park | 22699 | 2222 | Feather River Recreation and Park District 308 | Special District 4 | Recreation/Parks District 4 | http://www.frrpd.com/ | Special District 4 | 2222 | Feather River Recreation and Park District 305 | Special District 4 | Recreation/Parks District 4 | Butte 42 | 6.584 | Nelson Park | 0 | Local Park 2 | 4 | |
5553 | 5553 | 5552 | {"type": "Polygon", "coordinates": [[[-121.54112, 39.50039], [-121.54006, 39.50042], [-121.54009, 39.49801], [-121.54107, 39.49799], [-121.54112, 39.50039]]]} | Open Access 1 | 44167 | Martin Luther King Jr. Park | 21916 | 2222 | Feather River Recreation and Park District 308 | Special District 4 | Recreation/Parks District 4 | http://www.frrpd.com/ | Special District 4 | 2222 | Feather River Recreation and Park District 305 | Special District 4 | Recreation/Parks District 4 | Butte 42 | 5.81 | Martin Luther King Jr. Park | 0 | Local Park 2 | 4 | |
9622 | 9622 | 9621 | {"type": "Polygon", "coordinates": [[[-121.63305, 39.77263], [-121.63295, 39.77264], [-121.63295, 39.77294], [-121.63122, 39.77294], [-121.63122, 39.7705], [-121.63303, 39.77051], [-121.63305, 39.77263]]]} | Open Access 1 | 16475 | Bille Park | 16114 | 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 | 10.366 | Bille Park | 0 | Local Park 2 | 4 | |
9731 | 9731 | 9730 | {"type": "Polygon", "coordinates": [[[-121.59294, 39.786], [-121.59259, 39.78655], [-121.59161, 39.78859], [-121.58893, 39.7886], [-121.58894, 39.78601], [-121.59294, 39.786]]]} | Open Access 1 | 16480 | Moore Road Park | 22462 | 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 | 20.103 | Moore Road Park | 0 | Local Park 2 | 4 | |
11381 | 11381 | 11380 | {"type": "Polygon", "coordinates": [[[-121.51191, 39.7646], [-121.51174, 39.76803], [-121.51098, 39.76804], [-121.51097, 39.7663], [-121.51115, 39.7646], [-121.51191, 39.7646]]]} | Open Access 1 | 28145 | Crain Memorial Park | 17753 | 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 | 6.572 | Crain Memorial Park | 0 | Local Park 2 | 4 | |
11847 | 11847 | 11846 | {"type": "Polygon", "coordinates": [[[-121.62355, 39.75978], [-121.62353, 39.75986], [-121.62305, 39.7606], [-121.62223, 39.76218], [-121.62185, 39.76218], [-121.62186, 39.76168], [-121.62184, 39.75954], [-121.62328, 39.75953], [-121.62339, 39.75957], [-121.62347, 39.75962], [-121.62353, 39.7597], [-121.62355, 39.75978]]]} | Open Access 1 | 24232 | Terry Ashe Recreation Center | 26267 | 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 | 6.683 | Terry Ashe Rec. 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]);