superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1 and LABEL_NAME = "Ravenswood OSP"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14754 | 14754 | 14753 | {"type": "MultiPolygon", "coordinates": [[[[-122.1324, 37.47969], [-122.13089, 37.48337], [-122.13121, 37.48388], [-122.13007, 37.48435], [-122.12827, 37.48519], [-122.12706, 37.48581], [-122.12601, 37.48639], [-122.12499, 37.48698], [-122.12511, 37.48715], [-122.12288, 37.48851], [-122.12169, 37.4876], [-122.12122, 37.48712], [-122.1209, 37.48674], [-122.12069, 37.48634], [-122.12067, 37.48591], [-122.12069, 37.4854], [-122.12094, 37.48482], [-122.12111, 37.4838], [-122.12135, 37.48288], [-122.1213, 37.48188], [-122.1212, 37.48129], [-122.12101, 37.48067], [-122.121, 37.48033], [-122.12096, 37.48004], [-122.1205, 37.4786], [-122.12002, 37.47792], [-122.11974, 37.47759], [-122.12356, 37.47626], [-122.12357, 37.47575], [-122.12355, 37.47574], [-122.11921, 37.47727], [-122.11928, 37.47648], [-122.11928, 37.47602], [-122.11939, 37.47565], [-122.11954, 37.47542], [-122.11987, 37.47522], [-122.12078, 37.47498], [-122.12185, 37.47469], [-122.12274, 37.47455], [-122.12355, 37.47435], [-122.12359, 37.47573], [-122.12646, 37.47472], [-122.12638, 37.4749], [-122.12942, 37.47739], [-122.1324, 37.47969]]], [[[-122.12831, 37.49845], [-122.12687, 37.49937], [-122.12687, 37.49939], [-122.12723, 37.49966], [-122.12606, 37.50045], [-122.12584, 37.49934], [-122.12569, 37.49831], [-122.12559, 37.49736], [-122.12802, 37.49742], [-122.12831, 37.49845]]]]} | Open Access 1 | Ravenswood Open Space Preserve | http://www.openspace.org/preserves/pr_ravenswood.asp | 31459 | 2079 | Midpeninsula Regional Open Space District 631 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org | Special District 4 | 283.578 | Ravenswood OSP |
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]);