units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,490 rows where MNG_AG_LEV = 3 sorted by AGNCY_ID
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Los Angeles, County of 170
- San Diego, County of 120
- Santa Barbara, County of 118
- Orange, County of 95
- Los Angeles - Department of Parks and Recreation, County of 62
- Lake, County of 56
- Sacramento, County of 55
- Santa Clara County Parks and Recreation Dept., County of 54
- Butte, County of 53
- Santa Cruz, County of 51
- Sonoma County Regional Parks Dept., County of 50
- Kern, County of 47
- Monterey, County of 46
- El Dorado, County of 44
- Riverside, County of 39
- Marin County Parks Department, County of 34
- San Luis Obispo, County of 31
- Placer, County of 28
- San Mateo County Parks and Recreation Dept., County of 25
- Ventura, County of 24
- Stanislaus, County of 24
- San Joaquin, County of 21
- San Bernardino, County of 18
- Yolo, County of 18
- Fresno, County of 17
- Merced, County of 16
- Tulare, County of 15
- San Francisco - Public Utilities Commission, City and County of 14
- Humboldt, County of 12
- Contra Costa County Public Works Dept., County of 11
- …
DES_TP >30
- Local Park 807
- Local Other or Unknown 221
- Local Recreation Area 154
- Local Conservation Area 114
- Local Historic or Cultural Area 21
- Local Resource Management Area 8
- National Forest 2
- National Monument or Landmark 2
- None 1
- None 1
- None 1
- None 1
- None 1
- National Recreation Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
ACCESS_TYP 4
- Open Access 1,305
- Restricted Access 81
- No Public Access 47
- Unknown Access 37
MNG_AG_TYP 3
- County Agency 1,206
- County Agency - Parks 232
- County Agency - Other 32
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16964 | 16964 | 16963 | {"type": "Polygon", "coordinates": [[[-122.44907, 37.70164], [-122.44695, 37.70279], [-122.44598, 37.70227], [-122.44575, 37.70217], [-122.44551, 37.70208], [-122.44361, 37.70161], [-122.44327, 37.70156], [-122.44284, 37.70156], [-122.44274, 37.70138], [-122.44263, 37.70126], [-122.4419, 37.7008], [-122.44065, 37.70092], [-122.44064, 37.70094], [-122.44125, 37.70273], [-122.44096, 37.7037], [-122.4397, 37.7037], [-122.43851, 37.70406], [-122.438, 37.70399], [-122.43697, 37.70439], [-122.4362, 37.7043], [-122.43532, 37.7044], [-122.43459, 37.70436], [-122.43413, 37.70446], [-122.43398, 37.70467], [-122.43383, 37.70462], [-122.4336, 37.70461], [-122.43349, 37.70458], [-122.43338, 37.70453], [-122.4332, 37.70439], [-122.43303, 37.70432], [-122.43276, 37.70429], [-122.43247, 37.7043], [-122.43192, 37.70404], [-122.43161, 37.70431], [-122.43171, 37.70461], [-122.43152, 37.70478], [-122.43141, 37.70481], [-122.43141, 37.70483], [-122.43148, 37.70482], [-122.43136, 37.70488], [-122.43118, 37.7049], [-122.43072, 37.70478], [-122.43052, 37.70476], [-122.43031, 37.70475], [-122.42995, 37.7048], [-122.42937, 37.70497], [-122.42917, 37.70497], [-122.429, 37.70494], [-122.42897, 37.70491], [-122.42902, 37.70474], [-122.42902, 37.70461], [-122.42888, 37.70403], [-122.42876, 37.70374], [-122.4285, 37.70331], [-122.42839, 37.70321], [-122.42792, 37.70287], [-122.4272, 37.70349], [-122.42551, 37.70158], [-122.42569, 37.70113], [-122.42477, 37.70004], [-122.42375, 37.70022], [-122.42353, 37.70032], [-122.42283, 37.70025], [-122.42269, 37.70022], [-122.42217, 37.69846], [-122.42341, 37.69681], [-122.42365, 37.69657], [-122.42396, 37.69637], [-122.42431, 37.69623], [-122.42468, 37.69614], [-122.42508, 37.69612], [-122.42534, 37.69614], [-122.42565, 37.69621], [-122.42589, 37.69629], [-122.42612, 37.6964], [-122.42887, 37.69833], [-122.42919, 37.69852], [-122.42949, 37.69862], [-122.42987, 37.6987], [-122.43026, 37.69871], [-122.43065, 37.69866], [-122.43096, 37.69857], [-122.43124, 37.69843], [-122.43149, 37.69826], [-122.4317, 37.69806], [-122.4318, 37.69793], [-122.43191, 37.69774], [-122.43243, 37.69655], [-122.43257, 37.69637], [-122.43274, 37.6962], [-122.43299, 37.69604], [-122.43333, 37.69591], [-122.4337, 37.69584], [-122.43408, 37.69585], [-122.43429, 37.69589], [-122.4345, 37.69595], [-122.43627, 37.69661], [-122.43688, 37.69687], [-122.43746, 37.69717], [-122.43981, 37.69866], [-122.44012, 37.69883], [-122.44045, 37.69896], [-122.44753, 37.70159], [-122.44784, 37.70167], [-122.44817, 37.70169], [-122.44855, 37.70167], [-122.44893, 37.70159], [-122.44907, 37.70164]]]} | Open Access 1 | 16001 | San Bruno Mountain State Park | 30691 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 324 | San Mateo County Parks and Recreation Dept., County of 28 | County 3 | County Agency - Parks 7 | http://www.parks.ca.gov/?page_id=518 | San Mateo 15 | 297.853 | San Bruno Mtn. SP | 1980 | None 1421 | |
11442 | 11442 | 11441 | {"type": "Polygon", "coordinates": [[[-118.36175, 33.93255], [-118.36175, 33.93272], [-118.36145, 33.93272], [-118.36146, 33.93255], [-118.36175, 33.93255]]]} | Open Access 1 | 48138 | Lennox Community Garden | 32666 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | Los Angeles 6 | 0.127 | Lennox Community Garden | 0 | Local Park 2 | 4 | |
1826 | 1826 | 1825 | {"type": "Polygon", "coordinates": [[[-121.59683, 37.91452], [-121.59681, 37.91464], [-121.59673, 37.91472], [-121.59644, 37.91528], [-121.59643, 37.91542], [-121.59661, 37.91574], [-121.5967, 37.9161], [-121.59664, 37.91618], [-121.59635, 37.91627], [-121.596, 37.91633], [-121.59546, 37.91637], [-121.59503, 37.91646], [-121.59462, 37.91649], [-121.59405, 37.91522], [-121.59426, 37.91509], [-121.5945, 37.91486], [-121.59474, 37.91466], [-121.59492, 37.91418], [-121.59501, 37.9138], [-121.59505, 37.91347], [-121.59532, 37.91343], [-121.59553, 37.91343], [-121.59577, 37.91346], [-121.59603, 37.91361], [-121.59619, 37.91376], [-121.59653, 37.91426], [-121.59673, 37.91442], [-121.59683, 37.91452]]]} | Open Access 1 | 15707 | Cornell Park | 32842 | 300 | Contra Costa County Public Works Dept., County of 429 | County 3 | County Agency - Other 9 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | Contra Costa 12 | 13.522 | Cornell Park | 0 | Local Park 2 | 4 | |
1963 | 1963 | 1962 | {"type": "Polygon", "coordinates": [[[-122.3308, 37.99984], [-122.32883, 38.00027], [-122.32826, 37.99972], [-122.32874, 37.99941], [-122.32795, 37.99863], [-122.32906, 37.99841], [-122.32936, 37.9984], [-122.33043, 37.9986], [-122.33057, 37.99918], [-122.33065, 37.99944], [-122.33072, 37.9996], [-122.3308, 37.99984]]]} | Open Access 1 | 15093 | Montalvin Park | 22382 | 300 | Contra Costa County Public Works Dept., County of 429 | County 3 | County Agency - Other 9 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | Contra Costa 12 | 8.497 | Montalvin Park | 0 | Local Park 2 | 4 | |
3257 | 3257 | 3256 | {"type": "Polygon", "coordinates": [[[-122.27841, 37.90357], [-122.27835, 37.9037], [-122.2783, 37.90383], [-122.27824, 37.90357], [-122.27841, 37.90357]]]} | Open Access 1 | 48179 | Kensington Pocket Park | 32715 | 300 | Contra Costa County Public Works Dept., County of 429 | County 3 | County Agency - Other 9 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | Contra Costa 12 | 0.053 | Kensington PP | 0 | Local Park 2 | 4 | |
7784 | 7784 | 7783 | {"type": "Polygon", "coordinates": [[[-122.09793, 38.0339], [-122.09769, 38.03914], [-122.09158, 38.04066], [-122.09096, 38.03986], [-122.08905, 38.03774], [-122.08812, 38.03657], [-122.08732, 38.03561], [-122.08642, 38.03459], [-122.08564, 38.03378], [-122.08448, 38.0328], [-122.08348, 38.03204], [-122.08255, 38.03143], [-122.09011, 38.02928], [-122.09118, 38.03176], [-122.09429, 38.0309], [-122.09428, 38.03188], [-122.09338, 38.03401], [-122.09417, 38.03471], [-122.09447, 38.03495], [-122.09577, 38.03467], [-122.09706, 38.03377], [-122.09793, 38.0339]]]} | Restricted Access 2 | 8772 | Point Edith Wetlands | 23847 | 300 | Contra Costa County Public Works Dept., County of 429 | County 3 | County Agency - Other 9 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | Contra Costa 12 | 211.368 | Point Edith Wetlands | 2001 | Local Conservation Area 4 | 2 | |
9091 | 9091 | 9090 | {"type": "Polygon", "coordinates": [[[-122.21997, 38.05377], [-122.21956, 38.05348], [-122.21836, 38.05306], [-122.21781, 38.05289], [-122.21792, 38.05262], [-122.2194, 38.05234], [-122.21949, 38.05202], [-122.21938, 38.05173], [-122.21992, 38.05179], [-122.21998, 38.05209], [-122.22007, 38.05311], [-122.22003, 38.05357], [-122.21997, 38.05377]]]} | Open Access 1 | 15057 | Crockett | 17826 | 300 | Contra Costa County Public Works Dept., County of 429 | County 3 | County Agency - Other 9 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | Contra Costa 12 | 5.153 | Crockett | None 753 | |||
11466 | 11466 | 11465 | {"type": "Polygon", "coordinates": [[[-122.28132, 37.9134], [-122.28121, 37.91335], [-122.28073, 37.91357], [-122.28038, 37.91363], [-122.28006, 37.91364], [-122.28059, 37.91414], [-122.28032, 37.91429], [-122.28033, 37.91433], [-122.28017, 37.91443], [-122.28013, 37.91447], [-122.28011, 37.91455], [-122.27999, 37.91464], [-122.27974, 37.91375], [-122.27977, 37.91354], [-122.27953, 37.91348], [-122.27932, 37.91337], [-122.27914, 37.9133], [-122.27894, 37.91332], [-122.27856, 37.91344], [-122.27849, 37.9134], [-122.27855, 37.91313], [-122.27855, 37.91292], [-122.28025, 37.91174], [-122.28106, 37.91239], [-122.2812, 37.91267], [-122.28074, 37.91276], [-122.28074, 37.91278], [-122.28092, 37.91335], [-122.28129, 37.91318], [-122.28132, 37.9134]]]} | Open Access 1 | 48178 | Kensington Park | 32713 | 300 | Contra Costa County Public Works Dept., County of 429 | County 3 | County Agency - Other 9 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | Contra Costa 12 | 8.459 | Kensington Park | 0 | Local Park 2 | 4 | |
12092 | 12092 | 12091 | {"type": "Polygon", "coordinates": [[[-122.02017, 37.86622], [-122.02016, 37.86639], [-122.01993, 37.86641], [-122.01969, 37.86648], [-122.01952, 37.86657], [-122.01934, 37.86672], [-122.0192, 37.86692], [-122.01905, 37.86733], [-122.01897, 37.86749], [-122.01882, 37.86767], [-122.01862, 37.86783], [-122.01852, 37.86783], [-122.01826, 37.8676], [-122.01798, 37.86742], [-122.01815, 37.86697], [-122.01795, 37.86683], [-122.0179, 37.86666], [-122.01792, 37.86629], [-122.01939, 37.86633], [-122.01944, 37.86632], [-122.0195, 37.86629], [-122.01953, 37.86625], [-122.01954, 37.8662], [-122.02017, 37.86622]]]} | Open Access 1 | 24911 | Livorna Park | 21386 | 300 | Contra Costa County Public Works Dept., County of 429 | County 3 | County Agency - Other 9 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | Contra Costa 12 | 4.387 | Livorna Park | 0 | Local Park 2 | 4 | |
12094 | 12094 | 12093 | {"type": "Polygon", "coordinates": [[[-121.95664, 38.0308], [-121.95557, 38.03164], [-121.95456, 38.03083], [-121.95562, 38.03], [-121.95664, 38.0308]]]} | Open Access 1 | 24917 | Lynbrook Park | 21606 | 300 | Contra Costa County Public Works Dept., County of 429 | County 3 | County Agency - Other 9 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | Contra Costa 12 | 4.143 | Lynbrook Park | 0 | Local Park 2 | 4 | |
12095 | 12095 | 12094 | {"type": "Polygon", "coordinates": [[[-122.2701, 38.03192], [-122.26926, 38.03205], [-122.2692, 38.03185], [-122.26868, 38.03192], [-122.26872, 38.03213], [-122.26707, 38.03237], [-122.26663, 38.03052], [-122.26966, 38.03007], [-122.2701, 38.03192]]]} | Open Access 1 | 24918 | Lefty Gomez Ballfield Complex | 21138 | 300 | Contra Costa County Public Works Dept., County of 429 | County 3 | County Agency - Other 9 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | Contra Costa 12 | 13.708 | Lefty Gomez Ballfield Complex | 0 | Local Recreation Area 3 | 4 | |
13163 | 13163 | 13162 | {"type": "Polygon", "coordinates": [[[-122.00274, 37.90517], [-122.00231, 37.90516], [-122.00213, 37.90513], [-122.00195, 37.90508], [-122.0017, 37.90499], [-121.99863, 37.90492], [-121.9986, 37.90475], [-121.99682, 37.90477], [-121.99628, 37.90372], [-121.994, 37.90374], [-121.99403, 37.90335], [-121.99401, 37.90309], [-121.99395, 37.90283], [-121.99387, 37.90259], [-121.99375, 37.90235], [-121.9936, 37.90213], [-121.99346, 37.90195], [-121.99811, 37.90237], [-121.99812, 37.90236], [-121.99811, 37.90229], [-122.00015, 37.90249], [-122.0002, 37.90249], [-122.0002, 37.90255], [-122.00096, 37.90262], [-122.00103, 37.90334], [-122.00094, 37.90336], [-122.00101, 37.90354], [-122.00107, 37.90407], [-122.00116, 37.90431], [-122.00123, 37.90442], [-122.00141, 37.90462], [-122.00151, 37.90471], [-122.00176, 37.90486], [-122.0019, 37.90492], [-122.00219, 37.905], [-122.00235, 37.90503], [-122.00268, 37.90503], [-122.00274, 37.90517]]]} | No Public Access 3 | 35113 | Mount Diablo Gateway | 28139 | 300 | Contra Costa County Public Works Dept., County of 429 | County 3 | County Agency - Other 9 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | Contra Costa 12 | 38.137 | Mount Diablo Gateway | None 1142 | |||
15875 | 15875 | 15874 | {"type": "Polygon", "coordinates": [[[-122.32946, 38.00168], [-122.32842, 38.00225], [-122.32756, 38.00145], [-122.32721, 38.00108], [-122.32859, 38.00069], [-122.32946, 38.00168]]]} | Open Access 1 | 15091 | Montara Bay Community Center | 22384 | 300 | Contra Costa County Public Works Dept., County of 429 | County 3 | County Agency - Other 9 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | Contra Costa 12 | 4.396 | Montara Bay Community Ctr. | 0 | Local Recreation Area 3 | 4 | |
958 | 958 | 957 | {"type": "Polygon", "coordinates": [[[-119.92531, 36.72346], [-119.92527, 36.72786], [-119.91225, 36.72797], [-119.91225, 36.72353], [-119.92531, 36.72346]]]} | Open Access 1 | 6028 | Kearney Park | 20564 | 301 | Fresno, County of 296 | County 3 | County Agency 3 | http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51904 | County 3 | 301 | Fresno, County of 292 | County 3 | County Agency 3 | Fresno 9 | 141.05 | Kearney Park | 0 | Local Park 2 | 4 | |
1092 | 1092 | 1091 | {"type": "MultiPolygon", "coordinates": [[[[-120.06057, 36.82127], [-120.05812, 36.82206], [-120.05808, 36.82217], [-120.05765, 36.82219], [-120.05656, 36.82261], [-120.05645, 36.82149], [-120.05648, 36.82129], [-120.05672, 36.82121], [-120.05673, 36.82153], [-120.05751, 36.82123], [-120.05809, 36.82109], [-120.0581, 36.82122], [-120.06056, 36.82068], [-120.06057, 36.82127]]], [[[-120.06297, 36.81983], [-120.06296, 36.82016], [-120.06068, 36.82113], [-120.06069, 36.82058], [-120.06297, 36.81983]]]]} | Open Access 1 | 6501 | Skaggs Bridge Park | 25525 | 301 | Fresno, County of 296 | County 3 | County Agency 3 | http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51904 | County 3 | 301 | Fresno, County of 292 | County 3 | County Agency 3 | Fresno 9 | 10.968 | Skaggs Bridge Park | 0 | Local Park 2 | 4 | |
3493 | 3493 | 3492 | {"type": "Polygon", "coordinates": [[[-119.84774, 36.85682], [-119.84773, 36.85954], [-119.84741, 36.8595], [-119.84434, 36.86227], [-119.84328, 36.8623], [-119.84113, 36.86119], [-119.8391, 36.85984], [-119.83905, 36.85717], [-119.84175, 36.85772], [-119.84229, 36.85626], [-119.8449, 36.85685], [-119.84774, 36.85682]]]} | Open Access 1 | 25924 | Scout Island | 25217 | 301 | Fresno, County of 296 | County 3 | County Agency 3 | http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51904 | County 3 | 301 | Fresno, County of 292 | County 3 | County Agency 3 | Fresno 9 | 88.577 | Scout Island | None 291 | |||
4154 | 4154 | 4153 | {"type": "Polygon", "coordinates": [[[-119.81577, 36.82816], [-119.81567, 36.82823], [-119.81543, 36.8286], [-119.81534, 36.82863], [-119.81459, 36.82867], [-119.81452, 36.82859], [-119.81441, 36.82857], [-119.81437, 36.82825], [-119.81437, 36.82794], [-119.81444, 36.82792], [-119.8145, 36.82788], [-119.81531, 36.82788], [-119.81536, 36.82792], [-119.81542, 36.82795], [-119.81549, 36.82795], [-119.81556, 36.82793], [-119.81577, 36.82816]]]} | Open Access 1 | 47541 | Tenaya Park | 31249 | 301 | Fresno, County of 296 | County 3 | County Agency 3 | http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51904 | County 3 | 301 | Fresno, County of 292 | County 3 | County Agency 3 | http://www.tenayapark.org/home | Fresno 9 | 2.209 | Tenaya Park | 0 | Local Park 2 | 4 |
5462 | 5462 | 5461 | {"type": "Polygon", "coordinates": [[[-120.5772, 36.23014], [-120.576, 36.23388], [-120.57199, 36.23385], [-120.57199, 36.23372], [-120.57111, 36.23372], [-120.57112, 36.2293], [-120.57146, 36.22934], [-120.57203, 36.22947], [-120.57274, 36.22952], [-120.57507, 36.22999], [-120.57554, 36.23005], [-120.57601, 36.23004], [-120.5772, 36.23014]]]} | Open Access 1 | 6270 | Los Gatos Creek County Park | 21515 | 301 | Fresno, County of 296 | County 3 | County Agency 3 | http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51904 | County 3 | 301 | Fresno, County of 292 | County 3 | County Agency 3 | Fresno 9 | 55.581 | Los Gatos Creek County Park | 0 | Local Park 2 | 4 | |
6352 | 6352 | 6351 | {"type": "Polygon", "coordinates": [[[-120.39086, 36.50214], [-120.39079, 36.50243], [-120.39079, 36.50283], [-120.39059, 36.50287], [-120.39032, 36.50283], [-120.39015, 36.50274], [-120.38996, 36.50251], [-120.38987, 36.50246], [-120.38984, 36.50229], [-120.38984, 36.50215], [-120.38985, 36.50208], [-120.3899, 36.502], [-120.39023, 36.50191], [-120.39072, 36.50197], [-120.39086, 36.50214]]]} | Open Access 1 | 1777 | El Parque de la Communida El Porvenir | 18524 | 301 | Fresno, County of 296 | County 3 | County Agency 3 | http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51904 | County 3 | 301 | Fresno, County of 292 | County 3 | County Agency 3 | Fresno 9 | 1.861 | El Parque de la Communida El Porvenir | None 513 | |||
6986 | 6986 | 6985 | {"type": "Polygon", "coordinates": [[[-119.42108, 36.77855], [-119.42081, 36.78005], [-119.41857, 36.78242], [-119.41777, 36.78378], [-119.41743, 36.78552], [-119.41756, 36.78608], [-119.41728, 36.7867], [-119.41689, 36.78775], [-119.4136, 36.79017], [-119.41289, 36.79018], [-119.41291, 36.78956], [-119.41265, 36.78957], [-119.41264, 36.78953], [-119.41163, 36.78953], [-119.41163, 36.79007], [-119.41169, 36.79008], [-119.41169, 36.7902], [-119.41163, 36.79021], [-119.41163, 36.79075], [-119.41051, 36.79098], [-119.40972, 36.79183], [-119.4092, 36.79286], [-119.40806, 36.79282], [-119.40253, 36.79276], [-119.4029, 36.79203], [-119.40398, 36.79025], [-119.40444, 36.79042], [-119.40455, 36.79042], [-119.40454, 36.79034], [-119.4045, 36.79033], [-119.40438, 36.79018], [-119.40409, 36.79007], [-119.40466, 36.78911], [-119.40589, 36.7856], [-119.40683, 36.7856], [-119.40682, 36.78531], [-119.40608, 36.7853], [-119.40697, 36.78457], [-119.40753, 36.78396], [-119.40776, 36.78365], [-119.4092, 36.78367], [-119.40889, 36.78446], [-119.40818, 36.78559], [-119.40818, 36.78561], [-119.41158, 36.78567], [-119.41163, 36.78947], [-119.41293, 36.78906], [-119.41329, 36.78548], [-119.41363, 36.78401], [-119.41156, 36.78247], [-119.41151, 36.78205], [-119.41573, 36.78208], [-119.41818, 36.77991], [-119.41917, 36.78014], [-119.42026, 36.77852], [-119.42108, 36.77855]]]} | Open Access 1 | 5909 | Avocado Lake Park | 3936 | 301 | Fresno, County of 296 | County 3 | County Agency 3 | http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51904 | County 3 | 301 | Fresno, County of 292 | County 3 | County Agency 3 | http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51947 | Fresno 9 | 225.777 | Avocado Lake Park | 0 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]), FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]), FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]), FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]), FOREIGN KEY([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);