superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
27 rows where MNG_AGENCY = 421 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
ACRES 26 ✖
MNG_AG_TYP 1
- City Agency 27
MNG_AGENCY 1
- Daly City, City of · 27 ✖
ACCESS_TYP 1
- Open Access 27
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12823 | 12823 | 12822 | {"type": "Polygon", "coordinates": [[[-122.46503, 37.70656], [-122.46473, 37.70672], [-122.46448, 37.70646], [-122.46452, 37.70643], [-122.46498, 37.7065], [-122.46503, 37.70656]]]} | Open Access 1 | John Daly Tot Lot | 30038 | 1078 | Daly City, City of 421 | City 2 | City Agency 2 | http://www.dalycity.org/ | City 2 | 0.189 | John Daly Tot Lot | ||
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 | |
8283 | 8283 | 8282 | {"type": "Polygon", "coordinates": [[[-122.43747, 37.7074], [-122.43724, 37.70761], [-122.43697, 37.70744], [-122.43721, 37.70722], [-122.43747, 37.7074]]]} | Open Access 1 | Polaris Park | 23870 | 1078 | Daly City, City of 421 | City 2 | City Agency 2 | http://www.dalycity.org/ | City 2 | 0.234 | Polaris Park | 1969 | |
1558 | 1558 | 1557 | {"type": "Polygon", "coordinates": [[[-122.42983, 37.70536], [-122.42971, 37.70543], [-122.42944, 37.70564], [-122.42915, 37.70553], [-122.42926, 37.70533], [-122.42983, 37.70536]]]} | Open Access 1 | Arden Court | 15576 | 1078 | Daly City, City of 421 | City 2 | City Agency 2 | http://www.dalycity.org/ | City 2 | 0.281 | Arden Court | 1963 | |
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 | |
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 | |
11967 | 11967 | 11966 | {"type": "Polygon", "coordinates": [[[-122.47106, 37.65288], [-122.47049, 37.65305], [-122.47037, 37.65276], [-122.47096, 37.65265], [-122.47106, 37.65288]]]} | Open Access 1 | Canterbury Tot Lot | 28796 | 1078 | Daly City, City of 421 | City 2 | City Agency 2 | http://www.dalycity.org/ | City 2 | 0.402 | Canterbury Tot Lot | 1969 | |
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 | |
3317 | 3317 | 3316 | {"type": "Polygon", "coordinates": [[[-122.45024, 37.70477], [-122.44957, 37.70499], [-122.4494, 37.70475], [-122.45005, 37.70451], [-122.45024, 37.70477]]]} | Open Access 1 | Dan Gilbrech Park | 17906 | 1078 | Daly City, City of 421 | City 2 | City Agency 2 | http://www.dalycity.org/ | City 2 | 0.502 | Dan Gilbrech Park | ||
12822 | 12822 | 12821 | {"type": "Polygon", "coordinates": [[[-122.49663, 37.69768], [-122.49659, 37.69771], [-122.4965, 37.69774], [-122.49643, 37.69775], [-122.49637, 37.69777], [-122.4963, 37.69797], [-122.49625, 37.69802], [-122.49611, 37.6981], [-122.49612, 37.69816], [-122.49609, 37.69823], [-122.49605, 37.69828], [-122.49599, 37.69832], [-122.49546, 37.69842], [-122.49538, 37.69822], [-122.49551, 37.6982], [-122.49565, 37.69816], [-122.49571, 37.698], [-122.49576, 37.69796], [-122.49589, 37.69795], [-122.49619, 37.69801], [-122.49627, 37.69797], [-122.49633, 37.6978], [-122.49637, 37.69775], [-122.49647, 37.69771], [-122.49653, 37.69765], [-122.49658, 37.69763], [-122.49662, 37.69764], [-122.49663, 37.69768]]]} | Open Access 1 | Thornton Beach Vista | 30037 | 1078 | Daly City, City of 421 | City 2 | City Agency 2 | http://www.dalycity.org/ | City 2 | 0.585 | Thornton Beach Vista | ||
11969 | 11969 | 11968 | {"type": "Polygon", "coordinates": [[[-122.46717, 37.65442], [-122.46684, 37.65445], [-122.46683, 37.65457], [-122.46653, 37.65456], [-122.46654, 37.65449], [-122.46649, 37.65441], [-122.46641, 37.65438], [-122.46632, 37.65439], [-122.46624, 37.65412], [-122.46683, 37.65403], [-122.46688, 37.65431], [-122.46682, 37.65432], [-122.46683, 37.6544], [-122.46717, 37.65438], [-122.46717, 37.65442]]]} | Open Access 1 | Lycett Tot Lot | 28798 | 1078 | Daly City, City of 421 | City 2 | City Agency 2 | http://www.dalycity.org/ | City 2 | 0.605 | Lycett Tot Lot | 1980 | |
11964 | 11964 | 11963 | {"type": "Polygon", "coordinates": [[[-122.49422, 37.67986], [-122.49409, 37.68022], [-122.49374, 37.68015], [-122.49378, 37.68003], [-122.49381, 37.67984], [-122.49369, 37.67956], [-122.49403, 37.67946], [-122.49422, 37.67986]]]} | Open Access 1 | Northridge Park | 28792 | 1078 | Daly City, City of 421 | City 2 | City Agency 2 | http://www.dalycity.org/ | City 2 | 0.642 | Northridge Park | 1975 | |
3855 | 3855 | 3854 | {"type": "Polygon", "coordinates": [[[-122.46028, 37.70064], [-122.46009, 37.70065], [-122.45961, 37.70111], [-122.45957, 37.70032], [-122.46026, 37.70029], [-122.46028, 37.70064]]]} | Open Access 1 | Edgewood Park | 18440 | 1078 | Daly City, City of 421 | City 2 | City Agency 2 | http://www.dalycity.org/ | City 2 | 0.854 | Edgewood Park | ||
7054 | 7054 | 7053 | {"type": "Polygon", "coordinates": [[[-122.44177, 37.70781], [-122.4411, 37.70804], [-122.44089, 37.70804], [-122.44093, 37.70779], [-122.44118, 37.70732], [-122.44153, 37.70735], [-122.44161, 37.70745], [-122.44172, 37.70765], [-122.44177, 37.70781]]]} | Open Access 1 | Mission Hills Park | 22299 | 1078 | Daly City, City of 421 | City 2 | City Agency 2 | http://www.dalycity.org/ | City 2 | 1.012 | Mission Hills Park | 1989 | |
7865 | 7865 | 7864 | {"type": "Polygon", "coordinates": [[[-122.49561, 37.68954], [-122.49554, 37.68957], [-122.4952, 37.68961], [-122.49487, 37.68846], [-122.49527, 37.68839], [-122.49561, 37.68954]]]} | Open Access 1 | Palisades Park | 23329 | 1078 | Daly City, City of 421 | City 2 | City Agency 2 | http://www.dalycity.org/ | City 2 | 1.21 | Palisades Park | ||
6194 | 6194 | 6193 | {"type": "Polygon", "coordinates": [[[-122.45367, 37.70696], [-122.45263, 37.70735], [-122.4524, 37.70684], [-122.45315, 37.70655], [-122.45367, 37.70696]]]} | Open Access 1 | Lincoln Park | 21263 | 1078 | Daly City, City of 421 | City 2 | City Agency 2 | http://www.dalycity.org/ | City 2 | 1.286 | Lincoln Park | 1980 | |
2272 | 2272 | 2271 | {"type": "Polygon", "coordinates": [[[-122.48424, 37.70817], [-122.48238, 37.70817], [-122.48202, 37.70806], [-122.48203, 37.70759], [-122.48238, 37.7076], [-122.48347, 37.70733], [-122.48364, 37.70723], [-122.48377, 37.70732], [-122.48385, 37.70744], [-122.48389, 37.70757], [-122.48389, 37.70776], [-122.48395, 37.7079], [-122.48403, 37.708], [-122.48424, 37.70817]]]} | Open Access 1 | Broderick-Terry Dueling Place | 16414 | 1078 | Daly City, City of 421 | City 2 | City Agency 2 | http://www.dalycity.org/ | City 2 | 3.321 | Broderick-Terry Dueling Place | ||
3456 | 3456 | 3455 | {"type": "Polygon", "coordinates": [[[-122.41374, 37.70263], [-122.41365, 37.70283], [-122.41296, 37.70284], [-122.413, 37.70307], [-122.41298, 37.70324], [-122.41292, 37.70342], [-122.41281, 37.70358], [-122.41189, 37.70309], [-122.41234, 37.70208], [-122.41268, 37.70218], [-122.41267, 37.70222], [-122.4128, 37.70225], [-122.41309, 37.70201], [-122.41335, 37.70208], [-122.41318, 37.70247], [-122.41374, 37.70263]]]} | Open Access 1 | David Rowe Park | 17944 | 1078 | Daly City, City of 421 | City 2 | City Agency 2 | http://www.dalycity.org/ | City 2 | 3.516 | David Rowe Park | 1977 | |
1838 | 1838 | 1837 | {"type": "Polygon", "coordinates": [[[-122.42028, 37.7016], [-122.41998, 37.70231], [-122.41862, 37.70194], [-122.41903, 37.70091], [-122.42007, 37.70115], [-122.42028, 37.7016]]]} | Open Access 1 | Bayshore Heights | 15892 | 1078 | Daly City, City of 421 | City 2 | City Agency 2 | http://www.dalycity.org/ | City 2 | 3.701 | Bayshore Heights | 1985 | |
11136 | 11136 | 11135 | {"type": "Polygon", "coordinates": [[[-122.48453, 37.70411], [-122.48339, 37.70417], [-122.48337, 37.70264], [-122.48434, 37.70264], [-122.48453, 37.70411]]]} | Open Access 1 | Westlake Park | 27402 | 1078 | Daly City, City of 421 | City 2 | City Agency 2 | http://www.dalycity.org/ | City 2 | 3.836 | Westlake Park |
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]);