units_with_maps

Table actions

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

1 row where ACCESS_TYP = 3, MNG_AG_TYP = 4 and SUID_NMA = 30627

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Recreation/Parks District · 1 ✖

ACCESS_TYP 1

  • No Public Access · 1 ✖
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
16270 16270 16269 {"type": "Polygon", "coordinates": [[[-121.91452, 37.94328], [-121.91433, 37.94326], [-121.91403, 37.94329], [-121.91378, 37.94337], [-121.91358, 37.94352], [-121.91169, 37.9458], [-121.91149, 37.94602], [-121.91126, 37.94623], [-121.9109, 37.94647], [-121.90846, 37.94792], [-121.9083, 37.94799], [-121.9081, 37.94802], [-121.90712, 37.94792], [-121.90565, 37.94808], [-121.9056, 37.9463], [-121.89632, 37.94622], [-121.89127, 37.94621], [-121.874, 37.94627], [-121.87386, 37.93899], [-121.85005, 37.93907], [-121.85002, 37.93628], [-121.85002, 37.93555], [-121.85001, 37.93554], [-121.85002, 37.93212], [-121.83951, 37.93209], [-121.83948, 37.92876], [-121.84076, 37.92773], [-121.84342, 37.92548], [-121.84341, 37.92547], [-121.84077, 37.92548], [-121.84078, 37.92186], [-121.85003, 37.92186], [-121.85004, 37.92545], [-121.85465, 37.92543], [-121.85462, 37.91102], [-121.85877, 37.91102], [-121.85869, 37.90353], [-121.85857, 37.89987], [-121.85981, 37.89987], [-121.8615, 37.89983], [-121.86173, 37.89994], [-121.86195, 37.90003], [-121.86219, 37.90009], [-121.86243, 37.90014], [-121.86266, 37.90016], [-121.86341, 37.9002], [-121.86447, 37.90019], [-121.8646, 37.9002], [-121.86484, 37.90025], [-121.86495, 37.90028], [-121.86697, 37.90116], [-121.86731, 37.90136], [-121.8684, 37.90211], [-121.86861, 37.90219], [-121.8692, 37.90235], [-121.86943, 37.90243], [-121.86964, 37.90253], [-121.87109, 37.90329], [-121.8713, 37.90343], [-121.87147, 37.90359], [-121.87196, 37.9042], [-121.87221, 37.90443], [-121.87248, 37.90464], [-121.87338, 37.90526], [-121.87358, 37.90542], [-121.87376, 37.90559], [-121.87391, 37.90578], [-121.87424, 37.90634], [-121.87446, 37.90658], [-121.87473, 37.90677], [-121.87577, 37.90731], [-121.87593, 37.90743], [-121.87601, 37.90753], [-121.87607, 37.9077], [-121.87608, 37.9078], [-121.87605, 37.90815], [-121.87607, 37.90828], [-121.87613, 37.9084], [-121.87627, 37.90855], [-121.8764, 37.90863], [-121.8765, 37.90868], [-121.87771, 37.90908], [-121.87801, 37.9092], [-121.87848, 37.90948], [-121.87914, 37.9102], [-121.87984, 37.9108], [-121.88036, 37.91122], [-121.88068, 37.9114], [-121.88136, 37.9117], [-121.88151, 37.91179], [-121.88198, 37.91213], [-121.8822, 37.91223], [-121.88232, 37.91226], [-121.88256, 37.9123], [-121.88272, 37.91231], [-121.88432, 37.91228], [-121.88452, 37.9123], [-121.8849, 37.91239], [-121.88525, 37.91254], [-121.88547, 37.91269], [-121.88546, 37.91272], [-121.88586, 37.91304], [-121.88587, 37.91315], [-121.88641, 37.91359], [-121.88637, 37.91363], [-121.88662, 37.91383], [-121.887, 37.91447], [-121.88594, 37.91482], [-121.88618, 37.92153], [-121.87675, 37.92163], [-121.87674, 37.92534], [-121.89497, 37.92517], [-121.89614, 37.93219], [-121.91442, 37.93215], [-121.91445, 37.93618], [-121.91452, 37.94328]]]} No Public Access 3 13078 Clayton Ranch Regional Preserve 30627 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   Contra Costa 12 4131.029 Clayton Ranch RPr 0 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]);