units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where DES_TP = 8, MNG_AGENCY = 25 and SUID_NMA = 30414
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
- California Department of Fish and Wildlife · 2 ✖
DES_TP 1
- State Conservation Area · 2 ✖
ACCESS_TYP 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2918 | 2918 | 2917 | {"type": "Polygon", "coordinates": [[[-122.18861, 40.38726], [-122.18838, 40.38756], [-122.18755, 40.38806], [-122.18736, 40.38813], [-122.18717, 40.38823], [-122.18686, 40.38822], [-122.18606, 40.38824], [-122.18594, 40.38825], [-122.18586, 40.38824], [-122.1857, 40.38836], [-122.18559, 40.38839], [-122.18552, 40.3885], [-122.1854, 40.38857], [-122.18528, 40.3887], [-122.18512, 40.38876], [-122.18477, 40.38904], [-122.18465, 40.38917], [-122.18439, 40.38955], [-122.18427, 40.38968], [-122.18397, 40.39016], [-122.18389, 40.39043], [-122.1839, 40.39062], [-122.18399, 40.39092], [-122.18409, 40.3912], [-122.1842, 40.39137], [-122.18422, 40.39187], [-122.18349, 40.39238], [-122.18314, 40.39244], [-122.18229, 40.39242], [-122.18127, 40.39229], [-122.18104, 40.39222], [-122.18048, 40.39218], [-122.1799, 40.3921], [-122.17937, 40.39208], [-122.17916, 40.39205], [-122.17894, 40.39198], [-122.17849, 40.39193], [-122.17858, 40.39188], [-122.17857, 40.39186], [-122.17829, 40.39189], [-122.17788, 40.39185], [-122.17764, 40.39197], [-122.17754, 40.39195], [-122.1775, 40.39204], [-122.17693, 40.39232], [-122.1764, 40.39244], [-122.17613, 40.39252], [-122.17565, 40.39257], [-122.17489, 40.3925], [-122.1747, 40.39246], [-122.1743, 40.39241], [-122.17408, 40.3924], [-122.17363, 40.39249], [-122.17345, 40.39264], [-122.17337, 40.39281], [-122.17321, 40.39324], [-122.17311, 40.39334], [-122.17298, 40.3935], [-122.17227, 40.39369], [-122.17151, 40.39369], [-122.17108, 40.39356], [-122.17059, 40.39321], [-122.17047, 40.39316], [-122.16992, 40.39307], [-122.16977, 40.39309], [-122.16948, 40.39305], [-122.16923, 40.39311], [-122.16902, 40.39312], [-122.1688, 40.39317], [-122.16818, 40.39326], [-122.16792, 40.39334], [-122.16739, 40.39364], [-122.16691, 40.39377], [-122.1666, 40.39375], [-122.1663, 40.39364], [-122.16604, 40.39357], [-122.16587, 40.39349], [-122.16566, 40.39349], [-122.16549, 40.39339], [-122.16531, 40.39335], [-122.16516, 40.39327], [-122.165, 40.39329], [-122.16479, 40.39324], [-122.16453, 40.39326], [-122.16437, 40.39324], [-122.16415, 40.39325], [-122.1634, 40.39315], [-122.16323, 40.39316], [-122.16305, 40.39326], [-122.16298, 40.39336], [-122.16284, 40.3939], [-122.16267, 40.39411], [-122.16227, 40.39443], [-122.16204, 40.39448], [-122.16182, 40.39449], [-122.16137, 40.39456], [-122.16114, 40.39462], [-122.16104, 40.39461], [-122.16075, 40.39473], [-122.16065, 40.39481], [-122.16028, 40.39451], [-122.16036, 40.39013], [-122.17014, 40.38987], [-122.17017, 40.37655], [-122.17064, 40.377], [-122.17112, 40.37756], [-122.17306, 40.37911], [-122.173, 40.37914], [-122.17307, 40.37927], [-122.17333, 40.37955], [-122.17343, 40.37961], [-122.17354, 40.37975], [-122.17369, 40.37989], [-122.17391, 40.38017], [-122.17403, 40.38026], [-122.17414, 40.38037], [-122.17434, 40.38043], [-122.17468, 40.38065], [-122.1747, 40.38076], [-122.17485, 40.38087], [-122.17498, 40.38101], [-122.17515, 40.38111], [-122.1753, 40.38123], [-122.17575, 40.3815], [-122.17588, 40.38151], [-122.1764, 40.38165], [-122.17648, 40.3817], [-122.17666, 40.38175], [-122.17674, 40.3818], [-122.17694, 40.38194], [-122.17714, 40.38216], [-122.17736, 40.38245], [-122.17743, 40.38251], [-122.17752, 40.38267], [-122.17759, 40.38291], [-122.17778, 40.38334], [-122.1779, 40.38356], [-122.17801, 40.38371], [-122.17806, 40.38374], [-122.17791, 40.38388], [-122.17757, 40.38454], [-122.1776, 40.38552], [-122.17878, 40.38554], [-122.17885, 40.38421], [-122.17873, 40.38402], [-122.17884, 40.38402], [-122.17946, 40.38417], [-122.17984, 40.38452], [-122.18031, 40.38477], [-122.18042, 40.38479], [-122.18083, 40.38479], [-122.18104, 40.38474], [-122.18125, 40.38473], [-122.18138, 40.38467], [-122.18153, 40.3845], [-122.18158, 40.38447], [-122.18163, 40.38437], [-122.18222, 40.38402], [-122.18306, 40.38404], [-122.18308, 40.3843], [-122.18368, 40.38438], [-122.18413, 40.3845], [-122.18425, 40.38449], [-122.18462, 40.38449], [-122.18595, 40.3846], [-122.18604, 40.38462], [-122.18634, 40.38463], [-122.18702, 40.38487], [-122.18771, 40.38537], [-122.18807, 40.38598], [-122.18856, 40.38669], [-122.18861, 40.38726]]]} | Open Access 1 | 23071 | Battle Creek Wildlife Area | 30414 | 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 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Battle-Creek-WA | Tehama 18 | 461.11 | Battle Creek Wildlife Area | 1983 | State Conservation Area 8 | 2 |
16731 | 16731 | 16730 | {"type": "Polygon", "coordinates": [[[-122.17023, 40.39416], [-122.17013, 40.3972], [-122.17013, 40.39788], [-122.16965, 40.3975], [-122.16777, 40.39723], [-122.16775, 40.39816], [-122.16725, 40.39809], [-122.16687, 40.3981], [-122.16319, 40.39866], [-122.16269, 40.39877], [-122.16262, 40.39774], [-122.16184, 40.39791], [-122.16105, 40.3979], [-122.16029, 40.39796], [-122.16009, 40.39808], [-122.1601, 40.39896], [-122.15925, 40.39883], [-122.15901, 40.39881], [-122.15707, 40.3989], [-122.15611, 40.39892], [-122.15468, 40.39906], [-122.1544, 40.39916], [-122.15428, 40.39923], [-122.15378, 40.39962], [-122.15356, 40.39977], [-122.15338, 40.39986], [-122.15195, 40.40048], [-122.15116, 40.40076], [-122.15094, 40.40087], [-122.15054, 40.40114], [-122.15035, 40.40134], [-122.15023, 40.40152], [-122.14876, 40.40165], [-122.14857, 40.39876], [-122.14851, 40.39812], [-122.14881, 40.39815], [-122.14903, 40.39819], [-122.1493, 40.39818], [-122.14948, 40.39821], [-122.15102, 40.39777], [-122.1512, 40.39769], [-122.15156, 40.39755], [-122.15168, 40.39753], [-122.15201, 40.39743], [-122.15227, 40.39741], [-122.1529, 40.39732], [-122.15319, 40.39734], [-122.15337, 40.39734], [-122.15358, 40.3973], [-122.15396, 40.39728], [-122.15421, 40.3973], [-122.1545, 40.39723], [-122.1547, 40.39724], [-122.1549, 40.39717], [-122.15514, 40.39712], [-122.15554, 40.39691], [-122.15564, 40.39691], [-122.15589, 40.39685], [-122.15641, 40.39685], [-122.15665, 40.39689], [-122.15686, 40.39688], [-122.15705, 40.39694], [-122.15729, 40.39694], [-122.15763, 40.39698], [-122.15785, 40.39699], [-122.15816, 40.39704], [-122.15842, 40.397], [-122.15882, 40.39704], [-122.15899, 40.397], [-122.15915, 40.39701], [-122.15958, 40.39697], [-122.15986, 40.39691], [-122.16011, 40.39674], [-122.16019, 40.39659], [-122.16031, 40.39648], [-122.16045, 40.39622], [-122.16049, 40.39611], [-122.1605, 40.39595], [-122.16045, 40.39581], [-122.16033, 40.39565], [-122.16027, 40.39548], [-122.1603, 40.39523], [-122.16034, 40.39511], [-122.16043, 40.395], [-122.16075, 40.39473], [-122.16104, 40.39461], [-122.16114, 40.39462], [-122.16137, 40.39456], [-122.16182, 40.39449], [-122.16204, 40.39448], [-122.16227, 40.39443], [-122.16267, 40.39411], [-122.16284, 40.39391], [-122.16298, 40.39336], [-122.16305, 40.39326], [-122.16323, 40.39316], [-122.1634, 40.39315], [-122.16415, 40.39325], [-122.16437, 40.39324], [-122.16453, 40.39326], [-122.16479, 40.39324], [-122.165, 40.39329], [-122.16516, 40.39327], [-122.16531, 40.39335], [-122.16549, 40.39339], [-122.16566, 40.39349], [-122.16587, 40.39349], [-122.16604, 40.39357], [-122.1663, 40.39364], [-122.1666, 40.39375], [-122.16691, 40.39377], [-122.16739, 40.39364], [-122.16792, 40.39334], [-122.16818, 40.39326], [-122.1688, 40.39317], [-122.16902, 40.39312], [-122.16923, 40.39311], [-122.16948, 40.39305], [-122.16979, 40.39309], [-122.16978, 40.39322], [-122.16984, 40.39422], [-122.17009, 40.39416], [-122.17023, 40.39416]]]} | Open Access 1 | 17803 | Battle Creek Wildlife Area | 30414 | 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 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Battle-Creek-WA | Shasta 27 | 165.789 | Battle Creek Wildlife Area | 1983 | State Conservation Area 8 | 2 |
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]);