units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where LAYER = 1 and MNG_AG_LEV = 4
This data as json, copyable, CSV (advanced)
Suggested facets: MNG_AG_ID, PARK_URL, COUNTY
MNG_AG_TYP 2
MNG_AGENCY 2
DES_TP 2
ACCESS_TYP 2
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5520 | 5520 | 5519 | {"type": "MultiPolygon", "coordinates": [[[[-117.38996, 33.75652], [-117.3814, 33.75644], [-117.38124, 33.74221], [-117.38968, 33.74215], [-117.38996, 33.75652]]], [[[-117.41067, 33.77234], [-117.40929, 33.77406], [-117.40485, 33.77272], [-117.40497, 33.77239], [-117.40512, 33.77222], [-117.40525, 33.77213], [-117.40539, 33.77206], [-117.40555, 33.77201], [-117.40572, 33.77199], [-117.40824, 33.77215], [-117.40855, 33.77215], [-117.40949, 33.77208], [-117.40974, 33.77208], [-117.40998, 33.77211], [-117.41022, 33.77216], [-117.41045, 33.77224], [-117.41067, 33.77234]]], [[[-117.42003, 33.77136], [-117.42002, 33.77367], [-117.41915, 33.77281], [-117.41892, 33.77265], [-117.41866, 33.77255], [-117.41837, 33.77252], [-117.41818, 33.77254], [-117.41776, 33.77261], [-117.41776, 33.77541], [-117.41461, 33.77542], [-117.4146, 33.77304], [-117.41326, 33.77308], [-117.41297, 33.77306], [-117.4127, 33.77302], [-117.41243, 33.77295], [-117.41217, 33.77285], [-117.41079, 33.77212], [-117.41057, 33.77202], [-117.41034, 33.77194], [-117.40997, 33.77186], [-117.40972, 33.77184], [-117.40947, 33.77184], [-117.40839, 33.77191], [-117.4076, 33.77187], [-117.40759, 33.77145], [-117.40684, 33.77146], [-117.40688, 33.76765], [-117.41585, 33.76758], [-117.41586, 33.77137], [-117.42003, 33.77136]]], [[[-117.4145, 33.7762], [-117.41141, 33.77613], [-117.41246, 33.77321], [-117.41286, 33.77329], [-117.41313, 33.77332], [-117.4134, 33.77332], [-117.41441, 33.77329], [-117.41449, 33.77336], [-117.4145, 33.7762]]], [[[-117.45067, 33.76034], [-117.45064, 33.76721], [-117.45014, 33.76688], [-117.44995, 33.76679], [-117.44948, 33.76672], [-117.44895, 33.76678], [-117.44834, 33.76673], [-117.44774, 33.76684], [-117.44636, 33.76723], [-117.44637, 33.7676], [-117.45064, 33.76759], [-117.45063, 33.77121], [-117.43306, 33.77133], [-117.43311, 33.76868], [-117.42869, 33.7695], [-117.42861, 33.76936], [-117.42847, 33.76926], [-117.42753, 33.76891], [-117.42733, 33.7688], [-117.42722, 33.7687], [-117.42713, 33.76857], [-117.42708, 33.76845], [-117.42705, 33.76828], [-117.43315, 33.76724], [-117.43337, 33.75672], [-117.41584, 33.75669], [-117.41583, 33.74938], [-117.43335, 33.74938], [-117.43337, 33.75308], [-117.4421, 33.75312], [-117.44209, 33.75672], [-117.44203, 33.75673], [-117.44199, 33.7603], [-117.45067, 33.76034]]], [[[-117.42273, 33.78061], [-117.41945, 33.78181], [-117.41826, 33.77997], [-117.41815, 33.77983], [-117.42019, 33.77844], [-117.42273, 33.78061]]], [[[-117.43234, 33.80008], [-117.43231, 33.8073], [-117.42422, 33.80731], [-117.42414, 33.80008], [-117.42363, 33.80007], [-117.42357, 33.79286], [-117.43228, 33.79286], [-117.43234, 33.80008]]], [[[-117.43184, 33.78482], [-117.43184, 33.78482], [-117.42754, 33.78494], [-117.42876, 33.78264], [-117.43183, 33.78291], [-117.43184, 33.78482]]], [[[-117.45462, 33.80737], [-117.4546, 33.81097], [-117.45027, 33.81096], [-117.45027, 33.8146], [-117.4405, 33.81459], [-117.44052, 33.80733], [-117.45243, 33.80736], [-117.45245, 33.80557], [-117.45354, 33.80558], [-117.45353, 33.80736], [-117.45462, 33.80737]]]]} | No Public Access 3 | 48551 | Lake Mathews - Estelle Mountain Reserve | 33268 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 2122 | Riverside County Habitat Conservation Agency 562 | Special District 4 | Open Space District 6 | http://rchca.us/159/Reserves | Riverside 10 | 2048.377 | Lake Mathews - Estelle Mtn. Reserve | 1982 | Local Conservation Area 4 | 2 |
14420 | 14420 | 14419 | {"type": "MultiPolygon", "coordinates": [[[[-117.04031, 33.63474], [-117.03595, 33.63466], [-117.03586, 33.63098], [-117.04021, 33.63109], [-117.04031, 33.63474]]], [[[-117.04876, 33.62767], [-117.04876, 33.63129], [-117.04448, 33.63119], [-117.04443, 33.62742], [-117.04876, 33.62767]]]]} | Open Access 1 | 48557 | Southwestern Riverside County Multi-Species Reserve | 33272 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 2122 | Riverside County Habitat Conservation Agency 562 | Special District 4 | Open Space District 6 | http://rchca.us/159/Reserves | Riverside 10 | 81.034 | Southwestern Riverside County Multi-Species Reserve | 1992 | Local Conservation Area 4 | 2 |
15542 | 15542 | 15541 | {"type": "MultiPolygon", "coordinates": [[[[-120.22503, 37.57551], [-120.22499, 37.57901], [-120.22021, 37.57897], [-120.22011, 37.57541], [-120.22503, 37.57551]]], [[[-120.2707, 37.58198], [-120.27045, 37.58865], [-120.27047, 37.59077], [-120.2684, 37.58746], [-120.26758, 37.58728], [-120.26856, 37.58369], [-120.26686, 37.58326], [-120.26589, 37.58691], [-120.26573, 37.58693], [-120.26833, 37.59129], [-120.27042, 37.59216], [-120.27039, 37.59315], [-120.26292, 37.59371], [-120.26335, 37.58292], [-120.26334, 37.58243], [-120.2707, 37.58198]]], [[[-120.27059, 37.60756], [-120.27047, 37.61134], [-120.26169, 37.61141], [-120.26167, 37.61157], [-120.25669, 37.61142], [-120.25693, 37.60439], [-120.26218, 37.60437], [-120.26222, 37.60397], [-120.26637, 37.60387], [-120.26629, 37.60763], [-120.27059, 37.60756]]], [[[-120.26141, 37.61509], [-120.2612, 37.61794], [-120.26119, 37.61878], [-120.25643, 37.61877], [-120.25656, 37.61554], [-120.25645, 37.61508], [-120.26141, 37.61509]]], [[[-120.27469, 37.61905], [-120.27469, 37.62289], [-120.27008, 37.62283], [-120.27016, 37.619], [-120.26565, 37.61894], [-120.26576, 37.61514], [-120.27026, 37.61519], [-120.27017, 37.619], [-120.27469, 37.61905]]], [[[-120.15147, 37.62161], [-120.15144, 37.62212], [-120.15132, 37.62212], [-120.14929, 37.62046], [-120.14621, 37.6205], [-120.14753, 37.62193], [-120.1503, 37.62429], [-120.15047, 37.62425], [-120.15126, 37.62425], [-120.15145, 37.62423], [-120.151, 37.62466], [-120.15031, 37.62429], [-120.14971, 37.62442], [-120.14602, 37.62187], [-120.14282, 37.61934], [-120.14288, 37.61761], [-120.14137, 37.61643], [-120.14006, 37.61676], [-120.13921, 37.6149], [-120.13847, 37.61432], [-120.13846, 37.61434], [-120.13864, 37.61585], [-120.13812, 37.61617], [-120.13572, 37.61394], [-120.13721, 37.61397], [-120.13722, 37.61096], [-120.1377, 37.61113], [-120.13824, 37.61118], [-120.13977, 37.6116], [-120.14039, 37.61255], [-120.14143, 37.6126], [-120.14144, 37.6112], [-120.14356, 37.61189], [-120.14296, 37.61408], [-120.14399, 37.61608], [-120.15147, 37.62161]]], [[[-120.27469, 37.63688], [-120.27456, 37.63999], [-120.27428, 37.63999], [-120.2739, 37.63785], [-120.27129, 37.64012], [-120.26991, 37.64025], [-120.27011, 37.63697], [-120.27197, 37.63689], [-120.27469, 37.63688]]], [[[-120.28804, 37.64771], [-120.28802, 37.65131], [-120.2833, 37.65117], [-120.28348, 37.64757], [-120.28804, 37.64771]]], [[[-120.16434, 37.63453], [-120.16406, 37.63432], [-120.16535, 37.63319], [-120.16603, 37.63368], [-120.1673, 37.63235], [-120.1656, 37.63111], [-120.16432, 37.63244], [-120.16277, 37.6313], [-120.16239, 37.6281], [-120.16033, 37.62802], [-120.16008, 37.62628], [-120.15808, 37.62623], [-120.15759, 37.62358], [-120.16225, 37.6236], [-120.16234, 37.62766], [-120.1624, 37.62809], [-120.16292, 37.6281], [-120.1677, 37.63159], [-120.16901, 37.6324], [-120.17146, 37.63519], [-120.17345, 37.63571], [-120.17324, 37.63639], [-120.17598, 37.63906], [-120.17923, 37.64257], [-120.18133, 37.64228], [-120.18288, 37.64263], [-120.18234, 37.64313], [-120.18233, 37.64296], [-120.17785, 37.64318], [-120.17787, 37.64534], [-120.17718, 37.64381], [-120.17639, 37.64407], [-120.17712, 37.64586], [-120.17785, 37.64561], [-120.17785, 37.6483], [-120.17676, 37.64667], [-120.17517, 37.64819], [-120.17505, 37.65158], [-120.17274, 37.65274], [-120.17426, 37.64964], [-120.17384, 37.64535], [-120.17611, 37.64493], [-120.17611, 37.64491], [-120.17123, 37.6391], [-120.16886, 37.63914], [-120.16636, 37.63625], [-120.16517, 37.6351], [-120.16434, 37.63453]]], [[[-120.19942, 37.65321], [-120.18545, 37.65312], [-120.18509, 37.65278], [-120.1821, 37.65287], [-120.18004, 37.6516], [-120.17956, 37.65087], [-120.19147, 37.65012], [-120.19147, 37.64977], [-120.19365, 37.65053], [-120.19393, 37.65183], [-120.19747, 37.65306], [-120.19888, 37.65255], [-120.19942, 37.65321]]], [[[-120.32305, 37.6929], [-120.32256, 37.69339], [-120.32235, 37.69302], [-120.32227, 37.69294], [-120.3221, 37.69286], [-120.32176, 37.69274], [-120.32161, 37.69263], [-120.32143, 37.69239], [-120.32126, 37.69198], [-120.32113, 37.69178], [-120.32092, 37.69156], [-120.32062, 37.69136], [-120.32015, 37.69118], [-120.32006, 37.69112], [-120.31983, 37.69094], [-120.31979, 37.69133], [-120.31971, 37.69128], [-120.31938, 37.69116], [-120.31902, 37.69113], [-120.31896, 37.69114], [-120.31889, 37.69119], [-120.31885, 37.69132], [-120.31884, 37.69143], [-120.31887, 37.69159], [-120.31893, 37.69175], [-120.31901, 37.6919], [-120.31943, 37.69248], [-120.31951, 37.69265], [-120.31982, 37.69306], [-120.32007, 37.69329], [-120.32016, 37.69342], [-120.32023, 37.69355], [-120.32026, 37.69369], [-120.32027, 37.69383], [-120.32028, 37.69444], [-120.32056, 37.69487], [-120.32084, 37.69527], [-120.32105, 37.69563], [-120.32118, 37.696], [-120.3212, 37.69643], [-120.32086, 37.69643], [-120.3197, 37.6944], [-120.31824, 37.69241], [-120.31532, 37.69246], [-120.31535, 37.68888], [-120.31775, 37.68889], [-120.3178, 37.6886], [-120.3178, 37.68845], [-120.31767, 37.68824], [-120.31753, 37.68788], [-120.31753, 37.68768], [-120.31709, 37.6873], [-120.31691, 37.68708], [-120.31655, 37.68676], [-120.31617, 37.68626], [-120.31599, 37.6861], [-120.31534, 37.68535], [-120.31534, 37.68524], [-120.31523, 37.68515], [-120.31504, 37.68506], [-120.31498, 37.68502], [-120.31481, 37.68485], [-120.31462, 37.68472], [-120.3145, 37.68466], [-120.31443, 37.68458], [-120.31441, 37.68448], [-120.31439, 37.68431], [-120.31435, 37.68422], [-120.31429, 37.68414], [-120.31412, 37.68399], [-120.31399, 37.68373], [-120.31395, 37.6837], [-120.31361, 37.68358], [-120.31354, 37.68353], [-120.31337, 37.68333], [-120.31326, 37.68315], [-120.31318, 37.68285], [-120.31303, 37.68272], [-120.31304, 37.68255], [-120.313, 37.68249], [-120.31282, 37.68233], [-120.31263, 37.68224], [-120.31257, 37.68218], [-120.31251, 37.6821], [-120.31246, 37.68195], [-120.3124, 37.68183], [-120.31227, 37.68165], [-120.31221, 37.6816], [-120.31201, 37.68153], [-120.31183, 37.68139], [-120.31169, 37.68126], [-120.31139, 37.68091], [-120.31135, 37.68082], [-120.31132, 37.6807], [-120.3111, 37.68059], [-120.31087, 37.68022], [-120.31086, 37.68023], [-120.31069, 37.68154], [-120.30587, 37.68156], [-120.30091, 37.68154], [-120.30127, 37.67781], [-120.29598, 37.67777], [-120.29599, 37.67625], [-120.29264, 37.67623], [-120.29254, 37.67982], [-120.28809, 37.6796], [-120.28798, 37.67589], [-120.27894, 37.67524], [-120.27489, 37.67552], [-120.27428, 37.66634], [-120.2695, 37.66665], [-120.25918, 37.66738], [-120.25934, 37.66452], [-120.25342, 37.66433], [-120.25337, 37.66659], [-120.25346, 37.67204], [-120.259, 37.67216], [-120.25906, 37.67037], [-120.26472, 37.6705], [-120.26468, 37.6737], [-120.25895, 37.67352], [-120.25908, 37.67961], [-120.25912, 37.6831], [-120.25926, 37.6879], [-120.2593, 37.69219], [-120.25901, 37.70076], [-120.25742, 37.70101], [-120.2511, 37.70193], [-120.24991, 37.70291], [-120.24956, 37.70111], [-120.25362, 37.70124], [-120.25316, 37.6977], [-120.24992, 37.69762], [-120.24995, 37.6939], [-120.24057, 37.69398], [-120.24063, 37.69036], [-120.23613, 37.69035], [-120.2362, 37.68773], [-120.23425, 37.6875], [-120.23624, 37.68642], [-120.23633, 37.68273], [-120.23624, 37.67886], [-120.24057, 37.67893], [-120.24056, 37.67513], [-120.24488, 37.67535], [-120.24494, 37.67161], [-120.24049, 37.67142], [-120.24046, 37.66835], [-120.23718, 37.66815], [-120.23774, 37.66769], [-120.23774, 37.66767], [-120.2361, 37.66763], [-120.23608, 37.66387], [-120.23163, 37.66386], [-120.23171, 37.66762], [-120.22714, 37.66752], [-120.22712, 37.66377], [-120.22263, 37.66368], [-120.22261, 37.66399], [-120.22242, 37.66373], [-120.21858, 37.66373], [-120.21868, 37.66748], [-120.21678, 37.66747], [-120.21833, 37.66692], [-120.21707, 37.66522], [-120.21357, 37.6652], [-120.21263, 37.6644], [-120.20855, 37.66382], [-120.20633, 37.66352], [-120.2072, 37.66117], [-120.20544, 37.66051], [-120.20562, 37.65411], [-120.20421, 37.65318], [-120.20069, 37.65268], [-120.20013, 37.6517], [-120.20566, 37.65192], [-120.21415, 37.65222], [-120.21414, 37.65998], [-120.2241, 37.66008], [-120.23154, 37.66014], [-120.23151, 37.65263], [-120.23604, 37.65269], [-120.23604, 37.66016], [-120.23996, 37.66022], [-120.24001, 37.66018], [-120.24354, 37.66028], [-120.24952, 37.66038], [-120.24948, 37.66418], [-120.2534, 37.66433], [-120.25341, 37.66432], [-120.2535, 37.65857], [-120.25354, 37.65678], [-120.25079, 37.6567], [-120.24049, 37.6565], [-120.24041, 37.65274], [-120.2444, 37.65279], [-120.25129, 37.65295], [-120.25924, 37.65308], [-120.26, 37.65316], [-120.26007, 37.65206], [-120.26188, 37.65241], [-120.27418, 37.65138], [-120.27434, 37.65323], [-120.27433, 37.65594], [-120.27882, 37.65561], [-120.27902, 37.65909], [-120.27885, 37.66059], [-120.27878, 37.66246], [-120.28739, 37.66277], [-120.28739, 37.66138], [-120.28731, 37.65918], [-120.29672, 37.65947], [-120.29602, 37.67399], [-120.30164, 37.67407], [-120.30066, 37.67467], [-120.30149, 37.67546], [-120.3015, 37.67546], [-120.30154, 37.67505], [-120.30185, 37.67533], [-120.30218, 37.67553], [-120.30224, 37.67558], [-120.3023, 37.67567], [-120.30232, 37.67567], [-120.30237, 37.67558], [-120.30238, 37.67552], [-120.30234, 37.67536], [-120.30234, 37.67533], [-120.30259, 37.67519], [-120.30272, 37.67507], [-120.30281, 37.67501], [-120.30293, 37.67498], [-120.30301, 37.67491], [-120.30306, 37.6749], [-120.30317, 37.6749], [-120.30324, 37.67492], [-120.3034, 37.67502], [-120.30383, 37.67551], [-120.3043, 37.67623], [-120.30469, 37.6766], [-120.30479, 37.67689], [-120.3048, 37.67707], [-120.30482, 37.67709], [-120.30505, 37.67711], [-120.30518, 37.67716], [-120.3055, 37.67741], [-120.30558, 37.67754], [-120.30558, 37.6776], [-120.30554, 37.6777], [-120.30544, 37.67784], [-120.30518, 37.67817], [-120.30509, 37.67844], [-120.30502, 37.67873], [-120.30504, 37.67875], [-120.30517, 37.67872], [-120.30526, 37.67862], [-120.30533, 37.67858], [-120.3057, 37.67848], [-120.30613, 37.67843], [-120.30623, 37.67845], [-120.30659, 37.67533], [-120.30658, 37.67533], [-120.30653, 37.67538], [-120.30641, 37.67545], [-120.30627, 37.67548], [-120.30612, 37.67544], [-120.3058, 37.67522], [-120.3057, 37.67512], [-120.30556, 37.67494], [-120.30515, 37.6743], [-120.30499, 37.67412], [-120.30549, 37.67412], [-120.30622, 37.67516], [-120.30665, 37.67487], [-120.30673, 37.67414], [-120.31161, 37.67416], [-120.31107, 37.67951], [-120.31123, 37.68028], [-120.31281, 37.6815], [-120.31386, 37.68277], [-120.31429, 37.68337], [-120.31482, 37.6843], [-120.31535, 37.68474], [-120.31586, 37.68497], [-120.31645, 37.68558], [-120.31761, 37.68696], [-120.31802, 37.6875], [-120.31827, 37.68825], [-120.31822, 37.68889], [-120.31988, 37.69035], [-120.32142, 37.69134], [-120.32248, 37.69239], [-120.32305, 37.6929]], [[-120.27867, 37.66359], [-120.27868, 37.66358], [-120.27877, 37.66248], [-120.27792, 37.6635], [-120.27867, 37.66359]]]]} | Open Access 1 | 48981 | Lake McClure (Exchequer Reservoir) | 6445 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 2240 | Merced Irrigation District 620 | Special District 4 | Irrigation District 16 | http://www.lakemcclure.com/ | Mariposa 31 | 5305.275 | Lake McClure (Exchequer Reservoir) | 0 | None 1365 |
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]);