superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
84 rows where MNG_AGENCY = 510 sorted by SUID_NMA 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6240 | 6240 | 6239 | {"type": "MultiPolygon", "coordinates": [[[[-120.99932, 37.62134], [-120.99917, 37.62154], [-120.99906, 37.62181], [-120.99884, 37.62328], [-120.99886, 37.62347], [-120.99888, 37.62356], [-120.99917, 37.62423], [-120.99856, 37.62423], [-120.99861, 37.62338], [-120.99842, 37.62163], [-120.99844, 37.62135], [-120.99932, 37.62134]]], [[[-121.00483, 37.6277], [-121.00335, 37.6277], [-121.00333, 37.6274], [-121.00293, 37.6274], [-121.00293, 37.6277], [-121.0001, 37.62764], [-120.99933, 37.62754], [-120.99931, 37.62579], [-120.9994, 37.62481], [-120.99939, 37.6246], [-120.99936, 37.62439], [-120.9993, 37.62419], [-120.99901, 37.62354], [-120.99899, 37.62345], [-120.99898, 37.62328], [-120.99919, 37.62183], [-120.9993, 37.62158], [-120.99941, 37.62144], [-120.99954, 37.6213], [-121.00026, 37.62082], [-121.0005, 37.6207], [-121.00077, 37.62066], [-121.0015, 37.62067], [-121.00149, 37.62351], [-121.00206, 37.62352], [-121.00206, 37.62423], [-121.00252, 37.62424], [-121.00254, 37.62432], [-121.0048, 37.62432], [-121.00483, 37.6277]]]]} | Restricted Access 2 | Modesto Municipal Golf Course | 33068 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 67.98 | Modesto Municipal GC | ||
188 | 188 | 187 | {"type": "Polygon", "coordinates": [[[-121.01091, 37.61013], [-121.01091, 37.61163], [-121.01087, 37.61165], [-121.01029, 37.61166], [-121.01028, 37.61259], [-121.00951, 37.6126], [-121.0095, 37.61333], [-121.00713, 37.61333], [-121.00712, 37.6133], [-121.0069, 37.6132], [-121.00574, 37.61394], [-121.00469, 37.61511], [-121.00313, 37.61607], [-121.00289, 37.61661], [-121.00346, 37.61667], [-121.00337, 37.61699], [-121.00483, 37.617], [-121.00483, 37.61781], [-121.00413, 37.61781], [-121.00412, 37.61791], [-121.00265, 37.61791], [-121.00265, 37.61769], [-121.00263, 37.61768], [-121.00076, 37.62018], [-121.00023, 37.62069], [-120.99954, 37.62116], [-120.99932, 37.62134], [-120.99844, 37.62135], [-120.99856, 37.61961], [-120.99866, 37.61853], [-120.99872, 37.61772], [-120.9986, 37.61696], [-120.99845, 37.61648], [-120.99809, 37.61568], [-120.99824, 37.61515], [-121.00054, 37.61294], [-121.0023, 37.61183], [-121.00496, 37.61077], [-121.00724, 37.61022], [-121.00952, 37.60948], [-121.00953, 37.60976], [-121.00959, 37.60976], [-121.01091, 37.61013]]]} | Restricted Access 2 | Dryden Park Golf Course | 33067 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 145.269 | Dryden Park GC | ||
13759 | 13759 | 13758 | {"type": "Polygon", "coordinates": [[[-120.94998, 37.64964], [-120.94987, 37.64947], [-120.94972, 37.64935], [-120.94933, 37.64916], [-120.94892, 37.64904], [-120.94857, 37.64887], [-120.94821, 37.6486], [-120.94808, 37.64857], [-120.94792, 37.64849], [-120.94767, 37.64842], [-120.94751, 37.64832], [-120.94726, 37.64824], [-120.94705, 37.64824], [-120.94689, 37.64827], [-120.94603, 37.64854], [-120.94578, 37.64871], [-120.94549, 37.64892], [-120.94541, 37.64901], [-120.94526, 37.6492], [-120.9452, 37.64934], [-120.94519, 37.64946], [-120.94455, 37.6507], [-120.94414, 37.65124], [-120.94359, 37.65155], [-120.9433, 37.65173], [-120.94296, 37.65199], [-120.94286, 37.65209], [-120.94268, 37.65231], [-120.94275, 37.65236], [-120.94262, 37.65253], [-120.94256, 37.65267], [-120.94237, 37.65297], [-120.94211, 37.65331], [-120.94172, 37.65367], [-120.94162, 37.65382], [-120.94154, 37.65391], [-120.94143, 37.654], [-120.94125, 37.65409], [-120.94096, 37.6542], [-120.94082, 37.65422], [-120.94049, 37.65421], [-120.94027, 37.65418], [-120.93922, 37.65415], [-120.9392, 37.65408], [-120.93862, 37.6541], [-120.93813, 37.65394], [-120.93784, 37.65395], [-120.93715, 37.65383], [-120.93698, 37.65383], [-120.93663, 37.65371], [-120.93635, 37.65364], [-120.93558, 37.65356], [-120.93524, 37.65357], [-120.93523, 37.65365], [-120.93405, 37.65329], [-120.9337, 37.65323], [-120.9332, 37.65298], [-120.93291, 37.65275], [-120.9319, 37.65225], [-120.93167, 37.65218], [-120.93137, 37.65204], [-120.93065, 37.65213], [-120.93016, 37.6523], [-120.93014, 37.65079], [-120.93024, 37.65077], [-120.93022, 37.64918], [-120.93024, 37.64915], [-120.93026, 37.64914], [-120.93898, 37.64909], [-120.93901, 37.64911], [-120.93909, 37.64943], [-120.93911, 37.65109], [-120.93918, 37.65109], [-120.93919, 37.65111], [-120.9414, 37.65108], [-120.94139, 37.65094], [-120.93924, 37.65097], [-120.93923, 37.64954], [-120.93916, 37.64929], [-120.93916, 37.6492], [-120.93926, 37.64917], [-120.93926, 37.64923], [-120.93928, 37.64924], [-120.94039, 37.64882], [-120.94039, 37.64872], [-120.94066, 37.64859], [-120.94207, 37.64761], [-120.94226, 37.6475], [-120.94247, 37.64742], [-120.94438, 37.64684], [-120.94459, 37.64676], [-120.94479, 37.64665], [-120.94661, 37.64545], [-120.94678, 37.64537], [-120.94705, 37.6453], [-120.94724, 37.64529], [-120.94804, 37.64529], [-120.94813, 37.64549], [-120.94817, 37.64844], [-120.94821, 37.64848], [-120.9483, 37.64851], [-120.9483, 37.64864], [-120.94908, 37.64902], [-120.94982, 37.64935], [-120.94998, 37.64949], [-120.94998, 37.64964]], [[-120.94255, 37.65248], [-120.94254, 37.65246], [-120.94248, 37.65247], [-120.94241, 37.65263], [-120.94244, 37.65263], [-120.94255, 37.65248]]]} | Restricted Access 2 | Creekside Golf Course | 33066 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 181.215 | Creekside GC | ||
11404 | 11404 | 11403 | {"type": "Polygon", "coordinates": [[[-120.99901, 37.6822], [-120.99893, 37.68259], [-120.99886, 37.68315], [-120.99884, 37.68319], [-120.99878, 37.68326], [-120.99876, 37.68331], [-120.99878, 37.68336], [-120.99882, 37.68341], [-120.99887, 37.68344], [-120.99893, 37.68345], [-120.99893, 37.6837], [-120.9974, 37.68367], [-120.99741, 37.68347], [-120.99744, 37.68327], [-120.99749, 37.68307], [-120.99756, 37.68287], [-120.99765, 37.68268], [-120.99776, 37.6825], [-120.9979, 37.68233], [-120.9982, 37.682], [-120.99824, 37.682], [-120.99898, 37.68218], [-120.99901, 37.6822]]]} | Open Access 1 | Woodrow Park | 27736 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 4.973 | Woodrow Park | ||
11391 | 11391 | 11390 | {"type": "Polygon", "coordinates": [[[-121.04786, 37.6561], [-121.04783, 37.65613], [-121.04747, 37.65621], [-121.04712, 37.65624], [-121.04711, 37.65467], [-121.04724, 37.65467], [-121.04751, 37.65462], [-121.04756, 37.65464], [-121.04768, 37.65478], [-121.04777, 37.65494], [-121.04783, 37.65511], [-121.04785, 37.65529], [-121.04786, 37.6561]]]} | Open Access 1 | Woodland Park | 27722 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 2.626 | Woodland Park | ||
11351 | 11351 | 11350 | {"type": "Polygon", "coordinates": [[[-121.00764, 37.67588], [-121.0055, 37.67586], [-121.0055, 37.67483], [-121.00605, 37.67485], [-121.00763, 37.67485], [-121.00764, 37.67588]]]} | Open Access 1 | Witmore Park | 27663 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 5.301 | Witmore Park | ||
11096 | 11096 | 11095 | {"type": "Polygon", "coordinates": [[[-121.00813, 37.69463], [-121.00552, 37.69539], [-121.00549, 37.69342], [-121.00718, 37.69344], [-121.00755, 37.69341], [-121.00758, 37.69344], [-121.00813, 37.69463]]]} | Open Access 1 | Wesson Ranch Park | 27350 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 9.237 | Wesson Ranch Park | ||
10590 | 10590 | 10589 | {"type": "Polygon", "coordinates": [[[-120.94881, 37.68533], [-120.94562, 37.68533], [-120.9456, 37.68386], [-120.94879, 37.68387], [-120.94881, 37.68533]]]} | Open Access 1 | Ustach Park | 26746 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 11.33 | Ustach Park | ||
10341 | 10341 | 10340 | {"type": "Polygon", "coordinates": [[[-120.98005, 37.64608], [-120.97941, 37.64655], [-120.97849, 37.64674], [-120.97806, 37.64705], [-120.97741, 37.64757], [-120.97692, 37.64786], [-120.97666, 37.64792], [-120.9759, 37.64803], [-120.97499, 37.64825], [-120.97417, 37.64831], [-120.97279, 37.64831], [-120.97212, 37.64848], [-120.97211, 37.64753], [-120.97234, 37.64744], [-120.97317, 37.64735], [-120.97396, 37.64744], [-120.97489, 37.6477], [-120.97541, 37.64746], [-120.97588, 37.64734], [-120.97651, 37.64713], [-120.9774, 37.64677], [-120.97853, 37.64621], [-120.97908, 37.64601], [-120.97934, 37.64582], [-120.98004, 37.64555], [-120.98005, 37.64608]]]} | Open Access 1 | Thousand Oaks Park | 26325 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 14.411 | Thousand Oaks Park | ||
10323 | 10323 | 10322 | {"type": "Polygon", "coordinates": [[[-120.98467, 37.65083], [-120.98241, 37.65082], [-120.98242, 37.65055], [-120.98239, 37.65], [-120.98465, 37.65], [-120.98467, 37.65083]]]} | Open Access 1 | Thomas B. Scott Park | 26306 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 4.476 | Thomas B. Scott Park | ||
10197 | 10197 | 10196 | {"type": "Polygon", "coordinates": [[[-120.97312, 37.68166], [-120.9728, 37.68166], [-120.97251, 37.68162], [-120.97195, 37.68159], [-120.97189, 37.67985], [-120.97308, 37.67985], [-120.97312, 37.68166]]]} | Open Access 1 | Sylvan Park | 26149 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 5.072 | Sylvan Park | ||
10151 | 10151 | 10150 | {"type": "Polygon", "coordinates": [[[-120.92088, 37.64184], [-120.92083, 37.64294], [-120.92085, 37.6445], [-120.91771, 37.64453], [-120.9177, 37.64508], [-120.91664, 37.64509], [-120.91657, 37.64213], [-120.91894, 37.64212], [-120.91895, 37.64185], [-120.92088, 37.64184]]]} | Open Access 1 | Sutton Community Park | 26088 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 27.317 | Sutton Community Park | ||
8614 | 8614 | 8613 | {"type": "Polygon", "coordinates": [[[-120.98357, 37.66353], [-120.98261, 37.66352], [-120.9826, 37.66184], [-120.98355, 37.66185], [-120.98357, 37.66353]]]} | Open Access 1 | Sutter Park | 26086 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 3.894 | Sutter Park | ||
9973 | 9973 | 9972 | {"type": "Polygon", "coordinates": [[[-120.96618, 37.6961], [-120.96506, 37.6961], [-120.965, 37.69607], [-120.96498, 37.69436], [-120.96615, 37.69434], [-120.96618, 37.6961]]]} | Open Access 1 | Stockard Coffee Park | 25854 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 5.003 | Stockard Coffee Park | ||
9904 | 9904 | 9903 | {"type": "Polygon", "coordinates": [[[-120.98851, 37.67448], [-120.9881, 37.6745], [-120.98785, 37.67447], [-120.98734, 37.67446], [-120.98735, 37.67276], [-120.98851, 37.67276], [-120.98851, 37.67448]]]} | Open Access 1 | Standiford Park | 25783 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 4.841 | Standiford Park | ||
9774 | 9774 | 9773 | {"type": "Polygon", "coordinates": [[[-120.95248, 37.66346], [-120.95127, 37.66345], [-120.95126, 37.66173], [-120.95238, 37.66173], [-120.95238, 37.66214], [-120.95227, 37.66225], [-120.95224, 37.66231], [-120.95226, 37.66237], [-120.9523, 37.66242], [-120.95237, 37.66245], [-120.95245, 37.66245], [-120.95249, 37.66287], [-120.95248, 37.66346]]]} | Open Access 1 | Sonoma Park | 25616 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 4.822 | Sonoma Park | ||
9702 | 9702 | 9701 | {"type": "Polygon", "coordinates": [[[-120.93243, 37.66145], [-120.93027, 37.66144], [-120.93027, 37.6603], [-120.93056, 37.66032], [-120.9306, 37.66038], [-120.93069, 37.66043], [-120.93078, 37.66042], [-120.93089, 37.66037], [-120.93182, 37.66036], [-120.93214, 37.66031], [-120.93233, 37.66052], [-120.93239, 37.66069], [-120.93242, 37.66082], [-120.93243, 37.66145]]]} | Open Access 1 | Sipherd Park | 25520 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 5.613 | Sipherd Park | ||
9605 | 9605 | 9604 | {"type": "Polygon", "coordinates": [[[-120.98509, 37.68491], [-120.98473, 37.68487], [-120.98463, 37.68482], [-120.98454, 37.68482], [-120.98447, 37.68483], [-120.98296, 37.68481], [-120.98292, 37.68368], [-120.98508, 37.6837], [-120.98509, 37.68491]]]} | Open Access 1 | Sherwood Park | 25401 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 5.915 | Sherwood Park | ||
8937 | 8937 | 8936 | {"type": "Polygon", "coordinates": [[[-120.96349, 37.6595], [-120.96212, 37.6595], [-120.9621, 37.65929], [-120.96209, 37.65818], [-120.96215, 37.65817], [-120.96241, 37.65818], [-120.96348, 37.65818], [-120.96349, 37.6595]]]} | Open Access 1 | Rose Avenue Park | 24605 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 4.438 | Rose Avenue Park | ||
8931 | 8931 | 8930 | {"type": "Polygon", "coordinates": [[[-121.00528, 37.66562], [-121.00416, 37.6656], [-121.00414, 37.66569], [-121.00317, 37.66566], [-121.00316, 37.66396], [-121.00527, 37.66401], [-121.00528, 37.66562]]]} | Open Access 1 | Roosevelt Park | 24598 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 8.445 | Roosevelt 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]);