calands: units_with_maps: 1 row where MNG_AGENCY = 59, MNG_AG_TYP = 1 and YR

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

1 row where MNG_AGENCY = 59, MNG_AG_TYP = 1 and YR_EST = 1908

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
15780	15780	15779	{"type": "MultiPolygon", "coordinates": [[[[-122.56517, 37.89013], [-122.56502, 37.89019], [-122.56474, 37.89038], [-122.56387, 37.89083], [-122.56353, 37.8913], [-122.56354, 37.8914], [-122.56331, 37.8916], [-122.56306, 37.89183], [-122.56293, 37.89173], [-122.56263, 37.89169], [-122.56228, 37.89177], [-122.56183, 37.89176], [-122.56161, 37.89181], [-122.56147, 37.89182], [-122.56183, 37.89152], [-122.56198, 37.89147], [-122.56229, 37.89147], [-122.5625, 37.89141], [-122.56272, 37.89119], [-122.56326, 37.89052], [-122.56325, 37.89043], [-122.56319, 37.89029], [-122.56302, 37.89007], [-122.56288, 37.88998], [-122.56293, 37.88995], [-122.56318, 37.88984], [-122.56346, 37.88983], [-122.56371, 37.88995], [-122.564, 37.88987], [-122.56422, 37.88973], [-122.5645, 37.88958], [-122.5648, 37.88965], [-122.56517, 37.89013]]], [[[-122.5691, 37.89149], [-122.56853, 37.89143], [-122.56812, 37.89149], [-122.56792, 37.89158], [-122.56773, 37.89174], [-122.56769, 37.89174], [-122.56767, 37.89163], [-122.56752, 37.89117], [-122.56679, 37.89087], [-122.56606, 37.89078], [-122.56569, 37.89078], [-122.56505, 37.8911], [-122.56493, 37.89138], [-122.56489, 37.89158], [-122.56477, 37.89151], [-122.56454, 37.89152], [-122.56394, 37.89183], [-122.56356, 37.89224], [-122.56321, 37.89248], [-122.56327, 37.89283], [-122.56335, 37.89308], [-122.56334, 37.89319], [-122.56321, 37.89345], [-122.5632, 37.89352], [-122.56318, 37.89345], [-122.56304, 37.89328], [-122.56289, 37.89318], [-122.56272, 37.89294], [-122.56267, 37.89296], [-122.56285, 37.89322], [-122.56298, 37.89331], [-122.5631, 37.89347], [-122.56316, 37.89364], [-122.56307, 37.89361], [-122.5629, 37.89346], [-122.56268, 37.89339], [-122.56234, 37.89345], [-122.56202, 37.8936], [-122.5619, 37.8938], [-122.56196, 37.89355], [-122.56213, 37.89336], [-122.56224, 37.89313], [-122.5623, 37.89297], [-122.56224, 37.89295], [-122.56208, 37.89332], [-122.56191, 37.89352], [-122.56174, 37.89395], [-122.56171, 37.8937], [-122.56173, 37.89331], [-122.56171, 37.89319], [-122.56174, 37.89308], [-122.5619, 37.89282], [-122.56194, 37.89264], [-122.5619, 37.89242], [-122.56174, 37.89219], [-122.56175, 37.892], [-122.56172, 37.8919], [-122.56159, 37.89186], [-122.56184, 37.89181], [-122.56213, 37.89183], [-122.56229, 37.89182], [-122.56264, 37.89174], [-122.56291, 37.89179], [-122.56306, 37.8919], [-122.56357, 37.89145], [-122.56405, 37.89097], [-122.56524, 37.89043], [-122.56589, 37.89026], [-122.5668, 37.89016], [-122.56734, 37.89045], [-122.56823, 37.89119], [-122.5691, 37.89149]]], [[[-122.56548, 37.88924], [-122.56542, 37.88933], [-122.56513, 37.88945], [-122.56483, 37.88955], [-122.56448, 37.88947], [-122.56419, 37.88962], [-122.56396, 37.88977], [-122.56374, 37.88983], [-122.56351, 37.88973], [-122.56316, 37.88974], [-122.56287, 37.88988], [-122.5626, 37.88994], [-122.56226, 37.88944], [-122.56279, 37.8892], [-122.56282, 37.88922], [-122.5649, 37.8887], [-122.56535, 37.88873], [-122.56548, 37.88924]]], [[[-122.56485, 37.89054], [-122.56399, 37.89093], [-122.56392, 37.89087], [-122.56474, 37.89044], [-122.56485, 37.89054]]], [[[-122.56614, 37.8872], [-122.56575, 37.8881], [-122.56563, 37.88805], [-122.56512, 37.88821], [-122.56482, 37.88826], [-122.56454, 37.88819], [-122.56446, 37.88815], [-122.56444, 37.88808], [-122.56463, 37.888], [-122.5651, 37.88789], [-122.56529, 37.88775], [-122.56566, 37.88733], [-122.56599, 37.88722], [-122.56614, 37.8872]]], [[[-122.56671, 37.89011], [-122.56589, 37.89021], [-122.56522, 37.89038], [-122.5649, 37.89052], [-122.56479, 37.89042], [-122.56506, 37.89024], [-122.56548, 37.89006], [-122.56582, 37.88998], [-122.56626, 37.88981], [-122.56642, 37.88971], [-122.56642, 37.88985], [-122.56671, 37.89011]]], [[[-122.5666, 37.88799], [-122.56641, 37.88964], [-122.56623, 37.88976], [-122.56579, 37.88992], [-122.56545, 37.89001], [-122.56519, 37.89012], [-122.56484, 37.88966], [-122.56518, 37.88955], [-122.56551, 37.8894], [-122.56563, 37.88925], [-122.56552, 37.88878], [-122.56581, 37.88865], [-122.56588, 37.88839], [-122.56587, 37.88815], [-122.56578, 37.88811], [-122.56617, 37.88721], [-122.56628, 37.88729], [-122.5666, 37.88799]]], [[[-122.56716, 37.8885], [-122.56707, 37.88852], [-122.56689, 37.88861], [-122.56674, 37.88873], [-122.56665, 37.88886], [-122.56668, 37.88862], [-122.56696, 37.88843], [-122.56714, 37.88844], [-122.56716, 37.8885]]], [[[-122.60125, 37.89745], [-122.59062, 37.90249], [-122.58578, 37.90239], [-122.58266, 37.90128], [-122.5796, 37.90151], [-122.5752, 37.90393], [-122.57224, 37.89663], [-122.57202, 37.89405], [-122.57248, 37.89347], [-122.5724, 37.89296], [-122.57289, 37.89265], [-122.57347, 37.89311], [-122.57679, 37.89115], [-122.57679, 37.89114], [-122.57076, 37.89116], [-122.57044, 37.89173], [-122.56853, 37.89109], [-122.56835, 37.89102], [-122.56819, 37.89093], [-122.56752, 37.89039], [-122.567, 37.89011], [-122.56692, 37.89002], [-122.56688, 37.88996], [-122.56682, 37.88975], [-122.5668, 37.88961], [-122.56688, 37.88892], [-122.56715, 37.88908], [-122.56748, 37.8889], [-122.56757, 37.88899], [-122.56764, 37.8892], [-122.5681, 37.88958], [-122.57257, 37.89027], [-122.57501, 37.89004], [-122.57774, 37.89059], [-122.58434, 37.89507], [-122.58635, 37.89495], [-122.58614, 37.89551], [-122.587, 37.89554], [-122.58961, 37.89712], [-122.59019, 37.89777], [-122.59394, 37.89558], [-122.59453, 37.89505], [-122.59533, 37.89528], [-122.59659, 37.89601], [-122.59733, 37.89584], [-122.59844, 37.89589], [-122.60027, 37.89664], [-122.60125, 37.89745]]], [[[-122.56972, 37.89179], [-122.56915, 37.89309], [-122.56793, 37.89272], [-122.56819, 37.89213], [-122.56779, 37.89185], [-122.56801, 37.89166], [-122.56817, 37.89159], [-122.56853, 37.89154], [-122.56908, 37.8916], [-122.56972, 37.89179]]]]}	Open Access 1	18121	Muir Woods National Monument	14259	108	United States National Park Service 102	Federal 1	Federal Agency 1	http://www.nps.gov/	National Park Service 12	108	United States National Park Service 59	Federal 1	Federal Agency 1	http://www.nps.gov/muwo/index.htm	Marin 23	529.327	Muir Woods NM	1908	National Monument or Landmark 80	3

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]);