superunits_with_maps

Table actions

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

1 row where ACCESS_TYP = 1 and LABEL_NAME = "Carquinez Strait Reg. Shoreline"

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY

MNG_AG_TYP 1

ACCESS_TYP 1

  • Open Access · 1 ✖
Link rowid ▼ id map ACCESS_TYP PARK_NAME PARK_URL SUID_NMA MNG_AG_ID MNG_AGENCY MNG_AG_LEV MNG_AG_TYP AGNCY_WEB LAYER ACRES LABEL_NAME YR_EST
548 548 547 {"type": "MultiPolygon", "coordinates": [[[[-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.02334], [-122.16518, 38.02346], [-122.16492, 38.02371], [-122.16481, 38.02386], [-122.16485, 38.0239], [-122.16452, 38.02439], [-122.16434, 38.02458], [-122.16435, 38.02461], [-122.16413, 38.02475], [-122.16323, 38.02509], [-122.16314, 38.0251], [-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.02415], [-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.15881, 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.14952, 38.0199], [-122.14953, 38.0198], [-122.14956, 38.01971], [-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.01924], [-122.15051, 38.01918], [-122.15049, 38.01911], [-122.15045, 38.01905], [-122.15038, 38.019], [-122.15007, 38.01888], [-122.1499, 38.01884], [-122.14967, 38.01884], [-122.14907, 38.01893], [-122.14896, 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.1458, 38.01647], [-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.01548], [-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.0151], [-122.14283, 38.01544], [-122.14233, 38.01485], [-122.14242, 38.01477], [-122.14192, 38.01423], [-122.14269, 38.01376], [-122.14604, 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.14296, 38.00718], [-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.13813, 37.99829], [-122.13646, 37.99808], [-122.13547, 37.99708], [-122.13581, 37.99686], [-122.13595, 37.99664], [-122.1362, 37.99662], [-122.1384, 37.99633], [-122.13947, 37.99497], [-122.13963, 37.99483], [-122.13969, 37.99464], [-122.13965, 37.99446], [-122.13946, 37.99412], [-122.13939, 37.99408], [-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.14187, 37.99354], [-122.14257, 37.99596], [-122.1445, 37.99725], [-122.14453, 37.99733], [-122.14372, 37.99756], [-122.14299, 37.99779], [-122.14298, 37.99781], [-122.1445, 37.99934], [-122.14484, 37.99915], [-122.14531, 37.99942], [-122.14573, 37.99933], [-122.14657, 37.99988], [-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.01281], [-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.01911], [-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.14977, 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.14946, 38.01952], [-122.14939, 38.01963], [-122.14934, 38.01976], [-122.14932, 38.0199], [-122.14937, 38.02046], [-122.1494, 38.02055], [-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.02407], [-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.16146, 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.0249], [-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.16607, 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.16751, 38.02812], [-122.16761, 38.02801], [-122.16908, 38.02856], [-122.16925, 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.02818], [-122.17015, 38.02805], [-122.17019, 38.02779], [-122.17026, 38.02774], [-122.17035, 38.02775], [-122.1704, 38.0278], [-122.17047, 38.02827], [-122.17055, 38.02853], [-122.17061, 38.02865], [-122.17071, 38.0288], [-122.17078, 38.02886], [-122.17081, 38.02893], [-122.17082, 38.02901], [-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.17867, 38.04091], [-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.18453, 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.05206], [-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.20807, 38.05449], [-122.20813, 38.05454], [-122.20799, 38.05491], [-122.20642, 38.05455], [-122.20646, 38.05441], [-122.20598, 38.05429], [-122.20597, 38.05417], [-122.20528, 38.054], [-122.205, 38.05421], [-122.20434, 38.05405], [-122.20422, 38.05362], [-122.20346, 38.05343], [-122.20306, 38.05373], [-122.20086, 38.05319], [-122.1989, 38.05282], [-122.1984, 38.05276], [-122.19813, 38.0522], [-122.19761, 38.05215], [-122.19717, 38.05262], [-122.19679, 38.05258], [-122.19677, 38.05255], [-122.19644, 38.05254], [-122.19643, 38.05213], [-122.19369, 38.05204], [-122.19368, 38.0519], [-122.19221, 38.05185], [-122.19217, 38.0524], [-122.19182, 38.05238], [-122.1919, 38.0517], [-122.19159, 38.05166], [-122.19128, 38.05159], [-122.19093, 38.05147], [-122.19076, 38.05139], [-122.19015, 38.05105], [-122.19004, 38.05115], [-122.18888, 38.0505], [-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.18601, 38.04599], [-122.18626, 38.04589], [-122.18667, 38.04581], [-122.18667, 38.04575], [-122.18793, 38.04549], [-122.18799, 38.04561], [-122.18852, 38.04551], [-122.19098, 38.04617], [-122.19108, 38.04598], [-122.19196, 38.04653], [-122.1934, 38.04716], [-122.19363, 38.04725], [-122.19376, 38.04728], [-122.19401, 38.0473], [-122.19426, 38.04728], [-122.19438, 38.04726], [-122.19508, 38.04703], [-122.19538, 38.04756], [-122.19593, 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.19672, 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.19731, 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.19952, 38.05044], [-122.19967, 38.05041], [-122.19977, 38.05037], [-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.20243, 38.05066], [-122.20239, 38.05084], [-122.20237, 38.05104], [-122.20239, 38.05123], [-122.20242, 38.05142], [-122.20251, 38.05162], [-122.20263, 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.20783, 38.05211], [-122.20786, 38.05204], [-122.20796, 38.0519], [-122.20812, 38.05176], [-122.20834, 38.05161], [-122.20845, 38.05157], [-122.20856, 38.0516]]], [[[-122.21027, 38.05573], [-122.20658, 38.0551], [-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 Carquinez Strait Regional Shoreline http://www.ebparks.org/parks/carquinez 6373 2032 East Bay Regional Park District 87 Special District 4 Recreation/Parks District 4 http://www.ebparks.org/ Special District 4 1294.074 Carquinez Strait Reg. Shoreline 1981

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE superunits_with_maps(
  id INT,
  map,
  ACCESS_TYP INT,
  PARK_NAME TEXT,
  PARK_URL TEXT,
  SUID_NMA INT,
  MNG_AG_ID INT,
  MNG_AGENCY INT,
  MNG_AG_LEV INT,
  MNG_AG_TYP INT,
  AGNCY_WEB TEXT,
  LAYER INT,
  ACRES REAL,
  LABEL_NAME TEXT,
  YR_EST INT,
   FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id])
);
CREATE INDEX [idx_superunits_with_maps_LAYER]
    ON [superunits_with_maps] ([LAYER]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP]
    ON [superunits_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV]
    ON [superunits_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY]
    ON [superunits_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP]
    ON [superunits_with_maps] ([ACCESS_TYP]);