units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
57 rows where MNG_AGENCY = 397 sorted by YR_EST
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
9397 | 9397 | 9396 | {"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.43969, 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.43548, 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.42964, 40.59423], [-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.42559, 40.59348], [-122.42382, 40.5936], [-122.42381, 40.59349], [-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.59146], [-122.40187, 40.59144], [-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.4364, 40.59316], [-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.59583], [-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 | 15704 | Sacramento River South Trailhead | 24773 | 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 | 98.815 | Sacramento River South Trailhead | None 773 | |||
11319 | 11319 | 11318 | {"type": "Polygon", "coordinates": [[[-122.36751, 40.58459], [-122.3674, 40.58515], [-122.36738, 40.58546], [-122.3661, 40.58539], [-122.36493, 40.58524], [-122.36477, 40.58516], [-122.36349, 40.58441], [-122.36254, 40.58372], [-122.3617, 40.58309], [-122.36146, 40.58286], [-122.36297, 40.58284], [-122.3629, 40.58195], [-122.36293, 40.58152], [-122.36348, 40.58068], [-122.36366, 40.58014], [-122.36419, 40.58014], [-122.36429, 40.58027], [-122.3645, 40.58044], [-122.36475, 40.58053], [-122.36517, 40.5808], [-122.36553, 40.58117], [-122.3662, 40.58164], [-122.36659, 40.58254], [-122.36687, 40.58328], [-122.36684, 40.58365], [-122.3668, 40.58384], [-122.36708, 40.58418], [-122.36751, 40.58459]]]} | Open Access 1 | 22028 | Turtle Bay Regional Park (East) | 26588 | 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.667 | Turtle Bay RP (East) | None 991 | |||
13668 | 13668 | 13667 | {"type": "MultiPolygon", "coordinates": [[[[-122.3778, 40.56995], [-122.37773, 40.5701], [-122.3777, 40.57024], [-122.3777, 40.5704], [-122.37774, 40.57059], [-122.37773, 40.57063], [-122.37769, 40.57066], [-122.37747, 40.57077], [-122.37732, 40.57092], [-122.37711, 40.5713], [-122.37709, 40.5713], [-122.37695, 40.57161], [-122.37692, 40.57165], [-122.37685, 40.57167], [-122.37667, 40.57165], [-122.37642, 40.57167], [-122.37547, 40.57182], [-122.37535, 40.5719], [-122.37481, 40.57194], [-122.37474, 40.57197], [-122.37461, 40.57199], [-122.37458, 40.57202], [-122.37442, 40.57199], [-122.37494, 40.57155], [-122.37551, 40.57115], [-122.37577, 40.57082], [-122.37613, 40.57044], [-122.37653, 40.56986], [-122.37658, 40.56962], [-122.37723, 40.56968], [-122.3778, 40.56995]]], [[[-122.37914, 40.57064], [-122.37793, 40.57059], [-122.37788, 40.57054], [-122.37784, 40.57039], [-122.37784, 40.57023], [-122.37788, 40.57011], [-122.37793, 40.57001], [-122.37906, 40.57059], [-122.37914, 40.57064]]]]} | Open Access 1 | 36036 | Parkview Riverfront Park and Trails | 23459 | 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.943 | Parkview Riverfront Park and Trails | None 1176 | |||
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 |
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]);