units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,454 rows where LAYER = 3 sorted by MNG_AG_ID
This data as json, copyable, CSV (advanced)
Suggested facets: GAP_STS
MNG_AGENCY >30
- Los Angeles, County of 155
- Santa Barbara, County of 117
- San Diego, County of 117
- Orange, County of 91
- Los Angeles - Department of Parks and Recreation, County of 60
- Lake, County of 56
- Sacramento, County of 55
- Butte, County of 53
- Santa Cruz, County of 51
- Sonoma County Regional Parks Dept., County of 49
- Kern, County of 47
- Monterey, County of 46
- El Dorado, County of 42
- Santa Clara County Parks and Recreation Dept., County of 41
- Riverside, County of 38
- Marin County Parks Department, County of 33
- San Luis Obispo, County of 31
- Placer, County of 28
- San Mateo County Parks and Recreation Dept., County of 24
- Ventura, County of 24
- Stanislaus, County of 24
- San Joaquin, County of 21
- Yolo, County of 18
- Fresno, County of 17
- San Bernardino, 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 798
- Local Other or Unknown 221
- Local Recreation Area 146
- 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
- State Conservation Area 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
- …
MNG_AG_TYP 13
ACCESS_TYP 4
- Open Access 1,290
- Restricted Access 78
- No Public Access 49
- Unknown Access 37
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16430 | 16430 | 16429 | {"type": "MultiPolygon", "coordinates": [[[[-117.09275, 32.55093], [-117.08419, 32.55089], [-117.08418, 32.54718], [-117.0885, 32.54724], [-117.08851, 32.54815], [-117.09275, 32.54817], [-117.09274, 32.54879], [-117.09275, 32.55093]]], [[[-117.10589, 32.55459], [-117.10142, 32.55462], [-117.0993, 32.55461], [-117.09923, 32.55817], [-117.09713, 32.55816], [-117.09714, 32.55461], [-117.09632, 32.5546], [-117.09634, 32.55816], [-117.09383, 32.55815], [-117.09383, 32.55778], [-117.09285, 32.55777], [-117.09287, 32.54879], [-117.09289, 32.5476], [-117.09288, 32.54732], [-117.1016, 32.54732], [-117.10155, 32.54367], [-117.10156, 32.53999], [-117.10318, 32.53998], [-117.10318, 32.54033], [-117.10459, 32.54111], [-117.1046, 32.54365], [-117.10584, 32.54365], [-117.10585, 32.54377], [-117.10576, 32.54378], [-117.10576, 32.54731], [-117.10584, 32.54732], [-117.10583, 32.55098], [-117.10589, 32.55459]]], [[[-117.11232, 32.54729], [-117.11231, 32.55095], [-117.11011, 32.55096], [-117.11016, 32.54731], [-117.11232, 32.54729]]]]} | Open Access 1 | 45291 | Tijuana River Valley Regional Park | 26362 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 106 | United States Fish and Wildlife Service 44 | Federal 1 | Federal Agency 1 | http://www.sdparks.org/content/sdparks/en/park-pages/TJRVRP.html | San Diego 4 | 451.08 | Tijuana River Valley RP | None 1401 | ||
10083 | 10083 | 10082 | {"type": "MultiPolygon", "coordinates": [[[[-117.27291, 33.00739], [-117.26287, 33.00739], [-117.26203, 33.00689], [-117.26063, 33.00632], [-117.26066, 33.00626], [-117.26003, 33.00589], [-117.25972, 33.00557], [-117.25947, 33.00491], [-117.25957, 33.00483], [-117.25923, 33.00381], [-117.2588, 33.00344], [-117.25859, 33.00253], [-117.2588, 33.00172], [-117.25872, 33.00139], [-117.25829, 33.0005], [-117.25825, 33.0003], [-117.25846, 33.0003], [-117.2604, 33.00252], [-117.26197, 33.00312], [-117.26213, 33.00334], [-117.26214, 33.00387], [-117.26433, 33.00388], [-117.26433, 33.00262], [-117.26471, 33.00262], [-117.26472, 33.00248], [-117.26513, 33.00249], [-117.26513, 33.00208], [-117.26657, 33.00209], [-117.26659, 33.00211], [-117.2669, 33.00284], [-117.26699, 33.00292], [-117.26713, 33.00294], [-117.26724, 33.00291], [-117.2673, 33.00286], [-117.2678, 33.00198], [-117.26806, 33.00198], [-117.26818, 33.00279], [-117.26812, 33.00299], [-117.26835, 33.00318], [-117.26842, 33.0035], [-117.2686, 33.00363], [-117.26861, 33.00391], [-117.27039, 33.00393], [-117.2704, 33.00381], [-117.27061, 33.00383], [-117.27072, 33.00382], [-117.27089, 33.00376], [-117.27131, 33.00356], [-117.27158, 33.00354], [-117.27197, 33.00355], [-117.2721, 33.00359], [-117.27221, 33.0036], [-117.27223, 33.00361], [-117.2724, 33.00364], [-117.27248, 33.0037], [-117.27258, 33.0037], [-117.27269, 33.00406], [-117.27274, 33.00414], [-117.27287, 33.00423], [-117.27291, 33.00739]], [[-117.26716, 33.00301], [-117.26673, 33.00297], [-117.26688, 33.0036], [-117.26733, 33.00348], [-117.26726, 33.00297], [-117.26716, 33.00301]]], [[[-117.25116, 33.00742], [-117.25114, 33.00903], [-117.25115, 33.01098], [-117.24055, 33.01098], [-117.23939, 33.00941], [-117.2428, 33.00937], [-117.2428, 33.0092], [-117.24294, 33.00923], [-117.24295, 33.00922], [-117.24295, 33.00892], [-117.2428, 33.00883], [-117.24281, 33.00747], [-117.24445, 33.00745], [-117.24444, 33.00563], [-117.24552, 33.00564], [-117.24553, 33.00744], [-117.25116, 33.00742]]], [[[-117.27505, 33.0139], [-117.275, 33.01393], [-117.27475, 33.01377], [-117.27434, 33.01359], [-117.27395, 33.01348], [-117.27374, 33.01345], [-117.27352, 33.01343], [-117.27351, 33.01315], [-117.27319, 33.01314], [-117.27309, 33.01322], [-117.27307, 33.01326], [-117.27304, 33.01336], [-117.27305, 33.01344], [-117.27284, 33.01347], [-117.27256, 33.01347], [-117.27231, 33.01344], [-117.272, 33.01337], [-117.27171, 33.01326], [-117.27134, 33.01306], [-117.27104, 33.01279], [-117.27096, 33.01269], [-117.27083, 33.01249], [-117.27404, 33.01107], [-117.27469, 33.01223], [-117.27472, 33.01331], [-117.27505, 33.0139]]], [[[-117.25907, 33.01465], [-117.25889, 33.01488], [-117.25873, 33.01505], [-117.25836, 33.01536], [-117.25815, 33.0155], [-117.25784, 33.01568], [-117.25757, 33.0158], [-117.25711, 33.01597], [-117.25673, 33.01617], [-117.25651, 33.01633], [-117.25568, 33.01708], [-117.25569, 33.01468], [-117.25907, 33.01465]]], [[[-117.24895, 33.02066], [-117.24723, 33.0218], [-117.24698, 33.0218], [-117.24696, 33.02001], [-117.24894, 33.02002], [-117.24895, 33.02066]]]]} | Restricted Access 2 | 1714 | San Elijo Lagoon Ecological Reserve | 24877 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/San-Elijo-Lagoon-ER | San Diego 4 | 268.615 | San Elijo Lagoon ER | 1983 | State Conservation Area 8 | 2 |
4152 | 4152 | 4151 | {"type": "Polygon", "coordinates": [[[-117.97658, 33.91104], [-117.97658, 33.91143], [-117.97591, 33.91182], [-117.97546, 33.91214], [-117.96943, 33.91722], [-117.96887, 33.91721], [-117.97303, 33.91372], [-117.97303, 33.9137], [-117.97384, 33.91309], [-117.9751, 33.91199], [-117.97561, 33.91162], [-117.97658, 33.91104]]]} | Open Access 1 | 48288 | Coyote Creek Bikeway | 32861 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | http://www.lhcm.org/386/Bikeways | Orange 3 | 8.381 | Coyote Creek Bikeway | 2011 | None 358 | |
14544 | 14544 | 14543 | {"type": "Polygon", "coordinates": [[[-117.97916, 33.9094], [-117.97859, 33.91001], [-117.97804, 33.91048], [-117.9775, 33.91087], [-117.97658, 33.91143], [-117.97658, 33.91103], [-117.97694, 33.91084], [-117.97741, 33.91054], [-117.97784, 33.91022], [-117.97802, 33.91008], [-117.97805, 33.91001], [-117.97841, 33.90968], [-117.9788, 33.90926], [-117.97904, 33.90937], [-117.97916, 33.9094]]]} | Open Access 1 | 48309 | Coyote Creek Bikeway | 32861 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | http://www.lhcm.org/386/Bikeways | Los Angeles 6 | 2.63 | Coyote Creek Bikeway | 2011 | None 1239 | |
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 |
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]);