superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, ACRES = "15.907" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1834 | 1834 | 1833 | {"type": "Polygon", "coordinates": [[[-122.39575, 37.71662], [-122.39566, 37.71671], [-122.39559, 37.71682], [-122.39554, 37.71692], [-122.3955, 37.71711], [-122.39546, 37.71717], [-122.39537, 37.71729], [-122.39521, 37.71739], [-122.39461, 37.71762], [-122.39453, 37.71768], [-122.39445, 37.71776], [-122.3944, 37.7179], [-122.39441, 37.71804], [-122.39449, 37.71817], [-122.39462, 37.71826], [-122.39442, 37.71849], [-122.39393, 37.71821], [-122.39396, 37.71817], [-122.39396, 37.71816], [-122.39334, 37.7178], [-122.3936, 37.71771], [-122.39361, 37.71769], [-122.39329, 37.71739], [-122.39333, 37.71736], [-122.39333, 37.71734], [-122.39278, 37.71682], [-122.39201, 37.71657], [-122.39125, 37.71612], [-122.39002, 37.7146], [-122.38947, 37.71408], [-122.38921, 37.71419], [-122.38904, 37.71395], [-122.3889, 37.7137], [-122.3888, 37.71349], [-122.38871, 37.71322], [-122.38904, 37.71326], [-122.38918, 37.7133], [-122.38933, 37.71337], [-122.38945, 37.71345], [-122.38955, 37.71355], [-122.38965, 37.71367], [-122.38973, 37.71384], [-122.38985, 37.71396], [-122.39002, 37.71405], [-122.39033, 37.71413], [-122.39049, 37.71423], [-122.39059, 37.71434], [-122.39082, 37.71473], [-122.3911, 37.71508], [-122.39132, 37.71543], [-122.39144, 37.71557], [-122.39157, 37.71566], [-122.39208, 37.71586], [-122.39215, 37.71579], [-122.39231, 37.71568], [-122.39242, 37.71557], [-122.3925, 37.71554], [-122.39303, 37.71564], [-122.39361, 37.71583], [-122.39418, 37.71592], [-122.39424, 37.71597], [-122.39419, 37.71601], [-122.39419, 37.71608], [-122.39412, 37.71631], [-122.39411, 37.71648], [-122.39415, 37.71661], [-122.39423, 37.71671], [-122.39452, 37.71701], [-122.39464, 37.71708], [-122.39482, 37.71715], [-122.39494, 37.71717], [-122.39509, 37.71717], [-122.39522, 37.71714], [-122.39533, 37.71709], [-122.39543, 37.71702], [-122.39549, 37.71695], [-122.39559, 37.71679], [-122.39567, 37.71663], [-122.39571, 37.71661], [-122.39575, 37.71662]]]} | Open Access 1 | Bay View Hill Park/open Space | 15883 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 15.907 | Bay View Hill Park/open Space |
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]);