units_with_maps

Table actions

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

1 row where COUNTY = 9 and DES_TP = 515

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
6356 6356 6355 {"type": "Polygon", "coordinates": [[[-120.06436, 36.10851], [-120.06462, 36.10843], [-120.06472, 36.1081], [-120.06474, 36.10732], [-120.06459, 36.10624], [-120.06428, 36.1054], [-120.06369, 36.10452], [-120.06335, 36.10411], [-120.063, 36.10402], [-120.06158, 36.10285], [-120.06294, 36.10181], [-120.06367, 36.10233], [-120.06466, 36.10355], [-120.06547, 36.10478], [-120.06571, 36.10522], [-120.06631, 36.10758], [-120.06636, 36.10886], [-120.06624, 36.10917], [-120.06596, 36.10943], [-120.06593, 36.11201], [-120.06592, 36.11647], [-120.06594, 36.1184], [-120.06585, 36.12112], [-120.06563, 36.12228], [-120.0651, 36.12381], [-120.06458, 36.12488], [-120.06321, 36.12693], [-120.06263, 36.1277], [-120.06199, 36.12863], [-120.06084, 36.13019], [-120.05989, 36.13156], [-120.05912, 36.13284], [-120.05892, 36.13375], [-120.05887, 36.13603], [-120.05892, 36.13662], [-120.05907, 36.13692], [-120.05954, 36.13801], [-120.05943, 36.13826], [-120.05921, 36.13848], [-120.05879, 36.14024], [-120.05644, 36.1436], [-120.05485, 36.14574], [-120.05292, 36.14839], [-120.05151, 36.15028], [-120.05072, 36.15122], [-120.05045, 36.15212], [-120.05075, 36.15246], [-120.05147, 36.15253], [-120.05035, 36.15321], [-120.0502, 36.15351], [-120.05025, 36.15883], [-120.05021, 36.1629], [-120.05022, 36.16702], [-120.05008, 36.17477], [-120.0501, 36.17897], [-120.05013, 36.18062], [-120.05103, 36.18127], [-120.05105, 36.18162], [-120.05002, 36.18159], [-120.0484, 36.18167], [-120.04838, 36.18015], [-120.04846, 36.17576], [-120.04852, 36.16708], [-120.04862, 36.16683], [-120.04875, 36.1641], [-120.04886, 36.15717], [-120.04889, 36.15422], [-120.04888, 36.15293], [-120.04895, 36.15202], [-120.04918, 36.15121], [-120.04973, 36.15034], [-120.05174, 36.14754], [-120.05277, 36.14615], [-120.05514, 36.14305], [-120.05724, 36.14018], [-120.05761, 36.13949], [-120.05773, 36.13865], [-120.05742, 36.13805], [-120.05723, 36.13745], [-120.05725, 36.13538], [-120.05728, 36.13042], [-120.05881, 36.13046], [-120.05996, 36.12893], [-120.06172, 36.12649], [-120.06322, 36.12415], [-120.06351, 36.12334], [-120.06378, 36.12273], [-120.0641, 36.12137], [-120.06437, 36.11999], [-120.06441, 36.11734], [-120.06443, 36.10946], [-120.06437, 36.1091], [-120.06422, 36.10884], [-120.06436, 36.10851]]]} Restricted Access 2 1709 San Luis Canal 24929 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   Fresno 9 327.822 San Luis Canal   None 515  

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