units_with_maps

Table actions

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

1 row where DES_TP = 8, GAP_STS = 2 and MNG_AG_TYP = 10

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Non Profit - Land Trust · 1 ✖

MNG_AGENCY 1

DES_TP 1

  • State Conservation Area · 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
11209 11209 11208 {"type": "MultiPolygon", "coordinates": [[[[-122.12348, 40.17101], [-122.10649, 40.17085], [-122.08771, 40.17078], [-122.07364, 40.17066], [-122.06924, 40.16662], [-122.0518, 40.15108], [-122.05107, 40.15026], [-122.05077, 40.15003], [-122.05066, 40.14987], [-122.05036, 40.14957], [-122.04226, 40.14263], [-122.03385, 40.14261], [-122.01491, 40.14243], [-122.01424, 40.15688], [-121.99527, 40.15697], [-121.99525, 40.15697], [-121.99568, 40.14267], [-121.9503, 40.14391], [-121.93706, 40.14345], [-121.9309, 40.14319], [-121.86075, 40.14298], [-121.86107, 40.1284], [-121.86114, 40.12481], [-121.86586, 40.12484], [-121.86594, 40.12125], [-121.87068, 40.12127], [-121.87078, 40.11768], [-121.87554, 40.11768], [-121.87565, 40.11409], [-121.87245, 40.11408], [-121.87246, 40.11406], [-121.8725, 40.11267], [-121.87307, 40.11149], [-121.87339, 40.11048], [-121.88056, 40.11046], [-121.88522, 40.11047], [-121.88535, 40.10687], [-121.89003, 40.10686], [-121.89015, 40.10325], [-121.89952, 40.10325], [-121.89965, 40.09963], [-121.90434, 40.09963], [-121.90447, 40.09602], [-121.91853, 40.09602], [-121.91867, 40.0924], [-121.9286, 40.09225], [-121.92873, 40.08874], [-121.93898, 40.08853], [-121.94827, 40.08837], [-121.94807, 40.08484], [-121.94817, 40.08139], [-121.95763, 40.08126], [-121.96236, 40.08116], [-121.96256, 40.07767], [-121.96743, 40.07768], [-121.96749, 40.07412], [-121.97778, 40.07406], [-121.9778, 40.07032], [-121.98617, 40.07021], [-121.98626, 40.06655], [-121.9909, 40.06654], [-121.99086, 40.05929], [-122.01503, 40.05905], [-122.01493, 40.05535], [-122.03035, 40.05533], [-122.03036, 40.05532], [-122.03035, 40.05488], [-122.03135, 40.05496], [-122.03254, 40.055], [-122.03321, 40.05506], [-122.03343, 40.05505], [-122.03412, 40.05516], [-122.03456, 40.05527], [-122.03849, 40.05522], [-122.03855, 40.05894], [-122.05253, 40.05871], [-122.05258, 40.0624], [-122.07144, 40.06219], [-122.07142, 40.06352], [-122.07143, 40.06353], [-122.0872, 40.06346], [-122.08715, 40.06719], [-122.08721, 40.07257], [-122.08715, 40.07645], [-122.08709, 40.08904], [-122.08842, 40.08904], [-122.08944, 40.08909], [-122.09028, 40.08909], [-122.08715, 40.09122], [-122.0872, 40.09864], [-122.07605, 40.09863], [-122.07597, 40.09876], [-122.07598, 40.09877], [-122.07851, 40.09877], [-122.08041, 40.10105], [-122.08045, 40.10164], [-122.08072, 40.10327], [-122.081, 40.10432], [-122.08126, 40.10515], [-122.08134, 40.10608], [-122.08087, 40.10685], [-122.08057, 40.1076], [-122.08053, 40.10799], [-122.08108, 40.10981], [-122.08071, 40.1101], [-122.08046, 40.11077], [-122.08036, 40.11196], [-122.08058, 40.11326], [-122.06826, 40.11322], [-122.06291, 40.10752], [-122.06261, 40.10768], [-122.06769, 40.11283], [-122.09369, 40.14002], [-122.08995, 40.1421], [-122.08994, 40.14212], [-122.09072, 40.14286], [-122.0929, 40.14504], [-122.10678, 40.15947], [-122.11045, 40.15741], [-122.12348, 40.17101]]], [[[-122.13427, 40.16059], [-122.13335, 40.16119], [-122.12524, 40.16506], [-122.12055, 40.16769], [-122.10943, 40.15604], [-122.11687, 40.15178], [-122.1132, 40.14796], [-122.12017, 40.1479], [-122.12066, 40.14926], [-122.12061, 40.14922], [-122.12072, 40.14958], [-122.12095, 40.15023], [-122.12157, 40.15063], [-122.12248, 40.15109], [-122.12324, 40.15114], [-122.12415, 40.15059], [-122.12535, 40.1509], [-122.12654, 40.15098], [-122.1274, 40.15145], [-122.12754, 40.15169], [-122.12897, 40.1534], [-122.12907, 40.15355], [-122.12913, 40.15378], [-122.12913, 40.15407], [-122.12917, 40.15424], [-122.12927, 40.15448], [-122.12936, 40.15464], [-122.1295, 40.1548], [-122.12959, 40.15497], [-122.12964, 40.15516], [-122.12967, 40.15538], [-122.12964, 40.15557], [-122.12958, 40.15567], [-122.12943, 40.15614], [-122.12936, 40.15652], [-122.12933, 40.15683], [-122.12936, 40.15713], [-122.12944, 40.15743], [-122.12955, 40.15767], [-122.12971, 40.15793], [-122.12992, 40.15816], [-122.13013, 40.15832], [-122.13029, 40.15842], [-122.13054, 40.15851], [-122.13068, 40.15852], [-122.13088, 40.15851], [-122.1313, 40.15838], [-122.13155, 40.15833], [-122.13176, 40.15832], [-122.13288, 40.15959], [-122.13427, 40.16059]]]]} Restricted Access 2 21518 Gray Davis Dye Creek Preserve 19452 299 Other State 131 State 5 State Agency 5   Other State 5 3091 The Nature Conservancy 61 Non Profit 6 Non Profit - Land Trust 10   Tehama 18 37918.76 Gray Davis Dye Creek Preserve 0 State Conservation Area 8 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]);