superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
72 rows where MNG_AGENCY = 288 sorted by PARK_NAME 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9437 | 9437 | 9436 | {"type": "Polygon", "coordinates": [[[-118.35435, 33.80454], [-118.35435, 33.80563], [-118.35277, 33.80551], [-118.35278, 33.80441], [-118.35435, 33.80454]]]} | Open Access 1 | Walteria Park | 27248 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 4.41 | Walteria Park | ||
9306 | 9306 | 9305 | {"type": "Polygon", "coordinates": [[[-118.36495, 33.84316], [-118.36345, 33.84316], [-118.36344, 33.84143], [-118.36494, 33.84143], [-118.36495, 33.84316]]]} | Open Access 1 | Victor Park | 27071 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 6.597 | Victor Park | ||
12723 | 12723 | 12722 | {"type": "Polygon", "coordinates": [[[-118.34245, 33.8418], [-118.34022, 33.84182], [-118.3402, 33.84072], [-118.34244, 33.8407], [-118.34245, 33.8418]]]} | Restricted Access 2 | Toyota Sports Complex | http://www.torranceca.gov/27330.htm | 29898 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 6.219 | Toyota Sports Complex | |
10406 | 10406 | 10405 | {"type": "Polygon", "coordinates": [[[-118.37289, 33.82747], [-118.37259, 33.82737], [-118.37257, 33.82732], [-118.37286, 33.82735], [-118.37289, 33.82747]]]} | Open Access 1 | Torrance holding 6 | 26464 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 0.06 | Torrance holding 6 | ||
10405 | 10405 | 10404 | {"type": "Polygon", "coordinates": [[[-118.36897, 33.80456], [-118.36893, 33.80458], [-118.36879, 33.80431], [-118.36871, 33.80428], [-118.36847, 33.80438], [-118.36821, 33.80455], [-118.36778, 33.80419], [-118.3688, 33.8042], [-118.36897, 33.80456]]]} | Open Access 1 | Torrance holding 28 | 26435 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 0.536 | Torrance holding 28 | ||
10404 | 10404 | 10403 | {"type": "Polygon", "coordinates": [[[-118.37443, 33.81802], [-118.37442, 33.81909], [-118.37381, 33.81909], [-118.37372, 33.81908], [-118.37354, 33.819], [-118.37335, 33.81885], [-118.37326, 33.81869], [-118.37325, 33.81846], [-118.3733, 33.81831], [-118.37343, 33.81815], [-118.37363, 33.81804], [-118.37383, 33.81799], [-118.37443, 33.81799], [-118.37443, 33.81802]]]} | Open Access 1 | Torrance holding 23 | 26430 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 2.9 | Torrance holding 23 | ||
10403 | 10403 | 10402 | {"type": "Polygon", "coordinates": [[[-118.3621, 33.80422], [-118.36198, 33.80426], [-118.36183, 33.80426], [-118.36171, 33.80424], [-118.36154, 33.80416], [-118.36131, 33.80396], [-118.3611, 33.80383], [-118.36028, 33.80314], [-118.36024, 33.80307], [-118.36032, 33.80301], [-118.36169, 33.80417], [-118.36209, 33.80417], [-118.3621, 33.80422]]]} | Open Access 1 | Torrance holding 16 | 26422 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 0.591 | Torrance holding 16 | ||
10402 | 10402 | 10401 | {"type": "Polygon", "coordinates": [[[-118.31626, 33.83389], [-118.31603, 33.83406], [-118.31569, 33.83375], [-118.31591, 33.83358], [-118.31626, 33.83389]]]} | Open Access 1 | Torrance holding 13 | 26419 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 0.333 | Torrance holding 13 | ||
10401 | 10401 | 10400 | {"type": "Polygon", "coordinates": [[[-118.37443, 33.82141], [-118.37442, 33.82234], [-118.37432, 33.82233], [-118.37398, 33.82192], [-118.37365, 33.822], [-118.37358, 33.82193], [-118.37359, 33.82188], [-118.37374, 33.82172], [-118.37401, 33.82188], [-118.37443, 33.82141]]]} | No Public Access 3 | Torrance holding 11 | 26417 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 0.742 | Torrance holding 11 | ||
10410 | 10410 | 10409 | {"type": "Polygon", "coordinates": [[[-118.31867, 33.82175], [-118.31822, 33.82302], [-118.31708, 33.82273], [-118.31541, 33.82122], [-118.31549, 33.82097], [-118.31867, 33.82175]]]} | Open Access 1 | Torrance Park | 26468 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 8.191 | Torrance Park | ||
10400 | 10400 | 10399 | {"type": "Polygon", "coordinates": [[[-118.39238, 33.80932], [-118.39214, 33.81043], [-118.39191, 33.81038], [-118.39196, 33.81012], [-118.39199, 33.81009], [-118.39203, 33.81009], [-118.39212, 33.80992], [-118.39225, 33.80948], [-118.39233, 33.8093], [-118.39238, 33.80932]]]} | Open Access 1 | Torrance County Beach | 26414 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 0.424 | Torrance County Beach | ||
10143 | 10143 | 10142 | {"type": "Polygon", "coordinates": [[[-118.3144, 33.81056], [-118.3144, 33.81122], [-118.3118, 33.81121], [-118.31181, 33.80991], [-118.31183, 33.80989], [-118.3134, 33.80989], [-118.31341, 33.81019], [-118.31394, 33.81019], [-118.31394, 33.81023], [-118.31394, 33.81048], [-118.31341, 33.81048], [-118.3134, 33.81055], [-118.3144, 33.81056]]]} | Open Access 1 | Sur La Brea Park | 26075 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 7.427 | Sur La Brea Park | ||
10093 | 10093 | 10092 | {"type": "Polygon", "coordinates": [[[-118.37514, 33.85038], [-118.37394, 33.85055], [-118.37358, 33.8487], [-118.37437, 33.84871], [-118.37488, 33.84878], [-118.37492, 33.84881], [-118.37489, 33.84901], [-118.37489, 33.84913], [-118.37514, 33.85038]]]} | Open Access 1 | Sunnyglen Park | 26006 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 5.482 | Sunnyglen Park | ||
12219 | 12219 | 12218 | {"type": "MultiPolygon", "coordinates": [[[[-118.36261, 33.80521], [-118.36257, 33.80551], [-118.36058, 33.80532], [-118.36075, 33.80479], [-118.36197, 33.80525], [-118.36261, 33.80521]]], [[[-118.36453, 33.80584], [-118.36435, 33.80618], [-118.36341, 33.80593], [-118.3635, 33.80574], [-118.36453, 33.80584]]]]} | Open Access 1 | Slope-Vista Montana | 29200 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 2.382 | Slope-Vista Montana | ||
12198 | 12198 | 12197 | {"type": "Polygon", "coordinates": [[[-118.3629, 33.80569], [-118.36282, 33.80599], [-118.36103, 33.80567], [-118.35988, 33.80555], [-118.35986, 33.8054], [-118.3629, 33.80569]]]} | Open Access 1 | Slope-Vista Largo | 29177 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1.571 | Slope-Vista Largo | ||
12197 | 12197 | 12196 | {"type": "Polygon", "coordinates": [[[-118.35344, 33.79965], [-118.35314, 33.79985], [-118.35296, 33.79967], [-118.35259, 33.79991], [-118.35249, 33.7998], [-118.3532, 33.79933], [-118.3534, 33.79955], [-118.35338, 33.79959], [-118.35344, 33.79965]]]} | No Public Access 3 | Slope-Via Valmonte | 29176 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 0.564 | Slope-Via Valmonte | ||
12215 | 12215 | 12214 | {"type": "Polygon", "coordinates": [[[-118.37003, 33.80894], [-118.36954, 33.8099], [-118.36766, 33.80851], [-118.36743, 33.8087], [-118.36706, 33.80844], [-118.36605, 33.80806], [-118.36594, 33.808], [-118.36527, 33.8074], [-118.36503, 33.80742], [-118.36472, 33.80731], [-118.36486, 33.80704], [-118.36484, 33.80699], [-118.36492, 33.80694], [-118.36495, 33.80685], [-118.36494, 33.8068], [-118.36491, 33.80676], [-118.36471, 33.80663], [-118.36482, 33.80641], [-118.36514, 33.80657], [-118.36525, 33.80649], [-118.3653, 33.80593], [-118.36552, 33.8061], [-118.3655, 33.80627], [-118.36542, 33.80635], [-118.3654, 33.80639], [-118.3654, 33.80644], [-118.36542, 33.80648], [-118.36546, 33.80652], [-118.36553, 33.80654], [-118.3656, 33.80653], [-118.36565, 33.8065], [-118.36617, 33.8068], [-118.36613, 33.80682], [-118.36614, 33.80686], [-118.36597, 33.80689], [-118.36596, 33.8069], [-118.36646, 33.80748], [-118.3679, 33.80801], [-118.37003, 33.80894]]]} | No Public Access 3 | Slope-Via Corona | 29195 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 11.829 | Slope-Via Corona | ||
11764 | 11764 | 11763 | {"type": "Polygon", "coordinates": [[[-118.36147, 33.82116], [-118.36147, 33.82149], [-118.36001, 33.82072], [-118.36001, 33.8204], [-118.36147, 33.82116]]]} | Open Access 1 | Seaside Heroes Park | http://www.torranceca.gov/Parks/22840.htm | 28376 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1.202 | Seaside Heroes Park | |
14320 | 14320 | 14319 | {"type": "Polygon", "coordinates": [[[-118.36641, 33.82132], [-118.36593, 33.82131], [-118.36594, 33.82085], [-118.36641, 33.82087], [-118.36641, 33.82132]]]} | Open Access 1 | Sea-Aire Parklette | 29333 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 0.548 | Sea-Aire Parklette | ||
14583 | 14583 | 14582 | {"type": "Polygon", "coordinates": [[[-118.36766, 33.8205], [-118.36765, 33.82168], [-118.36593, 33.82168], [-118.36593, 33.82131], [-118.36641, 33.8213], [-118.36641, 33.82088], [-118.36594, 33.82085], [-118.36594, 33.82049], [-118.36766, 33.8205]]]} | Restricted Access 2 | Sea-Aire Golf Course | 33004 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 4.637 | Sea-Aire 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]);