calands: units_with_maps: 1 row where DES_TP = 4, MNG_AGENCY = 468 and SUID

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

1 row where DES_TP = 4, MNG_AGENCY = 468 and SUID_NMA = 33751

Search:

descending

This data as json, copyable, CSV (advanced)

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
15918	15918	15917	{"type": "Polygon", "coordinates": [[[-121.85815, 37.22884], [-121.85695, 37.22901], [-121.85587, 37.22908], [-121.85461, 37.22903], [-121.85434, 37.22903], [-121.85412, 37.22913], [-121.85392, 37.22915], [-121.84989, 37.22873], [-121.84963, 37.22856], [-121.84824, 37.2282], [-121.84765, 37.22588], [-121.84714, 37.22428], [-121.84524, 37.22443], [-121.84525, 37.22462], [-121.8443, 37.22466], [-121.84366, 37.22463], [-121.84346, 37.22335], [-121.8435, 37.2233], [-121.84431, 37.22403], [-121.8454, 37.2238], [-121.84606, 37.22367], [-121.84744, 37.22335], [-121.84798, 37.22337], [-121.84832, 37.22282], [-121.84828, 37.22297], [-121.84831, 37.22313], [-121.84837, 37.22323], [-121.84843, 37.22328], [-121.84859, 37.22337], [-121.84801, 37.2235], [-121.84835, 37.22396], [-121.84894, 37.22421], [-121.84983, 37.2247], [-121.84979, 37.22477], [-121.84967, 37.22532], [-121.84947, 37.22559], [-121.84898, 37.22589], [-121.84897, 37.22613], [-121.84915, 37.22614], [-121.84856, 37.22667], [-121.84856, 37.22669], [-121.8501, 37.22725], [-121.85178, 37.22751], [-121.8518, 37.22756], [-121.85275, 37.22781], [-121.85286, 37.22778], [-121.85307, 37.22767], [-121.8534, 37.22777], [-121.85375, 37.2276], [-121.8542, 37.22755], [-121.85524, 37.22754], [-121.85548, 37.22748], [-121.85626, 37.22758], [-121.85664, 37.22779], [-121.8577, 37.22855], [-121.85815, 37.22884]]]}	Restricted Access 2	49045	Santa Teresa Foothills Open Space Preserve	33751	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		Santa Clara 19	53.071	Santa Teresa Foothills OSP	0	Local Conservation Area 4	2

Advanced export

JSON shape: default, array, newline-delimited

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