units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
51 rows where COUNTY = 14 and DES_TP = 14 sorted by SUID_NMA
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, MNG_AG_ID, MNG_AG_LEV
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8678 | 8678 | 8677 | {"type": "Polygon", "coordinates": [[[-121.81028, 36.69978], [-121.81011, 36.70086], [-121.80621, 36.69923], [-121.80668, 36.69888], [-121.80692, 36.69836], [-121.81028, 36.69978]]]} | Open Access 1 | 13963 | Dunes State Park - Marina County Water District | 18301 | 2073 | Marina County Water District 897 | Special District 4 | Water District 13 | http://www.mcwd.org/ | Special District 4 | 2073 | Marina County Water District 871 | Special District 4 | Water District 13 | Monterey 14 | 10.133 | Dunes SP - Marina County Water District | 0 | Local Other or Unknown 14 | 4 | |
13298 | 13298 | 13297 | {"type": "Polygon", "coordinates": [[[-121.81166, 36.67007], [-121.8115, 36.67112], [-121.81097, 36.6721], [-121.81033, 36.67299], [-121.8098, 36.67357], [-121.80786, 36.67008], [-121.81166, 36.67007]]]} | Open Access 1 | 35375 | Marina holding 1 | 21825 | 1197 | Marina, City of 216 | City 2 | City Agency 2 | http://www.ci.marina.ca.us/index.aspx?NID=25 | City 2 | 1197 | Marina, City of 212 | City 2 | City Agency 2 | Monterey 14 | 18.561 | Marina holding 1 | 0 | Local Other or Unknown 14 | 4 | |
13343 | 13343 | 13342 | {"type": "Polygon", "coordinates": [[[-121.78991, 36.6636], [-121.78865, 36.6638], [-121.78723, 36.66422], [-121.78609, 36.66476], [-121.78539, 36.66517], [-121.7849, 36.66253], [-121.78527, 36.66244], [-121.78963, 36.66175], [-121.78991, 36.6636]]]} | Open Access 1 | 35422 | Marina holding 2 | 21826 | 1197 | Marina, City of 216 | City 2 | City Agency 2 | http://www.ci.marina.ca.us/index.aspx?NID=25 | City 2 | 1197 | Marina, City of 212 | City 2 | City Agency 2 | Monterey 14 | 24.569 | Marina holding 2 | 0 | Local Other or Unknown 14 | 4 | |
12171 | 12171 | 12170 | {"type": "Polygon", "coordinates": [[[-121.79995, 36.66037], [-121.7993, 36.66175], [-121.79686, 36.66122], [-121.79733, 36.65943], [-121.79869, 36.65973], [-121.79995, 36.66037]]]} | Open Access 1 | 35260 | Marina holding 3 | 21827 | 1197 | Marina, City of 216 | City 2 | City Agency 2 | http://www.ci.marina.ca.us/index.aspx?NID=25 | City 2 | 1197 | Marina, City of 212 | City 2 | City Agency 2 | Monterey 14 | 11.457 | Marina holding 3 | 0 | Local Other or Unknown 14 | 4 | |
13268 | 13268 | 13267 | {"type": "Polygon", "coordinates": [[[-121.79973, 36.66203], [-121.79896, 36.66436], [-121.79678, 36.66605], [-121.79622, 36.66576], [-121.79525, 36.66511], [-121.79613, 36.66377], [-121.79635, 36.6636], [-121.79667, 36.66257], [-121.79659, 36.66193], [-121.7968, 36.66136], [-121.79973, 36.66203]]]} | Open Access 1 | 35318 | Marina holding 4 | 21828 | 1197 | Marina, City of 216 | City 2 | City Agency 2 | http://www.ci.marina.ca.us/index.aspx?NID=25 | City 2 | 1197 | Marina, City of 212 | City 2 | City Agency 2 | Monterey 14 | 28.299 | Marina holding 4 | 0 | Local Other or Unknown 14 | 4 | |
3824 | 3824 | 3823 | {"type": "Polygon", "coordinates": [[[-121.82197, 36.58445], [-121.82053, 36.586], [-121.81948, 36.58511], [-121.81901, 36.58475], [-121.81625, 36.58287], [-121.81739, 36.58153], [-121.82197, 36.58445]]]} | Open Access 1 | 35230 | Monterey holding 1 | 22421 | 1212 | Monterey, City of 37 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | Monterey 14 | 24.525 | Monterey holding 1 | 0 | Local Other or Unknown 14 | 4 | |
13209 | 13209 | 13208 | {"type": "Polygon", "coordinates": [[[-121.80773, 36.57658], [-121.80773, 36.58183], [-121.80616, 36.58125], [-121.80561, 36.58087], [-121.80526, 36.58066], [-121.80482, 36.58044], [-121.80434, 36.58027], [-121.8037, 36.58007], [-121.80214, 36.57966], [-121.80143, 36.57949], [-121.80018, 36.57927], [-121.7979, 36.5789], [-121.79696, 36.57877], [-121.79602, 36.57867], [-121.79506, 36.57859], [-121.7945, 36.57856], [-121.7935, 36.57873], [-121.79326, 36.57873], [-121.79638, 36.57817], [-121.79781, 36.57789], [-121.80394, 36.5768], [-121.80635, 36.57633], [-121.80665, 36.57631], [-121.80695, 36.57632], [-121.80735, 36.57641], [-121.8076, 36.57651], [-121.80773, 36.57658]]]} | Open Access 1 | 35245 | Monterey holding 2 | 22422 | 1212 | Monterey, City of 37 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | Monterey 14 | 77.51 | Monterey holding 2 | 0 | Local Other or Unknown 14 | 4 | |
13308 | 13308 | 13307 | {"type": "Polygon", "coordinates": [[[-121.66339, 36.71025], [-121.66325, 36.71055], [-121.66286, 36.71042], [-121.66285, 36.71032], [-121.66281, 36.71021], [-121.66295, 36.7101], [-121.66339, 36.71025]]]} | Open Access 1 | 35370 | Salinas holding 1 | 24799 | 1291 | Salinas, City of 56 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | Monterey 14 | 0.402 | Salinas holding 1 | 0 | Local Other or Unknown 14 | 4 | |
13311 | 13311 | 13310 | {"type": "Polygon", "coordinates": [[[-121.6464, 36.69999], [-121.6463, 36.70028], [-121.64573, 36.70014], [-121.64571, 36.70012], [-121.64572, 36.69982], [-121.6464, 36.69999]]]} | Open Access 1 | 35373 | Salinas holding 2 | 24800 | 1291 | Salinas, City of 56 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | Monterey 14 | 0.492 | Salinas holding 2 | 0 | Local Other or Unknown 14 | 4 | |
13344 | 13344 | 13343 | {"type": "Polygon", "coordinates": [[[-121.65536, 36.6777], [-121.655, 36.67847], [-121.65496, 36.67849], [-121.65491, 36.67849], [-121.65489, 36.67846], [-121.65466, 36.6778], [-121.65536, 36.6777]]]} | Open Access 1 | 35423 | Salinas holding 3 | 24801 | 1291 | Salinas, City of 56 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | Monterey 14 | 0.711 | Salinas holding 3 | 0 | Local Other or Unknown 14 | 4 | |
13154 | 13154 | 13153 | {"type": "Polygon", "coordinates": [[[-121.60707, 36.67811], [-121.6068, 36.67827], [-121.6064, 36.67781], [-121.60668, 36.67766], [-121.60707, 36.67811]]]} | Open Access 1 | 35290 | Salinas holding 4 | 24802 | 1291 | Salinas, City of 56 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | Monterey 14 | 0.461 | Salinas holding 4 | 0 | Local Other or Unknown 14 | 4 | |
13240 | 13240 | 13239 | {"type": "Polygon", "coordinates": [[[-121.62762, 36.68194], [-121.6272, 36.68289], [-121.6267, 36.68273], [-121.62672, 36.68263], [-121.62654, 36.68235], [-121.62762, 36.68194]]]} | Open Access 1 | 35284 | Salinas holding 5 | 24803 | 1291 | Salinas, City of 56 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | Monterey 14 | 1.21 | Salinas holding 5 | 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 | |
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 | |
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 | |
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 | |
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 | |
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 |
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]);