units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
552 rows where COUNTY = 4, DES_TP = 2 and MNG_AG_TYP = 2 sorted by rowid descending
This data as json, copyable, CSV (advanced)
MNG_AGENCY 18
- San Diego, City of 281
- Chula Vista, City of 60
- Oceanside, City of 28
- Carlsbad, City of 23
- San Marcos, City of 21
- Encinitas, City of 19
- Coronado, City of 17
- Escondido, City of 16
- La Mesa, City of 14
- Poway, City of 13
- Vista, City of 13
- El Cajon, City of 12
- Santee, City of 10
- National City, City of 6
- Lemon Grove, City of 6
- Del Mar, City of 5
- Imperial Beach, City of 5
- Solana Beach, City of 3
ACCESS_TYP 3
- Open Access 535
- Restricted Access 11
- No Public Access 6
MNG_AG_TYP 1
- City Agency · 552 ✖
DES_TP 1
- Local Park · 552 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17046 | 17046 | 17045 | {"type": "Polygon", "coordinates": [[[-116.98325, 32.84955], [-116.98119, 32.84949], [-116.98023, 32.84953], [-116.97857, 32.8501], [-116.97773, 32.85014], [-116.97767, 32.85017], [-116.97709, 32.85032], [-116.97637, 32.85047], [-116.97628, 32.8506], [-116.97625, 32.85068], [-116.97623, 32.85157], [-116.97585, 32.85156], [-116.97579, 32.85151], [-116.97578, 32.8514], [-116.9757, 32.8514], [-116.97573, 32.85042], [-116.97586, 32.85043], [-116.97598, 32.85036], [-116.97605, 32.85025], [-116.9761, 32.85025], [-116.97612, 32.85003], [-116.97621, 32.85], [-116.97672, 32.84995], [-116.97693, 32.84991], [-116.9771, 32.84977], [-116.97717, 32.84964], [-116.97719, 32.84952], [-116.97714, 32.8494], [-116.97705, 32.84933], [-116.97693, 32.84934], [-116.97673, 32.84939], [-116.97602, 32.84946], [-116.97575, 32.84945], [-116.97576, 32.84927], [-116.97623, 32.84927], [-116.97646, 32.84925], [-116.97669, 32.84921], [-116.97701, 32.84909], [-116.9772, 32.84899], [-116.97738, 32.84886], [-116.97816, 32.84818], [-116.97844, 32.84802], [-116.97876, 32.84791], [-116.97914, 32.84784], [-116.98231, 32.84759], [-116.98263, 32.84759], [-116.9832, 32.84764], [-116.98324, 32.84766], [-116.98326, 32.84771], [-116.98325, 32.84955]]]} | Open Access 1 | 45977 | Town Center Community Park | 29131 | 1325 | Santee, City of 34 | City 2 | City Agency 2 | http://www.ci.santee.ca.us/Index.aspx?page=63 | City 2 | 1325 | Santee, City of 33 | City 2 | City Agency 2 | http://www.ci.santee.ca.us/index.aspx?page=229 | San Diego 4 | 32.677 | Town Ctr. Community Park | 0 | Local Park 2 | 4 |
17045 | 17045 | 17044 | {"type": "Polygon", "coordinates": [[[-117.15886, 33.14153], [-117.15831, 33.14154], [-117.1577, 33.14159], [-117.15768, 33.14153], [-117.1584, 33.14106], [-117.15849, 33.1412], [-117.15861, 33.14133], [-117.15886, 33.14153]]]} | Open Access 1 | 45970 | Civic Center Park | 29119 | 1308 | San Marcos, City of 201 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | http://www.san-marcos.net/Home/Components/FacilityDirectory/FacilityDirectory/150/1081 | San Diego 4 | 0.729 | Civic Ctr. Park | 0 | Local Park 2 | 4 |
17023 | 17023 | 17022 | {"type": "Polygon", "coordinates": [[[-117.23516, 33.20398], [-117.2347, 33.20423], [-117.23438, 33.20391], [-117.23431, 33.20367], [-117.23415, 33.20336], [-117.23382, 33.20317], [-117.23319, 33.20309], [-117.23308, 33.20329], [-117.23293, 33.20312], [-117.23259, 33.20288], [-117.2323, 33.20278], [-117.23192, 33.20276], [-117.2321, 33.20221], [-117.23237, 33.20244], [-117.23319, 33.20271], [-117.2334, 33.20269], [-117.23376, 33.20281], [-117.23402, 33.20279], [-117.23406, 33.20295], [-117.2342, 33.20294], [-117.23423, 33.20304], [-117.23436, 33.20302], [-117.23441, 33.20304], [-117.23458, 33.20312], [-117.2347, 33.20322], [-117.23465, 33.20338], [-117.23464, 33.20356], [-117.23466, 33.20364], [-117.23471, 33.20374], [-117.23483, 33.2037], [-117.23486, 33.20375], [-117.235, 33.20369], [-117.23516, 33.20398]]]} | Open Access 1 | 12927 | Civic Center Park | 17366 | 1369 | Vista, City of 159 | City 2 | City Agency 2 | http://www.cityofvista.com/departments/parks/parks_and_facilities.cfm | City 2 | 1369 | Vista, City of 155 | City 2 | City Agency 2 | http://www.cityofvista.com/services/parks-and-facilities | San Diego 4 | 3.873 | Civic Ctr. Park | 0 | Local Park 2 | 4 |
16337 | 16337 | 16336 | {"type": "MultiPolygon", "coordinates": [[[[-117.07724, 32.58886], [-117.07702, 32.58887], [-117.07702, 32.58935], [-117.07542, 32.58935], [-117.07543, 32.5875], [-117.07724, 32.5875], [-117.07724, 32.58886]]], [[[-117.07114, 32.59021], [-117.07114, 32.59039], [-117.07056, 32.5903], [-117.06945, 32.5902], [-117.07114, 32.59021]]], [[[-117.05145, 32.59104], [-117.05145, 32.59113], [-117.05034, 32.59112], [-117.05034, 32.59103], [-117.05145, 32.59104]]], [[[-117.04928, 32.58936], [-117.04829, 32.58936], [-117.04829, 32.5878], [-117.04827, 32.58738], [-117.04815, 32.58739], [-117.04815, 32.58946], [-117.04715, 32.58946], [-117.04716, 32.58898], [-117.04617, 32.58897], [-117.04617, 32.5874], [-117.04603, 32.5874], [-117.04602, 32.58897], [-117.04503, 32.58897], [-117.04502, 32.58924], [-117.04397, 32.58926], [-117.04398, 32.59108], [-117.04503, 32.59108], [-117.04503, 32.59121], [-117.04077, 32.59126], [-117.04076, 32.59112], [-117.03866, 32.59115], [-117.03865, 32.58747], [-117.045, 32.58741], [-117.045, 32.58713], [-117.04548, 32.58711], [-117.04563, 32.58708], [-117.0458, 32.58697], [-117.04595, 32.58704], [-117.04613, 32.5869], [-117.04629, 32.58682], [-117.04646, 32.5867], [-117.04663, 32.5867], [-117.0468, 32.58666], [-117.04728, 32.58664], [-117.04777, 32.58674], [-117.0479, 32.5867], [-117.04804, 32.58663], [-117.04812, 32.58678], [-117.0482, 32.58684], [-117.04838, 32.58684], [-117.04863, 32.587], [-117.04879, 32.58699], [-117.04895, 32.58703], [-117.04925, 32.58706], [-117.04928, 32.58936]]], [[[-117.03561, 32.59007], [-117.03561, 32.59118], [-117.03231, 32.59122], [-117.03231, 32.59052], [-117.03561, 32.59007]]], [[[-117.06313, 32.59241], [-117.06252, 32.59241], [-117.0625, 32.59211], [-117.06035, 32.59206], [-117.06034, 32.59104], [-117.05813, 32.59103], [-117.05813, 32.58922], [-117.05812, 32.58921], [-117.05701, 32.58922], [-117.057, 32.58915], [-117.0548, 32.58916], [-117.05481, 32.58926], [-117.05701, 32.58926], [-117.05702, 32.59201], [-117.0565, 32.59186], [-117.05648, 32.59076], [-117.05594, 32.59077], [-117.05594, 32.59166], [-117.05381, 32.59167], [-117.05381, 32.59146], [-117.05393, 32.59123], [-117.05394, 32.59116], [-117.05392, 32.5911], [-117.05386, 32.59106], [-117.05372, 32.59105], [-117.05371, 32.58741], [-117.05801, 32.58744], [-117.06057, 32.58744], [-117.06076, 32.58781], [-117.06072, 32.58785], [-117.06078, 32.58853], [-117.06074, 32.58859], [-117.06079, 32.58889], [-117.06092, 32.58917], [-117.06111, 32.58954], [-117.06126, 32.58963], [-117.06137, 32.58984], [-117.06148, 32.58981], [-117.06205, 32.59085], [-117.06195, 32.59089], [-117.062, 32.59099], [-117.06212, 32.59095], [-117.06213, 32.59096], [-117.06219, 32.59106], [-117.06242, 32.59139], [-117.06276, 32.592], [-117.06295, 32.59222], [-117.06313, 32.59241]]], [[[-117.08192, 32.59211], [-117.08125, 32.59221], [-117.0809, 32.5922], [-117.08069, 32.59211], [-117.08063, 32.59204], [-117.08053, 32.59198], [-117.0804, 32.59195], [-117.07977, 32.59191], [-117.07976, 32.59168], [-117.07762, 32.59167], [-117.07761, 32.59203], [-117.07532, 32.59205], [-117.07531, 32.5928], [-117.07527, 32.5928], [-117.07525, 32.59284], [-117.07521, 32.59287], [-117.07437, 32.59287], [-117.07432, 32.59284], [-117.07388, 32.59203], [-117.07393, 32.59203], [-117.07393, 32.59201], [-117.07345, 32.59112], [-117.08191, 32.59115], [-117.08192, 32.59211]]], [[[-117.06506, 32.59281], [-117.06465, 32.5928], [-117.06464, 32.59284], [-117.06461, 32.59284], [-117.06437, 32.59277], [-117.06388, 32.59258], [-117.06355, 32.59238], [-117.06329, 32.59214], [-117.06308, 32.59191], [-117.06295, 32.59167], [-117.0627, 32.59109], [-117.06504, 32.5911], [-117.06506, 32.59281]]], [[[-117.03003, 32.59295], [-117.02946, 32.59306], [-117.02891, 32.59321], [-117.02792, 32.59359], [-117.02792, 32.59302], [-117.02789, 32.59301], [-117.02789, 32.5935], [-117.0277, 32.59349], [-117.02748, 32.59353], [-117.02729, 32.59363], [-117.02715, 32.59375], [-117.02705, 32.59377], [-117.02698, 32.59375], [-117.02694, 32.59371], [-117.02687, 32.59352], [-117.02679, 32.59343], [-117.02667, 32.59334], [-117.02655, 32.59331], [-117.02619, 32.59326], [-117.02519, 32.59335], [-117.02471, 32.59332], [-117.02416, 32.59317], [-117.0232, 32.59297], [-117.0231, 32.59288], [-117.02301, 32.59285], [-117.02188, 32.59273], [-117.02165, 32.59269], [-117.02136, 32.59261], [-117.02018, 32.5925], [-117.01982, 32.59255], [-117.01973, 32.59259], [-117.01966, 32.59265], [-117.01963, 32.5927], [-117.01964, 32.59277], [-117.01978, 32.59293], [-117.01977, 32.59295], [-117.01912, 32.59307], [-117.0188, 32.59305], [-117.01877, 32.59311], [-117.01865, 32.59343], [-117.01727, 32.59308], [-117.01699, 32.59302], [-117.01648, 32.59296], [-117.0159, 32.59295], [-117.01561, 32.59298], [-117.01525, 32.59303], [-117.01448, 32.59321], [-117.01447, 32.59344], [-117.01416, 32.59353], [-117.01374, 32.59361], [-117.01164, 32.59384], [-117.0111, 32.59384], [-117.01087, 32.59383], [-117.01005, 32.59371], [-117.01004, 32.59355], [-117.0074, 32.59311], [-117.00674, 32.59307], [-117.00674, 32.59097], [-117.00749, 32.59106], [-117.00822, 32.59118], [-117.0079, 32.59229], [-117.00852, 32.59242], [-117.00888, 32.59122], [-117.00907, 32.59125], [-117.00954, 32.59112], [-117.01003, 32.59112], [-117.01006, 32.5909], [-117.01447, 32.59108], [-117.03002, 32.59121], [-117.03003, 32.59295]]]]} | Open Access 1 | 7396 | Otay Valley Regional Park | 2353 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.ovrp.org/ | San Diego 4 | 324.371 | Otay Valley RP | 0 | Local Park 2 | 4 |
16308 | 16308 | 16307 | {"type": "MultiPolygon", "coordinates": [[[[-117.0198, 32.82876], [-117.01951, 32.82959], [-117.01936, 32.8301], [-117.01773, 32.83003], [-117.01791, 32.82937], [-117.01801, 32.82935], [-117.01803, 32.82882], [-117.01793, 32.82837], [-117.01781, 32.82808], [-117.01732, 32.82737], [-117.01791, 32.82736], [-117.0198, 32.82876]]], [[[-117.04626, 32.81855], [-117.04598, 32.81888], [-117.04576, 32.81919], [-117.04407, 32.82211], [-117.04113, 32.82749], [-117.04075, 32.82815], [-117.04034, 32.82876], [-117.03996, 32.82928], [-117.03954, 32.82979], [-117.0391, 32.83029], [-117.03793, 32.83145], [-117.03427, 32.83146], [-117.02856, 32.82771], [-117.02747, 32.82882], [-117.02687, 32.82902], [-117.02698, 32.82892], [-117.0266, 32.82839], [-117.02654, 32.82842], [-117.02589, 32.82794], [-117.02548, 32.82847], [-117.02498, 32.82829], [-117.02459, 32.82809], [-117.02386, 32.82757], [-117.02399, 32.82745], [-117.02411, 32.82684], [-117.02346, 32.82662], [-117.02302, 32.82699], [-117.02263, 32.82673], [-117.02249, 32.82686], [-117.02235, 32.82676], [-117.02233, 32.82677], [-117.02208, 32.82659], [-117.01999, 32.82869], [-117.01798, 32.82719], [-117.01706, 32.8272], [-117.01687, 32.82685], [-117.01635, 32.82571], [-117.01586, 32.82388], [-117.01584, 32.82388], [-117.01574, 32.82376], [-117.01563, 32.82364], [-117.01539, 32.82346], [-117.01521, 32.82324], [-117.01505, 32.8231], [-117.01499, 32.823], [-117.01493, 32.82269], [-117.01488, 32.82256], [-117.01458, 32.82224], [-117.01449, 32.82216], [-117.01421, 32.82197], [-117.01183, 32.82066], [-117.01156, 32.82047], [-117.01137, 32.82028], [-117.01119, 32.82005], [-117.01107, 32.81978], [-117.0107, 32.81851], [-117.01061, 32.81816], [-117.0106, 32.81809], [-117.01066, 32.81799], [-117.01075, 32.81793], [-117.01086, 32.81792], [-117.01099, 32.81796], [-117.01107, 32.81805], [-117.01136, 32.81892], [-117.01145, 32.81906], [-117.01158, 32.81921], [-117.01183, 32.81938], [-117.01271, 32.81981], [-117.01289, 32.81988], [-117.01308, 32.81992], [-117.01337, 32.81993], [-117.01361, 32.8199], [-117.01385, 32.81983], [-117.01409, 32.8197], [-117.01425, 32.81957], [-117.01435, 32.81946], [-117.01481, 32.81877], [-117.0147, 32.81871], [-117.01426, 32.81937], [-117.01416, 32.81949], [-117.01399, 32.81963], [-117.01383, 32.81972], [-117.01365, 32.81978], [-117.01341, 32.81982], [-117.01323, 32.81983], [-117.01299, 32.8198], [-117.01277, 32.81972], [-117.0119, 32.81929], [-117.01168, 32.81914], [-117.01156, 32.81899], [-117.01147, 32.81885], [-117.01119, 32.81801], [-117.01113, 32.81792], [-117.01103, 32.81785], [-117.0109, 32.81781], [-117.01075, 32.81782], [-117.01063, 32.81786], [-117.01052, 32.81797], [-117.01048, 32.81805], [-117.01047, 32.81813], [-117.01058, 32.81855], [-117.01023, 32.81751], [-117.00997, 32.81563], [-117.01204, 32.81698], [-117.01391, 32.81818], [-117.0198, 32.8119], [-117.01979, 32.81188], [-117.01937, 32.81159], [-117.01979, 32.81115], [-117.02118, 32.8122], [-117.02174, 32.81214], [-117.02325, 32.81054], [-117.02339, 32.8101], [-117.02316, 32.80969], [-117.02272, 32.80941], [-117.02259, 32.8095], [-117.02245, 32.80957], [-117.02229, 32.80961], [-117.02212, 32.80963], [-117.02193, 32.80962], [-117.02176, 32.80957], [-117.02161, 32.8095], [-117.0215, 32.80942], [-117.0216, 32.80933], [-117.0219, 32.80952], [-117.02312, 32.80816], [-117.02571, 32.80819], [-117.02706, 32.80763], [-117.02759, 32.80851], [-117.02839, 32.80817], [-117.02788, 32.80729], [-117.02849, 32.80704], [-117.02918, 32.80557], [-117.0298, 32.80447], [-117.0313, 32.80375], [-117.03165, 32.80305], [-117.0317, 32.80307], [-117.03622, 32.80401], [-117.03728, 32.80422], [-117.03718, 32.80461], [-117.03774, 32.80471], [-117.0377, 32.80494], [-117.03767, 32.80517], [-117.03767, 32.8054], [-117.03771, 32.80568], [-117.03778, 32.80594], [-117.03785, 32.80614], [-117.03795, 32.80634], [-117.03809, 32.80655], [-117.03832, 32.80684], [-117.03857, 32.80707], [-117.03903, 32.8074], [-117.0394, 32.80757], [-117.03925, 32.80783], [-117.04019, 32.80836], [-117.03971, 32.80914], [-117.03963, 32.80933], [-117.0396, 32.80953], [-117.03959, 32.80986], [-117.03983, 32.81006], [-117.04008, 32.81009], [-117.04005, 32.81052], [-117.04018, 32.81053], [-117.04039, 32.81104], [-117.04042, 32.81119], [-117.04041, 32.81136], [-117.04046, 32.81152], [-117.04087, 32.81226], [-117.04123, 32.81262], [-117.04166, 32.81316], [-117.0432, 32.81475], [-117.04291, 32.8147], [-117.04273, 32.81537], [-117.04315, 32.81545], [-117.0436, 32.81548], [-117.04419, 32.81549], [-117.04512, 32.8158], [-117.04555, 32.8159], [-117.04626, 32.81855]]]]} | Open Access 1 | 1152 | Mission Trails Regional Park | 29248 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.mtrp.org/ | San Diego 4 | 1520.459 | Mission Trails RP | 0 | Local Park 2 | 4 |
15533 | 15533 | 15532 | {"type": "Polygon", "coordinates": [[[-117.0207, 32.5792], [-117.02057, 32.57953], [-117.02033, 32.57995], [-117.02015, 32.57997], [-117.01975, 32.58005], [-117.01946, 32.57923], [-117.01923, 32.57874], [-117.01924, 32.57873], [-117.01922, 32.57857], [-117.01924, 32.57846], [-117.01982, 32.57848], [-117.02008, 32.57856], [-117.02024, 32.57865], [-117.02054, 32.57897], [-117.0207, 32.5792]]]} | Open Access 1 | 46729 | Hidden Trails Neighborhood Park | 30177 | 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 | 3.938 | Hidden Trails Neighborhood Park | 0 | Local Park 2 | 4 | |
15532 | 15532 | 15531 | {"type": "Polygon", "coordinates": [[[-117.1088, 32.74494], [-117.10861, 32.74528], [-117.1085, 32.74535], [-117.10835, 32.74537], [-117.10835, 32.74493], [-117.1088, 32.74494]]]} | Open Access 1 | 46728 | Central Avenue Mini-Park | 30175 | 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.36 | Central Avenue Mini-Park | 0 | Local Park 2 | 4 | |
15453 | 15453 | 15452 | {"type": "Polygon", "coordinates": [[[-117.22179, 32.95088], [-117.2217, 32.95273], [-117.22121, 32.95271], [-117.2213, 32.95086], [-117.22179, 32.95088]]]} | Open Access 1 | 46723 | Carmel Valley Neighborhood Park | 30153 | 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 | 2.309 | Carmel Valley Neighborhood Park | 0 | Local Park 2 | 4 | |
15452 | 15452 | 15451 | {"type": "Polygon", "coordinates": [[[-117.25523, 32.9504], [-117.25392, 32.95174], [-117.25325, 32.95174], [-117.25326, 32.94894], [-117.25483, 32.94943], [-117.25523, 32.9504]]]} | Open Access 1 | 46722 | Crest Canyon Neighborhood Park | 30149 | 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.975 | Crest Canyon Neighborhood Park | 0 | Local Park 2 | 4 | |
15451 | 15451 | 15450 | {"type": "Polygon", "coordinates": [[[-117.10104, 32.96786], [-117.0991, 32.9694], [-117.09768, 32.96813], [-117.0991, 32.96695], [-117.0996, 32.96659], [-117.10104, 32.96786]]]} | No Public Access 3 | 46721 | Penasquitos Village Neighborhood Park | 30267 | 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 | 12.044 | Penasquitos Village Neighborhood Park | 0 | Local Park 2 | 4 | |
15450 | 15450 | 15449 | {"type": "MultiPolygon", "coordinates": [[[[-117.17858, 32.74951], [-117.17846, 32.74951], [-117.17833, 32.74953], [-117.1778, 32.74972], [-117.17753, 32.74977], [-117.17722, 32.74981], [-117.17664, 32.7498], [-117.17662, 32.74843], [-117.17858, 32.74843], [-117.17858, 32.74951]]], [[[-117.18097, 32.74829], [-117.18082, 32.74902], [-117.18034, 32.74958], [-117.18036, 32.74965], [-117.18012, 32.74979], [-117.17996, 32.74991], [-117.17986, 32.75002], [-117.1796, 32.75018], [-117.17902, 32.75026], [-117.17858, 32.75025], [-117.17857, 32.75041], [-117.17691, 32.75042], [-117.17691, 32.75001], [-117.17694, 32.74996], [-117.17698, 32.74994], [-117.17736, 32.74994], [-117.17766, 32.74989], [-117.17785, 32.74984], [-117.17836, 32.74967], [-117.17852, 32.74964], [-117.17858, 32.74964], [-117.17859, 32.74988], [-117.17898, 32.74984], [-117.17938, 32.74976], [-117.17963, 32.74959], [-117.17975, 32.74948], [-117.18086, 32.74818], [-117.18097, 32.74829]]]]} | Open Access 1 | 46720 | Mission Hills Neighborhood Park | 30142 | 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 | 12.537 | Mission Hills Neighborhood Park | 0 | Local Park 2 | 4 | |
15448 | 15448 | 15447 | {"type": "Polygon", "coordinates": [[[-117.25182, 32.75258], [-117.25173, 32.75275], [-117.25162, 32.75308], [-117.25164, 32.75338], [-117.25169, 32.75364], [-117.25108, 32.7537], [-117.2511, 32.75388], [-117.25039, 32.75397], [-117.25039, 32.75404], [-117.25038, 32.75406], [-117.2503, 32.75412], [-117.25024, 32.75413], [-117.25007, 32.75411], [-117.24998, 32.75407], [-117.24955, 32.75381], [-117.24954, 32.75376], [-117.24956, 32.75372], [-117.2496, 32.75371], [-117.24996, 32.75392], [-117.25129, 32.7535], [-117.25129, 32.75348], [-117.25098, 32.75326], [-117.25166, 32.75248], [-117.25182, 32.75258]]]} | Open Access 1 | 46747 | Brighton Park | 30199 | 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 | 2.179 | Brighton Park | 0 | Local Park 2 | 4 | |
15447 | 15447 | 15446 | {"type": "Polygon", "coordinates": [[[-117.08407, 32.90975], [-117.08285, 32.91131], [-117.08227, 32.91152], [-117.08215, 32.91178], [-117.08151, 32.91225], [-117.0807, 32.9115], [-117.081, 32.91127], [-117.08117, 32.9111], [-117.08126, 32.91097], [-117.08159, 32.91042], [-117.08168, 32.91032], [-117.08181, 32.91023], [-117.08259, 32.90987], [-117.08272, 32.90977], [-117.08284, 32.90966], [-117.08285, 32.90976], [-117.08407, 32.90975]]]} | Open Access 1 | 46719 | Jerabek Neighborhood Park | 30141 | 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.686 | Jerabek Neighborhood Park | 0 | Local Park 2 | 4 | |
15446 | 15446 | 15445 | {"type": "Polygon", "coordinates": [[[-117.09001, 32.91792], [-117.08908, 32.91922], [-117.08685, 32.91954], [-117.08692, 32.91885], [-117.08673, 32.91863], [-117.0868, 32.91854], [-117.08681, 32.91846], [-117.0868, 32.9184], [-117.08649, 32.91803], [-117.08638, 32.91793], [-117.08627, 32.91787], [-117.08616, 32.91784], [-117.08594, 32.91784], [-117.08584, 32.91733], [-117.09001, 32.91792]]]} | Open Access 1 | 46718 | Lakeview Neighborhood Park | 30139 | 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 | 13.209 | Lakeview Neighborhood Park | 0 | Local Park 2 | 4 | |
15445 | 15445 | 15444 | {"type": "Polygon", "coordinates": [[[-117.15805, 32.90687], [-117.15726, 32.90718], [-117.15701, 32.90724], [-117.15673, 32.90726], [-117.15644, 32.90724], [-117.15618, 32.90717], [-117.15598, 32.90709], [-117.15558, 32.90688], [-117.1571, 32.90586], [-117.15788, 32.90663], [-117.15792, 32.90663], [-117.15805, 32.90687]]]} | Open Access 1 | 46716 | Maddox Neighborhood Park | 30135 | 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.813 | Maddox Neighborhood Park | 0 | Local Park 2 | 4 | |
15444 | 15444 | 15443 | {"type": "Polygon", "coordinates": [[[-117.06668, 32.92666], [-117.06635, 32.92652], [-117.0662, 32.9265], [-117.06611, 32.92647], [-117.0658, 32.9261], [-117.06543, 32.9259], [-117.06515, 32.92583], [-117.06473, 32.92578], [-117.06454, 32.92587], [-117.06445, 32.92554], [-117.06413, 32.92492], [-117.06408, 32.92478], [-117.064, 32.92445], [-117.06399, 32.92422], [-117.06401, 32.92418], [-117.06407, 32.92416], [-117.06623, 32.92412], [-117.06647, 32.92415], [-117.06668, 32.92421], [-117.06668, 32.92666]]]} | Open Access 1 | 46715 | Cypress Canyon Neighborhood Park | 30133 | 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 | 12.247 | Cypress Canyon Neighborhood Park | 0 | Local Park 2 | 4 | |
15443 | 15443 | 15442 | {"type": "Polygon", "coordinates": [[[-117.10348, 32.93727], [-117.10176, 32.93719], [-117.10182, 32.93612], [-117.10206, 32.93613], [-117.10236, 32.93608], [-117.10259, 32.93596], [-117.1033, 32.93611], [-117.10321, 32.93674], [-117.10325, 32.93692], [-117.10335, 32.93705], [-117.10348, 32.93713], [-117.10348, 32.93727]]]} | Open Access 1 | 46714 | Miramar Ranch North Park | 30132 | 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.475 | Miramar Ranch North Park | 0 | Local Park 2 | 4 | |
15442 | 15442 | 15441 | {"type": "Polygon", "coordinates": [[[-117.07969, 32.92398], [-117.07969, 32.92402], [-117.07952, 32.92402], [-117.07932, 32.92405], [-117.07894, 32.92421], [-117.07843, 32.92435], [-117.07823, 32.92439], [-117.07812, 32.92435], [-117.07799, 32.92414], [-117.07796, 32.92413], [-117.0781, 32.92372], [-117.0786, 32.92382], [-117.07969, 32.92398]]]} | Open Access 1 | 46713 | Canyon View Mini-Park | 30131 | 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.504 | Canyon View Mini-Park | 0 | Local Park 2 | 4 | |
15441 | 15441 | 15440 | {"type": "Polygon", "coordinates": [[[-117.11749, 32.94559], [-117.11634, 32.9473], [-117.11585, 32.94711], [-117.11559, 32.94678], [-117.11529, 32.94682], [-117.11529, 32.94667], [-117.11535, 32.94652], [-117.11607, 32.9455], [-117.11609, 32.94537], [-117.11606, 32.94529], [-117.11602, 32.94523], [-117.11665, 32.94433], [-117.11711, 32.94477], [-117.11749, 32.94559]]]} | Open Access 1 | 46712 | Ridgewood Neighborhood Park | 30124 | 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 | 8.338 | Ridgewood Neighborhood Park | 0 | Local Park 2 | 4 | |
15440 | 15440 | 15439 | {"type": "Polygon", "coordinates": [[[-117.10802, 32.75155], [-117.10801, 32.75176], [-117.1075, 32.75174], [-117.10749, 32.75181], [-117.10703, 32.7518], [-117.10703, 32.75154], [-117.10802, 32.75155]]]} | Open Access 1 | 46711 | Central Neighborhood Park | 30120 | 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.589 | Central Neighborhood Park | 0 | Local Park 2 | 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]);