units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,162 rows where MNG_AG_TYP = 4 sorted by map
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- East Bay Regional Park District 167
- Hayward Area Recreation and Park District 84
- Valley-Wide Recreation and Park District 63
- Midpeninsula Regional Open Space District 51
- Conejo Recreation and Park District 48
- Rancho Simi Recreation and Park District 48
- Marin County Open Space District 41
- Southgate Recreation and Park District 41
- Sunrise Recreation and Park District 39
- Cordova Recreation and Park District 38
- Greater Vallejo Recreation and Park District 33
- Pleasant Valley Recreation and Park District 31
- North of the River Recreation and Park District 27
- Monterey Peninsula Regional Park District 25
- Santa Clara Valley Open Space Authority 25
- Sonoma County Agricultural Preservation and Open Space District 21
- Isla Vista Recreation and Park District 18
- Jurupa Area Recreation and Park District 18
- Desert Recreation District 15
- Mission Oaks Recreation and Park District 14
- Apple Valley Recreation and Park District 13
- Livermore Area Recreation and Park District 13
- Pleasant Hill Recreation and Park District 12
- Carmichael Recreation and Park District 12
- Auburn Area Recreation and Park District 11
- Hesperia Recreation and Park District 11
- North Highland Recreation and Park District 11
- Napa County Regional Park and Open Space District 10
- Rio Linda Elverta Recreation and Park District 9
- Tuolumne Park and Recreation District 9
- …
DES_TP >30
- Local Park 695
- Local Conservation Area 171
- Local Recreation Area 157
- Local Other or Unknown 28
- Local Historic or Cultural Area 3
- Local Resource Management 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
- …
ACCESS_TYP 4
- Open Access 973
- No Public Access 106
- Restricted Access 62
- Unknown Access 1
MNG_AG_TYP 1
- Recreation/Parks District · 1,142 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10163 | 10163 | 10162 | {"type": "MultiPolygon", "coordinates": [[[[-118.85683, 34.23954], [-118.8568, 34.23959], [-118.8567, 34.23938], [-118.8567, 34.23937], [-118.85683, 34.23954]]], [[[-118.85689, 34.23975], [-118.85688, 34.23975], [-118.85685, 34.23971], [-118.85689, 34.23975], [-118.85689, 34.23975]]], [[[-118.85275, 34.24064], [-118.85264, 34.24059], [-118.85237, 34.24061], [-118.85243, 34.24058], [-118.85242, 34.2406], [-118.85264, 34.24058], [-118.85275, 34.24064]]], [[[-118.85339, 34.24098], [-118.85317, 34.24081], [-118.85289, 34.2407], [-118.85298, 34.24071], [-118.85321, 34.24082], [-118.85339, 34.24098]]], [[[-118.8536, 34.2412], [-118.85343, 34.24101], [-118.85343, 34.24101], [-118.85345, 34.24102], [-118.8536, 34.2412]]], [[[-118.84856, 34.24296], [-118.84855, 34.24427], [-118.84855, 34.24422], [-118.84856, 34.24296]]], [[[-118.86424, 34.24569], [-118.86392, 34.24579], [-118.86363, 34.24573], [-118.86183, 34.24504], [-118.85908, 34.24514], [-118.85907, 34.24557], [-118.85582, 34.24601], [-118.85521, 34.24539], [-118.85472, 34.24505], [-118.85435, 34.2448], [-118.85356, 34.24447], [-118.85308, 34.24441], [-118.85229, 34.24447], [-118.85197, 34.24434], [-118.85209, 34.24376], [-118.85209, 34.2433], [-118.85238, 34.24315], [-118.85305, 34.24322], [-118.85335, 34.24361], [-118.85382, 34.24395], [-118.85445, 34.24414], [-118.85491, 34.24409], [-118.85552, 34.24377], [-118.85678, 34.24345], [-118.85787, 34.24342], [-118.85893, 34.24344], [-118.86001, 34.24322], [-118.86029, 34.24304], [-118.86109, 34.2424], [-118.86142, 34.24204], [-118.86166, 34.24164], [-118.86184, 34.24115], [-118.86212, 34.24004], [-118.86244, 34.23969], [-118.86267, 34.23997], [-118.86275, 34.24039], [-118.86274, 34.24099], [-118.86322, 34.24375], [-118.86361, 34.24494], [-118.86381, 34.24529], [-118.86424, 34.24569]]], [[[-118.85901, 34.24664], [-118.8583, 34.24676], [-118.8579, 34.24681], [-118.85901, 34.24664]]], [[[-118.85211, 34.24762], [-118.8504, 34.24762], [-118.85039, 34.24535], [-118.84855, 34.24563], [-118.85039, 34.24535], [-118.85042, 34.2476], [-118.85211, 34.24762]]]]} | Restricted Access 2 | 17736 | McCrea Ranch | 22015 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 63.673 | McCrea Ranch | 0 | Local Other or Unknown 14 | 4 | |
14605 | 14605 | 14604 | {"type": "MultiPolygon", "coordinates": [[[[-118.99513, 34.22522], [-118.99416, 34.22587], [-118.99396, 34.22605], [-118.99375, 34.22591], [-118.99349, 34.22579], [-118.99331, 34.22595], [-118.99269, 34.2257], [-118.99252, 34.22559], [-118.99243, 34.22558], [-118.99226, 34.2257], [-118.99199, 34.22553], [-118.99167, 34.2255], [-118.99095, 34.22567], [-118.99104, 34.22594], [-118.99101, 34.22595], [-118.9909, 34.22569], [-118.99066, 34.22576], [-118.99043, 34.22585], [-118.99, 34.22607], [-118.9896, 34.22634], [-118.98943, 34.2265], [-118.98911, 34.22683], [-118.98885, 34.22722], [-118.98877, 34.22744], [-118.98843, 34.22754], [-118.98849, 34.22787], [-118.98887, 34.22801], [-118.98902, 34.2282], [-118.98929, 34.22802], [-118.98931, 34.22804], [-118.98905, 34.22823], [-118.98924, 34.22838], [-118.98923, 34.22874], [-118.98912, 34.22905], [-118.98914, 34.22921], [-118.9893, 34.22938], [-118.9895, 34.22947], [-118.98983, 34.22948], [-118.99003, 34.22936], [-118.9921, 34.22992], [-118.99219, 34.22962], [-118.99222, 34.22963], [-118.99214, 34.22993], [-118.99272, 34.23009], [-118.99293, 34.23008], [-118.99093, 34.23081], [-118.9907, 34.23038], [-118.98808, 34.2303], [-118.988, 34.22995], [-118.98796, 34.22918], [-118.98793, 34.22897], [-118.98784, 34.22871], [-118.98762, 34.22825], [-118.9882, 34.22881], [-118.9887, 34.22844], [-118.98783, 34.22762], [-118.98744, 34.2279], [-118.98729, 34.22759], [-118.98807, 34.22714], [-118.98771, 34.22668], [-118.99037, 34.22519], [-118.991, 34.22491], [-118.99138, 34.22482], [-118.99334, 34.22503], [-118.9945, 34.22449], [-118.99463, 34.22466], [-118.99491, 34.22495], [-118.99513, 34.22522]]], [[[-118.99869, 34.2319], [-118.99551, 34.23195], [-118.99551, 34.23225], [-118.99501, 34.23226], [-118.99474, 34.23228], [-118.99444, 34.23234], [-118.99414, 34.23243], [-118.99398, 34.23211], [-118.99401, 34.2316], [-118.99351, 34.23109], [-118.99307, 34.23094], [-118.99266, 34.23108], [-118.99251, 34.23148], [-118.99273, 34.2318], [-118.99282, 34.2321], [-118.99313, 34.23256], [-118.99255, 34.23317], [-118.9928, 34.23352], [-118.99239, 34.23411], [-118.9921, 34.23297], [-118.99215, 34.23248], [-118.99151, 34.23088], [-118.99461, 34.22975], [-118.99494, 34.23038], [-118.99559, 34.2306], [-118.99549, 34.23078], [-118.99589, 34.23105], [-118.99579, 34.23124], [-118.996, 34.23123], [-118.99817, 34.23176], [-118.99866, 34.23174], [-118.99869, 34.2319]]], [[[-119.03767, 34.24169], [-119.03769, 34.24188], [-119.03766, 34.24206], [-119.03755, 34.24226], [-119.03741, 34.2424], [-119.03726, 34.24249], [-119.03712, 34.24254], [-119.03626, 34.24276], [-119.0357, 34.24116], [-119.03624, 34.24102], [-119.0361, 34.24063], [-119.03575, 34.24066], [-119.03573, 34.2406], [-119.03607, 34.24057], [-119.03608, 34.24056], [-119.03505, 34.23759], [-119.03521, 34.23755], [-119.03562, 34.23873], [-119.03601, 34.23864], [-119.03603, 34.23869], [-119.03564, 34.2388], [-119.03622, 34.24044], [-119.03662, 34.24035], [-119.03665, 34.24043], [-119.03625, 34.24054], [-119.03673, 34.24192], [-119.03767, 34.24169]]]]} | Open Access 1 | 48297 | Mission Verde Park | 32869 | 1708 | Camarillo, City of 1117 | City 2 | City Agency 2 | http://www.ci.camarillo.ca.us/ | City 2 | 2113 | Pleasant Valley Recreation and Park District 145 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 57.518 | Mission Verde Park | 0 | Local Park 2 | 4 | |
5554 | 5554 | 5553 | {"type": "MultiPolygon", "coordinates": [[[[-119.07261, 35.39748], [-119.07261, 35.3977], [-119.07254, 35.39775], [-119.06568, 35.39772], [-119.06561, 35.39766], [-119.06561, 35.39719], [-119.06564, 35.39694], [-119.06564, 35.39639], [-119.0657, 35.39634], [-119.06671, 35.39634], [-119.06671, 35.39745], [-119.07261, 35.39748]]], [[[-119.07323, 35.39748], [-119.07323, 35.39776], [-119.07288, 35.39775], [-119.07281, 35.3977], [-119.07282, 35.39748], [-119.07323, 35.39748]]]]} | Open Access 1 | 25351 | San Lauren Park | 24922 | 2096 | North of the River Recreation and Park District 386 | Special District 4 | Recreation/Parks District 4 | http://norfun.org/ | Special District 4 | 2096 | North of the River Recreation and Park District 382 | Special District 4 | Recreation/Parks District 4 | Kern 36 | 8.032 | San Lauren Park | 0 | Local Park 2 | 4 | |
17008 | 17008 | 17007 | {"type": "MultiPolygon", "coordinates": [[[[-119.07806, 34.23628], [-119.07804, 34.23659], [-119.07787, 34.23722], [-119.07774, 34.23732], [-119.07769, 34.23731], [-119.07752, 34.23744], [-119.07748, 34.2374], [-119.07761, 34.23729], [-119.07779, 34.23724], [-119.07784, 34.2372], [-119.078, 34.23659], [-119.07802, 34.23628], [-119.07806, 34.23628]]], [[[-119.07825, 34.23856], [-119.07816, 34.23894], [-119.07672, 34.23911], [-119.0767, 34.23897], [-119.07671, 34.23882], [-119.07675, 34.23879], [-119.07685, 34.23834], [-119.07825, 34.23856]]], [[[-119.07634, 34.23901], [-119.07589, 34.23931], [-119.07579, 34.2394], [-119.07568, 34.23943], [-119.07559, 34.23947], [-119.07617, 34.2391], [-119.07634, 34.23901]]], [[[-119.07534, 34.23961], [-119.07509, 34.23983], [-119.07479, 34.24022], [-119.07451, 34.24043], [-119.0745, 34.24042], [-119.07527, 34.23965], [-119.07534, 34.23961]]]]} | Open Access 1 | 48370 | Los Posas Equestrian Center | 32936 | 2113 | Pleasant Valley Recreation and Park District 149 | Special District 4 | Recreation/Parks District 4 | http://www.pvrpd.org/ | Special District 4 | 2113 | Pleasant Valley Recreation and Park District 145 | Special District 4 | Recreation/Parks District 4 | http://www.pvrpd.org/parks/park_list/las_posas_equestrian_park.asp | Ventura 8 | 2.391 | Los Posas Equestrian Ctr. | 0 | Local Recreation Area 3 | 4 |
365 | 365 | 364 | {"type": "MultiPolygon", "coordinates": [[[[-119.08732, 34.22541], [-119.08716, 34.2256], [-119.08697, 34.22573], [-119.08674, 34.22581], [-119.08637, 34.22589], [-119.08621, 34.22533], [-119.08622, 34.22508], [-119.08664, 34.22498], [-119.08731, 34.22537], [-119.08732, 34.22541]]], [[[-119.08846, 34.22607], [-119.08817, 34.22634], [-119.0866, 34.22666], [-119.08642, 34.22605], [-119.08683, 34.22596], [-119.08707, 34.22587], [-119.08725, 34.22575], [-119.08748, 34.22552], [-119.08752, 34.22551], [-119.08846, 34.22607]]]]} | Open Access 1 | 1045 | Springville Park | 25752 | 2113 | Pleasant Valley Recreation and Park District 149 | Special District 4 | Recreation/Parks District 4 | http://www.pvrpd.org/ | Special District 4 | 2113 | Pleasant Valley Recreation and Park District 145 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 4.87 | Springville Park | 0 | Local Park 2 | 4 | |
8543 | 8543 | 8542 | {"type": "MultiPolygon", "coordinates": [[[[-119.09761, 35.40048], [-119.09761, 35.40048], [-119.0976, 35.40055], [-119.09755, 35.40051], [-119.09761, 35.40048]]], [[[-119.09798, 35.40118], [-119.09789, 35.40109], [-119.09783, 35.40095], [-119.0979, 35.401], [-119.09794, 35.40106], [-119.09798, 35.40118]]], [[[-119.09823, 35.4015], [-119.0981, 35.40149], [-119.09804, 35.40138], [-119.09808, 35.40132], [-119.09823, 35.4015]]], [[[-119.09895, 35.39986], [-119.09895, 35.39986], [-119.09864, 35.39995], [-119.09889, 35.3998], [-119.09895, 35.39986]]], [[[-119.09949, 35.40115], [-119.09931, 35.40122], [-119.09921, 35.40121], [-119.09937, 35.40109], [-119.09947, 35.40107], [-119.09949, 35.40115]]]]} | Open Access 1 | 13462 | River Lakes Ranch Community Park | 24410 | 2096 | North of the River Recreation and Park District 386 | Special District 4 | Recreation/Parks District 4 | http://norfun.org/ | Special District 4 | 2096 | North of the River Recreation and Park District 382 | Special District 4 | Recreation/Parks District 4 | Kern 36 | 0.141 | River Lakes Ranch Community Park | 0 | Local Park 2 | 4 | |
2002 | 2002 | 2001 | {"type": "MultiPolygon", "coordinates": [[[[-119.21208, 34.85022], [-119.21204, 34.855], [-119.21179, 34.8556], [-119.21179, 34.85575], [-119.21177, 34.85589], [-119.21178, 34.85606], [-119.21176, 34.85645], [-119.21168, 34.85661], [-119.21156, 34.8568], [-119.21132, 34.85712], [-119.21077, 34.85763], [-119.208, 34.85771], [-119.20798, 34.85387], [-119.20347, 34.85379], [-119.20325, 34.8428], [-119.20756, 34.84279], [-119.20798, 34.85028], [-119.21208, 34.85022]]], [[[-119.21201, 34.8565], [-119.21199, 34.8576], [-119.21114, 34.85762], [-119.21153, 34.85726], [-119.21168, 34.85707], [-119.21192, 34.85669], [-119.21201, 34.8565]]]]} | Open Access 1 | 15343 | Westside Mountain Park | 27422 | 2178 | West Side Recreation and Park District 467 | Special District 4 | Recreation/Parks District 4 | http://www.wsrpd.com/ | Special District 4 | 2178 | West Side Recreation and Park District 460 | Special District 4 | Recreation/Parks District 4 | Kern 36 | 197.583 | Westside Mtn. Park | 0 | Local Park 2 | 4 | |
2812 | 2812 | 2811 | {"type": "MultiPolygon", "coordinates": [[[[-119.22941, 35.67311], [-119.22913, 35.67312], [-119.22913, 35.67358], [-119.22923, 35.67359], [-119.22923, 35.67373], [-119.22912, 35.67374], [-119.22912, 35.67385], [-119.22897, 35.67375], [-119.22887, 35.67372], [-119.22875, 35.6737], [-119.22825, 35.67369], [-119.22816, 35.67366], [-119.22806, 35.67345], [-119.2279, 35.67321], [-119.22781, 35.67312], [-119.22763, 35.67299], [-119.22755, 35.67296], [-119.22737, 35.67286], [-119.22682, 35.67274], [-119.22666, 35.67268], [-119.22653, 35.67252], [-119.22634, 35.67196], [-119.22801, 35.67193], [-119.22821, 35.67195], [-119.2294, 35.67193], [-119.22941, 35.67311]]], [[[-119.22712, 35.67297], [-119.2266, 35.673], [-119.22648, 35.67275], [-119.22661, 35.67283], [-119.22677, 35.67289], [-119.22712, 35.67297]]]]} | Open Access 1 | 12861 | McFarland Park | 22031 | 2075 | McFarland Recreation and Park District 557 | Special District 4 | Recreation/Parks District 4 | http://www.mcfarlandrpd.com/ | Special District 4 | 2075 | McFarland Recreation and Park District 550 | Special District 4 | Recreation/Parks District 4 | Kern 36 | 9.421 | McFarland Park | 0 | Local Park 2 | 4 | |
9122 | 9122 | 9121 | {"type": "MultiPolygon", "coordinates": [[[[-119.34483, 35.58715], [-119.34481, 35.58877], [-119.34272, 35.58876], [-119.34274, 35.58715], [-119.34483, 35.58715]]], [[[-119.34698, 35.58716], [-119.34695, 35.58877], [-119.34494, 35.58876], [-119.34496, 35.58715], [-119.34698, 35.58716]]]]} | Open Access 1 | 15122 | Barker Park | 15817 | 2175 | Wasco Recreation and Park District 465 | Special District 4 | Recreation/Parks District 4 | http://www.wascoparks.com/ | Special District 4 | 2175 | Wasco Recreation and Park District 458 | Special District 4 | Recreation/Parks District 4 | Kern 36 | 16.438 | Barker Park | 0 | Local Park 2 | 4 | |
9149 | 9149 | 9148 | {"type": "MultiPolygon", "coordinates": [[[[-119.35679, 35.5944], [-119.35679, 35.59501], [-119.35552, 35.59499], [-119.35551, 35.59442], [-119.35679, 35.5944]]], [[[-119.35739, 35.59678], [-119.35736, 35.59684], [-119.35448, 35.59686], [-119.35396, 35.59694], [-119.35382, 35.59691], [-119.35383, 35.59532], [-119.35443, 35.59527], [-119.35493, 35.59518], [-119.35701, 35.59518], [-119.35703, 35.59623], [-119.35708, 35.59638], [-119.35713, 35.59645], [-119.35732, 35.59665], [-119.35739, 35.59678]]]]} | Open Access 1 | 15181 | Westside Park | 27427 | 2175 | Wasco Recreation and Park District 465 | Special District 4 | Recreation/Parks District 4 | http://www.wascoparks.com/ | Special District 4 | 2175 | Wasco Recreation and Park District 458 | Special District 4 | Recreation/Parks District 4 | Kern 36 | 15.327 | Westside Park | 0 | Local Park 2 | 4 | |
9185 | 9185 | 9184 | {"type": "MultiPolygon", "coordinates": [[[[-119.44742, 35.15369], [-119.44736, 35.1537], [-119.44736, 35.15446], [-119.44283, 35.15448], [-119.43856, 35.15446], [-119.43858, 35.15264], [-119.43862, 35.15144], [-119.44741, 35.15143], [-119.44742, 35.15369]]], [[[-119.44785, 35.15654], [-119.44345, 35.15653], [-119.44343, 35.15646], [-119.44238, 35.15646], [-119.44237, 35.15533], [-119.43971, 35.15532], [-119.43971, 35.15463], [-119.44343, 35.15465], [-119.44743, 35.15465], [-119.44743, 35.15505], [-119.44756, 35.15505], [-119.44757, 35.15546], [-119.44763, 35.15584], [-119.44772, 35.1562], [-119.44785, 35.15654]]]]} | Open Access 1 | 15249 | Franklin Field | 19058 | 2178 | West Side Recreation and Park District 467 | Special District 4 | Recreation/Parks District 4 | http://www.wsrpd.com/ | Special District 4 | 2178 | West Side Recreation and Park District 460 | Special District 4 | Recreation/Parks District 4 | Kern 36 | 95.954 | Franklin Field | 0 | Local Recreation Area 3 | 4 | |
12608 | 12608 | 12607 | {"type": "MultiPolygon", "coordinates": [[[[-119.45531, 35.13801], [-119.45522, 35.13816], [-119.45478, 35.13802], [-119.45373, 35.13768], [-119.45312, 35.13744], [-119.45249, 35.13725], [-119.45209, 35.13709], [-119.45159, 35.13682], [-119.45087, 35.13639], [-119.45037, 35.13606], [-119.44908, 35.13514], [-119.44748, 35.13403], [-119.44727, 35.13392], [-119.4473, 35.13348], [-119.44756, 35.13364], [-119.44991, 35.13537], [-119.4512, 35.13627], [-119.45222, 35.13684], [-119.45271, 35.13712], [-119.45336, 35.13736], [-119.45451, 35.13772], [-119.45531, 35.13801]]], [[[-119.45822, 35.13891], [-119.4581, 35.13916], [-119.4554, 35.13828], [-119.45552, 35.13802], [-119.45822, 35.13891]]], [[[-119.46109, 35.13983], [-119.46097, 35.14009], [-119.45829, 35.13922], [-119.45841, 35.13897], [-119.45914, 35.1392], [-119.46109, 35.13983]]], [[[-119.47401, 35.14093], [-119.47399, 35.14122], [-119.47325, 35.14108], [-119.4726, 35.14102], [-119.47184, 35.14102], [-119.47112, 35.14109], [-119.47112, 35.14084], [-119.47114, 35.14081], [-119.47173, 35.14074], [-119.47226, 35.14073], [-119.47289, 35.14075], [-119.47345, 35.14082], [-119.47401, 35.14093]]], [[[-119.46504, 35.1414], [-119.46467, 35.14128], [-119.46121, 35.14017], [-119.46134, 35.13991], [-119.46448, 35.14093], [-119.46504, 35.14111], [-119.46504, 35.1414]]], [[[-119.47092, 35.14113], [-119.46832, 35.14167], [-119.46797, 35.14172], [-119.46752, 35.14176], [-119.4669, 35.14176], [-119.46637, 35.1417], [-119.46576, 35.14158], [-119.46524, 35.14142], [-119.46524, 35.14112], [-119.46577, 35.14129], [-119.46619, 35.14139], [-119.46667, 35.14146], [-119.46715, 35.14149], [-119.46772, 35.14147], [-119.46819, 35.1414], [-119.47086, 35.14085], [-119.4709, 35.14086], [-119.47092, 35.14089], [-119.47092, 35.14113]]], [[[-119.48286, 35.14322], [-119.48286, 35.14352], [-119.47428, 35.1413], [-119.47431, 35.14101], [-119.48286, 35.14322]]]]} | Open Access 1 | 29320 | Rails to Trails | 24080 | 2178 | West Side Recreation and Park District 467 | Special District 4 | Recreation/Parks District 4 | http://www.wsrpd.com/ | Special District 4 | 2178 | West Side Recreation and Park District 460 | Special District 4 | Recreation/Parks District 4 | Kern 36 | 25.313 | Rails to Trails | 0 | None 1093 | ||
9167 | 9167 | 9166 | {"type": "MultiPolygon", "coordinates": [[[[-119.45877, 35.15443], [-119.45775, 35.15442], [-119.45773, 35.1536], [-119.45876, 35.1536], [-119.45877, 35.15443]]], [[[-119.46007, 35.15443], [-119.45905, 35.15442], [-119.45903, 35.15361], [-119.46006, 35.15361], [-119.46007, 35.15443]]]]} | Open Access 1 | 15215 | Ford City Park | 18985 | 2178 | West Side Recreation and Park District 467 | Special District 4 | Recreation/Parks District 4 | http://www.wsrpd.com/ | Special District 4 | 2178 | West Side Recreation and Park District 460 | Special District 4 | Recreation/Parks District 4 | Kern 36 | 4.216 | Ford City Park | 0 | Local Park 2 | 4 | |
9901 | 9901 | 9900 | {"type": "MultiPolygon", "coordinates": [[[[-119.86321, 34.40908], [-119.86321, 34.40971], [-119.86305, 34.40971], [-119.86304, 34.40909], [-119.86321, 34.40908]]], [[[-119.86396, 34.40971], [-119.86379, 34.40971], [-119.86379, 34.40904], [-119.86396, 34.40902], [-119.86396, 34.40971]]], [[[-119.86429, 34.409], [-119.86429, 34.40971], [-119.86421, 34.40971], [-119.86421, 34.40901], [-119.86429, 34.409]]], [[[-119.86479, 34.40971], [-119.8647, 34.40971], [-119.8647, 34.40897], [-119.86479, 34.40896], [-119.86479, 34.40971]]], [[[-119.86758, 34.40971], [-119.86745, 34.40971], [-119.86745, 34.40933], [-119.86758, 34.40933], [-119.86758, 34.40971]]], [[[-119.86798, 34.40971], [-119.86772, 34.40971], [-119.86772, 34.40933], [-119.86798, 34.40933], [-119.86798, 34.40971]]], [[[-119.86846, 34.40936], [-119.86841, 34.40975], [-119.86828, 34.40973], [-119.86833, 34.40935], [-119.86846, 34.40936]]]]} | Open Access 1 | 16983 | Isla Vista Beach | 20278 | 2049 | Isla Vista Recreation and Park District 174 | Special District 4 | Recreation/Parks District 4 | http://www.ivparks.org/ | Special District 4 | 2049 | Isla Vista Recreation and Park District 170 | Special District 4 | Recreation/Parks District 4 | Santa Barbara 7 | 1.367 | Isla Vista Beach | 0 | Local Park 2 | 4 | |
10435 | 10435 | 10434 | {"type": "MultiPolygon", "coordinates": [[[[-119.86646, 34.4168], [-119.86644, 34.41722], [-119.86639, 34.41727], [-119.86446, 34.41727], [-119.86446, 34.41486], [-119.86644, 34.41486], [-119.86643, 34.41679], [-119.86646, 34.4168]]], [[[-119.8696, 34.41443], [-119.86827, 34.41444], [-119.86827, 34.41483], [-119.86794, 34.41484], [-119.86794, 34.41576], [-119.86827, 34.41577], [-119.86827, 34.41672], [-119.86775, 34.41672], [-119.86774, 34.41695], [-119.86712, 34.41729], [-119.86664, 34.41728], [-119.86665, 34.41384], [-119.86676, 34.41365], [-119.86692, 34.4135], [-119.86712, 34.41339], [-119.86731, 34.41333], [-119.86747, 34.41327], [-119.86761, 34.41318], [-119.86773, 34.41307], [-119.86783, 34.41294], [-119.86789, 34.41281], [-119.86797, 34.41246], [-119.86959, 34.4126], [-119.8696, 34.41443]]]]} | Open Access 1 | 1990 | Camino Corto Open Space | 16766 | 2049 | Isla Vista Recreation and Park District 174 | Special District 4 | Recreation/Parks District 4 | http://www.ivparks.org/ | Special District 4 | 2049 | Isla Vista Recreation and Park District 170 | Special District 4 | Recreation/Parks District 4 | Santa Barbara 7 | 33.509 | Camino Corto OS | 0 | Local Recreation Area 3 | 4 | |
16792 | 16792 | 16791 | {"type": "MultiPolygon", "coordinates": [[[[-120.23998, 37.95949], [-120.23997, 37.95991], [-120.23892, 37.95991], [-120.23892, 37.95953], [-120.23981, 37.95953], [-120.23998, 37.95949]]], [[[-120.26892, 37.96427], [-120.26882, 37.96433], [-120.26877, 37.96423], [-120.26884, 37.96418], [-120.26892, 37.96427]]], [[[-120.27003, 37.96481], [-120.26974, 37.96467], [-120.26921, 37.96408], [-120.26916, 37.96411], [-120.26906, 37.96403], [-120.26928, 37.9639], [-120.27003, 37.96481]]], [[[-120.30446, 37.97107], [-120.3044, 37.97145], [-120.30426, 37.97135], [-120.30363, 37.97066], [-120.30353, 37.97036], [-120.30314, 37.96985], [-120.30363, 37.96986], [-120.30414, 37.97067], [-120.30446, 37.97107]]], [[[-120.2998, 37.96957], [-120.29949, 37.96941], [-120.29843, 37.96904], [-120.29833, 37.96899], [-120.29815, 37.96884], [-120.29806, 37.96871], [-120.29798, 37.9685], [-120.29799, 37.96818], [-120.29801, 37.96798], [-120.29801, 37.96787], [-120.29796, 37.96776], [-120.29791, 37.96768], [-120.29776, 37.96755], [-120.29762, 37.96748], [-120.29738, 37.96742], [-120.29721, 37.96739], [-120.29702, 37.9674], [-120.29668, 37.96746], [-120.2966, 37.96749], [-120.29625, 37.96754], [-120.29607, 37.96754], [-120.29573, 37.96753], [-120.2956, 37.96749], [-120.2953, 37.9675], [-120.29503, 37.96757], [-120.29479, 37.96769], [-120.29452, 37.9679], [-120.29423, 37.96809], [-120.29387, 37.96822], [-120.29365, 37.96825], [-120.29344, 37.96825], [-120.29334, 37.96823], [-120.29308, 37.96816], [-120.2911, 37.96694], [-120.29082, 37.96674], [-120.29065, 37.96665], [-120.29043, 37.96659], [-120.29025, 37.96658], [-120.29001, 37.9666], [-120.28962, 37.96669], [-120.28864, 37.967], [-120.2871, 37.96746], [-120.28691, 37.96757], [-120.28673, 37.96771], [-120.28663, 37.9678], [-120.28652, 37.96794], [-120.28644, 37.96808], [-120.28636, 37.96835], [-120.28635, 37.96844], [-120.28637, 37.96869], [-120.28643, 37.96891], [-120.28658, 37.96921], [-120.2867, 37.96937], [-120.28771, 37.97031], [-120.288, 37.97069], [-120.28819, 37.97098], [-120.28832, 37.97121], [-120.28858, 37.97142], [-120.28911, 37.97191], [-120.28935, 37.97217], [-120.28964, 37.97254], [-120.28992, 37.97298], [-120.29004, 37.97332], [-120.29006, 37.97356], [-120.29003, 37.97385], [-120.28993, 37.97408], [-120.28976, 37.97434], [-120.28945, 37.97466], [-120.28914, 37.9749], [-120.28895, 37.97502], [-120.28858, 37.97524], [-120.28835, 37.97534], [-120.28803, 37.97543], [-120.28773, 37.97545], [-120.28754, 37.97544], [-120.28724, 37.97538], [-120.28712, 37.97534], [-120.28691, 37.97525], [-120.28597, 37.97469], [-120.28578, 37.97551], [-120.28556, 37.97552], [-120.28568, 37.97459], [-120.28567, 37.97448], [-120.28562, 37.97442], [-120.28501, 37.97385], [-120.28496, 37.97378], [-120.28478, 37.97356], [-120.28471, 37.97345], [-120.28469, 37.97338], [-120.28454, 37.97304], [-120.28429, 37.97252], [-120.28413, 37.97237], [-120.28398, 37.97227], [-120.28379, 37.97211], [-120.28356, 37.97196], [-120.28346, 37.97186], [-120.28329, 37.97156], [-120.2831, 37.97097], [-120.28298, 37.97075], [-120.28279, 37.97057], [-120.28253, 37.97042], [-120.28238, 37.97036], [-120.2822, 37.97032], [-120.28206, 37.97033], [-120.28185, 37.97042], [-120.28138, 37.9707], [-120.28088, 37.97122], [-120.28079, 37.97134], [-120.28042, 37.97169], [-120.28027, 37.97177], [-120.28004, 37.97183], [-120.27995, 37.97181], [-120.27996, 37.97172], [-120.27995, 37.97171], [-120.27922, 37.9719], [-120.27903, 37.97193], [-120.27874, 37.97195], [-120.27859, 37.97193], [-120.27848, 37.97186], [-120.2784, 37.97183], [-120.2782, 37.9717], [-120.27795, 37.97147], [-120.27783, 37.97133], [-120.27773, 37.97116], [-120.27771, 37.97107], [-120.27772, 37.9709], [-120.27779, 37.97069], [-120.27787, 37.97052], [-120.27802, 37.97033], [-120.27874, 37.96953], [-120.27893, 37.96925], [-120.27945, 37.96817], [-120.27982, 37.9673], [-120.27988, 37.96702], [-120.27987, 37.96688], [-120.27989, 37.96676], [-120.27986, 37.96668], [-120.27979, 37.96651], [-120.2797, 37.9664], [-120.27944, 37.96617], [-120.2793, 37.96612], [-120.27921, 37.96606], [-120.27903, 37.96598], [-120.27879, 37.9659], [-120.27856, 37.96585], [-120.27817, 37.96586], [-120.27787, 37.96596], [-120.27774, 37.96603], [-120.27734, 37.96631], [-120.27646, 37.96743], [-120.27633, 37.96752], [-120.27614, 37.96761], [-120.27577, 37.96773], [-120.27541, 37.96779], [-120.2751, 37.96781], [-120.27479, 37.9678], [-120.27423, 37.96774], [-120.27383, 37.96767], [-120.27357, 37.96755], [-120.27352, 37.96752], [-120.27348, 37.96747], [-120.27379, 37.96733], [-120.27408, 37.96743], [-120.27437, 37.96749], [-120.27473, 37.96752], [-120.27519, 37.96751], [-120.27545, 37.96747], [-120.27562, 37.96743], [-120.27579, 37.96736], [-120.27602, 37.96721], [-120.27668, 37.96644], [-120.277, 37.96612], [-120.27724, 37.96593], [-120.27757, 37.96571], [-120.2778, 37.9656], [-120.2781, 37.96552], [-120.27838, 37.96552], [-120.27856, 37.96553], [-120.27886, 37.9656], [-120.27905, 37.96567], [-120.27927, 37.96578], [-120.27969, 37.96604], [-120.27983, 37.96616], [-120.27994, 37.96619], [-120.28006, 37.96632], [-120.28016, 37.96645], [-120.28025, 37.96666], [-120.28025, 37.96695], [-120.28021, 37.96706], [-120.28017, 37.96728], [-120.27966, 37.96833], [-120.27937, 37.96897], [-120.27933, 37.96913], [-120.27927, 37.96927], [-120.2792, 37.96941], [-120.27905, 37.96965], [-120.27883, 37.9699], [-120.27829, 37.97045], [-120.27813, 37.97069], [-120.27808, 37.97083], [-120.27805, 37.97098], [-120.27805, 37.97106], [-120.27812, 37.97123], [-120.27815, 37.97128], [-120.27837, 37.97148], [-120.2785, 37.97155], [-120.27871, 37.97162], [-120.27881, 37.97163], [-120.27937, 37.97161], [-120.28004, 37.97147], [-120.28014, 37.97144], [-120.28031, 37.97135], [-120.28055, 37.97114], [-120.28081, 37.97102], [-120.28085, 37.97095], [-120.28132, 37.97054], [-120.28144, 37.97046], [-120.28181, 37.97011], [-120.28203, 37.97003], [-120.2824, 37.96997], [-120.28253, 37.97], [-120.2827, 37.97008], [-120.28305, 37.97034], [-120.28319, 37.97047], [-120.28332, 37.97062], [-120.28339, 37.97068], [-120.28355, 37.97098], [-120.28356, 37.97107], [-120.28368, 37.97147], [-120.28382, 37.97169], [-120.28396, 37.97186], [-120.28427, 37.97207], [-120.28459, 37.97239], [-120.2847, 37.97261], [-120.2848, 37.97275], [-120.28481, 37.97281], [-120.28509, 37.97331], [-120.28512, 37.97336], [-120.28514, 37.97342], [-120.28541, 37.9738], [-120.28579, 37.97423], [-120.28586, 37.97427], [-120.28592, 37.97435], [-120.28602, 37.97445], [-120.28685, 37.97497], [-120.28701, 37.97504], [-120.28725, 37.97511], [-120.28766, 37.97516], [-120.28799, 37.9751], [-120.28821, 37.97503], [-120.28883, 37.97468], [-120.28908, 37.97451], [-120.28922, 37.97438], [-120.28946, 37.9741], [-120.28954, 37.97391], [-120.28958, 37.97374], [-120.28945, 37.97369], [-120.28939, 37.97364], [-120.28938, 37.97356], [-120.28943, 37.97345], [-120.28957, 37.97339], [-120.28958, 37.97324], [-120.28951, 37.97307], [-120.28935, 37.97279], [-120.28917, 37.97256], [-120.28903, 37.9724], [-120.28826, 37.97168], [-120.28807, 37.97153], [-120.28783, 37.97128], [-120.28743, 37.97059], [-120.28707, 37.9702], [-120.28631, 37.96952], [-120.28601, 37.9691], [-120.28592, 37.96878], [-120.2859, 37.9684], [-120.28596, 37.96799], [-120.28602, 37.96783], [-120.28611, 37.9677], [-120.28627, 37.96752], [-120.28648, 37.96736], [-120.28676, 37.96721], [-120.28691, 37.96715], [-120.28932, 37.96645], [-120.2895, 37.96638], [-120.28993, 37.96627], [-120.29017, 37.96627], [-120.29053, 37.96629], [-120.29081, 37.96638], [-120.29104, 37.96647], [-120.29332, 37.96789], [-120.29362, 37.96795], [-120.29374, 37.96795], [-120.29404, 37.96787], [-120.29415, 37.9678], [-120.29456, 37.96751], [-120.29468, 37.96744], [-120.29505, 37.96729], [-120.29523, 37.96725], [-120.2955, 37.96723], [-120.29634, 37.9673], [-120.29701, 37.96717], [-120.29735, 37.96716], [-120.29758, 37.96717], [-120.2978, 37.96723], [-120.29809, 37.96736], [-120.29822, 37.96746], [-120.29835, 37.96762], [-120.2984, 37.96773], [-120.29842, 37.96782], [-120.2984, 37.96837], [-120.29844, 37.96852], [-120.2985, 37.9686], [-120.29863, 37.96872], [-120.29879, 37.96882], [-120.2998, 37.96919], [-120.2998, 37.96957]]], [[[-120.18548, 37.99156], [-120.18544, 37.9952], [-120.18086, 37.99522], [-120.18089, 37.99158], [-120.18548, 37.99156]]]]} | Open Access 1 | 611 | Tuolumne Park and Recreation District | 26578 | 2169 | Tuolumne Park and Recreation District 741 | Special District 4 | Recreation/Parks District 4 | http://www.tuolumnerecreation.com/ | Special District 4 | 2169 | Tuolumne Park and Recreation District 726 | Special District 4 | Recreation/Parks District 4 | Tuolumne 21 | 85.399 | Tuolumne Park and Rec. District | 0 | Local Recreation Area 3 | 4 | |
14269 | 14269 | 14268 | {"type": "MultiPolygon", "coordinates": [[[[-121.02494, 38.99785], [-121.02393, 38.99791], [-121.02363, 38.99776], [-121.02283, 38.99767], [-121.023, 38.99692], [-121.02465, 38.99688], [-121.02494, 38.99785]]], [[[-121.02542, 38.99876], [-121.02443, 38.99884], [-121.02388, 38.99806], [-121.02516, 38.99798], [-121.02542, 38.99876]]]]} | Open Access 1 | 44192 | Placer Hills Park | 23763 | 2004 | Auburn Area Recreation and Park District 700 | Special District 4 | Recreation/Parks District 4 | http://auburnrec.com/ | Special District 4 | 2004 | Auburn Area Recreation and Park District 447 | Special District 4 | Recreation/Parks District 4 | http://www.auburnrec.com/parks_placer-hills.php | Placer 35 | 6.283 | Placer Hills Park | 0 | Local Park 2 | 4 |
11222 | 11222 | 11221 | {"type": "MultiPolygon", "coordinates": [[[[-121.03745, 38.95721], [-121.03709, 38.95795], [-121.03689, 38.95845], [-121.03671, 38.95873], [-121.03598, 38.95955], [-121.03574, 38.95986], [-121.03541, 38.96038], [-121.0353, 38.96067], [-121.03422, 38.96068], [-121.03418, 38.96038], [-121.03427, 38.9602], [-121.03401, 38.95986], [-121.03387, 38.95963], [-121.03366, 38.95954], [-121.03325, 38.95969], [-121.03316, 38.95968], [-121.03311, 38.95927], [-121.03311, 38.95906], [-121.03322, 38.95893], [-121.03337, 38.9589], [-121.03374, 38.9589], [-121.03389, 38.95883], [-121.034, 38.95871], [-121.03411, 38.95853], [-121.03444, 38.95869], [-121.03539, 38.95784], [-121.03643, 38.95726], [-121.03666, 38.95719], [-121.03689, 38.95714], [-121.03725, 38.95712], [-121.03745, 38.95721]]], [[[-121.08528, 38.98459], [-121.08516, 38.98556], [-121.08401, 38.98557], [-121.08403, 38.98528], [-121.08431, 38.98491], [-121.08458, 38.98476], [-121.08528, 38.98459]]], [[[-121.08869, 38.98555], [-121.08869, 38.98555], [-121.0866, 38.98555], [-121.08785, 38.9849], [-121.08814, 38.9848], [-121.08868, 38.98429], [-121.08869, 38.98555]]], [[[-121.09018, 38.98115], [-121.08998, 38.98112], [-121.08999, 38.98097], [-121.08996, 38.98079], [-121.08987, 38.98062], [-121.08974, 38.98049], [-121.0899, 38.98033], [-121.0899, 38.98038], [-121.09006, 38.98056], [-121.09016, 38.98075], [-121.0902, 38.98095], [-121.09018, 38.98115]]]]} | Open Access 1 | 21556 | Christian Valley Park | 17226 | 2004 | Auburn Area Recreation and Park District 700 | Special District 4 | Recreation/Parks District 4 | http://auburnrec.com/ | Special District 4 | 2004 | Auburn Area Recreation and Park District 447 | Special District 4 | Recreation/Parks District 4 | http://www.auburnrec.com/parks_christian-valley.php | Placer 35 | 21.912 | Christian Valley Park | 0 | Local Park 2 | 4 |
16206 | 16206 | 16205 | {"type": "MultiPolygon", "coordinates": [[[[-121.25745, 38.71827], [-121.25706, 38.71836], [-121.25661, 38.71824], [-121.25604, 38.71835], [-121.25531, 38.7183], [-121.25481, 38.7183], [-121.25458, 38.71785], [-121.25377, 38.71788], [-121.25328, 38.7182], [-121.25312, 38.71819], [-121.25286, 38.71813], [-121.25264, 38.71812], [-121.25257, 38.71784], [-121.25237, 38.71788], [-121.25149, 38.71703], [-121.25155, 38.717], [-121.25163, 38.71644], [-121.25132, 38.71635], [-121.25131, 38.71616], [-121.2509, 38.71615], [-121.25093, 38.71604], [-121.25088, 38.71596], [-121.25078, 38.71592], [-121.25061, 38.71591], [-121.25062, 38.71554], [-121.25014, 38.71543], [-121.25015, 38.71537], [-121.24976, 38.71477], [-121.24969, 38.71478], [-121.24951, 38.71459], [-121.24941, 38.71442], [-121.24946, 38.71417], [-121.24989, 38.714], [-121.24981, 38.71437], [-121.25022, 38.71465], [-121.25022, 38.71501], [-121.25049, 38.71539], [-121.25132, 38.71542], [-121.25177, 38.71557], [-121.25215, 38.71577], [-121.2526, 38.71618], [-121.25276, 38.71637], [-121.25277, 38.71658], [-121.25261, 38.71688], [-121.25297, 38.71734], [-121.25333, 38.71738], [-121.25374, 38.71722], [-121.25376, 38.71752], [-121.25438, 38.71751], [-121.25463, 38.71726], [-121.2548, 38.71733], [-121.25492, 38.71737], [-121.25509, 38.7178], [-121.25531, 38.7178], [-121.2561, 38.71779], [-121.25611, 38.71739], [-121.25646, 38.71738], [-121.25695, 38.7173], [-121.25696, 38.71737], [-121.25722, 38.71769], [-121.2574, 38.71774], [-121.25738, 38.71787], [-121.25739, 38.71803], [-121.25745, 38.71827]]], [[[-121.26254, 38.71962], [-121.26116, 38.71952], [-121.26128, 38.71921], [-121.26101, 38.71881], [-121.26072, 38.71861], [-121.26024, 38.71858], [-121.26019, 38.71897], [-121.25863, 38.71886], [-121.25863, 38.71854], [-121.25823, 38.71839], [-121.25818, 38.71824], [-121.2577, 38.7182], [-121.25763, 38.71822], [-121.25758, 38.71806], [-121.25757, 38.71792], [-121.25758, 38.71779], [-121.25762, 38.71768], [-121.25763, 38.71764], [-121.25811, 38.71778], [-121.25821, 38.71765], [-121.25843, 38.7178], [-121.25868, 38.71794], [-121.25896, 38.71806], [-121.25924, 38.71814], [-121.25971, 38.71822], [-121.26008, 38.71788], [-121.2606, 38.71806], [-121.26089, 38.71821], [-121.26131, 38.71847], [-121.26162, 38.71861], [-121.26184, 38.71867], [-121.26209, 38.71872], [-121.26253, 38.71873], [-121.26254, 38.71962]]]]} | Open Access 1 | 44064 | Edgecliff/Cripple Creek Open Space | 18434 | 2199 | Sunrise Recreation and Park District 650 | Special District 4 | Recreation/Parks District 4 | http://sunriseparks.com/ | Special District 4 | 2199 | Sunrise Recreation and Park District 639 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 24.487 | Edgecliff/Cripple Creek OS | 0 | Local Recreation Area 3 | 4 | |
3156 | 3156 | 3155 | {"type": "MultiPolygon", "coordinates": [[[[-121.27744, 38.58545], [-121.27749, 38.58543], [-121.27781, 38.58545], [-121.2781, 38.58543], [-121.27816, 38.58544], [-121.27819, 38.58548], [-121.27837, 38.58605], [-121.27836, 38.58611], [-121.27831, 38.58614], [-121.27812, 38.58617], [-121.2774, 38.58624], [-121.27733, 38.58622], [-121.2773, 38.58617], [-121.27731, 38.58598], [-121.27741, 38.58549], [-121.27744, 38.58545]]], [[[-121.27804, 38.58653], [-121.27742, 38.5866], [-121.27737, 38.58635], [-121.27798, 38.5863], [-121.27804, 38.58653]]]]} | Open Access 1 | 25939 | Renaissance Park | 24292 | 2193 | Cordova Recreation and Park District 307 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.com/ | Special District 4 | 2193 | Cordova Recreation and Park District 304 | Special District 4 | Recreation/Parks District 4 | https://crpd.com/parks/renaissance-park/ | Sacramento 41 | 2.064 | Renaissance 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]);