units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
50 rows where MNG_AG_TYP = 16 sorted by PARK_URL
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, LAYER, MNG_AG_ID, PARK_URL, COUNTY, LABEL_NAME, YR_EST, GAP_STS
DES_TP 25
- Local Recreation Area 23
- Local Other or Unknown 4
- Local Park 1
- Local Conservation Area 1
- None 1
- Local Resource Management Area 1
- None 1
- National Wildlife Refuge 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
AGNCY_WEB 15 ✖
- http://www.kinneloairrigationdistrict.info/ 13
- http://www.lrcid.com/ 13
- http://www.nid.dst.ca.us/recreation.cfm 5
- http://www.eid.org/ 4
- http://www.iid.com/ 3
- http://www.lakemcclure.com/ 2
- http://www.mid.org/ 2
- http://lacanadairrigation.org/ 1
- http://www.blm.gov/wo/st/en.html 1
- http://www.bvid.org/ 1
- http://www.kdwcd.com/ 1
- http://www.madera-id.org/ 1
- http://www.sfidwater.org/ 1
- http://www.tid.org/ 1
- http://www.vid-h2o.org/ 1
AGNCY_ID 15 ✖
MNG_AGENCY 14
- Kinneloa Irrigation District 13
- Littlerock Creek Irrigation District 13
- Nevada Irrigation District 5
- El Dorado Irrigation District 4
- Imperial Irrigation District 3
- Merced Irrigation District 3
- Modesto Irrigation District 2
- Vista Irrigation District 1
- La Canada Irrigation District 1
- Kaweah Delta Water Conservation District 1
- Santa Fe Irrigation District 1
- Turlock Irrigation District 1
- Madera Irrigation District 1
- Browns Valley Irrigation District 1
ACCESS_TYP 4
MNG_AG_TYP 1
- Irrigation District · 50 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1115 | 1115 | 1114 | {"type": "Polygon", "coordinates": [[[-117.8843, 33.96567], [-117.88426, 33.96587], [-117.88394, 33.96616], [-117.88344, 33.96606], [-117.88359, 33.96552], [-117.8843, 33.96567]]]} | No Public Access 3 | 6558 | Roland Area County Water District Land | 24569 | 2054 | Kinneloa Irrigation District 320 | Special District 4 | Irrigation District 17 | http://www.kinneloairrigationdistrict.info/ | Special District 4 | 2054 | Kinneloa Irrigation District 317 | Special District 4 | Irrigation District 16 | Los Angeles 6 | 0.931 | Roland Area County Water District Land | None 101 | |||
1410 | 1410 | 1409 | {"type": "Polygon", "coordinates": [[[-118.22677, 34.25192], [-118.22147, 34.25178], [-118.21696, 34.25173], [-118.21705, 34.24813], [-118.22159, 34.24846], [-118.22162, 34.24484], [-118.22168, 34.24273], [-118.22273, 34.24274], [-118.22322, 34.24194], [-118.22394, 34.24193], [-118.22353, 34.24295], [-118.22307, 34.24366], [-118.22309, 34.24373], [-118.22331, 34.24422], [-118.2239, 34.24472], [-118.22419, 34.24556], [-118.22416, 34.24562], [-118.22416, 34.24572], [-118.22422, 34.24582], [-118.22435, 34.24591], [-118.2245, 34.24592], [-118.22486, 34.24607], [-118.22514, 34.24612], [-118.22528, 34.24618], [-118.22546, 34.24632], [-118.22551, 34.24641], [-118.22555, 34.24651], [-118.22555, 34.24667], [-118.22531, 34.24754], [-118.22529, 34.24766], [-118.2253, 34.24776], [-118.22533, 34.24792], [-118.22539, 34.24805], [-118.22551, 34.24825], [-118.22539, 34.24843], [-118.22556, 34.24872], [-118.22597, 34.24856], [-118.22597, 34.25048], [-118.22621, 34.25075], [-118.22637, 34.251], [-118.22652, 34.2513], [-118.22672, 34.25162], [-118.22677, 34.25192]]]} | No Public Access 3 | 12350 | La Canada Irrigation District Open Space | 20744 | 2055 | La Canada Irrigation District 363 | Special District 4 | Irrigation District 17 | http://lacanadairrigation.org/ | Special District 4 | 2055 | La Canada Irrigation District 359 | Special District 4 | Irrigation District 16 | Los Angeles 6 | 120.857 | La Canada Irrigation District OS | 0 | Local Recreation Area 3 | 4 | |
1532 | 1532 | 1531 | {"type": "MultiPolygon", "coordinates": [[[[-115.83381, 33.16563], [-115.83378, 33.16928], [-115.82198, 33.16929], [-115.82198, 33.16199], [-115.80482, 33.16192], [-115.80482, 33.15463], [-115.82199, 33.15469], [-115.82199, 33.16199], [-115.82687, 33.16198], [-115.82686, 33.16563], [-115.83381, 33.16563]]], [[[-115.90534, 33.29488], [-115.89218, 33.29486], [-115.89209, 33.28754], [-115.90085, 33.28756], [-115.90091, 33.29121], [-115.90529, 33.29122], [-115.90534, 33.29488]]], [[[-115.94493, 33.33904], [-115.94492, 33.32776], [-115.94935, 33.32775], [-115.94935, 33.3315], [-115.95377, 33.33149], [-115.95378, 33.33524], [-115.95819, 33.33522], [-115.95819, 33.33896], [-115.94493, 33.33904]]], [[[-115.87442, 33.40541], [-115.87441, 33.41234], [-115.85704, 33.41234], [-115.85647, 33.39822], [-115.86469, 33.39821], [-115.86509, 33.40498], [-115.8656, 33.40501], [-115.86561, 33.40527], [-115.87142, 33.40527], [-115.87442, 33.40541]]], [[[-116.01564, 33.39721], [-116.01562, 33.40443], [-116.01558, 33.40444], [-116.01555, 33.41176], [-115.99783, 33.4119], [-115.99791, 33.4265], [-115.98011, 33.42661], [-115.98006, 33.41198], [-115.96255, 33.41242], [-115.96254, 33.39762], [-115.9451, 33.39771], [-115.94509, 33.38299], [-115.92747, 33.38307], [-115.92745, 33.3906], [-115.90998, 33.39065], [-115.90996, 33.38314], [-115.89259, 33.38356], [-115.89256, 33.37504], [-115.89246, 33.36837], [-115.87583, 33.3684], [-115.87452, 33.36836], [-115.87415, 33.35374], [-115.89244, 33.35368], [-115.89245, 33.36836], [-115.90998, 33.36836], [-115.90999, 33.36835], [-115.90998, 33.35365], [-115.89247, 33.35368], [-115.89243, 33.3391], [-115.87371, 33.33912], [-115.87393, 33.32377], [-115.85611, 33.3237], [-115.85604, 33.33922], [-115.83881, 33.3393], [-115.83896, 33.32365], [-115.82156, 33.32357], [-115.82146, 33.33939], [-115.8041, 33.33951], [-115.80422, 33.3235], [-115.78723, 33.32344], [-115.7871, 33.33961], [-115.79552, 33.33958], [-115.80408, 33.33952], [-115.80398, 33.35407], [-115.8213, 33.35429], [-115.82123, 33.36847], [-115.83855, 33.36875], [-115.83851, 33.37503], [-115.83857, 33.38347], [-115.85586, 33.38345], [-115.85645, 33.39789], [-115.83907, 33.39793], [-115.82237, 33.398], [-115.82236, 33.39779], [-115.82164, 33.39779], [-115.82144, 33.39075], [-115.83012, 33.39073], [-115.83013, 33.39071], [-115.83007, 33.38892], [-115.82139, 33.38894], [-115.82123, 33.3835], [-115.82121, 33.37503], [-115.82124, 33.36848], [-115.80396, 33.36857], [-115.80399, 33.35408], [-115.76974, 33.35424], [-115.76973, 33.35342], [-115.76994, 33.32338], [-115.75247, 33.32209], [-115.75236, 33.33955], [-115.73458, 33.33953], [-115.73457, 33.33983], [-115.73443, 33.33983], [-115.73573, 33.32261], [-115.73574, 33.32203], [-115.71843, 33.322], [-115.71842, 33.32266], [-115.71712, 33.33982], [-115.71685, 33.33982], [-115.71684, 33.33967], [-115.69966, 33.33961], [-115.70108, 33.32203], [-115.68392, 33.32199], [-115.68235, 33.33986], [-115.68215, 33.3543], [-115.66495, 33.35426], [-115.66497, 33.34343], [-115.66037, 33.34342], [-115.66037, 33.33982], [-115.66676, 33.33981], [-115.66667, 33.32201], [-115.64872, 33.32197], [-115.6487, 33.33981], [-115.64435, 33.33978], [-115.64436, 33.33711], [-115.64004, 33.33708], [-115.64005, 33.33441], [-115.63573, 33.33438], [-115.63575, 33.32904], [-115.63144, 33.32902], [-115.63146, 33.32188], [-115.62293, 33.32185], [-115.62293, 33.31461], [-115.61865, 33.31458], [-115.61864, 33.31096], [-115.61436, 33.31094], [-115.61435, 33.30369], [-115.61001, 33.30367], [-115.61001, 33.29277], [-115.60566, 33.29275], [-115.60569, 33.28912], [-115.60134, 33.2891], [-115.60138, 33.28547], [-115.59704, 33.28544], [-115.59711, 33.27818], [-115.59708, 33.26367], [-115.58839, 33.26367], [-115.58835, 33.24925], [-115.59428, 33.24956], [-115.59436, 33.24923], [-115.59703, 33.24923], [-115.59706, 33.23474], [-115.57973, 33.23473], [-115.57976, 33.22813], [-115.57982, 33.22021], [-115.57981, 33.20924], [-115.58413, 33.20924], [-115.58414, 33.20559], [-115.58846, 33.2056], [-115.58851, 33.1984], [-115.59716, 33.19835], [-115.59713, 33.20562], [-115.61442, 33.2056], [-115.6144, 33.19099], [-115.63163, 33.19095], [-115.63147, 33.17661], [-115.63153, 33.16575], [-115.63581, 33.16574], [-115.63582, 33.16212], [-115.6401, 33.16211], [-115.64012, 33.15845], [-115.6444, 33.15843], [-115.64443, 33.15477], [-115.64871, 33.15475], [-115.64877, 33.14741], [-115.66632, 33.14745], [-115.68348, 33.1474], [-115.68339, 33.13303], [-115.68339, 33.11864], [-115.66637, 33.11857], [-115.66641, 33.104], [-115.68355, 33.10408], [-115.68339, 33.11863], [-115.69211, 33.11862], [-115.69211, 33.12582], [-115.70082, 33.12581], [-115.70084, 33.10413], [-115.73531, 33.10411], [-115.73536, 33.09685], [-115.75264, 33.09672], [-115.75266, 33.10034], [-115.75708, 33.10035], [-115.75709, 33.10398], [-115.76152, 33.104], [-115.76147, 33.10763], [-115.77031, 33.10767], [-115.77015, 33.11857], [-115.77015, 33.12725], [-115.78773, 33.12721], [-115.78776, 33.13303], [-115.77015, 33.13305], [-115.77014, 33.14745], [-115.78758, 33.14741], [-115.7875, 33.16199], [-115.77011, 33.162], [-115.77014, 33.14745], [-115.75242, 33.14742], [-115.75245, 33.13311], [-115.75081, 33.13309], [-115.73529, 33.13305], [-115.73529, 33.14742], [-115.71803, 33.14745], [-115.71802, 33.14023], [-115.70081, 33.14022], [-115.70077, 33.14743], [-115.68349, 33.1474], [-115.68349, 33.16204], [-115.6665, 33.16203], [-115.66649, 33.17657], [-115.6665, 33.17658], [-115.68352, 33.17655], [-115.68358, 33.191], [-115.68043, 33.19101], [-115.66655, 33.19099], [-115.66654, 33.19104], [-115.66647, 33.19104], [-115.64877, 33.19098], [-115.64885, 33.20569], [-115.6317, 33.20562], [-115.63178, 33.22012], [-115.62588, 33.2201], [-115.61438, 33.22014], [-115.61435, 33.22742], [-115.61003, 33.22743], [-115.61002, 33.23107], [-115.61434, 33.23107], [-115.6143, 33.24921], [-115.62582, 33.2492], [-115.63172, 33.24923], [-115.63163, 33.26368], [-115.63164, 33.26369], [-115.64884, 33.26369], [-115.64892, 33.25003], [-115.64886, 33.24918], [-115.66651, 33.24915], [-115.66655, 33.25004], [-115.66654, 33.26368], [-115.66655, 33.26369], [-115.68372, 33.26364], [-115.68375, 33.25004], [-115.68367, 33.24913], [-115.70102, 33.24913], [-115.70108, 33.25005], [-115.70101, 33.26369], [-115.70102, 33.2637], [-115.71822, 33.26373], [-115.71823, 33.25005], [-115.71817, 33.24918], [-115.73556, 33.24917], [-115.73558, 33.25003], [-115.73559, 33.26381], [-115.75082, 33.26381], [-115.75251, 33.26379], [-115.75256, 33.25004], [-115.75249, 33.24929], [-115.7622, 33.25009], [-115.76328, 33.25008], [-115.77001, 33.25062], [-115.76993, 33.26535], [-115.76994, 33.26536], [-115.78725, 33.26543], [-115.78727, 33.25067], [-115.80456, 33.25072], [-115.80455, 33.26546], [-115.82178, 33.26548], [-115.8218, 33.25074], [-115.83917, 33.25072], [-115.8392, 33.25007], [-115.83922, 33.23474], [-115.8564, 33.23466], [-115.85638, 33.25005], [-115.85637, 33.25077], [-115.83918, 33.25073], [-115.83917, 33.25074], [-115.8392, 33.2655], [-115.85634, 33.26547], [-115.85631, 33.28015], [-115.83925, 33.28014], [-115.83908, 33.29477], [-115.85622, 33.29485], [-115.85614, 33.30925], [-115.87405, 33.30937], [-115.87395, 33.32376], [-115.89239, 33.32388], [-115.89232, 33.30942], [-115.90986, 33.30952], [-115.9098, 33.3022], [-115.91856, 33.30222], [-115.91861, 33.30589], [-115.92737, 33.30591], [-115.92741, 33.30958], [-115.93179, 33.30959], [-115.9318, 33.31318], [-115.93617, 33.31319], [-115.93618, 33.32398], [-115.92745, 33.32396], [-115.92745, 33.33906], [-115.94492, 33.33905], [-115.94492, 33.3536], [-115.94493, 33.35361], [-115.96261, 33.35359], [-115.96261, 33.34259], [-115.96693, 33.34257], [-115.96693, 33.34624], [-115.97125, 33.34623], [-115.97125, 33.3499], [-115.97556, 33.3499], [-115.97556, 33.35358], [-115.96262, 33.35359], [-115.96263, 33.36831], [-115.97989, 33.36828], [-115.97987, 33.35358], [-115.9887, 33.35341], [-115.98869, 33.36084], [-115.9975, 33.36075], [-115.99747, 33.36826], [-115.9799, 33.36828], [-115.97989, 33.37505], [-115.97993, 33.38277], [-115.99761, 33.38274], [-115.99778, 33.3974], [-116.00082, 33.39739], [-116.01564, 33.39721]], [[-115.99777, 33.39742], [-115.99776, 33.39741], [-115.98, 33.39751], [-115.98007, 33.41197], [-115.99782, 33.4119], [-115.99777, 33.39742]], [[-115.97998, 33.39751], [-115.97992, 33.38278], [-115.96255, 33.38288], [-115.96255, 33.39761], [-115.97998, 33.39751]], [[-115.92746, 33.36835], [-115.92745, 33.36834], [-115.90999, 33.36836], [-115.90995, 33.38314], [-115.92747, 33.38307], [-115.9275, 33.37505], [-115.92746, 33.36835]], [[-115.94493, 33.36833], [-115.94495, 33.36832], [-115.94493, 33.35361], [-115.92746, 33.35361], [-115.92746, 33.36835], [-115.94493, 33.36833]], [[-115.96254, 33.38288], [-115.9626, 33.36832], [-115.94495, 33.36833], [-115.94496, 33.37506], [-115.9451, 33.38298], [-115.96254, 33.38288]], [[-115.92745, 33.35361], [-115.92745, 33.33907], [-115.90997, 33.33911], [-115.90998, 33.35364], [-115.92745, 33.35361]], [[-115.90996, 33.32392], [-115.89239, 33.32388], [-115.89244, 33.3391], [-115.90996, 33.33911], [-115.90996, 33.32392]], [[-115.85614, 33.30926], [-115.839, 33.30916], [-115.83897, 33.32365], [-115.8561, 33.32369], [-115.85614, 33.30926]], [[-115.82162, 33.30908], [-115.82161, 33.30907], [-115.80431, 33.309], [-115.80422, 33.3235], [-115.82155, 33.32357], [-115.82162, 33.30908]], [[-115.78726, 33.30888], [-115.76998, 33.30876], [-115.76995, 33.32338], [-115.78723, 33.32343], [-115.78726, 33.30888]], [[-115.75246, 33.32209], [-115.75247, 33.32208], [-115.7525, 33.30766], [-115.75083, 33.30763], [-115.73572, 33.30753], [-115.73574, 33.32203], [-115.75082, 33.32207], [-115.75246, 33.32209]], [[-115.71841, 33.322], [-115.71845, 33.30744], [-115.70116, 33.30733], [-115.70109, 33.32203], [-115.71841, 33.322]], [[-115.68391, 33.32199], [-115.68392, 33.32198], [-115.68388, 33.30725], [-115.66672, 33.30727], [-115.66668, 33.322], [-115.68391, 33.32199]], [[-115.6487, 33.32197], [-115.64871, 33.32196], [-115.64878, 33.30731], [-115.63154, 33.30739], [-115.63147, 33.32188], [-115.6487, 33.32197]], [[-115.66664, 33.29272], [-115.64876, 33.29274], [-115.64878, 33.3073], [-115.66671, 33.30727], [-115.66664, 33.29272]], [[-115.64874, 33.29274], [-115.64884, 33.27825], [-115.63158, 33.27828], [-115.63159, 33.29283], [-115.64874, 33.29274]], [[-115.63157, 33.27828], [-115.63158, 33.27827], [-115.63157, 33.27104], [-115.63163, 33.26369], [-115.61442, 33.26362], [-115.61444, 33.27094], [-115.62302, 33.27096], [-115.62303, 33.27827], [-115.63157, 33.27828]], [[-115.61441, 33.26362], [-115.61442, 33.26361], [-115.6143, 33.24922], [-115.60567, 33.24923], [-115.60575, 33.26363], [-115.61441, 33.26362]], [[-115.66662, 33.27821], [-115.66661, 33.27098], [-115.66653, 33.26369], [-115.64884, 33.2637], [-115.64884, 33.27824], [-115.66662, 33.27821]], [[-115.70101, 33.26371], [-115.68373, 33.26365], [-115.68377, 33.27819], [-115.70107, 33.27823], [-115.70101, 33.26371]], [[-115.73562, 33.27832], [-115.73563, 33.27831], [-115.73557, 33.26381], [-115.71823, 33.26374], [-115.71833, 33.27827], [-115.73562, 33.27832]], [[-115.76996, 33.27997], [-115.76997, 33.27997], [-115.76993, 33.26536], [-115.75251, 33.2638], [-115.75249, 33.27837], [-115.76996, 33.27997]], [[-115.80451, 33.2801], [-115.80452, 33.28009], [-115.80455, 33.26547], [-115.78726, 33.26544], [-115.78724, 33.28006], [-115.80451, 33.2801]], [[-115.83923, 33.28014], [-115.83924, 33.28013], [-115.83919, 33.2655], [-115.82179, 33.26548], [-115.82176, 33.28012], [-115.83923, 33.28014]], [[-115.82176, 33.28014], [-115.80452, 33.2801], [-115.8044, 33.29454], [-115.82174, 33.29467], [-115.82176, 33.28014]], [[-115.83899, 33.30915], [-115.83907, 33.29477], [-115.82175, 33.29468], [-115.82163, 33.30907], [-115.83899, 33.30915]], [[-115.8043, 33.30899], [-115.80431, 33.30898], [-115.8044, 33.29454], [-115.78725, 33.29442], [-115.78726, 33.30887], [-115.8043, 33.30899]], [[-115.76999, 33.29429], [-115.75252, 33.29292], [-115.75251, 33.30765], [-115.76997, 33.30875], [-115.76999, 33.29429]], [[-115.70106, 33.29275], [-115.68378, 33.29269], [-115.68388, 33.30725], [-115.70116, 33.30733], [-115.70106, 33.29275]], [[-115.68377, 33.29268], [-115.68377, 33.2782], [-115.66663, 33.27821], [-115.66664, 33.29271], [-115.68377, 33.29268]], [[-115.71832, 33.27828], [-115.70108, 33.27824], [-115.70106, 33.29273], [-115.71836, 33.29279], [-115.71832, 33.27828]], [[-115.75249, 33.27838], [-115.73564, 33.27832], [-115.73565, 33.29284], [-115.75082, 33.29293], [-115.75252, 33.29292], [-115.75249, 33.27838]], [[-115.78724, 33.28007], [-115.76997, 33.27998], [-115.76999, 33.29428], [-115.78725, 33.29442], [-115.78724, 33.28007]], [[-115.92741, 33.30975], [-115.9274, 33.30958], [-115.90987, 33.30952], [-115.90996, 33.3239], [-115.92744, 33.32395], [-115.92741, 33.30975]], [[-115.72667, 33.11861], [-115.72666, 33.1186], [-115.71806, 33.11861], [-115.71804, 33.12581], [-115.72666, 33.12581], [-115.72667, 33.11861]], [[-115.71811, 33.11137], [-115.7181, 33.11136], [-115.70947, 33.11137], [-115.70945, 33.1186], [-115.71806, 33.11861], [-115.71811, 33.11137]], [[-115.74387, 33.11853], [-115.74399, 33.10404], [-115.73532, 33.10411], [-115.73528, 33.11858], [-115.74387, 33.11853]]]]} | Open Access 1 | 12944 | Salton Sea - Irrigation District | 4595 | 2048 | Imperial Irrigation District 379 | Special District 4 | Irrigation District 17 | http://www.iid.com/ | Special District 4 | 2048 | Imperial Irrigation District 374 | Special District 4 | Irrigation District 16 | Imperial 20 | 69004.419 | Salton Sea - Irrigation District | 0 | Local Other or Unknown 14 | 4 | |
1708 | 1708 | 1707 | {"type": "Polygon", "coordinates": [[[-117.93744, 33.98131], [-117.93677, 33.98161], [-117.93629, 33.98086], [-117.93696, 33.98056], [-117.93744, 33.98131]]]} | No Public Access 3 | 6551 | Roland Area County Water District Land | 24569 | 2054 | Kinneloa Irrigation District 320 | Special District 4 | Irrigation District 17 | http://www.kinneloairrigationdistrict.info/ | Special District 4 | 2054 | Kinneloa Irrigation District 317 | Special District 4 | Irrigation District 16 | Los Angeles 6 | 1.632 | Roland Area County Water District Land | None 136 | |||
1759 | 1759 | 1758 | {"type": "Polygon", "coordinates": [[[-117.93234, 33.9866], [-117.93168, 33.98689], [-117.93158, 33.98688], [-117.93166, 33.98615], [-117.93219, 33.9861], [-117.93223, 33.98635], [-117.93234, 33.9866]]]} | No Public Access 3 | 6552 | Roland Area County Water District Land | 24569 | 2054 | Kinneloa Irrigation District 320 | Special District 4 | Irrigation District 17 | http://www.kinneloairrigationdistrict.info/ | Special District 4 | 2054 | Kinneloa Irrigation District 317 | Special District 4 | Irrigation District 16 | Los Angeles 6 | 1.052 | Roland Area County Water District Land | None 137 | |||
1760 | 1760 | 1759 | {"type": "Polygon", "coordinates": [[[-117.91753, 33.96603], [-117.91639, 33.96877], [-117.91516, 33.96861], [-117.91523, 33.96842], [-117.91541, 33.96808], [-117.91555, 33.96763], [-117.91605, 33.96696], [-117.91648, 33.9667], [-117.91691, 33.96636], [-117.91753, 33.96603]]]} | No Public Access 3 | 6553 | Roland Area County Water District Land | 24569 | 2054 | Kinneloa Irrigation District 320 | Special District 4 | Irrigation District 17 | http://www.kinneloairrigationdistrict.info/ | Special District 4 | 2054 | Kinneloa Irrigation District 317 | Special District 4 | Irrigation District 16 | Los Angeles 6 | 6.905 | Roland Area County Water District Land | None 138 | |||
1761 | 1761 | 1760 | {"type": "Polygon", "coordinates": [[[-117.92305, 33.97679], [-117.92297, 33.97736], [-117.92178, 33.97689], [-117.92181, 33.97667], [-117.92244, 33.97672], [-117.92249, 33.97669], [-117.92258, 33.97673], [-117.92265, 33.97671], [-117.92276, 33.97676], [-117.92305, 33.97679]]]} | No Public Access 3 | 6554 | Roland Area County Water District Land | 24569 | 2054 | Kinneloa Irrigation District 320 | Special District 4 | Irrigation District 17 | http://www.kinneloairrigationdistrict.info/ | Special District 4 | 2054 | Kinneloa Irrigation District 317 | Special District 4 | Irrigation District 16 | Los Angeles 6 | 1.271 | Roland Area County Water District Land | None 139 | |||
1762 | 1762 | 1761 | {"type": "Polygon", "coordinates": [[[-117.90135, 33.9591], [-117.90114, 33.95933], [-117.90097, 33.95918], [-117.90029, 33.95921], [-117.90038, 33.95914], [-117.90053, 33.95907], [-117.89969, 33.95857], [-117.89885, 33.95773], [-117.89826, 33.95783], [-117.89766, 33.95753], [-117.89771, 33.95684], [-117.89761, 33.9564], [-117.89643, 33.95562], [-117.89634, 33.95554], [-117.89624, 33.95542], [-117.89618, 33.95531], [-117.89616, 33.9552], [-117.89626, 33.95518], [-117.89661, 33.95555], [-117.89745, 33.95579], [-117.89819, 33.95616], [-117.89868, 33.95697], [-117.89953, 33.95806], [-117.90094, 33.959], [-117.90126, 33.95894], [-117.90135, 33.9591]]]} | No Public Access 3 | 6555 | Roland Area County Water District Land | 24569 | 2054 | Kinneloa Irrigation District 320 | Special District 4 | Irrigation District 17 | http://www.kinneloairrigationdistrict.info/ | Special District 4 | 2054 | Kinneloa Irrigation District 317 | Special District 4 | Irrigation District 16 | Los Angeles 6 | 7.601 | Roland Area County Water District Land | None 140 | |||
2565 | 2565 | 2564 | {"type": "Polygon", "coordinates": [[[-117.90918, 33.95983], [-117.90918, 33.95986], [-117.90916, 33.95988], [-117.90863, 33.95999], [-117.90848, 33.95973], [-117.90893, 33.95954], [-117.90906, 33.95966], [-117.90914, 33.95975], [-117.90918, 33.95983]]]} | No Public Access 3 | 6556 | Roland Area County Water District Land | 24569 | 2054 | Kinneloa Irrigation District 320 | Special District 4 | Irrigation District 17 | http://www.kinneloairrigationdistrict.info/ | Special District 4 | 2054 | Kinneloa Irrigation District 317 | Special District 4 | Irrigation District 16 | Los Angeles 6 | 0.487 | Roland Area County Water District Land | None 210 | |||
2593 | 2593 | 2592 | {"type": "Polygon", "coordinates": [[[-117.89197, 33.96438], [-117.89183, 33.96505], [-117.89141, 33.96512], [-117.8911, 33.96526], [-117.89075, 33.96497], [-117.89062, 33.96475], [-117.89062, 33.96444], [-117.89119, 33.96426], [-117.89197, 33.96438]]]} | No Public Access 3 | 6557 | Roland Area County Water District Land | 24569 | 2054 | Kinneloa Irrigation District 320 | Special District 4 | Irrigation District 17 | http://www.kinneloairrigationdistrict.info/ | Special District 4 | 2054 | Kinneloa Irrigation District 317 | Special District 4 | Irrigation District 16 | Los Angeles 6 | 2.479 | Roland Area County Water District Land | None 214 | |||
3551 | 3551 | 3550 | {"type": "Polygon", "coordinates": [[[-117.98918, 34.51959], [-117.98917, 34.52033], [-117.98818, 34.52034], [-117.98817, 34.51959], [-117.98918, 34.51959]]]} | No Public Access 3 | 12453 | Littlerock Creek Irrigation District Open Space | 21360 | 2061 | Littlerock Creek Irrigation District 659 | Special District 4 | Irrigation District 17 | http://www.lrcid.com/ | Special District 4 | 2061 | Littlerock Creek Irrigation District 646 | Special District 4 | Irrigation District 16 | Los Angeles 6 | 1.865 | Littlerock Creek Irrigation District OS | 0 | Local Recreation Area 3 | 4 | |
3801 | 3801 | 3800 | {"type": "Polygon", "coordinates": [[[-119.00087, 36.48581], [-119.00073, 36.50019], [-118.9888, 36.50036], [-118.98849, 36.5075], [-118.98438, 36.50756], [-118.98422, 36.51497], [-118.95056, 36.51478], [-118.95017, 36.48653], [-118.95887, 36.48654], [-118.95883, 36.48389], [-118.95011, 36.48385], [-118.95008, 36.48653], [-118.94129, 36.48652], [-118.94106, 36.47196], [-118.95863, 36.47197], [-118.95841, 36.45769], [-118.96306, 36.45867], [-118.96313, 36.46251], [-118.97128, 36.46422], [-118.97135, 36.47198], [-118.9759, 36.47199], [-118.97604, 36.48655], [-118.98065, 36.48656], [-118.98063, 36.48423], [-118.98403, 36.48421], [-118.99295, 36.4837], [-118.99301, 36.48616], [-119.00087, 36.48581]]]} | No Public Access 3 | 35098 | Mitigation Preserve | 22327 | 2302 | Kaweah Delta Water Conservation District 685 | Special District 4 | Irrigation District 17 | http://www.kdwcd.com/ | Special District 4 | 2302 | Kaweah Delta Water Conservation District 676 | Special District 4 | Irrigation District 16 | Tulare 29 | 4599.64 | Mitigation Preserve | 0 | Local Conservation Area 4 | 2 | |
4243 | 4243 | 4242 | {"type": "Polygon", "coordinates": [[[-117.1979, 33.04077], [-117.19691, 33.04146], [-117.19687, 33.04157], [-117.1967, 33.04154], [-117.19651, 33.04157], [-117.1957, 33.04195], [-117.19532, 33.04206], [-117.19501, 33.04209], [-117.19426, 33.04208], [-117.19394, 33.0421], [-117.19364, 33.04218], [-117.19207, 33.04311], [-117.19167, 33.0434], [-117.19148, 33.04349], [-117.19123, 33.04353], [-117.18912, 33.04351], [-117.18921, 33.04308], [-117.18939, 33.04261], [-117.18944, 33.04243], [-117.18945, 33.04226], [-117.1894, 33.0419], [-117.18942, 33.04177], [-117.18946, 33.04165], [-117.1895, 33.04157], [-117.19034, 33.04037], [-117.19045, 33.04017], [-117.19048, 33.04001], [-117.19048, 33.0398], [-117.19043, 33.03942], [-117.19038, 33.03925], [-117.19029, 33.03911], [-117.19018, 33.039], [-117.19005, 33.03891], [-117.18986, 33.0388], [-117.18981, 33.03875], [-117.18978, 33.0387], [-117.18977, 33.03864], [-117.18979, 33.03853], [-117.18991, 33.03839], [-117.19003, 33.03828], [-117.19028, 33.0381], [-117.19187, 33.03732], [-117.1922, 33.03718], [-117.19291, 33.0369], [-117.19326, 33.0367], [-117.19356, 33.03648], [-117.19382, 33.0362], [-117.19396, 33.036], [-117.19401, 33.03592], [-117.19403, 33.03581], [-117.19403, 33.03562], [-117.19395, 33.03525], [-117.19394, 33.03517], [-117.19396, 33.03508], [-117.19399, 33.03501], [-117.19404, 33.03495], [-117.1941, 33.03491], [-117.19417, 33.03491], [-117.19421, 33.03495], [-117.19432, 33.03563], [-117.19438, 33.03587], [-117.19445, 33.03604], [-117.19458, 33.0362], [-117.19475, 33.03633], [-117.19521, 33.03655], [-117.19544, 33.0367], [-117.19561, 33.03687], [-117.19579, 33.03712], [-117.19594, 33.0373], [-117.19613, 33.03745], [-117.19651, 33.03765], [-117.19669, 33.03769], [-117.19684, 33.03771], [-117.19678, 33.03841], [-117.19692, 33.03855], [-117.19732, 33.03888], [-117.19715, 33.04072], [-117.1979, 33.04077]]]} | Unknown Access 4 | 45146 | San Dieguito Reservoir Watershed | 24868 | 2322 | Santa Fe Irrigation District 738 | Special District 4 | Irrigation District 17 | http://www.sfidwater.org/ | Special District 4 | 2322 | Santa Fe Irrigation District 722 | Special District 4 | Irrigation District 16 | San Diego 4 | 102.408 | San Dieguito Reservoir Watershed | 0 | Local Resource Management Area 83 | 3 | |
5568 | 5568 | 5567 | {"type": "Polygon", "coordinates": [[[-117.98819, 34.51876], [-117.98807, 34.51874], [-117.98806, 34.51756], [-117.98818, 34.51757], [-117.98819, 34.51876]]]} | No Public Access 3 | 12452 | Littlerock Creek Irrigation District Open Space | 21360 | 2061 | Littlerock Creek Irrigation District 659 | Special District 4 | Irrigation District 17 | http://www.lrcid.com/ | Special District 4 | 2061 | Littlerock Creek Irrigation District 646 | Special District 4 | Irrigation District 16 | Los Angeles 6 | 0.356 | Littlerock Creek Irrigation District OS | 0 | Local Recreation Area 3 | 4 | |
7357 | 7357 | 7356 | {"type": "MultiPolygon", "coordinates": [[[[-118.02763, 34.50795], [-118.02763, 34.50822], [-118.02325, 34.50828], [-118.02326, 34.508], [-118.02763, 34.50795]]], [[[-118.02654, 34.50915], [-118.02654, 34.50999], [-118.02544, 34.51001], [-118.02544, 34.51093], [-118.02324, 34.51097], [-118.02324, 34.51373], [-118.00514, 34.51378], [-118.00508, 34.51374], [-118.00416, 34.51343], [-118.00236, 34.51343], [-118.00235, 34.51063], [-118.00105, 34.51062], [-118.00105, 34.51057], [-118.00564, 34.51018], [-118.00565, 34.51015], [-118.01886, 34.51011], [-118.02324, 34.51004], [-118.02325, 34.50919], [-118.02654, 34.50915]], [[-118.00565, 34.51222], [-118.00566, 34.51221], [-118.00566, 34.51197], [-118.00481, 34.51198], [-118.00482, 34.51199], [-118.00511, 34.51206], [-118.00565, 34.51222]]], [[[-118.00572, 34.52102], [-118.0025, 34.52103], [-118.0025, 34.51922], [-118.00233, 34.51921], [-118.00232, 34.51436], [-118.00261, 34.51433], [-118.00446, 34.51493], [-118.00467, 34.51559], [-118.00568, 34.516], [-118.00572, 34.52102]]], [[[-117.9969, 34.52998], [-117.9969, 34.52998], [-117.9963, 34.531], [-117.9963, 34.5301], [-117.99657, 34.53009], [-117.99657, 34.52938], [-117.9969, 34.52938], [-117.9969, 34.52998]]], [[[-117.98816, 34.54299], [-117.98815, 34.54466], [-117.98593, 34.54468], [-117.98697, 34.54299], [-117.98816, 34.54299]]], [[[-117.97925, 34.55142], [-117.97924, 34.55397], [-117.9775, 34.55397], [-117.97784, 34.55335], [-117.97825, 34.55334], [-117.97826, 34.55196], [-117.97892, 34.55197], [-117.97893, 34.55142], [-117.97925, 34.55142]]], [[[-117.97703, 34.55398], [-117.97702, 34.55468], [-117.97674, 34.55468], [-117.97674, 34.55398], [-117.97703, 34.55398]]], [[[-117.97762, 34.55779], [-117.9766, 34.55961], [-117.97615, 34.55961], [-117.97612, 34.55779], [-117.97762, 34.55779]]], [[[-117.98274, 34.56873], [-117.98274, 34.57055], [-117.98057, 34.57055], [-117.98056, 34.56872], [-117.98274, 34.56873]]], [[[-117.9937, 34.58516], [-117.99369, 34.58699], [-117.99143, 34.58701], [-117.99144, 34.58518], [-117.9937, 34.58516]]]]} | No Public Access 3 | 6714 | Little Rock Wash | 21356 | 2061 | Littlerock Creek Irrigation District 659 | Special District 4 | Irrigation District 17 | http://www.lrcid.com/ | Special District 4 | 2061 | Littlerock Creek Irrigation District 646 | Special District 4 | Irrigation District 16 | Los Angeles 6 | 293.656 | Little Rock Wash | 0 | None 609 | ||
7806 | 7806 | 7805 | {"type": "Polygon", "coordinates": [[[-118.08938, 34.16909], [-118.08897, 34.16934], [-118.08889, 34.16941], [-118.08876, 34.16917], [-118.08927, 34.16897], [-118.08938, 34.16909]]]} | No Public Access 3 | 12343 | Kinneloa Irrigation District Open Space | 20674 | 2054 | Kinneloa Irrigation District 320 | Special District 4 | Irrigation District 17 | http://www.kinneloairrigationdistrict.info/ | Special District 4 | 2054 | Kinneloa Irrigation District 317 | Special District 4 | Irrigation District 16 | Los Angeles 6 | 0.297 | Kinneloa Irrigation District OS | 0 | Local Recreation Area 3 | 4 | |
7827 | 7827 | 7826 | {"type": "Polygon", "coordinates": [[[-117.97928, 34.51891], [-117.97908, 34.51905], [-117.97879, 34.51923], [-117.97862, 34.51929], [-117.97826, 34.51953], [-117.97804, 34.51962], [-117.97781, 34.51968], [-117.97733, 34.51992], [-117.97708, 34.51998], [-117.97707, 34.51981], [-117.97662, 34.5198], [-117.97662, 34.52021], [-117.97538, 34.5207], [-117.97538, 34.52106], [-117.97504, 34.52106], [-117.97505, 34.52051], [-117.97508, 34.5205], [-117.97507, 34.52017], [-117.97516, 34.51847], [-117.97592, 34.5181], [-117.97708, 34.51764], [-117.97708, 34.51974], [-117.97726, 34.51971], [-117.97739, 34.51962], [-117.9777, 34.51949], [-117.97794, 34.51942], [-117.9781, 34.51934], [-117.97834, 34.51917], [-117.97866, 34.51903], [-117.97892, 34.51888], [-117.97927, 34.5186], [-117.97928, 34.51891]]]} | No Public Access 3 | 12441 | Littlerock Creek Irrigation District Open Space | 21360 | 2061 | Littlerock Creek Irrigation District 659 | Special District 4 | Irrigation District 17 | http://www.lrcid.com/ | Special District 4 | 2061 | Littlerock Creek Irrigation District 646 | Special District 4 | Irrigation District 16 | Los Angeles 6 | 13.15 | Littlerock Creek Irrigation District OS | 0 | Local Recreation Area 3 | 4 | |
8010 | 8010 | 8009 | {"type": "MultiPolygon", "coordinates": [[[[-116.02639, 33.51813], [-116.02637, 33.5256], [-116.00908, 33.52564], [-116.00908, 33.51812], [-116.02639, 33.51813]]], [[[-115.9917, 33.52561], [-115.97426, 33.52554], [-115.97415, 33.51817], [-115.99159, 33.51815], [-115.9917, 33.52561]]], [[[-116.08721, 33.51054], [-116.08721, 33.51421], [-116.08313, 33.51422], [-116.08312, 33.5179], [-116.07905, 33.51792], [-116.07904, 33.51054], [-116.06996, 33.51054], [-116.06116, 33.51058], [-116.06111, 33.50026], [-116.06106, 33.49907], [-116.04367, 33.4991], [-116.04385, 33.4845], [-116.02647, 33.48448], [-116.02633, 33.49919], [-116.00918, 33.49928], [-116.00907, 33.48449], [-115.99116, 33.48451], [-115.99116, 33.49919], [-115.9738, 33.49918], [-115.97404, 33.5108], [-115.95654, 33.51085], [-115.95674, 33.52541], [-115.94386, 33.52537], [-115.9438, 33.52174], [-115.9395, 33.52173], [-115.93932, 33.51085], [-115.95652, 33.51085], [-115.95651, 33.50987], [-115.9563, 33.5002], [-115.95643, 33.49917], [-115.93907, 33.49918], [-115.93919, 33.4846], [-115.94781, 33.48458], [-115.94784, 33.48133], [-115.95216, 33.48126], [-115.95214, 33.48458], [-115.95644, 33.48457], [-115.95644, 33.49916], [-115.97378, 33.49918], [-115.97379, 33.49917], [-115.97371, 33.48456], [-115.95645, 33.48456], [-115.95658, 33.47012], [-115.93925, 33.47013], [-115.93931, 33.45556], [-115.9393, 33.45555], [-115.92196, 33.45559], [-115.92197, 33.44092], [-115.90467, 33.44096], [-115.90465, 33.45563], [-115.88728, 33.45568], [-115.88727, 33.441], [-115.87582, 33.44116], [-115.86951, 33.44116], [-115.86945, 33.42685], [-115.87438, 33.42687], [-115.88723, 33.42686], [-115.88728, 33.44099], [-115.90466, 33.44096], [-115.9047, 33.42684], [-115.9221, 33.4268], [-115.92198, 33.44092], [-115.93937, 33.44093], [-115.9393, 33.45555], [-115.95671, 33.45554], [-115.95674, 33.45552], [-115.95683, 33.44096], [-115.93939, 33.44093], [-115.93946, 33.42674], [-115.95693, 33.42668], [-115.95683, 33.44096], [-115.97422, 33.44094], [-115.97424, 33.44093], [-115.97442, 33.42663], [-115.98341, 33.4266], [-115.99201, 33.42654], [-115.9918, 33.44093], [-116.00081, 33.44091], [-116.00913, 33.44086], [-116.00921, 33.42648], [-116.0265, 33.42635], [-116.02646, 33.44084], [-116.04392, 33.44081], [-116.04391, 33.45541], [-116.05245, 33.45538], [-116.05247, 33.46264], [-116.06106, 33.4626], [-116.06111, 33.46984], [-116.07886, 33.46979], [-116.07885, 33.48439], [-116.08713, 33.48429], [-116.08717, 33.49528], [-116.08304, 33.4953], [-116.08305, 33.49895], [-116.07892, 33.49896], [-116.079, 33.50032], [-116.07905, 33.51053], [-116.08721, 33.51054]], [[-115.99114, 33.48451], [-115.99135, 33.4701], [-115.97388, 33.47012], [-115.97372, 33.48455], [-115.99114, 33.48451]], [[-115.97388, 33.47012], [-115.9741, 33.45549], [-115.95674, 33.45553], [-115.95672, 33.45555], [-115.95658, 33.47012], [-115.97388, 33.47012]], [[-116.0091, 33.47005], [-116.00912, 33.45545], [-115.99162, 33.45548], [-115.99136, 33.4701], [-116.00084, 33.47011], [-116.0091, 33.47005]], [[-116.04381, 33.46994], [-116.04391, 33.45541], [-116.02647, 33.45544], [-116.02647, 33.47003], [-116.04381, 33.46994]], [[-116.06115, 33.48444], [-116.06111, 33.46984], [-116.04382, 33.46994], [-116.04386, 33.4845], [-116.06115, 33.48444]], [[-116.07885, 33.48441], [-116.06116, 33.48445], [-116.06107, 33.49906], [-116.07892, 33.49895], [-116.07885, 33.48441]], [[-116.02646, 33.48448], [-116.02646, 33.47004], [-116.00911, 33.47006], [-116.00908, 33.48449], [-116.02646, 33.48448]], [[-115.9918, 33.44093], [-115.97424, 33.44095], [-115.97411, 33.45548], [-115.99161, 33.45547], [-115.99181, 33.44094], [-115.9918, 33.44093]], [[-116.02646, 33.44086], [-116.02645, 33.44085], [-116.00914, 33.44087], [-116.00912, 33.45545], [-116.02646, 33.45544], [-116.02646, 33.44086]]], [[[-116.04379, 33.52553], [-116.04379, 33.52917], [-116.03943, 33.52918], [-116.03943, 33.52555], [-116.04379, 33.52553]]], [[[-116.07904, 33.5253], [-116.07902, 33.52898], [-116.07016, 33.52902], [-116.07016, 33.5327], [-116.06574, 33.53272], [-116.06571, 33.52536], [-116.07904, 33.5253]]]]} | Open Access 1 | 12966 | Salton Sea - Irrigation District | 4595 | 2048 | Imperial Irrigation District 379 | Special District 4 | Irrigation District 17 | http://www.iid.com/ | Special District 4 | 2048 | Imperial Irrigation District 374 | Special District 4 | Irrigation District 16 | Riverside 10 | 16954.91 | Salton Sea - Irrigation District | 0 | Local Other or Unknown 14 | 4 | |
8151 | 8151 | 8150 | {"type": "Polygon", "coordinates": [[[-118.08762, 34.17103], [-118.08718, 34.17144], [-118.08687, 34.17134], [-118.08698, 34.1711], [-118.08685, 34.17111], [-118.08712, 34.17061], [-118.08762, 34.17103]]]} | No Public Access 3 | 12341 | Kinneloa Irrigation District Open Space | 20674 | 2054 | Kinneloa Irrigation District 320 | Special District 4 | Irrigation District 17 | http://www.kinneloairrigationdistrict.info/ | Special District 4 | 2054 | Kinneloa Irrigation District 317 | Special District 4 | Irrigation District 16 | Los Angeles 6 | 0.868 | Kinneloa Irrigation District OS | 0 | Local Recreation Area 3 | 4 | |
8152 | 8152 | 8151 | {"type": "Polygon", "coordinates": [[[-118.08668, 34.18493], [-118.08668, 34.18564], [-118.08613, 34.18563], [-118.08613, 34.18492], [-118.08668, 34.18493]]]} | No Public Access 3 | 12342 | Kinneloa Irrigation District Open Space | 20674 | 2054 | Kinneloa Irrigation District 320 | Special District 4 | Irrigation District 17 | http://www.kinneloairrigationdistrict.info/ | Special District 4 | 2054 | Kinneloa Irrigation District 317 | Special District 4 | Irrigation District 16 | Los Angeles 6 | 0.996 | Kinneloa Irrigation 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]);