superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
30 rows where ACCESS_TYP = 1, MNG_AG_TYP = 2 and YR_EST = 1984
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AG_TYP
MNG_AGENCY 8
ACCESS_TYP 1
- Open Access · 30 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2246 | 2246 | 2245 | {"type": "Polygon", "coordinates": [[[-122.05539, 37.53459], [-122.05494, 37.53486], [-122.05338, 37.53409], [-122.05373, 37.53374], [-122.05382, 37.53347], [-122.05426, 37.53356], [-122.05443, 37.53361], [-122.05462, 37.53369], [-122.05477, 37.53378], [-122.05494, 37.53391], [-122.05514, 37.53414], [-122.05539, 37.53459]]]} | Open Access 1 | Bridgepointe Park | 16377 | 1221 | Newark, City of 372 | City 2 | City Agency 2 | http://www.ci.newark.ca.us/departments/recreation-and-community-services/parks/ | City 2 | 3.527 | Bridgepointe Park | 1984 | |
2342 | 2342 | 2341 | {"type": "Polygon", "coordinates": [[[-121.94629, 37.55413], [-121.94554, 37.5548], [-121.94613, 37.55522], [-121.94594, 37.55538], [-121.94582, 37.55544], [-121.94487, 37.55626], [-121.9447, 37.55637], [-121.94463, 37.55636], [-121.94461, 37.55634], [-121.94456, 37.55617], [-121.94449, 37.55605], [-121.94437, 37.55591], [-121.94414, 37.55573], [-121.94412, 37.55571], [-121.94413, 37.55567], [-121.94596, 37.55405], [-121.94603, 37.55402], [-121.9461, 37.55402], [-121.94629, 37.55413]]]} | Open Access 1 | Buena Vista Park | 16491 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 4.547 | Buena Vista Park | 1984 | |
2442 | 2442 | 2441 | {"type": "Polygon", "coordinates": [[[-122.02239, 37.53645], [-122.02193, 37.53702], [-122.0216, 37.53688], [-122.0216, 37.53681], [-122.02155, 37.53674], [-122.02091, 37.5364], [-122.02082, 37.5363], [-122.02073, 37.53612], [-122.02064, 37.536], [-122.0205, 37.53588], [-122.0203, 37.53577], [-122.02028, 37.53573], [-122.02049, 37.53547], [-122.02239, 37.53645]]]} | Open Access 1 | Byington Park | 16617 | 1221 | Newark, City of 372 | City 2 | City Agency 2 | http://www.ci.newark.ca.us/departments/recreation-and-community-services/parks/ | City 2 | 2.956 | Byington Park | 1984 | |
3371 | 3371 | 3370 | {"type": "Polygon", "coordinates": [[[-122.08326, 37.37172], [-122.08272, 37.37173], [-122.0827, 37.37347], [-122.07912, 37.3734], [-122.07913, 37.37216], [-122.07878, 37.37215], [-122.07877, 37.37167], [-122.07799, 37.37167], [-122.07799, 37.37091], [-122.08326, 37.37097], [-122.08326, 37.37172]]]} | Open Access 1 | Cuesta Park | 17850 | 1218 | Mountain View, City of 453 | City 2 | City Agency 2 | http://www.ci.mtnview.ca.us/services/parks/default.asp | City 2 | 25.205 | Cuesta Park | 1984 | |
4080 | 4080 | 4079 | {"type": "Polygon", "coordinates": [[[-122.00438, 37.52428], [-122.0038, 37.52499], [-122.00248, 37.52434], [-122.00276, 37.52398], [-122.00264, 37.5239], [-122.00292, 37.52355], [-122.00438, 37.52428]]]} | Open Access 1 | Eucalyptus Grove Park (South) | 18737 | 1221 | Newark, City of 372 | City 2 | City Agency 2 | http://www.ci.newark.ca.us/departments/recreation-and-community-services/parks/ | City 2 | 3.374 | Eucalyptus Grove Park (South) | 1984 | |
4160 | 4160 | 4159 | {"type": "Polygon", "coordinates": [[[-121.96284, 37.40502], [-121.9613, 37.40567], [-121.96112, 37.40543], [-121.96115, 37.40536], [-121.96112, 37.40529], [-121.96107, 37.40526], [-121.96094, 37.40524], [-121.96086, 37.40521], [-121.96077, 37.40514], [-121.9607, 37.40506], [-121.96066, 37.40497], [-121.96065, 37.40481], [-121.96058, 37.40461], [-121.96062, 37.40457], [-121.96163, 37.40414], [-121.96206, 37.40477], [-121.96284, 37.40502]]]} | Open Access 1 | Fairway Glen Park | 18822 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 4.071 | Fairway Glen Park | 1984 | |
4209 | 4209 | 4208 | {"type": "Polygon", "coordinates": [[[-121.79758, 37.34781], [-121.79725, 37.34797], [-121.79713, 37.34796], [-121.79703, 37.34799], [-121.7965, 37.34825], [-121.79535, 37.34749], [-121.79509, 37.34736], [-121.79483, 37.34728], [-121.7948, 37.34725], [-121.79479, 37.34721], [-121.79492, 37.34706], [-121.79539, 37.34659], [-121.79553, 37.34638], [-121.79758, 37.34781]]]} | Open Access 1 | Fernish Park | 18881 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 5.483 | Fernish Park | 1984 | |
4447 | 4447 | 4446 | {"type": "Polygon", "coordinates": [[[-121.96563, 37.39796], [-121.96499, 37.39824], [-121.96491, 37.39816], [-121.96458, 37.39769], [-121.96438, 37.39777], [-121.96431, 37.39773], [-121.96432, 37.39768], [-121.96448, 37.39759], [-121.9642, 37.39717], [-121.96427, 37.39718], [-121.96433, 37.39715], [-121.9644, 37.39704], [-121.96447, 37.39699], [-121.9648, 37.39685], [-121.96488, 37.39686], [-121.96563, 37.39796]]]} | Open Access 1 | Fuller Street Park | 19142 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 2.434 | Fuller Street Park | 1984 | |
4546 | 4546 | 4545 | {"type": "Polygon", "coordinates": [[[-121.79518, 37.23742], [-121.79515, 37.23746], [-121.79513, 37.23751], [-121.79514, 37.2387], [-121.79513, 37.23879], [-121.7951, 37.23884], [-121.79504, 37.23888], [-121.79496, 37.23889], [-121.79468, 37.23884], [-121.79447, 37.23881], [-121.79399, 37.2388], [-121.79393, 37.23878], [-121.79391, 37.23873], [-121.79387, 37.23693], [-121.79388, 37.2369], [-121.79394, 37.23688], [-121.79461, 37.23701], [-121.79518, 37.23708], [-121.79518, 37.23742]]]} | Open Access 1 | George Page Park | 19272 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 5.627 | George Page Park | 1984 | |
4793 | 4793 | 4792 | {"type": "Polygon", "coordinates": [[[-121.88306, 37.23598], [-121.88282, 37.23622], [-121.88261, 37.23649], [-121.88268, 37.23668], [-121.88284, 37.23692], [-121.88238, 37.23705], [-121.88186, 37.23728], [-121.88159, 37.23744], [-121.88065, 37.23811], [-121.88052, 37.23825], [-121.88041, 37.23841], [-121.88029, 37.23876], [-121.88017, 37.23895], [-121.87981, 37.23938], [-121.8797, 37.23947], [-121.87956, 37.23956], [-121.87916, 37.23973], [-121.8789, 37.23954], [-121.8787, 37.23941], [-121.87844, 37.23928], [-121.8782, 37.23919], [-121.87803, 37.23948], [-121.87701, 37.23919], [-121.87697, 37.23916], [-121.87698, 37.23895], [-121.87695, 37.23881], [-121.87697, 37.23875], [-121.87716, 37.2386], [-121.87729, 37.23847], [-121.87755, 37.23816], [-121.87764, 37.23799], [-121.87767, 37.23781], [-121.87767, 37.23731], [-121.87801, 37.23725], [-121.87825, 37.23724], [-121.87836, 37.23668], [-121.87836, 37.23665], [-121.87764, 37.2361], [-121.87779, 37.23596], [-121.87789, 37.23578], [-121.87792, 37.23569], [-121.87794, 37.2355], [-121.87785, 37.23515], [-121.87784, 37.23498], [-121.87781, 37.23481], [-121.87774, 37.23464], [-121.87758, 37.23438], [-121.87755, 37.23428], [-121.87754, 37.23412], [-121.87765, 37.23381], [-121.87775, 37.23361], [-121.87786, 37.2335], [-121.87805, 37.23337], [-121.87812, 37.23327], [-121.87816, 37.23317], [-121.87816, 37.23309], [-121.87814, 37.23294], [-121.87815, 37.23285], [-121.87814, 37.2328], [-121.88021, 37.23293], [-121.88006, 37.23334], [-121.88034, 37.23378], [-121.88057, 37.23417], [-121.88125, 37.23452], [-121.88183, 37.23457], [-121.882, 37.23454], [-121.88218, 37.23447], [-121.88226, 37.23446], [-121.88239, 37.23454], [-121.88269, 37.23456], [-121.88271, 37.23468], [-121.88251, 37.23471], [-121.88232, 37.23482], [-121.8822, 37.235], [-121.88204, 37.23511], [-121.88195, 37.23533], [-121.882, 37.2354], [-121.88232, 37.23541], [-121.88233, 37.2355], [-121.88228, 37.23562], [-121.88237, 37.23576], [-121.88253, 37.23578], [-121.88281, 37.23578], [-121.883, 37.2359], [-121.88306, 37.23598]]]} | Open Access 1 | Guadalupe Oak Grove | 19555 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 57.836 | Guadalupe Oak Grove | 1984 | |
5248 | 5248 | 5247 | {"type": "Polygon", "coordinates": [[[-122.21778, 37.48305], [-122.21644, 37.48394], [-122.21344, 37.48339], [-122.21436, 37.48199], [-122.21537, 37.48239], [-122.21599, 37.4823], [-122.21778, 37.48305]]]} | Open Access 1 | Hoover Park | 20081 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 11.512 | Hoover Park | 1984 | |
6314 | 6314 | 6313 | {"type": "Polygon", "coordinates": [[[-121.83923, 37.359], [-121.83914, 37.35909], [-121.83875, 37.35927], [-121.83871, 37.35928], [-121.83867, 37.35926], [-121.83633, 37.35687], [-121.83565, 37.35587], [-121.83599, 37.35588], [-121.83665, 37.3566], [-121.83681, 37.35652], [-121.83923, 37.359]]]} | Open Access 1 | Lo Bue Park | 21390 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 5.834 | Lo Bue Park | 1984 | |
6354 | 6354 | 6353 | {"type": "Polygon", "coordinates": [[[-121.91257, 37.24638], [-121.91193, 37.24639], [-121.91168, 37.24645], [-121.91158, 37.24641], [-121.91143, 37.24648], [-121.91143, 37.24653], [-121.9114, 37.24657], [-121.91116, 37.24668], [-121.91031, 37.24549], [-121.91017, 37.24517], [-121.90953, 37.24426], [-121.91011, 37.244], [-121.91017, 37.24399], [-121.91021, 37.24401], [-121.91111, 37.24526], [-121.91129, 37.24543], [-121.91151, 37.24556], [-121.91177, 37.24564], [-121.91196, 37.24566], [-121.91256, 37.24566], [-121.91257, 37.24638]]]} | Open Access 1 | Lone Hill Park | 21438 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 7.081 | Lone Hill Park | 1984 | |
6714 | 6714 | 6713 | {"type": "Polygon", "coordinates": [[[-122.0192, 37.34862], [-122.01805, 37.34863], [-122.01804, 37.34683], [-122.01919, 37.34683], [-122.0192, 37.34862]]]} | Open Access 1 | Panama Park | 23385 | 1345 | Sunnyvale, City of 413 | City 2 | City Agency 2 | http://sunnyvale.ca.gov/Departments/CommunityServices/Parks.aspx | City 2 | 5.018 | Panama Park | 1984 | |
6717 | 6717 | 6716 | {"type": "Polygon", "coordinates": [[[-121.86456, 37.33387], [-121.86435, 37.33498], [-121.86409, 37.33516], [-121.86367, 37.3373], [-121.86253, 37.3362], [-121.86309, 37.3358], [-121.86285, 37.33557], [-121.86285, 37.3355], [-121.86282, 37.33545], [-121.86253, 37.33517], [-121.8625, 37.33512], [-121.86251, 37.33507], [-121.86254, 37.335], [-121.86412, 37.33396], [-121.86417, 37.3339], [-121.8642, 37.33383], [-121.86456, 37.33387]]]} | Open Access 1 | Martin | 21901 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 8.34 | Martin | 1984 | |
6735 | 6735 | 6734 | {"type": "Polygon", "coordinates": [[[-121.77261, 37.22524], [-121.77226, 37.22632], [-121.77218, 37.22638], [-121.77202, 37.22639], [-121.77177, 37.22636], [-121.7713, 37.22671], [-121.77114, 37.22687], [-121.76979, 37.22607], [-121.77015, 37.22477], [-121.77007, 37.22474], [-121.77007, 37.22473], [-121.77243, 37.22517], [-121.77261, 37.22524]]]} | Open Access 1 | Martin Murphy Playfield | 21923 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 9.39 | Martin Murphy Playfield | 1984 | |
7059 | 7059 | 7058 | {"type": "Polygon", "coordinates": [[[-121.93952, 37.54652], [-121.93642, 37.54749], [-121.93634, 37.54757], [-121.93601, 37.54739], [-121.93593, 37.54741], [-121.93544, 37.54713], [-121.93594, 37.54656], [-121.93702, 37.54622], [-121.93777, 37.5454], [-121.93841, 37.54539], [-121.93841, 37.54585], [-121.93928, 37.54636], [-121.93952, 37.54652]]]} | Open Access 1 | Mission San Jose Community Park | 22310 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 9.581 | Mission San Jose Community Park | 1984 | |
7347 | 7347 | 7346 | {"type": "Polygon", "coordinates": [[[-122.01182, 37.51583], [-122.01166, 37.51629], [-122.01053, 37.51879], [-122.01011, 37.51977], [-122.00949, 37.51959], [-122.0089, 37.51937], [-122.00863, 37.51996], [-122.00771, 37.51964], [-122.00981, 37.51481], [-122.01051, 37.51513], [-122.01045, 37.51521], [-122.01046, 37.51523], [-122.01182, 37.51583]]]} | Open Access 1 | Newark Sportsfield Park | 22713 | 1221 | Newark, City of 372 | City 2 | City Agency 2 | http://www.ci.newark.ca.us/departments/recreation-and-community-services/parks/ | City 2 | 25.975 | Newark Sportsfield Park | 1984 | |
7651 | 7651 | 7650 | {"type": "Polygon", "coordinates": [[[-121.92796, 37.5226], [-121.92787, 37.52269], [-121.92771, 37.52292], [-121.92771, 37.52297], [-121.92773, 37.52305], [-121.92758, 37.52326], [-121.92747, 37.52349], [-121.92705, 37.52345], [-121.92659, 37.52335], [-121.9262, 37.52319], [-121.92571, 37.52289], [-121.92557, 37.52283], [-121.92532, 37.52276], [-121.92494, 37.52273], [-121.92454, 37.52275], [-121.92429, 37.52279], [-121.92409, 37.52284], [-121.92386, 37.52293], [-121.92364, 37.52303], [-121.9235, 37.52312], [-121.92328, 37.52328], [-121.92319, 37.52329], [-121.92315, 37.52328], [-121.92297, 37.52311], [-121.92273, 37.52296], [-121.92265, 37.52288], [-121.92257, 37.52277], [-121.92252, 37.52263], [-121.92238, 37.52166], [-121.92232, 37.52148], [-121.92219, 37.52124], [-121.92219, 37.52121], [-121.92223, 37.52116], [-121.92312, 37.52085], [-121.92328, 37.52081], [-121.92348, 37.52079], [-121.92406, 37.52084], [-121.92432, 37.52083], [-121.92462, 37.52078], [-121.92494, 37.52067], [-121.92502, 37.52066], [-121.92506, 37.52068], [-121.92529, 37.52097], [-121.92552, 37.52121], [-121.92573, 37.52139], [-121.92596, 37.52155], [-121.92634, 37.52177], [-121.92772, 37.52242], [-121.92796, 37.5226]]]} | Open Access 1 | Old Mission Park | 23094 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 22.896 | Old Mission Park | 1984 | |
8008 | 8008 | 8007 | {"type": "Polygon", "coordinates": [[[-121.76351, 37.30514], [-121.76337, 37.30509], [-121.76282, 37.30517], [-121.76274, 37.30486], [-121.76297, 37.30491], [-121.76349, 37.30511], [-121.76351, 37.30514]]]} | Open Access 1 | Pocket Park No. 20 | 23830 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 0.26 | PP No. 20 | 1984 |
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]);