calands: units_with_maps: 1 row where ACCESS_TYP = 1, MNG_AGENCY = 631 and YR

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

1 row where ACCESS_TYP = 1, MNG_AGENCY = 631 and YR_EST = 1986

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
15884	15884	15883	{"type": "MultiPolygon", "coordinates": [[[[-122.25791, 37.38103], [-122.2571, 37.38216], [-122.25721, 37.38258], [-122.25685, 37.38328], [-122.25661, 37.38355], [-122.25654, 37.38364], [-122.25628, 37.38388], [-122.25613, 37.38405], [-122.25576, 37.38419], [-122.25581, 37.38408], [-122.25602, 37.38399], [-122.2568, 37.38316], [-122.2571, 37.38254], [-122.25698, 37.38214], [-122.25782, 37.38098], [-122.25791, 37.38103]]], [[[-122.26147, 37.39074], [-122.26003, 37.39168], [-122.26004, 37.39172], [-122.2593, 37.3922], [-122.2593, 37.39221], [-122.25936, 37.39228], [-122.25932, 37.39229], [-122.25933, 37.39231], [-122.2579, 37.39229], [-122.25767, 37.39233], [-122.2575, 37.39239], [-122.25736, 37.3925], [-122.25725, 37.39263], [-122.25721, 37.39274], [-122.25712, 37.39283], [-122.257, 37.39288], [-122.25676, 37.39289], [-122.25661, 37.39294], [-122.25647, 37.39304], [-122.25637, 37.39318], [-122.25634, 37.39331], [-122.25635, 37.3934], [-122.2566, 37.39397], [-122.25661, 37.39406], [-122.2566, 37.39424], [-122.25663, 37.39435], [-122.25671, 37.39447], [-122.25682, 37.39455], [-122.25686, 37.39466], [-122.25695, 37.39475], [-122.25704, 37.39482], [-122.25718, 37.39487], [-122.25725, 37.39492], [-122.25729, 37.39498], [-122.25735, 37.39517], [-122.25733, 37.39526], [-122.2571, 37.3956], [-122.25704, 37.39577], [-122.25702, 37.39596], [-122.25707, 37.39641], [-122.25705, 37.39646], [-122.257, 37.39651], [-122.25696, 37.39658], [-122.25694, 37.39665], [-122.25695, 37.39674], [-122.25707, 37.39701], [-122.25715, 37.39712], [-122.25792, 37.39764], [-122.25802, 37.39769], [-122.25813, 37.39772], [-122.25824, 37.39772], [-122.2584, 37.3977], [-122.25848, 37.3977], [-122.25861, 37.39775], [-122.25868, 37.39781], [-122.25872, 37.39786], [-122.25873, 37.39793], [-122.25872, 37.39799], [-122.25869, 37.39804], [-122.25851, 37.39817], [-122.25829, 37.39824], [-122.25814, 37.39825], [-122.25799, 37.3982], [-122.25782, 37.39807], [-122.25769, 37.39789], [-122.25692, 37.39736], [-122.25661, 37.39722], [-122.25633, 37.39715], [-122.25615, 37.39713], [-122.25594, 37.39713], [-122.25534, 37.39716], [-122.25506, 37.39715], [-122.25496, 37.39712], [-122.25478, 37.39702], [-122.25561, 37.39647], [-122.25501, 37.39589], [-122.25509, 37.3959], [-122.25503, 37.39584], [-122.25448, 37.39571], [-122.25423, 37.39558], [-122.25392, 37.39549], [-122.25356, 37.3955], [-122.25353, 37.39547], [-122.25331, 37.39556], [-122.25268, 37.39574], [-122.25269, 37.39564], [-122.25262, 37.39566], [-122.25226, 37.39554], [-122.25189, 37.39539], [-122.25185, 37.39519], [-122.25155, 37.39516], [-122.2514, 37.3951], [-122.25117, 37.39509], [-122.25082, 37.39468], [-122.25047, 37.39446], [-122.25042, 37.3943], [-122.25053, 37.39377], [-122.25051, 37.39365], [-122.25045, 37.39362], [-122.25045, 37.39364], [-122.25011, 37.39348], [-122.24985, 37.39328], [-122.24989, 37.39286], [-122.24989, 37.39252], [-122.2498, 37.39251], [-122.24954, 37.39302], [-122.24946, 37.39339], [-122.24962, 37.39367], [-122.24929, 37.39409], [-122.24928, 37.39424], [-122.2492, 37.39404], [-122.24931, 37.39372], [-122.24901, 37.39341], [-122.24875, 37.39324], [-122.24877, 37.39291], [-122.24865, 37.39285], [-122.24922, 37.39193], [-122.2491, 37.3918], [-122.2491, 37.39178], [-122.24901, 37.39171], [-122.24951, 37.39124], [-122.25092, 37.38976], [-122.25089, 37.38951], [-122.25121, 37.38917], [-122.25131, 37.38873], [-122.25117, 37.38817], [-122.25101, 37.38787], [-122.25101, 37.38756], [-122.2515, 37.38767], [-122.25158, 37.3875], [-122.25189, 37.38727], [-122.25193, 37.38707], [-122.25205, 37.38681], [-122.25222, 37.38656], [-122.25242, 37.38658], [-122.25244, 37.38677], [-122.25265, 37.38715], [-122.25285, 37.38724], [-122.25291, 37.38745], [-122.25272, 37.38806], [-122.25275, 37.38816], [-122.25344, 37.38834], [-122.25369, 37.38849], [-122.2544, 37.38842], [-122.255, 37.38867], [-122.25525, 37.38865], [-122.25544, 37.38871], [-122.25607, 37.38887], [-122.25658, 37.38902], [-122.25679, 37.3891], [-122.25691, 37.38911], [-122.25763, 37.38956], [-122.25765, 37.38955], [-122.25781, 37.38963], [-122.2578, 37.38966], [-122.25787, 37.3897], [-122.25803, 37.38961], [-122.25986, 37.38932], [-122.26019, 37.38939], [-122.26135, 37.3905], [-122.26147, 37.39074]], [[-122.25524, 37.39278], [-122.25581, 37.39221], [-122.25524, 37.39189], [-122.25524, 37.39187], [-122.25514, 37.39181], [-122.25511, 37.39182], [-122.25507, 37.3918], [-122.25501, 37.3918], [-122.25467, 37.3916], [-122.25436, 37.392], [-122.25461, 37.39235], [-122.25451, 37.39303], [-122.25429, 37.3931], [-122.25423, 37.3937], [-122.2544, 37.394], [-122.25481, 37.39398], [-122.25519, 37.39392], [-122.25554, 37.39382], [-122.25553, 37.39356], [-122.25538, 37.3932], [-122.25524, 37.39278]], [[-122.25088, 37.39352], [-122.25087, 37.39351], [-122.25081, 37.39356], [-122.25087, 37.39358], [-122.25088, 37.39352]], [[-122.25063, 37.3932], [-122.25062, 37.39319], [-122.25061, 37.39322], [-122.25062, 37.39323], [-122.25063, 37.3932]]]]}	Open Access 1	3238	Thornewood Open Space Preserve	31491	2079	Midpeninsula Regional Open Space District 366	Special District 4	Recreation/Parks District 4	http://www.openspace.org	Special District 4	2079	Midpeninsula Regional Open Space District 631	Special District 4	Recreation/Parks District 4	http://www.openspace.org/preserves/pr_thornewood.asp	San Mateo 15	149.371	Thornewood OSP	1986	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]);