superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
34 rows where MNG_AGENCY = 395 sorted by YR_EST
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4194 | 4194 | 4193 | {"type": "Polygon", "coordinates": [[[-121.95471, 37.32693], [-121.95432, 37.327], [-121.95364, 37.32699], [-121.95364, 37.32676], [-121.95367, 37.32675], [-121.95377, 37.32665], [-121.95387, 37.32661], [-121.95415, 37.32662], [-121.95426, 37.3266], [-121.95437, 37.32654], [-121.95446, 37.32662], [-121.95471, 37.32662], [-121.95471, 37.32693]]]} | Open Access 1 | Thomas Barrett Park | https://www.santaclaraca.gov/Home/Components/ServiceDirectory/ServiceDirectory/4116/2654 | 33633 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 0.948 | Thomas Barrett Park | |
5515 | 5515 | 5514 | {"type": "Polygon", "coordinates": [[[-122.00473, 37.32757], [-122.00436, 37.32757], [-122.00439, 37.32751], [-122.00438, 37.32745], [-122.00433, 37.32741], [-122.00428, 37.3274], [-122.00421, 37.32742], [-122.00418, 37.32746], [-122.00417, 37.3275], [-122.0042, 37.32757], [-122.00268, 37.32758], [-122.00267, 37.32667], [-122.00473, 37.32663], [-122.00473, 37.32757]]]} | Open Access 1 | Jenny Strand Park | 20391 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 4.523 | Jenny Strand Park | ||
6295 | 6295 | 6294 | {"type": "Polygon", "coordinates": [[[-121.94878, 37.39627], [-121.94873, 37.39628], [-121.94823, 37.39678], [-121.94816, 37.39679], [-121.9481, 37.39683], [-121.94807, 37.39688], [-121.94809, 37.39696], [-121.94799, 37.39714], [-121.94791, 37.39733], [-121.94786, 37.39762], [-121.94788, 37.39792], [-121.94798, 37.3982], [-121.94801, 37.39824], [-121.94806, 37.39827], [-121.94804, 37.39833], [-121.94816, 37.39855], [-121.94808, 37.39859], [-121.94804, 37.39849], [-121.94792, 37.39831], [-121.94784, 37.39812], [-121.94777, 37.39782], [-121.94777, 37.39751], [-121.94616, 37.39731], [-121.94598, 37.39783], [-121.94553, 37.39831], [-121.94546, 37.39827], [-121.94591, 37.39779], [-121.94601, 37.39751], [-121.94607, 37.39725], [-121.94611, 37.3969], [-121.9461, 37.39655], [-121.94604, 37.39621], [-121.94593, 37.39583], [-121.94662, 37.39554], [-121.94679, 37.3954], [-121.94695, 37.39537], [-121.94762, 37.39563], [-121.94802, 37.39583], [-121.94841, 37.39604], [-121.94878, 37.39627]]]} | Open Access 1 | Live Oak Park | 21369 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 10.215 | Live Oak Park | ||
6907 | 6907 | 6906 | {"type": "Polygon", "coordinates": [[[-121.94126, 37.36692], [-121.94088, 37.36692], [-121.94088, 37.36656], [-121.94114, 37.36658], [-121.94122, 37.36662], [-121.94126, 37.36667], [-121.94126, 37.36692]]]} | Open Access 1 | Memorial Cross Park | 22118 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 0.314 | Memorial Cross Park | ||
9302 | 9302 | 9301 | {"type": "Polygon", "coordinates": [[[-121.96928, 37.40492], [-121.96927, 37.40497], [-121.96923, 37.40501], [-121.96887, 37.40518], [-121.96877, 37.40527], [-121.96814, 37.40557], [-121.96732, 37.40583], [-121.96686, 37.40594], [-121.96674, 37.40599], [-121.96611, 37.40504], [-121.96611, 37.40496], [-121.96616, 37.40483], [-121.96613, 37.40474], [-121.96608, 37.4047], [-121.96602, 37.40466], [-121.96595, 37.40465], [-121.96586, 37.40466], [-121.96853, 37.40347], [-121.96857, 37.40376], [-121.96869, 37.40406], [-121.96886, 37.40434], [-121.96927, 37.40487], [-121.96928, 37.40492]]]} | Open Access 1 | Santa Clara Youth Soccer Park | 25058 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 11.229 | Santa Clara Youth Soccer Park | ||
9523 | 9523 | 9522 | {"type": "Polygon", "coordinates": [[[-121.95422, 37.3521], [-121.95419, 37.35217], [-121.95414, 37.3522], [-121.9539, 37.35222], [-121.95422, 37.3521]]]} | Open Access 1 | Sesquicentennial Park | 25322 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 0.032 | Sesquicentennial Park | ||
10302 | 10302 | 10301 | {"type": "Polygon", "coordinates": [[[-121.94791, 37.40005], [-121.94789, 37.4001], [-121.94772, 37.4003], [-121.94771, 37.40037], [-121.94772, 37.40042], [-121.94725, 37.40095], [-121.94679, 37.4008], [-121.94635, 37.40068], [-121.946, 37.40061], [-121.94546, 37.40053], [-121.94742, 37.39972], [-121.94787, 37.4], [-121.94791, 37.40005]]]} | Open Access 1 | Thamien Park | 26276 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 3.491 | Thamien Park | ||
10547 | 10547 | 10546 | {"type": "Polygon", "coordinates": [[[-121.96133, 37.4083], [-121.96132, 37.40834], [-121.96127, 37.4084], [-121.961, 37.40863], [-121.96084, 37.4088], [-121.96041, 37.4094], [-121.9599, 37.40918], [-121.95662, 37.40804], [-121.95591, 37.40775], [-121.9554, 37.40749], [-121.95485, 37.40715], [-121.95433, 37.40676], [-121.95376, 37.40626], [-121.95343, 37.40591], [-121.95318, 37.4056], [-121.95296, 37.40528], [-121.95273, 37.40489], [-121.9525, 37.40458], [-121.95219, 37.40423], [-121.95183, 37.4039], [-121.95371, 37.4031], [-121.95399, 37.40346], [-121.95417, 37.40364], [-121.95436, 37.40379], [-121.95468, 37.404], [-121.95566, 37.40454], [-121.95582, 37.40464], [-121.95598, 37.40478], [-121.95617, 37.405], [-121.95649, 37.40543], [-121.95668, 37.40565], [-121.95757, 37.40687], [-121.95772, 37.40703], [-121.95789, 37.40717], [-121.95815, 37.40732], [-121.95945, 37.40794], [-121.95971, 37.40801], [-121.96001, 37.40806], [-121.96075, 37.40805], [-121.96095, 37.40806], [-121.96106, 37.4081], [-121.96124, 37.4082], [-121.9613, 37.40825], [-121.96133, 37.4083]]]} | Open Access 1 | Ulistac Natural Area | 26648 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 42.464 | Ulistac Natural Area | ||
11041 | 11041 | 11040 | {"type": "Polygon", "coordinates": [[[-121.9452, 37.34354], [-121.94488, 37.34366], [-121.94502, 37.34393], [-121.94417, 37.34424], [-121.94332, 37.3427], [-121.94323, 37.34272], [-121.94313, 37.34255], [-121.94184, 37.34301], [-121.94165, 37.34264], [-121.94178, 37.34259], [-121.94178, 37.34258], [-121.94115, 37.34143], [-121.94312, 37.34098], [-121.94385, 37.34228], [-121.94439, 37.34209], [-121.9452, 37.34354]]]} | Open Access 1 | Washington Park | 27281 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 13.567 | Washington Park | ||
11815 | 11815 | 11814 | {"type": "Polygon", "coordinates": [[[-121.94763, 37.35929], [-121.94758, 37.35936], [-121.94749, 37.35938], [-121.94726, 37.35926], [-121.94714, 37.359], [-121.94718, 37.35896], [-121.94685, 37.3583], [-121.94669, 37.3584], [-121.94653, 37.35811], [-121.94731, 37.35842], [-121.94763, 37.35929]]]} | Open Access 1 | Reed Street Dog Park | 28453 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 1.008 | Reed Street Dog Park | ||
2993 | 2993 | 2992 | {"type": "Polygon", "coordinates": [[[-121.94535, 37.34767], [-121.94528, 37.34773], [-121.94498, 37.34787], [-121.94446, 37.34801], [-121.94438, 37.34793], [-121.94414, 37.34745], [-121.94414, 37.34731], [-121.94418, 37.34725], [-121.94426, 37.34721], [-121.94477, 37.34704], [-121.94483, 37.34703], [-121.94492, 37.34705], [-121.94501, 37.34711], [-121.9451, 37.34725], [-121.94501, 37.34727], [-121.945, 37.34722], [-121.94489, 37.34719], [-121.94453, 37.34717], [-121.94447, 37.34719], [-121.94446, 37.34721], [-121.94455, 37.34745], [-121.94489, 37.34748], [-121.94491, 37.3474], [-121.94505, 37.34741], [-121.94516, 37.34735], [-121.94524, 37.34747], [-121.94535, 37.34767]]]} | Open Access 1 | City Plaza Park | 17344 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 1.542 | City Plaza Park | 1940 | |
6003 | 6003 | 6002 | {"type": "MultiPolygon", "coordinates": [[[[-121.94352, 37.35477], [-121.94295, 37.35523], [-121.94267, 37.35508], [-121.9435, 37.35478], [-121.94352, 37.35477]]], [[[-121.94573, 37.35466], [-121.94569, 37.35468], [-121.94569, 37.35474], [-121.94564, 37.35478], [-121.94515, 37.355], [-121.94451, 37.35533], [-121.94422, 37.35542], [-121.94392, 37.35547], [-121.94371, 37.35546], [-121.9434, 37.35542], [-121.94314, 37.35532], [-121.94355, 37.35496], [-121.94395, 37.35462], [-121.94526, 37.35416], [-121.94539, 37.35417], [-121.94549, 37.35423], [-121.94573, 37.35466]]]]} | Open Access 1 | Larry J. Marsalli Park | 21034 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 4.501 | Larry J. Marsalli Park | 1940 | |
2976 | 2976 | 2975 | {"type": "Polygon", "coordinates": [[[-121.95477, 37.35316], [-121.95473, 37.35322], [-121.95465, 37.35325], [-121.95422, 37.35323], [-121.95394, 37.35323], [-121.95366, 37.35326], [-121.95353, 37.35304], [-121.95364, 37.35294], [-121.95358, 37.35256], [-121.95439, 37.35255], [-121.95447, 37.35257], [-121.95476, 37.35308], [-121.95477, 37.35316]]]} | Open Access 1 | Civic Center Park | 17364 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 1.735 | Civic Ctr. Park | 1954 | |
2179 | 2179 | 2178 | {"type": "Polygon", "coordinates": [[[-121.97423, 37.35725], [-121.97413, 37.35941], [-121.97339, 37.35966], [-121.97291, 37.35947], [-121.97247, 37.35934], [-121.97313, 37.3567], [-121.97316, 37.35634], [-121.97337, 37.35634], [-121.97336, 37.35656], [-121.97344, 37.35679], [-121.9735, 37.3566], [-121.97362, 37.35699], [-121.97369, 37.35738], [-121.97411, 37.3572], [-121.97423, 37.35725]]]} | Open Access 1 | Bowers Park | 16308 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 8.935 | Bowers Park | 1961 | |
2762 | 2762 | 2761 | {"type": "MultiPolygon", "coordinates": [[[[-121.97732, 37.33988], [-121.97695, 37.34006], [-121.97664, 37.34028], [-121.97635, 37.34057], [-121.97615, 37.34086], [-121.97599, 37.34123], [-121.97576, 37.34199], [-121.9758, 37.34212], [-121.97582, 37.34226], [-121.97578, 37.34246], [-121.97567, 37.34265], [-121.9755, 37.34281], [-121.97522, 37.34371], [-121.9751, 37.34394], [-121.97405, 37.34517], [-121.97337, 37.34517], [-121.97332, 37.34112], [-121.97605, 37.34024], [-121.97606, 37.34022], [-121.97594, 37.33997], [-121.97718, 37.33952], [-121.97732, 37.33988]]], [[[-121.97748, 37.34379], [-121.97712, 37.34379], [-121.97711, 37.34265], [-121.9771, 37.34264], [-121.97612, 37.34267], [-121.97614, 37.34379], [-121.97547, 37.3438], [-121.97558, 37.34312], [-121.9759, 37.34282], [-121.976, 37.34268], [-121.97607, 37.34253], [-121.97612, 37.34238], [-121.97612, 37.34222], [-121.97607, 37.34198], [-121.97635, 37.34113], [-121.97643, 37.34097], [-121.97658, 37.34075], [-121.97684, 37.34048], [-121.97702, 37.34033], [-121.97714, 37.34026], [-121.97739, 37.34013], [-121.97743, 37.3404], [-121.97745, 37.34068], [-121.97748, 37.34379]]]]} | Open Access 1 | Central Park | 17060 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 32.939 | Central Park | 1961 | |
4102 | 4102 | 4101 | {"type": "Polygon", "coordinates": [[[-121.95707, 37.33348], [-121.9567, 37.33392], [-121.9564, 37.33377], [-121.95614, 37.3337], [-121.95611, 37.3328], [-121.95639, 37.33287], [-121.95664, 37.33299], [-121.95684, 37.33315], [-121.95707, 37.33343], [-121.95707, 37.33348]]]} | Open Access 1 | Everett Alvarez Park | 18761 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 1.695 | Everett Alvarez Park | 1961 | |
5040 | 5040 | 5039 | {"type": "Polygon", "coordinates": [[[-121.96162, 37.33687], [-121.96029, 37.33736], [-121.95907, 37.33641], [-121.96008, 37.33521], [-121.96012, 37.33518], [-121.96016, 37.33518], [-121.9604, 37.33534], [-121.96115, 37.33593], [-121.96132, 37.33609], [-121.96144, 37.33629], [-121.96162, 37.33687]]]} | Open Access 1 | Henry Schmidt Park | 19829 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 7.657 | Henry Schmidt Park | 1961 | |
5229 | 5229 | 5228 | {"type": "Polygon", "coordinates": [[[-121.98313, 37.3352], [-121.98301, 37.33532], [-121.98292, 37.33545], [-121.98268, 37.33595], [-121.98253, 37.33613], [-121.98227, 37.33638], [-121.9814, 37.33704], [-121.98125, 37.33718], [-121.98112, 37.33735], [-121.98111, 37.33648], [-121.98174, 37.33647], [-121.98215, 37.33519], [-121.98299, 37.33518], [-121.98307, 37.33521], [-121.98313, 37.3352]]]} | Open Access 1 | Homeridge Park | 20062 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 3.365 | Homeridge Park | 1961 | |
6164 | 6164 | 6163 | {"type": "MultiPolygon", "coordinates": [[[[-121.95907, 37.40357], [-121.95603, 37.40444], [-121.95567, 37.40421], [-121.9549, 37.4038], [-121.95468, 37.40366], [-121.95796, 37.40297], [-121.95797, 37.40304], [-121.95808, 37.40311], [-121.95824, 37.40335], [-121.95832, 37.40341], [-121.95842, 37.40345], [-121.95853, 37.40347], [-121.95864, 37.40346], [-121.95893, 37.40338], [-121.95907, 37.40357]]], [[[-121.96348, 37.4023], [-121.95925, 37.40353], [-121.9591, 37.40335], [-121.96329, 37.40214], [-121.96334, 37.40214], [-121.96338, 37.40216], [-121.96348, 37.4023]]]]} | Open Access 1 | Lick Mill Park | 21226 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 9.626 | Lick Mill Park | 1961 | |
6493 | 6493 | 6492 | {"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 | Machado Park | 21630 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 2.572 | Machado Park | 1961 |
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]);