units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
58 rows where COUNTY = 47 sorted by SUID_NMA
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, MNG_AG_ID, MNG_AG_LEV, PARK_URL, LABEL_NAME, YR_EST, GAP_STS
DES_TP 21
- Local Park 24
- State Conservation Area 7
- Local Recreation Area 5
- Local Other or Unknown 3
- Private Conservation 2
- National Wildlife Refuge 2
- State Park 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
MNG_AGENCY 9
MNG_AG_TYP 7
ACCESS_TYP 3
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16721 | 16721 | 16720 | {"type": "MultiPolygon", "coordinates": [[[[-121.61546, 38.8977], [-121.61145, 38.89989], [-121.60959, 38.9012], [-121.60887, 38.90215], [-121.60797, 38.90268], [-121.60678, 38.90289], [-121.60609, 38.90295], [-121.59953, 38.90135], [-121.59896, 38.90147], [-121.59812, 38.90181], [-121.59159, 38.90574], [-121.58785, 38.90214], [-121.58899, 38.90098], [-121.58969, 38.90049], [-121.59032, 38.9], [-121.59124, 38.89916], [-121.5926, 38.89798], [-121.59581, 38.89653], [-121.59786, 38.89584], [-121.60036, 38.89506], [-121.60112, 38.8947], [-121.60156, 38.89433], [-121.60188, 38.89465], [-121.60363, 38.89589], [-121.60506, 38.89665], [-121.60638, 38.89714], [-121.60963, 38.89722], [-121.61048, 38.89699], [-121.61227, 38.8959], [-121.61229, 38.89587], [-121.60403, 38.89278], [-121.60556, 38.89174], [-121.60641, 38.89097], [-121.60791, 38.88997], [-121.60901, 38.8892], [-121.61078, 38.8883], [-121.61323, 38.88698], [-121.61358, 38.88774], [-121.61524, 38.89532], [-121.61546, 38.8977]]], [[[-121.59123, 38.90596], [-121.58964, 38.90691], [-121.58893, 38.90756], [-121.58477, 38.90511], [-121.58474, 38.90496], [-121.58627, 38.90367], [-121.5876, 38.90239], [-121.59123, 38.90596]]], [[[-121.58859, 38.90762], [-121.58436, 38.91072], [-121.58398, 38.91143], [-121.58386, 38.91295], [-121.58383, 38.91524], [-121.5837, 38.91888], [-121.58374, 38.92269], [-121.58329, 38.92253], [-121.58068, 38.92187], [-121.57968, 38.91968], [-121.57918, 38.91887], [-121.5789, 38.91804], [-121.57906, 38.91714], [-121.57903, 38.91476], [-121.57903, 38.91326], [-121.57913, 38.91253], [-121.57962, 38.91144], [-121.58025, 38.91047], [-121.58186, 38.90845], [-121.58243, 38.90769], [-121.58323, 38.90706], [-121.58378, 38.90656], [-121.58468, 38.90539], [-121.58859, 38.90762]]], [[[-121.60311, 39.0108], [-121.598, 39.01083], [-121.59405, 39.00988], [-121.59067, 39.0092], [-121.58842, 39.00919], [-121.58684, 39.00904], [-121.58469, 39.00904], [-121.5825, 39.00886], [-121.58161, 39.00853], [-121.58104, 39.00815], [-121.58048, 39.00754], [-121.5803, 39.00745], [-121.57962, 39.00737], [-121.57938, 39.00712], [-121.57944, 39.00669], [-121.57963, 39.00611], [-121.57979, 39.0055], [-121.58136, 39.00365], [-121.58279, 39.00131], [-121.58417, 38.99955], [-121.58711, 38.99686], [-121.58904, 38.99402], [-121.59466, 38.99402], [-121.59492, 38.99475], [-121.59621, 38.99687], [-121.59678, 38.99992], [-121.59667, 39.00034], [-121.59652, 39.00075], [-121.59631, 39.00102], [-121.59619, 39.00134], [-121.59675, 39.00361], [-121.59674, 39.0055], [-121.59695, 39.00698], [-121.59666, 39.00933], [-121.59672, 39.0096], [-121.59681, 39.00979], [-121.59694, 39.00998], [-121.59718, 39.01009], [-121.59747, 39.01017], [-121.60083, 39.01017], [-121.60311, 39.0108]]], [[[-121.61302, 39.02834], [-121.61272, 39.02878], [-121.61081, 39.03271], [-121.61072, 39.03301], [-121.61065, 39.03344], [-121.61074, 39.03394], [-121.61127, 39.03537], [-121.61162, 39.03816], [-121.61113, 39.03981], [-121.61122, 39.04073], [-121.61165, 39.04241], [-121.61109, 39.04449], [-121.60995, 39.04449], [-121.60806, 39.03638], [-121.60791, 39.03632], [-121.60784, 39.0365], [-121.60769, 39.0368], [-121.6075, 39.03678], [-121.60719, 39.03665], [-121.60696, 39.03595], [-121.60684, 39.03569], [-121.60668, 39.03543], [-121.6063, 39.03465], [-121.60645, 39.03348], [-121.60634, 39.03319], [-121.60494, 39.03129], [-121.60422, 39.03079], [-121.60301, 39.02934], [-121.60242, 39.0291], [-121.60223, 39.02894], [-121.60107, 39.02787], [-121.60095, 39.02782], [-121.60088, 39.02783], [-121.60097, 39.028], [-121.60108, 39.02813], [-121.60108, 39.02827], [-121.60086, 39.02827], [-121.60057, 39.0282], [-121.60013, 39.02801], [-121.59904, 39.02715], [-121.59813, 39.02589], [-121.59816, 39.02585], [-121.59829, 39.0258], [-121.59873, 39.02596], [-121.5988, 39.02596], [-121.59884, 39.02591], [-121.59881, 39.02581], [-121.59857, 39.0256], [-121.59814, 39.02541], [-121.59718, 39.02438], [-121.59698, 39.02431], [-121.59652, 39.02425], [-121.59563, 39.02423], [-121.59528, 39.02403], [-121.5949, 39.02376], [-121.59458, 39.02333], [-121.60428, 39.02273], [-121.60326, 39.02044], [-121.60557, 39.0204], [-121.60582, 39.02034], [-121.60721, 39.01975], [-121.60791, 39.01928], [-121.60787, 39.01883], [-121.60767, 39.01859], [-121.60676, 39.01811], [-121.60659, 39.01783], [-121.60644, 39.01728], [-121.6066, 39.01657], [-121.60696, 39.01605], [-121.60709, 39.01602], [-121.60863, 39.01715], [-121.60949, 39.01691], [-121.60959, 39.01699], [-121.61114, 39.01938], [-121.61223, 39.02109], [-121.61279, 39.02275], [-121.61267, 39.02442], [-121.61282, 39.02626], [-121.61302, 39.02834]]], [[[-121.61135, 39.09537], [-121.61065, 39.09533], [-121.60653, 39.0957], [-121.60617, 39.09577], [-121.60471, 39.09635], [-121.60209, 39.09756], [-121.60188, 39.09768], [-121.6016, 39.09768], [-121.60145, 39.09773], [-121.6009, 39.09805], [-121.59989, 39.0986], [-121.59923, 39.09889], [-121.59881, 39.099], [-121.59861, 39.0989], [-121.59795, 39.09903], [-121.59758, 39.09877], [-121.59739, 39.0984], [-121.59737, 39.09809], [-121.59607, 39.09745], [-121.5947, 39.09664], [-121.59385, 39.09577], [-121.59348, 39.0947], [-121.59363, 39.09315], [-121.59439, 39.09211], [-121.59496, 39.09182], [-121.59582, 39.0916], [-121.59632, 39.09166], [-121.59741, 39.09195], [-121.59829, 39.09215], [-121.599, 39.092], [-121.59921, 39.09167], [-121.5992, 39.09154], [-121.60091, 39.09176], [-121.59975, 39.09504], [-121.59977, 39.09614], [-121.6, 39.09675], [-121.60132, 39.09751], [-121.60147, 39.09748], [-121.60177, 39.09753], [-121.60181, 39.09745], [-121.60628, 39.09555], [-121.60998, 39.09523], [-121.61125, 39.09521], [-121.61131, 39.09525], [-121.61135, 39.09537]]]]} | Open Access 1 | 6873 | Feather River Wildlife Area | 2171 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Feather-River-WA | Sutter 47 | 1710.802 | Feather River Wildlife Area | 1991 | State Conservation Area 8 | 2 |
12627 | 12627 | 12626 | {"type": "Polygon", "coordinates": [[[-121.59056, 38.93189], [-121.5906, 38.93226], [-121.5905, 38.93257], [-121.58881, 38.9345], [-121.58881, 38.93507], [-121.58837, 38.93799], [-121.58941, 38.93802], [-121.58918, 38.93942], [-121.5886, 38.94166], [-121.58757, 38.94166], [-121.5872, 38.94279], [-121.58627, 38.94382], [-121.58599, 38.9453], [-121.58627, 38.94629], [-121.58627, 38.94645], [-121.58543, 38.95098], [-121.58543, 38.95121], [-121.58153, 38.95118], [-121.58154, 38.94959], [-121.5814, 38.94798], [-121.58105, 38.94658], [-121.58131, 38.94392], [-121.58114, 38.94224], [-121.58144, 38.94044], [-121.58217, 38.93847], [-121.5824, 38.93679], [-121.58241, 38.93581], [-121.58258, 38.93403], [-121.58245, 38.9327], [-121.58218, 38.93214], [-121.58228, 38.93118], [-121.58258, 38.92952], [-121.58295, 38.92734], [-121.58271, 38.92592], [-121.58192, 38.92389], [-121.58068, 38.92187], [-121.58329, 38.92253], [-121.58302, 38.92368], [-121.5833, 38.92433], [-121.58386, 38.92526], [-121.58628, 38.9281], [-121.58753, 38.92948], [-121.58931, 38.93031], [-121.58967, 38.93045], [-121.58962, 38.93068], [-121.58981, 38.9309], [-121.58977, 38.93102], [-121.59056, 38.93189]]]} | Open Access 1 | 29423 | Bobelaine Sanctuary | 7436 | 3046 | National Audubon Society 651 | Non Profit 6 | Non Profit - Conservation 12 | http://ca.audubon.org/ | Non Governmental Organization 10 | 3046 | National Audubon Society 640 | Non Profit 6 | Non Profit - Conservation 12 | http://www.sacramentoaudubon.org/bobelainesanctuary.html | Sutter 47 | 353.691 | Bobelaine Sanctuary | 0 | Private Conservation 16 | 2 |
12717 | 12717 | 12716 | {"type": "MultiPolygon", "coordinates": [[[[-121.6007, 38.7384], [-121.59981, 38.74049], [-121.59115, 38.74058], [-121.59023, 38.74346], [-121.58935, 38.74635], [-121.58496, 38.74644], [-121.58503, 38.74523], [-121.58488, 38.74496], [-121.58336, 38.74324], [-121.58352, 38.74306], [-121.58355, 38.74272], [-121.58366, 38.74229], [-121.5843, 38.74056], [-121.58581, 38.73629], [-121.59247, 38.73626], [-121.59185, 38.73841], [-121.59185, 38.73842], [-121.6007, 38.7384]]], [[[-121.58903, 38.7474], [-121.58849, 38.74926], [-121.58654, 38.7493], [-121.5865, 38.74746], [-121.58903, 38.7474]]]]} | No Public Access 3 | 29732 | Atkinson | 15671 | 2092 | Natomas Basin Conservancy 634 | Special District 4 | Flood District 8 | http://www.natomasbasin.org/ | Special District 4 | 2092 | Natomas Basin Conservancy 623 | Special District 4 | Flood District 9 | Sutter 47 | 207.413 | Atkinson | None 1113 | |||
13174 | 13174 | 13173 | {"type": "MultiPolygon", "coordinates": [[[[-121.56754, 38.78412], [-121.56281, 38.78417], [-121.56279, 38.78305], [-121.559, 38.78306], [-121.55896, 38.78247], [-121.55883, 38.78192], [-121.55796, 38.77936], [-121.56749, 38.77925], [-121.56754, 38.78412]]], [[[-121.57688, 38.7791], [-121.57685, 38.78379], [-121.57658, 38.7838], [-121.57635, 38.78385], [-121.57612, 38.78398], [-121.57591, 38.78415], [-121.57575, 38.78438], [-121.57562, 38.78465], [-121.5756, 38.78501], [-121.57605, 38.78658], [-121.57227, 38.7866], [-121.57225, 38.78407], [-121.56773, 38.78412], [-121.56767, 38.77925], [-121.57688, 38.7791]]]]} | No Public Access 3 | 35158 | Bennett North | 16014 | 2092 | Natomas Basin Conservancy 634 | Special District 4 | Flood District 8 | http://www.natomasbasin.org/ | Special District 4 | 2092 | Natomas Basin Conservancy 623 | Special District 4 | Flood District 9 | Sutter 47 | 220.308 | Bennett North | None 1145 | |||
12715 | 12715 | 12714 | {"type": "Polygon", "coordinates": [[[-121.58089, 38.76428], [-121.58083, 38.77153], [-121.58085, 38.77515], [-121.58084, 38.7788], [-121.57707, 38.77889], [-121.57707, 38.77795], [-121.57912, 38.77792], [-121.57912, 38.77662], [-121.57911, 38.77661], [-121.57706, 38.77662], [-121.57704, 38.76432], [-121.58089, 38.76428]]]} | No Public Access 3 | 29729 | Bennett South | 16015 | 2092 | Natomas Basin Conservancy 634 | Special District 4 | Flood District 8 | http://www.natomasbasin.org/ | Special District 4 | 2092 | Natomas Basin Conservancy 623 | Special District 4 | Flood District 9 | Sutter 47 | 125.162 | Bennett South | None 1111 | |||
2110 | 2110 | 2109 | {"type": "Polygon", "coordinates": [[[-121.61622, 39.10531], [-121.61651, 39.10739], [-121.61651, 39.10747], [-121.61644, 39.10752], [-121.61438, 39.10802], [-121.61381, 39.10659], [-121.61375, 39.1059], [-121.61622, 39.10531]]]} | Open Access 1 | 15897 | Blackburn-Talley Sports Complex | 16142 | 1386 | Yuba City, City of 441 | City 2 | City Agency 2 | http://www.yubacity.net/city-services/parks-and-recreation.html | City 2 | 1386 | Yuba City, City of 435 | City 2 | City Agency 2 | Sutter 47 | 12.758 | Blackburn-Talley Sports Complex | 0 | Local Recreation Area 3 | 4 | |
2112 | 2112 | 2111 | {"type": "Polygon", "coordinates": [[[-121.60998, 39.10162], [-121.61015, 39.10206], [-121.61014, 39.10211], [-121.60953, 39.10226], [-121.60946, 39.10224], [-121.60928, 39.10179], [-121.60998, 39.10162]]]} | Open Access 1 | 15903 | Bogue Park | 16231 | 1386 | Yuba City, City of 441 | City 2 | City Agency 2 | http://www.yubacity.net/city-services/parks-and-recreation.html | City 2 | 1386 | Yuba City, City of 435 | City 2 | City Agency 2 | Sutter 47 | 0.88 | Bogue Park | 0 | Local Park 2 | 4 | |
13176 | 13176 | 13175 | {"type": "Polygon", "coordinates": [[[-121.58368, 38.77894], [-121.58367, 38.78624], [-121.57862, 38.78635], [-121.57859, 38.78626], [-121.57859, 38.78505], [-121.57857, 38.78483], [-121.57847, 38.78457], [-121.57822, 38.78433], [-121.57798, 38.78417], [-121.57743, 38.78397], [-121.57704, 38.78389], [-121.57707, 38.7791], [-121.58368, 38.77894]]]} | No Public Access 3 | 35162 | Bolen North | 16237 | 2092 | Natomas Basin Conservancy 634 | Special District 4 | Flood District 8 | http://www.natomasbasin.org/ | Special District 4 | 2092 | Natomas Basin Conservancy 623 | Special District 4 | Flood District 9 | Sutter 47 | 107.055 | Bolen North | None 1146 | |||
12716 | 12716 | 12715 | {"type": "Polygon", "coordinates": [[[-121.5898, 38.77492], [-121.58979, 38.77858], [-121.58084, 38.7788], [-121.58085, 38.77515], [-121.5898, 38.77492]]]} | No Public Access 3 | 29730 | Bolen South | 16238 | 2092 | Natomas Basin Conservancy 634 | Special District 4 | Flood District 8 | http://www.natomasbasin.org/ | Special District 4 | 2092 | Natomas Basin Conservancy 623 | Special District 4 | Flood District 9 | Sutter 47 | 77.856 | Bolen South | None 1112 | |||
12705 | 12705 | 12704 | {"type": "MultiPolygon", "coordinates": [[[[-121.59008, 38.78617], [-121.59003, 38.79179], [-121.58388, 38.78653], [-121.58388, 38.78637], [-121.59008, 38.78617]]], [[[-121.59012, 38.77873], [-121.59011, 38.78228], [-121.59002, 38.78231], [-121.58999, 38.78603], [-121.58388, 38.78623], [-121.58389, 38.77893], [-121.59012, 38.77873]]]]} | No Public Access 3 | 29733 | Bolen West | 16239 | 2092 | Natomas Basin Conservancy 634 | Special District 4 | Flood District 8 | http://www.natomasbasin.org/ | Special District 4 | 2092 | Natomas Basin Conservancy 623 | Special District 4 | Flood District 9 | Sutter 47 | 150.027 | Bolen West | None 1107 | |||
15840 | 15840 | 15839 | {"type": "Polygon", "coordinates": [[[-121.94614, 39.23849], [-121.94629, 39.23871], [-121.94682, 39.23927], [-121.94713, 39.23955], [-121.9477, 39.24019], [-121.94792, 39.24069], [-121.94803, 39.24106], [-121.94803, 39.2416], [-121.94801, 39.24186], [-121.94792, 39.2423], [-121.94782, 39.2426], [-121.94768, 39.24288], [-121.94742, 39.24332], [-121.94728, 39.24364], [-121.94721, 39.24415], [-121.94724, 39.24445], [-121.94728, 39.24457], [-121.94732, 39.24482], [-121.94732, 39.24502], [-121.94692, 39.24616], [-121.94675, 39.24685], [-121.94664, 39.24741], [-121.94657, 39.24799], [-121.94663, 39.24845], [-121.94667, 39.24877], [-121.9469, 39.24937], [-121.9469, 39.24949], [-121.94672, 39.25007], [-121.9466, 39.25026], [-121.94612, 39.2508], [-121.94596, 39.2511], [-121.94588, 39.2515], [-121.94581, 39.25196], [-121.94562, 39.25246], [-121.94555, 39.25273], [-121.93038, 39.25271], [-121.92992, 39.25236], [-121.9291, 39.25211], [-121.92775, 39.25146], [-121.92711, 39.25084], [-121.92695, 39.25084], [-121.92644, 39.24949], [-121.92631, 39.24847], [-121.92618, 39.2482], [-121.92516, 39.2471], [-121.92474, 39.24642], [-121.9242, 39.24585], [-121.92425, 39.24561], [-121.92455, 39.24522], [-121.92444, 39.24413], [-121.92453, 39.24351], [-121.92482, 39.24307], [-121.92536, 39.24268], [-121.92571, 39.24231], [-121.92593, 39.24187], [-121.92699, 39.24115], [-121.92702, 39.24083], [-121.92682, 39.24083], [-121.92598, 39.24072], [-121.92643, 39.24036], [-121.92718, 39.23822], [-121.93906, 39.23827], [-121.94364, 39.23834], [-121.94587, 39.23827], [-121.94609, 39.23849], [-121.94614, 39.23849]]]} | No Public Access 3 | 25212 | Butte Sink National Wildlife Refuge | 16604 | 106 | United States Fish and Wildlife Service 45 | Federal 1 | Federal Agency 1 | http://www.fws.gov/ | US Fish and Wildlife Service 8 | 106 | United States Fish and Wildlife Service 44 | Federal 1 | Federal Agency 1 | Sutter 47 | 712.427 | Butte Sink NWR | 0 | National Wildlife Refuge 105 | 2 | |
8832 | 8832 | 8831 | {"type": "Polygon", "coordinates": [[[-121.6258, 39.1439], [-121.62555, 39.1439], [-121.62555, 39.14372], [-121.62559, 39.14374], [-121.6258, 39.1439]]]} | Open Access 1 | 16040 | Clark-Ainsley Mini-Park | 17385 | 1386 | Yuba City, City of 441 | City 2 | City Agency 2 | http://www.yubacity.net/city-services/parks-and-recreation.html | City 2 | 1386 | Yuba City, City of 435 | City 2 | City Agency 2 | Sutter 47 | 0.056 | Clark-Ainsley Mini-Park | 0 | Local Park 2 | 4 | |
16757 | 16757 | 16756 | {"type": "Polygon", "coordinates": [[[-121.80689, 38.88866], [-121.8054, 38.89105], [-121.80515, 38.89074], [-121.80516, 38.89056], [-121.8047, 38.88988], [-121.80428, 38.88934], [-121.80363, 38.88908], [-121.80241, 38.88865], [-121.80166, 38.88837], [-121.8014, 38.88823], [-121.80146, 38.88809], [-121.80169, 38.88805], [-121.80187, 38.888], [-121.80312, 38.88824], [-121.80392, 38.88848], [-121.80462, 38.88863], [-121.80528, 38.88858], [-121.80616, 38.88858], [-121.80689, 38.88866]]]} | Restricted Access 2 | 25313 | Collins Eddy Wildlife Area | 17521 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Sutter 47 | 12.4 | Collins Eddy Wildlife Area | 0 | State Conservation Area 8 | 2 | |
5340 | 5340 | 5339 | {"type": "Polygon", "coordinates": [[[-121.66612, 39.27216], [-121.66504, 39.27216], [-121.66505, 39.27192], [-121.66507, 39.2719], [-121.66512, 39.27188], [-121.66535, 39.27191], [-121.66602, 39.27191], [-121.66608, 39.27193], [-121.66611, 39.27204], [-121.66612, 39.27216]]]} | Open Access 1 | 15854 | Date Stree Park | 17933 | 1177 | Live Oak, City of 432 | City 2 | City Agency 2 | http://www.liveoakcity.org/index.php/departments/parks-a-recreation | City 2 | 1177 | Live Oak, City of 426 | City 2 | City Agency 2 | Sutter 47 | 0.64 | Date Stree Park | 0 | Local Park 2 | 4 | |
4262 | 4262 | 4261 | {"type": "Polygon", "coordinates": [[[-121.62968, 39.20461], [-121.62981, 39.20619], [-121.62965, 39.20795], [-121.62916, 39.20791], [-121.62904, 39.20973], [-121.62892, 39.21023], [-121.6284, 39.21125], [-121.62609, 39.21031], [-121.62113, 39.20758], [-121.62141, 39.20654], [-121.62161, 39.20636], [-121.62186, 39.20629], [-121.62207, 39.20629], [-121.62247, 39.20646], [-121.62262, 39.20647], [-121.62275, 39.20645], [-121.62321, 39.20669], [-121.62321, 39.2069], [-121.62365, 39.20717], [-121.62403, 39.2072], [-121.62491, 39.20722], [-121.62613, 39.20712], [-121.62637, 39.20707], [-121.62787, 39.20585], [-121.62845, 39.2055], [-121.6291, 39.20513], [-121.62953, 39.20457], [-121.62968, 39.20461]]]} | Restricted Access 2 | 47979 | Feather River Wildlife Area | 18861 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Sutter 47 | 61.666 | Feather River Wildlife Area | 1991 | State Conservation Area 8 | 2 | |
3642 | 3642 | 3641 | {"type": "Polygon", "coordinates": [[[-121.55976, 38.81045], [-121.55308, 38.81447], [-121.5516, 38.81536], [-121.55163, 38.80843], [-121.55929, 38.80831], [-121.5588, 38.8086], [-121.55869, 38.80876], [-121.55872, 38.80892], [-121.55888, 38.80918], [-121.55948, 38.80966], [-121.55948, 38.80977], [-121.5595, 38.80998], [-121.55976, 38.81045]]]} | No Public Access 3 | 29722 | Frazer | 19069 | 2092 | Natomas Basin Conservancy 634 | Special District 4 | Flood District 8 | http://www.natomasbasin.org/ | Special District 4 | 2092 | Natomas Basin Conservancy 623 | Special District 4 | Flood District 9 | Sutter 47 | 85.165 | Frazer | None 303 | |||
9623 | 9623 | 9622 | {"type": "Polygon", "coordinates": [[[-121.61184, 39.13289], [-121.61107, 39.133], [-121.61105, 39.13299], [-121.61082, 39.13305], [-121.61068, 39.13312], [-121.61008, 39.13353], [-121.60968, 39.13273], [-121.60943, 39.13272], [-121.60934, 39.13202], [-121.60979, 39.1316], [-121.61069, 39.13156], [-121.61082, 39.13162], [-121.61094, 39.13208], [-121.61168, 39.13197], [-121.6119, 39.13282], [-121.61189, 39.13285], [-121.61184, 39.13289]]]} | Open Access 1 | 16207 | Gauche Aquatics Park | 19242 | 1386 | Yuba City, City of 441 | City 2 | City Agency 2 | http://www.yubacity.net/city-services/parks-and-recreation.html | City 2 | 1386 | Yuba City, City of 435 | City 2 | City Agency 2 | Sutter 47 | 7.32 | Gauche Aquatics Park | 0 | Local Park 2 | 4 | |
9579 | 9579 | 9578 | {"type": "Polygon", "coordinates": [[[-121.63325, 39.13444], [-121.63323, 39.1362], [-121.63228, 39.13617], [-121.63229, 39.13444], [-121.63325, 39.13444]]]} | Open Access 1 | 16109 | Geweke Field | 19282 | 1386 | Yuba City, City of 441 | City 2 | City Agency 2 | http://www.yubacity.net/city-services/parks-and-recreation.html | City 2 | 1386 | Yuba City, City of 435 | City 2 | City Agency 2 | Sutter 47 | 3.951 | Geweke Field | 0 | Local Recreation Area 3 | 4 | |
9480 | 9480 | 9479 | {"type": "Polygon", "coordinates": [[[-121.64098, 39.15332], [-121.64098, 39.15415], [-121.64093, 39.15433], [-121.64076, 39.15472], [-121.64073, 39.15486], [-121.64072, 39.15502], [-121.6407, 39.15506], [-121.64065, 39.15507], [-121.64037, 39.15505], [-121.64019, 39.15502], [-121.6398, 39.15491], [-121.63955, 39.15487], [-121.63954, 39.15332], [-121.64098, 39.15332]]]} | Open Access 1 | 15874 | Greenwood Park | 19490 | 1386 | Yuba City, City of 441 | City 2 | City Agency 2 | http://www.yubacity.net/city-services/parks-and-recreation.html | City 2 | 1386 | Yuba City, City of 435 | City 2 | City Agency 2 | Sutter 47 | 5.412 | Greenwood Park | 0 | Local Park 2 | 4 | |
9486 | 9486 | 9485 | {"type": "Polygon", "coordinates": [[[-121.64715, 39.10226], [-121.64938, 39.10226], [-121.64942, 39.1023], [-121.64945, 39.10304], [-121.64956, 39.10344], [-121.64952, 39.10348], [-121.64949, 39.10348], [-121.64721, 39.10349], [-121.64717, 39.10348], [-121.64714, 39.10344], [-121.64711, 39.10232], [-121.64712, 39.10229], [-121.64715, 39.10226]]]} | Open Access 1 | 15915 | Happy Park | 19657 | 1386 | Yuba City, City of 441 | City 2 | City Agency 2 | http://www.yubacity.net/city-services/parks-and-recreation.html | City 2 | 1386 | Yuba City, City of 435 | City 2 | City Agency 2 | Sutter 47 | 6.778 | Happy 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]);