calands: units_with_maps: 4 rows where DES_TP = 2 and LABEL

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

4 rows where DES_TP = 2 and LABEL_NAME = "Vintage 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	DES_TP	GAP_STS
2784	2784	2783	{"type": "Polygon", "coordinates": [[[-121.23513, 36.32734], [-121.23453, 36.32767], [-121.23445, 36.32757], [-121.23443, 36.32747], [-121.23439, 36.32741], [-121.23433, 36.32738], [-121.23426, 36.32737], [-121.23419, 36.32738], [-121.23414, 36.32741], [-121.23399, 36.32723], [-121.23469, 36.32683], [-121.23513, 36.32734]]]}	Open Access 1	18554	Vintage Park	30768	1124	Greenfield, City of 176	City 2	City Agency 2	http://www.ci.greenfield.ca.us/index.aspx?page=179	City 2	1124	Greenfield, City of 172	City 2	City Agency 2	Monterey 14	1.141	Vintage Park	Local Park 2	4
9100	9100	9099	{"type": "Polygon", "coordinates": [[[-117.54994, 34.12662], [-117.54984, 34.12663], [-117.54975, 34.12668], [-117.54969, 34.12674], [-117.54964, 34.12685], [-117.54958, 34.12688], [-117.54963, 34.12708], [-117.54962, 34.12726], [-117.54957, 34.12741], [-117.54945, 34.12762], [-117.54942, 34.12774], [-117.54943, 34.12786], [-117.54947, 34.12797], [-117.54954, 34.12806], [-117.54973, 34.12825], [-117.54977, 34.12834], [-117.5498, 34.12844], [-117.54927, 34.1285], [-117.54833, 34.12851], [-117.54828, 34.12814], [-117.5481, 34.12757], [-117.54808, 34.12755], [-117.54788, 34.12758], [-117.5478, 34.12752], [-117.54792, 34.12745], [-117.54792, 34.12725], [-117.54819, 34.12682], [-117.54824, 34.12664], [-117.54834, 34.12661], [-117.54994, 34.12662]]]}	Open Access 1	15084	Vintage Park	27149	1263	Rancho Cucamonga, City of 196	City 2	City Agency 2	http://www.cityofrc.us/cityhall/cs/parks/default.asp	City 2	1263	Rancho Cucamonga, City of 192	City 2	City Agency 2	San Bernardino 22	6.946	Vintage Park	Local Park 2	4
11742	11742	11741	{"type": "Polygon", "coordinates": [[[-121.38097, 38.46416], [-121.38097, 38.46466], [-121.38093, 38.46494], [-121.38088, 38.46509], [-121.38078, 38.46526], [-121.38066, 38.46542], [-121.38057, 38.46551], [-121.38045, 38.46561], [-121.38027, 38.46573], [-121.38009, 38.46581], [-121.37988, 38.46589], [-121.37948, 38.46596], [-121.37922, 38.46597], [-121.37909, 38.46595], [-121.37907, 38.46592], [-121.37907, 38.46456], [-121.37911, 38.46445], [-121.37909, 38.46439], [-121.3792, 38.46433], [-121.37929, 38.46416], [-121.38097, 38.46416]]]}	Open Access 1	24034	Vintage Park	27150	2160	Southgate Recreation and Park District 502	Special District 4	Recreation/Parks District 4	http://www.southgaterecandpark.net/	Special District 4	2160	Southgate Recreation and Park District 494	Special District 4	Recreation/Parks District 4	Sacramento 41	6.991	Vintage Park	Local Park 2	4
12806	12806	12805	{"type": "Polygon", "coordinates": [[[-117.65823, 33.6523], [-117.65805, 33.65271], [-117.65789, 33.65323], [-117.65753, 33.65399], [-117.65755, 33.6541], [-117.65746, 33.65409], [-117.65687, 33.65388], [-117.65667, 33.65369], [-117.65668, 33.65365], [-117.65697, 33.65334], [-117.65721, 33.65313], [-117.65773, 33.65215], [-117.65823, 33.6523]]]}	Open Access 1	30249	Vintage Park	27148	1167	Lake Forest, City of 235	City 2	City Agency 2	http://www.lakeforestca.gov/depts/cs/city_parks/default.asp	City 2	1167	Lake Forest, City of 231	City 2	City Agency 2	Orange 3	3.326	Vintage Park	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]);