units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 2, AGNCY_ID = 100 and DES_TP = 82
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
DES_TP 1
- Resource Management Area · 1 ✖
ACCESS_TYP 1
- Restricted Access · 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7289 | 7289 | 7288 | {"type": "MultiPolygon", "coordinates": [[[[-118.06004, 34.01551], [-118.05873, 34.0164], [-118.05805, 34.01692], [-118.0576, 34.0173], [-118.05827, 34.01767], [-118.05897, 34.01802], [-118.05747, 34.01907], [-118.05703, 34.01992], [-118.05593, 34.02051], [-118.0549, 34.02084], [-118.05395, 34.02158], [-118.05387, 34.02199], [-118.05295, 34.02135], [-118.05295, 34.02132], [-118.05137, 34.02026], [-118.05138, 34.02024], [-118.05053, 34.01967], [-118.0522, 34.01846], [-118.05317, 34.01829], [-118.05338, 34.01842], [-118.054, 34.01837], [-118.05434, 34.01784], [-118.0559, 34.01773], [-118.0575, 34.01641], [-118.05641, 34.01534], [-118.05752, 34.01455], [-118.05859, 34.01559], [-118.05927, 34.01514], [-118.06004, 34.01551]]], [[[-118.07861, 34.01711], [-118.07843, 34.01748], [-118.07832, 34.01765], [-118.07816, 34.01788], [-118.07791, 34.01819], [-118.07766, 34.01848], [-118.07744, 34.01869], [-118.0769, 34.01914], [-118.07637, 34.01948], [-118.07315, 34.02126], [-118.07286, 34.02143], [-118.07234, 34.02179], [-118.07178, 34.02229], [-118.0715, 34.02259], [-118.07118, 34.023], [-118.07101, 34.02324], [-118.06794, 34.02829], [-118.06785, 34.02831], [-118.06734, 34.02812], [-118.06696, 34.02802], [-118.06645, 34.02795], [-118.05777, 34.02462], [-118.05458, 34.02336], [-118.05406, 34.02414], [-118.0539, 34.02251], [-118.05402, 34.02209], [-118.05438, 34.02235], [-118.05503, 34.02278], [-118.05571, 34.02199], [-118.05622, 34.0217], [-118.05671, 34.02154], [-118.0612, 34.02141], [-118.06117, 34.02082], [-118.06902, 34.02046], [-118.06905, 34.02101], [-118.07253, 34.02084], [-118.07409, 34.02003], [-118.07431, 34.02006], [-118.07583, 34.01928], [-118.07629, 34.01901], [-118.07663, 34.01877], [-118.07688, 34.01858], [-118.07712, 34.01838], [-118.07748, 34.01803], [-118.0779, 34.01751], [-118.07825, 34.01698], [-118.07858, 34.01705], [-118.07861, 34.01711]]], [[[-118.061, 34.01708], [-118.06078, 34.01739], [-118.06049, 34.01666], [-118.06078, 34.01689], [-118.061, 34.01708]]], [[[-118.08765, 34.02294], [-118.08759, 34.02301], [-118.08732, 34.02322], [-118.08691, 34.02347], [-118.086, 34.02381], [-118.08518, 34.02419], [-118.08318, 34.02537], [-118.08275, 34.02555], [-118.08236, 34.02565], [-118.08211, 34.02568], [-118.08176, 34.02568], [-118.08063, 34.02561], [-118.07954, 34.02604], [-118.07683, 34.02666], [-118.0758, 34.02683], [-118.07506, 34.02709], [-118.07491, 34.02727], [-118.07484, 34.02752], [-118.07463, 34.02807], [-118.07407, 34.02903], [-118.07397, 34.02927], [-118.07388, 34.02937], [-118.07209, 34.02923], [-118.07201, 34.02963], [-118.07129, 34.02955], [-118.07151, 34.02914], [-118.07279, 34.02772], [-118.07565, 34.0256], [-118.07771, 34.02455], [-118.07809, 34.02411], [-118.07806, 34.02411], [-118.07769, 34.02454], [-118.07562, 34.02558], [-118.07277, 34.0277], [-118.07148, 34.02913], [-118.07125, 34.02954], [-118.07048, 34.02946], [-118.06906, 34.02892], [-118.06911, 34.02881], [-118.06831, 34.0285], [-118.06828, 34.02844], [-118.07138, 34.02337], [-118.07188, 34.02273], [-118.07241, 34.02222], [-118.07283, 34.02189], [-118.07328, 34.02159], [-118.07651, 34.0198], [-118.0769, 34.01956], [-118.07735, 34.01924], [-118.07785, 34.0188], [-118.07822, 34.0184], [-118.07842, 34.01815], [-118.07872, 34.01772], [-118.07888, 34.01744], [-118.07908, 34.01704], [-118.08031, 34.01676], [-118.07951, 34.017], [-118.07938, 34.01705], [-118.07918, 34.01749], [-118.07892, 34.01793], [-118.07893, 34.01794], [-118.07958, 34.01783], [-118.08009, 34.01779], [-118.08078, 34.0178], [-118.08127, 34.01786], [-118.08179, 34.01797], [-118.08204, 34.01804], [-118.08267, 34.01828], [-118.08318, 34.01854], [-118.08365, 34.01886], [-118.08493, 34.01795], [-118.08599, 34.019], [-118.08475, 34.01988], [-118.08504, 34.0202], [-118.08531, 34.02055], [-118.08551, 34.02088], [-118.08549, 34.0209], [-118.08553, 34.02092], [-118.08567, 34.02118], [-118.08582, 34.02151], [-118.08594, 34.02187], [-118.08602, 34.02218], [-118.08572, 34.02214], [-118.0858, 34.02267], [-118.08609, 34.02274], [-118.08612, 34.02311], [-118.08728, 34.02311], [-118.08744, 34.02298], [-118.08754, 34.02288], [-118.08765, 34.02294]]], [[[-118.07973, 34.01611], [-118.07954, 34.01674], [-118.07924, 34.01681], [-118.07921, 34.0168], [-118.0792, 34.01676], [-118.07931, 34.01638], [-118.07934, 34.01637], [-118.07936, 34.01633], [-118.07933, 34.01631], [-118.07936, 34.01624], [-118.07946, 34.01618], [-118.07973, 34.01611]]], [[[-118.08786, 34.02308], [-118.08756, 34.02334], [-118.08718, 34.02359], [-118.08683, 34.02375], [-118.08612, 34.02401], [-118.08548, 34.02438], [-118.08553, 34.02444], [-118.08495, 34.02492], [-118.0853, 34.02531], [-118.08535, 34.02563], [-118.08466, 34.02594], [-118.08411, 34.02502], [-118.08516, 34.0244], [-118.08556, 34.02419], [-118.08598, 34.02401], [-118.08684, 34.02369], [-118.08711, 34.02357], [-118.08748, 34.02334], [-118.08781, 34.02305], [-118.08786, 34.02308]]]]} | Restricted Access 2 | 6568 | Whittier Narrows Dam | 27479 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | Los Angeles 6 | 568.969 | Whittier Narrows Dam | 0 | Resource Management Area 82 | 3 |
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]);