units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
16 rows where AGNCY_NAME = 115, DES_TP = 14 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency · 16 ✖
MNG_AGENCY 1
DES_TP 1
- Local Other or Unknown · 16 ✖
ACCESS_TYP 1
- Open Access 16
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4823 | 4823 | 4822 | {"type": "Polygon", "coordinates": [[[-121.85423, 36.60375], [-121.85421, 36.60389], [-121.8541, 36.60397], [-121.85397, 36.60403], [-121.85384, 36.60403], [-121.85364, 36.60396], [-121.85332, 36.60388], [-121.85332, 36.60379], [-121.85381, 36.6038], [-121.85381, 36.60304], [-121.85394, 36.60302], [-121.85413, 36.60347], [-121.85423, 36.60375]]]} | Open Access 1 | 48915 | Unknown park - Seaside, City of | 33636 | 1330 | Seaside, City of 115 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | Monterey 14 | 0.936 | 0 | Local Other or Unknown 14 | 4 | ||
13202 | 13202 | 13201 | {"type": "Polygon", "coordinates": [[[-121.8188, 36.64408], [-121.81752, 36.645], [-121.81716, 36.64519], [-121.8167, 36.64538], [-121.81614, 36.64577], [-121.8157, 36.64624], [-121.81464, 36.64706], [-121.81306, 36.64751], [-121.81209, 36.64756], [-121.81208, 36.64729], [-121.81212, 36.64711], [-121.8122, 36.64695], [-121.81231, 36.64679], [-121.81314, 36.64588], [-121.81322, 36.64576], [-121.81327, 36.64563], [-121.81328, 36.64549], [-121.81331, 36.64427], [-121.81329, 36.64421], [-121.81326, 36.64417], [-121.81319, 36.64414], [-121.81313, 36.64413], [-121.81314, 36.64395], [-121.81695, 36.64406], [-121.8188, 36.64408]]]} | Open Access 1 | 35258 | Seaside holding 9 | 25265 | 1330 | Seaside, City of 115 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | Monterey 14 | 29.165 | Seaside holding 9 | 0 | Local Other or Unknown 14 | 4 | |
13214 | 13214 | 13213 | {"type": "Polygon", "coordinates": [[[-121.85017, 36.60253], [-121.84983, 36.60253], [-121.84975, 36.60252], [-121.85014, 36.60232], [-121.85018, 36.60235], [-121.85017, 36.60253]]]} | Open Access 1 | 35252 | Seaside holding 8 | 25264 | 1330 | Seaside, City of 115 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | Monterey 14 | 0.116 | Seaside holding 8 | 0 | Local Other or Unknown 14 | 4 | |
13215 | 13215 | 13214 | {"type": "Polygon", "coordinates": [[[-121.8525, 36.60939], [-121.85222, 36.60957], [-121.85222, 36.60957], [-121.85222, 36.60939], [-121.8525, 36.60939]]]} | Open Access 1 | 35253 | Seaside holding 5 | 25261 | 1330 | Seaside, City of 115 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | Monterey 14 | 0.062 | Seaside holding 5 | 0 | Local Other or Unknown 14 | 4 | |
13217 | 13217 | 13216 | {"type": "Polygon", "coordinates": [[[-121.8153, 36.65269], [-121.81444, 36.653], [-121.8144, 36.65172], [-121.8142, 36.65111], [-121.81379, 36.65064], [-121.8129, 36.64978], [-121.81267, 36.64929], [-121.81224, 36.6483], [-121.81216, 36.64786], [-121.8134, 36.64778], [-121.81395, 36.64798], [-121.81428, 36.64829], [-121.81433, 36.64865], [-121.81434, 36.64968], [-121.81445, 36.65052], [-121.81473, 36.65154], [-121.81503, 36.65218], [-121.8153, 36.65269]]]} | Open Access 1 | 35259 | Seaside holding 10 | 25252 | 1330 | Seaside, City of 115 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | Monterey 14 | 13.836 | Seaside holding 10 | 0 | Local Other or Unknown 14 | 4 | |
13239 | 13239 | 13238 | {"type": "Polygon", "coordinates": [[[-121.83969, 36.59906], [-121.83968, 36.59948], [-121.83818, 36.59945], [-121.83814, 36.59943], [-121.83812, 36.5994], [-121.83813, 36.59903], [-121.83969, 36.59906]]]} | Open Access 1 | 35283 | Seaside holding 11 | 25253 | 1330 | Seaside, City of 115 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | Monterey 14 | 1.606 | Seaside holding 11 | 0 | Local Other or Unknown 14 | 4 | |
13263 | 13263 | 13262 | {"type": "Polygon", "coordinates": [[[-121.82474, 36.61274], [-121.82474, 36.61301], [-121.82449, 36.613], [-121.82449, 36.61273], [-121.82474, 36.61274]]]} | Open Access 1 | 35311 | Seaside holding 13 | 25255 | 1330 | Seaside, City of 115 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | Monterey 14 | 0.167 | Seaside holding 13 | 0 | Local Other or Unknown 14 | 4 | |
13267 | 13267 | 13266 | {"type": "Polygon", "coordinates": [[[-121.84555, 36.59725], [-121.84553, 36.59808], [-121.84461, 36.59806], [-121.84464, 36.59723], [-121.84555, 36.59725]]]} | Open Access 1 | 35317 | Seaside holding 12 | 25254 | 1330 | Seaside, City of 115 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | Monterey 14 | 1.868 | Seaside holding 12 | 0 | Local Other or Unknown 14 | 4 | |
13269 | 13269 | 13268 | {"type": "Polygon", "coordinates": [[[-121.8558, 36.61097], [-121.85569, 36.61103], [-121.85525, 36.61148], [-121.85518, 36.61154], [-121.8552, 36.61062], [-121.85511, 36.61061], [-121.85512, 36.61031], [-121.85568, 36.61088], [-121.85571, 36.61087], [-121.8558, 36.61097]]]} | Open Access 1 | 35319 | Seaside holding 14 | 25256 | 1330 | Seaside, City of 115 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | Monterey 14 | 0.87 | Seaside holding 14 | 0 | Local Other or Unknown 14 | 4 | |
13280 | 13280 | 13279 | {"type": "Polygon", "coordinates": [[[-121.83311, 36.6034], [-121.83311, 36.6036], [-121.83284, 36.6036], [-121.83284, 36.60357], [-121.83291, 36.60355], [-121.83295, 36.6035], [-121.83293, 36.60345], [-121.83285, 36.6034], [-121.83311, 36.6034]]]} | Open Access 1 | 35334 | Seaside holding 15 | 25257 | 1330 | Seaside, City of 115 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | Monterey 14 | 0.102 | Seaside holding 15 | 0 | Local Other or Unknown 14 | 4 | |
13307 | 13307 | 13306 | {"type": "Polygon", "coordinates": [[[-121.79296, 36.64272], [-121.79296, 36.64377], [-121.78989, 36.64375], [-121.79123, 36.63952], [-121.79296, 36.64272]]]} | Open Access 1 | 35369 | Seaside holding 4 | 25260 | 1330 | Seaside, City of 115 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | Monterey 14 | 18.209 | Seaside holding 4 | 0 | Local Other or Unknown 14 | 4 | |
13309 | 13309 | 13308 | {"type": "Polygon", "coordinates": [[[-121.8332, 36.61336], [-121.83319, 36.61354], [-121.83312, 36.61357], [-121.83308, 36.61364], [-121.83283, 36.61363], [-121.83284, 36.61336], [-121.83258, 36.61335], [-121.83259, 36.61319], [-121.83248, 36.61312], [-121.83248, 36.61309], [-121.83259, 36.61317], [-121.83307, 36.61318], [-121.83316, 36.61316], [-121.83315, 36.61335], [-121.8332, 36.61336]]]} | Open Access 1 | 35371 | Seaside holding 2 | 25258 | 1330 | Seaside, City of 115 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | Monterey 14 | 0.486 | Seaside holding 2 | 0 | Local Other or Unknown 14 | 4 | |
13310 | 13310 | 13309 | {"type": "Polygon", "coordinates": [[[-121.83646, 36.61012], [-121.83646, 36.61018], [-121.83642, 36.61021], [-121.8364, 36.61026], [-121.83639, 36.61054], [-121.83615, 36.61054], [-121.83614, 36.61064], [-121.83589, 36.61064], [-121.8359, 36.61023], [-121.83587, 36.61018], [-121.83584, 36.61016], [-121.83584, 36.61007], [-121.836, 36.61017], [-121.83608, 36.6102], [-121.8364, 36.61015], [-121.83646, 36.61012]]]} | Open Access 1 | 35372 | Seaside holding 1 | 25251 | 1330 | Seaside, City of 115 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | Monterey 14 | 0.542 | Seaside holding 1 | 0 | Local Other or Unknown 14 | 4 | |
13312 | 13312 | 13311 | {"type": "Polygon", "coordinates": [[[-121.7986, 36.63737], [-121.79856, 36.64005], [-121.79853, 36.64022], [-121.79848, 36.64036], [-121.79817, 36.641], [-121.79798, 36.64093], [-121.79752, 36.64136], [-121.79747, 36.64134], [-121.7972, 36.64159], [-121.79613, 36.64138], [-121.79298, 36.64143], [-121.79296, 36.64271], [-121.79123, 36.63952], [-121.79146, 36.63881], [-121.79184, 36.63877], [-121.79215, 36.63869], [-121.79248, 36.63856], [-121.79348, 36.63814], [-121.7943, 36.63781], [-121.79484, 36.63765], [-121.79533, 36.63752], [-121.79567, 36.63747], [-121.79792, 36.63725], [-121.79816, 36.63726], [-121.7986, 36.63737]]]} | Open Access 1 | 35374 | Seaside holding 3 | 25259 | 1330 | Seaside, City of 115 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | Monterey 14 | 61.775 | Seaside holding 3 | 0 | Local Other or Unknown 14 | 4 | |
13345 | 13345 | 13344 | {"type": "Polygon", "coordinates": [[[-121.85589, 36.60788], [-121.8555, 36.60813], [-121.85532, 36.60795], [-121.85548, 36.60786], [-121.85572, 36.60778], [-121.85579, 36.60779], [-121.85589, 36.60788]]]} | Open Access 1 | 35424 | Seaside holding 6 | 25262 | 1330 | Seaside, City of 115 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | Monterey 14 | 0.246 | Seaside holding 6 | 0 | Local Other or Unknown 14 | 4 | |
13346 | 13346 | 13345 | {"type": "Polygon", "coordinates": [[[-121.82508, 36.6128], [-121.82474, 36.61287], [-121.82474, 36.61287], [-121.82474, 36.61284], [-121.82507, 36.61277], [-121.82508, 36.6128]]]} | Open Access 1 | 35425 | Seaside holding 7 | 25263 | 1330 | Seaside, City of 115 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | Monterey 14 | 0.023 | Seaside holding 7 | 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]);