units_with_maps

Table actions

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

2 rows where ACCESS_TYP = 3, LABEL_NAME = "Las Trampas Wilderness RPr", MNG_AGENCY = 87 and MNG_AG_TYP = 4

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Recreation/Parks District · 2 ✖

MNG_AGENCY 1

  • East Bay Regional Park District · 2 ✖

ACCESS_TYP 1

  • No Public Access · 2 ✖
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
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
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

CSV options: 

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