units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
57 rows where MNG_AGENCY = 397 sorted by MNG_AGENCY
This data as json, copyable, CSV (advanced)
DES_TP 11
- Local Park 23
- Local Recreation Area 5
- Local Conservation Area 1
- Local Other or Unknown 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 2
MNG_AG_TYP 1
- City Agency 37
MNG_AGENCY 1
- Redding, City of · 37 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3689 | 3689 | 3688 | {"type": "Polygon", "coordinates": [[[-122.37493, 40.51983], [-122.37441, 40.52028], [-122.374, 40.52054], [-122.37376, 40.52032], [-122.37417, 40.52006], [-122.37388, 40.51971], [-122.37427, 40.51938], [-122.37493, 40.51983]]]} | Open Access 1 | 44424 | Meadow Creek Park | 22070 | 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.467 | Meadow Creek Park | 0 | Local Park 2 | 4 | |
3926 | 3926 | 3925 | {"type": "Polygon", "coordinates": [[[-122.43529, 40.59249], [-122.43381, 40.59247], [-122.4315, 40.59257], [-122.4312, 40.59173], [-122.43217, 40.59155], [-122.43228, 40.59202], [-122.43288, 40.59229], [-122.43315, 40.59234], [-122.43336, 40.59232], [-122.43355, 40.59206], [-122.4333, 40.59203], [-122.43212, 40.58893], [-122.43185, 40.5885], [-122.43157, 40.58712], [-122.43102, 40.5861], [-122.43218, 40.58567], [-122.4323, 40.5861], [-122.43236, 40.58659], [-122.43222, 40.58698], [-122.43208, 40.58756], [-122.43282, 40.58869], [-122.43296, 40.58954], [-122.43319, 40.58969], [-122.43348, 40.59086], [-122.43407, 40.59147], [-122.4345, 40.59155], [-122.43507, 40.59205], [-122.43529, 40.59249]]]} | Open Access 1 | 36194 | Buenaventura Trail | 32406 | 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 | 16.523 | Buenaventura Trail | 0 | Local Recreation Area 3 | 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 | |
4873 | 4873 | 4872 | {"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 | 14722 | Northridge Park | 32400 | 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 | https://www.cityofredding.org/Home/Components/FacilityDirectory/FacilityDirectory/82/ | Shasta 27 | 0.749 | Northridge Park | 0 | Local Park 2 | 4 |
8337 | 8337 | 8336 | {"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 | 14785 | Old City Hall | 23083 | 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.312 | Old City Hall | None 695 | |||
8592 | 8592 | 8591 | {"type": "Polygon", "coordinates": [[[-122.36691, 40.54302], [-122.36592, 40.5431], [-122.36353, 40.54312], [-122.36021, 40.54062], [-122.35827, 40.53887], [-122.35869, 40.53865], [-122.35994, 40.53985], [-122.36268, 40.54141], [-122.36314, 40.54118], [-122.36361, 40.54142], [-122.36399, 40.54141], [-122.36435, 40.5415], [-122.36455, 40.54173], [-122.36449, 40.54212], [-122.36612, 40.54211], [-122.36613, 40.5421], [-122.366, 40.54166], [-122.36662, 40.54149], [-122.36663, 40.54153], [-122.36607, 40.5417], [-122.36613, 40.54189], [-122.36673, 40.54208], [-122.36691, 40.54302]]]} | No Public Access 3 | 13664 | John F. Reginato River Access | 32846 | 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 | 19.448 | John F. Reginato River Access | 0 | Local Recreation Area 3 | 4 | |
8603 | 8603 | 8602 | {"type": "Polygon", "coordinates": [[[-122.36272, 40.53922], [-122.3624, 40.53935], [-122.36222, 40.53906], [-122.36209, 40.53893], [-122.36194, 40.53846], [-122.36158, 40.53834], [-122.36236, 40.53775], [-122.36265, 40.53834], [-122.36232, 40.53845], [-122.36264, 40.53909], [-122.36272, 40.53922]]]} | No Public Access 3 | 13689 | Native American Burial Site | 22661 | 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.757 | Native American Burial Site | None 718 | |||
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 | |
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 | |
8812 | 8812 | 8811 | {"type": "MultiPolygon", "coordinates": [[[[-122.36938, 40.60315], [-122.36928, 40.60327], [-122.36919, 40.60346], [-122.36913, 40.60367], [-122.36912, 40.60377], [-122.36597, 40.6033], [-122.36513, 40.60346], [-122.36477, 40.60236], [-122.36435, 40.60213], [-122.36339, 40.60203], [-122.36335, 40.60023], [-122.36479, 40.60021], [-122.3648, 40.60143], [-122.36532, 40.60165], [-122.36574, 40.60123], [-122.36649, 40.6018], [-122.36652, 40.602], [-122.36938, 40.60315]]], [[[-122.37101, 40.60358], [-122.37056, 40.60414], [-122.37044, 40.60417], [-122.37058, 40.60455], [-122.37002, 40.60475], [-122.36978, 40.60389], [-122.36938, 40.60393], [-122.36936, 40.60386], [-122.36935, 40.6037], [-122.36938, 40.60355], [-122.36949, 40.60333], [-122.36974, 40.60301], [-122.36984, 40.60291], [-122.3701, 40.6027], [-122.37025, 40.60261], [-122.37054, 40.6029], [-122.37031, 40.60311], [-122.37101, 40.60358]]]]} | Open Access 1 | 14341 | Peppertree Park | 23599 | 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.154 | Peppertree Park | 0 | Local Park 2 | 4 | |
8849 | 8849 | 8848 | {"type": "MultiPolygon", "coordinates": [[[[-122.36715, 40.58632], [-122.367, 40.58675], [-122.36655, 40.58706], [-122.36559, 40.58763], [-122.36512, 40.58778], [-122.36471, 40.58802], [-122.36363, 40.5889], [-122.36323, 40.58934], [-122.3622, 40.58935], [-122.36219, 40.58931], [-122.36214, 40.58929], [-122.36099, 40.58931], [-122.36127, 40.58849], [-122.36163, 40.58793], [-122.36227, 40.5875], [-122.36295, 40.5872], [-122.36329, 40.58681], [-122.36377, 40.58642], [-122.36435, 40.58629], [-122.36512, 40.58625], [-122.36517, 40.58621], [-122.36525, 40.5862], [-122.36715, 40.58632]]], [[[-122.3784, 40.58752], [-122.37836, 40.5879], [-122.37811, 40.58817], [-122.37642, 40.58984], [-122.37589, 40.58941], [-122.3756, 40.58986], [-122.37555, 40.59047], [-122.37576, 40.59099], [-122.37612, 40.59155], [-122.37386, 40.59156], [-122.37183, 40.59166], [-122.37085, 40.59163], [-122.36993, 40.59131], [-122.37021, 40.59114], [-122.37022, 40.59112], [-122.37022, 40.59111], [-122.36908, 40.5909], [-122.36762, 40.59082], [-122.36662, 40.59067], [-122.36573, 40.59012], [-122.36492, 40.58942], [-122.36553, 40.58909], [-122.36611, 40.58956], [-122.36727, 40.58982], [-122.36834, 40.58944], [-122.36907, 40.58882], [-122.36964, 40.5882], [-122.37003, 40.58784], [-122.36955, 40.58736], [-122.3694, 40.58638], [-122.37158, 40.58654], [-122.372, 40.58654], [-122.37662, 40.58685], [-122.37752, 40.58707], [-122.37802, 40.58725], [-122.37818, 40.58735], [-122.37824, 40.58742], [-122.37828, 40.58751], [-122.3784, 40.58752]]]]} | Open Access 1 | 14464 | Turtle Bay | 32808 | 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 | 118.162 | Turtle Bay | None 742 | |||
8863 | 8863 | 8862 | {"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 | 14489 | Ravenwood Park | 24200 | 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.771 | Ravenwood Park | 0 | Local Park 2 | 4 | |
8886 | 8886 | 8885 | {"type": "MultiPolygon", "coordinates": [[[[-122.40043, 40.59672], [-122.39835, 40.59669], [-122.39835, 40.59669], [-122.39867, 40.5964], [-122.39886, 40.59619], [-122.39893, 40.59622], [-122.39895, 40.59628], [-122.39902, 40.5963], [-122.39905, 40.59628], [-122.3991, 40.59627], [-122.40043, 40.59672]]], [[[-122.40163, 40.59392], [-122.40162, 40.59423], [-122.40122, 40.59516], [-122.40117, 40.59519], [-122.40111, 40.5952], [-122.40106, 40.59531], [-122.40111, 40.59534], [-122.40112, 40.59539], [-122.40067, 40.59642], [-122.40065, 40.59645], [-122.40059, 40.59647], [-122.40052, 40.59647], [-122.39906, 40.59596], [-122.3992, 40.59579], [-122.39947, 40.5954], [-122.39969, 40.595], [-122.39978, 40.59483], [-122.39996, 40.5944], [-122.40008, 40.59396], [-122.40163, 40.59392]]]]} | Open Access 1 | 14530 | Lake Redding Park | 20963 | 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 | 9.977 | Lake Redding Park | 0 | Local Park 2 | 4 | |
8957 | 8957 | 8956 | {"type": "Polygon", "coordinates": [[[-122.39352, 40.57271], [-122.39244, 40.57282], [-122.39237, 40.57242], [-122.39255, 40.5724], [-122.39246, 40.57188], [-122.39228, 40.57189], [-122.39222, 40.57152], [-122.3933, 40.57141], [-122.39352, 40.57271]]]} | Open Access 1 | 14755 | Martin Luther King Jr. Park | 21913 | 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.107 | Martin Luther King Jr. Park | 0 | Local Park 2 | 4 | |
8977 | 8977 | 8976 | {"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.42599, 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 | 14817 | Rolling Hills Park | 24579 | 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.148 | Rolling Hills 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 | |
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 | |
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 | |
9166 | 9166 | 9165 | {"type": "Polygon", "coordinates": [[[-122.42826, 40.56759], [-122.42796, 40.56791], [-122.42804, 40.56814], [-122.42794, 40.56816], [-122.42779, 40.56783], [-122.42747, 40.56764], [-122.42634, 40.56741], [-122.42596, 40.56709], [-122.42536, 40.56709], [-122.42511, 40.56735], [-122.42509, 40.56783], [-122.42553, 40.5688], [-122.42545, 40.56879], [-122.42523, 40.56839], [-122.42492, 40.56848], [-122.42368, 40.56848], [-122.4237, 40.56621], [-122.42486, 40.56621], [-122.42485, 40.56667], [-122.42649, 40.5667], [-122.42676, 40.56621], [-122.42689, 40.56626], [-122.42734, 40.56651], [-122.42751, 40.56672], [-122.4269, 40.56671], [-122.42663, 40.56685], [-122.42641, 40.56688], [-122.4264, 40.56698], [-122.42688, 40.56732], [-122.4277, 40.56758], [-122.42826, 40.56759]]]} | Open Access 1 | 15214 | Ridgeview Park | 24360 | 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 | 10.736 | Ridgeview Park | 0 | Local Park 2 | 4 | |
9184 | 9184 | 9183 | {"type": "Polygon", "coordinates": [[[-122.38162, 40.59099], [-122.38032, 40.59104], [-122.3796, 40.59113], [-122.37875, 40.59131], [-122.37863, 40.59074], [-122.3787, 40.59061], [-122.37892, 40.59067], [-122.3791, 40.59069], [-122.37947, 40.59068], [-122.37974, 40.59065], [-122.37984, 40.59073], [-122.38016, 40.59078], [-122.38062, 40.59073], [-122.3811, 40.59081], [-122.38162, 40.59082], [-122.38162, 40.59099]]]} | Open Access 1 | 15248 | Riverfront Park | 24441 | 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.463 | Riverfront 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]);