units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
106 rows where DES_TP = 14 and MNG_AGENCY = 110 sorted by map
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency 106
MNG_AGENCY 1
- Ventura, City of · 106 ✖
DES_TP 1
- Local Other or Unknown · 106 ✖
ACCESS_TYP 1
- Open Access 106
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13323 | 13323 | 13322 | {"type": "MultiPolygon", "coordinates": [[[[-119.16704, 34.29601], [-119.1671, 34.29603], [-119.16711, 34.29606], [-119.16689, 34.29642], [-119.16663, 34.29626], [-119.16704, 34.29601]]], [[[-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 | 35390 | Ventura holding 23 | 26900 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 3.835 | Ventura holding 23 | 0 | Local Other or Unknown 14 | 4 | |
4584 | 4584 | 4583 | {"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.2935, 34.28196], [-119.29342, 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 | 35403 | Unknown park - Ventura, City of | 30393 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.37 | 0 | Local Other or Unknown 14 | 4 | ||
13934 | 13934 | 13933 | {"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 | 36540 | Ventura holding 125 | 26880 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.036 | Ventura holding 125 | 0 | Local Other or Unknown 14 | 4 | |
13282 | 13282 | 13281 | {"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 | 35337 | Ventura holding 118 | 26872 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.058 | Ventura holding 118 | 0 | Local Other or Unknown 14 | 4 | |
13290 | 13290 | 13289 | {"type": "Polygon", "coordinates": [[[-119.15329, 34.27338], [-119.15139, 34.2745], [-119.15103, 34.27476], [-119.1507, 34.27506], [-119.15037, 34.27543], [-119.1502, 34.27566], [-119.15006, 34.2759], [-119.14991, 34.2762], [-119.14981, 34.27646], [-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 | 35344 | Ventura holding 111 | 26865 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.776 | Ventura holding 111 | 0 | Local Other or Unknown 14 | 4 | |
13351 | 13351 | 13350 | {"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 | 35430 | Ventura holding 53 | 26933 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.045 | Ventura holding 53 | 0 | Local Other or Unknown 14 | 4 | |
13322 | 13322 | 13321 | {"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 | 35389 | Ventura holding 24 | 26901 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.342 | Ventura holding 24 | 0 | Local Other or Unknown 14 | 4 | |
13252 | 13252 | 13251 | {"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 | 35297 | Ventura holding 104 | 26857 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.051 | Ventura holding 104 | 0 | Local Other or Unknown 14 | 4 | |
13326 | 13326 | 13325 | {"type": "Polygon", "coordinates": [[[-119.16001, 34.26964], [-119.15958, 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 | 35393 | Ventura holding 26 | 26903 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.295 | Ventura holding 26 | 0 | Local Other or Unknown 14 | 4 | |
13359 | 13359 | 13358 | {"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 | 35443 | Ventura holding 82 | 26965 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.179 | Ventura holding 82 | 0 | Local Other or Unknown 14 | 4 | |
13327 | 13327 | 13326 | {"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 | 35394 | Ventura holding 25 | 26902 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.229 | Ventura holding 25 | 0 | Local Other or Unknown 14 | 4 | |
13364 | 13364 | 13363 | {"type": "Polygon", "coordinates": [[[-119.16402, 34.26635], [-119.16385, 34.26637], [-119.16372, 34.26644], [-119.16282, 34.26747], [-119.16251, 34.2678], [-119.16206, 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.26888], [-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 | 35448 | Ventura holding 84 | 26967 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 1.391 | Ventura holding 84 | 0 | Local Other or Unknown 14 | 4 | |
3435 | 3435 | 3434 | {"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 | 35441 | Ventura holding 78 | 26960 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.529 | Ventura holding 78 | 0 | Local Other or Unknown 14 | 4 | |
13259 | 13259 | 13258 | {"type": "Polygon", "coordinates": [[[-119.16467, 34.2683], [-119.16449, 34.26812], [-119.16453, 34.26813], [-119.16471, 34.26833], [-119.16473, 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.26838], [-119.16468, 34.26834], [-119.16467, 34.2683]]]} | Open Access 1 | 35305 | Ventura holding 103 | 26856 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.226 | Ventura holding 103 | 0 | Local Other or Unknown 14 | 4 | |
13279 | 13279 | 13278 | {"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 | 35333 | Ventura holding 122 | 26877 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.731 | Ventura holding 122 | 0 | Local Other or Unknown 14 | 4 | |
13245 | 13245 | 13244 | {"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.16121, 34.26957], [-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 | 35304 | Ventura holding 101 | 26854 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.929 | Ventura holding 101 | 0 | Local Other or Unknown 14 | 4 | |
13241 | 13241 | 13240 | {"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 | 35285 | Ventura holding 87 | 26970 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.134 | Ventura holding 87 | 0 | Local Other or Unknown 14 | 4 | |
13299 | 13299 | 13298 | {"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.16407, 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.16177, 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.16206, 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.16504, 34.26697], [-119.16591, 34.26726]]]} | Open Access 1 | 35352 | Ventura holding 11 | 26863 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 3.411 | Ventura holding 11 | 0 | Local Other or Unknown 14 | 4 | |
13223 | 13223 | 13222 | {"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.16487, 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 | 35267 | Ventura holding 62 | 26943 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.12 | Ventura holding 62 | 0 | Local Other or Unknown 14 | 4 | |
13293 | 13293 | 13292 | {"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.29544], [-119.16475, 34.29542], [-119.16458, 34.2953], [-119.16488, 34.29512], [-119.16528, 34.29542], [-119.16634, 34.29607]]]} | Open Access 1 | 35347 | Ventura holding 9 | 26973 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 1.437 | Ventura holding 9 | 0 | Local Other or Unknown 14 | 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]);