calands: units_with_maps: 6 rows where COUNTY = 40 and MNG_AG

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

6 rows where COUNTY = 40 and MNG_AG_TYP = 10

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
2820	2820	2819	{"type": "Polygon", "coordinates": [[[-122.5547, 39.07288], [-122.54077, 39.07244], [-122.52192, 39.07296], [-122.51717, 39.07356], [-122.51634, 39.05553], [-122.52099, 39.05524], [-122.52083, 39.05168], [-122.53935, 39.05086], [-122.54017, 39.06525], [-122.54047, 39.06885], [-122.55439, 39.06917], [-122.5547, 39.07288]]]}	Open Access 1	48614	Silver Spur Ranch	33328	3095	Tuleyome 558	Non Profit 6	Non Profit - Land Trust 10	http://www.tuleyome.org/	Non Governmental Organization 10	3095	Tuleyome 551	Non Profit 6	Non Profit - Land Trust 10	http://tuleyome.org/properties/	Lake 40	1270.865	Silver Spur Ranch	2016	Private Conservation 16	2
3113	3113	3112	{"type": "Polygon", "coordinates": [[[-122.87912, 39.02968], [-122.87717, 39.0297], [-122.87715, 39.02211], [-122.87898, 39.02212], [-122.87912, 39.02968]]]}	Open Access 1	48007	Melo Property	32436	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	http://www.lakecountylandtrust.org/melo-property.html	Lake 40	34.018	Melo Property	0	Private Conservation 16	2
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	0	Private Conservation 16	2
10516	10516	10515	{"type": "MultiPolygon", "coordinates": [[[[-122.62172, 38.74983], [-122.621, 38.7506], [-122.61962, 38.74987], [-122.61923, 38.75071], [-122.61868, 38.75057], [-122.61889, 38.75006], [-122.61877, 38.74937], [-122.61888, 38.74914], [-122.61914, 38.74921], [-122.61928, 38.74891], [-122.61927, 38.7489], [-122.61903, 38.74883], [-122.61921, 38.74847], [-122.62033, 38.74867], [-122.62172, 38.74983]]], [[[-122.62042, 38.75135], [-122.6203, 38.75152], [-122.61968, 38.75136], [-122.61983, 38.75103], [-122.61992, 38.75106], [-122.62042, 38.75135]]]]}	Open Access 1	48611	Rabbit Hill	33326	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	http://www.lakecountylandtrust.org	Lake 40	9.708	Rabbit Hill	1999	Private Conservation 16	2
10539	10539	10538	{"type": "MultiPolygon", "coordinates": [[[[-122.70762, 39.22992], [-122.70761, 39.23359], [-122.70258, 39.23362], [-122.69033, 39.23329], [-122.6873, 39.23318], [-122.68712, 39.22951], [-122.68979, 39.22966], [-122.70275, 39.23006], [-122.70762, 39.22992]]], [[[-122.72176, 39.22676], [-122.71711, 39.22651], [-122.71709, 39.23007], [-122.72173, 39.23039], [-122.72174, 39.23412], [-122.71241, 39.23361], [-122.71239, 39.22983], [-122.70762, 39.22992], [-122.70772, 39.22628], [-122.71247, 39.22625], [-122.71253, 39.21919], [-122.72176, 39.21953], [-122.72176, 39.22676]]], [[[-122.70289, 39.24409], [-122.70288, 39.24064], [-122.71237, 39.24126], [-122.71233, 39.24508], [-122.7125, 39.2489], [-122.7031, 39.2481], [-122.70289, 39.24409]]]]}	Open Access 1	48615	Goat Mountain Property	33329	3095	Tuleyome 558	Non Profit 6	Non Profit - Land Trust 10	http://www.tuleyome.org/	Non Governmental Organization 10	3095	Tuleyome 551	Non Profit 6	Non Profit - Land Trust 10	http://tuleyome.org/properties/	Lake 40	663.188	Goat Mtn. Property	2011	Private Conservation 16	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	0	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]);