calands: units_with_maps: 3 rows where DES_TP = 2 and UNIT

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

3 rows where DES_TP = 2 and UNIT_NAME = "Junipero Serra Park"

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
8125	8125	8124	{"type": "Polygon", "coordinates": [[[-117.665, 33.51297], [-117.66309, 33.51296], [-117.66291, 33.51257], [-117.66274, 33.51247], [-117.66274, 33.51217], [-117.6643, 33.51204], [-117.66431, 33.5121], [-117.66434, 33.51218], [-117.66442, 33.51232], [-117.66452, 33.51244], [-117.66477, 33.51267], [-117.66491, 33.51283], [-117.665, 33.51297]]]}	Open Access 1	12298	Junipero Serra Park	20531	1305	San Juan Capistrano, City of 92	City 2	City Agency 2	http://www.sanjuancapistrano.org/	City 2	1305	San Juan Capistrano, City of 90	City 2	City Agency 2	Orange 3	3.875	Junipero Serra Park	0	Local Park 2	4
9924	9924	9923	{"type": "Polygon", "coordinates": [[[-119.17382, 34.2657], [-119.17222, 34.26667], [-119.17186, 34.26626], [-119.17188, 34.26622], [-119.17342, 34.26529], [-119.17347, 34.2653], [-119.17382, 34.2657]]]}	Open Access 1	17092	Junipero Serra Park	20532	1366	Ventura, City of 113	City 2	City Agency 2	http://www.cityofventura.net/prcp	City 2	1366	Ventura, City of 110	City 2	City Agency 2	Ventura 8	2.622	Junipero Serra Park	0	Local Park 2	4
9954	9954	9953	{"type": "Polygon", "coordinates": [[[-122.42682, 37.60997], [-122.42658, 37.61042], [-122.42623, 37.61036], [-122.4262, 37.61067], [-122.42544, 37.61096], [-122.42521, 37.61132], [-122.42513, 37.61152], [-122.42504, 37.61185], [-122.42498, 37.61197], [-122.42488, 37.61213], [-122.42468, 37.61233], [-122.42436, 37.61256], [-122.42415, 37.61274], [-122.42369, 37.61323], [-122.42361, 37.61329], [-122.42235, 37.61386], [-122.42168, 37.61405], [-122.42089, 37.61393], [-122.42007, 37.61395], [-122.41977, 37.61352], [-122.42028, 37.61328], [-122.41778, 37.60978], [-122.41833, 37.6095], [-122.41879, 37.61019], [-122.42029, 37.6095], [-122.42029, 37.60948], [-122.42008, 37.60919], [-122.42026, 37.60902], [-122.42036, 37.60886], [-122.42041, 37.60865], [-122.4204, 37.60844], [-122.4235, 37.60681], [-122.42253, 37.60518], [-122.42234, 37.60505], [-122.42268, 37.60466], [-122.42244, 37.60453], [-122.42263, 37.60424], [-122.4227, 37.60418], [-122.42492, 37.60606], [-122.42538, 37.60583], [-122.42543, 37.60592], [-122.42552, 37.60601], [-122.42588, 37.60616], [-122.42597, 37.60624], [-122.42604, 37.60631], [-122.42609, 37.60641], [-122.42612, 37.60651], [-122.42612, 37.60711], [-122.42619, 37.60773], [-122.42618, 37.60789], [-122.42611, 37.60812], [-122.42612, 37.60832], [-122.42618, 37.60848], [-122.42629, 37.60863], [-122.42646, 37.60876], [-122.42672, 37.60892], [-122.42678, 37.60897], [-122.42682, 37.60904], [-122.42684, 37.60913], [-122.42683, 37.60922], [-122.42679, 37.6093], [-122.4267, 37.60938], [-122.42682, 37.60997]]]}	Open Access 1	17128	Junipero Serra Park	20530	324	San Mateo County Parks and Recreation Dept., County of 28	County 3	County Agency - Parks 7	http://www.co.sanmateo.ca.us/portal/site/parks/	County 3	324	San Mateo County Parks and Recreation Dept., County of 28	County 3	County Agency - Parks 7	San Mateo 15	105.136	Junipero Serra Park	2000	Local Park 2	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]);