units_with_maps

Table actions

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

1 row where ACCESS_TYP = 1, LABEL_NAME = "Rancho Cañada del Oro OSP" and MNG_AGENCY = 468

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Santa Clara Valley Open Space Authority · 1 ✖

ACCESS_TYP 1

  • Open 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
15935 15935 15934 {"type": "MultiPolygon", "coordinates": [[[[-121.77769, 37.14593], [-121.77727, 37.14631], [-121.77698, 37.14661], [-121.7768, 37.14675], [-121.77649, 37.14688], [-121.77578, 37.14724], [-121.77462, 37.14777], [-121.77436, 37.14772], [-121.77454, 37.14748], [-121.77443, 37.1468], [-121.77476, 37.14624], [-121.77532, 37.1459], [-121.77551, 37.14567], [-121.77581, 37.14548], [-121.77614, 37.14532], [-121.77673, 37.14548], [-121.77705, 37.14545], [-121.77769, 37.14593]]], [[[-121.83425, 37.15272], [-121.83158, 37.16049], [-121.82902, 37.15846], [-121.82782, 37.15812], [-121.8277, 37.15855], [-121.8243, 37.15989], [-121.83094, 37.15253], [-121.82311, 37.14815], [-121.81893, 37.15492], [-121.81959, 37.15591], [-121.81549, 37.15587], [-121.81498, 37.16051], [-121.81835, 37.16056], [-121.81806, 37.16293], [-121.81334, 37.1629], [-121.81329, 37.16351], [-121.80922, 37.16357], [-121.80259, 37.16407], [-121.7969, 37.1642], [-121.79586, 37.16251], [-121.79367, 37.1625], [-121.79387, 37.15982], [-121.79063, 37.1586], [-121.78672, 37.15918], [-121.78666, 37.15069], [-121.78641, 37.15071], [-121.78625, 37.15065], [-121.78604, 37.15061], [-121.78566, 37.15061], [-121.78511, 37.15076], [-121.78501, 37.15079], [-121.78478, 37.15092], [-121.78459, 37.15092], [-121.78446, 37.15094], [-121.78247, 37.14947], [-121.77472, 37.14779], [-121.77581, 37.14729], [-121.77652, 37.14693], [-121.77683, 37.1468], [-121.77703, 37.14665], [-121.77733, 37.14635], [-121.77801, 37.1457], [-121.77845, 37.14542], [-121.77875, 37.14527], [-121.7795, 37.14484], [-121.78005, 37.14457], [-121.78027, 37.14434], [-121.78035, 37.14424], [-121.78038, 37.14415], [-121.78035, 37.14403], [-121.78018, 37.14366], [-121.78018, 37.14364], [-121.78021, 37.1436], [-121.7805, 37.14353], [-121.78078, 37.1435], [-121.78141, 37.14351], [-121.78165, 37.14344], [-121.78178, 37.14336], [-121.78195, 37.14322], [-121.78204, 37.14308], [-121.78224, 37.14286], [-121.78244, 37.14275], [-121.78264, 37.14268], [-121.78298, 37.14252], [-121.78312, 37.1424], [-121.78327, 37.14222], [-121.78335, 37.1421], [-121.78367, 37.14187], [-121.78378, 37.14174], [-121.78391, 37.14143], [-121.78392, 37.14121], [-121.7839, 37.14084], [-121.78391, 37.14078], [-121.78396, 37.14073], [-121.78404, 37.14069], [-121.78416, 37.14065], [-121.78463, 37.14057], [-121.78492, 37.14055], [-121.78552, 37.14056], [-121.78578, 37.14049], [-121.78596, 37.14039], [-121.78616, 37.14019], [-121.78619, 37.14014], [-121.78621, 37.14008], [-121.7862, 37.13999], [-121.78609, 37.13976], [-121.7859, 37.13916], [-121.78599, 37.13885], [-121.78601, 37.13855], [-121.78611, 37.13837], [-121.78622, 37.13822], [-121.78633, 37.13811], [-121.78651, 37.13799], [-121.78748, 37.13739], [-121.78765, 37.13731], [-121.78814, 37.13712], [-121.78849, 37.13694], [-121.78881, 37.13673], [-121.78917, 37.13653], [-121.78943, 37.13642], [-121.79029, 37.13623], [-121.79054, 37.13608], [-121.79071, 37.13594], [-121.79092, 37.1357], [-121.79105, 37.13546], [-121.79108, 37.13537], [-121.79114, 37.13503], [-121.7912, 37.13478], [-121.79126, 37.13464], [-121.79136, 37.13417], [-121.79149, 37.13375], [-121.79164, 37.1334], [-121.7918, 37.13311], [-121.792, 37.13283], [-121.79217, 37.13266], [-121.79243, 37.13245], [-121.79328, 37.13185], [-121.80042, 37.13537], [-121.8004, 37.13126], [-121.80331, 37.13124], [-121.80335, 37.13681], [-121.82151, 37.14649], [-121.82152, 37.14648], [-121.82149, 37.1432], [-121.82599, 37.14316], [-121.82623, 37.1488], [-121.83425, 37.15272]], [[-121.81284, 37.15118], [-121.81323, 37.14489], [-121.80805, 37.14238], [-121.8026, 37.14692], [-121.8026, 37.14693], [-121.81006, 37.15056], [-121.81565, 37.15379], [-121.81576, 37.15131], [-121.81284, 37.15118]]], [[[-121.7871, 37.12789], [-121.78526, 37.12789], [-121.77855, 37.12459], [-121.77855, 37.12436], [-121.78707, 37.12425], [-121.7871, 37.12789]]]]} Open Access 1 24228 Rancho Cañada del Oro Open Space Preserve 28087 2142 Santa Clara Valley Open Space Authority 475 Special District 4 Recreation/Parks District 4 http://www.openspaceauthority.org/ Special District 4 2142 Santa Clara Valley Open Space Authority 468 Special District 4 Recreation/Parks District 4 http://www.openspaceauthority.org Santa Clara 19 2220.011 Rancho Cañada del Oro OSP 2000 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]);