superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
38 rows where MNG_AGENCY = 391 sorted by map
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3644 | 3644 | 3643 | {"type": "MultiPolygon", "coordinates": [[[[-122.25474, 37.52654], [-122.25441, 37.52655], [-122.25441, 37.52681], [-122.25398, 37.52683], [-122.25398, 37.5271], [-122.25365, 37.52712], [-122.25354, 37.52714], [-122.25339, 37.5272], [-122.25324, 37.52731], [-122.25318, 37.52731], [-122.25322, 37.5273], [-122.25463, 37.52605], [-122.25474, 37.52613], [-122.25472, 37.52627], [-122.25474, 37.52654]]], [[[-122.25693, 37.52551], [-122.25691, 37.52553], [-122.25615, 37.52556], [-122.25562, 37.52518], [-122.256, 37.52484], [-122.25693, 37.52551]]]]} | Open Access 1 | Dolphin Park | 18193 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 2.187 | Dolphin Park | 1978 | |
4502 | 4502 | 4501 | {"type": "MultiPolygon", "coordinates": [[[[-122.25846, 37.46818], [-122.25815, 37.46833], [-122.25834, 37.4685], [-122.25793, 37.46876], [-122.25797, 37.46931], [-122.25783, 37.46935], [-122.25634, 37.46817], [-122.25647, 37.46807], [-122.2568, 37.46821], [-122.25688, 37.46822], [-122.25699, 37.46821], [-122.25707, 37.46819], [-122.25714, 37.46814], [-122.25731, 37.46791], [-122.25738, 37.46787], [-122.25752, 37.46785], [-122.25769, 37.46789], [-122.25778, 37.46789], [-122.2581, 37.46776], [-122.25841, 37.4677], [-122.25846, 37.46818]]], [[[-122.25795, 37.46767], [-122.25777, 37.46781], [-122.25771, 37.46781], [-122.25753, 37.46777], [-122.25742, 37.46777], [-122.25731, 37.46781], [-122.25716, 37.46793], [-122.25703, 37.4681], [-122.25693, 37.46815], [-122.25679, 37.46814], [-122.2565, 37.46801], [-122.25658, 37.4679], [-122.25665, 37.46777], [-122.25683, 37.46778], [-122.25704, 37.46749], [-122.25737, 37.46724], [-122.25795, 37.46767]]]]} | Open Access 1 | Garret Park | 19223 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 5.237 | Garret Park | 1978 | |
1189 | 1189 | 1188 | {"type": "Polygon", "coordinates": [[[-122.2018, 37.48289], [-122.20065, 37.48477], [-122.20046, 37.48474], [-122.20042, 37.48472], [-122.20037, 37.48466], [-122.20038, 37.48459], [-122.20146, 37.48281], [-122.2016, 37.48286], [-122.20164, 37.48282], [-122.2018, 37.48289]]]} | Open Access 1 | Andrew Spinas Park | 15485 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 1.759 | Andrew Spinas Park | 1966 | |
4121 | 4121 | 4120 | {"type": "Polygon", "coordinates": [[[-122.21235, 37.47671], [-122.21207, 37.47697], [-122.21157, 37.47664], [-122.21202, 37.47668], [-122.21235, 37.47671]]]} | Open Access 1 | Fair Oaks Community Cente | 18784 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 0.275 | Fair Oaks Community Cente | 1961 | |
8311 | 8311 | 8310 | {"type": "Polygon", "coordinates": [[[-122.21675, 37.51128], [-122.21748, 37.51193], [-122.21798, 37.51278], [-122.21825, 37.51441], [-122.21774, 37.51663], [-122.21667, 37.51812], [-122.21461, 37.52028], [-122.21314, 37.52103], [-122.21148, 37.52081], [-122.2095, 37.51999], [-122.21014, 37.51897], [-122.2112, 37.51675], [-122.21142, 37.51513], [-122.21175, 37.51412], [-122.21206, 37.51252], [-122.21291, 37.51062], [-122.21675, 37.51128]]]} | No Public Access 3 | Port of Redwood City | 23896 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 139.326 | Port of Redwood City | ||
5248 | 5248 | 5247 | {"type": "Polygon", "coordinates": [[[-122.21778, 37.48305], [-122.21644, 37.48394], [-122.21344, 37.48339], [-122.21436, 37.48199], [-122.21537, 37.48239], [-122.21599, 37.4823], [-122.21778, 37.48305]]]} | Open Access 1 | Hoover Park | 20081 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 11.512 | Hoover Park | 1984 | |
6219 | 6219 | 6218 | {"type": "Polygon", "coordinates": [[[-122.21919, 37.47246], [-122.21905, 37.47264], [-122.21812, 37.47272], [-122.2181, 37.47267], [-122.2181, 37.47261], [-122.21814, 37.47255], [-122.21919, 37.47246]]]} | Open Access 1 | Linden Park | 21292 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 0.406 | Linden Park | 1986 | |
4248 | 4248 | 4247 | {"type": "Polygon", "coordinates": [[[-122.2214, 37.47243], [-122.22103, 37.47246], [-122.2208, 37.47275], [-122.22046, 37.47258], [-122.2209, 37.47202], [-122.22124, 37.47218], [-122.22117, 37.47229], [-122.2214, 37.47243]]]} | Open Access 1 | Fleishman Park | 18942 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 0.728 | Fleishman Park | 1939 | |
5488 | 5488 | 5487 | {"type": "Polygon", "coordinates": [[[-122.22233, 37.48195], [-122.22209, 37.48228], [-122.22181, 37.48214], [-122.22181, 37.48212], [-122.22203, 37.48181], [-122.22233, 37.48195]]]} | Open Access 1 | Jardin de Ninos Park | 20365 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 0.314 | Jardin de Ninos Park | 1981 | |
9104 | 9104 | 9103 | {"type": "Polygon", "coordinates": [[[-122.22471, 37.47312], [-122.2232, 37.47432], [-122.22235, 37.475], [-122.22294, 37.47252], [-122.22471, 37.47312]]]} | Open Access 1 | Union Cemetery | 26655 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 5.762 | Union Cemetery | 1962 | |
6538 | 6538 | 6537 | {"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 | Main Street Park | 21693 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 0.14 | Main Street Park | 1940 | |
7873 | 7873 | 7872 | {"type": "Polygon", "coordinates": [[[-122.22752, 37.47069], [-122.22725, 37.4709], [-122.22736, 37.47102], [-122.22714, 37.4712], [-122.22645, 37.47104], [-122.22721, 37.47044], [-122.22752, 37.47069]]]} | Open Access 1 | Palm Park | 23345 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 0.955 | Palm Park | 1979 | |
5580 | 5580 | 5579 | {"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 | John S. Roselli Memorial | 20468 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 1.258 | John S. Roselli Memorial | 1940 | |
2966 | 2966 | 2965 | {"type": "Polygon", "coordinates": [[[-122.22793, 37.48527], [-122.22734, 37.48532], [-122.22736, 37.48573], [-122.22753, 37.48573], [-122.22757, 37.4862], [-122.22745, 37.48621], [-122.22742, 37.48624], [-122.22744, 37.48647], [-122.22728, 37.48648], [-122.22725, 37.48622], [-122.22687, 37.48623], [-122.22681, 37.48552], [-122.22635, 37.48554], [-122.22634, 37.48545], [-122.22691, 37.48543], [-122.22699, 37.48541], [-122.22702, 37.48538], [-122.22697, 37.48472], [-122.22701, 37.4847], [-122.22698, 37.48425], [-122.22714, 37.48431], [-122.22789, 37.48476], [-122.22793, 37.48527]]]} | Open Access 1 | City Center Plaza | 17290 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 3.308 | City Ctr. Plaza | 1940 | |
2575 | 2575 | 2574 | {"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 | Courthouse Square | 17720 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 1.374 | Courthouse Square | 1940 | |
8185 | 8185 | 8184 | {"type": "Polygon", "coordinates": [[[-122.23169, 37.54244], [-122.23158, 37.54252], [-122.23125, 37.5428], [-122.23063, 37.54236], [-122.2304, 37.54226], [-122.23016, 37.5422], [-122.22984, 37.54218], [-122.22955, 37.54221], [-122.22927, 37.5423], [-122.22901, 37.54244], [-122.22963, 37.54196], [-122.23157, 37.54247], [-122.23163, 37.54247], [-122.23169, 37.54244]]]} | Open Access 1 | Shores Dog Park | 25429 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 1.086 | Shores Dog Park | 1984 | |
3963 | 3963 | 3962 | {"type": "Polygon", "coordinates": [[[-122.23198, 37.47215], [-122.23113, 37.47282], [-122.23092, 37.4728], [-122.23031, 37.47231], [-122.23032, 37.47228], [-122.23124, 37.47156], [-122.23198, 37.47215]]]} | Open Access 1 | Hawes Park | 19743 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 2.669 | Hawes Park | 1935 | |
9896 | 9896 | 9895 | {"type": "Polygon", "coordinates": [[[-122.23598, 37.54658], [-122.23582, 37.54674], [-122.23572, 37.54666], [-122.23419, 37.54553], [-122.23403, 37.54512], [-122.23351, 37.54489], [-122.23359, 37.54477], [-122.23361, 37.54469], [-122.2336, 37.54461], [-122.23354, 37.54453], [-122.23409, 37.54442], [-122.23427, 37.54499], [-122.23452, 37.54541], [-122.23461, 37.54554], [-122.23476, 37.54568], [-122.23598, 37.54658]]]} | Open Access 1 | Shore Dogs Park | http://www.redwoodcity.org/parks/parksandpools/parks/parks_shore_dogs.html | 27917 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 2.278 | Shore Dogs Park | |
6506 | 6506 | 6505 | {"type": "Polygon", "coordinates": [[[-122.2363, 37.4575], [-122.23548, 37.45765], [-122.23547, 37.45761], [-122.2356, 37.45723], [-122.23544, 37.45712], [-122.23542, 37.45698], [-122.23558, 37.45711], [-122.23592, 37.45706], [-122.23602, 37.45706], [-122.23616, 37.45702], [-122.2363, 37.4575]]]} | Open Access 1 | Maddux Park | 21646 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 0.892 | Maddux Park | 2000 | |
6965 | 6965 | 6964 | {"type": "Polygon", "coordinates": [[[-122.23677, 37.49175], [-122.23601, 37.4923], [-122.23554, 37.49189], [-122.23629, 37.49134], [-122.23677, 37.49175]]]} | Open Access 1 | Mezes Park | 22193 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 1.393 | Mezes Park | 1905 |
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]);