trees
8,659 rows where qSpecies_id = 11 sorted by qLegalStatus_id
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3570 | 228639 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 393 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6002974.70416 | 2105985.24173 | 37.7628024032403 | -122.432866963362 | (37.7628024032403, -122.432866963362) | 15 | 4 | 5 | 28862 | 3 | |||
| 3575 | 130205 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1033 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6009172.7127 | 2117683.88931 | 37.7952737045641 | -122.412257035446 | (37.7952737045641, -122.412257035446) | 3 | 1 | 10 | 28857 | 21 | |||
| 3586 | 217748 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 611 Frederick St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5996609.14457 | 2107297.9343 | 37.766043624629 | -122.45497792451 | (37.766043624629, -122.45497792451) | 15 | 5 | 11 | 29492 | 12 | |||
| 3616 | 7957 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1800 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/22/2016 03:18:00 PM | 3 | 3X3 | 6005720.43568 | 2116275.48789 | 37.7912122663809 | -122.424102272302 | (37.7912122663809, -122.424102272302) | 13 | 9 | 1 | 28858 | 27 | ||
| 3644 | 123178 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 755 10th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 9ft | 5992851.1981 | 2110319.16368 | 37.7741228178256 | -122.46819559495 | (37.7741228178256, -122.46819559495) | 11 | 6 | 2 | 54 | 11 | |||
| 3675 | 192590 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1390 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008004 | 2110521 | 37.775540499151 | -122.415793536261 | (37.775540499151, -122.415793536261) | 8 | 2 | 9 | 28853 | 34 | |||
| 3692 | 62416 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 677 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/08/1985 12:00:00 AM | 12 | Permit Number 22573 | 5991607.27791 | 2110834.1835 | 37.7754650021114 | -122.472536046895 | (37.7754650021114, -122.472536046895) | 11 | 6 | 2 | 54 | 26 | |
| 3699 | 228559 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 700 Valencia St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 7 | 3x6 | 6006186 | 2105451 | 37.7615171153003 | -122.421722254672 | (37.7615171153003, -122.421722254672) | 2 | 4 | 5 | 28859 | 19 | |||
| 3733 | 60222 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1200 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/1982 12:00:00 AM | 16 | Permit Number 19772 | 6009437.72242 | 2117453.02752 | 37.7946546814167 | -122.411323738797 | (37.7946546814167, -122.411323738797) | 3 | 1 | 10 | 28857 | 4 | |
| 3821 | 130402 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 537 Washington St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6011944.02835 | 2117720.9303 | 37.7955305266544 | -122.402670389235 | (37.7955305266544, -122.402670389235) | 3 | 1 | 10 | 28860 | 4 | |||
| 3830 | 91437 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 900X Portola Dr | 2 | Median : Cutout | Tree | DPW 1 | 02/22/2012 12:00:00 AM | 4x4 | 5996336.043197 | 2098916.600218 | 37.7430149203693 | -122.455316749086 | (37.7430149203693, -122.455316749086) | 9 | 7 | 4 | 59 | 40 | |||
| 3861 | 92129 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1119 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52490 | 6009318.00263 | 2111672.54463 | 37.7787761506237 | -122.41132943422 | (37.7787761506237, -122.41132943422) | 8 | 2 | 9 | 28853 | 34 | |
| 3868 | 259094 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 800 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/2019 12:00:00 AM | 3 | |||||||||||||
| 3877 | 228942 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 401 Division St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009177.01611 | 2108023.17078 | 37.7687479166233 | -122.411559257765 | (37.7687479166233, -122.411559257765) | 8 | 4 | 7 | 28853 | 19 | |||
| 3927 | 228050 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2095 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008750.70184 | 2106410.9206 | 37.7642971286338 | -122.412919846582 | (37.7642971286338, -122.412919846582) | 8 | 4 | 7 | 28859 | 19 | |||
| 4141 | 192575 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 218 08th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6009254.82168 | 2110652.88864 | 37.7759728720816 | -122.411475945469 | (37.7759728720816, -122.411475945469) | 8 | 2 | 9 | 28853 | 34 | |||
| 4191 | 252955 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 50 Ewing Ter | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 5998847 | 2112431 | 37.7802658347108 | -122.44760720085 | (37.7802658347108, -122.44760720085) | 15 | 6 | 2 | 54 | 16 | ||||
| 4252 | 229132 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 869 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/28/1983 12:00:00 AM | 19 | Width 3ft | Permit Number 21019 | 6007588.0617 | 2104611.24937 | 37.759290317716 | -122.416813591769 | (37.759290317716, -122.416813591769) | 2 | 4 | 7 | 28859 | 19 | |
| 4296 | 11415 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1486 Innes Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6016124.41895 | 2096811.69386 | 37.7383508053301 | -122.386746549719 | (37.7383508053301, -122.386746549719) | 10 | 3 | 8 | 58 | 1 | |||
| 4300 | 72086 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 287 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 17 | 5988351.63673 | 2114094.10602 | 37.7842268528731 | -122.484037051708 | (37.7842268528731, -122.484037051708) | 11 | 6 | 2 | 55 | 26 | |||
| 4353 | 6174 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1075 Ellis St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/11/2009 12:00:00 AM | 3 | 3X3 | 6005893.15301 | 2113273.27935 | 37.782978696051 | -122.423291166859 | (37.782978696051, -122.423291166859) | 7 | 9 | 11 | 28858 | 41 | ||
| 4357 | 76336 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2 Townsend St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6015855.31224 | 2112664.17743 | 37.7818634332888 | -122.388783363957 | (37.7818634332888, -122.388783363957) | 6 | 2 | 9 | 28856 | 6 | |||
| 4374 | 228170 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 900X Eugenia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6007791.31905 | 2097714.0061 | 37.7403634727908 | -122.415622282361 | (37.7403634727908, -122.415622282361) | 2 | 7 | 7 | 28859 | 2 | |||
| 4395 | 255228 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 300X Goettingen St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
| 4406 | 68340 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 431 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | 10 | Permit Number 32157 | 5991217.62534 | 2112456.91618 | 37.7798980198622 | -122.474002355247 | (37.7798980198622, -122.474002355247) | 11 | 6 | 2 | 54 | 26 | |
| 4409 | 60582 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1426 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/1982 12:00:00 AM | 10 | Permit Number 20198 | 6000937.5822 | 2111077.0426 | 37.7766674666338 | -122.440277805167 | (37.7766674666338, -122.440277805167) | 15 | 5 | 11 | 29492 | 41 | ||
| 4412 | 192661 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 299 Cashmere St | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6016830.36497 | 2095845.83394 | 37.735737807149 | -122.384238463729 | (37.735737807149, -122.384238463729) | 10 | 3 | 8 | 58 | 1 | |||
| 4416 | 22971 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 590 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/30/1997 12:00:00 AM | 8 | 3X3 | 6006160.16462 | 2106178.29258 | 37.763512632933 | -122.42186327248 | (37.763512632933, -122.42186327248) | 8 | 4 | 5 | 28859 | 19 | ||
| 4421 | 15304 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1650 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/10/2019 03:08:00 PM | 3 | 3X3 | 6006931.2074 | 2109169.6745 | 37.7717697147956 | -122.419408704778 | (37.7717697147956, -122.419408704778) | 8 | 2 | 9 | 28853 | 19 | ||
| 4425 | 262436 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 401X San Juan Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2019 12:00:00 AM | 3 | Width 3ft | 6000647.76831 | 2092657.8797 | 37.7260763822942 | -122.439959348864 | (37.7260763822942, -122.439959348864) | 9 | 7 | 6 | 28861 | 25 | ||
| 4482 | 73980 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 400 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | Permit Number 769778 | 6007997.42322 | 2113875.47963 | 37.7847507256189 | -122.416053899389 | (37.7847507256189, -122.416053899389) | 7 | 10 | 9 | 28858 | 36 | ||
| 4484 | 16615 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 113 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2016 12:00:00 AM | 3 | 3X3 | Permit Number 778956 | 6002889.7801 | 2107581.65027 | 37.7671809360695 | -122.433274762729 | (37.7671809360695, -122.433274762729) | 15 | 5 | 5 | 28862 | 3 | |
| 4517 | 200485 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2701 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6015936.93033 | 2102883.91485 | 37.7550134846985 | -122.387818371631 | (37.7550134846985, -122.387818371631) | 10 | 3 | 8 | 28856 | 29 | |||
| 4525 | 162657 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 187 Lee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/12/2020 09:54:00 AM | 3 | Width 0ft | 5996501.58023 | 2091123.57415 | 37.7216266438259 | -122.454181619811 | (37.7216266438259, -122.454181619811) | 9 | 8 | 6 | 28861 | 24 | ||
| 4532 | 70356 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1912 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6006535.5562 | 2117410.9094 | 37.7943758388735 | -122.421362640608 | (37.7943758388735, -122.421362640608) | 13 | 9 | 10 | 28858 | 32 | |||
| 4571 | 192526 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1064 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6009654 | 2112066 | 37.7798753251135 | -122.410194868954 | (37.7798753251135, -122.410194868954) | 14 | 2 | 9 | 28853 | 34 | |||
| 4610 | 229157 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3195 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008470.80971 | 2100938.6622 | 37.7492558360924 | -122.413500868897 | (37.7492558360924, -122.413500868897) | 2 | 4 | 7 | 28859 | 19 | |||
| 4628 | 6858 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2865X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/17/1992 12:00:00 AM | 15 | 3X3 | 5997253 | 2087738 | 37.7123737035526 | -122.451340121886 | (37.7123737035526, -122.451340121886) | 9 | 7 | 6 | 28861 | 25 | ||
| 4632 | 143126 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2055 LOMBARD ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6002559.0217 | 2119480.0502 | 37.7998321621177 | -122.435269976592 | (37.7998321621177, -122.435269976592) | 13 | 9 | 1 | 57 | 17 | |||
| 4648 | 200397 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1001x Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 8ft | 6011323 | 2110932 | 37.776855034552 | -122.404341187165 | (37.776855034552, -122.404341187165) | 14 | 2 | 9 | 28853 | 34 | |||
| 4660 | 24955 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3150 03rd St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/20/1995 12:00:00 AM | 3 | 3x2 | 6015938.87832 | 2100945.43692 | 37.7496909388885 | -122.387676394756 | (37.7496909388885, -122.387676394756) | 10 | 3 | 8 | 58 | 1 | ||
| 4667 | 75958 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2650 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6009941.91637 | 2105516.75655 | 37.7619087513959 | -122.408736667189 | (37.7619087513959, -122.408736667189) | 8 | 4 | 8 | 28859 | 19 | |||
| 4682 | 75924 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 500 Hyde St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 17 | 6007948.10688 | 2114213.26854 | 37.7856754391124 | -122.416248450599 | (37.7856754391124, -122.416248450599) | 13 | 10 | 9 | 28858 | 36 | |||
| 4691 | 179399 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 218 Congdon St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2018 11:42:00 AM | 3 | Width 3ft | 6004674.78225 | 2093970.68086 | 37.7299094637318 | -122.426131615003 | (37.7299094637318, -122.426131615003) | 9 | 7 | 6 | 28861 | 5 | ||
| 4694 | 229096 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 411X Ogden Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6008233.66043 | 2096096.60482 | 37.735947297932 | -122.413978446675 | (37.735947297932, -122.413978446675) | 2 | 7 | 7 | 28859 | 2 | |||
| 4716 | 152723 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1158 York St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2020 09:41:00 PM | 3 | 6x6 | 6009998.49348 | 2102434.18799 | 37.7534478792213 | -122.408323557305 | (37.7534478792213, -122.408323557305) | 2 | 4 | 7 | 28859 | 19 | ||
| 4756 | 80808 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1400 Tennessee St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 16 | 6015600.52909 | 2102412.11891 | 37.7536993917283 | -122.388948815828 | (37.7536993917283, -122.388948815828) | 10 | 3 | 8 | 28856 | 29 | |||
| 4816 | 21911 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2177 03rd St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/1995 12:00:00 AM | 3 | 3X3 | 6015777.76302 | 2105563.55854 | 37.7623623964337 | -122.388555857983 | (37.7623623964337, -122.388555857983) | 10 | 3 | 8 | 28856 | 29 | ||
| 4822 | 21978 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2573 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/23/2015 08:55:00 AM | 3 | 3x3 | 6015890.4711579 | 2103611.9444914 | 37.757009926228 | -122.388029843479 | (37.757009926228, -122.388029843479) | 10 | 3 | 8 | 28856 | 29 | ||
| 4834 | 255234 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 300X Goettingen St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
| 4844 | 228872 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 32 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/10/2018 12:00:00 AM | 3 | 4x7 | Permit Number 781830 | 6004066.01114 | 2108522.69035 | 37.7698314611737 | -122.429273464001 | (37.7698314611737, -122.429273464001) | 7 | 9 | 5 | 29492 | 10 | |
| 4915 | 26860 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1483 Sutter St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/07/2008 12:00:00 AM | 3 | 3X3 | 6005670.64359 | 2114807.23754 | 37.7871780057048 | -122.424170086605 | (37.7871780057048, -122.424170086605) | 13 | 9 | 1 | 28858 | 41 | ||
| 4947 | 6953 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 609 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/24/1995 12:00:00 AM | 3 | 3X3 | 6004373.4958 | 2110460.1271 | 37.7751685930556 | -122.428347988839 | (37.7751685930556, -122.428347988839) | 7 | 9 | 11 | 28852 | 10 | ||
| 4953 | 28732 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1795X Evans Ave | 22 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/20/2005 12:00:00 AM | 12 | 3X3 | 6014623.8379379 | 2099253.7018787 | 37.7449728593106 | -122.392105596748 | (37.7449728593106, -122.392105596748) | 10 | 3 | 8 | 58 | 1 | ||
| 4960 | 76355 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2 Townsend St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6015869.61058 | 2112665.8481 | 37.7818688130373 | -122.388734014567 | (37.7818688130373, -122.388734014567) | 6 | 2 | 9 | 28856 | 6 | |||
| 4968 | 228582 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3380 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007681.5536 | 2104447.74743 | 37.7588466371903 | -122.41647866898 | (37.7588466371903, -122.41647866898) | 2 | 4 | 7 | 28859 | 19 | |||
| 4975 | 251136 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1x Somerset St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/10/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779273 | 6009558 | 2094169 | 37.7307287985177 | -122.409263672815 | (37.7307287985177, -122.409263672815) | 10 | 3 | 7 | 309 | 28 | |
| 4997 | 255137 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 401X Brotherhood Way | 15 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
| 5124 | 208248 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 65 San Lorenzo Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 6ft | 5993720.3367 | 2097534.6228 | 37.739069929337 | -122.464260768027 | (37.739069929337, -122.464260768027) | 1 | 8 | 4 | 59 | 40 | |||
| 5131 | 172199 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 399 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 6003534.5249 | 2091291.61932 | 37.7224888445726 | -122.429882596429 | (37.7224888445726, -122.429882596429) | 9 | 7 | 6 | 28861 | 5 | |||
| 5137 | 22068 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2955 03rd St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/1997 12:00:00 AM | 8 | 3X3 | 6015998.15258 | 2101816.1551 | 37.7520850322075 | -122.387532157908 | (37.7520850322075, -122.387532157908) | 10 | 3 | 8 | 28856 | 1 | ||
| 5184 | 41797 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Henry Adams St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 18 | Permit Number 42199 | 6011431.47132 | 2107642.26388 | 37.7678282330246 | -122.403734417609 | (37.7678282330246, -122.403734417609) | 8 | 2 | 8 | 28853 | 20 | |
| 5214 | 264633 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1222 Egbert Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/04/2020 12:00:00 AM | 4x6 | 6015226 | 2090508 | 37.7209923441218 | -122.389412779223 | (37.7209923441218, -122.389412779223) | 10 | 3 | 8 | 58 | 1 | ||
| 5225 | 76274 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 753 Davis St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 14 | 6013063.67102 | 2119100.92888 | 37.7993821215331 | -122.398893108952 | (37.7993821215331, -122.398893108952) | 3 | 1 | 10 | 28860 | 6 | |||
| 5312 | 4705 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 940 Columbus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2017 09:01:00 PM | 3 | 3X3 | 6008689.9314 | 2120561.6575 | 37.8031482394038 | -122.414131236147 | (37.8031482394038, -122.414131236147) | 3 | 1 | 10 | 308 | 23 | ||
| 5327 | 208187 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 614 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5992619.53239 | 2105964.8476 | 37.7621536431042 | -122.468680060852 | (37.7621536431042, -122.468680060852) | 1 | 8 | 11 | 56 | 12 | |||
| 5377 | 208380 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2153 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5990986.04746 | 2100741.87447 | 37.747718234628 | -122.473948530418 | (37.747718234628, -122.473948530418) | 1 | 8 | 4 | 29491 | 40 | |||
| 5378 | 76652 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 148X Paris St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 6002965.38435 | 2092499.73249 | 37.7257738062998 | -122.43193620819 | (37.7257738062998, -122.43193620819) | 9 | 7 | 6 | 28861 | 5 | ||
| 5405 | 76328 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 753 Davis St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6013055.77037 | 2119154.19347 | 37.7995279331128 | -122.398924188599 | (37.7995279331128, -122.398924188599) | 3 | 1 | 10 | 28860 | 6 | |||
| 5686 | 129917 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 506 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6004089.66416 | 2110540.0338 | 37.7753719324971 | -122.429335525339 | (37.7753719324971, -122.429335525339) | 7 | 9 | 11 | 28852 | 10 | |||
| 5689 | 15213 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1171 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/1995 12:00:00 AM | 6 | 3X3 | 6008930.26718 | 2111302.55479 | 37.7777384921634 | -122.41264460546 | (37.7777384921634, -122.41264460546) | 8 | 2 | 9 | 28853 | 34 | ||
| 5691 | 228657 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 200 Eureka St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6001411.17707 | 2104612.02532 | 37.7589430822727 | -122.438176265734 | (37.7589430822727, -122.438176265734) | 2 | 4 | 5 | 28862 | 3 | |||
| 5699 | 62214 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 266 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/1985 12:00:00 AM | 17 | Permit Number 22337 | 5988393.1262 | 2114211.29352 | 37.7845510318996 | -122.483902110393 | (37.7845510318996, -122.483902110393) | 11 | 6 | 2 | 55 | 26 | |
| 5709 | 62987 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 139 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/1986 12:00:00 AM | 11 | Permit Number 23387 | 5989577.1157 | 2114447.52745 | 37.7852685185368 | -122.479823246943 | (37.7852685185368, -122.479823246943) | 11 | 6 | 2 | 55 | 26 | |
| 5711 | 253201 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 800 Oak St | 3 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Private | 11/02/2019 06:09:00 AM | 3 | 6x6 | 6003064 | 2109976 | 37.77376511482 | -122.432843231253 | (37.77376511482, -122.432843231253) | 15 | 5 | 11 | 29492 | 10 | |
| 5749 | 214100 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 225 Holloway Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 02:56:00 PM | 3 | Width 3ft | 5996085.5249 | 2091194.13993 | 37.7217965338776 | -122.455624901296 | (37.7217965338776, -122.455624901296) | 9 | 8 | 6 | 28861 | 24 | ||
| 5778 | 228654 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 4244 19th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6001858.18826 | 2104709.38537 | 37.7592358223878 | -122.436637263122 | (37.7592358223878, -122.436637263122) | 2 | 4 | 5 | 28862 | 3 | |||
| 5838 | 259349 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 244 Somerset St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 04/27/2019 12:00:00 AM | 3 | 6009793.70664 | 2093331.31107 | 37.7284418848055 | -122.408389730347 | (37.7284418848055, -122.408389730347) | 10 | 3 | 7 | 309 | 28 | ||
| 5858 | 191644 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 90 03rd St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6012351.37316 | 2113981.62151 | 37.7852860020951 | -122.400998036035 | (37.7852860020951, -122.400998036035) | 12 | 2 | 9 | 28853 | 6 | |||
| 5871 | 75838 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Henry Adams St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 15 | 6011420.31077 | 2107843.20731 | 37.7683793546411 | -122.403787161967 | (37.7683793546411, -122.403787161967) | 8 | 2 | 8 | 28853 | 20 | |||
| 5899 | 228878 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 317 Buchanan St | 2 | : | Tree | Private 2 | 10 | Width 4ft | 6004644.50049 | 2109700.89583 | 37.7730992602639 | -122.427356425982 | (37.7730992602639, -122.427356425982) | 7 | 9 | 11 | 28852 | 10 | |||
| 5911 | 228080 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 890 Clipper Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5999913.84424 | 2100703.76258 | 37.7481266725268 | -122.443074048252 | (37.7481266725268, -122.443074048252) | 2 | 4 | 5 | 63 | 22 | |||
| 5920 | 4544 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 66 Cleary Ct | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6004823.98553 | 2113713.43923 | 37.784126867551 | -122.427021407244 | (37.784126867551, -122.427021407244) | 13 | 9 | 11 | 28858 | 41 | |||
| 5933 | 71780 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1080 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | Permit Number 768726 | 6007445.70481 | 2115106.99549 | 37.7881011319113 | -122.418050003112 | (37.7881011319113, -122.418050003112) | 13 | 1 | 10 | 28858 | 21 | ||
| 5944 | 130091 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 740 Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6005787.47808 | 2112322.76962 | 37.780362864998 | -122.423589158734 | (37.780362864998, -122.423589158734) | 7 | 9 | 11 | 28852 | 41 | |||
| 5966 | 229069 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 134 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 5997862.26563 | 2106825.97053 | 37.7648195394167 | -122.450609621445 | (37.7648195394167, -122.450609621445) | 15 | 5 | 11 | 29492 | 9 | |||
| 6050 | 11026 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1435 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/05/2019 12:43:00 PM | 3 | 3x3 | 6007476.45198 | 2117303.69577 | 37.7941344595897 | -122.418099417266 | (37.7941344595897, -122.418099417266) | 5 | 1 | 10 | 28858 | 32 | ||
| 6075 | 15215 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1171 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/1995 12:00:00 AM | 6 | 3X3 | 6008972.05843 | 2111339.16554 | 37.7778413620341 | -122.412502623208 | (37.7778413620341, -122.412502623208) | 8 | 2 | 9 | 28853 | 34 | ||
| 6078 | 255898 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 255 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 11/12/2019 06:17:00 AM | 3 | 3x3 | 6007944 | 2113354 | 37.7833158649371 | -122.416201780533 | (37.7833158649371, -122.416201780533) | 7 | 10 | 9 | 28852 | 36 | |
| 6105 | 130370 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1401 Sansome St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6011756.98576 | 2121020.06086 | 37.8045786948161 | -122.403549821892 | (37.8045786948161, -122.403549821892) | 3 | 1 | 10 | 28860 | 6 | |||
| 6123 | 19258 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1868X Ellis St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6001940.6587 | 2112948.30853 | 37.7818625502091 | -122.436941871627 | (37.7818625502091, -122.436941871627) | 15 | 5 | 11 | 29490 | 41 | |||
| 6263 | 200452 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1000 Indiana St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6014967.99048 | 2103722.97568 | 37.7572636433306 | -122.391227918229 | (37.7572636433306, -122.391227918229) | 10 | 3 | 8 | 28856 | 29 | |||
| 6287 | 6206 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1155 Ellis St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6005354.90901 | 2113296.39872 | 37.7830117847389 | -122.425154916389 | (37.7830117847389, -122.425154916389) | 7 | 9 | 11 | 28858 | 41 | |||
| 6372 | 160064 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1000 Cayuga Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/2020 12:44:00 PM | 3 | Width 0ft | 6000438.16193 | 2090795.67407 | 37.7209512565735 | -122.440550438153 | (37.7209512565735, -122.440550438153) | 9 | 7 | 6 | 28861 | 25 | ||
| 6375 | 138396 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2445 PINE ST | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6002330.0089 | 2115035.313 | 37.7876150559957 | -122.43574426598 | (37.7876150559957, -122.43574426598) | 13 | 6 | 11 | 29490 | 27 | |||
| 6384 | 228964 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1 Woodward St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6006487.40312 | 2108404.39444 | 37.7696434318162 | -122.420889513561 | (37.7696434318162, -122.420889513561) | 8 | 4 | 7 | 28853 | 19 | |||
| 6441 | 255157 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3098 Turk St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | |||||||||||||
| 6520 | 73325 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 141 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 14 | 6008557.19392 | 2112976.99217 | 37.7823151519537 | -122.414053685727 | (37.7823151519537, -122.414053685727) | 7 | 10 | 9 | 28852 | 36 | |||
| 6568 | 62216 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 275 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/1985 12:00:00 AM | 13 | Permit Number 22339 | 5988348.59257 | 2114168.35653 | 37.7844305464846 | -122.484053030045 | (37.7844305464846, -122.484053030045) | 11 | 6 | 2 | 55 | 26 | |
| 6621 | 262544 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1146 Fitzgerald Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/18/2020 12:00:00 AM | 3x3 | 6014979 | 2090344 | 37.7205283348361 | -122.390255140049 | (37.7205283348361, -122.390255140049) | 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) );