units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
167 rows where MNG_AGENCY = 87
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, COUNTY, GAP_STS
DES_TP 25
- Local Park 76
- Local Conservation Area 40
- Local Recreation Area 28
- Local Resource Management Area 2
- Local Historic or Cultural Area 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 3
- Open Access 101
- No Public Access 47
- Restricted Access 19
MNG_AG_TYP 1
MNG_AGENCY 1
- East Bay Regional Park District · 167 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 218 | 218 | 217 | {"type": "MultiPolygon", "coordinates": [[[[-122.00283, 37.56787], [-122.00528, 37.56886], [-122.00536, 37.56876], [-122.00637, 37.56915], [-122.00646, 37.56905], [-122.00694, 37.56924], [-122.00841, 37.57037], [-122.00605, 37.57247], [-122.00581, 37.57272], [-122.00563, 37.57245], [-122.00561, 37.57245], [-122.00486, 37.57485], [-122.00167, 37.57418], [-122.00088, 37.57663], [-122.00033, 37.5765], [-121.99656, 37.57363], [-121.99685, 37.57277], [-121.99721, 37.57285], [-121.99723, 37.57284], [-121.99743, 37.56696], [-121.99852, 37.56669], [-121.99871, 37.5667], [-121.9987, 37.56677], [-121.99916, 37.56686], [-121.99961, 37.56698], [-122.00112, 37.56756], [-122.0012, 37.56746], [-122.00224, 37.56786], [-122.00235, 37.56771], [-122.00283, 37.56787]]], [[[-122.00227, 37.57706], [-122.00224, 37.57716], [-122.00227, 37.57718], [-122.00203, 37.57784], [-122.0005, 37.57666], [-122.00227, 37.57706]]], [[[-122.01347, 37.57268], [-122.01183, 37.57446], [-122.01014, 37.57619], [-122.00994, 37.57635], [-122.00973, 37.57651], [-122.00895, 37.57696], [-122.00821, 37.57742], [-122.00796, 37.57759], [-122.0077, 37.57782], [-122.00748, 37.57808], [-122.0073, 37.57835], [-122.00718, 37.57862], [-122.00706, 37.5786], [-122.00686, 37.57917], [-122.00811, 37.57947], [-122.00818, 37.57956], [-122.00772, 37.58092], [-122.00605, 37.58056], [-122.00568, 37.58164], [-122.00418, 37.58051], [-122.00216, 37.57896], [-122.00209, 37.57889], [-122.00203, 37.5788], [-122.00198, 37.57866], [-122.002, 37.57851], [-122.00244, 37.57734], [-122.00248, 37.57728], [-122.00258, 37.57724], [-122.003, 37.57733], [-122.00424, 37.57807], [-122.00588, 37.57674], [-122.00592, 37.57631], [-122.01114, 37.57138], [-122.01347, 37.57268]]]]} | Open Access 1 | 586 | Quarry Lakes Regional Recreation Area | 30594 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 254.616 | Quarry Lakes Reg. Rec. Area | 2001 | Local Recreation Area 3 | 4 | |
| 576 | 576 | 575 | {"type": "Polygon", "coordinates": [[[-122.14526, 37.74311], [-122.14524, 37.74315], [-122.14492, 37.74341], [-122.14434, 37.74398], [-122.14423, 37.74406], [-122.1437, 37.7433], [-122.14342, 37.74306], [-122.14482, 37.7425], [-122.14526, 37.74311]]]} | Open Access 1 | 3448 | Poaks Headquarters | 23819 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 3.419 | Poaks Headquarters | None 57 | |||
| 1218 | 1218 | 1217 | {"type": "MultiPolygon", "coordinates": [[[[-122.1451, 37.64851], [-122.14511, 37.64897], [-122.14509, 37.64903], [-122.14501, 37.64917], [-122.14486, 37.64934], [-122.14456, 37.64957], [-122.14429, 37.64973], [-122.14412, 37.64979], [-122.14409, 37.64745], [-122.14507, 37.64744], [-122.1451, 37.64851]]], [[[-122.14586, 37.6471], [-122.14517, 37.64711], [-122.14517, 37.64682], [-122.14586, 37.64682], [-122.14586, 37.6471]]]]} | Open Access 1 | 8671 | Hayward Shoreline | 19762 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 5.421 | Hayward Shoreline | 1977 | Local Park 2 | 4 | |
| 2090 | 2090 | 2089 | {"type": "Polygon", "coordinates": [[[-122.05671, 37.55736], [-122.0544, 37.55828], [-122.05314, 37.5588], [-122.04939, 37.56032], [-122.04849, 37.56072], [-122.04831, 37.56073], [-122.04627, 37.56161], [-122.04605, 37.56164], [-122.04542, 37.56193], [-122.04503, 37.56213], [-122.0441, 37.56252], [-122.0439, 37.56253], [-122.04307, 37.56293], [-122.04186, 37.56437], [-122.04173, 37.56445], [-122.04168, 37.56459], [-122.04131, 37.56503], [-122.0412, 37.56504], [-122.04107, 37.56502], [-122.04083, 37.56479], [-122.04047, 37.56459], [-122.0404, 37.56449], [-122.04033, 37.56428], [-122.04031, 37.56414], [-122.04031, 37.56402], [-122.04036, 37.56354], [-122.04036, 37.56327], [-122.0403, 37.56299], [-122.04025, 37.56288], [-122.04027, 37.56275], [-122.0403, 37.56263], [-122.04065, 37.56208], [-122.04081, 37.5619], [-122.04066, 37.56181], [-122.04149, 37.56063], [-122.04314, 37.55856], [-122.04394, 37.5578], [-122.04503, 37.55688], [-122.04532, 37.55689], [-122.04642, 37.55805], [-122.04676, 37.55788], [-122.04654, 37.55734], [-122.04642, 37.55712], [-122.04632, 37.55697], [-122.0459, 37.55665], [-122.04582, 37.55652], [-122.0458, 37.55642], [-122.0468, 37.55556], [-122.04925, 37.55413], [-122.05039, 37.55358], [-122.05071, 37.55347], [-122.0528, 37.5525], [-122.05356, 37.55289], [-122.05494, 37.55332], [-122.05588, 37.55343], [-122.05671, 37.55736]]]} | Open Access 1 | 17282 | Ardenwood Historic Farm | 3820 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/parks/ardenwood | Alameda 17 | 202.709 | Ardenwood Historic Farm | 1985 | Local Historic or Cultural Area 19 | 4 |
| 2356 | 2356 | 2355 | {"type": "Polygon", "coordinates": [[[-121.7508, 38.02106], [-121.7506, 38.02106], [-121.75061, 38.02096], [-121.75065, 38.02095], [-121.75065, 38.01964], [-121.75066, 38.01963], [-121.75067, 38.01953], [-121.75076, 38.01953], [-121.75075, 38.02095], [-121.7508, 38.02096], [-121.7508, 38.02106]]]} | Open Access 1 | 17112 | Antioch Bridge Fishing Pier | 15522 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 0.397 | Antioch Bridge Fishing Pier | None 198 | |||
| 3202 | 3202 | 3201 | {"type": "MultiPolygon", "coordinates": [[[[-121.94564, 37.63101], [-121.9403, 37.63339], [-121.94035, 37.63646], [-121.93102, 37.63656], [-121.93099, 37.63583], [-121.92155, 37.63602], [-121.92155, 37.63572], [-121.92165, 37.63558], [-121.92203, 37.63535], [-121.92186, 37.63512], [-121.92191, 37.63508], [-121.92192, 37.63502], [-121.92181, 37.63473], [-121.92198, 37.63455], [-121.92215, 37.63433], [-121.92218, 37.63422], [-121.92219, 37.63403], [-121.92224, 37.63369], [-121.92219, 37.63354], [-121.92222, 37.6334], [-121.92218, 37.63337], [-121.92228, 37.6333], [-121.92269, 37.63311], [-121.92266, 37.63307], [-121.92256, 37.63311], [-121.92239, 37.63288], [-121.92193, 37.63309], [-121.92187, 37.63313], [-121.92146, 37.63291], [-121.92134, 37.63312], [-121.9207, 37.63207], [-121.91998, 37.63157], [-121.92038, 37.6315], [-121.92081, 37.63135], [-121.92111, 37.63109], [-121.92181, 37.63114], [-121.92187, 37.63073], [-121.92185, 37.63067], [-121.92209, 37.63045], [-121.92142, 37.62996], [-121.92139, 37.62996], [-121.92138, 37.62956], [-121.92101, 37.62958], [-121.92, 37.6297], [-121.91948, 37.6298], [-121.91884, 37.6299], [-121.91869, 37.62969], [-121.91875, 37.62961], [-121.91874, 37.62943], [-121.91872, 37.62941], [-121.91854, 37.62914], [-121.9183, 37.62891], [-121.91773, 37.62928], [-121.91675, 37.62942], [-121.91663, 37.62953], [-121.91639, 37.62881], [-121.91577, 37.62894], [-121.91538, 37.62912], [-121.91533, 37.62916], [-121.91509, 37.62924], [-121.91487, 37.62889], [-121.9146, 37.62864], [-121.91435, 37.62822], [-121.91409, 37.62827], [-121.91371, 37.62786], [-121.91431, 37.62742], [-121.91481, 37.62728], [-121.9147, 37.62703], [-121.91446, 37.6271], [-121.91444, 37.62706], [-121.91468, 37.62699], [-121.91489, 37.62673], [-121.91462, 37.62658], [-121.91454, 37.62667], [-121.91456, 37.62673], [-121.91387, 37.62693], [-121.91335, 37.62728], [-121.91336, 37.62711], [-121.91325, 37.62675], [-121.91283, 37.62679], [-121.9128, 37.62666], [-121.91216, 37.62673], [-121.91216, 37.62655], [-121.91209, 37.62635], [-121.91198, 37.62619], [-121.91172, 37.62591], [-121.9116, 37.62553], [-121.91146, 37.62533], [-121.91125, 37.62519], [-121.91109, 37.62513], [-121.91085, 37.62508], [-121.91077, 37.62504], [-121.91071, 37.62498], [-121.91065, 37.62474], [-121.91059, 37.62458], [-121.91049, 37.62445], [-121.91037, 37.62436], [-121.9102, 37.62429], [-121.91009, 37.62426], [-121.90983, 37.62423], [-121.90971, 37.6242], [-121.90962, 37.62413], [-121.90955, 37.624], [-121.90947, 37.6239], [-121.90926, 37.62377], [-121.90895, 37.62369], [-121.9088, 37.62368], [-121.90891, 37.6235], [-121.90866, 37.62341], [-121.90831, 37.62293], [-121.90813, 37.62247], [-121.9084, 37.62222], [-121.9084, 37.62183], [-121.90799, 37.62183], [-121.90767, 37.62191], [-121.9076, 37.62189], [-121.90754, 37.62186], [-121.90699, 37.62125], [-121.90692, 37.62114], [-121.9069, 37.62105], [-121.90691, 37.62096], [-121.90706, 37.62062], [-121.90706, 37.62056], [-121.90703, 37.6205], [-121.90697, 37.62045], [-121.90636, 37.62007], [-121.90616, 37.61984], [-121.9057, 37.61946], [-121.90569, 37.61941], [-121.90573, 37.61936], [-121.90593, 37.61934], [-121.90605, 37.61926], [-121.90608, 37.6192], [-121.90609, 37.61914], [-121.90604, 37.61904], [-121.90594, 37.61896], [-121.9058, 37.61891], [-121.90494, 37.6188], [-121.90476, 37.61871], [-121.90464, 37.61859], [-121.9046, 37.61848], [-121.90458, 37.61837], [-121.90469, 37.61771], [-121.90466, 37.61728], [-121.90454, 37.61729], [-121.9045, 37.61733], [-121.90444, 37.61733], [-121.90418, 37.61699], [-121.9041, 37.61692], [-121.90402, 37.61689], [-121.90298, 37.61664], [-121.90294, 37.61662], [-121.90289, 37.61658], [-121.90287, 37.61653], [-121.90288, 37.61647], [-121.90299, 37.61627], [-121.90304, 37.61614], [-121.90306, 37.61601], [-121.90304, 37.61588], [-121.90281, 37.61532], [-121.90232, 37.61491], [-121.90213, 37.61465], [-121.90246, 37.6145], [-121.90247, 37.61449], [-121.90245, 37.61447], [-121.90211, 37.61463], [-121.90206, 37.61455], [-121.90202, 37.61445], [-121.90201, 37.61434], [-121.90206, 37.61398], [-121.90202, 37.61389], [-121.90196, 37.61385], [-121.90176, 37.61385], [-121.9015, 37.61398], [-121.90139, 37.61401], [-121.90126, 37.61402], [-121.90064, 37.61397], [-121.89991, 37.61409], [-121.89979, 37.61407], [-121.89971, 37.614], [-121.89969, 37.61392], [-121.90052, 37.61356], [-121.90054, 37.6135], [-121.90064, 37.61348], [-121.90075, 37.61343], [-121.90091, 37.61328], [-121.90093, 37.61323], [-121.90091, 37.61316], [-121.90097, 37.6132], [-121.90105, 37.61324], [-121.9012, 37.61326], [-121.90129, 37.61322], [-121.90153, 37.61325], [-121.90166, 37.6133], [-121.90184, 37.61297], [-121.89654, 37.60588], [-121.89627, 37.60601], [-121.89625, 37.60364], [-121.8942, 37.60365], [-121.89419, 37.59988], [-121.89706, 37.59992], [-121.89707, 37.59991], [-121.89605, 37.5986], [-121.89418, 37.59857], [-121.89417, 37.59428], [-121.89645, 37.59448], [-121.89645, 37.59476], [-121.89792, 37.5949], [-121.89856, 37.59499], [-121.89904, 37.59509], [-121.89975, 37.59527], [-121.90211, 37.59598], [-121.90194, 37.59641], [-121.90179, 37.59766], [-121.9018, 37.59767], [-121.90388, 37.59749], [-121.90405, 37.59631], [-121.9048, 37.5963], [-121.90512, 37.59628], [-121.90566, 37.59621], [-121.90618, 37.5961], [-121.90807, 37.59561], [-121.90819, 37.59743], [-121.90819, 37.59978], [-121.90776, 37.60027], [-121.91431, 37.6033], [-121.91439, 37.60736], [-121.94393, 37.60721], [-121.94075, 37.61037], [-121.94126, 37.61098], [-121.94103, 37.6114], [-121.9408, 37.61149], [-121.94056, 37.61153], [-121.94024, 37.61166], [-121.94017, 37.61184], [-121.94036, 37.61205], [-121.94042, 37.61224], [-121.94009, 37.61262], [-121.94008, 37.61281], [-121.93995, 37.61324], [-121.93993, 37.61356], [-121.93978, 37.61385], [-121.93978, 37.61417], [-121.93998, 37.6144], [-121.94029, 37.61469], [-121.94007, 37.61506], [-121.94045, 37.61589], [-121.94251, 37.61604], [-121.94317, 37.6157], [-121.94392, 37.61657], [-121.94402, 37.61684], [-121.94386, 37.61723], [-121.94359, 37.61747], [-121.9433, 37.61754], [-121.94308, 37.6177], [-121.94282, 37.61795], [-121.94265, 37.61816], [-121.94267, 37.6184], [-121.94282, 37.61875], [-121.94288, 37.61895], [-121.94295, 37.6195], [-121.9429, 37.62035], [-121.94287, 37.62058], [-121.94257, 37.62081], [-121.94265, 37.62106], [-121.94245, 37.62131], [-121.9424, 37.62136], [-121.94194, 37.62136], [-121.94171, 37.62154], [-121.9414, 37.62232], [-121.9414, 37.623], [-121.94101, 37.623], [-121.941, 37.62301], [-121.94169, 37.62521], [-121.94236, 37.62526], [-121.94349, 37.62491], [-121.94356, 37.62498], [-121.94358, 37.62503], [-121.94222, 37.62544], [-121.94281, 37.62661], [-121.94252, 37.6267], [-121.94252, 37.62671], [-121.94403, 37.62821], [-121.9429, 37.62878], [-121.9429, 37.62879], [-121.9435, 37.6295], [-121.94359, 37.62945], [-121.94417, 37.63014], [-121.94447, 37.63], [-121.94513, 37.63081], [-121.94542, 37.6307], [-121.94564, 37.63101]], [[-121.91707, 37.62494], [-121.91744, 37.62531], [-121.918, 37.62497], [-121.91761, 37.62459], [-121.91715, 37.62465], [-121.91707, 37.62494]], [[-121.92269, 37.61992], [-121.92282, 37.61999], [-121.92314, 37.61967], [-121.92289, 37.6195], [-121.92261, 37.61976], [-121.92216, 37.6197], [-121.92206, 37.62015], [-121.92236, 37.62035], [-121.92254, 37.62018], [-121.92247, 37.62013], [-121.92269, 37.61992]]], [[[-121.90282, 37.61628], [-121.90277, 37.61629], [-121.90272, 37.61627], [-121.9025, 37.6159], [-121.90209, 37.61541], [-121.90118, 37.61478], [-121.90097, 37.61468], [-121.90069, 37.61461], [-121.90053, 37.6146], [-121.89999, 37.61461], [-121.89982, 37.61457], [-121.89943, 37.6143], [-121.89926, 37.61411], [-121.89956, 37.61398], [-121.8996, 37.61407], [-121.89967, 37.61413], [-121.89975, 37.61418], [-121.89985, 37.6142], [-121.89995, 37.6142], [-121.90065, 37.61408], [-121.90134, 37.61413], [-121.90154, 37.61408], [-121.90183, 37.61394], [-121.9019, 37.61395], [-121.90192, 37.614], [-121.90186, 37.61434], [-121.90187, 37.61444], [-121.9019, 37.61454], [-121.90195, 37.61464], [-121.90218, 37.61496], [-121.90266, 37.61534], [-121.9027, 37.61539], [-121.90291, 37.61596], [-121.9029, 37.61612], [-121.90282, 37.61628]]], [[[-121.90642, 37.62025], [-121.90608, 37.62061], [-121.90523, 37.62026], [-121.90517, 37.62021], [-121.90512, 37.62015], [-121.90505, 37.61987], [-121.90496, 37.61976], [-121.90443, 37.61926], [-121.90394, 37.61899], [-121.90384, 37.61885], [-121.90383, 37.61881], [-121.90396, 37.61853], [-121.90401, 37.61826], [-121.90413, 37.61786], [-121.90415, 37.61775], [-121.90413, 37.61764], [-121.90409, 37.61755], [-121.90402, 37.61746], [-121.90333, 37.61695], [-121.90331, 37.61692], [-121.90333, 37.61688], [-121.9034, 37.61686], [-121.90393, 37.61698], [-121.90401, 37.61701], [-121.90407, 37.61706], [-121.90454, 37.6177], [-121.90455, 37.61777], [-121.90444, 37.61839], [-121.90447, 37.61855], [-121.90453, 37.61867], [-121.90468, 37.61881], [-121.90489, 37.61891], [-121.90502, 37.61894], [-121.90576, 37.61902], [-121.90584, 37.61905], [-121.90592, 37.6191], [-121.90595, 37.61916], [-121.90591, 37.61922], [-121.9057, 37.61924], [-121.9056, 37.6193], [-121.90555, 37.61939], [-121.90556, 37.61949], [-121.90561, 37.61956], [-121.90605, 37.61991], [-121.90622, 37.62012], [-121.90642, 37.62025]]], [[[-121.92749, 37.65025], [-121.92749, 37.65388], [-121.92329, 37.65388], [-121.92318, 37.65373], [-121.92304, 37.65359], [-121.92238, 37.65312], [-121.92224, 37.65323], [-121.92288, 37.65369], [-121.923, 37.65381], [-121.92312, 37.65397], [-121.92319, 37.65412], [-121.92322, 37.65427], [-121.9233, 37.65511], [-121.92335, 37.65531], [-121.92342, 37.65549], [-121.92405, 37.65672], [-121.92418, 37.65687], [-121.92474, 37.65741], [-121.92292, 37.65741], [-121.92292, 37.66166], [-121.92102, 37.66158], [-121.91451, 37.6614], [-121.91451, 37.66091], [-121.9147, 37.66095], [-121.91597, 37.66095], [-121.91607, 37.66094], [-121.91609, 37.66085], [-121.91613, 37.65849], [-121.91452, 37.65833], [-121.91452, 37.6507], [-121.91472, 37.6506], [-121.91472, 37.65025], [-121.92749, 37.65025]]], [[[-121.96441, 37.6875], [-121.96038, 37.68754], [-121.96039, 37.68927], [-121.96011, 37.68917], [-121.95955, 37.6891], [-121.95904, 37.6892], [-121.95843, 37.68954], [-121.95771, 37.68964], [-121.9573, 37.68988], [-121.95635, 37.69015], [-121.95598, 37.69035], [-121.95525, 37.69033], [-121.95466, 37.69052], [-121.95412, 37.69063], [-121.95289, 37.69107], [-121.95275, 37.69108], [-121.95252, 37.69092], [-121.95151, 37.69162], [-121.95128, 37.69186], [-121.95128, 37.69151], [-121.95126, 37.6915], [-121.95085, 37.69193], [-121.95058, 37.69231], [-121.94936, 37.6933], [-121.94858, 37.6934], [-121.94753, 37.69464], [-121.94723, 37.69468], [-121.94675, 37.69479], [-121.94677, 37.69216], [-121.94731, 37.69228], [-121.94756, 37.6923], [-121.94785, 37.69235], [-121.94835, 37.69252], [-121.94873, 37.69261], [-121.94879, 37.69261], [-121.94886, 37.69259], [-121.9489, 37.69253], [-121.94891, 37.69243], [-121.94888, 37.69235], [-121.94879, 37.69225], [-121.94846, 37.69203], [-121.94851, 37.692], [-121.94867, 37.6921], [-121.94896, 37.69183], [-121.94846, 37.69147], [-121.94838, 37.69145], [-121.94797, 37.6911], [-121.94828, 37.69084], [-121.9477, 37.69042], [-121.94742, 37.69034], [-121.94714, 37.69052], [-121.94695, 37.69062], [-121.94691, 37.69066], [-121.94689, 37.6907], [-121.94688, 37.69102], [-121.94678, 37.69101], [-121.94679, 37.68993], [-121.94776, 37.68911], [-121.94776, 37.68868], [-121.9468, 37.68867], [-121.9468, 37.68764], [-121.9462, 37.68763], [-121.9462, 37.68742], [-121.95131, 37.6874], [-121.95128, 37.68015], [-121.94102, 37.67923], [-121.93387, 37.67695], [-121.93328, 37.6773], [-121.93304, 37.67753], [-121.93196, 37.6771], [-121.93196, 37.67771], [-121.93168, 37.67787], [-121.93123, 37.67792], [-121.93103, 37.67808], [-121.9309, 37.67813], [-121.93081, 37.67822], [-121.9306, 37.67831], [-121.93032, 37.67831], [-121.93014, 37.67841], [-121.92978, 37.6784], [-121.92903, 37.67892], [-121.92719, 37.67894], [-121.92718, 37.67916], [-121.92657, 37.67921], [-121.92592, 37.67946], [-121.9255, 37.67961], [-121.92369, 37.68019], [-121.9217, 37.67451], [-121.92198, 37.67444], [-121.92266, 37.67461], [-121.92267, 37.67478], [-121.92955, 37.67479], [-121.92998, 37.67444], [-121.92996, 37.67407], [-121.93029, 37.67375], [-121.93046, 37.67322], [-121.93087, 37.67313], [-121.93102, 37.67304], [-121.93139, 37.67265], [-121.93193, 37.67235], [-121.93193, 37.67511], [-121.93388, 37.67579], [-121.93465, 37.67487], [-121.9355, 37.67516], [-121.93584, 37.67455], [-121.93417, 37.67393], [-121.93415, 37.67302], [-121.95002, 37.6729], [-121.95128, 37.68015], [-121.95944, 37.67979], [-121.95946, 37.68039], [-121.9644, 37.68037], [-121.96441, 37.6875]], [[-121.92614, 37.6781], [-121.92614, 37.67811], [-121.92715, 37.67872], [-121.92785, 37.67773], [-121.92713, 37.6772], [-121.92614, 37.6781]]], [[[-121.93182, 37.6647], [-121.92747, 37.6647], [-121.92747, 37.66105], [-121.93178, 37.66107], [-121.93182, 37.6647]]], [[[-121.96916, 37.6511], [-121.96841, 37.65109], [-121.9684, 37.6511], [-121.96866, 37.66571], [-121.96719, 37.6657], [-121.96735, 37.66484], [-121.96318, 37.66293], [-121.95923, 37.66043], [-121.95777, 37.65948], [-121.95545, 37.65984], [-121.9549, 37.65834], [-121.95271, 37.65649], [-121.95038, 37.65531], [-121.9498, 37.65305], [-121.94982, 37.65085], [-121.94947, 37.63636], [-121.95623, 37.63613], [-121.95847, 37.63626], [-121.95867, 37.63629], [-121.95886, 37.63634], [-121.95934, 37.63655], [-121.95969, 37.63673], [-121.95991, 37.63688], [-121.96007, 37.63702], [-121.96069, 37.63769], [-121.96089, 37.63787], [-121.96152, 37.63824], [-121.96161, 37.63832], [-121.96177, 37.63848], [-121.96193, 37.63875], [-121.96246, 37.63982], [-121.96268, 37.64014], [-121.96312, 37.64068], [-121.96335, 37.64088], [-121.96435, 37.64164], [-121.96467, 37.64184], [-121.96563, 37.64243], [-121.96575, 37.64255], [-121.96594, 37.64289], [-121.96611, 37.64306], [-121.96626, 37.64315], [-121.96641, 37.64322], [-121.96659, 37.64327], [-121.96677, 37.64329], [-121.96695, 37.64329], [-121.96823, 37.64319], [-121.96824, 37.64358], [-121.96891, 37.64367], [-121.96892, 37.64404], [-121.96878, 37.64406], [-121.96763, 37.64406], [-121.96732, 37.64412], [-121.96709, 37.64422], [-121.96688, 37.64438], [-121.96671, 37.64458], [-121.96663, 37.64479], [-121.96661, 37.64499], [-121.96665, 37.64521], [-121.96677, 37.64543], [-121.96695, 37.64561], [-121.9672, 37.64576], [-121.96734, 37.64581], [-121.9682, 37.64602], [-121.96856, 37.64608], [-121.96899, 37.6461], [-121.96916, 37.6511]]], [[[-121.96899, 37.64598], [-121.96853, 37.64596], [-121.96818, 37.64591], [-121.96736, 37.64567], [-121.96713, 37.64557], [-121.96701, 37.64548], [-121.96691, 37.64538], [-121.96683, 37.64526], [-121.96679, 37.64515], [-121.96676, 37.64503], [-121.96676, 37.64487], [-121.9668, 37.64474], [-121.96686, 37.64462], [-121.96697, 37.64448], [-121.96709, 37.64439], [-121.96728, 37.64428], [-121.96744, 37.64423], [-121.96766, 37.6442], [-121.96892, 37.64415], [-121.96899, 37.64598]]], [[[-121.97191, 37.67624], [-121.97189, 37.6803], [-121.96896, 37.68034], [-121.96889, 37.67627], [-121.97191, 37.67624]]]]} | No Public Access 3 | 28112 | Pleasanton Ridge Regional Park | 31518 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 4792.41 | Pleasanton Ridge RP | 1990 | Local Park 2 | 4 | |
| 3203 | 3203 | 3202 | {"type": "Polygon", "coordinates": [[[-122.15189, 37.91237], [-122.15162, 37.91242], [-122.15115, 37.91259], [-122.15097, 37.913], [-122.15058, 37.91318], [-122.15014, 37.91354], [-122.1495, 37.91367], [-122.14907, 37.91339], [-122.14839, 37.91364], [-122.14788, 37.91391], [-122.14793, 37.91422], [-122.1477, 37.91444], [-122.14739, 37.91458], [-122.14679, 37.91461], [-122.14637, 37.91474], [-122.14607, 37.91492], [-122.14574, 37.91484], [-122.14505, 37.91498], [-122.14476, 37.91524], [-122.14401, 37.91523], [-122.1438, 37.91536], [-122.14336, 37.9154], [-122.14278, 37.91562], [-122.14237, 37.91589], [-122.1417, 37.91597], [-122.1417, 37.91351], [-122.13655, 37.91349], [-122.13657, 37.90943], [-122.14171, 37.90944], [-122.14171, 37.91003], [-122.14183, 37.91005], [-122.14188, 37.91008], [-122.14208, 37.91044], [-122.14219, 37.91046], [-122.14263, 37.9103], [-122.14271, 37.9103], [-122.14277, 37.91035], [-122.14278, 37.91038], [-122.1428, 37.91066], [-122.14282, 37.9107], [-122.14287, 37.91074], [-122.14342, 37.91092], [-122.14367, 37.91114], [-122.14374, 37.91058], [-122.14364, 37.91038], [-122.14382, 37.91024], [-122.14401, 37.9098], [-122.14393, 37.90959], [-122.14401, 37.90944], [-122.14776, 37.90945], [-122.14659, 37.91025], [-122.14671, 37.91112], [-122.15189, 37.91113], [-122.15189, 37.91237]]]} | Open Access 1 | 28121 | Briones Regional Park | 3221 | 1163 | Lafayette, City of 236 | City 2 | City Agency 2 | http://www.ci.lafayette.ca.us/index.aspx?page=87 | City 2 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/parks/briones | Contra Costa 12 | 146.367 | Briones RP | 1967 | Local Park 2 | 4 |
| 3269 | 3269 | 3268 | {"type": "Polygon", "coordinates": [[[-122.0528, 37.99715], [-122.05267, 37.99768], [-122.05079, 37.99735], [-122.05079, 37.99734], [-122.05051, 37.99729], [-122.05017, 37.99725], [-122.05016, 37.99724], [-122.04978, 37.99725], [-122.04887, 37.99733], [-122.04817, 37.99731], [-122.04823, 37.9969], [-122.04863, 37.99694], [-122.04888, 37.99693], [-122.04913, 37.99691], [-122.04957, 37.9968], [-122.04985, 37.99676], [-122.04986, 37.99675], [-122.05003, 37.99674], [-122.0501, 37.99681], [-122.05025, 37.99683], [-122.05029, 37.99673], [-122.05066, 37.99677], [-122.0528, 37.99715]]]} | Open Access 1 | 29407 | Delta/DeAnza Trail | 18077 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 5.445 | Delta/DeAnza Trail | 0 | Local Recreation Area 3 | 4 | |
| 3271 | 3271 | 3270 | {"type": "Polygon", "coordinates": [[[-121.96963, 38.04434], [-121.96963, 38.04843], [-121.96528, 38.04832], [-121.96268, 38.04843], [-121.96269, 38.04202], [-121.9663, 38.04288], [-121.96623, 38.04318], [-121.96849, 38.0443], [-121.96963, 38.04434]]]} | Open Access 1 | 29409 | Bay Point Regional Shoreline | 32664 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | https://www.ebparks.org/parks/bay_point/default.htm | Contra Costa 12 | 86.981 | Bay Point Reg. Shoreline | 1996 | Local Park 2 | 4 |
| 3486 | 3486 | 3485 | {"type": "Polygon", "coordinates": [[[-122.04254, 37.69324], [-122.04258, 37.69353], [-122.04254, 37.69359], [-122.04245, 37.69363], [-122.04168, 37.69356], [-122.04021, 37.69367], [-122.04031, 37.69501], [-122.0398, 37.6962], [-122.03857, 37.69573], [-122.03373, 37.69642], [-122.03244, 37.69557], [-122.0294, 37.69336], [-122.02923, 37.6932], [-122.02911, 37.69298], [-122.02965, 37.69307], [-122.03009, 37.6934], [-122.03051, 37.69331], [-122.03084, 37.69344], [-122.03097, 37.69365], [-122.03108, 37.69367], [-122.03129, 37.69369], [-122.03163, 37.69355], [-122.03186, 37.69322], [-122.03235, 37.69309], [-122.03281, 37.69308], [-122.03302, 37.69322], [-122.03334, 37.69316], [-122.03333, 37.69293], [-122.03356, 37.69289], [-122.03402, 37.69255], [-122.03407, 37.69237], [-122.03435, 37.69371], [-122.04, 37.69298], [-122.04254, 37.69324]]]} | No Public Access 3 | 46879 | Chabot - Garin Trail Corridor | 30360 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 63.522 | Chabot - Garin Trail Corridor | 0 | Local Conservation Area 4 | 2 | |
| 3558 | 3558 | 3557 | {"type": "Polygon", "coordinates": [[[-122.34141, 37.899], [-122.33912, 37.89903], [-122.33911, 37.89846], [-122.3414, 37.89842], [-122.34141, 37.899]]]} | No Public Access 3 | 15364 | Brooks Island Regional Preserve | 31524 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 3.177 | Brooks Island RPr | 0 | Local Conservation Area 4 | 2 | |
| 3621 | 3621 | 3620 | {"type": "Polygon", "coordinates": [[[-122.13468, 38.02843], [-122.13427, 38.02977], [-122.13074, 38.03157], [-122.13026, 38.02906], [-122.13025, 38.02905], [-122.12946, 38.02945], [-122.12902, 38.02716], [-122.12945, 38.02692], [-122.13129, 38.02602], [-122.13153, 38.02637], [-122.13293, 38.02824], [-122.13468, 38.02843]]]} | Open Access 1 | 29404 | Martinez Regional Shoreline | 21926 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 38.97 | Martinez Reg. Shoreline | 1979 | Local Park 2 | 4 | |
| 3624 | 3624 | 3623 | {"type": "Polygon", "coordinates": [[[-121.70748, 37.99957], [-121.7053, 37.99809], [-121.70531, 37.9979], [-121.70746, 37.99794], [-121.70748, 37.99957]]]} | Open Access 1 | 29411 | BB Delta Shoreline Trail | 15905 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 4.739 | BB Delta Shoreline Trail | 0 | Local Recreation Area 3 | 4 | |
| 3646 | 3646 | 3645 | {"type": "Polygon", "coordinates": [[[-122.09719, 37.88699], [-122.0967, 37.88654], [-122.09593, 37.88668], [-122.09517, 37.88629], [-122.09471, 37.88637], [-122.09407, 37.88659], [-122.09356, 37.88625], [-122.09322, 37.88618], [-122.0933, 37.88612], [-122.0934, 37.8861], [-122.09615, 37.88602], [-122.09669, 37.88602], [-122.09723, 37.88606], [-122.09727, 37.88609], [-122.09728, 37.88613], [-122.09719, 37.88664], [-122.09719, 37.88699]]]} | Open Access 1 | 29549 | Lafayette/Moraga Trail | 20836 | 300 | Contra Costa County Public Works Dept., County of 429 | County 3 | County Agency - Other 9 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 4.276 | Lafayette/Moraga Trail | 0 | Local Recreation Area 3 | 4 | |
| 3733 | 3733 | 3732 | {"type": "MultiPolygon", "coordinates": [[[[-122.03357, 37.90414], [-122.03346, 37.90426], [-122.03345, 37.904], [-122.0335, 37.90405], [-122.03357, 37.90414]]], [[[-122.04019, 37.90842], [-122.03957, 37.90859], [-122.03754, 37.90726], [-122.03826, 37.90623], [-122.03875, 37.90662], [-122.03905, 37.9069], [-122.03939, 37.90741], [-122.03961, 37.90803], [-122.04019, 37.90842]]]]} | Open Access 1 | 31016 | Briones to Mount Diablo Trail | 33752 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 5.904 | Briones to Mount Diablo Trail | 0 | Local Recreation Area 3 | 4 | |
| 3734 | 3734 | 3733 | {"type": "MultiPolygon", "coordinates": [[[[-122.31785, 37.90207], [-122.31749, 37.90263], [-122.3175, 37.90285], [-122.31661, 37.90177], [-122.31604, 37.90104], [-122.31593, 37.90086], [-122.31581, 37.90061], [-122.31574, 37.90032], [-122.31575, 37.90024], [-122.31577, 37.90016], [-122.31585, 37.90005], [-122.31596, 37.89998], [-122.31612, 37.89993], [-122.31785, 37.90207]]], [[[-122.31976, 37.90599], [-122.31923, 37.906], [-122.3171, 37.90343], [-122.31757, 37.90318], [-122.31802, 37.90409], [-122.31829, 37.90458], [-122.31976, 37.90599]]]]} | Restricted Access 2 | 113 | McLaughlin Eastshore State Park | 29198 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/parks/eastshore | Contra Costa 12 | 7.835 | McLaughlin Eastshore SP | None 312 | ||
| 3757 | 3757 | 3756 | {"type": "Polygon", "coordinates": [[[-122.27111, 38.04044], [-122.26883, 38.04296], [-122.26793, 38.04407], [-122.26606, 38.04552], [-122.26345, 38.04303], [-122.26441, 38.04222], [-122.26428, 38.04211], [-122.26434, 38.04207], [-122.26434, 38.04205], [-122.26428, 38.042], [-122.26421, 38.04204], [-122.26333, 38.04124], [-122.26342, 38.04109], [-122.26365, 38.0408], [-122.26384, 38.04059], [-122.26413, 38.04034], [-122.26445, 38.04011], [-122.2648, 38.03991], [-122.26517, 38.03974], [-122.26694, 38.04149], [-122.27043, 38.0391], [-122.27111, 38.04044]]]} | Restricted Access 2 | 466 | San Pablo Bay Regional Shoreline | 24966 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 57.631 | San Pablo Bay Reg. Shoreline | 1976 | Local Park 2 | 4 | |
| 3773 | 3773 | 3772 | {"type": "Polygon", "coordinates": [[[-121.84132, 37.74732], [-121.84129, 37.7523], [-121.8324, 37.75239], [-121.83241, 37.75942], [-121.82329, 37.75956], [-121.82326, 37.75633], [-121.82328, 37.75238], [-121.8206, 37.75236], [-121.84132, 37.74732]]]} | No Public Access 3 | 35010 | Doolan Canyon Regional Preserve | 33749 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 283.15 | Doolan Canyon RPr | 2010 | Local Conservation Area 4 | 2 | |
| 4034 | 4034 | 4033 | {"type": "Polygon", "coordinates": [[[-121.91611, 37.5378], [-121.91556, 37.53803], [-121.91495, 37.53842], [-121.91451, 37.53888], [-121.91415, 37.53911], [-121.91397, 37.53932], [-121.91364, 37.53952], [-121.91302, 37.53939], [-121.91255, 37.53955], [-121.91174, 37.53993], [-121.91138, 37.54002], [-121.90953, 37.54067], [-121.90916, 37.54088], [-121.90818, 37.54109], [-121.90735, 37.54153], [-121.90688, 37.54203], [-121.90661, 37.54204], [-121.90612, 37.5403], [-121.90456, 37.5375], [-121.90418, 37.53666], [-121.90346, 37.53544], [-121.89974, 37.52963], [-121.89885, 37.5284], [-121.89859, 37.52788], [-121.8989, 37.52754], [-121.8994, 37.52728], [-121.90004, 37.52698], [-121.90089, 37.52646], [-121.90117, 37.52558], [-121.90143, 37.52518], [-121.90186, 37.52478], [-121.90249, 37.5246], [-121.90397, 37.52429], [-121.90517, 37.52427], [-121.9059, 37.52461], [-121.90612, 37.52479], [-121.90738, 37.52603], [-121.90881, 37.52554], [-121.90905, 37.52543], [-121.91005, 37.52485], [-121.91163, 37.52391], [-121.9122, 37.52617], [-121.91243, 37.52617], [-121.91252, 37.52614], [-121.91258, 37.52614], [-121.91266, 37.52619], [-121.91269, 37.52626], [-121.91271, 37.52705], [-121.91275, 37.52708], [-121.913, 37.52708], [-121.913, 37.52723], [-121.91273, 37.52724], [-121.91262, 37.5274], [-121.91263, 37.52745], [-121.91233, 37.52727], [-121.91199, 37.52714], [-121.91133, 37.52703], [-121.91108, 37.52705], [-121.91012, 37.52766], [-121.90997, 37.52829], [-121.91015, 37.52879], [-121.9104, 37.52907], [-121.91043, 37.52907], [-121.91051, 37.52939], [-121.91046, 37.52995], [-121.91009, 37.53017], [-121.90941, 37.53032], [-121.90902, 37.53037], [-121.90894, 37.53044], [-121.90888, 37.5306], [-121.90889, 37.53065], [-121.90906, 37.53091], [-121.90922, 37.53108], [-121.90935, 37.53128], [-121.91138, 37.53258], [-121.91098, 37.53266], [-121.91084, 37.53271], [-121.91022, 37.53305], [-121.91019, 37.53309], [-121.91019, 37.53315], [-121.91021, 37.53319], [-121.9103, 37.53326], [-121.91041, 37.53328], [-121.91051, 37.53332], [-121.91079, 37.53351], [-121.91131, 37.53334], [-121.91171, 37.53472], [-121.91254, 37.53694], [-121.91321, 37.53668], [-121.91405, 37.53642], [-121.91406, 37.5364], [-121.91547, 37.53595], [-121.91611, 37.5378]]]} | No Public Access 3 | 46970 | Mission Peak Regional Preserve | 30597 | 235 | Desert and Mountain Conservation Authority 713 | State 5 | State Agency 5 | http://www.dmca.ca.gov/ | Other State 5 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 374.957 | Mission Peak RPr | 0 | Local Conservation Area 4 | 2 | |
| 4182 | 4182 | 4181 | {"type": "Polygon", "coordinates": [[[-122.33713, 37.91103], [-122.3302, 37.90951], [-122.33019, 37.90937], [-122.32739, 37.90874], [-122.32609, 37.90838], [-122.32557, 37.9082], [-122.32557, 37.90811], [-122.32475, 37.9078], [-122.32454, 37.90774], [-122.32432, 37.90764], [-122.32317, 37.90701], [-122.32242, 37.90652], [-122.32205, 37.90627], [-122.32145, 37.90584], [-122.32094, 37.9054], [-122.32039, 37.90483], [-122.32022, 37.90468], [-122.31956, 37.90396], [-122.3163, 37.8999], [-122.31655, 37.89982], [-122.31658, 37.89984], [-122.31926, 37.90317], [-122.32457, 37.90051], [-122.32268, 37.89818], [-122.32347, 37.89776], [-122.32425, 37.89827], [-122.32452, 37.89851], [-122.32468, 37.89872], [-122.32478, 37.89891], [-122.32485, 37.89914], [-122.32487, 37.89938], [-122.32522, 37.89938], [-122.32522, 37.9011], [-122.32128, 37.90308], [-122.31988, 37.9038], [-122.3203, 37.90434], [-122.32088, 37.90498], [-122.32125, 37.90533], [-122.32159, 37.90561], [-122.32212, 37.90606], [-122.32235, 37.90632], [-122.3228, 37.9066], [-122.32313, 37.90684], [-122.3235, 37.90705], [-122.32458, 37.9076], [-122.32579, 37.90809], [-122.32594, 37.90814], [-122.3261, 37.90816], [-122.32745, 37.90855], [-122.3325, 37.90968], [-122.33251, 37.90967], [-122.33251, 37.90946], [-122.33711, 37.91047], [-122.33713, 37.91103]]]} | Open Access 1 | 3447 | Point Isabel | 23851 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 37.437 | Point Isabel | None 363 |
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]);