units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
17 rows where COUNTY = 42 and MNG_AG_TYP = 4
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_WEB
MNG_AGENCY 4
DES_TP 3
- Local Park 10
- Local Recreation Area 6
- None 1
MNG_AG_TYP 1
- Recreation/Parks District · 17 ✖
ACCESS_TYP 1
- Open Access 17
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
13472 | 13472 | 13471 | {"type": "Polygon", "coordinates": [[[-121.80194, 39.64878], [-121.80091, 39.64895], [-121.80036, 39.64752], [-121.80032, 39.64731], [-121.80034, 39.64725], [-121.80107, 39.64708], [-121.80118, 39.64737], [-121.80146, 39.6475], [-121.80194, 39.64878]]]} | Open Access 1 | 35731 | Durham Recreation and Park District 1 | 18313 | 2030 | Durham Recreation and Park District 1060 | Special District 4 | Recreation/Parks District 4 | http://www.durhamrec.com/ | Special District 4 | 2030 | Durham Recreation and Park District 1018 | Special District 4 | Recreation/Parks District 4 | Butte 42 | 4.222 | Durham Rec. and Park District 1 | 0 | Local Recreation Area 3 | 4 | |
13473 | 13473 | 13472 | {"type": "Polygon", "coordinates": [[[-121.77925, 39.64587], [-121.77474, 39.646], [-121.77471, 39.64458], [-121.77478, 39.64455], [-121.77507, 39.64437], [-121.77532, 39.64415], [-121.77556, 39.64373], [-121.77523, 39.64316], [-121.77663, 39.64268], [-121.77925, 39.64587]]]} | Open Access 1 | 35730 | Durham Recreation and Park District 2 | 18314 | 2030 | Durham Recreation and Park District 1060 | Special District 4 | Recreation/Parks District 4 | http://www.durhamrec.com/ | Special District 4 | 2030 | Durham Recreation and Park District 1018 | Special District 4 | Recreation/Parks District 4 | Butte 42 | 21.557 | Durham Rec. and Park District 2 | 0 | Local Recreation Area 3 | 4 | |
14259 | 14259 | 14258 | {"type": "Polygon", "coordinates": [[[-121.56479, 39.50685], [-121.56272, 39.50759], [-121.56253, 39.50729], [-121.56238, 39.5069], [-121.56237, 39.50689], [-121.56217, 39.50605], [-121.56211, 39.50606], [-121.56203, 39.50564], [-121.5629, 39.50536], [-121.56365, 39.50509], [-121.56378, 39.50507], [-121.56451, 39.50482], [-121.56449, 39.505], [-121.5645, 39.50577], [-121.56479, 39.50685]]]} | Open Access 1 | 44178 | Mitchell Field | 22323 | 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 | 11.461 | Mitchell Field | 0 | Local Recreation Area 3 | 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 |
16829 | 16829 | 16828 | {"type": "Polygon", "coordinates": [[[-121.76741, 39.55063], [-121.76703, 39.55071], [-121.76672, 39.54986], [-121.76666, 39.54986], [-121.76665, 39.54988], [-121.76696, 39.55072], [-121.76658, 39.55081], [-121.76622, 39.54984], [-121.76705, 39.54966], [-121.76741, 39.55063]]]} | Open Access 1 | 35629 | Durham Recreation and Park District 3 | 18315 | 2030 | Durham Recreation and Park District 1060 | Special District 4 | Recreation/Parks District 4 | http://www.durhamrec.com/ | Special District 4 | 2030 | Durham Recreation and Park District 1018 | Special District 4 | Recreation/Parks District 4 | Butte 42 | 1.89 | Durham Rec. and Park District 3 | 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]);