units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
96 rows where ACCESS_TYP = 3 and DES_TP = 14 sorted by rowid descending
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Los Angeles, City of 12
- Escondido, City of 9
- Los Angeles County Flood Control District 9
- San Diego, City of 8
- Napa, City of 7
- Mountains Recreation and Conservation Authority 3
- Santa Barbara Flood Control and Water Conserv. District 2
- Los Angeles - Department of Water and Power, City of 2
- Rancho Palos Verdes, City of 2
- Santa Barbara, County of 1
- Los Angeles, County of 1
- Monterey, County of 1
- San Diego, County of 1
- Napa County Regional Park and Open Space District 1
- Petaluma, City of 1
- Davis, City of 1
- San Marcos, City of 1
- Paramount, City of 1
- Torrance, City of 1
- Diamond Bar, City of 1
- Sonoma County Agricultural Preservation and Open Space District 1
- American Canyon, City of 1
- Santa Clara Valley Open Space Authority 1
- Soledad, City of 1
- Napa, County of 1
- Sacramento, City of 1
- Riverside County Habitat Conservation Agency 1
- Fresno Metropolitan Flood Control District 1
- California Reclamation District 2140 1
- Olivenhain Municipal Water District 1
- …
MNG_AG_TYP 6
DES_TP 1
- Local Other or Unknown · 76 ✖
ACCESS_TYP 1
- No Public Access · 76 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10935 | 10935 | 10934 | {"type": "Polygon", "coordinates": [[[-121.67546, 38.55795], [-121.67529, 38.56745], [-121.65712, 38.56762], [-121.65699, 38.57488], [-121.64781, 38.57492], [-121.63857, 38.57489], [-121.63885, 38.56638], [-121.66534, 38.56043], [-121.66535, 38.5608], [-121.66612, 38.5608], [-121.66614, 38.5602], [-121.66638, 38.56014], [-121.6664, 38.55998], [-121.67546, 38.55795]]]} | No Public Access 3 | 20963 | Howatt/Clayton Ranch | 20123 | 1081 | Davis, City of 171 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | Yolo 33 | 786.039 | Howatt/Clayton Ranch | 0 | Local Other or Unknown 14 | 4 | |
10235 | 10235 | 10234 | {"type": "MultiPolygon", "coordinates": [[[[-122.24463, 38.36675], [-122.24135, 38.37065], [-122.24136, 38.37067], [-122.24174, 38.37068], [-122.24269, 38.37071], [-122.24268, 38.3709], [-122.24261, 38.37117], [-122.24256, 38.37144], [-122.24251, 38.37156], [-122.24248, 38.37182], [-122.24255, 38.37251], [-122.24262, 38.37271], [-122.24271, 38.37278], [-122.24286, 38.37324], [-122.24362, 38.37352], [-122.24399, 38.37363], [-122.244, 38.37381], [-122.24379, 38.3739], [-122.24301, 38.37397], [-122.24243, 38.37411], [-122.24202, 38.37433], [-122.24175, 38.37461], [-122.24165, 38.375], [-122.24195, 38.37565], [-122.24199, 38.37584], [-122.24197, 38.37601], [-122.2419, 38.37616], [-122.24188, 38.37625], [-122.24189, 38.37634], [-122.24202, 38.3766], [-122.24205, 38.37676], [-122.24204, 38.37718], [-122.24197, 38.37771], [-122.24194, 38.37777], [-122.24185, 38.37784], [-122.24083, 38.37907], [-122.24064, 38.37951], [-122.24064, 38.37954], [-122.24017, 38.37955], [-122.24014, 38.38], [-122.24007, 38.38019], [-122.24008, 38.3802], [-122.24069, 38.38016], [-122.24088, 38.38114], [-122.24112, 38.38194], [-122.24107, 38.38199], [-122.2404, 38.38207], [-122.2401, 38.38214], [-122.23996, 38.38223], [-122.23985, 38.38236], [-122.23986, 38.38259], [-122.23991, 38.38282], [-122.23987, 38.383], [-122.23964, 38.3833], [-122.23924, 38.38351], [-122.23882, 38.38364], [-122.23842, 38.38371], [-122.23818, 38.38363], [-122.2379, 38.38348], [-122.23764, 38.3835], [-122.2375, 38.38354], [-122.23719, 38.38369], [-122.23698, 38.38382], [-122.23667, 38.38406], [-122.23599, 38.38426], [-122.23583, 38.3838], [-122.23573, 38.38356], [-122.23563, 38.38323], [-122.23546, 38.38283], [-122.23536, 38.38248], [-122.23531, 38.38223], [-122.2353, 38.38202], [-122.2352, 38.38178], [-122.23506, 38.38167], [-122.23485, 38.38155], [-122.23472, 38.38141], [-122.2347, 38.38113], [-122.23461, 38.3808], [-122.2345, 38.38061], [-122.23425, 38.38039], [-122.23412, 38.38032], [-122.23394, 38.38025], [-122.2338, 38.38015], [-122.23368, 38.37993], [-122.23363, 38.3798], [-122.23353, 38.37959], [-122.23339, 38.3794], [-122.23328, 38.37928], [-122.233, 38.37918], [-122.23286, 38.37908], [-122.23278, 38.37895], [-122.23276, 38.37881], [-122.23278, 38.37867], [-122.23278, 38.37851], [-122.23271, 38.3784], [-122.23252, 38.37836], [-122.23236, 38.37827], [-122.23197, 38.37814], [-122.23176, 38.37798], [-122.23155, 38.37772], [-122.23139, 38.37735], [-122.23131, 38.37697], [-122.23115, 38.37661], [-122.23113, 38.37651], [-122.23104, 38.37643], [-122.23091, 38.37635], [-122.23073, 38.37633], [-122.23023, 38.37635], [-122.23002, 38.37638], [-122.22974, 38.37649], [-122.22965, 38.37663], [-122.22959, 38.37681], [-122.22959, 38.37704], [-122.22963, 38.3773], [-122.22964, 38.37753], [-122.22981, 38.37811], [-122.23021, 38.37894], [-122.23028, 38.37911], [-122.23033, 38.37932], [-122.23052, 38.37954], [-122.23086, 38.3798], [-122.23173, 38.38018], [-122.23187, 38.38028], [-122.23186, 38.3804], [-122.23174, 38.38047], [-122.2311, 38.38053], [-122.23061, 38.38074], [-122.23048, 38.38084], [-122.23043, 38.38084], [-122.23049, 38.38074], [-122.23083, 38.38054], [-122.23084, 38.38044], [-122.23074, 38.38039], [-122.23059, 38.38024], [-122.23055, 38.3804], [-122.23061, 38.38048], [-122.23057, 38.38053], [-122.23045, 38.3806], [-122.23031, 38.38075], [-122.23023, 38.38093], [-122.23021, 38.38126], [-122.23016, 38.38146], [-122.23014, 38.38187], [-122.23016, 38.38217], [-122.23031, 38.38277], [-122.23034, 38.38297], [-122.23055, 38.38347], [-122.23068, 38.38364], [-122.23085, 38.38377], [-122.23109, 38.38387], [-122.23166, 38.3845], [-122.23181, 38.38464], [-122.23191, 38.3847], [-122.23227, 38.3848], [-122.23251, 38.38481], [-122.23293, 38.38481], [-122.23336, 38.38474], [-122.23377, 38.38472], [-122.23419, 38.3847], [-122.2344, 38.3847], [-122.23456, 38.38474], [-122.2348, 38.38485], [-122.23492, 38.38489], [-122.23517, 38.38492], [-122.23533, 38.3849], [-122.2355, 38.38483], [-122.23563, 38.38474], [-122.23585, 38.3845], [-122.23602, 38.38443], [-122.23633, 38.38436], [-122.23665, 38.38426], [-122.23691, 38.38409], [-122.23708, 38.38394], [-122.23736, 38.38378], [-122.2377, 38.38367], [-122.23787, 38.3837], [-122.23816, 38.3838], [-122.23854, 38.38384], [-122.23894, 38.38377], [-122.23939, 38.3836], [-122.2397, 38.38343], [-122.23994, 38.38324], [-122.2401, 38.38309], [-122.24015, 38.38291], [-122.24014, 38.38275], [-122.2401, 38.38263], [-122.24007, 38.38241], [-122.24011, 38.38231], [-122.24023, 38.38225], [-122.24062, 38.38218], [-122.24078, 38.38218], [-122.24112, 38.38211], [-122.24121, 38.38215], [-122.2421, 38.38406], [-122.24237, 38.38472], [-122.24272, 38.3854], [-122.24295, 38.38578], [-122.24321, 38.38637], [-122.2434, 38.38666], [-122.2431, 38.387], [-122.24309, 38.38705], [-122.24316, 38.38743], [-122.24308, 38.38773], [-122.24289, 38.3883], [-122.24269, 38.38873], [-122.24256, 38.38891], [-122.24219, 38.38933], [-122.24182, 38.38963], [-122.24156, 38.38968], [-122.24134, 38.38976], [-122.24126, 38.38983], [-122.24121, 38.38995], [-122.24122, 38.3903], [-122.24117, 38.39046], [-122.24111, 38.39055], [-122.24058, 38.3911], [-122.24, 38.3915], [-122.23996, 38.3917], [-122.23999, 38.3919], [-122.24017, 38.3922], [-122.24031, 38.39239], [-122.23976, 38.39238], [-122.2397, 38.3924], [-122.23965, 38.39488], [-122.23957, 38.39508], [-122.23953, 38.39531], [-122.23954, 38.3957], [-122.23966, 38.39602], [-122.23709, 38.396], [-122.23521, 38.396], [-122.23516, 38.40366], [-122.22631, 38.4035], [-122.22627, 38.39597], [-122.22176, 38.39593], [-122.22164, 38.38869], [-122.21244, 38.38862], [-122.21238, 38.37403], [-122.22656, 38.37413], [-122.2311, 38.37409], [-122.23107, 38.36982], [-122.231, 38.36687], [-122.24463, 38.36675]]], [[[-122.23506, 38.38194], [-122.23511, 38.38212], [-122.23514, 38.38236], [-122.23526, 38.38286], [-122.23544, 38.38326], [-122.23547, 38.38344], [-122.23555, 38.38363], [-122.23571, 38.38399], [-122.23574, 38.38423], [-122.2357, 38.38438], [-122.2356, 38.3845], [-122.23537, 38.38469], [-122.23524, 38.38475], [-122.23504, 38.38477], [-122.2348, 38.38465], [-122.23468, 38.38461], [-122.23441, 38.38455], [-122.23414, 38.38455], [-122.23336, 38.38461], [-122.23279, 38.3847], [-122.23243, 38.38468], [-122.23218, 38.38463], [-122.23197, 38.38454], [-122.23184, 38.38442], [-122.23138, 38.38388], [-122.2312, 38.38371], [-122.2309, 38.38358], [-122.23073, 38.38344], [-122.23058, 38.38309], [-122.23048, 38.38257], [-122.23037, 38.38223], [-122.23035, 38.38205], [-122.23043, 38.38117], [-122.23053, 38.38103], [-122.23068, 38.3809], [-122.2309, 38.38078], [-122.23121, 38.38068], [-122.23158, 38.38063], [-122.23201, 38.38052], [-122.2321, 38.38044], [-122.23214, 38.38034], [-122.2321, 38.38024], [-122.23202, 38.38016], [-122.2315, 38.37992], [-122.23132, 38.3798], [-122.23113, 38.37973], [-122.23099, 38.37965], [-122.23086, 38.37956], [-122.23063, 38.37933], [-122.23042, 38.37894], [-122.23026, 38.37859], [-122.23019, 38.37841], [-122.23013, 38.37832], [-122.2299, 38.37769], [-122.2298, 38.37692], [-122.22981, 38.37677], [-122.22988, 38.37667], [-122.23017, 38.37654], [-122.23042, 38.3765], [-122.23076, 38.37655], [-122.23085, 38.37659], [-122.23094, 38.37667], [-122.23101, 38.37681], [-122.23128, 38.37762], [-122.2314, 38.37785], [-122.2316, 38.37809], [-122.23186, 38.37828], [-122.23257, 38.37855], [-122.23257, 38.37887], [-122.23265, 38.37905], [-122.23286, 38.37927], [-122.23298, 38.37931], [-122.23313, 38.37942], [-122.23327, 38.37957], [-122.23341, 38.3798], [-122.23357, 38.38016], [-122.23368, 38.38029], [-122.23385, 38.38039], [-122.23407, 38.38048], [-122.23423, 38.38057], [-122.23441, 38.38083], [-122.23449, 38.38104], [-122.23452, 38.38122], [-122.23452, 38.38141], [-122.23459, 38.38153], [-122.23471, 38.38169], [-122.23493, 38.3818], [-122.23506, 38.38194]]], [[[-122.24403, 38.37272], [-122.24398, 38.37358], [-122.24306, 38.37325], [-122.24305, 38.37274], [-122.24375, 38.3727], [-122.24403, 38.37272]]]]} | No Public Access 3 | 17909 | Milliken Reservoir Property | 22252 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 1712.398 | Milliken Reservoir Property | 0 | Local Other or Unknown 14 | 4 | |
9993 | 9993 | 9992 | {"type": "Polygon", "coordinates": [[[-117.00987, 32.55768], [-117.00557, 32.5576], [-117.00555, 32.56025], [-117.00128, 32.56018], [-117.00126, 32.55751], [-116.99834, 32.55745], [-116.99769, 32.55743], [-116.99699, 32.55743], [-116.99699, 32.55385], [-116.99614, 32.55382], [-116.99588, 32.55353], [-116.99536, 32.55264], [-116.99513, 32.55248], [-116.99481, 32.55243], [-116.99449, 32.55257], [-116.99356, 32.55323], [-116.993, 32.55322], [-116.99287, 32.55313], [-116.99284, 32.55268], [-116.99337, 32.55212], [-116.99346, 32.55187], [-116.99337, 32.55162], [-116.99317, 32.55135], [-116.9927, 32.55115], [-116.99269, 32.55005], [-116.99912, 32.55022], [-116.99914, 32.55328], [-116.99985, 32.5533], [-116.99986, 32.55391], [-117.00986, 32.55413], [-117.00985, 32.55619], [-117.00987, 32.55768]]]} | No Public Access 3 | 47971 | Otay Mitigation Site | 32285 | 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 | 200.028 | Otay Mitigation Site | 0 | Local Other or Unknown 14 | 4 | |
9628 | 9628 | 9627 | {"type": "Polygon", "coordinates": [[[-122.69582, 38.54625], [-122.69567, 38.54622], [-122.6949, 38.54581], [-122.69432, 38.54576], [-122.69338, 38.54514], [-122.69307, 38.54474], [-122.69284, 38.54396], [-122.69244, 38.5437], [-122.69183, 38.54277], [-122.69113, 38.54204], [-122.69108, 38.54018], [-122.69581, 38.54015], [-122.69582, 38.54625]]]} | No Public Access 3 | 47850 | Wendle Property | 31796 | 2155 | Sonoma County Agricultural Preservation and Open Space District 387 | Special District 4 | Recreation/Parks District 4 | http://www.sonomaopenspace.org/ | Special District 4 | 2155 | Sonoma County Agricultural Preservation and Open Space District 383 | Special District 4 | Recreation/Parks District 4 | Sonoma 16 | 50.237 | Wendle Property | 2018 | Local Other or Unknown 14 | 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 | |
8304 | 8304 | 8303 | {"type": "Polygon", "coordinates": [[[-118.44775, 34.33271], [-118.44653, 34.33307], [-118.44644, 34.33288], [-118.44629, 34.33208], [-118.44632, 34.3321], [-118.44633, 34.33209], [-118.44593, 34.33133], [-118.4458, 34.33101], [-118.44556, 34.33066], [-118.44548, 34.3306], [-118.44537, 34.33055], [-118.44527, 34.33054], [-118.44516, 34.33055], [-118.44502, 34.3306], [-118.44486, 34.33072], [-118.44462, 34.33082], [-118.44455, 34.33083], [-118.44446, 34.3308], [-118.4444, 34.33074], [-118.44438, 34.33068], [-118.4444, 34.33061], [-118.44498, 34.32992], [-118.44717, 34.32993], [-118.44716, 34.33007], [-118.44756, 34.33103], [-118.44775, 34.33271]]]} | No Public Access 3 | 12723 | Flood Control | 18953 | 2272 | Los Angeles County Flood Control District 287 | Special District 4 | Flood District 8 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 2272 | Los Angeles County Flood Control District 284 | Special District 4 | Flood District 9 | Los Angeles 6 | 13.401 | Flood Control | 0 | Local Other or Unknown 14 | 4 | |
8303 | 8303 | 8302 | {"type": "Polygon", "coordinates": [[[-118.47061, 34.3327], [-118.47016, 34.33284], [-118.46964, 34.33229], [-118.46861, 34.33235], [-118.46846, 34.33475], [-118.46779, 34.33473], [-118.46763, 34.33148], [-118.46832, 34.33146], [-118.46882, 34.3306], [-118.46881, 34.33058], [-118.46838, 34.33055], [-118.46839, 34.33011], [-118.46915, 34.33012], [-118.46944, 34.33023], [-118.46958, 34.33035], [-118.47003, 34.33102], [-118.47061, 34.3327]]]} | No Public Access 3 | 12722 | Flood Control | 18953 | 2272 | Los Angeles County Flood Control District 287 | Special District 4 | Flood District 8 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 2272 | Los Angeles County Flood Control District 284 | Special District 4 | Flood District 9 | Los Angeles 6 | 15.975 | Flood Control | 0 | Local Other or Unknown 14 | 4 | |
8302 | 8302 | 8301 | {"type": "MultiPolygon", "coordinates": [[[[-118.47595, 34.32868], [-118.47522, 34.32881], [-118.47516, 34.32877], [-118.475, 34.3286], [-118.47468, 34.32886], [-118.47418, 34.32872], [-118.47382, 34.32824], [-118.47375, 34.32796], [-118.47388, 34.32773], [-118.47425, 34.32782], [-118.47464, 34.3274], [-118.47489, 34.32723], [-118.475, 34.32723], [-118.47498, 34.32741], [-118.47504, 34.32747], [-118.47515, 34.32748], [-118.47595, 34.32868]]], [[[-118.47687, 34.33028], [-118.47677, 34.33041], [-118.47584, 34.32924], [-118.4757, 34.32915], [-118.4762, 34.32905], [-118.47683, 34.33027], [-118.47687, 34.33028]]]]} | No Public Access 3 | 12721 | Flood Control | 18953 | 2272 | Los Angeles County Flood Control District 287 | Special District 4 | Flood District 8 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 2272 | Los Angeles County Flood Control District 284 | Special District 4 | Flood District 9 | Los Angeles 6 | 6.178 | Flood Control | 0 | Local Other or Unknown 14 | 4 | |
8301 | 8301 | 8300 | {"type": "Polygon", "coordinates": [[[-118.45954, 34.32608], [-118.45903, 34.32693], [-118.45897, 34.32748], [-118.45866, 34.32801], [-118.45855, 34.32801], [-118.45828, 34.32695], [-118.45824, 34.32695], [-118.45826, 34.32561], [-118.45823, 34.3255], [-118.458, 34.32543], [-118.4579, 34.32485], [-118.45808, 34.32479], [-118.45807, 34.32476], [-118.45823, 34.32469], [-118.45797, 34.32414], [-118.45813, 34.32418], [-118.45857, 34.32507], [-118.45921, 34.32507], [-118.45954, 34.32608]]]} | No Public Access 3 | 12720 | Flood Control | 18953 | 2272 | Los Angeles County Flood Control District 287 | Special District 4 | Flood District 8 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 2272 | Los Angeles County Flood Control District 284 | Special District 4 | Flood District 9 | Los Angeles 6 | 7.386 | Flood Control | 0 | Local Other or Unknown 14 | 4 | |
8300 | 8300 | 8299 | {"type": "Polygon", "coordinates": [[[-118.46565, 34.33048], [-118.46562, 34.33062], [-118.46563, 34.33073], [-118.46517, 34.33077], [-118.46516, 34.33138], [-118.46458, 34.332], [-118.46458, 34.33243], [-118.46432, 34.33311], [-118.4639, 34.3328], [-118.46417, 34.33245], [-118.46393, 34.33219], [-118.46382, 34.33173], [-118.46412, 34.33168], [-118.46385, 34.33059], [-118.46422, 34.33041], [-118.46428, 34.3302], [-118.4648, 34.33011], [-118.46482, 34.33008], [-118.46531, 34.33009], [-118.46526, 34.33043], [-118.46565, 34.33048]]]} | No Public Access 3 | 12719 | Flood Control | 18953 | 2272 | Los Angeles County Flood Control District 287 | Special District 4 | Flood District 8 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 2272 | Los Angeles County Flood Control District 284 | Special District 4 | Flood District 9 | Los Angeles 6 | 6.732 | Flood Control | 0 | Local Other or Unknown 14 | 4 | |
8298 | 8298 | 8297 | {"type": "Polygon", "coordinates": [[[-118.42996, 34.33076], [-118.42998, 34.3313], [-118.42978, 34.33175], [-118.42986, 34.33266], [-118.42959, 34.33271], [-118.42929, 34.33205], [-118.42879, 34.33196], [-118.4284, 34.33155], [-118.42781, 34.33143], [-118.42735, 34.33145], [-118.42681, 34.33168], [-118.42663, 34.3315], [-118.42709, 34.33123], [-118.42776, 34.33103], [-118.42849, 34.33092], [-118.42842, 34.33034], [-118.42684, 34.33026], [-118.42679, 34.33], [-118.42852, 34.32962], [-118.42869, 34.32985], [-118.42874, 34.32985], [-118.42897, 34.32974], [-118.42912, 34.3296], [-118.42922, 34.32943], [-118.42925, 34.32922], [-118.4294, 34.32923], [-118.4294, 34.32942], [-118.42954, 34.33013], [-118.42957, 34.33017], [-118.42962, 34.3302], [-118.42968, 34.3302], [-118.42974, 34.33019], [-118.4298, 34.33026], [-118.42957, 34.33035], [-118.42956, 34.33037], [-118.42969, 34.33054], [-118.42996, 34.33076]]]} | No Public Access 3 | 12716 | Flood Control | 18953 | 2272 | Los Angeles County Flood Control District 287 | Special District 4 | Flood District 8 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 2272 | Los Angeles County Flood Control District 284 | Special District 4 | Flood District 9 | Los Angeles 6 | 12.167 | Flood Control | 0 | Local Other or Unknown 14 | 4 | |
8296 | 8296 | 8295 | {"type": "Polygon", "coordinates": [[[-118.46627, 34.32993], [-118.46601, 34.32993], [-118.466, 34.32966], [-118.46531, 34.32965], [-118.46531, 34.32993], [-118.46492, 34.32992], [-118.4651, 34.32938], [-118.46586, 34.32944], [-118.46627, 34.32993]]]} | No Public Access 3 | 12715 | Flood Control | 18953 | 2272 | Los Angeles County Flood Control District 287 | Special District 4 | Flood District 8 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 2272 | Los Angeles County Flood Control District 284 | Special District 4 | Flood District 9 | Los Angeles 6 | 0.889 | Flood Control | 0 | Local Other or Unknown 14 | 4 | |
8295 | 8295 | 8294 | {"type": "Polygon", "coordinates": [[[-118.44066, 34.32991], [-118.44064, 34.33152], [-118.43961, 34.33184], [-118.43917, 34.33239], [-118.43727, 34.33306], [-118.43591, 34.33306], [-118.43464, 34.33355], [-118.4344, 34.33311], [-118.43366, 34.33287], [-118.43328, 34.33317], [-118.43276, 34.33272], [-118.43306, 34.33152], [-118.43441, 34.33071], [-118.43503, 34.33053], [-118.43502, 34.3299], [-118.43183, 34.32988], [-118.43185, 34.3275], [-118.43215, 34.32748], [-118.43219, 34.32749], [-118.43222, 34.32753], [-118.43237, 34.32753], [-118.43239, 34.32749], [-118.43242, 34.32747], [-118.43272, 34.32745], [-118.43274, 34.32766], [-118.43307, 34.32764], [-118.43308, 34.32772], [-118.43659, 34.32755], [-118.43659, 34.32747], [-118.43694, 34.32744], [-118.43744, 34.32745], [-118.43745, 34.32741], [-118.43782, 34.32741], [-118.43782, 34.3299], [-118.44066, 34.32991]]]} | No Public Access 3 | 12714 | Flood Control | 18953 | 2272 | Los Angeles County Flood Control District 287 | Special District 4 | Flood District 8 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 2272 | Los Angeles County Flood Control District 284 | Special District 4 | Flood District 9 | Los Angeles 6 | 85.213 | Flood Control | 0 | Local Other or Unknown 14 | 4 | |
8220 | 8220 | 8219 | {"type": "MultiPolygon", "coordinates": [[[[-121.67375, 37.19466], [-121.67332, 37.19501], [-121.6721, 37.19402], [-121.66931, 37.19621], [-121.66716, 37.19428], [-121.66577, 37.19395], [-121.66325, 37.19234], [-121.66291, 37.19106], [-121.65873, 37.18793], [-121.65677, 37.18978], [-121.65701, 37.18997], [-121.6572, 37.1902], [-121.65728, 37.19036], [-121.65744, 37.1908], [-121.65752, 37.19093], [-121.65768, 37.19109], [-121.65782, 37.19118], [-121.65797, 37.19124], [-121.65814, 37.19129], [-121.65831, 37.1913], [-121.65903, 37.1915], [-121.65932, 37.19154], [-121.65951, 37.19153], [-121.6597, 37.19149], [-121.65996, 37.1914], [-121.66012, 37.1913], [-121.66116, 37.19129], [-121.6613, 37.19151], [-121.66078, 37.1925], [-121.66037, 37.19312], [-121.65995, 37.19326], [-121.65974, 37.19354], [-121.65972, 37.19382], [-121.65989, 37.19421], [-121.6605, 37.19431], [-121.6609, 37.19442], [-121.66129, 37.19454], [-121.6617, 37.19489], [-121.662, 37.19498], [-121.66253, 37.19545], [-121.66294, 37.19584], [-121.66305, 37.19586], [-121.66327, 37.19587], [-121.66349, 37.19586], [-121.6638, 37.19579], [-121.66439, 37.19537], [-121.66444, 37.19523], [-121.66481, 37.19494], [-121.66497, 37.19493], [-121.66523, 37.19506], [-121.66593, 37.1955], [-121.66643, 37.19552], [-121.66731, 37.19526], [-121.66776, 37.19538], [-121.66841, 37.19586], [-121.66844, 37.19627], [-121.66918, 37.19753], [-121.6694, 37.19754], [-121.66957, 37.19745], [-121.66991, 37.19746], [-121.67042, 37.19752], [-121.67092, 37.19764], [-121.67147, 37.19794], [-121.67173, 37.19829], [-121.67164, 37.19869], [-121.67182, 37.19903], [-121.67264, 37.1994], [-121.67294, 37.19944], [-121.6729, 37.19964], [-121.67274, 37.2], [-121.67273, 37.20041], [-121.67311, 37.2009], [-121.67291, 37.20106], [-121.6719, 37.20147], [-121.67156, 37.2015], [-121.67086, 37.20186], [-121.67039, 37.20185], [-121.67037, 37.20194], [-121.67046, 37.20195], [-121.67045, 37.20208], [-121.67064, 37.20215], [-121.6721, 37.20242], [-121.67219, 37.20247], [-121.67226, 37.20254], [-121.67229, 37.20263], [-121.6723, 37.20271], [-121.67076, 37.20315], [-121.67054, 37.20325], [-121.67028, 37.20347], [-121.67051, 37.20373], [-121.67054, 37.20382], [-121.6702, 37.20496], [-121.66781, 37.20618], [-121.66476, 37.20618], [-121.6638, 37.20497], [-121.66105, 37.20567], [-121.66095, 37.20549], [-121.65936, 37.20486], [-121.65888, 37.20465], [-121.65833, 37.20381], [-121.65789, 37.20355], [-121.65783, 37.20317], [-121.65723, 37.20271], [-121.65558, 37.20205], [-121.65509, 37.20198], [-121.65315, 37.20186], [-121.65243, 37.20147], [-121.65162, 37.20136], [-121.65087, 37.20155], [-121.6508, 37.20184], [-121.65101, 37.2022], [-121.65087, 37.20231], [-121.65047, 37.20198], [-121.65004, 37.20155], [-121.64942, 37.2015], [-121.64935, 37.20239], [-121.65039, 37.20416], [-121.65064, 37.20448], [-121.64971, 37.20385], [-121.64956, 37.20394], [-121.64947, 37.20448], [-121.64968, 37.20529], [-121.64911, 37.20421], [-121.64921, 37.2034], [-121.64911, 37.20312], [-121.64884, 37.20299], [-121.64858, 37.20242], [-121.64845, 37.20157], [-121.64816, 37.20148], [-121.64781, 37.20164], [-121.64757, 37.20189], [-121.64736, 37.20206], [-121.64705, 37.20252], [-121.64665, 37.20358], [-121.64617, 37.20431], [-121.64539, 37.20467], [-121.64594, 37.20319], [-121.64673, 37.20119], [-121.64707, 37.20093], [-121.64721, 37.20057], [-121.64569, 37.20077], [-121.64536, 37.20098], [-121.64461, 37.20026], [-121.64537, 37.20036], [-121.64596, 37.2003], [-121.64698, 37.20009], [-121.64725, 37.19995], [-121.64693, 37.19888], [-121.64662, 37.19767], [-121.64676, 37.19726], [-121.64666, 37.19657], [-121.64633, 37.19607], [-121.64615, 37.19585], [-121.64556, 37.19615], [-121.64435, 37.19653], [-121.6442, 37.19712], [-121.64375, 37.19745], [-121.6435, 37.19724], [-121.64379, 37.19688], [-121.64391, 37.19609], [-121.64415, 37.19598], [-121.64442, 37.19578], [-121.64476, 37.19564], [-121.64514, 37.19536], [-121.64532, 37.19502], [-121.64544, 37.19438], [-121.64532, 37.19405], [-121.64513, 37.19384], [-121.64466, 37.19347], [-121.64426, 37.19335], [-121.64369, 37.19288], [-121.64316, 37.19251], [-121.6469, 37.19007], [-121.64731, 37.18986], [-121.64827, 37.19022], [-121.64888, 37.19041], [-121.64927, 37.19081], [-121.64959, 37.19108], [-121.64978, 37.19134], [-121.65018, 37.19125], [-121.6506, 37.19122], [-121.65101, 37.19125], [-121.65141, 37.19134], [-121.65167, 37.19144], [-121.6519, 37.19155], [-121.65338, 37.1925], [-121.65464, 37.18997], [-121.65256, 37.18777], [-121.6494, 37.18505], [-121.65302, 37.17121], [-121.65615, 37.17223], [-121.65621, 37.17216], [-121.65783, 37.17259], [-121.65882, 37.17264], [-121.65952, 37.17264], [-121.66124, 37.17269], [-121.65752, 37.17852], [-121.65647, 37.18174], [-121.65872, 37.18298], [-121.66133, 37.18434], [-121.66205, 37.18443], [-121.66306, 37.18517], [-121.6641, 37.1855], [-121.66506, 37.18668], [-121.66659, 37.1872], [-121.66687, 37.18756], [-121.66654, 37.18865], [-121.66646, 37.18927], [-121.66776, 37.1906], [-121.66918, 37.19163], [-121.67142, 37.19208], [-121.67375, 37.19466]]], [[[-121.68743, 37.19048], [-121.68638, 37.19073], [-121.68551, 37.19118], [-121.6846, 37.19161], [-121.68377, 37.19207], [-121.68286, 37.19246], [-121.68243, 37.19194], [-121.68333, 37.19155], [-121.68419, 37.19107], [-121.68506, 37.19067], [-121.68593, 37.1902], [-121.68702, 37.18995], [-121.68743, 37.19048]]]]} | No Public Access 3 | 47778 | Coyote Ridge Property | 31578 | 2143 | Santa Clara Valley Water District 483 | Special District 4 | Water District 13 | http://www.valleywater.org/ | Special District 4 | 2142 | Santa Clara Valley Open Space Authority 468 | Special District 4 | Recreation/Parks District 4 | Santa Clara 19 | 1178.052 | Coyote Ridge Property | 0 | Local Other or Unknown 14 | 4 | |
8218 | 8218 | 8217 | {"type": "MultiPolygon", "coordinates": [[[[-117.15598, 33.10707], [-117.15561, 33.10724], [-117.15541, 33.10729], [-117.15513, 33.10743], [-117.15484, 33.1075], [-117.15451, 33.10766], [-117.15398, 33.10779], [-117.15382, 33.10784], [-117.15357, 33.10796], [-117.15344, 33.10805], [-117.1534, 33.10809], [-117.15337, 33.10818], [-117.1534, 33.10835], [-117.15356, 33.10863], [-117.15377, 33.10915], [-117.15402, 33.10997], [-117.15394, 33.10991], [-117.15386, 33.10987], [-117.15326, 33.10975], [-117.15296, 33.10964], [-117.15283, 33.11018], [-117.15297, 33.11064], [-117.15345, 33.11053], [-117.15394, 33.11036], [-117.15385, 33.11066], [-117.1538, 33.11078], [-117.15369, 33.11096], [-117.15363, 33.111], [-117.15356, 33.11101], [-117.15302, 33.11098], [-117.15136, 33.11131], [-117.15112, 33.11093], [-117.15102, 33.11072], [-117.151, 33.11064], [-117.151, 33.11048], [-117.15098, 33.11037], [-117.15081, 33.10999], [-117.1507, 33.10967], [-117.1507, 33.10956], [-117.15072, 33.10945], [-117.15071, 33.10937], [-117.15038, 33.10894], [-117.15017, 33.10859], [-117.15012, 33.10852], [-117.15003, 33.10847], [-117.14962, 33.10829], [-117.14952, 33.10827], [-117.14942, 33.10828], [-117.14875, 33.10845], [-117.14855, 33.10847], [-117.14838, 33.10846], [-117.14822, 33.10849], [-117.14822, 33.1055], [-117.14954, 33.10548], [-117.1506, 33.10609], [-117.15282, 33.10654], [-117.15402, 33.10642], [-117.15598, 33.10707]]], [[[-117.16972, 33.11406], [-117.16939, 33.11424], [-117.16912, 33.11452], [-117.16906, 33.11473], [-117.16849, 33.11523], [-117.16743, 33.1153], [-117.16683, 33.11496], [-117.16594, 33.11491], [-117.16555, 33.11498], [-117.16536, 33.11482], [-117.16487, 33.11397], [-117.1649, 33.1136], [-117.1652, 33.11353], [-117.16583, 33.11369], [-117.16658, 33.11343], [-117.16665, 33.11328], [-117.1677, 33.11329], [-117.16765, 33.11374], [-117.16779, 33.11418], [-117.1683, 33.11424], [-117.16868, 33.11397], [-117.16907, 33.11344], [-117.16928, 33.11337], [-117.16945, 33.11372], [-117.16972, 33.11395], [-117.16972, 33.11406]]]]} | No Public Access 3 | 47787 | South Lake Mitigation | 31663 | 2170 | Vallecitos Water District 879 | Special District 4 | Water District 13 | http://www.vwd.org/ | Special District 4 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | San Diego 4 | 72.132 | South Lake Mitigation | 0 | Local Other or Unknown 14 | 4 | |
8209 | 8209 | 8208 | {"type": "Polygon", "coordinates": [[[-118.34266, 34.12073], [-118.34239, 34.12092], [-118.34236, 34.12088], [-118.34217, 34.12072], [-118.3424, 34.12055], [-118.34256, 34.12064], [-118.34266, 34.12073]]]} | No Public Access 3 | 12464 | Los Angeles Department of Water and Power | 21482 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.23 | Los Angeles Department of Water and Power | 0 | Local Other or Unknown 14 | 4 | |
8208 | 8208 | 8207 | {"type": "MultiPolygon", "coordinates": [[[[-118.34152, 34.1213], [-118.34152, 34.12134], [-118.34148, 34.12139], [-118.34142, 34.1215], [-118.34141, 34.12163], [-118.34115, 34.12183], [-118.34097, 34.12159], [-118.34146, 34.12124], [-118.34152, 34.1213]]], [[[-118.34202, 34.12109], [-118.34195, 34.12117], [-118.3418, 34.12119], [-118.34166, 34.12124], [-118.34159, 34.12124], [-118.34154, 34.12118], [-118.34192, 34.1209], [-118.34202, 34.121], [-118.34202, 34.12109]]]]} | No Public Access 3 | 12463 | Los Angeles Department of Water and Power | 21482 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.578 | Los Angeles Department of Water and Power | 0 | Local Other or Unknown 14 | 4 | |
8207 | 8207 | 8206 | {"type": "Polygon", "coordinates": [[[-118.34724, 34.11998], [-118.34703, 34.11998], [-118.34699, 34.11995], [-118.34697, 34.11996], [-118.34677, 34.11971], [-118.34724, 34.1197], [-118.34724, 34.11998]]]} | No Public Access 3 | 12461 | Los Angeles Department of Water and Power | 21482 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.25 | Los Angeles Department of Water and Power | 0 | Local Other or Unknown 14 | 4 | |
8206 | 8206 | 8205 | {"type": "MultiPolygon", "coordinates": [[[[-118.35903, 34.10633], [-118.35888, 34.10635], [-118.35902, 34.10725], [-118.35784, 34.10989], [-118.35508, 34.11224], [-118.35508, 34.11246], [-118.35482, 34.11246], [-118.35456, 34.11268], [-118.35061, 34.1192], [-118.35056, 34.11915], [-118.35048, 34.11913], [-118.35045, 34.1191], [-118.35045, 34.11906], [-118.35054, 34.11892], [-118.35054, 34.11881], [-118.35051, 34.11875], [-118.35429, 34.11252], [-118.3551, 34.11182], [-118.35542, 34.11156], [-118.35756, 34.10974], [-118.35868, 34.10723], [-118.35847, 34.10581], [-118.35835, 34.10582], [-118.35832, 34.1057], [-118.35883, 34.10517], [-118.35887, 34.10522], [-118.35888, 34.10529], [-118.35888, 34.10543], [-118.35903, 34.10633]]], [[[-118.35052, 34.11935], [-118.3503, 34.1197], [-118.3503, 34.11974], [-118.35023, 34.11985], [-118.35012, 34.11986], [-118.35002, 34.11989], [-118.34983, 34.11999], [-118.34977, 34.12001], [-118.34962, 34.12001], [-118.34946, 34.11999], [-118.34934, 34.12], [-118.34923, 34.12002], [-118.34903, 34.12012], [-118.34901, 34.12012], [-118.349, 34.11997], [-118.34841, 34.11998], [-118.34776, 34.11971], [-118.34993, 34.11969], [-118.35021, 34.11926], [-118.35045, 34.11935], [-118.35052, 34.11935]]]]} | No Public Access 3 | 12460 | Los Angeles Department of Water and Power | 21482 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 15.526 | Los Angeles Department of Water and Power | 0 | Local Other or Unknown 14 | 4 | |
8202 | 8202 | 8201 | {"type": "Polygon", "coordinates": [[[-118.33726, 34.1416], [-118.33447, 34.14462], [-118.33195, 34.14673], [-118.33158, 34.14719], [-118.33121, 34.14736], [-118.33087, 34.14757], [-118.33172, 34.14655], [-118.33181, 34.14647], [-118.33421, 34.14444], [-118.33691, 34.14153], [-118.33594, 34.1372], [-118.33525, 34.13611], [-118.33514, 34.1361], [-118.33504, 34.13595], [-118.33491, 34.13583], [-118.3349, 34.13579], [-118.33491, 34.13557], [-118.3348, 34.13541], [-118.33462, 34.1353], [-118.33461, 34.13527], [-118.33462, 34.13512], [-118.33431, 34.13463], [-118.33375, 34.13174], [-118.33405, 34.12667], [-118.33463, 34.12624], [-118.33474, 34.12622], [-118.33484, 34.12622], [-118.33491, 34.12625], [-118.335, 34.12634], [-118.33437, 34.1268], [-118.33408, 34.13172], [-118.33454, 34.13412], [-118.33449, 34.13422], [-118.33457, 34.13423], [-118.33464, 34.13456], [-118.33626, 34.13712], [-118.33726, 34.1416]]]} | No Public Access 3 | 12457 | Los Angeles Department of Water and Power | 21482 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 19.655 | Los Angeles Department of Water and Power | 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]);