units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
363 rows where ACCESS_TYP = 2 and MNG_AG_TYP = 2 sorted by COUNTY
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, YR_EST, GAP_STS
MNG_AGENCY >30
- Los Angeles, City of 20
- Whittier, City of 20
- San Ramon, City of 15
- San Diego, City of 10
- Long Beach, City of 9
- Arcadia, City of 8
- Manhattan Beach, City of 8
- Santa Cruz, City of 7
- Modesto, City of 7
- San Jose, City of 6
- Carlsbad, City of 6
- Hollister, City of 6
- Pasadena, City of 6
- Santa Ana, City of 5
- Fullerton, City of 5
- Vacaville, City of 5
- San Bernardino, City of 5
- Beverly Hills, City of 5
- Lawndale, City of 5
- San Gabriel, City of 5
- Glendora, City of 4
- El Segundo, City of 4
- Stockton, City of 4
- Mountain View, City of 4
- Roseville, City of 4
- South El Monte, City of 4
- Watsonville, City of 3
- San Luis Obispo, City of 3
- Oceanside, City of 3
- Pomona, City of 3
- …
DES_TP >30
- Local Recreation Area 168
- Local Park 151
- Local Conservation Area 10
- Local Other or Unknown 6
- Local Historic or Cultural Area 2
- 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
- None 1
- None 1
- None 1
- …
MNG_AG_TYP 1
- City Agency · 363 ✖
ACCESS_TYP 1
- Restricted Access · 363 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4160 | 4160 | 4159 | {"type": "Polygon", "coordinates": [[[-120.88662, 35.44856], [-120.88637, 35.45027], [-120.88645, 35.45032], [-120.88642, 35.4505], [-120.88586, 35.45105], [-120.88586, 35.45146], [-120.88525, 35.45142], [-120.88432, 35.45064], [-120.88407, 35.45064], [-120.88393, 35.45085], [-120.88399, 35.45208], [-120.88455, 35.45256], [-120.88418, 35.45304], [-120.88415, 35.45371], [-120.8839, 35.45439], [-120.88401, 35.45467], [-120.88424, 35.45492], [-120.88421, 35.45504], [-120.88376, 35.45517], [-120.88362, 35.45533], [-120.8834, 35.45535], [-120.88331, 35.45503], [-120.88303, 35.45467], [-120.88301, 35.45368], [-120.88275, 35.45334], [-120.88275, 35.45295], [-120.88194, 35.45233], [-120.88186, 35.45206], [-120.88152, 35.45174], [-120.88105, 35.4519], [-120.88038, 35.45242], [-120.87968, 35.45347], [-120.8799, 35.45437], [-120.87906, 35.45428], [-120.87895, 35.45419], [-120.87878, 35.45309], [-120.87901, 35.45229], [-120.8792, 35.45201], [-120.87923, 35.45156], [-120.87886, 35.45137], [-120.87705, 35.45132], [-120.87688, 35.45142], [-120.87671, 35.45221], [-120.87649, 35.45251], [-120.87599, 35.4526], [-120.87548, 35.45263], [-120.87517, 35.45288], [-120.87456, 35.45298], [-120.87445, 35.45309], [-120.87433, 35.45364], [-120.87372, 35.45389], [-120.87347, 35.4538], [-120.87299, 35.45394], [-120.8728, 35.45449], [-120.87207, 35.45554], [-120.87193, 35.45584], [-120.87196, 35.45686], [-120.87224, 35.45712], [-120.87232, 35.45737], [-120.8721, 35.45788], [-120.87235, 35.45902], [-120.87246, 35.45911], [-120.87235, 35.45989], [-120.87221, 35.46014], [-120.8721, 35.46064], [-120.87196, 35.4608], [-120.87199, 35.46101], [-120.87249, 35.46145], [-120.8728, 35.46193], [-120.87275, 35.46245], [-120.87213, 35.46328], [-120.87213, 35.46352], [-120.87255, 35.46362], [-120.87263, 35.46371], [-120.87263, 35.46422], [-120.87247, 35.46431], [-120.8718, 35.46419], [-120.87138, 35.4638], [-120.87124, 35.46378], [-120.8704, 35.46435], [-120.87003, 35.46447], [-120.86979, 35.46441], [-120.86964, 35.46413], [-120.86987, 35.46408], [-120.87003, 35.46392], [-120.87006, 35.46374], [-120.86975, 35.4636], [-120.86953, 35.46305], [-120.86969, 35.46262], [-120.8695, 35.46245], [-120.86955, 35.46099], [-120.87, 35.46051], [-120.87003, 35.45989], [-120.86905, 35.459], [-120.86894, 35.45849], [-120.86849, 35.45829], [-120.86804, 35.45776], [-120.86782, 35.45758], [-120.86734, 35.45756], [-120.86703, 35.45772], [-120.86684, 35.45771], [-120.86687, 35.45751], [-120.86698, 35.45737], [-120.86748, 35.45714], [-120.86776, 35.45671], [-120.86785, 35.45618], [-120.8681, 35.45584], [-120.86874, 35.45584], [-120.86899, 35.45561], [-120.86924, 35.4549], [-120.86924, 35.45431], [-120.86905, 35.4541], [-120.86905, 35.45373], [-120.86924, 35.45339], [-120.86941, 35.45215], [-120.86997, 35.45099], [-120.87061, 35.45085], [-120.87114, 35.45041], [-120.87226, 35.4489], [-120.87237, 35.44762], [-120.87251, 35.44739], [-120.87324, 35.44691], [-120.87374, 35.44675], [-120.87486, 35.44663], [-120.87562, 35.44682], [-120.87599, 35.44713], [-120.87683, 35.44766], [-120.87803, 35.44766], [-120.8787, 35.44789], [-120.87918, 35.44787], [-120.87965, 35.44771], [-120.88021, 35.44775], [-120.88192, 35.44819], [-120.8827, 35.44819], [-120.88343, 35.44796], [-120.88662, 35.44856]]]} | Restricted Access 2 | 44743 | Whale Rock Reservoir | 27446 | 207 | California Department of Water Resources 477 | State 5 | State Agency 5 | http://www.water.ca.gov/ | Other State 5 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 282.826 | Whale Rock Reservoir | 0 | Local Recreation Area 3 | 4 | |
6410 | 6410 | 6409 | {"type": "MultiPolygon", "coordinates": [[[[-120.85781, 35.47038], [-120.8576, 35.47052], [-120.85741, 35.47067], [-120.85723, 35.47086], [-120.8571, 35.47104], [-120.85699, 35.47122], [-120.85691, 35.47142], [-120.85681, 35.47178], [-120.85678, 35.47199], [-120.85565, 35.47199], [-120.85497, 35.47201], [-120.85379, 35.47197], [-120.8534, 35.47197], [-120.85344, 35.47036], [-120.85781, 35.47038]]], [[[-120.86826, 35.4694], [-120.86824, 35.47331], [-120.85682, 35.47326], [-120.85741, 35.47321], [-120.85761, 35.47316], [-120.85778, 35.47306], [-120.85828, 35.47261], [-120.85842, 35.47254], [-120.85857, 35.4725], [-120.85953, 35.47248], [-120.86111, 35.47272], [-120.86124, 35.47273], [-120.86386, 35.47235], [-120.86401, 35.47228], [-120.86412, 35.4722], [-120.86534, 35.47097], [-120.86548, 35.47086], [-120.86571, 35.47079], [-120.86695, 35.4706], [-120.8672, 35.47052], [-120.86744, 35.47039], [-120.86758, 35.47029], [-120.86772, 35.47015], [-120.86816, 35.46951], [-120.86826, 35.4694]]], [[[-120.88945, 35.45158], [-120.88818, 35.45144], [-120.88838, 35.45703], [-120.88624, 35.45705], [-120.88624, 35.4588], [-120.88128, 35.45883], [-120.87823, 35.46], [-120.87683, 35.45728], [-120.87511, 35.45676], [-120.87526, 35.46117], [-120.8775, 35.46112], [-120.87771, 35.46723], [-120.87532, 35.46729], [-120.87531, 35.4673], [-120.87557, 35.47469], [-120.87588, 35.47622], [-120.87722, 35.47508], [-120.87721, 35.47908], [-120.8759, 35.47975], [-120.87565, 35.47989], [-120.87539, 35.47989], [-120.87537, 35.47973], [-120.87514, 35.47898], [-120.87509, 35.47819], [-120.87504, 35.47807], [-120.87487, 35.47783], [-120.87482, 35.47768], [-120.87482, 35.47754], [-120.87491, 35.47734], [-120.87494, 35.47718], [-120.87493, 35.47704], [-120.87487, 35.47688], [-120.87474, 35.47671], [-120.87457, 35.47659], [-120.87438, 35.47654], [-120.87411, 35.47653], [-120.87405, 35.47651], [-120.874, 35.47647], [-120.87384, 35.47606], [-120.87366, 35.47572], [-120.87348, 35.47545], [-120.8729, 35.47469], [-120.87233, 35.47337], [-120.87221, 35.47316], [-120.87208, 35.47299], [-120.87195, 35.47286], [-120.87108, 35.47216], [-120.87052, 35.47141], [-120.87047, 35.47132], [-120.87046, 35.47124], [-120.87035, 35.46989], [-120.8703, 35.46968], [-120.87019, 35.46948], [-120.87003, 35.46929], [-120.86978, 35.46912], [-120.86953, 35.46901], [-120.86934, 35.46897], [-120.86918, 35.46895], [-120.86892, 35.46896], [-120.86862, 35.46902], [-120.86835, 35.46914], [-120.86819, 35.46926], [-120.86805, 35.4694], [-120.86762, 35.47002], [-120.86752, 35.47013], [-120.86733, 35.47029], [-120.8671, 35.47041], [-120.86682, 35.47049], [-120.86564, 35.47066], [-120.86539, 35.47075], [-120.86521, 35.47088], [-120.86402, 35.47209], [-120.86392, 35.47217], [-120.86379, 35.47222], [-120.86123, 35.47259], [-120.86113, 35.47259], [-120.85956, 35.47235], [-120.85857, 35.47236], [-120.85837, 35.47241], [-120.85818, 35.4725], [-120.85766, 35.47296], [-120.85755, 35.47303], [-120.85738, 35.47308], [-120.85686, 35.47312], [-120.85691, 35.47285], [-120.85694, 35.47257], [-120.85694, 35.47207], [-120.85696, 35.4719], [-120.85707, 35.47146], [-120.85718, 35.47122], [-120.85734, 35.47097], [-120.85759, 35.47071], [-120.85783, 35.47054], [-120.85806, 35.47042], [-120.85832, 35.47032], [-120.85864, 35.47026], [-120.8589, 35.47024], [-120.85915, 35.47025], [-120.86032, 35.47052], [-120.86065, 35.47058], [-120.86112, 35.4706], [-120.86141, 35.47058], [-120.86171, 35.47054], [-120.86194, 35.47047], [-120.86212, 35.47039], [-120.86231, 35.47027], [-120.86245, 35.47014], [-120.86254, 35.47002], [-120.86269, 35.46954], [-120.86271, 35.46939], [-120.86271, 35.46928], [-120.86268, 35.46913], [-120.86264, 35.469], [-120.86251, 35.46881], [-120.86227, 35.46857], [-120.86216, 35.46842], [-120.86209, 35.46828], [-120.86204, 35.46809], [-120.86203, 35.46792], [-120.86206, 35.46778], [-120.86233, 35.46702], [-120.86237, 35.46683], [-120.86238, 35.4667], [-120.86236, 35.46654], [-120.86228, 35.46627], [-120.86219, 35.46612], [-120.8621, 35.466], [-120.85959, 35.46311], [-120.85948, 35.46296], [-120.85933, 35.46265], [-120.85926, 35.46246], [-120.85924, 35.46231], [-120.85923, 35.46197], [-120.85927, 35.46173], [-120.86041, 35.45914], [-120.86057, 35.45894], [-120.8615, 35.45803], [-120.86159, 35.4579], [-120.86191, 35.45736], [-120.86203, 35.45721], [-120.86221, 35.45707], [-120.86294, 35.45662], [-120.86308, 35.45652], [-120.86421, 35.45532], [-120.86577, 35.45403], [-120.86593, 35.45386], [-120.86605, 35.4537], [-120.86614, 35.4535], [-120.86668, 35.45126], [-120.86676, 35.45107], [-120.86688, 35.45089], [-120.86819, 35.44942], [-120.86849, 35.44915], [-120.8689, 35.4489], [-120.86862, 35.44885], [-120.86915, 35.44846], [-120.86948, 35.44897], [-120.86973, 35.449], [-120.87005, 35.44868], [-120.87066, 35.44904], [-120.8713, 35.44837], [-120.87072, 35.448], [-120.87483, 35.44385], [-120.87733, 35.44296], [-120.87844, 35.44296], [-120.88138, 35.44564], [-120.88726, 35.44384], [-120.88744, 35.44401], [-120.88666, 35.44476], [-120.88671, 35.44593], [-120.88675, 35.44609], [-120.88685, 35.44609], [-120.88701, 35.44604], [-120.88715, 35.44596], [-120.88727, 35.44585], [-120.88734, 35.4457], [-120.88738, 35.44549], [-120.88738, 35.44535], [-120.88743, 35.44522], [-120.88749, 35.44511], [-120.88773, 35.44489], [-120.8882, 35.44523], [-120.88945, 35.45158]], [[-120.88637, 35.45027], [-120.88661, 35.44856], [-120.88343, 35.44796], [-120.8827, 35.44819], [-120.88192, 35.44819], [-120.88021, 35.44775], [-120.87965, 35.44771], [-120.87918, 35.44787], [-120.8787, 35.44789], [-120.87803, 35.44766], [-120.87683, 35.44766], [-120.87599, 35.44713], [-120.87562, 35.44682], [-120.87486, 35.44663], [-120.87374, 35.44675], [-120.87324, 35.44691], [-120.87251, 35.44739], [-120.87237, 35.44762], [-120.87226, 35.4489], [-120.87114, 35.45041], [-120.87061, 35.45085], [-120.86997, 35.45099], [-120.86941, 35.45215], [-120.86924, 35.45339], [-120.86905, 35.45373], [-120.86905, 35.4541], [-120.86924, 35.4543], [-120.86924, 35.4549], [-120.86899, 35.45561], [-120.86874, 35.45584], [-120.86809, 35.45584], [-120.86785, 35.45618], [-120.86776, 35.45671], [-120.86748, 35.45714], [-120.86698, 35.45737], [-120.86687, 35.45751], [-120.86684, 35.4577], [-120.86685, 35.45772], [-120.86703, 35.45772], [-120.86734, 35.45756], [-120.86782, 35.45758], [-120.86804, 35.45776], [-120.86849, 35.45829], [-120.86894, 35.45849], [-120.86905, 35.459], [-120.87003, 35.45989], [-120.87, 35.46051], [-120.86955, 35.46099], [-120.8695, 35.46245], [-120.86969, 35.46261], [-120.86953, 35.46305], [-120.86975, 35.4636], [-120.87006, 35.46374], [-120.87003, 35.46392], [-120.86987, 35.46408], [-120.86965, 35.46413], [-120.86979, 35.46441], [-120.87003, 35.46447], [-120.87039, 35.46435], [-120.87124, 35.46378], [-120.87137, 35.4638], [-120.8718, 35.46419], [-120.87247, 35.46431], [-120.87263, 35.46421], [-120.87263, 35.46371], [-120.87255, 35.46362], [-120.87213, 35.46353], [-120.87213, 35.46328], [-120.87275, 35.46245], [-120.8728, 35.46193], [-120.87249, 35.46145], [-120.87199, 35.46101], [-120.87196, 35.4608], [-120.8721, 35.46064], [-120.87221, 35.46014], [-120.87235, 35.45989], [-120.87246, 35.45911], [-120.87235, 35.45902], [-120.8721, 35.45787], [-120.87232, 35.45737], [-120.87224, 35.45712], [-120.87196, 35.45687], [-120.87193, 35.45584], [-120.87207, 35.45554], [-120.8728, 35.45449], [-120.87299, 35.45394], [-120.87347, 35.4538], [-120.87372, 35.45389], [-120.87433, 35.45364], [-120.87445, 35.45309], [-120.87456, 35.45298], [-120.87517, 35.45288], [-120.87548, 35.45263], [-120.87599, 35.4526], [-120.87649, 35.45251], [-120.87671, 35.45221], [-120.87688, 35.45141], [-120.87705, 35.45132], [-120.87887, 35.45137], [-120.87923, 35.45155], [-120.8792, 35.45201], [-120.87901, 35.45229], [-120.87878, 35.45309], [-120.87895, 35.45419], [-120.87906, 35.45428], [-120.87989, 35.45436], [-120.87968, 35.45347], [-120.88038, 35.45242], [-120.88105, 35.4519], [-120.88152, 35.45174], [-120.88186, 35.45206], [-120.88195, 35.45233], [-120.88275, 35.45295], [-120.88275, 35.45334], [-120.88301, 35.45368], [-120.88303, 35.45467], [-120.88331, 35.45503], [-120.8834, 35.45535], [-120.88362, 35.45533], [-120.88376, 35.45517], [-120.88421, 35.45503], [-120.88423, 35.45492], [-120.88401, 35.45467], [-120.8839, 35.4544], [-120.88415, 35.45371], [-120.88418, 35.45304], [-120.88454, 35.45256], [-120.88399, 35.45208], [-120.88393, 35.45085], [-120.88407, 35.45064], [-120.88432, 35.45064], [-120.88525, 35.45142], [-120.88585, 35.45146], [-120.88586, 35.45105], [-120.88642, 35.4505], [-120.88645, 35.45032], [-120.88637, 35.45027]]], [[[-120.86618, 35.45263], [-120.86596, 35.4535], [-120.8659, 35.45364], [-120.86578, 35.4538], [-120.86565, 35.45393], [-120.8641, 35.45522], [-120.86296, 35.45642], [-120.86284, 35.45652], [-120.86209, 35.45697], [-120.86188, 35.45714], [-120.86175, 35.45731], [-120.86143, 35.45786], [-120.86135, 35.45797], [-120.86044, 35.45885], [-120.86029, 35.45902], [-120.8602, 35.45918], [-120.85971, 35.4603], [-120.85972, 35.45707], [-120.86166, 35.45708], [-120.86208, 35.45655], [-120.86321, 35.45569], [-120.86444, 35.45449], [-120.86519, 35.45416], [-120.86614, 35.45262], [-120.86618, 35.45263]]], [[[-120.87522, 35.47989], [-120.87432, 35.4799], [-120.87421, 35.47782], [-120.87294, 35.47949], [-120.87296, 35.47504], [-120.87333, 35.47552], [-120.87351, 35.47578], [-120.87365, 35.47605], [-120.87383, 35.47648], [-120.87387, 35.47656], [-120.87396, 35.47663], [-120.87406, 35.47666], [-120.87436, 35.47667], [-120.87447, 35.4767], [-120.8746, 35.47679], [-120.87472, 35.47695], [-120.87476, 35.47707], [-120.87477, 35.47718], [-120.87474, 35.47731], [-120.87466, 35.47752], [-120.87465, 35.47772], [-120.87471, 35.47786], [-120.8749, 35.47815], [-120.87493, 35.47823], [-120.87497, 35.47898], [-120.8752, 35.47976], [-120.87522, 35.47989]]], [[[-120.88888, 35.44363], [-120.8874, 35.44494], [-120.8872, 35.44475], [-120.88722, 35.44433], [-120.88762, 35.44398], [-120.88832, 35.4437], [-120.8887, 35.44344], [-120.88888, 35.44363]]]]} | Restricted Access 2 | 1848 | Whale Rock Reservoir | 27446 | 207 | California Department of Water Resources 477 | State 5 | State Agency 5 | http://www.water.ca.gov/ | Other State 5 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 1098.807 | Whale Rock Reservoir | 0 | Local Recreation Area 3 | 4 | |
15691 | 15691 | 15690 | {"type": "Polygon", "coordinates": [[[-120.69862, 35.26213], [-120.69779, 35.26279], [-120.69759, 35.26263], [-120.69788, 35.26237], [-120.6974, 35.26197], [-120.69741, 35.26154], [-120.6972, 35.26136], [-120.69743, 35.26116], [-120.69862, 35.26213]]]} | Restricted Access 2 | 17195 | Laguna Lake Golf Course | 33055 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 2.344 | Laguna Lake GC | 0 | Local Recreation Area 3 | 4 | |
3 | 3 | 2 | {"type": "Polygon", "coordinates": [[[-120.81796, 37.78801], [-120.81602, 37.78793], [-120.81565, 37.78787], [-120.81358, 37.7878], [-120.81268, 37.78774], [-120.8117, 37.78776], [-120.8111, 37.78789], [-120.81064, 37.78764], [-120.80991, 37.78733], [-120.80928, 37.78757], [-120.80895, 37.78704], [-120.80743, 37.78568], [-120.80702, 37.78537], [-120.80701, 37.78515], [-120.80703, 37.78338], [-120.80993, 37.78254], [-120.81293, 37.78022], [-120.81292, 37.77802], [-120.81434, 37.77723], [-120.81693, 37.77715], [-120.81697, 37.78113], [-120.81726, 37.78253], [-120.81756, 37.78477], [-120.81686, 37.78479], [-120.81635, 37.78482], [-120.8157, 37.78465], [-120.81513, 37.78463], [-120.81405, 37.78454], [-120.81371, 37.7843], [-120.81343, 37.78428], [-120.81288, 37.78427], [-120.81092, 37.78458], [-120.81058, 37.78429], [-120.81017, 37.78433], [-120.80902, 37.785], [-120.80861, 37.78529], [-120.80875, 37.78561], [-120.80897, 37.78583], [-120.80941, 37.78606], [-120.80994, 37.78614], [-120.81072, 37.78613], [-120.81093, 37.78596], [-120.8114, 37.78609], [-120.81224, 37.78639], [-120.81288, 37.78655], [-120.8129, 37.78674], [-120.81368, 37.78684], [-120.8148, 37.78683], [-120.81525, 37.78688], [-120.81579, 37.78697], [-120.81674, 37.78697], [-120.81725, 37.78683], [-120.81777, 37.7866], [-120.81796, 37.78801]], [[-120.81641, 37.7829], [-120.81637, 37.78261], [-120.81576, 37.78291], [-120.81539, 37.78302], [-120.81522, 37.78337], [-120.81521, 37.78348], [-120.8154, 37.78386], [-120.81556, 37.78389], [-120.81566, 37.78395], [-120.81602, 37.78396], [-120.81609, 37.784], [-120.81655, 37.78409], [-120.81655, 37.78401], [-120.81644, 37.78328], [-120.81641, 37.7829]]]} | Restricted Access 2 | 9 | Oakdale Golf & Country Club | 32983 | 1227 | Oakdale, City of 2 | City 2 | City Agency 2 | http://www.oakdalegov.com/#!recreation/c222d | City 2 | 1227 | Oakdale, City of 2 | City 2 | City Agency 2 | Stanislaus 2 | 137.317 | Oakdale Golf & Country Club | 0 | Local Recreation Area 3 | 4 | |
4 | 4 | 3 | {"type": "Polygon", "coordinates": [[[-120.8183, 37.79059], [-120.81762, 37.7907], [-120.81665, 37.79072], [-120.81597, 37.7907], [-120.81518, 37.79071], [-120.81444, 37.7908], [-120.81354, 37.79068], [-120.81324, 37.79069], [-120.81119, 37.79087], [-120.81012, 37.79017], [-120.80995, 37.78962], [-120.81, 37.78839], [-120.80928, 37.78757], [-120.80991, 37.78733], [-120.81064, 37.78764], [-120.8111, 37.78789], [-120.81169, 37.78776], [-120.81268, 37.78774], [-120.81358, 37.7878], [-120.81565, 37.78787], [-120.81602, 37.78793], [-120.81796, 37.78801], [-120.8183, 37.79059]]]} | Restricted Access 2 | 24 | Stanley Wakefield Wilderness Area | 25790 | 1227 | Oakdale, City of 2 | City 2 | City Agency 2 | http://www.oakdalegov.com/#!recreation/c222d | City 2 | 1227 | Oakdale, City of 2 | City 2 | City Agency 2 | Stanislaus 2 | 57.379 | Stanley Wakefield Wilderness Area | 0 | Local Conservation Area 4 | 2 | |
7199 | 7199 | 7198 | {"type": "Polygon", "coordinates": [[[-120.97533, 37.62623], [-120.97481, 37.62623], [-120.97482, 37.62608], [-120.97533, 37.62607], [-120.97533, 37.62623]]]} | Restricted Access 2 | 34894 | Legion Park | 21143 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 0.197 | Legion Park | 0 | Local Park 2 | 4 | |
13046 | 13046 | 13045 | {"type": "Polygon", "coordinates": [[[-120.97835, 37.62482], [-120.97835, 37.6252], [-120.97609, 37.62409], [-120.9755, 37.62372], [-120.97562, 37.62339], [-120.97585, 37.62358], [-120.97681, 37.62388], [-120.97819, 37.62474], [-120.97835, 37.62482]]]} | Restricted Access 2 | 34895 | Mancini Park | 21733 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 3.106 | Mancini Park | 0 | Local Park 2 | 4 | |
15697 | 15697 | 15696 | {"type": "Polygon", "coordinates": [[[-120.94998, 37.64964], [-120.94987, 37.64947], [-120.94973, 37.64935], [-120.94933, 37.64916], [-120.94892, 37.64904], [-120.94857, 37.64887], [-120.94821, 37.6486], [-120.94808, 37.64857], [-120.94792, 37.64849], [-120.94767, 37.64842], [-120.94752, 37.64832], [-120.94726, 37.64824], [-120.94705, 37.64824], [-120.94689, 37.64827], [-120.94604, 37.64854], [-120.94578, 37.64871], [-120.94549, 37.64892], [-120.94541, 37.649], [-120.94526, 37.6492], [-120.9452, 37.64934], [-120.94519, 37.64946], [-120.94455, 37.6507], [-120.94414, 37.65124], [-120.94359, 37.65155], [-120.9433, 37.65173], [-120.94296, 37.65199], [-120.94286, 37.65209], [-120.94267, 37.65231], [-120.94275, 37.65236], [-120.94262, 37.65253], [-120.94256, 37.65267], [-120.94237, 37.65297], [-120.94211, 37.65331], [-120.94171, 37.65367], [-120.94162, 37.65382], [-120.94154, 37.65391], [-120.94143, 37.654], [-120.94125, 37.65409], [-120.94096, 37.6542], [-120.94082, 37.65422], [-120.94049, 37.65421], [-120.94027, 37.65418], [-120.93922, 37.65415], [-120.9392, 37.65408], [-120.93862, 37.6541], [-120.93813, 37.65394], [-120.93784, 37.65395], [-120.93715, 37.65383], [-120.93698, 37.65383], [-120.93663, 37.65371], [-120.93635, 37.65364], [-120.93558, 37.65356], [-120.93523, 37.65357], [-120.93523, 37.65365], [-120.93405, 37.65329], [-120.9337, 37.65323], [-120.9332, 37.65298], [-120.93291, 37.65275], [-120.9319, 37.65225], [-120.93167, 37.65218], [-120.93136, 37.65204], [-120.93064, 37.65213], [-120.93016, 37.6523], [-120.93014, 37.65079], [-120.93024, 37.65078], [-120.93022, 37.64918], [-120.93024, 37.64915], [-120.93026, 37.64914], [-120.93898, 37.64909], [-120.93901, 37.64911], [-120.93909, 37.64943], [-120.93911, 37.65109], [-120.93918, 37.65109], [-120.93919, 37.65111], [-120.94141, 37.65108], [-120.9414, 37.65094], [-120.93924, 37.65097], [-120.93923, 37.64954], [-120.93916, 37.64929], [-120.93916, 37.6492], [-120.93926, 37.64917], [-120.93926, 37.64923], [-120.93927, 37.64924], [-120.94039, 37.64881], [-120.94039, 37.64872], [-120.94066, 37.64859], [-120.94207, 37.64761], [-120.94226, 37.6475], [-120.94247, 37.64742], [-120.94438, 37.64684], [-120.94459, 37.64676], [-120.94479, 37.64665], [-120.94661, 37.64545], [-120.94678, 37.64537], [-120.94705, 37.6453], [-120.94724, 37.64529], [-120.94804, 37.64529], [-120.94813, 37.64549], [-120.94817, 37.64844], [-120.94821, 37.64848], [-120.9483, 37.64851], [-120.9483, 37.64864], [-120.94908, 37.64902], [-120.94982, 37.64935], [-120.94998, 37.64949], [-120.94998, 37.64964]], [[-120.94255, 37.65248], [-120.94255, 37.65246], [-120.94248, 37.65247], [-120.9424, 37.65264], [-120.94244, 37.65264], [-120.94255, 37.65248]]]} | Restricted Access 2 | 18555 | Creekside Golf Course | 33066 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 181.194 | Creekside GC | 0 | Local Recreation Area 3 | 4 | |
15698 | 15698 | 15697 | {"type": "Polygon", "coordinates": [[[-121.01091, 37.61013], [-121.01091, 37.61163], [-121.01087, 37.61165], [-121.01029, 37.61165], [-121.01028, 37.61259], [-121.00951, 37.61259], [-121.0095, 37.61333], [-121.00713, 37.61333], [-121.00713, 37.6133], [-121.0069, 37.61319], [-121.00574, 37.61394], [-121.00469, 37.61511], [-121.00313, 37.61607], [-121.00289, 37.61662], [-121.00346, 37.61667], [-121.00336, 37.61699], [-121.00483, 37.617], [-121.00483, 37.61781], [-121.00413, 37.61781], [-121.00412, 37.61791], [-121.00265, 37.61791], [-121.00265, 37.61768], [-121.00264, 37.61767], [-121.00076, 37.62018], [-121.00023, 37.62069], [-120.99953, 37.62116], [-120.99932, 37.62134], [-120.99844, 37.62135], [-120.99856, 37.61961], [-120.99866, 37.61853], [-120.99872, 37.61772], [-120.9986, 37.61696], [-120.99845, 37.61648], [-120.99809, 37.61568], [-120.99824, 37.61515], [-121.00054, 37.61294], [-121.0023, 37.61183], [-121.00496, 37.61077], [-121.00724, 37.61022], [-121.00952, 37.60948], [-121.00952, 37.60976], [-121.00959, 37.60976], [-121.01091, 37.61013]]]} | Restricted Access 2 | 18585 | Dryden Park Golf Course | 33067 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 145.239 | Dryden Park GC | 0 | Local Recreation Area 3 | 4 | |
15699 | 15699 | 15698 | {"type": "MultiPolygon", "coordinates": [[[[-120.99932, 37.62134], [-120.99917, 37.62154], [-120.99906, 37.62181], [-120.99884, 37.62328], [-120.99886, 37.62347], [-120.99888, 37.62356], [-120.99917, 37.62423], [-120.99856, 37.62423], [-120.99861, 37.62338], [-120.99842, 37.62163], [-120.99844, 37.62135], [-120.99932, 37.62134]]], [[[-121.00483, 37.6277], [-121.00335, 37.6277], [-121.00334, 37.6274], [-121.00293, 37.6274], [-121.00293, 37.6277], [-121.0001, 37.62764], [-120.99933, 37.62754], [-120.99931, 37.62579], [-120.9994, 37.62481], [-120.99939, 37.6246], [-120.99936, 37.62439], [-120.9993, 37.62419], [-120.99901, 37.62354], [-120.99899, 37.62345], [-120.99898, 37.62328], [-120.99919, 37.62183], [-120.9993, 37.62158], [-120.99941, 37.62144], [-120.99954, 37.6213], [-121.00026, 37.62082], [-121.00037, 37.62075], [-121.0005, 37.6207], [-121.00077, 37.62066], [-121.0015, 37.62067], [-121.00149, 37.62352], [-121.00206, 37.62352], [-121.00206, 37.62423], [-121.00252, 37.62424], [-121.00253, 37.62432], [-121.0048, 37.62432], [-121.00483, 37.6277]]]]} | Restricted Access 2 | 18745 | Modesto Municipal Golf Course | 33068 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 67.968 | Modesto Municipal GC | 0 | Local Recreation Area 3 | 4 | |
16267 | 16267 | 16266 | {"type": "MultiPolygon", "coordinates": [[[[-120.96798, 37.62431], [-120.9679, 37.62465], [-120.96772, 37.62462], [-120.9678, 37.62428], [-120.96798, 37.62431]]], [[[-120.96854, 37.6244], [-120.96834, 37.62437], [-120.96827, 37.6247], [-120.96809, 37.62467], [-120.96817, 37.62428], [-120.96853, 37.62433], [-120.96854, 37.6244]]], [[[-120.97082, 37.62484], [-120.97024, 37.62472], [-120.97023, 37.62482], [-120.96997, 37.62477], [-120.9698, 37.62476], [-120.96964, 37.62479], [-120.96944, 37.62487], [-120.96906, 37.62491], [-120.96905, 37.62476], [-120.96863, 37.62475], [-120.96864, 37.62414], [-120.9675, 37.62391], [-120.96745, 37.62417], [-120.96763, 37.6242], [-120.96754, 37.6246], [-120.96736, 37.62457], [-120.96744, 37.62418], [-120.96708, 37.62412], [-120.96672, 37.62408], [-120.96663, 37.62447], [-120.96632, 37.62442], [-120.96629, 37.6244], [-120.96626, 37.62432], [-120.96624, 37.6242], [-120.96623, 37.62277], [-120.96846, 37.62263], [-120.96924, 37.62277], [-120.97081, 37.62292], [-120.97082, 37.62484]]]]} | Restricted Access 2 | 34896 | Tuolumne River Regional Park | 6748 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 19.414 | Tuolumne River RP | 0 | Local Park 2 | 4 | |
16368 | 16368 | 16367 | {"type": "MultiPolygon", "coordinates": [[[[-120.96864, 37.62414], [-120.96864, 37.62434], [-120.96817, 37.62428], [-120.96808, 37.62467], [-120.9679, 37.62465], [-120.96799, 37.62426], [-120.96782, 37.62423], [-120.96772, 37.62462], [-120.96754, 37.6246], [-120.96762, 37.62421], [-120.96745, 37.62418], [-120.96736, 37.62457], [-120.96663, 37.62447], [-120.96672, 37.62407], [-120.9669, 37.6241], [-120.96689, 37.62415], [-120.96706, 37.62418], [-120.96708, 37.62412], [-120.96744, 37.62417], [-120.96749, 37.62391], [-120.96864, 37.62414]]], [[[-120.96854, 37.62474], [-120.96827, 37.6247], [-120.96834, 37.62437], [-120.96854, 37.6244], [-120.96854, 37.62474]]], [[[-120.9746, 37.62611], [-120.97324, 37.62554], [-120.97195, 37.62512], [-120.97082, 37.62484], [-120.97081, 37.62292], [-120.97343, 37.62388], [-120.97378, 37.62412], [-120.97459, 37.62461], [-120.9746, 37.62611]]]]} | Restricted Access 2 | 34897 | Tuolumne River Regional Park | 6748 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 17.831 | Tuolumne River RP | 0 | Local Park 2 | 4 | |
1392 | 1392 | 1391 | {"type": "MultiPolygon", "coordinates": [[[[-117.69075, 33.62392], [-117.68979, 33.62464], [-117.6881, 33.62602], [-117.68796, 33.62602], [-117.68764, 33.62571], [-117.68732, 33.6253], [-117.68703, 33.62485], [-117.68795, 33.62401], [-117.68946, 33.62275], [-117.69075, 33.62392]]], [[[-117.69308, 33.61785], [-117.69279, 33.61798], [-117.69244, 33.61822], [-117.69209, 33.61852], [-117.69108, 33.62006], [-117.69044, 33.6209], [-117.69044, 33.62091], [-117.69115, 33.62121], [-117.69006, 33.62215], [-117.68996, 33.62243], [-117.68983, 33.62274], [-117.68763, 33.62065], [-117.68806, 33.62016], [-117.68832, 33.61992], [-117.68852, 33.6197], [-117.68907, 33.61929], [-117.68969, 33.61891], [-117.69138, 33.61803], [-117.69201, 33.61773], [-117.69254, 33.61741], [-117.69268, 33.61741], [-117.69308, 33.61785]]]]} | Restricted Access 2 | 30526 | Lake Forest Golf Course | 33099 | 1167 | Lake Forest, City of 235 | City 2 | City Agency 2 | http://www.lakeforestca.gov/depts/cs/city_parks/default.asp | City 2 | 1167 | Lake Forest, City of 231 | City 2 | City Agency 2 | Orange 3 | 40.437 | Lake Forest GC | 0 | Local Recreation Area 3 | 4 | |
5739 | 5739 | 5738 | {"type": "Polygon", "coordinates": [[[-117.86368, 33.71492], [-117.86366, 33.71591], [-117.86257, 33.71591], [-117.86257, 33.715], [-117.86248, 33.71499], [-117.86248, 33.71487], [-117.86359, 33.71488], [-117.86359, 33.71492], [-117.86368, 33.71492]]]} | Restricted Access 2 | 47437 | Monroe Elementary School Field | 31153 | 2308 | Santa Ana Unified School District 816 | Special District 4 | School District 14 | http://www.sausd.us/site/default.aspx?PageID=1 | Special District 4 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 2.918 | Monroe Elementary School Field | 0 | Local Recreation Area 3 | 4 | |
5740 | 5740 | 5739 | {"type": "Polygon", "coordinates": [[[-117.90815, 33.749], [-117.90761, 33.74987], [-117.90711, 33.75063], [-117.9066, 33.75137], [-117.9061, 33.75206], [-117.90563, 33.75177], [-117.9056, 33.75179], [-117.90382, 33.75069], [-117.90435, 33.74984], [-117.90502, 33.75014], [-117.90503, 33.75021], [-117.90483, 33.75055], [-117.90576, 33.75095], [-117.90624, 33.75015], [-117.90651, 33.75028], [-117.90653, 33.75028], [-117.90651, 33.74904], [-117.90667, 33.74904], [-117.90668, 33.74906], [-117.90714, 33.74906], [-117.90715, 33.74901], [-117.90815, 33.749]]]} | Restricted Access 2 | 47438 | Spurgeon Intermediate School Field | 31154 | 2308 | Santa Ana Unified School District 816 | Special District 4 | School District 14 | http://www.sausd.us/site/default.aspx?PageID=1 | Special District 4 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 12.376 | Spurgeon Intermediate School Field | 0 | Local Recreation Area 3 | 4 | |
6328 | 6328 | 6327 | {"type": "Polygon", "coordinates": [[[-117.89836, 33.72183], [-117.8983, 33.72317], [-117.89797, 33.72315], [-117.89796, 33.72316], [-117.89797, 33.72355], [-117.89832, 33.72355], [-117.89835, 33.72428], [-117.8943, 33.72425], [-117.8943, 33.72338], [-117.89435, 33.72295], [-117.89452, 33.72237], [-117.89471, 33.72195], [-117.89481, 33.72179], [-117.89488, 33.72177], [-117.89525, 33.72176], [-117.89683, 33.72176], [-117.897, 33.72177], [-117.89752, 33.72184], [-117.89836, 33.72183]]]} | Restricted Access 2 | 47436 | Valley High School Field | 31152 | 2308 | Santa Ana Unified School District 816 | Special District 4 | School District 14 | http://www.sausd.us/site/default.aspx?PageID=1 | Special District 4 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 24.28 | Valley High School Field | 0 | Local Recreation Area 3 | 4 | |
6335 | 6335 | 6334 | {"type": "Polygon", "coordinates": [[[-117.91058, 33.72179], [-117.91047, 33.72176], [-117.91041, 33.72186], [-117.91048, 33.72189], [-117.91044, 33.72198], [-117.91045, 33.722], [-117.91032, 33.72232], [-117.91024, 33.72234], [-117.91017, 33.72238], [-117.91007, 33.72251], [-117.90997, 33.7225], [-117.90995, 33.72254], [-117.90986, 33.72251], [-117.90986, 33.72247], [-117.90977, 33.72248], [-117.9096, 33.72254], [-117.90953, 33.72264], [-117.90952, 33.72269], [-117.9094, 33.72266], [-117.90937, 33.72271], [-117.90927, 33.7227], [-117.90916, 33.72291], [-117.90914, 33.72327], [-117.90867, 33.72327], [-117.90855, 33.72329], [-117.90838, 33.72335], [-117.90792, 33.72336], [-117.90848, 33.72176], [-117.90871, 33.72179], [-117.90924, 33.72182], [-117.90951, 33.72176], [-117.90978, 33.72154], [-117.90996, 33.72132], [-117.91058, 33.72179]]]} | Restricted Access 2 | 47439 | Hector G. Godinez High School Field | 31155 | 2308 | Santa Ana Unified School District 816 | Special District 4 | School District 14 | http://www.sausd.us/site/default.aspx?PageID=1 | Special District 4 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 6.664 | Hector G. Godinez High School Field | 0 | Local Recreation Area 3 | 4 | |
6341 | 6341 | 6340 | {"type": "Polygon", "coordinates": [[[-117.84173, 33.89423], [-117.83972, 33.89424], [-117.83966, 33.89199], [-117.8408, 33.89197], [-117.84079, 33.89285], [-117.84024, 33.89286], [-117.84024, 33.89331], [-117.84092, 33.89332], [-117.84092, 33.89378], [-117.84123, 33.89378], [-117.84122, 33.89348], [-117.84171, 33.89348], [-117.84173, 33.89423]]]} | Restricted Access 2 | 47441 | Rose Drive Elementary School Recreational Facilities | 31157 | 2410 | Placentia-Yorba Linda Unified School District 833 | Special District 4 | School District 14 | http://www.pylusd.org/ | Special District 4 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | Orange 3 | 7.295 | Rose Drive Elementary School Recreational Facilities | 0 | Local Recreation Area 3 | 4 | |
12783 | 12783 | 12782 | {"type": "Polygon", "coordinates": [[[-117.93489, 33.66312], [-117.93485, 33.66379], [-117.93477, 33.66411], [-117.9345, 33.66461], [-117.93433, 33.66497], [-117.93425, 33.66529], [-117.93426, 33.66553], [-117.93434, 33.66577], [-117.93453, 33.666], [-117.93474, 33.66616], [-117.93478, 33.66862], [-117.92476, 33.6687], [-117.92473, 33.66822], [-117.92475, 33.66793], [-117.92484, 33.66736], [-117.92489, 33.6672], [-117.92497, 33.66701], [-117.92513, 33.66676], [-117.92522, 33.66666], [-117.92542, 33.66648], [-117.92548, 33.66643], [-117.92616, 33.66626], [-117.92641, 33.66623], [-117.92763, 33.666], [-117.92836, 33.66592], [-117.92909, 33.66525], [-117.92957, 33.66396], [-117.92835, 33.66366], [-117.92837, 33.66356], [-117.92773, 33.66339], [-117.92855, 33.66129], [-117.92855, 33.66091], [-117.92852, 33.66079], [-117.92846, 33.66068], [-117.92838, 33.66059], [-117.92826, 33.66047], [-117.92805, 33.66034], [-117.92801, 33.66028], [-117.92781, 33.66029], [-117.92391, 33.65934], [-117.92331, 33.65933], [-117.92288, 33.6595], [-117.9227, 33.65963], [-117.92122, 33.66345], [-117.92117, 33.66352], [-117.92111, 33.6636], [-117.92105, 33.66365], [-117.92095, 33.66369], [-117.92085, 33.6637], [-117.92035, 33.66362], [-117.91985, 33.66334], [-117.91972, 33.66324], [-117.91959, 33.66319], [-117.91947, 33.66318], [-117.91935, 33.6632], [-117.9193, 33.658], [-117.93043, 33.65793], [-117.93046, 33.6587], [-117.9315, 33.65867], [-117.93263, 33.66], [-117.9333, 33.65962], [-117.93389, 33.66032], [-117.93417, 33.66057], [-117.93451, 33.66076], [-117.93473, 33.66086], [-117.93476, 33.66311], [-117.93489, 33.66312]]]} | Restricted Access 2 | 30213 | Golf and Country Club | 33096 | 1071 | Costa Mesa, City of 117 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | Orange 3 | 239.277 | Golf and Country Club | 0 | Local Recreation Area 3 | 4 | |
12857 | 12857 | 12856 | {"type": "Polygon", "coordinates": [[[-117.92663, 33.9084], [-117.92635, 33.90978], [-117.92622, 33.90981], [-117.92598, 33.90991], [-117.92543, 33.90885], [-117.92549, 33.90833], [-117.92663, 33.9084]]]} | Restricted Access 2 | 30308 | Hermosa School Park | 31593 | 1115 | Fullerton, City of 116 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | Orange 3 | 3.279 | Hermosa School 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]);