superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
56 rows where MNG_AGENCY = 397 sorted by rowid descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12351 | 12351 | 12350 | {"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.59207], [-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.59085], [-122.43407, 40.59147], [-122.4345, 40.59155], [-122.43507, 40.59205], [-122.43529, 40.59249]]]} | Open Access 1 | Buenaventura Trail | 32406 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 16.532 | Buenaventura Trail | ||
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 | ||
12348 | 12348 | 12347 | {"type": "Polygon", "coordinates": [[[-122.40749, 40.57803], [-122.40618, 40.57825], [-122.40607, 40.57793], [-122.40606, 40.57777], [-122.40599, 40.57763], [-122.40586, 40.57746], [-122.40578, 40.57728], [-122.40663, 40.57722], [-122.40669, 40.57769], [-122.40737, 40.5776], [-122.40749, 40.57803]]]} | Open Access 1 | Benton Dog Park | 32401 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 2.33 | Benton Dog 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 | |
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 | ||
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 | ||
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 | ||
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 | ||
10204 | 10204 | 10203 | {"type": "Polygon", "coordinates": [[[-122.42367, 40.58814], [-122.42324, 40.58806], [-122.4231, 40.58816], [-122.4227, 40.58823], [-122.42208, 40.58818], [-122.42189, 40.58782], [-122.42166, 40.58768], [-122.42139, 40.58764], [-122.42107, 40.58769], [-122.42085, 40.58785], [-122.42076, 40.58806], [-122.42077, 40.58821], [-122.42036, 40.58833], [-122.42017, 40.5884], [-122.41991, 40.58785], [-122.41936, 40.58776], [-122.41866, 40.58774], [-122.4184, 40.58811], [-122.41847, 40.58853], [-122.41903, 40.58862], [-122.41911, 40.58872], [-122.41787, 40.58898], [-122.41596, 40.58981], [-122.4154, 40.58993], [-122.41497, 40.59016], [-122.41374, 40.59111], [-122.41363, 40.59116], [-122.41335, 40.59096], [-122.41369, 40.59073], [-122.41383, 40.59057], [-122.41414, 40.59014], [-122.4143, 40.58984], [-122.41437, 40.58962], [-122.41457, 40.58932], [-122.4147, 40.58922], [-122.41522, 40.58888], [-122.41534, 40.58907], [-122.41599, 40.58904], [-122.4165, 40.58898], [-122.41689, 40.58885], [-122.41696, 40.58885], [-122.41697, 40.58848], [-122.4167, 40.58804], [-122.41691, 40.58775], [-122.41695, 40.58776], [-122.41706, 40.58761], [-122.41844, 40.58753], [-122.41862, 40.58718], [-122.41827, 40.58675], [-122.41825, 40.58656], [-122.41805, 40.58656], [-122.41782, 40.5862], [-122.41752, 40.58613], [-122.4164, 40.58622], [-122.4164, 40.58616], [-122.41701, 40.58612], [-122.417, 40.58599], [-122.41793, 40.58591], [-122.41794, 40.58588], [-122.41831, 40.58585], [-122.41832, 40.58586], [-122.41848, 40.58585], [-122.42041, 40.58554], [-122.42178, 40.58517], [-122.42193, 40.58549], [-122.42136, 40.58548], [-122.42086, 40.5856], [-122.42026, 40.5858], [-122.41888, 40.5861], [-122.41861, 40.5866], [-122.41884, 40.587], [-122.41941, 40.58726], [-122.4195, 40.58737], [-122.4204, 40.58725], [-122.42095, 40.58722], [-122.42094, 40.58676], [-122.42191, 40.58661], [-122.42199, 40.58685], [-122.42211, 40.58703], [-122.42298, 40.58715], [-122.42338, 40.58681], [-122.42339, 40.58644], [-122.42361, 40.58647], [-122.42383, 40.58716], [-122.42384, 40.58731], [-122.42367, 40.58814]]]} | Open Access 1 | T. R. Woods Memorial Park | 26156 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 27.885 | T. R. Woods Memorial Park | ||
9972 | 9972 | 9971 | {"type": "Polygon", "coordinates": [[[-122.29578, 40.56147], [-122.29483, 40.56147], [-122.29482, 40.56112], [-122.29503, 40.56099], [-122.29514, 40.56089], [-122.29523, 40.56078], [-122.29531, 40.56059], [-122.29533, 40.56031], [-122.29578, 40.56031], [-122.29578, 40.56147]]]} | Open Access 1 | Stillwater Heights Park | 25852 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1.872 | Stillwater Heights Park | ||
9793 | 9793 | 9792 | {"type": "Polygon", "coordinates": [[[-122.38761, 40.57401], [-122.38715, 40.57505], [-122.38707, 40.57505], [-122.38665, 40.57598], [-122.38658, 40.57606], [-122.38647, 40.57612], [-122.38622, 40.57617], [-122.38602, 40.57616], [-122.38584, 40.57613], [-122.38372, 40.57537], [-122.38484, 40.57301], [-122.38761, 40.57401]]]} | Open Access 1 | South City Park | 25641 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 17.504 | South City Park | ||
9756 | 9756 | 9755 | {"type": "Polygon", "coordinates": [[[-122.38468, 40.57295], [-122.3842, 40.57397], [-122.3827, 40.57341], [-122.38331, 40.57245], [-122.38468, 40.57295]]]} | Open Access 1 | Softball Park | 25591 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 3.986 | Softball Park | ||
9108 | 9108 | 9107 | {"type": "Polygon", "coordinates": [[[-122.44466, 40.60043], [-122.4434, 40.60041], [-122.44331, 40.60019], [-122.44295, 40.59974], [-122.44266, 40.5994], [-122.44251, 40.59917], [-122.44224, 40.59894], [-122.44206, 40.59867], [-122.44161, 40.59819], [-122.4413, 40.59794], [-122.44111, 40.59774], [-122.44088, 40.59758], [-122.44065, 40.59735], [-122.43968, 40.59689], [-122.43938, 40.59661], [-122.4391, 40.59639], [-122.43892, 40.59629], [-122.43838, 40.59587], [-122.43793, 40.59556], [-122.43781, 40.5955], [-122.43759, 40.59542], [-122.4368, 40.59506], [-122.43647, 40.59495], [-122.43603, 40.59468], [-122.43547, 40.59445], [-122.43533, 40.5944], [-122.4352, 40.5944], [-122.43491, 40.59434], [-122.43458, 40.5942], [-122.43432, 40.59416], [-122.43416, 40.5941], [-122.4339, 40.59404], [-122.43327, 40.59383], [-122.43312, 40.59381], [-122.43296, 40.59375], [-122.43285, 40.59374], [-122.43276, 40.59375], [-122.43248, 40.59384], [-122.4324, 40.59391], [-122.43218, 40.59396], [-122.43162, 40.59393], [-122.43113, 40.59406], [-122.43093, 40.59408], [-122.43084, 40.59412], [-122.43075, 40.59411], [-122.43034, 40.59416], [-122.43023, 40.59419], [-122.42992, 40.59413], [-122.42989, 40.59415], [-122.42988, 40.59418], [-122.4298, 40.59422], [-122.42957, 40.59422], [-122.42934, 40.59431], [-122.42908, 40.59436], [-122.42878, 40.59434], [-122.42882, 40.59402], [-122.42876, 40.59396], [-122.4286, 40.59402], [-122.42819, 40.59405], [-122.4274, 40.59404], [-122.42698, 40.59402], [-122.42637, 40.59378], [-122.42618, 40.59374], [-122.42582, 40.59375], [-122.4256, 40.59371], [-122.42558, 40.59348], [-122.42382, 40.5936], [-122.4238, 40.5935], [-122.42317, 40.59354], [-122.42136, 40.59325], [-122.41973, 40.59285], [-122.41606, 40.59256], [-122.41567, 40.59257], [-122.41185, 40.59203], [-122.40652, 40.59262], [-122.40609, 40.59264], [-122.40583, 40.59269], [-122.40551, 40.59266], [-122.40513, 40.59269], [-122.40465, 40.59265], [-122.40437, 40.5927], [-122.40404, 40.59261], [-122.40368, 40.5926], [-122.40335, 40.59263], [-122.40326, 40.59266], [-122.40315, 40.59267], [-122.40174, 40.59266], [-122.40149, 40.5927], [-122.40124, 40.59269], [-122.4011, 40.59271], [-122.40094, 40.59276], [-122.40077, 40.59276], [-122.40062, 40.5928], [-122.40043, 40.59279], [-122.40024, 40.5928], [-122.40021, 40.59243], [-122.40014, 40.59203], [-122.40003, 40.59164], [-122.39988, 40.59126], [-122.3997, 40.59089], [-122.39947, 40.59048], [-122.39975, 40.59076], [-122.40186, 40.59145], [-122.40187, 40.59143], [-122.40158, 40.59106], [-122.40244, 40.59134], [-122.40363, 40.59167], [-122.40481, 40.59189], [-122.40568, 40.59201], [-122.40718, 40.59204], [-122.40809, 40.59202], [-122.40889, 40.59203], [-122.40983, 40.59197], [-122.41041, 40.59195], [-122.41113, 40.59196], [-122.41189, 40.592], [-122.41792, 40.59243], [-122.42105, 40.59268], [-122.42227, 40.59282], [-122.42435, 40.59317], [-122.42493, 40.59324], [-122.42623, 40.59328], [-122.4272, 40.59329], [-122.42755, 40.59328], [-122.42807, 40.59324], [-122.42841, 40.5932], [-122.4297, 40.59294], [-122.43025, 40.59288], [-122.43188, 40.59284], [-122.43308, 40.5928], [-122.43427, 40.59278], [-122.43486, 40.5928], [-122.43562, 40.59291], [-122.43592, 40.59298], [-122.43616, 40.59306], [-122.43666, 40.59329], [-122.4369, 40.59311], [-122.43731, 40.59309], [-122.43764, 40.5929], [-122.43825, 40.59319], [-122.43866, 40.59343], [-122.43901, 40.59367], [-122.43932, 40.59391], [-122.43959, 40.59415], [-122.43984, 40.5944], [-122.44107, 40.59582], [-122.44122, 40.59577], [-122.44223, 40.59697], [-122.4441, 40.59908], [-122.44434, 40.59948], [-122.44457, 40.59996], [-122.44466, 40.60043]]]} | Open Access 1 | Sacramento River South Trailhead | 24773 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 98.817 | Sacramento River South Trailhead | ||
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 | ||
8782 | 8782 | 8781 | {"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 | Riverfront Park | 24441 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 2.462 | Riverfront Park | ||
8779 | 8779 | 8778 | {"type": "Polygon", "coordinates": [[[-122.35486, 40.54442], [-122.35483, 40.5452], [-122.35479, 40.5453], [-122.35479, 40.54536], [-122.35367, 40.54535], [-122.35324, 40.54401], [-122.35446, 40.54404], [-122.35438, 40.54437], [-122.35486, 40.54442]]]} | Open Access 1 | Rivercrest Park | 24438 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 3.885 | Rivercrest Park | ||
8701 | 8701 | 8700 | {"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.42486, 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 | Ridgeview Park | 24360 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 10.753 | Ridgeview Park | ||
8589 | 8589 | 8588 | {"type": "Polygon", "coordinates": [[[-122.3076, 40.57465], [-122.30296, 40.57463], [-122.30287, 40.5745], [-122.30289, 40.57104], [-122.3076, 40.57103], [-122.3076, 40.57465]]]} | Open Access 1 | Redding Soccer Park | 24234 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 39.52 | Redding Soccer Park | ||
8588 | 8588 | 8587 | {"type": "Polygon", "coordinates": [[[-122.33303, 40.65548], [-122.33271, 40.65558], [-122.33214, 40.65572], [-122.33135, 40.6567], [-122.33143, 40.65679], [-122.33162, 40.65705], [-122.33152, 40.6574], [-122.33089, 40.6578], [-122.33071, 40.65846], [-122.33013, 40.65841], [-122.3297, 40.65941], [-122.32912, 40.65953], [-122.32918, 40.65918], [-122.32917, 40.65909], [-122.32912, 40.65893], [-122.329, 40.65879], [-122.329, 40.65874], [-122.32921, 40.65848], [-122.32936, 40.65828], [-122.32941, 40.65818], [-122.32951, 40.65795], [-122.32973, 40.65777], [-122.32985, 40.65746], [-122.33022, 40.65671], [-122.33077, 40.65619], [-122.33222, 40.65514], [-122.33228, 40.65517], [-122.33261, 40.65497], [-122.33292, 40.65525], [-122.333, 40.65538], [-122.33303, 40.65548]]]} | Open Access 1 | Redding holding 1 | 24232 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 11.166 | Redding holding 1 | ||
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 |
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]);