superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
84 rows where MNG_AGENCY = 510 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6981 | 6981 | 6980 | {"type": "Polygon", "coordinates": [[[-121.05612, 37.69647], [-121.05471, 37.69648], [-121.05466, 37.69477], [-121.05611, 37.69474], [-121.05612, 37.69647]]]} | Open Access 1 | Mildred Perkins Park | 22215 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 5.937 | Mildred Perkins 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 | ||
2926 | 2926 | 2925 | {"type": "Polygon", "coordinates": [[[-121.04521, 37.68382], [-121.04325, 37.6844], [-121.04323, 37.68302], [-121.0452, 37.68299], [-121.04521, 37.68382]]]} | Open Access 1 | Chrysler 99 Park | 17235 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 5.251 | Chrysler 99 Park | ||
2965 | 2965 | 2964 | {"type": "Polygon", "coordinates": [[[-121.04345, 37.67763], [-121.04306, 37.67767], [-121.04258, 37.67768], [-121.04263, 37.67694], [-121.04306, 37.67726], [-121.04345, 37.67763]]]} | Open Access 1 | City Gate Children's Park | 17292 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 0.828 | City Gate Children's Park | ||
2927 | 2927 | 2926 | {"type": "Polygon", "coordinates": [[[-121.03802, 37.68095], [-121.03655, 37.68097], [-121.03656, 37.67999], [-121.03661, 37.6798], [-121.03674, 37.67949], [-121.03688, 37.6793], [-121.03707, 37.67909], [-121.03749, 37.67881], [-121.03759, 37.67878], [-121.03777, 37.67891], [-121.03801, 37.67913], [-121.03802, 37.68095]]]} | Open Access 1 | Chrysler Park | 17236 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 6.541 | Chrysler Park | ||
2849 | 2849 | 2848 | {"type": "Polygon", "coordinates": [[[-121.03778, 37.64938], [-121.03551, 37.6494], [-121.03549, 37.64852], [-121.0366, 37.64803], [-121.03752, 37.64807], [-121.03777, 37.64817], [-121.03778, 37.64938]]]} | Open Access 1 | Charles M. Sharp Park | 17140 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 6.764 | Charles M. Sharp Park | ||
6846 | 6846 | 6845 | {"type": "Polygon", "coordinates": [[[-121.03756, 37.69876], [-121.03628, 37.69877], [-121.03622, 37.69689], [-121.03751, 37.69688], [-121.03756, 37.69876]]]} | Open Access 1 | Mckinney Colony Park | 22051 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 5.837 | Mckinney Colony Park | ||
7278 | 7278 | 7277 | {"type": "Polygon", "coordinates": [[[-121.03135, 37.67873], [-121.03015, 37.67872], [-121.0297, 37.6787], [-121.02923, 37.6787], [-121.02921, 37.67799], [-121.03134, 37.67802], [-121.03135, 37.67873]]]} | Open Access 1 | Muncy Park | 22599 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 3.645 | Muncy Park | ||
3879 | 3879 | 3878 | {"type": "Polygon", "coordinates": [[[-121.02733, 37.68752], [-121.02714, 37.68737], [-121.02618, 37.68735], [-121.02616, 37.68554], [-121.02725, 37.68556], [-121.0273, 37.68559], [-121.02733, 37.68752]]]} | Open Access 1 | Eisenhut Park | 18476 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 5.025 | Eisenhut Park | ||
6692 | 6692 | 6691 | {"type": "Polygon", "coordinates": [[[-121.02634, 37.63357], [-121.0248, 37.63356], [-121.02479, 37.63147], [-121.02634, 37.63145], [-121.02634, 37.63357]]]} | Open Access 1 | Mark Twain Park | 21871 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 7.883 | Mark Twain Park | ||
4501 | 4501 | 4500 | {"type": "Polygon", "coordinates": [[[-121.02421, 37.66503], [-121.0241, 37.6663], [-121.02215, 37.66628], [-121.02214, 37.66496], [-121.02314, 37.66497], [-121.02316, 37.66502], [-121.02421, 37.66503]]]} | Open Access 1 | Garisson Park | 19221 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 6.303 | Garisson Park | ||
1205 | 1205 | 1204 | {"type": "Polygon", "coordinates": [[[-121.0241, 37.69426], [-121.02375, 37.69426], [-121.02373, 37.69383], [-121.02259, 37.69381], [-121.02257, 37.69257], [-121.02258, 37.69254], [-121.02262, 37.69253], [-121.02407, 37.69255], [-121.0241, 37.69426]]]} | Open Access 1 | Aqueduct Park | 15550 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 5.052 | Aqueduct Park | ||
1933 | 1933 | 1932 | {"type": "Polygon", "coordinates": [[[-121.02354, 37.60961], [-121.02354, 37.61087], [-121.01634, 37.61091], [-121.01632, 37.60982], [-121.02176, 37.60979], [-121.02179, 37.60913], [-121.02209, 37.60916], [-121.02354, 37.60961]]]} | Open Access 1 | Bellenita Park | 15985 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 20.859 | Bellenita Park | ||
8834 | 8834 | 8833 | {"type": "Polygon", "coordinates": [[[-121.02098, 37.61548], [-121.02091, 37.61553], [-121.02089, 37.61559], [-121.02085, 37.61677], [-121.01999, 37.61678], [-121.01961, 37.61674], [-121.01873, 37.61675], [-121.01871, 37.61549], [-121.02098, 37.61548]]]} | Open Access 1 | Robertson Road Park | 24499 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 6.652 | Robertson Road Park | ||
2708 | 2708 | 2707 | {"type": "Polygon", "coordinates": [[[-121.01988, 37.67691], [-121.01984, 37.67694], [-121.01936, 37.67701], [-121.0189, 37.67702], [-121.01887, 37.67495], [-121.01984, 37.67496], [-121.01981, 37.67651], [-121.01983, 37.6767], [-121.01988, 37.67691]]]} | Open Access 1 | Catherine Everett Park | 16976 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 4.66 | Catherine Everett Park | ||
5430 | 5430 | 5429 | {"type": "Polygon", "coordinates": [[[-121.01985, 37.65775], [-121.01675, 37.65773], [-121.01674, 37.65692], [-121.01984, 37.65694], [-121.01985, 37.65775]]]} | Open Access 1 | J.M. Pike Park | 20295 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 6.061 | J.M. Pike Park | ||
6898 | 6898 | 6897 | {"type": "Polygon", "coordinates": [[[-121.01407, 37.63323], [-121.01197, 37.63323], [-121.01197, 37.63145], [-121.01405, 37.63145], [-121.01407, 37.63323]]]} | Open Access 1 | Mellis Park | 22110 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 9.017 | Mellis Park | ||
4379 | 4379 | 4378 | {"type": "Polygon", "coordinates": [[[-121.01348, 37.6259], [-121.01188, 37.6259], [-121.01185, 37.62423], [-121.01345, 37.62422], [-121.01348, 37.6259]]]} | Open Access 1 | James Marshall Park | 20349 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 6.523 | James Marshall Park | ||
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 | ||
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 |
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]);