units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
49 rows where AGNCY_NAME = 101, MNG_AGENCY = 99 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
Suggested facets: PARK_URL, GAP_STS
DES_TP 19
- Local Park 26
- Local Conservation Area 5
- Local Recreation Area 2
- 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
- None 1
- None 1
- None 1
- None 1
- None 1
MNG_AG_TYP 1
- City Agency · 49 ✖
MNG_AGENCY 1
- Redlands, City of · 49 ✖
ACCESS_TYP 1
- Open Access 49
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
244 | 244 | 243 | {"type": "Polygon", "coordinates": [[[-117.19007, 34.07019], [-117.19006, 34.0736], [-117.18985, 34.0736], [-117.18986, 34.07019], [-117.19007, 34.07019]]]} | Open Access 1 | 47336 | Lugonia Garden | 31047 | 1269 | Redlands, City of 101 | City 2 | City Agency 2 | http://www.cityofredlands.org/ | City 2 | 1269 | Redlands, City of 99 | City 2 | City Agency 2 | http://www.cityofredlands.org/recreation/gardens | San Bernardino 22 | 1.811 | Lugonia Garden | 0 | Local Park 2 | 4 |
245 | 245 | 244 | {"type": "Polygon", "coordinates": [[[-117.17915, 34.07497], [-117.17889, 34.07497], [-117.17889, 34.07456], [-117.17873, 34.07455], [-117.17877, 34.07447], [-117.17915, 34.07447], [-117.17915, 34.07497]]]} | Open Access 1 | 47337 | Clement Garden | 31048 | 1269 | Redlands, City of 101 | City 2 | City Agency 2 | http://www.cityofredlands.org/ | City 2 | 1269 | Redlands, City of 99 | City 2 | City Agency 2 | http://www.cityofredlands.org/recreation/gardens | San Bernardino 22 | 0.356 | Clement Garden | 0 | Local Park 2 | 4 |
246 | 246 | 245 | {"type": "Polygon", "coordinates": [[[-117.14865, 34.08097], [-117.14842, 34.08086], [-117.14818, 34.0805], [-117.14822, 34.0787], [-117.14826, 34.07852], [-117.14847, 34.07818], [-117.14864, 34.07795], [-117.14865, 34.08097]]]} | Open Access 1 | 47338 | Granite Citrus Grove | 31049 | 1269 | Redlands, City of 101 | City 2 | City Agency 2 | http://www.cityofredlands.org/ | City 2 | 1269 | Redlands, City of 99 | City 2 | City Agency 2 | San Bernardino 22 | 2.837 | Granite Citrus Grove | 0 | Local Park 2 | 4 | |
247 | 247 | 246 | {"type": "MultiPolygon", "coordinates": [[[[-117.19099, 34.07975], [-117.18687, 34.07973], [-117.18688, 34.07746], [-117.18692, 34.07744], [-117.18906, 34.07745], [-117.18906, 34.0777], [-117.18766, 34.0777], [-117.18766, 34.07866], [-117.18812, 34.07867], [-117.18811, 34.07919], [-117.18814, 34.07928], [-117.18819, 34.07936], [-117.18831, 34.07946], [-117.18846, 34.0795], [-117.18863, 34.0795], [-117.18878, 34.07944], [-117.18886, 34.07937], [-117.18895, 34.07925], [-117.18895, 34.07902], [-117.18912, 34.07902], [-117.18912, 34.07879], [-117.19053, 34.0788], [-117.19077, 34.0789], [-117.19099, 34.07891], [-117.19099, 34.07975]]], [[[-117.19099, 34.07883], [-117.19081, 34.07881], [-117.1906, 34.07871], [-117.19051, 34.07871], [-117.19051, 34.07868], [-117.19099, 34.07868], [-117.19099, 34.07883]]]]} | Open Access 1 | 47339 | Texas Citrus Grove | 31050 | 1269 | Redlands, City of 101 | City 2 | City Agency 2 | http://www.cityofredlands.org/ | City 2 | 1269 | Redlands, City of 99 | City 2 | City Agency 2 | San Bernardino 22 | 12.156 | Texas Citrus Grove | 0 | Local Park 2 | 4 | |
372 | 372 | 371 | {"type": "Polygon", "coordinates": [[[-117.18137, 34.05688], [-117.1811, 34.05687], [-117.1811, 34.05655], [-117.18137, 34.05655], [-117.18137, 34.05688]]]} | Open Access 1 | 1330 | Hale Park | 19603 | 1269 | Redlands, City of 101 | City 2 | City Agency 2 | http://www.cityofredlands.org/ | City 2 | 1269 | Redlands, City of 99 | City 2 | City Agency 2 | San Bernardino 22 | 0.219 | Hale Park | 0 | Local Park 2 | 4 | |
734 | 734 | 733 | {"type": "Polygon", "coordinates": [[[-117.21085, 34.04651], [-117.20865, 34.04651], [-117.20865, 34.04481], [-117.21084, 34.04481], [-117.21085, 34.0455], [-117.21085, 34.04651]]]} | Open Access 1 | 5512 | Brookside Park | 16432 | 1269 | Redlands, City of 101 | City 2 | City Agency 2 | http://www.cityofredlands.org/ | City 2 | 1269 | Redlands, City of 99 | City 2 | City Agency 2 | San Bernardino 22 | 9.471 | Brookside Park | 0 | Local Park 2 | 4 | |
1696 | 1696 | 1695 | {"type": "Polygon", "coordinates": [[[-117.19226, 34.07018], [-117.19224, 34.07362], [-117.19126, 34.07361], [-117.19128, 34.07017], [-117.19226, 34.07018]]]} | Open Access 1 | 14716 | Texonia Park | 26274 | 1269 | Redlands, City of 101 | City 2 | City Agency 2 | http://www.cityofredlands.org/ | City 2 | 1269 | Redlands, City of 99 | City 2 | City Agency 2 | San Bernardino 22 | 8.528 | Texonia Park | 0 | Local Park 2 | 4 | |
1858 | 1858 | 1857 | {"type": "Polygon", "coordinates": [[[-117.16813, 34.08394], [-117.16791, 34.08415], [-117.16606, 34.084], [-117.16607, 34.08275], [-117.16766, 34.08275], [-117.16767, 34.08302], [-117.16792, 34.08367], [-117.16802, 34.08385], [-117.16813, 34.08394]]]} | Open Access 1 | 15860 | Citrus Grove - RIVERVIEW | 17279 | 1269 | Redlands, City of 101 | City 2 | City Agency 2 | http://www.cityofredlands.org/ | City 2 | 1269 | Redlands, City of 99 | City 2 | City Agency 2 | San Bernardino 22 | 5.945 | Citrus Grove - RIVERVIEW | None 150 | |||
2094 | 2094 | 2093 | {"type": "Polygon", "coordinates": [[[-117.15615, 34.07543], [-117.15613, 34.07721], [-117.15407, 34.07722], [-117.15409, 34.07542], [-117.15615, 34.07543]]]} | Open Access 1 | 15833 | Citrus Grove - JUDSON | 17273 | 1269 | Redlands, City of 101 | City 2 | City Agency 2 | http://www.cityofredlands.org/ | City 2 | 1269 | Redlands, City of 99 | City 2 | City Agency 2 | San Bernardino 22 | 9.326 | Citrus Grove - JUDSON | None 168 | |||
2096 | 2096 | 2095 | {"type": "MultiPolygon", "coordinates": [[[[-117.19171, 34.04886], [-117.19105, 34.04921], [-117.1906, 34.04863], [-117.19064, 34.04859], [-117.19055, 34.04847], [-117.19114, 34.04815], [-117.19171, 34.04886]]], [[[-117.19283, 34.04823], [-117.19197, 34.04871], [-117.19189, 34.04861], [-117.19177, 34.04869], [-117.19127, 34.04808], [-117.19172, 34.04782], [-117.19226, 34.04849], [-117.19236, 34.04842], [-117.19241, 34.04833], [-117.1919, 34.04774], [-117.19226, 34.04753], [-117.19283, 34.04823]]]]} | Open Access 1 | 15847 | Citrus Grove - OLIVE | 17277 | 1269 | Redlands, City of 101 | City 2 | City Agency 2 | http://www.cityofredlands.org/ | City 2 | 1269 | Redlands, City of 99 | City 2 | City Agency 2 | San Bernardino 22 | 3.706 | Citrus Grove - OLIVE | None 169 | |||
2261 | 2261 | 2260 | {"type": "Polygon", "coordinates": [[[-117.16881, 34.01125], [-117.16838, 34.01129], [-117.16782, 34.01144], [-117.16755, 34.01148], [-117.16731, 34.0115], [-117.16648, 34.0115], [-117.16609, 34.01146], [-117.1658, 34.01139], [-117.16548, 34.01128], [-117.16517, 34.01113], [-117.16494, 34.01106], [-117.16469, 34.01101], [-117.16441, 34.011], [-117.16443, 34.00773], [-117.16879, 34.00774], [-117.16881, 34.01125]]]} | Open Access 1 | 18112 | Conservation Area | 9197 | 1269 | Redlands, City of 101 | City 2 | City Agency 2 | http://www.cityofredlands.org/ | City 2 | 1269 | Redlands, City of 99 | City 2 | City Agency 2 | San Bernardino 22 | 40.004 | Conservation Area | 0 | Local Conservation Area 4 | 2 | |
2292 | 2292 | 2291 | {"type": "Polygon", "coordinates": [[[-117.14122, 34.06104], [-117.14084, 34.06119], [-117.1405, 34.06137], [-117.13966, 34.06191], [-117.1391, 34.06221], [-117.1391, 34.06042], [-117.14121, 34.06039], [-117.14122, 34.06104]]]} | Open Access 1 | 18252 | Crafton Park | 17749 | 1269 | Redlands, City of 101 | City 2 | City Agency 2 | http://www.cityofredlands.org/ | City 2 | 1269 | Redlands, City of 99 | City 2 | City Agency 2 | San Bernardino 22 | 6.426 | Crafton Park | 0 | Local Park 2 | 4 | |
2619 | 2619 | 2618 | {"type": "Polygon", "coordinates": [[[-117.1821, 34.08725], [-117.18128, 34.08703], [-117.18018, 34.08677], [-117.17906, 34.08653], [-117.17808, 34.08635], [-117.17695, 34.08618], [-117.17596, 34.08605], [-117.17374, 34.08583], [-117.17372, 34.08457], [-117.17353, 34.08458], [-117.17353, 34.08585], [-117.1693, 34.08535], [-117.16496, 34.08491], [-117.16496, 34.08457], [-117.16604, 34.08457], [-117.16605, 34.084], [-117.1679, 34.08417], [-117.16813, 34.08397], [-117.16825, 34.08405], [-117.16839, 34.0841], [-117.16853, 34.08413], [-117.1687, 34.08414], [-117.16887, 34.08412], [-117.1693, 34.08401], [-117.1693, 34.08386], [-117.16932, 34.08392], [-117.16935, 34.08396], [-117.16946, 34.084], [-117.16955, 34.08399], [-117.16964, 34.08391], [-117.1697, 34.08389], [-117.17071, 34.08389], [-117.17097, 34.08392], [-117.1712, 34.08397], [-117.17226, 34.08433], [-117.17259, 34.0844], [-117.17288, 34.08442], [-117.17321, 34.08441], [-117.1735, 34.08437], [-117.17464, 34.08411], [-117.175, 34.08405], [-117.17538, 34.08402], [-117.17581, 34.08401], [-117.17649, 34.08404], [-117.17769, 34.08419], [-117.17801, 34.08425], [-117.17801, 34.08454], [-117.17901, 34.08454], [-117.18012, 34.08486], [-117.18019, 34.0847], [-117.18019, 34.08453], [-117.182, 34.08452], [-117.182, 34.08648], [-117.18209, 34.08649], [-117.1821, 34.08725]]]} | Open Access 1 | 17996 | Conservation Area | 9197 | 1269 | Redlands, City of 101 | City 2 | City Agency 2 | http://www.cityofredlands.org/ | City 2 | 1269 | Redlands, City of 99 | City 2 | City Agency 2 | San Bernardino 22 | 69.264 | Conservation Area | 0 | Local Conservation Area 4 | 2 | |
2621 | 2621 | 2620 | {"type": "Polygon", "coordinates": [[[-117.08214, 34.06252], [-117.08207, 34.06611], [-117.0778, 34.06609], [-117.0777, 34.06889], [-117.07683, 34.0689], [-117.07676, 34.06892], [-117.07668, 34.06897], [-117.07663, 34.06904], [-117.07661, 34.0691], [-117.07661, 34.06918], [-117.07669, 34.06943], [-117.0767, 34.06959], [-117.07662, 34.06982], [-117.07647, 34.07007], [-117.07643, 34.07022], [-117.07644, 34.07033], [-117.07663, 34.0708], [-117.07668, 34.07113], [-117.07663, 34.0718], [-117.07657, 34.07206], [-117.07324, 34.07204], [-117.07332, 34.06978], [-117.06898, 34.06982], [-117.06948, 34.06263], [-117.07792, 34.06244], [-117.08214, 34.06252]]]} | Open Access 1 | 18000 | Conservation Area | 9197 | 1269 | Redlands, City of 101 | City 2 | City Agency 2 | http://www.cityofredlands.org/ | City 2 | 1269 | Redlands, City of 99 | City 2 | City Agency 2 | San Bernardino 22 | 212.802 | Conservation Area | 0 | Local Conservation Area 4 | 2 | |
2624 | 2624 | 2623 | {"type": "MultiPolygon", "coordinates": [[[[-117.19854, 34.02575], [-117.19635, 34.02695], [-117.19532, 34.02687], [-117.19497, 34.0266], [-117.19476, 34.02702], [-117.19456, 34.02719], [-117.19447, 34.02762], [-117.19412, 34.028], [-117.19395, 34.0284], [-117.19398, 34.02878], [-117.19341, 34.02895], [-117.19323, 34.02854], [-117.1931, 34.02837], [-117.19298, 34.02835], [-117.19255, 34.0284], [-117.19242, 34.02855], [-117.19233, 34.02856], [-117.19223, 34.02855], [-117.19215, 34.0285], [-117.19214, 34.02841], [-117.1922, 34.02835], [-117.19239, 34.02823], [-117.19225, 34.02803], [-117.19205, 34.02797], [-117.1918, 34.02806], [-117.19133, 34.02801], [-117.19089, 34.02806], [-117.19039, 34.02805], [-117.19009, 34.02783], [-117.18976, 34.02763], [-117.19092, 34.02605], [-117.19091, 34.02579], [-117.18914, 34.0258], [-117.18913, 34.02674], [-117.18877, 34.02664], [-117.18836, 34.02662], [-117.18793, 34.02652], [-117.18733, 34.02627], [-117.18723, 34.02635], [-117.18712, 34.02627], [-117.18747, 34.0258], [-117.18877, 34.02396], [-117.18701, 34.02293], [-117.1865, 34.02323], [-117.18655, 34.02456], [-117.18531, 34.02563], [-117.18535, 34.02332], [-117.18437, 34.02189], [-117.18309, 34.02085], [-117.18206, 34.01949], [-117.18201, 34.01857], [-117.182, 34.01791], [-117.17812, 34.01793], [-117.17832, 34.0177], [-117.17844, 34.01721], [-117.17874, 34.01673], [-117.17894, 34.01615], [-117.17947, 34.01615], [-117.18199, 34.0175], [-117.18198, 34.01578], [-117.1823, 34.01599], [-117.18264, 34.01627], [-117.18289, 34.01652], [-117.18312, 34.01679], [-117.18335, 34.01713], [-117.18415, 34.01856], [-117.18419, 34.01856], [-117.18443, 34.01899], [-117.18474, 34.01942], [-117.185, 34.01971], [-117.18529, 34.01997], [-117.18561, 34.02022], [-117.18806, 34.02188], [-117.18837, 34.02205], [-117.1887, 34.0222], [-117.18904, 34.02232], [-117.18933, 34.0224], [-117.18984, 34.02251], [-117.19116, 34.02267], [-117.19145, 34.02273], [-117.19175, 34.02282], [-117.19221, 34.02301], [-117.19309, 34.02349], [-117.19346, 34.02368], [-117.19386, 34.02384], [-117.19436, 34.02401], [-117.19478, 34.02412], [-117.19522, 34.02421], [-117.19671, 34.0244], [-117.19676, 34.02576], [-117.19854, 34.02575]]], [[[-117.20834, 34.03384], [-117.205, 34.03385], [-117.20447, 34.03258], [-117.20334, 34.03192], [-117.20321, 34.03195], [-117.203, 34.03155], [-117.20231, 34.03087], [-117.20146, 34.03041], [-117.20066, 34.03015], [-117.19976, 34.02997], [-117.19941, 34.03018], [-117.19936, 34.03004], [-117.19839, 34.02994], [-117.1984, 34.03017], [-117.19797, 34.03008], [-117.19747, 34.02964], [-117.19737, 34.02944], [-117.19712, 34.0295], [-117.1966, 34.02953], [-117.19621, 34.02949], [-117.1964, 34.02848], [-117.19655, 34.0283], [-117.19662, 34.02799], [-117.19654, 34.02776], [-117.19657, 34.02749], [-117.19652, 34.02696], [-117.19776, 34.02705], [-117.19932, 34.02855], [-117.20389, 34.02934], [-117.20411, 34.02959], [-117.20425, 34.02988], [-117.20458, 34.03014], [-117.20472, 34.03035], [-117.20498, 34.03066], [-117.20536, 34.03088], [-117.20558, 34.03115], [-117.20567, 34.03139], [-117.20563, 34.0316], [-117.20611, 34.03225], [-117.20645, 34.03245], [-117.20692, 34.03256], [-117.20719, 34.0327], [-117.20772, 34.0329], [-117.20831, 34.03305], [-117.20834, 34.03384]]]]} | Open Access 1 | 18015 | Conservation Area | 9197 | 1269 | Redlands, City of 101 | City 2 | City Agency 2 | http://www.cityofredlands.org/ | City 2 | 1269 | Redlands, City of 99 | City 2 | City Agency 2 | San Bernardino 22 | 214.718 | Conservation Area | 0 | Local Conservation Area 4 | 2 | |
2980 | 2980 | 2979 | {"type": "MultiPolygon", "coordinates": [[[[-117.14845, 34.07743], [-117.14844, 34.07769], [-117.14839, 34.07787], [-117.1481, 34.07843], [-117.14804, 34.07861], [-117.148, 34.07882], [-117.148, 34.08052], [-117.14806, 34.08073], [-117.14816, 34.08087], [-117.14834, 34.08104], [-117.14852, 34.08114], [-117.1491, 34.08127], [-117.14944, 34.08142], [-117.14983, 34.08167], [-117.14985, 34.08172], [-117.14861, 34.083], [-117.14844, 34.08315], [-117.14825, 34.08327], [-117.14804, 34.08337], [-117.14787, 34.08344], [-117.14741, 34.08355], [-117.14651, 34.08356], [-117.1465, 34.08098], [-117.14394, 34.08099], [-117.14393, 34.07745], [-117.14845, 34.07743]]], [[[-117.1511, 34.08094], [-117.15079, 34.08103], [-117.15057, 34.08113], [-117.15032, 34.08129], [-117.15004, 34.08153], [-117.15001, 34.08154], [-117.14993, 34.0815], [-117.14958, 34.08126], [-117.1493, 34.08114], [-117.14865, 34.08097], [-117.1511, 34.08094]]]]} | Open Access 1 | 20535 | Redlands Sports Park | 24238 | 1269 | Redlands, City of 101 | City 2 | City Agency 2 | http://www.cityofredlands.org/ | City 2 | 1269 | Redlands, City of 99 | City 2 | City Agency 2 | San Bernardino 22 | 54.966 | Redlands Sports Park | 0 | Local Recreation Area 3 | 4 | |
3890 | 3890 | 3889 | {"type": "Polygon", "coordinates": [[[-117.16958, 34.03894], [-117.16953, 34.03899], [-117.1692, 34.03898], [-117.16895, 34.03895], [-117.1685, 34.03896], [-117.16833, 34.03888], [-117.16789, 34.03895], [-117.16768, 34.03903], [-117.16745, 34.03902], [-117.16736, 34.03898], [-117.16749, 34.03887], [-117.16759, 34.03883], [-117.1677, 34.03882], [-117.16952, 34.03886], [-117.16958, 34.03894]]]} | Open Access 1 | 640 | Franklin Park | 19064 | 1269 | Redlands, City of 101 | City 2 | City Agency 2 | http://www.cityofredlands.org/ | City 2 | 1269 | Redlands, City of 99 | City 2 | City Agency 2 | San Bernardino 22 | 0.649 | Franklin Park | 0 | Local Park 2 | 4 | |
4116 | 4116 | 4115 | {"type": "Polygon", "coordinates": [[[-117.19364, 34.03869], [-117.19345, 34.03879], [-117.19312, 34.03836], [-117.19329, 34.03826], [-117.19364, 34.03869]]]} | Open Access 1 | 47335 | Smiley Garden | 31046 | 1269 | Redlands, City of 101 | City 2 | City Agency 2 | http://www.cityofredlands.org/ | City 2 | 1269 | Redlands, City of 99 | City 2 | City Agency 2 | http://www.cityofredlands.org/recreation/gardens | San Bernardino 22 | 0.286 | Smiley Garden | 0 | Local Park 2 | 4 |
4878 | 4878 | 4877 | {"type": "MultiPolygon", "coordinates": [[[[-117.18024, 34.06267], [-117.18024, 34.06279], [-117.17387, 34.06275], [-117.17388, 34.06262], [-117.18024, 34.06267]]], [[[-117.18136, 34.06267], [-117.18136, 34.0628], [-117.18045, 34.06279], [-117.18045, 34.06267], [-117.18136, 34.06267]]]]} | Open Access 1 | 14727 | The Terrace | 26294 | 1269 | Redlands, City of 101 | City 2 | City Agency 2 | http://www.cityofredlands.org/ | City 2 | 1269 | Redlands, City of 99 | City 2 | City Agency 2 | San Bernardino 22 | 2.324 | The Terrace | None 409 | |||
4894 | 4894 | 4893 | {"type": "Polygon", "coordinates": [[[-117.19558, 34.05912], [-117.19517, 34.05926], [-117.19464, 34.05911], [-117.19428, 34.05898], [-117.19399, 34.05885], [-117.19282, 34.05825], [-117.19285, 34.05822], [-117.19285, 34.05806], [-117.19353, 34.05841], [-117.19367, 34.05835], [-117.19368, 34.05852], [-117.19557, 34.05852], [-117.19558, 34.05912]]]} | Open Access 1 | 2418 | Jeannie Davis Park | 20375 | 1269 | Redlands, City of 101 | City 2 | City Agency 2 | http://www.cityofredlands.org/ | City 2 | 1269 | Redlands, City of 99 | City 2 | City Agency 2 | San Bernardino 22 | 3.015 | Jeannie Davis 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]);