units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
23 rows where COUNTY = 4 and MNG_AG_TYP = 13 sorted by SUID_NMA
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_WEB, MNG_AG_ID, PARK_URL, LABEL_NAME, GAP_STS
MNG_AGENCY 12
- Helix Water District 4
- Olivenhain Municipal Water District 4
- Ramona Municipal Water District 4
- Valley Center Water District 2
- San Diego County Water Authority 2
- Yuima Municipal Water District 1
- Borrego Water District 1
- Vallecitos Water District 1
- Fallbrook Public Utility District 1
- Rainbow Municipal Water District 1
- Otay Water District 1
- Padre Dam Municipal Water District 1
DES_TP 7
ACCESS_TYP 4
MNG_AG_TYP 1
- Water District · 23 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7625 | 7625 | 7624 | {"type": "MultiPolygon", "coordinates": [[[[-116.89597, 32.87039], [-116.89476, 32.87018], [-116.89394, 32.86984], [-116.89368, 32.86962], [-116.89373, 32.86769], [-116.89372, 32.8676], [-116.89368, 32.86751], [-116.89596, 32.8658], [-116.89597, 32.87039]]], [[[-116.8936, 32.86756], [-116.89363, 32.86765], [-116.89364, 32.86772], [-116.89358, 32.86986], [-116.89357, 32.87022], [-116.8935, 32.87096], [-116.89335, 32.87089], [-116.89337, 32.86769], [-116.8936, 32.86756]]], [[[-116.90722, 32.87069], [-116.90714, 32.87081], [-116.90694, 32.87096], [-116.9067, 32.87108], [-116.90642, 32.87116], [-116.90433, 32.87136], [-116.90416, 32.87142], [-116.90402, 32.87153], [-116.90394, 32.87156], [-116.90374, 32.87154], [-116.90353, 32.87154], [-116.9031, 32.87161], [-116.90292, 32.87158], [-116.90311, 32.87154], [-116.90357, 32.87148], [-116.90722, 32.87069]]], [[[-116.9141, 32.87162], [-116.91382, 32.87179], [-116.91141, 32.87297], [-116.91112, 32.87314], [-116.91085, 32.87334], [-116.91053, 32.87314], [-116.90986, 32.87079], [-116.9098, 32.87051], [-116.911, 32.87044], [-116.91101, 32.87046], [-116.91262, 32.87037], [-116.91342, 32.87076], [-116.9141, 32.87162]]], [[[-116.91044, 32.87316], [-116.9095, 32.87297], [-116.90915, 32.8728], [-116.90863, 32.87251], [-116.90752, 32.87279], [-116.907, 32.87282], [-116.90671, 32.87288], [-116.90642, 32.87407], [-116.90624, 32.87408], [-116.90616, 32.87428], [-116.89855, 32.87272], [-116.89856, 32.87268], [-116.89732, 32.87243], [-116.89706, 32.87241], [-116.89353, 32.87168], [-116.89367, 32.87022], [-116.89368, 32.8699], [-116.8939, 32.86992], [-116.89473, 32.87026], [-116.89597, 32.87048], [-116.89598, 32.87065], [-116.89695, 32.87065], [-116.90083, 32.87134], [-116.90228, 32.87168], [-116.90277, 32.87162], [-116.90289, 32.87166], [-116.90308, 32.87169], [-116.90317, 32.87169], [-116.90353, 32.87162], [-116.90398, 32.87164], [-116.90407, 32.8716], [-116.90423, 32.87148], [-116.90434, 32.87144], [-116.9064, 32.87125], [-116.90675, 32.87114], [-116.90701, 32.87102], [-116.90723, 32.87085], [-116.90732, 32.87071], [-116.90868, 32.87084], [-116.90869, 32.87061], [-116.90969, 32.87057], [-116.91044, 32.87316]]], [[[-116.89566, 32.85751], [-116.89342, 32.85751], [-116.89337, 32.86613], [-116.89403, 32.86614], [-116.89453, 32.8666], [-116.89341, 32.86746], [-116.89309, 32.86763], [-116.89281, 32.86773], [-116.89247, 32.86779], [-116.88826, 32.86821], [-116.88772, 32.86836], [-116.8872, 32.86856], [-116.88693, 32.86869], [-116.88665, 32.86886], [-116.88641, 32.86902], [-116.88619, 32.8692], [-116.88407, 32.87126], [-116.88377, 32.8715], [-116.8838, 32.87152], [-116.88366, 32.87162], [-116.88345, 32.87173], [-116.88137, 32.87279], [-116.87889, 32.87367], [-116.87932, 32.87229], [-116.87972, 32.87225], [-116.88025, 32.87202], [-116.88125, 32.87055], [-116.88162, 32.87025], [-116.88244, 32.87025], [-116.88265, 32.86987], [-116.88297, 32.86966], [-116.88326, 32.86961], [-116.88365, 32.86925], [-116.88417, 32.86927], [-116.88457, 32.86898], [-116.8847, 32.86881], [-116.88481, 32.86856], [-116.88521, 32.8681], [-116.88563, 32.86776], [-116.88464, 32.86714], [-116.88375, 32.86786], [-116.88283, 32.86782], [-116.88159, 32.86525], [-116.8793, 32.86382], [-116.87858, 32.86447], [-116.8772, 32.86408], [-116.87506, 32.86273], [-116.87552, 32.86146], [-116.87521, 32.86087], [-116.87619, 32.85707], [-116.88026, 32.85584], [-116.88051, 32.85553], [-116.88632, 32.85219], [-116.88653, 32.85219], [-116.88651, 32.85209], [-116.88706, 32.85177], [-116.88728, 32.85168], [-116.88727, 32.85164], [-116.89303, 32.85161], [-116.89312, 32.85162], [-116.89318, 32.85187], [-116.89321, 32.85207], [-116.89321, 32.85233], [-116.89313, 32.85388], [-116.89316, 32.85389], [-116.89312, 32.85479], [-116.89315, 32.85519], [-116.8933, 32.85562], [-116.89339, 32.85582], [-116.89353, 32.85604], [-116.8935, 32.85607], [-116.89356, 32.85615], [-116.89377, 32.85641], [-116.89406, 32.85669], [-116.89443, 32.85694], [-116.89478, 32.85712], [-116.89509, 32.85723], [-116.89566, 32.8574], [-116.89566, 32.85751]], [[-116.87569, 32.86125], [-116.87566, 32.86122], [-116.87564, 32.86129], [-116.87565, 32.8613], [-116.87569, 32.86125]], [[-116.89257, 32.85521], [-116.89264, 32.85472], [-116.89281, 32.85399], [-116.89287, 32.85387], [-116.89287, 32.85382], [-116.89263, 32.8533], [-116.89246, 32.85282], [-116.89244, 32.85278], [-116.89238, 32.85277], [-116.89219, 32.85284], [-116.89196, 32.85287], [-116.89176, 32.85284], [-116.89158, 32.85278], [-116.89153, 32.85291], [-116.89133, 32.85319], [-116.89125, 32.85326], [-116.89096, 32.85343], [-116.89087, 32.85376], [-116.89061, 32.85412], [-116.89044, 32.85425], [-116.89029, 32.85431], [-116.89012, 32.85433], [-116.88938, 32.8543], [-116.88926, 32.85426], [-116.88916, 32.85419], [-116.88882, 32.85383], [-116.88879, 32.85375], [-116.88878, 32.85331], [-116.88928, 32.85235], [-116.88929, 32.85231], [-116.88927, 32.85227], [-116.88923, 32.85223], [-116.88916, 32.85222], [-116.88885, 32.85227], [-116.88866, 32.85233], [-116.88852, 32.85233], [-116.88841, 32.85229], [-116.88806, 32.85205], [-116.88791, 32.85197], [-116.88772, 32.85193], [-116.8874, 32.8519], [-116.88786, 32.85277], [-116.88822, 32.85433], [-116.88994, 32.85587], [-116.89049, 32.85576], [-116.89165, 32.85541], [-116.89235, 32.85525], [-116.89257, 32.85521]]], [[[-116.87838, 32.87524], [-116.87776, 32.87717], [-116.87721, 32.87745], [-116.87688, 32.87753], [-116.87649, 32.87781], [-116.87572, 32.87826], [-116.87552, 32.8784], [-116.87503, 32.87865], [-116.87451, 32.87887], [-116.87407, 32.87889], [-116.8736, 32.87912], [-116.87321, 32.87926], [-116.87272, 32.8794], [-116.8687, 32.88009], [-116.86809, 32.88028], [-116.8676, 32.88032], [-116.86711, 32.88046], [-116.86657, 32.88055], [-116.86648, 32.88062], [-116.86503, 32.88129], [-116.86441, 32.88154], [-116.86402, 32.88174], [-116.86353, 32.88218], [-116.86295, 32.88257], [-116.86253, 32.88296], [-116.8622, 32.88334], [-116.86116, 32.88209], [-116.86121, 32.8821], [-116.8613, 32.882], [-116.86116, 32.8819], [-116.8627, 32.88022], [-116.86377, 32.87955], [-116.86596, 32.87879], [-116.86809, 32.87822], [-116.86833, 32.87821], [-116.86854, 32.87823], [-116.87011, 32.87865], [-116.87025, 32.87868], [-116.8704, 32.87868], [-116.87161, 32.87855], [-116.87187, 32.8785], [-116.87214, 32.8784], [-116.87436, 32.87714], [-116.87441, 32.87722], [-116.87644, 32.87617], [-116.8765, 32.87622], [-116.87838, 32.87524]]], [[[-116.89333, 32.87218], [-116.89332, 32.87414], [-116.89247, 32.87416], [-116.89256, 32.88587], [-116.88717, 32.88725], [-116.88716, 32.87491], [-116.88715, 32.87491], [-116.8869, 32.87517], [-116.88683, 32.87519], [-116.88694, 32.87509], [-116.88704, 32.87493], [-116.88835, 32.87341], [-116.88883, 32.8729], [-116.8892, 32.87214], [-116.8893, 32.87206], [-116.88935, 32.87197], [-116.8894, 32.87196], [-116.88959, 32.87186], [-116.88964, 32.87185], [-116.8897, 32.87187], [-116.89017, 32.87182], [-116.89155, 32.87191], [-116.89333, 32.87218]]], [[[-116.86247, 32.88343], [-116.85911, 32.88809], [-116.85952, 32.88861], [-116.85953, 32.88893], [-116.85734, 32.89051], [-116.85709, 32.88997], [-116.85714, 32.88955], [-116.85743, 32.88911], [-116.85776, 32.88849], [-116.85854, 32.88762], [-116.8584, 32.88744], [-116.8623, 32.88345], [-116.86247, 32.88343]]]]} | Open Access 1 | 7358 | Lake Jennings Park | 4419 | 2046 | Helix Water District 777 | Special District 4 | Water District 13 | http://www.hwd.com | Special District 4 | 2046 | Helix Water District 757 | Special District 4 | Water District 13 | http://lakejennings.org/ | San Diego 4 | 1018.243 | Lake Jennings Park | 0 | Local Park 2 | 4 |
8103 | 8103 | 8102 | {"type": "Polygon", "coordinates": [[[-117.00113, 33.02272], [-117.00105, 33.02745], [-117.00102, 33.03009], [-116.9965, 33.03013], [-116.99651, 33.0372], [-116.99193, 33.03718], [-116.99194, 33.03505], [-116.99136, 33.03484], [-116.99041, 33.03574], [-116.99007, 33.03663], [-116.98814, 33.03668], [-116.98782, 33.0369], [-116.98779, 33.03901], [-116.9876, 33.0392], [-116.98747, 33.03926], [-116.98734, 33.03926], [-116.98698, 33.03914], [-116.9869, 33.03914], [-116.98679, 33.03919], [-116.98641, 33.03954], [-116.98604, 33.0395], [-116.98595, 33.0395], [-116.98581, 33.03953], [-116.98564, 33.03953], [-116.98553, 33.0395], [-116.9854, 33.03943], [-116.98519, 33.03935], [-116.98464, 33.0393], [-116.98442, 33.03926], [-116.98428, 33.0392], [-116.98404, 33.03905], [-116.98396, 33.03902], [-116.98461, 33.03854], [-116.9856, 33.03786], [-116.98499, 33.03754], [-116.98499, 33.03716], [-116.98474, 33.03716], [-116.98472, 33.03536], [-116.98542, 33.03536], [-116.98717, 33.03356], [-116.98316, 33.03353], [-116.98315, 33.02731], [-116.98313, 33.02609], [-116.98749, 33.02618], [-116.98755, 33.02902], [-116.98757, 33.02903], [-116.98959, 33.02861], [-116.99067, 33.02822], [-116.9913, 33.02777], [-116.99131, 33.02676], [-116.99153, 33.02626], [-116.99197, 33.02626], [-116.99197, 33.02538], [-116.99226, 33.02477], [-116.99312, 33.02414], [-116.99244, 33.02338], [-116.99242, 33.02251], [-116.99657, 33.02259], [-116.99655, 33.02181], [-117.00002, 33.02187], [-117.00113, 33.02272]]]} | Open Access 1 | 12142 | Lake Ramona | 8896 | 2116 | Ramona Municipal Water District 872 | Special District 4 | Water District 13 | http://www.rmwd.org/ | Special District 4 | 2116 | Ramona Municipal Water District 850 | Special District 4 | Water District 13 | http://www.rmwd.org/lake-ramona | San Diego 4 | 469.886 | Lake Ramona | None 676 | ||
14634 | 14634 | 14633 | {"type": "Polygon", "coordinates": [[[-116.98411, 32.96667], [-116.9839, 32.97035], [-116.97907, 32.97043], [-116.97914, 32.9667], [-116.98411, 32.96667]]]} | No Public Access 3 | 44863 | CWA Open Space | 17869 | 2132 | San Diego County Water Authority 873 | Special District 4 | Water District 13 | http://www.sdcwa.org/ | Special District 4 | 2132 | San Diego County Water Authority 851 | Special District 4 | Water District 13 | San Diego 4 | 46.559 | CWA OS | 0 | Local Recreation Area 3 | 4 | |
5974 | 5974 | 5973 | {"type": "Polygon", "coordinates": [[[-116.99133, 32.78393], [-116.99033, 32.78407], [-116.9903, 32.78611], [-116.9902, 32.78659], [-116.99031, 32.78666], [-116.98969, 32.78726], [-116.98908, 32.7869], [-116.98894, 32.78687], [-116.98882, 32.78688], [-116.98873, 32.78691], [-116.98866, 32.78696], [-116.9883, 32.78737], [-116.98484, 32.78841], [-116.98451, 32.78765], [-116.98457, 32.78745], [-116.98513, 32.78701], [-116.98552, 32.78636], [-116.98551, 32.78634], [-116.98504, 32.78641], [-116.98498, 32.78634], [-116.98558, 32.78624], [-116.98632, 32.78621], [-116.9863, 32.78563], [-116.9861, 32.78543], [-116.98482, 32.78557], [-116.9848, 32.78547], [-116.98471, 32.78547], [-116.98442, 32.78522], [-116.9846, 32.78505], [-116.98456, 32.78493], [-116.98762, 32.78417], [-116.98785, 32.78409], [-116.98887, 32.78392], [-116.99128, 32.78386], [-116.99133, 32.78393]]]} | Open Access 1 | 649 | Harry Griffen Park | 19707 | 2046 | Helix Water District 777 | Special District 4 | Water District 13 | http://www.hwd.com | Special District 4 | 2046 | Helix Water District 757 | Special District 4 | Water District 13 | http://www.cityoflamesa.com/391/Harry-Griffen-Regional-Park | San Diego 4 | 44.251 | Harry Griffen Park | 0 | Local Park 2 | 4 |
7600 | 7600 | 7599 | {"type": "MultiPolygon", "coordinates": [[[[-117.14622, 33.06563], [-117.14613, 33.06566], [-117.14588, 33.06585], [-117.14528, 33.06607], [-117.14395, 33.06651], [-117.14403, 33.07291], [-117.1354, 33.07289], [-117.13529, 33.06938], [-117.13397, 33.06938], [-117.13526, 33.06843], [-117.13522, 33.06723], [-117.13565, 33.06722], [-117.13627, 33.06627], [-117.13698, 33.06604], [-117.13697, 33.0657], [-117.13751, 33.0657], [-117.13751, 33.06452], [-117.13871, 33.06451], [-117.13873, 33.06569], [-117.13792, 33.06571], [-117.13792, 33.06788], [-117.1387, 33.06788], [-117.13956, 33.06701], [-117.14139, 33.06701], [-117.14343, 33.06567], [-117.14394, 33.06566], [-117.14474, 33.0654], [-117.14511, 33.06555], [-117.14583, 33.06531], [-117.14593, 33.06542], [-117.14622, 33.06563]], [[-117.1405, 33.06924], [-117.13933, 33.06837], [-117.1387, 33.06896], [-117.14006, 33.06987], [-117.14072, 33.06942], [-117.1405, 33.06924]]], [[[-117.15278, 33.06829], [-117.15233, 33.06861], [-117.15156, 33.06775], [-117.15135, 33.06683], [-117.1491, 33.06683], [-117.1486, 33.06657], [-117.1484, 33.06641], [-117.14826, 33.06634], [-117.14797, 33.06626], [-117.14766, 33.06624], [-117.14749, 33.06621], [-117.14727, 33.06613], [-117.1463, 33.06547], [-117.14695, 33.06537], [-117.14755, 33.06577], [-117.14788, 33.0658], [-117.14829, 33.06591], [-117.14858, 33.06605], [-117.14921, 33.06644], [-117.15176, 33.06643], [-117.15202, 33.06758], [-117.15242, 33.06802], [-117.15277, 33.06777], [-117.15278, 33.06829]]], [[[-117.15278, 33.06896], [-117.15241, 33.0692], [-117.15221, 33.06918], [-117.15201, 33.06897], [-117.1524, 33.06871], [-117.15278, 33.06843], [-117.15278, 33.06896]]]]} | No Public Access 3 | 7312 | Olivenhain Dam | 23133 | 2102 | Olivenhain Municipal Water District 871 | Special District 4 | Water District 13 | http://www.olivenhain.com/ | Special District 4 | 2102 | Olivenhain Municipal Water District 849 | Special District 4 | Water District 13 | San Diego 4 | 153.269 | Olivenhain Dam | None 632 | |||
7601 | 7601 | 7600 | {"type": "MultiPolygon", "coordinates": [[[[-117.13327, 33.06758], [-117.13262, 33.068], [-117.13262, 33.068], [-117.13262, 33.06788], [-117.13279, 33.06775], [-117.13327, 33.06758]]], [[[-117.13526, 33.06843], [-117.13397, 33.06938], [-117.13266, 33.06938], [-117.13262, 33.06807], [-117.13345, 33.06764], [-117.13364, 33.06788], [-117.13524, 33.06788], [-117.13526, 33.06843]]], [[[-117.14073, 33.06941], [-117.14006, 33.06987], [-117.13869, 33.06896], [-117.13932, 33.06837], [-117.14073, 33.06941]]]]} | No Public Access 3 | 7313 | Olivenhain Dam | 23134 | 2132 | San Diego County Water Authority 873 | Special District 4 | Water District 13 | http://www.sdcwa.org/ | Special District 4 | 2132 | San Diego County Water Authority 851 | Special District 4 | Water District 13 | San Diego 4 | 12.229 | Olivenhain Dam | 0 | None 633 | ||
14812 | 14812 | 14811 | {"type": "Polygon", "coordinates": [[[-117.16355, 33.32333], [-117.16351, 33.3234], [-117.1635, 33.32347], [-117.16199, 33.32369], [-117.16233, 33.32531], [-117.16102, 33.32539], [-117.1606, 33.32476], [-117.16061, 33.32239], [-117.16165, 33.32151], [-117.16302, 33.32258], [-117.16335, 33.32234], [-117.16355, 33.32333]]]} | No Public Access 3 | 45232 | Rainbow Municipal Water Distrt Open Space | 24086 | 2328 | Rainbow Municipal Water District 1123 | Special District 4 | Water District 13 | http://www.rainbowmwd.com/ | Special District 4 | 2328 | Rainbow Municipal Water District 1078 | Special District 4 | Water District 13 | San Diego 4 | 17.723 | Rainbow Municipal Water Distrt OS | 0 | Local Recreation Area 3 | 4 | |
7595 | 7595 | 7594 | {"type": "Polygon", "coordinates": [[[-116.86604, 33.04765], [-116.86554, 33.04884], [-116.86364, 33.05037], [-116.86232, 33.05145], [-116.86204, 33.05224], [-116.86159, 33.05221], [-116.86084, 33.05337], [-116.86084, 33.05339], [-116.86097, 33.0534], [-116.8608, 33.05395], [-116.86146, 33.05401], [-116.86117, 33.05486], [-116.86048, 33.05672], [-116.86059, 33.05849], [-116.85365, 33.05849], [-116.85484, 33.05303], [-116.85811, 33.05115], [-116.85865, 33.05083], [-116.85875, 33.05087], [-116.8589, 33.05087], [-116.85908, 33.05081], [-116.86068, 33.04987], [-116.86107, 33.04962], [-116.86262, 33.04877], [-116.86263, 33.04875], [-116.86255, 33.04865], [-116.86554, 33.04701], [-116.86604, 33.04765]]]} | Open Access 1 | 7305 | Ramona Community Park | 24111 | 2116 | Ramona Municipal Water District 872 | Special District 4 | Water District 13 | http://www.rmwd.org/ | Special District 4 | 2116 | Ramona Municipal Water District 850 | Special District 4 | Water District 13 | San Diego 4 | 148.594 | Ramona Community Park | 0 | Local Park 2 | 4 | |
14807 | 14807 | 14806 | {"type": "Polygon", "coordinates": [[[-116.93609, 33.0511], [-116.92755, 33.05108], [-116.92754, 33.04241], [-116.93205, 33.04305], [-116.93259, 33.04035], [-116.92753, 33.03962], [-116.92753, 33.03643], [-116.93601, 33.03655], [-116.93601, 33.04036], [-116.93609, 33.0511]]]} | Unknown Access 4 | 45223 | Ramona Municipal Water District | 24117 | 2116 | Ramona Municipal Water District 872 | Special District 4 | Water District 13 | http://www.rmwd.org/ | Special District 4 | 2116 | Ramona Municipal Water District 850 | Special District 4 | Water District 13 | San Diego 4 | 283.724 | Ramona Municipal Water District | 0 | Local Other or Unknown 14 | 4 | |
14808 | 14808 | 14807 | {"type": "Polygon", "coordinates": [[[-117.00394, 33.01294], [-117.00388, 33.01486], [-117.00029, 33.01496], [-117.00055, 33.01283], [-117.00251, 33.0123], [-117.00285, 33.01294], [-117.00394, 33.01294]]]} | Unknown Access 4 | 45224 | Ramona Municipal Water District | 24117 | 2116 | Ramona Municipal Water District 872 | Special District 4 | Water District 13 | http://www.rmwd.org/ | Special District 4 | 2116 | Ramona Municipal Water District 850 | Special District 4 | Water District 13 | San Diego 4 | 19.711 | Ramona Municipal Water District | 0 | Local Other or Unknown 14 | 4 | |
16299 | 16299 | 16298 | {"type": "MultiPolygon", "coordinates": [[[[-117.00698, 32.8493], [-117.00696, 32.8538], [-117.00784, 32.85577], [-117.00829, 32.85706], [-117.00841, 32.8577], [-117.00898, 32.86045], [-117.00905, 32.86085], [-117.00751, 32.86158], [-117.00743, 32.86121], [-117.00733, 32.8609], [-117.00661, 32.85925], [-117.00645, 32.8588], [-117.00637, 32.85845], [-117.00477, 32.84968], [-117.00476, 32.84959], [-117.00497, 32.84953], [-117.00472, 32.84888], [-117.00453, 32.84889], [-117.00424, 32.84725], [-117.00411, 32.84585], [-117.00392, 32.8452], [-117.00418, 32.84515], [-117.00444, 32.84493], [-117.00432, 32.84443], [-117.00441, 32.84444], [-117.00473, 32.84442], [-117.0048, 32.84446], [-117.00484, 32.84453], [-117.00501, 32.84451], [-117.005, 32.84441], [-117.00506, 32.84436], [-117.00548, 32.84432], [-117.00554, 32.84434], [-117.00558, 32.8444], [-117.00574, 32.84438], [-117.00573, 32.84428], [-117.00587, 32.84425], [-117.00601, 32.84469], [-117.00645, 32.84462], [-117.00691, 32.84606], [-117.00698, 32.8493]]], [[[-117.00923, 32.86438], [-117.00906, 32.86491], [-117.00844, 32.86624], [-117.00817, 32.86642], [-117.0076, 32.86635], [-117.00738, 32.86624], [-117.00703, 32.86596], [-117.00697, 32.86578], [-117.00795, 32.86413], [-117.00825, 32.8639], [-117.00917, 32.8642], [-117.00923, 32.86438]]]]} | Open Access 1 | 193 | Santee Lakes Regional Park | 25150 | 2106 | Padre Dam Municipal Water District 1170 | Special District 4 | Water District 13 | http://www.padredam.org/ | Special District 4 | 2106 | Padre Dam Municipal Water District 1109 | Special District 4 | Water District 13 | http://www.santeelakes.com/ | San Diego 4 | 99.056 | Santee Lakes RP | 0 | Local Park 2 | 4 |
8366 | 8366 | 8365 | {"type": "MultiPolygon", "coordinates": [[[[-117.18387, 33.06916], [-117.18373, 33.06922], [-117.18365, 33.06932], [-117.18344, 33.07003], [-117.18341, 33.07029], [-117.18336, 33.07037], [-117.18326, 33.07043], [-117.18318, 33.07045], [-117.18309, 33.07045], [-117.18301, 33.07043], [-117.18294, 33.07039], [-117.18275, 33.07017], [-117.18254, 33.06981], [-117.1824, 33.06968], [-117.18218, 33.06958], [-117.18192, 33.06954], [-117.18178, 33.06956], [-117.18174, 33.0696], [-117.18151, 33.0701], [-117.18141, 33.07027], [-117.18136, 33.07032], [-117.1812, 33.07042], [-117.1811, 33.07045], [-117.18043, 33.0706], [-117.18028, 33.07002], [-117.18012, 33.0692], [-117.18003, 33.06895], [-117.17992, 33.06872], [-117.17978, 33.06849], [-117.17962, 33.06828], [-117.17868, 33.06726], [-117.17963, 33.06745], [-117.18029, 33.06709], [-117.18124, 33.06728], [-117.18187, 33.06772], [-117.18368, 33.06734], [-117.18365, 33.06748], [-117.18206, 33.06821], [-117.1829, 33.06886], [-117.18303, 33.06925], [-117.18341, 33.06973], [-117.18342, 33.06972], [-117.18351, 33.06935], [-117.18357, 33.06925], [-117.18366, 33.06916], [-117.18377, 33.0691], [-117.18385, 33.0691], [-117.18387, 33.06916]]], [[[-117.19147, 33.06983], [-117.19147, 33.07279], [-117.18792, 33.07272], [-117.18861, 33.07056], [-117.18953, 33.07], [-117.18955, 33.06987], [-117.18959, 33.06977], [-117.18967, 33.06969], [-117.18991, 33.06953], [-117.18996, 33.06945], [-117.18997, 33.06936], [-117.19039, 33.06936], [-117.19051, 33.06954], [-117.19066, 33.06972], [-117.19077, 33.06983], [-117.1909, 33.06989], [-117.19107, 33.06991], [-117.19147, 33.06983]]], [[[-117.19582, 33.06557], [-117.19572, 33.07105], [-117.19575, 33.07289], [-117.19572, 33.07671], [-117.19463, 33.07669], [-117.19462, 33.07288], [-117.19238, 33.07281], [-117.19238, 33.0728], [-117.1925, 33.07226], [-117.19265, 33.0719], [-117.19286, 33.0715], [-117.19317, 33.07106], [-117.19333, 33.07088], [-117.19355, 33.07066], [-117.19383, 33.07071], [-117.1941, 33.07069], [-117.19437, 33.0706], [-117.1946, 33.07045], [-117.19473, 33.07031], [-117.19533, 33.06926], [-117.19312, 33.06831], [-117.19276, 33.06678], [-117.1915, 33.06679], [-117.19016, 33.06706], [-117.19071, 33.06551], [-117.1907, 33.0655], [-117.18733, 33.06546], [-117.18032, 33.06543], [-117.18024, 33.06347], [-117.17941, 33.06231], [-117.17797, 33.0623], [-117.17796, 33.06231], [-117.17798, 33.06244], [-117.17603, 33.06242], [-117.17442, 33.06314], [-117.17441, 33.06186], [-117.17988, 33.06189], [-117.18201, 33.06488], [-117.18723, 33.0649], [-117.18724, 33.06429], [-117.19045, 33.06383], [-117.19209, 33.06309], [-117.19233, 33.0636], [-117.19277, 33.06357], [-117.19333, 33.06389], [-117.1936, 33.0645], [-117.19346, 33.06478], [-117.19502, 33.06533], [-117.19514, 33.06543], [-117.19531, 33.06551], [-117.19539, 33.06553], [-117.19582, 33.06553], [-117.19582, 33.06557]]], [[[-117.20097, 33.07956], [-117.20047, 33.08043], [-117.19958, 33.08044], [-117.20028, 33.08074], [-117.1994, 33.08154], [-117.19938, 33.08409], [-117.19718, 33.08404], [-117.19637, 33.08404], [-117.19471, 33.08541], [-117.19466, 33.08403], [-117.1907, 33.08402], [-117.19073, 33.08041], [-117.19861, 33.08043], [-117.19921, 33.07967], [-117.19883, 33.0795], [-117.19929, 33.07918], [-117.20046, 33.07911], [-117.20097, 33.07956]]]]} | No Public Access 3 | 12964 | Second San Diego Aqueduct | 25278 | 2102 | Olivenhain Municipal Water District 871 | Special District 4 | Water District 13 | http://www.olivenhain.com/ | Special District 4 | 2102 | Olivenhain Municipal Water District 849 | Special District 4 | Water District 13 | San Diego 4 | 253.17 | Second San Diego Aqueduct | 0 | Local Other or Unknown 14 | 4 | |
14757 | 14757 | 14756 | {"type": "MultiPolygon", "coordinates": [[[[-117.08543, 33.22613], [-117.08543, 33.22629], [-117.08327, 33.22627], [-117.08316, 33.22632], [-117.08297, 33.22611], [-117.08291, 33.22611], [-117.08156, 33.22666], [-117.0814, 33.22676], [-117.08134, 33.22684], [-117.08129, 33.22695], [-117.08125, 33.22713], [-117.08129, 33.22768], [-117.08127, 33.22783], [-117.0812, 33.22796], [-117.0811, 33.22805], [-117.08093, 33.22813], [-117.08054, 33.22816], [-117.08033, 33.22821], [-117.07993, 33.22836], [-117.07975, 33.22838], [-117.07957, 33.22839], [-117.07936, 33.22837], [-117.07813, 33.22815], [-117.0768, 33.22785], [-117.07542, 33.22747], [-117.07349, 33.22687], [-117.07315, 33.22673], [-117.07274, 33.22649], [-117.07253, 33.2264], [-117.07253, 33.22601], [-117.07042, 33.22599], [-117.0704, 33.22233], [-117.06955, 33.22231], [-117.06954, 33.22217], [-117.06815, 33.22216], [-117.06808, 33.21864], [-117.07262, 33.21865], [-117.08118, 33.21878], [-117.08117, 33.22244], [-117.08321, 33.22248], [-117.08319, 33.2261], [-117.08543, 33.22613]]], [[[-117.08151, 33.22978], [-117.07891, 33.22974], [-117.07894, 33.22846], [-117.0794, 33.22855], [-117.07975, 33.22855], [-117.08005, 33.2285], [-117.08033, 33.22838], [-117.0805, 33.22834], [-117.08102, 33.22827], [-117.08121, 33.22819], [-117.08136, 33.22805], [-117.08145, 33.22788], [-117.08149, 33.22768], [-117.08154, 33.22811], [-117.08151, 33.22978]]]]} | No Public Access 3 | 45135 | Turner Lake Reservoir | 26585 | 2321 | Valley Center Water District 689 | Special District 4 | Water District 13 | http://www.vcmwd.org/ | Special District 4 | 2321 | Valley Center Water District 672 | Special District 4 | Water District 13 | San Diego 4 | 290.169 | Turner Lake Reservoir | 0 | Local Recreation Area 3 | 4 | |
7817 | 7817 | 7816 | {"type": "Polygon", "coordinates": [[[-117.17922, 33.14242], [-117.17907, 33.14299], [-117.179, 33.1431], [-117.17875, 33.14407], [-117.17743, 33.14475], [-117.17679, 33.14467], [-117.17664, 33.14497], [-117.17557, 33.14511], [-117.1745, 33.14495], [-117.17378, 33.14443], [-117.17724, 33.14084], [-117.17856, 33.14177], [-117.17826, 33.14195], [-117.17847, 33.14217], [-117.17847, 33.14223], [-117.17882, 33.14246], [-117.17913, 33.14233], [-117.17922, 33.14242]]]} | No Public Access 3 | 45233 | Vallecitos Water District Open Space | 26776 | 2170 | Vallecitos Water District 879 | Special District 4 | Water District 13 | http://www.vwd.org/ | Special District 4 | 2170 | Vallecitos Water District 855 | Special District 4 | Water District 13 | San Diego 4 | 32.528 | Vallecitos Water District OS | 0 | Local Recreation Area 3 | 4 | |
3826 | 3826 | 3825 | {"type": "Polygon", "coordinates": [[[-117.046, 33.25229], [-117.0459, 33.25362], [-117.04581, 33.25622], [-117.04584, 33.25988], [-117.04315, 33.25987], [-117.04304, 33.25622], [-117.04149, 33.2562], [-117.04135, 33.25228], [-117.046, 33.25229]]]} | No Public Access 3 | 45243 | Valley Center MWDD Open Space | 26786 | 2321 | Valley Center Water District 689 | Special District 4 | Water District 13 | http://www.vcmwd.org/ | Special District 4 | 2321 | Valley Center Water District 672 | Special District 4 | Water District 13 | San Diego 4 | 70.32 | Valley Ctr. MWDD OS | 0 | Local Recreation Area 3 | 4 | |
3798 | 3798 | 3797 | {"type": "MultiPolygon", "coordinates": [[[[-116.9578, 33.32443], [-116.94941, 33.3289], [-116.94271, 33.33233], [-116.93544, 33.32958], [-116.92862, 33.32705], [-116.91095, 33.32034], [-116.90797, 33.31919], [-116.91534, 33.31418], [-116.92002, 33.31102], [-116.92765, 33.31311], [-116.92793, 33.31298], [-116.92835, 33.31273], [-116.92842, 33.31228], [-116.929, 33.31186], [-116.92931, 33.31159], [-116.92979, 33.31131], [-116.93077, 33.311], [-116.93042, 33.31167], [-116.92952, 33.31213], [-116.92917, 33.31283], [-116.92805, 33.31344], [-116.92704, 33.31409], [-116.92582, 33.31491], [-116.92483, 33.31573], [-116.92386, 33.31674], [-116.92361, 33.31727], [-116.92383, 33.31777], [-116.92675, 33.31811], [-116.93088, 33.31862], [-116.93485, 33.318], [-116.93823, 33.31644], [-116.93821, 33.31671], [-116.93823, 33.31709], [-116.9382, 33.31734], [-116.93815, 33.31744], [-116.93808, 33.31751], [-116.93778, 33.31765], [-116.93785, 33.31774], [-116.93818, 33.31759], [-116.93827, 33.31749], [-116.93832, 33.31739], [-116.93836, 33.31715], [-116.93834, 33.31671], [-116.93837, 33.31633], [-116.94031, 33.31541], [-116.94087, 33.31561], [-116.94023, 33.31693], [-116.94024, 33.31695], [-116.94325, 33.31647], [-116.94478, 33.31671], [-116.94578, 33.31681], [-116.94575, 33.31803], [-116.94491, 33.31761], [-116.94483, 33.31757], [-116.94482, 33.31758], [-116.94292, 33.32426], [-116.95073, 33.32383], [-116.9542, 33.32362], [-116.9578, 33.32443]]], [[[-116.92717, 33.31458], [-116.92717, 33.31471], [-116.927, 33.31471], [-116.927, 33.31458], [-116.92717, 33.31458]]]]} | No Public Access 3 | 45133 | YMWD Open Space | 27772 | 2320 | Yuima Municipal Water District 684 | Special District 4 | Water District 13 | http://www.yuimamwd.com/ | Special District 4 | 2320 | Yuima Municipal Water District 675 | Special District 4 | Water District 13 | San Diego 4 | 1090.211 | YMWD OS | 0 | Local Recreation Area 3 | 4 | |
4470 | 4470 | 4469 | {"type": "Polygon", "coordinates": [[[-116.37329, 33.19965], [-116.36458, 33.19964], [-116.36453, 33.19257], [-116.37324, 33.19257], [-116.37329, 33.19965]]]} | Restricted Access 2 | 1194 | Unnamed site - Borrego Water District | 28622 | 2008 | Borrego Water District 764 | Special District 4 | Water District 13 | http://www.borregowd.org/ | Special District 4 | 2008 | Borrego Water District 745 | Special District 4 | Water District 13 | San Diego 4 | 157.534 | 0 | Local Other or Unknown 14 | 4 | ||
7593 | 7593 | 7592 | {"type": "Polygon", "coordinates": [[[-117.13563, 33.08017], [-117.12718, 33.0802], [-117.12711, 33.07295], [-117.1271, 33.06937], [-117.13529, 33.06938], [-117.13563, 33.08017]]]} | Open Access 1 | 7302 | Elfin Forest Recreational Reserve | 29214 | 2102 | Olivenhain Municipal Water District 871 | Special District 4 | Water District 13 | http://www.olivenhain.com/ | Special District 4 | 2102 | Olivenhain Municipal Water District 849 | Special District 4 | Water District 13 | https://www.olivenhain.com/elfin-forest-recreational-reserve | San Diego 4 | 230.522 | Elfin Forest Recreational Reserve | 0 | Local Recreation Area 3 | 4 |
7598 | 7598 | 7597 | {"type": "MultiPolygon", "coordinates": [[[[-117.15281, 33.07293], [-117.15266, 33.08035], [-117.14803, 33.08027], [-117.14401, 33.08032], [-117.13955, 33.08019], [-117.13956, 33.08391], [-117.13632, 33.08392], [-117.13629, 33.08152], [-117.13631, 33.08116], [-117.13631, 33.08018], [-117.13563, 33.08017], [-117.1354, 33.07289], [-117.15281, 33.07293]]], [[[-117.14671, 33.08662], [-117.14533, 33.0873], [-117.14509, 33.08735], [-117.14443, 33.08739], [-117.14422, 33.08742], [-117.1439, 33.08751], [-117.1439, 33.08753], [-117.14377, 33.08759], [-117.14364, 33.08761], [-117.14342, 33.08769], [-117.14244, 33.0881], [-117.14107, 33.08861], [-117.14063, 33.08872], [-117.13959, 33.08884], [-117.13957, 33.08443], [-117.14508, 33.08436], [-117.14671, 33.08662]]]]} | Open Access 1 | 7311 | Elfin Forest Recreational Reserve | 29214 | 2102 | Olivenhain Municipal Water District 871 | Special District 4 | Water District 13 | http://www.olivenhain.com/ | Special District 4 | 2102 | Olivenhain Municipal Water District 849 | Special District 4 | Water District 13 | https://www.olivenhain.com/elfin-forest-recreational-reserve | San Diego 4 | 413.656 | Elfin Forest Recreational Reserve | 0 | Local Recreation Area 3 | 4 |
4759 | 4759 | 4758 | {"type": "Polygon", "coordinates": [[[-116.89337, 32.86769], [-116.89335, 32.87083], [-116.89269, 32.87075], [-116.89171, 32.87067], [-116.89084, 32.87071], [-116.88852, 32.8713], [-116.88757, 32.87172], [-116.88715, 32.87197], [-116.88627, 32.87239], [-116.88579, 32.87264], [-116.88517, 32.87306], [-116.88341, 32.87378], [-116.88276, 32.87409], [-116.88211, 32.8745], [-116.88159, 32.87481], [-116.88042, 32.87556], [-116.87951, 32.87611], [-116.87854, 32.87675], [-116.87777, 32.87717], [-116.87882, 32.87389], [-116.88144, 32.87294], [-116.88354, 32.87188], [-116.88375, 32.87177], [-116.88407, 32.87153], [-116.88412, 32.87153], [-116.88423, 32.87144], [-116.88619, 32.86953], [-116.88642, 32.86932], [-116.88665, 32.86914], [-116.88691, 32.86897], [-116.88719, 32.86882], [-116.88743, 32.86871], [-116.88787, 32.86854], [-116.88831, 32.86843], [-116.89254, 32.868], [-116.89295, 32.86788], [-116.89337, 32.86769]]]} | Unknown Access 4 | 46690 | Unnamed site - Helix Water District | 30035 | 2046 | Helix Water District 777 | Special District 4 | Water District 13 | http://www.hwd.com | Special District 4 | 2046 | Helix Water District 757 | Special District 4 | Water District 13 | San Diego 4 | 97.198 | 0 | Local Other or Unknown 14 | 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]);