units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
5 rows where DES_TP = 2, MNG_AGENCY = 87 and UNIT_NAME = "Carquinez Strait Regional Shoreline"
This data as json, copyable, CSV (advanced)
Suggested facets: SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, YR_EST
ACCESS_TYP 3
MNG_AG_TYP 1
MNG_AGENCY 1
- East Bay Regional Park District · 5 ✖
DES_TP 1
- Local Park · 5 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7732 | 7732 | 7731 | {"type": "MultiPolygon", "coordinates": [[[[-122.14214, 37.99234], [-122.14187, 37.99354], [-122.14098, 37.99331], [-122.14097, 37.99332], [-122.14143, 37.99374], [-122.14185, 37.99588], [-122.1384, 37.99633], [-122.13947, 37.99497], [-122.13963, 37.99483], [-122.13969, 37.99464], [-122.13965, 37.99445], [-122.13946, 37.99412], [-122.13939, 37.99407], [-122.13928, 37.99417], [-122.13902, 37.99403], [-122.13888, 37.99391], [-122.1388, 37.99377], [-122.13877, 37.99361], [-122.13871, 37.99243], [-122.13811, 37.99142], [-122.13932, 37.99171], [-122.1416, 37.99179], [-122.14214, 37.99234]]], [[[-122.17154, 38.01945], [-122.17002, 38.02037], [-122.16946, 38.02068], [-122.16853, 38.02117], [-122.16814, 38.02148], [-122.16711, 38.02253], [-122.16688, 38.02283], [-122.16654, 38.02305], [-122.16644, 38.02299], [-122.16634, 38.02297], [-122.16623, 38.02298], [-122.1661, 38.02302], [-122.16602, 38.02297], [-122.16536, 38.02333], [-122.16518, 38.02346], [-122.16492, 38.02371], [-122.1648, 38.02387], [-122.16485, 38.0239], [-122.16452, 38.02439], [-122.16433, 38.02458], [-122.16435, 38.02461], [-122.16413, 38.02475], [-122.16323, 38.02509], [-122.16314, 38.0251], [-122.16304, 38.02508], [-122.16298, 38.02505], [-122.16262, 38.02481], [-122.16248, 38.02475], [-122.16232, 38.02471], [-122.16216, 38.02471], [-122.162, 38.02473], [-122.16178, 38.0248], [-122.16159, 38.02492], [-122.16146, 38.02492], [-122.16105, 38.0248], [-122.16025, 38.02444], [-122.16014, 38.02439], [-122.16005, 38.02432], [-122.15998, 38.02424], [-122.15993, 38.02414], [-122.15991, 38.02405], [-122.15991, 38.02395], [-122.16, 38.02373], [-122.16, 38.02367], [-122.15998, 38.02359], [-122.15993, 38.02352], [-122.15979, 38.02344], [-122.15969, 38.02343], [-122.15958, 38.02344], [-122.1588, 38.02371], [-122.15858, 38.02372], [-122.15842, 38.02368], [-122.15833, 38.02363], [-122.15821, 38.02353], [-122.15814, 38.02341], [-122.15809, 38.02317], [-122.15806, 38.02311], [-122.15798, 38.02302], [-122.15788, 38.02298], [-122.15778, 38.02296], [-122.15764, 38.02297], [-122.15754, 38.02301], [-122.15738, 38.02312], [-122.1572, 38.02317], [-122.15707, 38.02318], [-122.15694, 38.02317], [-122.15678, 38.02313], [-122.15639, 38.02291], [-122.15628, 38.0228], [-122.1562, 38.02268], [-122.15615, 38.02254], [-122.15614, 38.02241], [-122.15617, 38.02224], [-122.15622, 38.02216], [-122.15623, 38.02207], [-122.15619, 38.02196], [-122.15615, 38.02191], [-122.15603, 38.02184], [-122.15593, 38.02182], [-122.15582, 38.02182], [-122.15505, 38.02207], [-122.15487, 38.0221], [-122.15357, 38.02208], [-122.1535, 38.02206], [-122.15342, 38.02199], [-122.15339, 38.02195], [-122.15336, 38.02186], [-122.15339, 38.02177], [-122.15349, 38.02159], [-122.15379, 38.02125], [-122.15381, 38.02118], [-122.1538, 38.0211], [-122.15373, 38.02099], [-122.15365, 38.02094], [-122.15355, 38.02092], [-122.15346, 38.02092], [-122.15291, 38.02097], [-122.15277, 38.021], [-122.15222, 38.02116], [-122.15213, 38.02118], [-122.15203, 38.02117], [-122.15194, 38.02114], [-122.1518, 38.02104], [-122.15168, 38.02098], [-122.1512, 38.02081], [-122.15093, 38.02078], [-122.15051, 38.02081], [-122.15034, 38.02079], [-122.14978, 38.02063], [-122.14964, 38.02056], [-122.14958, 38.02046], [-122.14956, 38.0204], [-122.14952, 38.0199], [-122.14953, 38.0198], [-122.14956, 38.0197], [-122.14962, 38.01962], [-122.1497, 38.01954], [-122.14979, 38.01948], [-122.1499, 38.01944], [-122.15002, 38.01941], [-122.15032, 38.01939], [-122.1504, 38.01936], [-122.15046, 38.01931], [-122.1505, 38.01925], [-122.15051, 38.01918], [-122.15049, 38.01911], [-122.15045, 38.01905], [-122.15038, 38.019], [-122.15007, 38.01888], [-122.14991, 38.01884], [-122.14967, 38.01884], [-122.14929, 38.01889], [-122.14907, 38.01893], [-122.14897, 38.01897], [-122.14832, 38.01929], [-122.14811, 38.01934], [-122.14797, 38.01936], [-122.14787, 38.01935], [-122.14778, 38.01932], [-122.14771, 38.01927], [-122.14742, 38.01892], [-122.14726, 38.01879], [-122.14717, 38.01874], [-122.14591, 38.01815], [-122.14682, 38.01729], [-122.14579, 38.01646], [-122.14874, 38.01489], [-122.14872, 38.01014], [-122.14641, 38.01012], [-122.14605, 38.01047], [-122.14467, 38.00964], [-122.14388, 38.00957], [-122.14353, 38.00935], [-122.14292, 38.00874], [-122.14288, 38.00855], [-122.14263, 38.00841], [-122.14219, 38.00847], [-122.14177, 38.00833], [-122.14151, 38.0084], [-122.14144, 38.00834], [-122.14297, 38.00718], [-122.14312, 38.00586], [-122.14423, 38.00587], [-122.14497, 38.0021], [-122.14669, 37.99974], [-122.14697, 38.00002], [-122.14835, 38.0013], [-122.14883, 38.00247], [-122.15032, 38.00243], [-122.15105, 38.00281], [-122.15153, 38.00404], [-122.15338, 38.00459], [-122.15342, 38.01018], [-122.16112, 38.01025], [-122.16208, 38.01282], [-122.16359, 38.01285], [-122.16377, 38.01299], [-122.17072, 38.01803], [-122.17154, 38.01945]]], [[[-122.16323, 38.0253], [-122.16303, 38.02583], [-122.16271, 38.02625], [-122.1614, 38.02568], [-122.16072, 38.02545], [-122.15358, 38.02265], [-122.14845, 38.0206], [-122.14649, 38.01983], [-122.14649, 38.01981], [-122.14597, 38.01949], [-122.14579, 38.01945], [-122.14608, 38.01905], [-122.14624, 38.01912], [-122.14658, 38.01865], [-122.14701, 38.01885], [-122.14712, 38.01892], [-122.14731, 38.01909], [-122.14757, 38.01939], [-122.14771, 38.01947], [-122.14787, 38.01952], [-122.14811, 38.01951], [-122.14834, 38.01947], [-122.14846, 38.01943], [-122.14901, 38.01914], [-122.1492, 38.01907], [-122.14976, 38.019], [-122.14989, 38.01901], [-122.15006, 38.01905], [-122.15029, 38.01915], [-122.1503, 38.01918], [-122.15029, 38.01922], [-122.15023, 38.01925], [-122.15002, 38.01925], [-122.14986, 38.01928], [-122.14964, 38.01937], [-122.14947, 38.01952], [-122.14938, 38.01963], [-122.14934, 38.01976], [-122.14932, 38.0199], [-122.14937, 38.02046], [-122.1494, 38.02054], [-122.14945, 38.02062], [-122.14961, 38.02075], [-122.15028, 38.02095], [-122.15049, 38.02097], [-122.15095, 38.02094], [-122.15108, 38.02095], [-122.15159, 38.02113], [-122.15182, 38.02128], [-122.15202, 38.02134], [-122.15219, 38.02134], [-122.1523, 38.02132], [-122.15284, 38.02115], [-122.15348, 38.02108], [-122.15355, 38.02109], [-122.15358, 38.02112], [-122.1536, 38.02116], [-122.15358, 38.02121], [-122.15333, 38.02149], [-122.1532, 38.02171], [-122.15316, 38.02181], [-122.15316, 38.02189], [-122.15319, 38.02201], [-122.15324, 38.02208], [-122.15339, 38.02219], [-122.15348, 38.02223], [-122.15363, 38.02225], [-122.1549, 38.02227], [-122.15512, 38.02223], [-122.15584, 38.02198], [-122.15594, 38.02199], [-122.15601, 38.02205], [-122.15602, 38.02209], [-122.15593, 38.02235], [-122.15592, 38.02251], [-122.15596, 38.02266], [-122.15603, 38.0228], [-122.15621, 38.02299], [-122.15673, 38.02329], [-122.15697, 38.02335], [-122.15722, 38.02334], [-122.15745, 38.02328], [-122.15759, 38.02321], [-122.15768, 38.02314], [-122.15776, 38.02312], [-122.15781, 38.02313], [-122.15784, 38.02314], [-122.15789, 38.0232], [-122.15793, 38.0234], [-122.15796, 38.0235], [-122.15807, 38.02366], [-122.15825, 38.02379], [-122.1584, 38.02385], [-122.15856, 38.02388], [-122.15871, 38.02388], [-122.15886, 38.02386], [-122.1596, 38.0236], [-122.15965, 38.02359], [-122.15973, 38.0236], [-122.15977, 38.02362], [-122.1598, 38.02368], [-122.15971, 38.02395], [-122.15971, 38.02408], [-122.15973, 38.0242], [-122.1598, 38.02432], [-122.15989, 38.02442], [-122.16007, 38.02454], [-122.16086, 38.02491], [-122.16126, 38.02504], [-122.16147, 38.02508], [-122.16166, 38.02507], [-122.16181, 38.025], [-122.16194, 38.0249], [-122.16205, 38.02488], [-122.16223, 38.02487], [-122.16235, 38.02489], [-122.16247, 38.02494], [-122.16286, 38.02519], [-122.16284, 38.02522], [-122.16292, 38.02526], [-122.16302, 38.02529], [-122.16323, 38.0253]]], [[[-122.17096, 38.02968], [-122.17026, 38.03025], [-122.17006, 38.03002], [-122.1698, 38.02976], [-122.1695, 38.02953], [-122.16918, 38.02932], [-122.16882, 38.02914], [-122.16493, 38.02729], [-122.16531, 38.02676], [-122.16553, 38.02706], [-122.16568, 38.02718], [-122.16587, 38.02725], [-122.16605, 38.02728], [-122.16606, 38.02739], [-122.16639, 38.02738], [-122.16655, 38.02755], [-122.16666, 38.02764], [-122.16678, 38.0277], [-122.16717, 38.02779], [-122.16728, 38.02796], [-122.16739, 38.02806], [-122.16752, 38.02812], [-122.16761, 38.02801], [-122.16908, 38.02856], [-122.16926, 38.02859], [-122.16943, 38.02859], [-122.1696, 38.02855], [-122.16976, 38.0285], [-122.1699, 38.02841], [-122.17001, 38.02831], [-122.1701, 38.02819], [-122.17015, 38.02805], [-122.17019, 38.02779], [-122.17026, 38.02774], [-122.17035, 38.02775], [-122.1704, 38.0278], [-122.17048, 38.02827], [-122.17055, 38.02852], [-122.17061, 38.02865], [-122.17071, 38.0288], [-122.17078, 38.02886], [-122.17081, 38.02893], [-122.17082, 38.029], [-122.17075, 38.02927], [-122.17077, 38.02942], [-122.17084, 38.02957], [-122.17096, 38.02968]]], [[[-122.18375, 38.04237], [-122.18366, 38.04276], [-122.18334, 38.04281], [-122.18113, 38.04172], [-122.17904, 38.04266], [-122.17789, 38.04079], [-122.17821, 38.04078], [-122.17868, 38.04092], [-122.17839, 38.04003], [-122.17853, 38.03959], [-122.17887, 38.03911], [-122.17907, 38.03911], [-122.1794, 38.03921], [-122.1799, 38.03918], [-122.1805, 38.03934], [-122.1818, 38.04005], [-122.18309, 38.04143], [-122.18266, 38.04162], [-122.18266, 38.04164], [-122.18375, 38.04237]]], [[[-122.18576, 38.04593], [-122.18499, 38.04632], [-122.1848, 38.04647], [-122.18471, 38.04656], [-122.1846, 38.04673], [-122.18454, 38.04667], [-122.18441, 38.04672], [-122.18439, 38.04671], [-122.18402, 38.04687], [-122.18401, 38.04689], [-122.18395, 38.04684], [-122.18388, 38.04689], [-122.18385, 38.04686], [-122.1848, 38.04612], [-122.18576, 38.04593]]], [[[-122.20856, 38.0516], [-122.20858, 38.05172], [-122.20849, 38.05205], [-122.20844, 38.05241], [-122.20848, 38.0527], [-122.20857, 38.05296], [-122.20856, 38.05306], [-122.20853, 38.05312], [-122.20834, 38.05333], [-122.20822, 38.0537], [-122.20798, 38.05413], [-122.20796, 38.05426], [-122.20799, 38.05438], [-122.20808, 38.0545], [-122.20813, 38.05454], [-122.20799, 38.05491], [-122.20642, 38.05455], [-122.20647, 38.05441], [-122.20598, 38.05429], [-122.20597, 38.05417], [-122.20528, 38.054], [-122.205, 38.05421], [-122.20434, 38.05405], [-122.20423, 38.05362], [-122.20345, 38.05343], [-122.20306, 38.05373], [-122.20086, 38.05319], [-122.1989, 38.05282], [-122.1984, 38.05276], [-122.19814, 38.0522], [-122.19761, 38.05215], [-122.19717, 38.05262], [-122.19679, 38.05258], [-122.19678, 38.05255], [-122.19644, 38.05254], [-122.19643, 38.05213], [-122.19369, 38.05204], [-122.19369, 38.0519], [-122.1922, 38.05185], [-122.19217, 38.0524], [-122.19182, 38.05238], [-122.19191, 38.0517], [-122.19159, 38.05166], [-122.19128, 38.05159], [-122.19093, 38.05147], [-122.19076, 38.05139], [-122.19014, 38.05105], [-122.19004, 38.05115], [-122.18888, 38.05049], [-122.18847, 38.05093], [-122.18773, 38.0505], [-122.18835, 38.05055], [-122.18893, 38.04988], [-122.1884, 38.04945], [-122.18705, 38.04866], [-122.18704, 38.04858], [-122.18687, 38.0486], [-122.18593, 38.04825], [-122.18507, 38.04734], [-122.1861, 38.04705], [-122.18593, 38.04665], [-122.18588, 38.04665], [-122.18576, 38.04639], [-122.18482, 38.04665], [-122.18485, 38.0466], [-122.18497, 38.04648], [-122.18506, 38.04641], [-122.18584, 38.04603], [-122.186, 38.04599], [-122.18626, 38.04589], [-122.18667, 38.0458], [-122.18667, 38.04575], [-122.18793, 38.04549], [-122.18798, 38.04561], [-122.18852, 38.04551], [-122.19099, 38.04617], [-122.19108, 38.04598], [-122.19196, 38.04653], [-122.1934, 38.04716], [-122.19363, 38.04725], [-122.19375, 38.04728], [-122.19401, 38.0473], [-122.19426, 38.04728], [-122.19438, 38.04726], [-122.19508, 38.04703], [-122.19538, 38.04756], [-122.19594, 38.04736], [-122.19565, 38.04684], [-122.19723, 38.04632], [-122.19732, 38.04632], [-122.19741, 38.04635], [-122.19746, 38.04641], [-122.19755, 38.04669], [-122.19752, 38.04677], [-122.19746, 38.04682], [-122.1974, 38.04684], [-122.19701, 38.04691], [-122.19686, 38.04696], [-122.19677, 38.04702], [-122.19671, 38.04708], [-122.19667, 38.04718], [-122.19666, 38.04726], [-122.1967, 38.0474], [-122.19678, 38.0475], [-122.19685, 38.04755], [-122.19727, 38.04774], [-122.19742, 38.04788], [-122.19746, 38.04794], [-122.1976, 38.04835], [-122.19759, 38.04845], [-122.19756, 38.04849], [-122.19728, 38.04873], [-122.19723, 38.0488], [-122.19718, 38.04894], [-122.19718, 38.049], [-122.1972, 38.04908], [-122.1973, 38.0492], [-122.19788, 38.04956], [-122.19803, 38.04963], [-122.19829, 38.04966], [-122.19838, 38.04969], [-122.19912, 38.05033], [-122.19921, 38.05038], [-122.1993, 38.05042], [-122.19951, 38.05044], [-122.19967, 38.05041], [-122.19977, 38.05038], [-122.19988, 38.05029], [-122.19996, 38.05018], [-122.19999, 38.05008], [-122.20008, 38.04935], [-122.20015, 38.04929], [-122.20026, 38.04927], [-122.20032, 38.04928], [-122.2004, 38.04933], [-122.20109, 38.05024], [-122.20116, 38.05032], [-122.20126, 38.05039], [-122.20143, 38.05046], [-122.20155, 38.05048], [-122.20167, 38.05048], [-122.2018, 38.05046], [-122.20226, 38.05029], [-122.20236, 38.05029], [-122.20247, 38.05035], [-122.2025, 38.05042], [-122.20242, 38.05066], [-122.20239, 38.05085], [-122.20237, 38.05104], [-122.20239, 38.05123], [-122.20242, 38.05142], [-122.20251, 38.05162], [-122.20262, 38.05177], [-122.20278, 38.0519], [-122.20296, 38.052], [-122.20333, 38.05211], [-122.20352, 38.05219], [-122.20368, 38.05229], [-122.20416, 38.05268], [-122.20431, 38.05276], [-122.20449, 38.05278], [-122.20463, 38.05275], [-122.20471, 38.05272], [-122.20481, 38.05265], [-122.20494, 38.05246], [-122.20502, 38.05243], [-122.20511, 38.05244], [-122.20519, 38.05248], [-122.2057, 38.05315], [-122.20581, 38.05321], [-122.20593, 38.05325], [-122.20605, 38.05325], [-122.2062, 38.05321], [-122.20668, 38.05288], [-122.20688, 38.05279], [-122.20705, 38.05278], [-122.20731, 38.0528], [-122.2074, 38.05279], [-122.20753, 38.05274], [-122.2076, 38.0527], [-122.2077, 38.05258], [-122.20782, 38.05211], [-122.20786, 38.05204], [-122.20796, 38.0519], [-122.20812, 38.05176], [-122.20835, 38.0516], [-122.20845, 38.05157], [-122.20856, 38.0516]]], [[[-122.21027, 38.05573], [-122.20657, 38.05509], [-122.20648, 38.05547], [-122.20384, 38.05507], [-122.20016, 38.05424], [-122.20024, 38.05392], [-122.19852, 38.05361], [-122.19869, 38.05306], [-122.20091, 38.05349], [-122.20581, 38.05469], [-122.21027, 38.05573]]]]} | Open Access 1 | 8156 | Carquinez Strait Regional Shoreline | 6373 | 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/carquinez | Contra Costa 12 | 1064.993 | Carquinez Strait Reg. Shoreline | 1981 | Local Park 2 | 4 |
| 12624 | 12624 | 12623 | {"type": "Polygon", "coordinates": [[[-122.14874, 38.01489], [-122.14448, 38.01717], [-122.14388, 38.01674], [-122.14368, 38.01665], [-122.14379, 38.01658], [-122.14387, 38.0165], [-122.14414, 38.01615], [-122.14423, 38.016], [-122.14448, 38.01577], [-122.14462, 38.01569], [-122.1447, 38.01566], [-122.14493, 38.01567], [-122.14506, 38.01563], [-122.14511, 38.01555], [-122.14512, 38.01547], [-122.14508, 38.01538], [-122.14498, 38.0153], [-122.14481, 38.01521], [-122.14468, 38.01518], [-122.14455, 38.01519], [-122.14443, 38.01523], [-122.14428, 38.01537], [-122.14422, 38.0154], [-122.14374, 38.01547], [-122.14341, 38.01509], [-122.14283, 38.01544], [-122.14233, 38.01485], [-122.14243, 38.01478], [-122.14192, 38.01423], [-122.14269, 38.01377], [-122.14641, 38.01012], [-122.14872, 38.01014], [-122.14874, 38.01489]]]} | Open Access 1 | 29405 | Carquinez Strait Regional Shoreline | 6373 | 1198 | Martinez, City of 355 | City 2 | City Agency 2 | http://www.cityofmartinez.org/depts/recreation/parks/default.asp | City 2 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/parks/carquinez | Contra Costa 12 | 68.537 | Carquinez Strait Reg. Shoreline | 1981 | Local Park 2 | 4 |
| 13018 | 13018 | 13017 | {"type": "MultiPolygon", "coordinates": [[[[-122.17068, 38.03159], [-122.16962, 38.03196], [-122.16906, 38.03109], [-122.1702, 38.03076], [-122.17053, 38.03135], [-122.17068, 38.03159]]], [[[-122.1834, 38.03884], [-122.1833, 38.0389], [-122.18323, 38.03892], [-122.18138, 38.03897], [-122.17518, 38.03754], [-122.17466, 38.03492], [-122.17454, 38.03459], [-122.17438, 38.03427], [-122.17418, 38.03397], [-122.17394, 38.03368], [-122.17366, 38.03342], [-122.17335, 38.03318], [-122.17205, 38.0324], [-122.1717, 38.03218], [-122.17143, 38.03195], [-122.17118, 38.03171], [-122.17097, 38.03144], [-122.1708, 38.03116], [-122.17046, 38.03054], [-122.17026, 38.03025], [-122.17096, 38.02968], [-122.17113, 38.02976], [-122.17125, 38.0298], [-122.17139, 38.02981], [-122.17167, 38.02979], [-122.17193, 38.02983], [-122.17217, 38.02991], [-122.17229, 38.02997], [-122.17239, 38.03003], [-122.17278, 38.03033], [-122.17301, 38.03043], [-122.17315, 38.03046], [-122.17357, 38.0305], [-122.17377, 38.03051], [-122.17397, 38.03048], [-122.17428, 38.03038], [-122.17434, 38.03037], [-122.1744, 38.0304], [-122.17443, 38.03043], [-122.17497, 38.03068], [-122.18324, 38.03288], [-122.18328, 38.03838], [-122.1834, 38.03884]]], [[[-122.17505, 38.03846], [-122.17495, 38.0385], [-122.17493, 38.03848], [-122.17457, 38.03778], [-122.17462, 38.03776], [-122.17463, 38.03768], [-122.17458, 38.0374], [-122.17447, 38.03722], [-122.17442, 38.03707], [-122.17441, 38.03698], [-122.17435, 38.03688], [-122.17416, 38.03679], [-122.17408, 38.03667], [-122.174, 38.03638], [-122.17391, 38.03627], [-122.17342, 38.03595], [-122.17338, 38.0359], [-122.17342, 38.03577], [-122.17341, 38.03544], [-122.17333, 38.03511], [-122.17334, 38.03501], [-122.1733, 38.03485], [-122.17325, 38.03442], [-122.17317, 38.0341], [-122.17319, 38.034], [-122.17328, 38.03378], [-122.17324, 38.03364], [-122.17318, 38.03355], [-122.17304, 38.03342], [-122.17286, 38.03329], [-122.1729, 38.03325], [-122.17315, 38.03341], [-122.17343, 38.03363], [-122.17368, 38.03387], [-122.1739, 38.03413], [-122.17408, 38.0344], [-122.17423, 38.03469], [-122.17433, 38.035], [-122.17491, 38.03794], [-122.17499, 38.03827], [-122.17505, 38.03846]]]]} | No Public Access 3 | 46954 | Carquinez Strait Regional Shoreline | 30578 | 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 | 171.442 | Carquinez Strait Reg. Shoreline | 0 | Local Park 2 | 4 | |
| 16843 | 16843 | 16842 | {"type": "Polygon", "coordinates": [[[-122.14658, 37.99988], [-122.14497, 38.0021], [-122.14423, 38.00587], [-122.14311, 38.00586], [-122.13961, 38.00744], [-122.13941, 38.00652], [-122.13934, 38.00538], [-122.13895, 38.00276], [-122.13895, 38.00127], [-122.13854, 38.00037], [-122.13812, 37.99829], [-122.13646, 37.99808], [-122.13547, 37.99708], [-122.13581, 37.99686], [-122.13595, 37.99664], [-122.1362, 37.99662], [-122.14184, 37.99588], [-122.14143, 37.99374], [-122.14094, 37.9933], [-122.14187, 37.99354], [-122.14257, 37.99596], [-122.1445, 37.99725], [-122.14453, 37.99733], [-122.14372, 37.99756], [-122.14298, 37.99779], [-122.14298, 37.9978], [-122.1445, 37.99934], [-122.14484, 37.99915], [-122.14531, 37.99942], [-122.14573, 37.99933], [-122.14658, 37.99988]]]} | Open Access 1 | 29556 | Carquinez Strait Regional Shoreline | 6373 | 1198 | Martinez, City of 355 | City 2 | City Agency 2 | http://www.cityofmartinez.org/depts/recreation/parks/default.asp | City 2 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/parks/carquinez | Contra Costa 12 | 160.333 | Carquinez Strait Reg. Shoreline | 1981 | Local Park 2 | 4 |
| 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 |
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]);