units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
220 rows where ACCESS_TYP = 2 and DES_TP = 3 sorted by LABEL_NAME
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_TYP, LAYER, MNG_AG_LEV
MNG_AGENCY >30
- Los Angeles, City of 10
- Los Angeles, County of 9
- Santa Cruz, City of 7
- Los Angeles - Department of Parks and Recreation, County of 7
- San Diego, City of 5
- San Jose, City of 5
- Long Beach, City of 5
- Santa Ana, City of 4
- San Bernardino, City of 4
- San Luis Obispo, City of 3
- Carlsbad, City of 3
- Pomona, City of 3
- Needles, City of 3
- Torrance, City of 3
- El Segundo, City of 3
- Stockton, City of 3
- Modesto, City of 3
- Roseville, City of 3
- Sacramento, County of 3
- San Gabriel, City of 3
- San Luis Obispo, County of 2
- San Francisco, City and County of 2
- Santa Barbara, City of 2
- Rancho Simi Recreation and Park District 2
- Glendale, City of 2
- Coronado, City of 2
- Ventura, City of 2
- Burbank, City of 2
- Orange, County of 2
- Riverside, City of 2
- …
MNG_AG_TYP 11
DES_TP 1
- Local Recreation Area · 220 ✖
ACCESS_TYP 1
- Restricted Access · 220 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16245 | 16245 | 16244 | {"type": "Polygon", "coordinates": [[[-118.32437, 33.83122], [-118.32371, 33.83123], [-118.32371, 33.83073], [-118.32329, 33.83036], [-118.32348, 33.83021], [-118.32436, 33.83102], [-118.32437, 33.83122]]]} | Restricted Access 2 | 35907 | ATTIC Teen Center | 32631 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | https://www.torranceca.gov/our-city/recreation/attic | Los Angeles 6 | 1.086 | ATTIC Teen Ctr. | 0 | Local Recreation Area 3 | 4 |
15707 | 15707 | 15706 | {"type": "Polygon", "coordinates": [[[-119.71112, 36.77661], [-119.71034, 36.77693], [-119.71087, 36.77789], [-119.7109, 36.77817], [-119.71106, 36.77893], [-119.71107, 36.77916], [-119.71098, 36.77922], [-119.71095, 36.7793], [-119.70509, 36.77924], [-119.70404, 36.77885], [-119.70354, 36.77875], [-119.70312, 36.77872], [-119.70259, 36.77873], [-119.70203, 36.77891], [-119.70122, 36.77919], [-119.70095, 36.77921], [-119.7011, 36.77741], [-119.70133, 36.77645], [-119.70172, 36.77585], [-119.7019, 36.7757], [-119.70334, 36.77575], [-119.70395, 36.77575], [-119.70417, 36.77573], [-119.7044, 36.77567], [-119.7046, 36.77557], [-119.70476, 36.77545], [-119.70509, 36.77507], [-119.70515, 36.77506], [-119.70642, 36.77578], [-119.70767, 36.77435], [-119.70773, 36.77432], [-119.7078, 36.77432], [-119.70787, 36.77434], [-119.70931, 36.77518], [-119.71086, 36.77614], [-119.71112, 36.77661]]]} | Restricted Access 2 | 25456 | Airways Municipal Golf Course | 33086 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 88.161 | Airways Municipal GC | 0 | Local Recreation Area 3 | 4 | |
8257 | 8257 | 8256 | {"type": "Polygon", "coordinates": [[[-118.11967, 34.09049], [-118.11966, 34.09074], [-118.11234, 34.09388], [-118.10973, 34.0882], [-118.10992, 34.08814], [-118.10934, 34.08688], [-118.1091, 34.08626], [-118.10941, 34.08615], [-118.10899, 34.08523], [-118.10881, 34.08475], [-118.11269, 34.08456], [-118.11268, 34.08483], [-118.11269, 34.0859], [-118.11273, 34.08679], [-118.11276, 34.08697], [-118.11298, 34.08739], [-118.1137, 34.08774], [-118.11393, 34.08771], [-118.11418, 34.08766], [-118.11449, 34.08765], [-118.11449, 34.08813], [-118.11461, 34.08814], [-118.11486, 34.08831], [-118.11491, 34.08836], [-118.11491, 34.08858], [-118.11575, 34.08939], [-118.11563, 34.08939], [-118.11563, 34.0896], [-118.11567, 34.08964], [-118.1157, 34.08965], [-118.11577, 34.08965], [-118.11578, 34.08941], [-118.11591, 34.08929], [-118.11685, 34.08929], [-118.11686, 34.09051], [-118.11967, 34.09049]]]} | Restricted Access 2 | 45406 | Alhambra Municipal Golf Course | 33112 | 1003 | Alhambra, City of 158 | City 2 | City Agency 2 | http://www.cityofalhambra.org/page/20/parks_rec_department/ | City 2 | 1003 | Alhambra, City of 154 | City 2 | City Agency 2 | http://alhambragolf.com/ag/ | Los Angeles 6 | 107.021 | Alhambra Municipal GC | 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 | |
14384 | 14384 | 14383 | {"type": "Polygon", "coordinates": [[[-118.96126, 34.18591], [-118.96086, 34.18776], [-118.96044, 34.1877], [-118.96044, 34.18733], [-118.96018, 34.1869], [-118.95949, 34.18737], [-118.95917, 34.18749], [-118.95899, 34.18751], [-118.95881, 34.18751], [-118.95863, 34.18749], [-118.9584, 34.18742], [-118.95807, 34.18736], [-118.95816, 34.18723], [-118.9582, 34.18686], [-118.95811, 34.18649], [-118.95798, 34.18627], [-118.95764, 34.18647], [-118.95748, 34.18629], [-118.95768, 34.18611], [-118.95782, 34.18623], [-118.9585, 34.18623], [-118.95851, 34.18593], [-118.96126, 34.18591]]]} | Restricted Access 2 | 47116 | Alta Vista Open Space | 30792 | 2024 | Conejo Open Space Conservation Agency 504 | Special District 4 | Open Space District 6 | http://www.conejo-openspace.org/ | Special District 4 | 2024 | Conejo Open Space Conservation Agency 496 | Special District 4 | Open Space District 6 | http://www.conejo-openspace.org/open_space_areas_in_TO.htm#Alta Vista | Ventura 8 | 10.982 | Alta Vista OS | 0 | Local Recreation Area 3 | 4 |
1070 | 1070 | 1069 | {"type": "Polygon", "coordinates": [[[-118.12169, 34.18412], [-118.12169, 34.18484], [-118.12109, 34.18492], [-118.12098, 34.18506], [-118.12057, 34.18506], [-118.12058, 34.18579], [-118.11862, 34.1858], [-118.11862, 34.18574], [-118.11762, 34.1841], [-118.11755, 34.18393], [-118.1175, 34.18371], [-118.11747, 34.18334], [-118.11742, 34.18334], [-118.11734, 34.18092], [-118.11782, 34.18092], [-118.11781, 34.18075], [-118.11767, 34.18048], [-118.11767, 34.18009], [-118.11806, 34.18009], [-118.1181, 34.1796], [-118.12141, 34.17957], [-118.12144, 34.18233], [-118.12147, 34.18248], [-118.12158, 34.18276], [-118.12162, 34.18294], [-118.12162, 34.18319], [-118.12154, 34.18358], [-118.12153, 34.18373], [-118.12155, 34.18386], [-118.12159, 34.18403], [-118.12162, 34.18407], [-118.12169, 34.18412]]]} | Restricted Access 2 | 6971 | Altadena Golf Course | 33022 | 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 | 57.739 | Altadena GC | 0 | Local Recreation Area 3 | 4 | |
15700 | 15700 | 15699 | {"type": "MultiPolygon", "coordinates": [[[[-121.39794, 38.718], [-121.39794, 38.71803], [-121.39732, 38.718], [-121.39658, 38.71802], [-121.39577, 38.71793], [-121.39554, 38.71792], [-121.39551, 38.71787], [-121.39552, 38.71785], [-121.39555, 38.71784], [-121.39583, 38.71783], [-121.39606, 38.71779], [-121.39641, 38.71779], [-121.39656, 38.7178], [-121.39671, 38.71785], [-121.39676, 38.7179], [-121.39686, 38.71795], [-121.39728, 38.71796], [-121.39737, 38.71794], [-121.39749, 38.71784], [-121.39758, 38.71779], [-121.3976, 38.71781], [-121.39758, 38.71783], [-121.39748, 38.71789], [-121.39744, 38.71795], [-121.39783, 38.71794], [-121.39783, 38.71791], [-121.39779, 38.71786], [-121.39778, 38.71783], [-121.39781, 38.71782], [-121.39785, 38.71784], [-121.39789, 38.71788], [-121.39794, 38.718]]], [[[-121.39618, 38.71991], [-121.39616, 38.72016], [-121.39605, 38.72016], [-121.39597, 38.72018], [-121.39591, 38.72022], [-121.39584, 38.72035], [-121.3958, 38.72036], [-121.39565, 38.72036], [-121.39555, 38.7204], [-121.39556, 38.72018], [-121.39566, 38.72015], [-121.39571, 38.72], [-121.39583, 38.71988], [-121.39595, 38.71984], [-121.39608, 38.71986], [-121.39618, 38.71991]]], [[[-121.39818, 38.72268], [-121.39814, 38.72274], [-121.39806, 38.72275], [-121.39799, 38.72272], [-121.39741, 38.72221], [-121.39721, 38.72206], [-121.39692, 38.72206], [-121.39681, 38.72208], [-121.39667, 38.72208], [-121.39636, 38.72209], [-121.3963, 38.72213], [-121.39624, 38.72223], [-121.39618, 38.72225], [-121.39614, 38.72225], [-121.39614, 38.72214], [-121.39627, 38.72204], [-121.39642, 38.722], [-121.39678, 38.72199], [-121.397, 38.72193], [-121.39712, 38.72193], [-121.39716, 38.7219], [-121.39732, 38.72192], [-121.39736, 38.72188], [-121.39735, 38.7218], [-121.3974, 38.7218], [-121.39766, 38.72198], [-121.39765, 38.72205], [-121.39772, 38.72225], [-121.39781, 38.72236], [-121.39793, 38.72246], [-121.39806, 38.72253], [-121.39815, 38.72262], [-121.39818, 38.72268]]], [[[-121.39707, 38.71962], [-121.39706, 38.71979], [-121.39699, 38.71992], [-121.39686, 38.72003], [-121.3967, 38.7201], [-121.39652, 38.72011], [-121.39623, 38.7201], [-121.39627, 38.71989], [-121.39643, 38.71978], [-121.39654, 38.71961], [-121.39661, 38.71955], [-121.39665, 38.71954], [-121.39669, 38.71956], [-121.3967, 38.71969], [-121.39676, 38.71971], [-121.39683, 38.71966], [-121.39686, 38.71961], [-121.3969, 38.7196], [-121.39707, 38.71962]]], [[[-121.39714, 38.72282], [-121.39707, 38.72291], [-121.39709, 38.72297], [-121.39705, 38.72298], [-121.39697, 38.72297], [-121.39696, 38.72294], [-121.39698, 38.72291], [-121.39703, 38.72287], [-121.39705, 38.7228], [-121.39711, 38.72278], [-121.39714, 38.72282]]], [[[-121.39748, 38.71779], [-121.39746, 38.71783], [-121.39735, 38.71791], [-121.39728, 38.71789], [-121.39722, 38.7178], [-121.3973, 38.71778], [-121.39748, 38.71779]]], [[[-121.39777, 38.72167], [-121.39772, 38.72182], [-121.39774, 38.72194], [-121.39773, 38.72196], [-121.39751, 38.72182], [-121.39744, 38.72169], [-121.39747, 38.72165], [-121.39749, 38.72157], [-121.39747, 38.72152], [-121.39743, 38.72147], [-121.39759, 38.72147], [-121.39758, 38.72153], [-121.39763, 38.72157], [-121.39766, 38.72157], [-121.3977, 38.7215], [-121.39772, 38.72151], [-121.39777, 38.72167]]], [[[-121.39838, 38.7181], [-121.39828, 38.71814], [-121.39808, 38.71811], [-121.39802, 38.71806], [-121.39799, 38.71795], [-121.39803, 38.71791], [-121.3982, 38.71785], [-121.39827, 38.71781], [-121.39836, 38.71786], [-121.39833, 38.71791], [-121.39838, 38.7181]], [[-121.39827, 38.71793], [-121.39823, 38.71793], [-121.3981, 38.71799], [-121.39807, 38.71801], [-121.39808, 38.71804], [-121.39814, 38.71808], [-121.39829, 38.71808], [-121.3983, 38.71806], [-121.3983, 38.71802], [-121.39827, 38.71793]]], [[[-121.39856, 38.71876], [-121.39851, 38.71878], [-121.39844, 38.71876], [-121.39837, 38.71876], [-121.39836, 38.71877], [-121.39837, 38.71878], [-121.39847, 38.71879], [-121.39849, 38.7188], [-121.39849, 38.71882], [-121.39834, 38.71882], [-121.39826, 38.71884], [-121.39821, 38.71882], [-121.39814, 38.71876], [-121.39799, 38.71874], [-121.39799, 38.71871], [-121.39807, 38.71868], [-121.39808, 38.71864], [-121.39807, 38.71857], [-121.3981, 38.71854], [-121.39828, 38.71856], [-121.39835, 38.71854], [-121.39841, 38.71868], [-121.39856, 38.71873], [-121.39856, 38.71876]]], [[[-121.39831, 38.71842], [-121.3983, 38.71845], [-121.39827, 38.71847], [-121.39812, 38.71846], [-121.39806, 38.71841], [-121.39809, 38.71835], [-121.39812, 38.71833], [-121.39817, 38.71832], [-121.39825, 38.71834], [-121.39831, 38.71842]]], [[[-121.39929, 38.71634], [-121.3993, 38.7164], [-121.39929, 38.7165], [-121.39912, 38.71679], [-121.39902, 38.7169], [-121.39895, 38.71708], [-121.39891, 38.71713], [-121.39875, 38.71725], [-121.3987, 38.7173], [-121.39851, 38.71762], [-121.3985, 38.71769], [-121.39844, 38.71774], [-121.3984, 38.7178], [-121.39832, 38.71779], [-121.39832, 38.71776], [-121.3984, 38.7176], [-121.39865, 38.71724], [-121.39869, 38.71712], [-121.39881, 38.71706], [-121.39899, 38.71683], [-121.39904, 38.7168], [-121.39918, 38.71658], [-121.39922, 38.71649], [-121.39924, 38.71633], [-121.39929, 38.71634]]], [[[-121.39855, 38.71891], [-121.39854, 38.71895], [-121.39849, 38.71897], [-121.39844, 38.71895], [-121.39837, 38.71895], [-121.39834, 38.71892], [-121.39836, 38.71889], [-121.3985, 38.71887], [-121.39852, 38.71887], [-121.39855, 38.71891]]], [[[-121.399, 38.71916], [-121.39899, 38.7193], [-121.39893, 38.71943], [-121.39888, 38.71974], [-121.39877, 38.72018], [-121.39878, 38.72047], [-121.39876, 38.72053], [-121.39867, 38.72068], [-121.39863, 38.72089], [-121.39857, 38.72103], [-121.39855, 38.72112], [-121.3985, 38.72116], [-121.39845, 38.72114], [-121.39842, 38.72111], [-121.39842, 38.72097], [-121.39847, 38.72082], [-121.3985, 38.72065], [-121.39847, 38.7206], [-121.39853, 38.72028], [-121.39864, 38.71992], [-121.39871, 38.71981], [-121.3988, 38.71951], [-121.39879, 38.71916], [-121.39885, 38.71911], [-121.39894, 38.71911], [-121.399, 38.71916]]], [[[-121.40081, 38.71464], [-121.40058, 38.71479], [-121.40051, 38.71481], [-121.40037, 38.71487], [-121.40032, 38.71491], [-121.40027, 38.71504], [-121.4002, 38.71514], [-121.39991, 38.71531], [-121.3999, 38.71535], [-121.40001, 38.71548], [-121.39996, 38.71553], [-121.39964, 38.71561], [-121.39948, 38.71568], [-121.39943, 38.71572], [-121.39939, 38.71579], [-121.39938, 38.71583], [-121.39939, 38.71588], [-121.39952, 38.71594], [-121.39954, 38.71599], [-121.39951, 38.71607], [-121.39939, 38.71624], [-121.39933, 38.71628], [-121.39928, 38.71625], [-121.39927, 38.71623], [-121.39943, 38.71603], [-121.3994, 38.71598], [-121.39927, 38.71596], [-121.39924, 38.71594], [-121.39922, 38.7159], [-121.39923, 38.7158], [-121.39939, 38.71563], [-121.3995, 38.71556], [-121.39981, 38.7155], [-121.39985, 38.71546], [-121.39972, 38.71525], [-121.39962, 38.71525], [-121.39965, 38.71522], [-121.3997, 38.71521], [-121.39969, 38.71515], [-121.39971, 38.71513], [-121.39977, 38.71509], [-121.40009, 38.71507], [-121.40012, 38.71504], [-121.40018, 38.7149], [-121.40026, 38.71479], [-121.40037, 38.71472], [-121.40055, 38.71466], [-121.40071, 38.71457], [-121.4008, 38.71462], [-121.40081, 38.71464]]], [[[-121.40096, 38.71443], [-121.4009, 38.71456], [-121.40083, 38.71459], [-121.40079, 38.71456], [-121.40079, 38.71453], [-121.40085, 38.71449], [-121.40086, 38.71443], [-121.40096, 38.71443]]]]} | Restricted Access 2 | 21434 | Antelope Greens Golf Course | 28301 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 5.742 | Antelope Greens GC | 0 | Local Recreation Area 3 | 4 | |
15669 | 15669 | 15668 | {"type": "MultiPolygon", "coordinates": [[[[-118.02002, 34.10015], [-118.01922, 34.10279], [-118.01789, 34.10253], [-118.0166, 34.10528], [-118.01621, 34.10549], [-118.01575, 34.10339], [-118.01574, 34.10313], [-118.01578, 34.1029], [-118.0159, 34.10259], [-118.01597, 34.10246], [-118.01711, 34.10129], [-118.01857, 34.10015], [-118.01908, 34.09991], [-118.02002, 34.10015]]], [[[-118.01617, 34.10551], [-118.01607, 34.10557], [-118.01603, 34.10544], [-118.01577, 34.10423], [-118.01587, 34.10418], [-118.01617, 34.10551]]]]} | Restricted Access 2 | 7036 | Arcadia Par-3 Golf Course | 33024 | 1009 | Arcadia, City of 303 | City 2 | City Agency 2 | http://www.ci.arcadia.ca.us/home/index.asp?page=1160 | City 2 | 1009 | Arcadia, City of 299 | City 2 | City Agency 2 | Los Angeles 6 | 25.879 | Arcadia Par-3 GC | 0 | Local Recreation Area 3 | 4 | |
16119 | 16119 | 16118 | {"type": "MultiPolygon", "coordinates": [[[[-118.91157, 34.19061], [-118.91076, 34.19098], [-118.91079, 34.19125], [-118.911, 34.19126], [-118.90934, 34.19128], [-118.90916, 34.18971], [-118.90747, 34.18972], [-118.90516, 34.18937], [-118.90334, 34.18882], [-118.90226, 34.18875], [-118.90207, 34.18833], [-118.90224, 34.18766], [-118.90207, 34.1868], [-118.90146, 34.1862], [-118.90071, 34.18638], [-118.90034, 34.18671], [-118.89968, 34.18636], [-118.89939, 34.18597], [-118.8996, 34.18536], [-118.89983, 34.18592], [-118.90024, 34.18605], [-118.90052, 34.18607], [-118.90077, 34.18597], [-118.90168, 34.18602], [-118.90188, 34.1861], [-118.90246, 34.18627], [-118.90261, 34.1866], [-118.9027, 34.18712], [-118.90335, 34.18712], [-118.90335, 34.18611], [-118.90369, 34.18701], [-118.9037, 34.18779], [-118.904, 34.18822], [-118.90469, 34.18838], [-118.90498, 34.18818], [-118.90534, 34.18789], [-118.90668, 34.18786], [-118.90717, 34.18746], [-118.90691, 34.18584], [-118.90689, 34.18532], [-118.9073, 34.18556], [-118.90727, 34.18568], [-118.9075, 34.18631], [-118.90799, 34.18703], [-118.9081, 34.18785], [-118.90807, 34.18793], [-118.90808, 34.18799], [-118.90797, 34.18804], [-118.9079, 34.18827], [-118.90834, 34.18839], [-118.90859, 34.18831], [-118.90902, 34.18861], [-118.90954, 34.18851], [-118.90973, 34.18863], [-118.90982, 34.18875], [-118.90985, 34.18899], [-118.91008, 34.18913], [-118.91032, 34.18918], [-118.91061, 34.18937], [-118.9112, 34.18927], [-118.91131, 34.19008], [-118.9114, 34.19032], [-118.91157, 34.19061]]], [[[-118.91331, 34.19124], [-118.91268, 34.19124], [-118.91244, 34.19109], [-118.91221, 34.1909], [-118.91203, 34.1907], [-118.91188, 34.19049], [-118.91174, 34.1902], [-118.91164, 34.18986], [-118.9116, 34.1894], [-118.9115, 34.18847], [-118.9115, 34.18844], [-118.91153, 34.18841], [-118.91159, 34.18839], [-118.91201, 34.18843], [-118.91254, 34.18845], [-118.91253, 34.18868], [-118.91258, 34.18896], [-118.91248, 34.18913], [-118.91206, 34.18905], [-118.91205, 34.18906], [-118.91206, 34.18938], [-118.91213, 34.18948], [-118.91211, 34.18952], [-118.91212, 34.18957], [-118.91217, 34.18964], [-118.91226, 34.18966], [-118.91226, 34.19009], [-118.91221, 34.19009], [-118.9122, 34.1901], [-118.91229, 34.1904], [-118.91253, 34.19035], [-118.91262, 34.19028], [-118.91273, 34.19029], [-118.91279, 34.19069], [-118.91287, 34.19067], [-118.91331, 34.19124]]]]} | Restricted Access 2 | 15697 | Arroyo Conejo - South Arroyo Conejo Open Space | 15611 | 2024 | Conejo Open Space Conservation Agency 504 | Special District 4 | Open Space District 6 | http://www.conejo-openspace.org/ | Special District 4 | 2024 | Conejo Open Space Conservation Agency 496 | Special District 4 | Open Space District 6 | Ventura 8 | 51.646 | Arroyo Conejo - South Arroyo Conejo OS | 0 | Local Recreation Area 3 | 4 | |
7233 | 7233 | 7232 | {"type": "Polygon", "coordinates": [[[-118.17442, 34.11313], [-118.17382, 34.11314], [-118.17249, 34.1138], [-118.1717, 34.11481], [-118.17141, 34.1152], [-118.17123, 34.11541], [-118.17064, 34.11525], [-118.17023, 34.11568], [-118.1699, 34.11588], [-118.16957, 34.11604], [-118.1687, 34.11633], [-118.1684, 34.11659], [-118.16778, 34.11722], [-118.16752, 34.1172], [-118.16721, 34.11715], [-118.16702, 34.11722], [-118.16668, 34.1172], [-118.16617, 34.11698], [-118.16631, 34.1167], [-118.16644, 34.11652], [-118.16714, 34.1158], [-118.16736, 34.11565], [-118.16786, 34.11535], [-118.16903, 34.11436], [-118.17094, 34.11312], [-118.17138, 34.11306], [-118.1719, 34.11287], [-118.17256, 34.11271], [-118.17296, 34.1125], [-118.17362, 34.11232], [-118.17402, 34.11239], [-118.17442, 34.11313]]]} | Restricted Access 2 | 6930 | Arroyo Seco Golf Course | 29411 | 1340 | South Pasadena, City of 309 | City 2 | City Agency 2 | http://www.ci.south-pasadena.ca.us/ | City 2 | 1340 | South Pasadena, City of 306 | City 2 | City Agency 2 | http://www.arroyosecogolf.com/Home.html | Los Angeles 6 | 31.16 | Arroyo Seco GC | 0 | Local Recreation Area 3 | 4 |
15196 | 15196 | 15195 | {"type": "Polygon", "coordinates": [[[-118.17123, 34.11541], [-118.16918, 34.11752], [-118.16899, 34.11733], [-118.16859, 34.11755], [-118.16857, 34.11757], [-118.16862, 34.11762], [-118.16806, 34.11775], [-118.168, 34.11744], [-118.16778, 34.11722], [-118.1684, 34.11659], [-118.1687, 34.11633], [-118.16957, 34.11604], [-118.1699, 34.11588], [-118.17023, 34.11568], [-118.17064, 34.11524], [-118.17123, 34.11541]]]} | Restricted Access 2 | 46069 | Arroyo Seco Racquet Center | 29412 | 1340 | South Pasadena, City of 309 | City 2 | City Agency 2 | http://www.ci.south-pasadena.ca.us/ | City 2 | 1340 | South Pasadena, City of 306 | City 2 | City Agency 2 | http://www.ci.south-pasadena.ca.us/index.aspx?page=66 | Los Angeles 6 | 7.411 | Arroyo Seco Racquet Ctr. | 0 | Local Recreation Area 3 | 4 |
6254 | 6254 | 6253 | {"type": "MultiPolygon", "coordinates": [[[[-116.72083, 32.70426], [-116.71907, 32.7045], [-116.71873, 32.70456], [-116.7182, 32.70471], [-116.71793, 32.70482], [-116.71767, 32.70496], [-116.71735, 32.70515], [-116.71708, 32.70537], [-116.71398, 32.70808], [-116.71371, 32.70826], [-116.71349, 32.70839], [-116.71319, 32.70853], [-116.71283, 32.70866], [-116.70883, 32.70798], [-116.70426, 32.70803], [-116.70439, 32.71165], [-116.70677, 32.71163], [-116.70672, 32.71196], [-116.70667, 32.7121], [-116.70658, 32.71228], [-116.70649, 32.71241], [-116.70538, 32.71375], [-116.70517, 32.71411], [-116.70506, 32.71444], [-116.70502, 32.71464], [-116.705, 32.71489], [-116.70499, 32.71695], [-116.70495, 32.71993], [-116.7049, 32.72027], [-116.70478, 32.72064], [-116.70461, 32.72097], [-116.70444, 32.72123], [-116.70424, 32.72147], [-116.70405, 32.72166], [-116.69956, 32.72557], [-116.69966, 32.7224], [-116.69545, 32.72241], [-116.6953, 32.72599], [-116.6909, 32.726], [-116.69148, 32.71532], [-116.69577, 32.71527], [-116.69593, 32.71173], [-116.7001, 32.71169], [-116.69997, 32.7081], [-116.70112, 32.70807], [-116.70099, 32.7045], [-116.69554, 32.70453], [-116.69514, 32.69711], [-116.6819, 32.69715], [-116.68214, 32.70068], [-116.67793, 32.70075], [-116.67876, 32.71169], [-116.6786, 32.71546], [-116.68281, 32.71546], [-116.68266, 32.71901], [-116.68694, 32.71903], [-116.68659, 32.7261], [-116.67808, 32.72613], [-116.67826, 32.7226], [-116.66961, 32.72265], [-116.66984, 32.71904], [-116.67418, 32.71895], [-116.67435, 32.71542], [-116.6661, 32.71554], [-116.66639, 32.71171], [-116.66252, 32.71174], [-116.66225, 32.70812], [-116.66611, 32.70808], [-116.66584, 32.7045], [-116.66983, 32.70446], [-116.66933, 32.69723], [-116.66139, 32.69733], [-116.66126, 32.69371], [-116.65721, 32.69375], [-116.65703, 32.69021], [-116.65041, 32.68985], [-116.64504, 32.6896], [-116.64512, 32.68579], [-116.64145, 32.68553], [-116.62402, 32.686], [-116.62403, 32.68245], [-116.61982, 32.68242], [-116.61983, 32.67894], [-116.62406, 32.67895], [-116.62828, 32.67883], [-116.62843, 32.68226], [-116.64162, 32.6817], [-116.65303, 32.68272], [-116.65312, 32.68635], [-116.65685, 32.68666], [-116.66102, 32.68661], [-116.66116, 32.69017], [-116.66941, 32.69001], [-116.66943, 32.68647], [-116.66522, 32.68654], [-116.66518, 32.67936], [-116.66938, 32.67923], [-116.66936, 32.66864], [-116.67387, 32.66853], [-116.67418, 32.66477], [-116.67836, 32.6647], [-116.67912, 32.65372], [-116.68316, 32.65371], [-116.68281, 32.65012], [-116.69142, 32.65005], [-116.69107, 32.6537], [-116.68713, 32.65371], [-116.68691, 32.66092], [-116.68275, 32.66096], [-116.68232, 32.66832], [-116.67809, 32.66843], [-116.67805, 32.67191], [-116.67386, 32.67198], [-116.67382, 32.68271], [-116.68213, 32.68268], [-116.68206, 32.68638], [-116.68642, 32.68631], [-116.68641, 32.68978], [-116.69093, 32.68974], [-116.69093, 32.69145], [-116.69097, 32.69352], [-116.7085, 32.69348], [-116.70862, 32.69707], [-116.71266, 32.69772], [-116.71271, 32.7015], [-116.7208, 32.70275], [-116.72083, 32.70426]]], [[[-116.70877, 32.71161], [-116.70809, 32.72584], [-116.69953, 32.72595], [-116.69953, 32.72583], [-116.70419, 32.72176], [-116.70447, 32.72148], [-116.7047, 32.72118], [-116.70487, 32.72089], [-116.70501, 32.72058], [-116.70509, 32.7203], [-116.70515, 32.71995], [-116.70519, 32.71695], [-116.7052, 32.71484], [-116.70523, 32.71452], [-116.70534, 32.71421], [-116.70544, 32.714], [-116.70558, 32.71379], [-116.70662, 32.71254], [-116.70673, 32.71239], [-116.70683, 32.71221], [-116.7069, 32.71203], [-116.70695, 32.71184], [-116.70697, 32.71163], [-116.70877, 32.71161]]], [[[-116.71691, 32.70935], [-116.71691, 32.70935], [-116.71317, 32.70872], [-116.71348, 32.70858], [-116.71373, 32.70845], [-116.71395, 32.70831], [-116.71419, 32.70814], [-116.71683, 32.70582], [-116.71691, 32.70935]]], [[[-116.72086, 32.70635], [-116.72086, 32.70635], [-116.71693, 32.70573], [-116.71727, 32.70544], [-116.71758, 32.70521], [-116.71797, 32.705], [-116.71838, 32.70483], [-116.7187, 32.70474], [-116.719, 32.70467], [-116.72083, 32.70443], [-116.72086, 32.70635]]]]} | Restricted Access 2 | 1327 | Barrett Reservoir | 15833 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | https://www.sandiego.gov/water/recreation/reservoirs/barrett | San Diego 4 | 4177.221 | Barrett Reservoir | 0 | Local Recreation Area 3 | 4 |
9447 | 9447 | 9446 | {"type": "Polygon", "coordinates": [[[-121.82991, 36.63229], [-121.82592, 36.63574], [-121.82568, 36.63592], [-121.82546, 36.63603], [-121.82507, 36.63615], [-121.82474, 36.63618], [-121.81961, 36.63593], [-121.81935, 36.63593], [-121.81911, 36.63596], [-121.81872, 36.63606], [-121.81842, 36.6362], [-121.8183, 36.63628], [-121.81716, 36.63727], [-121.81692, 36.63709], [-121.81597, 36.63671], [-121.81592, 36.63661], [-121.81575, 36.63637], [-121.81533, 36.63587], [-121.81503, 36.63572], [-121.81455, 36.63544], [-121.81353, 36.63481], [-121.8128, 36.63419], [-121.81388, 36.63201], [-121.81361, 36.63084], [-121.81575, 36.62643], [-121.81895, 36.62681], [-121.82132, 36.62198], [-121.82148, 36.62204], [-121.82208, 36.62234], [-121.82269, 36.62251], [-121.82291, 36.6226], [-121.82351, 36.62312], [-121.82385, 36.6233], [-121.82411, 36.62337], [-121.82463, 36.62366], [-121.82508, 36.62391], [-121.82592, 36.62448], [-121.82574, 36.62606], [-121.82589, 36.62664], [-121.82609, 36.62719], [-121.82662, 36.62852], [-121.82696, 36.62899], [-121.82756, 36.62939], [-121.82804, 36.62959], [-121.82889, 36.62973], [-121.82916, 36.63084], [-121.82912, 36.6309], [-121.82991, 36.63229]]]} | Restricted Access 2 | 17283 | Bayonet Black Horse Golf Course | 33056 | 1330 | Seaside, City of 115 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | Monterey 14 | 373.525 | Bayonet Black Horse GC | 0 | Local Recreation Area 3 | 4 | |
10343 | 10343 | 10342 | {"type": "Polygon", "coordinates": [[[-122.66467, 38.42516], [-122.66241, 38.42639], [-122.66227, 38.4263], [-122.66226, 38.42719], [-122.65949, 38.42718], [-122.65908, 38.42721], [-122.65845, 38.42668], [-122.65832, 38.42654], [-122.65644, 38.4244], [-122.65601, 38.42344], [-122.65578, 38.42204], [-122.65565, 38.42202], [-122.65546, 38.42204], [-122.65549, 38.4217], [-122.65548, 38.42103], [-122.65551, 38.41987], [-122.65565, 38.41987], [-122.65588, 38.4191], [-122.65722, 38.41788], [-122.65756, 38.41741], [-122.6573, 38.4169], [-122.65799, 38.41691], [-122.6584, 38.41785], [-122.65968, 38.41786], [-122.65969, 38.41989], [-122.66115, 38.4199], [-122.66231, 38.41954], [-122.66239, 38.41954], [-122.66292, 38.41936], [-122.66368, 38.41889], [-122.66412, 38.4193], [-122.6643, 38.41953], [-122.66441, 38.4197], [-122.66452, 38.41991], [-122.66463, 38.42017], [-122.66468, 38.42039], [-122.66472, 38.42062], [-122.66473, 38.42089], [-122.66471, 38.42112], [-122.6646, 38.42152], [-122.66438, 38.42201], [-122.66428, 38.42228], [-122.66368, 38.42219], [-122.66363, 38.42242], [-122.6636, 38.42265], [-122.66358, 38.42288], [-122.6636, 38.42317], [-122.66364, 38.42345], [-122.66372, 38.42373], [-122.66392, 38.42421], [-122.66406, 38.42445], [-122.66427, 38.42473], [-122.66467, 38.42516]]]} | Restricted Access 2 | 29799 | Bennett Valley Municipal Golf Course | 33093 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 150.922 | Bennett Valley Municipal GC | 0 | Local Recreation Area 3 | 4 | |
15705 | 15705 | 15704 | {"type": "Polygon", "coordinates": [[[-119.96788, 38.93696], [-119.96716, 38.93808], [-119.96692, 38.93882], [-119.96734, 38.93893], [-119.96695, 38.93973], [-119.96669, 38.94016], [-119.9666, 38.94043], [-119.9664, 38.94068], [-119.96631, 38.94081], [-119.96625, 38.94096], [-119.96611, 38.94122], [-119.96603, 38.94149], [-119.96602, 38.94177], [-119.96604, 38.94205], [-119.96572, 38.94257], [-119.96554, 38.94452], [-119.96536, 38.94453], [-119.96523, 38.94455], [-119.96498, 38.94464], [-119.96485, 38.94474], [-119.96423, 38.94526], [-119.9642, 38.94528], [-119.96415, 38.94528], [-119.964, 38.94391], [-119.96426, 38.94258], [-119.96414, 38.94251], [-119.96435, 38.94196], [-119.96434, 38.9418], [-119.96449, 38.94166], [-119.96448, 38.94092], [-119.96347, 38.94023], [-119.96245, 38.94032], [-119.96204, 38.93986], [-119.962, 38.93969], [-119.96214, 38.93955], [-119.96216, 38.93944], [-119.9634, 38.93944], [-119.9643, 38.93877], [-119.96429, 38.93697], [-119.96662, 38.93695], [-119.96788, 38.93696]]]} | Restricted Access 2 | 24106 | Bijou Municipal Golf Course | 33083 | 1411 | South Lake Tahoe, City of 990 | City 2 | City Agency 2 | http://www.cityofslt.us/index.aspx?nid=196 | City 2 | 1411 | South Lake Tahoe, City of 954 | City 2 | City Agency 2 | El Dorado 34 | 46.201 | Bijou Municipal GC | 1920 | Local Recreation Area 3 | 4 | |
15681 | 15681 | 15680 | {"type": "Polygon", "coordinates": [[[-122.06149, 37.31998], [-122.06122, 37.32014], [-122.061, 37.32033], [-122.06093, 37.32047], [-122.06052, 37.32091], [-122.0604, 37.32111], [-122.06035, 37.32174], [-122.06037, 37.32207], [-122.06071, 37.32234], [-122.06046, 37.32243], [-122.06041, 37.32289], [-122.05932, 37.32293], [-122.05955, 37.32208], [-122.05953, 37.32183], [-122.05959, 37.32144], [-122.05951, 37.3212], [-122.05948, 37.32082], [-122.05925, 37.32048], [-122.05923, 37.32027], [-122.05923, 37.3198], [-122.05918, 37.31952], [-122.05906, 37.31943], [-122.05906, 37.31811], [-122.05955, 37.31789], [-122.05996, 37.31769], [-122.06007, 37.31768], [-122.06043, 37.3185], [-122.06149, 37.31998]]]} | Restricted Access 2 | 14518 | Blackberry Farm Golf Course | 33038 | 1076 | Cupertino, City of 195 | City 2 | City Agency 2 | http://www.cupertino.org/index.aspx?page=591 | City 2 | 1076 | Cupertino, City of 191 | City 2 | City Agency 2 | Santa Clara 19 | 16.747 | Blackberry Farm GC | 0 | Local Recreation Area 3 | 4 | |
6193 | 6193 | 6192 | {"type": "Polygon", "coordinates": [[[-121.56192, 36.44252], [-121.55756, 36.4424], [-121.55754, 36.43877], [-121.54888, 36.43855], [-121.54884, 36.44575], [-121.53978, 36.4455], [-121.53984, 36.4346], [-121.53079, 36.43424], [-121.53081, 36.43057], [-121.53085, 36.42693], [-121.53987, 36.42728], [-121.53986, 36.43096], [-121.5489, 36.43134], [-121.54889, 36.43494], [-121.56186, 36.43525], [-121.56192, 36.44252]]]} | Restricted Access 2 | 18578 | Bloomquist Open Space | 16170 | 2085 | Monterey Peninsula Regional Park District 47 | Special District 4 | Recreation/Parks District 4 | http://www.mprpd.org/ | Special District 4 | 2085 | Monterey Peninsula Regional Park District 46 | Special District 4 | Recreation/Parks District 4 | Monterey 14 | 639.336 | Bloomquist OS | 0 | Local Recreation Area 3 | 4 | |
15716 | 15716 | 15715 | {"type": "MultiPolygon", "coordinates": [[[[-114.63174, 33.67102], [-114.63136, 33.67121], [-114.6317, 33.67154], [-114.63029, 33.67213], [-114.63019, 33.67219], [-114.63007, 33.67228], [-114.6296, 33.67245], [-114.62854, 33.67242], [-114.62864, 33.67508], [-114.62905, 33.67656], [-114.62821, 33.67876], [-114.62699, 33.67877], [-114.62693, 33.6753], [-114.62717, 33.67529], [-114.6272, 33.67448], [-114.62636, 33.67318], [-114.62583, 33.67137], [-114.62548, 33.67142], [-114.62456, 33.67023], [-114.62454, 33.66908], [-114.62451, 33.66883], [-114.62548, 33.66835], [-114.6257, 33.66763], [-114.62713, 33.66792], [-114.62832, 33.66823], [-114.62876, 33.6679], [-114.62888, 33.66803], [-114.63117, 33.66975], [-114.63115, 33.6698], [-114.63174, 33.67102]]], [[[-114.63716, 33.67426], [-114.63696, 33.67444], [-114.63682, 33.67451], [-114.63668, 33.67455], [-114.63645, 33.67455], [-114.63559, 33.6742], [-114.63489, 33.67416], [-114.63305, 33.67433], [-114.63279, 33.67471], [-114.6315, 33.67464], [-114.63103, 33.67444], [-114.63066, 33.67398], [-114.63014, 33.67242], [-114.63027, 33.6723], [-114.63047, 33.6722], [-114.63079, 33.67252], [-114.63152, 33.67319], [-114.63294, 33.67412], [-114.63313, 33.67408], [-114.63518, 33.67316], [-114.63529, 33.67325], [-114.63554, 33.67304], [-114.63716, 33.67426]]], [[[-114.64176, 33.67399], [-114.63934, 33.6741], [-114.63888, 33.67414], [-114.63811, 33.67413], [-114.63771, 33.6741], [-114.63726, 33.67411], [-114.63626, 33.67336], [-114.6365, 33.673], [-114.63751, 33.67202], [-114.63838, 33.67164], [-114.63896, 33.67179], [-114.63921, 33.67018], [-114.63754, 33.66906], [-114.63541, 33.67002], [-114.63533, 33.66989], [-114.63508, 33.67003], [-114.63435, 33.66982], [-114.63367, 33.66935], [-114.63305, 33.6692], [-114.63206, 33.66938], [-114.63129, 33.66962], [-114.63066, 33.66915], [-114.63182, 33.66854], [-114.63309, 33.66838], [-114.63342, 33.66849], [-114.6353, 33.66929], [-114.63741, 33.66898], [-114.63762, 33.66854], [-114.63918, 33.66905], [-114.64069, 33.66844], [-114.64168, 33.6684], [-114.64171, 33.66936], [-114.64067, 33.66973], [-114.64033, 33.67008], [-114.64011, 33.6708], [-114.63953, 33.67145], [-114.63916, 33.67229], [-114.6392, 33.67231], [-114.63917, 33.67238], [-114.64052, 33.67267], [-114.64174, 33.67312], [-114.64176, 33.67399]]]]} | Restricted Access 2 | 39053 | Blythe Municipal Golf Course | 33102 | 1032 | Blythe, City of 342 | City 2 | City Agency 2 | http://www.cityofblythe.ca.gov/88/Parks-Department | City 2 | 1032 | Blythe, City of 339 | City 2 | City Agency 2 | Riverside 10 | 157.412 | Blythe Municipal GC | 0 | Local Recreation Area 3 | 4 | |
11431 | 11431 | 11430 | {"type": "Polygon", "coordinates": [[[-118.34535, 33.89046], [-118.34465, 33.89053], [-118.34471, 33.89095], [-118.34436, 33.89096], [-118.34432, 33.88985], [-118.34484, 33.88984], [-118.34485, 33.88999], [-118.34528, 33.88995], [-118.34535, 33.89046]]]} | Restricted Access 2 | 48114 | Bollinger Gymnasium | 32629 | 2396 | Lawndale Elementary School District 670 | Special District 4 | School District 14 | http://www.lawndale.k12.ca.us/ | Special District 4 | 1172 | Lawndale, City of 475 | City 2 | City Agency 2 | http://www.lawndalecity.org/ASSETS/PDF/Parks/bollinger.pdf | Los Angeles 6 | 1.856 | Bollinger Gymnasium | 0 | Local Recreation Area 3 | 4 |
15704 | 15704 | 15703 | {"type": "Polygon", "coordinates": [[[-122.0059, 37.9266], [-122.00588, 37.92724], [-122.00532, 37.92828], [-122.0051, 37.92889], [-122.00468, 37.92966], [-122.00455, 37.92973], [-122.00424, 37.92981], [-122.00406, 37.92996], [-122.00278, 37.93026], [-122.0022, 37.9292], [-121.99905, 37.92943], [-121.99763, 37.92761], [-121.99599, 37.92776], [-121.99374, 37.92453], [-121.99457, 37.92375], [-121.99637, 37.9236], [-121.99942, 37.92264], [-122.00486, 37.92176], [-122.00508, 37.9224], [-122.0052, 37.92451], [-122.00519, 37.92546], [-122.0054, 37.9259], [-122.00549, 37.92588], [-122.00561, 37.92605], [-122.0059, 37.9266]]]} | Restricted Access 2 | 23698 | Boundary Oak Golf Course | 33081 | 1371 | Walnut Creek, City of 178 | City 2 | City Agency 2 | http://www.ci.walnut-creek.ca.us/citygov/depts/ps/openspace/default.asp | City 2 | 1371 | Walnut Creek, City of 174 | City 2 | City Agency 2 | Contra Costa 12 | 159.583 | Boundary Oak GC | 0 | Local Recreation Area 3 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]), FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]), FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]), FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]), FOREIGN KEY([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);