units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
85 rows where MNG_AGENCY = 510
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2847 | 2847 | 2846 | {"type": "Polygon", "coordinates": [[[-120.96349, 37.6595], [-120.96212, 37.6595], [-120.9621, 37.65929], [-120.96209, 37.65818], [-120.96214, 37.65817], [-120.96241, 37.65818], [-120.96348, 37.65818], [-120.96349, 37.6595]]]} | Open Access 1 | 18809 | Rose Avenue Park | 24605 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 4.439 | Rose Avenue Park | 0 | Local Park 2 | 4 | |
2848 | 2848 | 2847 | {"type": "MultiPolygon", "coordinates": [[[[-120.97023, 37.62482], [-120.97022, 37.62563], [-120.96975, 37.62563], [-120.96974, 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 | 18777 | Orville Wright Park / George Rogers Park | 23230 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 2.467 | Orville Wright Park / George Rogers Park | 0 | Local Park 2 | 4 | |
2849 | 2849 | 2848 | {"type": "Polygon", "coordinates": [[[-120.98416, 37.60551], [-120.98131, 37.60551], [-120.98113, 37.60552], [-120.98079, 37.60558], [-120.9807, 37.60561], [-120.98048, 37.60564], [-120.98042, 37.6051], [-120.98416, 37.60508], [-120.98416, 37.60551]]]} | Open Access 1 | 18780 | Parklawn Park | 23444 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 3.907 | Parklawn Park | 0 | Local Park 2 | 4 | |
2852 | 2852 | 2851 | {"type": "Polygon", "coordinates": [[[-121.00528, 37.66562], [-121.00415, 37.6656], [-121.00414, 37.66569], [-121.00317, 37.66566], [-121.00316, 37.66396], [-121.00527, 37.66401], [-121.00528, 37.66562]]]} | Open Access 1 | 18802 | Roosevelt Park | 24598 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 8.445 | Roosevelt Park | 0 | Local Park 2 | 4 | |
2857 | 2857 | 2856 | {"type": "Polygon", "coordinates": [[[-121.03778, 37.64938], [-121.03551, 37.6494], [-121.03549, 37.64852], [-121.0366, 37.64803], [-121.03752, 37.64807], [-121.03777, 37.64817], [-121.03778, 37.64938]]]} | Open Access 1 | 18813 | Charles M. Sharp Park | 17140 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 6.766 | Charles M. Sharp Park | 0 | Local Park 2 | 4 | |
2860 | 2860 | 2859 | {"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 | 18834 | Sonoma Park | 25616 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 4.823 | Sonoma Park | 0 | Local Park 2 | 4 | |
2869 | 2869 | 2868 | {"type": "Polygon", "coordinates": [[[-120.92088, 37.64184], [-120.92083, 37.64294], [-120.92085, 37.6445], [-120.9177, 37.64453], [-120.9177, 37.64508], [-120.91664, 37.64509], [-120.91657, 37.64213], [-120.91894, 37.64212], [-120.91895, 37.64185], [-120.92088, 37.64184]]]} | Open Access 1 | 18851 | Sutton Community Park | 26088 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 27.309 | Sutton Community Park | 0 | Local Park 2 | 4 | |
2875 | 2875 | 2874 | {"type": "Polygon", "coordinates": [[[-121.00813, 37.69463], [-121.00552, 37.69539], [-121.00549, 37.69342], [-121.00718, 37.69344], [-121.00755, 37.69341], [-121.00758, 37.69344], [-121.00813, 37.69463]]]} | Open Access 1 | 18882 | Wesson Ranch Park | 27350 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 9.238 | Wesson Ranch Park | 0 | Local Park 2 | 4 | |
2880 | 2880 | 2879 | {"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 | 18888 | Witmore Park | 27663 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 5.303 | Witmore Park | 0 | Local Park 2 | 4 | |
3310 | 3310 | 3309 | {"type": "Polygon", "coordinates": [[[-120.94881, 37.68533], [-120.94562, 37.68533], [-120.9456, 37.68386], [-120.94879, 37.68387], [-120.94881, 37.68533]]]} | Open Access 1 | 29631 | Ustach Park | 26746 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 11.333 | Ustach Park | 0 | Local Park 2 | 4 | |
5144 | 5144 | 5143 | {"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 | 18735 | Mildred Perkins Park | 22215 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 5.938 | Mildred Perkins Park | 0 | Local Park 2 | 4 | |
5508 | 5508 | 5507 | {"type": "MultiPolygon", "coordinates": [[[[-120.97473, 37.62425], [-120.97536, 37.62465], [-120.97536, 37.62596], [-120.9748, 37.62595], [-120.9748, 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.97046, 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.97208, 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.97632, 37.62587], [-120.97554, 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 | 18682 | Legion Park | 21142 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 14.804 | Legion Park | 0 | Local Park 2 | 4 | |
5760 | 5760 | 5759 | {"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 | 18704 | Mark Twain Park | 21871 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 7.884 | Mark Twain Park | 0 | Local Park 2 | 4 | |
6430 | 6430 | 6429 | {"type": "Polygon", "coordinates": [[[-120.93045, 37.68322], [-120.92855, 37.68322], [-120.92844, 37.68321], [-120.92839, 37.68186], [-120.93044, 37.68186], [-120.93045, 37.68322]]]} | Open Access 1 | 18536 | Claus Park | 17394 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 6.684 | Claus Park | 0 | Local Park 2 | 4 | |
7187 | 7187 | 7186 | {"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 | 18597 | Elk Park | 18565 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 0.967 | Elk Park | 0 | Local Park 2 | 4 | |
7199 | 7199 | 7198 | {"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 | 34894 | Legion Park | 21143 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 0.197 | Legion Park | 0 | Local Park 2 | 4 | |
7526 | 7526 | 7525 | {"type": "Polygon", "coordinates": [[[-121.02421, 37.66503], [-121.0241, 37.6663], [-121.02215, 37.66628], [-121.02214, 37.66496], [-121.02314, 37.66497], [-121.02315, 37.66502], [-121.02421, 37.66503]]]} | Open Access 1 | 18616 | Garisson Park | 19221 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 6.303 | Garisson Park | 0 | Local Park 2 | 4 | |
9940 | 9940 | 9939 | {"type": "Polygon", "coordinates": [[[-121.02354, 37.60961], [-121.02354, 37.61087], [-121.01634, 37.61091], [-121.01632, 37.60982], [-121.02177, 37.60979], [-121.02179, 37.60913], [-121.02209, 37.60916], [-121.02354, 37.60961]]]} | Open Access 1 | 18480 | Bellenita Park | 15985 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 20.853 | Bellenita Park | 0 | Local Park 2 | 4 | |
9960 | 9960 | 9959 | {"type": "Polygon", "coordinates": [[[-121.03802, 37.68095], [-121.03655, 37.68097], [-121.03656, 37.67999], [-121.03661, 37.6798], [-121.03674, 37.67949], [-121.03688, 37.6793], [-121.03707, 37.67909], [-121.0375, 37.67881], [-121.03759, 37.67878], [-121.03777, 37.67891], [-121.03801, 37.67913], [-121.03802, 37.68095]]]} | Open Access 1 | 18520 | Chrysler Park | 17236 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 6.542 | Chrysler Park | 0 | Local Park 2 | 4 | |
10011 | 10011 | 10010 | {"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 | 18634 | Grogan Park | 19528 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 45.434 | Grogan Park | 0 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);