superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where LABEL_NAME = "North Grasslands Wildlife Area" and MNG_AG_TYP = 5
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11960 | 11960 | 11959 | {"type": "MultiPolygon", "coordinates": [[[[-120.81111, 37.04593], [-120.80899, 37.04898], [-120.80225, 37.04895], [-120.80204, 37.05572], [-120.8001, 37.05564], [-120.79614, 37.05556], [-120.79098, 37.05552], [-120.7879, 37.05546], [-120.78782, 37.05522], [-120.78734, 37.05476], [-120.78682, 37.05443], [-120.78616, 37.05414], [-120.78593, 37.05395], [-120.78323, 37.05113], [-120.78289, 37.05074], [-120.7824, 37.04991], [-120.78007, 37.04745], [-120.77531, 37.04257], [-120.77114, 37.0384], [-120.77087, 37.03826], [-120.7701, 37.03772], [-120.7677, 37.03532], [-120.76104, 37.02846], [-120.75901, 37.0264], [-120.76331, 37.02641], [-120.77211, 37.02655], [-120.80654, 37.04358], [-120.81111, 37.04593]]], [[[-120.78061, 37.04911], [-120.78059, 37.04952], [-120.7805, 37.0495], [-120.77915, 37.04948], [-120.77913, 37.04931], [-120.76946, 37.04928], [-120.76964, 37.04115], [-120.77138, 37.04119], [-120.77288, 37.0412], [-120.77466, 37.04298], [-120.77941, 37.04785], [-120.78061, 37.04911]]], [[[-120.78295, 37.05129], [-120.77958, 37.04774], [-120.77315, 37.04121], [-120.76985, 37.03791], [-120.77068, 37.03848], [-120.7709, 37.03861], [-120.77504, 37.04274], [-120.77978, 37.04761], [-120.78211, 37.05006], [-120.78259, 37.05087], [-120.78295, 37.05129]]], [[[-120.85184, 37.21652], [-120.8493, 37.21645], [-120.83085, 37.21631], [-120.83084, 37.21633], [-120.83054, 37.21596], [-120.83049, 37.21563], [-120.83052, 37.21522], [-120.83078, 37.21477], [-120.83096, 37.21464], [-120.83126, 37.21458], [-120.83135, 37.21457], [-120.83168, 37.2146], [-120.83228, 37.21479], [-120.83362, 37.21572], [-120.83454, 37.21577], [-120.83496, 37.21504], [-120.83466, 37.21443], [-120.83447, 37.21351], [-120.83452, 37.213], [-120.83479, 37.21241], [-120.83601, 37.21159], [-120.83637, 37.21103], [-120.83647, 37.21012], [-120.83632, 37.20895], [-120.83558, 37.20851], [-120.83469, 37.20898], [-120.83419, 37.2098], [-120.83366, 37.21047], [-120.83297, 37.21089], [-120.83255, 37.21095], [-120.83185, 37.21078], [-120.83109, 37.21035], [-120.83103, 37.21026], [-120.83108, 37.21005], [-120.83199, 37.20861], [-120.83241, 37.20776], [-120.83257, 37.20709], [-120.83264, 37.20645], [-120.8326, 37.20571], [-120.83234, 37.20517], [-120.8315, 37.20469], [-120.83101, 37.2043], [-120.83022, 37.20247], [-120.8289, 37.20108], [-120.82788, 37.2008], [-120.82656, 37.20015], [-120.82628, 37.19968], [-120.82588, 37.19783], [-120.82571, 37.19682], [-120.8257, 37.19617], [-120.82628, 37.19424], [-120.82609, 37.19353], [-120.8258, 37.19324], [-120.82563, 37.19289], [-120.8251, 37.19234], [-120.82479, 37.19213], [-120.82472, 37.192], [-120.8249, 37.19171], [-120.82558, 37.19106], [-120.82603, 37.19034], [-120.82619, 37.18987], [-120.82625, 37.18922], [-120.82617, 37.18871], [-120.82604, 37.18812], [-120.8262, 37.18782], [-120.82697, 37.18704], [-120.82674, 37.18703], [-120.82601, 37.18776], [-120.82674, 37.18702], [-120.82714, 37.18703], [-120.82715, 37.18701], [-120.82577, 37.18504], [-120.82538, 37.18462], [-120.82472, 37.1843], [-120.8242, 37.18423], [-120.8231, 37.18389], [-120.82222, 37.18311], [-120.82187, 37.18272], [-120.82121, 37.18236], [-120.82013, 37.1812], [-120.81963, 37.18037], [-120.81974, 37.17993], [-120.81938, 37.17924], [-120.81843, 37.17848], [-120.81789, 37.1783], [-120.81713, 37.17827], [-120.81641, 37.17833], [-120.81572, 37.17856], [-120.81493, 37.17924], [-120.81447, 37.17969], [-120.81388, 37.17986], [-120.81337, 37.17968], [-120.81298, 37.17924], [-120.81279, 37.17881], [-120.81278, 37.17828], [-120.81337, 37.17682], [-120.81327, 37.1764], [-120.81377, 37.17489], [-120.8138, 37.17423], [-120.81365, 37.17377], [-120.81368, 37.17347], [-120.81385, 37.17257], [-120.81407, 37.17237], [-120.81419, 37.17236], [-120.8143, 37.17192], [-120.81453, 37.1717], [-120.81729, 37.17087], [-120.81819, 37.17084], [-120.81952, 37.17014], [-120.81948, 37.16983], [-120.81963, 37.16936], [-120.81857, 37.16843], [-120.81802, 37.16698], [-120.81746, 37.16643], [-120.81633, 37.16591], [-120.81588, 37.166], [-120.81537, 37.16584], [-120.81467, 37.16558], [-120.81448, 37.16492], [-120.81467, 37.16434], [-120.81475, 37.1639], [-120.8147, 37.16299], [-120.81458, 37.16283], [-120.81457, 37.16314], [-120.81443, 37.16293], [-120.81423, 37.16269], [-120.81391, 37.1624], [-120.81318, 37.16185], [-120.81295, 37.16138], [-120.8126, 37.1602], [-120.81253, 37.15975], [-120.81184, 37.15977], [-120.81201, 37.15958], [-120.81216, 37.15928], [-120.81373, 37.15938], [-120.81404, 37.15832], [-120.81434, 37.1581], [-120.81469, 37.15708], [-120.81489, 37.15646], [-120.815, 37.15623], [-120.81544, 37.1557], [-120.81771, 37.1535], [-120.82055, 37.1508], [-120.82114, 37.15023], [-120.82293, 37.14818], [-120.82419, 37.14868], [-120.8242, 37.14875], [-120.82434, 37.14925], [-120.82451, 37.14975], [-120.82498, 37.15069], [-120.82573, 37.1518], [-120.82625, 37.15264], [-120.82655, 37.1532], [-120.82685, 37.15397], [-120.8271, 37.15474], [-120.82729, 37.15541], [-120.82855, 37.1601], [-120.8326, 37.17551], [-120.83393, 37.18051], [-120.83417, 37.18116], [-120.83514, 37.18347], [-120.83607, 37.18561], [-120.83673, 37.18718], [-120.83774, 37.18947], [-120.84035, 37.19558], [-120.84181, 37.19898], [-120.84485, 37.20615], [-120.84513, 37.20664], [-120.84548, 37.20713], [-120.8458, 37.20764], [-120.84929, 37.21298], [-120.85028, 37.21455], [-120.85106, 37.21496], [-120.85122, 37.2152], [-120.85157, 37.21581], [-120.85184, 37.21652]]], [[[-120.82484, 37.14594], [-120.82477, 37.1461], [-120.8246, 37.1467], [-120.82452, 37.14722], [-120.82453, 37.14754], [-120.82453, 37.14817], [-120.82458, 37.14852], [-120.82312, 37.14795], [-120.82484, 37.14594]]], [[[-120.99121, 37.31009], [-120.98562, 37.31823], [-120.98537, 37.3185], [-120.9842, 37.31905], [-120.98336, 37.3197], [-120.98247, 37.32015], [-120.97991, 37.3221], [-120.97165, 37.33765], [-120.97165, 37.33766], [-120.97323, 37.33818], [-120.97632, 37.33238], [-120.97665, 37.33174], [-120.97976, 37.33347], [-120.97946, 37.3337], [-120.97946, 37.33372], [-120.98484, 37.33624], [-120.98615, 37.33757], [-120.98331, 37.3402], [-120.98007, 37.33795], [-120.97985, 37.33808], [-120.97922, 37.33829], [-120.97886, 37.33864], [-120.9787, 37.33868], [-120.97846, 37.33862], [-120.97829, 37.33845], [-120.97835, 37.33802], [-120.9782, 37.33758], [-120.97827, 37.33732], [-120.97864, 37.33699], [-120.9787, 37.33671], [-120.97849, 37.33651], [-120.97757, 37.33614], [-120.97721, 37.33617], [-120.97644, 37.33656], [-120.97703, 37.33682], [-120.97706, 37.33694], [-120.97694, 37.33726], [-120.9765, 37.3376], [-120.97605, 37.33773], [-120.97615, 37.33803], [-120.97617, 37.3384], [-120.97616, 37.33881], [-120.97622, 37.33908], [-120.97606, 37.33931], [-120.97641, 37.33963], [-120.97653, 37.33999], [-120.9768, 37.34041], [-120.97736, 37.34051], [-120.97778, 37.34046], [-120.97722, 37.34065], [-120.97696, 37.34083], [-120.97683, 37.34099], [-120.97666, 37.34109], [-120.9765, 37.34136], [-120.97641, 37.3414], [-120.9763, 37.34142], [-120.97607, 37.34137], [-120.97598, 37.34132], [-120.97594, 37.34122], [-120.97599, 37.34099], [-120.97599, 37.34083], [-120.9759, 37.34057], [-120.97565, 37.34034], [-120.97522, 37.34011], [-120.97487, 37.34], [-120.97475, 37.33999], [-120.97453, 37.34002], [-120.97436, 37.34007], [-120.9743, 37.34013], [-120.97421, 37.34031], [-120.97413, 37.3404], [-120.97404, 37.34044], [-120.97388, 37.34049], [-120.97357, 37.3405], [-120.97322, 37.34047], [-120.97311, 37.34045], [-120.97279, 37.34026], [-120.97265, 37.34015], [-120.97252, 37.33993], [-120.97212, 37.33943], [-120.97187, 37.33961], [-120.9724, 37.34033], [-120.97254, 37.34045], [-120.9729, 37.34067], [-120.97314, 37.34073], [-120.97354, 37.34078], [-120.97394, 37.34076], [-120.97433, 37.34066], [-120.97448, 37.34049], [-120.9746, 37.34029], [-120.97481, 37.34028], [-120.97511, 37.34037], [-120.97545, 37.34056], [-120.97565, 37.34081], [-120.97561, 37.34127], [-120.97572, 37.34147], [-120.97589, 37.34162], [-120.97629, 37.34168], [-120.97656, 37.34166], [-120.97675, 37.34156], [-120.97696, 37.34125], [-120.97724, 37.34099], [-120.97745, 37.34086], [-120.97767, 37.3408], [-120.97841, 37.3416], [-120.97836, 37.34177], [-120.97784, 37.34216], [-120.97724, 37.34226], [-120.97631, 37.34346], [-120.97602, 37.3442], [-120.97597, 37.34438], [-120.97593, 37.34444], [-120.97592, 37.34454], [-120.97571, 37.34488], [-120.97566, 37.34507], [-120.97566, 37.34529], [-120.97585, 37.34562], [-120.97595, 37.3457], [-120.9761, 37.34578], [-120.97616, 37.34583], [-120.97623, 37.34593], [-120.97631, 37.34599], [-120.97645, 37.34618], [-120.9765, 37.34622], [-120.97653, 37.3465], [-120.97648, 37.34664], [-120.97638, 37.34675], [-120.97592, 37.34681], [-120.97521, 37.34713], [-120.97439, 37.34803], [-120.97413, 37.34834], [-120.97409, 37.349], [-120.97401, 37.34925], [-120.97384, 37.34926], [-120.9733, 37.34921], [-120.97302, 37.34913], [-120.97249, 37.34892], [-120.97213, 37.34876], [-120.97184, 37.3486], [-120.97152, 37.34829], [-120.97138, 37.34808], [-120.97134, 37.34775], [-120.97134, 37.34749], [-120.97126, 37.34733], [-120.97109, 37.34711], [-120.96997, 37.34605], [-120.96958, 37.34575], [-120.96932, 37.34557], [-120.96885, 37.34538], [-120.9684, 37.34534], [-120.96801, 37.34533], [-120.96768, 37.34541], [-120.96728, 37.34554], [-120.96644, 37.34592], [-120.966, 37.34606], [-120.9657, 37.34614], [-120.96509, 37.34611], [-120.96489, 37.34605], [-120.96472, 37.34591], [-120.96458, 37.34575], [-120.96456, 37.3457], [-120.96413, 37.34562], [-120.96368, 37.34567], [-120.96482, 37.34479], [-120.96425, 37.34459], [-120.96435, 37.34387], [-120.9648, 37.34363], [-120.96627, 37.34345], [-120.96684, 37.34295], [-120.96702, 37.34255], [-120.96751, 37.34226], [-120.96771, 37.34146], [-120.96689, 37.34118], [-120.96559, 37.34157], [-120.96431, 37.34118], [-120.96376, 37.34051], [-120.9637, 37.33988], [-120.96319, 37.33906], [-120.96225, 37.33736], [-120.96339, 37.33594], [-120.96399, 37.33478], [-120.96404, 37.33396], [-120.96114, 37.33374], [-120.96056, 37.33409], [-120.95928, 37.3356], [-120.95804, 37.33645], [-120.95692, 37.33506], [-120.95303, 37.33328], [-120.9529, 37.33124], [-120.95165, 37.33013], [-120.95042, 37.3303], [-120.94916, 37.33127], [-120.94729, 37.33135], [-120.94577, 37.33125], [-120.94451, 37.33187], [-120.94438, 37.33187], [-120.94354, 37.33181], [-120.94404, 37.33073], [-120.94489, 37.33084], [-120.94588, 37.33065], [-120.94659, 37.33], [-120.9467, 37.32885], [-120.94626, 37.32801], [-120.94546, 37.32755], [-120.9438, 37.32695], [-120.94348, 37.32611], [-120.944, 37.32466], [-120.94579, 37.32261], [-120.94578, 37.32198], [-120.94477, 37.32154], [-120.94363, 37.32173], [-120.94055, 37.32323], [-120.93838, 37.32359], [-120.93704, 37.32291], [-120.93592, 37.32131], [-120.93506, 37.31835], [-120.93549, 37.31787], [-120.9373, 37.31828], [-120.93852, 37.31794], [-120.93913, 37.31728], [-120.93942, 37.3164], [-120.93866, 37.31408], [-120.94019, 37.31226], [-120.93938, 37.31056], [-120.93844, 37.31032], [-120.93458, 37.31153], [-120.93196, 37.31134], [-120.93109, 37.31006], [-120.9317, 37.30967], [-120.93193, 37.30951], [-120.93237, 37.30917], [-120.93278, 37.30882], [-120.93324, 37.30833], [-120.93341, 37.30812], [-120.93378, 37.30761], [-120.93406, 37.30715], [-120.93541, 37.3044], [-120.93536, 37.30432], [-120.93578, 37.30351], [-120.93617, 37.30281], [-120.93644, 37.30268], [-120.94395, 37.29248], [-120.94389, 37.29211], [-120.94601, 37.28925], [-120.95005, 37.28923], [-120.95374, 37.29979], [-120.95057, 37.30052], [-120.95323, 37.30809], [-120.95641, 37.30744], [-120.9627, 37.31761], [-120.98068, 37.312], [-120.97656, 37.30369], [-120.97983, 37.30369], [-120.98372, 37.30371], [-120.98397, 37.30446], [-120.98432, 37.30491], [-120.98444, 37.30515], [-120.98459, 37.30572], [-120.98451, 37.30634], [-120.9847, 37.30741], [-120.98479, 37.3075], [-120.98513, 37.30772], [-120.98601, 37.30813], [-120.98847, 37.30725], [-120.99121, 37.31009]]]]} | Open Access 1 | North Grasslands Wildlife Area | https://www.wildlife.ca.gov/Lands/Places-to-Visit/North-Grasslands-WA | 30482 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 7334.636 | North Grasslands Wildlife Area | 1992 |
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]);