superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
4 rows where ACCESS_TYP = 1, LAYER = 4 and MNG_AGENCY = 951
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AG_TYP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3275 | 3275 | 3274 | {"type": "Polygon", "coordinates": [[[-121.38766, 38.58687], [-121.38764, 38.58692], [-121.38753, 38.58696], [-121.38736, 38.58701], [-121.38719, 38.58703], [-121.38498, 38.58703], [-121.38492, 38.58699], [-121.38492, 38.58639], [-121.38494, 38.58635], [-121.38498, 38.58633], [-121.38617, 38.58633], [-121.38647, 38.58626], [-121.38676, 38.58613], [-121.38682, 38.58614], [-121.38765, 38.58684], [-121.38766, 38.58687]]]} | Open Access 1 | Crabtree Park | 17747 | 2196 | Arden Manor Recreation and Park District 951 | Special District 4 | Recreation/Parks District 4 | http://www.amrpd.org/ | Special District 4 | 4.341 | Crabtree Park | ||
3588 | 3588 | 3587 | {"type": "Polygon", "coordinates": [[[-121.38917, 38.59141], [-121.38915, 38.59222], [-121.38788, 38.5922], [-121.38757, 38.5919], [-121.38786, 38.59166], [-121.38812, 38.59132], [-121.38816, 38.5913], [-121.38859, 38.59136], [-121.38912, 38.59137], [-121.38917, 38.59141]]]} | Open Access 1 | Deterding Park | 18121 | 2196 | Arden Manor Recreation and Park District 951 | Special District 4 | Recreation/Parks District 4 | http://www.amrpd.org/ | Special District 4 | 2.758 | Deterding Park | ||
5600 | 5600 | 5599 | {"type": "Polygon", "coordinates": [[[-121.39914, 38.58327], [-121.39914, 38.58404], [-121.39911, 38.58417], [-121.3991, 38.58419], [-121.39909, 38.58497], [-121.39908, 38.58499], [-121.39903, 38.58501], [-121.39703, 38.58499], [-121.39697, 38.58496], [-121.39697, 38.58416], [-121.39745, 38.58414], [-121.39746, 38.58325], [-121.39914, 38.58327]]]} | Open Access 1 | Jonas Larkspur Park | 20486 | 2196 | Arden Manor Recreation and Park District 951 | Special District 4 | Recreation/Parks District 4 | http://www.amrpd.org/ | Special District 4 | 7.901 | Jonas Larkspur Park | ||
11344 | 11344 | 11343 | {"type": "Polygon", "coordinates": [[[-121.39214, 38.5815], [-121.39214, 38.58301], [-121.39018, 38.58299], [-121.39018, 38.58149], [-121.39019, 38.58145], [-121.39025, 38.58144], [-121.39208, 38.58146], [-121.39212, 38.58147], [-121.39214, 38.5815]]]} | Open Access 1 | Winterstein Park | 27656 | 2196 | Arden Manor Recreation and Park District 951 | Special District 4 | Recreation/Parks District 4 | http://www.amrpd.org/ | Special District 4 | 7.276 | Winterstein 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]);