units_with_maps

Table actions

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

1 row where LABEL_NAME = "Diablo Foothills OSP", MNG_AGENCY = 468 and MNG_AG_TYP = 4

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Recreation/Parks District · 1 ✖

MNG_AGENCY 1

  • Santa Clara Valley Open Space Authority · 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
15810 15810 15809 {"type": "Polygon", "coordinates": [[[-121.4899, 37.01609], [-121.48765, 37.01759], [-121.48766, 37.01763], [-121.48324, 37.02135], [-121.47912, 37.02067], [-121.47955, 37.02882], [-121.47239, 37.02894], [-121.47236, 37.02828], [-121.46133, 37.02794], [-121.45596, 37.02863], [-121.45568, 37.02752], [-121.45566, 37.02711], [-121.456, 37.02498], [-121.45623, 37.02402], [-121.45649, 37.02349], [-121.4568, 37.02296], [-121.45744, 37.02235], [-121.45758, 37.02211], [-121.45803, 37.02126], [-121.4584, 37.02019], [-121.45844, 37.02018], [-121.4585, 37.01998], [-121.45919, 37.01959], [-121.46085, 37.01857], [-121.46124, 37.01828], [-121.46182, 37.01791], [-121.46204, 37.01742], [-121.46255, 37.01718], [-121.46268, 37.01678], [-121.46321, 37.01642], [-121.4643, 37.0159], [-121.46485, 37.0156], [-121.46505, 37.01539], [-121.46516, 37.01485], [-121.46495, 37.0145], [-121.46499, 37.01431], [-121.46502, 37.01423], [-121.47221, 37.01421], [-121.47222, 37.01455], [-121.48628, 37.0148], [-121.48629, 37.01479], [-121.48569, 37.01355], [-121.48667, 37.01355], [-121.48727, 37.01407], [-121.48768, 37.0146], [-121.48803, 37.01492], [-121.48856, 37.01515], [-121.48891, 37.01525], [-121.48929, 37.01529], [-121.48965, 37.01548], [-121.4899, 37.01587], [-121.4899, 37.01609]], [[-121.47211, 37.01834], [-121.47194, 37.01832], [-121.47193, 37.01833], [-121.4721, 37.01835], [-121.47211, 37.01834]]]} No Public Access 3 47763 Diablo Foothills Open Space Preserve 31568 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 819.017 Diablo Foothills OSP 2007 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]);