calands: units_with_maps: 1 row where ACCESS_TYP = 3 and UNIT_NAME = "Tunitas Creek Open Space Preserve"

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

1 row where ACCESS_TYP = 3 and UNIT_NAME = "Tunitas Creek Open Space 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
15952	15952	15951	{"type": "MultiPolygon", "coordinates": [[[[-122.37531, 37.37642], [-122.37525, 37.37651], [-122.37481, 37.37654], [-122.37469, 37.37662], [-122.37477, 37.3768], [-122.37475, 37.37686], [-122.37463, 37.3769], [-122.37455, 37.37696], [-122.37438, 37.3772], [-122.37443, 37.37814], [-122.37491, 37.37911], [-122.3746, 37.38073], [-122.37362, 37.3822], [-122.37318, 37.38369], [-122.37305, 37.38502], [-122.3721, 37.3867], [-122.37204, 37.38671], [-122.37219, 37.38694], [-122.37211, 37.38712], [-122.37213, 37.3874], [-122.37179, 37.38789], [-122.37163, 37.38781], [-122.37151, 37.38785], [-122.37142, 37.38801], [-122.37156, 37.38813], [-122.37157, 37.38841], [-122.37162, 37.38849], [-122.3716, 37.38854], [-122.37141, 37.38836], [-122.37093, 37.38852], [-122.37093, 37.38853], [-122.37134, 37.38868], [-122.3709, 37.38893], [-122.37094, 37.38926], [-122.3705, 37.38954], [-122.37043, 37.38964], [-122.37028, 37.38959], [-122.37005, 37.38971], [-122.36998, 37.38986], [-122.36979, 37.38988], [-122.36944, 37.39022], [-122.36936, 37.39026], [-122.36925, 37.3905], [-122.36928, 37.3906], [-122.36841, 37.39086], [-122.36773, 37.39139], [-122.36764, 37.39148], [-122.36759, 37.39161], [-122.36762, 37.39174], [-122.36748, 37.39183], [-122.3674, 37.39202], [-122.36751, 37.39214], [-122.36713, 37.39241], [-122.36718, 37.39248], [-122.36746, 37.39233], [-122.36777, 37.3917], [-122.36791, 37.39177], [-122.3676, 37.39242], [-122.3672, 37.39264], [-122.3671, 37.39288], [-122.36715, 37.39314], [-122.36729, 37.39342], [-122.36705, 37.39383], [-122.36707, 37.39418], [-122.36668, 37.39461], [-122.36634, 37.39479], [-122.36628, 37.39485], [-122.36625, 37.39495], [-122.36626, 37.39531], [-122.36623, 37.39536], [-122.36619, 37.39541], [-122.36612, 37.39544], [-122.36521, 37.39566], [-122.36511, 37.39571], [-122.36503, 37.39578], [-122.36497, 37.39589], [-122.36496, 37.39599], [-122.36508, 37.39634], [-122.36489, 37.39654], [-122.3649, 37.39674], [-122.36455, 37.39665], [-122.36474, 37.39692], [-122.36459, 37.39718], [-122.36428, 37.39725], [-122.36409, 37.39767], [-122.36386, 37.39788], [-122.36375, 37.398], [-122.36358, 37.39826], [-122.36348, 37.39856], [-122.36141, 37.40055], [-122.35816, 37.40029], [-122.35818, 37.38911], [-122.35368, 37.38913], [-122.35372, 37.38196], [-122.35818, 37.38195], [-122.35818, 37.38051], [-122.35849, 37.3805], [-122.35865, 37.38061], [-122.35908, 37.38066], [-122.35925, 37.3806], [-122.35962, 37.3806], [-122.35963, 37.3805], [-122.35984, 37.38047], [-122.35983, 37.38013], [-122.36003, 37.38023], [-122.36027, 37.38017], [-122.36066, 37.38019], [-122.36082, 37.38007], [-122.3608, 37.3799], [-122.36094, 37.37959], [-122.3612, 37.37958], [-122.3612, 37.37934], [-122.36159, 37.37931], [-122.36159, 37.37917], [-122.36167, 37.37916], [-122.36174, 37.37911], [-122.36168, 37.37899], [-122.36176, 37.37876], [-122.36184, 37.37871], [-122.36212, 37.37895], [-122.36229, 37.37877], [-122.36256, 37.37864], [-122.36272, 37.37833], [-122.36307, 37.37832], [-122.36313, 37.37822], [-122.36346, 37.37816], [-122.36383, 37.3782], [-122.36414, 37.37811], [-122.36438, 37.37815], [-122.36458, 37.37805], [-122.36491, 37.3781], [-122.36505, 37.37783], [-122.36538, 37.37784], [-122.36593, 37.37779], [-122.36624, 37.37787], [-122.36647, 37.37782], [-122.3669, 37.37747], [-122.36725, 37.37746], [-122.36763, 37.37729], [-122.36799, 37.37734], [-122.36817, 37.37745], [-122.36863, 37.37708], [-122.36878, 37.37713], [-122.36892, 37.3771], [-122.36907, 37.37715], [-122.36932, 37.37703], [-122.36946, 37.37708], [-122.36963, 37.37698], [-122.36987, 37.37696], [-122.36997, 37.37707], [-122.37024, 37.37705], [-122.37032, 37.37689], [-122.37064, 37.37676], [-122.37074, 37.37682], [-122.37092, 37.37676], [-122.37099, 37.3768], [-122.37119, 37.37663], [-122.37132, 37.37671], [-122.37145, 37.37671], [-122.37181, 37.37653], [-122.37214, 37.37651], [-122.37207, 37.37635], [-122.37229, 37.37634], [-122.37258, 37.37653], [-122.37259, 37.3767], [-122.37291, 37.37661], [-122.37293, 37.37649], [-122.37314, 37.37638], [-122.37344, 37.37647], [-122.37351, 37.37646], [-122.37309, 37.37664], [-122.37318, 37.37684], [-122.37357, 37.37673], [-122.3738, 37.37685], [-122.37395, 37.37708], [-122.3741, 37.37707], [-122.37415, 37.37702], [-122.37415, 37.37694], [-122.37423, 37.37667], [-122.37448, 37.37631], [-122.37456, 37.37636], [-122.37493, 37.37616], [-122.37531, 37.37642]]], [[[-122.39702, 37.34864], [-122.39631, 37.3488], [-122.39656, 37.35114], [-122.39682, 37.35209], [-122.39578, 37.35396], [-122.39565, 37.35569], [-122.39632, 37.35777], [-122.39603, 37.3581], [-122.39472, 37.35786], [-122.39453, 37.35765], [-122.39429, 37.35742], [-122.39408, 37.35741], [-122.39404, 37.35732], [-122.3938, 37.35743], [-122.39366, 37.35801], [-122.39317, 37.35818], [-122.39287, 37.35824], [-122.39258, 37.35844], [-122.39224, 37.35831], [-122.39195, 37.35834], [-122.39178, 37.35877], [-122.39143, 37.35897], [-122.39122, 37.35913], [-122.39094, 37.3589], [-122.39068, 37.35901], [-122.39027, 37.35901], [-122.38989, 37.35906], [-122.38968, 37.35918], [-122.38948, 37.3592], [-122.38944, 37.35897], [-122.38943, 37.35897], [-122.38889, 37.35912], [-122.38882, 37.35923], [-122.389, 37.35934], [-122.38889, 37.35951], [-122.38834, 37.35968], [-122.38728, 37.35935], [-122.38722, 37.35917], [-122.38668, 37.35918], [-122.38635, 37.35922], [-122.38597, 37.35895], [-122.38554, 37.35893], [-122.38522, 37.35875], [-122.38489, 37.3588], [-122.38481, 37.35862], [-122.38455, 37.35849], [-122.38425, 37.3585], [-122.38416, 37.35827], [-122.3839, 37.35822], [-122.38331, 37.35824], [-122.38316, 37.35815], [-122.38277, 37.3582], [-122.3824, 37.35792], [-122.3821, 37.35789], [-122.38192, 37.35791], [-122.38148, 37.35773], [-122.38103, 37.35772], [-122.38065, 37.35777], [-122.38008, 37.35761], [-122.37977, 37.35772], [-122.37945, 37.35773], [-122.37929, 37.35785], [-122.37898, 37.35782], [-122.3788, 37.3579], [-122.37857, 37.35778], [-122.37828, 37.35789], [-122.37796, 37.35789], [-122.37778, 37.35793], [-122.37761, 37.35759], [-122.37747, 37.35754], [-122.3773, 37.35764], [-122.37707, 37.35747], [-122.37676, 37.35739], [-122.37659, 37.3575], [-122.37629, 37.35752], [-122.37615, 37.35757], [-122.37602, 37.35765], [-122.37576, 37.3576], [-122.37533, 37.35784], [-122.37502, 37.35783], [-122.3747, 37.358], [-122.37466, 37.35818], [-122.37427, 37.35839], [-122.37414, 37.35852], [-122.37399, 37.35856], [-122.37392, 37.35872], [-122.37368, 37.35875], [-122.37337, 37.35873], [-122.37322, 37.35881], [-122.37307, 37.35879], [-122.37287, 37.35892], [-122.37277, 37.35891], [-122.37268, 37.35898], [-122.37265, 37.3591], [-122.37269, 37.35921], [-122.37257, 37.35943], [-122.37227, 37.35939], [-122.37197, 37.35948], [-122.37175, 37.3597], [-122.37161, 37.35988], [-122.37149, 37.35993], [-122.37132, 37.36005], [-122.37114, 37.36006], [-122.37108, 37.36002], [-122.3709, 37.35998], [-122.37047, 37.35998], [-122.36655, 37.34888], [-122.38797, 37.34275], [-122.39398, 37.34188], [-122.39391, 37.34194], [-122.39386, 37.342], [-122.39383, 37.34215], [-122.39401, 37.3427], [-122.394, 37.34276], [-122.39396, 37.34281], [-122.39347, 37.34306], [-122.39341, 37.34312], [-122.39336, 37.34318], [-122.39333, 37.34326], [-122.39333, 37.34334], [-122.39335, 37.34342], [-122.39342, 37.34351], [-122.39352, 37.34358], [-122.39443, 37.34392], [-122.39484, 37.34464], [-122.39489, 37.34474], [-122.3949, 37.34489], [-122.3948, 37.34528], [-122.3948, 37.34534], [-122.39483, 37.34539], [-122.39487, 37.34543], [-122.39551, 37.34577], [-122.39621, 37.34631], [-122.39626, 37.3464], [-122.39669, 37.34785], [-122.39702, 37.34864]]]]}	No Public Access 3	47114	Tunitas Creek Open Space Preserve	30785	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		San Mateo 15	1631.027	Tunitas Creek OSP	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]);