units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
704 rows where DES_TP = 2 and MNG_AG_TYP = 4 sorted by COUNTY descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, AGNCY_TYP, LAYER, COUNTY, YR_EST
MNG_AGENCY >30
- East Bay Regional Park District 76
- Hayward Area Recreation and Park District 74
- Valley-Wide Recreation and Park District 57
- Rancho Simi Recreation and Park District 42
- Cordova Recreation and Park District 37
- Southgate Recreation and Park District 34
- Greater Vallejo Recreation and Park District 29
- Conejo Recreation and Park District 25
- Pleasant Valley Recreation and Park District 25
- Sunrise Recreation and Park District 25
- North of the River Recreation and Park District 24
- Jurupa Area Recreation and Park District 16
- Mission Oaks Recreation and Park District 14
- Isla Vista Recreation and Park District 12
- Apple Valley Recreation and Park District 10
- Carmichael Recreation and Park District 10
- North Highland Recreation and Park District 10
- Auburn Area Recreation and Park District 9
- Pleasant Hill Recreation and Park District 9
- Hesperia Recreation and Park District 9
- Monterey Peninsula Regional Park District 8
- Desert Recreation District 8
- Fair Oaks Recreation and Park District 8
- Livermore Area Recreation and Park District 7
- Rio Linda Elverta Recreation and Park District 7
- Big Bear Valley Recreation and Park District 7
- Feather River Recreation and Park District 6
- Boulder Creek Recreation and Park District 5
- Miraleste Recreation and Park District 5
- Orangevale Recreation and Park District 5
- …
ACCESS_TYP 3
- Open Access 659
- No Public Access 27
- Restricted Access 18
MNG_AG_TYP 1
- Recreation/Parks District · 704 ✖
DES_TP 1
- Local Park · 704 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
12164 | 12164 | 12163 | {"type": "Polygon", "coordinates": [[[-121.57235, 39.5091], [-121.57232, 39.51021], [-121.5721, 39.51116], [-121.5703, 39.51159], [-121.57, 39.51162], [-121.5697, 39.51107], [-121.56981, 39.51012], [-121.5711, 39.50968], [-121.57074, 39.50902], [-121.5718, 39.50875], [-121.57212, 39.5087], [-121.57235, 39.5091]]]} | Open Access 1 | 25366 | Bedrock Skate and Bike Park | 15949 | 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 | 12.245 | Bedrock Skate and Bike Park | 0 | Local Park 2 | 4 | |
13012 | 13012 | 13011 | {"type": "Polygon", "coordinates": [[[-121.5721, 39.51116], [-121.57193, 39.51195], [-121.57034, 39.51226], [-121.56889, 39.51275], [-121.56832, 39.51177], [-121.56887, 39.51153], [-121.56911, 39.51137], [-121.56929, 39.51122], [-121.56947, 39.51103], [-121.56958, 39.51087], [-121.56969, 39.51065], [-121.56977, 39.51042], [-121.5697, 39.51106], [-121.57, 39.51162], [-121.5703, 39.51159], [-121.5721, 39.51116]]]} | Open Access 1 | 34889 | Bedrock Park | 15948 | 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 | 7.784 | Bedrock Park | 0 | Local Park 2 | 4 | |
14992 | 14992 | 14991 | {"type": "Polygon", "coordinates": [[[-121.57861, 39.49796], [-121.57853, 39.50175], [-121.57834, 39.50322], [-121.57815, 39.50405], [-121.57796, 39.50474], [-121.57795, 39.50494], [-121.57799, 39.50511], [-121.57795, 39.50523], [-121.5779, 39.5057], [-121.57776, 39.50648], [-121.57774, 39.50738], [-121.57738, 39.50848], [-121.57706, 39.50917], [-121.57684, 39.50996], [-121.57635, 39.51038], [-121.57574, 39.51064], [-121.57462, 39.51089], [-121.57417, 39.51078], [-121.57293, 39.51125], [-121.57282, 39.51126], [-121.57286, 39.51091], [-121.57336, 39.50949], [-121.57364, 39.50904], [-121.57398, 39.50861], [-121.57384, 39.50836], [-121.57402, 39.50797], [-121.57534, 39.50747], [-121.5752, 39.50722], [-121.57431, 39.50753], [-121.57381, 39.50733], [-121.57379, 39.50664], [-121.57413, 39.50494], [-121.57528, 39.49966], [-121.5754, 39.49901], [-121.57552, 39.49814], [-121.57591, 39.49816], [-121.57618, 39.4981], [-121.57761, 39.49798], [-121.57861, 39.49796]]]} | Open Access 1 | 45638 | Riverbend Park | 28455 | 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 | http://frrpd.com/parks-facilities/parks/ | Butte 42 | 108.194 | Riverbend Park | 0 | Local Park 2 | 4 |
1044 | 1044 | 1043 | {"type": "Polygon", "coordinates": [[[-121.23855, 38.54734], [-121.23856, 38.54816], [-121.23852, 38.54822], [-121.23846, 38.54824], [-121.23795, 38.54825], [-121.23749, 38.54829], [-121.23743, 38.54783], [-121.23743, 38.54772], [-121.23747, 38.54761], [-121.23758, 38.54748], [-121.23769, 38.54741], [-121.23786, 38.54735], [-121.23855, 38.54734]]]} | Open Access 1 | 47582 | Eagle's Nest Park | 31309 | 2193 | Cordova Recreation and Park District 307 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.com/ | Special District 4 | 2193 | Cordova Recreation and Park District 304 | Special District 4 | Recreation/Parks District 4 | http://crpd.com/parks/eagles-nest-park/ | Sacramento 41 | 2.302 | Eagle's Nest 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]);