superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
37 rows where MNG_AGENCY = 112
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
9452 | 9452 | 9451 | {"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 | Seaside holding 13 | 25255 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 0.167 | Seaside holding 13 | ||
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 | ||
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 | ||
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 | ||
9456 | 9456 | 9455 | {"type": "Polygon", "coordinates": [[[-121.7986, 36.63737], [-121.79856, 36.64005], [-121.79853, 36.64022], [-121.79848, 36.64036], [-121.79817, 36.641], [-121.79797, 36.64093], [-121.79752, 36.64136], [-121.79747, 36.64134], [-121.7972, 36.64159], [-121.79613, 36.64138], [-121.79298, 36.64143], [-121.79296, 36.64271], [-121.79123, 36.63952], [-121.79146, 36.63881], [-121.79184, 36.63877], [-121.79215, 36.63869], [-121.79248, 36.63856], [-121.79348, 36.63814], [-121.7943, 36.63781], [-121.79484, 36.63765], [-121.79533, 36.63752], [-121.79567, 36.63747], [-121.79792, 36.63725], [-121.79816, 36.63726], [-121.7986, 36.63737]]]} | Open Access 1 | Seaside holding 3 | 25259 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 61.788 | Seaside holding 3 | ||
9457 | 9457 | 9456 | {"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 | Seaside holding 4 | 25260 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 18.208 | Seaside holding 4 | ||
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 | ||
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 | ||
9460 | 9460 | 9459 | {"type": "Polygon", "coordinates": [[[-121.82508, 36.6128], [-121.82474, 36.61287], [-121.82474, 36.61287], [-121.82474, 36.61284], [-121.82507, 36.61277], [-121.82508, 36.6128]]]} | Open Access 1 | Seaside holding 7 | 25263 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 0.023 | Seaside holding 7 | ||
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 | ||
9462 | 9462 | 9461 | {"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 | Seaside holding 9 | 25265 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 29.165 | Seaside holding 9 | ||
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 | ||
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 | |||
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 | |
15091 | 15091 | 15090 | {"type": "MultiPolygon", "coordinates": [[[[-121.85465, 36.60115], [-121.85452, 36.60118], [-121.85457, 36.60139], [-121.85418, 36.60189], [-121.85385, 36.60189], [-121.85417, 36.60144], [-121.85418, 36.60134], [-121.85414, 36.60127], [-121.85402, 36.6012], [-121.85364, 36.60114], [-121.85323, 36.60103], [-121.85298, 36.60093], [-121.85257, 36.60072], [-121.85155, 36.59958], [-121.85144, 36.59935], [-121.85117, 36.59904], [-121.85135, 36.59892], [-121.8515, 36.59896], [-121.85161, 36.59906], [-121.85184, 36.599], [-121.85203, 36.5992], [-121.8521, 36.59966], [-121.85289, 36.6003], [-121.85378, 36.60075], [-121.85443, 36.60084], [-121.85465, 36.60115]]], [[[-121.85199, 36.59822], [-121.85199, 36.5988], [-121.85157, 36.5988], [-121.85118, 36.59874], [-121.85199, 36.59822]]], [[[-121.85618, 36.60499], [-121.85522, 36.60524], [-121.85481, 36.60425], [-121.85544, 36.60409], [-121.85563, 36.60453], [-121.85596, 36.60445], [-121.85618, 36.60499]]], [[[-121.85884, 36.60575], [-121.85829, 36.60603], [-121.85792, 36.60626], [-121.85713, 36.60547], [-121.8577, 36.60511], [-121.85723, 36.60434], [-121.85757, 36.60412], [-121.85852, 36.60549], [-121.85884, 36.60575]]]]} | Open Access 1 | Laguna Grande Regional Park | 20855 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 11.647 | Laguna Grande RP |
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]);