superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
151 rows where MNG_AGENCY = 110 sorted by map
This data as json, copyable, CSV (advanced)
ACCESS_TYP 2
- Open Access 129
- Restricted Access 2
MNG_AG_TYP 1
- City Agency 131
MNG_AGENCY 1
- Ventura, City of · 131 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10743 | 10743 | 10742 | {"type": "Polygon", "coordinates": [[[-119.16594, 34.26727], [-119.16553, 34.26773], [-119.16525, 34.26799], [-119.16494, 34.26823], [-119.16488, 34.26823], [-119.16468, 34.26802], [-119.16467, 34.268], [-119.16486, 34.26819], [-119.16494, 34.26819], [-119.16525, 34.26795], [-119.16552, 34.26769], [-119.16591, 34.26726], [-119.16594, 34.26727]]]} | Open Access 1 | Ventura holding 62 | 26943 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.121 | Ventura holding 62 | ||
10770 | 10770 | 10769 | {"type": "Polygon", "coordinates": [[[-119.16634, 34.29607], [-119.16607, 34.29624], [-119.16596, 34.29619], [-119.16577, 34.29615], [-119.16539, 34.29594], [-119.16519, 34.29578], [-119.16492, 34.29545], [-119.16475, 34.29542], [-119.16458, 34.2953], [-119.16488, 34.29512], [-119.16528, 34.29542], [-119.16634, 34.29607]]]} | Open Access 1 | Ventura holding 9 | 26973 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1.438 | Ventura holding 9 | ||
10775 | 10775 | 10774 | {"type": "Polygon", "coordinates": [[[-119.16635, 34.26389], [-119.16519, 34.26459], [-119.16502, 34.26471], [-119.16482, 34.26489], [-119.16434, 34.26543], [-119.16427, 34.26549], [-119.16421, 34.26561], [-119.16421, 34.26569], [-119.16426, 34.26578], [-119.16434, 34.26585], [-119.16477, 34.26636], [-119.16504, 34.2666], [-119.16527, 34.26674], [-119.16561, 34.2669], [-119.1657, 34.26691], [-119.16577, 34.2669], [-119.1659, 34.26683], [-119.16615, 34.26702], [-119.16593, 34.26727], [-119.16504, 34.26697], [-119.16402, 34.26581], [-119.16411, 34.2656], [-119.16436, 34.26534], [-119.16444, 34.26513], [-119.16455, 34.26502], [-119.16479, 34.26487], [-119.16484, 34.26469], [-119.16556, 34.26419], [-119.1657, 34.26396], [-119.16584, 34.2639], [-119.16612, 34.26396], [-119.1662, 34.26389], [-119.16635, 34.26389]]]} | Open Access 1 | Ventura holding 96 | 26980 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 2.503 | Ventura holding 96 | ||
10726 | 10726 | 10725 | {"type": "Polygon", "coordinates": [[[-119.16687, 34.2964], [-119.16665, 34.29659], [-119.1664, 34.29639], [-119.16607, 34.29624], [-119.16634, 34.29607], [-119.16687, 34.2964]]]} | Open Access 1 | Ventura holding 4 | 26918 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.422 | Ventura holding 4 | ||
9206 | 9206 | 9205 | {"type": "Polygon", "coordinates": [[[-119.16693, 34.29644], [-119.16693, 34.29644], [-119.16679, 34.29676], [-119.16665, 34.2966], [-119.16687, 34.2964], [-119.16693, 34.29644]]]} | Open Access 1 | Ventura holding 10 | 26852 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.109 | Ventura holding 10 | ||
10724 | 10724 | 10723 | {"type": "Polygon", "coordinates": [[[-119.16702, 34.26824], [-119.16696, 34.26827], [-119.16664, 34.26795], [-119.1666, 34.26795], [-119.16651, 34.26801], [-119.16647, 34.26797], [-119.16654, 34.26792], [-119.16654, 34.26787], [-119.16633, 34.26771], [-119.16619, 34.26764], [-119.16615, 34.26766], [-119.16542, 34.26827], [-119.16518, 34.26846], [-119.16517, 34.26849], [-119.16518, 34.26852], [-119.16535, 34.2687], [-119.16531, 34.26868], [-119.16513, 34.26848], [-119.16514, 34.26845], [-119.16547, 34.26819], [-119.16577, 34.26792], [-119.16608, 34.26758], [-119.16612, 34.26756], [-119.16617, 34.26757], [-119.16651, 34.2678], [-119.16702, 34.26824]]]} | Open Access 1 | Ventura holding 27 | 26904 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.325 | Ventura holding 27 | ||
10776 | 10776 | 10775 | {"type": "Polygon", "coordinates": [[[-119.16704, 34.29601], [-119.16663, 34.29625], [-119.16528, 34.29542], [-119.16408, 34.29455], [-119.1635, 34.29388], [-119.16364, 34.2938], [-119.16372, 34.29381], [-119.16398, 34.29415], [-119.16414, 34.29431], [-119.1646, 34.29464], [-119.16496, 34.2948], [-119.1651, 34.29489], [-119.16566, 34.29542], [-119.16603, 34.29569], [-119.1662, 34.29578], [-119.16643, 34.29587], [-119.16704, 34.29601]]]} | Open Access 1 | Ventura holding 97 | 26981 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 2.39 | Ventura holding 97 | ||
10687 | 10687 | 10686 | {"type": "Polygon", "coordinates": [[[-119.16787, 34.29732], [-119.16767, 34.29729], [-119.16753, 34.29719], [-119.1674, 34.29701], [-119.16719, 34.29692], [-119.16695, 34.29688], [-119.1671, 34.29655], [-119.16778, 34.29692], [-119.16762, 34.29703], [-119.16787, 34.29732]]]} | Open Access 1 | Ventura holding 109 | 26862 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.641 | Ventura holding 109 | ||
10757 | 10757 | 10756 | {"type": "Polygon", "coordinates": [[[-119.16815, 34.26985], [-119.16812, 34.2699], [-119.16807, 34.26992], [-119.16795, 34.26969], [-119.16759, 34.26971], [-119.16764, 34.26951], [-119.16761, 34.26912], [-119.16777, 34.26901], [-119.16759, 34.2688], [-119.16764, 34.26882], [-119.16772, 34.2689], [-119.16789, 34.26915], [-119.16815, 34.26985]]]} | Open Access 1 | Ventura holding 76 | 26958 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.666 | Ventura holding 76 | ||
9238 | 9238 | 9237 | {"type": "Polygon", "coordinates": [[[-119.16877, 34.27064], [-119.16876, 34.27067], [-119.16858, 34.27046], [-119.16824, 34.27065], [-119.16814, 34.27064], [-119.16805, 34.2704], [-119.16835, 34.2703], [-119.16825, 34.27004], [-119.1683, 34.27007], [-119.16877, 34.27064]]]} | Open Access 1 | Ventura holding 91 | 26975 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.376 | Ventura holding 91 | ||
10696 | 10696 | 10695 | {"type": "Polygon", "coordinates": [[[-119.16894, 34.26278], [-119.16757, 34.26339], [-119.16711, 34.26351], [-119.16688, 34.26359], [-119.16669, 34.26368], [-119.16635, 34.26389], [-119.16625, 34.26365], [-119.16678, 34.26348], [-119.16717, 34.26347], [-119.16737, 34.26339], [-119.16798, 34.26302], [-119.16863, 34.26273], [-119.16894, 34.26278]]]} | Open Access 1 | Ventura holding 116 | 26870 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.922 | Ventura holding 116 | ||
10737 | 10737 | 10736 | {"type": "Polygon", "coordinates": [[[-119.17022, 34.27214], [-119.17019, 34.27219], [-119.17012, 34.27215], [-119.17004, 34.27207], [-119.17003, 34.27202], [-119.16991, 34.27195], [-119.16982, 34.27188], [-119.16977, 34.27181], [-119.1697, 34.27177], [-119.16966, 34.27171], [-119.16967, 34.27168], [-119.16914, 34.2712], [-119.16898, 34.2711], [-119.16903, 34.27105], [-119.16885, 34.27084], [-119.16891, 34.27083], [-119.16895, 34.27085], [-119.1694, 34.27137], [-119.1702, 34.27209], [-119.17022, 34.27214]]]} | Open Access 1 | Ventura holding 57 | 26937 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.347 | Ventura holding 57 | ||
10753 | 10753 | 10752 | {"type": "Polygon", "coordinates": [[[-119.17066, 34.28063], [-119.17064, 34.28066], [-119.16734, 34.28261], [-119.16727, 34.2826], [-119.16717, 34.28249], [-119.16745, 34.28232], [-119.16749, 34.28234], [-119.16891, 34.28149], [-119.16889, 34.28144], [-119.17054, 34.28047], [-119.17066, 34.2806], [-119.17066, 34.28063]]]} | Open Access 1 | Ventura holding 72 | 26954 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1.845 | Ventura holding 72 | ||
10716 | 10716 | 10715 | {"type": "Polygon", "coordinates": [[[-119.17111, 34.29781], [-119.16993, 34.29836], [-119.16972, 34.2979], [-119.16943, 34.29782], [-119.16936, 34.29791], [-119.16924, 34.29786], [-119.16889, 34.29766], [-119.16883, 34.29757], [-119.16876, 34.29753], [-119.16869, 34.29752], [-119.16861, 34.29754], [-119.16848, 34.29745], [-119.16804, 34.29733], [-119.16793, 34.29739], [-119.16761, 34.29702], [-119.16778, 34.29692], [-119.16789, 34.29698], [-119.16878, 34.29733], [-119.17064, 34.29785], [-119.17111, 34.29781]]]} | Open Access 1 | Ventura holding 21 | 26898 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 2.734 | Ventura holding 21 | ||
10742 | 10742 | 10741 | {"type": "Polygon", "coordinates": [[[-119.17171, 34.26141], [-119.17078, 34.26174], [-119.16998, 34.26209], [-119.16971, 34.26225], [-119.16923, 34.26261], [-119.16894, 34.26278], [-119.16899, 34.26252], [-119.1693, 34.26229], [-119.16965, 34.26213], [-119.16981, 34.26209], [-119.17005, 34.26194], [-119.1702, 34.26195], [-119.17031, 34.26178], [-119.17042, 34.26172], [-119.17071, 34.26167], [-119.17087, 34.26159], [-119.17108, 34.2616], [-119.17119, 34.26143], [-119.17139, 34.26134], [-119.17171, 34.26141]]]} | Open Access 1 | Ventura holding 61 | 26942 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.993 | Ventura holding 61 | ||
10758 | 10758 | 10757 | {"type": "Polygon", "coordinates": [[[-119.17247, 34.27956], [-119.17088, 34.28051], [-119.17082, 34.28051], [-119.17076, 34.28045], [-119.17142, 34.28005], [-119.1714, 34.27999], [-119.17235, 34.27942], [-119.17247, 34.27956]]]} | Open Access 1 | Ventura holding 77 | 26959 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.757 | Ventura holding 77 | ||
10709 | 10709 | 10708 | {"type": "Polygon", "coordinates": [[[-119.17251, 34.27173], [-119.17245, 34.27175], [-119.17223, 34.27152], [-119.17231, 34.27149], [-119.17251, 34.27173]]]} | Open Access 1 | Ventura holding 15 | 26891 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.054 | Ventura holding 15 | ||
10678 | 10678 | 10677 | {"type": "Polygon", "coordinates": [[[-119.17273, 34.27675], [-119.17269, 34.27683], [-119.17247, 34.27657], [-119.17253, 34.27654], [-119.17258, 34.27654], [-119.17272, 34.27669], [-119.17273, 34.27675]]]} | Open Access 1 | Ventura holding 100 | 26853 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.084 | Ventura holding 100 | ||
10663 | 10663 | 10662 | {"type": "Polygon", "coordinates": [[[-119.17299, 34.27661], [-119.17293, 34.27664], [-119.17289, 34.27663], [-119.17275, 34.27647], [-119.17274, 34.27641], [-119.17279, 34.27638], [-119.17299, 34.27661]]]} | Open Access 1 | Ventura holding 13 | 26885 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.067 | Ventura holding 13 | ||
10715 | 10715 | 10714 | {"type": "Polygon", "coordinates": [[[-119.17309, 34.26527], [-119.17306, 34.26529], [-119.17283, 34.26503], [-119.17286, 34.26501], [-119.17309, 34.26527]]]} | Open Access 1 | Ventura holding 20 | 26897 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.027 | Ventura holding 20 |
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]);