superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
24 rows where MNG_AGENCY = 89 and MNG_AG_TYP = 10 sorted by id
This data as json, copyable, CSV (advanced)
ACCESS_TYP 3
MNG_AG_TYP 1
- Non Profit - Land Trust · 4 ✖
MNG_AGENCY 1
- Center for Natural Lands Management · 4 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14270 | 14270 | 14269 | {"type": "Polygon", "coordinates": [[[-116.36903, 33.83109], [-116.36896, 33.83837], [-116.36677, 33.83836], [-116.36686, 33.83109], [-116.36903, 33.83109]]]} | Unknown Access 4 | Unnamed site - Center for Natural Lands Management | 28629 | 3014 | Center for Natural Lands Management 89 | Non Profit 6 | Non Profit - Land Trust 10 | http://cnlm.org/ | Non Governmental Organization 10 | 40.195 | |||
14271 | 14271 | 14270 | {"type": "Polygon", "coordinates": [[[-121.86524, 36.95323], [-121.8652, 36.95328], [-121.86519, 36.95407], [-121.86435, 36.9541], [-121.86433, 36.95383], [-121.86433, 36.95311], [-121.86434, 36.95307], [-121.86438, 36.95306], [-121.86444, 36.95305], [-121.86478, 36.95308], [-121.86502, 36.95314], [-121.86524, 36.95323]]]} | Open Access 1 | Unnamed site - Center for Natural Lands Management | 28630 | 3014 | Center for Natural Lands Management 89 | Non Profit 6 | Non Profit - Land Trust 10 | http://cnlm.org/ | Non Governmental Organization 10 | 2.082 | |||
15503 | 15503 | 15502 | {"type": "MultiPolygon", "coordinates": [[[[-116.95131, 32.82963], [-116.95131, 32.83021], [-116.95114, 32.83034], [-116.9508, 32.83075], [-116.95075, 32.83091], [-116.95075, 32.83101], [-116.95077, 32.83111], [-116.95047, 32.83118], [-116.95015, 32.83128], [-116.94998, 32.83117], [-116.95013, 32.83091], [-116.95013, 32.8308], [-116.95008, 32.83067], [-116.94999, 32.83058], [-116.94958, 32.83037], [-116.94912, 32.83033], [-116.94863, 32.83057], [-116.94837, 32.83096], [-116.94836, 32.83124], [-116.94827, 32.83151], [-116.94811, 32.83187], [-116.94808, 32.83205], [-116.94813, 32.83206], [-116.94814, 32.83214], [-116.94818, 32.83221], [-116.94828, 32.8323], [-116.94837, 32.83233], [-116.94857, 32.83236], [-116.94871, 32.83283], [-116.94883, 32.83308], [-116.94895, 32.83323], [-116.94908, 32.83337], [-116.94922, 32.83348], [-116.94941, 32.8336], [-116.9494, 32.83373], [-116.94933, 32.83388], [-116.94937, 32.83402], [-116.94929, 32.83426], [-116.94925, 32.83429], [-116.94916, 32.83442], [-116.94916, 32.83458], [-116.94927, 32.83474], [-116.94935, 32.83481], [-116.94904, 32.83507], [-116.94889, 32.83516], [-116.94877, 32.83519], [-116.94865, 32.83519], [-116.94847, 32.83514], [-116.94833, 32.83504], [-116.94802, 32.83464], [-116.94782, 32.83444], [-116.94775, 32.83428], [-116.94741, 32.83415], [-116.94744, 32.83397], [-116.94744, 32.83386], [-116.94738, 32.83376], [-116.94719, 32.83358], [-116.94684, 32.83345], [-116.94671, 32.83333], [-116.94656, 32.83289], [-116.94632, 32.83245], [-116.94585, 32.83196], [-116.94545, 32.83191], [-116.94523, 32.83219], [-116.94506, 32.83233], [-116.94483, 32.83222], [-116.94437, 32.83145], [-116.94414, 32.83127], [-116.94397, 32.831], [-116.94378, 32.8309], [-116.94367, 32.8309], [-116.94335, 32.83102], [-116.94301, 32.83041], [-116.94316, 32.83037], [-116.94328, 32.83025], [-116.9433, 32.82988], [-116.94227, 32.82818], [-116.94213, 32.8282], [-116.94168, 32.82763], [-116.94133, 32.82731], [-116.94087, 32.82743], [-116.94113, 32.82837], [-116.9421, 32.83], [-116.94262, 32.8298], [-116.94287, 32.83056], [-116.94318, 32.83109], [-116.94315, 32.8311], [-116.94297, 32.83097], [-116.94291, 32.83096], [-116.94281, 32.83096], [-116.94277, 32.83093], [-116.94255, 32.831], [-116.94259, 32.83114], [-116.94266, 32.83123], [-116.94267, 32.83128], [-116.94263, 32.83149], [-116.94257, 32.83151], [-116.94251, 32.83141], [-116.94238, 32.83131], [-116.94194, 32.83113], [-116.94183, 32.83111], [-116.94153, 32.83112], [-116.9415, 32.83121], [-116.94097, 32.83047], [-116.94132, 32.83014], [-116.94004, 32.82856], [-116.93998, 32.82777], [-116.93891, 32.82645], [-116.93871, 32.82573], [-116.93798, 32.82498], [-116.93798, 32.82414], [-116.9438, 32.82422], [-116.94341, 32.82479], [-116.94597, 32.82657], [-116.94531, 32.82749], [-116.94581, 32.82963], [-116.95131, 32.82963]]], [[[-116.95265, 32.84001], [-116.95263, 32.84088], [-116.95214, 32.84086], [-116.95181, 32.84042], [-116.95154, 32.8401], [-116.95121, 32.83982], [-116.95087, 32.83959], [-116.95007, 32.83933], [-116.94968, 32.83922], [-116.94891, 32.83909], [-116.94852, 32.83906], [-116.94812, 32.83904], [-116.94721, 32.83907], [-116.94663, 32.83921], [-116.94627, 32.83963], [-116.94597, 32.84032], [-116.94593, 32.8407], [-116.94594, 32.84113], [-116.94614, 32.84158], [-116.94644, 32.8419], [-116.9467, 32.84202], [-116.94509, 32.84199], [-116.94511, 32.83553], [-116.94473, 32.83538], [-116.94445, 32.83451], [-116.94396, 32.83412], [-116.94368, 32.83361], [-116.94319, 32.83322], [-116.94306, 32.83331], [-116.94248, 32.8328], [-116.94175, 32.83178], [-116.94187, 32.83172], [-116.9419, 32.83173], [-116.94194, 32.83169], [-116.94197, 32.83162], [-116.94198, 32.83155], [-116.94196, 32.83149], [-116.94184, 32.83135], [-116.94225, 32.83152], [-116.94231, 32.83161], [-116.94234, 32.83176], [-116.9424, 32.83188], [-116.94248, 32.83193], [-116.94258, 32.83195], [-116.9427, 32.83193], [-116.94286, 32.83169], [-116.94289, 32.83161], [-116.94295, 32.83129], [-116.9431, 32.83146], [-116.9431, 32.83154], [-116.94313, 32.83157], [-116.9432, 32.8316], [-116.94317, 32.8318], [-116.9432, 32.83199], [-116.94342, 32.83234], [-116.94347, 32.83255], [-116.94356, 32.83267], [-116.94366, 32.83273], [-116.94379, 32.83301], [-116.94399, 32.83327], [-116.94447, 32.83355], [-116.94464, 32.83373], [-116.94479, 32.83398], [-116.94517, 32.83442], [-116.94533, 32.83466], [-116.94544, 32.8348], [-116.94545, 32.83493], [-116.9456, 32.83515], [-116.94577, 32.83526], [-116.94598, 32.83524], [-116.94629, 32.83513], [-116.94656, 32.83499], [-116.94678, 32.83481], [-116.94705, 32.83491], [-116.94732, 32.83489], [-116.94759, 32.83468], [-116.94771, 32.8348], [-116.94788, 32.83503], [-116.9479, 32.83516], [-116.94804, 32.83531], [-116.94817, 32.83534], [-116.9483, 32.83541], [-116.94845, 32.83547], [-116.94869, 32.8355], [-116.9487, 32.83556], [-116.95115, 32.83556], [-116.95109, 32.8377], [-116.95174, 32.83773], [-116.95169, 32.83943], [-116.95202, 32.83945], [-116.95201, 32.83999], [-116.95265, 32.84001]], [[-116.94884, 32.83756], [-116.94908, 32.83757], [-116.94938, 32.8373], [-116.94947, 32.83675], [-116.94879, 32.83667], [-116.94884, 32.83756]]], [[[-116.95669, 32.82962], [-116.95654, 32.83497], [-116.95635, 32.83495], [-116.95638, 32.83471], [-116.95628, 32.83456], [-116.95619, 32.83452], [-116.95609, 32.83434], [-116.95588, 32.83427], [-116.9558, 32.83427], [-116.95567, 32.83419], [-116.95552, 32.83414], [-116.95532, 32.83416], [-116.95531, 32.83414], [-116.95521, 32.83415], [-116.95506, 32.834], [-116.95488, 32.83367], [-116.95483, 32.83348], [-116.95481, 32.83335], [-116.95466, 32.83319], [-116.95474, 32.83289], [-116.95481, 32.83275], [-116.95485, 32.83257], [-116.95491, 32.83249], [-116.95499, 32.83243], [-116.95509, 32.83233], [-116.95517, 32.83224], [-116.95527, 32.83218], [-116.9553, 32.83219], [-116.95532, 32.83217], [-116.95532, 32.83212], [-116.95541, 32.83201], [-116.95548, 32.83199], [-116.95558, 32.83188], [-116.95562, 32.83175], [-116.95561, 32.83162], [-116.95554, 32.83146], [-116.95535, 32.83134], [-116.955, 32.83137], [-116.95486, 32.83146], [-116.95482, 32.83152], [-116.9548, 32.83153], [-116.9546, 32.83141], [-116.9544, 32.83131], [-116.95436, 32.83119], [-116.95433, 32.83116], [-116.95433, 32.8311], [-116.95428, 32.83098], [-116.95418, 32.83088], [-116.95405, 32.83081], [-116.9539, 32.83078], [-116.95377, 32.83079], [-116.95348, 32.83086], [-116.95322, 32.83097], [-116.95299, 32.83113], [-116.95286, 32.83129], [-116.95282, 32.83142], [-116.95268, 32.83165], [-116.95265, 32.83179], [-116.95256, 32.83194], [-116.95252, 32.83207], [-116.95241, 32.83209], [-116.95223, 32.83206], [-116.95219, 32.83203], [-116.95217, 32.83197], [-116.95212, 32.83195], [-116.95207, 32.83182], [-116.95202, 32.83174], [-116.95199, 32.83163], [-116.95183, 32.83144], [-116.95172, 32.83137], [-116.95157, 32.83134], [-116.9515, 32.83116], [-116.95146, 32.83115], [-116.95132, 32.83126], [-116.95125, 32.83126], [-116.95124, 32.83118], [-116.95112, 32.83102], [-116.95112, 32.83092], [-116.95141, 32.83042], [-116.95153, 32.83037], [-116.95186, 32.83031], [-116.95204, 32.83022], [-116.95224, 32.83004], [-116.95232, 32.82994], [-116.95238, 32.82983], [-116.95242, 32.82963], [-116.95669, 32.82962]]], [[[-116.95321, 32.83622], [-116.95321, 32.83622], [-116.95179, 32.83622], [-116.95198, 32.83605], [-116.95199, 32.83583], [-116.95203, 32.83582], [-116.95203, 32.83578], [-116.9521, 32.83584], [-116.95218, 32.83588], [-116.95233, 32.83589], [-116.95239, 32.83598], [-116.95246, 32.83603], [-116.95283, 32.8361], [-116.95312, 32.83607], [-116.95315, 32.83611], [-116.95321, 32.83611], [-116.95321, 32.83622]]], [[[-116.95858, 32.83819], [-116.95645, 32.83814], [-116.95649, 32.83674], [-116.95652, 32.83678], [-116.95669, 32.83683], [-116.95683, 32.83684], [-116.95693, 32.83682], [-116.95697, 32.83687], [-116.95704, 32.83685], [-116.95729, 32.83718], [-116.95733, 32.83734], [-116.95738, 32.83739], [-116.95745, 32.83744], [-116.9576, 32.8375], [-116.95769, 32.83751], [-116.9578, 32.8375], [-116.9581, 32.83787], [-116.95824, 32.83794], [-116.95838, 32.83797], [-116.9585, 32.83812], [-116.95858, 32.83819]]], [[[-116.96895, 32.87857], [-116.96687, 32.87858], [-116.96687, 32.87678], [-116.96894, 32.87677], [-116.96895, 32.87857]]], [[[-117.00734, 32.82839], [-117.00392, 32.82838], [-117.0039, 32.82652], [-117.00386, 32.82602], [-117.0038, 32.82557], [-117.00368, 32.82495], [-117.00357, 32.82448], [-117.00326, 32.82344], [-117.00307, 32.82251], [-117.00276, 32.8221], [-117.00268, 32.82025], [-117.00321, 32.82077], [-117.00576, 32.82077], [-117.00573, 32.82408], [-117.00731, 32.82409], [-117.00734, 32.82839]]]]} | No Public Access 3 | Rattlesnake Mountain | 24195 | 3014 | Center for Natural Lands Management 89 | Non Profit 6 | Non Profit - Land Trust 10 | http://cnlm.org/ | Non Governmental Organization 10 | 324.406 | Rattlesnake Mtn. | ||
15533 | 15533 | 15532 | {"type": "MultiPolygon", "coordinates": [[[[-121.86855, 36.95368], [-121.86785, 36.9536], [-121.86778, 36.95397], [-121.86827, 36.95404], [-121.8681, 36.95412], [-121.86798, 36.95419], [-121.86788, 36.95429], [-121.86781, 36.9544], [-121.86779, 36.95418], [-121.86747, 36.95345], [-121.86637, 36.95283], [-121.86511, 36.95253], [-121.86503, 36.95133], [-121.86479, 36.95133], [-121.86423, 36.95139], [-121.86423, 36.95134], [-121.86425, 36.95128], [-121.86429, 36.95123], [-121.86436, 36.9512], [-121.86471, 36.95107], [-121.86509, 36.95088], [-121.86524, 36.95084], [-121.8657, 36.95078], [-121.86565, 36.95101], [-121.86605, 36.9511], [-121.86605, 36.95118], [-121.86571, 36.95128], [-121.86586, 36.95146], [-121.86623, 36.95156], [-121.8665, 36.9518], [-121.86681, 36.95186], [-121.86727, 36.95224], [-121.86812, 36.95308], [-121.86841, 36.95299], [-121.86849, 36.95322], [-121.86855, 36.95356], [-121.86855, 36.95368]]], [[[-121.87549, 36.96011], [-121.87303, 36.96118], [-121.87263, 36.96085], [-121.87208, 36.96106], [-121.8715, 36.96037], [-121.87129, 36.96025], [-121.87108, 36.96047], [-121.87106, 36.96044], [-121.87104, 36.96033], [-121.871, 36.96027], [-121.87089, 36.96023], [-121.87076, 36.96024], [-121.87069, 36.96029], [-121.87066, 36.96034], [-121.87065, 36.96041], [-121.87068, 36.96047], [-121.87072, 36.96051], [-121.87079, 36.96055], [-121.87098, 36.96054], [-121.87108, 36.9606], [-121.87119, 36.96069], [-121.87125, 36.96077], [-121.87135, 36.96098], [-121.87154, 36.96118], [-121.87158, 36.96134], [-121.87152, 36.96137], [-121.87159, 36.9615], [-121.87162, 36.96154], [-121.87168, 36.96152], [-121.87188, 36.96173], [-121.8719, 36.96183], [-121.87187, 36.96192], [-121.8718, 36.962], [-121.87175, 36.962], [-121.87174, 36.96207], [-121.87167, 36.96219], [-121.8711, 36.962], [-121.87087, 36.96207], [-121.87033, 36.96217], [-121.87019, 36.96225], [-121.87022, 36.96236], [-121.87014, 36.96246], [-121.87019, 36.96255], [-121.87075, 36.96276], [-121.87084, 36.96298], [-121.87079, 36.96353], [-121.87048, 36.96362], [-121.87038, 36.96339], [-121.87039, 36.9631], [-121.87007, 36.96249], [-121.86907, 36.96281], [-121.86843, 36.96158], [-121.86812, 36.96111], [-121.86787, 36.96082], [-121.86533, 36.95799], [-121.86511, 36.95772], [-121.86486, 36.95753], [-121.86466, 36.95712], [-121.86454, 36.9568], [-121.86445, 36.95647], [-121.86445, 36.95601], [-121.86453, 36.95553], [-121.86448, 36.95518], [-121.86439, 36.9549], [-121.8649, 36.95487], [-121.86486, 36.95408], [-121.86519, 36.95406], [-121.8652, 36.95327], [-121.86524, 36.95323], [-121.86562, 36.9534], [-121.86678, 36.95378], [-121.86691, 36.95385], [-121.86707, 36.95399], [-121.86716, 36.95411], [-121.86721, 36.95423], [-121.86679, 36.95432], [-121.8665, 36.95426], [-121.86637, 36.95445], [-121.86628, 36.95446], [-121.8662, 36.95451], [-121.86588, 36.95437], [-121.8658, 36.95458], [-121.86587, 36.95474], [-121.8657, 36.9548], [-121.8659, 36.95526], [-121.86639, 36.95509], [-121.8665, 36.95521], [-121.86651, 36.95524], [-121.86642, 36.95549], [-121.86614, 36.95593], [-121.86573, 36.95583], [-121.86567, 36.95607], [-121.86568, 36.95616], [-121.8657, 36.95632], [-121.86581, 36.95656], [-121.8661, 36.95688], [-121.86641, 36.95667], [-121.86673, 36.95691], [-121.86689, 36.957], [-121.86703, 36.9571], [-121.86713, 36.95723], [-121.86715, 36.95732], [-121.86715, 36.95746], [-121.86716, 36.95754], [-121.86722, 36.95764], [-121.86728, 36.95771], [-121.86741, 36.95781], [-121.86797, 36.95802], [-121.8682, 36.95822], [-121.86845, 36.95832], [-121.86852, 36.95836], [-121.86857, 36.95843], [-121.86876, 36.95879], [-121.8689, 36.95897], [-121.86887, 36.95902], [-121.86901, 36.95913], [-121.86907, 36.9591], [-121.86919, 36.95917], [-121.86927, 36.95926], [-121.8694, 36.9593], [-121.86953, 36.95926], [-121.86959, 36.9592], [-121.8696, 36.95914], [-121.86958, 36.95906], [-121.86953, 36.95901], [-121.86948, 36.95898], [-121.86937, 36.95897], [-121.86926, 36.95901], [-121.86958, 36.95877], [-121.86924, 36.95837], [-121.86877, 36.95851], [-121.86873, 36.95845], [-121.86913, 36.95826], [-121.869, 36.95808], [-121.86835, 36.95758], [-121.86804, 36.95742], [-121.86779, 36.95782], [-121.86745, 36.95768], [-121.86737, 36.95762], [-121.8673, 36.95753], [-121.86728, 36.95745], [-121.86728, 36.95727], [-121.86722, 36.95713], [-121.86716, 36.95704], [-121.86697, 36.9569], [-121.86696, 36.95687], [-121.86697, 36.95684], [-121.86708, 36.95675], [-121.86717, 36.95672], [-121.86726, 36.95672], [-121.86753, 36.95684], [-121.86771, 36.95685], [-121.86778, 36.95712], [-121.86841, 36.95715], [-121.86852, 36.95685], [-121.86841, 36.95668], [-121.86849, 36.95661], [-121.86896, 36.95651], [-121.86866, 36.95606], [-121.86805, 36.95608], [-121.86742, 36.95624], [-121.86731, 36.95657], [-121.8672, 36.95657], [-121.86709, 36.95658], [-121.86695, 36.95664], [-121.86684, 36.95672], [-121.86679, 36.95673], [-121.86661, 36.9566], [-121.8669, 36.95637], [-121.8667, 36.95616], [-121.8668, 36.95586], [-121.86645, 36.95576], [-121.86658, 36.95556], [-121.86694, 36.95563], [-121.86707, 36.95545], [-121.86757, 36.9553], [-121.86744, 36.95498], [-121.86761, 36.95489], [-121.86776, 36.95478], [-121.8682, 36.95508], [-121.86839, 36.9549], [-121.86845, 36.95462], [-121.86807, 36.95434], [-121.86814, 36.95429], [-121.86838, 36.95417], [-121.86854, 36.95405], [-121.86864, 36.95393], [-121.86871, 36.95381], [-121.86874, 36.95372], [-121.86875, 36.95359], [-121.86872, 36.95343], [-121.8695, 36.95337], [-121.8697, 36.95315], [-121.87043, 36.95349], [-121.86981, 36.95388], [-121.86968, 36.95406], [-121.8729, 36.95732], [-121.87454, 36.95909], [-121.8745, 36.95921], [-121.87478, 36.95933], [-121.87549, 36.96011]]]]} | Open Access 1 | Center For Natural Lands Management | 17036 | 3014 | Center for Natural Lands Management 89 | Non Profit 6 | Non Profit - Land Trust 10 | http://cnlm.org/ | Non Governmental Organization 10 | 134.863 | Ctr. For Natural Lands Management |
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]);