superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AGENCY = 149 and map = "{"type":"Polygon","coordinates":[[[-117.9681699135216,33.74005909014139],[-117.9681789908526,33.74060160991928],[-117.9681615622501,33.74070215617741],[-117.9668610840205,33.74072491333603],[-117.9668460928088,33.74018209088971],[-117.9672535613855,33.74018115638629],[-117.9673819875213,33.74023024909607],[-117.9674579425012,33.74023855126917],[-117.9675533514513,33.74019997999713],[-117.9675782717833,33.74016636910533],[-117.9675900918218,33.74010309727165],[-117.9678219231567,33.74010578557019],[-117.9678400759667,33.74006408443343],[-117.9681699135216,33.74005909014139]]]}"
This data as json, copyable, CSV (advanced)
map 1 ✖
- {"type":"Polygon","coordinates":[[[-117.9681699135216,33.74005909014139],[-117.9681789908526,33.74060160991928],[-117.9681615622501,33.74070215617741],[-117.9668610840205,33.74072491333603],[-117.9668460928088,33.74018209088971],[-117.9672535613855,33.74018115638629],[-117.9673819875213,33.74023024909607],[-117.9674579425012,33.74023855126917],[-117.9675533514513,33.74019997999713],[-117.9675782717833,33.74016636910533],[-117.9675900918218,33.74010309727165],[-117.9678219231567,33.74010578557019],[-117.9678400759667,33.74006408443343],[-117.9681699135216,33.74005909014139]]]} · 1 ✖
MNG_AG_TYP 1
MNG_AGENCY 1
- Westminster, City of · 1 ✖
ACCESS_TYP 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3196 | 3196 | 3195 | {"type": "Polygon", "coordinates": [[[-117.96817, 33.74006], [-117.96818, 33.7406], [-117.96816, 33.7407], [-117.96686, 33.74072], [-117.96685, 33.74018], [-117.96725, 33.74018], [-117.96738, 33.74023], [-117.96746, 33.74024], [-117.96755, 33.7402], [-117.96758, 33.74017], [-117.96759, 33.7401], [-117.96782, 33.74011], [-117.96784, 33.74006], [-117.96817, 33.74006]]]} | Open Access 1 | Coronet Park | 17651 | 1378 | Westminster, City of 149 | City 2 | City Agency 2 | http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp | City 2 | 1.909 | Coronet 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]);