units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
28 rows where COUNTY = 14, DES_TP = 14 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
These facets timed out: ACCESS_TYP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | ||
6428 | 6428 | 6427 | {"type": "Polygon", "coordinates": [[[-121.33786, 36.47151], [-121.33187, 36.47323], [-121.3318, 36.46281], [-121.3377, 36.46284], [-121.33786, 36.47151]]]} | No Public Access 3 | 1938 | Windmill Property | 27628 | 1336 | Soledad, City of 485 | City 2 | City Agency 2 | http://www.cityofsoledad.com/ | City 2 | 1336 | Soledad, City of 476 | City 2 | City Agency 2 | Monterey 14 | 139.773 | Windmill Property | 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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 |
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]);