units_with_maps

Table actions

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

3 rows where ACCESS_TYP = 3 and AGNCY_TYP = 9

This data as json, copyable, CSV (advanced)

Suggested facets: MNG_AG_LEV, COUNTY

ACCESS_TYP 1

  • No Public Access · 3 ✖
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
565 565 564 {"type": "Polygon", "coordinates": [[[-121.91485, 37.97467], [-121.91485, 37.97489], [-121.91456, 37.9751], [-121.91431, 37.97535], [-121.9141, 37.97553], [-121.91345, 37.97542], [-121.91287, 37.97544], [-121.91255, 37.97534], [-121.91197, 37.97514], [-121.91169, 37.9751], [-121.9116, 37.97515], [-121.91148, 37.97518], [-121.91136, 37.97514], [-121.91103, 37.97515], [-121.9109, 37.97496], [-121.91122, 37.97496], [-121.91189, 37.97489], [-121.91232, 37.9749], [-121.91233, 37.97492], [-121.91345, 37.97494], [-121.91408, 37.97484], [-121.91485, 37.97467]]]} No Public Access 3 47528 Alaimo 31233 379 Contra Costa Department of Conservation and Development, County of 209 County 3 County Agency - Other 9 http://www.cccounty.us/dcd County 3 379 Contra Costa Department of Conservation and Development, County of 205 County 3 County Agency - Other 8   Contra Costa 12 3.763 Alaimo   None 56  
13163 13163 13162 {"type": "Polygon", "coordinates": [[[-122.00274, 37.90517], [-122.00231, 37.90516], [-122.00213, 37.90513], [-122.00195, 37.90508], [-122.0017, 37.90499], [-121.99863, 37.90492], [-121.9986, 37.90475], [-121.99682, 37.90477], [-121.99628, 37.90372], [-121.994, 37.90374], [-121.99403, 37.90335], [-121.99401, 37.90309], [-121.99395, 37.90283], [-121.99387, 37.90259], [-121.99375, 37.90235], [-121.9936, 37.90213], [-121.99346, 37.90195], [-121.99811, 37.90237], [-121.99812, 37.90236], [-121.99811, 37.90229], [-122.00015, 37.90249], [-122.0002, 37.90249], [-122.0002, 37.90255], [-122.00096, 37.90262], [-122.00103, 37.90334], [-122.00094, 37.90336], [-122.00101, 37.90354], [-122.00107, 37.90407], [-122.00116, 37.90431], [-122.00123, 37.90442], [-122.00141, 37.90462], [-122.00151, 37.90471], [-122.00176, 37.90486], [-122.0019, 37.90492], [-122.00219, 37.905], [-122.00235, 37.90503], [-122.00268, 37.90503], [-122.00274, 37.90517]]]} No Public Access 3 35113 Mount Diablo Gateway 28139 300 Contra Costa County Public Works Dept., County of 429 County 3 County Agency - Other 9 http://www.co.contra-costa.ca.us/227/Public-Works County 3 300 Contra Costa County Public Works Dept., County of 423 County 3 County Agency - Other 8   Contra Costa 12 38.137 Mount Diablo Gateway   None 1142  
16624 16624 16623 {"type": "Polygon", "coordinates": [[[-121.87428, 37.53505], [-121.87423, 37.5359], [-121.87414, 37.53845], [-121.87396, 37.54089], [-121.87396, 37.54203], [-121.8701, 37.54196], [-121.86955, 37.54176], [-121.86885, 37.5417], [-121.86885, 37.54142], [-121.86879, 37.54132], [-121.86353, 37.54128], [-121.8583, 37.54118], [-121.85764, 37.54027], [-121.85813, 37.53995], [-121.8586, 37.53948], [-121.85881, 37.53898], [-121.85889, 37.53895], [-121.85897, 37.53881], [-121.85912, 37.53863], [-121.85894, 37.53812], [-121.85795, 37.53698], [-121.85796, 37.53576], [-121.8569, 37.53481], [-121.8564, 37.53431], [-121.85545, 37.53365], [-121.85473, 37.53091], [-121.85356, 37.53043], [-121.85308, 37.53044], [-121.85304, 37.53025], [-121.85296, 37.53001], [-121.85259, 37.52957], [-121.85242, 37.52932], [-121.85221, 37.52907], [-121.85197, 37.52883], [-121.85173, 37.52861], [-121.85152, 37.52838], [-121.85112, 37.52787], [-121.8504, 37.52725], [-121.85003, 37.52682], [-121.84984, 37.52663], [-121.84971, 37.52644], [-121.84964, 37.52623], [-121.84954, 37.526], [-121.849, 37.52561], [-121.84881, 37.52536], [-121.84845, 37.52483], [-121.84831, 37.52456], [-121.84807, 37.524], [-121.84798, 37.52372], [-121.84791, 37.52344], [-121.84793, 37.52314], [-121.8479, 37.52282], [-121.84795, 37.52218], [-121.84789, 37.52187], [-121.84773, 37.52161], [-121.84769, 37.52139], [-121.84782, 37.5212], [-121.84802, 37.52104], [-121.86052, 37.52093], [-121.8695, 37.5209], [-121.86968, 37.535], [-121.87428, 37.53505]]]} No Public Access 3 46962 Sunol Regional Wilderness 30582 321 San Francisco - Public Utilities Commission, City and County of 31 County 3 County Agency - Other 9 http://sfwater.org/ County 3 2032 East Bay Regional Park District 87 Special District 4 Recreation/Parks District 4   Alameda 17 864.645 Sunol Reg. Wilderness 1962 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]);