superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
84 rows where MNG_AGENCY = 510 sorted by ACRES
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | ||
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 | ||
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 | ||
10 | 10 | 9 | {"type": "Polygon", "coordinates": [[[-120.98579, 37.65634], [-120.9858, 37.65675], [-120.98577, 37.65684], [-120.98545, 37.65716], [-120.98541, 37.65717], [-120.98537, 37.65716], [-120.98535, 37.65713], [-120.98535, 37.65634], [-120.98538, 37.65633], [-120.98577, 37.65633], [-120.98579, 37.65634]]]} | Open Access 1 | Asby Park | 15644 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 0.745 | Asby Park | ||
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 | ||
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 | ||
3940 | 3940 | 3939 | {"type": "Polygon", "coordinates": [[[-121.00163, 37.65153], [-121.00069, 37.65168], [-121.00067, 37.65118], [-121.00163, 37.6512], [-121.00163, 37.65153]]]} | Open Access 1 | Elk Park | 18565 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 0.966 | Elk Park | ||
2296 | 2296 | 2295 | {"type": "MultiPolygon", "coordinates": [[[[-120.98486, 37.63968], [-120.98485, 37.63968], [-120.98462, 37.63914], [-120.98459, 37.63898], [-120.98438, 37.63858], [-120.98435, 37.63825], [-120.98473, 37.63825], [-120.98486, 37.63968]]], [[[-120.98581, 37.64139], [-120.98592, 37.64161], [-120.98595, 37.64173], [-120.98597, 37.64196], [-120.98595, 37.64219], [-120.98591, 37.64231], [-120.9858, 37.64253], [-120.98578, 37.64254], [-120.98574, 37.64252], [-120.98569, 37.6423], [-120.98567, 37.64207], [-120.98567, 37.64185], [-120.9857, 37.64162], [-120.98575, 37.6414], [-120.98577, 37.64138], [-120.98581, 37.64139]]]]} | Open Access 1 | Brookway Park | 16438 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1.408 | Brookway 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 | ||
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 | ||
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 | ||
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 | ||
5572 | 5572 | 5571 | {"type": "Polygon", "coordinates": [[[-120.98788, 37.65467], [-120.98785, 37.65481], [-120.98776, 37.65494], [-120.98697, 37.65568], [-120.98692, 37.6557], [-120.98688, 37.65569], [-120.98635, 37.65533], [-120.98625, 37.65524], [-120.98621, 37.65516], [-120.98619, 37.65507], [-120.98619, 37.65466], [-120.98621, 37.65464], [-120.98784, 37.65464], [-120.98788, 37.65467]]]} | Open Access 1 | John Muir Park | 20459 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 2.91 | John Muir 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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 |
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]);