superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
27 rows where MNG_AGENCY = 382 and MNG_AG_TYP = 4
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- Recreation/Parks District · 7 ✖
MNG_AGENCY 1
- North of the River Recreation and Park District · 7 ✖
ACCESS_TYP 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9208 | 9208 | 9207 | {"type": "MultiPolygon", "coordinates": [[[[-119.07261, 35.39748], [-119.07261, 35.3977], [-119.07254, 35.39775], [-119.06568, 35.39772], [-119.06561, 35.39766], [-119.06561, 35.39719], [-119.06564, 35.39694], [-119.06564, 35.39639], [-119.0657, 35.39634], [-119.06671, 35.39634], [-119.06672, 35.39745], [-119.07261, 35.39748]]], [[[-119.07323, 35.39748], [-119.07323, 35.39776], [-119.07288, 35.39775], [-119.07281, 35.3977], [-119.07282, 35.39748], [-119.07323, 35.39748]]]]} | Open Access 1 | San Lauren Park | 24922 | 2096 | North of the River Recreation and Park District 382 | Special District 4 | Recreation/Parks District 4 | http://norfun.org/ | Special District 4 | 8.043 | San Lauren Park | ||
9441 | 9441 | 9440 | {"type": "Polygon", "coordinates": [[[-119.02942, 35.42069], [-119.02795, 35.42068], [-119.02794, 35.42017], [-119.02802, 35.42025], [-119.0291, 35.42025], [-119.0291, 35.41966], [-119.02941, 35.41964], [-119.02942, 35.42069]]]} | Open Access 1 | Sears Park | 25245 | 2096 | North of the River Recreation and Park District 382 | Special District 4 | Recreation/Parks District 4 | http://norfun.org/ | Special District 4 | 2.067 | Sears Park | ||
9532 | 9532 | 9531 | {"type": "Polygon", "coordinates": [[[-119.16218, 35.3708], [-119.16023, 35.3708], [-119.16028, 35.36914], [-119.16218, 35.36914], [-119.16218, 35.3708]]]} | Open Access 1 | Westdale Park | 27388 | 2096 | North of the River Recreation and Park District 382 | Special District 4 | Recreation/Parks District 4 | http://norfun.org/ | Special District 4 | 7.983 | Westdale Park | ||
9682 | 9682 | 9681 | {"type": "Polygon", "coordinates": [[[-119.18085, 35.3729], [-119.18085, 35.37375], [-119.18079, 35.3738], [-119.18018, 35.37382], [-119.1778, 35.37383], [-119.1778, 35.37259], [-119.18024, 35.37258], [-119.18026, 35.37208], [-119.18077, 35.37208], [-119.18084, 35.37215], [-119.18085, 35.3729]]]} | Open Access 1 | Silver Oak Park | 25493 | 2096 | North of the River Recreation and Park District 382 | Special District 4 | Recreation/Parks District 4 | http://norfun.org/ | Special District 4 | 10.149 | Silver Oak Park | ||
9903 | 9903 | 9902 | {"type": "Polygon", "coordinates": [[[-119.01684, 35.41888], [-119.01475, 35.41888], [-119.01468, 35.41594], [-119.01679, 35.41595], [-119.01684, 35.41888]]]} | Open Access 1 | Standard Park | 25782 | 2096 | North of the River Recreation and Park District 382 | Special District 4 | Recreation/Parks District 4 | http://norfun.org/ | Special District 4 | 15.333 | Standard Park | ||
13594 | 13594 | 13593 | {"type": "Polygon", "coordinates": [[[-119.13455, 35.37983], [-119.13454, 35.38338], [-119.13233, 35.38337], [-119.13234, 35.37982], [-119.13455, 35.37983]]]} | Open Access 1 | Unnamed site - North of the River Recreation and Park District | 32826 | 2096 | North of the River Recreation and Park District 382 | Special District 4 | Recreation/Parks District 4 | http://norfun.org/ | Special District 4 | 19.593 | |||
14182 | 14182 | 14181 | {"type": "Polygon", "coordinates": [[[-119.09792, 35.39433], [-119.09605, 35.39563], [-119.09572, 35.39522], [-119.09596, 35.39503], [-119.09583, 35.3949], [-119.09626, 35.39461], [-119.09627, 35.39439], [-119.09581, 35.39394], [-119.09595, 35.3938], [-119.09576, 35.39357], [-119.09659, 35.39298], [-119.09792, 35.39433]]]} | Open Access 1 | Riverlakes Ranch Park | 31658 | 2096 | North of the River Recreation and Park District 382 | Special District 4 | Recreation/Parks District 4 | http://norfun.org/ | Special District 4 | 7.3 | Riverlakes Ranch 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]);