units_with_maps

Table actions

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

2 rows where COUNTY = 10, MNG_AGENCY = 657 and MNG_AG_TYP = 10

This data as json, copyable, CSV (advanced)

ACCESS_TYP 2

MNG_AG_TYP 1

  • Non Profit - Land Trust · 2 ✖

MNG_AGENCY 1

  • Mojave Desert Land Trust · 2 ✖
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
4831 4831 4830 {"type": "MultiPolygon", "coordinates": [[[[-116.06156, 33.79473], [-116.05721, 33.79473], [-116.05721, 33.79292], [-116.06156, 33.79291], [-116.06156, 33.79473]]], [[[-116.07024, 33.79109], [-116.0659, 33.7911], [-116.0659, 33.78747], [-116.07024, 33.78747], [-116.07024, 33.79109]]]]} No Public Access 3 49076 Unnamed site - Mojave Desert Land Trust 33770 3124 Mojave Desert Land Trust 669 Non Profit 6 Non Profit - Land Trust 10 http://www.mojavedesertlandtrust.org/ Non Governmental Organization 10 3124 Mojave Desert Land Trust 657 Non Profit 6 Non Profit - Land Trust 10 https://www.mdlt.org/ Riverside 10 59.967   0 Private Other or Unknown 399 4
15536 15536 15535 {"type": "MultiPolygon", "coordinates": [[[[-114.77302, 33.90916], [-114.77301, 33.91008], [-114.77085, 33.91008], [-114.77086, 33.90916], [-114.77302, 33.90916]]], [[[-115.15274, 33.61312], [-115.15165, 33.61311], [-115.15164, 33.61224], [-115.15274, 33.61224], [-115.15274, 33.61312]]], [[[-115.20131, 33.99267], [-115.19693, 33.99264], [-115.1969, 33.9899], [-115.20129, 33.98991], [-115.20131, 33.99267]]], [[[-115.30171, 33.90962], [-115.30171, 33.91299], [-115.30166, 33.91303], [-115.29755, 33.91304], [-115.2975, 33.913], [-115.2975, 33.90963], [-115.29755, 33.90959], [-115.30166, 33.90958], [-115.30171, 33.90962]]], [[[-115.35687, 33.60349], [-115.35447, 33.60741], [-115.35254, 33.60648], [-115.35493, 33.60258], [-115.35687, 33.60349]]], [[[-115.68288, 33.86961], [-115.68288, 33.87052], [-115.68176, 33.87052], [-115.68176, 33.8696], [-115.68288, 33.86961]]], [[[-115.70995, 33.84741], [-115.70995, 33.84923], [-115.70777, 33.84923], [-115.70778, 33.84742], [-115.70995, 33.84741]]], [[[-115.73557, 33.88834], [-115.73555, 33.88924], [-115.73447, 33.88923], [-115.73448, 33.88833], [-115.73557, 33.88834]]], [[[-115.74261, 33.84734], [-115.74261, 33.84915], [-115.73825, 33.84916], [-115.73826, 33.84735], [-115.74261, 33.84734]]], [[[-115.74432, 33.91186], [-115.7443, 33.91366], [-115.74198, 33.91365], [-115.742, 33.91185], [-115.73969, 33.91183], [-115.73976, 33.90642], [-115.74206, 33.90643], [-115.74201, 33.91184], [-115.74432, 33.91186]]], [[[-115.75567, 33.84414], [-115.75567, 33.84459], [-115.7535, 33.8446], [-115.7535, 33.84415], [-115.75567, 33.84414]]], [[[-115.76073, 33.68225], [-115.76071, 33.68588], [-115.75854, 33.68587], [-115.75855, 33.68224], [-115.76073, 33.68225]]], [[[-115.77812, 33.90403], [-115.77382, 33.90396], [-115.77381, 33.90305], [-115.77812, 33.90313], [-115.77812, 33.90403]]], [[[-115.78899, 33.91321], [-115.78683, 33.91317], [-115.78683, 33.91227], [-115.78899, 33.91231], [-115.78899, 33.91321]]], [[[-115.79544, 33.89806], [-115.79111, 33.89802], [-115.7911, 33.89711], [-115.79543, 33.89715], [-115.79544, 33.89806]]], [[[-115.80189, 33.89538], [-115.79973, 33.89536], [-115.79972, 33.89445], [-115.80188, 33.89447], [-115.80189, 33.89538]]], [[[-115.82997, 33.89854], [-115.82997, 33.89946], [-115.82783, 33.89943], [-115.82783, 33.89851], [-115.82997, 33.89854]]], [[[-115.83653, 33.89957], [-115.83439, 33.89954], [-115.83437, 33.89862], [-115.83651, 33.89865], [-115.83653, 33.89957]]], [[[-115.95303, 33.81649], [-115.94433, 33.81652], [-115.94433, 33.81289], [-115.94867, 33.81287], [-115.94867, 33.80925], [-115.95303, 33.80924], [-115.95303, 33.81649]]], [[[-115.96169, 33.79474], [-115.95735, 33.79474], [-115.95734, 33.78749], [-115.96168, 33.78749], [-115.96169, 33.79474]]], [[[-115.98768, 33.80562], [-115.98767, 33.80914], [-115.98341, 33.80918], [-115.98341, 33.80562], [-115.98768, 33.80562]]], [[[-116.00077, 33.79477], [-116.00077, 33.79835], [-115.99643, 33.79835], [-115.99643, 33.79472], [-116.00077, 33.79477]]], [[[-116.00411, 33.75851], [-116.00409, 33.76562], [-115.99964, 33.76563], [-115.99966, 33.75853], [-116.00411, 33.75851]]], [[[-116.01726, 33.75117], [-116.0086, 33.7512], [-116.0086, 33.74398], [-116.0172, 33.744], [-116.01726, 33.75117]]], [[[-116.03677, 33.73666], [-116.03466, 33.73666], [-116.03466, 33.73422], [-116.03466, 33.73422], [-116.03677, 33.73666]]], [[[-116.08326, 33.802], [-116.08326, 33.80924], [-116.07459, 33.80921], [-116.07459, 33.80201], [-116.08326, 33.802]]], [[[-116.10468, 33.80203], [-116.09194, 33.802], [-116.09194, 33.7916], [-116.09194, 33.7916], [-116.10468, 33.80203]]], [[[-116.10828, 33.85427], [-116.10827, 33.85445], [-116.10772, 33.85445], [-116.10772, 33.85427], [-116.10828, 33.85427]]], [[[-116.12335, 33.81658], [-116.10939, 33.81656], [-116.1094, 33.80532], [-116.1094, 33.80532], [-116.12335, 33.81658]]], [[[-116.11696, 33.84468], [-116.11641, 33.84468], [-116.11641, 33.8445], [-116.11696, 33.8445], [-116.11696, 33.84468]]], [[[-116.11751, 33.83778], [-116.11696, 33.83778], [-116.11696, 33.8376], [-116.11751, 33.8376], [-116.11751, 33.83778]]], [[[-116.12238, 33.83906], [-116.12238, 33.83924], [-116.12184, 33.83924], [-116.12184, 33.83906], [-116.12238, 33.83906]]], [[[-116.13213, 33.85573], [-116.13213, 33.85591], [-116.13159, 33.85591], [-116.13159, 33.85573], [-116.13213, 33.85573]]], [[[-116.1474, 33.83113], [-116.14739, 33.83148], [-116.14686, 33.83148], [-116.14684, 33.8324], [-116.14631, 33.8324], [-116.1463, 33.83329], [-116.14577, 33.8333], [-116.14576, 33.83345], [-116.14522, 33.83345], [-116.14521, 33.83312], [-116.14468, 33.83312], [-116.14468, 33.83256], [-116.14413, 33.83255], [-116.14413, 33.83112], [-116.1474, 33.83113]]], [[[-116.1616, 33.84166], [-116.16105, 33.84165], [-116.16105, 33.84149], [-116.16052, 33.84148], [-116.16051, 33.84113], [-116.15997, 33.84113], [-116.15995, 33.84095], [-116.15944, 33.84094], [-116.15942, 33.84058], [-116.15887, 33.84058], [-116.15886, 33.84039], [-116.15834, 33.84039], [-116.15833, 33.84003], [-116.15778, 33.84002], [-116.15777, 33.83984], [-116.15723, 33.83984], [-116.15722, 33.8395], [-116.15668, 33.83949], [-116.15667, 33.8393], [-116.15615, 33.83929], [-116.15615, 33.83894], [-116.15561, 33.83894], [-116.1556, 33.83875], [-116.15506, 33.83875], [-116.15504, 33.83838], [-116.15448, 33.83838], [-116.15446, 33.8382], [-116.15394, 33.8382], [-116.15394, 33.83785], [-116.1534, 33.83785], [-116.15339, 33.83767], [-116.15288, 33.83766], [-116.15287, 33.83732], [-116.15234, 33.83731], [-116.15233, 33.83693], [-116.15181, 33.83693], [-116.1518, 33.83673], [-116.15122, 33.83673], [-116.15122, 33.83638], [-116.15069, 33.83637], [-116.15068, 33.83618], [-116.15013, 33.83618], [-116.15012, 33.83583], [-116.14958, 33.83584], [-116.14958, 33.83566], [-116.14901, 33.83566], [-116.14902, 33.83528], [-116.14848, 33.83527], [-116.14847, 33.83511], [-116.14797, 33.83512], [-116.14797, 33.83476], [-116.14742, 33.83475], [-116.14742, 33.83419], [-116.14796, 33.8342], [-116.14796, 33.8333], [-116.14846, 33.8333], [-116.14848, 33.83256], [-116.14902, 33.83254], [-116.14903, 33.83165], [-116.14956, 33.83164], [-116.14958, 33.83114], [-116.1616, 33.83118], [-116.1616, 33.84166]], [[-116.15446, 33.83672], [-116.15446, 33.83655], [-116.15393, 33.83655], [-116.15393, 33.83672], [-116.15446, 33.83672]], [[-116.15556, 33.83548], [-116.15557, 33.83528], [-116.15505, 33.83528], [-116.15505, 33.83548], [-116.15556, 33.83548]], [[-116.15834, 33.8384], [-116.15778, 33.83839], [-116.15778, 33.83857], [-116.15833, 33.83858], [-116.15834, 33.8384]]], [[[-116.16596, 33.85561], [-116.16596, 33.85579], [-116.16542, 33.85579], [-116.16542, 33.85561], [-116.16596, 33.85561]]], [[[-116.16813, 33.84801], [-116.16813, 33.84819], [-116.16757, 33.84819], [-116.16756, 33.84801], [-116.16813, 33.84801]]], [[[-116.17033, 33.84728], [-116.17033, 33.84747], [-116.16977, 33.84747], [-116.16977, 33.84728], [-116.17033, 33.84728]]], [[[-116.17907, 33.85038], [-116.17852, 33.85038], [-116.17851, 33.8502], [-116.17795, 33.8502], [-116.17794, 33.84985], [-116.1774, 33.84985], [-116.17739, 33.84967], [-116.17686, 33.84966], [-116.17686, 33.8493], [-116.17632, 33.8493], [-116.17632, 33.84912], [-116.17577, 33.84912], [-116.17576, 33.84875], [-116.17523, 33.84875], [-116.17522, 33.84857], [-116.17468, 33.84857], [-116.17468, 33.8482], [-116.17413, 33.8482], [-116.17412, 33.84802], [-116.17358, 33.84802], [-116.17357, 33.84764], [-116.17303, 33.84764], [-116.17303, 33.84747], [-116.1725, 33.84747], [-116.1725, 33.84711], [-116.17195, 33.84711], [-116.17194, 33.84693], [-116.1714, 33.84693], [-116.1714, 33.84658], [-116.17088, 33.84658], [-116.17087, 33.8464], [-116.17033, 33.84639], [-116.17033, 33.84603], [-116.16978, 33.84603], [-116.16978, 33.84566], [-116.17906, 33.84568], [-116.17907, 33.85038]]], [[[-116.17688, 33.85292], [-116.17633, 33.85292], [-116.17634, 33.85273], [-116.17687, 33.85274], [-116.17688, 33.85292]]]]} Open Access 1 48499 Mojave Desert Land Trust 6762 3124 Mojave Desert Land Trust 669 Non Profit 6 Non Profit - Land Trust 10 http://www.mojavedesertlandtrust.org/ Non Governmental Organization 10 3124 Mojave Desert Land Trust 657 Non Profit 6 Non Profit - Land Trust 10 https://www.mdlt.org/discover-learn/resources/ Riverside 10 1610.252 Mojave Desert Land Trust 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]);