units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where AGNCY_TYP = 10, DES_TP = 399 and MNG_AGENCY = 277
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
- Friends of the Desert Mountains · 1 ✖
DES_TP 1
- Private Other or Unknown · 1 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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]);