units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
75 rows where DES_TP = 65 and LAYER = 10 sorted by UNIT_NAME
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_TYP, PARK_URL, COUNTY, YR_EST
MNG_AGENCY >30
- Mountains Restoration Trust 26
- Los Angeles Neighborhood Land Trust 6
- San Dieguito River Valley Land Conservancy 5
- Arroyos and Foothills Conservancy 4
- Odd Fellows Sierra Recreation Association 3
- Truckee Donner Land Trust 2
- Trinidad Coastal Land Trust 2
- Trust for Public Land 2
- John Muir Land Trust 1
- Back Country Land Trust 1
- Land Trust for Santa Barbara County 1
- Solano Land Trust 1
- Sierra Historic Sites Association 1
- Del Monte Forest Foundation 1
- American River Conservancy 1
- Friends of the Dunes 1
- National Audubon Society 1
- Tri-Valley Conservancy 1
- The Collaborative Eagle Rock Beautiful 1
- Serra Cross Conservancy 1
- Westport Village Society 1
- Heal the Bay 1
- Mare Island Historic Park Foundation 1
- San Diego Humane Society and SPCA 1
- Kingsburg Historical Society 1
- Roosevelt Memorial Park Association 1
- Foundation for Preservation of Mt. Helix Nature Theatre 1
- Independent Order of Odd Fellows 1
- Palo Cerdo Community Park Association 1
- California Institute of Technology 1
- …
MNG_AG_TYP 5
ACCESS_TYP 4
DES_TP 1
- Private Recreation or Education · 75 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16200 | 16200 | 16199 | {"type": "Polygon", "coordinates": [[[-122.0897, 37.9062], [-122.08967, 37.90933], [-122.08958, 37.90936], [-122.08957, 37.91025], [-122.08787, 37.91065], [-122.08733, 37.91063], [-122.08703, 37.90902], [-122.08705, 37.90838], [-122.08752, 37.90706], [-122.0882, 37.90623], [-122.0897, 37.9062]]]} | Open Access 1 | 29704 | Acalanes Ridge Open Space | 15246 | 3045 | John Muir Land Trust 108 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.jmlt.org/ | Non Governmental Organization 10 | 3045 | John Muir Land Trust 105 | Non Profit 6 | Non Profit - Land Trust 10 | Contra Costa 12 | 24.054 | Acalanes Ridge OS | 0 | Private Recreation or Education 65 | 4 | |
1490 | 1490 | 1489 | {"type": "Polygon", "coordinates": [[[-117.68588, 34.45141], [-117.68154, 34.45142], [-117.68152, 34.44779], [-117.68587, 34.4478], [-117.68588, 34.45141]]]} | Restricted Access 2 | 12700 | Antelope Valley Open Space | 29491 | 3000 | Arroyos and Foothills Conservancy 375 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.arroyosfoothills.org/ | Non Governmental Organization 10 | 3000 | Arroyos and Foothills Conservancy 370 | Non Profit 6 | Non Profit - Land Trust 10 | Los Angeles 6 | 39.642 | Antelope Valley OS | 0 | Private Recreation or Education 65 | 4 | |
8330 | 8330 | 8329 | {"type": "Polygon", "coordinates": [[[-117.09055, 33.05824], [-117.08987, 33.06472], [-117.0888, 33.0652], [-117.08779, 33.06623], [-117.08762, 33.06754], [-117.08752, 33.06778], [-117.08632, 33.06777], [-117.08589, 33.06832], [-117.08581, 33.06924], [-117.08613, 33.07024], [-117.08537, 33.07057], [-117.08523, 33.07125], [-117.08374, 33.07112], [-117.08344, 33.0707], [-117.08373, 33.0701], [-117.08329, 33.06941], [-117.08281, 33.06838], [-117.08267, 33.06775], [-117.08203, 33.06715], [-117.08234, 33.06662], [-117.08253, 33.06494], [-117.08257, 33.06486], [-117.0825, 33.06439], [-117.08259, 33.06429], [-117.08265, 33.06402], [-117.08265, 33.06372], [-117.08256, 33.06359], [-117.08246, 33.06348], [-117.0824, 33.06321], [-117.08242, 33.06312], [-117.08251, 33.06298], [-117.08256, 33.06263], [-117.08304, 33.06214], [-117.08335, 33.0619], [-117.08367, 33.0615], [-117.08376, 33.06128], [-117.08385, 33.06118], [-117.08378, 33.06105], [-117.08379, 33.06096], [-117.08386, 33.06082], [-117.08427, 33.06051], [-117.08432, 33.06043], [-117.08444, 33.06032], [-117.08499, 33.05989], [-117.0857, 33.05861], [-117.08713, 33.058], [-117.08766, 33.05785], [-117.08761, 33.0577], [-117.0876, 33.05758], [-117.08766, 33.05738], [-117.08773, 33.05731], [-117.08795, 33.05728], [-117.08817, 33.05732], [-117.0884, 33.05745], [-117.08853, 33.05762], [-117.08965, 33.0578], [-117.08988, 33.05787], [-117.09024, 33.05791], [-117.09039, 33.058], [-117.09055, 33.05824]], [[-117.08681, 33.06677], [-117.0869, 33.06677], [-117.087, 33.06674], [-117.08714, 33.06664], [-117.08713, 33.0657], [-117.08615, 33.0657], [-117.08616, 33.06666], [-117.08668, 33.06676], [-117.08681, 33.06677]]]} | Open Access 1 | 12833 | Bernardo Mountain Open Space | 10792 | 3066 | San Dieguito River Valley Land Conservancy 378 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sdrvc.org/ | Non Governmental Organization 10 | 3066 | San Dieguito River Valley Land Conservancy 373 | Non Profit 6 | Non Profit - Land Trust 10 | http://sdrvc.org/accomplishments/bernardo-mountain/171 | San Diego 4 | 175.923 | Bernardo Mtn. OS | 0 | Private Recreation or Education 65 | 4 |
7599 | 7599 | 7598 | {"type": "Polygon", "coordinates": [[[-117.35825, 33.16477], [-117.35811, 33.16484], [-117.35793, 33.16488], [-117.35776, 33.16502], [-117.35773, 33.16507], [-117.35761, 33.1652], [-117.35715, 33.1652], [-117.35715, 33.16625], [-117.35629, 33.16543], [-117.35617, 33.16533], [-117.35607, 33.16521], [-117.35598, 33.1652], [-117.35586, 33.16509], [-117.35548, 33.16483], [-117.35555, 33.16478], [-117.3555, 33.16464], [-117.35547, 33.16431], [-117.35558, 33.16437], [-117.35557, 33.16441], [-117.35563, 33.16466], [-117.35569, 33.16472], [-117.35576, 33.16486], [-117.35757, 33.16474], [-117.3576, 33.16476], [-117.35792, 33.16464], [-117.35803, 33.16453], [-117.35825, 33.16477]]]} | Open Access 1 | 7307 | Buena Vista Lagoon and Nature Center | 16487 | 3046 | National Audubon Society 651 | Non Profit 6 | Non Profit - Conservation 12 | http://ca.audubon.org/ | Non Governmental Organization 10 | 3046 | National Audubon Society 640 | Non Profit 6 | Non Profit - Conservation 12 | http://bvaudubon.org/nature-center/ | San Diego 4 | 3.999 | Buena Vista Lagoon and Nature Ctr. | 0 | Private Recreation or Education 65 | 4 |
16019 | 16019 | 16018 | {"type": "MultiPolygon", "coordinates": [[[[-119.50311, 34.38539], [-119.50308, 34.38568], [-119.50203, 34.38548], [-119.50073, 34.38536], [-119.49887, 34.38533], [-119.49817, 34.38537], [-119.49748, 34.38535], [-119.49678, 34.38526], [-119.49447, 34.3849], [-119.49448, 34.38485], [-119.49679, 34.38513], [-119.49887, 34.38526], [-119.50073, 34.38526], [-119.50311, 34.38539]]], [[[-119.50306, 34.38596], [-119.50288, 34.38954], [-119.5017, 34.38915], [-119.5012, 34.38892], [-119.50096, 34.38879], [-119.50056, 34.38856], [-119.50013, 34.38825], [-119.49921, 34.38755], [-119.49896, 34.3874], [-119.49863, 34.38725], [-119.4986, 34.38722], [-119.4986, 34.38718], [-119.49881, 34.38671], [-119.49883, 34.38663], [-119.49857, 34.38656], [-119.49832, 34.38711], [-119.49827, 34.38715], [-119.49793, 34.38709], [-119.49748, 34.38708], [-119.49613, 34.38716], [-119.49585, 34.38715], [-119.49556, 34.38711], [-119.49517, 34.38702], [-119.49525, 34.38542], [-119.49629, 34.38558], [-119.49673, 34.3856], [-119.49793, 34.38562], [-119.49986, 34.38559], [-119.50095, 34.38564], [-119.50186, 34.38572], [-119.50275, 34.38589], [-119.50306, 34.38596]]], [[[-119.50861, 34.39081], [-119.50768, 34.39055], [-119.50768, 34.39119], [-119.50603, 34.39037], [-119.50539, 34.39025], [-119.50539, 34.39014], [-119.50559, 34.39014], [-119.5056, 34.38959], [-119.50861, 34.39049], [-119.50861, 34.39081]]]]} | Open Access 1 | 3980 | Carpinteria Bluffs Public Open Space | 16893 | 3033 | Land Trust for Santa Barbara County 269 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sblandtrust.org | Non Governmental Organization 10 | 3033 | Land Trust for Santa Barbara County 264 | Non Profit 6 | Non Profit - Land Trust 10 | Santa Barbara 7 | 52.141 | Carpinteria Bluffs Public OS | 0 | Private Recreation or Education 65 | 4 | |
15232 | 15232 | 15231 | {"type": "Polygon", "coordinates": [[[-118.14873, 34.20755], [-118.14873, 34.20755], [-118.14745, 34.20754], [-118.14816, 34.20703], [-118.14871, 34.20655], [-118.14873, 34.20755]]]} | Open Access 1 | 46186 | Chaney Trail Open Space | 29490 | 3000 | Arroyos and Foothills Conservancy 375 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.arroyosfoothills.org/ | Non Governmental Organization 10 | 3000 | Arroyos and Foothills Conservancy 370 | Non Profit 6 | Non Profit - Land Trust 10 | Los Angeles 6 | 1.539 | Chaney Trail OS | 0 | Private Recreation or Education 65 | 4 | |
1523 | 1523 | 1522 | {"type": "Polygon", "coordinates": [[[-116.78494, 33.12411], [-116.78019, 33.12414], [-116.7802, 33.12031], [-116.7849, 33.12029], [-116.78494, 33.12411]]]} | Open Access 1 | 12843 | Corral Mountain Open Space | 17655 | 3066 | San Dieguito River Valley Land Conservancy 378 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sdrvc.org/ | Non Governmental Organization 10 | 3066 | San Dieguito River Valley Land Conservancy 373 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 46.202 | Corral Mtn. OS | 0 | Private Recreation or Education 65 | 4 | |
7965 | 7965 | 7964 | {"type": "Polygon", "coordinates": [[[-116.7891, 33.13878], [-116.78022, 33.1388], [-116.78022, 33.13504], [-116.78472, 33.13503], [-116.78478, 33.13134], [-116.78494, 33.12411], [-116.78899, 33.12409], [-116.78892, 33.13124], [-116.78904, 33.13125], [-116.7891, 33.13878]]]} | No Public Access 3 | 47728 | Corral Mountain Open Space | 31528 | 3066 | San Dieguito River Valley Land Conservancy 378 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sdrvc.org/ | Non Governmental Organization 10 | 3066 | San Dieguito River Valley Land Conservancy 373 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 201.771 | Corral Mtn. OS | 0 | Private Recreation or Education 65 | 4 | |
3845 | 3845 | 3844 | {"type": "Polygon", "coordinates": [[[-118.18362, 34.14471], [-118.18351, 34.1448], [-118.18343, 34.14491], [-118.18336, 34.1451], [-118.18336, 34.1453], [-118.1834, 34.14542], [-118.18348, 34.14554], [-118.18357, 34.14564], [-118.18353, 34.1458], [-118.18343, 34.14596], [-118.1821, 34.14546], [-118.18217, 34.14478], [-118.18267, 34.14401], [-118.18325, 34.14443], [-118.18319, 34.14449], [-118.18324, 34.14457], [-118.18336, 34.14452], [-118.18362, 34.14471]]]} | Open Access 1 | 46810 | Eagle Rock Canyon Trail | 30271 | 3367 | The Collaborative Eagle Rock Beautiful 692 | Non Profit 6 | Non Profit - Other 22 | http://www.cerb.us/ | Non Governmental Organization 10 | 3367 | The Collaborative Eagle Rock Beautiful 682 | Non Profit 6 | Non Profit - Other 20 | http://www.cerb.us/ | Los Angeles 6 | 4.567 | Eagle Rock Canyon Trail | 0 | Private Recreation or Education 65 | 4 |
15335 | 15335 | 15334 | {"type": "Polygon", "coordinates": [[[-118.27552, 34.03356], [-118.27521, 34.03404], [-118.27516, 34.03403], [-118.27517, 34.03372], [-118.27516, 34.0334], [-118.27552, 34.03356]]]} | Open Access 1 | 46514 | Estrella Park | 29799 | 3269 | Los Angeles Neighborhood Land Trust 564 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.lanlt.org/ | Non Governmental Organization 10 | 3269 | Los Angeles Neighborhood Land Trust 556 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.lanlt.org/parks-and-gardens.php | Los Angeles 6 | 0.309 | Estrella Park | 1982 | Private Recreation or Education 65 | 4 |
14655 | 14655 | 14654 | {"type": "Polygon", "coordinates": [[[-118.23217, 33.92468], [-118.23217, 33.9253], [-118.23188, 33.9253], [-118.23188, 33.92468], [-118.23217, 33.92468]]]} | Open Access 1 | 45042 | Faith and Hope Veterans Park | 28005 | 3269 | Los Angeles Neighborhood Land Trust 564 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.lanlt.org/ | Non Governmental Organization 10 | 3269 | Los Angeles Neighborhood Land Trust 556 | Non Profit 6 | Non Profit - Land Trust 10 | Los Angeles 6 | 0.453 | Faith and Hope Veterans Park | 0 | Private Recreation or Education 65 | 4 | |
1961 | 1961 | 1960 | {"type": "Polygon", "coordinates": [[[-119.64038, 37.32984], [-119.64037, 37.33056], [-119.6394, 37.33019], [-119.63911, 37.33026], [-119.63852, 37.33009], [-119.63833, 37.32985], [-119.63942, 37.32983], [-119.64038, 37.32984]]]} | Open Access 1 | 16718 | Fresno Flats Historic Park | 19111 | 3078 | Sierra Historic Sites Association 462 | Non Profit 6 | Non Profit - Other 22 | http://www.fresnoflatsmuseum.org/ | Non Governmental Organization 10 | 3078 | Sierra Historic Sites Association 455 | Non Profit 6 | Non Profit - Other 20 | Madera 48 | 2.12 | Fresno Flats Historic Park | 0 | Private Recreation or Education 65 | 4 | |
9703 | 9703 | 9702 | {"type": "Polygon", "coordinates": [[[-121.6411, 36.65494], [-121.64106, 36.65632], [-121.641, 36.65661], [-121.6406, 36.65768], [-121.64034, 36.65762], [-121.63984, 36.65855], [-121.63922, 36.65869], [-121.638, 36.65816], [-121.63756, 36.65787], [-121.63698, 36.65755], [-121.63948, 36.65383], [-121.64101, 36.65449], [-121.64084, 36.65478], [-121.64082, 36.65492], [-121.6411, 36.65494]]]} | Unknown Access 4 | 16402 | Garden of Memories Memorial Park | 19198 | 3031 | Independent Order of Odd Fellows 921 | Non Profit 6 | Non Profit - Other 22 | http://www.ioof.org/ | Non Governmental Organization 10 | 3031 | Independent Order of Odd Fellows 894 | Non Profit 6 | Non Profit - Other 20 | Monterey 14 | 29.526 | Garden of Memories Memorial Park | 0 | Private Recreation or Education 65 | 4 | |
2966 | 2966 | 2965 | {"type": "Polygon", "coordinates": [[[-118.28333, 34.05806], [-118.28325, 34.05818], [-118.28282, 34.05798], [-118.2829, 34.05786], [-118.28333, 34.05806]]]} | Open Access 1 | 48647 | Golden Age Park | 33393 | 3269 | Los Angeles Neighborhood Land Trust 564 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.lanlt.org/ | Non Governmental Organization 10 | 3269 | Los Angeles Neighborhood Land Trust 556 | Non Profit 6 | Non Profit - Land Trust 10 | https://www.lanlt.org/projectupdates | Los Angeles 6 | 0.172 | Golden Age Park | 2019 | Private Recreation or Education 65 | 4 |
7266 | 7266 | 7265 | {"type": "Polygon", "coordinates": [[[-118.61947, 34.11809], [-118.61505, 34.11808], [-118.61507, 34.11444], [-118.61946, 34.11443], [-118.61947, 34.11809]]]} | No Public Access 3 | 6454 | Henry Ridge Open Space | 29664 | 3044 | Mountains Restoration Trust 533 | Non Profit 6 | Non Profit - Conservation 12 | http://www.mountainstrust.org/ | Non Governmental Organization 10 | 3044 | Mountains Restoration Trust 526 | Non Profit 6 | Non Profit - Conservation 12 | Los Angeles 6 | 40.702 | Henry Ridge OS | 0 | Private Recreation or Education 65 | 4 | |
7541 | 7541 | 7540 | {"type": "Polygon", "coordinates": [[[-124.11965, 41.03876], [-124.11891, 41.0388], [-124.11852, 41.0388], [-124.11838, 41.03832], [-124.11834, 41.03786], [-124.11845, 41.03761], [-124.1185, 41.0374], [-124.11848, 41.03711], [-124.11845, 41.03703], [-124.11803, 41.03637], [-124.11803, 41.03607], [-124.11812, 41.03579], [-124.11835, 41.03581], [-124.11849, 41.03571], [-124.1189, 41.0358], [-124.11916, 41.03613], [-124.11919, 41.03682], [-124.11911, 41.0371], [-124.11907, 41.03794], [-124.11913, 41.03827], [-124.11933, 41.03852], [-124.11965, 41.03876]]]} | Open Access 1 | 47608 | Houda Point/Camel Rock Beach Park | 31339 | 3203 | Trinidad Coastal Land Trust 690 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.trinidadcoastallandtrust.org/ | Non Governmental Organization 10 | 3203 | Trinidad Coastal Land Trust 680 | Non Profit 6 | Non Profit - Land Trust 10 | http://trinidadcoastallandtrust.org/holdings/houdapoint/ | Humboldt 45 | 5.877 | Houda Point/Camel Rock Beach Park | 0 | Private Recreation or Education 65 | 4 |
3318 | 3318 | 3317 | {"type": "Polygon", "coordinates": [[[-124.16888, 40.85809], [-124.16824, 40.85924], [-124.16227, 40.85914], [-124.16173, 40.85708], [-124.16234, 40.85708], [-124.16253, 40.8578], [-124.16325, 40.85769], [-124.16427, 40.85767], [-124.16438, 40.85809], [-124.16888, 40.85809]]]} | Restricted Access 2 | 29680 | Humboldt Coastal Nature Center | 20144 | 3127 | Friends of the Dunes 617 | Non Profit 6 | Non Profit - Conservation 12 | http://www.friendsofthedunes.org/ | Non Governmental Organization 10 | 3127 | Friends of the Dunes 606 | Non Profit 6 | Non Profit - Conservation 12 | Humboldt 45 | 19.441 | Humboldt Coastal Nature Ctr. | 0 | Private Recreation or Education 65 | 4 | |
5753 | 5753 | 5752 | {"type": "Polygon", "coordinates": [[[-119.54118, 36.51798], [-119.54116, 36.52003], [-119.54018, 36.52002], [-119.54021, 36.51798], [-119.54118, 36.51798]]]} | Restricted Access 2 | 3683 | Kingsburg Historical Park | 32675 | 3138 | Kingsburg Historical Society 817 | Non Profit 6 | Non Profit - Other 22 | http://www.kingsburghistoricalpark.org/ | Non Governmental Organization 10 | 3138 | Kingsburg Historical Society 795 | Non Profit 6 | Non Profit - Other 20 | http://kingsburghistoricalpark.org/ | Fresno 9 | 4.887 | Kingsburg Historical Park | 0 | Private Recreation or Education 65 | 4 |
7240 | 7240 | 7239 | {"type": "MultiPolygon", "coordinates": [[[[-118.63834, 34.05331], [-118.63828, 34.05338], [-118.63796, 34.05287], [-118.63805, 34.05287], [-118.63822, 34.05318], [-118.63834, 34.05331]]], [[[-118.6403, 34.06405], [-118.63999, 34.06447], [-118.63883, 34.06406], [-118.63887, 34.06394], [-118.63886, 34.06386], [-118.63882, 34.06371], [-118.63874, 34.06362], [-118.63846, 34.06342], [-118.63832, 34.06326], [-118.63943, 34.06277], [-118.63948, 34.06284], [-118.63955, 34.06289], [-118.63962, 34.06291], [-118.63971, 34.06301], [-118.63979, 34.06313], [-118.63977, 34.06316], [-118.64005, 34.06353], [-118.64004, 34.06366], [-118.64009, 34.06377], [-118.6403, 34.06405]]]]} | No Public Access 3 | 6434 | Las Flores Canyon Open Space | 29666 | 3044 | Mountains Restoration Trust 533 | Non Profit 6 | Non Profit - Conservation 12 | http://www.mountainstrust.org/ | Non Governmental Organization 10 | 3044 | Mountains Restoration Trust 526 | Non Profit 6 | Non Profit - Conservation 12 | Los Angeles 6 | 4.661 | Las Flores Canyon OS | 0 | Private Recreation or Education 65 | 4 | |
14713 | 14713 | 14712 | {"type": "Polygon", "coordinates": [[[-118.2902, 34.09309], [-118.2894, 34.0931], [-118.2894, 34.09282], [-118.2902, 34.09282], [-118.2902, 34.09309]]]} | Open Access 1 | 45052 | Madison Avenue Park | 28044 | 3094 | Trust for Public Land 734 | Non Profit 6 | Non Profit - Conservation 12 | http://www.tpl.org/ | Non Governmental Organization 10 | 3094 | Trust for Public Land 718 | Non Profit 6 | Non Profit - Conservation 12 | http://www.tpl.org/our-work/parks-for-people/madison-ave-park | Los Angeles 6 | 0.559 | Madison Avenue Park | 0 | Private Recreation or Education 65 | 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]);