units_with_maps

Table actions

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

2 rows where ACCESS_TYP = 1, GAP_STS = 2 and MNG_AGENCY = 50

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Save the Redwoods League · 2 ✖

ACCESS_TYP 1

  • Open Access · 2 ✖
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
2888 2888 2887 {"type": "Polygon", "coordinates": [[[-119.79781, 38.30883], [-119.79777, 38.30983], [-119.79674, 38.30981], [-119.79629, 38.30945], [-119.79631, 38.30886], [-119.79781, 38.30883]]]} Open Access 1 48635 Stanislaus National Forest 33338 3074 Save the Redwoods League 52 Non Profit 6 Non Profit - Land Trust 10 http://www.savetheredwoods.org Non Governmental Organization 10 3074 Save the Redwoods League 50 Non Profit 6 Non Profit - Land Trust 10 https://www.savetheredwoods.org/ Tuolumne 21 3.299 Stanislaus NF 0 Private Conservation 16 2
14322 14322 14321 {"type": "Polygon", "coordinates": [[[-123.84998, 39.82879], [-123.84743, 39.82888], [-123.84723, 39.82902], [-123.84606, 39.82912], [-123.84512, 39.82986], [-123.8439, 39.82981], [-123.84369, 39.83019], [-123.84342, 39.83063], [-123.84468, 39.832], [-123.8437, 39.83385], [-123.84267, 39.83451], [-123.8423, 39.8347], [-123.84174, 39.83484], [-123.84164, 39.83488], [-123.84048, 39.83364], [-123.84022, 39.83228], [-123.84092, 39.83265], [-123.84166, 39.83204], [-123.8409, 39.83138], [-123.83928, 39.83063], [-123.83855, 39.83078], [-123.83781, 39.83039], [-123.83608, 39.82986], [-123.835, 39.82912], [-123.83365, 39.82914], [-123.83284, 39.8296], [-123.83172, 39.82996], [-123.83053, 39.83054], [-123.82851, 39.8297], [-123.8269, 39.82887], [-123.82652, 39.82819], [-123.82603, 39.8281], [-123.82494, 39.82707], [-123.82412, 39.82717], [-123.82356, 39.82668], [-123.82286, 39.82556], [-123.82225, 39.82506], [-123.8219, 39.82385], [-123.82061, 39.82348], [-123.81982, 39.82279], [-123.81968, 39.82278], [-123.8189, 39.82265], [-123.81814, 39.82257], [-123.81738, 39.8221], [-123.81669, 39.8222], [-123.81582, 39.82008], [-123.81601, 39.81927], [-123.81574, 39.81862], [-123.81664, 39.81784], [-123.81724, 39.81709], [-123.81572, 39.81621], [-123.82022, 39.81587], [-123.83988, 39.81637], [-123.84643, 39.81657], [-123.84664, 39.81772], [-123.8469, 39.81806], [-123.84715, 39.81865], [-123.84717, 39.81884], [-123.84711, 39.81894], [-123.84703, 39.81899], [-123.84689, 39.81899], [-123.84684, 39.81901], [-123.8468, 39.81914], [-123.84683, 39.81937], [-123.84695, 39.81981], [-123.84712, 39.82005], [-123.84721, 39.82012], [-123.84758, 39.82025], [-123.84788, 39.82024], [-123.84802, 39.82028], [-123.84808, 39.82035], [-123.84808, 39.82061], [-123.84814, 39.82079], [-123.84813, 39.8209], [-123.84824, 39.82138], [-123.84823, 39.82153], [-123.84816, 39.82163], [-123.84808, 39.8217], [-123.84799, 39.82187], [-123.84799, 39.82206], [-123.8481, 39.82323], [-123.84828, 39.82379], [-123.84852, 39.82438], [-123.84882, 39.82518], [-123.84895, 39.82547], [-123.84919, 39.82612], [-123.84921, 39.82628], [-123.84945, 39.82705], [-123.84953, 39.82724], [-123.84967, 39.82793], [-123.84981, 39.82833], [-123.84998, 39.82879]]]} Open Access 1 44294 Shady Dell 12383 3074 Save the Redwoods League 52 Non Profit 6 Non Profit - Land Trust 10 http://www.savetheredwoods.org Non Governmental Organization 10 3074 Save the Redwoods League 50 Non Profit 6 Non Profit - Land Trust 10   Mendocino 24 927.538 Shady Dell 0 Private Conservation 16 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]);