units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
48 rows where ACCESS_TYP = 1, DES_TP = 2 and YR_EST = 1961
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
238 | 238 | 237 | {"type": "Polygon", "coordinates": [[[-122.30466, 37.56871], [-122.3034, 37.56958], [-122.30328, 37.56965], [-122.30262, 37.56848], [-122.30364, 37.56777], [-122.30466, 37.56871]]]} | Open Access 1 | 771 | Shoreview Park | 25430 | 1310 | San Mateo, City of 98 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | San Mateo 15 | 4.751 | Shoreview Park | 1961 | Local Park 2 | 4 | |
578 | 578 | 577 | {"type": "Polygon", "coordinates": [[[-121.898, 37.28754], [-121.89626, 37.28829], [-121.89597, 37.28788], [-121.89477, 37.2884], [-121.89439, 37.28785], [-121.89402, 37.288], [-121.89388, 37.28779], [-121.89389, 37.28775], [-121.89394, 37.28772], [-121.89732, 37.28649], [-121.89751, 37.28681], [-121.898, 37.28754]]]} | Open Access 1 | 1926 | Wallenburg Park | 27220 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 9.119 | Wallenburg Park | 1961 | Local Park 2 | 4 | |
1597 | 1597 | 1596 | {"type": "Polygon", "coordinates": [[[-122.27259, 37.52352], [-122.2725, 37.52374], [-122.27206, 37.52424], [-122.27191, 37.52437], [-122.27175, 37.52449], [-122.27154, 37.52459], [-122.2713, 37.52468], [-122.27109, 37.52473], [-122.27253, 37.52348], [-122.27259, 37.52352]]]} | Open Access 1 | 13500 | O'Donnell Park | 22947 | 1025 | Belmont, City of 198 | City 2 | City Agency 2 | http://www.belmont.gov/city-hall/park-and-recreation | City 2 | 1025 | Belmont, City of 194 | City 2 | City Agency 2 | San Mateo 15 | 0.889 | O'Donnell Park | 1961 | Local Park 2 | 4 | |
1659 | 1659 | 1658 | {"type": "Polygon", "coordinates": [[[-122.39721, 37.59372], [-122.39652, 37.59394], [-122.39638, 37.594], [-122.39628, 37.59398], [-122.39625, 37.59395], [-122.39607, 37.59348], [-122.39603, 37.59323], [-122.39648, 37.59325], [-122.39668, 37.59314], [-122.39721, 37.59372]]]} | Open Access 1 | 14302 | Rotary Park | 24691 | 1205 | Millbrae, City of 404 | City 2 | City Agency 2 | http://www.ci.millbrae.ca.us/ | City 2 | 1205 | Millbrae, City of 398 | City 2 | City Agency 2 | San Mateo 15 | 1.461 | Rotary Park | 1961 | Local Park 2 | 4 | |
1840 | 1840 | 1839 | {"type": "Polygon", "coordinates": [[[-121.99006, 37.35984], [-121.98834, 37.35985], [-121.98799, 37.35981], [-121.98766, 37.35971], [-121.98965, 37.35905], [-121.99006, 37.35984]]]} | Open Access 1 | 14139 | Machado Park | 21630 | 1318 | Santa Clara, City of 401 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | Santa Clara 19 | 2.572 | Machado Park | 1961 | Local Park 2 | 4 | |
1844 | 1844 | 1843 | {"type": "Polygon", "coordinates": [[[-122.32314, 37.54969], [-122.32289, 37.54988], [-122.3213, 37.54842], [-122.32142, 37.54837], [-122.32155, 37.54836], [-122.32166, 37.54838], [-122.32176, 37.54843], [-122.32314, 37.54969]]]} | Open Access 1 | 14083 | Borel Park | 16283 | 1310 | San Mateo, City of 98 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | San Mateo 15 | 1.55 | Borel Park | 1961 | Local Park 2 | 4 | |
1891 | 1891 | 1890 | {"type": "Polygon", "coordinates": [[[-122.08009, 37.35313], [-122.07973, 37.35313], [-122.07928, 37.35307], [-122.07906, 37.35307], [-122.079, 37.35305], [-122.07861, 37.35271], [-122.07861, 37.35243], [-122.08009, 37.35241], [-122.08009, 37.35313]]]} | Open Access 1 | 14588 | Marymeade Park | 21938 | 1186 | Los Altos, City of 451 | City 2 | City Agency 2 | http://www.losaltosca.gov/parksites | City 2 | 1186 | Los Altos, City of 445 | City 2 | City Agency 2 | Santa Clara 19 | 2.228 | Marymeade Park | 1961 | Local Park 2 | 4 | |
1896 | 1896 | 1895 | {"type": "Polygon", "coordinates": [[[-122.09518, 37.35894], [-122.09121, 37.35893], [-122.0912, 37.35811], [-122.09236, 37.35811], [-122.09238, 37.35872], [-122.09272, 37.35873], [-122.09273, 37.35883], [-122.09323, 37.35884], [-122.09324, 37.35879], [-122.09396, 37.3588], [-122.09398, 37.35834], [-122.09403, 37.35835], [-122.09404, 37.35845], [-122.09416, 37.35849], [-122.09424, 37.35849], [-122.09425, 37.35832], [-122.0942, 37.3583], [-122.0942, 37.35828], [-122.09421, 37.35826], [-122.09429, 37.35825], [-122.09518, 37.35894]]]} | Open Access 1 | 14594 | McKenzie Park | 22045 | 1186 | Los Altos, City of 451 | City 2 | City Agency 2 | http://www.losaltosca.gov/parksites | City 2 | 1186 | Los Altos, City of 445 | City 2 | City Agency 2 | Santa Clara 19 | 4.05 | McKenzie Park | 1961 | Local Park 2 | 4 | |
1948 | 1948 | 1947 | {"type": "Polygon", "coordinates": [[[-122.08948, 37.38667], [-122.08907, 37.387], [-122.08798, 37.38644], [-122.08754, 37.38612], [-122.08738, 37.38595], [-122.08726, 37.38576], [-122.08947, 37.38575], [-122.08948, 37.38667]]]} | Open Access 1 | 15025 | McKelvey Park | 22044 | 1218 | Mountain View, City of 460 | City 2 | City Agency 2 | http://www.ci.mtnview.ca.us/services/parks/default.asp | City 2 | 1218 | Mountain View, City of 453 | City 2 | City Agency 2 | Santa Clara 19 | 4.322 | McKelvey Park | 1961 | Local Park 2 | 4 | |
2668 | 2668 | 2667 | {"type": "Polygon", "coordinates": [[[-122.18195, 37.44777], [-122.18079, 37.44915], [-122.17918, 37.44823], [-122.18028, 37.44688], [-122.18195, 37.44777]]]} | Open Access 1 | 18188 | Nealon Park | 22679 | 1202 | Menlo Park, City of 221 | City 2 | City Agency 2 | http://www.menlopark.org/ | City 2 | 1202 | Menlo Park, City of 217 | City 2 | City Agency 2 | San Mateo 15 | 7.884 | Nealon Park | 1961 | Local Park 2 | 4 | |
3850 | 3850 | 3849 | {"type": "Polygon", "coordinates": [[[-122.04312, 37.34474], [-122.04168, 37.34475], [-122.04162, 37.34471], [-122.04161, 37.34172], [-122.04311, 37.34172], [-122.04312, 37.34474]]]} | Open Access 1 | 630 | Serra Park | 25315 | 1345 | Sunnyvale, City of 419 | City 2 | City Agency 2 | http://sunnyvale.ca.gov/Departments/CommunityServices/Parks.aspx | City 2 | 1345 | Sunnyvale, City of 413 | City 2 | City Agency 2 | Santa Clara 19 | 11.044 | Serra Park | 1961 | Local Park 2 | 4 | |
4226 | 4226 | 4225 | {"type": "Polygon", "coordinates": [[[-121.96487, 37.3561], [-121.96487, 37.35727], [-121.96485, 37.35732], [-121.96477, 37.35735], [-121.96353, 37.35735], [-121.96353, 37.3561], [-121.96487, 37.3561]]]} | Open Access 1 | 47793 | Warburton Park | 31670 | 1318 | Santa Clara, City of 401 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | Santa Clara 19 | 4.063 | Warburton Park | 1961 | Local Park 2 | 4 | |
5102 | 5102 | 5101 | {"type": "Polygon", "coordinates": [[[-122.24632, 37.46136], [-122.24605, 37.46148], [-122.24591, 37.46152], [-122.24588, 37.4615], [-122.24579, 37.46136], [-122.24567, 37.46123], [-122.24595, 37.46103], [-122.24632, 37.46136]]]} | Open Access 1 | 13910 | Westwood Park | 27442 | 1271 | Redwood City, City of 397 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | San Mateo 15 | 0.403 | Westwood Park | 1961 | Local Park 2 | 4 | |
5331 | 5331 | 5330 | {"type": "Polygon", "coordinates": [[[-122.19589, 37.44038], [-122.19554, 37.4408], [-122.19566, 37.44089], [-122.19538, 37.44122], [-122.19395, 37.44046], [-122.19438, 37.43994], [-122.19478, 37.44014], [-122.19494, 37.43998], [-122.19508, 37.44008], [-122.1953, 37.44011], [-122.19589, 37.44038]]]} | Open Access 1 | 15566 | Tinkers Park | 26373 | 1202 | Menlo Park, City of 221 | City 2 | City Agency 2 | http://www.menlopark.org/ | City 2 | 1202 | Menlo Park, City of 217 | City 2 | City Agency 2 | San Mateo 15 | 3.227 | Tinkers Park | 1961 | Local Park 2 | 4 | |
6018 | 6018 | 6017 | {"type": "Polygon", "coordinates": [[[-122.21204, 37.42373], [-122.21157, 37.42448], [-122.2106, 37.4243], [-122.20834, 37.42439], [-122.20823, 37.4236], [-122.20844, 37.42337], [-122.20979, 37.42308], [-122.21204, 37.42373]]]} | Open Access 1 | 700 | Sharon Park | 25363 | 1202 | Menlo Park, City of 221 | City 2 | City Agency 2 | http://www.menlopark.org/ | City 2 | 1202 | Menlo Park, City of 217 | City 2 | City Agency 2 | San Mateo 15 | 9.023 | Sharon Park | 1961 | Local Park 2 | 4 | |
6216 | 6216 | 6215 | {"type": "Polygon", "coordinates": [[[-122.44181, 37.62294], [-122.44167, 37.62295], [-122.44149, 37.62283], [-122.44155, 37.62271], [-122.44171, 37.62265], [-122.44177, 37.62264], [-122.44181, 37.62294]]]} | Open Access 1 | 14396 | Glenview Park | 19338 | 1294 | San Bruno, City of 440 | City 2 | City Agency 2 | http://www.sanbruno.ca.gov/parks_main.html | City 2 | 1294 | San Bruno, City of 434 | City 2 | City Agency 2 | San Mateo 15 | 0.16 | Glenview Park | 1961 | Local Park 2 | 4 | |
6735 | 6735 | 6734 | {"type": "Polygon", "coordinates": [[[-122.0458, 37.66526], [-122.04582, 37.66577], [-122.04507, 37.66859], [-122.04475, 37.66865], [-122.04361, 37.66881], [-122.0429, 37.66542], [-122.0458, 37.66526]]]} | Open Access 1 | 5067 | East Avenue Park | 18360 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 18.312 | East Avenue Park | 1961 | Local Park 2 | 4 | |
8383 | 8383 | 8382 | {"type": "Polygon", "coordinates": [[[-121.97573, 37.52674], [-121.97429, 37.52858], [-121.97358, 37.52821], [-121.97261, 37.52945], [-121.97162, 37.53022], [-121.97139, 37.53001], [-121.97252, 37.52912], [-121.97294, 37.52858], [-121.97255, 37.5277], [-121.97245, 37.52753], [-121.97257, 37.52748], [-121.97275, 37.52775], [-121.97308, 37.5276], [-121.97333, 37.52746], [-121.97371, 37.52723], [-121.974, 37.52699], [-121.9746, 37.52647], [-121.97479, 37.52622], [-121.97495, 37.52634], [-121.97573, 37.52674]]]} | Open Access 1 | 12979 | Blacow Park | 16146 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | Alameda 17 | 9.967 | Blacow Park | 1961 | Local Park 2 | 4 | |
8404 | 8404 | 8403 | {"type": "Polygon", "coordinates": [[[-121.96531, 37.52284], [-121.96529, 37.52287], [-121.96284, 37.52318], [-121.96261, 37.52202], [-121.9627, 37.52208], [-121.96279, 37.52207], [-121.96264, 37.52125], [-121.96266, 37.52125], [-121.96269, 37.5213], [-121.96274, 37.52134], [-121.96285, 37.52135], [-121.96292, 37.52133], [-121.96302, 37.52128], [-121.96456, 37.52108], [-121.96467, 37.52109], [-121.96475, 37.52112], [-121.96481, 37.52118], [-121.96512, 37.5216], [-121.9652, 37.52172], [-121.96526, 37.52188], [-121.96531, 37.52216], [-121.96528, 37.52259], [-121.96531, 37.52284]]]} | Open Access 1 | 13009 | Irvington Park | 20273 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | Alameda 17 | 11.073 | Irvington Park | 1961 | Local Park 2 | 4 | |
8405 | 8405 | 8404 | {"type": "Polygon", "coordinates": [[[-121.95991, 37.53298], [-121.95978, 37.53314], [-121.95949, 37.53297], [-121.95991, 37.53298], [-121.95991, 37.53298]]]} | Open Access 1 | 13011 | Irvington Plaza | 20274 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | Alameda 17 | 0.081 | Irvington Plaza | 1961 | 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]);