superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
56 rows where MNG_AGENCY = 397 sorted by ACRES
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4678 | 4678 | 4677 | {"type": "Polygon", "coordinates": [[[-122.3536, 40.56334], [-122.35329, 40.56334], [-122.35329, 40.56307], [-122.35359, 40.56308], [-122.3536, 40.56334]]]} | Open Access 1 | Graham Park | 19415 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 0.193 | Graham Park | ||
4962 | 4962 | 4961 | {"type": "Polygon", "coordinates": [[[-122.32063, 40.5651], [-122.32034, 40.5651], [-122.32033, 40.56473], [-122.32062, 40.56473], [-122.32063, 40.5651]]]} | Open Access 1 | Hawn Park | 19750 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 0.249 | Hawn Park | ||
6158 | 6158 | 6157 | {"type": "Polygon", "coordinates": [[[-122.3923, 40.58278], [-122.39221, 40.5828], [-122.39188, 40.58203], [-122.39209, 40.58198], [-122.3923, 40.58278]]]} | Open Access 1 | Library Park | 21220 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 0.299 | Library Park | ||
7644 | 7644 | 7643 | {"type": "Polygon", "coordinates": [[[-122.39151, 40.58627], [-122.39103, 40.58639], [-122.39092, 40.58614], [-122.3914, 40.58601], [-122.39151, 40.58627]]]} | Open Access 1 | Old City Hall | 23083 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 0.312 | Old City Hall | ||
2107 | 2107 | 2106 | {"type": "Polygon", "coordinates": [[[-122.35048, 40.59421], [-122.35045, 40.59425], [-122.34987, 40.59426], [-122.34984, 40.59397], [-122.35048, 40.59398], [-122.35048, 40.59421]]]} | Open Access 1 | Bobwhite Park | 16216 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 0.408 | Bobwhite Park | ||
1810 | 1810 | 1809 | {"type": "Polygon", "coordinates": [[[-122.4059, 40.59614], [-122.40588, 40.59625], [-122.40587, 40.59649], [-122.40539, 40.59649], [-122.40538, 40.59603], [-122.40569, 40.59604], [-122.40588, 40.5961], [-122.4059, 40.59614]]]} | Open Access 1 | Camelian Park | 16756 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 0.509 | Camelian Park | ||
1187 | 1187 | 1186 | {"type": "Polygon", "coordinates": [[[-122.41127, 40.59631], [-122.41084, 40.59628], [-122.41083, 40.59563], [-122.41093, 40.59566], [-122.41107, 40.59573], [-122.41114, 40.59579], [-122.41123, 40.59589], [-122.41129, 40.59605], [-122.41127, 40.59631]]]} | Open Access 1 | Amethyst Park | 15458 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 0.562 | Amethyst Park | ||
12349 | 12349 | 12348 | {"type": "Polygon", "coordinates": [[[-122.38535, 40.56927], [-122.38533, 40.56997], [-122.38492, 40.56996], [-122.38492, 40.5699], [-122.38489, 40.56981], [-122.38488, 40.56971], [-122.3849, 40.56963], [-122.38493, 40.56955], [-122.38506, 40.56942], [-122.38522, 40.56933], [-122.38528, 40.56924], [-122.38535, 40.56927]]]} | Open Access 1 | Parkview Green | 32402 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 0.585 | Parkview Green | ||
11071 | 11071 | 11070 | {"type": "Polygon", "coordinates": [[[-122.37707, 40.51839], [-122.37706, 40.51843], [-122.3764, 40.51899], [-122.37636, 40.51901], [-122.3763, 40.519], [-122.37618, 40.51891], [-122.37616, 40.51886], [-122.37618, 40.51881], [-122.37682, 40.51827], [-122.3769, 40.51825], [-122.37699, 40.5183], [-122.37707, 40.51839]]]} | Open Access 1 | Waverly Park | 27319 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 0.638 | Waverly Park | ||
12347 | 12347 | 12346 | {"type": "Polygon", "coordinates": [[[-122.36397, 40.62335], [-122.36391, 40.62334], [-122.36387, 40.62332], [-122.36379, 40.62316], [-122.3637, 40.62305], [-122.36358, 40.62295], [-122.36339, 40.62282], [-122.36339, 40.62278], [-122.36351, 40.62257], [-122.36351, 40.6225], [-122.36394, 40.62239], [-122.36397, 40.62335]]]} | Open Access 1 | Northridge Park | https://www.cityofredding.org/Home/Components/FacilityDirectory/FacilityDirectory/82/ | 32400 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 0.749 | Northridge Park | |
8560 | 8560 | 8559 | {"type": "Polygon", "coordinates": [[[-122.32243, 40.57834], [-122.32243, 40.57907], [-122.32199, 40.57906], [-122.32197, 40.57834], [-122.32243, 40.57834]]]} | Open Access 1 | Ravenwood Park | 24200 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 0.77 | Ravenwood Park | ||
4357 | 4357 | 4356 | {"type": "Polygon", "coordinates": [[[-122.34472, 40.56826], [-122.34472, 40.56885], [-122.34406, 40.56885], [-122.34407, 40.56832], [-122.34426, 40.56832], [-122.34434, 40.56837], [-122.34442, 40.56839], [-122.34453, 40.56835], [-122.34458, 40.5683], [-122.34459, 40.56825], [-122.34472, 40.56826]]]} | Open Access 1 | Foxtail Park | 19038 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 0.807 | Foxtail Park | ||
3301 | 3301 | 3300 | {"type": "Polygon", "coordinates": [[[-122.36968, 40.5209], [-122.36968, 40.52095], [-122.36827, 40.52094], [-122.36701, 40.52065], [-122.36714, 40.52043], [-122.36721, 40.5204], [-122.36751, 40.52049], [-122.36768, 40.52053], [-122.36807, 40.52054], [-122.36807, 40.52084], [-122.36828, 40.52089], [-122.36968, 40.5209]]]} | Open Access 1 | Creekside Park | 17778 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 0.881 | Creekside Park | ||
10965 | 10965 | 10964 | {"type": "Polygon", "coordinates": [[[-122.35421, 40.59997], [-122.35391, 40.60034], [-122.35384, 40.60035], [-122.3538, 40.5989], [-122.35408, 40.59916], [-122.35416, 40.59929], [-122.35418, 40.5994], [-122.35419, 40.59974], [-122.35415, 40.59985], [-122.35416, 40.5999], [-122.35421, 40.59997]]]} | Open Access 1 | Vista Ridge Park | 27189 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 0.929 | Vista Ridge Park | ||
8916 | 8916 | 8915 | {"type": "Polygon", "coordinates": [[[-122.42686, 40.573], [-122.42656, 40.57324], [-122.42622, 40.57311], [-122.42616, 40.57293], [-122.42588, 40.57296], [-122.42566, 40.57295], [-122.42567, 40.57281], [-122.42598, 40.57279], [-122.42595, 40.57255], [-122.42633, 40.57236], [-122.42668, 40.5728], [-122.42673, 40.57289], [-122.42686, 40.573]]]} | Open Access 1 | Rolling Hills Park | 24579 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1.151 | Rolling Hills Park | ||
7012 | 7012 | 7011 | {"type": "Polygon", "coordinates": [[[-122.33749, 40.59585], [-122.33659, 40.59638], [-122.3362, 40.59601], [-122.33626, 40.59604], [-122.33632, 40.59606], [-122.33639, 40.59606], [-122.33646, 40.59603], [-122.33651, 40.59599], [-122.33653, 40.59593], [-122.33652, 40.59587], [-122.33649, 40.59584], [-122.3371, 40.59547], [-122.33749, 40.59585]]]} | Open Access 1 | Minder Park | 22259 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1.176 | Minder Park | ||
4295 | 4295 | 4294 | {"type": "Polygon", "coordinates": [[[-122.40445, 40.56459], [-122.40409, 40.56485], [-122.40378, 40.565], [-122.40356, 40.5647], [-122.40284, 40.56405], [-122.40413, 40.56436], [-122.40445, 40.56459]]]} | Open Access 1 | Indian Hills Park | 20203 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1.362 | Indian Hills Park | ||
6860 | 6860 | 6859 | {"type": "Polygon", "coordinates": [[[-122.37493, 40.51983], [-122.37441, 40.52028], [-122.374, 40.52054], [-122.37376, 40.52032], [-122.37416, 40.52006], [-122.37388, 40.51971], [-122.37427, 40.51938], [-122.37493, 40.51983]]]} | Open Access 1 | Meadow Creek Park | 22070 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1.471 | Meadow Creek Park | ||
10631 | 10631 | 10630 | {"type": "Polygon", "coordinates": [[[-122.36741, 40.61555], [-122.36628, 40.61593], [-122.36601, 40.61551], [-122.36645, 40.6155], [-122.36637, 40.61519], [-122.3674, 40.61519], [-122.36741, 40.61555]]]} | Open Access 1 | Valley Ridge Park | 26800 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1.475 | Valley Ridge Park | ||
11126 | 11126 | 11125 | {"type": "Polygon", "coordinates": [[[-122.3268, 40.54679], [-122.32658, 40.54734], [-122.32639, 40.54734], [-122.32571, 40.54716], [-122.32576, 40.54637], [-122.32627, 40.54648], [-122.32654, 40.54668], [-122.3268, 40.54679]]]} | Open Access 1 | Western Oaks Park | 27393 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1.711 | Western Oaks 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]);