calands: superunits_with_maps: 4 rows where ACCESS_TYP = 1, LAYER = 10 and MNG

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

4 rows where ACCESS_TYP = 1, LAYER = 10 and MNG_AGENCY = 551

Search:

descending

This data as json, copyable, CSV (advanced)

Link	rowid ▼	id	map	ACCESS_TYP	PARK_NAME	PARK_URL	SUID_NMA	MNG_AG_ID	MNG_AGENCY	MNG_AG_LEV	MNG_AG_TYP	AGNCY_WEB	LAYER	ACRES	LABEL_NAME	YR_EST
3625	3625	3624	{"type": "Polygon", "coordinates": [[[-122.11064, 38.47867], [-122.11067, 38.47899], [-122.11052, 38.47933], [-122.11022, 38.47988], [-122.11006, 38.48009], [-122.10985, 38.48044], [-122.10987, 38.48056], [-122.10992, 38.48061], [-122.10989, 38.48075], [-122.10971, 38.48093], [-122.10952, 38.4811], [-122.10933, 38.48132], [-122.10919, 38.48154], [-122.10907, 38.48178], [-122.10901, 38.48214], [-122.10153, 38.48206], [-122.10152, 38.47858], [-122.11064, 38.47867]]]}	Open Access 1	Cold Canyon Headwaters Property	http://tuleyome.org/properties/	33330	3095	Tuleyome 551	Non Profit 6	Non Profit - Land Trust 10	http://www.tuleyome.org/	Non Governmental Organization 10	69.857	Cold Canyon Headwaters Property	2010
12010	12010	12009	{"type": "Polygon", "coordinates": [[[-122.11574, 38.47849], [-122.1108, 38.47847], [-122.11074, 38.47867], [-122.09694, 38.47855], [-122.09695, 38.47505], [-122.113, 38.47524], [-122.11293, 38.47538], [-122.11294, 38.47539], [-122.1131, 38.47522], [-122.11313, 38.47502], [-122.11317, 38.47487], [-122.1155, 38.47489], [-122.11574, 38.47849]], [[-122.11094, 38.47779], [-122.11096, 38.47779], [-122.111, 38.47767], [-122.11099, 38.47768], [-122.11094, 38.47779]]]}	Open Access 1	Huber Ranch	http://tuleyome.org/properties/	33327	3095	Tuleyome 551	Non Profit 6	Non Profit - Land Trust 10	http://www.tuleyome.org/	Non Governmental Organization 10	154.759	Huber Ranch	2018
12033	12033	12032	{"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.06884], [-122.55439, 39.06917], [-122.5547, 39.07288]]]}	Open Access 1	Silver Spur Ranch	http://tuleyome.org/properties/	33328	3095	Tuleyome 551	Non Profit 6	Non Profit - Land Trust 10	http://www.tuleyome.org/	Non Governmental Organization 10	1270.942	Silver Spur Ranch	2016
15508	15508	15507	{"type": "MultiPolygon", "coordinates": [[[[-122.72176, 39.22676], [-122.71712, 39.22651], [-122.71709, 39.23006], [-122.72173, 39.23039], [-122.72174, 39.23412], [-122.71241, 39.23361], [-122.71239, 39.22984], [-122.71238, 39.22983], [-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.70772, 39.22628], [-122.71247, 39.22624], [-122.71253, 39.21919], [-122.72176, 39.21953], [-122.72176, 39.22676]]], [[[-122.7125, 39.2489], [-122.7031, 39.2481], [-122.70289, 39.24409], [-122.70288, 39.24064], [-122.71237, 39.24126], [-122.71233, 39.24508], [-122.7125, 39.2489]]]]}	Open Access 1	Goat Mountain Property	http://tuleyome.org/properties/	33329	3095	Tuleyome 551	Non Profit 6	Non Profit - Land Trust 10	http://www.tuleyome.org/	Non Governmental Organization 10	663.35	Goat Mtn. Property	2011

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE superunits_with_maps(
  id INT,
  map,
  ACCESS_TYP INT,
  PARK_NAME TEXT,
  PARK_URL TEXT,
  SUID_NMA INT,
  MNG_AG_ID INT,
  MNG_AGENCY INT,
  MNG_AG_LEV INT,
  MNG_AG_TYP INT,
  AGNCY_WEB TEXT,
  LAYER INT,
  ACRES REAL,
  LABEL_NAME TEXT,
  YR_EST INT,
   FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id])
);
CREATE INDEX [idx_superunits_with_maps_LAYER]
    ON [superunits_with_maps] ([LAYER]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP]
    ON [superunits_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV]
    ON [superunits_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY]
    ON [superunits_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP]
    ON [superunits_with_maps] ([ACCESS_TYP]);