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 sorted by SUID_NMA descending
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- Recreation/Parks District · 27 ✖
MNG_AGENCY 1
- North of the River Recreation and Park District · 27 ✖
ACCESS_TYP 1
- Open Access 27
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
8806 | 8806 | 8805 | {"type": "Polygon", "coordinates": [[[-119.02987, 35.40131], [-119.02821, 35.40131], [-119.02822, 35.40213], [-119.02792, 35.4021], [-119.02791, 35.40263], [-119.0276, 35.40264], [-119.02758, 35.40338], [-119.02754, 35.40312], [-119.02752, 35.40284], [-119.02712, 35.40285], [-119.02711, 35.40337], [-119.02688, 35.40337], [-119.02688, 35.40299], [-119.02672, 35.40298], [-119.02672, 35.40132], [-119.02623, 35.4013], [-119.02651, 35.40111], [-119.02658, 35.40101], [-119.02666, 35.40086], [-119.02669, 35.40047], [-119.02662, 35.39998], [-119.0267, 35.39991], [-119.02983, 35.39908], [-119.02987, 35.40131]]]} | Open Access 1 | Riverview Park | 24467 | 2096 | North of the River Recreation and Park District 382 | Special District 4 | Recreation/Parks District 4 | http://norfun.org/ | Special District 4 | 19.99 | Riverview Park | ||
8751 | 8751 | 8750 | {"type": "MultiPolygon", "coordinates": [[[[-119.09761, 35.40048], [-119.09761, 35.40048], [-119.0976, 35.40055], [-119.09755, 35.40051], [-119.09761, 35.40048]]], [[[-119.09798, 35.40118], [-119.09789, 35.40109], [-119.09783, 35.40095], [-119.09789, 35.401], [-119.09794, 35.40106], [-119.09798, 35.40118]]], [[[-119.09823, 35.4015], [-119.0981, 35.40149], [-119.09804, 35.40138], [-119.09808, 35.40132], [-119.09823, 35.4015]]], [[[-119.09895, 35.39986], [-119.09895, 35.39986], [-119.09864, 35.39995], [-119.09889, 35.3998], [-119.09895, 35.39986]]], [[[-119.09949, 35.40115], [-119.09931, 35.40122], [-119.09921, 35.40121], [-119.09937, 35.40109], [-119.09947, 35.40107], [-119.09949, 35.40115]]]]} | Open Access 1 | River Lakes Ranch Community Park | 24410 | 2096 | North of the River Recreation and Park District 382 | Special District 4 | Recreation/Parks District 4 | http://norfun.org/ | Special District 4 | 0.141 | River Lakes Ranch Community Park | ||
8554 | 8554 | 8553 | {"type": "Polygon", "coordinates": [[[-119.01983, 35.40852], [-119.01888, 35.40852], [-119.01887, 35.40797], [-119.01983, 35.40797], [-119.01983, 35.40852]]]} | Open Access 1 | Rasmussen Center | 24188 | 2096 | North of the River Recreation and Park District 382 | Special District 4 | Recreation/Parks District 4 | http://norfun.org/ | Special District 4 | 1.309 | Rasmussen Ctr. | ||
8287 | 8287 | 8286 | {"type": "Polygon", "coordinates": [[[-119.13655, 35.40159], [-119.13653, 35.4041], [-119.1365, 35.40501], [-119.13643, 35.40507], [-119.13224, 35.40508], [-119.13226, 35.40158], [-119.13655, 35.40159]]]} | Open Access 1 | Polo Community Park | 23874 | 2096 | North of the River Recreation and Park District 382 | Special District 4 | Recreation/Parks District 4 | http://norfun.org/ | Special District 4 | 37.229 | Polo Community Park | ||
7679 | 7679 | 7678 | {"type": "Polygon", "coordinates": [[[-119.09045, 35.40647], [-119.09044, 35.40738], [-119.08934, 35.40737], [-119.08934, 35.40647], [-119.08974, 35.40647], [-119.08981, 35.40644], [-119.0899, 35.40646], [-119.09002, 35.40645], [-119.09045, 35.40647]]]} | Open Access 1 | Olive Park West | 23129 | 2096 | North of the River Recreation and Park District 382 | Special District 4 | Recreation/Parks District 4 | http://norfun.org/ | Special District 4 | 2.515 | Olive Park West | ||
7678 | 7678 | 7677 | {"type": "Polygon", "coordinates": [[[-119.08621, 35.40729], [-119.0851, 35.40731], [-119.08511, 35.40685], [-119.0851, 35.40638], [-119.08555, 35.40636], [-119.08621, 35.40638], [-119.08621, 35.40729]]]} | Open Access 1 | Olive Park East | 23128 | 2096 | North of the River Recreation and Park District 382 | Special District 4 | Recreation/Parks District 4 | http://norfun.org/ | Special District 4 | 2.553 | Olive Park East | ||
7468 | 7468 | 7467 | {"type": "Polygon", "coordinates": [[[-119.13082, 35.39222], [-119.1308, 35.39362], [-119.12798, 35.3936], [-119.12794, 35.39219], [-119.12797, 35.39106], [-119.12882, 35.39108], [-119.1288, 35.3922], [-119.13082, 35.39222]]]} | Open Access 1 | North Rosedale Park | 22857 | 2096 | North of the River Recreation and Park District 382 | Special District 4 | Recreation/Parks District 4 | http://norfun.org/ | Special District 4 | 12.359 | North Rosedale Park | ||
6351 | 6351 | 6350 | {"type": "Polygon", "coordinates": [[[-119.03006, 35.43544], [-119.03004, 35.43691], [-119.02772, 35.4369], [-119.02772, 35.43538], [-119.02999, 35.43538], [-119.03006, 35.43544]]]} | Open Access 1 | North Meadows Park | 22830 | 2096 | North of the River Recreation and Park District 382 | Special District 4 | Recreation/Parks District 4 | http://norfun.org/ | Special District 4 | 8.835 | North Meadows Park | ||
7439 | 7439 | 7438 | {"type": "Polygon", "coordinates": [[[-119.03325, 35.4423], [-119.03318, 35.445], [-119.03099, 35.44499], [-119.031, 35.44318], [-119.03103, 35.44278], [-119.03106, 35.44271], [-119.03106, 35.44264], [-119.03103, 35.4426], [-119.03096, 35.44256], [-119.03092, 35.4423], [-119.03325, 35.4423]]]} | Open Access 1 | North Highland Park | 22822 | 2096 | North of the River Recreation and Park District 382 | Special District 4 | Recreation/Parks District 4 | http://norfun.org/ | Special District 4 | 14.883 | North Highland Park | ||
7428 | 7428 | 7427 | {"type": "Polygon", "coordinates": [[[-119.04068, 35.41591], [-119.03921, 35.41592], [-119.0392, 35.4141], [-119.04065, 35.4141], [-119.04068, 35.41591]]]} | Open Access 1 | North Beardsley Park | 22808 | 2096 | North of the River Recreation and Park District 382 | Special District 4 | Recreation/Parks District 4 | http://norfun.org/ | Special District 4 | 6.593 | North Beardsley Park | ||
7412 | 7412 | 7411 | {"type": "Polygon", "coordinates": [[[-119.02999, 35.42808], [-119.02794, 35.42807], [-119.02794, 35.42719], [-119.02991, 35.42721], [-119.02998, 35.42726], [-119.02999, 35.42808]]]} | Open Access 1 | NOR Park | 22786 | 2096 | North of the River Recreation and Park District 382 | Special District 4 | Recreation/Parks District 4 | http://norfun.org/ | Special District 4 | 4.467 | NOR Park | ||
7107 | 7107 | 7106 | {"type": "Polygon", "coordinates": [[[-119.10684, 35.36219], [-119.1064, 35.36249], [-119.10628, 35.36247], [-119.1062, 35.36252], [-119.10617, 35.36258], [-119.10618, 35.36266], [-119.10622, 35.36272], [-119.10623, 35.36359], [-119.10405, 35.36358], [-119.10402, 35.36351], [-119.10397, 35.36345], [-119.10389, 35.36343], [-119.1038, 35.36345], [-119.10374, 35.36351], [-119.10353, 35.36355], [-119.10352, 35.36371], [-119.10311, 35.36371], [-119.10311, 35.36282], [-119.10313, 35.36265], [-119.10311, 35.36259], [-119.10302, 35.36248], [-119.10389, 35.36248], [-119.1039, 35.36255], [-119.10562, 35.36255], [-119.10564, 35.36218], [-119.10684, 35.36219]]]} | Open Access 1 | Mondavi Park | 22368 | 2096 | North of the River Recreation and Park District 382 | Special District 4 | Recreation/Parks District 4 | http://norfun.org/ | Special District 4 | 8.99 | Mondavi Park | ||
6806 | 6806 | 6805 | {"type": "Polygon", "coordinates": [[[-119.03334, 35.42147], [-119.03333, 35.4215], [-119.03271, 35.422], [-119.0325, 35.4221], [-119.03228, 35.42217], [-119.03222, 35.42214], [-119.03209, 35.42194], [-119.03198, 35.42173], [-119.03188, 35.42147], [-119.03188, 35.42144], [-119.03194, 35.4214], [-119.03328, 35.4214], [-119.03332, 35.42141], [-119.03334, 35.42144], [-119.03334, 35.42147]]]} | Open Access 1 | McCray Park | 22013 | 2096 | North of the River Recreation and Park District 382 | Special District 4 | Recreation/Parks District 4 | http://norfun.org/ | Special District 4 | 1.755 | McCray 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]);