calands: units_with_maps: 3 rows where AGNCY_TYP = 2, GAP_STS = 2 and MNG

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

3 rows where AGNCY_TYP = 2, GAP_STS = 2 and MNG_AGENCY = 120

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	DES_TP	GAP_STS
6426	6426	6425	{"type": "Polygon", "coordinates": [[[-117.28832, 33.16918], [-117.28816, 33.16969], [-117.288, 33.17008], [-117.28762, 33.17027], [-117.28755, 33.17053], [-117.28807, 33.17132], [-117.28817, 33.17188], [-117.28809, 33.17239], [-117.28778, 33.17235], [-117.28743, 33.17205], [-117.28705, 33.17199], [-117.287, 33.17181], [-117.28663, 33.17164], [-117.28607, 33.17149], [-117.28579, 33.17184], [-117.28571, 33.17242], [-117.2854, 33.17253], [-117.28518, 33.17298], [-117.285, 33.17422], [-117.2844, 33.17457], [-117.28428, 33.17416], [-117.28426, 33.17417], [-117.28425, 33.17447], [-117.28389, 33.17381], [-117.28389, 33.17324], [-117.28302, 33.17298], [-117.2815, 33.17354], [-117.2809, 33.17391], [-117.28089, 33.17412], [-117.28031, 33.17422], [-117.27957, 33.17406], [-117.27956, 33.17577], [-117.27527, 33.17577], [-117.27526, 33.17718], [-117.27095, 33.17716], [-117.27085, 33.1685], [-117.27953, 33.16855], [-117.27955, 33.16947], [-117.28386, 33.16947], [-117.28386, 33.16973], [-117.28435, 33.16972], [-117.28457, 33.16956], [-117.28458, 33.16946], [-117.28468, 33.16947], [-117.28473, 33.16932], [-117.28511, 33.16913], [-117.28522, 33.16882], [-117.28617, 33.16804], [-117.28832, 33.16918]]]}	Open Access 1	1933	Lake Calavera Preserve	2079	1045	Carlsbad, City of 123	City 2	City Agency 2	http://www.carlsbadca.gov/services/depts/parks/default.asp	City 2	1045	Carlsbad, City of 120	City 2	City Agency 2	http://www.carlsbadca.gov/services/depts/parks/open/trails/talk/calavera.asp	San Diego 4	262.295	Lake Calavera Preserve	Local Conservation Area 4	2
6675	6675	6674	{"type": "Polygon", "coordinates": [[[-117.30179, 33.13802], [-117.30174, 33.13819], [-117.30151, 33.13825], [-117.30101, 33.13828], [-117.30039, 33.13846], [-117.30037, 33.13863], [-117.30055, 33.1388], [-117.29992, 33.13877], [-117.30002, 33.13674], [-117.29812, 33.13667], [-117.29824, 33.13312], [-117.29871, 33.13306], [-117.2992, 33.13303], [-117.2995, 33.13305], [-117.29988, 33.13309], [-117.30021, 33.13316], [-117.30049, 33.13324], [-117.30079, 33.13334], [-117.30047, 33.13362], [-117.30025, 33.13408], [-117.29992, 33.13447], [-117.29989, 33.13469], [-117.29968, 33.13496], [-117.29966, 33.13527], [-117.29974, 33.13534], [-117.29979, 33.13542], [-117.29986, 33.13543], [-117.30003, 33.13541], [-117.30019, 33.13536], [-117.3004, 33.13527], [-117.3005, 33.13529], [-117.30059, 33.13542], [-117.30099, 33.13627], [-117.30068, 33.13678], [-117.3007, 33.13713], [-117.30076, 33.13745], [-117.30079, 33.13778], [-117.30093, 33.13801], [-117.30114, 33.13811], [-117.30148, 33.13803], [-117.30171, 33.13794], [-117.30179, 33.13802]]]}	Open Access 1	48409	Macario Canyon Preserve	32975	1045	Carlsbad, City of 123	City 2	City Agency 2	http://www.carlsbadca.gov/services/depts/parks/default.asp	City 2	1045	Carlsbad, City of 120	City 2	City Agency 2		San Diego 4	24.84	Macario Canyon Preserve	Local Conservation Area 4	2
6686	6686	6685	{"type": "Polygon", "coordinates": [[[-117.29824, 33.13313], [-117.29812, 33.13667], [-117.29552, 33.13657], [-117.29529, 33.13554], [-117.29538, 33.1353], [-117.29548, 33.13507], [-117.29561, 33.13484], [-117.29582, 33.13456], [-117.29599, 33.13436], [-117.29626, 33.13411], [-117.29655, 33.13389], [-117.29678, 33.13374], [-117.29768, 33.13329], [-117.29796, 33.13319], [-117.29824, 33.13313]]]}	Open Access 1	48411	Veterans Park Preserve	32977	1045	Carlsbad, City of 123	City 2	City Agency 2	http://www.carlsbadca.gov/services/depts/parks/default.asp	City 2	1045	Carlsbad, City of 120	City 2	City Agency 2	http://www.carlsbadca.gov/civicax/filebank/blobdload.aspx?BlobID=37992	San Diego 4	19.573	Veterans Park Preserve	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]);