units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
35 rows where ACCESS_TYP = 1, COUNTY = 14 and MNG_AGENCY = 112
This data as json, copyable, CSV (advanced)
DES_TP 4
MNG_AG_TYP 1
- City Agency 35
MNG_AGENCY 1
- Seaside, City of · 35 ✖
ACCESS_TYP 1
- Open Access · 35 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
390 | 390 | 389 | {"type": "Polygon", "coordinates": [[[-121.85037, 36.60465], [-121.85037, 36.60469], [-121.85035, 36.60473], [-121.85031, 36.60476], [-121.85025, 36.60477], [-121.84884, 36.60476], [-121.84876, 36.60472], [-121.84874, 36.60465], [-121.84877, 36.60459], [-121.84886, 36.60456], [-121.85026, 36.60458], [-121.85032, 36.6046], [-121.85037, 36.60465]]]} | Open Access 1 | 1422 | Trinity Park | 26541 | 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.754 | Trinity Park | 0 | Local Park 2 | 4 | |
428 | 428 | 427 | {"type": "Polygon", "coordinates": [[[-121.84692, 36.60162], [-121.84692, 36.60208], [-121.84657, 36.60207], [-121.84657, 36.60162], [-121.84692, 36.60162]]]} | Open Access 1 | 48914 | Ellis Park | 33635 | 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 | http://www.ci.seaside.ca.us/Facilities/Facility/Details/Ellis-Park-28 | Monterey 14 | 0.391 | Ellis Park | 0 | Local Park 2 | 4 |
651 | 651 | 650 | {"type": "Polygon", "coordinates": [[[-121.83147, 36.60522], [-121.83145, 36.60586], [-121.83095, 36.60585], [-121.83097, 36.60522], [-121.83147, 36.60522]]]} | Open Access 1 | 3181 | Capra Park | 16842 | 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.791 | Capra Park | 0 | Local Park 2 | 4 | |
1814 | 1814 | 1813 | {"type": "Polygon", "coordinates": [[[-121.83212, 36.60337], [-121.83211, 36.60358], [-121.8316, 36.60358], [-121.83161, 36.60337], [-121.83212, 36.60337]]]} | Open Access 1 | 15623 | Encanto Park | 18638 | 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.261 | Encanto Park | 0 | Local Park 2 | 4 | |
2038 | 2038 | 2037 | {"type": "Polygon", "coordinates": [[[-121.82168, 36.61344], [-121.82193, 36.61292], [-121.82191, 36.61358], [-121.82161, 36.61357], [-121.82168, 36.61344]]]} | Open Access 1 | 17079 | Juarez Park | 20516 | 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.245 | Juarez Park | 0 | Local Park 2 | 4 | |
2088 | 2088 | 2087 | {"type": "Polygon", "coordinates": [[[-121.83409, 36.60274], [-121.83408, 36.60319], [-121.83404, 36.60318], [-121.83401, 36.60314], [-121.83348, 36.60314], [-121.83349, 36.60273], [-121.83409, 36.60274]]]} | Open Access 1 | 15781 | Farallones Park | 18843 | 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.606 | Farallones Park | 0 | Local Park 2 | 4 | |
2291 | 2291 | 2290 | {"type": "Polygon", "coordinates": [[[-121.82999, 36.61186], [-121.82998, 36.61234], [-121.82948, 36.61233], [-121.82949, 36.61186], [-121.82999, 36.61186]]]} | Open Access 1 | 16884 | Highland Park | 19935 | 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.581 | Highland Park | 0 | Local Park 2 | 4 | |
2501 | 2501 | 2500 | {"type": "Polygon", "coordinates": [[[-121.82723, 36.6137], [-121.82691, 36.61382], [-121.8271, 36.61401], [-121.82685, 36.61443], [-121.82657, 36.6143], [-121.82631, 36.61413], [-121.82655, 36.61396], [-121.8269, 36.61383], [-121.8269, 36.61379], [-121.82722, 36.61367], [-121.82723, 36.6137]]]} | Open Access 1 | 17551 | Manzanita Stuart Park | 21770 | 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.669 | Manzanita Stuart Park | 0 | Local Park 2 | 4 | |
2541 | 2541 | 2540 | {"type": "Polygon", "coordinates": [[[-121.82669, 36.6072], [-121.82646, 36.60735], [-121.82635, 36.6076], [-121.82648, 36.60785], [-121.82606, 36.608], [-121.82587, 36.6078], [-121.82567, 36.6078], [-121.82557, 36.60757], [-121.82527, 36.60743], [-121.82558, 36.60679], [-121.82574, 36.60689], [-121.82576, 36.60699], [-121.82634, 36.60718], [-121.82667, 36.60715], [-121.82669, 36.6072]]]} | Open Access 1 | 17786 | Mescal Neil Park | 22183 | 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 | 2.079 | Mescal Neil Park | 0 | Local Park 2 | 4 | |
2590 | 2590 | 2589 | {"type": "MultiPolygon", "coordinates": [[[[-121.83143, 36.60704], [-121.83142, 36.60731], [-121.83117, 36.6073], [-121.83118, 36.60703], [-121.83143, 36.60704]]], [[[-121.83204, 36.60701], [-121.83203, 36.60732], [-121.83152, 36.60731], [-121.83153, 36.60701], [-121.83158, 36.60704], [-121.83199, 36.60705], [-121.83203, 36.60703], [-121.83204, 36.60701]]]]} | Open Access 1 | 17968 | Beta Park | 16044 | 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.502 | Beta Park | 0 | Local Park 2 | 4 | |
2680 | 2680 | 2679 | {"type": "MultiPolygon", "coordinates": [[[[-121.83123, 36.62024], [-121.83121, 36.62123], [-121.83032, 36.62123], [-121.83033, 36.62023], [-121.83123, 36.62024]]], [[[-121.83042, 36.6214], [-121.83041, 36.62173], [-121.83032, 36.62173], [-121.83033, 36.6214], [-121.83042, 36.6214]]]]} | Open Access 1 | 17790 | Metz Park | 22189 | 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 | 2.24 | Metz Park | 0 | Local Park 2 | 4 | |
2740 | 2740 | 2739 | {"type": "Polygon", "coordinates": [[[-121.82582, 36.6117], [-121.8252, 36.61169], [-121.8252, 36.61165], [-121.82581, 36.61166], [-121.82582, 36.6117]]]} | Open Access 1 | 18402 | park access 2 | 23424 | 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.063 | park access 2 | None 226 | |||
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 | ||
8058 | 8058 | 8057 | {"type": "Polygon", "coordinates": [[[-121.83751, 36.61522], [-121.83746, 36.61611], [-121.83721, 36.61612], [-121.83719, 36.61652], [-121.83745, 36.61653], [-121.83744, 36.61664], [-121.8369, 36.61664], [-121.83689, 36.61638], [-121.83635, 36.61638], [-121.83638, 36.61537], [-121.83626, 36.61537], [-121.83625, 36.61575], [-121.83601, 36.61575], [-121.83603, 36.61479], [-121.83579, 36.61478], [-121.83579, 36.61475], [-121.8361, 36.61464], [-121.83626, 36.6146], [-121.83651, 36.61459], [-121.83673, 36.61463], [-121.83726, 36.61484], [-121.83725, 36.61521], [-121.83751, 36.61522]]]} | Open Access 1 | 11832 | Cutino Park | 17865 | 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 | 5.376 | Cutino Park | 0 | Local Park 2 | 4 | |
8675 | 8675 | 8674 | {"type": "Polygon", "coordinates": [[[-121.83271, 36.60448], [-121.8327, 36.60496], [-121.83219, 36.60496], [-121.8322, 36.60447], [-121.83271, 36.60448]]]} | Open Access 1 | 14004 | Durant Park | 18312 | 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.602 | Durant Park | 0 | Local Park 2 | 4 | |
9498 | 9498 | 9497 | {"type": "Polygon", "coordinates": [[[-121.82706, 36.61571], [-121.82699, 36.61577], [-121.82661, 36.61556], [-121.82622, 36.61578], [-121.82608, 36.61578], [-121.82583, 36.61604], [-121.8258, 36.61603], [-121.82592, 36.61579], [-121.82591, 36.61578], [-121.82502, 36.61576], [-121.82502, 36.61568], [-121.82528, 36.61568], [-121.82529, 36.61533], [-121.82558, 36.61533], [-121.8257, 36.61508], [-121.82573, 36.61508], [-121.82573, 36.61533], [-121.82587, 36.61533], [-121.82646, 36.61453], [-121.82621, 36.61431], [-121.82625, 36.61429], [-121.82629, 36.6143], [-121.82656, 36.61446], [-121.82683, 36.61458], [-121.82671, 36.61481], [-121.8267, 36.6155], [-121.82706, 36.61571]]]} | Open Access 1 | 17359 | Lincoln Cunningham Park | 21247 | 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 | 2.854 | Lincoln Cunningham Park | 0 | Local Park 2 | 4 | |
9831 | 9831 | 9830 | {"type": "Polygon", "coordinates": [[[-121.82492, 36.61554], [-121.82492, 36.61569], [-121.82466, 36.61568], [-121.82438, 36.61581], [-121.82429, 36.61592], [-121.82418, 36.61591], [-121.82412, 36.61595], [-121.82409, 36.61599], [-121.8238, 36.61598], [-121.82379, 36.61615], [-121.82368, 36.61614], [-121.82368, 36.61598], [-121.82341, 36.61597], [-121.82339, 36.61593], [-121.82334, 36.6159], [-121.82329, 36.61588], [-121.82322, 36.6159], [-121.82317, 36.61581], [-121.82274, 36.61562], [-121.82258, 36.61561], [-121.82258, 36.61549], [-121.82355, 36.61551], [-121.82357, 36.61521], [-121.82373, 36.61519], [-121.82374, 36.61551], [-121.82492, 36.61554]]]} | Open Access 1 | 16793 | Havana Soliz Park | 19740 | 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.971 | Havana Soliz Park | 0 | Local Park 2 | 4 | |
10554 | 10554 | 10553 | {"type": "Polygon", "coordinates": [[[-121.82587, 36.60959], [-121.82585, 36.61029], [-121.82547, 36.61016], [-121.82509, 36.61011], [-121.82506, 36.61001], [-121.82491, 36.60968], [-121.82522, 36.60957], [-121.82587, 36.60959]]]} | Open Access 1 | 18776 | Portola Leslie Park | 23907 | 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.237 | Portola Leslie Park | 0 | Local Park 2 | 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 |
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]);