units_with_maps

Table actions

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

4 rows where AGNCY_TYP = 10, DES_TP = 16 and MNG_AGENCY = 576

This data as json, copyable, CSV (advanced)

Suggested facets: AGNCY_ID, AGNCY_WEB, YR_EST

ACCESS_TYP 2

MNG_AG_TYP 1

MNG_AGENCY 1

  • Lake County Land Trust · 4 ✖

DES_TP 1

  • Private Conservation · 4 ✖
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
3113 3113 3112 {"type": "Polygon", "coordinates": [[[-122.87912, 39.02968], [-122.87717, 39.0297], [-122.87715, 39.02211], [-122.87898, 39.02212], [-122.87912, 39.02968]]]} Open Access 1 48007 Melo Property 32436 3264 Lake County Land Trust 586 Non Profit 6 Non Profit - Land Trust 10 http://www.lakecountylandtrust.org/index.htm Non Governmental Organization 10 3264 Lake County Land Trust 576 Non Profit 6 Non Profit - Land Trust 10 http://www.lakecountylandtrust.org/melo-property.html Lake 40 34.018 Melo Property 0 Private Conservation 16 2
4139 4139 4138 {"type": "Polygon", "coordinates": [[[-122.90649, 39.12768], [-122.90618, 39.12768], [-122.9046, 39.12644], [-122.90082, 39.12692], [-122.89809, 39.12555], [-122.89808, 39.12413], [-122.89595, 39.12354], [-122.89528, 39.12245], [-122.89444, 39.12212], [-122.8971, 39.11987], [-122.8989, 39.11997], [-122.901, 39.12067], [-122.90099, 39.11847], [-122.89935, 39.11803], [-122.89935, 39.11656], [-122.89985, 39.1164], [-122.90008, 39.11636], [-122.9003, 39.11634], [-122.90053, 39.11634], [-122.90076, 39.11637], [-122.90098, 39.11642], [-122.90127, 39.11653], [-122.90144, 39.11662], [-122.90229, 39.11767], [-122.90276, 39.11893], [-122.90293, 39.11971], [-122.90315, 39.12079], [-122.9033, 39.12131], [-122.90345, 39.12177], [-122.90355, 39.12197], [-122.90368, 39.12217], [-122.90515, 39.12392], [-122.90537, 39.12427], [-122.90551, 39.12458], [-122.90609, 39.12665], [-122.90649, 39.12768]]]} Restricted Access 2 47467 Rodman Preserve 31186 3264 Lake County Land Trust 586 Non Profit 6 Non Profit - Land Trust 10 http://www.lakecountylandtrust.org/index.htm Non Governmental Organization 10 3264 Lake County Land Trust 576 Non Profit 6 Non Profit - Land Trust 10   Lake 40 141.594 Rodman Preserve 0 Private Conservation 16 2
10516 10516 10515 {"type": "MultiPolygon", "coordinates": [[[[-122.62172, 38.74983], [-122.621, 38.7506], [-122.61962, 38.74987], [-122.61923, 38.75071], [-122.61868, 38.75057], [-122.61889, 38.75006], [-122.61877, 38.74937], [-122.61888, 38.74914], [-122.61914, 38.74921], [-122.61928, 38.74891], [-122.61927, 38.7489], [-122.61903, 38.74883], [-122.61921, 38.74847], [-122.62033, 38.74867], [-122.62172, 38.74983]]], [[[-122.62042, 38.75135], [-122.6203, 38.75152], [-122.61968, 38.75136], [-122.61983, 38.75103], [-122.61992, 38.75106], [-122.62042, 38.75135]]]]} Open Access 1 48611 Rabbit Hill 33326 3264 Lake County Land Trust 586 Non Profit 6 Non Profit - Land Trust 10 http://www.lakecountylandtrust.org/index.htm Non Governmental Organization 10 3264 Lake County Land Trust 576 Non Profit 6 Non Profit - Land Trust 10 http://www.lakecountylandtrust.org Lake 40 9.708 Rabbit Hill 1999 Private Conservation 16 2
11200 11200 11199 {"type": "MultiPolygon", "coordinates": [[[[-122.78322, 38.88894], [-122.7821, 38.88893], [-122.7821, 38.88936], [-122.77831, 38.88934], [-122.77825, 38.8897], [-122.77754, 38.88952], [-122.77411, 38.8901], [-122.77186, 38.88911], [-122.77094, 38.88785], [-122.77079, 38.88756], [-122.77, 38.88635], [-122.77001, 38.88564], [-122.7713, 38.88488], [-122.77156, 38.88428], [-122.77195, 38.88359], [-122.77257, 38.88479], [-122.77342, 38.884], [-122.77604, 38.88439], [-122.77794, 38.88353], [-122.77793, 38.88313], [-122.7784, 38.88299], [-122.77851, 38.88299], [-122.77863, 38.88301], [-122.77877, 38.88308], [-122.77914, 38.88341], [-122.78015, 38.88387], [-122.78066, 38.88421], [-122.78111, 38.88456], [-122.78158, 38.88497], [-122.78167, 38.88507], [-122.78173, 38.88519], [-122.78176, 38.88537], [-122.78182, 38.88548], [-122.78193, 38.88555], [-122.78217, 38.88565], [-122.78223, 38.88571], [-122.78274, 38.88682], [-122.78284, 38.88712], [-122.7829, 38.88745], [-122.78307, 38.88781], [-122.78313, 38.88841], [-122.78322, 38.88894]]], [[[-122.77932, 38.8827], [-122.77932, 38.8834], [-122.77917, 38.88331], [-122.7788, 38.88299], [-122.77866, 38.88293], [-122.77854, 38.8829], [-122.77932, 38.8827]]]]} Restricted Access 2 21515 Boggs Lake Preserve 32435 3091 The Nature Conservancy 63 Non Profit 6 Non Profit - Land Trust 10 http://www.nature.org/ Non Governmental Organization 10 3264 Lake County Land Trust 576 Non Profit 6 Non Profit - Land Trust 10 http://www.lakecountylandtrust.org/boggs-lake.html Lake 40 153.099 Boggs Lake 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]);