units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
13 rows where COUNTY = 10 and DES_TP = 399 sorted by DES_TP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4602 | 4602 | 4601 | {"type": "Polygon", "coordinates": [[[-115.6625, 33.59841], [-115.66249, 33.60022], [-115.66023, 33.60022], [-115.66024, 33.59841], [-115.6625, 33.59841]]]} | No Public Access 3 | 35673 | Unnamed site - Riverside Land Conservancy | 28658 | 3059 | Rivers and Lands Conservancy 773 | Non Profit 6 | Non Profit - Land Trust 10 | https://riversandlands.org/ | Non Governmental Organization 10 | 3059 | Rivers and Lands Conservancy 754 | Non Profit 6 | Non Profit - Land Trust 10 | Riverside 10 | 10.421 | 0 | Private Other or Unknown 399 | 4 | ||
4606 | 4606 | 4605 | {"type": "Polygon", "coordinates": [[[-115.15033, 33.86963], [-115.15032, 33.87144], [-115.14923, 33.87145], [-115.14924, 33.86963], [-115.15033, 33.86963]]]} | No Public Access 3 | 35719 | Unnamed site - Riverside Land Conservancy | 28658 | 3059 | Rivers and Lands Conservancy 773 | Non Profit 6 | Non Profit - Land Trust 10 | https://riversandlands.org/ | Non Governmental Organization 10 | 3059 | Rivers and Lands Conservancy 754 | Non Profit 6 | Non Profit - Land Trust 10 | Riverside 10 | 5.031 | 0 | Private Other or Unknown 399 | 4 | ||
4607 | 4607 | 4606 | {"type": "Polygon", "coordinates": [[[-115.25346, 33.94901], [-115.25345, 33.95266], [-115.24906, 33.95262], [-115.24907, 33.94897], [-115.25346, 33.94901]]]} | No Public Access 3 | 35721 | Unnamed site - Riverside Land Conservancy | 28658 | 3059 | Rivers and Lands Conservancy 773 | Non Profit 6 | Non Profit - Land Trust 10 | https://riversandlands.org/ | Non Governmental Organization 10 | 3059 | Rivers and Lands Conservancy 754 | Non Profit 6 | Non Profit - Land Trust 10 | Riverside 10 | 40.642 | 0 | Private Other or Unknown 399 | 4 | ||
4677 | 4677 | 4676 | {"type": "Polygon", "coordinates": [[[-115.25785, 33.94904], [-115.25784, 33.9527], [-115.25345, 33.95266], [-115.25346, 33.94901], [-115.25785, 33.94904]]]} | No Public Access 3 | 36662 | Unnamed site - Riverside Land Conservancy | 28658 | 3059 | Rivers and Lands Conservancy 773 | Non Profit 6 | Non Profit - Land Trust 10 | https://riversandlands.org/ | Non Governmental Organization 10 | 3059 | Rivers and Lands Conservancy 754 | Non Profit 6 | Non Profit - Land Trust 10 | Riverside 10 | 40.688 | 0 | Private Other or Unknown 399 | 4 | ||
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 | |
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 | |
15454 | 15454 | 15453 | {"type": "Polygon", "coordinates": [[[-116.36903, 33.83109], [-116.36896, 33.83837], [-116.36677, 33.83836], [-116.36686, 33.83109], [-116.36903, 33.83109]]]} | Unknown Access 4 | 3769 | Unnamed site - Center for Natural Lands Management | 28629 | 3014 | Center for Natural Lands Management 91 | Non Profit 6 | Non Profit - Land Trust 10 | http://cnlm.org/ | Non Governmental Organization 10 | 3014 | Center for Natural Lands Management 89 | Non Profit 6 | Non Profit - Land Trust 10 | Riverside 10 | 40.197 | 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]);