superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
20 rows where ACCESS_TYP = 3 and MNG_AGENCY = 288
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency 20
MNG_AGENCY 1
- Torrance, City of · 20 ✖
ACCESS_TYP 1
- No Public Access · 20 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
12114 | 12114 | 12113 | {"type": "Polygon", "coordinates": [[[-118.3507, 33.84601], [-118.34892, 33.84601], [-118.34892, 33.84506], [-118.3507, 33.84506], [-118.3507, 33.84601]]]} | No Public Access 3 | Amie Sump | 29076 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 4.268 | Amie Sump | ||
12117 | 12117 | 12116 | {"type": "Polygon", "coordinates": [[[-118.37164, 33.83617], [-118.37117, 33.83684], [-118.36977, 33.83684], [-118.36976, 33.83423], [-118.37087, 33.83423], [-118.37163, 33.8351], [-118.37164, 33.83617]]]} | No Public Access 3 | Bishop Montgomery Sump | 29080 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 11.206 | Bishop Montgomery Sump | ||
12118 | 12118 | 12117 | {"type": "Polygon", "coordinates": [[[-118.33191, 33.83843], [-118.33118, 33.83844], [-118.33117, 33.83735], [-118.33189, 33.83735], [-118.33191, 33.83843]]]} | No Public Access 3 | Elm Tree Water Yard | 29081 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1.999 | Elm Tree Water Yard | ||
12119 | 12119 | 12118 | {"type": "Polygon", "coordinates": [[[-118.32429, 33.80965], [-118.32389, 33.80965], [-118.32389, 33.80924], [-118.32429, 33.80924], [-118.32429, 33.80965]]]} | No Public Access 3 | Empty Lot 237th and Vine | 29082 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 0.419 | Empty Lot 237th and Vine | ||
12152 | 12152 | 12151 | {"type": "Polygon", "coordinates": [[[-118.36997, 33.85242], [-118.36984, 33.85268], [-118.3688, 33.85252], [-118.36836, 33.85236], [-118.36835, 33.85206], [-118.36887, 33.85225], [-118.36997, 33.85242]]]} | No Public Access 3 | Entradero Swale 1 | 29125 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1.121 | Entradero Swale 1 | ||
12153 | 12153 | 12152 | {"type": "Polygon", "coordinates": [[[-118.36816, 33.85229], [-118.36737, 33.85201], [-118.36714, 33.85196], [-118.36699, 33.85194], [-118.36552, 33.85194], [-118.36523, 33.85193], [-118.36523, 33.85167], [-118.367, 33.85167], [-118.36731, 33.85171], [-118.3675, 33.85176], [-118.36815, 33.85199], [-118.36816, 33.85229]]]} | No Public Access 3 | Entradero Swale 2 | 29126 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 2.072 | Entradero Swale 2 | ||
12154 | 12154 | 12153 | {"type": "Polygon", "coordinates": [[[-118.36523, 33.85193], [-118.36463, 33.85189], [-118.36301, 33.85189], [-118.36254, 33.85186], [-118.36247, 33.85167], [-118.36523, 33.85167], [-118.36523, 33.85193]]]} | No Public Access 3 | Entradero Swale 3 | 29127 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1.524 | Entradero Swale 3 | ||
12172 | 12172 | 12171 | {"type": "Polygon", "coordinates": [[[-118.36219, 33.85184], [-118.36169, 33.85181], [-118.36169, 33.85167], [-118.36213, 33.85167], [-118.36219, 33.85184]]]} | No Public Access 3 | Entradero Swale 4 | 29148 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 0.181 | Entradero Swale 4 | ||
12182 | 12182 | 12181 | {"type": "Polygon", "coordinates": [[[-118.36169, 33.85181], [-118.35893, 33.85181], [-118.35893, 33.85167], [-118.36169, 33.85167], [-118.36169, 33.85181]]]} | No Public Access 3 | Entradero Swale 5 | 29162 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 0.957 | Entradero Swale 5 | ||
12183 | 12183 | 12182 | {"type": "Polygon", "coordinates": [[[-118.35893, 33.85167], [-118.35893, 33.85181], [-118.35772, 33.85181], [-118.35772, 33.85168], [-118.35893, 33.85167]]]} | No Public Access 3 | Entradero Swale 6 | 29163 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 0.421 | Entradero Swale 6 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 |
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]);