superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
15 rows where ACCESS_TYP = 1, MNG_AG_TYP = 2 and YR_EST = 1972
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1713 | 1713 | 1712 | {"type": "Polygon", "coordinates": [[[-121.98763, 37.22898], [-121.98664, 37.23005], [-121.98605, 37.22969], [-121.98657, 37.22857], [-121.9868, 37.22863], [-121.98697, 37.22826], [-121.98756, 37.22845], [-121.9872, 37.22871], [-121.98763, 37.22898]]]} | Open Access 1 | Bachman Park | 15750 | 1190 | Los Gatos, Town of 448 | City 2 | City Agency 2 | http://www.losgatosca.gov/48/Parks-and-Public-Works | City 2 | 3.494 | Bachman Park | 1972 | |
2278 | 2278 | 2277 | {"type": "Polygon", "coordinates": [[[-122.00749, 37.28292], [-122.00732, 37.28324], [-122.00725, 37.28341], [-122.00677, 37.28341], [-122.00676, 37.28291], [-122.00749, 37.28292]]]} | Open Access 1 | Brookglen Park | 16421 | 1326 | Saratoga, City of 513 | City 2 | City Agency 2 | http://www.saratoga.ca.us/cityhall/pw/parks/default.asp | City 2 | 0.724 | Brookglen Park | 1972 | |
2537 | 2537 | 2536 | {"type": "Polygon", "coordinates": [[[-121.99986, 37.58564], [-121.99972, 37.58581], [-121.99965, 37.58593], [-121.99961, 37.58596], [-121.99911, 37.58586], [-121.99892, 37.5858], [-121.99868, 37.58569], [-121.99852, 37.58557], [-121.99854, 37.58553], [-121.99871, 37.58539], [-121.99882, 37.58528], [-121.99908, 37.58507], [-121.99915, 37.58506], [-121.9992, 37.58507], [-121.99985, 37.58559], [-121.99986, 37.58564]]]} | Open Access 1 | California Terrace Park | 16729 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 1.669 | California Terrace Park | 1972 | |
5549 | 5549 | 5548 | {"type": "Polygon", "coordinates": [[[-121.96063, 37.28436], [-121.96048, 37.28438], [-121.96041, 37.2843], [-121.96029, 37.28428], [-121.96018, 37.28432], [-121.96012, 37.28441], [-121.96008, 37.28444], [-121.9586, 37.28465], [-121.9579, 37.28199], [-121.95721, 37.28139], [-121.95575, 37.2814], [-121.95575, 37.28072], [-121.95599, 37.28069], [-121.95626, 37.28062], [-121.95651, 37.28049], [-121.95685, 37.28025], [-121.95701, 37.28023], [-121.95715, 37.28028], [-121.9579, 37.28083], [-121.95956, 37.28237], [-121.9598, 37.28262], [-121.96001, 37.28288], [-121.9602, 37.28316], [-121.96042, 37.2836], [-121.96053, 37.2839], [-121.96063, 37.28436]]]} | Open Access 1 | John D. Morgan Park | 20434 | 1043 | Campbell, City of 442 | City 2 | City Agency 2 | http://www.ci.campbell.ca.us/226/Recreation-Parks | City 2 | 18.401 | John D. Morgan Park | 1972 | |
5737 | 5737 | 5736 | {"type": "Polygon", "coordinates": [[[-122.31686, 38.3307], [-122.31648, 38.33101], [-122.3164, 38.33098], [-122.31619, 38.3307], [-122.31612, 38.33066], [-122.31613, 38.33062], [-122.31599, 38.33046], [-122.3158, 38.33025], [-122.31567, 38.33021], [-122.31517, 38.32963], [-122.3157, 38.32936], [-122.31686, 38.3307]]]} | Open Access 1 | Klamath Park | 20685 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 2.352 | Klamath Park | 1972 | |
6418 | 6418 | 6417 | {"type": "Polygon", "coordinates": [[[-121.77292, 37.22793], [-121.77207, 37.22885], [-121.77167, 37.22864], [-121.77123, 37.22848], [-121.7711, 37.22847], [-121.77096, 37.22853], [-121.77057, 37.22894], [-121.77054, 37.229], [-121.77054, 37.22905], [-121.77058, 37.22915], [-121.77049, 37.22913], [-121.77014, 37.22951], [-121.77021, 37.22965], [-121.77016, 37.22969], [-121.77013, 37.22973], [-121.76994, 37.22972], [-121.76961, 37.23009], [-121.76967, 37.23023], [-121.7696, 37.2303], [-121.76941, 37.2303], [-121.76906, 37.23066], [-121.76914, 37.2308], [-121.76908, 37.23087], [-121.76887, 37.23087], [-121.76853, 37.23123], [-121.7686, 37.23137], [-121.76856, 37.23141], [-121.76853, 37.23146], [-121.76834, 37.23144], [-121.768, 37.2318], [-121.76808, 37.23195], [-121.76802, 37.23199], [-121.76799, 37.23204], [-121.76781, 37.23202], [-121.76747, 37.23238], [-121.76753, 37.23253], [-121.76749, 37.23257], [-121.76746, 37.2326], [-121.76727, 37.23259], [-121.7666, 37.23333], [-121.76653, 37.2333], [-121.7669, 37.23289], [-121.76683, 37.23275], [-121.76688, 37.23271], [-121.76691, 37.23266], [-121.7671, 37.23268], [-121.76744, 37.23231], [-121.76737, 37.23217], [-121.76744, 37.23209], [-121.76763, 37.2321], [-121.76797, 37.23173], [-121.76791, 37.2316], [-121.76796, 37.23156], [-121.76798, 37.23151], [-121.76816, 37.23153], [-121.76818, 37.23152], [-121.76852, 37.23115], [-121.76844, 37.23102], [-121.76849, 37.23098], [-121.76852, 37.23093], [-121.76871, 37.23094], [-121.76905, 37.23057], [-121.76897, 37.23044], [-121.76905, 37.23036], [-121.76924, 37.23038], [-121.76957, 37.23001], [-121.76951, 37.22986], [-121.76958, 37.22979], [-121.76977, 37.2298], [-121.77007, 37.22948], [-121.77003, 37.2293], [-121.77009, 37.22926], [-121.77012, 37.22921], [-121.77031, 37.22923], [-121.77043, 37.22909], [-121.7704, 37.22899], [-121.7714, 37.22791], [-121.76971, 37.22689], [-121.7693, 37.22691], [-121.76927, 37.22684], [-121.7692, 37.22678], [-121.76911, 37.22674], [-121.76863, 37.22647], [-121.76915, 37.22458], [-121.77016, 37.22475], [-121.7698, 37.22608], [-121.77292, 37.22793]]]} | Open Access 1 | Los Paseos | 21526 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 15.283 | Los Paseos | 1972 | |
6799 | 6799 | 6798 | {"type": "Polygon", "coordinates": [[[-122.06507, 37.31451], [-122.06468, 37.31447], [-122.06458, 37.31473], [-122.06457, 37.31479], [-122.06453, 37.31481], [-122.06442, 37.31483], [-122.06442, 37.31515], [-122.06431, 37.31515], [-122.0643, 37.31518], [-122.06399, 37.31518], [-122.06364, 37.31557], [-122.06362, 37.3156], [-122.06364, 37.31577], [-122.0634, 37.31566], [-122.06327, 37.31562], [-122.06277, 37.31562], [-122.06254, 37.31558], [-122.06236, 37.31551], [-122.06234, 37.31535], [-122.06217, 37.31527], [-122.0619, 37.31506], [-122.06179, 37.31479], [-122.06128, 37.31465], [-122.06149, 37.31457], [-122.0613, 37.31345], [-122.06164, 37.31332], [-122.06201, 37.31325], [-122.06226, 37.31318], [-122.06315, 37.31282], [-122.06344, 37.31279], [-122.06363, 37.31282], [-122.06374, 37.31286], [-122.06426, 37.31311], [-122.0648, 37.31329], [-122.06492, 37.31335], [-122.06502, 37.31344], [-122.06509, 37.31354], [-122.06513, 37.31365], [-122.06515, 37.31389], [-122.06514, 37.31418], [-122.06507, 37.31451]]]} | Open Access 1 | McClellan Ranch Park | 22000 | 1076 | Cupertino, City of 191 | City 2 | City Agency 2 | http://www.cupertino.org/index.aspx?page=591 | City 2 | 18.979 | McClellan Ranch Park | 1972 | |
7501 | 7501 | 7500 | {"type": "Polygon", "coordinates": [[[-122.46686, 37.66099], [-122.4665, 37.66111], [-122.46638, 37.66086], [-122.46652, 37.66082], [-122.4667, 37.66082], [-122.46677, 37.66079], [-122.46686, 37.66099]]]} | Open Access 1 | Norwood Park | 22907 | 1078 | Daly City, City of 421 | City 2 | City Agency 2 | http://www.dalycity.org/ | City 2 | 0.228 | Norwood Park | 1972 | |
7633 | 7633 | 7632 | {"type": "Polygon", "coordinates": [[[-122.07881, 37.59741], [-122.07881, 37.59746], [-122.07762, 37.59746], [-122.07762, 37.59685], [-122.07795, 37.59684], [-122.07796, 37.59657], [-122.0788, 37.59656], [-122.0788, 37.59704], [-122.07846, 37.59707], [-122.07848, 37.5974], [-122.07881, 37.59741]]]} | Open Access 1 | Old Alvarado Park | 23081 | 1362 | Union City, City of 361 | City 2 | City Agency 2 | http://www.ci.union-city.ca.us/ | City 2 | 2.068 | Old Alvarado Park | 1972 | |
8917 | 8917 | 8916 | {"type": "Polygon", "coordinates": [[[-121.91563, 37.36258], [-121.91482, 37.36298], [-121.91447, 37.36254], [-121.91522, 37.36207], [-121.91563, 37.36258]]]} | Open Access 1 | Rosemary Gardens Park | 24619 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1.306 | Rosemary Gardens Park | 1972 | |
10261 | 10261 | 10260 | {"type": "Polygon", "coordinates": [[[-122.27862, 37.83725], [-122.27859, 37.83726], [-122.27861, 37.83733], [-122.27849, 37.83735], [-122.27845, 37.8372], [-122.27826, 37.83713], [-122.27818, 37.83699], [-122.27755, 37.8371], [-122.27731, 37.83727], [-122.27716, 37.83724], [-122.27698, 37.83701], [-122.27691, 37.83695], [-122.2768, 37.83694], [-122.27638, 37.83702], [-122.27623, 37.83695], [-122.2763, 37.83674], [-122.27705, 37.83658], [-122.27707, 37.8368], [-122.27721, 37.83686], [-122.27734, 37.83687], [-122.27811, 37.83684], [-122.27826, 37.83686], [-122.2784, 37.83694], [-122.27842, 37.837], [-122.2785, 37.83709], [-122.2786, 37.83711], [-122.27861, 37.83715], [-122.27856, 37.83717], [-122.2786, 37.83719], [-122.27862, 37.83725]], [[-122.27837, 37.8371], [-122.27839, 37.83709], [-122.27837, 37.83707], [-122.27824, 37.83693], [-122.27818, 37.8369], [-122.2781, 37.83692], [-122.2781, 37.83693], [-122.27819, 37.83697], [-122.27827, 37.83705], [-122.27837, 37.8371]]]} | Open Access 1 | Temescal Creek Park | 26230 | 1098 | Emeryville, City of 769 | City 2 | City Agency 2 | http://www.ci.emeryville.ca.us/158/City-Parks | City 2 | 1.532 | Temescal Creek Park | 1972 | |
10904 | 10904 | 10903 | {"type": "Polygon", "coordinates": [[[-121.87324, 37.38089], [-121.87302, 37.38111], [-121.8729, 37.38119], [-121.87276, 37.38125], [-121.87261, 37.3813], [-121.87246, 37.38132], [-121.8723, 37.38132], [-121.87214, 37.3813], [-121.87199, 37.38126], [-121.87182, 37.38118], [-121.87145, 37.38088], [-121.87135, 37.38077], [-121.87127, 37.38064], [-121.87123, 37.38044], [-121.87324, 37.38089]]]} | Open Access 1 | Vinci Park | 27130 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 2.294 | Vinci Park | 1972 | |
11965 | 11965 | 11964 | {"type": "Polygon", "coordinates": [[[-122.45944, 37.65127], [-122.45942, 37.65138], [-122.45937, 37.65145], [-122.45928, 37.65151], [-122.45917, 37.65153], [-122.45905, 37.65152], [-122.45887, 37.65145], [-122.4588, 37.65138], [-122.45877, 37.65129], [-122.45877, 37.65123], [-122.45944, 37.65127]]]} | Open Access 1 | Camelot Tot Lot | 28793 | 1078 | Daly City, City of 421 | City 2 | City Agency 2 | http://www.dalycity.org/ | City 2 | 0.361 | Camelot Tot Lot | 1972 | |
11966 | 11966 | 11965 | {"type": "Polygon", "coordinates": [[[-122.47214, 37.65904], [-122.47193, 37.65918], [-122.47189, 37.65924], [-122.47161, 37.65914], [-122.47162, 37.65906], [-122.47158, 37.65901], [-122.47176, 37.65883], [-122.47214, 37.65904]]]} | Open Access 1 | Cameo Tot Lot | 28794 | 1078 | Daly City, City of 421 | City 2 | City Agency 2 | http://www.dalycity.org/ | City 2 | 0.304 | Cameo Tot Lot | 1972 | |
11968 | 11968 | 11967 | {"type": "Polygon", "coordinates": [[[-122.46174, 37.65483], [-122.46141, 37.65508], [-122.46109, 37.65483], [-122.4614, 37.65458], [-122.46174, 37.65483]]]} | Open Access 1 | Hampshire Tot Lot | 28797 | 1078 | Daly City, City of 421 | City 2 | City Agency 2 | http://www.dalycity.org/ | City 2 | 0.402 | Hampshire Tot Lot | 1972 |
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]);