units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
432 rows where ACCESS_TYP = 1 and MNG_AGENCY = 24 sorted by SUID_NMA descending
This data as json, copyable, CSV (advanced)
DES_TP 26
- Local Park 291
- Local Recreation Area 105
- Local Other or Unknown 10
- Local Conservation Area 4
- National Forest 1
- Local Historic or Cultural Area 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
- None 1
- None 1
- None 1
- None 1
- None 1
MNG_AG_TYP 1
- City Agency 432
MNG_AGENCY 1
- Los Angeles, City of · 432 ✖
ACCESS_TYP 1
- Open Access · 432 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7260 | 7260 | 7259 | {"type": "Polygon", "coordinates": [[[-118.2864, 33.75129], [-118.28462, 33.75194], [-118.28435, 33.752], [-118.28352, 33.752], [-118.2833, 33.75197], [-118.28308, 33.75187], [-118.28289, 33.75176], [-118.28268, 33.75159], [-118.28261, 33.75149], [-118.28262, 33.75146], [-118.28264, 33.75144], [-118.28298, 33.7514], [-118.2831, 33.75136], [-118.28316, 33.7513], [-118.28341, 33.75078], [-118.28377, 33.75022], [-118.28384, 33.75016], [-118.28393, 33.75013], [-118.28408, 33.75009], [-118.28424, 33.75007], [-118.28446, 33.75007], [-118.28446, 33.75089], [-118.28451, 33.75102], [-118.2846, 33.75111], [-118.28464, 33.75114], [-118.28476, 33.75119], [-118.28491, 33.75118], [-118.28611, 33.75074], [-118.2864, 33.75129]]]} | Open Access 1 | 48929 | Knoll Hill Little League | 33648 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 8.901 | Knoll Hill Little League | None 599 | |||
7125 | 7125 | 7124 | {"type": "MultiPolygon", "coordinates": [[[[-118.26072, 33.94705], [-118.26071, 33.94739], [-118.26068, 33.94742], [-118.25879, 33.94744], [-118.25875, 33.94743], [-118.25874, 33.9474], [-118.25874, 33.94706], [-118.26072, 33.94705]]], [[[-118.265, 33.94722], [-118.265, 33.94739], [-118.26494, 33.94743], [-118.26096, 33.94745], [-118.26093, 33.94744], [-118.26091, 33.94742], [-118.26091, 33.94703], [-118.26328, 33.94702], [-118.26329, 33.94723], [-118.265, 33.94722]]]]} | Open Access 1 | 6210 | Jacaranda Park | 33131 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 5.329 | Jacaranda Park | 0 | Local Park 2 | 4 | |
4464 | 4464 | 4463 | {"type": "Polygon", "coordinates": [[[-118.2356, 34.04165], [-118.23514, 34.0417], [-118.23507, 34.04127], [-118.23553, 34.04121], [-118.2356, 34.04165]]]} | Open Access 1 | 46647 | Arts District Park | 32785 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.514 | Arts District Park | 2016 | Local Park 2 | 4 | |
14964 | 14964 | 14963 | {"type": "Polygon", "coordinates": [[[-118.4065, 34.23117], [-118.4061, 34.23146], [-118.40628, 34.23165], [-118.40483, 34.23133], [-118.40587, 34.23057], [-118.4065, 34.23117]]]} | Open Access 1 | 45577 | Sheldon Skate Park | 32744 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 2.189 | Sheldon Skate Park | 0 | Local Recreation Area 3 | 4 | |
11341 | 11341 | 11340 | {"type": "Polygon", "coordinates": [[[-118.29214, 33.74614], [-118.29214, 33.74647], [-118.29177, 33.74647], [-118.29177, 33.74612], [-118.29179, 33.74611], [-118.2921, 33.74611], [-118.29214, 33.74614]]]} | Open Access 1 | 48106 | Los Angeles Sister Cities Plaza | 32611 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | https://www.laparks.org/park/los-angeles-sister-cities-plaza | Los Angeles 6 | 0.333 | Los Angeles Sister Cities Plaza | 0 | Local Park 2 | 4 |
11415 | 11415 | 11414 | {"type": "Polygon", "coordinates": [[[-118.44058, 34.20165], [-118.44015, 34.20165], [-118.44015, 34.20137], [-118.44021, 34.20134], [-118.44058, 34.20134], [-118.44058, 34.20165]]]} | Open Access 1 | 48104 | Greenwood Square Park | 32609 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | https://www.laparks.org/park/greenwood-square-park | Los Angeles 6 | 0.331 | Greenwood Square Park | 0 | Local Park 2 | 4 |
11428 | 11428 | 11427 | {"type": "Polygon", "coordinates": [[[-118.29133, 33.98266], [-118.29128, 33.9827], [-118.2911, 33.9827], [-118.2911, 33.98267], [-118.29108, 33.98267], [-118.29108, 33.98255], [-118.29105, 33.98254], [-118.29105, 33.9822], [-118.2913, 33.98228], [-118.29132, 33.9823], [-118.29133, 33.98266]]]} | Open Access 1 | 48096 | Vermont Gage Park | 32601 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | https://www.laparks.org/park/vermont-and-gage-park | Los Angeles 6 | 0.305 | Vermont Gage Park | 0 | Local Park 2 | 4 |
14749 | 14749 | 14748 | {"type": "Polygon", "coordinates": [[[-118.20749, 34.12111], [-118.2074, 34.12143], [-118.20711, 34.12138], [-118.20707, 34.12135], [-118.20707, 34.12132], [-118.20714, 34.12105], [-118.20749, 34.12111]]]} | Open Access 1 | 45089 | York Boulevard Pocket Park | 32599 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | https://www.laparks.org/park/york-boulevard-park | Los Angeles 6 | 0.293 | York Boulevard PP | 0 | Local Park 2 | 4 |
14704 | 14704 | 14703 | {"type": "Polygon", "coordinates": [[[-118.30056, 34.0395], [-118.30046, 34.0395], [-118.30046, 34.03918], [-118.30049, 34.03915], [-118.30055, 34.03915], [-118.30056, 34.0395]]]} | Open Access 1 | 45059 | West Adams Heights Park | 32572 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | https://www.laparks.org/park/west-adams-heights-park | Los Angeles 6 | 0.088 | West Adams Heights Park | 2014 | Local Park 2 | 4 |
14705 | 14705 | 14704 | {"type": "Polygon", "coordinates": [[[-118.34039, 34.03371], [-118.34038, 34.03384], [-118.34032, 34.03407], [-118.34007, 34.03394], [-118.34039, 34.03352], [-118.34039, 34.03371]]]} | Open Access 1 | 45060 | Gladys Jean Wesson Park | 32559 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | https://www.laparks.org/park/gladys-jean-wesson-park-aka-west-boulevard | Los Angeles 6 | 0.209 | Gladys Jean Wesson Park | 2014 | Local Park 2 | 4 |
14712 | 14712 | 14711 | {"type": "Polygon", "coordinates": [[[-118.30708, 34.09441], [-118.30692, 34.09441], [-118.30691, 34.094], [-118.30708, 34.094], [-118.30708, 34.09441]]]} | Open Access 1 | 45051 | La Mirada Avenue Park | 32026 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.172 | La Mirada Avenue Park | 0 | Local Park 2 | 4 | |
7464 | 7464 | 7463 | {"type": "Polygon", "coordinates": [[[-118.1847, 34.14373], [-118.1843, 34.1441], [-118.18411, 34.14425], [-118.18398, 34.14441], [-118.18362, 34.14471], [-118.18336, 34.14452], [-118.18363, 34.14438], [-118.18361, 34.14434], [-118.1838, 34.14425], [-118.1839, 34.14415], [-118.18417, 34.14373], [-118.18417, 34.14368], [-118.18413, 34.14353], [-118.18414, 34.14341], [-118.18415, 34.14338], [-118.18422, 34.14338], [-118.18428, 34.14334], [-118.18431, 34.14328], [-118.18429, 34.14323], [-118.18433, 34.14321], [-118.18471, 34.14364], [-118.18472, 34.14368], [-118.1847, 34.14373]]]} | Open Access 1 | 6961 | Richard Alatorre Park | 31684 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | https://www.laparks.org/park/richard-alatorre | Los Angeles 6 | 1.404 | Richard Alatorre Park | 0 | Local Park 2 | 4 |
14818 | 14818 | 14817 | {"type": "Polygon", "coordinates": [[[-118.29521, 34.27884], [-118.29519, 34.2801], [-118.29503, 34.28012], [-118.29504, 34.2803], [-118.2952, 34.28031], [-118.29519, 34.28119], [-118.29466, 34.28157], [-118.29422, 34.28183], [-118.29408, 34.28193], [-118.29383, 34.28219], [-118.29376, 34.2823], [-118.29367, 34.28249], [-118.29368, 34.28251], [-118.29404, 34.28224], [-118.29422, 34.28204], [-118.29436, 34.28194], [-118.29469, 34.28176], [-118.29496, 34.28158], [-118.29518, 34.28141], [-118.29514, 34.28609], [-118.29164, 34.28609], [-118.29167, 34.28599], [-118.29165, 34.28597], [-118.29157, 34.28602], [-118.29153, 34.28609], [-118.29132, 34.28609], [-118.2914, 34.28588], [-118.29123, 34.28531], [-118.29102, 34.2843], [-118.29098, 34.28401], [-118.29159, 34.28334], [-118.29146, 34.28272], [-118.29116, 34.28235], [-118.29016, 34.28207], [-118.28993, 34.28138], [-118.28979, 34.28133], [-118.28989, 34.2811], [-118.28996, 34.28047], [-118.29016, 34.28012], [-118.29081, 34.27972], [-118.29084, 34.27882], [-118.29521, 34.27884]]]} | Open Access 1 | 47239 | Tujunga Little League Field | 31254 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://www.tujungalittleleague.com/ | Los Angeles 6 | 79.152 | Tujunga Little League Field | 0 | Local Recreation Area 3 | 4 |
4131 | 4131 | 4130 | {"type": "Polygon", "coordinates": [[[-118.54299, 34.19064], [-118.54284, 34.19074], [-118.54242, 34.19049], [-118.54196, 34.1903], [-118.54174, 34.19014], [-118.54291, 34.18966], [-118.54291, 34.19054], [-118.54299, 34.19064]]]} | Open Access 1 | 47400 | Los Angeles River and Aliso Creek Confluence Park | 31121 | 1400 | Los Angeles - Department of Water and Power, City of 282 | City 2 | City Agency 2 | http://www.ladwp.com/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | https://www.tpl.org/our-work/los-angeles-river-aliso-creek-confluence-project | Los Angeles 6 | 1.682 | Los Angeles River and Aliso Creek Confluence Park | 2016 | Local Park 2 | 4 |
1306 | 1306 | 1305 | {"type": "Polygon", "coordinates": [[[-118.36933, 34.27138], [-118.36934, 34.27154], [-118.36933, 34.27158], [-118.36927, 34.27162], [-118.36916, 34.27167], [-118.36887, 34.27172], [-118.36875, 34.27177], [-118.36856, 34.2719], [-118.36845, 34.27199], [-118.36839, 34.27207], [-118.36834, 34.27218], [-118.36828, 34.2722], [-118.36823, 34.27225], [-118.3682, 34.27247], [-118.3682, 34.27267], [-118.36779, 34.27246], [-118.36555, 34.26923], [-118.36819, 34.269], [-118.36821, 34.26921], [-118.36828, 34.26945], [-118.36837, 34.2695], [-118.36848, 34.26953], [-118.36848, 34.26958], [-118.36851, 34.26964], [-118.36861, 34.26974], [-118.36871, 34.26981], [-118.36876, 34.26986], [-118.36881, 34.26999], [-118.36881, 34.2701], [-118.36878, 34.27038], [-118.36874, 34.27046], [-118.36868, 34.27055], [-118.36862, 34.27071], [-118.36862, 34.27081], [-118.36865, 34.27091], [-118.36873, 34.27105], [-118.3688, 34.27111], [-118.36919, 34.27127], [-118.36933, 34.27138]]]} | Open Access 1 | 7323 | Orcas Gabrieleno Equestrian Park | 30958 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 17.356 | Orcas Gabrieleno Equestrian Park | 0 | Local Recreation Area 3 | 4 | |
16795 | 16795 | 16794 | {"type": "MultiPolygon", "coordinates": [[[[-118.35638, 34.26783], [-118.35593, 34.26829], [-118.35584, 34.26829], [-118.35537, 34.2677], [-118.35638, 34.26783]]], [[[-118.40076, 34.26685], [-118.3982, 34.26992], [-118.39688, 34.27114], [-118.39396, 34.27326], [-118.39345, 34.27322], [-118.39305, 34.27306], [-118.39242, 34.27288], [-118.39167, 34.27275], [-118.39148, 34.27273], [-118.3913, 34.27261], [-118.39115, 34.27271], [-118.39048, 34.27273], [-118.3895, 34.27285], [-118.38271, 34.27375], [-118.38204, 34.27395], [-118.38165, 34.27413], [-118.38166, 34.27415], [-118.38199, 34.27411], [-118.38149, 34.27448], [-118.37505, 34.27381], [-118.37326, 34.27372], [-118.3728, 34.27074], [-118.37311, 34.26911], [-118.37307, 34.26894], [-118.37297, 34.26886], [-118.3728, 34.26881], [-118.3725, 34.26887], [-118.36836, 34.26898], [-118.36556, 34.26923], [-118.36779, 34.27246], [-118.3682, 34.27267], [-118.3682, 34.27331], [-118.36827, 34.27335], [-118.36339, 34.27298], [-118.36215, 34.27292], [-118.36205, 34.27265], [-118.36168, 34.27244], [-118.36149, 34.27222], [-118.36028, 34.27139], [-118.35844, 34.27155], [-118.35617, 34.26871], [-118.35695, 34.26791], [-118.35827, 34.26807], [-118.35863, 34.26622], [-118.36449, 34.26628], [-118.36534, 34.26618], [-118.36553, 34.26608], [-118.36603, 34.26587], [-118.36643, 34.26563], [-118.36663, 34.26571], [-118.36732, 34.26584], [-118.36782, 34.26584], [-118.36997, 34.26526], [-118.36978, 34.2624], [-118.37166, 34.25994], [-118.37265, 34.25872], [-118.37328, 34.25818], [-118.3738, 34.25783], [-118.37343, 34.25859], [-118.37343, 34.25862], [-118.37506, 34.25861], [-118.37614, 34.2584], [-118.37725, 34.25823], [-118.37816, 34.25822], [-118.37936, 34.25812], [-118.38042, 34.25817], [-118.38262, 34.25846], [-118.38325, 34.25843], [-118.38394, 34.2583], [-118.38448, 34.25843], [-118.38587, 34.25895], [-118.3865, 34.2579], [-118.38713, 34.25817], [-118.38665, 34.259], [-118.3866, 34.26034], [-118.38666, 34.26042], [-118.38925, 34.26121], [-118.3894, 34.26086], [-118.39031, 34.26113], [-118.39073, 34.26043], [-118.39103, 34.26066], [-118.39148, 34.26078], [-118.39335, 34.2618], [-118.39344, 34.2618], [-118.3935, 34.26157], [-118.3954, 34.26242], [-118.39631, 34.26249], [-118.39746, 34.26329], [-118.39782, 34.26398], [-118.39843, 34.26433], [-118.39897, 34.26483], [-118.39946, 34.26558], [-118.39988, 34.26605], [-118.40076, 34.26685]]], [[[-118.39867, 34.27251], [-118.39763, 34.27327], [-118.39688, 34.27256], [-118.3959, 34.27251], [-118.39568, 34.27231], [-118.39725, 34.27116], [-118.39867, 34.27251]]], [[[-118.40091, 34.26912], [-118.40073, 34.26966], [-118.40042, 34.27118], [-118.40039, 34.27126], [-118.39882, 34.2724], [-118.39739, 34.27105], [-118.3978, 34.2707], [-118.39826, 34.27023], [-118.39995, 34.26822], [-118.40091, 34.26912]]], [[[-118.4014, 34.26764], [-118.40094, 34.26903], [-118.40001, 34.26815], [-118.40119, 34.26673], [-118.4014, 34.26764]]]]} | Open Access 1 | 1374 | Hansen Dam Recreation Area | 30957 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://www.laparks.org/dos/reccenter/facility/hansendamRC.htm | Los Angeles 6 | 1140.78 | Hansen Dam Rec. Area | 0 | Local Recreation Area 3 | 4 |
16930 | 16930 | 16929 | {"type": "Polygon", "coordinates": [[[-118.26938, 33.95566], [-118.26937, 33.95639], [-118.26526, 33.95641], [-118.26526, 33.95567], [-118.26938, 33.95566]]]} | Open Access 1 | 25043 | Green Meadows Recreation Center | 30907 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://www.laparks.org/dos/reccenter/facility/greenMeadowsRC.htm | Los Angeles 6 | 7.636 | Green Meadows Rec. Ctr. | 0 | Local Recreation Area 3 | 4 |
16808 | 16808 | 16807 | {"type": "Polygon", "coordinates": [[[-118.61446, 34.17738], [-118.61023, 34.17739], [-118.61032, 34.17679], [-118.61033, 34.17586], [-118.61035, 34.17575], [-118.61046, 34.17557], [-118.61346, 34.17557], [-118.61355, 34.17563], [-118.61364, 34.17565], [-118.61441, 34.17565], [-118.61445, 34.1757], [-118.61446, 34.17738]]]} | Open Access 1 | 15474 | Woodland Hills Recreation Center | 30898 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://www.laparks.org/dos/reccenter/facility/woodlandhillsrc.htm | Los Angeles 6 | 18.776 | Woodland Hills Rec. Ctr. | 0 | Local Recreation Area 3 | 4 |
1457 | 1457 | 1456 | {"type": "MultiPolygon", "coordinates": [[[[-118.5359, 34.18959], [-118.5359, 34.18972], [-118.53552, 34.18962], [-118.53514, 34.1895], [-118.5345, 34.18923], [-118.53383, 34.18888], [-118.53017, 34.18682], [-118.53017, 34.18674], [-118.53582, 34.18674], [-118.53586, 34.18679], [-118.53586, 34.18958], [-118.5359, 34.18959]]], [[[-118.5347, 34.19014], [-118.53177, 34.19015], [-118.53176, 34.18851], [-118.53371, 34.1896], [-118.53405, 34.18977], [-118.53404, 34.1898], [-118.5347, 34.19008], [-118.5347, 34.19014]]]]} | Open Access 1 | 9808 | Reseda Park | 30890 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://www.laparks.org/dos/parks/facility/resedapk.htm | Los Angeles 6 | 29.768 | Reseda Park | 0 | Local Park 2 | 4 |
7865 | 7865 | 7864 | {"type": "Polygon", "coordinates": [[[-118.2415, 34.06352], [-118.24093, 34.0646], [-118.24034, 34.06439], [-118.24089, 34.06331], [-118.2415, 34.06352]]]} | Open Access 1 | 45724 | Alpine Park and Recreation Center | 30744 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://www.laparks.org/dos/reccenter/facility/alpineRC.htm | Los Angeles 6 | 1.936 | Alpine Park and Rec. Ctr. | 0 | Local Recreation Area 3 | 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]);