calands: units_with_maps: 1 row where COUNTY = 27, MNG_AGENCY = 343 and MNG_AG

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

1 row where COUNTY = 27, MNG_AGENCY = 343 and MNG_AG_TYP = 5

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
15544	15544	15543	{"type": "Polygon", "coordinates": [[[-121.74577, 40.66587], [-121.73631, 40.66592], [-121.73651, 40.65277], [-121.73196, 40.65288], [-121.73196, 40.64935], [-121.72222, 40.64928], [-121.72221, 40.64929], [-121.72219, 40.65272], [-121.72703, 40.65284], [-121.72705, 40.65619], [-121.73166, 40.65633], [-121.73149, 40.65943], [-121.72703, 40.65931], [-121.72184, 40.65946], [-121.72208, 40.66267], [-121.71722, 40.66275], [-121.71726, 40.65945], [-121.72183, 40.65945], [-121.72219, 40.65273], [-121.71727, 40.65289], [-121.71717, 40.64927], [-121.71255, 40.64931], [-121.71254, 40.64932], [-121.71276, 40.653], [-121.70823, 40.65276], [-121.70841, 40.65619], [-121.70871, 40.65964], [-121.70328, 40.65924], [-121.70305, 40.65582], [-121.69317, 40.65504], [-121.69338, 40.65868], [-121.69851, 40.65903], [-121.69808, 40.66237], [-121.7031, 40.66261], [-121.70302, 40.666], [-121.70799, 40.66591], [-121.70779, 40.66755], [-121.6983, 40.66764], [-121.69036, 40.66811], [-121.69035, 40.67176], [-121.68117, 40.67176], [-121.68125, 40.66818], [-121.67398, 40.6682], [-121.67317, 40.66373], [-121.67317, 40.65975], [-121.67359, 40.64486], [-121.67359, 40.63132], [-121.66411, 40.63141], [-121.66348, 40.61682], [-121.67317, 40.61676], [-121.68817, 40.61675], [-121.68806, 40.60827], [-121.70656, 40.60993], [-121.70651, 40.60277], [-121.72578, 40.60301], [-121.74524, 40.60284], [-121.74515, 40.61018], [-121.7442, 40.61713], [-121.74445, 40.62108], [-121.72648, 40.62114], [-121.71654, 40.62091], [-121.71653, 40.62092], [-121.71682, 40.62431], [-121.71729, 40.62784], [-121.72682, 40.62787], [-121.73593, 40.62768], [-121.74052, 40.62762], [-121.7456, 40.62762], [-121.74574, 40.63149], [-121.74564, 40.63861], [-121.74642, 40.64601], [-121.74628, 40.65283], [-121.74577, 40.66587]]]}	Open Access 1	10874	Latour Demonstration State Forest	1369	202	California Department of Forestry and Fire Protection 346	State 5	State Agency 5	http://www.fire.ca.gov/	Other State 5	202	California Department of Forestry and Fire Protection 343	State 5	State Agency 5	http://www.fire.ca.gov/resource_mgt/resource_mgt_stateforests_latour.php	Shasta 27	8915.243	Latour DSF	0	State Resource Management Area 55	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]);