superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, MNG_AGENCY = 384, MNG_AG_TYP = 2 and YR_EST = 1974
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency · 1 ✖
MNG_AGENCY 1
- Burlingame, City of · 1 ✖
ACCESS_TYP 1
- Open Access · 1 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2368 | 2368 | 2367 | {"type": "Polygon", "coordinates": [[[-122.36032, 37.59115], [-122.35988, 37.59164], [-122.35974, 37.59171], [-122.3578, 37.59173], [-122.35782, 37.59125], [-122.35679, 37.59084], [-122.35618, 37.59173], [-122.35152, 37.59176], [-122.35152, 37.59161], [-122.35171, 37.59163], [-122.35171, 37.59026], [-122.35152, 37.59006], [-122.35151, 37.58901], [-122.33844, 37.58823], [-122.33845, 37.58716], [-122.3533, 37.5875], [-122.35395, 37.58769], [-122.35476, 37.58796], [-122.35556, 37.58826], [-122.35633, 37.58859], [-122.35643, 37.5886], [-122.35708, 37.58878], [-122.35775, 37.5887], [-122.35857, 37.58896], [-122.35973, 37.58963], [-122.36028, 37.59002], [-122.36039, 37.59014], [-122.36047, 37.5903], [-122.36049, 37.59047], [-122.36046, 37.5906], [-122.36024, 37.59108], [-122.36032, 37.59115]]]} | Open Access 1 | Burlingame Lagoon Park | 16524 | 1039 | Burlingame, City of 384 | City 2 | City Agency 2 | http://www.burlingame.org/index.aspx?page=33 | City 2 | 109.735 | Burlingame Lagoon Park | 1974 |
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]);