units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
73 rows where MNG_AGENCY = 288 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, LABEL_NAME, GAP_STS
Link | rowid ▲ | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17047 | 17047 | 17046 | {"type": "Polygon", "coordinates": [[[-118.343, 33.82914], [-118.34294, 33.82915], [-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 | 46012 | Madrona Marsh Nature Center | 29332 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.friendsofmadronamarsh.com/index.shtml | Los Angeles 6 | 1.986 | Madrona Marsh Nature Ctr. | 0 | Local Park 2 | 4 |
16245 | 16245 | 16244 | {"type": "Polygon", "coordinates": [[[-118.32437, 33.83122], [-118.32371, 33.83123], [-118.32371, 33.83073], [-118.32329, 33.83036], [-118.32348, 33.83021], [-118.32436, 33.83102], [-118.32437, 33.83122]]]} | Restricted Access 2 | 35907 | ATTIC Teen Center | 32631 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | https://www.torranceca.gov/our-city/recreation/attic | Los Angeles 6 | 1.086 | ATTIC Teen Ctr. | 0 | Local Recreation Area 3 | 4 |
15664 | 15664 | 15663 | {"type": "Polygon", "coordinates": [[[-118.36766, 33.8205], [-118.36765, 33.82168], [-118.36593, 33.82168], [-118.36593, 33.82131], [-118.36641, 33.82131], [-118.36641, 33.82087], [-118.36594, 33.82085], [-118.36594, 33.82049], [-118.36766, 33.8205]]]} | Restricted Access 2 | 6001 | Sea-Aire Golf Course | 33004 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 4.628 | Sea-Aire GC | 0 | Local Recreation Area 3 | 4 | |
15382 | 15382 | 15381 | {"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 | 46597 | Toyota Sports Complex | 29898 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/27330.htm | Los Angeles 6 | 6.221 | Toyota Sports Complex | 0 | Local Recreation Area 3 | 4 |
15163 | 15163 | 15162 | {"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 | 46013 | Sea-Aire Parklette | 29333 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 0.549 | Sea-Aire Parklette | None 1321 | |||
14947 | 14947 | 14946 | {"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 | 45548 | Seaside Heroes Park | 28376 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/Parks/22840.htm | Los Angeles 6 | 1.202 | Seaside Heroes Park | 0 | Local Park 2 | 4 |
13981 | 13981 | 13980 | {"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.374, 33.82188], [-118.37443, 33.82141]]]} | No Public Access 3 | 36651 | Torrance holding 11 | 26417 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 0.738 | Torrance holding 11 | 0 | Local Other or Unknown 14 | 4 | |
13577 | 13577 | 13576 | {"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 | 35908 | Amie Sump | 29076 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 4.269 | Amie Sump | None 1174 | |||
13575 | 13575 | 13574 | {"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 | 35901 | Entradero Swale 3 | 29127 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 1.525 | Entradero Swale 3 | None 1173 | |||
13574 | 13574 | 13573 | {"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 | 35897 | Greenbelt near Bindewald St | 29165 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 0.215 | Greenbelt near Bindewald St | None 1172 | |||
13568 | 13568 | 13567 | {"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 | 35886 | Maple Sump | 29173 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 1.132 | Maple Sump | None 1171 | |||
13550 | 13550 | 13549 | {"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 | 35865 | Drain to Walteria Lake | 29193 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 1.879 | Drain to Walteria Lake | None 1169 | |||
13549 | 13549 | 13548 | {"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 | 35909 | Entradero Swale 5 | 29162 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 0.961 | Entradero Swale 5 | None 1168 | |||
13548 | 13548 | 13547 | {"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.80313], [-118.36024, 33.80307], [-118.36032, 33.80301], [-118.36169, 33.80417], [-118.36209, 33.80417], [-118.3621, 33.80422]]]} | Open Access 1 | 35864 | Torrance holding 16 | 26422 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 0.59 | Torrance holding 16 | 0 | Local Other or Unknown 14 | 4 | |
13547 | 13547 | 13546 | {"type": "Polygon", "coordinates": [[[-118.34459, 33.81799], [-118.34451, 33.81822], [-118.34448, 33.81848], [-118.34446, 33.81848], [-118.34446, 33.81894], [-118.34443, 33.81903], [-118.34436, 33.81902], [-118.34436, 33.81829], [-118.3444, 33.81815], [-118.34436, 33.81814], [-118.34436, 33.81789], [-118.34459, 33.81799]]]} | Open Access 1 | 35863 | Madrona Right of Way South | 29172 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 0.349 | Madrona Right of Way South | None 1167 | |||
13533 | 13533 | 13532 | {"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 | 35838 | Entradero Swale 2 | 29126 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 2.072 | Entradero Swale 2 | None 1166 | |||
13529 | 13529 | 13528 | {"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 | 35827 | Slope-Vista Montana | 29200 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 2.382 | Slope-Vista Montana | None 1165 | |||
13528 | 13528 | 13527 | {"type": "Polygon", "coordinates": [[[-118.36681, 33.81599], [-118.36674, 33.81603], [-118.36641, 33.81553], [-118.36652, 33.81548], [-118.36669, 33.81573], [-118.36665, 33.81575], [-118.36681, 33.81599]]]} | No Public Access 3 | 35826 | Greenbelt SE Bindewald SE Calle Mayor | 29168 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 0.158 | Greenbelt SE Bindewald SE Calle Mayor | None 1164 | |||
13518 | 13518 | 13517 | {"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 | 35830 | Torrance holding 6 | 26464 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 0.06 | Torrance holding 6 | 0 | Local Other or Unknown 14 | 4 | |
13503 | 13503 | 13502 | {"type": "Polygon", "coordinates": [[[-118.37443, 33.81802], [-118.37442, 33.81909], [-118.37381, 33.81909], [-118.37372, 33.81907], [-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 | 35795 | Torrance holding 23 | 26430 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 2.901 | Torrance holding 23 | 0 | Local Other or Unknown 14 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);