units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
57 rows where MNG_AGENCY = 397 sorted by ACRES
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
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 | |
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 | |||
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 | |
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 | |
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 | |
13767 | 13767 | 13766 | {"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.56964], [-122.38493, 40.56955], [-122.38506, 40.56942], [-122.38522, 40.56933], [-122.38528, 40.56924], [-122.38535, 40.56927]]]} | Open Access 1 | 36292 | Parkview Green | 32402 | 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.585 | Parkview Green | 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 | |
14359 | 14359 | 14358 | {"type": "Polygon", "coordinates": [[[-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], [-122.37706, 40.51843], [-122.3764, 40.51899], [-122.37636, 40.51901]]]} | Open Access 1 | 44421 | Waverly Park | 27319 | 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.638 | Waverly 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 |
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 | |
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 | |
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 | |
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 | |
9351 | 9351 | 9350 | {"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 | 15624 | Indian Hills Park | 20203 | 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.362 | Indian Hills 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 | |
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 |
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]);