superunits_with_maps

Table actions

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

1 row where LAYER = 10, MNG_AGENCY = 811 and MNG_AG_LEV = 6

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • San Diego Audubon Society · 1 ✖

ACCESS_TYP 1

Link rowid ▼ id map ACCESS_TYP PARK_NAME PARK_URL SUID_NMA MNG_AG_ID MNG_AGENCY MNG_AG_LEV MNG_AG_TYP AGNCY_WEB LAYER ACRES LABEL_NAME YR_EST
9689 9689 9688 {"type": "Polygon", "coordinates": [[[-116.88449, 32.9177], [-116.88442, 32.91819], [-116.88434, 32.91843], [-116.88422, 32.91866], [-116.88382, 32.91883], [-116.88374, 32.91886], [-116.88364, 32.91887], [-116.88353, 32.91892], [-116.88342, 32.919], [-116.88329, 32.91915], [-116.88323, 32.91919], [-116.88322, 32.91923], [-116.88261, 32.91942], [-116.88177, 32.91964], [-116.88175, 32.91967], [-116.88048, 32.92002], [-116.87996, 32.92023], [-116.87923, 32.92062], [-116.87894, 32.92081], [-116.87862, 32.92107], [-116.8761, 32.92338], [-116.87568, 32.92378], [-116.87552, 32.92398], [-116.87355, 32.92403], [-116.87354, 32.92387], [-116.87288, 32.92386], [-116.8671, 32.92734], [-116.86707, 32.92253], [-116.86293, 32.92261], [-116.8629, 32.91899], [-116.85859, 32.91904], [-116.84121, 32.91914], [-116.84119, 32.9155], [-116.85857, 32.91537], [-116.85906, 32.91535], [-116.86072, 32.91536], [-116.86073, 32.91535], [-116.86072, 32.91264], [-116.86927, 32.9126], [-116.87363, 32.91259], [-116.87362, 32.91458], [-116.88181, 32.91446], [-116.88184, 32.91631], [-116.88279, 32.91634], [-116.88275, 32.91768], [-116.88449, 32.9177]]]} Restricted Access 2 Silverwood Wildlife Sanctuary http://www.sandiegoaudubon.org/our-work/sanctuaries/silverwood-wildlife-sanctuary 25502 3064 San Diego Audubon Society 811 Non Profit 6 Non Profit - Conservation 12 http://www.sandiegoaudubon.org/ Non Governmental Organization 10 709.33 Silverwood Wildlife Sanctuary  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE superunits_with_maps(
  id INT,
  map,
  ACCESS_TYP INT,
  PARK_NAME TEXT,
  PARK_URL TEXT,
  SUID_NMA INT,
  MNG_AG_ID INT,
  MNG_AGENCY INT,
  MNG_AG_LEV INT,
  MNG_AG_TYP INT,
  AGNCY_WEB TEXT,
  LAYER INT,
  ACRES REAL,
  LABEL_NAME TEXT,
  YR_EST INT,
   FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id])
);
CREATE INDEX [idx_superunits_with_maps_LAYER]
    ON [superunits_with_maps] ([LAYER]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP]
    ON [superunits_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV]
    ON [superunits_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY]
    ON [superunits_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP]
    ON [superunits_with_maps] ([ACCESS_TYP]);