units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
49 rows where MNG_AGENCY = 397, MNG_AG_LEV = 2 and YR_EST = 0
This data as json, copyable, CSV (advanced)
Suggested facets: GAP_STS
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
1714 | 1714 | 1713 | {"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 | 14849 | Softball Park | 25591 | 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.987 | Softball Park | 0 | Local Park 2 | 4 | |
1721 | 1721 | 1720 | {"type": "Polygon", "coordinates": [[[-122.38761, 40.57401], [-122.38715, 40.57505], [-122.38708, 40.57504], [-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 | 14879 | South City Park | 25641 | 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 | 17.504 | South City Park | 0 | Local Park 2 | 4 | |
1726 | 1726 | 1725 | {"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 | 14916 | Library Park | 21220 | 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.299 | Library Park | 0 | Local Park 2 | 4 | |
1743 | 1743 | 1742 | {"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.54669], [-122.3268, 40.54679]]]} | Open Access 1 | 14979 | Western Oaks Park | 27393 | 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.712 | Western Oaks Park | 0 | Local Park 2 | 4 | |
1785 | 1785 | 1784 | {"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 | 15399 | Valley Ridge Park | 26800 | 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.473 | Valley Ridge Park | 0 | Local Park 2 | 4 | |
1883 | 1883 | 1882 | {"type": "Polygon", "coordinates": [[[-122.42367, 40.58814], [-122.42324, 40.58806], [-122.4231, 40.58816], [-122.4227, 40.58823], [-122.42208, 40.58818], [-122.4219, 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.42035, 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.41541, 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.58983], [-122.41437, 40.58962], [-122.41457, 40.58932], [-122.4147, 40.58922], [-122.41522, 40.58888], [-122.41533, 40.58907], [-122.41599, 40.58904], [-122.4165, 40.58898], [-122.41689, 40.58885], [-122.41696, 40.58886], [-122.41698, 40.58848], [-122.4167, 40.58804], [-122.41691, 40.58775], [-122.41695, 40.58777], [-122.41706, 40.58761], [-122.41844, 40.58753], [-122.41862, 40.58718], [-122.41827, 40.58675], [-122.41825, 40.58655], [-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.41887, 40.5861], [-122.41861, 40.58659], [-122.41884, 40.587], [-122.41941, 40.58726], [-122.4195, 40.58738], [-122.4204, 40.58725], [-122.42096, 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 | 14436 | T. R. Woods Memorial Park | 26156 | 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 | 27.847 | T. R. Woods Memorial Park | 0 | Local Park 2 | 4 | |
1900 | 1900 | 1899 | {"type": "Polygon", "coordinates": [[[-122.29578, 40.56031], [-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.29532, 40.56059], [-122.29533, 40.56031], [-122.29578, 40.56031]]]} | Open Access 1 | 14660 | Stillwater Heights Park | 25852 | 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.872 | Stillwater Heights Park | 0 | Local Park 2 | 4 | |
1903 | 1903 | 1902 | {"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 | 14692 | Minder Park | 22259 | 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.176 | Minder 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 | |
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 | |
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 | |
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 | |
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 | |
3349 | 3349 | 3348 | {"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 | 24175 | Redding Soccer Park | 24234 | 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 | 39.524 | Redding Soccer Park | 0 | Local Recreation Area 3 | 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 | |
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 | |
3688 | 3688 | 3687 | {"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 | 44423 | Vista Ridge Park | 27189 | 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.929 | Vista Ridge Park | 0 | Local Park 2 | 4 | |
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 |
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]);