units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
85 rows where MNG_AGENCY = 510 sorted by map descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
10609 | 10609 | 10608 | {"type": "Polygon", "coordinates": [[[-121.04751, 37.65462], [-121.04756, 37.65464], [-121.04768, 37.65478], [-121.04778, 37.65494], [-121.04783, 37.65511], [-121.04785, 37.65529], [-121.04786, 37.6561], [-121.04783, 37.65613], [-121.04747, 37.65621], [-121.04712, 37.65624], [-121.04711, 37.65467], [-121.04724, 37.65467], [-121.04751, 37.65462]]]} | Open Access 1 | 18892 | Woodland Park | 27722 | 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.626 | Woodland 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 | |
2362 | 2362 | 2361 | {"type": "Polygon", "coordinates": [[[-121.04345, 37.67763], [-121.04306, 37.67767], [-121.04258, 37.67768], [-121.04263, 37.67694], [-121.04306, 37.67726], [-121.04345, 37.67763]]]} | Open Access 1 | 18529 | City Gate Children's Park | 17292 | 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.829 | City Gate Children's 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 | |
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 | |
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 | |
10544 | 10544 | 10543 | {"type": "Polygon", "coordinates": [[[-121.03135, 37.67873], [-121.03015, 37.67872], [-121.0297, 37.6787], [-121.02923, 37.6787], [-121.02921, 37.67799], [-121.03134, 37.67802], [-121.03135, 37.67873]]]} | Open Access 1 | 18758 | Muncy Park | 22599 | 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.646 | Muncy 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 | |
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 | |
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 | |
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 | |
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 | |
10563 | 10563 | 10562 | {"type": "Polygon", "coordinates": [[[-121.02098, 37.61548], [-121.02091, 37.61553], [-121.02089, 37.61559], [-121.02085, 37.61677], [-121.01999, 37.61678], [-121.01961, 37.61674], [-121.01873, 37.61675], [-121.01871, 37.61549], [-121.02098, 37.61548]]]} | Open Access 1 | 18798 | Robertson Road Park | 24499 | 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.652 | Robertson Road 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 | |
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 | |
10362 | 10362 | 10361 | {"type": "Polygon", "coordinates": [[[-121.01407, 37.63323], [-121.01197, 37.63323], [-121.01197, 37.63145], [-121.01405, 37.63145], [-121.01407, 37.63323]]]} | Open Access 1 | 18726 | Mellis Park | 22110 | 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.019 | Mellis Park | 0 | Local Park 2 | 4 | |
2809 | 2809 | 2808 | {"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 | 18652 | James Marshall Park | 20349 | 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.525 | James Marshall Park | 0 | Local Park 2 | 4 | |
15698 | 15698 | 15697 | {"type": "Polygon", "coordinates": [[[-121.01091, 37.61013], [-121.01091, 37.61163], [-121.01087, 37.61165], [-121.01029, 37.61165], [-121.01028, 37.61259], [-121.00951, 37.61259], [-121.0095, 37.61333], [-121.00713, 37.61333], [-121.00713, 37.6133], [-121.0069, 37.61319], [-121.00574, 37.61394], [-121.00469, 37.61511], [-121.00313, 37.61607], [-121.00289, 37.61662], [-121.00346, 37.61667], [-121.00336, 37.61699], [-121.00483, 37.617], [-121.00483, 37.61781], [-121.00413, 37.61781], [-121.00412, 37.61791], [-121.00265, 37.61791], [-121.00265, 37.61768], [-121.00264, 37.61767], [-121.00076, 37.62018], [-121.00023, 37.62069], [-120.99953, 37.62116], [-120.99932, 37.62134], [-120.99844, 37.62135], [-120.99856, 37.61961], [-120.99866, 37.61853], [-120.99872, 37.61772], [-120.9986, 37.61696], [-120.99845, 37.61648], [-120.99809, 37.61568], [-120.99824, 37.61515], [-121.00054, 37.61294], [-121.0023, 37.61183], [-121.00496, 37.61077], [-121.00724, 37.61022], [-121.00952, 37.60948], [-121.00952, 37.60976], [-121.00959, 37.60976], [-121.01091, 37.61013]]]} | Restricted Access 2 | 18585 | Dryden Park Golf Course | 33067 | 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 | 145.239 | Dryden Park GC | 0 | Local Recreation Area 3 | 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 |
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]);