calands: superunits_with_maps: 2 rows where ACCESS_TYP = 2 and MNG

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

2 rows where ACCESS_TYP = 2 and MNG_AGENCY = 899

Search:

descending

This data as json, copyable, CSV (advanced)

Link	rowid ▼	id	map	ACCESS_TYP	PARK_NAME	PARK_URL	SUID_NMA	MNG_AG_ID	MNG_AGENCY	MNG_AG_LEV	MNG_AG_TYP	AGNCY_WEB	LAYER	ACRES	LABEL_NAME	YR_EST
225	225	224	{"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.80132, 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	HOA Community Park		31871	6033	Windwood Homeowners Association 899	Private 7	Home Owners Association 15		Private 14	1.699	HOA Community Park
388	388	387	{"type": "Polygon", "coordinates": [[[-117.79919, 33.70158], [-117.79917, 33.70162], [-117.79897, 33.70148], [-117.79893, 33.70151], [-117.79887, 33.70146], [-117.79888, 33.70142], [-117.7986, 33.70122], [-117.79855, 33.70125], [-117.79849, 33.7012], [-117.79851, 33.70116], [-117.79822, 33.70096], [-117.79818, 33.70099], [-117.79812, 33.70094], [-117.79814, 33.7009], [-117.798, 33.7008], [-117.79808, 33.7007], [-117.79794, 33.70061], [-117.79788, 33.70065], [-117.79785, 33.70061], [-117.79782, 33.70061], [-117.79785, 33.70055], [-117.79756, 33.70035], [-117.7975, 33.70038], [-117.79747, 33.70035], [-117.79744, 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.79777, 33.70037], [-117.79786, 33.70029], [-117.79787, 33.7003], [-117.79784, 33.70037], [-117.79788, 33.70045], [-117.79796, 33.70049], [-117.79805, 33.70048], [-117.79821, 33.70059], [-117.79832, 33.70048], [-117.79832, 33.70046], [-117.79837, 33.70041], [-117.7984, 33.70041], [-117.79863, 33.70017], [-117.79861, 33.70013], [-117.79866, 33.70008], [-117.79871, 33.7001], [-117.79882, 33.69998], [-117.798, 33.69939], [-117.79829, 33.6991], [-117.79817, 33.699], [-117.79825, 33.69889], [-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.70105], [-117.79917, 33.70154], [-117.79919, 33.70158]]]}	Restricted Access 2	Windwood Park		31992	6033	Windwood Homeowners Association 899	Private 7	Home Owners Association 15		Private 14	3.281	Windwood Park

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE superunits_with_maps(
  id INT,
  map,
  ACCESS_TYP INT,
  PARK_NAME TEXT,
  PARK_URL TEXT,
  SUID_NMA INT,
  MNG_AG_ID INT,
  MNG_AGENCY INT,
  MNG_AG_LEV INT,
  MNG_AG_TYP INT,
  AGNCY_WEB TEXT,
  LAYER INT,
  ACRES REAL,
  LABEL_NAME TEXT,
  YR_EST INT,
   FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id])
);
CREATE INDEX [idx_superunits_with_maps_LAYER]
    ON [superunits_with_maps] ([LAYER]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP]
    ON [superunits_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV]
    ON [superunits_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY]
    ON [superunits_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP]
    ON [superunits_with_maps] ([ACCESS_TYP]);