units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
23 rows where AGNCY_LEV = 2, MNG_AGENCY = 179 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
490 | 490 | 489 | {"type": "Polygon", "coordinates": [[[-122.14785, 37.69505], [-122.1456, 37.69512], [-122.14527, 37.69542], [-122.14472, 37.69503], [-122.1447, 37.69334], [-122.14783, 37.69326], [-122.14785, 37.69505]]]} | Open Access 1 | 1962 | Washington Manor | 27270 | 1306 | San Leandro, City of 183 | City 2 | City Agency 2 | http://www.sanleandro.org/depts/rec/parks/default.asp | City 2 | 1306 | San Leandro, City of 179 | City 2 | City Agency 2 | Alameda 17 | 13.829 | Washington Manor | None 51 | |||
855 | 855 | 854 | {"type": "Polygon", "coordinates": [[[-122.18754, 37.70419], [-122.18658, 37.70459], [-122.18625, 37.70409], [-122.18721, 37.70369], [-122.18754, 37.70419]]]} | Open Access 1 | 24933 | Mulford Park | 22589 | 1306 | San Leandro, City of 183 | City 2 | City Agency 2 | http://www.sanleandro.org/depts/rec/parks/default.asp | City 2 | 1306 | San Leandro, City of 179 | City 2 | City Agency 2 | Alameda 17 | 1.495 | Mulford Park | 0 | Local Park 2 | 4 | |
1905 | 1905 | 1904 | {"type": "Polygon", "coordinates": [[[-122.15854, 37.73409], [-122.15785, 37.73441], [-122.1578, 37.73441], [-122.15775, 37.73438], [-122.1571, 37.73348], [-122.15784, 37.73314], [-122.15788, 37.73318], [-122.15801, 37.73312], [-122.15822, 37.73341], [-122.15809, 37.73348], [-122.15854, 37.73409]]]} | Open Access 1 | 14717 | McCartney Park | 21996 | 1306 | San Leandro, City of 183 | City 2 | City Agency 2 | http://www.sanleandro.org/depts/rec/parks/default.asp | City 2 | 1306 | San Leandro, City of 179 | City 2 | City Agency 2 | Alameda 17 | 2.417 | McCartney Park | 0 | Local Park 2 | 4 | |
4858 | 4858 | 4857 | {"type": "Polygon", "coordinates": [[[-122.15805, 37.68659], [-122.15802, 37.68731], [-122.15632, 37.6873], [-122.15633, 37.68607], [-122.15785, 37.68646], [-122.15805, 37.68659]]]} | Open Access 1 | 14687 | Dayton Playground | 17964 | 1306 | San Leandro, City of 183 | City 2 | City Agency 2 | http://www.sanleandro.org/depts/rec/parks/default.asp | City 2 | 1306 | San Leandro, City of 179 | City 2 | City Agency 2 | Alameda 17 | 4.184 | Dayton Playground | 0 | Local Recreation Area 3 | 4 | |
4864 | 4864 | 4863 | {"type": "Polygon", "coordinates": [[[-122.13941, 37.70672], [-122.13812, 37.7079], [-122.13784, 37.7077], [-122.13808, 37.70749], [-122.13779, 37.70725], [-122.13726, 37.7067], [-122.13801, 37.7061], [-122.13812, 37.7062], [-122.13854, 37.70649], [-122.13879, 37.70626], [-122.13941, 37.70672]]]} | Open Access 1 | 14694 | Halcyon Park | 19601 | 1306 | San Leandro, City of 183 | City 2 | City Agency 2 | http://www.sanleandro.org/depts/rec/parks/default.asp | City 2 | 1306 | San Leandro, City of 179 | City 2 | City Agency 2 | Alameda 17 | 4.522 | Halcyon Park | 0 | Local Park 2 | 4 | |
4865 | 4865 | 4864 | {"type": "Polygon", "coordinates": [[[-122.13936, 37.71019], [-122.13888, 37.71064], [-122.13817, 37.7101], [-122.13884, 37.70954], [-122.13905, 37.70969], [-122.1389, 37.70983], [-122.13936, 37.71019]]]} | Open Access 1 | 14697 | Heath Park Tennis Courts | 19779 | 1306 | San Leandro, City of 183 | City 2 | City Agency 2 | http://www.sanleandro.org/depts/rec/parks/default.asp | City 2 | 1306 | San Leandro, City of 179 | City 2 | City Agency 2 | Alameda 17 | 1.506 | Heath Park Tennis Courts | 0 | Local Recreation Area 3 | 4 | |
4867 | 4867 | 4866 | {"type": "Polygon", "coordinates": [[[-122.17236, 37.71567], [-122.17024, 37.7163], [-122.17, 37.71565], [-122.17052, 37.71554], [-122.1717, 37.71482], [-122.17232, 37.71541], [-122.17236, 37.71567]]]} | Open Access 1 | 14709 | Cherry Grove Park | 17169 | 1306 | San Leandro, City of 183 | City 2 | City Agency 2 | http://www.sanleandro.org/depts/rec/parks/default.asp | City 2 | 1306 | San Leandro, City of 179 | City 2 | City Agency 2 | Alameda 17 | 4.114 | Cherry Grove Park | 0 | Local Park 2 | 4 | |
4868 | 4868 | 4867 | {"type": "Polygon", "coordinates": [[[-122.16571, 37.72215], [-122.16428, 37.72258], [-122.1634, 37.72188], [-122.16514, 37.7212], [-122.16571, 37.72215]]]} | Open Access 1 | 14711 | Thrasher Park | 26329 | 1306 | San Leandro, City of 183 | City 2 | City Agency 2 | http://www.sanleandro.org/depts/rec/parks/default.asp | City 2 | 1306 | San Leandro, City of 179 | City 2 | City Agency 2 | Alameda 17 | 4.145 | Thrasher Park | 0 | Local Park 2 | 4 | |
4870 | 4870 | 4869 | {"type": "Polygon", "coordinates": [[[-122.1671, 37.7294], [-122.16611, 37.72986], [-122.16537, 37.72891], [-122.16558, 37.72875], [-122.16611, 37.72889], [-122.16682, 37.72921], [-122.1671, 37.7294]]]} | Open Access 1 | 14714 | Siempre Verde Park | 25441 | 1306 | San Leandro, City of 183 | City 2 | City Agency 2 | http://www.sanleandro.org/depts/rec/parks/default.asp | City 2 | 1306 | San Leandro, City of 179 | City 2 | City Agency 2 | Alameda 17 | 2.217 | Siempre Verde Park | 0 | Local Park 2 | 4 | |
4874 | 4874 | 4873 | {"type": "Polygon", "coordinates": [[[-122.15828, 37.72678], [-122.15822, 37.7269], [-122.15824, 37.72699], [-122.15789, 37.7271], [-122.15758, 37.72666], [-122.15774, 37.72643], [-122.15828, 37.72678]]]} | Open Access 1 | 14731 | Root Park | 24600 | 1306 | San Leandro, City of 183 | City 2 | City Agency 2 | http://www.sanleandro.org/depts/rec/parks/default.asp | City 2 | 1306 | San Leandro, City of 179 | City 2 | City Agency 2 | Alameda 17 | 0.62 | Root Park | 0 | Local Park 2 | 4 | |
4876 | 4876 | 4875 | {"type": "Polygon", "coordinates": [[[-122.13661, 37.71296], [-122.13657, 37.71301], [-122.13575, 37.71377], [-122.13478, 37.71313], [-122.13486, 37.71301], [-122.13372, 37.71221], [-122.13357, 37.71201], [-122.13425, 37.71134], [-122.13661, 37.71296]]]} | Open Access 1 | 14734 | Toyon Park | 26500 | 1306 | San Leandro, City of 183 | City 2 | City Agency 2 | http://www.sanleandro.org/depts/rec/parks/default.asp | City 2 | 1306 | San Leandro, City of 179 | City 2 | City Agency 2 | Alameda 17 | 7.441 | Toyon Park | 0 | Local Park 2 | 4 | |
4879 | 4879 | 4878 | {"type": "Polygon", "coordinates": [[[-122.15029, 37.72826], [-122.14873, 37.72907], [-122.14835, 37.72813], [-122.15002, 37.72768], [-122.15029, 37.72826]]]} | Open Access 1 | 14728 | Memorial Park | 22132 | 1306 | San Leandro, City of 183 | City 2 | City Agency 2 | http://www.sanleandro.org/depts/rec/parks/default.asp | City 2 | 1306 | San Leandro, City of 179 | City 2 | City Agency 2 | Alameda 17 | 3.469 | Memorial Park | 0 | Local Park 2 | 4 | |
5065 | 5065 | 5064 | {"type": "Polygon", "coordinates": [[[-122.18181, 37.72332], [-122.18154, 37.72346], [-122.18135, 37.72327], [-122.18161, 37.72312], [-122.18181, 37.72332]]]} | Open Access 1 | 14703 | Warden Park | 27255 | 1306 | San Leandro, City of 183 | City 2 | City Agency 2 | http://www.sanleandro.org/depts/rec/parks/default.asp | City 2 | 1306 | San Leandro, City of 179 | City 2 | City Agency 2 | Alameda 17 | 0.199 | Warden Park | 0 | Local Park 2 | 4 | |
5078 | 5078 | 5077 | {"type": "Polygon", "coordinates": [[[-122.16394, 37.70921], [-122.16246, 37.7098], [-122.16258, 37.71016], [-122.16137, 37.7106], [-122.16086, 37.7098], [-122.16058, 37.70911], [-122.15938, 37.70732], [-122.15942, 37.70726], [-122.16072, 37.70679], [-122.16394, 37.70921]]]} | Open Access 1 | 14701 | Pacific Recreation Complex | 23304 | 1306 | San Leandro, City of 183 | City 2 | City Agency 2 | http://www.sanleandro.org/depts/rec/parks/default.asp | City 2 | 1306 | San Leandro, City of 179 | City 2 | City Agency 2 | Alameda 17 | 19.221 | Pacific Rec. Complex | 0 | Local Recreation Area 3 | 4 | |
5160 | 5160 | 5159 | {"type": "Polygon", "coordinates": [[[-122.16245, 37.69486], [-122.1607, 37.69487], [-122.16047, 37.69275], [-122.16218, 37.6927], [-122.16245, 37.69486]]]} | Open Access 1 | 14684 | Bonaire Park | 16254 | 1306 | San Leandro, City of 183 | City 2 | City Agency 2 | http://www.sanleandro.org/depts/rec/parks/default.asp | City 2 | 1306 | San Leandro, City of 179 | City 2 | City Agency 2 | Alameda 17 | 8.978 | Bonaire Park | 0 | Local Park 2 | 4 | |
6159 | 6159 | 6158 | {"type": "Polygon", "coordinates": [[[-122.16219, 37.6888], [-122.16081, 37.68811], [-122.15945, 37.68715], [-122.15866, 37.6864], [-122.15933, 37.68626], [-122.16039, 37.68594], [-122.1614, 37.68727], [-122.16167, 37.68766], [-122.16195, 37.68817], [-122.16206, 37.68844], [-122.16219, 37.6888]]]} | Open Access 1 | 1172 | Stenzel Park | 25829 | 1306 | San Leandro, City of 183 | City 2 | City Agency 2 | http://www.sanleandro.org/depts/rec/parks/default.asp | City 2 | 1306 | San Leandro, City of 179 | City 2 | City Agency 2 | Alameda 17 | 9.106 | Stenzel Park | 0 | Local Park 2 | 4 | |
8936 | 8936 | 8935 | {"type": "Polygon", "coordinates": [[[-122.1793, 37.72205], [-122.17861, 37.72213], [-122.17839, 37.7213], [-122.1793, 37.72205], [-122.1793, 37.72205]]]} | Open Access 1 | 14706 | Cleveland Park | 17422 | 1306 | San Leandro, City of 183 | City 2 | City Agency 2 | http://www.sanleandro.org/depts/rec/parks/default.asp | City 2 | 1306 | San Leandro, City of 179 | City 2 | City Agency 2 | Alameda 17 | 0.716 | Cleveland Park | 0 | Local Park 2 | 4 | |
8937 | 8937 | 8936 | {"type": "Polygon", "coordinates": [[[-122.147, 37.69944], [-122.14584, 37.69992], [-122.14518, 37.69893], [-122.14459, 37.69916], [-122.14422, 37.69859], [-122.14533, 37.69757], [-122.14617, 37.69818], [-122.147, 37.69944]]]} | Open Access 1 | 14699 | Florest Park | 18963 | 1306 | San Leandro, City of 183 | City 2 | City Agency 2 | http://www.sanleandro.org/depts/rec/parks/default.asp | City 2 | 1306 | San Leandro, City of 179 | City 2 | City Agency 2 | Alameda 17 | 7.703 | Florest Park | 0 | Local Park 2 | 4 | |
8940 | 8940 | 8939 | {"type": "Polygon", "coordinates": [[[-122.15322, 37.73632], [-122.1534, 37.73632], [-122.1535, 37.73637], [-122.15362, 37.73648], [-122.15367, 37.7366], [-122.15365, 37.73674], [-122.15357, 37.73687], [-122.15346, 37.73693], [-122.15328, 37.73698], [-122.15311, 37.73695], [-122.15299, 37.73689], [-122.1529, 37.7368], [-122.15285, 37.73668], [-122.15288, 37.73654], [-122.15294, 37.73646], [-122.15306, 37.73637], [-122.15322, 37.73632]]]} | Open Access 1 | 14725 | Victoria Park | 27081 | 1306 | San Leandro, City of 183 | City 2 | City Agency 2 | http://www.sanleandro.org/depts/rec/parks/default.asp | City 2 | 1306 | San Leandro, City of 179 | City 2 | City Agency 2 | Alameda 17 | 1.003 | Victoria Park | 0 | Local Park 2 | 4 | |
8945 | 8945 | 8944 | {"type": "Polygon", "coordinates": [[[-122.14839, 37.71945], [-122.14493, 37.72039], [-122.14456, 37.71955], [-122.14747, 37.71877], [-122.14839, 37.71945]]]} | Open Access 1 | 14737 | McKinley Playground | 22049 | 1306 | San Leandro, City of 183 | City 2 | City Agency 2 | http://www.sanleandro.org/depts/rec/parks/default.asp | City 2 | 1306 | San Leandro, City of 179 | City 2 | City Agency 2 | Alameda 17 | 7.218 | McKinley Playground | 0 | Local Recreation Area 3 | 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]);