superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
43 rows where MNG_AGENCY = 61 and MNG_AG_TYP = 10
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13298 | 13298 | 13297 | {"type": "Polygon", "coordinates": [[[-121.44101, 38.26353], [-121.44108, 38.26383], [-121.44114, 38.26415], [-121.44115, 38.26442], [-121.44115, 38.26468], [-121.44112, 38.26494], [-121.44106, 38.2652], [-121.44099, 38.26545], [-121.4409, 38.26568], [-121.44061, 38.26555], [-121.43901, 38.26458], [-121.439, 38.26459], [-121.43905, 38.26515], [-121.43873, 38.26566], [-121.43893, 38.26623], [-121.4405, 38.26654], [-121.43863, 38.27055], [-121.43851, 38.27088], [-121.43845, 38.27111], [-121.43842, 38.27134], [-121.4384, 38.27157], [-121.4384, 38.2718], [-121.43844, 38.27209], [-121.43847, 38.27226], [-121.43863, 38.27278], [-121.43743, 38.26945], [-121.43667, 38.26944], [-121.43619, 38.26994], [-121.43605, 38.27006], [-121.43581, 38.27022], [-121.43552, 38.27038], [-121.43528, 38.27049], [-121.43511, 38.27053], [-121.4349, 38.27054], [-121.43466, 38.27052], [-121.43453, 38.27047], [-121.4344, 38.27039], [-121.43435, 38.27034], [-121.43428, 38.27024], [-121.43426, 38.2701], [-121.4343, 38.2699], [-121.43437, 38.26969], [-121.43451, 38.26944], [-121.43365, 38.26943], [-121.43357, 38.27302], [-121.42942, 38.273], [-121.42926, 38.26866], [-121.42579, 38.26863], [-121.42578, 38.2663], [-121.42502, 38.26479], [-121.42414, 38.26368], [-121.42533, 38.26134], [-121.42541, 38.26004], [-121.42528, 38.25894], [-121.42669, 38.25701], [-121.42884, 38.25743], [-121.42873, 38.25424], [-121.42892, 38.25424], [-121.42904, 38.25441], [-121.42919, 38.25473], [-121.42927, 38.25482], [-121.42937, 38.2549], [-121.42962, 38.25497], [-121.43061, 38.25503], [-121.43105, 38.255], [-121.43173, 38.25486], [-121.43215, 38.25472], [-121.43218, 38.25475], [-121.43226, 38.25467], [-121.43411, 38.25429], [-121.43466, 38.2543], [-121.43514, 38.25444], [-121.43557, 38.25464], [-121.4358, 38.25485], [-121.43601, 38.25495], [-121.4365, 38.25511], [-121.4369, 38.25515], [-121.43711, 38.25516], [-121.43721, 38.25519], [-121.43817, 38.2551], [-121.439, 38.25512], [-121.43912, 38.25525], [-121.43959, 38.25548], [-121.43943, 38.25611], [-121.43866, 38.25662], [-121.43832, 38.25672], [-121.43828, 38.26167], [-121.43868, 38.26169], [-121.43893, 38.26255], [-121.43933, 38.26339], [-121.44101, 38.26353]], [[-121.43345, 38.25739], [-121.43346, 38.25737], [-121.43339, 38.25721], [-121.43308, 38.25732], [-121.43314, 38.25746], [-121.43345, 38.25739]]]} | Open Access 1 | Cosumnes River Preserve | 30622 | 3091 | The Nature Conservancy 61 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.nature.org/ | Non Governmental Organization 10 | 505.435 | Cosumnes River Preserve | ||
13307 | 13307 | 13306 | {"type": "MultiPolygon", "coordinates": [[[[-121.42884, 38.25745], [-121.42668, 38.25702], [-121.42529, 38.25894], [-121.42541, 38.26004], [-121.42474, 38.26005], [-121.42481, 38.26013], [-121.42492, 38.26134], [-121.42445, 38.26133], [-121.4244, 38.26069], [-121.4242, 38.26048], [-121.42356, 38.2608], [-121.42246, 38.26102], [-121.42229, 38.2612], [-121.42249, 38.26133], [-121.41767, 38.26132], [-121.41768, 38.26086], [-121.41759, 38.26002], [-121.41055, 38.26001], [-121.41046, 38.2696], [-121.40484, 38.26957], [-121.40485, 38.26886], [-121.40495, 38.26879], [-121.40595, 38.26827], [-121.40645, 38.26804], [-121.40687, 38.26777], [-121.40753, 38.26743], [-121.40777, 38.26728], [-121.40787, 38.26716], [-121.40863, 38.26543], [-121.40884, 38.26455], [-121.40887, 38.26428], [-121.40875, 38.26395], [-121.40855, 38.2636], [-121.4085, 38.26332], [-121.40852, 38.26314], [-121.40874, 38.26284], [-121.40881, 38.26242], [-121.40864, 38.26198], [-121.40843, 38.26173], [-121.40784, 38.2612], [-121.40789, 38.26079], [-121.40811, 38.26037], [-121.40873, 38.25947], [-121.40883, 38.25915], [-121.40879, 38.25872], [-121.40882, 38.25859], [-121.40891, 38.25851], [-121.40987, 38.25812], [-121.41021, 38.25792], [-121.41027, 38.25761], [-121.41019, 38.25731], [-121.40993, 38.25703], [-121.40961, 38.25681], [-121.40928, 38.25665], [-121.40909, 38.25652], [-121.40905, 38.25631], [-121.40906, 38.25616], [-121.40917, 38.25588], [-121.40923, 38.25559], [-121.40919, 38.25522], [-121.40912, 38.25493], [-121.40954, 38.25468], [-121.40922, 38.2544], [-121.40885, 38.2546], [-121.40871, 38.2547], [-121.40861, 38.25487], [-121.40871, 38.25527], [-121.40874, 38.25558], [-121.40869, 38.25579], [-121.40857, 38.25608], [-121.40856, 38.25633], [-121.40863, 38.25672], [-121.40899, 38.25696], [-121.40932, 38.25712], [-121.40957, 38.25729], [-121.40974, 38.25747], [-121.40977, 38.25762], [-121.40976, 38.2577], [-121.40961, 38.25779], [-121.40862, 38.2582], [-121.40836, 38.25841], [-121.4083, 38.2587], [-121.40834, 38.25912], [-121.40827, 38.25933], [-121.40766, 38.2602], [-121.40741, 38.26069], [-121.40734, 38.26132], [-121.40765, 38.26165], [-121.40805, 38.26197], [-121.4082, 38.26215], [-121.40832, 38.26246], [-121.40827, 38.26271], [-121.40805, 38.26301], [-121.408, 38.26333], [-121.40808, 38.26371], [-121.40829, 38.26408], [-121.40837, 38.26432], [-121.40835, 38.2645], [-121.40816, 38.26533], [-121.4074, 38.26702], [-121.40724, 38.26712], [-121.40659, 38.26746], [-121.40618, 38.26772], [-121.40569, 38.26794], [-121.40466, 38.26848], [-121.40446, 38.26861], [-121.40436, 38.26876], [-121.40436, 38.26929], [-121.40432, 38.26956], [-121.39215, 38.26949], [-121.39224, 38.26209], [-121.39777, 38.2621], [-121.39827, 38.26167], [-121.39866, 38.26069], [-121.39865, 38.25957], [-121.39916, 38.25819], [-121.3998, 38.25771], [-121.40069, 38.25608], [-121.40116, 38.25575], [-121.40126, 38.25502], [-121.40216, 38.2541], [-121.4041, 38.25411], [-121.40433, 38.25417], [-121.40523, 38.25423], [-121.40602, 38.25411], [-121.40637, 38.2538], [-121.40648, 38.25364], [-121.40855, 38.25364], [-121.41058, 38.25406], [-121.4106, 38.25414], [-121.42873, 38.25424], [-121.42884, 38.25745]]], [[[-121.42582, 38.27583], [-121.42168, 38.27584], [-121.4222, 38.27506], [-121.42063, 38.26884], [-121.42183, 38.26861], [-121.42579, 38.26863], [-121.42582, 38.27583]]]]} | Restricted Access 2 | Cosumnes River Preserve | 30623 | 3091 | The Nature Conservancy 61 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.nature.org/ | Non Governmental Organization 10 | 846.891 | Cosumnes River Preserve | ||
14208 | 14208 | 14207 | {"type": "MultiPolygon", "coordinates": [[[[-120.49929, 34.50713], [-120.49916, 34.50717], [-120.49922, 34.50755], [-120.49925, 34.50795], [-120.49924, 34.50855], [-120.4992, 34.50882], [-120.49896, 34.50973], [-120.49889, 34.51002], [-120.49885, 34.51032], [-120.49884, 34.51062], [-120.49886, 34.51108], [-120.49891, 34.51137], [-120.49897, 34.51165], [-120.49909, 34.51165], [-120.49926, 34.51215], [-120.49917, 34.51219], [-120.4992, 34.5123], [-120.49818, 34.51303], [-120.49599, 34.51257], [-120.49504, 34.51209], [-120.49505, 34.51087], [-120.49397, 34.51092], [-120.49319, 34.51102], [-120.49229, 34.5108], [-120.4924, 34.51141], [-120.49239, 34.51168], [-120.49118, 34.51197], [-120.49103, 34.51443], [-120.49061, 34.51444], [-120.49033, 34.51473], [-120.49041, 34.5153], [-120.49091, 34.51535], [-120.48799, 34.56446], [-120.48764, 34.56871], [-120.48734, 34.57417], [-120.48656, 34.57396], [-120.48174, 34.57224], [-120.47818, 34.57123], [-120.47696, 34.57086], [-120.47677, 34.57079], [-120.47637, 34.57057], [-120.47613, 34.57048], [-120.47583, 34.57035], [-120.47517, 34.5702], [-120.47494, 34.57019], [-120.4746, 34.57012], [-120.47427, 34.57], [-120.47368, 34.56987], [-120.47332, 34.56987], [-120.47303, 34.56991], [-120.47228, 34.56975], [-120.47201, 34.56973], [-120.47175, 34.56974], [-120.4713, 34.56982], [-120.47093, 34.56983], [-120.47056, 34.56981], [-120.46961, 34.5699], [-120.46822, 34.56995], [-120.4675, 34.56995], [-120.46646, 34.56999], [-120.46519, 34.57033], [-120.46168, 34.56762], [-120.46097, 34.56753], [-120.46, 34.56693], [-120.45928, 34.56561], [-120.45812, 34.56538], [-120.45699, 34.56441], [-120.45535, 34.56444], [-120.45215, 34.56446], [-120.45114, 34.5635], [-120.45068, 34.56315], [-120.44984, 34.56279], [-120.44634, 34.56177], [-120.44177, 34.55993], [-120.44083, 34.55966], [-120.43909, 34.55934], [-120.43842, 34.55943], [-120.43569, 34.56], [-120.4341, 34.55971], [-120.43286, 34.55913], [-120.43028, 34.55901], [-120.43007, 34.55575], [-120.4323, 34.54874], [-120.42938, 34.54706], [-120.42567, 34.54571], [-120.42357, 34.54531], [-120.42046, 34.54663], [-120.41226, 34.54657], [-120.40811, 34.54717], [-120.40696, 34.54657], [-120.40752, 34.54565], [-120.40695, 34.54413], [-120.40631, 34.54308], [-120.40743, 34.54165], [-120.40976, 34.54079], [-120.4107, 34.53717], [-120.4079, 34.53528], [-120.40496, 34.53197], [-120.40252, 34.53066], [-120.39946, 34.52963], [-120.39836, 34.5275], [-120.39894, 34.52703], [-120.39983, 34.5267], [-120.40016, 34.52639], [-120.40014, 34.52601], [-120.40065, 34.52557], [-120.40065, 34.52555], [-120.40027, 34.52526], [-120.39746, 34.52741], [-120.39422, 34.52746], [-120.39215, 34.52594], [-120.38953, 34.52655], [-120.38802, 34.5263], [-120.38773, 34.52605], [-120.38711, 34.52574], [-120.38657, 34.52568], [-120.38592, 34.52501], [-120.38567, 34.52478], [-120.38526, 34.5247], [-120.38513, 34.5243], [-120.38503, 34.52378], [-120.38484, 34.52369], [-120.38424, 34.52363], [-120.38393, 34.52306], [-120.38358, 34.52295], [-120.38315, 34.52317], [-120.38251, 34.52271], [-120.38205, 34.52257], [-120.3815, 34.52247], [-120.38104, 34.52244], [-120.38094, 34.52239], [-120.38101, 34.52327], [-120.37947, 34.52319], [-120.37601, 34.52207], [-120.37537, 34.52171], [-120.37583, 34.5207], [-120.37605, 34.52017], [-120.37529, 34.51906], [-120.37478, 34.51698], [-120.37239, 34.51514], [-120.36748, 34.51527], [-120.36608, 34.51513], [-120.36591, 34.51507], [-120.36545, 34.51395], [-120.36482, 34.51322], [-120.36503, 34.51225], [-120.36333, 34.50973], [-120.36402, 34.50772], [-120.36344, 34.50548], [-120.3625, 34.50494], [-120.36121, 34.50327], [-120.3577, 34.50321], [-120.35913, 34.50025], [-120.36774, 34.50012], [-120.37784, 34.49418], [-120.39274, 34.49387], [-120.39724, 34.49375], [-120.41262, 34.4934], [-120.41639, 34.45393], [-120.4168, 34.45387], [-120.4168, 34.4538], [-120.41867, 34.45358], [-120.42055, 34.4534], [-120.42243, 34.45328], [-120.42432, 34.4532], [-120.43615, 34.45298], [-120.43741, 34.45294], [-120.43867, 34.45285], [-120.43992, 34.45274], [-120.45017, 34.45165], [-120.45079, 34.4516], [-120.45171, 34.4516], [-120.45171, 34.45186], [-120.452, 34.45189], [-120.45238, 34.45198], [-120.45274, 34.45209], [-120.45328, 34.45232], [-120.45382, 34.4526], [-120.45753, 34.45467], [-120.45763, 34.45457], [-120.45812, 34.45488], [-120.45858, 34.45522], [-120.45901, 34.45559], [-120.45942, 34.45598], [-120.4598, 34.45641], [-120.46049, 34.45731], [-120.46403, 34.46221], [-120.46757, 34.46717], [-120.46769, 34.46716], [-120.46808, 34.46774], [-120.47335, 34.47515], [-120.47469, 34.47666], [-120.47711, 34.48001], [-120.4773, 34.48023], [-120.47759, 34.48046], [-120.47761, 34.4808], [-120.47801, 34.48113], [-120.47847, 34.48139], [-120.47931, 34.48214], [-120.4793, 34.48224], [-120.47959, 34.48245], [-120.47971, 34.48246], [-120.48028, 34.48304], [-120.48055, 34.48329], [-120.4813, 34.4839], [-120.48159, 34.4841], [-120.48188, 34.48427], [-120.4828, 34.48473], [-120.48276, 34.48484], [-120.48479, 34.48606], [-120.48451, 34.48641], [-120.48687, 34.488], [-120.48886, 34.49122], [-120.48888, 34.49122], [-120.48902, 34.49104], [-120.48909, 34.49118], [-120.48924, 34.49142], [-120.48958, 34.49188], [-120.48989, 34.49221], [-120.49147, 34.49375], [-120.49216, 34.49447], [-120.49257, 34.49493], [-120.4928, 34.49526], [-120.49347, 34.49635], [-120.49469, 34.49848], [-120.49758, 34.50374], [-120.49802, 34.50444], [-120.49862, 34.50547], [-120.49882, 34.50587], [-120.49906, 34.50646], [-120.49929, 34.50713]]], [[[-120.501, 34.50781], [-120.50069, 34.50846], [-120.50079, 34.50969], [-120.49988, 34.50957], [-120.49992, 34.50937], [-120.49974, 34.50934], [-120.49987, 34.50881], [-120.49993, 34.50824], [-120.49993, 34.50766], [-120.49985, 34.50707], [-120.4995, 34.50711], [-120.49934, 34.50666], [-120.49906, 34.506], [-120.49895, 34.50574], [-120.49869, 34.50525], [-120.49824, 34.50448], [-120.49776, 34.50373], [-120.49484, 34.49842], [-120.49312, 34.49541], [-120.49284, 34.49497], [-120.49225, 34.49428], [-120.49001, 34.49212], [-120.48972, 34.49181], [-120.48955, 34.49158], [-120.48924, 34.49112], [-120.48917, 34.49096], [-120.48896, 34.49028], [-120.48882, 34.4897], [-120.4887, 34.48927], [-120.4886, 34.48901], [-120.48842, 34.48867], [-120.48807, 34.48822], [-120.48765, 34.48773], [-120.48694, 34.48705], [-120.48623, 34.4865], [-120.48524, 34.4858], [-120.4841, 34.48512], [-120.48344, 34.48479], [-120.48276, 34.48448], [-120.48248, 34.48432], [-120.48146, 34.48363], [-120.48112, 34.48338], [-120.4807, 34.48304], [-120.47996, 34.48231], [-120.47829, 34.48074], [-120.47776, 34.48019], [-120.47705, 34.47941], [-120.47599, 34.4781], [-120.47463, 34.47618], [-120.4696, 34.46916], [-120.4681, 34.46711], [-120.46816, 34.46706], [-120.46776, 34.46633], [-120.46475, 34.46226], [-120.4638, 34.46107], [-120.4614, 34.45771], [-120.46013, 34.45614], [-120.45966, 34.45562], [-120.45927, 34.45523], [-120.45896, 34.45495], [-120.45841, 34.45449], [-120.45797, 34.45417], [-120.4581, 34.45401], [-120.4581, 34.45399], [-120.45437, 34.45191], [-120.45378, 34.45161], [-120.45314, 34.45134], [-120.45279, 34.45122], [-120.45218, 34.45108], [-120.4519, 34.45104], [-120.45174, 34.45106], [-120.45172, 34.45146], [-120.45078, 34.45147], [-120.45015, 34.45151], [-120.4399, 34.4526], [-120.43865, 34.45272], [-120.4374, 34.4528], [-120.43614, 34.45285], [-120.42471, 34.45306], [-120.42272, 34.45313], [-120.42073, 34.45325], [-120.41875, 34.45343], [-120.41678, 34.45367], [-120.41675, 34.4536], [-120.41641, 34.45365], [-120.41642, 34.45354], [-120.41682, 34.45344], [-120.417, 34.45333], [-120.41733, 34.45334], [-120.41813, 34.45304], [-120.41855, 34.45268], [-120.41873, 34.45232], [-120.41909, 34.452], [-120.41925, 34.45174], [-120.41938, 34.45146], [-120.41946, 34.45122], [-120.41961, 34.45097], [-120.41987, 34.45072], [-120.42035, 34.45042], [-120.42117, 34.45008], [-120.42166, 34.44995], [-120.42258, 34.44984], [-120.42298, 34.44975], [-120.42369, 34.4498], [-120.42409, 34.44975], [-120.42469, 34.44984], [-120.42531, 34.44988], [-120.42607, 34.44998], [-120.42625, 34.45004], [-120.42759, 34.45032], [-120.43027, 34.45064], [-120.4317, 34.45097], [-120.43351, 34.45122], [-120.43392, 34.45122], [-120.43567, 34.45154], [-120.43721, 34.45153], [-120.43771, 34.45141], [-120.43815, 34.45142], [-120.43875, 34.45149], [-120.43959, 34.45151], [-120.44117, 34.45171], [-120.44169, 34.45169], [-120.44258, 34.45159], [-120.44409, 34.45123], [-120.44507, 34.45079], [-120.44553, 34.45038], [-120.44566, 34.45011], [-120.44569, 34.44976], [-120.44593, 34.44938], [-120.4462, 34.4491], [-120.44651, 34.44894], [-120.44785, 34.4486], [-120.44945, 34.44807], [-120.45082, 34.44751], [-120.45133, 34.44732], [-120.45238, 34.44636], [-120.45299, 34.44524], [-120.45266, 34.44467], [-120.45272, 34.44396], [-120.45195, 34.44288], [-120.45265, 34.4423], [-120.45423, 34.44306], [-120.45625, 34.44332], [-120.45651, 34.44363], [-120.45659, 34.44445], [-120.45743, 34.44488], [-120.45858, 34.44461], [-120.45879, 34.44515], [-120.45835, 34.44589], [-120.45854, 34.44637], [-120.45857, 34.44655], [-120.45863, 34.44661], [-120.45873, 34.44686], [-120.45942, 34.44746], [-120.4603, 34.44783], [-120.46174, 34.44788], [-120.46234, 34.44854], [-120.46322, 34.44892], [-120.46465, 34.44931], [-120.46594, 34.44962], [-120.46773, 34.45139], [-120.46805, 34.45162], [-120.46984, 34.45285], [-120.47099, 34.45314], [-120.47192, 34.45386], [-120.47308, 34.45792], [-120.47411, 34.46815], [-120.47555, 34.47363], [-120.47844, 34.47973], [-120.48168, 34.48245], [-120.48282, 34.4836], [-120.48533, 34.48475], [-120.4882, 34.48704], [-120.48916, 34.48815], [-120.49017, 34.48957], [-120.49098, 34.4921], [-120.49356, 34.49459], [-120.49543, 34.49476], [-120.49631, 34.4955], [-120.4994, 34.50467], [-120.50017, 34.50615], [-120.501, 34.50781]]]]} | No Public Access 3 | Jack and Laura Dangermond Preserve | 31693 | 3091 | The Nature Conservancy 61 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.nature.org/ | Non Governmental Organization 10 | 24282.466 | Jack and Laura Dangermond Preserve |
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]);