units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
43 rows where MNG_AGENCY = 128 and MNG_AG_TYP = 5 sorted by map
This data as json, copyable, CSV (advanced)
Suggested facets: COUNTY, YR_EST, GAP_STS
DES_TP >30
ACCESS_TYP 4
MNG_AG_TYP 1
- State Agency · 43 ✖
MNG_AGENCY 1
- Other State · 43 ✖
LAYER 1 ✖
- Other State 43
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3108 | 3108 | 3107 | {"type": "MultiPolygon", "coordinates": [[[[-121.46234, 38.2686], [-121.46231, 38.26876], [-121.46161, 38.26911], [-121.46002, 38.26922], [-121.45923, 38.26938], [-121.45839, 38.2697], [-121.45775, 38.26965], [-121.45753, 38.26953], [-121.45774, 38.2673], [-121.45781, 38.26714], [-121.4579, 38.2664], [-121.45801, 38.26606], [-121.4583, 38.26581], [-121.45862, 38.26576], [-121.45932, 38.26588], [-121.46083, 38.2659], [-121.46118, 38.26624], [-121.46112, 38.26713], [-121.46132, 38.26782], [-121.46167, 38.26823], [-121.46211, 38.2684], [-121.46234, 38.2686]]], [[[-121.68459, 38.14478], [-121.68456, 38.14487], [-121.68445, 38.14505], [-121.68418, 38.14541], [-121.68404, 38.14611], [-121.68393, 38.14638], [-121.68387, 38.14656], [-121.68386, 38.14674], [-121.68389, 38.14684], [-121.6838, 38.14733], [-121.68366, 38.14777], [-121.68363, 38.148], [-121.68355, 38.14839], [-121.68327, 38.14912], [-121.68318, 38.14929], [-121.68312, 38.1493], [-121.68345, 38.14644], [-121.68406, 38.14476], [-121.68459, 38.14478]]]]} | Restricted Access 2 | 25288 | Cosumnes River Preserve | 17678 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Sacramento 41 | 35.364 | Cosumnes River Preserve | 0 | State Conservation Area 8 | 2 | ||
11278 | 11278 | 11277 | {"type": "MultiPolygon", "coordinates": [[[[-121.47063, 38.2699], [-121.4706, 38.27064], [-121.45934, 38.27057], [-121.45744, 38.27053], [-121.45753, 38.26953], [-121.45775, 38.26965], [-121.45839, 38.2697], [-121.45923, 38.26938], [-121.46002, 38.26922], [-121.46161, 38.26911], [-121.46231, 38.26876], [-121.46234, 38.2686], [-121.46211, 38.2684], [-121.46167, 38.26823], [-121.46132, 38.26782], [-121.46112, 38.26713], [-121.46118, 38.26625], [-121.46083, 38.2659], [-121.45932, 38.26588], [-121.45862, 38.26576], [-121.45831, 38.26581], [-121.45801, 38.26607], [-121.4579, 38.2664], [-121.45781, 38.26714], [-121.45774, 38.2673], [-121.45767, 38.2673], [-121.45787, 38.26584], [-121.45678, 38.26697], [-121.4556, 38.26691], [-121.45491, 38.26671], [-121.45329, 38.26679], [-121.45334, 38.26641], [-121.45342, 38.2664], [-121.45386, 38.26294], [-121.45446, 38.25887], [-121.45447, 38.25847], [-121.45468, 38.2569], [-121.45524, 38.25732], [-121.45555, 38.2575], [-121.45556, 38.25748], [-121.45578, 38.25759], [-121.45787, 38.25723], [-121.45864, 38.25732], [-121.45909, 38.25763], [-121.45934, 38.25812], [-121.45982, 38.25857], [-121.46072, 38.25902], [-121.46149, 38.25921], [-121.46136, 38.26017], [-121.46129, 38.2603], [-121.46105, 38.26172], [-121.46263, 38.26384], [-121.46222, 38.26635], [-121.46232, 38.26641], [-121.46232, 38.26645], [-121.46266, 38.26659], [-121.46431, 38.26748], [-121.46447, 38.26828], [-121.46365, 38.26984], [-121.47063, 38.2699]]], [[[-121.50963, 38.2458], [-121.50927, 38.24638], [-121.50921, 38.24636], [-121.50864, 38.24741], [-121.50384, 38.24617], [-121.5037, 38.24612], [-121.50353, 38.24609], [-121.50271, 38.24588], [-121.50332, 38.25019], [-121.50249, 38.25022], [-121.50189, 38.25041], [-121.50176, 38.25041], [-121.50146, 38.25033], [-121.50137, 38.25027], [-121.50135, 38.2503], [-121.5013, 38.25028], [-121.50021, 38.25049], [-121.50021, 38.25051], [-121.5007, 38.25092], [-121.50104, 38.25101], [-121.50058, 38.25107], [-121.50044, 38.25101], [-121.50033, 38.25084], [-121.50004, 38.2507], [-121.49992, 38.25044], [-121.49966, 38.25014], [-121.49947, 38.24987], [-121.49933, 38.24952], [-121.49916, 38.24938], [-121.49894, 38.24893], [-121.4988, 38.24871], [-121.49867, 38.24842], [-121.49845, 38.24755], [-121.49846, 38.24721], [-121.4984, 38.24683], [-121.49827, 38.24643], [-121.49813, 38.2461], [-121.49781, 38.24554], [-121.49768, 38.24512], [-121.49757, 38.24494], [-121.49745, 38.24449], [-121.49737, 38.24423], [-121.49733, 38.24387], [-121.49726, 38.24348], [-121.49726, 38.24268], [-121.49731, 38.24198], [-121.49738, 38.24147], [-121.49733, 38.24066], [-121.49736, 38.24046], [-121.49739, 38.2404], [-121.49744, 38.24035], [-121.49751, 38.24033], [-121.49763, 38.24034], [-121.49767, 38.2403], [-121.49771, 38.24021], [-121.49806, 38.24029], [-121.498, 38.24057], [-121.49802, 38.2411], [-121.49806, 38.24127], [-121.49818, 38.24151], [-121.49846, 38.24191], [-121.49871, 38.24222], [-121.49906, 38.24253], [-121.49937, 38.24273], [-121.49966, 38.24285], [-121.50023, 38.24302], [-121.5084, 38.24517], [-121.50877, 38.24532], [-121.50886, 38.24538], [-121.50905, 38.24565], [-121.50963, 38.2458]]]]} | Restricted Access 2 | 21796 | Cosumnes River Preserve | 17678 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Sacramento 41 | 329.27 | Cosumnes River Preserve | 0 | State Conservation Area 8 | 2 | ||
11478 | 11478 | 11477 | {"type": "MultiPolygon", "coordinates": [[[[-121.74436, 38.54119], [-121.74389, 38.54128], [-121.74362, 38.54036], [-121.7441, 38.54028], [-121.74436, 38.54119]]], [[[-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.53069], [-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.75452, 38.53315], [-121.7533, 38.53376], [-121.75329, 38.53389], [-121.75213, 38.53439], [-121.7521, 38.53435], [-121.75209, 38.53428], [-121.75211, 38.53427], [-121.75211, 38.53418], [-121.75288, 38.53376], [-121.75326, 38.53359], [-121.75427, 38.53319], [-121.75517, 38.53288], [-121.75789, 38.53184], [-121.75833, 38.53175], [-121.75914, 38.5315], [-121.75932, 38.53139], [-121.75989, 38.5301], [-121.76036, 38.52957], [-121.76128, 38.52867], [-121.76172, 38.52831], [-121.76234, 38.52788], [-121.76252, 38.52779], [-121.76281, 38.52759], [-121.76323, 38.52747], [-121.76343, 38.52748], [-121.7638, 38.52762], [-121.76414, 38.52784], [-121.76455, 38.52812], [-121.76494, 38.52835], [-121.76542, 38.52868], [-121.76581, 38.52892], [-121.76603, 38.52909], [-121.76637, 38.52927], [-121.76675, 38.52956], [-121.76703, 38.5297], [-121.7679, 38.53037], [-121.76794, 38.53046], [-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]]]]} | Open Access 1 | 23100 | UCD Arboretum | 26641 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Yolo 33 | 35.058 | UCD Arboretum | None 1018 | ||||
10955 | 10955 | 10954 | {"type": "MultiPolygon", "coordinates": [[[[-121.76795, 38.53042], [-121.76794, 38.53045], [-121.76789, 38.53037], [-121.76703, 38.5297], [-121.76675, 38.52956], [-121.76637, 38.52927], [-121.76603, 38.52909], [-121.76581, 38.52892], [-121.76542, 38.52868], [-121.76494, 38.52835], [-121.76455, 38.52812], [-121.76414, 38.52784], [-121.7638, 38.52762], [-121.76343, 38.52748], [-121.76322, 38.52747], [-121.76281, 38.52759], [-121.76252, 38.52779], [-121.76234, 38.52788], [-121.76172, 38.52831], [-121.76128, 38.52867], [-121.76036, 38.52957], [-121.75989, 38.5301], [-121.75932, 38.53139], [-121.75915, 38.5315], [-121.75833, 38.53175], [-121.75789, 38.53184], [-121.75517, 38.53288], [-121.75427, 38.53319], [-121.75326, 38.53359], [-121.75288, 38.53376], [-121.75211, 38.53418], [-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.75268, 38.53303], [-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.5311], [-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.75808, 38.53082], [-121.75852, 38.53057], [-121.7589, 38.53036], [-121.75942, 38.52992], [-121.75997, 38.52952], [-121.76071, 38.5289], [-121.76099, 38.52865], [-121.76186, 38.5278], [-121.76179, 38.5277], [-121.7623, 38.5274], [-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]]], [[[-121.74927, 38.535], [-121.74966, 38.53479], [-121.75141, 38.5341], [-121.7519, 38.53389], [-121.75198, 38.53389], [-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.75021, 38.53519], [-121.75013, 38.53526], [-121.74996, 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.535]]], [[[-121.74878, 38.53601], [-121.74882, 38.53617], [-121.74882, 38.53621], [-121.74869, 38.53634], [-121.74865, 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.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.53818], [-121.74822, 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.74736, 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.74878, 38.53601]]], [[[-121.74566, 38.53992], [-121.74541, 38.53997], [-121.74542, 38.54005], [-121.74504, 38.54012], [-121.74504, 38.54016], [-121.74491, 38.54018], [-121.74475, 38.54019], [-121.74471, 38.54016], [-121.74362, 38.54036], [-121.7436, 38.54032], [-121.7432, 38.54036], [-121.74314, 38.5404], [-121.7431, 38.54037], [-121.74305, 38.54034], [-121.7429, 38.54036], [-121.74288, 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.74143, 38.54035], [-121.7411, 38.54017], [-121.74105, 38.5402], [-121.741, 38.54018], [-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]]]]} | Open Access 1 | 21007 | UCD Arboretum | 26641 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Solano 26 | 48.421 | UCD Arboretum | 0 | None 957 | |||
10344 | 10344 | 10343 | {"type": "MultiPolygon", "coordinates": [[[[-122.01191, 36.97056], [-122.01184, 36.97079], [-122.01121, 36.97116], [-122.0112, 36.97122], [-122.01103, 36.97109], [-122.01178, 36.97054], [-122.0118, 36.97027], [-122.01191, 36.96996], [-122.01196, 36.97022], [-122.01191, 36.97056]]], [[[-121.99494, 36.98782], [-121.99458, 36.98781], [-121.99399, 36.98777], [-121.99412, 36.98737], [-121.99417, 36.98738], [-121.99467, 36.98769], [-121.99482, 36.98772], [-121.99494, 36.98782]]], [[[-121.99677, 36.98791], [-121.99677, 36.98791], [-121.99571, 36.98786], [-121.99615, 36.98769], [-121.99642, 36.98771], [-121.99677, 36.98791]]]]} | Open Access 1 | 18253 | Ocean View Park | 23056 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Santa Cruz 5 | 1.414 | Ocean View Park | 0 | None 904 | |||
4768 | 4768 | 4767 | {"type": "MultiPolygon", "coordinates": [[[[-123.79434, 40.47335], [-123.79344, 40.47461], [-123.79172, 40.47464], [-123.7917, 40.47345], [-123.79184, 40.4734], [-123.79189, 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.80011, 40.46906], [-123.80066, 40.46963], [-123.79996, 40.46972], [-123.79992, 40.46966], [-123.79964, 40.46971], [-123.79961, 40.46959], [-123.79997, 40.46954], [-123.8001, 40.46907], [-123.80009, 40.46906], [-123.79735, 40.46919], [-123.79647, 40.46944], [-123.79653, 40.46852], [-123.79661, 40.46843], [-123.79718, 40.46811], [-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.097, 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.26888, 40.62856], [-124.26888, 40.62856]]]]} | Open Access 1 | 46915 | Unnamed site - Other State | 28654 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Humboldt 45 | 140.719 | 0 | State Other or Unknown 104 | 4 | |||
5068 | 5068 | 5067 | {"type": "Polygon", "coordinates": [[[-116.81544, 33.65099], [-116.80691, 33.65114], [-116.80684, 33.64208], [-116.8047, 33.64211], [-116.80467, 33.64032], [-116.8025, 33.64032], [-116.80249, 33.63844], [-116.79816, 33.63837], [-116.79814, 33.63666], [-116.80466, 33.63671], [-116.80469, 33.63843], [-116.8068, 33.63845], [-116.80683, 33.64023], [-116.81105, 33.64011], [-116.8111, 33.64388], [-116.81536, 33.64383], [-116.81544, 33.65099]]]} | Open Access 1 | 14230 | California State Lands Commission | 16727 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Riverside 10 | 255.037 | SLC | None 417 | ||||
1165 | 1165 | 1164 | {"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 | 7381 | San Diego National Wildlife Refuge | 24858 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | San Diego 4 | 16.779 | San Diego NWR | 1996 | National Wildlife Refuge 105 | 2 | ||
6844 | 6844 | 6843 | {"type": "Polygon", "coordinates": [[[-118.65109, 34.03761], [-118.65102, 34.03789], [-118.65008, 34.03771], [-118.6496, 34.03764], [-118.64921, 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.64907, 34.0373], [-118.64975, 34.03736], [-118.65109, 34.03761]]]} | Open Access 1 | 5473 | La Costa Beach | 29045 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Los Angeles 6 | 9.122 | La Costa Beach | None 555 | ||||
3933 | 3933 | 3932 | {"type": "Polygon", "coordinates": [[[-119.21361, 38.30059], [-119.21338, 38.30059], [-119.21339, 38.29848], [-119.21349, 38.29872], [-119.21356, 38.29909], [-119.21361, 38.30059]]]} | Open Access 1 | 36234 | Other State 26 | 23258 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Mono 32 | 0.864 | Other State 26 | None 338 | ||||
3189 | 3189 | 3188 | {"type": "Polygon", "coordinates": [[[-119.71275, 36.9916], [-119.71191, 36.99249], [-119.7112, 36.99207], [-119.71091, 36.99196], [-119.71085, 36.99186], [-119.71077, 36.99183], [-119.71053, 36.99176], [-119.71044, 36.99178], [-119.71062, 36.99139], [-119.71109, 36.99063], [-119.71154, 36.99058], [-119.71275, 36.9916]]]} | Open Access 1 | 28051 | Friant Cove | 19113 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Fresno 9 | 5.884 | Friant Cove | None 262 | ||||
13751 | 13751 | 13750 | {"type": "Polygon", "coordinates": [[[-119.79203, 36.87905], [-119.79109, 36.87905], [-119.79022, 36.87875], [-119.79019, 36.87791], [-119.78789, 36.87794], [-119.7874, 36.87857], [-119.78724, 36.87929], [-119.78642, 36.87929], [-119.78673, 36.87858], [-119.78817, 36.87701], [-119.79199, 36.87641], [-119.79203, 36.87905]]]} | Open Access 1 | 36261 | Other State 39 | 23262 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Madera 48 | 19.314 | Other State 39 | None 1184 | ||||
4560 | 4560 | 4559 | {"type": "Polygon", "coordinates": [[[-120.34826, 34.69117], [-120.34814, 34.69379], [-120.34386, 34.69377], [-120.34383, 34.69], [-120.34826, 34.69117]]]} | Open Access 1 | 35186 | Unnamed site - Other State | 28654 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Santa Barbara 7 | 34.99 | 0 | State Other or Unknown 104 | 4 | |||
4615 | 4615 | 4614 | {"type": "Polygon", "coordinates": [[[-120.43434, 35.8989], [-120.4339, 35.89938], [-120.433, 35.89938], [-120.433, 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]]]} | Open Access 1 | 36133 | Unnamed site - Other State | 28654 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Monterey 14 | 5.226 | 0 | State Other or Unknown 104 | 4 | |||
12197 | 12197 | 12196 | {"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 | 35662 | Tuolumne River Restoration Center | 26580 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Stanislaus 2 | 4.72 | Tuolumne River Restoration Ctr. | None 1063 | ||||
9878 | 9878 | 9877 | {"type": "Polygon", "coordinates": [[[-120.50114, 37.29562], [-120.50068, 37.29642], [-120.49943, 37.29596], [-120.49989, 37.29516], [-120.50114, 37.29562]]]} | Open Access 1 | 16947 | Leonard Park | 21174 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Merced 37 | 2.938 | Leonard Park | None 856 | ||||
13738 | 13738 | 13737 | {"type": "Polygon", "coordinates": [[[-120.73667, 39.47016], [-120.73657, 39.47755], [-120.73196, 39.47752], [-120.73198, 39.48087], [-120.72711, 39.48102], [-120.72718, 39.48469], [-120.71771, 39.48463], [-120.7177, 39.49196], [-120.70865, 39.49214], [-120.70863, 39.49212], [-120.70882, 39.49178], [-120.70902, 39.4913], [-120.70912, 39.49113], [-120.70917, 39.49097], [-120.70929, 39.49081], [-120.70943, 39.49075], [-120.70989, 39.49065], [-120.71016, 39.49061], [-120.71064, 39.49068], [-120.71091, 39.49069], [-120.71122, 39.49065], [-120.71147, 39.49057], [-120.71164, 39.49046], [-120.71209, 39.49036], [-120.71225, 39.49019], [-120.71234, 39.48997], [-120.71239, 39.48977], [-120.71244, 39.48947], [-120.71253, 39.48925], [-120.71269, 39.48915], [-120.71298, 39.48912], [-120.71314, 39.48915], [-120.71338, 39.48923], [-120.71365, 39.4893], [-120.71392, 39.48935], [-120.71436, 39.48936], [-120.71476, 39.48932], [-120.71496, 39.48924], [-120.71527, 39.48928], [-120.71557, 39.48935], [-120.71584, 39.4894], [-120.71611, 39.48939], [-120.71629, 39.48932], [-120.71662, 39.48934], [-120.71683, 39.48934], [-120.71696, 39.48928], [-120.71714, 39.48907], [-120.71714, 39.48881], [-120.71702, 39.48861], [-120.71686, 39.48842], [-120.71684, 39.48799], [-120.71669, 39.4878], [-120.71645, 39.48759], [-120.71633, 39.48739], [-120.71626, 39.48713], [-120.71631, 39.48674], [-120.71625, 39.48657], [-120.71522, 39.48607], [-120.71507, 39.48595], [-120.71503, 39.48582], [-120.71503, 39.48565], [-120.71507, 39.48543], [-120.71518, 39.48516], [-120.71518, 39.48491], [-120.71506, 39.48448], [-120.71469, 39.48396], [-120.71459, 39.48379], [-120.71418, 39.48348], [-120.71379, 39.48317], [-120.71369, 39.48301], [-120.71382, 39.48274], [-120.71396, 39.48257], [-120.71423, 39.48206], [-120.71437, 39.48184], [-120.71504, 39.48126], [-120.71528, 39.48112], [-120.71539, 39.48111], [-120.71585, 39.48096], [-120.71598, 39.48089], [-120.71616, 39.48074], [-120.71628, 39.48054], [-120.7165, 39.48037], [-120.71702, 39.48002], [-120.71729, 39.4799], [-120.71785, 39.47963], [-120.71859, 39.47937], [-120.71888, 39.47923], [-120.71904, 39.47907], [-120.71934, 39.47886], [-120.71958, 39.47875], [-120.7199, 39.47853], [-120.72018, 39.47839], [-120.72036, 39.47822], [-120.7206, 39.47792], [-120.72105, 39.47745], [-120.72157, 39.47687], [-120.72185, 39.4766], [-120.72236, 39.47622], [-120.72293, 39.4757], [-120.72376, 39.47521], [-120.72404, 39.475], [-120.72434, 39.47473], [-120.72459, 39.47439], [-120.72484, 39.47399], [-120.72523, 39.47327], [-120.72546, 39.47295], [-120.72562, 39.47283], [-120.7261, 39.47262], [-120.72634, 39.47248], [-120.72651, 39.47235], [-120.72713, 39.47198], [-120.72754, 39.47184], [-120.7279, 39.47168], [-120.7283, 39.47154], [-120.7288, 39.47127], [-120.72948, 39.47101], [-120.72964, 39.47099], [-120.72991, 39.47104], [-120.73014, 39.47115], [-120.73043, 39.47123], [-120.73063, 39.47123], [-120.73087, 39.47114], [-120.73112, 39.47073], [-120.73146, 39.47029], [-120.73205, 39.4699], [-120.73229, 39.46983], [-120.73256, 39.46986], [-120.73285, 39.46985], [-120.73315, 39.46982], [-120.73346, 39.46975], [-120.73384, 39.46976], [-120.73421, 39.4698], [-120.73502, 39.46992], [-120.73616, 39.47012], [-120.73663, 39.47013], [-120.73667, 39.47016]]]} | Open Access 1 | 36232 | Other State 27 | 8209 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | http://asi.ucdavis.edu/rr | Sierra 58 | 481.401 | Other State 27 | None 1181 | |||
3934 | 3934 | 3933 | {"type": "Polygon", "coordinates": [[[-121.0547, 39.80881], [-121.05325, 39.80955], [-121.0533, 39.8095], [-121.04991, 39.8062], [-121.05152, 39.80559], [-121.0547, 39.80881]]]} | Open Access 1 | 36250 | Other State 23 | 23256 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Plumas 57 | 16.582 | Other State 23 | None 339 | ||||
4621 | 4621 | 4620 | {"type": "Polygon", "coordinates": [[[-121.07477, 38.99285], [-121.07367, 38.9929], [-121.07067, 38.99298], [-121.07064, 38.98937], [-121.07472, 38.98924], [-121.07477, 38.99285]]]} | Open Access 1 | 36160 | Other State 31 | 23259 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Placer 35 | 35.203 | Other State 31 | None 402 | ||||
4617 | 4617 | 4616 | {"type": "Polygon", "coordinates": [[[-121.44723, 35.87386], [-121.44572, 35.87386], [-121.44568, 35.87182], [-121.44593, 35.87189], [-121.44619, 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]]]} | Open Access 1 | 36110 | Unnamed site - Other State | 28654 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Monterey 14 | 5.733 | 0 | State Other or Unknown 104 | 4 |
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]);