superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
84 rows where MNG_AGENCY = 510 sorted by PARK_URL
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5974 | 5974 | 5973 | {"type": "Polygon", "coordinates": [[[-120.94416, 37.6582], [-120.94411, 37.65822], [-120.94297, 37.65822], [-120.94294, 37.65653], [-120.94414, 37.65653], [-120.94416, 37.6582]]]} | Open Access 1 | Lakewood Park | 20989 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 4.864 | Lakewood Park | ||
6026 | 6026 | 6025 | {"type": "Polygon", "coordinates": [[[-120.95264, 37.64545], [-120.9483, 37.64545], [-120.94823, 37.64529], [-120.95262, 37.64529], [-120.95264, 37.64545]]]} | Open Access 1 | Lateral No. 2 Park | 21076 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1.693 | Lateral No. 2 Park | ||
6085 | 6085 | 6084 | {"type": "MultiPolygon", "coordinates": [[[[-120.97536, 37.62596], [-120.9748, 37.62595], [-120.97479, 37.62474], [-120.97378, 37.62412], [-120.97343, 37.62388], [-120.97081, 37.62291], [-120.96924, 37.62277], [-120.96846, 37.62263], [-120.96623, 37.62277], [-120.96624, 37.62248], [-120.96668, 37.62245], [-120.96805, 37.62223], [-120.96922, 37.62197], [-120.96923, 37.62201], [-120.96928, 37.62202], [-120.96968, 37.62203], [-120.96993, 37.62209], [-120.97009, 37.62211], [-120.97045, 37.6222], [-120.9706, 37.62227], [-120.97085, 37.62234], [-120.97115, 37.62249], [-120.97136, 37.62253], [-120.97151, 37.62258], [-120.97163, 37.62259], [-120.97209, 37.62284], [-120.97268, 37.62302], [-120.97377, 37.62362], [-120.97409, 37.62385], [-120.9743, 37.62397], [-120.97439, 37.62406], [-120.97473, 37.62425], [-120.97536, 37.62465], [-120.97536, 37.62596]]], [[[-120.97632, 37.62587], [-120.97555, 37.62588], [-120.97553, 37.62609], [-120.97542, 37.62609], [-120.97542, 37.62469], [-120.97564, 37.62482], [-120.97575, 37.62485], [-120.97582, 37.6249], [-120.97604, 37.62499], [-120.97604, 37.62558], [-120.97632, 37.6256], [-120.97632, 37.62587]]]]} | Open Access 1 | Legion Park | 21142 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 14.814 | Legion Park | ||
6086 | 6086 | 6085 | {"type": "Polygon", "coordinates": [[[-120.97533, 37.62623], [-120.97481, 37.62623], [-120.97482, 37.62608], [-120.97533, 37.62607], [-120.97533, 37.62623]]]} | Restricted Access 2 | Legion Park | 21143 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 0.196 | Legion Park | ||
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 | ||
6564 | 6564 | 6563 | {"type": "Polygon", "coordinates": [[[-120.97872, 37.62191], [-120.9787, 37.62486], [-120.97827, 37.62465], [-120.97688, 37.62378], [-120.97593, 37.62349], [-120.97539, 37.62304], [-120.97539, 37.62105], [-120.97594, 37.62112], [-120.97688, 37.6213], [-120.97787, 37.62188], [-120.97872, 37.62191]]]} | Open Access 1 | Mancini Park | 21732 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 20.055 | Mancini Park | ||
6565 | 6565 | 6564 | {"type": "Polygon", "coordinates": [[[-120.97835, 37.62482], [-120.97835, 37.6252], [-120.97609, 37.62409], [-120.9755, 37.62372], [-120.97562, 37.62339], [-120.97585, 37.62358], [-120.97681, 37.62388], [-120.97819, 37.62474], [-120.97835, 37.62482]]]} | Restricted Access 2 | Mancini Park | 21733 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 3.106 | Mancini Park | ||
6592 | 6592 | 6591 | {"type": "MultiPolygon", "coordinates": [[[[-120.97023, 37.62482], [-120.97022, 37.62563], [-120.96975, 37.62563], [-120.96973, 37.62527], [-120.96906, 37.62527], [-120.96906, 37.62492], [-120.96944, 37.62487], [-120.96964, 37.62479], [-120.9698, 37.62476], [-120.96997, 37.62477], [-120.97023, 37.62482]]], [[[-120.97081, 37.62564], [-120.97036, 37.62563], [-120.97037, 37.62486], [-120.97081, 37.62495], [-120.97081, 37.62564]]]]} | Open Access 1 | Orville Wright Park / George Rogers Park | 23230 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 2.47 | Orville Wright Park / George Rogers 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 | ||
6797 | 6797 | 6796 | {"type": "Polygon", "coordinates": [[[-120.99511, 37.64303], [-120.99476, 37.64329], [-120.99458, 37.64314], [-120.99494, 37.64288], [-120.99511, 37.64303]]]} | Open Access 1 | McClatchy Rose Garden | 21998 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 0.244 | McClatchy Rose Garden | ||
6800 | 6800 | 6799 | {"type": "Polygon", "coordinates": [[[-120.93016, 37.6523], [-120.92947, 37.65269], [-120.92127, 37.65274], [-120.92127, 37.65251], [-120.92223, 37.65239], [-120.92764, 37.65119], [-120.92985, 37.65081], [-120.93014, 37.65079], [-120.93016, 37.6523]]]} | Open Access 1 | McClure Country Place | 22002 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 22.88 | McClure Country Place | ||
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 | ||
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 | ||
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 | ||
7084 | 7084 | 7083 | {"type": "Polygon", "coordinates": [[[-120.97873, 37.64514], [-120.97864, 37.64523], [-120.97846, 37.64535], [-120.97815, 37.64548], [-120.97793, 37.64552], [-120.97788, 37.6455], [-120.97788, 37.64545], [-120.97793, 37.64541], [-120.97866, 37.6451], [-120.97872, 37.64511], [-120.97873, 37.64514]]]} | Open Access 1 | Modesto holding 2 | 22338 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 0.289 | Modesto holding 2 | ||
7195 | 7195 | 7194 | {"type": "Polygon", "coordinates": [[[-120.98458, 37.64549], [-120.98458, 37.64549], [-120.98161, 37.64548], [-120.98211, 37.64528], [-120.98286, 37.64502], [-120.98364, 37.6446], [-120.98416, 37.64434], [-120.98433, 37.64418], [-120.98447, 37.64363], [-120.98456, 37.64364], [-120.98458, 37.64549]]]} | Open Access 1 | Moose Park | 22466 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 4.785 | Moose Park | ||
7198 | 7198 | 7197 | {"type": "Polygon", "coordinates": [[[-120.96128, 37.64569], [-120.96106, 37.6457], [-120.95854, 37.6457], [-120.95836, 37.64569], [-120.95847, 37.64549], [-120.95851, 37.6453], [-120.96116, 37.64532], [-120.96128, 37.64569]]]} | Open Access 1 | Moran Estates Park | 22469 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 2.603 | Moran Estates 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 | ||
7741 | 7741 | 7740 | {"type": "Polygon", "coordinates": [[[-120.94806, 37.67448], [-120.94805, 37.67472], [-120.94802, 37.67496], [-120.9479, 37.6754], [-120.94785, 37.67585], [-120.94781, 37.67587], [-120.94512, 37.67587], [-120.94509, 37.67583], [-120.94506, 37.6743], [-120.94507, 37.67428], [-120.9451, 37.67426], [-120.94521, 37.67428], [-120.94561, 37.6744], [-120.94586, 37.67443], [-120.94801, 37.67444], [-120.94805, 37.67445], [-120.94806, 37.67448]]]} | Open Access 1 | Orchard Park | 23191 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 10.169 | Orchard Park | ||
7907 | 7907 | 7906 | {"type": "Polygon", "coordinates": [[[-120.97845, 37.64795], [-120.97801, 37.64811], [-120.97726, 37.64835], [-120.97691, 37.64844], [-120.97608, 37.64861], [-120.97561, 37.64876], [-120.97552, 37.64875], [-120.97533, 37.64881], [-120.97529, 37.64887], [-120.97511, 37.64892], [-120.97493, 37.64895], [-120.9748, 37.64899], [-120.97469, 37.64905], [-120.97097, 37.64905], [-120.97097, 37.64875], [-120.97212, 37.64848], [-120.97279, 37.64831], [-120.97417, 37.64831], [-120.97499, 37.64825], [-120.9759, 37.64803], [-120.97666, 37.64792], [-120.97692, 37.64786], [-120.9774, 37.64757], [-120.97766, 37.64736], [-120.97831, 37.64775], [-120.97845, 37.64795]]]} | Open Access 1 | Pamela Monterosso Park | 23379 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 11.359 | Pamela Monterosso 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]);