calands: units_with_maps: 5 rows where ACCESS_TYP = 2, COUNTY = 10 and MNG_AG

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

5 rows where ACCESS_TYP = 2, COUNTY = 10 and MNG_AG_TYP = 15

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
498	498	497	{"type": "Polygon", "coordinates": [[[-117.29951, 33.64844], [-117.29964, 33.64847], [-117.29974, 33.64855], [-117.29977, 33.64866], [-117.29973, 33.64877], [-117.29926, 33.6492], [-117.29918, 33.64923], [-117.2991, 33.64924], [-117.29902, 33.64922], [-117.29895, 33.64918], [-117.2989, 33.64912], [-117.29887, 33.64906], [-117.29887, 33.64898], [-117.29891, 33.6489], [-117.29934, 33.6485], [-117.29941, 33.64846], [-117.29951, 33.64844]]]}	Restricted Access 2	48361	Spirit Park	32928	7028	Summerly Homes 188	Private 7	Home Owners Association 16	http://summerlyhomes.com/explore/	Private 14	7028	Summerly Homes 184	Private 7	Home Owners Association 15	http://summerlyhomes.com/explore/	Riverside 10	1.064	Spirit Park		None 53
4781	4781	4780	{"type": "Polygon", "coordinates": [[[-117.09427, 33.49075], [-117.09413, 33.4908], [-117.09236, 33.48975], [-117.09204, 33.48957], [-117.09188, 33.48943], [-117.09177, 33.48927], [-117.0916, 33.48886], [-117.09146, 33.48864], [-117.09201, 33.48839], [-117.09211, 33.48855], [-117.09206, 33.4891], [-117.09194, 33.48924], [-117.09198, 33.4893], [-117.09222, 33.48943], [-117.09228, 33.48942], [-117.09233, 33.48948], [-117.09239, 33.48951], [-117.09237, 33.48959], [-117.09326, 33.49009], [-117.09336, 33.49005], [-117.09339, 33.49009], [-117.09345, 33.49012], [-117.09356, 33.49012], [-117.09361, 33.4902], [-117.09398, 33.49024], [-117.09411, 33.49022], [-117.09427, 33.49075]]]}	Restricted Access 2	47164	Unknown Park - Paseo del Sol Master Association	31757	6110	Paseo del Sol Master Association 780	Private 7	Home Owners Association 16	http://www.twmc.com/paseodelsol/	Private 14	6110	Paseo del Sol Master Association 760	Private 7	Home Owners Association 15		Riverside 10	2.526		0	Private Recreation or Education 65	4
5693	5693	5692	{"type": "Polygon", "coordinates": [[[-116.9052, 33.74329], [-116.90501, 33.7433], [-116.905, 33.74348], [-116.90478, 33.74342], [-116.90427, 33.74342], [-116.90426, 33.74343], [-116.90381, 33.74341], [-116.9038, 33.74359], [-116.90363, 33.74359], [-116.90363, 33.74341], [-116.9023, 33.74342], [-116.90203, 33.74347], [-116.90203, 33.74298], [-116.90225, 33.74307], [-116.90248, 33.74307], [-116.90266, 33.74299], [-116.90283, 33.74306], [-116.90306, 33.74306], [-116.90324, 33.74299], [-116.90342, 33.74306], [-116.90364, 33.74306], [-116.90383, 33.74298], [-116.90401, 33.74306], [-116.90423, 33.74306], [-116.90442, 33.74298], [-116.90459, 33.74306], [-116.90482, 33.74305], [-116.905, 33.74298], [-116.905, 33.74326], [-116.9052, 33.74326], [-116.9052, 33.74329]]]}	Restricted Access 2	48937	Unknown park - Briarcliff Homeowners Association	33654	6137	Briarcliff Homeowners Association 813	Private 7	Home Owners Association 16	https://www.briarcliff.org/	Private 14	6137	Briarcliff Homeowners Association 792	Private 7	Home Owners Association 15		Riverside 10	3.003		0	Private Recreation or Education 65	4
6354	6354	6353	{"type": "Polygon", "coordinates": [[[-117.29984, 33.64296], [-117.29987, 33.64297], [-117.3003, 33.64324], [-117.30036, 33.64329], [-117.3004, 33.64335], [-117.30041, 33.64343], [-117.30039, 33.6435], [-117.30033, 33.64356], [-117.3002, 33.64362], [-117.30005, 33.64361], [-117.29955, 33.64331], [-117.29954, 33.64328], [-117.29955, 33.64324], [-117.29979, 33.64298], [-117.29984, 33.64296]]]}	Restricted Access 2	48362	Sunshine Park	32927	7028	Summerly Homes 188	Private 7	Home Owners Association 16	http://summerlyhomes.com/explore/	Private 14	7028	Summerly Homes 184	Private 7	Home Owners Association 15	http://summerlyhomes.com/explore/	Riverside 10	0.866	Sunshine Park		None 514
14518	14518	14517	{"type": "Polygon", "coordinates": [[[-117.10811, 33.49529], [-117.10821, 33.49558], [-117.10827, 33.49587], [-117.1083, 33.49617], [-117.10829, 33.49646], [-117.10825, 33.49676], [-117.10819, 33.49705], [-117.10803, 33.49747], [-117.10796, 33.49749], [-117.10776, 33.49743], [-117.10774, 33.4972], [-117.10755, 33.49688], [-117.10736, 33.49667], [-117.10713, 33.49651], [-117.10692, 33.49641], [-117.10649, 33.49627], [-117.10633, 33.49651], [-117.10619, 33.49644], [-117.10636, 33.49621], [-117.10614, 33.49606], [-117.1063, 33.49589], [-117.10606, 33.49571], [-117.10605, 33.49549], [-117.10627, 33.49547], [-117.10652, 33.49541], [-117.10641, 33.49515], [-117.10652, 33.49511], [-117.10667, 33.49536], [-117.10698, 33.49519], [-117.10714, 33.49506], [-117.10724, 33.49496], [-117.1074, 33.49473], [-117.10746, 33.4946], [-117.10752, 33.49443], [-117.10767, 33.4943], [-117.10749, 33.49381], [-117.10756, 33.49384], [-117.10811, 33.49529]]]}	Restricted Access 2	47181	Captain Aaron J. Contreras Memorial Park	31744	6111	Paloma del Sol Homeowners Association 1115	Private 7	Home Owners Association 16	http://www.palomadelsol.net/	Private 14	6111	Paloma del Sol Homeowners Association 1070	Private 7	Home Owners Association 15		Riverside 10	9.154	Captain Aaron J. Contreras Memorial 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]);