units_with_maps

Table actions

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

2 rows where COUNTY = 4, MNG_AG_ID = 2321 and MNG_AG_TYP = 13

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Water District · 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
3826 3826 3825 {"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 45243 Valley Center MWDD Open Space 26786 2321 Valley Center Water District 689 Special District 4 Water District 13 http://www.vcmwd.org/ Special District 4 2321 Valley Center Water District 672 Special District 4 Water District 13   San Diego 4 70.32 Valley Ctr. MWDD OS 0 Local Recreation Area 3 4
14757 14757 14756 {"type": "MultiPolygon", "coordinates": [[[[-117.08543, 33.22613], [-117.08543, 33.22629], [-117.08327, 33.22627], [-117.08316, 33.22632], [-117.08297, 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.22768], [-117.08127, 33.22783], [-117.0812, 33.22796], [-117.0811, 33.22805], [-117.08093, 33.22813], [-117.08054, 33.22816], [-117.08033, 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.06954, 33.22217], [-117.06815, 33.22216], [-117.06808, 33.21864], [-117.07262, 33.21865], [-117.08118, 33.21878], [-117.08117, 33.22244], [-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 45135 Turner Lake Reservoir 26585 2321 Valley Center Water District 689 Special District 4 Water District 13 http://www.vcmwd.org/ Special District 4 2321 Valley Center Water District 672 Special District 4 Water District 13   San Diego 4 290.169 Turner Lake Reservoir 0 Local Recreation Area 3 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]);