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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
8789 | 8789 | 8788 | {"type": "Polygon", "coordinates": [[[-120.94801, 37.64529], [-120.94714, 37.64529], [-120.94696, 37.64532], [-120.94678, 37.64537], [-120.94654, 37.64549], [-120.94479, 37.64665], [-120.94459, 37.64676], [-120.94438, 37.64684], [-120.94265, 37.64737], [-120.94262, 37.64729], [-120.94257, 37.64713], [-120.9426, 37.64708], [-120.94262, 37.64702], [-120.94261, 37.64537], [-120.94262, 37.64535], [-120.94262, 37.64515], [-120.94265, 37.64512], [-120.94291, 37.6451], [-120.94703, 37.64448], [-120.94796, 37.64447], [-120.94799, 37.64448], [-120.94801, 37.64451], [-120.94801, 37.64529]]]} | Open Access 1 | Riverside Park | 24456 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 19.738 | Riverside Park | ||
8647 | 8647 | 8646 | {"type": "Polygon", "coordinates": [[[-120.98124, 37.67141], [-120.98114, 37.67197], [-120.98114, 37.67254], [-120.98033, 37.67257], [-120.98029, 37.67274], [-120.97984, 37.67273], [-120.97983, 37.67175], [-120.98031, 37.67175], [-120.98032, 37.67146], [-120.98055, 37.67147], [-120.98079, 37.67143], [-120.98124, 37.67141]]]} | Open Access 1 | Revard Park | 24303 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 3.433 | Revard Park | ||
8135 | 8135 | 8134 | {"type": "Polygon", "coordinates": [[[-120.97202, 37.64556], [-120.97094, 37.64555], [-120.97093, 37.64535], [-120.97201, 37.64535], [-120.97202, 37.64556]]]} | Open Access 1 | Pierre Park | 23665 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 0.536 | Pierre Park | ||
7958 | 7958 | 7957 | {"type": "Polygon", "coordinates": [[[-120.98416, 37.60551], [-120.98131, 37.60551], [-120.98112, 37.60552], [-120.9807, 37.60561], [-120.98048, 37.60564], [-120.98042, 37.6051], [-120.98416, 37.60508], [-120.98416, 37.60551]]]} | Open Access 1 | Parklawn Park | 23444 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 3.91 | Parklawn 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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
1161 | 1161 | 1160 | {"type": "Polygon", "coordinates": [[[-120.9913, 37.64285], [-120.99095, 37.64312], [-120.99036, 37.64263], [-120.99071, 37.64236], [-120.9913, 37.64285]]]} | Open Access 1 | Modesto holding 1 | 22337 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 0.794 | Modesto holding 1 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 |
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]);