calands: units_with_maps: 1 row where COUNTY = 12, DES_TP = 4 and MNG

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

1 row where COUNTY = 12, DES_TP = 4 and MNG_AGENCY = 381

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
6840	6840	6839	{"type": "MultiPolygon", "coordinates": [[[[-122.30443, 37.92294], [-122.30401, 37.92313], [-122.30408, 37.92332], [-122.30401, 37.92354], [-122.30422, 37.92384], [-122.30247, 37.92464], [-122.30208, 37.92435], [-122.29973, 37.92584], [-122.30015, 37.92458], [-122.29997, 37.92377], [-122.30023, 37.92358], [-122.30107, 37.92361], [-122.30108, 37.92359], [-122.30011, 37.92288], [-122.29998, 37.92276], [-122.29934, 37.92321], [-122.29848, 37.92338], [-122.29801, 37.92345], [-122.29781, 37.92284], [-122.29933, 37.92216], [-122.29933, 37.92215], [-122.29867, 37.92156], [-122.298, 37.92088], [-122.29768, 37.92058], [-122.29676, 37.91987], [-122.29594, 37.91938], [-122.29536, 37.91863], [-122.29542, 37.91858], [-122.29552, 37.91835], [-122.29563, 37.91824], [-122.29574, 37.91818], [-122.29619, 37.91812], [-122.29638, 37.91811], [-122.29639, 37.9181], [-122.29634, 37.91803], [-122.29795, 37.91777], [-122.29863, 37.91746], [-122.29868, 37.91752], [-122.29902, 37.91746], [-122.29963, 37.91832], [-122.29917, 37.91854], [-122.29951, 37.91904], [-122.30079, 37.91847], [-122.30149, 37.91962], [-122.30235, 37.92081], [-122.30159, 37.92116], [-122.30263, 37.92258], [-122.30271, 37.92319], [-122.30339, 37.92374], [-122.30374, 37.92358], [-122.30372, 37.92316], [-122.3039, 37.92289], [-122.30419, 37.92257], [-122.30429, 37.92269], [-122.30428, 37.92273], [-122.30443, 37.92294]]], [[[-122.29972, 37.92585], [-122.3003, 37.92643], [-122.30156, 37.92608], [-122.30179, 37.9265], [-122.30186, 37.92649], [-122.30193, 37.92651], [-122.30197, 37.92655], [-122.30199, 37.92659], [-122.30194, 37.92675], [-122.30195, 37.92719], [-122.30192, 37.92725], [-122.30201, 37.92728], [-122.30199, 37.92735], [-122.30192, 37.92734], [-122.302, 37.92757], [-122.3016, 37.92767], [-122.30092, 37.9272], [-122.2999, 37.92708], [-122.29989, 37.92711], [-122.29946, 37.92729], [-122.2987, 37.9265], [-122.29972, 37.92585]]], [[[-122.30876, 37.92785], [-122.30587, 37.9279], [-122.30563, 37.92705], [-122.30492, 37.92648], [-122.30388, 37.92684], [-122.30325, 37.92733], [-122.30314, 37.92723], [-122.30278, 37.92747], [-122.30275, 37.92743], [-122.3031, 37.9272], [-122.30305, 37.92694], [-122.30313, 37.92679], [-122.30358, 37.92614], [-122.30399, 37.92576], [-122.30447, 37.9261], [-122.30716, 37.9249], [-122.30745, 37.92531], [-122.30777, 37.92516], [-122.30746, 37.92476], [-122.30747, 37.92476], [-122.30779, 37.92516], [-122.30781, 37.92572], [-122.30837, 37.92574], [-122.30839, 37.9258], [-122.3081, 37.92596], [-122.30809, 37.92597], [-122.30829, 37.92621], [-122.30868, 37.92621], [-122.30876, 37.92785]]]]}	Open Access 1	47537	Hillside Natural Area	31244	1094	El Cerrito, City of 385	City 2	City Agency 2	http://www.el-cerrito.org/	City 2	1094	El Cerrito, City of 381	City 2	City Agency 2	http://www.el-cerrito.org/index.aspx?NID=812	Contra Costa 12	98.951	Hillside Natural Area	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]);