superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
38 rows where MNG_AGENCY = 391
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
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 | ||
8330 | 8330 | 8329 | {"type": "Polygon", "coordinates": [[[-122.25555, 37.52901], [-122.25518, 37.52934], [-122.2546, 37.52891], [-122.25483, 37.52871], [-122.25485, 37.52865], [-122.25506, 37.52866], [-122.25555, 37.52901]]]} | Open Access 1 | Portside Park | 23914 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 0.831 | Portside Park | 1973 | |
8441 | 8441 | 8440 | {"type": "Polygon", "coordinates": [[[-122.25491, 37.52957], [-122.25453, 37.52991], [-122.25419, 37.52966], [-122.25424, 37.52957], [-122.25423, 37.52947], [-122.25447, 37.52926], [-122.25491, 37.52957]]]} | Open Access 1 | Starboard Park | 25803 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 0.619 | Starboard Park | 1973 | |
8582 | 8582 | 8581 | {"type": "Polygon", "coordinates": [[[-122.2403, 37.47151], [-122.24004, 37.4718], [-122.24028, 37.47209], [-122.23817, 37.47371], [-122.23757, 37.47321], [-122.23697, 37.47352], [-122.23666, 37.47333], [-122.23611, 37.47364], [-122.23547, 37.47309], [-122.23574, 37.47276], [-122.23467, 37.47184], [-122.23503, 37.47158], [-122.23546, 37.47184], [-122.23776, 37.47011], [-122.23849, 37.47066], [-122.23953, 37.46994], [-122.23989, 37.47018], [-122.24025, 37.47086], [-122.24002, 37.47123], [-122.2403, 37.47151]]]} | Open Access 1 | Red Morton Community Park | 24226 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 30.196 | Red Morton Community Park | 1948 | |
8597 | 8597 | 8596 | {"type": "Polygon", "coordinates": [[[-122.24221, 37.47403], [-122.24071, 37.47566], [-122.24044, 37.47541], [-122.23992, 37.47485], [-122.23949, 37.47457], [-122.24014, 37.47371], [-122.2418, 37.47384], [-122.24201, 37.47393], [-122.24221, 37.47403]]]} | Open Access 1 | Redwood City holding 1 | 24246 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 7.036 | Redwood City holding 1 | 1940 | |
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 | |
9269 | 9269 | 9268 | {"type": "Polygon", "coordinates": [[[-122.23881, 37.53899], [-122.23747, 37.53876], [-122.23707, 37.53889], [-122.23682, 37.53884], [-122.23709, 37.53795], [-122.23697, 37.53794], [-122.23626, 37.5376], [-122.23606, 37.53782], [-122.2354, 37.53759], [-122.23545, 37.53735], [-122.23542, 37.53732], [-122.23522, 37.53721], [-122.23572, 37.53671], [-122.23579, 37.53669], [-122.23616, 37.5369], [-122.23636, 37.53704], [-122.23649, 37.53715], [-122.23655, 37.53725], [-122.23661, 37.5373], [-122.23668, 37.53733], [-122.23675, 37.53733], [-122.23689, 37.53729], [-122.23767, 37.5379], [-122.23872, 37.53809], [-122.2387, 37.53829], [-122.23872, 37.53874], [-122.23874, 37.53887], [-122.23881, 37.53899]]]} | Open Access 1 | Sandpiper Park | 25020 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 7.137 | Sandpiper Park | 1974 | |
9270 | 9270 | 9269 | {"type": "Polygon", "coordinates": [[[-122.25293, 37.53131], [-122.2526, 37.5316], [-122.25233, 37.53161], [-122.25197, 37.53135], [-122.25228, 37.53108], [-122.25237, 37.53112], [-122.25244, 37.53112], [-122.25252, 37.5311], [-122.25259, 37.53106], [-122.25293, 37.53131]]]} | Open Access 1 | Sandpiper Point Park | 25021 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 0.783 | Sandpiper Point Park | 1973 | |
9503 | 9503 | 9502 | {"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 | Wellesley Park | 27341 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 1.397 | Wellesley Park | 1940 | |
9555 | 9555 | 9554 | {"type": "Polygon", "coordinates": [[[-122.24241, 37.53659], [-122.24239, 37.53664], [-122.24214, 37.5369], [-122.24187, 37.53715], [-122.24181, 37.53718], [-122.24168, 37.5372], [-122.24161, 37.53724], [-122.24156, 37.53729], [-122.24156, 37.53736], [-122.24134, 37.5374], [-122.24098, 37.53713], [-122.24188, 37.53635], [-122.24196, 37.53636], [-122.24205, 37.53634], [-122.24211, 37.53636], [-122.24238, 37.53655], [-122.24241, 37.53659]]]} | Open Access 1 | Shannon Park | 25360 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 1.77 | Shannon Park | 1974 | |
9570 | 9570 | 9569 | {"type": "Polygon", "coordinates": [[[-122.24632, 37.46136], [-122.24605, 37.46147], [-122.24591, 37.46152], [-122.24588, 37.4615], [-122.24578, 37.46136], [-122.24567, 37.46123], [-122.24595, 37.46103], [-122.24632, 37.46136]]]} | Open Access 1 | Westwood Park | 27442 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 0.403 | Westwood Park | 1961 | |
9611 | 9611 | 9610 | {"type": "Polygon", "coordinates": [[[-122.25494, 37.53473], [-122.25492, 37.53478], [-122.2544, 37.53518], [-122.25423, 37.5353], [-122.25401, 37.53541], [-122.2536, 37.53555], [-122.25259, 37.53573], [-122.25248, 37.53532], [-122.25271, 37.53528], [-122.25308, 37.53526], [-122.25321, 37.53522], [-122.25333, 37.53516], [-122.25347, 37.53504], [-122.25358, 37.53487], [-122.25367, 37.53477], [-122.25429, 37.53428], [-122.25441, 37.53412], [-122.25469, 37.53426], [-122.25476, 37.53449], [-122.25494, 37.53473]]]} | Open Access 1 | Shorebird Park | 25422 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 3.675 | Shorebird Park | 1987 | |
9895 | 9895 | 9894 | {"type": "Polygon", "coordinates": [[[-122.24815, 37.48203], [-122.24752, 37.48253], [-122.24685, 37.482], [-122.24749, 37.48149], [-122.24815, 37.48203]]]} | Open Access 1 | Stafford Park | 25775 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 1.644 | Stafford Park | 1946 | |
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 | |
10038 | 10038 | 10037 | {"type": "Polygon", "coordinates": [[[-122.25257, 37.45315], [-122.25163, 37.45392], [-122.25238, 37.45451], [-122.25082, 37.45511], [-122.24965, 37.45604], [-122.24989, 37.45639], [-122.24922, 37.45695], [-122.24911, 37.457], [-122.2486, 37.45656], [-122.2477, 37.45709], [-122.24664, 37.45778], [-122.24673, 37.45813], [-122.24687, 37.45851], [-122.24702, 37.4592], [-122.24693, 37.45924], [-122.24524, 37.45769], [-122.24508, 37.45752], [-122.24512, 37.45742], [-122.24486, 37.45711], [-122.25122, 37.45206], [-122.25257, 37.45315]]]} | Open Access 1 | Stulsaft Park | 25937 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 42.469 | Stulsaft Park | 1951 |
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]);