units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
969 rows where ACCESS_TYP = 3 sorted by DES_TP
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- California Department of Fish and Wildlife 79
- East Bay Regional Park District 46
- The Nature Conservancy 32
- Los Angeles, City of 29
- Las Virgenes Municipal Water District 28
- Peninsula Open Space Trust 24
- Natomas Basin Conservancy 22
- Rivers and Lands Conservancy 22
- The Environmental Trust 21
- Torrance, City of 20
- Mountains Restoration Trust 20
- Midpeninsula Regional Open Space District 19
- San Diego, City of 18
- Santa Clara Valley Open Space Authority 18
- United States Fish and Wildlife Service 16
- Fresno Metropolitan Flood Control District 16
- California Department of Parks and Recreation 15
- Endangered Habitats Conservancy 14
- San Diego, County of 14
- Los Angeles County Flood Control District 13
- Kinneloa Irrigation District 13
- American River Conservancy 13
- Save Mount Diablo 13
- Littlerock Creek Irrigation District 13
- Napa, City of 12
- Sonoma Land Trust 11
- Sonoma County Agricultural Preservation and Open Space District 11
- Santa Clara County Parks and Recreation Dept., County of 11
- California Department of Water Resources 11
- California Department of General Services 10
- …
DES_TP >30
- Private Conservation 211
- Local Recreation Area 113
- Local Other or Unknown 96
- Local Conservation Area 77
- State Resource Management Area 64
- Local Park 59
- Private Recreation or Education 25
- Private Other or Unknown 25
- State Conservation Area 22
- State Other or Unknown 19
- National Wildlife Refuge 14
- Local Resource Management Area 8
- State Park 5
- Private Agricultural 5
- Resource Management Area 4
- Conservation Area 3
- Federal Other or Unknown 3
- State Historic or Cultural Area 3
- National Monument or Landmark 2
- None 1
- None 1
- State Recreation Area 1
- Recreation Management Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
MNG_AG_TYP 20
- Non Profit - Land Trust 217
- City Agency 194
- State Agency 137
- Recreation/Parks District 105
- Flood District 58
- Water District 56
- Non Profit - Conservation 50
- Federal Agency 31
- Irrigation District 29
- County Agency 26
- Open Space District 22
- County Agency - Parks 14
- County Agency - Other 3
- Home Owners Association 1
- Commercial 1
- Sanitation District 1
- Non Profit - Other 1
- Joint Powers Authority 1
- Other 1
- Mitigation Bank 1
ACCESS_TYP 1
- No Public Access · 949 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5495 | 5495 | 5494 | {"type": "Polygon", "coordinates": [[[-118.38093, 34.1267], [-118.38083, 34.12681], [-118.38083, 34.12701], [-118.38061, 34.12707], [-118.38043, 34.12717], [-118.38031, 34.12721], [-118.3802, 34.12721], [-118.38011, 34.12718], [-118.38003, 34.12714], [-118.37992, 34.12701], [-118.3798, 34.12694], [-118.37975, 34.12694], [-118.37974, 34.12695], [-118.37963, 34.12692], [-118.37943, 34.1269], [-118.37939, 34.12686], [-118.37941, 34.12663], [-118.38093, 34.1267]]]} | No Public Access 3 | 12819 | Los Angeles City Water Resource Parkland | 21477 | 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 | 1.441 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
5496 | 5496 | 5495 | {"type": "Polygon", "coordinates": [[[-118.39301, 34.11863], [-118.39283, 34.11899], [-118.39267, 34.11881], [-118.39276, 34.11874], [-118.39271, 34.11868], [-118.3926, 34.11875], [-118.39249, 34.11863], [-118.39234, 34.11881], [-118.39226, 34.11887], [-118.39219, 34.11889], [-118.39201, 34.11889], [-118.39183, 34.11881], [-118.39175, 34.11874], [-118.39223, 34.11873], [-118.39222, 34.11808], [-118.39228, 34.11821], [-118.39284, 34.11848], [-118.39299, 34.11857], [-118.39297, 34.1186], [-118.39301, 34.11863]]]} | No Public Access 3 | 12820 | Los Angeles City Water Resource Parkland | 21477 | 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.964 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
5497 | 5497 | 5496 | {"type": "Polygon", "coordinates": [[[-118.39276, 34.11874], [-118.39267, 34.11881], [-118.3926, 34.11875], [-118.39271, 34.11867], [-118.39276, 34.11874]]]} | No Public Access 3 | 12821 | Los Angeles City Water Resource Parkland | 21477 | 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.028 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
5607 | 5607 | 5606 | {"type": "Polygon", "coordinates": [[[-121.99805, 37.90236], [-121.99346, 37.90195], [-121.99291, 37.90125], [-121.99278, 37.90102], [-121.9927, 37.90078], [-121.9926, 37.9006], [-121.99246, 37.90043], [-121.99237, 37.90036], [-121.99218, 37.90024], [-121.99085, 37.89958], [-121.99095, 37.89942], [-121.99097, 37.89941], [-121.99251, 37.89731], [-121.99359, 37.8979], [-121.99572, 37.89966], [-121.99752, 37.89939], [-121.99805, 37.90236]]]} | No Public Access 3 | 46993 | Diablo Foothills Regional Park | 30631 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 46.446 | Diablo Foothills RP | 0 | Local Park 2 | 4 | |
5769 | 5769 | 5768 | {"type": "MultiPolygon", "coordinates": [[[[-121.68672, 36.99803], [-121.68674, 36.99859], [-121.68661, 36.99896], [-121.68643, 36.99936], [-121.6863, 36.9998], [-121.68549, 37.00119], [-121.6854, 37.0018], [-121.68518, 37.00212], [-121.68487, 37.00246], [-121.68471, 37.00262], [-121.68441, 37.00278], [-121.68384, 37.00298], [-121.68341, 37.00311], [-121.68281, 37.00343], [-121.68237, 37.0037], [-121.68199, 37.00385], [-121.68126, 37.00395], [-121.68062, 37.00388], [-121.68004, 37.0037], [-121.67943, 37.00359], [-121.67871, 37.00351], [-121.67689, 37.0034], [-121.67629, 37.00332], [-121.67587, 37.0032], [-121.67521, 37.00309], [-121.67512, 37.00291], [-121.6747, 37.00217], [-121.67447, 37.00187], [-121.67356, 37.00185], [-121.67306, 37.00116], [-121.67214, 37.00075], [-121.67159, 37.00067], [-121.67134, 37.00042], [-121.67088, 36.99909], [-121.66987, 36.99904], [-121.66916, 36.99843], [-121.66876, 36.99825], [-121.66483, 36.99911], [-121.66455, 36.98429], [-121.66813, 36.98641], [-121.68672, 36.99803]]], [[[-121.71358, 37.02718], [-121.70911, 37.02723], [-121.70928, 37.03286], [-121.70996, 37.03332], [-121.70988, 37.03335], [-121.70972, 37.03333], [-121.7096, 37.03334], [-121.70945, 37.03341], [-121.7089, 37.03404], [-121.70885, 37.03408], [-121.70828, 37.03421], [-121.70784, 37.03422], [-121.7076, 37.03425], [-121.70647, 37.0346], [-121.70632, 37.03463], [-121.70616, 37.03463], [-121.70601, 37.0346], [-121.70587, 37.03455], [-121.70573, 37.03446], [-121.70561, 37.03436], [-121.70548, 37.03418], [-121.70533, 37.03394], [-121.70527, 37.03382], [-121.70514, 37.03352], [-121.70509, 37.03342], [-121.70486, 37.03318], [-121.70472, 37.0331], [-121.70461, 37.03307], [-121.70408, 37.03302], [-121.70399, 37.033], [-121.70389, 37.03293], [-121.70373, 37.03277], [-121.70364, 37.03271], [-121.70354, 37.03269], [-121.70248, 37.03265], [-121.70224, 37.03263], [-121.70178, 37.03256], [-121.70108, 37.03239], [-121.70101, 37.03235], [-121.70095, 37.03226], [-121.70088, 37.03219], [-121.70078, 37.03213], [-121.70066, 37.03209], [-121.70054, 37.03207], [-121.70041, 37.03207], [-121.70013, 37.03214], [-121.69996, 37.03214], [-121.69963, 37.032], [-121.69954, 37.03197], [-121.69934, 37.03195], [-121.69917, 37.0319], [-121.69891, 37.03176], [-121.69879, 37.03172], [-121.69867, 37.03171], [-121.69854, 37.03173], [-121.69828, 37.03181], [-121.69804, 37.03193], [-121.69794, 37.03195], [-121.69785, 37.03194], [-121.69776, 37.03191], [-121.69726, 37.03162], [-121.69676, 37.0314], [-121.69677, 37.03137], [-121.69548, 37.03058], [-121.69537, 37.03053], [-121.69525, 37.0305], [-121.69506, 37.0305], [-121.69486, 37.03055], [-121.69477, 37.03055], [-121.69249, 37.03023], [-121.69194, 37.03018], [-121.6914, 37.03015], [-121.69085, 37.03013], [-121.69018, 37.03013], [-121.68919, 37.03024], [-121.68892, 37.03028], [-121.68849, 37.0304], [-121.68825, 37.03044], [-121.68792, 37.03049], [-121.68742, 37.03052], [-121.6871, 37.03063], [-121.68688, 37.03074], [-121.6865, 37.03101], [-121.68561, 37.0317], [-121.68385, 37.0269], [-121.68064, 37.02881], [-121.67665, 37.02709], [-121.67403, 37.02297], [-121.675, 37.02246], [-121.67552, 37.02128], [-121.67558, 37.02068], [-121.676, 37.02025], [-121.67636, 37.02005], [-121.67689, 37.01985], [-121.67803, 37.01968], [-121.67837, 37.01899], [-121.67873, 37.01863], [-121.6793, 37.0179], [-121.67931, 37.01745], [-121.67946, 37.01733], [-121.67982, 37.01735], [-121.68038, 37.01748], [-121.68096, 37.01751], [-121.68219, 37.01829], [-121.68285, 37.01856], [-121.68319, 37.01853], [-121.6839, 37.01867], [-121.68431, 37.01873], [-121.68521, 37.01909], [-121.68796, 37.02053], [-121.68866, 37.02026], [-121.6934, 37.02305], [-121.71353, 37.01979], [-121.71358, 37.02718]]], [[[-121.73523, 37.0163], [-121.73072, 37.02292], [-121.73026, 37.02356], [-121.73013, 37.02352], [-121.7306, 37.02279], [-121.7309, 37.02184], [-121.72859, 37.02092], [-121.72772, 37.0209], [-121.72688, 37.02196], [-121.72662, 37.02169], [-121.72638, 37.02141], [-121.72622, 37.02119], [-121.72608, 37.02095], [-121.7259, 37.02055], [-121.7258, 37.02026], [-121.72555, 37.01921], [-121.72542, 37.01876], [-121.72521, 37.01839], [-121.72494, 37.01805], [-121.72474, 37.01786], [-121.72452, 37.01769], [-121.72427, 37.01753], [-121.72389, 37.01735], [-121.72363, 37.01727], [-121.72336, 37.01721], [-121.72223, 37.01703], [-121.72176, 37.01693], [-121.72133, 37.01679], [-121.72106, 37.01668], [-121.72081, 37.01655], [-121.72057, 37.01639], [-121.72035, 37.01621], [-121.72016, 37.01602], [-121.71912, 37.01475], [-121.71821, 37.01369], [-121.71826, 37.01358], [-121.71827, 37.01345], [-121.7181, 37.01308], [-121.718, 37.0129], [-121.71786, 37.01273], [-121.7177, 37.01258], [-121.71729, 37.01231], [-121.71724, 37.01223], [-121.71724, 37.01215], [-121.71729, 37.01206], [-121.71738, 37.01197], [-121.71748, 37.0119], [-121.71761, 37.01185], [-121.71822, 37.01174], [-121.719, 37.01167], [-121.71923, 37.01163], [-121.71945, 37.01157], [-121.71966, 37.01147], [-121.71985, 37.01136], [-121.72023, 37.01107], [-121.72042, 37.01084], [-121.72065, 37.01038], [-121.72073, 37.01028], [-121.72089, 37.01015], [-121.72116, 37.01002], [-121.72128, 37.00993], [-121.72139, 37.00983], [-121.72147, 37.00971], [-121.72152, 37.00958], [-121.72154, 37.00945], [-121.72155, 37.00931], [-121.72152, 37.00917], [-121.72147, 37.00901], [-121.72119, 37.00864], [-121.7217, 37.00769], [-121.72196, 37.00744], [-121.72557, 37.01114], [-121.72673, 37.01494], [-121.73044, 37.01336], [-121.73523, 37.0163]]]]} | No Public Access 3 | 37026 | Mount Madonna County Park | 29288 | 326 | Santa Clara County Parks and Recreation Dept., County of 472 | County 3 | County Agency - Parks 7 | http://www.sccgov.org/sites/parks/Pages/Welcome-to-Santa-Clara-County-Parks.aspx | County 3 | 326 | Santa Clara County Parks and Recreation Dept., County of 465 | County 3 | County Agency - Parks 7 | https://www.sccgov.org/sites/parks/parkfinder/Pages/MtMadonna.aspx | Santa Clara 19 | 1720.675 | Mount Madonna County Park | 0 | Local Park 2 | 4 |
6296 | 6296 | 6295 | {"type": "Polygon", "coordinates": [[[-121.88197, 37.73651], [-121.88144, 37.73642], [-121.874, 37.73118], [-121.87389, 37.72956], [-121.8737, 37.72941], [-121.87354, 37.72903], [-121.87339, 37.72886], [-121.87321, 37.72857], [-121.87321, 37.72841], [-121.87326, 37.72834], [-121.87361, 37.72828], [-121.8737, 37.72821], [-121.87367, 37.72806], [-121.87354, 37.72802], [-121.87327, 37.72806], [-121.87305, 37.72785], [-121.87286, 37.72737], [-121.87287, 37.7271], [-121.87293, 37.72697], [-121.87303, 37.72646], [-121.873, 37.72633], [-121.87291, 37.72631], [-121.87278, 37.72635], [-121.87269, 37.72635], [-121.87258, 37.72621], [-121.87244, 37.72581], [-121.87254, 37.72555], [-121.87256, 37.72525], [-121.87253, 37.72514], [-121.87225, 37.72474], [-121.87185, 37.72446], [-121.87183, 37.72431], [-121.87199, 37.72425], [-121.872, 37.72424], [-121.87166, 37.72419], [-121.87168, 37.72391], [-121.87238, 37.72394], [-121.87288, 37.72369], [-121.87438, 37.72709], [-121.87473, 37.73143], [-121.88197, 37.73651]]]} | No Public Access 3 | 1411 | Tassajara Creek Regional Park | 26194 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 24.514 | Tassajara Creek RP | 1971 | Local Park 2 | 4 | |
6608 | 6608 | 6607 | {"type": "Polygon", "coordinates": [[[-117.03964, 32.5565], [-117.03952, 32.55674], [-117.03854, 32.5569], [-117.03824, 32.55697], [-117.03804, 32.55697], [-117.03763, 32.55706], [-117.03762, 32.55704], [-117.03717, 32.55717], [-117.03738, 32.55766], [-117.03743, 32.55783], [-117.03746, 32.55795], [-117.03747, 32.55822], [-117.03369, 32.55819], [-117.03357, 32.55452], [-117.03776, 32.55454], [-117.03928, 32.55638], [-117.03964, 32.5565]]]} | No Public Access 3 | 4168 | Beyer Community Park | 30224 | 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 | 43.828 | Beyer Community Park | 0 | Local Park 2 | 4 | |
6999 | 6999 | 6998 | {"type": "Polygon", "coordinates": [[[-118.35627, 33.76696], [-118.35581, 33.76818], [-118.35516, 33.7689], [-118.35493, 33.76928], [-118.35465, 33.76912], [-118.35469, 33.76907], [-118.35503, 33.76841], [-118.35508, 33.76827], [-118.35509, 33.7682], [-118.3552, 33.76791], [-118.35547, 33.7675], [-118.3558, 33.76678], [-118.35627, 33.76696]]]} | No Public Access 3 | 5938 | Rolling Hills City Parkland | 24574 | 1282 | Rolling Hills, City of 288 | City 2 | City Agency 2 | http://www.rolling-hills.org/ | City 2 | 1282 | Rolling Hills, City of 285 | City 2 | City Agency 2 | Los Angeles 6 | 3.334 | Rolling Hills City Parkland | 0 | Local Park 2 | 4 | |
7000 | 7000 | 6999 | {"type": "Polygon", "coordinates": [[[-118.34321, 33.7627], [-118.34301, 33.76401], [-118.34289, 33.76533], [-118.34181, 33.76568], [-118.34103, 33.766], [-118.34091, 33.76615], [-118.34084, 33.76592], [-118.34013, 33.76572], [-118.33993, 33.76592], [-118.34015, 33.76629], [-118.34015, 33.76661], [-118.33955, 33.76629], [-118.33896, 33.76581], [-118.33863, 33.76543], [-118.33917, 33.76497], [-118.34028, 33.76519], [-118.34115, 33.76476], [-118.34115, 33.76475], [-118.34091, 33.7645], [-118.34081, 33.76415], [-118.34098, 33.76406], [-118.34132, 33.76401], [-118.34177, 33.76412], [-118.34181, 33.76404], [-118.34321, 33.7627]]]} | No Public Access 3 | 5939 | Rolling Hills City Parkland | 24574 | 1282 | Rolling Hills, City of 288 | City 2 | City Agency 2 | http://www.rolling-hills.org/ | City 2 | 1282 | Rolling Hills, City of 285 | City 2 | City Agency 2 | Los Angeles 6 | 15.507 | Rolling Hills City Parkland | 0 | Local Park 2 | 4 | |
7405 | 7405 | 7404 | {"type": "MultiPolygon", "coordinates": [[[[-117.23498, 33.26852], [-117.23496, 33.27233], [-117.23359, 33.27235], [-117.23078, 33.27536], [-117.2318, 33.27604], [-117.23496, 33.27267], [-117.23495, 33.27324], [-117.23464, 33.27384], [-117.23427, 33.27442], [-117.23398, 33.27479], [-117.2335, 33.27532], [-117.23297, 33.2758], [-117.23238, 33.27624], [-117.23175, 33.27664], [-117.23131, 33.27687], [-117.2296, 33.27764], [-117.22894, 33.27798], [-117.22851, 33.27823], [-117.22812, 33.2785], [-117.22775, 33.27877], [-117.2274, 33.27907], [-117.22706, 33.27938], [-117.2263, 33.28031], [-117.22556, 33.28144], [-117.22523, 33.28242], [-117.22503, 33.28174], [-117.22578, 33.27963], [-117.22622, 33.27921], [-117.22623, 33.2761], [-117.22649, 33.2759], [-117.22668, 33.27572], [-117.22705, 33.27529], [-117.22744, 33.27491], [-117.22765, 33.27474], [-117.22792, 33.27457], [-117.22842, 33.27429], [-117.22867, 33.27417], [-117.22899, 33.27408], [-117.22942, 33.27402], [-117.22972, 33.27394], [-117.22985, 33.2739], [-117.23058, 33.27357], [-117.23079, 33.27345], [-117.23183, 33.27282], [-117.23212, 33.27261], [-117.23234, 33.27239], [-117.23282, 33.27179], [-117.23295, 33.27157], [-117.23302, 33.27139], [-117.23305, 33.27113], [-117.23304, 33.27089], [-117.23312, 33.27088], [-117.23313, 33.26857], [-117.23498, 33.26852]]], [[[-117.22101, 33.29299], [-117.22101, 33.29463], [-117.22047, 33.29505], [-117.2195, 33.29631], [-117.21933, 33.29663], [-117.21973, 33.29664], [-117.21935, 33.29772], [-117.21915, 33.29819], [-117.21898, 33.29849], [-117.21878, 33.29877], [-117.21791, 33.29973], [-117.21752, 33.30024], [-117.21752, 33.30028], [-117.21746, 33.30029], [-117.2171, 33.30092], [-117.21714, 33.30094], [-117.21679, 33.30156], [-117.2167, 33.30187], [-117.21659, 33.3021], [-117.21638, 33.30236], [-117.21613, 33.30257], [-117.21582, 33.30273], [-117.21461, 33.3032], [-117.21433, 33.30334], [-117.21402, 33.30354], [-117.21369, 33.3032], [-117.21166, 33.30492], [-117.20899, 33.30653], [-117.20816, 33.30681], [-117.20803, 33.30738], [-117.20798, 33.3074], [-117.208, 33.30742], [-117.20575, 33.30789], [-117.1988, 33.30926], [-117.19536, 33.30995], [-117.19489, 33.31006], [-117.19476, 33.3096], [-117.19539, 33.30858], [-117.19637, 33.308], [-117.19704, 33.30771], [-117.19751, 33.30765], [-117.19807, 33.30773], [-117.19838, 33.30772], [-117.19871, 33.30758], [-117.19925, 33.30719], [-117.1994, 33.30701], [-117.19949, 33.30671], [-117.2, 33.30637], [-117.2002, 33.30614], [-117.20024, 33.30599], [-117.20274, 33.30505], [-117.20322, 33.30471], [-117.20374, 33.30425], [-117.20445, 33.3039], [-117.20626, 33.30282], [-117.20718, 33.30208], [-117.20829, 33.30028], [-117.21061, 33.29909], [-117.21174, 33.29842], [-117.21174, 33.2984], [-117.21162, 33.29828], [-117.2121, 33.29803], [-117.21283, 33.2976], [-117.21304, 33.29744], [-117.21387, 33.29677], [-117.21415, 33.29663], [-117.21459, 33.29651], [-117.21472, 33.29646], [-117.21484, 33.29639], [-117.21517, 33.29616], [-117.21526, 33.29608], [-117.21533, 33.29599], [-117.2154, 33.29588], [-117.21543, 33.29577], [-117.21555, 33.29434], [-117.21563, 33.29409], [-117.21572, 33.29395], [-117.21588, 33.2938], [-117.21658, 33.29325], [-117.2167, 33.29311], [-117.21677, 33.29298], [-117.22101, 33.29299]]], [[[-117.17733, 33.31358], [-117.17383, 33.31428], [-117.16985, 33.3143], [-117.16983, 33.31791], [-117.16585, 33.31793], [-117.16581, 33.31518], [-117.16597, 33.31501], [-117.1661, 33.31492], [-117.16631, 33.31513], [-117.16754, 33.31432], [-117.16932, 33.31297], [-117.17072, 33.31254], [-117.17158, 33.31259], [-117.17432, 33.31214], [-117.17474, 33.31238], [-117.17529, 33.3124], [-117.17733, 33.31358]]]]} | No Public Access 3 | 47590 | San Luis Rey River Park | 31317 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | San Diego 4 | 473.331 | San Luis Rey River Park | 0 | Local Park 2 | 4 | |
7428 | 7428 | 7427 | {"type": "Polygon", "coordinates": [[[-118.22601, 34.0822], [-118.22554, 34.08201], [-118.22525, 34.08188], [-118.22546, 34.08173], [-118.22558, 34.08171], [-118.22568, 34.08174], [-118.22578, 34.08182], [-118.22601, 34.0822]]]} | No Public Access 3 | 6924 | Confluence Park | 29794 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.393 | Confluence Park | 2003 | Local Park 2 | 4 | |
7447 | 7447 | 7446 | {"type": "MultiPolygon", "coordinates": [[[[-118.22877, 34.08683], [-118.22866, 34.08675], [-118.22875, 34.08668], [-118.22875, 34.08668], [-118.22877, 34.08683]]], [[[-118.22915, 34.08683], [-118.22891, 34.08704], [-118.22889, 34.08693], [-118.22882, 34.08688], [-118.22879, 34.08664], [-118.22885, 34.08659], [-118.22915, 34.08683]]]]} | No Public Access 3 | 6921 | Steelhead Park | 25823 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.219 | Steelhead Park | 0 | Local Park 2 | 4 | |
7534 | 7534 | 7533 | {"type": "Polygon", "coordinates": [[[-118.78014, 34.14754], [-118.78008, 34.14761], [-118.78006, 34.14768], [-118.77994, 34.14767], [-118.77967, 34.14771], [-118.77895, 34.14786], [-118.77864, 34.1479], [-118.77715, 34.14789], [-118.77638, 34.14778], [-118.77611, 34.14778], [-118.77413, 34.14793], [-118.77413, 34.14783], [-118.77432, 34.14788], [-118.77524, 34.14781], [-118.77589, 34.14763], [-118.77771, 34.1475], [-118.77817, 34.14749], [-118.77833, 34.14745], [-118.77934, 34.14745], [-118.78014, 34.14754]]]} | No Public Access 3 | 7112 | Agoura Hills City Parkland | 15288 | 1000 | Agoura Hills, City of 319 | City 2 | City Agency 2 | http://www.ci.agoura-hills.ca.us/government/departments/community-services-parks-recreation/parks-facilities | City 2 | 1000 | Agoura Hills, City of 316 | City 2 | City Agency 2 | Los Angeles 6 | 3.654 | Agoura Hills City Parkland | 0 | Local Park 2 | 4 | |
7551 | 7551 | 7550 | {"type": "Polygon", "coordinates": [[[-118.44367, 34.1295], [-118.4417, 34.12943], [-118.4417, 34.12935], [-118.44173, 34.12926], [-118.44203, 34.12886], [-118.44206, 34.12877], [-118.44212, 34.12843], [-118.4427, 34.12846], [-118.44271, 34.12848], [-118.44294, 34.12848], [-118.44294, 34.12861], [-118.4431, 34.12855], [-118.44318, 34.12855], [-118.44328, 34.12859], [-118.44334, 34.12867], [-118.44367, 34.1295]]]} | No Public Access 3 | 7161 | Los Angeles City Water Resource Parkland | 21477 | 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 | 3.797 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
7628 | 7628 | 7627 | {"type": "Polygon", "coordinates": [[[-117.15123, 33.13075], [-117.14933, 33.13075], [-117.14897, 33.13165], [-117.14916, 33.13197], [-117.15033, 33.13376], [-117.14836, 33.13491], [-117.14827, 33.13106], [-117.14832, 33.12938], [-117.14827, 33.12783], [-117.14921, 33.12832], [-117.14932, 33.12837], [-117.14963, 33.12845], [-117.15012, 33.12851], [-117.15039, 33.12859], [-117.15064, 33.12873], [-117.15083, 33.12889], [-117.15099, 33.12911], [-117.15109, 33.12937], [-117.15123, 33.13075]]]} | No Public Access 3 | 47623 | La Moree Park | 31359 | 1308 | San Marcos, City of 201 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | San Diego 4 | 28.883 | La Moree Park | 0 | Local Park 2 | 4 | |
7804 | 7804 | 7803 | {"type": "Polygon", "coordinates": [[[-122.42274, 38.39449], [-122.41856, 38.39451], [-122.4184, 38.39435], [-122.41835, 38.39431], [-122.41799, 38.39415], [-122.4177, 38.39404], [-122.41652, 38.39341], [-122.41618, 38.39306], [-122.41604, 38.39295], [-122.41586, 38.39286], [-122.4159, 38.39281], [-122.41587, 38.39273], [-122.41593, 38.39256], [-122.41485, 38.39153], [-122.4144, 38.39119], [-122.41397, 38.39091], [-122.41853, 38.39089], [-122.41855, 38.39111], [-122.4213, 38.39198], [-122.42177, 38.39216], [-122.42274, 38.39449]]]} | No Public Access 3 | 47687 | Amy's Grove | 31415 | 2268 | Napa County Regional Park and Open Space District 362 | Special District 4 | Recreation/Parks District 4 | http://napaoutdoors.org/ | Special District 4 | 2268 | Napa County Regional Park and Open Space District 108 | Special District 4 | Recreation/Parks District 4 | Napa 11 | 46.448 | Amy's Grove | 0 | Local Park 2 | 4 | |
7864 | 7864 | 7863 | {"type": "MultiPolygon", "coordinates": [[[[-116.92777, 32.58949], [-116.92777, 32.59228], [-116.92719, 32.59236], [-116.92709, 32.59253], [-116.92678, 32.59284], [-116.92635, 32.59308], [-116.92611, 32.59314], [-116.92622, 32.59232], [-116.92562, 32.59183], [-116.92563, 32.5918], [-116.92293, 32.5893], [-116.92211, 32.58875], [-116.92204, 32.58879], [-116.92131, 32.58828], [-116.91987, 32.58695], [-116.91737, 32.58824], [-116.91724, 32.58868], [-116.91579, 32.58965], [-116.91571, 32.59019], [-116.91743, 32.59146], [-116.92026, 32.59141], [-116.92062, 32.59165], [-116.92179, 32.59313], [-116.92285, 32.59318], [-116.92318, 32.59348], [-116.92371, 32.5935], [-116.92369, 32.59353], [-116.92526, 32.595], [-116.92514, 32.59515], [-116.92556, 32.59554], [-116.92582, 32.59535], [-116.92587, 32.59561], [-116.92593, 32.59573], [-116.92601, 32.59583], [-116.92635, 32.59609], [-116.9266, 32.5963], [-116.92681, 32.59658], [-116.92695, 32.59689], [-116.91079, 32.59702], [-116.9107, 32.59326], [-116.9129, 32.59324], [-116.91243, 32.59374], [-116.91342, 32.59443], [-116.91457, 32.59326], [-116.91516, 32.59328], [-116.91548, 32.5923], [-116.91619, 32.5921], [-116.91584, 32.59121], [-116.91508, 32.59097], [-116.91467, 32.59137], [-116.9128, 32.59139], [-116.91275, 32.58957], [-116.91061, 32.58958], [-116.91052, 32.58587], [-116.91906, 32.5858], [-116.92128, 32.5858], [-116.92129, 32.58715], [-116.92666, 32.58812], [-116.92777, 32.58949]]], [[[-116.92994, 32.59688], [-116.92778, 32.59688], [-116.92778, 32.59585], [-116.92807, 32.5955], [-116.92806, 32.59492], [-116.92993, 32.59491], [-116.92994, 32.59688]]], [[[-116.98385, 32.58252], [-116.97937, 32.58383], [-116.97937, 32.58383], [-116.97936, 32.5825], [-116.98385, 32.58252]]]]} | No Public Access 3 | 47717 | Otay Valley Regional Park | 31497 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.ovrp.org/ | San Diego 4 | 324.329 | Otay Valley RP | 0 | Local Park 2 | 4 |
7936 | 7936 | 7935 | {"type": "Polygon", "coordinates": [[[-118.36765, 34.12534], [-118.36714, 34.12607], [-118.36565, 34.126], [-118.3668, 34.12438], [-118.3669, 34.12456], [-118.36735, 34.12491], [-118.36715, 34.12508], [-118.36715, 34.1251], [-118.36765, 34.12534]]]} | No Public Access 3 | 12815 | Los Angeles City Water Resource Parkland | 21477 | 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 | 4.385 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
7948 | 7948 | 7947 | {"type": "Polygon", "coordinates": [[[-118.37369, 34.12306], [-118.3737, 34.12323], [-118.37362, 34.12338], [-118.37328, 34.12338], [-118.37328, 34.12313], [-118.3733, 34.12309], [-118.37349, 34.12293], [-118.37369, 34.12306]]]} | No Public Access 3 | 12814 | Los Angeles City Water Resource Parkland | 21477 | 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.377 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
7957 | 7957 | 7956 | {"type": "MultiPolygon", "coordinates": [[[[-117.26235, 32.97049], [-117.26211, 32.97088], [-117.26009, 32.96991], [-117.25848, 32.97116], [-117.25599, 32.97118], [-117.25596, 32.9703], [-117.25172, 32.97117], [-117.25111, 32.97119], [-117.25033, 32.97051], [-117.24968, 32.96839], [-117.24944, 32.96746], [-117.25596, 32.96753], [-117.25598, 32.96812], [-117.25807, 32.96814], [-117.25841, 32.96814], [-117.25888, 32.96806], [-117.25973, 32.9678], [-117.26055, 32.96864], [-117.26088, 32.96904], [-117.26112, 32.96943], [-117.26155, 32.96979], [-117.26146, 32.9699], [-117.26137, 32.96987], [-117.26132, 32.96997], [-117.26152, 32.9701], [-117.26186, 32.97027], [-117.26235, 32.97049]]], [[[-117.24735, 32.97286], [-117.24305, 32.97281], [-117.24305, 32.97158], [-117.24317, 32.97158], [-117.24315, 32.97208], [-117.24328, 32.97225], [-117.24361, 32.97234], [-117.24382, 32.97234], [-117.24398, 32.97218], [-117.24405, 32.97187], [-117.24405, 32.97166], [-117.24394, 32.97137], [-117.24371, 32.97114], [-117.2437, 32.97056], [-117.2445, 32.96992], [-117.24637, 32.96993], [-117.24591, 32.96921], [-117.24734, 32.96922], [-117.24734, 32.97169], [-117.24735, 32.97286]]], [[[-117.2474, 32.97836], [-117.24168, 32.97829], [-117.24007, 32.97858], [-117.23873, 32.97897], [-117.23872, 32.9777], [-117.23589, 32.97769], [-117.23589, 32.97824], [-117.23054, 32.97821], [-117.23052, 32.97748], [-117.23055, 32.9772], [-117.23063, 32.97688], [-117.23075, 32.97656], [-117.23089, 32.97626], [-117.23099, 32.97611], [-117.23119, 32.97583], [-117.23144, 32.97557], [-117.2317, 32.97533], [-117.23211, 32.97505], [-117.23268, 32.97477], [-117.23304, 32.97465], [-117.2334, 32.97456], [-117.23688, 32.97409], [-117.23729, 32.97401], [-117.23762, 32.97391], [-117.23784, 32.97383], [-117.2382, 32.97365], [-117.23858, 32.9734], [-117.23889, 32.97314], [-117.23904, 32.97297], [-117.2392, 32.97277], [-117.23934, 32.97257], [-117.23948, 32.97231], [-117.23958, 32.97204], [-117.23966, 32.97176], [-117.24045, 32.97176], [-117.24045, 32.97462], [-117.24175, 32.97464], [-117.24175, 32.9743], [-117.24287, 32.97407], [-117.24306, 32.97398], [-117.24305, 32.97482], [-117.24306, 32.97483], [-117.24737, 32.97395], [-117.2474, 32.97836]]], [[[-117.12723, 33.03666], [-117.1267, 33.03665], [-117.1267, 33.03659], [-117.12721, 33.03658], [-117.12723, 33.03666]]], [[[-117.13947, 33.04016], [-117.13513, 33.04016], [-117.13512, 33.04084], [-117.13399, 33.04103], [-117.13276, 33.0414], [-117.13197, 33.0423], [-117.13159, 33.04282], [-117.13122, 33.04321], [-117.13101, 33.04348], [-117.13078, 33.04382], [-117.12669, 33.04383], [-117.12669, 33.03929], [-117.13097, 33.0393], [-117.13098, 33.03878], [-117.13276, 33.03877], [-117.13276, 33.03653], [-117.13453, 33.03651], [-117.13946, 33.03649], [-117.13947, 33.04016]]], [[[-117.0431, 33.0404], [-117.04234, 33.04173], [-117.04209, 33.04158], [-117.04186, 33.04141], [-117.04138, 33.0416], [-117.04066, 33.04105], [-117.04019, 33.04144], [-117.04051, 33.04183], [-117.04078, 33.04227], [-117.04082, 33.04235], [-117.04078, 33.04269], [-117.04076, 33.04278], [-117.04079, 33.04288], [-117.04083, 33.0429], [-117.04157, 33.04309], [-117.04105, 33.04401], [-117.03222, 33.04407], [-117.03187, 33.03647], [-117.03625, 33.0365], [-117.03626, 33.03787], [-117.03772, 33.03788], [-117.03774, 33.03944], [-117.03736, 33.03944], [-117.03735, 33.03946], [-117.03746, 33.03948], [-117.0376, 33.03953], [-117.03769, 33.03958], [-117.03771, 33.03962], [-117.03777, 33.03965], [-117.03823, 33.03999], [-117.03825, 33.04003], [-117.03828, 33.04003], [-117.03872, 33.04036], [-117.03891, 33.04044], [-117.03915, 33.04002], [-117.03915, 33.03946], [-117.04057, 33.03948], [-117.04058, 33.04037], [-117.0431, 33.0404]], [[-117.03526, 33.04034], [-117.03408, 33.04031], [-117.03407, 33.0424], [-117.03523, 33.04239], [-117.03526, 33.04034]], [[-117.04019, 33.04144], [-117.04003, 33.04122], [-117.03946, 33.0408], [-117.0386, 33.04165], [-117.03827, 33.042], [-117.03952, 33.04203], [-117.04001, 33.04161], [-117.04019, 33.04144]]], [[[-117.03205, 33.04178], [-117.02982, 33.0424], [-117.02925, 33.04297], [-117.02937, 33.04402], [-117.02816, 33.04403], [-117.02819, 33.04383], [-117.02815, 33.04362], [-117.02825, 33.04325], [-117.02852, 33.0431], [-117.02857, 33.04285], [-117.02888, 33.0425], [-117.02865, 33.04161], [-117.02863, 33.04105], [-117.02873, 33.04095], [-117.02876, 33.04048], [-117.02901, 33.03959], [-117.02902, 33.03946], [-117.02898, 33.03928], [-117.02916, 33.03901], [-117.02917, 33.03852], [-117.02989, 33.03839], [-117.03039, 33.03864], [-117.03073, 33.0387], [-117.03191, 33.03867], [-117.03205, 33.04178]]], [[[-116.96257, 33.06565], [-116.95798, 33.06557], [-116.95791, 33.06161], [-116.96238, 33.06154], [-116.96257, 33.06565]]], [[[-117.08807, 33.07148], [-117.08733, 33.07483], [-117.08719, 33.07507], [-117.08712, 33.07514], [-117.08674, 33.07532], [-117.08707, 33.07476], [-117.08715, 33.07449], [-117.08715, 33.0743], [-117.08712, 33.07423], [-117.08682, 33.07349], [-117.0868, 33.07337], [-117.08681, 33.07317], [-117.08687, 33.07304], [-117.08698, 33.07287], [-117.0871, 33.07278], [-117.08712, 33.0728], [-117.08726, 33.07272], [-117.08724, 33.07269], [-117.08738, 33.07195], [-117.08607, 33.0716], [-117.08608, 33.07132], [-117.08807, 33.07148]]], [[[-117.01587, 33.10181], [-117.00721, 33.10173], [-117.00723, 33.09846], [-117.01352, 33.09829], [-117.01389, 33.09866], [-117.01411, 33.09881], [-117.01437, 33.09892], [-117.01466, 33.09898], [-117.01494, 33.09899], [-117.01505, 33.09902], [-117.01527, 33.09906], [-117.01554, 33.09906], [-117.01564, 33.09904], [-117.01586, 33.09905], [-117.01585, 33.09912], [-117.01587, 33.10181]]], [[[-116.74109, 33.1079], [-116.74108, 33.10916], [-116.73672, 33.10922], [-116.73671, 33.10849], [-116.739, 33.10849], [-116.73919, 33.10866], [-116.73938, 33.10856], [-116.73993, 33.10789], [-116.74109, 33.1079]]], [[[-116.60366, 33.11132], [-116.60366, 33.11148], [-116.60362, 33.11165], [-116.60351, 33.11184], [-116.60341, 33.11194], [-116.60332, 33.112], [-116.6032, 33.11203], [-116.60284, 33.11208], [-116.60256, 33.11216], [-116.60257, 33.10898], [-116.60291, 33.1097], [-116.60295, 33.10986], [-116.60299, 33.11018], [-116.60304, 33.11034], [-116.60329, 33.11073], [-116.60356, 33.11107], [-116.60364, 33.11122], [-116.60366, 33.11132]]], [[[-116.61024, 33.11223], [-116.60655, 33.11585], [-116.60292, 33.11583], [-116.60304, 33.1155], [-116.60306, 33.11537], [-116.60306, 33.11514], [-116.60273, 33.11376], [-116.60264, 33.11354], [-116.60255, 33.11339], [-116.60216, 33.11299], [-116.6021, 33.11295], [-116.60206, 33.11289], [-116.60201, 33.11275], [-116.60204, 33.11268], [-116.60214, 33.11256], [-116.60234, 33.11244], [-116.60259, 33.11233], [-116.60271, 33.11228], [-116.60296, 33.11222], [-116.60328, 33.11219], [-116.60345, 33.11212], [-116.60351, 33.11209], [-116.60365, 33.11196], [-116.60378, 33.11176], [-116.60385, 33.11152], [-116.60385, 33.11129], [-116.60381, 33.11113], [-116.60375, 33.11101], [-116.6034, 33.11055], [-116.60321, 33.11025], [-116.60315, 33.10998], [-116.60314, 33.10982], [-116.6031, 33.10966], [-116.603, 33.10943], [-116.60286, 33.10916], [-116.60263, 33.10865], [-116.6069, 33.10865], [-116.60691, 33.11222], [-116.61024, 33.11223]]], [[[-116.77148, 33.11263], [-116.76714, 33.11269], [-116.76717, 33.12036], [-116.76283, 33.12035], [-116.76285, 33.1242], [-116.74993, 33.12419], [-116.74983, 33.11661], [-116.7628, 33.1166], [-116.76278, 33.11275], [-116.76713, 33.11269], [-116.76713, 33.11085], [-116.77147, 33.11083], [-116.77148, 33.11263]]], [[[-116.56364, 33.11825], [-116.55962, 33.1184], [-116.55967, 33.12184], [-116.55915, 33.12187], [-116.55924, 33.12381], [-116.55473, 33.12403], [-116.55462, 33.12208], [-116.55564, 33.12202], [-116.55545, 33.1078], [-116.55541, 33.10779], [-116.55544, 33.10415], [-116.55533, 33.10051], [-116.55939, 33.10043], [-116.5595, 33.10399], [-116.56342, 33.10381], [-116.56349, 33.10731], [-116.56364, 33.11825]]], [[[-116.71987, 33.10558], [-116.72399, 33.10562], [-116.72398, 33.10933], [-116.7282, 33.10929], [-116.72829, 33.11298], [-116.73253, 33.11295], [-116.73266, 33.11669], [-116.72837, 33.11669], [-116.72845, 33.12039], [-116.73275, 33.1204], [-116.73282, 33.12416], [-116.72863, 33.12404], [-116.71994, 33.12392], [-116.71989, 33.12778], [-116.71994, 33.13029], [-116.71894, 33.12855], [-116.71794, 33.12675], [-116.71666, 33.12415], [-116.71148, 33.11444], [-116.71153, 33.11315], [-116.71147, 33.11126], [-116.71146, 33.10951], [-116.7114, 33.10578], [-116.71987, 33.10558]], [[-116.71786, 33.11216], [-116.7199, 33.11215], [-116.7199, 33.1112], [-116.71568, 33.11125], [-116.7157, 33.11216], [-116.71786, 33.11216]]], [[[-116.59542, 33.15573], [-116.58232, 33.15643], [-116.58105, 33.15221], [-116.58537, 33.15193], [-116.58535, 33.14991], [-116.58968, 33.14953], [-116.5897, 33.15165], [-116.59408, 33.15137], [-116.59542, 33.15573]]]]} | No Public Access 3 | 10844 | San Dieguito River Park | 24869 | 2134 | San Dieguito River Park Joint Powers Authority 883 | Special District 4 | Open Space District 6 | http://www.sdrp.org/ | Special District 4 | 2134 | San Dieguito River Park Joint Powers Authority 859 | Special District 4 | Open Space District 6 | San Diego 4 | 2520.958 | San Dieguito River Park | 0 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]), FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]), FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]), FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]), FOREIGN KEY([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);