units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
44 rows where COUNTY = 48 sorted by LAYER
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
13010 | 13010 | 13009 | {"type": "MultiPolygon", "coordinates": [[[[-119.57776, 37.08324], [-119.57335, 37.08293], [-119.57341, 37.09006], [-119.56427, 37.08996], [-119.56419, 37.09714], [-119.5693, 37.09728], [-119.57331, 37.09731], [-119.5733, 37.1009], [-119.56937, 37.10089], [-119.56935, 37.10261], [-119.56943, 37.11188], [-119.55581, 37.11186], [-119.55575, 37.11541], [-119.55576, 37.11542], [-119.56478, 37.11541], [-119.56478, 37.1157], [-119.56399, 37.11562], [-119.5632, 37.11559], [-119.56255, 37.11563], [-119.56109, 37.11566], [-119.56028, 37.11575], [-119.55989, 37.11574], [-119.5586, 37.11557], [-119.55677, 37.1155], [-119.55635, 37.1155], [-119.55536, 37.11557], [-119.55483, 37.11568], [-119.55385, 37.11593], [-119.55345, 37.1161], [-119.55303, 37.1163], [-119.55264, 37.11659], [-119.55231, 37.11679], [-119.55196, 37.11695], [-119.55162, 37.11707], [-119.5513, 37.11714], [-119.55097, 37.1172], [-119.55049, 37.11718], [-119.54985, 37.11708], [-119.54927, 37.11696], [-119.54868, 37.11682], [-119.5482, 37.11665], [-119.54724, 37.11608], [-119.54673, 37.11567], [-119.54635, 37.1153], [-119.5456, 37.11445], [-119.54524, 37.11409], [-119.54491, 37.11365], [-119.54437, 37.11266], [-119.54375, 37.11185], [-119.54345, 37.1116], [-119.54304, 37.11121], [-119.54226, 37.11074], [-119.54226, 37.10789], [-119.538, 37.10783], [-119.53793, 37.10385], [-119.53868, 37.10183], [-119.53887, 37.10142], [-119.53897, 37.101], [-119.53902, 37.10075], [-119.53948, 37.09929], [-119.54106, 37.09641], [-119.54269, 37.09534], [-119.54609, 37.09512], [-119.54727, 37.09488], [-119.5482, 37.09452], [-119.54868, 37.09438], [-119.54962, 37.09404], [-119.54991, 37.09394], [-119.55182, 37.09316], [-119.55301, 37.09265], [-119.55452, 37.0919], [-119.5557, 37.09082], [-119.55776, 37.08927], [-119.55894, 37.08817], [-119.5595, 37.08662], [-119.55976, 37.08463], [-119.55981, 37.08323], [-119.56055, 37.08156], [-119.56118, 37.07955], [-119.56182, 37.07765], [-119.5627, 37.07654], [-119.56334, 37.07505], [-119.56334, 37.07405], [-119.5628, 37.07323], [-119.56124, 37.07194], [-119.56133, 37.07164], [-119.56119, 37.07128], [-119.56096, 37.07107], [-119.56099, 37.07034], [-119.56201, 37.06942], [-119.56236, 37.06896], [-119.56241, 37.0686], [-119.56216, 37.06684], [-119.5619, 37.06617], [-119.56182, 37.06572], [-119.56193, 37.06544], [-119.5623, 37.06503], [-119.56404, 37.06452], [-119.56887, 37.06425], [-119.57075, 37.06448], [-119.5709, 37.06436], [-119.57135, 37.06437], [-119.57375, 37.06514], [-119.57546, 37.06537], [-119.57581, 37.06569], [-119.57774, 37.07953], [-119.57776, 37.08324]], [[-119.55108, 37.11543], [-119.55109, 37.11542], [-119.55092, 37.11185], [-119.54678, 37.11184], [-119.54674, 37.11538], [-119.55108, 37.11543]]], [[[-119.60095, 37.08506], [-119.59645, 37.08506], [-119.59645, 37.08329], [-119.60094, 37.08328], [-119.60095, 37.08506]]], [[[-119.60835, 37.07603], [-119.60546, 37.07857], [-119.60401, 37.0777], [-119.60599, 37.07603], [-119.60835, 37.07603]]]]} | Open Access 1 | 31044 | 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 | 2388.269 | BLM | 1899 | National Public Lands 1 | 3 | |
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 | |
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 | |
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 | |
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 | |
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 | |
12300 | 12300 | 12299 | {"type": "Polygon", "coordinates": [[[-120.01821, 36.94471], [-120.01718, 36.9447], [-120.01718, 36.94347], [-120.01821, 36.94347], [-120.01821, 36.94471]]]} | Open Access 1 | 25956 | Parksdale Park | 23446 | 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.102 | Parksdale Park | 0 | Local Park 2 | 4 | |
12301 | 12301 | 12300 | {"type": "Polygon", "coordinates": [[[-120.06681, 36.9502], [-120.06625, 36.9502], [-120.06624, 36.9499], [-120.06681, 36.9499], [-120.06681, 36.9502]]]} | Open Access 1 | 25957 | Maple Court Park | 21773 | 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 | 0.411 | Maple Court Park | 0 | Local Park 2 | 4 | |
12302 | 12302 | 12301 | {"type": "Polygon", "coordinates": [[[-120.07527, 36.96901], [-120.07524, 36.96923], [-120.07421, 36.96928], [-120.07179, 36.96919], [-120.07167, 36.96895], [-120.07511, 36.96907], [-120.07527, 36.96901]]]} | Open Access 1 | 25958 | Riverview Park | 24465 | 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.953 | Riverview Park | 0 | Local Park 2 | 4 | |
12303 | 12303 | 12302 | {"type": "Polygon", "coordinates": [[[-120.06706, 36.96913], [-120.06617, 36.96914], [-120.06554, 36.96905], [-120.0649, 36.9689], [-120.06379, 36.96856], [-120.06329, 36.96848], [-120.06328, 36.96845], [-120.06372, 36.9684], [-120.06391, 36.96842], [-120.06572, 36.96897], [-120.0666, 36.96907], [-120.06685, 36.969], [-120.06701, 36.96907], [-120.06706, 36.96913]]]} | Open Access 1 | 25959 | Riverside Park | 24455 | 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.216 | Riverside 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 | |
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 | |||
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]);