units_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 rowid descending
This data as json, copyable, CSV (advanced)
DES_TP 3
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 | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14414 | 14414 | 14413 | {"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 | 44536 | Rasmussen Center | 24188 | 2096 | North of the River Recreation and Park District 386 | Special District 4 | Recreation/Parks District 4 | http://norfun.org/ | Special District 4 | 2096 | North of the River Recreation and Park District 382 | Special District 4 | Recreation/Parks District 4 | Kern 36 | 1.31 | Rasmussen Ctr. | 0 | Local Recreation Area 3 | 4 | |
14412 | 14412 | 14411 | {"type": "Polygon", "coordinates": [[[-119.09792, 35.39433], [-119.09605, 35.39563], [-119.09572, 35.39522], [-119.09597, 35.39503], [-119.09583, 35.3949], [-119.09626, 35.3946], [-119.09627, 35.39439], [-119.09581, 35.39394], [-119.09596, 35.3938], [-119.09576, 35.39357], [-119.09659, 35.39298], [-119.09792, 35.39433]]]} | Open Access 1 | 44535 | Riverlakes Ranch Park | 31658 | 2096 | North of the River Recreation and Park District 386 | Special District 4 | Recreation/Parks District 4 | http://norfun.org/ | Special District 4 | 2096 | North of the River Recreation and Park District 382 | Special District 4 | Recreation/Parks District 4 | Kern 36 | 7.293 | Riverlakes Ranch Park | 0 | Local Park 2 | 4 | |
12252 | 12252 | 12251 | {"type": "Polygon", "coordinates": [[[-119.16218, 35.36914], [-119.16218, 35.3708], [-119.16023, 35.3708], [-119.16028, 35.36914], [-119.16218, 35.36914]]]} | Open Access 1 | 25786 | Westdale Park | 27388 | 2096 | North of the River Recreation and Park District 386 | Special District 4 | Recreation/Parks District 4 | http://norfun.org/ | Special District 4 | 2096 | North of the River Recreation and Park District 382 | Special District 4 | Recreation/Parks District 4 | Kern 36 | 7.984 | Westdale Park | 0 | Local Park 2 | 4 | |
12178 | 12178 | 12177 | {"type": "Polygon", "coordinates": [[[-119.12129, 35.4109], [-119.12002, 35.41094], [-119.11913, 35.41088], [-119.11906, 35.41083], [-119.11909, 35.41053], [-119.11907, 35.4089], [-119.12128, 35.40887], [-119.12127, 35.40939], [-119.12129, 35.40953], [-119.12129, 35.4109]]]} | Open Access 1 | 25363 | Almondale Park | 15400 | 2096 | North of the River Recreation and Park District 386 | Special District 4 | Recreation/Parks District 4 | http://norfun.org/ | Special District 4 | 2096 | North of the River Recreation and Park District 382 | Special District 4 | Recreation/Parks District 4 | Kern 36 | 11.185 | Almondale Park | 0 | Local Park 2 | 4 | |
12167 | 12167 | 12166 | {"type": "Polygon", "coordinates": [[[-119.10975, 35.37746], [-119.10975, 35.37803], [-119.10971, 35.37821], [-119.10971, 35.37828], [-119.10974, 35.37835], [-119.10974, 35.37846], [-119.10684, 35.37845], [-119.10682, 35.37976], [-119.10631, 35.37976], [-119.10632, 35.37746], [-119.10975, 35.37746]]]} | Open Access 1 | 25360 | Greenacres Community Center | 19470 | 2096 | North of the River Recreation and Park District 386 | Special District 4 | Recreation/Parks District 4 | http://norfun.org/ | Special District 4 | 2096 | North of the River Recreation and Park District 382 | Special District 4 | Recreation/Parks District 4 | Kern 36 | 10.147 | Greenacres Community Ctr. | 0 | Local Recreation Area 3 | 4 | |
8576 | 8576 | 8575 | {"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.18025, 35.37258], [-119.18026, 35.37208], [-119.18077, 35.37208], [-119.18084, 35.37215], [-119.18085, 35.3729]]]} | Open Access 1 | 13611 | Silver Oak Park | 25493 | 2096 | North of the River Recreation and Park District 386 | Special District 4 | Recreation/Parks District 4 | http://norfun.org/ | Special District 4 | 2096 | North of the River Recreation and Park District 382 | Special District 4 | Recreation/Parks District 4 | Kern 36 | 10.144 | Silver Oak Park | 0 | Local Park 2 | 4 | |
8563 | 8563 | 8562 | {"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 | 13578 | Sears Park | 25245 | 2096 | North of the River Recreation and Park District 386 | Special District 4 | Recreation/Parks District 4 | http://norfun.org/ | Special District 4 | 2096 | North of the River Recreation and Park District 382 | Special District 4 | Recreation/Parks District 4 | Kern 36 | 2.062 | Sears Park | 0 | Local Park 2 | 4 | |
8543 | 8543 | 8542 | {"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.0979, 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 | 13462 | River Lakes Ranch Community Park | 24410 | 2096 | North of the River Recreation and Park District 386 | Special District 4 | Recreation/Parks District 4 | http://norfun.org/ | Special District 4 | 2096 | North of the River Recreation and Park District 382 | Special District 4 | Recreation/Parks District 4 | Kern 36 | 0.141 | River Lakes Ranch Community Park | 0 | Local Park 2 | 4 | |
8505 | 8505 | 8504 | {"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.12879, 35.3922], [-119.13082, 35.39222]]]} | Open Access 1 | 13325 | North Rosedale Park | 22857 | 2096 | North of the River Recreation and Park District 386 | Special District 4 | Recreation/Parks District 4 | http://norfun.org/ | Special District 4 | 2096 | North of the River Recreation and Park District 382 | Special District 4 | Recreation/Parks District 4 | Kern 36 | 12.349 | North Rosedale Park | 0 | Local Park 2 | 4 | |
8448 | 8448 | 8447 | {"type": "Polygon", "coordinates": [[[-119.1175, 35.42072], [-119.11635, 35.42116], [-119.11602, 35.42075], [-119.11588, 35.42062], [-119.11552, 35.42035], [-119.11513, 35.42011], [-119.11481, 35.41997], [-119.11442, 35.41983], [-119.11404, 35.41975], [-119.1135, 35.41968], [-119.11574, 35.41842], [-119.11708, 35.42015], [-119.1175, 35.42072]]]} | Open Access 1 | 13129 | Madison Grove Park | 21656 | 2096 | North of the River Recreation and Park District 386 | Special District 4 | Recreation/Parks District 4 | http://norfun.org/ | Special District 4 | 2096 | North of the River Recreation and Park District 382 | Special District 4 | Recreation/Parks District 4 | Kern 36 | 10.96 | Madison Grove Park | 0 | Local Park 2 | 4 | |
8418 | 8418 | 8417 | {"type": "Polygon", "coordinates": [[[-119.07434, 35.41834], [-119.07433, 35.41949], [-119.07294, 35.41949], [-119.07293, 35.41959], [-119.07009, 35.41957], [-119.07009, 35.4179], [-119.07384, 35.4179], [-119.07386, 35.41832], [-119.07434, 35.41834]]]} | Open Access 1 | 13049 | Fruitvale/Norris Park | 19138 | 2096 | North of the River Recreation and Park District 386 | Special District 4 | Recreation/Parks District 4 | http://norfun.org/ | Special District 4 | 2096 | North of the River Recreation and Park District 382 | Special District 4 | Recreation/Parks District 4 | Kern 36 | 16.948 | Fruitvale/Norris Park | 0 | Local Park 2 | 4 | |
8397 | 8397 | 8396 | {"type": "Polygon", "coordinates": [[[-119.15641, 35.40372], [-119.1562, 35.40376], [-119.15599, 35.40383], [-119.15575, 35.40394], [-119.15557, 35.40405], [-119.15225, 35.40133], [-119.15324, 35.40133], [-119.15325, 35.40155], [-119.1544, 35.40155], [-119.15447, 35.4017], [-119.15459, 35.40192], [-119.15485, 35.40226], [-119.15497, 35.40238], [-119.15505, 35.40233], [-119.1562, 35.40328], [-119.15628, 35.40338], [-119.15635, 35.40348], [-119.15641, 35.40372]]]} | Open Access 1 | 12999 | Austin Creek Park | 15711 | 2096 | North of the River Recreation and Park District 386 | Special District 4 | Recreation/Parks District 4 | http://norfun.org/ | Special District 4 | 2096 | North of the River Recreation and Park District 382 | Special District 4 | Recreation/Parks District 4 | https://norfun.org/construction/austin-creek-park/ | Kern 36 | 9.344 | Austin Creek Park | 0 | Local Park 2 | 4 |
5558 | 5558 | 5557 | {"type": "Polygon", "coordinates": [[[-119.12778, 35.3653], [-119.12778, 35.36639], [-119.12774, 35.36742], [-119.12773, 35.36865], [-119.12763, 35.36873], [-119.12648, 35.36873], [-119.12549, 35.36876], [-119.12548, 35.36746], [-119.1255, 35.3653], [-119.12742, 35.36529], [-119.12778, 35.3653]]]} | Open Access 1 | 25359 | LibertyPark | 21215 | 2096 | North of the River Recreation and Park District 386 | Special District 4 | Recreation/Parks District 4 | http://norfun.org/ | Special District 4 | 2096 | North of the River Recreation and Park District 382 | Special District 4 | Recreation/Parks District 4 | Kern 36 | 19.487 | LibertyPark | 0 | Local Park 2 | 4 | |
5557 | 5557 | 5556 | {"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 | 25356 | North Beardsley Park | 22808 | 2096 | North of the River Recreation and Park District 386 | Special District 4 | Recreation/Parks District 4 | http://norfun.org/ | Special District 4 | 2096 | North of the River Recreation and Park District 382 | Special District 4 | Recreation/Parks District 4 | Kern 36 | 6.595 | North Beardsley Park | 0 | Local Park 2 | 4 | |
5556 | 5556 | 5555 | {"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 | 25354 | Olive Park East | 23128 | 2096 | North of the River Recreation and Park District 386 | Special District 4 | Recreation/Parks District 4 | http://norfun.org/ | Special District 4 | 2096 | North of the River Recreation and Park District 382 | Special District 4 | Recreation/Parks District 4 | Kern 36 | 2.554 | Olive Park East | 0 | Local Park 2 | 4 | |
5555 | 5555 | 5554 | {"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 | 25353 | Olive Park West | 23129 | 2096 | North of the River Recreation and Park District 386 | Special District 4 | Recreation/Parks District 4 | http://norfun.org/ | Special District 4 | 2096 | North of the River Recreation and Park District 382 | Special District 4 | Recreation/Parks District 4 | Kern 36 | 2.515 | Olive Park West | 0 | Local Park 2 | 4 | |
5554 | 5554 | 5553 | {"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.06671, 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 | 25351 | San Lauren Park | 24922 | 2096 | North of the River Recreation and Park District 386 | Special District 4 | Recreation/Parks District 4 | http://norfun.org/ | Special District 4 | 2096 | North of the River Recreation and Park District 382 | Special District 4 | Recreation/Parks District 4 | Kern 36 | 8.032 | San Lauren Park | 0 | Local Park 2 | 4 | |
5537 | 5537 | 5536 | {"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 | 24876 | McCray Park | 22013 | 2096 | North of the River Recreation and Park District 386 | Special District 4 | Recreation/Parks District 4 | http://norfun.org/ | Special District 4 | 2096 | North of the River Recreation and Park District 382 | Special District 4 | Recreation/Parks District 4 | Kern 36 | 1.756 | McCray Park | 0 | Local Park 2 | 4 | |
4520 | 4520 | 4519 | {"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 | 13519 | Unnamed site - North of the River Recreation and Park District | 32826 | 2096 | North of the River Recreation and Park District 386 | Special District 4 | Recreation/Parks District 4 | http://norfun.org/ | Special District 4 | 2096 | North of the River Recreation and Park District 382 | Special District 4 | Recreation/Parks District 4 | Kern 36 | 19.594 | 0 | Local Other or Unknown 14 | 4 | ||
3702 | 3702 | 3701 | {"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 | 44485 | Polo Community Park | 23874 | 2096 | North of the River Recreation and Park District 386 | Special District 4 | Recreation/Parks District 4 | http://norfun.org/ | Special District 4 | 2096 | North of the River Recreation and Park District 382 | Special District 4 | Recreation/Parks District 4 | Kern 36 | 37.231 | Polo Community Park | 0 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);