units_with_maps

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

148 rows where MNG_AG_TYP = 12

View and edit SQL

Suggested facets: AGNCY_LEV, AGNCY_TYP, LAYER, COUNTY, YR_EST, GAP_STS

MNG_AG_TYP

  • Non Profit - Conservation · 148
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
196 195 {"type": "Polygon", "coordinates": [[[-116.80824, 32.84466], [-116.80813, 32.84546], [-116.80736, 32.84567], [-116.80702, 32.84516], [-116.80704, 32.84466], [-116.80824, 32.84466]]]} No Public Access 3 46830 Palmer Property 30298 3208 Endangered Habitats Conservancy 79 Non Profit 6 Non Profit - Conservation 12 http://www.ehleague.org/EndangeredHabitatsConservancy.html Non Governmental Organization 10 3208 Endangered Habitats Conservancy 77 Non Profit 6 Non Profit - Conservation 12   San Diego 4 2.548 Palmer Property 0 Private Conservation 16 2
799 798 {"type": "MultiPolygon", "coordinates": [[[[-122.49991, 37.92691], [-122.49942, 37.92654], [-122.49818, 37.92572], [-122.49764, 37.92506], [-122.49509, 37.9251], [-122.49504, 37.92293], [-122.49312, 37.92144], [-122.49266, 37.92106], [-122.49265, 37.92043], [-122.49443, 37.92114], [-122.4948, 37.92124], [-122.49531, 37.9213], [-122.49545, 37.92131], [-122.49582, 37.92128], [-122.49619, 37.92123], [-122.49656, 37.92115], [-122.49691, 37.92104], [-122.4973, 37.92089], [-122.49736, 37.92428], [-122.49981, 37.92613], [-122.49991, 37.92691]]], [[[-122.50704, 37.92484], [-122.50678, 37.92501], [-122.50662, 37.92499], [-122.50631, 37.92523], [-122.5058, 37.92533], [-122.50532, 37.92522], [-122.50562, 37.92509], [-122.50587, 37.92491], [-122.50632, 37.9244], [-122.50704, 37.92484]]]]} No Public Access 3 5189 Triangle Marsh 26529 3039 Marin Audubon Society 261 Non Profit 6 Non Profit - Conservation 12 http://www.marinaudubon.org Non Governmental Organization 10 3039 Marin Audubon Society 257 Non Profit 6 Non Profit - Conservation 12   Marin 23 33.876 Triangle Marsh 1999 Private Conservation 16 2
1753 1752 {"type": "Polygon", "coordinates": [[[-122.49925, 38.63647], [-122.49421, 38.63642], [-122.49417, 38.63271], [-122.48533, 38.63279], [-122.48527, 38.62564], [-122.47606, 38.62561], [-122.4761, 38.62202], [-122.48526, 38.62206], [-122.48527, 38.62563], [-122.48765, 38.62558], [-122.48985, 38.62546], [-122.49439, 38.62527], [-122.49434, 38.62156], [-122.49886, 38.62131], [-122.49897, 38.62494], [-122.49908, 38.62919], [-122.49915, 38.63266], [-122.49925, 38.63647]]]} No Public Access 3 13101 Cleary Reserve 17417 3011 California Biological Field Studies Association 420 Non Profit 6 Non Profit - Conservation 12   Non Governmental Organization 10 3011 California Biological Field Studies Association 414 Non Profit 6 Non Profit - Conservation 12   Napa 11 406.373 Cleary Reserve 0 Private Conservation 16 2
2004 2003 {"type": "Polygon", "coordinates": [[[-120.83864, 35.3316], [-120.83864, 35.33176], [-120.83843, 35.33176], [-120.83823, 35.33167], [-120.83823, 35.33139], [-120.83864, 35.3316]]]} Open Access 1 16907 Audubon Overlook 15703 3043 Morro Coast Audubon Society 468 Non Profit 6 Non Profit - Conservation 12 http://www.morrocoastaudubon.org/ Non Governmental Organization 10 3043 Morro Coast Audubon Society 461 Non Profit 6 Non Profit - Conservation 12   San Luis Obispo 1 0.256 Audubon Overlook 0 Private Conservation 16 2
2300 2299 {"type": "Polygon", "coordinates": [[[-119.71423, 34.41147], [-119.71286, 34.41261], [-119.71211, 34.41205], [-119.71252, 34.41167], [-119.71232, 34.41149], [-119.71267, 34.41116], [-119.7132, 34.41071], [-119.71401, 34.41104], [-119.71423, 34.41147]]]} Open Access 1 16932 Honda Valley Park - Community Environmental Council 20066 3015 Community Environmental Council 508 Non Profit 6 Non Profit - Conservation 12 http://www.communityenvironmentalcouncil.org/ Non Governmental Organization 10 3015 Community Environmental Council 500 Non Profit 6 Non Profit - Conservation 12   Santa Barbara 7 5.43 Honda Valley Park - Community Environmental Council 0 Private Conservation 16 2
2385 2384 {"type": "Polygon", "coordinates": [[[-122.74268, 38.6103], [-122.74242, 38.61029], [-122.74161, 38.61], [-122.74135, 38.60995], [-122.73955, 38.61012], [-122.73842, 38.61011], [-122.73808, 38.61007], [-122.73775, 38.60998], [-122.73673, 38.60997], [-122.73604, 38.61004], [-122.73532, 38.61026], [-122.73491, 38.61034], [-122.73335, 38.61045], [-122.73331, 38.60526], [-122.72456, 38.60531], [-122.72434, 38.59791], [-122.71517, 38.59794], [-122.71495, 38.5906], [-122.71444, 38.59059], [-122.7058, 38.59066], [-122.70585, 38.59346], [-122.70432, 38.59338], [-122.68741, 38.59232], [-122.68714, 38.58312], [-122.6871, 38.5799], [-122.68205, 38.57987], [-122.68198, 38.57622], [-122.68195, 38.57621], [-122.68533, 38.5687], [-122.68239, 38.5686], [-122.6827, 38.5682], [-122.68357, 38.56783], [-122.68412, 38.56731], [-122.68409, 38.56653], [-122.68558, 38.56657], [-122.68554, 38.56517], [-122.68474, 38.56513], [-122.68492, 38.56472], [-122.68504, 38.5643], [-122.6852, 38.56389], [-122.68536, 38.56377], [-122.68547, 38.56372], [-122.6856, 38.5637], [-122.68607, 38.56373], [-122.68667, 38.56406], [-122.68689, 38.56413], [-122.68713, 38.56417], [-122.68815, 38.56406], [-122.68861, 38.56383], [-122.68874, 38.56379], [-122.6889, 38.56378], [-122.68897, 38.56378], [-122.68918, 38.56382], [-122.68951, 38.56398], [-122.6897, 38.56404], [-122.68994, 38.56402], [-122.69011, 38.56392], [-122.69068, 38.56333], [-122.69093, 38.56333], [-122.69112, 38.56348], [-122.69156, 38.56498], [-122.69206, 38.56576], [-122.69608, 38.56522], [-122.69608, 38.56871], [-122.7053, 38.56865], [-122.70533, 38.5651], [-122.70999, 38.56509], [-122.71014, 38.56896], [-122.71472, 38.56889], [-122.71925, 38.56899], [-122.72432, 38.56892], [-122.72879, 38.56905], [-122.72835, 38.56607], [-122.72834, 38.56531], [-122.73546, 38.56532], [-122.73557, 38.56536], [-122.73753, 38.56535], [-122.73778, 38.57276], [-122.72902, 38.5727], [-122.72924, 38.57622], [-122.72634, 38.5762], [-122.71941, 38.5762], [-122.71936, 38.58299], [-122.71959, 38.59056], [-122.73326, 38.59051], [-122.73326, 38.59283], [-122.73294, 38.59325], [-122.73199, 38.594], [-122.73151, 38.59417], [-122.73152, 38.59418], [-122.73326, 38.59416], [-122.73335, 38.59992], [-122.7341, 38.60016], [-122.73457, 38.60039], [-122.73503, 38.60145], [-122.74256, 38.60159], [-122.74265, 38.60433], [-122.74268, 38.6103]]]} Restricted Access 2 18604 Pepperwood Ranch Natural Preserve 23601 3010 California Academy of Sciences 522 Non Profit 6 Non Profit - Conservation 12 http://www.calacademy.org/ Non Governmental Organization 10 3010 California Academy of Sciences 515 Non Profit 6 Non Profit - Conservation 12   Sonoma 16 3045.466 Pepperwood Ranch Natural Preserve 0 Private Conservation 16 2
2539 2538 {"type": "Polygon", "coordinates": [[[-118.6218, 34.10061], [-118.62167, 34.10067], [-118.6216, 34.10059], [-118.62174, 34.10053], [-118.6218, 34.10061]]]} No Public Access 3 12510 Mountains Restoration Trust Parkland 29660 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 0.038 Mtns. Restoration Trust Parkland 0 Private Recreation or Education 65 4
2577 2576 {"type": "Polygon", "coordinates": [[[-118.61509, 34.08307], [-118.61508, 34.08325], [-118.61399, 34.08325], [-118.61398, 34.08307], [-118.61509, 34.08307]]]} No Public Access 3 12513 Mountains Restoration Trust Parkland 29660 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 0.501 Mtns. Restoration Trust Parkland 0 Private Recreation or Education 65 4
2800 2799 {"type": "Polygon", "coordinates": [[[-118.62165, 34.10163], [-118.62148, 34.10166], [-118.62143, 34.10159], [-118.62157, 34.10153], [-118.62165, 34.10163]]]} No Public Access 3 12515 Mountains Restoration Trust Parkland 29660 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 0.042 Mtns. Restoration Trust Parkland 0 Private Recreation or Education 65 4
2838 2837 {"type": "Polygon", "coordinates": [[[-121.93421, 36.60999], [-121.93184, 36.60975], [-121.932, 36.60951], [-121.93212, 36.60925], [-121.93222, 36.60897], [-121.93226, 36.6088], [-121.93229, 36.60854], [-121.93229, 36.60833], [-121.93227, 36.60812], [-121.93222, 36.60787], [-121.93214, 36.60765], [-121.93203, 36.60742], [-121.9319, 36.60721], [-121.93327, 36.60681], [-121.93327, 36.60718], [-121.9333, 36.60759], [-121.9334, 36.60812], [-121.9335, 36.60851], [-121.93372, 36.60916], [-121.93395, 36.60967], [-121.93405, 36.60983], [-121.93421, 36.60999]]]} Open Access 1 65 Rip Van Winkle Open Space 24395 3016 Del Monte Forest Foundation 559 Non Profit 6 Non Profit - Conservation 12 http://www.delmonteforestfoundation.org/ Non Governmental Organization 10 3016 Del Monte Forest Foundation 552 Non Profit 6 Non Profit - Conservation 12   Monterey 14 9.948 Rip Van Winkle OS 0 Private Recreation or Education 65 4
3308 3307 {"type": "Polygon", "coordinates": [[[-116.87605, 32.81198], [-116.87602, 32.81296], [-116.87303, 32.81508], [-116.87286, 32.81473], [-116.87304, 32.8145], [-116.87303, 32.81413], [-116.87289, 32.81331], [-116.87318, 32.8132], [-116.87335, 32.81308], [-116.87345, 32.81299], [-116.87353, 32.81288], [-116.87364, 32.81257], [-116.87401, 32.81237], [-116.87427, 32.81228], [-116.87453, 32.81222], [-116.87555, 32.8121], [-116.8758, 32.81205], [-116.87605, 32.81198]]]} No Public Access 3 46828 La Cresta Hills Property 30296 3208 Endangered Habitats Conservancy 79 Non Profit 6 Non Profit - Conservation 12 http://www.ehleague.org/EndangeredHabitatsConservancy.html Non Governmental Organization 10 3208 Endangered Habitats Conservancy 77 Non Profit 6 Non Profit - Conservation 12   San Diego 4 12.874 La Cresta Hills Property 0 Private Conservation 16 2
3309 3308 {"type": "Polygon", "coordinates": [[[-116.86574, 32.79365], [-116.86293, 32.79371], [-116.86299, 32.79622], [-116.86104, 32.79623], [-116.861, 32.79604], [-116.85956, 32.79629], [-116.85947, 32.79387], [-116.85842, 32.79388], [-116.85828, 32.78993], [-116.86564, 32.79012], [-116.86574, 32.79365]]]} No Public Access 3 46829 Michelson Property 30297 3208 Endangered Habitats Conservancy 79 Non Profit 6 Non Profit - Conservation 12 http://www.ehleague.org/EndangeredHabitatsConservancy.html Non Governmental Organization 10 3208 Endangered Habitats Conservancy 77 Non Profit 6 Non Profit - Conservation 12   San Diego 4 91.593 Michelson Property 0 Private Conservation 16 2
3313 3312 {"type": "Polygon", "coordinates": [[[-116.86309, 32.80074], [-116.86305, 32.80446], [-116.86307, 32.8054], [-116.85868, 32.80542], [-116.85866, 32.80438], [-116.85442, 32.80443], [-116.85445, 32.80069], [-116.85863, 32.80069], [-116.86309, 32.80074]]]} No Public Access 3 46834 Ulrich Property 30302 3208 Endangered Habitats Conservancy 79 Non Profit 6 Non Profit - Conservation 12 http://www.ehleague.org/EndangeredHabitatsConservancy.html Non Governmental Organization 10 3208 Endangered Habitats Conservancy 77 Non Profit 6 Non Profit - Conservation 12   San Diego 4 93.312 Ulrich Property 0 Private Conservation 16 2
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
3330 3329 {"type": "Polygon", "coordinates": [[[-121.0785, 39.19346], [-121.07797, 39.19474], [-121.07782, 39.19448], [-121.07764, 39.19438], [-121.07745, 39.19437], [-121.07724, 39.19444], [-121.0769, 39.1947], [-121.07627, 39.19509], [-121.07598, 39.19532], [-121.07588, 39.19546], [-121.07579, 39.19565], [-121.07568, 39.19577], [-121.07545, 39.19579], [-121.07529, 39.19574], [-121.07508, 39.19559], [-121.0751, 39.19488], [-121.07484, 39.19487], [-121.07481, 39.19483], [-121.07424, 39.19459], [-121.07408, 39.19416], [-121.07455, 39.19399], [-121.07504, 39.19412], [-121.07624, 39.19359], [-121.07686, 39.19277], [-121.07724, 39.19273], [-121.07836, 39.19326], [-121.0783, 39.19339], [-121.0785, 39.19346]]]} Restricted Access 2 29748 North Star House 31042 3376 North Star Historic Conservancy 619 Non Profit 6 Non Profit - Conservation 12 http://thenorthstarhouse.org/ Non Governmental Organization 10 3376 North Star Historic Conservancy 608 Non Profit 6 Non Profit - Conservation 12 http://thenorthstarhouse.org/ Nevada 30 14.16 North Star House 0 Private Conservation 16 2
3511 3510 {"type": "Polygon", "coordinates": [[[-118.29463, 35.66527], [-118.29017, 35.6658], [-118.29016, 35.66338], [-118.29462, 35.66337], [-118.29463, 35.66527]]]} Unknown Access 4 36102 National Audubon Society 4 22654 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   Kern 36 23.993 Nat. Audubon Society 4 0 Private Conservation 16 2
3739 3738 {"type": "Polygon", "coordinates": [[[-122.53527, 38.06893], [-122.5352, 38.06916], [-122.53501, 38.06911], [-122.53442, 38.06923], [-122.53406, 38.06927], [-122.53308, 38.06944], [-122.53252, 38.06952], [-122.53229, 38.06957], [-122.53239, 38.06949], [-122.53251, 38.06943], [-122.5325, 38.06937], [-122.53297, 38.06927], [-122.53439, 38.06908], [-122.53527, 38.06893]]]} No Public Access 3 31028 Marin Audubon Society 21815 3039 Marin Audubon Society 261 Non Profit 6 Non Profit - Conservation 12 http://www.marinaudubon.org Non Governmental Organization 10 3039 Marin Audubon Society 257 Non Profit 6 Non Profit - Conservation 12   Marin 23 1.098 Marin Audubon Society 0 Private Conservation 16 2
3921 3920 {"type": "MultiPolygon", "coordinates": [[[[-118.2043, 35.49494], [-118.20434, 35.49511], [-118.20436, 35.49526], [-118.20435, 35.49577], [-118.20437, 35.49604], [-118.20442, 35.49637], [-118.20441, 35.49673], [-118.20436, 35.49698], [-118.20421, 35.49746], [-118.20412, 35.49806], [-118.20399, 35.49875], [-118.2038, 35.49939], [-118.20377, 35.49962], [-118.20377, 35.50008], [-118.20385, 35.50087], [-118.20408, 35.50174], [-118.20407, 35.50194], [-118.20403, 35.50207], [-118.20398, 35.50216], [-118.20123, 35.50216], [-118.20127, 35.49494], [-118.2043, 35.49494]]], [[[-118.2101, 35.50219], [-118.2042, 35.50216], [-118.20427, 35.50197], [-118.20428, 35.50175], [-118.20425, 35.50159], [-118.20405, 35.50084], [-118.20397, 35.50008], [-118.20397, 35.49964], [-118.20401, 35.4994], [-118.20419, 35.49878], [-118.20432, 35.49808], [-118.20441, 35.49748], [-118.20456, 35.49699], [-118.20461, 35.49672], [-118.20462, 35.4964], [-118.20457, 35.49599], [-118.20455, 35.49569], [-118.20456, 35.49526], [-118.2045, 35.49494], [-118.2101, 35.49494], [-118.2101, 35.50219]]]]} Unknown Access 4 36100 National Audubon Society 5 22655 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   Kern 36 155.643 Nat. Audubon Society 5 0 Private Conservation 16 2
4024 4023 {"type": "Polygon", "coordinates": [[[-119.29637, 34.28467], [-119.29622, 34.28505], [-119.29605, 34.2852], [-119.29592, 34.28522], [-119.29579, 34.28522], [-119.29576, 34.28518], [-119.29569, 34.28521], [-119.29557, 34.28515], [-119.29543, 34.28497], [-119.29559, 34.28481], [-119.29613, 34.2845], [-119.29628, 34.28453], [-119.29637, 34.28467]]]} Open Access 1 46895 Serra Cross Park 30394 3369 San Buenaventura Heritage 711 Non Profit 6 Non Profit - Other 22 http://dudleyhouse.org/ Non Governmental Organization 10 3370 Serra Cross Conservancy 696 Non Profit 6 Non Profit - Conservation 12   Ventura 8 1.051 Serra Cross Park 0 Private Recreation or Education 65 4
4108 4107 {"type": "Polygon", "coordinates": [[[-123.7877, 39.63706], [-123.78765, 39.63715], [-123.78756, 39.63709], [-123.78747, 39.63706], [-123.78742, 39.637], [-123.78734, 39.63695], [-123.78728, 39.63696], [-123.78707, 39.63694], [-123.78693, 39.63696], [-123.78677, 39.63716], [-123.7867, 39.63731], [-123.78664, 39.63756], [-123.78663, 39.63766], [-123.78665, 39.63786], [-123.78672, 39.63793], [-123.78675, 39.63799], [-123.78679, 39.63805], [-123.78703, 39.63809], [-123.78709, 39.63817], [-123.78709, 39.63824], [-123.78705, 39.63828], [-123.78701, 39.6383], [-123.78677, 39.63832], [-123.78672, 39.63838], [-123.78583, 39.63835], [-123.78581, 39.63823], [-123.78569, 39.63822], [-123.78568, 39.63835], [-123.78539, 39.63835], [-123.78536, 39.6379], [-123.785, 39.63789], [-123.78502, 39.63729], [-123.785, 39.63673], [-123.78517, 39.63673], [-123.78518, 39.63661], [-123.78502, 39.63659], [-123.785, 39.63648], [-123.7852, 39.63649], [-123.78521, 39.63616], [-123.785, 39.63614], [-123.785, 39.63607], [-123.78515, 39.63606], [-123.78514, 39.63598], [-123.785, 39.63598], [-123.78501, 39.6358], [-123.78536, 39.6358], [-123.78538, 39.63565], [-123.78636, 39.63564], [-123.78647, 39.63567], [-123.78654, 39.63571], [-123.78654, 39.63579], [-123.7865, 39.63582], [-123.78642, 39.63586], [-123.78625, 39.63582], [-123.78619, 39.63582], [-123.78615, 39.63585], [-123.78613, 39.6359], [-123.78613, 39.63594], [-123.78616, 39.636], [-123.7862, 39.63604], [-123.78636, 39.63606], [-123.78643, 39.63609], [-123.78645, 39.63618], [-123.78636, 39.63628], [-123.78634, 39.63634], [-123.78636, 39.63639], [-123.78656, 39.63645], [-123.78683, 39.63661], [-123.78692, 39.63669], [-123.78707, 39.63669], [-123.78713, 39.63662], [-123.78723, 39.63664], [-123.78731, 39.63668], [-123.78739, 39.63676], [-123.78757, 39.63684], [-123.78764, 39.6369], [-123.78769, 39.63698], [-123.7877, 39.63706]]]} Open Access 1 47070 Westport Headlands Park 30721 3375 Westport Village Society 722 Non Profit 6 Non Profit - Conservation 12 http://www.westportvillagesociety.org/ Non Governmental Organization 10 3375 Westport Village Society 707 Non Profit 6 Non Profit - Conservation 12   Mendocino 24 10.269 Westport Headlands Park 0 Private Recreation or Education 65 4

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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]);
Powered by Datasette · Query took 110.719ms · Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette