units_with_maps

Table actions

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

1 row where AGNCY_ID = 100, AGNCY_TYP = 1 and DES_TP = 13

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

DES_TP 1

  • 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
660 660 659 {"type": "MultiPolygon", "coordinates": [[[[-118.47757, 34.17694], [-118.47653, 34.17753], [-118.47638, 34.17727], [-118.47491, 34.17726], [-118.47488, 34.17866], [-118.47404, 34.17875], [-118.4726, 34.17833], [-118.47255, 34.17833], [-118.47049, 34.17932], [-118.46982, 34.17835], [-118.46942, 34.17769], [-118.46908, 34.17704], [-118.46886, 34.17653], [-118.46876, 34.17623], [-118.46858, 34.17554], [-118.46851, 34.17511], [-118.46844, 34.1746], [-118.46841, 34.17384], [-118.46841, 34.17257], [-118.46879, 34.17257], [-118.46895, 34.17247], [-118.47109, 34.17243], [-118.4711, 34.1725], [-118.47273, 34.1725], [-118.47327, 34.17247], [-118.47381, 34.17242], [-118.47429, 34.17235], [-118.4747, 34.17228], [-118.4754, 34.17212], [-118.47554, 34.17212], [-118.47694, 34.17548], [-118.47723, 34.17608], [-118.47722, 34.17631], [-118.4774, 34.17666], [-118.47757, 34.17694]]], [[[-118.47739, 34.17084], [-118.4769, 34.17105], [-118.47556, 34.17153], [-118.47499, 34.17158], [-118.47358, 34.17183], [-118.47208, 34.17194], [-118.46878, 34.17196], [-118.46878, 34.17102], [-118.46911, 34.17021], [-118.46977, 34.16964], [-118.47092, 34.16895], [-118.4726, 34.16817], [-118.47276, 34.16826], [-118.47323, 34.1681], [-118.47413, 34.16763], [-118.47438, 34.16819], [-118.47571, 34.16965], [-118.47622, 34.1701], [-118.47659, 34.17037], [-118.47706, 34.17067], [-118.47739, 34.17084]]], [[[-118.48363, 34.18069], [-118.48361, 34.18069], [-118.4834, 34.1804], [-118.48315, 34.18014], [-118.47855, 34.17705], [-118.47836, 34.1769], [-118.47815, 34.17669], [-118.47799, 34.17649], [-118.47783, 34.1762], [-118.47595, 34.17177], [-118.47741, 34.17146], [-118.478, 34.17119], [-118.48123, 34.17251], [-118.48092, 34.17304], [-118.48094, 34.17432], [-118.48076, 34.17439], [-118.48075, 34.1744], [-118.48207, 34.1758], [-118.48338, 34.17578], [-118.48342, 34.17774], [-118.48359, 34.17867], [-118.48363, 34.18069]]], [[[-118.50099, 34.18172], [-118.50099, 34.18456], [-118.50095, 34.1855], [-118.50094, 34.18587], [-118.49857, 34.18587], [-118.49856, 34.18608], [-118.49253, 34.18608], [-118.49254, 34.18527], [-118.49305, 34.18528], [-118.49331, 34.18519], [-118.49344, 34.18507], [-118.49351, 34.18486], [-118.49351, 34.18461], [-118.49346, 34.18436], [-118.49679, 34.18321], [-118.49715, 34.18293], [-118.49763, 34.18229], [-118.49761, 34.18051], [-118.49826, 34.18052], [-118.49842, 34.18053], [-118.49856, 34.18058], [-118.49941, 34.18129], [-118.49962, 34.18137], [-118.50004, 34.18139], [-118.50016, 34.18144], [-118.50064, 34.18171], [-118.50079, 34.18175], [-118.50093, 34.18174], [-118.50099, 34.18172]]]]} Open Access 1 3261 Sepulveda Basin Wildlife Reserve 13591 100 United States Army Corps of Engineers 146 Federal 1 Federal Agency 1 http://www.usace.army.mil/ Other Federal 13 100 United States Army Corps of Engineers 142 Federal 1 Federal Agency 1 http://sepulvedabasinwildlife.org/ Los Angeles 6 327.332 Sepulveda Basin Wildlife Reserve 0 Conservation Area 13 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]);