units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
164 rows where DES_TP = 3 and MNG_AG_TYP = 4 sorted by AGNCY_LEV
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- East Bay Regional Park District 25
- Sunrise Recreation and Park District 12
- Conejo Recreation and Park District 10
- Rancho Simi Recreation and Park District 8
- Hayward Area Recreation and Park District 7
- Valley-Wide Recreation and Park District 6
- Isla Vista Recreation and Park District 6
- Southgate Recreation and Park District 5
- Monterey Peninsula Regional Park District 4
- Desert Recreation District 4
- Tuolumne Park and Recreation District 4
- Miraleste Recreation and Park District 4
- Pleasant Valley Recreation and Park District 3
- Apple Valley Recreation and Park District 3
- Pleasant Hill Recreation and Park District 3
- Durham Recreation and Park District 3
- Jurupa Area Recreation and Park District 2
- North of the River Recreation and Park District 2
- Auburn Area Recreation and Park District 2
- West Side Recreation and Park District 2
- Hesperia Recreation and Park District 2
- Orangevale Recreation and Park District 2
- Weed Recreation and Parks District 2
- Barstow Recreation and Park District 1
- Feather River Recreation and Park District 1
- Greater Vallejo Recreation and Park District 1
- Shafter Recreation and Park District 1
- Wasco Recreation and Park District 1
- Rio Linda Elverta Recreation and Park District 1
- Monte Rio Recreation and Park District 1
- …
ACCESS_TYP 3
MNG_AG_TYP 1
- Recreation/Parks District · 144 ✖
DES_TP 1
- Local Recreation Area · 144 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3269 | 3269 | 3268 | {"type": "Polygon", "coordinates": [[[-122.0528, 37.99715], [-122.05267, 37.99768], [-122.05079, 37.99735], [-122.05079, 37.99734], [-122.05051, 37.99729], [-122.05017, 37.99725], [-122.05016, 37.99724], [-122.04978, 37.99725], [-122.04887, 37.99733], [-122.04817, 37.99731], [-122.04823, 37.9969], [-122.04863, 37.99694], [-122.04888, 37.99693], [-122.04913, 37.99691], [-122.04957, 37.9968], [-122.04985, 37.99676], [-122.04986, 37.99675], [-122.05003, 37.99674], [-122.0501, 37.99681], [-122.05025, 37.99683], [-122.05029, 37.99673], [-122.05066, 37.99677], [-122.0528, 37.99715]]]} | Open Access 1 | 29407 | Delta/DeAnza Trail | 18077 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 5.445 | Delta/DeAnza Trail | 0 | Local Recreation Area 3 | 4 | |
3355 | 3355 | 3354 | {"type": "Polygon", "coordinates": [[[-116.36064, 33.7325], [-116.36064, 33.73492], [-116.35884, 33.73445], [-116.35656, 33.73376], [-116.35647, 33.73315], [-116.35647, 33.73251], [-116.36064, 33.7325]]]} | Open Access 1 | 24277 | Cook Fields Sports Complex | 17615 | 2216 | Desert Recreation District 286 | Special District 4 | Recreation/Parks District 4 | http://www.myrecreationdistrict.com | Special District 4 | 2216 | Desert Recreation District 282 | Special District 4 | Recreation/Parks District 4 | Riverside 10 | 19.46 | Cook Fields Sports Complex | 0 | Local Recreation Area 3 | 4 | |
3358 | 3358 | 3357 | {"type": "Polygon", "coordinates": [[[-116.07594, 33.57297], [-116.07593, 33.5744], [-116.0754, 33.57439], [-116.07538, 33.57444], [-116.07467, 33.57442], [-116.07467, 33.573], [-116.07472, 33.57296], [-116.07594, 33.57297]]]} | Open Access 1 | 24269 | Mecca Community Center and Park | 22102 | 2216 | Desert Recreation District 286 | Special District 4 | Recreation/Parks District 4 | http://www.myrecreationdistrict.com | Special District 4 | 2216 | Desert Recreation District 282 | Special District 4 | Recreation/Parks District 4 | Riverside 10 | 4.682 | Mecca Community Ctr. and Park | 0 | Local Recreation Area 3 | 4 | |
3364 | 3364 | 3363 | {"type": "Polygon", "coordinates": [[[-122.06821, 37.96242], [-122.06779, 37.96243], [-122.06778, 37.96239], [-122.06715, 37.9624], [-122.06651, 37.96247], [-122.06646, 37.96233], [-122.06626, 37.96208], [-122.06625, 37.96193], [-122.06635, 37.96168], [-122.06738, 37.96154], [-122.06818, 37.96148], [-122.06821, 37.96242]]]} | Open Access 1 | 31033 | Pleasant Hill Community Center / Frank Salfingere Park | 23794 | 2112 | Pleasant Hill Recreation and Park District 466 | Special District 4 | Recreation/Parks District 4 | http://www.pleasanthillrec.com | Special District 4 | 2112 | Pleasant Hill Recreation and Park District 459 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 3.829 | Pleasant Hill Community Ctr. / Frank Salfingere Park | 0 | Local Recreation Area 3 | 4 | |
3502 | 3502 | 3501 | {"type": "MultiPolygon", "coordinates": [[[[-121.38155, 38.45546], [-121.38133, 38.45552], [-121.38115, 38.45563], [-121.38102, 38.45578], [-121.38096, 38.45595], [-121.38097, 38.45515], [-121.38053, 38.45511], [-121.38059, 38.45505], [-121.3806, 38.45497], [-121.38057, 38.45493], [-121.38053, 38.45491], [-121.38047, 38.4549], [-121.38041, 38.4549], [-121.38041, 38.45474], [-121.38085, 38.45497], [-121.38115, 38.45506], [-121.3814, 38.45506], [-121.38155, 38.45546]]], [[[-121.38319, 38.45988], [-121.38277, 38.45988], [-121.38264, 38.4596], [-121.38272, 38.45954], [-121.38274, 38.45948], [-121.3827, 38.45937], [-121.3827, 38.45913], [-121.38268, 38.45901], [-121.38261, 38.45886], [-121.38245, 38.45861], [-121.38238, 38.45845], [-121.38224, 38.45784], [-121.38214, 38.45762], [-121.38195, 38.4573], [-121.38188, 38.45714], [-121.38182, 38.45694], [-121.38176, 38.45661], [-121.38171, 38.45649], [-121.38156, 38.45622], [-121.38155, 38.45617], [-121.38155, 38.4561], [-121.38154, 38.45606], [-121.38149, 38.45601], [-121.3814, 38.456], [-121.38131, 38.45603], [-121.38128, 38.45611], [-121.38109, 38.45611], [-121.38109, 38.45594], [-121.38113, 38.45583], [-121.38123, 38.4557], [-121.38135, 38.45562], [-121.38148, 38.45558], [-121.38159, 38.45557], [-121.38319, 38.45988]]]]} | Open Access 1 | 36025 | Danbury Parkway | 17917 | 2160 | Southgate Recreation and Park District 502 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 3.905 | Danbury Parkway | 0 | Local Recreation Area 3 | 4 | |
3624 | 3624 | 3623 | {"type": "Polygon", "coordinates": [[[-121.70748, 37.99957], [-121.7053, 37.99809], [-121.70531, 37.9979], [-121.70746, 37.99794], [-121.70748, 37.99957]]]} | Open Access 1 | 29411 | BB Delta Shoreline Trail | 15905 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 4.739 | BB Delta Shoreline Trail | 0 | Local Recreation Area 3 | 4 | |
3715 | 3715 | 3714 | {"type": "Polygon", "coordinates": [[[-118.79784, 34.25155], [-118.79749, 34.25203], [-118.7975, 34.25248], [-118.79724, 34.25295], [-118.79723, 34.2536], [-118.79568, 34.2533], [-118.7955, 34.25324], [-118.79538, 34.25317], [-118.79528, 34.25324], [-118.7952, 34.25343], [-118.79525, 34.25345], [-118.7954, 34.25372], [-118.79566, 34.25383], [-118.79597, 34.25401], [-118.79541, 34.25383], [-118.79527, 34.25375], [-118.79518, 34.2538], [-118.79509, 34.25364], [-118.79508, 34.25348], [-118.7952, 34.2532], [-118.79531, 34.2531], [-118.79523, 34.25299], [-118.79518, 34.25288], [-118.79515, 34.25275], [-118.79516, 34.25265], [-118.79518, 34.25254], [-118.79548, 34.25178], [-118.79559, 34.25128], [-118.79649, 34.25136], [-118.79776, 34.25144], [-118.79782, 34.25149], [-118.79784, 34.25155]]]} | Open Access 1 | 44685 | Sinaloa Youth Ball Fields | 25516 | 2118 | Rancho Simi Recreation and Park District 80 | Special District 4 | Recreation/Parks District 4 | http://www.rsrpd.org/ | Special District 4 | 2118 | Rancho Simi Recreation and Park District 78 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 11.424 | Sinaloa Youth Ball Fields | 0 | Local Recreation Area 3 | 4 | |
3733 | 3733 | 3732 | {"type": "MultiPolygon", "coordinates": [[[[-122.03357, 37.90414], [-122.03346, 37.90426], [-122.03345, 37.904], [-122.0335, 37.90405], [-122.03357, 37.90414]]], [[[-122.04019, 37.90842], [-122.03957, 37.90859], [-122.03754, 37.90726], [-122.03826, 37.90623], [-122.03875, 37.90662], [-122.03905, 37.9069], [-122.03939, 37.90741], [-122.03961, 37.90803], [-122.04019, 37.90842]]]]} | Open Access 1 | 31016 | Briones to Mount Diablo Trail | 33752 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 5.904 | Briones to Mount Diablo Trail | 0 | Local Recreation Area 3 | 4 | |
3929 | 3929 | 3928 | {"type": "Polygon", "coordinates": [[[-121.10884, 38.95035], [-121.10788, 38.95042], [-121.10787, 38.95046], [-121.10748, 38.95048], [-121.10748, 38.94927], [-121.1088, 38.94923], [-121.10884, 38.95035]]]} | Open Access 1 | 36208 | Auburn Recreation District 1 | 15695 | 2004 | Auburn Area Recreation and Park District 700 | Special District 4 | Recreation/Parks District 4 | http://auburnrec.com/ | Special District 4 | 2004 | Auburn Area Recreation and Park District 447 | Special District 4 | Recreation/Parks District 4 | Placer 35 | 3.705 | Auburn Rec. District 1 | 0 | Local Recreation Area 3 | 4 | |
4346 | 4346 | 4345 | {"type": "Polygon", "coordinates": [[[-119.27012, 35.49626], [-119.27011, 35.49689], [-119.26949, 35.49688], [-119.26949, 35.49626], [-119.27012, 35.49626]]]} | Open Access 1 | 48440 | Skate Park | 33145 | 2149 | Shafter Recreation and Park District 436 | Special District 4 | Recreation/Parks District 4 | http://shafterrecreation.com/ | Special District 4 | 2149 | Shafter Recreation and Park District 430 | Special District 4 | Recreation/Parks District 4 | Kern 36 | 0.977 | Skate Park | 2001 | Local Recreation Area 3 | 4 | |
4860 | 4860 | 4859 | {"type": "Polygon", "coordinates": [[[-118.8224, 34.295], [-118.82168, 34.29571], [-118.82099, 34.29626], [-118.8176, 34.29545], [-118.81217, 34.29678], [-118.80476, 34.30392], [-118.79639, 34.30984], [-118.79638, 34.3044], [-118.80047, 34.30326], [-118.80195, 34.30167], [-118.80796, 34.29721], [-118.8082, 34.29486], [-118.80973, 34.29297], [-118.81042, 34.29304], [-118.81081, 34.29253], [-118.81063, 34.29221], [-118.81146, 34.29191], [-118.81295, 34.29197], [-118.81497, 34.29179], [-118.8156, 34.29223], [-118.81725, 34.2923], [-118.81836, 34.29215], [-118.81865, 34.29188], [-118.819, 34.29232], [-118.8199, 34.292], [-118.82059, 34.29224], [-118.82079, 34.29209], [-118.82145, 34.29225], [-118.82176, 34.29316], [-118.82239, 34.2945], [-118.8224, 34.295]]]} | Open Access 1 | 48520 | Alamos Canyon Open Space | 33233 | 2118 | Rancho Simi Recreation and Park District 80 | Special District 4 | Recreation/Parks District 4 | http://www.rsrpd.org/ | Special District 4 | 2118 | Rancho Simi Recreation and Park District 78 | Special District 4 | Recreation/Parks District 4 | http://www.rsrpd.org/simi_valley/trails/alamoscanyon.php | Ventura 8 | 281.33 | Alamos Canyon OS | 2016 | Local Recreation Area 3 | 4 |
4981 | 4981 | 4980 | {"type": "Polygon", "coordinates": [[[-118.86601, 34.24605], [-118.86522, 34.24588], [-118.86449, 34.24562], [-118.8641, 34.24534], [-118.86386, 34.24503], [-118.86363, 34.24453], [-118.86337, 34.24383], [-118.8629, 34.24116], [-118.86291, 34.24008], [-118.86269, 34.23963], [-118.8625, 34.23963], [-118.86212, 34.24004], [-118.86184, 34.24115], [-118.86166, 34.24164], [-118.86142, 34.24204], [-118.86109, 34.2424], [-118.86029, 34.24304], [-118.86001, 34.24322], [-118.85893, 34.24344], [-118.85787, 34.24342], [-118.85677, 34.24345], [-118.85552, 34.24377], [-118.85491, 34.24409], [-118.85445, 34.24414], [-118.85382, 34.24395], [-118.85335, 34.24361], [-118.85305, 34.24322], [-118.85238, 34.24315], [-118.85209, 34.24331], [-118.85209, 34.24376], [-118.85198, 34.24435], [-118.85229, 34.24447], [-118.85308, 34.24441], [-118.85356, 34.24447], [-118.85435, 34.2448], [-118.85472, 34.24505], [-118.85521, 34.24539], [-118.85582, 34.24601], [-118.85907, 34.24557], [-118.85908, 34.24601], [-118.86183, 34.24698], [-118.86183, 34.24704], [-118.86135, 34.24737], [-118.86071, 34.24737], [-118.85901, 34.24664], [-118.8566, 34.247], [-118.85424, 34.2469], [-118.85211, 34.24762], [-118.85042, 34.2476], [-118.85039, 34.24535], [-118.84855, 34.24563], [-118.84856, 34.24296], [-118.8512, 34.24133], [-118.85202, 34.24224], [-118.85363, 34.24125], [-118.85364, 34.24123], [-118.85345, 34.24102], [-118.85321, 34.24082], [-118.85298, 34.24071], [-118.85281, 34.24069], [-118.85264, 34.24058], [-118.85238, 34.24061], [-118.85271, 34.24038], [-118.85426, 34.23944], [-118.85592, 34.24026], [-118.85688, 34.23975], [-118.85678, 34.23961], [-118.85682, 34.23954], [-118.8567, 34.23937], [-118.85687, 34.23921], [-118.85732, 34.23972], [-118.85764, 34.23997], [-118.86057, 34.23827], [-118.86071, 34.23809], [-118.86598, 34.23806], [-118.86601, 34.24605]]]} | Restricted Access 2 | 17732 | McCrea Open Space | 22014 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 226.171 | McCrea OS | 0 | Local Recreation Area 3 | 4 | |
5079 | 5079 | 5078 | {"type": "Polygon", "coordinates": [[[-119.01469, 34.22393], [-119.01462, 34.2239], [-119.01463, 34.22384], [-119.01461, 34.22379], [-119.01469, 34.22376], [-119.01469, 34.22393]]]} | Open Access 1 | 15062 | Pleasant Valley Recreation and Park District | 23802 | 2113 | Pleasant Valley Recreation and Park District 149 | Special District 4 | Recreation/Parks District 4 | http://www.pvrpd.org/ | Special District 4 | 2113 | Pleasant Valley Recreation and Park District 145 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 0.025 | Pleasant Valley Rec. and Park District | 0 | Local Recreation Area 3 | 4 | |
5082 | 5082 | 5081 | {"type": "Polygon", "coordinates": [[[-118.85008, 34.18256], [-118.84998, 34.18289], [-118.84956, 34.1828], [-118.84971, 34.18249], [-118.85008, 34.18256]]]} | Open Access 1 | 15579 | Conejo Recreation and Park District | 17586 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 0.346 | Conejo Rec. and Park District | 0 | Local Recreation Area 3 | 4 | |
5083 | 5083 | 5082 | {"type": "Polygon", "coordinates": [[[-118.89482, 34.22828], [-118.89475, 34.22845], [-118.8946, 34.2284], [-118.8946, 34.22839], [-118.89482, 34.22828]]]} | Open Access 1 | 15581 | Conejo Recreation and Park District | 17586 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 0.041 | Conejo Rec. and Park District | 0 | Local Recreation Area 3 | 4 | |
5243 | 5243 | 5242 | {"type": "Polygon", "coordinates": [[[-118.87309, 34.18644], [-118.87297, 34.18708], [-118.87264, 34.18703], [-118.87276, 34.1864], [-118.87309, 34.18644]]]} | Open Access 1 | 15577 | Conejo Recreation and Park District | 17586 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 0.536 | Conejo Rec. and Park District | 0 | Local Recreation Area 3 | 4 | |
5811 | 5811 | 5810 | {"type": "Polygon", "coordinates": [[[-121.86002, 36.60779], [-121.85928, 36.6088], [-121.85829, 36.60932], [-121.85798, 36.6093], [-121.85783, 36.60901], [-121.86002, 36.60779]]]} | Open Access 1 | 114 | Roberts Lake Open Space | 24493 | 2085 | Monterey Peninsula Regional Park District 47 | Special District 4 | Recreation/Parks District 4 | http://www.mprpd.org/ | Special District 4 | 2085 | Monterey Peninsula Regional Park District 46 | Special District 4 | Recreation/Parks District 4 | Monterey 14 | 2.374 | Roberts Lake OS | 0 | Local Recreation Area 3 | 4 | |
6007 | 6007 | 6006 | {"type": "Polygon", "coordinates": [[[-121.85372, 37.67067], [-121.84528, 37.67162], [-121.84527, 37.67159], [-121.83346, 37.67283], [-121.83347, 37.66804], [-121.83003, 37.6675], [-121.83007, 37.66576], [-121.83764, 37.66573], [-121.84017, 37.66573], [-121.84066, 37.66594], [-121.84179, 37.66599], [-121.84221, 37.66575], [-121.84532, 37.66574], [-121.84531, 37.66757], [-121.84781, 37.6683], [-121.84917, 37.6683], [-121.85004, 37.66837], [-121.85104, 37.66906], [-121.85107, 37.66961], [-121.85181, 37.66963], [-121.8524, 37.66936], [-121.85336, 37.66841], [-121.85372, 37.67067]]]} | Open Access 1 | 690 | Shadow Cliffs Regional Recreation Area | 3312 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/parks/shadow_cliffs | Alameda 17 | 253.728 | Shadow Cliffs Reg. Rec. Area | 1971 | Local Recreation Area 3 | 4 |
6193 | 6193 | 6192 | {"type": "Polygon", "coordinates": [[[-121.56192, 36.44252], [-121.55756, 36.4424], [-121.55754, 36.43877], [-121.54888, 36.43855], [-121.54884, 36.44575], [-121.53978, 36.4455], [-121.53984, 36.4346], [-121.53079, 36.43424], [-121.53081, 36.43057], [-121.53085, 36.42693], [-121.53987, 36.42728], [-121.53986, 36.43096], [-121.5489, 36.43134], [-121.54889, 36.43494], [-121.56186, 36.43525], [-121.56192, 36.44252]]]} | Restricted Access 2 | 18578 | Bloomquist Open Space | 16170 | 2085 | Monterey Peninsula Regional Park District 47 | Special District 4 | Recreation/Parks District 4 | http://www.mprpd.org/ | Special District 4 | 2085 | Monterey Peninsula Regional Park District 46 | Special District 4 | Recreation/Parks District 4 | Monterey 14 | 639.336 | Bloomquist OS | 0 | Local Recreation Area 3 | 4 | |
6263 | 6263 | 6262 | {"type": "Polygon", "coordinates": [[[-121.79058, 36.52123], [-121.79045, 36.52142], [-121.79048, 36.52155], [-121.79052, 36.52163], [-121.79026, 36.52171], [-121.7886, 36.52066], [-121.78871, 36.52058], [-121.78783, 36.5197], [-121.78919, 36.51943], [-121.7892, 36.51992], [-121.78948, 36.52042], [-121.78993, 36.52087], [-121.79025, 36.52083], [-121.79058, 36.52123]]]} | No Public Access 3 | 1348 | Thomas Open Space | 26308 | 2085 | Monterey Peninsula Regional Park District 47 | Special District 4 | Recreation/Parks District 4 | http://www.mprpd.org/ | Special District 4 | 2085 | Monterey Peninsula Regional Park District 46 | Special District 4 | Recreation/Parks District 4 | Monterey 14 | 5.313 | Thomas OS | 0 | Local Recreation Area 3 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
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]);