superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where LABEL_NAME = "Christmas Hill Park" and MNG_AG_TYP = 7
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2921 | 2921 | 2920 | {"type": "Polygon", "coordinates": [[[-121.58753, 36.99436], [-121.58738, 36.99554], [-121.58732, 36.99577], [-121.58721, 36.996], [-121.58706, 36.99622], [-121.58583, 36.9976], [-121.58544, 36.99808], [-121.58541, 36.99807], [-121.58494, 36.99871], [-121.58458, 36.99926], [-121.58332, 36.99837], [-121.58303, 36.99813], [-121.58286, 36.99795], [-121.58272, 36.99776], [-121.58257, 36.99752], [-121.58236, 36.9971], [-121.58221, 36.99689], [-121.58205, 36.9967], [-121.58183, 36.99649], [-121.58133, 36.99607], [-121.58054, 36.99548], [-121.58128, 36.99477], [-121.58177, 36.99424], [-121.58184, 36.99425], [-121.58305, 36.99325], [-121.58319, 36.99311], [-121.58336, 36.99293], [-121.58354, 36.9927], [-121.58371, 36.99244], [-121.58384, 36.99218], [-121.58548, 36.99277], [-121.587, 36.99287], [-121.58713, 36.99346], [-121.58753, 36.99436]]]} | Open Access 1 | Christmas Hill Park | 17228 | 326 | Santa Clara County Parks and Recreation Dept., County of 465 | County 3 | County Agency - Parks 7 | http://www.sccgov.org/sites/parks/Pages/Welcome-to-Santa-Clara-County-Parks.aspx | County 3 | 68.848 | Christmas Hill 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]);