calands: units_with_maps: 2 rows where COUNTY = 45, DES_TP = 16 and MNG

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

2 rows where COUNTY = 45, DES_TP = 16 and MNG_AGENCY = 50

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
5893	5893	5892	{"type": "Polygon", "coordinates": [[[-124.0476, 41.30161], [-124.04702, 41.30206], [-124.04612, 41.30252], [-124.04528, 41.30274], [-124.04622, 41.30429], [-124.04651, 41.30425], [-124.04688, 41.30455], [-124.04662, 41.30539], [-124.04623, 41.30514], [-124.04619, 41.30507], [-124.0461, 41.30505], [-124.04612, 41.30606], [-124.04595, 41.30602], [-124.04503, 41.30596], [-124.04517, 41.30612], [-124.04525, 41.31016], [-124.04507, 41.3112], [-124.04396, 41.3131], [-124.04226, 41.31424], [-124.0411, 41.31599], [-124.04101, 41.31625], [-124.04008, 41.31624], [-124.03943, 41.31654], [-124.03957, 41.31625], [-124.03992, 41.3159], [-124.04058, 41.31577], [-124.04093, 41.31553], [-124.0415, 41.31441], [-124.0425, 41.31351], [-124.04384, 41.31249], [-124.04423, 41.31194], [-124.0446, 41.31063], [-124.04452, 41.3099], [-124.04374, 41.30915], [-124.04234, 41.30856], [-124.04208, 41.30829], [-124.04181, 41.30791], [-124.04152, 41.30769], [-124.03988, 41.30602], [-124.03979, 41.30554], [-124.03971, 41.30484], [-124.03954, 41.30281], [-124.03953, 41.30198], [-124.03979, 41.30125], [-124.04042, 41.30076], [-124.04103, 41.30043], [-124.04173, 41.30022], [-124.04304, 41.30023], [-124.04305, 41.30015], [-124.044, 41.30014], [-124.04458, 41.30009], [-124.04586, 41.3005], [-124.0476, 41.30161]]]}	Unknown Access 4	46786	Orick Mill Site	30240	3074	Save the Redwoods League 52	Non Profit 6	Non Profit - Land Trust 10	http://www.savetheredwoods.org	Non Governmental Organization 10	3074	Save the Redwoods League 50	Non Profit 6	Non Profit - Land Trust 10		Humboldt 45	125.427	Orick Mill Site	0	Private Conservation 16	2
5894	5894	5893	{"type": "Polygon", "coordinates": [[[-124.04065, 41.3174], [-124.03951, 41.32033], [-124.03923, 41.32036], [-124.03889, 41.32062], [-124.03874, 41.32109], [-124.03872, 41.32125], [-124.03832, 41.32127], [-124.03852, 41.32073], [-124.03931, 41.31984], [-124.03934, 41.31945], [-124.03918, 41.31876], [-124.03895, 41.31814], [-124.03895, 41.31789], [-124.03916, 41.31755], [-124.04065, 41.3174]]]}	Unknown Access 4	46787	Berry Glen Trail Connection	30241	3074	Save the Redwoods League 52	Non Profit 6	Non Profit - Land Trust 10	http://www.savetheredwoods.org	Non Governmental Organization 10	3074	Save the Redwoods League 50	Non Profit 6	Non Profit - Land Trust 10		Humboldt 45	6.789	Berry Glen Trail Connection	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]);