superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
37 rows where MNG_AGENCY = 112 sorted by map descending
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8335 | 8335 | 8334 | {"type": "Polygon", "coordinates": [[[-121.85612, 36.61199], [-121.8561, 36.6123], [-121.85602, 36.6123], [-121.85604, 36.61196], [-121.85607, 36.61194], [-121.85612, 36.61199]]]} | Restricted Access 2 | South Monterey Dunes | 25664 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 0.069 | South Monterey Dunes | ||
9459 | 9459 | 9458 | {"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 | Seaside holding 6 | 25262 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 0.246 | Seaside holding 6 | ||
9453 | 9453 | 9452 | {"type": "Polygon", "coordinates": [[[-121.8558, 36.61097], [-121.85569, 36.61103], [-121.85525, 36.61148], [-121.85518, 36.61154], [-121.8552, 36.61063], [-121.85511, 36.61061], [-121.85512, 36.61031], [-121.85568, 36.61088], [-121.85571, 36.61087], [-121.8558, 36.61097]]]} | Open Access 1 | Seaside holding 14 | 25256 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 0.871 | Seaside holding 14 | ||
14400 | 14400 | 14399 | {"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.60379], [-121.85381, 36.60304], [-121.85394, 36.60302], [-121.85413, 36.60347], [-121.85423, 36.60375]]]} | Open Access 1 | Unknown park - Seaside, City of | 33636 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 0.94 | |||
9458 | 9458 | 9457 | {"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 | Seaside holding 5 | 25261 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 0.062 | Seaside holding 5 | ||
10427 | 10427 | 10426 | {"type": "Polygon", "coordinates": [[[-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], [-121.85037, 36.60469]]]} | Open Access 1 | Trinity Park | 26541 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 0.754 | Trinity Park | ||
9461 | 9461 | 9460 | {"type": "Polygon", "coordinates": [[[-121.85018, 36.60235], [-121.85017, 36.60253], [-121.84975, 36.60252], [-121.85014, 36.60232], [-121.85018, 36.60235]]]} | Open Access 1 | Seaside holding 8 | 25264 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 0.116 | Seaside holding 8 | ||
14401 | 14401 | 14400 | {"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 | Ellis Park | http://www.ci.seaside.ca.us/Facilities/Facility/Details/Ellis-Park-28 | 33635 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 0.391 | Ellis Park | |
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
9455 | 9455 | 9454 | {"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.83258, 36.61319], [-121.83248, 36.61312], [-121.83248, 36.61309], [-121.83259, 36.61317], [-121.83306, 36.61318], [-121.83316, 36.61316], [-121.83315, 36.61335], [-121.8332, 36.61336]]]} | Open Access 1 | Seaside holding 2 | 25258 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 0.489 | Seaside holding 2 | ||
9454 | 9454 | 9453 | {"type": "Polygon", "coordinates": [[[-121.83311, 36.6034], [-121.83311, 36.6036], [-121.83284, 36.6036], [-121.83284, 36.60357], [-121.83291, 36.60355], [-121.83294, 36.6035], [-121.83293, 36.60345], [-121.83285, 36.6034], [-121.83311, 36.6034]]]} | Open Access 1 | Seaside holding 15 | 25257 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 0.102 | Seaside holding 15 | ||
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 | ||
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 | ||
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 | ||
6397 | 6397 | 6396 | {"type": "Polygon", "coordinates": [[[-121.82991, 36.63229], [-121.82593, 36.63574], [-121.82568, 36.63592], [-121.82546, 36.63603], [-121.82507, 36.63615], [-121.82474, 36.63618], [-121.81961, 36.63594], [-121.81935, 36.63593], [-121.81911, 36.63596], [-121.81872, 36.63606], [-121.81842, 36.6362], [-121.8183, 36.63628], [-121.81716, 36.63727], [-121.81692, 36.63709], [-121.81597, 36.63671], [-121.81592, 36.6366], [-121.81575, 36.63637], [-121.81533, 36.63587], [-121.81503, 36.63572], [-121.81455, 36.63544], [-121.81353, 36.63481], [-121.8128, 36.63419], [-121.81388, 36.63201], [-121.81361, 36.63084], [-121.81575, 36.62643], [-121.81895, 36.62681], [-121.82132, 36.62198], [-121.82148, 36.62204], [-121.82208, 36.62234], [-121.82269, 36.62251], [-121.82291, 36.6226], [-121.82351, 36.62312], [-121.82384, 36.6233], [-121.82411, 36.62337], [-121.82463, 36.62366], [-121.82508, 36.62391], [-121.82592, 36.62448], [-121.82574, 36.62606], [-121.82589, 36.62664], [-121.82609, 36.62719], [-121.82662, 36.62852], [-121.82696, 36.62899], [-121.82756, 36.62939], [-121.82804, 36.62959], [-121.82889, 36.62973], [-121.82916, 36.63084], [-121.82912, 36.6309], [-121.82991, 36.63229]]]} | Restricted Access 2 | Bayonet Black Horse Golf Course | 33056 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 373.547 | Bayonet Black Horse GC |
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]);