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

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

1 row where DES_TP = 14 and MNG_AGENCY = 147

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
3942	3942	3941	{"type": "Polygon", "coordinates": [[[-121.96018, 38.34251], [-121.95925, 38.34317], [-121.95888, 38.3435], [-121.95879, 38.34331], [-121.95865, 38.34325], [-121.95856, 38.34319], [-121.95843, 38.34306], [-121.95841, 38.3429], [-121.95844, 38.34278], [-121.95839, 38.34272], [-121.95832, 38.34273], [-121.95806, 38.34289], [-121.95744, 38.34313], [-121.95728, 38.34315], [-121.95708, 38.34314], [-121.95687, 38.3431], [-121.95677, 38.34313], [-121.95666, 38.3432], [-121.95654, 38.34332], [-121.95649, 38.34339], [-121.95645, 38.3435], [-121.95622, 38.34364], [-121.95602, 38.3438], [-121.95594, 38.34394], [-121.95593, 38.3442], [-121.9559, 38.34432], [-121.95572, 38.34448], [-121.95548, 38.34459], [-121.95519, 38.34469], [-121.95466, 38.34491], [-121.9543, 38.34514], [-121.95404, 38.34527], [-121.95334, 38.3455], [-121.95335, 38.34531], [-121.95334, 38.34466], [-121.95369, 38.34465], [-121.95405, 38.34447], [-121.9543, 38.34445], [-121.9545, 38.34439], [-121.95493, 38.34439], [-121.95497, 38.34427], [-121.95506, 38.34424], [-121.95534, 38.34422], [-121.95571, 38.34376], [-121.95574, 38.34359], [-121.95582, 38.34356], [-121.95586, 38.3435], [-121.9559, 38.34349], [-121.95614, 38.34326], [-121.95648, 38.34299], [-121.95649, 38.34293], [-121.95655, 38.34289], [-121.95662, 38.3429], [-121.9568, 38.34276], [-121.95782, 38.34275], [-121.95823, 38.34253], [-121.95852, 38.34243], [-121.95867, 38.34241], [-121.96018, 38.34251]]]}	Open Access 1	36342	Vacaville holding 1	26753	1364	Vacaville, City of 151	City 2	City Agency 2	http://www.cityofvacaville.com/index.aspx?page=374	City 2	1364	Vacaville, City of 147	City 2	City Agency 2		Solano 26	8.609	Vacaville holding 1	0	Local Other or Unknown 14	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]);