units_with_maps

Table actions

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

1 row where DES_TP = 700 and LABEL_NAME = "Salton Sea - Bureau of Rec"

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 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
8369 8369 8368 {"type": "MultiPolygon", "coordinates": [[[[-116.0092, 33.42654], [-116.00913, 33.44087], [-115.9918, 33.44094], [-115.9916, 33.45547], [-115.97409, 33.4555], [-115.97389, 33.47011], [-115.99134, 33.4701], [-115.99114, 33.48451], [-115.97371, 33.48456], [-115.97378, 33.49917], [-115.99115, 33.49919], [-115.99146, 33.51068], [-115.97404, 33.51079], [-115.97378, 33.49918], [-115.95644, 33.49917], [-115.9563, 33.5002], [-115.95651, 33.50987], [-115.95652, 33.51085], [-115.93931, 33.51084], [-115.93905, 33.49918], [-115.92182, 33.49937], [-115.92185, 33.48464], [-115.93918, 33.4846], [-115.93924, 33.47014], [-115.92192, 33.47016], [-115.92195, 33.45559], [-115.90464, 33.45563], [-115.90466, 33.44096], [-115.88727, 33.44099], [-115.88723, 33.42704], [-115.9044, 33.42691], [-115.90469, 33.4272], [-115.90467, 33.44096], [-115.92196, 33.44092], [-115.92198, 33.44091], [-115.9221, 33.42682], [-115.92217, 33.42678], [-115.93945, 33.42674], [-115.93938, 33.44093], [-115.95682, 33.44096], [-115.95683, 33.44095], [-115.95693, 33.42693], [-115.95702, 33.42689], [-115.97434, 33.42665], [-115.97441, 33.42673], [-115.97423, 33.44094], [-115.99179, 33.44093], [-115.99202, 33.42654], [-116.0, 33.42649], [-116.00001, 33.42663], [-116.0092, 33.42654]], [[-115.92931, 33.44093], [-115.92197, 33.44093], [-115.92196, 33.45558], [-115.9393, 33.45555], [-115.93937, 33.44094], [-115.92931, 33.44093]], [[-115.95644, 33.48457], [-115.95219, 33.48457], [-115.9523, 33.48127], [-115.95229, 33.48126], [-115.94785, 33.48133], [-115.94782, 33.48458], [-115.93919, 33.4846], [-115.93906, 33.49918], [-115.95643, 33.49916], [-115.95644, 33.48457]], [[-115.95657, 33.47012], [-115.95672, 33.45555], [-115.9393, 33.45555], [-115.93925, 33.47013], [-115.95657, 33.47012]], [[-115.9737, 33.48456], [-115.97388, 33.47012], [-115.95658, 33.47012], [-115.95644, 33.48456], [-115.9737, 33.48456]], [[-115.97423, 33.44095], [-115.97422, 33.44094], [-115.95682, 33.44096], [-115.95672, 33.45554], [-115.9741, 33.45548], [-115.97423, 33.44095]]], [[[-115.89915, 33.48471], [-115.89576, 33.48471], [-115.89558, 33.48097], [-115.89558, 33.48097], [-115.89915, 33.48471]]], [[[-116.07001, 33.51275], [-116.06976, 33.51285], [-116.06933, 33.51281], [-116.06921, 33.51272], [-116.06837, 33.51274], [-116.06779, 33.51297], [-116.06738, 33.51334], [-116.06708, 33.514], [-116.06692, 33.51581], [-116.06645, 33.51597], [-116.06585, 33.51606], [-116.06519, 33.51574], [-116.0638, 33.51462], [-116.06339, 33.5146], [-116.06219, 33.51483], [-116.06118, 33.51482], [-116.06114, 33.51058], [-116.06996, 33.51054], [-116.07001, 33.51275]]]]} Open Access 1 12968 Salton Sea - Bureau of Rec 13839 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   Riverside 10 9406.511 Salton Sea - Bureau of Rec   None 700  

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