units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where DES_TP = 3, MNG_AG_TYP = 13 and YR_EST = 1952
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14838 | 14838 | 14837 | {"type": "Polygon", "coordinates": [[[-121.99308, 37.19292], [-121.99305, 37.19343], [-121.99297, 37.19354], [-121.99128, 37.19329], [-121.99099, 37.19345], [-121.991, 37.19379], [-121.99117, 37.19418], [-121.99234, 37.19503], [-121.99246, 37.19526], [-121.99251, 37.19608], [-121.99234, 37.19624], [-121.99217, 37.19729], [-121.99103, 37.19773], [-121.99054, 37.1981], [-121.99031, 37.19859], [-121.99034, 37.19909], [-121.99051, 37.19934], [-121.99103, 37.19978], [-121.991, 37.20002], [-121.99028, 37.2005], [-121.98948, 37.20077], [-121.98882, 37.20087], [-121.98791, 37.2008], [-121.98739, 37.19988], [-121.98708, 37.19961], [-121.98665, 37.1995], [-121.98599, 37.19957], [-121.98545, 37.19995], [-121.98525, 37.19995], [-121.9851, 37.19986], [-121.98479, 37.19901], [-121.98407, 37.19835], [-121.98367, 37.19821], [-121.98284, 37.19821], [-121.98212, 37.19842], [-121.98101, 37.19951], [-121.98052, 37.20021], [-121.98027, 37.20025], [-121.98027, 37.19984], [-121.98081, 37.19888], [-121.98175, 37.19803], [-121.98258, 37.19753], [-121.9843, 37.19693], [-121.98464, 37.19629], [-121.98524, 37.19599], [-121.9855, 37.19556], [-121.98553, 37.19508], [-121.98533, 37.1949], [-121.98473, 37.19499], [-121.9845, 37.19483], [-121.98364, 37.19455], [-121.98367, 37.19441], [-121.98415, 37.19412], [-121.98438, 37.19385], [-121.98442, 37.19382], [-121.98443, 37.19379], [-121.98456, 37.19363], [-121.98473, 37.19361], [-121.98559, 37.19409], [-121.98593, 37.19421], [-121.98616, 37.19411], [-121.98613, 37.19299], [-121.98593, 37.1927], [-121.98593, 37.19242], [-121.98633, 37.19201], [-121.98664, 37.19123], [-121.98667, 37.19068], [-121.9865, 37.1905], [-121.98647, 37.1902], [-121.98676, 37.1894], [-121.98698, 37.18809], [-121.98678, 37.18761], [-121.9863, 37.18692], [-121.98581, 37.18491], [-121.98547, 37.18438], [-121.98489, 37.18411], [-121.98392, 37.18436], [-121.98366, 37.18436], [-121.98263, 37.18384], [-121.98189, 37.18356], [-121.98092, 37.18377], [-121.98103, 37.18352], [-121.98163, 37.18329], [-121.9824, 37.18317], [-121.98289, 37.18329], [-121.98366, 37.18363], [-121.98406, 37.18365], [-121.98481, 37.1834], [-121.98526, 37.18315], [-121.98521, 37.18214], [-121.98555, 37.18093], [-121.98552, 37.17951], [-121.98497, 37.17775], [-121.98406, 37.1758], [-121.98443, 37.17479], [-121.9844, 37.17324], [-121.98417, 37.17205], [-121.98403, 37.17177], [-121.98351, 37.17145], [-121.98145, 37.17152], [-121.98045, 37.17102], [-121.98019, 37.17065], [-121.98019, 37.17019], [-121.98068, 37.16928], [-121.98128, 37.16861], [-121.98142, 37.16868], [-121.98139, 37.16893], [-121.98083, 37.16987], [-121.98083, 37.17026], [-121.98157, 37.17088], [-121.98205, 37.17104], [-121.98294, 37.17104], [-121.98431, 37.17081], [-121.98474, 37.17081], [-121.98517, 37.17092], [-121.98537, 37.17114], [-121.98552, 37.17186], [-121.98592, 37.17287], [-121.98575, 37.17362], [-121.98549, 37.17408], [-121.98569, 37.17498], [-121.98616, 37.17549], [-121.98712, 37.17594], [-121.98786, 37.17582], [-121.98818, 37.17607], [-121.98827, 37.17646], [-121.98852, 37.17685], [-121.98852, 37.17724], [-121.98807, 37.17749], [-121.98792, 37.17788], [-121.98818, 37.17882], [-121.98815, 37.17926], [-121.98798, 37.17953], [-121.9879, 37.18061], [-121.98764, 37.18125], [-121.98767, 37.18154], [-121.98781, 37.18171], [-121.98953, 37.18148], [-121.9901, 37.18161], [-121.98976, 37.18205], [-121.98807, 37.1826], [-121.98795, 37.18274], [-121.98795, 37.18301], [-121.98819, 37.18326], [-121.98913, 37.18367], [-121.98976, 37.18422], [-121.98993, 37.18452], [-121.98985, 37.18711], [-121.99025, 37.18853], [-121.99059, 37.18905], [-121.99179, 37.19008], [-121.99176, 37.19031], [-121.99122, 37.19061], [-121.99105, 37.19086], [-121.99105, 37.1912], [-121.99117, 37.19127], [-121.99237, 37.19132], [-121.99282, 37.1915], [-121.99294, 37.19187], [-121.99274, 37.19235], [-121.99274, 37.19273], [-121.99308, 37.19292]]]} | Open Access 1 | 45330 | Lexington Reservoir | 11943 | 2143 | Santa Clara Valley Water District 483 | Special District 4 | Water District 13 | http://www.valleywater.org/ | Special District 4 | 2143 | Santa Clara Valley Water District 798 | Special District 4 | Water District 13 | http://www.valleywater.org/Services/LexingtonReservoirAndLenihanDam.aspx | Santa Clara 19 | 319.187 | Lexington Reservoir | 1952 | 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]);