calands: units_with_maps: 1 row where DES_TP = 4, MNG_AGENCY = 101 and UNIT

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

1 row where DES_TP = 4, MNG_AGENCY = 101 and UNIT_NAME = "Mt. Olympus Preserve"

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
6179	6179	6178	{"type": "Polygon", "coordinates": [[[-117.11321, 33.4123], [-117.11289, 33.41266], [-117.1124, 33.41359], [-117.11121, 33.41278], [-117.11054, 33.41298], [-117.10972, 33.4128], [-117.10938, 33.41231], [-117.10899, 33.41231], [-117.10623, 33.4129], [-117.10374, 33.41236], [-117.1033, 33.4123], [-117.10365, 33.41528], [-117.0977, 33.41534], [-117.09748, 33.41496], [-117.09743, 33.41491], [-117.09735, 33.41487], [-117.09697, 33.41478], [-117.09692, 33.41473], [-117.09693, 33.41467], [-117.09689, 33.41455], [-117.09675, 33.41441], [-117.09648, 33.41432], [-117.09612, 33.414], [-117.09606, 33.41398], [-117.09598, 33.414], [-117.09593, 33.41405], [-117.09582, 33.41435], [-117.09578, 33.41451], [-117.09559, 33.41471], [-117.09566, 33.41531], [-117.09569, 33.41535], [-117.0958, 33.41567], [-117.0958, 33.41579], [-117.09578, 33.41591], [-117.09565, 33.41619], [-117.09546, 33.41631], [-117.09512, 33.4166], [-117.09511, 33.41667], [-117.09518, 33.41676], [-117.09519, 33.41684], [-117.09516, 33.41689], [-117.09497, 33.41701], [-117.09486, 33.41713], [-117.09482, 33.41726], [-117.09484, 33.41742], [-117.09483, 33.4175], [-117.09475, 33.41763], [-117.09472, 33.41775], [-117.09473, 33.41799], [-117.09479, 33.41844], [-117.09481, 33.41855], [-117.09476, 33.41895], [-117.09476, 33.41905], [-117.09483, 33.41908], [-117.09506, 33.41908], [-117.0951, 33.4198], [-117.09514, 33.4209], [-117.09526, 33.42291], [-117.09097, 33.42296], [-117.09102, 33.42379], [-117.08878, 33.42387], [-117.08865, 33.42348], [-117.08854, 33.42301], [-117.09096, 33.42296], [-117.09042, 33.41541], [-117.09032, 33.41197], [-117.0873, 33.41198], [-117.08728, 33.40855], [-117.09023, 33.40853], [-117.09014, 33.40506], [-117.08586, 33.40504], [-117.08585, 33.40349], [-117.08401, 33.40348], [-117.08388, 33.40276], [-117.08385, 33.4021], [-117.08377, 33.40175], [-117.08584, 33.40179], [-117.10209, 33.40231], [-117.10282, 33.40838], [-117.10377, 33.40848], [-117.10378, 33.40847], [-117.10306, 33.40238], [-117.11128, 33.4029], [-117.11148, 33.40933], [-117.11249, 33.40945], [-117.11291, 33.41202], [-117.11321, 33.4123]]]}	No Public Access 3	1219	Mt. Olympus Preserve	29249	319	San Diego, County of 104	County 3	County Agency 3	http://www.sandiegocounty.gov/parks/	County 3	319	San Diego, County of 101	County 3	County Agency 3		San Diego 4	801.066	Mt. Olympus Preserve	0	Local Conservation Area 4	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]);