superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
94 rows where MNG_AGENCY = 14
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
5185 | 5185 | 5184 | {"type": "Polygon", "coordinates": [[[-119.80436, 36.7161], [-119.80433, 36.71604], [-119.80427, 36.71602], [-119.8021, 36.71603], [-119.8021, 36.71598], [-119.80207, 36.71592], [-119.80202, 36.71588], [-119.80194, 36.71587], [-119.8021, 36.71585], [-119.8021, 36.71486], [-119.80278, 36.71485], [-119.80278, 36.71423], [-119.80426, 36.71423], [-119.80426, 36.71585], [-119.80429, 36.71594], [-119.80436, 36.716], [-119.80436, 36.7161]]]} | Open Access 1 | Hinton Park | 20004 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 8.504 | Hinton Park | ||
5223 | 5223 | 5222 | {"type": "Polygon", "coordinates": [[[-119.77435, 36.73962], [-119.77432, 36.74122], [-119.7726, 36.74123], [-119.77267, 36.73961], [-119.77435, 36.73962]]]} | Open Access 1 | Holmes Playground | 20056 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 6.724 | Holmes Playground | ||
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 | ||
5269 | 5269 | 5268 | {"type": "Polygon", "coordinates": [[[-119.82618, 36.83182], [-119.82618, 36.8326], [-119.82604, 36.8327], [-119.82405, 36.83271], [-119.82405, 36.83183], [-119.82618, 36.83182]]]} | Open Access 1 | Howard B Holman Park | 20115 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 4.571 | Howard B Holman Park | ||
5313 | 5313 | 5312 | {"type": "Polygon", "coordinates": [[[-119.81773, 36.71687], [-119.81772, 36.7176], [-119.81768, 36.71761], [-119.81768, 36.71769], [-119.81736, 36.71769], [-119.81732, 36.71765], [-119.81725, 36.71761], [-119.81224, 36.71764], [-119.81224, 36.71684], [-119.81244, 36.71655], [-119.81261, 36.71635], [-119.81283, 36.71618], [-119.81322, 36.716], [-119.81336, 36.71596], [-119.81338, 36.71604], [-119.81393, 36.71588], [-119.81415, 36.71584], [-119.81448, 36.71582], [-119.81487, 36.71582], [-119.81506, 36.71586], [-119.81559, 36.71585], [-119.81561, 36.71604], [-119.81773, 36.71687]]]} | Open Access 1 | Hyde Park | 20165 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 19.495 | Hyde Park | ||
5426 | 5426 | 5425 | {"type": "Polygon", "coordinates": [[[-119.79519, 36.69593], [-119.79314, 36.69594], [-119.79314, 36.6942], [-119.79519, 36.69419], [-119.79519, 36.69593]]]} | Open Access 1 | Ivy Park | 20287 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 8.732 | Ivy Park | ||
5648 | 5648 | 5647 | {"type": "Polygon", "coordinates": [[[-119.77928, 36.8429], [-119.77926, 36.84455], [-119.77813, 36.84457], [-119.77814, 36.84285], [-119.77928, 36.8429]]]} | Open Access 1 | Kaiser Park | 20544 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 4.695 | Kaiser Park | ||
5683 | 5683 | 5682 | {"type": "Polygon", "coordinates": [[[-119.76803, 36.8627], [-119.76737, 36.86271], [-119.76643, 36.86282], [-119.76598, 36.86283], [-119.76593, 36.86279], [-119.76593, 36.86197], [-119.76803, 36.86196], [-119.76803, 36.8627]]]} | Open Access 1 | Keith Tice Park | 20574 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 4.069 | Keith Tice 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 | ||
5867 | 5867 | 5866 | {"type": "Polygon", "coordinates": [[[-119.79275, 36.7758], [-119.79168, 36.77582], [-119.79168, 36.77414], [-119.79274, 36.77413], [-119.79275, 36.7758]]]} | Open Access 1 | Lafayette Park | 20831 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 4.352 | Lafayette Park | ||
5982 | 5982 | 5981 | {"type": "Polygon", "coordinates": [[[-119.76314, 36.79821], [-119.76314, 36.79947], [-119.76112, 36.79948], [-119.76112, 36.79821], [-119.76314, 36.79821]]]} | Open Access 1 | Large Park | 21025 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 6.237 | Large 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 | ||
6323 | 6323 | 6322 | {"type": "Polygon", "coordinates": [[[-119.71112, 36.77661], [-119.71035, 36.77693], [-119.71087, 36.77789], [-119.7109, 36.77817], [-119.71106, 36.77893], [-119.71107, 36.77916], [-119.71098, 36.77922], [-119.71095, 36.7793], [-119.70509, 36.77924], [-119.70404, 36.77885], [-119.70354, 36.77875], [-119.70312, 36.77872], [-119.70259, 36.77873], [-119.70203, 36.77891], [-119.70123, 36.77919], [-119.70095, 36.77921], [-119.7011, 36.77741], [-119.70133, 36.77645], [-119.70172, 36.77585], [-119.7019, 36.7757], [-119.70334, 36.77575], [-119.70395, 36.77575], [-119.70417, 36.77573], [-119.7044, 36.77567], [-119.7046, 36.77557], [-119.70476, 36.77545], [-119.70509, 36.77507], [-119.70515, 36.77506], [-119.70642, 36.77577], [-119.70767, 36.77435], [-119.70773, 36.77432], [-119.7078, 36.77432], [-119.70787, 36.77434], [-119.70931, 36.77518], [-119.71086, 36.77614], [-119.71112, 36.77661]]]} | Restricted Access 2 | Airways Municipal Golf Course | 33086 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 88.177 | Airways Municipal GC | ||
6563 | 6563 | 6562 | {"type": "Polygon", "coordinates": [[[-119.7814, 36.78136], [-119.78138, 36.78318], [-119.77927, 36.78318], [-119.77929, 36.78137], [-119.7814, 36.78136]]]} | Open Access 1 | Manchester Park | 21731 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 9.42 | Manchester Park | ||
6899 | 6899 | 6898 | {"type": "Polygon", "coordinates": [[[-119.68579, 36.78219], [-119.68225, 36.78221], [-119.68223, 36.77949], [-119.68575, 36.77947], [-119.68579, 36.78219]]]} | Open Access 1 | Melody Park | 22111 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 23.496 | Melody Park | ||
7228 | 7228 | 7227 | {"type": "Polygon", "coordinates": [[[-119.7453, 36.72622], [-119.7453, 36.72842], [-119.74397, 36.72843], [-119.74397, 36.72726], [-119.74285, 36.72727], [-119.74292, 36.7271], [-119.74286, 36.72664], [-119.7421, 36.72662], [-119.7421, 36.72625], [-119.7453, 36.72622]]]} | Open Access 1 | Mosqueda Park | 22510 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 10.657 | Mosqueda Park | ||
7270 | 7270 | 7269 | {"type": "Polygon", "coordinates": [[[-119.79036, 36.76947], [-119.78888, 36.76947], [-119.78887, 36.7687], [-119.78891, 36.76869], [-119.78909, 36.7686], [-119.78999, 36.76854], [-119.79001, 36.76798], [-119.79035, 36.76797], [-119.79036, 36.76947]]]} | Unknown Access 4 | Ratcliffe Stadium | 24192 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 3.756 | Ratcliffe Stadium | ||
7335 | 7335 | 7334 | {"type": "Polygon", "coordinates": [[[-119.81988, 36.72408], [-119.81985, 36.72531], [-119.81777, 36.72532], [-119.8178, 36.7241], [-119.81988, 36.72408]]]} | Open Access 1 | Neilson Park | 22690 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 6.257 | Neilson Park | ||
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 |
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]);