units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
4 rows where ACCESS_TYP = 1 and AGNCY_ID = 2046
This data as json, copyable, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
| 7618 | 7618 | 7617 | {"type": "MultiPolygon", "coordinates": [[[[-116.58828, 32.9905], [-116.58825, 32.99071], [-116.58818, 32.9909], [-116.58801, 32.99116], [-116.5879, 32.99127], [-116.58761, 32.99148], [-116.5874, 32.99157], [-116.58719, 32.99163], [-116.5869, 32.99167], [-116.58665, 32.99166], [-116.58142, 32.99099], [-116.5814, 32.99108], [-116.58108, 32.99104], [-116.58084, 32.991], [-116.58063, 32.99093], [-116.58048, 32.99088], [-116.57988, 32.9906], [-116.57971, 32.99055], [-116.57949, 32.99055], [-116.57933, 32.99059], [-116.57914, 32.99068], [-116.57896, 32.99083], [-116.57867, 32.99102], [-116.57852, 32.99107], [-116.57837, 32.9911], [-116.57793, 32.99107], [-116.57771, 32.99101], [-116.57685, 32.99067], [-116.57675, 32.99065], [-116.57647, 32.99066], [-116.57626, 32.99071], [-116.57605, 32.99081], [-116.57587, 32.99094], [-116.57568, 32.99114], [-116.57548, 32.9913], [-116.57545, 32.99118], [-116.57544, 32.99118], [-116.57368, 32.99185], [-116.57278, 32.99241], [-116.57137, 32.99369], [-116.56793, 32.99529], [-116.56657, 32.99852], [-116.56638, 32.99902], [-116.56548, 33.00118], [-116.56333, 33.00224], [-116.56291, 33.00372], [-116.56374, 33.00577], [-116.56384, 33.00633], [-116.5638, 33.00661], [-116.56173, 33.00851], [-116.56074, 33.01059], [-116.5602, 33.01038], [-116.55982, 33.01017], [-116.55945, 33.00989], [-116.5593, 33.00975], [-116.55914, 33.00956], [-116.55893, 33.00928], [-116.55868, 33.00889], [-116.55871, 33.00846], [-116.55796, 33.00715], [-116.55889, 33.00477], [-116.55844, 33.00404], [-116.55765, 33.00348], [-116.55654, 33.0018], [-116.55354, 33.00214], [-116.5523, 33.00058], [-116.55155, 32.99892], [-116.55205, 32.99793], [-116.55211, 32.99628], [-116.55325, 32.9954], [-116.55471, 32.99537], [-116.5569, 32.99538], [-116.55636, 32.99378], [-116.55535, 32.99255], [-116.55513, 32.99154], [-116.55526, 32.99138], [-116.55652, 32.98959], [-116.55693, 32.98801], [-116.55725, 32.98657], [-116.55803, 32.98589], [-116.5583, 32.9844], [-116.56187, 32.9836], [-116.56188, 32.98227], [-116.56635, 32.98249], [-116.56636, 32.98312], [-116.56747, 32.98414], [-116.56898, 32.98471], [-116.56935, 32.98534], [-116.56921, 32.9856], [-116.56929, 32.9864], [-116.56943, 32.98702], [-116.56962, 32.98713], [-116.57098, 32.98721], [-116.57129, 32.98711], [-116.57157, 32.98694], [-116.57204, 32.98548], [-116.57271, 32.98562], [-116.57335, 32.98626], [-116.57363, 32.98619], [-116.57605, 32.98533], [-116.57692, 32.98421], [-116.57714, 32.98288], [-116.57697, 32.98202], [-116.57662, 32.98137], [-116.57615, 32.9811], [-116.57521, 32.98117], [-116.57385, 32.98191], [-116.57299, 32.98196], [-116.57165, 32.98146], [-116.57102, 32.98066], [-116.5713, 32.98014], [-116.57341, 32.98094], [-116.57566, 32.97928], [-116.57639, 32.978], [-116.57747, 32.97841], [-116.57837, 32.97822], [-116.57879, 32.97782], [-116.57898, 32.97751], [-116.58028, 32.97747], [-116.58088, 32.97794], [-116.58068, 32.97842], [-116.58069, 32.97857], [-116.58058, 32.97883], [-116.58052, 32.97945], [-116.58088, 32.97945], [-116.58105, 32.98054], [-116.58105, 32.98062], [-116.58099, 32.98084], [-116.58069, 32.98145], [-116.58065, 32.9816], [-116.58066, 32.98181], [-116.58076, 32.98207], [-116.58157, 32.98307], [-116.58165, 32.98322], [-116.582, 32.98456], [-116.58201, 32.9848], [-116.58199, 32.98488], [-116.58199, 32.98499], [-116.58201, 32.98513], [-116.58212, 32.9854], [-116.58228, 32.98559], [-116.58245, 32.98572], [-116.58261, 32.9858], [-116.58292, 32.98591], [-116.58308, 32.98605], [-116.58316, 32.98614], [-116.58325, 32.98628], [-116.5833, 32.98658], [-116.58428, 32.98766], [-116.58443, 32.98778], [-116.58457, 32.98785], [-116.58482, 32.98793], [-116.58541, 32.98797], [-116.58564, 32.98803], [-116.58576, 32.98807], [-116.58654, 32.98843], [-116.58647, 32.9885], [-116.58648, 32.98851], [-116.5866, 32.98856], [-116.58682, 32.98869], [-116.58698, 32.98883], [-116.58708, 32.98895], [-116.58734, 32.98907], [-116.58763, 32.98942], [-116.58797, 32.98965], [-116.58814, 32.98999], [-116.58819, 32.99043], [-116.58828, 32.99044], [-116.58828, 32.9905]]], [[[-116.55887, 33.00971], [-116.55857, 33.00969], [-116.55861, 33.00936], [-116.55873, 33.00954], [-116.55887, 33.00971]]], [[[-116.56489, 33.01495], [-116.56489, 33.01495], [-116.56483, 33.02105], [-116.56391, 33.0168], [-116.56255, 33.01679], [-116.5626, 33.01656], [-116.56264, 33.01612], [-116.56264, 33.01583], [-116.56262, 33.01571], [-116.56258, 33.01556], [-116.56251, 33.01542], [-116.56188, 33.01444], [-116.56175, 33.01414], [-116.56132, 33.01258], [-116.56125, 33.01223], [-116.56121, 33.01185], [-116.56121, 33.01153], [-116.56121, 33.01124], [-116.56125, 33.01102], [-116.56158, 33.01114], [-116.564, 33.01328], [-116.56489, 33.01495]]], [[[-116.58571, 32.99196], [-116.58562, 32.99276], [-116.58476, 32.99272], [-116.58486, 32.99176], [-116.58558, 32.99185], [-116.58571, 32.99196]]]]} | Open Access 1 | 47619 | Lake Cuyamaca | 20881 | 2046 | Helix Water District 777 | Special District 4 | Water District 13 | http://www.hwd.com | Special District 4 | 2058 | Lake Cuyamaca Park and Recreation District 853 | Special District 4 | Recreation/Parks District 4 | http://www.lakecuyamaca.org/ | San Diego 4 | 1116.016 | Lake Cuyamaca | None 635 | ||
| 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 |
| 16230 | 16230 | 16229 | {"type": "Polygon", "coordinates": [[[-116.74867, 32.97823], [-116.74862, 32.97841], [-116.74844, 32.97867], [-116.74821, 32.97891], [-116.74824, 32.97908], [-116.74828, 32.97918], [-116.74829, 32.97928], [-116.74823, 32.97933], [-116.74799, 32.97942], [-116.7478, 32.97955], [-116.74767, 32.97973], [-116.74753, 32.97986], [-116.74738, 32.97992], [-116.74721, 32.98003], [-116.7468, 32.98041], [-116.74638, 32.98091], [-116.74623, 32.98147], [-116.74615, 32.98162], [-116.74614, 32.98182], [-116.74612, 32.98197], [-116.74597, 32.98246], [-116.74599, 32.98258], [-116.74613, 32.98283], [-116.74629, 32.98324], [-116.74626, 32.98332], [-116.74595, 32.98353], [-116.74571, 32.9836], [-116.74546, 32.98361], [-116.74523, 32.98368], [-116.74512, 32.98375], [-116.74505, 32.98385], [-116.7451, 32.98396], [-116.74525, 32.98412], [-116.74571, 32.98447], [-116.74592, 32.98458], [-116.7461, 32.98463], [-116.7463, 32.98478], [-116.74627, 32.98489], [-116.74617, 32.98497], [-116.74602, 32.98498], [-116.74573, 32.98493], [-116.74547, 32.98492], [-116.74516, 32.985], [-116.74481, 32.98512], [-116.7446, 32.98531], [-116.74455, 32.98543], [-116.74455, 32.98561], [-116.74459, 32.9858], [-116.74466, 32.98592], [-116.7447, 32.98608], [-116.74465, 32.98615], [-116.74452, 32.98624], [-116.74444, 32.98633], [-116.74446, 32.98655], [-116.74449, 32.9866], [-116.74446, 32.98665], [-116.74448, 32.98675], [-116.74444, 32.98685], [-116.7443, 32.98687], [-116.74413, 32.98686], [-116.74399, 32.98682], [-116.74383, 32.98685], [-116.74372, 32.98691], [-116.74363, 32.98703], [-116.74358, 32.98713], [-116.74327, 32.98732], [-116.7431, 32.9875], [-116.74297, 32.98775], [-116.74298, 32.98807], [-116.74312, 32.98817], [-116.74326, 32.98823], [-116.7435, 32.98827], [-116.74388, 32.98823], [-116.744, 32.98824], [-116.74404, 32.98835], [-116.744, 32.98843], [-116.74375, 32.98853], [-116.74362, 32.98861], [-116.74357, 32.98877], [-116.74356, 32.98886], [-116.74346, 32.98894], [-116.74345, 32.98907], [-116.74358, 32.98918], [-116.7438, 32.98921], [-116.74413, 32.98941], [-116.74428, 32.98953], [-116.74441, 32.98968], [-116.74449, 32.98992], [-116.74454, 32.9901], [-116.74475, 32.99029], [-116.74489, 32.99045], [-116.74493, 32.99052], [-116.74491, 32.99057], [-116.74486, 32.9906], [-116.7447, 32.99056], [-116.74436, 32.99053], [-116.74404, 32.99042], [-116.7439, 32.99043], [-116.74367, 32.99054], [-116.74339, 32.99054], [-116.74318, 32.99061], [-116.74303, 32.99072], [-116.74305, 32.99082], [-116.74306, 32.99109], [-116.74288, 32.9912], [-116.74282, 32.99137], [-116.74272, 32.99149], [-116.74269, 32.99151], [-116.74243, 32.99133], [-116.74223, 32.99126], [-116.74193, 32.99125], [-116.74185, 32.9913], [-116.7418, 32.9914], [-116.7418, 32.99145], [-116.74182, 32.9916], [-116.74193, 32.99175], [-116.74195, 32.99184], [-116.74194, 32.99188], [-116.74187, 32.99191], [-116.74168, 32.9919], [-116.74126, 32.99197], [-116.7411, 32.99201], [-116.74099, 32.99209], [-116.74091, 32.99218], [-116.74083, 32.9924], [-116.74075, 32.99248], [-116.74042, 32.99256], [-116.74035, 32.9926], [-116.74014, 32.9927], [-116.74001, 32.99279], [-116.74, 32.99294], [-116.73997, 32.99305], [-116.73989, 32.99313], [-116.73985, 32.99325], [-116.73985, 32.99345], [-116.73992, 32.99367], [-116.74008, 32.99379], [-116.74029, 32.9939], [-116.74046, 32.99407], [-116.74063, 32.99416], [-116.74076, 32.99425], [-116.74077, 32.99429], [-116.74066, 32.99431], [-116.74042, 32.9943], [-116.74034, 32.99436], [-116.74015, 32.9944], [-116.74007, 32.99436], [-116.73992, 32.99435], [-116.73979, 32.9944], [-116.73972, 32.99439], [-116.73934, 32.99427], [-116.73925, 32.9941], [-116.73911, 32.99398], [-116.73882, 32.99389], [-116.7387, 32.99389], [-116.73857, 32.99394], [-116.73852, 32.99403], [-116.73848, 32.99418], [-116.73849, 32.99433], [-116.73844, 32.9944], [-116.73837, 32.99442], [-116.73831, 32.9944], [-116.73803, 32.99428], [-116.73791, 32.99424], [-116.73742, 32.99427], [-116.73711, 32.99436], [-116.73659, 32.9946], [-116.7364, 32.99478], [-116.7363, 32.99492], [-116.7363, 32.99505], [-116.73646, 32.99524], [-116.73647, 32.9953], [-116.73615, 32.99533], [-116.7356, 32.99523], [-116.73531, 32.99521], [-116.73474, 32.99515], [-116.73448, 32.99517], [-116.73429, 32.99527], [-116.734, 32.99536], [-116.73379, 32.99551], [-116.7336, 32.99573], [-116.7335, 32.99595], [-116.73349, 32.99622], [-116.73352, 32.99634], [-116.73361, 32.99644], [-116.73366, 32.99653], [-116.73363, 32.99659], [-116.73326, 32.99675], [-116.73313, 32.99685], [-116.73305, 32.997], [-116.73287, 32.99716], [-116.73271, 32.99737], [-116.73265, 32.99751], [-116.73261, 32.99774], [-116.7324, 32.99811], [-116.73234, 32.99855], [-116.73231, 32.99862], [-116.73215, 32.99876], [-116.73211, 32.99884], [-116.73209, 32.99891], [-116.73206, 32.99898], [-116.73197, 32.99907], [-116.7318, 32.99915], [-116.73168, 32.99925], [-116.73158, 32.99939], [-116.73155, 32.99957], [-116.73156, 32.99986], [-116.73149, 32.99995], [-116.7312, 33.00004], [-116.73109, 33.00013], [-116.73093, 33.00058], [-116.73079, 33.00067], [-116.73053, 33.00078], [-116.73048, 33.00087], [-116.73045, 33.00109], [-116.7304, 33.00118], [-116.73017, 33.00136], [-116.73014, 33.00146], [-116.73012, 33.00165], [-116.73014, 33.00186], [-116.73006, 33.00205], [-116.72991, 33.0023], [-116.72964, 33.00254], [-116.72948, 33.0026], [-116.72922, 33.00274], [-116.72913, 33.00282], [-116.72898, 33.0029], [-116.72884, 33.00314], [-116.72875, 33.00318], [-116.72863, 33.00318], [-116.72851, 33.00327], [-116.72835, 33.00341], [-116.72832, 33.00352], [-116.72827, 33.00356], [-116.72793, 33.0036], [-116.72782, 33.00371], [-116.72748, 33.00398], [-116.72733, 33.00434], [-116.7273, 33.00437], [-116.72723, 33.00437], [-116.72718, 33.00432], [-116.72714, 33.00426], [-116.72713, 33.00378], [-116.72721, 33.00368], [-116.72728, 33.00363], [-116.72737, 33.00359], [-116.72744, 33.00353], [-116.72768, 33.00326], [-116.72826, 33.00296], [-116.72849, 33.00275], [-116.7285, 33.00268], [-116.72868, 33.00257], [-116.72878, 33.00247], [-116.72929, 33.00167], [-116.72929, 33.00137], [-116.72933, 33.00129], [-116.72951, 33.00114], [-116.72956, 33.00102], [-116.7298, 33.00069], [-116.72984, 33.00057], [-116.72985, 33.00022], [-116.73012, 33.00004], [-116.73036, 32.9996], [-116.73039, 32.99946], [-116.73048, 32.99921], [-116.73049, 32.99908], [-116.73048, 32.99896], [-116.73045, 32.99889], [-116.73045, 32.99878], [-116.73049, 32.99871], [-116.73062, 32.9986], [-116.73076, 32.99844], [-116.73089, 32.99811], [-116.73096, 32.99781], [-116.73122, 32.99707], [-116.73123, 32.99664], [-116.73131, 32.99645], [-116.73126, 32.99626], [-116.73131, 32.99606], [-116.73143, 32.99582], [-116.73148, 32.99554], [-116.73147, 32.99544], [-116.73138, 32.99519], [-116.73139, 32.99511], [-116.73131, 32.99491], [-116.73134, 32.99484], [-116.73152, 32.99475], [-116.73186, 32.9947], [-116.73222, 32.99459], [-116.73252, 32.9944], [-116.73274, 32.99423], [-116.73303, 32.99398], [-116.73344, 32.99357], [-116.7335, 32.99332], [-116.73357, 32.99327], [-116.7338, 32.99317], [-116.7339, 32.9931], [-116.73406, 32.99281], [-116.73414, 32.99263], [-116.73419, 32.99256], [-116.73427, 32.99252], [-116.73437, 32.9925], [-116.73451, 32.99243], [-116.73466, 32.99232], [-116.73476, 32.9922], [-116.73477, 32.99193], [-116.73483, 32.99185], [-116.73517, 32.99163], [-116.73535, 32.99148], [-116.73542, 32.99138], [-116.73538, 32.9913], [-116.73524, 32.99116], [-116.73519, 32.99103], [-116.73516, 32.99086], [-116.7351, 32.99072], [-116.73499, 32.99059], [-116.73487, 32.99051], [-116.73465, 32.99039], [-116.73451, 32.99035], [-116.73429, 32.99024], [-116.73409, 32.99018], [-116.73371, 32.99028], [-116.73351, 32.99025], [-116.73332, 32.99025], [-116.7331, 32.99014], [-116.7326, 32.98995], [-116.73223, 32.98985], [-116.73213, 32.98978], [-116.73181, 32.98947], [-116.73161, 32.98932], [-116.73131, 32.98921], [-116.73118, 32.98921], [-116.73104, 32.98926], [-116.73094, 32.98935], [-116.73087, 32.98945], [-116.73069, 32.9899], [-116.73061, 32.98999], [-116.73056, 32.99], [-116.73039, 32.98997], [-116.73009, 32.98997], [-116.72997, 32.98993], [-116.72993, 32.98988], [-116.72993, 32.98981], [-116.72999, 32.98968], [-116.73039, 32.98944], [-116.73052, 32.98926], [-116.73053, 32.98916], [-116.73052, 32.98903], [-116.73054, 32.98898], [-116.73247, 32.98887], [-116.73283, 32.98903], [-116.733, 32.98904], [-116.73318, 32.989], [-116.73326, 32.989], [-116.73352, 32.98888], [-116.73383, 32.98879], [-116.73413, 32.98877], [-116.73619, 32.98873], [-116.73631, 32.98874], [-116.73645, 32.98881], [-116.73651, 32.98887], [-116.73706, 32.98898], [-116.73738, 32.98915], [-116.73747, 32.98918], [-116.73754, 32.98917], [-116.7379, 32.98902], [-116.73783, 32.98873], [-116.73786, 32.9885], [-116.73794, 32.98836], [-116.73794, 32.98828], [-116.73787, 32.9882], [-116.73785, 32.98813], [-116.73778, 32.98808], [-116.73753, 32.98802], [-116.73721, 32.98778], [-116.73718, 32.9877], [-116.73717, 32.9876], [-116.73705, 32.98753], [-116.73702, 32.98747], [-116.73702, 32.98743], [-116.73709, 32.98738], [-116.73713, 32.98733], [-116.73713, 32.98722], [-116.73718, 32.98719], [-116.73755, 32.98719], [-116.73794, 32.98714], [-116.73837, 32.98686], [-116.73846, 32.98674], [-116.73848, 32.9866], [-116.73858, 32.98652], [-116.73879, 32.98639], [-116.73914, 32.98606], [-116.73916, 32.98594], [-116.73913, 32.98582], [-116.73923, 32.98574], [-116.73936, 32.98567], [-116.7396, 32.98547], [-116.73978, 32.9852], [-116.73987, 32.98495], [-116.7399, 32.98475], [-116.73997, 32.98468], [-116.74006, 32.98465], [-116.74016, 32.98451], [-116.74015, 32.98442], [-116.74019, 32.98431], [-116.74026, 32.98425], [-116.74077, 32.98395], [-116.74101, 32.98365], [-116.74113, 32.98323], [-116.74121, 32.98316], [-116.74167, 32.98295], [-116.74185, 32.98279], [-116.74194, 32.98269], [-116.74198, 32.98261], [-116.74225, 32.98234], [-116.74232, 32.98224], [-116.74237, 32.98209], [-116.74232, 32.98193], [-116.74197, 32.98164], [-116.74174, 32.98149], [-116.74158, 32.98145], [-116.74149, 32.9813], [-116.7413, 32.9812], [-116.74112, 32.98117], [-116.74099, 32.98119], [-116.7409, 32.98118], [-116.7404, 32.98072], [-116.74008, 32.98055], [-116.74002, 32.98049], [-116.74002, 32.98042], [-116.74007, 32.98029], [-116.74018, 32.98016], [-116.74018, 32.98007], [-116.74012, 32.97994], [-116.74002, 32.97984], [-116.73988, 32.97976], [-116.73967, 32.97974], [-116.73956, 32.97777], [-116.74282, 32.97769], [-116.74287, 32.97775], [-116.74298, 32.97784], [-116.74338, 32.97802], [-116.74375, 32.97802], [-116.74386, 32.97806], [-116.74393, 32.97813], [-116.74399, 32.97814], [-116.74415, 32.97814], [-116.74429, 32.9781], [-116.74442, 32.97809], [-116.7445, 32.97814], [-116.74466, 32.97841], [-116.74469, 32.97855], [-116.74491, 32.97879], [-116.74505, 32.97885], [-116.74519, 32.97886], [-116.7456, 32.9788], [-116.74576, 32.97879], [-116.74587, 32.97885], [-116.74605, 32.97902], [-116.74616, 32.97909], [-116.74628, 32.97911], [-116.74647, 32.97911], [-116.74674, 32.97907], [-116.74708, 32.97896], [-116.7476, 32.97863], [-116.74802, 32.97847], [-116.74813, 32.97836], [-116.74835, 32.97823], [-116.74849, 32.97818], [-116.74859, 32.97819], [-116.74867, 32.97823]]]} | Open Access 1 | 45134 | Helix Water District Open Space | 31526 | 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 | 318.048 | Helix Water District 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]);