units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
167 rows where MNG_AGENCY = 87 sorted by AGNCY_ID descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, 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
LAYER 7 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16848 | 16848 | 16847 | {"type": "Polygon", "coordinates": [[[-122.19101, 38.04175], [-122.19099, 38.04178], [-122.19086, 38.04185], [-122.1906, 38.04191], [-122.19039, 38.04202], [-122.19028, 38.04212], [-122.19015, 38.04228], [-122.19005, 38.04237], [-122.18937, 38.04276], [-122.18914, 38.04295], [-122.18891, 38.04318], [-122.18882, 38.04325], [-122.18837, 38.04342], [-122.18829, 38.0435], [-122.18825, 38.04362], [-122.18808, 38.04355], [-122.18799, 38.0437], [-122.18818, 38.04379], [-122.18804, 38.04398], [-122.18768, 38.04405], [-122.18769, 38.04413], [-122.1875, 38.04418], [-122.18769, 38.0448], [-122.18742, 38.04484], [-122.18741, 38.04482], [-122.18723, 38.04488], [-122.18694, 38.04494], [-122.18693, 38.04493], [-122.18667, 38.04491], [-122.18666, 38.04492], [-122.18668, 38.04499], [-122.18634, 38.04507], [-122.18625, 38.04481], [-122.18572, 38.04491], [-122.18571, 38.04492], [-122.18579, 38.04516], [-122.18542, 38.04523], [-122.18542, 38.04526], [-122.1853, 38.04528], [-122.18525, 38.04516], [-122.18507, 38.0452], [-122.18506, 38.04523], [-122.18493, 38.04526], [-122.18496, 38.04535], [-122.18479, 38.04538], [-122.18476, 38.04529], [-122.18456, 38.04533], [-122.18445, 38.04524], [-122.18409, 38.04532], [-122.18348, 38.04481], [-122.18335, 38.04533], [-122.18362, 38.04556], [-122.18354, 38.04552], [-122.18336, 38.0457], [-122.1834, 38.04574], [-122.18317, 38.04592], [-122.18342, 38.04611], [-122.18335, 38.04616], [-122.18321, 38.04605], [-122.18297, 38.04623], [-122.1806, 38.04465], [-122.18023, 38.04434], [-122.17991, 38.044], [-122.17963, 38.04363], [-122.17904, 38.04266], [-122.18113, 38.04172], [-122.18334, 38.04281], [-122.18366, 38.04276], [-122.18375, 38.04237], [-122.18264, 38.04163], [-122.1839, 38.04107], [-122.18473, 38.04119], [-122.18494, 38.0412], [-122.18515, 38.04118], [-122.18572, 38.04105], [-122.18589, 38.04102], [-122.18624, 38.04102], [-122.18658, 38.04108], [-122.18686, 38.04117], [-122.1884, 38.04201], [-122.18853, 38.04206], [-122.18868, 38.0421], [-122.18884, 38.0421], [-122.18897, 38.04209], [-122.18959, 38.04199], [-122.18975, 38.04194], [-122.18988, 38.04186], [-122.19, 38.04177], [-122.19011, 38.04161], [-122.19016, 38.0415], [-122.19022, 38.04146], [-122.1903, 38.04144], [-122.19042, 38.04147], [-122.19071, 38.04165], [-122.19083, 38.04168], [-122.19094, 38.04168], [-122.19098, 38.04169], [-122.191, 38.04171], [-122.19101, 38.04175]]]} | Restricted Access 2 | 29402 | Carquinez Strait Regional Shoreline | 16904 | 3126 | Port Costa Conservation Society 1177 | Non Profit 6 | Non Profit - Conservation 12 | http://www.portcosta.com/newsletter.htm | Non Governmental Organization 10 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 76.447 | Carquinez Strait Reg. Shoreline | 1981 | Local Park 2 | 4 | |
9293 | 9293 | 9292 | {"type": "Polygon", "coordinates": [[[-122.33272, 37.80548], [-122.33211, 37.80596], [-122.33226, 37.80633], [-122.33185, 37.80641], [-122.33188, 37.80651], [-122.33128, 37.80669], [-122.33018, 37.80715], [-122.32968, 37.8073], [-122.32911, 37.80741], [-122.32832, 37.80746], [-122.32745, 37.80745], [-122.32667, 37.8074], [-122.3259, 37.8073], [-122.32262, 37.80667], [-122.32252, 37.80661], [-122.3225, 37.80656], [-122.32252, 37.80613], [-122.32248, 37.80579], [-122.32237, 37.80541], [-122.32221, 37.80509], [-122.32267, 37.8052], [-122.32518, 37.79906], [-122.32546, 37.79913], [-122.32636, 37.79902], [-122.32644, 37.79904], [-122.32645, 37.79907], [-122.32628, 37.79949], [-122.32631, 37.79952], [-122.32664, 37.79961], [-122.32677, 37.79957], [-122.32693, 37.79919], [-122.32697, 37.79918], [-122.33, 37.79996], [-122.33008, 37.80006], [-122.33021, 37.80017], [-122.33009, 37.80036], [-122.32992, 37.80033], [-122.32948, 37.80032], [-122.32946, 37.80037], [-122.32976, 37.80065], [-122.32963, 37.80074], [-122.32919, 37.80054], [-122.32896, 37.80052], [-122.32854, 37.80054], [-122.32832, 37.8005], [-122.32818, 37.80045], [-122.32772, 37.80021], [-122.32734, 37.80005], [-122.32673, 37.80033], [-122.32556, 37.80009], [-122.32521, 37.80008], [-122.32516, 37.80009], [-122.32511, 37.80012], [-122.32506, 37.80029], [-122.325, 37.80041], [-122.3248, 37.80067], [-122.32458, 37.80125], [-122.32513, 37.80139], [-122.3251, 37.80146], [-122.32462, 37.80136], [-122.32456, 37.80152], [-122.32456, 37.80169], [-122.32449, 37.80192], [-122.32441, 37.80235], [-122.32443, 37.80279], [-122.32452, 37.80305], [-122.325, 37.80315], [-122.32498, 37.80323], [-122.32462, 37.80316], [-122.32455, 37.80323], [-122.32451, 37.80332], [-122.32449, 37.80342], [-122.3245, 37.8035], [-122.32462, 37.80375], [-122.32496, 37.80462], [-122.32512, 37.80509], [-122.32523, 37.80511], [-122.32525, 37.8051], [-122.32588, 37.80523], [-122.32591, 37.80516], [-122.32639, 37.80526], [-122.32649, 37.80535], [-122.32648, 37.80545], [-122.32494, 37.80666], [-122.32494, 37.80667], [-122.32508, 37.80676], [-122.32539, 37.80685], [-122.32628, 37.80702], [-122.32662, 37.80695], [-122.32665, 37.80696], [-122.32668, 37.807], [-122.32667, 37.80709], [-122.32669, 37.80713], [-122.32672, 37.80716], [-122.32677, 37.80718], [-122.32685, 37.80716], [-122.32692, 37.8071], [-122.32701, 37.80706], [-122.32735, 37.80717], [-122.3277, 37.80724], [-122.32806, 37.80728], [-122.32842, 37.80729], [-122.32873, 37.80726], [-122.32925, 37.80717], [-122.32985, 37.8071], [-122.33004, 37.80705], [-122.33049, 37.80684], [-122.33078, 37.80673], [-122.33098, 37.80662], [-122.33119, 37.80646], [-122.33129, 37.80642], [-122.3314, 37.8064], [-122.33161, 37.80624], [-122.33156, 37.80618], [-122.3326, 37.80538], [-122.33272, 37.80548]]]} | Open Access 1 | 15481 | Middle Harbor Shoreline Park | 22208 | 2286 | Port of Oakland 907 | Special District 4 | Port/Harbor District 15 | http://www.portofoakland.com/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 41.418 | Middle Harbor Shoreline Park | 2002 | Local Park 2 | 4 | |
13022 | 13022 | 13021 | {"type": "Polygon", "coordinates": [[[-122.14836, 37.627], [-122.14532, 37.62726], [-122.1389, 37.62727], [-122.13892, 37.62376], [-122.13918, 37.62376], [-122.13922, 37.627], [-122.14836, 37.627]]]} | No Public Access 3 | 46959 | Hayward Regional Shoreline | 19761 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/parks/hayward | Alameda 17 | 7.307 | Hayward Reg. Shoreline | 1980 | Local Park 2 | 4 |
13031 | 13031 | 13030 | {"type": "Polygon", "coordinates": [[[-122.13918, 37.62375], [-122.13543, 37.62377], [-122.13526, 37.62377], [-122.13581, 37.62359], [-122.13917, 37.62357], [-122.13918, 37.62375]]]} | Open Access 1 | 46961 | Hayward Regional Shoreline | 3268 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/parks/hayward | Alameda 17 | 1.605 | Hayward Reg. Shoreline | 1980 | Local Park 2 | 4 |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |||
4298 | 4298 | 4297 | {"type": "MultiPolygon", "coordinates": [[[[-121.97565, 37.70051], [-121.97562, 37.70061], [-121.97543, 37.70073], [-121.97507, 37.70044], [-121.97405, 37.69985], [-121.97434, 37.69948], [-121.9747, 37.69968], [-121.975, 37.69989], [-121.97538, 37.70022], [-121.97565, 37.70051]]], [[[-121.98765, 37.73258], [-121.98688, 37.73201], [-121.97964, 37.7298], [-121.9786, 37.72967], [-121.97859, 37.72783], [-121.97863, 37.72405], [-121.9862, 37.72382], [-121.98624, 37.72657], [-121.98763, 37.72776], [-121.98761, 37.73085], [-121.98765, 37.73258]]]]} | Restricted Access 2 | 45337 | Dublin Hills Regional Park | 18292 | 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 | 142.3 | Dublin Hills RP | 0 | Local Park 2 | 4 | |
4299 | 4299 | 4298 | {"type": "Polygon", "coordinates": [[[-121.7518, 38.01968], [-121.75091, 38.01969], [-121.7509, 38.01962], [-121.75076, 38.01962], [-121.75075, 38.01954], [-121.75067, 38.01953], [-121.75068, 38.01915], [-121.75068, 38.01845], [-121.75062, 38.01784], [-121.75069, 38.01749], [-121.75069, 38.01643], [-121.75071, 38.01657], [-121.7508, 38.01673], [-121.7509, 38.01684], [-121.75104, 38.01693], [-121.75122, 38.01701], [-121.75137, 38.01703], [-121.75179, 38.01704], [-121.7518, 38.01968]]]} | Open Access 1 | 45338 | Antioch / Oakley Regional Shoreline | 15521 | 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 | 7.375 | Antioch / Oakley Reg. Shoreline | 0 | Local Park 2 | 4 | |
4940 | 4940 | 4939 | {"type": "Polygon", "coordinates": [[[-122.02404, 37.66917], [-122.02383, 37.66911], [-122.02395, 37.66891], [-122.02396, 37.66892], [-122.02404, 37.66917]]]} | Restricted Access 2 | 10715 | Chabot - Garin Trail Corridor | 17108 | 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 | 0.064 | Chabot - Garin Trail Corridor | 0 | Local Conservation Area 4 | 2 |
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]);