units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
57 rows where MNG_AGENCY = 397 sorted by SUID_NMA
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, LABEL_NAME, GAP_STS
DES_TP 12
- Local Park 41
- Local Recreation Area 6
- Local Conservation Area 1
- Local Other or Unknown 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 2
MNG_AG_TYP 1
- City Agency 57
MNG_AGENCY 1
- Redding, City of · 57 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1651 | 1651 | 1650 | {"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 | 14206 | Alta Mesa park | 15417 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 6.04 | Alta Mesa park | None 134 | |||
1653 | 1653 | 1652 | {"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 | 14233 | Amethyst Park | 15458 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 0.562 | Amethyst Park | 0 | Local Park 2 | 4 | |
14345 | 14345 | 14344 | {"type": "Polygon", "coordinates": [[[-122.30999, 40.57599], [-122.30898, 40.57598], [-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 | 44418 | Big League Dreams Sports Park | 16081 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 35.914 | Big League Dreams Sports Park | 0 | Local Recreation Area 3 | 4 | |
8766 | 8766 | 8765 | {"type": "Polygon", "coordinates": [[[-122.35048, 40.59398], [-122.35048, 40.59421], [-122.35045, 40.59425], [-122.34987, 40.59426], [-122.34984, 40.59397], [-122.35048, 40.59398]]]} | Open Access 1 | 14255 | Bobwhite Park | 16216 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 0.408 | Bobwhite Park | 0 | Local Park 2 | 4 | |
1656 | 1656 | 1655 | {"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 | 14278 | Buckeye Park | 16472 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 8.741 | Buckeye Park | 0 | Local Park 2 | 4 | |
9279 | 9279 | 9278 | {"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.39605, 40.59691], [-122.39603, 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.39515, 40.59551], [-122.39525, 40.5955], [-122.39529, 40.59545], [-122.39534, 40.59543], [-122.39588, 40.59544], [-122.39626, 40.59548], [-122.39645, 40.59553], [-122.39673, 40.59561], [-122.39678, 40.59565], [-122.39678, 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 | 15460 | Caldwell Park | 16675 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 53.31 | Caldwell Park | 0 | Local Park 2 | 4 | |
3172 | 3172 | 3171 | {"type": "Polygon", "coordinates": [[[-122.40587, 40.59649], [-122.40539, 40.59649], [-122.40538, 40.59603], [-122.40569, 40.59604], [-122.40588, 40.5961], [-122.4059, 40.59614], [-122.40588, 40.59625], [-122.40587, 40.59649]]]} | Open Access 1 | 22035 | Camelian Park | 16756 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 0.509 | Camelian Park | 0 | Local Park 2 | 4 | |
8788 | 8788 | 8787 | {"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.36564, 40.5125], [-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.51214], [-122.36895, 40.51291], [-122.36896, 40.51309]]]} | Open Access 1 | 14296 | Cascade Park | 16937 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 24.093 | Cascade Park | 0 | Local Park 2 | 4 | |
4253 | 4253 | 4252 | {"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 | 14363 | Clover Creek Park | 17435 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 1.875 | Clover Creek Park | 0 | Local Park 2 | 4 | |
13669 | 13669 | 13668 | {"type": "Polygon", "coordinates": [[[-122.32205, 40.55148], [-122.32199, 40.55645], [-122.3148, 40.55648], [-122.31478, 40.55437], [-122.31469, 40.55436], [-122.31468, 40.55392], [-122.31465, 40.55367], [-122.31461, 40.55302], [-122.31457, 40.55291], [-122.31451, 40.55278], [-122.31431, 40.55258], [-122.3141, 40.55241], [-122.31391, 40.55227], [-122.31346, 40.55207], [-122.31328, 40.55193], [-122.31297, 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.31486, 40.54926], [-122.31508, 40.54926], [-122.31556, 40.54969], [-122.31615, 40.54982], [-122.31622, 40.54973], [-122.31576, 40.54931], [-122.31848, 40.54931], [-122.31848, 40.54977], [-122.31852, 40.54977], [-122.31852, 40.55097], [-122.31848, 40.55102], [-122.31848, 40.55103], [-122.32024, 40.552], [-122.32066, 40.55188], [-122.32067, 40.55147], [-122.32205, 40.55148]]]} | Open Access 1 | 36037 | Clover Creek Preserve | 17436 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 127.579 | Clover Creek Preserve | 0 | Local Conservation Area 4 | 2 | |
9227 | 9227 | 9226 | {"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.38168, 40.58873], [-122.38183, 40.5886]]]} | Open Access 1 | 15342 | Convention Center Grounds | 17610 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 18.713 | Convention Ctr. Grounds | None 760 | |||
9121 | 9121 | 9120 | {"type": "Polygon", "coordinates": [[[-122.40794, 40.55061], [-122.40759, 40.55096], [-122.40646, 40.55022], [-122.40674, 40.54997], [-122.4066, 40.54987], [-122.40761, 40.549], [-122.40794, 40.55061]]]} | Open Access 1 | 15121 | Country Heights Park | 17697 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 3.58 | Country Heights Park | 0 | Local Park 2 | 4 | |
3687 | 3687 | 3686 | {"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 | 44422 | Creekside Park | 17778 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 0.88 | Creekside Park | 0 | Local Park 2 | 4 | |
3350 | 3350 | 3349 | {"type": "Polygon", "coordinates": [[[-122.34575, 40.54282], [-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.54282]]]} | Open Access 1 | 24178 | East Oak Park | 18378 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 2.637 | East Oak Park | 0 | Local Park 2 | 4 | |
9029 | 9029 | 9028 | {"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 | 14944 | Enterprise Community Park | 18684 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 82.829 | Enterprise Community Park | 0 | Local Park 2 | 4 | |
3227 | 3227 | 3226 | {"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 | 22286 | Foothill Park | 18978 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 2.385 | Foothill Park | 0 | Local Park 2 | 4 | |
2000 | 2000 | 1999 | {"type": "Polygon", "coordinates": [[[-122.34472, 40.56826], [-122.34472, 40.56885], [-122.34406, 40.56885], [-122.34406, 40.5686], [-122.34441, 40.5686], [-122.34443, 40.56839], [-122.34453, 40.56835], [-122.34458, 40.5683], [-122.34459, 40.56825], [-122.34472, 40.56826]]]} | Open Access 1 | 15313 | Foxtail Park | 19038 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 0.593 | Foxtail Park | 0 | Local Park 2 | 4 | |
3179 | 3179 | 3178 | {"type": "Polygon", "coordinates": [[[-122.34442, 40.56839], [-122.34442, 40.56861], [-122.34406, 40.5686], [-122.34407, 40.56832], [-122.34426, 40.56832], [-122.34434, 40.56837], [-122.34442, 40.56839]]]} | Open Access 1 | 22034 | Foxtail Park | 19038 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 0.216 | Foxtail Park | 0 | Local Park 2 | 4 | |
1994 | 1994 | 1993 | {"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 | 15282 | Graham Park | 19415 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 0.194 | Graham Park | 0 | Local Park 2 | 4 | |
9065 | 9065 | 9064 | {"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 | 15005 | Hawn Park | 19750 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 0.249 | Hawn Park | 0 | Local Park 2 | 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]);