units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where AGNCY_ID = 103, AGNCY_LEV = 1 and MNG_AG_TYP = 3
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14458 | 14458 | 14457 | {"type": "Polygon", "coordinates": [[[-122.52636, 39.31903], [-122.52637, 39.31943], [-122.5251, 39.32296], [-122.52302, 39.32853], [-122.52303, 39.32854], [-122.52363, 39.32846], [-122.52301, 39.33189], [-122.5221, 39.33213], [-122.52146, 39.33351], [-122.52147, 39.33352], [-122.52615, 39.33354], [-122.52618, 39.34106], [-122.52153, 39.34078], [-122.52151, 39.34079], [-122.52166, 39.34795], [-122.52124, 39.35165], [-122.52558, 39.35156], [-122.52505, 39.35517], [-122.51546, 39.35536], [-122.51509, 39.35543], [-122.51507, 39.35551], [-122.51507, 39.35552], [-122.52086, 39.35545], [-122.52011, 39.35957], [-122.51765, 39.35917], [-122.51725, 39.36293], [-122.51262, 39.36292], [-122.51273, 39.36466], [-122.51209, 39.36462], [-122.51208, 39.36463], [-122.51212, 39.36627], [-122.51216, 39.37706], [-122.50724, 39.37681], [-122.49639, 39.37713], [-122.49613, 39.37347], [-122.49333, 39.37343], [-122.49328, 39.36618], [-122.48982, 39.36607], [-122.48974, 39.36264], [-122.4979, 39.36258], [-122.49749, 39.35637], [-122.49597, 39.3563], [-122.49588, 39.35551], [-122.48838, 39.35532], [-122.48843, 39.34826], [-122.48842, 39.33347], [-122.48846, 39.33111], [-122.48844, 39.33083], [-122.48853, 39.31922], [-122.48858, 39.30481], [-122.48873, 39.30475], [-122.4932, 39.30468], [-122.49319, 39.30527], [-122.49324, 39.30836], [-122.49341, 39.31258], [-122.4934, 39.31363], [-122.4944, 39.31557], [-122.49816, 39.31564], [-122.49811, 39.3192], [-122.50313, 39.31914], [-122.52636, 39.31903]]]} | Open Access 1 | 47088 | East Park Reservoir | 30742 | 103 | United States Bureau of Reclamation 369 | Federal 1 | Federal Agency 1 | http://www.usbr.gov/ | Other Federal 13 | 358 | Colusa, County of 1068 | County 3 | County Agency 3 | Colusa 49 | 4263.017 | East Park Reservoir | 0 | Local Recreation Area 3 | 4 | |
16794 | 16794 | 16793 | {"type": "MultiPolygon", "coordinates": [[[[-119.97088, 34.57189], [-119.97081, 34.57555], [-119.96345, 34.57212], [-119.96131, 34.57212], [-119.95957, 34.57273], [-119.95752, 34.57276], [-119.95604, 34.57194], [-119.95586, 34.57186], [-119.95497, 34.571], [-119.95426, 34.57048], [-119.95351, 34.56824], [-119.9528, 34.56792], [-119.95129, 34.5676], [-119.94677, 34.56768], [-119.94599, 34.56766], [-119.94512, 34.56768], [-119.94432, 34.5676], [-119.94367, 34.56748], [-119.94283, 34.5672], [-119.94202, 34.56686], [-119.94125, 34.56645], [-119.94051, 34.56597], [-119.93941, 34.56546], [-119.93902, 34.56479], [-119.937, 34.5638], [-119.93474, 34.56292], [-119.93242, 34.56224], [-119.93187, 34.56236], [-119.92686, 34.56093], [-119.92652, 34.56061], [-119.92132, 34.56097], [-119.9182, 34.55879], [-119.91682, 34.55878], [-119.91612, 34.55828], [-119.91406, 34.55809], [-119.91253, 34.55737], [-119.91134, 34.55487], [-119.91163, 34.55481], [-119.91162, 34.55397], [-119.91133, 34.55395], [-119.91108, 34.55267], [-119.91031, 34.55148], [-119.9185, 34.55565], [-119.92625, 34.5595], [-119.92637, 34.55904], [-119.92651, 34.5586], [-119.9267, 34.55816], [-119.92692, 34.55774], [-119.92718, 34.55735], [-119.92747, 34.55698], [-119.92779, 34.55663], [-119.92946, 34.55451], [-119.96358, 34.56898], [-119.97088, 34.57189]]], [[[-119.99132, 34.59119], [-119.98816, 34.59127], [-119.98659, 34.59205], [-119.98333, 34.59359], [-119.98332, 34.59811], [-119.97942, 34.59803], [-119.97811, 34.60042], [-119.97742, 34.60031], [-119.97691, 34.60042], [-119.97542, 34.60026], [-119.96854, 34.59772], [-119.96456, 34.6004], [-119.95458, 34.60706], [-119.95415, 34.60664], [-119.9519, 34.60453], [-119.95046, 34.60182], [-119.94671, 34.6002], [-119.94116, 34.60658], [-119.93649, 34.60979], [-119.93093, 34.60736], [-119.93417, 34.59869], [-119.9275, 34.59674], [-119.92304, 34.59788], [-119.9188, 34.59933], [-119.91526, 34.60181], [-119.90414, 34.59401], [-119.89889, 34.59025], [-119.89809, 34.58208], [-119.89816, 34.57735], [-119.87591, 34.5662], [-119.86647, 34.54994], [-119.86598, 34.54924], [-119.86526, 34.54889], [-119.86486, 34.54848], [-119.8648, 34.54784], [-119.86433, 34.54732], [-119.86412, 34.54695], [-119.86403, 34.5467], [-119.864, 34.54637], [-119.86427, 34.54579], [-119.86446, 34.54632], [-119.86443, 34.54657], [-119.86507, 34.54753], [-119.86558, 34.54856], [-119.8662, 34.54868], [-119.86746, 34.54549], [-119.87126, 34.54659], [-119.87386, 34.54855], [-119.87472, 34.54891], [-119.87501, 34.54896], [-119.8777, 34.55085], [-119.87901, 34.55108], [-119.8824, 34.5523], [-119.8827, 34.55351], [-119.8848, 34.55303], [-119.8848, 34.55301], [-119.88461, 34.55295], [-119.88446, 34.55287], [-119.88428, 34.55271], [-119.88415, 34.55251], [-119.88409, 34.55236], [-119.88406, 34.5522], [-119.88456, 34.5523], [-119.88556, 34.55215], [-119.88657, 34.54923], [-119.88742, 34.54922], [-119.88963, 34.54808], [-119.89002, 34.54726], [-119.89033, 34.54738], [-119.89185, 34.54716], [-119.89297, 34.54714], [-119.89334, 34.54711], [-119.89472, 34.54741], [-119.89547, 34.54734], [-119.89716, 34.54781], [-119.90053, 34.54832], [-119.89991, 34.54854], [-119.89991, 34.54971], [-119.90159, 34.55183], [-119.90243, 34.55396], [-119.90261, 34.5542], [-119.90322, 34.55452], [-119.90338, 34.55508], [-119.90311, 34.55533], [-119.90227, 34.55555], [-119.90186, 34.55611], [-119.90228, 34.55686], [-119.90294, 34.55702], [-119.90321, 34.55673], [-119.90351, 34.55661], [-119.90601, 34.5578], [-119.90873, 34.55683], [-119.9093, 34.55482], [-119.90979, 34.55299], [-119.9105, 34.55477], [-119.91025, 34.55527], [-119.91082, 34.55585], [-119.91139, 34.55834], [-119.92188, 34.56233], [-119.92257, 34.56229], [-119.92343, 34.56247], [-119.92424, 34.56208], [-119.92568, 34.56212], [-119.92645, 34.56259], [-119.92947, 34.56293], [-119.92941, 34.56307], [-119.93108, 34.56332], [-119.93221, 34.56398], [-119.93378, 34.56418], [-119.93761, 34.56551], [-119.93834, 34.5658], [-119.93881, 34.56634], [-119.93923, 34.56655], [-119.9397, 34.56654], [-119.94062, 34.56691], [-119.94138, 34.56736], [-119.94217, 34.56774], [-119.94299, 34.56806], [-119.94384, 34.56829], [-119.9447, 34.56846], [-119.94557, 34.56855], [-119.94645, 34.56856], [-119.95193, 34.56815], [-119.95271, 34.56913], [-119.95326, 34.57125], [-119.95552, 34.57279], [-119.95769, 34.57362], [-119.96073, 34.57329], [-119.96299, 34.57264], [-119.96638, 34.57395], [-119.96885, 34.57511], [-119.97082, 34.57592], [-119.97291, 34.57654], [-119.97328, 34.57693], [-119.9736, 34.57701], [-119.97388, 34.57674], [-119.97546, 34.57717], [-119.97541, 34.57729], [-119.97542, 34.57731], [-119.97587, 34.57743], [-119.97593, 34.5773], [-119.98107, 34.5787], [-119.98202, 34.58108], [-119.98497, 34.58333], [-119.9867, 34.5857], [-119.98673, 34.58669], [-119.98993, 34.58837], [-119.99126, 34.58835], [-119.99132, 34.59119]], [[-119.96003, 34.57872], [-119.96001, 34.57871], [-119.95999, 34.57874], [-119.96001, 34.57874], [-119.96003, 34.57872]], [[-119.9602, 34.57863], [-119.96019, 34.57861], [-119.96011, 34.57862], [-119.96009, 34.57865], [-119.9602, 34.57863]]]]} | Open Access 1 | 1340 | Cachuma Lake Recreation Area | 13798 | 103 | United States Bureau of Reclamation 369 | Federal 1 | Federal Agency 1 | http://www.usbr.gov/ | Other Federal 13 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 9563.006 | Cachuma Lake Rec. Area | 0 | Local Recreation Area 3 | 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]);