units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
4 rows where DES_TP = 4, MNG_AG_TYP = 4 and PARK_URL = "http://www.ebparks.org/parks/las_trampas"
This data as json, copyable, CSV (advanced)
Suggested facets: SUID_NMA, COUNTY
ACCESS_TYP 2
MNG_AG_TYP 1
- Recreation/Parks District · 4 ✖
MNG_AGENCY 1
DES_TP 1
- Local Conservation Area · 4 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10677 | 10677 | 10676 | {"type": "Polygon", "coordinates": [[[-122.06152, 37.79782], [-122.06008, 37.79892], [-122.05897, 37.79903], [-122.05748, 37.79893], [-122.05154, 37.79829], [-122.0471, 37.798], [-122.04643, 37.79791], [-122.04519, 37.79782], [-122.04304, 37.79575], [-122.03996, 37.79388], [-122.0399, 37.78587], [-122.04381, 37.78583], [-122.04385, 37.79321], [-122.05121, 37.79314], [-122.05123, 37.7949], [-122.05302, 37.79488], [-122.05301, 37.79312], [-122.06151, 37.79304], [-122.06152, 37.79782]]]} | Open Access 1 | 23069 | Las Trampas Wilderness Regional Preserve | 33754 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/parks/las_trampas | Alameda 17 | 301.925 | Las Trampas Wilderness RPr | 1966 | Local Conservation Area 4 | 2 |
16276 | 16276 | 16275 | {"type": "Polygon", "coordinates": [[[-122.0363, 37.79155], [-122.03179, 37.78826], [-122.03082, 37.78784], [-122.03073, 37.77882], [-122.03433, 37.77878], [-122.03454, 37.78591], [-122.03622, 37.7859], [-122.0363, 37.79155]]]} | No Public Access 3 | 31204 | Las Trampas Wilderness Regional Preserve | 33753 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/parks/las_trampas | Alameda 17 | 111.104 | Las Trampas Wilderness RPr | 1966 | Local Conservation Area 4 | 2 |
16280 | 16280 | 16279 | {"type": "MultiPolygon", "coordinates": [[[[-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]]], [[[-122.04586, 37.81413], [-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.81], [-122.04124, 37.80976], [-122.03988, 37.80912], [-122.03996, 37.79388], [-122.04304, 37.79575], [-122.04519, 37.79782], [-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.05637, 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.82103], [-122.06276, 37.82105], [-122.06273, 37.82889], [-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.04787, 37.83878], [-122.03855, 37.83814], [-122.03694, 37.83847], [-122.03636, 37.83871], [-122.0362, 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.03412, 37.8355], [-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.83045], [-122.02808, 37.83058], [-122.02813, 37.83103], [-122.02808, 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.83093], [-122.02593, 37.83038], [-122.02598, 37.83037], [-122.02593, 37.82731], [-122.02559, 37.82636], [-122.02497, 37.82568], [-122.02855, 37.8276], [-122.02864, 37.82514], [-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.02517, 37.8236], [-122.02517, 37.82303], [-122.02569, 37.82304], [-122.0258, 37.82272], [-122.02578, 37.82245], [-122.02562, 37.82205], [-122.02552, 37.82175], [-122.02568, 37.82132], [-122.02605, 37.82131], [-122.02602, 37.8195], [-122.02584, 37.81944], [-122.02594, 37.81217], [-122.02063, 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.81009], [-122.01562, 37.81012], [-122.01559, 37.81004], [-122.0148, 37.80865], [-122.01476, 37.80859], [-122.01462, 37.80844], [-122.00745, 37.80835], [-122.0072, 37.80944], [-122.0067, 37.80978], [-122.00571, 37.81015], [-122.00531, 37.81014], [-122.00476, 37.81033], [-122.00379, 37.81061], [-122.00357, 37.81074], [-122.00299, 37.81053], [-122.00304, 37.81043], [-122.00348, 37.81058], [-122.00375, 37.81033], [-122.00374, 37.80998], [-122.00365, 37.80963], [-122.00345, 37.8093], [-122.00321, 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.00066, 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.00329, 37.80591], [-122.00077, 37.80328], [-122.00231, 37.80281], [-122.00566, 37.8063], [-122.00556, 37.80048], [-122.0145, 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.80181], [-122.01934, 37.80189], [-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.80226], [-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.0194, 37.80357], [-122.01925, 37.80367], [-122.01916, 37.80381], [-122.01913, 37.80395], [-122.01919, 37.80478], [-122.02013, 37.80499], [-122.02028, 37.80906], [-122.02607, 37.80906], [-122.02601, 37.80838], [-122.02572, 37.80708], [-122.03011, 37.80709], [-122.03151, 37.80904], [-122.03201, 37.80915], [-122.03266, 37.80724], [-122.03366, 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.03824, 37.80801], [-122.03828, 37.80807], [-122.03807, 37.80829], [-122.03623, 37.80769], [-122.03619, 37.81413], [-122.03984, 37.81413], [-122.03985, 37.81315], [-122.0408, 37.81321], [-122.04186, 37.81365], [-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.81673], [-122.04971, 37.81651], [-122.04902, 37.81614], [-122.04828, 37.8159], [-122.04766, 37.81564], [-122.04733, 37.81547], [-122.04709, 37.81527], [-122.04586, 37.81413]], [[-122.01691, 37.80906], [-122.0169, 37.80905], [-122.01509, 37.80906], [-122.01567, 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.80838], [-122.01517, 37.80842], [-122.01521, 37.80847]]]]} | Open Access 1 | 17303 | Las Trampas Wilderness Regional Preserve | 33754 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/parks/las_trampas | Contra Costa 12 | 3549.895 | Las Trampas Wilderness RPr | 1966 | Local Conservation Area 4 | 2 |
16290 | 16290 | 16289 | {"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.78092], [-121.97412, 37.78089], [-121.97454, 37.78073], [-121.97549, 37.78048], [-121.9755, 37.7805], [-121.97552, 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.78314], [-121.97742, 37.7834], [-121.97776, 37.78435]]], [[[-122.01451, 37.80059], [-122.00557, 37.80048], [-122.00567, 37.80631], [-122.00231, 37.80281], [-121.99633, 37.80464], [-121.99583, 37.80363], [-121.99592, 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.80048], [-121.99653, 37.79356], [-121.99335, 37.79365], [-121.99388, 37.79191], [-121.99383, 37.79061], [-121.99347, 37.78944], [-121.99287, 37.78837], [-121.99322, 37.78817], [-121.99328, 37.78754], [-121.99353, 37.7874], [-121.99275, 37.78651], [-121.99177, 37.78703], [-121.99126, 37.78644], [-121.99657, 37.7863], [-121.99658, 37.78775], [-121.9987, 37.78744], [-122.00556, 37.78874], [-122.00557, 37.78873], [-122.00557, 37.78861], [-122.00618, 37.7886], [-122.00618, 37.78836], [-122.00757, 37.78834], [-122.0104, 37.78851], [-122.01015, 37.7894], [-122.0105, 37.78935], [-122.0105, 37.78947], [-122.01064, 37.78989], [-122.01097, 37.79025], [-122.01152, 37.79077], [-122.01211, 37.79125], [-122.0137, 37.79217], [-122.0142, 37.79254], [-122.01448, 37.79265], [-122.01451, 37.80059]]], [[[-122.0363, 37.79155], [-122.0363, 37.79155], [-122.03623, 37.80589], [-122.0357, 37.80545], [-122.03522, 37.80489], [-122.03478, 37.80455], [-122.03509, 37.80439], [-122.03494, 37.80416], [-122.03484, 37.80376], [-122.03451, 37.80383], [-122.03409, 37.80334], [-122.03429, 37.80317], [-122.03407, 37.80288], [-122.03415, 37.80265], [-122.03377, 37.80255], [-122.0337, 37.80268], [-122.03347, 37.80262], [-122.03388, 37.80209], [-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.03371, 37.80083], [-122.03372, 37.80065], [-122.03346, 37.80054], [-122.03353, 37.80038], [-122.0325, 37.79955], [-122.03131, 37.79892], [-122.03204, 37.79836], [-122.03205, 37.79677], [-122.03093, 37.79675], [-122.03082, 37.78784], [-122.03179, 37.78826], [-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.83924], [-122.0792, 37.84051], [-122.08034, 37.84006], [-122.0809, 37.84007], [-122.08089, 37.84046], [-122.08145, 37.84214], [-122.08209, 37.84307], [-122.08245, 37.84383], [-122.08379, 37.8438], [-122.0838, 37.84396], [-122.08378, 37.84397], [-122.08398, 37.84936], [-122.07963, 37.84944], [-122.07979, 37.85087], [-122.07937, 37.85095], [-122.07726, 37.85225], [-122.07747, 37.85261], [-122.07991, 37.85414], [-122.07998, 37.85676], [-122.07799, 37.85675], [-122.07828, 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.07009, 37.83594], [-122.07888, 37.83596], [-122.08333, 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.8314], [-122.08482, 37.83128], [-122.08509, 37.83131], [-122.08503, 37.83139], [-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.08671, 37.83247], [-122.08688, 37.83266], [-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.08883, 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.09114, 37.83833], [-122.09173, 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.84912], [-122.07043, 37.84912], [-122.07039, 37.84712], [-122.07024, 37.84711], [-122.07023, 37.84712], [-122.07041, 37.84912]]]]} | No Public Access 3 | 28108 | Las Trampas Wilderness Regional Preserve | 33753 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/parks/las_trampas | Contra Costa 12 | 1705.007 | Las Trampas Wilderness RPr | 1966 | Local Conservation Area 4 | 2 |
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]);