superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACRES = "216.969" and MNG_AG_TYP = 13
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11746 | 11746 | 11745 | {"type": "Polygon", "coordinates": [[[-121.75938, 37.40226], [-121.75072, 37.40644], [-121.74665, 37.40506], [-121.74514, 37.40143], [-121.74087, 37.39735], [-121.74693, 37.39537], [-121.75232, 37.39823], [-121.75202, 37.39839], [-121.75117, 37.39869], [-121.75076, 37.39886], [-121.75052, 37.39905], [-121.74923, 37.39947], [-121.74867, 37.39978], [-121.74921, 37.40098], [-121.7496, 37.4008], [-121.75015, 37.40085], [-121.75078, 37.40043], [-121.75107, 37.40035], [-121.75232, 37.40037], [-121.75349, 37.40049], [-121.75403, 37.40063], [-121.75477, 37.40095], [-121.75528, 37.40133], [-121.75628, 37.40129], [-121.75699, 37.40077], [-121.75938, 37.40226]]]} | Open Access 1 | Upper Penitencia Creek Property | 28353 | 2143 | Santa Clara Valley Water District 798 | Special District 4 | Water District 13 | http://www.valleywater.org/ | Special District 4 | 216.969 | Upper Penitencia Creek Property |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);