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 rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, AGNCY_TYP, LAYER, 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
- …
YR_EST 18 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17051 | 17051 | 17050 | {"type": "Polygon", "coordinates": [[[-117.74578, 34.02877], [-117.74542, 34.02878], [-117.74539, 34.02875], [-117.74539, 34.02862], [-117.74577, 34.02861], [-117.74578, 34.02877]]]} | Restricted Access 2 | 46518 | Renacimiento Community Center | 29805 | 1258 | Pomona, City of 128 | City 2 | City Agency 2 | http://ci.pomona.ca.us/index.php/visitors/park-directory | City 2 | 1258 | Pomona, City of 125 | City 2 | City Agency 2 | http://www.ci.pomona.ca.us/index.php/contact-us-home/contact-community-services/81-renacimiento-community-center | Los Angeles 6 | 0.157 | Renacimiento Community Ctr. | 0 | Local Recreation Area 3 | 4 |
17050 | 17050 | 17049 | {"type": "MultiPolygon", "coordinates": [[[[-118.07661, 34.66475], [-118.07606, 34.66475], [-118.07502, 34.66449], [-118.07376, 34.66452], [-118.07375, 34.66468], [-118.06801, 34.66468], [-118.06796, 34.66371], [-118.06794, 34.66087], [-118.06803, 34.66079], [-118.07648, 34.66082], [-118.07657, 34.66089], [-118.07661, 34.66475]]], [[[-118.08351, 34.66425], [-118.07694, 34.66429], [-118.07691, 34.66192], [-118.07694, 34.66159], [-118.07694, 34.6609], [-118.07703, 34.66082], [-118.08342, 34.66077], [-118.08345, 34.66335], [-118.08351, 34.66425]]]]} | Restricted Access 2 | 46506 | Lancaster National Soccer Center | 29790 | 1169 | Lancaster, City of 11 | City 2 | City Agency 2 | http://www.cityoflancasterca.org/index.aspx?page=23 | City 2 | 1169 | Lancaster, City of 11 | City 2 | City Agency 2 | Los Angeles 6 | 140.153 | Lancaster Nat. Soccer Ctr. | 0 | Local Recreation Area 3 | 4 | |
17049 | 17049 | 17048 | {"type": "Polygon", "coordinates": [[[-118.10867, 34.09787], [-118.1084, 34.09799], [-118.10834, 34.09808], [-118.10827, 34.09805], [-118.10823, 34.0981], [-118.10818, 34.09809], [-118.10813, 34.09816], [-118.10801, 34.09811], [-118.1084, 34.09743], [-118.10867, 34.09787]]]} | Restricted Access 2 | 46476 | Grapevine Arbor Park and Adult Recreation Center | 29751 | 1301 | San Gabriel, City of 740 | City 2 | City Agency 2 | http://www.sangabrielcity.com/ | City 2 | 1301 | San Gabriel, City of 725 | City 2 | City Agency 2 | Los Angeles 6 | 0.517 | Grapevine Arbor Park and Adult Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
17042 | 17042 | 17041 | {"type": "Polygon", "coordinates": [[[-118.37326, 34.27372], [-118.36895, 34.2735], [-118.36894, 34.27339], [-118.36827, 34.27335], [-118.3682, 34.27332], [-118.3682, 34.27247], [-118.36822, 34.27225], [-118.36828, 34.2722], [-118.36834, 34.27218], [-118.36839, 34.27207], [-118.36845, 34.27199], [-118.36856, 34.2719], [-118.36875, 34.27177], [-118.36887, 34.27172], [-118.36924, 34.27164], [-118.36933, 34.27158], [-118.36934, 34.27154], [-118.36933, 34.27138], [-118.36919, 34.27127], [-118.3688, 34.27111], [-118.36873, 34.27105], [-118.36865, 34.27091], [-118.36862, 34.27081], [-118.36862, 34.27071], [-118.36868, 34.27055], [-118.36874, 34.27046], [-118.36878, 34.27038], [-118.36881, 34.2701], [-118.36881, 34.26999], [-118.36876, 34.26986], [-118.36871, 34.26981], [-118.36861, 34.26974], [-118.36851, 34.26964], [-118.36848, 34.26958], [-118.36848, 34.26953], [-118.36828, 34.26945], [-118.36821, 34.26921], [-118.36819, 34.269], [-118.3725, 34.26887], [-118.3728, 34.26881], [-118.37297, 34.26886], [-118.37307, 34.26895], [-118.37311, 34.26911], [-118.3728, 34.27074], [-118.37326, 34.27372]]]} | Restricted Access 2 | 47236 | Hansen Dam Equestrian Center | 30949 | 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 | http://hansendamhorsecenter.com/ | Los Angeles 6 | 52.323 | Hansen Dam Equestrian Ctr. | 0 | Local Recreation Area 3 | 4 |
17040 | 17040 | 17039 | {"type": "MultiPolygon", "coordinates": [[[[-117.45663, 33.95565], [-117.45632, 33.95587], [-117.45598, 33.95604], [-117.45559, 33.95619], [-117.45518, 33.95628], [-117.4551, 33.95629], [-117.45398, 33.95629], [-117.45397, 33.95621], [-117.45293, 33.95622], [-117.4533, 33.95591], [-117.45356, 33.9556], [-117.45389, 33.95566], [-117.45399, 33.95566], [-117.45399, 33.95458], [-117.45538, 33.95457], [-117.45593, 33.95505], [-117.45662, 33.95554], [-117.45663, 33.95565]]], [[[-117.46118, 33.95825], [-117.45644, 33.9549], [-117.45602, 33.95457], [-117.45558, 33.95416], [-117.45532, 33.95387], [-117.45508, 33.95357], [-117.45486, 33.95325], [-117.45468, 33.95293], [-117.45472, 33.95285], [-117.45507, 33.95274], [-117.45536, 33.95269], [-117.45743, 33.95268], [-117.45803, 33.95369], [-117.45885, 33.95382], [-117.46023, 33.95608], [-117.46069, 33.95728], [-117.46071, 33.95727], [-117.46062, 33.95703], [-117.46072, 33.95701], [-117.46118, 33.95825]]]]} | Restricted Access 2 | 30001 | Van Buren Golf Center | 33095 | 1279 | Riverside, City of 189 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | Riverside 10 | 41.11 | Van Buren Golf Ctr. | 0 | Local Recreation Area 3 | 4 | |
16999 | 16999 | 16998 | {"type": "Polygon", "coordinates": [[[-117.08636, 32.67074], [-117.08572, 32.67093], [-117.08582, 32.67118], [-117.08573, 32.67122], [-117.08603, 32.67197], [-117.08511, 32.67223], [-117.08447, 32.67064], [-117.0844, 32.67041], [-117.08492, 32.67018], [-117.08489, 32.67002], [-117.08482, 32.66984], [-117.08427, 32.66905], [-117.08443, 32.66849], [-117.08422, 32.66785], [-117.08404, 32.66769], [-117.08384, 32.66761], [-117.08371, 32.6675], [-117.08355, 32.66707], [-117.08333, 32.66713], [-117.08273, 32.66557], [-117.08427, 32.66427], [-117.08404, 32.66366], [-117.0844, 32.66355], [-117.08441, 32.66354], [-117.08422, 32.66306], [-117.08384, 32.66316], [-117.08331, 32.66173], [-117.08333, 32.66158], [-117.08332, 32.66141], [-117.08338, 32.66155], [-117.08402, 32.66148], [-117.08389, 32.66116], [-117.08432, 32.66108], [-117.08434, 32.66111], [-117.08484, 32.66105], [-117.08498, 32.6614], [-117.08472, 32.66148], [-117.08523, 32.66214], [-117.08519, 32.66216], [-117.08526, 32.66235], [-117.08537, 32.66232], [-117.08551, 32.66251], [-117.08534, 32.66256], [-117.08548, 32.66294], [-117.08587, 32.66283], [-117.08605, 32.66334], [-117.0857, 32.66314], [-117.08558, 32.66317], [-117.0855, 32.66323], [-117.08543, 32.66339], [-117.08537, 32.66373], [-117.08519, 32.66397], [-117.08517, 32.66406], [-117.08518, 32.66425], [-117.08503, 32.66473], [-117.08481, 32.66525], [-117.08482, 32.66527], [-117.0849, 32.66524], [-117.08476, 32.66557], [-117.08586, 32.66839], [-117.08577, 32.66839], [-117.0856, 32.66846], [-117.08555, 32.6685], [-117.08549, 32.6686], [-117.08548, 32.66869], [-117.08549, 32.66885], [-117.08552, 32.66896], [-117.0857, 32.66942], [-117.08582, 32.66962], [-117.08586, 32.66983], [-117.08587, 32.6701], [-117.08584, 32.67017], [-117.08573, 32.67028], [-117.08567, 32.67029], [-117.08566, 32.67031], [-117.08576, 32.67055], [-117.08624, 32.67042], [-117.08636, 32.67074]]]} | Restricted Access 2 | 47891 | National City Golf Course | 31838 | 1219 | National City, City of 51 | City 2 | City Agency 2 | http://www.ci.national-city.ca.us/index.aspx?page=152 | City 2 | 1219 | National City, City of 49 | City 2 | City Agency 2 | San Diego 4 | 41.144 | Nat. City GC | 0 | Local Recreation Area 3 | 4 | |
16985 | 16985 | 16984 | {"type": "Polygon", "coordinates": [[[-118.00244, 34.14964], [-118.00161, 34.14965], [-118.0016, 34.14922], [-118.00243, 34.14921], [-118.00244, 34.14964]]]} | Restricted Access 2 | 47856 | Monrovia Community Center | 31802 | 1209 | Monrovia, City of 312 | City 2 | City Agency 2 | http://www.cityofmonrovia.org/publicworks/page/parks | City 2 | 1209 | Monrovia, City of 309 | City 2 | City Agency 2 | https://www.cityofmonrovia.org/Home/Components/FacilityDirectory/FacilityDirectory/2/548 | Los Angeles 6 | 0.898 | Monrovia Community Ctr. | 0 | Local Recreation Area 3 | 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 | |
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 | |
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 |
16194 | 16194 | 16193 | {"type": "Polygon", "coordinates": [[[-117.83355, 34.08758], [-117.83349, 34.08776], [-117.83351, 34.08798], [-117.83313, 34.08799], [-117.83269, 34.08803], [-117.83225, 34.08809], [-117.83181, 34.08819], [-117.83139, 34.08831], [-117.83098, 34.08845], [-117.83059, 34.08863], [-117.83024, 34.08881], [-117.82997, 34.08875], [-117.82981, 34.08893], [-117.82968, 34.08891], [-117.82925, 34.08877], [-117.82931, 34.08857], [-117.82933, 34.08826], [-117.83341, 34.08717], [-117.83355, 34.08758]]]} | Restricted Access 2 | 29519 | Walnut Creek Habitat & Open Space | 27224 | 1298 | San Dimas, City of 237 | City 2 | City Agency 2 | http://www.cityofsandimas.com/ps.parksrecreation.cfm?ID=2157 | City 2 | 1298 | San Dimas, City of 233 | City 2 | City Agency 2 | Los Angeles 6 | 7.17 | Walnut Creek Habitat & OS | 0 | Local Recreation Area 3 | 4 | |
16190 | 16190 | 16189 | {"type": "Polygon", "coordinates": [[[-122.07441, 38.2671], [-122.07432, 38.26712], [-122.07414, 38.26795], [-122.07374, 38.26798], [-122.07347, 38.2683], [-122.07341, 38.26849], [-122.07314, 38.26846], [-122.07313, 38.26825], [-122.07257, 38.26801], [-122.0722, 38.26781], [-122.07206, 38.26811], [-122.07198, 38.26848], [-122.07166, 38.26846], [-122.07073, 38.2676], [-122.07082, 38.26741], [-122.0699, 38.26709], [-122.06978, 38.26736], [-122.06967, 38.26749], [-122.06963, 38.26774], [-122.06984, 38.26789], [-122.06993, 38.26838], [-122.07034, 38.26877], [-122.06881, 38.26882], [-122.06879, 38.26881], [-122.06831, 38.26887], [-122.06813, 38.26805], [-122.06893, 38.26793], [-122.06894, 38.26789], [-122.06912, 38.26784], [-122.06927, 38.26732], [-122.06918, 38.26687], [-122.06911, 38.26677], [-122.06925, 38.26673], [-122.06995, 38.2666], [-122.07006, 38.26643], [-122.07042, 38.26639], [-122.07077, 38.26616], [-122.07043, 38.2659], [-122.07087, 38.2659], [-122.07109, 38.26574], [-122.07267, 38.26569], [-122.07292, 38.26616], [-122.07349, 38.26677], [-122.07396, 38.26677], [-122.07441, 38.2671]]]} | Restricted Access 2 | 29160 | Spyglass Open Space | 25758 | 1105 | Fairfield, City of 208 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | Solano 26 | 24.304 | Spyglass OS | 0 | Local Recreation Area 3 | 4 | |
16189 | 16189 | 16188 | {"type": "MultiPolygon", "coordinates": [[[[-122.03412, 37.11263], [-122.03141, 37.11264], [-122.025, 37.11282], [-122.025, 37.10683], [-122.02315, 37.1068], [-122.02315, 37.10572], [-122.02271, 37.10572], [-122.02314, 37.10563], [-122.0235, 37.1056], [-122.02383, 37.10552], [-122.02415, 37.10539], [-122.02472, 37.10509], [-122.02486, 37.105], [-122.025, 37.10493], [-122.025, 37.1065], [-122.02567, 37.10651], [-122.02568, 37.10491], [-122.02585, 37.10495], [-122.02607, 37.10497], [-122.02641, 37.10496], [-122.02672, 37.1049], [-122.02706, 37.10479], [-122.02747, 37.10473], [-122.02789, 37.10461], [-122.02828, 37.10445], [-122.02887, 37.10426], [-122.02924, 37.10409], [-122.0296, 37.10391], [-122.03009, 37.10359], [-122.0304, 37.10336], [-122.03068, 37.1031], [-122.03257, 37.10162], [-122.03253, 37.10192], [-122.03283, 37.10195], [-122.03284, 37.10209], [-122.0332, 37.10212], [-122.03321, 37.1021], [-122.03338, 37.1021], [-122.03341, 37.10276], [-122.03379, 37.10248], [-122.03412, 37.11263]]], [[[-122.0376, 37.0972], [-122.03743, 37.09732], [-122.03725, 37.09741], [-122.03678, 37.09759], [-122.03659, 37.09769], [-122.03641, 37.0978], [-122.03607, 37.09807], [-122.03589, 37.09819], [-122.03554, 37.09835], [-122.03554, 37.09836], [-122.03558, 37.09837], [-122.03584, 37.09856], [-122.03556, 37.09892], [-122.03561, 37.09909], [-122.03592, 37.09925], [-122.03595, 37.09929], [-122.03596, 37.09934], [-122.03591, 37.09949], [-122.03588, 37.09953], [-122.03567, 37.09965], [-122.03551, 37.09977], [-122.03547, 37.09983], [-122.03543, 37.09992], [-122.03537, 37.09992], [-122.03512, 37.09976], [-122.03491, 37.0997], [-122.03469, 37.0997], [-122.03448, 37.09976], [-122.03435, 37.09982], [-122.03421, 37.09996], [-122.03415, 37.10005], [-122.03402, 37.10041], [-122.03393, 37.10055], [-122.03378, 37.10067], [-122.03368, 37.10074], [-122.03363, 37.10074], [-122.03351, 37.10062], [-122.0335, 37.10055], [-122.03362, 37.10039], [-122.03367, 37.1003], [-122.03396, 37.09952], [-122.03405, 37.09947], [-122.03408, 37.0994], [-122.03407, 37.09934], [-122.03401, 37.09928], [-122.03393, 37.09926], [-122.03382, 37.09928], [-122.03379, 37.09931], [-122.03375, 37.09936], [-122.03376, 37.09943], [-122.03379, 37.09948], [-122.03351, 37.10024], [-122.03344, 37.10037], [-122.03334, 37.10049], [-122.03339, 37.10072], [-122.03347, 37.10082], [-122.03345, 37.10087], [-122.03245, 37.10152], [-122.03054, 37.10302], [-122.03012, 37.10339], [-122.02965, 37.10372], [-122.02931, 37.10392], [-122.02895, 37.1041], [-122.02791, 37.1045], [-122.02746, 37.10464], [-122.02695, 37.10473], [-122.02662, 37.10483], [-122.02642, 37.10487], [-122.0262, 37.10488], [-122.02599, 37.10487], [-122.02561, 37.10479], [-122.02543, 37.10477], [-122.02525, 37.10478], [-122.02508, 37.10481], [-122.02484, 37.1049], [-122.02408, 37.10532], [-122.02375, 37.10545], [-122.0235, 37.10551], [-122.02298, 37.10556], [-122.02269, 37.10563], [-122.0224, 37.10572], [-122.02196, 37.10573], [-122.02195, 37.10605], [-122.0214, 37.10589], [-122.02127, 37.10584], [-122.02097, 37.10566], [-122.02086, 37.10562], [-122.02063, 37.1056], [-122.02018, 37.1056], [-122.01991, 37.10557], [-122.01981, 37.10595], [-122.02156, 37.10626], [-122.0215, 37.10635], [-122.02145, 37.10649], [-122.02143, 37.10664], [-122.02144, 37.10679], [-122.01965, 37.10647], [-122.01974, 37.10615], [-122.01911, 37.10603], [-122.01929, 37.10539], [-122.01866, 37.10516], [-122.01787, 37.1048], [-122.01724, 37.10458], [-122.01728, 37.11272], [-122.01728, 37.11634], [-122.01459, 37.11635], [-122.01457, 37.11701], [-122.01379, 37.11711], [-122.01362, 37.11674], [-122.01332, 37.11662], [-122.01286, 37.1168], [-122.01284, 37.10923], [-122.00835, 37.10924], [-122.00834, 37.10574], [-122.00384, 37.10577], [-122.00383, 37.10253], [-122.00344, 37.10249], [-122.00307, 37.1024], [-122.00274, 37.10225], [-122.00242, 37.10203], [-122.00218, 37.1019], [-122.00193, 37.10179], [-122.00166, 37.10171], [-121.99945, 37.10136], [-121.99945, 37.10078], [-122.00192, 37.1012], [-122.00218, 37.10128], [-122.00243, 37.10139], [-122.00265, 37.10151], [-122.00297, 37.10172], [-122.0032, 37.10183], [-122.00357, 37.10195], [-122.00382, 37.10199], [-122.00381, 37.09871], [-122.0221, 37.09857], [-122.02796, 37.09839], [-122.03088, 37.09826], [-122.0355, 37.09806], [-122.03574, 37.09804], [-122.03606, 37.09778], [-122.03624, 37.09767], [-122.03643, 37.09757], [-122.03679, 37.09743], [-122.03688, 37.09737], [-122.03704, 37.09725], [-122.03725, 37.09704], [-122.0376, 37.0972]], [[-122.03515, 37.09946], [-122.03518, 37.09946], [-122.03552, 37.09906], [-122.03525, 37.09882], [-122.03478, 37.09918], [-122.03474, 37.09939], [-122.03475, 37.0994], [-122.03515, 37.09946]]], [[[-122.01457, 37.1176], [-122.01457, 37.11826], [-122.01437, 37.11823], [-122.01397, 37.11823], [-122.01396, 37.11757], [-122.01457, 37.1176]]], [[[-122.01986, 37.11813], [-122.0196, 37.11843], [-122.01941, 37.11852], [-122.01883, 37.11796], [-122.01887, 37.11764], [-122.01939, 37.11747], [-122.01929, 37.11735], [-122.01923, 37.11643], [-122.01936, 37.11642], [-122.01945, 37.11702], [-122.01948, 37.11716], [-122.01959, 37.11736], [-122.01982, 37.11763], [-122.01989, 37.11792], [-122.01986, 37.11813]]], [[[-122.01673, 37.11835], [-122.01646, 37.11894], [-122.01617, 37.11923], [-122.01564, 37.11929], [-122.01562, 37.11925], [-122.01495, 37.11847], [-122.01499, 37.11832], [-122.01533, 37.1184], [-122.01564, 37.11832], [-122.01647, 37.1182], [-122.01673, 37.11835]]], [[[-122.01728, 37.11983], [-122.01727, 37.12336], [-122.01286, 37.12339], [-122.01286, 37.12153], [-122.01288, 37.11965], [-122.01368, 37.12025], [-122.01402, 37.12055], [-122.01421, 37.12062], [-122.01456, 37.12059], [-122.01473, 37.12059], [-122.01523, 37.12038], [-122.01532, 37.12016], [-122.01554, 37.12001], [-122.01572, 37.11981], [-122.0159, 37.11972], [-122.01625, 37.11979], [-122.01632, 37.12002], [-122.01643, 37.12019], [-122.01668, 37.12015], [-122.01696, 37.11987], [-122.01728, 37.11983]]]]} | Restricted Access 2 | 28268 | City of Santa Cruz Open Space | 17334 | 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 | 884.796 | City of Santa Cruz OS | 0 | Local Recreation Area 3 | 4 | |
16120 | 16120 | 16119 | {"type": "Polygon", "coordinates": [[[-121.92213, 37.72774], [-121.91472, 37.72954], [-121.91488, 37.72937], [-121.91489, 37.72922], [-121.91462, 37.72896], [-121.91451, 37.72879], [-121.91451, 37.72865], [-121.9149, 37.72797], [-121.91497, 37.72771], [-121.91501, 37.72711], [-121.91481, 37.72653], [-121.915, 37.72565], [-121.91513, 37.72526], [-121.91498, 37.72457], [-121.91456, 37.72423], [-121.91415, 37.7233], [-121.91374, 37.72189], [-121.91326, 37.72198], [-121.9128, 37.72245], [-121.91233, 37.72278], [-121.91233, 37.72332], [-121.91214, 37.72362], [-121.91188, 37.72395], [-121.91156, 37.72358], [-121.91177, 37.72344], [-121.91179, 37.72307], [-121.91174, 37.72271], [-121.91185, 37.72236], [-121.91216, 37.72214], [-121.91265, 37.72189], [-121.91302, 37.72152], [-121.91319, 37.72097], [-121.91346, 37.7208], [-121.91356, 37.72071], [-121.91361, 37.72053], [-121.91358, 37.72035], [-121.91349, 37.72024], [-121.91343, 37.72013], [-121.91345, 37.71951], [-121.9134, 37.71937], [-121.91329, 37.71923], [-121.91287, 37.71888], [-121.91262, 37.71854], [-121.9137, 37.71795], [-121.9139, 37.71816], [-121.91466, 37.71777], [-121.91504, 37.71766], [-121.91517, 37.71767], [-121.91618, 37.71882], [-121.91644, 37.71908], [-121.917, 37.71972], [-121.91727, 37.71981], [-121.91753, 37.71983], [-121.91812, 37.71962], [-121.91828, 37.71985], [-121.91834, 37.72002], [-121.91838, 37.72017], [-121.9184, 37.72037], [-121.91834, 37.7204], [-121.91767, 37.7204], [-121.91749, 37.72045], [-121.91729, 37.72056], [-121.91716, 37.72077], [-121.9171, 37.72119], [-121.91704, 37.72176], [-121.91669, 37.72177], [-121.91673, 37.72213], [-121.917, 37.72295], [-121.91741, 37.72286], [-121.91751, 37.72289], [-121.91824, 37.72275], [-121.91853, 37.72271], [-121.91862, 37.72271], [-121.91867, 37.72277], [-121.91888, 37.72346], [-121.91892, 37.72364], [-121.91838, 37.72378], [-121.91789, 37.72403], [-121.91756, 37.72435], [-121.9175, 37.72472], [-121.91779, 37.7252], [-121.91837, 37.7258], [-121.91866, 37.72598], [-121.91901, 37.72603], [-121.92001, 37.72582], [-121.92029, 37.72562], [-121.921, 37.72617], [-121.92148, 37.72667], [-121.92199, 37.72731], [-121.92213, 37.72774]]]} | Restricted Access 2 | 15770 | Dougherty Hills Open Space | 18241 | 1090 | Dublin, City of 164 | City 2 | City Agency 2 | http://www.ci.dublin.ca.us/index.aspx?nid=1458 | City 2 | 1090 | Dublin, City of 160 | City 2 | City Agency 2 | Alameda 17 | 116.934 | Dougherty Hills OS | 1989 | Local Recreation Area 3 | 4 | |
16030 | 16030 | 16029 | {"type": "Polygon", "coordinates": [[[-122.46262, 37.88628], [-122.46194, 37.88753], [-122.46228, 37.88826], [-122.46203, 37.88883], [-122.46196, 37.88881], [-122.4622, 37.88825], [-122.46187, 37.88752], [-122.46244, 37.88647], [-122.46247, 37.88632], [-122.46244, 37.88621], [-122.46238, 37.88612], [-122.46202, 37.88574], [-122.46178, 37.88559], [-122.46163, 37.88555], [-122.46145, 37.88555], [-122.46137, 37.88558], [-122.46098, 37.88576], [-122.46088, 37.88583], [-122.4608, 37.88591], [-122.46058, 37.88632], [-122.45992, 37.8867], [-122.45884, 37.88729], [-122.45859, 37.88716], [-122.45997, 37.88649], [-122.46005, 37.88643], [-122.4601, 37.88635], [-122.46014, 37.88627], [-122.46014, 37.88621], [-122.46013, 37.88612], [-122.46006, 37.88601], [-122.45998, 37.88594], [-122.45989, 37.8859], [-122.45976, 37.88587], [-122.4593, 37.88584], [-122.45902, 37.88578], [-122.45852, 37.88564], [-122.45852, 37.8856], [-122.45892, 37.88563], [-122.45893, 37.88562], [-122.45892, 37.88559], [-122.45949, 37.88556], [-122.45993, 37.88558], [-122.46045, 37.88565], [-122.46068, 37.88563], [-122.4609, 37.88557], [-122.46112, 37.88544], [-122.46123, 37.88533], [-122.46127, 37.88526], [-122.46129, 37.88515], [-122.46128, 37.88503], [-122.46124, 37.88493], [-122.46116, 37.88484], [-122.46106, 37.88476], [-122.46088, 37.88466], [-122.46073, 37.8846], [-122.46025, 37.8845], [-122.46002, 37.88441], [-122.45985, 37.88429], [-122.45966, 37.88409], [-122.45902, 37.88413], [-122.4589, 37.88426], [-122.45871, 37.88418], [-122.45883, 37.88394], [-122.45949, 37.88386], [-122.45929, 37.88352], [-122.45912, 37.8832], [-122.45898, 37.88287], [-122.46164, 37.88514], [-122.4616, 37.88539], [-122.46206, 37.8857], [-122.46262, 37.88628]]]} | Restricted Access 2 | 5233 | Marinero Owner's Association Open Space Areas | 21856 | 1348 | Tiburon, Town of 486 | City 2 | City Agency 2 | http://www.ci.tiburon.ca.us/ | City 2 | 1348 | Tiburon, Town of 477 | City 2 | City Agency 2 | Marin 23 | 6.995 | Marinero Owner's Association OS Areas | None 1375 | |||
15931 | 15931 | 15930 | {"type": "Polygon", "coordinates": [[[-122.24262, 38.17617], [-122.23981, 38.17895], [-122.23986, 38.1792], [-122.23953, 38.1794], [-122.23943, 38.17962], [-122.23897, 38.17977], [-122.2389, 38.17988], [-122.23875, 38.17999], [-122.23878, 38.18009], [-122.2392, 38.18056], [-122.23904, 38.18081], [-122.23904, 38.18115], [-122.23881, 38.18129], [-122.23872, 38.18153], [-122.23844, 38.18154], [-122.23842, 38.18192], [-122.2382, 38.18229], [-122.23791, 38.18226], [-122.23767, 38.18233], [-122.23754, 38.18257], [-122.23737, 38.18259], [-122.23706, 38.18241], [-122.23686, 38.18239], [-122.23663, 38.18253], [-122.23375, 38.18254], [-122.23285, 38.18565], [-122.22446, 38.18414], [-122.22153, 38.19229], [-122.21829, 38.19216], [-122.21145, 38.19203], [-122.20969, 38.18989], [-122.21593, 38.18833], [-122.21327, 38.18417], [-122.21376, 38.1835], [-122.21378, 38.18328], [-122.21374, 38.18232], [-122.21527, 38.1799], [-122.21507, 38.17952], [-122.21507, 38.17936], [-122.21492, 38.17912], [-122.21474, 38.1789], [-122.21463, 38.17869], [-122.21238, 38.17684], [-122.21152, 38.17477], [-122.21073, 38.1741], [-122.2161, 38.17414], [-122.22476, 38.17401], [-122.22389, 38.17619], [-122.22808, 38.17781], [-122.22869, 38.17795], [-122.23028, 38.17837], [-122.23138, 38.1786], [-122.2334, 38.17948], [-122.23328, 38.17976], [-122.23328, 38.17977], [-122.23699, 38.18098], [-122.24253, 38.1755], [-122.24262, 38.17617]]]} | Restricted Access 2 | 34999 | Newell Open Space Preserve | 22722 | 1005 | American Canyon, City of 434 | City 2 | City Agency 2 | http://cityofamericancanyon.org/city-departments/parks-recreation | City 2 | 1005 | American Canyon, City of 428 | City 2 | City Agency 2 | Napa 11 | 639.436 | Newell OSP | 0 | Local Conservation Area 4 | 2 | |
15728 | 15728 | 15727 | {"type": "Polygon", "coordinates": [[[-118.15633, 33.9544], [-118.15556, 33.95835], [-118.15532, 33.95831], [-118.15543, 33.95776], [-118.15531, 33.95757], [-118.15526, 33.95754], [-118.15527, 33.9572], [-118.15505, 33.95697], [-118.15296, 33.95675], [-118.15268, 33.95647], [-118.15483, 33.95531], [-118.15633, 33.9544]]]} | Restricted Access 2 | 46197 | Bell Gardens Golf Course at Ford Park | 33117 | 1023 | Bell Gardens, City of 226 | City 2 | City Agency 2 | http://www.bellgardens.org/GOVERNMENT/CityDepartments/RecreationCommunityServices/ParksandFacilities.aspx | City 2 | 1023 | Bell Gardens, City of 222 | City 2 | City Agency 2 | Los Angeles 6 | 12.793 | Bell Gardens GC at Ford Park | 0 | Local Park 2 | 4 | |
15727 | 15727 | 15726 | {"type": "Polygon", "coordinates": [[[-118.17436, 34.1834], [-118.17431, 34.1834], [-118.17301, 34.18282], [-118.17291, 34.18254], [-118.17283, 34.18244], [-118.17273, 34.18235], [-118.17215, 34.18199], [-118.1718, 34.18194], [-118.17174, 34.18191], [-118.17206, 34.18149], [-118.17211, 34.18112], [-118.17243, 34.18106], [-118.1725, 34.18065], [-118.17248, 34.1804], [-118.17237, 34.18021], [-118.17204, 34.18005], [-118.17168, 34.1796], [-118.17145, 34.17966], [-118.17108, 34.17965], [-118.17031, 34.17951], [-118.17015, 34.17919], [-118.17008, 34.17898], [-118.17006, 34.17881], [-118.17008, 34.17861], [-118.17012, 34.17851], [-118.17025, 34.1783], [-118.17049, 34.17802], [-118.17066, 34.17777], [-118.17073, 34.17761], [-118.17076, 34.17745], [-118.17038, 34.17753], [-118.17042, 34.17743], [-118.17041, 34.17735], [-118.1702, 34.17699], [-118.17015, 34.17694], [-118.17006, 34.17688], [-118.16982, 34.17677], [-118.16947, 34.17648], [-118.16929, 34.17639], [-118.16911, 34.17625], [-118.16886, 34.17611], [-118.16866, 34.17587], [-118.16823, 34.17543], [-118.16806, 34.17524], [-118.16766, 34.17524], [-118.16765, 34.17511], [-118.16728, 34.17524], [-118.16725, 34.17511], [-118.16721, 34.17492], [-118.16711, 34.17363], [-118.16701, 34.17317], [-118.16699, 34.17299], [-118.16696, 34.17178], [-118.16689, 34.17152], [-118.16675, 34.17128], [-118.16668, 34.17114], [-118.16661, 34.17084], [-118.16664, 34.17019], [-118.16677, 34.16956], [-118.16679, 34.16932], [-118.16678, 34.16889], [-118.16679, 34.16843], [-118.16677, 34.1682], [-118.16642, 34.1671], [-118.16651, 34.1671], [-118.16652, 34.16709], [-118.16595, 34.16498], [-118.16523, 34.16349], [-118.16589, 34.16329], [-118.16778, 34.16277], [-118.16808, 34.16276], [-118.16841, 34.16264], [-118.16857, 34.16252], [-118.1689, 34.16241], [-118.16896, 34.16226], [-118.17005, 34.16195], [-118.16999, 34.16175], [-118.17002, 34.16173], [-118.16982, 34.16114], [-118.16974, 34.16109], [-118.16967, 34.161], [-118.16928, 34.15992], [-118.16932, 34.15971], [-118.16921, 34.15946], [-118.17032, 34.15985], [-118.171, 34.16012], [-118.17142, 34.16041], [-118.17165, 34.16111], [-118.17241, 34.16315], [-118.17217, 34.16322], [-118.17235, 34.16417], [-118.17242, 34.16439], [-118.17271, 34.16507], [-118.17318, 34.16645], [-118.17352, 34.16795], [-118.17399, 34.16795], [-118.17402, 34.16806], [-118.17425, 34.16914], [-118.17427, 34.16936], [-118.17447, 34.17027], [-118.17448, 34.17049], [-118.17468, 34.17142], [-118.17469, 34.17158], [-118.1748, 34.17226], [-118.17483, 34.17256], [-118.17478, 34.17312], [-118.17472, 34.17342], [-118.17456, 34.17402], [-118.1745, 34.17411], [-118.17437, 34.17417], [-118.17432, 34.17537], [-118.17339, 34.17649], [-118.17257, 34.17743], [-118.17253, 34.17803], [-118.17323, 34.17898], [-118.17357, 34.17931], [-118.1738, 34.17968], [-118.17394, 34.17995], [-118.17402, 34.18031], [-118.17366, 34.1808], [-118.17367, 34.18082], [-118.17359, 34.18105], [-118.17339, 34.18132], [-118.17345, 34.18137], [-118.17332, 34.18178], [-118.17344, 34.18248], [-118.17391, 34.18247], [-118.17394, 34.18268], [-118.17401, 34.18287], [-118.17436, 34.1834]]]} | Restricted Access 2 | 45949 | Brookside Golf Course | 29070 | 1246 | Pasadena, City of 301 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | http://www.cityofpasadena.net/PublicWorks/brookside_golf_course/ | Los Angeles 6 | 293.605 | Brookside GC | 0 | Local Recreation Area 3 | 4 |
15726 | 15726 | 15725 | {"type": "Polygon", "coordinates": [[[-121.35011, 38.00588], [-121.35004, 38.01275], [-121.34999, 38.01357], [-121.34999, 38.0139], [-121.34458, 38.01387], [-121.34456, 38.01382], [-121.3444, 38.01383], [-121.34423, 38.01388], [-121.34401, 38.01385], [-121.34353, 38.01386], [-121.34194, 38.01385], [-121.34193, 38.01343], [-121.34157, 38.01321], [-121.34097, 38.01292], [-121.34055, 38.01281], [-121.3402, 38.01281], [-121.33982, 38.01299], [-121.3398, 38.01271], [-121.3399, 38.01222], [-121.3399, 38.01198], [-121.33979, 38.01131], [-121.33974, 38.01117], [-121.33959, 38.01089], [-121.33949, 38.01042], [-121.33946, 38.01024], [-121.33946, 38.00978], [-121.33943, 38.00953], [-121.339, 38.00759], [-121.33895, 38.00678], [-121.33893, 38.00624], [-121.33893, 38.00616], [-121.33883, 38.00582], [-121.33885, 38.00578], [-121.33931, 38.0056], [-121.33958, 38.00551], [-121.33977, 38.00587], [-121.34029, 38.0058], [-121.34097, 38.00576], [-121.34363, 38.00548], [-121.34361, 38.00516], [-121.34536, 38.00526], [-121.34662, 38.00515], [-121.34957, 38.00503], [-121.34961, 38.00504], [-121.34964, 38.00507], [-121.34967, 38.00531], [-121.34978, 38.00555], [-121.3499, 38.00571], [-121.35011, 38.00588]], [[-121.34012, 38.00965], [-121.34012, 38.0096], [-121.34008, 38.0096], [-121.34008, 38.00965], [-121.34012, 38.00965]]]} | Restricted Access 2 | 44950 | Swenson Park Golf Course | 33122 | 1343 | Stockton, City of 402 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | San Joaquin 39 | 213.574 | Swenson Park GC | 0 | Local Recreation Area 3 | 4 | |
15722 | 15722 | 15721 | {"type": "MultiPolygon", "coordinates": [[[[-121.84169, 37.30182], [-121.83911, 37.30357], [-121.83871, 37.30382], [-121.83833, 37.30344], [-121.83831, 37.30296], [-121.83806, 37.30292], [-121.83779, 37.30277], [-121.83752, 37.30249], [-121.8374, 37.30207], [-121.83741, 37.30196], [-121.83729, 37.30113], [-121.83699, 37.30077], [-121.83589, 37.30148], [-121.8358, 37.30142], [-121.83548, 37.30163], [-121.83398, 37.30095], [-121.83407, 37.3009], [-121.83406, 37.30088], [-121.83211, 37.30009], [-121.83217, 37.30005], [-121.83217, 37.30003], [-121.83175, 37.29986], [-121.83029, 37.30027], [-121.82981, 37.29962], [-121.83097, 37.29885], [-121.83009, 37.29781], [-121.82955, 37.29738], [-121.82757, 37.2974], [-121.82788, 37.29723], [-121.82859, 37.29678], [-121.82873, 37.29701], [-121.82949, 37.29702], [-121.82982, 37.29708], [-121.82987, 37.29701], [-121.831, 37.29751], [-121.83177, 37.29795], [-121.83211, 37.29811], [-121.83197, 37.2982], [-121.83198, 37.29822], [-121.83336, 37.29877], [-121.83366, 37.29886], [-121.83382, 37.2989], [-121.83418, 37.29893], [-121.83467, 37.29894], [-121.83491, 37.299], [-121.83521, 37.2991], [-121.83609, 37.29952], [-121.83624, 37.29942], [-121.83658, 37.29959], [-121.83682, 37.29974], [-121.83696, 37.29986], [-121.83735, 37.30023], [-121.83742, 37.30032], [-121.83746, 37.30042], [-121.83759, 37.30085], [-121.83777, 37.30117], [-121.83788, 37.3013], [-121.8381, 37.30152], [-121.83813, 37.30151], [-121.8391, 37.30241], [-121.83971, 37.30198], [-121.84035, 37.30263], [-121.84164, 37.30177], [-121.84169, 37.30182]]], [[[-121.83787, 37.30585], [-121.83766, 37.30598], [-121.83727, 37.30607], [-121.83719, 37.30598], [-121.83702, 37.30585], [-121.83307, 37.30386], [-121.83283, 37.30376], [-121.83243, 37.3037], [-121.83224, 37.30364], [-121.83208, 37.30356], [-121.83177, 37.30334], [-121.83156, 37.30325], [-121.83128, 37.30319], [-121.83005, 37.30302], [-121.82979, 37.30301], [-121.82887, 37.30303], [-121.82859, 37.30301], [-121.82821, 37.30293], [-121.82785, 37.30279], [-121.82768, 37.30269], [-121.82739, 37.30247], [-121.8255, 37.30049], [-121.82542, 37.30008], [-121.82497, 37.29973], [-121.82488, 37.29961], [-121.82492, 37.29956], [-121.82525, 37.29935], [-121.82542, 37.29929], [-121.82676, 37.29993], [-121.82758, 37.3003], [-121.82775, 37.30036], [-121.82799, 37.30031], [-121.82818, 37.30014], [-121.82834, 37.30005], [-121.82847, 37.30002], [-121.82872, 37.3001], [-121.82878, 37.30022], [-121.82893, 37.30039], [-121.82935, 37.30013], [-121.83059, 37.30049], [-121.83103, 37.30066], [-121.83113, 37.30065], [-121.83152, 37.30055], [-121.83175, 37.30063], [-121.83194, 37.30079], [-121.83211, 37.30086], [-121.83237, 37.30103], [-121.83241, 37.30107], [-121.83274, 37.30124], [-121.83508, 37.3018], [-121.83518, 37.30185], [-121.8348, 37.30213], [-121.8348, 37.30214], [-121.83521, 37.30222], [-121.83573, 37.30238], [-121.83589, 37.30256], [-121.83608, 37.30264], [-121.83651, 37.30272], [-121.83668, 37.30284], [-121.83694, 37.3031], [-121.83725, 37.30361], [-121.83737, 37.30374], [-121.83755, 37.3038], [-121.83762, 37.30397], [-121.83759, 37.30421], [-121.83773, 37.30436], [-121.83783, 37.30461], [-121.83791, 37.30488], [-121.83789, 37.3051], [-121.83794, 37.30533], [-121.83793, 37.30565], [-121.83787, 37.30585]]]]} | Restricted Access 2 | 44531 | Los Lagos Golf Course | 21519 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 122.795 | Los Lagos 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]);