units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
260 rows where ACCESS_TYP = 2 and AGNCY_TYP = 2 sorted by UNIT_ID
This data as json, copyable, CSV (advanced)
Suggested facets: MNG_AG_LEV, YR_EST, GAP_STS
MNG_AGENCY >30
- Los Angeles, City of 17
- Long Beach, City of 9
- San Diego, City of 8
- Santa Cruz, City of 7
- Modesto, City of 7
- San Jose, City of 6
- Fullerton, City of 5
- Vacaville, City of 5
- Stockton, City of 4
- Mountain View, City of 4
- Roseville, City of 4
- Watsonville, City of 3
- Carlsbad, City of 3
- Pomona, City of 3
- Cerritos, City of 3
- El Segundo, City of 3
- Pasadena, City of 3
- South Pasadena, City of 3
- American Canyon, City of 3
- Sacramento, City of 3
- Oakdale, City of 2
- Fresno, City of 2
- San Francisco, City and County of 2
- California Department of Fish and Wildlife 2
- Santa Barbara, City of 2
- Garden Grove, City of 2
- Glendora, City of 2
- Oceanside, City of 2
- Glendale, City of 2
- Coronado, City of 2
- …
DES_TP >30
- Local Recreation Area 140
- Local Park 60
- Local Conservation Area 12
- Local Other or Unknown 6
- State Conservation Area 2
- 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
- …
MNG_AG_TYP 9
ACCESS_TYP 1
- Restricted Access · 260 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
5056 | 5056 | 5055 | {"type": "Polygon", "coordinates": [[[-117.13499, 32.75509], [-117.13393, 32.75509], [-117.13391, 32.75416], [-117.13499, 32.75415], [-117.13499, 32.75509]]]} | Restricted Access 2 | 46 | San Diego Indoor Soccer Center | 30288 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 6103 | Private Landowner 774 | Private 7 | Other 26 | San Diego 4 | 2.583 | San Diego Indoor Soccer Ctr. | None 416 | |||
15650 | 15650 | 15649 | {"type": "MultiPolygon", "coordinates": [[[[-121.61714, 36.67139], [-121.61624, 36.67188], [-121.61627, 36.67228], [-121.61205, 36.67257], [-121.60965, 36.67074], [-121.60818, 36.6702], [-121.6081, 36.6701], [-121.60753, 36.67042], [-121.60614, 36.66886], [-121.6055, 36.66922], [-121.60452, 36.66831], [-121.60718, 36.6665], [-121.60956, 36.66946], [-121.6102, 36.66988], [-121.61079, 36.66966], [-121.61136, 36.66929], [-121.6109, 36.66843], [-121.61229, 36.66778], [-121.61411, 36.66975], [-121.6152, 36.66916], [-121.61714, 36.67139]]], [[[-121.62255, 36.66852], [-121.62227, 36.66914], [-121.6224, 36.66928], [-121.62156, 36.66977], [-121.62132, 36.66952], [-121.61988, 36.67028], [-121.62003, 36.67047], [-121.61847, 36.67132], [-121.6183, 36.67128], [-121.61768, 36.67164], [-121.61417, 36.66766], [-121.61536, 36.66706], [-121.61478, 36.6664], [-121.61593, 36.66583], [-121.61652, 36.66648], [-121.61725, 36.66613], [-121.61763, 36.66655], [-121.61907, 36.66582], [-121.62035, 36.66562], [-121.62038, 36.66596], [-121.62102, 36.66665], [-121.62149, 36.6684], [-121.62172, 36.66852], [-121.62201, 36.66858], [-121.62255, 36.66852]]]]} | Restricted Access 2 | 268 | Salinas Fairways Golf Course | 32985 | 1291 | Salinas, City of 56 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | Monterey 14 | 145.929 | Salinas Fairways GC | 0 | Local Recreation Area 3 | 4 | |
15652 | 15652 | 15651 | {"type": "Polygon", "coordinates": [[[-117.28127, 33.07733], [-117.28113, 33.07742], [-117.2812, 33.07751], [-117.28126, 33.0776], [-117.28122, 33.07759], [-117.28117, 33.07759], [-117.28101, 33.07767], [-117.28079, 33.07775], [-117.28049, 33.0778], [-117.27999, 33.07785], [-117.27981, 33.07785], [-117.27954, 33.07782], [-117.27921, 33.07775], [-117.27907, 33.0777], [-117.27887, 33.07762], [-117.27868, 33.07752], [-117.27847, 33.07738], [-117.27806, 33.07706], [-117.27777, 33.07676], [-117.27755, 33.07699], [-117.27683, 33.0771], [-117.27543, 33.07714], [-117.27537, 33.0771], [-117.27536, 33.07715], [-117.27528, 33.07707], [-117.27512, 33.07701], [-117.275, 33.07701], [-117.27489, 33.07697], [-117.27485, 33.07693], [-117.27477, 33.07693], [-117.27462, 33.0771], [-117.27461, 33.07716], [-117.27447, 33.07719], [-117.2744, 33.07717], [-117.27431, 33.07721], [-117.27412, 33.07735], [-117.27414, 33.07739], [-117.27395, 33.07748], [-117.27383, 33.07751], [-117.27377, 33.07755], [-117.27375, 33.0777], [-117.27369, 33.07779], [-117.27362, 33.07787], [-117.27344, 33.07789], [-117.27327, 33.07787], [-117.27318, 33.07782], [-117.27313, 33.07775], [-117.2731, 33.07766], [-117.27303, 33.07755], [-117.27303, 33.07747], [-117.27307, 33.07736], [-117.27316, 33.07726], [-117.27309, 33.07701], [-117.27312, 33.07693], [-117.27317, 33.07689], [-117.27332, 33.07686], [-117.2734, 33.07692], [-117.27353, 33.07688], [-117.27355, 33.07684], [-117.27362, 33.0769], [-117.27375, 33.07696], [-117.27389, 33.077], [-117.27397, 33.077], [-117.274, 33.07698], [-117.27402, 33.07691], [-117.27412, 33.07687], [-117.27424, 33.07686], [-117.27428, 33.07683], [-117.27429, 33.07673], [-117.27424, 33.07661], [-117.27445, 33.07661], [-117.27465, 33.07655], [-117.27476, 33.07648], [-117.27478, 33.07651], [-117.27484, 33.07652], [-117.27492, 33.07647], [-117.27493, 33.07644], [-117.27505, 33.07639], [-117.27511, 33.07639], [-117.27527, 33.07631], [-117.27529, 33.07623], [-117.27536, 33.07621], [-117.27538, 33.07616], [-117.27546, 33.07608], [-117.27545, 33.07606], [-117.27539, 33.07607], [-117.2753, 33.07601], [-117.27528, 33.07584], [-117.27515, 33.07582], [-117.27493, 33.07572], [-117.27478, 33.07577], [-117.27469, 33.07578], [-117.27468, 33.0758], [-117.27471, 33.07582], [-117.27465, 33.07588], [-117.2745, 33.07596], [-117.27442, 33.07597], [-117.27433, 33.07603], [-117.27427, 33.07603], [-117.27425, 33.07612], [-117.27402, 33.07611], [-117.27399, 33.07628], [-117.2742, 33.07632], [-117.27418, 33.07636], [-117.27409, 33.0764], [-117.27402, 33.07647], [-117.27397, 33.07647], [-117.274, 33.07643], [-117.27398, 33.07637], [-117.27392, 33.07632], [-117.27392, 33.07615], [-117.274, 33.076], [-117.27409, 33.07593], [-117.27422, 33.07595], [-117.27444, 33.07577], [-117.27444, 33.07564], [-117.27436, 33.07557], [-117.27437, 33.07548], [-117.27448, 33.07527], [-117.27447, 33.07511], [-117.2745, 33.07508], [-117.27448, 33.07501], [-117.27451, 33.07484], [-117.27449, 33.07474], [-117.2745, 33.07469], [-117.27446, 33.07459], [-117.27448, 33.07455], [-117.27446, 33.07441], [-117.2745, 33.07435], [-117.27451, 33.07417], [-117.27455, 33.07407], [-117.27457, 33.07379], [-117.27455, 33.07375], [-117.27472, 33.07359], [-117.27471, 33.07358], [-117.2743, 33.07358], [-117.27436, 33.07356], [-117.27453, 33.07355], [-117.27471, 33.0735], [-117.27492, 33.07356], [-117.27502, 33.07356], [-117.27568, 33.07363], [-117.27583, 33.07362], [-117.27616, 33.07369], [-117.27626, 33.07344], [-117.27611, 33.07339], [-117.27601, 33.07345], [-117.27564, 33.07349], [-117.27554, 33.07346], [-117.2752, 33.07345], [-117.27511, 33.07345], [-117.27505, 33.07348], [-117.27498, 33.07347], [-117.27497, 33.07344], [-117.275, 33.07336], [-117.27484, 33.07331], [-117.27414, 33.07327], [-117.27415, 33.07233], [-117.27332, 33.07232], [-117.27348, 33.07201], [-117.2734, 33.07184], [-117.27328, 33.07169], [-117.27311, 33.07142], [-117.27301, 33.07114], [-117.27299, 33.07086], [-117.27299, 33.07059], [-117.27311, 33.07004], [-117.27328, 33.069], [-117.27336, 33.06887], [-117.27371, 33.06865], [-117.27414, 33.06833], [-117.27425, 33.06821], [-117.27403, 33.06799], [-117.27387, 33.06809], [-117.27353, 33.06828], [-117.27318, 33.06843], [-117.27299, 33.06807], [-117.27241, 33.06761], [-117.27232, 33.06729], [-117.27239, 33.067], [-117.27251, 33.06679], [-117.27376, 33.06567], [-117.27404, 33.06528], [-117.27431, 33.06509], [-117.27505, 33.06466], [-117.27495, 33.06452], [-117.27434, 33.06226], [-117.27434, 33.06213], [-117.27451, 33.06091], [-117.2738, 33.06058], [-117.27372, 33.05965], [-117.2742, 33.0583], [-117.27433, 33.0579], [-117.27468, 33.05752], [-117.27469, 33.05732], [-117.27476, 33.05729], [-117.27506, 33.05724], [-117.27538, 33.05724], [-117.27618, 33.05732], [-117.27658, 33.05731], [-117.27636, 33.06206], [-117.27807, 33.06204], [-117.27864, 33.06209], [-117.27938, 33.06239], [-117.28001, 33.06237], [-117.2801, 33.06245], [-117.28037, 33.06257], [-117.28027, 33.06273], [-117.28011, 33.06289], [-117.2801, 33.06292], [-117.27902, 33.06371], [-117.27885, 33.06386], [-117.27866, 33.0641], [-117.2785, 33.06445], [-117.27845, 33.06463], [-117.27836, 33.06567], [-117.27833, 33.06584], [-117.27826, 33.06603], [-117.27824, 33.06606], [-117.27813, 33.06605], [-117.27812, 33.06607], [-117.27785, 33.06654], [-117.27785, 33.06677], [-117.27672, 33.06872], [-117.27656, 33.06872], [-117.27682, 33.07143], [-117.27661, 33.07143], [-117.27664, 33.07259], [-117.27661, 33.07278], [-117.27657, 33.07293], [-117.27628, 33.07368], [-117.27619, 33.07408], [-117.27619, 33.07442], [-117.27626, 33.07508], [-117.27629, 33.07526], [-117.27718, 33.07519], [-117.27737, 33.07523], [-117.27791, 33.07524], [-117.27891, 33.07545], [-117.2797, 33.07532], [-117.28044, 33.07595], [-117.28045, 33.07622], [-117.28065, 33.0762], [-117.28077, 33.07631], [-117.28072, 33.0766], [-117.28055, 33.07686], [-117.28029, 33.07696], [-117.28049, 33.07732], [-117.28104, 33.07718], [-117.28127, 33.07733]]]} | Restricted Access 2 | 292 | Encinitas Ranch Golf Course | 32986 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | http://www.jcgolf.com/courses-encinitas.php | San Diego 4 | 184.589 | Encinitas Ranch GC | 0 | Local Recreation Area 3 | 4 |
15653 | 15653 | 15652 | {"type": "Polygon", "coordinates": [[[-119.21269, 34.24313], [-119.20754, 34.24185], [-119.2021, 34.23827], [-119.20809, 34.23733], [-119.21234, 34.23694], [-119.21269, 34.24313]]]} | Restricted Access 2 | 300 | San Buenaventura Golf Course | 32987 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 97.146 | San Buenaventura GC | 0 | Local Recreation Area 3 | 4 | |
3214 | 3214 | 3213 | {"type": "Polygon", "coordinates": [[[-122.039, 37.00381], [-122.03783, 37.00449], [-122.03729, 37.00412], [-122.03759, 37.00374], [-122.03715, 37.00342], [-122.03683, 37.00294], [-122.03674, 37.00261], [-122.03807, 37.00344], [-122.039, 37.00381]]]} | Restricted Access 2 | 367 | San Lorenzo River Open Space | 28168 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | Santa Cruz 5 | 3.51 | San Lorenzo River OS | 0 | Local Recreation Area 3 | 4 | |
177 | 177 | 176 | {"type": "Polygon", "coordinates": [[[-119.74164, 34.43295], [-119.74153, 34.43576], [-119.73893, 34.43575], [-119.73887, 34.43693], [-119.73869, 34.43693], [-119.73853, 34.43695], [-119.73837, 34.437], [-119.73822, 34.43708], [-119.73804, 34.43724], [-119.73783, 34.43753], [-119.73766, 34.43766], [-119.73751, 34.43772], [-119.73402, 34.43838], [-119.73394, 34.43798], [-119.73391, 34.43769], [-119.73392, 34.43573], [-119.73369, 34.43572], [-119.73366, 34.43384], [-119.73517, 34.43387], [-119.73518, 34.43141], [-119.73888, 34.43138], [-119.73888, 34.42908], [-119.73969, 34.42935], [-119.74016, 34.42954], [-119.74079, 34.42982], [-119.7407, 34.4325], [-119.74164, 34.43295]]]} | Restricted Access 2 | 492 | Santa Barbara Golf Club | 32988 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | Santa Barbara 7 | 110.039 | Santa Barbara Golf Club | 0 | Local Recreation Area 3 | 4 | |
15654 | 15654 | 15653 | {"type": "MultiPolygon", "coordinates": [[[[-117.09268, 33.16118], [-117.09263, 33.16144], [-117.09239, 33.1623], [-117.09172, 33.16442], [-117.09132, 33.16557], [-117.09126, 33.16559], [-117.09122, 33.16558], [-117.09117, 33.16553], [-117.09112, 33.16552], [-117.09095, 33.1655], [-117.09109, 33.16538], [-117.09084, 33.16498], [-117.09075, 33.16478], [-117.09071, 33.16458], [-117.09071, 33.16438], [-117.09076, 33.16417], [-117.09092, 33.16373], [-117.09086, 33.16352], [-117.09003, 33.16299], [-117.08995, 33.16301], [-117.08984, 33.16316], [-117.0898, 33.16374], [-117.09023, 33.1638], [-117.09023, 33.16386], [-117.0898, 33.1638], [-117.08972, 33.1645], [-117.08977, 33.16477], [-117.08983, 33.16503], [-117.08993, 33.16525], [-117.09006, 33.1655], [-117.09025, 33.1657], [-117.09055, 33.16553], [-117.09067, 33.16561], [-117.09073, 33.16569], [-117.09088, 33.16575], [-117.09098, 33.16581], [-117.09117, 33.16582], [-117.0912, 33.16588], [-117.09069, 33.16732], [-117.09045, 33.16811], [-117.09031, 33.1682], [-117.08999, 33.16812], [-117.08956, 33.1681], [-117.08947, 33.16806], [-117.08938, 33.16805], [-117.08929, 33.16808], [-117.08918, 33.16816], [-117.08894, 33.16826], [-117.08883, 33.16821], [-117.08896, 33.16797], [-117.08906, 33.1677], [-117.08909, 33.16741], [-117.08905, 33.16713], [-117.08871, 33.16584], [-117.08859, 33.16494], [-117.0884, 33.16417], [-117.08837, 33.16359], [-117.08815, 33.16355], [-117.08817, 33.16349], [-117.08816, 33.16345], [-117.08821, 33.16335], [-117.08822, 33.16322], [-117.08826, 33.16313], [-117.08827, 33.16306], [-117.08823, 33.16297], [-117.08815, 33.1629], [-117.08795, 33.16256], [-117.08797, 33.16246], [-117.08897, 33.16188], [-117.0893, 33.16172], [-117.0897, 33.16157], [-117.08991, 33.1615], [-117.09033, 33.1614], [-117.09069, 33.16135], [-117.09263, 33.16112], [-117.09268, 33.16118]]], [[[-117.0949, 33.17091], [-117.09272, 33.17091], [-117.08993, 33.17091], [-117.09066, 33.1685], [-117.0928, 33.1691], [-117.09489, 33.16975], [-117.09493, 33.16981], [-117.09491, 33.16997], [-117.0949, 33.17091]]], [[[-117.09702, 33.17023], [-117.0954, 33.16973], [-117.0954, 33.16968], [-117.09404, 33.16924], [-117.09211, 33.16867], [-117.09084, 33.16831], [-117.09344, 33.16883], [-117.09504, 33.16905], [-117.09539, 33.16912], [-117.09576, 33.16927], [-117.09604, 33.16943], [-117.09629, 33.16963], [-117.09644, 33.16979], [-117.09662, 33.16997], [-117.09679, 33.1701], [-117.09702, 33.17023]]]]} | Restricted Access 2 | 644 | Reidy Creek Golf Course | 31473 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 7017 | JC Resorts 1102 | Private 7 | Commercial 18 | https://www.jcgolf.com/san-diego-golf-courses/reidy-creek/ | San Diego 4 | 70.314 | Reidy Creek GC | None 1366 | ||
6022 | 6022 | 6021 | {"type": "Polygon", "coordinates": [[[-118.06026, 33.87842], [-118.05959, 33.87842], [-118.05956, 33.87688], [-118.06001, 33.87688], [-118.06019, 33.87686], [-118.06024, 33.87689], [-118.06026, 33.87842]]]} | Restricted Access 2 | 729 | Frontier Park | 19131 | 1051 | Cerritos, City of 225 | City 2 | City Agency 2 | http://www.ci.cerritos.ca.us/ | City 2 | 1051 | Cerritos, City of 221 | City 2 | City Agency 2 | Los Angeles 6 | 2.643 | Frontier Park | 0 | Local Park 2 | 4 | |
15651 | 15651 | 15650 | {"type": "Polygon", "coordinates": [[[-117.92866, 33.89741], [-117.92882, 33.89797], [-117.92866, 33.89899], [-117.92858, 33.89939], [-117.9284, 33.89986], [-117.9283, 33.90048], [-117.92833, 33.90094], [-117.92835, 33.90216], [-117.92806, 33.90241], [-117.92794, 33.9026], [-117.92782, 33.90285], [-117.92789, 33.90288], [-117.9279, 33.90291], [-117.92781, 33.90302], [-117.9277, 33.9032], [-117.92761, 33.90344], [-117.92753, 33.90373], [-117.92731, 33.90489], [-117.92713, 33.90576], [-117.92694, 33.90573], [-117.92669, 33.905], [-117.92544, 33.90564], [-117.92569, 33.9054], [-117.92485, 33.90469], [-117.92436, 33.90485], [-117.92358, 33.90507], [-117.92102, 33.90616], [-117.92255, 33.90495], [-117.9231, 33.90426], [-117.92225, 33.90389], [-117.9208, 33.90429], [-117.91838, 33.90369], [-117.91643, 33.90441], [-117.91697, 33.90527], [-117.91723, 33.90563], [-117.91661, 33.906], [-117.91638, 33.9061], [-117.91608, 33.90635], [-117.91599, 33.90644], [-117.91597, 33.90666], [-117.91591, 33.90694], [-117.91599, 33.9071], [-117.91639, 33.90737], [-117.9165, 33.90748], [-117.91741, 33.90864], [-117.91682, 33.90936], [-117.91585, 33.90911], [-117.91587, 33.90892], [-117.91585, 33.9087], [-117.9158, 33.90844], [-117.91565, 33.90813], [-117.91565, 33.90737], [-117.91479, 33.90656], [-117.91478, 33.9065], [-117.91495, 33.90578], [-117.91552, 33.90519], [-117.91512, 33.90406], [-117.914, 33.90357], [-117.91408, 33.90356], [-117.91405, 33.90301], [-117.92042, 33.90291], [-117.92104, 33.9032], [-117.92165, 33.90284], [-117.9233, 33.90281], [-117.92395, 33.90322], [-117.92419, 33.903], [-117.92478, 33.90242], [-117.92545, 33.90204], [-117.92462, 33.90094], [-117.92431, 33.90085], [-117.92499, 33.90051], [-117.92625, 33.90048], [-117.92705, 33.89942], [-117.92638, 33.89873], [-117.92586, 33.89916], [-117.92559, 33.89875], [-117.92565, 33.89751], [-117.92502, 33.89756], [-117.92475, 33.89873], [-117.92401, 33.89851], [-117.92397, 33.89859], [-117.92398, 33.89926], [-117.92302, 33.89914], [-117.92231, 33.89932], [-117.92197, 33.89983], [-117.92155, 33.89925], [-117.92203, 33.89917], [-117.92261, 33.89901], [-117.92316, 33.89878], [-117.92376, 33.89842], [-117.92436, 33.89784], [-117.9253, 33.89671], [-117.92571, 33.89644], [-117.92618, 33.89618], [-117.92651, 33.89606], [-117.92665, 33.89614], [-117.92714, 33.89625], [-117.92701, 33.89671], [-117.92702, 33.89673], [-117.92798, 33.89658], [-117.92793, 33.89672], [-117.92771, 33.89701], [-117.92866, 33.89741]]]} | Restricted Access 2 | 760 | Fullerton Municipal Golf Course | 32990 | 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 | 120.084 | Fullerton Municipal GC | 0 | Local Recreation Area 3 | 4 | |
15655 | 15655 | 15654 | {"type": "Polygon", "coordinates": [[[-117.32632, 33.25209], [-117.32599, 33.25259], [-117.32595, 33.25413], [-117.32564, 33.25449], [-117.3253, 33.25449], [-117.32502, 33.25407], [-117.32483, 33.25434], [-117.32437, 33.25617], [-117.32372, 33.2568], [-117.32395, 33.25745], [-117.32193, 33.25907], [-117.31798, 33.26005], [-117.31696, 33.26056], [-117.31487, 33.26041], [-117.31348, 33.26036], [-117.31397, 33.25707], [-117.31942, 33.2565], [-117.3199, 33.25563], [-117.31963, 33.25565], [-117.31959, 33.25506], [-117.31937, 33.25254], [-117.32113, 33.25252], [-117.32124, 33.25249], [-117.32162, 33.25231], [-117.32184, 33.25219], [-117.32195, 33.2521], [-117.32213, 33.25195], [-117.32242, 33.25164], [-117.32258, 33.25141], [-117.3227, 33.25114], [-117.32271, 33.25071], [-117.32608, 33.2507], [-117.32632, 33.25209]]]} | Restricted Access 2 | 798 | Oceanside Municipal Golf Course | 32991 | 1230 | Oceanside, City of 77 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/ | City 2 | 1230 | Oceanside, City of 75 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/gov/ns/parks/amenities/golf.asp | San Diego 4 | 153.557 | Oceanside Municipal GC | 0 | Local Recreation Area 3 | 4 |
15656 | 15656 | 15655 | {"type": "MultiPolygon", "coordinates": [[[[-117.30136, 33.12431], [-117.30109, 33.12548], [-117.30099, 33.12581], [-117.3009, 33.12606], [-117.30077, 33.1263], [-117.30063, 33.12653], [-117.30041, 33.12683], [-117.30016, 33.1271], [-117.29988, 33.12736], [-117.29943, 33.12767], [-117.29912, 33.12785], [-117.29879, 33.128], [-117.29844, 33.12813], [-117.29799, 33.12825], [-117.29689, 33.12844], [-117.29653, 33.12854], [-117.29611, 33.12871], [-117.29546, 33.12906], [-117.29516, 33.12919], [-117.29485, 33.1293], [-117.29455, 33.12937], [-117.29393, 33.12948], [-117.29388, 33.12931], [-117.29366, 33.12931], [-117.29348, 33.12914], [-117.2928, 33.12894], [-117.29075, 33.12924], [-117.29021, 33.12955], [-117.29004, 33.12945], [-117.28923, 33.12912], [-117.28822, 33.12843], [-117.2879, 33.12839], [-117.29047, 33.12797], [-117.29037, 33.12753], [-117.29114, 33.12727], [-117.29117, 33.12721], [-117.29105, 33.12678], [-117.29103, 33.12657], [-117.29388, 33.12611], [-117.29434, 33.12505], [-117.29475, 33.12451], [-117.29521, 33.12385], [-117.29436, 33.1232], [-117.29415, 33.12299], [-117.29467, 33.12313], [-117.29552, 33.12331], [-117.29988, 33.12403], [-117.30074, 33.12415], [-117.30085, 33.1242], [-117.30129, 33.12426], [-117.30134, 33.12428], [-117.30136, 33.12431]]], [[[-117.30821, 33.12981], [-117.30818, 33.12985], [-117.30818, 33.12992], [-117.30821, 33.13008], [-117.30827, 33.13574], [-117.30791, 33.13835], [-117.30763, 33.13858], [-117.30741, 33.13879], [-117.30725, 33.13898], [-117.3072, 33.139], [-117.30688, 33.13882], [-117.30658, 33.13862], [-117.30647, 33.13853], [-117.30624, 33.13828], [-117.30605, 33.13801], [-117.30591, 33.13774], [-117.30568, 33.13712], [-117.30553, 33.13682], [-117.30542, 33.13664], [-117.30519, 33.13635], [-117.30492, 33.1361], [-117.30461, 33.13589], [-117.30357, 33.13528], [-117.30323, 33.13506], [-117.30163, 33.13361], [-117.30136, 33.1334], [-117.30105, 33.13321], [-117.30081, 33.13309], [-117.30039, 33.13293], [-117.30012, 33.13286], [-117.29975, 33.13279], [-117.29928, 33.13275], [-117.29891, 33.13276], [-117.29836, 33.13285], [-117.29809, 33.13292], [-117.29774, 33.13304], [-117.29674, 33.13352], [-117.29634, 33.13378], [-117.29605, 33.13401], [-117.29585, 33.1342], [-117.29567, 33.1344], [-117.2954, 33.13476], [-117.29519, 33.13514], [-117.29465, 33.13281], [-117.29201, 33.13101], [-117.29222, 33.13079], [-117.29302, 33.13088], [-117.29334, 33.13079], [-117.29375, 33.13063], [-117.29486, 33.13138], [-117.29564, 33.13095], [-117.29622, 33.13071], [-117.29622, 33.13069], [-117.29569, 33.13037], [-117.29544, 33.13028], [-117.29554, 33.12974], [-117.29521, 33.12948], [-117.29563, 33.1293], [-117.29635, 33.12892], [-117.29665, 33.1288], [-117.29689, 33.12873], [-117.29722, 33.12866], [-117.2982, 33.12849], [-117.29851, 33.12841], [-117.29881, 33.1283], [-117.2992, 33.12813], [-117.29957, 33.12794], [-117.29983, 33.12777], [-117.30012, 33.12755], [-117.30045, 33.12725], [-117.30078, 33.12687], [-117.30079, 33.12685], [-117.30095, 33.12665], [-117.30115, 33.12628], [-117.30133, 33.12584], [-117.30159, 33.1248], [-117.30164, 33.12472], [-117.30169, 33.12449], [-117.30173, 33.12437], [-117.3018, 33.12434], [-117.30193, 33.12432], [-117.30244, 33.12435], [-117.30277, 33.12434], [-117.30376, 33.12426], [-117.30415, 33.12421], [-117.30475, 33.12408], [-117.30523, 33.12395], [-117.30593, 33.12373], [-117.306, 33.12376], [-117.30601, 33.12378], [-117.30639, 33.12491], [-117.30643, 33.12505], [-117.30675, 33.12506], [-117.30722, 33.12647], [-117.30727, 33.12686], [-117.30726, 33.12705], [-117.30712, 33.12705], [-117.30698, 33.12724], [-117.30691, 33.12971], [-117.30713, 33.12967], [-117.3082, 33.12935], [-117.30821, 33.12981]]]]} | Restricted Access 2 | 804 | The Crossings Golf Course | 30002 | 1045 | Carlsbad, City of 123 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/default.asp | City 2 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | San Diego 4 | 391.552 | The Crossings GC | 0 | Local Recreation Area 3 | 4 | |
280 | 280 | 279 | {"type": "Polygon", "coordinates": [[[-121.85612, 36.61199], [-121.8561, 36.6123], [-121.85602, 36.6123], [-121.85604, 36.61196], [-121.85607, 36.61194], [-121.85612, 36.61199]]]} | Restricted Access 2 | 956 | South Monterey Dunes | 25664 | 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 | 0.07 | South Monterey Dunes | None 30 | |||
6170 | 6170 | 6169 | {"type": "MultiPolygon", "coordinates": [[[[-119.00412, 36.06444], [-119.00205, 36.06442], [-119.00204, 36.06457], [-119.00206, 36.06564], [-119.00082, 36.06562], [-119.00081, 36.06569], [-118.99981, 36.06569], [-118.99979, 36.0629], [-119.00339, 36.06294], [-119.00388, 36.06365], [-119.00412, 36.06444]]], [[[-119.00453, 36.06712], [-119.00453, 36.06755], [-119.00411, 36.06755], [-119.0041, 36.06711], [-119.00453, 36.06712]]], [[[-119.0045, 36.06776], [-119.0045, 36.06847], [-119.00412, 36.06847], [-119.00412, 36.06776], [-119.0045, 36.06776]]]]} | Restricted Access 2 | 1184 | Murry Park and Porterville Municipal Golf Course | 32995 | 1260 | Porterville, City of 139 | City 2 | City Agency 2 | http://www.ci.porterville.ca.us/ | City 2 | 1260 | Porterville, City of 136 | City 2 | City Agency 2 | Tulare 29 | 22.939 | Murry Park and Porterville Municipal GC | 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 |
8490 | 8490 | 8489 | {"type": "Polygon", "coordinates": [[[-119.38553, 36.32294], [-119.38391, 36.32361], [-119.38313, 36.32419], [-119.38113, 36.32421], [-119.3811, 36.31994], [-119.38099, 36.31272], [-119.38131, 36.31274], [-119.38155, 36.31279], [-119.38178, 36.3129], [-119.38549, 36.31585], [-119.38569, 36.31605], [-119.38727, 36.3181], [-119.38829, 36.31895], [-119.38855, 36.31913], [-119.38879, 36.31924], [-119.38901, 36.31932], [-119.38949, 36.31943], [-119.38976, 36.31954], [-119.39004, 36.31974], [-119.3902, 36.31992], [-119.3903, 36.32009], [-119.39038, 36.32034], [-119.39039, 36.3206], [-119.39036, 36.32078], [-119.3903, 36.32093], [-119.39015, 36.32116], [-119.39001, 36.3213], [-119.38987, 36.32141], [-119.38968, 36.32151], [-119.38952, 36.32157], [-119.38896, 36.3217], [-119.38874, 36.32178], [-119.38849, 36.32193], [-119.38828, 36.32212], [-119.38817, 36.32228], [-119.38808, 36.32248], [-119.3877, 36.32389], [-119.3877, 36.32401], [-119.38774, 36.32416], [-119.38802, 36.32477], [-119.3881, 36.32488], [-119.38818, 36.32496], [-119.38839, 36.32509], [-119.38863, 36.32517], [-119.38891, 36.32519], [-119.38914, 36.32514], [-119.38954, 36.32498], [-119.38967, 36.32496], [-119.38995, 36.32496], [-119.3898, 36.32615], [-119.38881, 36.32651], [-119.3882, 36.32664], [-119.3877, 36.3267], [-119.38715, 36.32673], [-119.38555, 36.32675], [-119.38466, 36.32696], [-119.38131, 36.32696], [-119.38114, 36.32683], [-119.38113, 36.32424], [-119.38315, 36.32421], [-119.38393, 36.32363], [-119.38553, 36.32297], [-119.39037, 36.32063], [-119.39035, 36.32062], [-119.39, 36.32078], [-119.38553, 36.32294]]]} | Restricted Access 2 | 1435 | Valley Oaks Golf Course | 32996 | 1368 | Visalia, City of 156 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | Tulare 29 | 215.293 | Valley Oaks GC | 0 | Local Recreation Area 3 | 4 | |
8645 | 8645 | 8644 | {"type": "Polygon", "coordinates": [[[-119.84198, 34.43602], [-119.84029, 34.43629], [-119.84059, 34.43759], [-119.83711, 34.43794], [-119.8371, 34.43824], [-119.83253, 34.43871], [-119.83248, 34.43844], [-119.83238, 34.43817], [-119.83224, 34.43792], [-119.83216, 34.43781], [-119.83206, 34.4377], [-119.83185, 34.43751], [-119.8314, 34.43726], [-119.83139, 34.43653], [-119.83079, 34.43653], [-119.83079, 34.43627], [-119.83084, 34.43621], [-119.8316, 34.43584], [-119.83163, 34.43585], [-119.83209, 34.43564], [-119.83212, 34.43565], [-119.83313, 34.4352], [-119.83403, 34.43483], [-119.83675, 34.43411], [-119.84127, 34.43296], [-119.84152, 34.43404], [-119.84073, 34.43425], [-119.83908, 34.43451], [-119.83912, 34.43479], [-119.83853, 34.43491], [-119.83884, 34.43629], [-119.84193, 34.4358], [-119.84198, 34.43602]]]} | Restricted Access 2 | 1483 | Twin Lakes Golf Course | 32998 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | Santa Barbara 7 | 81.664 | Twin Lakes GC | 0 | Local Recreation Area 3 | 4 | |
6374 | 6374 | 6373 | {"type": "Polygon", "coordinates": [[[-119.77927, 36.84098], [-119.77927, 36.84288], [-119.77707, 36.84288], [-119.77708, 36.84133], [-119.77769, 36.84134], [-119.77794, 36.84127], [-119.77843, 36.84127], [-119.77869, 36.84135], [-119.77899, 36.84134], [-119.77918, 36.84111], [-119.77919, 36.84097], [-119.77927, 36.84098]]]} | Restricted Access 2 | 1738 | Harry Goorabian Park | 31253 | 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 | 8.566 | Harry Goorabian Park | 0 | Local Park 2 | 4 | |
2946 | 2946 | 2945 | {"type": "Polygon", "coordinates": [[[-118.43139, 34.07349], [-118.43133, 34.0739], [-118.43131, 34.07413], [-118.43128, 34.07416], [-118.43123, 34.07417], [-118.4312, 34.07415], [-118.43081, 34.0738], [-118.4306, 34.07366], [-118.4303, 34.07352], [-118.42983, 34.0734], [-118.42965, 34.0733], [-118.4295, 34.07319], [-118.42916, 34.07276], [-118.42892, 34.07255], [-118.42767, 34.07171], [-118.42764, 34.07166], [-118.42764, 34.0716], [-118.4278, 34.0712], [-118.42784, 34.07119], [-118.42921, 34.07171], [-118.42952, 34.07187], [-118.42979, 34.07208], [-118.43009, 34.07242], [-118.43027, 34.0726], [-118.43138, 34.07347], [-118.43139, 34.07349]]]} | Restricted Access 2 | 1906 | Holmby Park | 32999 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 8.535 | Holmby 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]);