calands: units_with_maps: 1 row where ACCESS_TYP = 1, ACRES = "900.128" and MNG_AG

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

1 row where ACCESS_TYP = 1, ACRES = "900.128" and MNG_AG_TYP = 10

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
7785	7785	7784	{"type": "MultiPolygon", "coordinates": [[[[-119.35775, 36.7922], [-119.35745, 36.80727], [-119.35308, 36.80684], [-119.34872, 36.80638], [-119.34431, 36.80596], [-119.3443, 36.8024], [-119.34425, 36.79888], [-119.33994, 36.79844], [-119.33987, 36.79126], [-119.34882, 36.79175], [-119.35775, 36.7922]]], [[[-119.38439, 36.80548], [-119.38364, 36.8062], [-119.38228, 36.80712], [-119.37982, 36.80713], [-119.37991, 36.81081], [-119.37752, 36.81081], [-119.37751, 36.81082], [-119.37752, 36.81201], [-119.38127, 36.81266], [-119.37942, 36.81404], [-119.3791, 36.81443], [-119.37911, 36.81444], [-119.38353, 36.81447], [-119.38367, 36.8181], [-119.37755, 36.81815], [-119.37668, 36.81728], [-119.37564, 36.81744], [-119.37559, 36.81523], [-119.37558, 36.81524], [-119.37558, 36.81544], [-119.37541, 36.81538], [-119.37524, 36.8153], [-119.37508, 36.81516], [-119.37497, 36.81503], [-119.37469, 36.81485], [-119.37448, 36.81479], [-119.37426, 36.81476], [-119.37394, 36.81477], [-119.37358, 36.81475], [-119.37328, 36.81468], [-119.37307, 36.8146], [-119.37281, 36.81452], [-119.37253, 36.81449], [-119.37241, 36.8145], [-119.37226, 36.81454], [-119.37205, 36.81466], [-119.37188, 36.81486], [-119.37176, 36.8152], [-119.37159, 36.81538], [-119.37121, 36.8154], [-119.37084, 36.81547], [-119.37066, 36.81553], [-119.37041, 36.81565], [-119.37027, 36.8157], [-119.37007, 36.8157], [-119.36974, 36.81561], [-119.36939, 36.8156], [-119.36925, 36.81562], [-119.36914, 36.81562], [-119.36902, 36.81559], [-119.36888, 36.81553], [-119.36852, 36.81548], [-119.36817, 36.81547], [-119.36785, 36.8155], [-119.36757, 36.81556], [-119.36734, 36.81562], [-119.36667, 36.81592], [-119.36602, 36.81615], [-119.36562, 36.81638], [-119.36514, 36.81655], [-119.36469, 36.81659], [-119.36323, 36.81661], [-119.36286, 36.8167], [-119.36247, 36.81676], [-119.362, 36.8168], [-119.36154, 36.8168], [-119.35761, 36.81746], [-119.35753, 36.81439], [-119.37107, 36.81441], [-119.3711, 36.81082], [-119.37544, 36.8108], [-119.37533, 36.80713], [-119.37615, 36.80712], [-119.37617, 36.80512], [-119.37668, 36.80432], [-119.3763, 36.80397], [-119.3762, 36.80344], [-119.37672, 36.80284], [-119.37728, 36.80262], [-119.37744, 36.80226], [-119.37729, 36.80189], [-119.37745, 36.80124], [-119.38434, 36.80354], [-119.38442, 36.80466], [-119.38439, 36.80548]]]]}	Open Access 1	8692	Tivy Mountain Preserve	12510	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/tivy-mountain-pres/	Fresno 9	900.128	Tivy Mtn. 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]);