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
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | ||
4039 | 4039 | 4038 | {"type": "Polygon", "coordinates": [[[-121.00046, 37.65103], [-120.9984, 37.65099], [-120.99838, 37.64934], [-121.00044, 37.64939], [-121.00046, 37.65103]]]} | Open Access 1 | Enslen Park | 18683 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 8.228 | Enslen Park | ||
4161 | 4161 | 4160 | {"type": "Polygon", "coordinates": [[[-121.00253, 37.62066], [-121.00252, 37.62417], [-121.00205, 37.62417], [-121.00205, 37.62353], [-121.00149, 37.62352], [-121.0015, 37.62067], [-121.00253, 37.62066]]]} | Open Access 1 | Fairway Park | 18824 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 7.899 | Fairway Park | ||
4396 | 4396 | 4395 | {"type": "Polygon", "coordinates": [[[-120.93047, 37.67448], [-120.92816, 37.6745], [-120.92813, 37.67234], [-120.93044, 37.67232], [-120.93047, 37.67448]]]} | Open Access 1 | Freedom Park | 19086 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 12.076 | Freedom 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 | ||
4504 | 4504 | 4503 | {"type": "Polygon", "coordinates": [[[-120.91649, 37.65449], [-120.91471, 37.65448], [-120.9147, 37.65291], [-120.91648, 37.65291], [-120.91649, 37.65449]]]} | Open Access 1 | Garst Road Park | 19225 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 6.789 | Garst Road Park | ||
4676 | 4676 | 4675 | {"type": "Polygon", "coordinates": [[[-120.99882, 37.64919], [-120.99779, 37.64917], [-120.99774, 37.64584], [-120.99877, 37.64586], [-120.99882, 37.64919]]]} | Open Access 1 | Graceada Park | 19413 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 8.347 | Graceada Park | ||
4773 | 4773 | 4772 | {"type": "Polygon", "coordinates": [[[-120.93339, 37.69446], [-120.92994, 37.69447], [-120.92984, 37.68908], [-120.93335, 37.68906], [-120.93339, 37.69446]]]} | Open Access 1 | Grogan Park | 19528 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 45.431 | Grogan Park | ||
5092 | 5092 | 5091 | {"type": "MultiPolygon", "coordinates": [[[[-121.00826, 37.69491], [-121.00639, 37.69546], [-121.00416, 37.6961], [-121.00417, 37.69578], [-121.00813, 37.69463], [-121.00826, 37.69491]]], [[[-121.0124, 37.69371], [-121.00845, 37.69486], [-121.00832, 37.69457], [-121.0124, 37.69339], [-121.0124, 37.69371]]], [[[-121.01761, 37.69219], [-121.01578, 37.69273], [-121.01265, 37.69363], [-121.01264, 37.69331], [-121.01377, 37.69298], [-121.01751, 37.6919], [-121.01761, 37.69219]]], [[[-121.02237, 37.69086], [-121.0216, 37.69112], [-121.02161, 37.69143], [-121.01974, 37.69157], [-121.01781, 37.69213], [-121.01771, 37.69184], [-121.02069, 37.69097], [-121.0207, 37.69137], [-121.02154, 37.69138], [-121.02155, 37.69109], [-121.02237, 37.69079], [-121.02237, 37.69086]]], [[[-121.02637, 37.68964], [-121.02317, 37.69057], [-121.02251, 37.69076], [-121.0225, 37.69044], [-121.02532, 37.68962], [-121.02637, 37.68964]]], [[[-121.03142, 37.68816], [-121.02727, 37.68937], [-121.02669, 37.68937], [-121.0267, 37.68922], [-121.03142, 37.68784], [-121.03142, 37.68816]]], [[[-121.04051, 37.68552], [-121.04051, 37.68552], [-121.03168, 37.68809], [-121.03168, 37.68777], [-121.0405, 37.6852], [-121.04051, 37.68552]]], [[[-121.04968, 37.68284], [-121.04964, 37.68286], [-121.04072, 37.68546], [-121.04071, 37.68514], [-121.04967, 37.68252], [-121.04968, 37.68284]]]]} | Open Access 1 | Hetch Hetchy Trail | 19886 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 32.987 | Hetch Hetchy Trail | ||
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 | ||
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 | ||
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 | ||
5733 | 5733 | 5732 | {"type": "Polygon", "coordinates": [[[-120.98447, 37.64363], [-120.98433, 37.64418], [-120.98416, 37.64434], [-120.98364, 37.6446], [-120.98285, 37.64502], [-120.98211, 37.64528], [-120.98161, 37.64548], [-120.98116, 37.64563], [-120.98005, 37.6461], [-120.98004, 37.64555], [-120.98018, 37.64547], [-120.98046, 37.64543], [-120.98057, 37.64537], [-120.98082, 37.64513], [-120.98107, 37.64505], [-120.98154, 37.64499], [-120.98168, 37.64493], [-120.98158, 37.64453], [-120.98168, 37.64427], [-120.98203, 37.6441], [-120.98253, 37.64376], [-120.98276, 37.64367], [-120.98302, 37.64362], [-120.98447, 37.64363]]]} | Open Access 1 | Kewin Park | 20639 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 9.607 | Kewin Park | ||
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 | ||
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 |
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]);