superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
62 rows where YR_EST = 1961
This data as json, copyable, CSV (advanced)
These facets timed out: ACCESS_TYP, MNG_AGENCY, MNG_AG_TYP, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
564 | 564 | 563 | {"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 | Borel Park | 16283 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1.549 | Borel Park | 1961 | |
1809 | 1809 | 1808 | {"type": "Polygon", "coordinates": [[[-121.93454, 37.26366], [-121.93454, 37.26383], [-121.93449, 37.26388], [-121.93447, 37.26395], [-121.93446, 37.2643], [-121.93449, 37.26439], [-121.93448, 37.26468], [-121.9316, 37.2647], [-121.9316, 37.26461], [-121.93187, 37.26459], [-121.93183, 37.26378], [-121.93196, 37.2638], [-121.93212, 37.26384], [-121.93212, 37.26389], [-121.93241, 37.26393], [-121.93262, 37.26393], [-121.93285, 37.26391], [-121.93302, 37.26387], [-121.93309, 37.26392], [-121.9331, 37.26427], [-121.93377, 37.26427], [-121.93379, 37.26408], [-121.93376, 37.26406], [-121.93375, 37.26377], [-121.93367, 37.26376], [-121.93365, 37.26359], [-121.93396, 37.26359], [-121.93397, 37.26373], [-121.93438, 37.26372], [-121.9344, 37.26367], [-121.93454, 37.26366]]]} | Open Access 1 | Camden Park Center | 16755 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 5.024 | Camden Park Ctr. | 1961 | |
1959 | 1959 | 1958 | {"type": "Polygon", "coordinates": [[[-122.31684, 37.53809], [-122.31636, 37.53823], [-122.31625, 37.53818], [-122.31614, 37.53821], [-122.31449, 37.53937], [-122.31379, 37.53974], [-122.31339, 37.53932], [-122.313, 37.53886], [-122.31264, 37.53839], [-122.31231, 37.5379], [-122.31581, 37.53648], [-122.31684, 37.53809]]]} | Open Access 1 | Beresford Park | 16020 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 17.933 | Beresford Park | 1961 | |
2043 | 2043 | 2042 | {"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.52859], [-121.97255, 37.5277], [-121.97245, 37.52753], [-121.97257, 37.52748], [-121.97276, 37.52774], [-121.97308, 37.5276], [-121.97333, 37.52746], [-121.9737, 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 | Blacow Park | 16146 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 9.979 | Blacow Park | 1961 | |
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 | |
2320 | 2320 | 2319 | {"type": "Polygon", "coordinates": [[[-122.08415, 37.37745], [-122.08415, 37.37791], [-122.08379, 37.37793], [-122.08379, 37.37881], [-122.08294, 37.3788], [-122.08293, 37.3773], [-122.08349, 37.37732], [-122.08412, 37.37739], [-122.08415, 37.37745]]]} | Open Access 1 | Bubb Park | 16466 | 1218 | Mountain View, City of 453 | City 2 | City Agency 2 | http://www.ci.mtnview.ca.us/services/parks/default.asp | City 2 | 3.572 | Bubb Park | 1961 | |
2672 | 2672 | 2671 | {"type": "Polygon", "coordinates": [[[-122.28234, 37.53399], [-122.28208, 37.53415], [-122.28213, 37.53423], [-122.28188, 37.53438], [-122.28187, 37.53441], [-122.28178, 37.53444], [-122.28173, 37.5345], [-122.28169, 37.53449], [-122.28144, 37.53464], [-122.28081, 37.53396], [-122.2823, 37.53395], [-122.28234, 37.53399]]]} | Open Access 1 | Casanova | 16932 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1.376 | Casanova | 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 | |
2821 | 2821 | 2820 | {"type": "Polygon", "coordinates": [[[-122.24204, 37.85062], [-122.23985, 37.85093], [-122.23982, 37.85109], [-122.2391, 37.85125], [-122.23883, 37.8512], [-122.23693, 37.85067], [-122.23681, 37.85044], [-122.23681, 37.85023], [-122.23658, 37.84995], [-122.23623, 37.84978], [-122.23624, 37.84932], [-122.23667, 37.84953], [-122.23731, 37.84991], [-122.23785, 37.85015], [-122.23846, 37.85028], [-122.23905, 37.85035], [-122.24001, 37.85032], [-122.2408, 37.85019], [-122.24128, 37.85007], [-122.24168, 37.84993], [-122.24196, 37.84972], [-122.24204, 37.85062]]]} | Open Access 1 | Chabot Park | 17109 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 10.308 | Chabot Park | 1961 | |
2977 | 2977 | 2976 | {"type": "Polygon", "coordinates": [[[-122.03923, 37.37111], [-122.03922, 37.37115], [-122.03918, 37.37118], [-122.03881, 37.37126], [-122.03784, 37.37171], [-122.03757, 37.37178], [-122.03729, 37.3718], [-122.0371, 37.37179], [-122.0364, 37.37164], [-122.03635, 37.37161], [-122.03635, 37.37158], [-122.03678, 37.37032], [-122.03682, 37.37029], [-122.03687, 37.37028], [-122.0375, 37.37042], [-122.03739, 37.37074], [-122.03752, 37.37084], [-122.03833, 37.37101], [-122.03847, 37.37091], [-122.03849, 37.37077], [-122.03847, 37.37063], [-122.03889, 37.37071], [-122.03904, 37.37077], [-122.03911, 37.37084], [-122.03916, 37.37091], [-122.03923, 37.37111]]]} | Open Access 1 | Civic Center Park | 17365 | 1345 | Sunnyvale, City of 413 | City 2 | City Agency 2 | http://sunnyvale.ca.gov/Departments/CommunityServices/Parks.aspx | City 2 | 5.837 | Civic Ctr. Park | 1961 | |
3150 | 3150 | 3149 | {"type": "Polygon", "coordinates": [[[-122.30455, 37.55525], [-122.30397, 37.55534], [-122.30391, 37.55508], [-122.30448, 37.55498], [-122.30455, 37.55525]]]} | Open Access 1 | Connie Park | 17591 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 0.389 | Connie Park | 1961 | |
3405 | 3405 | 3404 | {"type": "Polygon", "coordinates": [[[-122.29796, 37.56767], [-122.29795, 37.56824], [-122.29718, 37.56827], [-122.29719, 37.56766], [-122.29738, 37.56766], [-122.2974, 37.5677], [-122.29775, 37.5677], [-122.29777, 37.56767], [-122.29796, 37.56767]]]} | Open Access 1 | Dale Avenue | 17893 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1.07 | Dale Avenue | 1961 | |
3725 | 3725 | 3724 | {"type": "Polygon", "coordinates": [[[-122.0708, 37.34489], [-122.0708, 37.34665], [-122.06989, 37.34665], [-122.06989, 37.34631], [-122.06993, 37.34626], [-122.06995, 37.3462], [-122.06996, 37.34583], [-122.06995, 37.34576], [-122.06992, 37.3457], [-122.06986, 37.34566], [-122.06979, 37.34563], [-122.0698, 37.34492], [-122.07023, 37.34489], [-122.0708, 37.34489]]]} | Open Access 1 | Grant Park | 19438 | 1186 | Los Altos, City of 445 | City 2 | City Agency 2 | http://www.losaltosca.gov/parksites | City 2 | 3.972 | Grant Park | 1961 | |
3787 | 3787 | 3786 | {"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 | East Avenue Park | 18360 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 18.311 | East Avenue Park | 1961 | |
3794 | 3794 | 3793 | {"type": "Polygon", "coordinates": [[[-122.30409, 37.53651], [-122.3036, 37.53671], [-122.30288, 37.53523], [-122.30346, 37.53505], [-122.30372, 37.5359], [-122.30409, 37.53651]]]} | Open Access 1 | East Hillsdale | 18371 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 2.027 | East Hillsdale | 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 | |
4121 | 4121 | 4120 | {"type": "Polygon", "coordinates": [[[-122.21235, 37.47671], [-122.21207, 37.47697], [-122.21157, 37.47664], [-122.21202, 37.47668], [-122.21235, 37.47671]]]} | Open Access 1 | Fair Oaks Community Cente | 18784 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 0.275 | Fair Oaks Community Cente | 1961 | |
4217 | 4217 | 4216 | {"type": "Polygon", "coordinates": [[[-122.29641, 37.55058], [-122.2957, 37.55093], [-122.29572, 37.55098], [-122.29509, 37.55128], [-122.29476, 37.5511], [-122.29445, 37.55084], [-122.29433, 37.5509], [-122.29395, 37.55051], [-122.29439, 37.55026], [-122.2946, 37.55016], [-122.296, 37.54977], [-122.29613, 37.55], [-122.2961, 37.55003], [-122.29602, 37.55005], [-122.29602, 37.55007], [-122.29641, 37.55058]]]} | Open Access 1 | Fiesta Meadows | 18892 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 4.906 | Fiesta Meadows | 1961 | |
4296 | 4296 | 4295 | {"type": "Polygon", "coordinates": [[[-122.30386, 37.5286], [-122.30295, 37.52897], [-122.30258, 37.5289], [-122.30234, 37.52882], [-122.30231, 37.52883], [-122.30205, 37.52845], [-122.3034, 37.52789], [-122.30386, 37.5286]]]} | Open Access 1 | Indian Springs | 20207 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 2.707 | Indian Springs | 1961 | |
4332 | 4332 | 4331 | {"type": "Polygon", "coordinates": [[[-121.95991, 37.53298], [-121.95978, 37.53314], [-121.95949, 37.53297], [-121.95949, 37.53297], [-121.95991, 37.53298]]]} | Open Access 1 | Irvington Plaza | 20274 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 0.081 | Irvington Plaza | 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]);