superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where MNG_AGENCY = 87 and PARK_URL = "http://www.ebparks.org/parks/black_diamond"
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15033 | 15033 | 15032 | {"type": "MultiPolygon", "coordinates": [[[[-121.89646, 37.95371], [-121.89547, 37.95426], [-121.89138, 37.95429], [-121.89118, 37.95477], [-121.89091, 37.95526], [-121.89062, 37.95563], [-121.89041, 37.95601], [-121.89034, 37.95603], [-121.88893, 37.95706], [-121.88847, 37.95757], [-121.88816, 37.95772], [-121.88765, 37.95786], [-121.88732, 37.95807], [-121.8875, 37.95838], [-121.88778, 37.95852], [-121.88799, 37.95867], [-121.88797, 37.95916], [-121.88815, 37.95976], [-121.88837, 37.96119], [-121.88706, 37.96117], [-121.88395, 37.96152], [-121.88189, 37.96148], [-121.88137, 37.95904], [-121.88135, 37.95818], [-121.88132, 37.95806], [-121.88126, 37.95796], [-121.88112, 37.95783], [-121.8809, 37.95773], [-121.87919, 37.95723], [-121.87909, 37.95718], [-121.87902, 37.95712], [-121.87897, 37.95704], [-121.87892, 37.95654], [-121.87889, 37.95648], [-121.87883, 37.95642], [-121.87868, 37.95635], [-121.87787, 37.95615], [-121.87742, 37.95582], [-121.87741, 37.95584], [-121.87742, 37.95597], [-121.87779, 37.95625], [-121.87864, 37.95645], [-121.87874, 37.95651], [-121.87879, 37.9566], [-121.87884, 37.95707], [-121.8789, 37.95718], [-121.879, 37.95727], [-121.87914, 37.95733], [-121.88094, 37.95786], [-121.88104, 37.95792], [-121.88115, 37.95802], [-121.88119, 37.95811], [-121.88122, 37.95824], [-121.87945, 37.9582], [-121.87758, 37.95783], [-121.87648, 37.95743], [-121.87573, 37.95697], [-121.8751, 37.95645], [-121.87498, 37.95636], [-121.87477, 37.95628], [-121.87453, 37.95625], [-121.87437, 37.95627], [-121.87425, 37.9563], [-121.8735, 37.95655], [-121.87336, 37.95661], [-121.87318, 37.95675], [-121.87256, 37.95742], [-121.87247, 37.9575], [-121.87231, 37.95758], [-121.87218, 37.95761], [-121.87205, 37.95762], [-121.87105, 37.95762], [-121.86993, 37.9578], [-121.86978, 37.95784], [-121.86964, 37.9579], [-121.86933, 37.95815], [-121.86927, 37.95817], [-121.8692, 37.95816], [-121.86879, 37.95799], [-121.86873, 37.95794], [-121.86875, 37.95788], [-121.86908, 37.95745], [-121.86914, 37.95732], [-121.86913, 37.95718], [-121.86905, 37.95706], [-121.86898, 37.95701], [-121.86888, 37.95697], [-121.86815, 37.95674], [-121.86769, 37.95671], [-121.86744, 37.95673], [-121.8671, 37.95666], [-121.86596, 37.95683], [-121.86555, 37.95681], [-121.86505, 37.95696], [-121.86455, 37.95685], [-121.86399, 37.95737], [-121.86312, 37.95756], [-121.86227, 37.95808], [-121.86193, 37.95755], [-121.86136, 37.95727], [-121.8607, 37.95673], [-121.8603, 37.95611], [-121.86012, 37.95434], [-121.85981, 37.95421], [-121.85955, 37.95421], [-121.85955, 37.95423], [-121.85999, 37.95441], [-121.86016, 37.95614], [-121.86059, 37.95679], [-121.86127, 37.95735], [-121.86182, 37.95763], [-121.86216, 37.95815], [-121.8621, 37.95819], [-121.8621, 37.95832], [-121.86142, 37.95877], [-121.86131, 37.96034], [-121.86169, 37.96068], [-121.8612, 37.96123], [-121.86178, 37.96162], [-121.8628, 37.96575], [-121.86308, 37.96875], [-121.86309, 37.96932], [-121.86303, 37.96988], [-121.8629, 37.97042], [-121.86173, 37.97416], [-121.86175, 37.9743], [-121.86199, 37.97463], [-121.86201, 37.97471], [-121.86132, 37.97567], [-121.85758, 37.9795], [-121.85743, 37.97974], [-121.85738, 37.97987], [-121.85731, 37.98018], [-121.85725, 37.98032], [-121.8571, 37.98051], [-121.85696, 37.98061], [-121.85678, 37.98069], [-121.85551, 37.98107], [-121.85529, 37.98117], [-121.8552, 37.98124], [-121.85504, 37.98139], [-121.85497, 37.98148], [-121.85488, 37.98166], [-121.85444, 37.9832], [-121.85128, 37.98322], [-121.85128, 37.96873], [-121.84221, 37.96871], [-121.83762, 37.96865], [-121.8375, 37.96762], [-121.83446, 37.96601], [-121.83382, 37.96588], [-121.83352, 37.96573], [-121.82388, 37.9656], [-121.82386, 37.96572], [-121.82254, 37.96573], [-121.82246, 37.96552], [-121.81655, 37.96554], [-121.81654, 37.96523], [-121.81738, 37.96523], [-121.81776, 37.9652], [-121.81812, 37.96509], [-121.81814, 37.96531], [-121.82142, 37.9653], [-121.82194, 37.96525], [-121.82221, 37.96513], [-121.82233, 37.9651], [-121.82175, 37.96332], [-121.82185, 37.96263], [-121.82219, 37.96185], [-121.82287, 37.96063], [-121.82315, 37.95986], [-121.82322, 37.95927], [-121.82347, 37.95835], [-121.82341, 37.95721], [-121.8238, 37.95659], [-121.82384, 37.956], [-121.82403, 37.95587], [-121.82405, 37.9546], [-121.82248, 37.95387], [-121.82078, 37.9529], [-121.82097, 37.95257], [-121.82113, 37.9524], [-121.8213, 37.95226], [-121.82157, 37.95212], [-121.8226, 37.95167], [-121.82406, 37.95108], [-121.82403, 37.93932], [-121.8054, 37.93941], [-121.8054, 37.939], [-121.82404, 37.9389], [-121.82406, 37.93931], [-121.83233, 37.93921], [-121.83237, 37.93207], [-121.85002, 37.93212], [-121.85, 37.93907], [-121.85014, 37.94637], [-121.85479, 37.94636], [-121.85485, 37.95029], [-121.85942, 37.95027], [-121.86822, 37.95029], [-121.86815, 37.94629], [-121.89127, 37.94621], [-121.89632, 37.94622], [-121.89646, 37.95371]]], [[[-121.88175, 37.96148], [-121.87777, 37.96143], [-121.87827, 37.9691], [-121.87845, 37.97639], [-121.86133, 37.97596], [-121.86147, 37.97581], [-121.8622, 37.97477], [-121.86222, 37.97469], [-121.8622, 37.9746], [-121.86195, 37.97425], [-121.86194, 37.97415], [-121.8631, 37.97046], [-121.86324, 37.9699], [-121.8633, 37.96933], [-121.86328, 37.96874], [-121.863, 37.96573], [-121.86197, 37.96154], [-121.86147, 37.9612], [-121.86195, 37.96068], [-121.86152, 37.96029], [-121.86162, 37.95885], [-121.8623, 37.9584], [-121.86231, 37.95827], [-121.86322, 37.95771], [-121.86411, 37.95751], [-121.86462, 37.95704], [-121.86506, 37.95714], [-121.86558, 37.95698], [-121.86598, 37.957], [-121.86709, 37.95683], [-121.86742, 37.9569], [-121.86769, 37.95687], [-121.86814, 37.95691], [-121.86886, 37.95714], [-121.86893, 37.95723], [-121.86892, 37.95733], [-121.86855, 37.95783], [-121.86853, 37.95788], [-121.86853, 37.95796], [-121.86859, 37.95807], [-121.86869, 37.95814], [-121.86914, 37.95832], [-121.86931, 37.95833], [-121.86939, 37.95831], [-121.86947, 37.95826], [-121.86976, 37.95804], [-121.86998, 37.95796], [-121.87107, 37.95778], [-121.87214, 37.95778], [-121.87239, 37.95773], [-121.87254, 37.95766], [-121.87267, 37.95757], [-121.87335, 37.95685], [-121.87348, 37.95675], [-121.87433, 37.95645], [-121.87448, 37.95642], [-121.87465, 37.95643], [-121.87481, 37.95647], [-121.87491, 37.95653], [-121.8756, 37.9571], [-121.87637, 37.95757], [-121.87751, 37.95798], [-121.87942, 37.95837], [-121.88122, 37.95841], [-121.88124, 37.95905], [-121.88175, 37.96148]]], [[[-121.89647, 37.95425], [-121.89647, 37.95425], [-121.89577, 37.95425], [-121.89646, 37.95387], [-121.89647, 37.95425]]]]} | Open Access 1 | Black Diamond Mines Regional Preserve | http://www.ebparks.org/parks/black_diamond | 3220 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 4624.478 | Black Diamond Mines RPr | 1976 |
15041 | 15041 | 15040 | {"type": "MultiPolygon", "coordinates": [[[[-121.82405, 37.95459], [-121.82403, 37.95587], [-121.82384, 37.956], [-121.8238, 37.95659], [-121.82341, 37.95721], [-121.82347, 37.95835], [-121.82322, 37.95927], [-121.82315, 37.95986], [-121.82287, 37.96062], [-121.82219, 37.96185], [-121.82185, 37.96263], [-121.82175, 37.96332], [-121.82234, 37.96511], [-121.82221, 37.96513], [-121.82195, 37.96525], [-121.82142, 37.9653], [-121.81821, 37.96531], [-121.81821, 37.9652], [-121.81844, 37.9652], [-121.81965, 37.96474], [-121.82073, 37.96398], [-121.82117, 37.96328], [-121.8213, 37.96257], [-121.82217, 37.96093], [-121.82167, 37.95897], [-121.81893, 37.95724], [-121.81698, 37.95723], [-121.81642, 37.95677], [-121.81448, 37.95723], [-121.81358, 37.95805], [-121.81199, 37.95807], [-121.81104, 37.9574], [-121.81033, 37.95743], [-121.80803, 37.95851], [-121.80688, 37.95779], [-121.80721, 37.95745], [-121.80727, 37.95731], [-121.80791, 37.95736], [-121.8082, 37.95736], [-121.80847, 37.95731], [-121.80908, 37.95716], [-121.80946, 37.95709], [-121.80985, 37.95705], [-121.81187, 37.95693], [-121.81221, 37.95689], [-121.813, 37.95667], [-121.8133, 37.95662], [-121.81389, 37.95658], [-121.81402, 37.95655], [-121.81414, 37.9565], [-121.81424, 37.95641], [-121.8143, 37.95629], [-121.81431, 37.95617], [-121.81425, 37.95603], [-121.81412, 37.95591], [-121.81367, 37.95565], [-121.81325, 37.95547], [-121.81327, 37.9554], [-121.81323, 37.95537], [-121.8132, 37.95481], [-121.81139, 37.95483], [-121.8114, 37.95555], [-121.81277, 37.95554], [-121.81315, 37.95564], [-121.81322, 37.95552], [-121.81348, 37.95562], [-121.81408, 37.95595], [-121.81421, 37.95607], [-121.81425, 37.95621], [-121.8142, 37.95636], [-121.81407, 37.95647], [-121.81389, 37.95652], [-121.8133, 37.95657], [-121.81299, 37.95661], [-121.8122, 37.95683], [-121.81187, 37.95687], [-121.80984, 37.95699], [-121.80945, 37.95703], [-121.80906, 37.95711], [-121.80845, 37.95726], [-121.80819, 37.9573], [-121.80792, 37.9573], [-121.80728, 37.95726], [-121.80727, 37.95716], [-121.80723, 37.95706], [-121.8071, 37.95692], [-121.80694, 37.95685], [-121.80659, 37.95673], [-121.80635, 37.95663], [-121.80614, 37.95648], [-121.80597, 37.95629], [-121.80572, 37.95593], [-121.8056, 37.95579], [-121.80545, 37.95568], [-121.80545, 37.95396], [-121.82248, 37.95387], [-121.82405, 37.95459]]], [[[-121.85129, 37.96873], [-121.85128, 37.97597], [-121.84966, 37.97598], [-121.84884, 37.97657], [-121.84814, 37.97675], [-121.84752, 37.97679], [-121.84659, 37.97665], [-121.8464, 37.97646], [-121.84613, 37.97642], [-121.84597, 37.97658], [-121.84582, 37.97686], [-121.84579, 37.97704], [-121.84576, 37.97706], [-121.84566, 37.97702], [-121.84554, 37.97702], [-121.84557, 37.97699], [-121.8455, 37.97669], [-121.84568, 37.97649], [-121.84568, 37.97647], [-121.8447, 37.97647], [-121.84409, 37.97599], [-121.84221, 37.97599], [-121.83759, 37.97592], [-121.83762, 37.96865], [-121.84221, 37.96871], [-121.85129, 37.96873]], [[-121.84978, 37.97152], [-121.84975, 37.97161], [-121.84969, 37.97165], [-121.84971, 37.97168], [-121.84971, 37.97174], [-121.84975, 37.9718], [-121.84985, 37.97183], [-121.84991, 37.97181], [-121.84995, 37.97178], [-121.84997, 37.97172], [-121.84993, 37.9715], [-121.84989, 37.97145], [-121.84983, 37.97142], [-121.84975, 37.97142], [-121.84921, 37.97151], [-121.84902, 37.97151], [-121.84808, 37.97129], [-121.84794, 37.97132], [-121.8479, 37.97136], [-121.84786, 37.97143], [-121.84787, 37.97149], [-121.8479, 37.97156], [-121.84834, 37.97192], [-121.84841, 37.97201], [-121.84843, 37.97211], [-121.8484, 37.9726], [-121.84846, 37.97274], [-121.84854, 37.9727], [-121.8485, 37.9726], [-121.84853, 37.97211], [-121.84853, 37.97202], [-121.84845, 37.97189], [-121.84798, 37.9715], [-121.84796, 37.97143], [-121.84799, 37.97137], [-121.84805, 37.97135], [-121.84813, 37.97135], [-121.84888, 37.97155], [-121.84905, 37.97157], [-121.84919, 37.97157], [-121.84973, 37.97148], [-121.84977, 37.97149], [-121.84978, 37.97152]]], [[[-121.86969, 37.98272], [-121.86667, 37.98276], [-121.86658, 37.98116], [-121.8644, 37.98114], [-121.86435, 37.9828], [-121.86037, 37.98288], [-121.86035, 37.98316], [-121.85464, 37.9832], [-121.85505, 37.98175], [-121.8551, 37.98163], [-121.8552, 37.98148], [-121.85542, 37.9813], [-121.8556, 37.98121], [-121.85683, 37.98083], [-121.85704, 37.98074], [-121.85722, 37.98062], [-121.85737, 37.98047], [-121.85747, 37.9803], [-121.8576, 37.97985], [-121.8577, 37.97965], [-121.85777, 37.97955], [-121.86133, 37.97596], [-121.86959, 37.97617], [-121.86969, 37.98272]]], [[[-121.88773, 37.97662], [-121.87845, 37.97639], [-121.87827, 37.9691], [-121.88747, 37.96922], [-121.88773, 37.97662]]], [[[-121.91493, 37.9742], [-121.91407, 37.97445], [-121.91343, 37.97456], [-121.91278, 37.97454], [-121.91235, 37.97459], [-121.91201, 37.97458], [-121.91182, 37.97462], [-121.91092, 37.97463], [-121.91067, 37.97469], [-121.91028, 37.97466], [-121.90918, 37.97503], [-121.90905, 37.97514], [-121.90742, 37.97598], [-121.90716, 37.97616], [-121.90656, 37.97644], [-121.90617, 37.97669], [-121.9059, 37.97685], [-121.90529, 37.97702], [-121.90477, 37.97739], [-121.90409, 37.97754], [-121.9026, 37.97822], [-121.90207, 37.9784], [-121.90158, 37.9786], [-121.90112, 37.97884], [-121.9007, 37.97912], [-121.90031, 37.97943], [-121.89997, 37.97977], [-121.89967, 37.98013], [-121.89943, 37.98052], [-121.89923, 37.98093], [-121.8991, 37.98135], [-121.89881, 37.98238], [-121.89691, 37.97729], [-121.89689, 37.97665], [-121.90649, 37.97647], [-121.90608, 37.97065], [-121.90605, 37.96948], [-121.91489, 37.96938], [-121.91493, 37.9742]]], [[[-121.90608, 37.98366], [-121.90608, 37.98366], [-121.89893, 37.98367], [-121.89908, 37.98315], [-121.89936, 37.98185], [-121.89953, 37.98168], [-121.89957, 37.98155], [-121.89948, 37.98125], [-121.89963, 37.98087], [-121.89985, 37.98048], [-121.90012, 37.98011], [-121.90044, 37.97977], [-121.9008, 37.97945], [-121.9012, 37.97916], [-121.90164, 37.97891], [-121.9021, 37.9787], [-121.90529, 37.9776], [-121.90561, 37.97749], [-121.90608, 37.97728], [-121.90608, 37.98366]]]]} | No Public Access 3 | Black Diamond Mines Regional Preserve | http://www.ebparks.org/parks/black_diamond | 16133 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 1024.28 | Black Diamond Mines RPr | 1976 |
Advanced export
JSON shape: default, array, newline-delimited
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]);