units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, AGNCY_NAME = 328 and DES_TP = 4
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7476 | 7476 | 7475 | {"type": "MultiPolygon", "coordinates": [[[[-117.94363, 34.16523], [-117.94362, 34.16688], [-117.94228, 34.16689], [-117.94231, 34.16524], [-117.94363, 34.16523]]], [[[-117.95964, 34.15204], [-117.95956, 34.16516], [-117.94833, 34.16521], [-117.94805, 34.16498], [-117.94792, 34.16489], [-117.94772, 34.1648], [-117.94726, 34.16467], [-117.94692, 34.16467], [-117.94675, 34.16478], [-117.94654, 34.16501], [-117.94644, 34.16506], [-117.94544, 34.16233], [-117.94546, 34.16215], [-117.94543, 34.16206], [-117.94532, 34.16184], [-117.94532, 34.16179], [-117.94533, 34.16172], [-117.94544, 34.16156], [-117.9455, 34.16142], [-117.94551, 34.1612], [-117.94553, 34.16114], [-117.94559, 34.1611], [-117.94582, 34.16102], [-117.94619, 34.16084], [-117.94636, 34.16083], [-117.94642, 34.16078], [-117.94642, 34.16074], [-117.94638, 34.1607], [-117.94631, 34.16069], [-117.94608, 34.16079], [-117.94588, 34.16082], [-117.94589, 34.16084], [-117.94605, 34.16083], [-117.94617, 34.16079], [-117.94631, 34.16072], [-117.94636, 34.16072], [-117.94638, 34.16074], [-117.94638, 34.16078], [-117.94636, 34.1608], [-117.94618, 34.16081], [-117.94581, 34.16099], [-117.94558, 34.16107], [-117.9455, 34.16114], [-117.94548, 34.16119], [-117.94547, 34.16141], [-117.94539, 34.16157], [-117.94529, 34.16175], [-117.94529, 34.16184], [-117.94541, 34.1621], [-117.94542, 34.1622], [-117.94541, 34.16228], [-117.94463, 34.16017], [-117.94484, 34.16022], [-117.94504, 34.16032], [-117.9452, 34.16044], [-117.94536, 34.16064], [-117.94565, 34.1608], [-117.94581, 34.16085], [-117.94585, 34.16085], [-117.94587, 34.16083], [-117.94565, 34.16078], [-117.94538, 34.16062], [-117.94517, 34.16038], [-117.94501, 34.16026], [-117.94485, 34.16019], [-117.94462, 34.16014], [-117.94463, 34.158], [-117.94337, 34.158], [-117.94337, 34.15433], [-117.9448, 34.1543], [-117.94486, 34.15417], [-117.94479, 34.15399], [-117.9449, 34.15381], [-117.94518, 34.15366], [-117.94523, 34.15358], [-117.94526, 34.15346], [-117.94539, 34.15328], [-117.94544, 34.15331], [-117.94533, 34.15348], [-117.9453, 34.15359], [-117.94552, 34.15362], [-117.94623, 34.15382], [-117.9466, 34.15353], [-117.94709, 34.15363], [-117.94718, 34.15358], [-117.94725, 34.15364], [-117.9473, 34.15373], [-117.94738, 34.1537], [-117.94742, 34.1538], [-117.94745, 34.15391], [-117.94745, 34.15406], [-117.9474, 34.15423], [-117.9474, 34.15426], [-117.94871, 34.15425], [-117.94858, 34.15372], [-117.94928, 34.15361], [-117.94944, 34.15425], [-117.95101, 34.15423], [-117.95102, 34.15421], [-117.9511, 34.1542], [-117.95113, 34.1545], [-117.95133, 34.15518], [-117.95172, 34.15573], [-117.95288, 34.15541], [-117.95278, 34.15515], [-117.95283, 34.15511], [-117.95411, 34.15621], [-117.95439, 34.15601], [-117.95436, 34.15612], [-117.95496, 34.15628], [-117.95873, 34.1538], [-117.95932, 34.15232], [-117.95939, 34.152], [-117.95964, 34.15204]], [[-117.95364, 34.1575], [-117.95401, 34.15753], [-117.95406, 34.15723], [-117.95387, 34.15708], [-117.95359, 34.15719], [-117.95364, 34.1575]]], [[[-117.94829, 34.16521], [-117.94651, 34.16522], [-117.94645, 34.16508], [-117.94656, 34.16504], [-117.94678, 34.1648], [-117.94693, 34.1647], [-117.94726, 34.1647], [-117.94751, 34.16476], [-117.94789, 34.16491], [-117.94829, 34.16521]]]]} | Open Access 1 | 6988 | Duarte Wilderness Preserve | 3162 | 1089 | Duarte, City of 328 | City 2 | City Agency 2 | http://www.accessduarte.com/index.php?option=com_content&view=article&id=62&Itemid=72 | City 2 | 1089 | Duarte, City of 325 | City 2 | City Agency 2 | Los Angeles 6 | 405.48 | Duarte Wilderness Preserve | 0 | Local Conservation Area 4 | 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]);