units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
50 rows where MNG_AGENCY = 12 sorted by map
This data as json, copyable, CSV (advanced)
DES_TP 5
- Local Park 15
- Local Recreation Area 12
- None 1
- None 1
- None 1
ACCESS_TYP 2
MNG_AG_TYP 1
MNG_AGENCY 1
- Conejo Recreation and Park District · 30 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
10322 | 10322 | 10321 | {"type": "Polygon", "coordinates": [[[-118.85556, 34.22802], [-118.85545, 34.22805], [-118.85539, 34.22811], [-118.85543, 34.22823], [-118.85552, 34.22828], [-118.85555, 34.22841], [-118.85548, 34.22863], [-118.8552, 34.22915], [-118.85463, 34.22899], [-118.85454, 34.22889], [-118.85439, 34.22879], [-118.85362, 34.22847], [-118.8536, 34.22845], [-118.85371, 34.22828], [-118.85414, 34.2279], [-118.85421, 34.22776], [-118.85421, 34.22754], [-118.85414, 34.22727], [-118.85401, 34.22706], [-118.85386, 34.22687], [-118.85387, 34.22683], [-118.85432, 34.22654], [-118.85443, 34.22642], [-118.85454, 34.22635], [-118.85459, 34.22648], [-118.85474, 34.22652], [-118.85478, 34.22656], [-118.85498, 34.22696], [-118.85513, 34.22716], [-118.85534, 34.2274], [-118.85546, 34.22758], [-118.85548, 34.2277], [-118.8554, 34.22776], [-118.85536, 34.22784], [-118.8554, 34.22794], [-118.85552, 34.22798], [-118.85556, 34.22802]]]} | Open Access 1 | 18181 | Northwood Field | 22900 | 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 | 7.839 | Northwood Field | 0 | Local Recreation Area 3 | 4 | |
547 | 547 | 546 | {"type": "Polygon", "coordinates": [[[-118.85957, 34.20397], [-118.85928, 34.20419], [-118.85956, 34.20468], [-118.85943, 34.20577], [-118.85902, 34.20577], [-118.85882, 34.2057], [-118.85753, 34.20575], [-118.85776, 34.20423], [-118.85881, 34.20412], [-118.85882, 34.20405], [-118.85957, 34.20397]]]} | Open Access 1 | 1822 | Waverly Park | 27320 | 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 | 7.419 | Waverly Park | 0 | Local Park 2 | 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 | |
9739 | 9739 | 9738 | {"type": "Polygon", "coordinates": [[[-118.86726, 34.19633], [-118.86683, 34.19687], [-118.86428, 34.19547], [-118.8647, 34.19494], [-118.86726, 34.19633]]]} | Open Access 1 | 16532 | Glenwood Park - CRPD | 19342 | 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 | 4.942 | Glenwood Park - CRPD | None 840 | |||
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 | |
303 | 303 | 302 | {"type": "Polygon", "coordinates": [[[-118.87425, 34.22586], [-118.87258, 34.2261], [-118.87258, 34.22433], [-118.87408, 34.22434], [-118.87409, 34.22539], [-118.87418, 34.22551], [-118.87425, 34.22586]]]} | Open Access 1 | 1040 | Spring Meadow Park | 25741 | 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 | 6.467 | Spring Meadow Park | 0 | Local Park 2 | 4 | |
6270 | 6270 | 6269 | {"type": "Polygon", "coordinates": [[[-118.87703, 34.21508], [-118.87645, 34.21466], [-118.87557, 34.21452], [-118.87486, 34.21462], [-118.87459, 34.21496], [-118.87384, 34.21499], [-118.87344, 34.21466], [-118.87295, 34.2147], [-118.8727, 34.21454], [-118.87223, 34.21473], [-118.87187, 34.21497], [-118.87153, 34.21493], [-118.87125, 34.21476], [-118.87094, 34.21475], [-118.87054, 34.2148], [-118.87016, 34.21479], [-118.86963, 34.21485], [-118.86949, 34.21492], [-118.86936, 34.21507], [-118.86896, 34.2152], [-118.86854, 34.21519], [-118.86852, 34.21476], [-118.86856, 34.21447], [-118.86849, 34.21409], [-118.86846, 34.21305], [-118.87414, 34.21307], [-118.87414, 34.21362], [-118.87702, 34.21363], [-118.87703, 34.21508]]]} | Open Access 1 | 1363 | Thousand Oaks | 26324 | 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 | 33.506 | Thousand Oaks | None 507 | |||
7852 | 7852 | 7851 | {"type": "Polygon", "coordinates": [[[-118.88693, 34.1936], [-118.88605, 34.19425], [-118.88556, 34.19474], [-118.88529, 34.19526], [-118.88504, 34.19557], [-118.88467, 34.19583], [-118.88431, 34.19598], [-118.8841, 34.19575], [-118.88457, 34.19548], [-118.88322, 34.19378], [-118.88286, 34.19373], [-118.8822, 34.19458], [-118.88163, 34.19428], [-118.87974, 34.19429], [-118.87942, 34.19353], [-118.87967, 34.19336], [-118.87947, 34.1931], [-118.87883, 34.19284], [-118.87883, 34.19248], [-118.87846, 34.19222], [-118.87706, 34.19211], [-118.8771, 34.19192], [-118.87688, 34.19167], [-118.87658, 34.19161], [-118.8762, 34.19174], [-118.8758, 34.19176], [-118.8758, 34.1912], [-118.87655, 34.19114], [-118.87705, 34.19087], [-118.8775, 34.19095], [-118.87799, 34.19092], [-118.87834, 34.19115], [-118.87874, 34.19139], [-118.87875, 34.19143], [-118.87921, 34.19158], [-118.87955, 34.19163], [-118.87983, 34.19158], [-118.88013, 34.19136], [-118.88139, 34.19171], [-118.88198, 34.19221], [-118.88275, 34.19202], [-118.88288, 34.19236], [-118.88457, 34.19262], [-118.88693, 34.1936]]]} | Open Access 1 | 9395 | Conejo Community Park | 17582 | 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 | 48.818 | Conejo Community Park | 0 | Local Park 2 | 4 | |
6157 | 6157 | 6156 | {"type": "Polygon", "coordinates": [[[-118.88711, 34.21497], [-118.88689, 34.21498], [-118.88666, 34.21501], [-118.88646, 34.21506], [-118.88596, 34.2153], [-118.88574, 34.21535], [-118.88576, 34.21449], [-118.88637, 34.21451], [-118.88663, 34.21455], [-118.88693, 34.21469], [-118.88707, 34.21482], [-118.88711, 34.21497]]]} | Open Access 1 | 1170 | Suburbia Park | 25941 | 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 | 1.891 | Suburbia Park | 0 | Local Park 2 | 4 | |
5733 | 5733 | 5732 | {"type": "Polygon", "coordinates": [[[-118.889, 34.19027], [-118.88799, 34.19209], [-118.88636, 34.19336], [-118.88457, 34.19262], [-118.88288, 34.19236], [-118.88275, 34.19202], [-118.88268, 34.19161], [-118.88253, 34.19161], [-118.88252, 34.19146], [-118.88264, 34.1915], [-118.88284, 34.19119], [-118.88317, 34.19133], [-118.88578, 34.19087], [-118.88625, 34.18977], [-118.88788, 34.18977], [-118.88858, 34.18921], [-118.88873, 34.18936], [-118.88887, 34.18964], [-118.88894, 34.19005], [-118.889, 34.19027]]]} | Open Access 1 | 1649 | California Botanic Garden | 16686 | 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 | 32.578 | California Botanic Garden | 0 | Local Park 2 | 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 | |
6411 | 6411 | 6410 | {"type": "Polygon", "coordinates": [[[-118.89794, 34.2191], [-118.89793, 34.21915], [-118.89758, 34.21917], [-118.89736, 34.21956], [-118.89723, 34.21963], [-118.89685, 34.22], [-118.89682, 34.22008], [-118.89663, 34.22017], [-118.89628, 34.22], [-118.89553, 34.21901], [-118.89381, 34.21849], [-118.89343, 34.2182], [-118.89323, 34.21818], [-118.89319, 34.21816], [-118.89308, 34.21814], [-118.89292, 34.21802], [-118.89258, 34.21796], [-118.89178, 34.21774], [-118.89125, 34.21762], [-118.89129, 34.21739], [-118.89139, 34.2172], [-118.89162, 34.21689], [-118.89169, 34.2167], [-118.89177, 34.21643], [-118.89185, 34.21642], [-118.89793, 34.21868], [-118.89762, 34.2191], [-118.89763, 34.21912], [-118.89794, 34.2191]]]} | Open Access 1 | 1873 | Wildflower Playfield | 27513 | 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 | 21.318 | Wildflower Playfield | 0 | Local Recreation Area 3 | 4 | |
540 | 540 | 539 | {"type": "Polygon", "coordinates": [[[-118.8993, 34.1842], [-118.89897, 34.18424], [-118.89814, 34.18437], [-118.89767, 34.18434], [-118.89715, 34.18448], [-118.89638, 34.18443], [-118.89611, 34.18408], [-118.89593, 34.18404], [-118.89683, 34.18341], [-118.8969, 34.18346], [-118.89768, 34.18368], [-118.89819, 34.18346], [-118.89872, 34.18292], [-118.89889, 34.18303], [-118.89887, 34.18356], [-118.8993, 34.1842]]]} | Open Access 1 | 1801 | Walnut Grove Park | 27233 | 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 | 6.623 | Walnut Grove Park | 0 | Local Park 2 | 4 | |
2046 | 2046 | 2045 | {"type": "Polygon", "coordinates": [[[-118.90087, 34.21526], [-118.90083, 34.21549], [-118.90044, 34.21561], [-118.90035, 34.21547], [-118.90019, 34.21531], [-118.90026, 34.21519], [-118.90029, 34.21507], [-118.90075, 34.21508], [-118.90087, 34.21526]]]} | Open Access 1 | 15585 | 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.656 | Conejo Rec. and Park District | 0 | Local Recreation Area 3 | 4 | |
16805 | 16805 | 16804 | {"type": "Polygon", "coordinates": [[[-118.90091, 34.2165], [-118.90088, 34.21655], [-118.90042, 34.2164], [-118.90045, 34.21635], [-118.90091, 34.2165]]]} | Open Access 1 | 15583 | 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.068 | Conejo Rec. and Park District | 0 | Local Recreation Area 3 | 4 | |
532 | 532 | 531 | {"type": "Polygon", "coordinates": [[[-118.90336, 34.18406], [-118.90262, 34.18413], [-118.8993, 34.1842], [-118.89928, 34.18407], [-118.89887, 34.18356], [-118.89889, 34.18303], [-118.89872, 34.18292], [-118.89961, 34.18202], [-118.8998, 34.18225], [-118.90006, 34.18231], [-118.90027, 34.18246], [-118.90028, 34.18262], [-118.90087, 34.18263], [-118.90133, 34.18247], [-118.9018, 34.18266], [-118.9019, 34.18329], [-118.90208, 34.18388], [-118.90268, 34.18407], [-118.90324, 34.18397], [-118.90324, 34.18342], [-118.90333, 34.18327], [-118.90336, 34.18406]]]} | Open Access 1 | 1797 | Walnut Grove Equestrian Center | 27229 | 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 | 13.391 | Walnut Grove Equestrian Ctr. | 0 | Local Recreation Area 3 | 4 | |
368 | 368 | 367 | {"type": "Polygon", "coordinates": [[[-118.91305, 34.18088], [-118.91256, 34.18067], [-118.912, 34.18037], [-118.91123, 34.18041], [-118.91136, 34.17666], [-118.91295, 34.17687], [-118.91305, 34.18088]]]} | Open Access 1 | 1056 | Stagecoach Inn Park | 25777 | 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 | 16.214 | Stagecoach Inn Park | 0 | Local Park 2 | 4 | |
10035 | 10035 | 10034 | {"type": "Polygon", "coordinates": [[[-118.91346, 34.1918], [-118.91347, 34.19185], [-118.91314, 34.19327], [-118.91295, 34.19374], [-118.91274, 34.1941], [-118.91103, 34.19338], [-118.91104, 34.19313], [-118.91127, 34.19297], [-118.91135, 34.19285], [-118.9113, 34.1927], [-118.91116, 34.19248], [-118.91116, 34.1923], [-118.91106, 34.19213], [-118.91111, 34.192], [-118.91111, 34.19186], [-118.91106, 34.19169], [-118.91094, 34.19154], [-118.91101, 34.1914], [-118.911, 34.19126], [-118.91079, 34.19126], [-118.91076, 34.19098], [-118.91161, 34.19059], [-118.91181, 34.19085], [-118.91194, 34.19099], [-118.91213, 34.19116], [-118.91232, 34.1913], [-118.91251, 34.19142], [-118.91281, 34.19157], [-118.91346, 34.1918]]]} | Open Access 1 | 18901 | Rancho Conejo Playfield | 24135 | 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 | 14.343 | Rancho Conejo Playfield | 0 | Local Recreation Area 3 | 4 | |
2649 | 2649 | 2648 | {"type": "Polygon", "coordinates": [[[-118.92828, 34.17927], [-118.92827, 34.17981], [-118.9281, 34.18001], [-118.92782, 34.18015], [-118.92755, 34.18041], [-118.92724, 34.18051], [-118.92703, 34.18066], [-118.92722, 34.18095], [-118.92737, 34.18092], [-118.92746, 34.18099], [-118.9274, 34.18111], [-118.92771, 34.18141], [-118.92733, 34.18174], [-118.92674, 34.18145], [-118.92554, 34.18141], [-118.9251, 34.18136], [-118.92529, 34.1803], [-118.92553, 34.1803], [-118.92596, 34.18017], [-118.92604, 34.17943], [-118.92614, 34.17943], [-118.9264, 34.17961], [-118.9263, 34.17969], [-118.92648, 34.18011], [-118.9265, 34.18031], [-118.92672, 34.18048], [-118.92732, 34.18029], [-118.92767, 34.17993], [-118.92792, 34.17939], [-118.92804, 34.17906], [-118.92828, 34.17927]]]} | Open Access 1 | 18114 | Newbury Gateway Park | 22716 | 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 | 8.503 | Newbury Gateway Park | 0 | Local Park 2 | 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]);