units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
73 rows where MNG_AGENCY = 288 and MNG_AG_TYP = 2 sorted by UNIT_ID
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7040 | 7040 | 7039 | {"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 | 6014 | Greenwood Park | 19489 | 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.437 | Greenwood Park | 0 | Local Park 2 | 4 | |
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 | |
7042 | 7042 | 7041 | {"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 | 6016 | Torrance Park | 26468 | 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 | 8.192 | Torrance Park | 0 | Local Park 2 | 4 | |
952 | 952 | 951 | {"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.3134, 33.81048], [-118.3134, 33.81055], [-118.3144, 33.81056]]]} | Open Access 1 | 6018 | Sur La Brea Park | 26075 | 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 | 7.422 | Sur La Brea 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 | |
954 | 954 | 953 | {"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 | 6020 | Pueblo Park | 29902 | 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.689 | Pueblo Park | 0 | Local Park 2 | 4 | |
7045 | 7045 | 7044 | {"type": "Polygon", "coordinates": [[[-118.31349, 33.86923], [-118.31348, 33.86924], [-118.31348, 33.8706], [-118.31239, 33.8706], [-118.3124, 33.86962], [-118.31224, 33.86961], [-118.31223, 33.86931], [-118.31239, 33.8693], [-118.3124, 33.86778], [-118.31349, 33.86779], [-118.31349, 33.86923]]]} | Open Access 1 | 6021 | Guenser Park | 19562 | 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 | 7.929 | Guenser 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 | |
7047 | 7047 | 7046 | {"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 | 6023 | La Carretera Park | 20746 | 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.718 | La Carretera 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 | |
7050 | 7050 | 7049 | {"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.87174], [-118.33523, 33.87173], [-118.33524, 33.87142], [-118.33646, 33.87142], [-118.33648, 33.87123], [-118.33735, 33.87123], [-118.33735, 33.8727]]]} | Open Access 1 | 6032 | McMaster Park | 22057 | 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 | 6.47 | McMaster Park | 0 | Local Park 2 | 4 | |
7051 | 7051 | 7050 | {"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 | 6033 | Osage Park | 23231 | 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.164 | Osage Park | 0 | Local Park 2 | 4 | |
7052 | 7052 | 7051 | {"type": "Polygon", "coordinates": [[[-118.34927, 33.86776], [-118.34859, 33.86777], [-118.34859, 33.86737], [-118.34913, 33.86737], [-118.34911, 33.86744], [-118.34914, 33.86747], [-118.3492, 33.86748], [-118.34926, 33.86746], [-118.34927, 33.86776]]]} | Open Access 1 | 6034 | Pequeno Park | 23603 | 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.641 | Pequeno Park | 0 | Local Park 2 | 4 | |
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 | |
13399 | 13399 | 13398 | {"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 | 35507 | Greenbelt SE Bindewald NW Calle Mayor | 29167 | 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.109 | Greenbelt SE Bindewald NW Calle Mayor | None 1154 | |||
13402 | 13402 | 13401 | {"type": "Polygon", "coordinates": [[[-118.34493, 33.82494], [-118.34486, 33.82494], [-118.34458, 33.82455], [-118.34448, 33.82436], [-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.81903], [-118.34452, 33.81903], [-118.34448, 33.8192], [-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 | 35514 | Madrona Right of Way North | 29171 | 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.486 | Madrona Right of Way North | None 1155 | |||
13403 | 13403 | 13402 | {"type": "Polygon", "coordinates": [[[-118.37216, 33.84447], [-118.37209, 33.84464], [-118.37153, 33.84465], [-118.37154, 33.84487], [-118.37204, 33.84487], [-118.37204, 33.84613], [-118.37186, 33.8462], [-118.37123, 33.8462], [-118.37123, 33.8461], [-118.37115, 33.84609], [-118.37115, 33.84447], [-118.37216, 33.84447]]]} | No Public Access 3 | 35515 | Henrietta Sump North | 29169 | 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.606 | Henrietta Sump North | None 1156 | |||
13404 | 13404 | 13403 | {"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.85236], [-118.34525, 33.85217], [-118.34549, 33.85211], [-118.3468, 33.85259], [-118.3468, 33.85338]]]} | No Public Access 3 | 35516 | Retention Basin N Del Amo and Prairie | 29175 | 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.92 | Retention Basin N Del Amo and Prairie | None 1157 | |||
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 | |||
13406 | 13406 | 13405 | {"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 | 35518 | Henrietta Sump South | 29170 | 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.258 | Henrietta Sump South | None 1159 |
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]);