superunits_with_maps

Table actions

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

3 rows where ACCESS_TYP = 3, AGNCY_WEB = "http://nrs.ucop.edu/" and MNG_AG_LEV = 5

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

ACCESS_TYP 1

  • No Public Access · 3 ✖
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
6307 6307 6306 {"type": "Polygon", "coordinates": [[[-121.7562, 37.72355], [-121.75619, 37.73783], [-121.75386, 37.73785], [-121.7539, 37.73081], [-121.7516, 37.73078], [-121.75166, 37.72355], [-121.7562, 37.72355]]]} No Public Access 3 Livermore Monitoring Station   21382 217 University of California 51 State 5 State Agency 5 http://nrs.ucop.edu/ Other State 5 119.349 Livermore Monitoring Station  
13620 13620 13619 {"type": "Polygon", "coordinates": [[[-117.30505, 33.97199], [-117.30066, 33.97196], [-117.30065, 33.97556], [-117.29645, 33.97552], [-117.2965, 33.96463], [-117.30083, 33.96465], [-117.30087, 33.96814], [-117.30505, 33.96813], [-117.30505, 33.97199]]]} No Public Access 3 Box Springs Reserve http://www.ucnrs.org/reserves/box-springs-reserve.html 31388 217 University of California 51 State 5 State Agency 5 http://nrs.ucop.edu/ Other State 5 159.883 Box Springs Reserve  
13839 13839 13838 {"type": "Polygon", "coordinates": [[[-116.45768, 34.14968], [-116.45335, 34.1497], [-116.45333, 34.15015], [-116.45115, 34.15016], [-116.45114, 34.14929], [-116.44898, 34.1493], [-116.44892, 34.13524], [-116.45764, 34.13534], [-116.45767, 34.14247], [-116.45768, 34.14968]], [[-116.45762, 34.14812], [-116.45761, 34.14811], [-116.45654, 34.14811], [-116.45653, 34.14608], [-116.45332, 34.1461], [-116.45334, 34.147], [-116.45654, 34.14833], [-116.4576, 34.14833], [-116.45762, 34.14812]]]} No Public Access 3 Burns Piñon Ridge Reserve http://www.ucnrs.org/reserves/burns-pinon-ridge-reserve.html 31389 217 University of California 51 State 5 State Agency 5 http://nrs.ucop.edu/ Other State 5 304.485 Burns Piñon Ridge 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]);