units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
24 rows where DES_TP = 2 and MNG_AGENCY = 424
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9443 | 9443 | 9442 | {"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 | 15822 | Plaza Park | 23781 | 1052 | Chico, City of 430 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | Butte 42 | 1.59 | Plaza Park | 0 | Local Park 2 | 4 | |
9446 | 9446 | 9445 | {"type": "Polygon", "coordinates": [[[-121.79512, 39.74658], [-121.79514, 39.74697], [-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.79497, 39.74654], [-121.79506, 39.74654], [-121.79512, 39.74658]]]} | Open Access 1 | 15793 | Nob Hill Park | 22774 | 1052 | Chico, City of 430 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | Butte 42 | 2.818 | Nob Hill Park | 0 | Local Park 2 | 4 | |
9450 | 9450 | 9449 | {"type": "Polygon", "coordinates": [[[-121.80305, 39.73832], [-121.80207, 39.73854], [-121.79971, 39.73901], [-121.79964, 39.739], [-121.79958, 39.73898], [-121.79955, 39.73893], [-121.79936, 39.73839], [-121.79928, 39.73822], [-121.79914, 39.738], [-121.79899, 39.73782], [-121.79878, 39.73764], [-121.79857, 39.7375], [-121.79827, 39.73735], [-121.79792, 39.73722], [-121.79844, 39.73661], [-121.79865, 39.73672], [-121.799, 39.73687], [-121.79941, 39.73712], [-121.79978, 39.73742], [-121.80015, 39.73765], [-121.8006, 39.73774], [-121.80128, 39.73763], [-121.80155, 39.73764], [-121.80206, 39.73792], [-121.80207, 39.73759], [-121.80232, 39.73773], [-121.80305, 39.73832]]]} | Open Access 1 | 15801 | Norte Dame Blvd Park | 22803 | 1052 | Chico, City of 430 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | Butte 42 | 11.116 | Norte Dame Blvd Park | 0 | Local Park 2 | 4 | |
9460 | 9460 | 9459 | {"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 | 15817 | Peterson Park | 23633 | 1052 | Chico, City of 430 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | Butte 42 | 4.991 | Peterson Park | 0 | Local Park 2 | 4 | |
9465 | 9465 | 9464 | {"type": "Polygon", "coordinates": [[[-121.80608, 39.76755], [-121.80419, 39.76528], [-121.80279, 39.76367], [-121.80359, 39.76323], [-121.80417, 39.76268], [-121.80426, 39.76274], [-121.80495, 39.76259], [-121.80525, 39.76249], [-121.80535, 39.76249], [-121.80539, 39.76252], [-121.80554, 39.76278], [-121.80578, 39.7633], [-121.80587, 39.76356], [-121.80597, 39.76392], [-121.80605, 39.76446], [-121.80608, 39.76755]]]} | Open Access 1 | 15842 | Wildwood Park | 27520 | 1052 | Chico, City of 430 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | Butte 42 | 19.795 | Wildwood Park | 0 | Local Park 2 | 4 | |
9471 | 9471 | 9470 | {"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 | 15837 | Rotary Park | 24687 | 1052 | Chico, City of 430 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | Butte 42 | 0.36 | Rotary Park | 0 | Local Park 2 | 4 | |
10936 | 10936 | 10935 | {"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 | 48677 | Junction Park | 33418 | 1052 | Chico, City of 430 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | Butte 42 | 0.146 | Junction Park | 0 | Local Park 2 | 4 | |
11326 | 11326 | 11325 | {"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 | 22040 | Henshaw Park | 19830 | 1052 | Chico, City of 430 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | Butte 42 | 6.342 | Henshaw Park | 0 | Local Park 2 | 4 | |
11468 | 11468 | 11467 | {"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.8557, 39.8091], [-121.85575, 39.80889], [-121.85596, 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 | 48708 | Skycreek Park | 33437 | 1052 | Chico, City of 430 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | Butte 42 | 5.528 | Skycreek 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]);