units_with_maps

Table actions

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

1 row where LABEL_NAME = "Wilmont Preserve" and MNG_AG_TYP = 10

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Non Profit - Land Trust · 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
7977 7977 7976 {"type": "MultiPolygon", "coordinates": [[[[-117.2969, 33.27804], [-117.29646, 33.2786], [-117.29624, 33.27872], [-117.29594, 33.2788], [-117.29568, 33.27881], [-117.29449, 33.27868], [-117.29422, 33.2787], [-117.29408, 33.27873], [-117.29393, 33.27878], [-117.29303, 33.27854], [-117.29267, 33.27852], [-117.29234, 33.27861], [-117.29184, 33.27881], [-117.29146, 33.27904], [-117.2912, 33.27923], [-117.29094, 33.27957], [-117.29084, 33.27975], [-117.29072, 33.27991], [-117.29056, 33.28004], [-117.29037, 33.28016], [-117.28988, 33.28057], [-117.28949, 33.28103], [-117.28855, 33.28165], [-117.28833, 33.28194], [-117.28822, 33.2822], [-117.28816, 33.28223], [-117.28809, 33.28225], [-117.28761, 33.28224], [-117.28756, 33.28226], [-117.28748, 33.28233], [-117.2873, 33.28264], [-117.28702, 33.28261], [-117.2864, 33.28272], [-117.28622, 33.28272], [-117.28603, 33.2827], [-117.28685, 33.28185], [-117.28685, 33.28148], [-117.28793, 33.28148], [-117.28794, 33.28004], [-117.28834, 33.28021], [-117.2885, 33.28009], [-117.28852, 33.27965], [-117.28895, 33.27946], [-117.28922, 33.27931], [-117.28955, 33.27906], [-117.29028, 33.27873], [-117.2906, 33.27852], [-117.29074, 33.2783], [-117.2906, 33.27805], [-117.28989, 33.2781], [-117.2897, 33.27818], [-117.28946, 33.27822], [-117.28869, 33.27818], [-117.28849, 33.27825], [-117.28835, 33.27843], [-117.28795, 33.27842], [-117.28796, 33.27782], [-117.29663, 33.27789], [-117.2969, 33.27804]]], [[[-117.29783, 33.27845], [-117.29668, 33.27933], [-117.29645, 33.27916], [-117.29631, 33.27911], [-117.29625, 33.27904], [-117.29624, 33.279], [-117.29646, 33.27892], [-117.29673, 33.27875], [-117.29714, 33.2784], [-117.29719, 33.27839], [-117.29723, 33.27848], [-117.29731, 33.27855], [-117.29742, 33.27858], [-117.29749, 33.27857], [-117.29755, 33.27854], [-117.29762, 33.27848], [-117.29772, 33.27825], [-117.29783, 33.27845]]]]} No Public Access 3 10865 Wilmont Preserve 27601 3014 Center for Natural Lands Management 91 Non Profit 6 Non Profit - Land Trust 10 http://cnlm.org/ Non Governmental Organization 10 3014 Center for Natural Lands Management 89 Non Profit 6 Non Profit - Land Trust 10   San Diego 4 34.489 Wilmont 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]);