superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
72 rows where MNG_AGENCY = 288 sorted by rowid 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | ||
14092 | 14092 | 14091 | {"type": "Polygon", "coordinates": [[[-118.32437, 33.83122], [-118.32371, 33.83122], [-118.32371, 33.83073], [-118.32329, 33.83036], [-118.32348, 33.83022], [-118.32436, 33.83102], [-118.32437, 33.83122]]]} | Restricted Access 2 | ATTIC Teen Center | https://www.torranceca.gov/our-city/recreation/attic | 32631 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1.086 | ATTIC Teen Ctr. | |
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 | |
12299 | 12299 | 12298 | {"type": "Polygon", "coordinates": [[[-118.343, 33.82914], [-118.34294, 33.82916], [-118.34283, 33.82924], [-118.34276, 33.82926], [-118.34152, 33.82927], [-118.3415, 33.82825], [-118.34253, 33.82892], [-118.343, 33.82914]]]} | Open Access 1 | Madrona Marsh Nature Center | http://www.friendsofmadronamarsh.com/index.shtml | 29332 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1.986 | Madrona Marsh Nature Ctr. | |
12282 | 12282 | 12281 | {"type": "Polygon", "coordinates": [[[-118.3448, 33.82554], [-118.3448, 33.82767], [-118.34478, 33.828], [-118.34478, 33.82911], [-118.34473, 33.82916], [-118.3444, 33.82916], [-118.3439, 33.82912], [-118.34363, 33.82907], [-118.34337, 33.829], [-118.34312, 33.82892], [-118.34283, 33.82878], [-118.34251, 33.8286], [-118.34055, 33.82731], [-118.34005, 33.82708], [-118.34004, 33.82705], [-118.34003, 33.82566], [-118.34, 33.82541], [-118.33991, 33.82492], [-118.33989, 33.82465], [-118.33991, 33.82444], [-118.33994, 33.82441], [-118.34001, 33.8244], [-118.34081, 33.82457], [-118.34161, 33.8247], [-118.34336, 33.82505], [-118.34421, 33.82514], [-118.34421, 33.82554], [-118.3448, 33.82554]]]} | Open Access 1 | Madrona Marsh Preserve | 29331 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 42.375 | Madrona Marsh Preserve | ||
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 | ||
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 | ||
12214 | 12214 | 12213 | {"type": "Polygon", "coordinates": [[[-118.35732, 33.82927], [-118.35581, 33.8299], [-118.35559, 33.82945], [-118.35543, 33.82904], [-118.35529, 33.82863], [-118.35518, 33.8282], [-118.35509, 33.82777], [-118.35503, 33.82734], [-118.35501, 33.82703], [-118.35669, 33.82717], [-118.3568, 33.82782], [-118.35691, 33.82827], [-118.35706, 33.8287], [-118.35732, 33.82927]]]} | No Public Access 3 | Ocean Sump | 29194 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 10.918 | Ocean Sump | ||
12213 | 12213 | 12212 | {"type": "MultiPolygon", "coordinates": [[[[-118.35671, 33.81401], [-118.3545, 33.81401], [-118.3545, 33.8139], [-118.3567, 33.8139], [-118.35671, 33.81401]]], [[[-118.35725, 33.81401], [-118.35689, 33.81401], [-118.35688, 33.8139], [-118.35723, 33.8139], [-118.35725, 33.81401]]], [[[-118.35768, 33.8139], [-118.35768, 33.81401], [-118.35731, 33.81401], [-118.3573, 33.8139], [-118.35768, 33.8139]]], [[[-118.35838, 33.8139], [-118.35837, 33.81401], [-118.35801, 33.81404], [-118.35801, 33.81391], [-118.35838, 33.8139]]], [[[-118.3588, 33.81385], [-118.3588, 33.81396], [-118.35843, 33.814], [-118.35845, 33.81389], [-118.3588, 33.81385]]], [[[-118.36202, 33.8137], [-118.36202, 33.81381], [-118.36034, 33.81381], [-118.35899, 33.81395], [-118.35901, 33.81383], [-118.36033, 33.8137], [-118.36202, 33.8137]]]]} | No Public Access 3 | Drain to Walteria Lake | 29193 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1.877 | Drain to Walteria Lake | ||
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 | ||
12196 | 12196 | 12195 | {"type": "Polygon", "coordinates": [[[-118.3468, 33.85338], [-118.34613, 33.85338], [-118.34586, 33.85311], [-118.34562, 33.85279], [-118.34549, 33.85255], [-118.34549, 33.85235], [-118.34525, 33.85217], [-118.34549, 33.85211], [-118.3468, 33.85259], [-118.3468, 33.85338]]]} | No Public Access 3 | Retention Basin N Del Amo and Prairie | 29175 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 2.92 | Retention Basin N Del Amo and Prairie | ||
12195 | 12195 | 12194 | {"type": "Polygon", "coordinates": [[[-118.32242, 33.83351], [-118.32211, 33.83323], [-118.32241, 33.833], [-118.32241, 33.833], [-118.32242, 33.83351]]]} | Open Access 1 | Palm Tree Triangle next to Church in Old Torrance | 29174 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 0.194 | Palm Tree Triangle next to Church in Old Torrance | ||
12194 | 12194 | 12193 | {"type": "Polygon", "coordinates": [[[-118.34089, 33.83497], [-118.3401, 33.83496], [-118.3401, 33.83442], [-118.34015, 33.8344], [-118.34087, 33.8344], [-118.34089, 33.83443], [-118.34089, 33.83497]]]} | No Public Access 3 | Maple Sump | 29173 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1.131 | Maple Sump | ||
12193 | 12193 | 12192 | {"type": "Polygon", "coordinates": [[[-118.34459, 33.81799], [-118.34451, 33.81822], [-118.34448, 33.81848], [-118.34446, 33.81849], [-118.34446, 33.81894], [-118.34443, 33.81903], [-118.34436, 33.81902], [-118.34436, 33.81829], [-118.3444, 33.81816], [-118.34436, 33.81814], [-118.34436, 33.81789], [-118.34459, 33.81799]]]} | Open Access 1 | Madrona Right of Way South | 29172 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 0.349 | Madrona Right of Way South | ||
12192 | 12192 | 12191 | {"type": "Polygon", "coordinates": [[[-118.34493, 33.82494], [-118.34486, 33.82494], [-118.34458, 33.82455], [-118.34448, 33.82437], [-118.34446, 33.82436], [-118.34439, 33.82415], [-118.34434, 33.82384], [-118.34436, 33.81902], [-118.34443, 33.81902], [-118.34446, 33.81894], [-118.34446, 33.81902], [-118.34452, 33.81903], [-118.34448, 33.81921], [-118.34446, 33.81938], [-118.34444, 33.82386], [-118.34446, 33.82402], [-118.34456, 33.82433], [-118.34455, 33.82435], [-118.34465, 33.82454], [-118.34493, 33.82494]]]} | Open Access 1 | Madrona Right of Way North | 29171 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1.487 | Madrona Right of Way North | ||
12191 | 12191 | 12190 | {"type": "Polygon", "coordinates": [[[-118.37272, 33.8438], [-118.37216, 33.84447], [-118.37115, 33.84447], [-118.37115, 33.84344], [-118.37191, 33.84344], [-118.37272, 33.8438]]]} | No Public Access 3 | Henrietta Sump South | 29170 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 3.258 | Henrietta Sump South | ||
12190 | 12190 | 12189 | {"type": "Polygon", "coordinates": [[[-118.37216, 33.84447], [-118.37209, 33.84464], [-118.37153, 33.84466], [-118.37154, 33.84487], [-118.37204, 33.84487], [-118.37204, 33.84613], [-118.37186, 33.8462], [-118.37123, 33.8462], [-118.37122, 33.8461], [-118.37115, 33.84609], [-118.37115, 33.84447], [-118.37216, 33.84447]]]} | No Public Access 3 | Henrietta Sump North | 29169 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 3.614 | Henrietta Sump North | ||
12189 | 12189 | 12188 | {"type": "Polygon", "coordinates": [[[-118.36681, 33.81599], [-118.36674, 33.81603], [-118.36641, 33.81553], [-118.36652, 33.81548], [-118.36669, 33.81573], [-118.36666, 33.81576], [-118.36681, 33.81599]]]} | No Public Access 3 | Greenbelt SE Bindewald SE Calle Mayor | 29168 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 0.159 | Greenbelt SE Bindewald SE Calle Mayor |
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]);