units_with_maps

Table actions

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

1 row where DES_TP = 4, MNG_AGENCY = 101 and UNIT_NAME = "Volcan Mountain Wilderness Preserve"

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • San Diego, County of · 1 ✖

DES_TP 1

  • Local 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
16904 16904 16903 {"type": "Polygon", "coordinates": [[[-116.60256, 33.11614], [-116.60251, 33.11629], [-116.6025, 33.11642], [-116.60251, 33.11657], [-116.60257, 33.11685], [-116.60258, 33.117], [-116.60257, 33.11722], [-116.60255, 33.11743], [-116.60256, 33.11766], [-116.6026, 33.11791], [-116.60279, 33.1185], [-116.60283, 33.11883], [-116.60281, 33.11911], [-116.60275, 33.11936], [-116.60235, 33.12066], [-116.60203, 33.12176], [-116.60181, 33.12225], [-116.60156, 33.12264], [-116.60149, 33.12276], [-116.60141, 33.12304], [-116.60137, 33.12331], [-116.59729, 33.12338], [-116.59745, 33.12582], [-116.59836, 33.12606], [-116.59831, 33.12672], [-116.5984, 33.12723], [-116.59856, 33.12787], [-116.59827, 33.12788], [-116.59829, 33.13385], [-116.59825, 33.13386], [-116.59825, 33.13536], [-116.58954, 33.13585], [-116.58956, 33.13743], [-116.58955, 33.1398], [-116.58984, 33.13987], [-116.59018, 33.1399], [-116.59043, 33.13989], [-116.59079, 33.13982], [-116.59097, 33.1399], [-116.59121, 33.14015], [-116.59132, 33.14024], [-116.59159, 33.14032], [-116.59206, 33.14036], [-116.59243, 33.14035], [-116.59276, 33.14024], [-116.59288, 33.14015], [-116.59301, 33.14001], [-116.59345, 33.1396], [-116.59359, 33.1396], [-116.5936, 33.13971], [-116.59354, 33.14001], [-116.59345, 33.14023], [-116.59334, 33.14043], [-116.59327, 33.14068], [-116.59366, 33.14037], [-116.59393, 33.14029], [-116.59414, 33.1403], [-116.59458, 33.14038], [-116.59477, 33.14049], [-116.59483, 33.14054], [-116.5949, 33.14068], [-116.59491, 33.1408], [-116.59498, 33.14091], [-116.59525, 33.14098], [-116.59573, 33.141], [-116.59628, 33.14097], [-116.59669, 33.1409], [-116.59708, 33.14078], [-116.59736, 33.14068], [-116.59629, 33.14299], [-116.59195, 33.14333], [-116.58527, 33.14393], [-116.58532, 33.14793], [-116.58097, 33.14827], [-116.58088, 33.14433], [-116.58525, 33.14393], [-116.58518, 33.14049], [-116.58576, 33.14155], [-116.58742, 33.1409], [-116.58577, 33.13801], [-116.58564, 33.13639], [-116.58331, 33.13704], [-116.58474, 33.13967], [-116.58504, 33.13966], [-116.58504, 33.14001], [-116.58079, 33.14029], [-116.5807, 33.13633], [-116.58033, 33.12927], [-116.58004, 33.12054], [-116.56782, 33.12137], [-116.56788, 33.12522], [-116.55932, 33.12575], [-116.55915, 33.12187], [-116.55967, 33.12183], [-116.55962, 33.1184], [-116.56364, 33.11824], [-116.56349, 33.10731], [-116.56766, 33.10716], [-116.56736, 33.09696], [-116.57145, 33.09689], [-116.57146, 33.09366], [-116.57968, 33.09373], [-116.58547, 33.09423], [-116.5858, 33.09441], [-116.58605, 33.09451], [-116.58624, 33.09454], [-116.58652, 33.09455], [-116.58676, 33.09458], [-116.58702, 33.09465], [-116.58731, 33.09478], [-116.58752, 33.09499], [-116.58772, 33.09551], [-116.58782, 33.09571], [-116.58796, 33.09586], [-116.58811, 33.09594], [-116.5883, 33.09599], [-116.58849, 33.096], [-116.589, 33.09591], [-116.58913, 33.10051], [-116.59584, 33.10112], [-116.59835, 33.10378], [-116.59974, 33.10508], [-116.59986, 33.10509], [-116.59991, 33.10863], [-116.60027, 33.10864], [-116.60031, 33.11052], [-116.59823, 33.11055], [-116.59823, 33.10864], [-116.58933, 33.10776], [-116.58917, 33.11307], [-116.59824, 33.11415], [-116.59825, 33.115], [-116.60256, 33.11614]], [[-116.57991, 33.09966], [-116.58453, 33.10009], [-116.58442, 33.09705], [-116.5798, 33.09663], [-116.57991, 33.09966]]]} Open Access 1 10653 Volcan Mountain Wilderness Preserve 29261 319 San Diego, County of 104 County 3 County Agency 3 http://www.sandiegocounty.gov/parks/ County 3 319 San Diego, County of 101 County 3 County Agency 3 http://www.sdparks.org/content/sdparks/en/park-pages/VolcanMountain.html San Diego 4 3013.276 Volcan Mtn. Wilderness Preserve 0 Local Conservation Area 4 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]);