superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
6 rows where MNG_AG_TYP = 2 and YR_EST = 1990
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2052 | 2052 | 2051 | {"type": "Polygon", "coordinates": [[[-122.06315, 37.31718], [-122.06316, 37.31721], [-122.06316, 37.31766], [-122.06301, 37.3181], [-122.06273, 37.31835], [-122.06256, 37.31854], [-122.06247, 37.31892], [-122.06259, 37.31931], [-122.06205, 37.31959], [-122.06149, 37.31998], [-122.06043, 37.3185], [-122.06007, 37.31768], [-122.06076, 37.31761], [-122.06105, 37.31766], [-122.06116, 37.31765], [-122.06133, 37.31757], [-122.06137, 37.31752], [-122.06134, 37.31739], [-122.06119, 37.31725], [-122.06106, 37.3173], [-122.06081, 37.31701], [-122.06067, 37.31682], [-122.06017, 37.31646], [-122.06012, 37.31645], [-122.06011, 37.31628], [-122.06002, 37.31605], [-122.06019, 37.31559], [-122.0613, 37.31559], [-122.06158, 37.31557], [-122.06153, 37.31567], [-122.06151, 37.31577], [-122.06153, 37.31586], [-122.06159, 37.31601], [-122.0616, 37.31614], [-122.06157, 37.31624], [-122.06146, 37.31645], [-122.06145, 37.31655], [-122.06147, 37.31662], [-122.06151, 37.31668], [-122.06158, 37.31673], [-122.06208, 37.31694], [-122.06265, 37.31707], [-122.06292, 37.31716], [-122.0631, 37.31716], [-122.06315, 37.31718]]]} | Open Access 1 | Blackberry Farm | 16139 | 1076 | Cupertino, City of 191 | City 2 | City Agency 2 | http://www.cupertino.org/index.aspx?page=591 | City 2 | 18.003 | Blackberry Farm | 1990 | |
2616 | 2616 | 2615 | {"type": "Polygon", "coordinates": [[[-122.01681, 37.31623], [-122.0168, 37.31644], [-122.0164, 37.31668], [-122.01606, 37.31675], [-122.01577, 37.31726], [-122.01557, 37.31775], [-122.01363, 37.31777], [-122.01363, 37.31733], [-122.0137, 37.31731], [-122.01369, 37.31704], [-122.01379, 37.31702], [-122.01383, 37.31624], [-122.01498, 37.31627], [-122.01507, 37.31468], [-122.01624, 37.31472], [-122.0162, 37.31475], [-122.01625, 37.31503], [-122.01613, 37.31535], [-122.01612, 37.316], [-122.01639, 37.31618], [-122.01681, 37.31623]]]} | Open Access 1 | Creekside Park | 17772 | 1076 | Cupertino, City of 191 | City 2 | City Agency 2 | http://www.cupertino.org/index.aspx?page=591 | City 2 | 12.981 | Creekside Park | 1990 | |
3629 | 3629 | 3628 | {"type": "Polygon", "coordinates": [[[-121.91743, 37.45308], [-121.91537, 37.4538], [-121.91434, 37.45191], [-121.91435, 37.45184], [-121.91443, 37.4518], [-121.91475, 37.45173], [-121.91489, 37.45166], [-121.91619, 37.45126], [-121.91627, 37.45129], [-121.9172, 37.45266], [-121.91743, 37.45308]]]} | Open Access 1 | Dixon Landing Park | 18173 | 1206 | Milpitas, City of 411 | City 2 | City Agency 2 | http://www.ci.milpitas.ca.gov/ | City 2 | 11.084 | Dixon Landing Park | 1990 | |
6828 | 6828 | 6827 | {"type": "Polygon", "coordinates": [[[-121.8958, 37.33096], [-121.89562, 37.33105], [-121.89566, 37.3311], [-121.89464, 37.33158], [-121.89428, 37.33112], [-121.89502, 37.33074], [-121.8948, 37.33045], [-121.89469, 37.33046], [-121.89439, 37.33005], [-121.8946, 37.32996], [-121.89524, 37.33066], [-121.89578, 37.33083], [-121.89576, 37.33089], [-121.8958, 37.33096]]]} | Open Access 1 | McEnery Park | 22028 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 2.283 | McEnery Park | 1990 | |
7871 | 7871 | 7870 | {"type": "Polygon", "coordinates": [[[-121.90114, 37.3155], [-121.90116, 37.31561], [-121.90116, 37.31572], [-121.90114, 37.31582], [-121.9011, 37.31592], [-121.90019, 37.31569], [-121.90017, 37.31567], [-121.90019, 37.31565], [-121.90111, 37.31549], [-121.90114, 37.3155]]]} | Open Access 1 | Palm Haven Plaza | 23339 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 0.563 | Palm Haven Plaza | 1990 | |
10192 | 10192 | 10191 | {"type": "Polygon", "coordinates": [[[-121.94839, 37.80697], [-121.94726, 37.80856], [-121.94826, 37.80902], [-121.94773, 37.80924], [-121.94754, 37.80949], [-121.94725, 37.80958], [-121.94687, 37.80964], [-121.94661, 37.8095], [-121.94631, 37.80916], [-121.94594, 37.80897], [-121.94559, 37.80886], [-121.94517, 37.80893], [-121.94466, 37.80909], [-121.94434, 37.80913], [-121.94383, 37.80895], [-121.9439, 37.80869], [-121.94437, 37.80802], [-121.94444, 37.80803], [-121.94523, 37.80687], [-121.94514, 37.80604], [-121.94551, 37.80552], [-121.94683, 37.80612], [-121.94687, 37.8061], [-121.94839, 37.80697]]]} | Open Access 1 | Sycamore Valley Park | 26143 | 1080 | Danville, Town of 466 | City 2 | City Agency 2 | http://www.danville.ca.gov/Things-To-Do/Parks/ | City 2 | 24.674 | Sycamore Valley Park | 1990 |
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]);