calands: units_with_maps: 1 row where DES_TP = 2 and MNG

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

1 row where DES_TP = 2 and MNG_AGENCY = 1109

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
16299	16299	16298	{"type": "MultiPolygon", "coordinates": [[[[-117.00698, 32.8493], [-117.00696, 32.8538], [-117.00784, 32.85577], [-117.00829, 32.85706], [-117.00841, 32.8577], [-117.00898, 32.86045], [-117.00905, 32.86085], [-117.00751, 32.86158], [-117.00743, 32.86121], [-117.00733, 32.8609], [-117.00661, 32.85925], [-117.00645, 32.8588], [-117.00637, 32.85845], [-117.00477, 32.84968], [-117.00476, 32.84959], [-117.00497, 32.84953], [-117.00472, 32.84888], [-117.00453, 32.84889], [-117.00424, 32.84725], [-117.00411, 32.84585], [-117.00392, 32.8452], [-117.00418, 32.84515], [-117.00444, 32.84493], [-117.00432, 32.84443], [-117.00441, 32.84444], [-117.00473, 32.84442], [-117.0048, 32.84446], [-117.00484, 32.84453], [-117.00501, 32.84451], [-117.005, 32.84441], [-117.00506, 32.84436], [-117.00548, 32.84432], [-117.00554, 32.84434], [-117.00558, 32.8444], [-117.00574, 32.84438], [-117.00573, 32.84428], [-117.00587, 32.84425], [-117.00601, 32.84469], [-117.00645, 32.84462], [-117.00691, 32.84606], [-117.00698, 32.8493]]], [[[-117.00923, 32.86438], [-117.00906, 32.86491], [-117.00844, 32.86624], [-117.00817, 32.86642], [-117.0076, 32.86635], [-117.00738, 32.86624], [-117.00703, 32.86596], [-117.00697, 32.86578], [-117.00795, 32.86413], [-117.00825, 32.8639], [-117.00917, 32.8642], [-117.00923, 32.86438]]]]}	Open Access 1	193	Santee Lakes Regional Park	25150	2106	Padre Dam Municipal Water District 1170	Special District 4	Water District 13	http://www.padredam.org/	Special District 4	2106	Padre Dam Municipal Water District 1109	Special District 4	Water District 13	http://www.santeelakes.com/	San Diego 4	99.056	Santee Lakes RP	0	Local Park 2	4

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