superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
27 rows where MNG_AGENCY = 421 sorted by rowid descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | ||
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 | ||
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 | |
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 | |
1463 | 1463 | 1462 | {"type": "Polygon", "coordinates": [[[-122.48432, 37.68299], [-122.48103, 37.68299], [-122.48102, 37.6834], [-122.48085, 37.6834], [-122.48084, 37.68317], [-122.47981, 37.68193], [-122.47935, 37.6817], [-122.47962, 37.68131], [-122.47981, 37.6809], [-122.47993, 37.68047], [-122.47998, 37.68003], [-122.48003, 37.68001], [-122.48164, 37.68001], [-122.48161, 37.68079], [-122.48418, 37.68079], [-122.48418, 37.68242], [-122.48422, 37.68271], [-122.48432, 37.68299]]]} | Open Access 1 | Alto Loma | 15428 | 1078 | Daly City, City of 421 | City 2 | City Agency 2 | http://www.dalycity.org/ | City 2 | 26.15 | Alto Loma | ||
381 | 381 | 380 | {"type": "MultiPolygon", "coordinates": [[[[-122.49447, 37.67424], [-122.49336, 37.67528], [-122.49337, 37.67793], [-122.49327, 37.67796], [-122.49306, 37.67756], [-122.49295, 37.67745], [-122.49281, 37.67737], [-122.49289, 37.67724], [-122.49268, 37.67518], [-122.49244, 37.67515], [-122.49243, 37.675], [-122.49235, 37.67486], [-122.49223, 37.67474], [-122.49207, 37.67465], [-122.49191, 37.67461], [-122.49175, 37.6746], [-122.49161, 37.67462], [-122.49141, 37.67467], [-122.49011, 37.67164], [-122.49003, 37.67155], [-122.48993, 37.67147], [-122.4898, 37.67141], [-122.48964, 37.67137], [-122.48945, 37.67093], [-122.48898, 37.67105], [-122.48889, 37.67088], [-122.48878, 37.67072], [-122.48825, 37.67013], [-122.48811, 37.66994], [-122.48803, 37.66976], [-122.48748, 37.66794], [-122.48734, 37.66768], [-122.48713, 37.66741], [-122.48919, 37.66744], [-122.48938, 37.66741], [-122.48955, 37.66732], [-122.48958, 37.66726], [-122.48951, 37.66716], [-122.48986, 37.66709], [-122.49046, 37.66708], [-122.4916, 37.66709], [-122.49163, 37.66643], [-122.49237, 37.66648], [-122.49397, 37.66684], [-122.49283, 37.66901], [-122.49275, 37.6692], [-122.49269, 37.66947], [-122.49267, 37.66971], [-122.49267, 37.66991], [-122.49273, 37.67025], [-122.49287, 37.6706], [-122.49365, 37.67184], [-122.49355, 37.67244], [-122.49404, 37.67318], [-122.49414, 37.67351], [-122.49447, 37.67424]]], [[[-122.49506, 37.6795], [-122.49514, 37.68191], [-122.4949, 37.68332], [-122.49457, 37.68502], [-122.49345, 37.68365], [-122.49343, 37.68358], [-122.49181, 37.68336], [-122.49175, 37.68282], [-122.49187, 37.68253], [-122.49162, 37.68208], [-122.49166, 37.68188], [-122.4915, 37.68186], [-122.49136, 37.6816], [-122.49152, 37.68076], [-122.49185, 37.6808], [-122.49187, 37.68076], [-122.49272, 37.68075], [-122.49337, 37.68091], [-122.49338, 37.68117], [-122.49439, 37.68118], [-122.49443, 37.6795], [-122.49506, 37.6795]]], [[[-122.49634, 37.66648], [-122.49634, 37.66661], [-122.49631, 37.66691], [-122.49635, 37.66701], [-122.49638, 37.66726], [-122.49637, 37.66733], [-122.4963, 37.66746], [-122.49623, 37.66767], [-122.49623, 37.66788], [-122.49604, 37.66856], [-122.49595, 37.66882], [-122.49585, 37.67022], [-122.49586, 37.67035], [-122.49591, 37.67051], [-122.49592, 37.67085], [-122.49596, 37.67124], [-122.49597, 37.672], [-122.49591, 37.67252], [-122.49581, 37.67291], [-122.49569, 37.67356], [-122.49557, 37.67409], [-122.49557, 37.67415], [-122.49562, 37.67424], [-122.49564, 37.67454], [-122.49572, 37.67484], [-122.49572, 37.67491], [-122.49566, 37.675], [-122.49565, 37.67508], [-122.4957, 37.67534], [-122.49568, 37.67561], [-122.49571, 37.67582], [-122.49507, 37.67582], [-122.49518, 37.67515], [-122.49519, 37.67491], [-122.49518, 37.67471], [-122.49513, 37.6745], [-122.49507, 37.67431], [-122.49472, 37.67354], [-122.4952, 37.67339], [-122.49507, 37.67289], [-122.49455, 37.67283], [-122.49445, 37.67236], [-122.49431, 37.67201], [-122.49341, 37.67058], [-122.49334, 37.66903], [-122.49426, 37.6673], [-122.49464, 37.66728], [-122.49485, 37.66685], [-122.49458, 37.66662], [-122.49466, 37.6663], [-122.49468, 37.66594], [-122.49465, 37.66561], [-122.49456, 37.66529], [-122.49446, 37.66504], [-122.49433, 37.66481], [-122.49417, 37.66459], [-122.49399, 37.66438], [-122.49495, 37.6644], [-122.49499, 37.66448], [-122.49504, 37.66499], [-122.49508, 37.66509], [-122.49516, 37.66518], [-122.49524, 37.66524], [-122.49532, 37.66525], [-122.49543, 37.66524], [-122.49549, 37.66526], [-122.4955, 37.66529], [-122.49548, 37.66553], [-122.49574, 37.66575], [-122.4959, 37.6657], [-122.49595, 37.66571], [-122.49595, 37.66574], [-122.49591, 37.66589], [-122.49606, 37.66594], [-122.49618, 37.66608], [-122.4961, 37.66614], [-122.49611, 37.66629], [-122.4962, 37.66647], [-122.49632, 37.66646], [-122.49634, 37.66648]]]]} | Open Access 1 | Mussel Rock Park | 2960 | 1078 | Daly City, City of 421 | City 2 | City Agency 2 | http://www.dalycity.org/ | City 2 | 152.423 | Mussel Rock 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]);