units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
50 rows where AGNCY_NAME = 12 and MNG_AG_TYP = 4 sorted by UNIT_NAME descending
This data as json, copyable, CSV (advanced)
DES_TP 13
- Local Park 25
- Local Recreation Area 14
- Local Other or Unknown 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 2
MNG_AG_TYP 1
- Recreation/Parks District · 50 ✖
MNG_AGENCY 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
4242 | 4242 | 4241 | {"type": "Polygon", "coordinates": [[[-118.94369, 34.16333], [-118.94355, 34.16348], [-118.94315, 34.16401], [-118.94287, 34.16382], [-118.94286, 34.16377], [-118.94279, 34.16371], [-118.9427, 34.1637], [-118.94262, 34.16372], [-118.94225, 34.1635], [-118.94154, 34.16295], [-118.94176, 34.16283], [-118.94193, 34.16276], [-118.94216, 34.1627], [-118.94291, 34.16259], [-118.94299, 34.16255], [-118.94306, 34.16249], [-118.94351, 34.16271], [-118.94365, 34.16329], [-118.94369, 34.16333]]]} | Open Access 1 | 1828 | Wendy Park | 27346 | 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.537 | Wendy Park | 0 | Local Park 2 | 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 | |
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 | |
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 | |
450 | 450 | 449 | {"type": "Polygon", "coordinates": [[[-118.84969, 34.15691], [-118.84861, 34.15729], [-118.8484, 34.15705], [-118.84823, 34.15692], [-118.8481, 34.15686], [-118.84745, 34.15669], [-118.8474, 34.15675], [-118.84724, 34.15671], [-118.84701, 34.15669], [-118.84647, 34.15673], [-118.84613, 34.15674], [-118.84609, 34.15669], [-118.84529, 34.15636], [-118.84513, 34.15634], [-118.84475, 34.15615], [-118.84455, 34.15601], [-118.84392, 34.15522], [-118.84377, 34.15509], [-118.84351, 34.15491], [-118.84278, 34.1546], [-118.84282, 34.15435], [-118.84282, 34.15411], [-118.84286, 34.15404], [-118.84303, 34.154], [-118.84331, 34.15383], [-118.84351, 34.15362], [-118.84361, 34.1534], [-118.8436, 34.15311], [-118.84357, 34.15296], [-118.84413, 34.15317], [-118.84731, 34.15444], [-118.84968, 34.15512], [-118.84969, 34.15691]]]} | Open Access 1 | 1427 | Triunfo Park | 7237 | 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 | http://www.lamountains.com/parks.asp?parkid=62 | Ventura 8 | 38.958 | Triunfo 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 | |||
6200 | 6200 | 6199 | {"type": "Polygon", "coordinates": [[[-118.84264, 34.22414], [-118.84277, 34.2245], [-118.84284, 34.22504], [-118.8428, 34.22545], [-118.84258, 34.22591], [-118.84137, 34.22564], [-118.84038, 34.22537], [-118.84049, 34.22512], [-118.84112, 34.2251], [-118.84156, 34.22492], [-118.84187, 34.22457], [-118.84223, 34.22426], [-118.84264, 34.22414]]]} | Open Access 1 | 1240 | Sunset Hills Park | 26049 | 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 | 5.612 | Sunset Hills 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 | |
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 | |
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 | |
358 | 358 | 357 | {"type": "Polygon", "coordinates": [[[-118.84164, 34.14351], [-118.84162, 34.14361], [-118.84153, 34.1437], [-118.84153, 34.14379], [-118.84163, 34.14385], [-118.84147, 34.14417], [-118.84155, 34.14456], [-118.8412, 34.14464], [-118.84027, 34.14465], [-118.83984, 34.1442], [-118.83987, 34.14412], [-118.84004, 34.14402], [-118.84058, 34.14361], [-118.84113, 34.14306], [-118.84128, 34.14315], [-118.84155, 34.14336], [-118.84164, 34.14351]]]} | Open Access 1 | 1009 | Southshore Hills Park | 25696 | 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.475 | Southshore Hills Park | 0 | Local Park 2 | 4 | |
5831 | 5831 | 5830 | {"type": "Polygon", "coordinates": [[[-118.82888, 34.17163], [-118.82877, 34.17168], [-118.82845, 34.17117], [-118.82836, 34.1712], [-118.82832, 34.17114], [-118.82839, 34.17108], [-118.82805, 34.17055], [-118.82796, 34.17057], [-118.82791, 34.1705], [-118.828, 34.17046], [-118.82762, 34.16987], [-118.82753, 34.16991], [-118.82743, 34.1698], [-118.82731, 34.1698], [-118.82721, 34.16991], [-118.82716, 34.17], [-118.82701, 34.17006], [-118.82681, 34.17009], [-118.82654, 34.16999], [-118.82545, 34.16942], [-118.8285, 34.16806], [-118.82846, 34.16898], [-118.82843, 34.16933], [-118.82829, 34.1695], [-118.82809, 34.16959], [-118.8279, 34.16955], [-118.82778, 34.16961], [-118.82776, 34.16969], [-118.82779, 34.16976], [-118.82773, 34.16983], [-118.8281, 34.17041], [-118.82819, 34.17039], [-118.82824, 34.17045], [-118.82816, 34.1705], [-118.8285, 34.17104], [-118.82859, 34.17102], [-118.82866, 34.17109], [-118.82856, 34.17112], [-118.82855, 34.17113], [-118.82888, 34.17163]]]} | Open Access 1 | 219 | Russell Park - CRPD | 24741 | 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.455 | Russell Park - CRPD | None 467 | |||
5865 | 5865 | 5864 | {"type": "MultiPolygon", "coordinates": [[[[-118.82526, 34.16854], [-118.82526, 34.16863], [-118.82445, 34.16861], [-118.82443, 34.16869], [-118.82435, 34.16868], [-118.82433, 34.1686], [-118.8236, 34.16858], [-118.82357, 34.16866], [-118.82351, 34.16866], [-118.82348, 34.16858], [-118.82279, 34.16856], [-118.82279, 34.16846], [-118.82349, 34.16848], [-118.82352, 34.1684], [-118.82359, 34.1684], [-118.82361, 34.16848], [-118.82434, 34.16851], [-118.82436, 34.16843], [-118.82443, 34.16843], [-118.82445, 34.16851], [-118.82526, 34.16854]]], [[[-118.82896, 34.166], [-118.82877, 34.16625], [-118.82884, 34.16631], [-118.8288, 34.16636], [-118.82871, 34.16634], [-118.82832, 34.16685], [-118.82838, 34.16691], [-118.82836, 34.16695], [-118.82826, 34.16693], [-118.82783, 34.1675], [-118.82773, 34.16745], [-118.82816, 34.16688], [-118.82809, 34.16682], [-118.82813, 34.16677], [-118.82822, 34.1668], [-118.82861, 34.16629], [-118.82854, 34.16623], [-118.82858, 34.16617], [-118.82867, 34.1662], [-118.82886, 34.16595], [-118.82896, 34.166]]]]} | Open Access 1 | 212 | Russell Access Strips | 24738 | 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.277 | Russell Access Strips | None 470 | |||
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 | |
10446 | 10446 | 10445 | {"type": "Polygon", "coordinates": [[[-118.95865, 34.19332], [-118.95755, 34.19292], [-118.95737, 34.19284], [-118.95543, 34.19225], [-118.95497, 34.19215], [-118.95454, 34.1921], [-118.95313, 34.192], [-118.95307, 34.19196], [-118.95304, 34.1919], [-118.95305, 34.19182], [-118.95365, 34.19111], [-118.95394, 34.19075], [-118.9541, 34.19049], [-118.95425, 34.19017], [-118.95433, 34.18995], [-118.95446, 34.18936], [-118.9546, 34.18932], [-118.95462, 34.18962], [-118.95466, 34.1898], [-118.95475, 34.19004], [-118.95485, 34.19022], [-118.95502, 34.19035], [-118.95578, 34.19075], [-118.95652, 34.19106], [-118.95708, 34.19122], [-118.95785, 34.19139], [-118.95836, 34.19156], [-118.9586, 34.19168], [-118.95868, 34.19177], [-118.95874, 34.19188], [-118.95877, 34.192], [-118.95865, 34.19332]]]} | Open Access 1 | 18483 | Pepper Tree Playfield | 23595 | 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 | 22.244 | Pepper Tree Playfield | 0 | Local Recreation Area 3 | 4 | |
10294 | 10294 | 10293 | {"type": "Polygon", "coordinates": [[[-118.84962, 34.20133], [-118.84947, 34.20185], [-118.84861, 34.20263], [-118.8472, 34.20254], [-118.84721, 34.20202], [-118.84787, 34.20201], [-118.84787, 34.20175], [-118.84721, 34.20174], [-118.84721, 34.20144], [-118.84723, 34.20143], [-118.8485, 34.2011], [-118.84879, 34.20137], [-118.84917, 34.20147], [-118.84962, 34.20133]]]} | Open Access 1 | 18281 | Old Meadows Park | 23092 | 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.162 | Old Meadows Park | 0 | Local Park 2 | 4 | |
16151 | 16151 | 16150 | {"type": "Polygon", "coordinates": [[[-118.84724, 34.20143], [-118.84721, 34.20145], [-118.84721, 34.20183], [-118.84525, 34.20192], [-118.84459, 34.20202], [-118.84429, 34.20197], [-118.84293, 34.20068], [-118.8434, 34.20058], [-118.84343, 34.20031], [-118.84374, 34.20032], [-118.8439, 34.19964], [-118.84455, 34.19941], [-118.8465, 34.19988], [-118.84705, 34.20015], [-118.84722, 34.20036], [-118.84724, 34.20143]]]} | Open Access 1 | 18278 | Old Meadows Open Space - CRPD | 23091 | 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 | 20.035 | Old Meadows OS - CRPD | None 1389 | |||
2699 | 2699 | 2698 | {"type": "Polygon", "coordinates": [[[-118.84721, 34.20202], [-118.8472, 34.20254], [-118.84648, 34.20252], [-118.846, 34.20241], [-118.84562, 34.20243], [-118.84515, 34.20253], [-118.84479, 34.20234], [-118.84429, 34.20217], [-118.84721, 34.20202]]]} | Open Access 1 | 18273 | Old Meadows FC | 23089 | 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 | 2.511 | Old Meadows FC | None 221 | |||
16371 | 16371 | 16370 | {"type": "Polygon", "coordinates": [[[-118.81734, 34.21203], [-118.81709, 34.21212], [-118.81686, 34.21225], [-118.81674, 34.21234], [-118.81642, 34.21265], [-118.81612, 34.21286], [-118.81586, 34.21265], [-118.81591, 34.21237], [-118.81666, 34.21184], [-118.8173, 34.21194], [-118.81734, 34.21203]]]} | Open Access 1 | 18217 | Oakbrook Regional Park - CPRD | 23020 | 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.653 | Oakbrook RP - CPRD | None 1398 |
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]);