units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where AGNCY_LEV = 4 and DES_TP = 1019
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11480 | 11480 | 11479 | {"type": "MultiPolygon", "coordinates": [[[[-122.14069, 37.79837], [-122.14037, 37.79835], [-122.13991, 37.79834], [-122.13961, 37.79836], [-122.13939, 37.79835], [-122.13903, 37.79829], [-122.13886, 37.79815], [-122.13879, 37.79806], [-122.13862, 37.79779], [-122.13837, 37.79753], [-122.13832, 37.79751], [-122.13828, 37.79753], [-122.13816, 37.79765], [-122.138, 37.79788], [-122.13789, 37.79801], [-122.13779, 37.79816], [-122.13759, 37.79839], [-122.13743, 37.79852], [-122.13732, 37.79858], [-122.13715, 37.7986], [-122.13702, 37.79856], [-122.1369, 37.79845], [-122.13682, 37.79827], [-122.13675, 37.79789], [-122.13672, 37.79786], [-122.13664, 37.79782], [-122.13651, 37.79781], [-122.13588, 37.79783], [-122.13556, 37.7978], [-122.13534, 37.79773], [-122.1348, 37.79729], [-122.13471, 37.79727], [-122.13463, 37.79727], [-122.13448, 37.79732], [-122.1342, 37.79734], [-122.13397, 37.79724], [-122.13388, 37.79718], [-122.13355, 37.79692], [-122.1334, 37.79678], [-122.13325, 37.79659], [-122.13317, 37.79652], [-122.13293, 37.7964], [-122.13269, 37.79595], [-122.1326, 37.7959], [-122.13232, 37.79589], [-122.13211, 37.79586], [-122.13199, 37.7958], [-122.13144, 37.79541], [-122.13133, 37.79535], [-122.13127, 37.79535], [-122.13124, 37.7954], [-122.13124, 37.79546], [-122.13126, 37.79553], [-122.13137, 37.79586], [-122.13143, 37.796], [-122.13151, 37.79612], [-122.13178, 37.79635], [-122.132, 37.79665], [-122.1322, 37.79685], [-122.13227, 37.79692], [-122.13247, 37.79704], [-122.13274, 37.79726], [-122.13312, 37.79747], [-122.13351, 37.79772], [-122.13398, 37.79795], [-122.13426, 37.79803], [-122.13512, 37.79819], [-122.13537, 37.79827], [-122.13547, 37.79832], [-122.13554, 37.79839], [-122.13558, 37.79849], [-122.13558, 37.79858], [-122.13555, 37.79866], [-122.13547, 37.79879], [-122.13544, 37.79887], [-122.13543, 37.79896], [-122.13544, 37.79904], [-122.13559, 37.79932], [-122.13565, 37.79953], [-122.13574, 37.80012], [-122.13592, 37.80059], [-122.13596, 37.80091], [-122.13598, 37.80133], [-122.136, 37.80145], [-122.13603, 37.80152], [-122.13614, 37.80164], [-122.13652, 37.80191], [-122.13666, 37.80208], [-122.13676, 37.80225], [-122.1368, 37.80246], [-122.13686, 37.80259], [-122.13696, 37.80266], [-122.13733, 37.80281], [-122.13748, 37.80295], [-122.13757, 37.80312], [-122.13763, 37.80336], [-122.13772, 37.80345], [-122.13796, 37.8036], [-122.1381, 37.8037], [-122.13824, 37.80392], [-122.13838, 37.80424], [-122.13844, 37.80432], [-122.13869, 37.80461], [-122.13874, 37.80475], [-122.11312, 37.80286], [-122.11311, 37.80288], [-122.06152, 37.79909], [-122.06008, 37.79892], [-122.06152, 37.79781], [-122.06152, 37.79322], [-122.07027, 37.79312], [-122.0701, 37.7789], [-122.07889, 37.77897], [-122.07891, 37.77896], [-122.07891, 37.76222], [-122.07739, 37.76222], [-122.07086, 37.7634], [-122.0708, 37.75898], [-122.06231, 37.75064], [-122.0612, 37.74505], [-122.06184, 37.73976], [-122.06104, 37.73876], [-122.0615, 37.73677], [-122.06164, 37.73527], [-122.06277, 37.73329], [-122.06427, 37.72563], [-122.06447, 37.72443], [-122.06456, 37.72317], [-122.06457, 37.72313], [-122.06506, 37.7223], [-122.06534, 37.72128], [-122.0654, 37.72096], [-122.06542, 37.72054], [-122.07284, 37.72081], [-122.07484, 37.72106], [-122.07555, 37.72129], [-122.07574, 37.72145], [-122.07584, 37.72146], [-122.07738, 37.72251], [-122.07826, 37.7232], [-122.07867, 37.72358], [-122.07883, 37.72374], [-122.07892, 37.72389], [-122.07918, 37.72419], [-122.07926, 37.72432], [-122.07945, 37.72458], [-122.07956, 37.72482], [-122.0796, 37.72502], [-122.07961, 37.72522], [-122.07958, 37.72559], [-122.07966, 37.72559], [-122.07954, 37.72646], [-122.07948, 37.72718], [-122.07956, 37.72759], [-122.07979, 37.72803], [-122.08003, 37.72904], [-122.08036, 37.73027], [-122.0805, 37.7309], [-122.08067, 37.73156], [-122.08075, 37.7319], [-122.08086, 37.73283], [-122.081, 37.73344], [-122.08072, 37.73396], [-122.08003, 37.73463], [-122.07935, 37.73515], [-122.07841, 37.73558], [-122.07775, 37.73569], [-122.077, 37.7359], [-122.07617, 37.73679], [-122.07626, 37.73685], [-122.07689, 37.73628], [-122.0771, 37.73612], [-122.07724, 37.73605], [-122.07743, 37.73599], [-122.07786, 37.73593], [-122.07808, 37.73591], [-122.07842, 37.73582], [-122.07859, 37.73574], [-122.07978, 37.73508], [-122.07994, 37.73495], [-122.08018, 37.73471], [-122.08103, 37.73376], [-122.08111, 37.7336], [-122.08116, 37.7334], [-122.08117, 37.73309], [-122.08102, 37.73239], [-122.08088, 37.73158], [-122.08036, 37.72917], [-122.07985, 37.72754], [-122.07978, 37.72704], [-122.07987, 37.72635], [-122.07996, 37.72524], [-122.07995, 37.72503], [-122.0799, 37.72479], [-122.07982, 37.72456], [-122.07967, 37.72432], [-122.07905, 37.72361], [-122.07877, 37.72333], [-122.07854, 37.72312], [-122.07791, 37.72262], [-122.07828, 37.72233], [-122.07877, 37.72271], [-122.07951, 37.72337], [-122.08007, 37.72388], [-122.08061, 37.72423], [-122.08098, 37.72438], [-122.08112, 37.72443], [-122.08131, 37.72463], [-122.08133, 37.72474], [-122.08138, 37.72485], [-122.08146, 37.72518], [-122.08143, 37.72523], [-122.08117, 37.72539], [-122.08106, 37.72544], [-122.08074, 37.72572], [-122.08049, 37.72609], [-122.08038, 37.72722], [-122.08038, 37.72787], [-122.08045, 37.72822], [-122.08051, 37.72841], [-122.08086, 37.72919], [-122.08107, 37.72944], [-122.08127, 37.72972], [-122.08155, 37.72991], [-122.08178, 37.73015], [-122.08189, 37.73044], [-122.08188, 37.73074], [-122.08193, 37.73107], [-122.08191, 37.73144], [-122.08196, 37.73158], [-122.08208, 37.732], [-122.08203, 37.73227], [-122.08193, 37.73241], [-122.08168, 37.73303], [-122.08157, 37.73334], [-122.08165, 37.7335], [-122.08179, 37.73368], [-122.08166, 37.73403], [-122.08157, 37.73462], [-122.08324, 37.7353], [-122.08403, 37.73527], [-122.08462, 37.73544], [-122.08643, 37.73912], [-122.08437, 37.73867], [-122.0824, 37.73835], [-122.08113, 37.7387], [-122.07753, 37.74106], [-122.07728, 37.742], [-122.08014, 37.74531], [-122.09082, 37.75259], [-122.09117, 37.7523], [-122.09252, 37.74859], [-122.09242, 37.74852], [-122.09282, 37.74853], [-122.09294, 37.74859], [-122.09329, 37.7487], [-122.09354, 37.74881], [-122.09367, 37.74888], [-122.09384, 37.74901], [-122.09397, 37.74919], [-122.09412, 37.7496], [-122.09423, 37.74973], [-122.09434, 37.7498], [-122.0945, 37.74985], [-122.09489, 37.7499], [-122.09524, 37.74999], [-122.09547, 37.75011], [-122.09567, 37.75024], [-122.0958, 37.75036], [-122.09592, 37.7505], [-122.09598, 37.75065], [-122.09598, 37.75076], [-122.09588, 37.75117], [-122.0959, 37.75127], [-122.09595, 37.75134], [-122.09601, 37.7514], [-122.09613, 37.75145], [-122.09627, 37.75145], [-122.09697, 37.75142], [-122.09718, 37.75145], [-122.09738, 37.75151], [-122.09767, 37.7517], [-122.09786, 37.75189], [-122.09793, 37.75199], [-122.09797, 37.7521], [-122.09799, 37.7523], [-122.09795, 37.75261], [-122.09795, 37.75273], [-122.09797, 37.75286], [-122.09802, 37.75297], [-122.09808, 37.75305], [-122.09831, 37.75317], [-122.09849, 37.75319], [-122.09875, 37.75325], [-122.09888, 37.75329], [-122.09907, 37.75338], [-122.09965, 37.75379], [-122.09992, 37.75393], [-122.10041, 37.75411], [-122.1006, 37.75415], [-122.10088, 37.75417], [-122.10103, 37.7542], [-122.10117, 37.75427], [-122.10128, 37.75439], [-122.10136, 37.75455], [-122.10142, 37.75474], [-122.10191, 37.75524], [-122.10196, 37.75534], [-122.10199, 37.75551], [-122.10193, 37.75615], [-122.10195, 37.75623], [-122.102, 37.7563], [-122.10225, 37.75646], [-122.10243, 37.75663], [-122.10252, 37.75673], [-122.10258, 37.75682], [-122.10261, 37.75691], [-122.10261, 37.75701], [-122.10251, 37.7575], [-122.1025, 37.75759], [-122.10252, 37.75766], [-122.10268, 37.75788], [-122.10276, 37.75797], [-122.10342, 37.75835], [-122.10382, 37.75853], [-122.10432, 37.75873], [-122.10466, 37.75892], [-122.10481, 37.75903], [-122.10511, 37.75933], [-122.10551, 37.7598], [-122.10592, 37.76014], [-122.106, 37.76025], [-122.10614, 37.76049], [-122.10629, 37.76066], [-122.10668, 37.76107], [-122.10805, 37.76241], [-122.10835, 37.76273], [-122.10844, 37.76285], [-122.10849, 37.76297], [-122.1085, 37.76308], [-122.10845, 37.76337], [-122.10841, 37.76356], [-122.10838, 37.76378], [-122.10837, 37.76407], [-122.10839, 37.76432], [-122.10843, 37.7646], [-122.10847, 37.7647], [-122.10859, 37.76494], [-122.10821, 37.76494], [-122.1082, 37.76495], [-122.10875, 37.76606], [-122.10947, 37.76679], [-122.10953, 37.76759], [-122.10975, 37.76755], [-122.11061, 37.76953], [-122.11146, 37.77032], [-122.1153, 37.77238], [-122.11715, 37.77264], [-122.11861, 37.77323], [-122.12055, 37.77505], [-122.12175, 37.77556], [-122.12398, 37.77716], [-122.12414, 37.77743], [-122.12394, 37.77791], [-122.12367, 37.77871], [-122.12414, 37.78002], [-122.12523, 37.78106], [-122.12561, 37.78246], [-122.12671, 37.78312], [-122.12844, 37.78621], [-122.12875, 37.78782], [-122.12934, 37.78865], [-122.12974, 37.78899], [-122.13084, 37.79034], [-122.13112, 37.79097], [-122.13107, 37.7913], [-122.13081, 37.79112], [-122.13079, 37.79113], [-122.13119, 37.7921], [-122.13256, 37.79298], [-122.133, 37.79445], [-122.13392, 37.79473], [-122.13425, 37.7948], [-122.13515, 37.7957], [-122.13547, 37.79597], [-122.13588, 37.79663], [-122.13633, 37.79691], [-122.13761, 37.79697], [-122.13829, 37.79721], [-122.13873, 37.79722], [-122.13898, 37.79735], [-122.13975, 37.79818], [-122.14069, 37.79837]]], [[[-122.22148, 37.87545], [-122.22138, 37.87533], [-122.21975, 37.8739], [-122.21952, 37.87365], [-122.21853, 37.87276], [-122.21766, 37.87226], [-122.21747, 37.87181], [-122.21738, 37.87172], [-122.21657, 37.86958], [-122.21636, 37.86907], [-122.21691, 37.86879], [-122.21701, 37.86913], [-122.21716, 37.86936], [-122.21757, 37.86976], [-122.21816, 37.87022], [-122.21869, 37.87069], [-122.21874, 37.8708], [-122.21873, 37.87092], [-122.21867, 37.87104], [-122.21848, 37.87128], [-122.21844, 37.87135], [-122.21841, 37.87145], [-122.21843, 37.87154], [-122.21846, 37.87162], [-122.21854, 37.87172], [-122.21917, 37.87238], [-122.21934, 37.87247], [-122.21957, 37.8725], [-122.22023, 37.87238], [-122.22037, 37.87241], [-122.22047, 37.8725], [-122.22054, 37.87262], [-122.2206, 37.87285], [-122.22062, 37.87307], [-122.22061, 37.8735], [-122.22063, 37.87363], [-122.2207, 37.8738], [-122.22078, 37.87393], [-122.2209, 37.87405], [-122.22136, 37.8743], [-122.22143, 37.87436], [-122.22148, 37.87446], [-122.22155, 37.87473], [-122.22168, 37.875], [-122.22169, 37.87512], [-122.22167, 37.87522], [-122.2216, 37.87533], [-122.22148, 37.87545]]], [[[-122.22268, 37.86612], [-122.22268, 37.86626], [-122.22265, 37.86633], [-122.22257, 37.86641], [-122.22247, 37.86644], [-122.22234, 37.86642], [-122.22203, 37.86625], [-122.22181, 37.86618], [-122.22154, 37.86616], [-122.22137, 37.86619], [-122.22124, 37.86624], [-122.22114, 37.86629], [-122.22043, 37.86676], [-122.22027, 37.86689], [-122.22012, 37.86709], [-122.21989, 37.86763], [-122.21978, 37.86776], [-122.21964, 37.86787], [-122.21947, 37.86795], [-122.21932, 37.86799], [-122.21865, 37.86806], [-122.21808, 37.8682], [-122.21979, 37.86733], [-122.22144, 37.86547], [-122.22268, 37.86612]]]]} | Restricted Access 2 | 23060 | EBMUD | 18418 | 2031 | East Bay Municipal Utility District 433 | Special District 4 | Water District 13 | http://www.ebmud.com/ | Special District 4 | 2031 | East Bay Municipal Utility District 427 | Special District 4 | Water District 13 | Alameda 17 | 7314.768 | EBMUD | None 1019 |
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]);