units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
67 rows where DES_TP = 2 and MNG_AGENCY = 27 sorted by LABEL_NAME descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, PARK_URL, COUNTY, YR_EST
ACCESS_TYP 3
MNG_AG_TYP 1
MNG_AGENCY 1
- Mountains Recreation and Conservation Authority · 67 ✖
DES_TP 1
- Local Park · 67 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14348 | 14348 | 14347 | {"type": "Polygon", "coordinates": [[[-118.70897, 34.15007], [-118.70896, 34.15454], [-118.70252, 34.15455], [-118.70249, 34.15313], [-118.69819, 34.15314], [-118.69761, 34.15316], [-118.69748, 34.15272], [-118.69743, 34.15242], [-118.69741, 34.15208], [-118.69743, 34.15178], [-118.69747, 34.15155], [-118.69789, 34.15166], [-118.6981, 34.15115], [-118.69763, 34.15101], [-118.69802, 34.15008], [-118.69819, 34.14996], [-118.69825, 34.14961], [-118.69841, 34.14944], [-118.69878, 34.14891], [-118.69851, 34.14829], [-118.699, 34.14777], [-118.6994, 34.14746], [-118.69953, 34.14721], [-118.69967, 34.14707], [-118.70143, 34.14568], [-118.70188, 34.14553], [-118.70215, 34.14535], [-118.70228, 34.14507], [-118.70303, 34.14461], [-118.70413, 34.14399], [-118.70442, 34.14388], [-118.70549, 34.14323], [-118.70552, 34.15008], [-118.70897, 34.15007]]]} | Open Access 1 | 44386 | Zev Yaroslavsky Las Virgenes Highlands Park | 27864 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 192.192 | Zev Yaroslavsky Las Virgenes Highlands Park | 0 | Local Park 2 | 4 | |
1695 | 1695 | 1694 | {"type": "Polygon", "coordinates": [[[-118.44942, 34.32994], [-118.44933, 34.33741], [-118.43622, 34.33738], [-118.43622, 34.33551], [-118.43184, 34.3355], [-118.43183, 34.32988], [-118.43502, 34.32989], [-118.43503, 34.33053], [-118.43441, 34.33071], [-118.43306, 34.33152], [-118.43276, 34.33271], [-118.43328, 34.33316], [-118.43366, 34.33287], [-118.4344, 34.33311], [-118.43464, 34.33355], [-118.43591, 34.33306], [-118.43727, 34.33306], [-118.43917, 34.33239], [-118.4396, 34.33184], [-118.44064, 34.33151], [-118.44066, 34.32992], [-118.44064, 34.32991], [-118.44067, 34.32477], [-118.44103, 34.3248], [-118.44103, 34.32508], [-118.4409, 34.32544], [-118.44089, 34.32596], [-118.44104, 34.32615], [-118.44104, 34.32656], [-118.44135, 34.32763], [-118.44095, 34.32786], [-118.44093, 34.32866], [-118.44181, 34.32913], [-118.4418, 34.32946], [-118.44137, 34.32956], [-118.44137, 34.32991], [-118.44144, 34.3299], [-118.44144, 34.32957], [-118.44148, 34.32957], [-118.44174, 34.32965], [-118.44186, 34.3297], [-118.44198, 34.3298], [-118.44207, 34.32991], [-118.44238, 34.32991], [-118.44241, 34.3298], [-118.44261, 34.32947], [-118.44277, 34.32912], [-118.44284, 34.32908], [-118.44295, 34.32908], [-118.44305, 34.32913], [-118.44429, 34.32918], [-118.44424, 34.32895], [-118.44469, 34.32883], [-118.44485, 34.32801], [-118.44498, 34.32795], [-118.445, 34.32869], [-118.44496, 34.3288], [-118.44483, 34.329], [-118.44481, 34.32915], [-118.44483, 34.32924], [-118.44487, 34.32931], [-118.44506, 34.32954], [-118.44509, 34.32963], [-118.4451, 34.32972], [-118.44506, 34.32981], [-118.44498, 34.32993], [-118.44441, 34.3306], [-118.44438, 34.33065], [-118.44439, 34.33071], [-118.44442, 34.33076], [-118.44447, 34.3308], [-118.44454, 34.33082], [-118.44461, 34.33082], [-118.44486, 34.33072], [-118.44507, 34.33057], [-118.44523, 34.33054], [-118.44541, 34.33057], [-118.44549, 34.33061], [-118.44555, 34.33066], [-118.44581, 34.33101], [-118.44593, 34.33134], [-118.44635, 34.33212], [-118.4463, 34.3321], [-118.44644, 34.33288], [-118.44653, 34.33307], [-118.44775, 34.33271], [-118.44756, 34.33103], [-118.44716, 34.33007], [-118.44717, 34.32993], [-118.44942, 34.32994]]]} | Open Access 1 | 12757 | Wilson Canyon Park | 7255 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.lamountains.com/parks.asp?parkid=67 | Los Angeles 6 | 258.949 | Wilson Canyon Park | 0 | Local Park 2 | 4 |
9224 | 9224 | 9223 | {"type": "MultiPolygon", "coordinates": [[[[-118.49075, 34.36144], [-118.48634, 34.36448], [-118.48598, 34.37039], [-118.4847, 34.37037], [-118.48477, 34.36674], [-118.47591, 34.36628], [-118.47584, 34.3591], [-118.4849, 34.35958], [-118.48891, 34.35963], [-118.48897, 34.36142], [-118.49075, 34.36144]]], [[[-118.49645, 34.3669], [-118.49167, 34.36684], [-118.49162, 34.36958], [-118.48911, 34.36955], [-118.48908, 34.37042], [-118.48707, 34.3704], [-118.48741, 34.36492], [-118.49243, 34.36146], [-118.49593, 34.3615], [-118.49645, 34.3669]]], [[[-118.50393, 34.36303], [-118.50351, 34.36364], [-118.50327, 34.36393], [-118.50291, 34.36445], [-118.50273, 34.36458], [-118.50268, 34.36465], [-118.50265, 34.36472], [-118.50077, 34.36423], [-118.50068, 34.36449], [-118.50135, 34.36466], [-118.50134, 34.36477], [-118.50116, 34.36531], [-118.50111, 34.3656], [-118.50118, 34.36685], [-118.50112, 34.36773], [-118.50117, 34.36806], [-118.50084, 34.36914], [-118.50005, 34.37063], [-118.49976, 34.37063], [-118.49976, 34.37055], [-118.50044, 34.36829], [-118.50045, 34.36815], [-118.50041, 34.36797], [-118.5, 34.36709], [-118.49998, 34.36695], [-118.49982, 34.36694], [-118.49965, 34.36696], [-118.49966, 34.3671], [-118.50012, 34.36812], [-118.50013, 34.36821], [-118.49944, 34.37046], [-118.49942, 34.37063], [-118.49783, 34.37064], [-118.49695, 34.36151], [-118.49766, 34.36152], [-118.49771, 34.36262], [-118.50179, 34.36301], [-118.50393, 34.36303]]]]} | Open Access 1 | 15346 | Whitney Canyon Park | 29752 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.lamountains.com/parks.asp?parkid=65 | Los Angeles 6 | 440.166 | Whitney Canyon Park | 0 | Local Park 2 | 4 |
7248 | 7248 | 7247 | {"type": "MultiPolygon", "coordinates": [[[[-118.63884, 34.05238], [-118.63878, 34.05226], [-118.63851, 34.05226], [-118.63799, 34.05267], [-118.63794, 34.05287], [-118.63249, 34.05288], [-118.63247, 34.06006], [-118.62377, 34.06012], [-118.61721, 34.06003], [-118.61696, 34.05978], [-118.61684, 34.0597], [-118.61663, 34.05962], [-118.61641, 34.05959], [-118.61618, 34.05963], [-118.61578, 34.05979], [-118.61567, 34.05982], [-118.61554, 34.05983], [-118.61514, 34.05978], [-118.61492, 34.0598], [-118.61472, 34.05986], [-118.6145, 34.06], [-118.59759, 34.05999], [-118.59764, 34.05634], [-118.60046, 34.05633], [-118.60052, 34.05639], [-118.60065, 34.05646], [-118.60083, 34.05651], [-118.60109, 34.05654], [-118.60141, 34.05652], [-118.60153, 34.05657], [-118.60162, 34.05649], [-118.60149, 34.05642], [-118.60138, 34.05641], [-118.60112, 34.05643], [-118.60092, 34.05642], [-118.6008, 34.05639], [-118.60066, 34.05633], [-118.60195, 34.05632], [-118.60202, 34.0456], [-118.60626, 34.04559], [-118.60624, 34.03865], [-118.60676, 34.03846], [-118.60718, 34.03825], [-118.60744, 34.03808], [-118.60788, 34.03772], [-118.60795, 34.03769], [-118.60819, 34.03771], [-118.60829, 34.03774], [-118.60842, 34.03782], [-118.60848, 34.0379], [-118.60867, 34.0385], [-118.60868, 34.03869], [-118.60867, 34.03922], [-118.60871, 34.03928], [-118.6088, 34.03935], [-118.60892, 34.03938], [-118.60904, 34.03935], [-118.60911, 34.03931], [-118.60918, 34.0392], [-118.60992, 34.03941], [-118.61004, 34.03915], [-118.61025, 34.03898], [-118.61024, 34.03884], [-118.61067, 34.03883], [-118.6108, 34.03889], [-118.6109, 34.03896], [-118.61117, 34.03928], [-118.61148, 34.03953], [-118.61163, 34.03961], [-118.61187, 34.03966], [-118.61195, 34.0397], [-118.6123, 34.04002], [-118.61255, 34.04019], [-118.61282, 34.04031], [-118.61292, 34.04032], [-118.61319, 34.04032], [-118.61356, 34.04039], [-118.61367, 34.04043], [-118.6141, 34.04073], [-118.61432, 34.041], [-118.61442, 34.04108], [-118.61493, 34.04134], [-118.61512, 34.04139], [-118.61578, 34.04147], [-118.61506, 34.04196], [-118.61503, 34.04395], [-118.61717, 34.04558], [-118.62107, 34.04559], [-118.6215, 34.04522], [-118.62205, 34.04559], [-118.62229, 34.0456], [-118.62244, 34.0457], [-118.62272, 34.04581], [-118.62292, 34.0456], [-118.6325, 34.04567], [-118.63687, 34.04564], [-118.63687, 34.04927], [-118.63866, 34.04927], [-118.63845, 34.04948], [-118.63842, 34.04954], [-118.63842, 34.04961], [-118.63844, 34.04967], [-118.63849, 34.04972], [-118.63871, 34.04982], [-118.63886, 34.04992], [-118.63893, 34.05001], [-118.63897, 34.05011], [-118.63906, 34.05053], [-118.63904, 34.05098], [-118.63912, 34.05132], [-118.63912, 34.05141], [-118.63902, 34.05178], [-118.63902, 34.05186], [-118.63906, 34.05193], [-118.63914, 34.05201], [-118.63937, 34.05209], [-118.63943, 34.05213], [-118.63951, 34.0523], [-118.63948, 34.05238], [-118.6394, 34.05242], [-118.63906, 34.05244], [-118.63884, 34.05238]], [[-118.62377, 34.04866], [-118.62268, 34.04864], [-118.62266, 34.04922], [-118.62376, 34.04923], [-118.62377, 34.04866]]], [[[-118.61695, 34.06003], [-118.61492, 34.06], [-118.61483, 34.06], [-118.61505, 34.05995], [-118.61552, 34.06], [-118.61573, 34.05998], [-118.61587, 34.05995], [-118.6162, 34.0598], [-118.61633, 34.05977], [-118.61646, 34.05976], [-118.61659, 34.05978], [-118.61671, 34.05983], [-118.61681, 34.05989], [-118.61695, 34.06003]]], [[[-118.64114, 34.04927], [-118.64113, 34.05286], [-118.63938, 34.05286], [-118.63937, 34.05281], [-118.63905, 34.05281], [-118.63891, 34.05252], [-118.63906, 34.05255], [-118.63945, 34.05252], [-118.63953, 34.05249], [-118.6396, 34.05243], [-118.63964, 34.05237], [-118.63965, 34.05229], [-118.63958, 34.05212], [-118.63953, 34.05206], [-118.63946, 34.052], [-118.63928, 34.05192], [-118.63919, 34.05181], [-118.63918, 34.0517], [-118.63925, 34.05142], [-118.63926, 34.05132], [-118.63917, 34.05098], [-118.63919, 34.05052], [-118.63912, 34.05014], [-118.63908, 34.05002], [-118.639, 34.0499], [-118.63884, 34.04976], [-118.63871, 34.04969], [-118.63864, 34.04946], [-118.63883, 34.04927], [-118.64114, 34.04927]]]]} | Open Access 1 | 6430 | Tuna Canyon Park | 7239 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.lamountains.com/parks.asp?parkid=61 | Los Angeles 6 | 1411.224 | Tuna Canyon Park | 0 | Local Park 2 | 4 |
8988 | 8988 | 8987 | {"type": "MultiPolygon", "coordinates": [[[[-118.82675, 34.12934], [-118.82656, 34.12946], [-118.82635, 34.12956], [-118.82613, 34.12963], [-118.82589, 34.12968], [-118.82553, 34.1297], [-118.82456, 34.1296], [-118.82429, 34.1296], [-118.82403, 34.12963], [-118.82379, 34.12969], [-118.82343, 34.12983], [-118.82322, 34.12995], [-118.82301, 34.13011], [-118.82286, 34.13026], [-118.82272, 34.13044], [-118.82257, 34.13074], [-118.82231, 34.13161], [-118.82228, 34.13161], [-118.82224, 34.13174], [-118.81988, 34.13063], [-118.81916, 34.13037], [-118.81818, 34.13017], [-118.81791, 34.13015], [-118.81748, 34.13015], [-118.8143, 34.13024], [-118.814, 34.13027], [-118.81353, 34.13034], [-118.81298, 34.13047], [-118.81251, 34.13063], [-118.81006, 34.13159], [-118.80968, 34.13178], [-118.8079, 34.13278], [-118.80384, 34.13634], [-118.80183, 34.13618], [-118.80671, 34.13186], [-118.80064, 34.13125], [-118.79957, 34.13104], [-118.79939, 34.13095], [-118.79929, 34.13086], [-118.79921, 34.13075], [-118.79906, 34.13032], [-118.79849, 34.12942], [-118.79825, 34.12891], [-118.80312, 34.12892], [-118.81085, 34.12888], [-118.81074, 34.12532], [-118.81949, 34.12532], [-118.81948, 34.12167], [-118.82382, 34.12168], [-118.82384, 34.1236], [-118.82256, 34.12433], [-118.82397, 34.12477], [-118.82675, 34.12934]]], [[[-118.83083, 34.13356], [-118.83073, 34.1336], [-118.83079, 34.13377], [-118.83079, 34.13389], [-118.83075, 34.13401], [-118.83065, 34.13419], [-118.83056, 34.13415], [-118.82913, 34.13415], [-118.82912, 34.13332], [-118.82751, 34.13241], [-118.82695, 34.13309], [-118.82629, 34.1332], [-118.82576, 34.13253], [-118.82454, 34.1332], [-118.82418, 34.1328], [-118.82376, 34.13244], [-118.82329, 34.13212], [-118.82296, 34.13193], [-118.82258, 34.13175], [-118.82256, 34.13171], [-118.8228, 34.13089], [-118.82291, 34.13062], [-118.82303, 34.13045], [-118.82317, 34.13029], [-118.82334, 34.13016], [-118.82352, 34.13004], [-118.82373, 34.12995], [-118.82395, 34.12988], [-118.82429, 34.12982], [-118.82464, 34.12983], [-118.82551, 34.12991], [-118.82575, 34.12991], [-118.82599, 34.12989], [-118.82623, 34.12984], [-118.82646, 34.12976], [-118.82667, 34.12966], [-118.82687, 34.12954], [-118.82807, 34.13151], [-118.82925, 34.133], [-118.83083, 34.13356]]]]} | Open Access 1 | 14839 | Truinfo Creek Park | 26554 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 377.14 | Truinfo Creek Park | 0 | Local Park 2 | 4 | |
7200 | 7200 | 7199 | {"type": "Polygon", "coordinates": [[[-118.53253, 34.06278], [-118.53074, 34.06246], [-118.53059, 34.06231], [-118.53043, 34.06205], [-118.53036, 34.06186], [-118.53028, 34.06151], [-118.53006, 34.06137], [-118.5299, 34.06124], [-118.52975, 34.06109], [-118.52963, 34.06092], [-118.52928, 34.06035], [-118.5292, 34.06017], [-118.52915, 34.05998], [-118.52912, 34.0597], [-118.52914, 34.05875], [-118.52909, 34.05869], [-118.52886, 34.05854], [-118.52867, 34.05838], [-118.52842, 34.05811], [-118.52825, 34.05781], [-118.5279, 34.05702], [-118.52781, 34.05671], [-118.52775, 34.05641], [-118.52767, 34.05531], [-118.52351, 34.05531], [-118.52408, 34.05461], [-118.52423, 34.05473], [-118.52442, 34.05461], [-118.52459, 34.05463], [-118.5248, 34.05462], [-118.52477, 34.0541], [-118.52479, 34.05414], [-118.52486, 34.05418], [-118.5252, 34.05413], [-118.52526, 34.05436], [-118.52558, 34.05435], [-118.52596, 34.05424], [-118.52592, 34.05413], [-118.52615, 34.05407], [-118.52628, 34.05416], [-118.52656, 34.05399], [-118.52658, 34.05438], [-118.52725, 34.05409], [-118.52758, 34.05383], [-118.52757, 34.05358], [-118.52752, 34.05347], [-118.52699, 34.05343], [-118.52681, 34.05344], [-118.52678, 34.05323], [-118.52686, 34.05311], [-118.52697, 34.05268], [-118.52765, 34.05198], [-118.52765, 34.05176], [-118.52754, 34.05123], [-118.52825, 34.05155], [-118.52812, 34.05203], [-118.52807, 34.05236], [-118.52806, 34.05285], [-118.5281, 34.05323], [-118.5283, 34.05321], [-118.52837, 34.05322], [-118.52843, 34.05325], [-118.52848, 34.0533], [-118.52853, 34.05344], [-118.53037, 34.05402], [-118.53041, 34.05434], [-118.53044, 34.05439], [-118.53048, 34.05444], [-118.52932, 34.05526], [-118.52938, 34.05616], [-118.52943, 34.05643], [-118.52957, 34.05683], [-118.52979, 34.05733], [-118.52989, 34.05746], [-118.53017, 34.05764], [-118.53041, 34.05785], [-118.53097, 34.05785], [-118.53096, 34.05826], [-118.53069, 34.05827], [-118.53077, 34.05854], [-118.5308, 34.05873], [-118.53078, 34.05978], [-118.53111, 34.0603], [-118.53134, 34.06046], [-118.53151, 34.0606], [-118.53166, 34.06075], [-118.53177, 34.06093], [-118.53189, 34.0612], [-118.53197, 34.06155], [-118.53213, 34.06171], [-118.53226, 34.06186], [-118.53237, 34.06202], [-118.53245, 34.0622], [-118.53252, 34.06249], [-118.53253, 34.06278]]]} | Open Access 1 | 6354 | Temescal Gateway Park | 26232 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 59.508 | Temescal Gateway Park | 0 | Local Park 2 | 4 | |
7234 | 7234 | 7233 | {"type": "MultiPolygon", "coordinates": [[[[-118.58076, 34.11807], [-118.58018, 34.11806], [-118.58018, 34.11793], [-118.58021, 34.11792], [-118.58021, 34.11771], [-118.58028, 34.11774], [-118.58058, 34.11778], [-118.58058, 34.11798], [-118.58076, 34.118], [-118.58076, 34.11807]]], [[[-118.59985, 34.12535], [-118.60026, 34.1258], [-118.60035, 34.12598], [-118.60037, 34.12611], [-118.60036, 34.12625], [-118.60032, 34.12638], [-118.60025, 34.1265], [-118.60016, 34.1266], [-118.60004, 34.12669], [-118.59982, 34.12678], [-118.59959, 34.12682], [-118.59891, 34.12683], [-118.59866, 34.1269], [-118.59852, 34.12697], [-118.59836, 34.12713], [-118.59828, 34.12725], [-118.59823, 34.12745], [-118.59824, 34.12759], [-118.59832, 34.12778], [-118.59846, 34.12795], [-118.59859, 34.12803], [-118.59881, 34.12812], [-118.59898, 34.12814], [-118.59979, 34.12813], [-118.6, 34.12816], [-118.60012, 34.12821], [-118.60027, 34.12833], [-118.60034, 34.12843], [-118.60038, 34.12854], [-118.60039, 34.12866], [-118.60037, 34.12877], [-118.60027, 34.12893], [-118.59937, 34.12971], [-118.59927, 34.12984], [-118.5992, 34.12998], [-118.59916, 34.13013], [-118.59917, 34.13036], [-118.59938, 34.13097], [-118.59942, 34.13116], [-118.59943, 34.13137], [-118.59938, 34.13167], [-118.59901, 34.1327], [-118.58897, 34.1328], [-118.58898, 34.12634], [-118.5894, 34.12637], [-118.58968, 34.12636], [-118.59009, 34.12629], [-118.59049, 34.12616], [-118.59084, 34.12597], [-118.59115, 34.12575], [-118.59141, 34.12549], [-118.59138, 34.12541], [-118.59985, 34.12535]]], [[[-118.59115, 34.12541], [-118.59095, 34.1256], [-118.59076, 34.12575], [-118.59042, 34.12594], [-118.59017, 34.12603], [-118.58992, 34.1261], [-118.58952, 34.12615], [-118.58925, 34.12615], [-118.58898, 34.12612], [-118.58898, 34.12543], [-118.59115, 34.12541]]]]} | Open Access 1 | 6420 | Summit Valley Edmund D. Edelman Park | 7222 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.lamountains.com/parks.asp?parkid=56 | Los Angeles 6 | 193.957 | Summit Valley Edmund D. Edelman Park | 0 | Local Park 2 | 4 |
15292 | 15292 | 15291 | {"type": "MultiPolygon", "coordinates": [[[[-118.58898, 34.12543], [-118.58898, 34.12612], [-118.58874, 34.12607], [-118.58851, 34.12599], [-118.58828, 34.1259], [-118.5881, 34.1258], [-118.58808, 34.12581], [-118.58816, 34.12609], [-118.58838, 34.12619], [-118.58861, 34.12626], [-118.58898, 34.12634], [-118.58898, 34.13034], [-118.58336, 34.13033], [-118.58335, 34.12547], [-118.58208, 34.12547], [-118.58189, 34.12503], [-118.582, 34.12454], [-118.58187, 34.12433], [-118.58011, 34.12434], [-118.5802, 34.11807], [-118.58665, 34.11807], [-118.58666, 34.12155], [-118.58897, 34.12156], [-118.58898, 34.12543]]], [[[-118.61063, 34.12533], [-118.61061, 34.12902], [-118.60625, 34.129], [-118.60626, 34.1253], [-118.61063, 34.12533]]]]} | Open Access 1 | 46422 | Summit Valley Edmund D. Edelman Park | 7222 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.lamountains.com/parks.asp?parkid=56 | Los Angeles 6 | 248.906 | Summit Valley Edmund D. Edelman Park | 0 | Local Park 2 | 4 |
413 | 413 | 412 | {"type": "Polygon", "coordinates": [[[-118.60477, 34.27717], [-118.60418, 34.27703], [-118.60318, 34.2767], [-118.60222, 34.27647], [-118.60128, 34.2759], [-118.59886, 34.27528], [-118.59773, 34.27477], [-118.5968, 34.27437], [-118.59644, 34.27429], [-118.59687, 34.27384], [-118.59763, 34.27384], [-118.59817, 34.27352], [-118.59822, 34.27339], [-118.59913, 34.27345], [-118.59979, 34.27347], [-118.60035, 34.2736], [-118.60064, 34.27325], [-118.60057, 34.27261], [-118.60272, 34.2726], [-118.60273, 34.27228], [-118.60457, 34.27224], [-118.60449, 34.27236], [-118.60431, 34.27294], [-118.60432, 34.27441], [-118.60439, 34.27467], [-118.60448, 34.27485], [-118.60448, 34.27491], [-118.60457, 34.27492], [-118.60477, 34.27613], [-118.60481, 34.27645], [-118.60482, 34.27667], [-118.6048, 34.27695], [-118.60477, 34.27717]]]} | Open Access 1 | 831 | Stoney Point Park | 30273 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 55.047 | Stoney Point Park | 0 | Local Park 2 | 4 | |
4369 | 4369 | 4368 | {"type": "MultiPolygon", "coordinates": [[[[-118.29951, 34.43781], [-118.29921, 34.43801], [-118.29837, 34.43863], [-118.29836, 34.4378], [-118.29951, 34.43781]]], [[[-118.30462, 34.43943], [-118.30363, 34.44069], [-118.30341, 34.44058], [-118.30258, 34.44023], [-118.30189, 34.44001], [-118.3015, 34.43992], [-118.30115, 34.43986], [-118.3008, 34.43983], [-118.30054, 34.43984], [-118.30027, 34.43988], [-118.29998, 34.43995], [-118.29965, 34.44008], [-118.29943, 34.4402], [-118.29921, 34.44035], [-118.2989, 34.44061], [-118.2984, 34.44115], [-118.29837, 34.43885], [-118.29944, 34.43806], [-118.29966, 34.43793], [-118.29989, 34.43781], [-118.30272, 34.43781], [-118.30314, 34.43802], [-118.30347, 34.43826], [-118.30377, 34.43854], [-118.30433, 34.43918], [-118.30462, 34.43943]]], [[[-118.30408, 34.44144], [-118.30007, 34.44144], [-118.29898, 34.44144], [-118.29925, 34.44119], [-118.2998, 34.44091], [-118.3001, 34.44078], [-118.30042, 34.44068], [-118.30073, 34.44061], [-118.30105, 34.44056], [-118.30153, 34.44054], [-118.30186, 34.44055], [-118.30234, 34.44062], [-118.30265, 34.4407], [-118.30281, 34.44077], [-118.30283, 34.44076], [-118.30308, 34.44084], [-118.30333, 34.44095], [-118.30357, 34.44107], [-118.30391, 34.44129], [-118.30408, 34.44144]]]]} | Open Access 1 | 48522 | Stickleback Ranch | 33235 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 41.133 | Stickleback Ranch | 2017 | Local Park 2 | 4 | |
7447 | 7447 | 7446 | {"type": "MultiPolygon", "coordinates": [[[[-118.22877, 34.08683], [-118.22866, 34.08675], [-118.22875, 34.08668], [-118.22875, 34.08668], [-118.22877, 34.08683]]], [[[-118.22915, 34.08683], [-118.22891, 34.08704], [-118.22889, 34.08693], [-118.22882, 34.08688], [-118.22879, 34.08664], [-118.22885, 34.08659], [-118.22915, 34.08683]]]]} | No Public Access 3 | 6921 | Steelhead Park | 25823 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.219 | Steelhead Park | 0 | Local Park 2 | 4 | |
15285 | 15285 | 15284 | {"type": "Polygon", "coordinates": [[[-118.33692, 33.72337], [-118.33569, 33.72436], [-118.33525, 33.72574], [-118.33473, 33.72543], [-118.33308, 33.72735], [-118.33239, 33.7275], [-118.33207, 33.72753], [-118.33174, 33.72754], [-118.32971, 33.72738], [-118.33303, 33.72189], [-118.334, 33.72223], [-118.33468, 33.72234], [-118.33553, 33.72255], [-118.33569, 33.72266], [-118.33607, 33.72275], [-118.33624, 33.72289], [-118.33692, 33.72337]]]} | Open Access 1 | 46413 | Shoreline Park | 29692 | 1265 | Rancho Palos Verdes, City of 265 | City 2 | City Agency 2 | http://palosverdes.com/rpv/recreationparks/index.cfm | City 2 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 52.163 | Shoreline Park | 0 | Local Park 2 | 4 | |
922 | 922 | 921 | {"type": "Polygon", "coordinates": [[[-118.58834, 34.15325], [-118.58689, 34.15235], [-118.5868, 34.15236], [-118.58641, 34.15142], [-118.58633, 34.14834], [-118.58557, 34.14681], [-118.5847, 34.14741], [-118.58252, 34.14676], [-118.58605, 34.14524], [-118.58832, 34.14524], [-118.58834, 34.15325]]]} | Open Access 1 | 6411 | Serrania Park | 29661 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 48.711 | Serrania Park | 0 | Local Park 2 | 4 | |
5441 | 5441 | 5440 | {"type": "MultiPolygon", "coordinates": [[[[-118.63548, 34.37308], [-118.62674, 34.37315], [-118.62674, 34.37414], [-118.62401, 34.37417], [-118.62397, 34.3776], [-118.61533, 34.37785], [-118.61535, 34.37521], [-118.61607, 34.37543], [-118.61645, 34.37544], [-118.61646, 34.37498], [-118.61669, 34.37478], [-118.61732, 34.3749], [-118.61749, 34.37476], [-118.61786, 34.3745], [-118.61822, 34.37459], [-118.6186, 34.37443], [-118.61869, 34.37401], [-118.61908, 34.3739], [-118.61978, 34.37407], [-118.6201, 34.374], [-118.62071, 34.37409], [-118.62137, 34.37427], [-118.62161, 34.37424], [-118.62233, 34.37436], [-118.62247, 34.37415], [-118.62259, 34.37406], [-118.62308, 34.37417], [-118.62333, 34.37398], [-118.62347, 34.37393], [-118.62412, 34.37413], [-118.62439, 34.37394], [-118.62475, 34.37389], [-118.62516, 34.37376], [-118.62645, 34.37314], [-118.62662, 34.37288], [-118.62692, 34.37285], [-118.6273, 34.37301], [-118.62748, 34.37287], [-118.62759, 34.37253], [-118.62757, 34.37217], [-118.62732, 34.37187], [-118.62749, 34.37157], [-118.62786, 34.37154], [-118.62822, 34.37127], [-118.62856, 34.37124], [-118.62898, 34.37082], [-118.62906, 34.37055], [-118.62894, 34.37052], [-118.62886, 34.37077], [-118.62849, 34.37114], [-118.62817, 34.37116], [-118.6278, 34.37143], [-118.6274, 34.37147], [-118.62717, 34.37188], [-118.62744, 34.3722], [-118.62746, 34.37252], [-118.62736, 34.37281], [-118.62728, 34.37288], [-118.62694, 34.37274], [-118.62654, 34.37278], [-118.62635, 34.37306], [-118.6251, 34.37366], [-118.62471, 34.37379], [-118.62434, 34.37383], [-118.62409, 34.374], [-118.62347, 34.37381], [-118.62325, 34.37389], [-118.62304, 34.37405], [-118.62256, 34.37394], [-118.62236, 34.37408], [-118.62226, 34.37424], [-118.62162, 34.37413], [-118.62138, 34.37416], [-118.62074, 34.37398], [-118.62009, 34.37389], [-118.61978, 34.37396], [-118.61907, 34.37379], [-118.61858, 34.37393], [-118.61848, 34.37436], [-118.6182, 34.37448], [-118.61783, 34.37437], [-118.6174, 34.37467], [-118.61728, 34.37478], [-118.61665, 34.37466], [-118.61633, 34.37494], [-118.61632, 34.37533], [-118.6161, 34.37532], [-118.61535, 34.3751], [-118.61535, 34.37472], [-118.61104, 34.37466], [-118.61101, 34.37797], [-118.60669, 34.37809], [-118.60673, 34.36896], [-118.59771, 34.36892], [-118.59771, 34.3681], [-118.59652, 34.36809], [-118.59652, 34.36705], [-118.58962, 34.36713], [-118.58966, 34.35946], [-118.58785, 34.35949], [-118.57856, 34.35976], [-118.56921, 34.35992], [-118.56821, 34.35992], [-118.56823, 34.35261], [-118.56069, 34.35258], [-118.56091, 34.35222], [-118.56132, 34.3521], [-118.56145, 34.3518], [-118.56184, 34.3515], [-118.56173, 34.35132], [-118.56145, 34.35105], [-118.56146, 34.35089], [-118.5614, 34.3507], [-118.56138, 34.35045], [-118.56149, 34.35013], [-118.56147, 34.34984], [-118.56154, 34.34973], [-118.56184, 34.34968], [-118.56226, 34.34976], [-118.56252, 34.34968], [-118.56244, 34.34929], [-118.56254, 34.3491], [-118.56273, 34.34898], [-118.56292, 34.34879], [-118.5632, 34.34867], [-118.56367, 34.34817], [-118.56343, 34.3478], [-118.56348, 34.34737], [-118.56367, 34.34717], [-118.56374, 34.34686], [-118.56384, 34.34664], [-118.56396, 34.34658], [-118.56411, 34.3464], [-118.56416, 34.34601], [-118.56393, 34.34579], [-118.56391, 34.34559], [-118.56409, 34.34535], [-118.56451, 34.34527], [-118.56452, 34.34502], [-118.56425, 34.34419], [-118.56412, 34.34419], [-118.56411, 34.3442], [-118.56438, 34.34505], [-118.56438, 34.34519], [-118.56401, 34.34526], [-118.56377, 34.34556], [-118.5638, 34.34583], [-118.56403, 34.34604], [-118.56399, 34.34635], [-118.56386, 34.34651], [-118.56372, 34.34658], [-118.56363, 34.34681], [-118.56354, 34.34713], [-118.56335, 34.34733], [-118.56329, 34.34783], [-118.56351, 34.34816], [-118.56311, 34.34859], [-118.56284, 34.34871], [-118.56264, 34.34891], [-118.56242, 34.34904], [-118.5623, 34.34928], [-118.56237, 34.34961], [-118.56225, 34.34964], [-118.56184, 34.34956], [-118.56145, 34.34963], [-118.56133, 34.34982], [-118.56136, 34.35012], [-118.56125, 34.35043], [-118.56126, 34.35071], [-118.56132, 34.35091], [-118.56132, 34.35109], [-118.56162, 34.35138], [-118.56168, 34.35148], [-118.56133, 34.35174], [-118.56122, 34.35201], [-118.56081, 34.35213], [-118.56054, 34.35258], [-118.55048, 34.35254], [-118.55048, 34.35021], [-118.54799, 34.3514], [-118.54749, 34.3511], [-118.54705, 34.35087], [-118.54713, 34.35083], [-118.54712, 34.35082], [-118.54659, 34.35059], [-118.546, 34.35039], [-118.54599, 34.3504], [-118.54601, 34.35053], [-118.54528, 34.35034], [-118.54481, 34.35026], [-118.54444, 34.35021], [-118.54444, 34.35018], [-118.54295, 34.35015], [-118.54218, 34.3496], [-118.54192, 34.34954], [-118.54178, 34.34533], [-118.53779, 34.34531], [-118.53778, 34.34482], [-118.53742, 34.33828], [-118.55051, 34.33839], [-118.55052, 34.33476], [-118.5594, 34.33483], [-118.55936, 34.33845], [-118.56382, 34.33847], [-118.57261, 34.33756], [-118.57275, 34.34533], [-118.57711, 34.34536], [-118.57709, 34.34827], [-118.57718, 34.34814], [-118.58164, 34.34998], [-118.59269, 34.35002], [-118.59269, 34.35269], [-118.60665, 34.35205], [-118.60671, 34.36169], [-118.60773, 34.36171], [-118.60774, 34.36378], [-118.62414, 34.36475], [-118.62418, 34.36592], [-118.63539, 34.36583], [-118.63548, 34.37308]]], [[[-118.55487, 34.35427], [-118.55487, 34.35427], [-118.55486, 34.35533], [-118.55391, 34.35467], [-118.55487, 34.35427]]]]} | Open Access 1 | 11490 | Santa Clarita Woodlands Park | 7212 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.lamountains.com/parks.asp?parkid=626 | Los Angeles 6 | 3249.546 | Santa Clarita Woodlands Park | 0 | Local Park 2 | 4 |
6944 | 6944 | 6943 | {"type": "Polygon", "coordinates": [[[-118.51425, 34.12874], [-118.51314, 34.12885], [-118.51295, 34.12889], [-118.51277, 34.12897], [-118.51247, 34.12916], [-118.51234, 34.12922], [-118.5122, 34.12925], [-118.51188, 34.12928], [-118.51171, 34.12932], [-118.51174, 34.12898], [-118.51348, 34.12757], [-118.51357, 34.12725], [-118.51425, 34.12725], [-118.51425, 34.12874]]]} | Open Access 1 | 6365 | San Vicente Mountain Park | 29687 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 6.37 | San Vicente Mtn. Park | 0 | Local Park 2 | 4 | |
5867 | 5867 | 5866 | {"type": "Polygon", "coordinates": [[[-118.68549, 34.24998], [-118.68549, 34.25069], [-118.66802, 34.25071], [-118.66772, 34.24034], [-118.66776, 34.23429], [-118.66962, 34.23597], [-118.66904, 34.23641], [-118.66904, 34.23643], [-118.66926, 34.23663], [-118.66985, 34.23618], [-118.67286, 34.23895], [-118.67624, 34.23662], [-118.68521, 34.23663], [-118.6852, 34.23896], [-118.68549, 34.24998]]]} | Open Access 1 | 243 | Sage Ranch Park | 7210 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.lamountains.com/parks.asp?parkid=53 | Ventura 8 | 611.393 | Sage Ranch Park | 0 | Local Park 2 | 4 |
9484 | 9484 | 9483 | {"type": "MultiPolygon", "coordinates": [[[[-118.3565, 34.11322], [-118.35646, 34.11335], [-118.35625, 34.11361], [-118.35628, 34.11372], [-118.35595, 34.11393], [-118.35588, 34.11402], [-118.35578, 34.11422], [-118.35564, 34.11432], [-118.35397, 34.11366], [-118.35456, 34.11268], [-118.35482, 34.11246], [-118.35648, 34.11247], [-118.35643, 34.11269], [-118.35634, 34.11317], [-118.3565, 34.11322]]], [[[-118.35543, 34.11456], [-118.35533, 34.11513], [-118.35528, 34.11523], [-118.35444, 34.11562], [-118.35425, 34.11566], [-118.35417, 34.11565], [-118.35426, 34.11513], [-118.35482, 34.11485], [-118.35486, 34.11459], [-118.35493, 34.11444], [-118.35515, 34.11442], [-118.35543, 34.11456]]]]} | Open Access 1 | 47827 | Runyon Canyon Park | 24732 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 10.167 | Runyon Canyon Park | 0 | Local Park 2 | 4 | |
15283 | 15283 | 15282 | {"type": "Polygon", "coordinates": [[[-118.63258, 34.35354], [-118.62383, 34.35366], [-118.62373, 34.34997], [-118.63242, 34.34997], [-118.63258, 34.35354]]]} | Unknown Access 4 | 46403 | Ron Bishop & Judge Anderson Park | 29682 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 79.884 | Ron Bishop & Judge Anderson Park | 0 | Local Park 2 | 4 | |
51 | 51 | 50 | {"type": "Polygon", "coordinates": [[[-118.674, 34.29348], [-118.67397, 34.29777], [-118.67398, 34.29799], [-118.67395, 34.30795], [-118.67392, 34.32596], [-118.65355, 34.32593], [-118.6368, 34.29182], [-118.63356, 34.27021], [-118.63407, 34.26984], [-118.63486, 34.26943], [-118.63545, 34.26914], [-118.63594, 34.26887], [-118.63651, 34.26874], [-118.63636, 34.2682], [-118.63686, 34.26821], [-118.63699, 34.26795], [-118.63775, 34.2679], [-118.63862, 34.26735], [-118.63882, 34.26705], [-118.64002, 34.26694], [-118.64055, 34.26718], [-118.64124, 34.26707], [-118.64161, 34.26757], [-118.64205, 34.268], [-118.64292, 34.26794], [-118.64321, 34.26815], [-118.64384, 34.26796], [-118.64476, 34.26861], [-118.64486, 34.26885], [-118.64554, 34.26919], [-118.64591, 34.26945], [-118.64587, 34.26972], [-118.64605, 34.26992], [-118.64617, 34.27043], [-118.64649, 34.27042], [-118.64736, 34.27032], [-118.64857, 34.2705], [-118.64975, 34.27054], [-118.65053, 34.27066], [-118.65167, 34.27079], [-118.65135, 34.27117], [-118.65102, 34.27141], [-118.6505, 34.27233], [-118.65068, 34.27264], [-118.651, 34.27288], [-118.65206, 34.27291], [-118.65241, 34.2726], [-118.65269, 34.27253], [-118.65287, 34.27283], [-118.6536, 34.27319], [-118.65554, 34.27312], [-118.65564, 34.27322], [-118.6557, 34.27352], [-118.65552, 34.27365], [-118.65526, 34.27388], [-118.65532, 34.27401], [-118.6557, 34.27417], [-118.65686, 34.2756], [-118.65684, 34.27585], [-118.65692, 34.276], [-118.65743, 34.27643], [-118.65769, 34.27678], [-118.65796, 34.27742], [-118.65835, 34.27777], [-118.65861, 34.2779], [-118.657, 34.2786], [-118.65697, 34.2852], [-118.65552, 34.2852], [-118.65553, 34.28163], [-118.65284, 34.28162], [-118.65281, 34.2889], [-118.65656, 34.28891], [-118.65656, 34.28992], [-118.65968, 34.28993], [-118.65966, 34.29346], [-118.674, 34.29348]], [[-118.65173, 34.28695], [-118.65174, 34.28673], [-118.65148, 34.28674], [-118.65148, 34.28695], [-118.65173, 34.28695]]]} | Open Access 1 | 147 | Rocky Peak Park | 7206 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://lamountains.com/parks.asp?parkid=51 | Ventura 8 | 3570.979 | Rocky Peak Park | 0 | Local Park 2 | 4 |
4310 | 4310 | 4309 | {"type": "MultiPolygon", "coordinates": [[[[-118.63485, 34.30711], [-118.63246, 34.30711], [-118.63238, 34.31063], [-118.628, 34.31062], [-118.62808, 34.30711], [-118.6259, 34.3071], [-118.62582, 34.30534], [-118.62364, 34.30534], [-118.62336, 34.29831], [-118.62776, 34.2983], [-118.62783, 34.30006], [-118.63221, 34.30006], [-118.6321, 34.29654], [-118.63381, 34.29654], [-118.63485, 34.30711]]], [[[-118.65352, 34.32591], [-118.63593, 34.32593], [-118.63574, 34.32116], [-118.65118, 34.32114], [-118.65352, 34.32591]]]]} | Open Access 1 | 10284 | Rocky Peak Park | 7206 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://lamountains.com/parks.asp?parkid=51 | Los Angeles 6 | 458.301 | Rocky Peak 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]);