superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where PARK_URL = "http://www.ebparks.org/parks/las_trampas"
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY
ACCESS_TYP 2
MNG_AG_TYP 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15044 | 15044 | 15043 | {"type": "MultiPolygon", "coordinates": [[[[-121.97776, 37.78435], [-121.9763, 37.78443], [-121.97618, 37.78425], [-121.97601, 37.78391], [-121.97427, 37.7812], [-121.97412, 37.78093], [-121.97412, 37.78089], [-121.97454, 37.78073], [-121.97549, 37.78048], [-121.97551, 37.7805], [-121.97552, 37.78047], [-121.97581, 37.78041], [-121.97656, 37.78159], [-121.97657, 37.78176], [-121.97661, 37.78192], [-121.9773, 37.78315], [-121.97742, 37.7834], [-121.97776, 37.78435]]], [[[-122.01451, 37.80059], [-122.00557, 37.80049], [-122.00567, 37.80631], [-122.00231, 37.80281], [-121.99633, 37.80464], [-121.99583, 37.80363], [-121.99591, 37.80285], [-121.99496, 37.80231], [-121.99446, 37.80164], [-121.99362, 37.8019], [-121.99307, 37.8008], [-122.00009, 37.8005], [-122.00129, 37.80049], [-122.0013, 37.80047], [-121.99653, 37.79356], [-121.99335, 37.79365], [-121.99388, 37.79191], [-121.99383, 37.79062], [-121.99347, 37.78944], [-121.99287, 37.78837], [-121.99322, 37.78817], [-121.99328, 37.78754], [-121.99352, 37.78739], [-121.99275, 37.78651], [-121.99177, 37.78703], [-121.99126, 37.78644], [-121.99657, 37.7863], [-121.99659, 37.78775], [-121.9987, 37.78744], [-122.00555, 37.78874], [-122.00557, 37.78873], [-122.00557, 37.78861], [-122.00617, 37.7886], [-122.00618, 37.78836], [-122.00757, 37.78834], [-122.0104, 37.78851], [-122.01015, 37.78939], [-122.0105, 37.78935], [-122.01051, 37.78947], [-122.01064, 37.78989], [-122.01097, 37.79025], [-122.01152, 37.79077], [-122.01211, 37.79126], [-122.0137, 37.79217], [-122.0142, 37.79254], [-122.01448, 37.79265], [-122.01451, 37.80059]]], [[[-122.0363, 37.79155], [-122.03623, 37.80589], [-122.03623, 37.80589], [-122.0357, 37.80545], [-122.03522, 37.80489], [-122.03478, 37.80455], [-122.03508, 37.80438], [-122.03494, 37.80416], [-122.03484, 37.80376], [-122.03451, 37.80383], [-122.03409, 37.80334], [-122.03429, 37.80316], [-122.03407, 37.80288], [-122.03414, 37.80265], [-122.03377, 37.80255], [-122.0337, 37.80268], [-122.03347, 37.80262], [-122.03387, 37.80208], [-122.03285, 37.80158], [-122.03295, 37.80144], [-122.03288, 37.80132], [-122.03332, 37.80105], [-122.03348, 37.80088], [-122.03356, 37.80088], [-122.0337, 37.80083], [-122.03371, 37.80065], [-122.03346, 37.80054], [-122.03353, 37.80037], [-122.0325, 37.79955], [-122.03131, 37.79892], [-122.03204, 37.79835], [-122.03205, 37.79678], [-122.03093, 37.79675], [-122.03073, 37.77882], [-122.03433, 37.77878], [-122.03454, 37.7859], [-122.03622, 37.7859], [-122.0363, 37.79155]]], [[[-122.09416, 37.8385], [-122.09328, 37.83931], [-122.09287, 37.83963], [-122.09271, 37.83977], [-122.09258, 37.83992], [-122.09247, 37.84009], [-122.09238, 37.84026], [-122.09208, 37.84093], [-122.09101, 37.84036], [-122.09061, 37.84042], [-122.09089, 37.83928], [-122.09088, 37.83927], [-122.07915, 37.83925], [-122.0792, 37.84051], [-122.08034, 37.84006], [-122.0809, 37.84007], [-122.08089, 37.84046], [-122.08145, 37.84213], [-122.08209, 37.84307], [-122.08245, 37.84382], [-122.08379, 37.8438], [-122.0838, 37.84396], [-122.08378, 37.84398], [-122.08398, 37.84936], [-122.07964, 37.84945], [-122.07979, 37.85087], [-122.07937, 37.85095], [-122.07727, 37.85225], [-122.07747, 37.85262], [-122.07991, 37.85414], [-122.07998, 37.85676], [-122.07799, 37.85675], [-122.07827, 37.85578], [-122.0753, 37.85358], [-122.07118, 37.85202], [-122.06802, 37.84945], [-122.06746, 37.84945], [-122.06166, 37.84587], [-122.06157, 37.84298], [-122.06157, 37.84082], [-122.06151, 37.8352], [-122.07007, 37.83511], [-122.0701, 37.83594], [-122.07888, 37.83596], [-122.08332, 37.83587], [-122.08342, 37.83107], [-122.08386, 37.83108], [-122.08409, 37.83096], [-122.08432, 37.83092], [-122.0844, 37.83094], [-122.08473, 37.83139], [-122.08482, 37.83128], [-122.08509, 37.83131], [-122.08503, 37.8314], [-122.08504, 37.83142], [-122.08512, 37.83144], [-122.0855, 37.8313], [-122.08576, 37.83141], [-122.08595, 37.83162], [-122.08622, 37.8315], [-122.0862, 37.83188], [-122.08673, 37.83214], [-122.08677, 37.83236], [-122.08672, 37.83247], [-122.08688, 37.83265], [-122.08696, 37.83265], [-122.087, 37.83267], [-122.0872, 37.83282], [-122.0873, 37.83288], [-122.08742, 37.83307], [-122.08787, 37.83305], [-122.08804, 37.83298], [-122.08829, 37.83278], [-122.08861, 37.83295], [-122.08882, 37.83303], [-122.08915, 37.83306], [-122.08938, 37.83315], [-122.08976, 37.83335], [-122.08996, 37.83348], [-122.09015, 37.83371], [-122.09039, 37.83386], [-122.09047, 37.83403], [-122.09061, 37.83426], [-122.09093, 37.83451], [-122.09116, 37.83454], [-122.09142, 37.83442], [-122.09158, 37.83445], [-122.09178, 37.83465], [-122.09205, 37.8348], [-122.09206, 37.83482], [-122.09147, 37.83712], [-122.09115, 37.83834], [-122.09172, 37.8386], [-122.09219, 37.83869], [-122.09295, 37.83859], [-122.09332, 37.83834], [-122.09362, 37.83823], [-122.09416, 37.8385]], [[-122.07041, 37.84911], [-122.07043, 37.84911], [-122.07039, 37.84713], [-122.07024, 37.84711], [-122.07023, 37.84713], [-122.07041, 37.84911]]]]} | No Public Access 3 | Las Trampas Wilderness Regional Preserve | http://www.ebparks.org/parks/las_trampas | 33753 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 1816.346 | Las Trampas Wilderness RPr | 1966 |
15046 | 15046 | 15045 | {"type": "MultiPolygon", "coordinates": [[[[-122.07008, 37.82891], [-122.07011, 37.83076], [-122.07008, 37.83511], [-122.06151, 37.83521], [-122.06157, 37.84082], [-122.06157, 37.84298], [-122.04791, 37.84221], [-122.04786, 37.83878], [-122.03854, 37.83814], [-122.03694, 37.83847], [-122.03636, 37.83871], [-122.03619, 37.83854], [-122.03402, 37.83971], [-122.03312, 37.83867], [-122.03271, 37.83806], [-122.03268, 37.83806], [-122.03251, 37.8378], [-122.03245, 37.83729], [-122.0326, 37.83704], [-122.03227, 37.83679], [-122.03411, 37.83549], [-122.02785, 37.82923], [-122.02783, 37.82923], [-122.0278, 37.82934], [-122.02789, 37.82964], [-122.02786, 37.82974], [-122.02775, 37.82987], [-122.0278, 37.83015], [-122.02794, 37.83044], [-122.02808, 37.83058], [-122.02813, 37.83103], [-122.02809, 37.83108], [-122.0283, 37.83119], [-122.02819, 37.8313], [-122.02795, 37.83127], [-122.02785, 37.83139], [-122.02761, 37.83151], [-122.02733, 37.83159], [-122.0272, 37.83166], [-122.02679, 37.83197], [-122.02665, 37.83203], [-122.02618, 37.83216], [-122.02601, 37.83237], [-122.02599, 37.83213], [-122.02584, 37.83182], [-122.02555, 37.83158], [-122.02553, 37.83158], [-122.02531, 37.83121], [-122.02591, 37.83092], [-122.02593, 37.83038], [-122.02598, 37.83036], [-122.02593, 37.82731], [-122.02559, 37.82636], [-122.02498, 37.82568], [-122.02854, 37.82759], [-122.02864, 37.82515], [-122.02863, 37.82513], [-122.02485, 37.82523], [-122.02474, 37.82503], [-122.02452, 37.82444], [-122.02445, 37.82438], [-122.02416, 37.82423], [-122.02411, 37.82413], [-122.02394, 37.82357], [-122.02516, 37.82359], [-122.02517, 37.82303], [-122.02569, 37.82303], [-122.0258, 37.82272], [-122.02578, 37.82245], [-122.02562, 37.82205], [-122.02552, 37.82175], [-122.02568, 37.82132], [-122.02605, 37.8213], [-122.02602, 37.81951], [-122.02584, 37.81944], [-122.02594, 37.81217], [-122.02064, 37.81216], [-122.01907, 37.813], [-122.01891, 37.81283], [-122.01836, 37.81312], [-122.01804, 37.81292], [-122.0179, 37.81288], [-122.01761, 37.81286], [-122.01746, 37.81279], [-122.01724, 37.81252], [-122.01672, 37.81212], [-122.01659, 37.812], [-122.01649, 37.81185], [-122.01636, 37.81152], [-122.01632, 37.81149], [-122.01616, 37.81144], [-122.01606, 37.81139], [-122.01592, 37.81128], [-122.01584, 37.81115], [-122.01582, 37.81105], [-122.01584, 37.81069], [-122.01567, 37.8101], [-122.01562, 37.81012], [-122.01559, 37.81004], [-122.0148, 37.80865], [-122.01476, 37.80858], [-122.01462, 37.80844], [-122.00745, 37.80835], [-122.0072, 37.80944], [-122.0067, 37.80978], [-122.00571, 37.81015], [-122.00531, 37.81015], [-122.00476, 37.81033], [-122.00379, 37.81061], [-122.00357, 37.81074], [-122.00299, 37.81054], [-122.00304, 37.81043], [-122.00348, 37.81057], [-122.00375, 37.81033], [-122.00374, 37.80998], [-122.00365, 37.80962], [-122.00345, 37.8093], [-122.0032, 37.80909], [-122.00282, 37.80886], [-122.00219, 37.8087], [-122.00116, 37.8093], [-122.00089, 37.80954], [-122.00083, 37.80971], [-122.00078, 37.80959], [-122.00031, 37.80954], [-122.00035, 37.80951], [-122.00065, 37.80954], [-122.00067, 37.80948], [-122.00097, 37.80923], [-122.00107, 37.80904], [-122.00184, 37.8083], [-122.00187, 37.8083], [-122.00225, 37.80812], [-122.00288, 37.80768], [-122.00328, 37.80591], [-122.00077, 37.80328], [-122.00231, 37.80281], [-122.00565, 37.80628], [-122.00556, 37.80048], [-122.01449, 37.80059], [-122.01451, 37.80019], [-122.02017, 37.80015], [-122.0203, 37.80112], [-122.01957, 37.80155], [-122.01938, 37.80163], [-122.01931, 37.80171], [-122.0193, 37.8018], [-122.01935, 37.8019], [-122.01944, 37.80195], [-122.01951, 37.80197], [-122.01974, 37.80197], [-122.01983, 37.80201], [-122.01991, 37.80206], [-122.01996, 37.80214], [-122.01998, 37.80225], [-122.02001, 37.80232], [-122.02035, 37.80274], [-122.02038, 37.8028], [-122.02037, 37.80287], [-122.02032, 37.80296], [-122.01986, 37.80344], [-122.01971, 37.8035], [-122.01953, 37.80353], [-122.01941, 37.80357], [-122.01925, 37.80367], [-122.01916, 37.80381], [-122.01913, 37.80396], [-122.01919, 37.80477], [-122.02013, 37.80499], [-122.02028, 37.80905], [-122.02606, 37.80906], [-122.02601, 37.80838], [-122.02572, 37.80708], [-122.03011, 37.80709], [-122.03151, 37.80904], [-122.032, 37.80915], [-122.03266, 37.80724], [-122.03365, 37.80696], [-122.03327, 37.80657], [-122.03316, 37.80599], [-122.03449, 37.80536], [-122.0347, 37.80564], [-122.03513, 37.80539], [-122.03582, 37.80599], [-122.03615, 37.80623], [-122.03622, 37.8063], [-122.03708, 37.80694], [-122.0377, 37.80732], [-122.03808, 37.80771], [-122.0382, 37.80789], [-122.03828, 37.80795], [-122.03825, 37.80801], [-122.03828, 37.80807], [-122.03807, 37.80829], [-122.03623, 37.8077], [-122.03619, 37.81412], [-122.03984, 37.81413], [-122.03985, 37.81315], [-122.0408, 37.81321], [-122.04186, 37.81364], [-122.04351, 37.81247], [-122.04355, 37.8122], [-122.04417, 37.81285], [-122.04539, 37.81421], [-122.04716, 37.81569], [-122.04776, 37.81605], [-122.04877, 37.81646], [-122.04937, 37.81684], [-122.04958, 37.81686], [-122.04969, 37.81674], [-122.04974, 37.81672], [-122.04971, 37.8165], [-122.04902, 37.81614], [-122.04828, 37.8159], [-122.04766, 37.81564], [-122.04733, 37.81547], [-122.04709, 37.81527], [-122.04569, 37.81398], [-122.04555, 37.81369], [-122.04511, 37.81326], [-122.04429, 37.8124], [-122.04378, 37.81201], [-122.04257, 37.8107], [-122.04207, 37.81025], [-122.04168, 37.80999], [-122.04124, 37.80976], [-122.03988, 37.80912], [-122.03996, 37.79388], [-122.0399, 37.78587], [-122.04381, 37.78583], [-122.04385, 37.79321], [-122.05121, 37.79314], [-122.05124, 37.7949], [-122.05302, 37.79488], [-122.05301, 37.79312], [-122.06151, 37.79304], [-122.06152, 37.79782], [-122.0601, 37.79891], [-122.0601, 37.79892], [-122.06012, 37.79893], [-122.05809, 37.80062], [-122.05844, 37.80128], [-122.05818, 37.80268], [-122.05779, 37.80369], [-122.05727, 37.80403], [-122.05647, 37.80414], [-122.05638, 37.80421], [-122.05715, 37.80552], [-122.05676, 37.80643], [-122.05595, 37.80697], [-122.05568, 37.80781], [-122.05724, 37.81079], [-122.05757, 37.81146], [-122.0585, 37.81187], [-122.05906, 37.81278], [-122.0603, 37.81384], [-122.06151, 37.81517], [-122.06152, 37.82102], [-122.06276, 37.82105], [-122.06273, 37.82888], [-122.07008, 37.82891]], [[-122.01691, 37.80906], [-122.0169, 37.80905], [-122.01509, 37.80907], [-122.01568, 37.81007], [-122.01692, 37.80958], [-122.01691, 37.80906]], [[-122.01521, 37.80847], [-122.01523, 37.80848], [-122.01529, 37.80845], [-122.01525, 37.80839], [-122.01518, 37.80842], [-122.01521, 37.80847]]], [[[-122.04288, 37.81143], [-122.04279, 37.81158], [-122.04281, 37.81163], [-122.04227, 37.812], [-122.04163, 37.81167], [-122.04173, 37.81079], [-122.04117, 37.81029], [-122.04062, 37.81043], [-122.04012, 37.81027], [-122.03987, 37.81039], [-122.03988, 37.80943], [-122.04132, 37.8101], [-122.04213, 37.81069], [-122.04288, 37.81143]]]]} | Open Access 1 | Las Trampas Wilderness Regional Preserve | http://www.ebparks.org/parks/las_trampas | 33754 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 3849.935 | Las Trampas Wilderness RPr | 1966 |
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]);