calands: units_with_maps: 1 row where ACCESS_TYP = 1, MNG_AG_TYP = 4 and UNIT_NAME = "Pacheco Valle Open Space Preserve"

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

1 row where ACCESS_TYP = 1, MNG_AG_TYP = 4 and UNIT_NAME = "Pacheco Valle 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
15927	15927	15926	{"type": "Polygon", "coordinates": [[[-122.57082, 38.04648], [-122.57067, 38.04651], [-122.57052, 38.04659], [-122.57042, 38.04666], [-122.57041, 38.0467], [-122.57036, 38.04678], [-122.57025, 38.04685], [-122.57009, 38.04685], [-122.56981, 38.04683], [-122.56958, 38.0469], [-122.56956, 38.04695], [-122.56954, 38.0471], [-122.5695, 38.04716], [-122.56927, 38.04724], [-122.56905, 38.04726], [-122.56868, 38.04735], [-122.56856, 38.04743], [-122.56831, 38.04766], [-122.56766, 38.04791], [-122.56755, 38.04797], [-122.56737, 38.04799], [-122.5673, 38.04801], [-122.56721, 38.04808], [-122.56719, 38.04815], [-122.56719, 38.04833], [-122.56706, 38.04843], [-122.56698, 38.04843], [-122.56695, 38.04846], [-122.56588, 38.04892], [-122.56545, 38.04922], [-122.56527, 38.04929], [-122.56486, 38.04929], [-122.56464, 38.04938], [-122.56438, 38.04963], [-122.56406, 38.04988], [-122.56391, 38.05001], [-122.56362, 38.05004], [-122.56342, 38.05005], [-122.56301, 38.05014], [-122.56244, 38.05031], [-122.56237, 38.05065], [-122.56211, 38.05093], [-122.56188, 38.0513], [-122.56183, 38.05147], [-122.56195, 38.05179], [-122.56195, 38.0519], [-122.5619, 38.05208], [-122.56168, 38.05259], [-122.56148, 38.05286], [-122.5614, 38.05293], [-122.56127, 38.053], [-122.561, 38.05322], [-122.56094, 38.05331], [-122.56093, 38.05342], [-122.56067, 38.05347], [-122.56032, 38.05344], [-122.5602, 38.05346], [-122.56008, 38.05358], [-122.56007, 38.05364], [-122.55984, 38.05372], [-122.55974, 38.05372], [-122.55965, 38.05379], [-122.55953, 38.05384], [-122.55895, 38.05398], [-122.5588, 38.054], [-122.55853, 38.05411], [-122.55772, 38.05424], [-122.55743, 38.05437], [-122.55665, 38.05464], [-122.55646, 38.05465], [-122.55627, 38.05463], [-122.55606, 38.05465], [-122.55596, 38.05467], [-122.55576, 38.05456], [-122.55558, 38.05457], [-122.55545, 38.05461], [-122.55528, 38.05472], [-122.5553, 38.05481], [-122.55526, 38.05489], [-122.55506, 38.05512], [-122.55481, 38.05525], [-122.55466, 38.05529], [-122.55457, 38.05529], [-122.55443, 38.05518], [-122.5543, 38.05512], [-122.55395, 38.05512], [-122.55385, 38.05513], [-122.55368, 38.05522], [-122.55346, 38.0553], [-122.55346, 38.05532], [-122.55291, 38.05517], [-122.55109, 38.0548], [-122.5507, 38.05475], [-122.5497, 38.05414], [-122.54331, 38.05555], [-122.54195, 38.05604], [-122.53981, 38.05538], [-122.54016, 38.05219], [-122.53868, 38.05083], [-122.53606, 38.05133], [-122.53543, 38.05198], [-122.53197, 38.052], [-122.53198, 38.05176], [-122.53344, 38.05162], [-122.53414, 38.05049], [-122.53476, 38.05129], [-122.53685, 38.05051], [-122.53684, 38.0505], [-122.5357, 38.04986], [-122.53543, 38.04958], [-122.53514, 38.0496], [-122.53484, 38.0495], [-122.53451, 38.04921], [-122.53427, 38.04921], [-122.53418, 38.04907], [-122.53413, 38.04892], [-122.53407, 38.04859], [-122.53436, 38.04873], [-122.53531, 38.04777], [-122.53493, 38.04731], [-122.53513, 38.04714], [-122.53527, 38.04707], [-122.53637, 38.04659], [-122.5367, 38.04638], [-122.53688, 38.04629], [-122.53704, 38.04622], [-122.53715, 38.0462], [-122.53729, 38.0462], [-122.53781, 38.0463], [-122.53801, 38.04638], [-122.53824, 38.04653], [-122.53836, 38.04658], [-122.53828, 38.04671], [-122.53754, 38.04705], [-122.53767, 38.04755], [-122.539, 38.04854], [-122.54034, 38.04811], [-122.5412, 38.04727], [-122.54138, 38.04689], [-122.54214, 38.04712], [-122.54225, 38.04717], [-122.54233, 38.04724], [-122.54241, 38.04732], [-122.54254, 38.04755], [-122.54275, 38.04777], [-122.54273, 38.0478], [-122.54263, 38.04792], [-122.54259, 38.04799], [-122.54258, 38.04809], [-122.54263, 38.04824], [-122.54263, 38.04834], [-122.54261, 38.04842], [-122.54251, 38.04858], [-122.54249, 38.04868], [-122.54251, 38.04883], [-122.54261, 38.04899], [-122.54262, 38.04916], [-122.54265, 38.04929], [-122.54245, 38.04933], [-122.54192, 38.04993], [-122.54219, 38.05018], [-122.54249, 38.05021], [-122.54284, 38.05004], [-122.54304, 38.05045], [-122.54311, 38.05056], [-122.5429, 38.05067], [-122.5426, 38.05096], [-122.54193, 38.05106], [-122.54169, 38.05139], [-122.54183, 38.05163], [-122.54256, 38.05182], [-122.54314, 38.05149], [-122.54373, 38.05234], [-122.54467, 38.0531], [-122.54518, 38.05278], [-122.54522, 38.05282], [-122.54546, 38.0527], [-122.54527, 38.05239], [-122.54532, 38.05222], [-122.54559, 38.05209], [-122.54521, 38.05147], [-122.54463, 38.05109], [-122.54405, 38.05034], [-122.54398, 38.05036], [-122.54379, 38.04975], [-122.54357, 38.04918], [-122.54368, 38.04823], [-122.54361, 38.04801], [-122.54457, 38.04801], [-122.54481, 38.04798], [-122.54507, 38.04842], [-122.54484, 38.04856], [-122.54484, 38.04857], [-122.54576, 38.04885], [-122.54652, 38.04879], [-122.54794, 38.04931], [-122.54908, 38.04945], [-122.55015, 38.05033], [-122.54999, 38.05057], [-122.54971, 38.05105], [-122.55113, 38.05167], [-122.55133, 38.05139], [-122.5517, 38.05192], [-122.55181, 38.05197], [-122.55191, 38.05185], [-122.55215, 38.05186], [-122.55235, 38.05159], [-122.55224, 38.05141], [-122.55278, 38.05069], [-122.55246, 38.05053], [-122.55248, 38.05047], [-122.55299, 38.05042], [-122.55328, 38.05003], [-122.55233, 38.04935], [-122.55127, 38.04862], [-122.54846, 38.04724], [-122.54555, 38.04712], [-122.54625, 38.04664], [-122.54489, 38.04489], [-122.54367, 38.04469], [-122.54194, 38.04475], [-122.54019, 38.0439], [-122.53984, 38.04383], [-122.53893, 38.04368], [-122.5383, 38.04336], [-122.53705, 38.04342], [-122.53663, 38.044], [-122.53563, 38.04383], [-122.53648, 38.04331], [-122.5371, 38.04253], [-122.53968, 38.04374], [-122.55524, 38.04708], [-122.56173, 38.04677], [-122.57082, 38.04648]], [[-122.53786, 38.04874], [-122.5369, 38.0482], [-122.53652, 38.04863], [-122.53754, 38.04929], [-122.5377, 38.0491], [-122.53786, 38.04874]], [[-122.54644, 38.04999], [-122.54644, 38.04997], [-122.54607, 38.04982], [-122.54577, 38.05007], [-122.54616, 38.05033], [-122.54644, 38.04999]]]}	Open Access 1	18427	Pacheco Valle Open Space Preserve	31438	2070	Marin County Open Space District 44	Special District 4	Recreation/Parks District 4	http://www.marincountyparks.org/Depts/PK.aspx	Special District 4	2070	Marin County Open Space District 43	Special District 4	Recreation/Parks District 4	http://www.marincounty.org/depts/pk/divisions/open-space/pacheco-valle	Marin 23	461.022	Pacheco Valle OSP	1987	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]);