units_with_maps

Table actions

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

2 rows where AGNCY_NAME = 926 and MNG_AGENCY = 899

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Windwood Homeowners Association · 2 ✖

ACCESS_TYP 1

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

CSV options: 

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