units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
21 rows where AGNCY_TYP = 3 and MNG_AGENCY = 471 sorted by AGNCY_WEB
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16417 | 16417 | 16416 | {"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 | 44472 | Westgate Landing Regional Park | 27395 | 322 | San Joaquin, County of 479 | County 3 | County Agency 3 | http://www.sjparks.com/ | County 3 | 322 | San Joaquin, County of 471 | County 3 | County Agency 3 | San Joaquin 39 | 20.763 | Westgate Landing RP | 0 | Local Park 2 | 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]);