units_with_maps

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

45 rows where MNG_AG_TYP = 20

View and edit SQL

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

MNG_AG_TYP

  • Non Profit - Other · 45
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
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
2489 2488 {"type": "Polygon", "coordinates": [[[-122.44958, 37.76633], [-122.44898, 37.76641], [-122.44881, 37.76647], [-122.44849, 37.76654], [-122.44848, 37.76657], [-122.44806, 37.76662], [-122.44802, 37.76642], [-122.44844, 37.76637], [-122.44846, 37.7664], [-122.44872, 37.76635], [-122.44892, 37.76627], [-122.44902, 37.7662], [-122.44899, 37.76602], [-122.4495, 37.76595], [-122.44958, 37.76633]]]} Open Access 1 48909 Richard Gamble Memorial Park 33627 1300 San Francisco, City and County of 21 City 2 City Agency 2 http://sfrecpark.org/ City 2 3308 San Francisco Parks Alliance 521 Non Profit 6 Non Profit - Other 20 https://www.sfparksalliance.org/our-parks/parks/gamble-memorial-park San Francisco 13 0.912 Richard Gamble Memorial Park   None 205  
3034 3033 {"type": "Polygon", "coordinates": [[[-122.39104, 37.75772], [-122.39035, 37.75777], [-122.39033, 37.7576], [-122.39101, 37.75756], [-122.39104, 37.75772]]]} Open Access 1 48833 Woods Yard 33552 1300 San Francisco, City and County of 21 City 2 City Agency 2 http://sfrecpark.org/ City 2 3308 San Francisco Parks Alliance 521 Non Profit 6 Non Profit - Other 20 https://www.sfparksalliance.org/our-parks/parks/woods-yard San Francisco 13 0.275 Woods Yard   None 249  
3397 3396 {"type": "Polygon", "coordinates": [[[-119.08951, 36.35464], [-119.08945, 36.35822], [-119.08502, 36.3582], [-119.08507, 36.35461], [-119.08951, 36.35464]]]} Open Access 1 35099 Hog Wallow Preserve 20024 3137 Tulare County Historical Society 636 Non Profit 6 Non Profit - Other 22 http://www.tularecountyhistoricalsociety.org/ Non Governmental Organization 10 3137 Tulare County Historical Society 625 Non Profit 6 Non Profit - Other 20   Tulare 29 39.16 Hog Wallow Preserve 0 Private Conservation 16 2
3568 3567 {"type": "Polygon", "coordinates": [[[-117.12444, 32.57552], [-117.12422, 32.57552], [-117.12425, 32.57652], [-117.12305, 32.57652], [-117.12307, 32.5737], [-117.12357, 32.57366], [-117.12388, 32.57374], [-117.12399, 32.57387], [-117.12401, 32.57408], [-117.12442, 32.57408], [-117.12444, 32.57552]]]} Open Access 1 439 Imperial Beach Sports Park 31474 1143 Imperial Beach, City of 630 City 2 City Agency 2 http://www.imperialbeachca.gov/index.asp?Type=B_BASIC&SEC={9F232DF8-5366-4BA2-A4B8-8795196F6D81} City 2 7018 Boys and Girls Clubs of South County 649 Non Profit 6 Non Profit - Other 20 http://www.bgcscounty.org/portal/home San Diego 4 8.985 Imperial Beach Sports Park   None 298  
3710 3709 {"type": "Polygon", "coordinates": [[[-117.12997, 34.00757], [-117.12565, 34.00736], [-117.12569, 34.01105], [-117.12135, 34.01083], [-117.12136, 34.0124], [-117.11672, 34.01318], [-117.11671, 34.01471], [-117.11253, 34.01494], [-117.11247, 34.01855], [-117.11191, 34.01851], [-117.1119, 34.01823], [-117.11177, 34.01822], [-117.1117, 34.01827], [-117.11153, 34.01825], [-117.11138, 34.01805], [-117.11128, 34.01822], [-117.11086, 34.01823], [-117.10962, 34.01775], [-117.10954, 34.01781], [-117.10954, 34.01786], [-117.10942, 34.01774], [-117.10934, 34.01772], [-117.10927, 34.01772], [-117.10918, 34.01753], [-117.10925, 34.01752], [-117.10915, 34.01654], [-117.10816, 34.01601], [-117.10719, 34.01448], [-117.10708, 34.0126], [-117.10573, 34.01116], [-117.10685, 34.01022], [-117.10756, 34.01071], [-117.11261, 34.01028], [-117.1126, 34.01067], [-117.11262, 34.01068], [-117.11494, 34.0093], [-117.1164, 34.00859], [-117.11749, 34.00742], [-117.11913, 34.0066], [-117.11913, 34.00658], [-117.11825, 34.00577], [-117.11884, 34.00524], [-117.11984, 34.00498], [-117.12059, 34.00429], [-117.12243, 34.00429], [-117.12244, 34.00434], [-117.12273, 34.00488], [-117.12362, 34.00456], [-117.12395, 34.00465], [-117.12397, 34.00461], [-117.12449, 34.00464], [-117.12498, 34.0043], [-117.12991, 34.0043], [-117.12997, 34.00757]]]} Open Access 1 48815 Live Oak Canyon Open Space 33535 1269 Redlands, City of 101 City 2 City Agency 2 http://www.cityofredlands.org/ City 2 3302 Redlands Conservancy 660 Non Profit 6 Non Profit - Other 20   San Bernardino 22 338.281 Live Oak Canyon OS   None 309  
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
4103 4102 {"type": "Polygon", "coordinates": [[[-120.13295, 34.59237], [-120.13291, 34.59524], [-120.12773, 34.5952], [-120.12768, 34.59802], [-120.12682, 34.59784], [-120.12694, 34.59711], [-120.12699, 34.59605], [-120.1268, 34.59601], [-120.12734, 34.59501], [-120.12845, 34.59417], [-120.12826, 34.59379], [-120.1283, 34.59233], [-120.13295, 34.59237]]]} Restricted Access 2 47041 Santa Ines Mission Mill 30693 204 California Department of Parks and Recreation 48 State 5 State Agency 5 http://www.parks.ca.gov/ California Department of Parks and Recreation 9 3372 Santa Barbara Trust for Historic Preservation 706 Non Profit 6 Non Profit - Other 20 http://www.sbthp.org/ Santa Barbara 7 40.009 Santa Ines Mission Mill   None 356  
4158 4157 {"type": "Polygon", "coordinates": [[[-118.26097, 33.95842], [-118.26096, 33.95916], [-118.26076, 33.95916], [-118.26076, 33.95842], [-118.26097, 33.95842]]]} Open Access 1 45111 WAYS Reading and Fitness Park 28122 3352 Heal the Bay 726 Non Profit 6 Non Profit - Other 22 http://www.healthebay.org/ Non Governmental Organization 10 3352 Heal the Bay 711 Non Profit 6 Non Profit - Other 20   Los Angeles 6 0.387 WAYS Reading and Fitness Park 0 Private Recreation or Education 65 4
4344 4343 {"type": "Polygon", "coordinates": [[[-122.27181, 38.09791], [-122.27075, 38.09848], [-122.27064, 38.0983], [-122.27039, 38.09693], [-122.26917, 38.09562], [-122.26946, 38.09542], [-122.26965, 38.09541], [-122.26971, 38.09524], [-122.26973, 38.09524], [-122.2697, 38.0956], [-122.27179, 38.09785], [-122.27181, 38.09791]]]} Open Access 1 45605 Mare Island Historic Park 31265 3379 Mare Island Historic Park Foundation 751 Non Profit 6 Non Profit - Other 22 http://www.mareislandhpf.org/ Non Governmental Organization 10 3379 Mare Island Historic Park Foundation 737 Non Profit 6 Non Profit - Other 20 http://www.mareislandhpf.org/index.html Solano 26 4.996 Mare Island Historic Park 0 Private Recreation or Education 65 4
4471 4470 {"type": "Polygon", "coordinates": [[[-116.62024, 32.8546], [-116.62023, 32.85532], [-116.61829, 32.85533], [-116.61829, 32.85491], [-116.618, 32.85491], [-116.61799, 32.85435], [-116.61875, 32.85434], [-116.61914, 32.85341], [-116.61924, 32.85343], [-116.6193, 32.85399], [-116.61991, 32.8542], [-116.6198, 32.85446], [-116.62024, 32.8546]]]} Restricted Access 2 1199 Unnamed site - Nonprofit Organization - Unknown 28649 3048 Nonprofit Organization - Unknown 765 Non Profit 6 Non Profit - Other 22   Non Governmental Organization 10 3048 Nonprofit Organization - Unknown 746 Non Profit 6 Non Profit - Other 20   San Diego 4 6.306   0 Private Other or Unknown 399 4
4472 4471 {"type": "Polygon", "coordinates": [[[-116.31558, 33.3251], [-116.31551, 33.33963], [-116.29816, 33.3395], [-116.29841, 33.32503], [-116.31558, 33.3251]]]} Restricted Access 2 1208 Unnamed site - Nonprofit Organization - Unknown 28649 3048 Nonprofit Organization - Unknown 765 Non Profit 6 Non Profit - Other 22   Non Governmental Organization 10 3048 Nonprofit Organization - Unknown 746 Non Profit 6 Non Profit - Other 20   San Diego 4 638.799   0 Private Other or Unknown 399 4
5042 5041 {"type": "MultiPolygon", "coordinates": [[[[-123.70756, 39.31534], [-123.70732, 39.32435], [-123.70281, 39.32434], [-123.70273, 39.3279], [-123.7025, 39.3425], [-123.69791, 39.34255], [-123.68153, 39.34249], [-123.68164, 39.3389], [-123.69333, 39.33887], [-123.69345, 39.33522], [-123.69803, 39.33521], [-123.69818, 39.32792], [-123.69856, 39.31365], [-123.70475, 39.31359], [-123.70436, 39.31314], [-123.70756, 39.31534]]], [[[-123.69822, 39.31365], [-123.69382, 39.31371], [-123.6938, 39.3109], [-123.69419, 39.31055], [-123.69429, 39.31043], [-123.69437, 39.31029], [-123.69446, 39.31008], [-123.69455, 39.30974], [-123.69464, 39.30901], [-123.69474, 39.30875], [-123.69489, 39.30843], [-123.69504, 39.30817], [-123.69517, 39.30802], [-123.69534, 39.30792], [-123.69559, 39.30783], [-123.69587, 39.30779], [-123.69613, 39.30778], [-123.69641, 39.30782], [-123.69686, 39.30795], [-123.69749, 39.30819], [-123.69783, 39.30836], [-123.6979, 39.30841], [-123.69794, 39.30848], [-123.69797, 39.30863], [-123.69798, 39.30885], [-123.69796, 39.30913], [-123.69789, 39.30968], [-123.69772, 39.31065], [-123.69747, 39.31136], [-123.69745, 39.31158], [-123.69749, 39.31212], [-123.69754, 39.31234], [-123.69771, 39.31269], [-123.69809, 39.31316], [-123.69821, 39.31328], [-123.69822, 39.31365]]]]} Open Access 1 45367 Mendocino Woodlands State Park 30663 204 California Department of Parks and Recreation 48 State 5 State Agency 5 http://www.parks.ca.gov/ California Department of Parks and Recreation 9 3373 Mendocino Woodlands Camp Association 772 Non Profit 6 Non Profit - Other 20 http://www.parks.ca.gov/?page_id=443 Mendocino 24 650.541 Mendocino Woodlands SP 1977 State Park 15 4
5266 5265 {"type": "Polygon", "coordinates": [[[-117.35459, 33.20901], [-117.35406, 33.21043], [-117.35407, 33.21045], [-117.35412, 33.21045], [-117.3539, 33.21053], [-117.35388, 33.21048], [-117.35389, 33.21042], [-117.35409, 33.20978], [-117.35417, 33.20964], [-117.35418, 33.20959], [-117.35417, 33.20953], [-117.35411, 33.20946], [-117.35404, 33.20943], [-117.35393, 33.20943], [-117.35337, 33.20918], [-117.35314, 33.20899], [-117.35395, 33.20875], [-117.35416, 33.20875], [-117.35447, 33.20877], [-117.35455, 33.20899], [-117.35459, 33.20901]]]} Open Access 1 949 North County Humane Society and SPCA Dog Park 29112 3361 San Diego Humane Society and SPCA 803 Non Profit 6 Non Profit - Other 22 http://www.sdhumane.org/ Non Governmental Organization 10 3361 San Diego Humane Society and SPCA 783 Non Profit 6 Non Profit - Other 20 http://www.ci.oceanside.ca.us/gov/ns/parks/amenities/dogpark.asp San Diego 4 2.32 North County Humane Society and SPCA Dog Park 0 Private Recreation or Education 65 4
5618 5617 {"type": "Polygon", "coordinates": [[[-122.89472, 38.47891], [-122.89472, 38.48002], [-122.8932, 38.47999], [-122.8932, 38.48027], [-122.89244, 38.48027], [-122.89245, 38.47815], [-122.89323, 38.47814], [-122.89322, 38.4789], [-122.89472, 38.47891]]]} No Public Access 3 29794 Forestville Park Development District-Land Bank 19000 3131 Forestville Park Development District 812 Non Profit 6 Non Profit - Other 22 http://www.forestvilleyouthpark.org/ Non Governmental Organization 10 3131 Forestville Park Development District 791 Non Profit 6 Non Profit - Other 20   Sonoma 16 7.924 Forestville Park Development District-Land Bank 0 Private Conservation 16 2
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
5982 5981 {"type": "MultiPolygon", "coordinates": [[[[-120.15031, 38.07513], [-120.15021, 38.0767], [-120.15017, 38.0788], [-120.1503, 38.07975], [-120.15007, 38.08129], [-120.14928, 38.08265], [-120.14892, 38.08205], [-120.14846, 38.08111], [-120.14743, 38.08057], [-120.14611, 38.08037], [-120.14582, 38.08042], [-120.14567, 38.08036], [-120.14566, 38.08026], [-120.14575, 38.0801], [-120.14657, 38.07944], [-120.14735, 38.07842], [-120.14738, 38.0774], [-120.14754, 38.0764], [-120.14785, 38.07644], [-120.14808, 38.07548], [-120.14814, 38.075], [-120.14814, 38.07479], [-120.14821, 38.07416], [-120.14982, 38.07453], [-120.15031, 38.07513]]], [[[-120.15315, 38.08292], [-120.15299, 38.08306], [-120.15302, 38.08341], [-120.15262, 38.08363], [-120.15246, 38.0834], [-120.15153, 38.08386], [-120.1512, 38.08408], [-120.15116, 38.08418], [-120.15116, 38.08431], [-120.15123, 38.08441], [-120.15098, 38.08462], [-120.15073, 38.08492], [-120.15035, 38.08507], [-120.15003, 38.08485], [-120.15022, 38.08462], [-120.14991, 38.08444], [-120.14965, 38.08382], [-120.14963, 38.0837], [-120.14974, 38.08333], [-120.14974, 38.08285], [-120.14939, 38.08282], [-120.14945, 38.08274], [-120.15032, 38.08131], [-120.15055, 38.0798], [-120.15088, 38.08009], [-120.15087, 38.08057], [-120.15094, 38.08099], [-120.15096, 38.08105], [-120.15148, 38.08155], [-120.15173, 38.08183], [-120.15218, 38.08213], [-120.15241, 38.08263], [-120.15255, 38.08268], [-120.15281, 38.08281], [-120.15315, 38.08292]]]]} Open Access 1 575 Odd Fellows High Sierra Park 23069 3050 Odd Fellows Sierra Recreation Association 821 Non Profit 6 Non Profit - Other 22 http://ofsraparkmgt.wix.com/home Non Governmental Organization 10 3050 Odd Fellows Sierra Recreation Association 799 Non Profit 6 Non Profit - Other 20   Tuolumne 21 69.024 Odd Fellows High Sierra Park 0 Private Recreation or Education 65 4
6150 6149 {"type": "Polygon", "coordinates": [[[-117.97651, 34.11555], [-117.97637, 34.11573], [-117.97627, 34.11571], [-117.97575, 34.11619], [-117.97526, 34.11658], [-117.97501, 34.11677], [-117.97438, 34.11716], [-117.97327, 34.11691], [-117.97332, 34.11662], [-117.97332, 34.11632], [-117.97327, 34.11607], [-117.9731, 34.11575], [-117.97295, 34.11554], [-117.97288, 34.1153], [-117.97216, 34.11418], [-117.97253, 34.11436], [-117.97307, 34.11458], [-117.97392, 34.11484], [-117.9745, 34.11498], [-117.9751, 34.11509], [-117.97581, 34.11516], [-117.97581, 34.11527], [-117.97631, 34.11528], [-117.97649, 34.11546], [-117.97651, 34.11555]]]} Open Access 1 48340 Kare Park 32904 100 United States Army Corps of Engineers 146 Federal 1 Federal Agency 1 http://www.usace.army.mil/ Other Federal 13 7025 Kare Youth League 808 Non Profit 6 Non Profit - Other 20 https://kyl.org/KarePark/ Los Angeles 6 14.769 Kare Park 2017 None 496  
6419 6418 {"type": "Polygon", "coordinates": [[[-122.03659, 37.24213], [-122.03656, 37.24226], [-122.03614, 37.24251], [-122.03601, 37.24284], [-122.03597, 37.24285], [-122.03584, 37.24307], [-122.03584, 37.24313], [-122.03565, 37.24361], [-122.03504, 37.24416], [-122.03482, 37.24449], [-122.03472, 37.24468], [-122.0349, 37.24502], [-122.03444, 37.24515], [-122.03294, 37.24597], [-122.0323, 37.24568], [-122.03164, 37.24542], [-122.03126, 37.24543], [-122.03128, 37.24541], [-122.03126, 37.24514], [-122.03074, 37.24452], [-122.03066, 37.24456], [-122.03116, 37.24517], [-122.03117, 37.24539], [-122.0311, 37.24547], [-122.03048, 37.24587], [-122.03042, 37.24594], [-122.03038, 37.24603], [-122.03035, 37.24666], [-122.02997, 37.24667], [-122.02985, 37.24671], [-122.02975, 37.24677], [-122.02876, 37.24793], [-122.02872, 37.24801], [-122.0287, 37.2481], [-122.02869, 37.2471], [-122.02818, 37.24671], [-122.0283, 37.24666], [-122.02852, 37.24611], [-122.02868, 37.24581], [-122.02884, 37.2456], [-122.02899, 37.24528], [-122.02865, 37.24516], [-122.02864, 37.2449], [-122.02885, 37.24453], [-122.029, 37.24436], [-122.02904, 37.24415], [-122.029, 37.24393], [-122.02906, 37.24286], [-122.02722, 37.24287], [-122.0271, 37.23559], [-122.03129, 37.23551], [-122.03137, 37.23925], [-122.03652, 37.23927], [-122.03612, 37.24107], [-122.03659, 37.24159], [-122.03652, 37.242], [-122.03659, 37.24213]]]} Open Access 1 1891 Villa Montalvo Arboretum 27101 3041 Montalvo Association 834 Non Profit 6 Non Profit - Other 22 http://montalvoarts.org/ Non Governmental Organization 10 3041 Montalvo Association 812 Non Profit 6 Non Profit - Other 20   Santa Clara 19 166.406 Villa Montalvo Arboretum 1939 Private Conservation 16 2
7209 7208 {"type": "Polygon", "coordinates": [[[-116.71662, 33.74341], [-116.71528, 33.74392], [-116.71542, 33.7442], [-116.71505, 33.74429], [-116.71457, 33.7435], [-116.71464, 33.7433], [-116.71463, 33.7428], [-116.71464, 33.74276], [-116.71524, 33.74258], [-116.71632, 33.74263], [-116.71627, 33.74276], [-116.71662, 33.74341]]]} Open Access 1 48431 Idyllwild Community Center 33128 3387 San Jacinto Mountain Community Center 852 Non Profit 6 Non Profit - Other 22 https://www.idyllwildcommunitycenter.org/faq Non Governmental Organization 10 3387 San Jacinto Mountain Community Center 831 Non Profit 6 Non Profit - Other 20 https://www.idyllwildcommunitycenter.org/faq Riverside 10 5.563 Idyllwild Community Ctr. 2019 Private Conservation 16 2

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 92.464ms · Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette