superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
43 rows where MNG_AGENCY = 424 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: LABEL_NAME
PARK_NAME 42 ✖
- Little Chico Creek Greenway 2
- 20th Street Park 1
- Baroni Neighborhood Park 1
- Belgium Avenue Mini Park 1
- Bidwell Park 1
- Bidwell Ranch Preserve 1
- Big Chico Creek Greenway 1
- Chico Eastside Little League Park 1
- Children's Park 1
- City Designated Open Space 1
- City Skate Park 1
- Comanche Creek Greenway 1
- DeGarmo Park 1
- Depot Park 1
- Eaton Road Preserve 1
- Enloe Park 1
- Fair Street Detention Ponds 1
- Foothill Preserve 1
- Hancock Park 1
- Henshaw Park 1
- Highlands Park 1
- Hillview Preserve 1
- Hooker Oak Park 1
- Humboldt Neighborhood Park 1
- Johnson Neighborhood Center 1
- Junction Park 1
- Lindo Channel 1
- Meriam Park Preserve 1
- Nob Hill Park 1
- Norte Dame Blvd Park 1
- Oak Way Park 1
- Peterson Park 1
- Plaza Park 1
- Preserve Areas 1
- Ringle Park 1
- Rotary Park 1
- Skycreek Park 1
- Teichert Pond 1
- USFS Genetic Resource and Conservation Center 1
- Verbena Fields 1
- Wildwood Estate Preserve 1
- Wildwood Park 1
ACCESS_TYP 3
MNG_AG_TYP 1
- City Agency 43
MNG_AGENCY 1
- Chico, City of · 43 ✖
Link | rowid | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES ▼ | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13281 | 13281 | 13280 | {"type": "Polygon", "coordinates": [[[-121.78585, 39.7266], [-121.78558, 39.7266], [-121.78559, 39.72655], [-121.78559, 39.72636], [-121.78576, 39.72636], [-121.78582, 39.72638], [-121.78585, 39.72642], [-121.78585, 39.7266]]]} | Open Access 1 | Belgium Avenue Mini Park | 33419 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 0.142 | Belgium Avenue MP | ||
13279 | 13279 | 13278 | {"type": "Polygon", "coordinates": [[[-121.83508, 39.72537], [-121.83486, 39.7255], [-121.83448, 39.72532], [-121.83456, 39.72529], [-121.83465, 39.72529], [-121.83508, 39.72537]]]} | Open Access 1 | Junction Park | 33418 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 0.146 | Junction Park | ||
13271 | 13271 | 13270 | {"type": "Polygon", "coordinates": [[[-121.8418, 39.73083], [-121.8417, 39.73106], [-121.84166, 39.73121], [-121.84166, 39.7313], [-121.84141, 39.73108], [-121.8418, 39.73083]]]} | Open Access 1 | Ringle Park | 33415 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 0.158 | Ringle Park | ||
9012 | 9012 | 9011 | {"type": "Polygon", "coordinates": [[[-121.82954, 39.71984], [-121.82923, 39.72018], [-121.82893, 39.72001], [-121.82925, 39.71967], [-121.82954, 39.71984]]]} | Open Access 1 | Rotary Park | 24687 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 0.36 | Rotary Park | ||
2995 | 2995 | 2994 | {"type": "Polygon", "coordinates": [[[-121.83224, 39.72604], [-121.83183, 39.7262], [-121.83154, 39.72575], [-121.83165, 39.72571], [-121.83177, 39.72561], [-121.83192, 39.72555], [-121.83224, 39.72604]]]} | Open Access 1 | City Skate Park | 17346 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 0.566 | City Skate Park | ||
3573 | 3573 | 3572 | {"type": "Polygon", "coordinates": [[[-121.84772, 39.72402], [-121.8475, 39.72417], [-121.84613, 39.72293], [-121.84635, 39.72278], [-121.84772, 39.72402]]]} | Open Access 1 | Depot Park | 18100 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 1.124 | Depot Park | ||
8234 | 8234 | 8233 | {"type": "Polygon", "coordinates": [[[-121.83952, 39.72835], [-121.83882, 39.72882], [-121.8382, 39.72828], [-121.83889, 39.7278], [-121.83952, 39.72835]]]} | Open Access 1 | Plaza Park | 23781 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 1.59 | Plaza Park | ||
5293 | 5293 | 5292 | {"type": "Polygon", "coordinates": [[[-121.82248, 39.73148], [-121.82081, 39.73257], [-121.82042, 39.7323], [-121.8205, 39.73224], [-121.8206, 39.73219], [-121.8207, 39.7321], [-121.82085, 39.73201], [-121.821, 39.73188], [-121.82114, 39.73183], [-121.82131, 39.73163], [-121.8214, 39.73146], [-121.82144, 39.73142], [-121.82212, 39.73139], [-121.82219, 39.73137], [-121.82224, 39.7313], [-121.82228, 39.73129], [-121.82248, 39.73148]]]} | Open Access 1 | Humboldt Neighborhood Park | 20145 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 2.151 | Humboldt Neighborhood Park | ||
7398 | 7398 | 7397 | {"type": "Polygon", "coordinates": [[[-121.79524, 39.74756], [-121.79522, 39.74761], [-121.79517, 39.74762], [-121.79439, 39.74762], [-121.79428, 39.74759], [-121.79416, 39.74753], [-121.79406, 39.74746], [-121.79398, 39.74737], [-121.79392, 39.74721], [-121.79391, 39.74692], [-121.79387, 39.74674], [-121.79389, 39.74669], [-121.79446, 39.74666], [-121.79484, 39.74656], [-121.79506, 39.74654], [-121.79512, 39.74658], [-121.79514, 39.74697], [-121.79524, 39.74756]]]} | Open Access 1 | Nob Hill Park | 22774 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 2.815 | Nob Hill Park | ||
2900 | 2900 | 2899 | {"type": "Polygon", "coordinates": [[[-121.84369, 39.73133], [-121.84331, 39.73158], [-121.84322, 39.73166], [-121.84314, 39.7317], [-121.84292, 39.73172], [-121.84284, 39.73176], [-121.84258, 39.7318], [-121.84229, 39.73181], [-121.84212, 39.73178], [-121.84208, 39.73171], [-121.84197, 39.7314], [-121.84197, 39.73101], [-121.84202, 39.73084], [-121.84208, 39.73071], [-121.84218, 39.73057], [-121.84229, 39.73045], [-121.84333, 39.73137], [-121.84356, 39.73122], [-121.84369, 39.73133]]]} | Open Access 1 | Children's Park | 17195 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 2.963 | Children's Park | ||
15569 | 15569 | 15568 | {"type": "Polygon", "coordinates": [[[-121.82131, 39.72538], [-121.82125, 39.72544], [-121.81953, 39.72565], [-121.81943, 39.72559], [-121.81928, 39.72488], [-121.8199, 39.72452], [-121.82016, 39.72479], [-121.82021, 39.72478], [-121.82043, 39.72484], [-121.82128, 39.72533], [-121.8213, 39.72535], [-121.82131, 39.72538]]]} | Open Access 1 | Johnson Neighborhood Center | 20477 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 3.063 | Johnson Neighborhood Ctr. | ||
11219 | 11219 | 11218 | {"type": "Polygon", "coordinates": [[[-121.80876, 39.76798], [-121.80871, 39.76806], [-121.80871, 39.76814], [-121.80873, 39.76815], [-121.80863, 39.76821], [-121.80864, 39.76851], [-121.80763, 39.76852], [-121.8071, 39.76788], [-121.80738, 39.76769], [-121.8079, 39.76741], [-121.8081, 39.76735], [-121.80827, 39.76733], [-121.80829, 39.76733], [-121.8083, 39.76746], [-121.80846, 39.76763], [-121.80856, 39.76768], [-121.80866, 39.76792], [-121.80876, 39.76798]]]} | Unknown Access 4 | Wildwood Estate Preserve | 27518 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 3.111 | Wildwood Estate Preserve | ||
4866 | 4866 | 4865 | {"type": "Polygon", "coordinates": [[[-121.81617, 39.77188], [-121.81496, 39.77285], [-121.8149, 39.77286], [-121.81418, 39.77233], [-121.81416, 39.77229], [-121.81418, 39.77226], [-121.81523, 39.77142], [-121.81527, 39.77141], [-121.81556, 39.7714], [-121.8156, 39.77142], [-121.81616, 39.77183], [-121.81617, 39.77188]]]} | Open Access 1 | Hancock Park | 19634 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 3.583 | Hancock Park | ||
3822 | 3822 | 3821 | {"type": "Polygon", "coordinates": [[[-121.80841, 39.76956], [-121.80823, 39.76957], [-121.80747, 39.77004], [-121.80747, 39.77006], [-121.80758, 39.77016], [-121.80642, 39.76929], [-121.80643, 39.76853], [-121.80708, 39.76853], [-121.80745, 39.7689], [-121.80751, 39.76892], [-121.80751, 39.76895], [-121.80766, 39.76908], [-121.80801, 39.76933], [-121.80841, 39.76956]]]} | Open Access 1 | Eaton Road Preserve | 18413 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 3.754 | Eaton Road Preserve | ||
5134 | 5134 | 5133 | {"type": "Polygon", "coordinates": [[[-121.83404, 39.76752], [-121.83307, 39.76754], [-121.83288, 39.76759], [-121.83243, 39.76778], [-121.83236, 39.7678], [-121.83231, 39.76779], [-121.83228, 39.76775], [-121.83227, 39.76691], [-121.83232, 39.76686], [-121.83234, 39.7668], [-121.83231, 39.76673], [-121.83225, 39.76668], [-121.83224, 39.76644], [-121.83403, 39.76643], [-121.83404, 39.76752]]]} | Open Access 1 | Highlands Park | 19943 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 4.808 | Highlands Park | ||
8116 | 8116 | 8115 | {"type": "Polygon", "coordinates": [[[-121.87704, 39.76343], [-121.8758, 39.76415], [-121.87473, 39.76307], [-121.87603, 39.76234], [-121.87704, 39.76343]]]} | Open Access 1 | Peterson Park | 23633 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 4.99 | Peterson Park | ||
13457 | 13457 | 13456 | {"type": "Polygon", "coordinates": [[[-121.85697, 39.8077], [-121.85694, 39.81018], [-121.85663, 39.81022], [-121.85626, 39.80996], [-121.85599, 39.80946], [-121.85582, 39.80948], [-121.85572, 39.80922], [-121.85437, 39.80942], [-121.85359, 39.80962], [-121.85359, 39.80913], [-121.85387, 39.80913], [-121.85422, 39.80927], [-121.85439, 39.8093], [-121.85569, 39.8091], [-121.85575, 39.80889], [-121.85597, 39.80883], [-121.85612, 39.80845], [-121.85624, 39.80843], [-121.85634, 39.80839], [-121.85643, 39.80834], [-121.8565, 39.80827], [-121.85674, 39.80774], [-121.85697, 39.8077]]]} | Open Access 1 | Skycreek Park | 33437 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 5.534 | Skycreek Park | ||
5041 | 5041 | 5040 | {"type": "Polygon", "coordinates": [[[-121.88044, 39.75226], [-121.87925, 39.75296], [-121.87783, 39.75153], [-121.879, 39.75083], [-121.88044, 39.75226]]]} | Open Access 1 | Henshaw Park | 19830 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 6.341 | Henshaw Park | ||
7594 | 7594 | 7593 | {"type": "Polygon", "coordinates": [[[-121.87247, 39.73553], [-121.87225, 39.7356], [-121.87215, 39.73565], [-121.87206, 39.73573], [-121.87129, 39.73682], [-121.86938, 39.73603], [-121.87, 39.73514], [-121.87231, 39.73532], [-121.87244, 39.73537], [-121.87247, 39.73553]]]} | Open Access 1 | Oak Way Park | 23017 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 7.053 | Oak Way Park | ||
1304 | 1304 | 1303 | {"type": "Polygon", "coordinates": [[[-121.78385, 39.73052], [-121.78146, 39.73053], [-121.78141, 39.7299], [-121.78025, 39.72994], [-121.78024, 39.72984], [-121.78095, 39.72944], [-121.78099, 39.7294], [-121.78378, 39.72941], [-121.78385, 39.73052]]]} | Open Access 1 | Baroni Neighborhood Park | 15828 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 7.336 | Baroni Neighborhood Park |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);