trees
7,322 rows where qSpecies_id = 1 sorted by Longitude
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▼ | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 162737 | 11988 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1200X La Salle Ave | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6017464.4799176 | 2094331.6246005 | 37.7316151284675 | -122.381940767084 | (37.7316151284675, -122.381940767084) | 10 | 3 | 8 | 58 | 1 | ||
| 177884 | 11983 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1200X La Salle Ave | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/10/2007 12:00:00 AM | 3 | 3X3 | 6017464.4799176 | 2094331.6246005 | 37.7316151284675 | -122.381940767084 | (37.7316151284675, -122.381940767084) | 10 | 3 | 8 | 58 | 1 | ||
| 184787 | 11981 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1200X La Salle Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/10/2007 12:00:00 AM | 6 | 6017464.4799176 | 2094331.6246005 | 37.7316151284675 | -122.381940767084 | (37.7316151284675, -122.381940767084) | 10 | 3 | 8 | 58 | 1 | |||
| 47952 | 198225 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1195 La Salle Ave | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6017442.1049 | 2094354.63766 | 37.731677082136 | -122.382019722937 | (37.731677082136, -122.382019722937) | 10 | 3 | 8 | 58 | 1 | |||
| 136412 | 198202 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1196 La Salle Ave | 26 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017386.73333 | 2094343.85008 | 37.7316444034471 | -122.38221040528 | (37.7316444034471, -122.38221040528) | 10 | 3 | 8 | 58 | 1 | |||
| 154359 | 198201 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1196 La Salle Ave | 24 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6017349.13992 | 2094376.34522 | 37.7317315522718 | -122.382342634421 | (37.7317315522718, -122.382342634421) | 10 | 3 | 8 | 58 | 1 | |||
| 96171 | 198226 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1195 La Salle Ave | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6017330.47755 | 2094444.88766 | 37.7319187254481 | -122.38241192178 | (37.7319187254481, -122.38241192178) | 10 | 3 | 8 | 58 | 1 | |||
| 133071 | 12066 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1225X La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/17/2007 12:00:00 AM | 3 | 3X3 | 6017323.1868972 | 2094393.2571117 | 37.7317765554235 | -122.382433536417 | (37.7317765554235, -122.382433536417) | 10 | 3 | 8 | 58 | 1 | ||
| 45241 | 12017 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1230X La Salle Ave | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/25/2011 12:00:00 AM | 6 | 3X3 | 6017323.1168478 | 2094452.6646717 | 37.7319396729967 | -122.382437910438 | (37.7319396729967, -122.382437910438) | 10 | 3 | 8 | 58 | 1 | ||
| 66613 | 12003 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1230X La Salle Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6017323.1168478 | 2094452.6646717 | 37.7319396729967 | -122.382437910438 | (37.7319396729967, -122.382437910438) | 10 | 3 | 8 | 58 | 1 | |||
| 67634 | 12007 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1230X La Salle Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6017323.1168478 | 2094452.6646717 | 37.7319396729967 | -122.382437910438 | (37.7319396729967, -122.382437910438) | 10 | 3 | 8 | 58 | 1 | ||
| 79166 | 12001 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1230X La Salle Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6017323.1168478 | 2094452.6646717 | 37.7319396729967 | -122.382437910438 | (37.7319396729967, -122.382437910438) | 10 | 3 | 8 | 58 | 1 | ||
| 80983 | 12009 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1230X La Salle Ave | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2006 12:00:00 AM | 3 | 3X3 | 6017323.1168478 | 2094452.6646717 | 37.7319396729967 | -122.382437910438 | (37.7319396729967, -122.382437910438) | 10 | 3 | 8 | 58 | 1 | ||
| 121214 | 12005 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1230X La Salle Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/25/2011 12:00:00 AM | 6 | 3X3 | 6017323.1168478 | 2094452.6646717 | 37.7319396729967 | -122.382437910438 | (37.7319396729967, -122.382437910438) | 10 | 3 | 8 | 58 | 1 | ||
| 163424 | 12000 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1230X La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/09/1997 12:00:00 AM | 6 | 3X3 | 6017323.1168478 | 2094452.6646717 | 37.7319396729967 | -122.382437910438 | (37.7319396729967, -122.382437910438) | 10 | 3 | 8 | 58 | 1 | ||
| 39971 | 198227 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1195 La Salle Ave | 22 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6017315.65564 | 2094453.93145 | 37.7319427391711 | -122.382463793784 | (37.7319427391711, -122.382463793784) | 10 | 3 | 8 | 58 | 1 | |||
| 153205 | 198228 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1195 La Salle Ave | 23 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6017291.31263 | 2094471.73061 | 37.7319902674316 | -122.382549191609 | (37.7319902674316, -122.382549191609) | 10 | 3 | 8 | 58 | 1 | |||
| 46477 | 10787 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1200X Hudson Ave | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/26/2011 12:00:00 AM | 3 | 3x4 | 6017289.30037 | 2095275.75897 | 37.7341978590464 | -122.382612074644 | (37.7341978590464, -122.382612074644) | 10 | 3 | 8 | 58 | 1 | ||
| 183693 | 198229 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1195 La Salle Ave | 25 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6017254.92749 | 2094491.22957 | 37.7320417976787 | -122.382676340454 | (37.7320417976787, -122.382676340454) | 10 | 3 | 8 | 58 | 1 | |||
| 102890 | 198200 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1196 La Salle Ave | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017252.54934 | 2094443.2087 | 37.7319098104682 | -122.382681221984 | (37.7319098104682, -122.382681221984) | 10 | 3 | 8 | 58 | 1 | |||
| 180581 | 82684 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1232 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2009 12:00:00 AM | 3x3 | Permit Number 52464 | 6017221.0779692 | 2093189.9141815 | 37.7284667714932 | -122.382702846182 | (37.7284667714932, -122.382702846182) | 10 | 3 | 8 | 58 | 1 | ||
| 54149 | 198199 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1196 La Salle Ave | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017229.03163 | 2094455.22326 | 37.7319415007983 | -122.38276336425 | (37.7319415007983, -122.38276336425) | 10 | 3 | 8 | 58 | 1 | |||
| 4920 | 12041 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1250X La Salle Ave | 23 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6017218.4556902 | 2094518.641349 | 37.7321150500381 | -122.382804339533 | (37.7321150500381, -122.382804339533) | 10 | 3 | 8 | 58 | 1 | ||
| 39079 | 12024 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1250X La Salle Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2006 12:00:00 AM | 3 | 3X3 | 6017218.4556902 | 2094518.641349 | 37.7321150500381 | -122.382804339533 | (37.7321150500381, -122.382804339533) | 10 | 3 | 8 | 58 | 1 | ||
| 49580 | 12028 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1250X La Salle Ave | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6017218.4556902 | 2094518.641349 | 37.7321150500381 | -122.382804339533 | (37.7321150500381, -122.382804339533) | 10 | 3 | 8 | 58 | 1 | ||
| 64166 | 12034 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1250X La Salle Ave | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6017218.4556902 | 2094518.641349 | 37.7321150500381 | -122.382804339533 | (37.7321150500381, -122.382804339533) | 10 | 3 | 8 | 58 | 1 | ||
| 82106 | 12026 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1250X La Salle Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6017218.4556902 | 2094518.641349 | 37.7321150500381 | -122.382804339533 | (37.7321150500381, -122.382804339533) | 10 | 3 | 8 | 58 | 1 | ||
| 129952 | 12035 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1250X La Salle Ave | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/08/2011 12:00:00 AM | 3 | 3X3 | 6017218.4556902 | 2094518.641349 | 37.7321150500381 | -122.382804339533 | (37.7321150500381, -122.382804339533) | 10 | 3 | 8 | 58 | 1 | ||
| 134419 | 12040 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1250X La Salle Ave | 22 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/05/2011 12:00:00 AM | 0 | 3x3 | 6017218.4556902 | 2094518.641349 | 37.7321150500381 | -122.382804339533 | (37.7321150500381, -122.382804339533) | 10 | 3 | 8 | 58 | 1 | ||
| 137126 | 12048 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1250X La Salle Ave | 30 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6017218.4556902 | 2094518.641349 | 37.7321150500381 | -122.382804339533 | (37.7321150500381, -122.382804339533) | 10 | 3 | 8 | 58 | 1 | ||
| 140054 | 12033 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1250X La Salle Ave | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6017218.4556902 | 2094518.641349 | 37.7321150500381 | -122.382804339533 | (37.7321150500381, -122.382804339533) | 10 | 3 | 8 | 58 | 1 | ||
| 188040 | 12027 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1250X La Salle Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/24/1996 12:00:00 AM | 3 | 3X3 | 6017218.4556902 | 2094518.641349 | 37.7321150500381 | -122.382804339533 | (37.7321150500381, -122.382804339533) | 10 | 3 | 8 | 58 | 1 | ||
| 128837 | 198198 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1196 La Salle Ave | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6017190.95158 | 2094477.91802 | 37.7320017122032 | -122.382896595212 | (37.7320017122032, -122.382896595212) | 10 | 3 | 8 | 58 | 1 | |||
| 84608 | 198230 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1195 La Salle Ave | 30 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6017163.23576 | 2094544.63831 | 37.7321833815383 | -122.382997057562 | (37.7321833815383, -122.382997057562) | 10 | 3 | 8 | 58 | 1 | |||
| 77301 | 198231 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1195 La Salle Ave | 32 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6017152.36813 | 2094550.14066 | 37.7321978894074 | -122.38303501258 | (37.7321978894074, -122.38303501258) | 10 | 3 | 8 | 58 | 1 | |||
| 60764 | 12096 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1261X La Salle Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/23/1996 12:00:00 AM | 6 | 3X3 | 6017141.6501925 | 2094501.7221284 | 37.732064349457 | -122.383068698568 | (37.732064349457, -122.383068698568) | 10 | 3 | 8 | 58 | 1 | ||
| 125062 | 12085 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1261X La Salle Ave | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/27/2007 12:00:00 AM | 3 | 3X3 | 6017141.6501925 | 2094501.7221284 | 37.732064349457 | -122.383068698568 | (37.732064349457, -122.383068698568) | 10 | 3 | 8 | 58 | 1 | ||
| 184460 | 12083 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1261X La Salle Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2007 12:00:00 AM | 3 | 3X3 | 6017141.6501925 | 2094501.7221284 | 37.732064349457 | -122.383068698568 | (37.732064349457, -122.383068698568) | 10 | 3 | 8 | 58 | 1 | ||
| 24233 | 198232 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1195 La Salle Ave | 34 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6017137.15143 | 2094557.735 | 37.7322179011369 | -122.383088149026 | (37.7322179011369, -122.383088149026) | 10 | 3 | 8 | 58 | 1 | |||
| 142098 | 198197 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1196 La Salle Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6017115.48652 | 2094514.63753 | 37.7320983668343 | -122.383160051612 | (37.7320983668343, -122.383160051612) | 10 | 3 | 8 | 58 | 1 | |||
| 174701 | 198233 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1197 La Salle Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6017058.78636 | 2094596.82406 | 37.7323209013811 | -122.383361797428 | (37.7323209013811, -122.383361797428) | 10 | 3 | 8 | 58 | 1 | |||
| 14642 | 12098 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1281X La Salle Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/26/2011 12:00:00 AM | 3 | 3x3 | 6017033.141006 | 2094557.4754692 | 37.7322114406026 | -122.383447721977 | (37.7322114406026, -122.383447721977) | 10 | 3 | 8 | 58 | 1 | ||
| 31397 | 12100 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1281X La Salle Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/26/2011 12:00:00 AM | 3 | 3x3 | 6017033.141006 | 2094557.4754692 | 37.7322114406026 | -122.383447721977 | (37.7322114406026, -122.383447721977) | 10 | 3 | 8 | 58 | 1 | ||
| 138126 | 12107 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1281X La Salle Ave | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/26/2011 12:00:00 AM | 3 | 3x3 | 6017033.141006 | 2094557.4754692 | 37.7322114406026 | -122.383447721977 | (37.7322114406026, -122.383447721977) | 10 | 3 | 8 | 58 | 1 | ||
| 172223 | 12104 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1281X La Salle Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/26/2011 12:00:00 AM | 3 | 3x3 | 6017033.141006 | 2094557.4754692 | 37.7322114406026 | -122.383447721977 | (37.7322114406026, -122.383447721977) | 10 | 3 | 8 | 58 | 1 | ||
| 96154 | 198196 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1196 La Salle Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6017004.80168 | 2094575.859 | 37.7322603518346 | -122.383546977716 | (37.7322603518346, -122.383546977716) | 10 | 3 | 8 | 58 | 1 | |||
| 164134 | 10919 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1351X Hudson Ave | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/18/1993 12:00:00 AM | 4 | 3X4 | 6017015.77395 | 2096001.89725 | 37.7361765755813 | -122.383608288117 | (37.7361765755813, -122.383608288117) | 10 | 3 | 8 | 58 | 1 | ||
| 96575 | 10923 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1345X Hudson Ave | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/09/1998 12:00:00 AM | 3 | 3X4 | 6017013.5679363 | 2096006.7331036 | 37.7361897319358 | -122.383616251853 | (37.7361897319358, -122.383616251853) | 10 | 3 | 8 | 58 | 1 | ||
| 139712 | 12110 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1291X La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/17/2007 12:00:00 AM | 3 | 3X3 | 6016979.7352729 | 2094586.3401911 | 37.7322877456302 | -122.383634368276 | (37.7322877456302, -122.383634368276) | 10 | 3 | 8 | 58 | 1 | ||
| 145670 | 198195 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1196 La Salle Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6016961.24258 | 2094606.88267 | 37.7323431290307 | -122.383699732081 | (37.7323431290307, -122.383699732081) | 10 | 3 | 8 | 58 | 1 | |||
| 63010 | 10913 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1351X Hudson Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X4 | 6016987.51869 | 2096153.00243 | 37.7365899183909 | -122.383716496323 | (37.7365899183909, -122.383716496323) | 10 | 3 | 8 | 58 | 1 | |||
| 110123 | 198234 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1197 La Salle Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6016953.14252 | 2094654.60024 | 37.7324737042796 | -122.383731057235 | (37.7324737042796, -122.383731057235) | 10 | 3 | 8 | 58 | 1 | |||
| 122558 | 12051 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1300X La Salle Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6016940.8085131 | 2094664.4394135 | 37.7325000389111 | -122.383774384054 | (37.7325000389111, -122.383774384054) | 10 | 3 | 8 | 58 | 1 | ||
| 185287 | 12049 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1300X La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12/17/2007 12:00:00 AM | 3 | 3x3 | 6016940.8085131 | 2094664.4394135 | 37.7325000389111 | -122.383774384054 | (37.7325000389111, -122.383774384054) | 10 | 3 | 8 | 58 | 1 | ||
| 100602 | 198235 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1197 La Salle Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6016918.0288 | 2094674.5503 | 37.7325265421628 | -122.383853843478 | (37.7325265421628, -122.383853843478) | 10 | 3 | 8 | 58 | 1 | |||
| 128729 | 198236 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1197 La Salle Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6016883.97507 | 2094695.25955 | 37.7325815231026 | -122.383973018064 | (37.7325815231026, -122.383973018064) | 10 | 3 | 8 | 58 | 1 | |||
| 144965 | 12063 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1330X La Salle Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6016860.8582794 | 2094712.6673543 | 37.732628043472 | -122.384054150964 | (37.732628043472, -122.384054150964) | 10 | 3 | 8 | 58 | 1 | ||
| 102810 | 198239 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1196 La Salle Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6016854.43206 | 2094659.71121 | 37.7324822811308 | -122.384072681809 | (37.7324822811308, -122.384072681809) | 10 | 3 | 8 | 58 | 1 | |||
| 65238 | 12119 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1325X La Salle Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/17/2007 12:00:00 AM | 3 | 3X3 | 6016848.2078526 | 2094661.9057693 | 37.7324879628386 | -122.38409435335 | (37.7324879628386, -122.38409435335) | 10 | 3 | 8 | 58 | 1 | ||
| 107375 | 10935 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1367 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/1992 12:00:00 AM | 6 | 3X4 | 6016859.3335 | 2096507.77674 | 37.7375569710748 | -122.384184391096 | (37.7375569710748, -122.384184391096) | 10 | 3 | 8 | 58 | 1 | ||
| 103523 | 52154 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1310 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/31/2005 12:00:00 AM | 4 | Permit Number 48346 | 6016795.9745 | 2093515.2841 | 37.729336678647 | -122.384195114572 | (37.729336678647, -122.384195114572) | 10 | 3 | 8 | 58 | 1 | |
| 153690 | 10936 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1373 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/1992 12:00:00 AM | 6 | 3X4 | 6016845.99905 | 2096526.32287 | 37.7376071577553 | -122.384231786279 | (37.7376071577553, -122.384231786279) | 10 | 3 | 8 | 58 | 1 | ||
| 119196 | 10938 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1385 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/09/1998 12:00:00 AM | 3 | 3X4 | 6016811.47124 | 2096565.42425 | 37.7377126131446 | -122.384353889019 | (37.7377126131446, -122.384353889019) | 10 | 3 | 8 | 58 | 1 | ||
| 120442 | 10939 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1389 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/25/1992 12:00:00 AM | 6 | 3X4 | 6016794.60487 | 2096579.57931 | 37.7377505474584 | -122.384413190341 | (37.7377505474584, -122.384413190341) | 10 | 3 | 8 | 58 | 1 | ||
| 61809 | 10947 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1400X Hudson Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/13/2004 12:00:00 AM | 3 | 3X4 | 6016738.0241541 | 2096692.24342 | 37.7380567715564 | -122.384616664641 | (37.7380567715564, -122.384616664641) | 10 | 3 | 8 | 58 | 1 | ||
| 22464 | 2497 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1500 Burke Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016766.5915 | 2098782.95362 | 37.7437990179202 | -122.384663486948 | (37.7437990179202, -122.384663486948) | 10 | 3 | 8 | 58 | 1 | |||
| 180355 | 198237 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1197 La Salle Ave | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6016682.67229 | 2094826.73479 | 37.7329313971662 | -122.384678132392 | (37.7329313971662, -122.384678132392) | 10 | 3 | 8 | 58 | 1 | |||
| 129883 | 198238 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1198 La Salle Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6016677.29479 | 2094775.77454 | 37.7327911730619 | -122.38469317535 | (37.7327911730619, -122.38469317535) | 10 | 3 | 8 | 58 | 1 | |||
| 9597 | 88675 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 601 25th St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | 10 | 3 | 8 | 58 | 1 | ||
| 24203 | 88677 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 601 25th St | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | 10 | 3 | 8 | 58 | 1 | ||
| 33295 | 88679 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 601 25th St | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | 10 | 3 | 8 | 58 | 1 | ||
| 72342 | 88680 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 601 25th St | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | 10 | 3 | 8 | 58 | 1 | ||
| 73247 | 88674 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 601 25th St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | 10 | 3 | 8 | 58 | 1 | ||
| 76093 | 88682 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 601 25th St | 23 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | 10 | 3 | 8 | 58 | 1 | ||
| 89943 | 88665 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 601 25th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | 10 | 3 | 8 | 58 | 1 | ||
| 103269 | 88684 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 601 25th St | 25 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | 10 | 3 | 8 | 58 | 1 | ||
| 103913 | 88685 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 601 25th St | 26 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | 10 | 3 | 8 | 58 | 1 | ||
| 123297 | 88678 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 601 25th St | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | 10 | 3 | 8 | 58 | 1 | ||
| 141217 | 88681 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 601 25th St | 22 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | 10 | 3 | 8 | 58 | 1 | ||
| 165921 | 88676 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 601 25th St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | 10 | 3 | 8 | 58 | 1 | ||
| 179440 | 88683 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 601 25th St | 24 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | 10 | 3 | 8 | 58 | 1 | ||
| 189450 | 88673 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 601 25th St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | 10 | 3 | 8 | 58 | 1 | ||
| 12796 | 83871 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1431 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6016609.56128 | 2096718.62341 | 37.7381221005503 | -122.385062666315 | (37.7381221005503, -122.385062666315) | 10 | 3 | 8 | 58 | 1 | |||
| 124627 | 10958 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1425X Hudson Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/19/2002 12:00:00 AM | 6 | 3X4 | 6016592.1339091 | 2096738.5714059 | 37.7381759097054 | -122.385124311518 | (37.7381759097054, -122.385124311518) | 10 | 3 | 8 | 58 | 1 | ||
| 118374 | 10961 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1431 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/19/2016 12:00:00 AM | 3 | 3X4 | 6016582.94261 | 2096736.89065 | 37.7381707862468 | -122.385155973681 | (37.7381707862468, -122.385155973681) | 10 | 3 | 8 | 58 | 1 | ||
| 125719 | 10963 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1431 Hudson Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/1998 12:00:00 AM | 3 | 3X4 | 6016563.2925523 | 2096760.0557493 | 37.7382333059102 | -122.385225528118 | (37.7382333059102, -122.385225528118) | 10 | 3 | 8 | 58 | 1 | ||
| 35166 | 153735 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1570 Burke Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/12/2016 12:00:00 AM | 17 | 3x6 | 6016600.86102 | 2098898.29719 | 37.7441065608839 | -122.385244584766 | (37.7441065608839, -122.385244584766) | 10 | 3 | 8 | 58 | 1 | ||
| 137031 | 38623 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1318 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | Permit Number 40561 | 6016425.86619725 | 2093084.23064846 | 37.7281326207796 | -122.385444597808 | (37.7281326207796, -122.385444597808) | 10 | 3 | 8 | 58 | 1 | ||
| 143949 | 200581 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2 Las Villas Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6016459.2514 | 2094891.5062 | 37.733096887881 | -122.385455075627 | (37.733096887881, -122.385455075627) | 10 | 3 | 8 | 58 | 1 | |||
| 18881 | 200582 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4 Las Villas Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6016451.0884 | 2094912.8556 | 37.733155057434 | -122.385484784854 | (37.733155057434, -122.385484784854) | 10 | 3 | 8 | 58 | 1 | |||
| 5497 | 200583 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 6 Las Villas Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6016440.4137 | 2094932.3213 | 37.7332079157453 | -122.385523046608 | (37.7332079157453, -122.385523046608) | 10 | 3 | 8 | 58 | 1 | |||
| 157710 | 2528 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1570 Burke Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/24/2017 12:00:00 AM | 3 | 3X6 | 6016517.59351 | 2098961.55525 | 37.7442756477956 | -122.38553691569 | (37.7442756477956, -122.38553691569) | 10 | 3 | 8 | 58 | 1 | ||
| 118476 | 40045 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1381 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/10/1999 12:00:00 AM | 5 | Permit Number 41282 | 6016407.968 | 2093725.2196 | 37.7298916593997 | -122.385551125915 | (37.7298916593997, -122.385551125915) | 10 | 3 | 8 | 58 | 1 | |
| 62965 | 200584 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 8 Las Villas Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6016426.5993 | 2094953.6707 | 37.7332657725871 | -122.385572294555 | (37.7332657725871, -122.385572294555) | 10 | 3 | 8 | 58 | 1 | |||
| 132693 | 200596 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 Las Villas Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6016417.1805 | 2094923.5303 | 37.7331824919173 | -122.385602758378 | (37.7331824919173, -122.385602758378) | 10 | 3 | 8 | 58 | 1 | |||
| 16771 | 12133 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1400X La Salle Ave | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/03/2015 07:34:00 AM | 3 | 3X3 | 6016420.28727 | 2095262.82518 | 37.7341142997293 | -122.385615655843 | (37.7341142997293, -122.385615655843) | 10 | 3 | 8 | 58 | 1 | ||
| 163336 | 200585 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 10 Las Villas Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6016408.3895 | 2094976.9039 | 37.7333285587394 | -122.38563687008 | (37.7333285587394, -122.38563687008) | 10 | 3 | 8 | 58 | 1 | |||
| 37773 | 12135 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1400X La Salle Ave | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/1996 12:00:00 AM | 6 | 3X3 | 6016406.76292 | 2095317.85293 | 37.7342646465796 | -122.385666248106 | (37.7342646465796, -122.385666248106) | 10 | 3 | 8 | 58 | 1 | ||
| 112419 | 200586 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 12 Las Villas Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6016390.8077 | 2095002.6488 | 37.7333982762317 | -122.385699449519 | (37.7333982762317, -122.385699449519) | 10 | 3 | 8 | 58 | 1 | |||
| 28011 | 12137 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1400X La Salle Ave | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/28/2016 09:03:00 AM | 3 | 3X3 | 6016395.84509 | 2095364.00428 | 37.7343907648187 | -122.385707210442 | (37.7343907648187, -122.385707210442) | 10 | 3 | 8 | 58 | 1 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );