Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, PlantDate, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 89080 | 89080 | 106004 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 695X CAMPBELL AVE | unknown : Yard 19 | Tree 1 | Rec/Park 3 | 6009136.9 | 2088912.4 | 37.716271678506 | -122.41034847162202 | (37.716271678506, -122.410348471622) | ||||||
| 100855 | 100855 | 114731 | Property Tree 7 | Eucalyptus globulus :: Blue Gum 103 | 934 BRANNAN ST | Back Yard : Yard 13 | Tree 1 | Private 1 | Dept of Real Estate 9 | 10x10 | 6010724.0 | 2108745.0 | 37.7708165471861 | -122.40625919407302 | (37.7708165471861, -122.406259194073) | ||||
| 106936 | 106936 | 105441 | Private 5 | Eucalyptus globulus :: Blue Gum 103 | 425 WAWONA ST | unknown : Yard 19 | Tree 1 | Private 1 | 5991587.6 | 2097036.5 | 37.737579050883106 | -122.471598439568 | (37.7375790508831, -122.471598439568) | ||||||
| 112663 | 112663 | 114044 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 549X ARLINGTON ST | Median : Cutout 11 | Tree 1 | Private 1 | 70 | 6003400.0 | 2095634.0 | 37.734404428182295 | -122.430657330781 | (37.7344044281823, -122.430657330781) | |||||
| 6027 | 6027 | 20016 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 100 STAIRWAY48 | 0 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 10ST | ||||||||
| 896 | 896 | 251302 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1 Cashmere St | 1 | Back Yard : Yard 13 | Tree 1 | Health Dept 8 | 3x3 | 6017463.0 | 2095772.0 | 37.7355700327415 | -122.382046041696 | (37.7355700327415, -122.382046041696) | ||||
| 966 | 966 | 251417 | Private 5 | Eucalyptus globulus :: Blue Gum 103 | 418 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 3x3 | 5990003.0 | 2112517.0 | 37.779992561868504 | -122.478208632121 | (37.7799925618685, -122.478208632121) | ||||
| 2603 | 2603 | 253136 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 3059 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x5 | 5999298.0 | 2114593.0 | 37.786227889505604 | -122.446202552789 | (37.7862278895056, -122.446202552789) | ||||
| 3843 | 3843 | 253568 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 103 | 301X Sargent St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 5993018.0 | 2089140.0 | 37.7159798527116 | -122.46607925705901 | (37.7159798527116, -122.466079257059) | ||||
| 3850 | 3850 | 207785 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 290 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 09/28/2017 12:00:00 AM | 3 | Width 10ft | 5993081.87997 | 2096205.8056700001 | 37.7353845093885 | -122.46637169180299 | (37.7353845093885, -122.466371691803) | ||
| 6891 | 6891 | 7808 | Permitted Site 1 | Eucalyptus globulus :: Blue Gum 103 | 700X Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6006239.03041 | 2112534.82936 | 37.7809706070447 | -122.422042095466 | (37.7809706070447, -122.422042095466) | |||
| 8496 | 8496 | 20017 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 100 STAIRWAY48 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 10ST | ||||||||
| 9488 | 9488 | 17957 | Permitted Site 1 | Eucalyptus globulus :: Blue Gum 103 | 2500 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6001928.8852 | 2115030.4127 | 37.7875788082428 | -122.437131721785 | (37.7875788082428, -122.437131721785) | |||
| 9734 | 9734 | 173682 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 450x Raymond Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3x3 | 6008515.0 | 2088365.0 | 37.71473375007071 | -122.41245939537501 | (37.7147337500707, -122.412459395375) | |||
| 18477 | 18477 | 4843 | Permitted Site 1 | Eucalyptus globulus :: Blue Gum 103 | 146 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3X3 | 6006528.82493 | 2097534.91084 | 37.739800668952604 | -122.419974789699 | (37.7398006689526, -122.419974789699) | |||
| 20364 | 20364 | 4837 | Permitted Site 1 | Eucalyptus globulus :: Blue Gum 103 | 127 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6006404.24922 | 2097646.68025 | 37.7401005434118 | -122.420413452032 | (37.7401005434118, -122.420413452032) | |||
| 22892 | 22892 | 251144 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 103 | 200X Clarendon Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5996559.0 | 2104265.0 | 37.7577130831875 | -122.454932197022 | (37.7577130831875, -122.454932197022) | ||||
| 22896 | 22896 | 251145 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 103 | 200X Clarendon Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5996559.0 | 2104265.0 | 37.7577130831875 | -122.454932197022 | (37.7577130831875, -122.454932197022) | ||||
| 23367 | 23367 | 208982 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 320 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 45 | Width 3ft | 5993096.565780001 | 2095876.3159599998 | 37.7344806601409 | -122.46629697974501 | (37.7344806601409, -122.466296979745) | |||
| 24602 | 24602 | 208981 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 310 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 43 | Width 3ft | 5993092.40274 | 2095921.0497 | 37.7346032476459 | -122.466314622626 | (37.7346032476459, -122.466314622626) | |||
| 27200 | 27200 | 209021 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 34 Martha Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | 6000790.06178 | 2095561.6998400001 | 37.7340577017886 | -122.43967553722 | (37.7340577017886, -122.43967553722) | ||||
| 28258 | 28258 | 208938 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 66 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 28 | Width 10ft | 5991979.81471 | 2095977.19537 | 37.7346931510662 | -122.470165265142 | (37.7346931510662, -122.470165265142) | |||
| 28853 | 28853 | 209017 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 33 Martha Ave | 1 | : Yard 23 | Tree 1 | Private 1 | 25 | 6000774.79116 | 2095519.5815700002 | 37.7339411856303 | -122.43972531378401 | (37.7339411856303, -122.439725313784) | ||||
| 29038 | 29038 | 208963 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 90 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 30 | Width 6ft | 5993939.166669999 | 2096822.57013 | 37.7371274206966 | -122.463452499655 | (37.7371274206966, -122.463452499655) | |||
| 29186 | 29186 | 209002 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 115 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 36 | Width 4ft | 5994119.61861 | 2096725.9639 | 37.736872559114104 | -122.462821593742 | (37.7368725591141, -122.462821593742) | |||
| 29388 | 29388 | 207794 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 213 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | Width 10ft | 5993149.25155 | 2096563.99491 | 37.736371894833 | -122.46616478658999 | (37.736371894833, -122.46616478659) | |||
| 32381 | 32381 | 207778 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 124 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 10ft | 5993200.08857 | 2096786.31561 | 37.7369852648432 | -122.46600517310699 | (37.7369852648432, -122.466005173107) | |||
| 33664 | 33664 | 207789 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 275 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 10ft | 5993131.90761 | 2096210.54353 | 37.735400404893 | -122.46619907325199 | (37.735400404893, -122.466199073252) | |||
| 33873 | 33873 | 208955 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 630 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 35 | Width 8ft | 5993530.979180001 | 2095998.56422 | 37.7348413791301 | -122.464803955838 | (37.7348413791301, -122.464803955838) | |||
| 36584 | 36584 | 208984 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 354 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 38 | Width 3ft | 5993109.71634 | 2095669.50335 | 37.7339135629453 | -122.466236489538 | (37.7339135629453, -122.466236489538) | |||
| 36907 | 36907 | 208993 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 31 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 28 | Width 4ft | 5993535.26127 | 2097150.77507 | 37.7380053101076 | -122.46487280074899 | (37.7380053101076, -122.464872800749) | |||
| 37470 | 37470 | 176346 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 40 Teddy Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 6011228.44814 | 2087808.7969 | 37.7133584325151 | -122.40304144861 | (37.7133584325151, -122.40304144861) | ||||
| 40215 | 40215 | 207788 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 285 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | Width 10ft | 5993135.10109 | 2096167.2284099997 | 37.7352816566244 | -122.46618488553001 | (37.7352816566244, -122.46618488553) | |||
| 41418 | 41418 | 207775 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 110 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 27 | Width 10ft | 5993244.34274 | 2096906.29835 | 37.737317260394 | -122.465860883191 | (37.737317260394, -122.465860883191) | |||
| 41832 | 41832 | 208941 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 130 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 30 | Width 10ft | 5992287.573419999 | 2095984.60456 | 37.734731282309106 | -122.469101787134 | (37.7347312823091, -122.469101787134) | |||
| 43077 | 43077 | 191722 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 25th St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | 6014479.640380001 | 2101959.5389 | 37.752394509601494 | -122.392793471535 | (37.7523945096015, -122.392793471535) | ||||
| 43267 | 43267 | 121204 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 44 MacOndray Ln | 1 | Unaccepted Street : Cutout 20 | Tree 1 | Private 1 | 52 | 6008473.20212 | 2119153.5676 | 37.799269800719294 | -122.41478152415002 | (37.7992698007193, -122.41478152415) | ||||
| 43824 | 43824 | 207767 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 20 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 26 | Width 10ft | 5993205.662140001 | 2097402.75145 | 37.7386781648646 | -122.466030683288 | (37.7386781648646, -122.466030683288) | |||
| 44792 | 44792 | 208974 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 130 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | Width 6ft | 5994229.97779 | 2096604.2011400003 | 37.7365445844613 | -122.462431207033 | (37.7365445844613, -122.462431207033) | |||
| 46031 | 46031 | 207784 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 270 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | Width 10ft | 5993081.2153199995 | 2096255.53806 | 37.735521023771604 | -122.466377603044 | (37.7355210237716, -122.466377603044) | |||
| 47668 | 47668 | 208973 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 136 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 6ft | 5994259.725980001 | 2096572.0955299998 | 37.7364581434207 | -122.46232602774799 | (37.7364581434207, -122.462326027748) | |||
| 48153 | 48153 | 209013 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 412 Baden St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 20 | 6000780.48794 | 2095392.50815 | 37.7335925958074 | -122.439696511209 | (37.7335925958074, -122.439696511209) | ||||
| 48548 | 48548 | 65198 | Permitted Site 1 | Eucalyptus globulus :: Blue Gum 103 | 371 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1989 12:00:00 AM | 34 | Permit Number 27183 | 6003158.74485 | 2091706.4873099998 | 37.7236066919673 | -122.431211180179 | (37.7236066919673, -122.431211180179) | |
| 51382 | 51382 | 207780 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 250 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | Width 10ft | 5993075.61435 | 2096444.65306 | 37.7360399631594 | -122.46641070800501 | (37.7360399631594, -122.466410708005) | |||
| 52363 | 52363 | 208968 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 34 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 23 | Width 6ft | 5993576.11533 | 2097077.3704400002 | 37.737806114757795 | -122.46472622025298 | (37.7378061147578, -122.464726220253) | |||
| 52384 | 52384 | 208985 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 372 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 59 | Width 3ft | 5993126.32529 | 2095592.5648700001 | 37.7337032672843 | -122.466173478533 | (37.7337032672843, -122.466173478533) | |||
| 53478 | 53478 | 207782 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 260 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | Width 10ft | 5993076.07579 | 2096352.6988099997 | 37.7357875063795 | -122.466402431535 | (37.7357875063795, -122.466402431535) | |||
| 53855 | 53855 | 208983 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 330 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 35 | Width 3ft | 5993097.51511 | 2095800.07009 | 37.73427136274 | -122.466288158284 | (37.73427136274, -122.466288158284) | |||
| 55842 | 55842 | 207761 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 345 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 41 | Width 10ft | 5993145.033430001 | 2095739.54752 | 37.7341079244482 | -122.46611947693701 | (37.7341079244482, -122.466119476937) | |||
| 56581 | 56581 | 209009 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 408 Baden St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6000785.2821 | 2095342.6683900002 | 37.7334560202787 | -122.439676364582 | (37.7334560202787, -122.439676364582) | ||||
| 60450 | 60450 | 207766 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 14 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 32 | Width 10ft | 5993184.09693 | 2097461.91411 | 37.7388393665447 | -122.46610954301799 | (37.7388393665447, -122.466109543018) | |||
| 60463 | 60463 | 207807 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 25 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 22 | Width 10ft | 5993231.15579 | 2097483.74028 | 37.7389020106052 | -122.46594842230199 | (37.7389020106052, -122.465948422302) | |||
| 61081 | 61081 | 208914 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 45 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 38 | Width 10ft | 5991964.75621 | 2096031.6123 | 37.7348416956868 | -122.470221288386 | (37.7348416956868, -122.470221288386) | |||
| 61439 | 61439 | 208913 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 25 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 52 | Width 10ft | 5991855.18446 | 2096027.3519599999 | 37.7348236624713 | -122.470599802253 | (37.7348236624713, -122.470599802253) | |||
| 63161 | 63161 | 208994 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 21 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 29 | Width 4ft | 5993511.280230001 | 2097168.00802 | 37.7380512447772 | -122.46495696559799 | (37.7380512447772, -122.464956965598) | |||
| 63741 | 63741 | 246757 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 70 Waltham St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 27 | 6009117.20748 | 2098899.99025 | 37.7436943673943 | -122.41112161978998 | (37.7436943673943, -122.41112161979) | ||||
| 64417 | 64417 | 224250 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 425 Eugenia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 34 | Width 5ft | 6007149.05774 | 2097827.31438 | 37.740638468384795 | -122.417851002914 | (37.7406384683848, -122.417851002914) | |||
| 64951 | 64951 | 208942 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 200 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 32 | Width 10ft | 5992406.13159 | 2095989.66706 | 37.7347520323855 | -122.468692262863 | (37.7347520323855, -122.468692262863) | |||
| 65175 | 65175 | 208929 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 501 Saint Francis Blvd | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 34 | Width 6ft | 5993145.62708 | 2096072.03007 | 37.735020873007 | -122.466141577798 | (37.735020873007, -122.466141577798) | |||
| 65901 | 65901 | 208933 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 405 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 31 | Width 10ft | 5992936.60702 | 2096064.2661700002 | 37.7349874937845 | -122.466863664131 | (37.7349874937845, -122.466863664131) | |||
| 66396 | 66396 | 208966 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 44 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 44 | Width 6ft | 5993666.080159999 | 2097016.89785 | 37.7376452584166 | -122.46441078125099 | (37.7376452584166, -122.464410781251) | |||
| 67133 | 67133 | 209003 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 96 Castenada Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 43 | Width 3ft | 5994450.97172 | 2101378.39351 | 37.7496660456507 | -122.462013248027 | (37.7496660456507, -122.462013248027) | |||
| 69718 | 69718 | 208957 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 625 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 8ft | 5993588.443419999 | 2096129.23717 | 37.73520348755321 | -122.46461476908001 | (37.7352034875532, -122.46461476908) | |||
| 72305 | 72305 | 208950 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 440 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 26 | Width 10ft | 5992985.54967 | 2096006.72468 | 37.734832323836706 | -122.46669027215599 | (37.7348323238367, -122.466690272156) | |||
| 73251 | 73251 | 208996 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 11 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 29 | Width 4ft | 5993421.96829 | 2097241.5815 | 37.7382481090644 | -122.465271101502 | (37.7382481090644, -122.465271101502) | |||
| 73538 | 73538 | 207772 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 60 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | Width 10ft | 5993256.95856 | 2097201.9739 | 37.7381298392237 | -122.46583874187 | (37.7381298392237, -122.46583874187) | |||
| 74311 | 74311 | 208919 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 101 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 38 | Width 10ft | 5992247.91507 | 2096042.0705099998 | 37.734886777797996 | -122.469243079632 | (37.734886777798, -122.469243079632) | |||
| 74562 | 74562 | 209046 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 301 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 55 | Width 10ft | 5999983.24986 | 2094934.98428 | 37.732290932375605 | -122.442419949729 | (37.7322909323756, -122.442419949729) | |||
| 75055 | 75055 | 208997 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 10 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 31 | Width 4ft | 5993343.646380001 | 2097250.7379 | 37.738268733207605 | -122.465542562746 | (37.7382687332076, -122.465542562746) | |||
| 75518 | 75518 | 191738 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 920 Vermont St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 39 | 6011311.04969 | 2104026.1978700003 | 37.757892599481 | -122.40389645386699 | (37.757892599481, -122.403896453867) | ||||
| 76551 | 76551 | 224247 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 527 Powhattan Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 46 | 6008745.222630001 | 2098103.60695 | 37.74148680607821 | -122.412351580256 | (37.7414868060782, -122.412351580256) | ||||
| 76666 | 76666 | 207779 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 126 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 36 | Width 10ft | 5993175.19587 | 2096740.86685 | 37.7368590378112 | -122.46608793591001 | (37.7368590378112, -122.46608793591) | |||
| 76936 | 76936 | 208937 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 64 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 36 | Width 10ft | 5991925.34536 | 2095973.96809 | 37.734681140613105 | -122.47035334753201 | (37.7346811406131, -122.470353347532) | |||
| 76953 | 76953 | 208935 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 3 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 10ft | 5991812.79149 | 2095969.62922 | 37.7346627188958 | -122.47074216493401 | (37.7346627188958, -122.470742164934) | |||
| 77267 | 77267 | 207777 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 118 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 34 | Width 10ft | 5993220.0955300005 | 2096827.0991599998 | 37.737098400464795 | -122.465938963216 | (37.7370984004648, -122.465938963216) | |||
| 77296 | 77296 | 209024 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 36 Martha Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 32 | 6000772.29534 | 2095570.30388 | 37.7340803152378 | -122.43973757782601 | (37.7340803152378, -122.439737577826) | ||||
| 80756 | 80756 | 2614 | Landmark tree 9 | Eucalyptus globulus :: Blue Gum 103 | 1661X Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 10X10 | 6004876.92395 | 2115038.87855 | 37.787769186678204 | -122.42693268975599 | (37.7877691866782, -122.426932689756) | |||
| 89069 | 89069 | 138024 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1661 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 48 | Width 0ft | 6004873.7558 | 2115028.5137 | 37.7877405482561 | -122.42694291248002 | (37.7877405482561, -122.42694291248) | |||
| 90816 | 90816 | 119631 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 265 Fowler Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 3x5 | 5997384.0 | 2099137.0 | 37.7436801569324 | -122.451709113802 | (37.7436801569324, -122.451709113802) | |||
| 92339 | 92339 | 115295 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 103 | 500X 08TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010511.0 | 2109243.0 | 37.77217202356729 | -122.407031076357 | (37.7721720235673, -122.407031076357) | ||||
| 92343 | 92343 | 113367 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 6X Christopher Dr | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 25 | 5996701.11551 | 2103988.82524 | 37.7569629284433 | -122.454420756361 | (37.7569629284433, -122.454420756361) | ||||
| 92772 | 92772 | 114075 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 24 HIGUERA AVE | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 26 | 5987903.0 | 2090420.0 | 37.7191979850677 | -122.483852684784 | (37.7191979850677, -122.483852684784) | ||||
| 97315 | 97315 | 113859 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 456 HILL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003369.0 | 2103347.0 | 37.755580778127 | -122.431314899346 | (37.755580778127, -122.431314899346) | ||||
| 99243 | 99243 | 122535 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 199x Coso Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | 3x3 | 6007478.0 | 2099565.0 | 37.7454282725128 | -122.41683672388399 | (37.7454282725128, -122.416836723884) | |||
| 99315 | 99315 | 3751 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 990 Carolina St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 42 | 18 | 6012435.5557064 | 2103342.2152382 | 37.756077292734105 | -122.399959384248 | (37.7560772927341, -122.399959384248) | |||
| 102861 | 102861 | 112189 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 301x CORBETT AVE | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 12 | 3x3 | 5999677.0 | 2105220.0 | 37.760513648972996 | -122.444217531177 | (37.760513648973, -122.444217531177) | |||
| 103018 | 103018 | 104402 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 301 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6000011.7 | 2094912.1 | 37.7322297190532 | -122.44231994912901 | (37.7322297190532, -122.442319949129) | |||||
| 103214 | 103214 | 106173 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 103 | 267 Green St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 771881 | 6011670.8 | 2119368.7 | 37.8000396459541 | -122.403731811098 | (37.8000396459541, -122.403731811098) | ||||
| 105598 | 105598 | 106227 | Property Tree 7 | Eucalyptus globulus :: Blue Gum 103 | 38 Stanford Heights Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5997884.0 | 2095808.5 | 37.7345695210024 | -122.44974042873999 | (37.7345695210024, -122.44974042874) | |||||
| 109383 | 109383 | 106792 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 199X ARLINGTON ST | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | 6005045.0 | 2097131.0 | 37.7386079110333 | -122.425076502639 | (37.7386079110333, -122.425076502639) | ||||
| 109652 | 109652 | 113804 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 990X OSHAUGHNESSY BLVD | 1 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 3x30 | 6000025.0 | 2096199.0 | 37.735764003208 | -122.442366322687 | (37.735764003208, -122.442366322687) | ||||
| 114729 | 114729 | 96803 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 300X Melrose Ave | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 48 | 5998134.5 | 2095546.7 | 37.733865009274204 | -122.448855518806 | (37.7338650092742, -122.448855518806) | ||||
| 114900 | 114900 | 208965 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 56 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | Width 6ft | 5993745.43898 | 2096960.72106 | 37.7374955851482 | -122.464132325055 | (37.7374955851482, -122.464132325055) | |||
| 115179 | 115179 | 106275 | Property Tree 7 | Eucalyptus globulus :: Blue Gum 103 | 42 Stanford Heights Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5997882.5 | 2095834.4 | 37.7346405503947 | -122.449747480555 | (37.7346405503947, -122.449747480555) | |||||
| 116196 | 116196 | 92033 | Permitted Site 1 | Eucalyptus globulus :: Blue Gum 103 | 10 Elk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 52176 | 5999970.9 | 2097826.1 | 37.7402285519688 | -122.44267015975201 | (37.7402285519688, -122.442670159752) | |||
| 119166 | 119166 | 92897 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 103 | 208 States St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 08/13/2008 12:00:00 AM | 6000833.0 | 2106506.0 | 37.7641105715625 | -122.440311694354 | (37.7641105715625, -122.440311694354) | ||||
| 119476 | 119476 | 108200 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 90 Reuel Ct | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 774102 | 6017404.09127 | 2096025.6169900002 | 37.7362631610075 | -122.382267352258 | (37.7362631610075, -122.382267352258) | ||||
| 122561 | 122561 | 105900 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 11X ELLIOT ST | 1 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 30 | 6009059.0 | 2088845.0 | 37.716082244868005 | -122.410612975888 | (37.716082244868, -122.410612975888) | ||||
| 123394 | 123394 | 114040 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 95 LINARES AVE | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 40 | 3x3 | 5994258.0 | 2102054.0 | 37.751509977458795 | -122.462729551044 | (37.7515099774588, -122.462729551044) | |||
| 127109 | 127109 | 208991 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 45 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 28 | Width 4ft | 5993638.39674 | 2097082.374 | 37.73782344378579 | -122.46451124811199 | (37.7378234437858, -122.464511248112) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");