superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
21 rows where MNG_AGENCY = 471 and MNG_AG_LEV = 3 sorted by AGNCY_WEB
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15106 | 15106 | 15105 | {"type": "Polygon", "coordinates": [[[-121.49597, 38.12474], [-121.48987, 38.12479], [-121.48956, 38.12545], [-121.48917, 38.12561], [-121.489, 38.12547], [-121.48934, 38.12536], [-121.48941, 38.1253], [-121.49009, 38.12373], [-121.49024, 38.12382], [-121.49042, 38.12385], [-121.49059, 38.1238], [-121.49086, 38.12368], [-121.49097, 38.12367], [-121.49107, 38.12369], [-121.49114, 38.12375], [-121.49129, 38.12382], [-121.49172, 38.1239], [-121.49227, 38.12378], [-121.49239, 38.12368], [-121.49246, 38.1236], [-121.49251, 38.12349], [-121.49254, 38.12331], [-121.49249, 38.123], [-121.4924, 38.12269], [-121.49236, 38.12238], [-121.49237, 38.12233], [-121.49241, 38.12229], [-121.4925, 38.12225], [-121.49315, 38.12226], [-121.4934, 38.12222], [-121.49361, 38.12226], [-121.49373, 38.12232], [-121.49379, 38.12238], [-121.49379, 38.12255], [-121.49383, 38.12291], [-121.49388, 38.12301], [-121.49403, 38.12321], [-121.49422, 38.12333], [-121.49448, 38.12342], [-121.49518, 38.12361], [-121.4954, 38.12374], [-121.49565, 38.12397], [-121.49577, 38.12414], [-121.4959, 38.12441], [-121.49597, 38.12474]]]} | Open Access 1 | Westgate Landing Regional Park | 27395 | 322 | San Joaquin, County of 471 | County 3 | County Agency 3 | http://www.sjparks.com/ | County 3 | 20.769 | Westgate Landing RP |
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]);