units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
76 rows where DES_TP = 2 and MNG_AGENCY = 510 sorted by map descending
This data as json, copyable, CSV (advanced)
ACCESS_TYP 2
MNG_AG_TYP 1
- City Agency 76
MNG_AGENCY 1
- Modesto, City of · 76 ✖
DES_TP 1
- Local Park · 76 ✖
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 | |
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 | |
10479 | 10479 | 10478 | {"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.67906], [-121.0078, 37.67879], [-121.00784, 37.68195]]]} | Open Access 1 | 18563 | Davis Community Park | 17946 | 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 | 18.936 | Davis Community 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]);