superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
149 rows where ACCESS_TYP = 1 and MNG_AGENCY = 110 sorted by ACRES
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10738 | 10738 | 10737 | {"type": "Polygon", "coordinates": [[[-119.19521, 34.28644], [-119.19519, 34.28644], [-119.19511, 34.28596], [-119.19513, 34.28596], [-119.19521, 34.28644]]]} | Open Access 1 | Ventura holding 58 | 26938 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.019 | Ventura holding 58 | ||
10717 | 10717 | 10716 | {"type": "Polygon", "coordinates": [[[-119.19475, 34.28398], [-119.19474, 34.28399], [-119.19465, 34.28374], [-119.19455, 34.28353], [-119.19456, 34.28346], [-119.19456, 34.28351], [-119.19469, 34.28379], [-119.19475, 34.28398]]]} | Open Access 1 | Ventura holding 22 | 26899 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.021 | Ventura holding 22 | ||
10741 | 10741 | 10740 | {"type": "Polygon", "coordinates": [[[-119.1911, 34.28234], [-119.19106, 34.28236], [-119.19083, 34.28244], [-119.19075, 34.28238], [-119.19073, 34.28229], [-119.19076, 34.28229], [-119.19078, 34.28238], [-119.19083, 34.28242], [-119.1911, 34.28234]]]} | Open Access 1 | Ventura holding 60 | 26941 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.022 | Ventura holding 60 | ||
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 | ||
10685 | 10685 | 10684 | {"type": "Polygon", "coordinates": [[[-119.1914, 34.28159], [-119.19124, 34.2816], [-119.1908, 34.28162], [-119.1912, 34.28156], [-119.1914, 34.28159]]]} | Open Access 1 | Ventura holding 107 | 26860 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.034 | Ventura holding 107 | ||
10730 | 10730 | 10729 | {"type": "Polygon", "coordinates": [[[-119.19432, 34.28316], [-119.19407, 34.28287], [-119.1938, 34.28262], [-119.19379, 34.28258], [-119.1938, 34.28256], [-119.19381, 34.28257], [-119.1938, 34.28259], [-119.19382, 34.28261], [-119.19402, 34.2828], [-119.19421, 34.283], [-119.19431, 34.28313], [-119.19432, 34.28316]]]} | Open Access 1 | Ventura holding 5 | 26929 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.034 | Ventura holding 5 | ||
10751 | 10751 | 10750 | {"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 | Ventura holding 70 | 26952 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.035 | Ventura holding 70 | ||
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 | ||
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 | ||
10684 | 10684 | 10683 | {"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 | Ventura holding 106 | 26859 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.046 | Ventura holding 106 | ||
10752 | 10752 | 10751 | {"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 | Ventura holding 71 | 26953 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.048 | Ventura holding 71 | ||
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 | ||
10695 | 10695 | 10694 | {"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 | Ventura holding 115 | 26869 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.051 | Ventura holding 115 | ||
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 | ||
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 | ||
10747 | 10747 | 10746 | {"type": "Polygon", "coordinates": [[[-119.19505, 34.28555], [-119.19504, 34.28555], [-119.19479, 34.28417], [-119.1948, 34.28417], [-119.19481, 34.28421], [-119.19505, 34.28555]]]} | Open Access 1 | Ventura holding 86 | 26969 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.061 | Ventura holding 86 | ||
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 | ||
10750 | 10750 | 10749 | {"type": "Polygon", "coordinates": [[[-119.19041, 34.28172], [-119.1904, 34.28172], [-119.19036, 34.28168], [-119.19031, 34.28167], [-119.18902, 34.28186], [-119.18883, 34.28188], [-119.18882, 34.28187], [-119.19032, 34.28166], [-119.19038, 34.28167], [-119.19041, 34.28172]]]} | Open Access 1 | Ventura holding 7 | 26951 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.067 | Ventura holding 7 | ||
10777 | 10777 | 10776 | {"type": "Polygon", "coordinates": [[[-119.18424, 34.28252], [-119.18342, 34.28264], [-119.18296, 34.28272], [-119.18242, 34.28286], [-119.18238, 34.2829], [-119.18239, 34.28295], [-119.18238, 34.28296], [-119.18236, 34.28293], [-119.18237, 34.28288], [-119.18241, 34.28285], [-119.18296, 34.28271], [-119.18351, 34.28261], [-119.18423, 34.28251], [-119.18424, 34.28252]]]} | Open Access 1 | Ventura holding 98 | 26982 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.069 | Ventura holding 98 | ||
10704 | 10704 | 10703 | {"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 | Ventura holding 124 | 26879 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.075 | Ventura holding 124 |
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]);