superunits_with_maps

Table actions

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

1 row where ACCESS_TYP = 1, MNG_AGENCY = 47 and PARK_NAME = "Malakoff Diggins State Historic Park"

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • California Department of Parks and Recreation · 1 ✖

ACCESS_TYP 1

  • Open Access · 1 ✖
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
15195 15195 15194 {"type": "MultiPolygon", "coordinates": [[[[-120.88732, 39.3856], [-120.88704, 39.38617], [-120.88688, 39.38638], [-120.88665, 39.3864], [-120.88552, 39.38741], [-120.88475, 39.38769], [-120.88352, 39.38763], [-120.88281, 39.38793], [-120.88129, 39.38835], [-120.88113, 39.38847], [-120.88088, 39.38816], [-120.87689, 39.38835], [-120.87315, 39.38854], [-120.8728, 39.38852], [-120.87228, 39.38817], [-120.87152, 39.38758], [-120.87885, 39.3876], [-120.87886, 39.38759], [-120.87879, 39.38732], [-120.87873, 39.3858], [-120.88634, 39.38567], [-120.88668, 39.38566], [-120.88732, 39.3856]]], [[[-120.94541, 39.35609], [-120.94519, 39.35618], [-120.94424, 39.35651], [-120.94411, 39.35658], [-120.94399, 39.35667], [-120.94383, 39.35683], [-120.94362, 39.3571], [-120.94342, 39.35731], [-120.94317, 39.35768], [-120.94247, 39.35844], [-120.94232, 39.35864], [-120.94218, 39.35888], [-120.94157, 39.35911], [-120.941, 39.3593], [-120.94054, 39.35948], [-120.94015, 39.3597], [-120.93941, 39.36018], [-120.93911, 39.36044], [-120.93887, 39.36068], [-120.93872, 39.36087], [-120.93831, 39.36169], [-120.93794, 39.36235], [-120.93782, 39.36251], [-120.93769, 39.36265], [-120.93744, 39.36288], [-120.93719, 39.36304], [-120.93695, 39.36316], [-120.93678, 39.36322], [-120.93654, 39.36329], [-120.93566, 39.36339], [-120.93519, 39.36385], [-120.93388, 39.36466], [-120.93389, 39.36467], [-120.93413, 39.36465], [-120.93447, 39.3645], [-120.93463, 39.3644], [-120.9348, 39.36424], [-120.93541, 39.36388], [-120.93573, 39.36351], [-120.93666, 39.36339], [-120.93684, 39.36335], [-120.93722, 39.36319], [-120.93757, 39.36298], [-120.93785, 39.36273], [-120.93797, 39.36259], [-120.93811, 39.36239], [-120.93822, 39.36219], [-120.93833, 39.36189], [-120.93872, 39.36128], [-120.93895, 39.36083], [-120.93934, 39.36043], [-120.93965, 39.36019], [-120.94021, 39.35983], [-120.94075, 39.35955], [-120.94119, 39.35939], [-120.94144, 39.35941], [-120.94161, 39.35929], [-120.94234, 39.35997], [-120.94227, 39.3601], [-120.94193, 39.36047], [-120.94176, 39.3607], [-120.94163, 39.36092], [-120.94143, 39.36135], [-120.94131, 39.3617], [-120.94125, 39.3618], [-120.9411, 39.36195], [-120.94093, 39.36207], [-120.94053, 39.36227], [-120.94026, 39.36239], [-120.94002, 39.36257], [-120.93986, 39.36275], [-120.93976, 39.36295], [-120.93973, 39.36311], [-120.93974, 39.36328], [-120.94003, 39.36405], [-120.9401, 39.36444], [-120.9401, 39.36475], [-120.94007, 39.36493], [-120.93993, 39.36532], [-120.93986, 39.36545], [-120.93963, 39.36574], [-120.93929, 39.36605], [-120.93855, 39.36677], [-120.93821, 39.36707], [-120.93807, 39.36723], [-120.93786, 39.36752], [-120.93772, 39.3678], [-120.93759, 39.36813], [-120.93746, 39.36859], [-120.93737, 39.36923], [-120.93722, 39.36967], [-120.93704, 39.37025], [-120.936, 39.37224], [-120.9357, 39.37315], [-120.93539, 39.37315], [-120.93557, 39.37352], [-120.93499, 39.37473], [-120.93483, 39.37498], [-120.93468, 39.37518], [-120.93438, 39.37553], [-120.93404, 39.37587], [-120.93306, 39.37674], [-120.9327, 39.37716], [-120.93251, 39.37744], [-120.93223, 39.37789], [-120.93181, 39.37879], [-120.93145, 39.37962], [-120.93103, 39.38033], [-120.9296, 39.38156], [-120.92594, 39.38464], [-120.92351, 39.38532], [-120.91995, 39.38725], [-120.91959, 39.38738], [-120.91924, 39.38762], [-120.91907, 39.38778], [-120.91844, 39.3876], [-120.91818, 39.3876], [-120.91781, 39.38755], [-120.91711, 39.38738], [-120.91599, 39.38743], [-120.91506, 39.38774], [-120.91385, 39.38801], [-120.9123, 39.38818], [-120.91229, 39.38834], [-120.91178, 39.38836], [-120.90917, 39.38902], [-120.90759, 39.38923], [-120.90687, 39.38962], [-120.90681, 39.38967], [-120.90489, 39.39064], [-120.90448, 39.39094], [-120.90413, 39.39087], [-120.90393, 39.39087], [-120.90187, 39.39126], [-120.90118, 39.39125], [-120.90081, 39.39108], [-120.9006, 39.39103], [-120.90043, 39.39103], [-120.90003, 39.39106], [-120.89983, 39.39104], [-120.89948, 39.39098], [-120.89912, 39.39098], [-120.89903, 39.39094], [-120.89879, 39.39078], [-120.89868, 39.39074], [-120.89856, 39.39071], [-120.89735, 39.39058], [-120.89669, 39.39056], [-120.89642, 39.39053], [-120.89617, 39.39045], [-120.89595, 39.39033], [-120.89577, 39.39017], [-120.89568, 39.39002], [-120.89563, 39.38978], [-120.89564, 39.38975], [-120.89575, 39.38936], [-120.89602, 39.38851], [-120.89605, 39.38827], [-120.89603, 39.38814], [-120.89596, 39.38789], [-120.89592, 39.38765], [-120.89592, 39.38732], [-120.8959, 39.38718], [-120.89559, 39.38608], [-120.89593, 39.38587], [-120.89607, 39.38572], [-120.89614, 39.38556], [-120.89624, 39.38497], [-120.89629, 39.38479], [-120.89635, 39.38466], [-120.89663, 39.38418], [-120.89678, 39.38397], [-120.89723, 39.38347], [-120.89741, 39.38321], [-120.89749, 39.38297], [-120.89754, 39.38288], [-120.89823, 39.38204], [-120.89834, 39.38187], [-120.89841, 39.38169], [-120.89845, 39.38155], [-120.89853, 39.38101], [-120.89883, 39.38022], [-120.89927, 39.37921], [-120.89947, 39.37864], [-120.89958, 39.37814], [-120.89963, 39.37769], [-120.89963, 39.37735], [-120.89955, 39.37703], [-120.89949, 39.37689], [-120.89937, 39.37671], [-120.89923, 39.37655], [-120.89896, 39.37634], [-120.89884, 39.37621], [-120.89846, 39.37593], [-120.89814, 39.37564], [-120.89792, 39.37537], [-120.89778, 39.37517], [-120.8976, 39.37479], [-120.89754, 39.37456], [-120.89749, 39.3742], [-120.89747, 39.37377], [-120.89766, 39.37307], [-120.89769, 39.37281], [-120.89769, 39.37267], [-120.89779, 39.37155], [-120.89782, 39.37136], [-120.89792, 39.37112], [-120.89798, 39.37103], [-120.89814, 39.37086], [-120.89828, 39.37076], [-120.89945, 39.37001], [-120.89999, 39.3696], [-120.90071, 39.36955], [-120.90071, 39.36953], [-120.90046, 39.36929], [-120.90098, 39.36891], [-120.90144, 39.36933], [-120.90119, 39.36951], [-120.90119, 39.36953], [-120.90172, 39.36962], [-120.90187, 39.36963], [-120.90188, 39.36937], [-120.90196, 39.36929], [-120.90198, 39.36889], [-120.90209, 39.36896], [-120.90217, 39.36892], [-120.90218, 39.3687], [-120.90245, 39.36909], [-120.90262, 39.36956], [-120.9027, 39.36957], [-120.90252, 39.36903], [-120.90243, 39.3687], [-120.9028, 39.36837], [-120.90275, 39.36834], [-120.90239, 39.36863], [-120.90222, 39.36865], [-120.90214, 39.36861], [-120.90215, 39.36856], [-120.90173, 39.36829], [-120.90284, 39.36734], [-120.90395, 39.3673], [-120.90412, 39.36731], [-120.9041, 39.36748], [-120.90406, 39.36884], [-120.90472, 39.36887], [-120.90534, 39.368], [-120.90688, 39.3674], [-120.90741, 39.36648], [-120.90745, 39.36586], [-120.90752, 39.36535], [-120.90969, 39.36383], [-120.90968, 39.3638], [-120.90786, 39.3638], [-120.90696, 39.36505], [-120.90611, 39.36615], [-120.90522, 39.36725], [-120.90456, 39.36718], [-120.90279, 39.36719], [-120.902, 39.36778], [-120.90104, 39.36858], [-120.90059, 39.36824], [-120.90053, 39.36818], [-120.90051, 39.36812], [-120.9005, 39.36812], [-120.90047, 39.3683], [-120.90093, 39.36867], [-120.90024, 39.36912], [-120.89967, 39.36964], [-120.89925, 39.36998], [-120.89803, 39.37078], [-120.89789, 39.37091], [-120.8978, 39.37103], [-120.89772, 39.37116], [-120.89764, 39.37141], [-120.8975, 39.37292], [-120.89747, 39.37312], [-120.89732, 39.37371], [-120.89734, 39.37445], [-120.8974, 39.37474], [-120.8975, 39.37501], [-120.8977, 39.37538], [-120.898, 39.37573], [-120.89824, 39.37595], [-120.89865, 39.37626], [-120.89914, 39.37669], [-120.89926, 39.37687], [-120.89933, 39.37699], [-120.89939, 39.37715], [-120.89943, 39.37736], [-120.89944, 39.37758], [-120.89941, 39.37799], [-120.89929, 39.37854], [-120.8992, 39.37883], [-120.89899, 39.37938], [-120.89886, 39.37962], [-120.89867, 39.3801], [-120.89652, 39.37754], [-120.89315, 39.37685], [-120.89311, 39.37757], [-120.89335, 39.3776], [-120.89335, 39.37779], [-120.89277, 39.37886], [-120.89108, 39.3806], [-120.89124, 39.38111], [-120.89097, 39.38197], [-120.89021, 39.3834], [-120.88884, 39.38501], [-120.88901, 39.38532], [-120.88766, 39.38555], [-120.88765, 39.38446], [-120.88981, 39.38084], [-120.8877, 39.3809], [-120.88765, 39.38083], [-120.88191, 39.38086], [-120.88227, 39.38029], [-120.88761, 39.38025], [-120.88764, 39.37755], [-120.88753, 39.37502], [-120.88638, 39.37334], [-120.88826, 39.37255], [-120.88853, 39.37292], [-120.89, 39.37294], [-120.88952, 39.37294], [-120.88951, 39.37296], [-120.88954, 39.37298], [-120.89419, 39.37293], [-120.89449, 39.37222], [-120.89482, 39.37225], [-120.89469, 39.37162], [-120.88831, 39.37012], [-120.89083, 39.36906], [-120.89604, 39.37039], [-120.8963, 39.37026], [-120.89775, 39.36947], [-120.89793, 39.36586], [-120.89823, 39.36587], [-120.8996, 39.36587], [-120.89951, 39.36571], [-120.89936, 39.36559], [-120.89924, 39.36553], [-120.89849, 39.36532], [-120.89812, 39.36524], [-120.89785, 39.36512], [-120.8982, 39.36511], [-120.89837, 39.36515], [-120.89914, 39.36537], [-120.89939, 39.36548], [-120.89956, 39.36558], [-120.89965, 39.36566], [-120.89974, 39.36577], [-120.8998, 39.36589], [-120.90134, 39.3659], [-120.9014, 39.36551], [-120.90261, 39.36488], [-120.90371, 39.36405], [-120.9049, 39.3639], [-120.90476, 39.36355], [-120.9061, 39.36319], [-120.90791, 39.36359], [-120.90809, 39.36252], [-120.90631, 39.36253], [-120.89707, 39.36248], [-120.89646, 39.36247], [-120.89645, 39.36248], [-120.89677, 39.36361], [-120.89485, 39.36396], [-120.89289, 39.36093], [-120.89375, 39.36115], [-120.89393, 39.36123], [-120.89402, 39.36131], [-120.8941, 39.36139], [-120.89418, 39.3616], [-120.89442, 39.36174], [-120.89456, 39.36176], [-120.89495, 39.36175], [-120.89508, 39.36178], [-120.8952, 39.36184], [-120.89533, 39.36194], [-120.89564, 39.36247], [-120.89603, 39.36331], [-120.89631, 39.36363], [-120.89631, 39.36361], [-120.89607, 39.36297], [-120.89583, 39.3625], [-120.89559, 39.36213], [-120.89554, 39.362], [-120.89544, 39.36186], [-120.89524, 39.36169], [-120.89509, 39.36164], [-120.89494, 39.36161], [-120.89449, 39.36161], [-120.89438, 39.36155], [-120.89421, 39.36128], [-120.89409, 39.36118], [-120.89384, 39.36105], [-120.89279, 39.36076], [-120.89206, 39.35965], [-120.89171, 39.35869], [-120.89153, 39.3578], [-120.89112, 39.35702], [-120.89115, 39.35672], [-120.89167, 39.35674], [-120.89197, 39.35739], [-120.89224, 39.35792], [-120.89296, 39.35788], [-120.89363, 39.35905], [-120.89352, 39.35912], [-120.89357, 39.35922], [-120.89755, 39.36067], [-120.89758, 39.36083], [-120.8978, 39.36071], [-120.89793, 39.35879], [-120.90411, 39.35892], [-120.90885, 39.35897], [-120.90812, 39.3625], [-120.90813, 39.36252], [-120.91717, 39.36253], [-120.92034, 39.36247], [-120.92033, 39.36212], [-120.92136, 39.3605], [-120.9224, 39.35918], [-120.92167, 39.35753], [-120.92218, 39.35531], [-120.92377, 39.35315], [-120.92416, 39.35183], [-120.92305, 39.35125], [-120.92461, 39.3498], [-120.92466, 39.34925], [-120.92581, 39.34884], [-120.92614, 39.3485], [-120.92675, 39.34772], [-120.92734, 39.34654], [-120.92849, 39.34552], [-120.92848, 39.34551], [-120.92704, 39.3454], [-120.92667, 39.34539], [-120.9269, 39.34172], [-120.92886, 39.34169], [-120.92901, 39.34084], [-120.93169, 39.34009], [-120.93188, 39.33981], [-120.93214, 39.3391], [-120.93169, 39.33853], [-120.93229, 39.33824], [-120.9329, 39.33903], [-120.93251, 39.34002], [-120.93215, 39.34053], [-120.92963, 39.3412], [-120.92958, 39.34166], [-120.93623, 39.34155], [-120.93603, 39.34518], [-120.92913, 39.34534], [-120.92912, 39.34536], [-120.92919, 39.34541], [-120.92891, 39.34637], [-120.92828, 39.34698], [-120.9277, 39.34814], [-120.92714, 39.34886], [-120.92678, 39.34886], [-120.92592, 39.3502], [-120.92648, 39.35039], [-120.93105, 39.35183], [-120.93739, 39.35547], [-120.94291, 39.35573], [-120.94541, 39.35609]], [[-120.9005, 39.36809], [-120.90051, 39.3681], [-120.90054, 39.36806], [-120.90058, 39.3679], [-120.90056, 39.36776], [-120.90055, 39.36776], [-120.9005, 39.36809]], [[-120.90401, 39.36954], [-120.90404, 39.36934], [-120.90402, 39.36933], [-120.9036, 39.36953], [-120.90401, 39.36954]], [[-120.91584, 39.36698], [-120.91676, 39.36677], [-120.91703, 39.36388], [-120.91105, 39.36383], [-120.91101, 39.36435], [-120.91132, 39.36455], [-120.91088, 39.3649], [-120.90737, 39.36708], [-120.90733, 39.36757], [-120.90811, 39.3676], [-120.90955, 39.36784], [-120.91078, 39.36831], [-120.91126, 39.36848], [-120.91193, 39.36863], [-120.91303, 39.36884], [-120.91483, 39.36784], [-120.91584, 39.36698]], [[-120.92251, 39.36509], [-120.92252, 39.36511], [-120.92267, 39.36503], [-120.92265, 39.36502], [-120.92251, 39.36509]], [[-120.93379, 39.36473], [-120.93378, 39.36472], [-120.9334, 39.36494], [-120.93272, 39.36494], [-120.93252, 39.36489], [-120.93241, 39.36485], [-120.93218, 39.36464], [-120.93205, 39.36441], [-120.93197, 39.3642], [-120.93186, 39.36412], [-120.93133, 39.36384], [-120.93109, 39.36368], [-120.93057, 39.36354], [-120.92991, 39.36346], [-120.92972, 39.3634], [-120.92951, 39.36339], [-120.92932, 39.36341], [-120.92919, 39.36346], [-120.929, 39.36355], [-120.92878, 39.36371], [-120.92856, 39.3639], [-120.92847, 39.36402], [-120.92834, 39.36422], [-120.92813, 39.36463], [-120.92806, 39.36482], [-120.92799, 39.36506], [-120.92795, 39.36536], [-120.92795, 39.36576], [-120.92797, 39.36602], [-120.92803, 39.36627], [-120.92797, 39.36647], [-120.92786, 39.36654], [-120.9273, 39.36663], [-120.92713, 39.36662], [-120.92636, 39.36648], [-120.92598, 39.36651], [-120.92597, 39.36652], [-120.927, 39.36673], [-120.92727, 39.36677], [-120.9275, 39.36676], [-120.92768, 39.36672], [-120.92785, 39.36671], [-120.92797, 39.36668], [-120.92811, 39.36661], [-120.9282, 39.36645], [-120.92809, 39.36586], [-120.92809, 39.36537], [-120.92815, 39.36505], [-120.92822, 39.36481], [-120.92842, 39.36438], [-120.92861, 39.36408], [-120.92881, 39.36388], [-120.92895, 39.36377], [-120.92927, 39.36357], [-120.9295, 39.36353], [-120.92966, 39.36353], [-120.93037, 39.36366], [-120.93063, 39.36369], [-120.931, 39.36379], [-120.93129, 39.36397], [-120.93168, 39.36416], [-120.93181, 39.36425], [-120.93192, 39.36461], [-120.93214, 39.36479], [-120.93227, 39.36492], [-120.93243, 39.365], [-120.93265, 39.36505], [-120.93348, 39.36507], [-120.93379, 39.36473]]], [[[-120.90239, 39.3687], [-120.90238, 39.3689], [-120.90238, 39.3689], [-120.90226, 39.3687], [-120.90239, 39.3687]]], [[[-120.93517, 39.37491], [-120.9351, 39.37952], [-120.93511, 39.37993], [-120.93508, 39.38007], [-120.93145, 39.37993], [-120.93161, 39.37967], [-120.93208, 39.37858], [-120.93236, 39.37802], [-120.93255, 39.37769], [-120.93286, 39.37723], [-120.93304, 39.377], [-120.93329, 39.37673], [-120.93421, 39.37594], [-120.93458, 39.37557], [-120.93499, 39.37508], [-120.93517, 39.37491]]], [[[-120.94528, 39.36887], [-120.94509, 39.37285], [-120.9361, 39.37269], [-120.93605, 39.37264], [-120.93613, 39.3724], [-120.93719, 39.37027], [-120.93737, 39.36972], [-120.93751, 39.36935], [-120.93765, 39.36854], [-120.93771, 39.36831], [-120.93778, 39.36813], [-120.93793, 39.36779], [-120.93807, 39.36756], [-120.93827, 39.3673], [-120.93844, 39.36711], [-120.93864, 39.36694], [-120.93922, 39.36636], [-120.93931, 39.36625], [-120.93982, 39.36576], [-120.93997, 39.36557], [-120.94017, 39.36521], [-120.94025, 39.36494], [-120.94028, 39.36476], [-120.94028, 39.36446], [-120.94025, 39.36426], [-120.94019, 39.36402], [-120.9399, 39.36329], [-120.9399, 39.36314], [-120.94, 39.3629], [-120.94011, 39.36274], [-120.94019, 39.36265], [-120.9403, 39.36257], [-120.94049, 39.36245], [-120.94085, 39.36231], [-120.94099, 39.36223], [-120.94117, 39.36212], [-120.94131, 39.36199], [-120.94146, 39.36176], [-120.94162, 39.36131], [-120.94168, 39.36116], [-120.94179, 39.36096], [-120.94196, 39.3607], [-120.94239, 39.36019], [-120.94387, 39.36159], [-120.94193, 39.36403], [-120.94067, 39.36858], [-120.94239, 39.3688], [-120.94528, 39.36887]]]]} Open Access 1 Malakoff Diggins State Historic Park http://www.parks.ca.gov/default.asp?page_id=494 1613 204 California Department of Parks and Recreation 47 State 5 State Agency 5 http://www.parks.ca.gov/ California Department of Parks and Recreation 9 3165.977 Malakoff Diggins SHP 1965

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);