superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
84 rows where MNG_AGENCY = 510
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3080 | 3080 | 3079 | {"type": "Polygon", "coordinates": [[[-120.97023, 37.67442], [-120.96913, 37.67442], [-120.9691, 37.67259], [-120.96911, 37.67256], [-120.96916, 37.67255], [-120.96973, 37.67261], [-120.9702, 37.67263], [-120.97023, 37.67442]]]} | Open Access 1 | Coleman F. Brown Park | 17490 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 4.878 | Coleman F. Brown Park | ||
3148 | 3148 | 3147 | {"type": "Polygon", "coordinates": [[[-120.9277, 37.64658], [-120.92721, 37.64638], [-120.92685, 37.64626], [-120.92666, 37.64622], [-120.92627, 37.64618], [-120.92623, 37.64616], [-120.92622, 37.64493], [-120.92626, 37.64491], [-120.92768, 37.6449], [-120.9277, 37.64658]]]} | Open Access 1 | Creekwood Park | 17789 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 5.021 | Creekwood Park | ||
3458 | 3458 | 3457 | {"type": "Polygon", "coordinates": [[[-121.00784, 37.68195], [-121.00423, 37.68189], [-121.00419, 37.68185], [-121.00418, 37.68101], [-121.00418, 37.68091], [-121.00422, 37.6807], [-121.00431, 37.68051], [-121.00437, 37.68042], [-121.00451, 37.68026], [-121.00479, 37.68005], [-121.00501, 37.67995], [-121.00514, 37.67991], [-121.00541, 37.67985], [-121.00659, 37.67971], [-121.00685, 37.67964], [-121.0071, 37.67954], [-121.00732, 37.6794], [-121.00751, 37.67924], [-121.00767, 37.67905], [-121.0078, 37.67879], [-121.00784, 37.68195]]]} | Open Access 1 | Davis Community Park | 17946 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 18.933 | Davis Community Park | ||
3694 | 3694 | 3693 | {"type": "MultiPolygon", "coordinates": [[[[-120.97295, 37.6604], [-120.97281, 37.66074], [-120.9727, 37.66088], [-120.97261, 37.66095], [-120.9725, 37.66102], [-120.97231, 37.66108], [-120.97218, 37.6611], [-120.97182, 37.66109], [-120.9718, 37.66106], [-120.97179, 37.66059], [-120.97175, 37.66045], [-120.97167, 37.66036], [-120.97157, 37.66029], [-120.97145, 37.66024], [-120.97131, 37.66022], [-120.97118, 37.66023], [-120.97109, 37.66025], [-120.97108, 37.65921], [-120.97126, 37.65948], [-120.97137, 37.65961], [-120.97162, 37.65984], [-120.97177, 37.65994], [-120.97209, 37.66011], [-120.97245, 37.66023], [-120.97292, 37.66036], [-120.97295, 37.6604]]], [[[-120.97549, 37.66111], [-120.97547, 37.66114], [-120.97541, 37.66114], [-120.97529, 37.661], [-120.97515, 37.66089], [-120.975, 37.66078], [-120.97467, 37.66059], [-120.9743, 37.66046], [-120.97238, 37.65995], [-120.97223, 37.65989], [-120.97195, 37.65974], [-120.97171, 37.65955], [-120.9716, 37.65944], [-120.97143, 37.65921], [-120.97131, 37.65896], [-120.97127, 37.65883], [-120.97123, 37.65856], [-120.97439, 37.65856], [-120.97441, 37.65991], [-120.97548, 37.65992], [-120.97549, 37.66111]]]]} | Open Access 1 | Downey Community Park | 18254 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 16.394 | Downey Community Park | ||
3716 | 3716 | 3715 | {"type": "MultiPolygon", "coordinates": [[[[-120.95701, 37.65256], [-120.95682, 37.6526], [-120.95627, 37.65278], [-120.95603, 37.65279], [-120.9558, 37.65279], [-120.95544, 37.65261], [-120.95515, 37.65256], [-120.95503, 37.65251], [-120.95473, 37.65244], [-120.95417, 37.65217], [-120.95382, 37.65205], [-120.9535, 37.65189], [-120.95349, 37.6519], [-120.95349, 37.65194], [-120.9528, 37.6514], [-120.95268, 37.65143], [-120.95243, 37.65144], [-120.9522, 37.65133], [-120.95198, 37.65124], [-120.95188, 37.65117], [-120.95164, 37.65108], [-120.95163, 37.651], [-120.95152, 37.65096], [-120.9511, 37.65073], [-120.95075, 37.65047], [-120.95033, 37.65004], [-120.95005, 37.64959], [-120.94996, 37.64947], [-120.94982, 37.64935], [-120.94908, 37.64902], [-120.9483, 37.64864], [-120.94829, 37.64798], [-120.94834, 37.64801], [-120.94836, 37.64799], [-120.94918, 37.64837], [-120.95029, 37.64902], [-120.95085, 37.64902], [-120.95392, 37.65049], [-120.95528, 37.65085], [-120.95699, 37.65101], [-120.95701, 37.65256]]], [[[-120.9619, 37.65205], [-120.96156, 37.65207], [-120.96121, 37.65206], [-120.96053, 37.65221], [-120.96019, 37.65225], [-120.95987, 37.65225], [-120.95985, 37.65228], [-120.95951, 37.65229], [-120.9595, 37.65225], [-120.95918, 37.65217], [-120.95917, 37.65219], [-120.95883, 37.65222], [-120.95881, 37.65217], [-120.9585, 37.65221], [-120.95849, 37.65227], [-120.9577, 37.6525], [-120.95768, 37.65098], [-120.95949, 37.65086], [-120.96187, 37.64995], [-120.9619, 37.65205]]]]} | Open Access 1 | Dry Creek Park (Site) | 18282 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 46.0 | Dry Creek Park (Site) | ||
3795 | 3795 | 3794 | {"type": "Polygon", "coordinates": [[[-120.97212, 37.64848], [-120.97097, 37.64875], [-120.9708, 37.64867], [-120.97066, 37.64869], [-120.97053, 37.64864], [-120.97034, 37.64867], [-120.97005, 37.64877], [-120.96984, 37.64876], [-120.96972, 37.64879], [-120.96959, 37.6488], [-120.96944, 37.64882], [-120.96928, 37.6488], [-120.96903, 37.64882], [-120.96867, 37.64882], [-120.96764, 37.64952], [-120.96632, 37.64978], [-120.96631, 37.64974], [-120.96613, 37.64978], [-120.9658, 37.64993], [-120.9654, 37.65002], [-120.96501, 37.65018], [-120.96415, 37.65072], [-120.9635, 37.65102], [-120.96318, 37.65131], [-120.96279, 37.65182], [-120.96256, 37.65195], [-120.96222, 37.65202], [-120.9619, 37.65204], [-120.96187, 37.64949], [-120.96204, 37.64948], [-120.96225, 37.64943], [-120.96226, 37.6502], [-120.96228, 37.65021], [-120.96293, 37.65001], [-120.96333, 37.64984], [-120.96415, 37.64926], [-120.96532, 37.64901], [-120.96597, 37.6488], [-120.96631, 37.6488], [-120.96765, 37.64816], [-120.96868, 37.64787], [-120.97096, 37.6479], [-120.97211, 37.64753], [-120.97212, 37.64848]]]} | Open Access 1 | East La Loma Park | 18372 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 29.204 | East La Loma 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 | ||
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 | ||
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 | ||
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 | ||
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 |
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]);