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)
ACCESS_TYP 2
- Open Access 41
- No Public Access 11
MNG_AG_TYP 1
- City Agency 52
MNG_AGENCY 1
- Torrance, City of · 52 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12188 | 12188 | 12187 | {"type": "Polygon", "coordinates": [[[-118.36643, 33.81533], [-118.36631, 33.81539], [-118.36612, 33.8151], [-118.36624, 33.81505], [-118.36643, 33.81533]]]} | Open Access 1 | Greenbelt SE Bindewald NW Calle Mayor | 29167 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 0.108 | Greenbelt SE Bindewald NW Calle Mayor | ||
12185 | 12185 | 12184 | {"type": "Polygon", "coordinates": [[[-118.36777, 33.81735], [-118.36765, 33.8174], [-118.36727, 33.81683], [-118.36739, 33.81678], [-118.36777, 33.81735]]]} | Open Access 1 | Greenbelt near Bindewald St | 29165 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 0.215 | Greenbelt near Bindewald St | ||
12184 | 12184 | 12183 | {"type": "Polygon", "coordinates": [[[-118.37851, 33.80851], [-118.37849, 33.80863], [-118.37845, 33.80865], [-118.3784, 33.80865], [-118.37822, 33.80858], [-118.3782, 33.80855], [-118.37821, 33.80851], [-118.37825, 33.80849], [-118.37843, 33.80846], [-118.37849, 33.80847], [-118.37851, 33.80851]]]} | Open Access 1 | Grass Median Calle Miramar and Calle Aragon | 29164 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 0.108 | Grass Median Calle Miramar and Calle Aragon | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | |
11257 | 11257 | 11256 | {"type": "Polygon", "coordinates": [[[-118.32505, 33.84668], [-118.32406, 33.84668], [-118.32406, 33.8464], [-118.32504, 33.8464], [-118.32505, 33.84668]]]} | Open Access 1 | Pueblo Park | 29902 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 0.688 | Pueblo Park | ||
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 | ||
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 |
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]);