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 149
- Restricted Access 2
MNG_AG_TYP 1
- City Agency 151
MNG_AGENCY 1
- Ventura, City of · 151 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10718 | 10718 | 10717 | {"type": "MultiPolygon", "coordinates": [[[[-119.16711, 34.29606], [-119.16689, 34.29642], [-119.16663, 34.29626], [-119.16704, 34.29601], [-119.1671, 34.29603], [-119.16711, 34.29606]]], [[[-119.17126, 34.29776], [-119.17115, 34.29781], [-119.17065, 34.29785], [-119.16878, 34.29733], [-119.16789, 34.29698], [-119.16705, 34.29652], [-119.16729, 34.29613], [-119.16735, 34.29611], [-119.16747, 34.29618], [-119.16757, 34.29627], [-119.16782, 34.29657], [-119.16794, 34.29665], [-119.16809, 34.29673], [-119.1704, 34.2975], [-119.17106, 34.29753], [-119.17126, 34.29776]]]]} | Open Access 1 | Ventura holding 23 | 26900 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 3.835 | Ventura holding 23 | ||
11724 | 11724 | 11723 | {"type": "MultiPolygon", "coordinates": [[[[-119.2706, 34.25499], [-119.27035, 34.25506], [-119.27018, 34.25466], [-119.27042, 34.25458], [-119.2706, 34.25499]]], [[[-119.27083, 34.25554], [-119.27058, 34.25561], [-119.27036, 34.25508], [-119.27061, 34.25501], [-119.27083, 34.25554]]], [[[-119.27122, 34.25601], [-119.27109, 34.25605], [-119.27045, 34.25457], [-119.27049, 34.25456], [-119.2705, 34.2546], [-119.27081, 34.25533], [-119.27117, 34.25591], [-119.27122, 34.25601]]], [[[-119.27105, 34.25606], [-119.27081, 34.25613], [-119.27059, 34.25563], [-119.27084, 34.25556], [-119.27105, 34.25606]]]]} | Open Access 1 | City Beach | 30410 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1.236 | City Beach | ||
14339 | 14339 | 14338 | {"type": "MultiPolygon", "coordinates": [[[[-119.29299, 34.28177], [-119.29297, 34.28184], [-119.29281, 34.28191], [-119.29269, 34.28203], [-119.29249, 34.28203], [-119.29249, 34.28177], [-119.29299, 34.28177]]], [[[-119.29359, 34.28203], [-119.29355, 34.28202], [-119.29343, 34.2819], [-119.29328, 34.28185], [-119.29326, 34.28181], [-119.29325, 34.28176], [-119.29359, 34.28175], [-119.29359, 34.28203]]]]} | Open Access 1 | Unknown park - Ventura, City of | 30393 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.372 | |||
10705 | 10705 | 10704 | {"type": "Polygon", "coordinates": [[[-119.15013, 34.27654], [-119.15013, 34.27655], [-119.15007, 34.27656], [-119.15004, 34.27659], [-119.14986, 34.27736], [-119.14985, 34.27734], [-119.15003, 34.27659], [-119.15007, 34.27654], [-119.15013, 34.27654]]]} | Open Access 1 | Ventura holding 125 | 26880 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.037 | Ventura holding 125 | ||
10698 | 10698 | 10697 | {"type": "Polygon", "coordinates": [[[-119.15094, 34.27517], [-119.15067, 34.27547], [-119.15043, 34.27579], [-119.1503, 34.27601], [-119.15018, 34.27624], [-119.15015, 34.27633], [-119.15016, 34.27636], [-119.15019, 34.27638], [-119.15019, 34.27639], [-119.15016, 34.27638], [-119.15013, 34.27635], [-119.15013, 34.2763], [-119.15025, 34.27606], [-119.15042, 34.27578], [-119.1507, 34.27541], [-119.15093, 34.27517], [-119.15094, 34.27517]]]} | Open Access 1 | Ventura holding 118 | 26872 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.058 | Ventura holding 118 | ||
10691 | 10691 | 10690 | {"type": "Polygon", "coordinates": [[[-119.15329, 34.27338], [-119.15139, 34.2745], [-119.15103, 34.27476], [-119.1507, 34.27506], [-119.15037, 34.27543], [-119.15006, 34.2759], [-119.14991, 34.2762], [-119.14981, 34.27645], [-119.14964, 34.2771], [-119.14959, 34.27705], [-119.14975, 34.27644], [-119.14985, 34.27618], [-119.14997, 34.27594], [-119.15011, 34.27569], [-119.15027, 34.27546], [-119.15045, 34.27524], [-119.15065, 34.27502], [-119.15104, 34.27468], [-119.15141, 34.27442], [-119.15312, 34.27342], [-119.15329, 34.27337], [-119.15329, 34.27338]]]} | Open Access 1 | Ventura holding 111 | 26865 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.783 | Ventura holding 111 | ||
10733 | 10733 | 10732 | {"type": "Polygon", "coordinates": [[[-119.15826, 34.27089], [-119.15766, 34.27124], [-119.15716, 34.27146], [-119.15714, 34.27145], [-119.15759, 34.27126], [-119.15821, 34.2709], [-119.15826, 34.27089]]]} | Open Access 1 | Ventura holding 53 | 26933 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.045 | Ventura holding 53 | ||
10719 | 10719 | 10718 | {"type": "Polygon", "coordinates": [[[-119.15891, 34.27015], [-119.15868, 34.27037], [-119.15769, 34.27095], [-119.15734, 34.27113], [-119.15699, 34.27128], [-119.15697, 34.27125], [-119.15704, 34.2712], [-119.15731, 34.2711], [-119.15757, 34.27096], [-119.15795, 34.2707], [-119.15891, 34.27015]]]} | Open Access 1 | Ventura holding 24 | 26901 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.342 | Ventura holding 24 | ||
10682 | 10682 | 10681 | {"type": "Polygon", "coordinates": [[[-119.15969, 34.27006], [-119.15962, 34.2701], [-119.15848, 34.27077], [-119.15851, 34.27073], [-119.15963, 34.27008], [-119.15969, 34.27006]]]} | Open Access 1 | Ventura holding 104 | 26857 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.051 | Ventura holding 104 | ||
10721 | 10721 | 10720 | {"type": "Polygon", "coordinates": [[[-119.16001, 34.26964], [-119.15957, 34.26985], [-119.15868, 34.27037], [-119.15891, 34.27015], [-119.15983, 34.2696], [-119.15993, 34.26959], [-119.16001, 34.26964]]]} | Open Access 1 | Ventura holding 26 | 26903 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.295 | Ventura holding 26 | ||
4435 | 4435 | 4434 | {"type": "Polygon", "coordinates": [[[-119.16005, 34.28166], [-119.15737, 34.28294], [-119.15581, 34.28113], [-119.15703, 34.28038], [-119.15823, 34.27967], [-119.15829, 34.27965], [-119.15835, 34.27968], [-119.16005, 34.28166]]]} | Open Access 1 | Fritz Huntsinger Youth Complex | 19129 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 18.355 | Fritz Huntsinger Youth Complex | ||
10764 | 10764 | 10763 | {"type": "Polygon", "coordinates": [[[-119.16104, 34.2693], [-119.16057, 34.2694], [-119.16054, 34.26934], [-119.16099, 34.26909], [-119.16104, 34.2693]]]} | Open Access 1 | Ventura holding 82 | 26965 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.179 | Ventura holding 82 | ||
10720 | 10720 | 10719 | {"type": "Polygon", "coordinates": [[[-119.16277, 34.26987], [-119.16227, 34.2702], [-119.16213, 34.26993], [-119.16213, 34.26993], [-119.16277, 34.26987]]]} | Open Access 1 | Ventura holding 25 | 26902 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.229 | Ventura holding 25 | ||
10766 | 10766 | 10765 | {"type": "Polygon", "coordinates": [[[-119.16402, 34.26635], [-119.16385, 34.26637], [-119.16372, 34.26644], [-119.16282, 34.26747], [-119.16251, 34.2678], [-119.16205, 34.26825], [-119.16157, 34.2687], [-119.16099, 34.26909], [-119.16055, 34.26934], [-119.16056, 34.2694], [-119.16043, 34.26944], [-119.16041, 34.26935], [-119.16045, 34.26929], [-119.16078, 34.26907], [-119.16111, 34.26887], [-119.16175, 34.26841], [-119.16204, 34.26813], [-119.16259, 34.26754], [-119.1629, 34.26729], [-119.163, 34.26716], [-119.16328, 34.26671], [-119.1636, 34.26628], [-119.16368, 34.26625], [-119.16375, 34.26624], [-119.16402, 34.26635]]]} | Open Access 1 | Ventura holding 84 | 26967 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1.392 | Ventura holding 84 | ||
10759 | 10759 | 10758 | {"type": "Polygon", "coordinates": [[[-119.16407, 34.29454], [-119.16386, 34.29466], [-119.16329, 34.294], [-119.1635, 34.29388], [-119.16407, 34.29454]]]} | Open Access 1 | Ventura holding 78 | 26960 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.529 | Ventura holding 78 | ||
10681 | 10681 | 10680 | {"type": "Polygon", "coordinates": [[[-119.16472, 34.26835], [-119.16471, 34.26838], [-119.16443, 34.26854], [-119.16407, 34.26872], [-119.16369, 34.26887], [-119.1633, 34.26899], [-119.16289, 34.26908], [-119.16193, 34.2692], [-119.16188, 34.26918], [-119.16289, 34.26905], [-119.16329, 34.26896], [-119.16368, 34.26884], [-119.16405, 34.26869], [-119.16441, 34.26852], [-119.16466, 34.26837], [-119.16468, 34.26834], [-119.16467, 34.2683], [-119.16449, 34.26812], [-119.16453, 34.26813], [-119.16471, 34.26833], [-119.16472, 34.26835]]]} | Open Access 1 | Ventura holding 103 | 26856 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.226 | Ventura holding 103 | ||
10702 | 10702 | 10701 | {"type": "Polygon", "coordinates": [[[-119.16488, 34.29512], [-119.16458, 34.2953], [-119.16445, 34.29515], [-119.1643, 34.29509], [-119.16413, 34.29494], [-119.16392, 34.2948], [-119.16386, 34.29466], [-119.16407, 34.29454], [-119.16488, 34.29512]]]} | Open Access 1 | Ventura holding 122 | 26877 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.731 | Ventura holding 122 | ||
10679 | 10679 | 10678 | {"type": "Polygon", "coordinates": [[[-119.16516, 34.26881], [-119.16499, 34.26864], [-119.16492, 34.26863], [-119.16465, 34.26879], [-119.16388, 34.26916], [-119.16322, 34.26952], [-119.16279, 34.26941], [-119.16126, 34.26959], [-119.16098, 34.26984], [-119.16101, 34.27013], [-119.16059, 34.26969], [-119.16097, 34.2696], [-119.16253, 34.26941], [-119.16297, 34.26935], [-119.1634, 34.26925], [-119.16382, 34.26912], [-119.16422, 34.26896], [-119.16461, 34.26877], [-119.16494, 34.26859], [-119.16498, 34.2686], [-119.16515, 34.26878], [-119.16516, 34.26881]]]} | Open Access 1 | Ventura holding 101 | 26854 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.917 | Ventura holding 101 | ||
1241 | 1241 | 1240 | {"type": "Polygon", "coordinates": [[[-119.16534, 34.2838], [-119.16455, 34.28426], [-119.16452, 34.28422], [-119.1653, 34.28375], [-119.16534, 34.2838]]]} | Open Access 1 | Ventura holding 87 | 26970 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.134 | Ventura holding 87 | ||
10688 | 10688 | 10687 | {"type": "Polygon", "coordinates": [[[-119.16591, 34.26726], [-119.16557, 34.26764], [-119.16558, 34.26762], [-119.16556, 34.26758], [-119.16534, 34.26744], [-119.16518, 34.26744], [-119.16512, 34.26735], [-119.16408, 34.26651], [-119.16396, 34.26647], [-119.16386, 34.26649], [-119.16379, 34.26653], [-119.16292, 34.26753], [-119.16258, 34.26789], [-119.16196, 34.26849], [-119.16186, 34.26861], [-119.16178, 34.26875], [-119.16172, 34.2689], [-119.16171, 34.26905], [-119.16172, 34.26922], [-119.16105, 34.2693], [-119.16099, 34.26909], [-119.16157, 34.2687], [-119.16205, 34.26825], [-119.16282, 34.26747], [-119.16372, 34.26644], [-119.16382, 34.26638], [-119.16402, 34.26635], [-119.16415, 34.26642], [-119.16442, 34.26626], [-119.16503, 34.26697], [-119.16591, 34.26726]]]} | Open Access 1 | Ventura holding 11 | 26863 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 3.413 | Ventura holding 11 |
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]);