units_with_maps

Table actions

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

1 row where LABEL_NAME = "Lauro Canyon Reservoir" and MNG_AG_TYP = 1

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Federal Agency · 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
9457 9457 9456 {"type": "MultiPolygon", "coordinates": [[[[-119.72944, 34.45213], [-119.72942, 34.45219], [-119.72901, 34.45218], [-119.72857, 34.4527], [-119.72858, 34.45271], [-119.72912, 34.45273], [-119.72883, 34.45333], [-119.72897, 34.45366], [-119.72866, 34.45405], [-119.72831, 34.45457], [-119.72824, 34.45469], [-119.72822, 34.45503], [-119.72818, 34.45524], [-119.72804, 34.45538], [-119.72768, 34.45558], [-119.7276, 34.45564], [-119.72752, 34.45573], [-119.72743, 34.45594], [-119.72732, 34.45647], [-119.72719, 34.45676], [-119.72672, 34.4575], [-119.72602, 34.45853], [-119.72589, 34.45869], [-119.72583, 34.45875], [-119.72567, 34.45885], [-119.7255, 34.45892], [-119.72532, 34.45894], [-119.72514, 34.45893], [-119.72496, 34.45887], [-119.72489, 34.45882], [-119.72483, 34.45875], [-119.72466, 34.4585], [-119.72458, 34.45842], [-119.72447, 34.45835], [-119.72436, 34.4583], [-119.72412, 34.45825], [-119.72343, 34.45832], [-119.72235, 34.45839], [-119.72181, 34.45862], [-119.72159, 34.45739], [-119.72133, 34.45486], [-119.72324, 34.45416], [-119.72325, 34.45395], [-119.72775, 34.45265], [-119.72822, 34.4527], [-119.72821, 34.45247], [-119.72808, 34.45176], [-119.72869, 34.45118], [-119.72944, 34.45213]]], [[[-119.72632, 34.45843], [-119.72606, 34.45898], [-119.72536, 34.45924], [-119.72478, 34.4591], [-119.72397, 34.45854], [-119.72322, 34.45856], [-119.72321, 34.45884], [-119.72314, 34.45884], [-119.72314, 34.45888], [-119.72257, 34.45882], [-119.72188, 34.45884], [-119.72188, 34.45878], [-119.7224, 34.45854], [-119.72251, 34.45852], [-119.72335, 34.45849], [-119.72411, 34.45842], [-119.72428, 34.45845], [-119.72444, 34.45854], [-119.7245, 34.4586], [-119.72466, 34.45885], [-119.72484, 34.459], [-119.72515, 34.4591], [-119.72533, 34.45912], [-119.72546, 34.4591], [-119.72567, 34.45904], [-119.72588, 34.45893], [-119.72605, 34.4588], [-119.72632, 34.45843]]], [[[-119.73094, 34.45454], [-119.73033, 34.4557], [-119.72912, 34.45712], [-119.7276, 34.45752], [-119.72687, 34.4575], [-119.72725, 34.45691], [-119.72737, 34.4567], [-119.72745, 34.45649], [-119.72759, 34.45587], [-119.72767, 34.45574], [-119.72777, 34.45565], [-119.72804, 34.45552], [-119.72818, 34.45542], [-119.72839, 34.45531], [-119.7287, 34.45521], [-119.72882, 34.45538], [-119.72897, 34.45553], [-119.72888, 34.45567], [-119.72908, 34.45568], [-119.72918, 34.45555], [-119.72896, 34.45534], [-119.72861, 34.45471], [-119.72859, 34.45455], [-119.72879, 34.45422], [-119.73094, 34.45454]]]]} Open Access 1 17296 Lauro Canyon Reservoir 33318 103 United States Bureau of Reclamation 369 Federal 1 Federal Agency 1 http://www.usbr.gov/ Other Federal 13 103 United States Bureau of Reclamation 364 Federal 1 Federal Agency 1   Santa Barbara 7 97.858 Lauro Canyon Reservoir 0 Resource Management Area 82 3

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