superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
35 rows where ACCESS_TYP = 1, MNG_AGENCY = 112 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1979 | 1979 | 1978 | {"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.83198, 36.60705], [-121.83202, 36.60703], [-121.83204, 36.60701]]]]} | Open Access 1 | Beta Park | 16044 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 0.502 | Beta Park | ||
2620 | 2620 | 2619 | {"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 | Capra Park | 16842 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 0.791 | Capra Park | ||
3384 | 3384 | 3383 | {"type": "Polygon", "coordinates": [[[-121.83751, 36.61522], [-121.83746, 36.61611], [-121.83721, 36.61613], [-121.8372, 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.6148], [-121.83579, 36.61478], [-121.83579, 36.61475], [-121.8361, 36.61464], [-121.83626, 36.6146], [-121.83651, 36.61459], [-121.83673, 36.61462], [-121.83726, 36.61484], [-121.83726, 36.6152], [-121.83751, 36.61522]]]} | Open Access 1 | Cutino Park | 17865 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 5.391 | Cutino Park | ||
3743 | 3743 | 3742 | {"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 | Durant Park | 18312 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 0.602 | Durant Park | ||
4001 | 4001 | 4000 | {"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 | Encanto Park | 18638 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 0.261 | Encanto Park | ||
4176 | 4176 | 4175 | {"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 | Farallones Park | 18843 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 0.606 | Farallones Park | ||
4967 | 4967 | 4966 | {"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.82367, 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 | Havana Soliz Park | 19740 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 1.981 | Havana Soliz Park | ||
5131 | 5131 | 5130 | {"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 | Highland Park | 19935 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 0.581 | Highland Park | ||
5624 | 5624 | 5623 | {"type": "Polygon", "coordinates": [[[-121.82193, 36.61292], [-121.82191, 36.61358], [-121.82161, 36.61357], [-121.82168, 36.61344], [-121.82193, 36.61292]]]} | Open Access 1 | Juarez Park | 20516 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 0.245 | Juarez Park | ||
6184 | 6184 | 6183 | {"type": "Polygon", "coordinates": [[[-121.82706, 36.61571], [-121.82699, 36.61577], [-121.8266, 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.82527, 36.61568], [-121.82529, 36.61533], [-121.82558, 36.61533], [-121.8257, 36.61508], [-121.82573, 36.61508], [-121.82573, 36.61532], [-121.82587, 36.61532], [-121.82646, 36.61454], [-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 | Lincoln Cunningham Park | 21247 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 2.868 | Lincoln Cunningham Park | ||
6601 | 6601 | 6600 | {"type": "Polygon", "coordinates": [[[-121.82723, 36.6137], [-121.82692, 36.61382], [-121.8271, 36.61401], [-121.82685, 36.61443], [-121.82657, 36.6143], [-121.82631, 36.61413], [-121.82654, 36.61396], [-121.82689, 36.61383], [-121.8269, 36.61379], [-121.82722, 36.61367], [-121.82723, 36.6137]]]} | Open Access 1 | Manzanita Stuart Park | 21770 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 0.672 | Manzanita Stuart Park | ||
6958 | 6958 | 6957 | {"type": "Polygon", "coordinates": [[[-121.82669, 36.6072], [-121.82646, 36.60735], [-121.82635, 36.60759], [-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.607], [-121.82634, 36.60718], [-121.82667, 36.60715], [-121.82669, 36.6072]]]} | Open Access 1 | Mescal Neil Park | 22183 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 2.082 | Mescal Neil Park | ||
6961 | 6961 | 6960 | {"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 | Metz Park | 22189 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 2.24 | Metz Park | ||
7080 | 7080 | 7079 | {"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 | Portola Leslie Park | 23907 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 1.237 | Portola Leslie Park | ||
7946 | 7946 | 7945 | {"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 | park access 2 | 23424 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 0.063 | park access 2 | ||
8832 | 8832 | 8831 | {"type": "MultiPolygon", "coordinates": [[[[-121.86007, 36.60626], [-121.86019, 36.60641], [-121.86027, 36.60654], [-121.86032, 36.6067], [-121.86035, 36.60687], [-121.86033, 36.60703], [-121.86029, 36.60718], [-121.86022, 36.60732], [-121.86011, 36.60747], [-121.86, 36.60758], [-121.85984, 36.60769], [-121.85774, 36.60886], [-121.85761, 36.60892], [-121.85741, 36.60896], [-121.85638, 36.60792], [-121.85936, 36.60601], [-121.85977, 36.60644], [-121.86007, 36.60626]]], [[[-121.85802, 36.60942], [-121.85791, 36.6095], [-121.85784, 36.6094], [-121.85755, 36.6091], [-121.85783, 36.60901], [-121.85794, 36.60921], [-121.85802, 36.60942]]]]} | Open Access 1 | Roberts Lake Open Space | 24492 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 14.461 | Roberts Lake OS | ||
9448 | 9448 | 9447 | {"type": "Polygon", "coordinates": [[[-121.83646, 36.61012], [-121.83646, 36.61018], [-121.83642, 36.61021], [-121.8364, 36.61026], [-121.83639, 36.61054], [-121.83616, 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 | Seaside holding 1 | 25251 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 0.543 | Seaside holding 1 | ||
9449 | 9449 | 9448 | {"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 | Seaside holding 10 | 25252 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 13.836 | Seaside holding 10 | ||
9450 | 9450 | 9449 | {"type": "Polygon", "coordinates": [[[-121.83969, 36.59906], [-121.83968, 36.59948], [-121.83819, 36.59945], [-121.83814, 36.59943], [-121.83812, 36.5994], [-121.83813, 36.59903], [-121.83969, 36.59906]]]} | Open Access 1 | Seaside holding 11 | 25253 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 1.606 | Seaside holding 11 | ||
9451 | 9451 | 9450 | {"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 | Seaside holding 12 | 25254 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 1.868 | Seaside holding 12 |
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]);