units_with_maps

Table actions

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

2 rows where DES_TP = 399, MNG_AGENCY = 657 and UNIT_NAME = "Unnamed site - Mojave Desert Land Trust"

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Mojave Desert Land Trust · 2 ✖

DES_TP 1

  • Private Other or Unknown · 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
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
15531 15531 15530 {"type": "MultiPolygon", "coordinates": [[[[-114.68869, 34.96203], [-114.68869, 34.96294], [-114.68648, 34.96293], [-114.68648, 34.96203], [-114.68869, 34.96203]]], [[[-114.69837, 34.57743], [-114.6896, 34.57743], [-114.68921, 34.57359], [-114.69799, 34.57359], [-114.69837, 34.57743]]], [[[-114.69675, 34.58319], [-114.69018, 34.58318], [-114.68979, 34.57934], [-114.69637, 34.57935], [-114.69675, 34.58319]]], [[[-114.74114, 34.56431], [-114.73232, 34.56424], [-114.73171, 34.55673], [-114.74049, 34.55676], [-114.74114, 34.56431]]], [[[-114.77923, 34.5208], [-114.77051, 34.5208], [-114.77051, 34.51356], [-114.77923, 34.51356], [-114.77923, 34.5208]]], [[[-114.78334, 34.59172], [-114.78115, 34.59174], [-114.78105, 34.59079], [-114.77886, 34.59081], [-114.77847, 34.58702], [-114.78067, 34.587], [-114.78105, 34.59079], [-114.78324, 34.59077], [-114.78334, 34.59172]]], [[[-114.78621, 34.59832], [-114.78402, 34.59834], [-114.78383, 34.59645], [-114.78602, 34.59643], [-114.78621, 34.59832]]], [[[-114.78801, 34.59451], [-114.78692, 34.59453], [-114.78682, 34.59358], [-114.78792, 34.59357], [-114.78801, 34.59451]]], [[[-114.78853, 34.58883], [-114.78744, 34.58884], [-114.78724, 34.58694], [-114.78834, 34.58693], [-114.78853, 34.58883]]], [[[-114.7885, 34.59925], [-114.7874, 34.59926], [-114.78731, 34.59831], [-114.7884, 34.5983], [-114.7885, 34.59925]]], [[[-114.79169, 34.59827], [-114.7895, 34.59829], [-114.7894, 34.59734], [-114.79049, 34.59733], [-114.7904, 34.59639], [-114.79149, 34.59638], [-114.79169, 34.59827]]], [[[-114.79449, 34.59351], [-114.7934, 34.59352], [-114.79349, 34.59446], [-114.79239, 34.59447], [-114.7923, 34.59353], [-114.79339, 34.59351], [-114.7933, 34.59257], [-114.7944, 34.59256], [-114.79449, 34.59351]]], [[[-114.79531, 34.59066], [-114.79421, 34.59067], [-114.79411, 34.58973], [-114.79521, 34.58972], [-114.79531, 34.59066]]], [[[-114.81627, 34.90399], [-114.81407, 34.90399], [-114.81406, 34.90218], [-114.81627, 34.90218], [-114.81627, 34.90399]]], [[[-114.98641, 34.43251], [-114.98422, 34.43251], [-114.9842, 34.42889], [-114.98639, 34.42888], [-114.98641, 34.43251]]], [[[-115.09561, 34.87178], [-115.09557, 34.8754], [-115.0912, 34.87537], [-115.09124, 34.87175], [-115.09561, 34.87178]]], [[[-115.10877, 34.86826], [-115.10872, 34.87187], [-115.09998, 34.87181], [-115.09998, 34.87091], [-115.09125, 34.87085], [-115.09127, 34.86813], [-115.10877, 34.86826]]], [[[-115.11865, 34.58626], [-115.10989, 34.58627], [-115.10988, 34.57902], [-115.11865, 34.579], [-115.11865, 34.58626]]], [[[-115.12744, 34.60213], [-115.12471, 34.60491], [-115.12449, 34.60478], [-115.1233, 34.60415], [-115.12656, 34.60073], [-115.12743, 34.60073], [-115.12744, 34.60213]]], [[[-115.20069, 34.51592], [-115.19197, 34.51592], [-115.19193, 34.50142], [-115.20066, 34.50142], [-115.20069, 34.51592]]], [[[-115.20132, 34.62619], [-115.20131, 34.62982], [-115.20021, 34.62982], [-115.20022, 34.62619], [-115.20132, 34.62619]]], [[[-115.22687, 34.50145], [-115.20939, 34.50143], [-115.2094, 34.48693], [-115.21813, 34.48694], [-115.21814, 34.49419], [-115.22249, 34.49418], [-115.2225, 34.48694], [-115.22685, 34.48695], [-115.22687, 34.50145]]], [[[-115.31086, 34.70265], [-115.30644, 34.70261], [-115.30098, 34.70269], [-115.30082, 34.69885], [-115.30644, 34.69564], [-115.30645, 34.69897], [-115.31086, 34.69901], [-115.31086, 34.70265]]], [[[-115.30588, 34.69533], [-115.30084, 34.69812], [-115.30084, 34.69812], [-115.30118, 34.6953], [-115.30588, 34.69533]]], [[[-115.35645, 34.39138], [-115.35207, 34.39144], [-115.35207, 34.3878], [-115.35644, 34.38773], [-115.35645, 34.39138]]], [[[-115.55452, 34.59906], [-115.55451, 34.60236], [-115.55426, 34.604], [-115.54927, 34.604], [-115.54952, 34.60235], [-115.54454, 34.60236], [-115.54454, 34.59906], [-115.55452, 34.59906]]], [[[-115.54984, 34.56414], [-115.54763, 34.56412], [-115.54761, 34.5632], [-115.54981, 34.56322], [-115.54984, 34.56414]]], [[[-115.58015, 34.21289], [-115.57139, 34.21284], [-115.57139, 34.20922], [-115.58014, 34.20927], [-115.58015, 34.21289]]], [[[-115.58015, 34.22012], [-115.57576, 34.2201], [-115.57576, 34.21648], [-115.58015, 34.2165], [-115.58015, 34.22012]]], [[[-116.09724, 34.74069], [-116.09614, 34.74067], [-116.09613, 34.73886], [-116.09723, 34.73887], [-116.09724, 34.74069]]], [[[-116.12985, 35.00253], [-116.12969, 35.00617], [-116.11212, 35.00673], [-116.11234, 35.00329], [-116.12985, 35.00253]]], [[[-116.13809, 35.03906], [-116.13809, 35.04271], [-116.12921, 35.0426], [-116.12923, 35.03895], [-116.13809, 35.03906]]], [[[-116.14696, 35.03917], [-116.14112, 35.0391], [-116.14113, 35.03182], [-116.14695, 35.03189], [-116.14696, 35.03917]]], [[[-116.15734, 34.64686], [-116.15689, 34.6541], [-116.14881, 34.65411], [-116.14942, 34.64688], [-116.15238, 34.64687], [-116.1519, 34.6477], [-116.15619, 34.64948], [-116.15708, 34.64802], [-116.15432, 34.64687], [-116.15734, 34.64686]]], [[[-116.18242, 35.04608], [-116.17799, 35.0462], [-116.17797, 35.03592], [-116.17738, 35.0359], [-116.18118, 35.03231], [-116.18241, 35.03232], [-116.18242, 35.04608]]], [[[-116.1803, 35.0323], [-116.1803, 35.0323], [-116.17797, 35.03451], [-116.17796, 35.03228], [-116.1803, 35.0323]]], [[[-116.18242, 35.04685], [-116.17799, 35.04681], [-116.17799, 35.04675], [-116.18242, 35.04663], [-116.18242, 35.04685]]], [[[-116.20251, 34.82641], [-116.20247, 34.82821], [-116.20136, 34.8282], [-116.20139, 34.8264], [-116.20251, 34.82641]]], [[[-116.21805, 35.04509], [-116.2136, 35.04521], [-116.21356, 35.04029], [-116.21801, 35.04038], [-116.21805, 35.04509]]], [[[-116.21808, 35.04764], [-116.21362, 35.04755], [-116.21361, 35.04576], [-116.21806, 35.04563], [-116.21808, 35.04764]]], [[[-116.24474, 35.0408], [-116.24029, 35.04073], [-116.24034, 35.04449], [-116.23588, 35.04458], [-116.23573, 35.0334], [-116.24462, 35.03352], [-116.24474, 35.0408]]], [[[-116.24039, 35.04801], [-116.23592, 35.04793], [-116.23589, 35.04513], [-116.24035, 35.04504], [-116.24039, 35.04801]]], [[[-116.35568, 34.78247], [-116.35238, 34.78251], [-116.35238, 34.7819], [-116.35568, 34.78187], [-116.35568, 34.78247]]], [[[-116.49842, 34.09795], [-116.49757, 34.09837], [-116.49271, 34.09176], [-116.4927, 34.09028], [-116.49834, 34.09028], [-116.49842, 34.09795]]]]} No Public Access 3 49067 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/ San Bernardino 22 3237.077   0 Private Other or Unknown 399 4

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