units_with_maps

Table actions

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

2 rows where COUNTY = 10 and MNG_AG_TYP = 12

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Non Profit - Conservation · 2 ✖

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
4806 4806 4805 {"type": "MultiPolygon", "coordinates": [[[[-116.57588, 33.86683], [-116.57583, 33.86863], [-116.57481, 33.86799], [-116.57389, 33.86748], [-116.57281, 33.86696], [-116.56836, 33.86466], [-116.5693, 33.86342], [-116.57588, 33.86683]]], [[[-116.58857, 33.87432], [-116.58641, 33.8765], [-116.5835, 33.8743], [-116.57999, 33.8743], [-116.58009, 33.87175], [-116.57794, 33.87017], [-116.57805, 33.867], [-116.58853, 33.86709], [-116.5885, 33.86893], [-116.58848, 33.87431], [-116.58857, 33.87432]], [[-116.58424, 33.87431], [-116.58425, 33.8743], [-116.5842, 33.87071], [-116.58126, 33.87068], [-116.58129, 33.86975], [-116.58018, 33.86974], [-116.58011, 33.87138], [-116.58399, 33.8743], [-116.58424, 33.87431]]], [[[-116.59703, 33.84893], [-116.59628, 33.84774], [-116.59315, 33.84624], [-116.59266, 33.84624], [-116.59266, 33.84775], [-116.59182, 33.85041], [-116.59013, 33.8521], [-116.58881, 33.8521], [-116.58694, 33.85056], [-116.58252, 33.85498], [-116.58043, 33.85497], [-116.58041, 33.85259], [-116.5842, 33.84764], [-116.58807, 33.84439], [-116.58805, 33.84438], [-116.58749, 33.84448], [-116.58576, 33.84492], [-116.58525, 33.84492], [-116.58542, 33.84468], [-116.58523, 33.84457], [-116.59005, 33.8418], [-116.59181, 33.84035], [-116.59466, 33.83871], [-116.59548, 33.83871], [-116.597, 33.84], [-116.59703, 33.84893]]]]} Open Access 1 48582 Unnamed site - Friends of Palm Springs Mountains 33292 3378 Friends of Palm Springs Mountains 787 Non Profit 6 Non Profit - Conservation 12 http://friendsofpalmspringsmountains.org/ Non Governmental Organization 10 3378 Friends of Palm Springs Mountains 766 Non Profit 6 Non Profit - Conservation 12 http://friendsofpalmspringsmountains.org Riverside 10 501.078   0 Private Other or Unknown 399 4
6912 6912 6911 {"type": "Polygon", "coordinates": [[[-116.46015, 33.62703], [-116.46015, 33.6416], [-116.44281, 33.6416], [-116.4428, 33.62706], [-116.46015, 33.62703]]]} Open Access 1 5786 Santa Rosa and San Jacinto Mountains National Monument 13072 3090 The Living Desert 845 Non Profit 6 Non Profit - Conservation 12 http://www.livingdesert.org/ Non Governmental Organization 10 3090 The Living Desert 823 Non Profit 6 Non Profit - Conservation 12   Riverside 10 641.789 Santa Rosa and San Jacinto Mtns. NM 2000 National Monument or Landmark 80 3

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]);