calands: units_with_maps: 2 rows where AGNCY_NAME = 689, DES_TP = 3 and MNG

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

2 rows where AGNCY_NAME = 689, DES_TP = 3 and MNG_AGENCY = 672

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
3826	3826	3825	{"type": "Polygon", "coordinates": [[[-117.046, 33.25229], [-117.0459, 33.25362], [-117.04581, 33.25622], [-117.04584, 33.25988], [-117.04315, 33.25987], [-117.04304, 33.25622], [-117.04149, 33.2562], [-117.04135, 33.25228], [-117.046, 33.25229]]]}	No Public Access 3	45243	Valley Center MWDD Open Space	26786	2321	Valley Center Water District 689	Special District 4	Water District 13	http://www.vcmwd.org/	Special District 4	2321	Valley Center Water District 672	Special District 4	Water District 13		San Diego 4	70.32	Valley Ctr. MWDD OS	0	Local Recreation Area 3	4
14757	14757	14756	{"type": "MultiPolygon", "coordinates": [[[[-117.08543, 33.22613], [-117.08543, 33.22629], [-117.08327, 33.22627], [-117.08316, 33.22632], [-117.08297, 33.22611], [-117.08291, 33.22611], [-117.08156, 33.22666], [-117.0814, 33.22676], [-117.08134, 33.22684], [-117.08129, 33.22695], [-117.08125, 33.22713], [-117.08129, 33.22768], [-117.08127, 33.22783], [-117.0812, 33.22796], [-117.0811, 33.22805], [-117.08093, 33.22813], [-117.08054, 33.22816], [-117.08033, 33.22821], [-117.07993, 33.22836], [-117.07975, 33.22838], [-117.07957, 33.22839], [-117.07936, 33.22837], [-117.07813, 33.22815], [-117.0768, 33.22785], [-117.07542, 33.22747], [-117.07349, 33.22687], [-117.07315, 33.22673], [-117.07274, 33.22649], [-117.07253, 33.2264], [-117.07253, 33.22601], [-117.07042, 33.22599], [-117.0704, 33.22233], [-117.06955, 33.22231], [-117.06954, 33.22217], [-117.06815, 33.22216], [-117.06808, 33.21864], [-117.07262, 33.21865], [-117.08118, 33.21878], [-117.08117, 33.22244], [-117.08321, 33.22248], [-117.08319, 33.2261], [-117.08543, 33.22613]]], [[[-117.08151, 33.22978], [-117.07891, 33.22974], [-117.07894, 33.22846], [-117.0794, 33.22855], [-117.07975, 33.22855], [-117.08005, 33.2285], [-117.08033, 33.22838], [-117.0805, 33.22834], [-117.08102, 33.22827], [-117.08121, 33.22819], [-117.08136, 33.22805], [-117.08145, 33.22788], [-117.08149, 33.22768], [-117.08154, 33.22811], [-117.08151, 33.22978]]]]}	No Public Access 3	45135	Turner Lake Reservoir	26585	2321	Valley Center Water District 689	Special District 4	Water District 13	http://www.vcmwd.org/	Special District 4	2321	Valley Center Water District 672	Special District 4	Water District 13		San Diego 4	290.169	Turner Lake Reservoir	0	Local Recreation Area 3	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]);