superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AGENCY = 577 and PARK_NAME = "Westwood Manor Park"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11163 | 11163 | 11162 | {"type": "MultiPolygon", "coordinates": [[[[-124.0932, 40.88057], [-124.09245, 40.88055], [-124.09246, 40.88037], [-124.0932, 40.88038], [-124.09315, 40.88044], [-124.09314, 40.88048], [-124.09316, 40.88053], [-124.0932, 40.88057]]], [[[-124.09396, 40.87952], [-124.09421, 40.88044], [-124.09415, 40.88086], [-124.09415, 40.881], [-124.09403, 40.88131], [-124.09378, 40.88156], [-124.09362, 40.88161], [-124.09383, 40.88129], [-124.09385, 40.88065], [-124.0934, 40.88063], [-124.09341, 40.88058], [-124.09346, 40.88053], [-124.09348, 40.88049], [-124.09346, 40.88043], [-124.09341, 40.88035], [-124.09386, 40.88036], [-124.0939, 40.8795], [-124.09396, 40.87952]]]]} | Open Access 1 | Westwood Manor Park | 27438 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 1.731 | Westwood Manor 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]);