units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
7 rows where MNG_AGENCY = 277 and YR_EST = 0
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, LABEL_NAME, GAP_STS
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2003 | 2003 | 2002 | {"type": "Polygon", "coordinates": [[[-116.65655, 33.97984], [-116.65486, 33.97985], [-116.65485, 33.97777], [-116.65654, 33.97777], [-116.65655, 33.97984]]]} | Open Access 1 | 15336 | Whitewater Canyon | 4022 | 3025 | Friends of the Desert Mountains 281 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.desertmountains.org/ | Non Governmental Organization 10 | 3025 | Friends of the Desert Mountains 277 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.wildlandsconservancy.org/preserve_whitewater.html | Riverside 10 | 8.883 | Whitewater Canyon | 0 | Private Conservation 16 | 2 |
3606 | 3606 | 3605 | {"type": "Polygon", "coordinates": [[[-116.65656, 33.98163], [-116.65225, 33.98164], [-116.65224, 33.97985], [-116.65243, 33.97626], [-116.65654, 33.97625], [-116.65654, 33.97777], [-116.65485, 33.97778], [-116.65486, 33.97984], [-116.65655, 33.97984], [-116.65656, 33.98163]]]} | Open Access 1 | 29275 | Whitewater Canyon | 4022 | 3025 | Friends of the Desert Mountains 281 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.desertmountains.org/ | Non Governmental Organization 10 | 3025 | Friends of the Desert Mountains 277 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.wildlandsconservancy.org/preserve_whitewater.html | Riverside 10 | 48.98 | Whitewater Canyon | 0 | Private Conservation 16 | 2 |
4564 | 4564 | 4563 | {"type": "MultiPolygon", "coordinates": [[[[-116.11039, 33.44247], [-116.10826, 33.44247], [-116.10825, 33.44073], [-116.11038, 33.44072], [-116.11039, 33.44247]]], [[[-116.10935, 33.44611], [-116.10828, 33.44612], [-116.10827, 33.44431], [-116.10934, 33.4443], [-116.10935, 33.44611]]], [[[-115.74733, 33.43453], [-115.73867, 33.43457], [-115.73865, 33.42729], [-115.74731, 33.42724], [-115.74733, 33.43453]]], [[[-115.78294, 33.4371], [-115.77836, 33.43734], [-115.77816, 33.43392], [-115.78267, 33.43375], [-115.78294, 33.4371]]], [[[-116.13863, 33.45518], [-116.1343, 33.45522], [-116.13423, 33.45164], [-116.13531, 33.45163], [-116.13524, 33.44803], [-116.13848, 33.44804], [-116.13863, 33.45518]]], [[[-116.13321, 33.45523], [-116.12992, 33.45525], [-116.12992, 33.45165], [-116.13316, 33.45165], [-116.13321, 33.45523]]], [[[-116.11248, 33.44793], [-116.11247, 33.45514], [-116.11155, 33.45514], [-116.11151, 33.44793], [-116.11248, 33.44793]]], [[[-115.75601, 33.45632], [-115.74304, 33.4564], [-115.74303, 33.45276], [-115.73437, 33.4528], [-115.73436, 33.44916], [-115.73003, 33.44918], [-115.73002, 33.4419], [-115.73868, 33.44186], [-115.7387, 33.44914], [-115.756, 33.44904], [-115.75601, 33.45632]]], [[[-115.78263, 33.48481], [-115.7826, 33.48581], [-115.77976, 33.48731], [-115.77978, 33.4849], [-115.78263, 33.48481]]], [[[-115.77365, 33.4851], [-115.77357, 33.49049], [-115.76899, 33.49285], [-115.7687, 33.49299], [-115.76839, 33.49312], [-115.76778, 33.49334], [-115.7661, 33.49382], [-115.76467, 33.48945], [-115.76466, 33.48539], [-115.76242, 33.4854], [-115.7588, 33.48059], [-115.75845, 33.48014], [-115.75772, 33.47925], [-115.75695, 33.47839], [-115.75614, 33.47755], [-115.75531, 33.47673], [-115.74902, 33.47093], [-115.76465, 33.47082], [-115.76467, 33.48538], [-115.77365, 33.4851]]], [[[-115.77791, 33.49623], [-115.77784, 33.49998], [-115.76744, 33.49995], [-115.76742, 33.49922], [-115.76738, 33.4987], [-115.76732, 33.49818], [-115.76719, 33.4974], [-115.76707, 33.49689], [-115.76687, 33.49616], [-115.76628, 33.49435], [-115.76801, 33.49385], [-115.76867, 33.49362], [-115.76932, 33.49333], [-115.77079, 33.49257], [-115.77355, 33.49253], [-115.7735, 33.49625], [-115.77791, 33.49623]]], [[[-115.79094, 33.49983], [-115.79085, 33.51014], [-115.78868, 33.51019], [-115.78868, 33.50984], [-115.78759, 33.50984], [-115.7876, 33.50805], [-115.78869, 33.50803], [-115.78876, 33.49988], [-115.79094, 33.49983]]], [[[-115.7844, 33.49996], [-115.78431, 33.51029], [-115.78211, 33.51035], [-115.78223, 33.5], [-115.7844, 33.49996]]], [[[-116.20263, 33.53223], [-116.1984, 33.53224], [-116.1984, 33.53133], [-116.20262, 33.53132], [-116.20263, 33.53223]]], [[[-116.20483, 33.53673], [-116.20483, 33.53763], [-116.20267, 33.53763], [-116.20266, 33.53852], [-116.1983, 33.53852], [-116.1983, 33.53764], [-116.20158, 33.53763], [-116.20158, 33.53674], [-116.20483, 33.53673]]], [[[-115.75192, 33.531], [-115.74761, 33.53102], [-115.7476, 33.52921], [-115.75191, 33.52919], [-115.75192, 33.531]]], [[[-115.87997, 33.55444], [-115.87898, 33.55447], [-115.87892, 33.55083], [-115.87992, 33.5508], [-115.87997, 33.55444]]], [[[-115.93063, 33.56179], [-115.92202, 33.56176], [-115.92175, 33.55441], [-115.93043, 33.55447], [-115.93052, 33.55812], [-115.93063, 33.56179]]], [[[-116.22972, 33.57756], [-116.2248, 33.57751], [-116.22482, 33.57648], [-116.22436, 33.57648], [-116.22435, 33.57461], [-116.22436, 33.5746], [-116.22435, 33.5737], [-116.22718, 33.57368], [-116.22816, 33.57512], [-116.22904, 33.57647], [-116.22945, 33.57706], [-116.2296, 33.57731], [-116.2297, 33.57749], [-116.22972, 33.57756]]], [[[-116.2709, 33.59277], [-116.26982, 33.59276], [-116.26981, 33.59095], [-116.2709, 33.59095], [-116.2709, 33.59277]]], [[[-116.06075, 33.67141], [-116.05857, 33.67141], [-116.05857, 33.66959], [-116.06075, 33.6696], [-116.06075, 33.67141]]], [[[-116.05639, 33.6714], [-116.05422, 33.6714], [-116.05421, 33.66868], [-116.05639, 33.66868], [-116.05639, 33.6714]]], [[[-116.05203, 33.66777], [-116.04768, 33.66776], [-116.04768, 33.67139], [-116.04332, 33.67138], [-116.04332, 33.66411], [-116.05203, 33.66413], [-116.05203, 33.66777]]], [[[-116.05642, 33.68943], [-116.05641, 33.69305], [-116.05343, 33.69305], [-116.05175, 33.69222], [-116.05112, 33.69193], [-116.05062, 33.69172], [-116.0501, 33.69153], [-116.04957, 33.69136], [-116.04904, 33.69121], [-116.04633, 33.69], [-116.04367, 33.68981], [-116.04332, 33.68974], [-116.04332, 33.68581], [-116.05202, 33.68582], [-116.05202, 33.68942], [-116.05642, 33.68943]]], [[[-116.03034, 33.70947], [-116.03034, 33.71127], [-116.02818, 33.71128], [-116.02819, 33.70946], [-116.03034, 33.70947]]], [[[-116.06078, 33.7248], [-116.06078, 33.72571], [-116.05205, 33.72574], [-116.05206, 33.72936], [-116.06078, 33.72934], [-116.06077, 33.74387], [-116.04407, 33.7439], [-116.04333, 33.74303], [-116.04333, 33.72212], [-116.04551, 33.72211], [-116.04552, 33.72393], [-116.04769, 33.72392], [-116.04769, 33.72211], [-116.05205, 33.7221], [-116.05206, 33.72482], [-116.06078, 33.7248]]], [[[-116.07824, 33.75837], [-116.07824, 33.76202], [-116.07387, 33.76202], [-116.07387, 33.75838], [-116.07824, 33.75837]]], [[[-116.10752, 33.76574], [-116.10752, 33.76938], [-116.10316, 33.76936], [-116.10317, 33.76571], [-116.10752, 33.76574]]], [[[-116.09195, 33.77659], [-116.09194, 33.78748], [-116.08792, 33.78748], [-116.07458, 33.77618], [-116.07458, 33.77336], [-116.07503, 33.77296], [-116.07894, 33.77296], [-116.07893, 33.77659], [-116.08543, 33.77659], [-116.08545, 33.77296], [-116.08761, 33.77296], [-116.08761, 33.77659], [-116.09195, 33.77659]]], [[[-116.24856, 33.79477], [-116.24856, 33.80022], [-116.23116, 33.80026], [-116.23115, 33.78759], [-116.23986, 33.78758], [-116.23987, 33.79477], [-116.24856, 33.79477]]], [[[-116.18621, 33.80619], [-116.1862, 33.8077], [-116.1823, 33.80769], [-116.1823, 33.80617], [-116.18621, 33.80619]]], [[[-116.14848, 33.80578], [-116.1463, 33.80577], [-116.14629, 33.80667], [-116.14411, 33.80666], [-116.1441, 33.80214], [-116.14848, 33.80216], [-116.14848, 33.80578]]], [[[-116.26601, 33.81656], [-116.24855, 33.8166], [-116.24856, 33.80209], [-116.26578, 33.80204], [-116.26601, 33.81656]]], [[[-116.16594, 33.81671], [-116.16594, 33.82032], [-116.1616, 33.82031], [-116.1616, 33.8167], [-116.16594, 33.81671]]], [[[-116.17027, 33.82216], [-116.17027, 33.82216], [-116.16661, 33.82215], [-116.16896, 33.82033], [-116.17026, 33.82033], [-116.17027, 33.82216]]], [[[-116.15365, 33.82717], [-116.15315, 33.82706], [-116.15301, 33.82705], [-116.15285, 33.82707], [-116.15272, 33.82711], [-116.1526, 33.82717], [-116.1525, 33.82724], [-116.15237, 33.82739], [-116.15216, 33.82754], [-116.14412, 33.82749], [-116.14412, 33.81663], [-116.15363, 33.81667], [-116.15365, 33.82717]]], [[[-116.19631, 33.83847], [-116.17904, 33.83844], [-116.17903, 33.8312], [-116.19631, 33.83122], [-116.19631, 33.83847]], [[-116.19039, 33.83719], [-116.19039, 33.83737], [-116.19093, 33.83737], [-116.19092, 33.83719], [-116.19039, 33.83719]]], [[[-116.20933, 33.8666], [-116.20505, 33.86442], [-116.20505, 33.86408], [-116.20438, 33.86408], [-116.19733, 33.86046], [-116.20511, 33.86045], [-116.20932, 33.86046], [-116.20933, 33.8666]]], [[[-116.3014, 33.88038], [-116.30139, 33.88401], [-116.29646, 33.884], [-116.29645, 33.88219], [-116.29537, 33.88218], [-116.29537, 33.884], [-116.29428, 33.884], [-116.29429, 33.88581], [-116.2932, 33.88581], [-116.29319, 33.88399], [-116.29211, 33.884], [-116.29211, 33.88762], [-116.28776, 33.88761], [-116.28776, 33.8858], [-116.28668, 33.88579], [-116.28668, 33.88761], [-116.28342, 33.8876], [-116.28341, 33.87854], [-116.2834, 33.87853], [-116.28339, 33.8749], [-116.29016, 33.87493], [-116.29101, 33.87491], [-116.29535, 33.87494], [-116.29537, 33.87856], [-116.29645, 33.87855], [-116.29644, 33.87494], [-116.29753, 33.87494], [-116.29753, 33.87675], [-116.29971, 33.87676], [-116.29971, 33.88037], [-116.3014, 33.88038]], [[-116.28666, 33.88579], [-116.28667, 33.88398], [-116.2845, 33.88398], [-116.2845, 33.88578], [-116.28666, 33.88579]], [[-116.28557, 33.88216], [-116.28558, 33.88035], [-116.28449, 33.88035], [-116.2845, 33.88216], [-116.28557, 33.88216]], [[-116.29427, 33.88218], [-116.29428, 33.88217], [-116.29427, 33.87856], [-116.29319, 33.87855], [-116.29319, 33.88036], [-116.2921, 33.88037], [-116.2921, 33.88217], [-116.29427, 33.88218]], [[-116.28667, 33.8775], [-116.28665, 33.87673], [-116.28557, 33.87673], [-116.28558, 33.87853], [-116.28666, 33.87853], [-116.28667, 33.8775]], [[-116.2921, 33.87675], [-116.29101, 33.87673], [-116.29102, 33.87855], [-116.2921, 33.87854], [-116.2921, 33.87675]], [[-116.29209, 33.88036], [-116.2921, 33.87901], [-116.29102, 33.879], [-116.29102, 33.88036], [-116.29209, 33.88036]]], [[[-116.41468, 33.89668], [-116.41462, 33.8994], [-116.41247, 33.89939], [-116.41248, 33.89668], [-116.41468, 33.89668]]], [[[-116.41457, 33.90121], [-116.41455, 33.90212], [-116.41036, 33.90211], [-116.41035, 33.90029], [-116.41247, 33.9003], [-116.41247, 33.9012], [-116.41457, 33.90121]]], [[[-116.6389, 33.91082], [-116.63675, 33.91082], [-116.63672, 33.90839], [-116.63888, 33.90828], [-116.6389, 33.91082]]], [[[-116.64988, 33.91441], [-116.64662, 33.91442], [-116.64663, 33.91533], [-116.64555, 33.91534], [-116.64546, 33.91082], [-116.64983, 33.91082], [-116.64988, 33.91441]]], [[[-116.64447, 33.91579], [-116.64338, 33.9158], [-116.64337, 33.91534], [-116.64446, 33.91534], [-116.64447, 33.91579]]], [[[-116.64777, 33.91807], [-116.64342, 33.91808], [-116.64341, 33.91744], [-116.64558, 33.91731], [-116.64666, 33.91731], [-116.64667, 33.91726], [-116.64776, 33.91726], [-116.64777, 33.91807]]], [[[-116.32979, 33.90377], [-116.32899, 33.90569], [-116.32678, 33.90997], [-116.32616, 33.91101], [-116.31879, 33.91097], [-116.31875, 33.91098], [-116.31875, 33.91269], [-116.31002, 33.90844], [-116.30136, 33.90426], [-116.30136, 33.90383], [-116.30047, 33.90383], [-116.28342, 33.89562], [-116.28342, 33.88941], [-116.30138, 33.88945], [-116.30137, 33.90357], [-116.31877, 33.90373], [-116.31879, 33.90013], [-116.32317, 33.90015], [-116.32316, 33.90375], [-116.32979, 33.90377]], [[-116.31877, 33.90612], [-116.31879, 33.90612], [-116.31881, 33.904], [-116.31879, 33.90391], [-116.31878, 33.90392], [-116.31877, 33.90612]]], [[[-116.37098, 33.9096], [-116.37097, 33.91099], [-116.3623, 33.91101], [-116.36227, 33.91826], [-116.35574, 33.91828], [-116.35577, 33.91104], [-116.35359, 33.91104], [-116.35362, 33.90379], [-116.36012, 33.90378], [-116.37098, 33.9096]]], [[[-116.71097, 33.9382], [-116.70987, 33.93821], [-116.70986, 33.9345], [-116.71095, 33.93449], [-116.71097, 33.9382]]], [[[-116.64172, 33.9475], [-116.64148, 33.9475], [-116.64137, 33.94735], [-116.64162, 33.94735], [-116.64172, 33.9475]]], [[[-116.44054, 33.96104], [-116.42877, 33.96124], [-116.42304, 33.95752], [-116.42302, 33.94686], [-116.44043, 33.94685], [-116.44054, 33.96104]]], [[[-116.58264, 34.00542], [-116.58046, 34.00555], [-116.58041, 34.00236], [-116.58256, 34.00224], [-116.58264, 34.00542]]]]} | Open Access 1 | 35203 | Unnamed site - Friends of the Desert Mountains | 33250 | 3025 | Friends of the Desert Mountains 281 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.desertmountains.org/ | Non Governmental Organization 10 | 3025 | Friends of the Desert Mountains 277 | Non Profit 6 | Non Profit - Land Trust 10 | Riverside 10 | 7591.856 | 0 | Private Other or Unknown 399 | 4 | ||
5298 | 5298 | 5297 | {"type": "Polygon", "coordinates": [[[-116.6412, 33.93996], [-116.64119, 33.94368], [-116.63686, 33.94361], [-116.63684, 33.93993], [-116.6412, 33.93996]]]} | Open Access 1 | 4539 | Whitewater Canyon | 4022 | 3025 | Friends of the Desert Mountains 281 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.desertmountains.org/ | Non Governmental Organization 10 | 3025 | Friends of the Desert Mountains 277 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.wildlandsconservancy.org/preserve_whitewater.html | Riverside 10 | 40.728 | Whitewater Canyon | 0 | Private Conservation 16 | 2 |
6583 | 6583 | 6582 | {"type": "Polygon", "coordinates": [[[-116.4581, 33.88588], [-116.45809, 33.88852], [-116.44949, 33.88855], [-116.44946, 33.88418], [-116.45197, 33.88413], [-116.45236, 33.88407], [-116.45273, 33.88394], [-116.45288, 33.88386], [-116.45302, 33.88378], [-116.45327, 33.88357], [-116.45338, 33.88346], [-116.45357, 33.88321], [-116.45371, 33.88285], [-116.45372, 33.88278], [-116.45374, 33.88679], [-116.45483, 33.88678], [-116.45484, 33.88588], [-116.4581, 33.88588]]]} | No Public Access 3 | 3932 | Edom Hill-Willow Hole Preserve | 18455 | 3025 | Friends of the Desert Mountains 281 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.desertmountains.org/ | Non Governmental Organization 10 | 3025 | Friends of the Desert Mountains 277 | Non Profit 6 | Non Profit - Land Trust 10 | Riverside 10 | 75.777 | Edom Hill-Willow Hole Preserve | 0 | Private Conservation 16 | 2 | |
15781 | 15781 | 15780 | {"type": "MultiPolygon", "coordinates": [[[[-116.64487, 33.95441], [-116.63692, 33.9544], [-116.637, 33.94735], [-116.64162, 33.94735], [-116.64183, 33.94766], [-116.64159, 33.94766], [-116.64159, 33.94767], [-116.64163, 33.94773], [-116.64188, 33.94773], [-116.64218, 33.94819], [-116.64195, 33.94819], [-116.64194, 33.94821], [-116.642, 33.94826], [-116.64224, 33.94827], [-116.64272, 33.94887], [-116.64287, 33.94918], [-116.64264, 33.94918], [-116.64263, 33.94919], [-116.64278, 33.94948], [-116.64283, 33.94964], [-116.64308, 33.94964], [-116.64336, 33.95041], [-116.64346, 33.95041], [-116.64335, 33.95011], [-116.64355, 33.95011], [-116.64366, 33.95041], [-116.64375, 33.95041], [-116.64361, 33.95001], [-116.64384, 33.95001], [-116.64398, 33.95041], [-116.64392, 33.95127], [-116.64397, 33.95159], [-116.64448, 33.95304], [-116.64454, 33.95319], [-116.64471, 33.95344], [-116.6448, 33.95361], [-116.64485, 33.95382], [-116.64487, 33.95441]]], [[[-116.642, 33.94374], [-116.64194, 33.94552], [-116.64158, 33.94552], [-116.64119, 33.94416], [-116.64119, 33.94374], [-116.642, 33.94374]]], [[[-116.64287, 33.94708], [-116.64239, 33.9465], [-116.64209, 33.94584], [-116.64211, 33.94548], [-116.64286, 33.94548], [-116.64287, 33.94708]]], [[[-116.64286, 33.94537], [-116.64211, 33.94537], [-116.64216, 33.94374], [-116.64285, 33.94374], [-116.64286, 33.94537]]], [[[-116.64255, 33.94695], [-116.64222, 33.94695], [-116.64232, 33.94666], [-116.64255, 33.94695], [-116.64255, 33.94695]]], [[[-116.6428, 33.94774], [-116.64255, 33.94774], [-116.64251, 33.94766], [-116.64276, 33.94766], [-116.6428, 33.94774]]], [[[-116.64294, 33.94757], [-116.64272, 33.94757], [-116.64261, 33.94735], [-116.64288, 33.94735], [-116.64294, 33.94757]]], [[[-116.64317, 33.94918], [-116.64297, 33.94918], [-116.64282, 33.94887], [-116.64277, 33.94881], [-116.64299, 33.94881], [-116.64317, 33.94918]]], [[[-116.64372, 33.94537], [-116.643, 33.94537], [-116.64298, 33.94374], [-116.64371, 33.94374], [-116.64372, 33.94537]]], [[[-116.64373, 33.94672], [-116.643, 33.94672], [-116.643, 33.94548], [-116.64372, 33.94548], [-116.64373, 33.94672]]], [[[-116.64997, 33.94735], [-116.64991, 33.95442], [-116.64507, 33.95441], [-116.64504, 33.95381], [-116.64501, 33.95361], [-116.64494, 33.95345], [-116.64476, 33.95318], [-116.64466, 33.95299], [-116.64419, 33.95164], [-116.64414, 33.95145], [-116.64412, 33.95117], [-116.64417, 33.95037], [-116.64383, 33.94938], [-116.64345, 33.94864], [-116.64308, 33.94735], [-116.64997, 33.94735]]], [[[-116.64461, 33.94537], [-116.64385, 33.94537], [-116.64384, 33.94374], [-116.6446, 33.94374], [-116.64461, 33.94537]]], [[[-116.64463, 33.94729], [-116.64387, 33.9473], [-116.64385, 33.94548], [-116.64461, 33.94548], [-116.64463, 33.94729]]], [[[-116.6455, 33.94455], [-116.64474, 33.94455], [-116.64473, 33.94374], [-116.64549, 33.94374], [-116.6455, 33.94455]]], [[[-116.64551, 33.9473], [-116.64476, 33.9473], [-116.64475, 33.94589], [-116.6455, 33.94589], [-116.64551, 33.9473]]], [[[-116.70436, 33.93827], [-116.70435, 33.94014], [-116.70214, 33.94017], [-116.70215, 33.93829], [-116.70436, 33.93827]]], [[[-116.70656, 33.94374], [-116.70656, 33.94555], [-116.70544, 33.94556], [-116.70543, 33.94736], [-116.70432, 33.94736], [-116.70432, 33.94556], [-116.70321, 33.94556], [-116.70322, 33.94376], [-116.70656, 33.94374]]], [[[-116.70987, 33.93821], [-116.70877, 33.93822], [-116.70877, 33.93729], [-116.70987, 33.93728], [-116.70987, 33.93821]]], [[[-116.71103, 33.94736], [-116.70879, 33.94736], [-116.70879, 33.94554], [-116.71102, 33.94553], [-116.71103, 33.94736]]]]} | Open Access 1 | 48566 | Sand to Snow National Monument | 33277 | 3025 | Friends of the Desert Mountains 281 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.desertmountains.org/ | Non Governmental Organization 10 | 3025 | Friends of the Desert Mountains 277 | Non Profit 6 | Non Profit - Land Trust 10 | Riverside 10 | 290.865 | Sand to Snow NM | 0 | National Monument or Landmark 80 | 3 | |
15786 | 15786 | 15785 | {"type": "Polygon", "coordinates": [[[-116.37096, 33.93276], [-116.37035, 33.93275], [-116.35362, 33.92614], [-116.35356, 33.91828], [-116.34448, 33.91828], [-116.33625, 33.91831], [-116.33345, 33.91828], [-116.32746, 33.91604], [-116.32749, 33.91102], [-116.32661, 33.91101], [-116.32938, 33.90564], [-116.33015, 33.90377], [-116.33626, 33.90377], [-116.33628, 33.91108], [-116.35359, 33.91104], [-116.35357, 33.91828], [-116.37095, 33.91825], [-116.37096, 33.93276]]]} | Open Access 1 | 3716 | Joshua Tree National Park Linkage | 3979 | 3025 | Friends of the Desert Mountains 281 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.desertmountains.org/ | Non Governmental Organization 10 | 3025 | Friends of the Desert Mountains 277 | Non Profit 6 | Non Profit - Land Trust 10 | Riverside 10 | 1102.783 | Joshua Tree NP Linkage | 0 | Private Conservation 16 | 2 |
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]);