units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
48 rows where ACCESS_TYP = 1 and DES_TP = 65 sorted by AGNCY_WEB
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Los Angeles Neighborhood Land Trust 6
- Mountains Restoration Trust 4
- Arroyos and Foothills Conservancy 3
- Odd Fellows Sierra Recreation Association 3
- San Dieguito River Valley Land Conservancy 2
- Trinidad Coastal Land Trust 2
- Trust for Public Land 2
- Private Landowner 2
- John Muir Land Trust 1
- Back Country Land Trust 1
- Land Trust for Santa Barbara County 1
- Solano Land Trust 1
- Sierra Historic Sites Association 1
- San Francisco Parks Alliance 1
- Del Monte Forest Foundation 1
- American River Conservancy 1
- National Audubon Society 1
- Tri-Valley Conservancy 1
- The Collaborative Eagle Rock Beautiful 1
- Pinnacle International Development, Inc 1
- Serra Cross Conservancy 1
- Westport Village Society 1
- Heal the Bay 1
- Mare Island Historic Park Foundation 1
- San Diego Humane Society and SPCA 1
- San Diego Gas and Electric 1
- Roosevelt Memorial Park Association 1
- Foundation for Preservation of Mt. Helix Nature Theatre 1
- Palo Cerdo Community Park Association 1
- California Institute of Technology 1
- …
MNG_AG_TYP 8
DES_TP 1
- Private Recreation or Education · 48 ✖
ACCESS_TYP 1
- Open Access · 48 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14017 | 14017 | 14016 | {"type": "Polygon", "coordinates": [[[-118.47347, 34.03122], [-118.47281, 34.03175], [-118.47275, 34.03178], [-118.47267, 34.03175], [-118.47203, 34.03124], [-118.47296, 34.03049], [-118.4734, 34.03086], [-118.47336, 34.03089], [-118.47335, 34.03112], [-118.47347, 34.03122]]]} | Open Access 1 | 46587 | Colorado Center Park | 29890 | 6103 | Private Landowner 584 | Private 7 | Other 25 | Private 14 | 6103 | Private Landowner 774 | Private 7 | Other 26 | Los Angeles 6 | 2.516 | Colorado Ctr. Park | 0 | Private Recreation or Education 65 | 4 | ||
14630 | 14630 | 14629 | {"type": "Polygon", "coordinates": [[[-122.25647, 37.85554], [-122.25626, 37.85557], [-122.25622, 37.85524], [-122.25641, 37.85523], [-122.25647, 37.85554]]]} | Open Access 1 | 47647 | Bateman Park | 31391 | 6103 | Private Landowner 584 | Private 7 | Other 25 | Private 14 | 6103 | Private Landowner 774 | Private 7 | Other 26 | Alameda 17 | 0.16 | Bateman Park | 0 | Private Recreation or Education 65 | 4 | ||
7599 | 7599 | 7598 | {"type": "Polygon", "coordinates": [[[-117.35825, 33.16477], [-117.35811, 33.16484], [-117.35793, 33.16488], [-117.35776, 33.16502], [-117.35773, 33.16507], [-117.35761, 33.1652], [-117.35715, 33.1652], [-117.35715, 33.16625], [-117.35629, 33.16543], [-117.35617, 33.16533], [-117.35607, 33.16521], [-117.35598, 33.1652], [-117.35586, 33.16509], [-117.35548, 33.16483], [-117.35555, 33.16478], [-117.3555, 33.16464], [-117.35547, 33.16431], [-117.35558, 33.16437], [-117.35557, 33.16441], [-117.35563, 33.16466], [-117.35569, 33.16472], [-117.35576, 33.16486], [-117.35757, 33.16474], [-117.3576, 33.16476], [-117.35792, 33.16464], [-117.35803, 33.16453], [-117.35825, 33.16477]]]} | Open Access 1 | 7307 | Buena Vista Lagoon and Nature Center | 16487 | 3046 | National Audubon Society 651 | Non Profit 6 | Non Profit - Conservation 12 | http://ca.audubon.org/ | Non Governmental Organization 10 | 3046 | National Audubon Society 640 | Non Profit 6 | Non Profit - Conservation 12 | http://bvaudubon.org/nature-center/ | San Diego 4 | 3.999 | Buena Vista Lagoon and Nature Ctr. | 0 | Private Recreation or Education 65 | 4 |
4024 | 4024 | 4023 | {"type": "Polygon", "coordinates": [[[-119.29637, 34.28467], [-119.29622, 34.28505], [-119.29605, 34.2852], [-119.29592, 34.28522], [-119.29579, 34.28522], [-119.29576, 34.28518], [-119.29569, 34.28521], [-119.29557, 34.28515], [-119.29543, 34.28497], [-119.29559, 34.28481], [-119.29613, 34.2845], [-119.29628, 34.28453], [-119.29637, 34.28467]]]} | Open Access 1 | 46895 | Serra Cross Park | 30394 | 3369 | San Buenaventura Heritage 711 | Non Profit 6 | Non Profit - Other 22 | http://dudleyhouse.org/ | Non Governmental Organization 10 | 3370 | Serra Cross Conservancy 696 | Non Profit 6 | Non Profit - Conservation 12 | Ventura 8 | 1.051 | Serra Cross Park | 0 | Private Recreation or Education 65 | 4 | |
5982 | 5982 | 5981 | {"type": "MultiPolygon", "coordinates": [[[[-120.15031, 38.07513], [-120.15021, 38.0767], [-120.15017, 38.0788], [-120.1503, 38.07975], [-120.15007, 38.08129], [-120.14928, 38.08265], [-120.14892, 38.08205], [-120.14846, 38.08111], [-120.14743, 38.08057], [-120.14611, 38.08037], [-120.14582, 38.08042], [-120.14567, 38.08036], [-120.14566, 38.08026], [-120.14575, 38.0801], [-120.14657, 38.07944], [-120.14735, 38.07842], [-120.14738, 38.0774], [-120.14754, 38.0764], [-120.14785, 38.07644], [-120.14808, 38.07548], [-120.14814, 38.075], [-120.14814, 38.07479], [-120.14821, 38.07416], [-120.14982, 38.07453], [-120.15031, 38.07513]]], [[[-120.15315, 38.08292], [-120.15299, 38.08306], [-120.15302, 38.08341], [-120.15262, 38.08363], [-120.15246, 38.0834], [-120.15153, 38.08386], [-120.1512, 38.08408], [-120.15116, 38.08418], [-120.15116, 38.08431], [-120.15123, 38.08441], [-120.15098, 38.08462], [-120.15073, 38.08492], [-120.15035, 38.08507], [-120.15003, 38.08485], [-120.15022, 38.08462], [-120.14991, 38.08444], [-120.14965, 38.08382], [-120.14963, 38.0837], [-120.14974, 38.08333], [-120.14974, 38.08285], [-120.14939, 38.08282], [-120.14945, 38.08274], [-120.15032, 38.08131], [-120.15055, 38.0798], [-120.15088, 38.08009], [-120.15087, 38.08057], [-120.15094, 38.08099], [-120.15096, 38.08105], [-120.15148, 38.08155], [-120.15173, 38.08183], [-120.15218, 38.08213], [-120.15241, 38.08263], [-120.15255, 38.08268], [-120.15281, 38.08281], [-120.15315, 38.08292]]]]} | Open Access 1 | 575 | Odd Fellows High Sierra Park | 23069 | 3050 | Odd Fellows Sierra Recreation Association 821 | Non Profit 6 | Non Profit - Other 22 | http://ofsraparkmgt.wix.com/home | Non Governmental Organization 10 | 3050 | Odd Fellows Sierra Recreation Association 799 | Non Profit 6 | Non Profit - Other 20 | Tuolumne 21 | 69.024 | Odd Fellows High Sierra Park | 0 | Private Recreation or Education 65 | 4 | |
12389 | 12389 | 12388 | {"type": "Polygon", "coordinates": [[[-120.68035, 38.19748], [-120.68032, 38.19764], [-120.68019, 38.19787], [-120.68018, 38.19785], [-120.67998, 38.1978], [-120.68001, 38.19774], [-120.67974, 38.19755], [-120.67987, 38.19743], [-120.6797, 38.19732], [-120.67974, 38.19727], [-120.67949, 38.1971], [-120.67965, 38.19699], [-120.67991, 38.19725], [-120.68002, 38.19734], [-120.68035, 38.19748]]]} | Open Access 1 | 26534 | Neilsen Park | 22689 | 3050 | Odd Fellows Sierra Recreation Association 821 | Non Profit 6 | Non Profit - Other 22 | http://ofsraparkmgt.wix.com/home | Non Governmental Organization 10 | 3050 | Odd Fellows Sierra Recreation Association 799 | Non Profit 6 | Non Profit - Other 20 | Calaveras 53 | 0.651 | Neilsen Park | 0 | Private Recreation or Education 65 | 4 | |
16450 | 16450 | 16449 | {"type": "Polygon", "coordinates": [[[-120.54486, 38.22673], [-120.54487, 38.22707], [-120.54477, 38.22764], [-120.54471, 38.22788], [-120.54459, 38.22809], [-120.54345, 38.22879], [-120.54334, 38.22869], [-120.5434, 38.22789], [-120.54309, 38.22772], [-120.54359, 38.22728], [-120.54486, 38.22673]]]} | Open Access 1 | 26533 | Mountain Ranch Community Park | 22546 | 3050 | Odd Fellows Sierra Recreation Association 821 | Non Profit 6 | Non Profit - Other 22 | http://ofsraparkmgt.wix.com/home | Non Governmental Organization 10 | 3050 | Odd Fellows Sierra Recreation Association 799 | Non Profit 6 | Non Profit - Other 20 | Calaveras 53 | 4.68 | Mtn. Ranch Community Park | 0 | Private Recreation or Education 65 | 4 | |
11496 | 11496 | 11495 | {"type": "Polygon", "coordinates": [[[-121.08536, 38.70069], [-121.0853, 38.70071], [-121.08483, 38.70132], [-121.08466, 38.7015], [-121.08379, 38.70283], [-121.08379, 38.70288], [-121.08377, 38.7029], [-121.08366, 38.70297], [-121.08362, 38.70298], [-121.08357, 38.70297], [-121.08354, 38.70298], [-121.08285, 38.70248], [-121.08283, 38.70233], [-121.08305, 38.70197], [-121.08363, 38.70054], [-121.0837, 38.70015], [-121.08377, 38.70014], [-121.08398, 38.70016], [-121.08437, 38.70024], [-121.08455, 38.70031], [-121.08536, 38.70069]]]} | Open Access 1 | 23334 | Wild Oaks Park | 30312 | 3003 | American River Conservancy 604 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.arconservancy.org/ | Non Governmental Organization 10 | 3003 | American River Conservancy 593 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.eldoradohillscsd.org/images/park_detail_popups/wild-oaks/index.html | El Dorado 34 | 8.397 | Wild Oaks Park | 0 | Private Recreation or Education 65 | 4 |
15232 | 15232 | 15231 | {"type": "Polygon", "coordinates": [[[-118.14873, 34.20755], [-118.14873, 34.20755], [-118.14745, 34.20754], [-118.14816, 34.20703], [-118.14871, 34.20655], [-118.14873, 34.20755]]]} | Open Access 1 | 46186 | Chaney Trail Open Space | 29490 | 3000 | Arroyos and Foothills Conservancy 375 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.arroyosfoothills.org/ | Non Governmental Organization 10 | 3000 | Arroyos and Foothills Conservancy 370 | Non Profit 6 | Non Profit - Land Trust 10 | Los Angeles 6 | 1.539 | Chaney Trail OS | 0 | Private Recreation or Education 65 | 4 | |
16202 | 16202 | 16201 | {"type": "Polygon", "coordinates": [[[-118.12246, 34.20342], [-118.12199, 34.20383], [-118.12181, 34.20394], [-118.12159, 34.20406], [-118.12133, 34.20415], [-118.12098, 34.20421], [-118.12096, 34.20413], [-118.12062, 34.20418], [-118.1205, 34.20422], [-118.12039, 34.20428], [-118.11999, 34.20456], [-118.11991, 34.20464], [-118.11985, 34.20472], [-118.11976, 34.2049], [-118.11975, 34.20495], [-118.11975, 34.20535], [-118.11971, 34.20545], [-118.11961, 34.20559], [-118.11777, 34.20453], [-118.11778, 34.20046], [-118.11887, 34.20046], [-118.11886, 34.19944], [-118.11983, 34.19943], [-118.11984, 34.19938], [-118.12033, 34.19937], [-118.12025, 34.19942], [-118.12025, 34.19943], [-118.12091, 34.19968], [-118.12158, 34.19968], [-118.1216, 34.19987], [-118.12137, 34.19987], [-118.12136, 34.19992], [-118.12123, 34.20005], [-118.12106, 34.20006], [-118.12106, 34.20047], [-118.12014, 34.20047], [-118.12013, 34.20176], [-118.1206, 34.20183], [-118.12138, 34.20261], [-118.12214, 34.20259], [-118.12221, 34.20322], [-118.12246, 34.20342]]]} | Open Access 1 | 46181 | Rubio Canyon Open Space | 29487 | 3000 | Arroyos and Foothills Conservancy 375 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.arroyosfoothills.org/ | Non Governmental Organization 10 | 3000 | Arroyos and Foothills Conservancy 370 | Non Profit 6 | Non Profit - Land Trust 10 | Los Angeles 6 | 42.645 | Rubio Canyon OS | 0 | Private Recreation or Education 65 | 4 | |
16207 | 16207 | 16206 | {"type": "Polygon", "coordinates": [[[-118.16315, 34.21033], [-118.16181, 34.21207], [-118.16127, 34.2127], [-118.16129, 34.21319], [-118.16097, 34.21354], [-118.16082, 34.21341], [-118.16075, 34.21375], [-118.16061, 34.21387], [-118.16041, 34.21379], [-118.16033, 34.21393], [-118.16036, 34.21397], [-118.16043, 34.21401], [-118.15982, 34.21427], [-118.15969, 34.21437], [-118.15945, 34.2147], [-118.15914, 34.21455], [-118.15889, 34.21474], [-118.15844, 34.21497], [-118.15739, 34.21492], [-118.1604, 34.21271], [-118.16131, 34.21155], [-118.16185, 34.21158], [-118.16183, 34.21032], [-118.16315, 34.21033]]]} | Open Access 1 | 46184 | Millard Canyon Open Space | 29489 | 3000 | Arroyos and Foothills Conservancy 375 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.arroyosfoothills.org/ | Non Governmental Organization 10 | 3000 | Arroyos and Foothills Conservancy 370 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.arroyosfoothills.org/millard/ | Los Angeles 6 | 13.581 | Millard Canyon OS | 0 | Private Recreation or Education 65 | 4 |
9295 | 9295 | 9294 | {"type": "MultiPolygon", "coordinates": [[[[-116.76305, 32.81484], [-116.76098, 32.81517], [-116.76081, 32.816], [-116.76163, 32.81736], [-116.75943, 32.8183], [-116.75928, 32.81555], [-116.75915, 32.81554], [-116.75928, 32.81413], [-116.76033, 32.81398], [-116.76305, 32.81484]]], [[[-116.76499, 32.81594], [-116.76499, 32.81594], [-116.76252, 32.81698], [-116.76247, 32.81632], [-116.76306, 32.8158], [-116.76331, 32.8148], [-116.76497, 32.81453], [-116.76497, 32.81518], [-116.76499, 32.81594]]], [[[-116.77229, 32.82298], [-116.77205, 32.83021], [-116.76845, 32.83018], [-116.76843, 32.8299], [-116.7678, 32.8299], [-116.7678, 32.83018], [-116.76362, 32.83016], [-116.76347, 32.82769], [-116.76577, 32.8277], [-116.76578, 32.82769], [-116.76276, 32.81729], [-116.76665, 32.81623], [-116.76675, 32.81623], [-116.7668, 32.81625], [-116.76686, 32.81632], [-116.76711, 32.81956], [-116.76748, 32.81956], [-116.76773, 32.82294], [-116.77229, 32.82298]]]]} | Open Access 1 | 15488 | Wright's Field | 399 | 3007 | Back Country Land Trust 152 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.bclt.org/ | Non Governmental Organization 10 | 3007 | Back Country Land Trust 148 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 231.124 | Wright's Field | 0 | Private Recreation or Education 65 | 4 | |
12116 | 12116 | 12115 | {"type": "Polygon", "coordinates": [[[-118.12784, 34.13519], [-118.12781, 34.13533], [-118.1278, 34.13577], [-118.12776, 34.13581], [-118.12451, 34.13581], [-118.12429, 34.13529], [-118.12521, 34.13501], [-118.12521, 34.13476], [-118.12477, 34.13488], [-118.1247, 34.13468], [-118.12461, 34.13465], [-118.12407, 34.13481], [-118.12406, 34.13478], [-118.12475, 34.13457], [-118.12476, 34.13456], [-118.12458, 34.13415], [-118.12453, 34.13412], [-118.12386, 34.13432], [-118.12384, 34.13426], [-118.12487, 34.13395], [-118.12482, 34.13381], [-118.12471, 34.13363], [-118.12471, 34.13354], [-118.1248, 34.13354], [-118.12482, 34.13311], [-118.12511, 34.13311], [-118.12516, 34.13297], [-118.12521, 34.13297], [-118.12524, 34.1328], [-118.1253, 34.13269], [-118.12541, 34.13258], [-118.12556, 34.13249], [-118.12567, 34.13245], [-118.12583, 34.13242], [-118.12783, 34.13242], [-118.12784, 34.13519]]]} | Open Access 1 | 25053 | Tournament Park | 29146 | 3362 | California Institute of Technology 1005 | Non Profit 6 | Non Profit - Education 34 | http://www.caltech.edu/ | Non Governmental Organization 10 | 3362 | California Institute of Technology 968 | Non Profit 6 | Non Profit - Education 32 | Los Angeles 6 | 25.881 | Tournament Park | 0 | Private Recreation or Education 65 | 4 | |
3845 | 3845 | 3844 | {"type": "Polygon", "coordinates": [[[-118.18362, 34.14471], [-118.18351, 34.1448], [-118.18343, 34.14491], [-118.18336, 34.1451], [-118.18336, 34.1453], [-118.1834, 34.14542], [-118.18348, 34.14554], [-118.18357, 34.14564], [-118.18353, 34.1458], [-118.18343, 34.14596], [-118.1821, 34.14546], [-118.18217, 34.14478], [-118.18267, 34.14401], [-118.18325, 34.14443], [-118.18319, 34.14449], [-118.18324, 34.14457], [-118.18336, 34.14452], [-118.18362, 34.14471]]]} | Open Access 1 | 46810 | Eagle Rock Canyon Trail | 30271 | 3367 | The Collaborative Eagle Rock Beautiful 692 | Non Profit 6 | Non Profit - Other 22 | http://www.cerb.us/ | Non Governmental Organization 10 | 3367 | The Collaborative Eagle Rock Beautiful 682 | Non Profit 6 | Non Profit - Other 20 | http://www.cerb.us/ | Los Angeles 6 | 4.567 | Eagle Rock Canyon Trail | 0 | Private Recreation or Education 65 | 4 |
2838 | 2838 | 2837 | {"type": "Polygon", "coordinates": [[[-121.93421, 36.60999], [-121.93184, 36.60975], [-121.932, 36.60951], [-121.93212, 36.60925], [-121.93222, 36.60897], [-121.93226, 36.6088], [-121.93229, 36.60854], [-121.93229, 36.60833], [-121.93227, 36.60812], [-121.93222, 36.60787], [-121.93214, 36.60765], [-121.93203, 36.60742], [-121.9319, 36.60721], [-121.93327, 36.60681], [-121.93327, 36.60718], [-121.9333, 36.60759], [-121.9334, 36.60812], [-121.9335, 36.60851], [-121.93372, 36.60916], [-121.93395, 36.60967], [-121.93405, 36.60983], [-121.93421, 36.60999]]]} | Open Access 1 | 65 | Rip Van Winkle Open Space | 24395 | 3016 | Del Monte Forest Foundation 559 | Non Profit 6 | Non Profit - Conservation 12 | http://www.delmonteforestfoundation.org/ | Non Governmental Organization 10 | 3016 | Del Monte Forest Foundation 552 | Non Profit 6 | Non Profit - Conservation 12 | Monterey 14 | 9.948 | Rip Van Winkle OS | 0 | Private Recreation or Education 65 | 4 | |
1961 | 1961 | 1960 | {"type": "Polygon", "coordinates": [[[-119.64038, 37.32984], [-119.64037, 37.33056], [-119.6394, 37.33019], [-119.63911, 37.33026], [-119.63852, 37.33009], [-119.63833, 37.32985], [-119.63942, 37.32983], [-119.64038, 37.32984]]]} | Open Access 1 | 16718 | Fresno Flats Historic Park | 19111 | 3078 | Sierra Historic Sites Association 462 | Non Profit 6 | Non Profit - Other 22 | http://www.fresnoflatsmuseum.org/ | Non Governmental Organization 10 | 3078 | Sierra Historic Sites Association 455 | Non Profit 6 | Non Profit - Other 20 | Madera 48 | 2.12 | Fresno Flats Historic Park | 0 | Private Recreation or Education 65 | 4 | |
4158 | 4158 | 4157 | {"type": "Polygon", "coordinates": [[[-118.26097, 33.95842], [-118.26096, 33.95916], [-118.26076, 33.95916], [-118.26076, 33.95842], [-118.26097, 33.95842]]]} | Open Access 1 | 45111 | WAYS Reading and Fitness Park | 28122 | 3352 | Heal the Bay 726 | Non Profit 6 | Non Profit - Other 22 | http://www.healthebay.org/ | Non Governmental Organization 10 | 3352 | Heal the Bay 711 | Non Profit 6 | Non Profit - Other 20 | Los Angeles 6 | 0.387 | WAYS Reading and Fitness Park | 0 | Private Recreation or Education 65 | 4 | |
16200 | 16200 | 16199 | {"type": "Polygon", "coordinates": [[[-122.0897, 37.9062], [-122.08967, 37.90933], [-122.08958, 37.90936], [-122.08957, 37.91025], [-122.08787, 37.91065], [-122.08733, 37.91063], [-122.08703, 37.90902], [-122.08705, 37.90838], [-122.08752, 37.90706], [-122.0882, 37.90623], [-122.0897, 37.9062]]]} | Open Access 1 | 29704 | Acalanes Ridge Open Space | 15246 | 3045 | John Muir Land Trust 108 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.jmlt.org/ | Non Governmental Organization 10 | 3045 | John Muir Land Trust 105 | Non Profit 6 | Non Profit - Land Trust 10 | Contra Costa 12 | 24.054 | Acalanes Ridge OS | 0 | Private Recreation or Education 65 | 4 | |
2962 | 2962 | 2961 | {"type": "Polygon", "coordinates": [[[-118.29523, 33.84631], [-118.29172, 33.84632], [-118.29173, 33.84625], [-118.2918, 33.84624], [-118.29178, 33.84558], [-118.29179, 33.84535], [-118.29492, 33.84531], [-118.29492, 33.84546], [-118.29489, 33.84556], [-118.29491, 33.84563], [-118.29498, 33.8457], [-118.29507, 33.84574], [-118.29523, 33.84572], [-118.29523, 33.84631]]]} | Open Access 1 | 48646 | Wishing Tree Park | 33392 | 3269 | Los Angeles Neighborhood Land Trust 564 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.lanlt.org/ | Non Governmental Organization 10 | 3269 | Los Angeles Neighborhood Land Trust 556 | Non Profit 6 | Non Profit - Land Trust 10 | https://www.lanlt.org/projectupdates | Los Angeles 6 | 8.29 | Wishing Tree Park | 2020 | Private Recreation or Education 65 | 4 |
2966 | 2966 | 2965 | {"type": "Polygon", "coordinates": [[[-118.28333, 34.05806], [-118.28325, 34.05818], [-118.28282, 34.05798], [-118.2829, 34.05786], [-118.28333, 34.05806]]]} | Open Access 1 | 48647 | Golden Age Park | 33393 | 3269 | Los Angeles Neighborhood Land Trust 564 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.lanlt.org/ | Non Governmental Organization 10 | 3269 | Los Angeles Neighborhood Land Trust 556 | Non Profit 6 | Non Profit - Land Trust 10 | https://www.lanlt.org/projectupdates | Los Angeles 6 | 0.172 | Golden Age Park | 2019 | Private Recreation or Education 65 | 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]);