units_with_maps

Table actions

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

1 row where ACCESS_TYP = 2, MNG_AG_TYP = 4 and SUID_NMA = 31516

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Recreation/Parks District · 1 ✖

ACCESS_TYP 1

  • Restricted 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
16275 16275 16274 {"type": "Polygon", "coordinates": [[[-121.70305, 37.80995], [-121.70228, 37.80996], [-121.70228, 37.8138], [-121.70217, 37.81544], [-121.69737, 37.81188], [-121.69619, 37.81188], [-121.69618, 37.80997], [-121.69597, 37.80998], [-121.69595, 37.81134], [-121.69246, 37.81133], [-121.69231, 37.81105], [-121.69219, 37.81049], [-121.69215, 37.8104], [-121.69205, 37.81029], [-121.69172, 37.81009], [-121.69158, 37.80993], [-121.69153, 37.80989], [-121.69077, 37.80964], [-121.69067, 37.80963], [-121.69038, 37.80966], [-121.69025, 37.80969], [-121.69012, 37.80976], [-121.68984, 37.81006], [-121.68859, 37.80936], [-121.68849, 37.80894], [-121.68823, 37.80872], [-121.6869, 37.80815], [-121.68663, 37.80811], [-121.68639, 37.8082], [-121.68613, 37.80842], [-121.68569, 37.80872], [-121.68496, 37.80892], [-121.6842, 37.80889], [-121.68397, 37.80881], [-121.68178, 37.80814], [-121.6813, 37.80808], [-121.68029, 37.80828], [-121.67977, 37.80807], [-121.67968, 37.80764], [-121.68001, 37.80704], [-121.67996, 37.80685], [-121.67925, 37.80627], [-121.67892, 37.80629], [-121.678, 37.80698], [-121.67785, 37.80755], [-121.67689, 37.80772], [-121.67609, 37.8078], [-121.67572, 37.80766], [-121.67541, 37.80729], [-121.6751, 37.80698], [-121.67445, 37.80668], [-121.67429, 37.8064], [-121.67422, 37.80609], [-121.67438, 37.80564], [-121.67497, 37.80511], [-121.67539, 37.80335], [-121.67556, 37.80299], [-121.6757, 37.80256], [-121.67577, 37.80226], [-121.67581, 37.80197], [-121.67583, 37.8007], [-121.67592, 37.80004], [-121.67621, 37.79988], [-121.6761, 37.79964], [-121.67632, 37.79925], [-121.67685, 37.79862], [-121.67709, 37.79847], [-121.67819, 37.79809], [-121.68181, 37.79776], [-121.68233, 37.79749], [-121.68253, 37.79729], [-121.68296, 37.79701], [-121.68353, 37.79696], [-121.68502, 37.7972], [-121.6863, 37.7961], [-121.68737, 37.79489], [-121.68959, 37.79371], [-121.68963, 37.79366], [-121.69001, 37.79362], [-121.69006, 37.79365], [-121.69094, 37.7936], [-121.69142, 37.7931], [-121.69228, 37.79309], [-121.69245, 37.79302], [-121.69248, 37.79734], [-121.69593, 37.79734], [-121.69595, 37.80358], [-121.70305, 37.80995]]]} Restricted Access 2 47727 Vasco Caves Regional Preserve 31516 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 718.817 Vasco Caves RPr 1997 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]);