superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
49 rows where ACCESS_TYP = 1 and MNG_AGENCY = 288 sorted by map
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY
MNG_AG_TYP 1
- City Agency 49
ACCESS_TYP 1
- Open Access · 49 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3919 | 3919 | 3918 | {"type": "MultiPolygon", "coordinates": [[[[-118.31874, 33.83299], [-118.3174, 33.83403], [-118.31715, 33.83381], [-118.31849, 33.83277], [-118.31874, 33.83299]]], [[[-118.32028, 33.83181], [-118.31891, 33.83287], [-118.31866, 33.83264], [-118.32004, 33.83159], [-118.32028, 33.83181]]], [[[-118.32091, 33.83125], [-118.32091, 33.83125], [-118.32024, 33.83126], [-118.3206, 33.83097], [-118.32091, 33.83125]]], [[[-118.32096, 33.83147], [-118.32058, 33.83176], [-118.32027, 33.83147], [-118.32027, 33.83147], [-118.32096, 33.83147]]]]} | Open Access 1 | El Prado Park | 18532 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 3.356 | El Prado 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 | ||
4817 | 4817 | 4816 | {"type": "Polygon", "coordinates": [[[-118.31349, 33.86923], [-118.31348, 33.86925], [-118.31348, 33.8706], [-118.31239, 33.8706], [-118.3124, 33.86963], [-118.31224, 33.86961], [-118.31223, 33.86931], [-118.31239, 33.86929], [-118.3124, 33.86778], [-118.31349, 33.86779], [-118.31349, 33.86923]]]} | Open Access 1 | Guenser Park | 19562 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 7.932 | Guenser Park | ||
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 | ||
5800 | 5800 | 5799 | {"type": "Polygon", "coordinates": [[[-118.31564, 33.86189], [-118.31348, 33.86189], [-118.31348, 33.86097], [-118.31564, 33.86182], [-118.31564, 33.86189]]]} | Open Access 1 | La Carretera Park | 20746 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 2.717 | La Carretera Park | ||
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 | ||
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 | ||
3581 | 3581 | 3580 | {"type": "Polygon", "coordinates": [[[-118.32204, 33.87195], [-118.32201, 33.87198], [-118.32196, 33.87198], [-118.32167, 33.87193], [-118.32153, 33.87187], [-118.32076, 33.87146], [-118.32061, 33.87139], [-118.32046, 33.87136], [-118.32045, 33.871], [-118.32204, 33.871], [-118.32204, 33.87195]]]} | Open Access 1 | Descanso Park | 18110 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 2.84 | Descanso Park | ||
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 | ||
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 | ||
2848 | 2848 | 2847 | {"type": "Polygon", "coordinates": [[[-118.32837, 33.82753], [-118.3224, 33.82758], [-118.3212, 33.82649], [-118.32164, 33.82648], [-118.32164, 33.82567], [-118.32083, 33.82567], [-118.32011, 33.82549], [-118.31996, 33.82532], [-118.31991, 33.82531], [-118.31954, 33.82496], [-118.31917, 33.82465], [-118.31917, 33.82463], [-118.31928, 33.82473], [-118.31967, 33.82494], [-118.31984, 33.825], [-118.32016, 33.82509], [-118.32045, 33.82512], [-118.32835, 33.82506], [-118.32837, 33.82753]]]} | Open Access 1 | Charles H. Wilson Park | 17139 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 44.168 | Charles H. Wilson Park | ||
4746 | 4746 | 4745 | {"type": "Polygon", "coordinates": [[[-118.33331, 33.83428], [-118.33231, 33.83429], [-118.3323, 33.83292], [-118.33329, 33.83291], [-118.33331, 33.83428]]]} | Open Access 1 | Greenwood Park | 19489 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 3.436 | Greenwood Park | ||
1457 | 1457 | 1456 | {"type": "Polygon", "coordinates": [[[-118.33348, 33.78451], [-118.33347, 33.78464], [-118.33301, 33.78463], [-118.33301, 33.78506], [-118.33137, 33.78506], [-118.33136, 33.78393], [-118.3318, 33.78349], [-118.333, 33.78404], [-118.33302, 33.78448], [-118.33348, 33.78451]]]} | Open Access 1 | Alta Loma Park | 15416 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 5.656 | Alta Loma Park | ||
5102 | 5102 | 5101 | {"type": "Polygon", "coordinates": [[[-118.33649, 33.81859], [-118.33616, 33.81859], [-118.33615, 33.81847], [-118.3343, 33.81811], [-118.33447, 33.81796], [-118.33452, 33.81789], [-118.33492, 33.8171], [-118.33494, 33.81708], [-118.33522, 33.81714], [-118.33555, 33.81718], [-118.3358, 33.81716], [-118.33611, 33.81713], [-118.33647, 33.81713], [-118.33649, 33.81715], [-118.33649, 33.81718], [-118.33649, 33.81859]]]} | Open Access 1 | Hickory Park | 19897 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 5.808 | Hickory Park | ||
6850 | 6850 | 6849 | {"type": "Polygon", "coordinates": [[[-118.33735, 33.8727], [-118.33529, 33.8727], [-118.33524, 33.87266], [-118.33523, 33.87243], [-118.33565, 33.87242], [-118.33573, 33.87236], [-118.33573, 33.87175], [-118.33523, 33.87173], [-118.33524, 33.87142], [-118.33645, 33.87142], [-118.33648, 33.87123], [-118.33735, 33.87123], [-118.33735, 33.8727]]]} | Open Access 1 | McMaster Park | 22057 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 6.478 | McMaster Park | ||
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. | |
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 | ||
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 | ||
7775 | 7775 | 7774 | {"type": "Polygon", "coordinates": [[[-118.3448, 33.87548], [-118.3447, 33.8756], [-118.34443, 33.87557], [-118.34446, 33.87536], [-118.3445, 33.87534], [-118.34463, 33.87538], [-118.3448, 33.87548]]]} | Open Access 1 | Osage Park | 23231 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 0.164 | Osage Park | ||
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 |
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]);