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 COUNTY
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, DES_TP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
3931 | 3931 | 3930 | {"type": "Polygon", "coordinates": [[[-117.15178, 32.71015], [-117.15154, 32.71016], [-117.15154, 32.71036], [-117.15114, 32.71036], [-117.15113, 32.70953], [-117.15178, 32.70953], [-117.15178, 32.71015]]]} | Open Access 1 | 48832 | Fault Line Park | 33551 | 6133 | Pinnacle International Development, Inc 701 | Private 7 | Commercial 20 | http://www.pinnacleinternational.ca/resume | Private 14 | 6133 | Pinnacle International Development, Inc 689 | Private 7 | Commercial 18 | San Diego 4 | 1.249 | Fault Line 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 |
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 |
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 |
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 |
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 |
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 | |
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 |
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 |
4022 | 4022 | 4021 | {"type": "Polygon", "coordinates": [[[-118.29141, 33.96539], [-118.29091, 33.96539], [-118.29091, 33.96521], [-118.29141, 33.96521], [-118.29141, 33.96539]]]} | Open Access 1 | 46884 | Vermont Miracle Park | 32598 | 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 | Los Angeles 6 | 0.23 | Vermont Miracle 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 | |
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 |
5006 | 5006 | 5005 | {"type": "Polygon", "coordinates": [[[-118.62819, 34.09631], [-118.62814, 34.1035], [-118.62683, 34.10349], [-118.62683, 34.10402], [-118.62661, 34.10402], [-118.6266, 34.10349], [-118.6238, 34.10347], [-118.62382, 34.09987], [-118.62381, 34.09806], [-118.61947, 34.09805], [-118.61948, 34.09625], [-118.62381, 34.09625], [-118.62819, 34.09631]]]} | Open Access 1 | 12508 | Mountains Restoration Trust Parkland | 22563 | 3044 | Mountains Restoration Trust 533 | Non Profit 6 | Non Profit - Conservation 12 | http://www.mountainstrust.org/ | Non Governmental Organization 10 | 3044 | Mountains Restoration Trust 526 | Non Profit 6 | Non Profit - Conservation 12 | Los Angeles 6 | 99.528 | Mtns. Restoration Trust Parkland | 0 | Private Recreation or Education 65 | 4 | |
5407 | 5407 | 5406 | {"type": "Polygon", "coordinates": [[[-118.44355, 34.10751], [-118.443, 34.10752], [-118.44352, 34.10878], [-118.44023, 34.10877], [-118.44022, 34.10977], [-118.43891, 34.10965], [-118.4389, 34.11005], [-118.43864, 34.11005], [-118.43799, 34.10993], [-118.43749, 34.10981], [-118.43745, 34.10968], [-118.43747, 34.10956], [-118.43721, 34.10939], [-118.43722, 34.10936], [-118.43714, 34.10934], [-118.43707, 34.10929], [-118.43709, 34.10922], [-118.43709, 34.10895], [-118.43705, 34.10884], [-118.43772, 34.10905], [-118.43841, 34.10906], [-118.4389, 34.1088], [-118.43891, 34.10871], [-118.44022, 34.10836], [-118.44023, 34.10745], [-118.44353, 34.10745], [-118.44355, 34.10751]]]} | Open Access 1 | 12500 | Mountains Restoration Trust Parkland | 22563 | 3044 | Mountains Restoration Trust 533 | Non Profit 6 | Non Profit - Conservation 12 | http://www.mountainstrust.org/ | Non Governmental Organization 10 | 3044 | Mountains Restoration Trust 526 | Non Profit 6 | Non Profit - Conservation 12 | Los Angeles 6 | 18.111 | Mtns. Restoration Trust Parkland | 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 |
7120 | 7120 | 7119 | {"type": "Polygon", "coordinates": [[[-118.29912, 33.86543], [-118.29909, 33.86547], [-118.29904, 33.86549], [-118.29584, 33.86548], [-118.29583, 33.86553], [-118.29492, 33.86553], [-118.29491, 33.86548], [-118.29166, 33.86548], [-118.29084, 33.86608], [-118.29076, 33.86609], [-118.29069, 33.86604], [-118.29069, 33.86382], [-118.29066, 33.8638], [-118.29912, 33.8638], [-118.29912, 33.86543]]]} | Open Access 1 | 6201 | Roosevelt Memorial Park | 24594 | 3060 | Roosevelt Memorial Park Association 850 | Non Profit 6 | Non Profit - Cemetery District 28 | http://www.rooseveltmemorialparkandmortuary.com/ | Non Governmental Organization 10 | 3060 | Roosevelt Memorial Park Association 828 | Non Profit 6 | Non Profit - Cemetery District 27 | Los Angeles 6 | 36.884 | Roosevelt Memorial Park | 0 | Private Recreation or Education 65 | 4 | |
7265 | 7265 | 7264 | {"type": "Polygon", "coordinates": [[[-118.6346, 34.10682], [-118.63459, 34.10718], [-118.6335, 34.10718], [-118.63333, 34.10682], [-118.63356, 34.10682], [-118.63372, 34.1069], [-118.63389, 34.10682], [-118.6346, 34.10682]]]} | Open Access 1 | 6453 | Red Rock Canyon Park | 24227 | 3044 | Mountains Restoration Trust 533 | Non Profit 6 | Non Profit - Conservation 12 | http://www.mountainstrust.org/ | Non Governmental Organization 10 | 3044 | Mountains Restoration Trust 526 | Non Profit 6 | Non Profit - Conservation 12 | Los Angeles 6 | 1.049 | Red Rock Canyon Park | 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 |
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]);