units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
175 rows where MNG_AGENCY = 16 sorted by ACRES descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, YR_EST, GAP_STS
DES_TP 25
- Local Park 95
- Local Recreation Area 31
- Local Conservation Area 15
- Local Other or Unknown 11
- National Recreation Area 3
- 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
ACCESS_TYP 4
MNG_AG_TYP 1
- County Agency 175
MNG_AGENCY 1
- Los Angeles, County of · 175 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16243 | 16243 | 16242 | {"type": "MultiPolygon", "coordinates": [[[[-118.36323, 34.43458], [-118.36322, 34.43457], [-118.36055, 34.43457], [-118.36051, 34.43809], [-118.36055, 34.44182], [-118.35619, 34.44135], [-118.35629, 34.44514], [-118.35199, 34.44471], [-118.35227, 34.45054], [-118.35121, 34.45123], [-118.34996, 34.45259], [-118.34943, 34.4556], [-118.34819, 34.45706], [-118.34734, 34.45754], [-118.34664, 34.45788], [-118.3451, 34.45882], [-118.34452, 34.4592], [-118.34411, 34.45949], [-118.34382, 34.45973], [-118.3431, 34.46042], [-118.34271, 34.461], [-118.34243, 34.46151], [-118.3421, 34.46221], [-118.34198, 34.46265], [-118.34153, 34.46301], [-118.34126, 34.46327], [-118.34096, 34.46349], [-118.33781, 34.46547], [-118.33439, 34.46541], [-118.33449, 34.45261], [-118.34343, 34.45164], [-118.34291, 34.43993], [-118.33652, 34.44005], [-118.33649, 34.4381], [-118.3369, 34.43822], [-118.33718, 34.43826], [-118.33746, 34.43827], [-118.33775, 34.43826], [-118.33803, 34.43822], [-118.33831, 34.43815], [-118.3394, 34.43775], [-118.33977, 34.43754], [-118.33997, 34.43738], [-118.34015, 34.43721], [-118.34031, 34.43701], [-118.3407, 34.43641], [-118.34081, 34.43628], [-118.34103, 34.43612], [-118.34131, 34.436], [-118.34273, 34.43601], [-118.34717, 34.43652], [-118.34715, 34.43365], [-118.34813, 34.43301], [-118.36054, 34.43456], [-118.36056, 34.43364], [-118.36089, 34.4336], [-118.3618, 34.43334], [-118.36205, 34.43328], [-118.36223, 34.43328], [-118.36241, 34.43329], [-118.36262, 34.43336], [-118.36287, 34.4335], [-118.36299, 34.43361], [-118.36312, 34.43381], [-118.36318, 34.43401], [-118.36321, 34.43414], [-118.36323, 34.43458]]], [[[-118.3409, 34.436], [-118.34069, 34.43615], [-118.34057, 34.43627], [-118.34013, 34.43694], [-118.33998, 34.43712], [-118.3398, 34.43729], [-118.3396, 34.43744], [-118.33939, 34.43756], [-118.3386, 34.43787], [-118.33858, 34.43737], [-118.33899, 34.43721], [-118.33931, 34.43703], [-118.34058, 34.436], [-118.3409, 34.436]]], [[[-118.36127, 34.45283], [-118.36122, 34.45645], [-118.35676, 34.45623], [-118.35673, 34.45849], [-118.35673, 34.45992], [-118.35224, 34.45977], [-118.35219, 34.46359], [-118.34774, 34.46348], [-118.34779, 34.45962], [-118.34587, 34.45955], [-118.34862, 34.45799], [-118.34875, 34.45789], [-118.35028, 34.45631], [-118.35134, 34.45393], [-118.35263, 34.45225], [-118.36127, 34.45283]]], [[[-118.36511, 34.43459], [-118.36365, 34.43458], [-118.36348, 34.43384], [-118.36335, 34.43357], [-118.36309, 34.43329], [-118.36283, 34.43313], [-118.36253, 34.43304], [-118.36221, 34.433], [-118.36195, 34.43302], [-118.36098, 34.43329], [-118.36057, 34.43336], [-118.36058, 34.43254], [-118.36187, 34.43258], [-118.3638, 34.43301], [-118.36414, 34.43315], [-118.36505, 34.43362], [-118.36511, 34.43459]]], [[[-118.36502, 34.43312], [-118.36439, 34.43279], [-118.36405, 34.43265], [-118.36345, 34.4325], [-118.36195, 34.43217], [-118.36058, 34.43212], [-118.36059, 34.43104], [-118.36489, 34.43103], [-118.36502, 34.43312]]]]} | Open Access 1 | 46243 | Eastern Greenbelt Open Space | 29554 | 1319 | Santa Clarita, City of 325 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 1243.079 | Eastern Greenbelt OS | 0 | Local Recreation Area 3 | 4 | |
10493 | 10493 | 10492 | {"type": "Polygon", "coordinates": [[[-117.86356, 34.41191], [-117.85922, 34.41197], [-117.8592, 34.41731], [-117.86116, 34.41727], [-117.86127, 34.41886], [-117.86348, 34.41886], [-117.86349, 34.42457], [-117.85264, 34.42458], [-117.85248, 34.41725], [-117.84376, 34.41711], [-117.84379, 34.41355], [-117.83502, 34.41335], [-117.83534, 34.39918], [-117.83541, 34.3956], [-117.85252, 34.39557], [-117.85268, 34.40744], [-117.85845, 34.4074], [-117.85845, 34.41018], [-117.86356, 34.41013], [-117.86356, 34.41191]]]} | Open Access 1 | 18598 | Devil's Punchbowl Natural Area | 29185 | 199 | Other Federal 284 | Federal 1 | Federal Agency 1 | Other Federal 13 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov/wps/portal/dpr/Parks/Devils_Punchbowl_Natural_Area | Los Angeles 6 | 1235.787 | Devil's Punchbowl Natural Area | 0 | Local Conservation Area 4 | 2 | |
16260 | 16260 | 16259 | {"type": "MultiPolygon", "coordinates": [[[[-118.49356, 34.35386], [-118.48502, 34.35379], [-118.48506, 34.35159], [-118.48864, 34.35162], [-118.48894, 34.34448], [-118.48893, 34.34446], [-118.48492, 34.34449], [-118.48478, 34.33738], [-118.4844, 34.33028], [-118.48473, 34.3303], [-118.49129, 34.34281], [-118.49356, 34.35386]]], [[[-118.49223, 34.34234], [-118.48596, 34.33037], [-118.48876, 34.33053], [-118.48864, 34.32817], [-118.48942, 34.32864], [-118.48973, 34.32973], [-118.49187, 34.34057], [-118.49223, 34.34234]]], [[[-118.50547, 34.34135], [-118.5049, 34.342], [-118.50487, 34.34187], [-118.50482, 34.34177], [-118.50473, 34.3417], [-118.50462, 34.34168], [-118.50447, 34.34172], [-118.50433, 34.34184], [-118.50422, 34.34191], [-118.504, 34.34197], [-118.50382, 34.34197], [-118.50292, 34.34184], [-118.50269, 34.34186], [-118.50247, 34.34195], [-118.50239, 34.34203], [-118.50235, 34.34212], [-118.50242, 34.34262], [-118.50241, 34.34273], [-118.50238, 34.34282], [-118.50232, 34.34291], [-118.50168, 34.34362], [-118.50153, 34.34372], [-118.50152, 34.34378], [-118.50153, 34.34379], [-118.50163, 34.34375], [-118.50175, 34.34366], [-118.50245, 34.34287], [-118.50249, 34.34276], [-118.5025, 34.34264], [-118.50243, 34.34213], [-118.50245, 34.34207], [-118.50252, 34.34202], [-118.50269, 34.34194], [-118.50289, 34.34192], [-118.50377, 34.34204], [-118.50395, 34.34205], [-118.50412, 34.34202], [-118.50426, 34.34196], [-118.50438, 34.34189], [-118.50451, 34.34178], [-118.50456, 34.34176], [-118.50467, 34.34176], [-118.50476, 34.34183], [-118.50482, 34.342], [-118.50481, 34.34208], [-118.50479, 34.34218], [-118.50418, 34.34376], [-118.50372, 34.34488], [-118.50352, 34.34546], [-118.50347, 34.34573], [-118.50349, 34.34617], [-118.5028, 34.34557], [-118.50237, 34.34581], [-118.50235, 34.34589], [-118.50259, 34.34611], [-118.50311, 34.34639], [-118.50311, 34.34656], [-118.50351, 34.34692], [-118.50345, 34.34741], [-118.50332, 34.3477], [-118.50329, 34.34781], [-118.50328, 34.34815], [-118.5033, 34.34859], [-118.50335, 34.34912], [-118.50343, 34.34965], [-118.50352, 34.35006], [-118.50352, 34.35014], [-118.50346, 34.35024], [-118.50335, 34.3503], [-118.50284, 34.35033], [-118.50267, 34.35038], [-118.50258, 34.35045], [-118.50253, 34.35054], [-118.5025, 34.35063], [-118.50251, 34.35073], [-118.50257, 34.35083], [-118.50266, 34.35092], [-118.50322, 34.35116], [-118.50311, 34.35141], [-118.50304, 34.3517], [-118.50329, 34.35173], [-118.50338, 34.35144], [-118.50349, 34.35121], [-118.50365, 34.35099], [-118.50387, 34.35079], [-118.504, 34.35129], [-118.50382, 34.35176], [-118.50417, 34.35214], [-118.49895, 34.35224], [-118.4988, 34.35155], [-118.49516, 34.35161], [-118.49287, 34.34043], [-118.49077, 34.32978], [-118.49087, 34.32952], [-118.49073, 34.32943], [-118.49094, 34.32886], [-118.49202, 34.32845], [-118.49164, 34.32997], [-118.49181, 34.33008], [-118.49224, 34.32836], [-118.49355, 34.32962], [-118.49553, 34.32907], [-118.49586, 34.32851], [-118.49812, 34.32851], [-118.49829, 34.32887], [-118.49766, 34.32878], [-118.49735, 34.32883], [-118.49734, 34.32885], [-118.49736, 34.32891], [-118.49745, 34.32893], [-118.49754, 34.32896], [-118.49764, 34.32904], [-118.49776, 34.32905], [-118.49783, 34.32909], [-118.49787, 34.32919], [-118.49793, 34.32922], [-118.49809, 34.32924], [-118.49817, 34.32931], [-118.49839, 34.32929], [-118.49858, 34.33091], [-118.49864, 34.33107], [-118.49871, 34.33115], [-118.49998, 34.33231], [-118.50004, 34.33229], [-118.50058, 34.33321], [-118.50057, 34.33384], [-118.50052, 34.3339], [-118.50063, 34.33398], [-118.50069, 34.33394], [-118.50266, 34.3355], [-118.50322, 34.3357], [-118.50313, 34.33646], [-118.50358, 34.33667], [-118.50371, 34.337], [-118.50379, 34.33716], [-118.50381, 34.33716], [-118.50387, 34.33726], [-118.50381, 34.33731], [-118.5024, 34.33646], [-118.50238, 34.33646], [-118.50234, 34.33811], [-118.50189, 34.34125], [-118.50547, 34.34135]], [[-118.50144, 34.34439], [-118.50145, 34.34438], [-118.50144, 34.34437], [-118.50143, 34.34438], [-118.50144, 34.34439]]], [[[-118.50414, 34.33422], [-118.50355, 34.33549], [-118.50349, 34.33567], [-118.50345, 34.33587], [-118.50345, 34.33606], [-118.50349, 34.33625], [-118.50356, 34.3365], [-118.50331, 34.33638], [-118.50339, 34.33561], [-118.50275, 34.33538], [-118.50073, 34.33379], [-118.50075, 34.33318], [-118.50018, 34.33222], [-118.50356, 34.33061], [-118.50378, 34.33125], [-118.50403, 34.33224], [-118.5036, 34.3328], [-118.50334, 34.33331], [-118.50379, 34.33394], [-118.50414, 34.33422]]], [[[-118.50375, 34.35057], [-118.50348, 34.35082], [-118.50325, 34.35111], [-118.5027, 34.35087], [-118.50261, 34.35078], [-118.50257, 34.35067], [-118.50258, 34.35059], [-118.50261, 34.35052], [-118.50268, 34.35045], [-118.50276, 34.3504], [-118.50287, 34.35038], [-118.50331, 34.35037], [-118.50346, 34.35032], [-118.50352, 34.35027], [-118.50357, 34.3502], [-118.50359, 34.35013], [-118.50359, 34.35004], [-118.50361, 34.35004], [-118.50375, 34.35057]]], [[[-118.50544, 34.33608], [-118.50506, 34.33637], [-118.5042, 34.33701], [-118.5041, 34.33682], [-118.50404, 34.33666], [-118.50437, 34.33528], [-118.50451, 34.33513], [-118.50462, 34.33519], [-118.50489, 34.3349], [-118.50532, 34.33555], [-118.50544, 34.33608]]]]} | Open Access 1 | 46267 | Whitney Elsmere Open Space | 29551 | 1319 | Santa Clarita, City of 325 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 883.758 | Whitney Elsmere OS | 0 | Local Recreation Area 3 | 4 | |
16315 | 16315 | 16314 | {"type": "Polygon", "coordinates": [[[-117.75013, 34.14351], [-117.74586, 34.14597], [-117.74647, 34.14969], [-117.74658, 34.15137], [-117.74663, 34.15274], [-117.74628, 34.15259], [-117.74564, 34.1522], [-117.74456, 34.15887], [-117.74294, 34.15887], [-117.7437, 34.16054], [-117.74533, 34.1654], [-117.73329, 34.16538], [-117.72455, 34.16539], [-117.72452, 34.15812], [-117.72886, 34.15813], [-117.72883, 34.15457], [-117.73459, 34.15451], [-117.73743, 34.15192], [-117.73789, 34.15168], [-117.73816, 34.15144], [-117.73891, 34.15057], [-117.73908, 34.14982], [-117.73966, 34.14857], [-117.73975, 34.14831], [-117.73974, 34.1483], [-117.73938, 34.1483], [-117.7392, 34.14822], [-117.73908, 34.14819], [-117.73927, 34.14726], [-117.7417, 34.14724], [-117.74166, 34.14359], [-117.74219, 34.14357], [-117.74218, 34.1431], [-117.74202, 34.14165], [-117.74237, 34.14117], [-117.74267, 34.13948], [-117.7428, 34.13912], [-117.74325, 34.13857], [-117.74346, 34.13761], [-117.7433, 34.13722], [-117.7433, 34.13685], [-117.74318, 34.1367], [-117.74395, 34.13669], [-117.74364, 34.1369], [-117.74373, 34.13798], [-117.74353, 34.13807], [-117.74352, 34.13806], [-117.74343, 34.13805], [-117.74337, 34.13833], [-117.74348, 34.13835], [-117.74346, 34.13851], [-117.74361, 34.13853], [-117.7436, 34.13825], [-117.74387, 34.13821], [-117.74428, 34.13805], [-117.74455, 34.1387], [-117.74436, 34.13937], [-117.7441, 34.13964], [-117.74414, 34.1403], [-117.74382, 34.14072], [-117.74406, 34.14148], [-117.74426, 34.14177], [-117.74376, 34.14178], [-117.74371, 34.14356], [-117.75013, 34.14351]]]} | Open Access 1 | 6783 | Marshall Canyon Regional Park | 29278 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov/wps/portal/dpr/Parks/Marshall_Canyon_Park_And_Nursery | Los Angeles 6 | 734.701 | Marshall Canyon RP | 0 | Local Park 2 | 4 |
16803 | 16803 | 16802 | {"type": "Polygon", "coordinates": [[[-117.94459, 33.9753], [-117.94377, 33.98292], [-117.94094, 33.98271], [-117.94097, 33.98265], [-117.94088, 33.98262], [-117.94082, 33.9827], [-117.93444, 33.98223], [-117.9342, 33.98201], [-117.93398, 33.98185], [-117.93364, 33.98164], [-117.9322, 33.98094], [-117.93195, 33.98325], [-117.93128, 33.98988], [-117.93129, 33.98989], [-117.93184, 33.98993], [-117.93174, 33.99036], [-117.93169, 33.99074], [-117.93164, 33.99077], [-117.93132, 33.99082], [-117.93063, 33.99087], [-117.93029, 33.99086], [-117.92989, 33.99083], [-117.92988, 33.99086], [-117.9286, 33.99074], [-117.92872, 33.9897], [-117.92448, 33.98938], [-117.92439, 33.98921], [-117.92424, 33.98903], [-117.92407, 33.9889], [-117.92384, 33.98878], [-117.92351, 33.9887], [-117.92238, 33.98862], [-117.9224, 33.98852], [-117.92247, 33.98826], [-117.92255, 33.98806], [-117.92397, 33.98819], [-117.92417, 33.98746], [-117.92569, 33.98642], [-117.92475, 33.98546], [-117.92496, 33.98532], [-117.92505, 33.98521], [-117.92516, 33.98506], [-117.92563, 33.98532], [-117.92577, 33.98513], [-117.92585, 33.9849], [-117.92589, 33.98467], [-117.92584, 33.98385], [-117.92586, 33.98348], [-117.9259, 33.98319], [-117.926, 33.98276], [-117.92613, 33.98239], [-117.92618, 33.98218], [-117.92624, 33.98178], [-117.92636, 33.98063], [-117.92638, 33.98023], [-117.92635, 33.97979], [-117.92639, 33.97951], [-117.92645, 33.97936], [-117.92655, 33.9792], [-117.92667, 33.97908], [-117.92754, 33.97854], [-117.92763, 33.97755], [-117.92642, 33.97688], [-117.92522, 33.97687], [-117.92425, 33.97645], [-117.92427, 33.97571], [-117.92423, 33.97513], [-117.92386, 33.97512], [-117.92331, 33.97487], [-117.92331, 33.97477], [-117.92245, 33.97468], [-117.92207, 33.9748], [-117.9219, 33.97478], [-117.92208, 33.97404], [-117.92199, 33.97395], [-117.92204, 33.97332], [-117.92189, 33.97332], [-117.92181, 33.97364], [-117.92158, 33.974], [-117.92144, 33.97416], [-117.92109, 33.9745], [-117.91925, 33.97332], [-117.91911, 33.97215], [-117.91986, 33.97141], [-117.91893, 33.96997], [-117.91808, 33.96984], [-117.91729, 33.97016], [-117.91688, 33.96946], [-117.91593, 33.96916], [-117.91547, 33.96879], [-117.92386, 33.97074], [-117.92387, 33.97073], [-117.9239, 33.97052], [-117.92825, 33.97153], [-117.92824, 33.97175], [-117.9296, 33.97207], [-117.92961, 33.97206], [-117.92963, 33.97185], [-117.92965, 33.97185], [-117.93099, 33.97216], [-117.93305, 33.97264], [-117.93304, 33.97286], [-117.94259, 33.97506], [-117.94329, 33.975], [-117.94459, 33.9753]], [[-117.9363, 33.98086], [-117.93629, 33.98087], [-117.93677, 33.9816], [-117.93743, 33.98131], [-117.93696, 33.98056], [-117.9363, 33.98086]]]} | Open Access 1 | 6562 | Peter F Schabarum Regional County Park | 6064 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov/wps/portal/dpr/parks/peter_f_schabarum_regional_park | Los Angeles 6 | 621.792 | Peter F Schabarum Reg. County Park | 0 | Local Park 2 | 4 |
1649 | 1649 | 1648 | {"type": "MultiPolygon", "coordinates": [[[[-117.70252, 34.62762], [-117.70249, 34.63864], [-117.69592, 34.63871], [-117.69593, 34.63687], [-117.69482, 34.63688], [-117.69483, 34.63504], [-117.69373, 34.63504], [-117.69369, 34.63873], [-117.69146, 34.63875], [-117.69147, 34.63692], [-117.69137, 34.63691], [-117.69036, 34.63692], [-117.69035, 34.63876], [-117.68478, 34.63881], [-117.68481, 34.63143], [-117.68928, 34.6314], [-117.68928, 34.62771], [-117.69375, 34.62768], [-117.69376, 34.624], [-117.69823, 34.62397], [-117.69822, 34.62765], [-117.70252, 34.62762]]], [[[-117.70248, 34.64227], [-117.70247, 34.64598], [-117.69364, 34.64598], [-117.69366, 34.64235], [-117.70248, 34.64227]]]]} | Open Access 1 | 14183 | Carl O. Gerhardy Wildlife Sanctuary | 16854 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov/wps/portal/dpr/Parks/Carl_O_Gerhardy_Wildlife_Sanctuary | Los Angeles 6 | 552.259 | Carl O. Gerhardy Wildlife Sanctuary | 0 | Local Conservation Area 4 | 2 |
16033 | 16033 | 16032 | {"type": "Polygon", "coordinates": [[[-118.50024, 34.11059], [-118.49993, 34.11127], [-118.49951, 34.11125], [-118.49902, 34.11151], [-118.49904, 34.11211], [-118.49949, 34.11201], [-118.49966, 34.11289], [-118.49928, 34.11331], [-118.49883, 34.11314], [-118.49839, 34.1135], [-118.49848, 34.11373], [-118.49303, 34.11661], [-118.49324, 34.11737], [-118.49254, 34.11879], [-118.4918, 34.11907], [-118.49155, 34.11941], [-118.49164, 34.11959], [-118.49304, 34.11978], [-118.49374, 34.11932], [-118.49489, 34.11912], [-118.49555, 34.11945], [-118.49509, 34.12066], [-118.49438, 34.12149], [-118.4947, 34.12181], [-118.49536, 34.12163], [-118.49601, 34.122], [-118.49503, 34.1225], [-118.49549, 34.12327], [-118.49705, 34.12272], [-118.49721, 34.12285], [-118.49699, 34.1232], [-118.49699, 34.12321], [-118.49721, 34.12332], [-118.49793, 34.12307], [-118.4981, 34.12327], [-118.49774, 34.12355], [-118.4981, 34.12408], [-118.49847, 34.12381], [-118.49903, 34.1256], [-118.49701, 34.12626], [-118.49906, 34.12798], [-118.49735, 34.1281], [-118.49684, 34.12796], [-118.49635, 34.12924], [-118.49626, 34.12906], [-118.49521, 34.12845], [-118.4949, 34.12743], [-118.4943, 34.12742], [-118.49344, 34.12714], [-118.49245, 34.12805], [-118.49227, 34.12901], [-118.49102, 34.12884], [-118.49048, 34.12842], [-118.49021, 34.12845], [-118.4902, 34.12842], [-118.48997, 34.12692], [-118.49011, 34.1268], [-118.48988, 34.12643], [-118.48988, 34.1264], [-118.49024, 34.12607], [-118.49032, 34.12523], [-118.49012, 34.1251], [-118.48979, 34.12508], [-118.48887, 34.12535], [-118.48808, 34.1259], [-118.48716, 34.12628], [-118.48673, 34.12707], [-118.48767, 34.12855], [-118.4876, 34.12939], [-118.48775, 34.12941], [-118.4877, 34.12979], [-118.48658, 34.12973], [-118.48627, 34.12909], [-118.48584, 34.1272], [-118.4852, 34.1272], [-118.48511, 34.12649], [-118.4842, 34.12659], [-118.48371, 34.12717], [-118.48319, 34.12747], [-118.48337, 34.12612], [-118.48367, 34.12521], [-118.48318, 34.12485], [-118.4832, 34.12456], [-118.48353, 34.12423], [-118.48337, 34.12375], [-118.48247, 34.1235], [-118.48231, 34.12307], [-118.48235, 34.12295], [-118.48217, 34.12149], [-118.48259, 34.12109], [-118.48269, 34.11949], [-118.48241, 34.11902], [-118.48253, 34.11889], [-118.48265, 34.1187], [-118.48275, 34.11835], [-118.48277, 34.11821], [-118.48277, 34.11801], [-118.48275, 34.11782], [-118.48273, 34.11776], [-118.48272, 34.11573], [-118.48425, 34.11628], [-118.48501, 34.11684], [-118.4854, 34.1166], [-118.48601, 34.11697], [-118.48643, 34.1167], [-118.48705, 34.11702], [-118.48719, 34.11693], [-118.48705, 34.11654], [-118.48791, 34.11631], [-118.48742, 34.11571], [-118.48791, 34.11531], [-118.48844, 34.11531], [-118.48874, 34.11564], [-118.48895, 34.11524], [-118.48942, 34.11523], [-118.48953, 34.11507], [-118.48886, 34.11464], [-118.48853, 34.11425], [-118.48824, 34.11418], [-118.48799, 34.11381], [-118.48819, 34.11317], [-118.48867, 34.11287], [-118.48897, 34.11314], [-118.48947, 34.11301], [-118.48961, 34.11329], [-118.49137, 34.11401], [-118.49139, 34.11368], [-118.49179, 34.11353], [-118.49132, 34.11316], [-118.49141, 34.11286], [-118.49169, 34.11264], [-118.49189, 34.1128], [-118.49241, 34.11285], [-118.49271, 34.1127], [-118.49233, 34.11256], [-118.49209, 34.11176], [-118.49327, 34.1113], [-118.49327, 34.11129], [-118.49318, 34.11118], [-118.49626, 34.11118], [-118.49627, 34.11007], [-118.4981, 34.10916], [-118.49927, 34.10917], [-118.49905, 34.10959], [-118.49922, 34.10962], [-118.49963, 34.10977], [-118.49969, 34.10978], [-118.49963, 34.11008], [-118.50002, 34.11021], [-118.4999, 34.11047], [-118.50024, 34.11059]]]} | Open Access 1 | 6368 | Mission Canyon Open Space | 6051 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://www.lamountains.com/parks.asp?parkid=64 | Los Angeles 6 | 480.167 | Mission Canyon OS | 0 | Local Recreation Area 3 | 4 |
16062 | 16062 | 16061 | {"type": "Polygon", "coordinates": [[[-118.21741, 34.23745], [-118.21722, 34.24452], [-118.21284, 34.2442], [-118.21294, 34.24101], [-118.21293, 34.241], [-118.20852, 34.24092], [-118.20841, 34.24387], [-118.20398, 34.24355], [-118.20426, 34.23723], [-118.20431, 34.23366], [-118.20649, 34.23369], [-118.2083, 34.23106], [-118.20982, 34.22811], [-118.21084, 34.22869], [-118.21091, 34.22868], [-118.21098, 34.22864], [-118.21133, 34.22834], [-118.21139, 34.22827], [-118.21146, 34.22812], [-118.21187, 34.22837], [-118.21208, 34.22823], [-118.21233, 34.22814], [-118.21242, 34.22809], [-118.21258, 34.22789], [-118.21276, 34.22776], [-118.2129, 34.22771], [-118.21311, 34.22768], [-118.21319, 34.22762], [-118.21328, 34.22765], [-118.21332, 34.22758], [-118.21332, 34.22747], [-118.21328, 34.2274], [-118.21321, 34.22733], [-118.21319, 34.22729], [-118.21321, 34.22707], [-118.21362, 34.2272], [-118.21387, 34.22687], [-118.21432, 34.22655], [-118.21681, 34.22656], [-118.21612, 34.22701], [-118.21663, 34.22744], [-118.21527, 34.22884], [-118.21313, 34.23018], [-118.2131, 34.23379], [-118.21162, 34.23378], [-118.21159, 34.23734], [-118.21741, 34.23745]]]} | Open Access 1 | 6943 | Winery Canyon Open Space | 6117 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 342.872 | Winery Canyon OS | 0 | Local Recreation Area 3 | 4 | |
4355 | 4355 | 4354 | {"type": "Polygon", "coordinates": [[[-117.89899, 34.6164], [-117.89012, 34.61649], [-117.89008, 34.61647], [-117.89004, 34.61644], [-117.88983, 34.60198], [-117.89861, 34.60192], [-117.89899, 34.6164]]]} | Open Access 1 | 45699 | Alpine Butte Wildlife Sanctuary | 28598 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov/wps/portal/dpr/Parks/Alpine_Butte_Wildlife_Sanctuary | Los Angeles 6 | 323.116 | Alpine Butte Wildlife Sanctuary | 0 | Local Conservation Area 4 | 2 |
8243 | 8243 | 8242 | {"type": "Polygon", "coordinates": [[[-118.46707, 34.3301], [-118.46689, 34.33699], [-118.44933, 34.3374], [-118.44942, 34.32994], [-118.46482, 34.33008], [-118.46481, 34.33011], [-118.46429, 34.3302], [-118.46422, 34.33041], [-118.46386, 34.33059], [-118.46412, 34.33168], [-118.46383, 34.33173], [-118.46383, 34.33174], [-118.46393, 34.33219], [-118.46417, 34.33245], [-118.46391, 34.3328], [-118.46432, 34.3331], [-118.46458, 34.33243], [-118.46458, 34.332], [-118.46516, 34.33138], [-118.46517, 34.33076], [-118.46563, 34.33072], [-118.46562, 34.33062], [-118.46564, 34.33048], [-118.46525, 34.33044], [-118.46531, 34.33009], [-118.46707, 34.3301]]]} | Open Access 1 | 12580 | Rim of the Valley County Parkland | 6072 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 311.899 | Rim of the Valley County Parkland | 0 | Local Park 2 | 4 | |
16246 | 16246 | 16245 | {"type": "MultiPolygon", "coordinates": [[[[-118.55666, 34.36353], [-118.55638, 34.36353], [-118.55606, 34.36251], [-118.55601, 34.36229], [-118.5559, 34.36205], [-118.55584, 34.36184], [-118.55603, 34.36154], [-118.55616, 34.36122], [-118.5562, 34.36102], [-118.55622, 34.36086], [-118.55622, 34.36066], [-118.55619, 34.36047], [-118.55624, 34.36041], [-118.55647, 34.36049], [-118.55666, 34.36063], [-118.5568, 34.36081], [-118.55687, 34.36101], [-118.55687, 34.36112], [-118.55686, 34.36123], [-118.55644, 34.36285], [-118.55666, 34.36353]]], [[[-118.5637, 34.36721], [-118.55864, 34.36719], [-118.55799, 34.36633], [-118.55783, 34.36608], [-118.55762, 34.36568], [-118.55724, 34.36447], [-118.55731, 34.36444], [-118.55715, 34.36394], [-118.55707, 34.36395], [-118.55678, 34.36302], [-118.55681, 34.36242], [-118.55734, 34.36199], [-118.55741, 34.36171], [-118.55717, 34.36119], [-118.55718, 34.36099], [-118.55713, 34.36079], [-118.55702, 34.36058], [-118.55685, 34.36041], [-118.55671, 34.36031], [-118.55654, 34.36023], [-118.55615, 34.36014], [-118.55597, 34.35986], [-118.56368, 34.35989], [-118.5637, 34.36721]]], [[[-118.58964, 34.37075], [-118.58812, 34.37037], [-118.58532, 34.37075], [-118.58102, 34.37074], [-118.58107, 34.37367], [-118.58021, 34.37368], [-118.57873, 34.37313], [-118.5763, 34.37189], [-118.57482, 34.37037], [-118.57234, 34.36904], [-118.57228, 34.36716], [-118.58094, 34.36723], [-118.58962, 34.36713], [-118.58964, 34.37075]]]]} | Open Access 1 | 46255 | Rivendale Ranch Open Space | 29537 | 1319 | Santa Clarita, City of 325 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 297.561 | Rivendale Ranch OS | 0 | Local Recreation Area 3 | 4 | |
13747 | 13747 | 13746 | {"type": "Polygon", "coordinates": [[[-118.09628, 34.19339], [-118.09212, 34.19355], [-118.09205, 34.19733], [-118.08544, 34.19732], [-118.08551, 34.19363], [-118.08347, 34.19364], [-118.08339, 34.18984], [-118.0877, 34.1898], [-118.0876, 34.18602], [-118.09189, 34.186], [-118.09199, 34.1893], [-118.09196, 34.18935], [-118.09195, 34.1894], [-118.09196, 34.18945], [-118.09199, 34.18949], [-118.09206, 34.19165], [-118.09415, 34.19159], [-118.09411, 34.18973], [-118.09621, 34.18968], [-118.09628, 34.19339]]]} | Open Access 1 | 46244 | Eaton Canyon Open Space | 29522 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 215.911 | Eaton Canyon OS | 0 | Local Recreation Area 3 | 4 | |
16051 | 16051 | 16050 | {"type": "Polygon", "coordinates": [[[-118.29278, 34.22166], [-118.2774, 34.22176], [-118.27738, 34.21871], [-118.2773, 34.21531], [-118.27834, 34.21531], [-118.27835, 34.21456], [-118.28057, 34.21456], [-118.28668, 34.2146], [-118.29156, 34.2202], [-118.29278, 34.22166]], [[-118.28164, 34.21533], [-118.28164, 34.21532], [-118.28095, 34.21457], [-118.27956, 34.21495], [-118.27872, 34.21549], [-118.27971, 34.21654], [-118.28164, 34.21533]]]} | Open Access 1 | 6829 | Henderson Canyon Open Space | 19812 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 214.059 | Henderson Canyon OS | 0 | Local Recreation Area 3 | 4 | |
15719 | 15719 | 15718 | {"type": "Polygon", "coordinates": [[[-118.34366, 33.88545], [-118.34013, 33.88558], [-118.34029, 33.88725], [-118.33518, 33.88725], [-118.33518, 33.88623], [-118.33512, 33.88577], [-118.33502, 33.88542], [-118.33485, 33.88504], [-118.33464, 33.88473], [-118.33435, 33.88438], [-118.33447, 33.88429], [-118.33398, 33.88376], [-118.33384, 33.88384], [-118.33158, 33.88141], [-118.34006, 33.87868], [-118.34007, 33.87869], [-118.3403, 33.87861], [-118.3403, 33.8786], [-118.34353, 33.87755], [-118.34365, 33.87762], [-118.34366, 33.88545]]]} | Restricted Access 2 | 44523 | Alondra Golf Course | 33106 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 187.746 | Alondra GC | 0 | Local Recreation Area 3 | 4 | |
4892 | 4892 | 4891 | {"type": "MultiPolygon", "coordinates": [[[[-118.15498, 33.83254], [-118.15491, 33.83579], [-118.15381, 33.83579], [-118.15367, 33.83568], [-118.15367, 33.83541], [-118.15336, 33.8354], [-118.15335, 33.83567], [-118.15358, 33.83568], [-118.15378, 33.83584], [-118.15123, 33.83584], [-118.15123, 33.83648], [-118.15303, 33.83854], [-118.15303, 33.83964], [-118.14813, 33.83963], [-118.14827, 33.83948], [-118.14837, 33.83933], [-118.14842, 33.83919], [-118.1485, 33.83886], [-118.15013, 33.83865], [-118.15122, 33.83875], [-118.15122, 33.8381], [-118.1496, 33.83658], [-118.14871, 33.83658], [-118.14676, 33.83715], [-118.14799, 33.83893], [-118.14829, 33.83889], [-118.14823, 33.83915], [-118.14819, 33.83926], [-118.14811, 33.83939], [-118.14799, 33.83951], [-118.14782, 33.83963], [-118.14742, 33.83963], [-118.14397, 33.83644], [-118.14405, 33.83636], [-118.14424, 33.83639], [-118.14429, 33.83617], [-118.14441, 33.83597], [-118.1462, 33.83409], [-118.14639, 33.83392], [-118.14756, 33.833], [-118.14768, 33.83283], [-118.14773, 33.8327], [-118.14775, 33.83255], [-118.14781, 33.83251], [-118.15469, 33.83253], [-118.1547, 33.83254], [-118.15498, 33.83254]]], [[[-118.15984, 33.8286], [-118.15959, 33.8286], [-118.15661, 33.83004], [-118.15469, 33.83035], [-118.15293, 33.83225], [-118.15, 33.83223], [-118.15104, 33.82949], [-118.15192, 33.82897], [-118.1541, 33.82898], [-118.15411, 33.82768], [-118.15982, 33.82769], [-118.15984, 33.8286]]]]} | Restricted Access 2 | 45718 | Lakewood Golf Course | 33113 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov/wps/portal/dpr/ThingsToDo/Golf/Lakewood_Golf_Course | Los Angeles 6 | 176.286 | Lakewood GC | 0 | Local Recreation Area 3 | 4 |
2202 | 2202 | 2201 | {"type": "Polygon", "coordinates": [[[-118.27588, 33.85284], [-118.2733, 33.85587], [-118.27289, 33.855], [-118.27131, 33.85628], [-118.27096, 33.85622], [-118.27087, 33.85665], [-118.26832, 33.85666], [-118.26831, 33.85663], [-118.26621, 33.85662], [-118.26616, 33.85657], [-118.26515, 33.84858], [-118.26738, 33.84759], [-118.26891, 33.84731], [-118.26947, 33.84787], [-118.26991, 33.84825], [-118.26994, 33.84841], [-118.27012, 33.84858], [-118.2705, 33.84889], [-118.27057, 33.84885], [-118.2725, 33.85028], [-118.2731, 33.85068], [-118.27588, 33.85284]]]} | Restricted Access 2 | 6243 | Victoria Golf Course | 33008 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 167.229 | Victoria GC | 0 | Local Recreation Area 3 | 4 | |
16928 | 16928 | 16927 | {"type": "Polygon", "coordinates": [[[-117.78685, 34.08806], [-117.78682, 34.08835], [-117.78544, 34.08847], [-117.78504, 34.08832], [-117.78493, 34.08852], [-117.78422, 34.08859], [-117.78404, 34.08903], [-117.78041, 34.08809], [-117.78037, 34.08814], [-117.77867, 34.08717], [-117.77694, 34.08623], [-117.77698, 34.0862], [-117.77697, 34.08618], [-117.77522, 34.08526], [-117.77486, 34.08403], [-117.77477, 34.08386], [-117.77462, 34.08372], [-117.77291, 34.08262], [-117.77288, 34.08258], [-117.77288, 34.08254], [-117.77302, 34.08229], [-117.77324, 34.08205], [-117.77352, 34.08184], [-117.77384, 34.08168], [-117.77419, 34.08158], [-117.77412, 34.08161], [-117.77412, 34.08163], [-117.77559, 34.08135], [-117.77669, 34.08111], [-117.77718, 34.08098], [-117.77767, 34.08079], [-117.77822, 34.08051], [-117.77878, 34.08014], [-117.77903, 34.07993], [-117.77937, 34.07959], [-117.77961, 34.07928], [-117.77973, 34.07925], [-117.7799, 34.07934], [-117.78382, 34.08108], [-117.78097, 34.08373], [-117.78204, 34.08539], [-117.78408, 34.0849], [-117.78541, 34.08509], [-117.78685, 34.08806]]]} | Restricted Access 2 | 46285 | Mountain Meadows Golf Course | 33118 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov/wps/portal/dpr/ThingsToDo/Golf/Mountain_Meadows_Golf_Course | Los Angeles 6 | 165.184 | Mtn. Meadows GC | 0 | Local Recreation Area 3 | 4 |
15663 | 15663 | 15662 | {"type": "Polygon", "coordinates": [[[-118.40577, 33.76235], [-118.40543, 33.76277], [-118.40476, 33.76288], [-118.40115, 33.76183], [-118.40043, 33.76139], [-118.39873, 33.75821], [-118.39882, 33.75812], [-118.3989, 33.758], [-118.39899, 33.7578], [-118.39901, 33.75768], [-118.39901, 33.75754], [-118.39898, 33.75742], [-118.39888, 33.75722], [-118.39883, 33.75706], [-118.39879, 33.75691], [-118.39878, 33.75667], [-118.39884, 33.75634], [-118.39895, 33.75609], [-118.39942, 33.7554], [-118.39929, 33.75534], [-118.3988, 33.75604], [-118.39865, 33.75639], [-118.39861, 33.75662], [-118.39862, 33.7568], [-118.39833, 33.75685], [-118.3983, 33.75674], [-118.39837, 33.75604], [-118.39856, 33.7544], [-118.40003, 33.75192], [-118.39994, 33.75125], [-118.39987, 33.75101], [-118.39978, 33.75086], [-118.39962, 33.75068], [-118.39956, 33.75063], [-118.3993, 33.75049], [-118.39909, 33.75043], [-118.3989, 33.75041], [-118.39871, 33.75041], [-118.39843, 33.75047], [-118.3983, 33.75051], [-118.39609, 33.75167], [-118.3959, 33.75181], [-118.3958, 33.75191], [-118.39569, 33.75208], [-118.3957, 33.75216], [-118.3956, 33.75209], [-118.39539, 33.752], [-118.39546, 33.75197], [-118.39555, 33.75184], [-118.39507, 33.75161], [-118.39476, 33.7508], [-118.39504, 33.75018], [-118.39573, 33.74968], [-118.39552, 33.74935], [-118.39672, 33.74876], [-118.39875, 33.74843], [-118.39979, 33.74782], [-118.40117, 33.74652], [-118.40172, 33.74643], [-118.40231, 33.74691], [-118.40191, 33.74915], [-118.403, 33.75085], [-118.40334, 33.75309], [-118.404, 33.75374], [-118.40391, 33.75506], [-118.40227, 33.75588], [-118.40141, 33.75658], [-118.40141, 33.75804], [-118.40296, 33.76003], [-118.40533, 33.76169], [-118.40577, 33.76235]]]} | Restricted Access 2 | 5866 | Los Verdes Golf Course | 33003 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 162.838 | Los Verdes GC | 0 | Local Recreation Area 3 | 4 | |
1378 | 1378 | 1377 | {"type": "Polygon", "coordinates": [[[-117.77409, 34.77926], [-117.77404, 34.78659], [-117.76531, 34.78638], [-117.76533, 34.77908], [-117.77409, 34.77926]]]} | Open Access 1 | 8395 | Phacelia Wildlife Sanctuary | 23638 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 160.496 | Phacelia Wildlife Sanctuary | 0 | Local Conservation Area 4 | 2 | |
4316 | 4316 | 4315 | {"type": "Polygon", "coordinates": [[[-117.71308, 34.52742], [-117.7107, 34.52743], [-117.70912, 34.52733], [-117.70868, 34.52731], [-117.70817, 34.52733], [-117.70657, 34.52746], [-117.70429, 34.52748], [-117.70429, 34.52697], [-117.70443, 34.52566], [-117.70444, 34.52536], [-117.70442, 34.52507], [-117.70429, 34.52397], [-117.70426, 34.52396], [-117.70423, 34.5203], [-117.71303, 34.52029], [-117.71308, 34.52742]]]} | Open Access 1 | 45408 | Payne Wildlife Sanctuary | 28183 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 156.867 | Payne Wildlife Sanctuary | 0 | Local Conservation Area 4 | 2 |
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]);