units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,219 rows where MNG_AG_TYP = 3
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Los Angeles, County of 153
- Santa Barbara, County of 109
- San Diego, County of 105
- Orange, County of 85
- Sacramento, County of 56
- Lake, County of 54
- Butte, County of 53
- Kern, County of 47
- El Dorado, County of 44
- Santa Cruz, County of 43
- Monterey, County of 43
- Riverside, County of 36
- Placer, County of 27
- San Luis Obispo, County of 25
- Stanislaus, County of 24
- Ventura, County of 23
- San Joaquin, County of 21
- San Bernardino, County of 20
- Yolo, County of 18
- Merced, County of 16
- Fresno, County of 15
- Humboldt, County of 12
- Tulare, County of 10
- Mono, County of 7
- Tehama, County of 7
- Mendocino, County of 7
- Lassen, County of 6
- Mariposa, County of 5
- Imperial, County of 5
- Napa, County of 5
- …
DES_TP >30
- Local Park 584
- Local Other or Unknown 208
- Local Recreation Area 113
- Local Conservation Area 95
- Local Historic or Cultural Area 18
- National Recreation Area 3
- National Monument or Landmark 2
- National Forest 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
ACCESS_TYP 4
- Open Access 1,010
- Restricted Access 57
- Unknown Access 35
- No Public Access 24
MNG_AG_TYP 1
- County Agency · 1,126 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1159 | 1159 | 1158 | {"type": "Polygon", "coordinates": [[[-116.86115, 32.85694], [-116.85942, 32.85842], [-116.85825, 32.85715], [-116.85827, 32.85712], [-116.86003, 32.85568], [-116.86115, 32.85694]]]} | Open Access 1 | 7359 | Rios Canyon Park | 24393 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | San Diego 4 | 10.061 | Rios Canyon Park | 0 | Local Park 2 | 4 | |
1198 | 1198 | 1197 | {"type": "Polygon", "coordinates": [[[-117.94417, 33.99296], [-117.94358, 33.99312], [-117.94315, 33.99321], [-117.94258, 33.9933], [-117.94209, 33.99335], [-117.94199, 33.99239], [-117.94203, 33.99236], [-117.94252, 33.99232], [-117.94272, 33.99228], [-117.94343, 33.99205], [-117.94387, 33.99201], [-117.94393, 33.99239], [-117.94417, 33.99296]]]} | Open Access 1 | 8300 | Pepperbrook Park | 23596 | 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 | 5.118 | Pepperbrook Park | 0 | Local Park 2 | 4 | |
1324 | 1324 | 1323 | {"type": "Polygon", "coordinates": [[[-117.28327, 33.05261], [-117.28325, 33.0544], [-117.28105, 33.05439], [-117.27903, 33.05436], [-117.27912, 33.0521], [-117.27921, 33.0508], [-117.28122, 33.05083], [-117.28114, 33.05261], [-117.28327, 33.05261]]]} | Open Access 1 | 47628 | San Diego Botanic Garden | 31367 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdbgarden.org/ | San Diego 4 | 28.386 | San Diego Botanic Garden | 0 | Local Park 2 | 4 |
1333 | 1333 | 1332 | {"type": "Polygon", "coordinates": [[[-114.72616, 33.40354], [-114.72479, 33.40354], [-114.72438, 33.40263], [-114.72394, 33.40197], [-114.72359, 33.40161], [-114.72338, 33.40102], [-114.72304, 33.4002], [-114.72212, 33.39886], [-114.72184, 33.39858], [-114.72184, 33.39738], [-114.72616, 33.40354]]]} | Open Access 1 | 7580 | Palo Verde County Park | 23359 | 302 | Imperial, County of 348 | County 3 | County Agency 3 | http://www.icpds.com/?pid=1048 | County 3 | 302 | Imperial, County of 345 | County 3 | County Agency 3 | Imperial 20 | 13.919 | Palo Verde County Park | 0 | Local Park 2 | 4 | |
1357 | 1357 | 1356 | {"type": "Polygon", "coordinates": [[[-121.9737, 36.9789], [-121.97373, 36.97903], [-121.97373, 36.97947], [-121.97365, 36.97963], [-121.97249, 36.97967], [-121.97247, 36.97939], [-121.97093, 36.97945], [-121.97096, 36.97932], [-121.97243, 36.97925], [-121.97242, 36.97895], [-121.9737, 36.9789]]]} | Open Access 1 | 7881 | Coffee Lane Park | 17475 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 2.75 | Coffee Lane Park | 0 | Local Park 2 | 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 | |
1400 | 1400 | 1399 | {"type": "Polygon", "coordinates": [[[-119.87288, 34.43682], [-119.8723, 34.43682], [-119.87211, 34.43667], [-119.872, 34.43654], [-119.87193, 34.43639], [-119.8719, 34.43628], [-119.87195, 34.43605], [-119.87205, 34.43605], [-119.87221, 34.43614], [-119.87248, 34.4365], [-119.87277, 34.43651], [-119.87288, 34.43682]]]} | Open Access 1 | 16492 | Glen Annie at Del Norte | 19314 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 0.987 | Glen Annie at Del Norte | None 119 | |||
1403 | 1403 | 1402 | {"type": "Polygon", "coordinates": [[[-119.78424, 36.31712], [-119.78421, 36.3183], [-119.78422, 36.31887], [-119.78171, 36.3189], [-119.7817, 36.31897], [-119.78093, 36.31891], [-119.78091, 36.31714], [-119.78424, 36.31712]]]} | Open Access 1 | 8812 | Lemoore Cemetery | 21157 | 304 | Kings, County of 360 | County 3 | County Agency 3 | http://www.countyofkings.com/departments/public-works | County 3 | 304 | Kings, County of 357 | County 3 | County Agency 3 | Kings 44 | 14.396 | Lemoore Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
1439 | 1439 | 1438 | {"type": "Polygon", "coordinates": [[[-117.05558, 34.05159], [-117.05545, 34.05175], [-117.05444, 34.0525], [-117.05184, 34.05424], [-117.05145, 34.05409], [-117.05134, 34.05427], [-117.05134, 34.05498], [-117.0513, 34.05528], [-117.05108, 34.05543], [-117.0508, 34.05546], [-117.05046, 34.0553], [-117.05017, 34.05522], [-117.04994, 34.05551], [-117.04958, 34.05577], [-117.04936, 34.05601], [-117.04886, 34.0572], [-117.04871, 34.05734], [-117.04842, 34.05741], [-117.04818, 34.05735], [-117.04804, 34.05738], [-117.04789, 34.05753], [-117.04769, 34.05762], [-117.04748, 34.05764], [-117.04732, 34.05762], [-117.04713, 34.05751], [-117.04697, 34.05731], [-117.04663, 34.05717], [-117.0467, 34.05696], [-117.04647, 34.05691], [-117.04591, 34.05682], [-117.04577, 34.05674], [-117.04569, 34.05659], [-117.04538, 34.05693], [-117.04483, 34.05699], [-117.04455, 34.05717], [-117.04449, 34.05742], [-117.0447, 34.05762], [-117.04386, 34.05799], [-117.04366, 34.05721], [-117.04564, 34.05461], [-117.04584, 34.05406], [-117.04551, 34.05387], [-117.04517, 34.05357], [-117.04519, 34.05127], [-117.04077, 34.05125], [-117.04071, 34.05101], [-117.04064, 34.05078], [-117.04044, 34.05037], [-117.04033, 34.05004], [-117.04028, 34.04854], [-117.04063, 34.0485], [-117.04379, 34.04851], [-117.0438, 34.04906], [-117.04521, 34.04906], [-117.04521, 34.04884], [-117.04512, 34.0486], [-117.0491, 34.04862], [-117.04886, 34.04874], [-117.04844, 34.04904], [-117.04816, 34.04953], [-117.04817, 34.04955], [-117.0485, 34.04939], [-117.04964, 34.04906], [-117.05035, 34.04876], [-117.05074, 34.04867], [-117.0512, 34.04874], [-117.0515, 34.04885], [-117.05136, 34.04943], [-117.05254, 34.04955], [-117.05255, 34.04987], [-117.05273, 34.05013], [-117.053, 34.05018], [-117.05322, 34.05005], [-117.05421, 34.05028], [-117.05444, 34.0504], [-117.05501, 34.05105], [-117.05545, 34.05101], [-117.05558, 34.05159]], [[-117.04938, 34.05312], [-117.0481, 34.05208], [-117.04792, 34.05228], [-117.04803, 34.05297], [-117.04757, 34.05379], [-117.04726, 34.05442], [-117.04744, 34.05453], [-117.04785, 34.05438], [-117.0478, 34.0547], [-117.04726, 34.05476], [-117.04733, 34.05513], [-117.04728, 34.05535], [-117.04702, 34.05543], [-117.04661, 34.0555], [-117.04655, 34.05569], [-117.04689, 34.05589], [-117.04715, 34.05586], [-117.04751, 34.05546], [-117.04772, 34.05526], [-117.04798, 34.05513], [-117.04819, 34.05481], [-117.0484, 34.05459], [-117.04892, 34.05429], [-117.04892, 34.0537], [-117.04938, 34.05312]], [[-117.04926, 34.05164], [-117.04952, 34.05207], [-117.04972, 34.05212], [-117.04993, 34.05207], [-117.05045, 34.05144], [-117.05102, 34.04999], [-117.04996, 34.04954], [-117.0497, 34.04938], [-117.04965, 34.04987], [-117.04952, 34.05034], [-117.04959, 34.05071], [-117.04952, 34.05097], [-117.04928, 34.05144], [-117.04926, 34.05164]]]} | Open Access 1 | 6427 | Yucaipa Regional Park | 10147 | 318 | San Bernardino, County of 368 | County 3 | County Agency 3 | http://cms.sbcounty.gov/parks/Home.aspx | County 3 | 318 | San Bernardino, County of 363 | County 3 | County Agency 3 | http://cms.sbcounty.gov/parks/Parks/YucaipaRegionalPark.aspx | San Bernardino 22 | 172.247 | Yucaipa RP | 0 | Local Park 2 | 4 |
1479 | 1479 | 1478 | {"type": "Polygon", "coordinates": [[[-121.62993, 36.69624], [-121.62762, 36.69442], [-121.62979, 36.69262], [-121.63183, 36.6944], [-121.63188, 36.69446], [-121.63189, 36.69452], [-121.63188, 36.69459], [-121.63186, 36.69463], [-121.62993, 36.69624]]]} | Open Access 1 | 10118 | Constitution Soccer Complex | 17603 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | http://www.co.monterey.ca.us/parks/ | County 3 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | Monterey 14 | 19.339 | Constitution Soccer Complex | 0 | Local Recreation Area 3 | 4 | |
1530 | 1530 | 1529 | {"type": "MultiPolygon", "coordinates": [[[[-118.24585, 34.05493], [-118.24508, 34.05575], [-118.24423, 34.05519], [-118.245, 34.05437], [-118.24585, 34.05493]]], [[[-118.24802, 34.05649], [-118.24774, 34.05684], [-118.24735, 34.05721], [-118.24724, 34.05714], [-118.24721, 34.05717], [-118.24519, 34.05598], [-118.24595, 34.05518], [-118.24772, 34.05633], [-118.24775, 34.05632], [-118.24802, 34.05649]]]]} | Open Access 1 | 12926 | Grand Park | 29040 | 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 | 9.306 | Grand Park | 0 | Local Park 2 | 4 | |
1560 | 1560 | 1559 | {"type": "MultiPolygon", "coordinates": [[[[-116.67869, 33.12778], [-116.67507, 33.1291], [-116.67083, 33.12914], [-116.66826, 33.12896], [-116.66617, 33.12917], [-116.66555, 33.12932], [-116.66459, 33.12981], [-116.66349, 33.13111], [-116.66203, 33.13263], [-116.66257, 33.13857], [-116.65983, 33.1441], [-116.65087, 33.13807], [-116.64428, 33.13531], [-116.64222, 33.13439], [-116.64213, 33.13433], [-116.64207, 33.13431], [-116.64201, 33.13432], [-116.63822, 33.13266], [-116.63537, 33.13001], [-116.62768, 33.12661], [-116.61609, 33.1216], [-116.61608, 33.1216], [-116.6161, 33.12308], [-116.60157, 33.12331], [-116.60159, 33.12309], [-116.60164, 33.12292], [-116.60177, 33.12264], [-116.60204, 33.12221], [-116.60219, 33.12188], [-116.6028, 33.11983], [-116.60294, 33.11942], [-116.61572, 33.10683], [-116.61854, 33.10692], [-116.63257, 33.10687], [-116.63264, 33.10942], [-116.63262, 33.11709], [-116.63264, 33.11777], [-116.63951, 33.11478], [-116.63967, 33.11501], [-116.64538, 33.11233], [-116.64539, 33.11232], [-116.64534, 33.11224], [-116.64807, 33.11104], [-116.65016, 33.11031], [-116.65016, 33.10895], [-116.65283, 33.10895], [-116.65665, 33.10729], [-116.6568, 33.10743], [-116.65693, 33.10752], [-116.65708, 33.1076], [-116.65724, 33.10766], [-116.65756, 33.10773], [-116.65784, 33.10773], [-116.65788, 33.1078], [-116.65812, 33.10777], [-116.65812, 33.10769], [-116.65843, 33.10758], [-116.6587, 33.10742], [-116.65882, 33.10731], [-116.65895, 33.10714], [-116.65905, 33.10696], [-116.65909, 33.1068], [-116.65913, 33.10621], [-116.66452, 33.10387], [-116.66715, 33.10274], [-116.66726, 33.1029], [-116.66744, 33.10304], [-116.66752, 33.10314], [-116.66774, 33.10343], [-116.6679, 33.10373], [-116.66802, 33.10409], [-116.66808, 33.1044], [-116.66808, 33.10477], [-116.66803, 33.10504], [-116.66778, 33.10603], [-116.66776, 33.10634], [-116.66779, 33.10659], [-116.66782, 33.10675], [-116.6679, 33.10696], [-116.66874, 33.10895], [-116.66871, 33.10899], [-116.66882, 33.10921], [-116.66748, 33.10958], [-116.66806, 33.11096], [-116.6704, 33.11028], [-116.67082, 33.11127], [-116.67421, 33.1103], [-116.67598, 33.11473], [-116.67648, 33.11617], [-116.67686, 33.1175], [-116.67738, 33.12013], [-116.67869, 33.12778]]], [[[-116.65874, 33.10638], [-116.65872, 33.10671], [-116.65869, 33.10681], [-116.65863, 33.10695], [-116.65855, 33.10706], [-116.65843, 33.10719], [-116.65831, 33.10728], [-116.65819, 33.10736], [-116.65812, 33.10733], [-116.65786, 33.10737], [-116.65781, 33.10743], [-116.65751, 33.10742], [-116.65733, 33.10737], [-116.65713, 33.1073], [-116.65696, 33.10715], [-116.65874, 33.10638]]], [[[-116.72151, 33.13325], [-116.71595, 33.13859], [-116.70914, 33.13903], [-116.70195, 33.13862], [-116.69711, 33.13219], [-116.69318, 33.12693], [-116.69264, 33.12424], [-116.68438, 33.12422], [-116.6784, 33.12414], [-116.67819, 33.12293], [-116.68439, 33.12295], [-116.70166, 33.12273], [-116.70167, 33.12271], [-116.7084, 33.12261], [-116.70589, 33.11347], [-116.70159, 33.10945], [-116.69487, 33.10266], [-116.69544, 33.10219], [-116.69685, 33.10083], [-116.69907, 33.09843], [-116.69941, 33.09801], [-116.69975, 33.09756], [-116.70055, 33.0964], [-116.70072, 33.09608], [-116.70092, 33.09561], [-116.7011, 33.09529], [-116.7021, 33.09356], [-116.70233, 33.09324], [-116.70258, 33.09301], [-116.70399, 33.09204], [-116.70418, 33.09185], [-116.70443, 33.09149], [-116.70462, 33.09129], [-116.70478, 33.09116], [-116.70551, 33.09069], [-116.70566, 33.09057], [-116.7058, 33.09043], [-116.70592, 33.09025], [-116.70598, 33.09009], [-116.70626, 33.08876], [-116.70719, 33.08867], [-116.70708, 33.10671], [-116.70849, 33.10944], [-116.71004, 33.11173], [-116.71661, 33.12406], [-116.71794, 33.12675], [-116.71988, 33.13024], [-116.72151, 33.13325]]]]} | Open Access 1 | 11729 | Santa Ysabel Preserve | 29255 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/SantaYsabel.html | San Diego 4 | 5407.378 | Santa Ysabel Preserve | 0 | Local Conservation Area 4 | 2 |
1584 | 1584 | 1583 | {"type": "Polygon", "coordinates": [[[-117.09349, 33.56898], [-117.0926, 33.57066], [-117.08388, 33.57076], [-117.08394, 33.56909], [-117.09349, 33.56898]]]} | Unknown Access 4 | 12140 | French Valley Conservation Area, Expansion 1 | 19108 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | Riverside 10 | 38.849 | French Valley Conservation Area, Expansion 1 | None 128 | |||
1614 | 1614 | 1613 | {"type": "Polygon", "coordinates": [[[-118.65024, 34.1181], [-118.65024, 34.11939], [-118.6502, 34.12172], [-118.64565, 34.1217], [-118.64568, 34.1181], [-118.65024, 34.1181]]]} | Open Access 1 | 12332 | Secret Valley | 32667 | 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 | 41.753 | Secret Valley | None 129 | |||
1618 | 1618 | 1617 | {"type": "Polygon", "coordinates": [[[-119.74281, 34.40401], [-119.74274, 34.40423], [-119.74231, 34.40436], [-119.7421, 34.40437], [-119.74078, 34.40476], [-119.7407, 34.40454], [-119.74281, 34.40401]]]} | Open Access 1 | 13836 | Douglas Family Reserve | 18242 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 1.079 | Douglas Family Reserve | 0 | Local Conservation Area 4 | 2 | |
1632 | 1632 | 1631 | {"type": "Polygon", "coordinates": [[[-118.00413, 33.90582], [-118.00266, 33.9058], [-118.00229, 33.90591], [-118.0005, 33.9071], [-118.00033, 33.90729], [-118.00022, 33.90737], [-118.00018, 33.90743], [-117.99885, 33.90986], [-117.99444, 33.90988], [-117.99438, 33.90984], [-117.99434, 33.90424], [-117.99435, 33.90374], [-117.99441, 33.90318], [-117.99449, 33.90284], [-117.99455, 33.9028], [-118.00302, 33.90275], [-118.00303, 33.9028], [-118.00324, 33.90281], [-118.00329, 33.90286], [-118.0033, 33.90333], [-118.00333, 33.90358], [-118.00337, 33.90378], [-118.00343, 33.90396], [-118.00405, 33.90551], [-118.00413, 33.90582]]]} | Restricted Access 2 | 45404 | La Mirada Golf Course | 33111 | 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/La_Mirada_Golf_Course | Los Angeles 6 | 131.179 | La Mirada GC | 0 | Local Recreation Area 3 | 4 |
1638 | 1638 | 1637 | {"type": "Polygon", "coordinates": [[[-119.43775, 35.1571], [-119.43547, 35.15711], [-119.43547, 35.15585], [-119.43514, 35.15584], [-119.43497, 35.15576], [-119.43496, 35.15468], [-119.43774, 35.15467], [-119.43775, 35.1571]]]} | Open Access 1 | 14097 | Westside Cemetery | 27421 | 303 | Kern, County of 399 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 303 | Kern, County of 393 | County 3 | County Agency 3 | Kern 36 | 15.293 | Westside Cemetery | 0 | Local Historic or Cultural Area 19 | 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 |
1679 | 1679 | 1678 | {"type": "MultiPolygon", "coordinates": [[[[-117.57742, 33.57921], [-117.57561, 33.57949], [-117.57332, 33.57971], [-117.57325, 33.57941], [-117.57382, 33.57877], [-117.57489, 33.57871], [-117.57538, 33.57838], [-117.57593, 33.57835], [-117.57582, 33.5771], [-117.57531, 33.57698], [-117.57473, 33.57743], [-117.57379, 33.57678], [-117.57406, 33.57628], [-117.5748, 33.57579], [-117.57463, 33.57532], [-117.57601, 33.57545], [-117.57592, 33.57578], [-117.5767, 33.57653], [-117.57654, 33.57722], [-117.5764, 33.57755], [-117.57709, 33.57839], [-117.57742, 33.57921]]], [[[-117.57626, 33.58288], [-117.576, 33.58322], [-117.57597, 33.58321], [-117.57592, 33.58301], [-117.57554, 33.58262], [-117.57587, 33.58227], [-117.57626, 33.58288]]], [[[-117.54963, 33.53427], [-117.54945, 33.53509], [-117.54939, 33.53572], [-117.54932, 33.53712], [-117.54923, 33.53784], [-117.54911, 33.53846], [-117.54865, 33.53991], [-117.54855, 33.5405], [-117.54854, 33.54072], [-117.54857, 33.54116], [-117.5486, 33.54138], [-117.54867, 33.54167], [-117.54932, 33.54348], [-117.54939, 33.54372], [-117.54945, 33.54414], [-117.54945, 33.54432], [-117.5494, 33.54473], [-117.54881, 33.54693], [-117.54877, 33.54718], [-117.54873, 33.54761], [-117.54873, 33.54812], [-117.54917, 33.55504], [-117.54917, 33.55533], [-117.54913, 33.5559], [-117.54909, 33.55618], [-117.54898, 33.55675], [-117.54871, 33.55748], [-117.54514, 33.56607], [-117.54465, 33.56716], [-117.5439, 33.56867], [-117.54153, 33.57309], [-117.54144, 33.57307], [-117.54096, 33.57396], [-117.54084, 33.57415], [-117.5407, 33.57434], [-117.54045, 33.57459], [-117.53853, 33.57604], [-117.53813, 33.57638], [-117.53734, 33.57711], [-117.53683, 33.57748], [-117.53628, 33.57781], [-117.5357, 33.57809], [-117.52458, 33.58275], [-117.52417, 33.58296], [-117.52391, 33.58312], [-117.52336, 33.58353], [-117.52251, 33.58405], [-117.52232, 33.58421], [-117.52217, 33.58438], [-117.52198, 33.58467], [-117.5219, 33.58488], [-117.52184, 33.58509], [-117.52176, 33.58577], [-117.52167, 33.58604], [-117.52151, 33.58628], [-117.52137, 33.58643], [-117.5212, 33.58656], [-117.52102, 33.58667], [-117.52082, 33.58675], [-117.51827, 33.58749], [-117.51776, 33.58769], [-117.51728, 33.58793], [-117.517, 33.58812], [-117.51652, 33.5885], [-117.51604, 33.58882], [-117.51514, 33.58917], [-117.51485, 33.58934], [-117.51459, 33.58954], [-117.51438, 33.58976], [-117.51421, 33.59002], [-117.51409, 33.59029], [-117.51406, 33.59043], [-117.51391, 33.59082], [-117.51377, 33.5911], [-117.51357, 33.59135], [-117.51332, 33.59156], [-117.51313, 33.59168], [-117.51292, 33.59178], [-117.512, 33.59214], [-117.51177, 33.59222], [-117.51154, 33.59227], [-117.5113, 33.59229], [-117.51093, 33.59227], [-117.5107, 33.57546], [-117.51188, 33.57529], [-117.51466, 33.57676], [-117.51633, 33.57462], [-117.51968, 33.57422], [-117.52178, 33.57328], [-117.52268, 33.5731], [-117.52258, 33.56366], [-117.51053, 33.56363], [-117.51046, 33.5588], [-117.51098, 33.55853], [-117.51115, 33.55847], [-117.51134, 33.55843], [-117.51163, 33.55844], [-117.51231, 33.55857], [-117.51257, 33.55859], [-117.51283, 33.55856], [-117.51345, 33.55843], [-117.51356, 33.55837], [-117.51367, 33.55829], [-117.51415, 33.55779], [-117.51436, 33.55764], [-117.51462, 33.55754], [-117.51542, 33.5574], [-117.51562, 33.55734], [-117.51581, 33.55726], [-117.51653, 33.55691], [-117.51661, 33.55683], [-117.51663, 33.55675], [-117.51662, 33.55668], [-117.51653, 33.55651], [-117.51654, 33.5564], [-117.5166, 33.55627], [-117.51669, 33.55618], [-117.51682, 33.55614], [-117.5174, 33.55604], [-117.51759, 33.55598], [-117.51777, 33.55589], [-117.51861, 33.55542], [-117.51871, 33.55538], [-117.51886, 33.55538], [-117.519, 33.55544], [-117.51908, 33.5555], [-117.51934, 33.55585], [-117.51943, 33.55602], [-117.51949, 33.5562], [-117.51964, 33.55704], [-117.51967, 33.55715], [-117.51977, 33.55731], [-117.52016, 33.55764], [-117.5203, 33.5577], [-117.52045, 33.55771], [-117.52222, 33.55753], [-117.52233, 33.55753], [-117.52244, 33.55755], [-117.52254, 33.5576], [-117.52262, 33.55766], [-117.52302, 33.55804], [-117.5231, 33.55807], [-117.52318, 33.55809], [-117.52327, 33.55807], [-117.52338, 33.55801], [-117.52378, 33.55748], [-117.52552, 33.55589], [-117.52563, 33.55581], [-117.52577, 33.55575], [-117.52599, 33.5557], [-117.527, 33.55572], [-117.52714, 33.55569], [-117.52732, 33.55561], [-117.52742, 33.55552], [-117.52749, 33.55542], [-117.52753, 33.5553], [-117.52754, 33.55519], [-117.52723, 33.55393], [-117.52723, 33.55381], [-117.52727, 33.55373], [-117.52738, 33.55364], [-117.52753, 33.5536], [-117.52763, 33.55361], [-117.52821, 33.55372], [-117.52837, 33.5537], [-117.52851, 33.55363], [-117.52858, 33.55356], [-117.52943, 33.55233], [-117.53014, 33.5516], [-117.53047, 33.55106], [-117.53058, 33.55092], [-117.53071, 33.55078], [-117.53154, 33.55006], [-117.53167, 33.54996], [-117.53182, 33.54989], [-117.5324, 33.54973], [-117.53261, 33.54964], [-117.53279, 33.54951], [-117.53333, 33.54899], [-117.53345, 33.54889], [-117.53365, 33.54879], [-117.53422, 33.5486], [-117.53439, 33.54849], [-117.53451, 33.54834], [-117.53456, 33.54823], [-117.53493, 33.54671], [-117.53502, 33.54648], [-117.53517, 33.54627], [-117.53582, 33.54556], [-117.53632, 33.5448], [-117.53638, 33.54475], [-117.53646, 33.54472], [-117.53654, 33.54471], [-117.53662, 33.54473], [-117.53672, 33.54479], [-117.53691, 33.54503], [-117.53703, 33.54511], [-117.53713, 33.54514], [-117.53723, 33.54515], [-117.53743, 33.54511], [-117.53761, 33.54503], [-117.53778, 33.54493], [-117.53865, 33.54417], [-117.53884, 33.54403], [-117.53905, 33.5439], [-117.53939, 33.54375], [-117.53939, 33.54264], [-117.54134, 33.54099], [-117.54132, 33.53592], [-117.54679, 33.53592], [-117.54811, 33.53482], [-117.54941, 33.53482], [-117.54945, 33.53456], [-117.54954, 33.53426], [-117.54963, 33.53427]], [[-117.545, 33.5661], [-117.5484, 33.55799], [-117.54839, 33.55798], [-117.54739, 33.55781], [-117.54574, 33.55803], [-117.54214, 33.56031], [-117.53959, 33.56115], [-117.54023, 33.56233], [-117.54104, 33.56494], [-117.545, 33.5661]]], [[[-117.57838, 33.59334], [-117.57841, 33.59346], [-117.57837, 33.59397], [-117.57713, 33.59705], [-117.57739, 33.59833], [-117.57624, 33.59997], [-117.57609, 33.60104], [-117.57591, 33.60107], [-117.57617, 33.59907], [-117.57567, 33.59836], [-117.57414, 33.59725], [-117.57251, 33.5964], [-117.57216, 33.59471], [-117.57199, 33.59445], [-117.572, 33.59394], [-117.57217, 33.59393], [-117.57276, 33.59369], [-117.57326, 33.59309], [-117.5737, 33.59287], [-117.57515, 33.59261], [-117.57721, 33.59242], [-117.57838, 33.59334]]], [[[-117.5799, 33.5629], [-117.57908, 33.56334], [-117.57827, 33.56447], [-117.57728, 33.56458], [-117.57711, 33.5652], [-117.5772, 33.56608], [-117.57592, 33.56602], [-117.57554, 33.56643], [-117.57584, 33.56733], [-117.57642, 33.56891], [-117.577, 33.56899], [-117.57707, 33.56906], [-117.57651, 33.56946], [-117.57671, 33.57193], [-117.57693, 33.57214], [-117.57656, 33.5724], [-117.57608, 33.57497], [-117.57412, 33.57525], [-117.57376, 33.57601], [-117.57329, 33.57639], [-117.57308, 33.57707], [-117.57347, 33.57832], [-117.57271, 33.57977], [-117.57278, 33.57994], [-117.55622, 33.57993], [-117.55621, 33.58601], [-117.55576, 33.58631], [-117.55217, 33.59004], [-117.54867, 33.59127], [-117.54667, 33.59328], [-117.54437, 33.59229], [-117.54257, 33.59324], [-117.53879, 33.59767], [-117.53662, 33.5993], [-117.53515, 33.59994], [-117.52985, 33.60587], [-117.52809, 33.60735], [-117.51098, 33.5958], [-117.51093, 33.59244], [-117.5112, 33.59246], [-117.51146, 33.59244], [-117.51184, 33.59237], [-117.51209, 33.59229], [-117.513, 33.59193], [-117.51323, 33.59182], [-117.51345, 33.59169], [-117.51373, 33.59145], [-117.51395, 33.59118], [-117.51405, 33.59097], [-117.51423, 33.59047], [-117.5143, 33.59035], [-117.51444, 33.59012], [-117.51461, 33.5899], [-117.5148, 33.5897], [-117.51503, 33.58953], [-117.51529, 33.58939], [-117.51588, 33.58916], [-117.51645, 33.58885], [-117.5168, 33.58856], [-117.51696, 33.58837], [-117.51711, 33.58823], [-117.51736, 33.58806], [-117.51739, 33.58807], [-117.51792, 33.58781], [-117.51849, 33.58759], [-117.52088, 33.5869], [-117.5211, 33.58682], [-117.52139, 33.58664], [-117.52156, 33.5865], [-117.5217, 33.58634], [-117.52186, 33.58608], [-117.52196, 33.58579], [-117.52202, 33.58521], [-117.52206, 33.58501], [-117.52218, 33.58471], [-117.52236, 33.58444], [-117.52251, 33.58428], [-117.52269, 33.58414], [-117.52348, 33.58366], [-117.52404, 33.58325], [-117.52428, 33.58309], [-117.52467, 33.5829], [-117.53578, 33.57824], [-117.53639, 33.57795], [-117.53696, 33.57761], [-117.53731, 33.57736], [-117.53764, 33.57709], [-117.53828, 33.57649], [-117.53867, 33.57616], [-117.54058, 33.5747], [-117.54086, 33.57444], [-117.54108, 33.57414], [-117.54422, 33.56829], [-117.54482, 33.56706], [-117.54518, 33.56622], [-117.54882, 33.55748], [-117.54904, 33.55689], [-117.54914, 33.55648], [-117.54922, 33.55607], [-117.54927, 33.55566], [-117.54928, 33.55503], [-117.54885, 33.54809], [-117.54884, 33.54772], [-117.54886, 33.54734], [-117.54892, 33.54697], [-117.549, 33.5466], [-117.54951, 33.54472], [-117.54955, 33.54446], [-117.54956, 33.54419], [-117.54952, 33.54379], [-117.54946, 33.54353], [-117.54887, 33.5419], [-117.54877, 33.54158], [-117.54868, 33.54109], [-117.54866, 33.5406], [-117.54869, 33.54027], [-117.54875, 33.53994], [-117.5492, 33.53851], [-117.54935, 33.53781], [-117.54943, 33.5371], [-117.54953, 33.53547], [-117.54962, 33.5348], [-117.54972, 33.53436], [-117.54985, 33.53392], [-117.55001, 33.53349], [-117.5502, 33.53306], [-117.55915, 33.53495], [-117.56032, 33.53933], [-117.56514, 33.53929], [-117.56609, 33.53991], [-117.56695, 33.54249], [-117.57221, 33.54555], [-117.57298, 33.5477], [-117.57313, 33.54894], [-117.57266, 33.55006], [-117.57215, 33.55059], [-117.57262, 33.55161], [-117.57288, 33.5518], [-117.57338, 33.55335], [-117.57324, 33.55377], [-117.57441, 33.55471], [-117.57478, 33.55529], [-117.57428, 33.55587], [-117.57458, 33.55715], [-117.57459, 33.55757], [-117.57483, 33.55787], [-117.57453, 33.55875], [-117.5745, 33.56228], [-117.57857, 33.56147], [-117.57869, 33.56135], [-117.579, 33.56155], [-117.57889, 33.56175], [-117.57936, 33.56206], [-117.5799, 33.5629]]], [[[-117.57356, 33.60917], [-117.57201, 33.61029], [-117.5701, 33.61215], [-117.56922, 33.61724], [-117.56718, 33.61656], [-117.56594, 33.6181], [-117.56567, 33.61583], [-117.5663, 33.61267], [-117.57356, 33.60917]]], [[[-117.56756, 33.65211], [-117.56636, 33.65376], [-117.5656, 33.65528], [-117.56507, 33.65538], [-117.56476, 33.6555], [-117.56354, 33.65609], [-117.56334, 33.65621], [-117.56315, 33.65635], [-117.56294, 33.65652], [-117.5625, 33.6568], [-117.56198, 33.65693], [-117.56187, 33.65626], [-117.56163, 33.65621], [-117.56123, 33.65596], [-117.56081, 33.65557], [-117.56034, 33.65539], [-117.55986, 33.65545], [-117.55902, 33.6563], [-117.55884, 33.65622], [-117.55867, 33.65612], [-117.55814, 33.65567], [-117.55791, 33.65516], [-117.55808, 33.65463], [-117.55847, 33.65501], [-117.55948, 33.65495], [-117.5602, 33.65496], [-117.5607, 33.65504], [-117.56178, 33.65506], [-117.56294, 33.65494], [-117.56449, 33.65439], [-117.56531, 33.65372], [-117.56641, 33.6527], [-117.56626, 33.65176], [-117.56651, 33.65176], [-117.56691, 33.65181], [-117.56728, 33.65195], [-117.56756, 33.65211]]], [[[-117.56904, 33.65028], [-117.56868, 33.65083], [-117.56861, 33.65106], [-117.56871, 33.65322], [-117.56861, 33.65306], [-117.56843, 33.65313], [-117.56817, 33.65257], [-117.56802, 33.65233], [-117.56781, 33.65211], [-117.56753, 33.65191], [-117.56781, 33.65156], [-117.56762, 33.65146], [-117.56737, 33.65183], [-117.56715, 33.65173], [-117.56731, 33.65139], [-117.5672, 33.65123], [-117.56575, 33.65123], [-117.56568, 33.65098], [-117.56436, 33.64967], [-117.56275, 33.64993], [-117.56005, 33.65016], [-117.55734, 33.6497], [-117.55688, 33.65136], [-117.55656, 33.65176], [-117.55439, 33.6521], [-117.55387, 33.65282], [-117.55418, 33.65402], [-117.55569, 33.65522], [-117.55569, 33.65615], [-117.55836, 33.65609], [-117.55855, 33.65624], [-117.55875, 33.65636], [-117.55914, 33.65652], [-117.55916, 33.65655], [-117.55916, 33.65667], [-117.55919, 33.65677], [-117.55953, 33.65728], [-117.55959, 33.65754], [-117.55965, 33.6576], [-117.55975, 33.65763], [-117.55975, 33.658], [-117.55963, 33.65808], [-117.5596, 33.65898], [-117.55983, 33.659], [-117.55978, 33.66044], [-117.5593, 33.66102], [-117.55986, 33.66152], [-117.55964, 33.66253], [-117.56024, 33.66334], [-117.5595, 33.66421], [-117.55951, 33.66423], [-117.5598, 33.66436], [-117.55965, 33.66464], [-117.55624, 33.66465], [-117.55621, 33.65854], [-117.55526, 33.65853], [-117.55526, 33.65674], [-117.5558, 33.65674], [-117.55581, 33.65663], [-117.55552, 33.65636], [-117.55552, 33.65616], [-117.55496, 33.65564], [-117.55411, 33.65619], [-117.55441, 33.65674], [-117.55203, 33.65675], [-117.5521, 33.65136], [-117.55625, 33.65135], [-117.55626, 33.64329], [-117.55624, 33.64329], [-117.55619, 33.64419], [-117.5555, 33.64417], [-117.55511, 33.64261], [-117.55686, 33.63893], [-117.55928, 33.63476], [-117.55887, 33.63202], [-117.56019, 33.62748], [-117.56581, 33.61827], [-117.56571, 33.61882], [-117.56636, 33.61999], [-117.56677, 33.62042], [-117.56726, 33.62064], [-117.56739, 33.62109], [-117.56687, 33.62112], [-117.56641, 33.62077], [-117.56592, 33.62024], [-117.56591, 33.62007], [-117.56554, 33.61973], [-117.56506, 33.61979], [-117.56497, 33.62036], [-117.56468, 33.62044], [-117.56449, 33.62072], [-117.56453, 33.62098], [-117.56447, 33.62138], [-117.56529, 33.6217], [-117.56508, 33.62246], [-117.56621, 33.62368], [-117.56507, 33.62498], [-117.56499, 33.62498], [-117.56432, 33.62417], [-117.56305, 33.62418], [-117.56305, 33.62597], [-117.56343, 33.62634], [-117.56336, 33.62694], [-117.56289, 33.62717], [-117.56232, 33.62835], [-117.56264, 33.62869], [-117.56224, 33.62912], [-117.56226, 33.63064], [-117.56131, 33.63163], [-117.56161, 33.63199], [-117.5607, 33.63304], [-117.56084, 33.63429], [-117.56054, 33.63584], [-117.5591, 33.63621], [-117.55911, 33.63658], [-117.55902, 33.63665], [-117.55913, 33.63681], [-117.55921, 33.63812], [-117.56017, 33.63916], [-117.5602, 33.63991], [-117.56034, 33.64037], [-117.56046, 33.64062], [-117.5605, 33.64108], [-117.56029, 33.64109], [-117.56031, 33.64149], [-117.56052, 33.64149], [-117.56054, 33.64177], [-117.56158, 33.64177], [-117.56157, 33.64111], [-117.56085, 33.6411], [-117.56079, 33.64061], [-117.56106, 33.64054], [-117.56155, 33.64029], [-117.5617, 33.64051], [-117.56168, 33.64175], [-117.56193, 33.64292], [-117.56704, 33.64291], [-117.56705, 33.64652], [-117.56762, 33.64653], [-117.56763, 33.64869], [-117.56814, 33.6491], [-117.56822, 33.64918], [-117.56829, 33.64933], [-117.56829, 33.64952], [-117.56836, 33.64962], [-117.56879, 33.64979], [-117.56893, 33.6498], [-117.56904, 33.65028]], [[-117.56375, 33.64565], [-117.56304, 33.64522], [-117.56256, 33.6448], [-117.56242, 33.64475], [-117.56224, 33.6447], [-117.56213, 33.64471], [-117.56203, 33.64474], [-117.56147, 33.6451], [-117.56133, 33.64523], [-117.56122, 33.64542], [-117.56197, 33.64608], [-117.56275, 33.64546], [-117.56305, 33.64572], [-117.56247, 33.6462], [-117.5633, 33.64649], [-117.56373, 33.64653], [-117.56426, 33.64581], [-117.56418, 33.64571], [-117.56407, 33.64565], [-117.56398, 33.64563], [-117.56375, 33.64565]], [[-117.56327, 33.64361], [-117.56287, 33.64393], [-117.56327, 33.64428], [-117.56356, 33.64427], [-117.56362, 33.64381], [-117.56327, 33.64361]]]]} | Open Access 1 | 14562 | Ronald W. Caspers Wilderness Park | 29179 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/parks/ronald/ | Orange 3 | 7952.292 | Ronald W. Caspers Wilderness Park | 0 | Local Conservation Area 4 | 2 |
1686 | 1686 | 1685 | {"type": "Polygon", "coordinates": [[[-118.13552, 34.20063], [-118.13446, 34.2021], [-118.13438, 34.20208], [-118.13098, 34.20099], [-118.13105, 34.19921], [-118.13348, 34.19998], [-118.13298, 34.20069], [-118.13454, 34.20119], [-118.13505, 34.20048], [-118.13552, 34.20063]]]} | Open Access 1 | 6967 | Farnsworth Park | 18847 | 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 | 14.773 | Farnsworth 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]);