calands: units_with_maps: 3 rows where AGNCY_TYP = 1, DES_TP = 4 and MNG_AG

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

3 rows where AGNCY_TYP = 1, DES_TP = 4 and MNG_AG_TYP = 3

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	DES_TP	GAP_STS
5408	5408	5407	{"type": "Polygon", "coordinates": [[[-116.81981, 33.02977], [-116.8111, 33.02981], [-116.81109, 33.03475], [-116.81112, 33.03724], [-116.80247, 33.03726], [-116.80249, 33.03342], [-116.79575, 33.03337], [-116.7939, 33.03338], [-116.78948, 33.03332], [-116.7896, 33.02616], [-116.78509, 33.02618], [-116.78506, 33.0267], [-116.78495, 33.02974], [-116.78077, 33.02975], [-116.78072, 33.03206], [-116.78073, 33.03214], [-116.78051, 33.0373], [-116.77195, 33.03733], [-116.77187, 33.04415], [-116.76347, 33.04418], [-116.7635, 33.04086], [-116.76778, 33.04085], [-116.76776, 33.03734], [-116.77194, 33.03732], [-116.77212, 33.03338], [-116.77631, 33.03336], [-116.77632, 33.03302], [-116.77635, 33.03297], [-116.77634, 33.03283], [-116.77654, 33.02623], [-116.77239, 33.02624], [-116.77253, 33.02267], [-116.77191, 33.00828], [-116.77177, 33.00579], [-116.77467, 33.00636], [-116.78232, 33.01272], [-116.78474, 33.01283], [-116.78474, 33.0184], [-116.7894, 33.01824], [-116.79601, 33.0188], [-116.7999, 33.01916], [-116.79819, 33.0217], [-116.79691, 33.02514], [-116.79561, 33.02902], [-116.7956, 33.02911], [-116.80396, 33.02931], [-116.8139, 33.02775], [-116.81537, 33.0275], [-116.81616, 33.02756], [-116.81691, 33.02777], [-116.81803, 33.02843], [-116.81981, 33.02942], [-116.81981, 33.02977]]]}	Open Access 1	12525	Mt. Gower Preserve	30285	102	United States Bureau of Land Management 1	Federal 1	Federal Agency 1	http://www.blm.gov/wo/st/en.html	US Bureau of Land Management 1	319	San Diego, County of 101	County 3	County Agency 3	http://www.sdparks.org/content/sdparks/en/park-pages/MtGower.html	San Diego 4	1522.886	Mt. Gower Preserve	Local Conservation Area 4	2
6865	6865	6864	{"type": "Polygon", "coordinates": [[[-116.88206, 32.9016], [-116.87735, 32.90152], [-116.87743, 32.90675], [-116.87754, 32.91269], [-116.87364, 32.91266], [-116.87363, 32.91259], [-116.86927, 32.9126], [-116.86073, 32.91264], [-116.86073, 32.91536], [-116.85906, 32.91535], [-116.85857, 32.91537], [-116.84119, 32.9155], [-116.84121, 32.91914], [-116.84126, 32.92277], [-116.83271, 32.92285], [-116.83293, 32.93288], [-116.83278, 32.93287], [-116.83277, 32.93288], [-116.83424, 32.93483], [-116.82384, 32.93501], [-116.8236, 32.92202], [-116.82359, 32.91926], [-116.8236, 32.91642], [-116.83981, 32.91648], [-116.83994, 32.90146], [-116.83993, 32.90145], [-116.82362, 32.90223], [-116.82372, 32.8874], [-116.828, 32.8874], [-116.82799, 32.89121], [-116.83615, 32.89146], [-116.84492, 32.89538], [-116.84472, 32.89861], [-116.84891, 32.89856], [-116.84889, 32.90108], [-116.8525, 32.90092], [-116.85243, 32.90479], [-116.84825, 32.9049], [-116.84828, 32.9088], [-116.85647, 32.90867], [-116.85649, 32.90782], [-116.8565, 32.90482], [-116.86949, 32.9051], [-116.86958, 32.90132], [-116.86968, 32.8984], [-116.86146, 32.89843], [-116.86208, 32.89371], [-116.87781, 32.88967], [-116.87782, 32.89258], [-116.88195, 32.89201], [-116.88202, 32.89926], [-116.88206, 32.9016]]]}	Open Access 1	5516	El Capitan Preserve	30283	102	United States Bureau of Land Management 1	Federal 1	Federal Agency 1	http://www.blm.gov/wo/st/en.html	US Bureau of Land Management 1	319	San Diego, County of 101	County 3	County Agency 3	http://www.sdparks.org/content/sdparks/en/park-pages/ElCapitan.html	San Diego 4	2603.63	El Capitan Preserve	Local Conservation Area 4	2
10493	10493	10492	{"type": "Polygon", "coordinates": [[[-117.86356, 34.41191], [-117.85922, 34.41197], [-117.8592, 34.41731], [-117.86116, 34.41727], [-117.86127, 34.41886], [-117.86348, 34.41886], [-117.86349, 34.42457], [-117.85264, 34.42458], [-117.85248, 34.41725], [-117.84376, 34.41711], [-117.84379, 34.41355], [-117.83502, 34.41335], [-117.83534, 34.39918], [-117.83541, 34.3956], [-117.85252, 34.39557], [-117.85268, 34.40744], [-117.85845, 34.4074], [-117.85845, 34.41018], [-117.86356, 34.41013], [-117.86356, 34.41191]]]}	Open Access 1	18598	Devil's Punchbowl Natural Area	29185	199	Other Federal 284	Federal 1	Federal Agency 1		Other Federal 13	305	Los Angeles, County of 16	County 3	County Agency 3	http://parks.lacounty.gov/wps/portal/dpr/Parks/Devils_Punchbowl_Natural_Area	Los Angeles 6	1235.787	Devil's Punchbowl Natural Area	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]);