units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
14,510 rows where ACCESS_TYP = 1 sorted by AGNCY_WEB
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 30
- City Agency 9,920
- County Agency 1,098
- Recreation/Parks District 990
- State Agency 826
- Federal Agency 397
- Open Space District 247
- County Agency - Parks 206
- Non Profit - Land Trust 205
- Community Services District 194
- Water District 113
- Non Profit - Conservation 55
- Cemetery District 50
- Flood District 40
- Non Profit - Other 35
- Port/Harbor District 33
- County Agency - Other 20
- Irrigation District 17
- Special District - Other 15
- Sanitation District 6
- Commercial 5
- Non Profit - Cemetery District 5
- Joint Powers Authority 2
- Other 2
- Conservation District 2
- Non Profit - Education 2
- Airport District 1
- Metropolitan Planning Organization 1
- Utility 1
- Fire District 1
- Transportation Agency 1
MNG_AGENCY >30
- San Diego, City of 503
- Los Angeles, City of 432
- California Department of Parks and Recreation 354
- California Department of Fish and Wildlife 293
- San Jose, City of 247
- San Francisco, City and County of 238
- Sacramento, City of 216
- Mountains Recreation and Conservation Authority 191
- Los Angeles, County of 153
- Ventura, City of 149
- Long Beach, City of 135
- Roseville, City of 123
- Oakland, City of 122
- United States Forest Service 109
- United States Bureau of Land Management 105
- Santa Barbara, County of 105
- San Diego, County of 105
- East Bay Regional Park District 101
- Irvine, City of 100
- Consumnes Community Services District 94
- Fresno, City of 92
- Orange, County of 88
- United States National Park Service 80
- Modesto, City of 78
- Hayward Area Recreation and Park District 77
- Stockton, City of 77
- Huntington Beach, City of 76
- California State Lands Commission 75
- Tracy, City of 73
- Santa Rosa, City of 72
- …
DES_TP >30
- Local Park 9,077
- Local Recreation Area 1,639
- Local Other or Unknown 859
- Local Conservation Area 350
- State Conservation Area 250
- Private Conservation 212
- State Park 199
- State Recreation Area 140
- Local Historic or Cultural Area 102
- National Forest 99
- State Resource Management Area 81
- National Public Lands 64
- State Historic or Cultural Area 59
- Recreation Management Area 50
- Private Recreation or Education 48
- National Recreation Area 38
- National Monument or Landmark 33
- State Other or Unknown 32
- National Wildlife Refuge 25
- National Park 22
- Resource Management Area 20
- Federal Other or Unknown 14
- Local Resource Management Area 11
- Private Other or Unknown 9
- Conservation Area 6
- Wilderness Area 6
- Area of Critical Environmental Concern 6
- Historic or Cultural Area 5
- Private Historic or Cultural 4
- Private Agricultural 3
- …
ACCESS_TYP 1
- Open Access · 14,490 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
616 | 616 | 615 | {"type": "Polygon", "coordinates": [[[-119.3355, 36.20739], [-119.33118, 36.20737], [-119.33122, 36.2057], [-119.33122, 36.20386], [-119.33545, 36.20385], [-119.3355, 36.20739]]]} | Open Access 1 | 964 | Tulare Cemetery | 26563 | 2167 | Tulare Cemetery District 223 | Special District 4 | Cemetery District 11 | Special District 4 | 2167 | Tulare Cemetery District 219 | Special District 4 | Cemetery District 11 | Tulare 29 | 37.023 | Tulare Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
749 | 749 | 748 | {"type": "Polygon", "coordinates": [[[-119.62108, 36.558], [-119.62104, 36.55974], [-119.62088, 36.55974], [-119.62087, 36.55979], [-119.61988, 36.55979], [-119.61991, 36.558], [-119.62036, 36.55799], [-119.62108, 36.558]]]} | Open Access 1 | 4873 | West Selma Cemetery | 27375 | 2148 | Selma Cemetery District 251 | Special District 4 | Cemetery District 11 | Special District 4 | 2148 | Selma Cemetery District 247 | Special District 4 | Cemetery District 11 | Fresno 9 | 5.109 | West Selma Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
818 | 818 | 817 | {"type": "Polygon", "coordinates": [[[-117.1878, 34.44347], [-117.18605, 34.44348], [-117.18605, 34.44269], [-117.18779, 34.44268], [-117.1878, 34.44347]]]} | Open Access 1 | 5287 | Mendel Park | 22148 | 2200 | Apple Valley Recreation and Park District 267 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2200 | Apple Valley Recreation and Park District 262 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 3.478 | Mendel Park | 0 | Local Park 2 | 4 | ||
910 | 910 | 909 | {"type": "Polygon", "coordinates": [[[-117.21458, 34.53082], [-117.21419, 34.53082], [-117.21418, 34.53128], [-117.21261, 34.53128], [-117.2126, 34.53013], [-117.21265, 34.53009], [-117.21457, 34.53009], [-117.21458, 34.53082]]]} | Open Access 1 | 5810 | Thunderbird Park | 26338 | 2200 | Apple Valley Recreation and Park District 267 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2200 | Apple Valley Recreation and Park District 262 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 5.461 | Thunderbird Park | 0 | Local Park 2 | 4 | ||
994 | 994 | 993 | {"type": "Polygon", "coordinates": [[[-118.25629, 33.79377], [-118.25421, 33.79388], [-118.2541, 33.79231], [-118.25461, 33.79228], [-118.25462, 33.79225], [-118.25616, 33.79216], [-118.25616, 33.79219], [-118.25618, 33.79219], [-118.25629, 33.79377]]]} | Open Access 1 | 6195 | Wilmington Cemetery | 27598 | 2182 | Wilmington Public Cemetery District 302 | Special District 4 | Cemetery District 11 | Special District 4 | 2182 | Wilmington Public Cemetery District 298 | Special District 4 | Cemetery District 11 | Los Angeles 6 | 8.461 | Wilmington Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
1165 | 1165 | 1164 | {"type": "Polygon", "coordinates": [[[-116.90615, 32.72851], [-116.90484, 32.7283], [-116.90399, 32.72803], [-116.90394, 32.72518], [-116.90608, 32.72533], [-116.90615, 32.72851]]]} | Open Access 1 | 7381 | San Diego National Wildlife Refuge | 24858 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | San Diego 4 | 16.779 | San Diego NWR | 1996 | National Wildlife Refuge 105 | 2 | ||
1200 | 1200 | 1199 | {"type": "MultiPolygon", "coordinates": [[[[-117.90541, 34.1585], [-117.90453, 34.15837], [-117.90437, 34.15839], [-117.90421, 34.15845], [-117.904, 34.15843], [-117.90408, 34.15835], [-117.90423, 34.15828], [-117.9044, 34.15824], [-117.90456, 34.15824], [-117.9054, 34.15837], [-117.90541, 34.1585]]], [[[-117.90754, 34.15868], [-117.90754, 34.15881], [-117.90649, 34.15867], [-117.90649, 34.15852], [-117.90754, 34.15868]]], [[[-117.90401, 34.15871], [-117.90397, 34.15877], [-117.90371, 34.15961], [-117.9033, 34.15961], [-117.90163, 34.16004], [-117.89984, 34.1611], [-117.89886, 34.16208], [-117.89885, 34.16256], [-117.89881, 34.16256], [-117.89882, 34.16212], [-117.89861, 34.16211], [-117.89973, 34.16101], [-117.90022, 34.1607], [-117.89901, 34.16124], [-117.89884, 34.16139], [-117.8987, 34.16156], [-117.89728, 34.16357], [-117.89714, 34.16374], [-117.89686, 34.164], [-117.89655, 34.1642], [-117.89633, 34.16431], [-117.89605, 34.16441], [-117.89461, 34.1647], [-117.89323, 34.16486], [-117.89298, 34.16493], [-117.89253, 34.16513], [-117.89224, 34.16513], [-117.89224, 34.1651], [-117.89289, 34.16481], [-117.89305, 34.16475], [-117.89459, 34.16456], [-117.89597, 34.16429], [-117.89617, 34.16423], [-117.8964, 34.16412], [-117.89668, 34.16396], [-117.89684, 34.16383], [-117.89705, 34.16361], [-117.89856, 34.16149], [-117.89868, 34.16134], [-117.8989, 34.16114], [-117.90321, 34.15912], [-117.90322, 34.1591], [-117.90317, 34.15875], [-117.90362, 34.1587], [-117.90401, 34.15871]], [[-117.90325, 34.15927], [-117.90321, 34.15927], [-117.90307, 34.15933], [-117.90229, 34.15971], [-117.90327, 34.15948], [-117.90325, 34.15927]]]]} | Open Access 1 | 6939 | San Gabriel River | 24896 | 2137 | San Gabriel River Water Committee 332 | Special District 4 | Water District 13 | Special District 4 | 2137 | San Gabriel River Water Committee 329 | Special District 4 | Water District 13 | Los Angeles 6 | 8.661 | San Gabriel River | 0 | None 106 | |||
1281 | 1281 | 1280 | {"type": "Polygon", "coordinates": [[[-117.5581, 34.18262], [-117.55072, 34.18265], [-117.5507, 34.17938], [-117.55806, 34.1794], [-117.5581, 34.18262]]]} | Open Access 1 | 9910 | Richland Mitigation | 24337 | 3089 | The Habitat Trust 340 | Non Profit 6 | Non Profit - Land Trust 10 | Non Governmental Organization 10 | 3089 | The Habitat Trust 337 | Non Profit 6 | Non Profit - Land Trust 10 | San Bernardino 22 | 60.516 | Richland Mitigation | 0 | Private Conservation 16 | 2 | ||
1307 | 1307 | 1306 | {"type": "MultiPolygon", "coordinates": [[[[-118.63657, 34.26504], [-118.63633, 34.26516], [-118.63617, 34.26526], [-118.63601, 34.2654], [-118.63587, 34.26558], [-118.6358, 34.26572], [-118.63574, 34.26588], [-118.63571, 34.26605], [-118.63569, 34.26628], [-118.63564, 34.26647], [-118.63554, 34.26667], [-118.63539, 34.26684], [-118.63447, 34.26759], [-118.63418, 34.26779], [-118.63386, 34.26798], [-118.63327, 34.26823], [-118.63273, 34.2646], [-118.63657, 34.26504]]], [[[-118.63485, 34.26765], [-118.63449, 34.26821], [-118.63372, 34.26845], [-118.63334, 34.26871], [-118.63329, 34.2684], [-118.6338, 34.26819], [-118.63416, 34.26801], [-118.63449, 34.2678], [-118.63477, 34.26758], [-118.63485, 34.26765]]], [[[-118.65762, 34.27232], [-118.65772, 34.2726], [-118.65771, 34.27281], [-118.65769, 34.27297], [-118.65755, 34.27344], [-118.65753, 34.27346], [-118.65749, 34.27338], [-118.65642, 34.27257], [-118.65573, 34.27221], [-118.6555, 34.27195], [-118.65574, 34.27169], [-118.65574, 34.27168], [-118.65499, 34.27151], [-118.65408, 34.27081], [-118.65349, 34.27065], [-118.65242, 34.27019], [-118.65185, 34.27015], [-118.65094, 34.26998], [-118.65002, 34.26966], [-118.65006, 34.26918], [-118.64922, 34.26888], [-118.64886, 34.26879], [-118.64705, 34.26807], [-118.64679, 34.26814], [-118.64604, 34.26809], [-118.6458, 34.26796], [-118.64547, 34.26785], [-118.64495, 34.26758], [-118.64462, 34.26755], [-118.64414, 34.26724], [-118.64391, 34.26694], [-118.64358, 34.26675], [-118.64244, 34.26649], [-118.64221, 34.26578], [-118.64205, 34.2657], [-118.64022, 34.26616], [-118.63857, 34.266], [-118.63825, 34.26619], [-118.63802, 34.26604], [-118.63773, 34.26595], [-118.63661, 34.26612], [-118.63614, 34.26631], [-118.6356, 34.26704], [-118.6354, 34.2672], [-118.63532, 34.26713], [-118.6356, 34.26688], [-118.6357, 34.26676], [-118.63579, 34.26662], [-118.63588, 34.26636], [-118.63591, 34.26604], [-118.63594, 34.26588], [-118.636, 34.26574], [-118.63609, 34.2656], [-118.63624, 34.26544], [-118.63642, 34.2653], [-118.63663, 34.2652], [-118.63687, 34.26513], [-118.63725, 34.26529], [-118.63763, 34.2653], [-118.63817, 34.26541], [-118.6387, 34.26529], [-118.64734, 34.26629], [-118.64784, 34.26632], [-118.6482, 34.2663], [-118.64863, 34.26625], [-118.64905, 34.26617], [-118.64946, 34.26604], [-118.64985, 34.26589], [-118.65022, 34.26569], [-118.65061, 34.26543], [-118.65172, 34.26447], [-118.65208, 34.26407], [-118.65307, 34.2632], [-118.65352, 34.26283], [-118.65404, 34.26249], [-118.65458, 34.26292], [-118.65468, 34.26296], [-118.65481, 34.26299], [-118.65467, 34.26301], [-118.65448, 34.26298], [-118.6544, 34.26301], [-118.65435, 34.26305], [-118.65433, 34.2631], [-118.65433, 34.26316], [-118.65435, 34.2632], [-118.65288, 34.26389], [-118.65201, 34.26446], [-118.65231, 34.26447], [-118.65299, 34.26403], [-118.65496, 34.2631], [-118.65568, 34.26311], [-118.6557, 34.26352], [-118.65602, 34.26352], [-118.65602, 34.26311], [-118.65619, 34.26311], [-118.65614, 34.26652], [-118.6561, 34.2667], [-118.65643, 34.26684], [-118.65636, 34.26695], [-118.65626, 34.2677], [-118.65595, 34.26773], [-118.65595, 34.26945], [-118.6562, 34.26962], [-118.65629, 34.26981], [-118.65688, 34.27019], [-118.65701, 34.27046], [-118.65718, 34.27077], [-118.65734, 34.27095], [-118.6567, 34.2711], [-118.65679, 34.2714], [-118.65666, 34.27168], [-118.65762, 34.27232]]]]} | Open Access 1 | 10485 | Corriganville Park | 8979 | 2117 | Rancho Simi Open Space Conservation Agency 345 | Special District 4 | Open Space District 6 | Special District 4 | 2117 | Rancho Simi Open Space Conservation Agency 342 | Special District 4 | Open Space District 6 | http://www.rsrpd.org/park/corrignavilleparkandtrail/corrignavilleparkandtrail.html | Ventura 8 | 178.572 | Corriganville Park | 0 | Local Park 2 | 4 | |
1643 | 1643 | 1642 | {"type": "Polygon", "coordinates": [[[-119.68461, 36.60967], [-119.68459, 36.61269], [-119.68239, 36.61268], [-119.68238, 36.60964], [-119.68461, 36.60967]]]} | Open Access 1 | 14108 | Fowler Cemetery | 19028 | 2035 | Fowler Cemetery District 400 | Special District 4 | Cemetery District 11 | Special District 4 | 2035 | Fowler Cemetery District 394 | Special District 4 | Cemetery District 11 | Fresno 9 | 16.466 | Fowler Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
1942 | 1942 | 1941 | {"type": "Polygon", "coordinates": [[[-121.43074, 36.49462], [-121.42983, 36.49537], [-121.42837, 36.49418], [-121.4298, 36.49384], [-121.43074, 36.49462]]]} | Open Access 1 | 16639 | Gonzales Cemetery | 19393 | 2038 | Gonzales Cemetery District 457 | Special District 4 | Cemetery District 11 | Special District 4 | 2038 | Gonzales Cemetery District 451 | Special District 4 | Cemetery District 11 | Monterey 14 | 4.437 | Gonzales Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
2049 | 2049 | 2048 | {"type": "Polygon", "coordinates": [[[-121.13879, 36.20777], [-121.1387, 36.20806], [-121.13875, 36.20846], [-121.13866, 36.20877], [-121.13851, 36.20885], [-121.13608, 36.2066], [-121.13769, 36.20538], [-121.13782, 36.20538], [-121.1382, 36.20563], [-121.13821, 36.20604], [-121.1385, 36.2066], [-121.13853, 36.2066], [-121.13879, 36.20777]]]} | Open Access 1 | 17107 | King City Cemetery | 20649 | 2052 | King City Cemetery District 471 | Special District 4 | Cemetery District 11 | Special District 4 | 2052 | King City Cemetery District 464 | Special District 4 | Cemetery District 11 | Monterey 14 | 11.815 | King City Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
2104 | 2104 | 2103 | {"type": "Polygon", "coordinates": [[[-120.57389, 34.97384], [-120.57321, 34.97483], [-120.57204, 34.97432], [-120.57273, 34.97333], [-120.57389, 34.97384]]]} | Open Access 1 | 17330 | Leroy Park | 21178 | 1126 | Guadalupe, City of 480 | City 2 | City Agency 2 | City 2 | 1126 | Guadalupe, City of 472 | City 2 | City Agency 2 | Santa Barbara 7 | 3.784 | Leroy Park | 0 | Local Park 2 | 4 | ||
2266 | 2266 | 2265 | {"type": "Polygon", "coordinates": [[[-121.88959, 36.95741], [-121.88855, 36.95826], [-121.88843, 36.95817], [-121.88948, 36.95731], [-121.88959, 36.95741]]]} | Open Access 1 | 16858 | Hidden Beach | 19901 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Santa Cruz 5 | 0.488 | Hidden Beach | None 188 | ||||
2317 | 2317 | 2316 | {"type": "Polygon", "coordinates": [[[-120.59124, 34.95777], [-120.59116, 34.96061], [-120.58835, 34.96058], [-120.58837, 34.96035], [-120.58852, 34.95999], [-120.58868, 34.9598], [-120.58886, 34.95964], [-120.5892, 34.95938], [-120.58939, 34.95916], [-120.58958, 34.95879], [-120.58962, 34.9586], [-120.58965, 34.95785], [-120.58967, 34.9578], [-120.58974, 34.95777], [-120.59124, 34.95777]]]} | Open Access 1 | 16995 | Jack O'Conell Park | 20306 | 1126 | Guadalupe, City of 480 | City 2 | City Agency 2 | City 2 | 1126 | Guadalupe, City of 472 | City 2 | City Agency 2 | Santa Barbara 7 | 14.461 | Jack O'Conell Park | 0 | Local Park 2 | 4 | ||
2325 | 2325 | 2324 | {"type": "Polygon", "coordinates": [[[-119.54766, 36.62225], [-119.54431, 36.61985], [-119.54358, 36.61933], [-119.54757, 36.61933], [-119.54756, 36.61965], [-119.54766, 36.62225]]]} | Open Access 1 | 18386 | Parlier Cemetery | 23465 | 2109 | Parlier Cemetery District 512 | Special District 4 | Cemetery District 11 | Special District 4 | 2109 | Parlier Cemetery District 505 | Special District 4 | Cemetery District 11 | Fresno 9 | 14.213 | Parlier Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
2364 | 2364 | 2363 | {"type": "Polygon", "coordinates": [[[-119.56142, 36.50347], [-119.56141, 36.5051], [-119.55689, 36.50507], [-119.55687, 36.50343], [-119.56142, 36.50347]]]} | Open Access 1 | 17153 | Kingsburg Cemetery | 20667 | 2053 | Kingsburg Cemetery District 518 | Special District 4 | Cemetery District 11 | Special District 4 | 2053 | Kingsburg Cemetery District 511 | Special District 4 | Cemetery District 11 | Fresno 9 | 18.234 | Kingsburg Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
2460 | 2460 | 2459 | {"type": "Polygon", "coordinates": [[[-120.45154, 34.63089], [-120.45154, 34.63099], [-120.44878, 34.63096], [-120.44841, 34.63085], [-120.44601, 34.63083], [-120.446, 34.63074], [-120.44531, 34.63074], [-120.4453, 34.63071], [-120.44519, 34.63071], [-120.44522, 34.63014], [-120.44594, 34.62906], [-120.44681, 34.62907], [-120.44682, 34.62893], [-120.44884, 34.62894], [-120.44887, 34.62739], [-120.44917, 34.6274], [-120.44916, 34.62827], [-120.44944, 34.62828], [-120.4503, 34.62929], [-120.45069, 34.63019], [-120.45128, 34.63077], [-120.45154, 34.63089]]]} | Open Access 1 | 17397 | Lompoc Cemetery - Lompoc Cemetery District | 21419 | 2063 | Lompoc Cemetery District 526 | Special District 4 | Cemetery District 11 | Special District 4 | 2063 | Lompoc Cemetery District 518 | Special District 4 | Cemetery District 11 | Santa Barbara 7 | 27.221 | Lompoc Cemetery - Lompoc Cemetery District | 0 | Local Historic or Cultural Area 19 | 4 | ||
2506 | 2506 | 2505 | {"type": "Polygon", "coordinates": [[[-117.3015, 33.61798], [-117.3012, 33.61831], [-117.29877, 33.61679], [-117.29902, 33.61646], [-117.3015, 33.61798]]]} | Open Access 1 | 48910 | Regency-Heritage Park | 33631 | 2437 | Ortega Trail Recreation and Park District 529 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 1706 | Wildomar, City of 522 | City 2 | City Agency 2 | http://www.cityofwildomar.org/community/parks_trails/parks/regency-heritage_park | Riverside 10 | 3.114 | Regency-Heritage Park | 0 | Local Park 2 | 4 | |
2591 | 2591 | 2590 | {"type": "MultiPolygon", "coordinates": [[[[-121.89718, 36.61024], [-121.89709, 36.61029], [-121.89629, 36.60934], [-121.8964, 36.60932], [-121.89718, 36.61024]]], [[[-121.89804, 36.61126], [-121.89796, 36.61131], [-121.89719, 36.6104], [-121.89727, 36.61035], [-121.89804, 36.61126]]], [[[-121.89857, 36.61213], [-121.89845, 36.6122], [-121.89841, 36.61202], [-121.89831, 36.61179], [-121.89821, 36.61162], [-121.89805, 36.61143], [-121.89816, 36.61137], [-121.89831, 36.61155], [-121.89846, 36.6118], [-121.89852, 36.61194], [-121.89857, 36.61213]]], [[[-121.89976, 36.61454], [-121.8996, 36.61463], [-121.89874, 36.61359], [-121.89862, 36.61339], [-121.89853, 36.61314], [-121.8985, 36.61297], [-121.89847, 36.61266], [-121.89862, 36.61283], [-121.89864, 36.61302], [-121.89868, 36.61318], [-121.89875, 36.61336], [-121.89886, 36.61355], [-121.89942, 36.61422], [-121.89947, 36.6142], [-121.89976, 36.61454]]], [[[-121.90075, 36.61569], [-121.90057, 36.61579], [-121.89971, 36.61477], [-121.89987, 36.61468], [-121.90006, 36.61489], [-121.90008, 36.61489], [-121.90075, 36.61569]]], [[[-121.90167, 36.61684], [-121.90153, 36.61692], [-121.90067, 36.6159], [-121.9008, 36.61582], [-121.90167, 36.61684]]], [[[-121.90242, 36.6177], [-121.90225, 36.61776], [-121.90163, 36.61703], [-121.90177, 36.61695], [-121.90242, 36.6177]]], [[[-121.90324, 36.61833], [-121.90322, 36.61834], [-121.90314, 36.61831], [-121.903, 36.61821], [-121.90291, 36.61811], [-121.90302, 36.61806], [-121.90324, 36.61833]]]]} | Open Access 1 | 17932 | Monterey Bay Coastal Trail | 22417 | 2084 | Monterey Peninsula Recreational Trail Joint Powers 537 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2084 | Monterey Peninsula Recreational Trail Joint Powers 530 | Special District 4 | Recreation/Parks District 4 | Monterey 14 | 3.184 | Monterey Bay Coastal Trail | 0 | Local Recreation Area 3 | 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]);