superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
33 rows where MNG_AGENCY = 128 and MNG_AG_TYP = 5
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7809 | 7809 | 7808 | {"type": "Polygon", "coordinates": [[[-123.83901, 40.46367], [-123.839, 40.46751], [-123.83762, 40.46759], [-123.83761, 40.46748], [-123.83744, 40.46699], [-123.83691, 40.46742], [-123.83606, 40.46793], [-123.83527, 40.46801], [-123.83421, 40.46791], [-123.83495, 40.46784], [-123.83542, 40.46767], [-123.83587, 40.46725], [-123.83707, 40.46639], [-123.83754, 40.46561], [-123.8379, 40.46507], [-123.83813, 40.46474], [-123.83856, 40.46406], [-123.83884, 40.46367], [-123.83901, 40.46367]]]} | Open Access 1 | Other State 4 | 23263 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 14.858 | Other State 4 | |||
7810 | 7810 | 7809 | {"type": "Polygon", "coordinates": [[[-123.78183, 40.4786], [-123.78172, 40.47967], [-123.78083, 40.47987], [-123.78082, 40.47937], [-123.78064, 40.47893], [-123.78183, 40.4786]]]} | Open Access 1 | Other State 43 | 23264 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 2.359 | Other State 43 | |||
7811 | 7811 | 7810 | {"type": "Polygon", "coordinates": [[[-123.84468, 40.46319], [-123.84303, 40.46319], [-123.84302, 40.4623], [-123.8433, 40.46219], [-123.84379, 40.4621], [-123.84428, 40.46233], [-123.8444, 40.46257], [-123.84445, 40.46277], [-123.84468, 40.46319]]]} | Open Access 1 | Other State 5 | 23265 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 3.303 | Other State 5 | |||
9180 | 9180 | 9179 | {"type": "Polygon", "coordinates": [[[-116.90615, 32.72851], [-116.90484, 32.7283], [-116.90399, 32.72803], [-116.90394, 32.72518], [-116.90608, 32.72533], [-116.90615, 32.72851]]]} | Open Access 1 | San Diego National Wildlife Refuge | 24858 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 16.777 | San Diego NWR | 1996 | ||
9976 | 9976 | 9975 | {"type": "Polygon", "coordinates": [[[-122.0502, 36.9496], [-122.04978, 36.94953], [-122.0495, 36.9493], [-122.04942, 36.94927], [-122.04942, 36.94924], [-122.04951, 36.94925], [-122.04961, 36.94935], [-122.04967, 36.94936], [-122.0498, 36.94944], [-122.04993, 36.94948], [-122.05019, 36.9495], [-122.0502, 36.9496]]]} | Open Access 1 | Stockton Avenue Beach | 25857 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 0.139 | Stockton Avenue Beach | |||
9986 | 9986 | 9985 | {"type": "Polygon", "coordinates": [[[-121.50125, 38.31704], [-121.50005, 38.31773], [-121.49878, 38.31973], [-121.49852, 38.31959], [-121.49847, 38.31958], [-121.4946, 38.31753], [-121.49279, 38.31453], [-121.50082, 38.31445], [-121.50125, 38.31704]]]} | No Public Access 3 | Stone Lakes | 25871 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 68.283 | Stone Lakes | |||
10503 | 10503 | 10502 | {"type": "Polygon", "coordinates": [[[-120.46492, 37.66834], [-120.46421, 37.66774], [-120.4619, 37.66728], [-120.4618, 37.66725], [-120.46168, 37.66715], [-120.46163, 37.66704], [-120.46164, 37.66696], [-120.4617, 37.66675], [-120.46266, 37.66675], [-120.4649, 37.66747], [-120.46492, 37.66834]]]} | Open Access 1 | Tuolumne River Restoration Center | 26580 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 4.72 | Tuolumne River Restoration Ctr. | |||
10541 | 10541 | 10540 | {"type": "MultiPolygon", "coordinates": [[[[-121.74566, 38.53992], [-121.74541, 38.53997], [-121.74542, 38.54005], [-121.74505, 38.54011], [-121.74504, 38.54016], [-121.74491, 38.54018], [-121.74475, 38.54019], [-121.74471, 38.54016], [-121.7441, 38.54027], [-121.74436, 38.54119], [-121.74389, 38.54128], [-121.7436, 38.54032], [-121.7432, 38.54035], [-121.74314, 38.5404], [-121.7431, 38.54037], [-121.74305, 38.54035], [-121.7429, 38.54036], [-121.74287, 38.54034], [-121.74265, 38.54038], [-121.74263, 38.54041], [-121.74247, 38.54044], [-121.74244, 38.54042], [-121.74206, 38.54049], [-121.74205, 38.54045], [-121.74202, 38.54044], [-121.74156, 38.54052], [-121.74152, 38.54056], [-121.7415, 38.54055], [-121.74146, 38.54039], [-121.74141, 38.54039], [-121.74142, 38.54034], [-121.7411, 38.54017], [-121.74105, 38.5402], [-121.741, 38.54019], [-121.74008, 38.54124], [-121.74043, 38.54146], [-121.74031, 38.54157], [-121.73991, 38.54136], [-121.74133, 38.53974], [-121.7416, 38.53979], [-121.74288, 38.5399], [-121.74316, 38.53991], [-121.74366, 38.53988], [-121.74406, 38.53982], [-121.74442, 38.53972], [-121.74472, 38.53966], [-121.74541, 38.53939], [-121.74548, 38.53941], [-121.74553, 38.53948], [-121.74566, 38.53992]]], [[[-121.74882, 38.53621], [-121.74869, 38.53634], [-121.74866, 38.53644], [-121.74867, 38.53653], [-121.74875, 38.53666], [-121.74863, 38.53678], [-121.74858, 38.53688], [-121.74861, 38.53692], [-121.74863, 38.537], [-121.74861, 38.53702], [-121.74868, 38.53726], [-121.74871, 38.53727], [-121.74876, 38.53747], [-121.74873, 38.53753], [-121.74865, 38.53759], [-121.74858, 38.53778], [-121.74852, 38.53786], [-121.74843, 38.53795], [-121.74832, 38.53801], [-121.74825, 38.53808], [-121.74821, 38.53817], [-121.74821, 38.5383], [-121.7482, 38.53834], [-121.74815, 38.53836], [-121.74767, 38.53844], [-121.74759, 38.53848], [-121.74753, 38.53853], [-121.74708, 38.53906], [-121.74679, 38.5392], [-121.74666, 38.53929], [-121.74647, 38.53943], [-121.74631, 38.53959], [-121.74572, 38.53982], [-121.7457, 38.53972], [-121.7457, 38.5396], [-121.74562, 38.53932], [-121.74563, 38.53928], [-121.74604, 38.53906], [-121.74633, 38.53885], [-121.74671, 38.53853], [-121.74692, 38.53829], [-121.74702, 38.53815], [-121.74712, 38.53796], [-121.74737, 38.53726], [-121.74751, 38.53691], [-121.74768, 38.53659], [-121.74781, 38.53641], [-121.74857, 38.53559], [-121.74862, 38.53559], [-121.74866, 38.53561], [-121.74882, 38.53617], [-121.74882, 38.53621]]], [[[-121.75202, 38.53393], [-121.75201, 38.53436], [-121.75196, 38.53444], [-121.75185, 38.53451], [-121.75131, 38.53473], [-121.75112, 38.53479], [-121.75084, 38.53493], [-121.75022, 38.53518], [-121.75013, 38.53526], [-121.74995, 38.53532], [-121.74969, 38.53547], [-121.7494, 38.53567], [-121.74923, 38.53574], [-121.74914, 38.53576], [-121.74908, 38.53576], [-121.74888, 38.53571], [-121.74878, 38.53534], [-121.74898, 38.53518], [-121.74927, 38.53499], [-121.74966, 38.53479], [-121.75141, 38.5341], [-121.7519, 38.53389], [-121.75198, 38.53389], [-121.75202, 38.53393]]], [[[-121.76795, 38.53042], [-121.76793, 38.5305], [-121.76789, 38.53055], [-121.7678, 38.53061], [-121.76774, 38.53063], [-121.76757, 38.53062], [-121.76744, 38.53057], [-121.76731, 38.53049], [-121.76658, 38.52993], [-121.76632, 38.52976], [-121.76625, 38.52978], [-121.76621, 38.52982], [-121.76616, 38.52998], [-121.76616, 38.53006], [-121.76251, 38.53003], [-121.76236, 38.53007], [-121.76227, 38.53012], [-121.76225, 38.53009], [-121.76185, 38.5301], [-121.76166, 38.53014], [-121.7615, 38.53025], [-121.76137, 38.53047], [-121.76131, 38.53054], [-121.76114, 38.53069], [-121.76105, 38.53075], [-121.76098, 38.53077], [-121.76092, 38.53078], [-121.76071, 38.53077], [-121.76058, 38.53075], [-121.76017, 38.53061], [-121.75999, 38.53062], [-121.75994, 38.5307], [-121.75992, 38.5308], [-121.75992, 38.53089], [-121.76004, 38.53109], [-121.7601, 38.53115], [-121.76012, 38.53121], [-121.76014, 38.53132], [-121.76012, 38.53144], [-121.75999, 38.53156], [-121.75987, 38.53159], [-121.7596, 38.53162], [-121.7592, 38.53164], [-121.75896, 38.53168], [-121.75877, 38.53175], [-121.75842, 38.53194], [-121.7581, 38.53208], [-121.75792, 38.53211], [-121.75753, 38.53213], [-121.75705, 38.53223], [-121.75694, 38.53227], [-121.75671, 38.53239], [-121.75647, 38.53263], [-121.75573, 38.53295], [-121.75548, 38.53295], [-121.75534, 38.53297], [-121.75451, 38.53315], [-121.7533, 38.53375], [-121.75329, 38.53389], [-121.75213, 38.53439], [-121.7521, 38.53435], [-121.75212, 38.53399], [-121.75217, 38.53395], [-121.75218, 38.53373], [-121.75214, 38.53356], [-121.75195, 38.53325], [-121.75195, 38.53321], [-121.752, 38.53317], [-121.75204, 38.53315], [-121.75269, 38.53302], [-121.7533, 38.53282], [-121.75357, 38.53268], [-121.75376, 38.53254], [-121.754, 38.53242], [-121.7558, 38.53172], [-121.75611, 38.53158], [-121.75647, 38.53138], [-121.75664, 38.53125], [-121.75681, 38.53109], [-121.7569, 38.53109], [-121.75694, 38.53085], [-121.75712, 38.53028], [-121.75716, 38.52995], [-121.75732, 38.5297], [-121.75751, 38.52963], [-121.75769, 38.53025], [-121.75799, 38.53073], [-121.75807, 38.53081], [-121.75852, 38.53057], [-121.7589, 38.53035], [-121.75942, 38.52992], [-121.75997, 38.52952], [-121.76071, 38.5289], [-121.76099, 38.52865], [-121.76185, 38.52781], [-121.76179, 38.5277], [-121.7623, 38.52741], [-121.76232, 38.52733], [-121.76315, 38.52685], [-121.76325, 38.52686], [-121.76336, 38.52703], [-121.76336, 38.52708], [-121.76422, 38.52748], [-121.76419, 38.5275], [-121.76418, 38.52755], [-121.7644, 38.52764], [-121.7646, 38.52775], [-121.76486, 38.52794], [-121.76739, 38.52957], [-121.76766, 38.52985], [-121.76785, 38.53018], [-121.76795, 38.53042]]]]} | Open Access 1 | UCD Arboretum | 26641 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 83.519 | UCD Arboretum | |||
12104 | 12104 | 12103 | {"type": "Polygon", "coordinates": [[[-118.65109, 34.03761], [-118.65102, 34.03789], [-118.65008, 34.03771], [-118.64961, 34.03764], [-118.64922, 34.03765], [-118.64889, 34.0377], [-118.64882, 34.03758], [-118.64861, 34.03759], [-118.64839, 34.0377], [-118.64783, 34.03813], [-118.64748, 34.03823], [-118.64702, 34.03832], [-118.64694, 34.0382], [-118.64591, 34.03819], [-118.64439, 34.03805], [-118.64366, 34.03796], [-118.64298, 34.03782], [-118.64224, 34.03772], [-118.63951, 34.03714], [-118.6382, 34.03681], [-118.63828, 34.0365], [-118.63964, 34.03684], [-118.64039, 34.03708], [-118.64171, 34.03736], [-118.64261, 34.03748], [-118.64325, 34.03763], [-118.64555, 34.03791], [-118.64655, 34.03796], [-118.64744, 34.03791], [-118.64803, 34.03772], [-118.64845, 34.03742], [-118.64906, 34.0373], [-118.64975, 34.03736], [-118.65109, 34.03761]]]} | Open Access 1 | La Costa Beach | 29045 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 9.124 | La Costa Beach | |||
13249 | 13249 | 13248 | {"type": "Polygon", "coordinates": [[[-124.11238, 40.99977], [-124.11173, 41.00363], [-124.1111, 41.00601], [-124.11088, 41.00673], [-124.10992, 41.00671], [-124.11008, 41.00583], [-124.11159, 41.00045], [-124.11204, 40.99978], [-124.11238, 40.99977]]]} | Unknown Access 4 | Clam Beach Ponds | 30554 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 14.52 | Clam Beach Ponds | |||
14266 | 14266 | 14265 | {"type": "Polygon", "coordinates": [[[-121.47627, 38.28439], [-121.47626, 38.29098], [-121.47626, 38.29098], [-121.47106, 38.28433], [-121.47627, 38.28439]]]} | Restricted Access 2 | Stone Lakes | 25872 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 41.202 | Stone Lakes | |||
14284 | 14284 | 14283 | {"type": "MultiPolygon", "coordinates": [[[[-120.34826, 34.69117], [-120.34814, 34.69379], [-120.34386, 34.69377], [-120.34383, 34.69], [-120.34826, 34.69117]]], [[[-120.43434, 35.8989], [-120.4339, 35.89938], [-120.433, 35.89938], [-120.43299, 35.89909], [-120.43279, 35.89769], [-120.4328, 35.89746], [-120.43285, 35.89727], [-120.43291, 35.89727], [-120.43341, 35.89756], [-120.43422, 35.89848], [-120.43434, 35.8989]]], [[[-121.44979, 35.87733], [-121.44731, 35.87732], [-121.4472, 35.87724], [-121.44693, 35.87699], [-121.44647, 35.87652], [-121.44576, 35.87561], [-121.44568, 35.87182], [-121.44593, 35.87189], [-121.44618, 35.87189], [-121.44641, 35.87183], [-121.44656, 35.87186], [-121.447, 35.87216], [-121.447, 35.87235], [-121.44694, 35.8725], [-121.44675, 35.87258], [-121.44665, 35.87274], [-121.44665, 35.87297], [-121.44685, 35.87305], [-121.44688, 35.87323], [-121.44688, 35.87356], [-121.44709, 35.87378], [-121.44723, 35.87386], [-121.44745, 35.87416], [-121.44748, 35.87437], [-121.44749, 35.87455], [-121.44772, 35.87489], [-121.44778, 35.87492], [-121.44805, 35.8752], [-121.44825, 35.87555], [-121.44833, 35.87614], [-121.44853, 35.87649], [-121.44887, 35.87663], [-121.44941, 35.87701], [-121.44966, 35.87725], [-121.44979, 35.87733]]], [[[-121.45347, 35.88079], [-121.45045, 35.88079], [-121.45039, 35.87782], [-121.45083, 35.87812], [-121.45128, 35.87836], [-121.45184, 35.87897], [-121.45199, 35.87926], [-121.45214, 35.87963], [-121.45241, 35.88005], [-121.45259, 35.88039], [-121.45312, 35.88067], [-121.45347, 35.88079]]], [[[-121.68777, 36.44521], [-121.68564, 36.44803], [-121.68544, 36.44783], [-121.68401, 36.44774], [-121.68517, 36.44574], [-121.68502, 36.44565], [-121.68518, 36.44552], [-121.68529, 36.44539], [-121.68537, 36.44527], [-121.68545, 36.44508], [-121.6855, 36.44499], [-121.68558, 36.44491], [-121.68569, 36.44484], [-121.68595, 36.44475], [-121.68612, 36.44467], [-121.68628, 36.44454], [-121.68641, 36.44439], [-121.68648, 36.44425], [-121.68652, 36.44411], [-121.68653, 36.44396], [-121.68651, 36.44383], [-121.68652, 36.44381], [-121.68655, 36.4438], [-121.68658, 36.44382], [-121.68665, 36.44396], [-121.68679, 36.44411], [-121.68691, 36.4442], [-121.68711, 36.44428], [-121.68715, 36.44432], [-121.68717, 36.44437], [-121.68713, 36.44456], [-121.68714, 36.4447], [-121.68719, 36.44484], [-121.68728, 36.44497], [-121.6874, 36.44507], [-121.68751, 36.44513], [-121.68777, 36.44521]]], [[[-121.90442, 36.37228], [-121.90409, 36.37302], [-121.90285, 36.37256], [-121.9025, 36.37238], [-121.90224, 36.3722], [-121.90207, 36.37203], [-121.90198, 36.37191], [-121.90184, 36.37165], [-121.90175, 36.37141], [-121.90168, 36.37116], [-121.90166, 36.37091], [-121.90167, 36.37059], [-121.90307, 36.3706], [-121.90305, 36.37087], [-121.90312, 36.37125], [-121.90317, 36.3714], [-121.90343, 36.37175], [-121.9036, 36.37192], [-121.90369, 36.37199], [-121.90388, 36.37208], [-121.90399, 36.37216], [-121.90408, 36.3722], [-121.90442, 36.37228]]], [[[-123.79434, 40.47335], [-123.79344, 40.47461], [-123.79172, 40.47464], [-123.7917, 40.47345], [-123.79184, 40.4734], [-123.7919, 40.47397], [-123.7929, 40.47349], [-123.7938, 40.47316], [-123.79434, 40.47335]]], [[[-123.80067, 40.46825], [-123.80044, 40.46859], [-123.80036, 40.4688], [-123.80034, 40.46903], [-123.80012, 40.46907], [-123.80066, 40.46963], [-123.79996, 40.46972], [-123.79991, 40.46966], [-123.79964, 40.46971], [-123.79961, 40.46959], [-123.79997, 40.46953], [-123.8001, 40.46908], [-123.80008, 40.46906], [-123.79735, 40.46919], [-123.79647, 40.46944], [-123.79653, 40.46852], [-123.79661, 40.46843], [-123.79718, 40.46812], [-123.79754, 40.46817], [-123.79789, 40.46815], [-123.7983, 40.46803], [-123.7993, 40.46811], [-123.79937, 40.46813], [-123.79941, 40.46807], [-123.79936, 40.46805], [-123.79938, 40.46802], [-123.80067, 40.46825]]], [[[-124.09997, 41.25922], [-124.0996, 41.26108], [-124.09945, 41.26144], [-124.09924, 41.26217], [-124.09926, 41.26243], [-124.09904, 41.26333], [-124.09904, 41.26429], [-124.09931, 41.26516], [-124.09974, 41.26573], [-124.09975, 41.2659], [-124.0997, 41.2661], [-124.09935, 41.26665], [-124.09928, 41.26672], [-124.09862, 41.26813], [-124.09732, 41.27163], [-124.09699, 41.27279], [-124.09665, 41.27363], [-124.09622, 41.27454], [-124.09616, 41.27463], [-124.09565, 41.27589], [-124.09539, 41.27717], [-124.09365, 41.27719], [-124.09391, 41.2761], [-124.09413, 41.27503], [-124.09435, 41.27356], [-124.09491, 41.27158], [-124.09529, 41.27031], [-124.09573, 41.26915], [-124.09606, 41.2682], [-124.09669, 41.26687], [-124.09668, 41.26686], [-124.09536, 41.26684], [-124.09563, 41.26017], [-124.09518, 41.25926], [-124.09688, 41.25931], [-124.09997, 41.25922]]], [[[-124.19517, 40.77569], [-124.19492, 40.77704], [-124.19447, 40.77695], [-124.19466, 40.77632], [-124.19483, 40.77561], [-124.19517, 40.77569]]], [[[-124.26888, 40.62856], [-124.26886, 40.62923], [-124.26704, 40.62852], [-124.26704, 40.62852], [-124.26888, 40.62856]]]]} | Open Access 1 | Unnamed site - Other State | 28654 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 241.052 | ||||
15489 | 15489 | 15488 | {"type": "Polygon", "coordinates": [[[-116.81544, 33.65099], [-116.80691, 33.65114], [-116.80684, 33.64209], [-116.8047, 33.64211], [-116.80466, 33.64032], [-116.8025, 33.64032], [-116.80248, 33.63844], [-116.79816, 33.63837], [-116.79814, 33.63666], [-116.80466, 33.63671], [-116.80469, 33.63843], [-116.8068, 33.63845], [-116.80684, 33.64022], [-116.81105, 33.64011], [-116.81111, 33.64387], [-116.81536, 33.64383], [-116.81544, 33.65099]]]} | Open Access 1 | California State Lands Commission | 16727 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 255.155 | SLC |
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]);