units_with_maps

Table actions

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

1 row where ACCESS_TYP = 2, DES_TP = 211 and MNG_AGENCY = 529

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Santa Clara Valley Habitat Agency · 1 ✖

DES_TP 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
2587 2587 2586 {"type": "Polygon", "coordinates": [[[-121.6993, 37.1374], [-121.69927, 37.13758], [-121.69925, 37.13763], [-121.69897, 37.1379], [-121.69889, 37.13803], [-121.69886, 37.13818], [-121.69891, 37.13845], [-121.69887, 37.13856], [-121.69879, 37.13863], [-121.69835, 37.13886], [-121.69819, 37.13898], [-121.69812, 37.13906], [-121.69804, 37.13918], [-121.698, 37.13927], [-121.69798, 37.1394], [-121.69502, 37.13925], [-121.69459, 37.14231], [-121.69775, 37.14279], [-121.69751, 37.1432], [-121.69747, 37.14338], [-121.69749, 37.14349], [-121.69753, 37.14359], [-121.69773, 37.14385], [-121.69774, 37.1439], [-121.6977, 37.14408], [-121.69774, 37.14423], [-121.69782, 37.14433], [-121.69793, 37.14441], [-121.69814, 37.14449], [-121.6985, 37.14457], [-121.69858, 37.14461], [-121.69862, 37.14465], [-121.69873, 37.14492], [-121.69878, 37.145], [-121.69885, 37.14507], [-121.69906, 37.14521], [-121.69907, 37.14526], [-121.69904, 37.1453], [-121.69893, 37.14534], [-121.69881, 37.14534], [-121.69868, 37.14529], [-121.6984, 37.14513], [-121.69831, 37.1451], [-121.69784, 37.14504], [-121.69732, 37.1449], [-121.69711, 37.14489], [-121.69657, 37.14502], [-121.69609, 37.1451], [-121.69592, 37.14514], [-121.69575, 37.14523], [-121.69534, 37.14556], [-121.69429, 37.14477], [-121.69077, 37.14709], [-121.68949, 37.14741], [-121.6883, 37.14735], [-121.68766, 37.14771], [-121.68593, 37.14831], [-121.68474, 37.14958], [-121.6848, 37.15033], [-121.68234, 37.15043], [-121.68145, 37.15097], [-121.68134, 37.15101], [-121.68069, 37.15066], [-121.67969, 37.1506], [-121.6794, 37.15055], [-121.67913, 37.15046], [-121.67887, 37.15036], [-121.67862, 37.15023], [-121.67818, 37.15011], [-121.67231, 37.14686], [-121.67232, 37.14683], [-121.67103, 37.14611], [-121.67103, 37.14609], [-121.67071, 37.14589], [-121.67035, 37.14558], [-121.67011, 37.1453], [-121.68383, 37.13848], [-121.69306, 37.1338], [-121.69859, 37.13656], [-121.69832, 37.13693], [-121.6993, 37.1374]]]} Restricted Access 2 49052 Baird Open Space Regional Reserve 33794 503 Santa Clara Valley Habitat Agency 536 Joint 8 Joint Powers Authority 24 https://www.scv-habitatagency.org/ Special District 4 503 Santa Clara Valley Habitat Agency 529 Joint 8 Joint Powers Authority 23 https://www.scv-habitatagency.org/ Santa Clara 19 597.843 Baird OS RR   None 211  

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