superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
94 rows where MNG_AGENCY = 14 sorted by map descending
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8777 | 8777 | 8776 | {"type": "Polygon", "coordinates": [[[-119.90601, 36.84991], [-119.90514, 36.85098], [-119.90334, 36.8516], [-119.89998, 36.85175], [-119.8968, 36.85271], [-119.8963, 36.85226], [-119.89313, 36.85186], [-119.89311, 36.85193], [-119.89311, 36.85227], [-119.89279, 36.85211], [-119.8925, 36.852], [-119.89239, 36.85197], [-119.89231, 36.85193], [-119.89166, 36.85179], [-119.89119, 36.85175], [-119.89085, 36.85175], [-119.89017, 36.85181], [-119.88985, 36.85188], [-119.88952, 36.85198], [-119.88916, 36.85211], [-119.88936, 36.85127], [-119.88934, 36.85125], [-119.88939, 36.851], [-119.89048, 36.85117], [-119.89102, 36.85119], [-119.89182, 36.85127], [-119.89197, 36.85126], [-119.89206, 36.8513], [-119.89216, 36.8513], [-119.89237, 36.85134], [-119.8925, 36.85132], [-119.89259, 36.85135], [-119.89281, 36.85138], [-119.893, 36.85138], [-119.8931, 36.85136], [-119.89312, 36.85138], [-119.89352, 36.85142], [-119.8942, 36.85139], [-119.89439, 36.85135], [-119.89457, 36.85124], [-119.89461, 36.85124], [-119.89479, 36.85133], [-119.89496, 36.85136], [-119.89599, 36.85117], [-119.89622, 36.8511], [-119.89647, 36.85107], [-119.89672, 36.851], [-119.8968, 36.85091], [-119.89685, 36.85089], [-119.89709, 36.85087], [-119.89718, 36.85083], [-119.89729, 36.85082], [-119.8974, 36.85077], [-119.89761, 36.85052], [-119.89794, 36.85047], [-119.89817, 36.85016], [-119.89815, 36.85013], [-119.89822, 36.85009], [-119.89888, 36.84987], [-119.89952, 36.84974], [-119.89995, 36.84962], [-119.90022, 36.84965], [-119.90068, 36.84957], [-119.90181, 36.84954], [-119.90254, 36.84948], [-119.90325, 36.84925], [-119.90334, 36.84931], [-119.90358, 36.84923], [-119.90444, 36.84977], [-119.90533, 36.84896], [-119.90567, 36.84919], [-119.90539, 36.8495], [-119.90601, 36.84991]]]} | Open Access 1 | Riverbottom Park | 24437 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 57.831 | Riverbottom Park | ||
13983 | 13983 | 13982 | {"type": "Polygon", "coordinates": [[[-119.89564, 36.80259], [-119.8936, 36.8026], [-119.89359, 36.80089], [-119.89393, 36.80088], [-119.89394, 36.80093], [-119.89471, 36.8009], [-119.89536, 36.80089], [-119.89539, 36.80092], [-119.89541, 36.80141], [-119.89563, 36.80212], [-119.89564, 36.80259]]]} | Open Access 1 | Inspiration Park | 32570 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 7.972 | Inspiration Park | 2015 | |
9901 | 9901 | 9900 | {"type": "Polygon", "coordinates": [[[-119.89185, 36.82504], [-119.89184, 36.82616], [-119.88975, 36.82617], [-119.88977, 36.82508], [-119.89185, 36.82504]]]} | Open Access 1 | Stallion Park | 25780 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 5.628 | Stallion Park | ||
9652 | 9652 | 9651 | {"type": "Polygon", "coordinates": [[[-119.88755, 36.85026], [-119.88755, 36.85071], [-119.88721, 36.85064], [-119.88722, 36.85027], [-119.88732, 36.85026], [-119.88736, 36.85022], [-119.88738, 36.85017], [-119.88739, 36.85025], [-119.88755, 36.85026]]]} | Open Access 1 | Polk Overlook Pocket Park | 31011 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 0.349 | Polk Overlook PP | ||
5141 | 5141 | 5140 | {"type": "Polygon", "coordinates": [[[-119.88625, 36.80929], [-119.88539, 36.8101], [-119.88421, 36.8093], [-119.88556, 36.80929], [-119.88625, 36.80929]]]} | Open Access 1 | Highway City Park | 19952 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 2.017 | Highway City Park | ||
5773 | 5773 | 5772 | {"type": "Polygon", "coordinates": [[[-119.88605, 36.84411], [-119.88443, 36.84411], [-119.88439, 36.84407], [-119.88432, 36.84235], [-119.88597, 36.84231], [-119.88605, 36.84411]]]} | Open Access 1 | Koligian Park | 20716 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 7.2 | Koligian Park | ||
9670 | 9670 | 9669 | {"type": "Polygon", "coordinates": [[[-119.87918, 36.84588], [-119.87897, 36.84588], [-119.87868, 36.84562], [-119.87868, 36.84536], [-119.87885, 36.84521], [-119.87913, 36.84521], [-119.87916, 36.84522], [-119.87918, 36.84588]]]} | Open Access 1 | Milburn Overlook Pocket Park | 31022 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 0.682 | Milburn Overlook PP | ||
4222 | 4222 | 4221 | {"type": "Polygon", "coordinates": [[[-119.86925, 36.82653], [-119.86811, 36.82814], [-119.86772, 36.82791], [-119.86704, 36.82791], [-119.86704, 36.82627], [-119.86717, 36.82626], [-119.86782, 36.82561], [-119.86925, 36.82653]]]} | Open Access 1 | Figarden Loop Park | 18895 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 8.603 | Figarden Loop Park | ||
1790 | 1790 | 1789 | {"type": "Polygon", "coordinates": [[[-119.86893, 36.80535], [-119.86802, 36.80535], [-119.868, 36.8046], [-119.86867, 36.80459], [-119.86868, 36.80473], [-119.86875, 36.80488], [-119.86892, 36.80516], [-119.86893, 36.80535]]]} | Open Access 1 | Basin AH1 Dog Park | 15848 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1.479 | Basin AH1 Dog Park | ||
10869 | 10869 | 10868 | {"type": "Polygon", "coordinates": [[[-119.86216, 36.76989], [-119.86214, 36.77167], [-119.86209, 36.77171], [-119.8606, 36.77173], [-119.86058, 36.77176], [-119.86044, 36.77177], [-119.85782, 36.77178], [-119.85781, 36.76991], [-119.86216, 36.76989]]]} | Open Access 1 | Victoria West Community Park | 27084 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 19.669 | Victoria West Community Park | ||
14112 | 14112 | 14111 | {"type": "Polygon", "coordinates": [[[-119.85946, 36.77405], [-119.85882, 36.77405], [-119.85878, 36.77397], [-119.85869, 36.77392], [-119.85807, 36.77392], [-119.858, 36.77393], [-119.85794, 36.77396], [-119.85791, 36.774], [-119.85789, 36.77406], [-119.85725, 36.77406], [-119.85727, 36.77397], [-119.85732, 36.7739], [-119.85734, 36.77373], [-119.85734, 36.77366], [-119.85729, 36.77359], [-119.85721, 36.77327], [-119.8572, 36.77314], [-119.85724, 36.77311], [-119.85724, 36.77327], [-119.85731, 36.77351], [-119.85762, 36.77351], [-119.8577, 36.77345], [-119.85785, 36.77349], [-119.85801, 36.77349], [-119.85816, 36.77343], [-119.85816, 36.77322], [-119.85813, 36.77319], [-119.85816, 36.77314], [-119.85817, 36.77308], [-119.85814, 36.77303], [-119.85809, 36.77299], [-119.85809, 36.77244], [-119.85794, 36.77232], [-119.85794, 36.77225], [-119.85788, 36.77218], [-119.85788, 36.77204], [-119.85791, 36.77202], [-119.85823, 36.77202], [-119.85828, 36.77199], [-119.85837, 36.77199], [-119.85837, 36.77221], [-119.85829, 36.77217], [-119.85819, 36.77217], [-119.85812, 36.77222], [-119.85809, 36.7723], [-119.85811, 36.77235], [-119.85815, 36.77239], [-119.85821, 36.77242], [-119.85829, 36.77242], [-119.85829, 36.77297], [-119.85841, 36.77306], [-119.85841, 36.77313], [-119.85845, 36.77319], [-119.85841, 36.77322], [-119.85842, 36.77343], [-119.85857, 36.77348], [-119.85865, 36.77348], [-119.85888, 36.77338], [-119.85903, 36.77338], [-119.85912, 36.7735], [-119.85946, 36.7735], [-119.85943, 36.77359], [-119.85939, 36.77365], [-119.85938, 36.77374], [-119.8594, 36.77391], [-119.85945, 36.77397], [-119.85946, 36.77405]]]} | Open Access 1 | Westwood Park | 33656 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 3.663 | Westwood Park | ||
9658 | 9658 | 9657 | {"type": "Polygon", "coordinates": [[[-119.85853, 36.83271], [-119.85849, 36.83274], [-119.85745, 36.83274], [-119.8574, 36.83271], [-119.85741, 36.83201], [-119.85745, 36.83197], [-119.85754, 36.83198], [-119.8576, 36.832], [-119.85848, 36.83263], [-119.85853, 36.83271]]]} | Open Access 1 | Emerald Pocket Park | 31020 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1.276 | Emerald PP | ||
13573 | 13573 | 13572 | {"type": "Polygon", "coordinates": [[[-119.85482, 36.82922], [-119.85479, 36.82932], [-119.85447, 36.82937], [-119.85418, 36.8294], [-119.85409, 36.82933], [-119.85409, 36.82866], [-119.85415, 36.82861], [-119.8542, 36.82861], [-119.85428, 36.82864], [-119.85453, 36.82893], [-119.85482, 36.82922]]]} | Open Access 1 | Safety Pocket Park | 31007 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 0.894 | Safety PP | ||
7746 | 7746 | 7745 | {"type": "Polygon", "coordinates": [[[-119.85365, 36.84023], [-119.8525, 36.84027], [-119.85243, 36.84033], [-119.85219, 36.84034], [-119.85215, 36.83885], [-119.85353, 36.83885], [-119.8536, 36.83882], [-119.85362, 36.83877], [-119.85365, 36.84023]]]} | Open Access 1 | Orchid Park | 23197 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 5.093 | Orchid Park | ||
5239 | 5239 | 5238 | {"type": "Polygon", "coordinates": [[[-119.85339, 36.81645], [-119.85338, 36.81746], [-119.85112, 36.81746], [-119.85113, 36.81553], [-119.85196, 36.81553], [-119.85339, 36.81645]]]} | Open Access 1 | Logan Park | 21400 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 9.081 | Logan Park | ||
6253 | 6253 | 6252 | {"type": "Polygon", "coordinates": [[[-119.84426, 36.80273], [-119.83996, 36.80275], [-119.83995, 36.80098], [-119.84162, 36.80098], [-119.84205, 36.80106], [-119.84262, 36.80112], [-119.84422, 36.80112], [-119.84426, 36.80273]]]} | Open Access 1 | Lions Park | 21319 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 17.751 | Lions Park | ||
11305 | 11305 | 11304 | {"type": "Polygon", "coordinates": [[[-119.83984, 36.79196], [-119.83983, 36.79363], [-119.83765, 36.79364], [-119.83767, 36.79198], [-119.83984, 36.79196]]]} | Open Access 1 | Wilson Park | 27610 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 8.871 | Wilson Park | ||
8628 | 8628 | 8627 | {"type": "Polygon", "coordinates": [[[-119.83569, 36.69941], [-119.83184, 36.69942], [-119.83183, 36.69404], [-119.83132, 36.69402], [-119.83132, 36.6923], [-119.83569, 36.69229], [-119.83569, 36.69941]]]} | Open Access 1 | Regional Sports Park | 24277 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 69.374 | Reg. Sports Park | ||
15089 | 15089 | 15088 | {"type": "Polygon", "coordinates": [[[-119.83147, 36.70554], [-119.83024, 36.70554], [-119.83022, 36.70578], [-119.82573, 36.70578], [-119.8257, 36.69951], [-119.82599, 36.69933], [-119.82601, 36.69581], [-119.82675, 36.69579], [-119.82675, 36.69228], [-119.82703, 36.69232], [-119.82914, 36.69231], [-119.82915, 36.69402], [-119.83132, 36.69402], [-119.83133, 36.70304], [-119.83147, 36.70306], [-119.83147, 36.70554]]]} | Open Access 1 | Jensen-West Regional Park | 20394 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 164.826 | Jensen-West RP | ||
2828 | 2828 | 2827 | {"type": "Polygon", "coordinates": [[[-119.83131, 36.73084], [-119.83104, 36.73093], [-119.8308, 36.7311], [-119.83062, 36.73094], [-119.83057, 36.73087], [-119.83054, 36.73079], [-119.83057, 36.73064], [-119.83056, 36.73058], [-119.83053, 36.73053], [-119.83052, 36.72993], [-119.8313, 36.72992], [-119.83131, 36.73084]]]} | Open Access 1 | Chandler Park | 17119 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1.942 | Chandler 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]);