units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
17,068 rows
This data as json, copyable, CSV (advanced)
MNG_AG_TYP >30
- City Agency 9,044
- County Agency 1,095
- State Agency 1,093
- Recreation/Parks District 1,084
- Non Profit - Land Trust 557
- Federal Agency 480
- Open Space District 399
- Water District 230
- County Agency - Parks 224
- Community Services District 192
- Home Owners Association 187
- Non Profit - Conservation 145
- Flood District 99
- Non Profit - Other 45
- Cemetery District 42
- Irrigation District 41
- School District 38
- County Agency - Other 29
- Port/Harbor District 29
- Special District - Other 15
- Commercial 14
- Joint Powers Authority 9
- Sanitation District 8
- Other 6
- Non Profit - Cemetery District 5
- Conservation District 5
- Transportation Agency 5
- Mitigation Bank 4
- Non Profit - Education 3
- Metropolitan Planning Organization 2
- …
MNG_AGENCY >30
- San Diego, City of 464
- California Department of Fish and Wildlife 423
- Los Angeles, City of 405
- California Department of Parks and Recreation 371
- Mountains Recreation and Conservation Authority 324
- Sacramento, City of 220
- San Jose, City of 207
- San Francisco, City and County of 189
- East Bay Regional Park District 164
- Los Angeles, County of 145
- Ventura, City of 143
- Roseville, City of 130
- Long Beach, City of 127
- United States Bureau of Land Management 115
- Santa Barbara, County of 107
- Oakland, City of 107
- United States Forest Service 104
- San Diego, County of 102
- Consumnes Community Services District 94
- Modesto, City of 85
- California State Lands Commission 82
- Orange, County of 81
- United States Fish and Wildlife Service 80
- Stockton, City of 80
- Napa, City of 80
- Irvine, City of 77
- United States National Park Service 76
- Hayward Area Recreation and Park District 72
- Tracy, City of 72
- Torrance, City of 66
- …
DES_TP >30
- Local Park 7,951
- Local Recreation Area 1,846
- Local Other or Unknown 1,159
- Private Conservation 585
- Local Conservation Area 446
- State Conservation Area 366
- Private Recreation or Education 250
- State Park 204
- State Resource Management Area 154
- State Recreation Area 138
- National Forest 91
- Local Historic or Cultural Area 86
- National Wildlife Refuge 73
- National Public Lands 71
- State Other or Unknown 68
- State Historic or Cultural Area 62
- Recreation Management Area 54
- Private Other or Unknown 51
- National Monument or Landmark 38
- National Recreation Area 36
- Resource Management Area 23
- Federal Other or Unknown 23
- National Park 22
- Local Resource Management Area 22
- Conservation Area 12
- Private Agricultural 12
- Area of Critical Environmental Concern 7
- Wilderness Area 5
- Historic or Cultural Area 5
- Private Historic or Cultural 4
- …
LAYER 14 ✖
- City 8,917
- Special District 2,235
- County 1,313
- Non Governmental Organization 734
- Other State 416
- California Department of Fish and Wildlife 378
- California Department of Parks and Recreation 345
- Private 248
- US Bureau of Land Management 136
- Other Federal 135
- US Forest Service 108
- National Park Service 81
- US Fish and Wildlife Service 77
- US Military/Defense 10
ACCESS_TYP 4
- Open Access 12,715
- Restricted Access 1,135
- No Public Access 909
- Unknown Access 374
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1936 | 1936 | 1935 | {"type": "Polygon", "coordinates": [[[-119.25439, 34.20843], [-119.25369, 34.2087], [-119.25159, 34.20484], [-119.2522, 34.20457], [-119.25218, 34.20452], [-119.25326, 34.20611], [-119.25361, 34.20692], [-119.25439, 34.20843]]]} | Open Access 1 | 16625 | Mandalay County Park | 21734 | 331 | Ventura, County of 202 | County 3 | County Agency 3 | http://www.ventura.org/general-services-agency/parks-department | County 3 | 331 | Ventura, County of 198 | County 3 | County Agency 3 | Ventura 8 | 8.661 | Mandalay County Park | 0 | Local Park 2 | 4 | |
1937 | 1937 | 1936 | {"type": "Polygon", "coordinates": [[[-118.3711, 33.8099], [-118.36954, 33.8099], [-118.37004, 33.80894], [-118.37004, 33.80833], [-118.37013, 33.80831], [-118.37022, 33.80824], [-118.37028, 33.80807], [-118.3705, 33.80774], [-118.37061, 33.80762], [-118.37075, 33.8075], [-118.37089, 33.80741], [-118.37103, 33.80758], [-118.37109, 33.80758], [-118.37111, 33.80984], [-118.3711, 33.8099]]]} | Open Access 1 | 5994 | Los Arboles Park | 21503 | 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 | Los Angeles 6 | 6.305 | Los Arboles Park | 0 | Local Park 2 | 4 | |
1938 | 1938 | 1937 | {"type": "Polygon", "coordinates": [[[-118.3567, 33.80956], [-118.3567, 33.81116], [-118.35667, 33.81117], [-118.35664, 33.81117], [-118.35623, 33.81114], [-118.35603, 33.81109], [-118.35596, 33.81109], [-118.35585, 33.81114], [-118.35579, 33.8112], [-118.35577, 33.81125], [-118.35577, 33.81132], [-118.35583, 33.81149], [-118.3558, 33.8127], [-118.35574, 33.81272], [-118.35453, 33.81271], [-118.35451, 33.81269], [-118.35453, 33.80923], [-118.35462, 33.80922], [-118.3547, 33.80924], [-118.35501, 33.80939], [-118.35519, 33.80942], [-118.35668, 33.80954], [-118.3567, 33.80956]]]} | Open Access 1 | 5995 | Lago Seco Park | 20840 | 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 | Los Angeles 6 | 14.638 | Lago Seco Park | 0 | Local Park 2 | 4 | |
1939 | 1939 | 1938 | {"type": "Polygon", "coordinates": [[[-118.35435, 33.80454], [-118.35435, 33.80563], [-118.35277, 33.80551], [-118.35278, 33.80441], [-118.35435, 33.80454]]]} | Open Access 1 | 5997 | Walteria Park | 27248 | 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 | Los Angeles 6 | 4.411 | Walteria Park | 0 | Local Park 2 | 4 | |
1940 | 1940 | 1939 | {"type": "Polygon", "coordinates": [[[-118.34494, 33.79301], [-118.34492, 33.79305], [-118.34466, 33.79321], [-118.34429, 33.79334], [-118.3441, 33.79344], [-118.34397, 33.79361], [-118.34392, 33.79376], [-118.34393, 33.79384], [-118.34395, 33.79393], [-118.34402, 33.79406], [-118.3446, 33.79461], [-118.34474, 33.79472], [-118.34486, 33.79478], [-118.34466, 33.79513], [-118.34181, 33.794], [-118.34202, 33.79363], [-118.34212, 33.79361], [-118.34222, 33.79352], [-118.34229, 33.79333], [-118.34243, 33.79307], [-118.34273, 33.79255], [-118.34284, 33.79243], [-118.34288, 33.79237], [-118.34289, 33.79229], [-118.34284, 33.7922], [-118.343, 33.79194], [-118.34397, 33.79233], [-118.34433, 33.79251], [-118.34452, 33.79264], [-118.34474, 33.79281], [-118.34493, 33.79296], [-118.34494, 33.79301]]]} | Open Access 1 | 5999 | De Portola Park | 17975 | 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 | Los Angeles 6 | 12.592 | De Portola Park | 0 | Local Park 2 | 4 | |
1941 | 1941 | 1940 | {"type": "Polygon", "coordinates": [[[-117.69243, 34.07367], [-117.69243, 34.07394], [-117.69129, 34.07395], [-117.69129, 34.07221], [-117.69215, 34.07221], [-117.69214, 34.07366], [-117.69243, 34.07367]]]} | Open Access 1 | 16637 | Alma Hoffman Park (Montclair Skate Park) | 15386 | 1210 | Montclair, City of 55 | City 2 | City Agency 2 | http://www.ci.montclair.ca.us/ | City 2 | 1210 | Montclair, City of 53 | City 2 | City Agency 2 | San Bernardino 22 | 3.949 | Alma Hoffman Park (Montclair Skate Park) | None 157 | |||
1942 | 1942 | 1941 | {"type": "Polygon", "coordinates": [[[-121.43074, 36.49462], [-121.42983, 36.49537], [-121.42837, 36.49418], [-121.4298, 36.49384], [-121.43074, 36.49462]]]} | Open Access 1 | 16639 | Gonzales Cemetery | 19393 | 2038 | Gonzales Cemetery District 457 | Special District 4 | Cemetery District 11 | Special District 4 | 2038 | Gonzales Cemetery District 451 | Special District 4 | Cemetery District 11 | Monterey 14 | 4.437 | Gonzales Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
1943 | 1943 | 1942 | {"type": "Polygon", "coordinates": [[[-121.44452, 36.50964], [-121.44379, 36.51021], [-121.44308, 36.50961], [-121.44381, 36.50905], [-121.44452, 36.50964]]]} | Open Access 1 | 16643 | Gonzales Central Park | 19394 | 1122 | Gonzales, City of 458 | City 2 | City Agency 2 | http://www.ci.gonzales.ca.us/parks-and-facilities.php | City 2 | 1122 | Gonzales, City of 452 | City 2 | City Agency 2 | Monterey 14 | 2.05 | Gonzales Central Park | 0 | Local Park 2 | 4 | |
1944 | 1944 | 1943 | {"type": "Polygon", "coordinates": [[[-118.33649, 33.81859], [-118.33616, 33.81859], [-118.33615, 33.81848], [-118.3343, 33.81811], [-118.33447, 33.81796], [-118.33452, 33.81789], [-118.33492, 33.8171], [-118.33494, 33.81708], [-118.33522, 33.81714], [-118.33555, 33.81718], [-118.3358, 33.81716], [-118.33611, 33.81713], [-118.33647, 33.81713], [-118.33649, 33.81715], [-118.33649, 33.81718], [-118.33649, 33.81859]]]} | Open Access 1 | 6000 | Hickory Park | 19897 | 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 | Los Angeles 6 | 5.807 | Hickory Park | 0 | Local Park 2 | 4 | |
1945 | 1945 | 1944 | {"type": "MultiPolygon", "coordinates": [[[[-122.70278, 38.00573], [-122.70228, 38.00654], [-122.70204, 38.00654], [-122.70204, 38.00665], [-122.70221, 38.00666], [-122.70187, 38.00722], [-122.70164, 38.00714], [-122.70157, 38.00722], [-122.70152, 38.00718], [-122.70136, 38.00715], [-122.70104, 38.00702], [-122.70045, 38.00654], [-122.7004, 38.00652], [-122.70043, 38.00645], [-122.70024, 38.00635], [-122.70003, 38.00635], [-122.70002, 38.00644], [-122.69981, 38.00644], [-122.69957, 38.00641], [-122.69941, 38.0063], [-122.69925, 38.00596], [-122.69878, 38.00567], [-122.69848, 38.00554], [-122.69713, 38.00602], [-122.69724, 38.00658], [-122.69698, 38.00672], [-122.69672, 38.00671], [-122.69619, 38.00677], [-122.69675, 38.00777], [-122.69766, 38.00745], [-122.69772, 38.00756], [-122.69771, 38.0077], [-122.69767, 38.00782], [-122.69763, 38.00817], [-122.6949, 38.01089], [-122.69525, 38.01206], [-122.69354, 38.01409], [-122.69347, 38.01407], [-122.69346, 38.01398], [-122.6935, 38.0136], [-122.69337, 38.01349], [-122.69307, 38.0137], [-122.69299, 38.01371], [-122.69276, 38.0137], [-122.69268, 38.01366], [-122.69258, 38.01339], [-122.69242, 38.01338], [-122.69228, 38.01335], [-122.6917, 38.01312], [-122.69137, 38.01307], [-122.69126, 38.01299], [-122.69152, 38.0128], [-122.69131, 38.01259], [-122.69105, 38.01276], [-122.69094, 38.01252], [-122.69094, 38.01229], [-122.69072, 38.01225], [-122.69054, 38.01165], [-122.69041, 38.01139], [-122.69039, 38.01128], [-122.69042, 38.01099], [-122.68955, 38.01051], [-122.6895, 38.0104], [-122.68921, 38.01029], [-122.68922, 38.01021], [-122.68891, 38.00997], [-122.6888, 38.00977], [-122.68872, 38.00957], [-122.68881, 38.00935], [-122.68894, 38.00916], [-122.68843, 38.00898], [-122.68821, 38.00885], [-122.68809, 38.00857], [-122.6877, 38.0082], [-122.68753, 38.0079], [-122.6874, 38.00787], [-122.68741, 38.00768], [-122.68761, 38.00738], [-122.6881, 38.00696], [-122.68826, 38.00674], [-122.6881, 38.00662], [-122.68777, 38.00677], [-122.68738, 38.00685], [-122.68725, 38.00703], [-122.68707, 38.00715], [-122.68659, 38.0072], [-122.68648, 38.00729], [-122.68658, 38.0076], [-122.68648, 38.00777], [-122.68618, 38.00803], [-122.68625, 38.00849], [-122.68623, 38.00852], [-122.68623, 38.00855], [-122.68629, 38.0086], [-122.68637, 38.00859], [-122.68647, 38.00868], [-122.68609, 38.00884], [-122.68574, 38.00853], [-122.68559, 38.0082], [-122.68566, 38.00791], [-122.68563, 38.00776], [-122.68545, 38.00769], [-122.68491, 38.00827], [-122.68477, 38.00832], [-122.68448, 38.0083], [-122.68439, 38.00844], [-122.68417, 38.00855], [-122.68438, 38.00883], [-122.68454, 38.0089], [-122.68498, 38.00929], [-122.68504, 38.00942], [-122.68528, 38.00987], [-122.68508, 38.01009], [-122.68549, 38.01061], [-122.68572, 38.01141], [-122.686, 38.01209], [-122.68591, 38.01234], [-122.6862, 38.01241], [-122.68567, 38.0127], [-122.6852, 38.01281], [-122.68501, 38.01281], [-122.68513, 38.01267], [-122.68541, 38.0125], [-122.6852, 38.01226], [-122.68422, 38.01286], [-122.68363, 38.01278], [-122.68291, 38.01244], [-122.6827, 38.0123], [-122.68243, 38.01266], [-122.68211, 38.01242], [-122.68183, 38.01225], [-122.68154, 38.01201], [-122.68138, 38.01178], [-122.68111, 38.01148], [-122.68104, 38.0113], [-122.68078, 38.01093], [-122.68071, 38.01098], [-122.68094, 38.01134], [-122.681, 38.01152], [-122.68129, 38.01183], [-122.68144, 38.01203], [-122.68176, 38.01231], [-122.682, 38.01245], [-122.68229, 38.01268], [-122.68165, 38.01316], [-122.68161, 38.01313], [-122.68151, 38.01284], [-122.68142, 38.01269], [-122.68126, 38.0126], [-122.6812, 38.01244], [-122.68113, 38.0122], [-122.681, 38.01192], [-122.6808, 38.01172], [-122.68063, 38.01163], [-122.68048, 38.01117], [-122.68035, 38.011], [-122.68034, 38.011], [-122.68029, 38.01107], [-122.68033, 38.01125], [-122.68024, 38.01149], [-122.68029, 38.01164], [-122.68032, 38.01185], [-122.68047, 38.01197], [-122.68054, 38.01216], [-122.68049, 38.01234], [-122.68059, 38.01245], [-122.6806, 38.01249], [-122.68052, 38.0126], [-122.68048, 38.01247], [-122.68032, 38.01227], [-122.68023, 38.01211], [-122.68009, 38.01202], [-122.68003, 38.01192], [-122.67974, 38.01165], [-122.67944, 38.01151], [-122.67988, 38.0112], [-122.67988, 38.01118], [-122.67655, 38.00789], [-122.67474, 38.00881], [-122.67474, 38.01006], [-122.67434, 38.01006], [-122.674, 38.01031], [-122.67382, 38.01029], [-122.67369, 38.01019], [-122.6737, 38.01], [-122.67358, 38.00984], [-122.67361, 38.00941], [-122.67343, 38.00932], [-122.6731, 38.00942], [-122.67299, 38.00942], [-122.67291, 38.00916], [-122.67273, 38.00907], [-122.6727, 38.00886], [-122.6724, 38.00859], [-122.67225, 38.00848], [-122.67218, 38.00836], [-122.67203, 38.00829], [-122.67197, 38.00841], [-122.67198, 38.00856], [-122.67202, 38.00868], [-122.67179, 38.00893], [-122.67178, 38.00909], [-122.67163, 38.00928], [-122.67161, 38.00951], [-122.67134, 38.00981], [-122.67108, 38.00996], [-122.67094, 38.00988], [-122.67087, 38.00956], [-122.67091, 38.00932], [-122.67083, 38.00905], [-122.67068, 38.00885], [-122.67048, 38.0089], [-122.67037, 38.00902], [-122.67023, 38.00911], [-122.67017, 38.00912], [-122.6701, 38.00903], [-122.67006, 38.00892], [-122.67014, 38.00875], [-122.66999, 38.00855], [-122.66984, 38.0084], [-122.66934, 38.00849], [-122.66932, 38.00848], [-122.66952, 38.00812], [-122.6696, 38.008], [-122.66973, 38.0076], [-122.66972, 38.00741], [-122.6696, 38.00742], [-122.66811, 38.00726], [-122.66797, 38.00757], [-122.66724, 38.00844], [-122.66712, 38.00856], [-122.66692, 38.00852], [-122.66677, 38.00869], [-122.66674, 38.00882], [-122.66627, 38.00926], [-122.66612, 38.0096], [-122.66621, 38.00989], [-122.66609, 38.01024], [-122.66543, 38.01023], [-122.66511, 38.01027], [-122.66499, 38.01019], [-122.66487, 38.00998], [-122.66417, 38.00986], [-122.66492, 38.0096], [-122.66556, 38.00846], [-122.66517, 38.00759], [-122.66468, 38.00735], [-122.66308, 38.0077], [-122.66208, 38.00435], [-122.66041, 38.00379], [-122.65946, 38.00395], [-122.65799, 38.00413], [-122.65599, 38.00674], [-122.65602, 38.0093], [-122.65415, 38.00902], [-122.65391, 38.00972], [-122.65421, 38.01018], [-122.65436, 38.01065], [-122.65446, 38.0107], [-122.65437, 38.01087], [-122.65435, 38.01102], [-122.65437, 38.01117], [-122.65445, 38.01135], [-122.65447, 38.01145], [-122.65443, 38.01149], [-122.65387, 38.01154], [-122.6538, 38.01152], [-122.65375, 38.01131], [-122.65367, 38.01112], [-122.65339, 38.0108], [-122.65333, 38.01068], [-122.65286, 38.00956], [-122.65278, 38.00944], [-122.65266, 38.00932], [-122.65247, 38.0092], [-122.65224, 38.00914], [-122.65143, 38.00904], [-122.65042, 38.00881], [-122.65039, 38.00893], [-122.6507, 38.00992], [-122.65029, 38.01028], [-122.64948, 38.00979], [-122.64952, 38.0097], [-122.6495, 38.00949], [-122.64942, 38.00938], [-122.64927, 38.00926], [-122.6491, 38.00919], [-122.64912, 38.00898], [-122.64863, 38.00867], [-122.64844, 38.00843], [-122.64814, 38.00826], [-122.64779, 38.00746], [-122.64772, 38.00724], [-122.64783, 38.00706], [-122.64793, 38.00708], [-122.64794, 38.00707], [-122.64792, 38.00693], [-122.64772, 38.00688], [-122.64892, 38.0067], [-122.64891, 38.0055], [-122.64732, 38.00462], [-122.64719, 38.00409], [-122.64575, 38.00485], [-122.64585, 38.00385], [-122.64428, 38.00402], [-122.64424, 38.00361], [-122.64432, 38.0035], [-122.64419, 38.00334], [-122.64357, 38.00313], [-122.64332, 38.00318], [-122.64273, 38.00294], [-122.64271, 38.00282], [-122.64274, 38.00258], [-122.64267, 38.00234], [-122.64275, 38.00224], [-122.64278, 38.00208], [-122.64264, 38.00191], [-122.6427, 38.00171], [-122.64269, 38.00149], [-122.64246, 38.00133], [-122.64166, 38.00116], [-122.64137, 38.00128], [-122.64105, 38.00153], [-122.64077, 38.00144], [-122.64052, 38.00116], [-122.64044, 38.00092], [-122.64014, 38.00067], [-122.6398, 38.00075], [-122.63951, 38.00065], [-122.63943, 38.00012], [-122.63925, 38.00009], [-122.63896, 38.00047], [-122.63846, 38.00058], [-122.63844, 37.99994], [-122.63946, 37.99744], [-122.63722, 37.99674], [-122.63441, 37.99647], [-122.63408, 37.9977], [-122.63342, 37.99771], [-122.63228, 37.99721], [-122.63161, 37.99714], [-122.63121, 37.99734], [-122.63102, 37.99725], [-122.63056, 37.9974], [-122.62909, 37.99731], [-122.6294, 37.99579], [-122.63633, 37.9941], [-122.6465, 37.98255], [-122.64655, 37.98295], [-122.6466, 37.9832], [-122.64677, 37.98355], [-122.64701, 37.98388], [-122.64726, 37.98413], [-122.64741, 37.98424], [-122.64773, 37.98443], [-122.64793, 37.98452], [-122.64823, 37.98456], [-122.64843, 37.98462], [-122.64861, 37.98471], [-122.64878, 37.98483], [-122.64897, 37.98504], [-122.649, 37.98522], [-122.64907, 37.98536], [-122.64918, 37.98548], [-122.64943, 37.98564], [-122.64951, 37.98571], [-122.6496, 37.98584], [-122.64964, 37.98593], [-122.64965, 37.98602], [-122.64965, 37.98612], [-122.64952, 37.98668], [-122.64956, 37.98712], [-122.64965, 37.98757], [-122.64944, 37.98818], [-122.64892, 37.98865], [-122.64853, 37.98942], [-122.64854, 37.99004], [-122.64801, 37.99054], [-122.64742, 37.99066], [-122.64721, 37.99115], [-122.64758, 37.99143], [-122.648, 37.99169], [-122.6483, 37.9919], [-122.64885, 37.99216], [-122.64943, 37.99256], [-122.64978, 37.99312], [-122.64973, 37.99344], [-122.64983, 37.99422], [-122.65009, 37.99474], [-122.65062, 37.99532], [-122.65136, 37.99621], [-122.65174, 37.99705], [-122.65205, 37.99735], [-122.65217, 37.99741], [-122.6526, 37.99746], [-122.65275, 37.99751], [-122.65281, 37.99755], [-122.65293, 37.99768], [-122.65317, 37.99801], [-122.65322, 37.99806], [-122.65325, 37.99812], [-122.65322, 37.99822], [-122.65312, 37.99831], [-122.65304, 37.99842], [-122.65302, 37.99847], [-122.65304, 37.9986], [-122.65313, 37.99876], [-122.65327, 37.99888], [-122.65348, 37.9992], [-122.65373, 37.99921], [-122.65416, 37.99907], [-122.65461, 37.99898], [-122.65502, 37.99856], [-122.65545, 37.99853], [-122.65581, 37.99848], [-122.65613, 37.99837], [-122.65648, 37.99795], [-122.65665, 37.99784], [-122.65679, 37.99796], [-122.65685, 37.99829], [-122.65704, 37.99855], [-122.6571, 37.99878], [-122.65758, 37.99934], [-122.65778, 37.99943], [-122.65811, 37.99943], [-122.65845, 37.99952], [-122.65877, 37.99959], [-122.65884, 37.99962], [-122.65894, 37.99962], [-122.65902, 37.99959], [-122.65923, 37.99945], [-122.65975, 37.99916], [-122.65992, 37.99912], [-122.66016, 37.99914], [-122.66038, 37.99917], [-122.66046, 37.99921], [-122.66069, 37.99926], [-122.66086, 37.99926], [-122.66096, 37.99918], [-122.66103, 37.99909], [-122.66125, 37.99889], [-122.66132, 37.99884], [-122.66143, 37.99884], [-122.66156, 37.99886], [-122.66196, 37.99897], [-122.66213, 37.999], [-122.66225, 37.99908], [-122.66234, 37.9992], [-122.66245, 37.99924], [-122.66271, 37.99927], [-122.66285, 37.99932], [-122.66304, 37.99941], [-122.66343, 37.99964], [-122.66375, 37.9998], [-122.6639, 37.99985], [-122.66462, 38.00002], [-122.66476, 38.00009], [-122.66492, 38.00014], [-122.66507, 38.00017], [-122.66528, 38.00026], [-122.66545, 38.00031], [-122.66566, 38.0003], [-122.66593, 38.0002], [-122.66616, 38.00008], [-122.66632, 38.00004], [-122.66652, 37.9999], [-122.66675, 37.99985], [-122.66765, 37.99974], [-122.66874, 37.99963], [-122.66889, 37.99953], [-122.6693, 37.99935], [-122.66952, 37.99924], [-122.66966, 37.99906], [-122.66978, 37.99888], [-122.66997, 37.99848], [-122.67003, 37.99827], [-122.67008, 37.99805], [-122.6701, 37.99782], [-122.6701, 37.9976], [-122.67008, 37.99735], [-122.6701, 37.99729], [-122.67013, 37.99724], [-122.67021, 37.99719], [-122.67033, 37.99717], [-122.67046, 37.99718], [-122.67055, 37.99723], [-122.67072, 37.99727], [-122.67089, 37.99728], [-122.67121, 37.99725], [-122.67147, 37.99718], [-122.67161, 37.99719], [-122.67173, 37.99722], [-122.67204, 37.99735], [-122.67243, 37.9977], [-122.67259, 37.99789], [-122.67267, 37.998], [-122.67268, 37.99846], [-122.6727, 37.99859], [-122.67275, 37.99867], [-122.67281, 37.99871], [-122.6729, 37.99873], [-122.67331, 37.99877], [-122.6735, 37.99888], [-122.67366, 37.99905], [-122.67376, 37.99925], [-122.67385, 37.99951], [-122.67408, 37.99975], [-122.67421, 37.99995], [-122.67426, 38.00015], [-122.67428, 38.00035], [-122.67423, 38.00066], [-122.67427, 38.00076], [-122.67433, 38.00083], [-122.67445, 38.00093], [-122.6746, 38.001], [-122.67476, 38.00105], [-122.67491, 38.00107], [-122.67537, 38.00098], [-122.67586, 38.00096], [-122.6761, 38.00088], [-122.67629, 38.00086], [-122.6763, 38.00104], [-122.6763, 38.00129], [-122.67637, 38.00137], [-122.6765, 38.00143], [-122.67658, 38.0015], [-122.67667, 38.00169], [-122.67678, 38.00186], [-122.67697, 38.00219], [-122.67701, 38.00233], [-122.67711, 38.00253], [-122.6771, 38.00262], [-122.67713, 38.00269], [-122.67719, 38.00276], [-122.67728, 38.00283], [-122.67756, 38.00295], [-122.67776, 38.00299], [-122.67798, 38.00299], [-122.67816, 38.00296], [-122.67841, 38.00284], [-122.67857, 38.00281], [-122.6788, 38.00284], [-122.679, 38.00291], [-122.67921, 38.0031], [-122.67943, 38.00334], [-122.67969, 38.00352], [-122.67999, 38.00354], [-122.68021, 38.00343], [-122.68061, 38.00271], [-122.68077, 38.00249], [-122.68104, 38.00242], [-122.68123, 38.00245], [-122.68166, 38.00278], [-122.68186, 38.00289], [-122.68209, 38.00305], [-122.68226, 38.00321], [-122.68247, 38.00332], [-122.68268, 38.00332], [-122.68277, 38.00323], [-122.68282, 38.00304], [-122.68288, 38.00296], [-122.68304, 38.0029], [-122.68326, 38.00293], [-122.68388, 38.00324], [-122.68427, 38.00327], [-122.6846, 38.00338], [-122.68508, 38.00349], [-122.68535, 38.00337], [-122.6856, 38.00319], [-122.6859, 38.00312], [-122.68634, 38.00304], [-122.68672, 38.00291], [-122.6872, 38.00289], [-122.68752, 38.00296], [-122.68816, 38.00326], [-122.68868, 38.00334], [-122.68925, 38.0037], [-122.69008, 38.00402], [-122.69077, 38.00425], [-122.69115, 38.00428], [-122.69154, 38.00419], [-122.69221, 38.00387], [-122.69255, 38.00374], [-122.69291, 38.00367], [-122.69331, 38.00364], [-122.69413, 38.00362], [-122.69444, 38.0036], [-122.69462, 38.00354], [-122.69468, 38.00333], [-122.6947, 38.00307], [-122.69466, 38.00286], [-122.69455, 38.00272], [-122.69438, 38.00258], [-122.69427, 38.00247], [-122.69445, 38.00233], [-122.69658, 38.00163], [-122.69707, 38.00253], [-122.69772, 38.00334], [-122.69955, 38.00414], [-122.69961, 38.00485], [-122.69993, 38.00498], [-122.70025, 38.00475], [-122.70088, 38.00474], [-122.70278, 38.00573]], [[-122.70078, 38.00673], [-122.70078, 38.00675], [-122.70104, 38.0069], [-122.70114, 38.0068], [-122.70087, 38.00664], [-122.70078, 38.00673]]], [[[-122.63999, 38.00149], [-122.63988, 38.00183], [-122.63899, 38.00216], [-122.63891, 38.00193], [-122.63927, 38.0016], [-122.6394, 38.00128], [-122.63967, 38.00107], [-122.63999, 38.00149]]], [[[-122.6398, 38.00091], [-122.63943, 38.00121], [-122.63911, 38.00063], [-122.63928, 38.00036], [-122.63934, 38.00076], [-122.6398, 38.00091]]], [[[-122.64043, 38.00218], [-122.63998, 38.00258], [-122.63965, 38.00282], [-122.63932, 38.00264], [-122.63912, 38.00238], [-122.64001, 38.00194], [-122.64043, 38.00218]]], [[[-122.64224, 38.00143], [-122.64224, 38.0017], [-122.64216, 38.00182], [-122.64214, 38.00193], [-122.64195, 38.00188], [-122.64183, 38.00197], [-122.64184, 38.00198], [-122.64211, 38.00205], [-122.64218, 38.00222], [-122.64217, 38.00234], [-122.64208, 38.00242], [-122.64196, 38.00259], [-122.64081, 38.00237], [-122.63993, 38.00185], [-122.64003, 38.00149], [-122.63971, 38.00104], [-122.63989, 38.00089], [-122.6401, 38.00084], [-122.64027, 38.00098], [-122.64036, 38.00121], [-122.64066, 38.00155], [-122.64108, 38.0017], [-122.64148, 38.00139], [-122.64168, 38.00131], [-122.64224, 38.00143]]], [[[-122.6417, 38.00257], [-122.64163, 38.0028], [-122.64096, 38.00287], [-122.64089, 38.00274], [-122.64112, 38.00247], [-122.6417, 38.00257]]], [[[-122.64257, 38.00303], [-122.64223, 38.0032], [-122.64195, 38.00292], [-122.64202, 38.00286], [-122.64254, 38.00288], [-122.64257, 38.00303]]], [[[-122.6426, 38.0021], [-122.64259, 38.00219], [-122.64249, 38.00232], [-122.64256, 38.00255], [-122.64253, 38.00285], [-122.64203, 38.00283], [-122.642, 38.00263], [-122.64212, 38.00245], [-122.6422, 38.00237], [-122.64222, 38.00223], [-122.64216, 38.00206], [-122.6422, 38.00184], [-122.64228, 38.00173], [-122.64228, 38.00144], [-122.64239, 38.00146], [-122.64253, 38.00157], [-122.64253, 38.00168], [-122.64246, 38.00191], [-122.6426, 38.0021]]], [[[-122.64394, 38.00337], [-122.64384, 38.00341], [-122.64369, 38.00355], [-122.64354, 38.00364], [-122.64334, 38.00369], [-122.64321, 38.00364], [-122.64297, 38.00363], [-122.64264, 38.00357], [-122.64294, 38.00317], [-122.6433, 38.00331], [-122.64358, 38.00326], [-122.64394, 38.00337]]], [[[-122.64412, 38.00347], [-122.64404, 38.00357], [-122.64407, 38.00389], [-122.64391, 38.00388], [-122.64366, 38.0039], [-122.64362, 38.00387], [-122.64337, 38.00375], [-122.6436, 38.00368], [-122.64376, 38.00359], [-122.6439, 38.00346], [-122.64404, 38.00339], [-122.64408, 38.00341], [-122.64412, 38.00347]]], [[[-122.6474, 38.00624], [-122.64731, 38.00654], [-122.64715, 38.0065], [-122.64677, 38.00641], [-122.64657, 38.0062], [-122.64628, 38.0061], [-122.64618, 38.00597], [-122.64641, 38.00583], [-122.64653, 38.00595], [-122.64664, 38.00588], [-122.64699, 38.0061], [-122.6474, 38.00624]]], [[[-122.66518, 38.01038], [-122.66514, 38.01103], [-122.66498, 38.01099], [-122.66477, 38.01152], [-122.66448, 38.01155], [-122.66427, 38.01148], [-122.66415, 38.01156], [-122.66313, 38.01155], [-122.66373, 38.01], [-122.6639, 38.00994], [-122.66474, 38.01009], [-122.66485, 38.01027], [-122.66505, 38.01039], [-122.66518, 38.01038]]], [[[-122.66674, 38.01066], [-122.66656, 38.01081], [-122.6658, 38.01086], [-122.66579, 38.01091], [-122.66539, 38.01102], [-122.66541, 38.01135], [-122.66538, 38.01157], [-122.66503, 38.01159], [-122.66482, 38.01153], [-122.66501, 38.01104], [-122.66515, 38.01107], [-122.66522, 38.01105], [-122.66525, 38.01038], [-122.6655, 38.01035], [-122.66626, 38.01037], [-122.66634, 38.01046], [-122.66674, 38.01066]]], [[[-122.66689, 38.01039], [-122.66675, 38.01063], [-122.66637, 38.01044], [-122.66627, 38.01033], [-122.6664, 38.00989], [-122.66629, 38.00962], [-122.6664, 38.00936], [-122.66685, 38.00893], [-122.66683, 38.00951], [-122.6669, 38.00976], [-122.66688, 38.01011], [-122.66689, 38.01039]]], [[[-122.6747, 38.0107], [-122.67395, 38.01105], [-122.67334, 38.01164], [-122.67324, 38.01158], [-122.67303, 38.01137], [-122.67282, 38.01136], [-122.67285, 38.01122], [-122.67266, 38.01069], [-122.67265, 38.01051], [-122.67259, 38.01035], [-122.6724, 38.01016], [-122.67241, 38.00989], [-122.67236, 38.00969], [-122.67228, 38.00953], [-122.6723, 38.00941], [-122.67224, 38.00926], [-122.67226, 38.00916], [-122.67231, 38.00914], [-122.67235, 38.0092], [-122.67249, 38.00926], [-122.6726, 38.00933], [-122.6726, 38.00946], [-122.67276, 38.00937], [-122.67274, 38.00925], [-122.6726, 38.00915], [-122.67257, 38.00908], [-122.67261, 38.00903], [-122.67263, 38.00913], [-122.67282, 38.00921], [-122.67291, 38.00949], [-122.6731, 38.00951], [-122.67342, 38.00941], [-122.67351, 38.00945], [-122.67347, 38.00987], [-122.67358, 38.01003], [-122.67359, 38.01023], [-122.67378, 38.01038], [-122.67404, 38.01038], [-122.67437, 38.01015], [-122.67464, 38.01015], [-122.67466, 38.0104], [-122.67464, 38.0106], [-122.6747, 38.0107]]], [[[-122.68673, 38.00891], [-122.68644, 38.00902], [-122.6864, 38.0089], [-122.68613, 38.00885], [-122.68649, 38.0087], [-122.68673, 38.00891]]], [[[-122.68728, 38.008], [-122.68723, 38.00836], [-122.6865, 38.00867], [-122.68639, 38.00857], [-122.6864, 38.00852], [-122.68635, 38.00847], [-122.6863, 38.00805], [-122.68659, 38.00781], [-122.68694, 38.0078], [-122.68687, 38.00805], [-122.68687, 38.00807], [-122.68728, 38.008]]], [[[-122.68702, 38.00879], [-122.68676, 38.00889], [-122.68652, 38.00869], [-122.68687, 38.00854], [-122.68702, 38.00879]]], [[[-122.68812, 38.00677], [-122.68802, 38.00691], [-122.68754, 38.00732], [-122.68735, 38.0076], [-122.687, 38.00758], [-122.68701, 38.00751], [-122.68666, 38.00748], [-122.6866, 38.00733], [-122.68664, 38.00728], [-122.6871, 38.00724], [-122.68733, 38.0071], [-122.68746, 38.00693], [-122.68782, 38.00685], [-122.68809, 38.00673], [-122.68812, 38.00677]]], [[[-122.6906, 38.01211], [-122.69042, 38.01232], [-122.69039, 38.01221], [-122.69007, 38.01185], [-122.69, 38.01172], [-122.69033, 38.01142], [-122.69048, 38.01166], [-122.6906, 38.01211]]]]} | Open Access 1 | 16651 | Gary Giacomini Open Space Preserve | 6284 | 2070 | Marin County Open Space District 44 | Special District 4 | Recreation/Parks District 4 | http://www.marincountyparks.org/Depts/PK.aspx | Special District 4 | 2070 | Marin County Open Space District 43 | Special District 4 | Recreation/Parks District 4 | http://www.marincountyparks.org/depts/pk/divisions/open-space/gary-giacomini | Marin 23 | 1527.041 | Gary Giacomini OSP | 1995 | Local Conservation Area 4 | 2 |
1946 | 1946 | 1945 | {"type": "Polygon", "coordinates": [[[-121.76093, 36.91723], [-121.76076, 36.91733], [-121.76072, 36.91757], [-121.7608, 36.91771], [-121.76083, 36.91787], [-121.76082, 36.91797], [-121.76078, 36.91807], [-121.76066, 36.91822], [-121.76067, 36.91867], [-121.76061, 36.91868], [-121.76059, 36.91821], [-121.76052, 36.91809], [-121.7605, 36.91802], [-121.76049, 36.91789], [-121.7605, 36.91782], [-121.76055, 36.9177], [-121.76065, 36.91757], [-121.7607, 36.91729], [-121.76089, 36.91719], [-121.76093, 36.91723]]]} | Open Access 1 | 16647 | Gonzalez Pocket Park | 19401 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 0.54 | Gonzalez PP | 0 | Local Park 2 | 4 | |
1947 | 1947 | 1946 | {"type": "MultiPolygon", "coordinates": [[[[-118.98159, 36.05067], [-118.98137, 36.05079], [-118.9727, 36.05085], [-118.9718, 36.05081], [-118.97127, 36.05076], [-118.9708, 36.0507], [-118.97091, 36.0439], [-118.98041, 36.04394], [-118.98036, 36.04846], [-118.98039, 36.04883], [-118.98043, 36.04901], [-118.98052, 36.04928], [-118.98064, 36.04953], [-118.98074, 36.0497], [-118.98091, 36.04994], [-118.98105, 36.05009], [-118.98123, 36.05026], [-118.98148, 36.05046], [-118.98159, 36.05067]]], [[[-118.98205, 36.04396], [-118.98203, 36.04531], [-118.98196, 36.05048], [-118.98172, 36.05031], [-118.98148, 36.05012], [-118.98129, 36.04993], [-118.9811, 36.0497], [-118.98094, 36.04945], [-118.98084, 36.04924], [-118.98075, 36.04901], [-118.98068, 36.04874], [-118.98065, 36.04846], [-118.9807, 36.04394], [-118.98205, 36.04396]]]]} | Restricted Access 2 | 29177 | Yaudanchi Ecological Reserve | 27765 | 220 | California Department of Health Services 459 | State 5 | State Agency 5 | http://www.dhcs.ca.gov/Pages/default.aspx | Other State 5 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Tulare 29 | 184.306 | Yaudanchi ER | 0 | State Conservation Area 8 | 2 | |
1948 | 1948 | 1947 | {"type": "Polygon", "coordinates": [[[-122.08948, 37.38667], [-122.08907, 37.387], [-122.08798, 37.38644], [-122.08754, 37.38612], [-122.08738, 37.38595], [-122.08726, 37.38576], [-122.08947, 37.38575], [-122.08948, 37.38667]]]} | Open Access 1 | 15025 | McKelvey Park | 22044 | 1218 | Mountain View, City of 460 | City 2 | City Agency 2 | http://www.ci.mtnview.ca.us/services/parks/default.asp | City 2 | 1218 | Mountain View, City of 453 | City 2 | City Agency 2 | Santa Clara 19 | 4.322 | McKelvey Park | 1961 | Local Park 2 | 4 | |
1949 | 1949 | 1948 | {"type": "Polygon", "coordinates": [[[-119.3411, 35.24915], [-119.33804, 35.25071], [-119.33274, 35.25344], [-119.32347, 35.25337], [-119.32342, 35.24243], [-119.33225, 35.24252], [-119.3322, 35.23881], [-119.34107, 35.23889], [-119.3411, 35.24915]]]} | No Public Access 3 | 16653 | Elk Hills | 32158 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Kern 36 | 517.552 | Elk Hills | 0 | State Resource Management Area 55 | 3 | |
1950 | 1950 | 1949 | {"type": "Polygon", "coordinates": [[[-121.87669, 37.4267], [-121.87498, 37.42707], [-121.87494, 37.42706], [-121.87495, 37.42699], [-121.87476, 37.42644], [-121.87469, 37.42638], [-121.87473, 37.42633], [-121.87455, 37.42582], [-121.8745, 37.42579], [-121.87451, 37.42571], [-121.87432, 37.42517], [-121.8743, 37.42514], [-121.87425, 37.4251], [-121.87428, 37.42506], [-121.8741, 37.42453], [-121.87423, 37.42451], [-121.87438, 37.42468], [-121.87441, 37.42469], [-121.87517, 37.42452], [-121.87517, 37.4243], [-121.87527, 37.42428], [-121.8754, 37.42466], [-121.87527, 37.42488], [-121.87547, 37.4251], [-121.87542, 37.42514], [-121.87538, 37.42518], [-121.87537, 37.42522], [-121.87539, 37.42528], [-121.87581, 37.42574], [-121.87588, 37.42577], [-121.87589, 37.42582], [-121.87629, 37.42626], [-121.87636, 37.42627], [-121.87637, 37.42635], [-121.87669, 37.4267]]]} | Open Access 1 | 15011 | Murphy Park | 22608 | 1206 | Milpitas, City of 417 | City 2 | City Agency 2 | http://www.ci.milpitas.ca.gov/ | City 2 | 1206 | Milpitas, City of 411 | City 2 | City Agency 2 | Santa Clara 19 | 7.798 | Murphy Park | 1973 | Local Park 2 | 4 | |
1951 | 1951 | 1950 | {"type": "Polygon", "coordinates": [[[-122.07421, 37.36693], [-122.07419, 37.36805], [-122.07186, 37.36806], [-122.07185, 37.36774], [-122.07203, 37.36771], [-122.07223, 37.36765], [-122.07236, 37.36759], [-122.07252, 37.36748], [-122.07263, 37.36739], [-122.07274, 37.36725], [-122.07283, 37.36709], [-122.07287, 37.36694], [-122.07421, 37.36693]]]} | Open Access 1 | 15028 | Cooper Park | 17625 | 1218 | Mountain View, City of 460 | City 2 | City Agency 2 | http://www.ci.mtnview.ca.us/services/parks/default.asp | City 2 | 1218 | Mountain View, City of 453 | City 2 | City Agency 2 | Santa Clara 19 | 4.949 | Cooper Park | 0 | Local Park 2 | 4 | |
1952 | 1952 | 1951 | {"type": "Polygon", "coordinates": [[[-122.47443, 37.66522], [-122.47438, 37.66525], [-122.47419, 37.66532], [-122.47379, 37.6654], [-122.47341, 37.66542], [-122.47303, 37.66538], [-122.47278, 37.66533], [-122.47057, 37.66475], [-122.46938, 37.66442], [-122.46933, 37.66439], [-122.46932, 37.66434], [-122.4694, 37.66397], [-122.46939, 37.66333], [-122.47008, 37.66331], [-122.47006, 37.66266], [-122.47124, 37.6622], [-122.47138, 37.66215], [-122.47145, 37.66215], [-122.4715, 37.66219], [-122.47173, 37.6626], [-122.47194, 37.66291], [-122.47218, 37.66321], [-122.4724, 37.66344], [-122.4727, 37.66373], [-122.473, 37.66398], [-122.47372, 37.66447], [-122.474, 37.66469], [-122.47422, 37.66491], [-122.47439, 37.66509], [-122.47444, 37.66516], [-122.47443, 37.66522]]]} | Open Access 1 | 16663 | Gellert Park | 19251 | 1078 | Daly City, City of 427 | City 2 | City Agency 2 | http://www.dalycity.org/ | City 2 | 1078 | Daly City, City of 421 | City 2 | City Agency 2 | San Mateo 15 | 20.57 | Gellert Park | 1971 | Local Park 2 | 4 | |
1953 | 1953 | 1952 | {"type": "Polygon", "coordinates": [[[-118.32532, 33.79099], [-118.32469, 33.79099], [-118.32469, 33.79039], [-118.32531, 33.79039], [-118.32532, 33.79099]]]} | Open Access 1 | 6048 | Hathaway Park | 19735 | 1182 | Lomita, City of 461 | City 2 | City Agency 2 | http://www.lomita.com/cityhall/government/parksrec/index.cfm | City 2 | 1182 | Lomita, City of 454 | City 2 | City Agency 2 | Los Angeles 6 | 0.954 | Hathaway Park | 0 | Local Park 2 | 4 | |
1954 | 1954 | 1953 | {"type": "Polygon", "coordinates": [[[-118.31255, 33.79028], [-118.31254, 33.79061], [-118.31223, 33.79061], [-118.31231, 33.79039], [-118.31239, 33.79027], [-118.31255, 33.79028]]]} | Open Access 1 | 6049 | Veterans Park | 27044 | 1182 | Lomita, City of 461 | City 2 | City Agency 2 | http://www.lomita.com/cityhall/government/parksrec/index.cfm | City 2 | 1182 | Lomita, City of 454 | City 2 | City Agency 2 | Los Angeles 6 | 0.213 | Veterans Park | 0 | Local Park 2 | 4 | |
1955 | 1955 | 1954 | {"type": "Polygon", "coordinates": [[[-118.31437, 33.80313], [-118.31436, 33.80458], [-118.31181, 33.80457], [-118.31184, 33.80312], [-118.31437, 33.80313]]]} | Open Access 1 | 6050 | Lomita Park | 21414 | 1182 | Lomita, City of 461 | City 2 | City Agency 2 | http://www.lomita.com/cityhall/government/parksrec/index.cfm | City 2 | 1182 | Lomita, City of 454 | City 2 | City Agency 2 | Los Angeles 6 | 9.376 | Lomita 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]);