superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
78 rows where ACCESS_TYP = 1 and 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
9774 | 9774 | 9773 | {"type": "Polygon", "coordinates": [[[-120.95248, 37.66346], [-120.95127, 37.66345], [-120.95126, 37.66173], [-120.95238, 37.66173], [-120.95238, 37.66214], [-120.95227, 37.66225], [-120.95224, 37.66231], [-120.95226, 37.66237], [-120.9523, 37.66242], [-120.95237, 37.66245], [-120.95245, 37.66245], [-120.95249, 37.66287], [-120.95248, 37.66346]]]} | Open Access 1 | Sonoma Park | 25616 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 4.822 | Sonoma Park | ||
9904 | 9904 | 9903 | {"type": "Polygon", "coordinates": [[[-120.98851, 37.67448], [-120.9881, 37.6745], [-120.98785, 37.67447], [-120.98734, 37.67446], [-120.98735, 37.67276], [-120.98851, 37.67276], [-120.98851, 37.67448]]]} | Open Access 1 | Standiford Park | 25783 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 4.841 | Standiford 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 | ||
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 | ||
11404 | 11404 | 11403 | {"type": "Polygon", "coordinates": [[[-120.99901, 37.6822], [-120.99893, 37.68259], [-120.99886, 37.68315], [-120.99884, 37.68319], [-120.99878, 37.68326], [-120.99876, 37.68331], [-120.99878, 37.68336], [-120.99882, 37.68341], [-120.99887, 37.68344], [-120.99893, 37.68345], [-120.99893, 37.6837], [-120.9974, 37.68367], [-120.99741, 37.68347], [-120.99744, 37.68327], [-120.99749, 37.68307], [-120.99756, 37.68287], [-120.99765, 37.68268], [-120.99776, 37.6825], [-120.9979, 37.68233], [-120.9982, 37.682], [-120.99824, 37.682], [-120.99898, 37.68218], [-120.99901, 37.6822]]]} | Open Access 1 | Woodrow Park | 27736 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 4.973 | Woodrow Park | ||
9973 | 9973 | 9972 | {"type": "Polygon", "coordinates": [[[-120.96618, 37.6961], [-120.96506, 37.6961], [-120.965, 37.69607], [-120.96498, 37.69436], [-120.96615, 37.69434], [-120.96618, 37.6961]]]} | Open Access 1 | Stockard Coffee Park | 25854 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 5.003 | Stockard Coffee 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 | ||
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 | ||
1205 | 1205 | 1204 | {"type": "Polygon", "coordinates": [[[-121.0241, 37.69426], [-121.02375, 37.69426], [-121.02373, 37.69383], [-121.02259, 37.69381], [-121.02257, 37.69257], [-121.02258, 37.69254], [-121.02262, 37.69253], [-121.02407, 37.69255], [-121.0241, 37.69426]]]} | Open Access 1 | Aqueduct Park | 15550 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 5.052 | Aqueduct Park | ||
10197 | 10197 | 10196 | {"type": "Polygon", "coordinates": [[[-120.97312, 37.68166], [-120.9728, 37.68166], [-120.97251, 37.68162], [-120.97195, 37.68159], [-120.97189, 37.67985], [-120.97308, 37.67985], [-120.97312, 37.68166]]]} | Open Access 1 | Sylvan Park | 26149 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 5.072 | Sylvan Park | ||
2926 | 2926 | 2925 | {"type": "Polygon", "coordinates": [[[-121.04521, 37.68382], [-121.04325, 37.6844], [-121.04323, 37.68302], [-121.0452, 37.68299], [-121.04521, 37.68382]]]} | Open Access 1 | Chrysler 99 Park | 17235 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 5.251 | Chrysler 99 Park | ||
11351 | 11351 | 11350 | {"type": "Polygon", "coordinates": [[[-121.00764, 37.67588], [-121.0055, 37.67586], [-121.0055, 37.67483], [-121.00605, 37.67485], [-121.00763, 37.67485], [-121.00764, 37.67588]]]} | Open Access 1 | Witmore Park | 27663 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 5.301 | Witmore Park | ||
9702 | 9702 | 9701 | {"type": "Polygon", "coordinates": [[[-120.93243, 37.66145], [-120.93027, 37.66144], [-120.93027, 37.6603], [-120.93056, 37.66032], [-120.9306, 37.66038], [-120.93069, 37.66043], [-120.93078, 37.66042], [-120.93089, 37.66037], [-120.93182, 37.66036], [-120.93214, 37.66031], [-120.93233, 37.66052], [-120.93239, 37.66069], [-120.93242, 37.66082], [-120.93243, 37.66145]]]} | Open Access 1 | Sipherd Park | 25520 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 5.613 | Sipherd 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 | ||
9605 | 9605 | 9604 | {"type": "Polygon", "coordinates": [[[-120.98509, 37.68491], [-120.98473, 37.68487], [-120.98463, 37.68482], [-120.98454, 37.68482], [-120.98447, 37.68483], [-120.98296, 37.68481], [-120.98292, 37.68368], [-120.98508, 37.6837], [-120.98509, 37.68491]]]} | Open Access 1 | Sherwood Park | 25401 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 5.915 | Sherwood 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 | ||
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 | ||
2719 | 2719 | 2718 | {"type": "Polygon", "coordinates": [[[-121.00329, 37.63258], [-121.00254, 37.63315], [-121.00018, 37.63118], [-121.00244, 37.63123], [-121.00243, 37.63134], [-121.00238, 37.63143], [-121.00216, 37.63164], [-121.00329, 37.63258]]]} | Open Access 1 | Ceasar Chavez Park | 16988 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 6.223 | Ceasar Chavez 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 |
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]);