units_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 UNIT_ID
This data as json, copyable, CSV (advanced)
DES_TP 4
MNG_AG_TYP 1
- City Agency 58
MNG_AGENCY 1
- Modesto, City of · 58 ✖
ACCESS_TYP 1
- Open Access · 58 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2379 | 2379 | 2378 | {"type": "Polygon", "coordinates": [[[-120.97212, 37.64848], [-120.97097, 37.64875], [-120.9708, 37.64866], [-120.97066, 37.64869], [-120.97053, 37.64864], [-120.97034, 37.64867], [-120.97005, 37.64877], [-120.96984, 37.64876], [-120.96972, 37.64879], [-120.96959, 37.6488], [-120.96944, 37.64882], [-120.96928, 37.6488], [-120.96903, 37.64882], [-120.96867, 37.64882], [-120.96764, 37.64952], [-120.96632, 37.64978], [-120.96631, 37.64974], [-120.96613, 37.64978], [-120.9658, 37.64993], [-120.9654, 37.65002], [-120.96501, 37.65018], [-120.96415, 37.65072], [-120.9635, 37.65102], [-120.96318, 37.65131], [-120.96279, 37.65182], [-120.96256, 37.65195], [-120.96222, 37.65202], [-120.9619, 37.65204], [-120.96187, 37.64949], [-120.96204, 37.64948], [-120.96225, 37.64943], [-120.96226, 37.6502], [-120.96227, 37.65021], [-120.96293, 37.65001], [-120.96333, 37.64984], [-120.96415, 37.64926], [-120.96532, 37.64901], [-120.96597, 37.6488], [-120.96631, 37.6488], [-120.96765, 37.64816], [-120.96868, 37.64787], [-120.97096, 37.6479], [-120.97211, 37.64753], [-120.97212, 37.64848]]]} | Open Access 1 | 18589 | East La Loma Park | 18372 | 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 | 29.203 | East La Loma 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 | |
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 | |
10495 | 10495 | 10494 | {"type": "Polygon", "coordinates": [[[-121.00046, 37.65103], [-120.9984, 37.65099], [-120.99838, 37.64934], [-121.00044, 37.64939], [-121.00046, 37.65103]]]} | Open Access 1 | 18601 | Enslen Park | 18683 | 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.229 | Enslen Park | 0 | Local Park 2 | 4 | |
2386 | 2386 | 2385 | {"type": "Polygon", "coordinates": [[[-121.00253, 37.62066], [-121.00252, 37.62417], [-121.00205, 37.62417], [-121.00205, 37.62353], [-121.00149, 37.62352], [-121.0015, 37.62067], [-121.00253, 37.62066]]]} | Open Access 1 | 18606 | Fairway Park | 18824 | 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.896 | Fairway Park | 0 | Local Park 2 | 4 | |
2387 | 2387 | 2386 | {"type": "Polygon", "coordinates": [[[-120.93047, 37.67448], [-120.92816, 37.6745], [-120.92813, 37.67234], [-120.93044, 37.67232], [-120.93047, 37.67448]]]} | Open Access 1 | 18611 | Freedom Park | 19086 | 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 | 12.078 | Freedom 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 | |
10492 | 10492 | 10491 | {"type": "Polygon", "coordinates": [[[-120.91649, 37.65449], [-120.91471, 37.65448], [-120.9147, 37.65291], [-120.91648, 37.65291], [-120.91649, 37.65449]]]} | Open Access 1 | 18619 | Garst Road Park | 19225 | 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.79 | Garst Road Park | 0 | Local Park 2 | 4 | |
10498 | 10498 | 10497 | {"type": "Polygon", "coordinates": [[[-120.99882, 37.64919], [-120.99779, 37.64917], [-120.99774, 37.64584], [-120.99877, 37.64586], [-120.99882, 37.64919]]]} | Open Access 1 | 18622 | Graceada Park | 19413 | 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.348 | Graceada 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 | |
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 | |
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 | |
10510 | 10510 | 10509 | {"type": "Polygon", "coordinates": [[[-120.98621, 37.65464], [-120.98784, 37.65464], [-120.98788, 37.65467], [-120.98785, 37.65481], [-120.98776, 37.65494], [-120.98697, 37.65568], [-120.98692, 37.6557], [-120.98688, 37.65569], [-120.98635, 37.65533], [-120.98625, 37.65524], [-120.98621, 37.65516], [-120.98619, 37.65507], [-120.98619, 37.65466], [-120.98621, 37.65464]]]} | Open Access 1 | 18657 | John Muir Park | 20459 | 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.91 | John Muir Park | 0 | Local Park 2 | 4 | |
2403 | 2403 | 2402 | {"type": "Polygon", "coordinates": [[[-120.98447, 37.64363], [-120.98433, 37.64418], [-120.98416, 37.64434], [-120.98364, 37.6446], [-120.98285, 37.64502], [-120.98211, 37.64528], [-120.98161, 37.64548], [-120.98116, 37.64563], [-120.98005, 37.6461], [-120.98004, 37.64555], [-120.98018, 37.64547], [-120.98046, 37.64543], [-120.98057, 37.64537], [-120.98082, 37.64513], [-120.98107, 37.64505], [-120.98155, 37.64499], [-120.98169, 37.64493], [-120.98158, 37.64453], [-120.98168, 37.64427], [-120.98203, 37.6441], [-120.98253, 37.64376], [-120.98276, 37.64367], [-120.98302, 37.64362], [-120.98447, 37.64363]]]} | Open Access 1 | 18662 | Kewin Park | 20639 | 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.604 | Kewin 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 | |
2411 | 2411 | 2410 | {"type": "Polygon", "coordinates": [[[-120.95264, 37.64545], [-120.9483, 37.64545], [-120.94823, 37.64529], [-120.95262, 37.64529], [-120.95264, 37.64545]]]} | Open Access 1 | 18678 | Lateral No. 2 Park | 21076 | 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 | 1.694 | Lateral No. 2 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 | |
2830 | 2830 | 2829 | {"type": "Polygon", "coordinates": [[[-120.97872, 37.62191], [-120.9787, 37.62486], [-120.97827, 37.62465], [-120.97688, 37.62378], [-120.97593, 37.62349], [-120.97539, 37.62304], [-120.97539, 37.62105], [-120.97594, 37.62112], [-120.97688, 37.6213], [-120.97787, 37.62188], [-120.97872, 37.62191]]]} | Open Access 1 | 18697 | Mancini Park | 21732 | 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.054 | Mancini 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 | |
2831 | 2831 | 2830 | {"type": "Polygon", "coordinates": [[[-120.99511, 37.64303], [-120.99476, 37.64329], [-120.99458, 37.64314], [-120.99494, 37.64288], [-120.99511, 37.64303]]]} | Open Access 1 | 18710 | McClatchy Rose Garden | 21998 | 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.244 | McClatchy Rose Garden | 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]);