units_with_maps

Table actions

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

4 rows where ACCESS_TYP = 4, AGNCY_NAME = 52 and DES_TP = 16

This data as json, copyable, CSV (advanced)

Suggested facets: COUNTY, YR_EST

MNG_AG_TYP 1

MNG_AGENCY 1

DES_TP 1

  • Private Conservation · 4 ✖

ACCESS_TYP 1

  • Unknown Access · 4 ✖
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
120 120 119 {"type": "Polygon", "coordinates": [[[-123.78052, 39.29709], [-123.78043, 39.29964], [-123.77587, 39.29973], [-123.77122, 39.29977], [-123.77099, 39.29555], [-123.77061, 39.29557], [-123.77054, 39.29471], [-123.7708, 39.29489], [-123.77101, 39.29492], [-123.77111, 39.29503], [-123.77132, 39.29511], [-123.77154, 39.29529], [-123.77225, 39.29551], [-123.77299, 39.29488], [-123.77329, 39.29439], [-123.77335, 39.29402], [-123.77311, 39.29345], [-123.77325, 39.29328], [-123.77364, 39.29341], [-123.77396, 39.29356], [-123.77417, 39.29367], [-123.77432, 39.2938], [-123.77443, 39.29393], [-123.7745, 39.29409], [-123.77451, 39.29457], [-123.7746, 39.29494], [-123.77467, 39.29504], [-123.775, 39.29528], [-123.77583, 39.29574], [-123.77585, 39.29616], [-123.7769, 39.29616], [-123.77711, 39.2962], [-123.77803, 39.29633], [-123.77875, 39.29629], [-123.77892, 39.29631], [-123.77935, 39.29648], [-123.78002, 39.29686], [-123.7802, 39.297], [-123.78052, 39.29709]]]} Unknown Access 4 46785 Big River-Mendocino Old-Growth Redwoods 30239 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 92.451 Big River-Mendocino Old-Growth Redwoods 0 Private Conservation 16 2
5893 5893 5892 {"type": "Polygon", "coordinates": [[[-124.0476, 41.30161], [-124.04702, 41.30206], [-124.04612, 41.30252], [-124.04528, 41.30274], [-124.04622, 41.30429], [-124.04651, 41.30425], [-124.04688, 41.30455], [-124.04662, 41.30539], [-124.04623, 41.30514], [-124.04619, 41.30507], [-124.0461, 41.30505], [-124.04612, 41.30606], [-124.04595, 41.30602], [-124.04503, 41.30596], [-124.04517, 41.30612], [-124.04525, 41.31016], [-124.04507, 41.3112], [-124.04396, 41.3131], [-124.04226, 41.31424], [-124.0411, 41.31599], [-124.04101, 41.31625], [-124.04008, 41.31624], [-124.03943, 41.31654], [-124.03957, 41.31625], [-124.03992, 41.3159], [-124.04058, 41.31577], [-124.04093, 41.31553], [-124.0415, 41.31441], [-124.0425, 41.31351], [-124.04384, 41.31249], [-124.04423, 41.31194], [-124.0446, 41.31063], [-124.04452, 41.3099], [-124.04374, 41.30915], [-124.04234, 41.30856], [-124.04208, 41.30829], [-124.04181, 41.30791], [-124.04152, 41.30769], [-124.03988, 41.30602], [-124.03979, 41.30554], [-124.03971, 41.30484], [-124.03954, 41.30281], [-124.03953, 41.30198], [-124.03979, 41.30125], [-124.04042, 41.30076], [-124.04103, 41.30043], [-124.04173, 41.30022], [-124.04304, 41.30023], [-124.04305, 41.30015], [-124.044, 41.30014], [-124.04458, 41.30009], [-124.04586, 41.3005], [-124.0476, 41.30161]]]} Unknown Access 4 46786 Orick Mill Site 30240 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   Humboldt 45 125.427 Orick Mill Site 0 Private Conservation 16 2
5894 5894 5893 {"type": "Polygon", "coordinates": [[[-124.04065, 41.3174], [-124.03951, 41.32033], [-124.03923, 41.32036], [-124.03889, 41.32062], [-124.03874, 41.32109], [-124.03872, 41.32125], [-124.03832, 41.32127], [-124.03852, 41.32073], [-124.03931, 41.31984], [-124.03934, 41.31945], [-124.03918, 41.31876], [-124.03895, 41.31814], [-124.03895, 41.31789], [-124.03916, 41.31755], [-124.04065, 41.3174]]]} Unknown Access 4 46787 Berry Glen Trail Connection 30241 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   Humboldt 45 6.789 Berry Glen Trail Connection 0 Private Conservation 16 2
10600 10600 10599 {"type": "Polygon", "coordinates": [[[-123.31159, 38.63197], [-123.31112, 38.63968], [-123.2963, 38.63978], [-123.29666, 38.63575], [-123.28701, 38.6359], [-123.28723, 38.63198], [-123.28725, 38.62452], [-123.30782, 38.62432], [-123.30767, 38.63183], [-123.31159, 38.63197]]]} Unknown Access 4 48628 Harold Richardson Redwood Reserve 33334 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/ Sonoma 16 732.202 Harold Richardson Redwood Reserve 2018 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]);