units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
31 rows where MNG_AG_TYP = 2 and YR_EST = 1940
This data as json, copyable, CSV (advanced)
These facets timed out: ACCESS_TYP
MNG_AGENCY 10
DES_TP 10
- Local Park 20
- Local Recreation Area 2
- Local Other or Unknown 2
- Local Historic or Cultural Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
MNG_AG_TYP 1
- City Agency · 31 ✖
Link | rowid ▼ | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
608 | 608 | 607 | {"type": "Polygon", "coordinates": [[[-122.16052, 37.46073], [-122.15992, 37.46148], [-122.15819, 37.46088], [-122.15834, 37.46016], [-122.15964, 37.46033], [-122.15972, 37.46057], [-122.16052, 37.46073]]]} | Open Access 1 | 2123 | Willow Oaks Park | 27581 | 1202 | Menlo Park, City of 221 | City 2 | City Agency 2 | http://www.menlopark.org/ | City 2 | 1202 | Menlo Park, City of 217 | City 2 | City Agency 2 | San Mateo 15 | 4.256 | Willow Oaks Park | 1940 | Local Park 2 | 4 | |
1805 | 1805 | 1804 | {"type": "Polygon", "coordinates": [[[-121.88006, 37.33079], [-121.87965, 37.33098], [-121.87955, 37.33084], [-121.87991, 37.33067], [-121.87982, 37.33052], [-121.87985, 37.33051], [-121.88006, 37.33079]]]} | Open Access 1 | 13703 | O'Donnell Garden Park | 22946 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 0.201 | O'Donnell Garden Park | 1940 | Local Park 2 | 4 | |
3720 | 3720 | 3719 | {"type": "Polygon", "coordinates": [[[-122.31469, 37.55875], [-122.31454, 37.55886], [-122.3145, 37.55887], [-122.31428, 37.55865], [-122.31444, 37.55853], [-122.31448, 37.55852], [-122.31457, 37.55859], [-122.31469, 37.55871], [-122.31469, 37.55875]]]} | Open Access 1 | 14034 | Hayward Park Square | 19760 | 1310 | San Mateo, City of 98 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | San Mateo 15 | 0.192 | Hayward Park Square | 1940 | Local Park 2 | 4 | |
3721 | 3721 | 3720 | {"type": "Polygon", "coordinates": [[[-122.31947, 37.56947], [-122.31859, 37.57008], [-122.31843, 37.56994], [-122.31804, 37.56974], [-122.31787, 37.56968], [-122.31738, 37.56941], [-122.31678, 37.56954], [-122.31768, 37.56892], [-122.318, 37.56921], [-122.31789, 37.56928], [-122.31789, 37.56935], [-122.31827, 37.56968], [-122.31834, 37.56968], [-122.3184, 37.56965], [-122.3187, 37.56992], [-122.31881, 37.56987], [-122.31941, 37.56946], [-122.31947, 37.56947]]]} | Open Access 1 | 14036 | Gateway | 19234 | 1310 | San Mateo, City of 98 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | San Mateo 15 | 1.454 | Gateway | 1940 | None 310 | ||
3728 | 3728 | 3727 | {"type": "Polygon", "coordinates": [[[-122.32824, 37.55981], [-122.32774, 37.55988], [-122.3277, 37.55972], [-122.32775, 37.55963], [-122.32814, 37.55935], [-122.32824, 37.55981]]]} | Open Access 1 | 14038 | Bay Tree | 15881 | 1310 | San Mateo, City of 98 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | San Mateo 15 | 0.416 | Bay Tree | 1940 | None 311 | ||
4269 | 4269 | 4268 | {"type": "Polygon", "coordinates": [[[-122.41128, 37.62838], [-122.41128, 37.62838], [-122.41123, 37.62888], [-122.41096, 37.62843], [-122.41128, 37.62838]]]} | Open Access 1 | 14400 | Posy Park | 23918 | 1294 | San Bruno, City of 440 | City 2 | City Agency 2 | http://www.sanbruno.ca.gov/parks_main.html | City 2 | 1294 | San Bruno, City of 434 | City 2 | City Agency 2 | San Mateo 15 | 0.192 | Posy Park | 1940 | Local Park 2 | 4 | |
5058 | 5058 | 5057 | {"type": "Polygon", "coordinates": [[[-122.48732, 37.75739], [-122.48649, 37.75743], [-122.48638, 37.75579], [-122.4872, 37.75575], [-122.48732, 37.75739]]]} | Open Access 1 | 1309 | Sunset Recreation Center | 30853 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/destination/sunset-rec-center-park/ | San Francisco 13 | 3.286 | Sunset Rec. Ctr. | 1940 | Local Recreation Area 3 | 4 |
5101 | 5101 | 5100 | {"type": "Polygon", "coordinates": [[[-122.24341, 37.48993], [-122.2436, 37.48993], [-122.24374, 37.48997], [-122.24383, 37.49003], [-122.24389, 37.49014], [-122.2439, 37.49021], [-122.24386, 37.49036], [-122.24376, 37.4905], [-122.24353, 37.49066], [-122.24346, 37.4907], [-122.24333, 37.49072], [-122.24324, 37.49072], [-122.24314, 37.49069], [-122.24304, 37.49064], [-122.24294, 37.49054], [-122.24291, 37.49042], [-122.24294, 37.49029], [-122.24301, 37.49019], [-122.24317, 37.49004], [-122.24324, 37.49], [-122.24341, 37.48993]]]} | Open Access 1 | 13908 | Wellesley Park | 27341 | 1271 | Redwood City, City of 397 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | San Mateo 15 | 1.397 | Wellesley Park | 1940 | Local Park 2 | 4 | |
5916 | 5916 | 5915 | {"type": "Polygon", "coordinates": [[[-122.42029, 37.61328], [-122.41977, 37.61352], [-122.42007, 37.61395], [-122.41969, 37.61397], [-122.41819, 37.61396], [-122.41797, 37.61398], [-122.41777, 37.61402], [-122.41683, 37.61437], [-122.41657, 37.61449], [-122.41644, 37.61459], [-122.41627, 37.61474], [-122.41581, 37.61531], [-122.41392, 37.61739], [-122.41261, 37.61578], [-122.41261, 37.61577], [-122.41259, 37.61574], [-122.41283, 37.61557], [-122.41515, 37.61373], [-122.41687, 37.61283], [-122.41984, 37.61265], [-122.42029, 37.61328]]]} | Open Access 1 | 372 | San Bruno City Park | 24839 | 1294 | San Bruno, City of 440 | City 2 | City Agency 2 | http://www.sanbruno.ca.gov/parks_main.html | City 2 | 1294 | San Bruno, City of 434 | City 2 | City Agency 2 | San Mateo 15 | 29.148 | San Bruno City Park | 1940 | Local Park 2 | 4 | |
5929 | 5929 | 5928 | {"type": "Polygon", "coordinates": [[[-121.93019, 37.33171], [-121.92846, 37.33306], [-121.92699, 37.33185], [-121.92873, 37.3305], [-121.93019, 37.33171]]]} | Open Access 1 | 429 | San Jose Municipal Rose Garden | 24917 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 9.904 | San Jose Municipal Rose Garden | 1940 | Local Park 2 | 4 | |
6851 | 6851 | 6850 | {"type": "Polygon", "coordinates": [[[-122.40576, 37.63377], [-122.40541, 37.63374], [-122.40526, 37.63285], [-122.40564, 37.63282], [-122.40576, 37.63377]]]} | Open Access 1 | 14392 | 7th Avenue and Walnut Park | 15213 | 1294 | San Bruno, City of 440 | City 2 | City Agency 2 | http://www.sanbruno.ca.gov/parks_main.html | City 2 | 1294 | San Bruno, City of 434 | City 2 | City Agency 2 | San Mateo 15 | 0.806 | 7th Avenue and Walnut Park | 1940 | Local Park 2 | 4 | |
6970 | 6970 | 6969 | {"type": "Polygon", "coordinates": [[[-122.40517, 37.62935], [-122.40481, 37.62939], [-122.40477, 37.62877], [-122.40516, 37.62875], [-122.40517, 37.62935]]]} | Open Access 1 | 14394 | 7th Avenue Park | 15214 | 1294 | San Bruno, City of 440 | City 2 | City Agency 2 | http://www.sanbruno.ca.gov/parks_main.html | City 2 | 1294 | San Bruno, City of 434 | City 2 | City Agency 2 | San Mateo 15 | 0.556 | 7th Avenue Park | 1940 | Local Park 2 | 4 | |
7909 | 7909 | 7908 | {"type": "Polygon", "coordinates": [[[-122.32427, 37.56169], [-122.3221, 37.56319], [-122.32082, 37.56202], [-122.32141, 37.56161], [-122.32142, 37.56159], [-122.32012, 37.5604], [-122.32038, 37.56022], [-122.32088, 37.56068], [-122.32219, 37.55977], [-122.32427, 37.56169]]]} | Open Access 1 | 10244 | Central Park | 17059 | 1310 | San Mateo, City of 98 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | San Mateo 15 | 16.261 | Central Park | 1940 | Local Park 2 | 4 | |
8572 | 8572 | 8571 | {"type": "Polygon", "coordinates": [[[-121.87488, 37.32302], [-121.87497, 37.32314], [-121.87496, 37.32318], [-121.87417, 37.32356], [-121.87412, 37.32354], [-121.87388, 37.32322], [-121.87424, 37.32298], [-121.87443, 37.32323], [-121.87488, 37.32302]]]} | Open Access 1 | 13632 | Bestor Art Park | 16043 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 0.719 | Bestor Art Park | 1940 | Local Park 2 | 4 | |
8606 | 8606 | 8605 | {"type": "Polygon", "coordinates": [[[-121.85528, 37.3527], [-121.85526, 37.35275], [-121.85369, 37.35349], [-121.85316, 37.35276], [-121.85393, 37.35239], [-121.85364, 37.352], [-121.85396, 37.35184], [-121.85357, 37.35144], [-121.85397, 37.35125], [-121.85437, 37.35165], [-121.85483, 37.3522], [-121.85527, 37.35267], [-121.85528, 37.3527]]]} | Open Access 1 | 13697 | Mexican Cultural Heritage Garden | 22191 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 5.305 | Mexican Cultural Heritage Garden | 1940 | Local Park 2 | 4 | |
8610 | 8610 | 8609 | {"type": "Polygon", "coordinates": [[[-121.88079, 37.3135], [-121.88043, 37.31374], [-121.88022, 37.31346], [-121.88057, 37.31321], [-121.88079, 37.3135]]]} | Open Access 1 | 13719 | Parque de Padre Mateo Sheedy | 23477 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 0.382 | Parque de Padre Mateo Sheedy | 1940 | None 719 | ||
8611 | 8611 | 8610 | {"type": "Polygon", "coordinates": [[[-121.88516, 37.32837], [-121.88488, 37.32851], [-121.88432, 37.32772], [-121.88436, 37.3277], [-121.88516, 37.32837]]]} | Open Access 1 | 13722 | Parque de los Pobladores | 28077 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 0.411 | Parque de los Pobladores | 1940 | None 720 | ||
8659 | 8659 | 8658 | {"type": "Polygon", "coordinates": [[[-122.22766, 37.48359], [-122.22718, 37.48409], [-122.22707, 37.48402], [-122.22692, 37.48377], [-122.2268, 37.4835], [-122.22668, 37.48328], [-122.22659, 37.48302], [-122.22652, 37.48287], [-122.22766, 37.48359]]]} | Open Access 1 | 13895 | John S. Roselli Memorial | 20468 | 1271 | Redwood City, City of 397 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | San Mateo 15 | 1.258 | John S. Roselli Memorial | 1940 | None 727 | ||
8660 | 8660 | 8659 | {"type": "Polygon", "coordinates": [[[-122.22487, 37.48152], [-122.22446, 37.48126], [-122.2246, 37.48107], [-122.2246, 37.48107], [-122.22487, 37.48152]]]} | Open Access 1 | 13898 | Main Street Park | 21693 | 1271 | Redwood City, City of 397 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | San Mateo 15 | 0.14 | Main Street Park | 1940 | Local Park 2 | 4 | |
8671 | 8671 | 8670 | {"type": "Polygon", "coordinates": [[[-122.23003, 37.48738], [-122.22934, 37.48741], [-122.22928, 37.48659], [-122.22997, 37.48656], [-122.23003, 37.48738]]]} | Open Access 1 | 13949 | Courthouse Square | 17720 | 1271 | Redwood City, City of 397 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | San Mateo 15 | 1.375 | Courthouse Square | 1940 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);