units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
52 rows where MNG_AGENCY = 142 and MNG_AG_TYP = 1 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_WEB, PARK_URL, COUNTY, GAP_STS
DES_TP 11
- Recreation Management Area 29
- Resource Management Area 14
- Conservation Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 3
MNG_AG_TYP 1
- Federal Agency · 52 ✖
MNG_AGENCY 1
- United States Army Corps of Engineers · 52 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16806 | 16806 | 16805 | {"type": "Polygon", "coordinates": [[[-119.29135, 36.90366], [-119.29138, 36.90381], [-119.29133, 36.904], [-119.29126, 36.90411], [-119.29101, 36.904], [-119.29089, 36.90383], [-119.29093, 36.90363], [-119.29103, 36.90354], [-119.29125, 36.90356], [-119.29135, 36.90366]]]} | Open Access 1 | 15864 | Trimmer Recreation Area | 26537 | 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 | Fresno 9 | 0.497 | Trimmer Rec. Area | 0 | Recreation Management Area 49 | 4 | |
5413 | 5413 | 5412 | {"type": "MultiPolygon", "coordinates": [[[[-118.22858, 33.88759], [-118.22857, 33.88759], [-118.22835, 33.88727], [-118.22846, 33.88739], [-118.22858, 33.88759]]], [[[-118.24226, 33.90419], [-118.24209, 33.90423], [-118.24193, 33.90397], [-118.24191, 33.9036], [-118.24216, 33.90405], [-118.24226, 33.90419]]], [[[-118.24858, 33.91176], [-118.24841, 33.91176], [-118.24735, 33.91049], [-118.24755, 33.9105], [-118.24857, 33.91171], [-118.24858, 33.91176]]]]} | Open Access 1 | 7202 | Compton Creek & Bike Path | 17571 | 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 | Los Angeles 6 | 0.849 | Compton Creek & Bike Path | 0 | Recreation Management Area 49 | 4 | |
16770 | 16770 | 16769 | {"type": "Polygon", "coordinates": [[[-120.73227, 37.78935], [-120.73205, 37.79003], [-120.73166, 37.79035], [-120.73108, 37.7907], [-120.7305, 37.79113], [-120.73019, 37.79132], [-120.7301, 37.79127], [-120.72956, 37.79192], [-120.72909, 37.79271], [-120.72888, 37.79387], [-120.72864, 37.79446], [-120.72771, 37.79518], [-120.72674, 37.79679], [-120.72645, 37.79737], [-120.72624, 37.79731], [-120.72646, 37.79704], [-120.72657, 37.79678], [-120.72669, 37.79637], [-120.72674, 37.79631], [-120.72681, 37.79631], [-120.7269, 37.79627], [-120.72699, 37.79605], [-120.72711, 37.79591], [-120.72719, 37.79568], [-120.72751, 37.79517], [-120.72788, 37.79479], [-120.72808, 37.79468], [-120.72816, 37.79453], [-120.72827, 37.79445], [-120.72845, 37.79439], [-120.72864, 37.79417], [-120.72878, 37.79375], [-120.7288, 37.79336], [-120.7286, 37.79303], [-120.7286, 37.79274], [-120.72882, 37.79248], [-120.7289, 37.79217], [-120.72907, 37.79182], [-120.72931, 37.79148], [-120.72949, 37.79131], [-120.72962, 37.79107], [-120.7298, 37.79097], [-120.73005, 37.79063], [-120.73065, 37.79035], [-120.731, 37.79008], [-120.73128, 37.7895], [-120.73148, 37.78893], [-120.73204, 37.78857], [-120.73209, 37.78884], [-120.73227, 37.78935]]]} | Open Access 1 | 44371 | Honolulu Bar Recreation Area | 20069 | 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 | Stanislaus 2 | 10.135 | Honolulu Bar Rec. Area | 0 | Recreation Management Area 49 | 4 | |
4073 | 4073 | 4072 | {"type": "MultiPolygon", "coordinates": [[[[-120.7228, 38.19705], [-120.72278, 38.19976], [-120.72012, 38.19972], [-120.72078, 38.19943], [-120.72093, 38.19966], [-120.72272, 38.19967], [-120.72171, 38.19821], [-120.72233, 38.19741], [-120.72259, 38.19716], [-120.7228, 38.19705]]], [[[-120.72281, 38.19613], [-120.7228, 38.19668], [-120.72254, 38.19675], [-120.7222, 38.19697], [-120.72174, 38.19745], [-120.72141, 38.19782], [-120.72072, 38.19676], [-120.72023, 38.19607], [-120.72281, 38.19613]]]]} | Open Access 1 | 44450 | New Hogan Lake | 13827 | 103 | United States Bureau of Reclamation 369 | Federal 1 | Federal Agency 1 | http://www.usbr.gov/ | Other Federal 13 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | http://www.spk.usace.army.mil/Locations/SacramentoDistrictParks/NewHoganLake.aspx | Calaveras 53 | 10.237 | New Hogan Lake | 0 | Resource Management Area 82 | 3 |
710 | 710 | 709 | {"type": "Polygon", "coordinates": [[[-122.49778, 38.11503], [-122.49513, 38.11705], [-122.49391, 38.11801], [-122.49231, 38.1192], [-122.49241, 38.1189], [-122.49275, 38.11856], [-122.49311, 38.11825], [-122.49339, 38.11787], [-122.49376, 38.11735], [-122.49389, 38.11699], [-122.49396, 38.11668], [-122.49396, 38.11519], [-122.49778, 38.11503]]]} | No Public Access 3 | 4004 | Sonoma Baylands | 25607 | 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 | Sonoma 16 | 14.555 | Sonoma Baylands | None 66 | |||
465 | 465 | 464 | {"type": "Polygon", "coordinates": [[[-118.48671, 34.16591], [-118.48664, 34.16649], [-118.48663, 34.16717], [-118.48664, 34.16724], [-118.48669, 34.16733], [-118.48656, 34.1675], [-118.48638, 34.16753], [-118.48622, 34.16759], [-118.48616, 34.16766], [-118.48614, 34.16773], [-118.4862, 34.16804], [-118.48623, 34.16809], [-118.48628, 34.16811], [-118.48608, 34.16815], [-118.4861, 34.1681], [-118.48604, 34.16774], [-118.48591, 34.16777], [-118.48581, 34.1677], [-118.48557, 34.16772], [-118.48516, 34.16783], [-118.48494, 34.16787], [-118.48445, 34.16789], [-118.48418, 34.16787], [-118.48385, 34.1678], [-118.48369, 34.16772], [-118.48359, 34.1676], [-118.48357, 34.16755], [-118.48351, 34.1671], [-118.48355, 34.16638], [-118.48357, 34.16623], [-118.48362, 34.16609], [-118.48368, 34.16599], [-118.48374, 34.16594], [-118.48387, 34.1659], [-118.4853, 34.16589], [-118.48633, 34.16583], [-118.48634, 34.16591], [-118.48639, 34.16594], [-118.48671, 34.16591]]]} | Open Access 1 | 1861 | Hjelte Sports Center | 20010 | 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 | Los Angeles 6 | 14.721 | Hjelte Sports Ctr. | 0 | Recreation Management Area 49 | 4 | |
9903 | 9903 | 9902 | {"type": "Polygon", "coordinates": [[[-120.7739, 37.7927], [-120.77322, 37.79285], [-120.77164, 37.79236], [-120.76957, 37.7921], [-120.76865, 37.79188], [-120.76749, 37.79128], [-120.76755, 37.79123], [-120.76755, 37.79122], [-120.76728, 37.79108], [-120.76722, 37.79113], [-120.767, 37.79101], [-120.76646, 37.79083], [-120.76346, 37.79052], [-120.76278, 37.79031], [-120.7628, 37.79023], [-120.7623, 37.79007], [-120.76196, 37.78989], [-120.76187, 37.78981], [-120.7618, 37.78973], [-120.76168, 37.78963], [-120.76164, 37.78954], [-120.76156, 37.78946], [-120.76149, 37.78928], [-120.76187, 37.78901], [-120.76279, 37.78841], [-120.76306, 37.7888], [-120.76333, 37.78906], [-120.76406, 37.78952], [-120.76436, 37.78977], [-120.76462, 37.79011], [-120.76495, 37.7903], [-120.76532, 37.79038], [-120.76563, 37.79056], [-120.76598, 37.79061], [-120.7663, 37.79063], [-120.76685, 37.79076], [-120.76706, 37.79086], [-120.76727, 37.79091], [-120.76769, 37.79094], [-120.76799, 37.79105], [-120.76824, 37.79119], [-120.76868, 37.79131], [-120.76899, 37.79142], [-120.76932, 37.79152], [-120.76973, 37.79158], [-120.77008, 37.79175], [-120.77082, 37.79188], [-120.77112, 37.79192], [-120.77182, 37.79208], [-120.77211, 37.79209], [-120.77259, 37.7922], [-120.77319, 37.79236], [-120.77374, 37.79233], [-120.7739, 37.7927]]]} | Open Access 1 | 18350 | Orange Blossom Recreation Area | 23150 | 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 | Stanislaus 2 | 17.472 | Orange Blossom Rec. Area | 0 | Recreation Management Area 49 | 4 | |
4053 | 4053 | 4052 | {"type": "Polygon", "coordinates": [[[-120.63426, 37.85934], [-120.63377, 37.86008], [-120.63222, 37.86096], [-120.63246, 37.86129], [-120.63243, 37.86133], [-120.63134, 37.86171], [-120.63, 37.86242], [-120.62992, 37.8625], [-120.6297, 37.8621], [-120.62844, 37.86263], [-120.62838, 37.86143], [-120.62837, 37.86142], [-120.62757, 37.86181], [-120.627, 37.86214], [-120.62667, 37.86238], [-120.62626, 37.86279], [-120.62597, 37.86317], [-120.62588, 37.86306], [-120.62646, 37.86246], [-120.62671, 37.86225], [-120.62838, 37.86135], [-120.62883, 37.86124], [-120.62922, 37.86146], [-120.62971, 37.86134], [-120.63001, 37.86097], [-120.63166, 37.86028], [-120.6323, 37.85981], [-120.63255, 37.85869], [-120.63325, 37.85868], [-120.63426, 37.85934]]]} | Open Access 1 | 44370 | Goodwin Dam Recreation Area | 19404 | 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 | Tuolumne 21 | 18.684 | Goodwin Dam Rec. Area | 0 | Recreation Management Area 49 | 4 | |
8114 | 8114 | 8113 | {"type": "MultiPolygon", "coordinates": [[[[-118.49444, 34.16485], [-118.49256, 34.16484], [-118.49252, 34.16479], [-118.49252, 34.16402], [-118.49444, 34.16402], [-118.49444, 34.16485]]], [[[-118.49868, 34.16866], [-118.49868, 34.16878], [-118.49696, 34.16775], [-118.49431, 34.16604], [-118.49381, 34.16578], [-118.4935, 34.16564], [-118.49295, 34.16543], [-118.49252, 34.1653], [-118.49253, 34.16504], [-118.49257, 34.16501], [-118.49601, 34.16502], [-118.49602, 34.16639], [-118.49867, 34.16641], [-118.49868, 34.16866]]]]} | Open Access 1 | 12239 | Sepulveda Garden Center | 25304 | 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 | Los Angeles 6 | 24.1 | Sepulveda Garden Ctr. | None 677 | |||
10059 | 10059 | 10058 | {"type": "Polygon", "coordinates": [[[-118.49219, 34.16366], [-118.49127, 34.1647], [-118.49126, 34.16484], [-118.48809, 34.16482], [-118.48809, 34.16062], [-118.48813, 34.16046], [-118.48931, 34.16046], [-118.48932, 34.1631], [-118.49219, 34.16311], [-118.49219, 34.16366]]]} | Open Access 1 | 17417 | Libbit Park | 21202 | 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 | Los Angeles 6 | 24.58 | Libbit Park | 0 | Recreation Management Area 49 | 4 | |
16750 | 16750 | 16749 | {"type": "Polygon", "coordinates": [[[-120.80656, 37.78696], [-120.80405, 37.78649], [-120.80405, 37.78871], [-120.80384, 37.78865], [-120.80383, 37.78687], [-120.80275, 37.78665], [-120.80274, 37.78629], [-120.80111, 37.7865], [-120.79955, 37.78698], [-120.79955, 37.78605], [-120.79971, 37.78594], [-120.80213, 37.78523], [-120.80283, 37.78506], [-120.80399, 37.78493], [-120.80505, 37.78492], [-120.8056, 37.78499], [-120.80612, 37.78511], [-120.80655, 37.7853], [-120.80656, 37.78696]]]} | Open Access 1 | 48840 | Valley Oak Recreation Area | 33560 | 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 | https://stanislausriver.com/parks/valley-oak-recration-area/ | Stanislaus 2 | 24.963 | Valley Oak Rec. Area | 0 | Recreation Management Area 49 | 4 |
7058 | 7058 | 7057 | {"type": "Polygon", "coordinates": [[[-118.06181, 34.02017], [-118.06089, 34.02054], [-118.06107, 34.02082], [-118.06117, 34.02082], [-118.06121, 34.02141], [-118.05671, 34.02154], [-118.0577, 34.02122], [-118.05703, 34.01992], [-118.05747, 34.01907], [-118.05897, 34.01802], [-118.06078, 34.01739], [-118.06033, 34.01796], [-118.05961, 34.01857], [-118.0607, 34.02026], [-118.06181, 34.02017]]]} | Restricted Access 2 | 6569 | Pico Rivera Golf Course | 33017 | 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 | Los Angeles 6 | 26.31 | Pico Rivera GC | 0 | Recreation Management Area 49 | 4 | |
7280 | 7280 | 7279 | {"type": "MultiPolygon", "coordinates": [[[[-118.07223, 34.05905], [-118.07151, 34.05982], [-118.07104, 34.06086], [-118.07094, 34.06104], [-118.06981, 34.06232], [-118.06997, 34.06256], [-118.06964, 34.06256], [-118.07093, 34.06059], [-118.07092, 34.06052], [-118.06959, 34.06256], [-118.06763, 34.06256], [-118.06906, 34.06137], [-118.06934, 34.06104], [-118.06956, 34.06068], [-118.06965, 34.06049], [-118.06976, 34.06012], [-118.07026, 34.05725], [-118.07195, 34.05724], [-118.0719, 34.05755], [-118.07187, 34.05754], [-118.07164, 34.05893], [-118.07223, 34.05893], [-118.07223, 34.05905]]], [[[-118.06908, 34.06284], [-118.06876, 34.06313], [-118.06883, 34.06321], [-118.06867, 34.06332], [-118.06859, 34.06326], [-118.0681, 34.06363], [-118.06805, 34.06415], [-118.06797, 34.06422], [-118.06775, 34.06427], [-118.06774, 34.06391], [-118.06773, 34.0639], [-118.06717, 34.06433], [-118.06717, 34.06434], [-118.06721, 34.06437], [-118.06718, 34.06438], [-118.06632, 34.06357], [-118.06714, 34.06297], [-118.06715, 34.06292], [-118.06725, 34.06284], [-118.06908, 34.06284]]], [[[-118.06672, 34.06464], [-118.06662, 34.06466], [-118.06572, 34.06519], [-118.0656, 34.06508], [-118.06526, 34.06526], [-118.0646, 34.06571], [-118.06381, 34.06571], [-118.06493, 34.06491], [-118.06518, 34.06471], [-118.06559, 34.06431], [-118.06572, 34.06421], [-118.06605, 34.064], [-118.06672, 34.06464]]], [[[-118.06408, 34.06584], [-118.06348, 34.06628], [-118.06328, 34.06608], [-118.06362, 34.06584], [-118.06408, 34.06584]]]]} | Open Access 1 | 6565 | Rio Hondo | 24379 | 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 | Los Angeles 6 | 33.327 | Rio Hondo | 0 | None 601 | ||
356 | 356 | 355 | {"type": "Polygon", "coordinates": [[[-122.49396, 38.11519], [-122.49396, 38.11668], [-122.49389, 38.11699], [-122.49376, 38.11735], [-122.49339, 38.11788], [-122.49311, 38.11825], [-122.49275, 38.11856], [-122.49241, 38.1189], [-122.49231, 38.1192], [-122.49228, 38.11936], [-122.49071, 38.12038], [-122.48879, 38.12141], [-122.48651, 38.12238], [-122.47257, 38.12807], [-122.47183, 38.12772], [-122.48389, 38.1232], [-122.49205, 38.11836], [-122.49375, 38.11703], [-122.49245, 38.11561], [-122.4906, 38.11561], [-122.49396, 38.11519]]]} | Restricted Access 2 | 982 | Sonoma Baylands | 25608 | 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 | Sonoma 16 | 37.517 | Sonoma Baylands | None 36 | |||
16732 | 16732 | 16731 | {"type": "Polygon", "coordinates": [[[-121.01374, 37.75437], [-121.01373, 37.7545], [-121.01301, 37.755], [-121.01238, 37.75508], [-121.01166, 37.75503], [-121.01108, 37.75503], [-121.01074, 37.7551], [-121.0102, 37.75528], [-121.01022, 37.75749], [-121.01034, 37.75767], [-121.01005, 37.75774], [-121.01003, 37.75498], [-121.01044, 37.75499], [-121.01078, 37.75439], [-121.0108, 37.75364], [-121.01074, 37.75322], [-121.01058, 37.75288], [-121.01036, 37.75269], [-121.01021, 37.75222], [-121.00956, 37.75208], [-121.00872, 37.75173], [-121.00845, 37.75113], [-121.0084, 37.75073], [-121.00826, 37.75062], [-121.0081, 37.75058], [-121.00782, 37.7506], [-121.00752, 37.75067], [-121.00731, 37.75075], [-121.00726, 37.7507], [-121.00736, 37.75051], [-121.00732, 37.74994], [-121.00762, 37.74926], [-121.00811, 37.74904], [-121.00902, 37.74897], [-121.00982, 37.74905], [-121.01015, 37.74927], [-121.01079, 37.74964], [-121.01155, 37.74982], [-121.01204, 37.74968], [-121.01251, 37.74962], [-121.0127, 37.75005], [-121.01255, 37.75045], [-121.01216, 37.75078], [-121.01147, 37.75101], [-121.01094, 37.75128], [-121.01077, 37.75164], [-121.01095, 37.75201], [-121.01138, 37.75228], [-121.01218, 37.7526], [-121.01235, 37.75306], [-121.01234, 37.7532], [-121.01213, 37.75359], [-121.01232, 37.75404], [-121.01281, 37.75419], [-121.01333, 37.7542], [-121.01374, 37.75437]]]} | Open Access 1 | 36069 | McHenry Recreation Area | 22039 | 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 | San Joaquin 39 | 40.217 | McHenry Rec. Area | 0 | Recreation Management Area 49 | 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 | |
7293 | 7293 | 7292 | {"type": "MultiPolygon", "coordinates": [[[[-118.01784, 34.03317], [-118.01637, 34.03369], [-118.01597, 34.03343], [-118.01578, 34.03332], [-118.01537, 34.03313], [-118.01494, 34.03296], [-118.01452, 34.03284], [-118.01405, 34.03273], [-118.0137, 34.03268], [-118.01324, 34.03264], [-118.01251, 34.03265], [-118.00974, 34.03282], [-118.00678, 34.03311], [-118.00624, 34.03311], [-118.00493, 34.03305], [-118.00415, 34.03306], [-118.0047, 34.03204], [-118.00526, 34.03207], [-118.00593, 34.03205], [-118.01346, 34.0313], [-118.01347, 34.03152], [-118.014, 34.03159], [-118.01473, 34.03174], [-118.01539, 34.03193], [-118.01594, 34.03213], [-118.01646, 34.03237], [-118.01676, 34.03253], [-118.01784, 34.03317]]], [[[-118.02359, 34.03666], [-118.0233, 34.03661], [-118.02246, 34.03717], [-118.01999, 34.03569], [-118.01964, 34.03556], [-118.019, 34.03519], [-118.01847, 34.03488], [-118.01846, 34.03483], [-118.01676, 34.03384], [-118.01816, 34.03334], [-118.02047, 34.03471], [-118.02066, 34.03491], [-118.02335, 34.0365], [-118.02359, 34.03666]]]]} | Open Access 1 | 6572 | San Jose Creek | 24914 | 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 | http://www.usace.army.mil/ | Los Angeles 6 | 55.286 | San Jose Creek | None 603 | ||
16699 | 16699 | 16698 | {"type": "Polygon", "coordinates": [[[-120.88295, 37.77172], [-120.88256, 37.77198], [-120.88179, 37.77203], [-120.88033, 37.77166], [-120.87991, 37.77131], [-120.87976, 37.77136], [-120.87973, 37.77128], [-120.87865, 37.7707], [-120.87693, 37.77072], [-120.87501, 37.7713], [-120.87088, 37.77321], [-120.86954, 37.77366], [-120.86818, 37.77427], [-120.86739, 37.77476], [-120.86714, 37.7757], [-120.8669, 37.77195], [-120.86735, 37.77185], [-120.86749, 37.77197], [-120.86801, 37.77201], [-120.86826, 37.77194], [-120.8684, 37.77181], [-120.86849, 37.77182], [-120.86855, 37.77192], [-120.86865, 37.77192], [-120.86877, 37.77184], [-120.86883, 37.7717], [-120.86878, 37.77144], [-120.86945, 37.77132], [-120.87085, 37.77084], [-120.87131, 37.7705], [-120.8715, 37.77059], [-120.87171, 37.77054], [-120.87272, 37.77023], [-120.87311, 37.7702], [-120.87349, 37.77006], [-120.87407, 37.76978], [-120.87444, 37.76966], [-120.87499, 37.76936], [-120.87556, 37.76908], [-120.87594, 37.76891], [-120.87603, 37.76883], [-120.87606, 37.76874], [-120.87618, 37.76877], [-120.87631, 37.76893], [-120.87689, 37.76888], [-120.87756, 37.76886], [-120.87798, 37.76892], [-120.8785, 37.76891], [-120.87959, 37.76911], [-120.88003, 37.7691], [-120.88132, 37.77008], [-120.88248, 37.77006], [-120.88226, 37.77044], [-120.88174, 37.77064], [-120.88177, 37.77075], [-120.88229, 37.77116], [-120.88283, 37.77155], [-120.88295, 37.77172]]]} | Open Access 1 | 24997 | Oakdale Recreation Area | 23026 | 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 | Stanislaus 2 | 79.54 | Oakdale Rec. Area | 0 | Recreation Management Area 49 | 4 | |
6010 | 6010 | 6009 | {"type": "Polygon", "coordinates": [[[-118.50547, 34.18013], [-118.50135, 34.18014], [-118.50135, 34.17454], [-118.5013, 34.17234], [-118.50547, 34.17239], [-118.50547, 34.18013]]]} | Open Access 1 | 665 | Balboa Sports Center | 15773 | 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 | Los Angeles 6 | 81.108 | Balboa Sports Ctr. | 0 | Recreation Management Area 49 | 4 | |
8199 | 8199 | 8198 | {"type": "MultiPolygon", "coordinates": [[[[-118.41192, 34.30466], [-118.41068, 34.30557], [-118.40898, 34.30398], [-118.40892, 34.30416], [-118.41053, 34.30568], [-118.40755, 34.30785], [-118.40753, 34.3079], [-118.40684, 34.30791], [-118.40702, 34.30699], [-118.40687, 34.30638], [-118.40668, 34.30644], [-118.40655, 34.30641], [-118.40685, 34.30618], [-118.40733, 34.30605], [-118.40767, 34.3052], [-118.40766, 34.30519], [-118.40753, 34.30518], [-118.40761, 34.30442], [-118.40774, 34.30388], [-118.40879, 34.30236], [-118.40906, 34.30219], [-118.40936, 34.30229], [-118.40954, 34.30196], [-118.40968, 34.30176], [-118.41031, 34.30204], [-118.41001, 34.30253], [-118.41191, 34.30338], [-118.4117, 34.30415], [-118.41192, 34.30466]]], [[[-118.41297, 34.30697], [-118.41202, 34.30909], [-118.41195, 34.30938], [-118.41166, 34.30947], [-118.4113, 34.30955], [-118.41094, 34.3096], [-118.41057, 34.30961], [-118.40749, 34.3094], [-118.40745, 34.30938], [-118.40743, 34.30868], [-118.40746, 34.30848], [-118.4076, 34.30811], [-118.40756, 34.30807], [-118.41066, 34.3058], [-118.41184, 34.30691], [-118.41185, 34.30691], [-118.41187, 34.30669], [-118.41081, 34.30569], [-118.41208, 34.30477], [-118.4123, 34.30503], [-118.4125, 34.30531], [-118.41297, 34.30697]]], [[[-118.412, 34.31043], [-118.41147, 34.31141], [-118.4113, 34.31165], [-118.41041, 34.31081], [-118.4119, 34.30973], [-118.412, 34.31043]]], [[[-118.41175, 34.30962], [-118.4109, 34.31024], [-118.40853, 34.31197], [-118.40856, 34.30964], [-118.41057, 34.30978], [-118.41115, 34.30974], [-118.41141, 34.3097], [-118.41175, 34.30962]]], [[[-118.4089, 34.31192], [-118.40887, 34.31212], [-118.40862, 34.31212], [-118.4089, 34.31192], [-118.4089, 34.31192]]]]} | No Public Access 3 | 12454 | Lopez Reservoir and Dam | 21465 | 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 | Los Angeles 6 | 92.431 | Lopez Reservoir and Dam | 0 | Resource Management Area 82 | 3 |
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]);