calands: units_with_maps: 2 rows where DES_TP = 65, GAP_STS = 4 and MNG

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

2 rows where DES_TP = 65, GAP_STS = 4 and MNG_AGENCY = 899

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
9776	9776	9775	{"type": "Polygon", "coordinates": [[[-117.79917, 33.70162], [-117.79896, 33.70148], [-117.79893, 33.70151], [-117.79887, 33.70146], [-117.79889, 33.70143], [-117.79859, 33.70122], [-117.79855, 33.70125], [-117.79849, 33.7012], [-117.79852, 33.70117], [-117.79822, 33.70096], [-117.79818, 33.70099], [-117.79812, 33.70094], [-117.79814, 33.70091], [-117.798, 33.7008], [-117.79809, 33.7007], [-117.79794, 33.7006], [-117.79788, 33.70065], [-117.79788, 33.70063], [-117.79785, 33.70061], [-117.79782, 33.70061], [-117.79786, 33.70055], [-117.79756, 33.70035], [-117.7975, 33.70038], [-117.79746, 33.70035], [-117.79743, 33.70036], [-117.79739, 33.7004], [-117.79723, 33.7003], [-117.79704, 33.70049], [-117.79702, 33.70047], [-117.79702, 33.70042], [-117.79723, 33.70021], [-117.79725, 33.70014], [-117.7973, 33.70015], [-117.79744, 33.70024], [-117.79754, 33.70021], [-117.79778, 33.70037], [-117.79786, 33.70029], [-117.79787, 33.7003], [-117.79784, 33.70037], [-117.79787, 33.70045], [-117.79796, 33.70049], [-117.79805, 33.70048], [-117.79821, 33.70059], [-117.79833, 33.70048], [-117.79832, 33.70046], [-117.79837, 33.70041], [-117.79839, 33.70042], [-117.79864, 33.70017], [-117.79861, 33.70013], [-117.79866, 33.70008], [-117.7987, 33.7001], [-117.79883, 33.69998], [-117.798, 33.69939], [-117.7983, 33.69909], [-117.79817, 33.699], [-117.79826, 33.6989], [-117.79719, 33.69814], [-117.79754, 33.69802], [-117.79764, 33.69806], [-117.79779, 33.69828], [-117.79799, 33.69851], [-117.7982, 33.6987], [-117.79867, 33.69904], [-117.79879, 33.69915], [-117.79888, 33.69928], [-117.79895, 33.69943], [-117.79899, 33.69965], [-117.79897, 33.6998], [-117.79893, 33.69995], [-117.79887, 33.70008], [-117.79878, 33.70019], [-117.7984, 33.70058], [-117.79823, 33.70071], [-117.7982, 33.70076], [-117.79819, 33.70082], [-117.79822, 33.7009], [-117.79826, 33.70094], [-117.79847, 33.70104], [-117.79917, 33.70154], [-117.79919, 33.70158], [-117.79917, 33.70162]]]}	Restricted Access 2	47906	Windwood Park	31992	6033	Windwood Homeowners Association 926	Private 7	Home Owners Association 16		Private 14	6033	Windwood Homeowners Association 899	Private 7	Home Owners Association 15		Orange 3	3.259	Windwood Park	0	Private Recreation or Education 65	4
13461	13461	13460	{"type": "Polygon", "coordinates": [[[-117.80198, 33.70068], [-117.80192, 33.70074], [-117.80161, 33.70026], [-117.80139, 33.69982], [-117.80015, 33.69992], [-117.79916, 33.69984], [-117.79919, 33.69972], [-117.80014, 33.69978], [-117.80133, 33.69968], [-117.80117, 33.69913], [-117.8011, 33.69879], [-117.80097, 33.69768], [-117.80103, 33.69767], [-117.80109, 33.69772], [-117.80121, 33.69876], [-117.80128, 33.69916], [-117.80152, 33.69981], [-117.80176, 33.70031], [-117.80198, 33.70068]]]}	Restricted Access 2	35680	HOA Community Park	31871	6033	Windwood Homeowners Association 926	Private 7	Home Owners Association 16		Private 14	6033	Windwood Homeowners Association 899	Private 7	Home Owners Association 15		Orange 3	1.688	HOA Community 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]);