units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
24 rows where COUNTY = 12, DES_TP = 3 and LAYER = 4
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, AGNCY_NAME, AGNCY_WEB, MNG_AG_ID, PARK_URL, YR_EST
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2099 | 2099 | 2098 | {"type": "Polygon", "coordinates": [[[-121.94503, 37.73765], [-121.94369, 37.73818], [-121.94322, 37.73744], [-121.94227, 37.7378], [-121.94234, 37.73798], [-121.94192, 37.73811], [-121.94168, 37.73772], [-121.94145, 37.73739], [-121.94426, 37.7363], [-121.9444, 37.73653], [-121.94433, 37.7366], [-121.94433, 37.73668], [-121.94438, 37.73674], [-121.94449, 37.73676], [-121.94503, 37.73765]]]} | Restricted Access 2 | 47569 | Pine Valley Middle School Parks and Community Gym | 31294 | 2309 | San Ramon Valley Unified School District 478 | Special District 4 | School District 14 | http://www.srvusd.net/ | Special District 4 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | Contra Costa 12 | 8.075 | Pine Valley Middle School Parks and Community Gym | 0 | Local Recreation Area 3 | 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 | |
3364 | 3364 | 3363 | {"type": "Polygon", "coordinates": [[[-122.06821, 37.96242], [-122.06779, 37.96243], [-122.06778, 37.96239], [-122.06715, 37.9624], [-122.06651, 37.96247], [-122.06646, 37.96233], [-122.06626, 37.96208], [-122.06625, 37.96193], [-122.06635, 37.96168], [-122.06738, 37.96154], [-122.06818, 37.96148], [-122.06821, 37.96242]]]} | Open Access 1 | 31033 | Pleasant Hill Community Center / Frank Salfingere Park | 23794 | 2112 | Pleasant Hill Recreation and Park District 466 | Special District 4 | Recreation/Parks District 4 | http://www.pleasanthillrec.com | Special District 4 | 2112 | Pleasant Hill Recreation and Park District 459 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 3.829 | Pleasant Hill Community Ctr. / Frank Salfingere Park | 0 | Local Recreation Area 3 | 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 | |
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 | |
7251 | 7251 | 7250 | {"type": "Polygon", "coordinates": [[[-121.92994, 37.74522], [-121.92625, 37.74667], [-121.92569, 37.74579], [-121.92458, 37.74623], [-121.92512, 37.74711], [-121.92071, 37.74637], [-121.92092, 37.7457], [-121.92094, 37.7455], [-121.92092, 37.74535], [-121.921, 37.74482], [-121.9211, 37.7447], [-121.9213, 37.74459], [-121.92141, 37.74449], [-121.92146, 37.7444], [-121.92148, 37.74426], [-121.92136, 37.74378], [-121.92055, 37.74282], [-121.9205, 37.74268], [-121.92049, 37.74258], [-121.92053, 37.7422], [-121.92061, 37.74194], [-121.92088, 37.74171], [-121.9209, 37.74166], [-121.92086, 37.74144], [-121.921, 37.74106], [-121.92102, 37.74085], [-121.92096, 37.74024], [-121.92146, 37.73929], [-121.92181, 37.73883], [-121.92232, 37.73901], [-121.92245, 37.73928], [-121.92249, 37.73962], [-121.92256, 37.73977], [-121.92257, 37.73977], [-121.92276, 37.73954], [-121.92277, 37.73957], [-121.92258, 37.73982], [-121.9226, 37.73986], [-121.92258, 37.74002], [-121.9226, 37.74014], [-121.9227, 37.7404], [-121.92283, 37.74054], [-121.92298, 37.74068], [-121.92344, 37.74066], [-121.92396, 37.74073], [-121.92441, 37.74073], [-121.9246, 37.74075], [-121.9248, 37.74079], [-121.92491, 37.74089], [-121.92502, 37.74095], [-121.92519, 37.74109], [-121.92534, 37.74126], [-121.92543, 37.74145], [-121.92548, 37.74167], [-121.92547, 37.74189], [-121.92553, 37.74205], [-121.92563, 37.74213], [-121.92575, 37.74238], [-121.9259, 37.74263], [-121.92617, 37.74292], [-121.92625, 37.74304], [-121.92638, 37.74333], [-121.92669, 37.74351], [-121.92698, 37.74389], [-121.92725, 37.74414], [-121.92715, 37.74428], [-121.92706, 37.74444], [-121.92692, 37.74464], [-121.92691, 37.74469], [-121.92692, 37.74481], [-121.92801, 37.74475], [-121.92843, 37.74481], [-121.92869, 37.74482], [-121.92892, 37.74479], [-121.9294, 37.74467], [-121.92994, 37.74522]]]} | Open Access 1 | 48920 | Dougherty Valley Ridge Trail | 33643 | 2300 | Geologic Hazard Abatement District (San Ramon) 853 | Special District 4 | Special District - Other 26 | http://www.sanramon.ca.gov/engr/ghad.html | Special District 4 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | http://www.sanramon.ca.gov/our_city/departments_and_divisions/parks_community_services/trails_open_space/dougherty_valley_ridge_trail | Contra Costa 12 | 89.586 | Dougherty Valley Ridge Trail | 0 | Local Recreation Area 3 | 4 |
7255 | 7255 | 7254 | {"type": "Polygon", "coordinates": [[[-121.92427, 37.74849], [-121.92332, 37.74921], [-121.92193, 37.74844], [-121.91908, 37.7461], [-121.92388, 37.7469], [-121.92427, 37.74849]]]} | Open Access 1 | 48922 | Dougherty Valley Ridge Trail | 33643 | 2031 | East Bay Municipal Utility District 433 | Special District 4 | Water District 13 | http://www.ebmud.com/ | Special District 4 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | http://www.sanramon.ca.gov/our_city/departments_and_divisions/parks_community_services/trails_open_space/dougherty_valley_ridge_trail | Contra Costa 12 | 17.382 | Dougherty Valley Ridge Trail | 0 | Local Recreation Area 3 | 4 |
9237 | 9237 | 9236 | {"type": "Polygon", "coordinates": [[[-121.71401, 38.0024], [-121.71401, 38.00331], [-121.71393, 38.00334], [-121.7134, 38.00283], [-121.71283, 38.00253], [-121.71206, 38.00177], [-121.71201, 38.00107], [-121.71333, 38.00191], [-121.71401, 38.0024]]]} | Open Access 1 | 15373 | Big Break Regional Trail | 16075 | 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.138 | Big Break Reg. Trail | 0 | Local Recreation Area 3 | 4 | |
9475 | 9475 | 9474 | {"type": "Polygon", "coordinates": [[[-121.99706, 37.85874], [-121.99272, 37.85889], [-121.99271, 37.85879], [-121.99179, 37.85882], [-121.99177, 37.85859], [-121.99113, 37.85861], [-121.99114, 37.85894], [-121.98799, 37.85902], [-121.98802, 37.85534], [-121.98347, 37.85552], [-121.9834, 37.85198], [-121.98093, 37.85206], [-121.98203, 37.84983], [-121.98481, 37.84974], [-121.98472, 37.84989], [-121.98475, 37.85233], [-121.98792, 37.85218], [-121.98792, 37.85182], [-121.99283, 37.85166], [-121.99236, 37.85244], [-121.99237, 37.8527], [-121.99281, 37.85361], [-121.99269, 37.85461], [-121.9942, 37.85475], [-121.99566, 37.85534], [-121.99601, 37.85511], [-121.997, 37.85504], [-121.99706, 37.85874]]]} | Open Access 1 | 17309 | Las Trampas/Diablo Regional Trail | 21069 | 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 | 174.441 | Las Trampas/Diablo Reg. Trail | 1976 | Local Recreation Area 3 | 4 | |
9983 | 9983 | 9982 | {"type": "Polygon", "coordinates": [[[-122.26941, 37.95602], [-122.26837, 37.95734], [-122.26599, 37.95498], [-122.26344, 37.95587], [-122.26117, 37.9548], [-122.25983, 37.95454], [-122.25946, 37.95486], [-122.25818, 37.95369], [-122.25423, 37.94996], [-122.25637, 37.94855], [-122.25637, 37.94854], [-122.25595, 37.94817], [-122.25938, 37.94547], [-122.25949, 37.94554], [-122.2597, 37.94571], [-122.25984, 37.94571], [-122.25994, 37.94566], [-122.26004, 37.94558], [-122.2666, 37.94626], [-122.26733, 37.94758], [-122.26754, 37.94784], [-122.26408, 37.94964], [-122.26424, 37.94986], [-122.26431, 37.95017], [-122.26465, 37.95013], [-122.2647, 37.95039], [-122.26638, 37.95045], [-122.26638, 37.95097], [-122.26555, 37.95135], [-122.26489, 37.95103], [-122.26445, 37.95156], [-122.26422, 37.95236], [-122.26577, 37.95294], [-122.26736, 37.95407], [-122.26771, 37.95451], [-122.26812, 37.95439], [-122.26893, 37.95492], [-122.26888, 37.95506], [-122.26876, 37.95561], [-122.26941, 37.95602]]]} | Open Access 1 | 17172 | Kennedy Grove Regional Recreation Area | 3271 | 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 | http://www.ebparks.org/parks/kennedy | Contra Costa 12 | 217.875 | Kennedy Grove Reg. Rec. Area | 1967 | Local Recreation Area 3 | 4 |
10105 | 10105 | 10104 | {"type": "MultiPolygon", "coordinates": [[[[-121.97369, 37.93539], [-121.97365, 37.93544], [-121.96855, 37.93551], [-121.96867, 37.93545], [-121.97369, 37.93539]]], [[[-121.96826, 37.93546], [-121.96797, 37.93555], [-121.96726, 37.9357], [-121.96694, 37.93579], [-121.96664, 37.93591], [-121.96636, 37.93605], [-121.9661, 37.93622], [-121.96586, 37.93641], [-121.96569, 37.93657], [-121.96412, 37.93819], [-121.96404, 37.93818], [-121.96563, 37.93653], [-121.96585, 37.93633], [-121.9661, 37.93614], [-121.96637, 37.93598], [-121.96666, 37.93583], [-121.96696, 37.93572], [-121.96728, 37.93563], [-121.96782, 37.93553], [-121.96807, 37.93546], [-121.96826, 37.93546]]], [[[-121.96407, 37.93824], [-121.96335, 37.93918], [-121.96327, 37.9393], [-121.96312, 37.9396], [-121.96305, 37.93961], [-121.96316, 37.93934], [-121.96329, 37.93915], [-121.96399, 37.93823], [-121.96407, 37.93824]]], [[[-121.963, 37.93975], [-121.96304, 37.93978], [-121.96305, 37.93982], [-121.96283, 37.94043], [-121.96271, 37.94113], [-121.96265, 37.94118], [-121.96266, 37.94099], [-121.96275, 37.9405], [-121.96283, 37.9402], [-121.963, 37.93975]]], [[[-121.967, 37.94522], [-121.96692, 37.94523], [-121.96688, 37.94515], [-121.96663, 37.94479], [-121.96609, 37.94436], [-121.96423, 37.94346], [-121.96463, 37.94293], [-121.96447, 37.94288], [-121.96422, 37.94261], [-121.9641, 37.94241], [-121.96396, 37.94225], [-121.96369, 37.94199], [-121.96305, 37.94148], [-121.96287, 37.94147], [-121.9629, 37.94142], [-121.96307, 37.94142], [-121.96377, 37.94198], [-121.96401, 37.94221], [-121.96416, 37.94238], [-121.96429, 37.94259], [-121.96452, 37.94283], [-121.96475, 37.9429], [-121.96435, 37.94345], [-121.96617, 37.94432], [-121.96669, 37.94476], [-121.96695, 37.94513], [-121.967, 37.94522]]], [[[-121.96761, 37.94557], [-121.96754, 37.94563], [-121.96714, 37.94565], [-121.96699, 37.94536], [-121.96707, 37.94535], [-121.9672, 37.94559], [-121.96761, 37.94557]]], [[[-122.08253, 37.97602], [-122.08247, 37.97608], [-122.08181, 37.97609], [-122.08181, 37.97604], [-122.08253, 37.97602]]], [[[-122.08523, 37.97718], [-122.08516, 37.97722], [-122.08511, 37.97722], [-122.08497, 37.97714], [-122.08485, 37.9771], [-122.08446, 37.97706], [-122.08405, 37.97641], [-122.08396, 37.97618], [-122.08386, 37.97606], [-122.08269, 37.97608], [-122.08276, 37.97602], [-122.08396, 37.976], [-122.08396, 37.97605], [-122.08403, 37.97614], [-122.08409, 37.97627], [-122.08413, 37.97639], [-122.08447, 37.97693], [-122.08458, 37.977], [-122.08484, 37.97704], [-122.08507, 37.97712], [-122.08514, 37.97711], [-122.08523, 37.97718]]]]} | Open Access 1 | 49044 | California Riding and Hiking Trail | 33750 | 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 | https://www.ebparks.org/parks/trails/california/default.htm | Contra Costa 12 | 3.625 | California Riding and Hiking Trail | 1982 | Local Recreation Area 3 | 4 |
11862 | 11862 | 11861 | {"type": "Polygon", "coordinates": [[[-122.09727, 37.96835], [-122.09717, 37.96862], [-122.09485, 37.96935], [-122.09203, 37.969], [-122.092, 37.96452], [-122.09276, 37.96373], [-122.09296, 37.96333], [-122.093, 37.96256], [-122.09383, 37.96217], [-122.09419, 37.96211], [-122.09448, 37.96223], [-122.09467, 37.9622], [-122.09489, 37.96209], [-122.09533, 37.96201], [-122.09572, 37.96197], [-122.09637, 37.96319], [-122.09604, 37.96332], [-122.09595, 37.96369], [-122.09583, 37.96389], [-122.09567, 37.96404], [-122.09538, 37.96418], [-122.0947, 37.96427], [-122.09443, 37.96422], [-122.09396, 37.96436], [-122.09374, 37.96447], [-122.0936, 37.96466], [-122.0936, 37.96496], [-122.09385, 37.96515], [-122.09405, 37.96526], [-122.09418, 37.96538], [-122.09401, 37.96587], [-122.0937, 37.96661], [-122.09358, 37.96706], [-122.09401, 37.96735], [-122.09441, 37.96727], [-122.09466, 37.96712], [-122.09476, 37.96666], [-122.09485, 37.96614], [-122.09485, 37.9656], [-122.09496, 37.96529], [-122.09588, 37.96527], [-122.09727, 37.96835]]]} | Open Access 1 | 31035 | Ridgeview Open Space | 24358 | 2112 | Pleasant Hill Recreation and Park District 466 | Special District 4 | Recreation/Parks District 4 | http://www.pleasanthillrec.com | Special District 4 | 2112 | Pleasant Hill Recreation and Park District 459 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 58.402 | Ridgeview OS | 0 | Local Recreation Area 3 | 4 | |
11864 | 11864 | 11863 | {"type": "Polygon", "coordinates": [[[-122.08599, 37.95319], [-122.0867, 37.95368], [-122.08696, 37.95388], [-122.08706, 37.95399], [-122.0871, 37.95408], [-122.08712, 37.95418], [-122.08711, 37.95427], [-122.08708, 37.95436], [-122.08703, 37.95444], [-122.08696, 37.95451], [-122.08668, 37.95472], [-122.08599, 37.95516], [-122.08599, 37.95319]]]} | Open Access 1 | 31034 | Winslow Center | 27650 | 2112 | Pleasant Hill Recreation and Park District 466 | Special District 4 | Recreation/Parks District 4 | http://www.pleasanthillrec.com | Special District 4 | 2112 | Pleasant Hill Recreation and Park District 459 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 3.264 | Winslow Ctr. | 0 | Local Recreation Area 3 | 4 | |
11889 | 11889 | 11888 | {"type": "Polygon", "coordinates": [[[-122.12119, 37.99183], [-122.12094, 37.99183], [-122.12073, 37.99142], [-122.12067, 37.99123], [-122.12053, 37.99101], [-122.12036, 37.99083], [-122.11953, 37.99054], [-122.11898, 37.99054], [-122.11859, 37.9907], [-122.11803, 37.99083], [-122.11755, 37.99121], [-122.11756, 37.99136], [-122.11778, 37.99163], [-122.11775, 37.99168], [-122.11747, 37.99159], [-122.11728, 37.99155], [-122.11673, 37.99148], [-122.11634, 37.99146], [-122.11635, 37.99047], [-122.11127, 37.99041], [-122.11081, 37.9904], [-122.1108, 37.99035], [-122.10885, 37.99033], [-122.10834, 37.98908], [-122.10817, 37.98839], [-122.10786, 37.98789], [-122.10639, 37.98388], [-122.10672, 37.98297], [-122.10679, 37.98298], [-122.10647, 37.98388], [-122.10794, 37.98791], [-122.10823, 37.98838], [-122.10839, 37.98906], [-122.10889, 37.99028], [-122.11086, 37.9903], [-122.11088, 37.99035], [-122.11116, 37.99036], [-122.12051, 37.99046], [-122.12055, 37.99051], [-122.12119, 37.99183]]]} | Open Access 1 | 24446 | CA State Riding & Hiking Trail | 28138 | 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 | http://www.ebparks.org/Page161.aspx | Contra Costa 12 | 8.246 | CA State Riding & Hiking Trail | 0 | Local Recreation Area 3 | 4 |
12590 | 12590 | 12589 | {"type": "MultiPolygon", "coordinates": [[[[-121.85334, 38.00077], [-121.85324, 38.00103], [-121.84355, 37.99869], [-121.84381, 37.99847], [-121.85334, 38.00077]]], [[[-121.86747, 38.00445], [-121.86628, 38.00416], [-121.85344, 38.00108], [-121.85354, 38.00081], [-121.86198, 38.00284], [-121.86745, 38.00415], [-121.86749, 38.00417], [-121.8675, 38.00421], [-121.8675, 38.00433], [-121.86747, 38.00445]]], [[[-121.87183, 38.0052], [-121.87172, 38.00547], [-121.87081, 38.00525], [-121.86765, 38.00449], [-121.86768, 38.00436], [-121.86769, 38.00421], [-121.87183, 38.0052]]], [[[-121.8869, 38.00883], [-121.88683, 38.00909], [-121.87202, 38.00554], [-121.87212, 38.00527], [-121.8869, 38.00883]]], [[[-121.89186, 38.01001], [-121.89176, 38.01027], [-121.88716, 38.00917], [-121.88724, 38.0089], [-121.89186, 38.01001]]], [[[-121.89824, 38.01154], [-121.89814, 38.0118], [-121.89229, 38.0104], [-121.89239, 38.01014], [-121.89824, 38.01154]]], [[[-121.90445, 38.01304], [-121.9044, 38.01314], [-121.90428, 38.01328], [-121.8984, 38.01187], [-121.8985, 38.01161], [-121.90445, 38.01304]]], [[[-121.91117, 38.01465], [-121.9108, 38.01484], [-121.90446, 38.01332], [-121.90455, 38.01323], [-121.90463, 38.01308], [-121.91117, 38.01465]]], [[[-121.91293, 38.01535], [-121.91117, 38.01493], [-121.91117, 38.01493], [-121.91152, 38.01473], [-121.91251, 38.01496], [-121.91293, 38.01535]]], [[[-121.91986, 38.01673], [-121.91984, 38.01684], [-121.91985, 38.01702], [-121.91408, 38.01563], [-121.91365, 38.01549], [-121.91345, 38.01539], [-121.91325, 38.01527], [-121.91303, 38.0151], [-121.91986, 38.01673]]], [[[-121.92799, 38.01869], [-121.92716, 38.01877], [-121.92003, 38.01707], [-121.92001, 38.01693], [-121.92002, 38.01677], [-121.92799, 38.01869]]], [[[-121.93521, 38.02068], [-121.9328, 38.02011], [-121.93046, 38.01956], [-121.93156, 38.01953], [-121.9352, 38.02039], [-121.93521, 38.02068]]], [[[-121.93603, 38.02088], [-121.93538, 38.02072], [-121.93538, 38.02043], [-121.93602, 38.02059], [-121.93603, 38.02088]]], [[[-121.93687, 38.02108], [-121.9362, 38.02092], [-121.9362, 38.02063], [-121.93687, 38.02079], [-121.93687, 38.02108]]], [[[-121.94171, 38.02224], [-121.93704, 38.02112], [-121.93704, 38.02083], [-121.94171, 38.02195], [-121.94171, 38.02224]]], [[[-121.95116, 38.02451], [-121.95018, 38.02428], [-121.95007, 38.0259], [-121.95, 38.02589], [-121.9501, 38.02425], [-121.94212, 38.02234], [-121.94205, 38.02234], [-121.94204, 38.02203], [-121.95116, 38.02422], [-121.95116, 38.02451]]], [[[-121.95228, 38.02478], [-121.95133, 38.02455], [-121.95133, 38.02426], [-121.95227, 38.02449], [-121.95228, 38.02478]]], [[[-121.95332, 38.02503], [-121.95242, 38.02481], [-121.95242, 38.02452], [-121.95331, 38.02474], [-121.95332, 38.02503]]], [[[-121.95436, 38.02499], [-121.95436, 38.02528], [-121.95345, 38.02506], [-121.95345, 38.02477], [-121.95436, 38.02499]]], [[[-121.95584, 38.02563], [-121.9545, 38.02531], [-121.9545, 38.02502], [-121.95584, 38.02534], [-121.95584, 38.02563]]], [[[-121.95727, 38.02597], [-121.95602, 38.02567], [-121.95602, 38.02539], [-121.95726, 38.02569], [-121.95727, 38.02597]]], [[[-121.95987, 38.02631], [-121.95932, 38.02647], [-121.95741, 38.02601], [-121.95741, 38.02572], [-121.95987, 38.02631]]]]} | Open Access 1 | 29162 | Delta De Anza Regional Trail | 18069 | 2031 | East Bay Municipal Utility District 433 | Special District 4 | Water District 13 | http://www.ebmud.com/ | Special District 4 | 2031 | East Bay Municipal Utility District 427 | Special District 4 | Water District 13 | Contra Costa 12 | 75.03 | Delta De Anza Reg. Trail | 0 | Local Recreation Area 3 | 4 | |
12616 | 12616 | 12615 | {"type": "Polygon", "coordinates": [[[-122.11236, 37.89111], [-122.11234, 37.89111], [-122.11224, 37.89126], [-122.11214, 37.89136], [-122.11187, 37.89146], [-122.11178, 37.89161], [-122.11167, 37.89192], [-122.11167, 37.89221], [-122.1114, 37.89225], [-122.11132, 37.89205], [-122.11155, 37.89177], [-122.11166, 37.89144], [-122.11195, 37.89118], [-122.1122, 37.89108], [-122.1122, 37.89103], [-122.11235, 37.89102], [-122.11236, 37.89111]]]} | Open Access 1 | 29415 | Briones/Las Trampas Trail | 16396 | 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.765 | Briones/Las Trampas Trail | 0 | Local Recreation Area 3 | 4 | |
12621 | 12621 | 12620 | {"type": "MultiPolygon", "coordinates": [[[[-122.10336, 37.88915], [-122.10325, 37.88929], [-122.09952, 37.88684], [-122.09906, 37.88657], [-122.09871, 37.8864], [-122.09832, 37.88626], [-122.09812, 37.88621], [-122.09789, 37.88617], [-122.09798, 37.88599], [-122.09846, 37.88612], [-122.09878, 37.88625], [-122.09907, 37.88638], [-122.09965, 37.88671], [-122.10336, 37.88915]]], [[[-122.1019, 37.86205], [-122.09983, 37.86557], [-122.09945, 37.86633], [-122.09932, 37.86665], [-122.0991, 37.8673], [-122.09905, 37.86718], [-122.09902, 37.86708], [-122.09902, 37.86693], [-122.09904, 37.86683], [-122.09942, 37.86591], [-122.09959, 37.86561], [-122.10171, 37.86198], [-122.1019, 37.86205]]], [[[-122.10312, 37.8574], [-122.10291, 37.8578], [-122.10264, 37.85858], [-122.10249, 37.85922], [-122.10222, 37.86073], [-122.10215, 37.86103], [-122.10202, 37.8614], [-122.10184, 37.86175], [-122.10186, 37.86166], [-122.10186, 37.86153], [-122.10177, 37.86092], [-122.10174, 37.86061], [-122.10175, 37.86053], [-122.1018, 37.86052], [-122.10189, 37.85867], [-122.10206, 37.85862], [-122.1022, 37.85863], [-122.10237, 37.85834], [-122.10243, 37.85804], [-122.10203, 37.85798], [-122.10216, 37.85747], [-122.10262, 37.85738], [-122.10272, 37.85714], [-122.10312, 37.8574]]], [[[-122.11101, 37.89088], [-122.11069, 37.89095], [-122.11037, 37.89099], [-122.11005, 37.89101], [-122.10971, 37.89099], [-122.10651, 37.89056], [-122.10567, 37.89038], [-122.10492, 37.89015], [-122.10424, 37.88986], [-122.10384, 37.88965], [-122.10339, 37.88938], [-122.10349, 37.88924], [-122.10392, 37.88949], [-122.10446, 37.88977], [-122.10501, 37.89], [-122.1057, 37.89022], [-122.1066, 37.8904], [-122.10953, 37.89081], [-122.10981, 37.89083], [-122.1101, 37.89084], [-122.1104, 37.89082], [-122.11069, 37.89078], [-122.11099, 37.89072], [-122.11101, 37.89088]]]]} | Open Access 1 | 29414 | Lafayette/Moraga Trail | 20836 | 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 | 14.096 | Lafayette/Moraga Trail | 0 | Local Recreation Area 3 | 4 | |
12726 | 12726 | 12725 | {"type": "MultiPolygon", "coordinates": [[[[-121.93312, 37.96917], [-121.93309, 37.9762], [-121.92397, 37.97636], [-121.92389, 37.98339], [-121.91481, 37.9835], [-121.91485, 37.97467], [-121.91541, 37.97455], [-121.91619, 37.97432], [-121.91638, 37.97432], [-121.91684, 37.97403], [-121.917, 37.97372], [-121.91739, 37.97344], [-121.91795, 37.97331], [-121.91823, 37.97315], [-121.91876, 37.97249], [-121.91908, 37.97226], [-121.91945, 37.97219], [-121.91991, 37.97201], [-121.92004, 37.97193], [-121.92076, 37.97121], [-121.92124, 37.97103], [-121.92209, 37.97065], [-121.92264, 37.97037], [-121.92271, 37.9702], [-121.9229, 37.97006], [-121.92356, 37.96996], [-121.92384, 37.9698], [-121.9245, 37.96925], [-121.93312, 37.96917]]], [[[-121.92264, 37.96928], [-121.922, 37.96996], [-121.92175, 37.97005], [-121.92152, 37.97027], [-121.92122, 37.97042], [-121.9205, 37.9709], [-121.91988, 37.97127], [-121.91761, 37.97247], [-121.91709, 37.97284], [-121.91631, 37.97367], [-121.91588, 37.97391], [-121.91493, 37.9742], [-121.91489, 37.96938], [-121.92264, 37.96928]]]]} | No Public Access 3 | 29753 | CNWS to Black Diamond | 17451 | 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 | 449.119 | CNWS to Black Diamond | 0 | Local Recreation Area 3 | 4 | |
13048 | 13048 | 13047 | {"type": "MultiPolygon", "coordinates": [[[[-121.72319, 37.95393], [-121.72319, 37.95429], [-121.71709, 37.95429], [-121.71684, 37.95402], [-121.72238, 37.95401], [-121.72319, 37.95393]]], [[[-121.74157, 37.95436], [-121.72891, 37.9543], [-121.72334, 37.95429], [-121.72334, 37.95393], [-121.73271, 37.95396], [-121.73358, 37.95405], [-121.74157, 37.95409], [-121.74157, 37.95436]]], [[[-121.75526, 37.95876], [-121.75511, 37.959], [-121.75087, 37.95721], [-121.75086, 37.9569], [-121.75526, 37.95876]]], [[[-121.75973, 37.96095], [-121.75912, 37.96069], [-121.75529, 37.95908], [-121.75546, 37.95884], [-121.75967, 37.96062], [-121.75973, 37.96095]]], [[[-121.78005, 37.96603], [-121.77993, 37.96623], [-121.77859, 37.96572], [-121.76918, 37.96356], [-121.76557, 37.96268], [-121.762, 37.96191], [-121.76189, 37.96186], [-121.76264, 37.96186], [-121.76317, 37.96189], [-121.76341, 37.96191], [-121.76411, 37.96204], [-121.76918, 37.96327], [-121.7779, 37.96525], [-121.77849, 37.96541], [-121.77931, 37.96568], [-121.77999, 37.96595], [-121.78004, 37.96599], [-121.78005, 37.96603]]], [[[-121.78567, 37.96827], [-121.78552, 37.96854], [-121.7852, 37.96829], [-121.78027, 37.96636], [-121.7804, 37.96617], [-121.78044, 37.96615], [-121.78051, 37.96616], [-121.78507, 37.96793], [-121.78541, 37.96805], [-121.78567, 37.96827]]], [[[-121.78823, 37.97022], [-121.78813, 37.97034], [-121.78807, 37.97047], [-121.7857, 37.96867], [-121.78585, 37.96841], [-121.78823, 37.97022]]], [[[-121.79282, 37.9737], [-121.79258, 37.9739], [-121.78823, 37.97059], [-121.78825, 37.97052], [-121.78833, 37.97038], [-121.78838, 37.97032], [-121.79282, 37.9737]]], [[[-121.80043, 37.97808], [-121.80022, 37.97834], [-121.79904, 37.97671], [-121.79894, 37.97665], [-121.79731, 37.9758], [-121.7968, 37.9758], [-121.79679, 37.97553], [-121.79568, 37.97495], [-121.79374, 37.97477], [-121.79273, 37.97401], [-121.79297, 37.97381], [-121.79389, 37.97451], [-121.7958, 37.97468], [-121.79931, 37.97651], [-121.80043, 37.97808]]], [[[-121.80353, 37.98089], [-121.8035, 37.98091], [-121.80316, 37.98092], [-121.80119, 37.97969], [-121.80034, 37.9785], [-121.80055, 37.97824], [-121.80146, 37.9795], [-121.80353, 37.98079], [-121.80353, 37.98089]]], [[[-121.80543, 37.98233], [-121.80391, 37.98138], [-121.80352, 37.98114], [-121.80408, 37.98113], [-121.80541, 37.98196], [-121.80543, 37.98233]]], [[[-121.80773, 37.98341], [-121.80759, 37.98349], [-121.80747, 37.9836], [-121.80586, 37.9826], [-121.80584, 37.9826], [-121.80581, 37.98223], [-121.80773, 37.98341]]], [[[-121.81051, 37.98513], [-121.81029, 37.98535], [-121.80763, 37.9837], [-121.80776, 37.9836], [-121.80791, 37.98352], [-121.81051, 37.98513]]], [[[-121.81741, 37.98943], [-121.8173, 37.98953], [-121.81715, 37.98962], [-121.81043, 37.98544], [-121.81064, 37.98522], [-121.81741, 37.98943]]], [[[-121.82223, 37.99262], [-121.82219, 37.99266], [-121.82205, 37.99268], [-121.81732, 37.98973], [-121.81744, 37.98965], [-121.81757, 37.98953], [-121.82222, 37.99242], [-121.82223, 37.99262]]], [[[-121.82676, 37.99526], [-121.82655, 37.99547], [-121.82263, 37.99303], [-121.82258, 37.99281], [-121.82264, 37.99277], [-121.82275, 37.99276], [-121.82676, 37.99526]]], [[[-121.83178, 37.99794], [-121.83051, 37.99794], [-121.82671, 37.99557], [-121.82692, 37.99536], [-121.83063, 37.99767], [-121.83167, 37.99767], [-121.83173, 37.99779], [-121.83178, 37.99794]]], [[[-121.83458, 37.99767], [-121.83457, 37.99795], [-121.83199, 37.99794], [-121.83195, 37.99779], [-121.8319, 37.99767], [-121.83458, 37.99767]]], [[[-121.83789, 37.99768], [-121.83789, 37.99795], [-121.83479, 37.99795], [-121.83479, 37.99767], [-121.83789, 37.99768]]], [[[-121.84196, 37.99803], [-121.84136, 37.99817], [-121.84044, 37.99795], [-121.83811, 37.99795], [-121.8381, 37.99768], [-121.84051, 37.99768], [-121.84196, 37.99803]]], [[[-121.84351, 37.9984], [-121.84325, 37.99862], [-121.84188, 37.99829], [-121.84266, 37.99819], [-121.84351, 37.9984]]]]} | Open Access 1 | 34900 | Mokelumne Trail | 22359 | 2031 | East Bay Municipal Utility District 433 | Special District 4 | Water District 13 | http://www.ebmud.com/ | Special District 4 | 2031 | East Bay Municipal Utility District 427 | Special District 4 | Water District 13 | Contra Costa 12 | 86.275 | Mokelumne Trail | 0 | Local Recreation Area 3 | 4 | |
13139 | 13139 | 13138 | {"type": "Polygon", "coordinates": [[[-122.15677, 37.87154], [-122.15675, 37.87257], [-122.15558, 37.87257], [-122.15547, 37.88114], [-122.15566, 37.8812], [-122.15587, 37.88131], [-122.1554, 37.88262], [-122.15431, 37.88251], [-122.15411, 37.88268], [-122.15363, 37.88279], [-122.15273, 37.88546], [-122.14988, 37.8858], [-122.1449, 37.88817], [-122.14181, 37.88744], [-122.14087, 37.88825], [-122.14039, 37.88802], [-122.13926, 37.88775], [-122.13927, 37.88759], [-122.13794, 37.88741], [-122.1381, 37.88677], [-122.1367, 37.88633], [-122.13634, 37.88557], [-122.13068, 37.8838], [-122.1307, 37.88361], [-122.13091, 37.88364], [-122.13178, 37.88115], [-122.12938, 37.88116], [-122.12935, 37.87938], [-122.12703, 37.87937], [-122.12698, 37.87752], [-122.12933, 37.8775], [-122.12933, 37.87476], [-122.13381, 37.8747], [-122.13382, 37.87558], [-122.13613, 37.87556], [-122.13609, 37.87187], [-122.14177, 37.87187], [-122.14175, 37.86827], [-122.14415, 37.86832], [-122.14414, 37.86789], [-122.14465, 37.86732], [-122.1451, 37.86758], [-122.14471, 37.86803], [-122.14481, 37.86816], [-122.14528, 37.86838], [-122.14954, 37.86953], [-122.15677, 37.87154]]]} | Open Access 1 | 35074 | Lafayette Reservoir | 3197 | 2031 | East Bay Municipal Utility District 433 | Special District 4 | Water District 13 | http://www.ebmud.com/ | Special District 4 | 2031 | East Bay Municipal Utility District 427 | Special District 4 | Water District 13 | https://www.ebmud.com/recreation/lafayette-reservoir | Contra Costa 12 | 922.883 | Lafayette Reservoir | 0 | Local Recreation Area 3 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]), FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]), FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]), FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]), FOREIGN KEY([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);