calands: units_with_maps: 3 rows where ACCESS

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

3 rows where ACCESS_TYP = 2 and COUNTY = 40

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
4139	4139	4138	{"type": "Polygon", "coordinates": [[[-122.90649, 39.12768], [-122.90618, 39.12768], [-122.9046, 39.12644], [-122.90082, 39.12692], [-122.89809, 39.12555], [-122.89808, 39.12413], [-122.89595, 39.12354], [-122.89528, 39.12245], [-122.89444, 39.12212], [-122.8971, 39.11987], [-122.8989, 39.11997], [-122.901, 39.12067], [-122.90099, 39.11847], [-122.89935, 39.11803], [-122.89935, 39.11656], [-122.89985, 39.1164], [-122.90008, 39.11636], [-122.9003, 39.11634], [-122.90053, 39.11634], [-122.90076, 39.11637], [-122.90098, 39.11642], [-122.90127, 39.11653], [-122.90144, 39.11662], [-122.90229, 39.11767], [-122.90276, 39.11893], [-122.90293, 39.11971], [-122.90315, 39.12079], [-122.9033, 39.12131], [-122.90345, 39.12177], [-122.90355, 39.12197], [-122.90368, 39.12217], [-122.90515, 39.12392], [-122.90537, 39.12427], [-122.90551, 39.12458], [-122.90609, 39.12665], [-122.90649, 39.12768]]]}	Restricted Access 2	47467	Rodman Preserve	31186	3264	Lake County Land Trust 586	Non Profit 6	Non Profit - Land Trust 10	http://www.lakecountylandtrust.org/index.htm	Non Governmental Organization 10	3264	Lake County Land Trust 576	Non Profit 6	Non Profit - Land Trust 10		Lake 40	141.594	Rodman Preserve	Private Conservation 16	2
8348	8348	8347	{"type": "MultiPolygon", "coordinates": [[[[-122.41094, 38.85388], [-122.4109, 38.86064], [-122.41064, 38.86043], [-122.41045, 38.86031], [-122.40971, 38.85998], [-122.40952, 38.85988], [-122.40712, 38.85804], [-122.40687, 38.85789], [-122.40358, 38.85648], [-122.40329, 38.85638], [-122.40383, 38.85581], [-122.40383, 38.8558], [-122.40339, 38.85564], [-122.40303, 38.85564], [-122.40277, 38.85567], [-122.40247, 38.85568], [-122.402, 38.85586], [-122.40174, 38.85591], [-122.4014, 38.85577], [-122.40121, 38.85547], [-122.40099, 38.85506], [-122.40086, 38.85472], [-122.40053, 38.85448], [-122.40009, 38.85431], [-122.39986, 38.85425], [-122.39967, 38.85404], [-122.39955, 38.85379], [-122.41094, 38.85388]]], [[[-122.41361, 38.86493], [-122.4059, 38.8649], [-122.40599, 38.86091], [-122.40127, 38.86083], [-122.40125, 38.86271], [-122.39731, 38.86263], [-122.4032, 38.85648], [-122.40351, 38.85657], [-122.40679, 38.85797], [-122.40702, 38.85812], [-122.40943, 38.85996], [-122.40964, 38.86008], [-122.41038, 38.86041], [-122.41067, 38.8606], [-122.4109, 38.86083], [-122.4109, 38.86098], [-122.411, 38.86098], [-122.41104, 38.86105], [-122.41215, 38.86347], [-122.41234, 38.86382], [-122.4126, 38.86414], [-122.4128, 38.86433], [-122.41303, 38.86451], [-122.41361, 38.86493]]], [[[-122.42422, 38.87573], [-122.42408, 38.87585], [-122.41522, 38.87548], [-122.41522, 38.87045], [-122.4174, 38.87051], [-122.41776, 38.87075], [-122.41802, 38.87089], [-122.42, 38.87169], [-122.42023, 38.87181], [-122.42044, 38.87195], [-122.42062, 38.87211], [-122.42078, 38.87229], [-122.42091, 38.87248], [-122.421, 38.87268], [-122.4216, 38.87421], [-122.42178, 38.87453], [-122.42203, 38.87482], [-122.42235, 38.87507], [-122.42259, 38.87521], [-122.42284, 38.87532], [-122.42311, 38.87541], [-122.42422, 38.87573]]], [[[-122.44673, 38.8798], [-122.44346, 38.87981], [-122.44345, 38.87995], [-122.44277, 38.87981], [-122.43966, 38.8804], [-122.43894, 38.88033], [-122.43696, 38.87922], [-122.43486, 38.87902], [-122.43409, 38.87868], [-122.43283, 38.8773], [-122.43267, 38.87716], [-122.43248, 38.87704], [-122.43216, 38.8769], [-122.43193, 38.87684], [-122.4317, 38.8768], [-122.43146, 38.87678], [-122.43125, 38.87679], [-122.43105, 38.87682], [-122.42927, 38.87726], [-122.42901, 38.87732], [-122.4288, 38.87734], [-122.42857, 38.87735], [-122.42823, 38.87731], [-122.42801, 38.87725], [-122.42771, 38.87711], [-122.4265, 38.87633], [-122.42616, 38.87617], [-122.42316, 38.87531], [-122.42289, 38.87522], [-122.42264, 38.8751], [-122.42241, 38.87497], [-122.42222, 38.87482], [-122.42204, 38.87465], [-122.42183, 38.87437], [-122.42173, 38.87417], [-122.42109, 38.87254], [-122.42092, 38.87226], [-122.42069, 38.872], [-122.4204, 38.87177], [-122.42007, 38.87159], [-122.41823, 38.87085], [-122.41796, 38.87073], [-122.41771, 38.87058], [-122.41748, 38.87042], [-122.41727, 38.87024], [-122.4171, 38.87004], [-122.41688, 38.86972], [-122.41623, 38.86846], [-122.41606, 38.86816], [-122.41431, 38.86544], [-122.4141, 38.86519], [-122.41381, 38.86493], [-122.41291, 38.86426], [-122.41262, 38.86397], [-122.41247, 38.86376], [-122.41228, 38.86343], [-122.41116, 38.86099], [-122.41549, 38.86112], [-122.41551, 38.85757], [-122.42008, 38.85771], [-122.42945, 38.85792], [-122.42944, 38.87069], [-122.43174, 38.87069], [-122.4321, 38.87105], [-122.43243, 38.87134], [-122.43274, 38.87195], [-122.43308, 38.87236], [-122.4334, 38.87257], [-122.43375, 38.87276], [-122.43413, 38.87264], [-122.43498, 38.87277], [-122.4339, 38.87337], [-122.4331, 38.87389], [-122.4331, 38.87391], [-122.43337, 38.87416], [-122.43348, 38.87422], [-122.4335, 38.8744], [-122.43748, 38.87427], [-122.43935, 38.87519], [-122.44673, 38.8798]]]]}	Restricted Access 2	48476	McLaughlin Natural Reserve	33195	217	University of California 53	State 5	State Agency 5	http://nrs.ucop.edu/	Other State 5	217	University of California 51	State 5	State Agency 5	https://ucnrs.org/reserves/mclaughlin-natural-reserve/	Lake 40	1035.449	McLaughlin Natural Reserve	State Conservation Area 8	2
11200	11200	11199	{"type": "MultiPolygon", "coordinates": [[[[-122.78322, 38.88894], [-122.7821, 38.88893], [-122.7821, 38.88936], [-122.77831, 38.88934], [-122.77825, 38.8897], [-122.77754, 38.88952], [-122.77411, 38.8901], [-122.77186, 38.88911], [-122.77094, 38.88785], [-122.77079, 38.88756], [-122.77, 38.88635], [-122.77001, 38.88564], [-122.7713, 38.88488], [-122.77156, 38.88428], [-122.77195, 38.88359], [-122.77257, 38.88479], [-122.77342, 38.884], [-122.77604, 38.88439], [-122.77794, 38.88353], [-122.77793, 38.88313], [-122.7784, 38.88299], [-122.77851, 38.88299], [-122.77863, 38.88301], [-122.77877, 38.88308], [-122.77914, 38.88341], [-122.78015, 38.88387], [-122.78066, 38.88421], [-122.78111, 38.88456], [-122.78158, 38.88497], [-122.78167, 38.88507], [-122.78173, 38.88519], [-122.78176, 38.88537], [-122.78182, 38.88548], [-122.78193, 38.88555], [-122.78217, 38.88565], [-122.78223, 38.88571], [-122.78274, 38.88682], [-122.78284, 38.88712], [-122.7829, 38.88745], [-122.78307, 38.88781], [-122.78313, 38.88841], [-122.78322, 38.88894]]], [[[-122.77932, 38.8827], [-122.77932, 38.8834], [-122.77917, 38.88331], [-122.7788, 38.88299], [-122.77866, 38.88293], [-122.77854, 38.8829], [-122.77932, 38.8827]]]]}	Restricted Access 2	21515	Boggs Lake Preserve	32435	3091	The Nature Conservancy 63	Non Profit 6	Non Profit - Land Trust 10	http://www.nature.org/	Non Governmental Organization 10	3264	Lake County Land Trust 576	Non Profit 6	Non Profit - Land Trust 10	http://www.lakecountylandtrust.org/boggs-lake.html	Lake 40	153.099	Boggs Lake Preserve	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]);