superunits_with_maps

Table actions

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

1 row where MNG_AG_TYP = 5 and PARK_URL = "https://ucnrs.org/reserves/motte-rimrock-reserve/"

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • State Agency · 1 ✖

MNG_AGENCY 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
7234 7234 7233 {"type": "Polygon", "coordinates": [[[-117.26806, 33.81916], [-117.26149, 33.81923], [-117.26146, 33.81559], [-117.25705, 33.81565], [-117.25703, 33.81374], [-117.25263, 33.81378], [-117.25261, 33.81197], [-117.24922, 33.81201], [-117.24922, 33.81118], [-117.24944, 33.81115], [-117.24944, 33.81101], [-117.24934, 33.811], [-117.24936, 33.80968], [-117.24914, 33.80928], [-117.24891, 33.80927], [-117.24891, 33.80833], [-117.24841, 33.80795], [-117.24847, 33.80788], [-117.24838, 33.80781], [-117.24813, 33.80745], [-117.24906, 33.8073], [-117.24907, 33.80729], [-117.2488, 33.80702], [-117.24873, 33.80676], [-117.24778, 33.80691], [-117.2474, 33.80529], [-117.24836, 33.80514], [-117.24825, 33.80463], [-117.24825, 33.80456], [-117.24606, 33.80457], [-117.24603, 33.8029], [-117.24629, 33.80289], [-117.24664, 33.80296], [-117.2467, 33.80295], [-117.24675, 33.80291], [-117.24679, 33.80281], [-117.24825, 33.80281], [-117.24827, 33.80108], [-117.25252, 33.80114], [-117.25411, 33.8011], [-117.25412, 33.79918], [-117.25422, 33.79916], [-117.25422, 33.7985], [-117.25412, 33.79848], [-117.25411, 33.79594], [-117.25254, 33.79592], [-117.25253, 33.79622], [-117.2504, 33.79625], [-117.25039, 33.79599], [-117.25052, 33.79579], [-117.25039, 33.79575], [-117.25037, 33.79556], [-117.24996, 33.79556], [-117.24931, 33.79527], [-117.24881, 33.79534], [-117.24862, 33.79556], [-117.24821, 33.79556], [-117.24808, 33.78924], [-117.25025, 33.78924], [-117.2503, 33.79101], [-117.25252, 33.79101], [-117.25254, 33.79438], [-117.26128, 33.79438], [-117.26134, 33.80817], [-117.26358, 33.80819], [-117.2636, 33.81004], [-117.26579, 33.81005], [-117.2658, 33.81188], [-117.26689, 33.81188], [-117.26694, 33.81553], [-117.26801, 33.81554], [-117.26806, 33.81916]], [[-117.25354, 33.79496], [-117.25355, 33.79483], [-117.2534, 33.79483], [-117.2534, 33.79495], [-117.25354, 33.79496]], [[-117.26584, 33.81556], [-117.26585, 33.81555], [-117.26579, 33.81189], [-117.26141, 33.8119], [-117.26146, 33.81559], [-117.26584, 33.81556]]]} Restricted Access 2 Motte Rimrock Reserve https://ucnrs.org/reserves/motte-rimrock-reserve/ 22519 217 University of California 51 State 5 State Agency 5 http://nrs.ucop.edu/ Other State 5 717.949 Motte Rimrock Reserve  

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