calands: units_with_maps: 1 row where COUNTY = 20, DES_TP = 105 and MNG_AG

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

1 row where COUNTY = 20, DES_TP = 105 and MNG_AG_TYP = 1

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
15818	15818	15817	{"type": "MultiPolygon", "coordinates": [[[[-115.8564, 33.23466], [-115.83922, 33.23474], [-115.8392, 33.25007], [-115.83917, 33.25073], [-115.8218, 33.25074], [-115.82184, 33.25008], [-115.82192, 33.23468], [-115.82191, 33.23467], [-115.80462, 33.2347], [-115.80458, 33.25007], [-115.80456, 33.25072], [-115.78727, 33.25067], [-115.78736, 33.23738], [-115.78738, 33.23471], [-115.78737, 33.2347], [-115.77008, 33.23472], [-115.76999, 33.25005], [-115.77001, 33.25062], [-115.76328, 33.25008], [-115.7622, 33.25009], [-115.75249, 33.24929], [-115.75251, 33.23475], [-115.77003, 33.23472], [-115.77007, 33.22016], [-115.77006, 33.22015], [-115.75238, 33.22027], [-115.75247, 33.23475], [-115.73553, 33.23461], [-115.73556, 33.24916], [-115.7356, 33.24917], [-115.7356, 33.2492], [-115.73557, 33.2492], [-115.73555, 33.24917], [-115.71817, 33.24918], [-115.71822, 33.23462], [-115.71831, 33.23462], [-115.7183, 33.2346], [-115.70107, 33.23466], [-115.70103, 33.24915], [-115.70101, 33.24913], [-115.68368, 33.24913], [-115.68367, 33.24914], [-115.6317, 33.24918], [-115.6143, 33.24922], [-115.61437, 33.23472], [-115.63179, 33.23461], [-115.63179, 33.22008], [-115.64885, 33.22008], [-115.6489, 33.20566], [-115.66648, 33.20559], [-115.66654, 33.19099], [-115.68368, 33.19101], [-115.68363, 33.17653], [-115.70082, 33.17656], [-115.70087, 33.16204], [-115.71818, 33.16202], [-115.71809, 33.14748], [-115.73536, 33.14745], [-115.73534, 33.13307], [-115.7524, 33.13311], [-115.7524, 33.14741], [-115.7701, 33.14745], [-115.7701, 33.162], [-115.75236, 33.16202], [-115.75242, 33.14742], [-115.73537, 33.14745], [-115.73539, 33.16205], [-115.75229, 33.16202], [-115.75237, 33.17654], [-115.77015, 33.17658], [-115.78742, 33.17649], [-115.78743, 33.17653], [-115.80478, 33.17657], [-115.80467, 33.19122], [-115.80468, 33.19124], [-115.82194, 33.19111], [-115.82196, 33.1766], [-115.8307, 33.17664], [-115.83059, 33.19111], [-115.82195, 33.19112], [-115.82199, 33.20566], [-115.80463, 33.20569], [-115.80464, 33.20571], [-115.80465, 33.22014], [-115.82195, 33.22016], [-115.82193, 33.23468], [-115.83922, 33.23474], [-115.83921, 33.22019], [-115.85231, 33.22013], [-115.85232, 33.22091], [-115.85639, 33.22091], [-115.8564, 33.23466]], [[-115.73548, 33.22015], [-115.73547, 33.22009], [-115.71827, 33.22006], [-115.71832, 33.23459], [-115.73024, 33.23461], [-115.73552, 33.23461], [-115.73548, 33.22015]], [[-115.75235, 33.20576], [-115.73544, 33.20556], [-115.73548, 33.22009], [-115.75082, 33.22017], [-115.75236, 33.22024], [-115.75235, 33.20576]], [[-115.78738, 33.20571], [-115.77831, 33.20569], [-115.77008, 33.20569], [-115.77008, 33.22015], [-115.78733, 33.22013], [-115.78737, 33.22011], [-115.78738, 33.20571]], [[-115.80464, 33.22015], [-115.80463, 33.22014], [-115.78734, 33.22013], [-115.78738, 33.22809], [-115.78738, 33.23467], [-115.80462, 33.23469], [-115.80464, 33.22015]]], [[[-115.62281, 33.16931], [-115.62279, 33.17662], [-115.61455, 33.17663], [-115.61452, 33.1693], [-115.62281, 33.16931]]], [[[-115.70083, 33.14743], [-115.70077, 33.14744], [-115.70075, 33.16204], [-115.68359, 33.16203], [-115.68356, 33.15473], [-115.69221, 33.15473], [-115.69218, 33.14743], [-115.70076, 33.14743], [-115.70083, 33.14742], [-115.70083, 33.14743]]], [[[-115.71823, 33.07505], [-115.71813, 33.08228], [-115.71817, 33.08229], [-115.71817, 33.0823], [-115.70951, 33.08221], [-115.7096, 33.07496], [-115.70094, 33.07502], [-115.70091, 33.075], [-115.70091, 33.07496], [-115.69903, 33.07352], [-115.69907, 33.06708], [-115.70701, 33.06709], [-115.70702, 33.06715], [-115.70759, 33.06715], [-115.7076, 33.0671], [-115.7122, 33.06709], [-115.71229, 33.06315], [-115.71442, 33.06316], [-115.71437, 33.06709], [-115.71655, 33.06707], [-115.71639, 33.07448], [-115.71644, 33.0746], [-115.71657, 33.07471], [-115.71771, 33.07473], [-115.71792, 33.0749], [-115.71796, 33.07504], [-115.71823, 33.07505]]]]}	Open Access 1	12849	Sonny Bono Salton Sea National Wildlife Refuge	13989	106	United States Fish and Wildlife Service 45	Federal 1	Federal Agency 1	http://www.fws.gov/	US Fish and Wildlife Service 8	106	United States Fish and Wildlife Service 44	Federal 1	Federal Agency 1	http://www.fws.gov/refuge/sonny_bono_salton_sea/	Imperial 20	31831.176	Sonny Bono Salton Sea NWR	1930	National Wildlife Refuge 105	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]);