units_with_maps

Table actions

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

1 row where COUNTY = 4, MNG_AGENCY = 1120 and MNG_AG_TYP = 10

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Non Profit - Land Trust · 1 ✖

MNG_AGENCY 1

  • Volcan Mountain Preserve Foundation · 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
16917 16917 16916 {"type": "MultiPolygon", "coordinates": [[[[-116.59408, 33.15137], [-116.5897, 33.15166], [-116.58967, 33.1474], [-116.5906, 33.14589], [-116.59217, 33.14588], [-116.59219, 33.14793], [-116.59401, 33.14784], [-116.59407, 33.15133], [-116.59408, 33.15137]]], [[[-116.60729, 33.13867], [-116.60595, 33.14048], [-116.60542, 33.14383], [-116.60515, 33.14379], [-116.60489, 33.14372], [-116.60467, 33.14363], [-116.60434, 33.14346], [-116.60408, 33.14337], [-116.60384, 33.14332], [-116.60345, 33.14327], [-116.60035, 33.14481], [-116.59837, 33.14496], [-116.59831, 33.14088], [-116.59792, 33.14069], [-116.59776, 33.14065], [-116.59759, 33.14064], [-116.59734, 33.14068], [-116.59708, 33.14078], [-116.59669, 33.1409], [-116.59628, 33.14097], [-116.59573, 33.14101], [-116.59525, 33.14098], [-116.59498, 33.14091], [-116.59491, 33.1408], [-116.5949, 33.14068], [-116.59486, 33.14058], [-116.59479, 33.1405], [-116.59469, 33.14043], [-116.59454, 33.14037], [-116.59404, 33.14029], [-116.59385, 33.1403], [-116.59366, 33.14037], [-116.59355, 33.14044], [-116.59325, 33.1407], [-116.59334, 33.14043], [-116.59342, 33.14027], [-116.59353, 33.14013], [-116.59361, 33.14016], [-116.59395, 33.13963], [-116.59383, 33.13914], [-116.59385, 33.1356], [-116.59825, 33.13536], [-116.59829, 33.13385], [-116.59827, 33.12787], [-116.6003, 33.12794], [-116.60103, 33.12798], [-116.60142, 33.12798], [-116.60155, 33.13262], [-116.60124, 33.1326], [-116.60134, 33.13326], [-116.60152, 33.13326], [-116.60171, 33.13324], [-116.60217, 33.13306], [-116.60256, 33.13297], [-116.6029, 33.13297], [-116.60297, 33.13299], [-116.60304, 33.13305], [-116.60311, 33.1332], [-116.60309, 33.13325], [-116.60306, 33.1333], [-116.60296, 33.13335], [-116.60279, 33.13339], [-116.60263, 33.13346], [-116.60252, 33.13353], [-116.60246, 33.13361], [-116.60244, 33.13368], [-116.60245, 33.13418], [-116.60241, 33.1344], [-116.60344, 33.13434], [-116.60353, 33.1343], [-116.60358, 33.13427], [-116.60367, 33.13401], [-116.60423, 33.13395], [-116.60462, 33.13382], [-116.60492, 33.13354], [-116.60483, 33.13294], [-116.60704, 33.13315], [-116.60729, 33.13867]]]]} Open Access 1 46819 Volcan Mountain Wilderness Preserve 30284 3333 Volcan Mountain Preserve Foundation 1182 Non Profit 6 Non Profit - Land Trust 10 http://www.volcanmt.org/acquisition-projects-accomplishments Non Governmental Organization 10 3333 Volcan Mountain Preserve Foundation 1120 Non Profit 6 Non Profit - Land Trust 10 http://www.volcanmt.org San Diego 4 381.895 Volcan Mtn. Wilderness 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]);