superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
23 rows where MNG_AGENCY = 410 sorted by map descending
This data as json, copyable, CSV (advanced)
Link | rowid | id | map ▲ | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7208 | 7208 | 7207 | {"type": "Polygon", "coordinates": [[[-121.67307, 37.12075], [-121.67269, 37.1219], [-121.6661, 37.12198], [-121.6661, 37.12148], [-121.66669, 37.12121], [-121.66665, 37.121], [-121.66731, 37.12079], [-121.66731, 37.12073], [-121.66735, 37.12071], [-121.66764, 37.12122], [-121.66799, 37.12105], [-121.66799, 37.12067], [-121.66792, 37.12033], [-121.66765, 37.12036], [-121.66754, 37.12016], [-121.66758, 37.11983], [-121.66702, 37.11999], [-121.66738, 37.11973], [-121.6674, 37.11966], [-121.66739, 37.1196], [-121.66736, 37.11954], [-121.66718, 37.11941], [-121.66712, 37.11933], [-121.66708, 37.11925], [-121.66667, 37.11941], [-121.66669, 37.11947], [-121.66618, 37.11962], [-121.6658, 37.11892], [-121.66479, 37.1192], [-121.66477, 37.11877], [-121.66592, 37.11804], [-121.66555, 37.11732], [-121.67204, 37.11703], [-121.67277, 37.11831], [-121.67107, 37.11884], [-121.67307, 37.12075]], [[-121.66687, 37.11787], [-121.66668, 37.11788], [-121.66653, 37.1179], [-121.66628, 37.11813], [-121.66658, 37.1186], [-121.66789, 37.1186], [-121.66768, 37.11842], [-121.6675, 37.11814], [-121.66734, 37.11795], [-121.66723, 37.11788], [-121.66687, 37.11787]]]} | Open Access 1 | Morgan Hill holding 4 | 22483 | 1217 | Morgan Hill, City of 410 | City 2 | City Agency 2 | http://www.morgan-hill.ca.gov/index.aspx?nid=187 | City 2 | 67.371 | Morgan Hill holding 4 | ||
7275 | 7275 | 7274 | {"type": "Polygon", "coordinates": [[[-121.67256, 37.14164], [-121.6723, 37.14182], [-121.67205, 37.14183], [-121.67193, 37.1418], [-121.67196, 37.14175], [-121.67196, 37.14169], [-121.67191, 37.14163], [-121.67184, 37.1416], [-121.67222, 37.14133], [-121.67256, 37.14164]]]} | Open Access 1 | Murphy Spring Park | 22610 | 1217 | Morgan Hill, City of 410 | City 2 | City Agency 2 | http://www.morgan-hill.ca.gov/index.aspx?nid=187 | City 2 | 0.498 | Murphy Spring Park | ||
4353 | 4353 | 4352 | {"type": "Polygon", "coordinates": [[[-121.66901, 37.14031], [-121.66901, 37.14031], [-121.66891, 37.14072], [-121.66879, 37.1406], [-121.66881, 37.14056], [-121.66865, 37.14041], [-121.66888, 37.14025], [-121.66894, 37.14029], [-121.66901, 37.14031]]]} | Open Access 1 | Fox Hollow Park | 19033 | 1217 | Morgan Hill, City of 410 | City 2 | City Agency 2 | http://www.morgan-hill.ca.gov/index.aspx?nid=187 | City 2 | 0.201 | Fox Hollow Park | ||
9250 | 9250 | 9249 | {"type": "Polygon", "coordinates": [[[-121.66662, 37.14388], [-121.66644, 37.14397], [-121.66622, 37.14372], [-121.66639, 37.14362], [-121.66662, 37.14388]]]} | Open Access 1 | Sanchez Park | 25007 | 1217 | Morgan Hill, City of 410 | City 2 | City Agency 2 | http://www.morgan-hill.ca.gov/index.aspx?nid=187 | City 2 | 0.162 | Sanchez Park | ||
3000 | 3000 | 2999 | {"type": "Polygon", "coordinates": [[[-121.66244, 37.12502], [-121.66156, 37.1255], [-121.66085, 37.12469], [-121.66099, 37.12461], [-121.66139, 37.12504], [-121.6616, 37.12494], [-121.66161, 37.12492], [-121.66121, 37.12449], [-121.66172, 37.12421], [-121.66186, 37.12436], [-121.6615, 37.12456], [-121.66174, 37.12484], [-121.66211, 37.12466], [-121.66244, 37.12502]]]} | Open Access 1 | Civic Centre/City Hall | 17371 | 1217 | Morgan Hill, City of 410 | City 2 | City Agency 2 | http://www.morgan-hill.ca.gov/index.aspx?nid=187 | City 2 | 1.851 | Civic Centre/City Hall | ||
4472 | 4472 | 4471 | {"type": "Polygon", "coordinates": [[[-121.66121, 37.12869], [-121.66058, 37.12905], [-121.6612, 37.12976], [-121.66092, 37.12991], [-121.661, 37.13003], [-121.6603, 37.13041], [-121.65945, 37.12943], [-121.66024, 37.12898], [-121.65983, 37.12848], [-121.66064, 37.12803], [-121.66121, 37.12869]]]} | Open Access 1 | Galvan Park | 19182 | 1217 | Morgan Hill, City of 410 | City 2 | City Agency 2 | http://www.morgan-hill.ca.gov/index.aspx?nid=187 | City 2 | 5.269 | Galvan Park | ||
7206 | 7206 | 7205 | {"type": "Polygon", "coordinates": [[[-121.65749, 37.1112], [-121.65414, 37.11244], [-121.65222, 37.10909], [-121.65533, 37.10739], [-121.65749, 37.1112]]]} | Open Access 1 | Morgan Hill holding 1 | 22480 | 1217 | Morgan Hill, City of 410 | City 2 | City Agency 2 | http://www.morgan-hill.ca.gov/index.aspx?nid=187 | City 2 | 35.474 | Morgan Hill holding 1 | ||
7207 | 7207 | 7206 | {"type": "Polygon", "coordinates": [[[-121.65067, 37.11677], [-121.65066, 37.11682], [-121.65062, 37.11685], [-121.64923, 37.11735], [-121.64827, 37.11568], [-121.64669, 37.11625], [-121.64579, 37.11463], [-121.64631, 37.11444], [-121.64626, 37.11431], [-121.6473, 37.11393], [-121.64642, 37.11231], [-121.64774, 37.11159], [-121.65067, 37.11677]]]} | Open Access 1 | Morgan Hill holding 3 | 22482 | 1217 | Morgan Hill, City of 410 | City 2 | City Agency 2 | http://www.morgan-hill.ca.gov/index.aspx?nid=187 | City 2 | 29.908 | Morgan Hill holding 3 | ||
7934 | 7934 | 7933 | {"type": "Polygon", "coordinates": [[[-121.64828, 37.10579], [-121.64748, 37.10612], [-121.64742, 37.10609], [-121.64659, 37.10644], [-121.64631, 37.10659], [-121.64608, 37.10646], [-121.64595, 37.10656], [-121.64579, 37.10674], [-121.64568, 37.10693], [-121.64561, 37.10712], [-121.64413, 37.10621], [-121.64433, 37.106], [-121.64464, 37.10572], [-121.64511, 37.10523], [-121.64597, 37.10576], [-121.64601, 37.10576], [-121.64605, 37.10582], [-121.64615, 37.10585], [-121.64616, 37.10588], [-121.64646, 37.10607], [-121.64784, 37.10551], [-121.64828, 37.10579]]]} | Open Access 1 | Paradise Park | 23404 | 1217 | Morgan Hill, City of 410 | City 2 | City Agency 2 | http://www.morgan-hill.ca.gov/index.aspx?nid=187 | City 2 | 7.217 | Paradise Park | ||
5273 | 5273 | 5272 | {"type": "Polygon", "coordinates": [[[-121.64709, 37.09922], [-121.64706, 37.09934], [-121.64706, 37.09946], [-121.64669, 37.09948], [-121.64672, 37.09963], [-121.64643, 37.09996], [-121.64637, 37.09995], [-121.64636, 37.09981], [-121.64618, 37.09961], [-121.64669, 37.09909], [-121.64709, 37.09922]]]} | Open Access 1 | Howard Wiechert Park | 20120 | 1217 | Morgan Hill, City of 410 | City 2 | City Agency 2 | http://www.morgan-hill.ca.gov/index.aspx?nid=187 | City 2 | 0.858 | Howard Wiechert Park | ||
1931 | 1931 | 1930 | {"type": "Polygon", "coordinates": [[[-121.6469, 37.13309], [-121.64667, 37.13327], [-121.64624, 37.13293], [-121.6465, 37.13273], [-121.6468, 37.13287], [-121.64679, 37.13293], [-121.6468, 37.13298], [-121.64682, 37.13303], [-121.6469, 37.13309]]]} | Open Access 1 | Belle Estates Park | 15983 | 1217 | Morgan Hill, City of 410 | City 2 | City Agency 2 | http://www.morgan-hill.ca.gov/index.aspx?nid=187 | City 2 | 0.45 | Belle Estates Park | ||
3610 | 3610 | 3609 | {"type": "Polygon", "coordinates": [[[-121.6459, 37.13321], [-121.64586, 37.13323], [-121.64561, 37.13304], [-121.6455, 37.13307], [-121.64544, 37.13301], [-121.64546, 37.13291], [-121.64496, 37.13251], [-121.64488, 37.13255], [-121.64481, 37.1325], [-121.64484, 37.13242], [-121.64458, 37.13221], [-121.64429, 37.13246], [-121.64366, 37.13194], [-121.64382, 37.13179], [-121.64336, 37.13141], [-121.64389, 37.13099], [-121.64494, 37.13184], [-121.64476, 37.13199], [-121.64462, 37.13217], [-121.64483, 37.13234], [-121.64495, 37.13231], [-121.64501, 37.13236], [-121.64498, 37.13246], [-121.6455, 37.13289], [-121.64561, 37.13285], [-121.64568, 37.1329], [-121.64565, 37.13301], [-121.6459, 37.13321]]]} | Open Access 1 | Diana Park | 18149 | 1217 | Morgan Hill, City of 410 | City 2 | City Agency 2 | http://www.morgan-hill.ca.gov/index.aspx?nid=187 | City 2 | 3.02 | Diana Park | ||
4858 | 4858 | 4857 | {"type": "Polygon", "coordinates": [[[-121.64558, 37.09725], [-121.64557, 37.09729], [-121.64551, 37.09736], [-121.64537, 37.09739], [-121.6453, 37.09744], [-121.64528, 37.09747], [-121.64529, 37.09752], [-121.64534, 37.09758], [-121.64513, 37.0978], [-121.64468, 37.09751], [-121.64467, 37.09747], [-121.64508, 37.09703], [-121.64513, 37.09701], [-121.64518, 37.09701], [-121.64536, 37.09709], [-121.64555, 37.09721], [-121.64558, 37.09725]]]} | Open Access 1 | Hamilton Square Park | 19623 | 1217 | Morgan Hill, City of 410 | City 2 | City Agency 2 | http://www.morgan-hill.ca.gov/index.aspx?nid=187 | City 2 | 0.915 | Hamilton Square Park | ||
7547 | 7547 | 7546 | {"type": "Polygon", "coordinates": [[[-121.64487, 37.09478], [-121.64468, 37.09501], [-121.64458, 37.09509], [-121.6444, 37.09489], [-121.64423, 37.09497], [-121.6442, 37.09494], [-121.64405, 37.09502], [-121.64402, 37.095], [-121.64371, 37.09508], [-121.64355, 37.09496], [-121.64319, 37.09482], [-121.64324, 37.09467], [-121.64317, 37.09458], [-121.64293, 37.0946], [-121.64271, 37.09471], [-121.64235, 37.09421], [-121.64245, 37.09411], [-121.64248, 37.09405], [-121.6426, 37.09403], [-121.64302, 37.09428], [-121.64313, 37.09432], [-121.64322, 37.09432], [-121.6433, 37.0943], [-121.64347, 37.09416], [-121.64379, 37.0943], [-121.64421, 37.09447], [-121.64428, 37.09449], [-121.64432, 37.09455], [-121.64438, 37.09462], [-121.6445, 37.09466], [-121.64457, 37.09464], [-121.64487, 37.09478]]]} | Open Access 1 | Oak Creek Park | 22961 | 1217 | Morgan Hill, City of 410 | City 2 | City Agency 2 | http://www.morgan-hill.ca.gov/index.aspx?nid=187 | City 2 | 2.939 | Oak Creek Park | ||
597 | 597 | 596 | {"type": "Polygon", "coordinates": [[[-121.64347, 37.11265], [-121.64347, 37.11268], [-121.64305, 37.11279], [-121.64285, 37.11264], [-121.64329, 37.11251], [-121.64335, 37.1126], [-121.64341, 37.11259], [-121.64345, 37.11264], [-121.64347, 37.11265]]]} | Open Access 1 | 21 Mile Park | 15179 | 1217 | Morgan Hill, City of 410 | City 2 | City Agency 2 | http://www.morgan-hill.ca.gov/index.aspx?nid=187 | City 2 | 0.221 | 21 Mile Park | ||
8484 | 8484 | 8483 | {"type": "Polygon", "coordinates": [[[-121.6429, 37.1305], [-121.64288, 37.13055], [-121.64237, 37.13094], [-121.64221, 37.13103], [-121.64216, 37.13104], [-121.64212, 37.13102], [-121.64196, 37.13076], [-121.64197, 37.1307], [-121.64251, 37.1304], [-121.64274, 37.13031], [-121.6428, 37.13031], [-121.64284, 37.13034], [-121.6429, 37.1305]]]} | Open Access 1 | Stone Creek Park | 25868 | 1217 | Morgan Hill, City of 410 | City 2 | City Agency 2 | http://www.morgan-hill.ca.gov/index.aspx?nid=187 | City 2 | 0.836 | Stone Creek Park | ||
6973 | 6973 | 6972 | {"type": "Polygon", "coordinates": [[[-121.64065, 37.1039], [-121.64056, 37.10414], [-121.64046, 37.10431], [-121.64045, 37.10439], [-121.64031, 37.10449], [-121.6399, 37.1043], [-121.63994, 37.10411], [-121.63996, 37.10391], [-121.63997, 37.10388], [-121.64001, 37.10386], [-121.64056, 37.10383], [-121.64063, 37.10385], [-121.64065, 37.1039]]]} | Open Access 1 | Mill Creek Park | 22225 | 1217 | Morgan Hill, City of 410 | City 2 | City Agency 2 | http://www.morgan-hill.ca.gov/index.aspx?nid=187 | City 2 | 0.852 | Mill Creek Park | ||
7414 | 7414 | 7413 | {"type": "Polygon", "coordinates": [[[-121.62906, 37.13497], [-121.62792, 37.13541], [-121.62717, 37.13417], [-121.62832, 37.13373], [-121.62838, 37.13373], [-121.62841, 37.13375], [-121.62854, 37.13397], [-121.62872, 37.13439], [-121.62906, 37.13497]]]} | Open Access 1 | Nordstrom Park | 22790 | 1217 | Morgan Hill, City of 410 | City 2 | City Agency 2 | http://www.morgan-hill.ca.gov/index.aspx?nid=187 | City 2 | 4.38 | Nordstrom Park | ||
12266 | 12266 | 12265 | {"type": "Polygon", "coordinates": [[[-121.62906, 37.12814], [-121.62902, 37.12819], [-121.62608, 37.1293], [-121.62373, 37.12536], [-121.62667, 37.12424], [-121.62672, 37.12423], [-121.62676, 37.12426], [-121.62906, 37.12814]]]} | Open Access 1 | Morgan Hill Outdoor Sports Center | 30696 | 1217 | Morgan Hill, City of 410 | City 2 | City Agency 2 | http://www.morgan-hill.ca.gov/index.aspx?nid=187 | City 2 | 35.374 | Morgan Hill Outdoor Sports Ctr. | ||
11827 | 11827 | 11826 | {"type": "Polygon", "coordinates": [[[-121.6207, 37.13395], [-121.61422, 37.13642], [-121.61303, 37.13444], [-121.61951, 37.13197], [-121.6207, 37.13395]]]} | Open Access 1 | San Pedro Ponds Park | https://www.museumca.org/creeks/WholeMaps/15_Morgan%20Hill%20Creek.pdf | 28471 | 1217 | Morgan Hill, City of 410 | City 2 | City Agency 2 | http://www.morgan-hill.ca.gov/index.aspx?nid=187 | City 2 | 38.443 | San Pedro Ponds Park |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);