units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
61 rows where MNG_AGENCY = 185 and MNG_AG_TYP = 2 sorted by LABEL_NAME
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, LABEL_NAME, YR_EST, GAP_STS
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14471 | 14471 | 14470 | {"type": "Polygon", "coordinates": [[[-117.32246, 33.95383], [-117.32245, 33.95457], [-117.32188, 33.95454], [-117.32112, 33.95458], [-117.32047, 33.95466], [-117.31985, 33.95479], [-117.31984, 33.95381], [-117.32246, 33.95383]]]} | Open Access 1 | 47101 | Ameal Moore Nature Center | 30760 | 1279 | Riverside, City of 189 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | Riverside 10 | 5.254 | Ameal Moore Nature Ctr. | 0 | Local Park 2 | 4 | |
12123 | 12123 | 12122 | {"type": "Polygon", "coordinates": [[[-117.35103, 33.96113], [-117.35035, 33.96114], [-117.34983, 33.96116], [-117.34983, 33.96112], [-117.34864, 33.96037], [-117.34863, 33.96099], [-117.34849, 33.961], [-117.34849, 33.96038], [-117.34803, 33.95977], [-117.34669, 33.95629], [-117.34676, 33.95612], [-117.34851, 33.95588], [-117.34851, 33.9561], [-117.34852, 33.95611], [-117.34884, 33.95582], [-117.35026, 33.9561], [-117.3503, 33.95661], [-117.35047, 33.95689], [-117.3503, 33.957], [-117.35022, 33.95758], [-117.35018, 33.95805], [-117.35018, 33.95823], [-117.35026, 33.95849], [-117.35055, 33.9584], [-117.3507, 33.95873], [-117.35049, 33.95894], [-117.35028, 33.95967], [-117.35028, 33.95989], [-117.3503, 33.95993], [-117.35034, 33.95995], [-117.35057, 33.95994], [-117.35086, 33.95982], [-117.35102, 33.96057], [-117.35096, 33.96062], [-117.35103, 33.96113]]]} | Open Access 1 | 25074 | Andulka Park | 15488 | 1279 | Riverside, City of 189 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | Riverside 10 | 36.517 | Andulka Park | 0 | Local Park 2 | 4 | |
13161 | 13161 | 13160 | {"type": "Polygon", "coordinates": [[[-117.46674, 33.9428], [-117.46599, 33.9428], [-117.46595, 33.94279], [-117.46591, 33.94273], [-117.46591, 33.94235], [-117.46674, 33.94235], [-117.46674, 33.9428]]]} | Open Access 1 | 48820 | Arlanza Community Garden | 33539 | 1279 | Riverside, City of 189 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | https://www.riversideca.gov/mayor/fitfreshfunriverside/community.asp | Riverside 10 | 0.937 | Arlanza Community Garden | 0 | Local Park 2 | 4 |
14846 | 14846 | 14845 | {"type": "Polygon", "coordinates": [[[-117.4311, 33.90173], [-117.43346, 33.90466], [-117.43347, 33.90469], [-117.43345, 33.90471], [-117.43013, 33.90662], [-117.43009, 33.90663], [-117.43006, 33.90661], [-117.42888, 33.90516], [-117.42945, 33.90482], [-117.42825, 33.90334], [-117.4311, 33.90173]]]} | Open Access 1 | 45361 | Arlington Heights Sports Park Picnic Area | 15588 | 1279 | Riverside, City of 189 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | Riverside 10 | 34.333 | Arlington Heights Sports Park Picnic Area | 0 | Local Recreation Area 3 | 4 | |
2667 | 2667 | 2666 | {"type": "Polygon", "coordinates": [[[-117.44922, 33.92097], [-117.44787, 33.92173], [-117.4472, 33.9209], [-117.44883, 33.91998], [-117.44921, 33.92046], [-117.44896, 33.92062], [-117.44922, 33.92097]]]} | Open Access 1 | 18187 | Arlington Park | 15590 | 1279 | Riverside, City of 189 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | Riverside 10 | 4.645 | Arlington Park | 0 | Local Park 2 | 4 | |
11996 | 11996 | 11995 | {"type": "Polygon", "coordinates": [[[-117.3249, 33.88653], [-117.32405, 33.88669], [-117.32397, 33.8864], [-117.32373, 33.88644], [-117.3233, 33.88487], [-117.32336, 33.88494], [-117.32345, 33.88497], [-117.32371, 33.88491], [-117.32477, 33.8849], [-117.3248, 33.88491], [-117.32467, 33.88518], [-117.32464, 33.88533], [-117.32463, 33.88553], [-117.32465, 33.88565], [-117.3249, 33.88653]]]} | Open Access 1 | 24654 | Bergmont Park | 16021 | 1279 | Riverside, City of 189 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | Riverside 10 | 5.031 | Bergmont Park | 0 | Local Park 2 | 4 | |
5463 | 5463 | 5462 | {"type": "Polygon", "coordinates": [[[-117.35709, 33.97285], [-117.35709, 33.97395], [-117.356, 33.97398], [-117.35595, 33.97467], [-117.35505, 33.97466], [-117.35504, 33.97285], [-117.35709, 33.97285]]]} | Open Access 1 | 6271 | Bobby Bonds Park and Sports Complex | 16213 | 1279 | Riverside, City of 189 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | Riverside 10 | 7.442 | Bobby Bonds Park and Sports Complex | 0 | Local Recreation Area 3 | 4 | |
3777 | 3777 | 3776 | {"type": "Polygon", "coordinates": [[[-117.35709, 33.96642], [-117.35708, 33.96793], [-117.35707, 33.96798], [-117.35703, 33.96801], [-117.35503, 33.96801], [-117.35501, 33.96725], [-117.35294, 33.96728], [-117.35296, 33.9646], [-117.35502, 33.96459], [-117.35502, 33.96601], [-117.35509, 33.96605], [-117.35538, 33.96619], [-117.35571, 33.96627], [-117.3565, 33.96639], [-117.35681, 33.96642], [-117.35709, 33.96642]]]} | Open Access 1 | 8570 | Bordwell Park | 16282 | 1279 | Riverside, City of 189 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | Riverside 10 | 22.989 | Bordwell Park | 0 | Local Park 2 | 4 | |
7637 | 7637 | 7636 | {"type": "Polygon", "coordinates": [[[-117.46151, 33.93868], [-117.46151, 33.93891], [-117.46149, 33.93896], [-117.46143, 33.93898], [-117.45898, 33.93897], [-117.45902, 33.937], [-117.45903, 33.93485], [-117.45964, 33.93506], [-117.46119, 33.93554], [-117.46115, 33.93867], [-117.46151, 33.93868]]]} | Open Access 1 | 11597 | Bryant Park | 16458 | 1279 | Riverside, City of 189 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | Riverside 10 | 20.908 | Bryant Park | 0 | Local Park 2 | 4 | |
16511 | 16511 | 16510 | {"type": "MultiPolygon", "coordinates": [[[[-117.42036, 33.89827], [-117.41851, 33.89932], [-117.4162, 33.8965], [-117.41663, 33.89624], [-117.41665, 33.89616], [-117.41647, 33.89589], [-117.41644, 33.89575], [-117.41647, 33.89559], [-117.41663, 33.89533], [-117.41535, 33.89528], [-117.4153, 33.89523], [-117.41665, 33.89524], [-117.41632, 33.89488], [-117.41609, 33.89488], [-117.41566, 33.89478], [-117.41492, 33.89449], [-117.41484, 33.89459], [-117.41385, 33.89471], [-117.41322, 33.89429], [-117.41256, 33.89429], [-117.41204, 33.89435], [-117.412, 33.89406], [-117.41183, 33.89388], [-117.41166, 33.89379], [-117.41111, 33.89291], [-117.41054, 33.89225], [-117.4102, 33.89208], [-117.41, 33.89204], [-117.40959, 33.89169], [-117.4093, 33.89168], [-117.40904, 33.89161], [-117.40943, 33.89155], [-117.40951, 33.8914], [-117.40941, 33.89114], [-117.4096, 33.89087], [-117.40925, 33.89053], [-117.40871, 33.89016], [-117.40837, 33.88975], [-117.40834, 33.8893], [-117.40809, 33.88889], [-117.40735, 33.88827], [-117.40711, 33.88799], [-117.40725, 33.88721], [-117.40755, 33.88702], [-117.4097, 33.88701], [-117.40989, 33.88734], [-117.40977, 33.88754], [-117.4093, 33.88773], [-117.40926, 33.88786], [-117.40949, 33.88808], [-117.40985, 33.88821], [-117.40998, 33.88863], [-117.41021, 33.88855], [-117.41045, 33.88821], [-117.41049, 33.88849], [-117.4106, 33.88852], [-117.41085, 33.88845], [-117.41084, 33.88867], [-117.41128, 33.88888], [-117.41121, 33.88913], [-117.41144, 33.88925], [-117.41134, 33.88943], [-117.41159, 33.88938], [-117.4116, 33.88955], [-117.41174, 33.88952], [-117.41175, 33.88963], [-117.41186, 33.88968], [-117.41184, 33.88987], [-117.41195, 33.88993], [-117.41194, 33.89031], [-117.41236, 33.89029], [-117.41254, 33.89021], [-117.41272, 33.89], [-117.41285, 33.88995], [-117.41287, 33.89013], [-117.413, 33.89022], [-117.41309, 33.89036], [-117.41332, 33.89056], [-117.4133, 33.8907], [-117.41341, 33.89088], [-117.41333, 33.891], [-117.41336, 33.89147], [-117.4133, 33.89158], [-117.4134, 33.89163], [-117.41354, 33.89164], [-117.4135, 33.89185], [-117.41376, 33.89199], [-117.41404, 33.89198], [-117.4144, 33.89203], [-117.41451, 33.89196], [-117.41431, 33.89159], [-117.41442, 33.89158], [-117.41441, 33.89148], [-117.41446, 33.89129], [-117.41441, 33.89119], [-117.41443, 33.89103], [-117.41431, 33.89089], [-117.41431, 33.89082], [-117.41447, 33.89082], [-117.41453, 33.8907], [-117.41438, 33.89054], [-117.41427, 33.89011], [-117.41449, 33.89053], [-117.41464, 33.89057], [-117.41472, 33.89067], [-117.41473, 33.89083], [-117.41482, 33.89098], [-117.41493, 33.89086], [-117.415, 33.89084], [-117.4151, 33.89065], [-117.41511, 33.8908], [-117.41518, 33.89084], [-117.41508, 33.89094], [-117.41511, 33.89106], [-117.41541, 33.89094], [-117.41584, 33.89039], [-117.41797, 33.89199], [-117.418, 33.89201], [-117.41759, 33.89239], [-117.41755, 33.89263], [-117.41808, 33.8932], [-117.41845, 33.89311], [-117.41869, 33.89345], [-117.41907, 33.89345], [-117.4193, 33.89373], [-117.41976, 33.89373], [-117.42014, 33.8941], [-117.42015, 33.89415], [-117.42003, 33.89418], [-117.41986, 33.89428], [-117.41995, 33.89439], [-117.42012, 33.89439], [-117.42021, 33.89448], [-117.42029, 33.89534], [-117.42006, 33.89559], [-117.41899, 33.89581], [-117.4186, 33.89529], [-117.41837, 33.89535], [-117.41812, 33.89552], [-117.42036, 33.89827]]], [[[-117.42232, 33.90418], [-117.41881, 33.90616], [-117.41756, 33.90463], [-117.42107, 33.90265], [-117.42232, 33.90418]]], [[[-117.42967, 33.90001], [-117.42254, 33.90406], [-117.42128, 33.90253], [-117.42311, 33.90146], [-117.42331, 33.90095], [-117.42404, 33.89999], [-117.42415, 33.8999], [-117.42428, 33.89985], [-117.42441, 33.89984], [-117.42454, 33.89986], [-117.42466, 33.89992], [-117.42483, 33.89998], [-117.42567, 33.90001], [-117.4284, 33.89846], [-117.42967, 33.90001]]]]} | Open Access 1 | 30006 | California Citrus State Historic Park | 16687 | 1279 | Riverside, City of 189 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | Riverside 10 | 193.189 | California Citrus SHP | 1984 | None 1410 | ||
4068 | 4068 | 4067 | {"type": "Polygon", "coordinates": [[[-117.39209, 33.98971], [-117.39155, 33.99036], [-117.39049, 33.99022], [-117.3899, 33.99009], [-117.39089, 33.98988], [-117.39165, 33.98966], [-117.39171, 33.98965], [-117.39171, 33.98967], [-117.39188, 33.98967], [-117.39209, 33.98971]]]} | Open Access 1 | 44442 | Carlson Park | 16863 | 1279 | Riverside, City of 189 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | Riverside 10 | 1.898 | Carlson Park | 0 | Local Park 2 | 4 | |
1910 | 1910 | 1909 | {"type": "Polygon", "coordinates": [[[-117.34809, 33.93534], [-117.34809, 33.93619], [-117.3482, 33.93658], [-117.34818, 33.93665], [-117.34811, 33.93669], [-117.3475, 33.93651], [-117.34756, 33.93624], [-117.34586, 33.9359], [-117.34435, 33.93551], [-117.34434, 33.93552], [-117.34434, 33.9358], [-117.34253, 33.93534], [-117.34234, 33.9353], [-117.34208, 33.93528], [-117.34018, 33.93528], [-117.34011, 33.93522], [-117.34011, 33.93487], [-117.34017, 33.93481], [-117.34046, 33.93475], [-117.34074, 33.93466], [-117.34112, 33.93447], [-117.34134, 33.93431], [-117.34216, 33.9336], [-117.34244, 33.93341], [-117.34274, 33.93325], [-117.34317, 33.9331], [-117.34351, 33.93301], [-117.34386, 33.93297], [-117.34435, 33.93296], [-117.34435, 33.93385], [-117.34516, 33.93385], [-117.34628, 33.93481], [-117.34664, 33.93477], [-117.34705, 33.93527], [-117.34732, 33.93509], [-117.34747, 33.93521], [-117.34765, 33.93529], [-117.3478, 33.93532], [-117.34808, 33.93533], [-117.34809, 33.93534]]]} | Open Access 1 | 14787 | Castleview Park | 16959 | 1279 | Riverside, City of 189 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | Riverside 10 | 31.36 | Castleview Park | 0 | Local Park 2 | 4 | |
10698 | 10698 | 10697 | {"type": "Polygon", "coordinates": [[[-117.45939, 33.92471], [-117.45996, 33.92582], [-117.46002, 33.92601], [-117.46004, 33.92623], [-117.46002, 33.92641], [-117.45998, 33.92658], [-117.45933, 33.92831], [-117.45763, 33.92787], [-117.45744, 33.92783], [-117.45553, 33.92783], [-117.45536, 33.92785], [-117.45518, 33.92791], [-117.45519, 33.92631], [-117.45527, 33.92629], [-117.45526, 33.92568], [-117.45773, 33.92493], [-117.45804, 33.92488], [-117.45891, 33.92481], [-117.45916, 33.92477], [-117.45939, 33.92471]]]} | Open Access 1 | 19858 | Challen Hill Park | 17115 | 1279 | Riverside, City of 189 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | Riverside 10 | 33.132 | Challen Hill Park | 0 | Local Park 2 | 4 | |
2924 | 2924 | 2923 | {"type": "Polygon", "coordinates": [[[-117.48066, 33.91287], [-117.48064, 33.91295], [-117.47958, 33.9135], [-117.47841, 33.91207], [-117.47877, 33.91192], [-117.47881, 33.91196], [-117.47887, 33.91198], [-117.47899, 33.91197], [-117.47904, 33.91192], [-117.47912, 33.9118], [-117.4792, 33.91173], [-117.47953, 33.91154], [-117.47959, 33.91155], [-117.48066, 33.91287]]]} | Open Access 1 | 19855 | Collett Park | 17517 | 1279 | Riverside, City of 189 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | Riverside 10 | 5.616 | Collett Park | 0 | Local Park 2 | 4 | |
10701 | 10701 | 10700 | {"type": "Polygon", "coordinates": [[[-117.36263, 33.97145], [-117.36167, 33.97146], [-117.36167, 33.97143], [-117.36207, 33.97142], [-117.36206, 33.97072], [-117.36167, 33.97071], [-117.36167, 33.97062], [-117.36175, 33.97047], [-117.36181, 33.97046], [-117.36219, 33.97059], [-117.36224, 33.97066], [-117.36251, 33.97097], [-117.36262, 33.97106], [-117.36263, 33.97145]]]} | Open Access 1 | 19862 | Dario Vasquez Park | 17926 | 1279 | Riverside, City of 189 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | Riverside 10 | 1.193 | Dario Vasquez Park | 0 | Local Park 2 | 4 | |
1295 | 1295 | 1294 | {"type": "Polygon", "coordinates": [[[-117.42388, 33.91938], [-117.41909, 33.92211], [-117.41862, 33.92237], [-117.41949, 33.92047], [-117.41964, 33.92019], [-117.41975, 33.92002], [-117.42093, 33.91887], [-117.42114, 33.91856], [-117.42201, 33.91709], [-117.42388, 33.91938]]]} | Open Access 1 | 5722 | Don Derr Park | 18202 | 1279 | Riverside, City of 189 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | Riverside 10 | 23.992 | Don Derr Park | 0 | Local Park 2 | 4 | |
9119 | 9119 | 9118 | {"type": "Polygon", "coordinates": [[[-117.41925, 33.9404], [-117.41735, 33.94148], [-117.41678, 33.94078], [-117.41675, 33.94072], [-117.41676, 33.94066], [-117.41681, 33.9406], [-117.41858, 33.93959], [-117.41925, 33.9404]]]} | Open Access 1 | 18705 | Don Jones Park | 18205 | 1279 | Riverside, City of 189 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | Riverside 10 | 5.714 | Don Jones Park | 0 | Local Park 2 | 4 | |
9396 | 9396 | 9395 | {"type": "Polygon", "coordinates": [[[-117.44487, 33.92816], [-117.44309, 33.92917], [-117.44256, 33.92851], [-117.44257, 33.92847], [-117.44432, 33.92748], [-117.44487, 33.92816]]]} | Open Access 1 | 18711 | Don Lorenzi Sports Center | 18206 | 1279 | Riverside, City of 189 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | Riverside 10 | 4.492 | Don Lorenzi Sports Ctr. | 0 | Local Recreation Area 3 | 4 | |
2926 | 2926 | 2925 | {"type": "Polygon", "coordinates": [[[-117.44729, 33.93129], [-117.44564, 33.93223], [-117.44557, 33.93222], [-117.44446, 33.93087], [-117.44445, 33.93083], [-117.44448, 33.9308], [-117.44622, 33.92979], [-117.44646, 33.93007], [-117.44651, 33.93028], [-117.44658, 33.93041], [-117.44729, 33.93129]]]} | Open Access 1 | 19857 | Don Lorenzi Sports Park | 18207 | 1279 | Riverside, City of 189 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | Riverside 10 | 9.204 | Don Lorenzi Sports Park | 0 | Local Recreation Area 3 | 4 | |
10703 | 10703 | 10702 | {"type": "MultiPolygon", "coordinates": [[[[-117.45748, 33.93032], [-117.45696, 33.93055], [-117.45685, 33.9303], [-117.45635, 33.9303], [-117.45634, 33.92971], [-117.45667, 33.92988], [-117.45692, 33.92988], [-117.45719, 33.92984], [-117.45748, 33.93032]]], [[[-117.46005, 33.93408], [-117.45945, 33.93387], [-117.45903, 33.93388], [-117.45891, 33.93342], [-117.45839, 33.93258], [-117.45813, 33.93269], [-117.45809, 33.93262], [-117.45833, 33.9325], [-117.45785, 33.93171], [-117.45762, 33.93157], [-117.45742, 33.93157], [-117.45754, 33.93125], [-117.45743, 33.93101], [-117.45709, 33.93091], [-117.45701, 33.93071], [-117.45758, 33.93047], [-117.45766, 33.93059], [-117.45798, 33.93077], [-117.45806, 33.93088], [-117.45868, 33.93185], [-117.45891, 33.93175], [-117.45898, 33.93186], [-117.45875, 33.93198], [-117.4592, 33.93271], [-117.45924, 33.93286], [-117.45933, 33.93298], [-117.45956, 33.93287], [-117.45967, 33.93295], [-117.45957, 33.93316], [-117.4598, 33.93348], [-117.45976, 33.93354], [-117.45977, 33.93361], [-117.4598, 33.93366], [-117.45989, 33.93372], [-117.45993, 33.93376], [-117.46002, 33.93393], [-117.46005, 33.93408]]]]} | Open Access 1 | 19859 | El Dorado Open Space Park | 18503 | 1279 | Riverside, City of 189 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | Riverside 10 | 8.427 | El Dorado OS Park | 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]);