superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where LABEL_NAME = "Hampe Hills OS" and MNG_AG_TYP = 2
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
108 | 108 | 107 | {"type": "Polygon", "coordinates": [[[-117.14184, 32.97106], [-117.14124, 32.97188], [-117.1408, 32.97192], [-117.14001, 32.97194], [-117.13999, 32.97192], [-117.1393, 32.97187], [-117.13918, 32.97191], [-117.13901, 32.97201], [-117.13894, 32.97203], [-117.13893, 32.97216], [-117.1386, 32.97217], [-117.13843, 32.97224], [-117.13783, 32.97225], [-117.1379, 32.97211], [-117.13789, 32.97209], [-117.13792, 32.97197], [-117.13791, 32.97195], [-117.13793, 32.97184], [-117.13792, 32.97181], [-117.13795, 32.9717], [-117.13793, 32.97167], [-117.13796, 32.97156], [-117.13794, 32.97154], [-117.13797, 32.97143], [-117.13795, 32.9714], [-117.13798, 32.97129], [-117.13796, 32.97126], [-117.13796, 32.97111], [-117.13876, 32.97111], [-117.13986, 32.97108], [-117.14184, 32.97106]]]} | Open Access 1 | Hampe Hills Open Space | 19630 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 8.407 | Hampe Hills OS |
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]);