units_with_maps

Table actions

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

1 row where ACRES = "351.412", DES_TP = 16 and MNG_AGENCY = 61

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • The Nature Conservancy · 1 ✖

DES_TP 1

  • Private Conservation · 1 ✖

ACCESS_TYP 1

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
11245 11245 11244 {"type": "MultiPolygon", "coordinates": [[[[-123.75233, 39.2557], [-123.7474, 39.25537], [-123.74559, 39.25523], [-123.74512, 39.25523], [-123.74352, 39.25515], [-123.74242, 39.25512], [-123.74236, 39.25693], [-123.73761, 39.25684], [-123.73764, 39.25896], [-123.73545, 39.25882], [-123.73542, 39.25762], [-123.73579, 39.25754], [-123.7359, 39.25749], [-123.73598, 39.25739], [-123.73601, 39.25726], [-123.73601, 39.25714], [-123.73604, 39.25697], [-123.73615, 39.25684], [-123.7365, 39.25665], [-123.7366, 39.25654], [-123.73666, 39.25636], [-123.73669, 39.2561], [-123.73667, 39.25599], [-123.73655, 39.25583], [-123.736, 39.25533], [-123.73583, 39.25515], [-123.73577, 39.25496], [-123.73574, 39.25475], [-123.73568, 39.25449], [-123.73561, 39.25426], [-123.73545, 39.25408], [-123.73523, 39.25386], [-123.73496, 39.25355], [-123.73491, 39.25345], [-123.73489, 39.25328], [-123.73492, 39.25319], [-123.73493, 39.25304], [-123.73491, 39.25289], [-123.73482, 39.25272], [-123.73465, 39.25246], [-123.73463, 39.25233], [-123.73458, 39.25216], [-123.73458, 39.25203], [-123.73461, 39.25195], [-123.73467, 39.25186], [-123.7347, 39.25175], [-123.7347, 39.25167], [-123.73458, 39.25149], [-123.73456, 39.25141], [-123.73457, 39.25095], [-123.73448, 39.25072], [-123.73436, 39.25063], [-123.73434, 39.24997], [-123.73429, 39.24974], [-123.73406, 39.24946], [-123.73384, 39.24939], [-123.73313, 39.249], [-123.73313, 39.24787], [-123.73362, 39.2482], [-123.73391, 39.24801], [-123.73424, 39.24788], [-123.73466, 39.24776], [-123.73521, 39.24754], [-123.73598, 39.24719], [-123.73613, 39.24699], [-123.73634, 39.24688], [-123.7366, 39.24704], [-123.73663, 39.2472], [-123.73677, 39.24757], [-123.73735, 39.24783], [-123.73783, 39.24765], [-123.73821, 39.24748], [-123.73862, 39.24756], [-123.73873, 39.24774], [-123.73888, 39.24812], [-123.73915, 39.24827], [-123.7395, 39.24835], [-123.73986, 39.24881], [-123.7403, 39.24918], [-123.74061, 39.2494], [-123.74109, 39.24947], [-123.7413, 39.24938], [-123.74186, 39.24902], [-123.74223, 39.24883], [-123.74267, 39.24885], [-123.74256, 39.24995], [-123.74561, 39.25018], [-123.74732, 39.25029], [-123.7474, 39.24994], [-123.74734, 39.24845], [-123.75201, 39.2487], [-123.75233, 39.2557]]], [[[-123.76129, 39.28146], [-123.76132, 39.28339], [-123.76125, 39.28534], [-123.76127, 39.28787], [-123.75901, 39.28789], [-123.75899, 39.28843], [-123.75766, 39.28799], [-123.75757, 39.28663], [-123.75683, 39.28658], [-123.75674, 39.28532], [-123.75893, 39.28533], [-123.75898, 39.28339], [-123.75897, 39.28142], [-123.76129, 39.28146]]]]} No Public Access 3 21667 Pygmy Forest Preserve 30610 3091 The Nature Conservancy 63 Non Profit 6 Non Profit - Land Trust 10 http://www.nature.org/ Non Governmental Organization 10 3091 The Nature Conservancy 61 Non Profit 6 Non Profit - Land Trust 10   Mendocino 24 351.412 Pygmy Forest Preserve 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]);