units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
44 rows where COUNTY = 48 sorted by PARK_URL
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, MNG_AG_ID, MNG_AG_LEV, PARK_URL, YR_EST, GAP_STS
DES_TP 20
- Local Park 14
- Private Conservation 5
- Recreation Management Area 4
- National Public Lands 2
- Local Recreation Area 2
- National Forest 2
- State Resource Management Area 2
- State Conservation Area 1
- National Park 1
- State Recreation Area 1
- Private Recreation or Education 1
- National Monument or Landmark 1
- Resource Management Area 1
- State Historic or Cultural Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
MNG_AGENCY 16
- Madera, City of 12
- San Joaquin River Parkway and Conservation Trust 7
- United States Army Corps of Engineers 4
- Chowchilla, City of 3
- United States Bureau of Land Management 2
- United States Forest Service 2
- California Department of Parks and Recreation 2
- United States National Park Service 2
- California State Lands Commission 2
- United States Bureau of Reclamation 2
- California Department of Fish and Wildlife 1
- Other State 1
- Sierra Foothill Conservancy 1
- Sierra Historic Sites Association 1
- Madera, County of 1
- Madera Irrigation District 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1961 | 1961 | 1960 | {"type": "Polygon", "coordinates": [[[-119.64038, 37.32984], [-119.64037, 37.33056], [-119.6394, 37.33019], [-119.63911, 37.33026], [-119.63852, 37.33009], [-119.63833, 37.32985], [-119.63942, 37.32983], [-119.64038, 37.32984]]]} | Open Access 1 | 16718 | Fresno Flats Historic Park | 19111 | 3078 | Sierra Historic Sites Association 462 | Non Profit 6 | Non Profit - Other 22 | http://www.fresnoflatsmuseum.org/ | Non Governmental Organization 10 | 3078 | Sierra Historic Sites Association 455 | Non Profit 6 | Non Profit - Other 20 | Madera 48 | 2.12 | Fresno Flats Historic Park | 0 | Private Recreation or Education 65 | 4 | |
1967 | 1967 | 1966 | {"type": "Polygon", "coordinates": [[[-120.06135, 36.96054], [-120.06054, 36.9611], [-120.0597, 36.96026], [-120.06051, 36.95971], [-120.06135, 36.96054]]]} | Open Access 1 | 16733 | Courthouse Park | 17718 | 1192 | Madera, City of 463 | City 2 | City Agency 2 | http://www.cityofmadera.org/ | City 2 | 1192 | Madera, City of 456 | City 2 | City Agency 2 | Madera 48 | 2.782 | Courthouse Park | 0 | Local Park 2 | 4 | |
2239 | 2239 | 2238 | {"type": "Polygon", "coordinates": [[[-119.81102, 36.87326], [-119.80959, 36.87329], [-119.8096, 36.87351], [-119.81007, 36.87379], [-119.81022, 36.87384], [-119.81101, 36.87381], [-119.81092, 36.88017], [-119.80915, 36.88029], [-119.80178, 36.8809], [-119.79911, 36.88089], [-119.80337, 36.87899], [-119.80477, 36.87934], [-119.80542, 36.8792], [-119.8063, 36.87931], [-119.8063, 36.8783], [-119.80622, 36.87802], [-119.80565, 36.87825], [-119.80549, 36.8785], [-119.80516, 36.87785], [-119.79392, 36.8778], [-119.79337, 36.87782], [-119.79334, 36.87681], [-119.79332, 36.8768], [-119.7933, 36.87682], [-119.79325, 36.87549], [-119.79577, 36.8744], [-119.80082, 36.87025], [-119.80215, 36.86845], [-119.80261, 36.86797], [-119.80445, 36.86616], [-119.80599, 36.86497], [-119.80929, 36.86355], [-119.80935, 36.86353], [-119.81041, 36.86422], [-119.81111, 36.86607], [-119.81102, 36.87326]]]} | Unknown Access 4 | 16693 | Van Buren Unit | 26820 | 2345 | Tehachapi-Cummings County Water District 499 | Special District 4 | Water District 13 | http://tccwd.com/ | Special District 4 | 3069 | San Joaquin River Parkway and Conservation Trust 491 | Non Profit 6 | Non Profit - Land Trust 10 | Madera 48 | 433.198 | Van Buren Unit | None 186 | |||
2255 | 2255 | 2254 | {"type": "Polygon", "coordinates": [[[-120.07438, 36.9734], [-120.07385, 36.97387], [-120.07132, 36.97176], [-120.07077, 36.97126], [-120.07196, 36.97043], [-120.07235, 36.97104], [-120.07275, 36.97158], [-120.07411, 36.97315], [-120.07438, 36.9734]]]} | Open Access 1 | 16807 | Rotary Park | 24690 | 1192 | Madera, City of 463 | City 2 | City Agency 2 | http://www.cityofmadera.org/ | City 2 | 1192 | Madera, City of 456 | City 2 | City Agency 2 | Madera 48 | 9.679 | Rotary Park | 0 | Local Park 2 | 4 | |
2258 | 2258 | 2257 | {"type": "MultiPolygon", "coordinates": [[[[-120.03757, 36.97222], [-120.03747, 36.97228], [-120.03752, 36.97427], [-120.03278, 36.97428], [-120.03277, 36.9707], [-120.03753, 36.9707], [-120.03757, 36.97222]]], [[[-120.03977, 36.97349], [-120.03845, 36.97429], [-120.03773, 36.97429], [-120.03768, 36.97236], [-120.03835, 36.97198], [-120.03977, 36.97349]]]]} | Open Access 1 | 16743 | Madera Sunrise Rotary Sports Complex | 21655 | 1192 | Madera, City of 463 | City 2 | City Agency 2 | http://www.cityofmadera.org/ | City 2 | 1192 | Madera, City of 456 | City 2 | City Agency 2 | Madera 48 | 48.947 | Madera Sunrise Rotary Sports Complex | 0 | Local Recreation Area 3 | 4 | |
3129 | 3129 | 3128 | {"type": "MultiPolygon", "coordinates": [[[[-120.20207, 37.13415], [-120.20207, 37.13449], [-120.20152, 37.13451], [-120.20131, 37.13451], [-120.20105, 37.13446], [-120.20079, 37.13437], [-120.19586, 37.13211], [-120.19264, 37.1301], [-120.19236, 37.12991], [-120.19219, 37.12982], [-120.19198, 37.12974], [-120.1916, 37.12964], [-120.19133, 37.12962], [-120.19109, 37.12962], [-120.18887, 37.12995], [-120.18886, 37.12996], [-120.18902, 37.13022], [-120.18406, 37.13106], [-120.18407, 37.12916], [-120.18436, 37.12914], [-120.18504, 37.12897], [-120.18623, 37.12879], [-120.18751, 37.12855], [-120.18812, 37.1284], [-120.1887, 37.12966], [-120.19099, 37.12929], [-120.19127, 37.12928], [-120.19151, 37.1293], [-120.19175, 37.12933], [-120.19202, 37.12939], [-120.19235, 37.12951], [-120.19259, 37.12963], [-120.19617, 37.13183], [-120.201, 37.13407], [-120.20111, 37.13414], [-120.20121, 37.13417], [-120.20134, 37.13418], [-120.20207, 37.13415]]], [[[-120.18786, 37.12782], [-120.18688, 37.1281], [-120.18514, 37.12848], [-120.18407, 37.12864], [-120.18407, 37.12724], [-120.18761, 37.12726], [-120.18786, 37.12782]]], [[[-120.19316, 37.12631], [-120.19316, 37.12665], [-120.1915, 37.12715], [-120.18701, 37.12712], [-120.18727, 37.12685], [-120.191, 37.1269], [-120.19192, 37.12674], [-120.19316, 37.12631]]]]} | Open Access 1 | 25780 | Berenda Reservoir | 16018 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | Madera 48 | 47.282 | Berenda Reservoir | 0 | Resource Management Area 82 | 3 | |
3130 | 3130 | 3129 | {"type": "MultiPolygon", "coordinates": [[[[-120.12091, 37.14841], [-120.1202, 37.1484], [-120.12022, 37.14807], [-120.11991, 37.14744], [-120.11891, 37.14665], [-120.11848, 37.14651], [-120.11311, 37.14264], [-120.11265, 37.14235], [-120.11132, 37.14138], [-120.11132, 37.14127], [-120.11243, 37.14128], [-120.11915, 37.14615], [-120.11933, 37.14643], [-120.12079, 37.1475], [-120.12091, 37.14841]]], [[[-120.12237, 37.15854], [-120.12117, 37.15884], [-120.12026, 37.15686], [-120.12025, 37.15548], [-120.11762, 37.15546], [-120.11901, 37.15433], [-120.12017, 37.1543], [-120.12019, 37.14857], [-120.12097, 37.14857], [-120.12092, 37.15196], [-120.12093, 37.15573], [-120.12146, 37.15765], [-120.12237, 37.15854]]]]} | Open Access 1 | 25781 | Madera Canal | 21650 | 103 | United States Bureau of Reclamation 369 | Federal 1 | Federal Agency 1 | http://www.usbr.gov/ | Other Federal 13 | 103 | United States Bureau of Reclamation 364 | Federal 1 | Federal Agency 1 | Madera 48 | 43.907 | Madera Canal | None 256 | |||
3494 | 3494 | 3493 | {"type": "Polygon", "coordinates": [[[-119.92013, 36.84814], [-119.9201, 36.84889], [-119.91933, 36.84892], [-119.91621, 36.84954], [-119.91557, 36.84957], [-119.91467, 36.84879], [-119.91115, 36.8488], [-119.91115, 36.85122], [-119.91068, 36.85129], [-119.91054, 36.85133], [-119.90847, 36.8513], [-119.90649, 36.85002], [-119.90733, 36.84921], [-119.90775, 36.84888], [-119.90795, 36.84855], [-119.90816, 36.84837], [-119.90879, 36.848], [-119.90911, 36.84784], [-119.90954, 36.8475], [-119.90997, 36.84724], [-119.91042, 36.84702], [-119.91072, 36.84679], [-119.91172, 36.8464], [-119.91209, 36.84619], [-119.91244, 36.84606], [-119.91285, 36.84585], [-119.91314, 36.84576], [-119.91372, 36.84572], [-119.91435, 36.84574], [-119.91473, 36.84573], [-119.91559, 36.84561], [-119.91563, 36.84814], [-119.92013, 36.84814]]]} | Unknown Access 4 | 25925 | Schneider Property | 25187 | 3069 | San Joaquin River Parkway and Conservation Trust 649 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.riverparkway.org | Non Governmental Organization 10 | 3069 | San Joaquin River Parkway and Conservation Trust 491 | Non Profit 6 | Non Profit - Land Trust 10 | Madera 48 | 77.528 | Schneider Property | 0 | Private Conservation 16 | 2 | |
5262 | 5262 | 5261 | {"type": "MultiPolygon", "coordinates": [[[[-120.25895, 37.12208], [-120.25822, 37.12265], [-120.2575, 37.12206], [-120.25823, 37.12148], [-120.25895, 37.12208]]], [[[-120.25983, 37.12138], [-120.25909, 37.12196], [-120.25838, 37.12137], [-120.25911, 37.12079], [-120.25983, 37.12138]]]]} | Open Access 1 | 24539 | RC Wisener | 24209 | 1055 | Chowchilla, City of 801 | City 2 | City Agency 2 | http://www.ci.chowchilla.ca.us/ | City 2 | 1055 | Chowchilla, City of 781 | City 2 | City Agency 2 | Madera 48 | 4.14 | RC Wisener | None 424 | |||
5263 | 5263 | 5262 | {"type": "Polygon", "coordinates": [[[-120.05541, 36.9684], [-120.05477, 36.96843], [-120.05413, 36.96854], [-120.05328, 36.96772], [-120.05413, 36.96716], [-120.05541, 36.9684]]]} | Open Access 1 | 24540 | Centennial Park | 17024 | 1192 | Madera, City of 463 | City 2 | City Agency 2 | http://www.cityofmadera.org/ | City 2 | 1192 | Madera, City of 456 | City 2 | City Agency 2 | Madera 48 | 3.541 | Centennial Park | 0 | Local Park 2 | 4 | |
9818 | 9818 | 9817 | {"type": "MultiPolygon", "coordinates": [[[[-119.67173, 37.03046], [-119.67173, 37.043], [-119.65891, 37.04324], [-119.65829, 37.04351], [-119.65813, 37.04336], [-119.65793, 37.04313], [-119.65825, 37.04299], [-119.65856, 37.04298], [-119.65876, 37.04266], [-119.65914, 37.04249], [-119.65969, 37.04226], [-119.66001, 37.0421], [-119.6604, 37.04206], [-119.66063, 37.04211], [-119.66095, 37.04197], [-119.66144, 37.04168], [-119.66156, 37.04143], [-119.66131, 37.04131], [-119.66182, 37.04102], [-119.66201, 37.04083], [-119.66225, 37.04054], [-119.66278, 37.04037], [-119.66268, 37.04011], [-119.66268, 37.03977], [-119.6625, 37.03905], [-119.66259, 37.03877], [-119.66257, 37.03823], [-119.66238, 37.03776], [-119.66259, 37.03758], [-119.66261, 37.03713], [-119.66226, 37.03705], [-119.66206, 37.03679], [-119.66177, 37.03637], [-119.66176, 37.03587], [-119.66208, 37.03571], [-119.66237, 37.03538], [-119.66237, 37.03512], [-119.66211, 37.03502], [-119.66181, 37.03461], [-119.66167, 37.03404], [-119.66165, 37.03346], [-119.66176, 37.03277], [-119.66182, 37.03227], [-119.66171, 37.03205], [-119.66178, 37.03204], [-119.66219, 37.03164], [-119.66239, 37.03184], [-119.66269, 37.03224], [-119.66292, 37.03228], [-119.66294, 37.03164], [-119.66301, 37.03111], [-119.66288, 37.03067], [-119.66281, 37.03056], [-119.66284, 37.03038], [-119.67173, 37.03046]]], [[[-119.70792, 37.01064], [-119.70493, 37.01065], [-119.70481, 37.01054], [-119.70439, 37.00982], [-119.70437, 37.00959], [-119.70468, 37.00947], [-119.70476, 37.00933], [-119.70483, 37.00926], [-119.70474, 37.00916], [-119.70472, 37.00866], [-119.70463, 37.0083], [-119.70464, 37.00816], [-119.7047, 37.00807], [-119.70468, 37.00765], [-119.70472, 37.00748], [-119.70473, 37.00756], [-119.70474, 37.00757], [-119.70505, 37.00706], [-119.70635, 37.00643], [-119.70715, 37.00587], [-119.70758, 37.00492], [-119.70762, 37.00437], [-119.70748, 37.00415], [-119.70761, 37.00403], [-119.70781, 37.00394], [-119.70563, 37.00164], [-119.70603, 37.00085], [-119.70613, 37.00078], [-119.70755, 37.00119], [-119.7083, 37.00226], [-119.70855, 37.00343], [-119.70816, 37.00498], [-119.70777, 37.00603], [-119.70795, 37.00654], [-119.70792, 37.01064]]]]} | Open Access 1 | 16758 | Millerton Lake State Recreation Area | 22249 | 103 | United States Bureau of Reclamation 369 | Federal 1 | Federal Agency 1 | http://www.usbr.gov/ | Other Federal 13 | 103 | United States Bureau of Reclamation 364 | Federal 1 | Federal Agency 1 | Madera 48 | 353.212 | Millerton Lake SRA | 1957 | Recreation Management Area 49 | 4 | |
9823 | 9823 | 9822 | {"type": "Polygon", "coordinates": [[[-120.27786, 37.11495], [-120.27785, 37.11845], [-120.2765, 37.11832], [-120.27455, 37.11672], [-120.2748, 37.115], [-120.27786, 37.11495]]]} | Open Access 1 | 16782 | Sports Leisure Park | 25730 | 1055 | Chowchilla, City of 801 | City 2 | City Agency 2 | http://www.ci.chowchilla.ca.us/ | City 2 | 1055 | Chowchilla, City of 781 | City 2 | City Agency 2 | Madera 48 | 22.831 | Sports Leisure Park | 0 | Local Park 2 | 4 | |
9827 | 9827 | 9826 | {"type": "Polygon", "coordinates": [[[-120.09205, 36.95148], [-120.09057, 36.9515], [-120.09058, 36.95264], [-120.08485, 36.95272], [-120.08359, 36.95266], [-120.08358, 36.95143], [-120.08346, 36.95079], [-120.08345, 36.95009], [-120.09205, 36.95002], [-120.09205, 36.95148]]]} | Open Access 1 | 16788 | Lions Town and Country Regional Park | 21327 | 1192 | Madera, City of 463 | City 2 | City Agency 2 | http://www.cityofmadera.org/ | City 2 | 1192 | Madera, City of 456 | City 2 | City Agency 2 | Madera 48 | 50.314 | Lions Town and Country RP | 0 | Local Park 2 | 4 | |
9828 | 9828 | 9827 | {"type": "Polygon", "coordinates": [[[-120.04779, 36.95758], [-120.04695, 36.95815], [-120.04679, 36.95799], [-120.04678, 36.95683], [-120.04692, 36.95674], [-120.04779, 36.95758]]]} | Open Access 1 | 16791 | McNally Memorial Park | 22058 | 1192 | Madera, City of 463 | City 2 | City Agency 2 | http://www.cityofmadera.org/ | City 2 | 1192 | Madera, City of 456 | City 2 | City Agency 2 | Madera 48 | 1.931 | McNally Memorial Park | 0 | Local Park 2 | 4 | |
9832 | 9832 | 9831 | {"type": "Polygon", "coordinates": [[[-120.05954, 36.97731], [-120.05954, 36.97786], [-120.05631, 36.97786], [-120.05631, 36.97731], [-120.05632, 36.97728], [-120.05636, 36.97726], [-120.05948, 36.97727], [-120.05951, 36.97728], [-120.05954, 36.97731]]]} | Open Access 1 | 16794 | Pan-Am Park | 23382 | 1192 | Madera, City of 463 | City 2 | City Agency 2 | http://www.cityofmadera.org/ | City 2 | 1192 | Madera, City of 456 | City 2 | City Agency 2 | Madera 48 | 4.706 | Pan-Am Park | 0 | Local Park 2 | 4 | |
10504 | 10504 | 10503 | {"type": "Polygon", "coordinates": [[[-120.04201, 36.95708], [-120.041, 36.95707], [-120.041, 36.95622], [-120.04201, 36.95625], [-120.04201, 36.95708]]]} | Open Access 1 | 24871 | Knox Park | 20708 | 1192 | Madera, City of 463 | City 2 | City Agency 2 | http://www.cityofmadera.org/ | City 2 | 1192 | Madera, City of 456 | City 2 | City Agency 2 | Madera 48 | 2.093 | Knox Park | 0 | Local Park 2 | 4 | |
11249 | 11249 | 11248 | {"type": "MultiPolygon", "coordinates": [[[[-119.52826, 37.16345], [-119.52821, 37.16701], [-119.52375, 37.16695], [-119.52377, 37.16344], [-119.52826, 37.16345]]], [[[-119.53282, 37.13508], [-119.53274, 37.14124], [-119.52837, 37.14127], [-119.52834, 37.14819], [-119.52384, 37.14811], [-119.52392, 37.13028], [-119.52388, 37.12887], [-119.52387, 37.12886], [-119.52386, 37.12887], [-119.52388, 37.12798], [-119.52432, 37.12785], [-119.52486, 37.12758], [-119.52512, 37.12758], [-119.52575, 37.12788], [-119.52755, 37.12886], [-119.52757, 37.12897], [-119.52794, 37.12926], [-119.52822, 37.1295], [-119.52874, 37.12968], [-119.52894, 37.1298], [-119.5289, 37.13507], [-119.53282, 37.13508]]], [[[-119.53723, 37.1442], [-119.5372, 37.14808], [-119.53273, 37.1481], [-119.53274, 37.14423], [-119.53723, 37.1442]]], [[[-119.61692, 37.30088], [-119.61691, 37.30384], [-119.61553, 37.30385], [-119.61553, 37.30089], [-119.61692, 37.30088]]], [[[-119.62369, 37.17656], [-119.62196, 37.18051], [-119.62002, 37.18013], [-119.62165, 37.17615], [-119.62369, 37.17656]]], [[[-119.65408, 37.23158], [-119.65265, 37.23286], [-119.64805, 37.23058], [-119.64409, 37.22798], [-119.64094, 37.22618], [-119.64094, 37.22419], [-119.64403, 37.22585], [-119.6455, 37.22679], [-119.64741, 37.22813], [-119.64764, 37.22814], [-119.64925, 37.22923], [-119.65408, 37.23158]]], [[[-119.65213, 37.38486], [-119.65203, 37.38827], [-119.65007, 37.3883], [-119.65006, 37.38665], [-119.64777, 37.38665], [-119.64779, 37.38485], [-119.65213, 37.38486]]], [[[-119.66698, 37.23784], [-119.66552, 37.23913], [-119.66411, 37.23866], [-119.66077, 37.23777], [-119.66205, 37.23659], [-119.6641, 37.23708], [-119.66698, 37.23784]]], [[[-119.67289, 37.12264], [-119.6728, 37.1261], [-119.6636, 37.12641], [-119.66359, 37.12292], [-119.67289, 37.12264]]], [[[-119.68136, 37.32282], [-119.67235, 37.32283], [-119.67228, 37.31894], [-119.68134, 37.31893], [-119.68136, 37.32282]]], [[[-119.69249, 37.19337], [-119.68877, 37.19651], [-119.68553, 37.19383], [-119.6841, 37.19418], [-119.68249, 37.19032], [-119.68434, 37.18983], [-119.68595, 37.19348], [-119.68957, 37.19077], [-119.69249, 37.19337]]], [[[-119.69606, 37.28801], [-119.69556, 37.28959], [-119.69345, 37.28787], [-119.69295, 37.28901], [-119.68909, 37.28714], [-119.68965, 37.28598], [-119.69078, 37.28598], [-119.69079, 37.28597], [-119.68799, 37.28416], [-119.68554, 37.2816], [-119.68677, 37.28036], [-119.68938, 37.28261], [-119.68938, 37.28283], [-119.69274, 37.2852], [-119.69606, 37.28801]]], [[[-119.70237, 37.40995], [-119.68838, 37.4102], [-119.68852, 37.40277], [-119.70223, 37.40276], [-119.70237, 37.40995]]], [[[-119.69837, 37.3739], [-119.69797, 37.38477], [-119.69338, 37.38475], [-119.6937, 37.37392], [-119.69837, 37.3739]]], [[[-119.7123, 37.27216], [-119.71149, 37.27492], [-119.71083, 37.276], [-119.71093, 37.27216], [-119.7123, 37.27216]]], [[[-119.71769, 37.28894], [-119.7176, 37.29195], [-119.71651, 37.29032], [-119.71467, 37.29146], [-119.71177, 37.28873], [-119.71372, 37.28757], [-119.71317, 37.28691], [-119.71323, 37.2838], [-119.71476, 37.28578], [-119.7175, 37.28862], [-119.71769, 37.28894]]], [[[-119.71451, 37.26594], [-119.71473, 37.26741], [-119.71385, 37.27063], [-119.71331, 37.27086], [-119.71333, 37.26734], [-119.71451, 37.26594]]], [[[-119.73125, 37.30848], [-119.73124, 37.31027], [-119.72669, 37.31027], [-119.72669, 37.30847], [-119.73125, 37.30848]]], [[[-119.7528, 37.3485], [-119.75249, 37.34857], [-119.7516, 37.34894], [-119.75098, 37.34907], [-119.74989, 37.3492], [-119.7497, 37.34926], [-119.74891, 37.34965], [-119.74863, 37.34975], [-119.74855, 37.34977], [-119.74765, 37.34973], [-119.74726, 37.3498], [-119.74687, 37.34992], [-119.74583, 37.3505], [-119.74514, 37.35077], [-119.74508, 37.3508], [-119.745, 37.35082], [-119.74381, 37.35122], [-119.74384, 37.34446], [-119.75274, 37.34476], [-119.7528, 37.3485]]], [[[-119.75281, 37.35211], [-119.74382, 37.35194], [-119.74381, 37.35139], [-119.74506, 37.35097], [-119.74517, 37.35096], [-119.74525, 37.35091], [-119.74594, 37.35065], [-119.74696, 37.35007], [-119.74732, 37.34996], [-119.74767, 37.3499], [-119.74857, 37.34993], [-119.74869, 37.3499], [-119.74884, 37.34987], [-119.74901, 37.3498], [-119.74979, 37.34941], [-119.74994, 37.34936], [-119.75102, 37.34923], [-119.75168, 37.3491], [-119.75256, 37.34872], [-119.7528, 37.34867], [-119.75281, 37.35211]]], [[[-119.7723, 37.12716], [-119.7684, 37.12984], [-119.76618, 37.13076], [-119.76363, 37.13403], [-119.763, 37.1357], [-119.76311, 37.13715], [-119.76253, 37.13715], [-119.7623, 37.13738], [-119.76153, 37.13655], [-119.76265, 37.13346], [-119.76552, 37.13006], [-119.7661, 37.12979], [-119.76763, 37.12976], [-119.76764, 37.12905], [-119.77139, 37.12643], [-119.7723, 37.12716]]], [[[-119.77507, 37.37408], [-119.77495, 37.3812], [-119.77063, 37.38122], [-119.77069, 37.37407], [-119.77507, 37.37408]], [[-119.7735, 37.37495], [-119.77157, 37.37494], [-119.77174, 37.37884], [-119.77365, 37.37886], [-119.7735, 37.37495]]], [[[-119.92056, 37.14103], [-119.91579, 37.14105], [-119.91589, 37.14031], [-119.91608, 37.13996], [-119.91642, 37.13958], [-119.91662, 37.1389], [-119.91702, 37.13777], [-119.91716, 37.13727], [-119.92054, 37.13728], [-119.92056, 37.14103]]], [[[-119.91689, 37.13727], [-119.91676, 37.13771], [-119.91636, 37.13885], [-119.91614, 37.13957], [-119.91615, 37.13724], [-119.91689, 37.13727]]], [[[-119.99311, 37.1845], [-119.99304, 37.18767], [-119.99145, 37.18527], [-119.99002, 37.18599], [-119.99125, 37.18798], [-119.98868, 37.18798], [-119.98869, 37.18448], [-119.99311, 37.1845]]]]} | Open Access 1 | 21630 | BLM | 16162 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | Madera 48 | 1586.685 | BLM | 1899 | National Public Lands 1 | 3 | |
11509 | 11509 | 11508 | {"type": "Polygon", "coordinates": [[[-120.26521, 37.12013], [-120.26448, 37.12071], [-120.26376, 37.12012], [-120.26449, 37.11955], [-120.26521, 37.12013]]]} | Open Access 1 | 24538 | Veterans Memorial Park | 27025 | 1055 | Chowchilla, City of 801 | City 2 | City Agency 2 | http://www.ci.chowchilla.ca.us/ | City 2 | 1055 | Chowchilla, City of 781 | City 2 | City Agency 2 | Madera 48 | 2.068 | Veterans Memorial Park | 0 | Local Park 2 | 4 | |
11735 | 11735 | 11734 | {"type": "Polygon", "coordinates": [[[-120.05325, 36.93233], [-120.05133, 36.93232], [-120.05132, 36.93211], [-120.05142, 36.9321], [-120.05141, 36.93204], [-120.05132, 36.93204], [-120.05131, 36.93136], [-120.05323, 36.93136], [-120.05325, 36.93233]]]} | Open Access 1 | 24541 | Parkwood Park | 23464 | 346 | Madera, County of 989 | County 3 | County Agency 3 | http://www.madera-county.com | County 3 | 346 | Madera, County of 953 | County 3 | County Agency 3 | Madera 48 | 4.523 | Parkwood Park | 0 | Local Park 2 | 4 | |
12279 | 12279 | 12278 | {"type": "Polygon", "coordinates": [[[-119.74413, 36.95238], [-119.73643, 36.95242], [-119.73532, 36.95037], [-119.73417, 36.94855], [-119.73385, 36.94778], [-119.73382, 36.94705], [-119.73448, 36.94596], [-119.73557, 36.94502], [-119.73691, 36.94458], [-119.738, 36.94429], [-119.73914, 36.94436], [-119.7401, 36.94453], [-119.74133, 36.94424], [-119.74239, 36.94352], [-119.7435, 36.94216], [-119.74386, 36.94241], [-119.74413, 36.95238]]]} | Unknown Access 4 | 25928 | Ledger Island | 21130 | 2345 | Tehachapi-Cummings County Water District 499 | Special District 4 | Water District 13 | http://tccwd.com/ | Special District 4 | 3069 | San Joaquin River Parkway and Conservation Trust 491 | Non Profit 6 | Non Profit - Land Trust 10 | Madera 48 | 184.827 | Ledger Island | None 1072 |
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]);