8,659 rows where qSpecies_id = 11 sorted by rowid

View and edit SQL

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)
2831 67412 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 531 20th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/18/2019 12:00:00 AM 3   Permit Number 30911 5989678.19598 2111713.94895 37.7777687473825 -122.479273498656 (37.7777687473825, -122.479273498656) 11 6 2 55 26
2844 45194 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 434 Leavenworth St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/24/2001 12:00:00 AM 6   Permit Number 44039 6008463.06426 2114024.06162 37.7851848652278 -122.414453446982 (37.7851848652278, -122.414453446982) 7 10 9 28852 36
2855 201591 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 501 Donahue St 3 Sidewalk: Curb side : Cutout Tree Private 2   07/12/2017 12:00:00 AM 3 Width 4ft Permit Number 770566 6020744.06411 2093067.17806 37.7283237638216 -122.37051506831 (37.7283237638216, -122.37051506831) 10 3 8 58 1
2887 255158 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 3098 Turk St 3 Sidewalk: Curb side : Cutout Tree DPW 1   03/17/2018 12:00:00 AM 3                        
2892 52020 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1001 Pine St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/03/2008 12:00:00 AM 3 3x3 Permit Number 50061 6009007.02458 2115965.45342 37.7905460009358 -122.41270880089 (37.7905460009358, -122.41270880089) 5 1 10 28858 21
2899 32085 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 3933 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/09/1995 12:00:00 AM 14   Permit Number 35458 6003385.91589 2105339.01194 37.7610513260832 -122.431398593479 (37.7610513260832, -122.431398593479) 2 4 5 28862 3
2903 251423 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2162 Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1   06/24/2020 12:00:00 AM 3 3x3   5999946 2089791 37.7181646124566 -122.4421796072 (37.7181646124566, -122.4421796072) 9 7 6 28861 25
2919 208356 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 4998 19th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     10 Width 3ft   5990631.22914 2093445.14336 37.7276627189546 -122.474642998593 (37.7276627189546, -122.474642998593) 9 8 4 64 40
2941 261590 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 299x 14th St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006795 2107850 37.7681385292637 -122.41978620049 (37.7681385292637, -122.41978620049) 8 4 7 28853 19
2944 97145 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 2001X Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6008686.3 2106815.2 37.7654035712889 -122.413171184614 (37.7654035712889, -122.413171184614) 8 4 7 28859 19
2952 23021 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 873 Valencia St 1 Sidewalk: Curb side : Cutout Tree DPW 1     20 3X3   6006311.34363 2104526.62224 37.7589860572745 -122.42122309997 (37.7589860572745, -122.42122309997) 2 4 7 28859 19
2975 171289 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 319 Avalon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/27/2019 12:00:00 AM 3 Width 3ft   6003630.58529 2092759.63292 37.726525123318 -122.429655186657 (37.726525123318, -122.429655186657) 9 7 6 28861 5
2980 62421 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 769 14th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/17/1986 12:00:00 AM 15   Permit Number 22736 5991633.13825 2110183.5333 37.773679990211 -122.472399147235 (37.773679990211, -122.472399147235) 11 6 2 54 26
2995 202498 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 85 Townsend St 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6015682.27104 2112499.834 37.7814025909853 -122.389370531319 (37.7814025909853, -122.389370531319) 6 2 9 28856 20
2996 38797 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11   5 Sidewalk: Curb side : Cutout Tree Private 2   10/23/1998 12:00:00 AM     Permit Number 40645                    
3004 202458 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 299 Bryant St 11 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6015309.25216 2113889.9179 37.7851987588479 -122.390758179856 (37.7851987588479, -122.390758179856) 6 2 9 28856 6
3059 68742 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 3926 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/16/1993 12:00:00 AM     Permit Number 32663 6003444.16925552 2105388.01634751 37.7611891817503 -122.431200618374 (37.7611891817503, -122.431200618374) 15 4 5 28862 3
3107 227314 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 4329 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/26/2020 12:00:00 AM 3 3x3   6000917.153 2102277.61106 37.752505237738 -122.439717467211 (37.752505237738, -122.439717467211) 2 4 5 28862 22
3146 27755 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1299 Cesar Chavez St 8 Sidewalk: Curb side : Cutout Tree DPW 1   04/06/2002 12:00:00 AM 3 3X3   6015153.848397 2101092.2403929 37.7500505146893 -122.390401336874 (37.7500505146893, -122.390401336874) 10 3 8 58 1
3240 23833 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1302X Webster St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/21/2008 12:00:00 AM 3 3X3   6003750.8656173 2113176.0104319 37.7825904834742 -122.43069565207 (37.7825904834742, -122.43069565207) 7 9 11 29490 41
3244 208266 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 950x Portola Dr 4 Median : Yard Tree DPW 1     5 Width 8ft   5996189.57852 2098600.11131 37.7421375150253 -122.455800307749 (37.7421375150253, -122.455800307749) 9 7 4 59 40
3256 256623 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 162 Dorado Ter 1 Sidewalk: Curb side : Cutout Tree DPW 1   08/10/2019 02:37:00 PM 3 3x3   5994333.67195 2093080.20894 37.7268745363156 -122.461817248026 (37.7268745363156, -122.461817248026) 9 8 4 28861 40
3261 177171 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2 Hester Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   6012633.43776 2088096.17328 37.7142258700001 -122.398205432431 (37.7142258700001, -122.398205432431) 10 3 8 309 1
3274 23104 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1417 Valencia St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/29/1992 12:00:00 AM 20 3X3   6006489.94446 2101312.55607 37.7501710392837 -122.420377283985 (37.7501710392837, -122.420377283985) 2 4 7 28859 19
3397 228679 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 190 Storrie St 18 Front Yard : Yard Tree Private 2     8 Width 3ft   6000815.50706 2105314.68104 37.7608385069212 -122.440286756929 (37.7608385069212, -122.440286756929) 15 4 5 28862 3
3403 228171 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 401x Powhattan Ave 2 Sidewalk: Property side : Yard Tree Private 2     14 Width 3ft   6008190.97242 2098122.00574 37.7415062071578 -122.414269294615 (37.7415062071578, -122.414269294615) 2 7 7 28859 2
3437 79 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 899 14th St 1 Sidewalk: Curb side : Cutout Tree Private 2     26 3X3   6002864.3199934 2107660.1796498 37.7673951141913 -122.433368437593 (37.7673951141913, -122.433368437593) 15 5 5 28862 3
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
3477 259101 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 600 Visitacion Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 03/30/2019 12:00:00 AM 3                        
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
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
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
4046 43411 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 536 Liberty St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/17/2000 12:00:00 AM     Permit Number 43154 6002822.07551999 2103890.28570644 37.7570415002259 -122.433245151224 (37.7570415002259, -122.433245151224) 2 4 5 28862 3
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
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
4330 68743 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 3929 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/16/1993 12:00:00 AM     Permit Number 32664 6003434.71793969 2105335.41306872 37.761044210169 -122.431229551523 (37.761044210169, -122.431229551523) 2 4 5 28862 3
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
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
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
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
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
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
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

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);