units_with_maps

Table actions

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

70 rows where ACCESS_TYP = 1, MNG_AGENCY = 25 and YR_EST = 0

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP

ACCESS_TYP 1

  • Open Access · 70 ✖
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
391 391 390 {"type": "Polygon", "coordinates": [[[-122.90647, 38.50264], [-122.90621, 38.50264], [-122.9057, 38.50237], [-122.90378, 38.50239], [-122.90186, 38.50146], [-122.89966, 38.50045], [-122.89918, 38.50012], [-122.89896, 38.49992], [-122.89874, 38.4996], [-122.89862, 38.49815], [-122.89817, 38.49687], [-122.89757, 38.49608], [-122.89836, 38.49578], [-122.8985, 38.4953], [-122.89887, 38.49556], [-122.90061, 38.49693], [-122.90352, 38.49951], [-122.90396, 38.49992], [-122.90513, 38.50094], [-122.90559, 38.50128], [-122.90647, 38.50264]], [[-122.90226, 38.49992], [-122.90214, 38.49984], [-122.90159, 38.50028], [-122.90262, 38.50107], [-122.90325, 38.50075], [-122.90325, 38.50074], [-122.90226, 38.49992]]]} Open Access 1 1165 Steelhead Beach Fishing Access 32317 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   Sonoma 16 54.507 Steelhead Beach FA 0 State Recreation Area 39 4
689 689 688 {"type": "Polygon", "coordinates": [[[-122.27644, 41.23646], [-122.27565, 41.23673], [-122.27558, 41.23593], [-122.27633, 41.2358], [-122.27644, 41.23646]]]} Open Access 1 3506 Sacramento River -- Prospect Ave. Fishing Access 32282 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   Siskiyou 28 1.339 Sacramento River -- Prospect Ave. FA 0 State Recreation Area 39 4
1224 1224 1223 {"type": "Polygon", "coordinates": [[[-122.86042, 38.59925], [-122.86034, 38.59981], [-122.86039, 38.60018], [-122.86041, 38.60169], [-122.85992, 38.60156], [-122.85954, 38.60002], [-122.85952, 38.60002], [-122.85941, 38.60012], [-122.85928, 38.59999], [-122.85995, 38.5991], [-122.86042, 38.59925]]]} Open Access 1 8807 Healdsburg Fishing Access 32183 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   Sonoma 16 4.182 Healdsburg FA 0 State Recreation Area 39 4
1642 1642 1641 {"type": "MultiPolygon", "coordinates": [[[[-122.91501, 38.23223], [-122.91436, 38.23304], [-122.91323, 38.23292], [-122.91298, 38.23269], [-122.91332, 38.23235], [-122.91362, 38.23199], [-122.91396, 38.23141], [-122.91403, 38.23117], [-122.91417, 38.23093], [-122.91444, 38.23065], [-122.91472, 38.2304], [-122.91498, 38.23013], [-122.91479, 38.23083], [-122.91501, 38.23223]]], [[[-122.92228, 38.22119], [-122.92219, 38.22138], [-122.9222, 38.2214], [-122.92205, 38.22171], [-122.921, 38.22207], [-122.92063, 38.22229], [-122.91984, 38.22279], [-122.9192, 38.22313], [-122.91832, 38.22349], [-122.91766, 38.22384], [-122.9169, 38.22438], [-122.91676, 38.22491], [-122.91692, 38.22544], [-122.91697, 38.2261], [-122.91706, 38.22669], [-122.9171, 38.22705], [-122.91691, 38.22739], [-122.9167, 38.22796], [-122.91636, 38.22833], [-122.91608, 38.22869], [-122.9155, 38.22952], [-122.91512, 38.22995], [-122.91571, 38.22916], [-122.91592, 38.2289], [-122.91618, 38.22848], [-122.91635, 38.22809], [-122.91629, 38.22676], [-122.91608, 38.22537], [-122.91611, 38.22521], [-122.91622, 38.22491], [-122.91629, 38.22477], [-122.91649, 38.22449], [-122.91673, 38.22425], [-122.91702, 38.22406], [-122.91779, 38.22361], [-122.91846, 38.22313], [-122.91928, 38.22288], [-122.9198, 38.22249], [-122.92014, 38.22228], [-122.92196, 38.22151], [-122.92215, 38.22137], [-122.92228, 38.22119]]]]} Open Access 1 1917 Keys Creek Fishing Access 32194 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   Marin 23 15.8 Keys Creek FA 0 State Recreation Area 39 4
1849 1849 1848 {"type": "MultiPolygon", "coordinates": [[[[-122.94254, 40.6514], [-122.94075, 40.65216], [-122.94037, 40.65217], [-122.94034, 40.65114], [-122.94131, 40.65085], [-122.94254, 40.6514]]], [[[-122.94341, 40.6502], [-122.94276, 40.65044], [-122.94314, 40.65089], [-122.94277, 40.65114], [-122.94173, 40.6506], [-122.94119, 40.65048], [-122.94161, 40.6503], [-122.94222, 40.6503], [-122.94227, 40.64999], [-122.94239, 40.64988], [-122.94276, 40.64961], [-122.94341, 40.6502]]]]} Open Access 1 14107 Trinity River Fishing Access 32329 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   Trinity 46 7.06 Trinity River FA 0 State Recreation Area 39 4
2169 2169 2168 {"type": "Polygon", "coordinates": [[[-122.26026, 40.46551], [-122.25995, 40.4661], [-122.25878, 40.46717], [-122.25844, 40.46756], [-122.25829, 40.46797], [-122.25851, 40.46908], [-122.25823, 40.46964], [-122.25693, 40.46679], [-122.257, 40.46675], [-122.25734, 40.4669], [-122.25754, 40.46693], [-122.25755, 40.46692], [-122.25569, 40.46488], [-122.25569, 40.46461], [-122.25488, 40.464], [-122.25532, 40.46233], [-122.25635, 40.46254], [-122.25663, 40.46264], [-122.25701, 40.46333], [-122.25815, 40.46388], [-122.25913, 40.46406], [-122.25986, 40.46436], [-122.26021, 40.46499], [-122.26026, 40.46551]]]} Open Access 1 17642 Anderson Fishing Access 32022 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   Shasta 27 37.547 Anderson FA 0 State Recreation Area 39 4
2404 2404 2403 {"type": "Polygon", "coordinates": [[[-117.40831, 35.8391], [-117.39902, 35.8391], [-117.39889, 35.83547], [-117.38952, 35.83547], [-117.38912, 35.82822], [-117.38435, 35.82822], [-117.38411, 35.82459], [-117.37971, 35.82454], [-117.37972, 35.82089], [-117.38414, 35.82092], [-117.38891, 35.82093], [-117.38892, 35.82458], [-117.39372, 35.82458], [-117.39389, 35.82821], [-117.40341, 35.82821], [-117.4035, 35.83184], [-117.40815, 35.83184], [-117.40831, 35.8391]]]} Open Access 1 7378 Indian Joe Spring Ecological Reserve 32189 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/Indian-Joe-Springs-ER Inyo 43 550.369 Indian Joe Spring ER 0 State Conservation Area 8 2
2508 2508 2507 {"type": "Polygon", "coordinates": [[[-121.24804, 38.63376], [-121.24739, 38.63522], [-121.24697, 38.63508], [-121.24352, 38.63369], [-121.24282, 38.63347], [-121.242, 38.63327], [-121.24122, 38.63298], [-121.24087, 38.6328], [-121.24054, 38.63257], [-121.24015, 38.63234], [-121.23977, 38.63218], [-121.23316, 38.63264], [-121.23297, 38.63186], [-121.22925, 38.63193], [-121.22925, 38.63137], [-121.23982, 38.63078], [-121.24804, 38.63376]]]} Open Access 1 17562 American River Access 32019 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   Sacramento 41 59.692 American River Access 0 State Recreation Area 39 4
2573 2573 2572 {"type": "Polygon", "coordinates": [[[-122.22395, 40.26271], [-122.2237, 40.26323], [-122.22328, 40.26376], [-122.22186, 40.26304], [-122.22219, 40.26302], [-122.22269, 40.26218], [-122.22395, 40.26271]]]} Open Access 1 17891 Bend Bridge Public Access 32046 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   Tehama 18 3.867 Bend Bridge PA 0 State Recreation Area 39 4
2853 2853 2852 {"type": "Polygon", "coordinates": [[[-123.12633, 39.12775], [-123.12199, 39.12765], [-123.12186, 39.12406], [-123.12181, 39.12124], [-123.12251, 39.12168], [-123.12399, 39.12253], [-123.12435, 39.12276], [-123.1246, 39.12316], [-123.12473, 39.12355], [-123.12507, 39.12389], [-123.12597, 39.1242], [-123.12633, 39.12775]]]} Open Access 1 22154 Mill Creek 32219 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   Mendocino 24 49.861 Mill Creek 0 State Resource Management Area 55 3
3115 3115 3114 {"type": "Polygon", "coordinates": [[[-118.36149, 35.6525], [-118.36077, 35.67176], [-118.36099, 35.67202], [-118.36084, 35.67216], [-118.36083, 35.67225], [-118.36059, 35.67244], [-118.36048, 35.67244], [-118.36035, 35.67254], [-118.36025, 35.67254], [-118.36013, 35.67263], [-118.3599, 35.67264], [-118.35978, 35.67273], [-118.35943, 35.67273], [-118.35932, 35.67283], [-118.3592, 35.67283], [-118.35909, 35.67293], [-118.35897, 35.67293], [-118.35885, 35.67302], [-118.35862, 35.67302], [-118.3585, 35.67312], [-118.35838, 35.67312], [-118.35826, 35.67321], [-118.35814, 35.67321], [-118.35791, 35.67341], [-118.35779, 35.67341], [-118.35756, 35.6736], [-118.35744, 35.6736], [-118.35733, 35.67369], [-118.35698, 35.6737], [-118.35686, 35.67379], [-118.35651, 35.67379], [-118.35639, 35.6737], [-118.35616, 35.6737], [-118.35603, 35.6736], [-118.35581, 35.6736], [-118.35557, 35.67342], [-118.35545, 35.67342], [-118.35522, 35.67322], [-118.35511, 35.67322], [-118.35487, 35.67304], [-118.35475, 35.67304], [-118.35463, 35.67294], [-118.35441, 35.67294], [-118.35428, 35.67285], [-118.35394, 35.67285], [-118.35381, 35.67275], [-118.35359, 35.67275], [-118.35346, 35.67285], [-118.35264, 35.67285], [-118.35253, 35.67275], [-118.35147, 35.67276], [-118.35136, 35.67266], [-118.35101, 35.67267], [-118.35089, 35.67257], [-118.35031, 35.67257], [-118.35018, 35.67248], [-118.34856, 35.67248], [-118.34843, 35.67258], [-118.34762, 35.67258], [-118.34751, 35.67267], [-118.34703, 35.67267], [-118.34691, 35.67277], [-118.34668, 35.67277], [-118.34657, 35.67287], [-118.34621, 35.67287], [-118.3461, 35.67296], [-118.34564, 35.67297], [-118.34551, 35.67306], [-118.34516, 35.67307], [-118.34505, 35.67316], [-118.34494, 35.67316], [-118.34481, 35.67326], [-118.34399, 35.67326], [-118.34364, 35.67355], [-118.34352, 35.67354], [-118.34329, 35.67374], [-118.3426, 35.67374], [-118.34247, 35.67365], [-118.34224, 35.67365], [-118.34212, 35.67355], [-118.34201, 35.67355], [-118.34188, 35.67345], [-118.3413, 35.67346], [-118.34119, 35.67355], [-118.34048, 35.67356], [-118.34037, 35.67346], [-118.34014, 35.67346], [-118.3399, 35.67327], [-118.33966, 35.67327], [-118.33955, 35.67317], [-118.33932, 35.67317], [-118.33919, 35.67308], [-118.33874, 35.67308], [-118.33873, 35.67385], [-118.33861, 35.67394], [-118.33861, 35.6742], [-118.33451, 35.67409], [-118.33451, 35.67086], [-118.33432, 35.67112], [-118.33314, 35.67175], [-118.33047, 35.67254], [-118.32935, 35.67281], [-118.32925, 35.67273], [-118.32913, 35.67273], [-118.32879, 35.67245], [-118.32843, 35.67244], [-118.32838, 35.6724], [-118.33236, 35.67133], [-118.33412, 35.66986], [-118.33575, 35.66799], [-118.33753, 35.66683], [-118.33913, 35.6662], [-118.33909, 35.66591], [-118.33695, 35.66497], [-118.33666, 35.66368], [-118.33669, 35.66322], [-118.33589, 35.66322], [-118.33589, 35.66315], [-118.33635, 35.66277], [-118.33635, 35.66219], [-118.33624, 35.66209], [-118.33623, 35.6618], [-118.33635, 35.66171], [-118.33634, 35.66114], [-118.33623, 35.66105], [-118.33622, 35.66057], [-118.336, 35.66037], [-118.33471, 35.66038], [-118.33459, 35.66028], [-118.33482, 35.66008], [-118.33494, 35.66008], [-118.33506, 35.66], [-118.33517, 35.65999], [-118.33529, 35.6599], [-118.33553, 35.6599], [-118.33576, 35.65971], [-118.33588, 35.65971], [-118.33611, 35.65952], [-118.33623, 35.65951], [-118.3368, 35.65903], [-118.33716, 35.65903], [-118.33774, 35.65855], [-118.33786, 35.65855], [-118.3381, 35.65836], [-118.33821, 35.65836], [-118.33867, 35.65798], [-118.33879, 35.65798], [-118.33902, 35.65779], [-118.33903, 35.65663], [-118.33925, 35.65664], [-118.33949, 35.65645], [-118.33949, 35.65625], [-118.33936, 35.65616], [-118.33948, 35.65606], [-118.34276, 35.65605], [-118.34286, 35.65593], [-118.34288, 35.65558], [-118.34275, 35.65548], [-118.34276, 35.65491], [-118.34288, 35.65481], [-118.34333, 35.65481], [-118.34345, 35.65471], [-118.34345, 35.65433], [-118.34357, 35.65433], [-118.3436, 35.65579], [-118.34416, 35.65538], [-118.34622, 35.65508], [-118.34679, 35.65423], [-118.3472, 35.65436], [-118.34721, 35.65518], [-118.34731, 35.65527], [-118.34837, 35.65441], [-118.34883, 35.65441], [-118.34884, 35.6546], [-118.34907, 35.6546], [-118.34919, 35.6547], [-118.3493, 35.6547], [-118.34943, 35.65479], [-118.34966, 35.65479], [-118.34976, 35.65488], [-118.35012, 35.65489], [-118.35024, 35.65479], [-118.35048, 35.65478], [-118.35105, 35.65431], [-118.35117, 35.65431], [-118.35129, 35.65421], [-118.35141, 35.65421], [-118.35164, 35.65402], [-118.35164, 35.65382], [-118.35211, 35.65344], [-118.35222, 35.65344], [-118.35234, 35.65335], [-118.35234, 35.65268], [-118.35257, 35.65249], [-118.35315, 35.65248], [-118.35325, 35.65241], [-118.36149, 35.6525]], [[-118.33784, 35.66754], [-118.33642, 35.66856], [-118.33543, 35.66955], [-118.3349, 35.67031], [-118.33898, 35.67037], [-118.33903, 35.66701], [-118.33901, 35.66701], [-118.33784, 35.66754]]]} Open Access 1 25332 South Fork Wildlife Area 30532 100 United States Army Corps of Engineers 146 Federal 1 Federal Agency 1 http://www.usace.army.mil/ Other Federal 13 201 California Department of Fish and Wildlife 25 State 5 State Agency 5   Kern 36 1151.668 South Fork Wildlife Area 0 State Conservation Area 8 2
3142 3142 3141 {"type": "Polygon", "coordinates": [[[-124.10364, 40.82505], [-124.10204, 40.8308], [-124.10044, 40.83153], [-124.0966, 40.82984], [-124.08606, 40.82989], [-124.08663, 40.82862], [-124.08651, 40.82861], [-124.08712, 40.82752], [-124.08784, 40.82592], [-124.08642, 40.82542], [-124.08642, 40.82541], [-124.08628, 40.82535], [-124.08666, 40.82496], [-124.08699, 40.82469], [-124.08887, 40.82328], [-124.08903, 40.82319], [-124.08922, 40.82304], [-124.10364, 40.82505]], [[-124.08767, 40.82431], [-124.08749, 40.82436], [-124.08737, 40.8245], [-124.08721, 40.82478], [-124.08704, 40.82493], [-124.08715, 40.82496], [-124.08717, 40.82494], [-124.09118, 40.82586], [-124.0918, 40.8249], [-124.0918, 40.82489], [-124.08767, 40.82431]]]} Open Access 1 21590 Bracut Tidelands 32065 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   Humboldt 45 222.41 Bracut Tidelands 0 State Resource Management Area 55 3
3144 3144 3143 {"type": "Polygon", "coordinates": [[[-124.10173, 40.49177], [-124.09991, 40.49269], [-124.09979, 40.49248], [-124.1004, 40.49204], [-124.10081, 40.4918], [-124.1015, 40.49158], [-124.10173, 40.49177]]]} Open Access 1 21596 Eel River -- Rio Dell Fishing Access 32156 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   Humboldt 45 1.525 Eel River -- Rio Dell FA 0 State Recreation Area 39 4
3145 3145 3144 {"type": "MultiPolygon", "coordinates": [[[[-124.12175, 41.03989], [-124.12131, 41.03991], [-124.12121, 41.03987], [-124.12108, 41.03988], [-124.12093, 41.03992], [-124.12068, 41.04038], [-124.12061, 41.04044], [-124.12043, 41.04052], [-124.12027, 41.04068], [-124.12019, 41.04085], [-124.12012, 41.04095], [-124.12012, 41.04076], [-124.11999, 41.04031], [-124.11976, 41.04003], [-124.11934, 41.03975], [-124.11887, 41.03953], [-124.11879, 41.03945], [-124.11867, 41.03927], [-124.11859, 41.0391], [-124.11854, 41.03893], [-124.11849, 41.03884], [-124.11888, 41.03883], [-124.11962, 41.0388], [-124.12031, 41.03915], [-124.12093, 41.03936], [-124.1213, 41.03963], [-124.12175, 41.03989]]], [[[-124.12038, 41.04196], [-124.12008, 41.04195], [-124.1199, 41.04196], [-124.11979, 41.04199], [-124.11958, 41.04198], [-124.11972, 41.04168], [-124.11995, 41.04141], [-124.11995, 41.04147], [-124.12003, 41.04161], [-124.12008, 41.04164], [-124.12021, 41.04175], [-124.12038, 41.04196]]]]} Open Access 1 21601 Luffenholtz Creek Fishing Access 32210 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   Humboldt 45 6.71 Luffenholtz Creek FA 0 State Recreation Area 39 4
3284 3284 3283 {"type": "Polygon", "coordinates": [[[-114.722, 33.08954], [-114.70844, 33.08952], [-114.70802, 33.08874], [-114.70769, 33.08819], [-114.70696, 33.08728], [-114.70612, 33.08661], [-114.70461, 33.08633], [-114.7046, 33.08105], [-114.71315, 33.08099], [-114.71309, 33.075], [-114.72176, 33.07503], [-114.722, 33.08954]]]} Open Access 1 23367 Colorado River Access 32132 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   Imperial 20 488.822 Colorado River Access 0 State Recreation Area 39 4
3286 3286 3285 {"type": "Polygon", "coordinates": [[[-122.31276, 38.91619], [-122.30056, 38.91633], [-122.30018, 38.91044], [-122.30064, 38.91037], [-122.30093, 38.9103], [-122.30254, 38.90997], [-122.30296, 38.90992], [-122.30356, 38.90991], [-122.30391, 38.90996], [-122.30423, 38.91005], [-122.30598, 38.91071], [-122.30669, 38.91102], [-122.30716, 38.91107], [-122.30751, 38.91104], [-122.30761, 38.91103], [-122.30833, 38.91081], [-122.30868, 38.91064], [-122.30877, 38.91057], [-122.3089, 38.91042], [-122.30904, 38.9103], [-122.30907, 38.91024], [-122.30929, 38.90996], [-122.30929, 38.90988], [-122.3096, 38.90939], [-122.30981, 38.9092], [-122.31013, 38.90898], [-122.31036, 38.90884], [-122.31044, 38.90882], [-122.31061, 38.90873], [-122.31088, 38.90866], [-122.31144, 38.9086], [-122.312, 38.90866], [-122.31239, 38.90877], [-122.31264, 38.90888], [-122.31273, 38.90893], [-122.31276, 38.91619]]]} Open Access 1 23563 Cache Creek Public Access 32077 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   Yolo 33 184.731 Cache Creek PA 0 State Recreation Area 39 4
3437 3437 3436 {"type": "Polygon", "coordinates": [[[-122.4138, 38.46446], [-122.41344, 38.465], [-122.41272, 38.46514], [-122.41239, 38.46481], [-122.41285, 38.46468], [-122.41297, 38.46463], [-122.41332, 38.46455], [-122.41347, 38.4645], [-122.41361, 38.46442], [-122.41379, 38.46439], [-122.4138, 38.46446]]]} Open Access 1 25245 Rutherford Crossroad 32278 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   Napa 11 1.213 Rutherford Crossroad 0 State Resource Management Area 55 3
3443 3443 3442 {"type": "Polygon", "coordinates": [[[-122.27607, 38.12156], [-122.27576, 38.12178], [-122.2757, 38.12104], [-122.27592, 38.12097], [-122.27607, 38.12156]]]} Open Access 1 25259 Vallejo Fishing Pier 32344 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   Solano 26 0.461 Vallejo Fishing Pier 0 State Recreation Area 39 4
3597 3597 3596 {"type": "Polygon", "coordinates": [[[-120.42453, 41.423], [-120.42447, 41.42337], [-120.42407, 41.42367], [-120.42401, 41.42387], [-120.42359, 41.42413], [-120.42319, 41.42405], [-120.42179, 41.4233], [-120.42091, 41.423], [-120.42064, 41.42284], [-120.42067, 41.42262], [-120.42116, 41.42223], [-120.42189, 41.42202], [-120.42261, 41.422], [-120.4235, 41.42232], [-120.42413, 41.42232], [-120.42432, 41.42243], [-120.42453, 41.423]]]} Open Access 1 29187 Pine Creek Reservoir Public Access 32264 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   Modoc 56 11.894 Pine Creek Reservoir PA 0 State Recreation Area 39 4
3676 3676 3675 {"type": "Polygon", "coordinates": [[[-123.9944, 40.85728], [-123.98793, 40.85729], [-123.98823, 40.85355], [-123.99083, 40.85359], [-123.991, 40.85206], [-123.99205, 40.85205], [-123.99208, 40.8536], [-123.99105, 40.85359], [-123.99104, 40.8536], [-123.99158, 40.85448], [-123.99209, 40.85481], [-123.99433, 40.85721], [-123.9944, 40.85728]]]} Open Access 1 44354 Mad River Fish Hatchery 32212 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   Humboldt 45 43.3 Mad River Fish Hatchery 0 State Other or Unknown 104 4

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);