units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where COUNTY = 20, DES_TP = 87 and MNG_AG_TYP = 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12674 | 12674 | 12673 | {"type": "MultiPolygon", "coordinates": [[[[-115.0362, 32.79606], [-114.99756, 32.79608], [-114.99755, 32.79245], [-114.99326, 32.79245], [-114.99326, 32.78883], [-114.98897, 32.78883], [-114.98896, 32.7852], [-114.98467, 32.78519], [-114.98467, 32.78157], [-114.97178, 32.78156], [-114.97177, 32.77068], [-114.96749, 32.77065], [-114.96747, 32.76342], [-114.96318, 32.76342], [-114.96318, 32.75617], [-114.95888, 32.75616], [-114.95888, 32.75253], [-114.95459, 32.75253], [-114.95459, 32.73439], [-114.95889, 32.73439], [-114.95889, 32.73802], [-114.96318, 32.73802], [-114.96318, 32.74527], [-114.96747, 32.74528], [-114.96747, 32.75253], [-114.97176, 32.75253], [-114.97177, 32.75978], [-114.97606, 32.7598], [-114.97607, 32.76523], [-114.97811, 32.76522], [-114.97813, 32.76706], [-114.98896, 32.76707], [-114.98896, 32.77794], [-114.99325, 32.77795], [-114.99326, 32.78157], [-115.00613, 32.78156], [-115.02327, 32.78158], [-115.0233, 32.78883], [-115.0276, 32.78883], [-115.02762, 32.79245], [-115.0362, 32.79244], [-115.0362, 32.79606]]], [[[-115.29693, 32.68354], [-115.29264, 32.68355], [-115.29264, 32.69445], [-115.28406, 32.69447], [-115.28405, 32.70172], [-115.26692, 32.70176], [-115.2669, 32.70901], [-115.25922, 32.70903], [-115.25923, 32.71265], [-115.24638, 32.71266], [-115.24637, 32.71447], [-115.23781, 32.71448], [-115.23779, 32.71267], [-115.22923, 32.71269], [-115.22922, 32.70908], [-115.22065, 32.7091], [-115.16057, 32.70902], [-115.16056, 32.70903], [-115.16056, 32.7199], [-115.15199, 32.7199], [-115.15198, 32.71627], [-115.14341, 32.71627], [-115.1434, 32.71989], [-115.12625, 32.71989], [-115.12624, 32.71627], [-115.11765, 32.71627], [-115.11764, 32.71264], [-115.07473, 32.71264], [-115.07472, 32.70901], [-115.05759, 32.70901], [-115.05757, 32.71264], [-115.04901, 32.71264], [-115.04903, 32.72352], [-115.02327, 32.72353], [-115.02326, 32.71264], [-114.98036, 32.71264], [-114.98035, 32.73078], [-114.9546, 32.73076], [-114.9546, 32.72351], [-114.97177, 32.72351], [-114.97177, 32.70902], [-114.96657, 32.70901], [-114.96657, 32.70216], [-115.12104, 32.69151], [-115.17258, 32.68792], [-115.19998, 32.68604], [-115.22402, 32.68438], [-115.24442, 32.68289], [-115.27547, 32.68072], [-115.29693, 32.67916], [-115.29693, 32.68354]], [[-115.1434, 32.71264], [-115.15626, 32.71265], [-115.15627, 32.70903], [-115.1434, 32.70901], [-115.12624, 32.70902], [-115.12625, 32.71264], [-115.13911, 32.71264], [-115.13912, 32.71454], [-115.14339, 32.71453], [-115.1434, 32.71264]]], [[[-115.1135, 32.88311], [-115.1006, 32.88312], [-115.10059, 32.8795], [-115.09629, 32.8795], [-115.09628, 32.87587], [-115.09198, 32.87587], [-115.09198, 32.86863], [-115.08864, 32.86862], [-115.08864, 32.865], [-115.08338, 32.865], [-115.08338, 32.85776], [-115.07908, 32.85776], [-115.07908, 32.85413], [-115.07478, 32.85414], [-115.07478, 32.84688], [-115.07049, 32.84688], [-115.07049, 32.84325], [-115.0662, 32.84324], [-115.06619, 32.83962], [-115.06191, 32.83961], [-115.0619, 32.83599], [-115.05762, 32.83598], [-115.05761, 32.8251], [-115.0619, 32.8251], [-115.06191, 32.82873], [-115.06619, 32.82873], [-115.0662, 32.83236], [-115.07048, 32.83236], [-115.07049, 32.83599], [-115.07478, 32.83599], [-115.07478, 32.83962], [-115.07908, 32.83962], [-115.07908, 32.84325], [-115.08338, 32.84325], [-115.08338, 32.8505], [-115.08768, 32.8505], [-115.08768, 32.85412], [-115.09197, 32.85412], [-115.09198, 32.86137], [-115.09627, 32.86137], [-115.09628, 32.86499], [-115.10057, 32.86499], [-115.10058, 32.87224], [-115.10488, 32.87224], [-115.1049, 32.87587], [-115.10919, 32.87587], [-115.10921, 32.87949], [-115.11349, 32.87949], [-115.1135, 32.88311]]], [[[-115.18637, 32.96293], [-115.18637, 32.97015], [-115.17776, 32.97015], [-115.17776, 32.9665], [-115.16916, 32.96652], [-115.16916, 32.95927], [-115.16486, 32.95927], [-115.16485, 32.95564], [-115.16055, 32.95564], [-115.16057, 32.94113], [-115.16487, 32.94113], [-115.16487, 32.94476], [-115.16917, 32.94476], [-115.16917, 32.94838], [-115.17347, 32.94839], [-115.17346, 32.95564], [-115.17777, 32.95564], [-115.17777, 32.95926], [-115.18207, 32.95929], [-115.18207, 32.96291], [-115.18637, 32.96293]]], [[[-115.27626, 33.06101], [-115.27625, 33.07493], [-115.26763, 33.07493], [-115.26764, 33.06464], [-115.26333, 33.06463], [-115.26335, 33.05012], [-115.26765, 33.05012], [-115.26765, 33.05375], [-115.27196, 33.05375], [-115.27196, 33.061], [-115.27626, 33.06101]]], [[[-115.27211, 32.75921], [-115.26839, 32.75921], [-115.26838, 32.75981], [-115.26781, 32.75981], [-115.26781, 32.75254], [-115.27008, 32.75253], [-115.26996, 32.74527], [-115.2721, 32.74527], [-115.27211, 32.75921]]], [[[-115.28072, 32.76707], [-115.28071, 32.77432], [-115.27641, 32.77434], [-115.2764, 32.78159], [-115.2721, 32.7816], [-115.27211, 32.77072], [-115.26781, 32.77072], [-115.26781, 32.76345], [-115.26839, 32.76345], [-115.26841, 32.76646], [-115.27211, 32.76647], [-115.27212, 32.76708], [-115.28072, 32.76707]]], [[[-115.27639, 32.73799], [-115.27209, 32.73799], [-115.27209, 32.73436], [-115.27638, 32.73436], [-115.27639, 32.73799]]], [[[-115.28501, 32.82878], [-115.28072, 32.82878], [-115.2807, 32.82516], [-115.27641, 32.82516], [-115.27641, 32.8179], [-115.285, 32.81789], [-115.28501, 32.82878]]], [[[-115.29357, 32.95302], [-115.29356, 32.9594], [-115.28926, 32.9594], [-115.28927, 32.95304], [-115.29357, 32.95302]]], [[[-115.29361, 32.86201], [-115.29358, 32.91949], [-115.28928, 32.9195], [-115.28932, 32.86201], [-115.29361, 32.86201]]], [[[-115.29784, 32.96666], [-115.29783, 32.9739], [-115.29353, 32.97391], [-115.29354, 32.96666], [-115.29784, 32.96666]]], [[[-115.30213, 32.97753], [-115.30213, 32.98116], [-115.29782, 32.98116], [-115.29783, 32.97753], [-115.30213, 32.97753]]], [[[-115.31837, 32.68714], [-115.31408, 32.68715], [-115.31408, 32.68351], [-115.31837, 32.68351], [-115.31837, 32.68714]]], [[[-115.31935, 33.00292], [-115.31505, 33.00292], [-115.31505, 32.99929], [-115.31935, 32.99929], [-115.31935, 33.00292]]], [[[-115.32792, 33.03194], [-115.32354, 33.03192], [-115.32348, 33.02827], [-115.32789, 33.0283], [-115.32792, 33.03194]]], [[[-115.33231, 33.04284], [-115.32801, 33.04283], [-115.32795, 33.03559], [-115.3323, 33.03558], [-115.33231, 33.04284]]], [[[-115.33663, 33.05372], [-115.33232, 33.05373], [-115.33232, 33.0501], [-115.33662, 33.05009], [-115.33663, 33.05372]]], [[[-115.34095, 33.06461], [-115.33664, 33.06461], [-115.33664, 33.06099], [-115.34094, 33.06098], [-115.34095, 33.06461]]], [[[-115.40642, 33.19099], [-115.4064, 33.20551], [-115.38917, 33.2055], [-115.38918, 33.19099], [-115.37195, 33.19099], [-115.37196, 33.17647], [-115.3892, 33.17646], [-115.38919, 33.19099], [-115.40642, 33.19099]]], [[[-115.38925, 33.14749], [-115.38925, 33.15112], [-115.38494, 33.15111], [-115.38494, 33.14749], [-115.38925, 33.14749]]], [[[-115.42373, 33.18374], [-115.42372, 33.18736], [-115.4194, 33.18736], [-115.41941, 33.18373], [-115.42373, 33.18374]]], [[[-115.43237, 33.23453], [-115.42378, 33.2345], [-115.42377, 33.23087], [-115.43236, 33.2309], [-115.43237, 33.23453]]], [[[-115.44095, 33.19829], [-115.44095, 33.20192], [-115.43664, 33.2019], [-115.43664, 33.19828], [-115.44095, 33.19829]]], [[[-115.44526, 33.20917], [-115.44095, 33.20917], [-115.44094, 33.20555], [-115.44526, 33.20555], [-115.44526, 33.20917]]], [[[-115.44535, 33.2491], [-115.44103, 33.2491], [-115.44101, 33.24543], [-115.44533, 33.24544], [-115.44535, 33.2491]]]]} | Open Access 1 | 29569 | United States Bureau of Reclamation | 13858 | 103 | United States Bureau of Reclamation 369 | Federal 1 | Federal Agency 1 | http://www.usbr.gov/ | Other Federal 13 | 103 | United States Bureau of Reclamation 364 | Federal 1 | Federal Agency 1 | Imperial 20 | 27592.029 | United States Bureau of Reclamation | 0 | Federal Other or Unknown 87 | 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]);