units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
6 rows where ACCESS_TYP = 2, AGNCY_NAME = 146, AGNCY_TYP = 1 and MNG_AGENCY = 142
This data as json, copyable, CSV (advanced)
Suggested facets: GAP_STS
DES_TP 3
MNG_AG_TYP 1
MNG_AGENCY 1
- United States Army Corps of Engineers · 6 ✖
ACCESS_TYP 1
- Restricted Access · 6 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
356 | 356 | 355 | {"type": "Polygon", "coordinates": [[[-122.49396, 38.11519], [-122.49396, 38.11668], [-122.49389, 38.11699], [-122.49376, 38.11735], [-122.49339, 38.11788], [-122.49311, 38.11825], [-122.49275, 38.11856], [-122.49241, 38.1189], [-122.49231, 38.1192], [-122.49228, 38.11936], [-122.49071, 38.12038], [-122.48879, 38.12141], [-122.48651, 38.12238], [-122.47257, 38.12807], [-122.47183, 38.12772], [-122.48389, 38.1232], [-122.49205, 38.11836], [-122.49375, 38.11703], [-122.49245, 38.11561], [-122.4906, 38.11561], [-122.49396, 38.11519]]]} | Restricted Access 2 | 982 | Sonoma Baylands | 25608 | 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 | Sonoma 16 | 37.517 | Sonoma Baylands | None 36 | |||
1526 | 1526 | 1525 | {"type": "Polygon", "coordinates": [[[-118.50099, 34.17906], [-118.49854, 34.17803], [-118.49442, 34.17649], [-118.48937, 34.17455], [-118.47912, 34.17066], [-118.48, 34.17022], [-118.48079, 34.16993], [-118.48155, 34.16969], [-118.48232, 34.16949], [-118.48336, 34.16927], [-118.48464, 34.16886], [-118.48587, 34.16861], [-118.48659, 34.16843], [-118.48732, 34.16823], [-118.48784, 34.16822], [-118.48841, 34.16791], [-118.48987, 34.16748], [-118.49042, 34.16735], [-118.49087, 34.16727], [-118.49143, 34.16721], [-118.492, 34.1672], [-118.49256, 34.16722], [-118.49313, 34.16728], [-118.49369, 34.16739], [-118.49412, 34.1675], [-118.49465, 34.16768], [-118.49526, 34.16794], [-118.49583, 34.16825], [-118.49636, 34.16861], [-118.49669, 34.16888], [-118.49692, 34.16909], [-118.49738, 34.16963], [-118.49767, 34.1701], [-118.49815, 34.17079], [-118.49842, 34.17144], [-118.49856, 34.17168], [-118.49871, 34.17186], [-118.49887, 34.17201], [-118.49905, 34.17213], [-118.49927, 34.17223], [-118.49953, 34.17249], [-118.50001, 34.17249], [-118.50089, 34.17236], [-118.50092, 34.17238], [-118.50093, 34.17592], [-118.50098, 34.17593], [-118.50099, 34.17906]]]} | Restricted Access 2 | 12883 | Balboa Golf Course & Encino Golf Course | 33032 | 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 | 320.852 | Balboa GC & Encino GC | 0 | Recreation Management Area 49 | 4 | |
4884 | 4884 | 4883 | {"type": "MultiPolygon", "coordinates": [[[[-118.08173, 34.04994], [-118.0805, 34.04993], [-118.07751, 34.04834], [-118.07751, 34.04837], [-118.08049, 34.04996], [-118.08013, 34.04996], [-118.08012, 34.04997], [-118.08074, 34.05031], [-118.08073, 34.05157], [-118.07969, 34.05156], [-118.07753, 34.05168], [-118.07752, 34.05165], [-118.07733, 34.05166], [-118.07732, 34.05169], [-118.07317, 34.05171], [-118.07316, 34.05168], [-118.07307, 34.05168], [-118.07312, 34.04139], [-118.07467, 34.04125], [-118.07526, 34.04117], [-118.07525, 34.04275], [-118.07528, 34.04276], [-118.07529, 34.04116], [-118.07647, 34.04099], [-118.07643, 34.0414], [-118.07572, 34.04156], [-118.07534, 34.04238], [-118.07559, 34.04268], [-118.0763, 34.04268], [-118.07649, 34.04247], [-118.07747, 34.04247], [-118.07748, 34.04209], [-118.07802, 34.04182], [-118.07839, 34.04182], [-118.0791, 34.04225], [-118.07943, 34.04272], [-118.07964, 34.04272], [-118.07965, 34.04362], [-118.08009, 34.04362], [-118.0801, 34.04407], [-118.08087, 34.04407], [-118.08088, 34.04451], [-118.08114, 34.04452], [-118.08114, 34.04512], [-118.0817, 34.04512], [-118.08173, 34.04994]], [[-118.07717, 34.04812], [-118.07728, 34.04818], [-118.0773, 34.04818], [-118.07729, 34.04815], [-118.07602, 34.04748], [-118.07556, 34.04718], [-118.07541, 34.04706], [-118.07513, 34.04677], [-118.07499, 34.04658], [-118.07485, 34.04634], [-118.07471, 34.04603], [-118.07464, 34.04577], [-118.07528, 34.04458], [-118.07528, 34.04449], [-118.07525, 34.04449], [-118.07524, 34.04457], [-118.07434, 34.04628], [-118.07421, 34.04779], [-118.07318, 34.04991], [-118.07318, 34.04997], [-118.0732, 34.04997], [-118.07425, 34.0478], [-118.07437, 34.04628], [-118.07462, 34.04582], [-118.07468, 34.04603], [-118.07475, 34.04621], [-118.0749, 34.0465], [-118.07504, 34.0467], [-118.07538, 34.04707], [-118.07565, 34.04729], [-118.07595, 34.04747], [-118.07717, 34.04812]]], [[[-118.08027, 34.05174], [-118.08023, 34.05182], [-118.07834, 34.05181], [-118.07833, 34.05424], [-118.07813, 34.05438], [-118.07758, 34.05533], [-118.07756, 34.05534], [-118.07753, 34.05542], [-118.07671, 34.05543], [-118.07671, 34.05634], [-118.07648, 34.05719], [-118.0757, 34.05687], [-118.07535, 34.05699], [-118.07486, 34.05751], [-118.07467, 34.05792], [-118.07424, 34.05812], [-118.07362, 34.05794], [-118.07302, 34.05794], [-118.07301, 34.05872], [-118.0719, 34.05755], [-118.07222, 34.05543], [-118.073, 34.05542], [-118.07299, 34.0519], [-118.07318, 34.0519], [-118.07318, 34.05187], [-118.07743, 34.05185], [-118.07965, 34.05174], [-118.08027, 34.05174]]]]} | Restricted Access 2 | 6566 | Whittier Narrows Golf Course | 33010 | 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 | 268.099 | Whittier Narrows GC | 0 | Recreation Management Area 49 | 4 | |
7058 | 7058 | 7057 | {"type": "Polygon", "coordinates": [[[-118.06181, 34.02017], [-118.06089, 34.02054], [-118.06107, 34.02082], [-118.06117, 34.02082], [-118.06121, 34.02141], [-118.05671, 34.02154], [-118.0577, 34.02122], [-118.05703, 34.01992], [-118.05747, 34.01907], [-118.05897, 34.01802], [-118.06078, 34.01739], [-118.06033, 34.01796], [-118.05961, 34.01857], [-118.0607, 34.02026], [-118.06181, 34.02017]]]} | Restricted Access 2 | 6569 | Pico Rivera Golf Course | 33017 | 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 | 26.31 | Pico Rivera GC | 0 | Recreation Management Area 49 | 4 | |
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 | |
11308 | 11308 | 11307 | {"type": "Polygon", "coordinates": [[[-118.49251, 34.18069], [-118.49246, 34.18527], [-118.49127, 34.18528], [-118.49121, 34.18458], [-118.48812, 34.18462], [-118.4881, 34.18393], [-118.48647, 34.18422], [-118.48458, 34.18493], [-118.48387, 34.18494], [-118.48387, 34.18402], [-118.48384, 34.18401], [-118.48384, 34.1836], [-118.48386, 34.18359], [-118.48386, 34.18109], [-118.48382, 34.18108], [-118.48361, 34.18069], [-118.48363, 34.18068], [-118.48359, 34.17867], [-118.48342, 34.17774], [-118.48337, 34.17516], [-118.48345, 34.17515], [-118.48342, 34.17341], [-118.4925, 34.17711], [-118.49249, 34.18067], [-118.49251, 34.18069]]]} | Restricted Access 2 | 22012 | Woodley Lakes Golf Course | 33077 | 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 | 209.251 | Woodley Lakes GC | 0 | Recreation Management Area 49 | 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]);