superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
56 rows where MNG_AGENCY = 397 sorted by SUID_NMA
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1458 | 1458 | 1457 | {"type": "Polygon", "coordinates": [[[-122.32758, 40.5533], [-122.32754, 40.55568], [-122.32646, 40.55569], [-122.32648, 40.55333], [-122.32654, 40.55329], [-122.32758, 40.5533]]]} | Open Access 1 | Alta Mesa park | 15417 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 6.039 | Alta Mesa 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 | ||
1998 | 1998 | 1997 | {"type": "Polygon", "coordinates": [[[-122.30999, 40.57599], [-122.30898, 40.57599], [-122.309, 40.57833], [-122.30524, 40.57832], [-122.30525, 40.57464], [-122.30759, 40.57465], [-122.3076, 40.57428], [-122.30798, 40.57427], [-122.30831, 40.57428], [-122.30864, 40.57441], [-122.30902, 40.57469], [-122.30997, 40.57466], [-122.30999, 40.57599]]]} | Open Access 1 | Big League Dreams Sports Park | 16081 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 35.926 | Big League Dreams Sports Park | ||
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 | ||
2325 | 2325 | 2324 | {"type": "Polygon", "coordinates": [[[-122.40194, 40.63015], [-122.40192, 40.63181], [-122.3996, 40.63185], [-122.39961, 40.63061], [-122.40016, 40.63016], [-122.40194, 40.63015]]]} | Open Access 1 | Buckeye Park | 16472 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 8.739 | Buckeye Park | ||
2484 | 2484 | 2483 | {"type": "MultiPolygon", "coordinates": [[[[-122.39912, 40.59395], [-122.39899, 40.59436], [-122.39882, 40.59477], [-122.39859, 40.59517], [-122.39824, 40.59565], [-122.39805, 40.59561], [-122.39782, 40.59558], [-122.39746, 40.59558], [-122.3973, 40.59556], [-122.39627, 40.59528], [-122.39579, 40.59523], [-122.39524, 40.59523], [-122.39488, 40.59529], [-122.39409, 40.59549], [-122.39233, 40.59606], [-122.39216, 40.5961], [-122.39198, 40.59612], [-122.39179, 40.59612], [-122.39155, 40.59607], [-122.39141, 40.59602], [-122.39123, 40.59592], [-122.39113, 40.59583], [-122.39009, 40.59464], [-122.38985, 40.59442], [-122.38982, 40.59432], [-122.38986, 40.59425], [-122.39035, 40.59377], [-122.39062, 40.5936], [-122.39136, 40.59297], [-122.3917, 40.59262], [-122.39236, 40.59284], [-122.39379, 40.59338], [-122.39602, 40.59368], [-122.39696, 40.59382], [-122.39813, 40.59392], [-122.39912, 40.59395]]], [[[-122.39813, 40.59579], [-122.39781, 40.59613], [-122.39744, 40.59645], [-122.39618, 40.59742], [-122.39602, 40.59675], [-122.39563, 40.59675], [-122.39543, 40.59673], [-122.39503, 40.59665], [-122.39325, 40.59616], [-122.39319, 40.59612], [-122.39317, 40.59606], [-122.39318, 40.59601], [-122.39324, 40.59597], [-122.39416, 40.59567], [-122.39456, 40.59556], [-122.39502, 40.59546], [-122.3951, 40.59547], [-122.39516, 40.59551], [-122.39525, 40.5955], [-122.39529, 40.59545], [-122.39535, 40.59543], [-122.39588, 40.59544], [-122.39626, 40.59548], [-122.39645, 40.59553], [-122.39673, 40.59561], [-122.39678, 40.59565], [-122.39679, 40.59571], [-122.39687, 40.59573], [-122.39697, 40.59568], [-122.39711, 40.59572], [-122.39742, 40.59576], [-122.39813, 40.59579]]]]} | Open Access 1 | Caldwell Park | 16675 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 53.307 | Caldwell 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 | ||
2677 | 2677 | 2676 | {"type": "Polygon", "coordinates": [[[-122.36896, 40.51309], [-122.36699, 40.51305], [-122.3666, 40.51308], [-122.36632, 40.51312], [-122.36511, 40.51361], [-122.36487, 40.51304], [-122.36543, 40.51252], [-122.36562, 40.51249], [-122.36554, 40.51242], [-122.36559, 40.51219], [-122.36569, 40.51201], [-122.36576, 40.51177], [-122.36586, 40.51154], [-122.36596, 40.51122], [-122.36598, 40.51068], [-122.36607, 40.51041], [-122.36627, 40.51003], [-122.36693, 40.50869], [-122.3669, 40.50884], [-122.36706, 40.50928], [-122.36729, 40.50934], [-122.36774, 40.50967], [-122.36774, 40.50972], [-122.3682, 40.51029], [-122.36853, 40.51047], [-122.3687, 40.5105], [-122.36871, 40.51136], [-122.36891, 40.51214], [-122.36862, 40.51213], [-122.36861, 40.51215], [-122.36895, 40.51291], [-122.36896, 40.51309]]]} | Open Access 1 | Cascade Park | 16937 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 24.096 | Cascade Park | ||
3032 | 3032 | 3031 | {"type": "Polygon", "coordinates": [[[-122.32107, 40.56945], [-122.32105, 40.5701], [-122.32103, 40.5702], [-122.32098, 40.57029], [-122.32093, 40.57036], [-122.32089, 40.57038], [-122.3208, 40.57037], [-122.31959, 40.56979], [-122.31959, 40.56969], [-122.32107, 40.56945]]]} | Open Access 1 | Clover Creek Park | 17435 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1.875 | Clover Creek Park | ||
3033 | 3033 | 3032 | {"type": "Polygon", "coordinates": [[[-122.32205, 40.55148], [-122.32199, 40.55645], [-122.3148, 40.55648], [-122.31478, 40.55438], [-122.31469, 40.55436], [-122.31468, 40.55392], [-122.31465, 40.55367], [-122.31461, 40.55302], [-122.31457, 40.55291], [-122.3145, 40.55278], [-122.31431, 40.55258], [-122.3141, 40.55241], [-122.31391, 40.55228], [-122.31346, 40.55207], [-122.31328, 40.55193], [-122.31296, 40.55162], [-122.31212, 40.55114], [-122.31165, 40.55096], [-122.31126, 40.55071], [-122.31081, 40.55051], [-122.3106, 40.55038], [-122.30834, 40.54925], [-122.31485, 40.54923], [-122.31487, 40.54926], [-122.31508, 40.54926], [-122.31556, 40.54969], [-122.31614, 40.54982], [-122.31621, 40.54973], [-122.31576, 40.54931], [-122.31848, 40.54931], [-122.31848, 40.54976], [-122.31852, 40.54977], [-122.31852, 40.55097], [-122.31848, 40.55101], [-122.31849, 40.55103], [-122.32024, 40.55199], [-122.32066, 40.55188], [-122.32067, 40.55147], [-122.32205, 40.55148]]]} | Open Access 1 | Clover Creek Preserve | 17436 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 127.585 | Clover Creek Preserve | ||
3182 | 3182 | 3181 | {"type": "Polygon", "coordinates": [[[-122.38183, 40.5886], [-122.38182, 40.58866], [-122.38178, 40.58872], [-122.38021, 40.59028], [-122.37998, 40.59044], [-122.37967, 40.59056], [-122.37945, 40.5906], [-122.37923, 40.59061], [-122.37897, 40.59058], [-122.37872, 40.59052], [-122.3785, 40.59041], [-122.37752, 40.58984], [-122.37746, 40.58979], [-122.37744, 40.58974], [-122.37744, 40.58967], [-122.37747, 40.58959], [-122.37803, 40.58903], [-122.37803, 40.58897], [-122.37793, 40.5888], [-122.37791, 40.58865], [-122.37793, 40.58849], [-122.37803, 40.58832], [-122.37817, 40.5882], [-122.37877, 40.58781], [-122.37897, 40.58771], [-122.37919, 40.58764], [-122.37947, 40.5876], [-122.37971, 40.58759], [-122.38167, 40.58873], [-122.38183, 40.5886]]]} | Open Access 1 | Convention Center Grounds | 17610 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 18.715 | Convention Ctr. Grounds | ||
3221 | 3221 | 3220 | {"type": "Polygon", "coordinates": [[[-122.40794, 40.55061], [-122.40759, 40.55096], [-122.40646, 40.55022], [-122.40673, 40.54997], [-122.4066, 40.54987], [-122.40761, 40.549], [-122.40794, 40.55061]]]} | Open Access 1 | Country Heights Park | 17697 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 3.582 | Country Heights 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 | ||
3798 | 3798 | 3797 | {"type": "Polygon", "coordinates": [[[-122.34575, 40.54281], [-122.34573, 40.54285], [-122.34569, 40.54286], [-122.34439, 40.54287], [-122.34439, 40.54227], [-122.34449, 40.54203], [-122.34575, 40.54202], [-122.34575, 40.54281]]]} | Open Access 1 | East Oak Park | 18378 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 2.637 | East Oak Park | ||
4040 | 4040 | 4039 | {"type": "Polygon", "coordinates": [[[-122.34342, 40.54925], [-122.34026, 40.54929], [-122.33661, 40.5493], [-122.33662, 40.54563], [-122.33654, 40.54199], [-122.3391, 40.54199], [-122.33934, 40.54222], [-122.33967, 40.54281], [-122.33954, 40.54317], [-122.33981, 40.54565], [-122.34334, 40.54567], [-122.34342, 40.54925]]]} | Open Access 1 | Enterprise Community Park | 18684 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 82.844 | Enterprise Community Park | ||
4287 | 4287 | 4286 | {"type": "Polygon", "coordinates": [[[-122.41204, 40.58349], [-122.41177, 40.5837], [-122.41148, 40.58396], [-122.41121, 40.58411], [-122.41076, 40.58299], [-122.41174, 40.58275], [-122.41204, 40.58349]]]} | Open Access 1 | Foothill Park | 18978 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 2.384 | Foothill 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 | ||
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 | ||
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 |
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]);