trees
8,659 rows where qSpecies_id = 11 sorted by qCareAssistant
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3455 | 122949 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 300 09th Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5993094 | 2113125 | 37.7818409059319 | -122.467559795372 | (37.7818409059319, -122.467559795372) | 11 | 6 | 2 | 54 | 11 | |||
| 3490 | 128009 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 490 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/17/2020 02:34:00 PM | 3 | Width 3ft | 6008457.49636 | 2121430.59221 | 37.8055210575117 | -122.414997125824 | (37.8055210575117, -122.414997125824) | 3 | 1 | 10 | 308 | 23 | ||
| 3504 | 202818 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 560 Mission Bay Blvd North | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6014769.41047 | 2108724.81118 | 37.7709865710896 | -122.392264508307 | (37.7709865710896, -122.392264508307) | 14 | 3 | 9 | 310 | 20 | |||
| 3513 | 117891 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 506 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5982566.38409 | 2112290.68382 | 37.7789366773187 | -122.503918023894 | (37.7789366773187, -122.503918023894) | 11 | 6 | 2 | 55 | 26 | |||
| 3528 | 38666 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 850 Brewster St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/1998 12:00:00 AM | Permit Number 40586 | |||||||||||||
| 3564 | 29260 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 300X Portola Dr | 4 | Median : Cutout | Tree | DPW 1 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5999192.47139 | 2100264.06623 | 37.7468782156517 | -122.445536908226 | (37.7468782156517, -122.445536908226) | 2 | 7 | 5 | 63 | 22 | ||
| 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 | |||
| 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 | |||
| 3783 | 47477 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/2002 12:00:00 AM | Permit Number 45375 | ||||||||||||||
| 3797 | 260871 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 198x Eddy St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/16/2019 12:00:00 AM | 3 | 3x3 | 6009475 | 2113668 | 37.7842640010762 | -122.410927291409 | (37.7842640010762, -122.410927291409) | 14 | 10 | 9 | 28852 | 36 | ||
| 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 | |||
| 3835 | 42802 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 3700 17th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/2000 12:00:00 AM | Permit Number 42757 | 6004214.17005009 | 2106015.94399708 | 37.7629569261619 | -122.42858227503 | (37.7629569261619, -122.42858227503) | 8 | 4 | 5 | 28862 | 3 | |||
| 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 | |||
| 3879 | 260548 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1190 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/15/2018 12:00:00 AM | 3 | 3x3 | Permit Number 776221 | |||||||||||
| 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 | |||
| 3958 | 29691 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 235X Hahn St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/17/2006 12:00:00 AM | 3 | 3X3 | 6007408.6946 | 2087074.91278 | 37.7111292927788 | -122.416191939068 | (37.7111292927788, -122.416191939068) | 9 | 7 | 8 | 309 | 39 | ||
| 4118 | 60587 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1596 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/2008 12:00:00 AM | 3x3 | Permit Number 50372 | 6000129.25218727 | 2110962.46444115 | 37.7763068086663 | -122.443065816912 | (37.7763068086663, -122.443065816912) | 15 | 5 | 11 | 29492 | 16 | ||
| 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 | ||||
| 4247 | 41540 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 775X 02nd St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/20/2000 12:00:00 AM | 6 | 3x3 | Permit Number 42068 | 6015692.30699351 | 2111981.66601878 | 37.7799803743496 | -122.389299616981 | (37.7799803743496, -122.389299616981) | 6 | 2 | 9 | 28856 | 20 | |
| 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 | |||
| 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 | ||
| 4364 | 228727 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 3700 17th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6004008.60516 | 2106001.5865 | 37.7629058684239 | -122.429292229258 | (37.7629058684239, -122.429292229258) | 8 | 4 | 5 | 28862 | 3 | |||
| 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 | |||
| 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 | ||
| 4428 | 66790 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2150 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/13/2010 12:00:00 AM | 3x3 | Permit Number 53367 | 6006860.21214417 | 2118575.27175394 | 37.79759118503 | -122.420321971868 | (37.79759118503, -122.420321971868) | 5 | 9 | 10 | 28858 | 32 | ||
| 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 | ||
| 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 | ||
| 4689 | 100758 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 700X Brannan St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6012260.07583 | 2110177.24035 | 37.7748349572731 | -122.401046493351 | (37.7748349572731, -122.401046493351) | 14 | 2 | 9 | 28853 | 34 | |||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | |||||||||||||||
| 5074 | 22216 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 4250X 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2008 12:00:00 AM | 3 | 3X3 | 6015384.98643 | 2097123.18461 | 37.7391651289337 | -122.389324913037 | (37.7391651289337, -122.389324913037) | 10 | 3 | 8 | 58 | 1 | ||
| 5118 | 169123 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 210 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2019 12:00:00 AM | 3 | Width 4ft | 6009469.52117 | 2113800.26568 | 37.7846268637924 | -122.410955591431 | (37.7846268637924, -122.410955591431) | 14 | 10 | 9 | 28852 | 36 | ||
| 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 | ||
| 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 | |||
| 5351 | 108330 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 86 11TH ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007396 | 2110315 | 37.7749406737789 | -122.417882154347 | (37.7749406737789, -122.417882154347) | 8 | 2 | 9 | 28853 | 19 | ||||
| 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 | |||
| 5386 | 262533 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 2401 17th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/12/2020 12:00:00 AM | 3 | 3x3 | Permit Number 773215 | 5991046.77559 | 2098937.57906 | 37.7427676232348 | -122.473606942703 | (37.7427676232348, -122.473606942703) | 1 | 8 | 4 | 29491 | 40 | |
| 5589 | 39428 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 290 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | 3x3 | Permit Number 40930 | 6004202.2780492 | 2109746.86965534 | 37.7732004728874 | -122.428889408135 | (37.7732004728874, -122.428889408135) | 7 | 9 | 11 | 28852 | 10 | ||
| 5660 | 24445 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2251X 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/1995 12:00:00 AM | 3 | 3X3 | 6015765.11922 | 2105348.0588 | 37.7617699797552 | -122.388584545263 | (37.7617699797552, -122.388584545263) | 10 | 3 | 8 | 28856 | 29 | ||
| 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 | |||
| 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 | ||
| 5759 | 47617 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1209 Houston St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/2002 12:00:00 AM | Permit Number 45446 | |||||||||||||
| 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 | |||
| 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 | |||
| 5896 | 68729 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 8 Turquoise Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1993 12:00:00 AM | Permit Number 32645 | 5998785.51386128 | 2099959.35584866 | 37.7460183133905 | -122.446922200801 | (37.7460183133905, -122.446922200801) | 2 | 7 | 5 | 63 | 7 | |||
| 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 | |||
| 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 | ||
| 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 | |||
| 6231 | 46141 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2001 12:00:00 AM | Permit Number 44490 | ||||||||||||||
| 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 | |||||||||||||
| 6653 | 202390 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6015657.26603 | 2115099.16371 | 37.7885383750805 | -122.389638635413 | (37.7885383750805, -122.389638635413) | 6 | 2 | 9 | 28855 | 6 | |||
| 6778 | 28944 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 375 09th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/2006 12:00:00 AM | 3 | 3x3 | 6009557.68758 | 2109521.72935 | 37.7728839562701 | -122.410348361997 | (37.7728839562701, -122.410348361997) | 8 | 2 | 9 | 28853 | 34 | ||
| 6806 | 105051 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1244 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/17/2017 12:00:00 AM | 3 | Permit Number 779926 | 5999515.4 | 2108544.9 | 37.7696337718916 | -122.445015457708 | (37.7696337718916, -122.445015457708) | 15 | 5 | 11 | 29492 | 9 |
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) );