units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
27 rows where MNG_AGENCY = 479 sorted by GAP_STS
This data as json, copyable, CSV (advanced)
Suggested facets: 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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2156 | 2156 | 2155 | {"type": "Polygon", "coordinates": [[[-121.28501, 38.10685], [-121.28445, 38.10686], [-121.28433, 38.1068], [-121.28356, 38.1068], [-121.2835, 38.10654], [-121.28339, 38.10629], [-121.28326, 38.10609], [-121.28361, 38.10593], [-121.28346, 38.10569], [-121.28331, 38.10558], [-121.28317, 38.10552], [-121.28316, 38.10536], [-121.28332, 38.10543], [-121.2837, 38.10552], [-121.28457, 38.10553], [-121.28457, 38.10582], [-121.28463, 38.10586], [-121.2846, 38.10591], [-121.28458, 38.10598], [-121.28458, 38.10638], [-121.28463, 38.10648], [-121.2846, 38.1065], [-121.2846, 38.10679], [-121.28501, 38.1068], [-121.28501, 38.10685]]]} | Open Access 1 | 17504 | English Oaks Common | 18677 | 1180 | Lodi, City of 488 | City 2 | City Agency 2 | http://www.lodi.gov/PRCS/index.html | City 2 | 1180 | Lodi, City of 479 | City 2 | City Agency 2 | San Joaquin 39 | 3.69 | English Oaks Common | None 176 | |||
5229 | 5229 | 5228 | {"type": "Polygon", "coordinates": [[[-121.25662, 38.12344], [-121.25174, 38.12328], [-121.25168, 38.12153], [-121.25165, 38.11979], [-121.25318, 38.11982], [-121.25354, 38.11987], [-121.25503, 38.12018], [-121.25497, 38.1228], [-121.25662, 38.12286], [-121.25662, 38.12344]]]} | No Public Access 3 | 48073 | Pixley Park Basin | 32575 | 1180 | Lodi, City of 488 | City 2 | City Agency 2 | http://www.lodi.gov/PRCS/index.html | City 2 | 1180 | Lodi, City of 479 | City 2 | City Agency 2 | San Joaquin 39 | 29.579 | Pixley Park Basin | None 423 | |||
10110 | 10110 | 10109 | {"type": "Polygon", "coordinates": [[[-121.30036, 38.15016], [-121.30004, 38.15016], [-121.3001, 38.15032], [-121.3002, 38.15049], [-121.30033, 38.15078], [-121.30012, 38.15079], [-121.30006, 38.15083], [-121.3, 38.15083], [-121.29976, 38.1507], [-121.29949, 38.15061], [-121.2992, 38.15044], [-121.29901, 38.1503], [-121.29893, 38.14994], [-121.29891, 38.14963], [-121.29893, 38.14947], [-121.29891, 38.1493], [-121.29888, 38.14922], [-121.29881, 38.14911], [-121.29869, 38.14903], [-121.2986, 38.14893], [-121.29827, 38.14869], [-121.29794, 38.14869], [-121.29783, 38.14865], [-121.29754, 38.14879], [-121.29754, 38.1488], [-121.29763, 38.14882], [-121.29763, 38.1489], [-121.2975, 38.14908], [-121.2973, 38.14951], [-121.29736, 38.14966], [-121.29738, 38.14975], [-121.29734, 38.14984], [-121.29739, 38.15004], [-121.29736, 38.15016], [-121.29721, 38.15028], [-121.29699, 38.1505], [-121.29678, 38.15048], [-121.29654, 38.15041], [-121.29641, 38.15034], [-121.29609, 38.15009], [-121.29608, 38.14987], [-121.29598, 38.14932], [-121.29595, 38.14917], [-121.29584, 38.14887], [-121.29605, 38.14873], [-121.29596, 38.14858], [-121.29578, 38.14846], [-121.29566, 38.14841], [-121.29555, 38.1485], [-121.29548, 38.14864], [-121.29516, 38.14863], [-121.29483, 38.14874], [-121.29459, 38.14879], [-121.29439, 38.149], [-121.29423, 38.14931], [-121.29424, 38.14957], [-121.29418, 38.14966], [-121.29399, 38.14977], [-121.29388, 38.14978], [-121.29362, 38.14971], [-121.29349, 38.14963], [-121.29345, 38.14958], [-121.29323, 38.14948], [-121.29294, 38.14938], [-121.29267, 38.14939], [-121.29234, 38.14945], [-121.2923, 38.14949], [-121.2921, 38.14954], [-121.29178, 38.14976], [-121.29148, 38.15001], [-121.29124, 38.15035], [-121.2912, 38.15046], [-121.2912, 38.15066], [-121.29123, 38.15075], [-121.29129, 38.15085], [-121.29151, 38.15105], [-121.29165, 38.15122], [-121.2918, 38.15153], [-121.29216, 38.15188], [-121.29226, 38.15204], [-121.29219, 38.1521], [-121.29212, 38.15211], [-121.29186, 38.15205], [-121.29136, 38.1518], [-121.29126, 38.15171], [-121.29087, 38.15158], [-121.29041, 38.15147], [-121.29026, 38.15145], [-121.29009, 38.15148], [-121.28994, 38.15153], [-121.28977, 38.15163], [-121.28966, 38.15202], [-121.28966, 38.15217], [-121.28973, 38.15236], [-121.28984, 38.15249], [-121.28997, 38.15257], [-121.29025, 38.15266], [-121.29031, 38.15271], [-121.29036, 38.15279], [-121.29044, 38.15287], [-121.29055, 38.15306], [-121.29064, 38.15317], [-121.2906, 38.15321], [-121.29049, 38.1532], [-121.29001, 38.15296], [-121.2899, 38.15293], [-121.28961, 38.15293], [-121.28937, 38.15296], [-121.28917, 38.15301], [-121.28901, 38.15307], [-121.28874, 38.1532], [-121.28865, 38.15327], [-121.28859, 38.15335], [-121.28847, 38.1537], [-121.28847, 38.15407], [-121.28833, 38.15438], [-121.28836, 38.15447], [-121.28849, 38.15461], [-121.28849, 38.1547], [-121.28832, 38.15491], [-121.28822, 38.15498], [-121.28806, 38.15504], [-121.2879, 38.15502], [-121.28776, 38.15499], [-121.28763, 38.1549], [-121.28756, 38.1548], [-121.28738, 38.15447], [-121.2873, 38.15437], [-121.28721, 38.15417], [-121.2869, 38.15385], [-121.28669, 38.15368], [-121.28607, 38.15338], [-121.2859, 38.15333], [-121.28576, 38.15322], [-121.28544, 38.1527], [-121.2853, 38.15232], [-121.28519, 38.15212], [-121.28502, 38.15195], [-121.285, 38.15147], [-121.28555, 38.15166], [-121.28588, 38.1517], [-121.2865, 38.15169], [-121.28714, 38.15196], [-121.28762, 38.152], [-121.2877, 38.15198], [-121.28779, 38.15191], [-121.28803, 38.15099], [-121.28812, 38.15073], [-121.28821, 38.15058], [-121.28833, 38.15046], [-121.2891, 38.14979], [-121.2893, 38.14964], [-121.28936, 38.14969], [-121.28953, 38.14954], [-121.28948, 38.14948], [-121.29004, 38.149], [-121.29011, 38.14904], [-121.29049, 38.14873], [-121.29049, 38.14872], [-121.29044, 38.14867], [-121.29063, 38.14856], [-121.2907, 38.14862], [-121.29092, 38.14854], [-121.2909, 38.14847], [-121.29142, 38.14831], [-121.29146, 38.14839], [-121.2918, 38.14828], [-121.29181, 38.14827], [-121.29178, 38.1482], [-121.29187, 38.14817], [-121.29201, 38.14815], [-121.29202, 38.14827], [-121.29229, 38.14818], [-121.29227, 38.14812], [-121.29229, 38.14755], [-121.29235, 38.14731], [-121.29248, 38.14712], [-121.29271, 38.14692], [-121.29271, 38.14575], [-121.293, 38.14575], [-121.293, 38.14615], [-121.29301, 38.14616], [-121.29304, 38.14575], [-121.29365, 38.14571], [-121.29373, 38.14569], [-121.29406, 38.14566], [-121.29463, 38.14554], [-121.29525, 38.14537], [-121.29579, 38.14527], [-121.29635, 38.14523], [-121.29695, 38.14527], [-121.29714, 38.1453], [-121.29723, 38.1453], [-121.29782, 38.14543], [-121.29798, 38.14549], [-121.29808, 38.14564], [-121.29826, 38.14582], [-121.2984, 38.14602], [-121.2985, 38.14619], [-121.29857, 38.14636], [-121.2987, 38.14713], [-121.29882, 38.14795], [-121.29889, 38.14819], [-121.29916, 38.14864], [-121.29933, 38.14887], [-121.29972, 38.14928], [-121.30036, 38.15016]]]} | Open Access 1 | 17542 | Lodi Lake Park and Nature Area | 21398 | 1180 | Lodi, City of 488 | City 2 | City Agency 2 | http://www.lodi.gov/PRCS/index.html | City 2 | 1180 | Lodi, City of 479 | City 2 | City Agency 2 | San Joaquin 39 | 106.776 | Lodi Lake Park and Nature Area | 0 | Local Conservation Area 4 | 2 | |
2155 | 2155 | 2154 | {"type": "Polygon", "coordinates": [[[-121.29053, 38.10816], [-121.28925, 38.10816], [-121.28872, 38.10812], [-121.28828, 38.10812], [-121.28822, 38.1081], [-121.2882, 38.10806], [-121.28819, 38.10742], [-121.28812, 38.10692], [-121.28795, 38.10643], [-121.28759, 38.10582], [-121.28759, 38.10578], [-121.28763, 38.10575], [-121.28782, 38.10569], [-121.28839, 38.10557], [-121.28897, 38.10552], [-121.28911, 38.10553], [-121.28928, 38.10558], [-121.28944, 38.10567], [-121.28956, 38.10568], [-121.28976, 38.10608], [-121.29045, 38.10607], [-121.29053, 38.10816]]]} | Open Access 1 | 17475 | Beckman Park | 15946 | 1180 | Lodi, City of 488 | City 2 | City Agency 2 | http://www.lodi.gov/PRCS/index.html | City 2 | 1180 | Lodi, City of 479 | City 2 | City Agency 2 | San Joaquin 39 | 14.259 | Beckman Park | 0 | Local Park 2 | 4 | |
2397 | 2397 | 2396 | {"type": "Polygon", "coordinates": [[[-121.27344, 38.10513], [-121.27328, 38.10722], [-121.27288, 38.10726], [-121.27209, 38.10742], [-121.27084, 38.10783], [-121.27025, 38.1079], [-121.26982, 38.10791], [-121.26976, 38.10786], [-121.2697, 38.10529], [-121.27344, 38.10513]]]} | Open Access 1 | 17559 | Salas Park | 24793 | 1180 | Lodi, City of 488 | City 2 | City Agency 2 | http://www.lodi.gov/PRCS/index.html | City 2 | 1180 | Lodi, City of 479 | City 2 | City Agency 2 | San Joaquin 39 | 20.79 | Salas Park | 0 | Local Park 2 | 4 | |
2483 | 2483 | 2482 | {"type": "Polygon", "coordinates": [[[-121.26919, 38.1353], [-121.26912, 38.13629], [-121.26801, 38.13624], [-121.26808, 38.13525], [-121.26919, 38.1353]]]} | Open Access 1 | 17508 | Hale Park | 19602 | 1180 | Lodi, City of 488 | City 2 | City Agency 2 | http://www.lodi.gov/PRCS/index.html | City 2 | 1180 | Lodi, City of 479 | City 2 | City Agency 2 | San Joaquin 39 | 2.645 | Hale Park | 0 | Local Park 2 | 4 | |
2490 | 2490 | 2489 | {"type": "Polygon", "coordinates": [[[-121.28039, 38.13556], [-121.2793, 38.13556], [-121.27928, 38.13486], [-121.28038, 38.13486], [-121.28039, 38.13556]]]} | Open Access 1 | 17500 | Emerson Park | 18622 | 1180 | Lodi, City of 488 | City 2 | City Agency 2 | http://www.lodi.gov/PRCS/index.html | City 2 | 1180 | Lodi, City of 479 | City 2 | City Agency 2 | San Joaquin 39 | 1.842 | Emerson Park | 0 | Local Park 2 | 4 | |
2492 | 2492 | 2491 | {"type": "Polygon", "coordinates": [[[-121.30458, 38.13408], [-121.30187, 38.13407], [-121.3016, 38.13404], [-121.30137, 38.13393], [-121.30127, 38.13385], [-121.3012, 38.13377], [-121.30114, 38.13367], [-121.30111, 38.13357], [-121.3011, 38.13346], [-121.30111, 38.13336], [-121.30114, 38.13325], [-121.3012, 38.13315], [-121.30128, 38.13307], [-121.30137, 38.13299], [-121.30148, 38.13293], [-121.30176, 38.13284], [-121.30188, 38.13278], [-121.30198, 38.1327], [-121.30206, 38.13262], [-121.30213, 38.13252], [-121.30217, 38.13242], [-121.30219, 38.13229], [-121.30456, 38.13229], [-121.30458, 38.13408]]]} | Open Access 1 | 17511 | Henry Glaves Jr Park | 19824 | 1180 | Lodi, City of 488 | City 2 | City Agency 2 | http://www.lodi.gov/PRCS/index.html | City 2 | 1180 | Lodi, City of 479 | City 2 | City Agency 2 | San Joaquin 39 | 13.141 | Henry Glaves Jr Park | 0 | Local Park 2 | 4 | |
2495 | 2495 | 2494 | {"type": "Polygon", "coordinates": [[[-121.29088, 38.11928], [-121.29088, 38.11966], [-121.28831, 38.11967], [-121.28831, 38.1172], [-121.28934, 38.11719], [-121.28945, 38.1182], [-121.29071, 38.11819], [-121.29071, 38.11927], [-121.29088, 38.11928]]]} | Open Access 1 | 17526 | Kofu Park | 20713 | 1180 | Lodi, City of 488 | City 2 | City Agency 2 | http://www.lodi.gov/PRCS/index.html | City 2 | 1180 | Lodi, City of 479 | City 2 | City Agency 2 | San Joaquin 39 | 11.242 | Kofu Park | 0 | Local Park 2 | 4 | |
2496 | 2496 | 2495 | {"type": "Polygon", "coordinates": [[[-121.26754, 38.1385], [-121.26695, 38.13848], [-121.26691, 38.13898], [-121.26692, 38.13899], [-121.2675, 38.13902], [-121.2674, 38.14026], [-121.26555, 38.14022], [-121.26562, 38.14012], [-121.26566, 38.14002], [-121.26569, 38.13985], [-121.26564, 38.13829], [-121.26566, 38.13825], [-121.2657, 38.13823], [-121.2675, 38.13817], [-121.26754, 38.13818], [-121.26756, 38.13822], [-121.26754, 38.1385]]]} | Open Access 1 | 17530 | Lawrence Park | 21116 | 1180 | Lodi, City of 488 | City 2 | City Agency 2 | http://www.lodi.gov/PRCS/index.html | City 2 | 1180 | Lodi, City of 479 | City 2 | City Agency 2 | San Joaquin 39 | 8.188 | Lawrence Park | 0 | Local Park 2 | 4 | |
2499 | 2499 | 2498 | {"type": "Polygon", "coordinates": [[[-121.28061, 38.1243], [-121.27916, 38.1243], [-121.27915, 38.1226], [-121.27923, 38.12255], [-121.27943, 38.12259], [-121.27986, 38.12273], [-121.28013, 38.12277], [-121.2806, 38.12278], [-121.28061, 38.1243]]]} | Open Access 1 | 17534 | Legion Park | 21141 | 1180 | Lodi, City of 488 | City 2 | City Agency 2 | http://www.lodi.gov/PRCS/index.html | City 2 | 1180 | Lodi, City of 479 | City 2 | City Agency 2 | San Joaquin 39 | 5.584 | Legion Park | 0 | Local Park 2 | 4 | |
2500 | 2500 | 2499 | {"type": "Polygon", "coordinates": [[[-121.25153, 38.03604], [-121.24923, 38.03607], [-121.24921, 38.03448], [-121.2512, 38.03445], [-121.25123, 38.03443], [-121.25152, 38.03443], [-121.25153, 38.03604]]]} | Open Access 1 | 17538 | Morada Park | 22467 | 1180 | Lodi, City of 488 | City 2 | City Agency 2 | http://www.lodi.gov/PRCS/index.html | City 2 | 1180 | Lodi, City of 479 | City 2 | City Agency 2 | San Joaquin 39 | 8.881 | Morada Park | 0 | Local Park 2 | 4 | |
2502 | 2502 | 2501 | {"type": "Polygon", "coordinates": [[[-121.31533, 38.1379], [-121.31453, 38.1379], [-121.31265, 38.13818], [-121.3118, 38.13818], [-121.3118, 38.13751], [-121.31172, 38.13691], [-121.31177, 38.13599], [-121.31174, 38.13545], [-121.31457, 38.13547], [-121.3149, 38.1357], [-121.3149, 38.13648], [-121.31532, 38.13649], [-121.31533, 38.1379]]]} | Open Access 1 | 17552 | Peterson Park | 23634 | 1180 | Lodi, City of 488 | City 2 | City Agency 2 | http://www.lodi.gov/PRCS/index.html | City 2 | 1180 | Lodi, City of 479 | City 2 | City Agency 2 | San Joaquin 39 | 20.991 | Peterson Park | 0 | Local Park 2 | 4 | |
2507 | 2507 | 2506 | {"type": "Polygon", "coordinates": [[[-121.27079, 38.14011], [-121.27066, 38.14193], [-121.26896, 38.14194], [-121.2691, 38.14025], [-121.26916, 38.1402], [-121.27042, 38.14019], [-121.27043, 38.1401], [-121.27079, 38.14011]]]} | Open Access 1 | 17545 | Lodi Softball Complex | 21399 | 1180 | Lodi, City of 488 | City 2 | City Agency 2 | http://www.lodi.gov/PRCS/index.html | City 2 | 1180 | Lodi, City of 479 | City 2 | City Agency 2 | San Joaquin 39 | 7.175 | Lodi Softball Complex | 0 | Local Recreation Area 3 | 4 | |
2510 | 2510 | 2509 | {"type": "Polygon", "coordinates": [[[-121.27613, 38.14185], [-121.27582, 38.14186], [-121.27581, 38.14159], [-121.27561, 38.14145], [-121.27548, 38.14145], [-121.27547, 38.14104], [-121.27611, 38.14104], [-121.27613, 38.14185]]]} | Open Access 1 | 17567 | Van Buskirk Park | 26823 | 1180 | Lodi, City of 488 | City 2 | City Agency 2 | http://www.lodi.gov/PRCS/index.html | City 2 | 1180 | Lodi, City of 479 | City 2 | City Agency 2 | San Joaquin 39 | 0.979 | Van Buskirk Park | 0 | Local Park 2 | 4 | |
3529 | 3529 | 3528 | {"type": "Polygon", "coordinates": [[[-121.29482, 38.10429], [-121.29393, 38.10425], [-121.29392, 38.103], [-121.2948, 38.10303], [-121.29482, 38.10429]]]} | Open Access 1 | 28074 | Century Meadows Park | 17075 | 1180 | Lodi, City of 488 | City 2 | City Agency 2 | http://www.lodi.gov/PRCS/index.html | City 2 | 1180 | Lodi, City of 479 | City 2 | City Agency 2 | San Joaquin 39 | 2.673 | Century Meadows Park | 0 | Local Park 2 | 4 | |
5139 | 5139 | 5138 | {"type": "Polygon", "coordinates": [[[-121.26771, 38.10396], [-121.26713, 38.10397], [-121.26712, 38.10319], [-121.26771, 38.10317], [-121.26771, 38.10396]]]} | Open Access 1 | 28075 | Borchardt Park | 16278 | 1180 | Lodi, City of 488 | City 2 | City Agency 2 | http://www.lodi.gov/PRCS/index.html | City 2 | 1180 | Lodi, City of 479 | City 2 | City Agency 2 | San Joaquin 39 | 1.103 | Borchardt Park | 0 | Local Park 2 | 4 | |
10075 | 10075 | 10074 | {"type": "Polygon", "coordinates": [[[-121.3102, 38.14663], [-121.31017, 38.14668], [-121.30988, 38.14672], [-121.30871, 38.14672], [-121.30864, 38.14674], [-121.30858, 38.14677], [-121.30851, 38.14672], [-121.30813, 38.14672], [-121.30812, 38.14569], [-121.30826, 38.14571], [-121.30987, 38.14573], [-121.30987, 38.14576], [-121.30991, 38.14576], [-121.30996, 38.14581], [-121.30998, 38.14581], [-121.31005, 38.14627], [-121.31011, 38.14644], [-121.3102, 38.14663]]]} | Open Access 1 | 17518 | Katzakian Park | 20560 | 1180 | Lodi, City of 488 | City 2 | City Agency 2 | http://www.lodi.gov/PRCS/index.html | City 2 | 1180 | Lodi, City of 479 | City 2 | City Agency 2 | San Joaquin 39 | 4.67 | Katzakian Park | 0 | Local Park 2 | 4 | |
10093 | 10093 | 10092 | {"type": "Polygon", "coordinates": [[[-121.26748, 38.12109], [-121.26748, 38.11955], [-121.2675, 38.11952], [-121.26754, 38.1195], [-121.26939, 38.1194], [-121.26945, 38.1194], [-121.26951, 38.11944], [-121.26952, 38.11948], [-121.26954, 38.12096], [-121.26951, 38.12101], [-121.26944, 38.12104], [-121.26755, 38.12114], [-121.2675, 38.12112], [-121.26748, 38.12109]]]} | Open Access 1 | 17489 | Blakely Park | 16153 | 1180 | Lodi, City of 488 | City 2 | City Agency 2 | http://www.lodi.gov/PRCS/index.html | City 2 | 1180 | Lodi, City of 479 | City 2 | City Agency 2 | San Joaquin 39 | 8.071 | Blakely Park | 0 | Local Park 2 | 4 | |
10094 | 10094 | 10093 | {"type": "Polygon", "coordinates": [[[-121.30614, 38.10809], [-121.30605, 38.10817], [-121.29952, 38.10816], [-121.29954, 38.10763], [-121.29964, 38.10736], [-121.29974, 38.10737], [-121.30006, 38.10749], [-121.30034, 38.1072], [-121.30096, 38.10708], [-121.3011, 38.10659], [-121.30095, 38.10632], [-121.30104, 38.10572], [-121.30105, 38.10467], [-121.30608, 38.10469], [-121.30614, 38.10809]]]} | Open Access 1 | 17497 | DeBenedetti Park | 17983 | 1180 | Lodi, City of 488 | City 2 | City Agency 2 | http://www.lodi.gov/PRCS/index.html | City 2 | 1180 | Lodi, City of 479 | City 2 | City Agency 2 | San Joaquin 39 | 45.844 | DeBenedetti 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]);