units_with_maps

Table actions

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

1 row where DES_TP = 2 and SUID_NMA = 31520

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

DES_TP 1

  • Local Park · 1 ✖

ACCESS_TYP 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
5761 5761 5760 {"type": "Polygon", "coordinates": [[[-121.73224, 38.009], [-121.72985, 38.00901], [-121.72986, 38.02204], [-121.72942, 38.0223], [-121.72882, 38.02348], [-121.72786, 38.02508], [-121.7259, 38.02528], [-121.72399, 38.02519], [-121.72168, 38.02469], [-121.71852, 38.02368], [-121.71627, 38.02245], [-121.71439, 38.02186], [-121.71255, 38.02172], [-121.71147, 38.0212], [-121.71065, 38.0207], [-121.71014, 38.02044], [-121.7097, 38.02031], [-121.70885, 38.02016], [-121.70831, 38.02019], [-121.70788, 38.02032], [-121.70758, 38.02052], [-121.70735, 38.02087], [-121.70732, 38.02113], [-121.70732, 38.02145], [-121.7073, 38.02177], [-121.70713, 38.02207], [-121.70633, 38.02281], [-121.70546, 38.02315], [-121.70491, 38.02345], [-121.70413, 38.02397], [-121.70358, 38.02428], [-121.7029, 38.0245], [-121.70128, 38.02488], [-121.70062, 38.02507], [-121.69988, 38.02523], [-121.69909, 38.02534], [-121.69737, 38.02549], [-121.69672, 38.02563], [-121.69574, 38.02579], [-121.69543, 38.02581], [-121.69518, 38.02575], [-121.69395, 38.02506], [-121.69341, 38.02479], [-121.69274, 38.02442], [-121.69138, 38.02371], [-121.691, 38.02343], [-121.6908, 38.02323], [-121.69073, 38.02304], [-121.69056, 38.0221], [-121.69029, 38.02141], [-121.69007, 38.02108], [-121.68936, 38.02036], [-121.68882, 38.01995], [-121.68778, 38.0189], [-121.68732, 38.01838], [-121.68656, 38.01785], [-121.68638, 38.01768], [-121.68615, 38.01752], [-121.686, 38.01726], [-121.68594, 38.01701], [-121.68601, 38.01673], [-121.68602, 38.01649], [-121.68611, 38.01619], [-121.68619, 38.01602], [-121.68605, 38.01575], [-121.68589, 38.0156], [-121.6857, 38.01556], [-121.68534, 38.01561], [-121.68498, 38.01572], [-121.68549, 38.01535], [-121.68564, 38.01515], [-121.68575, 38.0148], [-121.68573, 38.0146], [-121.68567, 38.01441], [-121.68554, 38.01418], [-121.68499, 38.01365], [-121.68476, 38.01351], [-121.68616, 38.01353], [-121.68808, 38.0132], [-121.68885, 38.01329], [-121.68932, 38.01338], [-121.68975, 38.01329], [-121.69037, 38.01241], [-121.69042, 38.01202], [-121.69041, 38.01184], [-121.69057, 38.01169], [-121.69083, 38.01152], [-121.6909, 38.01129], [-121.69092, 38.01111], [-121.69102, 38.01082], [-121.69121, 38.01057], [-121.69104, 38.01036], [-121.69106, 38.01024], [-121.69101, 38.01008], [-121.691, 38.00933], [-121.69102, 38.00912], [-121.69114, 38.00835], [-121.69117, 38.00802], [-121.69131, 38.00698], [-121.6913, 38.00678], [-121.69134, 38.00615], [-121.69148, 38.00539], [-121.69171, 38.00536], [-121.69505, 38.00708], [-121.6968, 38.00734], [-121.69696, 38.00638], [-121.71159, 38.00658], [-121.71157, 38.00843], [-121.72312, 38.00845], [-121.72313, 38.00872], [-121.73224, 38.00873], [-121.73224, 38.009]]]} Restricted Access 2 532 Big Break Regional Shoreline 31520 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 1604.429 Big Break Reg. Shoreline 2005 Local Park 2 4

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