units_with_maps

Table actions

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

1 row where AGNCY_TYP = 13, DES_TP = 1045, MNG_AGENCY = 964 and MNG_AG_TYP = 13

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Water District · 1 ✖

MNG_AGENCY 1

  • United Water Conservation District · 1 ✖

DES_TP 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
11888 11888 11887 {"type": "Polygon", "coordinates": [[[-118.76808, 34.47879], [-118.76786, 34.47918], [-118.76708, 34.4798], [-118.76614, 34.47971], [-118.76426, 34.47986], [-118.76106, 34.47941], [-118.76042, 34.47909], [-118.76006, 34.47909], [-118.75992, 34.47934], [-118.76011, 34.48011], [-118.75987, 34.48062], [-118.75989, 34.48101], [-118.76011, 34.48147], [-118.76037, 34.48172], [-118.76108, 34.4819], [-118.76249, 34.48209], [-118.7626, 34.48218], [-118.76263, 34.48241], [-118.76235, 34.48268], [-118.76188, 34.4828], [-118.76138, 34.48314], [-118.76078, 34.48325], [-118.75986, 34.48371], [-118.75975, 34.48389], [-118.75981, 34.48417], [-118.76003, 34.4844], [-118.76008, 34.48463], [-118.7597, 34.48479], [-118.75958, 34.48514], [-118.75942, 34.48606], [-118.75966, 34.48629], [-118.75113, 34.49141], [-118.75113, 34.49101], [-118.75088, 34.49091], [-118.75068, 34.49064], [-118.75068, 34.49039], [-118.75046, 34.49005], [-118.74974, 34.48957], [-118.74927, 34.48904], [-118.74863, 34.48888], [-118.74852, 34.48874], [-118.74873, 34.48777], [-118.74855, 34.4876], [-118.74817, 34.48758], [-118.74788, 34.48781], [-118.74781, 34.48797], [-118.74722, 34.48845], [-118.7466, 34.48861], [-118.74659, 34.48835], [-118.74678, 34.48792], [-118.74676, 34.48759], [-118.74634, 34.48749], [-118.74598, 34.48754], [-118.7449, 34.48804], [-118.74396, 34.48802], [-118.74317, 34.48831], [-118.74176, 34.48838], [-118.74116, 34.48808], [-118.74112, 34.48772], [-118.74152, 34.48743], [-118.74252, 34.48733], [-118.74365, 34.48705], [-118.74649, 34.48602], [-118.74823, 34.48602], [-118.74829, 34.48595], [-118.74805, 34.48522], [-118.74769, 34.48489], [-118.74758, 34.48451], [-118.74708, 34.48403], [-118.74705, 34.48371], [-118.74713, 34.48341], [-118.74705, 34.48323], [-118.7468, 34.48311], [-118.74664, 34.48279], [-118.74622, 34.48277], [-118.74573, 34.48288], [-118.74534, 34.48322], [-118.74503, 34.48334], [-118.74495, 34.48327], [-118.74495, 34.48309], [-118.74536, 34.48247], [-118.74578, 34.48217], [-118.74666, 34.48194], [-118.74688, 34.48176], [-118.74693, 34.48142], [-118.74553, 34.48114], [-118.74492, 34.48114], [-118.74412, 34.4816], [-118.74318, 34.48167], [-118.74285, 34.48183], [-118.74249, 34.48188], [-118.74163, 34.48158], [-118.74169, 34.48135], [-118.74188, 34.48124], [-118.74326, 34.48103], [-118.74343, 34.48062], [-118.74423, 34.48052], [-118.74517, 34.4803], [-118.74553, 34.48], [-118.74592, 34.47995], [-118.74672, 34.48007], [-118.74708, 34.47991], [-118.74727, 34.4797], [-118.7473, 34.4794], [-118.74755, 34.47894], [-118.74821, 34.47855], [-118.7482, 34.4783], [-118.74801, 34.47821], [-118.74719, 34.47805], [-118.74683, 34.4783], [-118.74658, 34.47835], [-118.74647, 34.47798], [-118.74633, 34.47789], [-118.74614, 34.47789], [-118.74602, 34.47778], [-118.74553, 34.47775], [-118.74544, 34.47768], [-118.74544, 34.47752], [-118.7453, 34.47741], [-118.74484, 34.47748], [-118.74484, 34.47721], [-118.74519, 34.47684], [-118.74522, 34.47663], [-118.74511, 34.47654], [-118.74489, 34.47652], [-118.7445, 34.47682], [-118.74428, 34.47686], [-118.74417, 34.47677], [-118.74464, 34.47592], [-118.74489, 34.47569], [-118.74589, 34.47581], [-118.74602, 34.47574], [-118.74624, 34.4753], [-118.74685, 34.47528], [-118.74693, 34.4751], [-118.74649, 34.47386], [-118.74641, 34.47381], [-118.74591, 34.4726], [-118.74558, 34.4724], [-118.7453, 34.47251], [-118.74439, 34.47258], [-118.74422, 34.47235], [-118.74386, 34.47226], [-118.74312, 34.47228], [-118.74215, 34.47171], [-118.74168, 34.4715], [-118.7414, 34.4715], [-118.74107, 34.4718], [-118.74088, 34.47242], [-118.74057, 34.47242], [-118.74051, 34.47162], [-118.74021, 34.47146], [-118.73977, 34.47153], [-118.7393, 34.47196], [-118.73905, 34.47205], [-118.73894, 34.47198], [-118.73902, 34.4713], [-118.73891, 34.47121], [-118.73859, 34.47119], [-118.7383, 34.47169], [-118.73767, 34.47228], [-118.73781, 34.47331], [-118.73753, 34.47389], [-118.73728, 34.47398], [-118.7372, 34.47391], [-118.73709, 34.47323], [-118.73665, 34.47313], [-118.73651, 34.47325], [-118.7362, 34.47398], [-118.73593, 34.47425], [-118.73529, 34.47446], [-118.73496, 34.47478], [-118.73433, 34.47476], [-118.73402, 34.47485], [-118.73358, 34.47538], [-118.73341, 34.4754], [-118.73275, 34.47515], [-118.73261, 34.47446], [-118.7328, 34.47428], [-118.73325, 34.47352], [-118.73546, 34.47263], [-118.73568, 34.47226], [-118.73571, 34.47162], [-118.73615, 34.47109], [-118.73684, 34.47084], [-118.73698, 34.47073], [-118.73695, 34.47057], [-118.73676, 34.47045], [-118.73551, 34.47032], [-118.73501, 34.47013], [-118.7341, 34.46906], [-118.7341, 34.46887], [-118.73501, 34.4688], [-118.73534, 34.46935], [-118.73559, 34.46947], [-118.73642, 34.46956], [-118.7372, 34.46949], [-118.73844, 34.46974], [-118.73955, 34.46947], [-118.73988, 34.46903], [-118.74013, 34.46901], [-118.74016, 34.46922], [-118.74046, 34.4694], [-118.74149, 34.46942], [-118.74259, 34.46921], [-118.74328, 34.46935], [-118.74395, 34.46956], [-118.74579, 34.46962], [-118.74585, 34.46882], [-118.74602, 34.46878], [-118.74654, 34.4694], [-118.74685, 34.46946], [-118.74718, 34.46974], [-118.74754, 34.46969], [-118.74911, 34.46839], [-118.74903, 34.46779], [-118.74917, 34.46758], [-118.74909, 34.46685], [-118.74939, 34.46673], [-118.74942, 34.466], [-118.74986, 34.46552], [-118.74997, 34.46525], [-118.75041, 34.46479], [-118.75041, 34.46443], [-118.75022, 34.46426], [-118.74922, 34.46415], [-118.7488, 34.46376], [-118.74787, 34.46365], [-118.7474, 34.46337], [-118.7474, 34.46319], [-118.74856, 34.46308], [-118.74966, 34.46316], [-118.74986, 34.46298], [-118.74986, 34.46257], [-118.74966, 34.46204], [-118.74977, 34.46165], [-118.75091, 34.46149], [-118.75261, 34.46131], [-118.75374, 34.46108], [-118.7541, 34.46115], [-118.75487, 34.46154], [-118.75498, 34.46218], [-118.75537, 34.46255], [-118.75559, 34.46321], [-118.75573, 34.4634], [-118.75576, 34.46392], [-118.75559, 34.46425], [-118.75565, 34.46454], [-118.75581, 34.46482], [-118.75667, 34.46521], [-118.75664, 34.46541], [-118.75636, 34.46551], [-118.75626, 34.46578], [-118.75656, 34.46596], [-118.75744, 34.46617], [-118.75788, 34.46642], [-118.75846, 34.46656], [-118.75888, 34.46683], [-118.75929, 34.46695], [-118.76018, 34.46697], [-118.76045, 34.46702], [-118.7604, 34.46722], [-118.75913, 34.46759], [-118.75874, 34.46803], [-118.75871, 34.46922], [-118.75849, 34.46965], [-118.75863, 34.47009], [-118.7586, 34.47068], [-118.75907, 34.47109], [-118.75907, 34.4713], [-118.75827, 34.47183], [-118.75766, 34.47249], [-118.75658, 34.47295], [-118.75653, 34.4732], [-118.75702, 34.47347], [-118.75774, 34.4737], [-118.7597, 34.47398], [-118.76034, 34.47416], [-118.76053, 34.47435], [-118.76081, 34.47496], [-118.76128, 34.47535], [-118.7612, 34.47593], [-118.76084, 34.47648], [-118.76084, 34.47675], [-118.76095, 34.47693], [-118.76145, 34.47709], [-118.762, 34.47705], [-118.76242, 34.47685], [-118.76266, 34.47712], [-118.76369, 34.4768], [-118.76409, 34.4769], [-118.7641, 34.47689], [-118.76407, 34.47675], [-118.76421, 34.4768], [-118.76504, 34.47671], [-118.76584, 34.47709], [-118.76656, 34.47719], [-118.76692, 34.47767], [-118.76728, 34.4779], [-118.76761, 34.47797], [-118.76802, 34.47833], [-118.76808, 34.47879]]]} Open Access 1 24341 Lake Piru 14312 2266 United Water Conservation District 1001 Special District 4 Water District 13 http://www.unitedwater.org/ Special District 4 2266 United Water Conservation District 964 Special District 4 Water District 13 http://campone.com/campsites/lake-piru/ Ventura 8 974.051 Lake Piru   None 1045  

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