superunits_with_maps

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

9 rows where MNG_AG_TYP = 19

View and edit SQL

Suggested facets: MNG_AG_ID, AGNCY_WEB

MNG_AG_TYP

  • Sanitation District · 9
Link rowid ▼ id map ACCESS_TYP PARK_NAME PARK_URL SUID_NMA MNG_AG_ID MNG_AGENCY MNG_AG_LEV MNG_AG_TYP AGNCY_WEB LAYER ACRES LABEL_NAME YR_EST
3718 3717 {"type": "Polygon", "coordinates": [[[-121.45299, 38.68181], [-121.45281, 38.68221], [-121.45251, 38.68275], [-121.45228, 38.68335], [-121.45227, 38.68342], [-121.45225, 38.68343], [-121.45223, 38.68375], [-121.45108, 38.68374], [-121.45108, 38.68204], [-121.45132, 38.68203], [-121.45168, 38.68135], [-121.45174, 38.68093], [-121.4516, 38.68023], [-121.45231, 38.68024], [-121.45268, 38.68058], [-121.45293, 38.68113], [-121.45299, 38.68181]]]} Open Access 1 Dry Creek Parkway   18284 2130 Sacramento Regional County Sanitation District 575 Special District 4 Sanitation District 19 http://www.srcsd.com/ Special District 4 10.997 Dry Creek Parkway  
5107 5106 {"type": "MultiPolygon", "coordinates": [[[[-121.88803, 36.96112], [-121.88733, 36.96103], [-121.88667, 36.96038], [-121.88723, 36.95904], [-121.88785, 36.95921], [-121.88767, 36.95954], [-121.88759, 36.96033], [-121.88751, 36.9606], [-121.88803, 36.96112]]], [[[-121.88834, 36.95777], [-121.88826, 36.95785], [-121.88803, 36.95793], [-121.88785, 36.95843], [-121.88779, 36.95806], [-121.88824, 36.95754], [-121.88834, 36.95777]]]]} Open Access 1 Hidden Beach Park - Aptos Sanitation District   19903 2002 Aptos Sanitation District 903 Special District 4 Sanitation District 19 http://www.dpw.co.santa-cruz.ca.us/Sanitation.htm Special District 4 3.727 Hidden Beach Park - Aptos Sanitation District  
5108 5107 {"type": "Polygon", "coordinates": [[[-121.88826, 36.95785], [-121.88809, 36.95809], [-121.88786, 36.95841], [-121.88803, 36.95793], [-121.88826, 36.95785]]]} Open Access 1 Hidden Beach Park - SCCSD   19904 2144 Santa Cruz County Sanitation District 904 Special District 4 Sanitation District 19 http://www.dpw.co.santa-cruz.ca.us/Sanitation.htm#SCCSD Special District 4 0.121 Hidden Beach Park - SCCSD  
7046 7045 {"type": "Polygon", "coordinates": [[[-118.39025, 33.81526], [-118.39021, 33.81551], [-118.3901, 33.81537], [-118.38993, 33.81522], [-118.39025, 33.81526]]]} Open Access 1 Miramar Park   22287 2158 South Bay Cities Sanitation District 449 Special District 4 Sanitation District 19 http://www.lacsd.org/ Special District 4 0.094 Miramar Park  
7526 7525 {"type": "Polygon", "coordinates": [[[-122.53356, 38.09886], [-122.5254, 38.1064], [-122.52385, 38.10609], [-122.5231, 38.10599], [-122.52262, 38.10554], [-122.52248, 38.10589], [-122.52024, 38.10565], [-122.51913, 38.10483], [-122.51863, 38.10463], [-122.51506, 38.105], [-122.51432, 38.1048], [-122.51589, 38.10354], [-122.51507, 38.10281], [-122.52095, 38.09844], [-122.52137, 38.09802], [-122.52779, 38.09313], [-122.52815, 38.09311], [-122.52832, 38.09329], [-122.52796, 38.09336], [-122.52796, 38.09339], [-122.53314, 38.0984], [-122.53316, 38.0984], [-122.53354, 38.09796], [-122.53354, 38.09884], [-122.53356, 38.09886]]]} Restricted Access 2 Novato Sanitation District   22930 2097 Novato Sanitary District 921 Special District 4 Sanitation District 19 http://www.novatosan.com/ Special District 4 303.013 Novato Sanitation District 1925
9102 9101 {"type": "MultiPolygon", "coordinates": [[[[-121.46051, 38.46182], [-121.46014, 38.46182], [-121.45754, 38.46232], [-121.451, 38.46543], [-121.44687, 38.46343], [-121.44679, 38.46343], [-121.44671, 38.46232], [-121.44678, 38.46228], [-121.44675, 38.46187], [-121.44667, 38.46183], [-121.44656, 38.46034], [-121.44647, 38.45963], [-121.44654, 38.45958], [-121.44634, 38.4585], [-121.44731, 38.45854], [-121.44732, 38.45853], [-121.44716, 38.45731], [-121.44712, 38.45725], [-121.44609, 38.45726], [-121.44533, 38.45341], [-121.44515, 38.45268], [-121.44508, 38.45233], [-121.44497, 38.45132], [-121.44491, 38.45055], [-121.44486, 38.44945], [-121.44483, 38.44862], [-121.44483, 38.44779], [-121.44485, 38.44644], [-121.44484, 38.44534], [-121.44485, 38.44461], [-121.44489, 38.44394], [-121.44501, 38.44291], [-121.44499, 38.4429], [-121.44517, 38.44141], [-121.44555, 38.43957], [-121.44572, 38.43865], [-121.44619, 38.43587], [-121.44687, 38.43587], [-121.44693, 38.43561], [-121.44692, 38.4356], [-121.44624, 38.4356], [-121.44644, 38.43438], [-121.44647, 38.43433], [-121.44652, 38.43432], [-121.44714, 38.43432], [-121.45009, 38.43424], [-121.45691, 38.43426], [-121.45731, 38.43767], [-121.45766, 38.43769], [-121.45852, 38.44496], [-121.4587, 38.44501], [-121.46046, 38.46011], [-121.46029, 38.46014], [-121.46051, 38.46182]]], [[[-121.49294, 38.45629], [-121.49214, 38.45647], [-121.49218, 38.45685], [-121.48371, 38.45792], [-121.48343, 38.458], [-121.48326, 38.45807], [-121.48306, 38.45818], [-121.48181, 38.45908], [-121.48117, 38.4597], [-121.48029, 38.46047], [-121.47972, 38.46077], [-121.47927, 38.46099], [-121.47857, 38.46131], [-121.47809, 38.4615], [-121.4773, 38.46178], [-121.47655, 38.46201], [-121.47578, 38.46221], [-121.47474, 38.46243], [-121.47395, 38.46255], [-121.47315, 38.46264], [-121.47235, 38.4627], [-121.47144, 38.46274], [-121.47143, 38.46429], [-121.4643, 38.46431], [-121.46151, 38.46356], [-121.46101, 38.46009], [-121.46083, 38.46009], [-121.46067, 38.45882], [-121.46014, 38.45435], [-121.46031, 38.45435], [-121.46032, 38.45433], [-121.46011, 38.45253], [-121.46413, 38.45261], [-121.46411, 38.45613], [-121.46412, 38.45633], [-121.46844, 38.45634], [-121.46919, 38.45272], [-121.48258, 38.4528], [-121.48262, 38.4513], [-121.48259, 38.44599], [-121.48252, 38.44596], [-121.48224, 38.44051], [-121.48216, 38.4305], [-121.48752, 38.43049], [-121.48757, 38.43081], [-121.48791, 38.43225], [-121.48817, 38.43318], [-121.48917, 38.4378], [-121.48926, 38.43825], [-121.48937, 38.43911], [-121.48969, 38.43942], [-121.48989, 38.44033], [-121.48966, 38.4405], [-121.49012, 38.44225], [-121.49034, 38.44324], [-121.49017, 38.44322], [-121.49016, 38.44323], [-121.49158, 38.44986], [-121.49215, 38.45374], [-121.49229, 38.4543], [-121.49294, 38.45629]], [[-121.47786, 38.45972], [-121.47804, 38.4597], [-121.47775, 38.45842], [-121.47715, 38.45873], [-121.47632, 38.45909], [-121.47548, 38.45943], [-121.47461, 38.45973], [-121.46444, 38.45973], [-121.46441, 38.46016], [-121.46442, 38.46017], [-121.47461, 38.46018], [-121.47488, 38.46014], [-121.47516, 38.46007], [-121.47552, 38.45992], [-121.47596, 38.45972], [-121.47786, 38.45972]], [[-121.48046, 38.45628], [-121.48046, 38.45626], [-121.47734, 38.45634], [-121.47776, 38.45835], [-121.4782, 38.45812], [-121.4792, 38.45741], [-121.48046, 38.45628]]]]} Restricted Access 2 Sacramento Regional County Sanitation District   24767 2130 Sacramento Regional County Sanitation District 575 Special District 4 Sanitation District 19 http://www.srcsd.com/ Special District 4 1914.738 Sacramento Reg. County Sanitation District  
11295 11294 {"type": "Polygon", "coordinates": [[[-118.28281, 33.79807], [-118.28277, 33.79811], [-118.28159, 33.79818], [-118.28109, 33.7982], [-118.28103, 33.79816], [-118.28044, 33.79421], [-118.28048, 33.79417], [-118.28222, 33.79408], [-118.28227, 33.79411], [-118.28264, 33.79654], [-118.28281, 33.79807]]]} Open Access 1 Wilmington Athletic Complex   27597 2139 Sanitation Districts of Los Angeles County 490 Special District 4 Sanitation District 19 http://www.lacsd.org/ Special District 4 18.852 Wilmington Athletic Complex  
12094 12093 {"type": "Polygon", "coordinates": [[[-118.34876, 33.79283], [-118.34853, 33.79307], [-118.3421, 33.78766], [-118.34362, 33.78659], [-118.34783, 33.79015], [-118.34783, 33.79205], [-118.34876, 33.79283]]]} No Public Access 3 South Coast Park/former Palos Verdes Landfill site http://www.lacsd.org/solidwaste/swfacilities/landfills/palos_verdes/ 29032 2139 Sanitation Districts of Los Angeles County 490 Special District 4 Sanitation District 19 http://www.lacsd.org/ Special District 4 30.501 South Coast Park/former Palos Verdes Landfill site  
14809 14808 {"type": "MultiPolygon", "coordinates": [[[[-118.54153, 34.1232], [-118.54026, 34.1238], [-118.53947, 34.12475], [-118.53884, 34.12578], [-118.53848, 34.12649], [-118.53809, 34.12682], [-118.53673, 34.12774], [-118.53504, 34.12779], [-118.53397, 34.12799], [-118.53231, 34.12799], [-118.53153, 34.12835], [-118.53087, 34.12893], [-118.5307, 34.12926], [-118.52867, 34.12888], [-118.52827, 34.12871], [-118.52785, 34.12858], [-118.52733, 34.12846], [-118.52678, 34.12839], [-118.5262, 34.12835], [-118.52558, 34.12836], [-118.52547, 34.12833], [-118.52528, 34.12834], [-118.52487, 34.12783], [-118.52486, 34.12745], [-118.52448, 34.12688], [-118.52452, 34.12654], [-118.52438, 34.12622], [-118.52443, 34.12596], [-118.5246, 34.12563], [-118.52497, 34.12551], [-118.52529, 34.12499], [-118.52577, 34.1243], [-118.52602, 34.12352], [-118.52583, 34.12319], [-118.52555, 34.1229], [-118.52533, 34.12243], [-118.52513, 34.1221], [-118.52512, 34.12192], [-118.525, 34.12175], [-118.52495, 34.12106], [-118.52483, 34.12038], [-118.52459, 34.12006], [-118.52444, 34.11978], [-118.52436, 34.11978], [-118.52404, 34.11946], [-118.52389, 34.11924], [-118.52385, 34.11913], [-118.52388, 34.11883], [-118.52386, 34.1187], [-118.52379, 34.1186], [-118.52326, 34.11819], [-118.52298, 34.1178], [-118.5229, 34.11762], [-118.52259, 34.11719], [-118.52244, 34.11708], [-118.52231, 34.11703], [-118.52199, 34.11697], [-118.5218, 34.11686], [-118.5215, 34.11663], [-118.52139, 34.11649], [-118.52115, 34.116], [-118.52109, 34.11574], [-118.52117, 34.11526], [-118.52104, 34.11472], [-118.52105, 34.11422], [-118.52094, 34.11377], [-118.52095, 34.11366], [-118.5212, 34.11293], [-118.52119, 34.11266], [-118.52108, 34.11242], [-118.52073, 34.11204], [-118.52051, 34.1117], [-118.52048, 34.11156], [-118.52057, 34.11099], [-118.52077, 34.11059], [-118.52079, 34.11045], [-118.52066, 34.11004], [-118.52062, 34.10981], [-118.52065, 34.10967], [-118.52077, 34.10944], [-118.5211, 34.10702], [-118.52116, 34.10626], [-118.52127, 34.10578], [-118.52132, 34.10547], [-118.52147, 34.10502], [-118.52158, 34.10432], [-118.52152, 34.10394], [-118.52143, 34.10359], [-118.5215, 34.10304], [-118.52146, 34.1019], [-118.52134, 34.10163], [-118.52083, 34.10088], [-118.52077, 34.10063], [-118.52065, 34.09978], [-118.52053, 34.09947], [-118.52019, 34.0991], [-118.51992, 34.0986], [-118.51983, 34.09834], [-118.51979, 34.09795], [-118.5195, 34.09757], [-118.51936, 34.09706], [-118.51927, 34.0965], [-118.51931, 34.09594], [-118.51949, 34.0953], [-118.51944, 34.09493], [-118.51934, 34.09458], [-118.51949, 34.09428], [-118.51953, 34.09399], [-118.51942, 34.09353], [-118.51949, 34.09274], [-118.51933, 34.09219], [-118.51936, 34.09197], [-118.5195, 34.0917], [-118.51953, 34.09151], [-118.51948, 34.09133], [-118.5192, 34.0909], [-118.51929, 34.09069], [-118.51941, 34.09055], [-118.51947, 34.09039], [-118.51947, 34.09013], [-118.51901, 34.08979], [-118.51903, 34.08951], [-118.51924, 34.08904], [-118.51924, 34.08888], [-118.51918, 34.08873], [-118.51875, 34.08827], [-118.51834, 34.08776], [-118.51812, 34.08712], [-118.51781, 34.08667], [-118.51777, 34.08652], [-118.5178, 34.08632], [-118.51768, 34.08581], [-118.5176, 34.0852], [-118.51748, 34.08502], [-118.51732, 34.08487], [-118.51681, 34.08455], [-118.51664, 34.0841], [-118.51655, 34.08285], [-118.51647, 34.08268], [-118.51631, 34.08252], [-118.51568, 34.08215], [-118.51477, 34.0819], [-118.51356, 34.08106], [-118.51607, 34.08105], [-118.51671, 34.0812], [-118.51683, 34.08124], [-118.51699, 34.08133], [-118.51716, 34.08146], [-118.51731, 34.08166], [-118.51738, 34.08182], [-118.51745, 34.08214], [-118.51749, 34.08224], [-118.51757, 34.08233], [-118.51767, 34.0824], [-118.51791, 34.08252], [-118.51802, 34.08259], [-118.51811, 34.08268], [-118.51825, 34.08289], [-118.51835, 34.08297], [-118.51962, 34.08355], [-118.51972, 34.08361], [-118.51976, 34.08366], [-118.51983, 34.08378], [-118.51981, 34.08417], [-118.51988, 34.0843], [-118.51995, 34.08436], [-118.5208, 34.08478], [-118.52097, 34.08481], [-118.52165, 34.08482], [-118.52181, 34.08486], [-118.52195, 34.08492], [-118.5221, 34.08503], [-118.52216, 34.0851], [-118.52237, 34.08544], [-118.52232, 34.08548], [-118.52259, 34.0859], [-118.52269, 34.086], [-118.52284, 34.08611], [-118.523, 34.0862], [-118.52355, 34.08637], [-118.52365, 34.08643], [-118.52405, 34.08675], [-118.52419, 34.08683], [-118.52433, 34.08689], [-118.5245, 34.08693], [-118.52465, 34.08695], [-118.5251, 34.08696], [-118.52523, 34.087], [-118.52535, 34.08707], [-118.52671, 34.08852], [-118.52678, 34.08866], [-118.52729, 34.08995], [-118.5273, 34.09003], [-118.52729, 34.09012], [-118.52717, 34.09046], [-118.52718, 34.09068], [-118.52724, 34.0908], [-118.52732, 34.0909], [-118.52765, 34.09119], [-118.5278, 34.09108], [-118.52787, 34.091], [-118.5279, 34.09092], [-118.5279, 34.09072], [-118.52793, 34.09062], [-118.528, 34.09053], [-118.52815, 34.09045], [-118.52828, 34.09043], [-118.52842, 34.09045], [-118.52896, 34.09069], [-118.52897, 34.09121], [-118.52892, 34.09168], [-118.52887, 34.09195], [-118.5288, 34.09223], [-118.52865, 34.09268], [-118.52828, 34.09362], [-118.52814, 34.09409], [-118.52808, 34.09438], [-118.52803, 34.09487], [-118.52791, 34.09676], [-118.52783, 34.09732], [-118.52774, 34.09773], [-118.52754, 34.09842], [-118.52713, 34.09953], [-118.52698, 34.10011], [-118.52693, 34.10062], [-118.52695, 34.10113], [-118.52701, 34.1015], [-118.52716, 34.10201], [-118.52738, 34.10249], [-118.52893, 34.10526], [-118.52913, 34.10565], [-118.5294, 34.10625], [-118.52956, 34.10666], [-118.52977, 34.10728], [-118.52996, 34.10793], [-118.53019, 34.10851], [-118.5304, 34.10892], [-118.5306, 34.10923], [-118.53077, 34.10946], [-118.53121, 34.10995], [-118.5315, 34.11021], [-118.53188, 34.11051], [-118.53239, 34.11084], [-118.53312, 34.1112], [-118.5348, 34.11185], [-118.53533, 34.1121], [-118.53574, 34.11235], [-118.53613, 34.11262], [-118.53648, 34.11293], [-118.53668, 34.11312], [-118.53698, 34.11346], [-118.53719, 34.11375], [-118.53742, 34.11412], [-118.53758, 34.11444], [-118.53852, 34.11695], [-118.5389, 34.11783], [-118.54004, 34.12028], [-118.54081, 34.1222], [-118.54095, 34.12247], [-118.54118, 34.12281], [-118.54153, 34.1232]]], [[[-118.5255, 34.12357], [-118.52531, 34.12414], [-118.52487, 34.12477], [-118.52461, 34.12519], [-118.52421, 34.12531], [-118.52396, 34.12584], [-118.52387, 34.12624], [-118.52401, 34.12659], [-118.52398, 34.12697], [-118.52436, 34.12757], [-118.52437, 34.12796], [-118.52471, 34.12839], [-118.52466, 34.12839], [-118.52453, 34.12833], [-118.52433, 34.12827], [-118.52261, 34.12799], [-118.52247, 34.12791], [-118.52224, 34.12781], [-118.52206, 34.12777], [-118.52239, 34.12474], [-118.52282, 34.12449], [-118.52367, 34.1244], [-118.52377, 34.12416], [-118.52274, 34.12369], [-118.51879, 34.12367], [-118.51934, 34.12629], [-118.52103, 34.1279], [-118.51927, 34.12865], [-118.51893, 34.12866], [-118.5182, 34.12866], [-118.51801, 34.12862], [-118.51779, 34.12863], [-118.51712, 34.12532], [-118.5168, 34.12193], [-118.51854, 34.1198], [-118.52392, 34.11979], [-118.52414, 34.12026], [-118.52436, 34.12053], [-118.52445, 34.1211], [-118.5245, 34.12188], [-118.52463, 34.12205], [-118.52464, 34.12222], [-118.52488, 34.12259], [-118.52512, 34.12311], [-118.52542, 34.12342], [-118.5255, 34.12357]]], [[[-118.55679, 34.10704], [-118.55662, 34.11055], [-118.55474, 34.11145], [-118.55425, 34.11209], [-118.55391, 34.11221], [-118.55376, 34.11282], [-118.55423, 34.11288], [-118.55435, 34.11342], [-118.55425, 34.11388], [-118.55395, 34.1143], [-118.55393, 34.11468], [-118.55381, 34.1149], [-118.5536, 34.11502], [-118.55367, 34.11525], [-118.55348, 34.11565], [-118.55323, 34.11584], [-118.55313, 34.11633], [-118.55303, 34.11654], [-118.55271, 34.11667], [-118.55283, 34.11694], [-118.55249, 34.1176], [-118.55219, 34.11789], [-118.55169, 34.11794], [-118.55192, 34.11875], [-118.55186, 34.11885], [-118.55132, 34.11909], [-118.55172, 34.11963], [-118.55134, 34.12014], [-118.55127, 34.12062], [-118.55074, 34.12086], [-118.54197, 34.11798], [-118.54135, 34.11834], [-118.54306, 34.12125], [-118.54249, 34.12193], [-118.54211, 34.1227], [-118.54175, 34.12305], [-118.54167, 34.12299], [-118.54137, 34.12266], [-118.54124, 34.12246], [-118.54106, 34.12212], [-118.54029, 34.1202], [-118.53915, 34.11775], [-118.53876, 34.11688], [-118.53786, 34.11444], [-118.53775, 34.11419], [-118.53747, 34.11372], [-118.53714, 34.11327], [-118.53682, 34.11291], [-118.53631, 34.11247], [-118.5359, 34.11218], [-118.53565, 34.11202], [-118.53512, 34.11174], [-118.53468, 34.11155], [-118.53315, 34.11097], [-118.53254, 34.11066], [-118.53237, 34.11056], [-118.53183, 34.11018], [-118.53135, 34.10975], [-118.53111, 34.10948], [-118.53083, 34.10912], [-118.53068, 34.1089], [-118.53044, 34.10844], [-118.53024, 34.10795], [-118.53003, 34.10722], [-118.52981, 34.10659], [-118.52965, 34.10618], [-118.52937, 34.10557], [-118.52916, 34.10517], [-118.52764, 34.10242], [-118.52762, 34.1024], [-118.52746, 34.10207], [-118.5273, 34.1016], [-118.52722, 34.10119], [-118.52719, 34.1007], [-118.52719, 34.10049], [-118.52725, 34.10007], [-118.52736, 34.09966], [-118.52788, 34.09821], [-118.528, 34.09778], [-118.52809, 34.09735], [-118.52817, 34.09677], [-118.5283, 34.0947], [-118.52834, 34.09442], [-118.52842, 34.09405], [-118.52857, 34.09358], [-118.52897, 34.09256], [-118.52913, 34.09196], [-118.52916, 34.09265], [-118.52867, 34.09367], [-118.52872, 34.09667], [-118.52948, 34.09797], [-118.52858, 34.09836], [-118.52846, 34.09896], [-118.5283, 34.09937], [-118.52862, 34.09971], [-118.52828, 34.10015], [-118.52759, 34.10139], [-118.52857, 34.1022], [-118.52885, 34.10259], [-118.52891, 34.10364], [-118.53015, 34.10507], [-118.53049, 34.10562], [-118.53051, 34.10625], [-118.53043, 34.10681], [-118.53085, 34.10814], [-118.53102, 34.10843], [-118.53135, 34.10885], [-118.53176, 34.10918], [-118.53318, 34.11016], [-118.53439, 34.11073], [-118.54135, 34.10781], [-118.55126, 34.10807], [-118.55255, 34.10749], [-118.55189, 34.10543], [-118.5532, 34.10513], [-118.55484, 34.10598], [-118.55541, 34.10586], [-118.55679, 34.10704]]]]} Open Access 1 L.A. County Sanitation District Open Space   11624 2139 Sanitation Districts of Los Angeles County 490 Special District 4 Sanitation District 19 http://www.lacsd.org/ Special District 4 1888.142 L.A. County Sanitation District OS  

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE superunits_with_maps(
  id INT,
  map,
  ACCESS_TYP INT,
  PARK_NAME TEXT,
  PARK_URL TEXT,
  SUID_NMA INT,
  MNG_AG_ID INT,
  MNG_AGENCY INT,
  MNG_AG_LEV INT,
  MNG_AG_TYP INT,
  AGNCY_WEB TEXT,
  LAYER INT,
  ACRES REAL,
  LABEL_NAME TEXT,
  YR_EST INT,
   FOREIGN KEY(ACCESS_TYP) REFERENCES ACCESS_TYP(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(LAYER) REFERENCES LAYER(id)
);
CREATE INDEX [idx_superunits_with_maps_LAYER]
                ON [superunits_with_maps] ([LAYER]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP]
                ON [superunits_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV]
                ON [superunits_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY]
                ON [superunits_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP]
                ON [superunits_with_maps] ([ACCESS_TYP]);
Powered by Datasette · Query took 43.132ms · Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette