units_with_maps

Table actions

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

2 rows where LAYER = 5, MNG_AGENCY = 166 and MNG_AG_TYP = 5

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • State Agency · 2 ✖

MNG_AGENCY 1

  • California Department of Veterans Affairs · 2 ✖

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
434 434 433 {"type": "Polygon", "coordinates": [[[-122.3521, 38.44442], [-122.34572, 38.4492], [-122.34565, 38.44615], [-122.3358, 38.44548], [-122.3314, 38.44557], [-122.33138, 38.4492], [-122.3184, 38.44966], [-122.29917, 38.448], [-122.29908, 38.44438], [-122.31821, 38.44584], [-122.31804, 38.44201], [-122.33143, 38.44194], [-122.33145, 38.43832], [-122.32239, 38.43823], [-122.32228, 38.43447], [-122.33607, 38.43482], [-122.34065, 38.43479], [-122.34065, 38.43521], [-122.34066, 38.43522], [-122.3429, 38.43515], [-122.34817, 38.43528], [-122.34848, 38.43602], [-122.34809, 38.44201], [-122.3521, 38.44442]]]} Open Access 1 837 Silverado Trail Rector Dam Watershed 1818 206 California Department of Veterans Affairs 170 State 5 State Agency 5 http://www.cdva.ca.gov/ Other State 5 206 California Department of Veterans Affairs 166 State 5 State Agency 5   Napa 11 959.679 Silverado Trail Rector Dam Watershed   None 44  
9535 9535 9534 {"type": "Polygon", "coordinates": [[[-122.38699, 38.39466], [-122.37714, 38.39469], [-122.37938, 38.38742], [-122.38029, 38.38436], [-122.37717, 38.39444], [-122.37409, 38.39566], [-122.37335, 38.39398], [-122.37121, 38.39263], [-122.3693, 38.39221], [-122.36874, 38.39053], [-122.36846, 38.38914], [-122.36755, 38.38821], [-122.366, 38.38782], [-122.37008, 38.38595], [-122.37392, 38.39097], [-122.37515, 38.39047], [-122.37727, 38.38728], [-122.37763, 38.38706], [-122.37758, 38.38599], [-122.37775, 38.3841], [-122.3772, 38.38216], [-122.37717, 38.38217], [-122.37531, 38.38163], [-122.37518, 38.38087], [-122.37591, 38.37813], [-122.3817, 38.37932], [-122.38186, 38.37922], [-122.38154, 38.38027], [-122.38184, 38.38028], [-122.38222, 38.39106], [-122.38683, 38.39105], [-122.38699, 38.39466]]]} Open Access 1 15987 Veterans Home Open Space 1819 206 California Department of Veterans Affairs 170 State 5 State Agency 5 http://www.cdva.ca.gov/ Other State 5 206 California Department of Veterans Affairs 166 State 5 State Agency 5   Napa 11 347.642 Veterans Home OS 0 State Recreation Area 39 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]);