calands: units_with_maps: 2 rows where ACCESS_TYP = 2, AGNCY_NAME = 408 and DES

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

2 rows where ACCESS_TYP = 2, AGNCY_NAME = 408 and DES_TP = 65

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
1690	1690	1689	{"type": "Polygon", "coordinates": [[[-117.7695, 33.643], [-117.76969, 33.64291], [-117.76988, 33.64273], [-117.76992, 33.64272], [-117.77034, 33.64285], [-117.77072, 33.64291], [-117.77074, 33.64293], [-117.77074, 33.643], [-117.77069, 33.64363], [-117.77064, 33.64366], [-117.77029, 33.6436], [-117.76995, 33.64358], [-117.76969, 33.64352], [-117.76952, 33.64344], [-117.76934, 33.6433], [-117.76928, 33.64323], [-117.76922, 33.64313], [-117.76924, 33.64307], [-117.7694, 33.64301], [-117.76944, 33.64307], [-117.7695, 33.64305], [-117.76951, 33.64304], [-117.7695, 33.643]]]}	Restricted Access 2	12733	Valley View Park	26809	6019	Quail Hill Community Association 408	Private 7	Home Owners Association 16	http://www.quailhillhoa.org/	Private 14	6019	Quail Hill Community Association 402	Private 7	Home Owners Association 15		Orange 3	2.461	Valley View Park	0	Private Recreation or Education 65	4
8087	8087	8086	{"type": "Polygon", "coordinates": [[[-117.7745, 33.6464], [-117.77409, 33.64642], [-117.77402, 33.64586], [-117.77398, 33.64527], [-117.77395, 33.64518], [-117.77384, 33.64503], [-117.77389, 33.6449], [-117.77386, 33.64479], [-117.77383, 33.64478], [-117.77388, 33.64475], [-117.77385, 33.64452], [-117.77371, 33.64448], [-117.77371, 33.64441], [-117.77368, 33.64437], [-117.77378, 33.6443], [-117.77374, 33.64398], [-117.77357, 33.64362], [-117.77347, 33.64359], [-117.77345, 33.64351], [-117.77342, 33.64347], [-117.77348, 33.64339], [-117.77344, 33.64323], [-117.77344, 33.64295], [-117.77347, 33.64291], [-117.77331, 33.64267], [-117.77328, 33.64258], [-117.77321, 33.64254], [-117.77326, 33.64242], [-117.77312, 33.6422], [-117.7735, 33.64203], [-117.77358, 33.64201], [-117.77377, 33.64198], [-117.77402, 33.64201], [-117.77425, 33.6421], [-117.77442, 33.64219], [-117.77446, 33.64223], [-117.77445, 33.64226], [-117.77431, 33.64238], [-117.77417, 33.64252], [-117.77408, 33.64265], [-117.77401, 33.64278], [-117.77397, 33.64292], [-117.77394, 33.64317], [-117.77396, 33.6433], [-117.77399, 33.6434], [-117.77447, 33.64453], [-117.77457, 33.6449], [-117.7746, 33.64528], [-117.7746, 33.64546], [-117.7745, 33.6464]]]}	Restricted Access 2	12174	Cascade Park	16939	6019	Quail Hill Community Association 408	Private 7	Home Owners Association 16	http://www.quailhillhoa.org/	Private 14	6019	Quail Hill Community Association 402	Private 7	Home Owners Association 15		Orange 3	7.136	Cascade Park	0	Private Recreation or Education 65	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]);