superunits_with_maps

Table actions

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

4 rows where MNG_AGENCY = 672 and MNG_AG_TYP = 13

This data as json, copyable, CSV (advanced)

ACCESS_TYP 2

MNG_AG_TYP 1

  • Water District · 4 ✖

MNG_AGENCY 1

  • Valley Center Water District · 4 ✖
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
1699 1699 1698 {"type": "Polygon", "coordinates": [[[-117.40597, 34.07031], [-117.40479, 34.07031], [-117.40478, 34.06832], [-117.40534, 34.06832], [-117.40596, 34.06828], [-117.40597, 34.07031]]]} Open Access 1 Ayala Park   15735 2321 Valley Center Water District 672 Special District 4 Water District 13 http://www.vcmwd.org/ Special District 4 6.001 Ayala Park  
5729 5729 5728 {"type": "Polygon", "coordinates": [[[-117.40315, 34.04849], [-117.40144, 34.0485], [-117.40142, 34.04844], [-117.40084, 34.04844], [-117.40084, 34.04673], [-117.40086, 34.0467], [-117.4009, 34.04669], [-117.40131, 34.04669], [-117.40133, 34.04661], [-117.40143, 34.04658], [-117.40143, 34.04463], [-117.40146, 34.04463], [-117.40147, 34.04666], [-117.40226, 34.04667], [-117.40227, 34.04671], [-117.40315, 34.04671], [-117.40315, 34.04849]]]} Open Access 1 Kessler Park   20635 2321 Valley Center Water District 672 Special District 4 Water District 13 http://www.vcmwd.org/ Special District 4 10.685 Kessler Park  
10507 10507 10506 {"type": "MultiPolygon", "coordinates": [[[[-117.08543, 33.22613], [-117.08543, 33.22629], [-117.08327, 33.22627], [-117.08316, 33.22632], [-117.08298, 33.22611], [-117.08291, 33.22611], [-117.08156, 33.22666], [-117.0814, 33.22676], [-117.08134, 33.22684], [-117.08129, 33.22695], [-117.08125, 33.22713], [-117.08129, 33.22767], [-117.08127, 33.22783], [-117.0812, 33.22796], [-117.0811, 33.22805], [-117.08093, 33.22813], [-117.08054, 33.22816], [-117.08034, 33.22821], [-117.07993, 33.22836], [-117.07975, 33.22838], [-117.07957, 33.22839], [-117.07936, 33.22837], [-117.07813, 33.22815], [-117.0768, 33.22785], [-117.07542, 33.22747], [-117.07349, 33.22687], [-117.07315, 33.22673], [-117.07274, 33.22649], [-117.07253, 33.2264], [-117.07253, 33.22601], [-117.07042, 33.22599], [-117.0704, 33.22233], [-117.06955, 33.22231], [-117.06953, 33.22217], [-117.06815, 33.22216], [-117.06808, 33.21864], [-117.07262, 33.21865], [-117.08118, 33.21878], [-117.08118, 33.22243], [-117.08321, 33.22248], [-117.08319, 33.2261], [-117.08543, 33.22613]]], [[[-117.08151, 33.22978], [-117.07891, 33.22974], [-117.07894, 33.22846], [-117.0794, 33.22855], [-117.07975, 33.22855], [-117.08005, 33.2285], [-117.08033, 33.22838], [-117.0805, 33.22834], [-117.08102, 33.22827], [-117.08121, 33.22819], [-117.08136, 33.22805], [-117.08145, 33.22788], [-117.08149, 33.22768], [-117.08154, 33.22811], [-117.08151, 33.22978]]]]} No Public Access 3 Turner Lake Reservoir   26585 2321 Valley Center Water District 672 Special District 4 Water District 13 http://www.vcmwd.org/ Special District 4 290.222 Turner Lake Reservoir  
10616 10616 10615 {"type": "Polygon", "coordinates": [[[-117.046, 33.25229], [-117.0459, 33.25362], [-117.04581, 33.25622], [-117.04584, 33.25988], [-117.04315, 33.25987], [-117.04304, 33.25622], [-117.04149, 33.2562], [-117.04135, 33.25228], [-117.046, 33.25229]]]} No Public Access 3 Valley Center MWDD Open Space   26786 2321 Valley Center Water District 672 Special District 4 Water District 13 http://www.vcmwd.org/ Special District 4 70.334 Valley Ctr. MWDD OS  

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