units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where AGNCY_LEV = 3, AGNCY_WEB = "http://sfwater.org/", DES_TP = 9 and MNG_AGENCY = 30
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
- San Francisco - Public Utilities Commission, City and County of · 1 ✖
DES_TP 1
- - · 1 ✖
ACCESS_TYP 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 63 | 63 | 62 | {"type": "MultiPolygon", "coordinates": [[[[-122.35186, 37.50815], [-122.35183, 37.50859], [-122.35042, 37.50998], [-122.35022, 37.51078], [-122.35002, 37.51099], [-122.34927, 37.5111], [-122.34878, 37.51124], [-122.34832, 37.51117], [-122.34844, 37.51053], [-122.34804, 37.50998], [-122.34755, 37.50975], [-122.3468, 37.50957], [-122.34674, 37.50854], [-122.3464, 37.50813], [-122.3464, 37.50737], [-122.34551, 37.50669], [-122.3447, 37.50623], [-122.34384, 37.50552], [-122.34335, 37.50533], [-122.34243, 37.50522], [-122.34186, 37.5049], [-122.34185, 37.50448], [-122.34157, 37.50432], [-122.34088, 37.50414], [-122.33922, 37.5033], [-122.33821, 37.50359], [-122.33715, 37.50366], [-122.33712, 37.50336], [-122.33723, 37.50291], [-122.33778, 37.50293], [-122.33812, 37.50288], [-122.3381, 37.50149], [-122.33783, 37.50116], [-122.337, 37.50107], [-122.3362, 37.50084], [-122.33591, 37.50041], [-122.33574, 37.49993], [-122.3353, 37.49929], [-122.33473, 37.49911], [-122.33381, 37.49895], [-122.33263, 37.49835], [-122.33168, 37.4981], [-122.33079, 37.49833], [-122.32941, 37.49851], [-122.32913, 37.49767], [-122.33042, 37.49744], [-122.33108, 37.49689], [-122.33085, 37.49634], [-122.33068, 37.49577], [-122.33036, 37.49533], [-122.33039, 37.49418], [-122.33013, 37.49398], [-122.32974, 37.49393], [-122.32939, 37.49409], [-122.3287, 37.49418], [-122.32807, 37.49409], [-122.32778, 37.49386], [-122.32715, 37.49212], [-122.32686, 37.49185], [-122.32603, 37.49185], [-122.32568, 37.49125], [-122.32517, 37.49066], [-122.32517, 37.49038], [-122.32563, 37.49015], [-122.32658, 37.48999], [-122.3268, 37.48976], [-122.32683, 37.48922], [-122.3258, 37.48855], [-122.32511, 37.48779], [-122.32468, 37.48748], [-122.32428, 37.4875], [-122.32402, 37.48786], [-122.32299, 37.48713], [-122.32238, 37.48679], [-122.32103, 37.48665], [-122.32118, 37.48587], [-122.32077, 37.48546], [-122.32077, 37.48521], [-122.32092, 37.48495], [-122.32098, 37.48443], [-122.32135, 37.48411], [-122.32164, 37.48365], [-122.32172, 37.48319], [-122.32195, 37.48294], [-122.32198, 37.48267], [-122.32173, 37.48232], [-122.32236, 37.48218], [-122.32273, 37.48246], [-122.32379, 37.48246], [-122.3244, 37.48267], [-122.32454, 37.48308], [-122.32503, 37.48363], [-122.32569, 37.48383], [-122.32661, 37.48361], [-122.32707, 37.48365], [-122.3275, 37.48381], [-122.32847, 37.48468], [-122.32959, 37.48478], [-122.33003, 37.48496], [-122.3304, 37.48523], [-122.33071, 37.48514], [-122.33072, 37.48462], [-122.33115, 37.48457], [-122.33158, 37.48487], [-122.33172, 37.48528], [-122.33158, 37.48562], [-122.33132, 37.48585], [-122.33097, 37.48585], [-122.33011, 37.48562], [-122.32954, 37.48537], [-122.32917, 37.48544], [-122.32925, 37.48574], [-122.32951, 37.48604], [-122.33043, 37.48658], [-122.33094, 37.487], [-122.33169, 37.48798], [-122.33364, 37.48943], [-122.33508, 37.48931], [-122.33528, 37.48787], [-122.33643, 37.4878], [-122.33752, 37.4881], [-122.33795, 37.48849], [-122.33801, 37.48984], [-122.33815, 37.49009], [-122.33827, 37.49092], [-122.33867, 37.49121], [-122.34028, 37.49181], [-122.34019, 37.49238], [-122.33919, 37.49295], [-122.33821, 37.49326], [-122.33809, 37.49435], [-122.33875, 37.49508], [-122.33898, 37.4957], [-122.33985, 37.4965], [-122.34249, 37.49836], [-122.34292, 37.49879], [-122.34292, 37.49941], [-122.34341, 37.49993], [-122.34364, 37.50014], [-122.34456, 37.5003], [-122.34557, 37.50021], [-122.34591, 37.50037], [-122.34634, 37.50098], [-122.34669, 37.50126], [-122.34749, 37.50169], [-122.34827, 37.50188], [-122.34861, 37.50206], [-122.34962, 37.50206], [-122.34988, 37.50222], [-122.35057, 37.50238], [-122.34933, 37.50314], [-122.3489, 37.50325], [-122.34856, 37.50366], [-122.34856, 37.50409], [-122.34942, 37.50415], [-122.34959, 37.50451], [-122.34939, 37.50474], [-122.34922, 37.50526], [-122.34924, 37.50558], [-122.3497, 37.50593], [-122.34979, 37.50622], [-122.35108, 37.50595], [-122.3514, 37.506], [-122.35143, 37.50685], [-122.35143, 37.50744], [-122.35186, 37.50815]]], [[[-122.39158, 37.55481], [-122.39144, 37.55538], [-122.39124, 37.55602], [-122.39144, 37.55641], [-122.39144, 37.55669], [-122.39104, 37.55657], [-122.39069, 37.5563], [-122.39032, 37.55575], [-122.38986, 37.5555], [-122.38963, 37.55527], [-122.38931, 37.55454], [-122.38782, 37.55335], [-122.38762, 37.55261], [-122.38696, 37.55163], [-122.38621, 37.55124], [-122.38641, 37.55058], [-122.38627, 37.55033], [-122.38532, 37.54975], [-122.38442, 37.54826], [-122.38325, 37.54707], [-122.38258, 37.54691], [-122.38235, 37.54643], [-122.38212, 37.5462], [-122.38103, 37.54568], [-122.38066, 37.54508], [-122.38014, 37.54474], [-122.37968, 37.54462], [-122.37951, 37.54398], [-122.37902, 37.54352], [-122.3789, 37.54311], [-122.37781, 37.54227], [-122.37761, 37.54197], [-122.37706, 37.54169], [-122.37697, 37.5414], [-122.37672, 37.54119], [-122.3766, 37.54069], [-122.37623, 37.54034], [-122.3758, 37.54009], [-122.37562, 37.53966], [-122.37522, 37.53934], [-122.37462, 37.53933], [-122.37468, 37.53883], [-122.3745, 37.53835], [-122.37471, 37.53812], [-122.37476, 37.53783], [-122.37436, 37.53737], [-122.37301, 37.53776], [-122.37275, 37.53805], [-122.3724, 37.53796], [-122.37203, 37.53773], [-122.37301, 37.53679], [-122.37358, 37.53668], [-122.37381, 37.5363], [-122.37338, 37.53625], [-122.37232, 37.53638], [-122.37229, 37.53606], [-122.37311, 37.53585], [-122.37243, 37.5354], [-122.3724, 37.53478], [-122.37212, 37.53439], [-122.37166, 37.53402], [-122.37039, 37.53418], [-122.36985, 37.53418], [-122.36944, 37.53382], [-122.36896, 37.53359], [-122.36847, 37.53354], [-122.36784, 37.53373], [-122.36755, 37.53359], [-122.36763, 37.53252], [-122.36691, 37.53212], [-122.36677, 37.53132], [-122.36651, 37.531], [-122.36571, 37.53052], [-122.36427, 37.52999], [-122.36306, 37.52942], [-122.36298, 37.52896], [-122.36266, 37.52842], [-122.36214, 37.52798], [-122.36191, 37.52761], [-122.36191, 37.52725], [-122.36211, 37.52677], [-122.36177, 37.52635], [-122.362, 37.52551], [-122.36191, 37.52505], [-122.36154, 37.52468], [-122.36137, 37.52439], [-122.36105, 37.52416], [-122.36019, 37.52397], [-122.36082, 37.52343], [-122.36088, 37.52305], [-122.36028, 37.52244], [-122.35973, 37.52239], [-122.35947, 37.52221], [-122.35956, 37.5215], [-122.3591, 37.52116], [-122.35838, 37.52122], [-122.35881, 37.52054], [-122.35812, 37.52001], [-122.35749, 37.51932], [-122.35697, 37.51777], [-122.35668, 37.51722], [-122.35694, 37.51685], [-122.35646, 37.51651], [-122.35645, 37.51619], [-122.35677, 37.5161], [-122.35737, 37.5161], [-122.35754, 37.51578], [-122.35528, 37.51493], [-122.35444, 37.51429], [-122.35384, 37.51403], [-122.35375, 37.51378], [-122.35292, 37.51339], [-122.35197, 37.51323], [-122.35111, 37.51248], [-122.35102, 37.51223], [-122.35217, 37.51177], [-122.35283, 37.51195], [-122.35329, 37.51192], [-122.35329, 37.51168], [-122.35258, 37.51131], [-122.35163, 37.51065], [-122.35171, 37.51017], [-122.35252, 37.50914], [-122.35301, 37.50888], [-122.35355, 37.50831], [-122.35398, 37.50829], [-122.35427, 37.50863], [-122.35398, 37.5093], [-122.35365, 37.50967], [-122.35447, 37.51044], [-122.3549, 37.51117], [-122.35631, 37.51227], [-122.3566, 37.51271], [-122.35694, 37.5128], [-122.3574, 37.5128], [-122.35864, 37.51214], [-122.35919, 37.51147], [-122.35936, 37.51081], [-122.3597, 37.51063], [-122.36008, 37.51097], [-122.36011, 37.51147], [-122.36022, 37.51172], [-122.36054, 37.512], [-122.35982, 37.51282], [-122.35985, 37.51312], [-122.36022, 37.51321], [-122.36048, 37.51344], [-122.36048, 37.51374], [-122.36068, 37.51411], [-122.36151, 37.51447], [-122.36194, 37.51479], [-122.36085, 37.51491], [-122.36091, 37.51539], [-122.36123, 37.51578], [-122.36123, 37.51623], [-122.36128, 37.51649], [-122.36166, 37.51692], [-122.36209, 37.51708], [-122.36301, 37.51708], [-122.36318, 37.51738], [-122.36307, 37.51763], [-122.36364, 37.51768], [-122.36429, 37.51833], [-122.3627, 37.51816], [-122.36255, 37.5185], [-122.3639, 37.51912], [-122.36464, 37.51967], [-122.36539, 37.52006], [-122.36637, 37.52036], [-122.36792, 37.52145], [-122.36631, 37.52132], [-122.36597, 37.52146], [-122.36588, 37.52189], [-122.36637, 37.52272], [-122.36677, 37.52361], [-122.36689, 37.52422], [-122.36597, 37.52391], [-122.36554, 37.52391], [-122.36542, 37.5247], [-122.36597, 37.52496], [-122.36732, 37.52601], [-122.36775, 37.52668], [-122.36881, 37.52761], [-122.36901, 37.52812], [-122.36967, 37.52869], [-122.37005, 37.52878], [-122.37125, 37.52867], [-122.37157, 37.52855], [-122.37174, 37.52828], [-122.37174, 37.52777], [-122.37278, 37.5275], [-122.37304, 37.52819], [-122.3735, 37.52858], [-122.37407, 37.52892], [-122.37499, 37.52917], [-122.37502, 37.52942], [-122.37492, 37.52975], [-122.37738, 37.53043], [-122.37862, 37.53096], [-122.3793, 37.53103], [-122.37997, 37.53141], [-122.38112, 37.53187], [-122.38143, 37.53217], [-122.38218, 37.53233], [-122.38253, 37.53293], [-122.38431, 37.53331], [-122.3852, 37.53361], [-122.38592, 37.53359], [-122.38589, 37.53464], [-122.38534, 37.53421], [-122.385, 37.534], [-122.38451, 37.53398], [-122.38416, 37.5338], [-122.38353, 37.53377], [-122.38307, 37.53364], [-122.38172, 37.53359], [-122.38111, 37.53304], [-122.38011, 37.53288], [-122.37939, 37.53265], [-122.37913, 37.53281], [-122.37882, 37.53283], [-122.37721, 37.53228], [-122.37686, 37.53213], [-122.37643, 37.5316], [-122.37609, 37.53146], [-122.37574, 37.53141], [-122.37542, 37.53118], [-122.37468, 37.53116], [-122.37419, 37.5308], [-122.37378, 37.53084], [-122.37341, 37.53139], [-122.37332, 37.5318], [-122.37309, 37.53199], [-122.37252, 37.53229], [-122.37252, 37.53263], [-122.37269, 37.53299], [-122.37399, 37.53306], [-122.37433, 37.53325], [-122.37473, 37.53384], [-122.37488, 37.53427], [-122.37525, 37.53473], [-122.37583, 37.53515], [-122.37609, 37.53565], [-122.37652, 37.53592], [-122.37669, 37.53656], [-122.37721, 37.5372], [-122.37758, 37.53746], [-122.37824, 37.53771], [-122.37824, 37.53801], [-122.37802, 37.53833], [-122.37842, 37.53851], [-122.37907, 37.53842], [-122.37959, 37.53819], [-122.37991, 37.53821], [-122.37985, 37.53869], [-122.37945, 37.53888], [-122.37939, 37.53957], [-122.37971, 37.54101], [-122.38, 37.54119], [-122.3808, 37.5414], [-122.38029, 37.54195], [-122.38074, 37.54263], [-122.38092, 37.54295], [-122.38146, 37.54341], [-122.38276, 37.54396], [-122.38273, 37.54447], [-122.38402, 37.54483], [-122.38439, 37.54533], [-122.38474, 37.54549], [-122.38549, 37.54554], [-122.38569, 37.54597], [-122.38526, 37.54618], [-122.38517, 37.54648], [-122.38577, 37.54744], [-122.38707, 37.54859], [-122.38724, 37.54904], [-122.38833, 37.5503], [-122.3888, 37.55117], [-122.38948, 37.5517], [-122.3892, 37.55209], [-122.38926, 37.55243], [-122.39012, 37.5527], [-122.39058, 37.55316], [-122.39089, 37.55401], [-122.39158, 37.55481]]], [[[-122.44289, 37.55923], [-122.44249, 37.55923], [-122.4405, 37.55846], [-122.43984, 37.55841], [-122.43947, 37.55864], [-122.43892, 37.5588], [-122.43898, 37.55818], [-122.43869, 37.55789], [-122.4353, 37.55699], [-122.43507, 37.55672], [-122.43466, 37.55665], [-122.43457, 37.55617], [-122.4332, 37.55521], [-122.43251, 37.5551], [-122.43196, 37.55523], [-122.43144, 37.55485], [-122.4311, 37.55482], [-122.43072, 37.55491], [-122.43052, 37.55462], [-122.42957, 37.55407], [-122.42894, 37.55388], [-122.42805, 37.5535], [-122.42773, 37.55322], [-122.42695, 37.55292], [-122.42684, 37.55263], [-122.42652, 37.55244], [-122.42592, 37.55233], [-122.42569, 37.55205], [-122.42465, 37.55146], [-122.42356, 37.55073], [-122.42298, 37.55089], [-122.42278, 37.55119], [-122.42276, 37.5516], [-122.42322, 37.55247], [-122.42333, 37.55293], [-122.42325, 37.55343], [-122.42333, 37.55437], [-122.42348, 37.55467], [-122.42356, 37.55542], [-122.42451, 37.55615], [-122.42477, 37.55647], [-122.42515, 37.55753], [-122.4242, 37.55705], [-122.42414, 37.55675], [-122.42351, 37.55618], [-122.42307, 37.55551], [-122.42261, 37.55503], [-122.4225, 37.5543], [-122.42215, 37.55377], [-122.42224, 37.5532], [-122.42201, 37.55274], [-122.42178, 37.55254], [-122.42189, 37.55208], [-122.42189, 37.55137], [-122.42175, 37.55096], [-122.42241, 37.55043], [-122.42258, 37.54986], [-122.4225, 37.54926], [-122.42261, 37.54897], [-122.4235, 37.54782], [-122.42407, 37.54768], [-122.42445, 37.54768], [-122.42445, 37.54807], [-122.42471, 37.54828], [-122.4248, 37.54885], [-122.4256, 37.54908], [-122.42621, 37.54965], [-122.42681, 37.54977], [-122.42701, 37.55004], [-122.42736, 37.5502], [-122.4292, 37.55011], [-122.42905, 37.5504], [-122.42856, 37.55093], [-122.42833, 37.55136], [-122.42836, 37.55173], [-122.42877, 37.55212], [-122.42917, 37.5521], [-122.42966, 37.55198], [-122.43, 37.55203], [-122.42986, 37.55244], [-122.42989, 37.55274], [-122.43012, 37.55311], [-122.43066, 37.55356], [-122.43158, 37.55386], [-122.43213, 37.55418], [-122.43391, 37.55441], [-122.43418, 37.55464], [-122.43521, 37.55482], [-122.43524, 37.55535], [-122.43616, 37.55606], [-122.43691, 37.55594], [-122.43688, 37.55645], [-122.43803, 37.55697], [-122.43909, 37.55722], [-122.4395, 37.55754], [-122.44272, 37.5588], [-122.44289, 37.55923]]]]} | Restricted Access 2 | 21943 | San Francisco Watershed Water | 24890 | 321 | San Francisco - Public Utilities Commission, City and County of 31 | County 3 | County Agency - Other 9 | http://sfwater.org/ | County 3 | 321 | San Francisco - Public Utilities Commission, City and County of 30 | County 3 | County Agency - Other 8 | San Mateo 15 | 1251.272 | San Francisco Watershed Water | 1930 | None 9 |
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]);