units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
85 rows where MNG_AGENCY = 510 sorted by ACRES
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2457 | 2457 | 2456 | {"type": "Polygon", "coordinates": [[[-120.98467, 37.65083], [-120.98241, 37.65082], [-120.98242, 37.65055], [-120.98239, 37.65], [-120.98465, 37.65], [-120.98467, 37.65083]]]} | Open Access 1 | 18857 | Thomas B. Scott Park | 26306 | 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.478 | Thomas B. Scott Park | 0 | Local Park 2 | 4 | |
10454 | 10454 | 10453 | {"type": "Polygon", "coordinates": [[[-121.01984, 37.67496], [-121.01981, 37.67651], [-121.01983, 37.6767], [-121.01988, 37.67691], [-121.01984, 37.67694], [-121.01936, 37.67701], [-121.0189, 37.67702], [-121.01887, 37.67495], [-121.01984, 37.67496]]]} | Open Access 1 | 18501 | Catherine Everett Park | 16976 | 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.661 | Catherine Everett Park | 0 | Local Park 2 | 4 | |
10536 | 10536 | 10535 | {"type": "Polygon", "coordinates": [[[-120.98458, 37.64549], [-120.98458, 37.64549], [-120.98161, 37.64548], [-120.98211, 37.64528], [-120.98285, 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 | 18749 | Moose Park | 22466 | 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.785 | Moose 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 | |
10579 | 10579 | 10578 | {"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 | 18838 | Standiford Park | 25783 | 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.842 | Standiford Park | 0 | Local Park 2 | 4 | |
10513 | 10513 | 10512 | {"type": "Polygon", "coordinates": [[[-120.94414, 37.65653], [-120.94416, 37.6582], [-120.94411, 37.65822], [-120.94297, 37.65822], [-120.94294, 37.65653], [-120.94414, 37.65653]]]} | Open Access 1 | 18671 | Lakewood Park | 20989 | 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.864 | Lakewood Park | 0 | Local Park 2 | 4 | |
2371 | 2371 | 2370 | {"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 | 18548 | Coleman F. Brown Park | 17490 | 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.879 | Coleman F. Brown Park | 0 | Local Park 2 | 4 | |
10612 | 10612 | 10611 | {"type": "Polygon", "coordinates": [[[-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], [-120.99893, 37.68259], [-120.99886, 37.68315], [-120.99884, 37.68319], [-120.99878, 37.68326], [-120.99876, 37.68331], [-120.99877, 37.68336], [-120.99882, 37.68341], [-120.99887, 37.68344], [-120.99893, 37.68345]]]} | Open Access 1 | 18898 | Woodrow Park | 27736 | 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.973 | Woodrow Park | 0 | Local Park 2 | 4 | |
10583 | 10583 | 10582 | {"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 | 18843 | Stockard Coffee Park | 25854 | 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.004 | Stockard Coffee Park | 0 | Local Park 2 | 4 | |
10476 | 10476 | 10475 | {"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 | 18560 | Creekwood Park | 17789 | 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.022 | Creekwood Park | 0 | Local Park 2 | 4 | |
10434 | 10434 | 10433 | {"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 | 18593 | Eisenhut Park | 18476 | 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.025 | Eisenhut Park | 0 | Local Park 2 | 4 | |
2762 | 2762 | 2761 | {"type": "Polygon", "coordinates": [[[-121.0241, 37.69426], [-121.02375, 37.69426], [-121.02374, 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 | 18461 | Aqueduct Park | 15550 | 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.048 | Aqueduct Park | 0 | Local Park 2 | 4 | |
10585 | 10585 | 10584 | {"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 | 18853 | Sylvan Park | 26149 | 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.073 | Sylvan Park | 0 | Local Park 2 | 4 | |
2773 | 2773 | 2772 | {"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 | 18509 | Chrysler 99 Park | 17235 | 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.253 | Chrysler 99 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 | |
10572 | 10572 | 10571 | {"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 | 18829 | Sipherd Park | 25520 | 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.614 | Sipherd Park | 0 | Local Park 2 | 4 | |
2421 | 2421 | 2420 | {"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 | 18722 | Mckinney Colony Park | 22051 | 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.838 | Mckinney Colony Park | 0 | Local Park 2 | 4 | |
10568 | 10568 | 10567 | {"type": "Polygon", "coordinates": [[[-120.98509, 37.68491], [-120.98472, 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 | 18823 | Sherwood Park | 25401 | 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.916 | Sherwood 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 | |
2814 | 2814 | 2813 | {"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 | 18645 | J.M. Pike Park | 20295 | 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.063 | J.M. Pike 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]);