units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
73 rows where MNG_AGENCY = 288 sorted by UNIT_NAME
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_ID, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, LABEL_NAME, GAP_STS
DES_TP 31
ACCESS_TYP 3
AGNCY_NAME 2 ✖
MNG_AG_TYP 1
- City Agency 73
MNG_AGENCY 1
- Torrance, City of · 73 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
7002 | 7002 | 7001 | {"type": "Polygon", "coordinates": [[[-118.33348, 33.78451], [-118.33347, 33.78464], [-118.333, 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 | 5977 | Alta Loma Park | 15416 | 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 | 5.65 | Alta Loma Park | 0 | Local Park 2 | 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 | |||
13405 | 13405 | 13404 | {"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 | 35517 | Bishop Montgomery Sump | 29080 | 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 | 11.207 | Bishop Montgomery Sump | None 1158 | |||
7041 | 7041 | 7040 | {"type": "Polygon", "coordinates": [[[-118.32837, 33.82753], [-118.3224, 33.82758], [-118.3212, 33.82649], [-118.32165, 33.82648], [-118.32164, 33.82567], [-118.32082, 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.32017, 33.82509], [-118.32045, 33.82512], [-118.32835, 33.82506], [-118.32837, 33.82753]]]} | Open Access 1 | 6015 | Charles H. Wilson Park | 17139 | 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 | 44.163 | Charles H. Wilson Park | 0 | Local Park 2 | 4 | |
4356 | 4356 | 4355 | {"type": "Polygon", "coordinates": [[[-118.34726, 33.86193], [-118.344, 33.86193], [-118.34399, 33.8613], [-118.3466, 33.8613], [-118.3466, 33.85844], [-118.34725, 33.85844], [-118.34726, 33.85838], [-118.34726, 33.86193]]]} | Open Access 1 | 45709 | Columbia Park | 17547 | 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 | 10.024 | Columbia Park | 0 | Local Park 2 | 4 | |
7046 | 7046 | 7045 | {"type": "MultiPolygon", "coordinates": [[[[-118.3466, 33.8613], [-118.34388, 33.8613], [-118.34388, 33.85839], [-118.3466, 33.85839], [-118.3466, 33.8613]]], [[[-118.35089, 33.85921], [-118.35089, 33.85978], [-118.35065, 33.85979], [-118.35065, 33.86184], [-118.34815, 33.86185], [-118.34814, 33.86193], [-118.34726, 33.86193], [-118.34726, 33.85838], [-118.34769, 33.85838], [-118.3477, 33.85844], [-118.34814, 33.85844], [-118.34814, 33.85921], [-118.35089, 33.85921]], [[-118.34908, 33.86044], [-118.34907, 33.86058], [-118.34919, 33.86057], [-118.34919, 33.86044], [-118.34908, 33.86044]], [[-118.34995, 33.85985], [-118.34996, 33.85955], [-118.34962, 33.85956], [-118.34962, 33.85985], [-118.34995, 33.85985]]]]} | Open Access 1 | 6022 | Columbia Park | 17547 | 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 | 44.851 | Columbia Park | 0 | Local Park 2 | 4 | |
1940 | 1940 | 1939 | {"type": "Polygon", "coordinates": [[[-118.34494, 33.79301], [-118.34492, 33.79305], [-118.34466, 33.79321], [-118.34429, 33.79334], [-118.3441, 33.79344], [-118.34397, 33.79361], [-118.34392, 33.79376], [-118.34393, 33.79384], [-118.34395, 33.79393], [-118.34402, 33.79406], [-118.3446, 33.79461], [-118.34474, 33.79472], [-118.34486, 33.79478], [-118.34466, 33.79513], [-118.34181, 33.794], [-118.34202, 33.79363], [-118.34212, 33.79361], [-118.34222, 33.79352], [-118.34229, 33.79333], [-118.34243, 33.79307], [-118.34273, 33.79255], [-118.34284, 33.79243], [-118.34288, 33.79237], [-118.34289, 33.79229], [-118.34284, 33.7922], [-118.343, 33.79194], [-118.34397, 33.79233], [-118.34433, 33.79251], [-118.34452, 33.79264], [-118.34474, 33.79281], [-118.34493, 33.79296], [-118.34494, 33.79301]]]} | Open Access 1 | 5999 | De Portola Park | 17975 | 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 | 12.592 | De Portola Park | 0 | Local Park 2 | 4 | |
7039 | 7039 | 7038 | {"type": "Polygon", "coordinates": [[[-118.34715, 33.84786], [-118.3454, 33.84786], [-118.34539, 33.84679], [-118.34501, 33.84679], [-118.34499, 33.8467], [-118.34496, 33.84641], [-118.34497, 33.84505], [-118.34606, 33.84505], [-118.34606, 33.84678], [-118.34714, 33.84678], [-118.34715, 33.84786]]]} | Open Access 1 | 6011 | Delthorne Park | 18078 | 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 | 9.587 | Delthorne Park | 0 | Local Park 2 | 4 | |
7049 | 7049 | 7048 | {"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 | 6031 | Descanso Park | 18110 | 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.84 | Descanso Park | 0 | Local Park 2 | 4 | |
6946 | 6946 | 6945 | {"type": "Polygon", "coordinates": [[[-118.35427, 33.82352], [-118.35426, 33.82376], [-118.35369, 33.82371], [-118.35368, 33.82345], [-118.35424, 33.82349], [-118.35427, 33.82352]]]} | Open Access 1 | 6004 | Discovery Park | 18166 | 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.395 | Discovery Park | 0 | Local Park 2 | 4 | |
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 | |||
7053 | 7053 | 7052 | {"type": "Polygon", "coordinates": [[[-118.35868, 33.86546], [-118.35684, 33.86546], [-118.35683, 33.86187], [-118.35719, 33.86215], [-118.35746, 33.86238], [-118.3578, 33.86274], [-118.35812, 33.86318], [-118.35831, 33.86354], [-118.35838, 33.86373], [-118.35847, 33.86373], [-118.35855, 33.86395], [-118.35865, 33.8644], [-118.35868, 33.86467], [-118.35868, 33.86546]]]} | Open Access 1 | 6035 | El Nido Park | 18521 | 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 | 12.292 | El Nido Park | 0 | Local Park 2 | 4 | |
953 | 953 | 952 | {"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 | 6019 | El Prado Park | 18532 | 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 | 3.357 | El Prado Park | 0 | Local Park 2 | 4 | |
950 | 950 | 949 | {"type": "Polygon", "coordinates": [[[-118.37986, 33.81559], [-118.37947, 33.8157], [-118.37941, 33.81576], [-118.37708, 33.81546], [-118.37702, 33.81542], [-118.37673, 33.81482], [-118.37681, 33.81477], [-118.37702, 33.81473], [-118.37726, 33.8147], [-118.37777, 33.8147], [-118.3781, 33.81476], [-118.37848, 33.81488], [-118.37879, 33.81503], [-118.37914, 33.81529], [-118.37933, 33.81549], [-118.37968, 33.81529], [-118.37975, 33.81538], [-118.37986, 33.81559]]]} | Open Access 1 | 5989 | El Retiro Park | 18536 | 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.786 | El Retiro Park | 0 | Local Park 2 | 4 | |
3898 | 3898 | 3897 | {"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 | 35859 | Elm Tree Water Yard | 29081 | 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.0 | Elm Tree Water Yard | None 333 | |||
3582 | 3582 | 3581 | {"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 | 36688 | Empty Lot 237th and Vine | 29082 | 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.419 | Empty Lot 237th and Vine | 0 | Local Other or Unknown 14 | 4 | |
7037 | 7037 | 7036 | {"type": "Polygon", "coordinates": [[[-118.37364, 33.85464], [-118.37353, 33.85466], [-118.37302, 33.85512], [-118.37144, 33.85512], [-118.37143, 33.85544], [-118.37125, 33.85545], [-118.37124, 33.85512], [-118.37086, 33.85512], [-118.37055, 33.85389], [-118.36985, 33.85267], [-118.36996, 33.85242], [-118.36996, 33.85174], [-118.37048, 33.85173], [-118.37049, 33.85135], [-118.37067, 33.85135], [-118.37067, 33.85173], [-118.37209, 33.85173], [-118.37254, 33.85199], [-118.37294, 33.85219], [-118.37316, 33.85221], [-118.37364, 33.85464]]]} | Open Access 1 | 6009 | Entradero Park | 18687 | 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 | 25.683 | Entradero Park | 0 | Local Park 2 | 4 | |
3901 | 3901 | 3900 | {"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 | 35902 | Entradero Swale 1 | 29125 | 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.121 | Entradero Swale 1 | None 335 | |||
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 |
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]);