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 UNIT_ID descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3584 | 3584 | 3583 | {"type": "Polygon", "coordinates": [[[-119.17467, 34.27812], [-119.17461, 34.27816], [-119.17442, 34.27794], [-119.17446, 34.27792], [-119.1745, 34.27793], [-119.17467, 34.27812]]]} | Open Access 1 | 36691 | Ventura holding 106 | 26859 | 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.046 | Ventura holding 106 | 0 | Local Other or Unknown 14 | 4 | |
13988 | 13988 | 13987 | {"type": "Polygon", "coordinates": [[[-119.17705, 34.27796], [-119.17699, 34.27793], [-119.17693, 34.27794], [-119.17623, 34.27829], [-119.17578, 34.27854], [-119.17577, 34.27853], [-119.17622, 34.27828], [-119.17693, 34.27792], [-119.177, 34.27792], [-119.17705, 34.27796]]]} | Open Access 1 | 36671 | Ventura holding 115 | 26869 | 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 115 | 0 | Local Other or Unknown 14 | 4 | |
13978 | 13978 | 13977 | {"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 | 36645 | Ventura holding 4 | 26918 | 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.422 | Ventura holding 4 | 0 | Local Other or Unknown 14 | 4 | |
13950 | 13950 | 13949 | {"type": "Polygon", "coordinates": [[[-119.30362, 34.29574], [-119.3034, 34.29607], [-119.30138, 34.29859], [-119.30112, 34.29895], [-119.30099, 34.29893], [-119.30127, 34.29853], [-119.30318, 34.29613], [-119.30334, 34.2959], [-119.30346, 34.29571], [-119.30362, 34.29574]]]} | Open Access 1 | 36581 | Ventura holding 129 | 26884 | 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.293 | Ventura holding 129 | 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 | |
13931 | 13931 | 13930 | {"type": "Polygon", "coordinates": [[[-119.17513, 34.27798], [-119.17494, 34.27809], [-119.17486, 34.27808], [-119.1748, 34.27804], [-119.17505, 34.27789], [-119.17513, 34.27798]]]} | Open Access 1 | 36537 | Ventura holding 124 | 26879 | 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.075 | Ventura holding 124 | 0 | Local Other or Unknown 14 | 4 | |
13366 | 13366 | 13365 | {"type": "Polygon", "coordinates": [[[-119.23078, 34.26794], [-119.23067, 34.26801], [-119.23012, 34.26824], [-119.22828, 34.26888], [-119.22827, 34.26888], [-119.22763, 34.26905], [-119.22708, 34.26919], [-119.22632, 34.26934], [-119.22629, 34.26922], [-119.22652, 34.26918], [-119.22658, 34.26907], [-119.22667, 34.26907], [-119.22675, 34.26904], [-119.22688, 34.26911], [-119.2273, 34.26901], [-119.22734, 34.26895], [-119.22745, 34.26896], [-119.22751, 34.26894], [-119.22755, 34.2689], [-119.22764, 34.26892], [-119.22785, 34.26888], [-119.22807, 34.26881], [-119.2281, 34.26874], [-119.2282, 34.26874], [-119.2283, 34.26866], [-119.22831, 34.2686], [-119.22844, 34.26854], [-119.22876, 34.26844], [-119.22962, 34.26828], [-119.22984, 34.26822], [-119.23014, 34.26806], [-119.23028, 34.26803], [-119.23073, 34.26776], [-119.23078, 34.26794]]]} | Open Access 1 | 35450 | Ventura holding 83 | 26966 | 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.931 | Ventura holding 83 | 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 | |
13362 | 13362 | 13361 | {"type": "Polygon", "coordinates": [[[-119.19348, 34.28277], [-119.19345, 34.28278], [-119.19343, 34.28277], [-119.19323, 34.28259], [-119.19307, 34.28242], [-119.1929, 34.28221], [-119.19282, 34.28219], [-119.19258, 34.28229], [-119.19281, 34.28217], [-119.19293, 34.2822], [-119.19318, 34.28249], [-119.19348, 34.28277]]]} | Open Access 1 | 35446 | Ventura holding 79 | 26961 | 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.08 | Ventura holding 79 | 0 | Local Other or Unknown 14 | 4 | |
13361 | 13361 | 13360 | {"type": "Polygon", "coordinates": [[[-119.19127, 34.28332], [-119.19124, 34.28332], [-119.19122, 34.28329], [-119.19114, 34.28307], [-119.19106, 34.28291], [-119.19085, 34.28263], [-119.19087, 34.28254], [-119.19111, 34.28247], [-119.19115, 34.28247], [-119.19089, 34.28255], [-119.19087, 34.28261], [-119.19112, 34.28294], [-119.19121, 34.28313], [-119.19127, 34.28332]]]} | Open Access 1 | 35445 | Ventura holding 80 | 26963 | 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.086 | Ventura holding 80 | 0 | Local Other or Unknown 14 | 4 | |
13360 | 13360 | 13359 | {"type": "Polygon", "coordinates": [[[-119.19154, 34.28157], [-119.1914, 34.28159], [-119.1912, 34.28156], [-119.19077, 34.28162], [-119.19065, 34.28177], [-119.19075, 34.28225], [-119.19076, 34.28228], [-119.19073, 34.28229], [-119.1906, 34.28169], [-119.19062, 34.28163], [-119.19066, 34.28161], [-119.19118, 34.28153], [-119.1914, 34.28156], [-119.19154, 34.28155], [-119.19154, 34.28157]]]} | Open Access 1 | 35444 | Ventura holding 81 | 26964 | 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.144 | Ventura holding 81 | 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 | |
13358 | 13358 | 13357 | {"type": "Polygon", "coordinates": [[[-119.19275, 34.28192], [-119.19271, 34.28193], [-119.1926, 34.28171], [-119.19254, 34.28155], [-119.19235, 34.28146], [-119.19161, 34.28157], [-119.19154, 34.28157], [-119.19154, 34.28155], [-119.19249, 34.28142], [-119.19255, 34.28146], [-119.19264, 34.28171], [-119.19275, 34.28192]]]} | Open Access 1 | 35442 | Ventura holding 89 | 26972 | 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 89 | 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 | |
276 | 276 | 275 | {"type": "Polygon", "coordinates": [[[-119.17054, 34.28047], [-119.17066, 34.2806], [-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.16748, 34.28234], [-119.16892, 34.28149], [-119.16889, 34.28144], [-119.17054, 34.28047]]]} | Open Access 1 | 35440 | Ventura holding 72 | 26954 | 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.844 | Ventura holding 72 | 0 | Local Other or Unknown 14 | 4 | |
275 | 275 | 274 | {"type": "Polygon", "coordinates": [[[-119.19704, 34.28676], [-119.1969, 34.28706], [-119.19612, 34.28715], [-119.19612, 34.28713], [-119.19635, 34.28707], [-119.19658, 34.28696], [-119.19673, 34.28683], [-119.19685, 34.28668], [-119.19704, 34.28676]]]} | Open Access 1 | 35439 | Ventura holding 73 | 26955 | 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.367 | Ventura holding 73 | 0 | Local Other or Unknown 14 | 4 | |
4990 | 4990 | 4989 | {"type": "Polygon", "coordinates": [[[-119.19623, 34.28781], [-119.19547, 34.28778], [-119.19543, 34.28773], [-119.19535, 34.28731], [-119.19537, 34.28731], [-119.19544, 34.28773], [-119.19547, 34.28777], [-119.19623, 34.2878], [-119.19623, 34.28781]]]} | Open Access 1 | 35438 | Ventura holding 71 | 26953 | 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.047 | Ventura holding 71 | 0 | Local Other or Unknown 14 | 4 | |
7777 | 7777 | 7776 | {"type": "Polygon", "coordinates": [[[-119.19536, 34.28728], [-119.19535, 34.28728], [-119.1952, 34.28644], [-119.19521, 34.28644], [-119.19536, 34.28728]]]} | Open Access 1 | 35437 | Ventura holding 70 | 26952 | 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.035 | Ventura holding 70 | 0 | Local Other or Unknown 14 | 4 | |
13357 | 13357 | 13356 | {"type": "Polygon", "coordinates": [[[-119.2163, 34.26751], [-119.2162, 34.26752], [-119.21568, 34.26504], [-119.21578, 34.26503], [-119.2163, 34.26751]]]} | Open Access 1 | 35436 | Ventura holding 69 | 26950 | 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.632 | Ventura holding 69 | 0 | Local Other or Unknown 14 | 4 | |
13356 | 13356 | 13355 | {"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.26196], [-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 | 35435 | Ventura holding 61 | 26942 | 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.992 | Ventura holding 61 | 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]);