calands: units_with_maps: 4 rows where DES_TP = 65, LAYER = 10 and MNG

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

4 rows where DES_TP = 65, LAYER = 10 and MNG_AGENCY = 370

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
1490	1490	1489	{"type": "Polygon", "coordinates": [[[-117.68588, 34.45141], [-117.68154, 34.45142], [-117.68152, 34.44779], [-117.68587, 34.4478], [-117.68588, 34.45141]]]}	Restricted Access 2	12700	Antelope Valley Open Space	29491	3000	Arroyos and Foothills Conservancy 375	Non Profit 6	Non Profit - Land Trust 10	http://www.arroyosfoothills.org/	Non Governmental Organization 10	3000	Arroyos and Foothills Conservancy 370	Non Profit 6	Non Profit - Land Trust 10		Los Angeles 6	39.642	Antelope Valley OS	Private Recreation or Education 65	4
15232	15232	15231	{"type": "Polygon", "coordinates": [[[-118.14873, 34.20755], [-118.14873, 34.20755], [-118.14745, 34.20754], [-118.14816, 34.20703], [-118.14871, 34.20655], [-118.14873, 34.20755]]]}	Open Access 1	46186	Chaney Trail Open Space	29490	3000	Arroyos and Foothills Conservancy 375	Non Profit 6	Non Profit - Land Trust 10	http://www.arroyosfoothills.org/	Non Governmental Organization 10	3000	Arroyos and Foothills Conservancy 370	Non Profit 6	Non Profit - Land Trust 10		Los Angeles 6	1.539	Chaney Trail OS	Private Recreation or Education 65	4
16202	16202	16201	{"type": "Polygon", "coordinates": [[[-118.12246, 34.20342], [-118.12199, 34.20383], [-118.12181, 34.20394], [-118.12159, 34.20406], [-118.12133, 34.20415], [-118.12098, 34.20421], [-118.12096, 34.20413], [-118.12062, 34.20418], [-118.1205, 34.20422], [-118.12039, 34.20428], [-118.11999, 34.20456], [-118.11991, 34.20464], [-118.11985, 34.20472], [-118.11976, 34.2049], [-118.11975, 34.20495], [-118.11975, 34.20535], [-118.11971, 34.20545], [-118.11961, 34.20559], [-118.11777, 34.20453], [-118.11778, 34.20046], [-118.11887, 34.20046], [-118.11886, 34.19944], [-118.11983, 34.19943], [-118.11984, 34.19938], [-118.12033, 34.19937], [-118.12025, 34.19942], [-118.12025, 34.19943], [-118.12091, 34.19968], [-118.12158, 34.19968], [-118.1216, 34.19987], [-118.12137, 34.19987], [-118.12136, 34.19992], [-118.12123, 34.20005], [-118.12106, 34.20006], [-118.12106, 34.20047], [-118.12014, 34.20047], [-118.12013, 34.20176], [-118.1206, 34.20183], [-118.12138, 34.20261], [-118.12214, 34.20259], [-118.12221, 34.20322], [-118.12246, 34.20342]]]}	Open Access 1	46181	Rubio Canyon Open Space	29487	3000	Arroyos and Foothills Conservancy 375	Non Profit 6	Non Profit - Land Trust 10	http://www.arroyosfoothills.org/	Non Governmental Organization 10	3000	Arroyos and Foothills Conservancy 370	Non Profit 6	Non Profit - Land Trust 10		Los Angeles 6	42.645	Rubio Canyon OS	Private Recreation or Education 65	4
16207	16207	16206	{"type": "Polygon", "coordinates": [[[-118.16315, 34.21033], [-118.16181, 34.21207], [-118.16127, 34.2127], [-118.16129, 34.21319], [-118.16097, 34.21354], [-118.16082, 34.21341], [-118.16075, 34.21375], [-118.16061, 34.21387], [-118.16041, 34.21379], [-118.16033, 34.21393], [-118.16036, 34.21397], [-118.16043, 34.21401], [-118.15982, 34.21427], [-118.15969, 34.21437], [-118.15945, 34.2147], [-118.15914, 34.21455], [-118.15889, 34.21474], [-118.15844, 34.21497], [-118.15739, 34.21492], [-118.1604, 34.21271], [-118.16131, 34.21155], [-118.16185, 34.21158], [-118.16183, 34.21032], [-118.16315, 34.21033]]]}	Open Access 1	46184	Millard Canyon Open Space	29489	3000	Arroyos and Foothills Conservancy 375	Non Profit 6	Non Profit - Land Trust 10	http://www.arroyosfoothills.org/	Non Governmental Organization 10	3000	Arroyos and Foothills Conservancy 370	Non Profit 6	Non Profit - Land Trust 10	http://www.arroyosfoothills.org/millard/	Los Angeles 6	13.581	Millard Canyon OS	Private Recreation or Education 65	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]);