superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
193 rows where MNG_AG_TYP = 17
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Consumnes Community Services District 85
- El Dorado Hills Community Service District 23
- Jurupa Community Services District 9
- Cameron Park Community Services District 7
- Mountain House Community Services District 5
- McKinleyville Community Services District 4
- Tamalpais Community Services District 4
- Brooktrails Community Services District 3
- Rossmore Community Services District 2
- Groveland Community Services District 2
- Indian Valley Community Services District 2
- Marinwood Community Service District 2
- Pajaro Community Services District 2
- Salton Community Services District 2
- Templeton Community Services District 2
- Discovery Bay Community Service District 1
- Scotia Community Services District 1
- Morongo Valley Community Services District 1
- Twain Harte Community Services District 1
- Manila Community Services District 1
- Truckee Tahoe Airport District 1
- Cambria Community Services District 1
- Aromona Community Services District 1
- Rosamond Community Services District 1
- Los Alamos Community Services District 1
- Golden Hills Community Service District 1
- Happy Camp Community Services District 1
- McCloud Community Services District 1
- Concord Landscaping and Lighting Maintenance District No. 3 1
- Tomales Village Community Services District 1
- …
ACCESS_TYP 2
- Open Access 170
- Restricted Access 3
MNG_AG_TYP 1
- Community Services District · 173 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1984 | 1984 | 1983 | {"type": "MultiPolygon", "coordinates": [[[[-121.44049, 38.4306], [-121.44003, 38.4306], [-121.43918, 38.43156], [-121.43899, 38.43148], [-121.43873, 38.43143], [-121.43846, 38.43139], [-121.43708, 38.43138], [-121.43685, 38.43139], [-121.43667, 38.43144], [-121.43645, 38.43151], [-121.43619, 38.43155], [-121.43418, 38.43163], [-121.43414, 38.43161], [-121.43412, 38.43158], [-121.43412, 38.43064], [-121.43409, 38.43062], [-121.43409, 38.43039], [-121.4341, 38.43035], [-121.43413, 38.43034], [-121.43492, 38.43033], [-121.43494, 38.43062], [-121.43971, 38.4306], [-121.43973, 38.43003], [-121.43984, 38.43003], [-121.44029, 38.43008], [-121.44049, 38.43016], [-121.44049, 38.4306]]], [[[-121.43856, 38.4322], [-121.43773, 38.43316], [-121.43751, 38.43309], [-121.4383, 38.43218], [-121.43841, 38.43218], [-121.43856, 38.4322]]]]} | Open Access 1 | Betschart Park | 16049 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 13.848 | Betschart Park | ||
2183 | 2183 | 2182 | {"type": "Polygon", "coordinates": [[[-121.07724, 38.67812], [-121.07489, 38.67813], [-121.07469, 38.67779], [-121.07467, 38.67748], [-121.07485, 38.67705], [-121.07491, 38.67655], [-121.07482, 38.67601], [-121.07428, 38.67385], [-121.07403, 38.67278], [-121.07374, 38.67223], [-121.07365, 38.67182], [-121.07684, 38.67147], [-121.07743, 38.67407], [-121.07748, 38.67435], [-121.07751, 38.67472], [-121.07752, 38.675], [-121.07745, 38.67711], [-121.07738, 38.67757], [-121.07724, 38.67812]]]} | Open Access 1 | Bowmen's Archery Range | 16312 | 2197 | El Dorado Hills Community Service District 560 | Special District 4 | Community Services District 17 | http://www.edhcsd.org/ | Special District 4 | 44.968 | Bowmen's Archery Range | ||
2200 | 2200 | 2199 | {"type": "Polygon", "coordinates": [[[-121.44595, 38.39725], [-121.44596, 38.39751], [-121.44588, 38.39779], [-121.44581, 38.39779], [-121.44572, 38.39782], [-121.44567, 38.39787], [-121.44566, 38.39795], [-121.44533, 38.39799], [-121.445, 38.39799], [-121.44499, 38.39769], [-121.44494, 38.39755], [-121.44486, 38.39741], [-121.44485, 38.39738], [-121.44487, 38.39736], [-121.44495, 38.39732], [-121.44509, 38.39729], [-121.44595, 38.39725]]]} | Open Access 1 | Bradford Park | 16325 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 1.547 | Bradford Park | ||
2385 | 2385 | 2384 | {"type": "Polygon", "coordinates": [[[-117.6, 33.94975], [-117.59999, 33.95205], [-117.59995, 33.95209], [-117.59977, 33.9521], [-117.59968, 33.95208], [-117.59949, 33.95201], [-117.5994, 33.95201], [-117.59932, 33.95205], [-117.59929, 33.95212], [-117.59931, 33.9522], [-117.59937, 33.95225], [-117.59901, 33.95226], [-117.59896, 33.9523], [-117.5989, 33.95224], [-117.59882, 33.95221], [-117.59874, 33.95223], [-117.59867, 33.95228], [-117.59863, 33.95225], [-117.5981, 33.95225], [-117.59829, 33.95213], [-117.59844, 33.95199], [-117.59855, 33.95182], [-117.59862, 33.95163], [-117.59864, 33.95146], [-117.59862, 33.94997], [-117.59867, 33.94993], [-117.59917, 33.94992], [-117.59943, 33.94994], [-117.5995, 33.94992], [-117.59957, 33.94988], [-117.59961, 33.94982], [-117.59963, 33.94976], [-117.6, 33.94975]]]} | Open Access 1 | Mountainview Park | https://www.jcsd.us/services/parks-and-recreation/parks-and-recreation-facilities | 33618 | 2331 | Jurupa Community Services District 667 | Special District 4 | Community Services District 17 | http://parks.jcsd.us/ | Special District 4 | 8.187 | Mountainview Park | |
2550 | 2550 | 2549 | {"type": "Polygon", "coordinates": [[[-117.60335, 33.93244], [-117.60337, 33.93248], [-117.60337, 33.93316], [-117.60334, 33.93323], [-117.6033, 33.93325], [-117.60036, 33.93326], [-117.60037, 33.93321], [-117.60032, 33.933], [-117.60022, 33.93275], [-117.60012, 33.93259], [-117.59983, 33.93223], [-117.59978, 33.93214], [-117.59975, 33.93201], [-117.59976, 33.93153], [-117.5999, 33.93138], [-117.60052, 33.93174], [-117.60097, 33.93195], [-117.60157, 33.93215], [-117.60186, 33.93223], [-117.60232, 33.93232], [-117.60276, 33.93237], [-117.60324, 33.93239], [-117.60332, 33.93241], [-117.60335, 33.93244]]]} | Open Access 1 | Dairyland Park | https://www.jcsd.us/services/parks-and-recreation/parks-and-recreation-facilities | 33619 | 2331 | Jurupa Community Services District 667 | Special District 4 | Community Services District 17 | http://parks.jcsd.us/ | Special District 4 | 9.934 | Dairyland Park | |
2556 | 2556 | 2555 | {"type": "Polygon", "coordinates": [[[-117.56267, 33.9516], [-117.55847, 33.9516], [-117.55845, 33.94993], [-117.55859, 33.94991], [-117.55858, 33.94739], [-117.56038, 33.94687], [-117.56071, 33.94684], [-117.5621, 33.94742], [-117.56267, 33.94752], [-117.56267, 33.9516]]]} | Open Access 1 | Eastvale Community Park | https://www.jcsd.us/services/parks-and-recreation/parks-and-recreation-facilities | 33620 | 2331 | Jurupa Community Services District 667 | Special District 4 | Community Services District 17 | http://parks.jcsd.us/ | Special District 4 | 46.599 | Eastvale Community Park | |
2681 | 2681 | 2680 | {"type": "Polygon", "coordinates": [[[-121.43638, 38.42801], [-121.43638, 38.42805], [-121.43624, 38.42824], [-121.43613, 38.42847], [-121.43607, 38.42869], [-121.43432, 38.42814], [-121.43436, 38.42786], [-121.43441, 38.42782], [-121.43443, 38.42776], [-121.43441, 38.42771], [-121.43437, 38.42767], [-121.43431, 38.42739], [-121.4343, 38.42709], [-121.43435, 38.42705], [-121.43437, 38.427], [-121.43435, 38.42695], [-121.43431, 38.42691], [-121.43437, 38.42684], [-121.43486, 38.42685], [-121.4349, 38.42692], [-121.43498, 38.42697], [-121.43509, 38.42698], [-121.43543, 38.42709], [-121.43582, 38.42713], [-121.43586, 38.42715], [-121.43588, 38.42718], [-121.43594, 38.42742], [-121.43602, 38.42757], [-121.43611, 38.4277], [-121.43638, 38.42801]]]} | Open Access 1 | Case Park | 16942 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 6.081 | Case Park | ||
2686 | 2686 | 2685 | {"type": "Polygon", "coordinates": [[[-121.37703, 38.42161], [-121.377, 38.42169], [-121.37703, 38.42179], [-121.37703, 38.42262], [-121.37624, 38.42262], [-121.37623, 38.42127], [-121.37672, 38.42127], [-121.37673, 38.42145], [-121.37703, 38.42161]]]} | Open Access 1 | Castello Park | 16948 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2.382 | Castello Park | ||
2705 | 2705 | 2704 | {"type": "Polygon", "coordinates": [[[-121.45641, 38.41232], [-121.45637, 38.41234], [-121.45607, 38.41261], [-121.45601, 38.41264], [-121.45598, 38.41269], [-121.45598, 38.41275], [-121.45568, 38.41281], [-121.45527, 38.41284], [-121.4552, 38.41222], [-121.45618, 38.41213], [-121.45635, 38.41206], [-121.45638, 38.41206], [-121.45641, 38.41232]]]} | Open Access 1 | Caterino Park | 16972 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 1.507 | Caterino Park | ||
2716 | 2716 | 2715 | {"type": "Polygon", "coordinates": [[[-121.75839, 36.87566], [-121.75803, 36.87597], [-121.75767, 36.87552], [-121.7581, 36.87529], [-121.75839, 36.87566]]]} | Open Access 1 | Caytano Park | 16984 | 2249 | Pajaro Community Services District 956 | Special District 4 | Community Services District 17 | http://pajarosunnymesa.com/ | Special District 4 | 0.617 | Caytano Park | ||
2725 | 2725 | 2724 | {"type": "Polygon", "coordinates": [[[-117.58089, 33.9671], [-117.58011, 33.96711], [-117.58008, 33.96687], [-117.57998, 33.96658], [-117.57986, 33.96636], [-117.57973, 33.96617], [-117.57955, 33.96599], [-117.57939, 33.96586], [-117.57851, 33.96525], [-117.5785, 33.96519], [-117.57898, 33.96466], [-117.57905, 33.96463], [-117.58023, 33.96463], [-117.58075, 33.96458], [-117.58085, 33.96464], [-117.58089, 33.9671]]]} | Open Access 1 | Cedar Creek Park | 16994 | 2331 | Jurupa Community Services District 667 | Special District 4 | Community Services District 17 | http://parks.jcsd.us/ | Special District 4 | 9.52 | Cedar Creek Park | ||
2764 | 2764 | 2763 | {"type": "Polygon", "coordinates": [[[-121.54269, 37.77951], [-121.54239, 37.77979], [-121.54129, 37.78063], [-121.54098, 37.7809], [-121.54067, 37.78125], [-121.54041, 37.78162], [-121.54029, 37.78184], [-121.54019, 37.78207], [-121.54009, 37.78238], [-121.53981, 37.78233], [-121.53955, 37.78222], [-121.5394, 37.78212], [-121.53922, 37.78194], [-121.5391, 37.78173], [-121.53907, 37.78158], [-121.53905, 37.78027], [-121.54016, 37.78026], [-121.54045, 37.78019], [-121.54065, 37.78012], [-121.54091, 37.77996], [-121.54105, 37.77983], [-121.54116, 37.77968], [-121.54127, 37.77944], [-121.5413, 37.77927], [-121.54131, 37.77913], [-121.54187, 37.77914], [-121.54212, 37.77917], [-121.54236, 37.77923], [-121.54259, 37.77931], [-121.54252, 37.77943], [-121.54269, 37.77951]]]} | Open Access 1 | Central Community Park | 17047 | 2288 | Mountain House Community Services District 690 | Special District 4 | Community Services District 17 | http://www.mhcsd.com/ | Special District 4 | 11.504 | Central Community Park | ||
2800 | 2800 | 2799 | {"type": "Polygon", "coordinates": [[[-121.3714, 38.4211], [-121.3709, 38.4211], [-121.37034, 38.42063], [-121.3714, 38.42063], [-121.3714, 38.4211]]]} | Open Access 1 | Del Meyer Park | 18039 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 0.885 | Del Meyer Park | ||
2914 | 2914 | 2913 | {"type": "Polygon", "coordinates": [[[-121.00637, 38.65611], [-121.00636, 38.65719], [-121.00382, 38.6572], [-121.00381, 38.65631], [-121.00418, 38.65622], [-121.00637, 38.65611]]]} | Open Access 1 | Christa McAuliffe Park | 17223 | 2212 | Cameron Park Community Services District 604 | Special District 4 | Community Services District 17 | http://www.cameronpark.org/parks_and_facilities.html | Special District 4 | 6.169 | Christa McAuliffe Park | ||
3117 | 3117 | 3116 | {"type": "Polygon", "coordinates": [[[-121.3967, 38.41621], [-121.3967, 38.4165], [-121.39663, 38.41653], [-121.39659, 38.4166], [-121.3966, 38.41664], [-121.39664, 38.41669], [-121.39661, 38.41672], [-121.3966, 38.41708], [-121.39662, 38.41712], [-121.39653, 38.41715], [-121.39646, 38.41702], [-121.39609, 38.41661], [-121.3958, 38.41635], [-121.39532, 38.41598], [-121.39514, 38.4158], [-121.39498, 38.4156], [-121.39551, 38.41544], [-121.3958, 38.41544], [-121.39586, 38.41553], [-121.39603, 38.4157], [-121.3962, 38.41581], [-121.3962, 38.4162], [-121.3967, 38.41621]]]} | Open Access 1 | Colton Park | 17545 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2.685 | Colton Park | ||
3257 | 3257 | 3256 | {"type": "Polygon", "coordinates": [[[-116.57315, 34.05039], [-116.57313, 34.05043], [-116.57309, 34.05044], [-116.5722, 34.05045], [-116.57219, 34.04877], [-116.57314, 34.04877], [-116.57315, 34.05039]]]} | Open Access 1 | Covington Park | 17726 | 2086 | Morongo Valley Community Services District 536 | Special District 4 | Community Services District 17 | http://www.92256.net/csd/ | Special District 4 | 4.048 | Covington Park | ||
3294 | 3294 | 3293 | {"type": "MultiPolygon", "coordinates": [[[[-121.54538, 37.7804], [-121.54522, 37.78077], [-121.54524, 37.78079], [-121.54511, 37.78096], [-121.54496, 37.78111], [-121.54445, 37.78147], [-121.5442, 37.78172], [-121.54399, 37.78174], [-121.54378, 37.78179], [-121.54358, 37.78186], [-121.54335, 37.782], [-121.54319, 37.78214], [-121.54268, 37.78271], [-121.54248, 37.78288], [-121.54232, 37.783], [-121.54207, 37.78313], [-121.54189, 37.78321], [-121.54162, 37.7833], [-121.54142, 37.78335], [-121.54117, 37.78339], [-121.54092, 37.78341], [-121.54045, 37.7834], [-121.54044, 37.78309], [-121.54045, 37.78287], [-121.54053, 37.78244], [-121.5406, 37.78223], [-121.54071, 37.78197], [-121.54095, 37.78158], [-121.54121, 37.78126], [-121.54147, 37.78101], [-121.54267, 37.78008], [-121.54287, 37.7799], [-121.54308, 37.77969], [-121.54322, 37.77977], [-121.54332, 37.77966], [-121.54384, 37.77993], [-121.54424, 37.7801], [-121.54466, 37.78023], [-121.54525, 37.78035], [-121.54526, 37.78038], [-121.54538, 37.7804]]], [[[-121.55082, 37.77568], [-121.5508, 37.77572], [-121.55043, 37.77588], [-121.54959, 37.7761], [-121.54925, 37.77623], [-121.54795, 37.77699], [-121.54712, 37.77733], [-121.54663, 37.7776], [-121.54659, 37.77765], [-121.54656, 37.77771], [-121.54652, 37.77772], [-121.54635, 37.77802], [-121.54566, 37.77907], [-121.54558, 37.77922], [-121.54553, 37.77934], [-121.54551, 37.77948], [-121.54545, 37.78007], [-121.54505, 37.78001], [-121.54465, 37.77991], [-121.54427, 37.77978], [-121.54387, 37.77959], [-121.54418, 37.77927], [-121.54454, 37.77906], [-121.54477, 37.77879], [-121.54512, 37.77825], [-121.54541, 37.77784], [-121.54584, 37.77709], [-121.54597, 37.77694], [-121.54606, 37.77685], [-121.54623, 37.77674], [-121.54624, 37.77671], [-121.54636, 37.7767], [-121.54646, 37.77666], [-121.54677, 37.77658], [-121.54739, 37.77635], [-121.5476, 37.77623], [-121.54827, 37.77579], [-121.54842, 37.77571], [-121.54848, 37.77564], [-121.54852, 37.77564], [-121.54912, 37.77537], [-121.54914, 37.77534], [-121.54924, 37.77533], [-121.5494, 37.77527], [-121.54989, 37.77516], [-121.55013, 37.77506], [-121.55016, 37.77506], [-121.55049, 37.77533], [-121.55071, 37.77555], [-121.55082, 37.77568]]], [[[-121.55684, 37.77112], [-121.55681, 37.77206], [-121.55634, 37.77206], [-121.55638, 37.77199], [-121.55637, 37.77193], [-121.55633, 37.77189], [-121.55628, 37.77186], [-121.55622, 37.77185], [-121.55615, 37.77185], [-121.55609, 37.77188], [-121.55606, 37.77191], [-121.55604, 37.77197], [-121.55608, 37.77211], [-121.55606, 37.77224], [-121.55606, 37.77268], [-121.55603, 37.77272], [-121.55599, 37.77273], [-121.55505, 37.77275], [-121.55425, 37.77283], [-121.55372, 37.77293], [-121.55325, 37.77304], [-121.55291, 37.77318], [-121.5527, 37.77332], [-121.55248, 37.77355], [-121.5518, 37.7748], [-121.5516, 37.77509], [-121.5514, 37.7753], [-121.55106, 37.77557], [-121.55102, 37.77557], [-121.55099, 37.77556], [-121.55072, 37.77528], [-121.55031, 37.77493], [-121.55057, 37.77464], [-121.5509, 37.77422], [-121.55104, 37.774], [-121.55135, 37.7734], [-121.55156, 37.77314], [-121.55179, 37.77294], [-121.55312, 37.77197], [-121.55328, 37.77189], [-121.55344, 37.77184], [-121.55364, 37.77182], [-121.55416, 37.77181], [-121.5544, 37.77177], [-121.55461, 37.77171], [-121.55481, 37.77163], [-121.55499, 37.77154], [-121.55535, 37.77128], [-121.55551, 37.77118], [-121.55584, 37.77102], [-121.55598, 37.77098], [-121.55621, 37.77094], [-121.55681, 37.77096], [-121.55681, 37.77111], [-121.55684, 37.77112]]]]} | Open Access 1 | Creek Park | 17765 | 2288 | Mountain House Community Services District 690 | Special District 4 | Community Services District 17 | http://www.mhcsd.com/ | Special District 4 | 59.435 | Creek Park | ||
3296 | 3296 | 3295 | {"type": "Polygon", "coordinates": [[[-121.06525, 38.64755], [-121.06521, 38.64759], [-121.06334, 38.64831], [-121.06334, 38.64702], [-121.06368, 38.64696], [-121.06369, 38.64703], [-121.06373, 38.64709], [-121.06385, 38.64714], [-121.06401, 38.64713], [-121.06507, 38.64717], [-121.06511, 38.6472], [-121.06515, 38.64733], [-121.06525, 38.64751], [-121.06525, 38.64755]]]} | Open Access 1 | Creekside Greens Park | 17768 | 2197 | El Dorado Hills Community Service District 560 | Special District 4 | Community Services District 17 | http://www.edhcsd.org/ | Special District 4 | 3.69 | Creekside Greens Park | ||
3305 | 3305 | 3304 | {"type": "Polygon", "coordinates": [[[-122.5936, 38.03651], [-122.59322, 38.03735], [-122.59298, 38.03743], [-122.59283, 38.03745], [-122.5924, 38.03741], [-122.59226, 38.03735], [-122.59197, 38.03715], [-122.59183, 38.0371], [-122.59169, 38.03706], [-122.59171, 38.03697], [-122.59152, 38.03677], [-122.59132, 38.03663], [-122.59112, 38.03657], [-122.59099, 38.0369], [-122.59094, 38.03694], [-122.59091, 38.03701], [-122.59057, 38.0369], [-122.59083, 38.03681], [-122.59089, 38.03653], [-122.59067, 38.03638], [-122.59056, 38.03625], [-122.59028, 38.0357], [-122.59012, 38.03563], [-122.58972, 38.03565], [-122.58941, 38.03569], [-122.58928, 38.03569], [-122.58857, 38.0356], [-122.58856, 38.03574], [-122.5885, 38.03598], [-122.58845, 38.03612], [-122.58812, 38.03641], [-122.58806, 38.03649], [-122.58798, 38.03648], [-122.58837, 38.0359], [-122.5883, 38.03553], [-122.58746, 38.0352], [-122.58723, 38.03502], [-122.58695, 38.03522], [-122.58693, 38.03518], [-122.58692, 38.03515], [-122.58748, 38.03465], [-122.58766, 38.03476], [-122.58816, 38.03473], [-122.58897, 38.03519], [-122.58947, 38.03524], [-122.58995, 38.03509], [-122.5906, 38.03563], [-122.5907, 38.03578], [-122.59074, 38.03591], [-122.59082, 38.03589], [-122.59102, 38.03603], [-122.59119, 38.03625], [-122.59145, 38.0363], [-122.59179, 38.03645], [-122.59196, 38.03649], [-122.59224, 38.03655], [-122.59303, 38.0366], [-122.59336, 38.03657], [-122.5936, 38.03651]]]} | Open Access 1 | Creekside Park | 17784 | 2074 | Marinwood Community Service District 890 | Special District 4 | Community Services District 17 | http://www.marinwood.org/ | Special District 4 | 9.537 | Creekside Park | ||
3343 | 3343 | 3342 | {"type": "Polygon", "coordinates": [[[-121.45444, 38.42969], [-121.45442, 38.43075], [-121.45442, 38.43083], [-121.45439, 38.43086], [-121.45317, 38.43087], [-121.45288, 38.43085], [-121.45288, 38.42967], [-121.45444, 38.42969]]]} | Open Access 1 | Fite Park | 18926 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 4.4 | Fite Park |
Advanced export
JSON shape: default, array, newline-delimited
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]);