units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
309 rows where COUNTY = 4 and DES_TP = 3 sorted by LABEL_NAME
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, LAYER, MNG_AG_ID, MNG_AG_LEV
AGNCY_WEB 26 ✖
- http://www.sandiego.gov/park-and-recreation/ 209
- http://www.ci.san-marcos.ca.us/index.aspx?page=42 14
- http://poway.org/204/Community-Services---Parks-Recreation 12
- http://www.carlsbadca.gov/services/depts/parks/default.asp 11
- http://www.ci.oceanside.ca.us/ 10
- http://www.escondido.org/parks-open-space.aspx 8
- http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp 7
- http://www.sandiegocounty.gov/parks/ 7
- http://www.cityofencinitas.org/index.aspx?page=49 6
- http://www.ci.el-cajon.ca.us/dept/rec/_Parks.html 4
- http://www.coronado.ca.us/category/subcategory-rec.php 2
- http://www.olivenhain.com/ 2
- http://www.sweetwater.org 2
- http://www.vcmwd.org/ 2
- http://www.carlsbadusd.k12.ca.us/ 1
- http://www.ci.national-city.ca.us/index.aspx?page=152 1
- http://www.cityofvista.com/departments/parks/parks_and_facilities.cfm 1
- http://www.educ-enrichment.org/ 1
- http://www.hwd.com 1
- http://www.otaywater.gov/ 1
- http://www.portofsandiego.org/ 1
- http://www.rainbowmwd.com/ 1
- http://www.sandi.net/sandi 1
- http://www.sdcwa.org/ 1
- http://www.vwd.org/ 1
- http://www.yuimamwd.com/ 1
MNG_AGENCY 24
- San Diego, City of 211
- San Marcos, City of 14
- Carlsbad, City of 12
- Poway, City of 12
- Oceanside, City of 10
- Escondido, City of 8
- San Diego, County of 7
- Chula Vista, City of 7
- Encinitas, City of 6
- El Cajon, City of 4
- Coronado, City of 2
- Valley Center Water District 2
- Sweetwater Authority 2
- Olivenhain Municipal Water District 2
- National City, City of 1
- Vista, City of 1
- San Diego Unified Port District 1
- Yuima Municipal Water District 1
- Helix Water District 1
- San Diego County Water Authority 1
- Vallecitos Water District 1
- Vista Unified School District 1
- Rainbow Municipal Water District 1
- Otay Water District 1
MNG_AG_TYP 6
ACCESS_TYP 4
- Open Access 277
- Restricted Access 16
- No Public Access 15
- Unknown Access 1
DES_TP 1
- Local Recreation Area · 309 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1171 | 1171 | 1170 | {"type": "MultiPolygon", "coordinates": [[[[-117.12486, 32.71786], [-117.12437, 32.71786], [-117.12432, 32.71769], [-117.12428, 32.71748], [-117.12485, 32.71748], [-117.12486, 32.71786]]], [[[-117.12527, 32.7201], [-117.12493, 32.7201], [-117.12493, 32.71957], [-117.12459, 32.71956], [-117.12459, 32.71928], [-117.1244, 32.71927], [-117.1244, 32.71914], [-117.12521, 32.71913], [-117.12522, 32.71925], [-117.12525, 32.71926], [-117.12526, 32.71942], [-117.12527, 32.7201]]], [[[-117.1252, 32.71847], [-117.12449, 32.71847], [-117.12441, 32.71809], [-117.1252, 32.71808], [-117.1252, 32.71847]]], [[[-117.12521, 32.7189], [-117.12456, 32.71891], [-117.12452, 32.71853], [-117.12521, 32.71852], [-117.12521, 32.7189]]], [[[-117.12529, 32.72089], [-117.12494, 32.72089], [-117.12494, 32.72033], [-117.12528, 32.72032], [-117.12529, 32.72089]]], [[[-117.12597, 32.72046], [-117.12554, 32.72046], [-117.12554, 32.72028], [-117.12596, 32.72028], [-117.12597, 32.72046]]], [[[-117.12598, 32.72117], [-117.12554, 32.72117], [-117.12554, 32.72059], [-117.12597, 32.72059], [-117.12598, 32.72117]]], [[[-117.12644, 32.72134], [-117.12644, 32.72193], [-117.12597, 32.72192], [-117.12597, 32.72134], [-117.12644, 32.72134]]], [[[-117.12744, 32.72243], [-117.12743, 32.72304], [-117.12707, 32.72304], [-117.12707, 32.72292], [-117.12704, 32.72291], [-117.12704, 32.72269], [-117.12665, 32.72268], [-117.12666, 32.72243], [-117.12744, 32.72243]]], [[[-117.12744, 32.72221], [-117.12669, 32.72221], [-117.1267, 32.72179], [-117.12703, 32.7218], [-117.12704, 32.72207], [-117.12736, 32.72215], [-117.12743, 32.72215], [-117.12744, 32.72221]]], [[[-117.1283, 32.72411], [-117.12828, 32.72434], [-117.12792, 32.72434], [-117.12792, 32.72404], [-117.12829, 32.72404], [-117.1283, 32.72411]]], [[[-117.12829, 32.7239], [-117.12792, 32.72391], [-117.12792, 32.72377], [-117.12829, 32.72378], [-117.12829, 32.7239]]]]} | Open Access 1 | 7499 | 32nd Street Canyon | 15193 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 7.011 | 32nd Street Canyon | 0 | Local Recreation Area 3 | 4 | |
16145 | 16145 | 16144 | {"type": "Polygon", "coordinates": [[[-117.12447, 32.72612], [-117.12413, 32.72613], [-117.12412, 32.72547], [-117.12445, 32.72546], [-117.12447, 32.72612]]]} | Open Access 1 | 19921 | 34th St Canyon Open Space | 15194 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.576 | 34th St Canyon OS | 0 | Local Recreation Area 3 | 4 | |
10 | 10 | 9 | {"type": "MultiPolygon", "coordinates": [[[[-117.09436, 32.74201], [-117.09395, 32.74201], [-117.09393, 32.74146], [-117.09346, 32.74146], [-117.09345, 32.74102], [-117.09291, 32.74017], [-117.09284, 32.74016], [-117.09282, 32.73919], [-117.09236, 32.73919], [-117.09235, 32.7385], [-117.0928, 32.73849], [-117.09279, 32.73755], [-117.09339, 32.73754], [-117.09339, 32.73696], [-117.09359, 32.73697], [-117.0936, 32.73699], [-117.0938, 32.73699], [-117.09383, 32.7391], [-117.09321, 32.73912], [-117.09324, 32.74037], [-117.09385, 32.74037], [-117.09387, 32.74118], [-117.09435, 32.74118], [-117.09436, 32.74201]]], [[[-117.09277, 32.74057], [-117.0927, 32.74058], [-117.09269, 32.74084], [-117.09238, 32.74085], [-117.09238, 32.74039], [-117.09276, 32.74038], [-117.09277, 32.74057]]], [[[-117.09497, 32.74242], [-117.09456, 32.74242], [-117.09456, 32.74223], [-117.09497, 32.74222], [-117.09497, 32.74242]]], [[[-117.09603, 32.7429], [-117.09564, 32.74291], [-117.09564, 32.7427], [-117.09603, 32.7427], [-117.09603, 32.7429]]]]} | Open Access 1 | 31 | 47th Street Canyon | 15202 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 9.994 | 47th Street Canyon | 0 | Local Recreation Area 3 | 4 | |
15159 | 15159 | 15158 | {"type": "Polygon", "coordinates": [[[-117.12105, 33.004], [-117.12098, 33.00409], [-117.12083, 33.00424], [-117.12067, 33.00451], [-117.12062, 33.00467], [-117.12064, 33.00492], [-117.12061, 33.00507], [-117.12023, 33.00568], [-117.11995, 33.00557], [-117.1199, 33.00545], [-117.11984, 33.00535], [-117.11975, 33.00525], [-117.11963, 33.00516], [-117.11942, 33.00505], [-117.1192, 33.00497], [-117.11907, 33.00495], [-117.11894, 33.00495], [-117.11842, 33.00502], [-117.11826, 33.00516], [-117.11817, 33.00485], [-117.11819, 33.00445], [-117.1182, 33.00431], [-117.11831, 33.00418], [-117.11838, 33.00401], [-117.11835, 33.00386], [-117.11829, 33.00382], [-117.11836, 33.00338], [-117.11849, 33.00338], [-117.11855, 33.00336], [-117.11859, 33.00332], [-117.11865, 33.00322], [-117.11868, 33.00319], [-117.11929, 33.00323], [-117.11993, 33.00317], [-117.1201, 33.0032], [-117.12038, 33.00331], [-117.12105, 33.00331], [-117.12111, 33.00375], [-117.1211, 33.00387], [-117.12105, 33.004]]]} | Open Access 1 | 46007 | 4S Ranch Sports Park | 29269 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/4SRanchParks/4SRanchSports.html | San Diego 4 | 12.833 | 4S Ranch Sports Park | 0 | Local Recreation Area 3 | 4 |
6148 | 6148 | 6147 | {"type": "Polygon", "coordinates": [[[-117.0747, 32.78221], [-117.07462, 32.78225], [-117.07456, 32.78235], [-117.07453, 32.78236], [-117.07449, 32.78207], [-117.07319, 32.78207], [-117.07249, 32.782], [-117.07221, 32.78175], [-117.07188, 32.78121], [-117.07462, 32.78164], [-117.0747, 32.78221]]]} | Open Access 1 | 18932 | Adobe Falls Open Space Park | 15271 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 4.003 | Adobe Falls OS Park | 0 | Local Recreation Area 3 | 4 | |
2787 | 2787 | 2786 | {"type": "MultiPolygon", "coordinates": [[[[-117.1655, 32.74559], [-117.1651, 32.7456], [-117.16509, 32.74433], [-117.1655, 32.74432], [-117.1655, 32.74559]]], [[[-117.16661, 32.74404], [-117.1661, 32.74404], [-117.16611, 32.74459], [-117.16556, 32.7446], [-117.16555, 32.74405], [-117.16556, 32.74392], [-117.16661, 32.7439], [-117.16661, 32.74404]]], [[[-117.16849, 32.74062], [-117.16808, 32.74063], [-117.16809, 32.74086], [-117.16797, 32.74096], [-117.16759, 32.74142], [-117.16751, 32.74153], [-117.16669, 32.74154], [-117.16668, 32.74105], [-117.16763, 32.74103], [-117.16764, 32.74064], [-117.16763, 32.74022], [-117.16809, 32.74021], [-117.16809, 32.73983], [-117.16848, 32.73982], [-117.16849, 32.74062]]], [[[-117.16935, 32.73926], [-117.16914, 32.73957], [-117.16907, 32.7397], [-117.169, 32.73971], [-117.16899, 32.73918], [-117.16934, 32.73918], [-117.16935, 32.73926]]]]} | Open Access 1 | 18557 | Albatross Canyon Open Space | 15332 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 5.812 | Albatross Canyon OS | 0 | Local Recreation Area 3 | 4 | |
7792 | 7792 | 7791 | {"type": "Polygon", "coordinates": [[[-117.34567, 33.22133], [-117.34531, 33.22156], [-117.34498, 33.22181], [-117.34466, 33.22207], [-117.34437, 33.22235], [-117.34432, 33.2223], [-117.34451, 33.22209], [-117.34469, 33.22184], [-117.34484, 33.22158], [-117.34494, 33.22133], [-117.34501, 33.22129], [-117.34538, 33.22134], [-117.34567, 33.22133]]]} | Open Access 1 | 47674 | Alex Road Skate Park | 31416 | 1230 | Oceanside, City of 77 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/ | City 2 | 1230 | Oceanside, City of 75 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/gov/ns/parks/alexpark.asp | San Diego 4 | 0.81 | Alex Road Skate Park | 0 | Local Recreation Area 3 | 4 |
15147 | 15147 | 15146 | {"type": "Polygon", "coordinates": [[[-117.06234, 32.97546], [-117.06232, 32.97691], [-117.06225, 32.97692], [-117.06223, 32.97788], [-117.0613, 32.97786], [-117.0613, 32.97764], [-117.06135, 32.9775], [-117.06136, 32.97709], [-117.06132, 32.97698], [-117.06131, 32.97586], [-117.06151, 32.97583], [-117.06157, 32.97545], [-117.06234, 32.97546]]]} | Open Access 1 | 45981 | Arbolitos Sports Field | 29149 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://poway.org/Facilities/Facility/Details/Arbolitos-Sports-Fields-54 | San Diego 4 | 5.82 | Arbolitos Sports Field | 0 | Local Recreation Area 3 | 4 |
3556 | 3556 | 3555 | {"type": "Polygon", "coordinates": [[[-117.23771, 32.92887], [-117.23764, 32.92911], [-117.23752, 32.9294], [-117.23732, 32.92977], [-117.23735, 32.9298], [-117.23727, 32.92994], [-117.23672, 32.93067], [-117.23651, 32.93102], [-117.23436, 32.93101], [-117.23431, 32.92669], [-117.23586, 32.92657], [-117.23762, 32.92885], [-117.23771, 32.92887]]]} | Open Access 1 | 12154 | Arroyo Sorrento Open Space | 15633 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 29.661 | Arroyo Sorrento OS | 0 | Local Recreation Area 3 | 4 | |
12465 | 12465 | 12464 | {"type": "Polygon", "coordinates": [[[-117.10941, 32.7369], [-117.1094, 32.73752], [-117.10894, 32.73752], [-117.10895, 32.7369], [-117.10941, 32.7369]]]} | Open Access 1 | 28116 | Azalea Park and Lexington Canyon Open Space | 15738 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.728 | Azalea Park and Lexington Canyon OS | 0 | Local Recreation Area 3 | 4 | |
5822 | 5822 | 5821 | {"type": "Polygon", "coordinates": [[[-117.16627, 32.73925], [-117.16594, 32.73926], [-117.16593, 32.7388], [-117.16627, 32.7388], [-117.16627, 32.73925]]]} | Open Access 1 | 178 | Banker's Hill Canyon Open Space | 15796 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.393 | Banker's Hill Canyon OS | 0 | Local Recreation Area 3 | 4 | |
15899 | 15899 | 15898 | {"type": "Polygon", "coordinates": [[[-117.16654, 32.73769], [-117.16637, 32.73802], [-117.16607, 32.73803], [-117.16607, 32.73863], [-117.16568, 32.73863], [-117.16567, 32.73843], [-117.16534, 32.73844], [-117.16534, 32.7383], [-117.1654, 32.73829], [-117.16539, 32.73764], [-117.16566, 32.73764], [-117.16567, 32.73753], [-117.16593, 32.73753], [-117.16594, 32.73769], [-117.16625, 32.73769], [-117.16624, 32.73773], [-117.16625, 32.73774], [-117.16636, 32.73774], [-117.16638, 32.73769], [-117.16654, 32.73769]]]} | Open Access 1 | 179 | Banker's Hill Canyon Open Space | 15796 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 1.967 | Banker's Hill Canyon OS | 0 | Local Recreation Area 3 | 4 | |
6254 | 6254 | 6253 | {"type": "MultiPolygon", "coordinates": [[[[-116.72083, 32.70426], [-116.71907, 32.7045], [-116.71873, 32.70456], [-116.7182, 32.70471], [-116.71793, 32.70482], [-116.71767, 32.70496], [-116.71735, 32.70515], [-116.71708, 32.70537], [-116.71398, 32.70808], [-116.71371, 32.70826], [-116.71349, 32.70839], [-116.71319, 32.70853], [-116.71283, 32.70866], [-116.70883, 32.70798], [-116.70426, 32.70803], [-116.70439, 32.71165], [-116.70677, 32.71163], [-116.70672, 32.71196], [-116.70667, 32.7121], [-116.70658, 32.71228], [-116.70649, 32.71241], [-116.70538, 32.71375], [-116.70517, 32.71411], [-116.70506, 32.71444], [-116.70502, 32.71464], [-116.705, 32.71489], [-116.70499, 32.71695], [-116.70495, 32.71993], [-116.7049, 32.72027], [-116.70478, 32.72064], [-116.70461, 32.72097], [-116.70444, 32.72123], [-116.70424, 32.72147], [-116.70405, 32.72166], [-116.69956, 32.72557], [-116.69966, 32.7224], [-116.69545, 32.72241], [-116.6953, 32.72599], [-116.6909, 32.726], [-116.69148, 32.71532], [-116.69577, 32.71527], [-116.69593, 32.71173], [-116.7001, 32.71169], [-116.69997, 32.7081], [-116.70112, 32.70807], [-116.70099, 32.7045], [-116.69554, 32.70453], [-116.69514, 32.69711], [-116.6819, 32.69715], [-116.68214, 32.70068], [-116.67793, 32.70075], [-116.67876, 32.71169], [-116.6786, 32.71546], [-116.68281, 32.71546], [-116.68266, 32.71901], [-116.68694, 32.71903], [-116.68659, 32.7261], [-116.67808, 32.72613], [-116.67826, 32.7226], [-116.66961, 32.72265], [-116.66984, 32.71904], [-116.67418, 32.71895], [-116.67435, 32.71542], [-116.6661, 32.71554], [-116.66639, 32.71171], [-116.66252, 32.71174], [-116.66225, 32.70812], [-116.66611, 32.70808], [-116.66584, 32.7045], [-116.66983, 32.70446], [-116.66933, 32.69723], [-116.66139, 32.69733], [-116.66126, 32.69371], [-116.65721, 32.69375], [-116.65703, 32.69021], [-116.65041, 32.68985], [-116.64504, 32.6896], [-116.64512, 32.68579], [-116.64145, 32.68553], [-116.62402, 32.686], [-116.62403, 32.68245], [-116.61982, 32.68242], [-116.61983, 32.67894], [-116.62406, 32.67895], [-116.62828, 32.67883], [-116.62843, 32.68226], [-116.64162, 32.6817], [-116.65303, 32.68272], [-116.65312, 32.68635], [-116.65685, 32.68666], [-116.66102, 32.68661], [-116.66116, 32.69017], [-116.66941, 32.69001], [-116.66943, 32.68647], [-116.66522, 32.68654], [-116.66518, 32.67936], [-116.66938, 32.67923], [-116.66936, 32.66864], [-116.67387, 32.66853], [-116.67418, 32.66477], [-116.67836, 32.6647], [-116.67912, 32.65372], [-116.68316, 32.65371], [-116.68281, 32.65012], [-116.69142, 32.65005], [-116.69107, 32.6537], [-116.68713, 32.65371], [-116.68691, 32.66092], [-116.68275, 32.66096], [-116.68232, 32.66832], [-116.67809, 32.66843], [-116.67805, 32.67191], [-116.67386, 32.67198], [-116.67382, 32.68271], [-116.68213, 32.68268], [-116.68206, 32.68638], [-116.68642, 32.68631], [-116.68641, 32.68978], [-116.69093, 32.68974], [-116.69093, 32.69145], [-116.69097, 32.69352], [-116.7085, 32.69348], [-116.70862, 32.69707], [-116.71266, 32.69772], [-116.71271, 32.7015], [-116.7208, 32.70275], [-116.72083, 32.70426]]], [[[-116.70877, 32.71161], [-116.70809, 32.72584], [-116.69953, 32.72595], [-116.69953, 32.72583], [-116.70419, 32.72176], [-116.70447, 32.72148], [-116.7047, 32.72118], [-116.70487, 32.72089], [-116.70501, 32.72058], [-116.70509, 32.7203], [-116.70515, 32.71995], [-116.70519, 32.71695], [-116.7052, 32.71484], [-116.70523, 32.71452], [-116.70534, 32.71421], [-116.70544, 32.714], [-116.70558, 32.71379], [-116.70662, 32.71254], [-116.70673, 32.71239], [-116.70683, 32.71221], [-116.7069, 32.71203], [-116.70695, 32.71184], [-116.70697, 32.71163], [-116.70877, 32.71161]]], [[[-116.71691, 32.70935], [-116.71691, 32.70935], [-116.71317, 32.70872], [-116.71348, 32.70858], [-116.71373, 32.70845], [-116.71395, 32.70831], [-116.71419, 32.70814], [-116.71683, 32.70582], [-116.71691, 32.70935]]], [[[-116.72086, 32.70635], [-116.72086, 32.70635], [-116.71693, 32.70573], [-116.71727, 32.70544], [-116.71758, 32.70521], [-116.71797, 32.705], [-116.71838, 32.70483], [-116.7187, 32.70474], [-116.719, 32.70467], [-116.72083, 32.70443], [-116.72086, 32.70635]]]]} | Restricted Access 2 | 1327 | Barrett Reservoir | 15833 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | https://www.sandiego.gov/water/recreation/reservoirs/barrett | San Diego 4 | 4177.221 | Barrett Reservoir | 0 | Local Recreation Area 3 | 4 |
6087 | 6087 | 6086 | {"type": "Polygon", "coordinates": [[[-117.30606, 33.10595], [-117.30582, 33.10598], [-117.30555, 33.10596], [-117.30562, 33.10551], [-117.30557, 33.10548], [-117.30521, 33.10539], [-117.30525, 33.105], [-117.30526, 33.10463], [-117.30605, 33.10448], [-117.30606, 33.10595]]]} | Open Access 1 | 1113 | Batiquitos Drive Open Space | 15863 | 1045 | Carlsbad, City of 123 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/default.asp | City 2 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | San Diego 4 | 2.468 | Batiquitos Drive OS | 0 | Local Recreation Area 3 | 4 | |
6129 | 6129 | 6128 | {"type": "Polygon", "coordinates": [[[-117.30647, 33.10234], [-117.30617, 33.10247], [-117.30636, 33.10281], [-117.30617, 33.10282], [-117.30617, 33.10266], [-117.30508, 33.10086], [-117.30526, 33.1008], [-117.30538, 33.10115], [-117.3057, 33.10108], [-117.30542, 33.10119], [-117.30544, 33.10127], [-117.3055, 33.10135], [-117.30588, 33.10197], [-117.30617, 33.10185], [-117.30619, 33.10187], [-117.30588, 33.10201], [-117.30614, 33.10245], [-117.30645, 33.10232], [-117.30647, 33.10234]]]} | Open Access 1 | 1114 | Batiquitos Drive Open Space | 15863 | 1045 | Carlsbad, City of 123 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/default.asp | City 2 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | San Diego 4 | 0.715 | Batiquitos Drive OS | 0 | Local Recreation Area 3 | 4 | |
6130 | 6130 | 6129 | {"type": "Polygon", "coordinates": [[[-117.30489, 33.1026], [-117.30484, 33.10263], [-117.30464, 33.10265], [-117.30424, 33.1026], [-117.30451, 33.10256], [-117.30459, 33.10251], [-117.30466, 33.10246], [-117.3047, 33.1024], [-117.30471, 33.1023], [-117.30467, 33.10201], [-117.30452, 33.10151], [-117.30442, 33.10129], [-117.30412, 33.10081], [-117.3039, 33.10085], [-117.30378, 33.10059], [-117.30402, 33.10049], [-117.30403, 33.10047], [-117.30422, 33.1004], [-117.30466, 33.10131], [-117.30467, 33.10135], [-117.30481, 33.10171], [-117.30487, 33.10193], [-117.30489, 33.10221], [-117.3049, 33.10257], [-117.30489, 33.1026]]]} | Open Access 1 | 1115 | Batiquitos Drive Open Space | 15863 | 1045 | Carlsbad, City of 123 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/default.asp | City 2 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | San Diego 4 | 1.598 | Batiquitos Drive OS | 0 | Local Recreation Area 3 | 4 | |
15816 | 15816 | 15815 | {"type": "Polygon", "coordinates": [[[-117.30512, 33.09899], [-117.30508, 33.10086], [-117.30508, 33.10146], [-117.30497, 33.10125], [-117.30494, 33.10114], [-117.30486, 33.10098], [-117.30445, 33.1], [-117.30439, 33.09991], [-117.30399, 33.09898], [-117.30512, 33.09899]]]} | Open Access 1 | 1116 | Batiquitos Drive Open Space | 15863 | 1045 | Carlsbad, City of 123 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/default.asp | City 2 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | San Diego 4 | 3.566 | Batiquitos Drive OS | 0 | Local Recreation Area 3 | 4 | |
15820 | 15820 | 15819 | {"type": "Polygon", "coordinates": [[[-117.30392, 33.09963], [-117.30353, 33.09976], [-117.30314, 33.09969], [-117.30324, 33.09954], [-117.30324, 33.09935], [-117.30314, 33.09914], [-117.30301, 33.09907], [-117.30276, 33.099], [-117.30287, 33.09898], [-117.30372, 33.09898], [-117.30392, 33.09963]]]} | Open Access 1 | 1117 | Batiquitos Drive Open Space | 15863 | 1045 | Carlsbad, City of 123 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/default.asp | City 2 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | San Diego 4 | 1.277 | Batiquitos Drive OS | 0 | Local Recreation Area 3 | 4 | |
16916 | 16916 | 16915 | {"type": "Polygon", "coordinates": [[[-117.07375, 33.04138], [-117.07327, 33.04204], [-117.07279, 33.04304], [-117.07254, 33.04375], [-117.07233, 33.04397], [-117.07197, 33.04569], [-117.0719, 33.04629], [-117.07097, 33.04653], [-117.07021, 33.04703], [-117.07022, 33.04733], [-117.0696, 33.04878], [-117.06934, 33.04893], [-117.06907, 33.04926], [-117.06888, 33.04942], [-117.06857, 33.04958], [-117.0682, 33.04964], [-117.06812, 33.04969], [-117.06803, 33.04981], [-117.06798, 33.04989], [-117.06731, 33.04954], [-117.06686, 33.04948], [-117.0666, 33.04907], [-117.06628, 33.04894], [-117.06615, 33.04855], [-117.06554, 33.04816], [-117.06544, 33.04817], [-117.06545, 33.04761], [-117.0655, 33.04707], [-117.06625, 33.0471], [-117.06628, 33.04681], [-117.06635, 33.04667], [-117.06636, 33.04662], [-117.06614, 33.04657], [-117.06616, 33.04646], [-117.06614, 33.04639], [-117.06618, 33.04638], [-117.06622, 33.04642], [-117.0662, 33.04654], [-117.06637, 33.04658], [-117.06659, 33.04639], [-117.06676, 33.04613], [-117.06708, 33.04615], [-117.06773, 33.04561], [-117.06828, 33.0456], [-117.06829, 33.04507], [-117.06857, 33.04425], [-117.06857, 33.0441], [-117.06848, 33.04388], [-117.06897, 33.0437], [-117.06881, 33.04342], [-117.06994, 33.04343], [-117.07008, 33.04291], [-117.07035, 33.04293], [-117.07111, 33.04291], [-117.07143, 33.04285], [-117.0716, 33.0428], [-117.07171, 33.04274], [-117.07174, 33.04274], [-117.07193, 33.04261], [-117.07211, 33.04246], [-117.07244, 33.04206], [-117.07263, 33.04187], [-117.07286, 33.0417], [-117.07344, 33.04134], [-117.07375, 33.04138]]]} | Open Access 1 | 18641 | Battle Mountain Open Space | 15868 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 69.373 | Battle Mtn. OS | 0 | Local Recreation Area 3 | 4 | |
15985 | 15985 | 15984 | {"type": "Polygon", "coordinates": [[[-117.20805, 32.81695], [-117.2059, 32.81691], [-117.2059, 32.81641], [-117.20651, 32.81639], [-117.20649, 32.81554], [-117.20588, 32.81554], [-117.20584, 32.81431], [-117.20583, 32.8143], [-117.20572, 32.81436], [-117.2056, 32.8143], [-117.2056, 32.81426], [-117.20663, 32.81393], [-117.20692, 32.81329], [-117.20795, 32.81331], [-117.20805, 32.81695]]]} | Open Access 1 | 909 | Bay Ridge Open Space | 15878 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 16.843 | Bay Ridge OS | 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]);