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 PARK_URL descending
This data as json, copyable, CSV (advanced)
These facets timed out: DES_TP
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
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4230 | 4230 | 4229 | {"type": "Polygon", "coordinates": [[[-118.25946, 34.06588], [-118.25927, 34.06617], [-118.25885, 34.06598], [-118.25904, 34.06569], [-118.25946, 34.06588]]]} | Open Access 1 | 45071 | Patton Street Park | 28079 | 3094 | Trust for Public Land 734 | Non Profit 6 | Non Profit - Conservation 12 | http://www.tpl.org/ | Non Governmental Organization 10 | 3094 | Trust for Public Land 718 | Non Profit 6 | Non Profit - Conservation 12 | https://www.tpl.org/our-work/parks-for-people/patton-street-park | Los Angeles 6 | 0.4 | Patton Street Park | 0 | Private Recreation or Education 65 | 4 |
13918 | 13918 | 13917 | {"type": "Polygon", "coordinates": [[[-122.47779, 37.71752], [-122.47794, 37.71754], [-122.47824, 37.71766], [-122.47842, 37.71779], [-122.47855, 37.71794], [-122.47864, 37.71809], [-122.47866, 37.71822], [-122.47864, 37.7183], [-122.4786, 37.71838], [-122.47849, 37.71848], [-122.47836, 37.71855], [-122.47824, 37.71859], [-122.4781, 37.71859], [-122.47795, 37.71857], [-122.47777, 37.71849], [-122.47759, 37.71838], [-122.47748, 37.71829], [-122.47737, 37.71816], [-122.47731, 37.71806], [-122.47729, 37.71796], [-122.47729, 37.71787], [-122.47733, 37.71778], [-122.47742, 37.71767], [-122.47753, 37.71758], [-122.47763, 37.71754], [-122.47779, 37.71752]]]} | Open Access 1 | 48836 | Robert Pender Park | 33555 | 6134 | Parkmerced Owner LLC 1068 | Private 7 | Home Owners Association 16 | https://www.parkmerced.com/ | Private 14 | 3308 | San Francisco Parks Alliance 521 | Non Profit 6 | Non Profit - Other 20 | https://www.sfparksalliance.org/our-parks/parks/robert-pender-park | San Francisco 13 | 2.548 | Robert Pender Park | 0 | Private Recreation or Education 65 | 4 |
7613 | 7613 | 7612 | {"type": "MultiPolygon", "coordinates": [[[[-116.98432, 32.76701], [-116.98411, 32.76731], [-116.98404, 32.76739], [-116.98377, 32.76752], [-116.9836, 32.76758], [-116.98348, 32.76759], [-116.98317, 32.76758], [-116.98293, 32.76749], [-116.98281, 32.76741], [-116.98257, 32.76721], [-116.9825, 32.7671], [-116.9825, 32.76698], [-116.98252, 32.76694], [-116.98265, 32.76674], [-116.98268, 32.76671], [-116.9829, 32.76674], [-116.98319, 32.76662], [-116.98334, 32.7666], [-116.98362, 32.76663], [-116.98411, 32.76677], [-116.98423, 32.76685], [-116.98432, 32.76701]]], [[[-116.98313, 32.76651], [-116.98288, 32.76661], [-116.98266, 32.76658], [-116.98257, 32.76662], [-116.98253, 32.76666], [-116.98238, 32.76693], [-116.98236, 32.76703], [-116.98238, 32.76715], [-116.98245, 32.76726], [-116.98277, 32.76752], [-116.98302, 32.76765], [-116.98294, 32.76763], [-116.98228, 32.76735], [-116.98219, 32.76715], [-116.98236, 32.76689], [-116.98254, 32.76651], [-116.98266, 32.76646], [-116.98313, 32.76651]]], [[[-116.98413, 32.76749], [-116.98404, 32.76755], [-116.98385, 32.76773], [-116.98381, 32.76769], [-116.98369, 32.76768], [-116.98333, 32.76772], [-116.98326, 32.7677], [-116.9835, 32.7677], [-116.98373, 32.76766], [-116.98405, 32.76752], [-116.98412, 32.76747], [-116.98413, 32.76749]]], [[[-116.98087, 32.76954], [-116.98087, 32.76954], [-116.98049, 32.76998], [-116.9807, 32.7694], [-116.98087, 32.76954]]], [[[-116.98059, 32.7693], [-116.98028, 32.77017], [-116.98022, 32.77025], [-116.98028, 32.77002], [-116.98028, 32.76978], [-116.98025, 32.76951], [-116.98022, 32.76942], [-116.98014, 32.76934], [-116.98008, 32.76931], [-116.97977, 32.76924], [-116.97988, 32.76911], [-116.98017, 32.76898], [-116.98059, 32.7693]]], [[[-116.98014, 32.76944], [-116.98017, 32.76955], [-116.9802, 32.76977], [-116.9802, 32.76996], [-116.98018, 32.77009], [-116.98013, 32.77025], [-116.98007, 32.77023], [-116.97955, 32.76984], [-116.97941, 32.76978], [-116.97929, 32.76976], [-116.97953, 32.76954], [-116.97972, 32.7693], [-116.98004, 32.76937], [-116.98014, 32.76944]]], [[[-116.98007, 32.77041], [-116.97968, 32.77033], [-116.97914, 32.77013], [-116.97923, 32.76989], [-116.97934, 32.7699], [-116.97948, 32.76997], [-116.98007, 32.77041]]]]} | Open Access 1 | 7353 | Mt. Helix Park | 22579 | 3024 | Foundation for Preservation of Mt. Helix Nature Theatre 874 | Non Profit 6 | Non Profit - Other 22 | http://www.mthelixpark.org/ | Non Governmental Organization 10 | 3024 | Foundation for Preservation of Mt. Helix Nature Theatre 852 | Non Profit 6 | Non Profit - Other 20 | https://www.mthelixpark.org/ | San Diego 4 | 6.584 | Mt. Helix Park | 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 |
6070 | 6070 | 6069 | {"type": "Polygon", "coordinates": [[[-117.1791, 32.70172], [-117.17896, 32.70196], [-117.17873, 32.70185], [-117.17887, 32.70163], [-117.1791, 32.70172]]]} | Open Access 1 | 808 | Bayview Park | 33708 | 6076 | San Diego Gas and Electric 389 | Private 7 | Utility 21 | http://www.sdge.com/ | Private 14 | 6076 | San Diego Gas and Electric 805 | Private 7 | Utility 29 | https://www.coronado.ca.us/cms/one.aspx?portalId=746090&pageId=3801835 | San Diego 4 | 0.176 | Bayview Park | 0 | Private Recreation or Education 65 | 4 |
4311 | 4311 | 4310 | {"type": "Polygon", "coordinates": [[[-124.14215, 41.06163], [-124.14216, 41.06222], [-124.14214, 41.06229], [-124.14209, 41.0624], [-124.14204, 41.06246], [-124.14198, 41.06251], [-124.14186, 41.06258], [-124.14184, 41.06248], [-124.14083, 41.06253], [-124.14052, 41.06219], [-124.14117, 41.06192], [-124.14071, 41.06151], [-124.14108, 41.06136], [-124.14118, 41.06161], [-124.14194, 41.0615], [-124.14195, 41.0613], [-124.14192, 41.06121], [-124.14212, 41.06118], [-124.14215, 41.06163]]]} | Open Access 1 | 45379 | Saunders Park | 27897 | 3203 | Trinidad Coastal Land Trust 690 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.trinidadcoastallandtrust.org/ | Non Governmental Organization 10 | 3203 | Trinidad Coastal Land Trust 680 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.trinidadcoastallandtrust.org/holdings/index.html | Humboldt 45 | 3.134 | Saunders Park | 0 | Private Recreation or Education 65 | 4 |
14713 | 14713 | 14712 | {"type": "Polygon", "coordinates": [[[-118.2902, 34.09309], [-118.2894, 34.0931], [-118.2894, 34.09282], [-118.2902, 34.09282], [-118.2902, 34.09309]]]} | Open Access 1 | 45052 | Madison Avenue Park | 28044 | 3094 | Trust for Public Land 734 | Non Profit 6 | Non Profit - Conservation 12 | http://www.tpl.org/ | Non Governmental Organization 10 | 3094 | Trust for Public Land 718 | Non Profit 6 | Non Profit - Conservation 12 | http://www.tpl.org/our-work/parks-for-people/madison-ave-park | Los Angeles 6 | 0.559 | Madison Avenue Park | 0 | Private Recreation or Education 65 | 4 |
15972 | 15972 | 15971 | {"type": "Polygon", "coordinates": [[[-122.03205, 38.21576], [-122.03199, 38.2159], [-122.03163, 38.21621], [-122.03151, 38.21621], [-122.0312, 38.21632], [-122.02996, 38.21683], [-122.02982, 38.21715], [-122.02989, 38.21743], [-122.03, 38.21828], [-122.02988, 38.21849], [-122.03008, 38.21854], [-122.02997, 38.21896], [-122.02979, 38.21912], [-122.02965, 38.21923], [-122.0293, 38.21942], [-122.02899, 38.21912], [-122.02876, 38.21895], [-122.02842, 38.21862], [-122.02802, 38.21838], [-122.02759, 38.21816], [-122.02704, 38.218], [-122.02616, 38.21841], [-122.02546, 38.21854], [-122.02498, 38.2186], [-122.0247, 38.21905], [-122.02456, 38.21939], [-122.02449, 38.21949], [-122.02424, 38.21965], [-122.02444, 38.21995], [-122.0246, 38.22035], [-122.02464, 38.22068], [-122.02503, 38.22075], [-122.02535, 38.22074], [-122.02631, 38.2206], [-122.02662, 38.22052], [-122.02702, 38.22081], [-122.02695, 38.22124], [-122.02682, 38.22172], [-122.02666, 38.22202], [-122.02642, 38.22235], [-122.02612, 38.22229], [-122.02602, 38.22201], [-122.02602, 38.22161], [-122.02594, 38.22134], [-122.02578, 38.2212], [-122.02545, 38.22117], [-122.02506, 38.22117], [-122.02465, 38.22132], [-122.02394, 38.22167], [-122.02374, 38.22182], [-122.02316, 38.22212], [-122.02297, 38.22213], [-122.02257, 38.22221], [-122.02236, 38.22267], [-122.02214, 38.22292], [-122.02183, 38.22353], [-122.02184, 38.22393], [-122.02184, 38.22458], [-122.02197, 38.22501], [-122.02223, 38.22511], [-122.02252, 38.22533], [-122.02299, 38.22561], [-122.02322, 38.22563], [-122.02358, 38.22595], [-122.02342, 38.22609], [-122.02316, 38.22615], [-122.02292, 38.2261], [-122.02254, 38.22589], [-122.02178, 38.22575], [-122.02146, 38.22582], [-122.02121, 38.22602], [-122.02104, 38.22631], [-122.0211, 38.22692], [-122.02113, 38.22742], [-122.02102, 38.22784], [-122.02082, 38.228], [-122.02048, 38.22815], [-122.01981, 38.22829], [-122.01943, 38.22827], [-122.01908, 38.22809], [-122.01902, 38.22767], [-122.01914, 38.22729], [-122.01945, 38.22684], [-122.01948, 38.22656], [-122.01984, 38.22618], [-122.0202, 38.22587], [-122.02035, 38.22571], [-122.02052, 38.22534], [-122.01997, 38.22483], [-122.01969, 38.22454], [-122.01937, 38.22414], [-122.01921, 38.22369], [-122.01907, 38.22316], [-122.01898, 38.22308], [-122.01867, 38.22305], [-122.01791, 38.2228], [-122.01747, 38.22286], [-122.01737, 38.22295], [-122.01697, 38.22313], [-122.01672, 38.22319], [-122.01659, 38.22342], [-122.01653, 38.2236], [-122.01658, 38.22396], [-122.01683, 38.22407], [-122.01709, 38.22409], [-122.01756, 38.22419], [-122.01773, 38.22449], [-122.01769, 38.22496], [-122.01767, 38.22536], [-122.01778, 38.22552], [-122.01793, 38.22587], [-122.01795, 38.2262], [-122.01779, 38.2263], [-122.01618, 38.22606], [-122.01579, 38.22595], [-122.01546, 38.22574], [-122.0151, 38.22524], [-122.01477, 38.22523], [-122.01482, 38.22521], [-122.01484, 38.22468], [-122.01437, 38.2236], [-122.0141, 38.2234], [-122.01411, 38.22336], [-122.01403, 38.22316], [-122.0139, 38.22309], [-122.01369, 38.22307], [-122.01342, 38.22311], [-122.0126, 38.22025], [-122.01138, 38.21489], [-122.00995, 38.20984], [-122.00725, 38.2096], [-122.0092, 38.20838], [-122.01085, 38.20677], [-122.01103, 38.20618], [-122.01111, 38.20527], [-122.0107, 38.20449], [-122.01077, 38.20419], [-122.00984, 38.2012], [-122.00988, 38.20067], [-122.00984, 38.20046], [-122.00968, 38.20013], [-122.00919, 38.19981], [-122.00887, 38.19871], [-122.00914, 38.19868], [-122.01003, 38.19839], [-122.01131, 38.19751], [-122.01221, 38.1968], [-122.01242, 38.19647], [-122.01243, 38.19644], [-122.01245, 38.19643], [-122.01261, 38.19616], [-122.01264, 38.19587], [-122.01299, 38.19559], [-122.01476, 38.19522], [-122.01842, 38.19498], [-122.02227, 38.19512], [-122.02309, 38.1953], [-122.02456, 38.19596], [-122.02561, 38.1966], [-122.02651, 38.19755], [-122.02732, 38.19869], [-122.02729, 38.19956], [-122.02677, 38.2008], [-122.027, 38.20186], [-122.02653, 38.20294], [-122.02575, 38.20342], [-122.02566, 38.2037], [-122.02575, 38.20399], [-122.0261, 38.20441], [-122.02659, 38.20487], [-122.02697, 38.20519], [-122.0281, 38.20569], [-122.02938, 38.20615], [-122.02998, 38.2067], [-122.03045, 38.20725], [-122.03045, 38.20729], [-122.03074, 38.20743], [-122.03134, 38.20828], [-122.03036, 38.20808], [-122.02981, 38.20872], [-122.02978, 38.20901], [-122.02961, 38.2092], [-122.02961, 38.20931], [-122.02978, 38.20947], [-122.03013, 38.20961], [-122.03027, 38.21036], [-122.03036, 38.21048], [-122.03036, 38.21073], [-122.03065, 38.21137], [-122.03076, 38.21167], [-122.03074, 38.21201], [-122.03001, 38.21281], [-122.03001, 38.21359], [-122.03062, 38.21482], [-122.0314, 38.2149], [-122.03205, 38.21576]]]} | Open Access 1 | 308 | Rush Ranch Open Space | 12546 | 3081 | Solano Land Trust 361 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.solanolandtrust.org/ | Non Governmental Organization 10 | 3081 | Solano Land Trust 358 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.solanolandtrust.org/RushRanch.aspx | Solano 26 | 1177.494 | Rush Ranch OS | 1987 | Private Recreation or Education 65 | 4 |
4344 | 4344 | 4343 | {"type": "Polygon", "coordinates": [[[-122.27181, 38.09791], [-122.27075, 38.09848], [-122.27064, 38.0983], [-122.27039, 38.09693], [-122.26917, 38.09562], [-122.26946, 38.09542], [-122.26965, 38.09541], [-122.26971, 38.09524], [-122.26973, 38.09524], [-122.2697, 38.0956], [-122.27179, 38.09785], [-122.27181, 38.09791]]]} | Open Access 1 | 45605 | Mare Island Historic Park | 31265 | 3379 | Mare Island Historic Park Foundation 751 | Non Profit 6 | Non Profit - Other 22 | http://www.mareislandhpf.org/ | Non Governmental Organization 10 | 3379 | Mare Island Historic Park Foundation 737 | Non Profit 6 | Non Profit - Other 20 | http://www.mareislandhpf.org/index.html | Solano 26 | 4.996 | Mare Island Historic Park | 0 | Private Recreation or Education 65 | 4 |
5701 | 5701 | 5700 | {"type": "Polygon", "coordinates": [[[-118.46593, 34.21588], [-118.46567, 34.21583], [-118.46558, 34.21553], [-118.46555, 34.21552], [-118.46554, 34.21541], [-118.46585, 34.21547], [-118.46593, 34.21588]]]} | Open Access 1 | 45758 | Marson Park | 28763 | 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 | http://www.lanlt.org/parks-and-gardens.php#marson | Los Angeles 6 | 0.288 | Marson Park | 0 | Private Recreation or Education 65 | 4 |
15335 | 15335 | 15334 | {"type": "Polygon", "coordinates": [[[-118.27552, 34.03356], [-118.27521, 34.03404], [-118.27516, 34.03403], [-118.27517, 34.03372], [-118.27516, 34.0334], [-118.27552, 34.03356]]]} | Open Access 1 | 46514 | Estrella Park | 29799 | 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 | http://www.lanlt.org/parks-and-gardens.php | Los Angeles 6 | 0.309 | Estrella Park | 1982 | 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 |
5266 | 5266 | 5265 | {"type": "Polygon", "coordinates": [[[-117.35459, 33.20901], [-117.35406, 33.21043], [-117.35407, 33.21045], [-117.35412, 33.21045], [-117.3539, 33.21053], [-117.35388, 33.21048], [-117.35389, 33.21042], [-117.35409, 33.20978], [-117.35417, 33.20964], [-117.35418, 33.20959], [-117.35417, 33.20953], [-117.35411, 33.20946], [-117.35404, 33.20943], [-117.35393, 33.20943], [-117.35337, 33.20918], [-117.35314, 33.20899], [-117.35395, 33.20875], [-117.35416, 33.20875], [-117.35447, 33.20877], [-117.35455, 33.20899], [-117.35459, 33.20901]]]} | Open Access 1 | 949 | North County Humane Society and SPCA Dog Park | 29112 | 3361 | San Diego Humane Society and SPCA 803 | Non Profit 6 | Non Profit - Other 22 | http://www.sdhumane.org/ | Non Governmental Organization 10 | 3361 | San Diego Humane Society and SPCA 783 | Non Profit 6 | Non Profit - Other 20 | http://www.ci.oceanside.ca.us/gov/ns/parks/amenities/dogpark.asp | San Diego 4 | 2.32 | North County Humane Society and SPCA Dog 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 |
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 |
7541 | 7541 | 7540 | {"type": "Polygon", "coordinates": [[[-124.11965, 41.03876], [-124.11891, 41.0388], [-124.11852, 41.0388], [-124.11838, 41.03832], [-124.11834, 41.03786], [-124.11845, 41.03761], [-124.1185, 41.0374], [-124.11848, 41.03711], [-124.11845, 41.03703], [-124.11803, 41.03637], [-124.11803, 41.03607], [-124.11812, 41.03579], [-124.11835, 41.03581], [-124.11849, 41.03571], [-124.1189, 41.0358], [-124.11916, 41.03613], [-124.11919, 41.03682], [-124.11911, 41.0371], [-124.11907, 41.03794], [-124.11913, 41.03827], [-124.11933, 41.03852], [-124.11965, 41.03876]]]} | Open Access 1 | 47608 | Houda Point/Camel Rock Beach Park | 31339 | 3203 | Trinidad Coastal Land Trust 690 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.trinidadcoastallandtrust.org/ | Non Governmental Organization 10 | 3203 | Trinidad Coastal Land Trust 680 | Non Profit 6 | Non Profit - Land Trust 10 | http://trinidadcoastallandtrust.org/holdings/houdapoint/ | Humboldt 45 | 5.877 | Houda Point/Camel Rock Beach Park | 0 | Private Recreation or Education 65 | 4 |
8330 | 8330 | 8329 | {"type": "Polygon", "coordinates": [[[-117.09055, 33.05824], [-117.08987, 33.06472], [-117.0888, 33.0652], [-117.08779, 33.06623], [-117.08762, 33.06754], [-117.08752, 33.06778], [-117.08632, 33.06777], [-117.08589, 33.06832], [-117.08581, 33.06924], [-117.08613, 33.07024], [-117.08537, 33.07057], [-117.08523, 33.07125], [-117.08374, 33.07112], [-117.08344, 33.0707], [-117.08373, 33.0701], [-117.08329, 33.06941], [-117.08281, 33.06838], [-117.08267, 33.06775], [-117.08203, 33.06715], [-117.08234, 33.06662], [-117.08253, 33.06494], [-117.08257, 33.06486], [-117.0825, 33.06439], [-117.08259, 33.06429], [-117.08265, 33.06402], [-117.08265, 33.06372], [-117.08256, 33.06359], [-117.08246, 33.06348], [-117.0824, 33.06321], [-117.08242, 33.06312], [-117.08251, 33.06298], [-117.08256, 33.06263], [-117.08304, 33.06214], [-117.08335, 33.0619], [-117.08367, 33.0615], [-117.08376, 33.06128], [-117.08385, 33.06118], [-117.08378, 33.06105], [-117.08379, 33.06096], [-117.08386, 33.06082], [-117.08427, 33.06051], [-117.08432, 33.06043], [-117.08444, 33.06032], [-117.08499, 33.05989], [-117.0857, 33.05861], [-117.08713, 33.058], [-117.08766, 33.05785], [-117.08761, 33.0577], [-117.0876, 33.05758], [-117.08766, 33.05738], [-117.08773, 33.05731], [-117.08795, 33.05728], [-117.08817, 33.05732], [-117.0884, 33.05745], [-117.08853, 33.05762], [-117.08965, 33.0578], [-117.08988, 33.05787], [-117.09024, 33.05791], [-117.09039, 33.058], [-117.09055, 33.05824]], [[-117.08681, 33.06677], [-117.0869, 33.06677], [-117.087, 33.06674], [-117.08714, 33.06664], [-117.08713, 33.0657], [-117.08615, 33.0657], [-117.08616, 33.06666], [-117.08668, 33.06676], [-117.08681, 33.06677]]]} | Open Access 1 | 12833 | Bernardo Mountain Open Space | 10792 | 3066 | San Dieguito River Valley Land Conservancy 378 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sdrvc.org/ | Non Governmental Organization 10 | 3066 | San Dieguito River Valley Land Conservancy 373 | Non Profit 6 | Non Profit - Land Trust 10 | http://sdrvc.org/accomplishments/bernardo-mountain/171 | San Diego 4 | 175.923 | Bernardo Mtn. OS | 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 |
1523 | 1523 | 1522 | {"type": "Polygon", "coordinates": [[[-116.78494, 33.12411], [-116.78019, 33.12414], [-116.7802, 33.12031], [-116.7849, 33.12029], [-116.78494, 33.12411]]]} | Open Access 1 | 12843 | Corral Mountain Open Space | 17655 | 3066 | San Dieguito River Valley Land Conservancy 378 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sdrvc.org/ | Non Governmental Organization 10 | 3066 | San Dieguito River Valley Land Conservancy 373 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 46.202 | Corral Mtn. OS | 0 | 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]);