calands: units_with_maps: 2 rows where ACCESS_TYP = 1, GAP_STS = 2 and MNG

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

2 rows where ACCESS_TYP = 1, GAP_STS = 2 and MNG_AGENCY = 814

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
9658	9658	9657	{"type": "Polygon", "coordinates": [[[-122.76949, 38.74085], [-122.76573, 38.73744], [-122.76241, 38.73972], [-122.7624, 38.73911], [-122.75779, 38.73936], [-122.7577, 38.73559], [-122.75417, 38.73553], [-122.75429, 38.73194], [-122.75071, 38.73192], [-122.75078, 38.72832], [-122.74803, 38.7283], [-122.74762, 38.72114], [-122.7511, 38.72112], [-122.7511, 38.71423], [-122.75872, 38.7141], [-122.75911, 38.70825], [-122.75919, 38.70742], [-122.7593, 38.69993], [-122.76654, 38.70011], [-122.76878, 38.70013], [-122.76879, 38.70105], [-122.76855, 38.70749], [-122.76741, 38.72074], [-122.76737, 38.72247], [-122.76682, 38.72313], [-122.76686, 38.72316], [-122.76696, 38.72317], [-122.76707, 38.72315], [-122.76729, 38.72306], [-122.76741, 38.72306], [-122.76753, 38.72308], [-122.76767, 38.72317], [-122.76773, 38.72325], [-122.76776, 38.72333], [-122.76782, 38.72339], [-122.7679, 38.72344], [-122.7681, 38.72349], [-122.76816, 38.72353], [-122.76823, 38.72361], [-122.76824, 38.72369], [-122.76821, 38.72384], [-122.76816, 38.72393], [-122.76783, 38.72437], [-122.76778, 38.72447], [-122.76776, 38.72456], [-122.76776, 38.72466], [-122.76784, 38.72482], [-122.76781, 38.72493], [-122.76774, 38.72498], [-122.76765, 38.725], [-122.76759, 38.72499], [-122.76735, 38.7249], [-122.76731, 38.72491], [-122.76703, 38.73525], [-122.76936, 38.73517], [-122.76949, 38.74085]]]}	Open Access 1	16287	Modini Mayacamas Preserves	383	3005	Audubon Canyon Ranch 837	Non Profit 6	Non Profit - Conservation 12	http://www.egret.org	Non Governmental Organization 10	3005	Audubon Canyon Ranch 814	Non Profit 6	Non Profit - Conservation 12	http://egret.org/visit_modini_mayacamas	Sonoma 16	1278.975	Modini Mayacamas Preserves	0	Private Conservation 16	2
14822	14822	14821	{"type": "Polygon", "coordinates": [[[-122.69118, 37.9329], [-122.68888, 37.93441], [-122.67482, 37.94751], [-122.66036, 37.93681], [-122.66163, 37.93601], [-122.66163, 37.93599], [-122.65724, 37.93353], [-122.65725, 37.9335], [-122.6572, 37.93347], [-122.65775, 37.93261], [-122.65787, 37.93201], [-122.66228, 37.92912], [-122.66557, 37.92719], [-122.66568, 37.92715], [-122.66657, 37.92673], [-122.66708, 37.92652], [-122.66955, 37.92521], [-122.67289, 37.92396], [-122.67443, 37.92344], [-122.67464, 37.92389], [-122.67503, 37.92435], [-122.67516, 37.9246], [-122.67551, 37.92494], [-122.67583, 37.92515], [-122.67596, 37.92522], [-122.67608, 37.92525], [-122.67657, 37.92529], [-122.677, 37.92529], [-122.67779, 37.9252], [-122.67879, 37.92521], [-122.67907, 37.92527], [-122.67913, 37.92531], [-122.67927, 37.92537], [-122.67975, 37.92569], [-122.6799, 37.92577], [-122.68007, 37.92582], [-122.6803, 37.92595], [-122.68035, 37.926], [-122.6804, 37.92609], [-122.68043, 37.92618], [-122.68043, 37.92635], [-122.68049, 37.92644], [-122.68101, 37.927], [-122.68148, 37.92737], [-122.68185, 37.92762], [-122.68199, 37.92778], [-122.68205, 37.92791], [-122.68208, 37.92809], [-122.68207, 37.92836], [-122.68203, 37.92864], [-122.682, 37.92902], [-122.68201, 37.92914], [-122.68206, 37.92934], [-122.68211, 37.92948], [-122.68223, 37.92966], [-122.68246, 37.92987], [-122.68274, 37.93004], [-122.68314, 37.93023], [-122.68387, 37.93053], [-122.68406, 37.93058], [-122.68427, 37.9306], [-122.68457, 37.93059], [-122.68522, 37.93045], [-122.68529, 37.93085], [-122.68565, 37.93107], [-122.68592, 37.93102], [-122.68642, 37.93039], [-122.68675, 37.93041], [-122.68792, 37.93056], [-122.68821, 37.93071], [-122.68836, 37.93086], [-122.68845, 37.931], [-122.68849, 37.93113], [-122.68851, 37.93133], [-122.68849, 37.93148], [-122.68841, 37.93167], [-122.68843, 37.93199], [-122.68855, 37.93222], [-122.68876, 37.93235], [-122.68919, 37.93253], [-122.68963, 37.93266], [-122.68999, 37.9327], [-122.69036, 37.93269], [-122.69081, 37.93262], [-122.69093, 37.93264], [-122.69104, 37.93271], [-122.69118, 37.9329]]]}	Open Access 1	45281	Martin Griffin Preserve	21904	3005	Audubon Canyon Ranch 837	Non Profit 6	Non Profit - Conservation 12	http://www.egret.org	Non Governmental Organization 10	3005	Audubon Canyon Ranch 814	Non Profit 6	Non Profit - Conservation 12		Marin 23	1010.785	Martin Griffin Preserve	0	Private Conservation 16	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]);