calands: units_with_maps: 1 row where ACCESS_TYP = 3, DES_TP = 16, MNG_AGENCY = 118 and UNIT

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

1 row where ACCESS_TYP = 3, DES_TP = 16, MNG_AGENCY = 118 and UNIT_NAME = "Randall Morgan Sandhills"

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
11903	11903	11902	{"type": "MultiPolygon", "coordinates": [[[[-122.05085, 37.05644], [-122.05084, 37.05733], [-122.04901, 37.05733], [-122.04897, 37.05736], [-122.04879, 37.06192], [-122.04841, 37.06194], [-122.04831, 37.0649], [-122.03933, 37.06479], [-122.03939, 37.06108], [-122.03927, 37.05717], [-122.03822, 37.05718], [-122.03822, 37.05714], [-122.03851, 37.05688], [-122.03864, 37.05684], [-122.03868, 37.0568], [-122.03877, 37.05676], [-122.03877, 37.05661], [-122.03881, 37.05626], [-122.03929, 37.05618], [-122.03905, 37.05517], [-122.03927, 37.05525], [-122.0397, 37.05552], [-122.03989, 37.05556], [-122.04046, 37.05535], [-122.0407, 37.05529], [-122.0407, 37.05547], [-122.04089, 37.05547], [-122.04147, 37.0555], [-122.04149, 37.0557], [-122.0416, 37.05598], [-122.04186, 37.05626], [-122.0423, 37.05642], [-122.0428, 37.05651], [-122.04274, 37.05736], [-122.04391, 37.05736], [-122.0439, 37.05695], [-122.04479, 37.05698], [-122.04531, 37.05695], [-122.04597, 37.05683], [-122.04613, 37.0566], [-122.04639, 37.05643], [-122.0468, 37.05648], [-122.04764, 37.05607], [-122.04805, 37.05603], [-122.04834, 37.0559], [-122.0488, 37.05587], [-122.04881, 37.05643], [-122.05085, 37.05644]]], [[[-122.03892, 37.05561], [-122.03883, 37.05579], [-122.03871, 37.05573], [-122.03881, 37.05558], [-122.03879, 37.05551], [-122.03892, 37.05561]]], [[[-122.05593, 37.06624], [-122.05087, 37.06611], [-122.05087, 37.06593], [-122.05587, 37.06596], [-122.05593, 37.06624]]], [[[-122.05764, 37.06629], [-122.05619, 37.06625], [-122.05616, 37.0661], [-122.05761, 37.06611], [-122.05764, 37.06629]]]]}	No Public Access 3	24438	Randall Morgan Sandhills	30479	3036	Land Trust of Santa Cruz County 121	Non Profit 6	Non Profit - Land Trust 10	http://www.landtrustsantacruz.org/	Non Governmental Organization 10	3036	Land Trust of Santa Cruz County 118	Non Profit 6	Non Profit - Land Trust 10		Santa Cruz 5	203.811	Randall Morgan Sandhills	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]);