units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
85 rows where MNG_AGENCY = 510 sorted by ACCESS_TYP descending
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7199 | 7199 | 7198 | {"type": "Polygon", "coordinates": [[[-120.97533, 37.62623], [-120.97481, 37.62623], [-120.97482, 37.62608], [-120.97533, 37.62607], [-120.97533, 37.62623]]]} | Restricted Access 2 | 34894 | Legion Park | 21143 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 0.197 | Legion Park | 0 | Local Park 2 | 4 | |
13046 | 13046 | 13045 | {"type": "Polygon", "coordinates": [[[-120.97835, 37.62482], [-120.97835, 37.6252], [-120.97609, 37.62409], [-120.9755, 37.62372], [-120.97562, 37.62339], [-120.97585, 37.62358], [-120.97681, 37.62388], [-120.97819, 37.62474], [-120.97835, 37.62482]]]} | Restricted Access 2 | 34895 | Mancini Park | 21733 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 3.106 | Mancini Park | 0 | Local Park 2 | 4 | |
15697 | 15697 | 15696 | {"type": "Polygon", "coordinates": [[[-120.94998, 37.64964], [-120.94987, 37.64947], [-120.94973, 37.64935], [-120.94933, 37.64916], [-120.94892, 37.64904], [-120.94857, 37.64887], [-120.94821, 37.6486], [-120.94808, 37.64857], [-120.94792, 37.64849], [-120.94767, 37.64842], [-120.94752, 37.64832], [-120.94726, 37.64824], [-120.94705, 37.64824], [-120.94689, 37.64827], [-120.94604, 37.64854], [-120.94578, 37.64871], [-120.94549, 37.64892], [-120.94541, 37.649], [-120.94526, 37.6492], [-120.9452, 37.64934], [-120.94519, 37.64946], [-120.94455, 37.6507], [-120.94414, 37.65124], [-120.94359, 37.65155], [-120.9433, 37.65173], [-120.94296, 37.65199], [-120.94286, 37.65209], [-120.94267, 37.65231], [-120.94275, 37.65236], [-120.94262, 37.65253], [-120.94256, 37.65267], [-120.94237, 37.65297], [-120.94211, 37.65331], [-120.94171, 37.65367], [-120.94162, 37.65382], [-120.94154, 37.65391], [-120.94143, 37.654], [-120.94125, 37.65409], [-120.94096, 37.6542], [-120.94082, 37.65422], [-120.94049, 37.65421], [-120.94027, 37.65418], [-120.93922, 37.65415], [-120.9392, 37.65408], [-120.93862, 37.6541], [-120.93813, 37.65394], [-120.93784, 37.65395], [-120.93715, 37.65383], [-120.93698, 37.65383], [-120.93663, 37.65371], [-120.93635, 37.65364], [-120.93558, 37.65356], [-120.93523, 37.65357], [-120.93523, 37.65365], [-120.93405, 37.65329], [-120.9337, 37.65323], [-120.9332, 37.65298], [-120.93291, 37.65275], [-120.9319, 37.65225], [-120.93167, 37.65218], [-120.93136, 37.65204], [-120.93064, 37.65213], [-120.93016, 37.6523], [-120.93014, 37.65079], [-120.93024, 37.65078], [-120.93022, 37.64918], [-120.93024, 37.64915], [-120.93026, 37.64914], [-120.93898, 37.64909], [-120.93901, 37.64911], [-120.93909, 37.64943], [-120.93911, 37.65109], [-120.93918, 37.65109], [-120.93919, 37.65111], [-120.94141, 37.65108], [-120.9414, 37.65094], [-120.93924, 37.65097], [-120.93923, 37.64954], [-120.93916, 37.64929], [-120.93916, 37.6492], [-120.93926, 37.64917], [-120.93926, 37.64923], [-120.93927, 37.64924], [-120.94039, 37.64881], [-120.94039, 37.64872], [-120.94066, 37.64859], [-120.94207, 37.64761], [-120.94226, 37.6475], [-120.94247, 37.64742], [-120.94438, 37.64684], [-120.94459, 37.64676], [-120.94479, 37.64665], [-120.94661, 37.64545], [-120.94678, 37.64537], [-120.94705, 37.6453], [-120.94724, 37.64529], [-120.94804, 37.64529], [-120.94813, 37.64549], [-120.94817, 37.64844], [-120.94821, 37.64848], [-120.9483, 37.64851], [-120.9483, 37.64864], [-120.94908, 37.64902], [-120.94982, 37.64935], [-120.94998, 37.64949], [-120.94998, 37.64964]], [[-120.94255, 37.65248], [-120.94255, 37.65246], [-120.94248, 37.65247], [-120.9424, 37.65264], [-120.94244, 37.65264], [-120.94255, 37.65248]]]} | Restricted Access 2 | 18555 | Creekside Golf Course | 33066 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 181.194 | Creekside GC | 0 | Local Recreation Area 3 | 4 | |
15698 | 15698 | 15697 | {"type": "Polygon", "coordinates": [[[-121.01091, 37.61013], [-121.01091, 37.61163], [-121.01087, 37.61165], [-121.01029, 37.61165], [-121.01028, 37.61259], [-121.00951, 37.61259], [-121.0095, 37.61333], [-121.00713, 37.61333], [-121.00713, 37.6133], [-121.0069, 37.61319], [-121.00574, 37.61394], [-121.00469, 37.61511], [-121.00313, 37.61607], [-121.00289, 37.61662], [-121.00346, 37.61667], [-121.00336, 37.61699], [-121.00483, 37.617], [-121.00483, 37.61781], [-121.00413, 37.61781], [-121.00412, 37.61791], [-121.00265, 37.61791], [-121.00265, 37.61768], [-121.00264, 37.61767], [-121.00076, 37.62018], [-121.00023, 37.62069], [-120.99953, 37.62116], [-120.99932, 37.62134], [-120.99844, 37.62135], [-120.99856, 37.61961], [-120.99866, 37.61853], [-120.99872, 37.61772], [-120.9986, 37.61696], [-120.99845, 37.61648], [-120.99809, 37.61568], [-120.99824, 37.61515], [-121.00054, 37.61294], [-121.0023, 37.61183], [-121.00496, 37.61077], [-121.00724, 37.61022], [-121.00952, 37.60948], [-121.00952, 37.60976], [-121.00959, 37.60976], [-121.01091, 37.61013]]]} | Restricted Access 2 | 18585 | Dryden Park Golf Course | 33067 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 145.239 | Dryden Park GC | 0 | Local Recreation Area 3 | 4 | |
15699 | 15699 | 15698 | {"type": "MultiPolygon", "coordinates": [[[[-120.99932, 37.62134], [-120.99917, 37.62154], [-120.99906, 37.62181], [-120.99884, 37.62328], [-120.99886, 37.62347], [-120.99888, 37.62356], [-120.99917, 37.62423], [-120.99856, 37.62423], [-120.99861, 37.62338], [-120.99842, 37.62163], [-120.99844, 37.62135], [-120.99932, 37.62134]]], [[[-121.00483, 37.6277], [-121.00335, 37.6277], [-121.00334, 37.6274], [-121.00293, 37.6274], [-121.00293, 37.6277], [-121.0001, 37.62764], [-120.99933, 37.62754], [-120.99931, 37.62579], [-120.9994, 37.62481], [-120.99939, 37.6246], [-120.99936, 37.62439], [-120.9993, 37.62419], [-120.99901, 37.62354], [-120.99899, 37.62345], [-120.99898, 37.62328], [-120.99919, 37.62183], [-120.9993, 37.62158], [-120.99941, 37.62144], [-120.99954, 37.6213], [-121.00026, 37.62082], [-121.00037, 37.62075], [-121.0005, 37.6207], [-121.00077, 37.62066], [-121.0015, 37.62067], [-121.00149, 37.62352], [-121.00206, 37.62352], [-121.00206, 37.62423], [-121.00252, 37.62424], [-121.00253, 37.62432], [-121.0048, 37.62432], [-121.00483, 37.6277]]]]} | Restricted Access 2 | 18745 | Modesto Municipal Golf Course | 33068 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 67.968 | Modesto Municipal GC | 0 | Local Recreation Area 3 | 4 | |
16267 | 16267 | 16266 | {"type": "MultiPolygon", "coordinates": [[[[-120.96798, 37.62431], [-120.9679, 37.62465], [-120.96772, 37.62462], [-120.9678, 37.62428], [-120.96798, 37.62431]]], [[[-120.96854, 37.6244], [-120.96834, 37.62437], [-120.96827, 37.6247], [-120.96809, 37.62467], [-120.96817, 37.62428], [-120.96853, 37.62433], [-120.96854, 37.6244]]], [[[-120.97082, 37.62484], [-120.97024, 37.62472], [-120.97023, 37.62482], [-120.96997, 37.62477], [-120.9698, 37.62476], [-120.96964, 37.62479], [-120.96944, 37.62487], [-120.96906, 37.62491], [-120.96905, 37.62476], [-120.96863, 37.62475], [-120.96864, 37.62414], [-120.9675, 37.62391], [-120.96745, 37.62417], [-120.96763, 37.6242], [-120.96754, 37.6246], [-120.96736, 37.62457], [-120.96744, 37.62418], [-120.96708, 37.62412], [-120.96672, 37.62408], [-120.96663, 37.62447], [-120.96632, 37.62442], [-120.96629, 37.6244], [-120.96626, 37.62432], [-120.96624, 37.6242], [-120.96623, 37.62277], [-120.96846, 37.62263], [-120.96924, 37.62277], [-120.97081, 37.62292], [-120.97082, 37.62484]]]]} | Restricted Access 2 | 34896 | Tuolumne River Regional Park | 6748 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 19.414 | Tuolumne River RP | 0 | Local Park 2 | 4 | |
16368 | 16368 | 16367 | {"type": "MultiPolygon", "coordinates": [[[[-120.96864, 37.62414], [-120.96864, 37.62434], [-120.96817, 37.62428], [-120.96808, 37.62467], [-120.9679, 37.62465], [-120.96799, 37.62426], [-120.96782, 37.62423], [-120.96772, 37.62462], [-120.96754, 37.6246], [-120.96762, 37.62421], [-120.96745, 37.62418], [-120.96736, 37.62457], [-120.96663, 37.62447], [-120.96672, 37.62407], [-120.9669, 37.6241], [-120.96689, 37.62415], [-120.96706, 37.62418], [-120.96708, 37.62412], [-120.96744, 37.62417], [-120.96749, 37.62391], [-120.96864, 37.62414]]], [[[-120.96854, 37.62474], [-120.96827, 37.6247], [-120.96834, 37.62437], [-120.96854, 37.6244], [-120.96854, 37.62474]]], [[[-120.9746, 37.62611], [-120.97324, 37.62554], [-120.97195, 37.62512], [-120.97082, 37.62484], [-120.97081, 37.62292], [-120.97343, 37.62388], [-120.97378, 37.62412], [-120.97459, 37.62461], [-120.9746, 37.62611]]]]} | Restricted Access 2 | 34897 | Tuolumne River Regional Park | 6748 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 17.831 | Tuolumne River RP | 0 | Local Park 2 | 4 | |
2362 | 2362 | 2361 | {"type": "Polygon", "coordinates": [[[-121.04345, 37.67763], [-121.04306, 37.67767], [-121.04258, 37.67768], [-121.04263, 37.67694], [-121.04306, 37.67726], [-121.04345, 37.67763]]]} | Open Access 1 | 18529 | City Gate Children's Park | 17292 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 0.829 | City Gate Children's Park | 0 | Local Park 2 | 4 | |
2369 | 2369 | 2368 | {"type": "Polygon", "coordinates": [[[-120.98306, 37.69832], [-120.98171, 37.6983], [-120.98157, 37.6983], [-120.98139, 37.69834], [-120.98133, 37.69827], [-120.98124, 37.6981], [-120.9812, 37.69795], [-120.98115, 37.69617], [-120.98299, 37.69619], [-120.98306, 37.69832]]]} | Open Access 1 | 18542 | Coffee Claratina Park | 17474 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 9.482 | Coffee Claratina Park | 0 | Local Park 2 | 4 | |
2371 | 2371 | 2370 | {"type": "Polygon", "coordinates": [[[-120.97023, 37.67442], [-120.96913, 37.67442], [-120.9691, 37.67259], [-120.96911, 37.67256], [-120.96916, 37.67255], [-120.96973, 37.67261], [-120.9702, 37.67263], [-120.97023, 37.67442]]]} | Open Access 1 | 18548 | Coleman F. Brown Park | 17490 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 4.879 | Coleman F. Brown Park | 0 | Local Park 2 | 4 | |
2379 | 2379 | 2378 | {"type": "Polygon", "coordinates": [[[-120.97212, 37.64848], [-120.97097, 37.64875], [-120.9708, 37.64866], [-120.97066, 37.64869], [-120.97053, 37.64864], [-120.97034, 37.64867], [-120.97005, 37.64877], [-120.96984, 37.64876], [-120.96972, 37.64879], [-120.96959, 37.6488], [-120.96944, 37.64882], [-120.96928, 37.6488], [-120.96903, 37.64882], [-120.96867, 37.64882], [-120.96764, 37.64952], [-120.96632, 37.64978], [-120.96631, 37.64974], [-120.96613, 37.64978], [-120.9658, 37.64993], [-120.9654, 37.65002], [-120.96501, 37.65018], [-120.96415, 37.65072], [-120.9635, 37.65102], [-120.96318, 37.65131], [-120.96279, 37.65182], [-120.96256, 37.65195], [-120.96222, 37.65202], [-120.9619, 37.65204], [-120.96187, 37.64949], [-120.96204, 37.64948], [-120.96225, 37.64943], [-120.96226, 37.6502], [-120.96227, 37.65021], [-120.96293, 37.65001], [-120.96333, 37.64984], [-120.96415, 37.64926], [-120.96532, 37.64901], [-120.96597, 37.6488], [-120.96631, 37.6488], [-120.96765, 37.64816], [-120.96868, 37.64787], [-120.97096, 37.6479], [-120.97211, 37.64753], [-120.97212, 37.64848]]]} | Open Access 1 | 18589 | East La Loma Park | 18372 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 29.203 | East La Loma Park | 0 | Local Park 2 | 4 | |
2386 | 2386 | 2385 | {"type": "Polygon", "coordinates": [[[-121.00253, 37.62066], [-121.00252, 37.62417], [-121.00205, 37.62417], [-121.00205, 37.62353], [-121.00149, 37.62352], [-121.0015, 37.62067], [-121.00253, 37.62066]]]} | Open Access 1 | 18606 | Fairway Park | 18824 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 7.896 | Fairway Park | 0 | Local Park 2 | 4 | |
2387 | 2387 | 2386 | {"type": "Polygon", "coordinates": [[[-120.93047, 37.67448], [-120.92816, 37.6745], [-120.92813, 37.67234], [-120.93044, 37.67232], [-120.93047, 37.67448]]]} | Open Access 1 | 18611 | Freedom Park | 19086 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 12.078 | Freedom Park | 0 | Local Park 2 | 4 | |
2403 | 2403 | 2402 | {"type": "Polygon", "coordinates": [[[-120.98447, 37.64363], [-120.98433, 37.64418], [-120.98416, 37.64434], [-120.98364, 37.6446], [-120.98285, 37.64502], [-120.98211, 37.64528], [-120.98161, 37.64548], [-120.98116, 37.64563], [-120.98005, 37.6461], [-120.98004, 37.64555], [-120.98018, 37.64547], [-120.98046, 37.64543], [-120.98057, 37.64537], [-120.98082, 37.64513], [-120.98107, 37.64505], [-120.98155, 37.64499], [-120.98169, 37.64493], [-120.98158, 37.64453], [-120.98168, 37.64427], [-120.98203, 37.6441], [-120.98253, 37.64376], [-120.98276, 37.64367], [-120.98302, 37.64362], [-120.98447, 37.64363]]]} | Open Access 1 | 18662 | Kewin Park | 20639 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 9.604 | Kewin Park | 0 | Local Park 2 | 4 | |
2411 | 2411 | 2410 | {"type": "Polygon", "coordinates": [[[-120.95264, 37.64545], [-120.9483, 37.64545], [-120.94823, 37.64529], [-120.95262, 37.64529], [-120.95264, 37.64545]]]} | Open Access 1 | 18678 | Lateral No. 2 Park | 21076 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 1.694 | Lateral No. 2 Park | 0 | Local Park 2 | 4 | |
2421 | 2421 | 2420 | {"type": "Polygon", "coordinates": [[[-121.03756, 37.69876], [-121.03628, 37.69877], [-121.03622, 37.69689], [-121.03751, 37.69688], [-121.03756, 37.69876]]]} | Open Access 1 | 18722 | Mckinney Colony Park | 22051 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 5.838 | Mckinney Colony Park | 0 | Local Park 2 | 4 | |
2434 | 2434 | 2433 | {"type": "Polygon", "coordinates": [[[-120.97202, 37.64556], [-120.97094, 37.64555], [-120.97093, 37.64535], [-120.97201, 37.64535], [-120.97202, 37.64556]]]} | Open Access 1 | 18784 | Pierre Park | 23665 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 0.537 | Pierre Park | 0 | Local Park 2 | 4 | |
2457 | 2457 | 2456 | {"type": "Polygon", "coordinates": [[[-120.98467, 37.65083], [-120.98241, 37.65082], [-120.98242, 37.65055], [-120.98239, 37.65], [-120.98465, 37.65], [-120.98467, 37.65083]]]} | Open Access 1 | 18857 | Thomas B. Scott Park | 26306 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 4.478 | Thomas B. Scott Park | 0 | Local Park 2 | 4 | |
2762 | 2762 | 2761 | {"type": "Polygon", "coordinates": [[[-121.0241, 37.69426], [-121.02375, 37.69426], [-121.02374, 37.69383], [-121.02259, 37.69381], [-121.02257, 37.69257], [-121.02258, 37.69254], [-121.02262, 37.69253], [-121.02407, 37.69255], [-121.0241, 37.69426]]]} | Open Access 1 | 18461 | Aqueduct Park | 15550 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 5.048 | Aqueduct Park | 0 | Local Park 2 | 4 | |
2765 | 2765 | 2764 | {"type": "Polygon", "coordinates": [[[-120.9697, 37.69312], [-120.96964, 37.68905], [-120.97159, 37.68904], [-120.97162, 37.68908], [-120.97164, 37.68943], [-120.97171, 37.68961], [-120.97183, 37.68977], [-120.97208, 37.68996], [-120.9721, 37.68999], [-120.97178, 37.69031], [-120.9717, 37.69044], [-120.97165, 37.69064], [-120.97167, 37.69308], [-120.97163, 37.69311], [-120.9697, 37.69312]]]} | Open Access 1 | 18471 | Beyer Park | 16059 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 19.974 | Beyer 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]);