calands: units_with_maps: 13 rows where ACCESS_TYP = 3 and MNG

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

13 rows where ACCESS_TYP = 3 and MNG_AGENCY = 622

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	COUNTY	ACRES	LABEL_NAME	DES_TP	GAP_STS
3384	3384	3383	{"type": "Polygon", "coordinates": [[[-121.85546, 37.89221], [-121.85527, 37.89228], [-121.85529, 37.89252], [-121.85529, 37.89268], [-121.85503, 37.89298], [-121.85481, 37.89305], [-121.85461, 37.89329], [-121.85368, 37.89311], [-121.854, 37.8926], [-121.85521, 37.89211], [-121.85544, 37.89196], [-121.85546, 37.89221]]]}	No Public Access 3	35032	Marsh Creek IV	21890	3073	Save Mount Diablo 633	Non Profit 6	Non Profit - Land Trust 10	http://www.savemountdiablo.org/	Non Governmental Organization 10	3073	Save Mount Diablo 622	Non Profit 6	Non Profit - Land Trust 10	Contra Costa 12	2.68	Marsh Creek IV	Private Conservation 16	2
11294	11294	11293	{"type": "Polygon", "coordinates": [[[-121.87723, 37.87595], [-121.87713, 37.87967], [-121.87325, 37.87969], [-121.87295, 37.88075], [-121.87209, 37.88094], [-121.87066, 37.88088], [-121.86824, 37.88066], [-121.86793, 37.88054], [-121.86793, 37.87974], [-121.87, 37.87935], [-121.87009, 37.87846], [-121.87102, 37.8772], [-121.87126, 37.87727], [-121.87139, 37.87722], [-121.87132, 37.87708], [-121.87108, 37.87686], [-121.8716, 37.87614], [-121.87316, 37.87533], [-121.87293, 37.87476], [-121.87379, 37.87476], [-121.87376, 37.87595], [-121.87723, 37.87595]]]}	No Public Access 3	21976	Wright Property	27760	3073	Save Mount Diablo 633	Non Profit 6	Non Profit - Land Trust 10	http://www.savemountdiablo.org/	Non Governmental Organization 10	3073	Save Mount Diablo 622	Non Profit 6	Non Profit - Land Trust 10	Contra Costa 12	76.208	Wright Property	Private Conservation 16	2
13081	13081	13080	{"type": "Polygon", "coordinates": [[[-121.89845, 37.98368], [-121.89706, 37.98369], [-121.89694, 37.97873], [-121.89856, 37.98308], [-121.89858, 37.98316], [-121.89857, 37.98321], [-121.89845, 37.98368]]]}	No Public Access 3	35001	Black Diamond Mines	16132	3073	Save Mount Diablo 633	Non Profit 6	Non Profit - Land Trust 10	http://www.savemountdiablo.org/	Non Governmental Organization 10	3073	Save Mount Diablo 622	Non Profit 6	Non Profit - Land Trust 10	Contra Costa 12	10.101	Black Diamond Mines	Private Conservation 16	2
13082	13082	13081	{"type": "Polygon", "coordinates": [[[-121.87719, 37.88184], [-121.87714, 37.88524], [-121.87705, 37.88526], [-121.87698, 37.88529], [-121.87676, 37.88548], [-121.87245, 37.88546], [-121.87246, 37.88183], [-121.87719, 37.88184]]]}	No Public Access 3	35003	Oak Hill Lane	22978	3073	Save Mount Diablo 633	Non Profit 6	Non Profit - Land Trust 10	http://www.savemountdiablo.org/	Non Governmental Organization 10	3073	Save Mount Diablo 622	Non Profit 6	Non Profit - Land Trust 10	Contra Costa 12	41.248	Oak Hill Lane	Private Conservation 16	2
13087	13087	13086	{"type": "Polygon", "coordinates": [[[-121.75471, 37.90136], [-121.75464, 37.90146], [-121.75417, 37.90192], [-121.75141, 37.90095], [-121.75176, 37.90033], [-121.75471, 37.90136]]]}	No Public Access 3	35029	Dry Creek	18280	3073	Save Mount Diablo 633	Non Profit 6	Non Profit - Land Trust 10	http://www.savemountdiablo.org/	Non Governmental Organization 10	3073	Save Mount Diablo 622	Non Profit 6	Non Profit - Land Trust 10	Contra Costa 12	5.18	Dry Creek	Private Conservation 16	2
13109	13109	13108	{"type": "Polygon", "coordinates": [[[-121.89523, 37.88546], [-121.88592, 37.88547], [-121.88592, 37.88922], [-121.8806, 37.88925], [-121.88062, 37.88182], [-121.89522, 37.88178], [-121.89523, 37.88546]]]}	No Public Access 3	35027	Viera-North Peak	27093	3073	Save Mount Diablo 633	Non Profit 6	Non Profit - Land Trust 10	http://www.savemountdiablo.org/	Non Governmental Organization 10	3073	Save Mount Diablo 622	Non Profit 6	Non Profit - Land Trust 10	Contra Costa 12	177.666	Viera-North Peak	Private Conservation 16	2
13110	13110	13109	{"type": "Polygon", "coordinates": [[[-121.8042, 37.88903], [-121.80069, 37.8909], [-121.80036, 37.89094], [-121.80014, 37.89101], [-121.8, 37.89107], [-121.79998, 37.8907], [-121.80077, 37.88981], [-121.80077, 37.88901], [-121.8042, 37.88903]]]}	No Public Access 3	35028	Marsh Creek I	21888	3073	Save Mount Diablo 633	Non Profit 6	Non Profit - Land Trust 10	http://www.savemountdiablo.org/	Non Governmental Organization 10	3073	Save Mount Diablo 622	Non Profit 6	Non Profit - Land Trust 10	Contra Costa 12	8.954	Marsh Creek I	Private Conservation 16	2
13111	13111	13110	{"type": "Polygon", "coordinates": [[[-121.98061, 37.92304], [-121.98058, 37.92697], [-121.97292, 37.9269], [-121.97296, 37.92378], [-121.96975, 37.92348], [-121.96978, 37.91733], [-121.97977, 37.91719], [-121.97977, 37.91848], [-121.97966, 37.91849], [-121.97964, 37.92304], [-121.98061, 37.92304]]]}	No Public Access 3	35030	Mangini Ranch	21744	3073	Save Mount Diablo 633	Non Profit 6	Non Profit - Land Trust 10	http://www.savemountdiablo.org/	Non Governmental Organization 10	3073	Save Mount Diablo 622	Non Profit 6	Non Profit - Land Trust 10	Contra Costa 12	214.66	Mangini Ranch	Private Conservation 16	2
13112	13112	13111	{"type": "Polygon", "coordinates": [[[-121.91432, 37.90869], [-121.91431, 37.9107], [-121.90951, 37.9107], [-121.90946, 37.90876], [-121.91432, 37.90869]]]}	No Public Access 3	35031	Young Canyon	27788	3073	Save Mount Diablo 633	Non Profit 6	Non Profit - Land Trust 10	http://www.savemountdiablo.org/	Non Governmental Organization 10	3073	Save Mount Diablo 622	Non Profit 6	Non Profit - Land Trust 10	Contra Costa 12	23.027	Young Canyon	Private Conservation 16	2
13113	13113	13112	{"type": "Polygon", "coordinates": [[[-121.85767, 37.89517], [-121.85471, 37.8952], [-121.85439, 37.89624], [-121.85282, 37.89622], [-121.85368, 37.89336], [-121.85582, 37.89378], [-121.85658, 37.89398], [-121.85678, 37.89405], [-121.85694, 37.89415], [-121.85707, 37.89427], [-121.85767, 37.89517]]]}	No Public Access 3	35033	Marsh Creek II	21889	3073	Save Mount Diablo 633	Non Profit 6	Non Profit - Land Trust 10	http://www.savemountdiablo.org/	Non Governmental Organization 10	3073	Save Mount Diablo 622	Non Profit 6	Non Profit - Land Trust 10	Contra Costa 12	17.944	Marsh Creek II	Private Conservation 16	2
14570	14570	14569	{"type": "Polygon", "coordinates": [[[-121.92075, 37.92393], [-121.9207, 37.92397], [-121.92039, 37.9238], [-121.9203, 37.92414], [-121.92003, 37.92424], [-121.91984, 37.92395], [-121.91964, 37.92376], [-121.91951, 37.92367], [-121.91935, 37.92359], [-121.91901, 37.9235], [-121.919, 37.92085], [-121.91954, 37.92244], [-121.91992, 37.92282], [-121.92054, 37.92333], [-121.92036, 37.92371], [-121.92075, 37.92393]]]}	No Public Access 3	44714	Lot 25	28140	3073	Save Mount Diablo 633	Non Profit 6	Non Profit - Land Trust 10	http://www.savemountdiablo.org/	Non Governmental Organization 10	3073	Save Mount Diablo 622	Non Profit 6	Non Profit - Land Trust 10	Contra Costa 12	5.01	Lot 25	Private Conservation 16	2
14823	14823	14822	{"type": "Polygon", "coordinates": [[[-121.84979, 37.89157], [-121.84949, 37.89142], [-121.84917, 37.89133], [-121.84874, 37.89126], [-121.84852, 37.89119], [-121.84832, 37.8911], [-121.84814, 37.891], [-121.84797, 37.89088], [-121.84777, 37.8907], [-121.84768, 37.89056], [-121.84976, 37.88891], [-121.84979, 37.89157]]]}	No Public Access 3	45287	Marsh Creek V	21891	3073	Save Mount Diablo 633	Non Profit 6	Non Profit - Land Trust 10	http://www.savemountdiablo.org/	Non Governmental Organization 10	3073	Save Mount Diablo 622	Non Profit 6	Non Profit - Land Trust 10	Contra Costa 12	7.354	Marsh Creek V	Private Conservation 16	2
14824	14824	14823	{"type": "Polygon", "coordinates": [[[-121.85413, 37.89196], [-121.8541, 37.89216], [-121.85391, 37.89258], [-121.85359, 37.89309], [-121.85291, 37.89291], [-121.853, 37.89278], [-121.85296, 37.89026], [-121.85326, 37.89012], [-121.85368, 37.89116], [-121.85406, 37.89177], [-121.85413, 37.89196]]]}	No Public Access 3	45288	Marsh Creek VI	21892	3073	Save Mount Diablo 633	Non Profit 6	Non Profit - Land Trust 10	http://www.savemountdiablo.org/	Non Governmental Organization 10	3073	Save Mount Diablo 622	Non Profit 6	Non Profit - Land Trust 10	Contra Costa 12	5.462	Marsh Creek VI	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]);