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 UNIT_ID
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP, AGNCY_ID
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5803 | 5803 | 5802 | {"type": "Polygon", "coordinates": [[[-118.66808, 34.19517], [-118.66804, 34.19881], [-118.66712, 34.1988], [-118.66711, 34.1986], [-118.66187, 34.19858], [-118.66196, 34.19793], [-118.6607, 34.19748], [-118.66049, 34.1971], [-118.66026, 34.19647], [-118.65986, 34.19603], [-118.65932, 34.19588], [-118.65877, 34.19529], [-118.65896, 34.19514], [-118.66089, 34.19511], [-118.66808, 34.19517]]]} | Open Access 1 | 72 | El Escorpion Park | 29037 | 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 | 66.947 | El Escorpion Park | 0 | Local Park 2 | 4 | |
44 | 44 | 43 | {"type": "Polygon", "coordinates": [[[-118.35044, 34.13077], [-118.35003, 34.13136], [-118.34933, 34.1306], [-118.3496, 34.13019], [-118.35044, 34.13077]]]} | Open Access 1 | 99 | El Paseo Cahuenga Park | 18526 | 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 | 1.546 | El Paseo Cahuenga Park | 0 | Local Park 2 | 4 | |
5834 | 5834 | 5833 | {"type": "Polygon", "coordinates": [[[-118.16836, 34.09707], [-118.16833, 34.09818], [-118.16828, 34.0982], [-118.16756, 34.09819], [-118.16751, 34.09817], [-118.16748, 34.09812], [-118.16751, 34.09648], [-118.16794, 34.09648], [-118.16793, 34.09706], [-118.16836, 34.09707]]]} | Open Access 1 | 161 | El Sereno North Park | 18541 | 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 | 3.071 | El Sereno North Park | 0 | Local Park 2 | 4 | |
5843 | 5843 | 5842 | {"type": "Polygon", "coordinates": [[[-118.18237, 34.07792], [-118.18013, 34.07793], [-118.18013, 34.07751], [-118.18011, 34.0774], [-118.18007, 34.07733], [-118.18, 34.07725], [-118.17993, 34.07718], [-118.1795, 34.07695], [-118.17947, 34.07691], [-118.18026, 34.07568], [-118.18235, 34.07567], [-118.18237, 34.07792]]]} | Open Access 1 | 169 | El Sereno Recreation Center | 18543 | 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 | 13.93 | El Sereno Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
66 | 66 | 65 | {"type": "Polygon", "coordinates": [[[-118.24767, 33.99122], [-118.24568, 33.99122], [-118.24567, 33.98955], [-118.24762, 33.98955], [-118.24767, 33.99122]]]} | Open Access 1 | 190 | Augustus Hawkins Natural Park | 15707 | 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.369 | Augustus Hawkins Natural Park | 0 | Local Park 2 | 4 | |
5861 | 5861 | 5860 | {"type": "MultiPolygon", "coordinates": [[[[-118.2516, 34.08037], [-118.2506, 34.08161], [-118.24781, 34.08042], [-118.24776, 34.08055], [-118.248, 34.0807], [-118.24868, 34.08101], [-118.24894, 34.08116], [-118.25044, 34.0818], [-118.24997, 34.08239], [-118.24994, 34.08238], [-118.24986, 34.08253], [-118.24875, 34.0839], [-118.24874, 34.08529], [-118.24612, 34.08758], [-118.24308, 34.08628], [-118.24289, 34.08644], [-118.24289, 34.08645], [-118.24591, 34.08774], [-118.24469, 34.08821], [-118.24359, 34.08889], [-118.2436, 34.08909], [-118.24305, 34.08944], [-118.24368, 34.09136], [-118.24494, 34.09187], [-118.24399, 34.09277], [-118.24401, 34.0928], [-118.24325, 34.09351], [-118.24325, 34.09352], [-118.24356, 34.09369], [-118.24391, 34.09386], [-118.24366, 34.09404], [-118.24313, 34.09357], [-118.24221, 34.09285], [-118.24164, 34.09261], [-118.24062, 34.09154], [-118.24025, 34.09121], [-118.23987, 34.0909], [-118.23969, 34.09067], [-118.23906, 34.09008], [-118.2386, 34.08976], [-118.23763, 34.08895], [-118.23634, 34.08792], [-118.23346, 34.08619], [-118.22942, 34.08317], [-118.22874, 34.08248], [-118.22856, 34.08225], [-118.22846, 34.08207], [-118.22814, 34.08126], [-118.22805, 34.08109], [-118.22777, 34.08069], [-118.22756, 34.08031], [-118.22744, 34.08006], [-118.22737, 34.07975], [-118.2324, 34.08196], [-118.23995, 34.08519], [-118.23766, 34.0889], [-118.23786, 34.08906], [-118.2402, 34.0853], [-118.24263, 34.08634], [-118.24282, 34.08618], [-118.24282, 34.08617], [-118.23253, 34.08176], [-118.22742, 34.07952], [-118.22709, 34.0791], [-118.22732, 34.07755], [-118.22731, 34.07709], [-118.22715, 34.07656], [-118.22674, 34.07562], [-118.2262, 34.07358], [-118.22618, 34.0733], [-118.22623, 34.07303], [-118.22634, 34.07275], [-118.22647, 34.0725], [-118.22661, 34.07227], [-118.22682, 34.07199], [-118.22709, 34.07188], [-118.22817, 34.07165], [-118.22898, 34.07237], [-118.22944, 34.07224], [-118.23059, 34.07505], [-118.23223, 34.07459], [-118.23223, 34.07458], [-118.23217, 34.07442], [-118.23071, 34.07083], [-118.23115, 34.07064], [-118.23207, 34.07102], [-118.23207, 34.071], [-118.23152, 34.07052], [-118.23168, 34.07041], [-118.23198, 34.07035], [-118.23241, 34.07029], [-118.23351, 34.07041], [-118.23251, 34.07121], [-118.23452, 34.07205], [-118.23449, 34.07211], [-118.23435, 34.07236], [-118.2341, 34.0727], [-118.23294, 34.07392], [-118.23293, 34.07392], [-118.23288, 34.07399], [-118.23191, 34.07502], [-118.23175, 34.07514], [-118.23169, 34.07523], [-118.23057, 34.07619], [-118.23111, 34.07659], [-118.23199, 34.0777], [-118.23877, 34.08061], [-118.24016, 34.08103], [-118.24058, 34.08113], [-118.24092, 34.08116], [-118.24116, 34.08116], [-118.24145, 34.08114], [-118.24179, 34.08108], [-118.24184, 34.08109], [-118.24187, 34.08113], [-118.24184, 34.08127], [-118.24153, 34.08178], [-118.24166, 34.08185], [-118.24171, 34.08178], [-118.24175, 34.08179], [-118.24203, 34.08133], [-118.24207, 34.08121], [-118.24206, 34.08104], [-118.24207, 34.08102], [-118.24244, 34.08087], [-118.24249, 34.08087], [-118.24252, 34.0809], [-118.24254, 34.08097], [-118.24254, 34.08103], [-118.24252, 34.08113], [-118.24199, 34.08199], [-118.2435, 34.08264], [-118.24368, 34.0822], [-118.24404, 34.08169], [-118.24277, 34.08115], [-118.24403, 34.07912], [-118.24409, 34.07908], [-118.24421, 34.07888], [-118.24419, 34.07886], [-118.24552, 34.07668], [-118.24871, 34.07802], [-118.24883, 34.07749], [-118.24887, 34.07745], [-118.24894, 34.07745], [-118.24921, 34.07758], [-118.24945, 34.07774], [-118.24964, 34.07789], [-118.25017, 34.0784], [-118.25039, 34.07856], [-118.25058, 34.07865], [-118.25081, 34.07872], [-118.25103, 34.07876], [-118.25127, 34.07877], [-118.2516, 34.08037]]], [[[-118.23152, 34.07047], [-118.23138, 34.07054], [-118.23127, 34.07039], [-118.2314, 34.0703], [-118.23152, 34.07047]]], [[[-118.25007, 34.09563], [-118.24836, 34.09789], [-118.24821, 34.09784], [-118.24813, 34.09778], [-118.24796, 34.09754], [-118.24779, 34.09738], [-118.24755, 34.0972], [-118.24744, 34.097], [-118.24718, 34.09684], [-118.24679, 34.09719], [-118.24633, 34.09686], [-118.24622, 34.09673], [-118.2458, 34.09616], [-118.24561, 34.09595], [-118.24545, 34.09583], [-118.24527, 34.09572], [-118.24506, 34.09562], [-118.24487, 34.09555], [-118.24482, 34.09552], [-118.24478, 34.09537], [-118.24472, 34.09528], [-118.24408, 34.09455], [-118.24414, 34.09451], [-118.24465, 34.095], [-118.24488, 34.09464], [-118.24596, 34.0952], [-118.24611, 34.09517], [-118.2462, 34.0951], [-118.24684, 34.09537], [-118.2467, 34.0956], [-118.24671, 34.09562], [-118.25007, 34.09563]]], [[[-118.24601, 34.09461], [-118.24592, 34.09476], [-118.2453, 34.09425], [-118.2453, 34.09425], [-118.24601, 34.09461]]], [[[-118.24862, 34.07694], [-118.24856, 34.07704], [-118.24737, 34.07652], [-118.24706, 34.07634], [-118.24684, 34.07618], [-118.24862, 34.07694]]], [[[-118.25123, 34.07857], [-118.25104, 34.07856], [-118.25085, 34.07853], [-118.25067, 34.07847], [-118.25049, 34.07838], [-118.25032, 34.07825], [-118.24958, 34.07756], [-118.24935, 34.0774], [-118.24907, 34.07726], [-118.24913, 34.07716], [-118.24969, 34.07739], [-118.25053, 34.07607], [-118.25082, 34.07653], [-118.25123, 34.07857]]]]} | Open Access 1 | 233 | Elysian Park | 5628 | 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://lacity.org/for-residents/recreation/parks-gardens-beaches | Los Angeles 6 | 576.136 | Elysian Park | 0 | Local Park 2 | 4 |
5871 | 5871 | 5870 | {"type": "Polygon", "coordinates": [[[-118.24545, 34.09931], [-118.24468, 34.0998], [-118.24403, 34.09922], [-118.24481, 34.09872], [-118.24487, 34.09872], [-118.24545, 34.09931]]]} | Open Access 1 | 245 | Elysian Valley Recreation Center | 18609 | 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.004 | Elysian Valley Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
95 | 95 | 94 | {"type": "Polygon", "coordinates": [[[-118.50316, 34.16163], [-118.50227, 34.16163], [-118.50228, 34.15971], [-118.50316, 34.15991], [-118.50316, 34.16163]]]} | Open Access 1 | 302 | Encino Park | 18668 | 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 | 4.067 | Encino Park | 0 | Local Park 2 | 4 | |
127 | 127 | 126 | {"type": "MultiPolygon", "coordinates": [[[[-118.41914, 34.18293], [-118.4191, 34.18296], [-118.41829, 34.18296], [-118.41826, 34.18294], [-118.41825, 34.1818], [-118.41911, 34.18181], [-118.41914, 34.18184], [-118.41914, 34.18293]]], [[[-118.42023, 34.18293], [-118.42019, 34.18296], [-118.41938, 34.18296], [-118.41935, 34.18294], [-118.41934, 34.18184], [-118.42023, 34.18184], [-118.42023, 34.18293]]]]} | Open Access 1 | 335 | Valley Glen Community Park | 26789 | 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.115 | Valley Glen Community Park | 0 | Local Park 2 | 4 | |
159 | 159 | 158 | {"type": "Polygon", "coordinates": [[[-118.24886, 34.06967], [-118.24887, 34.07033], [-118.24883, 34.07039], [-118.24876, 34.07043], [-118.24868, 34.07045], [-118.2486, 34.07043], [-118.24854, 34.0704], [-118.2485, 34.07035], [-118.24848, 34.07029], [-118.24848, 34.07024], [-118.24877, 34.06965], [-118.24882, 34.06963], [-118.24886, 34.06967]]]} | Open Access 1 | 405 | Everett Park | 18763 | 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.521 | Everett Park | 0 | Local Park 2 | 4 | |
5927 | 5927 | 5926 | {"type": "Polygon", "coordinates": [[[-118.2058, 34.03807], [-118.20518, 34.03902], [-118.20469, 34.03879], [-118.2044, 34.03922], [-118.20354, 34.03884], [-118.20443, 34.03747], [-118.20518, 34.0378], [-118.20518, 34.03783], [-118.20534, 34.0379], [-118.20536, 34.03788], [-118.2058, 34.03807]]]} | Open Access 1 | 411 | Evergreen Recreation Center | 18767 | 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.393 | Evergreen Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
156 | 156 | 155 | {"type": "Polygon", "coordinates": [[[-118.27409, 34.2411], [-118.27374, 34.24114], [-118.2736, 34.24083], [-118.27329, 34.24038], [-118.2733, 34.24033], [-118.27334, 34.24031], [-118.27398, 34.2402], [-118.27404, 34.24086], [-118.27409, 34.2411]]]} | Open Access 1 | 494 | Fehlhaber-Houk Park | 28620 | 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/fehlhaberHoukPk.htm | Los Angeles 6 | 1.175 | Fehlhaber-Houk Park | 0 | Local Park 2 | 4 |
3572 | 3572 | 3571 | {"type": "Polygon", "coordinates": [[[-118.4037, 34.2292], [-118.40363, 34.22925], [-118.40364, 34.22929], [-118.40362, 34.22931], [-118.40221, 34.23034], [-118.40077, 34.22897], [-118.40228, 34.22787], [-118.4037, 34.2292]]]} | Open Access 1 | 519 | Fernangeles Recreation Center | 18880 | 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 | 9.262 | Fernangeles Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
294 | 294 | 293 | {"type": "Polygon", "coordinates": [[[-118.36564, 34.02332], [-118.36557, 34.02447], [-118.36551, 34.02475], [-118.36542, 34.02503], [-118.36317, 34.02482], [-118.36308, 34.02548], [-118.3629, 34.02546], [-118.36318, 34.02338], [-118.36465, 34.02338], [-118.36466, 34.02331], [-118.36564, 34.02332]]]} | Open Access 1 | 788 | Baldwin Hills Recreation Center | 15776 | 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 | 10.253 | Baldwin Hills Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
319 | 319 | 318 | {"type": "Polygon", "coordinates": [[[-118.18189, 34.12005], [-118.18189, 34.12005], [-118.17889, 34.12008], [-118.1804, 34.11888], [-118.18088, 34.11808], [-118.18153, 34.11815], [-118.18189, 34.12005]]]} | Open Access 1 | 855 | Garvanza Park | 19226 | 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.274 | Garvanza Park | 0 | Local Park 2 | 4 | |
331 | 331 | 330 | {"type": "Polygon", "coordinates": [[[-118.36901, 34.03598], [-118.36855, 34.03714], [-118.36689, 34.03694], [-118.36745, 34.03546], [-118.36901, 34.03598]]]} | Open Access 1 | 908 | Genesee Avenue Park | 19255 | 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.852 | Genesee Avenue Park | 0 | Local Park 2 | 4 | |
2907 | 2907 | 2906 | {"type": "Polygon", "coordinates": [[[-118.2343, 34.11538], [-118.23311, 34.11682], [-118.23255, 34.1176], [-118.23164, 34.11715], [-118.23068, 34.11666], [-118.2302, 34.11658], [-118.23129, 34.11609], [-118.2325, 34.11535], [-118.23326, 34.1146], [-118.23381, 34.11501], [-118.23351, 34.11525], [-118.23351, 34.11526], [-118.23352, 34.11527], [-118.23383, 34.11503], [-118.2343, 34.11538]]]} | Open Access 1 | 1011 | Glassell Park and Recreation Center | 19309 | 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/glassellParkRC.htm | Los Angeles 6 | 12.663 | Glassell Park and Rec. Ctr. | 0 | Local Recreation Area 3 | 4 |
6134 | 6134 | 6133 | {"type": "MultiPolygon", "coordinates": [[[[-118.48096, 34.27868], [-118.48054, 34.27901], [-118.48043, 34.279], [-118.48039, 34.27897], [-118.48039, 34.27867], [-118.48096, 34.27868]]], [[[-118.48233, 34.27763], [-118.48165, 34.27816], [-118.48154, 34.27812], [-118.48144, 34.27815], [-118.4814, 34.27819], [-118.48139, 34.27823], [-118.4814, 34.27828], [-118.48143, 34.27832], [-118.48104, 34.27862], [-118.48039, 34.27862], [-118.48039, 34.2783], [-118.48198, 34.27708], [-118.48211, 34.2772], [-118.48221, 34.27733], [-118.48229, 34.27748], [-118.48233, 34.27763]]]]} | Open Access 1 | 1121 | Gothic Rinaldi Park | 19410 | 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 | 3.557 | Gothic Rinaldi Park | 0 | Local Park 2 | 4 | |
6144 | 6144 | 6143 | {"type": "Polygon", "coordinates": [[[-118.49783, 34.26123], [-118.49779, 34.2646], [-118.49774, 34.26463], [-118.49747, 34.26462], [-118.49747, 34.26466], [-118.49575, 34.26465], [-118.49578, 34.2611], [-118.49778, 34.26112], [-118.49778, 34.26119], [-118.49783, 34.26123]]]} | Open Access 1 | 1142 | Granada Hills Park | 19417 | 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 | 18.297 | Granada Hills Park | 0 | Local Park 2 | 4 | |
6168 | 6168 | 6167 | {"type": "Polygon", "coordinates": [[[-118.21254, 34.09023], [-118.21261, 34.09025], [-118.21271, 34.09036], [-118.21272, 34.09039], [-118.2127, 34.09042], [-118.21214, 34.09067], [-118.2117, 34.09092], [-118.21165, 34.09092], [-118.21161, 34.0909], [-118.21161, 34.09084], [-118.21173, 34.09072], [-118.21187, 34.09061], [-118.21254, 34.09023]]]} | Open Access 1 | 1185 | Greayer's Oak Park | 28726 | 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/graeyorsOakPk.htm | Los Angeles 6 | 0.588 | Greayer's Oak 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]);