calands: units_with_maps: 1 row where ACCESS_TYP = 1, MNG_AGENCY = 43, MNG_AG_TYP = 4 and YR

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

1 row where ACCESS_TYP = 1, MNG_AGENCY = 43, MNG_AG_TYP = 4 and YR_EST = 1979

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
15874	15874	15873	{"type": "Polygon", "coordinates": [[[-122.62993, 38.11183], [-122.62914, 38.11182], [-122.62843, 38.11129], [-122.62798, 38.11109], [-122.62795, 38.11074], [-122.62809, 38.11038], [-122.62817, 38.11025], [-122.62824, 38.11004], [-122.62876, 38.10999], [-122.62888, 38.10952], [-122.62888, 38.10923], [-122.62864, 38.10872], [-122.6277, 38.1085], [-122.6275, 38.10872], [-122.6278, 38.10898], [-122.62776, 38.10901], [-122.62593, 38.10842], [-122.62615, 38.11061], [-122.62616, 38.11101], [-122.62534, 38.111], [-122.62471, 38.11113], [-122.62378, 38.1112], [-122.62364, 38.10989], [-122.62249, 38.10988], [-122.62242, 38.10942], [-122.62184, 38.10925], [-122.62128, 38.10932], [-122.62097, 38.11028], [-122.61823, 38.11056], [-122.61779, 38.11039], [-122.61673, 38.10903], [-122.61619, 38.10941], [-122.61599, 38.10868], [-122.61592, 38.1079], [-122.61586, 38.10742], [-122.61595, 38.10701], [-122.61662, 38.1068], [-122.61682, 38.10648], [-122.61828, 38.10705], [-122.61914, 38.10727], [-122.61944, 38.10644], [-122.62079, 38.10666], [-122.62079, 38.10782], [-122.6218, 38.10778], [-122.62255, 38.10762], [-122.62349, 38.10762], [-122.62359, 38.10701], [-122.6229, 38.10674], [-122.62296, 38.10671], [-122.62299, 38.10666], [-122.62377, 38.10679], [-122.62404, 38.10606], [-122.62424, 38.10611], [-122.62458, 38.10634], [-122.62698, 38.10605], [-122.6295, 38.10566], [-122.62969, 38.1056], [-122.62993, 38.11183]]]}	Open Access 1	1875	Verissimo Hills Open Space Preserve	26995	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		Marin 23	114.809	Verissimo Hills OSP	1979	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]);