calands: units_with_maps: 2 rows where ACCESS_TYP = 1, AGNCY_TYP = 2, DES_TP = 2 and MNG_AG

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

2 rows where ACCESS_TYP = 1, AGNCY_TYP = 2, DES_TP = 2 and MNG_AG_TYP = 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	PARK_URL	COUNTY	ACRES	LABEL_NAME	YR_EST	DES_TP	GAP_STS
4142	4142	4141	{"type": "MultiPolygon", "coordinates": [[[[-117.09958, 32.61991], [-117.09934, 32.62003], [-117.09922, 32.62012], [-117.09913, 32.62021], [-117.09904, 32.62033], [-117.09865, 32.62097], [-117.09833, 32.6209], [-117.09808, 32.62086], [-117.09777, 32.62086], [-117.09743, 32.62088], [-117.09725, 32.62091], [-117.09534, 32.62143], [-117.09523, 32.62115], [-117.09736, 32.62055], [-117.09738, 32.62037], [-117.09771, 32.62036], [-117.09957, 32.61984], [-117.09958, 32.61991]]], [[[-117.10451, 32.62192], [-117.10429, 32.62215], [-117.10402, 32.62226], [-117.10363, 32.62235], [-117.10342, 32.62233], [-117.10315, 32.62218], [-117.10301, 32.62193], [-117.10293, 32.62169], [-117.10295, 32.62156], [-117.10304, 32.6215], [-117.10324, 32.62143], [-117.10323, 32.62102], [-117.10295, 32.62088], [-117.10267, 32.62019], [-117.10271, 32.62001], [-117.10253, 32.61958], [-117.10263, 32.6195], [-117.10258, 32.61947], [-117.10254, 32.61939], [-117.10248, 32.61934], [-117.10239, 32.61931], [-117.10229, 32.61931], [-117.10148, 32.61952], [-117.10104, 32.61954], [-117.10069, 32.6196], [-117.10052, 32.61958], [-117.10331, 32.61879], [-117.10433, 32.62109], [-117.10451, 32.62156], [-117.10451, 32.62192]]]]}	Open Access 1	47479	Chula Vista Bayfront Park	31201	1056	Chula Vista, City of 120	City 2	City Agency 2	http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp	City 2	2133	San Diego Unified Port District 182	Special District 4	Port/Harbor District 14	https://www.portofsandiego.org/chula-vista-bayfront-park.html	San Diego 4	16.026	Chula Vista Bayfront Park	0	Local Park 2	4
6071	6071	6070	{"type": "Polygon", "coordinates": [[[-117.17247, 32.69894], [-117.17197, 32.69981], [-117.17153, 32.69964], [-117.17205, 32.69877], [-117.17247, 32.69894]]]}	Open Access 1	809	Centennial Park	33718	1069	Coronado, City of 105	City 2	City Agency 2	http://www.coronado.ca.us/category/subcategory-rec.php	City 2	2133	San Diego Unified Port District 182	Special District 4	Port/Harbor District 14	https://www.coronado.ca.us/cms/one.aspx?portalId=746090&pageId=3814369	San Diego 4	1.186	Centennial Park	0	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]);