superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AG_TYP = 5 and PARK_URL = "https://www.wildlife.ca.gov/Lands/Places-to-Visit/Spenceville-WA"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15376 | 15376 | 15375 | {"type": "MultiPolygon", "coordinates": [[[[-121.32213, 39.10132], [-121.32198, 39.11568], [-121.32192, 39.13023], [-121.32189, 39.14483], [-121.32156, 39.1521], [-121.32155, 39.15935], [-121.31624, 39.15927], [-121.3161, 39.15912], [-121.31575, 39.1588], [-121.31543, 39.15856], [-121.31493, 39.15828], [-121.3146, 39.15792], [-121.31408, 39.1573], [-121.31388, 39.15581], [-121.31379, 39.15532], [-121.31366, 39.15483], [-121.31348, 39.15445], [-121.31324, 39.15402], [-121.31311, 39.15343], [-121.31291, 39.15299], [-121.31258, 39.15251], [-121.31237, 39.15224], [-121.3123, 39.15203], [-121.31227, 39.15179], [-121.31226, 39.14633], [-121.31228, 39.14371], [-121.31239, 39.13739], [-121.31207, 39.1373], [-121.31017, 39.13477], [-121.31002, 39.13459], [-121.30963, 39.133], [-121.30928, 39.13164], [-121.30888, 39.13046], [-121.3087, 39.13009], [-121.30858, 39.12948], [-121.30855, 39.12903], [-121.30839, 39.12378], [-121.30789, 39.12192], [-121.30785, 39.12134], [-121.30761, 39.11879], [-121.30773, 39.11774], [-121.30785, 39.11692], [-121.30808, 39.11628], [-121.30835, 39.1153], [-121.30867, 39.11211], [-121.30815, 39.11118], [-121.30794, 39.11101], [-121.30773, 39.11103], [-121.30717, 39.111], [-121.30694, 39.11092], [-121.30632, 39.11047], [-121.30486, 39.10938], [-121.30431, 39.10886], [-121.30386, 39.10855], [-121.30331, 39.10832], [-121.30313, 39.10826], [-121.3007, 39.10817], [-121.2979, 39.10797], [-121.29732, 39.10784], [-121.29444, 39.10689], [-121.29392, 39.10679], [-121.29374, 39.10679], [-121.29242, 39.10691], [-121.29224, 39.10688], [-121.29135, 39.10663], [-121.28987, 39.107], [-121.2897, 39.107], [-121.28948, 39.10693], [-121.28927, 39.10676], [-121.28891, 39.1063], [-121.2887, 39.10618], [-121.28839, 39.10615], [-121.28658, 39.10617], [-121.28635, 39.10622], [-121.28589, 39.10643], [-121.28551, 39.10669], [-121.2839, 39.10854], [-121.2835, 39.10875], [-121.28329, 39.10893], [-121.28293, 39.10936], [-121.28274, 39.1094], [-121.28253, 39.10938], [-121.28216, 39.10924], [-121.28169, 39.10902], [-121.28114, 39.10889], [-121.28075, 39.10887], [-121.27975, 39.10889], [-121.27976, 39.10896], [-121.28101, 39.10903], [-121.28139, 39.10911], [-121.28171, 39.1092], [-121.28205, 39.10933], [-121.2824, 39.1095], [-121.28272, 39.10959], [-121.28293, 39.10954], [-121.28305, 39.10943], [-121.28357, 39.10886], [-121.28402, 39.10866], [-121.28423, 39.10844], [-121.28458, 39.108], [-121.28568, 39.10677], [-121.28606, 39.10653], [-121.28638, 39.10636], [-121.2867, 39.10628], [-121.28773, 39.10626], [-121.28821, 39.10627], [-121.28858, 39.1063], [-121.28879, 39.10641], [-121.28906, 39.10676], [-121.28931, 39.10699], [-121.28948, 39.10709], [-121.28969, 39.10714], [-121.28993, 39.10713], [-121.29136, 39.10676], [-121.29151, 39.10678], [-121.29233, 39.10703], [-121.29393, 39.1069], [-121.29405, 39.10692], [-121.29464, 39.10706], [-121.29568, 39.10738], [-121.29714, 39.1079], [-121.2976, 39.10803], [-121.2979, 39.10808], [-121.29858, 39.10813], [-121.30083, 39.10829], [-121.30243, 39.10834], [-121.30285, 39.10839], [-121.30331, 39.10849], [-121.30378, 39.10866], [-121.30421, 39.10904], [-121.30668, 39.11089], [-121.30697, 39.11108], [-121.30717, 39.11113], [-121.30784, 39.11119], [-121.30799, 39.11131], [-121.3085, 39.11213], [-121.30822, 39.11517], [-121.30812, 39.11556], [-121.30777, 39.11674], [-121.30768, 39.11693], [-121.30764, 39.11747], [-121.30751, 39.11816], [-121.30746, 39.11892], [-121.30763, 39.12048], [-121.30774, 39.12131], [-121.30774, 39.12195], [-121.30814, 39.12321], [-121.30824, 39.12368], [-121.30839, 39.12848], [-121.30846, 39.12964], [-121.30858, 39.13009], [-121.30905, 39.13147], [-121.30951, 39.13306], [-121.30986, 39.1346], [-121.30995, 39.13477], [-121.31205, 39.13755], [-121.31217, 39.1378], [-121.31221, 39.13923], [-121.31208, 39.1447], [-121.31208, 39.14768], [-121.31213, 39.15209], [-121.3122, 39.15233], [-121.31276, 39.15302], [-121.31296, 39.15346], [-121.3131, 39.15408], [-121.3133, 39.15445], [-121.3136, 39.15517], [-121.31381, 39.15653], [-121.31393, 39.15715], [-121.31393, 39.15741], [-121.31485, 39.15839], [-121.31538, 39.15874], [-121.31569, 39.15898], [-121.31599, 39.15927], [-121.31634, 39.15968], [-121.31666, 39.16026], [-121.31682, 39.16064], [-121.31689, 39.16157], [-121.31695, 39.16194], [-121.31732, 39.16354], [-121.3174, 39.16403], [-121.31747, 39.16651], [-121.31631, 39.16654], [-121.31613, 39.17368], [-121.31606, 39.17685], [-121.31594, 39.18099], [-121.31143, 39.181], [-121.31137, 39.18795], [-121.31134, 39.19361], [-121.30592, 39.19365], [-121.30584, 39.19673], [-121.30533, 39.19651], [-121.30482, 39.19643], [-121.30434, 39.1964], [-121.30403, 39.19633], [-121.30339, 39.19597], [-121.30308, 39.19579], [-121.30191, 39.19542], [-121.30169, 39.1954], [-121.30136, 39.19545], [-121.30111, 39.19554], [-121.30108, 39.19367], [-121.30127, 39.18884], [-121.30153, 39.18488], [-121.30174, 39.18065], [-121.30649, 39.18076], [-121.3066, 39.17846], [-121.30675, 39.17466], [-121.30682, 39.17348], [-121.31143, 39.17356], [-121.31161, 39.16702], [-121.31189, 39.15922], [-121.31188, 39.15921], [-121.30243, 39.15906], [-121.30309, 39.14458], [-121.28868, 39.14414], [-121.28389, 39.14403], [-121.28369, 39.14015], [-121.28397, 39.13678], [-121.27988, 39.13677], [-121.27973, 39.13674], [-121.27972, 39.13739], [-121.27934, 39.13733], [-121.27487, 39.13731], [-121.274, 39.13717], [-121.27196, 39.13714], [-121.26996, 39.13712], [-121.26709, 39.13715], [-121.26483, 39.13708], [-121.25613, 39.13708], [-121.25615, 39.13151], [-121.25626, 39.12958], [-121.25625, 39.12957], [-121.25169, 39.12961], [-121.25156, 39.13315], [-121.25145, 39.13688], [-121.2469, 39.13696], [-121.24677, 39.14076], [-121.24416, 39.14065], [-121.2442, 39.13695], [-121.23906, 39.13688], [-121.23911, 39.13315], [-121.24433, 39.13314], [-121.24439, 39.12961], [-121.24438, 39.1296], [-121.24077, 39.12958], [-121.24067, 39.12911], [-121.24047, 39.12844], [-121.24017, 39.12762], [-121.24036, 39.12224], [-121.2403, 39.11738], [-121.23976, 39.11725], [-121.23916, 39.11702], [-121.23865, 39.1167], [-121.23815, 39.11608], [-121.23797, 39.1157], [-121.23798, 39.11526], [-121.24027, 39.11524], [-121.2402, 39.10963], [-121.24028, 39.10813], [-121.24508, 39.10811], [-121.24754, 39.10812], [-121.25652, 39.10807], [-121.2565, 39.10646], [-121.2568, 39.1009], [-121.26596, 39.10086], [-121.26593, 39.09382], [-121.26595, 39.08669], [-121.26589, 39.08319], [-121.26595, 39.07985], [-121.26823, 39.07988], [-121.27452, 39.07988], [-121.27566, 39.07986], [-121.27981, 39.08348], [-121.27982, 39.08318], [-121.27918, 39.08269], [-121.27582, 39.07986], [-121.27982, 39.07987], [-121.27983, 39.07947], [-121.28434, 39.07959], [-121.28448, 39.07396], [-121.28627, 39.07357], [-121.28858, 39.07771], [-121.28974, 39.07786], [-121.29071, 39.07538], [-121.29008, 39.07248], [-121.29372, 39.07259], [-121.29361, 39.08], [-121.30305, 39.08026], [-121.30312, 39.08733], [-121.30352, 39.10062], [-121.32213, 39.10132]]], [[[-121.31973, 39.20816], [-121.31504, 39.2083], [-121.31498, 39.20463], [-121.31968, 39.20454], [-121.31973, 39.20816]]], [[[-121.3522, 39.19327], [-121.35214, 39.2079], [-121.33151, 39.20817], [-121.32908, 39.20806], [-121.32904, 39.20635], [-121.32904, 39.20089], [-121.33266, 39.20085], [-121.33362, 39.20078], [-121.33823, 39.20071], [-121.34211, 39.1976], [-121.34309, 39.19699], [-121.34301, 39.19341], [-121.34036, 39.19343], [-121.34041, 39.17718], [-121.3357, 39.17724], [-121.33569, 39.17358], [-121.34042, 39.17351], [-121.34506, 39.17367], [-121.34502, 39.17734], [-121.34974, 39.17745], [-121.34965, 39.18033], [-121.34929, 39.18639], [-121.34935, 39.19329], [-121.3522, 39.19327]]]]} | Open Access 1 | Spenceville Wildlife Area | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Spenceville-WA | 30508 | 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 | 11634.265 | Spenceville Wildlife Area | 1968 |
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]);