units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where DES_TP = 399, LAYER = 10 and SUID_NMA = 33770
This data as json, copyable, CSV (advanced)
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
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]);