superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where MNG_AGENCY = 1097, MNG_AG_LEV = 2 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12584 | 12584 | 12583 | {"type": "Polygon", "coordinates": [[[-117.97481, 34.14373], [-117.9748, 34.14592], [-117.97454, 34.14593], [-117.97453, 34.14687], [-117.9745, 34.14687], [-117.9745, 34.1459], [-117.97472, 34.14589], [-117.97476, 34.14586], [-117.97476, 34.14373], [-117.97481, 34.14373]]]} | Open Access 1 | Lemon Trail | 29710 | 1712 | Bradbury, City of 1097 | City 2 | City Agency 2 | http://cityofbradbury.org/ | City 2 | 0.344 | Lemon Trail | ||
12585 | 12585 | 12584 | {"type": "Polygon", "coordinates": [[[-117.97472, 34.14357], [-117.97464, 34.14362], [-117.96441, 34.1437], [-117.96441, 34.14354], [-117.97458, 34.14347], [-117.97472, 34.14357]]]} | Open Access 1 | Royal Oaks Trail North | 29711 | 1712 | Bradbury, City of 1097 | City 2 | City Agency 2 | http://cityofbradbury.org/ | City 2 | 4.027 | Royal Oaks Trail North | ||
15622 | 15622 | 15621 | {"type": "Polygon", "coordinates": [[[-117.96999, 34.14575], [-117.9696, 34.14575], [-117.96915, 34.14556], [-117.96899, 34.14555], [-117.96898, 34.14547], [-117.96986, 34.1455], [-117.96996, 34.14548], [-117.96999, 34.14575]]]} | Open Access 1 | Civic Center Park | 32522 | 1712 | Bradbury, City of 1097 | City 2 | City Agency 2 | http://cityofbradbury.org/ | City 2 | 0.468 | Civic Ctr. Park |
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]);