calands: units_with_maps: 8 rows where COUNTY = 15 and DES

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

8 rows where COUNTY = 15 and DES_TP = 14

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	COUNTY	ACRES	LABEL_NAME	YR_EST	DES_TP	GAP_STS
1149	1149	1148	{"type": "Polygon", "coordinates": [[[-122.46654, 37.70822], [-122.46654, 37.70827], [-122.46585, 37.70826], [-122.46585, 37.70822], [-122.46654, 37.70822]]]}	Restricted Access 2	6734	Hillcrest And Ocean View Lots	19962	321	San Francisco - Public Utilities Commission, City and County of 31	County 3	County Agency - Other 9	http://sfwater.org/	County 3	321	San Francisco - Public Utilities Commission, City and County of 30	County 3	County Agency - Other 8	San Mateo 15	0.08	Hillcrest And Ocean View Lots	0	Local Other or Unknown 14	4
4824	4824	4823	{"type": "Polygon", "coordinates": [[[-122.27833, 37.55285], [-122.27813, 37.55301], [-122.27808, 37.55297], [-122.27791, 37.55293], [-122.27762, 37.55297], [-122.27772, 37.55285], [-122.27776, 37.55283], [-122.27801, 37.55287], [-122.27833, 37.55285]]]}	Open Access 1	48930	Unknown park - Foster City, City of	33649	1110	Foster City, City of 435	City 2	City Agency 2	http://www.fostercity.org/parksandrecreation/index.cfm	City 2	1110	Foster City, City of 429	City 2	City Agency 2	San Mateo 15	0.149		0	Local Other or Unknown 14	4
5194	5194	5193	{"type": "Polygon", "coordinates": [[[-122.40018, 37.66434], [-122.40011, 37.66463], [-122.39923, 37.66446], [-122.39958, 37.66423], [-122.40018, 37.66434]]]}	Open Access 1	15580	Gardiner Lot	19209	1341	South San Francisco, City of 60	City 2	City Agency 2	http://www.ssf.net/377/Parks-Recreation	City 2	1341	South San Francisco, City of 58	City 2	City Agency 2	San Mateo 15	0.528	Gardiner Lot	0	Local Other or Unknown 14	4
5923	5923	5922	{"type": "Polygon", "coordinates": [[[-122.1385, 37.48163], [-122.13828, 37.48212], [-122.13754, 37.48296], [-122.13725, 37.48334], [-122.13641, 37.48427], [-122.13358, 37.48639], [-122.13244, 37.48637], [-122.12668, 37.4898], [-122.12636, 37.48978], [-122.12589, 37.4898], [-122.1259, 37.48918], [-122.12601, 37.48639], [-122.12719, 37.48574], [-122.12827, 37.48519], [-122.13007, 37.48435], [-122.1312, 37.48388], [-122.13088, 37.48337], [-122.13108, 37.4829], [-122.13274, 37.48232], [-122.13331, 37.48262], [-122.1338, 37.48271], [-122.13422, 37.48259], [-122.13498, 37.48243], [-122.13544, 37.48231], [-122.13605, 37.48227], [-122.13669, 37.48211], [-122.13741, 37.48183], [-122.1385, 37.48163]]]}	Restricted Access 2	455	San Mateo Properties	24954	321	San Francisco - Public Utilities Commission, City and County of 31	County 3	County Agency - Other 9	http://sfwater.org/	County 3	321	San Francisco - Public Utilities Commission, City and County of 30	County 3	County Agency - Other 8	San Mateo 15	94.811	San Mateo Properties	1930	Local Other or Unknown 14	4
7871	7871	7870	{"type": "Polygon", "coordinates": [[[-122.39608, 37.51947], [-122.38304, 37.51947], [-122.38303, 37.51405], [-122.38073, 37.51403], [-122.3807, 37.5086], [-122.37849, 37.5086], [-122.37849, 37.50594], [-122.383, 37.50594], [-122.38301, 37.50493], [-122.3869, 37.50493], [-122.38693, 37.51585], [-122.39604, 37.51584], [-122.39608, 37.51947]]]}	No Public Access 3	9994	Coastside County Water District	17466	2022	Coastside County Water District 882	Special District 4	Water District 13	http://www.coastsidewater.org/	Special District 4	2022	Coastside County Water District 857	Special District 4	Water District 13	San Mateo 15	277.163	Coastside County Water District	1930	Local Other or Unknown 14	4
13706	13706	13705	{"type": "Polygon", "coordinates": [[[-122.40221, 37.68489], [-122.40183, 37.68563], [-122.40176, 37.68569], [-122.40168, 37.68572], [-122.40158, 37.6857], [-122.4007, 37.68516], [-122.4005, 37.68506], [-122.40004, 37.685], [-122.40002, 37.68486], [-122.40221, 37.68489]]]}	Open Access 1	36302	Brisbane holding 1	16400	1035	Brisbane, City of 686	City 2	City Agency 2	http://www.ci.brisbane.ca.us/about-parks-and-recreation	City 2	1035	Brisbane, City of 677	City 2	City Agency 2	San Mateo 15	2.326	Brisbane holding 1	0	Local Other or Unknown 14	4
13749	13749	13748	{"type": "Polygon", "coordinates": [[[-122.37518, 37.59189], [-122.3749, 37.59222], [-122.3742, 37.59192], [-122.37418, 37.59193], [-122.37406, 37.59188], [-122.37411, 37.59183], [-122.37372, 37.59124], [-122.37402, 37.59096], [-122.3745, 37.59123], [-122.37449, 37.59133], [-122.37451, 37.59142], [-122.37456, 37.59151], [-122.37463, 37.59159], [-122.37518, 37.59189]]]}	Open Access 1	36283	Burlingame holding 1	16523	1039	Burlingame, City of 390	City 2	City Agency 2	http://www.burlingame.org/index.aspx?page=33	City 2	1039	Burlingame, City of 384	City 2	City Agency 2	San Mateo 15	1.913	Burlingame holding 1	1940	Local Other or Unknown 14	4
13803	13803	13802	{"type": "Polygon", "coordinates": [[[-122.24221, 37.47403], [-122.24071, 37.47566], [-122.24044, 37.47541], [-122.23991, 37.47485], [-122.23949, 37.47457], [-122.24014, 37.47371], [-122.2418, 37.47384], [-122.24201, 37.47393], [-122.24221, 37.47403]]]}	Open Access 1	36373	Redwood City holding 1	24246	1271	Redwood City, City of 397	City 2	City Agency 2	http://www.redwoodcity.org/parks/	City 2	1271	Redwood City, City of 391	City 2	City Agency 2	San Mateo 15	7.036	Redwood City holding 1	1940	Local Other or Unknown 14	4

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]);