calands: units_with_maps: 1 row where COUNTY = 48 and MNG

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

1 row where COUNTY = 48 and MNG_AGENCY = 320

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
14374	14374	14373	{"type": "Polygon", "coordinates": [[[-119.66327, 37.0625], [-119.66314, 37.06353], [-119.66138, 37.0647], [-119.65862, 37.06474], [-119.65876, 37.07194], [-119.64975, 37.0721], [-119.64984, 37.07601], [-119.64542, 37.07604], [-119.64531, 37.07218], [-119.64087, 37.07225], [-119.64076, 37.0686], [-119.64049, 37.053], [-119.64067, 37.05309], [-119.64084, 37.05329], [-119.64091, 37.05368], [-119.64137, 37.05397], [-119.64155, 37.05409], [-119.64166, 37.05429], [-119.64168, 37.05442], [-119.64189, 37.05453], [-119.64209, 37.05451], [-119.64242, 37.05471], [-119.64319, 37.05515], [-119.64338, 37.05528], [-119.64368, 37.05533], [-119.64414, 37.05549], [-119.64445, 37.05564], [-119.64456, 37.05593], [-119.64467, 37.05587], [-119.64518, 37.05592], [-119.64575, 37.05609], [-119.64606, 37.05627], [-119.64647, 37.0567], [-119.64632, 37.05755], [-119.64625, 37.0577], [-119.64649, 37.05762], [-119.64746, 37.05767], [-119.64828, 37.05787], [-119.64877, 37.05812], [-119.64917, 37.05849], [-119.64981, 37.059], [-119.64991, 37.05929], [-119.64999, 37.05943], [-119.64993, 37.05955], [-119.65011, 37.0597], [-119.65024, 37.05986], [-119.65022, 37.06019], [-119.65016, 37.06064], [-119.65058, 37.06084], [-119.6507, 37.06075], [-119.65074, 37.06087], [-119.65113, 37.06158], [-119.65127, 37.06211], [-119.65114, 37.0625], [-119.65108, 37.063], [-119.65074, 37.06296], [-119.65049, 37.063], [-119.65052, 37.06319], [-119.65116, 37.06333], [-119.65152, 37.06315], [-119.65151, 37.06273], [-119.65166, 37.06234], [-119.65174, 37.06197], [-119.65093, 37.06041], [-119.65092, 37.06034], [-119.65094, 37.06009], [-119.65099, 37.05981], [-119.6508, 37.05948], [-119.65095, 37.05925], [-119.65064, 37.05925], [-119.65048, 37.05896], [-119.65048, 37.05875], [-119.65036, 37.05826], [-119.65003, 37.05815], [-119.64985, 37.05791], [-119.64996, 37.05748], [-119.64973, 37.05721], [-119.64972, 37.05698], [-119.64952, 37.05698], [-119.64932, 37.05686], [-119.64903, 37.05672], [-119.64899, 37.05653], [-119.64873, 37.05661], [-119.64832, 37.05646], [-119.64797, 37.05623], [-119.6478, 37.05604], [-119.64751, 37.05606], [-119.64684, 37.05557], [-119.64648, 37.05521], [-119.64632, 37.05497], [-119.64616, 37.05498], [-119.64605, 37.05492], [-119.64586, 37.05475], [-119.64566, 37.05477], [-119.64545, 37.05476], [-119.64466, 37.05454], [-119.6443, 37.05433], [-119.64417, 37.05419], [-119.64383, 37.0541], [-119.64187, 37.05206], [-119.64172, 37.05176], [-119.64163, 37.05133], [-119.64169, 37.05115], [-119.64213, 37.05093], [-119.64393, 37.05058], [-119.64468, 37.05119], [-119.64492, 37.05133], [-119.64411, 37.052], [-119.64408, 37.05209], [-119.64449, 37.05224], [-119.64459, 37.05232], [-119.64473, 37.05273], [-119.64537, 37.05225], [-119.64593, 37.05232], [-119.64594, 37.05245], [-119.64589, 37.05279], [-119.64632, 37.05262], [-119.64668, 37.05269], [-119.64683, 37.0533], [-119.64729, 37.05316], [-119.64884, 37.05419], [-119.64893, 37.0543], [-119.649, 37.05436], [-119.64916, 37.05442], [-119.64937, 37.05445], [-119.64961, 37.05443], [-119.64984, 37.05438], [-119.64999, 37.05439], [-119.65031, 37.05447], [-119.6505, 37.05446], [-119.65089, 37.05442], [-119.65109, 37.05444], [-119.65197, 37.05508], [-119.65199, 37.06247], [-119.6541, 37.06247], [-119.65525, 37.06358], [-119.65853, 37.06243], [-119.66327, 37.0625]]]}	Open Access 1	44460	Austin and Mary Ewell Fine Gold Creek Preserve	29215	3077	Sierra Foothill Conservancy 323	Non Profit 6	Non Profit - Land Trust 10	http://www.sierrafoothill.org/	Non Governmental Organization 10	3077	Sierra Foothill Conservancy 320	Non Profit 6	Non Profit - Land Trust 10	http://awww.sierrafoothill.org/index.php/land/preserves/austin-mary-ewell-preserve	Madera 48	703.543	Austin and Mary Ewell Fine Gold Creek 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]);