superunits_with_maps

Table actions

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

2 rows where LAYER = 14 and MNG_AGENCY = 899 sorted by map

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Windwood Homeowners Association · 2 ✖

LAYER 1 ✖

  • Private · 2 ✖

ACCESS_TYP 1

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
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  
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  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);