units_with_maps

Table actions

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

1 row where DES_TP = 4, MNG_AGENCY = 798, MNG_AG_TYP = 13 and UNIT_NAME = "Carnadero Preserve"

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Water District · 1 ✖

MNG_AGENCY 1

  • Santa Clara Valley Water District · 1 ✖

DES_TP 1

  • Local Conservation Area · 1 ✖

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
9240 9240 9239 {"type": "MultiPolygon", "coordinates": [[[[-121.54901, 36.93552], [-121.549, 36.93611], [-121.54882, 36.93705], [-121.5486, 36.93685], [-121.54862, 36.93671], [-121.54872, 36.9366], [-121.54873, 36.93648], [-121.54867, 36.93646], [-121.5487, 36.93629], [-121.54861, 36.93569], [-121.54765, 36.93513], [-121.54763, 36.935], [-121.54515, 36.93499], [-121.54345, 36.93831], [-121.54138, 36.93918], [-121.54121, 36.93996], [-121.541, 36.94031], [-121.54047, 36.94128], [-121.53849, 36.94129], [-121.53673, 36.94358], [-121.53605, 36.94437], [-121.53605, 36.9465], [-121.53608, 36.94709], [-121.53607, 36.94755], [-121.53593, 36.94879], [-121.53593, 36.94916], [-121.53288, 36.94791], [-121.53326, 36.94725], [-121.53339, 36.9469], [-121.53349, 36.94609], [-121.53361, 36.94562], [-121.53373, 36.94514], [-121.53399, 36.94451], [-121.53398, 36.94417], [-121.53409, 36.94385], [-121.5344, 36.94343], [-121.5352, 36.94296], [-121.53533, 36.94274], [-121.53554, 36.94223], [-121.53583, 36.94169], [-121.53613, 36.94152], [-121.5366, 36.94107], [-121.53708, 36.94057], [-121.53739, 36.94022], [-121.53765, 36.94005], [-121.53796, 36.93996], [-121.53848, 36.93963], [-121.53873, 36.93952], [-121.53905, 36.93942], [-121.53931, 36.93929], [-121.53947, 36.93915], [-121.53996, 36.93831], [-121.54011, 36.93814], [-121.5404, 36.93796], [-121.54127, 36.93765], [-121.54166, 36.93754], [-121.54203, 36.93714], [-121.54223, 36.93682], [-121.54249, 36.93648], [-121.54252, 36.93618], [-121.5425, 36.93566], [-121.54256, 36.93528], [-121.54275, 36.93504], [-121.54359, 36.93439], [-121.54367, 36.93419], [-121.54371, 36.93387], [-121.54367, 36.93359], [-121.54351, 36.93318], [-121.54321, 36.93265], [-121.54301, 36.93193], [-121.54284, 36.93149], [-121.54251, 36.93097], [-121.5423, 36.93054], [-121.54211, 36.92995], [-121.54197, 36.92966], [-121.54181, 36.92901], [-121.54178, 36.92873], [-121.54167, 36.92818], [-121.54113, 36.92744], [-121.54088, 36.92687], [-121.54069, 36.92647], [-121.54061, 36.9261], [-121.5407, 36.92576], [-121.54068, 36.92576], [-121.5404, 36.92599], [-121.53995, 36.92599], [-121.53994, 36.92598], [-121.5401, 36.92588], [-121.54048, 36.92572], [-121.54081, 36.92545], [-121.54092, 36.92515], [-121.54089, 36.92486], [-121.54082, 36.92472], [-121.54051, 36.92429], [-121.54031, 36.92409], [-121.54008, 36.9239], [-121.53984, 36.92368], [-121.53949, 36.92343], [-121.53923, 36.92302], [-121.53919, 36.92291], [-121.54048, 36.92421], [-121.54068, 36.92418], [-121.54125, 36.92449], [-121.54134, 36.92457], [-121.54213, 36.92541], [-121.54282, 36.92621], [-121.54293, 36.92628], [-121.54308, 36.92635], [-121.54349, 36.92644], [-121.54377, 36.92647], [-121.54438, 36.9265], [-121.54449, 36.92652], [-121.54466, 36.9266], [-121.54508, 36.9269], [-121.54522, 36.92703], [-121.54535, 36.92722], [-121.54559, 36.92765], [-121.54568, 36.92777], [-121.5465, 36.92859], [-121.54681, 36.92879], [-121.54713, 36.92881], [-121.54738, 36.92913], [-121.54803, 36.92996], [-121.54809, 36.93056], [-121.54454, 36.93123], [-121.54454, 36.93125], [-121.54508, 36.9325], [-121.54551, 36.93284], [-121.54631, 36.93284], [-121.54665, 36.93301], [-121.5474, 36.93298], [-121.54763, 36.9334], [-121.54758, 36.93377], [-121.5477, 36.93414], [-121.54788, 36.93444], [-121.54796, 36.93491], [-121.54901, 36.93552]]], [[[-121.55239, 36.94284], [-121.55219, 36.94286], [-121.55189, 36.94222], [-121.55171, 36.94155], [-121.55116, 36.94063], [-121.55112, 36.93858], [-121.54879, 36.93856], [-121.54916, 36.93661], [-121.55147, 36.93685], [-121.5515, 36.93708], [-121.5516, 36.9394], [-121.55153, 36.94059], [-121.55207, 36.94146], [-121.55238, 36.94236], [-121.55239, 36.94284]]]]} No Public Access 3 15376 Carnadero Preserve 16881 2143 Santa Clara Valley Water District 483 Special District 4 Water District 13 http://www.valleywater.org/ Special District 4 2143 Santa Clara Valley Water District 798 Special District 4 Water District 13   Santa Clara 19 196.338 Carnadero Preserve 0 Local Conservation Area 4 2

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