superunits_with_maps

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

15 rows where MNG_AG_TYP = 24

View and edit SQL

Suggested facets: MNG_AG_ID, AGNCY_WEB

MNG_AG_TYP

  • Special District - Other · 15

ACCESS_TYP

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
609 608 {"type": "MultiPolygon", "coordinates": [[[[-117.92633, 33.95169], [-117.92622, 33.9518], [-117.92621, 33.95185], [-117.92598, 33.95214], [-117.92521, 33.95305], [-117.923, 33.95593], [-117.92265, 33.95634], [-117.9225, 33.95639], [-117.92154, 33.95636], [-117.92414, 33.95009], [-117.92426, 33.95043], [-117.92458, 33.95062], [-117.9247, 33.95081], [-117.925, 33.95102], [-117.92517, 33.95146], [-117.92545, 33.95147], [-117.9257, 33.95159], [-117.92585, 33.95156], [-117.92597, 33.95157], [-117.92633, 33.95169]]], [[[-117.92563, 33.95386], [-117.92551, 33.95393], [-117.92534, 33.95397], [-117.92519, 33.95397], [-117.92506, 33.95395], [-117.92502, 33.95392], [-117.925, 33.95387], [-117.92501, 33.95383], [-117.92529, 33.95348], [-117.92549, 33.95359], [-117.92554, 33.95377], [-117.92563, 33.95386]]]]} Open Access 1 Powder Canyon Open Space http://www.lamountains.com/parks.asp?parkid=45 7479 2091 Native Habitat Preservation Authority 826 Special District 4 Special District - Other 24 http://www.habitatauthority.org/ Special District 4 27.946 Powder Canyon OS  
1153 1152 {"type": "MultiPolygon", "coordinates": [[[[-116.79678, 32.79555], [-116.78939, 32.79568], [-116.78942, 32.79919], [-116.78839, 32.79922], [-116.78843, 32.801], [-116.79007, 32.80102], [-116.7926, 32.80099], [-116.79263, 32.80279], [-116.78848, 32.80283], [-116.78424, 32.80279], [-116.78419, 32.79919], [-116.77998, 32.79918], [-116.77994, 32.7956], [-116.77575, 32.7956], [-116.77578, 32.80274], [-116.77261, 32.80275], [-116.7724, 32.80274], [-116.77211, 32.80269], [-116.77186, 32.80263], [-116.77035, 32.80211], [-116.76992, 32.80201], [-116.76944, 32.80196], [-116.76903, 32.80196], [-116.76866, 32.80199], [-116.76675, 32.80231], [-116.76636, 32.80235], [-116.76581, 32.80234], [-116.76495, 32.80223], [-116.76464, 32.80215], [-116.76436, 32.80203], [-116.76257, 32.80087], [-116.76202, 32.80056], [-116.76163, 32.80039], [-116.75955, 32.79963], [-116.75917, 32.79952], [-116.75871, 32.79944], [-116.75756, 32.7994], [-116.75701, 32.79933], [-116.75675, 32.79928], [-116.75557, 32.79895], [-116.75512, 32.79887], [-116.75485, 32.79885], [-116.75316, 32.79883], [-116.75283, 32.79885], [-116.75249, 32.79889], [-116.75205, 32.799], [-116.75162, 32.79915], [-116.75052, 32.79972], [-116.7503, 32.79981], [-116.7501, 32.79986], [-116.74989, 32.79989], [-116.74964, 32.7999], [-116.74943, 32.79988], [-116.74915, 32.7998], [-116.74876, 32.79962], [-116.74852, 32.79945], [-116.74831, 32.79924], [-116.74669, 32.7967], [-116.7464, 32.79635], [-116.74602, 32.79601], [-116.746, 32.79564], [-116.74538, 32.79563], [-116.74374, 32.79496], [-116.74351, 32.79486], [-116.7433, 32.79473], [-116.74308, 32.79458], [-116.74288, 32.79441], [-116.74192, 32.79345], [-116.74156, 32.79315], [-116.74122, 32.79294], [-116.74012, 32.79246], [-116.73988, 32.79231], [-116.73976, 32.79219], [-116.73967, 32.79206], [-116.73948, 32.79166], [-116.73934, 32.79144], [-116.73886, 32.79089], [-116.73869, 32.79074], [-116.73845, 32.79058], [-116.73816, 32.79045], [-116.73791, 32.79038], [-116.73759, 32.79034], [-116.73759, 32.78851], [-116.73336, 32.78851], [-116.73331, 32.78476], [-116.73751, 32.78476], [-116.75428, 32.78443], [-116.7543, 32.77679], [-116.76715, 32.77703], [-116.76713, 32.77324], [-116.7714, 32.77332], [-116.77143, 32.77711], [-116.78804, 32.77718], [-116.78795, 32.77343], [-116.7965, 32.77338], [-116.79677, 32.78836], [-116.79253, 32.78841], [-116.79256, 32.79197], [-116.79677, 32.79194], [-116.79678, 32.79555]]], [[[-116.74494, 32.79562], [-116.73759, 32.79565], [-116.73759, 32.79051], [-116.73789, 32.79055], [-116.73815, 32.79063], [-116.73842, 32.79076], [-116.73864, 32.79093], [-116.73916, 32.79151], [-116.73931, 32.79174], [-116.73945, 32.79207], [-116.73953, 32.79219], [-116.73966, 32.79235], [-116.73981, 32.79247], [-116.74003, 32.79261], [-116.74114, 32.79309], [-116.74139, 32.79324], [-116.74162, 32.79342], [-116.74221, 32.7946], [-116.74237, 32.79482], [-116.74263, 32.79505], [-116.74295, 32.79523], [-116.74329, 32.79535], [-116.74354, 32.79539], [-116.74437, 32.79546], [-116.74467, 32.79553], [-116.74494, 32.79562]]], [[[-116.74406, 32.79528], [-116.74353, 32.79522], [-116.74329, 32.79518], [-116.74299, 32.79506], [-116.74274, 32.79491], [-116.74253, 32.79473], [-116.74237, 32.79452], [-116.74203, 32.79381], [-116.74269, 32.79448], [-116.74301, 32.79475], [-116.74343, 32.795], [-116.74406, 32.79528]]], [[[-116.77178, 32.80276], [-116.76519, 32.80282], [-116.76299, 32.80279], [-116.75449, 32.80278], [-116.74607, 32.80287], [-116.74601, 32.79624], [-116.74632, 32.79654], [-116.74656, 32.79684], [-116.74806, 32.7992], [-116.74821, 32.7994], [-116.7484, 32.79959], [-116.74863, 32.79975], [-116.74954, 32.80016], [-116.74978, 32.80019], [-116.74989, 32.80018], [-116.75005, 32.80014], [-116.75067, 32.79984], [-116.75166, 32.79932], [-116.75207, 32.79917], [-116.75245, 32.79907], [-116.75283, 32.79901], [-116.75319, 32.79899], [-116.75482, 32.79902], [-116.75511, 32.79904], [-116.75554, 32.79911], [-116.75667, 32.79943], [-116.75698, 32.79949], [-116.75756, 32.79957], [-116.7587, 32.79961], [-116.7591, 32.79968], [-116.75949, 32.79979], [-116.76145, 32.80051], [-116.76196, 32.80073], [-116.76246, 32.80101], [-116.76427, 32.80217], [-116.7645, 32.80228], [-116.76478, 32.80236], [-116.7657, 32.8025], [-116.76602, 32.80252], [-116.76636, 32.80252], [-116.76682, 32.80247], [-116.7687, 32.80216], [-116.76907, 32.80213], [-116.76942, 32.80213], [-116.76988, 32.80218], [-116.77029, 32.80227], [-116.77178, 32.80276]]]]} Open Access 1 Loveland Reservoir http://www.sweetwater.org/index.aspx?page=111 12983 2163 Sweetwater Authority 817 Special District 4 Special District - Other 24 http://www.sweetwater.org Special District 4 3292.952 Loveland Reservoir  
1155 1154 {"type": "MultiPolygon", "coordinates": [[[[-117.01289, 32.68963], [-117.01273, 32.68983], [-117.01202, 32.69013], [-117.01125, 32.69018], [-117.0111, 32.69025], [-117.01139, 32.69105], [-117.01007, 32.69144], [-117.01049, 32.69249], [-117.01035, 32.69264], [-117.01027, 32.69283], [-117.01026, 32.69298], [-117.01031, 32.69315], [-117.01039, 32.69334], [-117.01048, 32.69348], [-117.01099, 32.69408], [-117.01119, 32.69426], [-117.01143, 32.69485], [-117.00956, 32.69534], [-117.00656, 32.69617], [-117.00618, 32.69512], [-117.00612, 32.69501], [-117.00435, 32.69499], [-117.0043, 32.69752], [-117.00427, 32.69832], [-117.00321, 32.69831], [-117.00225, 32.6976], [-117.0005, 32.69756], [-116.99905, 32.69953], [-116.99528, 32.70188], [-116.99528, 32.7009], [-116.99469, 32.70089], [-116.99469, 32.70118], [-116.99502, 32.70118], [-116.99502, 32.70219], [-116.99471, 32.70219], [-116.9947, 32.70197], [-116.99438, 32.70198], [-116.99437, 32.7013], [-116.99436, 32.70129], [-116.9941, 32.70131], [-116.9941, 32.70218], [-116.99345, 32.70218], [-116.99345, 32.70132], [-116.99338, 32.7013], [-116.98986, 32.7032], [-116.98981, 32.70485], [-116.98864, 32.70483], [-116.98679, 32.70576], [-116.98678, 32.70678], [-116.98667, 32.70685], [-116.98666, 32.70691], [-116.98637, 32.70706], [-116.98598, 32.7073], [-116.98571, 32.70742], [-116.9846, 32.7074], [-116.98455, 32.70877], [-116.98409, 32.70894], [-116.98378, 32.70911], [-116.98277, 32.70929], [-116.98295, 32.7098], [-116.98281, 32.70996], [-116.981, 32.7124], [-116.98079, 32.71263], [-116.98037, 32.71304], [-116.98007, 32.71326], [-116.97835, 32.71428], [-116.97786, 32.71462], [-116.97751, 32.7149], [-116.97712, 32.71526], [-116.97656, 32.71585], [-116.9757, 32.71692], [-116.97558, 32.71703], [-116.97541, 32.71695], [-116.97547, 32.71378], [-116.97668, 32.71161], [-116.97486, 32.71069], [-116.97368, 32.71127], [-116.97187, 32.70999], [-116.96919, 32.71004], [-116.96717, 32.70956], [-116.96536, 32.7089], [-116.96242, 32.70748], [-116.96114, 32.7065], [-116.95846, 32.70964], [-116.95844, 32.711], [-116.9581, 32.71205], [-116.9566, 32.71183], [-116.95699, 32.71137], [-116.95618, 32.70806], [-116.95828, 32.70139], [-116.96282, 32.7014], [-116.96508, 32.70243], [-116.96727, 32.70129], [-116.96827, 32.70129], [-116.96828, 32.70216], [-116.97589, 32.70219], [-116.97777, 32.69987], [-116.97802, 32.69579], [-116.97824, 32.69276], [-116.97921, 32.69007], [-116.98595, 32.69006], [-116.98601, 32.69003], [-116.98608, 32.69003], [-116.98853, 32.68879], [-116.98853, 32.68673], [-116.98976, 32.68672], [-116.98976, 32.68514], [-116.99176, 32.68512], [-116.99176, 32.68304], [-116.99173, 32.68302], [-116.99173, 32.68284], [-116.99302, 32.68306], [-116.99443, 32.68312], [-116.99553, 32.68297], [-116.9964, 32.68323], [-116.99641, 32.68275], [-116.99729, 32.68246], [-116.99947, 32.68152], [-116.9996, 32.68176], [-117.00039, 32.68385], [-117.00165, 32.68355], [-117.00257, 32.6859], [-117.00289, 32.68583], [-117.00626, 32.68725], [-117.00585, 32.68795], [-117.00562, 32.68829], [-117.00584, 32.68882], [-117.00845, 32.68998], [-117.00851, 32.68999], [-117.00932, 32.68976], [-117.01078, 32.68938], [-117.01149, 32.6884], [-117.01152, 32.68831], [-117.01146, 32.68822], [-117.01148, 32.68813], [-117.01286, 32.68945], [-117.01289, 32.68963]], [[-116.9777, 32.71144], [-116.9769, 32.71243], [-116.97689, 32.71248], [-116.97658, 32.71286], [-116.97639, 32.71351], [-116.97646, 32.71453], [-116.97697, 32.71482], [-116.97703, 32.71473], [-116.97659, 32.71448], [-116.97651, 32.71352], [-116.9767, 32.71291], [-116.97787, 32.71141], [-116.97543, 32.71], [-116.97476, 32.70997], [-116.97399, 32.71061], [-116.97307, 32.70944], [-116.97226, 32.70918], [-116.97221, 32.70926], [-116.97223, 32.70928], [-116.97298, 32.70953], [-116.97395, 32.71075], [-116.97479, 32.71007], [-116.97537, 32.71009], [-116.9777, 32.71144]], [[-116.99676, 32.68615], [-116.99677, 32.68613], [-116.99635, 32.68555], [-116.99567, 32.68556], [-116.9957, 32.68666], [-116.99676, 32.68615]]], [[[-117.01103, 32.6939], [-117.01058, 32.6934], [-117.0105, 32.69326], [-117.01044, 32.69313], [-117.01041, 32.69298], [-117.01041, 32.69287], [-117.01046, 32.69273], [-117.01054, 32.69262], [-117.01103, 32.6939]]]]} Open Access 1 Sweetwater Reservoir http://www.sweetwater.org/index.aspx?page=112 12984 2163 Sweetwater Authority 817 Special District 4 Special District - Other 24 http://www.sweetwater.org Special District 4 1773.528 Sweetwater Reservoir  
1710 1709 {"type": "Polygon", "coordinates": [[[-121.42753, 38.60727], [-121.4274, 38.60767], [-121.42735, 38.6079], [-121.42733, 38.60801], [-121.42733, 38.60856], [-121.42569, 38.60856], [-121.42568, 38.60844], [-121.42541, 38.60842], [-121.42542, 38.60749], [-121.42547, 38.60723], [-121.42753, 38.60727]]]} Open Access 1 Babcock Park   15745 2192 Fulton - El Camino 948 Special District 4 Special District - Other 24 http://www.fecrecpark.com/index.htm Special District 4 6.064 Babcock Park  
1939 1938 {"type": "Polygon", "coordinates": [[[-121.41459, 38.61315], [-121.41259, 38.61312], [-121.41258, 38.61407], [-121.41181, 38.61406], [-121.41183, 38.61375], [-121.41241, 38.61319], [-121.41241, 38.61267], [-121.41458, 38.6127], [-121.41459, 38.61315]]]} Open Access 1 Bellview Park   15992 2192 Fulton - El Camino 948 Special District 4 Special District - Other 24 http://www.fecrecpark.com/index.htm Special District 4 3.554 Bellview Park  
2117 2116 {"type": "Polygon", "coordinates": [[[-121.40835, 38.62349], [-121.40616, 38.62348], [-121.40616, 38.62206], [-121.40617, 38.62203], [-121.40621, 38.622], [-121.40625, 38.62199], [-121.40792, 38.622], [-121.40806, 38.62199], [-121.40823, 38.62194], [-121.40835, 38.62213], [-121.40835, 38.62349]]]} Open Access 1 Bohemian Park   16233 2192 Fulton - El Camino 948 Special District 4 Special District - Other 24 http://www.fecrecpark.com/index.htm Special District 4 7.791 Bohemian Park  
3105 3104 {"type": "Polygon", "coordinates": [[[-121.0031, 38.69953], [-121.00292, 38.69965], [-121.00272, 38.6997], [-121.00162, 38.6997], [-121.00144, 38.69928], [-121.00129, 38.6993], [-121.00117, 38.6997], [-121.00105, 38.6997], [-121.00112, 38.69917], [-121.00122, 38.69893], [-121.00141, 38.6989], [-121.00145, 38.69883], [-121.00139, 38.69854], [-121.00178, 38.6985], [-121.0023, 38.69848], [-121.00259, 38.69851], [-121.00261, 38.69853], [-121.00262, 38.69857], [-121.00253, 38.69877], [-121.00245, 38.69882], [-121.0024, 38.6989], [-121.0024, 38.69895], [-121.00246, 38.69902], [-121.00224, 38.69924], [-121.00238, 38.69934], [-121.0028, 38.69932], [-121.0031, 38.69953]]]} Open Access 1 Coloma-Lotus 1   17524 2023 Coloma-Lotus 684 Special District 4 Special District - Other 24 http://www.coloma.com/ Special District 4 3.685 Coloma-Lotus 1  
3197 3196 {"type": "Polygon", "coordinates": [[[-121.39391, 38.60316], [-121.3939, 38.60535], [-121.39175, 38.60532], [-121.39173, 38.60496], [-121.39056, 38.60494], [-121.39049, 38.60483], [-121.39047, 38.60352], [-121.39088, 38.60353], [-121.39089, 38.60343], [-121.39164, 38.60344], [-121.39166, 38.60313], [-121.39391, 38.60316]]]} Open Access 1 Cottage Park   17682 2192 Fulton - El Camino 948 Special District 4 Special District - Other 24 http://www.fecrecpark.com/index.htm Special District 4 15.832 Cottage Park  
3297 3296 {"type": "Polygon", "coordinates": [[[-121.39534, 38.61331], [-121.39524, 38.61346], [-121.39523, 38.61377], [-121.3953, 38.61409], [-121.39469, 38.61448], [-121.39334, 38.6141], [-121.39334, 38.61281], [-121.39398, 38.61283], [-121.39401, 38.61331], [-121.39534, 38.61331]]]} Open Access 1 Creekside Nature Area   17769 2192 Fulton - El Camino 948 Special District 4 Special District - Other 24 http://www.fecrecpark.com/index.htm Special District 4 5.275 Creekside Nature Area  
5277 5276 {"type": "Polygon", "coordinates": [[[-121.41513, 38.6044], [-121.41511, 38.60442], [-121.41512, 38.60684], [-121.41299, 38.60682], [-121.41298, 38.60718], [-121.41077, 38.60714], [-121.41077, 38.6036], [-121.41497, 38.60368], [-121.41497, 38.60411], [-121.41513, 38.60413], [-121.41513, 38.6044]]]} Open Access 1 Howe Park   20125 2192 Fulton - El Camino 948 Special District 4 Special District - Other 24 http://www.fecrecpark.com/index.htm Special District 4 34.705 Howe Park  
9282 9281 {"type": "Polygon", "coordinates": [[[-121.41056, 38.60659], [-121.41056, 38.60714], [-121.40937, 38.60713], [-121.40883, 38.60772], [-121.40883, 38.60803], [-121.40838, 38.60803], [-121.40837, 38.60806], [-121.4081, 38.60806], [-121.40808, 38.60814], [-121.40684, 38.60813], [-121.40629, 38.60794], [-121.40621, 38.60778], [-121.40834, 38.60734], [-121.40838, 38.60712], [-121.40904, 38.60713], [-121.40905, 38.60699], [-121.40893, 38.60687], [-121.40899, 38.60681], [-121.409, 38.60673], [-121.40887, 38.60658], [-121.4092, 38.60658], [-121.40962, 38.60669], [-121.41022, 38.60659], [-121.41056, 38.60659]]]} Open Access 1 Santa Anita Park   25036 2192 Fulton - El Camino 948 Special District 4 Special District - Other 24 http://www.fecrecpark.com/index.htm Special District 4 6.081 Santa Anita Park  
9486 9485 {"type": "Polygon", "coordinates": [[[-121.39679, 38.62353], [-121.39677, 38.62509], [-121.39471, 38.62507], [-121.39517, 38.62469], [-121.39555, 38.62429], [-121.39587, 38.62388], [-121.3961, 38.62353], [-121.39679, 38.62353]]]} Open Access 1 Seely Park   25284 2192 Fulton - El Camino 948 Special District 4 Special District - Other 24 http://www.fecrecpark.com/index.htm Special District 4 4.81 Seely Park  
11835 11834 {"type": "Polygon", "coordinates": [[[-118.81765, 36.13081], [-118.81735, 36.13107], [-118.81709, 36.13088], [-118.81696, 36.13099], [-118.81693, 36.13097], [-118.81688, 36.13102], [-118.81664, 36.13084], [-118.81712, 36.13041], [-118.81765, 36.13081]]]} Open Access 1 Springville Veterans Memorial Park   28480 2353 Springville Memorial District 1088 Special District 4 Special District - Other 24   Special District 4 0.832 Springville Veterans Memorial Park  
11858 11857 {"type": "Polygon", "coordinates": [[[-117.33599, 34.59944], [-117.33599, 34.5995], [-117.33454, 34.60022], [-117.3345, 34.60023], [-117.33446, 34.60022], [-117.33402, 34.59962], [-117.33403, 34.59956], [-117.3355, 34.59883], [-117.33556, 34.59885], [-117.33599, 34.59944]]]} Open Access 1 Oro Grande Park   28514 2355 County Service Area 42 1087 Special District 4 Special District - Other 24 http://specialdistricts.org/index.aspx?page=404 Special District 4 3.531 Oro Grande Park  
14824 14823 {"type": "MultiPolygon", "coordinates": [[[[-117.96288, 33.96984], [-117.96249, 33.9704], [-117.96227, 33.97064], [-117.96228, 33.97088], [-117.96219, 33.97105], [-117.96204, 33.97114], [-117.96194, 33.97104], [-117.96175, 33.97093], [-117.96168, 33.97085], [-117.96159, 33.97082], [-117.96145, 33.97083], [-117.96125, 33.97077], [-117.96113, 33.97071], [-117.96104, 33.97064], [-117.96095, 33.97051], [-117.96093, 33.97033], [-117.96147, 33.96993], [-117.96156, 33.97004], [-117.96201, 33.97003], [-117.96229, 33.96993], [-117.9626, 33.96994], [-117.9628, 33.96978], [-117.96288, 33.96984]]], [[[-117.96145, 33.96988], [-117.96145, 33.9699], [-117.96096, 33.97026], [-117.96096, 33.97024], [-117.961, 33.97017], [-117.96112, 33.97006], [-117.96145, 33.96988]]], [[[-117.96165, 33.97087], [-117.96164, 33.97088], [-117.96156, 33.97086], [-117.96159, 33.97086], [-117.96165, 33.97087]]], [[[-117.97696, 33.96632], [-117.9769, 33.9664], [-117.97684, 33.96644], [-117.97661, 33.96649], [-117.97661, 33.96619], [-117.97696, 33.96632]]], [[[-117.97702, 33.96785], [-117.97665, 33.96784], [-117.97661, 33.96655], [-117.97689, 33.96666], [-117.97687, 33.96681], [-117.97678, 33.96705], [-117.97674, 33.96723], [-117.97673, 33.96739], [-117.97679, 33.96759], [-117.97684, 33.96769], [-117.97691, 33.96778], [-117.97702, 33.96785]]], [[[-117.98084, 33.96788], [-117.97717, 33.96785], [-117.97699, 33.96778], [-117.97694, 33.96773], [-117.97683, 33.96751], [-117.9768, 33.96737], [-117.9768, 33.96723], [-117.97685, 33.96705], [-117.97694, 33.96682], [-117.97697, 33.96664], [-117.97672, 33.96652], [-117.9768, 33.96651], [-117.97689, 33.96648], [-117.97698, 33.9664], [-117.97701, 33.96633], [-117.97851, 33.96688], [-117.97904, 33.96694], [-117.97955, 33.96708], [-117.9798, 33.96713], [-117.98007, 33.96716], [-117.9804, 33.96705], [-117.98052, 33.96678], [-117.98059, 33.96681], [-117.98024, 33.96761], [-117.98084, 33.96788]]]]} Open Access 1 Arroyo San Miguel Open Space   15625 2091 Native Habitat Preservation Authority 826 Special District 4 Special District - Other 24 http://www.habitatauthority.org/ Special District 4 13.42 Arroyo San Miguel 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 40.378ms · Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette